Table: dbo.Spreadsheet_Import_Customer
The purpose of this table is to map customers imported via the spreadsheet import process to AR customer�s already existing in the database.
Columns
NameTypeConstraintsDescription
spreadsheet_import_customer_KEYint (4)NOT NULLKey which uniquely identify each row of the table.
client_KEYint (4)NOT NULLKey of the client for which we are importing the spreadsheet data.
idnvarchar (318)NOT NULLAn external id which uniquely identifies a customer in the data source being imported. This id will be compared with the combination of customer ID and customer name when trying to find a match with an existing customer in the database.
is_interim_databit (1)NOT NULLWhen 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.
customer_KEYint (4)customer_KEY of ACS Customer table to which the spreadsheet customer is mapped. Null value indicates that the spreadsheet value mapped to Do not import.
Primary key
NameColumnsDescription
PK_Spreadsheet_Import_Customerspreadsheet_import_customer_KEY
Unique constraints
NameColumnsDescription
UK_Spreadsheet_Import_Customer$client_KEY$idclient_KEY, id
Foreign keys
NameColumnsReferenced tableDescription
FK_Spreadsheet_Import_Customer__Client__client_KEYclient_KEYClient (client_KEY)
FK_Spreadsheet_Import_Customer__Customer__customer_KEYcustomer_KEYCustomer (customer_KEY)

Schema diagram