Navigation: iVend Database Database > Tables >
iVend 6.6 Database Help
CfgContact Table
Collapse All Expand All
iVend Database Database : CfgContact Table |
Description
Defines the contact details that are saved against any address
Properties
Creation Date |
4/13/2015 12:00 PM |
File Group |
PRIMARY |
Text File Group |
|
System Object |
|
Published for Replication |
|
Rows |
2 |
Data Space Used |
8.00 KB |
Index Space Used |
8.00 KB |
Columns
|
Column Name |
Description |
Datatype |
Length |
Allow Nulls |
Default |
Formula |
|
ContactKey |
Primary Key |
VarWChar |
50 |
|
|
|
|
FirstName |
Refers to the first name |
VarWChar |
100 |
|
|
|
|
MiddleName |
Refers to the middle name |
VarWChar |
50 |
|
|
|
|
LastName |
Refers to the last name |
VarWChar |
50 |
|
|
|
|
Title |
Refers to the title of the contact |
VarWChar |
50 |
|
|
|
|
Salutation |
Refers to the salutation of the contact |
VarWChar |
50 |
|
|
|
|
NickName |
Refers to the nick name of the contact |
VarWChar |
50 |
|
|
|
|
Phone1 |
Refers to the phone number of the contact |
VarWChar |
50 |
|
|
|
|
Phone2 |
Refers to the alternate phone number of the contact |
VarWChar |
50 |
|
|
|
|
MobilePhone |
Refers to the mobile phone number of the contact |
VarWChar |
50 |
|
|
|
|
Fax |
Refers to the fax number of the contact |
VarWChar |
50 |
|
|
|
|
Refers to the email of the contact |
VarWChar |
100 |
|
|
|
|
|
Pager |
Refers to the pager number of the contact |
VarWChar |
50 |
|
|
|
|
Comment1 |
Refers to the comment details |
VarWChar |
255 |
|
|
|
|
Comment2 |
Refers to the comment details |
VarWChar |
255 |
|
|
|
|
CanPayOnAccount |
Flag to check whether this contact can pay on account or not |
Boolean |
1 |
|
|
|
|
CanPayWithCredit |
Flag to check whether this contact can pay with credit card or not |
Boolean |
1 |
|
|
|
|
SignatureKey |
For future use |
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 |
|
|
|
|
SalesTaxCodeKey |
Reference Key for the Sales Tax |
VarWChar |
50 |
|
((0)) |
|
|
ContactDiscount |
Refers to contact discount |
Numeric |
9 (20,5) |
|
((0.00)) |
|
|
Gender |
Specify the Gender of Contact (Male / Female) |
VarWChar |
50 |
|
|
|
|
Profession |
Stores the contact's Profession |
VarWChar |
50 |
|
|
|
|
BirthDate |
Stores the contact's Birth Date. |
DBTimeStamp |
4 |
|
|
|
|
BirthCity |
Stores the contact's Birth City |
VarWChar |
100 |
|
|
|
|
CountryKey |
Stores the contact's Birth Country. |
VarWChar |
50 |
|
|
|
Indexes
Index |
Description |
Primary |
Unique |
|
|
|
SQL
SET ANSI_NULLS ON SET QUOTED_IDENTIFIER ON CREATE TABLE [dbo].[CfgContact]( [ContactKey] [nvarchar](50) COLLATE SQL_Latin1_General_CP1_CI_AS NOT NULL, [FirstName] [nvarchar](100) COLLATE SQL_Latin1_General_CP1_CI_AS NOT NULL, [MiddleName] [nvarchar](50) COLLATE SQL_Latin1_General_CP1_CI_AS NULL, [LastName] [nvarchar](50) COLLATE SQL_Latin1_General_CP1_CI_AS NULL, [Title] [nvarchar](50) COLLATE SQL_Latin1_General_CP1_CI_AS NULL, [Salutation] [nvarchar](50) COLLATE SQL_Latin1_General_CP1_CI_AS NULL, [NickName] [nvarchar](50) COLLATE SQL_Latin1_General_CP1_CI_AS NULL, [Phone1] [nvarchar](50) COLLATE SQL_Latin1_General_CP1_CI_AS NOT NULL, [Phone2] [nvarchar](50) COLLATE SQL_Latin1_General_CP1_CI_AS NULL, [MobilePhone] [nvarchar](50) COLLATE SQL_Latin1_General_CP1_CI_AS NULL, [Fax] [nvarchar](50) COLLATE SQL_Latin1_General_CP1_CI_AS NULL, [Email] [nvarchar](100) COLLATE SQL_Latin1_General_CP1_CI_AS NULL, [Pager] [nvarchar](50) COLLATE SQL_Latin1_General_CP1_CI_AS NULL, [Comment1] [nvarchar](255) COLLATE SQL_Latin1_General_CP1_CI_AS NULL, [Comment2] [nvarchar](255) COLLATE SQL_Latin1_General_CP1_CI_AS NULL, [CanPayOnAccount] [bit] NOT NULL, [CanPayWithCredit] [bit] NOT NULL, [SignatureKey] [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, [SalesTaxCodeKey] [nvarchar](50) COLLATE SQL_Latin1_General_CP1_CI_AS NOT NULL, [ContactDiscount] [decimal](20, 5) NOT NULL, [Gender] [nvarchar](50) COLLATE SQL_Latin1_General_CP1_CI_AS NULL, [Profession] [nvarchar](50) COLLATE SQL_Latin1_General_CP1_CI_AS NULL, [BirthDate] [datetime] NULL, [BirthCity] [nvarchar](100) COLLATE SQL_Latin1_General_CP1_CI_AS NULL, [CountryKey] [nvarchar](50) COLLATE SQL_Latin1_General_CP1_CI_AS NULL, CONSTRAINT [PK_CfgContact] PRIMARY KEY CLUSTERED ( [ContactKey] 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].[CfgContact] ADD CONSTRAINT [DF_CfgContact_SalesTaxCodeKey] DEFAULT ((0)) FOR [SalesTaxCodeKey] ALTER TABLE [dbo].[CfgContact] ADD CONSTRAINT [DF_CfgContact_ContactDiscount] DEFAULT ((0.00)) FOR [ContactDiscount] |
See Also
Related Objects
© 2019 All Rights Reserved.
Send comments on this topic.