| Table: dbo.Tax_Code | |||
| Complete set of Ultra Tax and Custom Tax codes for a client | |||
| Columns | |||
| Name | Type | Constraints | Description |
| tax_code_KEY | int (4) | NOT NULL | Primary Key |
| client_KEY | int (4) | Client these tax codes are for. Null value indicates a global template used when creating a new client | |
| tax_code | nvarchar (10) | NOT NULL | Ultra Tax tax code |
| tax_subcode | nvarchar (4) | NOT NULL | User entered custom tax code |
| tax_code_guid | uniqueidentifier (16) | NOT NULL | A unique GUID key for this row. |
| Primary key | |||
| Name | Columns | Description | |
| PK_Tax_Code | tax_code_KEY | ||
| Unique constraints | |||
| Name | Columns | Description | |
| UK_Tax_Code$client_KEY$tax_code$tax_subcode | client_KEY, tax_code, tax_subcode | ||
| UK_Tax_Code$tax_code_guid | tax_code_guid | ||
| Foreign keys | |||
| Name | Columns | Referenced table | Description |
| FK_Tax_Code__Client__client_KEY | client_KEY | Client (client_KEY) | |