Easily find this page again using the shortlink: https://gpt.azrcrv.co.uk/EDCEI019
Product: Enhanced Intrastat (2788)
Series:
Display Name: Intrastat Exception Report
Physical Name: EDCEI019
Technical Name: EI_EXPN_RPT_TEMP
| Seq No | Physical Name | Display Name | Dexterity Data Type | SQL Data Type | Length | |
|---|---|---|---|---|---|---|
| 1 | SOPNUMBE  | SOP Number | String | STR20_SOP_Number | 17 | |
| 2 | SOPTYPE | SOP Type | Integer | DDL_SOP_Type | 0 | |
| 3 | DOCID | Document ID | String | STR15_LBAU | 15 | |
| 4 | BACHNUMB | Batch Number | String | STR15_LBAU | 15 | |
| 5 | DOCDATE | Document Date | Date | DT | 8 | |
| 6 | EXCHDATE | Exchange Date | Date | DT_Date | 6 | |
| 7 | POSTEDDT | Posted Date | Date | DATE | 6 | |
| 8 | CUSTNMBR | Customer Number | String | STR15_RM_Customer_Number | 15 | |
Key to the RM Customer MSTR (RM00101).
Click to show/hide | ||||||
| 9 | CUSTNAME | Customer Name | String | STR64_Customer_Name | 64 | |
| 10 | CURNCYID | Currency ID | String | STR15_Currency_ID | 15 | |
Key to the Currency Setup (MC40200).
Click to show/hide | ||||||
| 11 | CURRNIDX | Currency Index | Integer | INT3 | 3 | |
Key to the Currency Setup (MC40200).
Click to show/hide | ||||||
| 12 | SUBTOTAL | Subtotal | Currency | DLR17_RBS0_STR$ | 17 | |