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

TABLE: IBY.IBY_DOCUMENTS_PAYABLE_H

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


IBY_DOCUMENTS_PAYABLE_H stores historical snapshots of documents payable. This table contains denormalized versions of documents payable from specific points in time, such as when the payment for this document was submitted to a payment system. Different snapshots of the same document payable 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
DOCUMENT_PAYABLE_HISTORY_ID NUMBER (15) Yes System generated primary key
DOCUMENT_PAYABLE_HISTORY_DATE DATE
Yes Document payable snapshot date
PAYMENT_HISTORY_ID NUMBER (15) Yes Associated payment snapshot Identifier
PAY_PROC_TRXN_TYPE_CODE VARCHAR2 (100) Yes Type of payment processing transaction or document
CALLING_APP_ID NUMBER (15) Yes Source product Identifier
CALLING_APP_DOC_UNIQUE_REF1 VARCHAR2 (100) Yes Source product''s first unique document payable Identifier
CALLING_APP_DOC_UNIQUE_REF2 VARCHAR2 (100)
Source product''s second unique document payable Identifier
CALLING_APP_DOC_UNIQUE_REF3 VARCHAR2 (100)
Source product''s third unique document payable Identifier
CALLING_APP_DOC_UNIQUE_REF4 VARCHAR2 (100)
Source product''s fourth unique document payable Identifier
CALLING_APP_DOC_UNIQUE_REF5 VARCHAR2 (100)
Source product''s fifth unique document payable Identifier
CALLING_APP_DOC_REF_NUMBER NUMBER (15) Yes Reference number entered by user of the source product. Need not be unique
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
STRAIGHT_THROUGH_FLAG VARCHAR2 (1) Yes Y or N flag indicating whether the document payable has been processed without unexpected manual intervention
PO_NUMBER VARCHAR2 (255)
Purchase order numbers to which this document is matched. If multiple purchase orders, value is comma delimited.
DOCUMENT_PAYABLE_ID NUMBER (15) Yes Oracle Payments' unique internal document payable Identifier
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.
DOCUMENT_DATE DATE
Yes Date of document
DOCUMENT_TYPE VARCHAR2 (30) Yes Type of document payable. Values from the IBY_DOCUMENT_TYPES lookup include INVOICE.
DOCUMENT_DESCRIPTION VARCHAR2 (255)
Document description
DOCUMENT_STATUS VARCHAR2 (30) Yes Document status. Values from the lookup IBY_DOCS_PAYABLE_STATUSES include PAYMENT CREATED.
DOCUMENT_AMOUNT NUMBER
Yes Total document amount
DOCUMENT_CURRENCY_CODE VARCHAR2 (10) Yes Document currency code
DOC_CURRENCY_PAYMENT_AMOUNT NUMBER
Yes Amount to be paid in document currency
DOCUMENT_CURRENCY_TAX_AMOUNT NUMBER

Tax amount in document currency
DOCUMENT_CURR_CHARGE_AMOUNT NUMBER

Charge amount in document currency
PAYMENT_AMOUNT NUMBER
Yes Amount to be paid, in payment currency
PAYMENT_CURRENCY_CODE VARCHAR2 (10) Yes Payment currency code
PAYMENT_DUE_DATE DATE
Yes Date on which the payment is made
PAYMENT_CURR_DISCOUNT_TAKEN NUMBER

Discount taken, in payment currency
DISCOUNT_DATE DATE

Discount date
AMOUNT_WITHHELD NUMBER

Amount withheld
PAYMENT_SERVICE_REQUEST_ID NUMBER (15) Yes Identifier of the payment process request in which this document was submitted.
PAYMENT_METHOD_CODE VARCHAR2 (30) Yes Payment method Identifier.
PAYMENT_PROFILE_ID NUMBER (15) Yes Payment process profile Identifier
PAYMENT_ID NUMBER (15) Yes Identifier of the payment in which this document was paid
FORMATTING_PAYMENT_ID NUMBER (15)
Formatting payment identifier. This field identifies the payment stub on which this document's details are printed. This field is populated when the document has been grouped into a payment.
EXCLUSIVE_PAYMENT_FLAG VARCHAR2 (1) Yes Y or N flag indicating whether this document payable corresponds to one payment.
INT_BANK_ACCOUNT_ROUTING_NUM VARCHAR2 (30)
Internal bank account routing number from CE bank accounts
INT_BANK_ACCOUNT_NUMBER VARCHAR2 (30)
Internal bank account number from CE bank accounts
INT_BANK_ACCOUNT_IBAN_NUMBER VARCHAR2 (50)
Internal bank account IBAN number from CE bank accounts
EXT_BANK_ACCOUNT_ROUTING_NUM VARCHAR2 (30)
External bank account routing number from IBY bank accounts
EXT_BANK_ACCOUNT_NUMBER VARCHAR2 (30)
External bank account number from IBY 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
PARTY_SITE_ID NUMBER (15)
Payee party site Identifier
PAYEE_PARTY_ID NUMBER (15)
TCA party Identifier
SUPPLIER_SITE_ID NUMBER (15)
Supplier site 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
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 include Operating Unit, Business Group, and Legal Entity.
LEGAL_ENTITY_ID NUMBER (15) Yes Legal entity Identifier
BANK_CHARGE_BEARER VARCHAR2 (30)
Bearer of bank charge cost. Bank charge bearers are defined as the lookup IBY_BANK_CHARGE_BEARER.
INTEREST_RATE NUMBER

