# View: Timecard Expense Detail Audit

RotoID: PM0114
Table: PMTIMEA
Protocol: Flat
DLL: PMTIMEA

## Compositions: 0

## Keys: 4

Title | Fields
--- | ---
Sequence/Line Number | POSTSEQNO, LINENO
Sequence/Detail Number | POSTSEQNO, DETAILNUM
Timecard Seq/Post Seq/Detail Num | SEQ, POSTSEQNO, DETAILNUM
Timecard Seq/Post Seq/Detail Num | TIMECARDNO, DETAILNUM

## Fields: 82

Field | Index | Type | Title | Attributes | Presentation
--- | --- | --- | --- | --- | ---
POSTSEQNO | 1 | Long | Posting Sequence | E A K R |
LINENO | 2 | Integer | Line Number | E A K R |
SEQ | 3 | Long | Sequence | E A |
TIMECARDNO | 4 | String*16 | Timecard Number | E A | Mask: %-6N
FMTCONTNO | 5 | String*16 | Contract | E A |
CONTRACT | 6 | String*16 | Contract | E A | Mask: %-16C
PROJECT | 7 | String*16 | Project | E A | Mask: %-16N
CATEGORY | 8 | String*16 | Category | E A | Mask: %-16N
DETAILNUM | 9 | Long | Detail Number | E A |
EXPENSE | 10 | String*16 | Expense Code | E A |
DESC | 11 | String*60 | Description | E A |
TDATE | 12 | Date | Transaction Date | E A |
EXPTYPE | 13 | Integer | Expense Type | E A |
BILLTYPE | 14 | Integer | Billing Type | E A | List: 3 entries
2 | = | Billable
3 | = | No Charge
1 | = | Non-billable
QUANTITY | 15 | BCD*10.2 | Quantity | E A |
ARITEM | 16 | String*16 | A/R Item No. | E A | Mask: %-16C
UOM | 17 | String*10 | Unit of Measure | E A |
COSTCCY | 18 | String*3 | Cost Currency | E A | Mask: %-3N
BILLCCY | 19 | String*3 | Billing Currency | E A | Mask: %-3N
UNITCOST | 20 | BCD*10.6 | Unit Cost | E A |
EXTCOSTSR | 21 | BCD*10.3 | Extended Cost | E A |
EXTCOSTHM | 22 | BCD*10.3 | Extended Cost | E A |
EXTBILLSR | 23 | BCD*10.3 | Extended Billing Amount | E A |
EXTBILLHM | 24 | BCD*10.3 | Reserved | E A |
LABACCT | 25 | String*45 | Labor Account | E A | Mask: %-45C
LABOR | 26 | Integer | Labor Type | E A | List: 3 entries
1 | = | None
2 | = | Flat Rate Per Labor Hour/Unit
3 | = | Percentage of Labor Cost
LABORRATE | 27 | BCD*10.6 | Labor Rate | E A |
LABORPER | 28 | BCD*5.5 | Labor Percentage | E A |
LABORSR | 29 | BCD*10.3 | Transaction Labor Amount | E A |
LABORHM | 30 | BCD*10.3 | Transaction Labor Amount | E A |
OHACCT | 31 | String*45 | Overhead Account | E A | Mask: %-45C
OVERHD | 32 | Integer | Overhead Type | E A | List: 3 entries
1 | = | None
2 | = | Flat Rate Per Unit
5 | = | Percentage of Cost
OHEADRATE | 33 | BCD*10.6 | Overhead Rate | E A |
HEADPER | 34 | BCD*5.5 | Overhead Percentage | E A |
OHSR | 35 | BCD*10.3 | Transaction Overhead Amount | E A |
OHHM | 36 | BCD*10.3 | Transaction Overhead Amount | E A |
BILLRATE | 37 | BCD*10.6 | Billing Rate | E A |
TOTCOSTSR | 38 | BCD*10.3 | Total Cost | E A |
TOTCOSTHM | 39 | BCD*10.3 | Total Cost | E A |
TOTBILLSR | 40 | BCD*10.3 | Total Billable Amount | E A |
TOTBILLHM | 41 | BCD*10.3 | Total Billable Amount | E A |
EXPACCT | 42 | String*45 | Employee Expense Account | E A | Mask: %-45C
WIPACCT | 43 | String*45 | Work in Progress Account | E A | Mask: %-45C
COMMENTS | 44 | String*250 | Comments | E A |
CRATE | 45 | BCD*8.7 | Exchange Rate | E A |
CRATETYPE | 46 | String*2 | Rate Type | E A |
CRATEDATE | 47 | Date | Rate Date | E A |
CRATEOP | 48 | Integer | Rate Operator | E A |
CRATEOVER | 49 | Boolean | Rate Override | E A |
FIXEDBILL | 50 | Integer | Bill Amount Based On | E A | List: 2 entries
1 | = | Invoice This Amount
2 | = | Invoice Based on Exchange Rate
RATE | 51 | BCD*8.7 | Exchange Rate | E A |
RATETYPE | 52 | String*2 | Rate Type | E A | Mask: %-2N
RATEDATE | 53 | Date | Rate Date | E A |
RATEOP | 54 | Integer | Rate Operator | E A | List: 2 entries
1 | = | Multiply
2 | = | Divide
RATEOVER | 55 | Boolean | Rate Override | E A | List: 2 entries
0 | = | False
1 | = | True
TAUTH1 | 56 | String*12 | Tax Authority 1 | E A | Mask: %-12N
TAUTH2 | 57 | String*12 | Tax Authority 2 | E A | Mask: %-12N
TAUTH3 | 58 | String*12 | Tax Authority 3 | E A | Mask: %-12N
TAUTH4 | 59 | String*12 | Tax Authority 4 | E A | Mask: %-12N
TAUTH5 | 60 | String*12 | Tax Authority 5 | E A | Mask: %-12N
TCLASS1 | 61 | Integer | Tax Class 1 | E A |
TCLASS2 | 62 | Integer | Tax Class 2 | E A |
TCLASS3 | 63 | Integer | Tax Class 3 | E A |
TCLASS4 | 64 | Integer | Tax Class 4 | E A |
TCLASS5 | 65 | Integer | Tax Class 5 | E A |
TINCLUDED1 | 66 | Boolean | Tax Included 1 | E A |
TINCLUDED2 | 67 | Boolean | Tax Included 2 | E A |
TINCLUDED3 | 68 | Boolean | Tax Included 3 | E A |
TINCLUDED4 | 69 | Boolean | Tax Included 4 | E A |
TINCLUDED5 | 70 | Boolean | Tax Included 5 | E A |
PROJTYPE | 71 | Integer | Project Type | E A C | List: 3 entries
1 | = | Time and Materials
2 | = | Fixed Price
3 | = | Cost Plus
CONTSTYLE | 72 | Integer | Contract Style | E A C | List: 2 entries
1 | = | Standard
2 | = | Basic
CUSTOMER | 73 | String*12 | Customer | E A C | Mask: %-12C
REVREC | 74 | Integer | Accounting Method | E A C | 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 | 75 | Integer | Invoice Type | E A C | List: 2 entries
1 | = | Item
2 | = | Summary
VALUES | 76 | Long | Optional Fields | E A C |
ADJUSTED | 77 | Integer |  | E A |
GLDDESC | 78 | String*60 | G/L Detail Description | E A |
GLDREF | 79 | String*60 | G/L Detail Reference | E A |
GLCOMMENT | 80 | String*250 | G/L Detail Comment | E A |
RESOURCE | 81 | String*24 | Resource | E A |
TYPE | 82 | Integer | Cost Class | E A |

This page was generated on 2009-Nov-19

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