IBY_INTERNAL_PAYERS_ALL
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.
Details
-
Schema: FUSION
-
Object owner: IBY
-
Object type: TABLE
-
Tablespace: REFERENCE
Primary Key
| Name | Columns |
|---|---|
|
IBY_INTERNAL_PAYERS_ALL_PK |
INT_PAYER_ID |
Columns
| Name | Datatype | Length | Precision | Not-null | Comments |
|---|---|---|---|---|---|
| INT_PAYER_ID | NUMBER | 18 | 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 | Yes or No flag indicating whether the external bank account can be overridden. | |
| EXCLUSIVE_PAYMENT_FLAG | VARCHAR2 | 1 | Yes | Yes or No flag that will default to new payees indicating whether documents payable should be prevented from being grouped with other like documents payable for payment. | |
| 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 | VARCHAR2 | 64 | Yes | Who column: indicates the user who created the row. | |
| CREATION_DATE | TIMESTAMP | Yes | Who column: indicates the date and time of the creation of the row. | ||
| LAST_UPDATED_BY | VARCHAR2 | 64 | Yes | Who column: indicates the user who last updated the row. | |
| LAST_UPDATE_DATE | TIMESTAMP | Yes | Who column: indicates the date and time of the last update of the row. | ||
| LAST_UPDATE_LOGIN | VARCHAR2 | 32 | Who column: indicates the session login associated to the user who last updated the row. | ||
| OBJECT_VERSION_NUMBER | NUMBER | 9 | Yes | Used to implement optimistic locking. This number is incremented every time that the row is updated. The number is compared at the start and end of a transaction to detect whether another session has updated the row since it was queried. | |
| ORG_ID | NUMBER | 18 | Indicates the identifier of the business unit associated to the row. | ||
| ORG_TYPE | VARCHAR2 | 30 | Organization type, such as business unit. Values taken from lookup: IBY_ORGANIZATION_TYPES | ||
| BANK_CHARGE_BEARER | VARCHAR2 | 30 | Party that is responsible for paying regular or express bank charges, such as Payee or Payer. Values taken from 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 | Yes or No flag represented by the automatically submit option for the Payment Process Request Status Report on the Disbursement System Options user interface page | ||
| SRA_SEND_FROM | VARCHAR2 | 1024 | Send from email address for Separate Remittance Advice | ||
| SRA_EMAIL_SUBJECT | VARCHAR2 | 1024 | Email subject line for Separate Remittance Advice | ||
| PAYMENTS_APPROVAL_FLAG | VARCHAR2 | 1 | Indicates whether payments go through the approval process at the batch level. Possible values are Y or N. | ||
| SEED_DATA_SOURCE | VARCHAR2 | 512 | Source of seed data record. A value of 'BULK_SEED_DATA_SCRIPT' indicates that record was bulk loaded. Otherwise, specifies the name of the seed data file. | ||
| ORA_SEED_SET1 | VARCHAR2 | 1 | Yes | Oracle internal use only. Indicates the edition-based redefinition (EBR) context of the row for SET1. Context values are Y or N. | |
| ORA_SEED_SET2 | VARCHAR2 | 1 | Yes | Oracle internal use only. Indicates the edition-based redefinition (EBR) context of the row for SET2. Context values are Y or N. |
Foreign Keys
| Table | Foreign Table | Foreign Key Column |
|---|---|---|
| IBY_INTERNAL_PAYERS_ALL | iby_formats_b | PPR_REPORT_FORMAT |
Indexes
| Index | Uniqueness | Tablespace | Columns |
|---|---|---|---|
| IBY_INTERNAL_PAYERS_ALL_N1 | Non Unique | Default | ORG_ID, ORG_TYPE |
| IBY_INTERNAL_PAYERS_ALL_U1 | Unique | Default | INT_PAYER_ID, ORA_SEED_SET1 |
| IBY_INTERNAL_PAYERS_ALL_U11 | Unique | Default | INT_PAYER_ID, ORA_SEED_SET2 |