JointVentureGeneratedTransactions
Returns the transactions generated by joint venture processing, including source, ownership, overhead, and project details, in Oracle Financials.
Columns
| Name | Type | SupportedFinders | Description |
| TransactionId [KEY] | Long | PrimaryKey | The unique identifier of the joint venture transaction. |
| HeaderId | Long | The unique identifier for the joint venture source transaction header. | |
| LineNumber | Long | The accounting line for the joint venture source transaction. | |
| Status | String | TransactionFinder | The status of the joint venture transaction. |
| TransactionDate | Date | The date when the transaction occurred, which may be different from the joint venture source transaction date. | |
| AccountingPeriod | String | TransactionFinder | The name of the fiscal period that the source transaction is associated with. |
| TransactionType | String | TransactionFinder | The type of transaction to be processed, such as expense, revenue, asset, overhead, and so forth. |
| DistributionType | String | TransactionFinder | Determines whether the distributed transaction is billable or payable to the stakeholder when processed through invoicing and internal transfer journals. |
| DistributionOnlyFlag | Bool | Indicates whether the transaction is for distribution only, not for invoicing. | |
| JointVenture | String | TransactionFinder | The unique name of the joint venture. |
| JointVentureDescription | String | TransactionFinder | The description of the joint venture. |
| TransactionDescription | String | TransactionFinder | The description to include on the transactions created through invoice or internal transfer journal processing. |
| Ledger | String | TransactionFinder | The name of the ledger. |
| OwnershipDefinition | String | TransactionFinder | The name of the ownership definition assigned to the transaction, which can be overridden. |
| OriginalOwnershipDefinition | String | TransactionFinder | The original ownership definition assigned to the joint venture transaction. |
| DirectBilledStakeholder | String | TransactionFinder | The name of the direct billed stakeholder assigned to the joint venture transaction. |
| DirectBilledStakeholderDescription | String | TransactionFinder | The description of the direct billed stakeholder. |
| OriginalDirectBilledStakeholder | String | TransactionFinder | The name of the original direct billed stakeholder assigned to the joint venture transaction. |
| OriginalDirectBilledStakeholderDescription | String | TransactionFinder | The description of the original direct billed stakeholder. |
| Debit | Decimal | The debit amount of the joint venture source transaction. | |
| Credit | Decimal | The credit amount of the joint venture source transaction. | |
| Currency | String | The currency of the transaction amount. | |
| PartnerOffsetAccount | String | The combination of account segment values assigned to a partner's line in the receivables invoice. | |
| Method | String | TransactionFinder | The unique name of the overhead method. |
| MethodDescription | String | TransactionFinder | The description of the overhead method. |
| MethodType | String | The method type used to determine how the overhead amount is calculated. | |
| BasisSource | String | TransactionFinder | The source of the overhead calculation amount. |
| PeriodBasis | String | The value that determines how the period basis is derived for the overhead calculation. Valid values are: Period, Year to period, and Inception to period. | |
| Agreement | String | TransactionFinder | The name of the carried interest agreement associated with the joint venture transaction. |
| AgreementDescription | String | TransactionFinder | The description of the carried interest agreement associated with the joint venture transaction. |
| Project | String | The name of the project. | |
| ProjectNumber | String | The unique identifier of the project. | |
| Task | String | The name of the project task representing a subdivision of work. | |
| TaskNumber | String | The unique number of the project task. | |
| ExpenditureType | String | The name identifying the expenditure classification. | |
| ExpenditureTypeDescription | String | The description of the expenditure type. | |
| 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. | |
| CreatedBy | String | TransactionFinder | The user who created the joint venture transaction. |
| CreationDate | Datetime | The date and time when the joint venture transaction was created. | |
| LastUpdatedBy | String | TransactionFinder | The user who last updated the joint venture transaction. |
| LastUpdateDate | Datetime | The date and time when the joint venture transaction was last updated. | |
| Notes | String | Additional details about the joint venture source transaction. | |
| AccountingDate | Date | The date used to determine the accounting period for the transaction. | |
| TransactionSource | String | TransactionFinder | The type of the joint venture source transaction. |
| CreatedByJointVentureFlag | Bool | TransactionFinder | A flag indicating whether the source of the transaction is a joint venture invoice or journal created by joint venture processing. The source of the transaction can also be payments or receipts against an invoice created by joint venture processing. |
| MethodStartDate | Date | The start date of the overhead method effective date range. | |
| MethodEndDate | Date | The end date of the overhead method effective date range. | |
| BusinessUnit | String | The name of the business unit associated with the joint venture. | |
| AccountDescription | String | The description of the account assigned to the joint venture transaction. | |
| Finder | String | A named finder reference used to filter or locate specific joint venture generated transactions when querying. | |
| SearchAllText | String | TransactionFinder | A search value used to identify joint venture generated transactions that contain the specified text in any of their string attributes. |