Table: dbo.Spreadsheet_Import_Taxing_Authority | |||
Specifies mapping data for sales tax descriptions. | |||
Columns | |||
Name | Type | Constraints | Description |
spreadsheet_import_taxing_authority_KEY | int (4) | NOT NULL | Primary key for this table. |
client_KEY | int (4) | NOT NULL | Key of the client for which we are importing spreadsheet data. |
description | nvarchar (318) | NOT NULL | User friendly name for sales tax description. |
is_interim_data | bit (1) | NOT NULL | Specifies whether the sales tax description is part of interim data or not. |
taxing_authority_KEY | int (4) | Accounting CS taxing authority to which the spreadsheet sales tax description is mapped. NULL value indicates that the spreadsheet sales tax description mapped to "Do not import". |
Primary key | |||
Name | Columns | Description | |
PK_Spreadsheet_Import_Taxing_Authority | spreadsheet_import_taxing_authority_KEY | ||
Unique constraints | |||
Name | Columns | Description | |
UK_Spreadsheet_Import_Taxing_Authority$client_KEY$description | client_KEY, description |
Foreign keys | |||
Name | Columns | Referenced table | Description |
FK_Spreadsheet_Import_Taxing_Authority__Client__client_KEY | client_KEY | Client (client_KEY) | |
FK_Spreadsheet_Import_Taxing_Authority__Taxing_Authority__taxing_authority_KEY | taxing_authority_KEY | Taxing_Authority (taxing_authority_KEY) |