Table: dbo.Tax_Agent_N_Vendor_Agent_Payment_Schedule
Table to store all selected payment schedules for a particular tax agent along with a set of options for each payment schedule
Columns
NameTypeConstraintsDescription
tax_agent_n_vendor_agent_payment_schedule_KEYint (4)NOT NULLPrimary key for this table
tax_agent_KEYint (4)NOT NULLKey to associated table Tax_Agent
vendor_agent_payment_schedule_KEYint (4)NOT NULLKey to associated table Vendor_Agent_Payment_Schedule
payment_month_or_offsetint (4)NOT NULLIndicates either month of the year or an offset, depending on the payment schedule
liability_amountdecimal (9, 2)NOT NULLLiability amount used for amount due scheduling
vendor_agent_liability_source_KEYint (4)NOT NULLSource used when liability amount determines payment due dates
vendor_agent_due_date_adjustment_KEYint (4)NOT NULLDue date adjustment for for non-banking days
is_default_payment_schedulebit (1)NOT NULLIs this payment schedule the default for this tax agent?
payment_day_of_periodint (4)NOT NULLIndicates the day of the period -- e.g., 5 for the fifth day of the month; defaults to first day of month
payment_day_offsetint (4)NOT NULLIndicates the number of days to add when calculating -- e.g., 3 for three business days after the calculated period end
Primary key
NameColumnsDescription
PK_Tax_Agent_N_Vendor_Agent_Payment_Scheduletax_agent_n_vendor_agent_payment_schedule_KEY
Unique constraints
NameColumnsDescription
UK_Tax_Agent_N_Vendor_Agent_Payment_Schedule$tax_agent_KEY$vendor_agent_payment_schedule_KEYtax_agent_KEY, vendor_agent_payment_schedule_KEY
Foreign keys
NameColumnsReferenced tableDescription
FK_Tax_Agent_N_Vendor_Agent_Payment_Schedule__Tax_Agent__tax_agent_KEYtax_agent_KEYTax_Agent (tax_agent_KEY)
FK_Tax_Agent_N_Vendor_Agent_Payment_Schedule__Vendor_Agent_Due_Date_Adjustment__vendor_agent_due_date_adjustment_KEYvendor_agent_due_date_adjustment_KEYVendor_Agent_Due_Date_Adjustment (vendor_agent_due_date_adjustment_KEY)
FK_Tax_Agent_N_Vendor_Agent_Payment_Schedule__Vendor_Agent_Liability_Source__vendor_agent_liability_source_KEYvendor_agent_liability_source_KEYVendor_Agent_Liability_Source (vendor_agent_liability_source_KEY)
FK_Tax_Agent_N_Vendor_Agent_Payment_Schedule__Vendor_Agent_Payment_Schedule__vendor_agent_payment_schedule_KEYvendor_agent_payment_schedule_KEYVendor_Agent_Payment_Schedule (vendor_agent_payment_schedule_KEY)
Incoming foreign keys
NameColumnsReferencing tableDescription
FK_Tax_Agent_State_Local_Tax_Type_Code__Tax_Agent_N_Vendor_Agent_Payment_Schedule__tax_agent_n_vendor_agent_payment_schedule_KEYtax_agent_n_vendor_agent_payment_schedule_KEYTax_Agent_State_Local_Tax_Type_Code

Schema diagram