This appendix covers the following topics:
The following table shows the setup data control files.
Business Object | Flat File Loader's File Name Option | Control Files |
---|---|---|
Bill of Materials | Bills of Material Headers | MSC_ST_BOMS.ctl |
Bill of Materials | Bills of Material Components | MSC_ST_BOM_COMPONENTS.ctl |
Bill of Materials | Component Substitutes | MSC_ST_COMPONENT_SUBSTITUTES.ctl |
Items | Items | MSC_ST_SYSTEM_ITEMS.ctl |
Routings | Routings | MSC_ST_ROUTINGS.ctl |
Routings | Routing Operations | MSC_ST_ROUTING_OPERATIONS.ctl |
Routing | Operation Resources | MSC_ST_OPERATION_RESOURCES.ctl |
Resources | Resources | MSC_ST_DEPARTMENT_RESOURC.ctl ES |
Resource | Resource Availability | MSC_ST_RESOURCE_CHANGES.ctl |
Resource | Resource Shifts | MSC_ST_RESOURCE_SHIFTS.ctl |
Resource | Resource Groups | MSC_ST_RESOURCE_GROUPS.ctl |
Projects and tasks | Project Tasks | MSC_ST_PROJECT_TASKS.ctl |
Unit of Measure | Units of Measure | MSC_ST_UNITS_OF_MEASURE.ctl |
Unit of Measure | Units of Measure Class Conversions | MSC_ST_UOM_CLASS_CONVERSIONS.ctl |
Unit of Measure | Units of Measure Conversions | MSC_ST_UOM_CONVERSIONS.ctl |
Item Categories | Category Sets | MSC_ST_CATEGORY_SETS.ctl |
Item Categories | Item Categories | MSC_ST_ITEM_CATEGORIES.ctl |
Sourcing Rules | Item Sourcing | MSC_ST_ITEM_SOURCING.ctl |
Sourcing Rules | Inter Org Shipment Method | MSC_ST_INTERORG_SHIP_METHODS.ctl |
Calendars | Calendars | MSC_ST_CALENDARS.ctl |
Calendar | Workday Patterns | MSC_ST_WORKDAY_PATTERNS.ctl |
Calendar | Shift Times | MSC_ST_SHIFT_TIMES.ctl |
Calendar | Calendar Exceptions | MSC_ST_CALENDAR_EXCEPTIONS.ctl |
Calendar | Shift Exceptions | MSC_ST_SHIFT_EXCEPTIONS.ctl |
Resource Demand | Resource Requirements | MSC_ST_RESOURCE_REQUIREMENTS.ctl |
Supplier Capacity | Item Suppliers | MSC_ST_ITEM_SUPPLIERS.ctl |
Supplier Capacity | Supplier Capacities | MSC_ST_SUPPLIER_CAPACITIES.ctl |
Supplier Capacity | Supplier Flex Fences | MSC_ST_SUPPLIER_FLEX_FENCES.ctl |
Trading Partners | Trading Partners | MSC_ST_TRADING_PARTNERS.ctl |
Trading Partners | Trading Partner Sites | MSC_ST_TRADING_PARTNER_SITES.ctl |
Trading Partners | Location Associations | MSC_ST_LOCATION_ASSOCIATIONS.ctl |
Trading Partners | Sub Inventories | MSC_ST_SUB_INVENTORIES.ctl |
Supply Chain People | Partner Contacts | MSC_ST_PARTNER_CONTACTS.ctl |
Demand Class | Demand Class | MSC_ST_DEMAND_CLASSES.ctl |
The following table shows the control files for supplies.
Business Object | Flat File Loader's File Name Option | Control Files |
---|---|---|
Work Order | Work Order Supplies | MSC_ST_SUPPLIES_WO.ctl |
Requisitions | Requisition Supplies | MSC_ST_SUPPLIES_REQ.ctl |
On hand | On-hand Supplies | MSC_ST_SUPPLIES_ONHAND.ctl |
Intransit | Intransit Supplies | MSC_ST_SUPPLIES_INTRANSIT.ctl |
Purchase Order | Purchase Order Supplies | MSC_ST_SUPPLIES_PO.ctl |
Supply forecast | Plan Order Supplies | MSC_ST_SUPPLIES_PLAN_ORDERS.ctl |
Supply forecast | Plan Order Designators | MSC_ST_DESIGNATORS_PLAN_ORDERS.ctl |
The following table shows demand control files.
Business Object | Flat File Loader's File Name Option | Control Files |
---|---|---|
Sales Orders | Sales Order Demands | MSC_ST_SALES_ORDERS.ctl |
Demand Forecast | Forecast Demands | MSC_ST_DEMANDS_FORECAST.ctl |
Demand Forecast | Forecast Designators | MSC_ST_DESIGNATORS_FORECAST.ctl |
Master Demand Schedule | Demand Schedule Demands | MSC_ST_DEMANDS_MDS.ctl |
Master Demand Schedule | Demand Schedule Designators | MSC_ST_DESIGNATORS_MDS.ctl |
Work Order Component Demand | Work Order Component Demands | MSC_ST_DEMANDS_WORK_ORDER.ctl |
Safety Stocks | Safety Stocks | MSC_ST_SAFETY_STOCKS.ctl |
Reservations | Reservations | MSC_ST_RESERVATIONS.ctl |
COMPANY_NAME is required only if SCE is installed. For standalone APS, this is defaulted to -1.
The following table shows user-defined keys (UDK's) for various business objects.
Business Object | Table | User-Defined Key (UDK) |
---|---|---|
Item | MSC_ST_SYSTEM_ITEMS | SR_INSTANCE_CODE, ORGANIZATION_CODE, ITEM_NAME, COMPANY_NAME |
BOM | MSC_ST_BOMS | SR_INSTANCE_CODE, ORGANIZATION_CODE, BOM_NAME (defaulted from ASSEMBLY_NAME if Null), ASSEMBLY_NAME, ALTERNATE_BOM_DESIGNATOR (null allowed), COMPANY_NAME |
BOM | MSC_ST_BOM_COMPONENTS | SR_INSTANCE_CODE, ORGANIZATION_CODE, BOM_NAME (defaulted from ASSEMBLY_NAME if Null), ASSEMBLY_NAME, ALTERNATE_BOM_DESIGNATOR (can be null), OPERATION_SEQ_CODE (if null or character would be defaulted to 1), COMPONENT_NAME, EFFECTIVITY_DATE, DISABLE_DATE (can be null), COMPANY_NAME |
BOM | MSC_ST_COMPONENT_SUBSTITUTES | SR_INSTANCE_CODE, ORGANIZATION_CODE, BOM_NAME (defaulted from ASSEMBLY_NAME if Null), ASSEMBLY_NAME, ALTERNATE_BOM_DESIGNATOR (can be null), OPERATION_SEQ_CODE (if null or character would be defaulted to 1), COMPONENT_NAME, SUB_ITEM_NAME, COMPANY_NAME |
Categories | MSC_ST_CATEGORY_SETS | SR_INSTANCE_CODE, CATEGORY_SET_NAME, COMPANY_NAME |
Categories | MSC_ST_ITEM_CATEGORIES | SR_INSTANCE_CODE, ORGANIZATION_CODE, CATEGORY_SET_NAME, CATEGORY_NAME, ITEM_NAME, COMPANY_NAME |
UOM | MSC_ST_UNITS_OF_MEASURE | UOM_CODE, UNIT_OF_MEASURE (if null would be defaulted by UOM_CODE), COMPANY_NAME |
UOM | MSC_ST_UOM_CLASS_CONVERSIONS | ITEM_NAME, FROM_UOM_CODE, FROM_UNIT_OF_MEASURE (defaulted from FROM_UOM_CODE if null), TO_UOM_CODE, TO_UNIT_OF_MEASURE, (defaulted from TO_UOM_CODE if null) COMPANY_NAME |
UOM | MSC_ST_UOM_CONVERSIONS | ITEM_NAME, UOM_CODE, UNIT_OF_MEASURE (defaulted from UOM_CODE if null), COMPANY_NAME |
Demand Class | MSC_ST_DEMAND_CLASSES | SR_INSTANCE_CODE DEMAND_CLASS, COMPANY_NAME, |
Resources | MSC_ST_DEPARTMENT_RESOURCES | SR_INSTANCE_CODE, ORGANIZATION_CODE, RESOURCE_CODE, DEPARTMENT_CODE, COMPANY_NAME |
Resources | MSC_ST_RESOURCE_SHIFTS | SR_INSTANCE_CODE, ORGANIZATION_CODE, RESOURCE_CODE, DEPARTMENT_CODE, SHIFT_NAME, COMPANY_NAME |
Resources | MSC_ST_RESOURCE_CHANGES | SR_INSTANCE_CODE, ORGANIZATION_CODE, RESOURCE_CODE, DEPARTMENT_CODE, SHIFT_NUM, FROM_DATE, TO_DATE, FROM_TIME, TO_TIME, SIMULATION_SET, ACTION_TYPE, COMPANY_NAME |
Resources | MSC_ST_RESOURCE_GROUPS | SR_INSTANCE_CODE, COMPANY_NAME, GROUP_CODE |
Routings | MSC_ST_ROUTINGS | SR_INSTANCE_CODE, ORGANIZATION_CODE, ROUTING_NAME (defaulted from ASSEMBLY_NAME if Null), ASSEMBLY_NAME, ALTERNATE_ROUTING_DESIGNATOR (can be null), COMPANY_NAME |
Routings | MSC_ST_ROUTING_OPERATIONS | SR_INSTANCE_CODE, ORGANIZATION_CODE, ROUTING_NAME (defaulted from ASSEMBLY_NAME if Null), ASSEMBLY_NAME, OPERATION_SEQ_CODE (if null or character would be defaulted to 1), ALTERNATE_ROUTING_DESIGNATOR (can be null), EFFECTIVITY_DATE, DISABLE_DATE, COMPANY_NAME |
Routings | MSC_ST_OPERATION_RESOURCES | SR_INSTANCE_CODE, ORGANIZATION_CODE, ROUTING_NAME (defaulted from ASSEMBLY_NAME if Null), ASSEMBLY_NAME, OPERATION_SEQ_CODE (if null or character would be defaulted to 1), RESOURCE_SEQ_CODE (if null or character would be defaulted to 1), RESOURCE_CODE, ALTERNATE_ROUTING_DESIGNATOR (can be null), ALTERNATE_NUMBER (can be null), COMPANY_NAME |
Calendar | MSC_ST_CALENDARS | SR_INSTANCE_CODE, CALENDAR_CODE, COMPANY_NAME |
Calendar | MSC_ST_CALENDAR_EXCEPTIONS | SR_INSTANCE_CODE, CALENDAR_CODE, EXCEPTION_DATE, COMPANY_NAME |
Calendar | MSC_ST_WORKDAY_PATTERNS | SR_INSTANCE_CODE, CALENDAR_CODE, SHIFT_NAME, COMPANY_NAME |
Calendar | MSC_ST_SHIFT_TIMES | SR_INSTANCE_CODE, CALENDAR_CODE, SHIFT_NAME, FROM_TIME, TO_TIME, COMPANY_NAME |
Calendar | MSC_ST_SHIFT_EXCEPTIONS | SR_INSTANCE_CODE, CALENDAR_CODE, SHIFT_NAME, EXCEPTION_DATE, COMPANY_NAME |
Material Supply (PO) | MSC_ST_SUPPLIES | SR_INSTANCE_CODE, ORDER_NUMBER, PURCH_LINE_NUM, ORDER_TYPE = 1(PO),8(PO Recv.), COMPANY_NAME |
Material Supply (Req.) | MSC_ST_SUPPLIES | SR_INSTANCE_CODE, ORDER_NUMBER, PURCH_LINE_NUM, ORDER_TYPE = 2, COMPANY_NAME |
Material Supply (WO- Discrete/ Flow) | MSC_ST_SUPPLIES | SR_INSTANCE_CODE, ORDER_TYPE (3 - Discrete job, 7 - Non-standard job, 27-Flow schedule), WIP_ENTITY_NAME, COMPANY_NAME |
Material Supply (WO- By Products) | MSC_ST_SUPPLIES | SR_INSTANCE_CODE, ORDER_TYPE (14 -Discrete job by-product, 15 -Nonstandard job by-product), ITEM_NAME, WIP_ENTITY_NAME, ORDER_NUMBER, (if null defaulted by WIP_ENTITY_NAME if null), OPERATION_SEQ_CODE (if null or character would be defaulted to 1), COMPANY_NAME |
Material Supply (Plan Orders) | MSC_ST_SUPPLIES | SR_INSTANCE_CODE, ORDER_TYPE = 5 (Plan Orders), ORGANIZATION_CODE, SCHEDULE_DESIGNATOR, SCHEDULE_LINE_NUM (or order number), COMPANY_NAME |
Material Supply (Plan Orders) | MSC_ST_DESIGNATORS | DESIGNATOR, ORGANIZATION_CODE, SR_INSTANCE_CODE, COMPANY_NAME |
Material Supply (On Hand) | MSC_ST_SUPPLIES | SR_INSTANCE_CODE, ORDER_TYPE = 18, ITEM_NAME, ORGANIZATION_CODE, SUBINVENTORY_CODE (can be null), LOT_NUMBER (can be null), PROJECT_NUMBER (can be null), TASK_NUMBER (can be null), UNIT_NUMBER (can be null), COMPANY_NAME |
Material Supply (Intransit) | MSC_ST_SUPPLIES | SR_INSTANCE_CODE, ORDER_NUMBER, PURCH_LINE_NUM, ORDER_TYPE = 11 (Intransit), 12 - (Intransit Receipt), COMPANY_NAME |
Material Demand (Sales Orders) | MSC_ST_SALES_ORDERS | SR_INSTANCE_CODE, SALES_ORDER_NUMBER, LINE_NUM, ORGANIZATION_CODE, COMPANY_NAME |
Material Demand (WO- Discrete) | MSC_ST_DEMANDS | WIP_ENTITY_NAME, ITEM_NAME, OPERATION_SEQ_CODE (if null or character would be defaulted to 1), SR_INSTANCE_CODE, ORIGINATION_TYPE = 2 (Non Standard), 3 (Standard), ORGANIZATION_CODE, COMPANY_NAME |
Material Demand (Master Demand Schedule) | MSC_ST_DEMANDS | ITEM_NAME, DEMAND_SCHEDULE_NAME, SCHEDULE_LINE_NUM (Null allowed - in case of item not being demanded on the same date more than once), ORIGINATION_TYPE = 8 (MDS), ORGANIZATION_CODE SR_INSTANCE_CODE SCHEDULE_DATE, COMPANY_NAME |
Material Demand (Master Demand Schedule) | MSC_ST_DESIGNATORS | DESIGNATOR, ORGANIZATION_CODE, SR_INSTANCE_CODE, DESIGNATOR_TYPE =(1,2), COMPANY_NAME |
Material Demand (Forecast) | MSC_ST_DEMANDS | ITEM_NAME, FORECAST_DESIGNATOR, SCHEDULE_LINE_NUM (Null allowed - in case of item not being demanded on the same date more than once), ORIGINATION_TYPE = 29 (Forecast), ORGANIZATION_CODE, SR_INSTANCE_CODE, SCHEDULE_DATE, COMPANY_NAME |
Material Demand (Forecast) | MSC_ST_DESIGNATORS | DESIGNATOR, FORECAST_SET, ORGANIZATION_CODE, SR_INSTANCE_CODE, DESIGNATOR_TYPE =6, COMPANY_NAME |
Safety Stocks | MSC_ST_SAFETY_STOCKS | SR_INSTANCE_CODE, COMPANY_NAME, ORGANIZATION_CODE, ITEM_NAME, PERIOD_START_DATE |
Reservations | MSC_ST_RESERVATIONS | SR_INSTANCE_CODE, COMPANY_NAME, SALES_ORDER_NUMBER, LINE_NUM, ORGANIZATION_CODE |
Resource Demand | MSC_ST_RESOURCE_REQUIREMENTS | WIP_ENTITY_NAME, ITEM_NAME, OPERATION_SEQ_CODE (if null or character would be defaulted to 1), SR_INSTANCE_CODE, ORGANIZATION_CODE, DEPARTMENT_CODE, RESOURCE_CODE, COMPANY_NAME |
Supplier Capacity | MSC_ST_ITEM_SUPPLIERS | SR_INSTANCE_CODE, ORGANIZATION_CODE, VENDOR_NAME, VENDOR_SITE_CODE, ITEM_NAME, COMPANY_NAME |
Supplier Capacity | MSC_ST_SUPPLIER_CAPACITIES | SR_INSTANCE_CODE, ORGANIZATION_CODE, VENDOR_NAME, VENDOR_SITE_CODE, ITEM_NAME, FROM_DATE, COMPANY_NAME |
Supplier Capacity | MSC_ST_SUPPLIER_FLEX_FENCES | SR_INSTANCE_CODE, ORGANIZATION_CODE, VENDOR_NAME, VENDOR_SITE_CODE, ITEM_NAME, FENCE_DAYS, COMPANY_NAME |
Trading Partners | MSC_ST_TRADING_PARTNERS | SR_INSTANCE_CODE, PARTNER_NAME PARTNER_TYPE (1 - supplier, 2 - customer), COMPANY_NAME |
Trading Partners | MSC_ST_TRADING_PARTNER_SITES | PARTNER_NAME, SR_INSTANCE_CODE, PARTNER_TYPE (1 - supplier, 2 - customer), TP_SITE_CODE, COMPANY_NAME |
Trading Partners | MSC_ST_LOCATION_ASSOCIATIONS | PARTNER_NAME, SR_INSTANCE_CODE PARTNER_TYPE SR_TP_CODE LOCATION_CODE, ORGANIZATION_CODE, COMPANY_NAME |
Trading Partners | MSC_ST_SUB_INVENTORIES | ORGANIZATION_CODE SR_INSTANCE_CODE SUBINVENTORY_CODE, COMPANY_NAME |
Trading Partners | MSC_ST_PARTNER_CONTACTS | PARTNER_NAME, SR_INSTANCE_CODE, PARTNER_TYPE, TP_SITE_CODE, COMPANY_NAME, NAME (A partner site can have only one contact) |
Organizations | MSC_ST_TRADING_PARTNERS | ORGANIZATION_CODE, SR_INSTANCE_CODE, PARTNER_TYPE (3 - organizations), COMPANY_NAME |
Sourcing Rules | MSC_ST_INTER_ORG_SHIP_METHODS | SR_INSTANCE_CODE FROM_ORGANIZATION_CODE, TO_ORGANIZATION_CODE, SHIP_METHOD, COMPANY_NAME, |
Sourcing Rules | MSC_ST_ITEM_SOURCING | SR_INSTANCE_CODE, ITEM_NAME (null allowed), CATEGORY_NAME (null allowed), SOURCING_RULE_NAME (null allowed), ASSIGNMENT_NAME (null allowed), RECEIPT_ORGANIZATION_CODE (null allowed if global sourcing), SOURCE_ORGANIZATION_CODE, SOURCE_PARTNER_CODE (either one of source organization code or partner code can be null), SOURCE_PARTNER_SITE_CODE (null allowed), EFFECTIVE_DATE, COMPANY_NAME |
Projects & Tasks | MSC_ST_PROJECT_TASKS | SR_INSTANCE_CODE, ORGANIZATION_CODE, PROJECT_NAME, TASK_NAME (can be null if only project information is to be provided), COMPANY_NAME |