Auto-generated from: dbt/models/ — Last scanned: 2026-06-08T13:03:37.954992+00:00

dbt Model Inventory

Staging

80 models -- raw source views from Bronze SQL endpoint.

Model	Path
\
`stg_ax__lgslogisticfile`	`staging/ax/stg_ax__lgslogisticfile.sql`
\
`stg_ax__lgslogisticfileline`	`staging/ax/stg_ax__lgslogisticfileline.sql`
\
`stg_bd__bd_uat_allocations`	`staging/bd/stg_bd__bd_uat_allocations.sql`
\
`stg_bd__bd_uat_allocations_old`	`staging/bd/stg_bd__bd_uat_allocations_old.sql`
\
`stg_bd__productconfiguration`	`staging/bd/stg_bd__productconfiguration.sql`
\
`stg_dataverse__ccslinecostspec`	`staging/dataverse/stg_dataverse__ccslinecostspec.sql`
\
`stg_dataverse__credmancustguaranteeinsurance`	`staging/dataverse/stg_dataverse__credmancustguaranteeinsurance.sql`
\
`stg_dataverse__custgroup`	`staging/dataverse/stg_dataverse__custgroup.sql`
\
`stg_dataverse__custinvoicejour`	`staging/dataverse/stg_dataverse__custinvoicejour.sql`
\
`stg_dataverse__custinvoiceline`	`staging/dataverse/stg_dataverse__custinvoiceline.sql`
\
`stg_dataverse__custinvoicetable`	`staging/dataverse/stg_dataverse__custinvoicetable.sql`
\
`stg_dataverse__custinvoicetrans`	`staging/dataverse/stg_dataverse__custinvoicetrans.sql`
\
`stg_dataverse__custtable`	`staging/dataverse/stg_dataverse__custtable.sql`
\
`stg_dataverse__custtrans`	`staging/dataverse/stg_dataverse__custtrans.sql`
\
`stg_dataverse__dataarea`	`staging/dataverse/stg_dataverse__dataarea.sql`
\
`stg_dataverse__dcttransportcenter`	`staging/dataverse/stg_dataverse__dcttransportcenter.sql`
\
`stg_dataverse__dirpartylocation`	`staging/dataverse/stg_dataverse__dirpartylocation.sql`
\
`stg_dataverse__dirpartytable`	`staging/dataverse/stg_dataverse__dirpartytable.sql`
\
`stg_dataverse__docuref`	`staging/dataverse/stg_dataverse__docuref.sql`
\
`stg_dataverse__ecoresproduct`	`staging/dataverse/stg_dataverse__ecoresproduct.sql`
\
`stg_dataverse__ecoresproducttranslation`	`staging/dataverse/stg_dataverse__ecoresproducttranslation.sql`
\
`stg_dataverse__exchangerate`	`staging/dataverse/stg_dataverse__exchangerate.sql`
\
`stg_dataverse__exchangeratecurrencypair`	`staging/dataverse/stg_dataverse__exchangeratecurrencypair.sql`
\
`stg_dataverse__generaljournalaccountentry`	`staging/dataverse/stg_dataverse__generaljournalaccountentry.sql`
\
`stg_dataverse__generaljournalentry`	`staging/dataverse/stg_dataverse__generaljournalentry.sql`
\
`stg_dataverse__hcmworker`	`staging/dataverse/stg_dataverse__hcmworker.sql`
\
`stg_dataverse__inventbatch`	`staging/dataverse/stg_dataverse__inventbatch.sql`
\
`stg_dataverse__inventdim`	`staging/dataverse/stg_dataverse__inventdim.sql`
\
`stg_dataverse__inventitemgroup`	`staging/dataverse/stg_dataverse__inventitemgroup.sql`
\
`stg_dataverse__inventitemgroupitem`	`staging/dataverse/stg_dataverse__inventitemgroupitem.sql`
\
`stg_dataverse__inventjournaltable`	`staging/dataverse/stg_dataverse__inventjournaltable.sql`
\
`stg_dataverse__inventjournaltrans`	`staging/dataverse/stg_dataverse__inventjournaltrans.sql`
\
`stg_dataverse__inventtable`	`staging/dataverse/stg_dataverse__inventtable.sql`
\
`stg_dataverse__inventtrans`	`staging/dataverse/stg_dataverse__inventtrans.sql`
\
`stg_dataverse__inventtransorigin`	`staging/dataverse/stg_dataverse__inventtransorigin.sql`
\
`stg_dataverse__lgsaddresstable`	`staging/dataverse/stg_dataverse__lgsaddresstable.sql`
\
`stg_dataverse__lgslogisticfileline`	`staging/dataverse/stg_dataverse__lgslogisticfileline.sql`
\
`stg_dataverse__lgslogisticfiletable`	`staging/dataverse/stg_dataverse__lgslogisticfiletable.sql`
\
`stg_dataverse__logisticsaddresscountryregion`	`staging/dataverse/stg_dataverse__logisticsaddresscountryregion.sql`
\
`stg_dataverse__logisticsaddressstate`	`staging/dataverse/stg_dataverse__logisticsaddressstate.sql`
\
`stg_dataverse__logisticselectronicaddress`	`staging/dataverse/stg_dataverse__logisticselectronicaddress.sql`
\
`stg_dataverse__logisticslocation`	`staging/dataverse/stg_dataverse__logisticslocation.sql`
\
`stg_dataverse__logisticspostaladdress`	`staging/dataverse/stg_dataverse__logisticspostaladdress.sql`
\
`stg_dataverse__mainaccount`	`staging/dataverse/stg_dataverse__mainaccount.sql`
\
`stg_dataverse__mainaccountcategory`	`staging/dataverse/stg_dataverse__mainaccountcategory.sql`
\
`stg_dataverse__pdsbatchattributes`	`staging/dataverse/stg_dataverse__pdsbatchattributes.sql`
\
`stg_dataverse__prodjournalroute`	`staging/dataverse/stg_dataverse__prodjournalroute.sql`
\
`stg_dataverse__prodjournaltable`	`staging/dataverse/stg_dataverse__prodjournaltable.sql`
\
`stg_dataverse__prodtable`	`staging/dataverse/stg_dataverse__prodtable.sql`
\
`stg_dataverse__purchline`	`staging/dataverse/stg_dataverse__purchline.sql`
\
`stg_dataverse__purchtable`	`staging/dataverse/stg_dataverse__purchtable.sql`
\
`stg_dataverse__reasontableref`	`staging/dataverse/stg_dataverse__reasontableref.sql`
\
`stg_dataverse__routetable`	`staging/dataverse/stg_dataverse__routetable.sql`
\
`stg_dataverse__salesline`	`staging/dataverse/stg_dataverse__salesline.sql`
\
`stg_dataverse__salestable`	`staging/dataverse/stg_dataverse__salestable.sql`
\
`stg_dataverse__srsanalysisenums`	`staging/dataverse/stg_dataverse__srsanalysisenums.sql`
\
`stg_dataverse__vendgroup`	`staging/dataverse/stg_dataverse__vendgroup.sql`
\
`stg_dataverse__vendinvoicejour`	`staging/dataverse/stg_dataverse__vendinvoicejour.sql`
\
`stg_dataverse__vendinvoicetrans`	`staging/dataverse/stg_dataverse__vendinvoicetrans.sql`
\
`stg_dataverse__vendtable`	`staging/dataverse/stg_dataverse__vendtable.sql`
\
`stg_dataverse__vendtrans`	`staging/dataverse/stg_dataverse__vendtrans.sql`
\
`stg_dataverse__whscontainertype`	`staging/dataverse/stg_dataverse__whscontainertype.sql`
\
`stg_dataverse__whslicenseplate`	`staging/dataverse/stg_dataverse__whslicenseplate.sql`
\
`stg_dataverse__whslocationprofile`	`staging/dataverse/stg_dataverse__whslocationprofile.sql`
\
`stg_dataverse__whsworkline`	`staging/dataverse/stg_dataverse__whsworkline.sql`
\
`stg_dataverse__whsworktable`	`staging/dataverse/stg_dataverse__whsworktable.sql`
\
`stg_dataverse__wmslocation`	`staging/dataverse/stg_dataverse__wmslocation.sql`
\
`stg_mon__cu_utilization`	`staging/monitoring/stg_mon__cu_utilization.sql`
\
`stg_mon__dbt_node_manifest`	`staging/monitoring/stg_mon__dbt_node_manifest.sql`
\
`stg_mon__dbt_node_results`	`staging/monitoring/stg_mon__dbt_node_results.sql`
\
`stg_mon__dbt_runs`	`staging/monitoring/stg_mon__dbt_runs.sql`
\
`stg_mon__freshness_checks`	`staging/monitoring/stg_mon__freshness_checks.sql`
\
`stg_mon__ingestion_runs`	`staging/monitoring/stg_mon__ingestion_runs.sql`
\
`stg_mon__pipeline_runs`	`staging/monitoring/stg_mon__pipeline_runs.sql`
\
`stg_mon__pipeline_stages`	`staging/monitoring/stg_mon__pipeline_stages.sql`
\
`stg_sharepoint_commercial_budget_rls`	`staging/sharepoint/stg_sharepoint_commercial_budget_rls.sql`
\
`stg_sharepoint_kpi`	`staging/sharepoint/stg_sharepoint_kpi.sql`
\
`stg_sharepoint_kpi_comments`	`staging/sharepoint/stg_sharepoint_kpi_comments.sql`
\
`stg_sharepoint_purchase_budget`	`staging/sharepoint/stg_sharepoint_purchase_budget.sql`
\
`stg_sharepoint_sales_budget`	`staging/sharepoint/stg_sharepoint_sales_budget.sql`

