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: (%-3C) %-3C-%-24C
FAX 4 String*30 Fax Number E A P  Mask: (%-3C) %-3C-%-24C
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 2023-Aug-31

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