Table: dbo.Import_Template_Column_Vendor_Data
This table stores information of user defined template columns for spreadsheet import of Vendor.
Columns
NameTypeConstraintsDescription
import_template_column_KEYint (4)NOT NULLPrimary key.
contact_phone_type_KEYint (4)NULL - When DirectDepositAllocationType is mapped but, Contact Type is not mapped.
direct_deposit_allocation_type_KEYint (4)NULL - When Contact Type is mapped but, DirectDepositAllocationType is not mapped.
Primary key
NameColumnsDescription
PK_Import_Template_Column_Vendor_Data$import_template_column_KEYimport_template_column_KEY
Foreign keys
NameColumnsReferenced tableDescription
FK_Import_Template_Column_Vendor_Data__Contact_Phone_Type__contact_phone_type_KEYcontact_phone_type_KEYContact_Phone_Type (contact_phone_type_KEY)
FK_Import_Template_Column_Vendor_Data__Import_Template_Column__import_template_column_KEYimport_template_column_KEYImport_Template_Column (import_template_column_KEY)
FK_Import_Template_Column_Vendor_Data__Spreadsheet_Import_Direct_Deposit_Allocation_Type__direct_deposit_allocation_type_KEYdirect_deposit_allocation_type_KEYSpreadsheet_Import_Direct_Deposit_Allocation_Type (spreadsheet_import_direct_deposit_allocation_type_KEY)

Schema diagram