<< Click to Display Table of Contents >> Navigation: iVend Database Database > Tables > ProCoupon Table |
Navigation: iVend Database Database > Tables >
iVend 6.6 Database Help
ProCoupon Table
Collapse All Expand All
iVend Database Database : ProCoupon Table |
Description
Stores the issued coupon details for iVend
Properties
Creation Date |
4/13/2015 12:00 PM |
File Group |
PRIMARY |
Text File Group |
|
System Object |
|
Published for Replication |
|
Rows |
7 |
Data Space Used |
8.00 KB |
Index Space Used |
24.00 KB |
Columns
|
Column Name |
Description |
Datatype |
Length |
Allow Nulls |
Default |
Formula |
CouponKey |
Primary key |
VarWChar |
50 |
|
|
|
|
|
Id |
Value is the Id of the Coupon |
VarWChar |
20 |
|
|
|
|
Description |
Refers to the description for the Defined Coupon |
VarWChar |
100 |
|
|
|
|
TriggerQuantity |
Value Stored is the Trigger Quantity in number of product(s) meeting criteria that are required for the coupon to be applicable at Point of Sale. |
Integer |
4 |
|
|
|
|
ApplicableQuantity |
ApplicableQuantity |
Integer |
4 |
|
|
|
|
MultiplyValue |
Stores the True value if the coupon can be redeemed more than once in a same transaction at the POS. By default it remains True |
Numeric |
9 (20,5) |
|
|
|
|
UPCCode |
Stores the Universal Product Code (UPC) for the Coupon (UPC is a type of bar code) |
VarWChar |
255 |
|
|
|
|
RedemptionNumberPerStore |
Stores the value as number of times a coupon can be redeemed in a particular store. |
Integer |
4 |
|
|
|
|
StartDate |
Stores the validity start date of the coupon. The default value for this field is current date. |
DBTimeStamp |
4 |
|
('') |
|
|
EndDate |
Stores the validity end date of the coupon. |
DBTimeStamp |
4 |
|
('') |
|
|
TriggerMultiple |
The value is True if the coupon can be redeemed more than once in a same transaction at the POS. |
Boolean |
1 |
|
((0)) |
|
|
DiscountType |
Stores the Discount type Valid values are None = 0 Amount = 1 Percent = 2 |
Integer |
4 |
|
((0)) |
|
|
DiscountValue |
Stores the value depending on the Discount Type selected (in amount or percentage) |
Numeric |
9 (20,5) |
|
((0)) |
|
|
MinimumOrderValue |
Stores the minimum transaction amount required for coupon to be applicable at POS. |
Numeric |
9 (20,5) |
|
((0)) |
|
|
RedemptionOncePerCustomer |
Stores the number of times the coupon can be redeemed in a particular store. |
Boolean |
1 |
|
((0)) |
|
|
CreatedBy |
Reference of user who has created this record. See also Security User |
VarWChar |
50 |
|
|
|
|
Created |
Date of creation of this record |
DBTimeStamp |
4 |
|
|
|
|
ModifiedBy |
Reference of user who has modified this record. See also Security User |
VarWChar |
50 |
|
|
|
|
Modified |
Date of last modification of this record |
DBTimeStamp |
4 |
|
|
|
|
IsDeleted |
Value is True if the record has been deleted from the system. Record is always Soft Deleted |
Boolean |
1 |
|
|
|
|
CanIssueAtPOS |
The value is True if the coupon can be issued at Point Of Sale. |
Boolean |
1 |
|
((0)) |
|
|
CanPrintAtPOS |
The value is True if the coupon can be printed at Point Of Sale. |
Boolean |
1 |
|
((0)) |
|
|
ReportKey |
Reference key for Report. See also Report |
VarWChar |
50 |
|
((0)) |
|
|
CouponPassTemplate |
Stores the Coupon Pass template to be used with passbook. |
VarWChar |
100 |
|
|
|
|
CouponEmailTemplate |
Stores the Coupon Email template to be used with passbook. |
VarWChar |
100 |
|
|
|
|
PassDescription |
Description Value is the description of the coupon for the iVend Pass. |
VarWChar |
28 |
|
|
|
|
PassValue |
Stores the value of the coupon for the iVend Pass. |
VarWChar |
10 |
|
|
|
|
IsSerialControlled |
Value is true if the Coupon is serial controlled |
Boolean |
1 |
((0)) |
|
|
|
SerialOption |
Store the value if the serial number to be generated manually or automode. Valid values are: AutoGenerated = 0, UserDefined = 1 |
Integer |
4 |
((0)) |
|
|
|
SubsidiaryKey |
Reference key of the Subsidiary. See also Subsidiary |
VarWChar |
50 |
|
((0)) |
|
Indexes
Index |
Description |
Primary |
Unique |
|
|
|
|
|
Objects that depend on ProCoupon
|
Database Object |
Object Type |
Description |
Dep Level |
Stored Procedure |
|
1 |
||
Stored Procedure |
|
1 |
SQL
SET ANSI_NULLS ON SET QUOTED_IDENTIFIER ON CREATE TABLE [dbo].[ProCoupon]( [CouponKey] [nvarchar](50) COLLATE SQL_Latin1_General_CP1_CI_AS NOT NULL, [Id] [nvarchar](20) COLLATE SQL_Latin1_General_CP1_CI_AS NOT NULL, [Description] [nvarchar](100) COLLATE SQL_Latin1_General_CP1_CI_AS NULL, [TriggerQuantity] [int] NOT NULL, [ApplicableQuantity] [int] NOT NULL, [MultiplyValue] [decimal](20, 5) NOT NULL, [UPCCode] [nvarchar](255) COLLATE SQL_Latin1_General_CP1_CI_AS NOT NULL, [RedemptionNumberPerStore] [int] NOT NULL, [StartDate] [datetime] NOT NULL, [EndDate] [datetime] NOT NULL, [TriggerMultiple] [bit] NOT NULL, [DiscountType] [int] NOT NULL, [DiscountValue] [decimal](20, 5) NOT NULL, [MinimumOrderValue] [decimal](20, 5) NOT NULL, [RedemptionOncePerCustomer] [bit] NOT NULL, [CreatedBy] [nvarchar](50) COLLATE SQL_Latin1_General_CP1_CI_AS NOT NULL, [Created] [datetime] NOT NULL, [ModifiedBy] [nvarchar](50) COLLATE SQL_Latin1_General_CP1_CI_AS NOT NULL, [Modified] [datetime] NOT NULL, [IsDeleted] [bit] NOT NULL, [CanIssueAtPOS] [bit] NOT NULL, [CanPrintAtPOS] [bit] NOT NULL, [ReportKey] [nvarchar](50) COLLATE SQL_Latin1_General_CP1_CI_AS NOT NULL, [CouponPassTemplate] [nvarchar](100) COLLATE SQL_Latin1_General_CP1_CI_AS NULL, [CouponEmailTemplate] [nvarchar](100) COLLATE SQL_Latin1_General_CP1_CI_AS NULL, [PassDescription] [nvarchar](28) COLLATE SQL_Latin1_General_CP1_CI_AS NULL, [PassValue] [nvarchar](10) COLLATE SQL_Latin1_General_CP1_CI_AS NULL, [IsSerialControlled] [bit] NULL, [SerialOption] [int] NULL, [SubsidiaryKey] [nvarchar](50) COLLATE SQL_Latin1_General_CP1_CI_AS NOT NULL, CONSTRAINT [PK_PmtPromotionCoupon] PRIMARY KEY CLUSTERED ( [CouponKey] 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].[ProCoupon] ADD CONSTRAINT [DF__ProPromot__Start__26EFBBC6] DEFAULT ('') FOR [StartDate] ALTER TABLE [dbo].[ProCoupon] ADD CONSTRAINT [DF__ProPromot__EndDa__27E3DFFF] DEFAULT ('') FOR [EndDate] ALTER TABLE [dbo].[ProCoupon] ADD CONSTRAINT [DF__ProPromot__Trigg__28D80438] DEFAULT ((0)) FOR [TriggerMultiple] ALTER TABLE [dbo].[ProCoupon] ADD CONSTRAINT [DF__ProPromot__Disco__29CC2871] DEFAULT ((0)) FOR [DiscountType] ALTER TABLE [dbo].[ProCoupon] ADD CONSTRAINT [DF__ProPromot__Disco__2AC04CAA] DEFAULT ((0)) FOR [DiscountValue] ALTER TABLE [dbo].[ProCoupon] ADD CONSTRAINT [DF__ProPromot__Minim__2BB470E3] DEFAULT ((0)) FOR [MinimumOrderValue] ALTER TABLE [dbo].[ProCoupon] ADD CONSTRAINT [DF_ProPromotionCoupon_RedemptionOncePerCustomer] DEFAULT ((0)) FOR [RedemptionOncePerCustomer] ALTER TABLE [dbo].[ProCoupon] ADD CONSTRAINT [DF_ProPromotionCoupon_CanIssueAtPOS] DEFAULT ((0)) FOR [CanIssueAtPOS] ALTER TABLE [dbo].[ProCoupon] ADD CONSTRAINT [DF_ProPromotionCoupon_CanPrintAtPOS] DEFAULT ((0)) FOR [CanPrintAtPOS] ALTER TABLE [dbo].[ProCoupon] ADD CONSTRAINT [DF_ProPromotionCoupon_ReportKey] DEFAULT ((0)) FOR [ReportKey] ALTER TABLE [dbo].[ProCoupon] ADD CONSTRAINT [DF_ProCoupon_IsSerialControlled] DEFAULT ((0)) FOR [IsSerialControlled] ALTER TABLE [dbo].[ProCoupon] ADD CONSTRAINT [DF_ProCoupon_SerialOption] DEFAULT ((0)) FOR [SerialOption] ALTER TABLE [dbo].[ProCoupon] ADD CONSTRAINT [DF_ProCoupon_SubsidiaryKey] DEFAULT ((0)) FOR [SubsidiaryKey] |
See Also
© 2019 All Rights Reserved.
Send comments on this topic.