| Column | Field | Description | Data Type | Edit Type | Length | Decimals | SQL Create Statement |
---|
| 1 | EDEDOC | EDI - Document Number | Numeric | Generic Edit | 9 | 0 | Allow NULL? |
| 2 | EDEDCT | EDI - Document Type | String | Generic Edit | 2 | 0 | Allow NULL? |
| 3 | EDEKCO | Company - Key (EDI - Document Key Co) | String | Generic Edit | 5 | 0 | Allow NULL? |
| 4 | EDEDLN | EDI - Line Number | Numeric | Generic Edit | 7 | 3 | Allow NULL? |
| 5 | EDLITM | 2nd Item Number | String | Generic Edit | 25 | 0 | Allow NULL? |
| 6 | EDQTYCC | Quantity - Consignment | Numeric | Generic Edit | 15 | 0 | Allow NULL? |
| 7 | EDQTYOHC | On Hand Quantity - Consignment | Numeric | Generic Edit | 15 | 0 | Allow NULL? |
| 8 | EDUOM | Unit of Measure as Input | String | UDC (00 UM) | 2 | 0 | Allow NULL? |
| 9 | EDQTYCC2 | Secondary Consumed Quantity - Consignmen | Numeric | Generic Edit | 15 | 0 | Allow NULL? |
| 10 | EDQTYOHC2 | On Hand Quantity - Consignment Second | Numeric | Generic Edit | 15 | 0 | Allow NULL? |
| 11 | EDUOM2 | Unit of Measure - Secondary | String | UDC (00 UM) | 2 | 0 | Allow NULL? |
| 12 | EDCONDATE | Consumption Date | Date | Generic Edit | 6 | 0 | |
| 13 | EDITM | Item Number - Short | Numeric | Generic Edit | 8 | 0 | Allow NULL? |
| 14 | EDAITM | 3rd Item Number | String | Generic Edit | 25 | 0 | Allow NULL? |
| 15 | EDCITM | Item Number - Customer/Supplier | String | Generic Edit | 25 | 0 | Allow NULL? |
| 16 | EDLOTN | Lot/Serial Number | String | Generic Edit | 30 | 0 | Allow NULL? |
| 17 | EDURCD | User Reserved Code | String | Generic Edit | 2 | 0 | Allow NULL? |
| 18 | EDURDT | User Reserved Date | Date | Generic Edit | 6 | 0 | |
| 19 | EDURAT | User Reserved Amount | Numeric | Generic Edit | 15 | 2 | Allow NULL? |
| 20 | EDURAB | User Reserved Number | Numeric | Generic Edit | 8 | 0 | Allow NULL? |
| 21 | EDURRF | User Reserved Reference | String | Generic Edit | 15 | 0 | Allow NULL? |
| 22 | EDEDST | EDI - Transaction Set Number | String | UDC (40 ST) | 6 | 0 | Allow NULL? |
| 23 | EDEDFT | EDI - Translation Format | String | Generic Edit | 10 | 0 | Allow NULL? |
| 24 | EDEDDT | EDI - Transmission Date | Date | Generic Edit | 6 | 0 | |
| 25 | EDEDER | EDI - Send/Receive Indicator | Character | UDC (H00 ED) | 1 | 0 | Allow NULL? |
| 26 | EDEDDL | EDI - Detail Lines Processed | Numeric | Generic Edit | 5 | 0 | Allow NULL? |
| 27 | EDEDBT | EDI - Batch Number | String | Generic Edit | 15 | 0 | Allow NULL? |
| 28 | EDPNID | Trading Partner ID | String | Generic Edit | 15 | 0 | Allow NULL? |
| 29 | EDEDSP | EDI - Successfully Processed | Character | Generic Edit | 1 | 0 | Allow NULL? |
| 30 | EDEDTY | Type Record | Character | UDC (00 RD) | 1 | 0 | Allow NULL? |
| 31 | EDEDSQ | Record Sequence | Numeric | Generic Edit | 2 | 0 | Allow NULL? |
| 32 | EDTORG | Transaction Originator | String | Generic Edit | 10 | 0 | Allow NULL? |
| 33 | EDUSER | User ID | String | Generic Edit | 10 | 0 | Allow NULL? |
| 34 | EDPID | Program ID | String | Generic Edit | 10 | 0 | Allow NULL? |
| 35 | EDJOBN | Work Station ID | String | Generic Edit | 10 | 0 | Allow NULL? |
| 36 | EDUPMJ | Date - Updated | Date | Generic Edit | 6 | 0 | |
| 37 | EDTDAY | Time of Day | Numeric | Generic Edit | 6 | 0 | Allow NULL? |