📚 SAP Business One SDK Help

Table Name: IQR1

Table Description: Inventory Posting - Rows

Field Description Type Size Related Default Value Constraints
DocEntry Document Internal ID Int 11 -      
DocLineNum Row Number in Document Int 11 -      
ItemCode Item No. nVarChar 50 OITM      
ItemName Item Description nVarChar 200 -      
InvntryUom Inventory UoM nVarChar 100 -      
OnHandBef Quantity Stored in Warehouse Num 19.6 -      
Price Price Num 19.6 -      
Quantity Variance Num 19.6 -      
Currency Price Currency nVarChar 3 -      
Rate Currency Price Num 19.6 -      
IOffIncAcc Inventory Offset Increase Acct nVarChar 15 OACT      
DOffDecAcc Inventory Offset Decrease Acct nVarChar 15 OACT      
OcrCode Distribution Rule nVarChar 8 OOCR      
WhsCode Warehouse Code nVarChar 8 OWHS      
DocTotal Document Total Num 19.6 -      
DocTotalFC Document Total (FC) Num 19.6 -      
DocTotalSy Document Total (SC) Num 19.6 -      
OcrCode2 Distribution Rule2 nVarChar 8 OOCR      
OcrCode3 Distribution Rule3 nVarChar 8 OOCR      
OcrCode4 Distribution Rule4 nVarChar 8 OOCR      
OcrCode5 Distribution Rule5 nVarChar 8 OOCR      
ObjType Object Type nVarChar 20 - 10000071    
Project Project Code nVarChar 20 OPRJ      
BarCode Bar Code nVarChar 254 -      
InvUoM Inventory UoM VarChar 1 - Y Y Yes
            N No
BinEntry Bin Location Entry Int 11 OBIN      
FirmCode Manufacturer Int 6 OMRC      
SuppCatNum Mfr Catalog No. nVarChar 50 -      
CardCode Preferred Vendor nVarChar 15 OCRD      
CountDate Count Date Date 8 -      
CountTime Count Time Int 11 -      
DiffPercnt Percentage Difference Num 19.6 -      
BaseRef Base Document Reference nVarChar 16 -      
BaseType Base Document Type Int 11 - 1470000065 -1  
            1470000065 Inventory Counting
BaseEntry Base Document Internal ID Int 11 -      
BaseLine Base Row Int 11 -      
CountQty Counted Quantity Num 19.6 -      
Remark Remarks nVarChar 254 -      
LogInstanc Log Instance - History Int 11 -      
CpyCount Copied Count Int 11 - 0 0  
            1 Inventory Taker One
            2 Two Takers - Taker 1
            3 Two Takers - Taker 2
            4 Two Takers - Items with Zero Difference
BinNegQty Allow Bin Negative Quantity VarChar 1 - N Y Yes
            N No
VisOrder Visual Order Int 11 -      
UgpEntry UoM Group Entry Int 11 OUGP      
IUomEntry Inventory UoM Entry nVarChar 20 OUOM      
UomCode UoM Code for DI nVarChar 20 OUOM      
ItmsPerUnt Items per Unit for DI Num 19.6 -      
UomQty UoM Counted Qty for DI Num 19.6 -      
ActPrice Actual Price Num 19.6 -      
PostValueL Posted Value LC Num 19.6 -      
PostValueS Posted Value SC Num 19.6 -      
PPTaxExRe Plastic Packaging Tax Exemption Reason nVarChar 2 -      
PlPaWght Plastic Packaging Weight Num 19.6 -      
UomNum Uom Item Per Unit Numerator Num 19.6 -      
UomDen Uom Item Per Unit Denominator Num 19.6 -      
Key Unique Field
PRIMARY Yes DocEntry
    DocLineNum
ITEM_CODE No ItemCode