| 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) | |