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