biuan SAP® BUSINESS ONE SDK
API WTR18
WTR18 - Inventory Transfer - Export Process Table

SBO SQL database table details

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

Related information


Inventory Transfer OWTR 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