# View: RR Worksheet Detail Audit

RotoID: PM0096
Table: PMRWDA
Protocol: Flat
DLL: PMRWDA

## Compositions: 0

## Keys: 3

Title | Fields
--- | ---
| SEQ, DLINENUM
| SEQ, DDETAIL
| SEQ, CONTRACT, PROJECT, CATEGORY

## Fields: 26

Field | Index | Type | Title | Attributes | Presentation
--- | --- | --- | --- | --- | ---
SEQ | 1 | Long | Sequence | E A K R |
DLINENUM | 2 | Long | Line Number | E A K R |
DDETAIL | 3 | Long | Detail Number | E A |
CONTRACT | 4 | String*16 | Contract | E A | Mask: %-16C
PROJECT | 5 | String*16 | Project | E A | Mask: %-16N
CATEGORY | 6 | String*16 | Category | E A | Mask: %-16N
PROJTYPE | 7 | Integer | Project Type | E A | List: 3 entries
1 | = | Time and Materials
2 | = | Fixed Price
3 | = | Cost Plus
ACCTMETD | 8 | Integer | Accounting Method | E A | 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 | 9 | BCD*5.5 | Percentage Complete | E A |
TCURCOSTHM | 10 | BCD*10.3 | Current Total Cost | E A |
TCURREVSR | 11 | BCD*10.3 | Total Cur. Revenue Est. | E A |
TCURREVHM | 12 | BCD*10.3 | Total Cur. Revenue Est. | E A |
TRECCOSTHM | 13 | BCD*10.3 | Total Cost Recognized | E A |
TRECREVSR | 14 | BCD*10.3 | Total Revenue Recognized | E A |
TRECREVHM | 15 | BCD*10.3 | Total Revenue Recognized | E A |
RATE | 16 | BCD*8.7 | Rate | E A |
RATETYPE | 17 | String*2 | Rate Type | E A |
RATEDATE | 18 | Date | Rate Date | E A |
RATEOP | 19 | Integer | Rate Operator | E A | List: 2 entries
1 | = | Multiply
2 | = | Divide
PROJSTAT | 20 | Integer | Project Status | E A | List: 7 entries
10 | = | Estimate
20 | = | Approved
30 | = | Open
40 | = | On Hold
70 | = | Inactive
60 | = | Completed
50 | = | Closed
STATUS | 21 | Integer | Contract Status | E A | List: 7 entries
10 | = | Estimate
20 | = | Approved
30 | = | Open
40 | = | On Hold
70 | = | Inactive
60 | = | Completed
50 | = | Closed
CCY | 22 | String*3 | Currency | E A | Mask: %-3N
VALUES | 23 | Long | Optional Fields | E A C |
GLDDESC | 24 | String*60 | G/L Detail Reference | E A |
GLDREF | 25 | String*60 | G/L Detail Description | E A |
GLCOMMENT | 26 | String*250 | G/L Detail Comment | E A |

This page was generated on 2009-Nov-19

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