biuan SAP® BUSINESS ONE SDK
API CSV18
CSV18 - A/R Correction Invoice Reversal - Export Process Table

SBO SQL database table details

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

Related information


A/R Correction Invoice Reversal OCSV 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