Table: ^1 Resources

Table: PMRES
View: PM0120
Record Length: 731

Flags: A R 

Keys: 4

Title Flags Fields

Contract Uniquifier/Line Number CTUNIQPLINENUMCLINENUM
Contract Uniquifier/Detail Numbe CTUNIQDNUM
Contract/Project/Category D  CONTRACTPROJECTRESOURCE
Type/Contract/Project/Category D  TYPECONTRACTPROJECTRESOURCE

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