Table: dbo.Bank_Reconciliation_Recurring_Adjustment_Template_Distribution
This table holds the distributions of a bank reconciliation recurring adjustment template.
Columns
Name | Type | Constraints | Description
bank_reconciliation_recurring_adjustment_template_distribution_KEY | int (4) | NOT NULL | The primary key of this table, not null.
bank_reconciliation_recurring_adjustment_template_KEY | int (4) | NOT NULL | Foreign key to the parent recurring adjustment template record.
amount | decimal (9, 2) | NOT NULL | The amount of this recurring adjustment template distribution.
gl_account_KEY | int (4) | NOT NULL | The gl account key of this recurring adjustment template distribution.
description | nvarchar (240) | NOT NULL | The description of this recurring adjustment template distribution.
sequence_number | int (4) | NOT NULL | The 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
Name | Columns | Description
PK_Bank_Reconciliation_Recurring_Adjustment_Template_Distribution | bank_reconciliation_recurring_adjustment_template_distribution_KEY |
Unique constraints
Name | Columns | Description
UK_Bank_Reconciliation_Recurring_Adjustment_Template_Distribution$bank_reconciliation_recurring_adjustment_template_KEY$sequence | bank_reconciliation_recurring_adjustment_template_KEY, sequence_number |

Foreign keys
Name | Columns | Referenced table | Description
FK_Bank_Reconciliation_Recurring_Adjustment_Template_Distribution__Bank_Reconciliation_Recurring_Adjustment_Template__bank_recon | bank_reconciliation_recurring_adjustment_template_KEY | Bank_Reconciliation_Recurring_Adjustment_Template (bank_reconciliation_recurring_adjustment_template_KEY) |
FK_Bank_Reconciliation_Recurring_Adjustment_Template_Distribution__GL_Account__gl_account_KEY | gl_account_KEY | GL_Account (gl_account_KEY) |