📚 SAP Business One SDK Help

Table Name: OAIM

Table Description: Archive Inventory Message

Field Description Type Size Related Default Value Constraints
MessageID Message ID Int 11 -      
DocEntry Document Number Int 11 -      
TransType Transaction Type Int 11 - -1    
DocLineNum Document Row Number Int 11 -      
Quantity Quantity in Document Num 19.6 -      
EffectQty Effective Inventory Quantity 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 -      
BaseAbsEnt Internal No. of Base Doc 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
Currency Document 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 -      
ItemCode Item Code nVarChar 50 OITM      
DocDate Document Date Date 8 -      
DocRate Document Rate Num 19.6 -      
JrnlMemo Journal Remarks nVarChar 50 -      
BaseLine Base Row Number Int 11 - -1    
CreateTime Generation Time Int 6 -      
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 Document Price Num 19.6 -      
TreeType BOM Type VarChar 1 - N N Not a BOM
            A Assembly
            S Sales
            I BOM Component Item
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    
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      
Price Price Num 19.6 -      
CIShbQty Corr. Inv. Doc. Should Be Qty Num 19.6 -      
SubLineNum Subrow Number Int 11 - -1    
PrjCode Project Code nVarChar 20 OPRJ      
UseDocPric Use Document Price VarChar 1 - N Y Yes
            N No
Location Location Int 11 OLCT      
BSubLineNo Base Subrow Number Int 11 - -1    
AppSubLine Applied Subrow Number Int 11 - -1    
DocAction Document Action Type Int 11 -      
Key Unique Field
PRIMARY Yes MessageID