biuan SAP® BUSINESS ONE SDK
API OIBQ
OIBQ - Item - Bin Accumulator Table

SBO SQL database table details

FieldDescriptionTypeConstraintsSizeRelatedDefaultPrimary_KeyUnique
AbsEntry KEY UNIQUEInternal NumberInt
11
PRIMARYYes
ItemCode KEY UNIQUEItem CodenVarChar
20OITM
Items
BUSINESS_KYes
BinAbs KEYBin Internal NumberInt
11OBIN
Bin Location
BIN_ABSNo
OnHandQtyOn-Hand QuantityNum
20
WhsCodeWarehouse CodenVarChar
8OWHS
Warehouses
FreezedItem Frozen in Bin LocationVarChar
Y) Yes
N) No
1
N
FreezeDocInventory Count Doc. Frozen ByInt
11OINC
Inventory Counting

Table relationship map

SELECT statement

SELECT OIBQ.AbsEntry AS 'Internal Number', OIBQ.ItemCode AS 'Item Code', OIBQ.BinAbs AS 'Bin Internal Number', OIBQ.OnHandQty AS 'On-Hand Quantity', OIBQ.WhsCode AS 'Warehouse Code', OIBQ.Freezed AS 'Item Frozen in Bin Location', OIBQ.FreezeDoc AS 'Inventory Count Doc. Frozen By' FROM OIBQ AS OIBQ

Related information


Bin Location OBIN SQL Table

Inventory Counting OINC SQL Table

Items OITM 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