iVend Database Database : RtlFiscalMask Table

Creation Date

4/13/2015 12:00 PM

File Group

PRIMARY

Text File Group

System Object

Published for Replication

Rows

0

Data Space Used

0.00 KB

Index Space Used

0.00 KB

Column Name

Description

Datatype

Length

Allow Nulls

Default

Formula

FiscalMaskKey

Primary key

VarWChar

50

SiteId

Value is the site id for the Fiscal Mask.

Integer

4

CustomerGroupKey

Reference Key for Customer group. See also Customer Group

VarWChar

50

TransactionType

Refers to the type of transaction Valid values are: CashIn = 0 CashOut = 1 Transaction = 2

Integer

4

((0))

Mask

Specifies the fiscal mask

VarWChar

50

StartingNumber

Specifies the starting number of fiscal mask

Integer

4

((0))

Index

Description

Primary

Unique

IX_RtlFiscalMask

PK_RtlFiscalMask

SET ANSI_NULLS ON

SET QUOTED_IDENTIFIER ON

CREATE TABLE [dbo].[RtlFiscalMask](

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

[SiteId] [int] NOT NULL,

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

[TransactionType] [int] NOT NULL,

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

[StartingNumber] [int] NOT NULL,

CONSTRAINT [PK_RtlFiscalMask] PRIMARY KEY CLUSTERED

(

[FiscalMaskKey] ASC

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

) ON [PRIMARY]

ALTER TABLE [dbo].[RtlFiscalMask] ADD CONSTRAINT [DF_RtlFiscalMask_TransactionType] DEFAULT ((0)) FOR [TransactionType]

ALTER TABLE [dbo].[RtlFiscalMask] ADD CONSTRAINT [DF_RtlFiscalMask_StartingNumber] DEFAULT ((0)) FOR [StartingNumber]