Activity Template Database Schema

Download as pptx, pdf, or txt
Download as pptx, pdf, or txt
You are on page 1of 1

Order Items

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

You might also like