<< Click to Display Table of Contents >> Navigation: iVend Database Database > Tables > CusCustomerGroup Table |
Navigation: iVend Database Database > Tables >
iVend 6.6 Database Help
CusCustomerGroup Table
Collapse All Expand All
iVend Database Database : CusCustomerGroup Table |
Description
Defines the groups in which the customers can be catagorised.
Properties
Creation Date |
4/13/2015 12:00 PM |
File Group |
PRIMARY |
Text File Group |
|
System Object |
|
Published for Replication |
|
Rows |
1 |
Data Space Used |
8.00 KB |
Index Space Used |
8.00 KB |
Columns
|
Column Name |
Description |
Datatype |
Length |
Allow Nulls |
Default |
Formula |
CustomerGroupKey |
System generated Primary key of the table. |
VarWChar |
50 |
|
|
|
|
|
Id |
Refers to the Customer group's id. |
VarWChar |
20 |
|
|
|
|
Description |
Refers to the Customer group's description. |
VarWChar |
100 |
|
|
|
|
SalesTaxCodeKey |
Refers to the sales tax code key.See also Tax |
VarWChar |
50 |
|
|
|
|
Created |
Date of creation of this record |
DBTimeStamp |
4 |
|
|
|
|
CreatedBy |
Reference of user who has created this record. See also Security User |
VarWChar |
50 |
|
|
|
|
Modified |
Date of last modification of this record |
DBTimeStamp |
4 |
|
|
|
|
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 |
|
|
|
|
IsDefault |
The true value specifies that this Customer Group will be marked as the default Customer Group. After this while creating Customer this Customer Group will be populated as primary customer group. |
Boolean |
1 |
|
((0)) |
|
Indexes
Index |
Description |
Primary |
Unique |
|
Objects that depend on CusCustomerGroup
|
Database Object |
Object Type |
Description |
Dep Level |
Stored Procedure |
|
1 |
||
Stored Procedure |
|
1 |
||
User Defined Function |
|
1 |
||
Stored Procedure |
|
1 |
||
User Defined Function |
|
1 |
||
User Defined Function |
|
1 |
||
User Defined Function |
|
1 |
||
Stored Procedure |
|
1 |
||
View |
|
1 |
||
View |
|
1 |
||
View |
|
1 |
||
View |
|
1 |
SQL
SET ANSI_NULLS ON SET QUOTED_IDENTIFIER ON CREATE TABLE [dbo].[CusCustomerGroup]( [CustomerGroupKey] [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, [SalesTaxCodeKey] [nvarchar](50) COLLATE SQL_Latin1_General_CP1_CI_AS NULL, [Created] [datetime] NOT NULL, [CreatedBy] [nvarchar](50) COLLATE SQL_Latin1_General_CP1_CI_AS NOT NULL, [Modified] [datetime] NOT NULL, [ModifiedBy] [nvarchar](50) COLLATE SQL_Latin1_General_CP1_CI_AS NOT NULL, [IsDeleted] [bit] NOT NULL, [IsDefault] [bit] NOT NULL, CONSTRAINT [PK_CusCustomerGroup] PRIMARY KEY CLUSTERED ( [CustomerGroupKey] 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].[CusCustomerGroup] ADD CONSTRAINT [DF_CusCustomerGroup_IsDefault] DEFAULT ((0)) FOR [IsDefault] |
See Also
© 2019 All Rights Reserved.
Send comments on this topic.