Source-to-Pay integration framework transform maps and flows

The transform maps transform the source-to-pay data from the inbound staging tables to the Source-to-Pay primary data tables. The flows 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.

• 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.
• 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.
• 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.
• 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.
• 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 department: Transforms department data from the sn_fcms_intg_department_stage staging table to the cmn_department 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.
• 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 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.
• 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.
• 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.
• 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.
• 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.
• 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.
• 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.
• 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.
• 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 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.

Flows

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

• 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.
• 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.
• 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 Payment: Moves supplier data from the sn_fin_supplier_payment primary table to the sn_spend_intg_outbound_supplier​ 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.