Table: dbo.Bank_Reconciliation_Aggregate_Clear_Status
This is a type table of bank reconciliation clear status values that apply to a given bank transaction as a whole. This value is an aggregate of the bank transaction's associated bank reconciliation detail's clear status (cleared or uncleared).
Columns
Name | Type | Constraints | Description
bank_reconciliation_aggregate_clear_status_KEY | int (4) | NOT NULL | Primary key.
code | char (1) |  | The displayable one character code that represents the clear status.
description | nvarchar (100) | NOT NULL | A description of the meaning of the clear status.

Primary key
Name | Columns | Description
PK_Bank_Reconciliation_Aggregate_Clear_Status | bank_reconciliation_aggregate_clear_status_KEY |
Unique constraints
Name | Columns | Description
UK_Bank_Reconciliation_Aggregate_Clear_Status$code | code |
UK_Bank_Reconciliation_Aggregate_Clear_Status$description | description |