biuan SAP® BUSINESS ONE SDK
API TCN1
TCN1 - Tracking Note - Line Data Table

SBO SQL database table details

FieldDescriptionTypeConstraintsSizeRelatedDefaultPrimary_KeyUnique
AbsEntry KEY UNIQUEAbs. EntryInt
11OTCN
Tracking Note
PRIMARYYes
LineNumRow NumberInt
11
ItemCCDNumItem CCD NumbernVarChar
20
ItemCodeItem CodenVarChar
20OITM
Items
QuantityQuantityNum
20

Table relationship map

SELECT statement

SELECT TCN1.AbsEntry AS 'Abs. Entry', TCN1.LineNum AS 'Row Number', TCN1.ItemCCDNum AS 'Item CCD Number', TCN1.ItemCode AS 'Item Code', TCN1.Quantity AS 'Quantity' FROM TCN1 AS TCN1

Related information


TCN1 SQL Table

Tracking Note OTCN SQL Table

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