JointVentureDistributions
Returns the stakeholder distributions generated from joint venture transactions, including account, ownership, and amount details, in Oracle Financials.
Columns
| Name | Type | SupportedFinders | Description |
| DistributionId [KEY] | Long | PrimaryKey | The unique identifier of the joint venture distribution. |
| Status | String | DistributionFinder | The status of the distribution of the joint venture transaction. |
| LineType | String | DistributionFinder | The type of the distribution line for billing adjustments. |
| DistributionLineNumber | Int | The line number of a joint venture distribution and any associated lines created for billing adjustments and partner contribution draws. | |
| TransactionType | String | The type of transaction the distribution represents, such as expense, revenue, and so forth. | |
| Source | String | The name of the application the transaction originated from, for example Payables or Cost Management. | |
| TransactionSource | String | The source of the joint venture transaction, for example general ledger, subledger accounting, or joint venture. | |
| TransactionId | Long | The unique identifier of the joint venture transaction. | |
| TransactionDate | Date | The date when the joint venture source transaction occurred. | |
| AccountingDate | Date | The date used to determine the accounting period for the transaction. | |
| AccountingPeriod | String | DistributionFinder | The name of the fiscal period that the joint venture transaction is associated with. |
| Ledger | String | The name of the ledger. | |
| JointVenture | String | DistributionFinder | The unique name of the joint venture. |
| JointVentureDescription | String | The description of the joint venture. | |
| BusinessUnit | String | The name of the business unit associated with the joint venture. | |
| LegalEntity | String | The name of the legal entity associated with the joint venture. | |
| OriginalOwnershipDefinition | String | The original ownership definition assigned to the joint venture transaction that the distribution was created from. | |
| OwnershipDefinition | String | DistributionFinder | The name of the ownership definition used to process the distribution. |
| OwnershipDefinitionStartDate | Date | The start date of the effective date range of the ownership definition. | |
| OwnershipDefinitionEndDate | Date | The end date of the effective date range of the ownership definition. | |
| OriginalStakeholder | String | The name of the stakeholder that was originally associated with the joint venture distribution. | |
| Stakeholder | String | DistributionFinder | The name of the distribution stakeholder. |
| CostCenter | String | The cost center segment value associated with the distribution stakeholder. | |
| DirectBilledStakeholder | String | The name of the direct billed stakeholder assigned to the joint venture transaction that the distribution was created from. | |
| OwnershipPercentage | Decimal | The percentage of ownership a stakeholder has in a joint venture transaction. | |
| RoundAmountFlag | Bool | An indicator that rounding was applied to the distribution amount. | |
| DistributionOnlyFlag | Bool | DistributionFinder | Indicates whether the joint venture stakeholder is only participating in the transaction distribution and not being invoiced. |
| 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. | |
| 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. | |
| TransactionDescription | String | The description to include on the transactions created through invoice or internal transfer journal processing. | |
| AssignmentRule | String | The name of the ownership definition assignment rule used to assign the ownership definition or direct billed stakeholder. | |
| Agreement | String | The name of the carried interest agreement associated with the joint venture transaction. | |
| Method | String | The unique name of the overhead method. | |
| BasisSource | String | The source of the overhead calculation amount. | |
| Notes | String | Additional details about the joint venture source transaction. | |
| NetOriginalDistributedAccounted | Decimal | The original net amount of the joint venture distribution in the accounted currency. This is the amount prior to being split by partner contributions. | |
| OriginalDistributedAccountedDebit | Decimal | The original debit amount of the joint venture distribution in the accounting currency. This is the amount prior to being split between partner contributions. | |
| OriginalDistributedAccountedCredit | Decimal | The original credit amount of the joint venture distribution in the accounting currency. This is the amount prior to being split between partner contributions. | |
| NetDistributedAccounted | Decimal | The net distributed amount for the stakeholder in accounted currency. | |
| DistributedAccountedDebit | Decimal | The distributed debit amount for the stakeholder in accounting currency. | |
| DistributedAccountedCredit | Decimal | The distributed credit amount for the stakeholder in accounting currency. | |
| AccountedCurrencyCode | String | The currency of the transaction amount. | |
| NetOriginalDistributedEntered | Decimal | The original net amount of the joint venture distribution in the entered currency. This is the amount prior to being split by partner contributions. | |
| OriginalDistributedEnteredDebit | Decimal | The original debit amount of the joint venture distribution in the entered currency. This is the amount prior to being split between partner contributions. | |
| OriginalDistributedEnteredCredit | Decimal | The original credit amount of the joint venture distribution in the entered currency. This is the amount prior to being split between partner contributions. | |
| NetDistributedEntered | Decimal | The net distributed amount for the stakeholder in entered currency. | |
| DistributedEnteredDebit | Decimal | The distributed debit amount for the stakeholder in the entered currency. | |
| DistributedEnteredCredit | Decimal | The distributed credit amount for the stakeholder in the entered currency. | |
| EnteredCurrencyCode | String | The currency code entered on the original transaction. | |
| InvoiceNumber | String | A unique value that identifies the invoice generated for the joint venture distribution. | |
| InvoiceDate | Date | The date of the invoice transaction generated for the joint venture distribution. | |
| InvoiceType | String | Indicates the type of invoice transaction generated for the joint venture distribution, such as receivable invoice and credit memo. | |
| JournalNumber | Long | The unique identifier for the external transaction created for joint venture distributions, for example accounts receivable invoice, credit memo, accounts payable invoice, or journal entry. | |
| ContributionId | Long | The unique identifier of the partner contribution assigned to the joint venture distribution and drawn from. | |
| ProjectCostingStatus | String | DistributionFinder | The status of the export to Project Costing. |
| Project | String | DistributionFinder | The name of the project. |
| ProjectNumber | String | DistributionFinder | The unique identifier of the project. |
| Task | String | DistributionFinder | The name of the project task representing a subdivision of work. |
| TaskNumber | String | DistributionFinder | The unique number of the project task. |
| ExpenditureType | String | DistributionFinder | The name identifying the expenditure classification. |
| ExpenditureTypeDescription | String | The description of the expenditure type. | |
| ExpenditureOrganization | String | The name of the expenditure organization in Project Costing that's associated with the subledger accounting entry for the joint venture transaction. | |
| ExpenditureBusinessUnit | String | 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 | The date of the expenditure in Project Costing that's associated with the subledger accounting entry for the joint venture transaction. | |
| CreatedByJointVentureFlag | Bool | 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. | |
| StakeholderReportingHeaderId | Long | The unique identifier of the stakeholder reporting journal created for the distribution. | |
| StakeholderReportingLedger | String | The name of the ledger which will be used for stakeholder reporting. | |
| StakeholderReportingDate | Date | The date the stakeholder reporting journal was created. | |
| StakeholderReportingStatus | String | The status of the accounting for the stakeholder reporting distribution. | |
| ChangeReason | String | The reason the joint venture distribution was canceled. | |
| ChangeReasonDetails | String | Additional text to describe the reason the joint venture distribution line was canceled | |
| CreatedBy | String | The user who created the joint venture distribution. | |
| CreationDate | Datetime | The date and time when the joint venture distribution was created. | |
| LastUpdatedBy | String | The user who last updated the joint venture distribution. | |
| LastUpdateDate | Datetime | The date and time when the joint venture distribution was last updated. | |
| 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. | |
| AccountingClassCode | String | The accounting classification of the joint venture transaction. | |
| Finder | String | A named finder reference used to filter or locate specific joint venture distributions when querying. | |
| SearchAllText | String | DistributionFinder | A search value used to identify joint venture distributions that contain the specified text in any of their string attributes. |
| SysEffectiveDate | String | DistributionFinder | The effective date used to determine the active joint venture distributions at the time of the query. |