| Column | Field | Description | Data Type | Edit Type | Length | Decimals | SQL Create Statement |
---|
| 1 | GPEDBT | EDI - Batch Number | String | Generic Edit | 15 | 0 | Allow NULL? |
| 2 | GPEDUS | EDI - User ID | String | Generic Edit | 10 | 0 | Allow NULL? |
| 3 | GPEDTN | EDI - Transaction Number | String | Generic Edit | 22 | 0 | Allow NULL? |
| 4 | GPTRFG | Transmission File Status . . . . . . . . | Character | Generic Edit | 1 | 0 | Allow NULL? |
| 5 | GPTRSE | Number of Records Transmitted | Numeric | Generic Edit | 15 | 0 | Allow NULL? |
| 6 | GPDTSE | Date - Sent | Date | Generic Edit | 6 | 0 | |
| 7 | GPTRRC | Number of Records Received | Numeric | Generic Edit | 15 | 0 | Allow NULL? |
| 8 | GPDTRI | Date - Received | Date | Generic Edit | 6 | 0 | |
| 9 | GPCCSE | Category Code File Sent | Character | Generic Edit | 1 | 0 | Allow NULL? |
| 10 | GPCNAM | Consolidation Name | String | UDC (00 TS) | 3 | 0 | Allow NULL? |
| 11 | GPPN | Period Number - General Ledger | Numeric | Generic Edit | 2 | 0 | Allow NULL? |
| 12 | GPFY | Fiscal Year | Numeric | Generic Edit | 2 | 0 | Allow NULL? |
| 13 | GPCTRY | Century | Numeric | Generic Edit | 2 | 0 | Allow NULL? |
| 14 | GPLT | Ledger Types | String | UDC (09 LT) | 2 | 0 | Allow NULL? |
| 15 | GPCO | Company | String | Generic Edit | 5 | 0 | Allow NULL? |
| 16 | GPIN01 | Prior Period Adjustments | Character | Generic Edit | 1 | 0 | Allow NULL? |
| 17 | GPIN02 | Debits = Credits | Character | Generic Edit | 1 | 0 | Allow NULL? |
| 18 | GPIN03 | Source UDC = Target UDC | Character | Generic Edit | 1 | 0 | Allow NULL? |
| 19 | GPIN04 | Source Obj/Sub = Target Obj/Sub | Character | Generic Edit | 1 | 0 | Allow NULL? |
| 20 | GPIN05 | Accounts Last Month Not This Month | Character | Generic Edit | 1 | 0 | Allow NULL? |
| 21 | GPIN06 | Business Units Last Month Not This Month | Character | Generic Edit | 1 | 0 | Allow NULL? |
| 22 | GPIN07 | Accounts This Month Not Last Month | Character | Generic Edit | 1 | 0 | Allow NULL? |
| 23 | GPIN08 | Business Units This Month Not Last Month | Character | Generic Edit | 1 | 0 | Allow NULL? |
| 24 | GPIN09 | Integrity Control Status 9 | Character | Generic Edit | 1 | 0 | Allow NULL? |
| 25 | GPIN10 | Integrity Control Status 10 | Character | Generic Edit | 1 | 0 | Allow NULL? |
| 26 | GPIN11 | Integrity Control Status 11 | Character | Generic Edit | 1 | 0 | Allow NULL? |
| 27 | GPIN12 | Integrity Control Status 12 | Character | Generic Edit | 1 | 0 | Allow NULL? |
| 28 | GPURDT | User Reserved Date | Date | Generic Edit | 6 | 0 | |
| 29 | GPURRF | User Reserved Reference | String | Generic Edit | 15 | 0 | Allow NULL? |
| 30 | GPURCD | User Reserved Code | String | Generic Edit | 2 | 0 | Allow NULL? |
| 31 | GPURC1 | User Reserved Code | String | Generic Edit | 3 | 0 | Allow NULL? |
| 32 | GPURC2 | User Reserved Code | String | Generic Edit | 10 | 0 | Allow NULL? |
| 33 | GPUSER | User ID | String | Generic Edit | 10 | 0 | Allow NULL? |
| 34 | GPPID | Program ID | String | Generic Edit | 10 | 0 | Allow NULL? |
| 35 | GPVERS | Version History | String | Generic Edit | 10 | 0 | Allow NULL? |
| 36 | GPUPMJ | Date - Updated | Date | Generic Edit | 6 | 0 | |
| 37 | GPUPMT | Time - Last Updated | Numeric | Generic Edit | 6 | 0 | Allow NULL? |
| 38 | GPJOBN | Work Station ID | String | Generic Edit | 10 | 0 | Allow NULL? |