biuan SAP® BUSINESS ONE SDK
DTW A/R Invoice - Bin Allocation Data
API Document Lines / Document Lines Bin Allocations
INV19 - A/R Invoice - Bin Allocation Data Table

SBO SQL database table details

FieldDescriptionTypeConstraintsSizeRelatedDefaultPrimary_KeyUnique
DocEntry KEY UNIQUEInternal NumberInt
11OINV
A/R Invoice
PRIMARYYes
BinAllocSeBin Allocation SequenceInt
11
LineNumLine NumberInt
11
SubLineNumSubline NumberInt
11
-1
SnBTypeSnB TypeInt
11
-1
SnBMDAbsSnB Master Data Internal No.Int
11
-1
BinAbsBin Internal NumberInt
11OBIN
Bin Location
QuantityQuantityNum
20
ItemCodeItem CodenVarChar
20OITM
Items
WhsCodeWarehouse CodenVarChar
8OWHS
Warehouses
ObjTypeObject TypenVarChar
20ADP1
Object Settings - History
13
LogInstancLog InstanceInt
11
0
AllowNegAllow Negative Entry [Y/N]VarChar
Y) Yes
N) No
1
N
BinActTypBin Action TypeInt
1) Transaction In
2) Transaction Out
4) SnB Complete
8) Bin First Then SnB
6

Table relationship map

SELECT statement

SELECT INV19.DocEntry AS 'Internal Number', INV19.BinAllocSe AS 'Bin Allocation Sequence', INV19.LineNum AS 'Line Number', INV19.SubLineNum AS 'Subline Number', INV19.SnBType AS 'SnB Type', INV19.SnBMDAbs AS 'SnB Master Data Internal No.', INV19.BinAbs AS 'Bin Internal Number', INV19.Quantity AS 'Quantity', INV19.ItemCode AS 'Item Code', INV19.WhsCode AS 'Warehouse Code', INV19.ObjType AS 'Object Type', INV19.LogInstanc AS 'Log Instance', INV19.AllowNeg AS 'Allow Negative Entry [Y/N]', INV19.BinActTyp AS 'Bin Action Type' FROM INV19 AS INV19

Related information


Document Lines Bin Allocations DocumentLinesBinAllocations Object· Table: INV19
DocumentLinesBinAllocations is a child object of the Document_Lines object that represents the bin allocation of items or serial items or batch items. Source table: INV19.
   Parent: Document Lines Document_Lines Object· Table: IGE1 IGN1

Stock Transfer Lines Bin Allocations StockTransferLinesBinAllocations Object· Table: INV19
StockTransferLinesBinAllocations is a child object of the StockTransfer_Lines object that represents the bin allocation of items or serial items or batch items. Source table: INV19.
   Parent: Stock Transfer Lines StockTransfer_Lines Object· Table: WTR1 WTQ1
Bin Location OBIN SQL Table

A/R Invoice OINV SQL Table

Items OITM SQL Table

Object Settings - History ADP1 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