Table: Timecard Expense Detail

Table: PMTIMEE
View: PM0113
Record length: 1407
Flags: A R 

Keys: 3

Title  Flags  Fields

Sequence/Line Number  SEQ, LINENO
Timecard Number/Line Number  TIMECARDNO, LINENO
Sequence/Detail Number  SEQ, DETAILNUM

Fields: 75

Field  Type  Title  Presentation 

SEQ  Long  Sequence   
LINENO  Integer  Line Number   
AUDTDATE  Date     
AUDTTIME  Time     
AUDTUSER  String*8     
AUDTORG  String*6     
TIMECARDNO  String*16  Timecard Number  Mask: %-6N
FMTCONTNO  String*16  ^1  Mask: %-16C
CONTRACT  String*16  ^1  Mask: %-16C
PROJECT  String*16  ^2  Mask: %-16N
CATEGORY  String*16  ^3  Mask: %-16N
DETAILNUM  Long  Detail Number   
EXPENSE  String*16  Expense Code  Mask: %-16C
DESC  String*60  Description   
TDATE  Date  Transaction Date   
EXPTYPE  Integer  Expense Type  List: 9 entries
1=Airfares
2=Accommodation
3=Meals
4=Entertainment
5=Taxi/Hire Car
6=Tolls
7=Telephone
8=Parking
9=Other
BILLTYPE  Integer  Billing Type  List: 3 entries
2=Billable
3=No Charge
1=Non-billable
QUANTITY  BCD*10.2  Quantity   
ARITEM  String*16  A/R Item No.  Mask: %-16C
UOM  String*10  Unit of Measure  Mask: %-10C
COSTCCY  String*3  Cost Currency  Mask: %-3N
BILLCCY  String*3  Billing Currency  Mask: %-3N
UNITCOST  BCD*10.6  Cost Amount   
EXTCOSTSR  BCD*10.3  Cost Amount   
EXTCOSTHM  BCD*10.3  Cost Amount   
EXTBILLSR  BCD*10.3  Billing Amount   
EXTBILLHM  BCD*10.3  Reserved   
LABOR  Integer  Reserved  List: 3 entries
1=None
2=Flat Rate Per Labor Hour/Unit
3=Percentage of Labor Cost
LABORRATE  BCD*10.6  Reserved   
LABORPER  BCD*5.5  Reserved   
LABORSR  BCD*10.3  Reserved   
LABORHM  BCD*10.3  Reserved   
OVERHD  Integer  Reserved  List: 3 entries
1=None
2=Flat Rate Per Unit
5=Percentage of Cost
OHEADRATE  BCD*10.6  Reserved   
HEADPER  BCD*5.5  Reserved   
OHSR  BCD*10.3  Reserved   
OHHM  BCD*10.3  Reserved   
BILLRATE  BCD*10.6  Billing Amount   
TOTCOSTSR  BCD*10.3  Total Cost   
TOTCOSTHM  BCD*10.3  Total Cost   
TOTBILLSR  BCD*10.3  Total Billable Amount   
TOTBILLHM  BCD*10.3  Reserved   
EXPACCT  String*45  Employee Expense Account  Mask: %-45C
WIPACCT  String*45  WIP/COS Account  Mask: %-45C
OHACCT  String*45  Reserved  Mask: %-45C
LABORACCT  String*45  Reserved  Mask: %-45C
COMMENTS  String*250  Comments   
FIXEDBILL  Integer  Bill Amount Based On   
TAUTH1  String*12  Tax Authority 1  Mask: %-12N
TAUTH2  String*12  Tax Authority 2  Mask: %-12N
TAUTH3  String*12  Tax Authority 3  Mask: %-12N
TAUTH4  String*12  Tax Authority 4  Mask: %-12N
TAUTH5  String*12  Tax Authority 5  Mask: %-12N
TCLASS1  Integer  Tax Class 1   
TCLASS2  Integer  Tax Class 2   
TCLASS3  Integer  Tax Class 3   
TCLASS4  Integer  Tax Class 4   
TCLASS5  Integer  Tax Class 5   
TINCLUDED1  Boolean  Tax Included 1   
TINCLUDED2  Boolean  Tax Included 2   
TINCLUDED3  Boolean  Tax Included 3   
TINCLUDED4  Boolean  Tax Included 4   
TINCLUDED5  Boolean  Tax Included 5   
PROJTYPE  Integer  ^2 Type  List: 3 entries
1=Time and Materials
2=Fixed Price
3=Cost Plus
CONTSTYLE  Integer  ^1 Style  List: 2 entries
1=Standard
2=Basic
CUSTOMER  String*12  Customer  Mask: %-12C
REVREC  Integer  Accounting Method  List: 7 entries
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
8=Accrual-Basis
INVTYPE  Integer  Invoice Type  List: 2 entries
1=Item
2=Summary
VALUES  Long  Optional Fields   
GLDDESC  String*60  G/L Detail Description   
GLDREF  String*60  G/L Detail Reference   
GLCOMMENT  String*250  G/L Detail Comment   
RESOURCE  String*24  Resource  Mask: %-16N
TYPE  Integer  Cost Class  List: 6 entries
1=Labor
2=Material
3=Equipment
4=Subcontractor
5=Overhead
6=Miscellaneous
RESDESC  String*60     

This page was generated on 2008-May-01

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