[Home] [Help] [Dependency Information]
Object Name: | IBY_ACK_PMT_ALL |
---|---|
Object Type: | TABLE |
Owner: | IBY |
FND Design Data: | IBY.IBY_ACK_PMT_ALL |
Subobject Name: | |
Status: | VALID |
Oracle Corporation does not support access to Oracle
applications data using this object, except from standard Oracle Applications programs.
Tablespace: | APPS_TS_TX_DATA |
---|---|
PCT Free: | 10 |
PCT Used: |
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 |
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;
IBY.IBY_ACK_PMT_ALL does not reference any database object
IBY.IBY_ACK_PMT_ALL is referenced by following:
|
|
|