[SETTINGS]

CREATE TABLE

[SETTINGS]
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