View: ^1 Resource ^6

RotoID: PM0121
Table: PMRESC
Protocol: Detail, Sequenced revisions, Key auto generate
DLL:PMRESC

Compositions: 4

RotoID Tables Title DLL
PM0022 PMPROJSPMPROJT ^5 PMPROJS
PM0021 PMCONTSPMCONTT ^4 PMCONTS
PM0039 PMCATGT ^1 ^6 PMCATGT
PM0120 PMRES ^1 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: 114

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 A  Mask: %-16C
PROJECT 5 String*16 ^2 A  Mask: %-16N
DETAILNUM 6 Long ^2 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 ^3 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 
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 A 
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 
CCOSTPLUSP 85 BCD*5.5 Current Cost Plus Percentage A 
ICUOM 86 String*10 ^7 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 E A C  List:3 entries
3 = None
1 = US Payroll
2 = Canadian Payroll
STRDQTY 99 BCD*10.5 Stored Quantity A 
STRDCOSTHM 100 BCD*10.3 Stored Cost A 
STRDBILLSR 101 BCD*10.3 Stored Billable Amount A 
PRECOLEDSR 102 BCD*10.3 Previous D + E A 
STRDOHHM 103 BCD*10.3 Overhead Amount A 
STRDTCSTHM 104 BCD*10.3 Total Stored Cost A 
TXEXPCOMHM 105 BCD*10.3 Tax (exp) Committed (func) A 
TXALLCOMHM 106 BCD*10.3 Tax (all) Committed (func) A 
PREAIAPAY 107 BCD*10.3 Previous Certificates for Payment A 
PRESTORED 108 BCD*10.3 G703 Column F from Last AIA Report A 
PRERETAIN 109 BCD*10.3 G703 Column I from Last AIA Report A 
CATDESC 1001 String*60 Description rt A C 
REVERSE 1002 Integer Reverse Resource/Category rt E A C 
RESDESC 1003 String*60 Description rt A C 
PRICELIST 1004 String*6 PRICELIST rt A C 
TBILLRATE 1005 BCD*10.6 TBILLRATE rt A C 

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).