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

TABLE: IBY.IBY_PAYMENTS_H

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


IBY_PAYMENTS_H table stores historical snapshots of payments. This table contains denormalized versions of payments from specific points in time, including when the payment was submitted to a payment system. Different snapshots of the same payment can exist in this table. These snapshots are differentiated by the table's primary key and a snapshot date.


Storage Details
Tablespace: TablespaceAPPS_TS_TX_DATA
PCT Free: 10
PCT Used:
Columns
Name Datatype Length Mandatory Comments
PAYMENT_HISTORY_ID NUMBER (15) Yes System generated primary key
PAYMENT_HISTORY_DATE DATE
Yes Payment snapshot date
PAYMENT_INSTRUCTION_HISTORY_ID NUMBER (15) Yes Associated payment instruction snapshot Identifier
PAYMENT_ID NUMBER (15) Yes Payment Identifier
PROCESSING_TYPE VARCHAR2 (30) Yes Specifies the type of processing from the payment process profile. Values from the lookup IBY_PROCESSING_TYPES include ELECTRONIC and PRINTED.
BILL_PAYABLE_FLAG VARCHAR2 (1) Yes Y or N flag indicating whether a payment is a bill payable
EXCLUSIVE_PAYMENT_FLAG VARCHAR2 (1) Yes Y or N flag indicating whether this payment is made up of a single document payable that was meant to be paid alone.
PAYMENTS_COMPLETE_FLAG VARCHAR2 (1) Yes Y or N flag indicating whether the payment has been marked as complete.
STOP_CONFIRMED_FLAG VARCHAR2 (1) Yes Y or N flag indicating whether a stop has been confirmed on this payment
STOP_RELEASED_FLAG VARCHAR2 (1) Yes Y or N flag indicating whether a stop request has been released on this payment
STOP_REQUEST_PLACED_FLAG VARCHAR2 (1) Yes Y or N flag indicating whether a stop request has been placed on this payment.
CREATED_BY NUMBER (15) Yes Standard Who column
CREATION_DATE DATE
Yes Standard Who column
LAST_UPDATED_BY NUMBER (15) Yes Standard Who column
LAST_UPDATE_DATE DATE
Yes Standard Who column
OBJECT_VERSION_NUMBER NUMBER
Yes Object version number
LAST_UPDATE_LOGIN NUMBER (15)
Standard Who column
DECLARATION_OPTION VARCHAR2 (30)
Specifies the customer's chosen declaration option from the payment process profile
DCL_ONLY_FOREIGN_CURR_PMT_FLAG VARCHAR2 (1)
Yor N flag to specify whether only foreign currency payments or all payments are declared from the payment process profile
DECLARATION_REPORT_FORMAT_CODE VARCHAR2 (30)
Only needed if the DECLARATION_OPTION is set to DECLARE_DIRECT_TO_CENTRAL_BANK from the payment process profile
DECLARATION_CURR_FX_RATE_TYPE VARCHAR2 (255)
Indicates the type of exchange rate from the payment process profile
DECLARATION_CURRENCY_CODE VARCHAR2 (10)
Currency of the declaration amount
DECLARATION_THRESHOLD_AMOUNT NUMBER

From the payment process profile, the threshold amount above which the payment needs to be reported to the central bank
PAYMENT_DETAILS_FORMULA VARCHAR2 (240)
From the payment process profile, SQL function used to concatenate the document attributes into the payment details information
BANK_INSTRUCTION1_CODE VARCHAR2 (30) Yes Code of first bank instruction, from the payment process profile
BANK_INSTRUCTION2_CODE VARCHAR2 (30) Yes Code of second bank instruction, from the payment process profile
BANK_INSTRUCTION_DETAILS VARCHAR2 (255)
Additional bank instruction details from the payment process profile
PAYMENT_TEXT_MESSAGE1 VARCHAR2 (150)
From the payment process profile, text message for use in payment processing.
PAYMENT_TEXT_MESSAGE2 VARCHAR2 (150)
From the payment process profile, text message for use in payment processing.
PAYMENT_SERVICE_REQUEST_ID NUMBER (15) Yes Payment process request Identifier
PROCESS_TYPE VARCHAR2 (30) Yes Specifies the process by which the payment is built into a payment instruction. Values from the lookup IBY_PROCESS_TYPES include STANDARD, IMMEDIATE, and MANUAL.
PAYMENT_INSTRUCTION_ID NUMBER (15) Yes Payment instruction Identifier
PAYMENT_STATUS VARCHAR2 (30) Yes Payment status. Values from the lookup IBY_PAYMENT_STATUSES include CREATED, FORMATTED, and TRANSMITTED.
PAYMENT_FUNCTION VARCHAR2 (30) Yes 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) Yes Payment reason code
PAYMENT_REASON_COMMENTS VARCHAR2 (240) Yes Free text field available for entering a reason for the payment
PAYMENT_DATE DATE

