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.