Price Import staging table
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.
| 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. |
Parent Topic:Inbound staging tables for Sourcing and Procurement Operations
Related topics
CMDB Model Category Stage inbound staging table
CMDB Service Model Stage inbound staging table
CMN Location Stage inbound staging table
Cost Center Stage inbound staging table
Department Stage inbound staging table
ERP Plant Address Mapping Stage inbound staging table
FX Currency Stage inbound staging table
FX Rate Stage inbound staging table
Fixed asset details stage inbound table
GL Account Stage inbound staging table
Import Availability Updates inbound staging table
Availability Error staging table
Cost Allocation inbound staging table (Deprecated)
Purchase Order inbound staging table
Purchase Order Line inbound staging table
Legal Entity Stage inbound staging table
Office Location Stage inbound staging table
Order Acknowledgement staging table
Order Acknowledgement Error staging table
Payment Terms Stage inbound staging table
Price Error outbound staging table
Product Model Stage inbound staging table
Purchase Entity Stage inbound staging table
Purchase Line Stage inbound staging table
Purchase Requisition staging table
Spend Shipment Import inbound staging table
Supplier Product Stage inbound staging table
Third Party Sourcing Registration staging table
Third Party Unit Mapping staging table