Table: ^4

Table: PMCONTS
View: PM0021
Record Length: 1370

Flags: A R 

Keys: 4

Title Flags Fields
Contract Uniquifier CTUNIQ
Unformatted Contract CONTRACT
Customer / Contract M  CUSTOMER, CONTRACT
Contract FMTCONTNO

Fields: 118

Field Type Title Presentation
CTUNIQ BCD*10.0 ^1 Uniq
AUDTDATE Date
AUDTTIME Time
AUDTUSER String*8
AUDTORG String*6
CONTRACT String*16 Unformatted ^1 Mask: %-16C
DESC String*60 Description
DATELASTMN Date Last Maintained
CONTBRKID String*6 Structure Code Mask: %-6N
FMTCONTNO String*16 ^1 Mask: %-16C
CUSTOMER String*12 Customer Number Mask: %-12C
MANAGER String*16 ^1 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 ^1 Revenue Recognition Information
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 ^1 Overhead Information
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 ^1 Labor Information
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 ^1 Status List:7 entries
10 = Estimate
20 = Approved
30 = Open
40 = On Hold
70 = Inactive
60 = Completed
50 = Closed
USECOSTP Boolean Use the ^1 Cost Plus Percentage
COSTPLUSP BCD*5.5 Cost Plus Percentage
USEPTYPE Integer ^2 Type
PROJTYPE Integer ^2 Type List:3 entries
1 = Time and Materials
2 = Fixed Price
3 = Cost Plus
CHANGEORD Integer Number of Change Orders to the ^1
NXTCHGORD Long Next Change Order Number
IDACCTSET String*6 Account Set Mask: %-6N
TEMPLAT String*16 Template Mask: %-16C
USEBILL Boolean Use the ^1 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 ^1 Retainage Information
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 ^5 onto the One Invoice
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 ^1 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 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 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 2022-Aug-18

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