POZ_SUPPLIER_INT_REJECTIONS

Details

Schema: FUSION
Object owner: POZ
Object type: TABLE
Tablespace: INTERFACE

Primary Key

Name	Columns
POZ_SUPPLIER_INT_REJECTIONS_PK	REJECTION_ID

Columns

Name	Datatype	Length	Precision	Not-null	Comments
REJECTION_ID	NUMBER		18	Yes	Rejection identifier
PARENT_TABLE	VARCHAR2	30		Yes	Reference to table in which the rejection occurred
PARENT_ID	NUMBER		18	Yes	Reference to supplier or site or contact identifier which was rejected
REJECT_LOOKUP_CODE	VARCHAR2	2000		Yes	Supplier or site or contact rejection reason
APP_NAME	VARCHAR2	50		Yes	Application name
ATTRIBUTE	VARCHAR2	30			This column will display the attribute that has caused the import to fail for the concerned record
VALUE	VARCHAR2	2000			This column will display the value that the user provided for the attribute that failed
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.
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.
TOKEN1_NAME	VARCHAR2	100			Token name
TOKEN1_VALUE	VARCHAR2	360			Token value
TOKEN2_NAME	VARCHAR2	100			Token name
TOKEN2_VALUE	VARCHAR2	360			Token value
TOKEN3_NAME	VARCHAR2	100			Token name
TOKEN3_VALUE	VARCHAR2	360			Token value
TOKEN4_NAME	VARCHAR2	100			Token name
TOKEN4_VALUE	VARCHAR2	360			Token value
TOKEN5_NAME	VARCHAR2	100			Token name
TOKEN5_VALUE	VARCHAR2	360			Token value
TOKEN6_NAME	VARCHAR2	100			Token name
TOKEN6_VALUE	VARCHAR2	360			Token value
OBJECT_VERSION_NUMBER	NUMBER		9	Yes	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.
REQUEST_ID	NUMBER		18		Enterprise Service Scheduler: indicates the request ID of the job that created or last updated the row.
JOB_DEFINITION_NAME	VARCHAR2	100			Enterprise Service Scheduler: indicates the name of the job that created or last updated the row.
JOB_DEFINITION_PACKAGE	VARCHAR2	900			Enterprise Service Scheduler: indicates the package name of the job that created or last updated the row.

Indexes

Index	Uniqueness	Tablespace	Columns
POZ_SUPPLIER_INT_REJECTIONS_N1	Non Unique	Default	REQUEST_ID, PARENT_ID
POZ_SUPPLIER_INT_REJECTIONS_PK	Unique	Default	REJECTION_ID