Module: Common
Type: Dimension
| Name | Datatype | Length | Precision | Not Null | Comments | Referred Table | Referred Column |
|---|---|---|---|---|---|---|---|
| FISCAL_PERIOD_SET_NAME | VARCHAR2 | 16 | Fiscal Period Set Name | ||||
| FISCAL_PERIOD_TYPE | VARCHAR2 | 16 | Fiscal Period Type | ||||
| FISCAL_YEAR_NUMBER | NUMBER | 38 | 0 | Fiscal Year Number | |||
| SOURCE_RECORD_ID | VARCHAR2 | 72 | Source Record Id | ||||
| ACCOUNTING_CAL_FLAG | VARCHAR2 | 16 | Accounting Cal Flag | ||||
| CALENDAR_TYPE_CODE | VARCHAR2 | 32 | Calendar Type Code | ||||
| CURRENT_FISCAL_YEAR_CODE | VARCHAR2 | 16 | Current Fiscal Year Code | ||||
| FISCAL_TRAILING_YEAR_NUMBER | NUMBER | 38 | 0 | Fiscal Trailing Year Number | |||
| FISCAL_YEAR_END_DATE | DATE | 0 | Fiscal Year End Date | ||||
| FISCAL_YEAR_END_DATE_ID | NUMBER | 38 | 0 | Fiscal Year End Date ID | |||
| FISCAL_YEAR_START_DATE | DATE | 0 | Fiscal Year Start Date | ||||
| FISCAL_YEAR_START_DATE_ID | NUMBER | 38 | 0 | Fiscal Year Start Date ID | |||
| FISCAL_YEAR_TOTAL_DAYS | NUMBER | 38 | 0 | Fiscal Year Total Days | |||
| FISCAL_YEAR_TOTAL_WEEKS | NUMBER | 38 | 0 | Fiscal Year Total Weeks | |||
| NUMBER_PER_FISCAL_YEAR | NUMBER | 38 | 0 | Number Per Fiscal Year | |||
| YEAR_END_OR_PRV_CRNT_DATE | DATE | 0 | Year End Or Prv Crnt Date | ||||
| YEAR_END_OR_PRV_CRNT_DATE_ALT | DATE | 0 | Year End Or Prv Crnt Date Alt | ||||
| W$_INSERT_DT | TIMESTAMP | 0 | 6 | ||||
| W$_UPDATE_DT | TIMESTAMP | 0 | 6 |