| Column | Field | Description | Data Type | Edit Type | Length | Decimals | SQL Create Statement |
|---|
| 1 | IAEDUS | EDI - User ID | String | Generic Edit | 10 | 0 | Allow NULL? |
| 2 | IAEDBT | EDI - Batch Number | String | Generic Edit | 15 | 0 | Allow NULL? |
| 3 | IAEDTN | EDI - Transaction Number | String | Generic Edit | 22 | 0 | Allow NULL? |
| 4 | IAEDLN | EDI - Line Number | Numeric | Generic Edit | 7 | 3 | Allow NULL? |
| 5 | IAEDCT | EDI - Document Type | String | Generic Edit | 2 | 0 | Allow NULL? |
| 6 | IATYTN | Type - Transaction | String | UDC (00 TT) | 8 | 0 | Allow NULL? |
| 7 | IAEDFT | EDI - Translation Format | String | Generic Edit | 10 | 0 | Allow NULL? |
| 8 | IAEDDT | EDI - Transmission Date | Date | Generic Edit | 6 | 0 | |
| 9 | IADRIN | Direction Indicator | Character | UDC (00 DN) | 1 | 0 | Allow NULL? |
| 10 | IAEDDL | EDI - Detail Lines Processed | Numeric | Generic Edit | 5 | 0 | Allow NULL? |
| 11 | IAEDSP | EDI - Successfully Processed | Character | Generic Edit | 1 | 0 | Allow NULL? |
| 12 | IAPNID | Trading Partner ID | String | Generic Edit | 15 | 0 | Allow NULL? |
| 13 | IATNAC | Transaction Action | String | UDC (00 TA) | 2 | 0 | Allow NULL? |
| 14 | IATRFG | Transmission File Status . . . . . . . . | Character | Generic Edit | 1 | 0 | Allow NULL? |
| 15 | IATRSE | Number of Records Transmitted | Numeric | Generic Edit | 15 | 0 | Allow NULL? |
| 16 | IADTSE | Date - Sent | Date | Generic Edit | 6 | 0 | |
| 17 | IATRRC | Number of Records Received | Numeric | Generic Edit | 15 | 0 | Allow NULL? |
| 18 | IADTRI | Date - Received | Date | Generic Edit | 6 | 0 | |
| 19 | IACCSE | Category Code File Sent | Character | Generic Edit | 1 | 0 | Allow NULL? |
| 20 | IACNAM | Consolidation Name | String | UDC (00 TS) | 3 | 0 | Allow NULL? |
| 21 | IAPN | Period Number - General Ledger | Numeric | Generic Edit | 2 | 0 | Allow NULL? |
| 22 | IAFY | Fiscal Year | Numeric | Generic Edit | 2 | 0 | Allow NULL? |
| 23 | IACTRY | Century | Numeric | Generic Edit | 2 | 0 | Allow NULL? |
| 24 | IALT | Ledger Types | String | UDC (09 LT) | 2 | 0 | Allow NULL? |
| 25 | IACO | Company | String | Generic Edit | 5 | 0 | Allow NULL? |
| 26 | IAIN01 | Prior Period Adjustments | Character | Generic Edit | 1 | 0 | Allow NULL? |
| 27 | IAIN02 | Debits = Credits | Character | Generic Edit | 1 | 0 | Allow NULL? |
| 28 | IAIN03 | Source UDC = Target UDC | Character | Generic Edit | 1 | 0 | Allow NULL? |
| 29 | IAIN04 | Source Obj/Sub = Target Obj/Sub | Character | Generic Edit | 1 | 0 | Allow NULL? |
| 30 | IAIN05 | Accounts Last Month Not This Month | Character | Generic Edit | 1 | 0 | Allow NULL? |
| 31 | IAIN06 | Business Units Last Month Not This Month | Character | Generic Edit | 1 | 0 | Allow NULL? |
| 32 | IAIN07 | Accounts This Month Not Last Month | Character | Generic Edit | 1 | 0 | Allow NULL? |
| 33 | IAIN08 | Business Units This Month Not Last Month | Character | Generic Edit | 1 | 0 | Allow NULL? |
| 34 | IAIN09 | Integrity Control Status 9 | Character | Generic Edit | 1 | 0 | Allow NULL? |
| 35 | IAIN10 | Integrity Control Status 10 | Character | Generic Edit | 1 | 0 | Allow NULL? |
| 36 | IAIN11 | Integrity Control Status 11 | Character | Generic Edit | 1 | 0 | Allow NULL? |
| 37 | IAIN12 | Integrity Control Status 12 | Character | Generic Edit | 1 | 0 | Allow NULL? |
| 38 | IAURDT | User Reserved Date | Date | Generic Edit | 6 | 0 | |
| 39 | IAURRF | User Reserved Reference | String | Generic Edit | 15 | 0 | Allow NULL? |
| 40 | IAURCD | User Reserved Code | String | Generic Edit | 2 | 0 | Allow NULL? |
| 41 | IAURC1 | User Reserved Code | String | Generic Edit | 3 | 0 | Allow NULL? |
| 42 | IAURC2 | User Reserved Code | String | Generic Edit | 10 | 0 | Allow NULL? |
| 43 | IAURAT | User Reserved Amount | Numeric | Generic Edit | 15 | 2 | Allow NULL? |
| 44 | IAURAB | User Reserved Number | Numeric | Generic Edit | 8 | 0 | Allow NULL? |
| 45 | IATORG | Transaction Originator | String | Generic Edit | 10 | 0 | Allow NULL? |
| 46 | IAUSER | User ID | String | Generic Edit | 10 | 0 | Allow NULL? |
| 47 | IAPID | Program ID | String | Generic Edit | 10 | 0 | Allow NULL? |
| 48 | IAVERS | Version History | String | Generic Edit | 10 | 0 | Allow NULL? |
| 49 | IAJOBN | Work Station ID | String | Generic Edit | 10 | 0 | Allow NULL? |
| 50 | IAUPMJ | Date - Updated | Date | Generic Edit | 6 | 0 | |
| 51 | IAUPMT | Time - Last Updated | Numeric | Generic Edit | 6 | 0 | Allow NULL? |