Payment date
ANTICIPATED_VALUE_DATE DATE

Anticipated value date
PAYMENT_AMOUNT NUMBER
Yes Amount of the payment
PAYMENT_CURRENCY_CODE VARCHAR2 (10) Yes Currency of the payment
MATURITY_DATE DATE

Calculated maturity date on a bill payable payment, that is, future dated payment
PAYMENT_DUE_DATE DATE

Date on which the payment is made
DECLARE_PAYMENT_FLAG VARCHAR2 (1)
Y or N flag that indicates whether this payment needs to be reported to the central bank
DECLARATION_AMOUNT NUMBER

Sum of all reporting amounts from the documents that constitute this payment. This amount is in the declaration or reporting currency
DISCOUNT_AMOUNT_TAKEN NUMBER

Discount amount, in payment currency
PAYMENT_DETAILS VARCHAR2 (240)
Concatenated string that represents the payment details
BANK_CHARGE_BEARER VARCHAR2 (30)
Bearer of bank charge cost. Bank charge bearers are defined as the lookup IBY_BANK_CHARGE_BEARER.
BANK_CHARGE_AMOUNT NUMBER

Bank charge amount in the payment currency
DELIVERY_FORMAT_VALUE VARCHAR2 (80) Yes Delivery value required by the payment format that uses this delivery channel
SETTLEMENT_PRIORITY VARCHAR2 (30)
Priority with which the financial institution or payment system settles payment for this document. The available values for this column come from the FND lookup IBY_SETTLEMENT_PRIORITY.
REMITTANCE_MESSAGE1 VARCHAR2 (150)
Remittance message for use in payment processing
REMITTANCE_MESSAGE2 VARCHAR2 (150)
Remittance message for use in payment processing
REMITTANCE_MESSAGE3 VARCHAR2 (150)
Remittance message for use in payment processing
PAPER_DOCUMENT_NUMBER NUMBER (15)
Payment document number, if a printed payment
BANK_ASSIGNED_REF_CODE VARCHAR2 (30)
Bank-provided reference code for this payment
INT_BANK_ACCOUNT_NUMBER VARCHAR2 (30)
Internal bank account number from CE bank accounts
INT_BANK_ACCOUNT_ROUTING_NUM VARCHAR2 (30)
Internal bank account routing number from CE bank accounts
INT_BANK_ACCOUNT_IBAN_NUMBER VARCHAR2 (50)
Internal bank account IBAN number from CE bank accounts
EXT_BANK_ACCOUNT_NUMBER VARCHAR2 (100)
External bank account number from IBY bank accounts
EXT_BANK_ACCOUNT_ROUTING_NUM VARCHAR2 (30)
External bank account routing number from CE bank accounts
EXT_BANK_ACCOUNT_BANK_NAME VARCHAR2 (360)
Internal bank account bank name from IBY bank accounts
EXT_BANK_ACCOUNT_BRANCH_NAME VARCHAR2 (360)
Internal bank account branch name from IBY bank accounts
EXT_BANK_ACCOUNT_BRANCH_NUMBER VARCHAR2 (30)
Internal bank account branch number from IBY bank accounts
EXT_BANK_ACCOUNT_IBAN_NUMBER VARCHAR2 (50)
Internal bank account IBAN number from IBY bank accounts
EXT_BANK_ACCOUNT_SWIFT_CODE VARCHAR2 (30)
Internal bank account SWIFT code from IBY bank accounts
EXT_PAYEE_ID NUMBER (15)
External payee Identifier
PAYEE_PARTY_ID NUMBER (15)
TCA party Identifier
PARTY_SITE_ID NUMBER (15)
Payee party site Identifier
SUPPLIER_SITE_ID NUMBER (15)
Supplier site Identifier
BENEFICIARY_PARTY NUMBER (15)
Beneficiary party if payment is made through a third party
ORG_ID NUMBER (15) Yes Organization Identifier
ORG_TYPE VARCHAR2 (30)
Organization type. Values from the lookup IBY_ORGANIZATION_TYPES nclude Operating Unit, Business Group, and Legal Entity.
ORG_NAME VARCHAR2 (240) Yes Organization name from HR organizations
LEGAL_ENTITY_ID NUMBER (15) Yes Legal entity Identifier
PARTY_NAME VARCHAR2 (360)
Name of party from TCA parties
COUNTRY VARCHAR2 (60) Yes Country code from the TERRITORY_CODE column in the FND_TERRITORY table from TCA location
ADDRESS1 VARCHAR2 (240)
First line for address from TCA location
ADDRESS2 VARCHAR2 (240)
Second line for address from TCA location
ADDRESS3 VARCHAR2 (240)
Third line for address from TCA location
ADDRESS4 VARCHAR2 (240)
Fourth line for address from TCA location
CITY VARCHAR2 (60)
City from TCA location
POSTAL_CODE VARCHAR2 (60)
Postal code from TCA location
POSTAL_PLUS4_CODE VARCHAR2 (10)
Four digit extension to the United States Postal ZIP code from TCA location
STATE VARCHAR2 (60)
State from TCA location
PROVINCE VARCHAR2 (60)
Province from TCA location
COUNTY VARCHAR2 (60)
County from TCA location
UNIQUE_REMITTANCE_IDENTIFIER VARCHAR2 (30)
Unique remittance Identifier provided by the payee
URI_CHECK_DIGIT VARCHAR2 (2)
Unique remittance Identifier check digit
DOCUMENT_CATEGORY_CODE VARCHAR2 (30)
Document category code
DOCUMENT_SEQUENCE_ID NUMBER

