Payment History
The payment history view object contains clearing and unclearing history for payments such as transaction date, transaction amount, transaction type and so on. It also contains maturity history for future dated payments.
Data Store Key : FscmTopModelAM.FinExtractAM.ApBiccExtractAM.DisbursementHistoryHeaderExtractPVO
Primary Keys : ApPaymentHistoryAllPaymentHistoryId
Initial Extract Date : ApPaymentHistoryAllCreationDate
Incremental Extract Date : ApPaymentHistoryAllLastUpdateDate
Attributes
This table provides the list of exposed attributes and their descriptions.
| Name | Description |
|---|---|
| ApPaymentHistoryAllAccountingDate | The accounting date for accounting entries for this transaction |
| ApPaymentHistoryAllAccountingEventId | The identifier of the accounting event. |
| ApPaymentHistoryAllBankCurrencyCode | The currency of the bank account used for the payment. This is a foreign key of the Currencies view object. |
| ApPaymentHistoryAllBankToBaseXrate | The conversion rate from bank account currency to ledger currency. |
| ApPaymentHistoryAllBankToBaseXrateDate | The date effective for the conversion rate from bank account currency to ledger currency. |
| ApPaymentHistoryAllBankToBaseXrateType | The conversion rate type for conversion from bank account currency to ledger currency. |
| ApPaymentHistoryAllChargeAmount | The bank charge amount on the reconciled payment. |
| ApPaymentHistoryAllChargesBankAmount | The bank charges amount in bank account currency. |
| ApPaymentHistoryAllChargesBaseAmount | The bank charges amount in ledger currency. |
| ApPaymentHistoryAllChargesPmtAmount | The bank charges amount in payment currency. |
| ApPaymentHistoryAllCheckId | The identifier of the payment document |
| ApPaymentHistoryAllCreatedBy | The user who created the payment history row. |
| ApPaymentHistoryAllCreationDate | The date and time when the payment history row was created. |
| ApPaymentHistoryAllCurrencyCode | The ledger currency of the payment. This is a foreign key of the Currencies view object. |
| ApPaymentHistoryAllErrorAmount | The reconciliation error amount on the reconciled payment. |
| ApPaymentHistoryAllErrorsBankAmount | The reconciliation error amount in bank account currency. |
| ApPaymentHistoryAllErrorsBaseAmount | The reconciliation error amount in ledger currency. |
| ApPaymentHistoryAllErrorsPmtAmount | The reconciliation error amount in payment currency. |
| ApPaymentHistoryAllGainLossIndicator | Indicator for whether the payment related transaction resulted in gain or loss. Possible values are G or L. |
| ApPaymentHistoryAllHistoricalFlag | Indicator for whether the payment transaction is a result of upgraded data. |
| ApPaymentHistoryAllInvoiceAdjustmentEventId | The identifier of the invoice adjustment event for which the payment adjustment event is created in this view object. When a paid invoice is adjusted, an invoice adjustment event is created for the adjustment accounting entries. For each such invoice adjustment event, there is a corresponding payment adjustment event that adjusts the supplier liability. |
| ApPaymentHistoryAllLastUpdateDate | The date when the payment history row was last updated. |
| ApPaymentHistoryAllLastUpdateLogin | The session login associated with the user who last updated the payment history row. |
| ApPaymentHistoryAllLastUpdatedBy | The user who last updated the payment history row. |
| ApPaymentHistoryAllMatchedFlag | Indicates whether the payment is matched to a bank statement line. It can have two possible values : Y or N. A value of Y indicates that the payment Is reconciled. A value of N indicates that the payment is cleared. |
| ApPaymentHistoryAllMrcBankToBaseXrate | Multiple Reporting Currencies only. This attribute is currently unused. |
| ApPaymentHistoryAllMrcBankToBaseXrateDate | Multiple Reporting Currencies only. This attribute is currently unused. |
| ApPaymentHistoryAllMrcBankToBaseXrateType | Multiple Reporting Currencies only. This attribute is currently unused. |
| ApPaymentHistoryAllMrcChargesBaseAmount | Multiple Reporting Currencies only. This attribute is currently unused. |
| ApPaymentHistoryAllMrcErrorsBaseAmount | Multiple Reporting Currencies only. This attribute is currently unused. |
| ApPaymentHistoryAllMrcExchangeRate | Multiple Reporting Currencies only. This attribute is currently unused. |
| ApPaymentHistoryAllMrcExchangeRateDate | Multiple Reporting Currencies only. This attribute is currently unused. |
| ApPaymentHistoryAllMrcExchangeRateType | Multiple Reporting Currencies only. This attribute is currently unused. |
| ApPaymentHistoryAllMrcPmtToBaseXrate | Multiple Reporting Currencies only. This attribute is currently unused. |
| ApPaymentHistoryAllMrcPmtToBaseXrateDate | Multiple Reporting Currencies only. This attribute is currently unused. |
| ApPaymentHistoryAllMrcPmtToBaseXrateType | Multiple Reporting Currencies only. This attribute is currently unused. |
| ApPaymentHistoryAllMrcTrxBaseAmount | Multiple Reporting Currencies only. This attribute is currently unused. |
| ApPaymentHistoryAllObjectVersionNumber | The number of times the payment history row has been updated. |
| ApPaymentHistoryAllOrgId | The identifier of the business unit associated with the payment history row. |
| ApPaymentHistoryAllPaymentHistoryId | The unique identifier of the payment history row. This is the primary key of the payment history view object. |
| ApPaymentHistoryAllPmtCurrencyCode | The currency of the payment. This is a foreign key of the Currencies view object. |
| ApPaymentHistoryAllPmtToBaseXrate | The conversion rate from payment currency to ledger currency. |
| ApPaymentHistoryAllPmtToBaseXrateDate | The date effective for the conversion rate from payment currency to ledger currency. |
| ApPaymentHistoryAllPmtToBaseXrateType | The conversion rate type for conversion from payment currency to ledger currency. |
| ApPaymentHistoryAllPostedFlag | Indicates whether the maturity, clearing or unclearing transaction has been accounted. It can have two possible values: Y and N. |
| ApPaymentHistoryAllProgramApplicationId | The application identifier of the program that last updated the payment history row. |
| ApPaymentHistoryAllProgramId | The program identifier of the program that last updated the payment history row. |
| ApPaymentHistoryAllProgramUpdateDate | The date when the program that updated the payment history row was last run. |
| ApPaymentHistoryAllRelatedEventId | The identifier of the originating transaction event. |
| ApPaymentHistoryAllRequestId | The request identifier of the enterprise service scheduler job that created or last update the payment history row. |
| ApPaymentHistoryAllRevPmtHistId | The unique identifier of the reversed payment history transaction. |
| ApPaymentHistoryAllTransactionAmount | The transaction amount in the payment history. |
| ApPaymentHistoryAllTransactionDate | The transaction date in the payment history. |
| ApPaymentHistoryAllTransactionType | The transaction type of the payment history row. It can have three possible values : Payment Maturity, Payment Clearing, Payment Unclearing. |
| ApPaymentHistoryAllTrxBankAmount | The payment amount to clear in bank account currency. This is inclusive of charges and errors. |
| ApPaymentHistoryAllTrxBaseAmount | The payment amount to clear in ledger currency. This is inclusive of charges and errors. |
| ApPaymentHistoryAllTrxPmtAmount | The payment amount to clear in payment currency. This is inclusive of charges and errors. |