m_client_transaction

-1 rows


Columns

Column Type Size Nulls Auto Default Children Parents Comments
id int8 19 √ null
acc_gl_journal_entry.client_transaction_id FK_acc_gl_journal_entry_m_client_transaction R
m_client_charge_paid_by.client_transaction_id FK_m_client_charge_paid_by_m_client_transaction R
client_id int8 19 null
m_client.id FK_m_client_transaction_m_client R
office_id int8 19 null
currency_code varchar 3 null
payment_detail_id int8 19 √ null
is_reversed bool 1 null
external_id varchar 50 √ null
transaction_date date 13 null
transaction_type_enum int2 5 null
amount numeric 19,6 null
created_date timestamp 29,6 √ null
created_on_utc timestamptz 35,6 null
created_by int8 19 null
m_appuser.id FK_client_transaction_created_by R
last_modified_by int8 19 null
m_appuser.id FK_client_transaction_last_modified_by R
last_modified_on_utc timestamptz 35,6 null
submitted_on_date date 13 null

Indexes

Constraint Name Type Sort Column(s)
m_client_transaction_pkey Primary key Asc id
FK_client_transaction_submitted_on_date Performance Asc submitted_on_date
FK_m_client_transaction_m_client Performance Asc client_id
m_client_transaction_external_id_key Must be unique Asc external_id

Relationships

Close relationships within degrees of separation