CMR_PO_EVENTS

This table is used to record all event notifications that PRC has to send to Costing. The Purchase Order's PO_HEADER_ID, the date of the event and the type of the event are recorded as part of the PRC event.

Details

• Schema: FUSION

• Object owner: FUSION

• Object type: TABLE

• Tablespace: Default

Primary Key

Name	Columns
CMR_PO_EVENTS_PK	PO_HEADER_ID, EVENT_DATE

Columns

Name	Datatype	Length	Precision	Not-null	Comments
PO_HEADER_ID	NUMBER		18	Yes	Purchase order head identifier and references to {PO_HEADERS_ALL.PO_HEADER_ID}.
EVENT_DATE	TIMESTAMP			Yes	Contains the date timestamp when the event occurred on the PO
EVENT_TYPE	VARCHAR2	30		Yes	Contains the type of the event notification
PROCESS_FLAG	VARCHAR2	1		Yes	Flag used to track the transfer of the PO to Costing.
CREATED_BY	VARCHAR2	64		Yes	Who column: indicates the user who created the row.
CREATION_DATE	TIMESTAMP			Yes	Who column: indicates the date and time of the creation of the row.
LAST_UPDATED_BY	VARCHAR2	64		Yes	Who column: indicates the user who last updated the row.
LAST_UPDATE_DATE	TIMESTAMP			Yes	Who column: indicates the date and time of the last update of the row.
LAST_UPDATE_LOGIN	VARCHAR2	32			Who column: indicates the session login associated to the user who last updated the row.

Indexes

Index	Uniqueness	Tablespace	Columns
CMR_PO_EVENTS_U1	Unique	Default	PO_HEADER_ID, EVENT_DATE