View: Timecard Expense Detail

RotoID: PM0113
Table: PMTIMEE
Protocol: Detail, Sequenced revisions, Key auto generate
DLL:PMTIMEE

Compositions: 2

RotoID Tables Title DLL
PM0040 PMTIMEH Timecard PMTIMEH
PM0539 PMTIMEO Timecard Expense Optional Field PMTIMEO

Keys: 3

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

Fields: 79

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 
EXPENSE 9 String*16 Expense Code E A P X  Mask: %-16C
DESC 10 String*60 Description A X 
TDATE 11 Date Transaction Date A X 
EXPTYPE 12 Integer Expense Type A X  List:9 entries
1 = Airfares
2 = Accommodation
3 = Meals
4 = Entertainment
5 = Taxi/Hire Car
6 = Tolls
7 = Telephone
8 = Parking
9 = Other
BILLTYPE 13 Integer Billing Type A X  List:3 entries
2 = Billable
3 = No Charge
1 = Non-billable
QUANTITY 14 BCD*10.2 Quantity A C X 
ARITEM 15 String*16 A/R Item No. A X  Mask: %-16C
UOM 16 String*10 Unit of Measure A X  Mask: %-10C
COSTCCY 17 String*3 Cost Currency A  Mask: %-3N
BILLCCY 18 String*3 Billing Currency A  Mask: %-3N
UNITCOST 19 BCD*10.6 Cost Amount A X 
EXTCOSTSR 20 BCD*10.3 Cost Amount A X 
EXTCOSTHM 21 BCD*10.3 Cost Amount A 
EXTBILLSR 22 BCD*10.3 Billing Amount A X 
EXTBILLHM 23 BCD*10.3 Reserved A 
LABOR 24 Integer Reserved A X  List:3 entries
1 = None
2 = Flat Rate Per Labor Hour/Unit
3 = Percentage of Labor Cost
LABORRATE 25 BCD*10.6 Reserved A X 
LABORPER 26 BCD*5.5 Reserved A X 
LABORSR 27 BCD*10.3 Reserved A X 
LABORHM 28 BCD*10.3 Reserved A X 
OVERHD 29 Integer Reserved A X  List:3 entries
1 = None
2 = Flat Rate Per Unit
5 = Percentage of Cost
OHEADRATE 30 BCD*10.6 Reserved A X 
HEADPER 31 BCD*5.5 Reserved A X 
OHSR 32 BCD*10.3 Reserved A X 
OHHM 33 BCD*10.3 Reserved A X 
BILLRATE 34 BCD*10.6 Billing Amount A X 
TOTCOSTSR 35 BCD*10.3 Total Cost A 
TOTCOSTHM 36 BCD*10.3 Total Cost A 
TOTBILLSR 37 BCD*10.3 Total Billable Amount A 
TOTBILLHM 38 BCD*10.3 Reserved A 
EXPACCT 39 String*45 Employee Expense Account A X  Mask: %-45C
WIPACCT 40 String*45 WIP/COS Account A X  Mask: %-45C
OHACCT 41 String*45 Reserved A X  Mask: %-45C
LABORACCT 42 String*45 Reserved A X  Mask: %-45C
COMMENTS 43 String*250 Comments A X 
FIXEDBILL 44 Integer Bill Amount Based On A X 
TAUTH1 45 String*12 Tax Authority 1 A  Mask: %-12N
TAUTH2 46 String*12 Tax Authority 2 A  Mask: %-12N
TAUTH3 47 String*12 Tax Authority 3 A  Mask: %-12N
TAUTH4 48 String*12 Tax Authority 4 A  Mask: %-12N
TAUTH5 49 String*12 Tax Authority 5 A  Mask: %-12N
TCLASS1 50 Integer Tax Class 1 A X 
TCLASS2 51 Integer Tax Class 2 A X 
TCLASS3 52 Integer Tax Class 3 A X 
TCLASS4 53 Integer Tax Class 4 A X 
TCLASS5 54 Integer Tax Class 5 A X 
TINCLUDED1 55 Boolean Tax Included 1 A X 
TINCLUDED2 56 Boolean Tax Included 2 A X 
TINCLUDED3 57 Boolean Tax Included 3 A X 
TINCLUDED4 58 Boolean Tax Included 4 A X 
TINCLUDED5 59 Boolean Tax Included 5 A X 
PROJTYPE 60 Integer ^2 Type A C X  List:3 entries
1 = Time and Materials
2 = Fixed Price
3 = Cost Plus
CONTSTYLE 61 Integer ^1 Style A C X  List:2 entries
1 = Standard
2 = Basic
CUSTOMER 62 String*12 Customer A C X  Mask: %-12C
REVREC 63 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 64 Integer Invoice Type A C X  List:2 entries
1 = Item
2 = Summary
VALUES 65 Long Optional Fields A C X 
GLDDESC 66 String*60 G/L Detail Description A X 
GLDREF 67 String*60 G/L Detail Reference A X 
GLCOMMENT 68 String*250 G/L Detail Comment A X 
RESOURCE 69 String*24 Resource E A P X  Mask: %-16N
TYPE 70 Integer Cost Class A X  List:6 entries
1 = Labor
2 = Material
3 = Equipment
4 = Subcontractor
5 = Overhead
6 = Miscellaneous
RESDESC 71 String*60 A X 
FUNCTION 1001 Integer Function E A C  List:2 entries
0 = None
10 = Load Optional Fields
EXPDESC 1002 String*60 Description A C 
WIPDESC 1003 String*60 Description A C 
ITEMDESC 1004 String*60 Description A C 
CONTDESC 1009 String*60 Description A C 
PROJDESC 1010 String*60 Description A C 
CATDESC 1011 String*60 Description A C 
HASOPT 1012 Boolean Optional Fields E A C  List:2 entries
0 = No
1 = Yes

This page was generated on 2023-Aug-31

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