Table: dbo.Tax_Code_Type | |||
This table stores the various tax code types in the system that serve as tax categories. This table also stores the FAKE tax code types. Those FAKEs are added in to serve as placeholders that signify multiple tax code types and the multiple types are defined in the code. Local_Tax_Exemption_Type basically has a one to one relationship with Tax_Code_Type in the database and for certain exemption selections this needs to be one-to-many and the FAKEs allow the many to be specified in the code. | |||
Columns | |||
Name | Type | Constraints | Description |
tax_code_type_KEY | int (4) | NOT NULL | Primary key for this table |
tax_code | nvarchar (20) | NOT NULL | Tax code |
description | nvarchar (100) | NOT NULL | Description |
long_description | nvarchar (100) | NOT NULL | Long description |
Primary key | |||
Name | Columns | Description | |
PK_Tax_Code_Type | tax_code_type_KEY |