biuan SAP® BUSINESS ONE SDK
SQL Others / Serial Numbers and Batch Valuation Log
API UBVL
UBVL - Serial Numbers and Batch Valuation Log Table

SBO SQL database table details

FieldDescriptionTypeConstraintsSizeRelatedDefaultPrimary_KeyUnique
AbsEntry KEY UNIQUEInternal NumberInt
11
PRIMARYYes
DocEntryDoc. Abs. EntryInt
11
DocLineNumDoc. Line NumberInt
11
DocTypeTransact. TypeInt
11
-1
BaseTypeBase Document TypeInt
-1)
0
13) A/R Invoice
15) Delivery
16) Returns
17) Sales Order
18) A/P Invoice
20) Goods Receipt PO
21) Goods Return
22) Purchase Order
23) Sales Quotation
59) Goods Receipt
67) Inventory Transfer
69) Landed Costs
163) A/P Correction Invoice
164) A/P Correction Invoice Reversal
165) A/R Correction Invoice
166) A/R Correction Invoice Reversal
202) Production Order
203) A/R Down Payment
204) A/P Down Payment
11
-1
ActionTypeAction TypeInt
0
1) TRANSACTION_IN
2) TRANSACTION_OUT
3) TRANSACTION_SET
4) TRANSACTION_COMPLETE
5) EMPTY_TRANSACTION
6) TRANSACTION_REVALUATION
7) TRANSACTION_REVALUATION_INCREASE
8) TRANSACTION_REVALUATION_DECREASE
9) TRANSACTION_CLOSE_IN
10) TRANSACTION_CLOSE_OUT
11) TRANSACTION_NEGATIVE_REVALUATION
12) TRANSACTION_NULLIFY
13) TRANSACTION_RESERVE_CI_IN
14) TRANSACTION_RESERVE_CI_OUT
15) TRANSACTION_RESERVE_CI_REVAL_INC
16) TRANSACTION_RESERVE_CI_REVAL_DEC
17) TRANSACTION_REVAL_PRICE_CHANGE_INCREASE
18) TRANSACTION_REVAL_PRICE_CHANGE_DECREASE
11
5
AccumTypeAccumulator TypeInt
0
1) ACCUM_ON_HAND
2) ACCUM_COMMITTED
3) ACCUM_ON_ORDER
4) ACCUM_CONSIGNATION
5) ACCUM_COUNTED
11
0
ManagedByManaged ByInt
10000044) Batch Numbers
10000045) Serial Numbers
11
-1
CreateDateGeneration DateDate
8
CreateTimeGeneration TimeInt
6
ItemCodeItem No.nVarChar
20
SysNumberSystem NumberInt
11
DistNumberBatch NumbernVarChar
36
MdAbsEntryMD Abs. EntryInt
11
TrValApplyApply Transaction ValueVarChar
Y) Yes
N) No
1
Y
TransValueTransaction ValueNum
20
InvValueInventory ValueNum
20
CogsValueCogs ValueNum
20
QuantityQuantityNum
20
OverlapQtyOverlap QuantityNum
20
CogsQtyCogs QuantityNum
20
CalcPriceCalculated PriceNum
20
PriceDiffPrice DifferenceNum
20
InvDiffInventory DifferenceNum
20
BalanceBatch BalanceNum
20
AccTotalTotal AccumulatorNum
20
AccQtyQuantity-Out AccumulatorNum
20
AccNegQQuantity-In AccumulatorNum
20
ILMEntryILM EntryInt
11
ITLEntryITL EntryInt
11
CostQtyCost QuantityNum
20
CostCostNum
20
BaseDocEnBase Doc. Abs. EntryInt
11
BaseLnNumBase Doc. Line NumberInt
11
DeltaAccTDelta Total AccumulatorNum
20

SELECT statement

SELECT UBVL.AbsEntry AS 'Internal Number', UBVL.DocEntry AS 'Doc. Abs. Entry', UBVL.DocLineNum AS 'Doc. Line Number', UBVL.DocType AS 'Transact. Type', UBVL.BaseType AS 'Base Document Type', UBVL.ActionType AS 'Action Type', UBVL.AccumType AS 'Accumulator Type', UBVL.ManagedBy AS 'Managed By', UBVL.CreateDate AS 'Generation Date', UBVL.CreateTime AS 'Generation Time', UBVL.ItemCode AS 'Item No.', UBVL.SysNumber AS 'System Number', UBVL.DistNumber AS 'Batch Number', UBVL.MdAbsEntry AS 'MD Abs. Entry', UBVL.TrValApply AS 'Apply Transaction Value', UBVL.TransValue AS 'Transaction Value', UBVL.InvValue AS 'Inventory Value', UBVL.CogsValue AS 'Cogs Value', UBVL.Quantity AS 'Quantity', UBVL.OverlapQty AS 'Overlap Quantity', UBVL.CogsQty AS 'Cogs Quantity', UBVL.CalcPrice AS 'Calculated Price', UBVL.PriceDiff AS 'Price Difference', UBVL.InvDiff AS 'Inventory Difference', UBVL.Balance AS 'Batch Balance', UBVL.AccTotal AS 'Total Accumulator', UBVL.AccQty AS 'Quantity-Out Accumulator', UBVL.AccNegQ AS 'Quantity-In Accumulator', UBVL.ILMEntry AS 'ILM Entry', UBVL.ITLEntry AS 'ITL Entry', UBVL.CostQty AS 'Cost Quantity', UBVL.Cost AS 'Cost', UBVL.BaseDocEn AS 'Base Doc. Abs. Entry', UBVL.BaseLnNum AS 'Base Doc. Line Number', UBVL.DeltaAccT AS 'Delta Total Accumulator' FROM UBVL AS UBVL

Related information
SAP® Business One is the trademark(s) or registered trademark(s) of SAP AG in Germany and in several other countries. Contact
This website is not affiliated with, maintained, authorized, endorsed or sponsored by SAP AG or any of its affiliates