| Column | Field | Description | Data Type | Edit Type | Length | Decimals | SQL Create Statement |
|---|
| 1 | D1EDTY | Type Record | Character | UDC (00 RD) | 1 | 0 | Allow NULL? |
| 2 | D1EDSQ | Record Sequence | Numeric | Generic Edit | 2 | 0 | Allow NULL? |
| 3 | D1EKCO | Company - Key (EDI - Document Key Co) | String | Generic Edit | 5 | 0 | Allow NULL? |
| 4 | D1EDOC | EDI - Document Number | Numeric | Generic Edit | 9 | 0 | Allow NULL? |
| 5 | D1EDCT | EDI - Document Type | String | Generic Edit | 2 | 0 | Allow NULL? |
| 6 | D1EDLN | EDI - Line Number | Numeric | Generic Edit | 7 | 3 | Allow NULL? |
| 7 | D1EDST | EDI - Transaction Set Number | String | UDC (40 ST) | 6 | 0 | Allow NULL? |
| 8 | D1EDFT | EDI - Translation Format | String | Generic Edit | 10 | 0 | Allow NULL? |
| 9 | D1EDDT | EDI - Transmission Date | Date | Generic Edit | 6 | 0 | |
| 10 | D1EDER | EDI - Send/Receive Indicator | Character | UDC (H00 ED) | 1 | 0 | Allow NULL? |
| 11 | D1EDDL | EDI - Detail Lines Processed | Numeric | Generic Edit | 5 | 0 | Allow NULL? |
| 12 | D1EDSP | EDI - Successfully Processed | Character | Generic Edit | 1 | 0 | Allow NULL? |
| 13 | D1EDBT | EDI - Batch Number | String | Generic Edit | 15 | 0 | Allow NULL? |
| 14 | D1PNID | Trading Partner ID | String | Generic Edit | 15 | 0 | Allow NULL? |
| 15 | D1ICU | Batch Number | Numeric | Generic Edit | 8 | 0 | Allow NULL? |
| 16 | D1ICUT | Batch Type | String | UDC (98 IT) | 2 | 0 | Allow NULL? |
| 17 | D1KCO | Document Company | String | Generic Edit | 5 | 0 | Allow NULL? |
| 18 | D1CO | Company | String | Generic Edit | 5 | 0 | Allow NULL? |
| 19 | D1MCU | Business Unit | String | Generic Edit | 12 | 0 | Allow NULL? |
| 20 | D1DOCM | Document - Matching(Payment or Item) | Numeric | Generic Edit | 8 | 0 | Allow NULL? |
| 21 | D1DCTM | Document Type - Matching | String | UDC (00 DT) | 2 | 0 | Allow NULL? |
| 22 | D1SFXM | Document Pay Item - Matching(Pmt/Item) | String | Generic Edit | 3 | 0 | Allow NULL? |
| 23 | D1DMTJ | Date - Matching Check or Item - Julian | Date | Generic Edit | 6 | 0 | |
| 24 | D1PYIN | Payment Instrument | Character | UDC (00 PY) | 1 | 0 | Allow NULL? |
| 25 | D1PRMK | Payment Remark | String | Generic Edit | 10 | 0 | Allow NULL? |
| 26 | D1AN8 | Address Number | Numeric | UDC | 8 | 0 | Allow NULL? |
| 27 | D1PA8 | Address Number - Parent | Numeric | Generic Edit | 8 | 0 | Allow NULL? |
| 28 | D1CRRM | Currency Mode-Foreign or Domestic Entry | Character | UDC (H00 CY) | 1 | 0 | Allow NULL? |
| 29 | D1DMCD | Domestic Entry w/Mult Currency Distr | Character | Generic Edit | 1 | 0 | Allow NULL? |
| 30 | D1CRCD | Currency Code - From | String | Generic Edit | 3 | 0 | Allow NULL? |
| 31 | D1CDEC | Display Decimals | Character | Generic Edit | 1 | 0 | Allow NULL? |
| 32 | D1CRR | Currency Conversion Rate - Spot Rate | Numeric | Generic Edit | 15 | 0 | Allow NULL? |
| 33 | D1THCD | Transaction Handling Code | Character | UDC (47 TH) | 1 | 0 | Allow NULL? |
| 34 | D1DGJ | Date - For G/L (and Voucher) - Julian | Date | Generic Edit | 6 | 0 | |
| 35 | D1FY | Fiscal Year | Numeric | Generic Edit | 2 | 0 | Allow NULL? |
| 36 | D1CTRY | Century | Numeric | Generic Edit | 2 | 0 | Allow NULL? |
| 37 | D1PN | Period Number - General Ledger | Numeric | Generic Edit | 2 | 0 | Allow NULL? |
| 38 | D1TTOT | Amount - Total Trans | Numeric | Generic Edit | 15 | 2 | Allow NULL? |
| 39 | D1AC01 | Category Code - Address Book 01 | String | UDC (01 01) | 3 | 0 | Allow NULL? |
| 40 | D1AC02 | Category Code - Address Book 02 | String | UDC (01 02) | 3 | 0 | Allow NULL? |
| 41 | D1AC03 | Category Code - Address Book 03 | String | UDC (01 03) | 3 | 0 | Allow NULL? |
| 42 | D1AC04 | Category Code - Address Book 04 | String | UDC (01 04) | 3 | 0 | Allow NULL? |
| 43 | D1AC05 | Category Code - Address Book 05 | String | UDC (01 05) | 3 | 0 | Allow NULL? |
| 44 | D1AC06 | Category Code - Address Book 06 | String | UDC (01 06) | 3 | 0 | Allow NULL? |
| 45 | D1AC07 | Category Code - Address Book 07 | String | UDC (01 07) | 3 | 0 | Allow NULL? |
| 46 | D1AC08 | Category Code - Address Book 08 | String | UDC (01 08) | 3 | 0 | Allow NULL? |
| 47 | D1AC09 | Address Book 09 - Country Type | String | UDC (01 09) | 3 | 0 | Allow NULL? |
| 48 | D1AC10 | Address Book 10 - Nature of the Trade | String | UDC (01 10) | 3 | 0 | Allow NULL? |
| 49 | D1ATE | Address Type - Employee | Character | UDC (H01 AR) | 1 | 0 | Allow NULL? |
| 50 | D1ATR | Address Type - Receivables | Character | UDC (H01 AR) | 1 | 0 | Allow NULL? |
| 51 | D1ATP | Address Type - Payables | Character | UDC (H01 AS) | 1 | 0 | Allow NULL? |
| 52 | D1ATO | Address Type - User Code 5 | Character | UDC (H01 AR) | 1 | 0 | Allow NULL? |
| 53 | D1ATPR | Address Type - Code Purchaser | Character | Generic Edit | 1 | 0 | Allow NULL? |
| 54 | D1AT1 | Search Type | String | UDC (01 ST) | 3 | 0 | Allow NULL? |
| 55 | D1AT2 | AR/AP Netting Indicator | Character | UDC (H01 AV) | 1 | 0 | Allow NULL? |
| 56 | D1AT3 | HRM Records Exist | Character | UDC (H01 AV) | 1 | 0 | Allow NULL? |
| 57 | D1AT4 | Address Type - 4 | Character | UDC (H01 AV) | 1 | 0 | Allow NULL? |
| 58 | D1AT5 | Address Type - 5 | Character | UDC (H01 AV) | 1 | 0 | Allow NULL? |
| 59 | D1TNN | Flag for 1099 | Character | Generic Edit | 1 | 0 | Allow NULL? |
| 60 | D1URCD | User Reserved Code | String | Generic Edit | 2 | 0 | Allow NULL? |
| 61 | D1URDT | User Reserved Date | Date | Generic Edit | 6 | 0 | |
| 62 | D1URAT | User Reserved Amount | Numeric | Generic Edit | 15 | 2 | Allow NULL? |
| 63 | D1URAB | User Reserved Number | Numeric | Generic Edit | 8 | 0 | Allow NULL? |
| 64 | D1URRF | User Reserved Reference | String | Generic Edit | 15 | 0 | Allow NULL? |
| 65 | D1TORG | Transaction Originator | String | Generic Edit | 10 | 0 | Allow NULL? |
| 66 | D1USER | User ID | String | Generic Edit | 10 | 0 | Allow NULL? |
| 67 | D1PID | Program ID | String | Generic Edit | 10 | 0 | Allow NULL? |
| 68 | D1JOBN | Work Station ID | String | Generic Edit | 10 | 0 | Allow NULL? |
| 69 | D1UPMJ | Date - Updated | Date | Generic Edit | 6 | 0 | |
| 70 | D1TDAY | Time of Day | Numeric | Generic Edit | 6 | 0 | Allow NULL? |
