View: Reopen Worksheet Detail

RotoID: PM0202
Table: PMROD
Protocol: Detail, Sequenced revisions, Key auto generate
DLL:PMROD

Compositions: 3

RotoID Tables Title DLL

PM0201 PMROH Reopening Projects Worksheet PMROH
PM0204 PMRODD Reopen Worksheet Accounts PMRODD
PM0203 PMRODO Reopen Detail Optional Field PMRODO

Keys: 3

Title Fields

SEQDLINENUM
SEQDDETAIL
SEQFMTCONTNOPROJECT

Fields: 19

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 
FMTCONTNO 4 String*16 ^1 E A  Mask: %-16C
PROJECT 5 String*16 ^2 E A  Mask: %-16N
PROJTYPE 6 Integer ^2 Type E A  List:3 entries
1 = Time and Materials
2 = Fixed Price
3 = Cost Plus
ACCTMETD 7 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
RATE 8 BCD*8.7 Rate E A 
RATETYPE 9 String*2 Rate Type E A 
RATEDATE 10 Date Rate Date E A 
RATEOP 11 Integer Rate Operator E A  List:2 entries
1 = Multiply
2 = Divide
CCY 12 String*3 Currency E A  Mask: %-3N
TDEBIT 13 BCD*10.3 Total Debits A C 
TCREDIT 14 BCD*10.3 Total Credits A C 
VALUES 15 Long Optional Fields E A C 
GLDDESC 16 String*60 G/L Detail Reference E A 
GLDREF 17 String*60 G/L Detail Description E A 
GLCOMMENT 18 String*250 G/L Detail Comment E A 
HASOPT 1001 Boolean Optional Fields E A C  List:2 entries
0 = No
1 = Yes