📚 SAP Business One SDK Help

Table Name: OIVL

Table Description: Whse Journal

Field Description Type Size Related Default Value Constraints
TransType Transaction Type Int 11 - -1 15 Delivery
            16 Returns
            13 A/R Invoice
            14 A/R Credit Memo
            132 Correction Invoice
            20 Goods Receipt
            21 Goods Return
            18 A/P Invoice
            19 A/P Credit Memo
            -2 Opening Balance
            58 Inventory Update
            59 Goods Receipt
            60 Goods Issue
            67 Inventory Transfer
            68 Work Instructions
            -1 All Transactions
            162 Inventory Revaluation
            69 Landed Costs
            310000001 Initial Quantity
            10000071 Inventory Posting
CreatedBy Document Key Created Int 11 -      
BASE_REF Base Reference nVarChar 11 -      
DocLineNum Row Number in Document Int 11 -      
DocDate Posting Date Date 8 -      
CreateTime Generation Time Int 6 -      
ItemCode Item No. nVarChar 50 OITM      
InQty Receipt Quantity Num 19.6 -      
OutQty Issue Quantity Num 19.6 -      
Price Price Num 19.6 -      
Currency Price Currency nVarChar 3 -      
Rate Currency Price Num 19.6 -      
TrnsfrAct Transfer Account nVarChar 15 OACT      
PriceDifAc Price Difference Account nVarChar 15 OACT      
VarianceAc Variance Account nVarChar 15 OACT      
ReturnAct Returning Account nVarChar 15 OACT      
ExcRateAct Exchange Rate Differences Acct nVarChar 15 OACT      
ClearAct Goods Clearing Account nVarChar 15 OACT      
CostAct COGS Account nVarChar 15 OACT      
WipAct WIP Inventory Account nVarChar 15 OACT      
OpenStock Open Sum Inventory Value Num 19.6 -      
CreateDate Creation Date Date 8 -      
PriceDiff Price Difference Value Num 19.6 -      
TransSeq Transaction Sequence No. Int 11 - 0    
InvntAct Inventory Account nVarChar 15 OACT      
SubLineNum Subrow Number Int 11 - -1    
AppObjLine Applied Object Line Int 11 - -1    
Expenses Inventory Expenses Num 19.6 -      
OpenExp Open Expenses Value Num 19.6 -      
Allocation Allocation Amount Num 19.6 -      
OpenAlloc Open Allocation Value Num 19.6 -      
ExpAlloc Expenses Allocation Value Num 19.6 -      
OExpAlloc Open Expenses Allocation Value Num 19.6 -      
OpenPDiff Open Price Diff. Value Num 19.6 -      
ExchDiff Exchange Rate Difference Value Num 19.6 -      
OpenEDiff Open Exchange Rate Diff. Value Num 19.6 -      
NegInvAdjs Negative Inventory Adjustment Value Num 19.6 -      
OpenNegInv Open Negative Adjustment Num 19.6 -      
NegStckAct Negative Inventory Adj. Acct nVarChar 15 OACT      
BTransVal Base Transaction Value Num 19.6 -      
VarVal Variance Value Num 19.6 -      
BExpVal Base Freight Value Num 19.6 -      
CogsVal COGS Value Num 19.6 -      
BNegAVal Base Negative Adjustment Amt Num 19.6 -      
IOffIncAcc Inventory Offset Increase Acct nVarChar 15 OACT      
IOffIncVal Inv. Offset Increase Value Num 19.6 -      
DOffDecAcc Inventory Offset Decrease Acct nVarChar 15 OACT      
DOffDecVal Inv. Offset Decrease Value Num 19.6 -      
DecAcc G/L Decrease Account nVarChar 15 OACT      
DecVal G/L Decrease Value Num 19.6 -      
WipVal WIP Inventory Value Num 19.6 -      
WipVarAcc WIP Variance Account nVarChar 15 OACT      
WipVarVal WIP Variance Value Num 19.6 -      
IncAct G/L Increase Account nVarChar 15 -      
IncVal G/L Increase Value Num 19.6 -      
ExpCAcc Expense Clearing Account nVarChar 15 OACT      
CostMethod Costing Method VarChar 1 - N A Moving Average
            S Standard
            F FIFO
            B Serial/Batch
            N None
MessageID Message ID Int 11 OILM      
LocType Location Type Int 11 -      
LocCode Warehouse Code nVarChar 8 -      
UserSign User Signature Int 6 OUSR      
DataSource Data Source VarChar 1 - N N Unknown
            I Interface
            U Upgrade
            M Import
            O DI API
            S Service Layer
            W Web Client
            A Auto Summary
            D Restore Wizard
            P Partner Implementation
            Y Year Transfer
PostStatus Posting Status VarChar 1 - N N None
            P Partial
            C Complete
SumStock Sum Stock Value Num 19.6 -      
OpenCogs Open COGS Value Num 19.6 -      
OpenQty Open Quantity Num 19.6 -      
TreeID Tree ID Int 11 - -1    
ParentID Parent ID Int 11 - -1    
PAOffAcc Purchase Offset Account nVarChar 15 OACT      
PAOffVal Purchase Offset Value Num 19.6 -      
OpenPAOff Open Purchase Offset Value Num 19.6 -      
PAAcc Purchase Account nVarChar 15 OACT      
PAVal Purchase Account Value Num 19.6 -      
OpenPA Open Purchase Value Num 19.6 -      
LinkArc Linked To Archived Doc VarChar 1 - N N No
            Y Yes
VersionNum Version Number nVarChar 13 -      
BSubLineNo Base Subrow Number Int 11 - -1    
WipDebCred WIP Account: Debit/Credit Side VarChar 1 -      
Key Unique Field
PRIMARY Yes TransSeq
ITEM No ItemCode
CURRENCY No Currency
DOCDATE No DocDate
DOCENTRY No CreatedBy
    TransType
    DocLineNum
MESSAGEID No MessageID
TREEID No TreeID