Document Sequence ID
DOCUMENT_SEQUENCE_VALUE NUMBER

Document sequence value
STOP_CONFIRMED_BY NUMBER (15)
User who confirmed the stop
STOP_CONFIRM_DATE DATE

Date on which the stop was confirmed
STOP_CONFIRM_REASON VARCHAR2 (240)
Reason for confirming the stop
STOP_CONFIRM_REFERENCE VARCHAR2 (100)
Payment system reference code for the confirmed stop payment
STOP_RELEASED_BY NUMBER (15)
User who released the stop request
STOP_RELEASE_DATE DATE

Date on which the stop request was released
STOP_RELEASE_REASON VARCHAR2 (240)
Reason for releasing the stop request
STOP_RELEASE_REFERENCE VARCHAR2 (100)
Payment system reference code for releasing or denying the stop request.
STOP_REQUEST_DATE DATE

Date on which the stop request was placed
STOP_REQUEST_PLACED_BY NUMBER (15)
User who placed the stop request
STOP_REQUEST_REASON VARCHAR2 (240)
Reason for placing the stop request
STOP_REQUEST_REFERENCE VARCHAR2 (100)
Payment system reference code for the stop request
VOIDED_BY NUMBER (15)
User who voided the payment
VOID_DATE DATE

Date on which the payment was voided
VOID_REASON VARCHAR2 (240)
Reason for voiding the payment
ATTRIBUTE_CATEGORY VARCHAR2 (150)
Descriptive Flexfield structure defining column
ATTRIBUTE1 VARCHAR2 (150)
Descriptive Flexfield segment
ATTRIBUTE2 VARCHAR2 (150)
Descriptive Flexfield segment
ATTRIBUTE3 VARCHAR2 (150)
Descriptive Flexfield segment
ATTRIBUTE4 VARCHAR2 (150)
Descriptive Flexfield segment
ATTRIBUTE5 VARCHAR2 (150)
Descriptive Flexfield segment
ATTRIBUTE6 VARCHAR2 (150)
Descriptive Flexfield segment
ATTRIBUTE7 VARCHAR2 (150)
Descriptive Flexfield segment
ATTRIBUTE8 VARCHAR2 (150)
Descriptive Flexfield segment
ATTRIBUTE9 VARCHAR2 (150)
Descriptive Flexfield segment
ATTRIBUTE10 VARCHAR2 (150)
Descriptive Flexfield segment
ATTRIBUTE11 VARCHAR2 (150)
Descriptive Flexfield segment
ATTRIBUTE12 VARCHAR2 (150)
Descriptive Flexfield segment
ATTRIBUTE13 VARCHAR2 (150)
Descriptive Flexfield segment
ATTRIBUTE14 VARCHAR2 (150)
Descriptive Flexfield segment
ATTRIBUTE15 VARCHAR2 (150)
Descriptive Flexfield segment
Query Text

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


