# View: Options

RotoID: PM0003
Table: PMOPT
Protocol: Flat
DLL: PMOPT

## Compositions: 2

RotoID | Tables | Title | DLL
--- | --- | --- | ---
PM0019 | PMOPT2 | Options | PMOPT2
PM0020 | PMOPT3 | Options | PMOPT3

## Keys: 1

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

## Fields: 119

Field | Index | Type | Title | Attributes | Presentation
--- | --- | --- | --- | --- | ---
IDOPT01 | 1 | Integer | Dummy | E A K R |
CONTACT | 2 | String*60 | Contact Name | E A |
PHONE | 3 | String*30 | Telephone | E A P | Mask: %-30c
FAX | 4 | String*30 | Fax Number | E A P | Mask: %-30c
DATELASTMN | 5 | Date | Last Maintained | A C |
MULTICURR | 6 | Boolean | Multicurrency | E A |
HOMECURR | 7 | String*3 | Home Currency | E A | Mask: %-3N
DEFOVERHD | 8 | Integer | Default Overhead Type | E A | List: 3 entries
1 | = | None
2 | = | Flat Rate Per Unit
5 | = | Percentage of Cost
OHEADRATE | 9 | BCD*10.6 | Overhead Rate | E A |
HEADPER | 10 | BCD*5.5 | Overhead Percentage | E A |
DEFLABOR | 11 | Integer | Default Labor Type | E A | List: 3 entries
1 | = | None
2 | = | Flat Rate Per Labor Hour/Unit
3 | = | Percentage of Labor Cost
LABORRATE | 12 | BCD*10.6 | Labor Rate | E A |
LABORPER | 13 | BCD*5.5 | Labor Percentage | E A |
SWEDITIMPT | 14 | Boolean | Edit Imported Batches | E A |
SWFRCLST | 15 | Boolean | Force Listing of Transactions | E A |
DEFREVREC | 16 | Integer | Default Accounting Method | E A | 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 | 17 | Integer | Payroll | E A | List: 3 entries
3 | = | None
1 | = | US Payroll
2 | = | Canadian Payroll
DEFERGLPST | 18 | Boolean | Create G/L Transactions | E A | List: 2 entries
1 | = | During Posting
0 | = | On Request Using Create G/L Batch Icon
APPENDGL | 19 | Integer | Append G/L Batch | E A | List: 3 entries
1 | = | Adding to an Existing Batch
0 | = | Creating a New Batch
2 | = | Creating and Posting a New Batch
CONSOLGL | 20 | Integer | Consolidate G/L Batches | E A | 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 | 21 | Integer | G/L Reference Field - Not Used | E A | 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 | 22 | Integer | G/L Description Field - Not Used | E A | 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 | 23 | Long | Charges | A |
NXTEQIPSEQ | 24 | Long | Equipment Usage | A |
NXTCHNGSEQ | 25 | Long | Revise Estimates | A |
NXTCARDSEQ | 26 | Long | Timecards | A |
NXTSTKASEQ | 27 | Long | Reserved | A |
NXTSTKRSEQ | 28 | Long | Reserved | A |
NXTRRSEQ | 29 | Long | Revenue Recognition | A |
NXTADJSEQ | 30 | Long | Adjustments | A |
COSTBTCH | 31 | BCD*5.0 | Cost | A |
INVBTCH | 32 | BCD*5.0 | Invoice | A |
TCARDBTCH | 33 | BCD*5.0 | Timecard | A |
STKABTCH | 34 | BCD*5.0 | Material Usage | A |
STKRBTCH | 35 | BCD*5.0 | Material Return | A |
PMSC | 36 | String*2 | Project and Job Costing | E A | Mask: %-2N
STKALLSC | 37 | String*2 | Material Usage | E A | Mask: %-2N
STKRETSC | 38 | String*2 | Material Returns | E A | Mask: %-2N
TIMECARDSC | 39 | String*2 | Timecards | E A | Mask: %-2N
RRSC | 40 | String*2 | Revenue Recognition | E A | Mask: %-2N
EQUIPSC | 41 | String*2 | Equipment Usage | E A | Mask: %-2N
CHRGSC | 42 | String*2 | Charges | E A | Mask: %-2N
ADJSC | 43 | String*2 | Adjustments | E A | Mask: %-2N
RETAR | 44 | BCD*5.5 | Default A/R Retainage Percentage | E A |
RETDAYSAR | 45 | Integer | Default A/R Retainage No of Days | E A |
RETAP | 46 | BCD*5.5 | Default A/P Retainage Percentage | E A |
RETDAYSAP | 47 | Integer | Default A/P Retainage No of Days | E A |
DATELASTRR | 48 | Date | Date Last Revenue Recognition | A |
TIMELASTRR | 49 | Time | Time Last Revenue Recognition | A |
DATELASTBB | 50 | Date | Date Last Billing Worksheet | A |
DATELASTAL | 51 | Date | Date Last Material Usage | A |
DATELASTRE | 52 | Date | Date Last Material Return | A |
DATELASTTC | 53 | Date | Date Last Timecard | A |
DATELASTCS | 54 | Date | Date Last Cost Batch Posted | A |
DATELASTIN | 55 | Date | Date Last Invoice Batch Posted | A |
DATELASTCH | 56 | Date | Date Last Charges Posted | A |
DATELASTEU | 57 | Date | Date Last Equipment Usage | A |
DATELASTES | 58 | Date | Date Last Revised Estimates Posted | A |
ARGLEDIT | 59 | Boolean | Allow Edit of G/L Codes in A/R | E A |
APGLEDIT | 60 | Boolean | Allow Edit of G/L Codes in A/P | E A |
AGINPERD1 | 61 | BCD*3.0 | Aging Period 1 | E A |
AGINPERD2 | 62 | BCD*3.0 | Aging Period 2 | E A |
AGINPERD3 | 63 | BCD*3.0 | Aging Period 3 | E A |
LEVEL1NAME | 64 | String*30 | Level 1 Name | E A |
LEVEL2NAME | 65 | String*30 | Level 2 Name | E A |
LEVEL3NAME | 66 | String*30 | Level 3 Name | E A |
DEFSTRUCT | 67 | String*6 | Default Contract Structure | E A | Mask: %-6N
HYPEN | 68 | Boolean | Use Hypen | E A |
FWDSLASH | 69 | Boolean | Use Forward Slash | E A |
BCKSLASH | 70 | Boolean | Use Back Slash | E A |
ASTERISK | 71 | Boolean | Use Asterisk | E A |
PERIOD | 72 | Boolean | Use Period | E A |
LFTPARENS | 73 | Boolean | Use Left Parenthesis | E A |
RGTPARENS | 74 | Boolean | Use Right Parenthesis | E A |
POUNDSGN | 75 | Boolean | Use Pound Sign | E A |
TEXTTCPF | 76 | String*6 | Time Card Prefix | E A | Mask: %-6N
CNTTCPFLEN | 77 | BCD*2.0 | Timecard Number Length | E A |
CNTTCSEQ | 78 | String*16 | Next Timecard Number | E A | Mask: %-16D
TEXTSAPF | 79 | String*6 | Material Usage Prefix | E A | Mask: %-6N
CNTSAPFLEN | 80 | BCD*2.0 | Material Usage Number Length | E A |
CNTSASEQ | 81 | String*16 | Next Material Usage Number | E A | Mask: %-16D
TEXTSRPF | 82 | String*6 | Material Return Prefix | E A | Mask: %-6N
CNTSRPFLEN | 83 | BCD*2.0 | Material Return Number Length | E A |
CNTSRSEQ | 84 | String*16 | Next Material Returns Number | E A | Mask: %-16D
TEXTEQPF | 85 | String*6 | Equipment Usage Prefix | E A | Mask: %-6N
CNTEQPFLEN | 86 | BCD*2.0 | Equipment Usage Number Length | E A |
CNTEQSEQ | 87 | String*16 | Next Equipment Usage Number | E A | Mask: %-16D
TEXTCOPF | 88 | String*6 | Revised Estimate Prefix | E A | Mask: %-6N
CNTCOPFLEN | 89 | BCD*2.0 | Revised Estimate Number Length | E A |
CNTCOSEQ | 90 | String*16 | Next Revised Estimate Number | E A | Mask: %-16D
TEXTCHRGPF | 91 | String*6 | Charge Prefix | E A | Mask: %-6N
TEXTADJPF | 92 | String*6 | Adjustments | E A | Mask: %-6N
CNTADJLEN | 93 | BCD*2.0 | Adjustment Number Length | E A |
CNTADJSEQ | 94 | String*16 | Next Adjustment Number | E A | Mask: %-16D
CNTCHRGLEN | 95 | BCD*2.0 | Charge Number Length | E A |
CNTCHRGSEQ | 96 | String*16 | Next Charge Number | E A | Mask: %-16D
NEXTCTUNIQ | 97 | BCD*10.0 | Next Contract Unique | E A |
CNTBBSEQ | 98 | String*16 | A/R Billing | E A | Mask: %-16D
CNTRRSEQ | 99 | String*16 | Revenue Recognition | E A | Mask: %-16D
TEXTBBPF | 100 | String*6 | A/R Billing Prefix | E A | Mask: %-6N
TEXTRRPF | 101 | String*6 | Revenue Recognition Prefix | E A | Mask: %-6N
CNTBBLEN | 102 | BCD*2.0 | A/R Billing Length | E A |
CNTRRLEN | 103 | BCD*2.0 | Revenue Recognition Length | E A |
PROJTYPE | 104 | Boolean | Allow Edit of Project Type | E A |
ARITEM | 105 | String*16 | Default A/R Item Number | E A | Mask: %-16C
ARUOM | 106 | String*10 | Default A/R Unit of Measure | E A | Mask: %-10C
PAYROLLTC | 107 | String*6 | Payroll | E A |
GLEQIPSEQ | 109 | BCD*10.0 | Equipment Usage | E A |
GLCARDSEQ | 111 | BCD*10.0 | Timecards | E A |
GLRRSEQ | 114 | BCD*10.0 | Revenue Recognition | E A |
GLADJSEQ | 115 | BCD*10.0 | Adjustments | E A |
LEVEL4NAME | 116 | String*30 | Level 1 Name - Plural | E A |
LEVEL5NAME | 117 | String*30 | Level 2 Name - Plural | E A |
LEVEL6NAME | 118 | String*30 | Level 3 Name - Plural | E A |
CESC | 119 | String*2 | Costs | E A | Mask: %-2N
ROSC | 120 | String*2 | Reopen Projects | E A | Mask: %-2N
DRIVERID | 1000 | Integer | Description ed | A C |
FRACTQTY | 1001 | Integer | # decimals for material quantityed | A C |
FUNCTION | 1002 | Integer | Function ed | E A C |

This page was generated on 2009-Nov-19

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