ADO.NET Provider for Oracle Fusion Cloud Financials

Build 24.0.9175

InterimDocumentsPayables

Holds temporary payables documents pending validation and payment, enabling partial or staged invoice creation.

Columns

Name Type Description
InvoiceExternalSupplierSiteIdentifier Long Unique identifier of the external supplier associated with the invoice.
ObjectVersionNumber Int Version number of the interim document in the payables system, used for version tracking and management.
CallingApplicationDocumentUniqueReferenceFive String Document unique reference five from the calling application, used to track the document in external systems.
InvoiceExternalPayeePartyIdentifier Long Unique identifier of the external payee party associated with the invoice, used to track the recipient.
PayeePartyIdentifier Long Unique identifier for the payee party, representing the entity receiving the payment.
OrganizationIdentifier Long Unique identifier for the organization associated with the invoice, used for organization-level tracking.
InvoicingLegalEntityIdentifier String Unique identifier for the legal entity issuing the invoice, used for legal and compliance tracking.
RelationshipIdentifier Long Unique identifier for the relationship between the payee and supplier, linking the entities involved in the invoice.
RemittanceMessageThree String Remittance message three, providing additional details about the payment or invoice status.
BankAssignedReferenceCode String Reference code assigned by the bank to the payment, used for tracking and reconciliation purposes.
PaymentFunction String Code that indicates the purpose of the payment, such as 'SUPPLIER_PAYMENT' or 'CUSTOMER_REFUNDS'.
PaymentAmount Decimal Amount to be paid as part of the transaction, specified in the payment request.
PaymentProfileIdentifier Long Unique identifier for the payment profile, helping to link payment information to specific profiles.
DeliveryChannelCode String Code indicating the channel used for payment delivery, such as electronic transfer or check.
InvoiceExternalPayeeIdentifier Long Unique identifier of the external payee, helping to track the entity receiving the payment.
ExclusivePaymentFlag Bool Flag indicating whether the payment is exclusive, meaning that it is reserved for a specific payee.
ExternalBankAccountIdentifier Long Unique identifier for the external bank account used for the payment.
AnticipatedValueDate Date The anticipated date when the payment is processed or cleared.
DocumentDescription String A description of the document, providing context or further details about the invoice or payment.
DiscountDate Date The computed date by which a payment must be made to avail a discount.
PaymentFormatCode String Code that specifies the format used for the payment, such as electronic funds transfer or check.
InterestRate Decimal Interest rate applicable to the payment or invoice, typically for overdue payments.
InvoiceExternalPayeePartySiteIdentifier Long Unique identifier for the payee party site, linking the payee's address to the payment transaction.
InvoicingOrganizationType String Indicates the type of the organization that is issuing the invoice, such as a vendor or government entity.
PaymentDueDate Date Date by which the payment is due to the payee or supplier.
DocumentDate Date Date when the document (invoice or payment request) was created.
PaymentCurrencyCode String Currency code of the payment, indicating the type of currency used for the transaction.
PaymentProcessTransactionTypeCode String Code indicating the type of payment process transaction, such as 'PREPAYMENT' or 'FINALPAYMENT'.
PaymentReasonCode String Code that indicates the reason for the payment, such as 'INVOICE' or 'REFUND'.
LegalEntityIdentifier Decimal Unique identifier for the legal entity involved in the transaction, ensuring proper legal categorization.
AmountWithheld Decimal The amount withheld in a transaction, typically for tax purposes or to fulfill regulatory requirements.
PaymentCurrencyDiscountTaken Decimal The discount taken in the payment currency, applied when paying before the discount deadline.
DoumentSequenceIdentifer Decimal Unique identifier for the document sequence, used for document classification and tracking.
CallingApplicationDocumentReferenceNumberOne String Reference number one of the calling application document, helping to track the document externally.
RemitToLocationIdentifier Long Unique identifier for the location where the payment is to be remitted, such as a specific address or branch.
PayeePartySiteIdentifier Long Unique identifier for the payee's site, typically representing a physical location or address for payment purposes.
AllowRemovingDocumentFlag Bool Flag indicating whether the document can be removed from the system, allowing for flexibility in document management.
DocumentType String Type of document, which could include invoice, payment request, or credit memo, among others.
RemittanceMessageOne String Remittance message one, providing details about the payment and related information.
SupplierSiteIdentifier Long Unique identifier for the supplier's site, indicating the specific location or branch where the supplier conducts business.
InternalBankAccountIdentifier Long Unique identifier for the internal bank account used to process the payment internally.
DocumentAmount Decimal The total amount specified in the document, which could be an invoice, credit memo, or payment.
OrganizationType String Type of the organization, used for classification purposes (for example, vendor, government).
DocumentCurrencyCode String Currency code associated with the document, indicating the currency in which the invoice or payment is denominated.
PaymentGroupingNumber Long Payment grouping number used to group multiple payments together, simplifying processing and reconciliation.
BankChargeAmount Decimal The amount charged by the bank for processing the payment, typically associated with transaction fees.
DocumentCurrencyPaymentAmount Decimal The payment amount in the document currency, indicating the total amount to be paid.
PaymentDate Date Date when the payment was made, indicating the transaction completion date.
DocumentCurrencyTaxAmount Decimal The tax amount associated with the payment or document, specified in the document's currency.
DocumentSequenceValue Decimal Unique identifier for the document sequence, used to maintain the order of documents.
PaymentReasonComments String Comments providing additional context or justification for the payment reason.
CallingApplicationIdentifier Long Unique identifier for the calling application that initiated the payment or invoice transaction.
PaymentMethodCode String Code indicating the method of payment, such as electronic funds transfer, check, or cash.
PaymentCurrencyBankCharges Long Bank charges applied in the payment currency, accounting for any fees associated with the transaction.
CallingApplicationDocumentReferenceNumber Long Reference number of the calling application document, linking the payment to the external system.
DocumentCurrencyChargeAmount Decimal The charge amount in the document's currency, typically indicating additional fees or charges.
SettlementPriority String Indicates the priority for executing a payment, helping to prioritize payments based on urgency.
ProcessType String Indicates the type of process, such as 'PAYMENT' or 'REFUND', guiding how the payment is processed.
InvoicingOrganizationIdentifier Long Unique identifier for the invoicing organization, helping to link the invoice to the issuing entity.
BankChargeBearer String Indicates who bears the bank charges, such as the payer or payee.
RemittanceMessageTwo String Remittance message two, providing further details about the payment and transaction.
DocumentCategoryCode String Code that categorizes the document, such as 'Invoice' or 'Credit Memo'.
UniqueRemittanceIdentifierCheckDigit String Check digit used to validate the unique remittance identifier, ensuring the identifier's correctness.
UniqueRemittanceIdentifier String Unique identifier for the remittance, providing a distinct reference for tracking the payment.
CallingApplicationDocumentUniqueReferenceFour String Document unique reference four of the calling application.
CallingApplicationDocumentUniqueReferenceThree String Document unique reference three of the calling application.
CallingApplicationDocumentUniqueReferenceTwo String Document unique reference two of the calling application.
GlobalAttributeOne String Attribute one of the global descriptive flexfield, used for custom data capture.
GlobalAttributeTen String Attribute ten of the global descriptive flexfield, allowing for additional custom fields.
GlobalAttributeEleven String Attribute eleven of the global descriptive flexfield.
GlobalAttributeTwelve String Attribute twelve of the global descriptive flexfield.
GlobalAttributeThirteen String Attribute thirteen of the global descriptive flexfield.
GlobalAttributeFourteen String Attribute fourteen of the global descriptive flexfield.
GlobalAttributeFifteen String Attribute fifteen of the global descriptive flexfield.
GlobalAttributeSixteen String Attribute sixteen of the global descriptive flexfield.
GlobalAttributeSeventeen String Attribute seventeen of the global descriptive flexfield.
GlobalAttributeEighteen String Attribute eighteen of the global descriptive flexfield.
GlobalAttributeTwo String Attribute two of the global descriptive flexfield.
GlobalAttributeTwenty String Attribute twenty of the global descriptive flexfield.
GlobalAttributeThree String Attribute three of the global descriptive flexfield.
GlobalAttributeFour String Attribute four of the global descriptive flexfield.
GlobalAttributeFive String Attribute five of the global descriptive flexfield.
GlobalAttributeSix String Attribute six of the global descriptive flexfield.
GlobalAttributeSeven String Attribute seven of the global descriptive flexfield.
GlobalAttributeEight String Attribute eight of the global descriptive flexfield.
GlobalAttributeNine String Attribute nine of the global descriptive flexfield.
GlobalAttributeCategory String Category that the global attribute belongs to, helping organize attributes based on their use.
GlobalAttributeDateOne Date Date one of the global descriptive flexfield, capturing date-related custom data.
GlobalAttributeDateTwo Date Date two of the global descriptive flexfield.
GlobalAttributeDateThree Date Date three of the global descriptive flexfield.
GlobalAttributeDateFour Date Date four of the global descriptive flexfield.
GlobalAttributeDateFive Date Date five of the global descriptive flexfield.
GlobalAttributeNumberOne Decimal Numeric attribute one of the global descriptive flexfield, used for capturing numeric data.
GlobalAttributeNumberTwo Decimal Numeric attribute two of the global descriptive flexfield.
GlobalAttributeNumberThree Decimal Numeric attribute three of the global descriptive flexfield.
GlobalAttributeNumberFour Decimal Numeric attribute four of the global descriptive flexfield.
GlobalAttributeNumberFive Decimal Numeric attribute five of the global descriptive flexfield.
AttributeOne String Attribute one of the user descriptive flexfield, used for capturing user-defined data.
AttributeTen String Attribute ten of the user descriptive flexfield.
AttributeEleven String Attribute eleven of the user descriptive flexfield.
AttributeTwelve String Attribute twelve of the user descriptive flexfield.
AttributeThirteen String Attribute thirteen of the user descriptive flexfield.
AttributeFourteen String Attribute fourteen of the user descriptive flexfield.
AttributeFifteen String Attribute fifteen of the user descriptive flexfield.
AttributeTwo String Attribute two of the user descriptive flexfield.
AttributeThree String Attribute three of the user descriptive flexfield.
AttributeFour String Attribute four of the user descriptive flexfield.
AttributeFive String Attribute five of the user descriptive flexfield.
AttributeSix String Attribute six of the user descriptive flexfield.
AttributeSeven String Attribute seven of the user descriptive flexfield.
AttributeEight String Attribute eight of the user descriptive flexfield.
AttributeNine String Attribute nine of the user descriptive flexfield.
AttributeCategory String Category that the attribute belongs to, providing classification for user attributes.
ValidationErrorMessage String Message indicating any validation errors encountered during the processing of the interim document.
ValidationSuccessIndicator String Indicator showing whether the document passed validation (for example, 'Success' or 'Failure').
PurchaseOrderNumber String Unique identifier for the purchase order associated with the document, linking the payment to the specific purchase.
CallingApplicationDocumentUniqueReferenceOne String First unique reference for the calling application document, aiding in document identification.
DocumentPayableId [KEY] Long Unique identifier of the document payable, used for tracking the payable transaction.
GlobalAttributeNinteen String Attribute nineteen of the global descriptive flexfield.
PayGroupCode String Code indicating the category that suppliers or invoices belong to, such as Employees, Merchandise, or Domestic.
Finder String Search term or identifier used to locate and retrieve specific interim document payable records.

Copyright (c) 2025 CData Software, Inc. - All rights reserved.
Build 24.0.9175