Prepayment Application Distributions

The prepayment application distributions view object contains information about the distribution of prepayment application distributions to the recipient invoice distributions.

Data Store Key : FscmTopModelAM.FinExtractAM.ApBiccExtractAM.PrepaymentApplicationDistributionExtractPVO

Primary Keys : ApPrepayAppDistsPrepayAppDistId

Initial Extract Date : ApPrepayAppDistsCreationDate

Incremental Extract Date : ApPrepayAppDistsLastUpdateDate

Attributes

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

Name	Description
ApPrepayAppDistsAccountingEventId	The identifier of the prepayment application accounting event.
ApPrepayAppDistsAmount	The prorated invoice distribution amount of the prepayment that is applied to the invoice.
ApPrepayAppDistsAmountVariance	The amount variance in the entered currency for invoice distributions matched to a service shipment or receipt.
ApPrepayAppDistsAwtRelatedId	The identifier of the withholding tax distribution.
ApPrepayAppDistsBaseAmount	The prorated invoice distribution amount in the ledger currency that is derived using the invoice conversion rate.
ApPrepayAppDistsBaseAmtAtPrepayClrXrate	The ledger amount derived using the prepayment clearing conversion rate.
ApPrepayAppDistsBaseAmtAtPrepayPayXrate	The ledger amount derived using the prepayment payment clearing conversion rate.
ApPrepayAppDistsBaseAmtAtPrepayXrate	The ledger amount derived using the prepayment conversion rate.
ApPrepayAppDistsBcEventId	The identifier of accounting event raised for encumbrance accounting.
ApPrepayAppDistsCreatedBy	The user who created the prepayment application distribution row.
ApPrepayAppDistsCreationDate	The date and time when the prepayment application distribution was created.
ApPrepayAppDistsInvoiceBaseAmtVariance	The amount variance in the ledger currency for invoice distributions matched to a service shipment or receipt.
ApPrepayAppDistsInvoiceBaseQtyVariance	The quantity variance in the ledger currency for invoice distributions matched to a purchase order or receipt.
ApPrepayAppDistsInvoiceDistributionId	The identifier of the related invoice distribution.
ApPrepayAppDistsLastUpdateDate	The date when the prepayment application distribution was last updated.
ApPrepayAppDistsLastUpdateLogin	The session login associated with the user who last updated the prepayment application distribution.
ApPrepayAppDistsLastUpdatedBy	The user who last updated the prepayment application distribution.
ApPrepayAppDistsObjectVersionNumber	The number of times the prepayment application distribution has been updated.
ApPrepayAppDistsPaAdditionFlag	Indicates if project-related invoice distributions have been transferred to Oracle Fusion Projects.
ApPrepayAppDistsPrepayAppDistId	The unique Identifier of the prepayment application distribution. This is the primary key of the Prepayment Application Distributions view object.
ApPrepayAppDistsPrepayAppDistributionId	The unique identifier of the prepayment invoice distribution.
ApPrepayAppDistsPrepayClrExchangeDate	The date used to derive the conversion rate for the prepayment payment bank currency to the ledger currency. Used for calculation at the time of payment clearing for prepayment invoices.
ApPrepayAppDistsPrepayClrExchangeRate	The rate used to convert the bank currency amount of a prepayment to the ledger currency at clearing time.
ApPrepayAppDistsPrepayClrExchangeRateType	The rate type used to convert the bank currency amount of a prepayment payment to the ledger currency at clearing time.
ApPrepayAppDistsPrepayDistLookupCode	The name of the distribution type. A list of accepted values is defined in the lookup type INVOICE DISTRIBUTION TYPE.
ApPrepayAppDistsPrepayExchangeDate	The date when the prepayment to the supplier was created.
ApPrepayAppDistsPrepayExchangeRate	The conversion rate at which the prepayment to the supplier was created.
ApPrepayAppDistsPrepayExchangeRateType	The rate type used to convert the prepayment invoice amount to the ledger currency.
ApPrepayAppDistsPrepayHistoryId	The unique identifier of the prepayment history.
ApPrepayAppDistsPrepayPayExchangeDate	The date used to derive the conversion rate for the prepayment payment currency to the ledger currency.
ApPrepayAppDistsPrepayPayExchangeRate	The rate used to convert the foreign currency prepayment payment amount to the ledger currency.
ApPrepayAppDistsPrepayPayExchangeRateType	The rate type used to convert the foreign currency prepayment payment amount to the ledger currency.
ApPrepayAppDistsProgramApplicationId	The application that last updated the prepayment application distribution.
ApPrepayAppDistsProgramId	The process that last updated the prepayment application distribution.
ApPrepayAppDistsProgramUpdateDate	The date when a process last updated the prepayment application distribution.
ApPrepayAppDistsQuantityVariance	The quantity variance amount for invoice distribution lines matched to a purchase order or receipt.
ApPrepayAppDistsReleaseInvDistDerivedFrom	The identifier of the retainage release invoice distribution.
ApPrepayAppDistsRequestId	The identifier of the scheduled process request that created or last updated the prepayment application distribution.
ApPrepayAppDistsReversedPrepayAppDistId	The identifier of the prepayment application payment distribution being reversed.
ApPrepayAppDistsRoundAmtAtPrepayClrXrate	The rounding amount that results from proration using the prepayment payment clearing conversion rate.
ApPrepayAppDistsRoundAmtAtPrepayPayXrate	The rounding amount that results from proration using the prepayment payment conversion rate.
ApPrepayAppDistsRoundAmtAtPrepayXrate	The rounding amount that results from proration using the prepayment conversion rate.
ApPrepayAppDistsRoundingAmt	The amount that was added to the distribution line to ensure that the total of distribution line amounts adds up to the invoice amount in the ledger currency.