[Home] [Help] [Dependency Information]
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.
Tablespace: | APPS_TS_TX_DATA |
---|---|
PCT Free: | 10 |
PCT Used: |
Index | Type | Uniqueness | Tablespace | Column |
---|---|---|---|---|
IBY_INTERNAL_PAYERS_ALL_U1 | NORMAL | UNIQUE | APPS_TS_TX_IDX | INT_PAYER_ID |
IBY_INTERNAL_PAYERS_ALL_N1 | NORMAL | NONUNIQUE | APPS_TS_TX_IDX |
ORG_ID
ORG_TYPE |
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 | (30) | 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 |
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
FROM IBY.IBY_INTERNAL_PAYERS_ALL;
IBY.IBY_INTERNAL_PAYERS_ALL does not reference any database object
IBY.IBY_INTERNAL_PAYERS_ALL is referenced by following:
|
|
|