IDI version 26.8 is now available.  Click here for details: IDI Updates.

Adjustment File Format

Prev Next

Before adjustments can be loaded from a file, the file must be in a specific format. The data must be comma delimited, with no header or trailer records. The fields are in the following order:

  • customer account number - alphanumeric

  • adjustment amount - currency

  • adjustment type code - numeric (as set up in Data Management)

  • adjustment date - mm/dd/yyyy

  • description (not required)) - alphanumeric

  • service number - numeric (if applicable)

  • associated invoice number - numeric (if applicable)

  • check number - numeric (if applicable)

  • batch number - numeric (not required)

  • invoice category ID - numeric (not required)

    This is an example of an adjustment file.

    UG template for Help