fscsm_chargeexport
fscsm_chargeexport -dir output-directory [-month targetmonth] [-bizSystemId platformID] [-projectId projectID] [-code accountingcode] [-menuId menuID]
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.
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>
The file name of the file to which billing data is output is determined based on the output unit, target year, and month.
Refer to "Billing Details File" in "3.2.3 Sending Billing".
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 |
# 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 |