Interest rate on which this document payable was created if it is an interest invoice
PAYMENT_GROUPING_NUMBER NUMBER (15)
Payment grouping number. All documents with the same grouping number are automatically grouped into a single payment. No document in the payment group can be removed from the payment unless the whole payment is removed.
PAYMENT_REASON_FORMAT_VALUE VARCHAR2 (80)
Payment reason value required by the payment format that uses this payment reason
PAYMENT_REASON_COMMENTS VARCHAR2 (240)
Free text field available for entering a reason for the payment
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
UNIQUE_REMITTANCE_IDENTIFIER VARCHAR2 (30)
Unique remittance Identifier provided by the payee
URI_CHECK_DIGIT VARCHAR2 (2)
Unique remittance Identifier check digit
DELIVERY_FORMAT_VALUE VARCHAR2 (80) Yes Delivery value required by the payment format that uses this delivery channel
FORMAT_TEMPLATE_CODE VARCHAR2 (80) Yes Payment format code, as defined in the XML Publisher registry
EXTRACT_CODE VARCHAR2 (30)
Code for the extract version
DOCUMENT_CATEGORY_CODE VARCHAR2 (30)
Sequential numbering document category
DOCUMENT_SEQUENCE_ID NUMBER

Sequential numbering document sequence Identifier
DOCUMENT_SEQUENCE_VALUE NUMBER

Sequence number of document payable
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 DOCUMENT_PAYABLE_HISTORY_ID
,      DOCUMENT_PAYABLE_HISTORY_DATE
,      PAYMENT_HISTORY_ID
,      PAY_PROC_TRXN_TYPE_CODE
,      CALLING_APP_ID
,      CALLING_APP_DOC_UNIQUE_REF1
,      CALLING_APP_DOC_UNIQUE_REF2
,      CALLING_APP_DOC_UNIQUE_REF3
,      CALLING_APP_DOC_UNIQUE_REF4
,      CALLING_APP_DOC_UNIQUE_REF5
,      CALLING_APP_DOC_REF_NUMBER
,      CREATED_BY
,      CREATION_DATE
,      LAST_UPDATED_BY
,      LAST_UPDATE_DATE
,      OBJECT_VERSION_NUMBER
,      LAST_UPDATE_LOGIN
,      STRAIGHT_THROUGH_FLAG
,      PO_NUMBER
,      DOCUMENT_PAYABLE_ID
,      PAYMENT_FUNCTION
,      DOCUMENT_DATE
,      DOCUMENT_TYPE
,      DOCUMENT_DESCRIPTION
,      DOCUMENT_STATUS
,      DOCUMENT_AMOUNT
,      DOCUMENT_CURRENCY_CODE
,      DOC_CURRENCY_PAYMENT_AMOUNT
,      DOCUMENT_CURRENCY_TAX_AMOUNT
,      DOCUMENT_CURR_CHARGE_AMOUNT
,      PAYMENT_AMOUNT
,      PAYMENT_CURRENCY_CODE
,      PAYMENT_DUE_DATE
,      PAYMENT_CURR_DISCOUNT_TAKEN
,      DISCOUNT_DATE
,      AMOUNT_WITHHELD
,      PAYMENT_SERVICE_REQUEST_ID
,      PAYMENT_METHOD_CODE
,      PAYMENT_PROFILE_ID
,      PAYMENT_ID
,      FORMATTING_PAYMENT_ID
,      EXCLUSIVE_PAYMENT_FLAG
,      INT_BANK_ACCOUNT_ROUTING_NUM
,      INT_BANK_ACCOUNT_NUMBER
,      INT_BANK_ACCOUNT_IBAN_NUMBER
,      EXT_BANK_ACCOUNT_ROUTING_NUM
,      EXT_BANK_ACCOUNT_NUMBER
,      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
,      PARTY_SITE_ID
,      PAYEE_PARTY_ID
,      SUPPLIER_SITE_ID
,      PARTY_NAME
,      COUNTRY
,      ADDRESS1
,      ADDRESS2
,      ADDRESS3
,      ADDRESS4
,      CITY
,      POSTAL_CODE
,      POSTAL_PLUS4_CODE
,      STATE
,      PROVINCE
,      COUNTY
,      BENEFICIARY_PARTY
,      ORG_ID
,      ORG_TYPE
,      LEGAL_ENTITY_ID
,      BANK_CHARGE_BEARER
,      INTEREST_RATE
,      PAYMENT_GROUPING_NUMBER
,      PAYMENT_REASON_FORMAT_VALUE
,      PAYMENT_REASON_COMMENTS
,      SETTLEMENT_PRIORITY
,      REMITTANCE_MESSAGE1
,      REMITTANCE_MESSAGE2
,      REMITTANCE_MESSAGE3
,      UNIQUE_REMITTANCE_IDENTIFIER
,      URI_CHECK_DIGIT
,      DELIVERY_FORMAT_VALUE
,      FORMAT_TEMPLATE_CODE
,      EXTRACT_CODE
,      DOCUMENT_CATEGORY_CODE
,      DOCUMENT_SEQUENCE_ID
,      DOCUMENT_SEQUENCE_VALUE
,      ATTRIBUTE_CATEGORY
,      ATTRIBUTE1
,      ATTRIBUTE2
,      ATTRIBUTE3
,      ATTRIBUTE4
,      ATTRIBUTE5
,      ATTRIBUTE6
,      ATTRIBUTE7
,      ATTRIBUTE8
,      ATTRIBUTE9
,      ATTRIBUTE10
,      ATTRIBUTE11
,      ATTRIBUTE12
,      ATTRIBUTE13
,      ATTRIBUTE14
,      ATTRIBUTE15
FROM IBY.IBY_DOCUMENTS_PAYABLE_H;

Dependencies

[top of page]

IBY.IBY_DOCUMENTS_PAYABLE_H does not reference any database object

IBY.IBY_DOCUMENTS_PAYABLE_H is referenced by following:

SchemaIBY
ViewIBY_DOCUMENTS_PAYABLE_H#