Table: ^5

Table: PMPROJS
View: PM0022
Record Length: 1786

Flags: A R 

Keys: 4

Title Flags Fields
Contract Uniquifier/Line Number CTUNIQ, PLINENUM
Contract Uniquifier/Detail Numbe CTUNIQ, DETAILNUM
Contract/Project CONTRACT, PROJECT
Customer/Contract/Project M  CUSTOMER, CONTRACT, PROJECT

Fields: 165

Field Type Title Presentation
CTUNIQ BCD*10.0 ^1 Uniq
PLINENUM Long Line Number
AUDTDATE Date
AUDTTIME Time
AUDTUSER String*8
AUDTORG String*6
CONTRACT String*16 ^1 Mask: %-16C
PROJECT String*16 ^2 Mask: %-16N
DETAILNUM Long Detail Number
DATELASTMN Date Last Maintained
STARTDATE Date Projected Start Date
ORJENDDATE Date Projected End Date
CURENDDATE Date Current End Date
CLOSEDDATE Date Date Closed
DESC String*60 Description
PROJTYPE Integer ^2 Type List:3 entries
1 = Time and Materials
2 = Fixed Price
3 = Cost Plus
REVREC Integer Accounting Method List:7 entries
1 = Completed Project
2 = Total Cost Percentage Complete
3 = Labor Hours Percentage Complete
4 = Billings and Costs
5 = Project Percentage Complete
6 = Category Percentage Complete
8 = Accrual-Basis
COSTPLUSP BCD*5.5 Cost Plus Percentage
CLOSEBILL Integer Closed to Billings List:2 entries
1 = Yes
0 = No
CLOSECOST Integer Closed to Costs List:2 entries
1 = Yes
0 = No
PROJSTAT Integer ^2 Status List:7 entries
10 = Estimate
20 = Approved
30 = Open
40 = On Hold
70 = Inactive
60 = Completed
50 = Closed
USEDEFREV Integer Revenue Type List:2 entries
0 = Revenue
1 = Deferred Revenue
BILLTYPE Integer Billing Type List:3 entries
2 = Billable
3 = No Charge
1 = Non-billable
PERRETREC BCD*5.5 A/R Retainage Percentage
RETRECD Integer A/R Retention Period
BILLACCT String*45 Billings Mask: %-45C
DEFRACCT String*45 Deferred Revenue Mask: %-45C
REVACCT String*45 Revenue Mask: %-45C
PROFITACCT String*45 Profit Mask: %-45C
LOSSACCT String*45 Loss Mask: %-45C
GAINACCT String*45 Gain Mask: %-45C
WIPACCT String*45 Work in Progress Mask: %-45C
COGSACCT String*45 Cost of Sales Mask: %-45C
PONUMBER String*22 P/O Number Mask: %-22C
FORMCODE String*6 Form Code Mask: %-6N
INVTYPE Integer A/R Invoice Type List:2 entries
1 = Item
2 = Summary
ORATE BCD*8.7 Original Exchange Rate
ORATETYPE String*2 Original Rate Type Mask: %-2N
ORATEDATE Date Original Rate Date
RATE BCD*8.7 Exchange Rate
RATETYPE String*2 Rate Type Mask: %-2N
RATEOP Integer Rate Operator List:2 entries
1 = Multiply
2 = Divide
RATEDATE Date Rate Date
RATESPREAD BCD*8.7 Rate Spread
ESTBILLCCY Integer Revenue And Cost Currency List:3 entries
1 = Revenue and Costs in Functional Currency
2 = Revenue in Customer Currency
3 = Revenue and Costs in Customer Currency
COSTCCY String*3 Cost Currency Mask: %-3N
REVCCY String*3 Revenue Currency Mask: %-3N
INVSTATE Integer Invoice Status List:3 entries
1 = Not Processed
2 = On Worksheet
3 = On Invoice
NUMCATS Long Number of ^6
ORJTIMECSR BCD*10.3 Reserved
ORJTIMECHM BCD*10.3 Orig. Labor Cost Est.
CURTIMECSR BCD*10.3 Reserved
CURTIMECHM BCD*10.3 Cur. Labor Cost Est.
ACTTIMECSR BCD*10.3 Reserved
ACTTIMECHM BCD*10.3 Actual Labor Costs
RECTIMECSR BCD*10.3 Reserved
RECTIMECHM BCD*10.3 Reserved
ORJTIMEBSR BCD*10.3 Orig. Labor Billing Est.
ORJTIMEBHM BCD*10.3 Orig. Labor Billing Est.
CURTIMEBSR BCD*10.3 Cur. Labor Billing Est.
CURTIMEBHM BCD*10.3 Cur. Labor Billing Est.
ACTTIMEBSR BCD*10.3 Actual Labor Billings
ACTTIMEBHM BCD*10.3 Actual Labor Billings
RECTIMEBSR BCD*10.3 Reserved
RECTIMEBHM BCD*10.3 Reserved
ORJTIMEQTY BCD*10.5 Orig. Labor Qty Est.
CURTIMEQTY BCD*10.5 Cur. Labor Qty Est.
ACTTIMEQTY BCD*10.5 Actual Labor Qty
PERTIMEQTY BCD*5.5 Labor Percentage Complete
ORJMATECSR BCD*10.3 Reserved
ORJMATECHM BCD*10.3 Orig. Material Estimated Cost
CURMATECSR BCD*10.3 Reserved
CURMATECHM BCD*10.3 Current Material Estimated Cost
ACTMATECSR BCD*10.3 Reserved
ACTMATECHM BCD*10.3 Actual Material Cost
RECMATECSR BCD*10.3 Reserved
RECMATECHM BCD*10.3 Reserved
ORJMATEBSR BCD*10.3 Orig. Material Billing Est.
ORJMATEBHM BCD*10.3 Orig. Material Billing Est.
CURMATEBSR BCD*10.3 Cur. Material Billing Est.
CURMATEBHM BCD*10.3 Cur. Material Billing Est.
ACTMATEBSR BCD*10.3 Actual Material Billed
ACTMATEBHM BCD*10.3 Actual Material Billed
RECMATEBSR BCD*10.3 Reserved
RECMATEBHM BCD*10.3 Reserved
ORJMATEQTY BCD*10.5 Orig. Material Qty Est.
CURMATEQTY BCD*10.5 Cur. Material Est.
ACTMATEQTY BCD*10.5 Actual Material Qty
ORJEQUICSR BCD*10.3 Reserved
ORJEQUICHM BCD*10.3 Orig. Estimated Equipment Cost
CUREQUICSR BCD*10.3 Reserved
CUREQUICHM BCD*10.3 Cur. Estimated Equipment Cost
ACTEQUICSR BCD*10.3 Reserved
ACTEQUICHM BCD*10.3 Actual Equipment Cost
RECEQUICSR BCD*10.3 Reserved
RECEQUICHM BCD*10.3 Reserved
ORJEQUIBSR BCD*10.3 Orig. Equipment Billing Est.
ORJEQUIBHM BCD*10.3 Orig. Equipment Billing Est.
CUREQUIBSR BCD*10.3 Cur. Equipment Billing Est.
CUREQUIBHM BCD*10.3 Cur. Equipment Billing Est.
ACTEQUIBSR BCD*10.3 Actual Equipment Amount Billed
ACTEQUIBHM BCD*10.3 Actual Equipment Amount Billed
RECEQUIBSR BCD*10.3 Reserved
RECEQUIBHM BCD*10.3 Reserved
ORJEQUIQTY BCD*10.5 Orig. Equipment Qty Est.
CUREQUIQTY BCD*10.5 Cur. Equipment Est.
ACTEQUIQTY BCD*10.5 Actual Equipment Qty
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 Qty Est.
ACTMISCQTY BCD*10.5 Actual Miscellaneous Qty
CUSTOMER String*12 Customer Mask: %-12C

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