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.
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. |