Cloud Billing API - Monthly 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_csv",
  "columns": [
    "id_",
    "account_",
    "month_",
    "invoice_i_d",
    "payer_account_id",
    "linked_account_id",
    "record_type",
    "record_i_d",
    "billing_period_start_date",
    "billing_period_end_date",
    "invoice_date",
    "payer_account_name",
    "linked_account_name",
    "taxation_address",
    "payer_p_o_number",
    "product_code",
    "product_name",
    "seller_of_record",
    "usage_type",
    "operation",
    "rate_id",
    "item_description",
    "usage_start_date",
    "usage_end_date",
    "usage_quantity",
    "blended_rate",
    "currency_code",
    "cost_before_tax",
    "credits",
    "tax_amount",
    "tax_type",
    "total_cost"
  ],
  "detailedColumns": [
    {
      "tableName": "aws_billing_csv",
      "columnName": "id_",
      "dataType": 12,
      "dataTypeName": "VARCHAR"
    },
    {
      "tableName": "aws_billing_csv",
      "columnName": "account_",
      "dataType": 12,
      "dataTypeName": "VARCHAR"
    },
    {
      "tableName": "aws_billing_csv",
      "columnName": "month_",
      "dataType": 12,
      "dataTypeName": "VARCHAR"
    },
    {
      "tableName": "aws_billing_csv",
      "columnName": "invoice_i_d",
      "dataType": 12,
      "dataTypeName": "VARCHAR"
    },
    {
      "tableName": "aws_billing_csv",
      "columnName": "payer_account_id",
      "dataType": 12,
      "dataTypeName": "VARCHAR"
    },
    {
      "tableName": "aws_billing_csv",
      "columnName": "linked_account_id",
      "dataType": 12,
      "dataTypeName": "VARCHAR"
    },
    {
      "tableName": "aws_billing_csv",
      "columnName": "record_type",
      "dataType": 12,
      "dataTypeName": "VARCHAR"
    },
    {
      "tableName": "aws_billing_csv",
      "columnName": "record_i_d",
      "dataType": 12,
      "dataTypeName": "VARCHAR"
    },
    {
      "tableName": "aws_billing_csv",
      "columnName": "billing_period_start_date",
      "dataType": 93,
      "dataTypeName": "TIMESTAMP"
    },
    {
      "tableName": "aws_billing_csv",
      "columnName": "billing_period_end_date",
      "dataType": 93,
      "dataTypeName": "TIMESTAMP"
    },
    {
      "tableName": "aws_billing_csv",
      "columnName": "invoice_date",
      "dataType": 93,
      "dataTypeName": "TIMESTAMP"
    },
    {
      "tableName": "aws_billing_csv",
      "columnName": "payer_account_name",
      "dataType": 12,
      "dataTypeName": "VARCHAR"
    },
    {
      "tableName": "aws_billing_csv",
      "columnName": "linked_account_name",
      "dataType": 12,
      "dataTypeName": "VARCHAR"
    },
    {
      "tableName": "aws_billing_csv",
      "columnName": "taxation_address",
      "dataType": 12,
      "dataTypeName": "VARCHAR"
    },
    {
      "tableName": "aws_billing_csv",
      "columnName": "payer_p_o_number",
      "dataType": 12,
      "dataTypeName": "VARCHAR"
    },
    {
      "tableName": "aws_billing_csv",
      "columnName": "product_code",
      "dataType": 12,
      "dataTypeName": "VARCHAR"
    },
    {
      "tableName": "aws_billing_csv",
      "columnName": "product_name",
      "dataType": 12,
      "dataTypeName": "VARCHAR"
    },
    {
      "tableName": "aws_billing_csv",
      "columnName": "seller_of_record",
      "dataType": 12,
      "dataTypeName": "VARCHAR"
    },
    {
      "tableName": "aws_billing_csv",
      "columnName": "usage_type",
      "dataType": 12,
      "dataTypeName": "VARCHAR"
    },
    {
      "tableName": "aws_billing_csv",
      "columnName": "operation",
      "dataType": 12,
      "dataTypeName": "VARCHAR"
    },
    {
      "tableName": "aws_billing_csv",
      "columnName": "rate_id",
      "dataType": 12,
      "dataTypeName": "VARCHAR"
    },
    {
      "tableName": "aws_billing_csv",
      "columnName": "item_description",
      "dataType": 12,
      "dataTypeName": "VARCHAR"
    },
    {
      "tableName": "aws_billing_csv",
      "columnName": "usage_start_date",
      "dataType": 93,
      "dataTypeName": "TIMESTAMP"
    },
    {
      "tableName": "aws_billing_csv",
      "columnName": "usage_end_date",
      "dataType": 93,
      "dataTypeName": "TIMESTAMP"
    },
    {
      "tableName": "aws_billing_csv",
      "columnName": "usage_quantity",
      "dataType": 2,
      "dataTypeName": "NUMERIC"
    },
    {
      "tableName": "aws_billing_csv",
      "columnName": "blended_rate",
      "dataType": 2,
      "dataTypeName": "NUMERIC"
    },
    {
      "tableName": "aws_billing_csv",
      "columnName": "currency_code",
      "dataType": 12,
      "dataTypeName": "VARCHAR"
    },
    {
      "tableName": "aws_billing_csv",
      "columnName": "cost_before_tax",
      "dataType": 2,
      "dataTypeName": "NUMERIC"
    },
    {
      "tableName": "aws_billing_csv",
      "columnName": "credits",
      "dataType": 2,
      "dataTypeName": "NUMERIC"
    },
    {
      "tableName": "aws_billing_csv",
      "columnName": "tax_amount",
      "dataType": 2,
      "dataTypeName": "NUMERIC"
    },
    {
      "tableName": "aws_billing_csv",
      "columnName": "tax_type",
      "dataType": 12,
      "dataTypeName": "VARCHAR"
    },
    {
      "tableName": "aws_billing_csv",
      "columnName": "total_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": "record_i_d",
      "unmangled": [
        "RecordID"
      ],
      "inFile": true
    },
    {
      "columnName": "billing_period_start_date",
      "unmangled": [
        "BillingPeriodStartDate"
      ],
      "inFile": true
    },
    {
      "columnName": "billing_period_end_date",
      "unmangled": [
        "BillingPeriodEndDate"
      ],
      "inFile": true
    },
    {
      "columnName": "invoice_date",
      "unmangled": [
        "InvoiceDate"
      ],
      "inFile": true
    },
    {
      "columnName": "payer_account_name",
      "unmangled": [
        "PayerAccountName"
      ],
      "inFile": true
    },
    {
      "columnName": "linked_account_name",
      "unmangled": [
        "LinkedAccountName"
      ],
      "inFile": true
    },
    {
      "columnName": "taxation_address",
      "unmangled": [
        "TaxationAddress"
      ],
      "inFile": true
    },
    {
      "columnName": "payer_p_o_number",
      "unmangled": [
        "PayerPONumber"
      ],
      "inFile": true
    },
    {
      "columnName": "product_code",
      "unmangled": [
        "ProductCode"
      ],
      "inFile": true
    },
    {
      "columnName": "product_name",
      "unmangled": [
        "ProductName"
      ],
      "inFile": true
    },
    {
      "columnName": "seller_of_record",
      "unmangled": [
        "SellerOfRecord"
      ],
      "inFile": true
    },
    {
      "columnName": "usage_type",
      "unmangled": [
        "UsageType"
      ],
      "inFile": true
    },
    {
      "columnName": "operation",
      "unmangled": [
        "Operation"
      ],
      "inFile": true
    },
    {
      "columnName": "rate_id",
      "unmangled": [
        "RateId"
      ],
      "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": "blended_rate",
      "unmangled": [
        "BlendedRate"
      ],
      "inFile": true
    },
    {
      "columnName": "currency_code",
      "unmangled": [
        "CurrencyCode"
      ],
      "inFile": true
    },
    {
      "columnName": "cost_before_tax",
      "unmangled": [
        "CostBeforeTax"
      ],
      "inFile": true
    },
    {
      "columnName": "credits",
      "unmangled": [
        "Credits"
      ],
      "inFile": true
    },
    {
      "columnName": "tax_amount",
      "unmangled": [
        "TaxAmount"
      ],
      "inFile": true
    },
    {
      "columnName": "tax_type",
      "unmangled": [
        "TaxType"
      ],
      "inFile": true
    },
    {
      "columnName": "total_cost",
      "unmangled": [
        "TotalCost"
      ],
      "inFile": true
    }
  ]
}
columns

Navigation

root

parent

self

Data
