Table: dbo.State_Local_Amount_Code_Type
Columns
NameTypeConstraintsDescription
state_local_amount_code_type_KEYint (4)NOT NULLPrimary Key
state_local_amount_codenvarchar (4)NOT NULLState/Local Amount Code - used for Vendor Electronic payments.
descriptionnvarchar (30)NOT NULLRelated description for user.
Primary key
NameColumnsDescription
PK_State_Local_Amount_Code_Typestate_local_amount_code_type_KEY
Unique constraints
NameColumnsDescription
UK_State_Local_Amount_Code_Type$state_local_amount_codestate_local_amount_code
Incoming foreign keys
NameColumnsReferencing tableDescription
FK_Tax_Agent_Direct_Deposit_Tax_Payment_Information__State_Local_Amount_Code_Type__code_1__state_local_amount_code_type_KEYcode_1__state_local_amount_code_type_KEYTax_Agent_Direct_Deposit_Tax_Payment_Information
FK_Tax_Agent_Direct_Deposit_Tax_Payment_Information__State_Local_Amount_Code_Type__code_2__state_local_amount_code_type_KEYcode_2__state_local_amount_code_type_KEYTax_Agent_Direct_Deposit_Tax_Payment_Information
FK_Tax_Agent_Direct_Deposit_Tax_Payment_Information__State_Local_Amount_Code_Type__code_3__state_local_amount_code_type_KEYcode_3__state_local_amount_code_type_KEYTax_Agent_Direct_Deposit_Tax_Payment_Information

Schema diagram