RapidResponse (by Kinaxis) Integration Data

This document provides an overview of the RapidResponse requirements and the corresponding PlanetTogether features.

 

Introduction / Overview

The integration between RapidResponse (RR) and PlanetTogether (PT) allows the scheduling system to use current data when creating an optimal schedule. The data in RR is maintained in various tables and is compiled into worksheets for use by PlanetTogether. 

RapidResponse Requirements and Corresponding PlanetTogether Features:

RR Requirement PT Feature Description
Alternative Resource Resource Capabilities "Alternative Resources" are defined as resources capable of processing the same type of work.
Activity Status Internal Activities This includes production progress information that will be supplied by a Manufacturing Execution System (MES). 
Transfer Batching Operation Overlap This allows a successor operation to start before the predecessor operation is complete.
Helper Resources Resource Requirements Multiple additional pieces of equipment can be defined for each operation.
Number of People People Usage This specifies the number of people (crew) required to perform the task.
Capabilities Resource Capabilities Capabilities define what work a machine can perform. A machine can have multiple capabilities.
Resource-Specific Rates Product Rules A resource can have a standard Run Rate. That Run Rate can be overridden for a specific product being produced. 
Max Delay Max Delay Specifies the maximum amount of delay that can occur between operations.
Successor Processing Successor Manufacturing Orders This allows you to specify a relationship between two jobs requiring one job to complete prior to the next job starting. 
REST API REST API A REST-based set of APIs has been created to facilitate the automatic transfer of data between the two systems.
Default / Preferred Resources Default Resource This feature allows you to specify a specific resource to use even if multiple resources are capable and available.
Can Pause Can Pause When 'True', an operation can pause for an offline capacity interval. Otherwise, the operation will not schedule to start unless there is enough continuous online capacity to complete the task without pause.
Material Constraint Type Material Constraint Type

PlanetTogether allows for three types of Material Constraints:

1) Non-Constraint: There is unlimited availability of material.

2) Constrained by Available Date: The material must be physically available prior to the start of the scheduled work.

3) Constrained by Lead Time or Available Date: Allows you to schedule based on the lead time of unavailable material.

