C1_​ALTBLSYS1

The C1_​ALTBLSYS1 algorithm type is used to generate an alternate bill ID for the completed and pending bills. You can generate an alternate bill ID in the required format using the following parameters:

Parameter Description
‘X’ Here, X stands for a separator. For example, ‘,’. The separator must be enclosed within single quotes. It will act as a delimiter in the alternate sequential bill number.
CIS_​DIVISION The division to which the account belongs. It is retrieved from the bill. It should not be more than five characters.
BILL_​CYC_​CD The bill cycle of the account for which the bill is generated. It is retrieved from the bill. It should not be more than four characters.
ACCT_​INDENTIFIER=<Account_​Identifier_​Type>, <CharStartPosition>,<CharCount> Here, you need to specify the following information separated by a comma:

  • <Account_​Identifier_​Type> - Used to indicate the account identifier type whose value must be used to generate the alternate sequential bill number.

  • <CharStartPosition> - Used to indicate the starting position from where you want to extract the characters from the account identifier. If you do not specify the starting position, by default, it is set to zero (0) (i.e. from the first character).

  • <CharCount> - Used to indicate the number of characters that you want to extract from the account identifier. If you do not specify the count, by default, it is set to five.

CHARACC=<Characteristic_​Type>, <CharStartPosition>,<CharCount> Here, you need to specify the following information separated by a comma:

  • <Characteristic_​Type> - Used to indicate the account's characteristic whose value must be used to generate the alternate sequential bill number.

  • <CharStartPosition> - Used to indicate the starting position from where you want to extract the characters from the characteristic value. If you do not specify the starting position, by default, it is set to zero (0) (i.e. from the first character).

  • <CharCount> - Used to indicate the number of characters that you want to extract from the characteristic value. If you do not specify the count, by default, it is set to five.

Note: If the same characteristic is defined multiple times for an account, the characteristic value which is effective on the batch business date is considered.
CHARPER=<Characteristic_​Type>, <CharStartPosition>,<CharCount> Here, you need to specify the following information separated by a comma:

  • <Characteristic_​Type> - Used to indicate the person's characteristic whose value must be used to generate the alternate sequential bill number.

  • <CharStartPosition> - Used to indicate the starting position from where you want to extract the characters from the characteristic value. If you do not specify the starting position, by default, it is set to zero (0) (i.e. from the first character).

  • <CharCount> - Used to indicate the number of characters that you want to extract from the characteristic value. If you do not specify the count, by default, it is set to five.

Note: If the same characteristic is defined multiple times for a person, the characteristic value which is effective on the batch business date is considered.
BILL_​DT=MMddyy The date when the bill is created for the account. It should not be more than six characters. You can use the following patterns in the date format:

  • "yyyy" or "yy" for year

  • "MM" or "M" for month

  • "dd" or "d" for day

Note: The date format should either start or end with the year.
SEQ_​NBR The sequence number generated by the database. It should not be more than 12 characters.
FIXED_​SUFFIX=XX Here, X stands for a letter or a group of letters that you want to add at the end of the alternate sequential bill number.
LEFT_​PADDING_​CHAR=ZERO or LEFT_​PADDING_​CHAR=SPACE Indicates whether you want to add zero or space when the number of characters derived from the account's or person's characteristic value is less than the character count. The padding is added to the left.

You can specify the above mentioned parameters against any of the following parameters available in the C1_​ALTBLSYS1 algorithm type:

  • Field1

  • Field2

  • Field3

  • Field4

  • Field5

  • Field6

  • Field7

  • Field8

  • Field9

  • Field10

None of these algorithm type parameters are mandatory. The system will concatenate the parameter values and then generate alternate bill ID in the required format. For example, if you create an algorithm using the following parameters:

  • Field1 - CIS_​DIVISION

  • Field2 - ‘|’

  • Field3 - SEQ_​NBR

  • Field4 - ‘-’

  • Field5 - FIXED_​SUFFIX=01

In this case, the system will generate the alternate bill ID in the CIS_​DIVISION|SEQ_​NBR-01 format. For example, DIV1|12345678-01. If you want to generate unique alternate bill ID, we recommend you to use the SEQ_​NBR parameter while creating an algorithm using the C1_​ALTBLSYS1 algorithm type.

Note that if you do not specify the value for any parameters while creating an algorithm using the C1_​ALTBLSYS1 algorithm type, the system will generate the alternate bill ID using the sequence number.

While specifying the value for these parameters, you need to ensure that the length of the alternate bill ID should not exceed 30 characters. An algorithm named C1_​ALTBLSYS1 is already shipped with the product. You can create custom algorithms using the C1_​ALTBLSYS1 algorithm type to design the required alternate bill ID format using the above mentioned parameters. If you attach an algorithm created using the C1_​ALTBLSYS1 algorithm type to the Sequence Generation Algorithm field in the Billing tab of the Installation Options screen, the algorithm is invoked while executing the Assign Sequential Bill Numbers (ASSGNSBN) batch.