Primary data tables for Sourcing and Procurement Operations

The primary data tables for Sourcing and Procurement Operations store important information about products, attributes, pricing, approvals, payment terms, shipping methods, delivery locations, and job codes.

• Fixed Asset [sn_fin_fixed_asset] table
  The Fixed Asset [sn_fin_fixed_asset] table stores information related to: Fixed assets purchased from suppliers.
• Finance Exchange Rates [sn_fin_fx_rate] table
  The Finance Exchange Rates [sn_fin_fx_rate] table stores currency exchange rates used for Finance Common.
• Ledger Account table
  The Ledger Account [sn_fin_gl_account] table stores information related to: General ledger accounts.
• GL rule [sn_fin_gl_rule] table
  The GL Rule [sn_fin_gl_rule] table stores general ledger classification rules.
• Threshold rule [sn_fin_gl_threshold_rule] table
  The Threshold Rule [sn_fin_gl_threshold_rule] table stores variance threshold information for general ledger rules.
• Industry [sn_fin_industry] table
  The Industry [sn_fin_industry] table stores industry classification information.
• Ledger [sn_fin_ledger] table
  The Ledger [sn_fin_ledger] table stores financial reporting ledger data.
• Legal Entity [sn_fin_legal_entity] table
  The Legal Entity [sn_fin_legal_entity] table stores information about legal entities used in financial and organizational structures.
• Office Location table
  The Office Location [sn_fin_office_location] table stores data about organization office locations, including address, country, legal entity, and ERP source.
• Organization [sn_fin_organization] table
  The Organization [sn_fin_organization] table stores information about organizational entities such as companies and legal entities.
• Approval Group [sn_shop_approval_group] table
  The Approval Group [sn_shop_approval_group] table stores information related to: Approval groups.
• Approval Rule [sn_shop_approval_rule] table
  The Approval Rule [sn_shop_approval_rule] table stores the rules that determine how and when approval requests are sent for purchasing objects.
• Approval Rule Composition table
  The Approval Rule Composition [sn_shop_approval_rule_composition] table stores rule ordering within approval groups.
• Attribute [sn_shop_attribute] table
  The Attribute [sn_shop_attribute] table stores product attribute values.
• Attribute Set [sn_shop_attribute_set] table
  The Attribute Set [sn_shop_attribute_set] table groups attribute types.
• Attribute Type [sn_shop_attribute_type] table
  The Attribute Type [sn_shop_attribute_type] table stores product attribute definitions.
• Delivery Location [sn_shop_delivery_location] table
  The Delivery Location [sn_shop_delivery_location] table stores delivery address information.
• Job Code [sn_shop_job_code] table
  The Job Code [sn_shop_job_code] table stores job codes for users.
• Payment Terms [sn_shop_payment_term] table
  The Payment Terms [sn_shop_payment_term] table stores payment term information.
• Price Break [sn_shop_price_break] table
  The Price Break [sn_shop_price_break] table stores quantity-based pricing information.
• Pricing [sn_shop_m2m_product_contract] table
  The Pricing [sn_shop_m2m_product_contract] table stores contract-specific product pricing information.
• Product group [sn_shop_product_group] table
  The Product group [sn_shop_product_group] table stores product model grouping information.
• Product Visuals [sn_shop_supplier_product_artifact] table
  The Product Visuals [sn_shop_supplier_product_artifact] table stores product images and media.
• Shipping methods [sn_shop_shipping_method] table
  The Shipping methods [sn_shop_shipping_method] table stores shipping method and carrier information.

Related concepts

• SPO and Asset Management data model mappings
• Domain separation and Sourcing and Procurement Operations
• Sourcing and Procurement Operations glossary

Related reference

• Base system procurement case type reference
• Create New Pipeline Project form
• Pipeline project record tabs and UI actions
• Savings opportunity fields
• Purchase requisition, purchase order, and sourcing request states