biuan SAP® BUSINESS ONE SDK
SQL Inventory and Production / Inventory Opening Balance Draft - Rows
API IOD1
IOD1 - Inventory Opening Balance Draft - Rows Table

SBO SQL database table details

FieldDescriptionTypeConstraintsSizeRelatedDefaultPrimary_KeyUnique
DocEntry KEY UNIQUEDocument Internal IDInt
11OIOD
Inventory Opening Balance Draft		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 Rule 2nVarChar
8OOCR
Distribution Rule
OcrCode3Distribution Rule 3nVarChar
8OOCR
Distribution Rule
OcrCode4Distribution Rule 4nVarChar
8OOCR
Distribution Rule
OcrCode5Distribution Rule 5nVarChar
8OOCR
Distribution Rule
ObjTypeObject TypenVarChar
20
310000001
ProjectProject CodenVarChar
20OPRJ
Project Codes
BarCodeBar CodenVarChar
127
InvUoMInventory UoMVarChar
Y) Yes
N) No
1
InvUoMQtyInventory UoM QtyNum
20
BinEntryBin Location EntryInt
11OBIN
Bin Location
FirmCodeManufacturerInt
6OMRC
Manufacturers
SuppCatNumMfr Catalog No.nVarChar
17
CardCodePreferred VendornVarChar
15OCRD
Business Partner
RemarkRemarksnVarChar
127
LocationLocationInt
11
ItmsGrpCodItem GroupInt
6OITB
Item Groups		100
LogInstancLog Instance - HistoryInt
11
BinNegQtyAllow Bin Negative QuantityVarChar
Y) Yes
N) No
1
N
VisOrderVisual OrderInt
11
ActPriceActual PriceNum
20
PostValueLPosted Value LCNum
20
PostValueSPosted Value SCNum
20

Table relationship map

SELECT statement

SELECT IOD1.DocEntry AS 'Document Internal ID', IOD1.DocLineNum AS 'Row Number in Document', IOD1.ItemCode AS 'Item No.', IOD1.ItemName AS 'Item Description', IOD1.InvntryUom AS 'Inventory UoM', IOD1.OnHandBef AS 'Quantity Stored in Warehouse', IOD1.Price AS 'Price', IOD1.Quantity AS 'Quantity - Delta', IOD1.Currency AS 'Price Currency', IOD1.Rate AS 'Currency Price', IOD1.IOffIncAcc AS 'Inventory Offset Increase Acct', IOD1.DOffDecAcc AS 'Inventory Offset Decrease Acct', IOD1.OcrCode AS 'Distribution Rule', IOD1.WhsCode AS 'Warehouse Code', IOD1.DocTotal AS 'Document Total', IOD1.DocTotalFC AS 'Document Total (FC)', IOD1.DocTotalSy AS 'Document Total (SC)', IOD1.OcrCode2 AS 'Distribution Rule 2', IOD1.OcrCode3 AS 'Distribution Rule 3', IOD1.OcrCode4 AS 'Distribution Rule 4', IOD1.OcrCode5 AS 'Distribution Rule 5', IOD1.ObjType AS 'Object Type', IOD1.Project AS 'Project Code', IOD1.BarCode AS 'Bar Code', IOD1.InvUoM AS 'Inventory UoM', IOD1.InvUoMQty AS 'Inventory UoM Qty', IOD1.BinEntry AS 'Bin Location Entry', IOD1.FirmCode AS 'Manufacturer', IOD1.SuppCatNum AS 'Mfr Catalog No.', IOD1.CardCode AS 'Preferred Vendor', IOD1.Remark AS 'Remarks', IOD1.Location AS 'Location', IOD1.ItmsGrpCod AS 'Item Group', IOD1.LogInstanc AS 'Log Instance - History', IOD1.BinNegQty AS 'Allow Bin Negative Quantity', IOD1.VisOrder AS 'Visual Order', IOD1.ActPrice AS 'Actual Price', IOD1.PostValueL AS 'Posted Value LC', IOD1.PostValueS AS 'Posted Value SC' FROM IOD1 AS IOD1

Related information


Bin Location OBIN SQL Table

Business Partner OCRD SQL Table

Inventory Opening Balance Draft OIOD SQL Table

G/L Accounts OACT SQL Table

Manufacturers OMRC SQL Table

Items OITM SQL Table

Item Groups OITB SQL Table

Distribution Rule OOCR SQL Table

Project Codes OPRJ 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. Contact
This website is not affiliated with, maintained, authorized, endorsed or sponsored by SAP AG or any of its affiliates