View: Revise Estimates Audit

RotoID: PM0060
Table: PMCHNHA
Protocol: Flat
DLL:PMCHNGHA

Keys: 4

Title Fields
Posting Sequence POSTSEQNO
Sequence/Posting Sequence SEQ, POSTSEQNO
Revise Estimate Number CHNGORDNO
Sequence/Transaction date SEQ, TRANSDATE

Fields: 37

Field Index Type Title Attributes Presentation
POSTSEQNO 1 Long Posting Sequence E A K R 
SEQ 2 Long Sequence E A 
POSTDATE 3 Date Posting Date E A 
CHNGORDNO 4 String*16 Revise Estimate Number E A 
TRANSDATE 5 Date Transaction Date E A 
FISCALYEAR 6 String*4 Fiscal Year E A 
FISCALPER 7 Integer Fiscal Period E A 
REFERENCE 8 String*60 Reference E A 
DESC 9 String*60 Description E A 
CTOTQTY 10 BCD*10.5 Total Quantity E A 
RTOTQTY 11 BCD*10.5 Total Quantity E A 
CEXTCOSTSR 12 BCD*10.3 Current Extended Cost E A 
REXTCOSTSR 13 BCD*10.3 Revised Extended Cost E A 
CEXTCOSTHM 14 BCD*10.3 Current Extended Cost E A 
REXTCOSTHM 15 BCD*10.3 Revised Extended Cost E A 
CTOTCOSTSR 16 BCD*10.3 Total Cost Estimate Amount E A 
RTOTCOSTSR 17 BCD*10.3 Total Cost Estimate Amount E A 
CTOTCOSTHM 18 BCD*10.3 Total Cost Estimate Amount E A 
RTOTCOSTHM 19 BCD*10.3 Total Cost Estimate Amount E A 
CTOTBILLSR 20 BCD*10.3 Total Billing Estimate Amount E A 
RTOTBILLSR 21 BCD*10.3 Total Billing Estimate Amount E A 
CTOTBILLHM 22 BCD*10.3 Total Billing Estimate Amount E A 
RTOTBILLHM 23 BCD*10.3 Total Billing Estimate Amount E A 
COMPLETE 24 Integer Status E A 
PRINTSTAT 25 Boolean Printed E A 
TRANSTAT 26 Integer Transaction Status E A 
NUMDTL 27 Long Number of Details E A C 
CREATEBY 28 String*8 Created By E A C 
CREATEDT 29 Date Created On E A C 
CREATETM 30 Time Created At E A C 
APPROVEBY 31 String*8 Approved By E A C 
APPROVEDT 32 Date Approved On E A C 
APPROVETM 33 Time Approved At E A C 
POSTEDBY 34 String*8 Posted By E A C 
POSTEDDT 35 Date Posted On E A C 
POSTEDTM 36 Time Posted At E A C 
DATEBUS 37 Date Posting Date 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).