15.2.2 Accounting Information File Format

The accounting information of L-Platform templates is written to the accounting information file. The format of accounting information file is as follows.

Character code is UTF-8.
Each column is separated by a comma.
Comments cannot be written.
Character string data are enclosed by double quotations. When the double quotation is a character in a character string, enter two double quotations to escape it.
When a double quotation is set in a character string that is enclosed with double quotations, the single double quotation will be ignored.
Example
When the following string is entered in the accounting information file, the value will be "aaaaa"a".
```
"aaaaa""a"
```
When the following string is entered in the accounting information file, the value will be "aaaaaa".
```
"aaa"aaa"
```

Columns represented in an accounting information file are shown below.

No	Name	Omit	Explanation
1	Product ID	No	Specify ID that identifies the product. Register one product for each resource identifier. Specify 16 or less characters using alphanumeric characters, _(underline), or -(hyphen).
2	Priority	No	Specify the priority in a product. Multiple unit prices can be specified in a product, and the unit price with larger value has higher priority. (*1) The same priority cannot be set to the same product. Specify the numerical value from 0 to 999.
3	Start of applicable date	No	Specify start of applicable date. Format: YYYY-MM-DD Thh:mm:ss.SSSZ Example) Use 2012-04-01T00:00:00.000+0900 for the date and time 12:00A.M. and 00.000 seconds on April 1, 2012 in time zone UTC+9:00
4	End of applicable date	Yes	Specify end of applicable date. Format: YYYY-MM-DD Thh:mm:ss.SSSZ Example) Use 2013-03-31T23:59:59.999+0900 for the date and time 11:59 P.M. and 59.999 seconds on March 31, 2013 in time zone UTC+9:00 Specify the date prior to the start of applicable date.
5	Category code	No	Specify the product category using following codes. cpu: CPU cpu clock: CPU clock memory: memory capacity vm: virtual L-Server pm: physical L-Server sys_disk: system disk capacity disk: extension disk capacity snapshot: snapshot template: template nic: NIC
6	Resource identifier	No	Specify information to identify the accounting target resource with 128 or less alphanumeric characters. Resource identifiers vary by the category. (*2) cpu, cpu_clock, memory: VM pool name or sever pool name vm: virtual L-Server image name pm: physical L-Server image name sys_disk: storage pool name disk: storage pool name snapshot: storage pool name template: template ID nic: network resource ID
7	Unit code	No	Specify accounting unit using following codes. year: yearly month: monthly hour: hourly
8	Unit price	No	Specify unit price. Specify 11 or less digits for the integer portion and 4 or less digit for the fractional portion. Specify the fractional currency unit (ex. cent) as 1 for U.S. dollar, euro, or Singapore dollar. Specify the currency unit as 1 for Japanese yen. (*3) Example) Specify 23 if the setting value is $0.23. Specify 23 if the setting value is ¥23.
9	Product name	No	Specify the name to distinguish the products using 128 or less characters.
10	Description	Yes	Specify the description of the product using 1024 or less characters. A comma that follows the name must be entered even when the specification is omitted. Example) ...,Unit price,"Product name",

*1: An example of description is shown below assuming following settings.

Example of the setting for product ID "ME-0001"
Product ID
Priority
Unit price
Start of applicable date
End of applicable date
Data A
ME-0001
0
$2.00
2012-01-01T00:00:00.000+0900
None
Data B
ME-0001
1
$1.00
2012-08-01T00:00:00.000+0900
2012-08-31T23:59:59.999+0900
- The unit price for product ID "ME-0001" is $2.00 on 2011-07-01 because only data A is applied.
- The unit price for product ID "ME-0001" is $1.00 on 2011-08-15 because data B has higher priority even though both data A and data B are in the applicable period.

An example description of accounting information file

"ME-0001",0,"2012-01-01T00:00:00.000+0900",,"memory","/VMPool","month",200,"Standard memory","Standard memory"
"ME-0001",1,"2012-08-01T00:00:00.000+0900","2012-08-31T23:59:59.999+0900","memory","/VMPool","month",100,"Standard memory(Campaign)","Standard memory(Campaign)"

*2: The value of the resource identifier can be obtained from the value of the corresponding XML tag of the template information list that is output in XML format by using the template information list display command. Refer to "9.12 cfmg_listtemplate (Displaying Template Information List)" in the "Reference Guide (Command/XML) CE" for information on how to use the template information list display command.
The resource identifier for each category code and the corresponding template information (XML tag) are shown below.

Resource identifiers and corresponding template information (XML tag)

