CSV File Format for Write Off Request Upload
Before uploading a write off request file, you need to ensure that the CSV file contains the following columns:
Column Name | Description | Mandatory (Yes or No) |
---|---|---|
Write Off Request Type | Used to specify the write off request type. | Yes |
Account Identifier Type | Used to specify the account identifier type. | Yes (Conditional) Note: This data is required when the Account ID is not specified.
|
Account Identifier | Used to specify the account identifier of the account for which you want to create the write off request. | Yes (Conditional) Note: This data is required when the Account ID is not specified.
|
Account ID | Used to specify the account for which you want to create the write off request. | Yes (Conditional) Note: This data is required when the Account Identifier Type and Account Identifier are not specified.
|
Entity Type | Used to specify the entity type. | Yes |
Entity ID | Used to specify the entity ID. | Yes |
Adjustment Type | Used to specify the adjustment type using which the write off adjustments are created. | No |
Write Off Amount | Used to specify the amount that you want to write off. | Yes |
Comments | Used to specify the comments which are added on the write off request. | No |
Effective Date1, Effective Date2, ....., Effective Date5 | Used to indicate the effective date of the characteristics. | Yes (Conditional) Note: This data is required when Char Type or Char Val is specified.
|
Char Type1, Char Type2, ....., Char Type5 | Used to indicate the characteristic that must be defined for the write off request. | Yes (Conditional) Note: This data is required when Effective Date or Char Val is
specified.
|
Char Val1, Char Val2, ....., Char Val5 | Used to specify the value of the characteristic type. | Yes (Conditional) Note: This data is required when Effective Date or Char Type is
specified.
|