Activity Template Database Schema
Activity Template Database Schema
Activity Template Database Schema
Product Price
product_id
Product
product_id
order_sid
order_item_sid product_id
product_id
order_item_type product_price
product_name
product_sid price_valid_from
product_category
planned_delivery_dat price_valid_to
e
order_item_price
order_item_currency
Shipments
Sales Facts
shipment_id
Sales Order Details
product_id
order_sid
order_item_sid order_id
order_sid
shipped_quanity customer_sid
customer_sid
order_date Customer
order_item_sid product_id
order_type
shipment_sid
customer_sid
billing_sid
customer_name
quantity
customer_type
net_amount
Billing
tax_amount
billing_id gross_amount
billing_date discount_amount
order_sid
order_item_sid
billing_amount