| \n\nRole title \\[name\\]\n\n | \n\nDescription\n\n | \n\nContains roles\n\n |
|---|---|---|
| \n\nShopping Hub Administrator\n\n \\[sn\\_shop.shopping\\_hub\\_admin\\]\n\n | \n\nAccess to all modules of the Source-to-Pay Common Architecture application.\n\n | \n\n- decision\\_table\\_admin\n- sn\\_fin.procurement\\_user\n- model\\_manager\n- category\\_manager\n\n |
| \n\nShopper\n\n \\[sn\\_shop.shopper\\]\n\n | \n\nAccess to the Shopping Hub portal to make requests and purchases.\n\n | \n\nNone\n\n |
| \n\nProcurement Administrator\n\n \\[sn\\_shop.procurement\\_administrator\\]\n\n | \n\nAccess to the primary data and administration sections of the Purchase Automation module.\n\n | \n\n- sn\\_fin.procurement\\_primary\\_data\\_admin\n- sn\\_shop.procurement\\_specialist\n\n |
| \n\nProcurement Specialist\n\n \\[sn\\_shop.procurement\\_specialist\\]\n\n | \n\nAccess to all the data of the Sourcing and Purchasing Automation module, except the primary data.\n\n | \n\n- sn\\_fin.procurement\\_user\n- contract\\_manager\n\n |
| \n\nAccounts Payable Viewer\n\n \\[sn\\_shop.accounts\\_payable\\_viewer\\]\n\n | \n\nRead access to purchase orders, invoices, and other task-related objects that arise from purchase order creation.\n\n | \n\nNone\n\n |
| \n\nPurchasing Task Owner\n\n \\[sn\\_shop.purchasing\\_task\\_owner\\]\n\n | \n\nAccess to all purchase orders, requisitions, negotiations, sourcing requests, and purchasing tasks.\n\n | \n\nNone\n\n |
| \n\nAcknowledgment Task Owner\n\n \\[sn\\_shop.acknowledgment\\_task\\_owner\\]\n\n | \n\nAccess to all purchase orders and purchase requisitions. Read-only access to the main objects, but can update assigned tasks.\n\n | \n\nNone\n\n |
| \n\nProcurement Common Administrator\n\n \\[sn\\_shop.procurement\\_common\\_admin\\]\n\n | \n\nAccess to all tables, including deletion of records, in the Source-to-Pay Common Architecture application.\n\n | \n\nsn\\_shop.procurement\\_common\\_user\n\n |
| \n\nProcurement Common Reader\n\n \\[sn\\_shop.procurement\\_common\\_reader\\]\n\n | \n\nRead access to all tables available in the Source-to-Pay Common Architecture application.\n\n | \n\nsn\\_fin.procurement\\_user\n\n |
| \n\nProcurement Common User\n\n \\[sn\\_shop.procurement\\_common\\_user\\]\n\n | \n\nAccess to perform, create, and update operations on all tables in the Source-to-Pay Common Architecture application.\n\n | \n\nsn\\_shop.procurement\\_common\\_reader\n\n |
| \n\nsn\\_spend\\_mgmt.category\\_manager\\_admin\n\n | \n\nCan import the category taxonomy, update the Spend Category and Spend Category Stage tables and update the Spend category to Product category mappings.\n\n | \n\nNone\n\n |
| \n\nsn\\_spend\\_mgmt.sourcing\\_category\\_manager\n\n | \n\nCan view and access the Category management tab and the Savings dashboard in Spend and Savings Management.\n\n | \n\nsn\\_shop.procurement\\_specialist\n\n |
| \n\nsn\\_spend\\_pipeline.pipeline\\_management\\_admin\n\n | \n\nCan configure the Pipeline project creation rule decision table to automate the creation of pipeline projects.\n\n | \n\ndecision\\_table\\_admin\n\n |
| \n\nsn\\_spend\\_pipeline.sourcing\\_pipeline\\_user\n\n | \n\nCan view and access the Pipeline management tab.\n\n | \n\nNone\n\n |
| \n\nTable\n\n | \n\nDescription\n\n |
|---|---|
| \n\nAttribute\n\n \\[sn\\_shop\\_attribute\\]\n\n | \n\nStores 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.\n\n |
| \n\nAttribute Set\n\n \\[sn\\_shop\\_attribute\\_set\\]\n\n | \n\nStores 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.\n\n |
| \n\nAttribute Type\n\n \\[sn\\_shop\\_attribute\\_type\\]\n\n | \n\nStores the various types of attributes that are used when creating a product attribute.\n\n |
| \n\nDelivery Location\n\n \\[sn\\_shop\\_delivery\\_location\\]\n\n | \n\nStores the delivery location for a given shop line or cart line.\n\n |
| \n\nERP Address Mapping\n\n \\[sn\\_shop\\_erp\\_address\\_map\\]\n\n | \n\nStores the mapping between the ERP address and the location.\n\n |
| \n\nERP Asset Category Mapping\n\n \\[sn\\_shop\\_erp\\_asset\\_category\\_map\\]\n\n | \n\nStores the mapping between the ERP source and the capitalization policy.\n\n |
| \n\nERP Material Group Mapping\n\n \\[sn\\_shop\\_erp\\_material\\_group\\_map\\]\n\n | \n\nStores the mapping between the ERP source, model category, and material group.\n\n |
| \n\nIntegration Error\n\n \\[sn\\_shop\\_erp\\_error\\_task\\]\n\n | \n\nStores integration errors that might occur when communicating or processing a request with ERP.\n\n |
| \n\nInvoice\n\n \\[sn\\_shop\\_invoice\\]\n\n | \n\nStores the invoice that is associated with a purchase order.\n\n |
| \n\nInvoice Line\n\n \\[sn\\_shop\\_invoice\\_line\\]\n\n | \n\nStores the invoice lines for each corresponding purchase order line.\n\n |
| \n\nJob Code\n\n \\[sn\\_shop\\_job\\_code\\]\n\n | \n\nStores the job codes that are associated with business owners that primarily drive the approval hierarchy.\n\n |
| \n\nMilestone\n\n \\[sn\\_shop\\_milestone\\]\n\n | \n\nExtends the Acknowledgment Task table and stores the acknowledgment of services received.\n\n |
| \n\nOffice Location\n\n \\[sn\\_shop\\_office\\_location\\]\n\n | \n\nStores delivery locations marked as office.\n\n |
| \n\nOrder Line Template\n\n \\[sn\\_shop\\_order\\_line\\]\n\n | \n\nExtends the Shop Line table and stores the purchase order line for any purchase order.\n\n |
| \n\nOrder Template\n\n \\[sn\\_shop\\_order\\]\n\n | \n\nStores all purchase orders. This is a base table.\n\n |
| \n\nOrder to Contract Relationships\n\n \\[sn\\_shop\\_m2m\\_order\\_contract\\]\n\n | \n\nStores the mapping between the purchase order and contract.\n\n |
| \n\nPayment Terms\n\n \\[sn\\_shop\\_payment\\_term\\]\n\n | \n\nStores the term in which a payment would be made. For example, a term could be seven days after the invoice date.\n\n |
| \n\nPrice Break\n\n \\[sn\\_shop\\_price\\_break\\]\n\n | \n\nStores the price divided based on the number of quantities purchased for a given supplier product contract.\n\n |
| \n\nPricing\n\n \\[sn\\_shop\\_m2m\\_product\\_contract\\]\n\n | \n\nStores the mapping of a supplier product and its price that is based on the associated contract.\n\n |
| \n\nProduct Group\n\n \\[sn\\_shop\\_product\\_group\\]\n\n | \n\nStores the name that is associated with an attribute set that is then referenced by the supplier product and product model.\n\n |
| \n\nProduct Visuals\n\n \\[sn\\_shop\\_supplier\\_product\\_artifact\\]\n\n | \n\nStores the artifacts that are used to display product appearances on the user interface.\n\n |
| \n\nPurchase Order\n\n \\[sn\\_shop\\_purchase\\_order\\]\n\n | \n\nExtends the Order Template table and stores the purchase order for a given purchase.\n\n |
| \n\nPurchase Order Line\n\n \\[sn\\_shop\\_purchase\\_order\\_line\\]\n\n | \n\nExtends the Order Line Template table and stores the purchase order line for a purchase.\n\n |
| \n\nReceipt\n\n \\[sn\\_shop\\_receipt\\]\n\n | \n\nStores the receipt of a supplier product received as part of a purchase order line.\n\n |
| \n\nShipment Details\n\n \\[sn\\_shop\\_shipment\\_details\\]\n\n | \n\nStores the shipment details that are associated with a purchase order line.\n\n |
| \n\nShipment Product\n\n \\[sn\\_shop\\_shipment\\_product\\]\n\n | \n\nStores the shipment product details that are associated with a purchase order line.\n\n |
| \n\nShipping Method\n\n \\[sn\\_shop\\_shipping\\_method\\]\n\n | \n\nStores the shipping method details that are associated with a purchase order line.\n\n |
| \n\nTable\n\n | \n\nDescription\n\n |
|---|---|
| \n\nAcknowledgment Task\n\n \\[sn\\_shop\\_acknowledgment\\_task\\]\n\n | \n\nStores acknowledgments such as the milestone and receipt task. This is a parent table within the Common Service Delivery \\(SDC\\) application.\n\n |
| \n\nApproval Plan\n\n \\[sn\\_shop\\_approval\\_plan\\]\n\n | \n\nStores the approval plan details for a purchase requisition such as the approval routing method and approval decision method.\n\n |
| \n\nApproval Plan Detail\n\n \\[sn\\_shop\\_approval\\_plan\\_detail\\]\n\n | \n\nStores an instance of the approval record for a purchase line that is created based on the approval plan.\n\n |
| \n\nApproval Rule\n\n \\[sn\\_shop\\_approval\\_rule\\]\n\n | \n\nStores the rule that triggers the creation of an approval record. It uses a condition builder to build the trigger condition for approvals.\n\n |
| \n\nCapitalization Policy\n\n \\[sn\\_shop\\_capitalization\\_policy\\]\n\n | \n\nStores the condition based on which an asset is capitalized, and a fixed asset record is created.\n\n |
| \n\nCart Line\n\n \\[sn\\_shop\\_cart\\_line\\]\n\n | \n\nStores 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.\n\n |
| \n\nContract Task\n\n \\[sn\\_shop\\_contract\\_task\\]\n\n | \n\nExtends the Purchasing Task table and stores instances of various types of contract tasks that are associated with a purchase line.\n\n |
| \n\nPurchase Cost Allocation\n\n \\[sn\\_shop\\_cost\\_allocation\\]\n\n | \n\nStores 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.\n\n |
| \n\nCredit Allocation Rules\n\n \\[sn\\_shop\\_credit\\_allocation\\_rules\\]\n\n | \n\nStores 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.\n\n |
| \n\nDelivery Address Task\n\n \\[sn\\_shop\\_delivery\\_address\\_task\\]\n\n | \n\nExtends the Purchasing Task table and stores the tasks that are associated with verifying and validating the delivery location for a purchase line.\n\n |
| \n\nEmployee Credit\n\n \\[sn\\_shop\\_employee\\_credit\\]\n\n | \n\nStores the credit amount that is allocated for a user with supporting information such as the responsible cost center and credit allocation rule.\n\n |
| \n\nLedger Assignment Rules\n\n \\[sn\\_shop\\_ledger\\_assignment\\_rule\\]\n\n | \n\nStores 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.\n\n |
| \n\nModel Map\n\n \\[sn\\_shop\\_m2m\\_model\\_map\\]\n\n | \n\nStores the mapping between a CMDB model and a third-party category.\n\n |
| \n\nNegotiation\n\n \\[sn\\_shop\\_negotiation\\]\n\n | \n\nStores the negotiation object that is created for a supplier product in a sourcing activity.\n\n |
| \n\nSourcing Event\n\n \\[sn\\_shop\\_negotiation\\_event\\]\n\n | \n\nStores the sourcing events that are created for a supplier product in a sourcing activity.\n\n |
| \n\nNon Catalog Intake\n\n \\[sn\\_shop\\_non\\_catalog\\_intake\\]\n\n | \n\nExtends the Import Set Row table and acts like a staging table for the non-catalog intake flow.\n\n |
| \n\nOrder Permission\n\n \\[sn\\_shop\\_m2m\\_order\\_users\\_covered\\]\n\n | \n\nStores the mapping between the purchasing permission and purchase order.\n\n |
| \n\nPaycheck Periods\n\n \\[sn\\_shop\\_paycheck\\_periods\\]\n\n | \n\nStores the number of paychecks through which a payment would be made.\n\n |
| \n\nPayment Methods\n\n \\[sn\\_shop\\_payment\\_method\\]\n\n | \n\nStores the payment method that is selected by the shopper and the cost center or person responsible for the payment.\n\n |
| \n\nPercent Complete Configuration\n\n \\[sn\\_shop\\_percent\\_complete\\_config\\]\n\n | \n\nStores the configurations to determine the percentage of payment that is completed for an order.\n\n |
| \n\nPre-Payment\n\n \\[sn\\_shop\\_pre\\_payment\\]\n\n | \n\nStores a record of prepayment done for a purchase line as per a contract.\n\n |
| \n\nProduct Purchases by Job Code\n\n \\[sn\\_shop\\_user\\_product\\_purchase\\]\n\n | \n\nStores the aggregation of products purchased by the job code.\n\n |
| \n\nProduct Stage\n\n \\[sn\\_shop\\_imp\\_product\\]\n\n | \n\nExtends the Import Set Row table. This staging table is used to import supplier products.\n\n |
| \n\nProperties\n\n \\[sn\\_shop\\_properties\\]\n\n | \n\nStores the Shopping Hub specific properties such as the requisition auto order.\n\n |
| \n\nPurchase\n\n \\[sn\\_shop\\_purchase\\]\n\n | \n\nStores the purchase record that is created for each purchasing or sourcing activity.\n\n |
| \n\nPurchase Line\n\n \\[sn\\_shop\\_purchase\\_line\\]\n\n | \n\nExtends the Request Line table and stores the purchase line that is associated with a purchasing or sourcing activity.\n\n |
| \n\nPurchase Order History\n\n \\[sn\\_shop\\_order\\_history\\]\n\n | \n\nExtends the Order Template table and stores the older purchase order record when an order is revised.\n\n |
| \n\nPurchase Order Line History\n\n \\[sn\\_shop\\_order\\_line\\_history\\]\n\n | \n\nExtends the Order Line Template table and stores the older purchase order line record when a purchase order line is revised.\n\n |
| \n\nPurchase Requisition\n\n \\[sn\\_shop\\_purchase\\_requisition\\]\n\n | \n\nStores the purchase requisition for a purchase or sourcing activity.\n\n |
| \n\nPurchases by Category\n\n \\[sn\\_shop\\_user\\_category\\_purchase\\]\n\n | \n\nStores the analytical data for purchases by product category.\n\n |
| \n\nPurchasing Permission\n\n \\[sn\\_shop\\_covered\\_user\\]\n\n | \n\nStores the purchasing permission for a user, group, cost center, or department.\n\n |
| \n\nPurchasing Task\n\n \\[sn\\_shop\\_task\\]\n\n | \n\nStores the various tasks that are associated with a purchase such as finance and contract tasks. This is a base table within the Common Service Delivery \\(SDC\\) application.\n\n |
| \n\nReceipt Task\n\n \\[sn\\_shop\\_receipt\\_task\\]\n\n | \n\nExtends the Acknowledgment Task table and stores the state of a receipt confirmation.\n\n |
| \n\nRequest Line Template\n\n \\[sn\\_shop\\_request\\_line\\]\n\n | \n\nExtends the Shop Line table and stores the purchase request line items.\n\n |
| \n\nRequisition Permission\n\n \\[sn\\_shop\\_m2m\\_purchasing\\_users\\_covered\\]\n\n | \n\nStores the mapping between the purchasing permission and purchase requisition.\n\n |
| \n\nRequisition to Contract Relationships\n\n \\[sn\\_shop\\_m2m\\_requisition\\_contract\\]\n\n | \n\nStores the mapping between the requisition and contract.\n\n |
| \n\nRevision Line\n\n \\[sn\\_shop\\_rev\\_request\\_line\\]\n\n | \n\nExtends the Request Line Template table and stores the revision line for a purchase.\n\n |
| \n\nRevision Request\n\n \\[sn\\_shop\\_revision\\_request\\]\n\n | \n\nExtends the Purchasing Task table and stores the state of a revision request for a purchase.\n\n |
| \n\nService Acknowledgment\n\n \\[sn\\_shop\\_service\\_acknowledgment\\]\n\n | \n\nStores the acknowledgment tasks of services received.\n\n |
| \n\nShop Line\n\n \\[sn\\_shop\\_line\\]\n\n | \n\nStores the order line template and request line template. This is a base table.\n\n |
| \n\nShopper's Top Suppliers\n\n \\[sn\\_shop\\_usr\\_preferred\\_supplier\\]\n\n | \n\nStores the mapping between the shopper and preferred supplier.\n\n |
| \n\nShopping Control\n\n \\[sn\\_shop\\_shopping\\_control\\]\n\n | \n\nStores the security rules that determine the access of supplier products for a given user.\n\n |
| \n\nShoppingHub API Cache\n\n \\[sn\\_shop\\_shopnow\\_api\\_cache\\]\n\n | \n\nStores the cached data for quicker access by APIs. An example is the CachedCagetoryMap.\n\n |
| \n\nShoppingHub Configuration\n\n \\[sn\\_shop\\_shopnow\\_content\\]\n\n | \n\nStores configurations that determine certain aspects of the application appearance and behavior. An example is the terms and conditions page URL.\n\n |
| \n\nSourcing Bid Stage\n\n \\[sn\\_shop\\_imp\\_sourcing\\_bid\\]\n\n | \n\nStores the bids that are received for a supplier product by the third-party providers. This is a staging table.\n\n |
| \n\nSourcing Line Outbound Queue\n\n \\[sn\\_shop\\_sourcing\\_line\\_out\\_queue\\]\n\n | \n\nStages the sourcing line for the third-party providers.\n\n |
| \n\nSourcing Outbound Queue\n\n \\[sn\\_shop\\_sourcing\\_out\\_queue\\]\n\n | \n\nStages the sourcing request for the third-party providers.\n\n |
| \n\nSourcing Request\n\n \\[sn\\_shop\\_sourcing\\_activity\\]\n\n | \n\nStores requests to source for supplier products.\n\n |
| \n\nSourcing Task\n\n \\[sn\\_shop\\_sourcing\\_task\\]\n\n | \n\nExtends the Purchasing Task table and stores the tasks that are related to a sourcing request.\n\n |
| \n\nSourcing Vendor\n\n \\[sn\\_shop\\_sourcing\\_vendor\\]\n\n | \n\nStores the mapping between the sourcing vendor code and sourcing vendor name.\n\n |
| \n\nSupplier Product\n\n \\[sn\\_shop\\_supplier\\_product\\]\n\n | \n\nStores the supplier products that represent goods or services that can be listed on the portal.\n\n |
| \n\nSupplier Product View\n\n \\[sn\\_shop\\_supplier\\_product\\_view\\]\n\n | \n\nStores the analytics of the number of views for a supplier product.\n\n |
| \n\nSupplier Use by Department\n\n \\[sn\\_shop\\_dept\\_supplier\\_purchase\\]\n\n | \n\nStores the analytics of suppliers that are used by departments.\n\n |
| \n\nSupplier Use by Shopper\n\n \\[sn\\_shop\\_user\\_supplier\\_purchase\\]\n\n | \n\nStores the analytics of suppliers that are used by shoppers.\n\n |
| \n\nThird-Party Category\n\n \\[sn\\_shop\\_third\\_party\\_category\\]\n\n | \n\nStores an external category that is provided by a supplier that maps to an existing model.\n\n |
| \n\nUser Controls\n\n \\[sn\\_shop\\_user\\_control\\]\n\n | \n\nStores the mapping of a user and a shopping control.\n\n |
| \n\nProperty\n\n | \n\nDescription\n\n |
|---|---|
| \n\nsn\\_shop.atf.threshold.days\n\n | \n\nNumber of days before an expected delivery date for goods, or a start date for services and blankets, in which time a purchase requisition would be considered after the fact.\n\n |
| \n\nsn\\_shop.credit.allocation.batchsize\n\n | \n\nTotal number of employee records that are processed in a batch, during credit allocation.\n\n |
| \n\nsn\\_shop.default.contract.model.type\n\n | \n\nDefault contract model when creating contracts.\n\n |
| \n\nsn\\_shop.default.purchasing.time\n\n | \n\nInitial value of the purchasing time in days.\n\n |
| \n\nsn\\_shop.default.shipping.estimate\n\n | \n\nDefault shipping estimate, in percentage.\n\n |
| \n\nsn\\_shop.default.sourcing.time\n\n | \n\nInitial sourcing time in days.\n\n |
| \n\nsn\\_shop.default.supplier.onboard.time\n\n | \n\nInitial supplier onboarding time in days.\n\n |
| \n\nsn\\_shop.non.pricing.contract\n\n | \n\nList of non-pricing contracts. The default is NDA.\n\n |
| \n\nsn\\_shop.shipping.estimate.inclusion\n\n | \n\nShipping estimate included in purchase request approvals.\n\n |
| \n\nsn\\_shop.approval.reassessment.resend\n\n | \n\nApprovals that must be reassessed during a revision if the same approval rule is triggered. It applies to both purchase requisition and purchase order revisions.\n\n |
| \n\nsn\\_shop.log.property\n\n | \n\nLogging level for Sourcing and Purchasing Automation.\n\n |
| \n\nsn\\_shop.spend.requisition.autoorder\n\n | \n\nPurchase order that can be automatically created on completion of purchasing tasks without having to undergo a manual final review.For more information on how the auto-order properties affect purchase order creation, see [Purchase requisition auto-order](https://raw.githubusercontent.com/ServiceNow/ServiceNowDocs/australia/markdown/australia/source-to-pay-operations/sourcing-and-procurement-operations/pr-auto-order.md).\n\n |
| \n\nsn\\_shop.spend.requisition.autoorder.threshold\n\n | \n\nDollar amount threshold above which a final review is required before a purchase order is created even when the automatic creation of purchase orders property is set to Yes.For more information on how the auto-order properties affect purchase order creation, see [Purchase requisition auto-order](https://raw.githubusercontent.com/ServiceNow/ServiceNowDocs/australia/markdown/australia/source-to-pay-operations/sourcing-and-procurement-operations/pr-auto-order.md).\n\n |
| \n\nsn\\_shop.spend.sla.due.days\n\n | \n\nMinimum due date for SLA calculation.\n\n |
| \n\nsn\\_shop.supported.artifact.formats\n\n | \n\nFormats that are supported for supplier product artifacts.\n\n |
| \n\nsn\\_shop.tax.estimate.inclusion\n\n | \n\nIncludes generated tax estimate in purchase requests for the approval process.\n\n |