Table: Revise Estimates

Table: PMCHNGH
View: PM0058
Record length: 396
Flags: A R 

Keys: 3

Title  Flags  Fields

Sequence  SEQ
Revise Estimate Number  CHNGORDNO
Status/Revise Estimate Number  M  COMPLETE, CHNGORDNO

Fields: 41

Field  Type  Title  Presentation 

SEQ  Long  Sequence   
AUDTDATE  Date     
AUDTTIME  Time     
AUDTUSER  String*8     
AUDTORG  String*6     
CHNGORDNO  String*16  Revise Estimate Number  Mask: %-16C
TRANSDATE  Date  Transaction Date   
FISCALYEAR  String*4  Fiscal Year  Mask: %04D
FISCALPER  Integer  Fiscal Period  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  String*60  Reference   
DESC  String*60  Description   
CTOTQTY  BCD*10.5  Total Quantity   
RTOTQTY  BCD*10.5  Total Quantity   
CEXTCOSTSR  BCD*10.3  Current Extended Cost   
REXTCOSTSR  BCD*10.3  Revised Extended Cost   
CEXTCOSTHM  BCD*10.3  Current Extended Cost   
REXTCOSTHM  BCD*10.3  Revised Extended Cost   
CTOTCOSTSR  BCD*10.3  Total Cost Estimate Amount   
RTOTCOSTSR  BCD*10.3  Total Cost Estimate Amount   
CTOTCOSTHM  BCD*10.3  Total Cost Estimate Amount   
RTOTCOSTHM  BCD*10.3  Total Cost Estimate Amount   
CTOTBILLSR  BCD*10.3  Total Billing Estimate Amount   
RTOTBILLSR  BCD*10.3  Total Billing Estimate Amount   
CTOTBILLHM  BCD*10.3  Total Billing Estimate Amount   
RTOTBILLHM  BCD*10.3  Total Billing Estimate Amount   
COMPLETE  Integer  Status  List: 4 entries
0=New
10=Entered
30=Approved
40=Posted
PRINTSTAT  Boolean  Printed  List: 2 entries
0=False
1=True
TRANSTAT  Integer  Transaction Status  List: 4 entries
1=Entered
2=Imported
3=Generated
4=Posted
NEXTDTLNUM  Long  Next Detail Number   
NUMDTL  Long  Number of Details   
CREATEBY  String*8  Created By   
CREATEDT  Date  Created On   
CREATETM  Time  Created At   
APPROVEBY  String*8  Approved By   
APPROVEDT  Date  Approved On   
APPROVETM  Time  Approved At   
POSTEDBY  String*8  Posted By   
POSTEDDT  Date  Posted On   
POSTEDTM  Time  Posted At   
ENTEREDBY  String*8  Entered By   
DATEBUS  Date  Posting Date   

This page was generated on 2009-Nov-19

Copyright © 2001–2009 Sage Software, Inc. All rights reserved.