| Column | Field | Description | Data Type | Edit Type | Length | Decimals | SQL Create Statement |
---|
| 1 | ZEEDUS | EDI - User ID | String | Generic Edit | 10 | 0 | Allow NULL? |
| 2 | ZEEDBT | EDI - Batch Number | String | Generic Edit | 15 | 0 | Allow NULL? |
| 3 | ZEEDTN | EDI - Transaction Number | String | Generic Edit | 22 | 0 | Allow NULL? |
| 4 | ZEEDLN | EDI - Line Number | Numeric | Generic Edit | 7 | 3 | Allow NULL? |
| 5 | ZEEDCT | EDI - Document Type | String | Generic Edit | 2 | 0 | Allow NULL? |
| 6 | ZETYTN | Type - Transaction | String | UDC (00 TT) | 8 | 0 | Allow NULL? |
| 7 | ZEEDFT | EDI - Translation Format | String | Generic Edit | 10 | 0 | Allow NULL? |
| 8 | ZEEDDT | EDI - Transmission Date | Date | Generic Edit | 6 | 0 | |
| 9 | ZEDRIN | Direction Indicator | Character | UDC (00 DN) | 1 | 0 | Allow NULL? |
| 10 | ZEEDDL | EDI - Detail Lines Processed | Numeric | Generic Edit | 5 | 0 | Allow NULL? |
| 11 | ZEEDSP | EDI - Successfully Processed | Character | Generic Edit | 1 | 0 | Allow NULL? |
| 12 | ZEPNID | Trading Partner ID | String | Generic Edit | 15 | 0 | Allow NULL? |
| 13 | ZETNAC | Transaction Action | String | UDC (00 TA) | 2 | 0 | Allow NULL? |
| 14 | ZEEDTY | Type Record | Character | UDC (00 RD) | 1 | 0 | Allow NULL? |
| 15 | ZEEDSQ | Record Sequence | Numeric | Generic Edit | 2 | 0 | Allow NULL? |
| 16 | ZEEDTS | EDI - Transaction Set Number | String | Generic Edit | 6 | 0 | Allow NULL? |
| 17 | ZEEDER | EDI - Send/Receive Indicator | Character | UDC (H00 ED) | 1 | 0 | Allow NULL? |
| 18 | ZEEDTC | EDI - Transaction Action | Character | Generic Edit | 1 | 0 | Allow NULL? |
| 19 | ZEEDTR | EDI - Transaction Type | Character | Generic Edit | 1 | 0 | Allow NULL? |
| 20 | ZEEDGL | Batch File Create G/L Record | Character | Generic Edit | 1 | 0 | Allow NULL? |
| 21 | ZEEDDH | Batch File Discount Handling Flag | Character | Generic Edit | 1 | 0 | Allow NULL? |
| 22 | ZEEDAN | User Address Number | Numeric | Generic Edit | 8 | 0 | Allow NULL? |
| 23 | ZECRCD | Currency Code - From | String | Generic Edit | 3 | 0 | Allow NULL? |
| 24 | ZECRDC | Currency Code - To | String | Generic Edit | 3 | 0 | Allow NULL? |
| 25 | ZEAN8 | Address Number | Numeric | UDC | 8 | 0 | Allow NULL? |
| 26 | ZERTTYP | Currency Rate Type | String | UDC (11 RT) | 2 | 0 | Allow NULL? |
| 27 | ZEEFT | Date - Effective | Date | Generic Edit | 6 | 0 | |
| 28 | ZECLMETH | Calculation Method | Character | Generic Edit | 1 | 0 | Allow NULL? |
| 29 | ZECRCM | Currency Conversion Y/Z | Character | Generic Edit | 1 | 0 | Allow NULL? |
| 30 | ZETRCR | Triangulation Currency Code | String | Generic Edit | 3 | 0 | Allow NULL? |
| 31 | ZECRR | Currency Conversion Rate - Spot Rate | Numeric | Generic Edit | 15 | 0 | Allow NULL? |
| 32 | ZECRRD | Currency Conversion Rate - Divisor | Numeric | Generic Edit | 15 | 0 | Allow NULL? |
| 33 | ZECSR | Currency Spot Rate | Character | Generic Edit | 1 | 0 | Allow NULL? |
| 34 | ZEUSER | User ID | String | Generic Edit | 10 | 0 | Allow NULL? |
| 35 | ZEPID | Program ID | String | Generic Edit | 10 | 0 | Allow NULL? |
| 36 | ZEUPMJ | Date - Updated | Date | Generic Edit | 6 | 0 | |
| 37 | ZEUPMT | Time - Last Updated | Numeric | Generic Edit | 6 | 0 | Allow NULL? |
| 38 | ZEJOBN | Work Station ID | String | Generic Edit | 10 | 0 | Allow NULL? |