Romber

Database tables

romber_financial.transaction_elements

• Purpose
• Definition
• Constraints

Purpose

This table provides a list of valid financial transaction elements.

Definition

Source romber_financial_transaction_elements_tbl.sql

create table romber_financial.transaction_elements (
  financial_transaction_id              romber_financial.transaction_id                 not null,
  financial_transaction_element_seq_num int                                             not null,
  financial_transaction_element_type_id romber_financial.transaction_element_type_id    not null,
  financial_transaction_element_value   romber_base.generic_currency_amount             not null,
  ledger_account_id                     romber_financial.ledger_account_id              not null,
  subledger_account_id                  romber_financial.subledger_account_id           not null );

Constraints

Source romber_financial_transaction_elements_pk.sql

alter table romber_financial.transaction_elements
  add constraint romber_financial_transaction_elements_pk
    primary key (
      financial_transaction_id,
      financial_transaction_element_seq_num );

Source romber_financial_transaction_elements_fk1.sql

alter table romber_financial.transaction_elements
  add constraint romber_financial_transaction_elements_fk1
    foreign key ( financial_transaction_id )
    references romber_financial.transactions ( financial_transaction_id );

Source romber_financial_transaction_elements_fk2.sql

alter table romber_financial.transaction_elements
  add constraint romber_financial_transaction_elements_fk2
    foreign key ( financial_transaction_element_type_id )
    references romber_financial.transaction_element_types (
      financial_transaction_element_type_id );

Source romber_financial_transaction_elements_fk3.sql

alter table romber_financial.transaction_elements
  add constraint romber_financial_transaction_elements_fk3
    foreign key ( ledger_account_id )
    references romber_financial.ledger_accounts ( ledger_account_id );

Source romber_financial_transaction_elements_fk4.sql

alter table romber_financial.transaction_elements
  add constraint romber_financial_transaction_elements_fk4
    foreign key ( subledger_account_id )
    references romber_financial.subledger_accounts ( subledger_account_id );