Category code	Resource identifier	Template information (XML tag)
template	Template ID	<template><id>
vm	Virtual L-Server image name	<image><imageName>
pm	Physical L-Server image name	<image><imageName>
cpu	VM pool name or sever pool name	<server><pool>
cpu_clock	VM pool name or sever pool name	<server><pool>
memory	VM pool name or sever pool name	<server><pool>
sys_disk	Storage pool name	<server><storagePool>
disk	Storage pool name	<vdisk><storagePool>
snapshot	Storage pool name	<server><storagePool> and <vdisk><storagePool>
nic	Network resource ID	<vnet><resourceID>

Specify VM pool name, sever pool name and storage pool name in the format that start with / (slash).
If the VM pool name, sever pool name or storage pool name are omitted, they are output to the template information as <pool /> or <storagePool />, respectively. In this case, refer to the resource pool and perform settings on the [Resources] tab of the ROR console. Refer to the "User's Guide for Infrastructure Administrators (Resource Management) CE" for information on the [Resources] tab of the ROR console.

*3: The currency unit can be changed according to the currency unit setting. Specify the value multiplied by 10 raised to the power of the number of decimal places for the unit price in the accounting information file.

Example:

Specify 1 as the unit price of currency unit 1 if the currency unit has no decimal places.
Specify 100 as the unit price of currency unit 1.00 if the currency unit has two decimal places.

Refer to "8.7.2 Currency Information Settings" for information on how to set the currency unit.

An example description of template information and corresponding accounting information is shown below.

Example of template information

<?xml version="1.0" encoding="Windows-31J"?>
<templates>
  <template>
    <id>templateId1</id>
    ...
    <vnets>
      <vnet>
        <resourceID>rormng_123</resourceID>
      </vnet>
    </vnets>
    <servers>
      <server>
        <pool>/VMHostPool</pool>
        <storagePool>/StoragePool</storagePool>
        ...
        <vdisks>
          <vdisk>
            ...
            <storagePool>/StoragePool2</storagePool>
            ...
          </vdisk>
        </vdisks>
        <image>
          <imageName>image1</imageName>
          ...
        </image>
      </server>
    </servers>
  </template>
</templates>

Example description of accounting information file

"TP-0001",0,"2012-01-01T00:00:00.000+0900",,"template","templateId1","month",1000,"Web/DB Windows Server 2008 R2 Standard","Service Windows Server 2008 R2 Standard"
"VM-0001",0,"2012-01-01T00:00:00.000+0900",,"vm","image1","month",500,"Windows Server 2008 R2 Standard","VM Windows Server 2008 R2 Standard"
"CP-0001",0,"2012-01-01T00:00:00.000+0900",,"cpu","/VMHostPool","month",100,"Xeon5110","Xeon5110"
"CL-0001",0,"2012-01-01T00:00:00.000+0900",,"cpu_clock","/VMHostPool","month",50,"Xeon5110","Xeon5110"
"ME-0001",0,"2012-01-01T00:00:00.000+0900",,"memory","/VMHostPool","month",200,"Standard memory","Standard memory"
"DI-0001",0,"2012-01-01T00:00:00.000+0900",,"disk","/StoragePool2","month",10,"normal disk","normal disk"
"SD-0001",0,"2012-01-01T00:00:00.000+0900",,"sys_disk","/StoragePool","month",10,"normal disk","normal disk"
"SS-0001",0,"2012-01-01T00:00:00.000+0900",,"snapshot","/StoragePool","hour",0.1,"snapshot disk","snapshot disk"
"SS-0002",0,"2012-01-01T00:00:00.000+0900",,"snapshot","/StoragePool2","hour",0.1,"snapshot disk2","snapshot disk2"
"NC-0001",0,"2012-01-01T00:00:00.000+0900",,"nic","rormng_123","hour",0.1,"Standard NIC","Standard NIC"

Note

The accounting information will not be deleted from the product master automatically even after the end of applicable date. Reference to "15.3.3 Delete Accounting Information" to delete unnecessary accounting information.
If the end of applicable date is specified, prepare other accounting information of the same product ID without specifying the end of applicable date.
If the overcommit function is enabled, the category codes cpu_clock and memory will be calculated by default as CPU reserve performance and memory reserve capacity, respectively, and usage fee (the estimated price) will be displayed on the [L-Platforms] tab of the ROR console.
Refer to "8.7.1 Display Function Settings for Estimated Price" for information on charge settings when the overcommit function is enabled.

	Product ID	Priority	Unit price	Start of applicable date	End of applicable date
Data A	ME-0001	0	$2.00	2012-01-01T00:00:00.000+0900	None
Data B	ME-0001	1	$1.00	2012-08-01T00:00:00.000+0900	2012-08-31T23:59:59.999+0900