PJS_UNIT_INFO
This table contains persistent information about all project units for use in summarization.
Details
-
Schema: FUSION
-
Object owner: PJS
-
Object type: TABLE
-
Tablespace: FUSION_TS_SUMMARY
Columns
Name | Datatype | Length | Precision | Not-null | Comments | Status |
---|---|---|---|---|---|---|
PROJECT_UNIT_ID | NUMBER | 18 | Project unit ID | Active | ||
FUN_CURRENCY_CODE | VARCHAR2 | 3 | Project functional currency code | Active | ||
FUN_CURRENCY_MAU | NUMBER | Project functional currency minimum accounting unit | Active | |||
GL_CALENDAR_ID | NUMBER | 18 | Time dimension calendar ID | Active | ||
GL_CALENDAR_MIN_DATE | DATE | Start date of the earliest period for the GL calendar | Active | |||
GL_CALENDAR_MAX_DATE | DATE | End date of the latest period for the GL calendar | Active | |||
GL_FIRST_PERIOD_ID | NUMBER | 18 | Contains the earliest summarized PA period | Active | ||
GL_FIRST_PERIOD_NAME | VARCHAR2 | 100 | Contains the earliest summarized GL period | Active | ||
GL_FIRST_START_DATE | DATE | The start date of the earliest period for the GL calendar for the PU | Active | |||
GL_FIRST_END_DATE | DATE | The end date of the latest period for the GL calendar for the PU | Active | |||
GL_CURR_REP_PERIOD_ID | NUMBER | 18 | Current reporting GL period | Active | ||
PA_CALENDAR_ID | NUMBER | 18 | Time dimension calendar ID | Active | ||
PA_CALENDAR_MIN_DATE | DATE | Start date of the earliest period for the PA calendar | Active | |||
PA_CALENDAR_MAX_DATE | DATE | End date of the latest period for the PA calendar | Active | |||
PA_FIRST_PERIOD_ID | NUMBER | 18 | Contains the earliest summarized PA period | Active | ||
PA_FIRST_PERIOD_NAME | VARCHAR2 | 100 | Contains the earliest summarized PA period | Active | ||
PA_FIRST_START_DATE | DATE | The start date of the earliest period for the PA calendar for the PU | Active | |||
PA_FIRST_END_DATE | DATE | The end date of the latest period for the PA calendar for the PU | Active | |||
PA_CURR_REP_PERIOD_ID | NUMBER | 18 | Current reporting PA period | Active | ||
LAST_UPDATE_DATE | TIMESTAMP | Yes | Who column: indicates the date and time of the last update of the row. | Active | ||
LAST_UPDATED_BY | VARCHAR2 | 64 | Yes | Who column: indicates the user who last updated the row. | Active | |
CREATION_DATE | TIMESTAMP | Yes | Who column: indicates the date and time of the creation of the row. | Active | ||
CREATED_BY | VARCHAR2 | 64 | Yes | Who column: indicates the user who created the row. | Active | |
LAST_UPDATE_LOGIN | VARCHAR2 | 32 | Who column: indicates the session login associated to the user who last updated the row. | Active |