JV_CONTRIBUTIONS_B
This table contains joint venture partner contribution definitions.
Details
-
Schema: FUSION
-
Object owner: JV
-
Object type: TABLE
-
Tablespace: Default
Primary Key
| Name | Columns |
|---|---|
|
JV_CONTRIBUTIONS_B_PK |
CONTRIBUTION_ID |
Columns
| Name | Datatype | Length | Precision | Not-null | Comments |
|---|---|---|---|---|---|
| CONTRIBUTION_ID | NUMBER | 18 | Yes | Unique identifier for the partner contribution. | |
| 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 | The unique identifier of the joint venture assigned to the partner contribution. | |
| STAKEHOLDER_ID | NUMBER | 18 | Yes | The unique identifier of the stakeholder assigned to the partner contribution. | |
| START_DATE | DATE | Yes | The date when joint venture distribution records can be applied to the partner contribution. | ||
| SEQUENCE_NUMBER | NUMBER | 3 | Yes | The sequence number of the partner contribution. | |
| CONTRIBUTION_AMOUNT | NUMBER | The contribution amount for the stakeholder in the ledger currency. This is the amount that will be assigned to joint venture distributions and drawn against. | |||
| CONTRIBUTION_OPEN_AMOUNT | NUMBER | The amount available to be drawn, transferred, or refunded for the partner contribution. | |||
| CONTRIBUTION_STATUS_CODE | VARCHAR2 | 30 | Yes | The status code of the partner contribution. It is based on ORA_JV_CONTRIBUTION_STATUS. Statuses include: In Progress, Invoiced, Available to Draw, Closed, On Hold, or Error. | |
| CLOSE_REASON_CODE | VARCHAR2 | 30 | The reason code identifying why the partner contribution was closed. It is based on ORA_JV_PC_CLOSE_REASON_CODE. | ||
| CLOSE_DATE | DATE | The date the partner contribution was closed. | |||
| CLOSE_TYPE_CODE | VARCHAR2 | 30 | The type code used to identify how the partner contribution was closed. It is based on ORA_JV_PC_CLOSE_TYPE. Close types include: Journal Entry or AP Invoice. | ||
| REFUND_AMOUNT | NUMBER | The amount to be refunded to the partner when the partner contribution is closed. | |||
| AGREEMENT_DEFAULT_CHARGE | NUMBER | The amount charged to the partner when closing the partner contribution. | |||
| TRANSFER_TO_CONTRIBUTION_ID | NUMBER | 18 | The unique identifier of the partner contribution that the open amount was transferred to when closing this partner contribution. | ||
| OWNERSHIP_PERCENTAGE_ID | NUMBER | 18 | Identifier for the ownership definition that was used to create the partner contribution. | ||
| PREFERRED_CURRENCY_CODE | VARCHAR2 | 15 | The currency code that will be used to create the partner contribution receivables invoice for the stakeholder. | ||
| FOREIGN_CONTRIBUTION_AMOUNT | NUMBER | The contribution amount for the stakeholder in the preferred currency. This amount is populated only when the preferred currency is different from the primary ledger currency of the joint venture. | |||
| GROSS_CONTRIBUTION_AMOUNT | NUMBER | The gross partner contribution amount that was split among the stakeholders defined in the ownership definition. This amount is in the preferred currency of the contribution. If the preferred currency is not defined, this amount will be in the currency of the primary ledger associated with the joint venture. | |||
| PARTNER_ACCOUNT_CCID | NUMBER | 18 | The code combination identifier for the partner account used when invoicing the stakeholder for the partner contribution. | ||
| AUTOMATIC_CONTRIBUTION_FLAG | VARCHAR2 | 1 | Yes | Indicates whether the partner contribution was created automatically or manually. A value of "Y" indicates that the partner contribution was created automatically by the system. A value of "N" indicates that the partner contribution was manually created. | |
| 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. | ||
| CONTRIBUTION_REQUEST_ID | NUMBER | 18 | Unique identifier of the partner contribution request. | ||
| 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_CONTRIBUTIONS_B | jv_stakeholders_b | STAKEHOLDER_ID |
| JV_CONTRIBUTIONS_B | jv_contributions_b | TRANSFER_TO_CONTRIBUTION_ID |
| jv_accounting_headers | jv_contributions_b | CONTRIBUTION_ID |
| jv_distributions | jv_contributions_b | CONTRIBUTION_ID |
| jv_contributions_b | jv_contributions_b | TRANSFER_TO_CONTRIBUTION_ID |
| jv_contribution_references | jv_contributions_b | RELATED_CONTRIBUTION_ID |
| jv_contribution_references | jv_contributions_b | CONTRIBUTION_ID |
| jv_contributions_tl | jv_contributions_b | CONTRIBUTION_ID |
Indexes
| Index | Uniqueness | Tablespace | Columns |
|---|---|---|---|
| JV_CONTRIBUTIONS_B_FK1 | Non Unique | Default | STAKEHOLDER_ID |
| JV_CONTRIBUTIONS_B_FK2 | Non Unique | Default | TRANSFER_TO_CONTRIBUTION_ID |
| JV_CONTRIBUTIONS_B_PK | Unique | Default | CONTRIBUTION_ID |
| JV_CONTRIBUTIONS_B_U1 | Unique | Default | JOINT_VENTURE_ID, STAKEHOLDER_ID, START_DATE, SEQUENCE_NUMBER |