📚 SAP Business One SDK Help

Table Name: OITL

Table Description: Inventory Transactions Log

Field Description Type Size Related Default Value Constraints
LogEntry Log Internal ID Int 11 -      
TransId Transaction ID Int 11 -      
ItemCode Item Code nVarChar 50 OITM      
ItemName Item Description nVarChar 200 -      
ManagedBy Management Method Int 11 - 4 10000044 BTN
            10000045 SRN
            4 ITM
DocEntry Document Internal ID Int 11 -      
DocLine Doc. Row Number Int 11 -      
DocType Transact. Type Int 11 - -1    
DocNum Doc. Number Int 11 -      
BaseEntry Base Document Internal ID Int 11 - -1    
BaseLine Base Document Row Number 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
ApplyEntry Applied Document Internal ID Int 11 -      
ApplyLine Applied Document Line Number Int 11 -      
ApplyType Applied Document Type Int 11 - -1    
DocDate Doc. Posting Date Date 8 -      
CardCode BP Code nVarChar 15 OCRD      
CardName BP Name nVarChar 200 -      
DocQty Doc. Quantity Num 19.6 -      
StockQty Stock Affecting Quantity Num 19.6 -      
DefinedQty SnB Defined Quantity Num 19.6 -      
StockEff Stock Effect Int 11 - 0 0 ACCUM_EMPTY
            1 ACCUM_ON_HAND
            2 ACCUM_COMMITTED
            3 ACCUM_ON_ORDER
CreateDate Creation Date Date 8 -      
LocType Location Type Int 6 -      
LocCode Location Code nVarChar 8 -      
AppDocNum Applied Document Number Int 11 -      
VersionNum Version Number nVarChar 13 -      
Transfered Year Tranfer VarChar 1 - N    
Instance INSTANCE Int 6 - 0    
SubLineNum Subrow Number Int 11 - -1    
BSubLineNo Base Subrow Number Int 11 - -1    
AppSubLine Applied Subrow Number Int 11 - -1    
ActBaseTp Actual Base Type Int 11 - -1    
ActBaseEnt Actual Base Entry Int 11 -      
ActBaseLn Actual Base Line Int 11 - -1    
ActBasSubL Actual Base Subline Int 11 - -1    
AllocateTp Allocate Document Type Int 11 - -1    
AllocatEnt Allocate Document Entry Int 11 - -1    
AllocateLn Allocate Document Line Int 11 - -1    
CreateTime Creation Time Int 6 - 0    
Key Unique Field
PRIMARY Yes LogEntry
DOC_INFO No ManagedBy
    DocType
    DocEntry
    DocLine
    SubLineNum
BASEREF No BaseType
    BaseEntry
    BaseLine
    BSubLineNo
APPLYREF No ApplyType
    ApplyEntry
    ApplyLine
    AppSubLine
TRANSID No TransId
ACTUAL_INF No ManagedBy
    ActBaseTp
    ActBaseEnt
    ActBaseLn
    ActBasSubL
ALLOC_REF No AllocateTp
    AllocatEnt
    AllocateLn
DOC_REF No DocType
    DocEntry
    DocLine
    LogEntry
ITEM_CODE No ItemCode
    LocCode
    ManagedBy
    Instance
    ApplyEntry
    ApplyType
    LogEntry