Supplier Product Stage inbound staging table
The Supplier Product Stage inbound [sn_spend_intg_supplier_product_stage] staging table temporarily stores important data about supplier products before this data is sent to the primary table.
The following table lists the mandatory fields for the Supplier Product Stage inbound [sn_spend_intg_supplier_product_stage] staging table.
| Field | Data type | Description |
|---|---|---|
| Capex account | String | General ledger account where capital expenses are posted on purchase. |
| Currency | String | Currency format associated with the supplier |
| Description | String | Detailed description of the product for the buyer. |
| ERP source | String | ERP source used by the organization. |
| Expense account | String | General ledger account where operational expenses are posted on purchases. |
| Goods receipt required | String | Indicates if a receipt is required in addition to the invoice. |
| Name | String | Name of the company that the supplier is linked to. |
| Prepaid account | String | General ledger account where purchases of this product are posted when they are prepaid. |
| Product category | String | Category to which this product belongs. |
| Product model | String | Standardized definition for this product across suppliers.Note: For creating a product bundle, enter the name of the product model of type bundle in this field. |
| Product type | String | Type of product. The options are Good or Service. |
| Published | String | Option for specifying if the product is to be listed on the ShoppingHub portal. |
| Services acknowledgement | String | All the service acknowledgments associated with the supplier. |
| Short description | String | Brief description of the product for the buyer. |
| Sourcing required | Boolean | Option to mark if sourcing is required for this product. This is determined based on if there is an active contractual price for this supplier product or not. |
| Sourcing time in days | String | Estimated number of days to process the sourcing request. |
| Spend categorization | String | Product that is addressable for negotiation. You can select one of these options:- Addressable: Can be considered for negotiation. - Not Addressable: Cannot be considered for negotiation. |
| Supplier | String | Name of the supplier. |
| Supplier delivers to | String | Countries where the suppliers can deliver the product. |
| Supplier part number | String | Unique number that is used by the supplier to identify this product. |
| Units | String | Unit or rate in which the product is sold by the supplier. |
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
Third Party Sourcing Registration staging table
Third Party Unit Mapping staging table