1. Tables and Views for SCM
  2. MSC_ST_LOCATIONS

MSC_ST_LOCATIONS

The table is the staging table for MSC_OCATIONS that contains the list of locations and the region mapped to it.

Details

  • Schema: FUSION

  • Object owner: MSC

  • Object type: TABLE

  • Tablespace: INTERFACE

Columns

Name Datatype Length Precision Not-null Comments
SR_LOCATION_ID NUMBER 18 Source value of Location id if any
LOCATION_TYPE VARCHAR2 1 Identifies if the location is internal or external.
DELETED_FLAG NUMBER 1 Flag that indicates the logical deletion of the location 1 ??? Yes (deleted), 2 ??? No (Not deleted)
SR_REGION_ID NUMBER 18 Source value of Region id if any
LOCATION_CODE VARCHAR2 240 Unique identifier for Location for a given source instance.
DESCRIPTION VARCHAR2 2000 Description of the associated location
ADDRESS1 VARCHAR2 240 First line of the Identifying address
ADDRESS2 VARCHAR2 240 Second line of the Identifying address
ADDRESS3 VARCHAR2 240 Third line of the identifying address
ADDRESS4 VARCHAR2 240 Fourth line of the Identifying address
FLOOR_NUMBER VARCHAR2 40 This is the floor number part of the address.
BUILDING VARCHAR2 240 Specific building name or number at a given address
CITY VARCHAR2 60 City of the Identifying address
STATE VARCHAR2 60 State name of the customer/supplier site location address.
PROVINCE VARCHAR2 60 Province part of the customer/supplier site location address.
COUNTY VARCHAR2 60 County where this address belongs.
POSTAL_CODE VARCHAR2 60 Postal code part of the customer/supplier site location address.
COUNTRY_CODE VARCHAR2 2 Country where this address belongs.
ADDRESS_EFFECTIVE_DATE DATE Date when the location is valid
ADDRESS_EXPIRATION_DATE DATE Date when the location is no longer valid
REGION_NAME VARCHAR2 240 Region name to be mapped to this location
PARENT_REGION_NAME_1 VARCHAR2 360 Name of the parent region in the hierarchy
PARENT_REGION_NAME_2 VARCHAR2 360 Name of the parent region in the hierarchy
PARENT_REGION_NAME_3 VARCHAR2 360 Name of the parent region in the hierarchy
PARENT_REGION_NAME_4 VARCHAR2 360 Name of the parent region in the hierarchy
PARENT_REGION_NAME_5 VARCHAR2 360 Name of the parent region in the hierarchy
PARENT_REGION_NAME_6 VARCHAR2 360 Name of the parent region in the hierarchy
PARENT_REGION_NAME_7 VARCHAR2 360 Name of the parent region in the hierarchy
PARENT_REGION_NAME_8 VARCHAR2 360 Name of the parent region in the hierarchy
REFRESH_NUMBER NUMBER 18 Refresh Number is the Cycle id of collections
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.
PROCESS_FLAG NUMBER Process Flag indicates the status of records during pre-processing. 1- Compete Record, 2- Error Record, 3- Warning Record, 4- Retry Record, 5- New Record.
SR_INSTANCE_CODE VARCHAR2 30 The value indicates the source system code from where the data is collected.
ERROR_TEXT VARCHAR2 2000 Error text for functional validation errors in the record
ERROR_CODE VARCHAR2 150 Error code for functional validation errors in the record
RETRY_COUNT NUMBER Retry count. Used during planning collection when the record fails to get loaded into ODS.
LOAD_REQUEST_ID NUMBER Loads the request id of job that inserted the data.
TIMEZONE_CODE VARCHAR2 64 Stores the time zone code for the location
LOCATION_NAME VARCHAR2 240 Stores the concatenation of Location Name and Alternate Location Code
SR_LOCATION_CODE VARCHAR2 150 Stores the name of the location