Table: dbo.Vendor_Agent_Effective_Date
This table will essentialy hold duplicate information from the Vendor_Agent table, and will be used as temp table while areas of the code are changed for the Effective Date for Deposit Schedules project.
Columns
NameTypeConstraintsDescription
vendor_agent_effective_date_KEYint (4)NOT NULLPrimary key for this table.
vendor_KEYint (4)NOT NULLForeign key for this table that references a vendor.
vendor_agent_payment_schedule_KEYint (4)Payment schedule.
vendor_agent_effective_date_for_deposit_schedulesdate (3)NOT NULLDate that determines when the pay schedule changes.
vendor_agent_due_date_adjustment_KEYint (4)Due date adjustment for for non-banking days
liability_amountdecimal (9, 2)Liability amount used for amount due scheduling.
vendor_agent_liability_source_KEYint (4)Foreign key for this table that references a vendor agent liability source.
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
payment_month_or_offsetint (4)Indicates either month of the year or an offset, depending on the payment schedule
Primary key
NameColumnsDescription
PK_Vendor_Agent_Effective_Datevendor_agent_effective_date_KEY
Foreign keys
NameColumnsReferenced tableDescription
FK_Vendor_Agent_Effective_Date__Vendor__vendor_KEYvendor_KEYVendor (vendor_KEY)
FK_Vendor_Agent_Effective_Date__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_Vendor_Agent_Effective_Date__Vendor_Agent_Payment_Schedule__vendor_agent_payment_schedule_KEYvendor_agent_payment_schedule_KEYVendor_Agent_Payment_Schedule (vendor_agent_payment_schedule_KEY)
FK_Vendor_Agent_Effective_Date__Vendor_Agent_Liability_Source__vendor_agent_liability_source_KEYvendor_agent_liability_source_KEYVendor_Agent_Liability_Source (vendor_agent_liability_source_KEY)

Schema diagram