View: Revise Estimates Detail

RotoID: PM0059
Table: PMCHNGD
Protocol: Detail, Sequenced revisions, Key auto generate
DLL:PMCHNGD

Compositions: 2

RotoID Tables Title DLL
PM0058 PMCHNGH Revise Estimates PMCHNGH
PM0550 PMREVDO Revise Estimates Detail Opt. Fld PMREVDO

Keys: 3

Title Fields
Sequence/Line Number SEQ, LINENO
Document Number/Line Number CHNGORDNO, LINENO
Sequence/Detail Number SEQ, DETAILNUM

Fields: 93

Field Index Type Title Attributes Presentation
SEQ 1 Long Sequence E A K R 
LINENO 2 Long Line Number E A K R 
CHNGORDNO 3 String*16 Revise Estimate Number E A C  Mask: %-16C
DETAILNUM 4 Long Detail Number E A 
FMTCONTNO 5 String*16 ^1 E A X  Mask: %-16C
CONTRACT 6 String*16 ^1 E A X  Mask: %-16C
PROJECT 7 String*16 ^2 E A X  Mask: %-16N
CATEGORY 8 String*16 ^3 E A X  Mask: %-16N
RESOURCE 9 String*24 Resource E A X  Mask: %-24C
COSTTYPE 10 Integer Cost Type E A X  List:7 entries
0 = None
1 = Labor
2 = Material
3 = Equipment
4 = Subcontractor
5 = Overhead
6 = Miscellaneous
TYPE 11 Integer Type A  List:4 entries
0 = None
1 = Project
2 = Category
3 = Resource Category
ACTION 12 Integer Action A  List:2 entries
1 = Add New
2 = Modify Existing
CBILLTYPE 13 Integer Billing Type A  List:3 entries
2 = Billable
3 = No Charge
1 = Non-billable
RBILLTYPE 14 Integer Billing Type A P X  List:3 entries
2 = Billable
3 = No Charge
1 = Non-billable
COSTCCY 15 String*3 Cost Currency A  Mask: %-3N
BILLCCY 16 String*3 Billing Currency A  Mask: %-3N
CDESC 17 String*60 Description A 
RDESC 18 String*60 Description A X 
CARITEM 19 String*16 A/R Item No. A  Mask: %-16C
RARITEM 20 String*16 A/R Item No. A X  Mask: %-16C
CARUOM 21 String*10 A/R Unit of Measure A  Mask: %-10C
RARUOM 22 String*10 A/R Unit of Measure A X  Mask: %-10C
CICUOM 23 String*10 ^7 A  Mask: %-10c
RICUOM 24 String*10 ^7 A  Mask: %-10c
CCONV 25 BCD*10.6 A X 
RCONV 26 BCD*10.6 A X 
CQUANTITY 27 BCD*10.5 Quantity A 
RQUANTITY 28 BCD*10.5 Quantity A X 
CUNITCOST 29 BCD*10.6 Unit Cost A 
RUNITCOST 30 BCD*10.6 Unit Cost A X 
CEXTCOSTSR 31 BCD*10.3 Extended Cost A 
REXTCOSTSR 32 BCD*10.3 Extended Cost A 
CEXTCOSTHM 33 BCD*10.3 Extended Cost A 
REXTCOSTHM 34 BCD*10.3 Extended Cost A X 
CLABORTYPE 35 Integer Labor Type A  List:3 entries
1 = None
2 = Flat Rate Per Labor Hour/Unit
3 = Percentage of Labor Cost
RLABORTYPE 36 Integer Labor Type A P X  List:3 entries
1 = None
2 = Flat Rate Per Labor Hour/Unit
3 = Percentage of Labor Cost
CLABORRATE 37 BCD*10.6 Labor Rate A 
RLABORRATE 38 BCD*10.6 Labor Rate A X 
CLABORPER 39 BCD*5.5 Labor Percentage A 
RLABORPER 40 BCD*5.5 Labor Percentage A X 
CLABORAMT 41 BCD*10.3 Labor Amount A 
RLABORAMT 42 BCD*10.3 Labor Amount A 
COHTYPE 43 Integer Overhead Type A  List:3 entries
1 = None
2 = Flat Rate Per Unit
5 = Percentage of Cost
ROHTYPE 44 Integer Overhead Type A P X  List:3 entries
1 = None
2 = Flat Rate Per Unit
5 = Percentage of Cost
COHRATE 45 BCD*10.6 Overhead Rate A 
ROHRATE 46 BCD*10.6 Overhead Rate A X 
COHPER 47 BCD*5.5 Overhead Percentage A 
ROHPER 48 BCD*5.5 Overhead Percentage A X 
COHAMT 49 BCD*10.3 Overhead Amount A 
ROHAMT 50 BCD*10.3 Overhead Amount A 
CTOTCOSTSR 51 BCD*10.3 Total Cost A 
RTOTCOSTSR 52 BCD*10.3 Total Cost A 
CTOTCOSTHM 53 BCD*10.3 Total Cost A 
RTOTCOSTHM 54 BCD*10.3 Total Cost A 
CCOSTPLUSP 55 BCD*5.5 Cost Plus Percentage A 
RCOSTPLUSP 56 BCD*5.5 Cost Plus Percentage A X 
CBILLRATE 57 BCD*10.6 Billing Rate A 
RBILLRATE 58 BCD*10.6 Billing Rate A X 
CEXTBILLSR 59 BCD*10.3 Extended Billing Amount A 
REXTBILLSR 60 BCD*10.3 Extended Billing Amount A X 
CEXTBILLHM 61 BCD*10.3 Extended Billing Amount A 
REXTBILLHM 62 BCD*10.3 Extended Billing Amount A X 
CFPAMTSR 63 BCD*10.3 Fixed Price Amount A 
RFPAMTSR 64 BCD*10.3 Fixed Price Amount A X 
CFPAMTHM 65 BCD*10.3 Fixed Price Amount A 
RFPAMTHM 66 BCD*10.3 Fixed Price Amount A 
CPROFITSR 67 BCD*10.3 Profit A 
RPROFITSR 68 BCD*10.3 Profit A 
CPROFITHM 69 BCD*10.3 Profit A 
RPROFITHM 70 BCD*10.3 Profit A 
CRATETYPE 71 String*2 Rate Type A X  Mask: %-2N
CRATEDATE 72 Date Rate Date A X 
CRATEOP 73 Integer Rate Op A X  List:2 entries
1 = Multiply
2 = Divide
CRATE 74 BCD*8.7 Rate A X 
RATETYPE 75 String*2 Rate Type A  Mask: %-2N
RATEDATE 76 Date Rate Date A 
RATEOP 77 Integer Rate Operation A  List:2 entries
1 = Multiply
2 = Divide
RATE 78 BCD*8.7 Rate A 
RATESPREAD 79 BCD*8.7 Rate Spread A C 
COMMENTS 80 String*250 Comment A X 
CONTSTYLE 81 Integer ^1 Style A C  List:2 entries
1 = Standard
2 = Basic
PROJTYPE 82 Integer ^2 Type A C  List:3 entries
1 = Time and Materials
2 = Fixed Price
3 = Cost Plus
REVREC 83 Integer Accounting Method A C  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
CUSTOMER 84 String*12 Customer A C X  Mask: %-12C
INVTYPE 85 Integer Invoice Type A C X  List:2 entries
1 = Item
2 = Summary
VALUES 86 Long A C X 
RATEERR 1001 Integer Description A C  List:5 entries
0 = No rate error
1 = Rate type is invalid
2 = Rate is zero
3 = Rate is outside spread
4 = No rate information exists
FUNCTION 1002 Integer Function E A C  List:2 entries
0 = None
10 = Load Optional Fields
CONTDESC 1009 String*60 Description A C 
PROJDESC 1010 String*60 Description A C 
CATDESC 1011 String*60 Description A C 
RESDESC 1012 String*60 Description A C 
HASOPT 1013 Boolean Optional Fields E A C  List:2 entries
0 = No
1 = Yes

This page was generated on 2022-Aug-18

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