Source-to-Pay integration framework transform maps and subflows

The transform maps transform the source-to-pay data from the inbound staging tables to the Source-to-Pay primary data tables. The subflows move the source-to-pay data from the outbound staging tables to a third-party ERP system.

Transform maps

The following transform maps transform the source-to-pay data from the inbound staging tables to the Source-to-Pay primary data tables.

• Load product model:

  Transforms product model data from the sn_fcms_intg_cmdb_model_stage staging table to the cmdb_model primary table.

• Load service model:

  Transforms service model data from the sn_fcms_intg_cmdb_service_model_stage staging table to the cmdb_service_product_model primary table.

• Transform CMN location:

  Transforms CMN location data from the sn_fcms_intg_cmn_location_stage staging table to the cmn_location primary table.

• Master data cost center:

  Transforms cost center data from the sn_fcms_intg_imp_cost_center staging table to the cmn_cost_center primary table.

• Load department:

  Transforms department data from the sn_fcms_intg_department_stage staging table to the cmn_department primary table.

• Transform ERP Plant Address:

  Transforms ERP plant address data from the sn_fcms_intg_erp_plant_address_mapping_stage staging table to the sn_fcms_intg_erp_plant_address_mapping primary table.

• Load FX currency:

  Transforms FX currency data from the sn_fcms_intg_fx_currency_stage staging table to the sn_fin_fx_currency primary table.

• Load FX rate:

  Transforms FX rate data from the sn_fcms_intg_fx_rate_stage staging table to the sn_fin_fx_rate primary table.

• GL account load data:

  Transforms GL account data from the sn_fcms_intg_gl_account_stage staging table to the sn_fin_gl_account primary table.

• Import availability updates:

  Transforms Import availability updates from the sn_spend_intg_imp_availability staging table to the sn_shop_supplier_product primary table.

• Cost allocation stage:

  Transforms cost allocation data from the sn_spend_intg_imp_cost_allocation staging table to the sn_shop_cost_allocation primary table.

• Order stage:

  Transforms purchase order data from the sn_fcms_intg_imp_order staging table to the sn_shop_purchase_order primary table.

• Order line stage:

  Transforms purchase order line data from the sn_fcms_intg_imp_order_line staging table to the sn_shop_purchase_order_line primary table.

• Receipt stage:

  Transforms receipts data from the sn_fcms_intg_imp_receipt staging table to the sn_shop_receipt primary table.

• Transform legal entities:

  Transforms legal entity data from the sn_fcms_intg_legal_entity_stage staging table to the sn_fin_legal_entity primary table.

• Transform office location:

  Transforms office location data from the sn_fcms_intg_office_location_stage staging table to the sn_shop_office_location primary table.

• Load payment terms:

  Transforms payment terms data from the sn_fcms_intg_payment_term_stage staging table to the sn_shop_payment_term primary table.

• Load product category:

  Transforms product category data from the sn_fcms_intg_cmdb_model_category_stage staging table to the cmdb_model_category primary table.

• Master data purchase entity:

  Transforms purchase entity data from the sn_fcms_intg_imp_purchase_entity staging table to the sn_fin_purchasing_entity primary table.

• Load supplier product:

  Transforms supplier product data from the sn_spend_intg_supplier_product_stage staging table to the sn_shop_supplier_product primary table.

• Transform supplier contact details:

  Transforms supplier contact details data from the sn_fcms_intg_supplier_contact_inbound staging table to the vm_vdr_contact primary table.

• Master data supplier:

  Transforms supplier data from the sn_fcms_intg_imp_supplier staging table to the sn_fin_supplier primary table.

• Load legal entity mapping data:

  Transforms supplier legal entity data from the sn_fcms_intg_supplier_legal_entity_inbound staging table to the sn_fin_supplier_detail primary table.

• Load supplier address information:

  Transforms supplier location data from the sn_fcms_intg_supplier_location_inbound staging table to the sn_slm_m2m_location primary table.

• Transform supplier payment:

  Transforms supplier payment data from the sn_fcms_intg_supplier_payment_inbound_stage staging table to the sn_fin_supplier_payment primary table.

• Invoice import:

  Transforms invoice details from the sn_spend_intg_imp_invoice staging table to the sn_shop_invoice primary table.

• Invoice line import:

  Transforms invoice line details from the sn_spend_intg_imp_invoice_line staging table to the sn_shop_invoice_line primary table.

• Invoice payment detail import:

  Transforms invoice payment details from the sn_spend_intg_imp_invoice_payment_detail staging table to the sn_shop_invoice_payment_detail primary table.

• Transform organization tax details:

  Transforms organization tax details data from the sn_fcms_intg_org_tax_detail_inbound staging table to the sn_fin_org_tax_detail primary table.

• Spend Shipment Import:

  Transforms spend shipment import details from the sn_spend_intg_imp_shipment staging table to the sn_shop_shipment_details primary table.

• Fixed asset details:

  Transforms fixed asset details from the sn_fcms_intg_imp_fixed_asset_details staging table to the sys_import_set_row primary table.

Subflows

The following subflows move the source-to-pay data from the outbound staging tables to a third-party ERP system.

• Create cost allocation on outbound table:

  Moves cost allocation data from the sn_shop_cost_allocation primary table to the sn_spend_intg_outbound_cost_allocation staging table.

• Create purchase order on outbound order table:

  Moves purchase order data from the sn_shop_purchase_order primary table to the sn_spend_intg_outbound_purchase_order staging table.

• Create purchase order line on outbound order line table:

  Moves purchase order line data from the sn_shop_purchase_order_line primary table to the sn_spend_intg_outbound_purchase_order_line staging table.

• Create/update receipt on outbound table:

  Moves receipt data from the sn_shop_receipt primary table to the sn_spend_intg_outbound_receipt staging table.

• Update Supplier Contact Outbound from trigger Supplier Contact:

  Moves supplier contact details data from the vm_vdr_contact primary table to the sn_spend_intg_supplier_contact_outbound staging table.

• Update Supplier Legal entity details from Legal entity mapping:

  Moves supplier legal entity data from the sn_fin_supplier_detail primary table to the sn_fcms_intg_supplier_legal_entity_outbound staging table.

• Update Supplier Location outbound from M2M location:

  Moves supplier location data from the sn_slm_m2m_location primary table to the sn_spend_intg_supplier_location_outbound staging table.

• Update Supplier Outbound from trigger Supplier:

  Moves supplier data from the sn_fin_supplier primary table to the sn_spend_intg_outbound_supplier​ staging table.

• Update Supplier Payment Outbound from trigger Payment:

  Moves supplier payment data from the sn_fin_supplier_payment primary table to the sn_spend_intg_supplier_payment_outbound_stage staging table.

• Update tax details outbound from trigger tax details:

  Moves organization tax details data from the sn_fin_org_tax_detail primary table to the sn_spend_intg_outbound_tax_detail staging table.