A client specific table that stores the setup information defining a finance charge, which is used to calculate fees on overdue balances. |
finance_charge_definition_KEY | int (4) | NOT NULL | Primary key for this table |
client_KEY | int (4) | NOT NULL | Client key |
finance_charge_definition_id | nvarchar (22) | NOT NULL | Finance charge definition id |
finance_charge_definition_id_sortable | varchar (48) | NOT NULL | A representation of the finance_charge_definition_id column that sorts in natural order. A trigger keeps this field synchronized with the content of finance_charge_definition_id. |
description | nvarchar (60) | NOT NULL | Description of the finance charge. |
is_active | bit (1) | NOT NULL | The active status of the finance charge. |
annual_rate | decimal (5, 4) | NOT NULL | The annual rate to charge. |
grace_period_duration | int (4) | NOT NULL | The duration of grace period before the finance charge kicks in. |
finance_charge_grace_period_basis_KEY | int (4) | NOT NULL | The time period for the grace period amount. |
is_compound | bit (1) | NOT NULL | If true previous finance charge transactions should be included in the total for calculating future finance charges. |
finance_charge_date_basis_KEY | int (4) | NOT NULL | The type of date to calculate the finance charge from. |
minimum_finance_charge | decimal (9, 2) | NOT NULL | The minimum finance charge. |
gl_account_KEY | int (4) | NOT NULL | The finance charge gl account. |
is_taxable | bit (1) | NOT NULL | If true the finance charge amount is subject to sales tax when the finance charge transactions are created. |
minimum_past_due_balance | decimal (9, 2) | NOT NULL | The minimum customer past due balance required to calculate a finance charge. |