# Table: Contract Categories

Table: PMCATGT
View: PM0039
Record length: 1968
Flags: A R

## Keys: 5

Title | Flags | 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: 194

Field | Type | Title | Presentation
--- | --- | --- | ---
CTUNIQ | BCD*10.0 | Contract Unique Code |
PLINENUM | Long | Project Line Number |
CLINENUM | Long | Line Number |
AUDTDATE | Date |  |
AUDTTIME | Time |  |
AUDTUSER | String*8 |  |
AUDTORG | String*6 |  |
CONTRACT | String*16 | Contract | Mask: %-16C
PROJECT | String*16 | Project | Mask: %-16N
CATEGORY | String*16 | Category | Mask: %-16N
CCY | String*3 | Currency | Mask: %-3N
DETAILNUM | Long | Project Detail Number |
DNUM | Long | Category Detail Number |
DATELASTMN | Date | Last Maintained |
DESC | String*60 | Description |
COSTTYPE | String*10 | Cost Type | Mask: %-10N
TYPE | Integer | Cost Class | List: 6 entries
1 | = | Labor
2 | = | Material
3 | = | Equipment
4 | = | Subcontractor
5 | = | Overhead
6 | = | Miscellaneous
PONUMBER | String*22 | Last Purchase Order Number | Mask: %-22C
BILLTYPE | Integer | Billing Type | List: 3 entries
2 | = | Billable
3 | = | No Charge
1 | = | Non-billable
ORJQTY | BCD*10.5 | Quantity |
CURQTY | BCD*10.5 | Current Quantity Estimate |
ACTQTY | BCD*10.5 | Actual Quantity |
ARITEM | String*16 | A/R Item No. | Mask: %-16C
UOM | String*10 | Unit of Measure | Mask: %-10C
UNITCOST | BCD*10.6 | Unit Cost |
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 |
BILLRATE | BCD*10.6 | Billing Rate |
OVERHD | Integer | Overhead Type | List: 3 entries
1 | = | None
2 | = | Flat Rate Per Unit
5 | = | Percentage of Cost
OHEADRATE | BCD*10.6 | Overhead Rate |
HEADPER | BCD*5.5 | Overhead Percentage |
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 |
LABOR | Integer | Labor Type | List: 3 entries
1 | = | None
2 | = | Flat Rate Per Labor Hour/Unit
3 | = | Percentage of Labor Cost
LABORRATE | BCD*10.6 | Labor Rate |
LABORPER | BCD*5.5 | Labor Percentage |
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 |
COSTPLUSP | BCD*5.5 | Cost Plus Percentage |
ORJBILLSR | BCD*10.3 | Revenue |
ORJBILLHM | BCD*10.3 | Revenue |
CURBILLSR | BCD*10.3 | Current Revenue Estimate |
CURBILLHM | BCD*10.3 | Current Revenue Estimate |
ACTBILLHM | BCD*10.3 | Total Actual Revenue |
ACTBILLSR | BCD*10.3 | Total Actual Revenue |
ACTBILRRHM | BCD*10.3 | Total Revenue Recognized |
ACTBILRRSR | BCD*10.3 | Total Revenue Recognized |
CCYBILL | String*3 | Customer Currency | Mask: %-3N
TORJCOSTSR | BCD*10.3 | Reserved |
TORJCOSTHM | BCD*10.3 | Total Original Estimate Cost |
TCURCOSTSR | BCD*10.3 | Reserved |
TCURCOSTHM | BCD*10.3 | Total Current Estimate Cost |
TACTCOSTSR | BCD*10.3 | Reserved |
TACTCOSTHM | BCD*10.3 | Total Actual Cost |
TCOSTRRSR | BCD*10.3 | Reserved |
TCOSTRRHM | BCD*10.3 | Total Cost Recognized |
PERTOTCOST | BCD*5.5 | Percent Total Cost |
TARRECTSSR | BCD*10.3 | Total A/R Customer Receipts |
TARRECTSHM | BCD*10.3 | Total A/R Customer Receipts |
TAPPAYMTS | BCD*10.3 | A/P Vendor Payments |
PERRETPAID | BCD*5.5 | A/P Retainage Percentage |
RETPAIDD | Integer | A/P Retention Period |
RETARAMTSR | BCD*10.3 | Retainage Receivable |
RETARAMTHM | BCD*10.3 | Retainage Receivable |
RETARRECSR | BCD*10.3 | Retainage Amount Received in A/R |
RETARRECHM | BCD*10.3 | Retainage Amount Received in A/R |
RETAPAMT | BCD*10.3 | Retainage Payable |
RETAPPAID | BCD*10.3 | Retainage Amount Paid in A/P |
POAMOUNTSR | BCD*10.3 | Reserved |
POAMOUNTHM | BCD*10.3 | Reserved |
POQTY | BCD*10.5 | Committed P/O Quantity |
OEAMOUNTSR | BCD*10.3 | Reserved |
OEAMOUNTHM | BCD*10.3 | Recognized Loss |
OEQTY | BCD*10.5 | Reserved |
POSTDATE | Date | Last Posting Date |
WIPACCT | String*45 | Work in Progress | Mask: %-45C
COSTACCT | String*45 | Cost of Sales | Mask: %-45C
PAYACCT | String*45 | Payroll Expense | Mask: %-45C
EXPACCT | String*45 | Employee Expense | Mask: %-45C
EQUIPACCT | String*45 | Equipment | Mask: %-45C
OHACCT | String*45 | Overhead | Mask: %-45C
LABACCT | String*45 | Labor | Mask: %-45C
GAINACCT | String*45 | Unrecognized Gain/Loss | Mask: %-45C
LCSTAMT | BCD*10.3 | Last Cost Amount |
LCSTDATE | Date | Last Cost Date |
INVPEND | BCD*10.3 | Invoice Pending |
LRECAMT | BCD*10.3 | Last Amount Recognized |
LRECDATE | Date | Last Recognized Date |
LINVAMT | BCD*10.3 | Last Invoice Amount |
LINVDATE | Date | Last Invoice Date |
TAUTH1 | String*12 | Tax Authority 1 | Mask: %-12N
TAUTH2 | String*12 | Tax Authority 2 | Mask: %-12N
TAUTH3 | String*12 | Tax Authority 3 | Mask: %-12N
TAUTH4 | String*12 | Tax Authority 4 | Mask: %-12N
TAUTH5 | String*12 | Tax Authority 5 | Mask: %-12N
TCLASS1 | Integer | Tax Class 1 |
TCLASS2 | Integer | Tax Class 2 |
TCLASS3 | Integer | Tax Class 3 |
TCLASS4 | Integer | Tax Class 4 |
TCLASS5 | Integer | Tax Class 5 |
TINCLUDED1 | Boolean | Tax Included 1 |
TINCLUDED2 | Boolean | Tax Included 2 |
TINCLUDED3 | Boolean | Tax Included 3 |
TINCLUDED4 | Boolean | Tax Included 4 |
TINCLUDED5 | Boolean | Tax Included 5 |
TAXBASES1 | BCD*10.3 | Tax Base 1 |
TAXBASES2 | BCD*10.3 | Tax Base 2 |
TAXBASES3 | BCD*10.3 | Tax Base 3 |
TAXBASES4 | BCD*10.3 | Tax Base 4 |
TAXBASES5 | BCD*10.3 | Tax Base 5 |
TAXBASEH1 | BCD*10.3 | Tax Base 1 |
TAXBASEH2 | BCD*10.3 | Tax Base 2 |
TAXBASEH3 | BCD*10.3 | Tax Base 3 |
TAXBASEH4 | BCD*10.3 | Tax Base 4 |
TAXBASEH5 | BCD*10.3 | Tax Base 5 |
TAXAMTS1 | BCD*10.3 | Tax Amount 1 |
TAXAMTS2 | BCD*10.3 | Tax Amount 2 |
TAXAMTS3 | BCD*10.3 | Tax Amount 3 |
TAXAMTS4 | BCD*10.3 | Tax Amount 4 |
TAXAMTS5 | BCD*10.3 | Tax Amount 5 |
TAXAMTH1 | BCD*10.3 | Tax Amount 1 |
TAXAMTH2 | BCD*10.3 | Tax Amount 2 |
TAXAMTH3 | BCD*10.3 | Tax Amount 3 |
TAXAMTH4 | BCD*10.3 | Tax Amount 4 |
TAXAMTH5 | BCD*10.3 | Tax Amount 5 |
INVSTATE | Integer | Invoice Status | List: 3 entries
1 | = | Not Processed
2 | = | On Worksheet
3 | = | On Invoice
BILLAMT | BCD*10.3 | Expected Billings |
LSTBILLPER | BCD*5.5 | Last Billings Percent Complete |
PRFTLOSSSR | BCD*10.3 | Recognized Profit / Loss |
PRFTLOSSHM | BCD*10.3 | Recognized Profit / Loss |
REVESTDATE | Date | Last Revised Posting Date |
LSTRRPER | BCD*5.5 | Last Rev. Recognition Percentage |
OOHTYPE | Integer | Overhead Type | List: 3 entries
1 | = | None
2 | = | Flat Rate Per Unit
5 | = | Percentage of Cost
OOHRATE | BCD*10.6 | Overhead Rate |
OOHPER | BCD*5.5 | Overhead Percentage |
COHTYPE | Integer | Overhead Type | List: 3 entries
1 | = | None
2 | = | Flat Rate Per Unit
5 | = | Percentage of Cost
COHRATE | BCD*10.6 | Overhead Rate |
COHPER | BCD*5.5 | Overhead Percentage |
OLABORTYPE | Integer | Labor Type | List: 3 entries
1 | = | None
2 | = | Flat Rate Per Labor Hour/Unit
3 | = | Percentage of Labor Cost
OLABORRATE | BCD*10.6 | Labor Rate |
OLABORPER | BCD*5.5 | Labor Percentage |
CLABORTYPE | Integer | Labor Type | List: 3 entries
1 | = | None
2 | = | Flat Rate Per Labor Hour/Unit
3 | = | Percentage of Labor Cost
CLABORRATE | BCD*10.6 | Labor Rate |
CLABORPER | BCD*5.5 | Labor Percentage |
OUNITCOST | BCD*10.6 | Original Unit Cost |
OBILLRATE | BCD*10.6 | Original Billing Rate |
OCOSTPLUSP | BCD*5.5 | Original Cost Plus Percentage |
CUNITCOST | BCD*10.6 | Current Unit Cost |
CBILLRATE | BCD*10.6 | Current Billing Rate |
CCOSTPLUSP | BCD*5.5 | Current Cost Plus Percentage |
ODATEFROM | Date | Projected Start Date |
ODATETO | Date | Projected End Date |
CDATEFROM | Date | Current Start Date |
CDATETO | Date | Current End Date |
ORATETYPE | String*2 | Original Rate Type |
ORATEDATE | Date | Original Rate Date |
ORATE | BCD*8.7 | Original Rate |
CRATETYPE | String*2 | Current Rate Type |
CRATEDATE | Date | Current Rate Date |
CRATE | BCD*8.7 | Current Rate |
PLCODE | String*16 | Reserved |
DEFRETFROM | Integer | Default Retainage From | List: 2 entries
0 | = | Category
1 | = | Vendor
BILLAMTC | BCD*10.3 | Current Billings (AR and on BW) |
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 | Default Unit Cost From | List: 3 entries
0 | = | Use Default PJC Option
2 | = | PJC Employee Setup
6 | = | Category
TCBILLRATE | Integer | Default Billing Rate From | List: 3 entries
0 | = | Use Default PJC Option
2 | = | PJC Employee Setup
6 | = | Category
CEACCT | String*45 | Cost | Mask: %-45C
STRDQTY | BCD*10.5 | Stored Quantity |
STRDCOSTHM | BCD*10.3 | Stored Cost |
STRDBILLSR | BCD*10.3 | Stored Billable Amount |
PRECOLEDSR | BCD*10.3 | Previous D + E |
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 |

This page was generated on 2009-Nov-19

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