View: UOS Table(s): uos.order_line_items

Source Database Table

uos.order_line_items

Script that Populates Database Table

0516_UOS_BAS_SHOPIFY_order_line_Items.sql

Script Description and Logic

Pulls orders line items in Shopify created or modified in the 7 days prior to the script run date along with order line ids, flags, and other associated data. The data is loaded into a unified schema which combines order line, refund line items, and discount data from Shopify with data from any other order line item source integration.

Source Tables Used In Script

 <insert table here-manual>

SQL Flow

Calculated and Derived Fields

 <insert table here-manual>

 

All content © Daasity 2021. Do not copy, share or distribute.