Table: Options

Table: OEOPT
View: OE0480
Record length: 582
Flags: A R 

Keys: 1


Title  Flags  Fields

Dummy   DUMMY

Fields: 81


Field  Type  Title  Presentation 

DUMMY  Integer  Dummy Key   
AUDTDATE  Date     
AUDTTIME  Time     
AUDTUSER  String*8     
AUDTORG  String*6     
PHONE  String*30  Phone  Mask: (%-3C) %-3C-%-24C
FAX  String*30  Fax  Mask: (%-3C) %-3C-%-24C
CONTACT  String*60  Contact Name   
DAYEND  Boolean  Day End Pending   
DIRECT  Boolean  Direct Printing on Invoices   
ORDHIST  Boolean  Keep Order History   
COMMISSION  Boolean  Track Commissions   
COMMTYPE  Integer  Commission Type  List: 2 entries
1=Sales
2=Margin
BACKORD  Boolean  Calculate Backorder Quantities   
ALLOWSHIP  Boolean  Allow Qty Shipped on Orders   
STATACCUM  Boolean  Accumulate Statistics   
STATEDIT  Boolean  Allow Edit Statistics   
STATCLNDR  Integer  Accumulate Statistics By  List: 2 entries
1=Calendar Year
2=Fiscal Year
STATPRD  Integer  Statistics Period By  List: 10 entries
1=Weekly
2=Seven Days
3=Bi-weekly
4=Four Weeks
5=Monthly
6=Bi-monthly
7=Quarterly
8=Semi-annually
9=Annually
10=Fiscal Period
AGING1  Integer  Aging Period 1   
AGING2  Integer  Aging Period 2   
AGING3  Integer  Aging Period 3   
RATETYPE  String*2  Default Rate Type  Mask: %-2N
TRANHIST  Boolean  Accumulate Sales History   
TRANCLNDR  Integer  Accumulate Sales History By  List: 2 entries
1=Calendar Year
2=Fiscal Year
TRANPRD  Integer  Sales History Period By  List: 10 entries
1=Weekly
2=Seven Days
3=Bi-weekly
4=Four Weeks
5=Monthly
6=Bi-monthly
7=Quarterly
8=Semi-annually
9=Annually
10=Fiscal Period
DEFTEMP  String*6  Default Template Code  Mask: %-6N
OPT002ACTV  Boolean  Optional Field 2 Active   
OPT002NAME  String*10  Optional Field 2 Name   
OPT002TBL  String*8  Optional Field 2 Table  Mask: %-8N
OPT003ACTV  Boolean  Optional Field 3 Active   
OPT003NAME  String*10  Optional Field 3 Name   
OPT003TBL  String*8  Optional Field 3 Table  Mask: %-8N
OPT004ACTV  Boolean  Optional Field 4 Active   
OPT004NAME  String*10  Optional Field 4 Name   
OPT004TBL  String*8  Optional Field 4 Table  Mask: %-8N
OPT012ACTV  Boolean  Optional Field 12 Active   
OPT012NAME  String*10  Optional Field 12 Name   
OPT012TBL  String*8  Optional Field 12 Table  Mask: %-8N
OPT015ACTV  Boolean  Optional Field 15 Active   
OPT015NAME  String*10  Optional Field 15 Name   
OPT015TBL  String*8  Optional Field 15 Table  Mask: %-8N
OPT030ACTV  Boolean  Optional Field 30 Active   
OPT030NAME  String*10  Optional Field 30 Name   
OPT030TBL  String*8  Optional Field 30 Table   
OPTDATACTV  Boolean  Optional Date Field Active   
OPTDATNAME  String*10  Optional Date Field Name   
OPTAMTACTV  Boolean  Optional Amount Field Active   
OPTAMTNAME  String*10  Optional Amount Field Name   
ORDNUMBERL  Integer  Order Number Length   
ORDPREFIXD  String*6  Order Number Prefix  Mask: %-6C
ORDBODYD  String*22  Next Order Number  Mask: %19D
NEXTOUNIQ  BCD*10.0  Next Order Uniquifier Key   
INVNUMBERL  Integer  Invoice Number Length   
INVPREFIXD  String*6  Invoice Number Prefix  Mask: %-6C
INVBODYD  String*22  Next Invoice Number  Mask: %20D
CRDNUMBERL  Integer  Credit Note Number Length   
CRDPREFIXD  String*6  Credit Note Number Prefix  Mask: %-6C
CRDBODYD  String*22  Next Credit Note Number  Mask: %20D
NEXTCUNIQ  BCD*10.0  Next Credit Note Uniquifier Key   
BROWSENUM  BCD*10.0  Day End Browse Number   
QUONUMBERL  Integer  Quote Number Length   
QUOPREFIXD  String*6  Quote Number Prefix  Mask: %-6C
QUOBODYD  String*22  Next Quote Number  Mask: %20D
UOMBY  Integer  Default Order UOM  List: 2 entries
1=Stocking Unit
2=Pricing Unit
NONCUST  Boolean  Allow post to non-exist customer   
QUOEXPIRE  Integer  Default quote expiring days   
DBNNUMBERL  Integer  Debit Note Number Length   
DBNPREFIXD  String*6  Debit Note Number Prefix  Mask: %-6C
DBNBODYD  String*22  Next Debit Note Number  Mask: %20D
NEXTIUNIQ  BCD*10.0  Next Invoice Uniquifier Key   
SHINUMBERL  Integer  Shipment Number Length   
SHIPREFIXD  String*6  Shipment Number Prefix  Mask: %-6C
SHIBODYD  String*22  Next Shipment Number  Mask: %20D
NEXTSUNIQ  BCD*10.0  Next Shipment Uniquifier Key   
DEFERGLPST  Boolean  Deferred G/L Posting   
GLDAYEND  Long  G/L Trans Created Thru Day End   
APPENDGL  Boolean  Append To G/L Batch   
CONSOLGL  Integer  Consolidate G/L Batch  List: 3 entries
1=Do Not Consolidate
2=Consolidate by Account and Fiscal Period
3=Consolidate by Account, Fiscal Period, and Source
REFCHOICE  Integer  G/L Reference Field  List: 6 entries
1=Document Number
2=Reference Number
3=Source Code/Day End Number/Entry Number
4=Header Description
5=Customer/Vendor Number
6=Customer/Vendor Name
DESCCHOICE  Integer  G/L Description Field  List: 6 entries
1=Document Number
2=Reference Number
3=Source Code/Day End Number/Entry Number
4=Header Description
5=Customer/Vendor Number
6=Customer/Vendor Name

This page was generated on 2003-Sep-18

Copyright © 2003 ACCPAC International, Inc. All rights reserved.