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
Name | Type | Constraints | Description
import_template_column_KEY | int (4) | NOT NULL | Primary key for this table.
spreadsheet_import_discount_other_charge_shipping_selection_KEY | int (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_KEY | int (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
Name | Columns | Description
PK_Import_Template_Column_AR_Item_Data$import_template_column_KEY | import_template_column_KEY |

Foreign keys
Name | Columns | Referenced table | Description
FK_Import_Template_Column_AR_Item_Data__Import_Template_Column__import_template_column_KEY | import_template_column_KEY | Import_Template_Column (import_template_column_KEY) |
FK_Import_Template_Column_AR_Item_Data__Spreadsheet_Import_Discount_Other_Charge_Shipping_Selection__spreadsheet_import_discount | spreadsheet_import_discount_other_charge_shipping_selection_KEY | Spreadsheet_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_KEY | spreadsheet_import_sales_tax_selection_KEY | Spreadsheet_Import_Sales_Tax_Selection (spreadsheet_import_sales_tax_selection_KEY) |