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 | |||
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_Payroll_Agent_Payment_Method_Lead_Days$vendor_payment_method_KEY | vendor_payment_method_KEY |
Foreign keys | |||
Name | Columns | Referenced table | Description |
FK_Payroll_Agent_Payment_Method_Lead_Days__Vendor_Payment_Method__vendor_payment_method_KEY | vendor_payment_method_KEY | Vendor_Payment_Method (vendor_payment_method_KEY) |