# Table: Revise Estimates Detail

Table: PMCHNGD
View: PM0059
Record length: 1062
Flags: A R

## Keys: 3

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

## Fields: 90

Field | Type | Title | Presentation
--- | --- | --- | ---
SEQ | Long | Sequence |
LINENO | Long | Line Number |
AUDTDATE | Date |  |
AUDTTIME | Time |  |
AUDTUSER | String*8 |  |
AUDTORG | String*6 |  |
CHNGORDNO | String*16 | Revise Estimate Number | Mask: %-16C
DETAILNUM | Long | Detail Number |
FMTCONTNO | String*16 | Contract | Mask: %-16C
CONTRACT | String*16 | Contract | Mask: %-16C
PROJECT | String*16 | Project | Mask: %-16N
CATEGORY | String*16 | Category | Mask: %-16N
RESOURCE | String*24 | Resource | Mask: %-24C
COSTTYPE | Integer | Cost Type | List: 7 entries
0 | = | None
1 | = | Labor
2 | = | Material
3 | = | Equipment
4 | = | Subcontractor
5 | = | Overhead
6 | = | Miscellaneous
TYPE | Integer | Type | List: 4 entries
0 | = | None
1 | = | Project
2 | = | Category
3 | = | Resource Category
ACTION | Integer | Action | List: 2 entries
1 | = | Add New
2 | = | Modify Existing
CBILLTYPE | Integer | Billing Type | List: 3 entries
2 | = | Billable
3 | = | No Charge
1 | = | Non-billable
RBILLTYPE | Integer | Billing Type | List: 3 entries
2 | = | Billable
3 | = | No Charge
1 | = | Non-billable
COSTCCY | String*3 | Cost Currency | Mask: %-3N
BILLCCY | String*3 | Revenue Currency | Mask: %-3N
CDESC | String*60 | Description |
RDESC | String*60 | Description |
CARITEM | String*16 | A/R Item No. | Mask: %-16C
RARITEM | String*16 | A/R Item No. | Mask: %-16C
CARUOM | String*10 | A/R Unit of Measure | Mask: %-10C
RARUOM | String*10 | A/R Unit of Measure | Mask: %-10C
CICUOM | String*10 | I/C Unit of Measure | Mask: %-10c
RICUOM | String*10 | I/C Unit of Measure | Mask: %-10c
CCONV | BCD*10.6 | CCONV |
RCONV | BCD*10.6 | RCONV |
CQUANTITY | BCD*10.5 | Quantity |
RQUANTITY | BCD*10.5 | Quantity |
CUNITCOST | BCD*10.6 | Unit Cost |
RUNITCOST | BCD*10.6 | Unit Cost |
CEXTCOSTSR | BCD*10.3 | Extended Cost |
REXTCOSTSR | BCD*10.3 | Extended Cost |
CEXTCOSTHM | BCD*10.3 | Extended Cost |
REXTCOSTHM | BCD*10.3 | Extended Cost |
CLABORTYPE | Integer | Labor Type | List: 3 entries
1 | = | None
2 | = | Flat Rate Per Labor Hour/Unit
3 | = | Percentage of Labor Cost
RLABORTYPE | Integer | Labor Type | List: 3 entries
1 | = | None
2 | = | Flat Rate Per Labor Hour/Unit
3 | = | Percentage of Labor Cost
CLABORRATE | BCD*10.6 | Labor Rate |
RLABORRATE | BCD*10.6 | Labor Rate |
CLABORPER | BCD*5.5 | Labor Percentage |
RLABORPER | BCD*5.5 | Labor Percentage |
CLABORAMT | BCD*10.3 | Labor Amount |
RLABORAMT | BCD*10.3 | Labor Amount |
COHTYPE | Integer | Overhead Type | List: 3 entries
1 | = | None
2 | = | Flat Rate Per Unit
5 | = | Percentage of Cost
ROHTYPE | Integer | Overhead Type | List: 3 entries
1 | = | None
2 | = | Flat Rate Per Unit
5 | = | Percentage of Cost
COHRATE | BCD*10.6 | Overhead Rate |
ROHRATE | BCD*10.6 | Overhead Rate |
COHPER | BCD*5.5 | Overhead Percentage |
ROHPER | BCD*5.5 | Overhead Percentage |
COHAMT | BCD*10.3 | Overhead Amount |
ROHAMT | BCD*10.3 | Overhead Amount |
CTOTCOSTSR | BCD*10.3 | Total Cost |
RTOTCOSTSR | BCD*10.3 | Total Cost |
CTOTCOSTHM | BCD*10.3 | Total Cost |
RTOTCOSTHM | BCD*10.3 | Total Cost |
CCOSTPLUSP | BCD*5.5 | Cost Plus Percentage |
RCOSTPLUSP | BCD*5.5 | Cost Plus Percentage |
CBILLRATE | BCD*10.6 | Billing Rate |
RBILLRATE | BCD*10.6 | Billing Rate |
CEXTBILLSR | BCD*10.3 | Extended Billing Amount |
REXTBILLSR | BCD*10.3 | Extended Billing Amount |
CEXTBILLHM | BCD*10.3 | Extended Billing Amount |
REXTBILLHM | BCD*10.3 | Extended Billing Amount |
CFPAMTSR | BCD*10.3 | Fixed Price Amount |
RFPAMTSR | BCD*10.3 | Fixed Price Amount |
CFPAMTHM | BCD*10.3 | Fixed Price Amount |
RFPAMTHM | BCD*10.3 | Fixed Price Amount |
CPROFITSR | BCD*10.3 | Profit |
RPROFITSR | BCD*10.3 | Profit |
CPROFITHM | BCD*10.3 | Profit |
RPROFITHM | BCD*10.3 | Profit |
CRATETYPE | String*2 | Rate Type | Mask: %-2N
CRATEDATE | Date | Rate Date |
CRATEOP | Integer | Rate Op | List: 2 entries
1 | = | Multiply
2 | = | Divide
CRATE | BCD*8.7 | Rate |
RATETYPE | String*2 | Rate Type | Mask: %-2N
RATEDATE | Date | Rate Date |
RATEOP | Integer | Rate Operation | List: 2 entries
1 | = | Multiply
2 | = | Divide
RATE | BCD*8.7 | Rate |
RATESPREAD | BCD*8.7 | Rate Spread |
COMMENTS | String*250 | Comment |
CONTSTYLE | Integer | Contract Style | List: 2 entries
1 | = | Standard
2 | = | Basic
PROJTYPE | Integer | Project Type | List: 3 entries
1 | = | Time and Materials
2 | = | Fixed Price
3 | = | Cost Plus
REVREC | Integer | Accounting Method | 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 | String*12 | Customer | Mask: %-12C
INVTYPE | Integer | Invoice Type | List: 2 entries
1 | = | Item
2 | = | Summary
VALUES | Long | VALUES |

This page was generated on 2006-Sep-07

Copyright © 2001–2005 Sage Accpac International, Inc.