Payables Invoices

The payables invoices view object contains information about supplier invoices such as invoice number, invoice date, invoice amount, supplier, currency and so on. There is one row for each invoice.

Data Store Key : FscmTopModelAM.FinExtractAM.ApBiccExtractAM.InvoiceHeaderExtractPVO

Primary Keys : ApInvoicesInvoiceId

Initial Extract Date : ApInvoicesCreationDate

Incremental Extract Date : ApInvoicesLastUpdateDate

Attributes

This table provides the list of exposed attributes and their descriptions.

Name	Description
ApInvoicesAcctsPayCodeCombinationId	The identifier of the account code combination for the accounts payable liability account.
ApInvoicesAmountApplicableToDiscount	The Invoice amount used as the basis for calculation of discount.
ApInvoicesAmountPaid	The amount paid for the invoice.
ApInvoicesAmtDueCcardCompany	The amount that is due to the credit card company.
ApInvoicesAmtDueEmployee	The amount that is due to an employee.
ApInvoicesApplicationId	The unique identifier of the application from which the invoice originated.
ApInvoicesApprovalDescription	The description of the invoice approval. Used for reference purposes only.
ApInvoicesApprovalIteration	The number of times the invoice has passed through the Invoice Approval Workflow process.
ApInvoicesApprovalReadyFlag	Indicates whether the invoice is ready for approval using the Invoice Approval workflow. Possible values are Y or N.
ApInvoicesApprovalStatus	The status indicating the state of the invoice in the approval process.
ApInvoicesApprovedAmount	The invoice amount approved through the Invoice Approval workflow process.
ApInvoicesAttribute1	A segment for the Payables Invoices descriptive flexfield.
ApInvoicesAttribute10	A segment for the Payables Invoices descriptive flexfield.
ApInvoicesAttribute11	A segment for the Payables Invoices descriptive flexfield.
ApInvoicesAttribute12	A segment for the Payables Invoices descriptive flexfield.
ApInvoicesAttribute13	A segment for the Payables Invoices descriptive flexfield.
ApInvoicesAttribute14	A segment for the Payables Invoices descriptive flexfield.
ApInvoicesAttribute15	A segment for the Payables Invoices descriptive flexfield.
ApInvoicesAttribute2	A segment for the Payables Invoices descriptive flexfield.
ApInvoicesAttribute3	A segment for the Payables Invoices descriptive flexfield.
ApInvoicesAttribute4	A segment for the Payables Invoices descriptive flexfield.
ApInvoicesAttribute5	A segment for the Payables Invoices descriptive flexfield.
ApInvoicesAttribute6	A segment for the Payables Invoices descriptive flexfield.
ApInvoicesAttribute7	A segment for the Payables Invoices descriptive flexfield.
ApInvoicesAttribute8	A segment for the Payables Invoices descriptive flexfield.
ApInvoicesAttribute9	A segment for the Payables Invoices descriptive flexfield.
ApInvoicesAttributeCategory	The context name for the Payables Invoices descriptive flexfield.
ApInvoicesAttributeDate1	A date segment for the Payables Invoices descriptive flexfield.
ApInvoicesAttributeDate2	A date segment for the Payables Invoices descriptive flexfield.
ApInvoicesAttributeDate3	A date segment for the Payables Invoices descriptive flexfield.
ApInvoicesAttributeDate4	A date segment for the Payables Invoices descriptive flexfield.
ApInvoicesAttributeDate5	A date segment for the Payables Invoices descriptive flexfield.
ApInvoicesAttributeNumber1	A number segment for the Payables Invoices descriptive flexfield.
ApInvoicesAttributeNumber2	A number segment for the Payables Invoices descriptive flexfield.
ApInvoicesAttributeNumber3	A number segment for the Payables Invoices descriptive flexfield.
ApInvoicesAttributeNumber4	A number segment for the Payables Invoices descriptive flexfield.
ApInvoicesAttributeNumber5	A number segment for the Payables Invoices descriptive flexfield.
ApInvoicesAwardId	The identifier for the award associated with the invoice. Used by Oracle Fusion Grants Management.
ApInvoicesAwtFlag	Indicates whether withholding tax has been calculated automatically or manually. A value of A indicates automatic calculation and a value of M indicates manual calculation.
ApInvoicesAwtGroupId	The identifier of the withholding tax group.
ApInvoicesBankChargeBearer	The party that agrees to assume the liability for bank charges assessed on a transaction. A list of accepted values is defined in the lookup type IBY_BANK_CHARGE_BEARER.
ApInvoicesBaseAmount	The invoice amount in the ledger currency.
ApInvoicesBatchId	The unique identifier of the invoice group.
ApInvoicesBudgetDate	The budgetary calendar period date applicable for funds checking.
ApInvoicesCancelledAmount	The original amount of the canceled invoice.
ApInvoicesCancelledBy	The user who canceled the invoice.
ApInvoicesCancelledDate	The date when the invoice was canceled.
ApInvoicesCheckVatAmountPaid	Indicates whether a partially paid purchase transaction is reportable for tax. This is used for tax reporting purposes in eastern and central Europe.
ApInvoicesControlAmount	The user-enterable value to ensure that the calculated tax will be the same as on the physical document.
ApInvoicesCorrectionPeriod	The correction period for the invoice being corrected.
ApInvoicesCorrectionYear	The correction year for the invoice being corrected.
ApInvoicesCreatedBy	The user who created the invoice.
ApInvoicesCreationDate	The date and time when the invoice was created.
ApInvoicesCreditedInvoiceId	The identifier of the invoice that is fully reversed by a credit or debit memo.
ApInvoicesCustRegistrationCode	The first party tax registration code.
ApInvoicesCustRegistrationNumber	The first party tax registration number.
ApInvoicesDataSetId	The identifier of the budgetary control transaction or group of transactions.
ApInvoicesDeliveryChannelCode	The delivery channel code entered by the user that helps to uniquely identify a delivery channel.
ApInvoicesDescription	The statement that describes the invoice.
ApInvoicesDiscIsInvLessTaxFlag	Indicates whether the tax amount is excluded from the discountable amount when the invoice amount applicable to discount is calculated. Possible values are Y or N.
ApInvoicesDiscountAmountTaken	The discount amount on the invoice.
ApInvoicesDistributionSetId	The identifier of the distribution set used to generate the distributions for the invoice lines.
ApInvoicesDocCategoryCode	The sequential numbering document category.
ApInvoicesDocSequenceId	The unique identifier of the sequential numbering document sequence.
ApInvoicesDocSequenceValue	The manual sequence number when document sequential numbering is enabled.
ApInvoicesDocumentSubType	The classification that categorizes the document associated with a transaction for tax.
ApInvoicesEarliestSettlementDate	The date after which a prepayment invoice may be applied to invoices.
ApInvoicesEmployeeAddressCode	The address code for the employee. Possible values are HOME or OFFICE.
ApInvoicesExchangeDate	The date effective for the conversion rate.
ApInvoicesExchangeRate	The conversion rate used to convert the invoice amount to ledger currency.
ApInvoicesExchangeRateType	The rate type associated with the conversion rate.
ApInvoicesExcludeFreightFromDiscount	Indicates whether freight amount is excluded from the discountable amount when calculating the invoice amount subject to discount. Possible values are Y or N.
ApInvoicesExclusivePaymentFlag	Indicates whether the invoice should be paid with its own payment document without including other invoices for the supplier.
ApInvoicesExpenditureItemDate	The expenditure item date for project-related invoices.
ApInvoicesExpenditureOrganizationId	The identifier of the project organization used to build default accounting for the invoice.
ApInvoicesExpenditureType	The identifier for the project expenditure organization associated with the invoice.
ApInvoicesExternalBankAccountId	The identifier of the external bank account.
ApInvoicesFirstPartyRegistrationId	The identifier of the first party tax registration.
ApInvoicesFiscalDocAccessKey	The unique identifier of the fiscal document, which is generated by concatenating multiple attributes of the fiscal document.
ApInvoicesForceRevalidationFlag	Indicates whether revalidation is allowed for the invoice. Valid values are Y or N.
ApInvoicesFreightAmount	The total freight amount for the invoice.
ApInvoicesFundsStatus	Indicates whether funds checking and reservation is applicable for the invoice.
ApInvoicesGlDate	The accounting date captured on the invoice that is finally used to default to invoice lines and distributions.
ApInvoicesGlobalAttribute1	A segment for the Payables Invoices global descriptive flexfield.
ApInvoicesGlobalAttribute10	A segment for the Payables Invoices global descriptive flexfield.
ApInvoicesGlobalAttribute11	A segment for the Payables Invoices global descriptive flexfield.
ApInvoicesGlobalAttribute12	A segment for the Payables Invoices global descriptive flexfield.
ApInvoicesGlobalAttribute13	A segment for the Payables Invoices global descriptive flexfield.
ApInvoicesGlobalAttribute14	A segment for the Payables Invoices global descriptive flexfield.
ApInvoicesGlobalAttribute15	A segment for the Payables Invoices global descriptive flexfield.
ApInvoicesGlobalAttribute16	A segment for the Payables Invoices global descriptive flexfield.
ApInvoicesGlobalAttribute17	A segment for the Payables Invoices global descriptive flexfield.
ApInvoicesGlobalAttribute18	A segment for the Payables Invoices global descriptive flexfield.
ApInvoicesGlobalAttribute19	A segment for the Payables Invoices global descriptive flexfield.
ApInvoicesGlobalAttribute2	A segment for the Payables Invoices global descriptive flexfield.
ApInvoicesGlobalAttribute20	A segment for the Payables Invoices global descriptive flexfield.
ApInvoicesGlobalAttribute3	A segment for the Payables Invoices global descriptive flexfield.
ApInvoicesGlobalAttribute4	A segment for the Payables Invoices global descriptive flexfield.
ApInvoicesGlobalAttribute5	A segment for the Payables Invoices global descriptive flexfield.
ApInvoicesGlobalAttribute6	A segment for the Payables Invoices global descriptive flexfield.
ApInvoicesGlobalAttribute7	A segment for the Payables Invoices global descriptive flexfield.
ApInvoicesGlobalAttribute8	A segment for the Payables Invoices global descriptive flexfield.
ApInvoicesGlobalAttribute9	A segment for the Payables Invoices global descriptive flexfield.
ApInvoicesGlobalAttributeCategory	The context name for the Payables Invoices global descriptive flexfield.
ApInvoicesGlobalAttributeDate1	A date segment for the Payables Invoices global descriptive flexfield.
ApInvoicesGlobalAttributeDate2	A date segment for the Payables Invoices global descriptive flexfield.
ApInvoicesGlobalAttributeDate3	A date segment for the Payables Invoices global descriptive flexfield.
ApInvoicesGlobalAttributeDate4	A date segment for the Payables Invoices global descriptive flexfield.
ApInvoicesGlobalAttributeDate5	A date segment for the Payables Invoices global descriptive flexfield.
ApInvoicesGlobalAttributeNumber1	A number segment for the Payables Invoices global descriptive flexfield.
ApInvoicesGlobalAttributeNumber2	A number segment for the Payables Invoices global descriptive flexfield.
ApInvoicesGlobalAttributeNumber3	A number segment for the Payables Invoices global descriptive flexfield.
ApInvoicesGlobalAttributeNumber4	A number segment for the Payables Invoices global descriptive flexfield.
ApInvoicesGlobalAttributeNumber5	A number segment for the Payables Invoices global descriptive flexfield.
ApInvoicesGoodsReceivedDate	The date when the goods were received.
ApInvoicesHistoricalFlag	Indicates whether the transaction is upgraded from a prior release or is newly created.
ApInvoicesImageDocumentNum	This attribute is for internal use only.
ApInvoicesImportDocumentDate	The import declaration date associated with the import document number.
ApInvoicesImportDocumentNumber	The import declaration number or import manifest number provided by Customs when goods are imported.
ApInvoicesIntercompanyFlag	Indicates if an invoice is an intercompany invoice.
ApInvoicesInternalContactEmail	The email address of the internal contact.
ApInvoicesInvoiceAmount	The invoice amount in transaction currency.
ApInvoicesInvoiceCurrencyCode	The currency code used on the invoice.
ApInvoicesInvoiceDate	The date on the supplier invoice.
ApInvoicesInvoiceId	The unique invoice identifier that is generated while creating an invoice. This is the primary key of the Payables Invoices view object.
ApInvoicesInvoiceNum	The unique number for supplier invoice.
ApInvoicesInvoiceReceivedDate	The date when the invoice was received. This date can be used to calculate the invoice payment due date.
ApInvoicesInvoiceTypeLookupCode	The type of the invoice. A list of accepted values is defined in the lookup type INVOICE TYPE.
ApInvoicesJobDefinitionName	The name of the scheduled process that created or last updated the invoice.
ApInvoicesJobDefinitionPackage	The package name of the scheduled process that created or last updated the invoice.
ApInvoicesLastUpdateDate	The date when the invoice was last updated.
ApInvoicesLastUpdateLogin	The session login associated with the user who last updated the invoice header.
ApInvoicesLastUpdatedBy	The user who last updated the invoice.
ApInvoicesLegalEntityId	The unique identifier of the legal entity associated with the invoice.
ApInvoicesLockTime	The time when the invoice is locked for editing.
ApInvoicesLockedBy	The user who has locked the invoice for editing.
ApInvoicesMergeRequestId	The identifier of the supplier merge request.
ApInvoicesNetOfRetainageFlag	Indicates whether the invoice amount is net of retainage.
ApInvoicesObjectVersionNumber	The number of times that the invoice has been updated.
ApInvoicesOrgId	The identifier of the business unit associated with the invoice.
ApInvoicesPaDefaultDistCcid	The identifier for the default accounting code combination for project-related invoices. This is used to default the code combination to the invoice distributions.
ApInvoicesPaQuantity	The quantity billed to a project.
ApInvoicesPaidOnBehalfEmployeeId	The employee identifier for expense reports which are split in both pay scenario. The new expense report is updated with the employee identifier of the original expense report.
ApInvoicesPartyId	The unique identifier of the invoice supplier or party.
ApInvoicesPartySiteId	The unique identifier of supplier or party site.
ApInvoicesPayCurrInvoiceAmount	The invoice amount in the payment currency.
ApInvoicesPayGroupLookupCode	The group for a category of suppliers or invoices for a single pay run. Examples include employees, merchandise, nonmerchandise, government, domestic, and international. A list of accepted values is defined in the lookup PAY GROUP.
ApInvoicesPayProcTrxnTypeCode	The type of payment processing transaction or document for the invoice.
ApInvoicesPaymentAmountTotal	The amount of invoice that was paid.
ApInvoicesPaymentCrossRate	The conversion rate between the invoice currency and the payment currency.
ApInvoicesPaymentCrossRateDate	The date effective for the conversion rate.
ApInvoicesPaymentCrossRateType	The cross-currency payment rate type.
ApInvoicesPaymentCurrencyCode	The currency used to make a payment
ApInvoicesPaymentFunction	The business function that the payment serves. Examples include employee expenses and payables disbursements.
ApInvoicesPaymentMethodCode	The user-entered payment method code that helps to uniquely identify a payment method.
ApInvoicesPaymentMethodLookupCode	The user-entered payment method code that helps to uniquely identify a payment method.
ApInvoicesPaymentReasonCode	The payment method used to make the payment.
ApInvoicesPaymentReasonComments	The comments that indicate the reason for creating the payment.
ApInvoicesPaymentStatusFlag	Indicates whether the invoice is paid. The default value is set to Unpaid.
ApInvoicesPoHeaderId	The unique identifier of the purchase order that the invoice is matched to.
ApInvoicesPoMatchedFlag	Identifies whether the invoice is matched to a purchase order. This is used in the payables invoice validation batch program.
ApInvoicesPortOfEntryCode	Identifies the location or port through which the invoiced goods entered the country.
ApInvoicesPostingStatus	Indicates the posting status of the invoice. A list of accepted values is defined in the lookup POSTING STATUS.
ApInvoicesPreWithholdingAmount	Reserved for future use.
ApInvoicesProductTable	The name of the product source table used for generating the invoice.
ApInvoicesProjectId	The identifier of the number assigned to a project.
ApInvoicesQuickCredit	Indicates whether the credit memo or debit memo was created as a quick credit.
ApInvoicesQuickPoHeaderId	The identifier of the purchase order used for Quick Match. This is used to default values from the purchase order to the invoice header.
ApInvoicesRecurringPaymentId	The identifier of the recurring invoice.
ApInvoicesReference1	The reference information from Oracle Projects expense reports.
ApInvoicesReference2	The reference information from Oracle Projects expense reports.
ApInvoicesReferenceKey1	The primary key information that uniquely identifies a record in another product's view.
ApInvoicesReferenceKey2	The primary key information that uniquely identifies a record in another product's view.
ApInvoicesReferenceKey3	The primary key information that uniquely identifies a record in another product's view.
ApInvoicesReferenceKey4	The primary key information that uniquely identifies a record in another product's view.
ApInvoicesReferenceKey5	The primary key information that uniquely identifies a record in another product's view.
ApInvoicesRelationshipId	The identifier of the third party relationship to whom the payment is made.
ApInvoicesReleaseAmountNetOfTax	The invoice amount net of tax for retainage release invoices.
ApInvoicesRemitToAddressId	The identifier of the remit-to address where the payment is sent.
ApInvoicesRemitToAddressName	The third-party payment related remit-to address where the payment is sent.
ApInvoicesRemitToSupplierId	The identifier of the third-party payment related remit-to supplier where the payment is sent.
ApInvoicesRemitToSupplierName	The third-party payment related remit-to supplier where the payment is sent.
ApInvoicesRemittanceMessage1	The remittance message for use in payment processing.
ApInvoicesRemittanceMessage2	The remittance message for use in payment processing.
ApInvoicesRemittanceMessage3	The remittance message for use in payment processing.
ApInvoicesRequestId	The identifier of the schedule process request that created or last updated the invoice.
ApInvoicesRequesterId	The unique identifier of the person who requested the goods or services. The requester is used by the Invoice Approval Workflow process to generate the list of approvers.
ApInvoicesRoutingAttribute1	Captures additional attributes information that may have been used for routing payables invoice images.
ApInvoicesRoutingAttribute2	Captures additional attributes information that may have been used for routing payables invoice images.
ApInvoicesRoutingAttribute3	Captures additional attributes information that may have been used for routing payables invoice images.
ApInvoicesRoutingAttribute4	Captures additional attributes information that may have been used for routing payables invoice images.
ApInvoicesRoutingAttribute5	Captures additional attributes information that may have been used for routing payables invoice images.
ApInvoicesRoutingStatusLookupCode	Indicates the routing status of the invoice. The invoice can be in the process of routing or complete.
ApInvoicesSelfAssessedTaxAmount	The total self-assessed tax amount on the invoice.
ApInvoicesSetOfBooksId	The unique identifier of the ledger associated with the invoice.
ApInvoicesSettlementPriority	The priority with which the financial institution or payment system should settle payment for this document. A list of accepted values is defined in the lookup IBY_SETTLEMENT_PRIORITY.
ApInvoicesSource	The source that indicates the feeder system from which an invoice is created. A list of accepted values is defined in the lookup SOURCE.
ApInvoicesSupplierTaxExchangeRate	Conversion rate entered for taxes on a supplier invoice.
ApInvoicesSupplierTaxInvoiceDate	The date when the supplier charged tax, as shown on the purchase order.
ApInvoicesSupplierTaxInvoiceNumber	The supplier tax invoice number on the invoice.
ApInvoicesTaskId	The identifier for the project task for project-related invoice.
ApInvoicesTaxInvoiceInternalSeq	The internal sequence number for a supplier issued tax invoice.
ApInvoicesTaxInvoiceRecordingDate	The date when the tax invoice was recorded.
ApInvoicesTaxRelatedInvoiceId	The identifier of the invoice tax related invoice.
ApInvoicesTaxationCountry	The country in which the transaction is deemed to have taken place for taxation purposes. Oracle Fusion Tax will set the context of other tax drivers such as Product Fiscal Classification based on the value of this field.
ApInvoicesTempCancelledAmount	This attribute temporarily stores the original invoice amount of an invoice until the cancelation completes successfully.
ApInvoicesTermsDate	The date used with payment terms to calculate installment along with due date and discount dates.
ApInvoicesTermsId	The unique identifier of the payment terms used to calculate installments and to calculate due dates, discount dates, and discount amounts for the invoice.
ApInvoicesThirdPartyRegistrationId	The identifier for the third party registration.
ApInvoicesTotalTaxAmount	The total tax charged on the invoice.
ApInvoicesTransactionDeadline	This attribute information pertaining to the declaration or register of certain intracommunity transactions, including the number of days to perform the transactions. Used for Spanish transactions only.
ApInvoicesTrxBusinessCategory	The transaction category assigned to the invoice. Used to identify and classify business transactions for the purpose of tax calculation.
ApInvoicesUniqueRemittanceIdentifier	The unique identifier for a remittance. Contains reference information for a payment.
ApInvoicesUriCheckDigit	The check digit used to validate the unique remittance identifier.
ApInvoicesUserDefinedFiscClass	A classification for any tax requirement that you cannot define using the existing fiscal classification types.
ApInvoicesUssglTransactionCode	The USSGL transaction code for creating US Standard General Ledger journal entries. This is used for Oracle Public Sector Payables.
ApInvoicesUssglTrxCodeContext	The context name for the USSGL Transaction Code Descriptive flexfield.
ApInvoicesValidatedTaxAmount	The total tax amount excluded from the discountable amount.
ApInvoicesValidationRequestId	The identifier of the validation request processing the invoice.
ApInvoicesValidationWorkerId	The temporary identifier to set the worker assignment number for the Payables Invoice Validation process.
ApInvoicesVendorContactId	The identifier of the supplier contact.
ApInvoicesVendorId	The identifier of the supplier on the invoice.
ApInvoicesVendorSiteId	The identifier of the supplier site on the invoice.
ApInvoicesVoucherNum	The manual voucher number when document sequential numbering is not used.
ApInvoicesWfapprovalStatus	The status indicating the state of the invoice in the approval process. A list of accepted values is defined in the lookup AP_WFAPPROVAL_STATUS.