biuan SAP® BUSINESS ONE SDK
API PCH18
PCH18 - A/P Invoice - Export Process Table

SBO SQL database table details

FieldDescriptionTypeConstraintsSizeRelatedDefaultPrimary_KeyUnique
DocEntry KEY UNIQUEDocument Internal IDInt
11OPCH
A/P Invoice
PRIMARYYes
LineNumRow NumberInt
11
LogInstancLog InstanceInt
11
0
ObjectTypeObject TypenVarChar
20ADP1
Object Settings - History
18
ExpDocTypeType of Exportation DocumentInt
11OBNI
Brazil Numeric Indexer
-1
ExpDeclNumExportation Declaration NumberInt
11
ExpDeclDatExportation Declaration DateDate
8
ExpNatureNature of ExportationInt
11OBNI
Brazil Numeric Indexer
-1
ExpRegNumNumber of Exportation RegistryInt
11
ExpRegDateDate of Exportation RegistryDate
8
LadBillNumBill of Lading NumbernVarChar
19
LadBillDatDate of Bill of LadingDate
8
MerchLeftDDate Merchandise Left CustomsDate
8
LadBillTypType of Bill of LadingInt
11OBNI
Brazil Numeric Indexer
-1

Table relationship map

SELECT statement

SELECT PCH18.DocEntry AS 'Document Internal ID', PCH18.LineNum AS 'Row Number', PCH18.LogInstanc AS 'Log Instance', PCH18.ObjectType AS 'Object Type', PCH18.ExpDocType AS 'Type of Exportation Document', PCH18.ExpDeclNum AS 'Exportation Declaration Number', PCH18.ExpDeclDat AS 'Exportation Declaration Date', PCH18.ExpNature AS 'Nature of Exportation', PCH18.ExpRegNum AS 'Number of Exportation Registry', PCH18.ExpRegDate AS 'Date of Exportation Registry', PCH18.LadBillNum AS 'Bill of Lading Number', PCH18.LadBillDat AS 'Date of Bill of Lading', PCH18.MerchLeftD AS 'Date Merchandise Left Customs', PCH18.LadBillTyp AS 'Type of Bill of Lading' FROM PCH18 AS PCH18

Related information


A/P Invoice OPCH SQL Table

Brazil Numeric Indexer OBNI 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. Contact
This website is not affiliated with, maintained, authorized, endorsed or sponsored by SAP AG or any of its affiliates