Source Tables Used In Script
| Schema | Table (or Derived Table) Name | Table Type | Purpose |
| uos | order_item_fulfillments | database | Primary Source |
| drp | fulfillment_cost | database | Obtain fulfillment and shipping cost for each fulfillment |
| drp_staging | order_item_fulfillment_cost | database | Pre-insert |
| drp_staging | order_item_fulfillments_to_update | database | Lookup |
| N/A | last_sync_date | derived | Obtain last sync date for each record |
SQL Flow
Calculated and Derived Fields
| Target Column | Target Column Data Type | Source schema.table | Source Column | Transformation/Logic |
| fulfillment_cost | DECIMAL | drp.fulfillment_cost | fulfillment_cost | Sum(fulfillment cost/num_items) per order_line and __shop_id |
| shipping_cost | DECIMAL | drp.fulfillment_cost | shipping_cost | Sum(shipping cost/num_items) per order_line and __shop_id |
All content © Daasity 2021. Do not copy, share or distribute.