Table: dbo.Import_Template_Column
Parent record for user-defined Import Templates.
Columns
NameTypeConstraintsDescription
import_template_column_KEYint (4)NOT NULLPrimary key.
import_template_KEYint (4)NOT NULLParent record for the user defined Import Template
import_template_column_type_KEYint (4)NOT NULLParent record for the user defined Import Template_Column_Type
column_numberint (4)NOT NULL
Primary key
NameColumnsDescription
PK_Import_Template_Columnimport_template_column_KEY
Unique constraints
NameColumnsDescription
UK_Import_Template_Column$import_template_KEY$column_numberimport_template_KEY, column_number
Foreign keys
NameColumnsReferenced tableDescription
FK_Import_Template_Column__Import_Template__import_template_KEYimport_template_KEYImport_Template (import_template_KEY)
FK_Import_Template_Column__Import_Template_Column_Type__import_template_column_type_KEYimport_template_column_type_KEYImport_Template_Column_Type (import_template_column_type_KEY)
Incoming foreign keys
NameColumnsReferencing tableDescription
FK_Import_Template_Column_AR_Item_Data__Import_Template_Column__import_template_column_KEYimport_template_column_KEYImport_Template_Column_AR_Item_Data
FK_Import_Template_Column_Check_Number_Data__Import_Template_Column__import_template_column_KEYimport_template_column_KEYImport_Template_Column_Check_Number_Data
FK_Import_Template_Column_AR_Transaction_Item_Data__Import_Template_Column__import_template_column_KEYimport_template_column_KEYImport_Template_Column_AR_Transaction_Item_Data
FK_Import_Template_Column__import_template_column_KEYimport_template_column_KEYImport_Template_Column_1095C_Data
FK_Import_Template_Column_GL_Account_Data__Import_Template_Column__import_template_column_KEYimport_template_column_KEYImport_Template_Column_GL_Account_Data
FK_Import_Template_Column_Customer_Data__Import_Template_Column__import_template_column_KEYimport_template_column_KEYImport_Template_Column_Customer_Data
FK_Import_Template_Column_Vendor_Data__Import_Template_Column__import_template_column_KEYimport_template_column_KEYImport_Template_Column_Vendor_Data
FK_Import_Template_Column_Payroll_Item_Data__Import_Template_Column__import_template_column_KEYimport_template_column_KEYImport_Template_Column_Payroll_Item_Data
FK_Import_Template_Column_Employee_Data__Import_Template_Column__import_template_column_KEYimport_template_column_KEYImport_Template_Column_Employee_Data
FK_Import_Template_Column_Tax_Item_Data__Import_Template_Column__import_template_column_KEYimport_template_column_KEYImport_Template_Column_Tax_Item_Data

Schema diagram