This section describes the banking tables in FSO Core and shows how they store and manage banking information.

Banking tables installed

Table 1. Financial Services Operations Core tables

Label	Table name	Description
Auto Loan	sn_bom_auto_loan	Stores all auto loans records. This table extends the Loan Account [sn_bom_loan_account] table.
Bond	sn_bom_bond	Stores all bond information. Extends the Security [sn_bom_security] table.
Business Certificate of Deposit	sn_bom_b2b_certificate_of_deposit	Stores all certificate of deposit account records, a type of financial account that allows businesses to deposit money for a fixed period and earn a fixed interest on it.
Business Checking Account	sn_bom_b2b_checking_account	Stores all checking account records for consumers. Extends the Deposit Account [sn_bom_deposit_account] table.
Business Credit Card	sn_bom_b2b_credit_card	Stores all business credit card records, a type of credit card that is designed for businesses to purchase goods or services on credit with benefits tailored to their needs.
Business Line of Credit	sn_bom_b2b_line_of_credit	Stores all line of credit records for business loan customers. Extends the Line of Credit table.
Business Saving Account	sn_bom_b2b_saving_account	Stores all saving account (a type of deposit account) records for business customers. Extends the Deposit Account [sn_bom_deposit_account] table.
Chargeback Reason Codes	sn_bom_chargeback_reason_codes	Stores all chargeback reason code records. Chargeback reason codes are numerical codes used to categorize the reasons why a cardholder disputes a transaction. These are provided by card networks like Visa, Mastercard, American Express.
Commercial Real Estate Loan	sn_bom_commercial_real_estate_loan	Stores all commercial real estate loan records. Extends the Loan Account [sn_bom_loan_account] table.
Commercial Vehicle Loan	sn_bom_commercial_vehicle_loan	Stores all commercial vehicle loan records. Extends the Loan Account [sn_bom_loan_account] table.
Covenant	sn_bom_b2b_covenant	Stores all covenant records for business customers.
Covenant	sn_bom_covenant	Stores all covenant records for consumers.
Covenant	sn_bom_covenant_base	Stores all covenant base records. The [sn_bom_b2b_covenant] and [sn_bom_covenant_base] tables extend the Covenant Base table.
Coverage Specification	sn_bom_coverage_specification	Stores all coverage specification records that define the product coverage types and their options.
Coverage Type	sn_bom_coverage_type	Stores all coverage type records across all products.
Coverage Type Option	sn_bom_coverage_type_option	Stores all coverage type option records for each coverage type across all products.
Currency ISO Code Association	currency_iso_code_association
Stores all location records for customer property.	sn_bom_customer_property	Stores all customer property records with details of the properties that a customer has. For example, it stores the vehicles and property locations that a customer holds.
Data Fix Backup	sn_bom_data_fix_backup	Stores all backup records during data migration from one table to another.
Deposit Account	sn_bom_deposit_account	Stores all deposit accounts – Checking and Saving records. Extends the Financial Account [sn_bom_financial_account] table.
Equipment Loan	sn_bom_equipment_loan	Stores all equipment loan records. This table extends the Loan Account [sn_bom_loan_account] table.
ETF	sn_bom_etf	Stores all ETF information. This table extends the Security [sn_bom_security] table.
Exchange	sn_bom_exchange
Financial Account	sn_bom_financial_account	Stores all financial accounts – deposit accounts, loan accounts, credit card account, line of credit accounts, and insurance policy accounts. Extends the Sold Product [sn_install_base_sold_product] table.
Financial Institution	sn_bom_financial_institution	Stores all financial institution records. Extends the Company [core_company] table.
Financial Service	sn_bom_service	Stores all financial services – RDC service and wire transfer service. Extends the Sold Product [sn_install_base_sold_product] table.
Stores all RDC financial account records. Links RDC services to financial accounts.	sn_bom_m2m_service_financial_account	Stores all financial accounts – deposit accounts, loan accounts, credit card account, line of credit accounts, and insurance policy accounts. Extends the Sold Product [sn_install_base_sold_product] table
Financial Service User	sn_bom_m2m_service_user	Stores details of users for a financial service account
Financial Services Base	sn_bom_case	Stores all financial services base records and serves as the parent table for all types of financial case records within a system. It acts as a central repository that provides a unified structure for managing various financial cases, such as disputes, fraud investigations, loan applications, insurance servicing, claims and other financial inquiries or issues. Each record represents a unique financial case, with associated metadata that links to more specific case details stored in related child tables.
Financial Services Case	sn_bom_financial_service	Stores all financial services cases. Extends the financial services base Case [sn_bom_case] table.
Financial Services Task	sn_bom_financial_task	Stores all financial services tasks. Extends the Financial Task [sn_bom_task] table.
Financial Task	sn_bom_task	Stores all financial tasks such as inquiry tasks, claim tasks, credit tasks and loan tasks. Extends the Industry Task [sn_ind_task] table.
Financial Transaction	sn_bom_transaction	Stores all financial transactions for deposit, loan, and credit card accounts. Extends the Industry Data Entity [sn_ind_data_entity] table.
Financial Transaction Authorization	sn_bom_transaction_authorization	Stores authorization-related details for financial transactions.
Group Member Info	sn_bom_group_member_info	Stores all group member info records and is an extension of customer property table which can contain the group member details applicable to a customer. For example, in employer provided life insurance policy scenario, this table can hold the group member details of the employer.
Holding	sn_bom_holding	Stores all holding information records.
Holding lot	sn_bom_holding_lot	Stores all holding lot information records.
Insured Property	sn_bom_insured_property	Stores all insured property records that reference customer property and contain the properties of a customer which are covered by an insurance policy.
Investment account	sn_bom_investment_account	Stores all investment account records. Extends the Financial Account [sn_bom_financial_account] table.
Line	sn_bom_line	Stores all line records and is a parent table which holds the case lines of a case when requests are made on the line items belonging to a sold product. For example, in an insurance servicing case, when a request is made to change policy coverages, the coverage line items for the policy can be held in the line tables extended from this table in the servicing app. This ensures that the changes are not made directly on the insurance policy coverage records when the case is being processed and the updates are made only after the case is approved and closed.
Line of Credit	sn_bom_line_of_credit	Stores all line of credit account records. Extends the Financial Account [sn_bom_financial_account] table.
Loan Account	sn_bom_loan_account	Stores all loan account records. Extends the Financial Account [sn_bom_financial_account] table.
Location	sn_bom_location	Stores all vehicle records for customer property.
Merchant Category Code	sn_bom_merchant_category_code
Mortgage	sn_bom_mortgage	Stores all mortgage account records. Extends the Loan Account [sn_bom_loan_account] table.
Operating instruction	sn_bom_b2b_operating_instruction	Stores all operating instruction records on a business account. For example, on a business checking account who are the signatories who are allowed to sign and their financial limits.
Operating instruction	sn_bom_operating_instruction	Stores all operating instruction records on a personal account. For example, on a personal checking account who are the signatories who are allowed to sign or provide instructions to operate the account.
Option	sn_bom_option	Stores all options information. Extends the Security [sn_bom_security] table.
Payment Network	sn_bom_payment_network	Stores all payment network records with information about the payment processing networks in the context of cards. For example, Visa interlink, Pulse.
Personal Certificate of Deposit	sn_bom_certificate_of_deposit	Stores all personal certificate of deposit account records, a type of financial account that allows individuals to deposit money for a fixed period and earn a fixed interest on it.
Personal Checking Account	sn_bom_checking_account	Stores all checking account records for consumers. Extends the Deposit Account [sn_bom_deposit_account] table.
Personal Credit Card	sn_bom_credit_card	Stores all personal credit card records, a type of credit card that allows individuals to purchase goods or services on credit.
Personal Line of Credit	sn_bom_b2c_line_of_credit	Stores all line of credit records for consumers.
Personal Loan	sn_bom_personal_loan	Stores all personal loan account records. Extends the Loan Account [sn_bom_loan_account] table.
Personal Saving Account	sn_bom_saving_account	Stores all personal saving account records, a type of bank account that allows customers to deposit money and earn interest on it.
Policy Coverage	sn_bom_policy_coverage	Stores all policy coverage records with the defined coverages on the insurance policy.
Policy Participant	sn_bom_policy_participant	Stores all policy participant records with the defined participants on the insurance policy.
Policy Participant Role	sn_bom_policy_participant_insured_property	Stores all policy participant role records with the roles played by the participants who have been defined on the insurance policy.
Product Coverage Type	sn_bom_product_coverage_type	Stores all product coverage type records with the product coverage types defined for the product.
Product Coverage Type Option	sn_bom_product_coverage_type_option	Stores all product coverage type option records with the product coverage type options defined for a coverage type within the product.
RDC Financial Account	sn_bom_m2m_rdc_financial_account	Stores all wire transfer financial account records. Links wire transfer services to financial accounts.
RDC Service	sn_bom_rdc	Stores all RDC treasury service records. Extends the Financial Service [sn_bom_service] table.
RDC User	sn_bom_m2m_rdc_user	Stores details of users who are authorized to request for a remote deposit capture facility on a business deposit account
Renters Policy	sn_bom_renters_ins_policy	Stores all renters policy records for insurance personal renters policies. Extends the insurance policy table.
SBA Loan	sn_bom_sba_loan	Stores all SBA (Small Business Administration) loan account records. Extends the Loan Account [sn_bom_loan_account] table.
Security	sn_bom_security	Stores all security information. Extends the Security [sn_bom_security] table.
Security Exchange	sn_bom_m2m_security_exchange	Stores all security exchange records with details of security exchange (a marketplace where securities, such as stocks, bonds, and derivatives, are bought and sold). For example, NYSE- New York Stock Exchange, Nasdaq.
Service Definition	sn_bom_service_definition	Stores all service definitions configured for all workflows across Financial Services Operations applications.
Service Definition has Agent Criteria	n_csm_case_types_service_user_criteria	Stores all service definition and agent criteria relationship records. An m2m table between Service Definition and Agent Criteria (user_criteria).
Service Definition has Entity Criteria	sn_csm_case_types_service_customer_criteria	Stores all service definition and entity criteria relationship records. An m2m table between Service Definition and Entity Criteria (sn_req_criteria_customer_condition).
Standing Order	sn_bom_b2b_standing_order	Stores all standing instruction records which are pre-authorized payment instructions given by a business customer to the bank. For example, auto bill payments.
Standing Order	sn_bom_standing_order	Stores all standing instruction records which are pre-authorized payment instructions given by a an individual customer to the bank. For example, auto bill payments.
Stock	sn_bom_stock	Stores all stock information. Extends the Security [sn_bom_security] table.
Student Loan	sn_bom_student_loan	Stores all student loan account records. Extends the Loan Account [sn_bom_loan_account] table.
Term Loan	sn_bom_term_loan	Stores all term loan account records. Extends the Loan Account [sn_bom_loan_account] table.
Trade	sn_bom_trad	Stores all trade records with information related to individual stock orders placed by investors.
Transaction	sn_bom_card_transaction	Stores all card transaction records. Extends the Financial Transaction [sn_bom_transaction] table.
Transaction	sn_bom_deposit_transaction	Stores all deposit transaction records. Extends the Financial Transaction [sn_bom_transaction] table.
Transaction	sn_bom_ins_policy_transaction	Stores all policy transaction records. Extends the Financial Transaction [sn_bom_transaction] table.
Transaction	sn_bom_investment_transaction	Stores all investment transaction records. Extends the Financial Transaction [sn_bom_transaction] table.
Transaction	sn_bom_line_of_credit_transaction	Stores all line of credit transaction records. Extends the Financial Transaction [sn_bom_transaction] table.
Transaction	sn_bom_loan_transaction	Stores all loan transaction records. Extends the Financial Transaction [sn_bom_transaction] table.
Vehicle	sn_bom_vehicle	Customer Property
Wire Transfer Financial Account	sn_bom_m2m_wire_transfer_financial_account	Financial Service Financial Account
Wire Transfer Service	sn_bom_wire_transfer	Stores all wire transfer treasury service records. Extends the Financial Service [sn_bom_service] table.
Wire Transfer User	sn_bom_m2m_wire_transfer_user	Stores details of users who are authorized to request for a wire transfer facility on a business deposit account