Table: dbo.Import_Template_Column_AR_Transaction_Item_Data
Specifies information about user defined template columns for spreadsheet import of AR Transactions invoice items. Only import template column rows of type Item, Shipping 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_ar_transaction_item_selection_KEY | int (4) |  | Specifies the key of selected option for import template column of type Item. NULL - when "Item" is not mapped but "Shipping" is mapped.
spreadsheet_import_ar_transaction_shipping_item_selection_KEY | int (4) |  | Specifies the key of selected option for import template column of type Shipping. NULL - when "Shipping" is not mapped but "Item" is mapped.

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

Foreign keys
Name | Columns | Referenced table | Description
FK_Import_Template_Column_AR_Transaction_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_Transaction_Item_Data__Spreadsheet_Import_AR_Transaction_Item_Selection__spreadsheet_import_ar_tran | spreadsheet_import_ar_transaction_item_selection_KEY | Spreadsheet_Import_AR_Transaction_Item_Selection (spreadsheet_import_ar_transaction_item_selection_KEY) |
FK_Import_Template_Column_AR_Transaction_Item_Data__Spreadsheet_Import_AR_Transaction_Shipping_Item_Selection__spreadsheet_impor | spreadsheet_import_ar_transaction_shipping_item_selection_KEY | Spreadsheet_Import_AR_Transaction_Shipping_Item_Selection (spreadsheet_import_ar_transaction_shipping_item_selection_KEY) |