JV_ASSIGNMENT_RULES_B
This table contains assignment rules for each joint venture. These rules are used to assign ownership definitions or direct billed stakeholders to joint venture transactions to be distributed.
Details
-
Schema: FUSION
-
Object owner: JV
-
Object type: TABLE
-
Tablespace: Default
Primary Key
| Name | Columns |
|---|---|
|
JV_ASSIGNMENT_RULES_B_PK |
ASSIGNMENT_RULE_ID |
Columns
| Name | Datatype | Length | Precision | Not-null | Comments |
|---|---|---|---|---|---|
| ASSIGNMENT_RULE_ID | NUMBER | 18 | Yes | Unique identifier for the assignment rule. | |
| 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. | |
| ASSIGNMENT_RULE_SHORT_NAME | VARCHAR2 | 30 | Yes | The short name of the assignment rule that is used as an identifier. | |
| ASSIGNMENT_RULE_STATUS_CODE | VARCHAR2 | 30 | Yes | The status code of the assignment rule. It is based on ORA_JV_ASSIGNMENT_RULE_STATUS lookup codes such as ORA_JV_EDITING, ORA_JV_ACTIVE, ORA_JV_INACTIVE, or other user defined values. | |
| JOINT_VENTURE_ID | NUMBER | 18 | Yes | Unique identifier for the joint venture that the assignment rule is associated with. | |
| OWNER_DEFINITION_SHORT_NAME | VARCHAR2 | 30 | The ownership definition short name to be assigned to joint venture transactions based on the assignment rule. | ||
| STAKEHOLDER_ID | NUMBER | 18 | The stakeholder to be assigned to joint venture transactions based on the assignment rule. This will be the direct billed stakeholder. | ||
| ACCOUNT_SET_ID | NUMBER | 18 | Unique identifier for the account set used by the assignment rule to select joint venture transactions, which will be updated with an ownership definition or direct billed stakeholder. | ||
| ACCOUNT_CCID | NUMBER | 18 | Unique identifier for the account to be used by the assignment rule to select joint venture transactions, which will be updated with an ownership definition or direct billed stakeholder. | ||
| PROJECT_SET_ID | NUMBER | 18 | Unique identifier of the project set associated with the assignment rule. | ||
| SEQUENCE_NUMBER | NUMBER | 5 | Yes | Number assigned by the user to indicate the order assignment rules will be processed for the joint venture. | |
| START_DATE | DATE | Yes | The beginning date for the assignment rule, which will be compared to the transaction date on joint venture transactions to determine which transactions will be updated with an ownership definition or direct billed stakeholder. | ||
| END_DATE | DATE | Yes | The ending date for the assignment rule, which will be compared to the transaction date on joint venture transactions to determine which transactions will be updated with an ownership definition or direct billed stakeholder. | ||
| 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 | 30 | 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_ASSIGNMENT_RULES_B | joint_ventures_b | JOINT_VENTURE_ID |
| JV_ASSIGNMENT_RULES_B | jv_stakeholders_b | STAKEHOLDER_ID |
| JV_ASSIGNMENT_RULES_B | jv_account_sets_b | ACCOUNT_SET_ID |
| JV_ASSIGNMENT_RULES_B | gl_code_combinations | ACCOUNT_CCID |
| JV_ASSIGNMENT_RULES_B | jv_project_sets_b | PROJECT_SET_ID |
| jv_assignment_rules_tl | jv_assignment_rules_b | ASSIGNMENT_RULE_ID |
| jv_project_value_sets | jv_assignment_rules_b | ASSIGNMENT_RULE_ID |
Indexes
| Index | Uniqueness | Tablespace | Columns |
|---|---|---|---|
| JV_ASSIGNMENT_RULES_B_PK | Unique | Default | ASSIGNMENT_RULE_ID |
| JV_ASSIGNMENT_RULES_B_U1 | Unique | Default | JOINT_VENTURE_ID, ASSIGNMENT_RULE_SHORT_NAME |