# View: Contract Resource Categories

RotoID: PM0121
Table: PMRESC
DLL: PMRESC

## Compositions: 4

RotoID | Table | Title | DLL
--- | --- | --- | ---
PM0022 | PMPROJS | Projects | PMPROJS
PM0021 | PMCONTS | Contracts | PMCONTS
PM0039 | PMCATGT | Contract Categories | PMCATGT
PM0120 | PMRES | Contract Resources | PMRES

## Keys: 6

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

## Fields: 101

Field | Index | Type | Title | Attributes | Presentation
--- | --- | --- | --- | --- | ---
CTUNIQ | 1 | BCD*10.0 | Contract Uniq | E A K R |
PLINENUM | 2 | Long | Project Line Number | E A K R |
CLINENUM | 3 | Long | Line Number | E A K R |
CONTRACT | 4 | String*16 | Contract | A | Mask: %-16C
PROJECT | 5 | String*16 | Project | A | Mask: %-16N
DETAILNUM | 6 | Long | Project Detail Number | A |
DATELASTMN | 7 | Date | Last Maintained | A C |
PNUM | 8 | Long | Employee Detail Number | E A |
DNUM | 9 | Long | Detail Number | E A |
TYPE | 10 | Integer | Cost Class | E A | List: 6 entries
1 | = | Labor
2 | = | Material
3 | = | Equipment
4 | = | Subcontractor
5 | = | Overhead
6 | = | Miscellaneous
RESOURCE | 11 | String*24 | Resource | E A P | Mask: %-16N
ITEMNO | 12 | String*24 | Unformatted Item Number | E A | Mask: %-24C
LOCATION | 13 | String*6 | Location | E A | Mask: %-6N
CONVERSION | 14 | BCD*10.6 | Conversion Factor | E A |
CATEGORY | 15 | String*16 | Category | E A | Mask: %-16N
COMMENT | 16 | String*60 | Description | E A |
COSTTYPE | 17 | String*10 | Cost Type | A | Mask: %-10N
BILLTYPE | 18 | Integer | Billing Type | A X | List: 3 entries
2 | = | Billable
3 | = | No Charge
1 | = | Non-billable
ORJQTY | 19 | BCD*10.5 | Quantity | A X |
CURQTY | 20 | BCD*10.5 | Current Quantity Estimate | A X |
ACTQTY | 21 | BCD*10.5 | Actual Quantity | A |
UOM | 22 | String*10 | Unit of Measure | A X | Mask: %-10C
UNITCOST | 23 | BCD*10.6 | Unit Cost | A X |
ORJCOSTSR | 24 | BCD*10.3 | Reserved | A |
ORJCOSTHM | 25 | BCD*10.3 | Extended Cost | A X |
CURCOSTSR | 26 | BCD*10.3 | Reserved | A |
CURCOSTHM | 27 | BCD*10.3 | Current Cost Estimate | A X |
ACTCOSTSR | 28 | BCD*10.3 | Reserved | A |
ACTCOSTHM | 29 | BCD*10.3 | Actual Cost | A |
OVERHD | 30 | Integer | Overhead Type | A | List: 3 entries
1 | = | None
2 | = | Flat Rate Per Unit
5 | = | Percentage of Cost
OHEADRATE | 31 | BCD*10.6 | Overhead Rate | A |
HEADPER | 32 | BCD*5.5 | Overhead Percentage | A |
ORJOHSR | 33 | BCD*10.3 | Reserved | A |
ORJOHHM | 34 | BCD*10.3 | Original Overhead Estimate | A |
CUROHSR | 35 | BCD*10.3 | Reserved | A |
CUROHHM | 36 | BCD*10.3 | Current Overhead Estimate | A |
ACTOHSR | 37 | BCD*10.3 | Reserved | A |
ACTOHHM | 38 | BCD*10.3 | Actual Overhead | A |
BILLRATE | 39 | BCD*10.6 | Billing Rate | A X |
COSTPLUSP | 40 | BCD*5.5 | Cost Plus Percentage | A |
ORJBILLSR | 41 | BCD*10.3 | Revenue | A X |
ORJBILLHM | 42 | BCD*10.3 | Revenue | A X |
CURBILLSR | 43 | BCD*10.3 | Current Revenue Estimate | A X |
CURBILLHM | 44 | BCD*10.3 | Current Revenue Estimate | A X |
ACTBILLSR | 45 | BCD*10.3 | Actual Revenue | A |
ACTBILLHM | 46 | BCD*10.3 | Actual Revenue | A |
ARITEM | 47 | String*16 | A/R Item No. | A X | Mask: %-16C
LABOR | 48 | Integer | Labor Type | A | List: 3 entries
1 | = | None
2 | = | Flat Rate Per Labor Hour/Unit
3 | = | Percentage of Labor Cost
LABORRATE | 49 | BCD*10.6 | Labor Rate | A |
LABORPER | 50 | BCD*5.5 | Labor Percentage | A |
ORJLABORSR | 51 | BCD*10.3 | Reserved | A |
ORJLABORHM | 52 | BCD*10.3 | Original Labor Amount Estimate | A |
CURLABORSR | 53 | BCD*10.3 | Reserved | A |
CURLABORHM | 54 | BCD*10.3 | Current Labor Amount Estimate | A |
ACTLABORSR | 55 | BCD*10.3 | Reserved | A |
ACTLABORHM | 56 | BCD*10.3 | Actual Labor Amount | A |
TORJCOSTSR | 57 | BCD*10.3 | Reserved | A |
TORJCOSTHM | 58 | BCD*10.3 | Original Total Cost | A |
TCURCOSTSR | 59 | BCD*10.3 | Reserved | A |
TCURCOSTHM | 60 | BCD*10.3 | Current Total Cost | A |
TACTCOSTSR | 61 | BCD*10.3 | Reserved | A |
TACTCOSTHM | 62 | BCD*10.3 | Actual Total Cost | A |
ADJUNITCST | 63 | BCD*10.6 | Reserved | E A |
COSTSEQNUM | 64 | Long | Reserved | E A |
COSTDATE | 65 | Date | Reserved | E A |
STOCKITEM | 66 | Boolean | Reserved | E A |
BILLAMT | 67 | BCD*10.3 | Expected Billings | E A X |
OOHTYPE | 68 | Integer | Overhead Type | A | List: 3 entries
1 | = | None
2 | = | Flat Rate Per Unit
5 | = | Percentage of Cost
OOHRATE | 69 | BCD*10.6 | Overhead Rate | A |
OOHPER | 70 | BCD*5.5 | Overhead Percentage | A |
COHTYPE | 71 | Integer | Overhead Type | A | List: 3 entries
1 | = | None
2 | = | Flat Rate Per Unit
5 | = | Percentage of Cost
COHRATE | 72 | BCD*10.6 | Overhead Rate | A |
COHPER | 73 | BCD*5.5 | Overhead Percentage | A |
OLABORTYPE | 74 | Integer | Labor Type | A | List: 3 entries
1 | = | None
2 | = | Flat Rate Per Labor Hour/Unit
3 | = | Percentage of Labor Cost
OLABORRATE | 75 | BCD*10.6 | Labor Rate | A |
OLABORPER | 76 | BCD*5.5 | Labor Percentage | A |
CLABORTYPE | 77 | Integer | Labor Type | A | List: 3 entries
1 | = | None
2 | = | Flat Rate Per Labor Hour/Unit
3 | = | Percentage of Labor Cost
CLABORRATE | 78 | BCD*10.6 | Labor Rate | A |
CLABORPER | 79 | BCD*5.5 | Labor Percentage | A |
OUNITCOST | 80 | BCD*10.6 | Original Unit Cost | A X |
OBILLRATE | 81 | BCD*10.6 | Original Billing Rate | A X |
OCOSTPLUSP | 82 | BCD*5.5 | Original Cost Plus Percentage | A |
CUNITCOST | 83 | BCD*10.6 | Current Unit Cost | A X |
CBILLRATE | 84 | BCD*10.6 | Current Billing Rate | A X |
CCOSTPLUSP | 85 | BCD*5.5 | Current Cost Plus Percentage | A |
ICUOM | 86 | String*10 | I/C Unit of Measure | A X | Mask: %-10c
ODATEFROM | 87 | Date | Projected Start Date | A X |
ODATETO | 88 | Date | Projected End Date | A X |
CDATEFROM | 89 | Date | Current Start Date | A X |
CDATETO | 90 | Date | Current End Date | A X |
POQTY | 91 | BCD*10.5 | Committed P/O Quantity | A |
POCOSTHM | 92 | BCD*10.3 | Committed P/O Cost | A |
POOHHM | 93 | BCD*10.3 | Committed P/O Overhead | A |
POLABORHM | 94 | BCD*10.3 | Committed P/O Labor | A |
POTCOSTHM | 95 | BCD*10.3 | Committed P/O Total Cost | A |
TCUNITCOST | 96 | Integer | Default Unit Cost From | E A P | List: 1 entries
0 | = | Use Default PJC Option
TCBILLRATE | 97 | Integer | Default Billing Rate From | E A P | List: 1 entries
0 | = | Use Default PJC Option
PAYTYPE | 98 | Integer | PAYTYPE | E A C | List: 3 entries
3 | = | None
1 | = | US Payroll
2 | = | Canadian Payroll
CATDESC | 1001 | String*60 | Description | A C |
REVERSE | 1002 | Integer | Reverse Resource/Category | E A C |
RESDESC | 1003 | String*60 | Description | A C |

This page was generated on 2006-Sep-07

Copyright © 2001–2005 Sage Accpac International, Inc.