View: Reopen Worksheet Detail Audit

RotoID: PM0206
Table: PMRODA
Protocol: Flat
DLL:PMRODA

Keys: 3

Title Fields
SEQ, DLINENUM
SEQ, DDETAIL
SEQ, FMTCONTNO, PROJECT

Fields: 18

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 E A 
TCREDIT 14 BCD*10.3 Total Credits E A 
VALUES 15 Long Optional Fields E A 
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 

This page was generated on 2023-Aug-31

© 2023 Sage Software, Inc. All rights reserved. Reproduction of part or all of the contents in any form is prohibited unless for personal use. None of the content of this article may be copied or otherwise incorporated into any other document, publication or other work in any form (whether written, electronic or other format).

Sage Software, Inc. makes no warranties, representations or undertakings about any of the content of articles (including, without limitation, any as to the quality, accuracy, completeness or fitness for any particular purpose of such content).