Table: dbo.Import_Template_Column_AR_Item_Data
Specifies information about user defined template columns for spreadsheet import of invoice items. Only import template column rows of type Discount, Other Charge, Shipping, Sales Tax will have an associated rows in this table.
Columns
NameTypeConstraintsDescription
import_template_column_KEYint (4)NOT NULLPrimary key for this table.
spreadsheet_import_discount_other_charge_shipping_selection_KEYint (4)Specifies the key of selected option for import template column of type Discount/Other Charge/Shipping. NULL - when "Discount" or "Other Charge" or "Shipping" is not mapped but "Sales Tax" is mapped.
spreadsheet_import_sales_tax_selection_KEYint (4)Specifies the key of selected option for import template column of type Sales Tax. NULL - when "Sales Tax" is not mapped but "Discount" or "Other Charge" or "Shipping" is mapped.
Primary key
NameColumnsDescription
PK_Import_Template_Column_AR_Item_Data$import_template_column_KEYimport_template_column_KEY
Foreign keys
NameColumnsReferenced tableDescription
FK_Import_Template_Column_AR_Item_Data__Import_Template_Column__import_template_column_KEYimport_template_column_KEYImport_Template_Column (import_template_column_KEY)
FK_Import_Template_Column_AR_Item_Data__Spreadsheet_Import_Discount_Other_Charge_Shipping_Selection__spreadsheet_import_discountspreadsheet_import_discount_other_charge_shipping_selection_KEYSpreadsheet_Import_Discount_Other_Charge_Shipping_Selection (spreadsheet_import_discount_other_charge_shipping_selection_KEY)
FK_Import_Template_Column_AR_Item_Data__Spreadsheet_Import_Sales_Tax_Selection__spreadsheet_import_sales_tax_selection_KEYspreadsheet_import_sales_tax_selection_KEYSpreadsheet_Import_Sales_Tax_Selection (spreadsheet_import_sales_tax_selection_KEY)

Schema diagram