CST_PRJ_INTF_ERRORS

This table keep records of error or info messges for transactions send to projects via cost collection services.

Details

• Schema: FUSION

• Object owner: CST

• Object type: TABLE

• Tablespace: FUSION_TS_INTERFACE

Primary Key

Name	Columns
CST_PRJ_INTF_ERRORS_PK	CST_PRJ_INTF_ERRORS_ID

Columns

Name	Datatype	Length	Precision	Not-null	Comments	Status
CST_PRJ_INTF_ERRORS_ID	NUMBER			Yes	Unique identifier for records in this table.	Active
DISTRIBUTION_LINE_ID	NUMBER		18		The distribution line id that is a foreign key from cst_cost_distribution_lines.	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
CST_PRJ_INTF_ERRORS	cst_cost_distribution_lines	DISTRIBUTION_LINE_ID

Indexes

Index	Uniqueness	Tablespace	Columns	Status
CST_PRJ_INTF_ERRORS_PK	Unique	FUSION_TS_INTERFACE	CST_PRJ_INTF_ERRORS_ID	Active