Table: dbo.Bank_Transaction_Displayable_Status
This type table contains values that represent a bank transaction's status determined by analyzing all pertinent attributes of the transaction (its type, record status, handwritten flag, etc.). This value can be displayed by data entry screens, used when filtering bank transactions on status, etc.
Columns
NameTypeConstraintsDescription
bank_transaction_displayable_status_KEYint (4)NOT NULLPrimary key for this table.
descriptionnvarchar (70)NOT NULLThe displayable, filterable, all-in-one, super-duper bank transaction status.
Primary key
NameColumnsDescription
PK_Bank_Transaction_Displayable_Statusbank_transaction_displayable_status_KEY
Unique constraints
NameColumnsDescription
UK_Bank_Transaction_Displayable_Status$descriptiondescription

Schema diagram