eTRM uses javascript that opens and focuses a separate window to display reports. Your browser does not appear to support javascript. This should not prevent you from using eTRM but it does mean the window focus feature will not work. Please check the contents of other windows on your desktop if you click on a link that does not appear to do anything.

DBA Data [Home] [Help] [Dependency Information]

TABLE: IBY.IBY_EXT_PARTY_PMT_MTHDS

Object Details

Object Name:	IBY_EXT_PARTY_PMT_MTHDS
Object Type:	TABLE
Owner:	IBY
FND Design Data:	IBY.IBY_EXT_PARTY_PMT_MTHDS
Subobject Name:
Status:	VALID

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.

Storage Details

Tablespace:	APPS_TS_TX_DATA
PCT Free:	10
PCT Used:

Indexes

Index	Type	Uniqueness	Tablespace	Column
IBY_EXT_PARTY_PMT_MTHDS_U1	NORMAL	UNIQUE	APPS_TS_TX_IDX	EXT_PARTY_PMT_MTHD_ID
IBY_EXT_PARTY_PMT_MTHDS_N1	NORMAL	NONUNIQUE	APPS_TS_TX_IDX	EXT_PMT_PARTY_ID
IBY_EXT_PARTY_PMT_MTHDS_N2	NORMAL	NONUNIQUE	APPS_TS_TX_IDX	PAYMENT_METHOD_CODE

Columns

Name	Datatype	Length	Mandatory	Comments
EXT_PARTY_PMT_MTHD_ID	NUMBER	(15)	Yes	System generated primary key
PAYMENT_METHOD_CODE	VARCHAR2	(30)	Yes	Payment method Identifier
PAYMENT_FLOW	VARCHAR2	(30)	Yes	Determines the source table for the PAYMENT_METHOD_CODE foreign key. Values from the lookup IBY_PAYMENT_FLOW are DISBURSEMENTS and FUND_CAPTURE.
EXT_PMT_PARTY_ID	NUMBER	(15)	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	NUMBER	(15)	Yes	Standard Who column
CREATION_DATE	DATE		Yes	Standard Who column
LAST_UPDATED_BY	NUMBER	(15)	Yes	Standard Who column
LAST_UPDATE_DATE	DATE		Yes	Standard Who column
LAST_UPDATE_LOGIN	NUMBER	(15)		Standard Who column
OBJECT_VERSION_NUMBER	NUMBER		Yes	Object version number
INACTIVE_DATE	DATE			Inactive date

Query Text

Cut, paste (and edit) the following text to query this object:


SELECT EXT_PARTY_PMT_MTHD_ID
,      PAYMENT_METHOD_CODE
,      PAYMENT_FLOW
,      EXT_PMT_PARTY_ID
,      PAYMENT_FUNCTION
,      PRIMARY_FLAG
,      CREATED_BY
,      CREATION_DATE
,      LAST_UPDATED_BY
,      LAST_UPDATE_DATE
,      LAST_UPDATE_LOGIN
,      OBJECT_VERSION_NUMBER
,      INACTIVE_DATE
FROM IBY.IBY_EXT_PARTY_PMT_MTHDS;

Dependencies

[top of page]

IBY.IBY_EXT_PARTY_PMT_MTHDS does not reference any database object

IBY.IBY_EXT_PARTY_PMT_MTHDS is referenced by following:

APPS: IBY_EXT_PARTY_PMT_MTHDS