| Oracle® Retail Store Inventory Management Store User Guide Release 16.0 E76179-08 |
|
 Previous |
 Next |
| Oracle® Retail Store Inventory Management Store User Guide Release 16.0 E76179-08 |
|
Previous |
Next |
This chapter covers shelf replenishment. The following topics are covered:
Overview: Introduction to Shelf Replenishment.
Functionality: Shelf Replenishment, Shelf Adjustment, Item Substitution, and Receive on Shop floor.
Technical: Integration with Oracle Retail Integration Bus (RIB), web services, batch, and the database structure.
The replenishment process attempts to ensure that the shop floor inventory is set at a level best suited for enticing customers to buy a product and to prevent empty shelves. Shelf replenishment functionality within SIM is related to the movement of goods from the back room to the shop floor and shop floor to back room. For example, when a user sees that a certain soda quantity is low, the user can initiate a replenishment process so that more of the soda is moved from the back room. Similarly, if there is excess stock on the shop floor, SIM supports processes to move inventory to the backroom. Some of the processes require capacity setup and some form of plan-o-gram sequenced data, while others do not.
Shelf replenishment-related processing within SIM includes the following features:
Six different replenishment methods:
Capacity algorithm based on stock level percentages
Sales based
Ad hoc empty shelf scanning
Display stock replenishment
Receiving on the shop floor
Automatic
The system can calculate the optimal quantity of inventory on what should be held on the shop floor to prevent empty shelves
On demand generation of pick lists with real-time data
Store employees are driven to replenish the most urgently needed items first
Optional item location guidance when picking items by backroom micro sequence
Formal or informal picking dialog
Ad hoc update shop floor and backroom process to balance and correct inventory positions
Optional substitution when lacking inventory
Within day partial or end of day full replenishment pick lists for user efficiency
Capacity replenishment uses shop floor capacity and backroom inventory positions to calculate a pick list optimized to keep shelves on the shop floor well stocked. The user only has to indicate how many cases they want to replenish and which items by selecting the product group. This method is focused on those retailers and items which have a well defined plan-o-gram.
The capacity-based replenishment method is best used by retailers who have a structured shop floor where it is easy to define capacity, items are fairly static, and multiple units are on the shop floor. This is especially useful for grocery retailers and mass merchandise retailers. The structured shop floor is important to this method since there is an inherent cost involved with the need to understand how much capacity exist on the shop floor. A dynamic environment with continuously changing assortments or single item counts often is too costly to maintain the plan-o-gram shopfloor capacity.
Ad Hoc scanning is focused on those retail environments who want to have a very simple easy to use shop floor replenishment system. The user is able to scan items on the shop floor which become a backroom pick list for someone to pick items on and bring to the shop floor.
Sales-based shelf replenishment is based on a process that records all sales coming into the store. The sold item is added to the pick list based on merchandize hierarchy. Similar to the ad hoc scanning process, this does not require plan-o-gram information. Sales-based shelf replenishment is especially well suited for fashion retailers who have constantly changing assortments and have many low, or even single instance items like special shoe sizes or undergarments.
Display Stock is a replenishment method specifically geared towards single unit items that are used to sell to customers and are related to each other by style. The process allows a user to scan the items they have on the shop floor. SIM will generate a pick list for those styles and differentiator combination not represented on the shop floor.
Business Case example: A handbag retailer displays all the colors within a style for purses. Susan finds the perfect burgundy colored purse, picks it up from the shop floor, and goes to a sales counter. The sales associates on the sales floor do not notice that that particular color/model is not displayed anymore. Jane looked at a magazine and really wanted to have the featured red colored purse, but when shopping for that specific purse she does not see it on the shop floor and assumes it has sold out or was never carried. She decides to walk out of the store without a purchase and look at a different purse vendor who may have the red colored purse.
This scenario could easily have been resolved by the sales associate scanning periodically the items that are displayed on the shop floor and generating a list of missing items in inventory using the display replenishment methods.
Shop floor receiving will allow the receiving associate to indicate if they are receiving in the backroom or directly on the shop floor. This method is most often used with those retailers that have daily deliveries and move delivered quantities directly to the shop floor since most of the delivered quantities are just in time deliveries as is the case in the grocery environment.
The automatic option will refresh the store shop floor quantities based on capacity and available inventory for a specific merchandise selection. This feature can be used by those retailers who have a process where the store is brought back into a refreshed state at the end of the day and do not want to run manual or calculated pick lists. Another possible scenario could be when a large refresh is required due to significant plan-o-gram changes or when initially configuring a store.
Replenishment of shop floor.
This operation will help a retailer to move goods from the backroom to the shop floor. This is done to achieve a better fill rate at the store; the more shelf space is utilized, the better sales. This is possible even if a retailer is not using sequencing.
Moving items to the back room
Moving of Items from Shop floor to the Backroom is possible. It helps a retailer to move extra goods from the shop floor, which could be an outcome of receiving the delivery at the shop floor itself or incorrect movement of goods. For example, if a retailer receives a delivery at the shop floor but there is not enough space to keep the full delivery, then the retailer can use this functionality to move the goods to the backroom which are not required for that moment on shop floor. Secondly, if due to manual intervention there has been a movement of goods from the backroom to the shop floor and the shop floor cannot accommodate that much quantity, the retailer can push back the excess quantity to the backroom.
Shelf Replenishment exists under the Inventory Management menu. From the Shelf replenishment List screen, the user can filter the records as needed. The user can then view, create, edit, delete, and complete shelf replenishments.
This section covers system and store parameters.
Shelf Replenishment UI Limit
Values: Not to exceed the value of the UI performance limitation configuration setting
Default: 1500
Topic: UI
Editable: Yes
This option determines the maximum number of line items allowed on a Shelf Replenishment List. This check occurs in addition to and after the application limits the transaction based on the pick list system parameters.
Replenishment - At Case Level
Values: Yes/No
Default: No
Topic: Shelf Replenishment
Editable: Yes
This parameter determines whether to replenish shelves at the Case level or at the standard unit of measure. This will override the "Default UOM" system parameter.
Yes: The standard UOM will default to Cases on the Shelf replenishment screens on both the handheld and PC.
No: The standard UOM will default to "Eaches" on the Shelf replenishment screens on both the handheld and PC.
Regardless of how this parameter is set, the user will be able to toggle between cases and SUOM.
Replenishment - Delivery Bay Inventory
Values: Yes/No
Default: Yes
Topic: Shelf Replenishment
Editable: Yes
This option allows the user to turn on or off the delivery bay functionality.
Replenishment - End of Day Max. Fill %
Values: 0 to 100
Default: 100
Topic: Shelf Replenishment
Editable: Yes
This configurable percentage allows each store to set its own fill percentage for creating end-of-day shelf replenishment lists.
Replenishment - Handheld Picking Mode
Values: Enter Pick Quantity / Scan Every Item
Default: Enter Pick Quantity
Topic: Shelf Replenishment
Editable: Yes
This parameter determines whether the user will need to scan every item during the pick process or whether the user will manually enter a pick quantity, then scan the item to validate it is the correct item.
Enter Pick Qty: The user will need to manually enter the pick quantity and then scan the item to validate it is the correct item.
Scan Every Item: The user will be required to scan each instance of the item on the pick and then scan the bin, if required, instead of manually entering a pick quantity for all items picked. This method ensures every item is validated as the correct item to pick.
Replenishment - Item Substitution Store Discretion
Values: Yes/No
Default: No
Topic: Shelf Replenishment
Editable: Yes
This parameter determines whether or not a user will be able to choose any item for item substitution functionality on the Shelf Replenishment List Detail screen on the handheld and PC.
Yes: The user will be allowed to choose any item to substitute. An item lookup feature on the PC allows the user to search for an item to select.
No: The user will be restricted to scanning/entering an item that exists on the list of approved substitute items defined by RMS.
|
Note: If there are no items defined in RMS for item substitution, the Item Substitution dialog is displayed with the original item in the header and no substitutes. |
Replenishment - Within Day Max. Fill %
Values: 0 to 100
Default: 75
Topic: Shelf Replenishment
Editable: Yes
This configurable percentage allows each store to set its own fill percentage for creating within-day shelf replenishment lists.
Shelf Adjustment List Printing
Values: Automatic/Manual
Default: Manual
Topic: Shelf Replenishment
Editable: Yes
This parameter determines whether Shelf Adjustment list Printing will be automatic or manual.
Automatic: Report and tickets will be printed automatically. In case of multiple reports, the system will prompt to choose.
Manual: The user will need to initiate printing of the list.
This section describes the available screens.
This figure shows the Product Group Detail screen. The shelf replenishment product group is required to be set up for three types of in-store replenishment:
Capacity based requires the user to define product group components which will be used to generate the pick list.
The Display List type shelf replenishment helps the user to scan a list of items available on the shelf and create a list and compare it with the product group and identify the gap and replenish. This screen allows the user to select the diff through which the replenishment would be done. The Display list method requires the user to define outside of the product group components to also define the differentiator. The combination of differentiator and product group used with a scanned list will provide the user with a list of items that were not scanned.
Auto replenishment requires the user to set the "auto replenishment" indicator and define product group components. After setup, the user is also required to add this product group to the scheduler for batch scheduling. This setup will auto "top off" the shop floor. If the product group is only used one time, it also could be used to bring the shop floor up to capacity after a major plan-o-gram change without requiring user intervention in SIM.
|
Note: When scheduling for today, the user will have the option to immediately execute the "top off." |
The Shelf Replenishment List screen allows the user to create, edit or delete a replenishment list. The Shelf Replenishment List screen is accessible from the Shelf Replenishment button on the Inventory Management menu. All types of replenishment lists are displayed with the total quantity to pick and the actual picked quantity. When the user selects a replenishment list the user is brought to the Shelf Replenishment List Detail screen where the list details may be picked and completed. If the user creates a new replenishment list, the user is brought to the Shelf Replenishment List Create popup.
Four types of in store replenishment methods can be defined here: Capacity, Display List, Ad Hoc, and sales.
The Mode field indicates if the pick list is an end of day list which fills the shelves to capacity (pending backroom inventory) or if the pick list will only pick up to a specific user-defined quantity.
This screen can be reached from the Shelf Replenishment List screen by clicking the filter button. This helps to limit the search on Shelf Replenishment List screen through date, hierarchy, and various additional filters:
Shelf Replenishment List ID: limit search by shelf replenishment ID
Type: drop-down list with valid values:
Capacity
Adhoc
Display
Sales
Mode: drop-down list with valid values "End of Day" and "Within Day." This field is disabled if Shelf replenishment Type = Shelf adjustment or Adhoc Replenishment as it is not used for these types of replenishment.
Product Group: drop-down list of all shelf replenishment product groups. Only enabled for "Capacity" and "Sales" shelf replenishment types.
Shelf Adjustment List: drop-down list of all Shelf Adjustment Lists. Only enabled for "Shelf Adjustment" and "Adhoc Replenishment" shelf replenishment types.
Item: existing
Status: allows the user to filter by the state of the replenishment record. If filtering by "Active" status, SIM will return New and In Progress shelf replenishments.
User: limit search by the user who created the replenishment.
The Shelf Replenishment List Create screen is used to create a new shelf replenishment list based on various criteria specified by the user. This screen is accessed by clicking the Create button from the Shelf Replenishment List screen.
The user is able to create four different types of shelf replenishment lists: Ad Hoc, Capacity, Display, and Sales based replenishment lists.
Additionally, the user can specify an amount to be picked.
|
Note: Units is the total number of individual units, not the number of SKUs. |
If the user wants the system to check available inventory, SIM does not restrict to only backroom stock. This feature is also useful to identify if substitution is possible. The need of the item is checked, and no constraint is applied.
Based on the replenishment list type selected, some fields will display while others will not.
Capacity (Algorithm Based on Stock Level Percentages)
Capacity-based replenishment is dependent on the capacity defined for an item in sequencing at the shop floor. A user can choose to replenish within the day or end of the day. The difference between the capacity quantity and the actual stock on the shop floor becomes the suggested quantity to replenish. If the user chooses to replenish the stock within the day, the user also has an option to enter a quantity to replenish taking into account the manpower availability. If the user chooses to replenish at the end of the day, it is assumed that the user will have sufficient manpower and be able to replenish the full deficit.
Capacity-based replenishment uses the difference of the shop floor capacity and the shop floor quantity to calculate the gross need of how many units need to move to the shop floor. This need is constrained by several factors, how many units are present in the backroom and how many units does the user actually have time to pick and move to the shop floor.
Capacity-based replenishment uses a specific algorithm to define the optimal method to replenish the shop floor quantity:
The total capacity equals the sum of capacity for all shop floor locations.
The Out of stock % equals the total capacity minus the shop floor quantity divided by the total capacity times 100.
Calculation:
The Gross Need Units equals the total capacity minus the shop floor quantity.
The item list is sorted in the order of percentage Out of stock.
The Net Need calculation uses the total capacity, total max fill percentage, and the mode.
The total available replenish quantity equals the backroom plus the delivery bay stock. This step is only used when checking available stock on hand.
The fill quantity equals the Net Need or the total available, whichever is smaller.
The Within day fill will create a list until units replenished meet the within day fill quantity.
The End of day fill will create a list with all items needing replenishment.
Sales Based
Sales-based replenishment uses a concept in which the shop floor is intact and accurate every morning. As units are sold, new units will take their place. Often if a unit is sold out, because of limited availability, a substitution will be used to replenish. When the substitute is sold, the substitute will be replenished. The advantage of this type of method is sequencing is not required, since everything replenished is based on sold units.
A user can choose to replenish within the day or at the end of the day. If the user chooses to replenish within the day, they have an option to enter the quantity they have time to replenish. This replenishment quantity is restricted by the quantity entered by the user, and is pro-rated. If the user chooses to replenish at the end of the day, it assumes sufficient manpower will be able to replenish the suggested quantity.
This method is mostly used by fashion retailers who have no defined capacity and many items that are single size/color/style items. It often is used in conjunction with substitution to allow them to keep the shop floor looking filled by substituting the sold unit with one that is in the backroom.
|
Note: This method will often be used with the option to ignore available inventory. This allows "out of stock" items on the replenishment list to be substituted. |
Ad Hoc (Empty Shelf Scanning)
The Ad hoc replenishment is the easiest method of all the various types of shelf replenishment. With this method, the user scans the goods that need replenishment and a replenishment list is created from the units scanned.
The system uses this replenishment list to move the goods from the backroom to the shop floor based on backroom availability. The reason to have a separate process between scanning and generating is that one user can create a list and another user can execute the shelf replenishment allowing for distribution of workload. It is even possible to prevent a shelf replenishment list from generating and just print a report of the scanned items.
Since this process does not have a dependency with either sales or capacity, it gives an advantage to the retailer to move goods without any complex setup.
Display (Sales Floor/ Shop Floor)
The shelf replenishment method of Display stock replenishment is fully based on the idea that if a customer does not see the item on the shop floor, they do not know the item exists.
This method provides a way to reduce the inefficiency of receiving new styles in the backroom, and not having full knowledge of what is displayed and what should be moved from the backroom to the shop floor.
The generic process is the user will scan all display stock items, and then compare them against a product group with all the styles available for that department. The user will then identify what is the differentiator needing to be displayed on the floor. Often this is color.
Because this type of method is often used in a fashion setting, it does not require sequencing or capacity at all. Capacity need is always one item per primary differentiator.
A product group is required to set up with all the items on a shelf. The following table is an example which shows six items with various colors and sizes. In order for the comparison between shop floor display and backroom, all of the items need to be set up in the product group.
Next, a shelf adjustment list needs to be created by scanning the items on display. For this example, the user only has item 124 on the display shelf.
| Item ID | Diff 1 | Diff2 |
|---|---|---|
| 123 | Black | S |
| 124 | Black | M |
| 125 | Black | L |
| 234 | Red | S |
| 235 | Red | M |
| 236 | Red | L |
While creating the product group, the user selected to sort by the color. Since the scanned item is black, the sorting is by color. The system will try to find a different color available in the backroom. After the comparison between the two lists, SIM tells the user item 236 needs to be replenished.
|
Note: The suggested red item to be replenished will depend on available backroom inventory and the sort of the second differentiator. If Diff 2 had been defined differently, such as L = 10, M = 08, and S = 06, then item 234 would have been recommended instead for replenishment. |
The Shelf Replenishment List screen allows the user to view all the details of the replenishment list. This screen is accessed by selecting a replenishment list from the Shelf Replenishment List screen. If the item is not available for replenishment, the item can be substituted by selecting the Item Substitution button.
The Item Substitution popup is used to find a substitute item when the requested item has no inventory. The Item Substitution popup can be accessed from the Shelf Replenishment List Detail screen. Using item substitution helps maintain a better fill rate within different areas of the store. The substitutions can be recommended by corporate or they can be ad hoc picked depending on system settings. This is a similar process as in the Customer Order Picking dialog. Depending on security permissions, the user can be restricted to just the corporate items or be free to select anything they want.
The DSD Receiving Container Info popup is used to identify a container to receive on the shop floor. This popup is accessed from the DSD Receiving Container Detail screen. If the store parameter, "Direct Delivery Default to Shop floor Receiving," is set to Yes, the checkbox will already be marked and the user will only enter the screen and unmark the checkbox when they want to receive in the backroom.
The Transfer Receiving Container Info popup is used to identify a container to receive on the shop floor. This popup is accessed from the Transfer Receiving Container Detail screen. If the store parameter, "Store Transfer Default to Shop floor Receiving" and/or "Warehouse Default to Shopfloor Receiving," is set to Yes, the checkbox will already be marked and the user will only enter the screen and unmark the checkbox when they want to receive in the backroom. External Finisher containers are always be received in the backroom.
This section describes the store replenishment workflows on the handheld.
This figure shows all the types of shelf adjustment lists that can be created and used for creating a pick lists or directly updating the shop floor or backroom:
Shop Floor Adjust: This list allows the user to scan the items on the shop floor and update the shop floor quantity with the scanned item quantities. The shelf adjustment list can only be created on the handheld. After the creation of the list, the user clicks confirm to update the stock on the shop floor. Adjust the shop floor will also adjust the backroom to ensure that the shop floor plus backroom is equal to the SOH.
Backroom Adjust: This is very similar to the shop floor adjusted, except here the user scans the backroom and updates the backroom quantities. Adjusting the backroom will also automatically adjust the shop floor to ensure the SOH is always equal to shop floor plus backroom.
|
Note: Both the shop floor and backroom adjust methods ignore capacity and sequencing setup, so it is possible to update the shop floor with more units than capacity is identified for. |
Display List: This list is intended for the user to scan the shop floor display items. The list of scanned items will be compared on the PC or handheld when generating a pick list. This list can only be created on the handheld.
Ad Hoc Replenish: For Ad Hoc replenishment, the user will scan gaps on the shelf. When the list is complete, the user can save it and have it executed on the PC or handheld. This list can only be created on the handheld.
Similar to the PC, the handheld can also be used to generate shelf replenishment lists and execute those lists. Four replenishment list types can be created and actioned from the handheld:
Capacity
Sales
Ad Hoc
Display List
The following table describes the most common functional processes on the handheld.
| Vertical | Replenishment Method | Complexity | Use Case | Item Scan | Pick List Generate | Product Group | Likely Use Backroom/Shop Floor | Plan-O-Gram |
|---|---|---|---|---|---|---|---|---|
| All | Ad Hoc Scan | Simple | - Scan items
- Print report - Pick from report |
Yes | No | No | No | No |
| All | Ad Hoc Scan | Medium | - Scan items
- Generate pick list - Pick from report |
Yes | Yes | No | Yes | Optional |
| All | Update Shop Floor | Simple | - Scan items
- Complete updates to shop floor |
Yes | No | No | Yes | Optional |
| All | Update Backroom | Simple | - Scan items
- Complete updates to backroom |
Yes | No | No | Yes | Optional |
| Fashion | Fashion List | Medium | - Scan items
- Generate pick list based on product group - Action pick list manually or through handheld |
Yes | Yes | Yes | Yes | No |
| Grocer Hard Line | Assisted Generation | High | - Set parameters
- Create product group - Action within/end of day pick list - Pick based on handheld presented sequence |
No | Yes | Yes | Yes | Yes |
| Fashion | Sales | Medium | - Set up product group- Action within/end of day pick list- Pick from list on handheld or report | No | Yes | Yes | No | No |
| Fashion | Sales | Simple | - Use merch hierarchy- Action within/end of day pick list- Pick from list on handheld or report | No | Yes | No | No | No |
| Grocer | Receive Shop Floor | Medium | - Receive transaction
- Indicates receive shop floor - Update shop floor to max capacity, move rest to backroom |
No | No | No | Yes | Optional |
| Fashion | Auto Shop Floor Update | Simple | - Set up product group
- Schedule product group - End of day, auto update shop floor to capacity |
No | No | Yes | Yes | No |
Description of columns in preceding table:
Vertical: Type of item vertical.
Complexity: Difficulty of execution.
Use Case: High-level steps.
Item scan: Scan a list of items.
Pick List Generate: Generate a pick list or not.
Product Group: Is product group setup required?
Likely use backroom/shop floor quantities: does this replenishment method track inventory at the backroom and shop floor or not.
Plan-o-gram: This indicates if capacity is required to be set up. Plan-o-gram integration reduces the need to maintain this manually in SIM.
SIM creates shelf replenishments and updates inventory buckets for four types of shelf replenishments: Capacity, Sales, Ad Hoc, and Display List by the creation of pick lists. SIM also supports on-the-fly stock movement (from shop floor to backroom and vice versa) using the Shelf Adjustment List.
From a technical perspective, both Shelf Replenishment and Shelf Adjustment List have a header record and can have multiple detail records.
For shelf replenishments that are created using a product group (could be Sales type or capacity type), depending on the number of items in the product group and the system parameter Shelf Replenishment UI Limit, the shelf replenishment may be broken down into multiple shelf replenishments each with line items not more than the value of the system parameter. The only condition is that a sub-class hierarchy is never divided further. For example:
Product group has 1100 items such that 500 items are in sub-class A and 600 items are in sub-class B.
The stock at shop floor for each item is lower than their respective defined capacity.
Shelf Replenishment UI Limit = 1000
User creates capacity-based shelf replenishment.
This will create two capacity-based shelf replenishments, one for sub-class A (with 500 items) and another for sub-class B (with 600 items).
Business objects are used within the application code for all business processing. The following business objects are used for shelf replenishment:
| Business Object | Description |
|---|---|
| ShelfReplenishment | Contains header information about the shelf replenishment including status. |
| ShelfReplenishmentLineItem | Contains detailed information about a specific item on the shelf replenishment including pick area and pick quantity. |
| ShelfAdjustment | Contains header information about the shelf adjustment including status. |
| ShelfAdjustmentLineItem | Contains detailed information about a specific item on the shelf adjustment including requested quantity. |
This section provides information on the integration for shelf replenishment.
Shelf replenishment is integrated with external systems through web services.
SIM supplies the ShelfReplenishment SOAP web service which has following service operations:
| Service Operation | Description |
|---|---|
| lookupShelfReplenishmentHeaders | Retrieves header information for one or more shelf replenishments based on input search criteria. |
| readShelfReplenishment | Retrieves detail information for a shelf replenishment. |
| createShelfReplenishment | Creates a shelf replenishment in New status. |
| updateShelfReplenishment | Updates the line item records of the shelf replenishment and updates the status for New shelf replenishments to In-progress. |
| confirmShelfReplenishment | Confirms a shelf replenishment updating the inventory positions and completing the replenishment. |
| cancelShelfReplenishment | Cancels a shelf replenishment. |
SIM also supplies the ShelfAdjustment SOAP web service which has following service operations:
| Service Operation | Description |
|---|---|
| lookupShelfAdjustmentHeaders | Retrieves header information for one or more shelf adjustments based on input search criteria. |
| readShelfAdjustment | Retrieves detail information for a shelf adjustment. |
| saveShelfAdjustment | Creates a new shelf adjustment or modifies an existing shelf adjustment. |
| confirmShelfAdjustment | Confirms a shelf adjustment of type Shop floor Adjust or Move to Backroom. |
| cancelShelfAdjustment | Cancels a shelf adjustment. |
The following batch is supported:
| Batch Name | Description |
|---|---|
| Auto Replenish Capacity Batch | This batch is run to maximize capacity. It needs to be scheduled for the correct product group and have the "Auto Replenishment" indicator set. It will only affect those items that have been set up in the product group. It is usually run when the store is closed. |
| Cleanup Shelf Replenishment Batch | This batch moves inventory from the delivery bay to the back room. It also marks any uncompleted shelf replenishment pick lists as cancelled. |
The following database tables are used in shelf replenishment:
| Table Name | Description |
|---|---|
| SHELF_REPLENISH | Contains shelf replenishment header information including store for which the shelf replenishment was created, type, status, amount to pick, and create date-time. |
| SHELF_REPLENISH_LINE_ITEM | Contains detailed item level information for all the line items in the shelf replenishment including suggested quantity and actual picked quantity. |
| SHELF_REPLENISH_BKDN | This is a temporary table which contains breakdown information for shelf replenishments created using product group having large number of items.
Contains shelf replenishment breakdown details along with the item ID. |
| SHELF_ADJUST | Contains header level information for a shelf adjustment list along with the type of adjustment, status, and create date-time. |
| SHELF_ADJUST_LINE_ITEM | Contains detailed line item level information for the items in the shelf adjustment list including suggested quantity. |
| RPRT_SHELF_REPLENISH_V | This view contains header as well as item level detailed records for shelf replenishment. |
| RPRT_SHELF_ADJUST_V | This view contains header as well as item level detailed records for shelf adjustment. |
