---
sourceDocument: Xanadu Finance and Supply Chain
sourceDocumentLink: https://servicenow-prod.fluidtopics.net/r/xanadu/source-to-pay-operations

 Release :

    - xanadu

ft:locale :

    - en-US

ft:publication_title :

    - Xanadu Finance and Supply Chain

ft:clusterId :

    - stpop

bundleId :

    - stpop

workflow :

    - Creator


---

# S2P integration framework transform maps and subflows

# Source-to-Pay integration framework transform maps and subflows {#ariaid-title1}

* Release version: Xanadu
* 
* Updated August 1, 2024
* 
* ![](https://www.servicenow.com/docs/portal-asset/ico-clock) 4 minutes to read

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 {#s2p-transform-maps-flows__section_jkm_kpp_rbc}

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.

{#s2p-transform-maps-flows__ul_mjd_mpp_rbc}

## Subflows {#s2p-transform-maps-flows__section_ajj_npp_rbc}

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.

{#s2p-transform-maps-flows__ul_bjj_npp_rbc}