Table: Projects

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  Contract 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  Project 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  Project 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: %-30c
OTHERPHONE  String*30  Other Phone  Mask: %-30c
CTACFAX  String*30  Fax  Mask: %-30c
CTACEMAIL  String*60  E-mail   
MULTICUST  Integer  Invoice to Multiple Customers  List: 2 entries
1=Yes
0=No
BILLED  Integer  Has this Project 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 2009-Nov-19

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