biuan SAP® BUSINESS ONE SDK
API Document Packages / Document Package Items
DLN8 - Items in Package - Delivery Table

SBO SQL database table details

FieldDescriptionTypeConstraintsSizeRelatedDefaultPrimary_KeyUnique
DocEntry KEY UNIQUEDocument Internal IDInt
11ODLN
Delivery
PRIMARYYes
PackageNumPackage NumberInt
11
ItemCodeItem NumbernVarChar
20OITM
Items
QuantityQuantityNum
20
LogInstancLog InstanceInt
11
0
ObjTypeObject TypenVarChar
20ADP1
Object Settings - History
15
UomEntryUoM EntryInt
11OUOM
UoM Master Data
0
unitMsrUnitnVarChar
100
NumPerMsrUoM ValueNum
20
0

Table relationship map

SELECT statement

SELECT DLN8.DocEntry AS 'Document Internal ID', DLN8.PackageNum AS 'Package Number', DLN8.ItemCode AS 'Item Number', DLN8.Quantity AS 'Quantity', DLN8.LogInstanc AS 'Log Instance', DLN8.ObjType AS 'Object Type', DLN8.UomEntry AS 'UoM Entry', DLN8.unitMsr AS 'Unit', DLN8.NumPerMsr AS 'UoM Value' FROM DLN8 AS DLN8

Related information


Document Package Items DocumentPackageItems Object· Table: DLN8
A data structure holding the properties of items in a package. Access this structure via DocumentPackages.Items. Source table: DLN8.
   Parent: Document Packages DocumentPackages Object
Delivery ODLN SQL Table

Items OITM SQL Table

Object Settings - History ADP1 SQL Table

UoM Master Data OUOM 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