USE [idb_datastore]
GO
/****** Object:  Table [dbo].[QBO_Account]    Script Date: 7/6/2020 1:43:31 PM ******/
SET ANSI_NULLS ON
GO
SET QUOTED_IDENTIFIER ON
GO
CREATE TABLE [dbo].[QBO_Account](
	[AccountSubType] [varchar](255) NULL,
	[AccountType] [varchar](255) NULL,
	[AcctNum] [decimal](30, 10) NULL,
	[Active] [varchar](255) NULL,
	[Classification] [varchar](255) NULL,
	[CurrencyRef.name] [varchar](255) NULL,
	[CurrencyRef.value] [varchar](255) NULL,
	[CurrentBalance] [decimal](30, 10) NULL,
	[CurrentBalanceWithSubAccounts] [decimal](30, 10) NULL,
	[Description] [varchar](255) NULL,
	[domain] [varchar](255) NULL,
	[FullyQualifiedName] [varchar](255) NULL,
	[AccountLevel1] [varchar](255) NULL,
	[AccountLevel2] [varchar](255) NULL,
	[AccountLevel3] [varchar](255) NULL,
	[AccountLevel4] [varchar](255) NULL,
	[AccountLevel5] [varchar](255) NULL,
	[Id] [decimal](30, 10) NULL,
	[MetaData.CreateTime] [datetime] NULL,
	[MetaData.LastUpdatedTime] [datetime] NULL,
	[Name] [varchar](255) NULL,
	[ParentRef.value] [decimal](30, 10) NULL,
	[sparse] [varchar](255) NULL,
	[SubAccount] [varchar](255) NULL,
	[SyncToken] [decimal](30, 10) NULL
) ON [PRIMARY]
GO
/****** Object:  Table [dbo].[QBO_AllExpenses]    Script Date: 7/6/2020 1:43:32 PM ******/
SET ANSI_NULLS ON
GO
SET QUOTED_IDENTIFIER ON
GO
CREATE TABLE [dbo].[QBO_AllExpenses](
	[CurrencyRef.name] [varchar](255) NULL,
	[DocNumber] [decimal](30, 10) NULL,
	[VendorRef.name] [varchar](255) NULL,
	[ExchangeRate] [decimal](30, 10) NULL,
	[Id] [decimal](30, 10) NULL,
	[PrivateNote] [varchar](255) NULL,
	[TotalAmt] [decimal](30, 10) NULL,
	[TxnDate] [datetime] NULL,
	[AccountBasedExpenseLineDetail.AccountRef.name] [varchar](255) NULL,
	[AccountLevel1] [varchar](255) NULL,
	[AccountLevel2] [varchar](255) NULL,
	[AccountLevel3] [varchar](255) NULL,
	[AccountLevel4] [varchar](255) NULL,
	[AccountLevel5] [varchar](255) NULL,
	[AccountBasedExpenseLineDetail.AccountRef.value] [decimal](30, 10) NULL,
	[AccountBasedExpenseLineDetail.BillableStatus] [varchar](255) NULL,
	[AccountBasedExpenseLineDetail.ClassRef.name] [varchar](255) NULL,
	[AccountBasedExpenseLineDetail.ClassRef.value] [decimal](30, 10) NULL,
	[AccountBasedExpenseLineDetail.TaxCodeRef.value] [varchar](255) NULL,
	[Amount] [decimal](30, 10) NULL,
	[Description] [varchar](255) NULL,
	[Balance] [decimal](30, 10) NULL,
	[LineNum] [decimal](30, 10) NULL,
	[DueDate] [datetime] NULL,
	[DaysPastDue] [decimal](30, 10) NULL,
	[PastDue] [varchar](255) NULL,
	[PastDueBalance] [decimal](30, 10) NULL
) ON [PRIMARY]
GO
/****** Object:  Table [dbo].[QBO_AllSales]    Script Date: 7/6/2020 1:43:32 PM ******/
SET ANSI_NULLS ON
GO
SET QUOTED_IDENTIFIER ON
GO
CREATE TABLE [dbo].[QBO_AllSales](
	[Amount] [decimal](30, 10) NULL,
	[Description] [varchar](255) NULL,
	[DetailType] [varchar](255) NULL,
	[Id] [decimal](30, 10) NULL,
	[LineNum] [decimal](30, 10) NULL,
	[SalesItemLineDetail.ClassRef.name] [varchar](255) NULL,
	[SalesItemLineDetail.ClassRef.value] [decimal](30, 10) NULL,
	[SalesItemLineDetail.ItemRef.name] [varchar](255) NULL,
	[AccountLevel1] [varchar](255) NULL,
	[AccountLevel2] [varchar](255) NULL,
	[AccountLevel3] [varchar](255) NULL,
	[AccountLevel4] [varchar](255) NULL,
	[AccountLevel5] [varchar](255) NULL,
	[SalesItemLineDetail.ItemRef.value] [decimal](30, 10) NULL,
	[SalesItemLineDetail.Qty] [decimal](30, 10) NULL,
	[SalesItemLineDetail.TaxCodeRef.value] [varchar](255) NULL,
	[SalesItemLineDetail.UnitPrice] [decimal](30, 10) NULL,
	[Balance] [decimal](30, 10) NULL,
	[BillAddr.City] [varchar](255) NULL,
	[BillAddr.Country] [varchar](255) NULL,
	[BillAddr.CountrySubDivisionCode] [varchar](255) NULL,
	[BillAddr.Id] [decimal](30, 10) NULL,
	[BillAddr.Lat] [decimal](30, 10) NULL,
	[BillAddr.Line1] [varchar](255) NULL,
	[BillAddr.Line2] [varchar](255) NULL,
	[BillAddr.Long] [decimal](30, 10) NULL,
	[BillAddr.PostalCode] [decimal](30, 10) NULL,
	[BillEmail.Address] [varchar](255) NULL,
	[CurrencyRef.name] [varchar](255) NULL,
	[CurrencyRef.value] [varchar](255) NULL,
	[CustomerMemo.value] [varchar](255) NULL,
	[CustomerRef.name] [varchar](255) NULL,
	[CustomerRef.value] [decimal](30, 10) NULL,
	[DeliveryInfo.DeliveryTime] [datetime] NULL,
	[DeliveryInfo.DeliveryType] [varchar](255) NULL,
	[DocNumber] [decimal](30, 10) NULL,
	[PrivateNote] [varchar](255) NULL,
	[ShipAddr.City] [varchar](255) NULL,
	[ShipAddr.Country] [varchar](255) NULL,
	[ShipAddr.CountrySubDivisionCode] [varchar](255) NULL,
	[ShipAddr.Id] [decimal](30, 10) NULL,
	[ShipAddr.Lat] [decimal](30, 10) NULL,
	[ShipAddr.Line1] [varchar](255) NULL,
	[ShipAddr.Line2] [varchar](255) NULL,
	[ShipAddr.Long] [decimal](30, 10) NULL,
	[ShipAddr.PostalCode] [decimal](30, 10) NULL,
	[TotalAmt] [decimal](30, 10) NULL,
	[TxnDate] [datetime] NULL,
	[DueDate] [datetime] NULL,
	[DaysPastDue] [decimal](30, 10) NULL,
	[PastDue] [varchar](255) NULL,
	[PastDueBalance] [decimal](30, 10) NULL,
	[FullyQualifiedName_1] [varchar](255) NULL,
	[AccountLevel1_1] [varchar](255) NULL,
	[AccountLevel2_1] [varchar](255) NULL,
	[AccountLevel3_1] [varchar](255) NULL,
	[AccountLevel4_1] [varchar](255) NULL,
	[AccountLevel5_1] [varchar](255) NULL
) ON [PRIMARY]
GO
/****** Object:  Table [dbo].[QBO_AP_Aging]    Script Date: 7/6/2020 1:43:32 PM ******/
SET ANSI_NULLS ON
GO
SET QUOTED_IDENTIFIER ON
GO
CREATE TABLE [dbo].[QBO_AP_Aging](
	[Vendor] [varchar](255) NULL,
	[Current] [decimal](30, 10) NULL,
	[1 - 30] [decimal](30, 10) NULL,
	[31 - 60] [decimal](30, 10) NULL,
	[61 - 90] [decimal](30, 10) NULL,
	[91 and over] [decimal](30, 10) NULL,
	[Total] [decimal](30, 10) NULL
) ON [PRIMARY]
GO
/****** Object:  Table [dbo].[QBO_AR_Aging]    Script Date: 7/6/2020 1:43:32 PM ******/
SET ANSI_NULLS ON
GO
SET QUOTED_IDENTIFIER ON
GO
CREATE TABLE [dbo].[QBO_AR_Aging](
	[Customer] [varchar](255) NULL,
	[Current] [decimal](30, 10) NULL,
	[1 - 30] [decimal](30, 10) NULL,
	[31 - 60] [decimal](30, 10) NULL,
	[61 - 90] [decimal](30, 10) NULL,
	[91 and over] [decimal](30, 10) NULL,
	[Total] [decimal](30, 10) NULL
) ON [PRIMARY]
GO
/****** Object:  Table [dbo].[QBO_BalanceSheet_Report]    Script Date: 7/6/2020 1:43:32 PM ******/
SET ANSI_NULLS ON
GO
SET QUOTED_IDENTIFIER ON
GO
CREATE TABLE [dbo].[QBO_BalanceSheet_Report](
	[Account] [varchar](255) NULL,
	[Total] [decimal](30, 10) NULL,
	[Report] [varchar](255) NULL
) ON [PRIMARY]
GO
/****** Object:  Table [dbo].[QBO_Bill]    Script Date: 7/6/2020 1:43:33 PM ******/
SET ANSI_NULLS ON
GO
SET QUOTED_IDENTIFIER ON
GO
CREATE TABLE [dbo].[QBO_Bill](
	[APAccountRef.name] [varchar](255) NULL,
	[APAccountRef.value] [decimal](30, 10) NULL,
	[Balance] [decimal](30, 10) NULL,
	[CurrencyRef.name] [varchar](255) NULL,
	[CurrencyRef.value] [varchar](255) NULL,
	[DocNumber] [decimal](30, 10) NULL,
	[domain] [varchar](255) NULL,
	[DueDate] [datetime] NULL,
	[ExchangeRate] [decimal](30, 10) NULL,
	[Id] [decimal](30, 10) NULL,
	[MetaData.CreateTime] [datetime] NULL,
	[MetaData.LastUpdatedTime] [datetime] NULL,
	[PrivateNote] [varchar](255) NULL,
	[SalesTermRef.value] [decimal](30, 10) NULL,
	[sparse] [varchar](255) NULL,
	[SyncToken] [decimal](30, 10) NULL,
	[TotalAmt] [decimal](30, 10) NULL,
	[TxnDate] [datetime] NULL,
	[VendorRef.name] [varchar](255) NULL,
	[VendorRef.value] [decimal](30, 10) NULL
) ON [PRIMARY]
GO
/****** Object:  Table [dbo].[QBO_Bill_Lines]    Script Date: 7/6/2020 1:43:33 PM ******/
SET ANSI_NULLS ON
GO
SET QUOTED_IDENTIFIER ON
GO
CREATE TABLE [dbo].[QBO_Bill_Lines](
	[APAccountRef.name] [varchar](255) NULL,
	[APAccountRef.value] [decimal](30, 10) NULL,
	[Balance] [decimal](30, 10) NULL,
	[CurrencyRef.name] [varchar](255) NULL,
	[CurrencyRef.value] [varchar](255) NULL,
	[DocNumber] [decimal](30, 10) NULL,
	[domain] [varchar](255) NULL,
	[DueDate] [datetime] NULL,
	[ExchangeRate] [decimal](30, 10) NULL,
	[Id] [decimal](30, 10) NULL,
	[MetaData.CreateTime] [datetime] NULL,
	[MetaData.LastUpdatedTime] [datetime] NULL,
	[PrivateNote] [varchar](255) NULL,
	[SalesTermRef.value] [decimal](30, 10) NULL,
	[sparse] [varchar](255) NULL,
	[SyncToken] [decimal](30, 10) NULL,
	[TotalAmt] [decimal](30, 10) NULL,
	[TxnDate] [datetime] NULL,
	[VendorRef.name] [varchar](255) NULL,
	[VendorRef.value] [decimal](30, 10) NULL,
	[AccountBasedExpenseLineDetail.AccountRef.name] [varchar](255) NULL,
	[AccountLevel1] [varchar](255) NULL,
	[AccountLevel2] [varchar](255) NULL,
	[AccountLevel3] [varchar](255) NULL,
	[AccountLevel4] [varchar](255) NULL,
	[AccountLevel5] [varchar](255) NULL,
	[AccountBasedExpenseLineDetail.AccountRef.value] [decimal](30, 10) NULL,
	[AccountBasedExpenseLineDetail.BillableStatus] [varchar](255) NULL,
	[AccountBasedExpenseLineDetail.ClassRef.name] [varchar](255) NULL,
	[AccountBasedExpenseLineDetail.ClassRef.value] [decimal](30, 10) NULL,
	[AccountBasedExpenseLineDetail.TaxCodeRef.value] [varchar](255) NULL,
	[Amount] [decimal](30, 10) NULL,
	[BillRef.value] [decimal](30, 10) NULL,
	[Description] [varchar](255) NULL,
	[DetailType] [varchar](255) NULL,
	[LineNum] [decimal](30, 10) NULL
) ON [PRIMARY]
GO
/****** Object:  Table [dbo].[QBO_Budget_Detail]    Script Date: 7/6/2020 1:43:33 PM ******/
SET ANSI_NULLS ON
GO
SET QUOTED_IDENTIFIER ON
GO
CREATE TABLE [dbo].[QBO_Budget_Detail](
	[AccountSubType] [varchar](255) NULL,
	[AccountType] [varchar](255) NULL,
	[AcctNum] [decimal](30, 10) NULL,
	[Active] [varchar](255) NULL,
	[Classification] [varchar](255) NULL,
	[CurrencyRef.name] [varchar](255) NULL,
	[CurrencyRef.value] [varchar](255) NULL,
	[CurrentBalance] [decimal](30, 10) NULL,
	[CurrentBalanceWithSubAccounts] [decimal](30, 10) NULL,
	[Description] [varchar](255) NULL,
	[domain] [varchar](255) NULL,
	[FullyQualifiedName] [varchar](255) NULL,
	[AccountLevel1] [varchar](255) NULL,
	[AccountLevel2] [varchar](255) NULL,
	[AccountLevel3] [varchar](255) NULL,
	[AccountLevel4] [varchar](255) NULL,
	[AccountLevel5] [varchar](255) NULL,
	[MetaData.CreateTime] [datetime] NULL,
	[MetaData.LastUpdatedTime] [datetime] NULL,
	[Name] [varchar](255) NULL,
	[ParentRef.value] [decimal](30, 10) NULL,
	[sparse] [varchar](255) NULL,
	[SubAccount] [varchar](255) NULL,
	[SyncToken] [decimal](30, 10) NULL,
	[Active_1] [varchar](255) NULL,
	[BudgetEntryType] [varchar](255) NULL,
	[BudgetType] [varchar](255) NULL,
	[domain_1] [varchar](255) NULL,
	[EndDate] [datetime] NULL,
	[Id_1] [decimal](30, 10) NULL,
	[MetaData.CreateTime_1] [datetime] NULL,
	[MetaData.LastUpdatedTime_1] [datetime] NULL,
	[Name_1] [varchar](255) NULL,
	[sparse_1] [varchar](255) NULL,
	[StartDate] [datetime] NULL,
	[SyncToken_1] [decimal](30, 10) NULL,
	[AccountRef.name] [varchar](255) NULL,
	[AccountRef.value] [decimal](30, 10) NULL,
	[Amount] [decimal](30, 10) NULL,
	[BudgetDate] [datetime] NULL,
	[BudgetRef.value] [decimal](30, 10) NULL
) ON [PRIMARY]
GO
/****** Object:  Table [dbo].[QBO_Company_Name]    Script Date: 7/6/2020 1:43:34 PM ******/
SET ANSI_NULLS ON
GO
SET QUOTED_IDENTIFIER ON
GO
CREATE TABLE [dbo].[QBO_Company_Name](
	[CompanyName] [varchar](255) NULL
) ON [PRIMARY]
GO
/****** Object:  Table [dbo].[QBO_CustomerIncome_Report]    Script Date: 7/6/2020 1:43:34 PM ******/
SET ANSI_NULLS ON
GO
SET QUOTED_IDENTIFIER ON
GO
CREATE TABLE [dbo].[QBO_CustomerIncome_Report](
	[Customer] [varchar](255) NULL,
	[Income] [decimal](30, 10) NULL,
	[Expenses] [decimal](30, 10) NULL,
	[Net Income] [decimal](30, 10) NULL
) ON [PRIMARY]
GO
/****** Object:  Table [dbo].[QBO_Customers]    Script Date: 7/6/2020 1:43:34 PM ******/
SET ANSI_NULLS ON
GO
SET QUOTED_IDENTIFIER ON
GO
CREATE TABLE [dbo].[QBO_Customers](
	[Active] [varchar](255) NULL,
	[Balance] [decimal](30, 10) NULL,
	[BalanceWithJobs] [decimal](30, 10) NULL,
	[BillAddr.City] [varchar](255) NULL,
	[BillAddr.Country] [varchar](255) NULL,
	[BillAddr.CountrySubDivisionCode] [varchar](255) NULL,
	[BillAddr.Id] [decimal](30, 10) NULL,
	[BillAddr.Lat] [decimal](30, 10) NULL,
	[BillAddr.Line1] [varchar](255) NULL,
	[BillAddr.Line2] [varchar](255) NULL,
	[BillAddr.Long] [decimal](30, 10) NULL,
	[BillAddr.PostalCode] [decimal](30, 10) NULL,
	[BillWithParent] [varchar](255) NULL,
	[CompanyName] [varchar](255) NULL,
	[CurrencyRef.name] [varchar](255) NULL,
	[CurrencyRef.value] [varchar](255) NULL,
	[DisplayName] [varchar](255) NULL,
	[domain] [varchar](255) NULL,
	[FamilyName] [varchar](255) NULL,
	[FullyQualifiedName] [varchar](255) NULL,
	[GivenName] [varchar](255) NULL,
	[Id] [decimal](30, 10) NULL,
	[Job] [varchar](255) NULL,
	[MetaData.CreateTime] [datetime] NULL,
	[MetaData.LastUpdatedTime] [datetime] NULL,
	[Mobile.FreeFormNumber] [varchar](255) NULL,
	[Notes] [varchar](255) NULL,
	[PaymentMethodRef.value] [decimal](30, 10) NULL,
	[PreferredDeliveryMethod] [varchar](255) NULL,
	[PrimaryEmailAddr.Address] [varchar](255) NULL,
	[PrimaryPhone.FreeFormNumber] [varchar](255) NULL,
	[PrintOnCheckName] [varchar](255) NULL,
	[SalesTermRef.value] [decimal](30, 10) NULL,
	[ShipAddr.City] [varchar](255) NULL,
	[ShipAddr.Country] [varchar](255) NULL,
	[ShipAddr.CountrySubDivisionCode] [varchar](255) NULL,
	[ShipAddr.Id] [decimal](30, 10) NULL,
	[ShipAddr.Lat] [varchar](255) NULL,
	[ShipAddr.Line1] [varchar](255) NULL,
	[ShipAddr.Line2] [varchar](255) NULL,
	[ShipAddr.Long] [varchar](255) NULL,
	[ShipAddr.PostalCode] [decimal](30, 10) NULL,
	[sparse] [varchar](255) NULL,
	[SyncToken] [decimal](30, 10) NULL,
	[Taxable] [varchar](255) NULL,
	[WebAddr.URI] [varchar](255) NULL
) ON [PRIMARY]
GO
/****** Object:  Table [dbo].[QBO_Invoice]    Script Date: 7/6/2020 1:43:34 PM ******/
SET ANSI_NULLS ON
GO
SET QUOTED_IDENTIFIER ON
GO
CREATE TABLE [dbo].[QBO_Invoice](
	[AllowIPNPayment] [varchar](255) NULL,
	[AllowOnlineACHPayment] [varchar](255) NULL,
	[AllowOnlineCreditCardPayment] [varchar](255) NULL,
	[AllowOnlinePayment] [varchar](255) NULL,
	[ApplyTaxAfterDiscount] [varchar](255) NULL,
	[Balance] [decimal](30, 10) NULL,
	[BillAddr.City] [varchar](255) NULL,
	[BillAddr.Country] [varchar](255) NULL,
	[BillAddr.CountrySubDivisionCode] [varchar](255) NULL,
	[BillAddr.Id] [decimal](30, 10) NULL,
	[BillAddr.Lat] [decimal](30, 10) NULL,
	[BillAddr.Line1] [varchar](255) NULL,
	[BillAddr.Line2] [varchar](255) NULL,
	[BillAddr.Long] [decimal](30, 10) NULL,
	[BillAddr.PostalCode] [decimal](30, 10) NULL,
	[BillEmail.Address] [varchar](255) NULL,
	[CurrencyRef.name] [varchar](255) NULL,
	[CurrencyRef.value] [varchar](255) NULL,
	[CustomerMemo.value] [varchar](255) NULL,
	[CustomerRef.name] [varchar](255) NULL,
	[CustomerRef.value] [decimal](30, 10) NULL,
	[DeliveryInfo.DeliveryTime] [datetime] NULL,
	[DeliveryInfo.DeliveryType] [varchar](255) NULL,
	[Deposit] [decimal](30, 10) NULL,
	[DocNumber] [decimal](30, 10) NULL,
	[domain] [varchar](255) NULL,
	[DueDate] [datetime] NULL,
	[ECloudStatusTimeStamp] [datetime] NULL,
	[EInvoiceStatus] [varchar](255) NULL,
	[EmailStatus] [varchar](255) NULL,
	[ExchangeRate] [decimal](30, 10) NULL,
	[HomeTotalAmt] [decimal](30, 10) NULL,
	[Id] [decimal](30, 10) NULL,
	[MetaData.CreateTime] [datetime] NULL,
	[MetaData.LastUpdatedTime] [datetime] NULL,
	[PrintStatus] [varchar](255) NULL,
	[PrivateNote] [varchar](255) NULL,
	[SalesTermRef.value] [decimal](30, 10) NULL,
	[ShipAddr.City] [varchar](255) NULL,
	[ShipAddr.Country] [varchar](255) NULL,
	[ShipAddr.CountrySubDivisionCode] [varchar](255) NULL,
	[ShipAddr.Id] [decimal](30, 10) NULL,
	[ShipAddr.Lat] [decimal](30, 10) NULL,
	[ShipAddr.Line1] [varchar](255) NULL,
	[ShipAddr.Line2] [varchar](255) NULL,
	[ShipAddr.Long] [decimal](30, 10) NULL,
	[ShipAddr.PostalCode] [decimal](30, 10) NULL,
	[sparse] [varchar](255) NULL,
	[SyncToken] [decimal](30, 10) NULL,
	[TotalAmt] [decimal](30, 10) NULL,
	[TxnDate] [datetime] NULL
) ON [PRIMARY]
GO
/****** Object:  Table [dbo].[QBO_Invoice_Lines]    Script Date: 7/6/2020 1:43:35 PM ******/
SET ANSI_NULLS ON
GO
SET QUOTED_IDENTIFIER ON
GO
CREATE TABLE [dbo].[QBO_Invoice_Lines](
	[AllowIPNPayment] [varchar](255) NULL,
	[AllowOnlineACHPayment] [varchar](255) NULL,
	[AllowOnlineCreditCardPayment] [varchar](255) NULL,
	[AllowOnlinePayment] [varchar](255) NULL,
	[ApplyTaxAfterDiscount] [varchar](255) NULL,
	[Balance] [decimal](30, 10) NULL,
	[BillAddr.City] [varchar](255) NULL,
	[BillAddr.Country] [varchar](255) NULL,
	[BillAddr.CountrySubDivisionCode] [varchar](255) NULL,
	[BillAddr.Id] [decimal](30, 10) NULL,
	[BillAddr.Lat] [decimal](30, 10) NULL,
	[BillAddr.Line1] [varchar](255) NULL,
	[BillAddr.Line2] [varchar](255) NULL,
	[BillAddr.Long] [decimal](30, 10) NULL,
	[BillAddr.PostalCode] [decimal](30, 10) NULL,
	[BillEmail.Address] [varchar](255) NULL,
	[CurrencyRef.name] [varchar](255) NULL,
	[CurrencyRef.value] [varchar](255) NULL,
	[CustomerMemo.value] [varchar](255) NULL,
	[CustomerRef.name] [varchar](255) NULL,
	[CustomerRef.value] [decimal](30, 10) NULL,
	[DeliveryInfo.DeliveryTime] [datetime] NULL,
	[DeliveryInfo.DeliveryType] [varchar](255) NULL,
	[Deposit] [decimal](30, 10) NULL,
	[DocNumber] [decimal](30, 10) NULL,
	[domain] [varchar](255) NULL,
	[DueDate] [datetime] NULL,
	[ECloudStatusTimeStamp] [datetime] NULL,
	[EInvoiceStatus] [varchar](255) NULL,
	[EmailStatus] [varchar](255) NULL,
	[ExchangeRate] [decimal](30, 10) NULL,
	[HomeTotalAmt] [decimal](30, 10) NULL,
	[Id] [decimal](30, 10) NULL,
	[MetaData.CreateTime] [datetime] NULL,
	[MetaData.LastUpdatedTime] [datetime] NULL,
	[PrintStatus] [varchar](255) NULL,
	[PrivateNote] [varchar](255) NULL,
	[SalesTermRef.value] [decimal](30, 10) NULL,
	[ShipAddr.City] [varchar](255) NULL,
	[ShipAddr.Country] [varchar](255) NULL,
	[ShipAddr.CountrySubDivisionCode] [varchar](255) NULL,
	[ShipAddr.Id] [decimal](30, 10) NULL,
	[ShipAddr.Lat] [decimal](30, 10) NULL,
	[ShipAddr.Line1] [varchar](255) NULL,
	[ShipAddr.Line2] [varchar](255) NULL,
	[ShipAddr.Long] [decimal](30, 10) NULL,
	[ShipAddr.PostalCode] [decimal](30, 10) NULL,
	[sparse] [varchar](255) NULL,
	[SyncToken] [decimal](30, 10) NULL,
	[TotalAmt] [decimal](30, 10) NULL,
	[TxnDate] [datetime] NULL,
	[Amount] [decimal](30, 10) NULL,
	[Description] [varchar](255) NULL,
	[DetailType] [varchar](255) NULL,
	[Id_1] [decimal](30, 10) NULL,
	[LineNum] [decimal](30, 10) NULL,
	[SalesItemLineDetail.ClassRef.name] [varchar](255) NULL,
	[SalesItemLineDetail.ClassRef.value] [decimal](30, 10) NULL,
	[SalesItemLineDetail.ItemRef.name] [varchar](255) NULL,
	[AccountLevel1] [varchar](255) NULL,
	[AccountLevel2] [varchar](255) NULL,
	[AccountLevel3] [varchar](255) NULL,
	[AccountLevel4] [varchar](255) NULL,
	[AccountLevel5] [varchar](255) NULL,
	[SalesItemLineDetail.ItemRef.value] [decimal](30, 10) NULL,
	[SalesItemLineDetail.Qty] [decimal](30, 10) NULL,
	[SalesItemLineDetail.TaxCodeRef.value] [varchar](255) NULL,
	[SalesItemLineDetail.UnitPrice] [decimal](30, 10) NULL
) ON [PRIMARY]
GO
/****** Object:  Table [dbo].[QBO_Items]    Script Date: 7/6/2020 1:43:35 PM ******/
SET ANSI_NULLS ON
GO
SET QUOTED_IDENTIFIER ON
GO
CREATE TABLE [dbo].[QBO_Items](
	[Active] [varchar](255) NULL,
	[Description] [varchar](255) NULL,
	[domain] [varchar](255) NULL,
	[FullyQualifiedName] [varchar](255) NULL,
	[Id] [decimal](30, 10) NULL,
	[IncomeAccountRef.name] [varchar](255) NULL,
	[IncomeAccountRef.value] [decimal](30, 10) NULL,
	[Level] [decimal](30, 10) NULL,
	[MetaData.CreateTime] [datetime] NULL,
	[MetaData.LastUpdatedTime] [datetime] NULL,
	[Name] [varchar](255) NULL,
	[ParentRef.name] [varchar](255) NULL,
	[ParentRef.value] [decimal](30, 10) NULL,
	[PurchaseCost] [decimal](30, 10) NULL,
	[sparse] [varchar](255) NULL,
	[SubItem] [varchar](255) NULL,
	[SyncToken] [decimal](30, 10) NULL,
	[Taxable] [varchar](255) NULL,
	[TrackQtyOnHand] [varchar](255) NULL,
	[Type] [varchar](255) NULL,
	[UnitPrice] [decimal](30, 10) NULL
) ON [PRIMARY]
GO
/****** Object:  Table [dbo].[QBO_ProfitLoss_Report]    Script Date: 7/6/2020 1:43:35 PM ******/
SET ANSI_NULLS ON
GO
SET QUOTED_IDENTIFIER ON
GO
CREATE TABLE [dbo].[QBO_ProfitLoss_Report](
	[Date] [datetime] NULL,
	[Transaction Type] [varchar](255) NULL,
	[Num] [varchar](255) NULL,
	[Create Date] [datetime] NULL,
	[Created By] [varchar](255) NULL,
	[Last Modified] [datetime] NULL,
	[Last Modified By] [varchar](255) NULL,
	[Name] [varchar](255) NULL,
	[Class] [varchar](255) NULL,
	[Memo/Description] [varchar](255) NULL,
	[Split] [varchar](255) NULL,
	[Debit] [decimal](30, 10) NULL,
	[Credit] [decimal](30, 10) NULL,
	[Payment Method] [varchar](255) NULL,
	[Amount] [varchar](255) NULL,
	[Balance] [varchar](255) NULL,
	[Exchange Rate] [varchar](255) NULL,
	[Currency] [varchar](255) NULL,
	[Foreign Amount] [varchar](255) NULL,
	[Report] [varchar](255) NULL
) ON [PRIMARY]
GO
/****** Object:  Table [dbo].[QBO_Purchase]    Script Date: 7/6/2020 1:43:35 PM ******/
SET ANSI_NULLS ON
GO
SET QUOTED_IDENTIFIER ON
GO
CREATE TABLE [dbo].[QBO_Purchase](
	[AccountRef.name] [varchar](255) NULL,
	[AccountRef.value] [decimal](30, 10) NULL,
	[CurrencyRef.name] [varchar](255) NULL,
	[CurrencyRef.value] [varchar](255) NULL,
	[DocNumber] [decimal](30, 10) NULL,
	[domain] [varchar](255) NULL,
	[EntityRef.name] [varchar](255) NULL,
	[EntityRef.type] [varchar](255) NULL,
	[EntityRef.value] [decimal](30, 10) NULL,
	[ExchangeRate] [decimal](30, 10) NULL,
	[Id] [decimal](30, 10) NULL,
	[MetaData.CreateTime] [datetime] NULL,
	[MetaData.LastUpdatedTime] [datetime] NULL,
	[PaymentMethodRef.value] [decimal](30, 10) NULL,
	[PaymentType] [varchar](255) NULL,
	[PrintStatus] [varchar](255) NULL,
	[PrivateNote] [varchar](255) NULL,
	[RemitToAddr.City] [varchar](255) NULL,
	[RemitToAddr.Country] [varchar](255) NULL,
	[RemitToAddr.CountrySubDivisionCode] [varchar](255) NULL,
	[RemitToAddr.Id] [decimal](30, 10) NULL,
	[RemitToAddr.Line1] [varchar](255) NULL,
	[RemitToAddr.PostalCode] [decimal](30, 10) NULL,
	[sparse] [varchar](255) NULL,
	[SyncToken] [decimal](30, 10) NULL,
	[TotalAmt] [decimal](30, 10) NULL,
	[TxnDate] [datetime] NULL
) ON [PRIMARY]
GO
/****** Object:  Table [dbo].[QBO_Purchase_Lines]    Script Date: 7/6/2020 1:43:35 PM ******/
SET ANSI_NULLS ON
GO
SET QUOTED_IDENTIFIER ON
GO
CREATE TABLE [dbo].[QBO_Purchase_Lines](
	[AccountRef.name] [varchar](255) NULL,
	[AccountRef.value] [decimal](30, 10) NULL,
	[CurrencyRef.name] [varchar](255) NULL,
	[CurrencyRef.value] [varchar](255) NULL,
	[DocNumber] [decimal](30, 10) NULL,
	[domain] [varchar](255) NULL,
	[EntityRef.name] [varchar](255) NULL,
	[EntityRef.type] [varchar](255) NULL,
	[EntityRef.value] [decimal](30, 10) NULL,
	[ExchangeRate] [decimal](30, 10) NULL,
	[Id] [decimal](30, 10) NULL,
	[MetaData.CreateTime] [datetime] NULL,
	[MetaData.LastUpdatedTime] [datetime] NULL,
	[PaymentMethodRef.value] [decimal](30, 10) NULL,
	[PaymentType] [varchar](255) NULL,
	[PrintStatus] [varchar](255) NULL,
	[PrivateNote] [varchar](255) NULL,
	[RemitToAddr.City] [varchar](255) NULL,
	[RemitToAddr.Country] [varchar](255) NULL,
	[RemitToAddr.CountrySubDivisionCode] [varchar](255) NULL,
	[RemitToAddr.Id] [decimal](30, 10) NULL,
	[RemitToAddr.Line1] [varchar](255) NULL,
	[RemitToAddr.PostalCode] [decimal](30, 10) NULL,
	[sparse] [varchar](255) NULL,
	[SyncToken] [decimal](30, 10) NULL,
	[TotalAmt] [decimal](30, 10) NULL,
	[TxnDate] [datetime] NULL,
	[AccountBasedExpenseLineDetail.AccountRef.name] [varchar](255) NULL,
	[AccountLevel1] [varchar](255) NULL,
	[AccountLevel2] [varchar](255) NULL,
	[AccountLevel3] [varchar](255) NULL,
	[AccountLevel4] [varchar](255) NULL,
	[AccountLevel5] [varchar](255) NULL,
	[AccountBasedExpenseLineDetail.AccountRef.value] [decimal](30, 10) NULL,
	[AccountBasedExpenseLineDetail.BillableStatus] [varchar](255) NULL,
	[AccountBasedExpenseLineDetail.ClassRef.name] [varchar](255) NULL,
	[AccountBasedExpenseLineDetail.ClassRef.value] [decimal](30, 10) NULL,
	[AccountBasedExpenseLineDetail.CustomerRef.name] [varchar](255) NULL,
	[AccountBasedExpenseLineDetail.CustomerRef.value] [decimal](30, 10) NULL,
	[AccountBasedExpenseLineDetail.TaxCodeRef.value] [varchar](255) NULL,
	[Amount] [decimal](30, 10) NULL,
	[Description] [varchar](255) NULL,
	[DetailType] [varchar](255) NULL,
	[Id_1] [decimal](30, 10) NULL
) ON [PRIMARY]
GO
/****** Object:  Table [dbo].[QBO_SalesReceipt]    Script Date: 7/6/2020 1:43:36 PM ******/
SET ANSI_NULLS ON
GO
SET QUOTED_IDENTIFIER ON
GO
CREATE TABLE [dbo].[QBO_SalesReceipt](
	[ApplyTaxAfterDiscount] [varchar](255) NULL,
	[Balance] [decimal](30, 10) NULL,
	[BillAddr.City] [varchar](255) NULL,
	[BillAddr.Country] [varchar](255) NULL,
	[BillAddr.CountrySubDivisionCode] [varchar](255) NULL,
	[BillAddr.Id] [decimal](30, 10) NULL,
	[BillAddr.Lat] [decimal](30, 10) NULL,
	[BillAddr.Line1] [varchar](255) NULL,
	[BillAddr.Line2] [varchar](255) NULL,
	[BillAddr.Long] [decimal](30, 10) NULL,
	[BillAddr.PostalCode] [decimal](30, 10) NULL,
	[BillEmail.Address] [varchar](255) NULL,
	[CreditCardPayment.CreditChargeInfo.Amount] [decimal](30, 10) NULL,
	[CreditCardPayment.CreditChargeInfo.CcExpiryMonth] [decimal](30, 10) NULL,
	[CreditCardPayment.CreditChargeInfo.CcExpiryYear] [decimal](30, 10) NULL,
	[CreditCardPayment.CreditChargeInfo.NameOnAcct] [varchar](255) NULL,
	[CreditCardPayment.CreditChargeInfo.Number] [varchar](255) NULL,
	[CreditCardPayment.CreditChargeInfo.PostalCode] [decimal](30, 10) NULL,
	[CreditCardPayment.CreditChargeInfo.ProcessPayment] [varchar](255) NULL,
	[CreditCardPayment.CreditChargeResponse.AuthCode] [decimal](30, 10) NULL,
	[CreditCardPayment.CreditChargeResponse.AvsStreet] [varchar](255) NULL,
	[CreditCardPayment.CreditChargeResponse.AvsZip] [varchar](255) NULL,
	[CreditCardPayment.CreditChargeResponse.CardSecurit] [varchar](255) NULL,
	[CreditCardPayment.CreditChargeResponse.CCTransId] [varchar](255) NULL,
	[CreditCardPayment.CreditChargeResponse.Status] [varchar](255) NULL,
	[CreditCardPayment.CreditChargeResponse.TxnAuthoriz] [datetime] NULL,
	[CurrencyRef.name] [varchar](255) NULL,
	[CurrencyRef.value] [varchar](255) NULL,
	[CustomerMemo.value] [varchar](255) NULL,
	[CustomerRef.name] [varchar](255) NULL,
	[CustomerRef.value] [decimal](30, 10) NULL,
	[DeliveryInfo.DeliveryTime] [datetime] NULL,
	[DeliveryInfo.DeliveryType] [varchar](255) NULL,
	[DepositToAccountRef.name] [varchar](255) NULL,
	[DepositToAccountRef.value] [decimal](30, 10) NULL,
	[DocNumber] [decimal](30, 10) NULL,
	[domain] [varchar](255) NULL,
	[EmailStatus] [varchar](255) NULL,
	[ExchangeRate] [decimal](30, 10) NULL,
	[HomeTotalAmt] [decimal](30, 10) NULL,
	[Id] [decimal](30, 10) NULL,
	[MetaData.CreateTime] [datetime] NULL,
	[MetaData.LastUpdatedTime] [datetime] NULL,
	[PaymentMethodRef.name] [varchar](255) NULL,
	[PaymentMethodRef.value] [decimal](30, 10) NULL,
	[PaymentRefNum] [decimal](30, 10) NULL,
	[PrintStatus] [varchar](255) NULL,
	[PrivateNote] [varchar](255) NULL,
	[ShipAddr.City] [varchar](255) NULL,
	[ShipAddr.Country] [varchar](255) NULL,
	[ShipAddr.CountrySubDivisionCode] [varchar](255) NULL,
	[ShipAddr.Id] [decimal](30, 10) NULL,
	[ShipAddr.Lat] [decimal](30, 10) NULL,
	[ShipAddr.Line1] [varchar](255) NULL,
	[ShipAddr.Line2] [varchar](255) NULL,
	[ShipAddr.Long] [decimal](30, 10) NULL,
	[ShipAddr.PostalCode] [decimal](30, 10) NULL,
	[sparse] [varchar](255) NULL,
	[SyncToken] [decimal](30, 10) NULL,
	[TotalAmt] [decimal](30, 10) NULL,
	[TxnDate] [datetime] NULL,
	[TxnSource] [varchar](255) NULL
) ON [PRIMARY]
GO
/****** Object:  Table [dbo].[QBO_SalesReceipt_Lines]    Script Date: 7/6/2020 1:43:36 PM ******/
SET ANSI_NULLS ON
GO
SET QUOTED_IDENTIFIER ON
GO
CREATE TABLE [dbo].[QBO_SalesReceipt_Lines](
	[Amount] [decimal](30, 10) NULL,
	[Description] [varchar](255) NULL,
	[DetailType] [varchar](255) NULL,
	[Id] [decimal](30, 10) NULL,
	[LineNum] [decimal](30, 10) NULL,
	[SalesItemLineDetail.ClassRef.name] [varchar](255) NULL,
	[SalesItemLineDetail.ClassRef.value] [decimal](30, 10) NULL,
	[SalesItemLineDetail.ItemRef.name] [varchar](255) NULL,
	[AccountLevel1] [varchar](255) NULL,
	[AccountLevel2] [varchar](255) NULL,
	[AccountLevel3] [varchar](255) NULL,
	[AccountLevel4] [varchar](255) NULL,
	[AccountLevel5] [varchar](255) NULL,
	[SalesItemLineDetail.ItemRef.value] [decimal](30, 10) NULL,
	[SalesItemLineDetail.Qty] [decimal](30, 10) NULL,
	[SalesItemLineDetail.TaxCodeRef.value] [varchar](255) NULL,
	[SalesItemLineDetail.UnitPrice] [decimal](30, 10) NULL,
	[ApplyTaxAfterDiscount] [varchar](255) NULL,
	[Balance] [decimal](30, 10) NULL,
	[BillAddr.City] [varchar](255) NULL,
	[BillAddr.Country] [varchar](255) NULL,
	[BillAddr.CountrySubDivisionCode] [varchar](255) NULL,
	[BillAddr.Id] [decimal](30, 10) NULL,
	[BillAddr.Lat] [decimal](30, 10) NULL,
	[BillAddr.Line1] [varchar](255) NULL,
	[BillAddr.Line2] [varchar](255) NULL,
	[BillAddr.Long] [decimal](30, 10) NULL,
	[BillAddr.PostalCode] [decimal](30, 10) NULL,
	[BillEmail.Address] [varchar](255) NULL,
	[CreditCardPayment.CreditChargeInfo.Amount] [decimal](30, 10) NULL,
	[CreditCardPayment.CreditChargeInfo.CcExpiryMonth] [decimal](30, 10) NULL,
	[CreditCardPayment.CreditChargeInfo.CcExpiryYear] [decimal](30, 10) NULL,
	[CreditCardPayment.CreditChargeInfo.NameOnAcct] [varchar](255) NULL,
	[CreditCardPayment.CreditChargeInfo.Number] [varchar](255) NULL,
	[CreditCardPayment.CreditChargeInfo.PostalCode] [decimal](30, 10) NULL,
	[CreditCardPayment.CreditChargeInfo.ProcessPayment] [varchar](255) NULL,
	[CreditCardPayment.CreditChargeResponse.AuthCode] [decimal](30, 10) NULL,
	[CreditCardPayment.CreditChargeResponse.AvsStreet] [varchar](255) NULL,
	[CreditCardPayment.CreditChargeResponse.AvsZip] [varchar](255) NULL,
	[CreditCardPayment.CreditChargeResponse.CardSecurit] [varchar](255) NULL,
	[CreditCardPayment.CreditChargeResponse.CCTransId] [varchar](255) NULL,
	[CreditCardPayment.CreditChargeResponse.Status] [varchar](255) NULL,
	[CreditCardPayment.CreditChargeResponse.TxnAuthoriz] [datetime] NULL,
	[CurrencyRef.name] [varchar](255) NULL,
	[CurrencyRef.value] [varchar](255) NULL,
	[CustomerMemo.value] [varchar](255) NULL,
	[CustomerRef.name] [varchar](255) NULL,
	[CustomerRef.value] [decimal](30, 10) NULL,
	[DeliveryInfo.DeliveryTime] [datetime] NULL,
	[DeliveryInfo.DeliveryType] [varchar](255) NULL,
	[DepositToAccountRef.name] [varchar](255) NULL,
	[DepositToAccountRef.value] [decimal](30, 10) NULL,
	[DocNumber] [decimal](30, 10) NULL,
	[domain] [varchar](255) NULL,
	[EmailStatus] [varchar](255) NULL,
	[ExchangeRate] [decimal](30, 10) NULL,
	[HomeTotalAmt] [decimal](30, 10) NULL,
	[Id_1] [decimal](30, 10) NULL,
	[MetaData.CreateTime] [datetime] NULL,
	[MetaData.LastUpdatedTime] [datetime] NULL,
	[PaymentMethodRef.name] [varchar](255) NULL,
	[PaymentMethodRef.value] [decimal](30, 10) NULL,
	[PaymentRefNum] [decimal](30, 10) NULL,
	[PrintStatus] [varchar](255) NULL,
	[PrivateNote] [varchar](255) NULL,
	[ShipAddr.City] [varchar](255) NULL,
	[ShipAddr.Country] [varchar](255) NULL,
	[ShipAddr.CountrySubDivisionCode] [varchar](255) NULL,
	[ShipAddr.Id] [decimal](30, 10) NULL,
	[ShipAddr.Lat] [decimal](30, 10) NULL,
	[ShipAddr.Line1] [varchar](255) NULL,
	[ShipAddr.Line2] [varchar](255) NULL,
	[ShipAddr.Long] [decimal](30, 10) NULL,
	[ShipAddr.PostalCode] [decimal](30, 10) NULL,
	[sparse] [varchar](255) NULL,
	[SyncToken] [decimal](30, 10) NULL,
	[TotalAmt] [decimal](30, 10) NULL,
	[TxnDate] [datetime] NULL,
	[TxnSource] [varchar](255) NULL
) ON [PRIMARY]
GO
/****** Object:  Table [dbo].[QBO_VendorCredit]    Script Date: 7/6/2020 1:43:36 PM ******/
SET ANSI_NULLS ON
GO
SET QUOTED_IDENTIFIER ON
GO
CREATE TABLE [dbo].[QBO_VendorCredit](
	[APAccountRef.name] [varchar](255) NULL,
	[APAccountRef.value] [decimal](30, 10) NULL,
	[CurrencyRef.name] [varchar](255) NULL,
	[CurrencyRef.value] [varchar](255) NULL,
	[domain] [varchar](255) NULL,
	[ExchangeRate] [decimal](30, 10) NULL,
	[Id] [decimal](30, 10) NULL,
	[MetaData.CreateTime] [datetime] NULL,
	[MetaData.LastUpdatedTime] [datetime] NULL,
	[PrivateNote] [varchar](255) NULL,
	[sparse] [varchar](255) NULL,
	[SyncToken] [decimal](30, 10) NULL,
	[TotalAmt] [decimal](30, 10) NULL,
	[TxnDate] [datetime] NULL,
	[VendorRef.name] [varchar](255) NULL,
	[VendorRef.value] [decimal](30, 10) NULL
) ON [PRIMARY]
GO
/****** Object:  Table [dbo].[QBO_VendorCredit_Lines]    Script Date: 7/6/2020 1:43:36 PM ******/
SET ANSI_NULLS ON
GO
SET QUOTED_IDENTIFIER ON
GO
CREATE TABLE [dbo].[QBO_VendorCredit_Lines](
	[APAccountRef.name] [varchar](255) NULL,
	[APAccountRef.value] [decimal](30, 10) NULL,
	[CurrencyRef.name] [varchar](255) NULL,
	[CurrencyRef.value] [varchar](255) NULL,
	[domain] [varchar](255) NULL,
	[ExchangeRate] [decimal](30, 10) NULL,
	[Id] [decimal](30, 10) NULL,
	[MetaData.CreateTime] [datetime] NULL,
	[MetaData.LastUpdatedTime] [datetime] NULL,
	[PrivateNote] [varchar](255) NULL,
	[sparse] [varchar](255) NULL,
	[SyncToken] [decimal](30, 10) NULL,
	[TotalAmt] [decimal](30, 10) NULL,
	[TxnDate] [datetime] NULL,
	[VendorRef.name] [varchar](255) NULL,
	[VendorRef.value] [decimal](30, 10) NULL,
	[AccountBasedExpenseLineDetail.AccountRef.name] [varchar](255) NULL,
	[AccountLevel1] [varchar](255) NULL,
	[AccountLevel2] [varchar](255) NULL,
	[AccountLevel3] [varchar](255) NULL,
	[AccountLevel4] [varchar](255) NULL,
	[AccountLevel5] [varchar](255) NULL,
	[AccountBasedExpenseLineDetail.AccountRef.value] [decimal](30, 10) NULL,
	[AccountBasedExpenseLineDetail.BillableStatus] [varchar](255) NULL,
	[AccountBasedExpenseLineDetail.TaxCodeRef.value] [varchar](255) NULL,
	[Amount] [decimal](30, 10) NULL,
	[Description] [varchar](255) NULL,
	[DetailType] [varchar](255) NULL,
	[Id_1] [decimal](30, 10) NULL,
	[LineNum] [decimal](30, 10) NULL,
	[VendorCreditRef.value] [decimal](30, 10) NULL
) ON [PRIMARY]
GO