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_EXTERNAL_PAYEES_ALL

Object Details

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

IBY_EXTERNAL_PAYEES_ALL stores payment-related attributes for the funds disbursement payment process for external party payees. This table corresponds to the supplier attributes.

Storage Details

Tablespace:	APPS_TS_TX_DATA
PCT Free:	10
PCT Used:

Indexes

Index	Type	Uniqueness	Tablespace	Column
IBY_EXTERNAL_PAYEES_ALL_U1	NORMAL	UNIQUE	APPS_TS_TX_IDX	EXT_PAYEE_ID
IBY_EXTERNAL_PAYEES_ALL_N1	NORMAL	NONUNIQUE	APPS_TS_TX_IDX	BANK_INSTRUCTION1_CODE
IBY_EXTERNAL_PAYEES_ALL_N2	NORMAL	NONUNIQUE	APPS_TS_TX_IDX	DEFAULT_PAYMENT_METHOD_CODE
IBY_EXTERNAL_PAYEES_ALL_N3	NORMAL	NONUNIQUE	APPS_TS_TX_IDX	BANK_INSTRUCTION2_CODE
IBY_EXTERNAL_PAYEES_ALL_N4	NORMAL	NONUNIQUE	APPS_TS_TX_IDX	PAYMENT_REASON_CODE
IBY_EXTERNAL_PAYEES_ALL_N5	NORMAL	NONUNIQUE	APPS_TS_TX_IDX	DELIVERY_CHANNEL_CODE
IBY_EXTERNAL_PAYEES_ALL_N6	NORMAL	NONUNIQUE	APPS_TS_TX_IDX	PAYMENT_FORMAT_CODE
IBY_EXTERNAL_PAYEES_ALL_N7	NORMAL	NONUNIQUE	APPS_TS_TX_IDX	SUPPLIER_SITE_ID
IBY_EXTERNAL_PAYEES_ALL_N8	NORMAL	NONUNIQUE	APPS_TS_TX_IDX	PAYEE_PARTY_ID PAYMENT_FUNCTION PARTY_SITE_ID SUPPLIER_SITE_ID ORG_ID ORG_TYPE

Columns

Name	Datatype	Length	Mandatory	Comments
EXT_PAYEE_ID	NUMBER	(15)	Yes	System generated primary key
PAYEE_PARTY_ID	NUMBER	(15)	Yes	TCA party Identifier
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.
EXCLUSIVE_PAYMENT_FLAG	VARCHAR2	(1)	Yes	Y or N flag indicating whether each document payable for this payee corresponds to one payment
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
PARTY_SITE_ID	NUMBER	(15)		Party site Identifier
SUPPLIER_SITE_ID	NUMBER	(15)		Supplier site Identifier
ORG_ID	NUMBER	(15)		Organization Identifier
ORG_TYPE	VARCHAR2	(30)		Organization type. Values from the lookup IBY_ORGANIZATION_TYPES include Operating Unit, Business Group, and Legal Entity.
DEFAULT_PAYMENT_METHOD_CODE	VARCHAR2	(30)		Default payment method Identifier
ECE_TP_LOCATION_CODE	VARCHAR2	(60)		Trading partner location code for e-Commerce Gateway
BANK_CHARGE_BEARER	VARCHAR2	(30)		Bearer of bank charge cost. Bank charge bearers are defined as the lookup IBY_BANK_CHARGE_BEARER.
BANK_INSTRUCTION1_CODE	VARCHAR2	(30)		Code of first bank instruction
BANK_INSTRUCTION2_CODE	VARCHAR2	(30)		Code of second bank instruction
BANK_INSTRUCTION_DETAILS	VARCHAR2	(255)		Additional bank instruction details
PAYMENT_REASON_CODE	VARCHAR2	(30)		Payment reason code
PAYMENT_REASON_COMMENTS	VARCHAR2	(240)		Free text field available for entering a reason for the payment
INACTIVE_DATE	DATE			Inactive date
PAYMENT_TEXT_MESSAGE1	VARCHAR2	(256)		Text message for use in payment processing
PAYMENT_TEXT_MESSAGE2	VARCHAR2	(150)		Text message for use in payment processing
PAYMENT_TEXT_MESSAGE3	VARCHAR2	(150)		Text message for use in payment processing
DELIVERY_CHANNEL_CODE	VARCHAR2	(30)		Default delivery channel code
PAYMENT_FORMAT_CODE	VARCHAR2	(30)		Default payment format code
SETTLEMENT_PRIORITY	VARCHAR2	(30)		Priority with which the financial institution or payment system settles payments for this payee. The available values for this column come from the FND lookup IBY_SETTLEMENT_PRIORITY.
REMIT_ADVICE_DELIVERY_METHOD	VARCHAR2	(30)		Default delivery method set on the payee level. If the Override with Payee Delivery Method Preference flag on the Payment Process Profile is turned off, the setting here is ignored. Values from the lookup IBY_DELIVERY_METHODS include EMAIL, FAX, and PRINTED.
REMIT_ADVICE_EMAIL	VARCHAR2	(255)		E-mail address at which the payee wishes to receive remittance advice
REMIT_ADVICE_FAX	VARCHAR2	(100)		Fax number at which the payee wishes to receive remittance advice

Query Text

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


SELECT EXT_PAYEE_ID
,      PAYEE_PARTY_ID
,      PAYMENT_FUNCTION
,      EXCLUSIVE_PAYMENT_FLAG
,      CREATED_BY
,      CREATION_DATE
,      LAST_UPDATED_BY
,      LAST_UPDATE_DATE
,      LAST_UPDATE_LOGIN
,      OBJECT_VERSION_NUMBER
,      PARTY_SITE_ID
,      SUPPLIER_SITE_ID
,      ORG_ID
,      ORG_TYPE
,      DEFAULT_PAYMENT_METHOD_CODE
,      ECE_TP_LOCATION_CODE
,      BANK_CHARGE_BEARER
,      BANK_INSTRUCTION1_CODE
,      BANK_INSTRUCTION2_CODE
,      BANK_INSTRUCTION_DETAILS
,      PAYMENT_REASON_CODE
,      PAYMENT_REASON_COMMENTS
,      INACTIVE_DATE
,      PAYMENT_TEXT_MESSAGE1
,      PAYMENT_TEXT_MESSAGE2
,      PAYMENT_TEXT_MESSAGE3
,      DELIVERY_CHANNEL_CODE
,      PAYMENT_FORMAT_CODE
,      SETTLEMENT_PRIORITY
,      REMIT_ADVICE_DELIVERY_METHOD
,      REMIT_ADVICE_EMAIL
,      REMIT_ADVICE_FAX
FROM IBY.IBY_EXTERNAL_PAYEES_ALL;

Dependencies

[top of page]

IBY.IBY_EXTERNAL_PAYEES_ALL does not reference any database object

IBY.IBY_EXTERNAL_PAYEES_ALL is referenced by following:

IBY: IBY_EXTERNAL_PAYEES_ALL#