View: ^1 Resources

RotoID: PM0120
Table: PMRES
Protocol: Detail, Sequenced revisions, Key auto generate
DLL:PMRES

Compositions: 5

RotoID Tables Title DLL
PM0022 PMPROJSPMPROJT ^5 PMPROJS
PM0021 PMCONTSPMCONTT ^4 PMCONTS
PM0039 PMCATGT ^1 ^6 PMCATGT
PM0121 PMRESC ^1 Resource ^6 PMRESC
PM0853 PMRESO Resource Optional Field PMRESO

Keys: 4

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

Fields: 72

Field Index Type Title Attributes Presentation
CTUNIQ 1 BCD*10.0 ^1 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 ^1 E A  Mask: %-16C
PROJECT 5 String*16 ^2 E A  Mask: %-16N
DETAILNUM 6 Long ^2 Detail Number A 
DATELASTMN 7 Date Last Maintained A C 
DNUM 8 Long Detail Number E A 
TYPE 9 Integer Cost Class E A  List:6 entries
1 = Labor
2 = Material
3 = Equipment
4 = Subcontractor
5 = Overhead
6 = Miscellaneous
RESOURCE 10 String*24 E A P  Mask: %-16N
ITEMNO 11 String*24 Unformatted Item Number E A  Mask: %-24C
LOCATION 12 String*6 Location E A  Mask: %-6N
NAME 13 String*60 Name E A 
COMMENT 14 String*60 Description E A 
ORJQTY 15 BCD*10.5 Quantity A 
CURQTY 16 BCD*10.5 Current Quantity Estimate A 
ACTQTY 17 BCD*10.5 Actual Quantity A 
ORJCOSTSR 18 BCD*10.3 Reserved A 
ORJCOSTHM 19 BCD*10.3 Extended Cost A 
CURCOSTSR 20 BCD*10.3 Reserved A 
CURCOSTHM 21 BCD*10.3 Current Cost Estimate A 
ACTCOSTSR 22 BCD*10.3 Reserved A 
ACTCOSTHM 23 BCD*10.3 Actual Cost A 
ORJOHSR 24 BCD*10.3 Reserved A 
ORJOHHM 25 BCD*10.3 Original Overhead Estimate A 
CUROHSR 26 BCD*10.3 Reserved A 
CUROHHM 27 BCD*10.3 Current Overhead Estimate A 
ACTOHSR 28 BCD*10.3 Reserved A 
ACTOHHM 29 BCD*10.3 Actual Overhead A 
ORJBILLSR 30 BCD*10.3 Revenue A 
ORJBILLHM 31 BCD*10.3 Revenue A 
CURBILLSR 32 BCD*10.3 Current Revenue Estimate A 
CURBILLHM 33 BCD*10.3 Current Revenue Estimate A 
ACTBILLSR 34 BCD*10.3 Actual Revenue A 
ACTBILLHM 35 BCD*10.3 Actual Revenue A 
ORJLABORSR 36 BCD*10.3 Reserved A 
ORJLABORHM 37 BCD*10.3 Original Labor Amount Estimate A 
CURLABORSR 38 BCD*10.3 Reserved A 
CURLABORHM 39 BCD*10.3 Current Labor Amount Estimate A 
ACTLABORSR 40 BCD*10.3 Reserved A 
ACTLABORHM 41 BCD*10.3 Actual Labor Amount A 
BILLAMT 42 BCD*10.3 Expected Billings A 
ODATEFROM 43 Date Projected Start Date E A X 
ODATETO 44 Date Projected End Date E A X 
CDATEFROM 45 Date Current Start Date A X 
CDATETO 46 Date Current End Date A X 
POQTY 47 BCD*10.5 Committed P/O Quantity A 
POCOSTHM 48 BCD*10.3 Committed P/O Cost A 
POOHHM 49 BCD*10.3 Committed P/O Overhead A 
POLABORHM 50 BCD*10.3 Committed P/O Labor A 
POTCOSTHM 51 BCD*10.3 Committed P/O Total Cost A 
VALUES 52 Long Optional Fields E A C 
TCUNITCOST 53 Integer E A  List:4 entries
0 = Use Default PJC Option
1 = Payroll
2 = PJC Employee Setup
6 = Resource Category
TCBILLRATE 54 Integer E A  List:3 entries
0 = Use Default PJC Option
2 = PJC Employee Setup
6 = Resource Category
STRDQTY 55 BCD*10.5 Stored Quantity A 
STRDCOSTHM 56 BCD*10.3 Stored Cost A 
STRDBILLSR 57 BCD*10.3 Stored Billable Amount A 
PRECOLEDSR 58 BCD*10.3 Previous Completed Work A 
STRDOHHM 59 BCD*10.3 Overhead Amount A 
STRDTCSTHM 60 BCD*10.3 Total Stored Cost A 
TXEXPCOMHM 61 BCD*10.3 Tax (exp) Committed (func) A 
TXALLCOMHM 62 BCD*10.3 Tax (all) Committed (func) A 
PREAIAPAY 63 BCD*10.3 Previous Certificates for Payment A 
PRESTORED 64 BCD*10.3 G703 Column F from Last AIA Report A 
PRERETAIN 65 BCD*10.3 G703 Column I from Last AIA Report A 
SNAPCALC 1000 Integer Extended Cost rt E A C 
SNAPOFROM 1001 Date Extended Cost rt E A X 
SNAPOTO 1002 Date Extended Cost rt E A X 
SNAPCFROM 1003 Date Extended Cost rt A X 
SNAPCTO 1004 Date Extended Cost rt A X 
HASOPT 1021 Boolean Optional Fields rt E A C  List:2 entries
1 = Yes
0 = No
FUNCTION 1022 Integer Function rt E A C  List:2 entries
0 = None
10 = Load Optional Fields

This page was generated on 2022-Aug-18

© 2021 Sage Software, Inc. All rights reserved. Reproduction of part or all of the contents in any form is prohibited unless for personal use. None of the content of this article may be copied or otherwise incorporated into any other document, publication or other work in any form (whether written, electronic or other format).

Sage Software, Inc. makes no warranties, representations or undertakings about any of the content of articles (including, without limitation, any as to the quality, accuracy, completeness or fitness for any particular purpose of such content).