Table: ^4

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 ^1 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 ^2 Amount
FPAMOUNTHM BCD*10.3 ^2 Amount
LSTBILLPER BCD*5.5 Last Billings Percent Complete
BILLAMTSR BCD*10.3 Amt Bill Fixed Price ^1
BILLAMTHM BCD*10.3 Amt Bill Fixed Price ^1
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 ^5
OPENED Boolean ^1 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: (%-3C) %-3C-%-24C
OTHERPHONE String*30 Other Phone Mask: (%-3C) %-3C-%-24C
CTACFAX String*30 Fax Mask: (%-3C) %-3C-%-24C
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 2021-Nov-24

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