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
Name | Type | Constraints | Description
tax_agent_n_vendor_agent_payment_schedule_KEY | int (4) | NOT NULL | Primary key for this table
tax_agent_KEY | int (4) | NOT NULL | Key to associated table Tax_Agent
vendor_agent_payment_schedule_KEY | int (4) | NOT NULL | Key to associated table Vendor_Agent_Payment_Schedule
payment_month_or_offset | int (4) | NOT NULL | Indicates either month of the year or an offset, depending on the payment schedule
liability_amount | decimal (9, 2) | NOT NULL | Liability amount used for amount due scheduling
vendor_agent_liability_source_KEY | int (4) | NOT NULL | Source used when liability amount determines payment due dates
vendor_agent_due_date_adjustment_KEY | int (4) | NOT NULL | Due date adjustment for for non-banking days
is_default_payment_schedule | bit (1) | NOT NULL | Is this payment schedule the default for this tax agent?
payment_day_of_period | int (4) | NOT NULL | Indicates the day of the period -- e.g., 5 for the fifth day of the month; defaults to first day of month
payment_day_offset | int (4) | NOT NULL | Indicates the number of days to add when calculating -- e.g., 3 for three business days after the calculated period end

Primary key
Name | Columns | Description
PK_Tax_Agent_N_Vendor_Agent_Payment_Schedule | tax_agent_n_vendor_agent_payment_schedule_KEY |
Unique constraints
Name | Columns | Description
UK_Tax_Agent_N_Vendor_Agent_Payment_Schedule$tax_agent_KEY$vendor_agent_payment_schedule_KEY | tax_agent_KEY, vendor_agent_payment_schedule_KEY |

Foreign keys
Name | Columns | Referenced table | Description
FK_Tax_Agent_N_Vendor_Agent_Payment_Schedule__Tax_Agent__tax_agent_KEY | tax_agent_KEY | Tax_Agent (tax_agent_KEY) |
FK_Tax_Agent_N_Vendor_Agent_Payment_Schedule__Vendor_Agent_Due_Date_Adjustment__vendor_agent_due_date_adjustment_KEY | vendor_agent_due_date_adjustment_KEY | Vendor_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_KEY | vendor_agent_liability_source_KEY | Vendor_Agent_Liability_Source (vendor_agent_liability_source_KEY) |
FK_Tax_Agent_N_Vendor_Agent_Payment_Schedule__Vendor_Agent_Payment_Schedule__vendor_agent_payment_schedule_KEY | vendor_agent_payment_schedule_KEY | Vendor_Agent_Payment_Schedule (vendor_agent_payment_schedule_KEY) |

Incoming foreign keys
Name | Columns | Referencing table | Description
FK_Tax_Agent_State_Local_Tax_Type_Code__Tax_Agent_N_Vendor_Agent_Payment_Schedule__tax_agent_n_vendor_agent_payment_schedule_KEY | tax_agent_n_vendor_agent_payment_schedule_KEY | Tax_Agent_State_Local_Tax_Type_Code |