| Column | Field | Description | Data Type | Edit Type | Length | Decimals | SQL Create Statement |
---|
| 1 | ESEDTY | Type Record | Character | UDC (00 RD) | 1 | 0 | Allow NULL? |
| 2 | ESEDSQ | Record Sequence | Numeric | Generic Edit | 2 | 0 | Allow NULL? |
| 3 | ESEKCO | Company - Key (EDI - Document Key Co) | String | Generic Edit | 5 | 0 | Allow NULL? |
| 4 | ESEDOC | EDI - Document Number | Numeric | Generic Edit | 9 | 0 | Allow NULL? |
| 5 | ESEDCT | EDI - Document Type | String | Generic Edit | 2 | 0 | Allow NULL? |
| 6 | ESEDLN | EDI - Line Number | Numeric | Generic Edit | 7 | 3 | Allow NULL? |
| 7 | ESEDST | EDI - Transaction Set Number | String | UDC (40 ST) | 6 | 0 | Allow NULL? |
| 8 | ESEDFT | EDI - Translation Format | String | Generic Edit | 10 | 0 | Allow NULL? |
| 9 | ESEDDT | EDI - Transmission Date | Date | Generic Edit | 6 | 0 | |
| 10 | ESEDER | EDI - Send/Receive Indicator | Character | UDC (H00 ED) | 1 | 0 | Allow NULL? |
| 11 | ESEDDL | EDI - Detail Lines Processed | Numeric | Generic Edit | 5 | 0 | Allow NULL? |
| 12 | ESEDSP | EDI - Successfully Processed | Character | Generic Edit | 1 | 0 | Allow NULL? |
| 13 | ESEDBT | EDI - Batch Number | String | Generic Edit | 15 | 0 | Allow NULL? |
| 14 | ESEDSLN | EDI - Sub Line Number | Numeric | Generic Edit | 7 | 0 | Allow NULL? |
| 15 | ESREQFRQ | Requirement Frequency | String | Generic Edit | 3 | 0 | Allow NULL? |
| 16 | ESCSTDMDPT | Customer Demand Pattern | String | Generic Edit | 3 | 0 | Allow NULL? |
| 17 | ESREQTYP | Requirement Type | String | Generic Edit | 3 | 0 | Allow NULL? |
| 18 | ESRSDJ | Date - Promised Delivery | Date | Generic Edit | 6 | 0 | |
| 19 | ESRSDT | Promised Delivery Time | Numeric | Generic Edit | 6 | 0 | Allow NULL? |
| 20 | ESPSIG | Pull Signal | String | Generic Edit | 30 | 0 | Allow NULL? |
| 21 | ESRQSJ | Date - Requested Ship | Date | Generic Edit | 6 | 0 | |
| 22 | ESRQSHPQTY | Requested Ship Quantity | Numeric | Generic Edit | 15 | 0 | Allow NULL? |
| 23 | ESUOM | Unit of Measure as Input | String | UDC (00 UM) | 2 | 0 | Allow NULL? |
| 24 | ESRSHT | Requested Ship Time | Numeric | Generic Edit | 6 | 0 | Allow NULL? |
| 25 | ESERQSHPDJ | Date - Ending Requested Ship | Date | Generic Edit | 6 | 0 | |
| 26 | ESDMD06 | Category Code - Demand 06 | String | UDC (40R 06) | 3 | 0 | Allow NULL? |
| 27 | ESDMD07 | Category Code - Demand 07 | String | UDC (40R 07) | 3 | 0 | Allow NULL? |
| 28 | ESDMD08 | Category Code - Demand 08 | String | UDC (40R 08) | 3 | 0 | Allow NULL? |
| 29 | ESDMD09 | Category Code - Demand 09 | String | UDC (40R 09) | 3 | 0 | Allow NULL? |
| 30 | ESDMD10 | Category Code - Demand 10 | String | UDC (40R 10) | 3 | 0 | Allow NULL? |
| 31 | ESURCD | User Reserved Code | String | Generic Edit | 2 | 0 | Allow NULL? |
| 32 | ESURDT | User Reserved Date | Date | Generic Edit | 6 | 0 | |
| 33 | ESURAT | User Reserved Amount | Numeric | Generic Edit | 15 | 2 | Allow NULL? |
| 34 | ESURAB | User Reserved Number | Numeric | Generic Edit | 8 | 0 | Allow NULL? |
| 35 | ESURRF | User Reserved Reference | String | Generic Edit | 15 | 0 | Allow NULL? |
| 36 | ESUSER | User ID | String | Generic Edit | 10 | 0 | Allow NULL? |
| 37 | ESPID | Program ID | String | Generic Edit | 10 | 0 | Allow NULL? |
| 38 | ESJOBN | Work Station ID | String | Generic Edit | 10 | 0 | Allow NULL? |
| 39 | ESUPMJ | Date - Updated | Date | Generic Edit | 6 | 0 | |
| 40 | ESTDAY | Time of Day | Numeric | Generic Edit | 6 | 0 | Allow NULL? |
| 41 | ESPSJOBNO | Production Sequencing Job Number | String | Generic Edit | 15 | 0 | Allow NULL? |
| 42 | ESJOBSQ | Job Sequence Number | String | Generic Edit | 15 | 0 | Allow NULL? |
| 43 | ESDELBATCH | Delivery Batch Number | String | Generic Edit | 6 | 0 | Allow NULL? |