Revention Menu Notes

Misc notes for menu dev For changing sizes for a particular item to only have certain sizes, you need to create another group then assign sizes to that group this limits the entire group of items to a certain size

Revention Notes

Make sure to login as the revadmin / L0muQ@352 user first To enable the browser go to regedit.exe HKEY_LOCAL_MACHINE User that auto logs in is Revention Windows Auto Logon There are 3 disks C: Main 19.5 GB R: Data 20.4 GB D: 113MB

Protected: Revention Documentation

There is no excerpt because this is a protected post.

Revention SQL Server Versions

Microsoft SQL Server Management Studio 10.0.1600.22 ((SQL_PreRelease).080709-1414 ) Microsoft Data Access Components (MDAC) 6.1.7601.17514 (win7sp1_rtm.101119-1850) Microsoft MSXML 3.0 6.0 Microsoft Internet Explorer 9.0.8112.16443 Microsoft .NET Framework 2.0.50727.5485 Operating System 6.1.7601

Revention CustomerAddr

[code language=”sql”] USE [Revention] GO /****** Object: Table [dbo].[CustomerAddr] Script Date: 08/20/2018 09:37:59 ******/ CREATE TABLE [dbo].[CustomerAddr]( [AddrKey] [int] IDENTITY(1,1) NOT NULL, [StNumber] [nvarchar](15) NULL, [Street] [nvarchar](50) NULL, [Apt] [nvarchar](25) NULL, [City] [nvarchar](25) NULL, [State] [nvarchar](20) NULL, [Zip] [nvarchar](20) NULL, [AddrType] [nvarchar](10) NOT NULL, [CompanyName] [nvarchar](50) NULL, [EntryCode] [nvarchar](20) NULL, [AddrZone] [nvarchar](25) NULL, [CrossStreet] [nvarchar](40) […]

Revention Customer

[code language=”sql”] USE [Revention] GO /****** Object: Table [dbo].[Customer] Script Date: 08/20/2018 09:36:32 ******/ SET ANSI_NULLS ON GO SET QUOTED_IDENTIFIER ON GO CREATE TABLE [dbo].[Customer]( [CustomerKey] [int] IDENTITY(1,1) NOT NULL, [AddrKey] [int] NULL, [LastName] [nvarchar](25) NULL, [FirstName] [nvarchar](25) NULL, [CustID] [nvarchar](25) NULL, [SpNote] [nvarchar](100) NOT NULL, [DelNote] [nvarchar](100) NOT NULL, [FirstOrdDate] [datetime] NULL, [LastOrdDate] [datetime] […]

Revention CustAcct

[code language=”sql”] USE [Revention] GO /****** Object: Table [dbo].[CustAcct] Script Date: 08/20/2018 09:34:33 ******/ SET ANSI_NULLS ON GO SET QUOTED_IDENTIFIER ON GO CREATE TABLE [dbo].[CustAcct]( [CustAcctKey] [int] IDENTITY(1,1) NOT NULL, [AcctNum] [int] NOT NULL, [CustKey] [int] NOT NULL, [AcctBalance] [money] NOT NULL, [AcctStatus] [nvarchar](10) NULL, [CreditLimit] [money] NOT NULL, [AvailableCredit] [money] NOT NULL, [DateOpened] [datetime] […]

Revention Inventory Vendors

[code language=”sql”] /****** Object: Table [dbo].[InventVendor] Script Date: 08/08/2018 12:42:56 ******/ SET ANSI_NULLS ON GO SET QUOTED_IDENTIFIER ON GO CREATE TABLE [dbo].[InventVendor]( [InventVendorKey] [int] IDENTITY(1,1) NOT NULL, [Name] [nvarchar](25) NULL, [Addr1] [nvarchar](25) NULL, [Addr2] [nvarchar](25) NULL, [City] [nvarchar](25) NULL, [State] [nvarchar](15) NULL, [Zip] [nvarchar](15) NULL, [Phone] [nvarchar](25) NULL, [Fax] [nvarchar](25) NULL, [VendorID] [nvarchar](25) NULL, [SalesRep] […]