# Table: Timecard

Table: PMTIMEH
View: PM0040
Record length: 651
Flags: A R

## Keys: 5

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

## Fields: 65

Field | Type | Title | Presentation
--- | --- | --- | ---
SEQ | Long | Sequence |
AUDTDATE | Date |  |
AUDTTIME | Time |  |
AUDTUSER | String*8 |  |
AUDTORG | String*6 |  |
TIMECARDNO | String*16 | Timecard Number | Mask: %-6N
TRANSDATE | Date | Date |
FISCALYEAR | String*4 | Fiscal Year | Mask: %04D
FISCALPER | Integer | Fiscal Period | 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 | String*24 | Employee Number | Mask: %-16N
NAME | String*60 | Name |
REFERENCE | String*60 | Reference |
DESC | String*60 | Description |
BEGINDATE | Date | Start Date |
ENDDATE | Date | End Date |
EXTCOSTSR | BCD*10.3 | Total Cost |
EXTCOSTHM | BCD*10.3 | Total Cost |
OHSR | BCD*10.3 | Transaction Overhead Amount |
OHHM | BCD*10.3 | Transaction Overhead Amount |
LABORSR | BCD*10.3 | Transaction Labor Amount |
LABORHM | BCD*10.3 | Transaction Labor Amount |
TOTCOSTSR | BCD*10.3 | Total Cost |
TOTCOSTHM | BCD*10.3 | Total Cost |
TOTBILLSR | BCD*10.3 | Total Billable |
TOTBILLHM | BCD*10.3 | Total Billable |
TOTQTY | BCD*10.2 | Total Hours |
ETOTCOSTSR | BCD*10.3 | Total Expense Cost |
ETOTCOSTHM | BCD*10.3 | Total Expense Cost |
ETOTBILLSR | BCD*10.3 | Total Expense Billable |
ETOTBILLHM | BCD*10.3 | Total Expense Billable |
ETOTQTY | BCD*10.2 | Total Expense Quantity |
GTOTCOSTSR | BCD*10.3 | Total Cost |
GTOTCOSTHM | BCD*10.3 | Total Cost |
GTOTBILLSR | BCD*10.3 | Total Billable Amount |
GTOTBILLHM | BCD*10.3 | Total Billable Amount |
CCY | String*3 | Staff Currency | Mask: %-3N
RATE | BCD*8.7 | Exchange Rate |
RATETYPE | String*2 | Rate Type | Mask: %-2N
RATEDATE | Date | Rate Date |
RATEOP | Integer | Rate Operator | List: 2 entries
1 | = | Multiply
2 | = | Divide
RATESPREAD | BCD*8.7 | Rate Spread |
COMPLETE | Integer | Status | List: 5 entries
0 | = | New
10 | = | Entered
20 | = | Ready For Approval
30 | = | Approved
40 | = | Posted
PRINTSTAT | Boolean | Print Status | List: 2 entries
0 | = | False
1 | = | True
TRANSTAT | Integer | Transaction Status | List: 4 entries
1 | = | Entered
2 | = | Imported
3 | = | Generated
4 | = | Posted
NEXTDTLNUM | Long | Next Detail Number |
PAYTYPE | Integer | Payroll Type | List: 3 entries
3 | = | None
1 | = | US Payroll
2 | = | Canadian Payroll
NUMDTL | Long | Number of Details |
HMON | BCD*10.2 | Monday Hours |
HTUE | BCD*10.2 | Tuesday Hours |
HWED | BCD*10.2 | Wednesday Hours |
HTHU | BCD*10.2 | Thursday Hours |
HFRI | BCD*10.2 | Friday Hours |
HSAT | BCD*10.2 | Saturday Hours |
HSUN | BCD*10.2 | Sunday Hours |
HWEEK | BCD*10.2 | Weekly Hours |
VALUES | Long | Optional Fields |
CREATEBY | String*8 | Created By |
CREATEDT | Date | Created On |
CREATETM | Time | Created At |
APPROVEBY | String*8 | Approved By |
APPROVEDT | Date | Approved On |
APPROVETM | Time | Approved At |
POSTEDBY | String*8 | Posted By |
POSTEDDT | Date | Posted On |
POSTEDTM | Time | Posted At |

This page was generated on 2006-Sep-07

Copyright © 2001–2005 Sage Accpac International, Inc.