# Table: Contracts

Table: PMCONTT
View: PM0021
Record length: 1891
Flags: A R

## Keys: 1

Title | Flags | Fields
--- | --- | ---
Contract Uniquifier |  | CTUNIQ

## Fields: 191

Field | Type | Title | Presentation
--- | --- | --- | ---
CTUNIQ | BCD*10.0 | Contract Uniq |
AUDTDATE | Date |  |
AUDTTIME | Time |  |
AUDTUSER | String*8 |  |
AUDTORG | String*6 |  |
ORJSUBCCSR | BCD*10.3 | Reserved |
ORJSUBCCHM | BCD*10.3 | Orig. Subcontractor Est. Cost |
CURSUBCCSR | BCD*10.3 | Reserved |
CURSUBCCHM | BCD*10.3 | Cur. Subcontractor Est. Cost |
ACTSUBCCSR | BCD*10.3 | Reserved |
ACTSUBCCHM | BCD*10.3 | Actual Subcontractor Cost |
RECSUBCCSR | BCD*10.3 | Reserved |
RECSUBCCHM | BCD*10.3 | Reserved |
ORJSUBCBSR | BCD*10.3 | Orig. Subcontract Billing Est. |
ORJSUBCBHM | BCD*10.3 | Orig. Subcontract Billing Est. |
CURSUBCBSR | BCD*10.3 | Cur. Subcontract Billing Est. |
CURSUBCBHM | BCD*10.3 | Cur. Subcontract Billing Est. |
ACTSUBCBSR | BCD*10.3 | Actual Subcontract Amt Billed |
ACTSUBCBHM | BCD*10.3 | Actual Subcontract Amt Billed |
RECSUBCBSR | BCD*10.3 | Reserved |
RECSUBCBHM | BCD*10.3 | Reserved |
ORJSUBCQTY | BCD*10.5 | Orig. Subcontractor Qty Est. |
CURSUBCQTY | BCD*10.5 | Cur. Subcontractor Est. |
ACTSUBCQTY | BCD*10.5 | Actual Subcontractor Qty |
ORJOHEXCSR | BCD*10.3 | Reserved |
ORJOHEXCHM | BCD*10.3 | Orig. Est Overhead Expense Cost |
CUROHEXCSR | BCD*10.3 | Reserved |
CUROHEXCHM | BCD*10.3 | Cur. Est. Overhead Expense Cost |
ACTOHEXCSR | BCD*10.3 | Reserved |
ACTOHEXCHM | BCD*10.3 | Actual Overhead Expense Cost |
RECOHEXCSR | BCD*10.3 | Reserved |
RECOHEXCHM | BCD*10.3 | Reserved |
ORJOHEXBSR | BCD*10.3 | Orig. Overhead Billing Est. |
ORJOHEXBHM | BCD*10.3 | Orig. Overhead Billing Est. |
CUROHEXBSR | BCD*10.3 | Cur. Overhead Billing Est. |
CUROHEXBHM | BCD*10.3 | Cur. Overhead Billing Est. |
ACTOHEXBSR | BCD*10.3 | Actual Overhead Amount Billed |
ACTOHEXBHM | BCD*10.3 | Actual Overhead Billing Est. |
RECOHEXBSR | BCD*10.3 | Reserved |
RECOHEXBHM | BCD*10.3 | Reserved |
ORJOHEXQTY | BCD*10.5 | Orig. Overhead Qty Est. |
CUROHEXQTY | BCD*10.5 | Cur. Overhead Est. |
ACTOHEXQTY | BCD*10.5 | Actual Overhead Qty |
ORJMISCCSR | BCD*10.3 | Reserved |
ORJMISCCHM | BCD*10.3 | Orig. Est. Miscellaneous Cost |
CURMISCCSR | BCD*10.3 | Reserved |
CURMISCCHM | BCD*10.3 | Cur. Est. Miscellaneous Cost |
ACTMISCCSR | BCD*10.3 | Reserved |
ACTMISCCHM | BCD*10.3 | Actual Miscellaneous Cost |
RECMISCCSR | BCD*10.3 | Reserved |
RECMISCCHM | BCD*10.3 | Reserved |
ORJMISCBSR | BCD*10.3 | Orig. Miscellaneous Billing Est |
ORJMISCBHM | BCD*10.3 | Orig. Miscellaneous Billing Est |
CURMISCBSR | BCD*10.3 | Cur. Miscellaneous Billing Est. |
CURMISCBHM | BCD*10.3 | Cur. Miscellaneous Billing Est. |
ACTMISCBSR | BCD*10.3 | Actual Miscellaneous Amt Billed |
ACTMISCBHM | BCD*10.3 | Actual Miscellaneous Amt Billed |
RECMISCBSR | BCD*10.3 | Reserved |
RECMISCBHM | BCD*10.3 | Reserved |
ORJMISCQTY | BCD*10.5 | Orig. Miscellaneous Qty Est. |
CURMISCQTY | BCD*10.5 | Cur. Miscellaneous Est. |
ACTMISCQTY | BCD*10.5 | Actual Miscellaneous Qty |
ORJOHEADSR | BCD*10.3 | Reserved |
ORJOHEADHM | BCD*10.3 | Original Overhead Estimate |
CUROHEADSR | BCD*10.3 | Reserved |
CUROHEADHM | BCD*10.3 | Current Overhead Estimate |
ACTOHEADSR | BCD*10.3 | Reserved |
ACTOHEADHM | BCD*10.3 | Actual Overhead |
ORJLABSR | BCD*10.3 | Original Labor Amount Estimate |
ORJLABHM | BCD*10.3 | Original Labor Amount Estimate |
CURLABSR | BCD*10.3 | Current Labor Amount Estimate |
CURLABHM | BCD*10.3 | Current Labor Amount Estimate |
ACTLABSR | BCD*10.3 | Actual Labor Amount |
ACTLABHM | BCD*10.3 | Actual Labor Amount |
ORJCHRGSR | BCD*10.3 | Reserved |
ORJCHRGHM | BCD*10.3 | Reserved |
CURCHRGSR | BCD*10.3 | Reserved |
CURCHRGHM | BCD*10.3 | Reserved |
ACTCHRGSR | BCD*10.3 | Actual Charge Amount Billed |
ACTCHRGHM | BCD*10.3 | Actual Charge Amount Billed |
ACTCHRGDSR | BCD*10.3 | Act Chrg Amt Billed & Deferred |
ACTCHRGDHM | BCD*10.3 | Act Chrg Amt Billed & Deferred |
RECCHRGSR | BCD*10.3 | Reserved |
RECCHRGHM | BCD*10.3 | Reserved |
ACTSTKRESR | BCD*10.3 | Reserved |
ACTSTKREHM | BCD*10.3 | Act Cost Stock Ret to Inventory |
ACTSTKRQTY | BCD*10.5 | Act Qty Stock Ret to Inventory |
TARRECTSSR | BCD*10.3 | Total A/R Customer Receipts |
TARRECTSHM | BCD*10.3 | Total A/R Customer Receipts |
TAPPAYMTS | BCD*10.3 | Total A/P Vendor Payments |
TORJCOSTSR | BCD*10.3 | Reserved |
TORJCOSTHM | BCD*10.3 | Total Orig. Cost Est. |
TCURCOSTSR | BCD*10.3 | Reserved |
TCURCOSTHM | BCD*10.3 | Total Cur. Cost Est. |
TACTCOSTSR | BCD*10.3 | Reserved |
TACTCOSTHM | BCD*10.3 | Total Actual Cost |
TRECCOSTSR | BCD*10.3 | Reserved |
TRECCOSTHM | BCD*10.3 | Total Cost Recognized |
PERTCOST | BCD*5.5 | Percent Total Cost |
TORJREVSR | BCD*10.3 | Total Orig. Revenue Est. |
TORJREVHM | BCD*10.3 | Total Orig. Revenue Est. |
TCURREVSR | BCD*10.3 | Total Cur. Revenue Est. |
TCURREVHM | BCD*10.3 | Total Cur. Revenue Est. |
TACTREVSR | BCD*10.3 | Total Actual Revenue |
TACTREVHM | BCD*10.3 | Total Actual Revenue Est. |
TRECREVSR | BCD*10.3 | Total Revenue Recognized |
TRECREVHM | BCD*10.3 | Total Revenue Recognized |
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 | Reserved |
OEAMOUNTSR | BCD*10.3 | Reserved |
OEAMOUNTHM | BCD*10.3 | Recognized Loss |
OEQTY | BCD*10.5 | Reserved |
PCOMLETERR | BCD*5.5 | Recognized % Complete |
FPAMOUNTSR | BCD*10.3 | Project Amount |
FPAMOUNTHM | BCD*10.3 | Project Amount |
LSTBILLPER | BCD*5.5 | Last Billings Percent Complete |
BILLAMTSR | BCD*10.3 | Amt Bill Fixed Price Contract |
BILLAMTHM | BCD*10.3 | Amt Bill Fixed Price Contract |
COSTDATE | Date | Last Cost Posting Date |
BILLDATE | Date | Last Billings Posting Date |
OHDATE | Date | Last Overhead Posting Date |
CHARGEDATE | Date | Last Charge Posting Date |
REVRECDATE | Date | Last Rev. Recognition Posting Date |
ARRECDATE | Date | Last A/R Receipt Posting Date |
APPAYDATE | Date | Last A/P Payment Posting Date |
TIMEDATE | Date | Last Timecard Posting Date |
STKTRDATE | Date | Last Material Usage Posting Date |
STKRETDATE | Date | Last Material Return Posting Date |
EQUIPDATE | Date | Last Equipment Posting Date |
PODATE | Date | Last Purchase Order Date |
PORECDATE | Date | Last P/O Receipt Date |
PORETDATE | Date | Last P/O Return Date |
OEORDDATE | Date | Last O/E Order Date |
OEINVDATE | Date | Last O/E Invoice Date |
FUNCRND | BCD*10.3 | Functional Rounding Amount |
NEXTTRAN | Long | Next Transaction Number |
OPENPROJ | Long | Number of open Projects |
OPENED | Boolean | Contract Has Been Opened | List: 2 entries
0 | = | No
1 | = | Yes
BILLAMT | BCD*10.3 | Expected Billings |
PCOMPLETEB | BCD*5.5 | Billings Percent Complete |
LSTRRPER | BCD*5.5 | Last Rev. Recognition Percentage |
PRFTLOSSSR | BCD*10.3 | Recognized Profit / Loss |
PRFTLOSSHM | BCD*10.3 | Recognized Profit / Loss |
REVESTDATE | Date | Last Revised Posting Date |
CDATEFROM | Date | Current Start Date |
PLCODE | String*16 | Reserved |
RRMETHOD | Integer | Percentage Complete Method | List: 3 entries
1 | = | Clear Billings and WIP During Revenue Recognition
0 | = | Clear Billings and WIP During Project Close
2 | = | From Options
NUMPROJECT | Long | Number of Projects |
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 |
CUSCONTACT | String*60 | Contact |
CTACTITTLE | String*60 | Position |
CTACPHONE | String*30 | Phone | Mask: %-30c
OTHERPHONE | String*30 | Other Phone | Mask: %-30c
CTACFAX | String*30 | Fax | Mask: %-30c
CTACEMAIL | String*60 | E-mail |
USETAXGRP | Boolean | Tax Group |
CODETAXGRP | String*12 | Tax Group | 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 |
TAUTH1 | String*12 | Customer Tax Authority 1 |
TAUTH2 | String*12 | Customer Tax Authority 2 |
TAUTH3 | String*12 | Customer Tax Authority 3 |
TAUTH4 | String*12 | Customer Tax Authority 4 |
TAUTH5 | String*12 | Customer Tax Authority 5 |
STRDCOSTHM | BCD*10.3 | Stored Cost |
STRDBILLSR | BCD*10.3 | Stored Billable Amount |
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 |
MULTICUST | Integer | Invoice to Multiple Customers |
CURVAR | Integer | Currency different from that on project? |
BONECUST | Integer | Allow Multiple Customers | List: 2 entries
1 | = | Yes
0 | = | No
ARACCTSET | String*6 | A/R Account Set | Mask: %-6N

This page was generated on 2009-Nov-19

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