JointVentureTransactions
Returns the transactions processed for joint ventures, including their accounting, ownership, and distribution details.
Columns
| Name | Type | SupportedFinders | Description |
| TransactionId [KEY] | Long | PrimaryKey | The unique identifier of the joint venture transaction. |
| HeaderId | Long | The unique identifier of the original transaction | |
| LineNumber | Long | The number of the line in the original transaction. | |
| Status | String | TransactionFinder | The status of the joint venture transaction. |
| TransactionSource | String | The source of the joint venture transaction, for example general ledger, subledger accounting, or joint venture. | |
| TransactionDate | Date | TransactionFinder | The date when the joint venture source transaction occurred. |
| AccountingDate | Date | TransactionFinder | The date used to determine the accounting period for the transaction. |
| AccountingPeriod | String | TransactionFinder | The name of the fiscal period that the joint venture transaction is associated with. |
| Ledger | String | TransactionFinder | The name of the ledger. |
| Source | String | TransactionFinder | The name of the application the transaction originated from, for example Payables or Cost Management. |
| JointVenture | String | TransactionFinder | The unique name of the joint venture. |
| JointVentureDescription | String | The description of the joint venture. | |
| OriginalOwnershipDefinition | String | TransactionFinder | The original ownership definition assigned to the joint venture transaction. |
| OwnershipDefinition | String | TransactionFinder | The name of the ownership definition assigned to the transaction, which can be overridden. |
| OriginalDirectBilledStakeholder | String | TransactionFinder | The name of the original direct billed stakeholder assigned to the joint venture transaction. |
| OriginalDirectBilledStakeholderDescription | String | The description of the original direct billed stakeholder. | |
| DirectBilledStakeholder | String | TransactionFinder | The name of the direct billed stakeholder assigned to the joint venture transaction. |
| DirectBilledStakeholderDescription | String | The description of the direct billed stakeholder. | |
| AssignmentRule | String | TransactionFinder | The name of the ownership definition assignment rule used to assign the ownership definition or direct billed stakeholder. |
| AssignmentRuleDescription | String | The description of the ownership definition assignment rule. | |
| Agreement | String | TransactionFinder | The name of the carried interest agreement associated with the joint venture transaction. |
| AgreementDescription | String | The description of the carried interest agreement associated with the joint venture transaction. | |
| Method | String | TransactionFinder | The unique name of the overhead method. |
| MethodDescription | String | The description of the overhead method. | |
| BasisSource | String | TransactionFinder | The source of the overhead calculation amount. |
| DistributionType | String | TransactionFinder | Determines whether the distributed transaction is billable or payable to the stakeholder when processed through invoicing and internal transfer journals. |
| Notes | String | Additional details about the joint venture source transaction. | |
| DistributionOnlyFlag | Bool | Indicates whether the transaction is for distribution only, not for invoicing. | |
| Account | String | The account assigned to the joint venture transaction. | |
| AccountSegment1 | String | The segment 1 value of the account assigned to the joint venture transaction. | |
| AccountSegment2 | String | The segment 2 value of the account assigned to the joint venture transaction. | |
| AccountSegment3 | String | The segment 3 value of the account assigned to the joint venture transaction. | |
| AccountSegment4 | String | The segment 4 value of the account assigned to the joint venture transaction. | |
| AccountSegment5 | String | The segment 5 value of the account assigned to the joint venture transaction. | |
| AccountSegment6 | String | The segment 6 value of the account assigned to the joint venture transaction. | |
| AccountSegment7 | String | The segment 7 value of the account assigned to the joint venture transaction. | |
| AccountSegment8 | String | The segment 8 value of the account assigned to the joint venture transaction. | |
| AccountSegment9 | String | The segment 9 value of the account assigned to the joint venture transaction. | |
| AccountSegment10 | String | The segment 10 value of the account assigned to the joint venture transaction. | |
| AccountSegment11 | String | The segment 11 value of the account assigned to the joint venture transaction. | |
| AccountSegment12 | String | The segment 12 value of the account assigned to the joint venture transaction. | |
| AccountSegment13 | String | The segment 13 value of the account assigned to the joint venture transaction. | |
| AccountSegment14 | String | The segment 14 value of the account assigned to the joint venture transaction. | |
| AccountSegment15 | String | The segment 15 value of the account assigned to the joint venture transaction. | |
| AccountSegment16 | String | The segment 16 value of the account assigned to the joint venture transaction. | |
| AccountSegment17 | String | The segment 17 value of the account assigned to the joint venture transaction. | |
| AccountSegment18 | String | The segment 18 value of the account assigned to the joint venture transaction. | |
| AccountSegment19 | String | The segment 19 value of the account assigned to the joint venture transaction. | |
| AccountSegment20 | String | The segment 20 value of the account assigned to the joint venture transaction. | |
| AccountSegment21 | String | The segment 21 value of the account assigned to the joint venture transaction. | |
| AccountSegment22 | String | The segment 22 value of the account assigned to the joint venture transaction. | |
| AccountSegment23 | String | The segment 23 value of the account assigned to the joint venture transaction. | |
| AccountSegment24 | String | The segment 24 value of the account assigned to the joint venture transaction. | |
| AccountSegment25 | String | The segment 25 value of the account assigned to the joint venture transaction. | |
| AccountSegment26 | String | The segment 26 value of the account assigned to the joint venture transaction. | |
| AccountSegment27 | String | The segment 27 value of the account assigned to the joint venture transaction. | |
| AccountSegment28 | String | The segment 28 value of the account assigned to the joint venture transaction. | |
| AccountSegment29 | String | The segment 29 value of the account assigned to the joint venture transaction. | |
| AccountSegment30 | String | The segment 30 value of the account assigned to the joint venture transaction. | |
| NetAccounted | Decimal | The net transaction amount in the accounting currency. | |
| AccountedDebit | Decimal | The transaction debit amount in accounting currency. | |
| AccountedCredit | Decimal | The transaction credit amount in accounting currency. | |
| AccountingCurrency | String | The currency of the transaction amount. | |
| NetEntered | Decimal | The net transaction amount in the entered currency. | |
| EnteredDebit | Decimal | The transaction debit amount in the entered currency. | |
| EnteredCredit | Decimal | The transaction credit amount in the entered currency. | |
| EnteredCurrency | String | The currency code entered on the original transaction. | |
| TransactionDescription | String | TransactionFinder | The description to include on the transactions created through invoice or internal transfer journal processing. |
| AccountingClassCode | String | The accounting classification of the joint venture transaction. | |
| Project | String | TransactionFinder | The name of the project. |
| ProjectNumber | String | TransactionFinder | The unique identifier of the project. |
| Task | String | TransactionFinder | The name of the project task representing a subdivision of work. |
| TaskNumber | String | TransactionFinder | The unique number of the project task. |
| ExpenditureType | String | TransactionFinder | The name identifying the expenditure classification. |
| ExpenditureTypeDescription | String | The description of the expenditure type. | |
| ExpenditureOrganization | String | TransactionFinder | The name of the expenditure organization in Project Costing that's associated with the subledger accounting entry for the joint venture transaction. |
| ExpenditureBusinessUnit | String | TransactionFinder | The name of the expenditure business unit in Project Costing that's associated with the subledger accounting entry for the joint venture transaction. |
| ExpenditureItemDate | Date | TransactionFinder | The date of the expenditure in Project Costing that's associated with the subledger accounting entry for the joint venture transaction. |
| 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 | TransactionFinder | 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 | TransactionFinder | The date and time when the joint venture transaction was last updated. |
| TransactionType | String | TransactionFinder | The type of transaction to be processed, such as expense, revenue, asset, overhead, and so forth. |
| 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. | |
| SourceReferenceNumber | String | The reference number for the source transaction, such as supplier invoice number from Payables. | |
| EventTypeCode | String | The event type of the subledger transaction. | |
| Finder | String | A named finder reference used to filter or locate specific joint venture transactions when querying. | |
| SearchAllText | String | TransactionFinder | A search value used to identify joint venture transactions that contain the specified text in any of their string attributes. |
| SysEffectiveDate | Date | TransactionFinder | The effective date used to determine the active joint venture transactions at the time of the query. |
| EffectiveDate | Date | This query parameter is used to fetch resources which are effective dated as of the specified start date. |