CMR_PERIOD_STATUSES_S_GT

Temporary table used within the distribution processor to get the period statuses from Receipt Accounting and GL. Both period statuses are used to validate the that the transactions for which the distributions are created fall in an open period.

Details

• Schema: FUSION

• Object owner: CMR

• Object type: TABLE

• Tablespace: Default

Columns

Name	Datatype	Length	Precision	Comments
BUSINESS_UNIT_ID	NUMBER		18	Business Unit for which the period statuses are defined.
PERIOD_NAME	VARCHAR2	15		Period name identifying the period.
STATUS_CODE	VARCHAR2	30		Status of the period in receipt accounting.
PERIOD_START_DATE	DATE			Indicates receipt accounting period start date.
PERIOD_END_DATE	DATE			Indicates receipt accounting period end date.
GL_APPLICATION_ID	NUMBER		18	Application for which the GL Period status is stored. For now this is always GL (101).
GL_LEDGER_ID	NUMBER		18	Ledger (corresponding to the bill to business unit) for which the GL period status is stored.
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 of 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.

Indexes

Index	Uniqueness	Columns
CMR_PERIOD_STATUSES_GT_N1	Non Unique	BUSINESS_UNIT_ID, PERIOD_START_DATE, PERIOD_END_DATE
CMR_PERIOD_STATUSES_GT_N2	Non Unique	GL_LEDGER_ID, PERIOD_NAME