Card Disputes data model

This section outlines the card disputes data model and the tables installed with the disputes application.

Card disputes data model

The following diagram shows the tables and their relationships within the card disputes data model.

Image omitted: MMASSET0020606-card-dispute-data-model.png
Diagram showing the relationships between tables in the card disputes data model.

Card disputes tables

Entity	Table name	What you can do
Dispute Task	sn_bom_credit_card_disputes_task	Track and manage dispute tasks; extends the Financial Task table [sn_bom_task].
Dispute Transaction	sn_bom_credit_card_disputes_transaction	Store all credit card dispute transactions.
Business Checking Account	sn_bom_b2b_checking_account	Store checking account data for business customers; extends Deposit Account table [sn_bom_deposit_account].
Business Saving Account	sn_bom_b2b_saving_account	Store saving account data for business customers; extends Deposit Account table [sn_bom_deposit_account].
Deposit Account	sn_bom_deposit_account	Manage all checking and saving account records; extends Financial Account table [sn_bom_financial_account].
Financial Account	sn_bom_financial_account	Store deposit, loan, credit card, line of credit, and insurance policy accounts; extends Sold Product table [sn_install_base_sold_product].
Financial Task	sn_bom_task	Manage financial tasks such as inquiries, claims, credits, and loans; extends Industry Task table [sn_ind_task].
Financial Transaction	sn_bom_transaction	Track all financial transactions across deposit, loan, and credit card accounts.
Line of Credit	sn_bom_line_of_credit	Store line of credit account records; extends Financial Account table [sn_bom_financial_account].
Personal Checking Account	sn_bom_checking_account	Store checking account data for individual consumers; extends Deposit Account table [sn_bom_deposit_account].
Service Definition	sn_bom_service_definition	Configure service definitions used across workflows; extends Service Definition table [sn_case_type_selection].
Card Transaction	sn_bom_card_transaction	Store card-based transaction records; extends Financial Transaction table [sn_bom_transaction].
Deposit Transaction	sn_bom_deposit_transaction	Store deposit transaction records; extends Financial Transaction table [sn_bom_transaction].
Credit Transaction	sn_bom_line_of_credit_transaction	Store line of credit transactions; extends Financial Transaction table [sn_bom_transaction].
Visa Dispute Intake	sn_bom_credit_card_dispute_intake	Capture Visa dispute questionnaire questions and responses; extends Intake Form table [sn_evnt_inq_qtn].
Visa Dispute Cardholder Intake	sn_bom_credit_card_cardholder_dispute_intake	Store Visa dispute responses from consumers; extends Visa Dispute Intake table [sn_bom_visa_cp_visa_dispute_questionnaire].
CRB Region Type	sn_bom_visa_cp_crb_region_type	Store Visa Card Recovery Bulletin (CRB) region details.
Mastercard Chargeback Reason Code Message	sn_bom_mcard_cp_mastercard_chargeback_reason_codes	Store Mastercard chargeback reason codes and messages.
Sold Products	sn_install_base_sold_product	Track products and services sold to accounts or consumers.
Product Model	cmdb_model	Configure product models for services, hardware, software, and consumables.
Card dispute service case	sn_bom_credit_card_disputes_services	Create and track card dispute cases initiated by agents.
Card service model	Sn_ent_card_service_model	Store card product information.
Deposit model	sn_ent_deposit_account_model	Define deposit product models like savings or checking accounts.
Case	sn_customerservice_case	Manage customer questions, issues, and resolutions, such as card dispute cases.
Task	Task	Track work progress related to case management.
Task	sn_customerservice_task	Centralize and manage customer service-related tasks.
Card disputes related transaction	sn_bom_credit_card_disputes_related_transaction	Store transactions associated with a card dispute.
Service Definition	sn_case_type_selection	Link services to case types and define request types.
Intake Form	sn_evt_inq_qtn	Store request-related questions and responses.
Personal Saving Account	sn_bom_saving_account	Store individual saving account data.
Payment Network	sn_bom_payment_network	Store payment processing network info such as Visa Interlink, Pulse.
Business Credit Card	sn_bom_b2b_credit_card	Store business credit card details and usage data.
Personal Credit Card	sn_bom_credit_card	Store individual credit card details.
Chargeback Reason Codes	sn_bom_chargeback_reason_codes	Categorize and store chargeback reasons per card network.
Financial Services Base	sn_bom_case	Manage all financial case records, including disputes and fraud investigations.
Account	customer_account	Store and manage customer account records.
Consumer	csm_consumer	Store information for B2C (individual) customers.
Contact	customer_contact	Maintain customer contact information.

Dispute decision tables
Decision tables in Dispute Management provide decision logic for card dispute processing.

Parent Topic:Data Models