IBY_EXT_PARTY_PMT_MTHDS

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 organization. This table is shared by funds capture and fund disbursement flows.

Details

  • Schema: FUSION

  • Object owner: IBY

  • Object type: TABLE

  • Tablespace: APPS_TS_TX_DATA

Primary Key

Name Columns

IBY_EXT_PARTY_PMT_MTHDS_PK

EXT_PARTY_PMT_MTHD_ID

Columns

Name Datatype Length Precision Not-null Comments
EXT_PARTY_PMT_MTHD_ID NUMBER 18 Yes System-generated primary key.
PAYMENT_METHOD_CODE VARCHAR2 30 Yes Payment method Identifier
PAYMENT_FLOW VARCHAR2 30 Yes Specifies funds capture or disbursement flow. Values taken from lookup: IBY_PAYMENT_FLOW
EXT_PMT_PARTY_ID NUMBER 18 Yes External party Identifier, either a payee or payer, depending on the payment flow
PAYMENT_FUNCTION VARCHAR2 30 Yes Function or purpose of the payment. Values from the lookup IBY_PAYMENT_FUNCTIONS include SUPPLIER_PAYMENT, CUSTOMER_REFUNDS, and others.
PRIMARY_FLAG VARCHAR2 1 Yes Indicates if payment method is primary. Y for Yes, N otherwise.
CREATED_BY VARCHAR2 64 Yes Who column: indicates the user who created the row.
CREATION_DATE TIMESTAMP Yes Who column: indicates the date and time of the creation of the row.
LAST_UPDATED_BY VARCHAR2 64 Yes Who column: indicates the user who last updated the row.
LAST_UPDATE_DATE TIMESTAMP Yes Who column: indicates the date and time of the last update of the row.
LAST_UPDATE_LOGIN VARCHAR2 32 Who column: indicates the session login associated to the user who last updated the row.
OBJECT_VERSION_NUMBER NUMBER 9 Yes Used to implement optimistic locking. This number is incremented every time that the row is updated. The number is compared at the start and end of a transaction to detect whether another session has updated the row since it was queried.
INACTIVE_DATE DATE interface.
START_DATE DATE Yes Date when an explicit assignment of a payment method to an external payee becomes active.
END_DATE DATE Yes Date when an explicit assignment of a payment method to an external payee becomes inactive.
ENTERPRISE_ID NUMBER 18 Enterprise identifier to support multi-tenancy.
OVERRIDE_PAYMENT_TERM_ID NUMBER 18 Overriding payment term. Foreign key to the AP_TERMS_B table.
BACKUP_PAYMENT_METHOD_CODE VARCHAR2 30 Backup payment method. Foreign key to the IBY_PAYMENT_METHODS_B table.

Foreign Keys

Table Foreign Table Foreign Key Column
IBY_EXT_PARTY_PMT_MTHDS iby_external_payees_all EXT_PMT_PARTY_ID
IBY_EXT_PARTY_PMT_MTHDS iby_payment_methods_b PAYMENT_METHOD_CODE
IBY_EXT_PARTY_PMT_MTHDS ap_terms_b OVERRIDE_PAYMENT_TERM_ID
IBY_EXT_PARTY_PMT_MTHDS iby_payment_methods_b BACKUP_PAYMENT_METHOD_CODE

Indexes

Index Uniqueness Tablespace Columns
IBY_EXT_PARTY_PMT_MTHDS_N1 Non Unique Default EXT_PMT_PARTY_ID
IBY_EXT_PARTY_PMT_MTHDS_N2 Non Unique Default PAYMENT_METHOD_CODE
IBY_EXT_PARTY_PMT_MTHDS_U1 Unique Default EXT_PARTY_PMT_MTHD_ID
IBY_EXT_PARTY_PMT_MTHDS_U2 Unique Default PAYMENT_FLOW, EXT_PMT_PARTY_ID, PAYMENT_METHOD_CODE, PAYMENT_FUNCTION