iVend Database Database : SecCustomSecuritySubFunction Table

Creation Date

4/13/2015 12:00 PM

File Group

PRIMARY

Text File Group

System Object

Published for Replication

Rows

435

Data Space Used

24.00 KB

Index Space Used

16.00 KB

Column Name

Description

Datatype

Length

Allow Nulls

Default

Formula

CustomSecuritySubFunctionKey

Value is the system generated Primary Key of the table.

VarWChar

50

SecuritySubFunctionKey

Reference key of the Security Sub Function. See also SecuritySubFunction

VarWChar

50

AccessLevel

Defines the access level

Valid values are:

None= 0

Read=1

Write=2

All=3

Integer

4

StoreType

Store the ownership of the store.

Valid values are:

CompanyOwnedCompanyOperated = 0

CompanyOwnedDistributorOperated = 1

DistributorOwnedDistributorOperated = 2

Integer

4

Localisation

For Future use

VarWChar

50

ERPType

Stores the Value of ERP Chosen

Integer

4

Index

Description

Primary

Unique

PK_SecCustomSecuritySubFunction

SET ANSI_NULLS ON

SET QUOTED_IDENTIFIER ON

CREATE TABLE [dbo].[SecCustomSecuritySubFunction](

[CustomSecuritySubFunctionKey] [nvarchar](50) COLLATE SQL_Latin1_General_CP1_CI_AS NOT NULL,

[SecuritySubFunctionKey] [nvarchar](50) COLLATE SQL_Latin1_General_CP1_CI_AS NOT NULL,

[AccessLevel] [int] NOT NULL,

[StoreType] [int] NOT NULL,

[Localisation] [nvarchar](50) COLLATE SQL_Latin1_General_CP1_CI_AS NULL,

[ERPType] [int] NULL,

CONSTRAINT [PK_SecCustomSecuritySubFunction] PRIMARY KEY CLUSTERED

(

[CustomSecuritySubFunctionKey] ASC

)WITH (PAD_INDEX = OFF, STATISTICS_NORECOMPUTE = OFF, IGNORE_DUP_KEY = OFF, ALLOW_ROW_LOCKS = ON, ALLOW_PAGE_LOCKS = ON) ON [PRIMARY]

) ON [PRIMARY]