# Table: ^1 Resources

Table: PMRES
View: PM0120
Record length: 731
Flags: A R

## Keys: 4

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

## Fields: 69

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 |
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 |  | Mask: %-16N
ITEMNO | String*24 | Unformatted Item Number | Mask: %-24C
LOCATION | String*6 | Location | Mask: %-6N
NAME | String*60 | Name |
COMMENT | String*60 | Description |
ORJQTY | BCD*10.5 | Quantity |
CURQTY | BCD*10.5 | Current Quantity Estimate |
ACTQTY | BCD*10.5 | Actual Quantity |
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 |
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 |
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 |
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 |
BILLAMT | BCD*10.3 | Expected Billings |
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 |
VALUES | Long | Optional Fields |
TCUNITCOST | Integer |  | List: 4 entries
0 | = | Use Default PJC Option
1 | = | Payroll
2 | = | PJC Employee Setup
6 | = | Resource Category
TCBILLRATE | Integer |  | List: 3 entries
0 | = | Use Default PJC Option
2 | = | PJC Employee Setup
6 | = | Resource Category
STRDQTY | BCD*10.5 | Stored Quantity |
STRDCOSTHM | BCD*10.3 | Stored Cost |
STRDBILLSR | BCD*10.3 | Stored Billable Amount |
PRECOLEDSR | BCD*10.3 | Previous Completed Work |
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.