acc_product_mapping

-1 rows


Columns

Column Type Size Nulls Auto Default Children Parents Comments
id int8 19 √ null
gl_account_id int8 19 √ null
acc_gl_account.id FK_acc_product_mapping_gl_account_id R
product_id int8 19 √ null
product_type int2 5 √ null
payment_type int4 10 √ null
m_payment_type.id FK_acc_product_mapping_m_payment_type R
charge_id int8 19 √ null
m_charge.id FK_acc_product_mapping_m_charge R
financial_account_type int2 5 √ null
charge_off_reason_id int4 10 √ null
m_code_value.id fk_acc_product_mapping_charge_off_reason R
capitalized_income_classification_id int4 10 √ null
m_code_value.id fk_acc_product_mapping_capitalized_income_classification R
buydown_fee_classification_id int4 10 √ null
m_code_value.id fk_acc_product_mapping_buydown_fee_classification R
write_off_reason_id int8 19 √ null

Indexes

Constraint Name Type Sort Column(s)
acc_product_mapping_pkey Primary key Asc id
FK_acc_product_mapping_m_charge Performance Asc charge_id
FK_acc_product_mapping_m_payment_type Performance Asc payment_type
IND_acc_product_mapping_product_id Performance Asc product_id

Relationships

Close relationships within degrees of separation