View: Timecard

RotoID: PM0040
Table: PMTIMEH
Protocol: Header, Key auto generate
DLL:PMTIMEH

Compositions: 4

RotoID Tables Title DLL
PM0041 PMTIMED Timecard Time Detail PMTIMED
PM0113 PMTIMEE Timecard Expense Detail PMTIMEE
PM0115 PMTIMET Timecard Time Totals PMTIMET
PM0532 PMTIMHO Timecard Optional Field PMTIMHO

Keys: 5

Title Fields
Sequence SEQ
Timecard Number TIMECARDNO
Staff/Timecard Number STAFFCODE, TIMECARDNO
Transaction Status/Timecard Numb TRANSTAT, TIMECARDNO
Status/Timecard Number COMPLETE, TIMECARDNO

Fields: 69

Field Index Type Title Attributes Presentation
SEQ 1 Long Sequence E A K R 
TIMECARDNO 2 String*16 Timecard Number E A  Mask: %-6N
TRANSDATE 3 Date Transaction Date E A X 
FISCALYEAR 4 String*4 Fiscal Year A  Mask: %04D
FISCALPER 5 Integer Fiscal Period A  List:13 entries
1 = 1
2 = 2
3 = 3
4 = 4
5 = 5
6 = 6
7 = 7
8 = 8
9 = 9
10 = 10
11 = 11
12 = 12
13 = 13
STAFFCODE 6 String*24 Employee Number E A  Mask: %-16N
NAME 7 String*60 Name E A 
REFERENCE 8 String*60 Reference E A X 
DESC 9 String*60 Description E A X 
BEGINDATE 10 Date Start Date E A X 
ENDDATE 11 Date End Date E A X 
EXTCOSTSR 12 BCD*10.3 Total Cost A 
EXTCOSTHM 13 BCD*10.3 Total Cost A 
OHSR 14 BCD*10.3 Transaction Overhead Amount A 
OHHM 15 BCD*10.3 Transaction Overhead Amount A 
LABORSR 16 BCD*10.3 Transaction Labor Amount A 
LABORHM 17 BCD*10.3 Transaction Labor Amount A 
TOTCOSTSR 18 BCD*10.3 Total Cost A 
TOTCOSTHM 19 BCD*10.3 Total Cost A 
TOTBILLSR 20 BCD*10.3 Total Billable A 
TOTBILLHM 21 BCD*10.3 Total Billable A 
TOTQTY 22 BCD*10.2 Total Hours A 
ETOTCOSTSR 23 BCD*10.3 Total Expense Cost A 
ETOTCOSTHM 24 BCD*10.3 Total Expense Cost A 
ETOTBILLSR 25 BCD*10.3 Total Expense Billable A 
ETOTBILLHM 26 BCD*10.3 Total Expense Billable A 
ETOTQTY 27 BCD*10.2 Total Expense Quantity A 
GTOTCOSTSR 28 BCD*10.3 Total Cost A 
GTOTCOSTHM 29 BCD*10.3 Total Cost A 
GTOTBILLSR 30 BCD*10.3 Total Billable Amount A 
GTOTBILLHM 31 BCD*10.3 Total Billable Amount A 
CCY 32 String*3 Staff Currency A  Mask: %-3N
RATE 33 BCD*8.7 Exchange Rate A 
RATETYPE 34 String*2 Rate Type A  Mask: %-2N
RATEDATE 35 Date Rate Date A 
RATEOP 36 Integer Rate Operator A  List:2 entries
1 = Multiply
2 = Divide
RATESPREAD 37 BCD*8.7 Rate Spread E A X 
COMPLETE 38 Integer Status E A P X  List:5 entries
0 = New
10 = Entered
20 = Ready For Approval
30 = Approved
40 = Posted
PRINTSTAT 39 Boolean Print Status E A  List:2 entries
0 = False
1 = True
TRANSTAT 40 Integer Transaction Status E A  List:4 entries
1 = Entered
2 = Imported
3 = Generated
4 = Posted
NEXTDTLNUM 41 Long Next Detail Number E A C 
PAYTYPE 42 Integer Payroll Type E A  List:3 entries
3 = None
1 = US Payroll
2 = Canadian Payroll
NUMDTL 43 Long Number of Details E A C 
HMON 44 BCD*10.2 Monday Hours E A C 
HTUE 45 BCD*10.2 Tuesday Hours E A C 
HWED 46 BCD*10.2 Wednesday Hours E A C 
HTHU 47 BCD*10.2 Thursday Hours E A C 
HFRI 48 BCD*10.2 Friday Hours E A C 
HSAT 49 BCD*10.2 Saturday Hours E A C 
HSUN 50 BCD*10.2 Sunday Hours E A C 
HWEEK 51 BCD*10.2 Weekly Hours E A C 
VALUES 52 Long Optional Fields E A C 
CREATEBY 53 String*8 Created By A C 
CREATEDT 54 Date Created On A C 
CREATETM 55 Time Created At A C 
APPROVEBY 56 String*8 Approved By A C 
APPROVEDT 57 Date Approved On A C 
APPROVETM 58 Time Approved At A C 
POSTEDBY 59 String*8 Posted By A C 
POSTEDDT 60 Date Posted On A C 
POSTEDTM 61 Time Posted At A C 
GLHDESC 62 String*60 G/L Entry Description E A 
ENTEREDBY 63 String*8 Entered By E A 
DATEBUS 64 Date Posting Date E A X 
BMETER 1000 Integer Show progress bar during posting E A C  List:3 entries
0 = No meter
1 = Meter
2 = Meter but no cancel button
USERID 1001 String*8 User ID A C 
LSTAFF 1002 String*16 User ID A C 
FUNCTION 1003 Integer Function E A C  List:2 entries
0 = None
10 = Load Optional Fields
BCANSEE 1004 Integer Signon user can see this timecar A C 

This page was generated on 2022-Aug-18

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