# 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 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 2008-May-01

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