Mass Bill Cycle Rule Characteristic Creation or Modification CSV Format
The following table lists and describes the columns that should be available in the CSV file while creating or updating bill cycle rule characteristic of multiple accounts at once through an upload request:
| Sr. No. | Column Name | Column Description | Mandatory (Yes or No) |
|---|---|---|---|
| 1 | Account Identifier Type | Used to specify the account identifier type. Note: You must
specify an account identifier type which is already defined in the
system.
|
Yes (Conditional) Note: This data is required when the account
ID is not specified in the record.
|
| 2 | Account Identifier | Used to specify the account identifier. Note: The system derives
the account using the given account identifier type and account identifier
combination when the account ID is either not specified or is invalid
in the record.
|
Yes (Conditional) Note: This data is required when the account
ID is not specified in the record.
|
| 3 | Account ID | Used to indicate the account for which you want to define or update the bill cycle rule characteristic. | Yes (Conditional) Note: This data is required when the account
identifier type and account identifier are not specified in the record.
|
| 4 | Effective Date | Used to specify the date from when the characteristic is
effective for the account. Note: You must specify the date in the YYYY-MM-DD format.
|
Yes |
| 5 | Bill Cycle Rule Code | Used to specify the bill cycle rule characteristic value. Note: You must specify a valid preference where the preference category
is set to Billing.
|
Yes |
Note:
The CSV file should contain the columns in the above mentioned sequence.
Before uploading the file, ensure that the column headers specified in the CSV file are mapped to the schema of the respective upload request business object through data mapping in the upload request type. Otherwise, erroneous results might occur. For more information, see Mapping Data and Configuring Filters for an Upload Request Type.