| Column | Field | Description | Data Type | Edit Type | Length | Decimals | SQL Create Statement |
---|
| 1 | AEEDTY | Type Record | Character | UDC (00 RD) | 1 | 0 | Allow NULL? |
| 2 | AEEDSQ | Record Sequence | Numeric | Generic Edit | 2 | 0 | Allow NULL? |
| 3 | AEEKCO | Company - Key (EDI - Document Key Co) | String | Generic Edit | 5 | 0 | Allow NULL? |
| 4 | AEEDOC | EDI - Document Number | Numeric | Generic Edit | 9 | 0 | Allow NULL? |
| 5 | AEEDCT | EDI - Document Type | String | Generic Edit | 2 | 0 | Allow NULL? |
| 6 | AEEDLN | EDI - Line Number | Numeric | Generic Edit | 7 | 3 | Allow NULL? |
| 7 | AEEDST | EDI - Transaction Set Number | String | UDC (40 ST) | 6 | 0 | Allow NULL? |
| 8 | AEEDFT | EDI - Translation Format | String | Generic Edit | 10 | 0 | Allow NULL? |
| 9 | AEEDDT | EDI - Transmission Date | Date | Generic Edit | 6 | 0 | |
| 10 | AEEDER | EDI - Send/Receive Indicator | Character | UDC (H00 ED) | 1 | 0 | Allow NULL? |
| 11 | AEEDDL | EDI - Detail Lines Processed | Numeric | Generic Edit | 5 | 0 | Allow NULL? |
| 12 | AEEDSP | EDI - Successfully Processed | Character | Generic Edit | 1 | 0 | Allow NULL? |
| 13 | AEEDBT | EDI - Batch Number | String | Generic Edit | 15 | 0 | Allow NULL? |
| 14 | AESEGERRID | Segment Error ID | String | UDC (47 NC) | 3 | 0 | Allow NULL? |
| 15 | AESEGID | EDI Segment ID | String | Generic Edit | 3 | 0 | Allow NULL? |
| 16 | AESEGPOS | Segment Position | Integer | Generic Edit | 11 | 0 | Allow NULL? |
| 17 | AEELEPOS | Element Position | Integer | Generic Edit | 11 | 0 | Allow NULL? |
| 18 | AEELEREFNO | Element Reference Number | Integer | Generic Edit | 11 | 0 | Allow NULL? |
| 19 | AEBADELE | Copy of Bad Element | String | Generic Edit | 35 | 0 | Allow NULL? |
| 20 | AENEWELE | Data Element New Content | String | Generic Edit | 35 | 0 | Allow NULL? |
| 21 | AELOOPID | Code - Loop ID | String | Generic Edit | 4 | 0 | Allow NULL? |
| 22 | AEELEERRCD | Code - Element Error | String | UDC (47 EC) | 3 | 0 | Allow NULL? |
| 23 | AEUSER | User ID | String | Generic Edit | 10 | 0 | Allow NULL? |
| 24 | AEPID | Program ID | String | Generic Edit | 10 | 0 | Allow NULL? |
| 25 | AEJOBN | Work Station ID | String | Generic Edit | 10 | 0 | Allow NULL? |
| 26 | AEUPMJ | Date - Updated | Date | Generic Edit | 6 | 0 | |
| 27 | AETDAY | Time of Day | Numeric | Generic Edit | 6 | 0 | Allow NULL? |