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
Name | Type | Constraints | Description
spreadsheet_import_customer_KEY | int (4) | NOT NULL | Key which uniquely identify each row of the table.
client_KEY | int (4) | NOT NULL | Key of the client for which we are importing the spreadsheet data.
id | nvarchar (318) | NOT NULL | An 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_data | bit (1) | NOT NULL | When 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_KEY | int (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
Name | Columns | Description
PK_Spreadsheet_Import_Customer | spreadsheet_import_customer_KEY |
Unique constraints
Name | Columns | Description
UK_Spreadsheet_Import_Customer$client_KEY$id | client_KEY, id |

Foreign keys
Name | Columns | Referenced table | Description
FK_Spreadsheet_Import_Customer__Client__client_KEY | client_KEY | Client (client_KEY) |
FK_Spreadsheet_Import_Customer__Customer__customer_KEY | customer_KEY | Customer (customer_KEY) |