Table: dbo.Payroll_Agent_Payment_Method_Lead_Days
This table is used by the manage impound payments workitem for use with payroll agents. It contains information used in conjunction with a filter to select processing days for payments based on payment method, the due date and the number of lead days. The filter system will calculate the processing date by due date minus the number of lead days for the payment method type. This table is at the firm level and is shared by all clients. There are a fixed number of rows as the payment method types are static, but the table is not read only since the number of lead days can be modified.
Columns
NameTypeConstraintsDescription
vendor_payment_method_KEYint (4)NOT NULLThe payment method type for which the lead days pertain.
lead_daysint (4)NOT NULLThe number of lead days.
Primary key
NameColumnsDescription
PK_Payroll_Agent_Payment_Method_Lead_Days$vendor_payment_method_KEYvendor_payment_method_KEY
Foreign keys
NameColumnsReferenced tableDescription
FK_Payroll_Agent_Payment_Method_Lead_Days__Vendor_Payment_Method__vendor_payment_method_KEYvendor_payment_method_KEYVendor_Payment_Method (vendor_payment_method_KEY)

Schema diagram