Field Name Mandatory or Optional Description Remarks India Cyprus 1 Comments Partner…
- User
Field Name Mandatory or Optional Description Remarks India Cyprus 1 Comments Partner Name NA Partner Name partnerName Site Id M Site ID in Partner System Get partner sites. If so, then we need site master siteNo Site Name M Name of the Site in Partner System siteName Stock Created Date M Date when stock file was generated(SoD or EoD) aggregatedStockDate Article Variant Id M Product Variant Id articleVariantId GTIN O Product GTIN EAN - M&S GTIN UPC O Product UPC EAN - M&S UPC Total quantity M Total quantity of stock for the article variant Id quantity SubLocationName M Sub location code (Allocated to 3rd parties) Will specify sub-location name and code SubLocationCode "Q: Is this store, warehouse, what level of granularity does this go down to? Does this get updated within the supply chain network? Sub location - To indicate a classification of the storage location from where the stock gets allocated ie., Allocated to 3rd parties, Customer put away." Storage Location Code M Location code Will specify location name and code storageLocationCode Does this include damaged stock that is written off? Stock Type M Type of Stock UNRESTRICTED, BLOCKED, IN_TRANSIT, QUARANTINED stockType Unit of measure M Unit of measure EA unitOfMeasure Quantity M Quantity of stock 200 quantity Storage type O Storage type - Boxed or Hanging Boxed or Hanging First receipted date of the inventory? O Product First receipted date of the inventory? "Highly desirable - Res: Can be captured at data end instead of from partners. Can get from the partners, if they have as part of the one-off initially but not worth getting it as part of daily feed." "How can we get the Partner selling value to apply to stock data? Res: I will check with Arch and come back on this. Syed said that when they initially designed, it was specifically called out to have 2 different feeds (one for stock and one for selling price), as stock value is a different entity. " "Need to be able to see season etc for stock data - will this just be done by matching to product master data? Res: Can be from multiple season orders, not specific to each season, but season can be inferred from the master data. " ...explain in brief
- Assistant
This table outlines the key fields involved in managing partner stock data, highlighting which fields are mandatory (M) or optional (O), their descriptions, and some remarks or questions relating to data usage and interpretation. Here's a brief explanation:
- Partner Name (NA): Identifier for the partner supplying the data; not mandatory.
- Site Id (M): Unique ID for the partner's site; needed for site-level stock tracking.
- Site Name (M): Name corresponding to the Site Id.
- Stock Created Date (M): Date when the stock data file was generated (start or end of day).
- Article Variant Id (M): Unique product variant identifier.
- GTIN / UPC (O): Optional global product codes like EAN or UPC for enhanced identification.
- Total Quantity (M): Total stock quantity for the specific product variant.
- SubLocationName (M): Code for sub-location within a storage site, showing finer granularity like third party allocation or customer put-away. Questions remain on its exact granularity and whether it updates dynamically through the supply chain.
- Storage Location Code (M): Code representing the particular storage location; concerns about whether damaged or written-off stock is included.
- Stock Type (M): Classification of stock status like UNRESTRICTED or QUARANTINED.
- Unit of Measure (M): Units in which the quantities are expressed (e.g., each).
- Quantity (M): Stock quantity count.
- Storage Type (O): Whether items are stored boxed or hanging.
- First Receipted Date (O): The date stock was first received; optional, may be captured internally rather than from partners.
Additional Commentary:
- Partner pricing or selling value is treated separately from stock data and requires a different data feed.
- Seasonality for stock can be inferred by linking product master data rather than direct stock data.
- Some field details call for further clarification, like the handling of damaged stock or precise meaning of sub-locations.