iVend Database Database > Tables > PrcSpecialPriceListQuantity Table

Navigation: iVend Database Database > Tables >

iVend 6.6 Database Help

PrcSpecialPriceListQuantity Table

Collapse All Expand All

iVend Database Database : PrcSpecialPriceListQuantity Table

Description

Defines the volume discount applicable on products. Here we specify the quantity of product on the purchase of which a certain discount would be applied.

Properties

Creation Date	4/13/2015 12:00 PM
File Group	PRIMARY
Text File Group
System Object
Published for Replication
Rows	24
Data Space Used	8.00 KB
Index Space Used	24.00 KB

Columns

Column Name	Description	Datatype	Length	Allow Nulls	Default	Formula
SpecialPriceListQuantityKey	Primary Key	VarWChar	50
SpecialPriceListDateKey	Reference key of Special price list date	VarWChar	50
Quantity	Quantity of product	Numeric	9 (20,5)
Price	Price in price list according to quantity	Numeric	9 (20,5)
DiscountType	Discount type applicable. Valid values are: None = 0 Amount = 1 Percent = 2	Integer	4
Discount	Discount amount or percentage	Numeric	9 (20,5)
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
IsDeleted	Value is True if the record has been deleted from the system. Record is always Soft Deleted	Boolean	1
QuantityLineNumber	Stores the Sequence number of the Price List (based on Quantity) when the multiple price list is defined	Integer	4		((0))
UOMKey	Refers to the UOM key. See InvUOM	VarWChar	50		((0))
CurrencyKey	Reference Key for currency	VarWChar	50		((0))

Indexes

Index	Description	Primary	Unique
IX_PrcSpecialPriceListQuantity
PK_PrcSpecialPriceListQuantity

Objects that depend on PrcSpecialPriceListQuantity

Database Object	Object Type	Description	Dep Level
uspGetItemPrice	Stored Procedure		2
uspGetItemSpecialPrice	Stored Procedure	Determines the price of the Product for the customer specified and other parameters	1

SQL

SET ANSI_NULLS ON

SET QUOTED_IDENTIFIER ON

CREATE TABLE [dbo].[PrcSpecialPriceListQuantity](

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

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

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

[Price] [numeric](20, 5) NOT NULL,

[DiscountType] [int] NOT NULL,

[Discount] [numeric](20, 5) 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,

[IsDeleted] [bit] NOT NULL,

[QuantityLineNumber] [int] NOT NULL,

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

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

CONSTRAINT [PK_PrcSpecialPriceListQuantity] PRIMARY KEY CLUSTERED

(

[SpecialPriceListQuantityKey] 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].[PrcSpecialPriceListQuantity] ADD CONSTRAINT [DF_PrcSpecialPriceListQuantity_QuantityLineNumber] DEFAULT ((0)) FOR [QuantityLineNumber]

ALTER TABLE [dbo].[PrcSpecialPriceListQuantity] ADD CONSTRAINT [DF_PrcSpecialPriceListQuantity_UOMKey] DEFAULT ((0)) FOR [UOMKey]

ALTER TABLE [dbo].[PrcSpecialPriceListQuantity] ADD CONSTRAINT [DF_PrcSpecialPriceListQuantity_CurrencyKey] DEFAULT ((0)) FOR [CurrencyKey]

Related Objects

iVend Database Database

Send comments on this topic.