AWS Data Datables

Overview

The following list of tables contain information pertaining to AWS usage.

• AwsAccount
• AwsDescription
• AwsInvoices
• AwsProducts
• AwsReservations

• AwsSavingsPlan

AwsAccounts

Name	Type	Description
Key	PK, Integer	Primary Key
AWSUsageAccountId	String	The tenant id in the AWS Partner Center
CustomerCode	String	The customer id in CloudBilling

AwsDescription

Name	Type	Description
Key	PK, Integer
Description	String
CustomerCode	String

AwsInvoices

Name	Type	Description
Key	PK, Integer
AwsInvoiceStart	FK, Integer
AwsInvoiceEnd	FK, String

AwsProducts

Name	Type	Description
Key	PK, Integer
ItemAvailabilityZone	String
ItemOperation	String
ItemType	String
ItemUsageType	String
ItemProductCode	String
ServiceCode	String
ServiceName	String
Location	String
InstanceType	String
ProductFamily	String
ProductName	String
Sku	String

AwsReservations

Name	Type	Description
Key	PK, Integer
ReservationStart	FK, Integer
ReservationEnd	FK, Integer
ReservationArn	String
TotalReservedUnits	String
CustomerCode	String

AWSSavingsPlans

Name	Type	Description
Key	PK, Integer
SavingsPlanArn	String
CustomerCode	String