Cloud Billing API - Monthly Report with Tags - Columns
columns
Navigation
Link |
rootCommon link which links to the root level of the service.
|
Link |
parentCommon link which links to the parent resource.
|
Link |
selfCommon link which links to this resource.
|
Data
- tag
code
- id
data__
- classes
data
{
"tableName": "aws_cost_allocation",
"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",
"availability_zone",
"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",
"user__account",
"user__department",
"aws_autoscaling_group_name"
],
"detailedColumns": [
{
"tableName": "aws_cost_allocation",
"columnName": "id_",
"dataType": 12,
"dataTypeName": "VARCHAR"
},
{
"tableName": "aws_cost_allocation",
"columnName": "account_",
"dataType": 12,
"dataTypeName": "VARCHAR"
},
{
"tableName": "aws_cost_allocation",
"columnName": "month_",
"dataType": 12,
"dataTypeName": "VARCHAR"
},
{
"tableName": "aws_cost_allocation",
"columnName": "invoice_i_d",
"dataType": 12,
"dataTypeName": "VARCHAR"
},
{
"tableName": "aws_cost_allocation",
"columnName": "payer_account_id",
"dataType": 12,
"dataTypeName": "VARCHAR"
},
{
"tableName": "aws_cost_allocation",
"columnName": "linked_account_id",
"dataType": 12,
"dataTypeName": "VARCHAR"
},
{
"tableName": "aws_cost_allocation",
"columnName": "record_type",
"dataType": 12,
"dataTypeName": "VARCHAR"
},
{
"tableName": "aws_cost_allocation",
"columnName": "record_i_d",
"dataType": 12,
"dataTypeName": "VARCHAR"
},
{
"tableName": "aws_cost_allocation",
"columnName": "billing_period_start_date",
"dataType": 93,
"dataTypeName": "TIMESTAMP"
},
{
"tableName": "aws_cost_allocation",
"columnName": "billing_period_end_date",
"dataType": 93,
"dataTypeName": "TIMESTAMP"
},
{
"tableName": "aws_cost_allocation",
"columnName": "invoice_date",
"dataType": 93,
"dataTypeName": "TIMESTAMP"
},
{
"tableName": "aws_cost_allocation",
"columnName": "payer_account_name",
"dataType": 12,
"dataTypeName": "VARCHAR"
},
{
"tableName": "aws_cost_allocation",
"columnName": "linked_account_name",
"dataType": 12,
"dataTypeName": "VARCHAR"
},
{
"tableName": "aws_cost_allocation",
"columnName": "taxation_address",
"dataType": 12,
"dataTypeName": "VARCHAR"
},
{
"tableName": "aws_cost_allocation",
"columnName": "payer_p_o_number",
"dataType": 12,
"dataTypeName": "VARCHAR"
},
{
"tableName": "aws_cost_allocation",
"columnName": "product_code",
"dataType": 12,
"dataTypeName": "VARCHAR"
},
{
"tableName": "aws_cost_allocation",
"columnName": "product_name",
"dataType": 12,
"dataTypeName": "VARCHAR"
},
{
"tableName": "aws_cost_allocation",
"columnName": "seller_of_record",
"dataType": 12,
"dataTypeName": "VARCHAR"
},
{
"tableName": "aws_cost_allocation",
"columnName": "usage_type",
"dataType": 12,
"dataTypeName": "VARCHAR"
},
{
"tableName": "aws_cost_allocation",
"columnName": "operation",
"dataType": 12,
"dataTypeName": "VARCHAR"
},
{
"tableName": "aws_cost_allocation",
"columnName": "availability_zone",
"dataType": 12,
"dataTypeName": "VARCHAR"
},
{
"tableName": "aws_cost_allocation",
"columnName": "rate_id",
"dataType": 12,
"dataTypeName": "VARCHAR"
},
{
"tableName": "aws_cost_allocation",
"columnName": "item_description",
"dataType": 12,
"dataTypeName": "VARCHAR"
},
{
"tableName": "aws_cost_allocation",
"columnName": "usage_start_date",
"dataType": 93,
"dataTypeName": "TIMESTAMP"
},
{
"tableName": "aws_cost_allocation",
"columnName": "usage_end_date",
"dataType": 93,
"dataTypeName": "TIMESTAMP"
},
{
"tableName": "aws_cost_allocation",
"columnName": "usage_quantity",
"dataType": 2,
"dataTypeName": "NUMERIC"
},
{
"tableName": "aws_cost_allocation",
"columnName": "blended_rate",
"dataType": 2,
"dataTypeName": "NUMERIC"
},
{
"tableName": "aws_cost_allocation",
"columnName": "currency_code",
"dataType": 12,
"dataTypeName": "VARCHAR"
},
{
"tableName": "aws_cost_allocation",
"columnName": "cost_before_tax",
"dataType": 2,
"dataTypeName": "NUMERIC"
},
{
"tableName": "aws_cost_allocation",
"columnName": "credits",
"dataType": 2,
"dataTypeName": "NUMERIC"
},
{
"tableName": "aws_cost_allocation",
"columnName": "tax_amount",
"dataType": 2,
"dataTypeName": "NUMERIC"
},
{
"tableName": "aws_cost_allocation",
"columnName": "tax_type",
"dataType": 12,
"dataTypeName": "VARCHAR"
},
{
"tableName": "aws_cost_allocation",
"columnName": "total_cost",
"dataType": 2,
"dataTypeName": "NUMERIC"
},
{
"tableName": "aws_cost_allocation",
"columnName": "user__account",
"dataType": 12,
"dataTypeName": "VARCHAR"
},
{
"tableName": "aws_cost_allocation",
"columnName": "user__department",
"dataType": 12,
"dataTypeName": "VARCHAR"
},
{
"tableName": "aws_cost_allocation",
"columnName": "aws_autoscaling_group_name",
"dataType": 12,
"dataTypeName": "VARCHAR"
}
],
"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": "availability_zone",
"unmangled": [
"AvailabilityZone"
],
"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
},
{
"columnName": "user__account",
"unmangled": [
"user:Account"
],
"inFile": true
},
{
"columnName": "user__department",
"unmangled": [
"user:Department"
],
"inFile": true
},
{
"columnName": "aws_autoscaling_group_name",
"unmangled": [
"aws:autoscaling:groupName"
],
"inFile": true
}
]
}