Table: dbo.Spreadsheet_Import_Taxing_Authority
Specifies mapping data for sales tax descriptions.
Columns
NameTypeConstraintsDescription
spreadsheet_import_taxing_authority_KEYint (4)NOT NULLPrimary key for this table.
client_KEYint (4)NOT NULLKey of the client for which we are importing spreadsheet data.
descriptionnvarchar (318)NOT NULLUser friendly name for sales tax description.
is_interim_databit (1)NOT NULLSpecifies whether the sales tax description is part of interim data or not.
taxing_authority_KEYint (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
NameColumnsDescription
PK_Spreadsheet_Import_Taxing_Authorityspreadsheet_import_taxing_authority_KEY
Unique constraints
NameColumnsDescription
UK_Spreadsheet_Import_Taxing_Authority$client_KEY$descriptionclient_KEY, description
Foreign keys
NameColumnsReferenced tableDescription
FK_Spreadsheet_Import_Taxing_Authority__Client__client_KEYclient_KEYClient (client_KEY)
FK_Spreadsheet_Import_Taxing_Authority__Taxing_Authority__taxing_authority_KEYtaxing_authority_KEYTaxing_Authority (taxing_authority_KEY)

Schema diagram