View: ^1 ^6

RotoID: PM0039
Table: PMCATGT
Protocol: Detail, Sequenced revisions, Key auto generate
DLL:PMCATGT

Compositions: 3

RotoID Tables Title DLL
PM0022 PMPROJSPMPROJT ^5 PMPROJS
PM0021 PMCONTSPMCONTT ^4 PMCONTS
PM0852 PMCATGTO Category Optional Field PMCATGTO

Keys: 5

Title Fields
Contract Uniquifier/Line Number CTUNIQ, PLINENUM, CLINENUM
Contract Uniquifier/Detail Numbe CTUNIQ, DNUM
Contract/Project/Category CONTRACT, PROJECT, CATEGORY
Contract Uniquifier/Detail Numbe CTUNIQ, DETAILNUM, DNUM
Contract/Category/Project Line N CONTRACT, CATEGORY, PLINENUM

Fields: 200

Field Index Type Title Attributes Presentation
CTUNIQ 1 BCD*10.0 ^1 Unique Code 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
CATEGORY 6 String*16 ^3 E A  Mask: %-16N
CCY 7 String*3 Currency A  Mask: %-3N
DETAILNUM 8 Long ^2 Detail Number E A 
DNUM 9 Long ^3 Detail Number E A 
DATELASTMN 10 Date Last Maintained A C 
DESC 11 String*60 Description E A 
COSTTYPE 12 String*10 Cost Type A X  Mask: %-10N
TYPE 13 Integer Cost Class A X  List:6 entries
1 = Labor
2 = Material
3 = Equipment
4 = Subcontractor
5 = Overhead
6 = Miscellaneous
PONUMBER 14 String*22 Last Purchase Order Number A X  Mask: %-22C
BILLTYPE 15 Integer Billing Type A X  List:3 entries
2 = Billable
3 = No Charge
1 = Non-billable
ORJQTY 16 BCD*10.5 Quantity A X 
CURQTY 17 BCD*10.5 Current Quantity Estimate A X 
ACTQTY 18 BCD*10.5 Actual Quantity A 
ARITEM 22 String*16 A/R Item No. A X  Mask: %-16C
UOM 23 String*10 Unit of Measure A X  Mask: %-10C
UNITCOST 24 BCD*10.6 Unit Cost A X 
ORJCOSTSR 25 BCD*10.3 Reserved A X 
ORJCOSTHM 26 BCD*10.3 Extended Cost A X 
CURCOSTSR 27 BCD*10.3 Reserved A X 
CURCOSTHM 28 BCD*10.3 Current Cost Estimate A X 
ACTCOSTSR 29 BCD*10.3 Reserved A 
ACTCOSTHM 30 BCD*10.3 Actual Cost A 
BILLRATE 31 BCD*10.6 Billing Rate A X 
OVERHD 32 Integer Overhead Type A X  List:3 entries
1 = None
2 = Flat Rate Per Unit
5 = Percentage of Cost
OHEADRATE 33 BCD*10.6 Overhead Rate A X 
HEADPER 34 BCD*5.5 Overhead Percentage A X 
ORJOHSR 35 BCD*10.3 Reserved A 
ORJOHHM 36 BCD*10.3 Original Overhead Estimate A 
CUROHSR 37 BCD*10.3 Reserved A 
CUROHHM 38 BCD*10.3 Current Overhead Estimate A 
ACTOHSR 39 BCD*10.3 Reserved A 
ACTOHHM 40 BCD*10.3 Actual Overhead A 
LABOR 41 Integer Labor Type A X  List:3 entries
1 = None
2 = Flat Rate Per Labor Hour/Unit
3 = Percentage of Labor Cost
LABORRATE 42 BCD*10.6 Labor Rate A X 
LABORPER 43 BCD*5.5 Labor Percentage A X 
ORJLABORSR 44 BCD*10.3 Reserved A 
ORJLABORHM 45 BCD*10.3 Original Labor Amount Estimate A 
CURLABORSR 46 BCD*10.3 Reserved A 
CURLABORHM 47 BCD*10.3 Current Labor Amount Estimate A 
ACTLABORSR 48 BCD*10.3 Reserved A 
ACTLABORHM 49 BCD*10.3 Actual Labor Amount A 
COSTPLUSP 50 BCD*5.5 Cost Plus Percentage A X 
ORJBILLSR 51 BCD*10.3 Revenue A X 
ORJBILLHM 52 BCD*10.3 Revenue A X 
CURBILLSR 53 BCD*10.3 Current Revenue Estimate A X 
CURBILLHM 54 BCD*10.3 Current Revenue Estimate A X 
ACTBILLHM 55 BCD*10.3 Total Actual Revenue A 
ACTBILLSR 56 BCD*10.3 Total Actual Revenue A 
ACTBILRRHM 57 BCD*10.3 Total Revenue Recognized A 
ACTBILRRSR 58 BCD*10.3 Total Revenue Recognized A 
CCYBILL 59 String*3 Customer Currency A  Mask: %-3N
TORJCOSTSR 60 BCD*10.3 Reserved A 
TORJCOSTHM 61 BCD*10.3 Total Original Estimate Cost A 
TCURCOSTSR 62 BCD*10.3 Reserved A 
TCURCOSTHM 63 BCD*10.3 Total Current Estimate Cost A 
TACTCOSTSR 64 BCD*10.3 Reserved A 
TACTCOSTHM 65 BCD*10.3 Total Actual Cost A 
TCOSTRRSR 66 BCD*10.3 Reserved A 
TCOSTRRHM 67 BCD*10.3 Total Cost Recognized A 
PERTOTCOST 68 BCD*5.5 Percent Total Cost A 
TARRECTSSR 72 BCD*10.3 Total A/R Customer Receipts A 
TARRECTSHM 73 BCD*10.3 Total A/R Customer Receipts A 
TAPPAYMTS 74 BCD*10.3 A/P Vendor Payments A 
PERRETPAID 75 BCD*5.5 A/P Retainage Percentage A X 
RETPAIDD 76 Integer A/P Retention Period A X 
RETARAMTSR 77 BCD*10.3 Retainage Receivable A 
RETARAMTHM 78 BCD*10.3 Retainage Receivable A X 
RETARRECSR 79 BCD*10.3 Retainage Amount Received in A/R A X 
RETARRECHM 80 BCD*10.3 Retainage Amount Received in A/R A X 
RETAPAMT 81 BCD*10.3 Retainage Payable A 
RETAPPAID 82 BCD*10.3 Retainage Amount Paid in A/P A X 
POAMOUNTSR 83 BCD*10.3 Reserved A X 
POAMOUNTHM 84 BCD*10.3 Reserved A X 
POQTY 85 BCD*10.5 Committed P/O Quantity A 
OEAMOUNTSR 86 BCD*10.3 Reserved A X 
OEAMOUNTHM 87 BCD*10.3 Recognized Loss A 
OEQTY 88 BCD*10.5 Reserved A X 
POSTDATE 89 Date Last Posting Date A X 
WIPACCT 90 String*45 Work in Progress A X  Mask: %-45C
COSTACCT 91 String*45 Cost of Sales A X  Mask: %-45C
PAYACCT 92 String*45 Payroll Expense A X  Mask: %-45C
EXPACCT 93 String*45 Employee Expense A X  Mask: %-45C
EQUIPACCT 94 String*45 Equipment A X  Mask: %-45C
OHACCT 95 String*45 Overhead A X  Mask: %-45C
LABACCT 96 String*45 Labor A X  Mask: %-45C
GAINACCT 97 String*45 Unrecognized Gain/Loss A  Mask: %-45C
LCSTAMT 98 BCD*10.3 Last Cost Amount A X 
LCSTDATE 99 Date Last Cost Date A X 
INVPEND 101 BCD*10.3 Invoice Pending A X 
LRECAMT 102 BCD*10.3 Last Amount Recognized A X 
LRECDATE 103 Date Last Recognized Date A X 
LINVAMT 104 BCD*10.3 Last Invoice Amount A X 
LINVDATE 105 Date Last Invoice Date A X 
TAUTH1 106 String*12 Tax Authority 1 A X  Mask: %-12N
TAUTH2 107 String*12 Tax Authority 2 A X  Mask: %-12N
TAUTH3 108 String*12 Tax Authority 3 A X  Mask: %-12N
TAUTH4 109 String*12 Tax Authority 4 A X  Mask: %-12N
TAUTH5 110 String*12 Tax Authority 5 A X  Mask: %-12N
TCLASS1 111 Integer Tax Class 1 A X 
TCLASS2 112 Integer Tax Class 2 A X 
TCLASS3 113 Integer Tax Class 3 A X 
TCLASS4 114 Integer Tax Class 4 A X 
TCLASS5 115 Integer Tax Class 5 A X 
TINCLUDED1 116 Boolean Tax Included 1 A X 
TINCLUDED2 117 Boolean Tax Included 2 A X 
TINCLUDED3 118 Boolean Tax Included 3 A X 
TINCLUDED4 119 Boolean Tax Included 4 A X 
TINCLUDED5 120 Boolean Tax Included 5 A X 
TAXBASES1 121 BCD*10.3 Tax Base 1 A X 
TAXBASES2 122 BCD*10.3 Tax Base 2 A X 
TAXBASES3 123 BCD*10.3 Tax Base 3 A X 
TAXBASES4 124 BCD*10.3 Tax Base 4 A X 
TAXBASES5 125 BCD*10.3 Tax Base 5 A X 
TAXBASEH1 126 BCD*10.3 Tax Base 1 A X 
TAXBASEH2 127 BCD*10.3 Tax Base 2 A X 
TAXBASEH3 128 BCD*10.3 Tax Base 3 A X 
TAXBASEH4 129 BCD*10.3 Tax Base 4 A X 
TAXBASEH5 130 BCD*10.3 Tax Base 5 A X 
TAXAMTS1 131 BCD*10.3 Tax Amount 1 A X 
TAXAMTS2 132 BCD*10.3 Tax Amount 2 A X 
TAXAMTS3 133 BCD*10.3 Tax Amount 3 A X 
TAXAMTS4 134 BCD*10.3 Tax Amount 4 A X 
TAXAMTS5 135 BCD*10.3 Tax Amount 5 A X 
TAXAMTH1 136 BCD*10.3 Tax Amount 1 A X 
TAXAMTH2 137 BCD*10.3 Tax Amount 2 A X 
TAXAMTH3 138 BCD*10.3 Tax Amount 3 A X 
TAXAMTH4 139 BCD*10.3 Tax Amount 4 A X 
TAXAMTH5 140 BCD*10.3 Tax Amount 5 A X 
INVSTATE 141 Integer Invoice Status A X  List:3 entries
1 = Not Processed
2 = On Worksheet
3 = On Invoice
BILLAMT 147 BCD*10.3 Expected Billings A 
LSTBILLPER 148 BCD*5.5 Last Billings Percent Complete A 
PRFTLOSSSR 149 BCD*10.3 Recognized Profit / Loss A X 
PRFTLOSSHM 150 BCD*10.3 Recognized Profit / Loss A X 
REVESTDATE 151 Date Last Revised Posting Date A X 
LSTRRPER 152 BCD*5.5 Last Rev. Recognition Percentage A X 
OOHTYPE 153 Integer Overhead Type A X  List:3 entries
1 = None
2 = Flat Rate Per Unit
5 = Percentage of Cost
OOHRATE 154 BCD*10.6 Overhead Rate A X 
OOHPER 155 BCD*5.5 Overhead Percentage A X 
COHTYPE 156 Integer Overhead Type A X  List:3 entries
1 = None
2 = Flat Rate Per Unit
5 = Percentage of Cost
COHRATE 157 BCD*10.6 Overhead Rate A X 
COHPER 158 BCD*5.5 Overhead Percentage A X 
OLABORTYPE 159 Integer Labor Type A X  List:3 entries
1 = None
2 = Flat Rate Per Labor Hour/Unit
3 = Percentage of Labor Cost
OLABORRATE 160 BCD*10.6 Labor Rate A X 
OLABORPER 161 BCD*5.5 Labor Percentage A X 
CLABORTYPE 162 Integer Labor Type A X  List:3 entries
1 = None
2 = Flat Rate Per Labor Hour/Unit
3 = Percentage of Labor Cost
CLABORRATE 163 BCD*10.6 Labor Rate A X 
CLABORPER 164 BCD*5.5 Labor Percentage A X 
OUNITCOST 165 BCD*10.6 Original Unit Cost A X 
OBILLRATE 166 BCD*10.6 Original Billing Rate A X 
OCOSTPLUSP 167 BCD*5.5 Original Cost Plus Percentage A X 
CUNITCOST 168 BCD*10.6 Current Unit Cost A X 
CBILLRATE 169 BCD*10.6 Current Billing Rate A X 
CCOSTPLUSP 170 BCD*5.5 Current Cost Plus Percentage A X 
ODATEFROM 171 Date Projected Start Date A X 
ODATETO 172 Date Projected End Date A X 
CDATEFROM 173 Date Current Start Date A X 
CDATETO 174 Date Current End Date A X 
ORATETYPE 175 String*2 Original Rate Type A X 
ORATEDATE 176 Date Original Rate Date A X 
ORATE 177 BCD*8.7 Original Rate A X 
CRATETYPE 178 String*2 Current Rate Type A X 
CRATEDATE 179 Date Current Rate Date A X 
CRATE 180 BCD*8.7 Current Rate A X 
PLCODE 181 String*16 Reserved A X 
DEFRETFROM 182 Integer Default Retainage From A X  List:2 entries
0 = Category
1 = Vendor
BILLAMTC 183 BCD*10.3 Current Billings (AR and on BW) A 
POCOSTHM 184 BCD*10.3 Committed P/O Cost A 
POOHHM 185 BCD*10.3 Committed P/O Overhead A 
POLABORHM 186 BCD*10.3 Committed P/O Labor A 
POTCOSTHM 187 BCD*10.3 Committed P/O Total Cost A 
VALUES 188 Long Optional Fields A C X 
TCUNITCOST 189 Integer Default Unit Cost From A X  List:3 entries
0 = Use Default PJC Option
2 = PJC Employee Setup
6 = Category
TCBILLRATE 190 Integer Default Billing Rate From A X  List:3 entries
0 = Use Default PJC Option
2 = PJC Employee Setup
6 = Category
CEACCT 191 String*45 Cost A X  Mask: %-45C
STRDQTY 192 BCD*10.5 Stored Quantity A 
STRDCOSTHM 193 BCD*10.3 Stored Cost A 
STRDBILLSR 194 BCD*10.3 Stored Billable Amount A 
PRECOLEDSR 195 BCD*10.3 Previous D + E A 
STRDOHHM 196 BCD*10.3 Overhead Amount A 
STRDTCSTHM 197 BCD*10.3 Total Stored Cost A 
TXEXPCOMHM 198 BCD*10.3 Tax (exp) Committed (func) A 
TXALLCOMHM 199 BCD*10.3 Tax (all) Committed (func) A 
PREAIAPAY 200 BCD*10.3 Previous Certificates for Payment A 
PRESTORED 201 BCD*10.3 G703 Column F from Last AIA Report A 
PRERETAIN 202 BCD*10.3 G703 Column I from Last AIA Report A 
WIPDESC 1000 String*60 WIP Account Description rt A C 
COSTDESC 1001 String*60 COS Account Description rt A C 
PAYDESC 1002 String*60 Payroll Account Description rt A C 
EXPDESC 1003 String*60 Employee Account Description rt A C 
EQUIPDESC 1004 String*60 Equipment Account Description rt A C 
OHDESC 1005 String*60 Overhead Account Description rt A C 
LABDESC 1006 String*60 Labour Account Description rt A C 
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
CEDESC 1023 String*60 Cost Account Description rt A C 

This page was generated on 2023-Aug-31

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