Price Import staging table

  • Release version: Yokohama
  • Updated January 30, 2025
  • 1 minute to read

    • The Price Import [sn_spend_intg_imp_price] staging table temporarily stores important data about price imports before this data is sent to the primary table.

    Table 1. Price Import staging table
    Field Data type Description
    Catalog id String Unique identifier for each catalog of the purchase order.
    Contract end date String Date on which the contract term ends.
    Contract number String Unique number of the contract.
    Contract start date String Date on which the contract term starts.
    Customer id String Unique identifier for a customer.
    Negotiated currency String Currency used in price negotiation.
    Negotiated price String Unit price of a product as negotiated through a contract with the supplier.
    Supplier id String Unique identifier for the supplier.
    Supplier part number String Unique identifier assigned by a supplier to a specific product or part that they provide.
    Third party import ID String Unique identifier for external data imports.