Table: dbo.Updated_Ledger_Entry_Queue
Table used to queue up gl transaction changes that will require the ledger entry ETL processes to run.
Columns
NameTypeConstraintsDescription
gl_transaction_KEYint (4)NOT NULLThe primary key of the gl transaction that has caused the update.
ledger_entry_type_KEYint (4)NOT NULLType of ledger entry that needs to be created/updated.
Primary key
NameColumnsDescription
PK_Updated_Ledger_Entry_Queue$gl_transaction_KEY$ledger_entry_type_KEYgl_transaction_KEY, ledger_entry_type_KEY
Foreign keys
NameColumnsReferenced tableDescription
FK_Updated_Ledger_Entry_Queue__Ledger_Entry_Type__ledger_entry_type_KEYledger_entry_type_KEYLedger_Entry_Type (ledger_entry_type_KEY)

Schema diagram