This table stores information of user defined template columns for spreadsheet import of customer. |
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 |