| 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 | |||
| Name | Type | Constraints | Description |
| gl_transaction_KEY | int (4) | NOT NULL | The primary key of the gl transaction that has caused the update. |
| ledger_entry_type_KEY | int (4) | NOT NULL | Type of ledger entry that needs to be created/updated. |
| Primary key | |||
| Name | Columns | Description | |
| PK_Updated_Ledger_Entry_Queue$gl_transaction_KEY$ledger_entry_type_KEY | gl_transaction_KEY, ledger_entry_type_KEY | ||
| Foreign keys | |||
| Name | Columns | Referenced table | Description |
| FK_Updated_Ledger_Entry_Queue__Ledger_Entry_Type__ledger_entry_type_KEY | ledger_entry_type_KEY | Ledger_Entry_Type (ledger_entry_type_KEY) | |