Table: dbo.Spreadsheet_Import_Payment_Term
Table to store the mapping data information of payment terms for spreadsheet import.
Columns
NameTypeConstraintsDescription
spreadsheet_import_payment_term_KEYint (4)NOT NULLKey which uniquely identify each row of the table.
client_KEYint (4)NOT NULLClient key for which we are importing the spreadsheet data.
idnvarchar (318)NOT NULLExternal id which is used to match to an existing payment term id, else to a payment term description when trying to find a match
is_interim_databit (1)NOT NULLWhen the user cancels the import process,the data mapped till that point has to be saved and presented to the user when he starts the import next time.For such mapping data we set the value of this column to true.
payment_term_KEYint (4)payment_term_KEY of Payment_Term table to which the payment term description in the spreadsheet is mapped to,a null value indicates that it was mapped as Do not import.
Primary key
NameColumnsDescription
PK_Spreadsheet_Import_Payment_Termspreadsheet_import_payment_term_KEY
Unique constraints
NameColumnsDescription
UK_Spreadsheet_Import_Payment_Term$client_KEY$idclient_KEY, id
Foreign keys
NameColumnsReferenced tableDescription
FK_Spreadsheet_Import_Payment_Term__Client__client_KEYclient_KEYClient (client_KEY)
FK_Spreadsheet_Import_Payment_Term__Payment_Term__payment_term_KEYpayment_term_KEYPayment_Term (payment_term_KEY)

Schema diagram