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 STAFFCODETIMECARDNO
Transaction Status/Timecard Numb TRANSTATTIMECARDNO
Status/Timecard Number COMPLETETIMECARDNO

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 C 
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