View: Timecard Time Detail Audit

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

Keys: 4

Title Fields
Sequence/Line Number POSTSEQNO, LINENO
Sequence/Detail Number POSTSEQNO, DETAILNUM
Timecard Seq/Post Seq/Detail Num SEQ, POSTSEQNO, DETAILNUM
Timecard Seq/Post Seq/Detail Num TIMECARDNO, DETAILNUM

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 

This page was generated on 2021-Nov-24

© 2021 Sage Software, Inc. All rights reserved. Reproduction of part or all of the contents in any form is prohibited unless for personal use. None of the content of this article may be copied or otherwise incorporated into any other document, publication or other work in any form (whether written, electronic or other format).

Sage Software, Inc. makes no warranties, representations or undertakings about any of the content of articles (including, without limitation, any as to the quality, accuracy, completeness or fitness for any particular purpose of such content).