JointVentureGeneratedDistributions
Returns the distributions generated for joint venture transactions, including the ownership amounts allocated to each stakeholder.
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. |
| DistributionType | String | The type of transaction the distribution represents, such as expense, revenue, and so forth. | |
| LineType | String | DistributionFinder | The type of the distribution line for billing adjustments. |
| LineNumber | Int | The line number of a joint venture distribution and any associated lines created for billing adjustments and partner contribution draws. | |
| JointVenture | String | DistributionFinder | The name of the joint venture of the source transaction. |
| JointVentureDescription | String | The description of the joint venture. | |
| BusinessUnit | String | DistributionFinder | The name of the business unit associated with the joint venture. |
| JointVentureClassification | String | The classification of the joint venture associated with the distribution. | |
| 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. | |
| OriginalOwnershipDefinitionStartDate | Date | Effective start date of the ownership definition that was used to distribute the joint venture transaction. | |
| OriginalOwnershipDefinitionEndDate | Date | Effective end date of the ownership definition that was used to distribute the joint venture transaction. | |
| Stakeholder | String | DistributionFinder | The name of the distribution stakeholder. |
| CostCenterSegmentValue | String | The cost center segment value associated with the distributed stakeholder. | |
| Party | String | The name of the party associated with the stakeholder on the joint venture distribution. | |
| InvoicingPartner | String | DistributionFinder | The name of the invoicing partner associated with the distribution stakeholder. |
| Customer | String | The name of the customer associated with the invoicing partner. | |
| Supplier | String | The name of the supplier associated with invoicing partner. | |
| OriginalStakeholder | String | The name of the stakeholder that was originally associated with the joint venture distribution. | |
| ReassignedStakeholder | String | The name of the stakeholder that's reassigned to the joint venture distribution. | |
| PercentageOfInterest | 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. |
| SplitLinesExistFlag | Bool | Indicates that split lines exist for the joint venture 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 | |
| TransactionDate | Date | Indicates the default effective date for journal entries or the transaction date for subledger entries. | |
| TransactionId | Long | DistributionFinder | The unique identifier for the joint venture transaction that the distribution was created from. |
| DirectBilledStakeholder | String | DistributionFinder | The name of the direct billed stakeholder assigned to the joint venture transaction that the distribution was created from. |
| OriginalDirectBilledStakeholder | String | DistributionFinder | The name of the original direct billed stakeholder assigned to the joint venture transaction that the distribution was created from. |
| OriginalOwnershipDefinition | String | The original ownership definition assigned to the joint venture transaction that the distribution was created from. | |
| AccountingPeriod | String | DistributionFinder | The name of the fiscal period that the source transaction is associated with. |
| Ledger | String | DistributionFinder | The name of the ledger. |
| LedgerCategoryCode | String | The code that identifies the ledger type, such as primary, secondary, and so on. | |
| TransactionType | String | DistributionFinder | The type of the joint venture source transaction. |
| Method | String | DistributionFinder | The unique name of the overhead method. |
| MethodDescription | String | DistributionFinder | The description of the overhead method. |
| MethodType | String | The method type used to determine how the overhead amount is calculated. | |
| BasisSource | String | 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. | |
| TransactionDescription | String | A description that's passed into the joint venture invoice for the joint venture source transaction. | |
| PartnerOffsetAccount | String | The combination of account segment values assigned to a partner's line in the receivables invoice. | |
| TargetTransactionHeaderAccount | String | The combination of segment values for the receivable or liability account used when posting a receivables or payables invoice. | |
| TargetTransactionId | 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. | |
| TrxNumber | String | DistributionFinder | A unique value that identifies the invoice generated for the joint venture distribution. |
| TrxDate | Date | The date of the invoice transaction generated for the joint venture distribution. | |
| InvoiceTransactionType | String | Indicates the type of invoice transaction generated for the joint venture distribution, such as receivable invoice and credit memo. | |
| DistributedDebit | Decimal | The distributed debit amount for the stakeholder in accounting currency. | |
| DistributedCredit | Decimal | The distributed credit amount for the stakeholder in accounting currency. | |
| OriginalDistributedDebit | 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. | |
| OriginalDistributedCredit | 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. | |
| 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. | |
| TransactionDebit | Decimal | The debit amount of the joint venture source transaction. | |
| TransactionCredit | Decimal | The credit amount of the joint venture source transaction. | |
| TransactionCurrency | String | The currency of the transaction amount. | |
| ContributionId | Long | The unique identifier of the partner contribution assigned to the joint venture distribution and drawn from. | |
| ContributionAmount | Decimal | The partner contribution amount that's associated with a distribution. | |
| ContributionRequest | String | The name of the partner contribution request. | |
| Agreement | String | DistributionFinder | The name of the agreement of the carried interest distribution. |
| AgreementDescription | String | DistributionFinder | The description of the agreement of the carried interest distribution. |
| ProjectCostingStatus | String | 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 | DistributionFinder | The description of the expenditure type. |
| CreatedBy | String | DistributionFinder | The user who created the joint venture distribution. |
| CreationDate | Datetime | The date and time when the joint venture distribution was created. | |
| LastUpdatedBy | String | DistributionFinder | The user who last updated the joint venture distribution. |
| LastUpdateDate | Datetime | The date and time when the joint venture distribution 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. | |
| CreatedByJointVentureFlag | Bool | DistributionFinder | 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. |
| StakeholderReportingLedger | String | DistributionFinder | The name of the ledger which will be used for stakeholder reporting. |
| StakeholderReportingHeaderId | Long | The unique identifier of the stakeholder reporting journal created for the distribution. | |
| StakeholderReportingStatus | String | DistributionFinder | The status of the accounting for the stakeholder reporting distribution. |
| StakeholderReportingDate | Date | The date the stakeholder reporting journal was created. | |
| MethodStartDate | Date | The start date of the overhead method effective date range. | |
| MethodEndDate | Date | The end date of the overhead method effective date range. | |
| CostCenterDescription | String | The description of the cost center segment value associated with the joint venture stakeholder. | |
| AccountDescription | String | The description of the account assigned to the joint venture transaction. | |
| Account | String | The combination of the values of the account segments assigned to the transaction. | |
| Finder | String | A named finder reference used to filter or locate specific joint venture generated distributions when querying. | |
| SearchAllText | String | DistributionFinder | A search value used to identify joint venture generated distributions that contain the specified text in any of their string attributes. |