# Table: Timecard Expense Detail Audit

Table: PMTIMEA
View: PM0114
Record length: 1391
Flags: A R

## Keys: 4

Title | Flags | 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 | D | TIMECARDNO, DETAILNUM

## Fields: 86

Field | Type | Title | Presentation
--- | --- | --- | ---
POSTSEQNO | Long | Posting Sequence |
LINENO | Integer | Line Number |
AUDTDATE | Date |  |
AUDTTIME | Time |  |
AUDTUSER | String*8 |  |
AUDTORG | String*6 |  |
SEQ | Long | Sequence |
TIMECARDNO | String*16 | Timecard Number | Mask: %-6N
FMTCONTNO | String*16 | Contract |
CONTRACT | String*16 | Contract | Mask: %-16C
PROJECT | String*16 | Project | Mask: %-16N
CATEGORY | String*16 | Category | Mask: %-16N
DETAILNUM | Long | Detail Number |
EXPENSE | String*16 | Expense Code |
DESC | String*60 | Description |
TDATE | Date | Transaction Date |
EXPTYPE | Integer | Expense Type |
BILLTYPE | Integer | Billing Type | List: 3 entries
2 | = | Billable
3 | = | No Charge
1 | = | Non-billable
QUANTITY | BCD*10.2 | Quantity |
ARITEM | String*16 | A/R Item No. | Mask: %-16C
UOM | String*10 | Unit of Measure |
COSTCCY | String*3 | Cost Currency | Mask: %-3N
BILLCCY | String*3 | Billing Currency | Mask: %-3N
UNITCOST | BCD*10.6 | Unit Cost |
EXTCOSTSR | BCD*10.3 | Extended Cost |
EXTCOSTHM | BCD*10.3 | Extended Cost |
EXTBILLSR | BCD*10.3 | Extended Billing Amount |
EXTBILLHM | BCD*10.3 | Reserved |
LABACCT | String*45 | Labor Account | Mask: %-45C
LABOR | Integer | Labor Type | List: 3 entries
1 | = | None
2 | = | Flat Rate Per Labor Hour/Unit
3 | = | Percentage of Labor Cost
LABORRATE | BCD*10.6 | Labor Rate |
LABORPER | BCD*5.5 | Labor Percentage |
LABORSR | BCD*10.3 | Transaction Labor Amount |
LABORHM | BCD*10.3 | Transaction Labor Amount |
OHACCT | String*45 | Overhead Account | Mask: %-45C
OVERHD | Integer | Overhead Type | List: 3 entries
1 | = | None
2 | = | Flat Rate Per Unit
5 | = | Percentage of Cost
OHEADRATE | BCD*10.6 | Overhead Rate |
HEADPER | BCD*5.5 | Overhead Percentage |
OHSR | BCD*10.3 | Transaction Overhead Amount |
OHHM | BCD*10.3 | Transaction Overhead Amount |
BILLRATE | BCD*10.6 | Billing Rate |
TOTCOSTSR | BCD*10.3 | Total Cost |
TOTCOSTHM | BCD*10.3 | Total Cost |
TOTBILLSR | BCD*10.3 | Total Billable Amount |
TOTBILLHM | BCD*10.3 | Total Billable Amount |
EXPACCT | String*45 | Employee Expense Account | Mask: %-45C
WIPACCT | String*45 | Work in Progress Account | Mask: %-45C
COMMENTS | String*250 | Comments |
CRATE | BCD*8.7 | Exchange Rate |
CRATETYPE | String*2 | Rate Type |
CRATEDATE | Date | Rate Date |
CRATEOP | Integer | Rate Operator |
CRATEOVER | Boolean | Rate Override |
FIXEDBILL | Integer | Bill Amount Based On | List: 2 entries
1 | = | Invoice This Amount
2 | = | Invoice Based on Exchange Rate
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
RATEOVER | Boolean | Rate Override | List: 2 entries
0 | = | False
1 | = | True
TAUTH1 | String*12 | Tax Authority 1 | Mask: %-12N
TAUTH2 | String*12 | Tax Authority 2 | Mask: %-12N
TAUTH3 | String*12 | Tax Authority 3 | Mask: %-12N
TAUTH4 | String*12 | Tax Authority 4 | Mask: %-12N
TAUTH5 | String*12 | Tax Authority 5 | Mask: %-12N
TCLASS1 | Integer | Tax Class 1 |
TCLASS2 | Integer | Tax Class 2 |
TCLASS3 | Integer | Tax Class 3 |
TCLASS4 | Integer | Tax Class 4 |
TCLASS5 | Integer | Tax Class 5 |
TINCLUDED1 | Boolean | Tax Included 1 |
TINCLUDED2 | Boolean | Tax Included 2 |
TINCLUDED3 | Boolean | Tax Included 3 |
TINCLUDED4 | Boolean | Tax Included 4 |
TINCLUDED5 | Boolean | Tax Included 5 |
PROJTYPE | Integer | Project Type | List: 3 entries
1 | = | Time and Materials
2 | = | Fixed Price
3 | = | Cost Plus
CONTSTYLE | Integer | Contract Style | List: 2 entries
1 | = | Standard
2 | = | Basic
CUSTOMER | String*12 | Customer | Mask: %-12C
REVREC | Integer | Accounting Method | 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 | Integer | Invoice Type | List: 2 entries
1 | = | Item
2 | = | Summary
VALUES | Long | Optional Fields |
ADJUSTED | Integer |  |
GLDDESC | String*60 | G/L Detail Description |
GLDREF | String*60 | G/L Detail Reference |
GLCOMMENT | String*250 | G/L Detail Comment |
RESOURCE | String*24 | Resource |
TYPE | Integer | Cost Class |

This page was generated on 2009-Nov-19

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