using stockout indicator in weekly_prod_dmnd table

[AndresCardozo]

What are the rules to interface stockoutInd column in the DCM WPD table?

[AndresCardozo · Accepted solution]

• Set the stockoutind column to 1 in wpd table (wekly_prod_dmnd) when a pdl (product/location) runs out at any point during the week
• That will allow the ETL to calculate lost sales and revised demand as the difference between the forecast sales (expected sales) and the actual sales reported in wpd
• This will tell the application the pdl ran out during the week reported in wpd with the stockoutind field set to 1
• The lost sales calculation is typically in the wpd ETL and developed by the PS team or the client
• The stockout logic is independent of whether you use replenishment
• The standard logic is when stockoutind is 1 OR inventory 0, the ETL will apply the revised demand calculation and store it in wpd_rev table (wekly_prod_dmnd_rev) as revised demand
• This depends on how the ETL was written

For additional details you can also consult the following documentation:

• KCS-ONE Knowledge Centered Support article: KCS001281
• TDCM Table Interface Guide