Intermediate

14 models -- business logic, enrichment, deduplication.

Model	Path
\
`int_account_bridge_built`	`intermediate/finance/int_account_bridge_built.sql`
\
`int_commercial_budget_built`	`intermediate/finance/int_commercial_budget_built.sql`
\
`int_exchange_rates_expanded`	`intermediate/finance/int_exchange_rates_expanded.sql`
\
`int_financials_combined`	`intermediate/finance/int_financials_combined.sql`
\
`int_allocations_old_deduped`	`intermediate/trading/int_allocations_old_deduped.sql`
\
`int_batch_base`	`intermediate/trading/int_batch_base.sql`
\
`int_batch_lineage_built`	`intermediate/trading/int_batch_lineage_built.sql`
\
`int_batch_metadata_latest`	`intermediate/trading/int_batch_metadata_latest.sql`
\
`int_batch_references`	`intermediate/trading/int_batch_references.sql`
\
`int_futures_accounts_merged`	`intermediate/trading/int_futures_accounts_merged.sql`
\
`int_inventdim_enriched`	`intermediate/trading/int_inventdim_enriched.sql`
\
`int_inventory_movements_base`	`intermediate/trading/int_inventory_movements_base.sql`
\
`int_productconfiguration_deduped`	`intermediate/trading/int_productconfiguration_deduped.sql`
\
`int_trade_departure_dates`	`intermediate/trading/int_trade_departure_dates.sql`

