0554_UOS_BAS_AMAZON_order_item_fulfillments Transformation

Target Database Table

uos.order_item_fulfillments.

Script Description and Logic

Pulls order item fulfillments from from asc order items in Amazon created or modified in the 7 days prior to the script run date along with order fulfillment line id, order fulfillment ids, ordered amounts and other associated data. The data is loaded into a unified schema which combines order item fulfillments from Amazon with data from any other order item fulfillment source integrations.

Source Tables Used In Script

Coming soon.

SQL Flow

To View Larger Image, Right Click and Choose Open Image In New Tab.

 0554_UOS_BAS_AMAZON_order_item_fulfillments Transformation
Calculated and Derived Fields

Coming soon.

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