# Table: RR Worksheet Detail

Table: PMRWD
View: PM0092
Record length: 191
Flags: A R

## Keys: 3

Title | Flags | Fields
--- | --- | ---
|  | SEQ, DLINENUM
| D M | SEQ, DDETAIL
| D M | SEQ, CONTRACT, PROJECT, CATEGORY

## Fields: 28

Field | Type | Title | Presentation
--- | --- | --- | ---
SEQ | Long | Sequence |
DLINENUM | Long | Line Number |
AUDTDATE | Date |  |
AUDTTIME | Time |  |
AUDTUSER | String*8 |  |
AUDTORG | String*6 |  |
DDETAIL | Long | Detail Number |
CONTRACT | String*16 | Contract | Mask: %-16C
PROJECT | String*16 | Project | Mask: %-16N
CATEGORY | String*16 | Category | Mask: %-16N
PROJTYPE | Integer | Project Type | List: 3 entries
1 | = | Time and Materials
2 | = | Fixed Price
3 | = | Cost Plus
ACCTMETD | 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
PERCOMP | BCD*5.5 | Percentage Complete |
TCURCOSTHM | BCD*10.3 | Current Total Cost |
TCURREVSR | BCD*10.3 | Total Cur. Revenue Est. |
TCURREVHM | BCD*10.3 | Total Cur. Revenue Est. |
TRECCOSTHM | BCD*10.3 | Total Cost Recognized |
TRECREVSR | BCD*10.3 | Total Revenue Recognized |
TRECREVHM | BCD*10.3 | Total Revenue Recognized |
RATE | BCD*8.7 | Rate |
RATETYPE | String*2 | Rate Type |
RATEDATE | Date | Rate Date |
RATEOP | Integer | Rate Operator | List: 2 entries
1 | = | Multiply
2 | = | Divide
PROJSTAT | Integer | Project Status | List: 7 entries
10 | = | Estimate
20 | = | Approved
30 | = | Open
40 | = | On Hold
70 | = | Inactive
60 | = | Completed
50 | = | Closed
STATUS | Integer | Contract Status | List: 7 entries
10 | = | Estimate
20 | = | Approved
30 | = | Open
40 | = | On Hold
70 | = | Inactive
60 | = | Completed
50 | = | Closed
CCY | String*3 | Currency | Mask: %-3N
VALUES | Long | Optional Fields |
TACTCOSTHM | BCD*10.3 | Actual Total Cost |

This page was generated on 2006-Sep-07

Copyright © 2001–2005 Sage Accpac International, Inc.