biuan SAP® BUSINESS ONE SDK
API RDR18
RDR18 - Sales Order - Export Process Table

SBO SQL database table details

FieldDescriptionTypeConstraintsSizeRelatedDefaultPrimary_KeyUnique
DocEntry KEY UNIQUEDocument Internal IDInt
11ORDR
Sales Order
PRIMARYYes
LineNumRow NumberInt
11
LogInstancLog InstanceInt
11
0
ObjectTypeObject TypenVarChar
20ADP1
Object Settings - History
17
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 RDR18.DocEntry AS 'Document Internal ID', RDR18.LineNum AS 'Row Number', RDR18.LogInstanc AS 'Log Instance', RDR18.ObjectType AS 'Object Type', RDR18.ExpDocType AS 'Type of Exportation Document', RDR18.ExpDeclNum AS 'Exportation Declaration Number', RDR18.ExpDeclDat AS 'Exportation Declaration Date', RDR18.ExpNature AS 'Nature of Exportation', RDR18.ExpRegNum AS 'Number of Exportation Registry', RDR18.ExpRegDate AS 'Date of Exportation Registry', RDR18.LadBillNum AS 'Bill of Lading Number', RDR18.LadBillDat AS 'Date of Bill of Lading', RDR18.MerchLeftD AS 'Date Merchandise Left Customs', RDR18.LadBillTyp AS 'Type of Bill of Lading' FROM RDR18 AS RDR18

Related information


Sales Order ORDR 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. Icons by Icons8 Contact
This website is not affiliated with, maintained, authorized, endorsed or sponsored by SAP AG or any of its affiliates