CE_CP_OPTIONS_

This table contains the cash positioning and forecasting data extraction start date.

Details

• Schema: FUSION

• Object owner: CE

• Object type: TABLE

• Tablespace: FUSION_TS_TX_DATA

Primary Key

Name	Columns
CE_CP_OPTIONS_PK_	LAST_UPDATE_DATE, LAST_UPDATED_BY, CP_OPTION_ID

Columns

Name	Datatype	Length	Precision	Not-null	Comments
CP_OPTION_ID	NUMBER		18	Yes	Primary key of the table. A unique identifier of CE_CP_OPTIONS.
BALANCE_DATE_THRESHOLD	NUMBER		18		The number of days before a bank statement is reported missing for a bank account.
DEFAULT_TRANSACTION_CALENDAR	NUMBER		18		The calendar assigned to transactions used in cash positioning and forecasting.
EXTRACTION_DURATION	VARCHAR2	30			Duration in which the cash positioning and forecasting extraction will be taken. For example, Last 2 years or Last 3 years.
REPORTING_CURRENCY	VARCHAR2	15			Reporting currency used by cash positioning and forecasting data extraction to convert and store the amount in the cube.
BALANCE_CODE	VARCHAR2	30			The reporting balance type code chosen by user. It is based on CE_INTERNAL_BALANCE_CODES lookup code.
LAST_UPDATE_DATE	TIMESTAMP			Yes	Who column: indicates the date and time of the last update of the row.
LAST_UPDATED_BY	VARCHAR2	64		Yes	Who column: indicates the user who last updated the row.
LAST_UPDATE_LOGIN	VARCHAR2	32			Who column: indicates the session login associated to the user who last updated the row.
CREATION_DATE	TIMESTAMP				Who column: indicates the date and time of the creation of the row.
CREATED_BY	VARCHAR2	64			Who column: indicates the user who created the row.
OBJECT_VERSION_NUMBER	NUMBER		9		Used to implement optimistic locking. This number is incremented every time that the row is updated. The number is compared at the start and end of a transaction to detect whether another session has updated the row since it was queried.
REPORTING_CONVERSION_TYPE	VARCHAR2	30			The conversion rate type used to convert cash postion fact amount from bank account currency to reporting currency.
WEEKLY_EXTRACT_FLAG	VARCHAR2	1			Indicates whether weekly or monthly period frequency calendar is used to aggregate cash flows for Predictive Cash Forecasting.
WEEKLY_CALENDAR_ID	NUMBER		18		The unique identifier of the weekly accounting calendar. This attribute is used when weekly periodic forecast is selected. Null value indicates that user has selected monthly calendar.
PCF_SETUP_FLAG	VARCHAR2	1			Indicates whether the current record is defined for Predictive Cash Forecasting or Cash Positioning and Forecasting data extract options. This is an internal attribute.
AUDIT_ACTION_TYPE_	VARCHAR2	10			Action Type - have values like INSERT, UPDATE and DELETE.
AUDIT_CHANGE_BIT_MAP_	VARCHAR2	1000			Used to store a bit map of 1s and 0s for each column in the table.
AUDIT_IMPERSONATOR_	VARCHAR2	64			Original Impersonator User.

Indexes

Index	Uniqueness	Tablespace	Columns
CE_CP_OPTIONS_N1_	Non Unique	Default	CP_OPTION_ID
CE_CP_OPTIONS_U1_	Unique	FUSION_TS_TX_DATA	LAST_UPDATE_DATE, LAST_UPDATED_BY, CP_OPTION_ID