GL_JE_INCLUSION_RULES
GL_JE_INCLUSION_RULES contains a set of journal sources and categories to be included/excluded for various kinds of processing, such as propagation to reporting currencies and secondary ledgers.INCLUDE_FLAG indicates if a particular source and category combination is to be included (Y) or excluded (N) for processing.Rules defined in this table could be entered by user or system generated. System generated rules cannot be modified by the user. USER_UPDATABLE_FLAG indicates if a user can modify the rule or not.
Details
-
Schema: FUSION
-
Object owner: GL
-
Object type: TABLE
-
Tablespace: APPS_TS_TX_DATA
Primary Key
| Name | Columns |
|---|---|
|
GL_JE_INCLUSION_RULES_PK |
JE_SOURCE_NAME, JE_CATEGORY_NAME, JE_RULE_SET_ID |
Columns
| Name | Datatype | Length | Precision | Not-null | Comments | Flexfield-mapping |
|---|---|---|---|---|---|---|
| JE_RULE_SET_ID | NUMBER | 18 | Yes | Journal inclusion rule set identifier. | ||
| JE_SOURCE_NAME | VARCHAR2 | 25 | Yes | Journal source. Foreign key to GL_JE_SOURCES_B. | ||
| JE_CATEGORY_NAME | VARCHAR2 | 25 | Yes | Journal category. Foreign key to GL_JE_CATEGORIES_B. | ||
| USER_UPDATABLE_FLAG | VARCHAR2 | 1 | Yes | Indicates whether the user can update the rule. | ||
| INCLUDE_FLAG | VARCHAR2 | 1 | Yes | Indicate whether this journal source or category will be included or excluded for processing. | ||
| ALC_DEFAULT_CONV_RATE_TYPE | VARCHAR2 | 30 | Default conversion rate type for reporting ledger journal. | |||
| ALC_NO_RATE_ACTION_CODE | VARCHAR2 | 30 | Report error or use the last available rate when no rate exists. | |||
| ALC_INHERIT_CONVERSION_TYPE | VARCHAR2 | 1 | Inherit conversion rate type from transaction. | |||
| CREATION_DATE | TIMESTAMP | Yes | Who column: indicates the date and time of the creation of the row. | |||
| CREATED_BY | VARCHAR2 | 64 | Yes | Who column: indicates the user who created the row. | ||
| LAST_UPDATE_LOGIN | VARCHAR2 | 32 | Who column: indicates the session login associated to 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_UPDATED_BY | VARCHAR2 | 64 | Yes | Who column: indicates the user who last updated the row. | ||
| ATTRIBUTE_CATEGORY | VARCHAR2 | 150 | Descriptive Flexfield: structure definition of the user descriptive flexfield. | Secondary Ledger Source and Category Conversion (GL_JE_INCLUSION_RULES) | ||
| ATTRIBUTE1 | VARCHAR2 | 150 | Descriptive Flexfield: segment of the user descriptive flexfield. | Secondary Ledger Source and Category Conversion (GL_JE_INCLUSION_RULES) | ||
| ATTRIBUTE2 | VARCHAR2 | 150 | Descriptive Flexfield: segment of the user descriptive flexfield. | Secondary Ledger Source and Category Conversion (GL_JE_INCLUSION_RULES) | ||
| ATTRIBUTE3 | VARCHAR2 | 150 | Descriptive Flexfield: segment of the user descriptive flexfield. | Secondary Ledger Source and Category Conversion (GL_JE_INCLUSION_RULES) | ||
| ATTRIBUTE4 | VARCHAR2 | 150 | Descriptive Flexfield: segment of the user descriptive flexfield. | Secondary Ledger Source and Category Conversion (GL_JE_INCLUSION_RULES) | ||
| ATTRIBUTE5 | VARCHAR2 | 150 | Descriptive Flexfield: segment of the user descriptive flexfield. | Secondary Ledger Source and Category Conversion (GL_JE_INCLUSION_RULES) | ||
| ATTRIBUTE6 | VARCHAR2 | 150 | Descriptive Flexfield: segment of the user descriptive flexfield. | Secondary Ledger Source and Category Conversion (GL_JE_INCLUSION_RULES) | ||
| ATTRIBUTE7 | VARCHAR2 | 150 | Descriptive Flexfield: segment of the user descriptive flexfield. | Secondary Ledger Source and Category Conversion (GL_JE_INCLUSION_RULES) | ||
| ATTRIBUTE8 | VARCHAR2 | 150 | Descriptive Flexfield: segment of the user descriptive flexfield. | Secondary Ledger Source and Category Conversion (GL_JE_INCLUSION_RULES) | ||
| ATTRIBUTE9 | VARCHAR2 | 150 | Descriptive Flexfield: segment of the user descriptive flexfield. | Secondary Ledger Source and Category Conversion (GL_JE_INCLUSION_RULES) | ||
| ATTRIBUTE10 | VARCHAR2 | 150 | Descriptive Flexfield: segment of the user descriptive flexfield. | Secondary Ledger Source and Category Conversion (GL_JE_INCLUSION_RULES) | ||
| ATTRIBUTE11 | VARCHAR2 | 150 | Descriptive Flexfield: segment of the user descriptive flexfield. | Secondary Ledger Source and Category Conversion (GL_JE_INCLUSION_RULES) | ||
| ATTRIBUTE12 | VARCHAR2 | 150 | Descriptive Flexfield: segment of the user descriptive flexfield. | Secondary Ledger Source and Category Conversion (GL_JE_INCLUSION_RULES) | ||
| ATTRIBUTE13 | VARCHAR2 | 150 | Descriptive Flexfield: segment of the user descriptive flexfield. | Secondary Ledger Source and Category Conversion (GL_JE_INCLUSION_RULES) | ||
| ATTRIBUTE14 | VARCHAR2 | 150 | Descriptive Flexfield: segment of the user descriptive flexfield. | Secondary Ledger Source and Category Conversion (GL_JE_INCLUSION_RULES) | ||
| ATTRIBUTE15 | VARCHAR2 | 150 | Descriptive Flexfield: segment of the user descriptive flexfield. | Secondary Ledger Source and Category Conversion (GL_JE_INCLUSION_RULES) | ||
| 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. |
Indexes
| Index | Uniqueness | Tablespace | Columns |
|---|---|---|---|
| GL_JE_INCLUSION_RULES_U1 | Unique | Default | JE_SOURCE_NAME, JE_CATEGORY_NAME, JE_RULE_SET_ID |