Table: Projects

Table: PMPROJT
View: PM0022
Record length: 1081
Flags: A R 

Keys: 1


Title  Flags  Fields

Contract Uniquifier/Line Number   CTUNIQ, PLINENUM

Fields: 132


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  PERTREV   
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 Amount Due in A/R   
RETARAMTHM  BCD*10.3  Retainage Amount Due in A/R   
RETARRECSR  BCD*10.3  Retainage Amount Received in A/R   
RETARRECHM  BCD*10.3  Retainage Amount Due in A/R   
RETAPAMT  BCD*10.3  Retainage Amount Payable in A/P   
RETAPPAID  BCD*10.3  Retainage Amount Paid in A/P   
POAMOUNTSR  BCD*10.3  Outstanding Purchase Order Amt   
POAMOUNTHM  BCD*10.3  Outstanding Purchase Order Amt   
POQTY  BCD*10.5  Outstanding Purchase Order Qty   
OEAMOUNTSR  BCD*10.3  Outstanding Order Entry Amount   
OEAMOUNTHM  BCD*10.3  Outstanding Order Entry Amount   
OEQTY  BCD*10.5  Outstanding Order Entry Qty   
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 Dat   
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   
PTAXTOTAL  BCD*10.3  PTAXTOTAL   
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   

This page was generated on 2003-May-05

Copyright © 2003 ACCPAC International, Inc. All rights reserved.