biuan SAP® BUSINESS ONE SDK
API OEI18
OEI18 - Outgoing Excise Invoice - Export Process Table

SBO SQL database table details

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

Related information


Outgoing Excise Invoice OOEI 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