Table: dbo.Vendor_Agent_Payment_Schedule
Columns
NameTypeConstraintsDescription
vendor_agent_payment_schedule_KEYint (4)NOT NULLTable primary key
descriptionnvarchar (60)NOT NULLDisplay text for payment schedule
Primary key
NameColumnsDescription
PK_Vendor_Agent_Payment_Schedulevendor_agent_payment_schedule_KEY
Unique constraints
NameColumnsDescription
UK_Vendor_Agent_Payment_Schedule$descriptiondescription
Incoming foreign keys
NameColumnsReferencing tableDescription
FK_Tax_Agent_N_Vendor_Agent_Payment_Schedule__Vendor_Agent_Payment_Schedule__vendor_agent_payment_schedule_KEYvendor_agent_payment_schedule_KEYTax_Agent_N_Vendor_Agent_Payment_Schedule
FK_Client_Tax_Item__Vendor_Agent_Payment_Schedule__vendor_agent_payment_schedule_KEYvendor_agent_payment_schedule_KEYClient_Tax_Item
FK_Vendor_Agent__Vendor_Agent_Payment_Schedule__vendor_agent_payment_schedule_KEYvendor_agent_payment_schedule_KEYVendor_Agent
FK_Vendor_Agent_Effective_Date__Vendor_Agent_Payment_Schedule__vendor_agent_payment_schedule_KEYvendor_agent_payment_schedule_KEYVendor_Agent_Effective_Date

Schema diagram