JV_TRANSACTIONS
This table will reference transactions that will be distributed among stakeholders of a joint venture.
Details
-
Schema: FUSION
-
Object owner: JV
-
Object type: TABLE
-
Tablespace: Default
Primary Key
| Name | Columns |
|---|---|
|
JV_TRANSACTIONS_PK |
TRANSACTION_ID |
Columns
| Name | Datatype | Length | Precision | Not-null | Comments | Status |
|---|---|---|---|---|---|---|
| TRANSACTION_ID | NUMBER | 18 | Yes | Unique identifier for the distributable 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. | ||
| JOINT_VENTURE_ID | NUMBER | 18 | Yes | Unique identifier for the joint venture. | ||
| HEADER_ID | NUMBER | 18 | Yes | Header defining column for the transaction. This will hold either a je_header_id (for journal entry) or ae_header_id (for subledger accounting entry). | ||
| LINE_NUM | NUMBER | 18 | Yes | Accounting line for the transaction. This will hold either a je_line_num (for journal entry) or ae_line_num (for subledger accounting entry). | ||
| APPLICATION_ID | NUMBER | 18 | Yes | Functional area within a software suite of products. For example, Financials or Payroll. If this transaction is a journal entry a value of -99 will be populated. | ||
| TRANSACTION_STATUS_CODE | VARCHAR2 | 30 | Yes | The status code of the distributable transaction. It is based on ORA_JV_TRANSACTION_STATUS lookup codes such as ORA_JV_AVAILABLE_TO_PROCESS, ORA_JV_ERROR, or ORA_JV_ON_HOLD. | ||
| OWNERSHIP_PERCENT_SHORT_NAME | VARCHAR2 | 30 | The ownership definition short name to be used when splitting the transaction amount for distribution to the stakeholders. This can be overridden from what was originally assigned. | |||
| ORIGINAL_OWNERSHIP_SHORT_NAME | VARCHAR2 | 30 | The original ownership definition short name to be used when splitting the transaction amount for distribution to the stakeholders. This is the value that was initially assigned when the transaction was created and can't be overridden. | |||
| STAKEHOLDER_ID | NUMBER | 18 | Unique identifier for the stakeholder that is to be directly billed for the transaction. This can be overridden from what was originally assigned. | |||
| ORIGINAL_STAKEHOLDER_ID | NUMBER | 18 | Unique identifier for the stakeholder that is to be directly billed for the transaction. This was originally assigned and cannot be overridden. | |||
| TRANSACTION_DATE | DATE | Date used to identify when the transaction occurred. This may be different than the effective_date for the journal entry and the accounting_date for the subledger accounting transaction. | ||||
| ACCOUNTING_DATE | DATE | The accounting date on the original source transaction used to create the joint venture transaction. | ||||
| PERIOD_NAME | VARCHAR2 | 15 | The fiscal period assigned to the original source transaction used to create the joint venture transaction. | |||
| LEDGER_ID | NUMBER | 18 | Self-contained accounting information set for single or multiple legal or management entities. | |||
| CODE_COMBINATION_ID | NUMBER | 18 | Account combination identifier for the account on the original source transaction used to create the joint venture transaction. | |||
| ENTERED_DEBIT | NUMBER | The debit amount of the original source transaction used to create the joint venture transaction in the entered currency. | ||||
| ENTERED_CREDIT | NUMBER | The credit amount of the original source transaction used to create the joint venture transaction in the entered currency. | ||||
| ENTERED_CURRENCY_CODE | VARCHAR2 | 15 | The currency code entered on the original source transaction used to create the joint venture transaction. | |||
| ACCOUNTED_DEBIT | NUMBER | The debit amount of the original source transaction used to create the joint venture transaction in the accounted currency. | ||||
| ACCOUNTED_CREDIT | NUMBER | The credit amount of the original source transaction used to create the joint venture transaction in the accounted currency. | ||||
| ACCOUNTED_CURRENCY_CODE | VARCHAR2 | 15 | The currency code of the original source transaction used to create the joint venture transaction. | |||
| TRANSACTION_DESCRIPTION | VARCHAR2 | 240 | The description on the original source transaction used to create the joint venture transaction that is passed into the joint venture invoice. | |||
| ASSIGNMENT_RULE_ID | NUMBER | 18 | Unique identifier for the assignment rule used to assign the ownership definition or direct billed stakeholder to the joint venture transaction. | |||
| 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. | |||
| AGREEMENT_ID | NUMBER | 18 | Unique identifier for the carried interest agreement. | |||
| CI_ORIGINAL_OWNERSHIP_NAME | VARCHAR2 | 30 | The original ownership definition short name that was used along with the carried interest agreement to generate the carried interest ownership definition. The carried interest ownership definition will be used to distribute the transaction to the stakeholders. | |||
| 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. | ||||
| PROJECT_ID | NUMBER | 18 | Unique identifier for the project that is associated with the subledger accounting entry for the transaction. | |||
| TASK_ID | NUMBER | 18 | Unique identifier for the project task that is associated with the subledger accounting entry for the transaction. | |||
| OVERRIDE_TASK_ID | NUMBER | 18 | Unique identifier for the overriding task applied to joint venture distributions sent to Project Costing as cost adjustments. | |||
| EXPENDITURE_TYPE_ID | NUMBER | 18 | Unique identifier for the expenditure type that is associated with the subledger accounting entry for the transaction. | |||
| OVERRIDE_EXPENDITURE_TYPE_ID | NUMBER | 18 | Unique identifier for the overriding expenditure type applied to joint venture distributions sent to Project Costing as cost adjustments. | |||
| EXPENDITURE_ORGANIZATION_ID | NUMBER | 18 | Unique identifier for the organization that is associated with the subledger accounting entry for the transaction. | |||
| EXPENDITURE_ITEM_DATE | DATE | Date when the expenditure associated with the subledger accounting entry for the transaction was incurred. | ||||
| EXPENDITURE_BU_ID | NUMBER | 18 | Unique identifier for the expenditure business unit that is associated with the subledger accounting entry for the transaction. | |||
| EXPENDITURE_ITEM_ID | NUMBER | 18 | Unique identifier for the expenditure item that is associated with the subledger accounting entry for the transaction. | Obsolete | ||
| EXPENDITURE_CATEGORY_ID | NUMBER | 18 | Unique identifier for the grouping of expenditure types that is associated with the subledger accounting entry for the transaction. | Obsolete | ||
| OVERHEAD_AVAILABILITY_FLAG | VARCHAR2 | 1 | Yes | Indicates whether the joint venture transaction is available to be used in overhead calculations. | ||
| DISTRIBUTION_ONLY_FLAG | VARCHAR2 | 1 | Yes | Indicates whether the transaction will be used for distribution only and not invoiced. |
Foreign Keys
| Table | Foreign Table | Foreign Key Column |
|---|---|---|
| JV_TRANSACTIONS | jv_joint_ventures_b | JOINT_VENTURE_ID |
| JV_TRANSACTIONS | jv_stakeholders_b | STAKEHOLDER_ID |
| JV_TRANSACTIONS | jv_stakeholders_b | ORIGINAL_STAKEHOLDER_ID |
| jv_distributions | jv_transactions | TRANSACTION_ID |
| jv_ci_distributions | jv_transactions | TRANSACTION_ID |
| jv_transaction_changes | jv_transactions | TRANSACTION_ID |
Indexes
| Index | Uniqueness | Tablespace | Columns |
|---|---|---|---|
| JV_TRANACTIONS_FK1 | Non Unique | Default | JOINT_VENTURE_ID |
| JV_TRANACTIONS_FK2 | Non Unique | Default | STAKEHOLDER_ID |
| JV_TRANACTIONS_FK3 | Non Unique | Default | ORIGINAL_STAKEHOLDER_ID |
| JV_TRANSACTIONS_FK4 | Non Unique | Default | PROJECT_ID |
| JV_TRANSACTIONS_N1 | Non Unique | Default | OWNERSHIP_PERCENT_SHORT_NAME, TRANSACTION_DATE |
| JV_TRANSACTIONS_PK | Unique | Default | TRANSACTION_ID |
| JV_TRANSACTIONS_U1 | Unique | Default | HEADER_ID, LINE_NUM, APPLICATION_ID |