ODBC Driver for Oracle Fusion Cloud Financials

Build 26.0.9770

JointVentureGeneratedTransactionsTransactionChanges

Returns the change history records for joint venture generated transactions, capturing updates to attributes such as stakeholder, ownership definition, and status.

Columns

Name Type SupportedFinders Description
JointVentureGeneratedTransactionstransactionId [KEY] Long The unique identifier of the joint venture transaction.
TransactionChangeId [KEY] Long The unique identifier of the joint venture transaction change.
ChangeReason String The reason for the manual change to the joint venture transaction.
ChangeReasonDetails String Additional text to describe the reason the joint venture transaction was manually changed.
BeforeTransactionDate Date The previous transaction date assigned to the transaction.
AfterTransactionDate Date The new transaction date assigned to the transaction.
BeforeStatus String The previous status assigned to the transaction.
AfterStatus String The new status assigned to the transaction.
BeforeOwnershipDefinition String The previous ownership definition assigned to the transaction.
AfterOwnershipDefinition String The new ownership definition assigned to the transaction.
BeforeStakeholder String The previous name of the direct billed stakeholder assigned to the transaction.
BeforeStakeholderDescription String The previous description of the direct billed stakeholder assigned to the transaction.
AfterStakeholder String The new name of the direct billed stakeholder assigned to the transaction.
AfterStakeholderDescription String The new description of the direct billed stakeholder assigned to the transaction.
CreationDate Datetime The date and time when the joint venture transaction change was created.
CreatedBy String TransactionFinder The user who created the joint venture transaction change.
BeforeAssignmentRule String The previous ownership definition assignment rule assigned to the transaction.
AfterAssignmentRule String The new ownership definition assignment rule assigned to the transaction.
BeforeDistributionOnlyFlag Bool The previous distribution only value assigned to the transaction.
AfterDistributionOnlyFlag Bool The new distribution only value assigned to the transaction.
BeforeProject String The name of the previous project assigned to the transaction.
BeforeProjectNumber String The previous project number assigned to the transaction.
AfterProject String The name of the new project assigned to the transaction.
AfterProjectNumber String The new project number assigned to the transaction.
BeforeTask String The name of the previous task assigned to the transaction.
BeforeTaskNumber String The previous task number assigned to the transaction.
AfterTask String The name of the new task assigned to the transaction.
AfterTaskNumber String The new task number assigned to the transaction.
BeforeExpenditureType String The previous expenditure type assigned to the transaction.
BeforeExpenditureTypeDescription String The description of the previous expenditure type assigned to the transaction.
AfterExpenditureType String The new expenditure type assigned to the transaction.
AfterExpenditureTypeDescription String The description of the new expenditure type assigned to the transaction.
BeforeExpenditureItemDate Date The previous expenditure item date assigned to the transaction.
AfterExpenditureItemDate Date The new expenditure item date assigned to the transaction.
BeforeExpenditureOrganization String The previous expenditure organization assigned to the transaction.
AfterExpenditureOganization String The new expenditure organization assigned to the transaction.
BeforeExpenditureBusinessUnit String The previous expenditure business unit assigned to the transaction.
AfterExpenditureBusinessUnit String The new expenditure business unit assigned to the transaction.
SysEffectiveDate Date Effective date of the query.
AccountingPeriod String TransactionFinder The name of the accounting period associated with the joint venture generated transaction.
Agreement String TransactionFinder The name of the carried interest agreement associated with the joint venture generated transaction.
AgreementDescription String TransactionFinder The description of the carried interest agreement associated with the joint venture generated transaction.
BasisSource String TransactionFinder The source of the amount used as the basis for the overhead calculation.
CreatedByJointVentureFlag String TransactionFinder Indicates whether the transaction was created by joint venture processing.
DirectBilledStakeholder String TransactionFinder The name of the direct billed stakeholder assigned to the joint venture generated transaction.
DirectBilledStakeholderDescription String TransactionFinder The description of the direct billed stakeholder assigned to the joint venture generated transaction.
DistributionType String TransactionFinder The type of transaction that the distribution represents, such as expense or revenue.
Finder String A named finder reference used to filter or locate specific joint venture generated transaction changes when querying.
JointVenture String TransactionFinder The name of the joint venture associated with the generated transaction.
JointVentureDescription String TransactionFinder The description of the joint venture associated with the generated transaction.
LastUpdatedBy String TransactionFinder The user who last updated the joint venture generated transaction.
Ledger String TransactionFinder The name of the ledger associated with the joint venture generated transaction.
Method String TransactionFinder The unique name of the overhead method applied to the joint venture generated transaction.
MethodDescription String TransactionFinder The description of the overhead method applied to the joint venture generated transaction.
OriginalDirectBilledStakeholder String TransactionFinder The name of the original direct billed stakeholder assigned to the joint venture generated transaction.
OriginalDirectBilledStakeholderDescription String TransactionFinder The description of the original direct billed stakeholder assigned to the joint venture generated transaction.
OriginalOwnershipDefinition String TransactionFinder The name of the original ownership definition used to distribute the joint venture generated transaction.
OwnershipDefinition String TransactionFinder The name of the ownership definition used to distribute the joint venture generated transaction.
SearchAllText String TransactionFinder A search value used to identify joint venture generated transaction changes that contain the specified text in any of their string attributes.
Status String TransactionFinder The status of the joint venture generated transaction.
TransactionDescription String TransactionFinder The description of the joint venture generated transaction.
TransactionId Long PrimaryKey The unique identifier of the joint venture generated transaction.
TransactionSource String TransactionFinder The source of the joint venture generated transaction.
TransactionType String TransactionFinder The type of the joint venture generated transaction.

Copyright (c) 2026 CData Software, Inc. - All rights reserved.
Build 26.0.9770