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