Inbound staging tables for Sourcing and Procurement Operations

The inbound staging tables for Sourcing and Procurement Operations temporarily store sourcing and procurement data before it is sent to the SPO primary data tables.

• CMDB Model Category Stage inbound staging table
  The CMDB Model Category Stage inbound [sn_fcms_intg_cmdb_model_category_stage] staging table temporarily stores important data about product model categories before this data is sent to the primary table.
• CMDB Service Model Stage inbound staging table
  The CMDB Service Model Stage inbound [sn_fcms_intg_cmdb_service_model_stage] staging table temporarily stores important data about service models before this data is sent to the primary table.
• CMN Location Stage inbound staging table
  The CMN Location Stage inbound [sn_fcms_intg_cmn_location_stage] staging table temporarily stores important data about locations before this data is sent to the primary table.
• Catalog Import staging table
  The Catalog Import [sn_spend_intg_imp_catalog] staging table temporarily stores important data about catalog imports before this data is sent to the primary table.
• Catalog Error staging table
  The Catalog Error [sn_spend_intg_catalog_error] staging table temporarily stores important data about any catalog errors before this data is sent to the primary table.
• Cost Center Stage inbound staging table
  The Cost Center Stage inbound [sn_fcms_intg_imp_cost_center] staging table temporarily stores important data about cost centers before this data is sent to the primary table. You can use this table to lookup all the cost center details.
• Department Stage inbound staging table
  The Department Stage inbound [sn_fcms_intg_department_stage] staging table temporarily stores important data about departments before this data is sent to the primary table.
• ERP Plant Address Mapping Stage inbound staging table
  The ERP Plant Address Mapping Stage inbound [sn_fcms_intg_erp_plant_address_mapping_stage] staging table temporarily stores important data about ERP plant address before this data is sent to the primary table.
• FX Currency Stage inbound staging table
  The FX Currency Stage inbound [sn_fcms_intg_fx_currency_stage] staging table temporarily stores important data about FX currencies before this data is sent to the primary table.
• FX Rate Stage inbound staging table
  The FX Rate Stage inbound [sn_fcms_intg_fx_rate_stage] staging table temporarily stores important data about FX rates before this data is sent to the primary table.
• Fixed asset details stage inbound table
  The Fixed asset details inbound [sn_fcms_intg_imp_fixed_asset_details] staging table temporarily stores important data about imported invoice line before this data is sent to the primary table.
• GL Account Stage inbound staging table
  The GL Account Stage inbound [sn_fcms_intg_gl_account_stage] staging table temporarily stores important data about General Ledger (GL) accounts before this data is sent to the primary table.
• Import Availability Updates inbound staging table
  The Import Availability Updates inbound [sn_spend_intg_imp_availability] staging table temporarily stores important data about cost allocations before this data is sent to the primary table.
• Availability Error staging table
  The Availability Error [sn_spend_intg_availability_error] staging table stores important data about availability error so that an ERP integrator can export this data to a third-party ERP system.
• Cost Allocation inbound staging table (Deprecated)
  The Cost Allocation inbound [sn_spend_intg_imp_cost_allocation] staging table temporarily stores important data about cost allocations before this data is sent to the primary table.
• Invoice inbound staging table
  The Invoice inbound [sn_shop_invoice] staging table temporarily stores important data about shopping invoices before this data is sent to the primary table.
• Purchase Order inbound staging table
  The Purchase Order inbound [sn_fcms_intg_imp_order] staging table temporarily stores important data about purchase orders before this data is sent to the primary table.
• Purchase Order Line inbound staging table
  The Purchase Order Line inbound [sn_fcms_intg_imp_order_line] staging table temporarily stores important data about purchase order lines before this data is sent to the primary table.
• Receipt inbound staging table
  The Receipt inbound [sn_fcms_intg_imp_receipt] staging table temporarily stores important data about receipts before this data is sent to the primary table.
• Legal Entity Stage inbound staging table
  The Legal entity stage inbound [sn_fcms_intg_legal_entity_stage] staging table temporarily stores important data about legal entities before this data is sent to the primary table.
• Office Location Stage inbound staging table
  The Office Location Stage inbound [sn_fcms_intg_office_location_stage] staging table temporarily stores important data about office locations before this data is sent to the primary table.
• Order Acknowledgement staging table
  The Order Acknowledgment [sn_spend_intg_imp_purchase_order_ack] staging table temporarily stores important data about order acknowledgements before this data is sent to the primary table.
• Order Acknowledgement Error staging table
  The Order Acknowledgement Error [sn_spend_intg_order_ack_error] staging table temporarily stores important data about any errors in the order price imports before this data is sent to the primary table.
• Payment Terms Stage inbound staging table
  The Payment Terms Stage inbound [sn_fcms_intg_payment_term_stage] staging table temporarily stores important data about payment terms before this data is sent to the primary table.
• Price Import staging table
  The Price Import [sn_spend_intg_imp_price] staging table temporarily stores important data about price imports before this data is sent to the primary table.
• Price Error outbound staging table
  The Price Error [sn_spend_intg_price_error] staging table stores important data about pricing error so that an ERP integrator can export this data to a third-party ERP system.
• Product Model Stage inbound staging table
  The Product Model Stage inbound [sn_fcms_intg_cmdb_model_stage] staging table temporarily stores important data about product models before this data is sent to the primary table.
• Purchase Entity Stage inbound staging table
  The Purchase Entity Stage inbound [sn_fcms_intg_imp_purchase_entity] staging table temporarily stores important data about purchase entities before this data is sent to the primary table.
• Purchase Line Stage inbound staging table
  The Purchase Entity Stage inbound [sn_spend_intg_purchase_line] staging table temporarily stores important data about purchase entities before this data is sent to the primary table.
• Purchase Requisition staging table
  The Purchase requisition [sn_spend_intg_purchase_requisition] staging table temporarily stores important data about purchase requests before this data is sent to the primary table.
• Spend Shipment Import inbound staging table
  The Spend Shipment Import inbound [sn_spend_intg_imp_shipment] staging table temporarily stores important data about spend shipment imports before this data is sent to the primary table.
• Shipment Error staging table
  The Shipment Error [sn_spend_intg_shipment_error] staging table temporarily stores important data on any shipment errors before this data is sent to the primary table.
• Supplier Product Stage inbound staging table
  The Supplier Product Stage inbound [sn_spend_intg_supplier_product_stage] staging table temporarily stores important data about supplier products before this data is sent to the primary table.
• Third Party Sourcing Registration staging table
  The Third Party Sourcing Registration [sn_spend_intg_sourcing_vendor] table temporarily stores important data on third party sourcing registrations before this data is sent to the primary table.
• Third Party Unit Mapping staging table
  The Third Party Unit Mapping [sn_spend_intg_third_party_uom_map] staging table temporarily stores important data on third party mapping before this data is sent to the primary table.
• Third Party Unit staging table
  The Third Party Unit [sn_spend_intg_third_party_uom] staging table temporarily stores important data on third party units before this data is sent to the primary table.
• Unit of Measure inbound staging table
  The Third Party Unit [sn_fcms_intg_imp_uom] staging table temporarily stores important data on third party units before this data is sent to the primary table.

Related concepts

• Inbound staging tables for Supplier Lifecycle Operations
• Inbound staging tables for Accounts Payable Operations