📚 SAP Business One SDK Help

Table Name: UILM

Table Description: IVI Inventory Log Message

Field Description Type Size Related Default Value Constraints
MessageID Message ID Int 11 -      
DocEntry Doc Number Int 11 -      
TransType Transaction Type Int 11 - -1    
DocLineNum Doc Row Number Int 11 -      
Quantity Quantity in Doc Num 19.6 -      
EffectQty Stock Effective Qty Num 19.6 -      
LocType Location Type Int 6 -      
LocCode Location Code nVarChar 8 -      
TotalLC Inventory Total LC Num 19.6 -      
TotalFC Inventory Total FC Num 19.6 -      
TotalSC Inventory Total SC Num 19.6 -      
BaseAbsEnt Internal ID of Base Document Int 11 -      
BaseType Base Transaction 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
BaseCurr Base Currency nVarChar 3 -      
Currency Doc Currency nVarChar 3 OCRN      
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
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
ExpensesLC Expenses (LC) Num 19.6 -      
ExpensesFC Expenses (FC) Num 19.6 -      
ExpensesSC Expenses (SC) Num 19.6 -      
DocDueDate Doc. Due Date Date 8 -      
ItemCode Item Code nVarChar 50 OITM      
BPCardCode Business Partner Code nVarChar 15 OCRD      
DocDate Doc Date Date 8 -      
DocRate Doc. Rate Num 19.6 -      
Comment Comment nVarChar 254 -      
JrnlMemo Journal Remarks nVarChar 50 -      
Ref1 Reference 1 nVarChar 11 -      
Ref2 Reference 2 nVarChar 100 -      
BaseLine Base Row Number Int 11 - -1    
SnBType Serials and Batches Type Int 11 - -1 0 Batch Numbers Management
            1 Serial Number Management
CreateTime Generation Time Int 6 -      
DataSource Data Source VarChar 1 - N N Unknown
            I Interface
            U Update
            M Import
            O DI API
            S Service Layer
            W Web Client
            A Doc. Generation Wizard
            D Restore Wizard
            P Partner Implementation
            T Year Transfer
CreateDate Creation Date Date 8 -      
OcrCode Distribution Rule nVarChar 8 OOCR      
OcrCode2 Distribution Rule2 nVarChar 8 OOCR      
OcrCode3 Distribution Rule3 nVarChar 8 OOCR      
OcrCode4 Distribution Rule4 nVarChar 8 OOCR      
OcrCode5 Distribution Rule5 nVarChar 8 OOCR      
DocPrice Doc Price Num 19.6 -      
CardName BP Name nVarChar 200 -      
Dscription Item Description nVarChar 200 -      
TreeType BOM Type VarChar 1 - N N Not a BOM
            A Assembly
            S Sales
            I BOM Component Item
            P Production
            T Template
ApplObj Applied Object Int 11 - -1    
AppObjAbs Applied Object Internal ID Int 11 - -1    
AppObjType Applied Object Type VarChar 1 -      
AppObjLine Applied Object Row Int 11 - -1    
BASE_REF Base Reference nVarChar 11 -      
TransSeqRf Transaction Sequence Ref Int 11 - -1    
LayerIDRef Layer ID Reference Int 11 - -1    
VersionNum Version Number nVarChar 13 -      
PriceRate Price Rate Num 19.6 -      
PriceCurr Price Currency nVarChar 3 OCRN      
DocTotal Document Total Num 19.6 -      
Price Price Num 19.6 -      
CIShbQty Corr. Inv. Doc. Should Be Qty Num 19.6 -      
SubLineNum Sub Line Number Int 11 - -1    
PrjCode Project code nVarChar 20 OPRJ      
SlpCode Sales Employee Int 11 OSLP -1    
TaxDate Document Date Date 8 -      
UseDocPric Use Document Price VarChar 1 - N Y Yes
            N No
VendorNum Vendor Catalog No. nVarChar 50 -      
SerialNum Serial Number nVarChar 17 -      
BlockNum Block Number nVarChar 100 -      
ImportLog Import Log nVarChar 20 -      
Location Location Int 11 OLCT      
DocPrcRate Document Price Rate Num 19.6 -      
DocPrcCurr Document Price Currency nVarChar 3 OCRN      
CgsOcrCod COGS Distribution Rule nVarChar 8 OOCR      
CgsOcrCod2 COGS Distribution Rule 2 nVarChar 8 OOCR      
CgsOcrCod3 COGS Distribution Rule 3 nVarChar 8 OOCR      
CgsOcrCod4 COGS Distribution Rule 4 nVarChar 8 OOCR      
CgsOcrCod5 COGS Distribution Rule 5 nVarChar 8 OOCR      
BSubLineNo Base Subrow Number Int 11 - -1    
AppSubLine Applied Subrow Number Int 11 - -1    
UserSign User Signature Int 6 OUSR      
SysRate System Rate Num 19.6 -      
ExFromRpt Exclude from Report VarChar 1 - N Y Yes
            N No
Ref3 Reference 3 nVarChar 100 -      
EnSetCost Enable Set Item Cost in Return VarChar 1 - N Y Yes
            N No
RetCost Return Cost in A/R Return Num 19.6 -      
DocAction Document Action Type Int 11 -      
UseShpdGd Use Shipped Goods Account VarChar 1 - N N No
            Y Yes
AddTotalLC Additional Total LC Num 19.6 -      
AddExpLC Additional Expenses LC Num 19.6 -      
IsNegLnQty Negative Line Quantity VarChar 1 - N    
StgSeqNum Stage Sequence Number Int 11 -      
StgEntry Stage Entry Int 11 -      
StgDesc Stage Description nVarChar 100 -      
Key Unique Field
PRIMARY Yes MessageID
CARD No BPCardCode
DocLine No TransType
    DocEntry
    DocLineNum
    SubLineNum
APPOBJ No ApplObj
    AppObjAbs
    AppObjType
    AppObjLine
BASEOBJ No BaseType
    BaseAbsEnt
    BaseLine
    BSubLineNo
EntryType No DocEntry
    TransType
    MessageID