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.