MSC_CUSTOMER_SITES

This table stores information about customer sites

Details

  • Schema: FUSION

  • Object owner: MSC

  • Object type: TABLE

  • Tablespace: TRANSACTION_TABLES

Primary Key

Name Columns

MSC_CUSTOMER_SITES_PK

PARTNER_SITE_ID

Columns

Name Datatype Length Precision Not-null Comments
PARTNER_SITE_ID NUMBER 18 Yes Sequence generated on the Dest Side
SR_TP_SITE_ID NUMBER 18 Customer site id in the source side
SR_INSTANCE_ID NUMBER 18 Source instance identifier
PARTNER_ID NUMBER 18 Yes Customer Id in the destination side
PARTNER_NAME VARCHAR2 1600 Customer Name
PARTNER_ADDRESS VARCHAR2 1600 Site address of the customer
TP_SITE_CODE VARCHAR2 30 Vendor site code for Customer Sites
SR_TP_ID NUMBER 18 Customer id in the source side
LOCATION VARCHAR2 60 location
LOCATION_ID NUMBER 18 location id
PARTNER_TYPE NUMBER Yes 2-Customer
DELETED_FLAG NUMBER Deleted_flag
LONGITUDE NUMBER 10 Longitude
LATITUDE NUMBER 10 Latitude
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.
ATTRIBUTE_CATEGORY VARCHAR2 30 Descriptive Flexfield: structure definition of the user descriptive flexfield.
ATTRIBUTE1 VARCHAR2 150 Descriptive Flexfield: segment of the user descriptive flexfield.
ATTRIBUTE2 VARCHAR2 150 Descriptive Flexfield: segment of the user descriptive flexfield.
ATTRIBUTE3 VARCHAR2 150 Descriptive Flexfield: segment of the user descriptive flexfield.
ATTRIBUTE4 VARCHAR2 150 Descriptive Flexfield: segment of the user descriptive flexfield.
ATTRIBUTE5 VARCHAR2 150 Descriptive Flexfield: segment of the user descriptive flexfield.
ATTRIBUTE6 VARCHAR2 150 Descriptive Flexfield: segment of the user descriptive flexfield.
ATTRIBUTE7 VARCHAR2 150 Descriptive Flexfield: segment of the user descriptive flexfield.
ATTRIBUTE8 VARCHAR2 150 Descriptive Flexfield: segment of the user descriptive flexfield.
ATTRIBUTE9 VARCHAR2 150 Descriptive Flexfield: segment of the user descriptive flexfield.
ATTRIBUTE10 VARCHAR2 150 Descriptive Flexfield: segment of the user descriptive flexfield.
ATTRIBUTE11 VARCHAR2 150 Descriptive Flexfield: segment of the user descriptive flexfield.
ATTRIBUTE12 VARCHAR2 150 Descriptive Flexfield: segment of the user descriptive flexfield.
ATTRIBUTE13 VARCHAR2 150 Descriptive Flexfield: segment of the user descriptive flexfield.
ATTRIBUTE14 VARCHAR2 150 Descriptive Flexfield: segment of the user descriptive flexfield.
ATTRIBUTE15 VARCHAR2 150 Descriptive Flexfield: segment of the user descriptive flexfield.
OPERATING_UNIT_NAME VARCHAR2 240 OPERATING_UNIT_NAME
COUNTRY VARCHAR2 60 Country
STATE VARCHAR2 150 state
CITY VARCHAR2 60 city
POSTAL_CODE VARCHAR2 60 Postal Code
SHIPPING_CONTROL VARCHAR2 14 SHIPPING_CONTROL
TIMEZONE_CODE VARCHAR2 64 Stores the time zone code for the customer site

Foreign Keys

Table Foreign Table Foreign Key Column
MSC_CUSTOMER_SITES msc_customers PARTNER_ID

Indexes

Index Uniqueness Tablespace Columns
MSC_CUSTOMER_SITES_N1 Non Unique Default PARTNER_ID
MSC_CUSTOMER_SITES_U1 Unique Default PARTNER_SITE_ID
MSC_CUSTOMER_SITES_U2 Unique Default TP_SITE_CODE, PARTNER_TYPE, PARTNER_ID