IBY_PAY_INSTRUCTIONS_ALL
IBY_PAY_INSTRUCTIONS_ALL stores information on payment instructions. A payment instruction is a set of one or more payments submitted together to a payment system. This table corresponds to the Payment Instructions tab of the Funds Disbursement Process Home.
Details
-
Schema: FUSION
-
Object owner: IBY
-
Object type: TABLE
-
Tablespace: APPS_TS_TX_DATA
Primary Key
| Name | Columns |
|---|---|
|
IBY_PAY_INSTRUCTIONS_ALL_PK |
PAYMENT_INSTRUCTION_ID |
Columns
| Name | Datatype | Length | Precision | Not-null | Comments |
|---|---|---|---|---|---|
| PAYMENT_INSTRUCTION_ID | NUMBER | 18 | Yes | System generated primary key | |
| PAYMENT_PROFILE_ID | NUMBER | 18 | Yes | Payment process profile Identifier | |
| PROCESS_TYPE | VARCHAR2 | 30 | Yes | Specifies the process by which payments are built into payment instructions. Values from the lookup IBY_PROCESS_TYPES include STANDARD, IMMEDIATE, and MANUAL. | |
| PAYMENT_INSTRUCTION_STATUS | VARCHAR2 | 30 | Yes | Payment instruction status. Values from the lookup IBY_PAY_INSTRUCTION_STATUSES include CREATED, FORMATTED, and TRANSMITTED. | |
| PAYMENTS_COMPLETE_CODE | VARCHAR2 | 30 | Yes | Code indicating whether payments in the payment instruction have been marked as complete. Values from the lookup IBY_PAYMENTS_COMPLETE include YES, NO, and PARTIAL. | |
| GENERATE_SEP_REMIT_ADVICE_FLAG | VARCHAR2 | 1 | Yes | Y or N flag indicating whether a separate remittance advice needs to be created for a payment instruction. If the flag is set to Y, then at least one payment within the payment instruction requires a separate remittance advice. | |
| REMITTANCE_ADVICE_CREATED_FLAG | VARCHAR2 | 1 | Yes | Indicates whether any separate remittance advice documents were created for a payment instruction. By default this flag is set to N. | |
| REGULATORY_REPORT_CREATED_FLAG | VARCHAR2 | 1 | Yes | Indicates whether a regulatory report, for example, for central bank reporting, has been created for a payment instruction | |
| BILL_PAYABLE_FLAG | VARCHAR2 | 1 | Yes | Y or N flag indicating whether a payment instruction consists of bills payable | |
| LEGAL_ENTITY_ID | NUMBER | 18 | Legal entity Identifier of the payment instruction. This column is populated only when first party legal entity is specified as a grouping rule for payment instruction creation. | ||
| PAYMENT_COUNT | NUMBER | 18 | Yes | Number of payments comprising this instruction | |
| POSITIVE_PAY_FILE_CREATED_FLAG | VARCHAR2 | 1 | Yes | Indicates whether a positive pay file has been created for a payment instruction | |
| PRINT_INSTRUCTION_IMMED_FLAG | VARCHAR2 | 1 | Yes | Y or N flag indicating whether the payment instruction is printed immediately after the payment instruction is created | |
| TRANSMIT_INSTR_IMMED_FLAG | VARCHAR2 | 1 | Yes | Y or N flag indicating whether the payment instruction is transmitted immediately after the payment instruction is created | |
| 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. | |
| INTERNAL_BANK_ACCOUNT_ID | NUMBER | 18 | Internal bank account Identifier of the payment instruction. This column is populated only when internal bank account is specified as a grouping rule for payment instruction creation. This column is always populated for printed payment instructions, as they are required to be created for a single internal bank account. | ||
| PAY_ADMIN_ASSIGNED_REF_CODE | VARCHAR2 | 100 | Administrator assigned reference code | ||
| TRANSMISSION_DATE | DATE | Date that the payment instruction is sent to the bank | |||
| ACKNOWLEDGEMENT_DATE | DATE | Acknowledgment date | |||
| COMMENTS | VARCHAR2 | 240 | User entered notes | ||
| BANK_ASSIGNED_REF_CODE | VARCHAR2 | 30 | Payment system-provided reference code for this payment instruction | ||
| ORG_ID | NUMBER | 18 | Indicates the identifier of the business unit associated to the row. | ||
| ORG_TYPE | VARCHAR2 | 30 | Organization type. Values from the lookup IBY_ORGANIZATION_TYPES include Operating Unit, Business Group, and Legal Entity. | ||
| PAYMENT_DATE | DATE | Payment date of the payment instruction. This column is populated only when payment date is specified as a grouping rule for payment instruction creation. | |||
| PAYMENT_CURRENCY_CODE | VARCHAR2 | 10 | Currency of the payment instruction. This column is populated only when payment currency is specified as a grouping rule for payment instruction creation. This column is always populated for printed payment instructions, as they are required to be for a single payment currency. | ||
| PAYMENT_SERVICE_REQUEST_ID | NUMBER | 18 | Identifier of the payment process request which had its payments grouped into the payment instruction. This column is populated when payment process request is specified as a grouping rule for payment instruction creation. | ||
| PAYMENT_FUNCTION | VARCHAR2 | 30 | Function or purpose of the payment. Values from the lookup IBY_PAYMENT_FUNCTIONS include SUPPLIER_PAYMENT, CUSTOMER_REFUNDS, and others. | ||
| PAYMENT_REASON_CODE | VARCHAR2 | 30 | Payment reason code. This column is populated when Payment Reason is specified as a grouping rule for payment instruction creation. | ||
| RFC_IDENTIFIER | VARCHAR2 | 30 | Identifier of the regional finance center at the bank branch level pertaining to the payments in the instruction. This column is populated when RFC is specified as a grouping rule for payment instruction creation. | ||
| PAYMENT_REASON_COMMENTS | VARCHAR2 | 240 | Free text describing a reason for the payments in the instruction. This column is populated when Payment Reason is specified as a grouping rule for payment instruction creation. | ||
| PAYMENT_DOCUMENT_ID | NUMBER | 18 | Payment document that was passed to the payment instruction creation program, if it is different from the default in the payment process profile | ||
| PRINTER_NAME | VARCHAR2 | 255 | Name of the printer to be used for printed checks | ||
| ATTRIBUTE_CATEGORY | VARCHAR2 | 150 | Descriptive Flexfield: structure definition of the user descriptive flexfield. | ||
| ATTRIBUTE1 | VARCHAR2 | 150 | Descriptive Flexfield: segment of the user descriptive flexfield. | ||
| ATTRIBUTE2 | VARCHAR2 | 150 | Descriptive Flexfield: segment of the user descriptive flexfield. | ||
| ATTRIBUTE3 | VARCHAR2 | 150 | Descriptive Flexfield: segment of the user descriptive flexfield. | ||
| ATTRIBUTE4 | VARCHAR2 | 150 | Descriptive Flexfield: segment of the user descriptive flexfield. | ||
| ATTRIBUTE5 | VARCHAR2 | 150 | Descriptive Flexfield: segment of the user descriptive flexfield. | ||
| ATTRIBUTE6 | VARCHAR2 | 150 | Descriptive Flexfield: segment of the user descriptive flexfield. | ||
| ATTRIBUTE7 | VARCHAR2 | 150 | Descriptive Flexfield: segment of the user descriptive flexfield. | ||
| ATTRIBUTE8 | VARCHAR2 | 150 | Descriptive Flexfield: segment of the user descriptive flexfield. | ||
| ATTRIBUTE9 | VARCHAR2 | 150 | Descriptive Flexfield: segment of the user descriptive flexfield. | ||
| ATTRIBUTE10 | VARCHAR2 | 150 | Descriptive Flexfield: segment of the user descriptive flexfield. | ||
| ATTRIBUTE11 | VARCHAR2 | 150 | Descriptive Flexfield: segment of the user descriptive flexfield. | ||
| ATTRIBUTE12 | VARCHAR2 | 150 | Descriptive Flexfield: segment of the user descriptive flexfield. | ||
| ATTRIBUTE13 | VARCHAR2 | 150 | Descriptive Flexfield: segment of the user descriptive flexfield. | ||
| ATTRIBUTE14 | VARCHAR2 | 150 | Descriptive Flexfield: segment of the user descriptive flexfield. | ||
| ATTRIBUTE15 | VARCHAR2 | 150 | Descriptive Flexfield: segment of the user descriptive flexfield. | ||
| REFERENCE_FORMAT_CODE | VARCHAR2 | 30 | Reference format code | ||
| REQUEST_ID | NUMBER | 18 | Enterprise Service Scheduler: indicates the request ID of the job that created or last updated the row. | ||
| BATCH_BOOKING_FLAG | VARCHAR2 | 1 | Batch booking flag | ||
| CARD_ISSUER_FILE_SEQ_NO | NUMBER | 15 | Numeric sequence of AMEX remittance file sent by customer. This number is used by American Express to check for skipped or duplicated files. | ||
| NOTIFICATION_MESSAGE_ID | NUMBER | 18 | Notification message identifier. | ||
| INBOUND_FILE_ID | NUMBER | 18 | Identifier of the inbound payment file. | ||
| BEP_STATUS | VARCHAR2 | 30 | Status returned by the bank or payment system. | ||
| BEP_ERROR_CODE | VARCHAR2 | 30 | Error code from bank or payment system. | ||
| BEP_ERROR_MESSAGE_TEXT | VARCHAR2 | 255 | Error message from bank or payment system. | ||
| ACKNOWLEDGEMENT_FORMAT_CODE | VARCHAR2 | 30 | Code of the acknowledgment format used for the payment file. | ||
| CES_TRANSMISSION_FLAG | VARCHAR2 | 1 | Indicates if the payment file is transmitted using Oracle Connected Partners. | ||
| SENT_FILE_NAME | VARCHAR2 | 360 | Name of the payment file transmitted to the bank. | ||
| PAYMENT_MODE_CODE | VARCHAR2 | 30 | Invoice payment mode identifier. | ||
| PAYMENT_INSTRUMENT_ID | NUMBER | 18 | Funding instrument used for making payments. |
Foreign Keys
| Table | Foreign Table | Foreign Key Column |
|---|---|---|
| IBY_PAY_INSTRUCTIONS_ALL | iby_acct_pmt_profiles_b | PAYMENT_PROFILE_ID |
| IBY_PAY_INSTRUCTIONS_ALL | iby_pay_service_requests | PAYMENT_SERVICE_REQUEST_ID |
| IBY_PAY_INSTRUCTIONS_ALL | ce_bank_accounts | INTERNAL_BANK_ACCOUNT_ID |
| ap_checks_all | iby_pay_instructions_all | PAYMENT_INSTRUCTION_ID |
| iby_payments_all | iby_pay_instructions_all | PAYMENT_INSTRUCTION_ID |
| iby_status_overrides | iby_pay_instructions_all | PAYMENT_INSTRUCTION_ID |
| jl_br_ap_bank_returns_all | iby_pay_instructions_all | PAYMENT_INSTRUCTION_ID |
| iby_logical_pmt_groups | iby_pay_instructions_all | PAYMENT_INSTRUCTION_ID |
| iby_trxn_documents | iby_pay_instructions_all | PAYMENT_INSTRUCTION_ID |
| iby_instruct_source_apps | iby_pay_instructions_all | PAYMENT_INSTRUCTION_ID |
| iby_file_acks | iby_pay_instructions_all | PAYMENT_INSTRUCTION_ID |
| iby_payments_h | iby_pay_instructions_all | PAYMENT_INSTRUCTION_ID |
Indexes
| Index | Uniqueness | Tablespace | Columns |
|---|---|---|---|
| IBY_PAY_INSTRUCTIONS_ALL_N1 | Non Unique | Default | PAYMENT_PROFILE_ID |
| IBY_PAY_INSTRUCTIONS_ALL_N10 | Non Unique | Default | LAST_UPDATE_DATE |
| IBY_PAY_INSTRUCTIONS_ALL_N2 | Non Unique | Default | PAYMENT_DATE |
| IBY_PAY_INSTRUCTIONS_ALL_N3 | Non Unique | Default | PAYMENT_SERVICE_REQUEST_ID |
| IBY_PAY_INSTRUCTIONS_ALL_N4 | Non Unique | Default | PAYMENT_REASON_CODE |
| IBY_PAY_INSTRUCTIONS_ALL_N5 | Non Unique | Default | INTERNAL_BANK_ACCOUNT_ID |
| IBY_PAY_INSTRUCTIONS_ALL_N6 | Non Unique | Default | PAYMENT_INSTRUCTION_STATUS |
| IBY_PAY_INSTRUCTIONS_ALL_N7 | Non Unique | Default | BANK_ASSIGNED_REF_CODE |
| IBY_PAY_INSTRUCTIONS_ALL_N8 | Non Unique | Default | UPPER("PAY_ADMIN_ASSIGNED_REF_CODE") |
| IBY_PAY_INSTRUCTIONS_ALL_N9 | Non Unique | Default | CREATION_DATE |
| IBY_PAY_INSTRUCTIONS_ALL_U1 | Unique | Default | PAYMENT_INSTRUCTION_ID |