# Table: Cheque Job Details

Table: CPCHJB
View: CP0056
Record length: 433
Flags: A R

## Keys: 1

Title | Flags | Fields
--- | --- | ---
Cheque Job Line Number |  | EMPLOYEE, PEREND, ENTRYSEQ, CATEGORY, EARNDED, LINETYPE, LINENO, JOBLINE

## Fields: 41

Field | Type | Title | Presentation
--- | --- | --- | ---
EMPLOYEE | String*12 | Employee | Mask: %-12N
PEREND | Date | Period End Date |
ENTRYSEQ | Long | Entry Sequence |
CATEGORY | Integer | Category | List: 10 entries
1 | = | Accrual
2 | = | Earning
3 | = | Advance
4 | = | Deduction
5 | = | Expense Reimbursement
6 | = | Benefit
7 | = | Federal Tax
8 | = | Provincial Tax
9 | = | Local Tax
10 | = | User Tax
EARNDED | String*6 | Earning/Deduction | Mask: %-6N
LINETYPE | Integer | Type | List: 9 entries
1 | = | Payment
2 | = | Accrual
3 | = | Regular
4 | = | Overtime
5 | = | Shift Differential
6 | = | n/a
7 | = | Normal Withholding
8 | = | Backup Withholding
9 | = | Supplemental Withholding
LINENO | Integer | Line Number |
JOBLINE | Integer | Job Line Number |
AUDTDATE | Date |  |
AUDTTIME | Time |  |
AUDTUSER | String*8 |  |
AUDTORG | String*6 |  |
CONTRACT | String*16 | Contract Code | Mask: %-16C
PROJECT | String*16 | Project Code | Mask: %-16N
CCATEGORY | String*16 | Category Code | Mask: %-16N
IDCUST | String*12 | Customer | Mask: %-12C
CURRCODE | String*3 | Billing Currency | Mask: %-3C
STARTTIME | Integer | Start Time |
STOPTIME | Integer | Stop Time |
HOURS | BCD*4.3 | Hours |
CNTBASE | BCD*10.3 | Pieces/Sales/Amt |
BILLTYPE | Integer | Billing Type | List: 4 entries
0 | = |
1 | = | Non-billable
2 | = | Billable
3 | = | No Charge
BILLRATE | BCD*10.6 | Billing Rate |
ARITEMNO | String*16 | A/R Item Number | Mask: %-16C
ARUNIT | String*10 | A/R Item UOM | Mask: %-10C
WIPACCT | String*45 | WIP/COS Acct |
VALUES | Long | Number of Optional Fields |
CURRDESC | String*30 | Currency Description |
UFMTCONTNO | String*16 | Unformatted Contract Code | Mask: %-16C
PROJSTYLE | Integer | Project Style | List: 3 entries
0 | = |
1 | = | Standard
2 | = | Basic
PROJTYPE | Integer | Project Type | List: 4 entries
0 | = |
1 | = | Time and Materials
2 | = | Fixed Price
3 | = | Cost Plus
REVREC | Integer | Accounting Method | List: 9 entries
0 | = |
1 | = | Completed Project
2 | = | Total Cost Percentage Complete
3 | = | Labor Hours Percentage Complete
4 | = | Billings and Costs
5 | = | Project Percentage Complete
6 | = | Category Percentage Complete
7 | = | Completed Contract
8 | = | Accrual-Basis
BEXTEND | BCD*10.3 | Extended Billing Amount |
EEXTEND | BCD*10.3 | Employee Extended Amount |
GLOVERHEAD | String*45 | Overhead Account |
GLLABOR | String*45 | Labor Burden Account |
FCOVRHDAMT | BCD*10.3 | (FC) Overhead Amount |
SCOVRHDAMT | BCD*10.3 | Overhead Amount |
FCLABORAMT | BCD*10.3 | (FC) Labor Burden Amount |
SCLABORAMT | BCD*10.3 | Labor Burden Amount |
PMTRANSNUM | Long | PJC Transaction Number |

This page was generated on 2006-Sep-07

Copyright © 2001–2005 Sage Accpac International, Inc.