|
|
API IGN18
IGN18 - Goods Receipt - Export Process Table
Goods Receipt OIGN 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 | OIGN Goods Receipt | PRIMARY | Yes |
|---|---|---|---|---|---|---|---|---|
| LineNum | Row Number | Int | 11 | |||||
| LogInstanc | Log Instance | Int | 11 | 0 | ||||
| ObjectType | Object Type | nVarChar | 20 | ADP1 Object Settings - History | 59 | |||
| ExpDocType | Type of Exportation Document | Int | 11 | OBNI Brazil Numeric Indexer | -1 | |||
| ExpDeclNum | Exportation Declaration Number | Int | 11 | |||||
| ExpDeclDat | Exportation Declaration Date | Date | 8 | |||||
| ExpNature | Nature of Exportation | Int | 11 | OBNI Brazil Numeric Indexer | -1 | |||
| ExpRegNum | Number of Exportation Registry | Int | 11 | |||||
| ExpRegDate | Date of Exportation Registry | Date | 8 | |||||
| LadBillNum | Bill of Lading Number | nVarChar | 19 | |||||
| LadBillDat | Date of Bill of Lading | Date | 8 | |||||
| MerchLeftD | Date Merchandise Left Customs | Date | 8 | |||||
| LadBillTyp | Type of Bill of Lading | Int | 11 | OBNI Brazil Numeric Indexer | -1 |
Table relationship map
SELECT statement
SELECT
IGN18.DocEntry AS 'Document Internal ID',
IGN18.LineNum AS 'Row Number',
IGN18.LogInstanc AS 'Log Instance',
IGN18.ObjectType AS 'Object Type',
IGN18.ExpDocType AS 'Type of Exportation Document',
IGN18.ExpDeclNum AS 'Exportation Declaration Number',
IGN18.ExpDeclDat AS 'Exportation Declaration Date',
IGN18.ExpNature AS 'Nature of Exportation',
IGN18.ExpRegNum AS 'Number of Exportation Registry',
IGN18.ExpRegDate AS 'Date of Exportation Registry',
IGN18.LadBillNum AS 'Bill of Lading Number',
IGN18.LadBillDat AS 'Date of Bill of Lading',
IGN18.MerchLeftD AS 'Date Merchandise Left Customs',
IGN18.LadBillTyp AS 'Type of Bill of Lading'
FROM IGN18 AS IGN18
Related information
Goods Receipt OIGN 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
