Table: dbo.Tax_Agent_Payment_Method_Lead_Days
This table is used by the manage impound payments workitem for use with tax 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
Name | Type | Constraints | Description
vendor_payment_method_KEY | int (4) | NOT NULL | The payment method type for which the lead days pertain.
lead_days | int (4) | NOT NULL | The number of lead days.

Primary key
Name | Columns | Description
PK_Tax_Agent_Payment_Method_Lead_Days$vendor_payment_method_KEY | vendor_payment_method_KEY |

Foreign keys
Name | Columns | Referenced table | Description
FK_Tax_Agent_Payment_Method_Lead_Days__Vendor_Payment_Method__vendor_payment_method_KEY | vendor_payment_method_KEY | Vendor_Payment_Method (vendor_payment_method_KEY) |