Table: dbo.Transaction_Status
Columns
NameTypeConstraintsDescription
transaction_status_KEYint (4)NOT NULL
descriptionnvarchar (100)NOT NULL
Primary key
NameColumnsDescription
PK_Transaction_Statustransaction_status_KEY
Unique constraints
NameColumnsDescription
UK_Transaction_Status$descriptiondescription
Incoming foreign keys
NameColumnsReferencing tableDescription
FK_Receivable_Transaction__Transaction_Status__transaction_status_KEYtransaction_status_KEYReceivable_Transaction
FK_Journal_Entry__Transaction_Status__transaction_status_KEYtransaction_status_KEYJournal_Entry
FK_Bank_Transaction__Transaction_Status__transaction_status_KEYtransaction_status_KEYBank_Transaction
FK_Payable_Transaction_Template__Transaction_Status__transaction_status_KEYtransaction_status_KEYPayable_Transaction_Template
FK_Positive_Pay_File_Detail__Transaction_Status__transaction_status_KEYtransaction_status_KEYPositive_Pay_File_Detail
FK_AR_Transaction__Transaction_Status__transaction_status_KEYtransaction_status_KEYAR_Transaction
FK_AR_Payment__Transaction_Status__transaction_status_KEYtransaction_status_KEYAR_Payment
FK_Manage_Customer_Payment__Transaction_Status__transaction_status_KEYtransaction_status_KEYManage_Customer_Payment
FK_Payable_Transaction__Transaction_Status__transaction_status_KEYtransaction_status_KEYPayable_Transaction

Schema diagram