POZ_SUP_CONTACT_ADDRESSES

Details

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

Primary Key

Name	Columns
POZ_SUP_CONT_ADDR_INT_PK	CONTACT_ADDRESS_INTERFACE_ID

Columns

Name	Datatype	Length	Precision	Not-null	Comments
CONTACT_ADDRESS_INTERFACE_ID	NUMBER		18	Yes	Supplier contact address interface record unique identifier.
BATCH_ID	VARCHAR2	200			An optional identifier, if provided while scheduling an import process is used to identify which interface table records will be picked up for processing.
VENDOR_INTERFACE_ID	NUMBER		18		Supplier interface record identifier.
VENDOR_ID	NUMBER		18		Supplier unique identifier. The value can be obtained from the VENDOR_ID column in the POZ_SUPPLIERS table.
VENDOR_NAME	VARCHAR2	360			Supplier name unique identifier.
CONTACT_INTERFACE_ID	NUMBER		18		Contact interface record identifier.
ADDRESS_INTERFACE_ID	NUMBER		18		Address interface record identifier.
PER_PARTY_ID	NUMBER		18		Identifies the specific supplier contact.
IMPORT_STATUS	VARCHAR2	30			Status of the record before or after import. Initially, the status is set to 'NEW' and after processing, the status is turned to 'PROCESSED' or 'REJECTED' based on the outcome.
IMPORT_ACTION	VARCHAR2	10			Indicates whether the contact address association record is to be created or deleted via import. Valid import actions: CREATE/ DELETE
FIRST_NAME	VARCHAR2	150			First name of contact.
LAST_NAME	VARCHAR2	150			Last name of contact.
EMAIL_ADDRESS	VARCHAR2	320			E-mail address for contact.
PARTY_SITE_ID	NUMBER		18		Supplier address unique identifier.
PARTY_SITE_NAME	VARCHAR2	240			Indicates the supplier address name to which the contact should be associated.
PROGRAM_APP_NAME	VARCHAR2	50			Program application name.
REQUEST_SOURCE	VARCHAR2	15			Signifies whether the request is from import or through a web service. Valid values are IMPORT or WEB_SERVICE. Null value for this column is also treated as a request from import.
REQUEST_ID	NUMBER		18		Enterprise Service Scheduler: indicates the request ID of the job that created or last updated the row.
LOAD_REQUEST_ID	NUMBER		18		Indicates the id of the job that loaded the rows into the interface table. This is used when initial data is made available via a spreadsheet.
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.
LAST_UPDATE_DATE	TIMESTAMP				Who column: indicates the date and time of the last update of the row.
LAST_UPDATED_BY	VARCHAR2	64			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.
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.
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.

Indexes

Index	Uniqueness	Tablespace	Columns
POZ_SUP_CONT_ADDR_INT_N1	Non Unique	Default	REQUEST_ID
POZ_SUP_CONT_ADDR_INT_N2	Non Unique	Default	VENDOR_INTERFACE_ID
POZ_SUP_CONT_ADDR_INT_N3	Non Unique	Default	CONTACT_INTERFACE_ID
POZ_SUP_CONT_ADDR_INT_N4	Non Unique	Default	ADDRESS_INTERFACE_ID
POZ_SUP_CONT_ADDR_INT_N5	Non Unique	Default	UPPER("BATCH_ID"), CONTACT_ADDRESS_INTERFACE_ID
POZ_SUP_CONT_ADDR_INT_PK	Unique	Default	CONTACT_ADDRESS_INTERFACE_ID