Transaction History
The transaction history view object contains the detailed information about each bills receivable transaction, including activities and the life cycle of bills receivable events.
Data Store Key : FscmTopModelAM.FinExtractAM.ArBiccExtractAM.TransactionHistoryAllExtractPVO
Primary Keys : TransactionHistoryAllTransactionHistoryId
Initial Extract Date : TransactionHistoryAllCreationDate
Incremental Extract Date : TransactionHistoryAllLastUpdateDate
Attributes
This table provides the list of exposed attributes and their descriptions.
| Name | Description |
|---|---|
| TransactionHistoryAllAttribute1 | A segment of the Receivables Transaction History descriptive flexfield 1. |
| TransactionHistoryAllAttribute10 | A segment of the Receivables Transaction History descriptive flexfield 10. |
| TransactionHistoryAllAttribute11 | A segment of the Receivables Transaction History descriptive flexfield 11. |
| TransactionHistoryAllAttribute12 | A segment of the Receivables Transaction History descriptive flexfield 12. |
| TransactionHistoryAllAttribute13 | A segment of the Receivables Transaction History descriptive flexfield 13. |
| TransactionHistoryAllAttribute14 | A segment of the Receivables Transaction History descriptive flexfield 14. |
| TransactionHistoryAllAttribute15 | A segment of the Receivables Transaction History descriptive flexfield 15. |
| TransactionHistoryAllAttribute2 | A segment of the Receivables Transaction History descriptive flexfield 2. |
| TransactionHistoryAllAttribute3 | A segment of the Receivables Transaction History descriptive flexfield 3. |
| TransactionHistoryAllAttribute4 | A segment of the Receivables Transaction History descriptive flexfield 4. |
| TransactionHistoryAllAttribute5 | A segment of the Receivables Transaction History descriptive flexfield 5. |
| TransactionHistoryAllAttribute6 | A segment of the Receivables Transaction History descriptive flexfield 6. |
| TransactionHistoryAllAttribute7 | A segment of the Receivables Transaction History descriptive flexfield 7. |
| TransactionHistoryAllAttribute8 | A segment of the Receivables Transaction History descriptive flexfield 8. |
| TransactionHistoryAllAttribute9 | A segment of the Receivables Transaction History descriptive flexfield 9. |
| TransactionHistoryAllAttributeCategory | The descriptive flexfield context name for the Receivables Transaction History descriptive flexfield. |
| TransactionHistoryAllBatchId | The identifier of the bills receivable batch. |
| TransactionHistoryAllComments | The user-entered comments associated with the bills receivable transaction. |
| TransactionHistoryAllCreatedBy | The user who created the bills receivable transaction history line. |
| TransactionHistoryAllCreatedFrom | The application from which the bills receivable transaction history is created. |
| TransactionHistoryAllCreationDate | The date and time the bills receivable transaction history line was created. |
| TransactionHistoryAllCurrentAccountedFlag | The option that indicates whether the history record represents the latest accounted record for the bill receivable. A list of accepted values is defined in the lookup type YES_NO. |
| TransactionHistoryAllCurrentRecordFlag | The option that indicates whether the history record represents the latest record for the bill receivable. A list of accepted values is defined in the lookup type YES_NO. |
| TransactionHistoryAllCustomerTrxId | The identifier of the bills receivable transaction. |
| TransactionHistoryAllEvent | The event that created this transaction history record for a bill receivable. Examples include ACCEPTED, CANCELLED, CLOSED, COMPLETED, FACTORED, HOLD, INCOMPLETE, MATURITY_DATE, PROTESTED, RELEASE_HOLD, REMITTED, RISK_ELIMINATED, SELECTED_REMITTANCE, and UNPAID. |
| TransactionHistoryAllEventId | The identifier of the event that created this transaction history record for a bill receivable. |
| TransactionHistoryAllFirstPostedRecordFlag | The option that indicates whether this history record is the first posted record for a bill receivable. |
| TransactionHistoryAllGlDate | The accounting date of the event that resulted in the creation of the transaction history for a bill receivable. |
| TransactionHistoryAllGlPostedDate | The date when the bills receivable transaction was posted to the General Ledger. |
| TransactionHistoryAllLastUpdateDate | The date and time of the last update to the transaction history for a bill receivable. |
| TransactionHistoryAllLastUpdateLogin | The session login of the user who last updated the transaction history for a bill receivable. |
| TransactionHistoryAllLastUpdatedBy | The user who last updated the transaction history for a bill receivable. |
| TransactionHistoryAllMaturityDate | The maturity date of the transaction history for a bill receivable. |
| TransactionHistoryAllObjectVersionNumber | The number used to implement optimistic locking for the transaction history for a bill receivable. This number is incremented every time that the row is updated. The number is compared at the start and end of a transaction to detect whether another session has updated the row since it was queried. |
| TransactionHistoryAllOrgId | The identifier of the business unit associated with the transaction history for a bill receivable. |
| TransactionHistoryAllPostableFlag | The option that indicates whether the transaction history for a bill receivable is postable. |
| TransactionHistoryAllPostingControlId | The identifier of the transaction history for a bill receivable posting batch. Valid values are: -1, -2, and -4 if posted in previous releases, or -3 if not posted. |
| TransactionHistoryAllPrvTrxHistoryId | The Identifier of the previous history record that precedes the current transaction history for a bill receivable. |
| TransactionHistoryAllRequestId | The request identifier of the process that created or last updated the transaction history for a bill receivable. |
| TransactionHistoryAllStatus | The historical status of the transaction history for a bill receivable. |
| TransactionHistoryAllTransactionHistoryId | The identifier of the transaction history for a bill receivable. |
| TransactionHistoryAllTrxDate | The date when the transaction history for a bill receivable is created. |