<< Click to Display Table of Contents >> Navigation: iVend Database Database > Tables > ProPromotionBonusBuysMaster Table |
Navigation: iVend Database Database > Tables >
iVend 6.6 Database Help
ProPromotionBonusBuysMaster Table
Collapse All Expand All
iVend Database Database : ProPromotionBonusBuysMaster Table |
Description
Stores the master data for the Promotion defined
Properties
Creation Date |
4/13/2015 12:00 PM |
File Group |
PRIMARY |
Text File Group |
|
System Object |
|
Published for Replication |
|
Rows |
6 |
Data Space Used |
8.00 KB |
Index Space Used |
24.00 KB |
Columns
|
Column Name |
Description |
Datatype |
Length |
Allow Nulls |
Default |
Formula |
PromotionKey |
Store the Primary Key for the table. |
VarWChar |
50 |
|
|
|
|
|
Id |
Value is the Id of the Promotion Bonus Buys Master |
VarWChar |
20 |
|
|
|
|
Description |
Refers to the description for the Bonus Buy |
VarWChar |
100 |
|
|
|
|
HasValidDates |
Value if true if the promotion is available for limited period. |
Boolean |
1 |
|
|
|
|
StartDate |
Stores the start date if HasValidDates value is true. |
DBTimeStamp |
4 |
|
|
|
|
EndDate |
Stores the End Time to which the promotion ends if the HasValidTime value is true. |
DBTimeStamp |
4 |
|
|
|
|
HasValidTime |
Stores the true value if the promotion has been defined to Dates as well as specific time slots. For Example: Happy Hours |
Boolean |
1 |
|
|
|
|
StartTime |
Stores the Start Time from which the promotion starts if the HasValidTime value is true. |
DBTimeStamp |
4 |
|
|
|
|
EndTime |
Stores the Start Time from which the promotion starts if the HasValidTime value is true. |
DBTimeStamp |
4 |
|
|
|
|
BuyOptionalCount |
Stores the value to specify the number of conditions that are to be fulfilled among the optional buy conditions so that the system can apply this promotion. |
Integer |
4 |
|
|
|
|
GetOptionalCount |
Stores the value to specify the number of conditions that are to be fulfilled among the optional get conditions so that the system can apply this promotion. |
Integer |
4 |
|
|
|
|
MinimumBillAmount |
Stores the value as total minimum bill amount for promotion applicability at Point Of Sale. |
Numeric |
9 (20,5) |
|
|
|
|
MinimumQuantity |
Stores the value as minimum quantity of product(s) required to trigger the promotion at Point Of Sale. |
Integer |
4 |
|
|
|
|
DiscountPercent |
Stores the value as discount offered(in amount or percentage) at sale level. |
Numeric |
9 (20,5) |
|
|
|
|
CanRepeatInTransaction |
Value is True if the same promotion can be applied multiple times in a single transaction at POS. |
Boolean |
1 |
|
|
|
|
LowestValue |
Specifies if the discount is to be applied on the the lowest value item in a transaction. |
Boolean |
1 |
|
|
|
|
ExcludeDiscountedItems |
Value is True if user wants to exclude already discounted items from promotion applicability. |
Boolean |
1 |
|
|
|
|
PromotionType |
Stores the value for the Promotion type. |
Integer |
4 |
|
|
|
|
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 |
|
|
|
|
Active |
Value is True if the promotion is active. |
Boolean |
1 |
|
|
|
|
PromotionColor |
Stores the value of promotion color that to be displayed on items added in a transaction. |
Integer |
4 |
|
|
|
|
SequenceNumber |
Stores the value as Sequence Number. The promotions will be listed in Bonus Buy Hierarchy based on this sequenece number value and promotions will be applied. |
Integer |
4 |
|
|
|
|
ApplyOnItemScan |
Value is True if the promotion should be applied On Item Scan (immediately) rather than on while doing the Payment for transaction. |
Boolean |
1 |
|
((1)) |
|
|
DiscountType |
Discount type applicable. Valid values are: None = 0 Amount = 1 Percent = 2 |
Integer |
4 |
|
((2)) |
|
|
MaximumRedemptionCount |
Defines the Maximum Count for the redemption of the defined Promotion |
Integer |
4 |
((0)) |
|
|
|
TotalRedemptionCount |
Defines the Count of the redemption done for the defined Promotion |
Integer |
4 |
((0)) |
|
|
|
GetItemAtFixedPrice |
Specifies the pricie on which the itmes to be sold in promotion |
Numeric |
9 (20,5) |
|
|
|
|
SubsidiaryKey |
Reference key of the Subsidiary. See also Subsidiary |
VarWChar |
50 |
|
((0)) |
|
|
IsApplyOnce |
Value is true, if this bonus can be applicable once only. |
Boolean |
1 |
|
|
|
|
PromotionApplicabilityCount |
Stores promotion applicability count on transaciton. |
Integer |
4 |
|
|
Indexes
Index |
Description |
Primary |
Unique |
|
|
|
|
|
Objects that depend on ProPromotionBonusBuysMaster
|
Database Object |
Object Type |
Description |
Dep Level |
Stored Procedure |
|
1 |
||
Stored Procedure |
|
1 |
||
View |
|
1 |
||
View |
|
1 |
SQL
SET ANSI_NULLS ON SET QUOTED_IDENTIFIER ON CREATE TABLE [dbo].[ProPromotionBonusBuysMaster]( [PromotionKey] [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, [HasValidDates] [bit] NOT NULL, [StartDate] [datetime] NULL, [EndDate] [datetime] NULL, [HasValidTime] [bit] NOT NULL, [StartTime] [datetime] NULL, [EndTime] [datetime] NULL, [BuyOptionalCount] [int] NOT NULL, [GetOptionalCount] [int] NOT NULL, [MinimumBillAmount] [decimal](20, 5) NULL, [MinimumQuantity] [int] NULL, [DiscountPercent] [decimal](20, 5) NOT NULL, [CanRepeatInTransaction] [bit] NOT NULL, [LowestValue] [bit] NOT NULL, [ExcludeDiscountedItems] [bit] NOT NULL, [PromotionType] [int] 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 NULL, [Modified] [datetime] NULL, [IsDeleted] [bit] NOT NULL, [Active] [bit] NOT NULL, [PromotionColor] [int] NULL, [SequenceNumber] [int] NOT NULL, [ApplyOnItemScan] [bit] NOT NULL, [DiscountType] [int] NOT NULL, [MaximumRedemptionCount] [int] NULL, [TotalRedemptionCount] [int] NULL, [GetItemAtFixedPrice] [decimal](20, 5) NULL, [SubsidiaryKey] [nvarchar](50) COLLATE SQL_Latin1_General_CP1_CI_AS NOT NULL, [IsApplyOnce] [bit] NULL, [PromotionApplicabilityCount] [int] NULL, CONSTRAINT [PK_ProPromotionBonusBuysMaster] PRIMARY KEY CLUSTERED ( [PromotionKey] 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].[ProPromotionBonusBuysMaster] ADD CONSTRAINT [DF_ProPromotionBonusBuysMaster_ApplyOnItemScan] DEFAULT ((1)) FOR [ApplyOnItemScan] ALTER TABLE [dbo].[ProPromotionBonusBuysMaster] ADD CONSTRAINT [DF_ProPromotionBonusBuysMaster_DiscountType] DEFAULT ((2)) FOR [DiscountType] ALTER TABLE [dbo].[ProPromotionBonusBuysMaster] ADD CONSTRAINT [DF_ProPromotionBonusBuysMaster_MaximumRedemptionCount] DEFAULT ((0)) FOR [MaximumRedemptionCount] ALTER TABLE [dbo].[ProPromotionBonusBuysMaster] ADD CONSTRAINT [DF_ProPromotionBonusBuysMaster_TotalRedemptionCount] DEFAULT ((0)) FOR [TotalRedemptionCount] ALTER TABLE [dbo].[ProPromotionBonusBuysMaster] ADD CONSTRAINT [DF__ProPromot__Subsi__263B8EAF] DEFAULT ((0)) FOR [SubsidiaryKey] |
See Also
© 2019 All Rights Reserved.
Send comments on this topic.