Table: dbo.Export_Journal_Entry_To_Csa_Status
Columns
NameTypeConstraintsDescription
export_journal_entry_to_csa_status_KEYint (4)NOT NULLPrimary key for this table
descriptionnvarchar (40)NOT NULLThe export status of a bank transaction. LiveNotExported - this live check has not been exported to csa yet, LiveExported - this live check has been exported to csa, Ignore - this bank transaction should be ignored
Primary key
NameColumnsDescription
PK_Export_Journal_Entry_To_Csa_Statusexport_journal_entry_to_csa_status_KEY
Unique constraints
NameColumnsDescription
UK_Export_Journal_Entry_To_Csa_Status$descriptiondescription
Incoming foreign keys
NameColumnsReferencing tableDescription
FK_Bank_Transaction__Export_Journal_Entry_To_Csa_Status__export_journal_entry_to_csa_status_KEYexport_journal_entry_to_csa_status_KEYBank_Transaction
FK_Payable_Transaction__Export_Journal_Entry_To_Csa_Status__export_journal_entry_to_csa_status_KEYexport_journal_entry_to_csa_status_KEYPayable_Transaction

Schema diagram