Table: ^5

Table: PMPROJT
View: PM0022
Record Length: 2196

Flags: A R 

Keys: 1

Title Flags Fields
Contract Uniquifier/Line Number CTUNIQ, PLINENUM

Fields: 234

Field Type Title Presentation
CTUNIQ BCD*10.0 ^1 Uniq
PLINENUM Long Line Number
AUDTDATE Date
AUDTTIME Time
AUDTUSER String*8
AUDTORG String*6
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 Reserved
ORJLABHM BCD*10.3 Original Labor Amount Estimate
CURLABSR BCD*10.3 Reserved
CURLABHM BCD*10.3 Current Labor Amount Estimate
ACTLABSR BCD*10.3 Reserved
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
ACTCHRGHM BCD*10.3 Actual Charge Amount
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
PERTREV BCD*5.5 Percent Total Revenue
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
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 Committed P/O Quantity
OEAMOUNTSR BCD*10.3 Reserved
OEAMOUNTHM BCD*10.3 Recognized Loss
OEQTY BCD*10.5 Reserved
PCOMPLETEB BCD*5.5 Billings Percent Complete
PCOMPLETER BCD*5.5 RR Percent Complete
FPAMOUNTSR BCD*10.3 Fixed Price Amount
FPAMOUNTHM BCD*10.3 Fixed Price Amount
LSTBILLPER BCD*5.5 Last Billings Percent Complete
BILLAMTRSR BCD*10.3 Recognized Amount to Bill
BILLAMTRHM BCD*10.3 Recognized Amount to Bill
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 Revenue Rec 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 Reserved
OEINVDATE Date Last O/E Invoice Date
PTAXTOTAL BCD*10.3 Project tax total
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
ONBW Boolean On Billing Worksheet
OPENED Boolean ^2 Has Been Opened List:2 entries
0 = No
1 = Yes
BILLAMT BCD*10.3 Expected Billings
ORATEOP Integer Rate Operator List:2 entries
1 = Multiply
2 = Divide
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
ONRW Boolean On RR Worksheet
OLABEMHM BCD*10.3 Original Employee Labor
CLABEMHM BCD*10.3 Current Employee Labor
ALABEMHM BCD*10.3 Actual Employee Labor
OOHEMHM BCD*10.3 Original Employee Overhead
COHEMHM BCD*10.3 Current Employee Overhead
AOHEMHM BCD*10.3 Actual Employee Overhead
OOHEQHM BCD*10.3 Original Equipment Overhead
COHEQHM BCD*10.3 Current Equipment Overhead
AOHEQHM BCD*10.3 Actual Equipment Overhead
OOHSUHM BCD*10.3 Original Subcontractor Overhead
COHSUHM BCD*10.3 Current Subcontractor Overhead
AOHSUHM BCD*10.3 Actual Subcontractor Overhead
OOHOHHM BCD*10.3 Original Overhead Overhead
COHOHHM BCD*10.3 Current Overhead Overhead
AOHOHHM BCD*10.3 Actual Overhead Overhead
OOHMIHM BCD*10.3 Original Miscellaneous Overhead
COHMIHM BCD*10.3 Current Miscellaneous Overhead
AOHMIHM BCD*10.3 Actual Miscellaneous Overhead
OOHMAHM BCD*10.3 Original Material Overhead
COHMAHM BCD*10.3 Current Material Overhead
AOHMAHM BCD*10.3 Actual Material Overhead
CDATEFROM Date Current Start Date
PROJSTYLE Integer ^2 Style List:2 entries
1 = Standard
2 = Basic
APTAXEXPHM BCD*10.3 Reserved
APTAXRECHM BCD*10.3 Reserved
APTAXEXCHM BCD*10.3 Reserved
APDISCHM BCD*10.3 Reserved
APINTHM BCD*10.3 Reserved
ARTAXHM BCD*10.3 Reserved
ARTAXSR BCD*10.3 Reserved
ARDISCHM BCD*10.3 Reserved
ARDISCSR BCD*10.3 Reserved
ARINTHM BCD*10.3 Reserved
ARINTSR BCD*10.3 Reserved
ARWRITEHM BCD*10.3 Reserved
ARWRITESR BCD*10.3 Reserved
PLCODE String*16 Reserved
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
POEMQTY BCD*10.5 P/O Employee Quantity
POEMOHHM BCD*10.3 P/O Employee Overhead
POEMLABHM BCD*10.3 P/O Employee Labor
POEMTCOSTH BCD*10.3 P/O Employee Total Cost
POEQQTY BCD*10.5 P/O Equipment Quantity
POEQOHHM BCD*10.3 P/O Equipment Overhead
POEQTCOSTH BCD*10.3 P/O Equipment Total Cost
POSUQTY BCD*10.5 P/O Subcontractor Quantity
POSUOHHM BCD*10.3 P/O Subcontractor Overhead
POSUTCOSTH BCD*10.3 P/O Subcontractor Total Cost
POOHQTY BCD*10.5 P/O Overhead Quantity
POOHOHHM BCD*10.3 P/O Overhead Overhead
POOHTCOSTH BCD*10.3 P/O Overhead Total Cost
POMIQTY BCD*10.5 P/O Miscellaneous Quantity
POMIOHHM BCD*10.3 P/O Miscellaneous Overhead
POMITCOSTH BCD*10.3 P/O Miscellaneous Total Cost
POMAQTY BCD*10.5 P/O Material Quantity
POMAOHHM BCD*10.3 P/O Material Overhead
POMATCOSTH BCD*10.3 P/O Material Total Cost
VALUES Long Optional Fields
CLEARED Integer Transactions have been cleared List:2 entries
0 = No
1 = Yes
CODETAXGRP String*12 Tax Group Mask: %-12N
CTCLASS1 Integer Customer Tax Class 1
CTCLASS2 Integer Customer Tax Class 2
CTCLASS3 Integer Customer Tax Class 3
CTCLASS4 Integer Customer Tax Class 4
CTCLASS5 Integer Customer Tax Class 5
CTAUTH1 String*12 Customer Tax Authority 1
CTAUTH2 String*12 Customer Tax Authority 2
CTAUTH3 String*12 Customer Tax Authority 3
CTAUTH4 String*12 Customer Tax Authority 4
CTAUTH5 String*12 Customer Tax Authority 5
LUPDATE Date Last US Payroll Posting Date
LCPDATE Date Last Canadian Payroll Posting Date
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)
STRDQTY BCD*10.5 Stored Quantity
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
IDACCTSET String*6 Account Set Mask: %-6N
CUSTCCY String*3 Customer Currency
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
MULTICUST Integer Invoice to Multiple Customers List:2 entries
1 = Yes
0 = No
BILLED Integer Has this ^2 been billed?
OESHPDATE Date Last O/E Shipment Date
PRICEOPT Integer Default Billing Rate List:3 entries
1 = Billing Rate
2 = Use Customer Price List
3 = Use Specified Price List
PRICELIST String*6 Price List Mask: %-6N
OEMCHGOPT Integer O/E Miscellaneous Charges List:2 entries
0 = Default Cost from Contract
1 = Default Cost from Misc. Charges
ARACCTSET String*6 A/R Account Set Mask: %-6N

This page was generated on 2023-Aug-31

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