CSV File Format for Banking Usage Data
Before uploading a usage data file for banking, you need to ensure that the CSV file contains the following columns:
Column Name | Description | Mandatory (Yes or No) |
---|---|---|
DATA IDENTIFIER | Used to specify the serial number of the usage record. | No |
ACCOUNT ID TYPE | Used to specify the account identifier type. | Yes |
ACCOUNT IDENTIFIER | Used to indicate the account to which the usage record belongs. | Yes |
START DATE | Used to specify the date from when the price item was used. Note: You must specify the date in the YYYY-MM-DD format.
|
No |
END DATE | Used to specify the date till when the price item was used. Note: You must specify the date in the YYYY-MM-DD format.
|
No |
DIVISION | Used to specify the division to which the usage record belongs. | Yes |
DESCRIPTION | Used to specify the description for the usage record. It is shown on the billable charge. | Yes |
BILL LINE DESCRIPTION1, BILL LINE DESCRIPTION2, ....., BILL LINE DESCRIPTION10 | Used to specify the description for the line item (charge). | Yes (Conditional) Note: This data is required when the charge
amount is specified.
|
AMOUNT1, AMOUNT2, ....., AMOUNT10 | Used to specify the charge amount. | Yes (Conditional) Note: This data is required when the bill
line description or currency is specified.
|
CURRENCY1, CURRENCY2, ....., CURRENCY10 | Used to specify the currency in which the amount is charged. Note: If you specify a currency other than the account’s invoice currency,
the system will do the currency conversion if the appropriate exchange
rate is available in the system.
|
Yes (Conditional) Note: This data is required when the charge
amount is specified.
|
MEMO ONLY1, MEMO ONLY2, ....., MEMO ONLY10 | Used to indicate whether the charge should be included in
the bill amount or not. The valid values are:
Note: By default, the value will be set to false if the column does not contain any value.
|
No |
SUMMARY1, SUMMARY2, ....., SUMMARY10 | Used to indicate whether the charge should be included in
the summary line or not. The valid values are:
Note: By default, the value will be set to true if the column does not contain any value.
|
No |
SHOW ON BILL1, SHOW ON BILL2, ....., SHOW ON BILL10 | Used to indicate whether the charge should appear on the
person’s printed bill or not. The valid values are:
Note: By default, the value will be set to true if the column does not contain any value.
|
No |
GL DISTRIBUTION CODE 1, GL DISTRIBUTION CODE 2, ...., GL DISTRIBUTION CODE 10 | Used to specify the distribution code which indicates the GL account associated with the charge. | Yes (Conditional) Note: This data is required when false is specified in the Memo Only column corresponding to the bill line description.
|
PRICE ITEM | Used to specify the price item code. | Yes |
VARIANCE | Used to indicate the variance that must be used along with the price item for determining the price item pricing. | No |
PARAM TYPE1, PARAM TYPE2, ....., PARAM TYPE15 | Used to indicate the price item parameter that must be used
along with the price item for determining the price item pricing. Note: If the data in these columns will be used for price item parameter
mapping, you must not use the equal to (=) and tilde (~) symbols in
these columns.
|
Yes (Conditional) Note: This data is required when the parameter
value is specified.
|
PARAM VALUE1, PARAM VALUE2, ....., PARAM VALUE15 | Used to specify the parameter value. Note: If the data in
these columns will be used for price item parameter mapping, you must
not use the equal to (=) and tilde (~) symbols in these columns.
|
Yes (Conditional) Note: This data is required when the parameter
type is specified.
|
SQI1, SQI2, ....., SQI10 | Used to indicate the service quantity identifier that must be used for calculating the price item charges. | Yes (Conditional) Note: This data is required when the service
quantity is specified.
|
SQIVALUE1, SQIVALUE2, ....., SQIVALUE10 | Used to specify the number of units of the service quantity. | Yes (Conditional) Note: This data is required when the SQI
is specified.
|
CHARTYPE1, CHARTYPE2, ....., CHARTYPE10 | Used to indicate the characteristic that must be defined for the billable charge. | Yes (Conditional) Note: This data is required when the characteristic
value is specified.
|
CHARVAL1, CHARVAL2, ....., CHARVAL10 | Used to specify the value of the characteristic type. | Yes (Conditional) Note: This data is required when the characteristic
type is specified.
|
Note:
The column names in the CSV file must be in the Upper case. Otherwise, erroneous results might occur when you upload the usage data file.
While uploading a file using a file type where business labels are defined for usage data fields, the CSV file should contain the business label in the respective column. Otherwise, the usage data file will not be uploaded in the system.