Table: Cheque Job Details

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

Keys: 1

Title  Flags  Fields

Cheque Job Line Number  EMPLOYEE, PEREND, ENTRYSEQ, CATEGORY, EARNDED, LINETYPE, LINENO, JOBLINE

Fields: 44

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   
COSTCLASS  Integer  Cost Class  List: 7 entries
0=
1=Labor
2=Material
3=Equipment
4=Subcontractor
5=Overhead
6=Miscellaneous
RESOURCE  String*24  Resource  Mask: %-16N
RESDESC  String*60  Resource Description   

This page was generated on 2009-Nov-19

Copyright © 2001–2009 Sage Software, Inc. All rights reserved.