# Table: ^1 Resource ^6

Table: PMRESC
View: PM0121
Record length: 1005
Flags: A R

## Keys: 6

Title | Flags | Fields
--- | --- | ---
Contract Uniquifier/Line Number |  | CTUNIQ, PLINENUM, CLINENUM
Contract Uniquifier/Detail Numbe |  | CTUNIQ, DNUM
Contract/Project/Resource/Catego | D | CONTRACT, PROJECT, RESOURCE, CATEGORY
Contract/Project/Category/Resour | D | CONTRACT, PROJECT, CATEGORY, RESOURCE
Type/Contract/Project/Resource/C | D | TYPE, CONTRACT, PROJECT, RESOURCE, CATEGORY
Type/Contract/Project/Category/R | D | TYPE, CONTRACT, PROJECT, CATEGORY, RESOURCE

## Fields: 113

Field | Type | Title | Presentation
--- | --- | --- | ---
CTUNIQ | BCD*10.0 | ^1 Uniq |
PLINENUM | Long | Project Line Number |
CLINENUM | Long | Line Number |
AUDTDATE | Date |  |
AUDTTIME | Time |  |
AUDTUSER | String*8 |  |
AUDTORG | String*6 |  |
CONTRACT | String*16 | ^1 | Mask: %-16C
PROJECT | String*16 | ^2 | Mask: %-16N
DETAILNUM | Long | ^2 Detail Number |
DATELASTMN | Date | Last Maintained |
PNUM | Long | Employee Detail Number |
DNUM | Long | Detail Number |
TYPE | Integer | Cost Class | List: 6 entries
1 | = | Labor
2 | = | Material
3 | = | Equipment
4 | = | Subcontractor
5 | = | Overhead
6 | = | Miscellaneous
RESOURCE | String*24 | Resource | Mask: %-16N
ITEMNO | String*24 | Unformatted Item Number | Mask: %-24C
LOCATION | String*6 | Location | Mask: %-6N
CONVERSION | BCD*10.6 | Conversion Factor |
CATEGORY | String*16 | ^3 | Mask: %-16N
COMMENT | String*60 | Description |
COSTTYPE | String*10 | Cost Type | Mask: %-10N
BILLTYPE | Integer | Billing Type | List: 3 entries
2 | = | Billable
3 | = | No Charge
1 | = | Non-billable
ORJQTY | BCD*10.5 | Quantity |
CURQTY | BCD*10.5 | Current Quantity Estimate |
ACTQTY | BCD*10.5 | Actual Quantity |
UOM | String*10 | Unit of Measure | Mask: %-10C
UNITCOST | BCD*10.6 | Unit Cost |
ORJCOSTSR | BCD*10.3 | Reserved |
ORJCOSTHM | BCD*10.3 | Extended Cost |
CURCOSTSR | BCD*10.3 | Reserved |
CURCOSTHM | BCD*10.3 | Current Cost Estimate |
ACTCOSTSR | BCD*10.3 | Reserved |
ACTCOSTHM | BCD*10.3 | Actual Cost |
OVERHD | Integer | Overhead Type | List: 3 entries
1 | = | None
2 | = | Flat Rate Per Unit
5 | = | Percentage of Cost
OHEADRATE | BCD*10.6 | Overhead Rate |
HEADPER | BCD*5.5 | Overhead Percentage |
ORJOHSR | BCD*10.3 | Reserved |
ORJOHHM | BCD*10.3 | Original Overhead Estimate |
CUROHSR | BCD*10.3 | Reserved |
CUROHHM | BCD*10.3 | Current Overhead Estimate |
ACTOHSR | BCD*10.3 | Reserved |
ACTOHHM | BCD*10.3 | Actual Overhead |
BILLRATE | BCD*10.6 | Billing Rate |
COSTPLUSP | BCD*5.5 | Cost Plus Percentage |
ORJBILLSR | BCD*10.3 | Revenue |
ORJBILLHM | BCD*10.3 | Revenue |
CURBILLSR | BCD*10.3 | Current Revenue Estimate |
CURBILLHM | BCD*10.3 | Current Revenue Estimate |
ACTBILLSR | BCD*10.3 | Actual Revenue |
ACTBILLHM | BCD*10.3 | Actual Revenue |
ARITEM | String*16 | A/R Item No. | Mask: %-16C
LABOR | Integer | Labor Type | List: 3 entries
1 | = | None
2 | = | Flat Rate Per Labor Hour/Unit
3 | = | Percentage of Labor Cost
LABORRATE | BCD*10.6 | Labor Rate |
LABORPER | BCD*5.5 | Labor Percentage |
ORJLABORSR | BCD*10.3 | Reserved |
ORJLABORHM | BCD*10.3 | Original Labor Amount Estimate |
CURLABORSR | BCD*10.3 | Reserved |
CURLABORHM | BCD*10.3 | Current Labor Amount Estimate |
ACTLABORSR | BCD*10.3 | Reserved |
ACTLABORHM | BCD*10.3 | Actual Labor Amount |
TORJCOSTSR | BCD*10.3 | Reserved |
TORJCOSTHM | BCD*10.3 | Original Total Cost |
TCURCOSTSR | BCD*10.3 | Reserved |
TCURCOSTHM | BCD*10.3 | Current Total Cost |
TACTCOSTSR | BCD*10.3 | Reserved |
TACTCOSTHM | BCD*10.3 | Actual Total Cost |
ADJUNITCST | BCD*10.6 | Reserved |
COSTSEQNUM | Long | Reserved |
COSTDATE | Date | Reserved |
STOCKITEM | Boolean | Reserved |
BILLAMT | BCD*10.3 | Expected Billings |
OOHTYPE | Integer | Overhead Type | List: 3 entries
1 | = | None
2 | = | Flat Rate Per Unit
5 | = | Percentage of Cost
OOHRATE | BCD*10.6 | Overhead Rate |
OOHPER | BCD*5.5 | Overhead Percentage |
COHTYPE | Integer | Overhead Type | List: 3 entries
1 | = | None
2 | = | Flat Rate Per Unit
5 | = | Percentage of Cost
COHRATE | BCD*10.6 | Overhead Rate |
COHPER | BCD*5.5 | Overhead Percentage |
OLABORTYPE | Integer | Labor Type | List: 3 entries
1 | = | None
2 | = | Flat Rate Per Labor Hour/Unit
3 | = | Percentage of Labor Cost
OLABORRATE | BCD*10.6 | Labor Rate |
OLABORPER | BCD*5.5 | Labor Percentage |
CLABORTYPE | 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 |
CLABORPER | BCD*5.5 | Labor Percentage |
OUNITCOST | BCD*10.6 | Original Unit Cost |
OBILLRATE | BCD*10.6 | Original Billing Rate |
OCOSTPLUSP | BCD*5.5 | Original Cost Plus Percentage |
CUNITCOST | BCD*10.6 | Current Unit Cost |
CBILLRATE | BCD*10.6 | Current Billing Rate |
CCOSTPLUSP | BCD*5.5 | Current Cost Plus Percentage |
ICUOM | String*10 | ^7 | Mask: %-10c
ODATEFROM | Date | Projected Start Date |
ODATETO | Date | Projected End Date |
CDATEFROM | Date | Current Start Date |
CDATETO | Date | Current End Date |
POQTY | BCD*10.5 | Committed P/O Quantity |
POCOSTHM | BCD*10.3 | Committed P/O Cost |
POOHHM | BCD*10.3 | Committed P/O Overhead |
POLABORHM | BCD*10.3 | Committed P/O Labor |
POTCOSTHM | BCD*10.3 | Committed P/O Total Cost |
TCUNITCOST | Integer | Default Unit Cost From | List: 1 entries
0 | = | Use Default PJC Option
TCBILLRATE | Integer | Default Billing Rate From | List: 1 entries
0 | = | Use Default PJC Option
PAYTYPE | Integer |  | List: 3 entries
3 | = | None
1 | = | US Payroll
2 | = | Canadian Payroll
STRDQTY | BCD*10.5 | Stored Quantity |
STRDCOSTHM | BCD*10.3 | Stored Cost |
STRDBILLSR | BCD*10.3 | Stored Billable Amount |
PRECOLEDSR | BCD*10.3 | Previous D + E |
STRDOHHM | BCD*10.3 | Overhead Amount |
STRDTCSTHM | BCD*10.3 | Total Stored Cost |
TXEXPCOMHM | BCD*10.3 | Tax (exp) Committed (func) |
TXALLCOMHM | BCD*10.3 | Tax (all) Committed (func) |
PREAIAPAY | BCD*10.3 | Previous Certificates for Payment |
PRESTORED | BCD*10.3 | G703 Column F from Last AIA Report |
PRERETAIN | BCD*10.3 | G703 Column I from Last AIA Report |

This page was generated on 2008-May-01

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