[SETTINGS]
CREATE TABLE
USE [POS]
GO
/****** Object: Table [dbo].[Settings] Script Date: 10/4/2024 3:43:48 PM ******/
SET ANSI_NULLS ON
GO
SET QUOTED_IDENTIFIER ON
GO
CREATE TABLE [dbo].[Settings](
[ID] [int] IDENTITY(1,1) NOT NULL,
[POSNumber] [nvarchar](50) NULL,
[POSDescription] [nvarchar](max) NULL,
[ClassicPOS] [bit] NULL,
[HybridPOS] [bit] NULL,
[ToshibaPOS] [bit] NULL,
[TouchServePOS] [bit] NULL,
[StationTypePOS] [bit] NULL,
[StationTypeBackOffice] [bit] NULL,
[UseSounds] [bit] NULL,
[LogOnEachSale] [bit] NULL,
[OnScreenKeyboardSolid] [bit] NULL,
[ShoppingCartEnabled] [bit] NULL,
[ShowWarningonNoTOBLicense] [bit] NULL,
[DonotTenderonWalking] [bit] NULL,
[AllowSalesBelowZero] [bit] NULL,
[ShowBelowZeroMessage] [bit] NULL,
[DailyGoal] [money] NULL,
[QuantityCharacters] [nvarchar](max) NULL,
[OpenDepartmentMax] [money] NULL,
[AllowManageronStationPause] [bit] NULL,
[UseXReport] [bit] NULL,
[UseSearchforInvoice] [bit] NULL,
[PauseStationonIdle] [bit] NULL,
[UsePasswordonNoSale] [bit] NULL,
[UseHandheld] [bit] NULL,
[UseBiometric] [bit] NULL,
[ReturnReasonCode] [bit] NULL,
[DODineIN] [bit] NULL,
[DOTakeOut] [bit] NULL,
[DOPhone] [bit] NULL,
[DODriveThru] [bit] NULL,
[SSDineIn] [bit] NULL,
[SSTakeout] [bit] NULL,
[SSPhone] [bit] NULL,
[SSDriveThru] [bit] NULL,
[MMFDrawerNumber] [nvarchar](max) NULL,
[UseMMFDrawer] [bit] NULL,
[LCPort] [nvarchar](max) NULL,
[UseLCDrawer] [bit] NULL,
[UseToshibaDrawer] [bit] NULL,
[ScaleScannerPort] [nvarchar](max) NULL,
[UseScaleScanner] [bit] NULL,
[UseReport1] [bit] NULL,
[UseReport2] [bit] NULL,
[UseReport3] [bit] NULL,
[UseReport4] [bit] NULL,
[UseReport5] [bit] NULL,
[UseReport6] [bit] NULL,
[UseReport7] [bit] NULL,
[UseReport8] [bit] NULL,
[UseReport9] [bit] NULL,
[UseReport10] [bit] NULL,
[UseReport11] [bit] NULL,
[UseReport12] [bit] NULL,
[UseReport13] [bit] NULL,
[UseReport14] [bit] NULL,
[UseReport15] [bit] NULL,
[UseReport16] [bit] NULL,
[UseReport17] [bit] NULL,
[UseReport18] [bit] NULL,
[UseReport19] [bit] NULL,
[Copies1] [nvarchar](max) NULL,
[Copies2] [nvarchar](max) NULL,
[Copies3] [nvarchar](max) NULL,
[Copies4] [nvarchar](max) NULL,
[Copies5] [nvarchar](max) NULL,
[Copies6] [nvarchar](max) NULL,
[Copies7] [nvarchar](max) NULL,
[Copies8] [nvarchar](max) NULL,
[Copies9] [nvarchar](max) NULL,
[Copies10] [nvarchar](max) NULL,
[Copies11] [nvarchar](max) NULL,
[Copies12] [nvarchar](max) NULL,
[Copies13] [nvarchar](max) NULL,
[Copies14] [nvarchar](max) NULL,
[Copies15] [nvarchar](max) NULL,
[Copies16] [nvarchar](max) NULL,
[Copies17] [nvarchar](max) NULL,
[Copies18] [nvarchar](max) NULL,
[Copies19] [nvarchar](max) NULL,
[Printer1] [nvarchar](max) NULL,
[Printer2] [nvarchar](max) NULL,
[Printer3] [nvarchar](max) NULL,
[Printer4] [nvarchar](max) NULL,
[Printer5] [nvarchar](max) NULL,
[Printer6] [nvarchar](max) NULL,
[Printer7] [nvarchar](max) NULL,
[Printer8] [nvarchar](max) NULL,
[Printer9] [nvarchar](max) NULL,
[Printer10] [nvarchar](max) NULL,
[Printer11] [nvarchar](max) NULL,
[Printer12] [nvarchar](max) NULL,
[Printer13] [nvarchar](max) NULL,
[Printer14] [nvarchar](max) NULL,
[Printer15] [nvarchar](max) NULL,
[Printer16] [nvarchar](max) NULL,
[Printer17] [nvarchar](max) NULL,
[Printer18] [nvarchar](max) NULL,
[Printer19] [nvarchar](max) NULL,
[InvoiceTemplate] [nvarchar](max) NULL,
[UsepackingSlipOnHold] [bit] NULL,
[UseDrinksPrinter] [bit] NULL,
[UseCheckEndorse] [bit] NULL,
[ShowLogoInvoice] [bit] NULL,
[UseDualMonitor] [bit] NULL,
[DualMonitorNumber] [nvarchar](max) NULL,
[UsePCCharge] [bit] NULL,
[UseMurcuryPay] [bit] NULL,
[UseCashBack] [bit] NULL,
[VerifyLastFourCC] [bit] NULL,
[PRCash] [bit] NULL,
[PRCreditCard] [bit] NULL,
[PRCheck] [bit] NULL,
[PRDebit] [bit] NULL,
[PRFoodStamp] [bit] NULL,
[PREBTCash] [bit] NULL,
[PRGiftCard] [bit] NULL,
[PRHouseAccount] [bit] NULL,
[ODCash] [bit] NULL,
[ODCreditCard] [bit] NULL,
[ODCheck] [bit] NULL,
[ODDebit] [bit] NULL,
[ODFoodStamp] [bit] NULL,
[ODEbtCash] [bit] NULL,
[ODGiftCard] [bit] NULL,
[ODHouseAccount] [bit] NULL,
[UTCash] [bit] NULL,
[UTCreditCard] [bit] NULL,
[UTCheck] [bit] NULL,
[UTDebit] [bit] NULL,
[UTFoodStamp] [bit] NULL,
[UTEBTCash] [bit] NULL,
[UTGiftCard] [bit] NULL,
[UTHouseAccount] [bit] NULL,
[UseCheckFile] [bit] NULL,
[txtcomport] [nvarchar](max) NULL,
[chkUse6550] [bit] NULL,
[chkuseSig] [bit] NULL,
[chkUseSignonAllInv] [bit] NULL,
[chkCredit] [bit] NULL,
[chkDebit] [bit] NULL,
[chkEBTCash] [bit] NULL,
[chkEBTFood] [bit] NULL,
[ChkPrePaidGiftCard] [bit] NULL,
[txtdebitcashback] [money] NULL,
[txtebtcashback] [money] NULL,
CONSTRAINT [PK_Settings] PRIMARY KEY CLUSTERED
(
[ID] ASC
)WITH (PAD_INDEX = OFF, STATISTICS_NORECOMPUTE = OFF, IGNORE_DUP_KEY = OFF, ALLOW_ROW_LOCKS = ON, ALLOW_PAGE_LOCKS = ON, OPTIMIZE_FOR_SEQUENTIAL_KEY = OFF) ON [PRIMARY]
) ON [PRIMARY] TEXTIMAGE_ON [PRIMARY]
GO
Last updated