📚 SAP Business One SDK Help

Table Name: UBVL

Table Description: Serial Numbers and Batch Valuation Log

Field Description Type Size Related Default Value Constraints
AbsEntry Internal Number Int 11 -      
DocEntry Doc. Abs. Entry Int 11 -      
DocLineNum Doc. Line Number Int 11 -      
DocType Transact. Type Int 11 - -1    
BaseType Base Document Type Int 11 - -1 -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
ActionType Action Type Int 11 - 5 0 TRANSACTION_UNKNOWN
            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
AccumType Accumulator Type Int 11 - 0 0 ACCUM_EMPTY
            1 ACCUM_ON_HAND
            2 ACCUM_COMMITTED
            3 ACCUM_ON_ORDER
            4 ACCUM_CONSIGNATION
            5 ACCUM_COUNTED
ManagedBy Managed By Int 11 - -1 10000044 Batch Numbers
            10000045 Serial Numbers
CreateDate Generation Date Date 8 -      
CreateTime Generation Time Int 6 -      
ItemCode Item No. nVarChar 50 -      
SysNumber System Number Int 11 -      
DistNumber Batch Number nVarChar 36 -      
MdAbsEntry MD Abs. Entry Int 11 -      
TrValApply Apply Transaction Value VarChar 1 - Y Y Yes
            N No
TransValue Transaction Value Num 19.6 -      
InvValue Inventory Value Num 19.6 -      
CogsValue Cogs Value Num 19.6 -      
Quantity Quantity Num 19.6 -      
OverlapQty Overlap Quantity Num 19.6 -      
CogsQty Cogs Quantity Num 19.6 -      
CalcPrice Calculated Price Num 19.6 -      
PriceDiff Price Difference Num 19.6 -      
InvDiff Inventory Difference Num 19.6 -      
Balance Batch Balance Num 19.6 -      
AccTotal Total Accumulator Num 19.6 -      
AccQty Quantity-Out Accumulator Num 19.6 -      
AccNegQ Quantity-In Accumulator Num 19.6 -      
ILMEntry ILM Entry Int 11 -      
ITLEntry ITL Entry Int 11 -      
CostQty Cost Quantity Num 19.6 -      
Cost Cost Num 19.6 -      
BaseDocEn Base Doc. Abs. Entry Int 11 -      
BaseLnNum Base Doc. Line Number Int 11 -      
DeltaAccT Delta Total Accumulator Num 19.6 -      
RowAction Row Action Type Int 11 -   0 TRANSACTION_UNKNOWN
            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
Key Unique Field
PRIMARY Yes AbsEntry