Order Management database schema tables

This topic contains links to the files that describe the Order Management reporting database schema.

• mf_activities
• mf_activity_codes
• mf_activity_object_links
• mf_activity_results
• mf_address_types
• mf_agents
• mf_alerts_localized
• mf_allocation_partitions
• mf_allocation_reservation_items
• mf_allocation_reservation_order_items
• mf_allocation_reservations
• mf_association_types
• mf_attribute_data_types
• mf_attribute_display_types
• mf_attribute_groups
• mf_attribute_handlers
• mf_attribute_object_associations
• mf_attribute_types
• mf_attribute_values
• mf_attribute_values_localized
• mf_attributes
• mf_attributes_localized
• mf_auction_bids
• mf_auctions
• mf_auto_order_items
• mf_auto_order_next_ship_date_compute_types
• mf_auto_order_schedules
• mf_auto_orders
• mf_auto_payment_entries
• mf_auto_payment_entry_logs
• mf_auto_payments
• mf_batch_items
• mf_batch_settings
• mf_batches
• mf_campaign_coupons
• mf_campaign_promotions
• mf_campaign_sources
• mf_campaigns
• mf_cart_types
• mf_carts
• mf_catalog_catalog_groups
• mf_catalog_classifications
• mf_catalog_groups
• mf_catalog_handlers
• mf_catalogs
• mf_categories
• mf_categories_attributes
• mf_categories_localized
• mf_categories_provider_categories
• mf_category_catalogs
• mf_category_sites
• mf_client_types
• mf_clients
• mf_companies
• mf_company_agents
• mf_company_attribute_groups
• mf_company_attributes
• mf_company_categories
• mf_company_countries
• mf_company_payment_methods
• mf_company_payment_processors
• mf_company_payment_processors_payment_methods
• mf_company_providers
• mf_company_searches
• mf_company_settings
• mf_company_shipping_methods
• mf_company_shipping_price_points
• mf_company_shipping_processors
• mf_company_taglines
• mf_company_taxrates
• mf_company_template_object_associations
• mf_company_templates
• mf_countries
• mf_country_postal_codes
• mf_country_regions
• mf_coupon_codes
• mf_coupons
• mf_currencies
• mf_customer_addresses
• mf_customer_credits
• mf_customer_groups
• mf_customer_handlers
• mf_customer_item_association_types
• mf_customer_item_associations
• mf_customer_item_price_levels
• mf_customer_item_price_points
• mf_customer_items
• mf_customer_payment_methods
• mf_customer_promotions
• mf_customer_statistics
• mf_customer_types
• mf_customers
• mf_data_formats
• mf_deliveries
• mf_delivery_items
• mf_email_object_links
• mf_emails
• mf_event_types
• mf_export_files
• mf_ext_item_catalogs
• mf_ext_items
• mf_firms
• mf_flags
• mf_forms
• mf_giftcard_catalogs
• mf_giftcard_transaction_types
• mf_giftcard_transactions
• mf_giftcards
• mf_hold_types
• mf_image_formats
• mf_image_types
• mf_incident_object_links
• mf_incidents
• mf_int_billing_events
• mf_int_companies
• mf_int_errors
• mf_int_invoices
• mf_int_log
• mf_int_reconcile_log
• mf_int_transactions
• mf_internet_address_groups
• mf_internet_addresses
• mf_inventories
• mf_inventory_items
• mf_inventory_lots
• mf_inventory_receipts
• mf_inventory_site_location_transactions
• mf_inventory_site_location_transactions_history
• mf_inventory_site_transactions
• mf_inventory_site_transactions_history
• mf_inventory_transaction_types
• mf_inventory_valuation_types
• mf_invoice_items
• mf_invoice_payments
• mf_invoice_price_adjustment_distributions
• mf_invoice_price_adjustments
• mf_invoice_transaction_types
• mf_invoice_transactions
• mf_invoice_types
• mf_invoices
• mf_iso_cultures
• mf_iso_currencies
• mf_item_associations
• mf_item_backorder_authorization_types
• mf_item_backorder_authorizations
• mf_item_backorderable_types
• mf_item_catalogs
• mf_item_categories
• mf_item_handlers
• mf_item_holds
• mf_item_image_types
• mf_item_images
• mf_item_lists
• mf_item_lists_items
• mf_item_price_calc_basis
• mf_item_price_calc_methods
• mf_item_price_levels
• mf_item_price_point_type
• mf_item_price_points
• mf_item_reviews
• mf_item_selling_destination
• mf_item_serialized_items
• mf_item_site_holds
• mf_item_site_locations
• mf_item_sites
• mf_item_states
• mf_item_sub_types
• mf_item_types
• mf_item_units
• mf_item_vendors
• mf_items
• mf_items_localized
• mf_job_data_formats
• mf_job_error_mode_types
• mf_job_logs
• mf_job_types
• mf_jobs
• mf_listing_types
• mf_listings
• mf_localization_iso_cultures
• mf_localizations
• mf_lot_types
• mf_object_attribute_values
• mf_object_attribute_values_localized
• mf_object_attributes
• mf_object_attributes_localized
• mf_object_codes
• mf_object_events
• mf_object_flags
• mf_object_provider_attribute_cache
• mf_object_provider_attributes
• mf_object_provider_profiles
• mf_object_set_objects
• mf_object_sets
• mf_object_sync_bindings
• mf_object_types
• mf_order_coupon_codes
• mf_order_customer_credits
• mf_order_item_group_display_types
• mf_order_item_groups
• mf_order_item_object_link_types
• mf_order_item_object_links
• mf_order_item_options
• mf_order_items
• mf_order_items_item_serialized_items
• mf_order_payment_methods
• mf_order_payments
• mf_order_price_adjustment_distributions
• mf_order_price_adjustments
• mf_order_priorities
• mf_order_return_codes
• mf_order_return_items
• mf_order_returns
• mf_order_ship_addresses
• mf_order_types
• mf_orders
• mf_packages
• mf_payable_transactions
• mf_payables
• mf_payment_accounts
• mf_payment_attached_objects
• mf_payment_methods
• mf_payment_pending_transactions
• mf_payment_processors
• mf_payment_rmas
• mf_payment_transaction_types
• mf_payment_transactions
• mf_payment_types
• mf_payments
• mf_picking_order_item_picks
• mf_picking_order_items
• mf_picking_order_shipping_orders
• mf_picking_orders
• mf_price_adjustment_reasons
• mf_price_adjustment_types
• mf_promise_date_types
• mf_promotion_codes
• mf_promotion_handlers
• mf_promotion_items
• mf_promotion_types
• mf_promotions
• mf_provider
• mf_provider_attributes
• mf_provider_categories
• mf_provider_profiles
• mf_provider_settings
• mf_provider_types
• mf_purchase_order_items
• mf_purchase_order_receipts
• mf_purchase_order_types
• mf_purchase_orders
• mf_putaway_order_item_puts
• mf_putaway_order_items
• mf_putaway_orders
• mf_request_date_types
• mf_return_items
• mf_return_order_fees
• mf_return_order_items
• mf_return_order_payment_methods
• mf_return_order_price_adjustment_distributions
• mf_return_order_price_adjustments
• mf_return_order_replacement_items
• mf_return_order_types
• mf_return_orders
• mf_returns
• mf_reviews
• mf_searches
• mf_security_levels
• mf_sequences
• mf_set_objects
• mf_shipment_document_types
• mf_shipment_documents
• mf_shipment_items
• mf_shipment_packages
• mf_shipment_tracking_numbers
• mf_shipment_transaction_response_messages
• mf_shipment_transaction_types
• mf_shipment_transactions
• mf_shipments
• mf_shipping_methods
• mf_shipping_order_items
• mf_shipping_order_site_assignment_reject_reasons
• mf_shipping_order_site_assignment_rejected_items
• mf_shipping_order_site_assignments
• mf_shipping_order_types
• mf_shipping_orders
• mf_shipping_orders_open
• mf_shipping_processors
• mf_site_groups
• mf_site_handlers
• mf_site_location_group_levels
• mf_site_location_groups
• mf_site_locations
• mf_site_types
• mf_sites
• mf_source_codes
• mf_source_items
• mf_sources
• mf_states
• mf_tax_tables
• mf_taxation_policy_types
• mf_template_type
• mf_templates
• mf_term_payments
• mf_terms
• mf_textclips
• mf_user_companies
• mf_user_passwords
• mf_users
• mf_vendor_handlers
• mf_vendor_sites
• mf_vendors
• mf_work_orders