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 |