1. Tables and Views for SCM
  2. MSC_ST_PARAMETERS

MSC_ST_PARAMETERS

staging table for msc_parameters

Details

  • Schema: FUSION

  • Object owner: MSC

  • Object type: TABLE

  • Tablespace: INTERFACE

Columns

Name Datatype Length Precision Not-null Comments
SOURCE_INSTANCE_ID NUMBER 18 Source system identifier for the organization record.
DEFAULT_INCL_PLAN_BULK NUMBER 1 Default the Bulk supply type to be included in planning. Valid values are 1(Yes) and 2(No). If value is null then it should be treated as 1(Yes) for backward compatibility.
DEFAULT_INCL_PLAN_SUPPLIER NUMBER 1 Default the Supplier supply type to be included in planning. Valid values are 1(Yes) and 2(No). If value is null then it should be treated as 1(Yes) for backward compatibility.
ORGANIZATION_CODE VARCHAR2 18 Short alphanumeric code to identify the Organization.
ORGANIZATION_ID NUMBER 18 This column indicates the organization identifier.
PARTNER_ID NUMBER 18 This value indicates the trading partner identifier generated during planning collections.
ORGANIZATION_NAME VARCHAR2 240 This column indicates the organization name.
DEMAND_TIME_FENCE_FLAG NUMBER Flag to indicate whether to use the demand time fence. The Demand Time Fence is defined at the item level
PLANNING_TIME_FENCE_FLAG NUMBER Planning time fence code of the inventory item.
OPERATION_SCHEDULE_TYPE NUMBER This value indicates OPERATION_SCHEDULE_TYPE.
CONSIDER_WIP NUMBER Flag to Indicate whether to consider WIP
CONSIDER_PO NUMBER Flag to Indicate whether to consider PO
SNAPSHOT_LOCK NUMBER Snapshot lock specified for the organization.
PLAN_SAFETY_STOCK NUMBER This value indicates the plan safety stock value for the organization.
PART_INCLUDE_TYPE NUMBER This value indicates the part inclusion type for the organization.
DEFAULT_ABC_ASSIGNMENT_GROUP VARCHAR2 240 Indicates the default ABC assignment group
CONSIDER_RESERVATIONS NUMBER Flag to Indicate whether to consider reservations
DISABLE_DATE DATE Disable date of the organization.
STATUS NUMBER Status of the organizations collected from source system.
MASTER_ORGANIZATION_CODE VARCHAR2 240 This column indicates the master organization code name.
MASTER_ORGANIZATION_ID NUMBER 18 This column indicates the master organization identifier.
PROJECT_REFERENCE_ENABLED NUMBER This flag indicates whether the project reference is enabled. 1-Yes, 2-No.
PROJECT_CONTROL_LEVEL NUMBER This value indicates the update date of the program.
DEFAULT_ATP_RULE_NAME VARCHAR2 240 Indicates the default ATP rule name
DEFAULT_DEMAND_CLASS VARCHAR2 240 Indicates the default demand class
PLANNING_ENABLED_FLAG NUMBER Planning enabled flag for the organization.
MODELED_CUSTOMER_NAME VARCHAR2 240 This is the organization that is modeled as a customer.
MODELED_CUSTOMER_SITE_CODE VARCHAR2 240 This is the organization that is modeled as a customer site.
MODELED_SUPPLIER_NAME VARCHAR2 240 This is the organization that is modeled as a supplier.
MODELED_SUPPLIER_SITE_CODE VARCHAR2 240 This is the organization that is modeled as a supplier site.
CALENDAR_CODE VARCHAR2 22 CALENDAR_CODE of the given Calendar
CALENDAR_EXCEPTION_SET_ID NUMBER 18 Unique id for the calendar exception set
OPERATING_UNIT NUMBER This value indicates OPERATING_UNIT.
DEMAND_LATENESS_COST NUMBER Cost incurred when the demand is met late.
SUPPLIER_CAP_OVERUTIL_COST NUMBER Supplier capacity overutilization cost specified as per ASL agreements.
RESOURCE_CAP_OVERUTIL_COST NUMBER Resource capacity overutilization cost of the organization.
MODELED_CUSTOMER_ID NUMBER 18 This is the organization that is modeled as a customer.
MODELED_CUSTOMER_SITE_ID NUMBER 18 This is the organization that is modeled as a customer site.
MODELED_SUPPLIER_ID NUMBER 18 This is the organization that is modeled as a supplier.
MODELED_SUPPLIER_SITE_ID NUMBER 18 This is the organization that is modeled as a supplier site.
TRANSPORT_CAP_OVER_UTIL_COST NUMBER Transport capacity over utilization cost value.
USE_PHANTOM_ROUTINGS NUMBER This flag indicates whether phantom routings can be used during manufacturing.
INHERIT_PHANTOM_OP_SEQ NUMBER Flag indicates whether phantom option operation sequence number is inherited.
DEFAULT_ATP_RULE_ID NUMBER 18 Indicates the default ATP rule id
COMPANY_ID NUMBER 18 Unique id assigned to the company
ORG_SUPPLIER_MAPPED VARCHAR2 1 This value indicates whether the organization is mapped to the supplier.
ACCEPT_DEMANDS_FROM_UNMET_PO NUMBER Flag indicates whether to accept demands from unmet PO for supplier modeled org. 1-Yes, 2-No.
INHERIT_OC_OP_SEQ_NUM NUMBER Flag indicates whether option class operation sequence number is inherited.
SR_BUSINESS_GROUP_ID NUMBER 18 This value indicates the source side business group identifier.
SR_LEGAL_ENTITY NUMBER Source side value of the legal entity of the organization.
SR_SET_OF_BOOKS_ID NUMBER Source side value of the Set of Books identifier.
SR_CHART_OF_ACCOUNTS_ID NUMBER Source side value of the chart of accounts identifier.
BUSINESS_GROUP_NAME VARCHAR2 240 Business group for the organization record.
LEGAL_ENTITY_NAME VARCHAR2 240 This column indicates the Legal name for the entity.
OPERATING_UNIT_NAME VARCHAR2 240 This value indicates OPERATING_UNIT_NAME.
REPETITIVE_HORIZON1 NUMBER Repetitive horizon 1 of the organization.
REPETITIVE_HORIZON2 NUMBER Repetitive horizon 2 of the organization.
REPETITIVE_BUCKET_SIZE1 NUMBER Repetitive bucket size 1 of the organization.
REPETITIVE_BUCKET_SIZE2 NUMBER Repetitive bucket size 2 of the organization.
REPETITIVE_BUCKET_SIZE3 NUMBER Repetitive bucket size 3 of the organization.
REPETITIVE_ANCHOR_DATE DATE Repetitive anchor date of the organization.
COLLECTED_FLAG NUMBER Flag indicating whether the row is collected from source application instance
NETWORK_SCHEDULING_METHOD NUMBER This column indicates the method used for network scheduling.
INCLUDE_PAST_DUE_FORECAST NUMBER Indicates whether to include past due forecast
NET_ON_HAND NUMBER This value indicates the Net onhand defined for the organization.
REFRESH_NUMBER NUMBER Refresh identifier populated by the collection program.
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.
MATERIAL_ACCOUNT NUMBER This value indicates the material account for the organization.
EXPENSE_ACCOUNT NUMBER Expense account of the organization.
ORGANIZATION_TYPE NUMBER This value indicates the type of organization.
SERVICE_LEVEL NUMBER Service level specified in the shipping method.
CUSTOMER_CLASS_CODE VARCHAR2 30 Stores the customer class code of a customer
CURRENCY_CODE VARCHAR2 30 Currency associated with amounts
WEIGHT_UOM VARCHAR2 30 This value indicates the unit of measure defined in terms of weight.
MAXIMUM_WEIGHT NUMBER This value indicates the maximum weight set.
VOLUME_UOM VARCHAR2 30 This value indicates the unit of measure defined in terms of volume.
MAXIMUM_VOLUME NUMBER This value indicates the maximum volume set.
PERIOD_TYPE NUMBER This value indicates the period type of the organization.
RESCHED_ASSUMPTION NUMBER This value indicates the reschedule assumption of the organization.
PLAN_DATE_DEFAULT_TYPE NUMBER Plan date default type specified for the organization.
INCLUDE_REP_SUPPLY_DAYS NUMBER Flag indicates whether to include repetitive supply days for an organization.
INCLUDE_MDS_DAYS NUMBER Indicates whether to include MDS days
PAST_DUE_SO_DAYS NUMBER 9 This value indicates the number of days prior to the plan start date uptill which the shipped sales orders will be collected.
DELETED_FLAG NUMBER Flag indicating whether this is a deleted record
SR_INSTANCE_ID NUMBER 18 Identifier of the source system from where the data is collected.
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 retries to process failed records.
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.
SR_INSTANCE_CODE VARCHAR2 30 Source Instance code from which data is being populated.
CUST_ACCOUNT_NUMBER VARCHAR2 30 Account number associated to the customer
PARTY_SITE_NUMBER VARCHAR2 30 Unique party site number generated on the source system for the trading partner site.
OPERATION_TYPE VARCHAR2 2 This value indicates OPERATION_TYPE value.
PAST_DUE_FORECAST_DAYS NUMBER The number of days of past due forecasts to include in plans. No value indicates include all past due forecasts; zero indicates include no past due forecasts. This value does not apply to independent demands derived from assemble-to-order models.
BUSINESS_UNIT_NAME VARCHAR2 240 Business Unit of the Organization.
LOAD_REQUEST_ID NUMBER contains the request id of job that loaded the data
INVENTORY_FLAG NUMBER Flag to indicate if organization is inventory organization(1) or item Organization (2)
PLANT_FLAG NUMBER Flag to indicate if the organization is a manufacturing plant. 1- Yes, 2 -No.
PAST_DUE_SUPPLY_DAYS NUMBER 9 This value indicates the past due supply days value for the organization.
TIMEZONE_CODE VARCHAR2 64 Stores the time zone code for the organization
USE_CUST_FOR_XFER_FLAG NUMBER 1 This column helps collections to identify the customer and customer-site to use for transfer org scenario.
SUBINV_PLANNING_ENABLED NUMBER Indicates if the org is enabled for sub inventory level planning.
ORG_GROUP VARCHAR2 30 Name of the organization group.
ENABLE_IOT_FLAG NUMBER 1 Contains one of the following values: 1 or 2. If 1, then the plant is integrated to Oracle Internet of Things Cloud Service. If 2, then the plant is not integrated.
COLLECT_NONNETTABLE_PAR_SUBINV NUMBER Indicates whether to collect item subinventories for PAR enabled non-nettable subinventories.
CUTOFF_TIME NUMBER This column stores the shipping cut off time of respective organization in minutes. The value ranges from 0 to (24*60) -1
PICK_PACK_LEAD_TIME NUMBER This column stores the Pick Pack Lead time of the respective organization in days.