Marts

88 models -- dimensional tables and fact tables in Gold Warehouse.

Model	Path
\
`dim_account_bridge`	`marts/dim_account_bridge.sql`
\
`dim_account_customer`	`marts/dim_account_customer.sql`
\
`dim_account_loading`	`marts/dim_account_loading.sql`
\
`dim_account_transporter`	`marts/dim_account_transporter.sql`
\
`dim_account_unloading`	`marts/dim_account_unloading.sql`
\
`dim_account_vendor`	`marts/dim_account_vendor.sql`
\
`dim_area`	`marts/dim_area.sql`
\
`dim_batch`	`marts/dim_batch.sql`
\
`dim_batch_lineage`	`marts/dim_batch_lineage.sql`
\
`dim_batch_no_snapshot`	`marts/dim_batch_no_snapshot.sql`
\
`dim_calendar`	`marts/dim_calendar.sql`
\
`dim_config`	`marts/dim_config.sql`
\
`dim_invent_color`	`marts/dim_invent_color.sql`
\
`dim_invent_site`	`marts/dim_invent_site.sql`
\
`dim_invent_size`	`marts/dim_invent_size.sql`
\
`dim_invent_status`	`marts/dim_invent_status.sql`
\
`dim_invoice`	`marts/dim_invoice.sql`
\
`dim_item`	`marts/dim_item.sql`
\
`dim_licenseplate`	`marts/dim_licenseplate.sql`
\
`dim_logistics`	`marts/dim_logistics.sql`
\
`dim_logistics_addresses`	`marts/dim_logistics_addresses.sql`
\
`dim_logistics_addresses_buyer`	`marts/dim_logistics_addresses_buyer.sql`
\
`dim_logistics_addresses_delivery`	`marts/dim_logistics_addresses_delivery.sql`
\
`dim_logistics_addresses_loading`	`marts/dim_logistics_addresses_loading.sql`
\
`dim_logistics_addresses_transporter`	`marts/dim_logistics_addresses_transporter.sql`
\
`dim_logistics_addresses_transportertp`	`marts/dim_logistics_addresses_transportertp.sql`
\
`dim_logistics_addresses_unloading`	`marts/dim_logistics_addresses_unloading.sql`
\
`dim_mainaccount`	`marts/dim_mainaccount.sql`
\
`dim_party`	`marts/dim_party.sql`
\
`dim_party_addresses`	`marts/dim_party_addresses.sql`
\
`dim_party_contact_info`	`marts/dim_party_contact_info.sql`
\
`dim_pc_product_group`	`marts/dim_pc_product_group.sql`
\
`dim_pc_trading_book`	`marts/dim_pc_trading_book.sql`
\
`dim_trade_orders`	`marts/dim_trade_orders.sql`
\
`dim_traders`	`marts/dim_traders.sql`
\
`dim_transport_routes`	`marts/dim_transport_routes.sql`
\
`dim_wmslocation`	`marts/dim_wmslocation.sql`
\
`fact_cheesebackcalc`	`marts/fact_cheesebackcalc.sql`
\
`fact_commercial_budget`	`marts/fact_commercial_budget.sql`
\
`fact_commercial_budget_rls`	`marts/fact_commercial_budget_rls.sql`
\
`fact_credlimit`	`marts/fact_credlimit.sql`
\
`fact_customerinvoice`	`marts/fact_customerinvoice.sql`
\
`fact_exchange_rates`	`marts/fact_exchange_rates.sql`
\
`fact_financials`	`marts/fact_financials.sql`
\
`fact_futures_accounts`	`marts/fact_futures_accounts.sql`
\
`fact_futures_netpositions`	`marts/fact_futures_netpositions.sql`
\
`fact_generalledgertransactions`	`marts/fact_generalledgertransactions.sql`
\
`fact_inventory_90d_flow`	`marts/fact_inventory_90d_flow.sql`
\
`fact_inventory_movements`	`marts/fact_inventory_movements.sql`
\
`fact_inventory_movements_nolineage`	`marts/fact_inventory_movements_nolineage.sql`
\
`fact_inventory_snapshot`	`marts/fact_inventory_snapshot.sql`
\
`fact_inventory_snapshot_checkpoint`	`marts/fact_inventory_snapshot_checkpoint.sql`
\
`fact_kpi`	`marts/fact_kpi.sql`
\
`fact_kpi_comments`	`marts/fact_kpi_comments.sql`
\
`fact_marex`	`marts/fact_marex.sql`
\
`fact_oldstock_sales`	`marts/fact_oldstock_sales.sql`
\
`fact_sca_allocations`	`marts/fact_sca_allocations.sql`
\
`fact_sca_allocations_snapshot_purchase`	`marts/fact_sca_allocations_snapshot_purchase.sql`
\
`fact_sca_allocations_snapshot_sales`	`marts/fact_sca_allocations_snapshot_sales.sql`
\
`fact_stonex_cashsettlements`	`marts/fact_stonex_cashsettlements.sql`
\
`fact_stonex_monies`	`marts/fact_stonex_monies.sql`
\
`fact_stonex_netpositions`	`marts/fact_stonex_netpositions.sql`
\
`fact_stonex_openpositions`	`marts/fact_stonex_openpositions.sql`
\
`fact_temp_production_hours`	`marts/fact_temp_production_hours.sql`
\
`fact_trade`	`marts/fact_trade.sql`
\
`fact_trade_copy`	`marts/fact_trade_copy.sql`
\
`fact_trade_rls`	`marts/fact_trade_rls.sql`
\
`fact_vendinvoice`	`marts/fact_vendinvoice.sql`
\
`fact_vesper_exchange_rates`	`marts/fact_vesper_exchange_rates.sql`
\
`fact_vesper_futures`	`marts/fact_vesper_futures.sql`
\
`fact_vesper_spot`	`marts/fact_vesper_spot.sql`
\
`fact_vesper_trade_for_lrmodel`	`marts/fact_vesper_trade_for_lrmodel.sql`
\
`fact_warehousework`	`marts/fact_warehousework.sql`
\
`info_report_owners`	`marts/info_report_owners.sql`
\
`metrics`	`marts/metrics.sql`
\
`mon_dim_bronze_method`	`marts/monitoring/mon_dim_bronze_method.sql`
\
`mon_dim_dbt_node`	`marts/monitoring/mon_dim_dbt_node.sql`
\
`mon_dim_vendor`	`marts/monitoring/mon_dim_vendor.sql`
\
`mon_fact_cu_utilization`	`marts/monitoring/mon_fact_cu_utilization.sql`
\
`mon_fact_dbt_node_executions`	`marts/monitoring/mon_fact_dbt_node_executions.sql`
\
`mon_fact_dbt_runs`	`marts/monitoring/mon_fact_dbt_runs.sql`
\
`mon_fact_freshness_checks`	`marts/monitoring/mon_fact_freshness_checks.sql`
\
`mon_fact_ingestion_runs`	`marts/monitoring/mon_fact_ingestion_runs.sql`
\
`mon_fact_pipeline_runs`	`marts/monitoring/mon_fact_pipeline_runs.sql`
\
`mon_fact_pipeline_stages`	`marts/monitoring/mon_fact_pipeline_stages.sql`
\
`refresh`	`marts/refresh.sql`
\
`temp_inventdim_calc`	`marts/temp_inventdim_calc.sql`
\
`vw_inventory_open_po`	`marts/views/vw_inventory_open_po.sql`