5.2.8 Billing Output Command

Command Name: fscsm_chargeexport

Format

fscsm_chargeexport -dir output-directory [-month targetmonth] [-bizSystemId platformID] [-projectId projectID] [-code accountingcode] [-menuId menuID]

Description

Outputs the billing data for the specified month as a CSV file.

In output-directory, specify a folder name using a character string containing alphanumeric characters, hyphens ("-"), and underscores ("_"). This parameter cannot be omitted. Before executing this command, create an empty folder and specify it as the output folder. When the specified folder does not exist or is not empty, an error will occur.

In targetmonth, specify the year and month of the output target in the format, YYYY-MM. This parameter can be omitted. If omitted, the data for the most recent year and month for which billing data has been processed will be the target.

In platformID, specify the platform ID. This parameter can be omitted. If it is omitted, the billing data for all platforms will be the target.

In projectID, specify a project ID. This parameter can be omitted. If it is omitted, the billing data for all projects will be the target.

In accountingcode, specify the accounting code. This parameter can be omitted. If it is omitted, the billing data for all accounting codes will be the target.

Specify a menu ID for menuID. This parameter can be omitted. If it is omitted, the billing data for all menus will be the target.

Example

When outputting the monthly usage charges for May 2015 for the business system ID 533 as a file

>fscsm_chargeexport -dir .\usertmp\chargeex\biz\533\201505 -month 2015-05 -bizSystemId 533<RETURN>

When outputting the monthly usage charges for May 2015 for the accounting code 533 as a file

>fscsm_chargeexport -dir .\usertmp\chargeex\biz\AccountABB\201505 -month 2015-05 -code ABB<RETURN>

File Name and Output Content

The file name of the file to which billing data is output is determined based on the output unit, target year, and month.

File for Each Platform

Refer to "Billing Details File" in "3.2.3 Sending Billing".

Table 5.1 List of Elements Output to File
Item Name	Output Value or Example
version	Version of file format
date	Target month. Each entry is output in the following format: <Target month>(<Accounting period>)
accountingCode	Accounting Code
projectId	Project ID
menuName	Menu Name
bizSystemName	Platform Name
category	Category
breakdown	Breakdown For virtual machines, system disk images, or data disk images, multiple pieces of information divided by "\|" are output. - For virtual machines "Virtual machine \| <Service ID> \| <Instance type>" - For system disk images "Image \| <Service ID> \| <System disk image>" - For data disks "Data disk" \| <Service ID> \| <Data disk type>"
unitPrice[<Currency Symbol>]	Unit Price
unitPriceUnit	Unit of unit price
usage	Amount of usage
usageUnit	Unit of usage
charge[<Currency Symbol>]	Charge

Output Example

# version, date, accountingCode, projectId, menuName, bizSystemName, category, breakdown, unitPrice[\], unitPriceUnit, usage, usageUnit, charge[\]

2, "2015-01(2015-01-01 - 2015-01-31)", "ACNT-001", "project001", "menu001", "bizsys001", "basicMenu", "Initial Costs", 2000, "/Month", 2, "Month", 2000

2, "2015-01(2015-01-01 - 2015-01-31)", "ACNT-001", "project001", "menu001", "bizsys001", "basicMenu", "Basic Charges", 2000, "/Month", 2, "Month", 2000

2, "2015-01(2015-01-01 - 2015-01-31)", "ACNT-001", "project001", "menu001", "bizsys001", "extendedOption", "Backup", 500, "/Month", 1, "Month", 500

2, "2015-01(2015-01-01 - 2015-01-31)", "ACNT-001", "project001", "menu001", "bizsys001", "extendedOption", "Standard Monitoring", 500, "/Month", 1, "Month", 500

2, "2015-01(2015-01-01 - 2015-01-31)", "ACNT-001", "project001", "menu001", "bizsys001", "serviceOption", "virtualMachine|server001|small", 30, "/Hour", 550, "Hour", 16500

2, "2015-01(2015-01-01 - 2015-01-31)", "ACNT-001", "project001", "menu001", "bizsys001", "serviceOption", "Image|server001|win2012", 500, "/Month", 1, "Month", 500

2, "2015-01(2015-01-01 - 2015-01-31)", "ACNT-001", "project001", "menu001", "bizsys001", "serviceOption", "Data Disk|server001|200GB", 1000, "/Number of disks * Month", 1, "Number of disks * Month", 2000