EDCEI005 - Intrastat Return Master
SQL Query Builder
25 Columns
| Column | Description | Type | Length | |
|---|---|---|---|---|
| PERIODGB | smallint 0 | |||
| CMPADRSCODE | char '' | |||
| INTRSTTRTRNID | char '' | |||
| NILRTN | tinyint 0 | |||
| PERIOD | char '' | |||
| SUBMITTED | tinyint 0 | |||
| NUMOFTIMGEN | smallint 0 | |||
| CURNCYID | Functional currency code (e.g., USD, CAD, GBP). Use to filter or group multicurrency transactions. | char '' | ||
| CCode | char '' | |||
| RGN | char '' | |||
| TXRGNNUM | char '' | |||
| BRNCHNMBR | char '' | |||
| ADDRESS1 | char '' | |||
| ADDRESS2 | char '' | |||
| ADDRESS3 | char '' | |||
| AGENTID | char '' | |||
| AGENTNAME | char '' | |||
| AGADDR1 | char '' | |||
| AGADDR2 | char '' | |||
| AGADDR3 | char '' | |||
| AGTXRGN | char '' | |||
| BRNCHIDENTF | char '' | |||
| ARVLDECLTYPE | smallint 0 | |||
| DISPDECLTYPE | smallint 0 | |||
| DEX_ROW_ID | int auto number (1,1) |
Related Tables
Tables that share columns with EDCEI005. Click "Join" to add to your query.