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_APPLICABLE_PMT_MTHDS

Object Details

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

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 Foreign Currency or Not, Cross-Border Transaction or Not, and Payment Amount. Payment method applicability determines which payment method applies under given conditions. It is used to narrow the list of possible payment methods when a user or application is assigning a payment method to a document payable. 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_APPLICABLE_PMT_MTHDS_U1	NORMAL	UNIQUE	APPS_TS_TX_IDX	APPLICABLE_PMT_MTHD_ID ZD_EDITION_NAME
IBY_APPLICABLE_PMT_MTHDS_N1	NORMAL	NONUNIQUE	APPS_TS_TX_IDX	PAYMENT_METHOD_CODE
IBY_APPLICABLE_PMT_MTHDS_N2	NORMAL	NONUNIQUE	APPS_TS_TX_IDX	APPLICATION_ID
IBY_APPLICABLE_PMT_MTHDS_N3	NORMAL	NONUNIQUE	APPS_TS_TX_IDX	APPLICABLE_TYPE_CODE

Columns

Name	Datatype	Length	Mandatory	Comments
APPLICABLE_PMT_MTHD_ID	NUMBER	(15)	Yes	System generated primary key
PAYMENT_METHOD_CODE	VARCHAR2	(30)	Yes	Payment method identifier
PAYMENT_FLOW	VARCHAR2	(30)		Determines the source table for the PAYMENT_METHOD_CODE foreign key. Lookup values of IBY_PAYMENT_FLOW lookup type. Values are DISBURSEMENTS and FUND_CAPTURE.
APPLICABLE_TYPE_CODE	VARCHAR2	(30)	Yes	Applicable type. Each type corresponds to one factor in determining the applicability of a payment method. Lookup values of IBY_PMT_MTHD_USAGE_RULE_TYPES lookup type
APPLICABLE_VALUE_FROM	VARCHAR2	(240)		From value of the applicability type. Used for the payment amount applicability only
APPLICABLE_VALUE_TO	VARCHAR2	(240)		To value of the applicability type
APPLICATION_ID	NUMBER	(15)	Yes	Application Identifier of the calling product
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
EXCLUDE_FROM_APPLIC_FLAG	VARCHAR2	(1)		Y or N flag
INACTIVE_DATE	DATE			Inactive date
ZD_EDITION_NAME	VARCHAR2	(30)	Yes

Query Text

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


SELECT APPLICABLE_PMT_MTHD_ID
,      PAYMENT_METHOD_CODE
,      PAYMENT_FLOW
,      APPLICABLE_TYPE_CODE
,      APPLICABLE_VALUE_FROM
,      APPLICABLE_VALUE_TO
,      APPLICATION_ID
,      CREATED_BY
,      CREATION_DATE
,      LAST_UPDATED_BY
,      LAST_UPDATE_DATE
,      LAST_UPDATE_LOGIN
,      OBJECT_VERSION_NUMBER
,      EXCLUDE_FROM_APPLIC_FLAG
,      INACTIVE_DATE
,      ZD_EDITION_NAME
FROM IBY.IBY_APPLICABLE_PMT_MTHDS;

Dependencies

[top of page]

IBY.IBY_APPLICABLE_PMT_MTHDS does not reference any database object

IBY.IBY_APPLICABLE_PMT_MTHDS is referenced by following:

IBY: IBY_APPLICABLE_PMT_MTHDS#