Invoice Distributions

The invoice distributions view object contains information about distributions for a supplier invoice such as distribution number, distribution amount, invoice line number and so on. An invoice can have multiple distributions and there is one row for each distribution in this view object. The combination of ApInvoiceDistributionsInvoiceDistributionId, ApInvoiceDistributionsLastUpdateDate and ApInvoiceDistributionsLastUpdatedBy forms the primary key for this view object.

Data Store Key : FscmTopModelAM.FinExtractAM.ApBiccExtractAM.InvoiceDistributionExtractPVO

Primary Keys : ApInvoiceDistributionsInvoiceDistributionId

Initial Extract Date : ApInvoiceDistributionsCreationDate

Incremental Extract Date : ApInvoiceDistributionsLastUpdateDate

Attributes

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

Name Description
ApInvoiceDistributionsAccountingDate The date when the invoice distribution is to be accounted.
ApInvoiceDistributionsAccountingEventId The identifier of the accounting event that accounted for the distribution.
ApInvoiceDistributionsAdjustmentReason The reason for the invoice distribution adjustment.
ApInvoiceDistributionsAmount The amount on the invoice distribution.
ApInvoiceDistributionsAmountAtPrepayPayXrate The invoice distribution amount in the ledger currency at the prepayment payment conversion rate. Populated for prepay type distributions on foreign currency invoices.
ApInvoiceDistributionsAmountAtPrepayXrate The invoice distribution amount in the ledger currency at the prepayment invoice conversion rate. This attribute is populated for prepay type distributions on foreign currency invoices.
ApInvoiceDistributionsAmountVariance The amount variance in the entered currency for invoice distributions that are matched to a service shipment or receipt.
ApInvoiceDistributionsAssetBookTypeCode The asset book associated with the row. The value is populated by default from the invoice line to the distributions candidate for transfer to Oracle Fusion Assets.
ApInvoiceDistributionsAssetCategoryId The asset category under which this asset line is grouped. The value is populated by default from the invoice line to the invoice distributions for transferring to Oracle Fusion Assets.
ApInvoiceDistributionsAssetsAdditionFlag Indicates whether the invoice distribution has been transferred to Oracle Fusion Assets. A value of U indicates that the distribution is not yet processed for transfer to Oracle Fusion Assets. A value of Y indicates that the distribution has been transferred and a value of N indicates that the distribution has not been transferred to Oracle Fusion Assets.
ApInvoiceDistributionsAssetsTrackingFlag Indicates if the item should be transferred to Oracle Fusion Assets. The value can either be provided while creating an invoice distribution or populated by default from the parent invoice line or populated by default to true if an asset account is provided in the distribution combination. If the value is true, then it indicates that the item should be transferred to Oracle Fusion Assets.
ApInvoiceDistributionsAttribute1 A segment for the Payables Invoice Distributions descriptive flexfield.
ApInvoiceDistributionsAttribute10 A segment for the Payables Invoice Distributions descriptive flexfield.
ApInvoiceDistributionsAttribute11 A segment for the Payables Invoice Distributions descriptive flexfield.
ApInvoiceDistributionsAttribute12 A segment for the Payables Invoice Distributions descriptive flexfield.
ApInvoiceDistributionsAttribute13 A segment for the Payables Invoice Distributions descriptive flexfield.
ApInvoiceDistributionsAttribute14 A segment for the Payables Invoice Distributions descriptive flexfield.
ApInvoiceDistributionsAttribute15 A segment for the Payables Invoice Distributions descriptive flexfield.
ApInvoiceDistributionsAttribute2 A segment for the Payables Invoice Distributions descriptive flexfield.
ApInvoiceDistributionsAttribute3 A segment for the Payables Invoice Distributions descriptive flexfield.
ApInvoiceDistributionsAttribute4 A segment for the Payables Invoice Distributions descriptive flexfield.
ApInvoiceDistributionsAttribute5 A segment for the Payables Invoice Distributions descriptive flexfield.
ApInvoiceDistributionsAttribute6 A segment for the Payables Invoice Distributions descriptive flexfield.
ApInvoiceDistributionsAttribute7 A segment for the Payables Invoice Distributions descriptive flexfield.
ApInvoiceDistributionsAttribute8 A segment for the Payables Invoice Distributions descriptive flexfield.
ApInvoiceDistributionsAttribute9 A segment for the Payables Invoice Distributions descriptive flexfield.
ApInvoiceDistributionsAttributeCategory The context name for the Payables Invoice Distributions descriptive flexfield.
ApInvoiceDistributionsAttributeDate1 A date segment for the Payables Invoice Distributions descriptive flexfield.
ApInvoiceDistributionsAttributeDate2 A date segment for the Payables Invoice Distributions descriptive flexfield.
ApInvoiceDistributionsAttributeDate3 A date segment for the Payables Invoice Distributions descriptive flexfield.
ApInvoiceDistributionsAttributeDate4 A date segment for the Payables Invoice Distributions descriptive flexfield.
ApInvoiceDistributionsAttributeDate5 A date segment for the Payables Invoice Distributions descriptive flexfield.
ApInvoiceDistributionsAttributeNumber1 A number segment for the Payables Invoice Distributions descriptive flexfield.
ApInvoiceDistributionsAttributeNumber2 A number segment for the Payables Invoice Distributions descriptive flexfield.
ApInvoiceDistributionsAttributeNumber3 A number segment for the Payables Invoice Distributions descriptive flexfield.
ApInvoiceDistributionsAttributeNumber4 A number segment for the Payables Invoice Distributions descriptive flexfield.
ApInvoiceDistributionsAttributeNumber5 A number segment for the Payables Invoice Distributions descriptive flexfield.
ApInvoiceDistributionsAwardId The identifier for the award associated with the invoice distribution. Used by Oracle Fusion Grants Management.
ApInvoiceDistributionsAwtFlag Indicates whether the invoice distribution is subject to withholding tax. Possible values are Y, N or null.
ApInvoiceDistributionsAwtGrossAmount The distribution amount subject to withholding tax.
ApInvoiceDistributionsAwtGroupId The identifier of the withholding tax group.
ApInvoiceDistributionsAwtInvoiceId The identifier of the withholding tax invoice created from this distribution.
ApInvoiceDistributionsAwtInvoicePaymentId The identifier of the payment for the parent invoice. This attribute is populated only for those withholding tax distributions that are automatically created at payment time.
ApInvoiceDistributionsAwtOriginGroupId The identifier of the parent withholding tax group. This attribute is populated for automatically created withholding tax distributions.
ApInvoiceDistributionsAwtRelatedId The identifier of related invoice distributions for the withholding tax distributions.
ApInvoiceDistributionsAwtTaxRateId The identifier of the withholding tax rate.
ApInvoiceDistributionsBaseAmount The invoice distribution amount in the ledger currency. This is only used for foreign currency invoices.
ApInvoiceDistributionsBaseAmountVariance The amount variance in the ledger currency for invoice distributions matched to a service shipment or receipt.
ApInvoiceDistributionsBaseQuantityVariance The quantity variance on the invoice distribution.
ApInvoiceDistributionsBatchId The identifier of the invoice group used for the invoice.
ApInvoiceDistributionsBcEventId The identifier of the accounting event for the encumbrance accounting event associated with the invoice distribution.
ApInvoiceDistributionsBudgetDate The budgetary calendar period date applicable for funds checking.
ApInvoiceDistributionsCancellationFlag Indicates whether an invoice distribution is canceled. The default value is false. If the value if true, then it indicates the invoice distribution is canceled.
ApInvoiceDistributionsCashBasisFinalAppRounding The rounding amount used to relieve the prepaid expense completely when the cash basis accounting method is used. It is calculated during the final application of a foreign currency prepayment. The amount is added to the prepay type distribution on the invoice that the prepayment is applied to that has the same account as the prepayment distribution with the outstanding balance being relieved.
ApInvoiceDistributionsCcReversalFlag Indicates if the prepaid credit card transaction line distributions are reversed or not. A value of Y indicates that the distributions are reversed.
ApInvoiceDistributionsChargeApplicableToDistId The distribution to which the entire amount of the current charge is applied.
ApInvoiceDistributionsCompanyPrepaidInvoiceId The identifier of the invoice for prepaid credit card transactions.
ApInvoiceDistributionsConsumptionAdviceHeaderId The identifier of the consumption advice associated with the invoice distribution.
ApInvoiceDistributionsConsumptionAdviceLineId The identifier of the line number of the consumption advice associated with the invoice distribution.
ApInvoiceDistributionsCorrectedInvoiceDistId The identifier of the invoice distribution that is corrected by the current invoice distribution. This is used for price, quantity, or invoice line corrections.
ApInvoiceDistributionsCorrectedQuantity The quantity corrected for price, quantity, or invoice line corrections. This attribute is populated for the correcting distribution.
ApInvoiceDistributionsCountryOfSupply The country where services or goods were originated. Used for expense reports.
ApInvoiceDistributionsCreatedBy The user who created the invoice distribution.
ApInvoiceDistributionsCreationDate The date and time when the invoice distribution was created.
ApInvoiceDistributionsCreditCardTrxId The identifier of the credit card transaction.
ApInvoiceDistributionsDailyAmount The amount of the daily expense receipt. Used for expense reports.
ApInvoiceDistributionsDataSetId The identifier of the data set used for processing budgetary control funds reservation requests.
ApInvoiceDistributionsDefAcctgAclCcid The identifier of the accrual account used in multiperiod accounting to accrue deferred expenses.
ApInvoiceDistributionsDefAcctgEndDate The multiperiod accounting end date on the invoice distribution.
ApInvoiceDistributionsDefAcctgStartDate The multiperiod accounting start date on the invoice distribution.
ApInvoiceDistributionsDescription The description of the invoice distribution.
ApInvoiceDistributionsDetailTaxDistId The unique identifier of the tax distribution.
ApInvoiceDistributionsDistCodeCombinationId The identifier of the accounting flexfield for the account associated with the distribution.
ApInvoiceDistributionsDistMatchType Indicates if the invoice is matched to a purchase order or to a receipt of material. A list of accepted values is defined in the lookup type INVOICE LINE MATCH TYPE.
ApInvoiceDistributionsDistributionClass Indicates whether the distribution is permanent or built in preview mode for display to the user. A list of value values is defined in the lookup DISTRIBUTION_CLASS.
ApInvoiceDistributionsDistributionLineNumber The line number associated with the invoice distribution.
ApInvoiceDistributionsEndExpenseDate The last day of an expense that spans multiple days. Used for expense reports.
ApInvoiceDistributionsExchangeDate The date used to derive the conversion rate for converting the foreign currency invoice distribution amount to the ledger currency.
ApInvoiceDistributionsExchangeRate The conversion rate used to convert the foreign currency invoice distribution amount to the ledger currency.
ApInvoiceDistributionsExchangeRateType The conversion rate type used to convert the foreign currency invoice distribution amount to the ledger currency.
ApInvoiceDistributionsExpenditureItemDate The expenditure item date for project-related invoice distributions.
ApInvoiceDistributionsExpenditureOrganizationId The identifier for the project expenditure organization associated with the invoice distribution.
ApInvoiceDistributionsExpenditureType The classification of cost assigned to each expenditure item. Expenditure types are grouped into cost groups or expenditure categories and revenue groups or revenue categories.
ApInvoiceDistributionsExpenseGroup The expense group associated with the invoice line.
ApInvoiceDistributionsExtraPoErv The conversion rate variance for receipt matched distributions, based on the receipt and purchase order conversion rates. This is used for encumbrance accounting.
ApInvoiceDistributionsFinalApplicationRounding The rounding amount to relieve the prepaid expense completely. The amount is calculated during the final application of a prepayment. It is then added to the prepay type distributions on the invoice that the prepayment is applied to that has the same account as the prepayment distribution with the outstanding balance being relieved.
ApInvoiceDistributionsFinalMatchFlag Indicates if an invoice is the last one being matched to a purchase order, so that the purchase order is no longer available for matching to other invoices.
ApInvoiceDistributionsFinalPaymentRounding The rounding amount to relieve the invoice liability completely for foreign currency invoices paid with more than one prepayment application or payment. This is calculated when the invoice becomes fully paid by a prepayment application. This amount is added to the largest prepay distribution on the invoice.
ApInvoiceDistributionsFinalReleaseRounding The rounding amount due to final release of an invoice with retainage.
ApInvoiceDistributionsFullyPaidAcctdFlag Indicates whether the invoice is fully paid and accounted. Used for US Federal Financials. A value of Y indicates that the invoice is fully paid and accounted.
ApInvoiceDistributionsFundsStatus The funds check or reservation status for the invoice distribution.
ApInvoiceDistributionsGlobalAttribute1 A segment for the Payables Invoice Distributions global descriptive flexfield.
ApInvoiceDistributionsGlobalAttribute10 A segment for the Payables Invoice Distributions global descriptive flexfield.
ApInvoiceDistributionsGlobalAttribute11 A segment for the Payables Invoice Distributions global descriptive flexfield.
ApInvoiceDistributionsGlobalAttribute12 A segment for the Payables Invoice Distributions global descriptive flexfield.
ApInvoiceDistributionsGlobalAttribute13 A segment for the Payables Invoice Distributions global descriptive flexfield.
ApInvoiceDistributionsGlobalAttribute14 A segment for the Payables Invoice Distributions global descriptive flexfield.
ApInvoiceDistributionsGlobalAttribute15 A segment for the Payables Invoice Distributions global descriptive flexfield.
ApInvoiceDistributionsGlobalAttribute16 A segment for the Payables Invoice Distributions global descriptive flexfield.
ApInvoiceDistributionsGlobalAttribute17 A segment for the Payables Invoice Distributions global descriptive flexfield.
ApInvoiceDistributionsGlobalAttribute18 A segment for the Payables Invoice Distributions global descriptive flexfield.
ApInvoiceDistributionsGlobalAttribute19 A segment for the Payables Invoice Distributions global descriptive flexfield.
ApInvoiceDistributionsGlobalAttribute2 A segment for the Payables Invoice Distributions global descriptive flexfield.
ApInvoiceDistributionsGlobalAttribute20 A segment for the Payables Invoice Distributions global descriptive flexfield.
ApInvoiceDistributionsGlobalAttribute3 A segment for the Payables Invoice Distributions global descriptive flexfield.
ApInvoiceDistributionsGlobalAttribute4 A segment for the Payables Invoice Distributions global descriptive flexfield.
ApInvoiceDistributionsGlobalAttribute5 A segment for the Payables Invoice Distributions global descriptive flexfield.
ApInvoiceDistributionsGlobalAttribute6 A segment for the Payables Invoice Distributions global descriptive flexfield.
ApInvoiceDistributionsGlobalAttribute7 A segment for the Payables Invoice Distributions global descriptive flexfield.
ApInvoiceDistributionsGlobalAttribute8 A segment for the Payables Invoice Distributions global descriptive flexfield.
ApInvoiceDistributionsGlobalAttribute9 A segment for the Payables Invoice Distributions global descriptive flexfield.
ApInvoiceDistributionsGlobalAttributeCategory The context name for the Payables Invoice Distributions global descriptive flexfield.
ApInvoiceDistributionsGlobalAttributeDate1 A date segment for the Payables Invoice Distributions global descriptive flexfield.
ApInvoiceDistributionsGlobalAttributeDate2 A date segment for the Payables Invoice Distributions global descriptive flexfield.
ApInvoiceDistributionsGlobalAttributeDate3 A date segment for the Payables Invoice Distributions global descriptive flexfield.
ApInvoiceDistributionsGlobalAttributeDate4 A date segment for the Payables Invoice Distributions global descriptive flexfield.
ApInvoiceDistributionsGlobalAttributeDate5 A date segment for the Payables Invoice Distributions global descriptive flexfield.
ApInvoiceDistributionsGlobalAttributeNumber1 A number segment for the Payables Invoice Distributions global descriptive flexfield.
ApInvoiceDistributionsGlobalAttributeNumber2 A number segment for the Payables Invoice Distributions global descriptive flexfield.
ApInvoiceDistributionsGlobalAttributeNumber3 A number segment for the Payables Invoice Distributions global descriptive flexfield.
ApInvoiceDistributionsGlobalAttributeNumber4 A number segment for the Payables Invoice Distributions global descriptive flexfield.
ApInvoiceDistributionsGlobalAttributeNumber5 A number segment for the Payables Invoice Distributions global descriptive flexfield.
ApInvoiceDistributionsGmsBurdenableRawCost The raw cost on the invoice distribution that can be burdened.
ApInvoiceDistributionsIncomeTaxRegion The reporting region on the invoice line for a 1099 supplier.
ApInvoiceDistributionsIntendedUse A tax driver used to determine and calculate the applicable taxes.
ApInvoiceDistributionsIntendedUseClassifId The unique identifier of the user-entered intended use code.
ApInvoiceDistributionsInventoryTransferStatus Indicates whether the invoice distribution was processed by the transfer invoice variance program. A value of N indicates that the distribution has not been transferred. No value indicates that either the distribution was transferred or is not eligible for transfer to inventory valuation. The default value of this attribute at the time of distribution creation is N.
ApInvoiceDistributionsInvoiceDistributionId The unique identifier of the invoice distribution. This attribute forms part of the primary key for the Invoice Distributions view object.
ApInvoiceDistributionsInvoiceId The unique identifier of the invoice associated with the invoice distribution.
ApInvoiceDistributionsInvoiceIncludesPrepayFlag Indicates whether the prepayment amount is included in the invoice amount.
ApInvoiceDistributionsInvoiceLineNumber The unique number for the invoice line associated with the invoice distribution.
ApInvoiceDistributionsJustification The reason an expense was incurred. Used for expense reports.
ApInvoiceDistributionsLastUpdateDate The date and time when the invoice distribution was last updated. This attribute forms part of the primary key for the Invoice Distributions view object.
ApInvoiceDistributionsLastUpdateLogin The session login of the user who last updated the invoice distribution.
ApInvoiceDistributionsLastUpdatedBy The user who last updated the invoice distribution. This attribute forms part of the primary key for the Invoice Distributions view object.
ApInvoiceDistributionsLineTypeLookupCode The type of invoice line associated with the invoice distribution. A list of accepted values is defined in the lookup type INVOICE DISTRIBUTION TYPE.
ApInvoiceDistributionsMatchStatusFlag Indicates whether the invoice distribution is generated for a purchase order matched line. The default value is set to Not Matched.
ApInvoiceDistributionsMatchedUomLookupCode The unit of measure used for the invoiced quantity when this distribution is matched.
ApInvoiceDistributionsMerchantDocumentNumber The number on the receipt issued by the merchant. Used for expense reports.
ApInvoiceDistributionsMerchantName The name of the merchant where the expense was incurred. Used for expense reports.
ApInvoiceDistributionsMerchantReference The purchase identification of a transaction provided by the merchant at the point of sale. Used for expense reports.
ApInvoiceDistributionsMerchantTaxRegNumber Unique sequence of letters or numbers assigned to the merchant by a tax authority when it is registered and by which the merchant registration is identified.
ApInvoiceDistributionsMerchantTaxpayerId The unique identifier of the merchant tax payer.
ApInvoiceDistributionsObjectVersionNumber The number of times that the invoice distribution has been updated.
ApInvoiceDistributionsOrgId The identifier of the business unit associated with the invoice distribution.
ApInvoiceDistributionsPJC_BILLABLE_FLAG Indicates whether a project-related item is available to be billed to customers.
ApInvoiceDistributionsPJC_CAPITALIZABLE_FLAG Indicates whether a project-related item is eligible for capitalization.
ApInvoiceDistributionsPJC_CONTEXT_CATEGORY The segment used to identify the descriptive flexfield application context for project-related standardized code collection.
ApInvoiceDistributionsPJC_CONTRACT_ID The identifier of the project contract associated with the expenditure. Used when Oracle Contract Billing or Oracle Grants Accounting is installed.
ApInvoiceDistributionsPJC_CONTRACT_LINE_ID The identifier of the project contract line. Used when Oracle Contract Billing or Oracle Grants Accounting is installed.
ApInvoiceDistributionsPJC_EXPENDITURE_ITEM_DATE The date on which work is performed and is charged to a project and task.
ApInvoiceDistributionsPJC_EXPENDITURE_TYPE_ID The identifier of the expenditure type. An expenditure type is a classification of cost that you assign to each expenditure item. Expenditure types are grouped into cost groups or expenditure categories and revenue groups or revenue categories.
ApInvoiceDistributionsPJC_FUNDING_ALLOCATION_ID The identifier of the project funding allocation.
ApInvoiceDistributionsPJC_ORGANIZATION_ID The organization that the incurring employee is assigned unless overridden by organization overrides for time cards and expense reports. Additionally, the incurring organization entered on the expenditure for usage, supplier invoices, and purchasing commitments.
ApInvoiceDistributionsPJC_PROJECT_ID The identifier of the number assigned to a project.
ApInvoiceDistributionsPJC_RESERVED_ATTRIBUTE1 Reserved for future project-related functionality.
ApInvoiceDistributionsPJC_RESERVED_ATTRIBUTE10 Reserved for future project-related functionality.
ApInvoiceDistributionsPJC_RESERVED_ATTRIBUTE2 Reserved for future project-related functionality.
ApInvoiceDistributionsPJC_RESERVED_ATTRIBUTE3 Reserved for future project-related functionality.
ApInvoiceDistributionsPJC_RESERVED_ATTRIBUTE4 Reserved for future project-related functionality.
ApInvoiceDistributionsPJC_RESERVED_ATTRIBUTE5 Reserved for future project-related functionality.
ApInvoiceDistributionsPJC_RESERVED_ATTRIBUTE6 Reserved for future project-related functionality.
ApInvoiceDistributionsPJC_RESERVED_ATTRIBUTE7 Reserved for future project-related functionality.
ApInvoiceDistributionsPJC_RESERVED_ATTRIBUTE8 Reserved for future project-related functionality.
ApInvoiceDistributionsPJC_RESERVED_ATTRIBUTE9 Reserved for future project-related functionality.
ApInvoiceDistributionsPJC_TASK_ID The identifier of the project task used to build the transaction descriptive flexfield for project-related invoice line distributions.
ApInvoiceDistributionsPJC_USER_DEF_ATTRIBUTE1 Reserved for user-defined project information.
ApInvoiceDistributionsPJC_USER_DEF_ATTRIBUTE10 Reserved for user-defined project information.
ApInvoiceDistributionsPJC_USER_DEF_ATTRIBUTE2 Reserved for user-defined project information.
ApInvoiceDistributionsPJC_USER_DEF_ATTRIBUTE3 Reserved for user-defined project information.
ApInvoiceDistributionsPJC_USER_DEF_ATTRIBUTE4 Reserved for user-defined project information.
ApInvoiceDistributionsPJC_USER_DEF_ATTRIBUTE5 Reserved for user-defined project information.
ApInvoiceDistributionsPJC_USER_DEF_ATTRIBUTE6 Reserved for user-defined project information.
ApInvoiceDistributionsPJC_USER_DEF_ATTRIBUTE7 Reserved for user-defined project information.
ApInvoiceDistributionsPJC_USER_DEF_ATTRIBUTE8 Reserved for user-defined project information.
ApInvoiceDistributionsPJC_USER_DEF_ATTRIBUTE9 Reserved for user-defined project information.
ApInvoiceDistributionsPJC_WORK_TYPE_ID The identifier of the project work type classification of the work performed on a project.
ApInvoiceDistributionsPaAdditionFlag Indicates if project-related invoice distributions have been transferred to Oracle Fusion Projects.
ApInvoiceDistributionsPaCmtXfaceFlag Indicates if project-related invoice distributions were transferred to Oracle Fusion Projects as a committed cost.
ApInvoiceDistributionsPaQuantity The quantity billed to a project.
ApInvoiceDistributionsParentInvoiceId The identifier of the invoice matched to a credit or debit memo.
ApInvoiceDistributionsParentReversalId The identifier of the invoice distribution being reversed by the current distribution.
ApInvoiceDistributionsPeriodName The period name for the invoice distribution.
ApInvoiceDistributionsPoDistributionId The identifier of the purchase order distribution line that is associated with the invoice distribution.
ApInvoiceDistributionsPostedFlag Indicates whether the invoice distribution line has been accounted.
ApInvoiceDistributionsPrepayAmountRemaining The amount of the prepayment that can still be applied to an invoice.
ApInvoiceDistributionsPrepayDistributionId The identifier of the prepayment distribution line related to the prepayment line.
ApInvoiceDistributionsPrepayTaxDiffAmount The amount resulting from a tax rate or recovery rate change between the prepayment invoice date and the standard invoice date.
ApInvoiceDistributionsProgramApplicationId The application that last updated the invoice distribution.
ApInvoiceDistributionsProgramId The process that last updated the invoice distribution.
ApInvoiceDistributionsProgramUpdateDate The date on which the process last updated the invoice distribution.
ApInvoiceDistributionsProjectId The unique identifier of the project associated with the invoice distribution.
ApInvoiceDistributionsQuantityInvoiced The quantity that was invoiced.
ApInvoiceDistributionsQuantityVariance The quantity variance on the invoice distribution.
ApInvoiceDistributionsRcvChargeAdditionFlag Indicates whether distributions have been reversed. A value of N indicates that distribution have been not been reversed. A value of blank indicates that the distributions have been reversed.
ApInvoiceDistributionsRcvTransactionId The identifier of the receipt of material that originated the invoice distribution.
ApInvoiceDistributionsRecNrecRate Indicates whether a tax rate is recoverable or nonrecoverable.
ApInvoiceDistributionsReceiptConversionRate The conversion rate used for conversion from the receipt currency to the ledger currency. Used for expense reports.
ApInvoiceDistributionsReceiptCurrencyAmount The distribution amount in the expense receipt currency. Used for expense reports.
ApInvoiceDistributionsReceiptCurrencyCode The currency of the expense receipt. Used for expense reports.
ApInvoiceDistributionsReceiptMissingFlag Indicates whether receipts are missing for an expense. Used for expense reports.
ApInvoiceDistributionsReceiptRequiredFlag Indicates whether an expense requires a receipt. Used for expense reports.
ApInvoiceDistributionsReceiptVerifiedFlag Indicates whether an auditor verified the receipt for an expense. Used for expense reports.
ApInvoiceDistributionsRecoveryRateCode The rate at which tax is recoverable for the recoverable tax line.
ApInvoiceDistributionsRecoveryRateId The identifier of the tax recovery rate.
ApInvoiceDistributionsRecoveryRateName The name of the tax rate.
ApInvoiceDistributionsRecoveryTypeCode The mechanism to administer the recovery process for a specific tax.
ApInvoiceDistributionsRecurringPaymentId The identifier of the recurring invoice.
ApInvoiceDistributionsReference1 Reference to a record in another application.
ApInvoiceDistributionsReference2 Reference to a record in another application.
ApInvoiceDistributionsRelatedId The identifier that links related distributions. This is used for linking related IPV, ERV, ITEM, or ACCRUAL distributions and is populated with the invoice distribution identifier of the item or accrual distribution. If there are no item or accrual distributions, then it is populated with the identifier of the invoice price variance distribution. In all other cases, it is populated with the identifier of the conversion rate variance distribution.
ApInvoiceDistributionsRelatedRetainageDistId The identifier of the related retainage invoice distribution.
ApInvoiceDistributionsReleaseInvDistDerivedFrom The identifier of the retainage release invoice distribution.
ApInvoiceDistributionsRequestId The identifier of the scheduled process request that created or last updated the invoice distribution.
ApInvoiceDistributionsRetainedAmountRemaining The retained amount available for release on the standard invoice distribution.
ApInvoiceDistributionsRetainedInvoiceDistId The identifier of the original invoice distribution on which the amount was retained. This attribute is populated for the invoice distributions of the retainage release invoice.
ApInvoiceDistributionsReversalFlag Indicates whether a distribution is part of a reversal pair. The default value is false. If the value if true, then it indicates that the distribution is part of a reversal pair.
ApInvoiceDistributionsRootDistributionId The identifier of the original distribution that was subject to a retroactive price adjustment. This attribute is populated on the purchase order price adjustment and adjustment documents.
ApInvoiceDistributionsRoundingAmt The rounding amount on the invoice distribution represented in the ledger currency.
ApInvoiceDistributionsSetOfBooksId The unique identifier of the ledger associated with the invoice distribution.
ApInvoiceDistributionsStartExpenseDate The date when the expense occurred or the first day of an expense that spans multiple days. Used for expense reports.
ApInvoiceDistributionsStatAmount The amount associated with a distribution for measuring statistical quantities.
ApInvoiceDistributionsSummaryTaxLineId The unique identifier of the summary line associated with the tax line.
ApInvoiceDistributionsTaskId The identifier of the project task for project-related invoice distributions.
ApInvoiceDistributionsTaxAlreadyDistributedFlag Internal processing indicator for Oracle Fusion Payables, indicating whether tax was distributed.
ApInvoiceDistributionsTaxCodeId The identifier of the tax code on the invoice distribution.
ApInvoiceDistributionsTaxRecoverableFlag Indicates if tax is fully or partially recoverable for the invoice distribution. Valid values are Y or N.
ApInvoiceDistributionsTaxableAmount The taxable amount for the distribution. This attribute is used during upgrade and is intended for internal use only.
ApInvoiceDistributionsTaxableBaseAmount The taxable amount in the ledger currency for the distribution. This attribute is used during upgrade and is intended for internal use only.
ApInvoiceDistributionsTotalDistAmount The sum total of amounts related to this distribution including variance amounts from related invoice distributions.
ApInvoiceDistributionsTotalDistBaseAmount The sum total of amounts related to this distribution including variance amounts from related invoice distributions in the ledger currency.
ApInvoiceDistributionsType1099 The payments of type 1099 made to a supplier.
ApInvoiceDistributionsUnitPrice The unit price for a good or service.
ApInvoiceDistributionsUpgradeBasePostedAmt This attribute is reserved for future use.
ApInvoiceDistributionsUpgradePostedAmt This attribute is reserved for future use.
ApInvoiceDistributionsWebParameterId The parameter identifier of the self-service web application associated with the Invoice distribution.
ApInvoiceDistributionsWithholdingTaxCodeId The unique identifier of the withholding tax rates applicable to the invoice.
ApInvoiceDistributionsXinvParentReversalId The cross-invoice parent reversal identifier of the distribution that has been reversed. This attribute is populated for distributions that negate a distribution on a different invoice.