View: RR Worksheet Detail Audit

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

Keys: 3

Title Fields

SEQDLINENUM
SEQDDETAIL
SEQCONTRACTPROJECTCATEGORY

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 ^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 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 ^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 
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