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.

Tableau 1. Transform map details

Transform map	Description
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.
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.
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.
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:
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.
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.
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 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.

Subflows

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

Tableau 2. Subflow details

Subflows	Description
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.