MSC_CUSTOMERS

This table Stores the data for Customers.

Details

• Schema: FUSION

• Object owner: MSC

• Object type: TABLE

• Tablespace: Default

Primary Key

Name	Columns
MSC_CUSTOMERS_PK	TP_ID

Columns

Name	Datatype	Length	Precision	Not-null	Comments
TP_ID	NUMBER		18	Yes	Sequence Generated
COMPANY_ID	NUMBER		18		company identifier
DISABLE_DATE	DATE				Disable Date for the partner. This will be populated for Suppliers and Carriers only.
PARTY_ID	NUMBER				This column will not ne populated or used.
PARTNER_NAME	VARCHAR2	360		Yes	this column stores customer Name
PARTNER_TYPE	NUMBER				Partner type. Always 2 for customers
STATUS	NUMBER				Status ??? 1 - Active, 2 - Inactive.
PARTNER_NUMBER	VARCHAR2	360			Customer party number
MODELLING_ORG_ID	NUMBER		18		Org_id if the supplier is modeled as an organization.This is not needed for Carriers.
CUSTOMER_TYPE	VARCHAR2	30			Customer type. Not needed for Supplier and Carriers
CUSTOMER_CLASS_CODE	VARCHAR2	30			Stores the customer class code of a customer
REFRESH_NUMBER	NUMBER				Refresh Number
LAST_UPDATE_DATE	TIMESTAMP			Yes	Who column: indicates the date and time of the last update of the row.
LAST_UPDATED_BY	VARCHAR2	64		Yes	Who column: indicates the user who last updated the row.
CREATION_DATE	TIMESTAMP			Yes	Who column: indicates the date and time of the creation of the row.
CREATED_BY	VARCHAR2	64		Yes	Who column: indicates the user who created the row.
LAST_UPDATE_LOGIN	VARCHAR2	32			Who column: indicates the session login associated to the user who last updated the row.

Foreign Keys

Table	Foreign Table	Foreign Key Column
msc_customer_sites	msc_customers	PARTNER_ID

Indexes

Index	Uniqueness	Tablespace	Columns
MSC_CUSTOMERS_N1	Non Unique	Default	PARTNER_NUMBER
MSC_CUSTOMERS_N2	Non Unique	Default	UPPER("PARTNER_NAME")
MSC_CUSTOMERS_U1	Unique	Default	TP_ID