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
NameTypeConstraintsDescription
finance_charge_definition_KEYint (4)NOT NULLPrimary key for this table
client_KEYint (4)NOT NULLClient key
finance_charge_definition_idnvarchar (22)NOT NULLFinance charge definition id
finance_charge_definition_id_sortablevarchar (48)NOT NULLA 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.
descriptionnvarchar (60)NOT NULLDescription of the finance charge.
is_activebit (1)NOT NULLThe active status of the finance charge.
annual_ratedecimal (5, 4)NOT NULLThe annual rate to charge.
grace_period_durationint (4)NOT NULLThe duration of grace period before the finance charge kicks in.
finance_charge_grace_period_basis_KEYint (4)NOT NULLThe time period for the grace period amount.
is_compoundbit (1)NOT NULLIf true previous finance charge transactions should be included in the total for calculating future finance charges.
finance_charge_date_basis_KEYint (4)NOT NULLThe type of date to calculate the finance charge from.
minimum_finance_chargedecimal (9, 2)NOT NULLThe minimum finance charge.
gl_account_KEYint (4)NOT NULLThe finance charge gl account.
is_taxablebit (1)NOT NULLIf true the finance charge amount is subject to sales tax when the finance charge transactions are created.
minimum_past_due_balancedecimal (9, 2)NOT NULLThe minimum customer past due balance required to calculate a finance charge.
Primary key
NameColumnsDescription
PK_Finance_Charge_Definitionfinance_charge_definition_KEY
Unique constraints
NameColumnsDescription
UK_Finance_Charge_Definition$client_KEY$finance_charge_definition_idclient_KEY, finance_charge_definition_id
Foreign keys
NameColumnsReferenced tableDescription
FK_Finance_Charge_Definition__Client__client_KEYclient_KEYClient (client_KEY)
FK_Finance_Charge_Definition__Finance_Charge_Date_Basis__finance_charge_date_basis_KEYfinance_charge_date_basis_KEYFinance_Charge_Date_Basis (finance_charge_date_basis_KEY)
FK_Finance_Charge_Definition__Finance_Charge_Grace_Period_Basis__finance_charge_grace_period_basis_KEYfinance_charge_grace_period_basis_KEYFinance_Charge_Grace_Period_Basis (finance_charge_grace_period_basis_KEY)
FK_Finance_Charge_Definition__GL_Account__client_KEY__gl_account_KEYclient_KEY, gl_account_KEYGL_Account (client_KEY, gl_account_KEY)
Incoming foreign keys
NameColumnsReferencing tableDescription
FK_Spreadsheet_Import_Finance_Charge_Definition__Finance_Charge_Definition__finance_charge_definition_KEYfinance_charge_definition_KEYSpreadsheet_Import_Finance_Charge_Definition
FK_Customer__Finance_Charge_Definition__finance_charge_definition_KEYfinance_charge_definition_KEYCustomer

Schema diagram