CSV File Format
Before uploading an adjustment data file, you need to ensure that the CSV file contains the following columns:
| Column Name | Description | Mandatory (Yes or No) |
|---|---|---|
| Account Identifier Type | Used to specify the account identifier type. | Yes (Conditional) Note: This data is required when the match
type is Contract Type and account ID is not specified.
|
| Account Identifier | Used to specify the account identifier. | Yes (Conditional) Note: This data is required when the match
type is Contract Type and account ID is not specified.
|
| Account ID | Used to indicate the account for which the adjustment must be created. | Yes (Conditional) Note: This data is required when the match
type is Contract Type and the account identifier type and account
identifier are not specified.
|
| Match Type | Used to indicate the match type using which the adjustment must be created. | Yes |
| Match Value | Used to indicate the entity (such as contract, contract type, and so on) against which the adjustment must be created. | Yes |
| Adjustment Type | Used to indicate the adjustment type using which the adjustment
must be created. Note: The adjustment type must be included in the
adjustment type profile which is attached to the contract type.
|
Yes |
| Adjustment Amount | Used to specify the adjustment amount. Note: The adjustment
amount precision must match the precision (decimal positions) defined
for the currency.
|
Yes |
| Currency Code | Used to indicate the currency in which the adjustment must be created. | Yes |
| Comments | Used to specify additional information about the adjustment. | No |
| Bill ID | Used to indicate the bill on which the adjustment must be created. | No |
| Arrears Date | Used to specify the date from when the amount is outstanding on the bill. | No |
| Char Type 1, Char Type 2, ......, Char Type 5 | Used to indicate the characteristic that must be defined for the adjustment. | Yes (Conditional) Note: This data is required if the characteristic
value is specified.
|
| Char Value 1, Char Value 2, ......, Char Value 5 | Used to specify the value for the characteristic type. | Yes (Conditional) Note: This data is required if the characteristic
type is specified.
|
Note: If an adjustment data file contains column names other than
those mentioned in the above table, the system will not upload the
adjustment data file.