Defining a Template
Procedure
To define a template:
-
Click the Admin link in the Application toolbar.
A list appears.
-
From the Admin menu, select T and then click Template.
A sub-menu appears.
-
Click the Add option from the Template sub-menu.
The Template screen appears. It consists of the following zone:
-
Search Template — Used to specify basic details about the template. It consists of the following fields:
Field Name Field Description Mandatory (Yes or No) Template Used to specify the template name. Yes Description Used to search for a template by it’s description. Yes Purpose Used to indicate the purpose of the template. The valid values are: -
Adjustment Selection - Used for selecting a set of adjustments based on the criteria.
-
Bill Segment Selection
- Used for selecting a set of bill segments 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 specify additional information about the template. Yes 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 specify the zone for the template. Note:The Search (
) 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. -
- Enter the required details in the Main tab.
-
If you want to define more than one bind variable, click
the Add (
) icon in the Bind Variables section and then enter the required details.
Note: However, if you want to remove a bind variable from the Bind Variables section, click the Delete () icon corresponding to the bind variable.
-
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.
- Define characteristics for the template, if required.
-
Click Validate and Save.
The system validates the syntax of the SELECT statement and then accordingly saves the template.
Related Topics
For more information on... | See... |
---|---|
Template screen | Template |
Search Template zone | Search Template |
How to define a characteristic for a template | Defining a Characteristic for a Template |