C1-ADVALREQ

This algorithm validates the records in the adjustment data file that is uploaded using an adjustment upload request type. It validates the following:

  • Either the contract ID or account details and contract type are specified in the record.

  • Either the account ID or account identifier type and account identifier is specified in the record.

    Note: If the account ID is not specified in the record, it derives the account ID using the respective account identifier type and account identifier combination.

  • The match type, match value, adjustment type, adjustment amount, and currency are specified in the record.

  • The account ID given in the record is valid.

  • An account with the given account identifier type and account identifier combination exists in the system.

  • The adjustment type, currency code, and match type given in the record are valid.

  • The characteristic type given in the record is valid and its characteristic entity is set to Adjustment and is associated with the adjustment type.

  • The adhoc characteristic values are validated as per the validations defined in the respective algorithm.

  • The predefined characteristic value is already defined for the characteristic type.

  • The foreign key reference characteristic value is valid.

  • The bill ID given in the record is valid.

  • The contract type or contract ID given in the record is valid.

  • The contract is not in the Canceled status.

  • An active contract of the specified contract type exists for the account.

  • The amount matches the decimal positions of the respective currency.

  • The adjustment type is included in the adjustment type profile which is associated with the contract type.

If any of above validations fail for any of the record in the CSV file, the system will not allow you to create an adjustment upload request. In other words, the system will not allow you to upload an adjustment data file.

Note: This algorithm invokes the algorithm associated to the match type in the respective adjustment upload request type. For more information, see Associating a Match Type with an Adjustment Upload Request Type.