SELECT PAYMENT_HISTORY_ID
,      PAYMENT_HISTORY_DATE
,      PAYMENT_INSTRUCTION_HISTORY_ID
,      PAYMENT_ID
,      PROCESSING_TYPE
,      BILL_PAYABLE_FLAG
,      EXCLUSIVE_PAYMENT_FLAG
,      PAYMENTS_COMPLETE_FLAG
,      STOP_CONFIRMED_FLAG
,      STOP_RELEASED_FLAG
,      STOP_REQUEST_PLACED_FLAG
,      CREATED_BY
,      CREATION_DATE
,      LAST_UPDATED_BY
,      LAST_UPDATE_DATE
,      OBJECT_VERSION_NUMBER
,      LAST_UPDATE_LOGIN
,      DECLARATION_OPTION
,      DCL_ONLY_FOREIGN_CURR_PMT_FLAG
,      DECLARATION_REPORT_FORMAT_CODE
,      DECLARATION_CURR_FX_RATE_TYPE
,      DECLARATION_CURRENCY_CODE
,      DECLARATION_THRESHOLD_AMOUNT
,      PAYMENT_DETAILS_FORMULA
,      BANK_INSTRUCTION1_CODE
,      BANK_INSTRUCTION2_CODE
,      BANK_INSTRUCTION_DETAILS
,      PAYMENT_TEXT_MESSAGE1
,      PAYMENT_TEXT_MESSAGE2
,      PAYMENT_SERVICE_REQUEST_ID
,      PROCESS_TYPE
,      PAYMENT_INSTRUCTION_ID
,      PAYMENT_STATUS
,      PAYMENT_FUNCTION
,      PAYMENT_REASON_CODE
,      PAYMENT_REASON_COMMENTS
,      PAYMENT_DATE
,      ANTICIPATED_VALUE_DATE
,      PAYMENT_AMOUNT
,      PAYMENT_CURRENCY_CODE
,      MATURITY_DATE
,      PAYMENT_DUE_DATE
,      DECLARE_PAYMENT_FLAG
,      DECLARATION_AMOUNT
,      DISCOUNT_AMOUNT_TAKEN
,      PAYMENT_DETAILS
,      BANK_CHARGE_BEARER
,      BANK_CHARGE_AMOUNT
,      DELIVERY_FORMAT_VALUE
,      SETTLEMENT_PRIORITY
,      REMITTANCE_MESSAGE1
,      REMITTANCE_MESSAGE2
,      REMITTANCE_MESSAGE3
,      PAPER_DOCUMENT_NUMBER
,      BANK_ASSIGNED_REF_CODE
,      INT_BANK_ACCOUNT_NUMBER
,      INT_BANK_ACCOUNT_ROUTING_NUM
,      INT_BANK_ACCOUNT_IBAN_NUMBER
,      EXT_BANK_ACCOUNT_NUMBER
,      EXT_BANK_ACCOUNT_ROUTING_NUM
,      EXT_BANK_ACCOUNT_BANK_NAME
,      EXT_BANK_ACCOUNT_BRANCH_NAME
,      EXT_BANK_ACCOUNT_BRANCH_NUMBER
,      EXT_BANK_ACCOUNT_IBAN_NUMBER
,      EXT_BANK_ACCOUNT_SWIFT_CODE
,      EXT_PAYEE_ID
,      PAYEE_PARTY_ID
,      PARTY_SITE_ID
,      SUPPLIER_SITE_ID
,      BENEFICIARY_PARTY
,      ORG_ID
,      ORG_TYPE
,      ORG_NAME
,      LEGAL_ENTITY_ID
,      PARTY_NAME
,      COUNTRY
,      ADDRESS1
,      ADDRESS2
,      ADDRESS3
,      ADDRESS4
,      CITY
,      POSTAL_CODE
,      POSTAL_PLUS4_CODE
,      STATE
,      PROVINCE
,      COUNTY
,      UNIQUE_REMITTANCE_IDENTIFIER
,      URI_CHECK_DIGIT
,      DOCUMENT_CATEGORY_CODE
,      DOCUMENT_SEQUENCE_ID
,      DOCUMENT_SEQUENCE_VALUE
,      STOP_CONFIRMED_BY
,      STOP_CONFIRM_DATE
,      STOP_CONFIRM_REASON
,      STOP_CONFIRM_REFERENCE
,      STOP_RELEASED_BY
,      STOP_RELEASE_DATE
,      STOP_RELEASE_REASON
,      STOP_RELEASE_REFERENCE
,      STOP_REQUEST_DATE
,      STOP_REQUEST_PLACED_BY
,      STOP_REQUEST_REASON
,      STOP_REQUEST_REFERENCE
,      VOIDED_BY
,      VOID_DATE
,      VOID_REASON
,      ATTRIBUTE_CATEGORY
,      ATTRIBUTE1
,      ATTRIBUTE2
,      ATTRIBUTE3
,      ATTRIBUTE4
,      ATTRIBUTE5
,      ATTRIBUTE6
,      ATTRIBUTE7
,      ATTRIBUTE8
,      ATTRIBUTE9
,      ATTRIBUTE10
,      ATTRIBUTE11
,      ATTRIBUTE12
,      ATTRIBUTE13
,      ATTRIBUTE14
,      ATTRIBUTE15
FROM IBY.IBY_PAYMENTS_H;

Dependencies

[top of page]

IBY.IBY_PAYMENTS_H does not reference any database object

IBY.IBY_PAYMENTS_H is referenced by following:

SchemaIBY
ViewIBY_PAYMENTS_H#