Raw Layer Mapping

The following tables need to be mapped into the RAW layer for Location Clustering to be set up. With the release a standard data mapping into the raw layer is provided from the Navision erp tables. For other data sources either the customer should provide data directly into the raw layer tables er you use the raw views for data mapping.

Try not to change anything in the other layers as the mapping into PREP and LC are part of the upgrade paths.

raw.SALE_VALUE_HISTORY

History of Sales, Cost of Goods Sold and Discounts in values and units. Primary key: PRODUCT_ITEM_NO,LOCATION_NO,DATE

  • PRODUCT_ITEM_NO (nvarchar) - required: The product number
  • LOCATION_NO (nvarchar) - required: the location number
  • DATE (date) - required: The date of sale
  • SALE_UNITS (decimal(18,4)) - not required: Sale in units
  • TRANSFER_UNITS(decimal(18,4))- not required:
  • SALE_VALUE (decimal(18,4)) - not required but recommended : Sale in value
  • COST_VALUE (decimal(18,4)) - not required: Cost of sales in value
  • PLANNED_DISCOUNT_VALUE (decimal(18,4)) - not required: Planned discount in value
  • OTHER_DISCOUNT_VALUE (decimal(18,4)) - not required: Other discount in value

Note that sale_value is not required but it’s used to calculate replenishment grade, so if a customer intends to use that then it’s required. Please check with your customer before eliminating data like sale value from the data mapping as it may be information that they want to see when planning location clusters.