1.5 OFSLL Open Interface Tables

OFSLL provides a set of Interface tables to load the Account Data. This section describes the purpose of each Interface table and the relationship between them. The following are the Interface tables,

  • API_CUSTOMERS_PRIMARY
  • API_CUSTOMERS_OTHER
  • API_CONTRACT_DETAILS
  • API_ASSETS
  • API_ACCOUNTS
  • API_ACCOUNT_BALANCES
  • API_TXNS
  • API_COMMENTS
  • API_CONTRACTS
  • API_ACCOUNT_BALANCES_AMORTIZE
  • API_ACCOUNT_REPMT_SCHEDULE
  • API_ACCOUNT_RATE_SCHEDULE
  • API_INSURANCES
  • API_SUBVENTIONS
  • API_ACCOUNT_PMT_CHG_SCH
  • API_BUSINESS_APPL_LIABILITIES
  • API_BUSINESS_APPL_FINANCIALS
  • API_BUSINESS_APPL_DETAILS
  • API_ACCOUNT_DUE_DATE_HISTORY
  • API_ACCOUNT_CONDITIONS
  • API_BANKRUPTCY
  • API_ACCOUNT_BKRP_HISTORY
  • API_TRACKING_ATTRIBUTES
  • API_CUSTOMER_CREDIT_SCORE
  • API_BUSINESS_CREDIT_SCORE

The information of an Account is spread across the above Interface Tables.