View: RR Worksheet Detail
RotoID: PM0092
Table: PMRWDProtocol: Detail, Sequenced revisions, Key auto generate
DLL:PMRWD
Compositions: 3
Keys: 3
Fields: 30
| 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 |
^1 |
E A |
Mask: %-16C |
| PROJECT |
5 |
String*16 |
^2 |
E A |
Mask: %-16N |
| CATEGORY |
6 |
String*16 |
^3 |
E A |
Mask: %-16N |
| PROJTYPE |
7 |
Integer |
^2 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 |
A X |
|
| 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
|
| PROJSTAT |
20 |
Integer |
^2 Status |
E A |
List:7 entries
| 10 |
= |
Estimate |
| 20 |
= |
Approved |
| 30 |
= |
Open |
| 40 |
= |
On Hold |
| 70 |
= |
Inactive |
| 60 |
= |
Completed |
| 50 |
= |
Closed |
|
| STATUS |
21 |
Integer |
^1 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 |
|
| TACTCOSTHM |
24 |
BCD*10.3 |
Actual Total Cost |
E A |
|
| GLDDESC |
25 |
String*60 |
G/L Detail Reference |
E A |
|
| GLDREF |
26 |
String*60 |
G/L Detail Description |
E A |
|
| GLCOMMENT |
27 |
String*250 |
G/L Detail Comment |
E A |
|
| UNREGCOST |
28 |
Boolean |
Reserved |
E A |
|
| HASOPT |
1001 |
Boolean |
Optional Fields |
E A C |
List:2 entries
|
| FUNCTION |
1002 |
Integer |
Function |
E A C |
List:1 entries
|
|