Table: dbo.Spreadsheet_Import_Discount_Other_Charge_Shipping_Selection
Specifies column options for invoice item of type "Discount" or "Other Charge" or "Shipping"
Columns
NameTypeConstraintsDescription
spreadsheet_import_discount_other_charge_shipping_selection_KEYint (4)NOT NULLPrimary key for this table.
descriptionnvarchar (60)NOT NULLUser friendly name for invoice 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_Discount_Other_Charge_Shipping_Selectionspreadsheet_import_discount_other_charge_shipping_selection_KEY
Unique constraints
NameColumnsDescription
UK_Spreadsheet_Import_Discount_Other_Charge_Shipping_Selection$descriptiondescription
UK_Spreadsheet_Import_Discount_Other_Charge_Shipping_Selection$sequence_numbersequence_number
Incoming foreign keys
NameColumnsReferencing tableDescription
FK_Import_Template_Column_AR_Item_Data__Spreadsheet_Import_Discount_Other_Charge_Shipping_Selection__spreadsheet_import_discountspreadsheet_import_discount_other_charge_shipping_selection_KEYImport_Template_Column_AR_Item_Data

Schema diagram