| 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 | ||