You are browsing the archive for Oracle iPayment.

Oracle iPayment Tables

Oracle iPayment module – list of database tables

  • IBY_ACCOUNT_OWNERS
  • IBY_ACCPPMTMTHD
  • IBY_ACCTTYPE
  • IBY_ACCT_PMT_PROFILES_B
  • IBY_ACCT_PMT_PROFILES_TL
  • IBY_ACK_READERS
  • IBY_ACTIVITY
  • IBY_APPLICABLE_PMT_MTHDS
  • IBY_APPLICABLE_PMT_PROFS
  • IBY_BANKACCT
  • IBY_BANK_INSTRUCTIONS_B
  • IBY_BANK_INSTRUCTIONS_TL
  • IBY_BATCHES_ALL
  • IBY_BEPINFO
  • IBY_BEPKEYS
  • IBY_BEPLANGS
  • IBY_BEP_ACCT_OPT_NAME_B
  • IBY_BEP_ACCT_OPT_NAME_TL
  • IBY_BEP_ACCT_OPT_VALS
  • IBY_CC_ISSUER_RANGES
  • IBY_CREDITCARD
  • IBY_CREDITCARD_H
  • IBY_CREDITCARD_ISSUERS_B
  • IBY_CREDITCARD_ISSUERS_TL
  • IBY_DEFAULT_BEP
  • IBY_DELIVERY_CHANNELS_B
  • IBY_DELIVERY_CHANNELS_TL
  • IBY_DOCS_PAYABLE_ALL
  • IBY_DOCS_PAYABLE_GT
  • IBY_DOCUMENTS_PAYABLE_H
  • IBY_DOCUMENT_LINES
  • IBY_DOCUMENT_LINES_H
  • IBY_ECAPP
  • IBY_EXTERNAL_PAYEES_ALL
  • IBY_EXTERNAL_PAYERS_ALL
  • IBY_EXTRACTS_B
  • IBY_EXTRACTS_TL
  • IBY_EXTRACT_ACTIVATIONS
  • IBY_EXT_BANK_ACCOUNTS
  • IBY_EXT_PARTY_PMT_MTHDS
  • IBY_FNDCPT_PAYEE_APPL
  • IBY_FNDCPT_PMT_CHNNLS_B
  • IBY_FNDCPT_PMT_CHNNLS_TL
  • IBY_FNDCPT_SYS_CC_PF_B
  • IBY_FNDCPT_SYS_CC_PF_TL
  • IBY_FNDCPT_SYS_DC_PF_B
  • IBY_FNDCPT_SYS_DC_PF_TL
  • IBY_FNDCPT_SYS_EFT_PF_B
  • IBY_FNDCPT_SYS_EFT_PF_TL
  • IBY_FNDCPT_TX_EXTENSIONS
  • IBY_FNDCPT_TX_OPERATIONS
  • IBY_FNDCPT_TX_XE_COPIES
  • IBY_FNDCPT_USER_CC_PF_B
  • IBY_FNDCPT_USER_CC_PF_TL
  • IBY_FNDCPT_USER_DC_PF_B
  • IBY_FNDCPT_USER_DC_PF_TL
  • IBY_FNDCPT_USER_EFT_PF_B
  • IBY_FNDCPT_USER_EFT_PF_TL
  • IBY_FORMATS_B
  • IBY_FORMATS_TL
  • IBY_F_CRDT_APP_STATUS_B
  • IBY_F_CRDT_APP_STATUS_TL
  • IBY_F_PC_RATES_ALL
  • IBY_F_T_CA_GRNTRS_B
  • IBY_F_T_CA_GRNTRS_TL
  • IBY_F_T_CA_GRNTR_H
  • IBY_F_T_CRDT_APPS_ALL_B
  • IBY_F_T_CRDT_APPS_ALL_TL
  • IBY_F_T_CRDT_APP_REVS
  • IBY_F_T_CRDT_APP_ST_H
  • IBY_F_T_EMAIL_NOTIF_LOG
  • IBY_GEN_DOCS_PAYABLE
  • IBY_GEN_DOCUMENT_LINES
  • IBY_G_MSG_TEMPLATES_B
  • IBY_G_MSG_TEMPLATES_TL
  • IBY_G_ST_TRANSITIONS
  • IBY_G_T_MESSAGES
  • IBY_G_T_MSG_REQ_LOG
  • IBY_HOOK_DOCS_IN_PMT_T
  • IBY_HOOK_PAYMENTS_T
  • IBY_INSTRHOLDER
  • IBY_INSTRUCT_SOURCE_APPS
  • IBY_INSTR_CREATION_RULES
  • IBY_INTERMEDIARY_ACCTS
  • IBY_INTERNAL_PAYERS_ALL
  • IBY_IRF_PMT_AMOUNT
  • IBY_IRF_PMT_FREQUENCY
  • IBY_IRF_PMT_HISTORY
  • IBY_IRF_PMT_HIST_RANGE
  • IBY_IRF_RISKY_INSTR
  • IBY_IRF_TIMEOF_PURCHASE
  • IBY_IRF_TRXN_AMT_LIMIT
  • IBY_MAPPINGS
  • IBY_PAYEE
  • IBY_PAYEE_SUBKEYS
  • IBY_PAYMENTS_ALL
  • IBY_PAYMENTS_H
  • IBY_PAYMENT_METHODS_B
  • IBY_PAYMENT_METHODS_TL
  • IBY_PAYMENT_REASONS_B
  • IBY_PAYMENT_REASONS_TL
  • IBY_PAYMENT_REFERENCES
  • IBY_PAYMENT_RULES
  • IBY_PAY_BATCHES_ALL
  • IBY_PAY_INSTRUCTIONS_ALL
  • IBY_PAY_INSTRUCTIONS_H
  • IBY_PAY_INVOICEPMTS
  • IBY_PAY_PAYMENTS_ALL
  • IBY_PAY_SERVICE_REQUESTS
  • IBY_PCARD_BIN_RANGE
  • IBY_PMTMTHD_CONDITIONS
  • IBY_PMTSCHEMES
  • IBY_PMT_CREATION_RULES
  • IBY_PMT_INSTR_USES_ALL
  • IBY_PMT_MTHD_ATTRIB_APPL
  • IBY_PMT_SYS_FORMATS
  • IBY_PMT_SYS_TRANSMISSIONS
  • IBY_PROCESS_FUNCTIONS
  • IBY_PROCESS_ORGS
  • IBY_REMIT_ADVICE_SETUP
  • IBY_RESULT_CODES
  • IBY_RISK_FACTORS
  • IBY_RISK_FORMULAS
  • IBY_RISK_FORMULA_ITEM
  • IBY_ROUTINGINFO
  • IBY_RULE_CONDITIONS
  • IBY_SECURITY_SEGMENTS
  • IBY_SETUP_TASKS_B
  • IBY_SETUP_TASKS_TL
  • IBY_SYS_PMT_PROFILES_B
  • IBY_SYS_PMT_PROFILES_TL
  • IBY_SYS_SECURITY_OPTIONS
  • IBY_SYS_SECURITY_SUBKEYS
  • IBY_TANGIBLE
  • IBY_TEMP_EXT_BANK_ACCTS
  • IBY_TEMP_EXT_PAYEES
  • IBY_TEMP_PMT_INSTR_USES
  • IBY_TRANSACTION_ERRORS
  • IBY_TRANSMIT_CONFIGS_B
  • IBY_TRANSMIT_CONFIGS_TL
  • IBY_TRANSMIT_PARAMETERS_B
  • IBY_TRANSMIT_PARAMETERS_TL
  • IBY_TRANSMIT_PROTOCOLS_B
  • IBY_TRANSMIT_PROTOCOLS_TL
  • IBY_TRANSMIT_VALUES
  • IBY_TRXN_CORE
  • IBY_TRXN_DOCUMENTS
  • IBY_TRXN_ERROR_TOKENS
  • IBY_TRXN_EXTENDED
  • IBY_TRXN_EXTENSIBILITY
  • IBY_TRXN_FI
  • IBY_TRXN_SUMMARIES_ALL
  • IBY_TRXN_TYPES_B
  • IBY_TRXN_TYPES_TL
  • IBY_UPG_INSTRUMENTS
  • IBY_UPG_PPP
  • IBY_USED_PAYMENT_DOCS
  • IBY_VALIDATION_PARAMS_B
  • IBY_VALIDATION_PARAMS_TL
  • IBY_VALIDATION_SETS_B
  • IBY_VALIDATION_SETS_TL
  • IBY_VALIDATION_VALUES
  • IBY_VAL_ASSIGNMENTS
  • IBY_VISBLTY_CLASS_DTLS
  • IBY_VISIBILITY_CLASSES

