# Table: Projects

Table: PMPROJS
View: PM0022
Record length: 1774
Flags: A R

## Keys: 3

Title | Flags | Fields
--- | --- | ---
Contract Uniquifier/Line Number |  | CTUNIQ, PLINENUM
Contract Uniquifier/Detail Numbe |  | CTUNIQ, DETAILNUM
Contract/Project |  | CONTRACT, PROJECT

## Fields: 164

Field | Type | Title | Presentation
--- | --- | --- | ---
CTUNIQ | BCD*10.0 | Contract Uniq |
PLINENUM | Long | Line Number |
AUDTDATE | Date |  |
AUDTTIME | Time |  |
AUDTUSER | String*8 |  |
AUDTORG | String*6 |  |
CONTRACT | String*16 | Contract | Mask: %-16C
PROJECT | String*16 | Project | 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 | Project 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 | Project 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 Categories |
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 | PERTIMEQTY |
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 |

This page was generated on 2006-Sep-07

Copyright © 2001–2005 Sage Accpac International, Inc.