Table: dbo.Bank_Reconciliation_Recurring_Adjustment_Template_Distribution
This table holds the distributions of a bank reconciliation recurring adjustment template.
Columns
NameTypeConstraintsDescription
bank_reconciliation_recurring_adjustment_template_distribution_KEYint (4)NOT NULLThe primary key of this table, not null.
bank_reconciliation_recurring_adjustment_template_KEYint (4)NOT NULLForeign key to the parent recurring adjustment template record.
amountdecimal (9, 2)NOT NULLThe amount of this recurring adjustment template distribution.
gl_account_KEYint (4)NOT NULLThe gl account key of this recurring adjustment template distribution.
descriptionnvarchar (240)NOT NULLThe description of this recurring adjustment template distribution.
sequence_numberint (4)NOT NULLThe sequence number of this recurring adjustment template distribution. If there are several distributions from the same recurring adjustment template in a list, this shows the preferred location of a distribution in the list.
Primary key
NameColumnsDescription
PK_Bank_Reconciliation_Recurring_Adjustment_Template_Distributionbank_reconciliation_recurring_adjustment_template_distribution_KEY
Unique constraints
NameColumnsDescription
UK_Bank_Reconciliation_Recurring_Adjustment_Template_Distribution$bank_reconciliation_recurring_adjustment_template_KEY$sequencebank_reconciliation_recurring_adjustment_template_KEY, sequence_number
Foreign keys
NameColumnsReferenced tableDescription
FK_Bank_Reconciliation_Recurring_Adjustment_Template_Distribution__Bank_Reconciliation_Recurring_Adjustment_Template__bank_reconbank_reconciliation_recurring_adjustment_template_KEYBank_Reconciliation_Recurring_Adjustment_Template (bank_reconciliation_recurring_adjustment_template_KEY)
FK_Bank_Reconciliation_Recurring_Adjustment_Template_Distribution__GL_Account__gl_account_KEYgl_account_KEYGL_Account (gl_account_KEY)

Schema diagram