1. Home
  2. Products
  3. Cloud Billing Database
  4. Documentation
  5. 1.0
  6. API
  7. Tables
  8. Monthly Report with Tags
  9. Select

Cloud Billing API - Monthly Report with Tags - Select

select

Navigation

Link

root

Common link which links to the root level of the service.

tag
a (look at the href attribute for the URL)
id
root
Link

parent

Common link which links to the parent resource.

tag
a (look at the href attribute for the URL)
id
parent
Link

self

Common link which links to this resource.

tag
a (look at the href attribute for the URL)
id
self

Data

tag
code
id
data__
classes
  • data

{
  "tableName": "aws_cost_allocation",
  "columns": [],
  "whereClauses": [],
  "limit": 2,
  "query": "SELECT * FROM aws_cost_allocation ORDER BY id_ LIMIT ? ",
  "parameters": [
    2
  ],
  "records": [
    {
      "id_": "20130112345678901200000000000000000000",
      "account_": "123456789012",
      "month_": "2013-01",
      "invoice_i_d": "26889551",
      "payer_account_id": "123456789012",
      "linked_account_id": "123456789012",
      "record_type": "PayerLineItem",
      "record_i_d": "400000000103568005",
      "billing_period_start_date": "2013-01-01T00:00:00Z",
      "billing_period_end_date": "2013-01-31T23:59:59Z",
      "invoice_date": "2013-02-03T12:40:24Z",
      "payer_account_name": "Joe User",
      "taxation_address": "123 Main St, Anytown, CA, 98765-4321, US",
      "product_code": "AmazonEC2",
      "product_name": "Amazon Elastic Compute Cloud",
      "seller_of_record": "Amazon Web Services, Inc.",
      "usage_type": "USW2-EBS:SnapshotUsage",
      "rate_id": "895707",
      "item_description": "$0.095 per GB-Month of snapshot data stored",
      "usage_start_date": "2013-01-01T00:00:00Z",
      "usage_end_date": "2013-01-31T23:59:59Z",
      "usage_quantity": 14.55629990,
      "currency_code": "USD",
      "cost_before_tax": 1.380000,
      "credits": 0.000000,
      "tax_amount": 0.000000,
      "tax_type": "None",
      "total_cost": 1.380000
    },
    {
      "id_": "20130112345678901200000000000000000001",
      "account_": "123456789012",
      "month_": "2013-01",
      "invoice_i_d": "26889551",
      "payer_account_id": "123456789012",
      "linked_account_id": "123456789012",
      "record_type": "PayerLineItem",
      "record_i_d": "400000000103567975",
      "billing_period_start_date": "2013-01-01T00:00:00Z",
      "billing_period_end_date": "2013-01-31T23:59:59Z",
      "invoice_date": "2013-02-03T12:40:24Z",
      "payer_account_name": "Joe User",
      "taxation_address": "123 Main St, Anytown, CA, 98765-4321, US",
      "product_code": "AmazonEC2",
      "product_name": "Amazon Elastic Compute Cloud",
      "seller_of_record": "Amazon Web Services, Inc.",
      "usage_type": "APN1-EBS:VolumeIOUsage",
      "rate_id": "894729",
      "item_description": "$0.12 per 1 million I/O requests ",
      "usage_start_date": "2013-01-01T00:00:00Z",
      "usage_end_date": "2013-01-31T23:59:59Z",
      "usage_quantity": 372694.00000000,
      "currency_code": "USD",
      "cost_before_tax": 0.040000,
      "credits": 0.000000,
      "tax_amount": 0.000000,
      "tax_type": "None",
      "total_cost": 0.040000
    }
  ]
}