[Home] [Help] [Dependency Information]
Object Name: | GL_PERIOD_STATUSES |
---|---|
Object Type: | TABLE |
Owner: | GL |
FND Design Data: | SQLGL.GL_PERIOD_STATUSES |
Subobject Name: | |
Status: | VALID |
GL_PERIOD_STATUSES stores the statuses of your accounting periods. Each row includes the accounting period name and status. Many applications maintain their calendars in this table, so each row also includes the relevant application identifier. CLOSING_STATUS is either 'O' for open, 'F' for future enterable, 'C' for closed, 'P' for permanently closed, or 'N' for never opened. Note that you cannot successfully open a period in your Oracle General Ledger application by changing a period's status to 'O' if it has never been opened before. You must use the Open and Close Periods form or programs to properly open a period.
Tablespace: | APPS_TS_TX_DATA |
---|---|
PCT Free: | 10 |
PCT Used: |
Index | Type | Uniqueness | Tablespace | Column |
---|---|---|---|---|
GL_PERIOD_STATUSES_U1 | NORMAL | UNIQUE | APPS_TS_TX_IDX |
APPLICATION_ID
SET_OF_BOOKS_ID PERIOD_NAME |
GL_PERIOD_STATUSES_U2 | NORMAL | UNIQUE | APPS_TS_TX_IDX |
APPLICATION_ID
SET_OF_BOOKS_ID EFFECTIVE_PERIOD_NUM CLOSING_STATUS |
GL_PERIOD_STATUSES_U3 | NORMAL | UNIQUE | APPS_TS_TX_IDX |
APPLICATION_ID
LEDGER_ID PERIOD_NAME |
GL_PERIOD_STATUSES_U4 | NORMAL | UNIQUE | APPS_TS_TX_IDX |
APPLICATION_ID
LEDGER_ID EFFECTIVE_PERIOD_NUM CLOSING_STATUS |
GL_PERIOD_STATUSES_N1 | NORMAL | NONUNIQUE | APPS_TS_TX_IDX | CLOSING_STATUS |
Name | Datatype | Length | Mandatory | Comments |
---|---|---|---|---|
APPLICATION_ID | NUMBER | (15) | Yes | Application defining column |
SET_OF_BOOKS_ID | NUMBER | (15) | Yes | Ledger defining column |
PERIOD_NAME | VARCHAR2 | (15) | Yes | Accounting period name |
LAST_UPDATE_DATE | DATE | Yes | Standard Who column | |
LAST_UPDATED_BY | NUMBER | (15) | Yes | Standard Who column |
CLOSING_STATUS | VARCHAR2 | (1) | Yes | Accounting period status |
START_DATE | DATE | Yes | Date on which accounting period begins | |
END_DATE | DATE | Yes | Date on which accounting period ends | |
YEAR_START_DATE | DATE | Yes | Date on which the year containing this accounting period starts | |
QUARTER_NUM | NUMBER | (15) | Yes | Quarter number |
QUARTER_START_DATE | DATE | Yes | Date on which the quarter containing this accounting period starts | |
PERIOD_TYPE | VARCHAR2 | (15) | Yes | Accounting period type |
PERIOD_YEAR | NUMBER | (15) | Yes | Accounting period year |
EFFECTIVE_PERIOD_NUM | NUMBER | (15) | Yes | Denormalized period number (period_year*10000 + period_num) |
PERIOD_NUM | NUMBER | (15) | Yes | Accounting period number |
ADJUSTMENT_PERIOD_FLAG | VARCHAR2 | (1) | Yes | Calendar adjustment period flag |
CREATION_DATE | DATE | Standard Who column | ||
CREATED_BY | NUMBER | (15) | Standard Who column | |
LAST_UPDATE_LOGIN | NUMBER | (15) | Standard Who column | |
ELIMINATION_CONFIRMED_FLAG | VARCHAR2 | (1) | Elimination confirmed flag | |
ATTRIBUTE1 | VARCHAR2 | (150) | Descriptive flexfield segment | |
ATTRIBUTE2 | VARCHAR2 | (150) | Descriptive flexfield segment | |
ATTRIBUTE3 | VARCHAR2 | (150) | Descriptive flexfield segment | |
ATTRIBUTE4 | VARCHAR2 | (150) | Descriptive flexfield segment | |
ATTRIBUTE5 | VARCHAR2 | (150) | Descriptive flexfield segment | |
CONTEXT | VARCHAR2 | (150) | Descriptive flexfield context | |
CHRONOLOGICAL_SEQ_STATUS_CODE | VARCHAR2 | (1) | Chronological sequence maintenance status | |
LEDGER_ID | NUMBER | (15) | Yes | Ledger defining column |
MIGRATION_STATUS_CODE | VARCHAR2 | (30) | Migration status | |
TRACK_BC_YTD_FLAG | VARCHAR2 | (1) | Track budgetary debit/credit accounts as balance sheet accounts |
Cut, paste (and edit) the following text to query this object:
SELECT APPLICATION_ID
, SET_OF_BOOKS_ID
, PERIOD_NAME
, LAST_UPDATE_DATE
, LAST_UPDATED_BY
, CLOSING_STATUS
, START_DATE
, END_DATE
, YEAR_START_DATE
, QUARTER_NUM
, QUARTER_START_DATE
, PERIOD_TYPE
, PERIOD_YEAR
, EFFECTIVE_PERIOD_NUM
, PERIOD_NUM
, ADJUSTMENT_PERIOD_FLAG
, CREATION_DATE
, CREATED_BY
, LAST_UPDATE_LOGIN
, ELIMINATION_CONFIRMED_FLAG
, ATTRIBUTE1
, ATTRIBUTE2
, ATTRIBUTE3
, ATTRIBUTE4
, ATTRIBUTE5
, CONTEXT
, CHRONOLOGICAL_SEQ_STATUS_CODE
, LEDGER_ID
, MIGRATION_STATUS_CODE
, TRACK_BC_YTD_FLAG
FROM GL.GL_PERIOD_STATUSES;
GL.GL_PERIOD_STATUSES does not reference any database object
GL.GL_PERIOD_STATUSES is referenced by following:
|
|
|