Payment History Distributions

The payment history distributions view object contains payment distributions associated with payment accounting events referenced in the payment history view object. Each row in the payment history view object has one or more rows in the payment history distributions view object.

Data Store Key : FscmTopModelAM.FinExtractAM.ApBiccExtractAM.PaymentHistoryDistributionExtractPVO

Primary Keys : ApPaymentHistDistsPaymentHistDistId

Initial Extract Date : ApPaymentHistDistsCreationDate

Incremental Extract Date : ApPaymentHistDistsLastUpdateDate

Attributes

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

Name	Description
ApPaymentHistDistsAccountingEventId	The identifier of the payment accounting event.
ApPaymentHistDistsAmount	The amount of the distribution in the payment history.
ApPaymentHistDistsAmountVariance	The variance amount of the payment distribution.
ApPaymentHistDistsAwtRelatedId	The line number of the withholding distribution.
ApPaymentHistDistsBankCurrAmount	The amount of the distribution in the bank account currency.
ApPaymentHistDistsClearedBaseAmount	The payment cleared amount in the ledger currency.
ApPaymentHistDistsCreatedBy	The user who created the payment history distribution row.
ApPaymentHistDistsCreationDate	The date and time when the payment history distribution was created.
ApPaymentHistDistsHistoricalFlag	Indicates whether the payment distribution is a result of upgraded data.
ApPaymentHistDistsInvoiceAdjustmentEventId	The identifier of the invoice adjustment event that resulted in the payment distribution.
ApPaymentHistDistsInvoiceBaseAmtVariance	The variance amount on the invoice for the payment distribution in the ledger currency.
ApPaymentHistDistsInvoiceBaseQtyVariance	The quantity variance amount in the ledger currency for invoice distribution lines matched to a purchase order or receipt.
ApPaymentHistDistsInvoiceDistAmount	The amount paid of the related invoice distribution in entered invoice currency.
ApPaymentHistDistsInvoiceDistBaseAmount	Amount of related invoice distribution in the ledger currency using the invoice conversion rate.
ApPaymentHistDistsInvoiceDistributionId	The identifier of the related invoice distribution.
ApPaymentHistDistsInvoicePaymentId	The identifier of the invoice payment.
ApPaymentHistDistsLastUpdateDate	The date when the payment history distribution row was last updated.
ApPaymentHistDistsLastUpdateLogin	The session login associated with the user who last updated the payment history distribution row.
ApPaymentHistDistsLastUpdatedBy	The user who last updated the payment history distribution row.
ApPaymentHistDistsMaturedBaseAmount	The matured payment amount of a future dated payment in ledger currency
ApPaymentHistDistsObjectVersionNumber	The number of times that the payment history distribution row has been updated.
ApPaymentHistDistsPaAdditionFlag	Indicates whether project related invoice distributions have been transferred to Oracle Projects when cash basis accounting is used.
ApPaymentHistDistsPaidBaseAmount	The payment distribution amount in the ledger currency using the payment conversion rate.
ApPaymentHistDistsPayDistLookupCode	The name of the distribution type used for the payment distribution.
ApPaymentHistDistsPaymentHistDistId	The unique identifier of the payment history distribution row. This is the primary key of the Payment History Distributions view object.
ApPaymentHistDistsPaymentHistoryId	The identifier of the payment history event.
ApPaymentHistDistsProgramApplicationId	The application that last updated the payment history distribution row.
ApPaymentHistDistsProgramId	The process that last updated the payment history distribution row.
ApPaymentHistDistsProgramLoginId	The session login associated with the process that last updated the payment history distribution row.
ApPaymentHistDistsProgramUpdateDate	The date the process last updated the payment history distribution row.
ApPaymentHistDistsQuantityVariance	The quantity variance amount for invoice distribution lines matched to a purchase order or receipt.
ApPaymentHistDistsReleaseInvDistDerivedFrom	The identifier of the retainage release invoice distribution used for subledger accounting business flows.
ApPaymentHistDistsRequestId	The request identifier of the process that created or last updated the payment history distribution row.
ApPaymentHistDistsReversalFlag	Indicates if the distribution reverses another payment distribution.
ApPaymentHistDistsReversedPayHistDistId	The identifier of the accounting event of the payment distribution being reversed.
ApPaymentHistDistsRoundingAmt	The rounding amount resulting from proration using the payment conversion rate.