Views in Oracle iPayments Module

List of views in Oracle iPayments Module

IBY_ACCT_PMT_PROFILES_VL
IBY_AVS_RSTYPES_V
IBY_BANK_INSTRUCTIONS_VL
IBY_BANKACCT_V
IBY_BATCHES_ALL_V
IBY_BEP_ACCT_OPT_NAME_VL
IBY_BEPINFO_DFV
IBY_BEPKEYS_DFV
IBY_CLEARED_PMT_XML_V
IBY_COMPLETED_PMT_XML_V
IBY_CRC_RSTYPES_V
IBY_CREDITCARD_DFV
IBY_CREDITCARD_ISSUERS_V
IBY_CREDITCARD_ISSUERS_VL
IBY_CREDITCARD_V
IBY_DELIVERY_CHANNELS_VL
IBY_DOCS_PAYABLE_ALL_DFV
IBY_DOCS_PAYABLE_SEC_V
IBY_ECAPP_V
IBY_EXT_BANK_ACCOUNTS_DFV
IBY_EXT_BANK_ACCOUNTS_INT_V
IBY_EXT_BANK_ACCOUNTS_V
IBY_EXT_BANK_BRANCHES_V
IBY_EXT_BANKS_V
IBY_EXT_FC_PAYER_1_0_V
IBY_EXT_FD_DOC_1_0_V
IBY_EXT_FD_DOC_1_0_VT
IBY_EXT_FD_DOC_ERR_1_0_V
IBY_EXT_FD_INS_1_0_V
IBY_EXT_FD_INVPAYEE_1_0_VD
IBY_EXT_FD_PAYEE_1_0_V
IBY_EXT_FD_PAYEE_1_0_VD
IBY_EXT_FD_PAYER_1_0_V
IBY_EXT_FD_PAYER_1_0_VD
IBY_EXT_FD_PMT_1_0_V
IBY_EXT_FD_PMT_1_0_VT
IBY_EXT_FD_PMT_ERR_1_0_V
IBY_EXT_FD_PPR_1_0_V
IBY_EXT_FD_PRBA_1_0_V
IBY_EXT_FD_PRBA_1_0_VD
IBY_EXTERNAL_BANK_ACCOUNTS_V
IBY_EXTERNAL_PAYEES_V
IBY_EXTN_AUTHORIZATIONS_V
IBY_EXTN_INSTR_DETAILS_V
IBY_EXTN_RETURNS_V
IBY_EXTN_SETTLEMENTS_V
IBY_EXTRACTS_VL
IBY_F_CRDT_APP_STATUS_VL
IBY_F_LENDER_CONTACTS_V
IBY_F_LENDERS_V
IBY_F_PC_RATES_ALL_V
IBY_F_T_CA_GRNTRS_VL
IBY_F_T_CA_STATUS_H_V
IBY_F_T_CRDT_APPS_ALL_VL
IBY_F_T_CRDT_APPS_V
IBY_FD_DOCS_PAYABLE_V
IBY_FD_PAYMENTS_V
IBY_FNDCPT_ALL_PMT_CHANNELS_V
IBY_FNDCPT_PAYER_ALL_INSTRS_V
IBY_FNDCPT_PAYER_ASSGN_INSTR_V
IBY_FNDCPT_PMT_CHNNLS_B_DFV
IBY_FNDCPT_PMT_CHNNLS_VL
IBY_FNDCPT_SYS_CC_PF_B_DFV
IBY_FNDCPT_SYS_CC_PF_VL
IBY_FNDCPT_SYS_DC_PF_B_DFV
IBY_FNDCPT_SYS_DC_PF_VL
IBY_FNDCPT_SYS_EFT_PF_B_DFV
IBY_FNDCPT_SYS_EFT_PF_VL
IBY_FNDCPT_USER_CC_PF_VL
IBY_FNDCPT_USER_DC_PF_VL
IBY_FNDCPT_USER_EFT_PF_VL
IBY_FOP_DTYPES_V
IBY_FORMATS_B_DFV
IBY_FORMATS_VL
IBY_FORMULA_FACTOR_V
IBY_G_MSG_TEMPLATES_VL
IBY_INS_LVL_PMT_STS_CHG_XML_V
IBY_INSTR_HOLDER_V
IBY_NOTIFY_INS_FAIL_XML_V
IBY_NOTIFY_REQ_XML_V
IBY_NOTIFY_XMISSION_FAIL_XML_V
IBY_PA_RSTYPES_V
IBY_PAY_INSTRUCTIONS_ALL_DFV
IBY_PAY_INSTRUCTIONS_SEC_V
IBY_PAY_REQUEST_SEC_V
IBY_PAY_SERVICE_REQUESTS_DFV
IBY_PAYEE_ALL_BANKACCT_V
IBY_PAYEE_ASSIGNED_BANKACCT_V
IBY_PAYMENT_METHODS_B_DFV
IBY_PAYMENT_METHODS_VL
IBY_PAYMENT_PROFILES
IBY_PAYMENT_REASONS_VL
IBY_PAYMENTS_ALL_DFV
IBY_PAYMENTS_SEC_V
IBY_PAYMENTS_V
IBY_PERIODIC_SEQ_SRS_V
IBY_PH_DTYPES_V
IBY_PH_RSTYPES_V
IBY_PMT_FAILED_DOCS_XML_V
IBY_PMT_INSTR_USES_ALL_DFV
IBY_PMT_LVL_PMT_STS_CHG_XML_V
IBY_PP_FIRST_PARTY_V
IBY_PURCHASECARD_V
IBY_RC_RSTYPES_V
IBY_REJECT_REQ_XML_V
IBY_REJECTED_DOCS_XML_V
IBY_SEC_EXT_BANK_ACCOUNT_V
IBY_SETUP_TASKS_VL
IBY_SINGLE_REJECTED_DOC_XML_V
IBY_SYS_PMT_PROFILES_B_DFV
IBY_SYS_PMT_PROFILES_VL
IBY_TAL_DTYPES_V
IBY_TAL_RSTYPES_V
IBY_TOP_RSTYPES_V
IBY_TRANS_ALL_V
IBY_TRANS_BANKACCT_V
IBY_TRANS_CORE_V
IBY_TRANS_FI_V
IBY_TRANS_PCARD_V
IBY_TRANS_SET_V
IBY_TRANSACTIONS_SET_V
IBY_TRANSACTIONS_V
IBY_TRANSMIT_CONFIGS_VL
IBY_TRANSMIT_PARAMETERS_VL
IBY_TRANSMIT_PROTOCOLS_VL
IBY_TRXN_EXT_AUTHS_V
IBY_TRXN_EXT_SETTLEMENTS_V
IBY_TRXN_EXTENSIONS_V
IBY_TRXN_TYPES_VL
IBY_UNCLEARED_PMT_XML_V
IBY_UPG_PPP_VL
IBY_USER_PAY_FUNS_SEC_V
IBY_VALIDATION_PARAMS_VL
IBY_VALIDATION_SETS_VL
IBY_VOID_PMT_XML_V
IBY_XML_BATCH_FCI_1_0_V
IBY_XML_BEP_ACCT_OPTIONS_V
IBY_XML_FC_PRBA_1_0_V
IBY_XML_FD_ACCT_SETTINGS_1_0_V
IBY_XML_FD_DOC_1_0_V
IBY_XML_FD_DOC_ERR_1_0_V
IBY_XML_FD_DOCLINE_1_0_V
IBY_XML_FD_INS_1_0_V
IBY_XML_FD_INS_1_0_V0
IBY_XML_FD_INVPAYEE_1_0_V
IBY_XML_FD_PAYEE_1_0_V
IBY_XML_FD_PAYEEM_1_0_V
IBY_XML_FD_PAYER_1_0_V
IBY_XML_FD_PEBA_1_0_V
IBY_XML_FD_PEBA_1_0_VD
IBY_XML_FD_PEBAM_1_0_V
IBY_XML_FD_PEBAM_1_0_VD
IBY_XML_FD_PMT_1_0_V
IBY_XML_FD_PMT_1_0_V0
IBY_XML_FD_PMT_ERR_1_0_V
IBY_XML_FD_PPR_1_0_V
IBY_XML_FD_PRBA_1_0_V
IBY_XML_FD_PRBA_1_0_V0
IBY_XML_FNDCPT_ACCT_1_0_V
IBY_XML_FNDCPT_BANKACCOUNT_V
IBY_XML_FNDCPT_CREDITCARD_V
IBY_XML_FNDCPT_DEBITCARD_V
IBY_XML_FNDCPT_DOC_HEADER_V
IBY_XML_FNDCPT_DOC_HEADERS_V
IBY_XML_FNDCPT_DOC_LINE_V
IBY_XML_FNDCPT_DOC_LINES_V
IBY_XML_FNDCPT_ORDER_1_0_V
IBY_XML_FNDCPT_ORDER_PN_1_0_V
IBY_XML_FNDCPT_PAYEE_1_0_V
IBY_XML_FNDCPT_PAYER_1_0_V
IBY_XML_HR_ADDR_1_0_V
IBY_XML_HZ_ADDR_1_0_V
IBY_XML_ONLINE_FCI_1_0_V
IBY_XML_TRXN_EXTENDLIST_V