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. |