Editing a Construct

You can only edit a construct in the Draft, Active, or Rejected status. If a bill is already generated through a construct and it is in the Pending status, you cannot edit the details of the construct. You can only edit the effective to date of a construct when all bills generated through the construct are in the Completed status. The effective to date must be later than the last completed bill's bill date. Otherwise, the system will not allow you to edit the effective to date of the construct.

Procedure

To edit a template:

  1. Click the Menu link in the Application toolbar.
    A list appears.
  2. From the Main menu, select Billing Management and then click Construct.
    A sub-menu appears.
  3. Click on Search.
    The Construct screen appears.
  4. In the Search Results section, click the Edit (The Edit Icon) icon in the Edit column corresponding to the Construct ID whose details you want to edit.
    Note: If a template is used in any construct, a message appears confirming whether you want to edit the template. You must click OK if you want to edit the template. Any changes made to a template will not be reflected in any construct where the template is already used unless you use the latest template in the construct.

    The Template screen appears. It consists of the following tabs:

    • Main - Used to specify basic details about the template.

    • Characteristics - Used to define the characteristics for the template.

    The Main tab contains the following fields:

    Field Name Field Description Mandatory (Yes or No)
    Template Used to indicate the template name. Not applicable
    Description Used to specify the description for the template. Yes
    Detailed Description Used to specify additional information about the template. No
    Purpose Used to indicate the purpose of the template. The valid values are:

    • Account Selection - Used for selecting a set of usage accounts based on the criteria.

    • Adjustment Selection - Used for selecting a set of adjustments based on the criteria.

    • Billable Charge Selection - Used for selecting a set of billable charges based on the criteria.

    • Usage Account Selection - Used for selecting a set of usage accounts based on the criteria.

    • Usage and Invoice Account Selection - Used for selecting a set of usage and invoice accounts based on the criteria.

    		 Yes
    Status Used to indicate the status of the template. The valid values are:

    • Active

    • Inactive

    		 Yes
    Select Used to specify the column name. It indicates the data that you want to retrieve using the SELECT statement.

    The default value appears in this field when you select the purpose of the template. However, the default value changes depending on the purpose of template. You can edit the column name whenever required.

    If you have set the purpose of the template to.... Then, the default value is...
    Account Selection ACCT_​ID
    Adjustment Selection ADJ_​ID
    Billable Charge Selection BILLABLE_​CHG_​ID
    		Yes
    From Used to specify the table or view name. It indicates the table or view from which you want to retrieve the data. Yes
    Where Used to specify the condition based on which you want to retrieve the data from the table or view. You can use the bind variables in the where clause using the following syntax:

    {column_​name}{operator}:{bind_​variable}

    The bind variables must be alphanumeric and prefixed with the colon (:). There should not be any space between the column name, operator, and the bind variable. For example, CURRENCY_​CD=:CURRENCY. All bind variables used in the where clause must be defined in the Bind Variables section.

    		 No

    In addition, this tab contains the Bind Variables section where you can define the bind variables which are used in the where clause. The Bind Variables section contains the following fields:

    Field Name Field Description Mandatory (Yes or No)
    Bind Variable Used to specify the bind variable (which is used in the where clause). Yes (Conditional)
    Note: This field is required when you are defining a bind variable.
    Data Type Used to indicate the type of data that you want to store in the bind variable. The valid values are:

    • Date

    • Numeric

    • String

    		 Yes (Conditional)
    Note: This field is required when you are defining a bind variable.
    Label Used to specify the business label for the bind variable. The business label appears when you define and edit the criteria for selecting a set of usage accounts, adjustments, or billable charges. Yes (Conditional)
    Note: This field is required when you are defining a bind variable.
    Zone Used to indicate a zone for the template.
    Note:

    The Search (The Search Icon) icon appears corresponding to this field. On clicking the Search icon, the Zone/Code Description window appears.

    		 Yes (Conditional)
    Note: This field is required when you are defining a bind variable.
  5. Modify the details in the Main tab, if required.
    Note: If you want to define more than one bind variable, click the Add (The Add Icon) icon in the Bind Variables section and then enter the required details. However, if you want to remove a bind variable from the Bind Variables section, click the Delete (The Delete Icon`) icon corresponding to the bind variable.
  6. If required, click Validate to validate the syntax of the SELECT statement.
    Note: If the syntax of the SELECT statement is correct, a message appears indicating that the SQL statement was validated successfully. However, if the syntax of the SELECT statement is incorrect, an error message occurs. You need to then correct the SELECT statement accordingly. Otherwise, the system will not allow you to save the template.
  7. Define, edit or remove characteristics of the template, if required.
  8. Click Validate and Save.
    The system validates the syntax of the SELECT statement and then accordingly saves the changes made to the template.

Related Topics

For more information on... See...
How to search for a construct Searching for a Construct
How to include usage accounts in a construct Including Usage Accounts in a Construct
How to exclude usage accounts from a construct Excluding Usage Accounts from a Construct
How to include billable charges in a construct Including Bill Segments in a Construct
How to include adjustments in a construct Including Adjustments in a Construct