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. 주: 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:
|
| 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. |