1. Tables and Views for SCM
  2. MSC_ST_BOR_SUBSTITUTES_INT

MSC_ST_BOR_SUBSTITUTES_INT

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

Details

  • Schema: FUSION

  • Object owner: MSC

  • Object type: TABLE

  • Tablespace: INTERFACE

Columns

Name Datatype Length Precision Comments
SR_INSTANCE_ID NUMBER 18 Identifier of the source application instance
SR_INSTANCE_CODE VARCHAR2 30 Alphanumeric code used to identify the source system.
ORGANIZATION_ID NUMBER 18 Organization Identifier to where the Bill of Resource is defined.
ORGANIZATION_CODE VARCHAR2 18 Short alphanumeric code to identify the organization to where the bill is defined.
PRODUCED_ITEM_ID NUMBER 18 Identifier of the item being produced.
PRODUCED_ITEM_NAME VARCHAR2 250 Name of the item Produced in Bill of Resources.
CONSUMED_ITEM_ID NUMBER 18 Identifier of the item being consumed.
CONSUMED_ITEM_NAME VARCHAR2 250 Name of the item being consumed.
EFFECTIVE_DATE DATE Effective start date for the component item or resource
DISABLE_DATE DATE Effective end date for the component item or resource
SOURCE_ORGANIZATION_ID NUMBER 18 Source organization identifier to where the component or resource is defined.
SOURCE_ORGANIZATION_CODE VARCHAR2 18 Short alphanumeric code to identify the organization to where the bill is defined.
SUBSTITUTE_COMP_ITEM_ID NUMBER 18 Identifier of the substitute item being consumed.
SUBSTITUTE_COMP_ITEM_NAME VARCHAR2 250 Name of the substitute item being consumed.
SUBSTITUTE_COMP_ITEM_PRIORITY NUMBER Substitution priority of the substitute consumed item.
SUBSTITUTE_COMP_QUANTITY NUMBER Quantity of the substitute consumed item.
WORK_CENTER_ID NUMBER 18 Work center Identifier for the resource
WORK_CENTER_CODE VARCHAR2 250 Alphanumeric code used to identify the work center to which the resource belongs.
RESOURCE_ID NUMBER 18 Identifier of the resource being consumed.
RESOURCE_CODE VARCHAR2 250 Alphanumeric code used to identify the resource.
BOR_ID NUMBER 18 Unique id for component or resource record from MSC_PLANNING_BOR.
ALTERNATE_WORK_CENTER_ID NUMBER 18 Alternate work center Identifier for the resource
ALTERNATE_WORK_CENTER_CODE VARCHAR2 250 Alphanumeric code used to identify the work center to which the alternate resource belongs.
ALTERNATE_RESOURCE_ID NUMBER 18 Identifier of the alternate resource being consumed.
ALTERNATE_RESOURCE_CODE VARCHAR2 250 Alphanumeric code used to identify the alternate resource.
ALTERNATE_RESOURCE_QUANTITY NUMBER Quantity of the alternate resource being consumed.
ALTERNATE_RESOURCE_PRIORITY NUMBER Substitution priority of the alternate resource consumed.
DELETED_FLAG NUMBER Indicates whether the row is no longer valid. If Yes, then this row is deleted from the planning table. Valid values are Yes, No. Default value is No.
REFRESH_NUMBER NUMBER Refresh identifier populated by the collection program.
PROCESS_FLAG NUMBER Processing Flag indicating the status of records during pre-processing. 1- New Record, 2- In-Process, 3- Error, 4- Propagated Error, 5- Successfully Processed.
LOAD_REQUEST_ID NUMBER Request Id of the job that will load the data.
ERROR_CODE VARCHAR2 150 Error code for functional validation errors in the record.
ERROR_TEXT VARCHAR2 2000 This will describe the reason for the error if any.
SUBSTITUTE_TYPE NUMBER Represents resource and component type. Valid values are 1 and 2. 1 represents 'Item' and 2 represents 'Resource'.
CREATED_BY VARCHAR2 64 Who column: indicates the user who created the row.
CREATION_DATE TIMESTAMP Who column: indicates the date and time of the creation of the row.
LAST_UPDATED_BY VARCHAR2 64 Who column: indicates the user who last updated the row.
LAST_UPDATE_DATE TIMESTAMP 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.
MASTER_BASIS_TYPE NUMBER Indicates whether the usage quantity of the primary component item or resource in the BillOfResources is fixed (e.g., quantity per lot produced) or variable (e.g., quantity per item produced).