1. Order Management Infrastructure Guide
  2. Adding New Fields to an Existing Waterfall

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

Note: Data Maps can be Workspace enabled in your development environment. If they have been Workspace enabled in your development environment and you are working in that environment, then you can only modify them in an editable Workspace. You do not need an editable Workspace to create and edit Data Maps in your Production environment.

  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 the Administration Application screen, then the Data Maps view. 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).