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:
|
CHARACC=<Characteristic_Type>, <CharStartPosition>,<CharCount> | Here, you need to specify the following information separated
by a comma:
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:
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:
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.