m_external_asset_owner_transfer

-1 rows


Columns

Column Type Size Nulls Auto Default Children Parents Comments
id int8 19 √ null
m_external_asset_owner_transfer_journal_entry_mapping.owner_transfer_id FK_ext_asset_owner_transfer_je_mapping_owner_transfer_id R
m_external_asset_owner_transfer_loan_mapping.owner_transfer_id FK_external_asset_owner_transfer_loan_mapping_owner_transfer_id R

Internal ID
owner_id int8 19 null
m_external_asset_owner.id FK_external_asset_owner_transfer_owner_id R
external_id varchar 100 null
status varchar 50 null
purchase_price_ratio varchar 50 null
settlement_date date 13 null
effective_date_from date 13 null
effective_date_to date 13 null
created_by int8 19 √ null
m_appuser.id FK_external_asset_owner_transfer_created_by R
created_on_utc timestamptz 35,6 √ null
last_modified_by int8 19 √ null
m_appuser.id FK_external_asset_owner_transfer_modified_by R
last_modified_on_utc timestamptz 35,6 √ null
external_loan_id varchar 100 √ null
loan_id int8 19 null
m_loan.id FK_external_asset_owner_transfer_loan_id R

Loan ID
sub_status varchar 50 √ null
external_group_id varchar 100 √ null
previous_owner_id int8 19 √ null
m_external_asset_owner.id FK_external_asset_owner_transfer_previous_owner R

Indexes

Constraint Name Type Sort Column(s)
m_external_asset_owner_transfer_pkey Primary key Asc id
external_asset_owner_transfer_effective_date_from Performance Asc effective_date_from
external_asset_owner_transfer_effective_date_to Performance Asc effective_date_to
external_asset_owner_transfer_external_id Performance Asc external_id
external_asset_owner_transfer_loan_id Performance Asc loan_id
external_asset_owner_transfer_settlement_date Performance Asc settlement_date
external_asset_owner_transfer_status Performance Asc status
external_asset_owner_transfer_sub_status Performance Asc sub_status
external_transfer_status_external_id Must be unique Asc/Asc status + external_id

Relationships

Close relationships within degrees of separation