# 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 2008-May-01

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