[Home] [Help] [Dependency Information]
Object Name: | BSC_SYS_PERIODS_TL |
---|---|
Object Type: | TABLE |
Owner: | BSC |
FND Design Data: | BSC.BSC_SYS_PERIODS_TL |
Subobject Name: | |
Status: | VALID |
BSC_SYS_PERIODS_TL stores translated information about the periods. Each row includes values that identify the particular period such as year,periodicity identifier, period identifier, name and short name.
Tablespace: | APPS_TS_TX_DATA |
---|---|
PCT Free: | 10 |
PCT Used: |
Index | Type | Uniqueness | Tablespace | Column |
---|---|---|---|---|
BSC_SYS_PERIODS_TL_U1 | NORMAL | UNIQUE | APPS_TS_TX_IDX |
YEAR
PERIODICITY_ID PERIOD_ID MONTH LANGUAGE |
Name | Datatype | Length | Mandatory | Comments |
---|---|---|---|---|
YEAR | NUMBER | (4) | Yes | Year |
PERIODICITY_ID | NUMBER | (5) | Yes | Periodicity id |
PERIOD_ID | NUMBER | (5) | Yes | Period id |
MONTH | NUMBER | (5) | Yes | Month for PERIODICITY_ID = 8 or 10. MONTH =1 for Other periodicities |
LANGUAGE | VARCHAR2 | (4) | Yes | Language code |
SOURCE_LANG | VARCHAR2 | (4) | Yes | The Language the text will mirror. If text is not yet translated into LANGUAGE then any changes to the text in the source language row will be reflected here as well. |
NAME | VARCHAR2 | (90) | Period name (Max 30 Characters) | |
SHORT_NAME | VARCHAR2 | (45) | Period short Name (Max 15Characters) |
Cut, paste (and edit) the following text to query this object:
SELECT YEAR
, PERIODICITY_ID
, PERIOD_ID
, MONTH
, LANGUAGE
, SOURCE_LANG
, NAME
, SHORT_NAME
FROM BSC.BSC_SYS_PERIODS_TL;
BSC.BSC_SYS_PERIODS_TL does not reference any database object
BSC.BSC_SYS_PERIODS_TL is referenced by following:
|
|
|