Mapping Settings

Mapping Core Principle

Mappings are essential in C60 to make sure that we interpret your data properly and standardize it as a single combined dataset across different systems and different business regions or plants.

For each mapping category, we expose some data in your system, for which we need you to tell us what it corresponds to in the C60 world.

Delivery Status

The different statuses that we found in your system that is pertaining to delivery of the concrete product. Each status can be either mapped to "Delivered' that is the delivery was complete or 'Cancelled' that is the delivery was cancelled.

By default, all statuses are mapped as 'Delivered' and you can update it as necessary

Material Code (Batch & QC Streams)

Material codes can be different if it is coming from two different systems.  In C60,  we automatically match the codes that are same in both batch and QC system and expose the ones that need to be matched , as we cannot find the matching material codes between the two systems. You can leave the non-matched ones as empty , if the material code in question is not being used or specify its equivalent in the other system.

Delivery Type

The different types that we found in your system that is pertaining to type of delivery of the concrete product. Each type can be either mapped to "Delivery' that it was the actual delivery  or 'PickUp(FOB)' that it was picked up

By default, all types are mapped as 'Delivery' and you can update it as necessary

Product Code (Dispatch & QC Streams)

Product codes can be different if it is coming from two different systems. In C60,  we automatically match the codes that are same in both dispatch and QC system and expose the ones that need to be matched , as we cannot find the matching product codes between the two systems. You can leave the non-matched as empty , if the product code in question is not in use or specify its equivalent in the other system.

Material Type

The different material types we found in your system that is pertaining to category of the material. Each material type can be mapped as Cement, or Coarse Aggregate, or Fine Aggregate, or SCM, or Additives, or Water 

Truck Owner Type

The different truck types we found in your system that is pertaining to ownership of the truck. Each Truck or Truck Type  can be mapped as Company-owned, or Contracted or Spot trucks.

By default, all Trucks of Truck Owner types are mapped as 'Company-owned' and you can update it as necessary.

Revenue Cost Category - Product Type

The different product types we found in your systems that can be used to categorize the product types as Concrete, Deliveries or Exclude for margin calculations. This mapping affects all margin dashboards, you can map the product types to consider the revenue or cost associated with product types as Concrete or Delivery or to be excluded them from the calculations

If you map the product type to "Deliveries", then all products in the grouping will be mapped to Deliveries and accounted for calculating Logistics Surcharges. 

If you map the product type to "Concrete", then all products in the grouping will be mapped to Concrete and accounted for calculating Concrete Invoice and Total Material Costs. 

Here's an example: If we have a product type that looks like this:

1. Delivery Fees (Product Type) -> "Deliveries"
   1. Late Delivery (product Code)
   2. Small Load (Product Code)
   3. Env Fee (Product Code)

If you map this product type "Delivery Fees" to "Deliveries", then all 3 products in the grouping will be mapped to Deliveries and accounted for calculating Logistics Surcharges. 

P.S. - If a product type is mapped to 'Deliveries' category, then only invoice related information would be considered and costs will be excluded for the products under this product type during invoice and material cost calculation for the delivery.

Revenue Cost Category - Product Code

The different product codes we found in your systems that can be used to categorize individual products as Concrete, Deliveries or Exclude for margin calculations. This mapping affects all margin dashboards, you can further map individual product codes to consider the revenue or cost associated with each product as Concrete or Delivery or to be excluded them from the calculations

If nothing is specified here, the products will take the revenue category of their product type (see previous setting). Taking the same example

1. Delivery Fees (Product Type) -> "Deliveries"
   1. Late Delivery (product Code)
   2. Small Load (Product Code)
   3. Env Fee (Product Code) -> "Exclude"

If you want further control in managing each product's mapping for revenue and cost calculation, you can do so with the mapping here. For example, if you wanted to exclude Env Fee from "Deliveries" , then you could use the 'Revenue Cost Category - Product Code' mapping to exclude it, which means that Late Delivery & Small Load would still be considered as "Logistics Surcharges" and Env fee would be excluded from logistics charges calculation.

P.S. - If a product is mapped to 'Deliveries' category, then only invoice related information would be considered and costs will be excluded for that product during invoice and material cost calculation for the delivery.