# 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 2008-May-01

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