SO_Options SO Options Rel: 4.40 Bld: 398 8/28/2009
Bus Obj: N/A
SQL Def: N SysDB: N "MAS_"+%C$+"/SO"+%C$+"/SO_Options.M4T"
KPRIMARY: ModuleCode
Fld Column Name M/L TUR Description/Notes Class
1 ModuleCode. . . . . . . . . . 3 SNN Module Code . . . . . . . . . .MODULECODE
Notes: {SO0$(1,3)}
2 NewSystem . . . . . . . . . . 1 SYN New System. . . . . . . . . . .
Valid:Y,N,S Notes: {SO0$(7,
1)}, Y=Yes, N=No, S=Setup in
Progress
3 DefaultWarehouseCode. . . . . 3 SYY Default Warehouse Code. . . . .WAREHOUSE
DfltVal:000 FmtType:CHARNUM
Notes: {SO0$(22,3)}
4 UseAlternateWhse. . . . . . . 1 SYY Use Alternate Whse For Out-Of-SYESNO
DfltVal:N Valid:Y,N Notes:
{SO0$(25,1)}
5 UseDefaultItemWhse. . . . . . 1 SYY Use Default Item Warehouse. . .YESNO
DfltVal:N Valid:Y,N
6 SplitCommissions. . . . . . . 1 SYY Split Commsn Between SalespersoYESNO
DfltVal:N Valid:Y,N Notes:
{SO0$(98,1)}
7 UseShippingCode . . . . . . . 1 SYY Use Shipping To Calculate Freig
DfltVal:Y Valid:Y,N,A Notes:
Y=Yes, N=No, A=Actual
{SO0$(26,1)}
8 NextSalesOrderNo. . . . . . . 7 SYY Next Sales Order Number . . . .
DfltVal:0000001 FmtType:CHARN
UM Notes: {SO0$(8,7)}
9 NextInvoiceNo . . . . . . . . 7 SYN Next Invoice Number . . . . . .
DfltVal:0000001 FmtType:CHARN
UM Notes: {SO0$(15,7)}
10 CurrentCalendarYr . . . . . . 4 SNN Current SO Calendar Year. . . .YEAR
Mask:0000 FmtType:ZEROFILL
Notes: {SO0$(178,2)}
11 CurrentFiscalYr . . . . . . . 4 SNY Current SO Fiscal Year. . . . .YEAR
Mask:0000 Notes: {SO0$(58,2)}
12 CurrentPeriod . . . . . . . . 2 SNY Current SO Period . . . . . . .FISCALPERIOD
Mask:00 FmtType:ZEROFILL
Notes: {SO0$(176,1)}
13 AllowDiscountRate . . . . . . 1 SYY Allow Discount Rate By Detail LYESNO
DfltVal:N Valid:Y,N Notes:
{SO0$(78,1)}
14 CheckQtyOnHand. . . . . . . . 1 SYY Check For Quantity On Hand DuriYESNO
DfltVal:N Valid:Y,N Notes:
{SO0$(97,1)}
15 DefaultSpecialItemsToDS . . . 1 SYY Default Special Items To Drop SYESNO
DfltVal:Y Valid:Y,N Notes:
{SO0$(182,1)}
16 IncludeBackorderedLines . . . 1 SYY Include Backordered Lines on BaYESNO
DfltVal:Y Valid:Y,N Notes:
{SO0$(64,1)}
17 RequireJobNo. . . . . . . . . 1 SYY Require Job Number. . . . . . .YESNO
DfltVal:N Valid:Y,N
18 AllowJobsToBeCreated. . . . . 1 SYY Allow Jobs to be Created. . . .YESNO
DfltVal:N Valid:Y,N
19 RequireCostCode . . . . . . . 1 SYY Require Cost Code . . . . . . .YESNO
DfltVal:N Valid:Y,N
20 PostInvoiceCostsToJC. . . . . 1 SYY Post Invoice Costs To Job Cost.YESNO
DfltVal:N Valid:Y,N
21 PostSalesByDivision . . . . . 1 SYY Post Sales To G/L By Division .
DfltVal:N Valid:Y,N,W Notes:
Y=Yes, N=No, W=Warehouse
{SO0$(27,1)}
22 PostDepositsByDiv . . . . . . 1 SYY Post Customer Deposits By DivisYESNO
DfltVal:N Valid:Y,N Notes:
{SO0$(79,1)}
23 PostDepositsInDetail. . . . . 1 SYY Post Deposits In Detail . . . .YESNO
DfltVal:Y Valid:Y,N
24 PrintSalesOrders. . . . . . . 1 SYY Print Sales Orders. . . . . . .YESNO
DfltVal:Y Valid:Y,N Notes:
{SO0$(37,1)}
25 PrintPickingSheets. . . . . . 1 SYY Print Picking Sheets Sort Order
DfltVal:B Valid:B,I,L,N
Notes: B=Bin location,
I=Item number, L=Line number,
N=None {SO0$(38,1)}
26 IncludeKitItems . . . . . . . 1 SYY Include Kit Items On Picking ShYESNO
DfltVal:Y Valid:Y,N Notes:
{SO0$(183,1)}
27 PrintShippingLabels . . . . . 1 SYY Print Shipping Labels . . . . .YESNO
DfltVal:Y Valid:Y,N Notes:
{SO0$(39,1)}
28 PrintDailyDropShipRpt . . . . 1 SYY Print Daily Drop Ship Report. .YESNO
DfltVal:Y Valid:Y,N Notes:
{SO0$(42,1)}
29 PrintCODLabels. . . . . . . . 1 SYY Print C.O.D. Labels . . . . . .YESNO
DfltVal:N Valid:Y,N Notes:
{SO0$(65,1)}
30 CustomerDepAcctKey. . . . . . 9 SYN Customer Deposits Account Key .ACCOUNT
Notes: {SO0$(68,9)}
31 SpecialItemSalesAcctKey . . . 9 SYN Special Item Sales Account Key.ACCOUNT
Notes: {SO0$(28,9)}
32 SpecialItemCOGSAcctKey. . . . 9 SYN Special Item COGS Account Key .ACCOUNT
Notes: {SO0$(151,9)}
33 SpecialItemPurchasesAcctKey . 9 SYN Special Item Purchases Account ACCOUNT
Notes: {SO0$(160,9)}
34 PrintSalesJournalByDiv. . . . 1 SYY Print Sales Journal By DivisionYESNO
DfltVal:N Valid:Y,N Notes:
{SO0$(43,1)}
35 PrintGrossProfitJournal . . . 1 SYY Print Gross Profit Journal. . .YESNO
DfltVal:Y Valid:Y,N Notes:
{SO0$(44,1)}
36 PrintGrossPrftJrnlBySlsprson. 1 SYN Print Gross Profit Journal By SYESNO
DfltVal:N Valid:Y,N Notes:
{SO0$(45,1)}
37 PrintDailyBackorder . . . . . 1 SYY Print Daily Backorder Report. .YESNO
DfltVal:Y Valid:Y,N Notes:
{SO0$(46,1)}
38 PrintDailyDepositRecap. . . . 1 SYY Print Daily Deposit Recap ReporYESNO
DfltVal:N Valid:Y,N Notes:
{SO0$(60,1)}
39 PrintTaxDetailOnSalesJrnl . . 1 SYN Print Tax Detail On Sales JournYESNO
DfltVal:N Valid:Y,N Notes:
{SO0_9$(21,1)}
40 PrintTaxJournalInDetail . . . 1 SYY Print Tax Journal In Detail . .YESNO
DfltVal:N Valid:Y,N Notes:
{SO0_9$(22,1)}
41 PrintDailySalesRecap. . . . . 1 SYY Print Daily Sales Recap ReportsYESNO
DfltVal:N Valid:Y,N Notes:
{SO0$(47,1)}
42 PrintRecapByItem. . . . . . . 1 SYY Print Recap By Item . . . . . .YESNO
DfltVal:N Valid:Y,N Notes:
{SO0$(48,1)}
43 PrintWhseDetailForRecap . . . 1 SYY Print Whse Detail For Recap By-YESNO
DfltVal:N Valid:Y,N Notes:
{SO0$(49,1)}
44 PrintRecapByWhseByItem. . . . 1 SYY Print Recap By Whse By Item . .YESNO
DfltVal:N Valid:Y,N Notes:
{SO0$(50,1)}
45 PrintRecapByProductLine . . . 1 SYY Print Recap By Prod Line. . . .YESNO
DfltVal:N Valid:Y,N Notes:
{SO0$(51,1)}
46 PrintRecapByWhseByProdLine. . 1 SYY Print Recap By Whse By Product YESNO
DfltVal:N Valid:Y,N Notes:
{SO0$(52,1)}
47 PrintRecapByWhse. . . . . . . 1 SYY Print Recap By Whse . . . . . .YESNO
DfltVal:N Valid:Y,N Notes:
{SO0$(53,1)}
48 PrintRecapByCustomer. . . . . 1 SYY Print Recap By Customer . . . .YESNO
DfltVal:N Valid:Y,N Notes:
{SO0$(54,1)}
49 PrintRecapByDiv . . . . . . . 1 SYY Print Recap By Division . . . .YESNO
DfltVal:N Valid:Y,N Notes:
{SO0$(55,1)}
50 PrintBarCodeSalesOrders . . . 1 SYY Print Bar Code Sales Orders . .YESNO
DfltVal:N Valid:Y,N Notes:
{SO0$(197,1)}
51 PrintBarCodePickSheets. . . . 1 SYY Print Bar Code Picking Sheets .YESNO
DfltVal:N Valid:Y,N Notes:
{SO0$(198,1)}
52 PurgeSORecap. . . . . . . . . 1 SYY Purge S/O Recap at Period End .YESNO
DfltVal:Y Valid:Y,N Notes:
{SO0$(89,1)}
53 DisplayUnitCost . . . . . . . 1 SYY Display Unit Cost During Line EYESNO
DfltVal:Y Valid:Y,N Notes:
{SO0$(100,1)}
54 YearsToRetainSalesHist. . . . 2.0 NNY Years to Retain Sales History .
DfltVal:2 Mask:00
55 RetainBackorderedLines. . . . 1 SYY Retain Backordered Lines in InvYESNO
DfltVal:N Valid:Y,N Notes:
{SO0$(85,1)}
56 RetainShipToDetail. . . . . . 1 SYN Retain Ship-To Detail in CustomYESNO
DfltVal:N Valid:Y,N Notes:
{SO0$(200,1)}
57 RetainLotSerialHistory. . . . 1 SYY Retain Lot/Serial Sales History
DfltVal:N Valid:L,S,B,N
Notes: L=Lot items, S=Serial
items, B=Both lot and serial
items, N=None {SO0$(66,1)}
58 RetainCustLastPurchHistory. . 1 SYY Retain Customer Last Purchase H
DfltVal:N Valid:Y,N,I Notes:
Y=Yes, N=No, I=Invoices Only
{SO0$(196,1)}
59 RetainOrderQuoteHistory . . . 1 SYY Retain Sales Order/Quote HistorYESNO
DfltVal:Y Valid:Y,N Notes:
{SO0$(61,1)}
60 RetainDeletedSalesOrders. . . 1 SYY Retain Deleted Sales Order/Quot
DfltVal:Y Valid:Y,N,P Notes:
Y=Yes, N=No, P=Prompt
{SO0$(62,1)}
61 RetainDeletedLines. . . . . . 1 SYY Retain Deleted Lines in History
DfltVal:Y Valid:Y,N,P Notes:
Y=Yes, N=No, P=Prompt
{SO0$(63,1)}
62 DisplayProfitMargin . . . . . 1 SYY Display Profit Margin Percent iYESNO
DfltVal:N Valid:Y,N Notes:
{SO0_9$(20,1)}
63 EnableShipping. . . . . . . . 1 SYY Enable Shipping . . . . . . . .YESNO
DfltVal:N Valid:Y,N Notes:
{SO0_9$(35,1)}
64 WarrantyCalcBasedOn . . . . . 1 SYY Warranty Calculation Based On .
DfltVal:S Valid:S,I Notes:
S=Ship date, I=Invoice date
{SO0$(180,1)}
65 RecalcExpiration. . . . . . . 1 SYY Recalc Expiration if Ship/InvoiYESNO
DfltVal:N Valid:Y,N Notes:
{SO0$(181,1)}
66 IntegrateGeneralLedger. . . . 1 SYY Integrate To General Ledger . .YESNO
DfltVal:Y Valid:Y,N Notes:
{SO0_9$(8,1)}
67 IntegrateInventory. . . . . . 1 SYY Integrate To Inventory. . . . .YESNO
DfltVal:N Valid:Y,N Notes:
{SO0$(84,1)}
68 IntegrateJobCost. . . . . . . 1 SYY Integrate To Job Cost . . . . .YESNO
DfltVal:N Valid:Y,N
69 PeriodEndOptSelection . . . . 1 SNN Period End Option Selection . .
Notes: {SO0$(77,1)}
70 CurrentInvoiceUpdate. . . . . 1 SYN Current Invoice Update. . . . .
Valid:B,Y,N Notes: {SO0$(67,
1)}
71 CheckForDuplicateCustPO . . . 1 SYY Check for Duplicate Customer POYESNO
DfltVal:N Valid:Y,N
72 CompanyCode . . . . . . . . . 3 SNN Company Code. . . . . . . . . .COMPANYCODE
Notes: Used to "join"
Crystal Tables
73 DefaultNoOfLabels . . . . . . 2.0 NNY Default Number Of Shipping Labe
DfltVal:01 Mask:00 Notes:
{SO0$(40,2)}
74 ProfitMarginPercent . . . . . 3.0 NNN Profit Margin Percent to Displa
Mask:##0 Notes: {SO0_9$(11,
3)}
75 DataVersion . . . . . . . . . 5.2 NNN Data Version. . . . . . . . . .
Mask:#0.00
76 DateUpdated . . . . . . . . . 8 SNN Last Update Date. . . . . . . .DATE
Read Only:Y Notes: YYYYMMDD
77 TimeUpdated . . . . . . . . . 8 SNN Last Update Time. . . . . . . .
Read Only:Y
78 UserUpdatedKey. . . . . . . . 10 SYN Last Update User ID . . . . . .USER
Read Only:Y Mask:0000000000
FmtType:ZEROFILL