# Returns

## Script Manifest File (YML)

### Upstream Transformation Dependencies

{% hint style="warning" %}
This code block has no upstream dependencies but requires the Loop Returns extractor to be installed
{% endhint %}

### 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](https://help.daasity.com/technical-docs/transform-code/transform-code/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

{% hint style="success" %}
Add this code to enable analysis of returns and exchanges by creating the following tables:

* \[`drp.loop_return_lines`]
  {% endhint %}

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