iVend Database Database : CfgDiscountGroupSetup Table

Creation Date

4/13/2015 12:00 PM

File Group

PRIMARY

Text File Group

System Object

Published for Replication

Rows

1

Data Space Used

8.00 KB

Index Space Used

8.00 KB

Column Name

Description

Datatype

Length

Allow Nulls

Default

Formula

DiscountGroupKey

Primary key

Integer

4

LineDiscountGroup

Specifies the Discount Group

Valid values are

Group1 =0

Group1 =1

Group1 =2

Group1 =3

Integer

4

SystemDiscountGroup

Specifies the Discount Group

Valid values are

Group1 =0

Group1 =1

Group1 =2

Group1 =3

Integer

4

CouponDiscountGroup

Specifies the Discount Group

Valid values are

Group1 =0

Group1 =1

Group1 =2

Group1 =3

Integer

4

PromotionDiscountGroup

Store the Discount Group applied on promotion

Integer

4

Group1Option

Specifies how discount should be calculated within Group 1

Valid values are

Sum = 1

Maximum =2

Integer

4

Group1Relation

Specify how Group 1 discount calculation is related with Group 2 discount.

Valid values are

Sum = 1

Maximum =2

Integer

4

Group2Option

Specifies how discount should be calculated within Group 2

Valid values are

Sum = 1

Maximum =2

Integer

4

Group2Relation

Specify how Group 2 discount calculation is related with Group 3 discount.

Valid values are

Sum = 1

Maximum =2

Integer

4

Group3Option

Specifies how discount should be calculated within Group 3

Valid values are

Sum = 1

Maximum =2

Integer

4

Group3Relation

Specify how Group 3 discount calculation is related with Group 4 discount.

Valid values are

Sum = 1

Maximum =2

Integer

4

Group4Option

Specifies how discount should be calculated within Group 4

Valid values are

Sum = 1

Maximum =2

Integer

4

Group4Relation

Default value is 2

Integer

4

Index

Description

Primary

Unique

PK_RtlDiscountGroupSetup

SET ANSI_NULLS ON

SET QUOTED_IDENTIFIER ON

CREATE TABLE [dbo].[CfgDiscountGroupSetup](

[DiscountGroupKey] [int] NOT NULL,

[LineDiscountGroup] [int] NOT NULL,

[SystemDiscountGroup] [int] NOT NULL,

[CouponDiscountGroup] [int] NOT NULL,

[PromotionDiscountGroup] [int] NOT NULL,

[Group1Option] [int] NOT NULL,

[Group1Relation] [int] NOT NULL,

[Group2Option] [int] NOT NULL,

[Group2Relation] [int] NOT NULL,

[Group3Option] [int] NOT NULL,

[Group3Relation] [int] NOT NULL,

[Group4Option] [int] NOT NULL,

[Group4Relation] [int] NOT NULL,

CONSTRAINT [PK_RtlDiscountGroupSetup] PRIMARY KEY CLUSTERED

(

[DiscountGroupKey] ASC

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

) ON [PRIMARY]