Table: dbo.Finance_Charge_Definition
A client specific table that stores the setup information defining a finance charge, which is used to calculate fees on overdue balances.
Columns
Name | Type | Constraints | Description
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.

Primary key
Name | Columns | Description
PK_Finance_Charge_Definition | finance_charge_definition_KEY |
Unique constraints
Name | Columns | Description
UK_Finance_Charge_Definition$client_KEY$finance_charge_definition_id | client_KEY, finance_charge_definition_id |

Foreign keys
Name | Columns | Referenced table | Description
FK_Finance_Charge_Definition__Client__client_KEY | client_KEY | Client (client_KEY) |
FK_Finance_Charge_Definition__Finance_Charge_Date_Basis__finance_charge_date_basis_KEY | finance_charge_date_basis_KEY | Finance_Charge_Date_Basis (finance_charge_date_basis_KEY) |
FK_Finance_Charge_Definition__Finance_Charge_Grace_Period_Basis__finance_charge_grace_period_basis_KEY | finance_charge_grace_period_basis_KEY | Finance_Charge_Grace_Period_Basis (finance_charge_grace_period_basis_KEY) |
FK_Finance_Charge_Definition__GL_Account__client_KEY__gl_account_KEY | client_KEY, gl_account_KEY | GL_Account (client_KEY, gl_account_KEY) |

Incoming foreign keys
Name | Columns | Referencing table | Description
FK_Spreadsheet_Import_Finance_Charge_Definition__Finance_Charge_Definition__finance_charge_definition_KEY | finance_charge_definition_KEY | Spreadsheet_Import_Finance_Charge_Definition |
FK_Customer__Finance_Charge_Definition__finance_charge_definition_KEY | finance_charge_definition_KEY | Customer |