Table: dbo.Import_Template_Column_Customer_Data
This table stores information of user defined template columns for spreadsheet import of customer.
Columns
NameTypeConstraintsDescription
import_template_column_KEYint (4)NOT NULLPrimary key.
contact_phone_type_KEYint (4)NULL - When Phone is not mapped but, When Phone Fax is mapped
contact_phone_is_extensionbit (1)NOT NULL1 - When the Phone is extension and 0 - When Phone is mapped and Phone is not extension or When Phone is not mapped but, Phone Fax is mapped
phone_fax_is_extensionbit (1)NOT NULL1 - When the Phone Fax is Extension and 0 - When Phone Fax is mapped and Phone Fax is not extension or When Phone Fax is not mapped but, Phone is mapped
Primary key
NameColumnsDescription
PK_Import_Template_Column_Customer_Data$import_template_column_KEYimport_template_column_KEY
Foreign keys
NameColumnsReferenced tableDescription
FK_Import_Template_Column_Customer_Data__Contact_Phone_Type__contact_phone_type_KEYcontact_phone_type_KEYContact_Phone_Type (contact_phone_type_KEY)
FK_Import_Template_Column_Customer_Data__Import_Template_Column__import_template_column_KEYimport_template_column_KEYImport_Template_Column (import_template_column_KEY)

Schema diagram