biuan SAP® BUSINESS ONE SDK
SQL Marketing Documents and Receipts / Correction Invoice - Bin Allocation Data
API CIN17
CIN17 - Correction Invoice - Bin Allocation Data Table

SBO SQL database table details

FieldDescriptionTypeConstraintsSizeRelatedDefaultPrimary_KeyUnique
DocEntry KEY UNIQUEInternal NumberInt
11OCIN
A/R Correction Invoice		PRIMARYYes
LineNumBin Allocation SequenceInt
11
LogInstancLine NumberInt
11
0
ObjectTypeSubline NumbernVarChar
20ADP1
Object Settings - History		132
ImpDocTypeSnB TypeVarChar
1OBSI
Brazil String Indexer
ImpDocNumSnB Master Data Internal NumbernVarChar
10
DateOfRegBin Internal NumberDate
8
CustClrDatQuantityDate
8
ConcActNumItem CodenVarChar
30
AdditNumWarehouse CodenVarChar
30
AddItmDVObject TypeNum
20
tpVTranspOverland Transport RouteInt
1) Maritime
2) Waterway
3) Lakeside
4) Air
5) Post
6) Train
7) Road
8) Network Transmission
9) Own Means
10) Input/Output Fictitious
6

Table relationship map

SELECT statement

SELECT CIN17.DocEntry AS 'Internal Number', CIN17.LineNum AS 'Bin Allocation Sequence', CIN17.LogInstanc AS 'Line Number', CIN17.ObjectType AS 'Subline Number', CIN17.ImpDocType AS 'SnB Type', CIN17.ImpDocNum AS 'SnB Master Data Internal Number', CIN17.DateOfReg AS 'Bin Internal Number', CIN17.CustClrDat AS 'Quantity', CIN17.ConcActNum AS 'Item Code', CIN17.AdditNum AS 'Warehouse Code', CIN17.AddItmDV AS 'Object Type', CIN17.tpVTransp AS 'Overland Transport Route' FROM CIN17 AS CIN17

Related information


A/R Correction Invoice OCIN SQL Table

Brazil String Indexer OBSI SQL Table

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