| Column | Field | Description | Data Type | Edit Type | Length | Decimals | SQL Create Statement |
---|
| 1 | CLCO | Company | String | Generic Edit | 5 | 0 | Allow NULL? |
| 2 | CLDTPW | Fiscal Date Pattern - Weekly | Character | Generic Edit | 1 | 0 | Allow NULL? |
| 3 | CLDFW | Date - Fiscal Year Begins - Weekly | Date | Generic Edit | 6 | 0 | |
| 4 | CLCALW | Number of Periods - Normal - Weekly | String | UDC (H00 CB) | 2 | 0 | Allow NULL? |
| 5 | CLPNK | Period Number - Current Week | Numeric | Generic Edit | 2 | 0 | Allow NULL? |
| 6 | CLDJM | Date - Job Cost Monthly | Date | Generic Edit | 6 | 0 | |
| 7 | CLDJW | Date - Job Cost Weekly | Date | Generic Edit | 6 | 0 | |
| 8 | CLFMO | File Maintenance Options | Character | UDC (H00 FM) | 1 | 0 | Allow NULL? |
| 9 | CLBAT | Budget Audit Trail (Y/N) | Character | Generic Edit | 1 | 0 | Allow NULL? |
| 10 | CLCGT | Projection Audit Trail (Y/N) | Character | Generic Edit | 1 | 0 | Allow NULL? |
| 11 | CLJCP | Job Cost Projections (Y/N) | Character | Generic Edit | 1 | 0 | Allow NULL? |
| 12 | CLCMTR | Commitment Relief (Y/N) | Character | Generic Edit | 1 | 0 | Allow NULL? |
| 13 | CLCMTT | Commitment Display | Character | UDC (H00 CM) | 1 | 0 | Allow NULL? |
| 14 | CLJCF1 | Job Cost Future Constant 1 | Character | Generic Edit | 1 | 0 | Allow NULL? |
| 15 | CLJCF2 | Job Cost Future Constant 2 | Character | Generic Edit | 1 | 0 | Allow NULL? |
| 16 | CLJCF3 | Job Cost Future Constant 3 | Character | Generic Edit | 1 | 0 | Allow NULL? |
| 17 | CLJCF4 | Job Cost Future Constant 4 | Character | Generic Edit | 1 | 0 | Allow NULL? |
| 18 | CLJCF5 | Job Cost Future Constant 5 | Character | Generic Edit | 1 | 0 | Allow NULL? |