Table: dbo.Import_Template_Column_Customer_Data
This table stores information of user defined template columns for spreadsheet import of customer.
Columns
Name | Type | Constraints | Description
import_template_column_KEY | int (4) | NOT NULL | Primary key.
contact_phone_type_KEY | int (4) |  | NULL - When Phone is not mapped but, When Phone Fax is mapped
contact_phone_is_extension | bit (1) | NOT NULL | 1 - 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_extension | bit (1) | NOT NULL | 1 - 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
Name | Columns | Description
PK_Import_Template_Column_Customer_Data$import_template_column_KEY | import_template_column_KEY |

Foreign keys
Name | Columns | Referenced table | Description
FK_Import_Template_Column_Customer_Data__Contact_Phone_Type__contact_phone_type_KEY | contact_phone_type_KEY | Contact_Phone_Type (contact_phone_type_KEY) |
FK_Import_Template_Column_Customer_Data__Import_Template_Column__import_template_column_KEY | import_template_column_KEY | Import_Template_Column (import_template_column_KEY) |