Table to store the mapping data information of chart of accounts for spreadsheet import. |
spreadsheet_import_account_KEY | int (4) | NOT NULL | Key which uniquely identify each row of the table. |
client_KEY | int (4) | NOT NULL | Client key for which we are importing the spreadsheet data. |
account_number | nvarchar (120) | NOT NULL | Account number provided in the spread sheet. |
description | nvarchar (318) | NOT NULL | Description for the account number. |
sequence_number | int (4) | NOT NULL | account sort order for the accont number. |
is_interim_data | bit (1) | NOT NULL | When 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. |
gl_account_KEY | int (4) | | gl_account_key of GL_Account table to which the account number in the spreadsheet is mapped to,a null value indicates that it was mapped as Do not import. |
import_template_type_KEY | int (4) | NOT NULL | SS Import type key for which we are importing the spreadsheet data |