iVend Database Database > Tables > InvProductGroup Table

iVend 6.6 Database Help

InvProductGroup Table

Collapse All Expand All

iVend Database Database : InvProductGroup Table

Description

Defined the various groups under which the products can be categorised.

Properties

Columns

Column Name	Description	Datatype	Length	Allow Nulls	Default	Formula
ProductGroupKey	System generated Primary key of the table.	VarWChar	50
Id	Refers to the product group's Id	VarWChar	20
Description	Refers to the product group's description	VarWChar	100
RequireAgeVerification	For future use	Boolean	1
MinAge	For future use	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
IsDefault	Flag to mark the default product group for product	Boolean	1		((0))
InventoryCycleSetupKey	Reference Key of Inventory Cycle Setup. See also Inventory Cycle Setup	VarWChar	50
FulfillmentPlanSaleKey		VarWChar	50		((0))
FulfillmentPlanSOKey		VarWChar	50		((0))
FulfillmentPlanLayawayKey		VarWChar	50		((0))

Indexes

Index	Description	Primary	Unique
PK_InvProductGroup

Objects that depend on InvProductGroup

Database Object	Object Type	Description	Dep Level
Forecast	Stored Procedure		1
GetInventoryItemForStockCount	Stored Procedure		1
GetMobileReplicationData	Stored Procedure		1
MRP	Stored Procedure		1
Rpt_ItemWithoutSale	User Defined Function		1
rpt_LayAway	Stored Procedure		1
rptOpeningBalance	User Defined Function		1
rptOpeningBalance_dailyClosingBal	User Defined Function		1
rptOpeningBalance_Location	User Defined Function		1
rptOpeningBalance_Stock	User Defined Function		1
rptSalesData	User Defined Function		1
rptSalesTransactionData	User Defined Function		1
rptSalesTransactionDataWithSalesPerson	User Defined Function		1
SalesAnalysisbySalesPersons	Stored Procedure		2
SalesDetail	User Defined Function		1
vw_GrossProfit	View		1
vw_InventoryCost	View		1
vw_InventoryMovement	View		1
vw_SalesReportData	View		1
vwAnalytics_InventorySnapshot	View		1
vwAnalytics_MerchandiseSales	View		1
vwAnalytics_NetSales	View		1
vwAnalytics_Sales	View		1

SQL

SET ANSI_NULLS ON

SET QUOTED_IDENTIFIER ON

CREATE TABLE [dbo].[InvProductGroup](

[ProductGroupKey] [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,

[RequireAgeVerification] [bit] NOT NULL,

[MinAge] [int] 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,

[IsDefault] [bit] NOT NULL,

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

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

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

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

CONSTRAINT [PK_InvProductGroup] PRIMARY KEY CLUSTERED

(

[ProductGroupKey] 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].[InvProductGroup] ADD CONSTRAINT [DF_InvProductGroup_IsDefault] DEFAULT ((0)) FOR [IsDefault]

ALTER TABLE [dbo].[InvProductGroup] ADD CONSTRAINT [DF__InvProduc__Fulfi__329743F3] DEFAULT ((0)) FOR [FulfillmentPlanSaleKey]

ALTER TABLE [dbo].[InvProductGroup] ADD CONSTRAINT [DF__InvProduc__Fulfi__338B682C] DEFAULT ((0)) FOR [FulfillmentPlanSOKey]

ALTER TABLE [dbo].[InvProductGroup] ADD CONSTRAINT [DF__InvProduc__Fulfi__347F8C65] DEFAULT ((0)) FOR [FulfillmentPlanLayawayKey]

Send comments on this topic.