biuan SAP® BUSINESS ONE SDK
SQL Marketing Documents and Receipts / A/R Invoice - Delivery Packages
API Document Packages / Document Package Items
INV7 - A/R Invoice - Delivery Packages Table

SBO SQL database table details

FieldDescriptionTypeConstraintsSizeRelatedDefaultPrimary_KeyUnique
DocEntry KEY UNIQUEDocument Internal IDInt
11OINV
A/R Invoice		PRIMARYYes
PackageNumPackage NumberInt
11
PackageTypPackage TypenVarChar
30
WeightWeightNum
20
WeightUnitUoMInt
6OWGT
Weight Units
ObjTypeObject TypenVarChar
20ADP1
Object Settings - History		13
LogInstancLog InstanceInt
11
0

Table relationship map

SELECT statement

SELECT INV7.DocEntry AS 'Document Internal ID', INV7.PackageNum AS 'Package Number', INV7.PackageTyp AS 'Package Type', INV7.Weight AS 'Weight', INV7.WeightUnit AS 'UoM', INV7.ObjType AS 'Object Type', INV7.LogInstanc AS 'Log Instance' FROM INV7 AS INV7

Related information


Document Package Items DocumentPackageItems Object· Table: INV7
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
A/R Invoice OINV SQL Table

Object Settings - History ADP1 SQL Table

Weight Units OWGT 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