Pinch to zoom · Ctrl + scroll to zoom faster
↑
↓
0 / 0
×
lineage
Cycle Superstore Data Warehouse Lineage
Node Types
Square box = table
Rounded box = view
Edge color = originating object
Data Sources
Main ERP
[Central operational system: POS, inventory, financials, and service management]
CSS2
[E-commerce website and online order data]
Google Ads
[Campaigns, conversions and Merchant Center product data]
Bizimply
[Staff timecards and payroll]
Xero
[Accounting, invoices and bank transactions]
Email
[Microsoft 365 customer correspondence]
How to read this lineage
This map shows how data sources feed the warehouse, are shaped through Silver and Intermediate, consolidated in Gold, and exposed through the Semantic layer.
Each node is a warehouse table or view. Arrows point from an object to its upstream dependencies, so read the diagram right to left.
Example layer path: read right to left
Semantic
←
Gold
←
Intermediate
←
Silver
←
Bronze
raw_layer
BRONZE LAYER
stg_layer
SILVER LAYER
int_layer
INTERMEDIATE
marts_layer
GOLD LAYER
semantic_layer
SEMANTIC LAYER
raw_365_365_mail
raw_365.365_mail
raw_ccdata_adminusers
raw_ccdata.adminusers
raw_ccdata_category_map
raw_ccdata.category_map
raw_ccdata_customer
raw_ccdata.customer
raw_ccdata_customerphoneno
raw_ccdata.customerphoneno
raw_ccdata_events
raw_ccdata.events
raw_ccdata_inventory
raw_ccdata.inventory
raw_ccdata_invoicedetails
raw_ccdata.invoicedetails
raw_ccdata_invoiceheader
raw_ccdata.invoiceheader
raw_ccdata_makes
raw_ccdata.makes
raw_ccdata_products
raw_ccdata.products
raw_ccdata_purchaseorderdetails
raw_ccdata.purchaseorderdetails
raw_ccdata_purchaseorderheader
raw_ccdata.purchaseorderheader
raw_ccdata_repairs
raw_ccdata.repairs
raw_ccdata_repairsdetails
raw_ccdata.repairsdetails
raw_ccdata_saleorderdetails
raw_ccdata.saleorderdetails
raw_ccdata_saleorderheader
raw_ccdata.saleorderheader
raw_ccdata_stock
raw_ccdata.stock
raw_ccdata_sundrydetails
raw_ccdata.sundrydetails
raw_ccdata_sundryheader
raw_ccdata.sundryheader
raw_ccdata_usedbikes
raw_ccdata.usedbikes
raw_css2_categories_products
raw_css2.categories_products
raw_css2_customers
raw_css2.customers
raw_css2_itemgroupings_t
raw_css2.itemgroupings_t
raw_css2_productoptions_t
raw_css2.productoptions_t
raw_css2_products
raw_css2.products
raw_google_ads_campaignconversionstats_5605924582
raw_google.ads_campaignconversionstats_5605924582
raw_google_ads_campaignlabel_5605924582
raw_google.ads_campaignlabel_5605924582
raw_google_ads_campaignstats_5605924582
raw_google.ads_campaignstats_5605924582
raw_google_vw_daily_product_performance
raw_google.vw_daily_product_performance
raw_google_vw_pricecompetitiveness
raw_google.vw_pricecompetitiveness
raw_google_vw_priceinsights
raw_google.vw_priceinsights
raw_payroll_bizimply_timecards
raw_payroll.bizimply_timecards
raw_payroll_seed_dwh_employee
raw_payroll.seed-dwh-employee
raw_xero_banktransactions
raw_xero.banktransactions
stg_bike_product
stg.bike_product
stg_bike_product->raw_ccdata_products
stg_categories_products
stg.categories_products
stg_categories_products->raw_css2_categories_products
stg_category_map_temp
stg.category_map_temp
stg_category_map_temp->raw_ccdata_category_map
stg_customer_numbers
stg.customer_numbers
stg_customer_numbers->raw_ccdata_customerphoneno
stg_customers
stg.customers
stg_customers->raw_ccdata_customer
stg_employees
stg.employees
stg_employees->raw_ccdata_adminusers
stg_events
stg.events
stg_events->raw_ccdata_events
stg_exchange_emails
stg.exchange_emails
stg_exchange_emails->raw_365_365_mail
stg_google_ads_campaign_conversion_stats
stg.google_ads_campaign_conversion_stats
stg_google_ads_campaign_conversion_stats->raw_google_ads_campaignconversionstats_5605924582
stg_google_ads_campaign_label
stg.google_ads_campaign_label
stg_google_ads_campaign_label->raw_google_ads_campaignlabel_5605924582
stg_google_ads_campaign_stats
stg.google_ads_campaign_stats
stg_google_ads_campaign_stats->raw_google_ads_campaignstats_5605924582
stg_google_daily_product_performance
stg.google_daily_product_performance
stg_google_daily_product_performance->raw_google_vw_daily_product_performance
stg_google_price_competitiveness
stg.google_price_competitiveness
stg_google_price_competitiveness->raw_google_vw_pricecompetitiveness
stg_google_price_insights
stg.google_price_insights
stg_google_price_insights->raw_google_vw_priceinsights
stg_inventory
stg.inventory
stg_inventory->raw_ccdata_inventory
stg_invoice_details
stg.invoice_details
stg_invoice_details->raw_ccdata_invoicedetails
stg_invoice_header
stg.invoice_header
stg_invoice_header->raw_ccdata_invoiceheader
stg_makes
stg.makes
stg_makes->raw_ccdata_makes
stg_payroll_employees
stg.payroll_employees
stg_payroll_employees->raw_payroll_seed_dwh_employee
stg_product
stg.product
stg_product->raw_ccdata_stock
stg_purchase_order_details
stg.purchase_order_details
stg_purchase_order_details->raw_ccdata_purchaseorderdetails
stg_purchase_order_header
stg.purchase_order_header
stg_purchase_order_header->raw_ccdata_purchaseorderheader
stg_repairs_details
stg.repairs_details
stg_repairs_details->raw_ccdata_repairsdetails
stg_repairs_header
stg.repairs_header
stg_repairs_header->raw_ccdata_repairs
stg_sales_order_details
stg.sales_order_details
stg_sales_order_details->raw_ccdata_saleorderdetails
stg_sales_order_header
stg.sales_order_header
stg_sales_order_header->raw_ccdata_saleorderheader
stg_sundry_details
stg.sundry_details
stg_sundry_details->raw_ccdata_sundrydetails
stg_sundry_header
stg.sundry_header
stg_sundry_header->raw_ccdata_sundryheader
stg_used_bike_memo
stg.used_bike_memo
stg_used_bike_memo->raw_ccdata_usedbikes
stg_vw_stg_bizimply_timecards
stg.vw_stg_bizimply_timecards
stg_vw_stg_bizimply_timecards->raw_payroll_bizimply_timecards
stg_web_customers
stg.web_customers
stg_web_customers->raw_css2_customers
stg_web_item_groupings
stg.web_item_groupings
stg_web_item_groupings->raw_css2_itemgroupings_t
stg_web_product
stg.web_product
stg_web_product->raw_css2_products
stg_web_product_options
stg.web_product_options
stg_web_product_options->raw_css2_productoptions_t
stg_xero_bank_transaction_details
stg.xero_bank_transaction_details
stg_xero_bank_transaction_details->raw_xero_banktransactions
stg_xero_bank_transaction_header
stg.xero_bank_transaction_header
stg_xero_bank_transaction_header->raw_xero_banktransactions
int_base_repair_details
int.base_repair_details
int_base_repair_details->stg_repairs_details
int_base_repair_headers
int.base_repair_headers
int_base_repair_headers->stg_repairs_header
int_service_product
int.service_product
int_base_repair_headers->int_service_product
int_bike_product
int.bike_product
int_bike_product->stg_bike_product
int_bike_product->stg_category_map_temp
int_bike_product->stg_makes
int_consolidated_customers
int.consolidated_customers
int_consolidated_customers->stg_web_customers
int_customers
int.customers
int_consolidated_customers->int_customers
int_consolidated_product
int.consolidated_product
int_product_consolidated_enriched
int.product_consolidated_enriched
int_consolidated_product->int_product_consolidated_enriched
int_customers->stg_customer_numbers
int_customers->stg_customers
int_employees
int.employees
int_employees->stg_employees
int_employees->stg_payroll_employees
int_exchange_emails_with_customer
int.exchange_emails_with_customer
int_exchange_emails_with_customer->stg_exchange_emails
int_exchange_emails_with_customer->int_consolidated_customers
int_fact_repair_lines
int.fact_repair_lines
int_fact_repair_lines->int_base_repair_details
int_fact_repair_lines->int_base_repair_headers
int_fact_repair_lines->int_employees
int_product_code_to_product_key_mapping
int.product_code_to_product_key_mapping
int_fact_repair_lines->int_product_code_to_product_key_mapping
int_google_ads_campaign_conversions
int.google_ads_campaign_conversions
int_google_ads_campaign_conversions->stg_google_ads_campaign_conversion_stats
int_google_ads_campaign_conversions->stg_google_ads_campaign_label
int_int_dim_transaction
int.int_dim_transaction
int_int_dim_transaction->stg_sales_order_header
int_int_dim_transaction->int_base_repair_headers
int_order_credit_header
int.order_credit_header
int_int_dim_transaction->int_order_credit_header
int_order_invoice_header
int.order_invoice_header
int_int_dim_transaction->int_order_invoice_header
int_pos_credit_notes_header
int.pos_credit_notes_header
int_int_dim_transaction->int_pos_credit_notes_header
int_pos_invoice_notes_header
int.pos_invoice_notes_header
int_int_dim_transaction->int_pos_invoice_notes_header
int_int_order_credits
int.int_order_credits
int_int_order_credits->int_base_repair_headers
int_int_order_credits->int_employees
int_order_credit_details
int.order_credit_details
int_int_order_credits->int_order_credit_details
int_int_order_credits->int_order_credit_header
int_int_order_credits->int_order_invoice_header
int_int_order_credits->int_product_code_to_product_key_mapping
int_int_order_invoices
int.int_order_invoices
int_int_order_invoices->int_employees
int_order_invoice_details
int.order_invoice_details
int_int_order_invoices->int_order_invoice_details
int_int_order_invoices->int_order_invoice_header
int_int_order_invoices->int_product_code_to_product_key_mapping
int_int_pos_credits
int.int_pos_credits
int_int_pos_credits->int_employees
int_pos_credit_notes_details
int.pos_credit_notes_details
int_int_pos_credits->int_pos_credit_notes_details
int_int_pos_credits->int_pos_credit_notes_header
int_pos_invoice_notes_details
int.pos_invoice_notes_details
int_int_pos_credits->int_pos_invoice_notes_details
int_int_pos_credits->int_pos_invoice_notes_header
int_int_pos_credits->int_product_code_to_product_key_mapping
int_int_pos_invoices
int.int_pos_invoices
int_int_pos_invoices->int_employees
int_int_pos_invoices->int_pos_credit_notes_details
int_int_pos_invoices->int_pos_credit_notes_header
int_int_pos_invoices->int_pos_invoice_notes_details
int_int_pos_invoices->int_pos_invoice_notes_header
int_int_pos_invoices->int_product_code_to_product_key_mapping
int_int_sales_orders
int.int_sales_orders
int_int_sales_orders->stg_sales_order_details
int_int_sales_orders->stg_sales_order_header
int_int_sales_orders->int_employees
int_int_sales_orders->int_product_code_to_product_key_mapping
int_sales_order_collections
int.sales_order_collections
int_int_sales_orders->int_sales_order_collections
int_int_service_credits
int.int_service_credits
int_int_service_credits->int_base_repair_headers
int_int_service_credits->int_employees
int_int_service_credits->int_order_credit_details
int_int_service_credits->int_order_credit_header
int_int_service_credits->int_order_invoice_header
int_int_service_credits->int_product_code_to_product_key_mapping
int_int_service_invoices
int.int_service_invoices
int_int_service_invoices->int_fact_repair_lines
int_int_service_orders
int.int_service_orders
int_int_service_orders->int_fact_repair_lines
int_non_bike_product
int.non_bike_product
int_non_bike_product->stg_category_map_temp
int_non_bike_product->stg_makes
int_non_bike_product->stg_product
int_order_credit_details->stg_invoice_details
int_order_credit_header->stg_invoice_header
int_order_invoice_collections
int.order_invoice_collections
int_order_credit_header->int_order_invoice_collections
int_order_invoice_collections->stg_events
int_order_invoice_details->stg_invoice_details
int_order_invoice_header->stg_invoice_header
int_order_invoice_header->int_order_invoice_collections
int_pos_credit_notes_details->stg_sundry_details
int_pos_credit_notes_header->stg_sundry_header
int_pos_invoice_notes_details->stg_sundry_details
int_pos_invoice_notes_header->stg_sundry_header
int_vw_int_product_code_to_product_key_mapping
int.vw_int_product_code_to_product_key_mapping
int_product_code_to_product_key_mapping->int_vw_int_product_code_to_product_key_mapping
int_product_consolidated_base
int.product_consolidated_base
int_product_source_bike
int.product_source_bike
int_product_consolidated_base->int_product_source_bike
int_product_source_non_bike
int.product_source_non_bike
int_product_consolidated_base->int_product_source_non_bike
int_product_source_special_keys
int.product_source_special_keys
int_product_consolidated_base->int_product_source_special_keys
int_product_consolidated_enriched->stg_makes
int_product_consolidated_enriched->int_product_consolidated_base
int_product_google_signals
int.product_google_signals
int_product_consolidated_enriched->int_product_google_signals
int_product_google_signals->stg_google_price_competitiveness
int_product_google_signals->stg_google_price_insights
int_product_source_bike->int_bike_product
int_web_product_integrated
int.web_product_integrated
int_product_source_bike->int_web_product_integrated
int_product_source_non_bike->int_non_bike_product
int_product_source_non_bike->int_web_product_integrated
int_product_source_special_keys->stg_bike_product
int_product_source_special_keys->int_product_code_to_product_key_mapping
int_purchase_orders
int.purchase_orders
int_purchase_orders->stg_purchase_order_details
int_purchase_orders->stg_purchase_order_header
int_purchase_orders->int_employees
int_purchase_orders->int_product_code_to_product_key_mapping
int_sales_order_collections->stg_events
int_service_engineer_performance
int.service_engineer_performance
int_service_engineer_performance->stg_events
int_service_engineer_performance->int_base_repair_headers
int_service_engineer_performance->int_employees
int_vw_int_service_product
int.vw_int_service_product
int_service_product->int_vw_int_service_product
int_used_bikes_memo
int.used_bikes_memo
int_used_bikes_memo->stg_used_bike_memo
int_used_bikes_memo->int_product_code_to_product_key_mapping
int_vw_int_bizimply_timecards_daily
int.vw_int_bizimply_timecards_daily
int_vw_int_bizimply_timecards_daily->stg_employees
int_vw_int_bizimply_timecards_daily->stg_vw_stg_bizimply_timecards
int_vw_int_dim_google_ads_campaign
int.vw_int_dim_google_ads_campaign
int_vw_int_dim_google_ads_campaign->stg_google_ads_campaign_label
int_vw_int_google_ads_campaign_daily_stats
int.vw_int_google_ads_campaign_daily_stats
int_vw_int_google_ads_campaign_daily_stats->stg_google_ads_campaign_label
int_vw_int_google_ads_campaign_daily_stats->stg_google_ads_campaign_stats
int_vw_int_google_daily_product_performance
int.vw_int_google_daily_product_performance
int_vw_int_google_daily_product_performance->stg_google_daily_product_performance
int_vw_int_google_daily_product_performance->stg_web_product
int_vw_int_google_daily_product_performance->int_consolidated_product
int_vw_int_product_code_to_product_key_mapping->stg_bike_product
int_vw_int_product_code_to_product_key_mapping->stg_product
int_vw_int_service_product->stg_product
int_vw_web_product_integrated
int.vw_web_product_integrated
int_vw_web_product_integrated->stg_categories_products
int_vw_web_product_integrated->stg_web_item_groupings
int_vw_web_product_integrated->stg_web_product
int_vw_web_product_integrated->stg_web_product_options
int_web_product_integrated->int_vw_web_product_integrated
int_xero_bank_transactions
int.xero_bank_transactions
int_xero_bank_transactions->stg_xero_bank_transaction_details
int_xero_bank_transactions->stg_xero_bank_transaction_header
marts_dim_customer
marts.dim_customer
marts_vw_dim_customer
marts.vw_dim_customer
marts_dim_customer->marts_vw_dim_customer
marts_dim_employee
marts.dim_employee
marts_vw_dim_employee
marts.vw_dim_employee
marts_dim_employee->marts_vw_dim_employee
marts_dim_product
marts.dim_product
marts_vw_dim_product
marts.vw_dim_product
marts_dim_product->marts_vw_dim_product
marts_dim_transaction
marts.dim_transaction
marts_vw_dim_transaction
marts.vw_dim_transaction
marts_dim_transaction->marts_vw_dim_transaction
marts_fct_exchange_emails_with_customer
marts.fct_exchange_emails_with_customer
marts_vw_fct_exchange_emails_with_customer
marts.vw_fct_exchange_emails_with_customer
marts_fct_exchange_emails_with_customer->marts_vw_fct_exchange_emails_with_customer
marts_fct_google_ads_campaign_conversions
marts.fct_google_ads_campaign_conversions
marts_vw_fct_google_ads_campaign_conversions
marts.vw_fct_google_ads_campaign_conversions
marts_fct_google_ads_campaign_conversions->marts_vw_fct_google_ads_campaign_conversions
marts_fct_google_ads_campaign_daily_stats
marts.fct_google_ads_campaign_daily_stats
marts_vw_fct_google_ads_campaign_daily_stats
marts.vw_fct_google_ads_campaign_daily_stats
marts_fct_google_ads_campaign_daily_stats->marts_vw_fct_google_ads_campaign_daily_stats
marts_fct_google_daily_product_performance
marts.fct_google_daily_product_performance
marts_vw_fct_google_daily_product_performance
marts.vw_fct_google_daily_product_performance
marts_fct_google_daily_product_performance->marts_vw_fct_google_daily_product_performance
marts_fct_order_credits
marts.fct_order_credits
marts_vw_fct_order_credits
marts.vw_fct_order_credits
marts_fct_order_credits->marts_vw_fct_order_credits
marts_fct_order_invoices
marts.fct_order_invoices
marts_vw_fct_order_invoices
marts.vw_fct_order_invoices
marts_fct_order_invoices->marts_vw_fct_order_invoices
marts_fct_purchase_orders
marts.fct_purchase_orders
marts_vw_fct_purchase_orders
marts.vw_fct_purchase_orders
marts_fct_purchase_orders->marts_vw_fct_purchase_orders
marts_fct_sales_orders
marts.fct_sales_orders
marts_vw_fct_sales_orders
marts.vw_fct_sales_orders
marts_fct_sales_orders->marts_vw_fct_sales_orders
marts_fct_service_credits
marts.fct_service_credits
marts_vw_fct_service_credits
marts.vw_fct_service_credits
marts_fct_service_credits->marts_vw_fct_service_credits
marts_fct_service_engineer_performance
marts.fct_service_engineer_performance
marts_vw_fct_service_engineer_performance
marts.vw_fct_service_engineer_performance
marts_fct_service_engineer_performance->marts_vw_fct_service_engineer_performance
marts_fct_service_invoices
marts.fct_service_invoices
marts_vw_fct_service_invoices
marts.vw_fct_service_invoices
marts_fct_service_invoices->marts_vw_fct_service_invoices
marts_fct_service_orders
marts.fct_service_orders
marts_vw_fct_service_orders
marts.vw_fct_service_orders
marts_fct_service_orders->marts_vw_fct_service_orders
marts_fct_till_credits
marts.fct_till_credits
marts_vw_fct_till_credits
marts.vw_fct_till_credits
marts_fct_till_credits->marts_vw_fct_till_credits
marts_fct_till_invoices
marts.fct_till_invoices
marts_vw_fct_till_invoices
marts.vw_fct_till_invoices
marts_fct_till_invoices->marts_vw_fct_till_invoices
marts_fct_used_bikes_memo
marts.fct_used_bikes_memo
marts_vw_fct_used_bikes_memo
marts.vw_fct_used_bikes_memo
marts_fct_used_bikes_memo->marts_vw_fct_used_bikes_memo
marts_fct_xero_bank_transaction_credits
marts.fct_xero_bank_transaction_credits
marts_vw_fct_xero_bank_transaction_credits
marts.vw_fct_xero_bank_transaction_credits
marts_fct_xero_bank_transaction_credits->marts_vw_fct_xero_bank_transaction_credits
marts_fct_xero_bank_transaction_debits
marts.fct_xero_bank_transaction_debits
marts_vw_fct_xero_bank_transaction_debits
marts.vw_fct_xero_bank_transaction_debits
marts_fct_xero_bank_transaction_debits->marts_vw_fct_xero_bank_transaction_debits
marts_vw_dim_customer->int_consolidated_customers
marts_vw_dim_employee->int_employees
marts_vw_dim_google_ads_campaign
marts.vw_dim_google_ads_campaign
marts_vw_dim_google_ads_campaign->int_vw_int_dim_google_ads_campaign
marts_vw_dim_order_channel
marts.vw_dim_order_channel
marts_vw_dim_product->int_consolidated_product
marts_vw_dim_transaction->int_int_dim_transaction
marts_vw_employee_timecards_hours
marts.vw_employee_timecards_hours
marts_vw_employee_timecards_hours->int_vw_int_bizimply_timecards_daily
marts_vw_fct_exchange_emails_with_customer->int_exchange_emails_with_customer
marts_vw_fct_google_ads_campaign_conversions->int_google_ads_campaign_conversions
marts_vw_fct_google_ads_campaign_daily_stats->int_vw_int_google_ads_campaign_daily_stats
marts_vw_fct_google_daily_product_performance->int_vw_int_google_daily_product_performance
marts_vw_fct_order_credits->int_int_order_credits
marts_vw_fct_order_invoices->int_int_order_invoices
marts_vw_fct_purchase_orders->int_purchase_orders
marts_vw_fct_sales_orders->int_int_sales_orders
marts_vw_fct_service_credits->int_int_service_credits
marts_vw_fct_service_engineer_performance->int_service_engineer_performance
marts_vw_fct_service_invoices->int_int_service_invoices
marts_vw_fct_service_orders->int_int_service_orders
marts_vw_fct_till_credits->int_int_pos_credits
marts_vw_fct_till_invoices->int_int_pos_invoices
marts_vw_fct_used_bikes_memo->int_used_bikes_memo
marts_vw_fct_xero_bank_transaction_credits->int_xero_bank_transactions
marts_vw_fct_xero_bank_transaction_debits->int_xero_bank_transactions
meta_deployment_log
meta.deployment_log
meta_refresh_metadata
meta.refresh_metadata
dbo_01___order_invoices
01 - Order Invoices
dbo_01___order_invoices->marts_fct_order_invoices
dbo_02___till_invoices
02 - Till Invoices
dbo_02___till_invoices->marts_fct_till_invoices
dbo_03___service_invoices
03 - Service Invoices
dbo_03___service_invoices->marts_fct_service_invoices
dbo_04___used_bikes
04 - Used Bikes
dbo_04___used_bikes->marts_fct_used_bikes_memo
dbo_05___order_credits
05 - Order Credits
dbo_05___order_credits->marts_fct_order_credits
dbo_06___till_credits
06 - Till Credits
dbo_06___till_credits->marts_fct_till_credits
dbo_07___service_credits
07 - Service Credits
dbo_07___service_credits->marts_fct_service_credits
dbo_08___sales_order
08 - Sales Order
dbo_08___sales_order->marts_fct_sales_orders
dbo_09___service_orders
09 - Service Orders
dbo_09___service_orders->marts_fct_service_orders
dbo_10___inventory
10 - Inventory
dbo_10___inventory->stg_inventory
dbo_11___emails
11 - Emails
dbo_11___emails->marts_fct_exchange_emails_with_customer
dbo_12___purchase_orders
12 - Purchase Orders
dbo_12___purchase_orders->marts_fct_purchase_orders
dbo_13___google_ads_campaign_conversions
13 - Google Ads Campaign Conversions
dbo_13___google_ads_campaign_conversions->marts_fct_google_ads_campaign_conversions
dbo_14___google_product_performance
14 - Google Product Performance
dbo_14___google_product_performance->marts_fct_google_daily_product_performance
dbo_15___google_ads_campaign_stats
15 - Google Ads Campaign Stats
dbo_15___google_ads_campaign_stats->marts_fct_google_ads_campaign_daily_stats
dbo_16___service_engineer_performance
16 - Service Engineer Performance
dbo_16___service_engineer_performance->marts_fct_service_engineer_performance
dbo_17___xero_bank_transaction_debits
17 - Xero Bank Transaction Debits
dbo_17___xero_bank_transaction_debits->marts_fct_xero_bank_transaction_debits
dbo_18___xero_bank_transaction_credits
18 - Xero Bank Transaction Credits
dbo_18___xero_bank_transaction_credits->marts_fct_xero_bank_transaction_credits
dbo_19___employee_payroll_hours
19 - Employee Payroll Hours
dbo_19___employee_payroll_hours->marts_vw_employee_timecards_hours
dbo_41___document_date
41 - Document Date
dbo_42___product
42 - Product
dbo_42___product->marts_dim_product
dbo_43___customer
43 - Customer
dbo_43___customer->marts_dim_customer
dbo_44___employee
44 - Employee
dbo_44___employee->marts_vw_dim_employee
dbo_45___order_channel
45 - Order Channel
dbo_45___order_channel->marts_vw_dim_order_channel
dbo_46___order_time
46 - Order Time
dbo_47___transaction
47 - Transaction
dbo_47___transaction->marts_dim_transaction
dbo_48___engineer
48 - Engineer
dbo_48___engineer->marts_vw_dim_employee
dbo_49___order_date
49 - Order Date
dbo_50___service_type
50 - Service Type
dbo_51___google_ads_campaign
51 - Google Ads Campaign
dbo_51___google_ads_campaign->marts_vw_dim_google_ads_campaign
dbo_98___refreshes
98 - Refreshes
dbo_98___refreshes->meta_refresh_metadata