The purpose of this table is to map customers imported via the spreadsheet import process to AR customer�s already existing in the database. |
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. |