Table: dbo.Import_Template_Column_Vendor_Data
This table stores information of user defined template columns for spreadsheet import of Vendor.
Columns
Name | Type | Constraints | Description
import_template_column_KEY | int (4) | NOT NULL | Primary key.
contact_phone_type_KEY | int (4) |  | NULL - When DirectDepositAllocationType is mapped but, Contact Type is not mapped.
direct_deposit_allocation_type_KEY | int (4) |  | NULL - When Contact Type is mapped but, DirectDepositAllocationType is not mapped.

Primary key
Name | Columns | Description
PK_Import_Template_Column_Vendor_Data$import_template_column_KEY | import_template_column_KEY |

Foreign keys
Name | Columns | Referenced table | Description
FK_Import_Template_Column_Vendor_Data__Contact_Phone_Type__contact_phone_type_KEY | contact_phone_type_KEY | Contact_Phone_Type (contact_phone_type_KEY) |
FK_Import_Template_Column_Vendor_Data__Import_Template_Column__import_template_column_KEY | import_template_column_KEY | Import_Template_Column (import_template_column_KEY) |
FK_Import_Template_Column_Vendor_Data__Spreadsheet_Import_Direct_Deposit_Allocation_Type__direct_deposit_allocation_type_KEY | direct_deposit_allocation_type_KEY | Spreadsheet_Import_Direct_Deposit_Allocation_Type (spreadsheet_import_direct_deposit_allocation_type_KEY) |