biuan SAP® BUSINESS ONE SDK
SQL Marketing Documents and Receipts / Purchase Request - Export Process
API PRQ18
PRQ18 - Purchase Request - Export Process Table

SBO SQL database table details

FieldDescriptionTypeConstraintsSizeRelatedDefaultPrimary_KeyUnique
DocEntry KEY UNIQUEDocument Internal IDInt
11OPRQ
Purchase Request		PRIMARYYes
LineNumRow NumberInt
11
LogInstancLog InstanceInt
11
0
ObjectTypeObject TypenVarChar
20ADP1
Object Settings - History		1470000113
ExpDocTypeExportation Document TypeInt
11OBNI
Brazil Numeric Indexer		-1
ExpDeclNumExportation Declaration NumberInt
11
ExpDeclDatExportation Declaration DateDate
8
ExpNatureExportation NatureInt
11OBNI
Brazil Numeric Indexer		-1
ExpRegNumExportation Registry NumberInt
11
ExpRegDateExportation Registry DateDate
8
LadBillNumBill of Lading NumbernVarChar
19
LadBillDatBill of Lading DateDate
8
MerchLeftDDate Merchandise Left CustomsDate
8
LadBillTypBill of Lading TypeInt
11OBNI
Brazil Numeric Indexer		-1

Table relationship map

SELECT statement

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

Related information


Purchase Request OPRQ 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