About Waterfalls
A waterfall is an applet or a pop-up window that provides line-item explanation about field values— displaying any combination of values such as text, numbers, or dates—such as the figures that were used to arrive at a particular value in a field. As one example of a waterfall, the pricing waterfall shown in the following figure shows the details of the calculation used to arrive at the net price. This example shows a base price used for an item ordered, minus the discount given to arrive at the net price.

As another example, you might implement a waterfall on a product’s eligibility status, to show the end user all the reasons a product cannot be purchased (rather than just one reason).
All text displayed to the end user in waterfalls is translatable. the Unified Messaging Service (UMS) business service dynamically translates and substitutes waterfall text . The UMS business service processes all translations through the LookUpMessage API in PSP action script:
{Row}.{Net Price Waterfall} += New('Waterfall', [Text] = LookUpMessage({Row.Temp
List Price Message}, [Price List] = {Match.Price List}), [Currency Code] =
{Row.Currency Code}, [Price] = {Row.List Price})
For more information about UMS, see Unified Messaging.