1. Tables and Views for SCM
  2. CMR_PERIOD_STATUSES_GT

CMR_PERIOD_STATUSES_GT

This table contains the GL Period statuses for the Business Units used in Receipt Accounting and is a global temporary table.

Details

  • Schema: FUSION

  • Object owner: CMR

  • Object type: TABLE

  • Tablespace: Default

Columns

Name Datatype Length Precision Not-null Comments
SERVER_START_DATE DATE Yes Period start date in the server time zone.
SERVER_END_DATE DATE Yes Period end date in the server time zone.
LE_TIME_OFFSET NUMBER Yes LE time zone offset from UTC for the period end date.
END_DATE DATE Yes End date of the period derived from general ledger calendar.
START_DATE DATE Yes Start date of the period derived from general ledger calendar.
PERIOD_YEAR NUMBER 18 Yes Period year derived from general ledger calendar.
PERIOD_NUM NUMBER 18 Yes Period number derived from general ledger calendar.
STATUS_CODE VARCHAR2 30 Yes Period Status code for Receipt Accounting. N-Never Opened, O-Open, P-Pending Close, C-Closed, F-Permanently Closed.
PERIOD_NAME VARCHAR2 15 Yes Period Name derived from the general ledger calendar.
PERIOD_TYPE VARCHAR2 15 Yes Period type derived from general ledger calendar.
LEGAL_ENTITY_ID NUMBER 18 Yes Legal Entity associated to the BU.
LEDGER_ID NUMBER 18 Yes Unique identifier of the ledger derived from the business unit.
PERIOD_SET_NAME VARCHAR2 15 Yes Period set name derived from general ledger calendar.
BUSINESS_UNIT_ID NUMBER 18 Yes Business Unit for which the period statuses are defined.
GL_CLOSING_STATUS VARCHAR2 1 Indicates the GL period status.
NEXT_OPEN_PERIOD_NAME VARCHAR2 15 If the receipt accounting period is final closed, this is the name of next available open receipt accounting period.
NEXT_OPEN_PERIOD_START_DATE DATE If the receipt accounting period is final closed, this is the start date on the next available open receipt accounting period.
NEXT_OPEN_GL_CLOSING_STATUS VARCHAR2 1 The status of the GL period for the date in the next_open_period_start_date column.
NEXT_CMR_PERIOD_STATUS VARCHAR2 1 The status of the receipt accounting period for the date in the next_open_period_start_date column.
PROCESS_START_DATE DATE Used in the reports processor to store the date and time when the reports processor starts processing. This field is used in filtering the data until this date.