# View: ^1 ^6

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

## Compositions: 3

RotoID | Tables | Title | DLL
--- | --- | --- | ---
PM0022 | PMPROJS, PMPROJT | ^5 | PMPROJS
PM0021 | PMCONTS, PMCONTT | ^4 | PMCONTS
PM0852 | PMCATGTO | Category Optional Field | PMCATGTO

## Keys: 4

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

## 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 2008-May-01

Copyright © 2001–2008 Sage Software, Inc. All rights reserved.