Transaction References

The Transaction References view object contains information about transactions between assets where two or more dependent transactions are performed at one time.

Data Store Key : FscmTopModelAM.FinExtractAM.FaBiccExtractAM.TransactionReferenceExtractPVO

Primary Keys : TransactionReferenceTrxReferenceId

Initial Extract Date : TransactionReferenceCreationDate

Incremental Extract Date : TransactionReferenceLastUpdateDate

Attributes

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

Name	Description
TransactionReferenceBookTypeCode	Unique book identification name.
TransactionReferenceCreatedBy	The user who created the row in the Transaction References table.
TransactionReferenceCreationDate	The date when the transaction reference was created.
TransactionReferenceDestAmortizationStartDate	The amortization start date for the destination asset transaction.
TransactionReferenceDestAssetId	The unique identifier of the destination asset on which the transaction occurred.
TransactionReferenceDestEofyReserve	The depreciation reserve of the destination asset at the end of the previous fiscal year.
TransactionReferenceDestExpenseAmount	The amount entered for catch-up depreciation expense on the destination asset transaction.
TransactionReferenceDestTransactionHeaderId	Unique identifier of the destination transaction.
TransactionReferenceDestTransactionSubtype	More details about the type of transaction for the destination asset.
TransactionReferenceEventId	Unique identifier of the transaction event that's associated with this transaction reference for accounting purposes.
TransactionReferenceInvoiceTransactionId	Unique identifier of the invoice transaction.
TransactionReferenceLastUpdateDate	The date when the transaction reference was last updated.
TransactionReferenceLastUpdateLogin	The session login associated with the user who last updated the transaction reference.
TransactionReferenceLastUpdatedBy	The user who last updated the transaction reference.
TransactionReferenceMemberAssetId	Unique identification number of the member asset.
TransactionReferenceMemberTransactionHeaderId	Identifier of the member asset transaction that spawned this transaction for the group asset.
TransactionReferenceObjectVersionNumber	The number of times the transaction reference has been updated.
TransactionReferenceReserveTransferAmount	The reserve amount transferred between assets.
TransactionReferenceSrcAmortizationStartDate	The amortization start date for the source asset transaction.
TransactionReferenceSrcAssetId	The unique identifier of the source asset on which the transaction occurred.
TransactionReferenceSrcEofyReserve	The amount entered for the reserve of the prior fiscal year for the source asset.
TransactionReferenceSrcExpenseAmount	The amount entered for catch-up depreciation expense on the source asset transaction.
TransactionReferenceSrcTransactionHeaderId	Unique identifier of the source transaction.
TransactionReferenceSrcTransactionSubtype	More details about the type of transaction for the source asset.
TransactionReferenceTransactionType	Classification of transactions that occur between one or more assets.
TransactionReferenceTrxReferenceId	Unique identifier of the mass transaction.