biuan SAP® BUSINESS ONE SDK
SQL Items in Package - Draft
DTW Items in Package - Draft
API Document Package Items / Item Code
DRF8 - Items in Package - Draft Table

SBO SQL database table details

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

Table relationship map

SELECT statement

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

Related information


 v9.0  Item Code ItemCode Property· Table: DRF8
Sets or returns the code of the item in the package.
· Table: DRF8 INV8 DLN8    Parent: Document Package Items DocumentPackageItems Object· Table: DRF8 INV8 DLN8
Drafts ODRF 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. Contact
This website is not affiliated with, maintained, authorized, endorsed or sponsored by SAP AG or any of its affiliates