[Home] [Help] [Dependency Information]
Object Name: | IBY_ACK_PMT_ALL# |
---|---|
Object Type: | VIEW |
Owner: | IBY |
Subobject Name: | |
Status: | VALID |
Name | Datatype | Length | Mandatory | Comments |
---|---|---|---|---|
ACK_PMT_ID | NUMBER | (15) | Yes | |
PAYMENT_REF_NUMBER | NUMBER | (15) | Yes | |
PAYMENT_INSTRUCTION_REF_NUMBER | NUMBER | (15) | ||
BANK_STATUS_CODE | VARCHAR2 | (30) | Yes | |
PAYMENT_ACK_STATUS | VARCHAR2 | (30) | Yes | |
ACKNOWLEDGEMENT_DATE | DATE | Yes | ||
BANK_ASSIGNED_REF_CODE1 | VARCHAR2 | (80) | ||
BANK_ASSIGNED_REF_CODE2 | VARCHAR2 | (80) | ||
PAYER_NAME | VARCHAR2 | (360) | ||
PAYER_BANK_NAME | VARCHAR2 | (360) | ||
PAYER_BANK_BRANCH_NAME | VARCHAR2 | (360) | ||
PAYER_BANK_SWIFT_CODE | VARCHAR2 | (12) | ||
PAYER_BANK_ACCOUNT_NUMBER | VARCHAR2 | (30) | ||
PAYER_BANK_IBAN_NUMBER | VARCHAR2 | (40) | ||
PAYEE_NAME | VARCHAR2 | (360) | ||
PAYEE_BANK_NAME | VARCHAR2 | (360) | ||
PAYEE_BANK_BRANCH_NAME | VARCHAR2 | (360) | ||
PAYEE_BANK_SWIFT_CODE | VARCHAR2 | (12) | ||
PAYEE_BANK_ACCOUNT_NUMBER | VARCHAR2 | (30) | ||
PAYEE_BANK_IBAN_NUMBER | VARCHAR2 | (40) | ||
PAYMENT_AMOUNT | NUMBER | |||
BANK_CHARGE_AMOUNT | NUMBER | |||
PAYMENT_CURRENCY_CODE | VARCHAR2 | (15) | ||
EXCHANGE_RATE | NUMBER | |||
CALCULATED_PAYMENT_AMOUNT | NUMBER | |||
CALCULATED_BANK_CHARGE_AMOUNT | NUMBER | |||
VALUE_DATE | DATE | |||
REQUESTED_EXECUTION_DATE | DATE | |||
CREATED_BY | NUMBER | (15) | Yes | |
CREATION_DATE | DATE | Yes | ||
LAST_UPDATED_BY | NUMBER | (15) | Yes | |
LAST_UPDATE_DATE | DATE | Yes | ||
LAST_UPDATE_LOGIN | NUMBER | (15) |
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#;
|
|
|