Components installed with Source-to-Pay Common Architecture

  • Release version: Yokohama
  • Updated February 18, 2025
  • 9 minutes to read

    • Several types of components are installed with the installation of the Source-to-Pay Common Architecture application, including tables and user roles.

    Roles installed

    Role title [name] Description Contains roles

    Accounts Payable Viewer

    [sn_shop.accounts_payable_viewer]

    		 Read access to purchase orders, invoices, and other task-related objects that arise from purchase order creation. None

    Acknowledgment Task Owner

    [sn_shop.acknowledgment_task_owner]

    		 Access to all purchase orders and purchase requisitions. Read-only access to the main objects, but can update assigned tasks. None
    Business Owner

    [sn_shop.invoice_owner]

    		 Access only to their own invoices and related data. None.

    Procurement Administrator

    [sn_shop.procurement_administrator]

    		 Access to the primary data and administration sections of the Purchase Automation module.
    • Procurement Primary Data Admin [sn_fin.procurement_primary_data_admin]
    • Procurement Specialist [sn_shop.procurement_specialist]

    Procurement Common Administrator

    [sn_shop.procurement_common_admin]

    		 Access to all tables, including deletion of records, in the Source-to-Pay Common Architecture application. Procurement Common User [sn_shop.procurement_common_user]

    Procurement Common Reader

    [sn_shop.procurement_common_reader]

    		 Read access to all tables available in the Source-to-Pay Common Architecture application. Procurement User [sn_fin.procurement_user]

    Procurement Common User

    [sn_shop.procurement_common_user]

    		 Access to perform, create, and update operations on all tables in the Source-to-Pay Common Architecture application. Procurement Common Reader [sn_shop.procurement_common_reader]

    Procurement Specialist

    [sn_shop.procurement_specialist]

    		 Access to all the data of the Sourcing and Purchasing Automation module, except the primary data.
    • Procurement User [sn_fin.procurement_user]
    • Contract Manager [contract_manager]
    Procurement Specialist_Manager

    [sn_shop.procurement_specialist_manager]

    		 Access to the Procurement Team Performance Dashboard to view your organization's overall performance. This role has the same access as a procurement specialist, except that they have access to the manager dashboards.
    • Procurement Specialist [sn_shop.procurement_specialist]
    • Procurement Team Manager [sn_spend_psd.manager]

    Purchasing Task Owner

    [sn_shop.purchasing_task_owner]

    		 Access to all purchase orders, requisitions, negotiations, sourcing requests, and purchasing tasks. None

    Shopper

    [sn_shop.shopper]

    		 Access to the Shopping Hub portal to make requests and purchases. None

    Shopping Hub Administrator

    [sn_shop.shopping_hub_admin]

    		 Access to all modules of the Source-to-Pay Common Architecture application.
    • Decision Table Admin [decision_table_admin]
    • Procurement User [sn_fin.procurement_user]
    • Model Manager [model_manager]
    • Category Manager [category_manager]

    Tables installed

    Table Description
    Acknowledgement Task

    [sn_shop_acknowledgement_task]

    		 Extends the Finance Task table and stores acknowledgments such as the milestone and receipt task.
    Approval Group

    [sn_shop_approval_group]

    		 Stores a set of approval rules.
    Approval Group Plan

    [sn_shop_approval_group_plan]

    		 Stores the approval plans that determine how the overall approval process is run.
    Approval Plan Detail

    [sn_shop_approval_plan_detail]

    		 Stores an instance of the approval record for a purchase line that is created based on the approval plan.
    Approval Reminder Task

    [sn_shop_approval_reminder_task]

    		 Extends the Purchasing task table and stores information about the specific tasks required to complete the approval process.
    Approval Rule

    [sn_shop_approval_rule]

    		 Stores the rule that triggers the creation of an approval record. It uses a condition builder to build the trigger condition for approvals.
    Approval Rule Composition

    [sn_shop_approval_rule_composition]

    		 Stores information about the approval rule and its associated approval group.

    Attribute

    [sn_shop_attribute]

    		 Stores specific attribute types and the values that are associated with a product model. For example, a laptop can have an attribute for the type of memory used, which can be SSD or Hard disk.

    Attribute Set

    [sn_shop_attribute_set]

    		 Stores a group of attribute types that can later be associated with a supplier product. For example, Memory, Graphic card, and CPU can be an attribute set that can be associated with a product group.

    Attribute Type

    [sn_shop_attribute_type]

    		 Stores the various types of attributes that are used when creating a product attribute.
    Capitalization Policy

    [sn_shop_capitalization_policy]

    		 Stores the condition based on which an asset is capitalized, and a fixed asset record is created.
    Cart Delivery

    [sn_shop_cart_delivery]

    		 Stores information related to the delivery details of items in a shopping cart or purchase requisition. It has various details, such as order type, delivery location, expected delivery date, estimated shipping, payment allocations, and so on.
    Cart Header

    [sn_shop_cart_header]

    		 Stores high-level information about the purchase requisition. It has various details, such as requisition ID, shopper details, requisition date, shopper payable amount, status, and so on.
    Cart Line

    [sn_shop_cart_line]

    		 Stores the details of a purchase line that is added to a cart. It has various details such as the supplier product selected, checkout type, business owner, delivery location, and so on.
    Credit Allocation Rules

    [sn_shop_credit_allocation_rules]

    		 Stores the credit allocation rules that are based on how a credit is allocated to an individual shopper. The allocation can be based on the inventory asset or user condition.
    Delivery Address Task

    [sn_shop_delivery_address_task]

    		 Extends the Purchasing Task table and stores the tasks that are associated with verifying and validating the delivery location for a purchase line.
    Delivery Location

    [sn_shop_delivery_location]

    		 Stores the delivery location for a given shop line or cart line.
    Employee Credit

    [sn_shop_employee_credit]

    		 Stores the credit amount that is allocated for a user with supporting information such as the responsible cost center and credit allocation rule.
    ERP Address Mapping

    [sn_shop_erp_address_map]

    		 Stores the mapping between the ERP address and the location.
    ERP Asset Category Mapping

    [sn_shop_erp_asset_category_map]

    		 Stores the mapping between the ERP source and the capitalization policy.
    ERP Material Group Mapping

    [sn_shop_erp_material_group_map]

    		 Stores the mapping between the ERP source, model category, and material group.
    Handling Fee

    [sn_shop_handling_fee]

    		 Stores details about handling fees, which are additional charges added to purchase requests under specific conditions.
    Integration Error

    [sn_shop_erp_error_task]

    		 Single table to address all integration errors.
    Invoice

    [sn_shop_invoice]

    		 Stores important data about shopping invoices temporarily before this data is sent to the primary table.
    Invoice cost allocation

    [sn_shop_invoice_cost_allocation]

    		 Stores the allocated invoice line cost across multiple cost centers or ledger accounts.
    Invoice Line

    [sn_shop_invoice_line]

    		 Stores important data about imported invoice line temporarily before this data is sent to the primary table.
    Invoice Payment Detail

    [sn_shop_invoice_payment_detail]

    		 Stores important data about supplier data temporarily before this data is sent to the primary table.
    Invoice Tax Line

    [sn_shop_invoice_tax_line]

    		 Extends the Base Tax Line table and stores the tax lines for purchases that are invoiced.
    Job Code

    [sn_shop_job_code]

    		 Stores the job codes that are associated with business owners that primarily drive the approval hierarchy.
    Ledger Assignment Rules

    [sn_shop_ledger_assignment_rule]

    		 Stores the rules that apply to the supplier products, product model or product category, and cost center. These rules are based on the accounting details, such as the capex and expense accounts, that are populated on a purchase line.
    Milestone

    [sn_shop_milestone]

    		 Extends the Acknowledgment Task table and stores the acknowledgment of services received.
    Negotiation

    [sn_shop_negotiation]

    		 Stores the negotiation object that is created for a supplier product in a sourcing activity.
    Negotiation to Contract Relationships

    [sn_shop_m2m_negotiation_contract]

    		 Stores the mapping between the negotiation and contract.
    Negotiation Event

    [sn_shop_negotiation_event]

    		 Stores the negotiation events that are created for a supplier product in a sourcing activity.
    Non Catalog Intake

    [sn_shop_non_catalog_intake]

    		 Extends the Import Set Row table and acts like a staging table for the non-catalog intake flow.
    Order Template

    [sn_shop_order]

    		 Stores all purchase orders. This is a base table.
    Order to Contract Relationships

    [sn_shop_m2m_order_contract]

    		 Stores the mapping between the purchase order and contract.
    Order Permission

    [sn_shop_m2m_order_users_covered]

    		 Stores the mapping between the purchasing permission and purchase order.
    Order Line Template

    [sn_shop_order_line]

    		 Extends the Shop Line table and stores the purchase order line for any purchase order.

    Purchase Cost Allocation

    [sn_shop_cost_allocation]

    		 Stores the type of cost allocation, associated cost center, and the amount that is allocated for a shopper that can be used to buy a supplier product.
    Purchasing Permission

    [sn_shop_covered_user]

    		 Stores the purchasing permission for a user, group, cost center, or department.
    PSM FX Currency

    [sn_shop_fx_currency_instance]

    		 Stores the converted Fx2 currency amount into legal entity local currency amount and legal entity reporting currency amount by using the conversion rate from the Finance Exchange Rates table.
    Pricing

    [sn_shop_m2m_product_contract]

    		 Stores the mapping of a supplier product and its price that is based on the associated contract.
    Product Purchases by Job code and Department

    [sn_shop_user_product_purchase]

    		 Stores the aggregation of products purchased by the job code.
    Purchase

    [sn_shop_purchase]

    		 Stores the purchase record that is created for each purchasing or sourcing activity.
    Purchases by Category

    [sn_shop_user_category_purchase]

    		 Stores the analytical data for purchases by product category.
    Product Purchases by Job code and Department

    [sn_shop_user_product_purchase]

    		 Stores the aggregation of products purchased by the job code.
    Purchasing Task

    [sn_shop_task]

    		 Extends the Finance Task table and stores the various tasks that are associated with a purchase such as finance and contract tasks.
    Purchase Order History

    [sn_shop_order_history]

    		 Extends the Order Template table and stores the older purchase order record when an order is revised.
    Purchase Order Line History

    [sn_shop_order_line_history]

    		 Extends the Order Line Template table and stores the older purchase order line record when a purchase order line is revised.
    Purchase Order Line

    [sn_shop_purchase_order_line]

    		 Extends the Order Line Template table and stores the purchase order line for a purchase.
    Purchase Order

    [sn_shop_purchase_order]

    		 Extends the Order Template table and stores the purchase order for a given purchase.
    Product Visuals

    [sn_shop_supplier_product_artifact]

    		 Stores the artifacts that are used to display product appearances on the user interface.
    Purchase Requisition

    [sn_shop_purchase_requisition]

    		 Stores the purchase requisition for a purchase or sourcing activity.
    Purchase Line

    [sn_shop_purchase_line]

    		 Extends the Request Line table and stores the purchase line that is associated with a purchasing or sourcing activity.
    Purchase

    [sn_shop_purchase]

    		 Extends the Order Template table and stores the purchase order for a given purchase.
    PSM State Mapper

    [sn_shop_psm_state_mapper]

    		 Stores the unique states of tasks related to negotiation, sourcing request, purchase requisition, and procurement case.
    Product group

    [sn_shop_product_group]

    		 Stores the name that is associated with an attribute set that is then referenced by the supplier product and product model.
    Price Break

    [sn_shop_price_break]

    		 Stores the price divided based on the number of quantities purchased for a given supplier product contract.
    Pre-Payment

    [sn_shop_pre_payment]

    		 Stores a record of prepayment done for a purchase line as per a contract.
    Percent Complete Configuration

    [sn_shop_percent_complete_config]

    		 Stores the configurations to determine the percentage of payment that is completed for an order.
    Payment Terms

    [sn_shop_payment_term]

    		 Stores the term in which a payment would be made. For example, a term could be seven days after the invoice date.
    Payment Methods

    [sn_shop_payment_method]

    		 Stores the payment method that is selected by the shopper and the cost center or person responsible for the payment.
    Paycheck Periods

    [sn_shop_paycheck_periods]

    		 Stores the number of paychecks through which a payment would be made.
    Purchase Order Line History

    [sn_shop_order_line_history]

    		 Extends the Order Line Template table and stores the older purchase order line record when a purchase order line is revised.
    Receipt

    [sn_shop_receipt]

    		 Stores the receipt of a supplier product received as part of a purchase order line.
    Receipt Task

    [sn_shop_receipt_task]

    		 Extends the Acknowledgment Task table and stores the state of a receipt confirmation.
    Request Line Template

    [sn_shop_request_line]

    		 Extends the Shop Line table and stores the purchase request line items.
    Requisition Additional Info

    [sn_shop_requisition_additional_info]

    		 Stores additional details about a purchase requisition, including its creation and update timestamps, and the users responsible for these actions.
    Requisition Permission

    [sn_shop_m2m_purchasing_users_covered]

    		 Stores the mapping between the purchasing permission and purchase requisition.
    Requisition to Contract Relationships

    [sn_shop_m2m_requisition_contract]

    		 Stores the mapping between the purchase requisition and contract.
    Revision Request

    [sn_shop_revision_request]

    		 Extends the Purchasing Task table and stores the state of a revision request for a purchase.
    Revision Line

    [sn_shop_rev_request_line]

    		 Extends the Request Line Template table and stores the revision line for a purchase.
    Supplier Use by Department

    [sn_shop_dept_supplier_purchase]

    		 Stores the analytics of suppliers that are used by departments.
    Service Acknowledgment

    [sn_shop_invoice_task]

    		 Extends the Acknowledgement Task table and stores details about invoice tasks, which are an extension of acknowledgment tasks.
    Shop Line

    [sn_shop_line]

    		 Stores the order line template and request line template. This is a base table.
    Sourcing to Contract Relationships

    [sn_shop_m2m_sourcing_contract]

    		 Stores the mapping between the sourcing request and contract.
    Shipment Details

    [sn_shop_shipment_details]

    		 Stores the shipment details that are associated with a purchase order line.
    Shipment Product

    [sn_shop_shipment_product]

    		 Stores the shipment product details that are associated with a purchase order line.
    Shipping methods

    [sn_shop_shipping_method]

    		 Stores the shipping method details that are associated with a purchase order line.
    ShoppingHub API Cache

    [sn_shop_shopnow_api_cache]

    		 Stores the cached data for quicker access by APIs. An example is the CachedCagetoryMap.
    ShoppingHub Configuration

    [sn_shop_shopnow_content]

    		 Stores configurations that determine certain aspects of the application appearance and behavior. An example is the terms and conditions page URL.
    Shopping Control

    [sn_shop_shopping_control]

    		 Stores the security rules that determine the access of supplier products for a given user.
    Sourcing Request

    [sn_shop_sourcing_activity]

    		 Stores requests to source for supplier products.
    Sourcing Task

    [sn_shop_sourcing_task]

    		 Extends the Purchasing Task table and stores the tasks that are related to a sourcing request.
    Supplier Product

    [sn_shop_supplier_product]

    		 Stores the supplier products that represent goods or services that can be listed on the portal.
    Supplier Product View

    [sn_shop_supplier_product_view]

    		 Stores the analytics of the number of views for a supplier product.
    Supplier Use by Shopper

    [sn_shop_user_supplier_purchase]

    		 Stores the analytics of suppliers that are used by shoppers.
    Shopper's Top Suppliers

    [sn_shop_usr_preferred_supplier]

    		 Stores the mapping between the shopper and preferred supplier.
    User Controls

    [sn_shop_user_control]

    		 Stores the mapping of a user and a shopping control.