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_TEMP_EXT_PAYEES

Object Details

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

IBY_TEMP_EXT_PAYEES stores payment processing attributes for external payees.

Storage Details

Tablespace:	APPS_TS_TX_DATA
PCT Free:	10
PCT Used:

Columns

Name	Datatype	Length	Mandatory	Comments
TEMP_EXT_PAYEE_ID	NUMBER	(15)	Yes	Primary Identifier. The value comes from sequence IBY_TEMP_EXT_PAYEE_S.
PAYMENT_FUNCTION	VARCHAR2	(30)	Yes	Payment function
PARTY_ID	NUMBER	(15)	Yes	Identifier of the party
ORG_TYPE	VARCHAR2	(30)		Organization type
ORG_ID	NUMBER	(15)		Organization Identifier
BANK_CHARGE_BEARER	VARCHAR2	(30)		Bank charge bearer
PARTY_SITE_ID	NUMBER	(15)		Party site use Identifier
SUPPLIER_SITE_ID	NUMBER	(15)		Supplier site Identifier
DEFAULT_PAYMENT_METHOD_CODE	VARCHAR2	(30)	Yes	Default payment method Identifier
ECE_TP_LOCATION_CODE	VARCHAR2	(60)		Trading partner location code for e-Commerce Gateway
BANK_INSTRUCTION1_CODE	VARCHAR2	(30)	Yes	Code of first bank instruction
BANK_INSTRUCTION2_CODE	VARCHAR2	(30)	Yes	Code of second bank instruction
BANK_INSTRUCTION_DETAILS	VARCHAR2	(255)		Additional bank instruction details
PAYMENT_REASON_CODE	VARCHAR2	(30)	Yes	Payment reason code
PAYMENT_REASON_COMMENTS	VARCHAR2	(240)		Free text field available for entering a reason for the payment
PAYMENT_TEXT_MESSAGE1	VARCHAR2	(150)		Text message for use in payment processing
PAYMENT_TEXT_MESSAGE2	VARCHAR2	(150)		Payment text message
PAYMENT_TEXT_MESSAGE3	VARCHAR2	(150)		Payment text message
DELIVERY_CHANNEL_CODE	VARCHAR2	(30)	Yes	Delivery method
PAYMENT_FORMAT_CODE	VARCHAR2	(30)	Yes	Payment format code
EXCLUSIVE_PAYMENT_FLAG	VARCHAR2	(1)	Yes	Y or N flag that indicates if a document payable should be prevented from grouping with others into a payment
INACTIVE_DATE	DATE			Inactive date
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	(15)	Yes	Object version number

Query Text

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


SELECT TEMP_EXT_PAYEE_ID
,      PAYMENT_FUNCTION
,      PARTY_ID
,      ORG_TYPE
,      ORG_ID
,      BANK_CHARGE_BEARER
,      PARTY_SITE_ID
,      SUPPLIER_SITE_ID
,      DEFAULT_PAYMENT_METHOD_CODE
,      ECE_TP_LOCATION_CODE
,      BANK_INSTRUCTION1_CODE
,      BANK_INSTRUCTION2_CODE
,      BANK_INSTRUCTION_DETAILS
,      PAYMENT_REASON_CODE
,      PAYMENT_REASON_COMMENTS
,      PAYMENT_TEXT_MESSAGE1
,      PAYMENT_TEXT_MESSAGE2
,      PAYMENT_TEXT_MESSAGE3
,      DELIVERY_CHANNEL_CODE
,      PAYMENT_FORMAT_CODE
,      EXCLUSIVE_PAYMENT_FLAG
,      INACTIVE_DATE
,      CREATED_BY
,      CREATION_DATE
,      LAST_UPDATED_BY
,      LAST_UPDATE_DATE
,      LAST_UPDATE_LOGIN
,      OBJECT_VERSION_NUMBER
FROM IBY.IBY_TEMP_EXT_PAYEES;

Dependencies

[top of page]

IBY.IBY_TEMP_EXT_PAYEES does not reference any database object

IBY.IBY_TEMP_EXT_PAYEES is referenced by following:

IBY: IBY_TEMP_EXT_PAYEES#