Table: dbo.Client_1099_State_Override
The table used to store the overrides for a Client's state id numbers.
Columns
Name | Type | Constraints | Description
client_1099_state_override_KEY | int (4) | NOT NULL | Primary key.
client_KEY | int (4) | NOT NULL | Foreign key into the client table.
ste_state_code_KEY | nvarchar (4) | NOT NULL | Foreign key into the Ste state code table.
state_id_number | nvarchar (50) | NOT NULL | The override for the client's state id.
client_1099_state_override_type_KEY | int (4) | NOT NULL | The type of override.

Primary key
Name | Columns | Description
PK_Client_1099_State_Override | client_1099_state_override_KEY |
Unique constraints
Name | Columns | Description
UK_Client_1099_State_Override$client_KEY$ste_state_code_KEY | client_KEY, ste_state_code_KEY |

Foreign keys
Name | Columns | Referenced table | Description
FK_Client_1099_State_Override__Client__client_KEY | client_KEY | Client (client_KEY) |
FK_Client_1099_State_Override__Client_1099_State_Override_Type__client_1099_state_override_type_KEY | client_1099_state_override_type_KEY | Client_1099_State_Override_Type (client_1099_state_override_type_KEY) |
FK_Client_1099_State_Override__Ste_State_Code__ste_state_code_KEY | ste_state_code_KEY | Ste_State_Code (ste_state_code_KEY) |