# Table: Options

Table: PMOPT
View: PM0003
Record length: 869
Flags: A R

## Keys: 1

Title | Flags | Fields
--- | --- | ---
Dummy |  | IDOPT01

## Fields: 120

Field | Type | Title | Presentation
--- | --- | --- | ---
IDOPT01 | Integer | Dummy |
AUDTDATE | Date |  |
AUDTTIME | Time |  |
AUDTUSER | String*8 |  |
AUDTORG | String*6 |  |
CONTACT | String*60 | Contact Name |
PHONE | String*30 | Telephone | Mask: (%-3C) %-3C-%-24C
FAX | String*30 | Fax Number | Mask: (%-3C) %-3C-%-24C
DATELASTMN | Date | Last Maintained |
MULTICURR | Boolean | Multicurrency |
HOMECURR | String*3 | Home Currency | Mask: %-3N
DEFOVERHD | Integer | Default 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 |
DEFLABOR | Integer | Default 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 |
SWEDITIMPT | Boolean | Edit Imported Batches |
SWFRCLST | Boolean | Force Listing of Transactions |
DEFREVREC | Integer | Default 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
PAYROLL | Integer | Payroll | List: 3 entries
3 | = | None
1 | = | US Payroll
2 | = | Canadian Payroll
DEFERGLPST | Boolean | Create G/L Transactions | List: 2 entries
1 | = | During Posting
0 | = | On Request Using Create G/L Batch Icon
APPENDGL | Integer | Append G/L Batch | List: 3 entries
1 | = | Adding to an Existing Batch
0 | = | Creating a New Batch
2 | = | Creating and Posting a New Batch
CONSOLGL | Integer | Consolidate G/L Batches | List: 4 entries
1 | = | Do Not Consolidate
9 | = | Consolidate Transaction Details by Account
2 | = | Consolidate by Account and Fiscal Period
3 | = | Consolidate by Account, Fiscal Period, and Source
CODEGLREF | Integer | G/L Reference Field - Not Used | List: 12 entries
1 | = | Customer Number
2 | = | Customer Name
3 | = | Document Number
4 | = | Contract Number
5 | = | Project
6 | = | Category
7 | = | Contract-Project-Category
8 | = | Type-Posting Seq.-Document Number
9 | = | Resource
10 | = | Purchase Order Number
11 | = | Description
12 | = | Reference
CODEGLDESC | Integer | G/L Description Field - Not Used | List: 12 entries
1 | = | Customer Number
2 | = | Customer Name
3 | = | Document Number
4 | = | Contract Number
5 | = | Project
6 | = | Category
7 | = | Contract-Project-Category
8 | = | Type-Posting Seq.-Document Number
9 | = | Resource
10 | = | Purchase Order Number
11 | = | Description
12 | = | Reference
NXTCHRGSEQ | Long | Charges |
NXTEQIPSEQ | Long | Equipment Usage |
NXTCHNGSEQ | Long | Revise Estimates |
NXTCARDSEQ | Long | Timecards |
NXTSTKASEQ | Long | Reserved |
NXTSTKRSEQ | Long | Reserved |
NXTRRSEQ | Long | Revenue Recognition |
NXTADJSEQ | Long | Adjustments |
COSTBTCH | BCD*5.0 | Cost |
INVBTCH | BCD*5.0 | Invoice |
TCARDBTCH | BCD*5.0 | Timecard |
STKABTCH | BCD*5.0 | Material Usage |
STKRBTCH | BCD*5.0 | Material Return |
PMSC | String*2 | Project and Job Costing | Mask: %-2N
STKALLSC | String*2 | Material Usage | Mask: %-2N
STKRETSC | String*2 | Material Returns | Mask: %-2N
TIMECARDSC | String*2 | Timecards | Mask: %-2N
RRSC | String*2 | Revenue Recognition | Mask: %-2N
EQUIPSC | String*2 | Equipment Usage | Mask: %-2N
CHRGSC | String*2 | Charges | Mask: %-2N
ADJSC | String*2 | Adjustments | Mask: %-2N
RETAR | BCD*5.5 | Default A/R Retainage Percentage |
RETDAYSAR | Integer | Default A/R Retainage No of Days |
RETAP | BCD*5.5 | Default A/P Retainage Percentage |
RETDAYSAP | Integer | Default A/P Retainage No of Days |
DATELASTRR | Date | Date Last Revenue Recognition |
TIMELASTRR | Time | Time Last Revenue Recognition |
DATELASTBB | Date | Date Last Billing Worksheet |
DATELASTAL | Date | Date Last Material Usage |
DATELASTRE | Date | Date Last Material Return |
DATELASTTC | Date | Date Last Timecard |
DATELASTCS | Date | Date Last Cost Batch Posted |
DATELASTIN | Date | Date Last Invoice Batch Posted |
DATELASTCH | Date | Date Last Charges Posted |
DATELASTEU | Date | Date Last Equipment Usage |
DATELASTES | Date | Date Last Revised Estimates Posted |
ARGLEDIT | Boolean | Allow Edit of G/L Codes in A/R |
APGLEDIT | Boolean | Allow Edit of G/L Codes in A/P |
AGINPERD1 | BCD*3.0 | Aging Period 1 |
AGINPERD2 | BCD*3.0 | Aging Period 2 |
AGINPERD3 | BCD*3.0 | Aging Period 3 |
LEVEL1NAME | String*30 | Level 1 Name |
LEVEL2NAME | String*30 | Level 2 Name |
LEVEL3NAME | String*30 | Level 3 Name |
DEFSTRUCT | String*6 | Default Contract Structure | Mask: %-6N
HYPEN | Boolean | Use Hypen |
FWDSLASH | Boolean | Use Forward Slash |
BCKSLASH | Boolean | Use Back Slash |
ASTERISK | Boolean | Use Asterisk |
PERIOD | Boolean | Use Period |
LFTPARENS | Boolean | Use Left Parenthesis |
RGTPARENS | Boolean | Use Right Parenthesis |
POUNDSGN | Boolean | Use Pound Sign |
TEXTTCPF | String*6 | Time Card Prefix | Mask: %-6N
CNTTCPFLEN | BCD*2.0 | Timecard Number Length |
CNTTCSEQ | String*16 | Next Timecard Number | Mask: %-16D
TEXTSAPF | String*6 | Material Usage Prefix | Mask: %-6N
CNTSAPFLEN | BCD*2.0 | Material Usage Number Length |
CNTSASEQ | String*16 | Next Material Usage Number | Mask: %-16D
TEXTSRPF | String*6 | Material Return Prefix | Mask: %-6N
CNTSRPFLEN | BCD*2.0 | Material Return Number Length |
CNTSRSEQ | String*16 | Next Material Returns Number | Mask: %-16D
TEXTEQPF | String*6 | Equipment Usage Prefix | Mask: %-6N
CNTEQPFLEN | BCD*2.0 | Equipment Usage Number Length |
CNTEQSEQ | String*16 | Next Equipment Usage Number | Mask: %-16D
TEXTCOPF | String*6 | Revised Estimate Prefix | Mask: %-6N
CNTCOPFLEN | BCD*2.0 | Revised Estimate Number Length |
CNTCOSEQ | String*16 | Next Revised Estimate Number | Mask: %-16D
TEXTCHRGPF | String*6 | Charge Prefix | Mask: %-6N
TEXTADJPF | String*6 | Adjustments | Mask: %-6N
CNTADJLEN | BCD*2.0 | Adjustment Number Length |
CNTADJSEQ | String*16 | Next Adjustment Number | Mask: %-16D
CNTCHRGLEN | BCD*2.0 | Charge Number Length |
CNTCHRGSEQ | String*16 | Next Charge Number | Mask: %-16D
NEXTCTUNIQ | BCD*10.0 | Next Contract Unique |
CNTBBSEQ | String*16 | A/R Billing | Mask: %-16D
CNTRRSEQ | String*16 | Revenue Recognition | Mask: %-16D
TEXTBBPF | String*6 | A/R Billing Prefix | Mask: %-6N
TEXTRRPF | String*6 | Revenue Recognition Prefix | Mask: %-6N
CNTBBLEN | BCD*2.0 | A/R Billing Length |
CNTRRLEN | BCD*2.0 | Revenue Recognition Length |
PROJTYPE | Boolean | Allow Edit of Project Type |
ARITEM | String*16 | Default A/R Item Number | Mask: %-16C
ARUOM | String*10 | Default A/R Unit of Measure | Mask: %-10C
PAYROLLTC | String*6 | Payroll |
GLEQIPSEQ | BCD*10.0 | Equipment Usage |
GLCARDSEQ | BCD*10.0 | Timecards |
GLRRSEQ | BCD*10.0 | Revenue Recognition |
GLADJSEQ | BCD*10.0 | Adjustments |
LEVEL4NAME | String*30 | Level 1 Name - Plural |
LEVEL5NAME | String*30 | Level 2 Name - Plural |
LEVEL6NAME | String*30 | Level 3 Name - Plural |
CESC | String*2 | Costs | Mask: %-2N
ROSC | String*2 | Reopen Projects | Mask: %-2N

This page was generated on 2008-May-01

Copyright © 2001–2008 Sage Software, Inc. All rights reserved.