Table: Options

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

Keys: 1

Title  Flags  Fields

Dummy  DUMMY

Fields: 74

Field  Type  Title  Presentation 

DUMMY  Integer  Dummy Key   
AUDTDATE  Date     
AUDTTIME  Time     
AUDTUSER  String*8     
AUDTORG  String*6     
PHONE  String*30  Phone  Mask: %-30c
FAX  String*30  Fax  Mask: %-30c
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
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  Integer  Append To 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 Batch  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
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
DEFQCOMMIT  Boolean  Default Qty. Ordered to Committed?   
CREATEINV  Boolean  Create Invoice When Qty. Shipped?  List: 2 entries
0=No
1=Yes
INCREDITED  Integer  Apply CN to invoice that was credited.  List: 3 entries
0=Ignore
1=Warning
2=Error
INCARPEND  Boolean  Include Pending A/R Transactions in Credit Limit Check   
INCOEPEND  Boolean  Include Pending O/E Transactions in Credit Limit Check   
INCXXPEND  Boolean  Include Other Pending Transactions in Credit Limit Check   
TAXREPCALC  Integer  Tax Reporting Calculation Method   
WUOMBY  Integer  Default Order Weight UOM  List: 2 entries
1=Item Weight Unit
2=Pricing Weight Unit
DEFERARPST  Integer  Deferred A/R Posting.  List: 2 entries
0=During Day End Processing
1=On Request Using Create Batch Icon
SRCTYPESH  String*2  O/E Shipments  Mask: %-2N
SRCTYPEIN  String*2  O/E Invoices  Mask: %-2N
SRCTYPECN  String*2  O/E Credit Notes  Mask: %-2N
SRCTYPEDN  String*2  O/E Debit Notes  Mask: %-2N
SRCTYPECO  String*2  O/E Consolidated Entry  Mask: %-2N
DATEBUSDFT  Integer  Default Posting Date  List: 2 entries
1=Document Date
2=Session Date

This page was generated on 2009-Nov-19

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