FSO Core Banking tables

  • Rversion finale: Australia
  • Mis à jour 12 mars 2026
  • 8 minutes de lecture

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

    Banking tables installed

    Tableau 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 Table stores details of a certificate of deposit account 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 Table to store details of 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 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. The table holds details of these reason codes.
    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 [sn_bom_b2b_covenant] and [sn_bom_covenant_base] tables extend the Covenant Base table.
    Coverage Specification sn_bom_coverage_specification Coverage specification defines the product coverage types and their options.
    Coverage Type sn_bom_coverage_type Coverage type table will contain all the coverage types across all products.
    Coverage Type Option sn_bom_coverage_type_option Coverage type option table will contain all the coverage options for each coverage type across all products.
    Currency ISO Code Association currency_iso_code_association
    Customer Property sn_bom_customer_property Customer property table holds the details of the properties that a customer has. For example, it holds the vehicles and property locations that a customer holds.
    Data Fix Backup sn_bom_data_fix_backup Table to 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.
    Financial Service Financial Account 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 The Financial Services Base table 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 in this table 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 Group member info table 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 holding information.
    Holding lot sn_bom_holding_lot Stores holding lot information.
    Insured Property sn_bom_insured_property Insured property table references customer property and will 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 This 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 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 Table to store the operating instructions on a business account.E.g on a business checking account who are the signatories who are allowed to sign and their financial limits.
    Operating instruction sn_bom_operating_instruction Table to store the operating instructions on a personal account.E.g 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 Table to store information about the payment processing networks in the context of cards. E.g., Visa interlink, Pulse.
    Personal Certificate of Deposit sn_bom_certificate_of_deposit Table stores details of a certificate of deposit account 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 Table to store details of 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 Table to store details of a type of bank account that allows customers to deposit money and earn interest on it.
    Policy Coverage sn_bom_policy_coverage Policy coverage table will contain the defined coverages on the insurance policy.
    Policy Participant sn_bom_policy_participant Policy participant table will contain the defined participants on the insurance policy.
    Policy Participant Role sn_bom_policy_participant_insured_property Policy participant role table will contain the roles played by the participants who have been defined on the insurance policy.
    Product Coverage Type sn_bom_product_coverage_type Product coverage type table will contain the product coverage types defined for the product
    Product Coverage Type Option sn_bom_product_coverage_type_option Product coverage type option table will contain the product coverage type options defined for a coverage type within the product
    RDC Financial Account sn_bom_m2m_rdc_financial_account Financial Service Financial Account
    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 Insurance personal renters policy table extended from insurance policy.
    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 Table to store details of security exchange (a marketplace where securities, such as stocks, bonds, and derivatives, are bought and sold). E.g. 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 sn_bom_m2m_service_definition_user_criteria An m2m table between Service Definition and Agent Criteria (user_criteria)
    Service Definition has Entity Criteria sn_bom_m2m_service_definition_customer_condition An m2m table between Service Definition and Entity Criteria (sn_req_criteria_customer_condition).
    Standing Order sn_bom_b2b_standing_order Table to store standing instructions which is pre-authorized payment instruction given by a business customer to the bank. E.g. Auto bill payments
    Standing Order sn_bom_standing_order Table to store standing instructions which is pre-authorized payment instruction given by a individual customer to the bank. E.g. 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 To store 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