| Column | Field | Description | Data Type | Edit Type | Length | Decimals | SQL Create Statement |
---|
| 1 | GPAID | Account ID | String | Generic Edit | 8 | 0 | Allow NULL? |
| 2 | GPPNST | Date - Planned Start (Julian) | Date | Generic Edit | 6 | 0 | |
| 3 | GPPNFN | Date - Planned Finish (Julian) | Date | Generic Edit | 6 | 0 | |
| 4 | GPATST | Date - Actual Start (Julian) | Date | Generic Edit | 6 | 0 | |
| 5 | GPATFN | Date - Actual Finish (Julian) | Date | Generic Edit | 6 | 0 | |
| 6 | GPSCHN | Schedule Number | String | Generic Edit | 10 | 0 | Allow NULL? |
| 7 | GPP3ID | Project ID | String | Generic Edit | 4 | 0 | Allow NULL? |
| 8 | GPACID | Activity ID | String | Generic Edit | 8 | 0 | Allow NULL? |
| 9 | GPRID | Resource ID | String | Generic Edit | 8 | 0 | Allow NULL? |
| 10 | GPRDES | Resource Designator | Character | Generic Edit | 1 | 0 | Allow NULL? |
| 11 | GPP3CA | Cost Account | String | Generic Edit | 11 | 0 | Allow NULL? |
| 12 | GPP3AC | Cost Account Category | Character | Generic Edit | 1 | 0 | Allow NULL? |
| 13 | GPPOST | G/L Posted Code | Character | Generic Edit | 1 | 0 | Allow NULL? |
| 14 | GPOSF | Original Schedule Finish | Date | Generic Edit | 6 | 0 | |
| 15 | GPCSHF | Current Schedule Finish | Date | Generic Edit | 6 | 0 | |
| 16 | GPPASQ | Precedent Activity Sequence | Numeric | Generic Edit | 3 | 0 | Allow NULL? |
| 17 | GPNDC | Number of Days to Complete | Numeric | Generic Edit | 9 | 0 | Allow NULL? |
| 18 | GPHPF | Hold Payment Flag | Character | Generic Edit | 1 | 0 | Allow NULL? |
| 19 | GPASJ | Actual Start Date | Date | Generic Edit | 6 | 0 | |
| 20 | GPMCU | Business Unit | String | Generic Edit | 12 | 0 | Allow NULL? |
| 21 | GPOBJ | Object Account | String | Generic Edit | 6 | 0 | Allow NULL? |
| 22 | GPSUB | Subsidiary | String | Generic Edit | 8 | 0 | Allow NULL? |
| 23 | GPUSER | User ID | String | Generic Edit | 10 | 0 | Allow NULL? |
| 24 | GPPID | Program ID | String | Generic Edit | 10 | 0 | Allow NULL? |
| 25 | GPJOBN | Work Station ID | String | Generic Edit | 10 | 0 | Allow NULL? |
| 26 | GPUPMJ | Date - Updated | Date | Generic Edit | 6 | 0 | |
| 27 | GPUPMT | Time - Last Updated | Numeric | Generic Edit | 6 | 0 | Allow NULL? |