This table is used to stage incoming Ultra Tax tax codes before they are merged into the global and client Ultra Tax tax codes. |
ultra_tax_staged_tax_code_KEY | int (4) | NOT NULL | Primary Key |
code_year | int (4) | NOT NULL | Year this tax code is for |
tax_code | nvarchar (10) | NOT NULL | Ultra Tax tax code |
ultra_tax_entity_type_KEY | int (4) | NOT NULL | Entity type this tax code is for |
ultra_tax_category_type_KEY | int (4) | NOT NULL | Tax code category; Standard, Puerto Rico, M3A, M3B, M3C, ALL |
description | nvarchar (100) | NOT NULL | Ultra Tax tax code form line and description concatenated |
gl_account_type_KEY | int (4) | | Account type; A, L, E, R for entity types 1120, 1120S and 1065, otherwise NULL. |