Raw Layer Mapping

The following tables need to be mapped into the RAW layer for Merchandise Financial Planning (MFP) 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 MFP 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)) - required for unit planning: Sale in units
  • TRANSFER_UNITS(decimal(18,4))- not required:
  • SALE_VALUE (decimal(18,4)) - required: Sale in value
  • COST_VALUE (decimal(18,4)) - required: Cost of sales in value
  • PLANNED_DISCOUNT_VALUE (decimal(18,4)) - required: Planned discount in value
  • OTHER_DISCOUNT_VALUE (decimal(18,4)) - required: Other discount in value

raw.INTAKE_VALUE_HISTORY

History of Intake 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
  • INTAKE_UNITS (decimal(18,4)) - required for unit planning: Intake in units
  • SALE_VALUE (decimal(18,4)) - required: Intake in sale value
  • COST_VALUE (decimal(18,4)) - required: Intake in cost value

raw.STOCK_VALUE_HISTORY

History of Stock 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
  • STOCK_MOVE_UNITS (decimal(18,4)) - required: Stock movement in units
  • STOCK_LEVEL_UNITS (decimal(18,4)) - required: Stock level in units
  • STOCK_LEVEL_SALE_VALUE (decimal(18,4)) - required: Stock level in sale value
  • STOCK_LEVEL_COST_VALUE (decimal(18,4)) - required: Stock level in cost value

raw.STOCK_MARKDOWN_HISTORY

History of Stock Markdowns in values and units. Primary key: PRODUCT_ITEM_NO,DATE

  • PRODUCT_ITEM_NO (nvarchar) - required: The product number
  • DATE (date) - required: The date of sale
  • STOCK_MARKDOWN_VALUE (decimal(18,4)) - required: Stock markdown in sale value