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
NameTypeConstraintsDescription
bank_reconciliation_aggregate_clear_status_KEYint (4)NOT NULLPrimary key.
codechar (1)The displayable one character code that represents the clear status.
descriptionnvarchar (100)NOT NULLA description of the meaning of the clear status.
Primary key
NameColumnsDescription
PK_Bank_Reconciliation_Aggregate_Clear_Statusbank_reconciliation_aggregate_clear_status_KEY
Unique constraints
NameColumnsDescription
UK_Bank_Reconciliation_Aggregate_Clear_Status$codecode
UK_Bank_Reconciliation_Aggregate_Clear_Status$descriptiondescription

Schema diagram