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
NameTypeConstraintsDescription
import_template_column_KEYint (4)NOT NULLPrimary key for this table.
spreadsheet_import_ar_transaction_item_selection_KEYint (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_KEYint (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
NameColumnsDescription
PK_Import_Template_Column_AR_Transaction_Item_Data$import_template_column_KEYimport_template_column_KEY
Foreign keys
NameColumnsReferenced tableDescription
FK_Import_Template_Column_AR_Transaction_Item_Data__Import_Template_Column__import_template_column_KEYimport_template_column_KEYImport_Template_Column (import_template_column_KEY)
FK_Import_Template_Column_AR_Transaction_Item_Data__Spreadsheet_Import_AR_Transaction_Item_Selection__spreadsheet_import_ar_transpreadsheet_import_ar_transaction_item_selection_KEYSpreadsheet_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_imporspreadsheet_import_ar_transaction_shipping_item_selection_KEYSpreadsheet_Import_AR_Transaction_Shipping_Item_Selection (spreadsheet_import_ar_transaction_shipping_item_selection_KEY)

Schema diagram