1. Tables and Views for Financials
  2. IBY_DOCUMENTS_PAYABLE_H

IBY_DOCUMENTS_PAYABLE_H

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.

Details

  • Schema: FUSION

  • Object owner: IBY

  • Object type: TABLE

  • Tablespace: APPS_TS_TX_DATA

Primary Key

Name Columns

IBY_DOCUMENTS_PAYABLE_H_PK

DOCUMENT_PAYABLE_HISTORY_ID

Columns

Name Datatype Length Precision Not-null Comments
DOCUMENT_PAYABLE_HISTORY_ID NUMBER 18 Yes System-generated primary key.
DOCUMENT_PAYABLE_HISTORY_DATE DATE Yes Document payable snapshot date
PAYMENT_HISTORY_ID NUMBER 18 Yes Associated payment snapshot Identifier
PAY_PROC_TRXN_TYPE_CODE VARCHAR2 100 Yes Type of payment processing transaction or document
CALLING_APP_ID NUMBER 18 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 18 Yes Reference number entered by user of the source product. Need not be unique
CREATED_BY VARCHAR2 64 Yes Who column: indicates the user who created the row.
CREATION_DATE TIMESTAMP Yes Who column: indicates the date and time of the creation of the row.
LAST_UPDATED_BY VARCHAR2 64 Yes Who column: indicates the user who last updated the row.
LAST_UPDATE_DATE TIMESTAMP Yes Who column: indicates the date and time of the last update of the row.
OBJECT_VERSION_NUMBER NUMBER 9 Yes Used to implement optimistic locking. This number is incremented every time that the row is updated. The number is compared at the start and end of a transaction to detect whether another session has updated the row since it was queried.
LAST_UPDATE_LOGIN VARCHAR2 32 Who column: indicates the session login associated to the user who last updated the row.
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 18 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 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 18 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 18 Yes Payment process profile Identifier
PAYMENT_ID NUMBER 18 Yes Identifier of the payment in which this document was paid
FORMATTING_PAYMENT_ID NUMBER 18 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 Yes or No flag indicating whether this document payable should be prevented from being grouped with other like documents payable for 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 18 External payee Identifier
PARTY_SITE_ID NUMBER 18 Payee party site Identifier
PAYEE_PARTY_ID NUMBER 18 TCA party Identifier
SUPPLIER_SITE_ID NUMBER 18 Supplier site Identifier
PARTY_NAME VARCHAR2 360 Party name, denormalized from HZ_PARTIES_ALL.PARTY_NAME and derived via PARTY_ID.
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 18 Beneficiary party, if payment is made through a third party
ORG_ID NUMBER 18 Yes Indicates the identifier of the business unit associated to the row.
ORG_TYPE VARCHAR2 30 Organization type, such as business unit. Values taken from lookup: IBY_ORGANIZATION_TYPES
LEGAL_ENTITY_ID NUMBER 18 Yes Legal entity Identifier
BANK_CHARGE_BEARER VARCHAR2 30 Party that is responsible for paying regular or express bank charges, such as Payee or Payer. Values taken from 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 18 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 256 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 definition of the user descriptive flexfield.
ATTRIBUTE1 VARCHAR2 150 Descriptive Flexfield: segment of the user descriptive flexfield.
ATTRIBUTE2 VARCHAR2 150 Descriptive Flexfield: segment of the user descriptive flexfield.
ATTRIBUTE3 VARCHAR2 150 Descriptive Flexfield: segment of the user descriptive flexfield.
ATTRIBUTE4 VARCHAR2 150 Descriptive Flexfield: segment of the user descriptive flexfield.
ATTRIBUTE5 VARCHAR2 150 Descriptive Flexfield: segment of the user descriptive flexfield.
ATTRIBUTE6 VARCHAR2 150 Descriptive Flexfield: segment of the user descriptive flexfield.
ATTRIBUTE7 VARCHAR2 150 Descriptive Flexfield: segment of the user descriptive flexfield.
ATTRIBUTE8 VARCHAR2 150 Descriptive Flexfield: segment of the user descriptive flexfield.
ATTRIBUTE9 VARCHAR2 150 Descriptive Flexfield: segment of the user descriptive flexfield.
ATTRIBUTE10 VARCHAR2 150 Descriptive Flexfield: segment of the user descriptive flexfield.
ATTRIBUTE11 VARCHAR2 150 Descriptive Flexfield: segment of the user descriptive flexfield.
ATTRIBUTE12 VARCHAR2 150 Descriptive Flexfield: segment of the user descriptive flexfield.
ATTRIBUTE13 VARCHAR2 150 Descriptive Flexfield: segment of the user descriptive flexfield.
ATTRIBUTE14 VARCHAR2 150 Descriptive Flexfield: segment of the user descriptive flexfield.
ATTRIBUTE15 VARCHAR2 150 Descriptive Flexfield: segment of the user descriptive flexfield.
INVOICING_ORG_ID NUMBER 18 Invoicing Business Unit
INVOICING_ORG_TYPE VARCHAR2 30 Invoicing Organization Type
INV_EXT_PAYEE_ID NUMBER 18 External payee associated with the invoice supplier
INV_PAYEE_PARTY_ID NUMBER 18 Party identifier of the supplier that sends the invoice.
INV_PARTY_SITE_ID NUMBER 18 Party site identifier associated with the supplier.
INV_SUPPLIER_SITE_ID NUMBER 18 Supplier site identifier of the supplier that sends the invoice.
RELATIONSHIP_ID NUMBER 18 Unique identifier of the relationship between payee and supplier that sends the invoice.
GLOBAL_ATTRIBUTE_CATEGORY VARCHAR2 150 Global Descriptive Flexfield: structure definition of the global descriptive flexfield.
GLOBAL_ATTRIBUTE1 VARCHAR2 150 Global Descriptive Flexfield: segment of the global descriptive flexfield.
GLOBAL_ATTRIBUTE2 VARCHAR2 150 Global Descriptive Flexfield: segment of the global descriptive flexfield.
GLOBAL_ATTRIBUTE3 VARCHAR2 150 Global Descriptive Flexfield: segment of the global descriptive flexfield.
GLOBAL_ATTRIBUTE4 VARCHAR2 150 Global Descriptive Flexfield: segment of the global descriptive flexfield.
GLOBAL_ATTRIBUTE5 VARCHAR2 150 Global Descriptive Flexfield: segment of the global descriptive flexfield.
GLOBAL_ATTRIBUTE6 VARCHAR2 150 Global Descriptive Flexfield: segment of the global descriptive flexfield.
GLOBAL_ATTRIBUTE7 VARCHAR2 150 Global Descriptive Flexfield: segment of the global descriptive flexfield.
GLOBAL_ATTRIBUTE8 VARCHAR2 150 Global Descriptive Flexfield: segment of the global descriptive flexfield.
GLOBAL_ATTRIBUTE9 VARCHAR2 150 Global Descriptive Flexfield: segment of the global descriptive flexfield.
GLOBAL_ATTRIBUTE10 VARCHAR2 150 Global Descriptive Flexfield: segment of the global descriptive flexfield.
GLOBAL_ATTRIBUTE11 VARCHAR2 150 Global Descriptive Flexfield: segment of the global descriptive flexfield.
GLOBAL_ATTRIBUTE12 VARCHAR2 150 Global Descriptive Flexfield: segment of the global descriptive flexfield.
GLOBAL_ATTRIBUTE13 VARCHAR2 150 Global Descriptive Flexfield: segment of the global descriptive flexfield.
GLOBAL_ATTRIBUTE14 VARCHAR2 150 Global Descriptive Flexfield: segment of the global descriptive flexfield.
GLOBAL_ATTRIBUTE15 VARCHAR2 150 Global Descriptive Flexfield: segment of the global descriptive flexfield.
GLOBAL_ATTRIBUTE16 VARCHAR2 150 Global Descriptive Flexfield: segment of the global descriptive flexfield.
GLOBAL_ATTRIBUTE17 VARCHAR2 150 Global Descriptive Flexfield: segment of the global descriptive flexfield.
GLOBAL_ATTRIBUTE18 VARCHAR2 150 Global Descriptive Flexfield: segment of the global descriptive flexfield.
GLOBAL_ATTRIBUTE19 VARCHAR2 150 Global Descriptive Flexfield: segment of the global descriptive flexfield.
GLOBAL_ATTRIBUTE20 VARCHAR2 150 Global Descriptive Flexfield: segment of the global descriptive flexfield.
GLOBAL_ATTRIBUTE_NUMBER1 NUMBER Global Descriptive Flexfield: segment of the global descriptive flexfield.
GLOBAL_ATTRIBUTE_NUMBER2 NUMBER Global Descriptive Flexfield: segment of the global descriptive flexfield.
GLOBAL_ATTRIBUTE_NUMBER3 NUMBER Global Descriptive Flexfield: segment of the global descriptive flexfield.
GLOBAL_ATTRIBUTE_NUMBER4 NUMBER Global Descriptive Flexfield: segment of the global descriptive flexfield.
GLOBAL_ATTRIBUTE_NUMBER5 NUMBER Global Descriptive Flexfield: segment of the global descriptive flexfield.
GLOBAL_ATTRIBUTE_DATE1 DATE Global Descriptive Flexfield: segment of the global descriptive flexfield.
GLOBAL_ATTRIBUTE_DATE2 DATE Global Descriptive Flexfield: segment of the global descriptive flexfield.
GLOBAL_ATTRIBUTE_DATE3 DATE Global Descriptive Flexfield: segment of the global descriptive flexfield.
GLOBAL_ATTRIBUTE_DATE4 DATE Global Descriptive Flexfield: segment of the global descriptive flexfield.
GLOBAL_ATTRIBUTE_DATE5 DATE Global Descriptive Flexfield: segment of the global descriptive flexfield.

Foreign Keys

Table Foreign Table Foreign Key Column
IBY_DOCUMENTS_PAYABLE_H iby_acct_pmt_profiles_b PAYMENT_PROFILE_ID
IBY_DOCUMENTS_PAYABLE_H iby_payments_all PAYMENT_ID
IBY_DOCUMENTS_PAYABLE_H iby_payments_h PAYMENT_HISTORY_ID
IBY_DOCUMENTS_PAYABLE_H iby_payment_methods_b PAYMENT_METHOD_CODE
IBY_DOCUMENTS_PAYABLE_H iby_trxn_types_b CALLING_APP_ID, PAY_PROC_TRXN_TYPE_CODE
IBY_DOCUMENTS_PAYABLE_H iby_pay_service_requests PAYMENT_SERVICE_REQUEST_ID
iby_document_lines_h iby_documents_payable_h DOCUMENT_PAYABLE_HISTORY_ID

Indexes

Index Uniqueness Tablespace Columns
IBY_DOCUMENTS_PAYABLE_H_PK Unique Default DOCUMENT_PAYABLE_HISTORY_ID