Cloud Billing API - Hourly Report - Columns

columns

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_billing_detailed_line_items",
  "columns": [
    "id_",
    "account_",
    "month_",
    "invoice_i_d",
    "payer_account_id",
    "linked_account_id",
    "record_type",
    "product_name",
    "rate_id",
    "subscription_id",
    "pricing_plan_id",
    "usage_type",
    "operation",
    "availability_zone",
    "reserved_instance",
    "item_description",
    "usage_start_date",
    "usage_end_date",
    "usage_quantity",
    "rate",
    "cost"
  ],
  "detailedColumns": [
    {
      "tableName": "aws_billing_detailed_line_items",
      "columnName": "id_",
      "dataType": 12,
      "dataTypeName": "VARCHAR"
    },
    {
      "tableName": "aws_billing_detailed_line_items",
      "columnName": "account_",
      "dataType": 12,
      "dataTypeName": "VARCHAR"
    },
    {
      "tableName": "aws_billing_detailed_line_items",
      "columnName": "month_",
      "dataType": 12,
      "dataTypeName": "VARCHAR"
    },
    {
      "tableName": "aws_billing_detailed_line_items",
      "columnName": "invoice_i_d",
      "dataType": 12,
      "dataTypeName": "VARCHAR"
    },
    {
      "tableName": "aws_billing_detailed_line_items",
      "columnName": "payer_account_id",
      "dataType": 12,
      "dataTypeName": "VARCHAR"
    },
    {
      "tableName": "aws_billing_detailed_line_items",
      "columnName": "linked_account_id",
      "dataType": 12,
      "dataTypeName": "VARCHAR"
    },
    {
      "tableName": "aws_billing_detailed_line_items",
      "columnName": "record_type",
      "dataType": 12,
      "dataTypeName": "VARCHAR"
    },
    {
      "tableName": "aws_billing_detailed_line_items",
      "columnName": "product_name",
      "dataType": 12,
      "dataTypeName": "VARCHAR"
    },
    {
      "tableName": "aws_billing_detailed_line_items",
      "columnName": "rate_id",
      "dataType": 12,
      "dataTypeName": "VARCHAR"
    },
    {
      "tableName": "aws_billing_detailed_line_items",
      "columnName": "subscription_id",
      "dataType": 12,
      "dataTypeName": "VARCHAR"
    },
    {
      "tableName": "aws_billing_detailed_line_items",
      "columnName": "pricing_plan_id",
      "dataType": 12,
      "dataTypeName": "VARCHAR"
    },
    {
      "tableName": "aws_billing_detailed_line_items",
      "columnName": "usage_type",
      "dataType": 12,
      "dataTypeName": "VARCHAR"
    },
    {
      "tableName": "aws_billing_detailed_line_items",
      "columnName": "operation",
      "dataType": 12,
      "dataTypeName": "VARCHAR"
    },
    {
      "tableName": "aws_billing_detailed_line_items",
      "columnName": "availability_zone",
      "dataType": 12,
      "dataTypeName": "VARCHAR"
    },
    {
      "tableName": "aws_billing_detailed_line_items",
      "columnName": "reserved_instance",
      "dataType": -7,
      "dataTypeName": "BIT"
    },
    {
      "tableName": "aws_billing_detailed_line_items",
      "columnName": "item_description",
      "dataType": 12,
      "dataTypeName": "VARCHAR"
    },
    {
      "tableName": "aws_billing_detailed_line_items",
      "columnName": "usage_start_date",
      "dataType": 93,
      "dataTypeName": "TIMESTAMP"
    },
    {
      "tableName": "aws_billing_detailed_line_items",
      "columnName": "usage_end_date",
      "dataType": 93,
      "dataTypeName": "TIMESTAMP"
    },
    {
      "tableName": "aws_billing_detailed_line_items",
      "columnName": "usage_quantity",
      "dataType": 2,
      "dataTypeName": "NUMERIC"
    },
    {
      "tableName": "aws_billing_detailed_line_items",
      "columnName": "rate",
      "dataType": 2,
      "dataTypeName": "NUMERIC"
    },
    {
      "tableName": "aws_billing_detailed_line_items",
      "columnName": "cost",
      "dataType": 2,
      "dataTypeName": "NUMERIC"
    }
  ],
  "fields": [
    {
      "columnName": "id_",
      "unmangled": [
        "id_"
      ],
      "inFile": false
    },
    {
      "columnName": "account_",
      "unmangled": [
        "account_"
      ],
      "inFile": false
    },
    {
      "columnName": "month_",
      "unmangled": [
        "month_"
      ],
      "inFile": false
    },
    {
      "columnName": "invoice_i_d",
      "unmangled": [
        "InvoiceID"
      ],
      "inFile": true
    },
    {
      "columnName": "payer_account_id",
      "unmangled": [
        "PayerAccountId"
      ],
      "inFile": true
    },
    {
      "columnName": "linked_account_id",
      "unmangled": [
        "LinkedAccountId"
      ],
      "inFile": true
    },
    {
      "columnName": "record_type",
      "unmangled": [
        "RecordType"
      ],
      "inFile": true
    },
    {
      "columnName": "product_name",
      "unmangled": [
        "ProductName"
      ],
      "inFile": true
    },
    {
      "columnName": "rate_id",
      "unmangled": [
        "RateId"
      ],
      "inFile": true
    },
    {
      "columnName": "subscription_id",
      "unmangled": [
        "SubscriptionId"
      ],
      "inFile": true
    },
    {
      "columnName": "pricing_plan_id",
      "unmangled": [
        "PricingPlanId"
      ],
      "inFile": true
    },
    {
      "columnName": "usage_type",
      "unmangled": [
        "UsageType"
      ],
      "inFile": true
    },
    {
      "columnName": "operation",
      "unmangled": [
        "Operation"
      ],
      "inFile": true
    },
    {
      "columnName": "availability_zone",
      "unmangled": [
        "AvailabilityZone"
      ],
      "inFile": true
    },
    {
      "columnName": "reserved_instance",
      "unmangled": [
        "ReservedInstance"
      ],
      "inFile": true
    },
    {
      "columnName": "item_description",
      "unmangled": [
        "ItemDescription"
      ],
      "inFile": true
    },
    {
      "columnName": "usage_start_date",
      "unmangled": [
        "UsageStartDate"
      ],
      "inFile": true
    },
    {
      "columnName": "usage_end_date",
      "unmangled": [
        "UsageEndDate"
      ],
      "inFile": true
    },
    {
      "columnName": "usage_quantity",
      "unmangled": [
        "UsageQuantity"
      ],
      "inFile": true
    },
    {
      "columnName": "rate",
      "unmangled": [
        "Rate"
      ],
      "inFile": true
    },
    {
      "columnName": "cost",
      "unmangled": [
        "Cost"
      ],
      "inFile": true
    }
  ]
}
columns

Navigation

root

parent

self

Data
