[Home] [Help] [Dependency Information]
Object Name: | BIM_INTL_DATES |
---|---|
Object Type: | TABLE |
Owner: | BIM |
Subobject Name: | |
Status: | VALID |
This is used for store the gl period info for each day
Tablespace: | APPS_TS_TX_DATA |
---|---|
PCT Free: | 10 |
PCT Used: |
Index | Type | Uniqueness | Tablespace | Column |
---|---|---|---|---|
BIM_INTL_DATES_N1 | NORMAL | NONUNIQUE | APPS_TS_TX_IDX | TRDATE |
Name | Datatype | Length | Mandatory | Comments |
---|---|---|---|---|
TRDATE | DATE | Yes | transaction date | |
YEAR | VARCHAR2 | (30) | ||
QTR | VARCHAR2 | (30) | ||
MONTH | VARCHAR2 | (30) | ||
QTR_NUM | NUMBER | Fiscal Period Quarter Number | ||
MONTH_NUM | NUMBER | Fiscal Period Month order in fiscal year | ||
SECURITY_GROUP_ID | NUMBER | Used in hosted environments | ||
FISCAL_MONTH | VARCHAR2 | (30) | Fiscal Period Month | |
MONTH_FLAG | VARCHAR2 | (1) | flag indicating whether this is month start | |
FISCAL_QTR | VARCHAR2 | (30) | Fiscal Period Quarter | |
QTR_FLAG | VARCHAR2 | (1) | flag indicating whether it is quarter start | |
FISCAL_YEAR | VARCHAR2 | (30) | Fiscal Period year | |
YEAR_FLAG | VARCHAR2 | (1) | flag indicating whether it is year start | |
FISCAL_MONTH_START | DATE | start date for fiscal month | ||
FISCAL_MONTH_END | DATE | end date for fiscal month | ||
FISCAL_QTR_START | DATE | start date for fiscal quarter | ||
FISCAL_QTR_END | DATE | end date for fiscal quarter | ||
FISCAL_YEAR_START | DATE | start date for fiscal year | ||
FISCAL_YEAR_END | DATE | end date for fiscal year | ||
FISCAL_ROLL_YEAR_START | DATE | start date for rolling fiscal year | ||
PRE_FISCAL_MONTH_START | DATE | start date for previous fiscal month | ||
PRE_FISCAL_MONTH_END | DATE | end date for previous fiscal month end | ||
PRE_FISCAL_QTR_START | DATE | start date for previous fiscal quarter | ||
PRE_FISCAL_QTR_END | DATE | end date for previous fiscal quarter | ||
PRE_FISCAL_YEAR_START | DATE | start date for the previous fiscal year | ||
PRE_FISCAL_YEAR_END | DATE | end date for previous fiscal year | ||
PRE_FISCAL_ROLL_YEAR_START | DATE | start date for previous rolling year | ||
PRE_FISCAL_ROLL_YEAR_END | DATE | end date for previous rolling year |
Cut, paste (and edit) the following text to query this object:
SELECT TRDATE
, YEAR
, QTR
, MONTH
, QTR_NUM
, MONTH_NUM
, SECURITY_GROUP_ID
, FISCAL_MONTH
, MONTH_FLAG
, FISCAL_QTR
, QTR_FLAG
, FISCAL_YEAR
, YEAR_FLAG
, FISCAL_MONTH_START
, FISCAL_MONTH_END
, FISCAL_QTR_START
, FISCAL_QTR_END
, FISCAL_YEAR_START
, FISCAL_YEAR_END
, FISCAL_ROLL_YEAR_START
, PRE_FISCAL_MONTH_START
, PRE_FISCAL_MONTH_END
, PRE_FISCAL_QTR_START
, PRE_FISCAL_QTR_END
, PRE_FISCAL_YEAR_START
, PRE_FISCAL_YEAR_END
, PRE_FISCAL_ROLL_YEAR_START
, PRE_FISCAL_ROLL_YEAR_END
FROM BIM.BIM_INTL_DATES;
BIM.BIM_INTL_DATES does not reference any database object
BIM.BIM_INTL_DATES is referenced by following:
|
|
|