# 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 2009-Nov-19

Copyright © 2001–2009 Sage Software, Inc. All rights reserved.