This Technical Reference Manual (TRM) in any form, software or printed matter, contains proprietary information of Oracle ; it is provided under an Oracle agreement containing restrictions on use and disclosure and is also protected by copyright, patent, and other intellectual property law. Restrictions applicable to this TRM include, but are not limited to: (a) exercising either the same degree of care to safeguard the confidentiality of this TRM as you exercise to safeguard the confidentiality of your own most important Confidential Information or a reasonable degree of care, whichever is greater; (b) maintaining agreements with your employees and agents that protect the Confidential Information of third parties such as Oracle and instructing such employees and agents of these requirements for this TRM; (c) restricting disclosure of this TRM to those of your employees who have a 'need to know' consistent with the purposes for which this TRM was disclosed to you; (d) maintaining this TRM at all times on your premises; (e) not removing or destroying any proprietary or confidential legends or markings placed upon this TRM in whatever form, software or printed matter; and (f) not reproducing or transmitting this TRM in any form or by any means, electronic or mechanical, for any purpose, without the express written permission of Oracle. You should not use this TRM in any form, software or printed matter, to create software that performs the same or similar functions as any Oracle products.
The information in this TRM is subject to change without notice. If you find any problems in the TRM in any form, software or printed matter, please report them to us in writing. Oracle does not warrant that this TRM is error free. This TRM is provided to customer 'as is' with no warranty of any kind. This TRM does not constitute Documentation as that term is defined in Oracle's agreements. Reverse engineering of the Programs (software and documentation) associated with this TRM are prohibited. The Programs associated with this TRM are not intended for use in any nuclear, aviation, mass transit, medical, or other inherently dangerous applications. It shall be licensee's responsibility to take all appropriate fail safe, backup, redundancy and other measures to ensure the safe use of such applications if the Programs are used for such purposes, and Oracle disclaims liability for any damages caused by such use of the Programs. Program Documentation is licensed for use solely to support the deployment of the Programs and not for any other any other purpose. Restricted Rights Legend
This TRM and the Programs associated with this TRM delivered subject to the DOD FAR Supplement are 'commercial computer software' and use, duplication and disclosure of the TRM and the Programs associated with this TRM shall be subject to the licensing restrictions set forth in the applicable Oracle license agreement. Otherwise, this TRM and the Programs associated with this TRM delivered subject to the Federal Acquisition Regulations are 'restricted computer software' and use, duplication and disclosure of the TRM and the Programs associated with this TRM shall be subject to the restrictions in FAR 52.227-14, Rights in Data General, including Alternate III (June 1987). Oracle, 500 Oracle Parkway, Redwood City, CA 94065.
Oracle is a registered trademark. AIM Advantage™, Big Business. Small Business. All Business.™, CDM Advantage™, .comference™, ConText®, Des40®, Easy*Query™, Easy*SQL®, Education Objects™, EMM Advantage™, Enabling the Information Age®, ExpertDetectSM, Express®, FastForwardSM, GEMMS®, Gist™, Hyper*SQL™, instantOracle™, "Internet Business Intelligence - Insight for Everyone"™, iSQL*Plus™, JInitiator™, NLS*Workbench®, Object Marketplace™, ODP Pulse™, ODP Techwire™, OLA™, On Oracle™, Oracle®, Oracle Book®, Oracle Bookbatch®, Oracle BookBuilder®, OracleBRONZE®, Oracle Business OnLine®, OracleDevConnectSM, Oracle® Discoverer™, Oracle® Expert™, Oracle Financials®, OracleGOLDSM, OracleIncidentSM, OracleJSP™, OracleLifeCycleSM, Oracle Media Objects®, OracleMERCURYSM, OracleMetaLinkSM, OraclemetalsSM, OracleMobile™, Oracle Names®, Oracle NetSolutions®, Oracle® One™, Oracle Open Gateways®, Oracle OpenWorld®, OraclePLATINUMSM, Oracle Power Objects®, Oracle Press®, Oracle Procedural Gateway®, Oracle Quality®, Oracle Secure Network Services®, OracleSILVERSM, Oracle® SQL/Services™, Oracle® SQL*TutorSM, OracleSTERLINGSM, Oracle Store®, Oracle Transparent Gateway®, OracleWare®, Oracle8i™, Oracle9i™, PC Express®, Personal Express®, PJM Advantage™, PL/SQL™, Pro*Ada®, Pro*C™, Pro*C/C++™, Pro*COBOL®, Pro*FORTRAN®, Pro*Pascal®, Pro*PL/1®, Pro*REXX®, Profit™, ProREXX™, Report Card™, Secure Access 2.0™, Secure Network Services®, Security Without Compromise™, SellingPoint®, SQL*Plus®, Tutor™ are trademarks or registered trademarks of Oracle. Other names may be trademarks of their respective owners. The absence of a product or service name, slogan, or logo from this list does not constitute a waiver of Oracle's trademark or other intellectual property rights concerning that name, slogan, or logo.
Description: | This table contains records of the account owners of the external bank accounts entered manually. This table corresponds to the Banking details page of supplier or customer. When an external bank account is created a row will be stored in |
---|
Foreign Key Column | Foreign Table |
---|---|
IBY_ACCOUNT_OWNERS.EXT_BANK_ACCOUNT_ID | IBY_EXT_BANK_ACCOUNTS |
IBY_ACCOUNT_OWNERS.ACCOUNT_OWNER_PARTY_ID | HZ_PARTIES |
IBY.IBY_ACCOUNT_OWNERS does not reference any database object
IBY.IBY_ACCOUNT_OWNERS is referenced by following:
Description: | IBY_ACCPPMTMTHD contains a list of all the payment instrument methods that are accepted by a iPayment. |
---|
Foreign Key Column | Foreign Table |
---|---|
IBY_ACCPPMTMTHD.MPAYEEID | IBY_PAYEE |
IBY_ACCPPMTMTHD.ACCTTYPEID | IBY_ACCTTYPE |
IBY.IBY_ACCPPMTMTHD does not reference any database object
IBY.IBY_ACCPPMTMTHD is referenced by following:
Description: | IBY_ACCTTYPE contains a list of various account types supported. For example for bank account, the account types could be Checking, Savings etc, for Credit Card, the account types could be Visa, MasterCard, Discover etc... |
---|
Foreign Key Column | Foreign Table |
---|---|
IBY_ACCPPMTMTHD.ACCTTYPEID | IBY_ACCTTYPE |
IBY_BANKACCT.ACCTTYPEID | IBY_ACCTTYPE |
IBY_CREDITCARD.ACCTTYPEID | IBY_ACCTTYPE |
IBY.IBY_ACCTTYPE does not reference any database object
IBY.IBY_ACCTTYPE is referenced by following:
Description: | IBY_ACCT_PMT_PROFILES stores account-related information that completes the specification of the handling of payment instructions. Entries in this table are based on entries in the IBY_SYS_PMT_PROFILES table. A combination of the two tables |
---|
Foreign Key Column | Foreign Table |
---|---|
IBY_ACCT_PMT_PROFILES_B.SYSTEM_PROFILE_CODE | IBY_SYS_PMT_PROFILES_B |
IBY_ACCT_PMT_PROFILES_B.BEP_ACCOUNT_ID | IBY_BEPKEYS |
IBY_ACCT_PMT_PROFILES_B.TRANSMIT_CONFIGURATION_ID | IBY_TRANSMIT_CONFIGS_B |
Foreign Key Column | Foreign Table |
---|---|
IBY_ACCT_PMT_PROFILES_TL.PAYMENT_PROFILE_ID | IBY_ACCT_PMT_PROFILES_B |
IBY_DOCS_PAYABLE_ALL.PAYMENT_PROFILE_ID | IBY_ACCT_PMT_PROFILES_B |
IBY_DOCUMENTS_PAYABLE_H.PAYMENT_PROFILE_ID | IBY_ACCT_PMT_PROFILES_B |
IBY_PAYMENTS_ALL.PAYMENT_PROFILE_ID | IBY_ACCT_PMT_PROFILES_B |
IBY_PAY_INSTRUCTIONS_ALL.PAYMENT_PROFILE_ID | IBY_ACCT_PMT_PROFILES_B |
IBY_PAY_SERVICE_REQUESTS.PAYMENT_PROFILE_ID | IBY_ACCT_PMT_PROFILES_B |
IBY.IBY_ACCT_PMT_PROFILES_B does not reference any database object
IBY.IBY_ACCT_PMT_PROFILES_B is referenced by following:
Description: | IBY_ACCT_PMT_PROFILES stores account-related information that completes the specification of the handling of payment instructions. Entries in this table are based on entries in the IBY_SYS_PMT_PROFILES table. A combination of the two tables |
---|
Foreign Key Column | Foreign Table |
---|---|
IBY_ACCT_PMT_PROFILES_TL.PAYMENT_PROFILE_ID | IBY_ACCT_PMT_PROFILES_B |
IBY.IBY_ACCT_PMT_PROFILES_TL does not reference any database object
IBY.IBY_ACCT_PMT_PROFILES_TL is referenced by following:
Description: | Provided to store acknowledgement information at payment level. |
---|
IBY.IBY_ACK_PMT_ALL does not reference any database object
IBY.IBY_ACK_PMT_ALL is referenced by following:
Description: | Provided to store acknowledgement error(s) information at payment level. |
---|
IBY.IBY_ACK_PMT_ERRORS does not reference any database object
IBY.IBY_ACK_PMT_ERRORS is referenced by following:
Description: |
---|
Foreign Key Column | Foreign Table |
---|---|
IBY_FNDCPT_SYS_CC_PF_B.SETTLEMENT_ACK_RDR_CODE | IBY_ACK_READERS |
IBY_FNDCPT_SYS_CC_PF_B.QUERY_ACK_RDR_CODE | IBY_ACK_READERS |
IBY.IBY_ACK_READERS does not reference any database object
IBY.IBY_ACK_READERS is referenced by following:
Description: | IBY_ACTIVITY stores scheduler related activities. |
---|
IBY.IBY_ACTIVITY does not reference any database object
IBY.IBY_ACTIVITY is referenced by following:
Description: | IBY_APPLICABLE_PMT_MTHDS stores the payment method applicability information for company policy-based factors. The factors include First Party Legal Entity, First Party Organization, Payment Processing Transaction Type, Transaction is Forei |
---|
Foreign Key Column | Foreign Table |
---|---|
IBY_APPLICABLE_PMT_MTHDS.PAYMENT_METHOD_CODE | IBY_PAYMENT_METHODS_B |
IBY_APPLICABLE_PMT_MTHDS.APPLICATION_ID | FND_APPLICATION |
IBY.IBY_APPLICABLE_PMT_MTHDS does not reference any database object
IBY.IBY_APPLICABLE_PMT_MTHDS is referenced by following:
Description: | IBY_APPLICABLE_PMT_PROFS maps payment methods to payment process profiles. Since administrators can define both payment methods and payment process profiles, they must also choose which payment process profiles are associated with each paym |
---|
Foreign Key Column | Foreign Table |
---|---|
IBY_APPLICABLE_PMT_PROFS.SYSTEM_PROFILE_CODE | IBY_SYS_PMT_PROFILES_B |
IBY.IBY_APPLICABLE_PMT_PROFS does not reference any database object
IBY.IBY_APPLICABLE_PMT_PROFS is referenced by following:
Description: |
---|
IBY.IBY_AR_DOC_HEADER_GT1 does not reference any database object
IBY.IBY_AR_DOC_HEADER_GT1 is referenced by following:
Description: |
---|
APPS.IBY_AR_DOC_LINES_GT does not reference any database object
APPS.IBY_AR_DOC_LINES_GT is referenced by following:
Description: | IBY_BANKACCOUNTstores bank account related information of the customer(payer) or payee. |
---|
Foreign Key Column | Foreign Table |
---|---|
IBY_BANKACCT.ADDRESSID | HZ_LOCATIONS |
IBY_BANKACCT.ACCTTYPEID | IBY_ACCTTYPE |
Foreign Key Column | Foreign Table |
---|---|
IBY_INSTRHOLDER.INSTRID | IBY_BANKACCT |
IBY.IBY_BANKACCT does not reference any database object
IBY.IBY_BANKACCT is referenced by following:
Description: | Provided to store Mapping of acknowledgement codes to ISO codes. |
---|
IBY.IBY_BANK_ACK_STATUSES does not reference any database object
IBY.IBY_BANK_ACK_STATUSES is referenced by following:
Description: | IBY_BANK_INSTRUCTIONS stores bank instructions that are used as lookup values for payment process profiles and external payee setup. This table corresponds to the Bank Instruction Codes page. |
---|
Foreign Key Column | Foreign Table |
---|---|
IBY_BANK_INSTRUCTIONS_B.TERRITORY_CODE | FND_TERRITORIES |
Foreign Key Column | Foreign Table |
---|---|
IBY_BANK_INSTRUCTIONS_TL.BANK_INSTRUCTION_CODE | IBY_BANK_INSTRUCTIONS_B |
IBY_EXTERNAL_PAYEES_ALL.BANK_INSTRUCTION1_CODE | IBY_BANK_INSTRUCTIONS_B |
IBY_EXTERNAL_PAYEES_ALL.BANK_INSTRUCTION2_CODE | IBY_BANK_INSTRUCTIONS_B |
IBY_PAYMENTS_H.BANK_INSTRUCTION1_CODE | IBY_BANK_INSTRUCTIONS_B |
IBY_PAYMENTS_H.BANK_INSTRUCTION2_CODE | IBY_BANK_INSTRUCTIONS_B |
IBY_SYS_PMT_PROFILES_B.BANK_INSTRUCTION1_CODE | IBY_BANK_INSTRUCTIONS_B |
IBY_SYS_PMT_PROFILES_B.BANK_INSTRUCTION2_CODE | IBY_BANK_INSTRUCTIONS_B |
IBY_TEMP_EXT_PAYEES.BANK_INSTRUCTION1_CODE | IBY_BANK_INSTRUCTIONS_B |
IBY_TEMP_EXT_PAYEES.BANK_INSTRUCTION2_CODE | IBY_BANK_INSTRUCTIONS_B |
IBY.IBY_BANK_INSTRUCTIONS_B does not reference any database object
IBY.IBY_BANK_INSTRUCTIONS_B is referenced by following:
Description: | IBY_BANK_INSTRUCTIONS stores bank instructions that are used as lookup values for payment process profiles and external payee setup. This table corresponds to the Bank Instruction Codes page. |
---|
Foreign Key Column | Foreign Table |
---|---|
IBY_BANK_INSTRUCTIONS_TL.BANK_INSTRUCTION_CODE | IBY_BANK_INSTRUCTIONS_B |
IBY.IBY_BANK_INSTRUCTIONS_TL does not reference any database object
IBY.IBY_BANK_INSTRUCTIONS_TL is referenced by following:
Description: | "This table contains records of the settlement batch information which is updated by system while processing 'Create settlement Batches' program.IBY_BATCHES_ALL stores information about batch operations for credit cards and bank account tra |
---|
Foreign Key Column | Foreign Table |
---|---|
IBY_BATCHES_ALL.BEPID | IBY_BEPINFO |
IBY_BATCHES_ALL.MPAYEEID | IBY_PAYEE |
Foreign Key Column | Foreign Table |
---|---|
IBY_PAY_BATCHES_ALL.IBY_BATCH_ID
IBY_PAY_BATCHES_ALL.PAYER_ID |
IBY_BATCHES_ALL |
IBY_TRXN_SUMMARIES_ALL.MBATCHID | IBY_BATCHES_ALL |
IBY.IBY_BATCHES_ALL does not reference any database object
IBY.IBY_BATCHES_ALL is referenced by following:
Description: | IBY_BEPKEYS stores information about the payment systems. |
---|
Foreign Key Column | Foreign Table |
---|---|
IBY_BEPINFO.PARTY_ID | HZ_PARTIES |
IBY_BEPINFO.BANK_ID | HZ_PARTIES |
Foreign Key Column | Foreign Table |
---|---|
IBY_BATCHES_ALL.BEPID | IBY_BEPINFO |
IBY_BEPKEYS.BEPID | IBY_BEPINFO |
IBY_BEPLANGS.BEPID | IBY_BEPINFO |
IBY_BEP_ACCT_OPT_NAME_B.BEPID | IBY_BEPINFO |
IBY_DEFAULT_BEP.BEPID | IBY_BEPINFO |
IBY_FNDCPT_SYS_DC_PF_B.PAYMENT_SYSTEM_ID | IBY_BEPINFO |
IBY_FNDCPT_SYS_EFT_PF_B.PAYMENT_SYSTEM_ID | IBY_BEPINFO |
IBY_PAY_INSTRUCTIONS_H.BEPID | IBY_BEPINFO |
IBY_PMTSCHEMES.BEPID | IBY_BEPINFO |
IBY_PMT_SYS_FORMATS.PAYMENT_SYSTEM_ID | IBY_BEPINFO |
IBY_PMT_SYS_TRANSMISSIONS.BEPID | IBY_BEPINFO |
IBY_ROUTINGINFO.BEPID | IBY_BEPINFO |
IBY_SYS_PMT_PROFILES_B.BEPID | IBY_BEPINFO |
IBY_TRXN_SUMMARIES_ALL.BEPID | IBY_BEPINFO |
IBY_TRXN_SUMMARIES_ALL.BEPID | IBY_BEPINFO |
IBY.IBY_BEPINFO does not reference any database object
IBY.IBY_BEPINFO is referenced by following:
Description: | IBY_BEPKEYS stores information about the payment systems accounts. |
---|
Foreign Key Column | Foreign Table |
---|---|
IBY_BEPKEYS.BEPID | IBY_BEPINFO |
Foreign Key Column | Foreign Table |
---|---|
IBY_ACCT_PMT_PROFILES_B.BEP_ACCOUNT_ID | IBY_BEPKEYS |
IBY_BEP_ACCT_OPT_VALS.BEP_ACCOUNT_ID | IBY_BEPKEYS |
IBY_DEFAULT_BEP.BEP_ACCOUNT_ID | IBY_BEPKEYS |
IBY_FNDCPT_USER_CC_PF_B.BEP_ACCOUNT_ID | IBY_BEPKEYS |
IBY_FNDCPT_USER_DC_PF_B.BEP_ACCOUNT_ID | IBY_BEPKEYS |
IBY_FNDCPT_USER_EFT_PF_B.BEP_ACCOUNT_ID | IBY_BEPKEYS |
IBY.IBY_BEPKEYS does not reference any database object
IBY.IBY_BEPKEYS is referenced by following:
Description: | IBY_BEPLANGS contains list of all the languages supported by the Back End Payment System |
---|
Foreign Key Column | Foreign Table |
---|---|
IBY_BEPLANGS.BEPID | IBY_BEPINFO |
IBY.IBY_BEPLANGS does not reference any database object
IBY.IBY_BEPLANGS is referenced by following:
Description: |
---|
Foreign Key Column | Foreign Table |
---|---|
IBY_BEP_ACCT_OPT_NAME_B.BEPID | IBY_BEPINFO |
Foreign Key Column | Foreign Table |
---|---|
IBY_BEP_ACCT_OPT_NAME_TL.ACCOUNT_OPTION_CODE
IBY_BEP_ACCT_OPT_NAME_TL.BEPID |
IBY_BEP_ACCT_OPT_NAME_B |
IBY.IBY_BEP_ACCT_OPT_NAME_B does not reference any database object
IBY.IBY_BEP_ACCT_OPT_NAME_B is referenced by following:
Description: |
---|
Foreign Key Column | Foreign Table |
---|---|
IBY_BEP_ACCT_OPT_NAME_TL.ACCOUNT_OPTION_CODE
IBY_BEP_ACCT_OPT_NAME_TL.BEPID |
IBY_BEP_ACCT_OPT_NAME_B |
IBY.IBY_BEP_ACCT_OPT_NAME_TL does not reference any database object
IBY.IBY_BEP_ACCT_OPT_NAME_TL is referenced by following:
Description: |
---|
Foreign Key Column | Foreign Table |
---|---|
IBY_BEP_ACCT_OPT_VALS.BEP_ACCOUNT_ID | IBY_BEPKEYS |
IBY_BEP_ACCT_OPT_VALS.VAL_SEC_SEGMENT_ID | IBY_SECURITY_SEGMENTS |
IBY.IBY_BEP_ACCT_OPT_VALS does not reference any database object
IBY.IBY_BEP_ACCT_OPT_VALS is referenced by following:
Description: | Table contains card ranges for various credit card issuers. Used to remove structure from a credit card number before it is encrypted. |
---|
Foreign Key Column | Foreign Table |
---|---|
IBY_CC_ISSUER_RANGES.CARD_ISSUER_CODE | IBY_CREDITCARD_ISSUERS_B |
Foreign Key Column | Foreign Table |
---|---|
IBY_CREDITCARD.CC_ISSUER_RANGE_ID | IBY_CC_ISSUER_RANGES |
IBY_TRXN_SUMMARIES_ALL.CC_ISSUER_RANGE_ID | IBY_CC_ISSUER_RANGES |
IBY.IBY_CC_ISSUER_RANGES does not reference any database object
IBY.IBY_CC_ISSUER_RANGES is referenced by following:
Description: | IBY_CREDITACRD stores Credit Card related information of the customer(payer) or payee. |
---|
Foreign Key Column | Foreign Table |
---|---|
IBY_CREDITCARD.ACCTTYPEID | IBY_ACCTTYPE |
IBY_CREDITCARD.CHNAME_SEC_SEGMENT_ID | IBY_SECURITY_SEGMENTS |
IBY_CREDITCARD.ADDRESSID | HZ_PARTY_SITE_USES |
IBY_CREDITCARD.CARD_OWNER_ID | HZ_PARTIES |
IBY_CREDITCARD.CARD_ISSUER_CODE | IBY_CREDITCARD_ISSUERS_B |
IBY_CREDITCARD.CC_ISSUER_RANGE_ID | IBY_CC_ISSUER_RANGES |
IBY_CREDITCARD.CC_NUM_SEC_SEGMENT_ID | % |
IBY_CREDITCARD.BILL_ADDR_TERRITORY_CODE | FND_TERRITORIES |
IBY_CREDITCARD.UPGRADE_ADDRESSID | HZ_LOCATIONS |
IBY_CREDITCARD.EXPIRY_SEC_SEGMENT_ID | IBY_SECURITY_SEGMENTS |
Foreign Key Column | Foreign Table |
---|---|
AP_CARDS_ALL.CARD_REFERENCE_ID | IBY_CREDITCARD |
IBY_CREDITCARD_H.INSTRID | IBY_CREDITCARD |
IBY_INSTRHOLDER.INSTRID | IBY_CREDITCARD |
IBY.IBY_CREDITCARD does not reference any database object
IBY.IBY_CREDITCARD is referenced by following:
Description: | Holds historical data for credit cards |
---|
Foreign Key Column | Foreign Table |
---|---|
IBY_CREDITCARD_H.INSTRID | IBY_CREDITCARD |
IBY_CREDITCARD_H.ADDRESSID | HZ_PARTY_SITE_USES |
IBY_CREDITCARD_H.CARD_ISSUER_CODE | IBY_CREDITCARD_ISSUERS_B |
IBY_CREDITCARD_H.CARD_OWNER_ID | HZ_PARTIES |
IBY_CREDITCARD_H.CHNAME_SEC_SEGMENT_ID | IBY_SECURITY_SEGMENTS |
IBY.IBY_CREDITCARD_H does not reference any database object
IBY.IBY_CREDITCARD_H is referenced by following:
Description: | Holds the list of accepted card brands |
---|
Foreign Key Column | Foreign Table |
---|---|
IBY_CC_ISSUER_RANGES.CARD_ISSUER_CODE | IBY_CREDITCARD_ISSUERS_B |
IBY_CREDITCARD.CARD_ISSUER_CODE | IBY_CREDITCARD_ISSUERS_B |
IBY_CREDITCARD_H.CARD_ISSUER_CODE | IBY_CREDITCARD_ISSUERS_B |
IBY_CREDITCARD_ISSUERS_TL.CARD_ISSUER_CODE | IBY_CREDITCARD_ISSUERS_B |
IBY.IBY_CREDITCARD_ISSUERS_B does not reference any database object
IBY.IBY_CREDITCARD_ISSUERS_B is referenced by following:
Description: | Holds the list of accepted card brands |
---|
Foreign Key Column | Foreign Table |
---|---|
IBY_CREDITCARD_ISSUERS_TL.CARD_ISSUER_CODE | IBY_CREDITCARD_ISSUERS_B |
IBY.IBY_CREDITCARD_ISSUERS_TL does not reference any database object
IBY.IBY_CREDITCARD_ISSUERS_TL is referenced by following:
Description: | This table holds the mandate information for the bank accounts |
---|
IBY.IBY_DEBIT_AUTHORIZATIONS does not reference any database object
IBY.IBY_DEBIT_AUTHORIZATIONS is referenced by following:
Description: | IBY_DEFAULT_BEP stores information that will allow a payment system account and funds capture process profile to be derived for a transaction should the routing rules fail to yield them. |
---|
Foreign Key Column | Foreign Table |
---|---|
IBY_DEFAULT_BEP.BEPID | IBY_BEPINFO |
IBY_DEFAULT_BEP.MPAYEEID | IBY_PAYEE |
IBY_DEFAULT_BEP.BEP_ACCOUNT_ID | IBY_BEPKEYS |
IBY.IBY_DEFAULT_BEP does not reference any database object
IBY.IBY_DEFAULT_BEP is referenced by following:
Description: | IBY_DELIVERY_CHANNELS stores delivery channel information that is used as lookup values for external payee setup or documents payable. The table is similar to FND_LOOKUPS, but with a new column for territory identification. Products that us |
---|
Foreign Key Column | Foreign Table |
---|---|
IBY_DELIVERY_CHANNELS_B.TERRITORY_CODE | FND_TERRITORIES |
Foreign Key Column | Foreign Table |
---|---|
IBY_DELIVERY_CHANNELS_TL.DELIVERY_CHANNEL_CODE | IBY_DELIVERY_CHANNELS_B |
IBY_DOCS_PAYABLE_ALL.DELIVERY_CHANNEL_CODE | IBY_DELIVERY_CHANNELS_B |
IBY_EXTERNAL_PAYEES_ALL.DELIVERY_CHANNEL_CODE | IBY_DELIVERY_CHANNELS_B |
IBY_PAYMENTS_ALL.DELIVERY_CHANNEL_CODE | IBY_DELIVERY_CHANNELS_B |
IBY_TEMP_EXT_PAYEES.DELIVERY_CHANNEL_CODE | IBY_DELIVERY_CHANNELS_B |
IBY.IBY_DELIVERY_CHANNELS_B does not reference any database object
IBY.IBY_DELIVERY_CHANNELS_B is referenced by following:
Description: | IBY_DELIVERY_CHANNELS stores delivery channel information that is used as lookup values for external payee setup or documents payable. The table is similar to FND_LOOKUPS, but with a new column for territory identification. Products that us |
---|
Foreign Key Column | Foreign Table |
---|---|
IBY_DELIVERY_CHANNELS_TL.DELIVERY_CHANNEL_CODE | IBY_DELIVERY_CHANNELS_B |
IBY.IBY_DELIVERY_CHANNELS_TL does not reference any database object
IBY.IBY_DELIVERY_CHANNELS_TL is referenced by following:
Description: | "This table contains records of the documents payable which are updated by system while processing 'Build payments' program. IBY_DOCS_PAYABLE_ALL stores Oracle Payments' representation of source products' documents payable. A document pay |
---|
Foreign Key Column | Foreign Table |
---|---|
IBY_DOCS_PAYABLE_ALL.CALLING_APP_ID
IBY_DOCS_PAYABLE_ALL.PAY_PROC_TRXN_TYPE_CODE |
IBY_TRXN_TYPES_B |
IBY_DOCS_PAYABLE_ALL.PAYMENT_SERVICE_REQUEST_ID | IBY_PAY_SERVICE_REQUESTS |
IBY_DOCS_PAYABLE_ALL.EXTERNAL_BANK_ACCOUNT_ID | CE_BANK_ACCOUNTS |
IBY_DOCS_PAYABLE_ALL.FORMATTING_PAYMENT_ID | IBY_PAYMENTS_ALL |
IBY_DOCS_PAYABLE_ALL.PAYMENT_METHOD_CODE | IBY_PAYMENT_METHODS_B |
IBY_DOCS_PAYABLE_ALL.PAYMENT_PROFILE_ID | IBY_ACCT_PMT_PROFILES_B |
IBY_DOCS_PAYABLE_ALL.PAYMENT_ID | IBY_PAYMENTS_ALL |
IBY_DOCS_PAYABLE_ALL.EXT_PAYEE_ID | IBY_EXTERNAL_PAYEES_ALL |
IBY_DOCS_PAYABLE_ALL.PAYMENT_REASON_CODE | IBY_PAYMENT_REASONS_B |
IBY_DOCS_PAYABLE_ALL.DELIVERY_CHANNEL_CODE | IBY_DELIVERY_CHANNELS_B |
IBY_DOCS_PAYABLE_ALL.PAYMENT_FORMAT_CODE | IBY_FORMATS_B |
IBY_DOCS_PAYABLE_ALL.INTERNAL_BANK_ACCOUNT_ID | CE_BANK_ACCOUNTS |
Foreign Key Column | Foreign Table |
---|---|
IBY_DOCUMENT_LINES.DOCUMENT_PAYABLE_ID | IBY_DOCS_PAYABLE_ALL |
IBY_DOCUMENT_LINES_H.DOCUMENT_PAYABLE_ID | IBY_DOCS_PAYABLE_ALL |
IBY.IBY_DOCS_PAYABLE_ALL does not reference any database object
IBY.IBY_DOCS_PAYABLE_ALL is referenced by following:
Description: |
---|
IBY.IBY_DOCS_PAYABLE_GT does not reference any database object
IBY.IBY_DOCS_PAYABLE_GT is referenced by following:
Description: |
---|
IBY.IBY_DOCS_PAYABLE_VAL_GT1 does not reference any database object
IBY.IBY_DOCS_PAYABLE_VAL_GT1 is referenced by following:
Description: | IBY_DOCUMENTS_PAYABLE_H stores historical snapshots of documents payable. This table contains denormalized versions of documents payable from specific points in time, such as when the payment for this document was submitted to a payment sys |
---|
Foreign Key Column | Foreign Table |
---|---|
IBY_DOCUMENTS_PAYABLE_H.PAYMENT_PROFILE_ID | IBY_ACCT_PMT_PROFILES_B |
IBY_DOCUMENTS_PAYABLE_H.PAYMENT_ID | IBY_PAYMENTS_ALL |
IBY_DOCUMENTS_PAYABLE_H.PAYMENT_HISTORY_ID | IBY_PAYMENTS_H |
IBY_DOCUMENTS_PAYABLE_H.PAYMENT_METHOD_CODE | IBY_PAYMENT_METHODS_B |
IBY_DOCUMENTS_PAYABLE_H.CALLING_APP_ID
IBY_DOCUMENTS_PAYABLE_H.PAY_PROC_TRXN_TYPE_CODE |
IBY_TRXN_TYPES_B |
IBY_DOCUMENTS_PAYABLE_H.PAYMENT_SERVICE_REQUEST_ID | IBY_PAY_SERVICE_REQUESTS |
IBY_DOCUMENTS_PAYABLE_H.COUNTRY | FND_TERRITORIES |
Foreign Key Column | Foreign Table |
---|---|
IBY_DOCUMENT_LINES_H.DOCUMENT_PAYABLE_HISTORY_ID | IBY_DOCUMENTS_PAYABLE_H |
IBY.IBY_DOCUMENTS_PAYABLE_H does not reference any database object
IBY.IBY_DOCUMENTS_PAYABLE_H is referenced by following:
Description: | IBY_DOCUMENT_LINES stores Oracle Payments' representation of individual line items for documents payable, such as invoice lines for an Oracle Payables invoice. This information is passed according to payment format, but is not used to affec |
---|
Foreign Key Column | Foreign Table |
---|---|
IBY_DOCUMENT_LINES.DOCUMENT_PAYABLE_ID | IBY_DOCS_PAYABLE_ALL |
IBY.IBY_DOCUMENT_LINES does not reference any database object
IBY.IBY_DOCUMENT_LINES is referenced by following:
Description: | IBY_DOCUMENT_LINES_H stores historical snapshots of document line items. This table contains denormalized versions of document lines from specific points in time, including when the payment for the associated document was submitted to a pay |
---|
Foreign Key Column | Foreign Table |
---|---|
IBY_DOCUMENT_LINES_H.DOCUMENT_PAYABLE_ID | IBY_DOCS_PAYABLE_ALL |
IBY_DOCUMENT_LINES_H.DOCUMENT_PAYABLE_HISTORY_ID | IBY_DOCUMENTS_PAYABLE_H |
IBY.IBY_DOCUMENT_LINES_H does not reference any database object
IBY.IBY_DOCUMENT_LINES_H is referenced by following:
Description: | IBY_ECAPP stores information about Electronic Commerce Applications registered with iPayment. Oracle Applications which integrate with iPayment directly - via iPayment Java and PL/SQL API's are treated as EC applications by iPayment. They w |
---|
Foreign Key Column | Foreign Table |
---|---|
IBY_PAYEE.ECAPPID | IBY_ECAPP |
IBY.IBY_ECAPP does not reference any database object
IBY.IBY_ECAPP is referenced by following:
Description: | "This table contains payment details of an external payee automatically created by the source product. For example when supplier or supplier site is created manually system automatically inserts row in to the IBY_EXTERNAL_PAYEES_ALL table. |
---|
Foreign Key Column | Foreign Table |
---|---|
IBY_EXTERNAL_PAYEES_ALL.BANK_INSTRUCTION1_CODE | IBY_BANK_INSTRUCTIONS_B |
IBY_EXTERNAL_PAYEES_ALL.DEFAULT_PAYMENT_METHOD_CODE | IBY_PAYMENT_METHODS_B |
IBY_EXTERNAL_PAYEES_ALL.BANK_INSTRUCTION2_CODE | IBY_BANK_INSTRUCTIONS_B |
IBY_EXTERNAL_PAYEES_ALL.PAYMENT_REASON_CODE | IBY_PAYMENT_REASONS_B |
IBY_EXTERNAL_PAYEES_ALL.DELIVERY_CHANNEL_CODE | IBY_DELIVERY_CHANNELS_B |
IBY_EXTERNAL_PAYEES_ALL.PAYMENT_FORMAT_CODE | IBY_FORMATS_B |
Foreign Key Column | Foreign Table |
---|---|
FV_TPP_ASSIGNMENTS_ALL.EXT_PAYEE_ID | IBY_EXTERNAL_PAYEES_ALL |
IBY_DOCS_PAYABLE_ALL.EXT_PAYEE_ID | IBY_EXTERNAL_PAYEES_ALL |
IBY_EXT_PARTY_PMT_MTHDS.EXT_PMT_PARTY_ID | IBY_EXTERNAL_PAYEES_ALL |
IBY_PAYMENTS_ALL.EXT_PAYEE_ID | IBY_EXTERNAL_PAYEES_ALL |
IBY.IBY_EXTERNAL_PAYEES_ALL does not reference any database object
IBY.IBY_EXTERNAL_PAYEES_ALL is referenced by following:
Description: | "This table contains payment details of an external payer automatically created by the source product. For example when customer or customer site is created manually, system automatically insert row in to the IBY_EXTERNAL_PAYERS_ALL table. |
---|
Foreign Key Column | Foreign Table |
---|---|
IBY_EXTERNAL_PAYERS_ALL.PARTY_ID | HZ_PARTIES |
IBY_EXTERNAL_PAYERS_ALL.CUST_ACCOUNT_ID | HZ_CUST_ACCOUNTS |
IBY_EXTERNAL_PAYERS_ALL.ACCT_SITE_USE_ID | HZ_CUST_SITE_USES_ALL |
IBY.IBY_EXTERNAL_PAYERS_ALL does not reference any database object
IBY.IBY_EXTERNAL_PAYERS_ALL is referenced by following:
Description: | Defines data extracts for payment file creation |
---|
Foreign Key Column | Foreign Table |
---|---|
IBY_EXTRACTS_TL.EXTRACT_ID | IBY_EXTRACTS_B |
IBY_FORMATS_B.EXTRACT_ID | IBY_EXTRACTS_B |
IBY.IBY_EXTRACTS_B does not reference any database object
IBY.IBY_EXTRACTS_B is referenced by following:
Description: |
---|
Foreign Key Column | Foreign Table |
---|---|
IBY_EXTRACTS_TL.EXTRACT_ID | IBY_EXTRACTS_B |
IBY.IBY_EXTRACTS_TL does not reference any database object
IBY.IBY_EXTRACTS_TL is referenced by following:
Description: | IBY_EXTRACT_ACTIVATIONS defines which computed fields within an extract are unnecessary for a particular format, with each row corresponding to a single field for that extract. When the extract engine is called for a particular format, ever |
---|
Foreign Key Column | Foreign Table |
---|---|
IBY_EXTRACT_ACTIVATIONS.FORMAT_CODE | IBY_FORMATS_B |
IBY.IBY_EXTRACT_ACTIVATIONS does not reference any database object
IBY.IBY_EXTRACT_ACTIVATIONS is referenced by following:
Description: | "This table contains records of the external bank accounts entered manually. This table corresponds to the Banking details page of supplier or customer. This table contains bank, branch, masking, encryption details of the external bank acc |
---|
Foreign Key Column | Foreign Table |
---|---|
IBY_EXT_BANK_ACCOUNTS.BA_NUM_SEC_SEGMENT_ID | IBY_SECURITY_SEGMENTS |
IBY_EXT_BANK_ACCOUNTS.IBAN_SEC_SEGMENT_ID | IBY_SECURITY_SEGMENTS |
IBY_EXT_BANK_ACCOUNTS.BA_NUM_ELEC_SEC_SEGMENT_ID | IBY_SECURITY_SEGMENTS |
Foreign Key Column | Foreign Table |
---|---|
AR_CASH_RECEIPTS_ALL.CUSTOMER_BANK_ACCOUNT_ID | IBY_EXT_BANK_ACCOUNTS |
AR_INTERIM_CASH_RECEIPTS_ALL.CUSTOMER_BANK_ACCOUNT_ID | IBY_EXT_BANK_ACCOUNTS |
AR_PAYMENTS_INTERFACE_ALL.CUSTOMER_BANK_ACCOUNT_ID | IBY_EXT_BANK_ACCOUNTS |
IBY_ACCOUNT_OWNERS.EXT_BANK_ACCOUNT_ID | IBY_EXT_BANK_ACCOUNTS |
IBY_INTERMEDIARY_ACCTS.BANK_ACCT_ID | IBY_EXT_BANK_ACCOUNTS |
POS_ACNT_ADDR_SUMM_REQ.EXT_BANK_ACCOUNT_ID | IBY_EXT_BANK_ACCOUNTS |
IBY.IBY_EXT_BANK_ACCOUNTS does not reference any database object
IBY.IBY_EXT_BANK_ACCOUNTS is referenced by following:
Description: | IBY_EXT_PARTY_PMT_MTHDS stores payment method applicability driven by the preferences of the external party. A payment method is applicable to a party and payment function combination and, optionally and additionally, to a party site and/or |
---|
Foreign Key Column | Foreign Table |
---|---|
IBY_EXT_PARTY_PMT_MTHDS.EXT_PMT_PARTY_ID | IBY_EXTERNAL_PAYEES_ALL |
IBY_EXT_PARTY_PMT_MTHDS.PAYMENT_METHOD_CODE | IBY_PAYMENT_METHODS_B |
IBY.IBY_EXT_PARTY_PMT_MTHDS does not reference any database object
IBY.IBY_EXT_PARTY_PMT_MTHDS is referenced by following:
Description: | "This table stores information about third party payment related relationships and related attributes. IBY_EXT_PAYEE_RELATIONSHIPS contain third payment relationships entered manually using the Relationship region in the supplier page. Eac |
---|
IBY.IBY_EXT_PAYEE_RELATIONSHIPS does not reference any database object
IBY.IBY_EXT_PAYEE_RELATIONSHIPS is referenced by following:
Description: | IBY_FNDCPT_PAYEE_APPL is a mapping table between internal payees and operating units. One payee may be associated with many operating units. An operating unit may be associated with at most one payee. |
---|
Foreign Key Column | Foreign Table |
---|---|
IBY_FNDCPT_PAYEE_APPL.MPAYEEID | IBY_PAYEE |
IBY.IBY_FNDCPT_PAYEE_APPL does not reference any database object
IBY.IBY_FNDCPT_PAYEE_APPL is referenced by following:
Description: | IBY_FNDCPT_PMT_CHNNLS defines all payment methods for the funds capture flow. Payment methods are categorized by instrument types. The instrument types are BANKACCOUNT, CREDITCARD, and DEBITCARD. Each payment method includes the attribute- |
---|
Foreign Key Column | Foreign Table |
---|---|
AR_RECEIPT_METHODS.PAYMENT_CHANNEL_CODE | IBY_FNDCPT_PMT_CHNNLS_B |
IBY_FNDCPT_TX_EXTENSIONS.PAYMENT_CHANNEL_CODE | IBY_FNDCPT_PMT_CHNNLS_B |
IBY.IBY_FNDCPT_PMT_CHNNLS_B does not reference any database object
IBY.IBY_FNDCPT_PMT_CHNNLS_B is referenced by following:
Description: | IBY_FNDCPT_PMT_CHNNLS defines all payment methods for the funds capture flow. Payment methods are categorized by instrument types. The instrument types are BANKACCOUNT, CREDITCARD, and DEBITCARD. Each payment method includes the attribute- |
---|
Foreign Key Column | Foreign Table |
---|---|
IBY_FNDCPT_PMT_CHNNLS_TL.PAYMENT_CHANNEL_CODE | % |
IBY.IBY_FNDCPT_PMT_CHNNLS_TL does not reference any database object
IBY.IBY_FNDCPT_PMT_CHNNLS_TL is referenced by following:
Description: |
---|
Foreign Key Column | Foreign Table |
---|---|
IBY_FNDCPT_SYS_CC_PF_B.SETTLEMENT_FORMAT_CODE | IBY_FORMATS_B |
IBY_FNDCPT_SYS_CC_PF_B.SETTLEMENT_TRANS_PRTCL_CODE | IBY_TRANSMIT_PROTOCOLS_B |
IBY_FNDCPT_SYS_CC_PF_B.SETTLEMENT_ACK_RDR_CODE | IBY_ACK_READERS |
IBY_FNDCPT_SYS_CC_PF_B.QUERY_FORMAT_CODE | IBY_FORMATS_B |
IBY_FNDCPT_SYS_CC_PF_B.QUERY_TRANS_PRTCL_CODE | IBY_TRANSMIT_PROTOCOLS_B |
IBY_FNDCPT_SYS_CC_PF_B.QUERY_ACK_RDR_CODE | IBY_ACK_READERS |
IBY_FNDCPT_SYS_CC_PF_B.PAYER_NOTIFICATION_FORMAT | IBY_FORMATS_B |
IBY.IBY_FNDCPT_SYS_CC_PF_B does not reference any database object
IBY.IBY_FNDCPT_SYS_CC_PF_B is referenced by following:
Description: |
---|
Foreign Key Column | Foreign Table |
---|---|
IBY_FNDCPT_SYS_CC_PF_TL.SYS_CC_PROFILE_CODE | % |
IBY.IBY_FNDCPT_SYS_CC_PF_TL does not reference any database object
IBY.IBY_FNDCPT_SYS_CC_PF_TL is referenced by following:
Description: |
---|
Foreign Key Column | Foreign Table |
---|---|
IBY_FNDCPT_SYS_DC_PF_B.PAYMENT_SYSTEM_ID | IBY_BEPINFO |
IBY_FNDCPT_SYS_DC_PF_B.QUERY_ACK_RDR_CODE | % |
IBY_FNDCPT_SYS_DC_PF_B.PAYER_NOTIFICATION_FORMAT | IBY_FORMATS_B |
IBY_FNDCPT_SYS_DC_PF_B.ONLINE_DEB_ACK_RDR_CODE | IBY_FORMATS_B |
IBY_FNDCPT_SYS_DC_PF_B.ONLINE_DEB_TRANS_PRTCL_CODE | IBY_TRANSMIT_PROTOCOLS_B |
IBY_FNDCPT_SYS_DC_PF_B.ONLINE_DEB_ACK_RDR_CODE | % |
IBY_FNDCPT_SYS_DC_PF_B.SETTLEMENT_FORMAT_CODE | IBY_FORMATS_B |
IBY_FNDCPT_SYS_DC_PF_B.SETTLEMENT_TRANS_PRTCL_CODE | IBY_TRANSMIT_PROTOCOLS_B |
IBY_FNDCPT_SYS_DC_PF_B.SETTLEMENT_ACK_RDR_CODE | % |
IBY_FNDCPT_SYS_DC_PF_B.QUERY_FORMAT_CODE | IBY_FORMATS_B |
IBY_FNDCPT_SYS_DC_PF_B.QUERY_TRANS_PRTCL_CODE | IBY_TRANSMIT_PROTOCOLS_B |
IBY.IBY_FNDCPT_SYS_DC_PF_B does not reference any database object
IBY.IBY_FNDCPT_SYS_DC_PF_B is referenced by following:
Description: |
---|
Foreign Key Column | Foreign Table |
---|---|
IBY_FNDCPT_SYS_DC_PF_TL.SYS_DC_PROFILE_CODE | % |
IBY.IBY_FNDCPT_SYS_DC_PF_TL does not reference any database object
IBY.IBY_FNDCPT_SYS_DC_PF_TL is referenced by following:
Description: |
---|
Foreign Key Column | Foreign Table |
---|---|
IBY_FNDCPT_SYS_EFT_PF_B.PAYMENT_SYSTEM_ID | IBY_BEPINFO |
IBY_FNDCPT_SYS_EFT_PF_B.QUERY_ACK_RDR_CODE | % |
IBY_FNDCPT_SYS_EFT_PF_B.PAYER_NOTIFICATION_FORMAT | IBY_FORMATS_B |
IBY_FNDCPT_SYS_EFT_PF_B.ACCOMPANY_LETTER_FORMAT | IBY_FORMATS_B |
IBY_FNDCPT_SYS_EFT_PF_B.VERIFY_FORMAT_CODE | IBY_FORMATS_B |
IBY_FNDCPT_SYS_EFT_PF_B.VERIFY_TRANS_PRTCL_CODE | IBY_TRANSMIT_PROTOCOLS_B |
IBY_FNDCPT_SYS_EFT_PF_B.VERIFY_ACK_RDR_CODE | % |
IBY_FNDCPT_SYS_EFT_PF_B.FUNDS_XFER_FORMAT_CODE | IBY_FORMATS_B |
IBY_FNDCPT_SYS_EFT_PF_B.FUNDS_XFER_TRANS_PRTCL_CODE | IBY_TRANSMIT_PROTOCOLS_B |
IBY_FNDCPT_SYS_EFT_PF_B.FUNDS_XFER_ACK_RDR_CODE | % |
IBY_FNDCPT_SYS_EFT_PF_B.QUERY_FORMAT_CODE | IBY_FORMATS_B |
IBY_FNDCPT_SYS_EFT_PF_B.QUERY_TRANS_PRTCL_CODE | IBY_TRANSMIT_PROTOCOLS_B |
IBY.IBY_FNDCPT_SYS_EFT_PF_B does not reference any database object
IBY.IBY_FNDCPT_SYS_EFT_PF_B is referenced by following:
Description: |
---|
Foreign Key Column | Foreign Table |
---|---|
IBY_FNDCPT_SYS_EFT_PF_TL.SYS_EFT_PROFILE_CODE | % |
IBY.IBY_FNDCPT_SYS_EFT_PF_TL does not reference any database object
IBY.IBY_FNDCPT_SYS_EFT_PF_TL is referenced by following:
Description: | "The data in this table will be created by the source products through the public API IBY_FNDCPT_TRXN_PUB, Create_Transaction_Extension and Copy_Transaction_Extension to register a Funds capture transaction. IBY_FNDCPT_TX_EXTENSIONS table |
---|
Foreign Key Column | Foreign Table |
---|---|
IBY_FNDCPT_TX_EXTENSIONS.PAYMENT_CHANNEL_CODE | IBY_FNDCPT_PMT_CHNNLS_B |
IBY_FNDCPT_TX_EXTENSIONS.INSTR_ASSIGNMENT_ID | IBY_PMT_INSTR_USES_ALL |
IBY_FNDCPT_TX_EXTENSIONS.ORIGIN_APPLICATION_ID | FND_APPLICATION |
IBY_FNDCPT_TX_EXTENSIONS.INSTR_CODE_SEC_SEGMENT_ID | IBY_SECURITY_SEGMENTS |
Foreign Key Column | Foreign Table |
---|---|
AR_CASH_RECEIPTS_ALL.PAYMENT_TRXN_EXTENSION_ID | IBY_FNDCPT_TX_EXTENSIONS |
AR_CC_ERROR_HISTORY.PAYMENT_TRXN_EXTENSION_ID | IBY_FNDCPT_TX_EXTENSIONS |
IBY_FNDCPT_TX_OPERATIONS.TRXN_EXTENSION_ID | IBY_FNDCPT_TX_EXTENSIONS |
IBY_FNDCPT_TX_XE_COPIES.COPY_TRXN_EXTENSION_ID | IBY_FNDCPT_TX_EXTENSIONS |
IBY_FNDCPT_TX_XE_COPIES.SOURCE_TRXN_EXTENSION_ID | IBY_FNDCPT_TX_EXTENSIONS |
IBY_TRXN_SUMMARIES_ALL.INITIATOR_EXTENSION_ID | IBY_FNDCPT_TX_EXTENSIONS |
RA_CUSTOMER_TRX_ALL.PAYMENT_TRXN_EXTENSION_ID | IBY_FNDCPT_TX_EXTENSIONS |
RA_CUSTOMER_TRX_LINES_ALL.PAYMENT_TRXN_EXTENSION_ID | IBY_FNDCPT_TX_EXTENSIONS |
RA_INTERFACE_LINES_ALL.PAYMENT_TRXN_EXTENSION_ID | IBY_FNDCPT_TX_EXTENSIONS |
IBY.IBY_FNDCPT_TX_EXTENSIONS does not reference any database object
IBY.IBY_FNDCPT_TX_EXTENSIONS is referenced by following:
Description: | IBY_FNDCPT_TX_OPERATIONS stores associations between transaction extension entities and authorization or settlement transactions. |
---|
Foreign Key Column | Foreign Table |
---|---|
IBY_FNDCPT_TX_OPERATIONS.TRXN_EXTENSION_ID | IBY_FNDCPT_TX_EXTENSIONS |
IBY.IBY_FNDCPT_TX_OPERATIONS does not reference any database object
IBY.IBY_FNDCPT_TX_OPERATIONS is referenced by following:
Description: | IBY_FNDCPT_TX_XE_COPIES stores the copy relationship between transaction extension entities. This relationship is many-to-many, since during copy transaction extension, entities may be merged or split. |
---|
Foreign Key Column | Foreign Table |
---|---|
IBY_FNDCPT_TX_XE_COPIES.COPY_TRXN_EXTENSION_ID | IBY_FNDCPT_TX_EXTENSIONS |
IBY_FNDCPT_TX_XE_COPIES.SOURCE_TRXN_EXTENSION_ID | IBY_FNDCPT_TX_EXTENSIONS |
IBY.IBY_FNDCPT_TX_XE_COPIES does not reference any database object
IBY.IBY_FNDCPT_TX_XE_COPIES is referenced by following:
Description: |
---|
Foreign Key Column | Foreign Table |
---|---|
IBY_FNDCPT_USER_CC_PF_B.SYS_CC_PROFILE_CODE | % |
IBY_FNDCPT_USER_CC_PF_B.BEP_ACCOUNT_ID | IBY_BEPKEYS |
IBY_FNDCPT_USER_CC_PF_B.ONLINE_AUTH_TRANS_CONFIG_ID | % |
IBY_FNDCPT_USER_CC_PF_B.SETTLEMENT_TRANS_CONFIG_ID | % |
IBY_FNDCPT_USER_CC_PF_B.QUERY_TRANS_CONFIG_ID | % |
IBY.IBY_FNDCPT_USER_CC_PF_B does not reference any database object
IBY.IBY_FNDCPT_USER_CC_PF_B is referenced by following:
Description: |
---|
Foreign Key Column | Foreign Table |
---|---|
IBY_FNDCPT_USER_CC_PF_TL.USER_CC_PROFILE_CODE | % |
IBY.IBY_FNDCPT_USER_CC_PF_TL does not reference any database object
IBY.IBY_FNDCPT_USER_CC_PF_TL is referenced by following:
Description: |
---|
Foreign Key Column | Foreign Table |
---|---|
IBY_FNDCPT_USER_DC_PF_B.SYS_DC_PROFILE_CODE | % |
IBY_FNDCPT_USER_DC_PF_B.BEP_ACCOUNT_ID | IBY_BEPKEYS |
IBY_FNDCPT_USER_DC_PF_B.ONLINE_DEB_TRANS_CONFIG_ID | % |
IBY_FNDCPT_USER_DC_PF_B.SETTLEMENT_TRANS_CONFIG_ID | % |
IBY_FNDCPT_USER_DC_PF_B.QUERY_TRANS_CONFIG_ID | % |
Foreign Key Column | Foreign Table |
---|---|
IBY_FNDCPT_USER_DC_PF_TL.USER_DC_PROFILE_CODE | IBY_FNDCPT_USER_DC_PF_B |
IBY.IBY_FNDCPT_USER_DC_PF_B does not reference any database object
IBY.IBY_FNDCPT_USER_DC_PF_B is referenced by following:
Description: |
---|
Foreign Key Column | Foreign Table |
---|---|
IBY_FNDCPT_USER_DC_PF_TL.USER_DC_PROFILE_CODE | IBY_FNDCPT_USER_DC_PF_B |
IBY.IBY_FNDCPT_USER_DC_PF_TL does not reference any database object
IBY.IBY_FNDCPT_USER_DC_PF_TL is referenced by following:
Description: |
---|
Foreign Key Column | Foreign Table |
---|---|
IBY_FNDCPT_USER_EFT_PF_B.SYS_EFT_PROFILE_CODE | % |
IBY_FNDCPT_USER_EFT_PF_B.BEP_ACCOUNT_ID | IBY_BEPKEYS |
IBY_FNDCPT_USER_EFT_PF_B.VERIFY_TRANS_CONFIG_ID | % |
IBY_FNDCPT_USER_EFT_PF_B.FUNDS_XFER_TRANS_CONFIG_ID | % |
IBY_FNDCPT_USER_EFT_PF_B.QUERY_TRANS_CONFIG_ID | % |
IBY.IBY_FNDCPT_USER_EFT_PF_B does not reference any database object
IBY.IBY_FNDCPT_USER_EFT_PF_B is referenced by following:
Description: |
---|
Foreign Key Column | Foreign Table |
---|---|
IBY_FNDCPT_USER_EFT_PF_TL.USER_EFT_PROFILE_CODE | % |
IBY.IBY_FNDCPT_USER_EFT_PF_TL does not reference any database object
IBY.IBY_FNDCPT_USER_EFT_PF_TL is referenced by following:
Description: | Stores payment processing format types |
---|
Foreign Key Column | Foreign Table |
---|---|
IBY_FORMATS_B.EXTRACT_ID | IBY_EXTRACTS_B |
Foreign Key Column | Foreign Table |
---|---|
IBY_DOCS_PAYABLE_ALL.PAYMENT_FORMAT_CODE | IBY_FORMATS_B |
IBY_EXTERNAL_PAYEES_ALL.PAYMENT_FORMAT_CODE | IBY_FORMATS_B |
IBY_EXTRACT_ACTIVATIONS.FORMAT_CODE | IBY_FORMATS_B |
IBY_FNDCPT_SYS_CC_PF_B.SETTLEMENT_FORMAT_CODE | IBY_FORMATS_B |
IBY_FNDCPT_SYS_CC_PF_B.QUERY_FORMAT_CODE | IBY_FORMATS_B |
IBY_FNDCPT_SYS_CC_PF_B.PAYER_NOTIFICATION_FORMAT | IBY_FORMATS_B |
IBY_FNDCPT_SYS_DC_PF_B.PAYER_NOTIFICATION_FORMAT | IBY_FORMATS_B |
IBY_FNDCPT_SYS_DC_PF_B.ONLINE_DEB_ACK_RDR_CODE | IBY_FORMATS_B |
IBY_FNDCPT_SYS_DC_PF_B.SETTLEMENT_FORMAT_CODE | IBY_FORMATS_B |
IBY_FNDCPT_SYS_DC_PF_B.QUERY_FORMAT_CODE | IBY_FORMATS_B |
IBY_FNDCPT_SYS_EFT_PF_B.PAYER_NOTIFICATION_FORMAT | IBY_FORMATS_B |
IBY_FNDCPT_SYS_EFT_PF_B.ACCOMPANY_LETTER_FORMAT | IBY_FORMATS_B |
IBY_FNDCPT_SYS_EFT_PF_B.VERIFY_FORMAT_CODE | IBY_FORMATS_B |
IBY_FNDCPT_SYS_EFT_PF_B.FUNDS_XFER_FORMAT_CODE | IBY_FORMATS_B |
IBY_FNDCPT_SYS_EFT_PF_B.QUERY_FORMAT_CODE | IBY_FORMATS_B |
IBY_PAY_INSTRUCTIONS_H.PAYMENT_FORMAT_CODE | IBY_FORMATS_B |
IBY_PAY_INSTRUCTIONS_H.POSITIVE_PAY_FORMAT_CODE | IBY_FORMATS_B |
IBY_PMT_SYS_FORMATS.PAYMENT_FORMAT_CODE | IBY_FORMATS_B |
IBY_REMIT_ADVICE_SETUP.REMITTANCE_ADVICE_FORMAT_CODE | IBY_FORMATS_B |
IBY_SYS_PMT_PROFILES_B.PAYMENT_FORMAT_CODE | IBY_FORMATS_B |
IBY_SYS_PMT_PROFILES_B.POSITIVE_PAY_FORMAT_CODE | IBY_FORMATS_B |
IBY_SYS_PMT_PROFILES_B.PAY_FILE_LETTER_FORMAT_CODE | IBY_FORMATS_B |
IBY_TEMP_EXT_PAYEES.PAYMENT_FORMAT_CODE | IBY_FORMATS_B |
IBY.IBY_FORMATS_B does not reference any database object
IBY.IBY_FORMATS_B is referenced by following:
Description: |
---|
Foreign Key Column | Foreign Table |
---|---|
IBY_FORMATS_TL.FORMAT_CODE | % |
IBY.IBY_FORMATS_TL does not reference any database object
IBY.IBY_FORMATS_TL is referenced by following:
Description: |
---|
Foreign Key Column | Foreign Table |
---|---|
IBY_F_CRDT_APP_STATUS_TL.CREDIT_APP_STATUS_ID | IBY_F_CRDT_APP_STATUS_B |
IBY_F_T_CRDT_APPS_ALL_B.CREDIT_APP_STATUS_ID | IBY_F_CRDT_APP_STATUS_B |
IBY_F_T_CRDT_APP_ST_H.OLD_STATUS_ID | IBY_F_CRDT_APP_STATUS_B |
IBY_F_T_CRDT_APP_ST_H.NEW_STATUS_ID | IBY_F_CRDT_APP_STATUS_B |
IBY_G_ST_TRANSITIONS.FROM_STATUS_ID | IBY_F_CRDT_APP_STATUS_B |
IBY_G_ST_TRANSITIONS.TO_STATUS_ID | IBY_F_CRDT_APP_STATUS_B |
IBY.IBY_F_CRDT_APP_STATUS_B does not reference any database object
IBY.IBY_F_CRDT_APP_STATUS_B is referenced by following:
Description: |
---|
Foreign Key Column | Foreign Table |
---|---|
IBY_F_CRDT_APP_STATUS_TL.CREDIT_APP_STATUS_ID | IBY_F_CRDT_APP_STATUS_B |
IBY.IBY_F_CRDT_APP_STATUS_TL does not reference any database object
IBY.IBY_F_CRDT_APP_STATUS_TL is referenced by following:
Description: |
---|
IBY.IBY_F_PC_RATES_ALL does not reference any database object
IBY.IBY_F_PC_RATES_ALL is referenced by following:
Description: |
---|
Foreign Key Column | Foreign Table |
---|---|
IBY_F_T_CA_GRNTRS_B.CREDIT_APP_ID | IBY_F_T_CRDT_APPS_ALL_B |
Foreign Key Column | Foreign Table |
---|---|
IBY_F_T_CA_GRNTRS_TL.CREDIT_APP_GRNTR_ID | IBY_F_T_CA_GRNTRS_B |
IBY_F_T_CA_GRNTR_H.CREDIT_APP_GRNTR_ID | IBY_F_T_CA_GRNTRS_B |
IBY_F_T_EMAIL_NOTIF_LOG.CREDIT_APP_GRNTR_ID | IBY_F_T_CA_GRNTRS_B |
IBY.IBY_F_T_CA_GRNTRS_B does not reference any database object
IBY.IBY_F_T_CA_GRNTRS_B is referenced by following:
Description: |
---|
Foreign Key Column | Foreign Table |
---|---|
IBY_F_T_CA_GRNTRS_TL.CREDIT_APP_GRNTR_ID | IBY_F_T_CA_GRNTRS_B |
IBY.IBY_F_T_CA_GRNTRS_TL does not reference any database object
IBY.IBY_F_T_CA_GRNTRS_TL is referenced by following:
Description: |
---|
Foreign Key Column | Foreign Table |
---|---|
IBY_F_T_CA_GRNTR_H.CREDIT_APP_GRNTR_ID | IBY_F_T_CA_GRNTRS_B |
IBY.IBY_F_T_CA_GRNTR_H does not reference any database object
IBY.IBY_F_T_CA_GRNTR_H is referenced by following:
Description: |
---|
Foreign Key Column | Foreign Table |
---|---|
IBY_F_T_CRDT_APPS_ALL_B.TRXN_SUMMARY_ID | IBY_TRXN_SUMMARIES_ALL |
IBY_F_T_CRDT_APPS_ALL_B.CREDIT_APP_STATUS_ID | IBY_F_CRDT_APP_STATUS_B |
IBY_F_T_CRDT_APPS_ALL_B.CREDIT_APP_XML_ID | IBY_TRXN_DOCUMENTS |
IBY_F_T_CRDT_APPS_ALL_B.TERMS_N_CONDITIONS_XML_ID | IBY_TRXN_DOCUMENTS |
Foreign Key Column | Foreign Table |
---|---|
IBY_F_T_CA_GRNTRS_B.CREDIT_APP_ID | IBY_F_T_CRDT_APPS_ALL_B |
IBY_F_T_CRDT_APPS_ALL_TL.CREDIT_APP_ID | IBY_F_T_CRDT_APPS_ALL_B |
IBY_F_T_CRDT_APP_REVS.CREDIT_APP_ID | IBY_F_T_CRDT_APPS_ALL_B |
IBY_F_T_CRDT_APP_ST_H.CREDIT_APP_ID | IBY_F_T_CRDT_APPS_ALL_B |
IBY_F_T_EMAIL_NOTIF_LOG.CREDIT_APP_ID | IBY_F_T_CRDT_APPS_ALL_B |
IBY_G_T_MESSAGES.CREDIT_APP_ID | IBY_F_T_CRDT_APPS_ALL_B |
IBY.IBY_F_T_CRDT_APPS_ALL_B does not reference any database object
IBY.IBY_F_T_CRDT_APPS_ALL_B is referenced by following:
Description: |
---|
Foreign Key Column | Foreign Table |
---|---|
IBY_F_T_CRDT_APPS_ALL_TL.CREDIT_APP_ID | IBY_F_T_CRDT_APPS_ALL_B |
IBY.IBY_F_T_CRDT_APPS_ALL_TL does not reference any database object
IBY.IBY_F_T_CRDT_APPS_ALL_TL is referenced by following:
Description: |
---|
Foreign Key Column | Foreign Table |
---|---|
IBY_F_T_CRDT_APP_REVS.CREDIT_APP_ID | IBY_F_T_CRDT_APPS_ALL_B |
IBY.IBY_F_T_CRDT_APP_REVS does not reference any database object
IBY.IBY_F_T_CRDT_APP_REVS is referenced by following:
Description: |
---|
Foreign Key Column | Foreign Table |
---|---|
IBY_F_T_CRDT_APP_ST_H.CREDIT_APP_ID | IBY_F_T_CRDT_APPS_ALL_B |
IBY_F_T_CRDT_APP_ST_H.OLD_STATUS_ID | IBY_F_CRDT_APP_STATUS_B |
IBY_F_T_CRDT_APP_ST_H.NEW_STATUS_ID | IBY_F_CRDT_APP_STATUS_B |
IBY.IBY_F_T_CRDT_APP_ST_H does not reference any database object
IBY.IBY_F_T_CRDT_APP_ST_H is referenced by following:
Description: |
---|
Foreign Key Column | Foreign Table |
---|---|
IBY_F_T_EMAIL_NOTIF_LOG.CREDIT_APP_ID | IBY_F_T_CRDT_APPS_ALL_B |
IBY_F_T_EMAIL_NOTIF_LOG.CREDIT_APP_GRNTR_ID | IBY_F_T_CA_GRNTRS_B |
IBY_F_T_EMAIL_NOTIF_LOG.MSG_TEMPLATE_ID | IBY_G_MSG_TEMPLATES_B |
IBY.IBY_F_T_EMAIL_NOTIF_LOG does not reference any database object
IBY.IBY_F_T_EMAIL_NOTIF_LOG is referenced by following:
Description: | IBY_GEN_DOCS_PAYABLE serves as a template for source product tables or views from which Oracle Payables can import documents payable. |
---|
IBY.IBY_GEN_DOCS_PAYABLE does not reference any database object
IBY.IBY_GEN_DOCS_PAYABLE is referenced by following:
Description: | IBY_GEN_DOCUMENT_LINES serves as a template for source product tables or views from which Oracle Payables can import documents payable. |
---|
IBY.IBY_GEN_DOCUMENT_LINES does not reference any database object
IBY.IBY_GEN_DOCUMENT_LINES is referenced by following:
Description: |
---|
Foreign Key Column | Foreign Table |
---|---|
IBY_F_T_EMAIL_NOTIF_LOG.MSG_TEMPLATE_ID | IBY_G_MSG_TEMPLATES_B |
IBY_G_MSG_TEMPLATES_TL.MSG_TEMPLATE_ID | IBY_G_MSG_TEMPLATES_B |
IBY.IBY_G_MSG_TEMPLATES_B does not reference any database object
IBY.IBY_G_MSG_TEMPLATES_B is referenced by following:
Description: |
---|
Foreign Key Column | Foreign Table |
---|---|
IBY_G_MSG_TEMPLATES_TL.MSG_TEMPLATE_ID | IBY_G_MSG_TEMPLATES_B |
IBY.IBY_G_MSG_TEMPLATES_TL does not reference any database object
IBY.IBY_G_MSG_TEMPLATES_TL is referenced by following:
Description: |
---|
Foreign Key Column | Foreign Table |
---|---|
IBY_G_ST_TRANSITIONS.FROM_STATUS_ID | IBY_F_CRDT_APP_STATUS_B |
IBY_G_ST_TRANSITIONS.TO_STATUS_ID | IBY_F_CRDT_APP_STATUS_B |
IBY.IBY_G_ST_TRANSITIONS does not reference any database object
IBY.IBY_G_ST_TRANSITIONS is referenced by following:
Description: |
---|
Foreign Key Column | Foreign Table |
---|---|
IBY_G_T_MESSAGES.TRXN_SUMMARY_ID | IBY_TRXN_SUMMARIES_ALL |
IBY_G_T_MESSAGES.MESSAGE_XML_ID | IBY_TRXN_DOCUMENTS |
IBY_G_T_MESSAGES.CREDIT_APP_ID | IBY_F_T_CRDT_APPS_ALL_B |
Foreign Key Column | Foreign Table |
---|---|
IBY_G_T_MSG_REQ_LOG.MESSAGE_ID | IBY_G_T_MESSAGES |
IBY.IBY_G_T_MESSAGES does not reference any database object
IBY.IBY_G_T_MESSAGES is referenced by following:
Description: |
---|
Foreign Key Column | Foreign Table |
---|---|
IBY_G_T_MSG_REQ_LOG.MESSAGE_ID | IBY_G_T_MESSAGES |
IBY.IBY_G_T_MSG_REQ_LOG does not reference any database object
IBY.IBY_G_T_MSG_REQ_LOG is referenced by following:
Description: |
---|
IBY.IBY_HOOK_DOCS_IN_PMT_T does not reference any database object
IBY.IBY_HOOK_DOCS_IN_PMT_T is referenced by following:
Description: |
---|
IBY.IBY_HOOK_PAYMENTS_T does not reference any database object
IBY.IBY_HOOK_PAYMENTS_T is referenced by following:
Description: | IBY_INSTRHOLDER stores the information about the holder of the instrment. A payment instrument can be held by different users or payees or payers. |
---|
Foreign Key Column | Foreign Table |
---|---|
IBY_INSTRHOLDER.INSTRID | IBY_CREDITCARD |
IBY_INSTRHOLDER.INSTRID | IBY_BANKACCT |
IBY.IBY_INSTRHOLDER does not reference any database object
IBY.IBY_INSTRHOLDER is referenced by following:
Description: | IBY_INSTRUCT_SOURCE_APPS stores a list of source products that submitted documents to be paid in each payment instruction. |
---|
Foreign Key Column | Foreign Table |
---|---|
IBY_INSTRUCT_SOURCE_APPS.PAYMENT_INSTRUCTION_ID | IBY_PAY_INSTRUCTIONS_ALL |
IBY.IBY_INSTRUCT_SOURCE_APPS does not reference any database object
IBY.IBY_INSTRUCT_SOURCE_APPS is referenced by following:
Description: | IBY_INSTR_CREATION_RULES specifies how payments are grouped into payment instructions. Payment instructions are always grouped by internal bank account and payment process profile but additional items stored in this table can be added for f |
---|
Foreign Key Column | Foreign Table |
---|---|
IBY_INSTR_CREATION_RULES.SYSTEM_PROFILE_CODE | IBY_SYS_PMT_PROFILES_B |
IBY.IBY_INSTR_CREATION_RULES does not reference any database object
IBY.IBY_INSTR_CREATION_RULES is referenced by following:
Description: | IBY_INTERMEDIARY_ACCTS defines intermediary bank account information. |
---|
Foreign Key Column | Foreign Table |
---|---|
IBY_INTERMEDIARY_ACCTS.BANK_ACCT_ID | IBY_EXT_BANK_ACCOUNTS |
IBY_INTERMEDIARY_ACCTS.INTERNAL_BANK_ACCOUNT_ID | CE_BANK_ACCOUNTS |
IBY.IBY_INTERMEDIARY_ACCTS does not reference any database object
IBY.IBY_INTERMEDIARY_ACCTS is referenced by following:
Description: | IBY_INTERNAL_PAYERS_ALL stores payment-related attributes for the funds disbursement payment process for all first party payers. These attributes control the flow of payments. |
---|
IBY.IBY_INTERNAL_PAYERS_ALL does not reference any database object
IBY.IBY_INTERNAL_PAYERS_ALL is referenced by following:
Description: | This table stores information pertaining to the payment amount risk factor involved in the payment request. A payment request that has huge amount is possibly a fraudulent payment. But the value of the amount varies from business to busines |
---|
Foreign Key Column | Foreign Table |
---|---|
IBY_IRF_PMT_AMOUNT.PAYEEID | IBY_PAYEE |
IBY.IBY_IRF_PMT_AMOUNT does not reference any database object
IBY.IBY_IRF_PMT_AMOUNT is referenced by following:
Description: | This table stores information pertaining to the payment frequency risk factor. It basically has information about the frequency of purchase in the given time frame(duration). This risk fatcor is associated with a risk score - low and high. |
---|
Foreign Key Column | Foreign Table |
---|---|
IBY_IRF_PMT_FREQUENCY.PAYEEID | IBY_PAYEE |
IBY.IBY_IRF_PMT_FREQUENCY does not reference any database object
IBY.IBY_IRF_PMT_FREQUENCY is referenced by following:
Description: | This table stores information pertaining to the payment history risk factor. The merchant can set up different time ranges which he considers risky. |
---|
Foreign Key Column | Foreign Table |
---|---|
IBY_IRF_PMT_HISTORY.PAYEEID | IBY_PAYEE |
Foreign Key Column | Foreign Table |
---|---|
IBY_IRF_PMT_HIST_RANGE.PAYMENT_HIST_ID | IBY_IRF_PMT_HISTORY |
IBY.IBY_IRF_PMT_HISTORY does not reference any database object
IBY.IBY_IRF_PMT_HISTORY is referenced by following:
Description: | This table stores the frequency ranges information pertaining to the payment history risk factor. The customer can setup multiple frequency ranges for a specific duration. During Risk Factor evaluation the merchant can setup risk scores (lo |
---|
Foreign Key Column | Foreign Table |
---|---|
IBY_IRF_PMT_HIST_RANGE.PAYMENT_HIST_ID | IBY_IRF_PMT_HISTORY |
IBY.IBY_IRF_PMT_HIST_RANGE does not reference any database object
IBY.IBY_IRF_PMT_HIST_RANGE is referenced by following:
Description: | IBY_IRF_RISKY_INSTR stores information pertaining to the risk instrument risk factor. It has information about the merchant who sends the file of risky instruments, the type of instrument and other account information pertaining to the risk |
---|
Foreign Key Column | Foreign Table |
---|---|
IBY_IRF_RISKY_INSTR.PAYEEID | IBY_PAYEE |
IBY.IBY_IRF_RISKY_INSTR does not reference any database object
IBY.IBY_IRF_RISKY_INSTR is referenced by following:
Description: | This table stores information pertaining to the time of purchase risk factor. The merchant can setup different time ranges - and associate a risk score of low risk, medium low risk, medium risk , medium high risk and high risk. |
---|
Foreign Key Column | Foreign Table |
---|---|
IBY_IRF_TIMEOF_PURCHASE.PAYEEID | IBY_PAYEE |
IBY.IBY_IRF_TIMEOF_PURCHASE does not reference any database object
IBY.IBY_IRF_TIMEOF_PURCHASE is referenced by following:
Description: | IBY_IRF_TRXN_AMT_LIMITstores information pertaining to the transaction amount limit risk factor. It is a limit on the total amount of payments made using the same instrument in a particular duration. |
---|
Foreign Key Column | Foreign Table |
---|---|
IBY_IRF_TRXN_AMT_LIMIT.PAYEEID | IBY_PAYEE |
IBY.IBY_IRF_TRXN_AMT_LIMIT does not reference any database object
IBY.IBY_IRF_TRXN_AMT_LIMIT is referenced by following:
Description: | IBY_MAPPINGS stores mapping of codes with risk scores. Each row includes a code and a value for that code. |
---|
Foreign Key Column | Foreign Table |
---|---|
IBY_MAPPINGS.PAYEEID | IBY_PAYEE |
IBY.IBY_MAPPINGS does not reference any database object
IBY.IBY_MAPPINGS is referenced by following:
Description: | IBY_PAYEE stores a row for each payee, such as a biller, merchant, or store at this site. |
---|
Foreign Key Column | Foreign Table |
---|---|
IBY_PAYEE.ECAPPID | IBY_ECAPP |
Foreign Key Column | Foreign Table |
---|---|
IBY_ACCPPMTMTHD.MPAYEEID | IBY_PAYEE |
IBY_BATCHES_ALL.MPAYEEID | IBY_PAYEE |
IBY_DEFAULT_BEP.MPAYEEID | IBY_PAYEE |
IBY_FNDCPT_PAYEE_APPL.MPAYEEID | IBY_PAYEE |
IBY_IRF_PMT_AMOUNT.PAYEEID | IBY_PAYEE |
IBY_IRF_PMT_FREQUENCY.PAYEEID | IBY_PAYEE |
IBY_IRF_PMT_HISTORY.PAYEEID | IBY_PAYEE |
IBY_IRF_RISKY_INSTR.PAYEEID | IBY_PAYEE |
IBY_IRF_TIMEOF_PURCHASE.PAYEEID | IBY_PAYEE |
IBY_IRF_TRXN_AMT_LIMIT.PAYEEID | IBY_PAYEE |
IBY_MAPPINGS.PAYEEID | IBY_PAYEE |
IBY_PAYEE_SUBKEYS.MPAYEE_ID | IBY_PAYEE |
IBY_RISK_FORMULAS.PAYEEID | IBY_PAYEE |
IBY_ROUTINGINFO.MPAYEEID | IBY_PAYEE |
IBY_TRXN_SUMMARIES_ALL.MPAYEEID | IBY_PAYEE |
IBY_TRXN_SUMMARIES_ALL.MPAYEEID | IBY_PAYEE |
IBY.IBY_PAYEE does not reference any database object
IBY.IBY_PAYEE is referenced by following:
Description: |
---|
Foreign Key Column | Foreign Table |
---|---|
IBY_PAYEE_SUBKEYS.MPAYEE_ID | IBY_PAYEE |
Foreign Key Column | Foreign Table |
---|---|
IBY_TRXN_SUMMARIES_ALL.SUB_KEY_ID | IBY_PAYEE_SUBKEYS |
IBY.IBY_PAYEE_SUBKEYS does not reference any database object
IBY.IBY_PAYEE_SUBKEYS is referenced by following:
Description: | "This table stores information about card number for the card programs associated with card type 'Payment Card'.IBY_PAYMENTCARD contain payment card numbers entered manually through the Payables, Credit card setup. The card number can be nu |
---|
Foreign Key Column | Foreign Table |
---|---|
IBY_PAYMENTCARD.ADDRESSID | HZ_PARTY_SITE_USES |
IBY_PAYMENTCARD.CARD_OWNER_ID | HZ_PARTIES |
IBY_PAYMENTCARD.BILL_ADDR_TERRITORY_CODE | FND_TERRITORIES |
IBY.IBY_PAYMENTCARD does not reference any database object
IBY.IBY_PAYMENTCARD is referenced by following:
Description: | "This table contains records of the payments which are created by system while processing 'Build payments' program. A payment can be a single check or an electronic fund transfer between first party payer and third party payee. A row in |
---|
Foreign Key Column | Foreign Table |
---|---|
IBY_PAYMENTS_ALL.PAYMENT_METHOD_CODE | IBY_PAYMENT_METHODS_B |
IBY_PAYMENTS_ALL.PAYMENT_PROFILE_ID | IBY_ACCT_PMT_PROFILES_B |
IBY_PAYMENTS_ALL.PAYMENT_SERVICE_REQUEST_ID | IBY_PAY_SERVICE_REQUESTS |
IBY_PAYMENTS_ALL.PAYMENT_INSTRUCTION_ID | IBY_PAY_INSTRUCTIONS_ALL |
IBY_PAYMENTS_ALL.PAYMENT_REASON_CODE | IBY_PAYMENT_REASONS_B |
IBY_PAYMENTS_ALL.DELIVERY_CHANNEL_CODE | IBY_DELIVERY_CHANNELS_B |
IBY_PAYMENTS_ALL.EXT_PAYEE_ID | IBY_EXTERNAL_PAYEES_ALL |
IBY_PAYMENTS_ALL.EXTERNAL_BANK_ACCOUNT_ID | CE_BANK_ACCOUNTS |
IBY_PAYMENTS_ALL.INTERNAL_BANK_ACCOUNT_ID | CE_BANK_ACCOUNTS |
Foreign Key Column | Foreign Table |
---|---|
AP_HISTORY_CHECKS_ALL.PAYMENT_ID | IBY_PAYMENTS_ALL |
IBY_DOCS_PAYABLE_ALL.FORMATTING_PAYMENT_ID | IBY_PAYMENTS_ALL |
IBY_DOCS_PAYABLE_ALL.PAYMENT_ID | IBY_PAYMENTS_ALL |
IBY_DOCUMENTS_PAYABLE_H.PAYMENT_ID | IBY_PAYMENTS_ALL |
IBY.IBY_PAYMENTS_ALL does not reference any database object
IBY.IBY_PAYMENTS_ALL is referenced by following:
Description: | IBY_PAYMENTS_H table stores historical snapshots of payments. This table contains denormalized versions of payments from specific points in time, including when the payment was submitted to a payment system. Different snapshots of the same |
---|
Foreign Key Column | Foreign Table |
---|---|
IBY_PAYMENTS_H.BANK_INSTRUCTION1_CODE | IBY_BANK_INSTRUCTIONS_B |
IBY_PAYMENTS_H.PAYMENT_REASON_CODE | IBY_PAYMENT_REASONS_B |
IBY_PAYMENTS_H.PAYMENT_INSTRUCTION_ID | IBY_PAY_INSTRUCTIONS_ALL |
IBY_PAYMENTS_H.PAYMENT_SERVICE_REQUEST_ID | IBY_PAY_SERVICE_REQUESTS |
IBY_PAYMENTS_H.PAYMENT_INSTRUCTION_HISTORY_ID | IBY_PAY_INSTRUCTIONS_H |
IBY_PAYMENTS_H.BANK_INSTRUCTION2_CODE | IBY_BANK_INSTRUCTIONS_B |
IBY_PAYMENTS_H.COUNTRY | FND_TERRITORIES |
Foreign Key Column | Foreign Table |
---|---|
IBY_DOCUMENTS_PAYABLE_H.PAYMENT_HISTORY_ID | IBY_PAYMENTS_H |
IBY.IBY_PAYMENTS_H does not reference any database object
IBY.IBY_PAYMENTS_H is referenced by following:
Description: | IBY_PAYMENT_METHODS stores the payment methods that Oracle Payments supports. A payment method is a payment attribute on a document payable that indicates how the first party payer is going to make the payment. Examples of payment methods i |
---|
Foreign Key Column | Foreign Table |
---|---|
IBY_APPLICABLE_PMT_MTHDS.PAYMENT_METHOD_CODE | IBY_PAYMENT_METHODS_B |
IBY_DOCS_PAYABLE_ALL.PAYMENT_METHOD_CODE | IBY_PAYMENT_METHODS_B |
IBY_DOCUMENTS_PAYABLE_H.PAYMENT_METHOD_CODE | IBY_PAYMENT_METHODS_B |
IBY_EXTERNAL_PAYEES_ALL.DEFAULT_PAYMENT_METHOD_CODE | IBY_PAYMENT_METHODS_B |
IBY_EXT_PARTY_PMT_MTHDS.PAYMENT_METHOD_CODE | IBY_PAYMENT_METHODS_B |
IBY_PAYMENTS_ALL.PAYMENT_METHOD_CODE | IBY_PAYMENT_METHODS_B |
IBY_PAYMENT_METHODS_TL.PAYMENT_METHOD_CODE | IBY_PAYMENT_METHODS_B |
IBY_PAYMENT_RULES.PAYMENT_METHOD_CODE | IBY_PAYMENT_METHODS_B |
IBY_TEMP_EXT_PAYEES.DEFAULT_PAYMENT_METHOD_CODE | IBY_PAYMENT_METHODS_B |
IBY_VAL_ASSIGNMENTS.PAYMENT_METHOD_CODE | IBY_PAYMENT_METHODS_B |
IBY.IBY_PAYMENT_METHODS_B does not reference any database object
IBY.IBY_PAYMENT_METHODS_B is referenced by following:
Description: | IBY_PAYMENT_METHODS stores the payment methods that Oracle Payments supports. A payment method is a payment attribute on a document payable that indicates how the first party payer is going to make the payment. Examples of payment methods i |
---|
Foreign Key Column | Foreign Table |
---|---|
IBY_PAYMENT_METHODS_TL.PAYMENT_METHOD_CODE | IBY_PAYMENT_METHODS_B |
IBY.IBY_PAYMENT_METHODS_TL does not reference any database object
IBY.IBY_PAYMENT_METHODS_TL is referenced by following:
Description: | IBY_PAYMENT_REASONS stores payment reasons that are used as lookup values for payee records or documents payable, that is, invoices. This table is similar to FND_LOOKUPS, but with a new column for territory identification. Products that use |
---|
Foreign Key Column | Foreign Table |
---|---|
IBY_PAYMENT_REASONS_B.TERRITORY_CODE | FND_TERRITORIES |
Foreign Key Column | Foreign Table |
---|---|
FV_PB_SEQ_ASSIGNMENTS_ALL.PAYMENT_REASON_CODE | IBY_PAYMENT_REASONS_B |
FV_TOP_EXCLUSION_CRITERIA_ALL.PAYMENT_REASON_CODE | IBY_PAYMENT_REASONS_B |
IBY_DOCS_PAYABLE_ALL.PAYMENT_REASON_CODE | IBY_PAYMENT_REASONS_B |
IBY_EXTERNAL_PAYEES_ALL.PAYMENT_REASON_CODE | IBY_PAYMENT_REASONS_B |
IBY_PAYMENTS_ALL.PAYMENT_REASON_CODE | IBY_PAYMENT_REASONS_B |
IBY_PAYMENTS_H.PAYMENT_REASON_CODE | IBY_PAYMENT_REASONS_B |
IBY_PAYMENT_REASONS_TL.PAYMENT_REASON_CODE | IBY_PAYMENT_REASONS_B |
IBY_PAY_INSTRUCTIONS_ALL.PAYMENT_REASON_CODE | IBY_PAYMENT_REASONS_B |
IBY_PAY_INSTRUCTIONS_H.PAYMENT_REASON_CODE | IBY_PAYMENT_REASONS_B |
IBY_TEMP_EXT_PAYEES.PAYMENT_REASON_CODE | IBY_PAYMENT_REASONS_B |
IBY.IBY_PAYMENT_REASONS_B does not reference any database object
IBY.IBY_PAYMENT_REASONS_B is referenced by following:
Description: | IBY_PAYMENT_REASONS stores payment reasons that are used as lookup values for payee records or documents payable, that is, invoices. This table is similar to FND_LOOKUPS, but with a new column for territory identification. Products that use |
---|
Foreign Key Column | Foreign Table |
---|---|
IBY_PAYMENT_REASONS_TL.PAYMENT_REASON_CODE | IBY_PAYMENT_REASONS_B |
IBY.IBY_PAYMENT_REASONS_TL does not reference any database object
IBY.IBY_PAYMENT_REASONS_TL is referenced by following:
Description: | IBY_PAYMENT_REFERENCES stores the current payment reference number. Payment reference numbers are outward facing identifiers assigned to payments during payment instruction creation. |
---|
IBY.IBY_PAYMENT_REFERENCES does not reference any database object
IBY.IBY_PAYMENT_REFERENCES is referenced by following:
Description: | IBY_PAYMENT_RULES stores the header-level information for a payment method defaulting rule. A defaulting rule enables the user to define the default payment method with respect to multiple factors of a transaction context. A defaulting rule |
---|
Foreign Key Column | Foreign Table |
---|---|
IBY_PAYMENT_RULES.PAYMENT_METHOD_CODE | IBY_PAYMENT_METHODS_B |
IBY_PAYMENT_RULES.APPLICATION_ID | FND_APPLICATION |
Foreign Key Column | Foreign Table |
---|---|
IBY_RULE_CONDITIONS.PAYMENT_RULE_ID | IBY_PAYMENT_RULES |
IBY.IBY_PAYMENT_RULES does not reference any database object
IBY.IBY_PAYMENT_RULES is referenced by following:
Description: | Stores batch level payment information as submitted by payable programs |
---|
Foreign Key Column | Foreign Table |
---|---|
IBY_PAY_BATCHES_ALL.IBY_BATCH_ID
IBY_PAY_BATCHES_ALL.PAYER_ID |
IBY_BATCHES_ALL |
Foreign Key Column | Foreign Table |
---|---|
IBY_PAY_PAYMENTS_ALL.BATCH_ID | IBY_PAY_BATCHES_ALL |
IBY.IBY_PAY_BATCHES_ALL does not reference any database object
IBY.IBY_PAY_BATCHES_ALL is referenced by following:
Description: |
---|
APPS.IBY_PAY_DASHBOARD_GT does not reference any database object
APPS.IBY_PAY_DASHBOARD_GT is referenced by following:
Description: | "This table contains records of the payment instructions. Instructions are created based on the Payment Process Request options. Data is inserted in to the table IBY_PAY_INSTRUCTIONS_AL after payment instruction creation, based on the opt |
---|
Foreign Key Column | Foreign Table |
---|---|
IBY_PAY_INSTRUCTIONS_ALL.PAYMENT_PROFILE_ID | IBY_ACCT_PMT_PROFILES_B |
IBY_PAY_INSTRUCTIONS_ALL.PAYMENT_SERVICE_REQUEST_ID | IBY_PAY_SERVICE_REQUESTS |
IBY_PAY_INSTRUCTIONS_ALL.PAYMENT_REASON_CODE | IBY_PAYMENT_REASONS_B |
IBY_PAY_INSTRUCTIONS_ALL.INTERNAL_BANK_ACCOUNT_ID | CE_BANK_ACCOUNTS |
Foreign Key Column | Foreign Table |
---|---|
AP_CHECKS_ALL.PAYMENT_INSTRUCTION_ID | IBY_PAY_INSTRUCTIONS_ALL |
FV_SUMMARY_CONSOLIDATE_ALL.PAYMENT_INSTRUCTION_ID | IBY_PAY_INSTRUCTIONS_ALL |
FV_TP_TS_AMT_DATA.PAYMENT_INSTRUCTION_ID | IBY_PAY_INSTRUCTIONS_ALL |
IBY_INSTRUCT_SOURCE_APPS.PAYMENT_INSTRUCTION_ID | IBY_PAY_INSTRUCTIONS_ALL |
IBY_PAYMENTS_ALL.PAYMENT_INSTRUCTION_ID | IBY_PAY_INSTRUCTIONS_ALL |
IBY_PAYMENTS_H.PAYMENT_INSTRUCTION_ID | IBY_PAY_INSTRUCTIONS_ALL |
JL_AR_AP_AWT_CERTIF_ALL.PAYMENT_INSTRUCTION_ID | IBY_PAY_INSTRUCTIONS_ALL |
IBY.IBY_PAY_INSTRUCTIONS_ALL does not reference any database object
IBY.IBY_PAY_INSTRUCTIONS_ALL is referenced by following:
Description: | IBY_PAY_INSTRUCTIONS_H stores historical snapshots of payment instructions. This table contains denormalized versions of payment instructions from specific points in time, including when the payment instruction was submitted to a payment sy |
---|
Foreign Key Column | Foreign Table |
---|---|
IBY_PAY_INSTRUCTIONS_H.BEPID | IBY_BEPINFO |
IBY_PAY_INSTRUCTIONS_H.PAYMENT_FORMAT_CODE | IBY_FORMATS_B |
IBY_PAY_INSTRUCTIONS_H.PAYMENT_REASON_CODE | IBY_PAYMENT_REASONS_B |
IBY_PAY_INSTRUCTIONS_H.TRANSMIT_CONFIGURATION_ID | IBY_TRANSMIT_CONFIGS_B |
IBY_PAY_INSTRUCTIONS_H.POSITIVE_PAY_FORMAT_CODE | IBY_FORMATS_B |
Foreign Key Column | Foreign Table |
---|---|
IBY_PAYMENTS_H.PAYMENT_INSTRUCTION_HISTORY_ID | IBY_PAY_INSTRUCTIONS_H |
IBY.IBY_PAY_INSTRUCTIONS_H does not reference any database object
IBY.IBY_PAY_INSTRUCTIONS_H is referenced by following:
Description: | Stores a reference to the invoice in the calling payable programs |
---|
Foreign Key Column | Foreign Table |
---|---|
IBY_PAY_INVOICEPMTS.PMT_TRXN_ID | IBY_PAY_PAYMENTS_ALL |
IBY.IBY_PAY_INVOICEPMTS does not reference any database object
IBY.IBY_PAY_INVOICEPMTS is referenced by following:
Description: | Stores transaction level payment information as submitted by payable programs |
---|
Foreign Key Column | Foreign Table |
---|---|
IBY_PAY_PAYMENTS_ALL.BATCH_ID | IBY_PAY_BATCHES_ALL |
Foreign Key Column | Foreign Table |
---|---|
IBY_PAY_INVOICEPMTS.PMT_TRXN_ID | IBY_PAY_PAYMENTS_ALL |
IBY.IBY_PAY_PAYMENTS_ALL does not reference any database object
IBY.IBY_PAY_PAYMENTS_ALL is referenced by following:
Description: | "This table contains records of the payment process requests which are created by system while processing 'Build payments' program.IBY_PAY_SERVICE_REQUESTS stores payment process requests from source products. A payment process request is |
---|
Foreign Key Column | Foreign Table |
---|---|
IBY_PAY_SERVICE_REQUESTS.INTERNAL_BANK_ACCOUNT_ID | CE_BANK_ACCOUNTS |
IBY_PAY_SERVICE_REQUESTS.PAYMENT_PROFILE_ID | IBY_ACCT_PMT_PROFILES_B |
Foreign Key Column | Foreign Table |
---|---|
IBY_DOCS_PAYABLE_ALL.PAYMENT_SERVICE_REQUEST_ID | IBY_PAY_SERVICE_REQUESTS |
IBY_DOCUMENTS_PAYABLE_H.PAYMENT_SERVICE_REQUEST_ID | IBY_PAY_SERVICE_REQUESTS |
IBY_PAYMENTS_ALL.PAYMENT_SERVICE_REQUEST_ID | IBY_PAY_SERVICE_REQUESTS |
IBY_PAYMENTS_H.PAYMENT_SERVICE_REQUEST_ID | IBY_PAY_SERVICE_REQUESTS |
IBY_PAY_INSTRUCTIONS_ALL.PAYMENT_SERVICE_REQUEST_ID | IBY_PAY_SERVICE_REQUESTS |
IBY.IBY_PAY_SERVICE_REQUESTS does not reference any database object
IBY.IBY_PAY_SERVICE_REQUESTS is referenced by following:
Description: | Stores the BIN ranges for all valid purchase cards. |
---|
IBY.IBY_PCARD_BIN_RANGE does not reference any database object
IBY.IBY_PCARD_BIN_RANGE is referenced by following:
Description: | IBY_PMTMTHD_CONDITIONS stores the conditions for payment methods. Each condition is comprised of a parameter, operation, and value. The condition is evaluated at runtime to determine if the payment system account and funds capture process p |
---|
Foreign Key Column | Foreign Table |
---|---|
IBY_PMTMTHD_CONDITIONS.PAYMENTMETHODID | IBY_ROUTINGINFO |
IBY.IBY_PMTMTHD_CONDITIONS does not reference any database object
IBY.IBY_PMTMTHD_CONDITIONS is referenced by following:
Description: | IBY_PMTSCHEMES stores a list of payment schemes that are supported by a payment system. |
---|
Foreign Key Column | Foreign Table |
---|---|
IBY_PMTSCHEMES.BEPID | IBY_BEPINFO |
IBY.IBY_PMTSCHEMES does not reference any database object
IBY.IBY_PMTSCHEMES is referenced by following:
Description: | IBY_PMT_CREATION_RULES specifies how documents payable are grouped into payments. Creation rules are determined by payment process profiles. This table corresponds to the Payment Creation tab of the Update Payment Process Profile page. |
---|
Foreign Key Column | Foreign Table |
---|---|
IBY_PMT_CREATION_RULES.SYSTEM_PROFILE_CODE | IBY_SYS_PMT_PROFILES_B |
IBY.IBY_PMT_CREATION_RULES does not reference any database object
IBY.IBY_PMT_CREATION_RULES is referenced by following:
Description: | "This table contains records of the relationship between payment instruments and Payer/Payee. Data can be entered manually. IBY_PMT_INSTR_USES_ALL table assigns payment instruments to external party payers and payees. This table is shared |
---|
Foreign Key Column | Foreign Table |
---|---|
IBY_FNDCPT_TX_EXTENSIONS.INSTR_ASSIGNMENT_ID | IBY_PMT_INSTR_USES_ALL |
IBY_TRXN_SUMMARIES_ALL.PAYER_INSTR_ASSIGNMENT_ID | IBY_PMT_INSTR_USES_ALL |
IBY.IBY_PMT_INSTR_USES_ALL does not reference any database object
IBY.IBY_PMT_INSTR_USES_ALL is referenced by following:
Description: | IBY_PMT_LOGICAL_GRP_RULES specifies the attributes for grouping the payments in a payment instruction. |
---|
Foreign Key Column | Foreign Table |
---|---|
IBY_PMT_LOGICAL_GRP_RULES.SYSTEM_PROFILE_CODE | IBY_SYS_PMT_PROFILES_B |
IBY.IBY_PMT_LOGICAL_GRP_RULES does not reference any database object
IBY.IBY_PMT_LOGICAL_GRP_RULES is referenced by following:
Description: | IBY_PMT_MTHD_ATTRIB_APPL stores payment channel or method attribute applicability settings. |
---|
IBY.IBY_PMT_MTHD_ATTRIB_APPL does not reference any database object
IBY.IBY_PMT_MTHD_ATTRIB_APPL is referenced by following:
Description: |
---|
Foreign Key Column | Foreign Table |
---|---|
IBY_PMT_SYS_FORMATS.PAYMENT_SYSTEM_ID | IBY_BEPINFO |
IBY_PMT_SYS_FORMATS.PAYMENT_FORMAT_CODE | IBY_FORMATS_B |
IBY.IBY_PMT_SYS_FORMATS does not reference any database object
IBY.IBY_PMT_SYS_FORMATS is referenced by following:
Description: |
---|
Foreign Key Column | Foreign Table |
---|---|
IBY_PMT_SYS_TRANSMISSIONS.TRANSMIT_PROTOCOL_CODE | IBY_TRANSMIT_PROTOCOLS_B |
IBY_PMT_SYS_TRANSMISSIONS.BEPID | IBY_BEPINFO |
IBY.IBY_PMT_SYS_TRANSMISSIONS does not reference any database object
IBY.IBY_PMT_SYS_TRANSMISSIONS is referenced by following:
Description: | Concurrent requests |
---|
IBY.IBY_PROCESS_CONC_REQUESTS does not reference any database object
IBY.IBY_PROCESS_CONC_REQUESTS is referenced by following:
Description: | Populated by build program - list of all functions within any given PPR |
---|
IBY.IBY_PROCESS_FUNCTIONS does not reference any database object
IBY.IBY_PROCESS_FUNCTIONS is referenced by following:
Description: | Populated by build program - list of all orgs within any given PPR |
---|
IBY.IBY_PROCESS_ORGS does not reference any database object
IBY.IBY_PROCESS_ORGS is referenced by following:
Description: |
---|
APPS.IBY_PYO_INVOICE_GT does not reference any database object
APPS.IBY_PYO_INVOICE_GT is referenced by following:
Description: |
---|
APPS.IBY_PYO_PAYMENT_GT does not reference any database object
APPS.IBY_PYO_PAYMENT_GT is referenced by following:
Description: | IBY_REMIT_ADVICE_SETUP stores information on creating and delivering remittance information, or remittance advice, for a payee separately from the payment itself. Remittance advice setup is organized by payment process profile. Each payment |
---|
Foreign Key Column | Foreign Table |
---|---|
IBY_REMIT_ADVICE_SETUP.SYSTEM_PROFILE_CODE | IBY_SYS_PMT_PROFILES_B |
IBY_REMIT_ADVICE_SETUP.REMITTANCE_ADVICE_FORMAT_CODE | IBY_FORMATS_B |
IBY.IBY_REMIT_ADVICE_SETUP does not reference any database object
IBY.IBY_REMIT_ADVICE_SETUP is referenced by following:
Description: | Result codes |
---|
IBY.IBY_RESULT_CODES does not reference any database object
IBY.IBY_RESULT_CODES is referenced by following:
Description: | IBY_RISK_FACTORS stores information about the Risk Factors. These are factors which a merchant deems fit to use to evaluate the risk of the customer who wants to purchase its goods and services. Risk Management feature will contain bundled |
---|
Foreign Key Column | Foreign Table |
---|---|
IBY_RISK_FORMULA_ITEM.RISK_FACTOR_ID | IBY_RISK_FACTORS |
IBY.IBY_RISK_FACTORS does not reference any database object
IBY.IBY_RISK_FACTORS is referenced by following:
Description: | IBY_RISK_FORMULAS stores risk formula retaled information . Risk Formula is used by merchants to evaluate the risk of the customer. This formula could be different for different goods/services offered by the merchants. A Risk Formula may be |
---|
Foreign Key Column | Foreign Table |
---|---|
IBY_RISK_FORMULAS.PAYEEID | IBY_PAYEE |
Foreign Key Column | Foreign Table |
---|---|
IBY_RISK_FORMULA_ITEM.RISK_FORMULA_ID | IBY_RISK_FORMULAS |
IBY.IBY_RISK_FORMULAS does not reference any database object
IBY.IBY_RISK_FORMULAS is referenced by following:
Description: | IBY_RISK_FORMULA_ITEM table is an intersection table between the IBY_RISK_FORMULA and IBY_RISK_FACTORS. It stores weight for different Risk Factors. |
---|
Foreign Key Column | Foreign Table |
---|---|
IBY_RISK_FORMULA_ITEM.RISK_FACTOR_ID | IBY_RISK_FACTORS |
IBY_RISK_FORMULA_ITEM.RISK_FORMULA_ID | IBY_RISK_FORMULAS |
IBY.IBY_RISK_FORMULA_ITEM does not reference any database object
IBY.IBY_RISK_FORMULA_ITEM is referenced by following:
Description: | IBY_ROUTINGINFO stores information that maps payment method to the payment system and funds capture process profile via conditions. |
---|
Foreign Key Column | Foreign Table |
---|---|
IBY_ROUTINGINFO.BEPID | IBY_BEPINFO |
IBY_ROUTINGINFO.MPAYEEID | IBY_PAYEE |
Foreign Key Column | Foreign Table |
---|---|
IBY_PMTMTHD_CONDITIONS.PAYMENTMETHODID | IBY_ROUTINGINFO |
IBY.IBY_ROUTINGINFO does not reference any database object
IBY.IBY_ROUTINGINFO is referenced by following:
Description: | IBY_RULE_CONDITIONS stores the detail-level information for a payment method defaulting rule. Each row in the IBY_PAYMENT_RULES table has one or more rows in this table. Conditions of different types are combined with the AND logical operat |
---|
Foreign Key Column | Foreign Table |
---|---|
IBY_RULE_CONDITIONS.PAYMENT_RULE_ID | IBY_PAYMENT_RULES |
IBY.IBY_RULE_CONDITIONS does not reference any database object
IBY.IBY_RULE_CONDITIONS is referenced by following:
Description: |
---|
Foreign Key Column | Foreign Table |
---|---|
IBY_SECURITY_SEGMENTS.SEC_SUBKEY_ID | IBY_SYS_SECURITY_SUBKEYS |
Foreign Key Column | Foreign Table |
---|---|
IBY_BEP_ACCT_OPT_VALS.VAL_SEC_SEGMENT_ID | IBY_SECURITY_SEGMENTS |
IBY_CREDITCARD.CHNAME_SEC_SEGMENT_ID | IBY_SECURITY_SEGMENTS |
IBY_CREDITCARD.EXPIRY_SEC_SEGMENT_ID | IBY_SECURITY_SEGMENTS |
IBY_CREDITCARD_H.CHNAME_SEC_SEGMENT_ID | IBY_SECURITY_SEGMENTS |
IBY_EXT_BANK_ACCOUNTS.BA_NUM_SEC_SEGMENT_ID | IBY_SECURITY_SEGMENTS |
IBY_EXT_BANK_ACCOUNTS.IBAN_SEC_SEGMENT_ID | IBY_SECURITY_SEGMENTS |
IBY_FNDCPT_TX_EXTENSIONS.INSTR_CODE_SEC_SEGMENT_ID | IBY_SECURITY_SEGMENTS |
IBY_EXT_BANK_ACCOUNTS.BA_NUM_ELEC_SEC_SEGMENT_ID | IBY_SECURITY_SEGMENTS |
IBY_TRANSMIT_VALUES.VAL_SEC_SEGMENT_ID | IBY_SECURITY_SEGMENTS |
IBY_TRXN_CORE.CHNAME_SEC_SEGMENT_ID | IBY_SECURITY_SEGMENTS |
IBY_TRXN_CORE.EXPIRY_SEC_SEGMENT_ID | IBY_SECURITY_SEGMENTS |
IBY.IBY_SECURITY_SEGMENTS does not reference any database object
IBY.IBY_SECURITY_SEGMENTS is referenced by following:
Description: | IBY_SETUP_TASKS stores the status of all Oracle Payments' setup tasks. |
---|
Foreign Key Column | Foreign Table |
---|---|
IBY_SETUP_TASKS_TL.TASK_CODE | IBY_SETUP_TASKS_B |
IBY.IBY_SETUP_TASKS_B does not reference any database object
IBY.IBY_SETUP_TASKS_B is referenced by following:
Description: | IBY_SETUP_TASKS stores the status of all Oracle Payments' setup tasks. |
---|
Foreign Key Column | Foreign Table |
---|---|
IBY_SETUP_TASKS_TL.TASK_CODE | IBY_SETUP_TASKS_B |
IBY.IBY_SETUP_TASKS_TL does not reference any database object
IBY.IBY_SETUP_TASKS_TL is referenced by following:
Description: | "This table stores Payment Process Profile setup for Funds Disbursement transactions. This table also stores information of the seeded Payment process profiles. IBY_SYS_PMT_PROFILES_B stores information that specifies the bulk of payment |
---|
Foreign Key Column | Foreign Table |
---|---|
IBY_SYS_PMT_PROFILES_B.BEPID | IBY_BEPINFO |
IBY_SYS_PMT_PROFILES_B.TRANSMIT_PROTOCOL_CODE | IBY_TRANSMIT_PROTOCOLS_B |
IBY_SYS_PMT_PROFILES_B.PAYMENT_FORMAT_CODE | IBY_FORMATS_B |
IBY_SYS_PMT_PROFILES_B.POSITIVE_PAY_FORMAT_CODE | IBY_FORMATS_B |
IBY_SYS_PMT_PROFILES_B.PAY_FILE_LETTER_FORMAT_CODE | IBY_FORMATS_B |
IBY_SYS_PMT_PROFILES_B.BANK_INSTRUCTION1_CODE | IBY_BANK_INSTRUCTIONS_B |
IBY_SYS_PMT_PROFILES_B.BANK_INSTRUCTION2_CODE | IBY_BANK_INSTRUCTIONS_B |
Foreign Key Column | Foreign Table |
---|---|
IBY_ACCT_PMT_PROFILES_B.SYSTEM_PROFILE_CODE | IBY_SYS_PMT_PROFILES_B |
IBY_APPLICABLE_PMT_PROFS.SYSTEM_PROFILE_CODE | IBY_SYS_PMT_PROFILES_B |
IBY_INSTR_CREATION_RULES.SYSTEM_PROFILE_CODE | IBY_SYS_PMT_PROFILES_B |
IBY_PMT_LOGICAL_GRP_RULES.SYSTEM_PROFILE_CODE | IBY_SYS_PMT_PROFILES_B |
IBY_REMIT_ADVICE_SETUP.SYSTEM_PROFILE_CODE | IBY_SYS_PMT_PROFILES_B |
IBY_SYS_PMT_PROFILES_TL.SYSTEM_PROFILE_CODE | IBY_SYS_PMT_PROFILES_B |
IBY_PMT_CREATION_RULES.SYSTEM_PROFILE_CODE | IBY_SYS_PMT_PROFILES_B |
IBY.IBY_SYS_PMT_PROFILES_B does not reference any database object
IBY.IBY_SYS_PMT_PROFILES_B is referenced by following:
Description: | IBY_SYS_PMT_PROFILES stores seeded information that specifies the bulk of payment processing behavior. The rest of the behavior is specified in a user-defined account payment process profile stored in IBY_ACCT_PMT_PROFILES. A combination of |
---|
Foreign Key Column | Foreign Table |
---|---|
IBY_SYS_PMT_PROFILES_TL.SYSTEM_PROFILE_CODE | IBY_SYS_PMT_PROFILES_B |
IBY.IBY_SYS_PMT_PROFILES_TL does not reference any database object
IBY.IBY_SYS_PMT_PROFILES_TL is referenced by following:
Description: |
---|
IBY.IBY_SYS_SECURITY_OPTIONS does not reference any database object
IBY.IBY_SYS_SECURITY_OPTIONS is referenced by following:
Description: |
---|
Foreign Key Column | Foreign Table |
---|---|
IBY_SECURITY_SEGMENTS.SEC_SUBKEY_ID | IBY_SYS_SECURITY_SUBKEYS |
IBY.IBY_SYS_SECURITY_SUBKEYS does not reference any database object
IBY.IBY_SYS_SECURITY_SUBKEYS is referenced by following:
Description: | IBY_TANGIBLE stores information about the bills or orders. |
---|
Foreign Key Column | Foreign Table |
---|---|
IBY_TANGIBLE.SOURCE_OBJECT_TYPE_CODE | JTF_OBJECTS_B |
Foreign Key Column | Foreign Table |
---|---|
IBY_TRXN_SUMMARIES_ALL.MTANGIBLEID | IBY_TANGIBLE |
IBY_TRXN_SUMMARIES_ALL.MTANGIBLEID | IBY_TANGIBLE |
IBY.IBY_TANGIBLE does not reference any database object
IBY.IBY_TANGIBLE is referenced by following:
Description: |
---|
IBY.IBY_TEMP_EXT_BANK_ACCTS does not reference any database object
IBY.IBY_TEMP_EXT_BANK_ACCTS is referenced by following:
Description: |
---|
Foreign Key Column | Foreign Table |
---|---|
IBY_TEMP_EXT_PAYEES.BANK_INSTRUCTION1_CODE | IBY_BANK_INSTRUCTIONS_B |
IBY_TEMP_EXT_PAYEES.DEFAULT_PAYMENT_METHOD_CODE | IBY_PAYMENT_METHODS_B |
IBY_TEMP_EXT_PAYEES.BANK_INSTRUCTION2_CODE | IBY_BANK_INSTRUCTIONS_B |
IBY_TEMP_EXT_PAYEES.DELIVERY_CHANNEL_CODE | IBY_DELIVERY_CHANNELS_B |
IBY_TEMP_EXT_PAYEES.PAYMENT_FORMAT_CODE | IBY_FORMATS_B |
IBY_TEMP_EXT_PAYEES.PAYMENT_REASON_CODE | IBY_PAYMENT_REASONS_B |
Foreign Key Column | Foreign Table |
---|---|
IBY_TEMP_PMT_INSTR_USES.TEMP_EXT_PARTY_ID | IBY_TEMP_EXT_PAYEES |
IBY.IBY_TEMP_EXT_PAYEES does not reference any database object
IBY.IBY_TEMP_EXT_PAYEES is referenced by following:
Description: |
---|
Foreign Key Column | Foreign Table |
---|---|
IBY_TEMP_PMT_INSTR_USES.TEMP_EXT_PARTY_ID | IBY_TEMP_EXT_PAYEES |
IBY.IBY_TEMP_PMT_INSTR_USES does not reference any database object
IBY.IBY_TEMP_PMT_INSTR_USES is referenced by following:
Description: | IBY_TRANSACTION_ERRORS stores any errors encountered during payment processing validations. |
---|
Foreign Key Column | Foreign Table |
---|---|
IBY_TRANSACTION_ERRORS.CALLING_APP_ID
IBY_TRANSACTION_ERRORS.PAY_PROC_TRXN_TYPE_CODE |
IBY_TRXN_TYPES_B |
Foreign Key Column | Foreign Table |
---|---|
IBY_TRXN_ERROR_TOKENS.TRANSACTION_ERROR_ID | IBY_TRANSACTION_ERRORS |
IBY.IBY_TRANSACTION_ERRORS does not reference any database object
IBY.IBY_TRANSACTION_ERRORS is referenced by following:
Description: |
---|
Foreign Key Column | Foreign Table |
---|---|
IBY_TRANSMIT_CONFIGS_B.TRANSMIT_PROTOCOL_CODE | IBY_TRANSMIT_PROTOCOLS_B |
IBY_TRANSMIT_CONFIGS_B.TUNNELING_TRANS_CONFIG_ID | IBY_TRANSMIT_CONFIGS_B |
Foreign Key Column | Foreign Table |
---|---|
IBY_ACCT_PMT_PROFILES_B.TRANSMIT_CONFIGURATION_ID | IBY_TRANSMIT_CONFIGS_B |
IBY_PAY_INSTRUCTIONS_H.TRANSMIT_CONFIGURATION_ID | IBY_TRANSMIT_CONFIGS_B |
IBY_TRANSMIT_CONFIGS_B.TUNNELING_TRANS_CONFIG_ID | IBY_TRANSMIT_CONFIGS_B |
IBY.IBY_TRANSMIT_CONFIGS_B does not reference any database object
IBY.IBY_TRANSMIT_CONFIGS_B is referenced by following:
Description: |
---|
Foreign Key Column | Foreign Table |
---|---|
IBY_TRANSMIT_CONFIGS_TL.TRANSMIT_CONFIGURATION_ID | % |
IBY.IBY_TRANSMIT_CONFIGS_TL does not reference any database object
IBY.IBY_TRANSMIT_CONFIGS_TL is referenced by following:
Description: |
---|
Foreign Key Column | Foreign Table |
---|---|
IBY_TRANSMIT_PARAMETERS_B.TRANSMIT_PROTOCOL_CODE | IBY_TRANSMIT_PROTOCOLS_B |
IBY.IBY_TRANSMIT_PARAMETERS_B does not reference any database object
IBY.IBY_TRANSMIT_PARAMETERS_B is referenced by following:
Description: |
---|
Foreign Key Column | Foreign Table |
---|---|
IBY_TRANSMIT_PARAMETERS_TL.TRANSMIT_PROTOCOL_CODE
IBY_TRANSMIT_PARAMETERS_TL.TRANSMIT_PARAMETER_CODE |
% |
IBY.IBY_TRANSMIT_PARAMETERS_TL does not reference any database object
IBY.IBY_TRANSMIT_PARAMETERS_TL is referenced by following:
Description: |
---|
Foreign Key Column | Foreign Table |
---|---|
IBY_FNDCPT_SYS_CC_PF_B.SETTLEMENT_TRANS_PRTCL_CODE | IBY_TRANSMIT_PROTOCOLS_B |
IBY_FNDCPT_SYS_CC_PF_B.QUERY_TRANS_PRTCL_CODE | IBY_TRANSMIT_PROTOCOLS_B |
IBY_FNDCPT_SYS_DC_PF_B.ONLINE_DEB_TRANS_PRTCL_CODE | IBY_TRANSMIT_PROTOCOLS_B |
IBY_FNDCPT_SYS_DC_PF_B.SETTLEMENT_TRANS_PRTCL_CODE | IBY_TRANSMIT_PROTOCOLS_B |
IBY_FNDCPT_SYS_DC_PF_B.QUERY_TRANS_PRTCL_CODE | IBY_TRANSMIT_PROTOCOLS_B |
IBY_FNDCPT_SYS_EFT_PF_B.VERIFY_TRANS_PRTCL_CODE | IBY_TRANSMIT_PROTOCOLS_B |
IBY_FNDCPT_SYS_EFT_PF_B.FUNDS_XFER_TRANS_PRTCL_CODE | IBY_TRANSMIT_PROTOCOLS_B |
IBY_FNDCPT_SYS_EFT_PF_B.QUERY_TRANS_PRTCL_CODE | IBY_TRANSMIT_PROTOCOLS_B |
IBY_PMT_SYS_TRANSMISSIONS.TRANSMIT_PROTOCOL_CODE | IBY_TRANSMIT_PROTOCOLS_B |
IBY_SYS_PMT_PROFILES_B.TRANSMIT_PROTOCOL_CODE | IBY_TRANSMIT_PROTOCOLS_B |
IBY_TRANSMIT_CONFIGS_B.TRANSMIT_PROTOCOL_CODE | IBY_TRANSMIT_PROTOCOLS_B |
IBY_TRANSMIT_PARAMETERS_B.TRANSMIT_PROTOCOL_CODE | IBY_TRANSMIT_PROTOCOLS_B |
IBY_TRANSMIT_PROTOCOLS_TL.TRANSMIT_PROTOCOL_CODE | IBY_TRANSMIT_PROTOCOLS_B |
IBY.IBY_TRANSMIT_PROTOCOLS_B does not reference any database object
IBY.IBY_TRANSMIT_PROTOCOLS_B is referenced by following:
Description: |
---|
Foreign Key Column | Foreign Table |
---|---|
IBY_TRANSMIT_PROTOCOLS_TL.TRANSMIT_PROTOCOL_CODE | IBY_TRANSMIT_PROTOCOLS_B |
IBY.IBY_TRANSMIT_PROTOCOLS_TL does not reference any database object
IBY.IBY_TRANSMIT_PROTOCOLS_TL is referenced by following:
Description: |
---|
Foreign Key Column | Foreign Table |
---|---|
IBY_TRANSMIT_VALUES.TRANSMIT_CONFIGURATION_ID | % |
IBY_TRANSMIT_VALUES.VAL_SEC_SEGMENT_ID | IBY_SECURITY_SEGMENTS |
IBY.IBY_TRANSMIT_VALUES does not reference any database object
IBY.IBY_TRANSMIT_VALUES is referenced by following:
Description: | IBY_BEPKEYS stores information about the payment systems. |
---|
Foreign Key Column | Foreign Table |
---|---|
IBY_TRXN_CORE.TRXNMID | IBY_TRXN_SUMMARIES_ALL |
IBY_TRXN_CORE.CHNAME_SEC_SEGMENT_ID | IBY_SECURITY_SEGMENTS |
IBY_TRXN_CORE.EXPIRY_SEC_SEGMENT_ID | IBY_SECURITY_SEGMENTS |
IBY.IBY_TRXN_CORE does not reference any database object
IBY.IBY_TRXN_CORE is referenced by following:
Description: | Table used to store XML documents associated with a particular transaction. |
---|
Foreign Key Column | Foreign Table |
---|---|
IBY_TRXN_DOCUMENTS.TRXNMID | IBY_TRXN_SUMMARIES_ALL |
Foreign Key Column | Foreign Table |
---|---|
IBY_F_T_CRDT_APPS_ALL_B.CREDIT_APP_XML_ID | IBY_TRXN_DOCUMENTS |
IBY_F_T_CRDT_APPS_ALL_B.TERMS_N_CONDITIONS_XML_ID | IBY_TRXN_DOCUMENTS |
IBY_G_T_MESSAGES.MESSAGE_XML_ID | IBY_TRXN_DOCUMENTS |
IBY.IBY_TRXN_DOCUMENTS does not reference any database object
IBY.IBY_TRXN_DOCUMENTS is referenced by following:
Description: | IBY_TRXN_ERROR_TOKENS stores the values that are used to fill out the tokens in transaction error messages. For each error in IBY_TRANSACTION_ERRORS, this table contains one or more rows with one row for each token included in the correspon |
---|
Foreign Key Column | Foreign Table |
---|---|
IBY_TRXN_ERROR_TOKENS.TRANSACTION_ERROR_ID | IBY_TRANSACTION_ERRORS |
IBY.IBY_TRXN_ERROR_TOKENS does not reference any database object
IBY.IBY_TRXN_ERROR_TOKENS is referenced by following:
Description: | IBY_TRXN_EXTENDED stores the details of a payment request that are specific for extended set functionality for credit cards. |
---|
Foreign Key Column | Foreign Table |
---|---|
IBY_TRXN_EXTENDED.TRXNMID | IBY_TRXN_SUMMARIES_ALL |
IBY.IBY_TRXN_EXTENDED does not reference any database object
IBY.IBY_TRXN_EXTENDED is referenced by following:
Description: |
---|
Foreign Key Column | Foreign Table |
---|---|
IBY_TRXN_EXTENSIBILITY.TRXNMID | IBY_TRXN_SUMMARIES_ALL |
IBY.IBY_TRXN_EXTENSIBILITY does not reference any database object
IBY.IBY_TRXN_EXTENSIBILITY is referenced by following:
Description: | IBY_TRXN_FI contains the details of a payment request that are specific for systems that support both bank account transfers and credit cards such as Financial Institutions. |
---|
Foreign Key Column | Foreign Table |
---|---|
IBY_TRXN_FI.TRXNMID | IBY_TRXN_SUMMARIES_ALL |
IBY.IBY_TRXN_FI does not reference any database object
IBY.IBY_TRXN_FI is referenced by following:
Description: | IBY_TRXN_SUMMARIES_ALL contains information about each payment request. This table is used for both online and offline payment transactions. The information contained in this table is generic in nature to cover the various payment inst |
---|
Foreign Key Column | Foreign Table |
---|---|
IBY_TRXN_SUMMARIES_ALL.MPAYEEID | IBY_PAYEE |
IBY_TRXN_SUMMARIES_ALL.CC_ISSUER_RANGE_ID | IBY_CC_ISSUER_RANGES |
IBY_TRXN_SUMMARIES_ALL.INSTRNUM_SEC_SEGMENT_ID | % |
IBY_TRXN_SUMMARIES_ALL.PAYER_INSTR_ASSIGNMENT_ID | IBY_PMT_INSTR_USES_ALL |
IBY_TRXN_SUMMARIES_ALL.AR_RECEIPT_METHOD_ID | AR_RECEIPT_METHODS |
IBY_TRXN_SUMMARIES_ALL.INITIATOR_EXTENSION_ID | IBY_FNDCPT_TX_EXTENSIONS |
IBY_TRXN_SUMMARIES_ALL.MBATCHID | IBY_BATCHES_ALL |
IBY_TRXN_SUMMARIES_ALL.BEPID | IBY_BEPINFO |
IBY_TRXN_SUMMARIES_ALL.MTANGIBLEID | IBY_TANGIBLE |
IBY_TRXN_SUMMARIES_ALL.CUST_ACCOUNT_ID | HZ_CUST_ACCOUNTS |
IBY_TRXN_SUMMARIES_ALL.SALES_REP_PARTY_ID | HZ_PARTIES |
IBY_TRXN_SUMMARIES_ALL.SUB_KEY_ID | IBY_PAYEE_SUBKEYS |
IBY_TRXN_SUMMARIES_ALL.MPAYEEID | IBY_PAYEE |
IBY_TRXN_SUMMARIES_ALL.BEPID | IBY_BEPINFO |
IBY_TRXN_SUMMARIES_ALL.MTANGIBLEID | IBY_TANGIBLE |
Foreign Key Column | Foreign Table |
---|---|
IBY_F_T_CRDT_APPS_ALL_B.TRXN_SUMMARY_ID | IBY_TRXN_SUMMARIES_ALL |
IBY_G_T_MESSAGES.TRXN_SUMMARY_ID | IBY_TRXN_SUMMARIES_ALL |
IBY_TRXN_CORE.TRXNMID | IBY_TRXN_SUMMARIES_ALL |
IBY_TRXN_DOCUMENTS.TRXNMID | IBY_TRXN_SUMMARIES_ALL |
IBY_TRXN_EXTENDED.TRXNMID | IBY_TRXN_SUMMARIES_ALL |
IBY_TRXN_EXTENSIBILITY.TRXNMID | IBY_TRXN_SUMMARIES_ALL |
IBY_TRXN_FI.TRXNMID | IBY_TRXN_SUMMARIES_ALL |
IBY.IBY_TRXN_SUMMARIES_ALL does not reference any database object
IBY.IBY_TRXN_SUMMARIES_ALL is referenced by following:
Description: | IBY_TRXN_TYPES stores the payment processing transaction types required by the dependent products for submitting payment transactions to Oracle Payments. This is used for both funds disbursement and funds capture transactions. |
---|
Foreign Key Column | Foreign Table |
---|---|
IBY_DOCS_PAYABLE_ALL.CALLING_APP_ID
IBY_DOCS_PAYABLE_ALL.PAY_PROC_TRXN_TYPE_CODE |
IBY_TRXN_TYPES_B |
IBY_DOCUMENTS_PAYABLE_H.CALLING_APP_ID
IBY_DOCUMENTS_PAYABLE_H.PAY_PROC_TRXN_TYPE_CODE |
IBY_TRXN_TYPES_B |
IBY_TRANSACTION_ERRORS.CALLING_APP_ID
IBY_TRANSACTION_ERRORS.PAY_PROC_TRXN_TYPE_CODE |
IBY_TRXN_TYPES_B |
IBY_TRXN_TYPES_TL.APPLICATION_ID
IBY_TRXN_TYPES_TL.PAY_PROC_TRXN_TYPE_CODE |
IBY_TRXN_TYPES_B |
IBY.IBY_TRXN_TYPES_B does not reference any database object
IBY.IBY_TRXN_TYPES_B is referenced by following:
Description: | IBY_TRXN_TYPES stores the payment processing transaction types required by the dependent products for submitting payment transactions to Oracle Payments. This is used for both funds disbursement and funds capture transactions. |
---|
Foreign Key Column | Foreign Table |
---|---|
IBY_TRXN_TYPES_TL.APPLICATION_ID
IBY_TRXN_TYPES_TL.PAY_PROC_TRXN_TYPE_CODE |
IBY_TRXN_TYPES_B |
IBY.IBY_TRXN_TYPES_TL does not reference any database object
IBY.IBY_TRXN_TYPES_TL is referenced by following:
Description: |
---|
IBY.IBY_UPG_GDFS does not reference any database object
IBY.IBY_UPG_GDFS is referenced by following:
Description: |
---|
IBY.IBY_UPG_INSTRUMENTS does not reference any database object
IBY.IBY_UPG_INSTRUMENTS is referenced by following:
Description: |
---|
IBY.IBY_UPG_PPP_B does not reference any database object
IBY.IBY_UPG_PPP_B is referenced by following:
Description: |
---|
IBY.IBY_UPG_PPP_TL does not reference any database object
IBY.IBY_UPG_PPP_TL is referenced by following:
Description: | IBY_USED_PAYMENT_DOCS tracks information about which payment documents have been used when printing payments. |
---|
IBY.IBY_USED_PAYMENT_DOCS does not reference any database object
IBY.IBY_USED_PAYMENT_DOCS is referenced by following:
Description: | IBY_VALIDATION_PARAMS stores parameters for each validation. For example, one validation controls the maximum amount that can be paid in a single payment instruction. The maximum amount parameter is stored in this table, and the actual valu |
---|
Foreign Key Column | Foreign Table |
---|---|
IBY_VALIDATION_PARAMS_B.VALIDATION_SET_CODE | IBY_VALIDATION_SETS_B |
Foreign Key Column | Foreign Table |
---|---|
IBY_VALIDATION_PARAMS_TL.VALIDATION_SET_CODE
IBY_VALIDATION_PARAMS_TL.VALIDATION_PARAMETER_CODE |
IBY_VALIDATION_PARAMS_B |
IBY.IBY_VALIDATION_PARAMS_B does not reference any database object
IBY.IBY_VALIDATION_PARAMS_B is referenced by following:
Description: | IBY_VALIDATION_PARAMS stores parameters for each validation. For example, one validation controls the maximum amount that can be paid in a single payment instruction. The maximum amount parameter is stored in this table, and the actual valu |
---|
Foreign Key Column | Foreign Table |
---|---|
IBY_VALIDATION_PARAMS_TL.VALIDATION_SET_CODE
IBY_VALIDATION_PARAMS_TL.VALIDATION_PARAMETER_CODE |
IBY_VALIDATION_PARAMS_B |
IBY.IBY_VALIDATION_PARAMS_TL does not reference any database object
IBY.IBY_VALIDATION_PARAMS_TL is referenced by following:
Description: |
---|
Foreign Key Column | Foreign Table |
---|---|
IBY_VALIDATION_PARAMS_B.VALIDATION_SET_CODE | IBY_VALIDATION_SETS_B |
IBY_VALIDATION_VALUES.VALIDATION_SET_CODE | IBY_VALIDATION_SETS_B |
IBY.IBY_VALIDATION_SETS_B does not reference any database object
IBY.IBY_VALIDATION_SETS_B is referenced by following:
Description: |
---|
Foreign Key Column | Foreign Table |
---|---|
IBY_VALIDATION_SETS_TL.VALIDATION_SET_CODE | % |
IBY.IBY_VALIDATION_SETS_TL does not reference any database object
IBY.IBY_VALIDATION_SETS_TL is referenced by following:
Description: | IBY_VALIDATION_VALUES stores the values for each validation parameter. For example, one validation controls the maximum amount that can be paid in a single payment instruction. The maximum amount parameter is stored in this table, and the a |
---|
Foreign Key Column | Foreign Table |
---|---|
IBY_VALIDATION_VALUES.VALIDATION_SET_CODE | IBY_VALIDATION_SETS_B |
IBY_VALIDATION_VALUES.VALIDATION_ASSIGNMENT_ID | IBY_VAL_ASSIGNMENTS |
IBY.IBY_VALIDATION_VALUES does not reference any database object
IBY.IBY_VALIDATION_VALUES is referenced by following:
Description: |
---|
Foreign Key Column | Foreign Table |
---|---|
IBY_VAL_ASSIGNMENTS.VALIDATION_SET_CODE | % |
IBY_VAL_ASSIGNMENTS.PAYMENT_METHOD_CODE | IBY_PAYMENT_METHODS_B |
IBY_VAL_ASSIGNMENTS.TERRITORY_CODE | FND_TERRITORIES |
Foreign Key Column | Foreign Table |
---|---|
IBY_VALIDATION_VALUES.VALIDATION_ASSIGNMENT_ID | IBY_VAL_ASSIGNMENTS |
IBY.IBY_VAL_ASSIGNMENTS does not reference any database object
IBY.IBY_VAL_ASSIGNMENTS is referenced by following:
Description: | Stores the combinations of EC app, payee and org id for a visibility class |
---|
Foreign Key Column | Foreign Table |
---|---|
IBY_VISBLTY_CLASS_DTLS.VISIBILITY_CLASS_ID | IBY_VISIBILITY_CLASSES |
IBY.IBY_VISBLTY_CLASS_DTLS does not reference any database object
IBY.IBY_VISBLTY_CLASS_DTLS is referenced by following:
Description: | Stores the user privilege settings for viewing sensitive data in iPayment operations UI |
---|
Foreign Key Column | Foreign Table |
---|---|
IBY_VISBLTY_CLASS_DTLS.VISIBILITY_CLASS_ID | IBY_VISIBILITY_CLASSES |
IBY.IBY_VISIBILITY_CLASSES does not reference any database object
IBY.IBY_VISIBILITY_CLASSES is referenced by following:
APPS.IBY_AVS_RSTYPES_V is not referenced by any database object
APPS.IBY_BANKACCT_V is not referenced by any database object
APPS.IBY_BATCHES_ALL_V is not referenced by any database object
APPS.IBY_BEP_ACCT_OPT_NAME_VL is not referenced by any database object
APPS.IBY_CLEARED_PMT_XML_V is not referenced by any database object
APPS.IBY_COMPLETED_PMT_XML_V is not referenced by any database object
APPS.IBY_CRC_RSTYPES_V is not referenced by any database object
APPS.IBY_CREDITCARD_ISSUERS_V is not referenced by any database object
APPS.IBY_CREDITCARD_V is not referenced by any database object
APPS.IBY_DOCS_PAYABLE_SEC_V is not referenced by any database object
APPS.IBY_ECAPP_V is not referenced by any database object
APPS.IBY_EXTERNAL_PAYEES_V is not referenced by any database object
APPS.IBY_EXT_BANKS_V is not referenced by any database object
APPS.IBY_EXT_BANK_BRANCHES_V is not referenced by any database object
APPS.IBY_EXT_FD_PAYEE_1_0_V is not referenced by any database object
APPS.IBY_FD_DOCS_PAYABLE_V is not referenced by any database object
APPS.IBY_FD_PAYMENTS_V is not referenced by any database object
APPS.IBY_FNDCPT_ALL_PMT_CHANNELS_V is not referenced by any database object
APPS.IBY_FNDCPT_PAYER_ASSGN_INSTR_V is not referenced by any database object
APPS.IBY_FNDCPT_SYS_CC_PF_VL is not referenced by any database object
APPS.IBY_FNDCPT_SYS_DC_PF_VL is not referenced by any database object
APPS.IBY_FNDCPT_SYS_EFT_PF_VL is not referenced by any database object
APPS.IBY_FNDCPT_USER_CC_PF_VL is not referenced by any database object
APPS.IBY_FNDCPT_USER_DC_PF_VL is not referenced by any database object
APPS.IBY_FNDCPT_USER_EFT_PF_VL is not referenced by any database object
APPS.IBY_FOP_DTYPES_V is not referenced by any database object
APPS.IBY_FORMULA_FACTOR_V is not referenced by any database object
APPS.IBY_F_LENDERS_V is not referenced by any database object
APPS.IBY_F_LENDER_CONTACTS_V is not referenced by any database object
APPS.IBY_F_PC_RATES_ALL_V is not referenced by any database object
APPS.IBY_F_T_CA_GRNTRS_VL is not referenced by any database object
APPS.IBY_F_T_CA_STATUS_H_V is not referenced by any database object
APPS.IBY_F_T_CRDT_APPS_V is not referenced by any database object
APPS.IBY_G_MSG_TEMPLATES_VL is not referenced by any database object
APPS.IBY_INSTR_HOLDER_V is not referenced by any database object
APPS.IBY_INS_LVL_PMT_STS_CHG_XML_V is not referenced by any database object
APPS.IBY_NOTIFY_INS_FAIL_XML_V is not referenced by any database object
APPS.IBY_NOTIFY_REQ_XML_V is not referenced by any database object
APPS.IBY_NOTIFY_XMISSION_FAIL_XML_V is not referenced by any database object
APPS.IBY_PAYEE_ALL_BANKACCT_V is not referenced by any database object
APPS.IBY_PAYEE_ASSIGNED_BANKACCT_V is not referenced by any database object
APPS.IBY_PAYMENTS_SEC_V is not referenced by any database object
APPS.IBY_PAYMENTS_V is not referenced by any database object
APPS.IBY_PAY_INSTRUCTIONS_SEC_V is not referenced by any database object
APPS.IBY_PAY_REQUEST_SEC_V is not referenced by any database object
APPS.IBY_PA_RSTYPES_V is not referenced by any database object
APPS.IBY_PH_DTYPES_V is not referenced by any database object
APPS.IBY_PH_RSTYPES_V is not referenced by any database object
APPS.IBY_PMT_FAILED_DOCS_XML_V is not referenced by any database object
APPS.IBY_PMT_LVL_PMT_STS_CHG_XML_V is not referenced by any database object
APPS.IBY_PSR_SNAPSHOT_COUNT is not referenced by any database object
APPS.IBY_PURCHASECARD_V is not referenced by any database object
APPS.IBY_RC_RSTYPES_V is not referenced by any database object
APPS.IBY_REJECTED_DOCS_XML_V is not referenced by any database object
APPS.IBY_REJECT_REQ_XML_V is not referenced by any database object
APPS.IBY_SETUP_TASKS_VL is not referenced by any database object
APPS.IBY_SINGLE_REJECTED_DOC_XML_V is not referenced by any database object
APPS.IBY_TAL_DTYPES_V is not referenced by any database object
APPS.IBY_TAL_RSTYPES_V is not referenced by any database object
APPS.IBY_TOP_RSTYPES_V is not referenced by any database object
APPS.IBY_TRANSACTIONS_SET_V is not referenced by any database object
APPS.IBY_TRANSMIT_CONFIGS_VL is not referenced by any database object
APPS.IBY_TRANSMIT_PROTOCOLS_VL is not referenced by any database object
APPS.IBY_TRANS_ALL_V is not referenced by any database object
APPS.IBY_TRANS_BANKACCT_V is not referenced by any database object
APPS.IBY_TRANS_CORE_V is not referenced by any database object
APPS.IBY_TRANS_FI_V is not referenced by any database object
APPS.IBY_TRANS_PCARD_V is not referenced by any database object
APPS.IBY_TRANS_SET_V is not referenced by any database object
APPS.IBY_TRXN_EXTENSIONS_V is not referenced by any database object
APPS.IBY_TRXN_EXT_AUTHS_V is not referenced by any database object
APPS.IBY_TRXN_EXT_SETTLEMENTS_V is not referenced by any database object
APPS.IBY_TRXN_TYPES_VL is not referenced by any database object
APPS.IBY_UNCLEARED_PMT_XML_V is not referenced by any database object
APPS.IBY_VALIDATION_PARAMS_VL is not referenced by any database object
APPS.IBY_VALIDATION_SETS_VL is not referenced by any database object
APPS.IBY_VOID_PMT_XML_V is not referenced by any database object
APPS.IBY_XML_BATCH_FCI_1_0_V is not referenced by any database object
APPS.IBY_XML_BEP_ACCT_OPTIONS_V is not referenced by any database object
APPS.IBY_XML_FD_ACCT_SETTINGS_1_0_V is not referenced by any database object
APPS.IBY_XML_FD_DOCLINE_1_0_V is not referenced by any database object
APPS.IBY_XML_FD_DOC_1_0_V is not referenced by any database object
APPS.IBY_XML_FD_DOC_ERR_1_0_V is not referenced by any database object
APPS.IBY_XML_FD_INS_1_0_V is not referenced by any database object
APPS.IBY_XML_FD_PAYEE_1_0_V is not referenced by any database object
APPS.IBY_XML_FD_PEBA_1_0_V is not referenced by any database object
APPS.IBY_XML_FD_PMT_1_0_V is not referenced by any database object
APPS.IBY_XML_FD_PMT_ERR_1_0_V is not referenced by any database object
APPS.IBY_XML_FD_PPR_1_0_V is not referenced by any database object
APPS.IBY_XML_FNDCPT_DOC_HEADERS_V is not referenced by any database object
APPS.IBY_XML_FNDCPT_DOC_LINES_V is not referenced by any database object
APPS.IBY_XML_ONLINE_FCI_1_0_V is not referenced by any database object
|
|
Copyright (c) 2001 - 2005, Oracle | - Use Restricted by Contract |