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

CouponIssueInformationKey

Primary key for the table

VarWChar

50

TransactionKey

Reference key for the Transaction

VarWChar

50

TransactionCouponKey

Reference key for the Transaction coupon

VarWChar

50

CouponKey

Reference Key for the coupon. See Coupon

VarWChar

50

CustomerKey

Reference key for the customer. See Customer

VarWChar

50

Quantity

Value is the quantity for the coupon issued

Numeric

9 (20,5)

ValidDate

Stores the valid date for the coupon

DBTimeStamp

4

IssueDate

Stores the date on which the coupon has been issued

DBTimeStamp

4

IssueStoreKey

Reference key for the store. See Store

VarWChar

50

Status

Value is the status of the coupon

Integer

4

Created

Date of creation of this record

DBTimeStamp

4

CreatedBy

Reference of user who has created this record. See also Security User

VarWChar

50

Modified

Date of last modification of this record

DBTimeStamp

4

ModifiedBy

Reference of user who has modified this record. See also Security User

VarWChar

50

SerialNumber

Value is the serial number for the coupon

VarWChar

50

DiscountType

Specifies whether discount has been defined in amount or precentage.

Valid values are:

None = 0

Amount = 1

Percentage = 2

Integer

4

Discount

Stores the discount value assigned to the coupon

Numeric

9 (20,5)

Index

Description

Primary

Unique

PK_ProCouponIssueInformation

SET ANSI_NULLS ON

SET QUOTED_IDENTIFIER ON

CREATE TABLE [dbo].[ProCouponIssueInformation](

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

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

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

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

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

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

[ValidDate] [datetime] NOT NULL,

[IssueDate] [datetime] NOT NULL,

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

[Status] [int] NOT NULL,

[Created] [datetime] NOT NULL,

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

[Modified] [datetime] NOT NULL,

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

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

[DiscountType] [int] NULL,

[Discount] [decimal](20, 5) NULL,

CONSTRAINT [PK_ProCouponIssueInformation] PRIMARY KEY CLUSTERED

(

[CouponIssueInformationKey] ASC

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

) ON [PRIMARY]