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_INTERNAL_PAYERS_ALL

Object Details

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

IBY_INTERNAL_PAYERS_ALL stores payment-related attributes for the funds disbursement payment process for all first party payers. These attributes control the flow of payments.

Storage Details

Tablespace:	APPS_TS_TX_DATA
PCT Free:	10
PCT Used:

Indexes

Index	Type	Uniqueness	Tablespace	Column
IBY_INTERNAL_PAYERS_ALL_U1	NORMAL	UNIQUE	APPS_TS_TX_IDX	INT_PAYER_ID ZD_EDITION_NAME
IBY_INTERNAL_PAYERS_ALL_N1	NORMAL	NONUNIQUE	APPS_TS_TX_IDX	ORG_ID ORG_TYPE

Columns

Name	Datatype	Length	Mandatory	Comments
INT_PAYER_ID	NUMBER	(15)	Yes	System generated primary key
PAYMENT_METHOD_AT_PAYEE_FLAG	VARCHAR2	(1)	Yes	Stores the Allow Payee Override system option. This is a Y or N flag indicating whether defaults for the payment method attribute can be set at the payee or payee site levels. The defaults at payee or payee site levels override the ones set by defaulting rules. If set to N, any defaults previously set at the payee or payee site levels are ignored. There will be no override and the defaults are determined by the defaulting rules only.
DOCUMENT_REJECTION_LEVEL_CODE	VARCHAR2	(30)	Yes	Specifies what is rejected if a document payable fails validation. Values from the IBY_DOCUMENT_REJECTION_LEVELS lookup include REQUEST, PAYEE, and DOCUMENT.
PAYMENT_REJECTION_LEVEL_CODE	VARCHAR2	(30)	Yes	Specifies how much of a payment process request is rejected if a payment fails validation. Values from the IBY_PAYMENT_REJECTION_LEVELS lookup include REQUEST, PAYMENT, and NONE.
REQUIRE_PROP_PMTS_REVIEW_FLAG	VARCHAR2	(1)	Yes	Flag indicating whether Payments should stop the payment creation flow to allow an administrator to review and modify proposed payments before grouping them into payment instructions. Values from the lookup IBY_PROPOSED_PMTS_REVIEW_CODES include Y and N.
ALLOW_EXT_ACCT_OVERRIDE_FLAG	VARCHAR2	(1)	Yes	Y or N flag indicating whether the external bank account can be overridden
EXCLUSIVE_PAYMENT_FLAG	VARCHAR2	(1)	Yes	Y or N flag indicating whether each document payable corresponds to one payment. The value in this column is a default for new payees.
SAVE_PAYMENT_FILE_IN_DB	VARCHAR2	(1)	Yes	Y or N flag indicating whether Oracle Payments saves a copy of the formatted payment instruction file in the database
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
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.
BANK_CHARGE_BEARER	VARCHAR2	(30)		Bearer of bank charge cost. Bank charge bearers are defined as the lookup IBY_BANK_CHARGE_BEARER.
PPR_REPORT_FORMAT	VARCHAR2	(60)		Format to be used for the Payment Process Request Status Report. Set in the Disbursement System Options user interface page
AUTOMATIC_PPR_REPORT_SUBMIT	VARCHAR2	(1)		Y or N flag represented by the Automatically Submit at Payment Process Request Completion checkbox on the Disbursement System Options user interface page
ZD_EDITION_NAME	VARCHAR2	(30)	Yes

Query Text

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


SELECT INT_PAYER_ID
,      PAYMENT_METHOD_AT_PAYEE_FLAG
,      DOCUMENT_REJECTION_LEVEL_CODE
,      PAYMENT_REJECTION_LEVEL_CODE
,      REQUIRE_PROP_PMTS_REVIEW_FLAG
,      ALLOW_EXT_ACCT_OVERRIDE_FLAG
,      EXCLUSIVE_PAYMENT_FLAG
,      SAVE_PAYMENT_FILE_IN_DB
,      CREATED_BY
,      CREATION_DATE
,      LAST_UPDATED_BY
,      LAST_UPDATE_DATE
,      LAST_UPDATE_LOGIN
,      OBJECT_VERSION_NUMBER
,      ORG_ID
,      ORG_TYPE
,      BANK_CHARGE_BEARER
,      PPR_REPORT_FORMAT
,      AUTOMATIC_PPR_REPORT_SUBMIT
,      ZD_EDITION_NAME
FROM IBY.IBY_INTERNAL_PAYERS_ALL;

Dependencies

[top of page]

IBY.IBY_INTERNAL_PAYERS_ALL does not reference any database object

IBY.IBY_INTERNAL_PAYERS_ALL is referenced by following:

IBY: IBY_INTERNAL_PAYERS_ALL#