JV_OVERHEAD_METHODS_F_B
This table contains the date effective overhead methods for each joint venture. These methods are used to calculate and generate overhead transactions to charge indirect costs to the joint venture partners.
Details
-
Schema: FUSION
-
Object owner: JV
-
Object type: TABLE
-
Tablespace: Default
Primary Key
| Name | Columns |
|---|---|
|
JV_OVERHEAD_METHODS_F_B_PK |
OVERHEAD_METHOD_ID |
Columns
| Name | Datatype | Length | Precision | Not-null | Comments |
|---|---|---|---|---|---|
| OVERHEAD_METHOD_ID | NUMBER | 18 | Yes | Unique identifier for the joint venture overhead method. | |
| 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 of the joint venture that the overhead method is associated to. | |
| METHOD_SHORT_NAME | VARCHAR2 | 30 | Yes | The short name of the joint venture overhead method that is used as an identifier across effective dates for the joint venture. | |
| METHOD_TYPE_CODE | VARCHAR2 | 30 | Yes | The type of overhead method used to determine how to calculate the overhead amount. It is based on the ORA_JV_OVERHEAD_METHOD_TYPE lookup codes such as percentage of cost. | |
| EFFECTIVE_START_DATE | DATE | Yes | Date Effective Entity: indicates the date at the beginning of the date range within which the row is effective. | ||
| EFFECTIVE_END_DATE | DATE | Yes | Date Effective Entity: indicates the date at the end of the date range within which the row is effective. | ||
| BASIS_SOURCE_CODE | VARCHAR2 | 30 | The source that the overhead calculation is based on. It is based on the ORA_JV_OVERHEAD_SOURCE lookup codes such as billed joint venture transactions. | ||
| METHOD_PERCENTAGE | NUMBER | The percentage in the overhead method that is used to calculate the overhead amount. | |||
| FIXED_AMOUNT | NUMBER | The fixed amount applied to the joint venture as overhead. | |||
| METHOD_STATUS_CODE | VARCHAR2 | 30 | Yes | The status code of the joint venture overhead method. It is based on the ORA_JV_OVERHEAD_METHOD_STATUS lookup codes such as pending, active, inactive, or other user defined values. | |
| STRUCTURE_ID | NUMBER | 18 | Unique identifier for the structure associated with the account segment assigned to the overhead method. This is used to get the account name and segment value description. | ||
| SEGMENT_CODE | VARCHAR2 | 30 | Identifies which segment in the chart of accounts is used to select joint venture transactions for overhead calculations. | ||
| SEGMENT_VALUE | VARCHAR2 | 25 | Identifies the segment value used to select joint venture transactions for overhead calculations. | ||
| OWNERSHIP_PERCENT_SHORT_NAME | VARCHAR2 | 30 | The ownership definition short name to be used when splitting the calculated overhead amount for distribution to the stakeholders. | ||
| DISTRIBUTION_TYPE_CODE | VARCHAR2 | 30 | The distribution type that is passed into the joint venture invoice for the distributed overhead transactions to be used for account mapping to assign the receivable offset account to the invoice line. It is based on the ORA_JV_METHOD_DIST_TYPE lookup codes such as overhead or fees. | ||
| MINIMUM_AMOUNT | NUMBER | The minimum debit amount for an overhead accounts receivable line. This amount will be used instead of the calculated overhead debit amount if the calculated amount is less than the minimum. If the calculated overhead amount results in a credit, this amount is ignored. | |||
| TRANSACTION_DATE_SOURCE_CODE | VARCHAR2 | 30 | The source of the transaction date in a transaction with the calculated overhead amount. It is based on the ORA_JV_TRANSACTION_DATE_SOURCE lookup codes such as last day of the period or system date. | ||
| CODE_COMBINATION_ID | NUMBER | 18 | Key flexfield combination defining column that will be used as the receivable offset account in invoicing. | ||
| PERIOD_BASIS_CODE | VARCHAR2 | 30 | Determines how the overhead calculation basis is derived. It is based on the ORA_JV_OVERHEAD_PERIOD lookup codes such as period, year to period, or inception to period. | ||
| CALENDAR_TYPE_CODE | VARCHAR2 | 30 | The type of calendar being used when calculating overhead. It is based on the ORA_JV_CALENDAR_TYPE lookup codes such as standard or fiscal. | ||
| MAXIMUM_AMOUNT | NUMBER | Yes | The maximum overhead amount allowed to be billed. | ||
| SOURCE_ACCOUNT_SET_ID | NUMBER | 18 | The account set used to select GL and SLA transactions for the overhead calculation. | ||
| SOURCE_CODE_COMBINATION_ID | NUMBER | 18 | The account used to select GL and SLA transactions for the overhead calculation. | ||
| SOURCE_LEDGER_ID | NUMBER | 18 | The ledger used to select GL and SLA transactions for the overhead calculation. | ||
| 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. | ||
| SLIDING_SCALE_FLAG | VARCHAR2 | 1 | Yes | Indicates whether the overhead method will use a sliding scale. | |
| METHOD_RATE | NUMBER | The rate in the overhead method that is used to calculate the overhead amount. | |||
| ADJUSTMENT_FACTOR_ID | NUMBER | 18 | Unique identifier of the periodic adjustment factor that the overhead method is associated with. | ||
| LAST_ADJUSTMENT_DATE | DATE | The date that the overhead method was last adjusted. | |||
| LAST_FACTOR_VALUE_DATE | DATE | The date of the last adjustment factor value used to adjust the overhead method. | |||
| LAST_FACTOR_VALUE_PERCENTAGE | NUMBER | The percentage of the last adjustment factor value used to adjust the overhead method. | |||
| 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 | 32 | 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_OVERHEAD_METHODS_F_B | jv_joint_ventures_b | JOINT_VENTURE_ID |
| JV_OVERHEAD_METHODS_F_B | jv_periodic_adj_factors_b | ADJUSTMENT_FACTOR_ID |
| jv_generated_transactions | jv_overhead_methods_f_b | OVERHEAD_METHOD_ID |
| jv_overhead_measure_types | jv_overhead_methods_f_b | OVERHEAD_METHOD_ID |
| jv_overhead_methods_tl | jv_overhead_methods_f_b | OVERHEAD_METHOD_ID |
| jv_sliding_scale_thresholds | jv_overhead_methods_f_b | OVERHEAD_METHOD_ID |
Indexes
| Index | Uniqueness | Tablespace | Columns |
|---|---|---|---|
| JV_OVERHEAD_METHODS_F_B_PK | Unique | Default | OVERHEAD_METHOD_ID |
| JV_OVERHEAD_METHODS_F_B_U1 | Unique | Default | JOINT_VENTURE_ID, METHOD_SHORT_NAME, EFFECTIVE_END_DATE |