Table: Timecard Time Detail

Table: PMTIMED
View: PM0041
Record Length: 1357

Flags: A R 

Keys: 3

Title Flags Fields

Sequence/Line Number SEQLINENO
Timecard Number/Line Number TIMECARDNOLINENO
Sequence/Detail Number SEQDETAILNUM

Fields: 76

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
EARNINGS String*16 Earnings Code Mask: %-16C
DESC String*60 Description
TDATE Date Transaction Date
TIMETYPE Integer Time Type List:3 entries
1 = Hour
2 = Vacation
3 = Sick
BILLTYPE Integer Billing Type List:3 entries
2 = Billable
3 = No Charge
1 = Non-billable
STARTTIME Time Start Time
ENDTIME Time End Time
QUANTITY BCD*10.2 Hours
ARITEM String*16 A/R Item No. Mask: %-16C
UOM String*10 Unit of Measure Mask: %-10C
ESTBILLCCY Integer Revenue And Cost Currency List:3 entries
1 = Revenue and Costs in Functional Currency
2 = Revenue in Customer Currency
3 = Revenue and Costs in Customer Currency
COSTCCY String*3 Cost Currency Mask: %-3N
BILLCCY String*3 Billing Currency Mask: %-3N
UNITCOST BCD*10.6 Unit Cost
EXTCOSTSR BCD*10.3 Extended Cost
EXTCOSTHM BCD*10.3 Extended Cost
EXTBILLSR BCD*10.3 Extended Billing Amount
EXTBILLHM BCD*10.3 Reserved
LABOR Integer Labor Type List:3 entries
1 = None
2 = Flat Rate Per Labor Hour/Unit
3 = Percentage of Labor Cost
LABORRATE BCD*10.6 Labor Rate
LABORPER BCD*5.5 Labor Percentage
LABORSR BCD*10.3 Transaction Labor Amount
LABORHM BCD*10.3 Transaction Labor Amount
OVERHD Integer Overhead Type List:3 entries
1 = None
2 = Flat Rate Per Unit
5 = Percentage of Cost
OHEADRATE BCD*10.6 Overhead Rate
HEADPER BCD*5.5 Overhead Percentage
OHSR BCD*10.3 Transaction Overhead Amount
OHHM BCD*10.3 Transaction Overhead Amount
BILLRATE BCD*10.6 Billing Rate
TOTCOSTSR BCD*10.3 Total Cost
TOTCOSTHM BCD*10.3 Total Cost
TOTBILLSR BCD*10.3 Total Billable Amount
TOTBILLHM BCD*10.3 Total Billable Amount
PAYRACCT String*45 Payroll Account Mask: %-45C
WIPACCT String*45 Work In Progress Account Mask: %-45C
OHACCT String*45 Overhead Account Mask: %-45C
LABORACCT String*45 Labor Account Mask: %-45C
COMMENTS String*250 Comments
FIXEDBILL Integer Bill Amount Based On List:2 entries
1 = Invoice This Amount
2 = Invoice Based on Exchange Rate
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