Returns

This page provides detailed instructions on the Returns Code transform code block and what should be added to the Script Manifest file in order to execute the code

Script Manifest File (YML)

Upstream Transformation Dependencies

This code block has no upstream dependencies but requires the Loop Returns extractor to be installed

Transformation Code Requirements

The following code should be added to the main workflow in the appropriate position, after Life-Time Value and before Product and Inventory per the Transform Code Sequence - DRP page

  #--------------------------------------------------------------------------------------------------------------------
  # SECTION: 5800_RETURNS
  # DEPENDENCIES:
  #   - Integration: Loop Returns
  # REQUIRED: No
  # PURPOSE: This code the DRP tables for Loop Returns and should be enabled when Loop Returns is added and enabled
  #--------------------------------------------------------------------------------------------------------------------
  loop_returns:
    integrations:
      - loop_returns
    scripts:
      - "github://platform-sql-shared/scripts/base/5800_returns/5810_RET_BAS_loop_return_lines.sql"

Returns - Loop Returns

Add this code to enable analysis of returns and exchanges by creating the following tables:

• [drp.loop_return_lines]

• https://github.com/Daasity/platform-sql-shared/blob/master/scripts/base/5800_returns/5810_RET_BAS_loop_return_lines.sql