View: Timecard Time Detail

RotoID: PM0041
Table: PMTIMED
Protocol: Detail, Sequenced revisions, Key auto generate
DLL:PMTIMED

Compositions: 3

RotoID Tables Title DLL
PM0040 PMTIMEH Timecard PMTIMEH
PM0115 PMTIMET Timecard Time Totals PMTIMET
PM0531 PMTIMDO Timecard Detail Optional Field PMTIMDO

Keys: 3

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

Fields: 84

Field Index Type Title Attributes Presentation
SEQ 1 Long Sequence E A K R 
LINENO 2 Integer Line Number E A K R 
TIMECARDNO 3 String*16 Timecard Number E A C  Mask: %-6N
FMTCONTNO 4 String*16 ^1 E A X  Mask: %-16C
CONTRACT 5 String*16 ^1 E A X  Mask: %-16C
PROJECT 6 String*16 ^2 E A X  Mask: %-16N
CATEGORY 7 String*16 ^3 E A X  Mask: %-16N
DETAILNUM 8 Long Detail Number E A 
EARNINGS 9 String*16 Earnings Code E A P X  Mask: %-16C
DESC 10 String*60 Description A X 
TDATE 11 Date Transaction Date A X 
TIMETYPE 12 Integer Time Type A X  List:3 entries
1 = Hour
2 = Vacation
3 = Sick
BILLTYPE 13 Integer Billing Type A X  List:3 entries
2 = Billable
3 = No Charge
1 = Non-billable
STARTTIME 14 Time Start Time A X 
ENDTIME 15 Time End Time A X 
QUANTITY 16 BCD*10.2 Hours A X 
ARITEM 17 String*16 A/R Item No. A X  Mask: %-16C
UOM 18 String*10 Unit of Measure A X  Mask: %-10C
ESTBILLCCY 19 Integer Revenue And Cost Currency A  List:3 entries
1 = Revenue and Costs in Functional Currency
2 = Revenue in Customer Currency
3 = Revenue and Costs in Customer Currency
COSTCCY 20 String*3 Cost Currency A  Mask: %-3N
BILLCCY 21 String*3 Billing Currency A  Mask: %-3N
UNITCOST 22 BCD*10.6 Unit Cost A X 
EXTCOSTSR 23 BCD*10.3 Extended Cost A X 
EXTCOSTHM 24 BCD*10.3 Extended Cost A 
EXTBILLSR 25 BCD*10.3 Extended Billing Amount A X 
EXTBILLHM 26 BCD*10.3 Reserved A 
LABOR 27 Integer Labor Type A X  List:3 entries
1 = None
2 = Flat Rate Per Labor Hour/Unit
3 = Percentage of Labor Cost
LABORRATE 28 BCD*10.6 Labor Rate A X 
LABORPER 29 BCD*5.5 Labor Percentage A X 
LABORSR 30 BCD*10.3 Transaction Labor Amount A X 
LABORHM 31 BCD*10.3 Transaction Labor Amount A X 
OVERHD 32 Integer Overhead Type A X  List:3 entries
1 = None
2 = Flat Rate Per Unit
5 = Percentage of Cost
OHEADRATE 33 BCD*10.6 Overhead Rate A X 
HEADPER 34 BCD*5.5 Overhead Percentage A X 
OHSR 35 BCD*10.3 Transaction Overhead Amount A X 
OHHM 36 BCD*10.3 Transaction Overhead Amount A X 
BILLRATE 37 BCD*10.6 Billing Rate A X 
TOTCOSTSR 38 BCD*10.3 Total Cost A 
TOTCOSTHM 39 BCD*10.3 Total Cost A 
TOTBILLSR 40 BCD*10.3 Total Billable Amount A 
TOTBILLHM 41 BCD*10.3 Total Billable Amount A 
PAYRACCT 42 String*45 Payroll Account A X  Mask: %-45C
WIPACCT 43 String*45 Work In Progress Account A X  Mask: %-45C
OHACCT 44 String*45 Overhead Account A X  Mask: %-45C
LABORACCT 45 String*45 Labor Account A X  Mask: %-45C
COMMENTS 46 String*250 Comments A X 
FIXEDBILL 47 Integer Bill Amount Based On A X  List:2 entries
1 = Invoice This Amount
2 = Invoice Based on Exchange Rate
TAUTH1 48 String*12 Tax Authority 1 A  Mask: %-12N
TAUTH2 49 String*12 Tax Authority 2 A  Mask: %-12N
TAUTH3 50 String*12 Tax Authority 3 A  Mask: %-12N
TAUTH4 51 String*12 Tax Authority 4 A  Mask: %-12N
TAUTH5 52 String*12 Tax Authority 5 A  Mask: %-12N
TCLASS1 53 Integer Tax Class 1 A X 
TCLASS2 54 Integer Tax Class 2 A X 
TCLASS3 55 Integer Tax Class 3 A X 
TCLASS4 56 Integer Tax Class 4 A X 
TCLASS5 57 Integer Tax Class 5 A X 
TINCLUDED1 58 Boolean Tax Included 1 A X 
TINCLUDED2 59 Boolean Tax Included 2 A X 
TINCLUDED3 60 Boolean Tax Included 3 A X 
TINCLUDED4 61 Boolean Tax Included 4 A X 
TINCLUDED5 62 Boolean Tax Included 5 A X 
PROJTYPE 63 Integer ^2 Type A C X  List:3 entries
1 = Time and Materials
2 = Fixed Price
3 = Cost Plus
CONTSTYLE 64 Integer ^1 Style A C X  List:2 entries
1 = Standard
2 = Basic
CUSTOMER 65 String*12 Customer A C X  Mask: %-12C
REVREC 66 Integer Accounting Method A C X  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 67 Integer Invoice Type A C X  List:2 entries
1 = Item
2 = Summary
VALUES 68 Long Optional Fields A C X 
GLDDESC 69 String*60 G/L Detail Description A X 
GLDREF 70 String*60 G/L Detail Reference A X 
GLCOMMENT 71 String*250 G/L Detail Comment A X 
RESOURCE 72 String*24 Resource A X 
PAYRDESC 1003 String*60 Description A C 
WIPDESC 1004 String*60 Description A C 
ITEMDESC 1005 String*60 Description A C 
OHDESC 1006 String*60 Description A C 
LABORDESC 1007 String*60 Description A C 
WARN 1008 Boolean Description E A C 
CONTDESC 1009 String*60 Description A C 
PROJDESC 1010 String*60 Description A C 
CATDESC 1011 String*60 Description A C 
FUNCTION 1012 Integer Function E A C  List:2 entries
0 = None
10 = Load Optional Fields
HASOPT 1013 Boolean Optional Fields E A C  List:2 entries
0 = No
1 = Yes
TIMET 1014 Boolean Called by PMTIMET? E A C 

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).