View: Timecard Time Detail Audit

RotoID: PM0043
Table: PMTIMDA
Protocol: Flat
DLL:PMTIMDA

Keys: 4

Title Fields

Sequence/Line Number POSTSEQNOLINENO
Sequence/Detail Number POSTSEQNODETAILNUM
Timecard Seq/Post Seq/Detail Num SEQPOSTSEQNODETAILNUM
Timecard Seq/Post Seq/Detail Num TIMECARDNODETAILNUM

Fields: 80

Field Index Type Title Attributes Presentation

POSTSEQNO 1 Long Posting Sequence E A K R 
LINENO 2 Integer Line Number E A K R 
SEQ 3 Long Sequence E A 
TIMECARDNO 4 String*16 Timecard Number E A  Mask: %-6N
FMTCONTNO 5 String*16 ^1 E A 
CONTRACT 6 String*16 ^1 E A  Mask: %-16C
PROJECT 7 String*16 ^2 E A  Mask: %-16N
CATEGORY 8 String*16 ^3 E A  Mask: %-16N
DETAILNUM 9 Long Detail Number E A 
EARNINGS 10 String*16 Earnings Code E A 
DESC 11 String*60 Description E A 
TDATE 12 Date Transaction Date E A 
TIMETYPE 13 Integer Time Type E A 
BILLTYPE 14 Integer Billing Type E A  List:3 entries
2 = Billable
3 = No Charge
1 = Non-billable
STARTTIME 15 Time Start Time E A 
ENDTIME 16 Time End Time E A 
QUANTITY 17 BCD*10.2 Quantity E A 
ARITEM 18 String*16 A/R Item No. E A  Mask: %-16C
UOM 19 String*10 Unit of Measure E A 
ESTBILLCCY 20 Integer Revenue And Cost Currency E A  List:3 entries
1 = Revenue and Costs in Functional Currency
2 = Revenue in Customer Currency
3 = Revenue and Costs in Customer Currency
COSTCCY 21 String*3 Cost Currency E A  Mask: %-3N
BILLCCY 22 String*3 Billing Currency E A  Mask: %-3N
UNITCOST 23 BCD*10.6 Unit Cost E A 
EXTCOSTSR 24 BCD*10.3 Extended Cost E A 
EXTCOSTHM 25 BCD*10.3 Extended Cost E A 
EXTBILLSR 26 BCD*10.3 Extended Billing Amount E A 
EXTBILLHM 27 BCD*10.3 Reserved E A 
LABACCT 28 String*45 Labor Account E A  Mask: %-45C
LABOR 29 Integer Labor Type E A  List:3 entries
1 = None
2 = Flat Rate Per Labor Hour/Unit
3 = Percentage of Labor Cost
LABORRATE 30 BCD*10.6 Labor Rate E A 
LABORPER 31 BCD*5.5 Labor Percentage E A 
LABORSR 32 BCD*10.3 Transaction Labor Amount E A 
LABORHM 33 BCD*10.3 Transaction Labor Amount E A 
OHACCT 34 String*45 Overhead Account E A  Mask: %-45C
OVERHD 35 Integer Overhead Type E A  List:3 entries
1 = None
2 = Flat Rate Per Unit
5 = Percentage of Cost
OHEADRATE 36 BCD*10.6 Overhead Rate E A 
HEADPER 37 BCD*5.5 Overhead Percentage E A 
OHSR 38 BCD*10.3 Transaction Overhead Amount E A 
OHHM 39 BCD*10.3 Transaction Overhead Amount E A 
BILLRATE 40 BCD*10.6 Billing Rate E A 
TOTCOSTSR 41 BCD*10.3 Total Cost E A 
TOTCOSTHM 42 BCD*10.3 Total Cost E A 
TOTBILLSR 43 BCD*10.3 Total Billable Amount E A 
TOTBILLHM 44 BCD*10.3 Total Billable Amount E A 
PAYRACCT 45 String*45 Payroll Account E A  Mask: %-45C
WIPACCT 46 String*45 Work in Progress Account E A  Mask: %-45C
COMMENTS 47 String*250 Comments E A 
FIXEDBILL 48 Integer Bill Amount Based On E A  List:2 entries
1 = Invoice This Amount
2 = Invoice Based on Exchange Rate
RATE 49 BCD*8.7 Exchange Rate E A 
RATETYPE 50 String*2 Rate Type E A  Mask: %-2N
RATEDATE 51 Date Rate Date E A 
RATEOP 52 Integer Rate Operator E A  List:2 entries
1 = Multiply
2 = Divide
RATEOVER 53 Boolean Rate Override E A  List:2 entries
0 = False
1 = True
RATESPREAD 54 BCD*8.7 Rate Spread E A 
TAUTH1 55 String*12 Tax Authority 1 E A  Mask: %-12N
TAUTH2 56 String*12 Tax Authority 2 E A  Mask: %-12N
TAUTH3 57 String*12 Tax Authority 3 E A  Mask: %-12N
TAUTH4 58 String*12 Tax Authority 4 E A  Mask: %-12N
TAUTH5 59 String*12 Tax Authority 5 E A  Mask: %-12N
TCLASS1 60 Integer Tax Class 1 E A 
TCLASS2 61 Integer Tax Class 2 E A 
TCLASS3 62 Integer Tax Class 3 E A 
TCLASS4 63 Integer Tax Class 4 E A 
TCLASS5 64 Integer Tax Class 5 E A 
TINCLUDED1 65 Boolean Tax Included 1 E A 
TINCLUDED2 66 Boolean Tax Included 2 E A 
TINCLUDED3 67 Boolean Tax Included 3 E A 
TINCLUDED4 68 Boolean Tax Included 4 E A 
TINCLUDED5 69 Boolean Tax Included 5 E A 
PROJTYPE 70 Integer ^2 Type E A C  List:3 entries
1 = Time and Materials
2 = Fixed Price
3 = Cost Plus
CONTSTYLE 71 Integer ^1 Style E A C  List:2 entries
1 = Standard
2 = Basic
CUSTOMER 72 String*12 Customer E A C  Mask: %-12C
REVREC 73 Integer Accounting Method E A C  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 74 Integer Invoice Type E A C  List:2 entries
1 = Item
2 = Summary
VALUES 75 Long Optional Fields E A C 
ADJUSTED 76 Integer E A 
GLDDESC 77 String*60 G/L Detail Description E A 
GLDREF 78 String*60 G/L Detail Reference E A 
GLCOMMENT 79 String*250 G/L Detail Comment E A 
RESOURCE 80 String*24 Resource E A