JV_DISTRIBUTIONS
This table contains distribution records generated for each stakeholder from the processing of joint venture transactions.
Details
-
Schema: FUSION
-
Object owner: JV
-
Object type: TABLE
-
Tablespace: Default
Primary Key
| Name | Columns |
|---|---|
|
JV_DISTRIBUTIONS_PK |
DISTRIBUTION_ID |
Columns
| Name | Datatype | Length | Precision | Not-null | Comments | Status |
|---|---|---|---|---|---|---|
| DISTRIBUTION_ID | NUMBER | 18 | Yes | Unique identifier for a distribution record generated from the processing of a joint venture transaction. | ||
| OBJECT_VERSION_NUMBER | NUMBER | 9 | Yes | Used to implement optimistic locking. This number is incremented every time that the row is updated. The number is compared at the start and end of a transaction to detect whether another session has updated the row since it was queried. | ||
| TRANSACTION_ID | NUMBER | 18 | Yes | Unique identifier for the joint venture transaction that the distribution was created from. | ||
| TRANSACTION_DATE | DATE | Indicates the journal entry default effective date for journal entries or the transaction date for subledger entries. | ||||
| OWNERSHIP_PERCENTAGE_ID | NUMBER | 18 | Unique identifier for the ownership percentage definition. | |||
| STAKEHOLDER_ID | NUMBER | 18 | Yes | Unique identifier of the joint venture stakeholder that is associated with the distribution of the joint venture transaction. | ||
| DISTRIBUTED_DEBIT_AMOUNT | NUMBER | The distribution debit amount for the stakeholder in the accounting currency. | ||||
| DISTRIBUTED_CREDIT_AMOUNT | NUMBER | The distribution credit amount for the stakeholder in the accounting currency. | ||||
| PERCENTAGE_OF_INTEREST | NUMBER | The percent of ownership a stakeholder has in a joint venture transaction. | ||||
| DISTRIBUTION_STATUS_CODE | VARCHAR2 | 30 | The status code to identify the state of the distribution of the joint venture transaction. It is based on the ORA_JV_DISTRIBUTION_STATUS lookup codes like Available to Process, Process Complete, and so forth. | |||
| DISTRIBUTION_TYPE_CODE | VARCHAR2 | 30 | Indicates the type of transaction the distribution represents, such as Expense, Revenue, and so forth. | |||
| CURRENCY_CODE | VARCHAR2 | 15 | The currency code of the source joint venture transaction. | |||
| ROUND_AMOUNT_FLAG | VARCHAR2 | 1 | A flag to identify if rounding was applied to the distribution amount. | |||
| TARGET_TRANSACTION_ID | NUMBER | 18 | Identifies the transaction ID of the AR invoice, AP invoice or journal entry created for the joint venture distribution. | |||
| CHILD_REQUEST_ID | NUMBER | 18 | Identifies the request ID of the child job that was used to process the distribution record. | |||
| JOINT_VENTURE_ID | NUMBER | 18 | The unique identifier of the joint venture assigned to the distribution. | |||
| DISTRIBUTION_ONLY_FLAG | VARCHAR2 | 1 | Indicates whether the joint venture stakeholder is only participating in the distribution and not being invoiced. | |||
| ERROR_GROUP_ID | NUMBER | 18 | Indicates the error group number for a set of distribution IDs encountered while creating invoices. | |||
| TRX_NUMBER | VARCHAR2 | 150 | Unique number of the invoice transaction generated for the distribution. | |||
| TRX_DATE | DATE | The date of the invoice transaction generated for the distribution. | ||||
| ADVANCE_PAYMENT_ID | NUMBER | 18 | Unique identifier for the advance payment this distribution record was assigned and drawn from. | Obsolete | ||
| DISTRIBUTION_LINE_NUMBER | NUMBER | 9 | Yes | Line number used when a distribution record is split between multiple advance payments, or an advance payment and an AR invoice. | ||
| ORIG_DISTRIBUTED_AMOUNT_DEBIT | NUMBER | The original debit amount of the joint venture distribution in the accounting currency. This is the amount prior to being split by partner contributions. | ||||
| ORIG_DISTRIBUTED_AMOUNT_CREDIT | NUMBER | The original credit amount of the joint venture distribution in the accounting currency. This is the amount prior to being split by partner contributions. | ||||
| DISTRIBUTION_LINE_TYPE_CODE | VARCHAR2 | 30 | Yes | The code that indicates the type of distribution line. It is based on ORA_JV_DISTRIBUTION_LINE_CODE lookup codes such as ORA_JV_CANCEL, ORA_JV_REVERSE, and so forth. | ||
| ORIGINAL_DISTRIBUTION_ID | NUMBER | 18 | The unique identifier of the original distribution line. This is populated in a reversed distribution line, a distribution line created to reassign a stakeholder, and a distribution line created due to a partner contribution split. | |||
| CHANGE_REASON_CODE | VARCHAR2 | 30 | The code that indicates the reason for canceling the distribution line. It is based on ORA_JV_CHANGE_REASON_CODE lookup codes such as ORA_JV_INCORRECT_OPD_PERCENT, ORA_JV_INCORRECT_INV_INFO, and so forth. | |||
| CHANGE_REASON_ADDITIONAL_TEXT | VARCHAR2 | 240 | Additional information describing the reason for canceling the distribution line. | |||
| CONTRIBUTION_ID | NUMBER | 18 | Unique identifier for the partner contribution this distribution record was assigned and drawn from. | |||
| CONTRIBUTION_REVERSAL_FLAG | VARCHAR2 | 1 | Yes | Indicates whether the distribution amount was reversed and needs to be added back into the partner contribution open amount. | ||
| PROJECT_COSTING_STATUS_CODE | VARCHAR2 | 30 | Yes | Identifies the export status of the joint venture offset accounting entries to the Project Costing system. | ||
| SOURCE_DISTRIBUTION_NUM | NUMBER | 38 | Unique identifier for the GL distribution associated with the joint venture distribution invoice or journal entry. This value is used to retrieve the general ledger account identifier. | |||
| TARGET_TRANSACTION_HEADER_CCID | NUMBER | 18 | Account combination identifier for the offset account to the partner account used when creating receivables invoices, payables invoices, and internal transfers. | |||
| PARTNER_ACCOUNT_CCID | NUMBER | 18 | Account combination identifier for the partner account used when creating receivables invoices, payables invoices, and internal transfers. | |||
| OWNERSHIP_START_DATE | DATE | Effective start date of the ownership definition that was used to distribute a joint venture transaction. | ||||
| OWNERSHIP_END_DATE | DATE | Effective end date of the ownership definition that was used to distribute a joint venture transaction. | ||||
| DISTRIBUTED_ENTERED_CREDIT | NUMBER | The distributed credit amount for the stakeholder in the entered currency. | ||||
| DISTRIBUTED_ENTERED_DEBIT | NUMBER | The distributed debit amount for the stakeholder in the entered currency. | ||||
| ENTERED_CURRENCY_CODE | VARCHAR2 | 15 | The currency code entered on the original transaction. | |||
| ORIG_DISTRIBUTED_ENTERED_DR | NUMBER | The original debit amount of the joint venture distribution in the entered currency. This is the amount prior to being split by partner contributions. | ||||
| ORIG_DISTRIBUTED_ENTERED_CR | NUMBER | The original credit amount of the joint venture distribution in the entered currency. This is the amount prior to being split by partner contributions. | ||||
| REQUEST_ID | NUMBER | 18 | Enterprise Service Scheduler: indicates the request ID of the job that created or last updated the row. | |||
| JOB_DEFINITION_NAME | VARCHAR2 | 100 | Enterprise Service Scheduler: indicates the name of the job that created or last updated the row. | |||
| JOB_DEFINITION_PACKAGE | VARCHAR2 | 900 | Enterprise Service Scheduler: indicates the package name of the job that created or last updated the row. | |||
| PARTNER_CONTRIBUTION_ID | NUMBER | 18 | Unique identifier of the partner contribution created from a partner contribution request. The system populates this ID when the open distribution amount is selected to calculate the partner contribution for a stakeholder. | |||
| ORIGINAL_STAKEHOLDER_ID | NUMBER | 18 | The unique identifier for the stakeholder that was originally associated with the distribution line. | |||
| CREATED_BY | VARCHAR2 | 64 | Yes | Who column: indicates the user who created the row. | ||
| CREATION_DATE | TIMESTAMP | Yes | Who column: indicates the date and time of the creation of the row. | |||
| LAST_UPDATED_BY | VARCHAR2 | 64 | Yes | Who column: indicates the user who last updated the row. | ||
| LAST_UPDATE_DATE | TIMESTAMP | Yes | Who column: indicates the date and time of the last update of the row. | |||
| LAST_UPDATE_LOGIN | VARCHAR2 | 32 | Who column: indicates the session login associated to the user who last updated the row. | |||
| ATTRIBUTE_CATEGORY | VARCHAR2 | 150 | Descriptive Flexfield: structure definition of the user descriptive flexfield. | |||
| ATTRIBUTE_CHAR1 | VARCHAR2 | 150 | Descriptive Flexfield: segment of the user descriptive flexfield. | |||
| ATTRIBUTE_CHAR2 | VARCHAR2 | 150 | Descriptive Flexfield: segment of the user descriptive flexfield. | |||
| ATTRIBUTE_CHAR3 | VARCHAR2 | 150 | Descriptive Flexfield: segment of the user descriptive flexfield. | |||
| ATTRIBUTE_CHAR4 | VARCHAR2 | 150 | Descriptive Flexfield: segment of the user descriptive flexfield. | |||
| ATTRIBUTE_CHAR5 | VARCHAR2 | 150 | Descriptive Flexfield: segment of the user descriptive flexfield. | |||
| ATTRIBUTE_CHAR6 | VARCHAR2 | 150 | Descriptive Flexfield: segment of the user descriptive flexfield. | |||
| ATTRIBUTE_CHAR7 | VARCHAR2 | 150 | Descriptive Flexfield: segment of the user descriptive flexfield. | |||
| ATTRIBUTE_CHAR8 | VARCHAR2 | 150 | Descriptive Flexfield: segment of the user descriptive flexfield. | |||
| ATTRIBUTE_CHAR9 | VARCHAR2 | 150 | Descriptive Flexfield: segment of the user descriptive flexfield. | |||
| ATTRIBUTE_CHAR10 | VARCHAR2 | 150 | Descriptive Flexfield: segment of the user descriptive flexfield. | |||
| ATTRIBUTE_NUMBER1 | NUMBER | Descriptive Flexfield: segment of the user descriptive flexfield. | ||||
| ATTRIBUTE_NUMBER2 | NUMBER | Descriptive Flexfield: segment of the user descriptive flexfield. | ||||
| ATTRIBUTE_NUMBER3 | NUMBER | Descriptive Flexfield: segment of the user descriptive flexfield. | ||||
| ATTRIBUTE_NUMBER4 | NUMBER | Descriptive Flexfield: segment of the user descriptive flexfield. | ||||
| ATTRIBUTE_NUMBER5 | NUMBER | Descriptive Flexfield: segment of the user descriptive flexfield. | ||||
| ATTRIBUTE_DATE1 | DATE | Descriptive Flexfield: segment of the user descriptive flexfield. | ||||
| ATTRIBUTE_DATE2 | DATE | Descriptive Flexfield: segment of the user descriptive flexfield. | ||||
| ATTRIBUTE_DATE3 | DATE | Descriptive Flexfield: segment of the user descriptive flexfield. | ||||
| ATTRIBUTE_DATE4 | DATE | Descriptive Flexfield: segment of the user descriptive flexfield. | ||||
| ATTRIBUTE_DATE5 | DATE | Descriptive Flexfield: segment of the user descriptive flexfield. |
Foreign Keys
| Table | Foreign Table | Foreign Key Column |
|---|---|---|
| JV_DISTRIBUTIONS | jv_transactions | TRANSACTION_ID |
| JV_DISTRIBUTIONS | jv_owner_percents_f_b | OWNERSHIP_PERCENTAGE_ID |
| JV_DISTRIBUTIONS | jv_stakeholders_b | STAKEHOLDER_ID |
| JV_DISTRIBUTIONS | jv_joint_ventures_b | JOINT_VENTURE_ID |
| JV_DISTRIBUTIONS | jv_contributions_b | CONTRIBUTION_ID |
| jv_ci_distributions | jv_distributions | JV_DISTRIBUTION_ID |
Indexes
| Index | Uniqueness | Tablespace | Columns |
|---|---|---|---|
| JV_DISTRIBUTIONS_FK2 | Non Unique | Default | OWNERSHIP_PERCENTAGE_ID |
| JV_DISTRIBUTIONS_FK3 | Non Unique | Default | STAKEHOLDER_ID |
| JV_DISTRIBUTIONS_FK4 | Non Unique | Default | JOINT_VENTURE_ID |
| JV_DISTRIBUTIONS_FK5 | Non Unique | Default | CONTRIBUTION_ID |
| JV_DISTRIBUTIONS_N1 | Non Unique | Default | ORIGINAL_DISTRIBUTION_ID |
| JV_DISTRIBUTIONS_N2 | Non Unique | Default | CONTRIBUTION_REVERSAL_FLAG |
| JV_DISTRIBUTIONS_N3 | Non Unique | Default | TARGET_TRANSACTION_ID, SOURCE_DISTRIBUTION_NUM |
| JV_DISTRIBUTIONS_PK | Unique | Default | DISTRIBUTION_ID |
| JV_DISTRIBUTIONS_UK1 | Unique | Default | TRANSACTION_ID, STAKEHOLDER_ID, DISTRIBUTION_LINE_NUMBER |