|
|
API CIN18
CIN18 - Correction Invoice - Export Process Table
A/R Correction Invoice OCIN SQL Table
Brazil Numeric Indexer OBNI SQL Table
Object Settings - History ADP1 SQL Table
SBO SQL database table details
| Field | Description | Type | Constraints | Size | Related | Default | Primary_Key | Unique | DocEntry KEY UNIQUE | Document Internal ID | Int | 11 | OCIN A/R Correction Invoice | PRIMARY | Yes |
|---|---|---|---|---|---|---|---|---|
| LineNum | Row Number | Int | 11 | |||||
| LogInstanc | Log Instance | Int | 11 | 0 | ||||
| ObjectType | Object Type | nVarChar | 20 | ADP1 Object Settings - History | 132 | |||
| ExpDocType | Exportation Document Type | Int | 11 | OBNI Brazil Numeric Indexer | -1 | |||
| ExpDeclNum | Exportation Declaration Number | Int | 11 | |||||
| ExpDeclDat | Exportation Declaration Date | Date | 8 | |||||
| ExpNature | Exportation Nature | Int | 11 | OBNI Brazil Numeric Indexer | -1 | |||
| ExpRegNum | Exportation Registry Number | Int | 11 | |||||
| ExpRegDate | Exportation Registry Date | Date | 8 | |||||
| LadBillNum | Bill of Lading Number | nVarChar | 19 | |||||
| LadBillDat | Bill of Lading Date | Date | 8 | |||||
| MerchLeftD | Date Merchandise Left Customs | Date | 8 | |||||
| LadBillTyp | Bill of Lading Type | Int | 11 | OBNI Brazil Numeric Indexer | -1 |
Table relationship map
SELECT statement
SELECT
CIN18.DocEntry AS 'Document Internal ID',
CIN18.LineNum AS 'Row Number',
CIN18.LogInstanc AS 'Log Instance',
CIN18.ObjectType AS 'Object Type',
CIN18.ExpDocType AS 'Exportation Document Type',
CIN18.ExpDeclNum AS 'Exportation Declaration Number',
CIN18.ExpDeclDat AS 'Exportation Declaration Date',
CIN18.ExpNature AS 'Exportation Nature',
CIN18.ExpRegNum AS 'Exportation Registry Number',
CIN18.ExpRegDate AS 'Exportation Registry Date',
CIN18.LadBillNum AS 'Bill of Lading Number',
CIN18.LadBillDat AS 'Bill of Lading Date',
CIN18.MerchLeftD AS 'Date Merchandise Left Customs',
CIN18.LadBillTyp AS 'Bill of Lading Type'
FROM CIN18 AS CIN18
Related information
A/R Correction Invoice OCIN SQL Table
Brazil Numeric Indexer OBNI SQL Table
Object Settings - History ADP1 SQL Table
This website is not affiliated with, maintained, authorized, endorsed or sponsored by SAP AG or any of its affiliates
