View: O/E Options

RotoID: OE0480
Table: OEOPT
Protocol: Flat
DLL:OEOPT

Keys: 1

Title Fields
Dummy DUMMY

Fields: 99

Field Index Type Title Attributes Presentation
DUMMY 1 Integer Dummy Key E A K R 
PHONE 2 String*30 Phone E A  Mask: (%-3C) %-3C-%-24C
FAX 3 String*30 Fax E A  Mask: (%-3C) %-3C-%-24C
CONTACT 4 String*60 Contact Name E A 
DAYEND 5 Boolean Day End Pending E A 
DIRECT 6 Boolean Direct Printing on Invoices E A 
ORDHIST 7 Boolean Keep Order History E A 
COMMISSION 8 Boolean Track Commissions E A 
COMMTYPE 9 Integer Commission Type E A  List:2 entries
1 = Sales
2 = Margin
BACKORD 10 Boolean Calculate Backorder Quantities E A 
ALLOWSHIP 11 Boolean Allow Qty Shipped on Orders E A 
STATACCUM 12 Boolean Accumulate Statistics E A 
STATEDIT 13 Boolean Allow Edit Statistics E A 
STATCLNDR 14 Integer Accumulate Statistics By E A P  List:2 entries
1 = Calendar Year
2 = Fiscal Year
STATPRD 15 Integer Statistics Period By E A P  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 16 Integer Aging Period 1 E A 
AGING2 17 Integer Aging Period 2 E A 
AGING3 18 Integer Aging Period 3 E A 
RATETYPE 19 String*2 Default Rate Type E A  Mask: %-2N
TRANHIST 20 Boolean Accumulate Sales History E A 
TRANCLNDR 21 Integer Accumulate Sales History By E A P  List:2 entries
1 = Calendar Year
2 = Fiscal Year
TRANPRD 22 Integer Sales History Period By E A P  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 23 String*6 Default Template Code E A  Mask: %-6N
ORDNUMBERL 46 Integer Order Number Length E A 
ORDPREFIXD 47 String*6 Order Number Prefix E A  Mask: %-6C
ORDBODYD 48 String*22 Next Order Number E A  Mask: %19D
NEXTOUNIQ 49 BCD*10.0 Next Order Uniquifier Key E A 
INVNUMBERL 50 Integer Invoice Number Length E A 
INVPREFIXD 51 String*6 Invoice Number Prefix E A  Mask: %-6C
INVBODYD 52 String*22 Next Invoice Number E A  Mask: %20D
CRDNUMBERL 53 Integer Credit Note Number Length E A 
CRDPREFIXD 54 String*6 Credit Note Number Prefix E A  Mask: %-6C
CRDBODYD 55 String*22 Next Credit Note Number E A  Mask: %20D
NEXTCUNIQ 56 BCD*10.0 Next Credit Note Uniquifier Key E A 
BROWSENUM 57 BCD*10.0 Day End Browse Number E A 
QUONUMBERL 58 Integer Quote Number Length E A 
QUOPREFIXD 59 String*6 Quote Number Prefix E A  Mask: %-6C
QUOBODYD 60 String*22 Next Quote Number E A  Mask: %20D
UOMBY 61 Integer Default Order UOM E A  List:2 entries
1 = Stocking Unit
2 = Pricing Unit
NONCUST 62 Boolean Allow post to non-exist customer E A 
QUOEXPIRE 63 Integer Default quote expiring days E A 
DBNNUMBERL 64 Integer Debit Note Number Length E A 
DBNPREFIXD 65 String*6 Debit Note Number Prefix E A  Mask: %-6C
DBNBODYD 66 String*22 Next Debit Note Number E A  Mask: %20D
NEXTIUNIQ 67 BCD*10.0 Next Invoice Uniquifier Key E A 
SHINUMBERL 68 Integer Shipment Number Length E A 
SHIPREFIXD 69 String*6 Shipment Number Prefix E A  Mask: %-6C
SHIBODYD 70 String*22 Next Shipment Number E A  Mask: %20D
NEXTSUNIQ 71 BCD*10.0 Next Shipment Uniquifier Key E A 
DEFERGLPST 72 Boolean Deferred G/L Posting E A 
GLDAYEND 73 Long G/L Trans Created Thru Day End E A 
APPENDGL 74 Integer Append To 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 75 Integer Consolidate G/L Batch 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
REFCHOICE 76 Integer G/L Reference Field E A  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 77 Integer G/L Description Field E A  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 78 Boolean Default Qty. Ordered to Committed? E A 
CREATEINV 79 Boolean Create Invoice When Qty. Shipped? E A  List:2 entries
0 = No
1 = Yes
INCREDITED 80 Integer Apply CN to invoice that was credited. E A  List:3 entries
0 = Ignore
1 = Warning
2 = Error
INCARPEND 81 Boolean Include Pending A/R Transactions in Credit Limit Check E A 
INCOEPEND 82 Boolean Include Pending O/E Transactions in Credit Limit Check E A 
INCXXPEND 83 Boolean Include Other Pending Transactions in Credit Limit Check E A 
TAXREPCALC 84 Integer Tax Reporting Calculation Method E A 
WUOMBY 85 Integer Default Order Weight UOM E A  List:2 entries
1 = Item Weight Unit
2 = Pricing Weight Unit
DEFERARPST 86 Integer Deferred A/R Posting. E A P X  List:2 entries
0 = During Day End Processing
1 = On Request Using Create Batch Icon
SRCTYPESH 87 String*2 O/E Shipments E A  Mask: %-2N
SRCTYPEIN 88 String*2 O/E Invoices E A  Mask: %-2N
SRCTYPECN 89 String*2 O/E Credit Notes E A  Mask: %-2N
SRCTYPEDN 90 String*2 O/E Debit Notes E A  Mask: %-2N
SRCTYPECO 91 String*2 O/E Consolidated Entry E A  Mask: %-2N
DATEBUSDFT 92 Integer Default Posting Date E A  List:2 entries
1 = Document Date
2 = Session Date
PURGEEXPQT 93 Boolean Clear Expired Quotes E A  List:2 entries
0 = No
1 = Yes
QTPURGEDAY 94 Integer Clear Expired Quotes Days E A 
STATPRDTYP 101 Integer Statistical Period Type A C  List:3 entries
2 = Weekly
1 = Seven Days
3 = Monthly
STATPRDLNG 102 Integer Statistical Period Length A C 
STATPRDS 103 Integer Statistical Periods A C 
TRANPRDTYP 104 Integer Sales History Period Type A C  List:3 entries
2 = Weekly
1 = Seven Days
3 = Monthly
TRANPRDLNG 105 Integer Sales History Period Length A C 
TRANPRDS 106 Integer Sales History Periods A C 
ORDDEFAULT 107 String*22 Default Order Number A C 
ORDVALUE 108 String*22 Next Order Number A C 
INVDEFAULT 109 String*22 Default Invoice Number A C 
INVVALUE 110 String*22 Next Invoice Number A C 
CRDDEFAULT 111 String*22 Default Credit Note Number A C 
CRDVALUE 112 String*22 Next Credit Note Number A C 
QUODEFAULT 113 String*22 Default Quote Number A C 
QUOVALUE 114 String*22 Next Quote Number A C 
HOMECURR 115 String*3 Home Currency A C 
DRIVERID 116 Integer Database Driver ID A C 
DBNDEFAULT 117 String*22 Default Debit Note Number A C 
DBNVALUE 118 String*22 Next Debit Note Number A C 
SHIDEFAULT 119 String*22 Default Shipment Number A C 
SHIVALUE 120 String*22 Next Shipment Number A C 
DAYENDSEQ 121 Long Next Day End Posting Seq. A C 
ACTION 122 Integer Action E A 
SHFISCYR 123 String*4 Current Sales History Year A C  Mask: %-4d
SHFISCPER 124 Integer Current Sales History Period A C 
SSFISCYR 125 String*4 Current Sales Statistics Year A C  Mask: %-4d
SSFISCPER 126 Integer Current Sales Statistics Period A C 
SWCAPTURE 127 Integer Require Invoicing at Shipping A C  List:2 entries
0 = No
1 = Yes

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