Skip to content

DBA Data[Home] [Help] [Dependency Information]

TABLE: BIM.BIM_INTL_DATES

Object Details
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


Storage Details
Tablespace: TablespaceAPPS_TS_TX_DATA
PCT Free: 10
PCT Used:
Indexes
Index Type Uniqueness Tablespace Column
BIM_INTL_DATES_N1 NORMAL NONUNIQUE TablespaceAPPS_TS_TX_IDX ColumnTRDATE
Columns
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
Query Text

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;

Dependencies

[top of page]

BIM.BIM_INTL_DATES does not reference any database object

BIM.BIM_INTL_DATES is referenced by following:

SchemaAPPS
SynonymBIM_INTL_DATES