CMK_APPLICATION

Details

Schema: FUSION
Object owner: CMK
Object type: TABLE
Tablespace: FUSION_TS_TX_DATA

Primary Key

Name	Columns
CMK_APPL_PARTNERS_PK	APPL_PARTNER_ID

Columns

Name	Datatype	Length	Precision	Not-null	Comments
APPL_PARTNER_ID	NUMBER		18	Yes	Primary key of the Application Partner.
APPL_PARTNER_STATUS	VARCHAR2	100			Application Partner Status.
APPL_PARTNER_STATUS_DATE	TIMESTAMP				Application Partner Status Date and Time.
PARTNER_KEY_TYPE	VARCHAR2	100		Yes	Application specific partner key types e.g. Legal Entity, Supplier Site.
PARTNER_KEY1	VARCHAR2	256		Yes	Name of the Logical Entity Property that identifies the Partner.
PARTNER_KEY2	VARCHAR2	256			The name of the Logical Entity property that contains the second part of a multi-part key that identifies the Partner (if any).
PARTNER_KEY3	VARCHAR2	512			The name of the Logical Entity property that contains the third part of a multi-part key that identifies the Partner (if any).
PARTNER_KEY4	VARCHAR2	512			Partner Key 4 Value of Partner Key Type.
PARTNER_KEY5	VARCHAR2	512			Partner Key 5 Value of Partner Key Type.
PARTNER_KEY6	VARCHAR2	256			Partner Key 6 Value of Partner Key Type.
PARTNER_KEY7	VARCHAR2	256			Partner Key 7 Value of Partner Key Type.
PARTNER_KEY8	VARCHAR2	256			Partner Key 8 Value of Partner Key Type.
SERVICE_REQ_ID	NUMBER		18		An automatically generated Request ID assigned by the framework when a setup request is made to a Service Provider.
REQUEST_DATE	TIMESTAMP				Request Data and Time.
PARTNER_ID	VARCHAR2	256			ID of the Partner.
PARTNER_ID_TYPE	VARCHAR2	100			The type of ID e.g. DUNS.
PROC_ACTION_CODE	VARCHAR2	256			Processing Action Code
DVM_GROUP	VARCHAR2	256			DVM Group
CONFIG_DATA1	VARCHAR2	256			Configuration Data 1 to be Business Unit for Customer.
CONFIG_DATA2	VARCHAR2	256			Configuration Data 2 to be data for Customer configuration.
CONFIG_DATA3	VARCHAR2	256			Configuration Data 3 to be data for Customer configuration.
CONFIG_DATA4	VARCHAR2	256			Configuration Data 4 to be data for Customer configuration.
CONFIG_DATA5	VARCHAR2	256			Configuration Data 5 to be data for Customer configuration.
CONFIG_DATA6	VARCHAR2	256			Configuration Data 6 to be data for Customer configuration.
EXTERNAL_PARTNER_ID	NUMBER		18		Foreign key to External Parrtner.
SERVICE_PROVIDER_ID	NUMBER		18	Yes	Foreign key to the Service Provider.
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.
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.

Foreign Keys

Table	Foreign Table	Foreign Key Column
CMK_APPLICATION_PARTNERS	cmk_external_partners	EXTERNAL_PARTNER_ID
CMK_APPLICATION_PARTNERS	cmk_service_providers_b	SERVICE_PROVIDER_ID
cmk_appl_partner_docs	cmk_application_partners	APPL_PARTNER_ID

Indexes

Index	Uniqueness	Tablespace	Columns	Status
CMK_APPL_PARTNERS_U1	Unique	FUSION_TS_TX_IDX	APPL_PARTNER_ID
CMK_APPL_PARTNERS_U2	Unique	FUSION_TS_TX_IDX	PARTNER_KEY_TYPE, PARTNER_KEY1, PARTNER_KEY2, PARTNER_KEY3, SERVICE_PROVIDER_ID	Obsolete
CMK_APPL_PARTNERS_U3	Unique	FUSION_TS_TX_IDX	PARTNER_KEY_TYPE, PARTNER_KEY1, PARTNER_KEY2, PARTNER_KEY3, SERVICE_PROVIDER_ID, EXTERNAL_PARTNER_ID