iVend Database Database : TrxTransactionPromotionDetail 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

TransactionPromotionDetailKey

Value is the system generated key of the transaction payment.

VarWChar

50

TransactionKey

Reference key of the Transaction. See also Transaction

VarWChar

50

Type

Specifies whether the promotion got applied on Principal or Associate item.

Valid values are:

PrincipalItem = 0

AssociateItem = 1

Integer

4

TransactionItemKey

Reference key of the Transaction line item on which the promotion has got applied

VarWChar

50

PromotionKey

Reference key of the Promotion which got applied on the Transaction. See also Promotion

VarWChar

50

Quantity

Quantity on which promotion got applied

Numeric

9 (20,5)

DiscountAmount

Promotion discount amount that has got applied on the line item

Numeric

9 (20,5)

ItemType

Stores the type of line item on which the promotion got applied.

Valid values are:

None = 0

Sales = 1

Order = 2

Layaway = 3

Integer

4

Sets

Number of sets that qualify for promotion

Integer

4

PromotionNumber

Promotion line number to identify transaction line number

Integer

4

StoreKey

VarWChar

50

CustomerKey

VarWChar

50

LoyaltyId

VarWChar

50

Index

Description

Primary

Unique

IX_TrxTransactionPromotionDetail

PK_TrxTransactionPromotionDetail

Database Object

Object Type

Description

Dep Level

Loy_GetTransactionPromotionDetail

Stored Procedure

1

TrxCompleteTransactionUpdates

Stored Procedure

1

vwAnalytics_MerchandisePromotionSales

View

1

vwAnalytics_PromotionSales

View

1

SET ANSI_NULLS ON

SET QUOTED_IDENTIFIER ON

CREATE TABLE [dbo].[TrxTransactionPromotionDetail](

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

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

[Type] [int] NOT NULL,

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

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

[Quantity] [decimal](20, 5) NOT NULL,

[DiscountAmount] [decimal](20, 5) NOT NULL,

[ItemType] [int] NOT NULL,

[Sets] [int] NOT NULL,

[PromotionNumber] [int] NOT NULL,

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

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

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

CONSTRAINT [PK_TrxTransactionPromotionDetail] PRIMARY KEY CLUSTERED

(

[TransactionPromotionDetailKey] ASC

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

) ON [PRIMARY]