1. Tables and Views for SCM
  2. MSC_ST_LOCATION_ASSOCIATIONS

MSC_ST_LOCATION_ASSOCIATIONS

'The staging table used by the collection program to validate and process data for MSC_LOCATION_ASSOCIATIONS

Details

  • Schema: FUSION

  • Object owner: MSC

  • Object type: TABLE

  • Tablespace: INTERFACE

Columns

Name Datatype Length Not-null Comments
ORGANIZATION_CODE VARCHAR2 18 Short alphanumeric code to identify the Organization.
DEFAULT_FLAG NUMBER Flag indicates whether the location is a default location. 1-Yes, 2-No.
LOCATION_CODE VARCHAR2 240 Code of Internal Location associated with the Organization
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.
LOCATION_ID NUMBER Location id mapped to this site
REFRESH_NUMBER NUMBER Refresh identifier populated by the collection program.
SITE_ID NUMBER This value indicates the Trading partner site identifier.
SITE_TYPE NUMBER Site type of the trading partner. 1-Supplier site, 2-Customer site, 3-Organization.
SR_INSTANCE_CODE VARCHAR2 30 The value indicates the source system code from where the data is collected.
DELETED_FLAG NUMBER Flag that indicates the logical deletion of the region 1 ??? Yes (deleted), 2 ??? No (Not deleted).
ERROR_CODE VARCHAR2 150 Error code for functional validation errors in the record.
ERROR_TEXT VARCHAR2 2000 Concatenated error messages for functional errors in this record.
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.
RETRY_COUNT NUMBER Number of times this record was retried in retry cycles
LOAD_REQUEST_ID NUMBER This stores the job id of request that loaded the data.