RapidResponse Worksheets Required:

  • PT_Alternate Paths: Header record for the Job's Route.
  • PT_AlternatePaths_Nodes: Detailed records for the Route's Operation steps.
  • PT_AttributeCodeTable: Header record that defines the Setup matrix.
  • PT_AttributeCodeTable_AssignedResources: Associates Resources with Setup matrices.
  • PT_AttributeCodeTable_AttributeCodes: The individual cells of the Setup matrix. 
  • PT_AttributeCodeTable_AttributeNames: The attributes to be included in the Setup matrix.
  • PT_Capabilities: Defines what work can be done by the resources.
  • PT_CapabilityAssignments: Associates Capabilities with Resources.
  • PT_Departments: Defines the groupings of Resources within a Plant.
  • PT_InternalActivities: Defines the "People Usage", "Nbr of People", and MES activity.
  • PT_Inventories: Defines the amount of an ITem in a particular Warehouse.
  • PT_Items: Defines the Item master.
  • PT_Jobs: Defines the Jobs (the highest level of our Order/Route hierarchy. Click here for additional information on Job Structure). 
  • PT_ManufacturingOrders: Defines a Product being produced and is the header for the route. 
  • PT_Materials: Defines the component materials being consumed by the operation.
  • PT_OperationAttributes: Defines the Attributes associated with an Operation (route step).
  • PT_Plants: Defines the Plants being scheduled.
  • PT_PlantWarehouses: Associates the Warehouses with the Plants.
  • PT_ProductRules: Allows for the override of Run Rates based on the Product being produced.
  • PT_Products: Defines the Products being produced.
  • PT_PurchaseOrders: Purchase Order Line items. There is no header record for these.
  • PT_RequiredCapabilities: Defines which Capabilities are required for each Operation.
  • PT_ResourceConnectors: Defines a relationship between two or more Resources.
  • PT_ResourceOperations: Schedulable Operation steps corresponding to Routing Steps.
  • PT_ResourceOperations_Attributes_LookupByCode: Identifies how an Attribute will incur Setup.
  • PT_ResourceRequirements: Specifies the type of machines needed at an Operation step.
  • PT_Resoures: Defines what Resources exist.
  • PT_SalesOrders: Header record for the Sales Order.
  • PT_SalesOrders_Lines: Detail record for the Sales Order Lines.
  • PT_SalesOrders_Lines_Distributions: Distributions of the Sales Order Lines.
  • PT_SuccessorManufacturingOrders: Defines a relationship between multiple Jobs or Manufacturing Orders.
  • PT_Warehouses: Defines the Warehouses available for production.
  • GAP_CONFIGURE_Attribute_Color: The association of Colors to Attribute Values for display on the Gantt. 

    Plants

    A Plant is defined as a facility where production occurs.

    Usage

    Used for display purposes and grouping of Departments. 

    PT Import Mappings

    "PT_Plants" corresponds to a Worksheet in RapidResponse that is used to define the data needed and mapped to PlanetTogether.

    RR Tables

    The Plant data is maintained in RR. The source data is in the existing "Site" table within RapidResponse. The Site data is imported as-is into PlanetTogether via the PT_Plant worksheet.

    Worksheet columns: ExternalId, Description, Name

    PlanetTogether

    In PlanetTogether, Plants appear on the upper-left corner of the Gantt View and in the Resource tab of the Scenario Data.

    Departments

    Departments represent groupings of resources that can be viewed together within a plant. These have no impact on scheduling and often correspond to ERP work center groups.

    Usage

    Used for display and grouping of Resources. Schedule Frozen Spans can also be manually set for individual Departments. 

    PT Import Mappings

    "PT_Departments" corresponds to a Worksheet in RapidResponse that is used to define the data needed and mapped to PlanetTogether.

    RR Tables

    The PT_Department worksheet is populated by the RapidResponse table “WorkCenter”.

    Worksheet columns: ExternalId, PlantExternalId, Description, Name

    PlanetTogether

    In PlanetTogether, Departments can be viewed at the top of the Gantt chart and from the Settings | Scenario Data | Resources tab. Selecting one of the Departments on the Gantt will show only the Resources found within that Department.

    Resources

    Resources represent people, machines, workstations, tools, or other equipment that is required to perform work. These can only belong to one department within a plant. Constraining a resource to a specific department does not affect schedule optimization. 

    Usage

    Used for display purposes. Also used to determine a resource's Capacity (Single-Tasking, Multi-Tasking, Infinite), whether multiples of this resource can be scheduled, and how Setup is calculated.

    RapidResponse Worksheet: PT_Resources

    RapidResponse Table: WorkCenter

    PT Import Mappings

    "PT_Resources" corresponds to a Worksheet in RapidResponse that is used to define the data needed and mapped to PlanetTogether.

    RR Tables

    The PT_Resources worksheet is populated by the RapidResponse table “WorkCenter”

    Worksheet columns: DepartmentExternalId, ExternalId, Name, PlantExternalId, CapacityType, Description, ImageFileName, NumberOfResources, ResourceType, SetupIncluded, ShowOnlyInDepartment, Sort

    PlanetTogether

    In PlanetTogether, Resources are listed to the left of the Gantt chart and are also found in the Resources tab of the Scenario Data. Note: The Resources listed in the grid are shown by Department.

                                 

    Capabilities

    A Capability defines what type of resource can do. In this case, the capabilities will correspond to a Work Center Group in RapidResponse. Resources can have multiple capabilities and capabilities can be linked to multiple resources.

    Usage

    Used as a constraint that determines what work can be performed on which resources. 

    PT Import Mappings

    "PT_Capabilities" corresponds to a Worksheet in RapidResponse that is used to define the data needed and mapped to PlanetTogether.

    RR Tables

    The PT_Capabilities worksheet is populated by the RapidResponse table “Capability (PT)”.

    Worksheet columns: ExternalId, Name, Description

    PlanetTogether

    In PlanetTogether, Capabilities are listed in the Scenario Data | Capabilities tab.

    Capability Assignments

    Capability Assignments refer to the link between capabilities and the resource they are assigned to.

    Usage

    The assignment of capabilities to resources is used as a constraint to specify which resources can process which work requirements.

    PT Import Mappings

    "PT_CapabilityAssignments" corresponds to a Worksheet in RapidResponse that is used to define the data needed and mapped to PlanetTogether.

    RR Tables

    The PT_CapabilityAssignments worksheet is populated by the RapidResponse table “CapabilityAssignment”.

    Worksheet columns: CapabilityExternalId, DepartmentExternalId, PlantExternalId, ResourceExternalId.

    PlanetTogether

    In the Capabilities tab, you can double click on a capability to see which resources are associated with it.

    Resource Connectors

    Resource connectors specify a flow relationship between two resources. This means that successor operations will only be scheduled to one of the connected resources.

    Usage:

    Used as a constraint to limit which downstream resources can be selected based on the scheduling of the current operation.

    PT Import Mappings

    "PT_ResourceConnectors" corresponds to a Worksheet in RapidResponse that is used to define the data needed and mapped to PlanetTogether. 

    RR Tables

    The PT_ResourceConnectors worksheet is populated by the RapidResponse table “ResourceConnectors”.

    Worksheet columns: DownstreamResourceDepartmentExternalId, DownstreamResourceExternalId, DownstreamResourcePlantExternalId, FixedTransitHrs, ResourceDepartmentExternalId, ResourceExternalId, ResourcePlantExternalId.

    PlanetTogether

    In PlanetTogether, resource connectors are listed in the Settings | Scenario Data | Resource Connectors tab.

    Product Rules

    Product Rules tie items to resources and override the standard production rates, yields, and preferences defined in the job operation. These provide additional flexibility for companies that have varying production planning values depending on the machine or labor personnel completing each operation.

    Usage:

    Used to override various constraint values associated with the rate of production. These include: Cycle Hours, Quantity Per Cycle, Post-Processing Hours, Material Post-Processing Hours, and Standard Setup Hours. 

    PT Import Mappings

    "PT_ProductRules" corresponds to a Worksheet in RapidResponse that is used to define the data needed and mapped to PlanetTogether.

    RR Tables

    The PT_ProductRules worksheet is populated by the RapidResponse table “ProductRules”.

    Worksheet columns: DepartmentExternalId, PlantExternalId, ResourceExternalId, CycleHrs, MaterialPostProcessingHrs, PostProcessingHrs, QtyPerCycle, SetupHrs, UseCycleHrs, UseMaterialPostProcessingSpan, UsePostProcessingHrs, UseQtyPerCycle, UseSetupHrs.

    PlanetTogether

    In PlanetTogether, Product Rules are listed in the Settings | Scenario Data | Product Rules tab. The top section of the screen shows a list of items and a list of resources while the bottom of the screen shows the list of defined product rules.

    Attribute Code Tables

    Attribute Code Tables are used to calculate Setup Cost and Time based on sequential Operation Attribute Code changes for specific resources.

    PT Import Mappings

    There are 4 tables that need to be mapped in the import mappings:

    • Attribute Code Table (Select From: PT_AttributeCodeTable)
    • Attribute Code Table Attribute Name (Select From: PT_AttributeCodeTable_AttributeNames)
    • Attribute Code Table Attribute Code (Select From: PT_AttributeCodeTable_AttributeCodes)
    • Attribute Code Table Assigned Resources (Select From: PT_AttributeCodeTable_AssignedResources)

    RR Tables

    • PT_AttributeCodeTable worksheet is populated by the RapidResponse table “GAP_GRID_AttributeCode"
      • Worksheet columns: TableName, Description
    • PT_AttributeCodeTable_AttributeNames worksheet is populated by the RapidResponse table "GAP_GRID_AttributeCode_Attributes"
      • Worksheet columns: AttributeName, TableName
    • PT_AttributeCodeTable_AttributeCodes worksheet is populated by the RapidResponse table "GAP_GRID_AttributeCode_FromTos"
      • Worksheet columns: AttributeName, NextOpAttributeCode, PreviousOpAttributeCode, SetupTime, TableName, SetupCost
    • PT_AttributeCodeTable_AssignedResources worksheet is populated by the RapidReponse table "GAP_GRID_AttributeCode_Resources"
      • Worksheet columns: DepartmentEcternalId, PlantExternalId, ResourceExternalId, TableName

    PlanetTogether

    Attribute Code Tables will appear in the "Setup Tables" tab of the Scenario Data.

    The assigned attribute code table will also appear in the "Setup/Changeover" tab of the Resource options.

    Items

    In PlanetTogether, Items represent the different Raw Materials, Intermediates, and Finished Goods that are being produced, stocked, and consumed by the manufacturer.

    Usage

    Used mainly for display purposes including information on Cost, Item Type (Raw, Sub, Finished Good), and Item Source (Purchased or Manufactured). However, an item must exist in order to be scheduled.

    PT Import Mappings

    "PT_Items" corresponds to a Worksheet in RapidResponse that is used to define the data needed and mapped to PlanetTogether.

    RR Tables

    The PT_Items worksheet is populated by the RapidResponse table “Part”.

    Worksheet columns: ExternalId, Cost, Description, ItemType, Name, Source, BatchSize, Flavor, PackSize, BarSize, MinOrderQty.

    PlanetTogether

    The Item Details can be found in the Inventory Plan view.

    Warehouses

    In PlanetTogether, warehouses represent storage facilities for both raw materials and finished goods. Every item coming into PlanetTogether must be linked to a warehouse.

    PT Import Mappings

    "PT_Warehouses" corresponds to a Worksheet in RapidResponse that is used to define the data needed and mapped to PlanetTogether.

    RR Tables

    The PT_Warehouses worksheet is populated by the RapidResponse table “Site”.

    Worksheet columns: ExternalId, Description, Name.

    PlanetTogether

    In the Inventory Plan, select an item from the inventory list and click on "Manage Inventory" to see its associated warehouse.

    Inventories

    Inventories provide information on the on-hand quantity of items as well as safety stock and lead time information.

    PT Import Mappings

    "PT_Inventories" corresponds to a Worksheet in RapidResponse that is used to define the data needed and mapped to PlanetTogether.

    RR Tables

    The PT_Inventories worksheet is populated by the RapidResponse table “Part”.

    Worksheet columns: ItemExternalId, WarehouseExternalId, LeadTimeDays, OnHandQty, SafetyStock.

    PlanetTogether

    In PlanetTogether, the inventory grid of the inventory plan view contains information about all inventory items, such as where those items are stored, any on-hand quantities, and total supplies and demands for that item.

    Sales Orders

    In PlanetTogether, Sales Orders generally represent customer orders for finished products.

    PT Import Mappings

    "PT_SalesOrders" corresponds to a Worksheet in RapidResponse that is used to define the data needed and mapped to PlanetTogether.

    RR Tables

    The PT_SalesOrders worksheet is populated by the RapidResponse table “SupplyDemand”.

    Worksheet columns: ExternalId, Name, Customer, Description, Notes.

    PlanetTogether

    Sales Orders are listed in the “Distributions” section of the Sales Orders view.

    Purchase Orders

    In PlanetTogether, Purchase Orders represent orders for additional materials to supply jobs.

    PT Import Mappings

    "PT_PurchaseOrders" corresponds to a Worksheet in RapidResponse that is used to define the data needed and mapped to PlanetTogether.

    RR Tables

    The PT_PurchaseOrders worksheet is populated by the RapidResponse table “SupplyDemand”.

    Worksheet columns: ExternalId, ItemExternalId, WarehouseExternalId, description, Firm, Name, QtyOrdered, QtyReceived, ScheduledReceiptDate.

    PlanetTogether

    These are listed in the Purchase Orders view.

    Jobs

    In PlanetTogether, jobs represent the top-level object that generates requests for the shop to produce one or more products by a specific time.

    PT Import Mappings

    "PT_Jobs" corresponds to a Worksheet in RapidResponse that is used to define the data needed and mapped to PlanetTogether.

    RR Tables

    The PT_Jobs worksheet is populated by the RapidResponse table “SupplyDemand”.

    Worksheet columns: ExternalId, Name, AlmostLateDays, Commitment, CustomerExternalId, Description, Hot, Importance, NeedDateTime, OrderNumber, Priority, UserField.

    PlanetTogether

    The Jobs View displays a list of all existing jobs and contains information on the Need Date, Customer, Priority, Quantity, etc.

    Manufacturing Orders

    In PlanetTogether, Manufacturing Orders represent requests to manufacture a specific quantity of a product. Each job contains one or more manufacturing orders.

    PT Import Mappings

    "PT_ManufacturingOrders" corresponds to a Worksheet in RapidResponse that is used to define the data needed and mapped to PlanetTogether.

    RR Tables

    The PT_ManufacturingOrders worksheet is populated by the RapidResponse table “SupplyDemand”.

    Worksheet columns: ExternalId, JobExternalId, Name, RequiredQty, Description, MoNeedDate, NeedDate, PreserveRequiredQty, ProductDescription, ProductName, UOM.

    PlanetTogether

    Manufacturing orders are listed in the Jobs dialog. Each job can have multiple manufacturing orders.

    Operations

    In PlanetTogether, Operations represent a single processing step in a manufacturing order and specify values for the cycle time, setup time, required finish quantity, etc.

    RapidResponse Worksheet: PT_ResourceOperations

    *This worksheet is composed of 2 Worksheets: CompleteRoutingAndOperations and ManufacturingOrders (RR Table: SupplyDemand)

    PT Import Mappings

    "PT_ResourceOperations" corresponds to a Worksheet in RapidResponse that is used to define the data needed and mapped to PlanetTogether.

    RR Tables

    Worksheet columns: CycleHrs, ExternalId, JobExternalId, MoExternalId, Name, RequiredFinishQty, BatchCode, CanPause, Description, OverlapTransferQty, QtyPerCycle, Setupcode, StupHrs, WorkCenter, Part, CapabilityID, KeepSuccessorsTimeLimitHrs, Helper, NumberofHelpers. 

    PlanetTogether

    Operation information can be found in the Jobs dialog under the Grid View | Operations tab.

    Internal Activities

    In PlanetTogether, Activities represent the smallest unit of work that can be scheduled. These specify the production status, reported quantity, reported time, etc. 

    PT Import Mappings

    "PT_InternalActivities" corresponds to a Worksheet in RapidResponse that is used to define the data needed and mapped to PlanetTogether.

    RR Tables

    Worksheet columns: ExternalId, JobExternalId, MoExternalId, OpExternalId, RequiredFinishQty, CycleHrs, NbrOfPeople, PeopleUsage, QtyPerCycle. 

    PlanetTogether

    The Activity information can be found in the Jobs dialog in the “Status” tab. 

    Resource Requirements

    In PlanetTogether, Resource Requirements specify the production resources that are required to perform the operation. Each operation must have at least one resource requirement.

    PT Import Mappings

    "PT_ResourceRequirements" corresponds to a Worksheet in RapidResponse that is used to define the data needed and mapped to PlanetTogether.

    RR Tables

    Worksheet columns: ExternalId, JobExternalId, MoExternalId, OpExternalId, AttentionPercent, DefaultResourceDepartmentExternalId, DefaultResourceExternalId, DefaultResourcePlantExternalId, NumberOfResourcesRequired, PrimaryRequirement, UsageEnd, UsageStart. 

    PlanetTogether

    The Resource Requirement information can be found in the Job Dialog, under the Resources | Resource Requirements tab. 

    Required Capabilities

    In PlanetTogether, required capabilities refer to the specific capabilities that are required for an operation to be completed. Resources must have all the required capabilities to perform an operation.

    PT Import Mappings

    "PT_RequiredCapabilities" corresponds to a Worksheet in RapidResponse that is used to define the data needed and mapped to PlanetTogether.

    RR Tables

    Worksheet columns: CapabilityExternalId, JobExternalId, MoExternalId, OpExternalId, ResourceRequirementExternalId. 

    PlanetTogether

    Required Capability information can be found in the Job dialog window under the Operation | Resources tab.

    Materials

    In PlanetTogether this refers to the materials that are required to be used by a job's operations.

    PT Import Mappings

    "PT_Materials" corresponds to a Worksheet in RapidResponse that is used to define the data needed and mapped to PlanetTogether.

    RR Tables

    The PT_Materials worksheet is populated by the RapidResponse table “SupplyDemand”.

    Worksheet columns: ExternalId, JobExternalId, MoExternalId, OpExternalId, ConstraintType, IssuedQty, ItemExternalId, TotalRequiredQty, UOM, WarehouseExternalId. 

    PlanetTogether

    The Material information can be found in the Job dialog under the Operation | Stock Materials tab. The Materials View also displays a list of manufacturing orders, jobs, and operations in terms of the materials required to supply them.

    Products

    PT Import Mappings

    "PT_Products" corresponds to a Worksheet in RapidResponse that is used to define the data needed and mapped to PlanetTogether.

    RR Tables

    The PT_Products worksheet is populated by the RapidResponse table “SupplyDemand”.

    Worksheet columns: ExternalId, JobExternalId, MoExternalId, OpExternalId, ItemExternalId, TotalOutputQty, WarehouseExternalId. 

    PlanetTogether

    The Product information can be found in the Job dialog under the Operation | Products tab.

    Operation Attributes

    Operation Attributes can specify a wide range of characteristics regarding the product being created. These can, in turn, be used by PlanetTogether to calculate the Setup time or in the calculation of optimize rules.

    PT Import Mappings

    "PT_OperationAttributes" corresponds to a Worksheet in RapidResponse that is used to define the data needed and mapped to PlanetTogether.

    RR Tables

    Worksheet columns: 

    PlanetTogether

    The Operation Attributes can be accessed from the Jobs dialog under the Operation | Attributes tab.

    Alternate Paths

    In PlanetTogether, Alternate Paths specify the precedence relationships between operations and provide a different order for the operations than the default path.

    PT Import Mappings

    "PT_AlternatePaths" corresponds to a Worksheet in RapidResponse that is used to define the data needed and mapped to PlanetTogether.

    RR Tables

    Worksheet columns: ExternalId, JobExternalId, MoExternalId, AutoUse, AutoUseReleaseOffsetDays, Name.

    PlanetTogether

    Information on Alternate Paths can be found in the Jobs dialog in the Grid View | Alternate Paths tab.

    Alternate Path Nodes

    Each Alternate Path is made up of one or more Nodes that specifies an operation and one or more successor operations, if applicable.

    PT Import Mappings

    "PT_AlternatePaths_Nodes" corresponds to a Worksheet in RapidResponse that is used to define the data needed and mapped to PlanetTogether.

    RR Tables

    Worksheet columns: JobExternalId, MoExternalId, PlantExternalId, OpID, MaxDelayHrs, OverlapType. 

    PlanetTogether

    Information on Alternate Path Nodes can be found in the Jobs dialog in the Grid View | Alternate Paths tab.

    Successor Manufacturing Orders

    Successor Manufacturing Orders are manufacturing orders from either the same or different job that requires materials from a predecessor manufacturing order.

    PT Import Mappings

    "PT_SuccessorManudacturingOrders" corresponds to a Worksheet in RapidResponse that is used to define the data needed and mapped to PlanetTogether.

    RR Tables

    The PT_SuccessorManufacturingOrders worksheet is populated by the RapidResponse table “SuccessorManufacturingOrders”.

    Worksheet columns: ExternalId, JobExternalId, MoExternalId, SuccessorJobExternalId, SuccessorManufacturingOrderExternalId, SuccessorOperationExternalId, SuccessorPathExternalId. 

    PlanetTogether

    Successor Manufacturing Order information can be found in the Jobs dialog under the Grid View | Successor M.O.s tab.