Table: dbo.Client_1099_State_Override
The table used to store the overrides for a Client's state id numbers.
Columns
NameTypeConstraintsDescription
client_1099_state_override_KEYint (4)NOT NULLPrimary key.
client_KEYint (4)NOT NULLForeign key into the client table.
ste_state_code_KEYnvarchar (4)NOT NULLForeign key into the Ste state code table.
state_id_numbernvarchar (50)NOT NULLThe override for the client's state id.
client_1099_state_override_type_KEYint (4)NOT NULLThe type of override.
Primary key
NameColumnsDescription
PK_Client_1099_State_Overrideclient_1099_state_override_KEY
Unique constraints
NameColumnsDescription
UK_Client_1099_State_Override$client_KEY$ste_state_code_KEYclient_KEY, ste_state_code_KEY
Foreign keys
NameColumnsReferenced tableDescription
FK_Client_1099_State_Override__Client__client_KEYclient_KEYClient (client_KEY)
FK_Client_1099_State_Override__Client_1099_State_Override_Type__client_1099_state_override_type_KEYclient_1099_state_override_type_KEYClient_1099_State_Override_Type (client_1099_state_override_type_KEY)
FK_Client_1099_State_Override__Ste_State_Code__ste_state_code_KEYste_state_code_KEYSte_State_Code (ste_state_code_KEY)

Schema diagram