View: Revise Estimates

RotoID: PM0058
Table: PMCHNGH
Protocol: Header, Key auto generate
DLL:PMCHNGH

Compositions: 1

RotoID Tables Title DLL

PM0059 PMCHNGD Revise Estimates Detail PMCHNGD

Keys: 3

Title Fields

Sequence SEQ
Revise Estimate Number CHNGORDNO
Status/Revise Estimate Number COMPLETECHNGORDNO

Fields: 39

Field Index Type Title Attributes Presentation

SEQ 1 Long Sequence E A K R 
CHNGORDNO 2 String*16 Revise Estimate Number E A  Mask: %-16C
TRANSDATE 3 Date Transaction Date E A X 
FISCALYEAR 4 String*4 Fiscal Year A  Mask: %04D
FISCALPER 5 Integer Fiscal Period A  List:13 entries
1 = 1
2 = 2
3 = 3
4 = 4
5 = 5
6 = 6
7 = 7
8 = 8
9 = 9
10 = 10
11 = 11
12 = 12
13 = 13
REFERENCE 6 String*60 Reference E A X 
DESC 7 String*60 Description E A X 
CTOTQTY 8 BCD*10.5 Total Quantity A 
RTOTQTY 9 BCD*10.5 Total Quantity A 
CEXTCOSTSR 10 BCD*10.3 Current Extended Cost A 
REXTCOSTSR 11 BCD*10.3 Revised Extended Cost A 
CEXTCOSTHM 12 BCD*10.3 Current Extended Cost A 
REXTCOSTHM 13 BCD*10.3 Revised Extended Cost A 
CTOTCOSTSR 14 BCD*10.3 Total Cost Estimate Amount A 
RTOTCOSTSR 15 BCD*10.3 Total Cost Estimate Amount A 
CTOTCOSTHM 16 BCD*10.3 Total Cost Estimate Amount A 
RTOTCOSTHM 17 BCD*10.3 Total Cost Estimate Amount A 
CTOTBILLSR 18 BCD*10.3 Total Billing Estimate Amount A 
RTOTBILLSR 19 BCD*10.3 Total Billing Estimate Amount A 
CTOTBILLHM 20 BCD*10.3 Total Billing Estimate Amount A 
RTOTBILLHM 21 BCD*10.3 Total Billing Estimate Amount A 
COMPLETE 22 Integer Status E A P X  List:4 entries
0 = New
10 = Entered
30 = Approved
40 = Posted
PRINTSTAT 23 Boolean Printed E A  List:2 entries
0 = False
1 = True
TRANSTAT 24 Integer Transaction Status E A  List:4 entries
1 = Entered
2 = Imported
3 = Generated
4 = Posted
NEXTDTLNUM 25 Long Next Detail Number E A 
NUMDTL 26 Long Number of Details E A C 
CREATEBY 27 String*8 Created By A C 
CREATEDT 28 Date Created On A C 
CREATETM 29 Time Created At A C 
APPROVEBY 30 String*8 Approved By A C 
APPROVEDT 31 Date Approved On A C 
APPROVETM 32 Time Approved At A C 
POSTEDBY 33 String*8 Posted By A C 
POSTEDDT 34 Date Posted On A C 
POSTEDTM 35 Time Posted At A C 
ENTEREDBY 36 String*8 Entered By E A C 
DATEBUS 37 Date Posting Date E A X 
BMETER 1000 Integer Show progress bar during posting E A C  List:3 entries
0 = No meter
1 = Meter
2 = Meter but no cancel button
FUNCTION 1001 Integer Function E A C  List:1 entries
0 = None