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