GL_CALENDARS
Unique identifier for accounting and commitment Calendars created in Oracle Fusion and has a one to one relationship with PERIOD_SET_NAME. For legacy accounting calendars migrated from instances prior to Oracle Fusion, CALENDAR_ID may have a one to many relationship with PERIOD_SET_NAME.
Details
-
Schema: FUSION
-
Object owner: GL
-
Object type: TABLE
-
Tablespace: APPS_TS_TX_DATA
Primary Key
| Name | Columns |
|---|---|
|
GL_CALENDARS_PK |
PERIOD_SET_NAME, PERIOD_TYPE |
Columns
| Name | Datatype | Length | Precision | Not-null | Comments | Flexfield-mapping |
|---|---|---|---|---|---|---|
| CALENDAR_ID | NUMBER | 18 | Yes | Unique identifier for Accounting and Commitment Calendars created in Fusion and has a 1-1 Relationship with PERIOD_SET_NAME. For legacy Accounting Calendars migrated from instances prior to Fusion, CALENDAR_ID may have 1 to many relationship with PERIOD_SET_NAME. | ||
| USER_PERIOD_SET_NAME | VARCHAR2 | 15 | Yes | Period of time, extending from one date to another, defined by a party to quantify the fiscal position of the business. It can be divided into accounting periods. | ||
| PERIOD_SET_NAME | VARCHAR2 | 15 | Yes | Name of the accounting calendar. | ||
| PERIOD_SET_ID | NUMBER | 18 | Yes | Accounting calendar identifier. | ||
| PERIOD_TYPE | VARCHAR2 | 15 | Yes | Accounting period type. Examples are Weekly, Monthly, Quarterly. | ||
| PERIOD_TYPE_ID | NUMBER | 18 | Yes | Accounting period type identifier. | ||
| DESCRIPTION | VARCHAR2 | 240 | Accounting calendar description. | |||
| SECURITY_FLAG | VARCHAR2 | 1 | Yes | Security mode flag of the calendar. | ||
| NON_ADJ_PERIOD_FREQ_CODE | VARCHAR2 | 30 | Nonadjustment period frequency. | |||
| ADJ_PERIOD_FREQ_CODE | VARCHAR2 | 30 | Frequency of adjusting periods in a calendar year. For example, it can be one adjusting period at the end of the year, two adjusting periods at the end of the year, one at the beginning and one at the end of the year. | |||
| ADJ_PERIODS_NUM | NUMBER | 18 | Number of adjusting periods per year in an accounting calendar when users choose to specify their own adjusting period frequency rather than selecting from prespecified choices. | |||
| LEGACY_RULES_ENABLED_FLAG | VARCHAR2 | 1 | Yes | Flag that indicates whether legacy rules for migration apply to this calendar for update purposes. Valid values are Yes or No. | ||
| NON_ADJ_PERIODS_NUM | NUMBER | 18 | Yes | Number of nonadjustment periods. | ||
| USER_PERIOD_NAME_PREFIX | VARCHAR2 | 30 | Optional string that is added at the beginning of an accounting period name, usually to identify its nature, such as fiscal or quarter name. | |||
| PERIOD_NAME_FORMAT_CODE | VARCHAR2 | 30 | To put in a fixed or organized form. | |||
| PERIOD_NAME_SEPARATOR_CODE | VARCHAR2 | 30 | Character (dash, forward slash, or none) that separates the period and year components of the accounting period name. | |||
| LATEST_YEAR_START_DATE | DATE | Yes | Start date of the latest year for which periods are generated. | |||
| CALENDAR_START_DATE | DATE | Yes | Date when the first period of the accounting calendar begins. | |||
| CALENDAR_TYPE_CODE | VARCHAR2 | 30 | Yes | Type of Calendar. Valid values are Accounting or Budgetary Control. | ||
| LEGACY_CALENDAR_FLAG | VARCHAR2 | 1 | Yes | Flag that indicates whether this is a legacy E-Business Suite calendar. Valid values are Yes or No. | ||
| ATTRIBUTE1 | VARCHAR2 | 150 | Descriptive Flexfield: segment of the user descriptive flexfield. | Calendars (GL_CALENDARS) | ||
| ATTRIBUTE2 | VARCHAR2 | 150 | Descriptive Flexfield: segment of the user descriptive flexfield. | Calendars (GL_CALENDARS) | ||
| ATTRIBUTE3 | VARCHAR2 | 150 | Descriptive Flexfield: segment of the user descriptive flexfield. | Calendars (GL_CALENDARS) | ||
| ATTRIBUTE4 | VARCHAR2 | 150 | Descriptive Flexfield: segment of the user descriptive flexfield. | Calendars (GL_CALENDARS) | ||
| ATTRIBUTE5 | VARCHAR2 | 150 | Descriptive Flexfield: segment of the user descriptive flexfield. | Calendars (GL_CALENDARS) | ||
| ATTRIBUTE_CATEGORY | VARCHAR2 | 150 | Descriptive Flexfield: structure definition of the user descriptive flexfield. | Calendars (GL_CALENDARS) | ||
| 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_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. | |||
| LAST_UPDATED_BY | VARCHAR2 | 64 | Yes | Who column: indicates the user who last updated the row. | ||
| 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. | ||
| ENTERPRISE_ID | NUMBER | 18 | Enterprise or business group identifier. | |||
| DEFAULT_PARTITION_GROUP_CODE | VARCHAR2 | 15 | Default partition grouping used for ledgers with this calendar. |
Foreign Keys
| Table | Foreign Table | Foreign Key Column |
|---|---|---|
| GL_CALENDARS | gl_period_sets | PERIOD_SET_NAME |
| GL_CALENDARS | gl_period_types | PERIOD_TYPE |
| gl_periods | gl_calendars | PERIOD_SET_NAME, PERIOD_TYPE |
| gl_date_period_map | gl_calendars | PERIOD_SET_NAME, PERIOD_TYPE |
Indexes
| Index | Uniqueness | Tablespace | Columns |
|---|---|---|---|
| GL_CALENDARS_N2 | Non Unique | Default | CALENDAR_TYPE_CODE |
| GL_CALENDARS_N3 | Non Unique | Default | UPPER("PERIOD_SET_NAME"), UPPER("PERIOD_TYPE") |
| GL_CALENDARS_U1 | Unique | Default | PERIOD_SET_NAME, PERIOD_TYPE |
| GL_CALENDARS_U2 | Unique | Default | CALENDAR_ID |
| GL_CALENDARS_U3 | Unique | Default | USER_PERIOD_SET_NAME |