Siebel Order Management Infrastructure Guide > PSP Waterfall > About Configuring Waterfall Output >

Adding New Fields to an Existing Waterfall

You can add as many new fields as you like to an existing waterfall using the following procedure as an example. This example adds an Accounting Code field to the existing Net Price waterfall.

To add a new field to an existing waterfall

  1. In Siebel Tools, revise the PSP procedure (for example, revise Pricing Procedure - Calculate Net Price).
  2. Add an extra comma-separated argument to the "+= New()" function in every action that generates waterfall output. For example:

    {Row}.{Net Price Waterfall} += New('Waterfall', [Text] = LookUpMessage('Pricer - Dynamic Matrix Adjustment', [Price Book] = {Match.Price Book}), [Adjustment Type] = {Match.Adjustment Type}, [Adjustment Amount] = {Match.Adjustment Amount}, [Currency Code] = {Row.Currency Code}, [Price] = {Row.Start Price}, [Accounting Code] = {Match.Accounting Code})

    The syntax [Accounting Code] = {Match.Accounting Code} adds the new field.

  3. Add the new field to the waterfall virtual business component (for example, Net Price Waterfall VBC).
  4. Add the new field to the waterfall pop-up applet (for example, Net Price Waterfall Popup List Applet).
  5. (Optional) If the new field needs to be written to the database:
    1. Add the new field to the tables used to store this waterfall type (for example, S_QTEIT_WTR_LOG, S_ORDIT_WTR_LOG, S_AGRIT_WTR_LOG).
    2. Add the new field to the business components used to persist this waterfall type (for example, Quote Line Item Waterfall, Order Entry Line Item Waterfall, Service Agreement Line Item Waterfall).
    3. Navigate to Administration Application > Data Maps. Add the new field to the waterfall data map objects (for example, Quote Waterfall Data Map Object, Order Waterfall Data Map Object, Service Agreement Waterfall Data Map Object).
Siebel Order Management Infrastructure Guide Copyright © 2006, Oracle. All rights reserved.