CMR_PRJ_INTF_ERRORS

This table keep records of error or info messages for transactions interfaced to projects.

Details

• Schema: FUSION

• Object owner: CMR

• Object type: TABLE

• Tablespace: FUSION_TS_TX_DATA

Primary Key

Name	Columns
CMR_PRJ_INTF_ERRORS_PK	CMR_PRJ_INTF_ERRORS_ID

Columns

Name	Datatype	Length	Precision	Not-null	Comments	Status
CMR_PRJ_INTF_ERRORS_ID	NUMBER			Yes	Unique identifier for records in this table.	Active
CMR_SUB_LEDGER_ID	NUMBER		18	Yes	The subledger id that is a foreign key from cmr_rcv_distributions	Active
DOCUMENT_ENTRY_CODE	VARCHAR2	10			The Document entry code for each transaction passed to projects.	Active
PJC_INTERFACE_TXN_ID	NUMBER				The unique identifier for transactions generated by projects after processing transactions on their side.	Active
PJC_INTERFACE_MESSAGE	VARCHAR2	900			The error or info message send by projects for each transaction interfaced to them visa cost collection service.	Active
CREATED_BY	VARCHAR2	64		Yes	Who column: indicates the user who created the row.	Active
CREATION_DATE	TIMESTAMP			Yes	Who column: indicates the date and time of the creation of the row.	Active
LAST_UPDATED_BY	VARCHAR2	64		Yes	Who column: indicates the user who last updated the row.	Active
LAST_UPDATE_DATE	TIMESTAMP			Yes	Who column: indicates the date and time of the last update of the row.	Active
LAST_UPDATE_LOGIN	VARCHAR2	32			Who column: indicates the session login associated to the user who last updated the row.	Active
REQUEST_ID	NUMBER		18		Enterprise Service Scheduler: indicates the request ID of the job that created or last updated the row.	Active
JOB_DEFINITION_NAME	VARCHAR2	100			Enterprise Service Scheduler: indicates the name of the job that created or last updated the row.	Active
JOB_DEFINITION_PACKAGE	VARCHAR2	900			Enterprise Service Scheduler: indicates the package name of the job that created or last updated the row.	Active

Foreign Keys

Table	Foreign Table	Foreign Key Column
CMR_PRJ_INTF_ERRORS	cmr_rcv_distributions	CMR_SUB_LEDGER_ID

Indexes

Index	Uniqueness	Tablespace	Columns	Status
CMR_PRJ_INTF_ERRORS_PK	Unique	FUSION_TS_TX_DATA	CMR_PRJ_INTF_ERRORS_ID	Active