# Table: Contracts

Table: PMCONTS
View: PM0021
Record length: 1370
Flags: A R

## Keys: 3

Title | Flags | Fields
--- | --- | ---
Contract Uniquifier |  | CTUNIQ
Contract |  | CONTRACT
Customer / Contract |  | CUSTOMER, CONTRACT

## Fields: 118

Field | Type | Title | Presentation
--- | --- | --- | ---
CTUNIQ | BCD*10.0 | Contract Uniq |
AUDTDATE | Date |  |
AUDTTIME | Time |  |
AUDTUSER | String*8 |  |
AUDTORG | String*6 |  |
CONTRACT | String*16 | Contract | Mask: %-16C
DESC | String*60 | Description |
DATELASTMN | Date | Last Maintained |
CONTBRKID | String*6 | Structure Code | Mask: %-6N
FMTCONTNO | String*16 | Contract | Mask: %-16C
CUSTOMER | String*12 | Customer Number | Mask: %-12C
MANAGER | String*16 | Contract Manager | Mask: %-16N
PONUMBER | String*22 | P/O Number | Mask: %-22C
CONTACT | String*60 | Contact |
PHONE | String*30 | Telephone | Mask: (%-3C) %-3C-%-24C
FAX | String*30 | Fax | Mask: (%-3C) %-3C-%-24C
STARTDATE | Date | Start Date |
ORJENDDATE | Date | Original End Date |
CURENDDATE | Date | Projected End Date |
CLOSEDDATE | Date | Closed Date |
COMMENT | String*250 | Comment |
USERR | Boolean | Use Contract Revenue Recognition |
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
USEOVERH | Boolean | Use the Contract Overhead Inform |
OVERHEAD | Integer | Overhead Type | List: 3 entries
1 | = | None
2 | = | Flat Rate Per Unit
5 | = | Percentage of Cost
OHEADRATE | BCD*10.6 | Overhead Rate |
HEADPER | BCD*5.5 | Overhead Percentage |
USELABOR | Boolean | Use the Contract Labor Informati |
LABOR | Integer | Labor Type | List: 3 entries
1 | = | None
2 | = | Flat Rate Per Labor Hour/Unit
3 | = | Percentage of Labor Cost
LABORRATE | BCD*10.6 | Labor Rate |
LABORPER | BCD*5.5 | Labor Percentage |
STATUS | Integer | Contract Status | List: 7 entries
10 | = | Estimate
20 | = | Approved
30 | = | Open
40 | = | On Hold
70 | = | Inactive
60 | = | Completed
50 | = | Closed
USECOSTP | Boolean | Use the Contract Cost Plus Perce |
COSTPLUSP | BCD*5.5 | Cost Plus Percentage |
USEPTYPE | Integer | Project Type |
PROJTYPE | Integer | Project Type | List: 3 entries
1 | = | Time and Materials
2 | = | Fixed Price
3 | = | Cost Plus
CHANGEORD | Integer | Number of Change Orders to the ^ |
NXTCHGORD | Long | Next Change Order Number |
IDACCTSET | String*6 | Account Set | Mask: %-6N
TEMPLAT | String*16 | Template | Mask: %-16C
USEBILL | Boolean | Use the Contract Billing Type |
BILLTYPE | Integer | Billing Type | List: 3 entries
2 | = | Billable
3 | = | No Charge
1 | = | Non-billable
SCHCODE | String*12 | Schedule | Mask: %-12N
USERETAIN | Boolean | Use the Contract Retainage Infor |
PERRETREC | BCD*5.5 | A/R Retainage Percentage |
RETRECD | Integer | A/R Retention Period |
PERRETPAID | BCD*5.5 | Reserved |
RETPAIDD | Integer | Reserved |
SEGMENT1 | String*16 | Segment 1 |
SEGMENT2 | String*16 | Segment 2 |
SEGMENT3 | String*16 | Segment 3 |
SEGMENT4 | String*16 | Segment 4 |
SEGMENT5 | String*16 | Segment 5 |
CONSOLINV | Boolean | Consolidate Projects onto the On |
FORMCODE | String*6 | Form Code | Mask: %-6N
NEXTNUM | Long | Next Detail Number |
NUMDETAILS | Long | Number of Details |
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
CUSTCCY | String*3 | Customer Currency | Mask: %-3N
CONTSTYLE | Integer | Contract Style | List: 2 entries
1 | = | Standard
2 | = | Basic
ORJTIMECSR | BCD*10.3 | Number of non percent projects |
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 Amount Billed |
ACTMATEBHM | BCD*10.3 | Actual Material Amount 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 |

This page was generated on 2006-Sep-07

Copyright © 2001–2005 Sage Accpac International, Inc.