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