| Column | Field | Description | Data Type | Edit Type | Length | Decimals | SQL Create Statement |
---|
| 1 | IDY74IDEC | Internal Declaration Number | Numeric | Generic Edit | 6 | 0 | Allow NULL? |
| 2 | IDKCOO | Order Company (Order Number) | String | Generic Edit | 5 | 0 | Allow NULL? |
| 3 | IDDCTO | Order Type | String | UDC (00 DT) | 2 | 0 | Allow NULL? |
| 4 | IDDOCO | Document (Order No Invoice etc.) | Numeric | Generic Edit | 8 | 0 | Allow NULL? |
| 5 | IDY74SEC | Service Explanation Code | String | UDC (74Y SX) | 10 | 0 | Allow NULL? |
| 6 | IDY74MOS | Method of Supply | Character | UDC (74Y MS) | 1 | 0 | Allow NULL? |
| 7 | IDY74MOC | Method of Collection | Character | UDC (74Y MC) | 1 | 0 | Allow NULL? |
| 8 | IDY74PCTR | Country of Payment | String | UDC (00 CN) | 3 | 0 | Allow NULL? |
| 9 | IDY74OPTY | Intrastat Operation Type | Character | Generic Edit | 1 | 0 | Allow NULL? |
| 10 | IDY74SECN | Section Number | Numeric | Generic Edit | 6 | 0 | Allow NULL? |
| 11 | IDY74SSEQ | Section Sequence Nbr | Numeric | Generic Edit | 6 | 0 | Allow NULL? |
| 12 | IDY74IAA | Intrastat Domestic Amount | Numeric | Generic Edit | 15 | 2 | Allow NULL? |
| 13 | IDCTR | Country | String | UDC (00 CN) | 3 | 0 | Allow NULL? |
| 14 | IDTAX | Tax ID | String | Generic Edit | 20 | 0 | Allow NULL? |
| 15 | IDAN8 | Address Number | Numeric | UDC | 8 | 0 | Allow NULL? |
| 16 | IDDGJ | Date - For G/L (and Voucher) - Julian | Date | Generic Edit | 6 | 0 | |
| 17 | IDY74IFA | Intrastat Foreign Amount | Numeric | Generic Edit | 15 | 2 | Allow NULL? |
| 18 | IDCRCD | Currency Code - From | String | Generic Edit | 3 | 0 | Allow NULL? |
| 19 | IDVINV | Supplier Invoice Number | String | Generic Edit | 25 | 0 | Allow NULL? |
| 20 | IDY74NIDE | New Internal Declaration Number | Numeric | Generic Edit | 6 | 0 | Allow NULL? |
| 21 | IDUSER | User ID | String | Generic Edit | 10 | 0 | Allow NULL? |
| 22 | IDPID | Program ID | String | Generic Edit | 10 | 0 | Allow NULL? |
| 23 | IDJOBN | Work Station ID | String | Generic Edit | 10 | 0 | Allow NULL? |
| 24 | IDUPMJ | Date - Updated | Date | Generic Edit | 6 | 0 | |
| 25 | IDUPMT | Time - Last Updated | Numeric | Generic Edit | 6 | 0 | Allow NULL? |