IBY_DOCS_PAYABLE_ALL
IBY_DOCS_PAYABLE_ALL stores Oracle Payments' representation of source products' documents payable. A document payable is a supplier invoice or similar document that needs to be paid. This table contains the identifier for the source product's document payable. In addition, this table contains whatever document information is necessary for payment processing.
Details
-
Schema: FUSION
-
Object owner: IBY
-
Object type: TABLE
-
Tablespace: APPS_TS_TX_DATA
Primary Key
| Name | Columns |
|---|---|
|
IBY_DOCS_PAYABLE_ALL_PK |
DOCUMENT_PAYABLE_ID |
Columns
| Name | Datatype | Length | Precision | Not-null | Comments |
|---|---|---|---|---|---|
| PAY_PROC_TRXN_TYPE_CODE | VARCHAR2 | 100 | Yes | Type of payment processing transaction or document | |
| ROUTING_ATTRIBUTE1 | VARCHAR2 | 270 | ROUTING_ATTRIBUTE1 | ||
| ROUTING_ATTRIBUTE2 | VARCHAR2 | 270 | ROUTING_ATTRIBUTE2 | ||
| ROUTING_ATTRIBUTE3 | VARCHAR2 | 270 | ROUTING_ATTRIBUTE3 | ||
| ROUTING_ATTRIBUTE4 | VARCHAR2 | 270 | ROUTING_ATTRIBUTE4 | ||
| ROUTING_ATTRIBUTE5 | VARCHAR2 | 270 | ROUTING_ATTRIBUTE5 | ||
| CALLING_APP_ID | NUMBER | 18 | Yes | Calling product Identifier | |
| CALLING_APP_DOC_REF_NUMBER | VARCHAR2 | 100 | Yes | Reference number entered by user of the source product. Need not be unique | |
| 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. | |
| PAYMENT_DATE | DATE | Yes | Payment date | ||
| 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_STATUS | VARCHAR2 | 30 | Yes | Document status. Values from the lookup IBY_DOCS_PAYABLE_STATUSES include PAYMENT CREATED. | |
| DOCUMENT_CURRENCY_CODE | VARCHAR2 | 10 | Yes | Document currency code | |
| DOCUMENT_AMOUNT | NUMBER | Yes | Total amount in document currency | ||
| PAYMENT_CURRENCY_CODE | VARCHAR2 | 10 | Yes | Payment currency code | |
| PAYMENT_AMOUNT | NUMBER | Yes | Amount to be paid in payment currency | ||
| 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 | |
| EXCLUSIVE_PAYMENT_FLAG | VARCHAR2 | 1 | Yes | Y or N flag indicating whether this document payable corresponds to one payment | |
| STRAIGHT_THROUGH_FLAG | VARCHAR2 | 1 | Yes | Y or N flag indicating whether the document payable has been processed without unexpected manual intervention | |
| EXT_PAYEE_ID | NUMBER | 18 | Yes | External payee Identifier | |
| PAYEE_PARTY_ID | NUMBER | 18 | Yes | TCA party Identifier | |
| LEGAL_ENTITY_ID | NUMBER | 18 | Yes | Legal entity Identifier | |
| ORG_ID | NUMBER | 18 | Yes | Indicates the identifier of the business unit associated to the row. | |
| ALLOW_REMOVING_DOCUMENT_FLAG | VARCHAR2 | 1 | Yes | Y or N flag indicating whether this document can be removed from a payment or payment process request | |
| 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. | |
| 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 | ||
| LAST_UPDATE_LOGIN | VARCHAR2 | 32 | Who column: indicates the session login associated to the user who last updated the row. | ||
| PARTY_SITE_ID | NUMBER | 18 | Payee party site Identifier | ||
| SUPPLIER_SITE_ID | NUMBER | 18 | Supplier site Identifier | ||
| BENEFICIARY_PARTY | NUMBER | 18 | Beneficiary party if payment is made through a third party | ||
| ORG_TYPE | VARCHAR2 | 30 | Yes | Organization type. Values from the lookup IBY_ORGANIZATION_TYPES include Operating Unit, Business Group, and Legal Entity. | |
| ANTICIPATED_VALUE_DATE | DATE | Anticipated value date | |||
| PO_NUMBER | VARCHAR2 | 255 | Purchase order numbers to which this document is matched. If multiple purchase orders, value is comma delimited | ||
| DOCUMENT_DESCRIPTION | VARCHAR2 | 255 | Document description | ||
| DOCUMENT_CURRENCY_TAX_AMOUNT | NUMBER | Tax amount in document currency | |||
| DOCUMENT_CURR_CHARGE_AMOUNT | NUMBER | Charge amount in document currency | |||
| AMOUNT_WITHHELD | NUMBER | Amount withheld in payment currency | |||
| PAYMENT_CURR_DISCOUNT_TAKEN | NUMBER | Discount taken in payment currency | |||
| DISCOUNT_DATE | DATE | Discount date | |||
| PAYMENT_DUE_DATE | DATE | Date on which the payment is made | |||
| PAYMENT_PROFILE_ID | NUMBER | 18 | Payment process profile Identifier | ||
| PAYMENT_ID | NUMBER | 18 | Payment Identifier. This field is populated once this document has been grouped into a payment. | ||
| 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. | ||
| INTERNAL_BANK_ACCOUNT_ID | NUMBER | 18 | Internal bank account Identifier | ||
| EXTERNAL_BANK_ACCOUNT_ID | NUMBER | 18 | External bank account 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 | 18 | This attribute is used to link a set of documents payable. All documents payable that have the same payment grouping number are grouped into a single payment. | ||
| PAYMENT_REASON_CODE | VARCHAR2 | 30 | Payment reason code | ||
| 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_CHANNEL_CODE | VARCHAR2 | 30 | Delivery channel code | ||
| PAYMENT_FORMAT_CODE | VARCHAR2 | 30 | Payment format code | ||
| DOCUMENT_SEQUENCE_ID | NUMBER | Sequential numbering document sequence Identifier | |||
| DOCUMENT_SEQUENCE_VALUE | NUMBER | Sequence number of document payable | |||
| DOCUMENT_CATEGORY_CODE | VARCHAR2 | 30 | Sequential numbering document category | ||
| BANK_ASSIGNED_REF_CODE | VARCHAR2 | 30 | Payment system-provided reference code for this document | ||
| REMIT_TO_LOCATION_ID | NUMBER | 18 | Remit-To address Identifier | ||
| COMPLETED_PMTS_GROUP_ID | NUMBER | 18 | Identifier of a group of payments, which include this document, that were marked complete. The value is from the sequence IBY_COMPLETED_PMTS_GROUP_S. | ||
| REJECTED_DOCS_GROUP_ID | NUMBER | 18 | Identifier of a group of documents payable, including this one, which were rejected together. The value is from the sequence IBY_REJECTED_DOCS_S. | ||
| 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. | ||
| ADDRESS_SOURCE | VARCHAR2 | 30 | Source of the address. Possible values from the lookup IBY_ADDRESS_SOURCE_TYPES include TCA and HR. | ||
| EMPLOYEE_ADDRESS_CODE | VARCHAR2 | 30 | Type of address. Possible values include HOME and OFFICE. | ||
| EMPLOYEE_PERSON_ID | NUMBER | 18 | Employee person Identifier | ||
| EMPLOYEE_PAYMENT_FLAG | VARCHAR2 | 1 | Y or N flag indicating whether the payment is of the employee payment type | ||
| EMPLOYEE_ADDRESS_ID | NUMBER | 18 | HR Identifier of the address | ||
| INVOICING_ORG_ID | NUMBER | 18 | Invoicing Business Unit. | ||
| INVOICING_ORG_TYPE | VARCHAR2 | 30 | Invoicing Org Type. | ||
| PAY_GROUP_CODE | VARCHAR2 | 25 | Groups a category of suppliers or invoices for a payment. For example, employees, merchandise, nonmerchandise, government, domestic, and international. | ||
| INVOICING_LEGAL_ENTITY_ID | NUMBER | 18 | Invoicing legal entity unique identifier. | ||
| DOC_CURRENCY_PAYMENT_AMOUNT | NUMBER | Amount to be paid in document currency | |||
| DOC_CURR_AMOUNT_WITHHELD | NUMBER | DOC_CURR_AMOUNT_WITHHELD | |||
| DOC_CURR_DISCOUNT_TAKEN | NUMBER | DOC_CURR_DISCOUNT_TAKEN | |||
| 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. | |||
| BALANCING_SEGMENT_VALUE | VARCHAR2 | 25 | BALANCING_SEGMENT_VALUE | ||
| SET_OF_BOOKS_ID | NUMBER | 18 | Ledger identifier for the invoice. | ||
| PAYMENT_MODE_CODE | VARCHAR2 | 30 | Invoice payment mode identifier. | ||
| PAYMENT_INSTRUMENT_ID | NUMBER | 18 | Funding instrument used for making payments. |
Foreign Keys
| Table | Foreign Table | Foreign Key Column |
|---|---|---|
| IBY_DOCS_PAYABLE_ALL | iby_trxn_types_b | CALLING_APP_ID, PAY_PROC_TRXN_TYPE_CODE |
| IBY_DOCS_PAYABLE_ALL | iby_pay_service_requests | PAYMENT_SERVICE_REQUEST_ID |
| IBY_DOCS_PAYABLE_ALL | iby_ext_bank_accounts | EXTERNAL_BANK_ACCOUNT_ID |
| IBY_DOCS_PAYABLE_ALL | iby_payments_all | FORMATTING_PAYMENT_ID |
| IBY_DOCS_PAYABLE_ALL | iby_payment_methods_b | PAYMENT_METHOD_CODE |
| IBY_DOCS_PAYABLE_ALL | iby_acct_pmt_profiles_b | PAYMENT_PROFILE_ID |
| IBY_DOCS_PAYABLE_ALL | iby_payments_all | PAYMENT_ID |
| IBY_DOCS_PAYABLE_ALL | iby_external_payees_all | EXT_PAYEE_ID |
| IBY_DOCS_PAYABLE_ALL | iby_formats_b | PAYMENT_FORMAT_CODE |
| IBY_DOCS_PAYABLE_ALL | ce_bank_accounts | INTERNAL_BANK_ACCOUNT_ID |
| jl_br_ap_bank_returns_all | iby_docs_payable_all | DOCUMENT_PAYABLE_ID |
| iby_document_lines | iby_docs_payable_all | DOCUMENT_PAYABLE_ID |
| iby_document_lines_h | iby_docs_payable_all | DOCUMENT_PAYABLE_ID |
Indexes
| Index | Uniqueness | Tablespace | Columns |
|---|---|---|---|
| IBY_DOCS_PAYABLE_ALL_N1 | Non Unique | Default | PAYMENT_DATE |
| IBY_DOCS_PAYABLE_ALL_N10 | Non Unique | Default | PAYMENT_FORMAT_CODE |
| IBY_DOCS_PAYABLE_ALL_N11 | Non Unique | Default | INTERNAL_BANK_ACCOUNT_ID |
| IBY_DOCS_PAYABLE_ALL_N12 | Non Unique | Default | DOCUMENT_STATUS |
| IBY_DOCS_PAYABLE_ALL_N13 | Non Unique | Default | 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 |
| IBY_DOCS_PAYABLE_ALL_N14 | Non Unique | Default | FORMATTING_PAYMENT_ID |
| IBY_DOCS_PAYABLE_ALL_N15 | Non Unique | Default | REJECTED_DOCS_GROUP_ID |
| IBY_DOCS_PAYABLE_ALL_N16 | Non Unique | Default | COMPLETED_PMTS_GROUP_ID |
| IBY_DOCS_PAYABLE_ALL_N2 | Non Unique | Default | PAYMENT_SERVICE_REQUEST_ID, DOCUMENT_STATUS |
| IBY_DOCS_PAYABLE_ALL_N3 | Non Unique | Default | EXTERNAL_BANK_ACCOUNT_ID |
| IBY_DOCS_PAYABLE_ALL_N4 | Non Unique | Default | PAYMENT_METHOD_CODE |
| IBY_DOCS_PAYABLE_ALL_N5 | Non Unique | Default | PAYMENT_PROFILE_ID |
| IBY_DOCS_PAYABLE_ALL_N6 | Non Unique | Default | PAYMENT_ID |
| IBY_DOCS_PAYABLE_ALL_N7 | Non Unique | Default | EXT_PAYEE_ID |
| IBY_DOCS_PAYABLE_ALL_N8 | Non Unique | Default | PAYMENT_REASON_CODE |
| IBY_DOCS_PAYABLE_ALL_N9 | Non Unique | Default | DELIVERY_CHANNEL_CODE |
| IBY_DOCS_PAYABLE_ALL_U1 | Unique | Default | DOCUMENT_PAYABLE_ID |