You are here: File Descriptions > Contractors' Job Cost > CJCDxxx - Cost Codes Detail File

# CJCDxxx - Cost Codes Detail File

The Cost Codes Detail file stores estimated and actual cost information for each job and phase. Codes can be 100-999 and contain one cost type from the Cost Types file; code 000 is reserved for billing.

There is one record for each cost code for each job or phase.

| Template: |
| IOLIST: | 0999 CJCDXXX: IOLIST CD0$, CD1$, CD2$, CD3$, CD4$, CD0[ALL], CD1[ALL], CD99$[ALL], CD99[ALL]
| Array Sizes: | DIM CD0[5], CD1[5], CD99[1]
| String Sizes: | DIM CD0$(15), CD1$(28), CD2$(2), CD3$(5), CD4$(8)

Key Definitions

| Key Number | Field | Description
| 0 | [1:1:6] + | Job ID +
|  | [1:7:6] + | Phase ID +
|  | [1:13:3] | Cost Code
| 1 | [3:1:2] + | Cost Type +
|  | [1:1:6] + | Job ID +
|  | [1:7:6] + | Phase ID +
|  | [1:13:3] | Cost Code
| 2 | [5:1:8] + | Use Type +
|  | [1:1:6] + | Job ID +
|  | [1:7:6] | Phase ID
| 3 | [1:13:3] + | Cost Code +
|  | [3:1:2] + | Cost Type +
|  | [1:1:6] + | Job ID +
|  | [1:7:6] | Phase ID
|  | __________ |
|  | 14 segments |

Cost Codes Detail File

| File Name: | CJCDxxx | Record Size: | 256(209)
| File Type: | Mkeyed - Dynamic | Number of Keys: | 4

| Field | Field Name | Variable | Description | A/N | Length | Note
| 1(1,6) | JOBID | CD0$(1,6) | Job ID | A | 6 |
| 1(7,6) | PHASEID | CD0$(7,6) | Phase ID | A | 6 |
| 1(13,3) | COSTCODE | CD0$(13,3) | Cost Code | A | 3 |
| 2(1,20) | CCDESC | CD1$(1,20) | Cost Code Description | A | 20 |
| 2(21,8) | SHRTDESC | CD1$(21,8) | Short Cost Code Description | A | 8 |
| 3 | CTYPE | CD2$ | Cost Type | A | 2 |
| 4 | UOM | CD3$ | Unit of Measure | A | 5 |
| 5 | UTYPE | CD4$ | Use Type | A | 8 | LABOR,
|  |  |  |  |  |  | GENERAL,
|  |  |  |  |  |  | OVERHEAD
| 6 | ESTQTY | CD0[0] | Estimated Quantity | N | 14 |
| 7 | PTDQTY | CD0[1] | Period To Date Quantity | N | 14 |
| 8 | YTDQTY | CD0[2] | Year To Date Quantity | N | 14 |
| 9 | JTDQTY | CD0[3] | Job To Date Quantity | N | 14 |
| 10 | RSV | CD0[4] | Reserved | N | 8 |
| 11 | RSV1 | CD0[5] | Reserved 1 | N | 14 |
| 12 | ESTCOSTAMT | CD1[0] | Estimated Cost Amount | N | 14 |
| 13 | PTDCOSTAMT | CD1[1] | Period Cost Amount | N | 14 |
| 14 | YTDCOSTAMT | CD1[2] | Year To Date Cost Amount | N | 14 |
| 15 | JTDCOSTAMT | CD1[3] | Job To Date Cost Amount | N | 14 |
| 16 | ORIESTCOSTAMT | CD1[4] | Original Estimate For Cost Amount | N | 14 |
| 17 | RSV2 | CD1[5] | Reserved | N | 14 |
| 18 | ISVA | CD99$[0] | Reserved for ISV | A | 1 |
| 19 | ACCUMWIP | CD99[0] | Accumulated WIP | N | 14 |
| 20 | ISVN[1] | CD99[1] | Reserved for ISV | N | 1 |