Table: Employee Timecard Job Details

Table: CPUTJB
View: CP0044
Record length: 422
Flags: A R 

Keys: 2

Title  Flags  Fields
Employee Timecard Job Line Numbe  EMPLOYEE, ENDDATE, PAYDATE, EARNDED, UNIQUE, JOBLINE
Employee Timecard Job  EMPLOYEE, ENDDATE, PAYDATE, EARNDED, UNIQUE, CONTRACT, PROJECT, CCATEGORY, IDCUST, JOBLINE

Fields: 34

Field  Type  Title  Presentation 
EMPLOYEE  String*12  Employee  Mask: %-12N
ENDDATE  Date  End Date   
PAYDATE  Date  Pay Date   
EARNDED  String*6  Earning/Expense/Tip Code  Mask: %-6N
UNIQUE  Integer  Unique Key Field   
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  Regular WIP/COS Acct   
OTWIPACCT  String*45  Overtime WIP/COS Acct   
STWIPACCT  String*45  Shift WIP/COS Acct   
VALUES  Long  Number of Optional Fields   
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
UFMTCONTNO  String*16  Unformatted Contract Code  Mask: %-16C
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
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 2008-May-02

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