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 COMPLETE, CHNGORDNO

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

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).