biuan SAP® BUSINESS ONE SDK
API Inventory Posting Lines / Inventory Posting Line
IQR1 - Inventory Posting - Rows Table

SBO SQL database table details

FieldDescriptionTypeConstraintsSizeRelatedDefaultPrimary_KeyUnique
DocEntry KEY UNIQUEDocument Internal IDInt
11
PRIMARYYes
DocLineNumRow Number in DocumentInt
11
ItemCode KEYItem No.nVarChar
20OITM
Items
ITEM_CODENo
ItemNameItem DescriptionnVarChar
100
InvntryUomInventory UoMnVarChar
100
OnHandBefQuantity Stored in WarehouseNum
20
PricePriceNum
20
QuantityQuantity - DeltaNum
20
CurrencyPrice CurrencynVarChar
3
RateCurrency PriceNum
20
IOffIncAccInventory Offset Increase AcctnVarChar
15OACT
G/L Accounts
DOffDecAccInventory Offset Decrease AcctnVarChar
15OACT
G/L Accounts
OcrCodeDistribution RulenVarChar
8OOCR
Distribution Rule
WhsCodeWarehouse CodenVarChar
8OWHS
Warehouses
DocTotalDocument TotalNum
20
DocTotalFCDocument Total (FC)Num
20
DocTotalSyDocument Total (SC)Num
20
OcrCode2Distribution Rule2nVarChar
8OOCR
Distribution Rule
OcrCode3Distribution Rule3nVarChar
8OOCR
Distribution Rule
OcrCode4Distribution Rule4nVarChar
8OOCR
Distribution Rule
OcrCode5Distribution Rule5nVarChar
8OOCR
Distribution Rule
ObjTypeObject TypenVarChar
20
10000071
ProjectProject CodenVarChar
20OPRJ
Project Codes
BarCodeBar CodenVarChar
127
InvUoMInventory UoMVarChar
Y) Yes
N) No
1
Y
BinEntryBin Location EntryInt
11OBIN
Bin Location
FirmCodeManufacturerInt
6OMRC
Manufacturers
SuppCatNumMfr Catalog No.nVarChar
17
CardCodePreferred VendornVarChar
15OCRD
Business Partner
CountDateCount DateDate
8
CountTimeCount TimeInt
11
DiffPercntPercentage DifferenceNum
20
BaseRefBase Document ReferencenVarChar
16
BaseTypeBase Document TypeInt
-1)
1470000065) Inventory Counting
11
1470000065
BaseEntryBase Document Internal IDInt
11
BaseLineBase RowInt
11
CountQtyCounted QuantityNum
20
RemarkRemarksnVarChar
127
LogInstancLog Instance - HistoryInt
11
CpyCountCopied CountInt
0
1) Inventory Taker One
2) Two Takers - Taker 1
3) Two Takers - Taker 2
4) Two Takers - Items with Zero Difference
11
0
BinNegQtyAllow Bin Negative QuantityVarChar
Y) Yes
N) No
1
N
VisOrderVisual OrderInt
11
UgpEntryUoM Group EntryInt
11OUGP
UoM Group
IUomEntryInventory UoM EntrynVarChar
20OUOM
UoM Master Data
UomCodeUoM Code for DInVarChar
20OUOM
UoM Master Data
ItmsPerUntItems per Unit for DINum
20
UomQtyUoM Counted Qty for DINum
20
ActPriceActual PriceNum
20
PostValueLPosted Value LCNum
20
PostValueSPosted Value SCNum
20

Table relationship map

SELECT statement

SELECT IQR1.DocEntry AS 'Document Internal ID', IQR1.DocLineNum AS 'Row Number in Document', IQR1.ItemCode AS 'Item No.', IQR1.ItemName AS 'Item Description', IQR1.InvntryUom AS 'Inventory UoM', IQR1.OnHandBef AS 'Quantity Stored in Warehouse', IQR1.Price AS 'Price', IQR1.Quantity AS 'Quantity - Delta', IQR1.Currency AS 'Price Currency', IQR1.Rate AS 'Currency Price', IQR1.IOffIncAcc AS 'Inventory Offset Increase Acct', IQR1.DOffDecAcc AS 'Inventory Offset Decrease Acct', IQR1.OcrCode AS 'Distribution Rule', IQR1.WhsCode AS 'Warehouse Code', IQR1.DocTotal AS 'Document Total', IQR1.DocTotalFC AS 'Document Total (FC)', IQR1.DocTotalSy AS 'Document Total (SC)', IQR1.OcrCode2 AS 'Distribution Rule2', IQR1.OcrCode3 AS 'Distribution Rule3', IQR1.OcrCode4 AS 'Distribution Rule4', IQR1.OcrCode5 AS 'Distribution Rule5', IQR1.ObjType AS 'Object Type', IQR1.Project AS 'Project Code', IQR1.BarCode AS 'Bar Code', IQR1.InvUoM AS 'Inventory UoM', IQR1.BinEntry AS 'Bin Location Entry', IQR1.FirmCode AS 'Manufacturer', IQR1.SuppCatNum AS 'Mfr Catalog No.', IQR1.CardCode AS 'Preferred Vendor', IQR1.CountDate AS 'Count Date', IQR1.CountTime AS 'Count Time', IQR1.DiffPercnt AS 'Percentage Difference', IQR1.BaseRef AS 'Base Document Reference', IQR1.BaseType AS 'Base Document Type', IQR1.BaseEntry AS 'Base Document Internal ID', IQR1.BaseLine AS 'Base Row', IQR1.CountQty AS 'Counted Quantity', IQR1.Remark AS 'Remarks', IQR1.LogInstanc AS 'Log Instance - History', IQR1.CpyCount AS 'Copied Count', IQR1.BinNegQty AS 'Allow Bin Negative Quantity', IQR1.VisOrder AS 'Visual Order', IQR1.UgpEntry AS 'UoM Group Entry', IQR1.IUomEntry AS 'Inventory UoM Entry', IQR1.UomCode AS 'UoM Code for DI', IQR1.ItmsPerUnt AS 'Items per Unit for DI', IQR1.UomQty AS 'UoM Counted Qty for DI', IQR1.ActPrice AS 'Actual Price', IQR1.PostValueL AS 'Posted Value LC', IQR1.PostValueS AS 'Posted Value SC' FROM IQR1 AS IQR1

Related information


Inventory Posting Line InventoryPostingLine Object· Table: IQR1
InventoryPostingLine is a child object of the InventoryPosting object and represents the line entries of the inventory posting transaction. Source table: IQR1.   INC1V table is a virtual table to store the line data for inventory counting...
   Parent: Inventory Posting Lines InventoryPostingLines Collection
Bin Location OBIN SQL Table

Business Partner OCRD SQL Table

G/L Accounts OACT SQL Table

Manufacturers OMRC SQL Table

Items OITM SQL Table

UoM Master Data OUOM SQL Table

Distribution Rule OOCR SQL Table

Project Codes OPRJ SQL Table

UoM Group OUGP SQL Table

Warehouses OWHS SQL Table



SAP® Business One is the trademark(s) or registered trademark(s) of SAP AG in Germany and in several other countries. Icons by Icons8 Contact
This website is not affiliated with, maintained, authorized, endorsed or sponsored by SAP AG or any of its affiliates