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) |