Table: dbo.Spreadsheet_Import_AR_Transaction_Item_Selection
Specifies column options for AR transaction invoice items of type Item.
Columns
NameTypeConstraintsDescription
spreadsheet_import_ar_transaction_item_selection_KEYint (4)NOT NULLPrimary key for this table.
descriptionnvarchar (100)NOT NULLUser friendly name for AR item import column option.
sequence_numberint (4)NOT NULLSequence in which the column options to be displayed to the user.
Primary key
NameColumnsDescription
PK_Spreadsheet_Import_AR_Transaction_Item_Selectionspreadsheet_import_ar_transaction_item_selection_KEY
Unique constraints
NameColumnsDescription
UK_Spreadsheet_Import_AR_Transaction_Item_Selection$descriptiondescription
UK_Spreadsheet_Import_AR_Transaction_Item_Selection$sequence_numbersequence_number
Incoming foreign keys
NameColumnsReferencing tableDescription
FK_Import_Template_Column_AR_Transaction_Item_Data__Spreadsheet_Import_AR_Transaction_Item_Selection__spreadsheet_import_ar_transpreadsheet_import_ar_transaction_item_selection_KEYImport_Template_Column_AR_Transaction_Item_Data

Schema diagram