Skip to content

DBA Data[Home] [Help] [Dependency Information]

TABLE: IBY.IBY_ACK_PMT_ALL

Object Details
Object Name: IBY_ACK_PMT_ALL
Object Type: TABLE
Owner: IBY
FND Design Data: TableIBY.IBY_ACK_PMT_ALL
Subobject Name:
Status: VALID

***** Warning: Oracle Internal Use Only *****

Oracle Corporation does not support access to Oracle
applications data using this object, except from standard Oracle Applications programs.

Storage Details
Tablespace: TablespaceAPPS_TS_TX_DATA
PCT Free: 10
PCT Used:
Columns
Name Datatype Length Mandatory Comments
ACK_PMT_ID NUMBER (15) Yes System generated primary key. Should be unique.
PAYMENT_REF_NUMBER NUMBER (15) Yes Payment reference number. This is the matching key.
PAYMENT_INSTRUCTION_REF_NUMBER NUMBER (15)
Payment instruction reference number.
BANK_STATUS_CODE VARCHAR2 (30) Yes Bank provided status code in payment acknowledgement file.
PAYMENT_ACK_STATUS VARCHAR2 (30) Yes Payment status as per lookup 'IBY_ACKNOWLEDGEMENT_STATUSES' which can be:ACCP, ACSP, ACWC, PNDG and RJCT
ACKNOWLEDGEMENT_DATE DATE
Yes Date of the acknowledgement, provided by the bank in the acknowledgement file
BANK_ASSIGNED_REF_CODE1 VARCHAR2 (80)
Bank provided reference code 1
BANK_ASSIGNED_REF_CODE2 VARCHAR2 (80)
Bank provided reference code 2
PAYER_NAME VARCHAR2 (360)
Payer name
PAYER_BANK_NAME VARCHAR2 (360)
Payer bank name
PAYER_BANK_BRANCH_NAME VARCHAR2 (360)
Payer bank branch name.
PAYER_BANK_SWIFT_CODE VARCHAR2 (12)
Payer bank swift code (BIC).
PAYER_BANK_ACCOUNT_NUMBER VARCHAR2 (30)
Payer bank account number.
PAYER_BANK_IBAN_NUMBER VARCHAR2 (40)
Payer bank account IBAN.
PAYEE_NAME VARCHAR2 (360)
Payee name.
PAYEE_BANK_NAME VARCHAR2 (360)
Payee bank name
PAYEE_BANK_BRANCH_NAME VARCHAR2 (360)
Payee bank branch name.
PAYEE_BANK_SWIFT_CODE VARCHAR2 (12)
Payee bank swift code (BIC).
PAYEE_BANK_ACCOUNT_NUMBER VARCHAR2 (30)
Payee bank account number.
PAYEE_BANK_IBAN_NUMBER VARCHAR2 (40)
Payee bank account IBAN.
PAYMENT_AMOUNT NUMBER

Payment amount
BANK_CHARGE_AMOUNT NUMBER

Bank charge amount
PAYMENT_CURRENCY_CODE VARCHAR2 (15)
The currency for the payment.
EXCHANGE_RATE NUMBER

The exchange rate.
CALCULATED_PAYMENT_AMOUNT NUMBER

This will be payment amount multiplied with exchange rate.
CALCULATED_BANK_CHARGE_AMOUNT NUMBER

This will be bank charge amount multiplied with exchange rate
VALUE_DATE DATE

The date bank withdrew funds from the payer bank account
REQUESTED_EXECUTION_DATE DATE

Date on which bank to debit payer bank account for making payment
CREATED_BY NUMBER (15) Yes Standard Who columns
CREATION_DATE DATE
Yes Standard Who columns
LAST_UPDATED_BY NUMBER (15) Yes Standard Who columns
LAST_UPDATE_DATE DATE
Yes Standard Who columns
LAST_UPDATE_LOGIN NUMBER (15)
Standard Who columns
Query Text

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


SELECT ACK_PMT_ID
,      PAYMENT_REF_NUMBER
,      PAYMENT_INSTRUCTION_REF_NUMBER
,      BANK_STATUS_CODE
,      PAYMENT_ACK_STATUS
,      ACKNOWLEDGEMENT_DATE
,      BANK_ASSIGNED_REF_CODE1
,      BANK_ASSIGNED_REF_CODE2
,      PAYER_NAME
,      PAYER_BANK_NAME
,      PAYER_BANK_BRANCH_NAME
,      PAYER_BANK_SWIFT_CODE
,      PAYER_BANK_ACCOUNT_NUMBER
,      PAYER_BANK_IBAN_NUMBER
,      PAYEE_NAME
,      PAYEE_BANK_NAME
,      PAYEE_BANK_BRANCH_NAME
,      PAYEE_BANK_SWIFT_CODE
,      PAYEE_BANK_ACCOUNT_NUMBER
,      PAYEE_BANK_IBAN_NUMBER
,      PAYMENT_AMOUNT
,      BANK_CHARGE_AMOUNT
,      PAYMENT_CURRENCY_CODE
,      EXCHANGE_RATE
,      CALCULATED_PAYMENT_AMOUNT
,      CALCULATED_BANK_CHARGE_AMOUNT
,      VALUE_DATE
,      REQUESTED_EXECUTION_DATE
,      CREATED_BY
,      CREATION_DATE
,      LAST_UPDATED_BY
,      LAST_UPDATE_DATE
,      LAST_UPDATE_LOGIN
FROM IBY.IBY_ACK_PMT_ALL;

Dependencies

[top of page]

IBY.IBY_ACK_PMT_ALL does not reference any database object

IBY.IBY_ACK_PMT_ALL is referenced by following:

SchemaIBY
ViewIBY_ACK_PMT_ALL#