iVend Database Database > Tables > PrcSpecialPriceDiscountGroupDate Table

Navigation: iVend Database Database > Tables >

iVend 6.6 Database Help

PrcSpecialPriceDiscountGroupDate Table

Collapse All Expand All

iVend Database Database : PrcSpecialPriceDiscountGroupDate Table

Description

Defines a list of all products which fall under a common discount group on the basis of belonging to a common Customer group, Product group or Manufacturer by Date range

Properties

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

Columns

Column Name	Description	Datatype	Length	Allow Nulls	Default	Formula
PriceDiscountGroupDateKey	Primary Key	VarWChar	50
PriceDiscountGroupKey	Reference key of Special Price Discount Group. See also SpecialPriceDiscountGroup	VarWChar	50
FromDate	Date From which the discount would get applied	DBTimeStamp	4
ToDate	Date To which the discount would get applied	DBTimeStamp	4
DiscountType	Discount type applicable. Valid values are: None = 0 Amount = 1 Percent = 2	Integer	4
Discount	Discount amount or percentage depending on the discount type selected	Numeric	9 (20,5)
IsDeleted	Value is True if the record has been deleted from the system. Record is always Soft Deleted	Boolean	1
Created	Date of creation of this record	DBTimeStamp	4
Modified	Date of last modification of this record	DBTimeStamp	4
CreatedBy	Reference of user who has created this record. See also Security User	VarWChar	50
ModifiedBy	Reference of user who has modified this record. See also Security User	VarWChar	50
SubsidiaryKey	Reference key of the Subsidiary. See also Subsidiary	VarWChar	50		((0))
WarehouseKey	Refers to the Warehouse applicable to the SpecialPriceDiscount Group Date. See also Warehouse	VarWChar	50		((0))

Indexes

Index	Description	Primary	Unique
PK_PrcSpecialPriceDiscountGroupDate

Objects that depend on PrcSpecialPriceDiscountGroupDate

	Database Object	Object Type	Description	Dep Level
	uspGetItemPrice	Stored Procedure		1

SQL

SET ANSI_NULLS ON

SET QUOTED_IDENTIFIER ON

CREATE TABLE [dbo].[PrcSpecialPriceDiscountGroupDate](

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

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

[FromDate] [datetime] NOT NULL,

[ToDate] [datetime] NULL,

[DiscountType] [int] NOT NULL,

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

[IsDeleted] [bit] NOT NULL,

[Created] [datetime] NOT NULL,

[Modified] [datetime] NOT NULL,

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

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

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

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

CONSTRAINT [PK_PrcSpecialPriceDiscountGroupDate] PRIMARY KEY CLUSTERED

(

[PriceDiscountGroupDateKey] 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].[PrcSpecialPriceDiscountGroupDate] ADD CONSTRAINT [DF_PrcSpecialPriceDiscountGroupDate_SubsidiaryKey] DEFAULT ((0)) FOR [SubsidiaryKey]

ALTER TABLE [dbo].[PrcSpecialPriceDiscountGroupDate] ADD CONSTRAINT [DF_PrcSpecialPriceDiscountGroupDate_WarehouseKey] DEFAULT ((0)) FOR [WarehouseKey]

Related Objects

iVend Database Database

Send comments on this topic.