SQL Server Database Schema Create for QuickBooks Online

59 min read
LetSync needs some extra tables in order to operate properly. These tables are used to run tasks properly, to record errors that may occur while running a task, and to keep your database up-to-date for future new fields.
You cannot delete any column of any table because LetSync will throw an error on that table.
history: this table will record the date that any operation (populate, refresh, or update from/to QuickBooks) was done. This task is crucial for “Refresh From QuickBooks” and “Update and Refresh tasks”
lsologging: this table will record all the operations that happen when running a task, including the errors as well
error_table: this table will record the errors that happen when running a task if it is any
Make the table collation to utf8_general_ci. This will support special characters like quotation marks
CREATE TABLE [dbo].[account](
	[Id] [varchar](255) NULL,
	[SyncToken] [varchar](4095) NULL,
	[CreateTime] [datetime] NULL,
	[LastUpdatedTime] [datetime] NULL,
	[Domain] [varchar](4095) NULL,
	[Name] [varchar](4095) NULL,
	[AcctNum] [varchar](4095) NULL,
	[FullyQualifiedName] [varchar](4095) NULL,
	[AccountAlias] [varchar](4095) NULL,
	[Active] [bit] NULL,
	[SubAccount] [bit] NULL,
	[ParentRef_Id] [varchar](4095) NULL,
	[ParentRef_Name] [varchar](4095) NULL,
	[CurrencyRef_Id] [varchar](4095) NULL,
	[CurrencyRef_Name] [varchar](4095) NULL,
	[Description] [varchar](4095) NULL,
	[Classification] [varchar](4095) NULL,
	[ClassificationSpecified] [bit] NULL,
	[TxnLocationType] [varchar](4095) NULL,
	[AccountType] [varchar](4095) NULL,
	[CurrentBalance] [decimal](15, 2) NULL,
	[CurrentBalanceSpecified] [bit] NULL,
	[CurrentBalanceWithSubAccounts] [decimal](15, 2) NULL,
	[CurrentBalanceWithSubAccountsSpecified] [bit] NULL,
	[TaxCodeRef_Id] [varchar](4095) NULL,
	[TaxCodeRef_Name] [varchar](4095) NULL,
	[TaxAccount] [bit] NULL,
	[TaxAccountSpecified] [bit] NULL,
	[AccountSubType] [varchar](4095) NULL,
	[SubAccountSpecified] [bit] NULL,
	[JournalCodeRef_Id] [varchar](4095) NULL,
	[JournalCodeRef_Name] [varchar](4095) NULL,
	[AccountTypeSpecified] [bit] NULL,
	[ActiveSpecified] [bit] NULL,
	[AcctNumExtn] [varchar](4095) NULL,
	[BankNum] [varchar](4095) NULL,
	[FIName] [varchar](4095) NULL,
	[OpeningBalance] [decimal](15, 2) NULL,
	[OpeningBalanceDate] [datetime] NULL,
	[OpeningBalanceDateSpecified] [bit] NULL,
	[OpeningBalanceSpecified] [bit] NULL,
	[OnlineBankingEnabledSpecified] [bit] NULL,
	[OnlineBankingEnabled] [bit] NULL,
	[UserData] [varchar](4095) NULL,
	[Operation] [varchar](4095) NULL,
	[sparse] [bit] NULL,
	[LSData] [varchar](4095) NULL
) ON [PRIMARY]
GO



CREATE TABLE [dbo].[bill](
	[Id] [varchar](255) NULL,
	[SyncToken] [varchar](4095) NULL,
	[CreateTime] [datetime] NULL,
	[LastUpdatedTime] [datetime] NULL,
	[Domain] [varchar](4095) NULL,
	[Name] [varchar](4095) NULL,
	[TxnDate] [datetime] NULL,
	[TransactionLocationType] [varchar](4095) NULL,
	[ExchangeRateSpecified] [bit] NULL,
	[DocNumber] [varchar](4095) NULL,
	[TxnDateSpecified] [bit] NULL,
	[DepartmentRef_Id] [varchar](4095) NULL,
	[DepartmentRef_Name] [varchar](4095) NULL,
	[ExchangeRate] [decimal](15, 2) NULL,
	[PrivateNote] [varchar](4095) NULL,
	[TaxFormNum] [varchar](4095) NULL,
	[TxnStatus] [varchar](4095) NULL,
	[TxnTaxDetail] [varchar](4095) NULL,
	[TxnSource] [varchar](4095) NULL,
	[TaxFormType] [varchar](4095) NULL,
	[VendorRef_Id] [varchar](4095) NULL,
	[VendorRef_Name] [varchar](4095) NULL,
	[CurrencyRef_Id] [varchar](4095) NULL,
	[CurrencyRef_Name] [varchar](4095) NULL,
	[APAccountRef_Id] [varchar](4095) NULL,
	[APAccountRef_Name] [varchar](4095) NULL,
	[TotalAmt] [decimal](15, 2) NULL,
	[TotalAmtSpecified] [bit] NULL,
	[BillEmailAddress] [varchar](4095) NULL,
	[ReplyEmailAddress] [varchar](4095) NULL,
	[Memo] [varchar](4095) NULL,
	[GlobalTaxCalculation] [varchar](4095) NULL,
	[GlobalTaxCalculationSpecified] [bit] NULL,
	[PayerRef_Id] [varchar](4095) NULL,
	[PayerRef_Name] [varchar](4095) NULL,
	[SalesTermRef_Id] [varchar](4095) NULL,
	[SalesTermRef_Name] [varchar](4095) NULL,
	[DueDate] [datetime] NULL,
	[DueDateSpecified] [bit] NULL,
	[Balance] [decimal](15, 2) NULL,
	[BalanceSpecified] [bit] NULL,
	[HomeBalance] [decimal](15, 2) NULL,
	[HomeBalanceSpecified] [bit] NULL,
	[LessCIS] [decimal](15, 2) NULL,
	[LessCISSpecified] [bit] NULL,
	[IncludeInAnnualTPAR] [bit] NULL,
	[RecurDataRef_Id] [varchar](4095) NULL,
	[RecurDataRef_Name] [varchar](4095) NULL,
	[ShipAddr_Id] [varchar](4095) NULL,
	[ShipAddr_Line1] [varchar](4095) NULL,
	[ShipAddr_Line2] [varchar](4095) NULL,
	[ShipAddr_Line3] [varchar](4095) NULL,
	[ShipAddr_Line4] [varchar](4095) NULL,
	[ShipAddr_Line5] [varchar](4095) NULL,
	[ShipAddr_City] [varchar](4095) NULL,
	[ShipAddr_Country] [varchar](4095) NULL,
	[ShipAddr_PostalCode] [varchar](4095) NULL,
	[ShipAddr_CountryCode] [varchar](4095) NULL,
	[ShipAddr_CountrySubDivisionCode] [varchar](4095) NULL,
	[ShipAddr_PostalCodeSuffix] [varchar](4095) NULL,
	[ShipAddr_Long] [varchar](4095) NULL,
	[ShipAddr_Lat] [varchar](4095) NULL,
	[ShipAddr_Note] [varchar](4095) NULL,
	[ShipAddr_Tag] [varchar](4095) NULL,
	[RemitToAddr_Id] [varchar](4095) NULL,
	[RemitToAddr_Line1] [varchar](4095) NULL,
	[RemitToAddr_Line2] [varchar](4095) NULL,
	[RemitToAddr_Line3] [varchar](4095) NULL,
	[RemitToAddr_Line4] [varchar](4095) NULL,
	[RemitToAddr_Line5] [varchar](4095) NULL,
	[RemitToAddr_City] [varchar](4095) NULL,
	[RemitToAddr_Country] [varchar](4095) NULL,
	[RemitToAddr_PostalCode] [varchar](4095) NULL,
	[RemitToAddr_CountryCode] [varchar](4095) NULL,
	[RemitToAddr_CountrySubDivisionCode] [varchar](4095) NULL,
	[RemitToAddr_PostalCodeSuffix] [varchar](4095) NULL,
	[RemitToAddr_Long] [varchar](4095) NULL,
	[RemitToAddr_Lat] [varchar](4095) NULL,
	[RemitToAddr_Note] [varchar](4095) NULL,
	[RemitToAddr_Tag] [varchar](4095) NULL,
	[UserData] [varchar](4095) NULL,
	[Operation] [varchar](4095) NULL,
	[sparse] [bit] NULL,
	[LSData] [varchar](4095) NULL
) ON [PRIMARY]
GO


CREATE TABLE [dbo].[billlinedetail](
	[Id] [varchar](255) NULL,
	[LineNum] [varchar](4095) NULL,
	[Description] [varchar](4095) NULL,
	[Amount] [decimal](15, 2) NULL,
	[AmountSpecified] [bit] NULL,
	[DetailType] [varchar](4095) NULL,
	[DetailTypeSpecified] [bit] NULL,
	[ItemRef_Id] [varchar](4095) NULL,
	[ItemRef_Name] [varchar](4095) NULL,
	[ClassRef_Id] [varchar](4095) NULL,
	[ClassRef_Name] [varchar](4095) NULL,
	[PriceLevelRef_Id] [varchar](4095) NULL,
	[PriceLevelRef_Name] [varchar](4095) NULL,
	[RatePercent] [decimal](15, 2) NULL,
	[UnitPrice] [decimal](15, 2) NULL,
	[Qty] [decimal](15, 2) NULL,
	[QtySpecified] [bit] NULL,
	[UOMSetRef_Unit] [varchar](4095) NULL,
	[UOMSetRef_Id] [varchar](4095) NULL,
	[UOMSetRef_Name] [varchar](4095) NULL,
	[ItemAccountRef_Id] [varchar](4095) NULL,
	[ItemAccountRef_Name] [varchar](4095) NULL,
	[InventorySiteRef_Id] [varchar](4095) NULL,
	[InventorySiteRef_Name] [varchar](4095) NULL,
	[TaxCodeRef_Id] [varchar](4095) NULL,
	[TaxCodeRef_Name] [varchar](4095) NULL,
	[TaxClassificationRef_Id] [varchar](4095) NULL,
	[TaxClassificationRef_Name] [varchar](4095) NULL,
	[CustomerRef_Id] [varchar](4095) NULL,
	[CustomerRef_Name] [varchar](4095) NULL,
	[BillableStatus] [varchar](4095) NULL,
	[BillableStatusSpecified] [bit] NULL,
	[TaxInclusiveAmt] [decimal](15, 2) NULL,
	[TaxInclusiveAmtSpecified] [bit] NULL,
	[AccountRef_Id] [varchar](4095) NULL,
	[AccountRef_Name] [varchar](4095) NULL,
	[TaxAmount] [decimal](15, 2) NULL,
	[TaxAmountSpecified] [bit] NULL,
	[MarkupPercentBased] [bit] NULL,
	[MarkupPercentBasedSpecified] [bit] NULL,
	[MarkupValue] [decimal](15, 2) NULL,
	[MarkupValueSpecified] [bit] NULL,
	[MarkupPercent] [decimal](15, 2) NULL,
	[MarkupPercentSpecified] [bit] NULL,
	[MarkupPriceLevelRef_Id] [varchar](4095) NULL,
	[MarkupPriceLevelRef_Name] [varchar](4095) NULL,
	[MarkupIncomeAccountRef_Id] [varchar](4095) NULL,
	[MarkupIncomeAccountRef_Name] [varchar](4095) NULL,
	[CustomField1] [varchar](4095) NULL,
	[CustomField2] [varchar](4095) NULL,
	[CustomField3] [varchar](4095) NULL,
	[CustomField4] [varchar](4095) NULL,
	[CustomField5] [varchar](4095) NULL,
	[CustomField6] [varchar](4095) NULL,
	[CustomField7] [varchar](4095) NULL,
	[CustomField8] [varchar](4095) NULL,
	[CustomField9] [varchar](4095) NULL,
	[CustomField10] [varchar](4095) NULL,
	[SeqNum] [int] NULL,
	[PARENT_GroupID] [varchar](255) NULL,
	[PARENT_ID] [varchar](255) NULL
) ON [PRIMARY]
GO



CREATE TABLE [dbo].[billpayment](
	[Id] [varchar](255) NULL,
	[SyncToken] [varchar](4095) NULL,
	[CreateTime] [datetime] NULL,
	[LastUpdatedTime] [datetime] NULL,
	[Name] [varchar](4095) NULL,
	[TransactionLocationType] [varchar](4095) NULL,
	[ExchangeRateSpecified] [bit] NULL,
	[DocNumber] [varchar](4095) NULL,
	[TxnDate] [datetime] NULL,
	[TxnDateSpecified] [bit] NULL,
	[DepartmentRef_Id] [varchar](4095) NULL,
	[DepartmentRef_Name] [varchar](4095) NULL,
	[CurrencyRef_Id] [varchar](4095) NULL,
	[CurrencyRef_Name] [varchar](4095) NULL,
	[ExchangeRate] [decimal](15, 2) NULL,
	[PrivateNote] [varchar](4095) NULL,
	[TaxFormNum] [varchar](4095) NULL,
	[TxnStatus] [varchar](4095) NULL,
	[TxnSource] [varchar](4095) NULL,
	[TaxFormType] [varchar](4095) NULL,
	[TotalAmtSpecified] [bit] NULL,
	[TotalAmt] [decimal](15, 2) NULL,
	[PayTypeSpecified] [bit] NULL,
	[PayType] [varchar](4095) NULL,
	[APAccountRef_Id] [varchar](4095) NULL,
	[APAccountRef_Name] [varchar](4095) NULL,
	[VendorRef_Id] [varchar](4095) NULL,
	[VendorRef_Name] [varchar](4095) NULL,
	[ProcessBillPayment] [bit] NULL,
	[BankAccountRef_Id] [varchar](4095) NULL,
	[BankAccountRef_Name] [varchar](4095) NULL,
	[PrintStatus] [varchar](4095) NULL,
	[PrintStatusSpecified] [bit] NULL,
	[CheckNum] [varchar](4095) NULL,
	[CheckStatus] [varchar](4095) NULL,
	[CheckNameOnAcct] [varchar](4095) NULL,
	[AcctNum] [varchar](4095) NULL,
	[BankName] [varchar](4095) NULL,
	[PayeeAddr_Id] [varchar](4095) NULL,
	[PayeeAddr_Line1] [varchar](4095) NULL,
	[PayeeAddr_Line2] [varchar](4095) NULL,
	[PayeeAddr_Line3] [varchar](4095) NULL,
	[PayeeAddr_Line4] [varchar](4095) NULL,
	[PayeeAddr_Line5] [varchar](4095) NULL,
	[PayeeAddr_City] [varchar](4095) NULL,
	[PayeeAddr_Country] [varchar](4095) NULL,
	[PayeeAddr_PostalCode] [varchar](4095) NULL,
	[PayeeAddr_CountryCode] [varchar](4095) NULL,
	[PayeeAddr_CountrySubDivisionCode] [varchar](4095) NULL,
	[PayeeAddr_PostalCodeSuffix] [varchar](4095) NULL,
	[PayeeAddr_Long] [varchar](4095) NULL,
	[PayeeAddr_Lat] [varchar](4095) NULL,
	[PayeeAddr_Note] [varchar](4095) NULL,
	[PayeeAddr_Tag] [varchar](4095) NULL,
	[TotalTaxSpecified] [bit] NULL,
	[TotalTax] [decimal](15, 2) NULL,
	[TxnTaxCodeRef_Id] [varchar](4095) NULL,
	[TxnTaxCodeRef_Name] [varchar](4095) NULL,
	[DefaultTaxCodeRef_Id] [varchar](4095) NULL,
	[DefaultTaxCodeRef_Name] [varchar](4095) NULL,
	[CCAccountRef_Id] [varchar](4095) NULL,
	[CCAccountRef_Name] [varchar](4095) NULL,
	[NameOnAcct] [varchar](4095) NULL,
	[Number] [varchar](4095) NULL,
	[Amount] [decimal](15, 2) NULL,
	[AmountSpecified] [bit] NULL,
	[ProcessPayment] [bit] NULL,
	[Type] [varchar](4095) NULL,
	[PostalCode] [varchar](4095) NULL,
	[CcExpiryMonth] [int] NULL,
	[CcExpiryMonthSpecified] [bit] NULL,
	[CcExpiryYear] [int] NULL,
	[CcExpiryYearSpecified] [bit] NULL,
	[BillAddrStreet] [varchar](4095) NULL,
	[CommercialCardCode] [varchar](4095) NULL,
	[ProcessPaymentSpecified] [bit] NULL,
	[CCTxnMode] [varchar](4095) NULL,
	[CCTxnModeSpecified] [bit] NULL,
	[CCTxnType] [varchar](4095) NULL,
	[CCTxnTypeSpecified] [bit] NULL,
	[PrevCCTransId] [varchar](4095) NULL,
	[TxnAuthorizationTime] [datetime] NULL,
	[TxnAuthorizationTimeSpecified] [bit] NULL,
	[TxnAuthorizationStamp] [int] NULL,
	[TxnAuthorizationStampSpecified] [bit] NULL,
	[PaymentGroupingCodeSpecified] [bit] NULL,
	[PaymentGroupingCode] [int] NULL,
	[ReconBatchId] [varchar](4095) NULL,
	[SecurityCode] [varchar](4095) NULL,
	[AvsZipSpecified] [bit] NULL,
	[AvsZip] [varchar](4095) NULL,
	[AvsStreetSpecified] [bit] NULL,
	[AvsStreet] [varchar](4095) NULL,
	[AuthCode] [varchar](4095) NULL,
	[CardSecurityCodeMatch] [varchar](4095) NULL,
	[CardSecurityCodeMatchSpecified] [bit] NULL,
	[MerchantAcctNum] [varchar](4095) NULL,
	[ResultMsg] [varchar](4095) NULL,
	[ResultCodeSpecified] [bit] NULL,
	[ResultCode] [int] NULL,
	[StatusSpecified] [bit] NULL,
	[Status] [varchar](4095) NULL,
	[CCTransId] [varchar](4095) NULL,
	[CCProcessor] [varchar](4095) NULL,
	[ClientTransID] [varchar](4095) NULL,
	[UserData] [varchar](4095) NULL,
	[Operation] [varchar](4095) NULL,
	[sparse] [bit] NULL,
	[LSData] [varchar](4095) NULL
) ON [PRIMARY]
GO


CREATE TABLE [dbo].[billpaymentlinedetail](
	[Id] [varchar](255) NULL,
	[LineNum] [varchar](4095) NULL,
	[Description] [varchar](4095) NULL,
	[Amount] [decimal](15, 2) NULL,
	[AmountSpecified] [bit] NULL,
	[CustomField1] [varchar](4095) NULL,
	[CustomField2] [varchar](4095) NULL,
	[CustomField3] [varchar](4095) NULL,
	[CustomField4] [varchar](4095) NULL,
	[CustomField5] [varchar](4095) NULL,
	[CustomField6] [varchar](4095) NULL,
	[CustomField7] [varchar](4095) NULL,
	[CustomField8] [varchar](4095) NULL,
	[CustomField9] [varchar](4095) NULL,
	[CustomField10] [varchar](4095) NULL,
	[SeqNum] [int] NULL,
	[PARENT_GroupID] [varchar](255) NULL,
	[PARENT_ID] [varchar](255) NULL
) ON [PRIMARY]
GO



CREATE TABLE [dbo].[class](
	[Id] [varchar](255) NULL,
	[SyncToken] [varchar](4095) NULL,
	[CreateTime] [datetime] NULL,
	[LastUpdatedTime] [datetime] NULL,
	[Name] [varchar](4095) NULL,
	[FullyQualifiedName] [varchar](4095) NULL,
	[ParentRef_Id] [varchar](4095) NULL,
	[ParentRef_Name] [varchar](4095) NULL,
	[SubClassSpecified] [bit] NULL,
	[SubClass] [bit] NULL,
	[Active] [bit] NULL,
	[ActiveSpecified] [bit] NULL,
	[UserData] [varchar](4095) NULL,
	[Operation] [varchar](4095) NULL,
	[sparse] [bit] NULL,
	[LSData] [varchar](4095) NULL
) ON [PRIMARY]
GO



CREATE TABLE [dbo].[company](
	[Id] [varchar](255) NULL,
	[SyncToken] [varchar](4095) NULL,
	[CreateTime] [datetime] NULL,
	[LastUpdatedTime] [datetime] NULL,
	[Domain] [varchar](4095) NULL,
	[LegalAddr_Id] [varchar](4095) NULL,
	[LegalAddr_City] [varchar](4095) NULL,
	[LegalAddr_Country] [varchar](4095) NULL,
	[LegalAddr_Line1] [varchar](4095) NULL,
	[LegalAddr_PostalCode] [varchar](4095) NULL,
	[LegalAddr_CountryCode] [varchar](4095) NULL,
	[SupportedLanguages] [varchar](4095) NULL,
	[CompanyName] [varchar](4095) NULL,
	[Country] [varchar](4095) NULL,
	[CompanyAddr_Id] [varchar](4095) NULL,
	[CompanyAddr_City] [varchar](4095) NULL,
	[CompanyAddr_Country] [varchar](4095) NULL,
	[CompanyAddr_Line1] [varchar](4095) NULL,
	[CompanyAddr_PostalCode] [varchar](4095) NULL,
	[CompanyAddr_CountryCode] [varchar](4095) NULL,
	[WebAddrURI] [varchar](4095) NULL,
	[FiscalYearStartMonth] [varchar](4095) NULL,
	[CommunicationAddr_Id] [varchar](4095) NULL,
	[CommunicationAddr_City] [varchar](4095) NULL,
	[CommunicationAddr_Country] [varchar](4095) NULL,
	[CommunicationAddr_Line1] [varchar](4095) NULL,
	[CommunicationAddr_PostalCode] [varchar](4095) NULL,
	[CommunicationAddr_CountryCode] [varchar](4095) NULL,
	[CommunicationEmailAddress] [varchar](4095) NULL,
	[PrimaryPhone] [varchar](4095) NULL,
	[LegalName] [varchar](4095) NULL,
	[CompanyStartDate] [varchar](4095) NULL,
	[Email] [varchar](4095) NULL,
	[NameValue] [varchar](4095) NULL,
	[UserData] [varchar](4095) NULL,
	[Operation] [varchar](4095) NULL,
	[sparse] [bit] NULL,
	[LSData] [varchar](4095) NULL
) ON [PRIMARY]
GO



CREATE TABLE [dbo].[companycurrency](
	[Id] [varchar](255) NULL,
	[SyncToken] [varchar](4095) NULL,
	[CreateTime] [datetime] NULL,
	[LastUpdatedTime] [datetime] NULL,
	[Name] [varchar](4095) NULL,
	[Code] [varchar](4095) NULL,
	[Active] [bit] NULL,
	[ActiveSpecified] [bit] NULL,
	[CustomField1] [varchar](4095) NULL,
	[CustomField2] [varchar](4095) NULL,
	[CustomField3] [varchar](4095) NULL,
	[CustomField4] [varchar](4095) NULL,
	[CustomField5] [varchar](4095) NULL,
	[CustomField6] [varchar](4095) NULL,
	[CustomField7] [varchar](4095) NULL,
	[CustomField8] [varchar](4095) NULL,
	[CustomField9] [varchar](4095) NULL,
	[CustomField10] [varchar](4095) NULL,
	[UserData] [varchar](4095) NULL,
	[Operation] [varchar](4095) NULL,
	[sparse] [bit] NULL,
	[LSData] [varchar](4095) NULL
) ON [PRIMARY]
GO



CREATE TABLE [dbo].[companypreferences](
	[Id] [varchar](255) NULL,
	[SyncToken] [varchar](4095) NULL,
	[CreateTime] [datetime] NULL,
	[LastUpdatedTime] [datetime] NULL,
	[InvoiceMessage] [varchar](4095) NULL,
	[InvoiceSubject] [varchar](4095) NULL,
	[EstimateMessage] [varchar](4095) NULL,
	[EstimateSubject] [varchar](4095) NULL,
	[SalesReceiptMessage] [varchar](4095) NULL,
	[SalesReceiptSubject] [varchar](4095) NULL,
	[StatementMessage] [varchar](4095) NULL,
	[StatementSubject] [varchar](4095) NULL,
	[QuantityWithPriceAndRate] [bit] NULL,
	[ForPurchase] [bit] NULL,
	[QuantityOnHand] [bit] NULL,
	[ForSales] [bit] NULL,
	[ReportBasis] [varchar](4095) NULL,
	[CalcAgingReportFromTxnDate] [bit] NULL,
	[FirstMonthOfFiscalYear] [varchar](4095) NULL,
	[UseAccountNumbers] [bit] NULL,
	[TaxYearMonth] [varchar](4095) NULL,
	[ClassTrackingPerTxn] [bit] NULL,
	[TrackDepartments] [bit] NULL,
	[TaxForm] [varchar](4095) NULL,
	[CustomerTerminology] [varchar](4095) NULL,
	[BookCloseDate] [datetime] NULL,
	[DepartmentTerminology] [varchar](4095) NULL,
	[ClassTrackingPerTxnLine] [bit] NULL,
	[ETransactionPaymentEnabled] [bit] NULL,
	[CustomTxnNumbers] [bit] NULL,
	[AllowShipping] [bit] NULL,
	[AllowServiceDate] [bit] NULL,
	[ETransactionEnabledStatus] [varchar](4095) NULL,
	[DefaultCustomerMessage] [varchar](4095) NULL,
	[EmailCopyToCompany] [bit] NULL,
	[AllowEstimates] [bit] NULL,
	[DefaultTerms] [varchar](4095) NULL,
	[AllowDiscount] [bit] NULL,
	[DefaultDiscountAccount] [varchar](4095) NULL,
	[AllowDeposit] [bit] NULL,
	[AutoApplyPayments] [bit] NULL,
	[IPNSupportEnabled] [bit] NULL,
	[AutoApplyCredit] [bit] NULL,
	[UsingSalesTax] [bit] NULL,
	[WorkWeekStartDate] [varchar](4095) NULL,
	[MarkTimeEntriesBillable] [bit] NULL,
	[ShowBillRateToAll] [bit] NULL,
	[UseServices] [bit] NULL,
	[BillCustomers] [bit] NULL,
	[HomeCurrency] [varchar](4095) NULL,
	[MultiCurrencyEnabled] [bit] NULL,
	[UserData] [varchar](4095) NULL,
	[Operation] [varchar](4095) NULL,
	[sparse] [bit] NULL,
	[LSData] [varchar](4095) NULL
) ON [PRIMARY]
GO



CREATE TABLE [dbo].[contactinfo](
	[TypeContactValue] [varchar](4095) NULL,
	[TypeContactInfo] [varchar](4095) NULL,
	[TypeSpecified] [varchar](4095) NULL,
	[SeqNum] [int] NULL,
	[ParentTableType] [varchar](255) NULL,
	[PARENT_ID] [varchar](255) NULL
) ON [PRIMARY]
GO



CREATE TABLE [dbo].[creditmemo](
	[Id] [varchar](255) NULL,
	[SyncToken] [varchar](4095) NULL,
	[CreateTime] [datetime] NULL,
	[LastUpdatedTime] [datetime] NULL,
	[Name] [varchar](4095) NULL,
	[PrivateNote] [varchar](4095) NULL,
	[ExchangeRate] [decimal](15, 2) NULL,
	[CurrencyRef_Id] [varchar](4095) NULL,
	[CurrencyRef_Name] [varchar](4095) NULL,
	[DepartmentRef_Id] [varchar](4095) NULL,
	[DepartmentRef_Name] [varchar](4095) NULL,
	[TxnDate] [datetime] NULL,
	[TxnDateSpecified] [bit] NULL,
	[DocNumber] [varchar](4095) NULL,
	[TransactionLocationType] [varchar](4095) NULL,
	[PrintStatus] [varchar](4095) NULL,
	[PrintStatusSpecified] [bit] NULL,
	[BillEmailAddress] [varchar](4095) NULL,
	[BillEmailCcAddress] [varchar](4095) NULL,
	[BillEmailBccAddress] [varchar](4095) NULL,
	[EmailStatusSpecified] [bit] NULL,
	[EmailStatus] [varchar](4095) NULL,
	[Balance] [decimal](15, 2) NULL,
	[BalanceSpecified] [bit] NULL,
	[HomeBalance] [decimal](15, 2) NULL,
	[HomeBalanceSpecified] [bit] NULL,
	[PaymentMethodRef_Id] [varchar](4095) NULL,
	[PaymentMethodRef_Name] [varchar](4095) NULL,
	[DeliveryType] [varchar](4095) NULL,
	[DeliveryTime] [datetime] NULL,
	[ApplyTaxAfterDiscountSpecified] [bit] NULL,
	[ApplyTaxAfterDiscount] [bit] NULL,
	[CustomerRef_Id] [varchar](4095) NULL,
	[CustomerRef_Name] [varchar](4095) NULL,
	[CustomerMemo] [varchar](4095) NULL,
	[ClassRef_Id] [varchar](4095) NULL,
	[ClassRef_Name] [varchar](4095) NULL,
	[SalesTermRef_Id] [varchar](4095) NULL,
	[SalesTermRef_Name] [varchar](4095) NULL,
	[GlobalTaxCalculation] [varchar](4095) NULL,
	[GlobalTaxCalculationSpecified] [bit] NULL,
	[TotalAmt] [decimal](15, 2) NULL,
	[HomeTotalAmt] [decimal](15, 2) NULL,
	[HomeTotalAmtSpecified] [bit] NULL,
	[TotalAmtSpecified] [bit] NULL,
	[TaxExemptionRef_Id] [varchar](4095) NULL,
	[TaxExemptionRef_Name] [varchar](4095) NULL,
	[InvoiceRef_Id] [varchar](4095) NULL,
	[InvoiceRef_Name] [varchar](4095) NULL,
	[RecurDataRef_Id] [varchar](4095) NULL,
	[RecurDataRef_Name] [varchar](4095) NULL,
	[RemainingCreditSpecified] [bit] NULL,
	[RemainingCredit] [decimal](15, 2) NULL,
	[TotalTaxSpecified] [bit] NULL,
	[TotalTax] [decimal](15, 2) NULL,
	[TxnTaxCodeRef_Id] [varchar](4095) NULL,
	[TxnTaxCodeRef_Name] [varchar](4095) NULL,
	[DefaultTaxCodeRef_Id] [varchar](4095) NULL,
	[DefaultTaxCodeRef_Name] [varchar](4095) NULL,
	[BillAddr_Id] [varchar](4095) NULL,
	[BillAddr_Line1] [varchar](4095) NULL,
	[BillAddr_Line2] [varchar](4095) NULL,
	[BillAddr_Line3] [varchar](4095) NULL,
	[BillAddr_Line4] [varchar](4095) NULL,
	[BillAddr_Line5] [varchar](4095) NULL,
	[BillAddr_City] [varchar](4095) NULL,
	[BillAddr_Country] [varchar](4095) NULL,
	[BillAddr_PostalCode] [varchar](4095) NULL,
	[BillAddr_CountryCode] [varchar](4095) NULL,
	[BillAddr_CountrySubDivisionCode] [varchar](4095) NULL,
	[BillAddr_PostalCodeSuffix] [varchar](4095) NULL,
	[BillAddr_Long] [varchar](4095) NULL,
	[BillAddr_Lat] [varchar](4095) NULL,
	[BillAddr_Note] [varchar](4095) NULL,
	[BillAddr_Tag] [varchar](4095) NULL,
	[ShipAddr_Id] [varchar](4095) NULL,
	[ShipAddr_Line1] [varchar](4095) NULL,
	[ShipAddr_Line2] [varchar](4095) NULL,
	[ShipAddr_Line3] [varchar](4095) NULL,
	[ShipAddr_Line4] [varchar](4095) NULL,
	[ShipAddr_Line5] [varchar](4095) NULL,
	[ShipAddr_City] [varchar](4095) NULL,
	[ShipAddr_Country] [varchar](4095) NULL,
	[ShipAddr_PostalCode] [varchar](4095) NULL,
	[ShipAddr_CountryCode] [varchar](4095) NULL,
	[ShipAddr_CountrySubDivisionCode] [varchar](4095) NULL,
	[ShipAddr_PostalCodeSuffix] [varchar](4095) NULL,
	[ShipAddr_Long] [varchar](4095) NULL,
	[ShipAddr_Lat] [varchar](4095) NULL,
	[ShipAddr_Note] [varchar](4095) NULL,
	[ShipAddr_Tag] [varchar](4095) NULL,
	[CustomField1] [varchar](4095) NULL,
	[CustomField2] [varchar](4095) NULL,
	[CustomField3] [varchar](4095) NULL,
	[CustomField4] [varchar](4095) NULL,
	[CustomField5] [varchar](4095) NULL,
	[CustomField6] [varchar](4095) NULL,
	[CustomField7] [varchar](4095) NULL,
	[CustomField8] [varchar](4095) NULL,
	[CustomField9] [varchar](4095) NULL,
	[CustomField10] [varchar](4095) NULL,
	[UserData] [varchar](4095) NULL,
	[Operation] [varchar](4095) NULL,
	[sparse] [bit] NULL,
	[LSData] [varchar](4095) NULL
) ON [PRIMARY]
GO



CREATE TABLE [dbo].[creditmemolinedetail](
	[Id] [varchar](255) NULL,
	[LineNum] [varchar](4095) NULL,
	[Description] [varchar](4095) NULL,
	[Amount] [decimal](15, 2) NULL,
	[AmountSpecified] [bit] NULL,
	[DetailType] [varchar](4095) NULL,
	[DetailTypeSpecified] [bit] NULL,
	[PriceLevelRef_Id] [varchar](4095) NULL,
	[PriceLevelRef_Name] [varchar](4095) NULL,
	[RatePercent] [decimal](15, 2) NULL,
	[UnitPrice] [decimal](15, 2) NULL,
	[TaxInclusiveAmt] [decimal](15, 2) NULL,
	[TaxInclusiveAmtSpecified] [bit] NULL,
	[DiscountAmt] [decimal](15, 2) NULL,
	[DiscountAmtSpecified] [bit] NULL,
	[ServiceDate] [datetime] NULL,
	[ServiceDateSpecified] [bit] NULL,
	[DiscountRate] [decimal](15, 2) NULL,
	[DiscountRateSpecified] [bit] NULL,
	[TaxClassificationRef_Id] [varchar](4095) NULL,
	[TaxClassificationRef_Name] [varchar](4095) NULL,
	[ItemAccountRef_Id] [varchar](4095) NULL,
	[ItemAccountRef_Name] [varchar](4095) NULL,
	[InventorySiteRef_Id] [varchar](4095) NULL,
	[InventorySiteRef_Name] [varchar](4095) NULL,
	[TaxCodeRef_Id] [varchar](4095) NULL,
	[TaxCodeRef_Name] [varchar](4095) NULL,
	[ClassRef_Id] [varchar](4095) NULL,
	[ClassRef_Name] [varchar](4095) NULL,
	[ItemRef_Id] [varchar](4095) NULL,
	[ItemRef_Name] [varchar](4095) NULL,
	[UOMUnit] [varchar](4095) NULL,
	[UOMSetRef_Id] [varchar](4095) NULL,
	[UOMSetRef_Name] [varchar](4095) NULL,
	[Qty] [decimal](15, 2) NULL,
	[QtySpecified] [bit] NULL,
	[GroupItemRef_Id] [varchar](4095) NULL,
	[GroupItemRef_Name] [varchar](4095) NULL,
	[DiscountAccountRef_Id] [varchar](4095) NULL,
	[DiscountAccountRef_Name] [varchar](4095) NULL,
	[DiscountRef_Id] [varchar](4095) NULL,
	[DiscountRef_Name] [varchar](4095) NULL,
	[DiscountPercent] [decimal](15, 2) NULL,
	[DiscountPercentSpecified] [bit] NULL,
	[PercentBased] [bit] NULL,
	[PercentBasedSpecified] [bit] NULL,
	[MarkupPercentBased] [bit] NULL,
	[MarkupPercentBasedSpecified] [bit] NULL,
	[MarkupPriceLevelRef_Id] [varchar](4095) NULL,
	[MarkupPriceLevelRef_Name] [varchar](4095) NULL,
	[MarkupValue] [decimal](15, 2) NULL,
	[MarkupValueSpecified] [bit] NULL,
	[MarkupPercent] [decimal](15, 2) NULL,
	[MarkupPercentSpecified] [bit] NULL,
	[MarkupIncomeAccountRef_Id] [varchar](4095) NULL,
	[MarkupIncomeAccountRef_Name] [varchar](4095) NULL,
	[CustomField1] [varchar](4095) NULL,
	[CustomField2] [varchar](4095) NULL,
	[CustomField3] [varchar](4095) NULL,
	[CustomField4] [varchar](4095) NULL,
	[CustomField5] [varchar](4095) NULL,
	[CustomField6] [varchar](4095) NULL,
	[CustomField7] [varchar](4095) NULL,
	[CustomField8] [varchar](4095) NULL,
	[CustomField9] [varchar](4095) NULL,
	[CustomField10] [varchar](4095) NULL,
	[SeqNum] [int] NULL,
	[PARENT_GroupID] [varchar](255) NULL,
	[PARENT_ID] [varchar](255) NULL
) ON [PRIMARY]
GO



CREATE TABLE [dbo].[customer](
	[Id] [varchar](255) NULL,
	[SyncToken] [varchar](4095) NULL,
	[CreateTime] [datetime] NULL,
	[LastUpdatedTime] [datetime] NULL,
	[Domain] [varchar](4095) NULL,
	[DisplayName] [varchar](4095) NULL,
	[GivenName] [varchar](4095) NULL,
	[MiddleName] [varchar](4095) NULL,
	[Suffix] [varchar](4095) NULL,
	[FamilyName] [varchar](4095) NULL,
	[FullyQualifiedName] [varchar](4095) NULL,
	[ParentRef_Id] [varchar](4095) NULL,
	[ParentRef_Name] [varchar](4095) NULL,
	[CompanyName] [varchar](4095) NULL,
	[Level] [int] NULL,
	[TaxExemptionReasonId] [varchar](4095) NULL,
	[Job] [bit] NULL,
	[PrimaryEmailAddress] [varchar](4095) NULL,
	[ResaleNum] [varchar](4095) NULL,
	[SecondaryTaxIdentifier] [varchar](4095) NULL,
	[ARAccountRef_Id] [varchar](4095) NULL,
	[ARAccountRef_Name] [varchar](4095) NULL,
	[TaxCodeRef_Id] [varchar](4095) NULL,
	[TaxCodeRef_Name] [varchar](4095) NULL,
	[SalesTermRef_Id] [varchar](4095) NULL,
	[SalesTermRef_Name] [varchar](4095) NULL,
	[CurrencyRef_Id] [varchar](4095) NULL,
	[CurrencyRef_Name] [varchar](4095) NULL,
	[PaymentMethodRef_Id] [varchar](4095) NULL,
	[PaymentMethodRef_Name] [varchar](4095) NULL,
	[OpenBalanceDate] [datetime] NULL,
	[Balance] [decimal](15, 2) NULL,
	[Notes] [varchar](4095) NULL,
	[Fax] [varchar](4095) NULL,
	[Source] [varchar](4095) NULL,
	[PrimaryTaxIdentifier] [varchar](4095) NULL,
	[GSTRegistrationType] [varchar](4095) NULL,
	[BusinessNumber] [varchar](4095) NULL,
	[BillWithParent] [bit] NULL,
	[IsProject] [bit] NULL,
	[PrimaryPhone] [varchar](4095) NULL,
	[Mobile] [varchar](4095) NULL,
	[AlternatePhone] [varchar](4095) NULL,
	[Active] [bit] NULL,
	[PreferredDeliveryMethod] [varchar](4095) NULL,
	[GSTIN] [varchar](4095) NULL,
	[Taxable] [bit] NULL,
	[PrintOnCheckName] [varchar](4095) NULL,
	[IsCISContractorSpecified] [bit] NULL,
	[BalanceSpecified] [bit] NULL,
	[PriceLevelRef_Id] [varchar](4095) NULL,
	[PriceLevelRef_Name] [varchar](4095) NULL,
	[SalesRepRef_Id] [varchar](4095) NULL,
	[SalesRepRef_Name] [varchar](4095) NULL,
	[CustomerTypeRef_Id] [varchar](4095) NULL,
	[CustomerTypeRef_Name] [varchar](4095) NULL,
	[RootCustomerRef_Id] [varchar](4095) NULL,
	[RootCustomerRef_Name] [varchar](4095) NULL,
	[TaxGroupCodeRef_Id] [varchar](4095) NULL,
	[TaxGroupCodeRef_Name] [varchar](4095) NULL,
	[TaxRateRef_Id] [varchar](4095) NULL,
	[TaxRateRef_Name] [varchar](4095) NULL,
	[IsCISContractor] [bit] NULL,
	[BillWithParentSpecified] [bit] NULL,
	[JobSpecified] [bit] NULL,
	[AltContactName] [varchar](4095) NULL,
	[ContactName] [varchar](4095) NULL,
	[TaxableSpecified] [bit] NULL,
	[OpenBalanceDateSpecified] [bit] NULL,
	[BalanceWithJobsSpecified] [bit] NULL,
	[IsProjectSpecified] [bit] NULL,
	[TDSEnabledSpecified] [bit] NULL,
	[TDSEnabled] [bit] NULL,
	[TotalExpenseSpecified] [bit] NULL,
	[TotalExpense] [decimal](15, 2) NULL,
	[TotalRevenueSpecified] [bit] NULL,
	[TotalRevenue] [decimal](15, 2) NULL,
	[OverDueBalanceSpecified] [bit] NULL,
	[OverDueBalance] [decimal](15, 2) NULL,
	[AcctNum] [varchar](4095) NULL,
	[CreditLimitSpecified] [bit] NULL,
	[CreditLimit] [decimal](15, 2) NULL,
	[Job_TypeRef_Id] [varchar](4095) NULL,
	[Job_TypeRef_Name] [varchar](4095) NULL,
	[Job_Description] [varchar](4095) NULL,
	[Job_EndDateSpecified] [bit] NULL,
	[Job_EndDate] [datetime] NULL,
	[Job_ProjectedEndDateSpecified] [bit] NULL,
	[Job_ProjectedEndDate] [datetime] NULL,
	[Job_StartDateSpecified] [bit] NULL,
	[Job_StartDate] [datetime] NULL,
	[Job_StatusSpecified] [bit] NULL,
	[Job_Status] [varchar](4095) NULL,
	[CCI_PostalCode] [varchar](4095) NULL,
	[CCI_Number] [varchar](4095) NULL,
	[CCI_Type] [varchar](4095) NULL,
	[CCI_NameOnAcct] [varchar](4095) NULL,
	[CCI_CcExpiryMonth] [int] NULL,
	[CCI_CcExpiryMonthSpecified] [bit] NULL,
	[CCI_CcExpiryYear] [int] NULL,
	[CCI_CcExpiryYearSpecified] [bit] NULL,
	[CCI_BillAddrStreet] [varchar](4095) NULL,
	[CCI_CommercialCardCode] [varchar](4095) NULL,
	[CCI_ProcessPaymentSpecified] [bit] NULL,
	[CCI_CCTxnMode] [varchar](4095) NULL,
	[CCI_CCTxnModeSpecified] [bit] NULL,
	[CCI_CCTxnType] [varchar](4095) NULL,
	[CCI_CCTxnTypeSpecified] [bit] NULL,
	[CCI_PrevCCTransId] [varchar](4095) NULL,
	[CCI_Amount] [decimal](15, 2) NULL,
	[CCI_AmountSpecified] [bit] NULL,
	[CCI_ProcessPayment] [bit] NULL,
	[DefaultTaxCodeRef_Id] [varchar](4095) NULL,
	[DefaultTaxCodeRef_Name] [varchar](4095) NULL,
	[IntuitId] [varchar](4095) NULL,
	[Organization] [bit] NULL,
	[OrganizationSpecified] [bit] NULL,
	[Title] [varchar](4095) NULL,
	[UserId] [varchar](4095) NULL,
	[ActiveSpecified] [bit] NULL,
	[WebAddress] [varchar](4095) NULL,
	[BalanceWithJobs] [decimal](15, 2) NULL,
	[BillAddr_Id] [varchar](4095) NULL,
	[BillAddr_Line1] [varchar](4095) NULL,
	[BillAddr_Line2] [varchar](4095) NULL,
	[BillAddr_Line3] [varchar](4095) NULL,
	[BillAddr_Line4] [varchar](4095) NULL,
	[BillAddr_Line5] [varchar](4095) NULL,
	[BillAddr_City] [varchar](4095) NULL,
	[BillAddr_Country] [varchar](4095) NULL,
	[BillAddr_PostalCode] [varchar](4095) NULL,
	[BillAddr_CountryCode] [varchar](4095) NULL,
	[BillAddr_CountrySubDivisionCode] [varchar](4095) NULL,
	[BillAddr_PostalCodeSuffix] [varchar](4095) NULL,
	[BillAddr_Long] [varchar](4095) NULL,
	[BillAddr_Lat] [varchar](4095) NULL,
	[BillAddr_Note] [varchar](4095) NULL,
	[BillAddr_Tag] [varchar](4095) NULL,
	[ShipAddr_Id] [varchar](4095) NULL,
	[ShipAddr_Line1] [varchar](4095) NULL,
	[ShipAddr_Line2] [varchar](4095) NULL,
	[ShipAddr_Line3] [varchar](4095) NULL,
	[ShipAddr_Line4] [varchar](4095) NULL,
	[ShipAddr_Line5] [varchar](4095) NULL,
	[ShipAddr_City] [varchar](4095) NULL,
	[ShipAddr_Country] [varchar](4095) NULL,
	[ShipAddr_PostalCode] [varchar](4095) NULL,
	[ShipAddr_CountryCode] [varchar](4095) NULL,
	[ShipAddr_CountrySubDivisionCode] [varchar](4095) NULL,
	[ShipAddr_PostalCodeSuffix] [varchar](4095) NULL,
	[ShipAddr_Long] [varchar](4095) NULL,
	[ShipAddr_Lat] [varchar](4095) NULL,
	[ShipAddr_Note] [varchar](4095) NULL,
	[ShipAddr_Tag] [varchar](4095) NULL,
	[CustomField1] [varchar](4095) NULL,
	[CustomField2] [varchar](4095) NULL,
	[CustomField3] [varchar](4095) NULL,
	[CustomField4] [varchar](4095) NULL,
	[CustomField5] [varchar](4095) NULL,
	[CustomField6] [varchar](4095) NULL,
	[CustomField7] [varchar](4095) NULL,
	[CustomField8] [varchar](4095) NULL,
	[CustomField9] [varchar](4095) NULL,
	[CustomField10] [varchar](4095) NULL,
	[UserData] [varchar](4095) NULL,
	[Operation] [varchar](4095) NULL,
	[sparse] [bit] NULL,
	[LSData] [varchar](4095) NULL
) ON [PRIMARY]
GO



CREATE TABLE [dbo].[customertype](
	[Id] [varchar](255) NULL,
	[SyncToken] [varchar](4095) NULL,
	[CreateTime] [datetime] NULL,
	[LastUpdatedTime] [datetime] NULL,
	[Name] [varchar](4095) NULL,
	[ParentRef_Id] [varchar](4095) NULL,
	[ParentRef_Name] [varchar](4095) NULL,
	[FullyQualifiedName] [varchar](4095) NULL,
	[Active] [bit] NULL,
	[ActiveSpecified] [bit] NULL,
	[UserData] [varchar](4095) NULL,
	[Operation] [varchar](4095) NULL,
	[sparse] [bit] NULL,
	[LSData] [varchar](4095) NULL
) ON [PRIMARY]
GO



CREATE TABLE [dbo].[customFieldpreferences](
	[BooleanValue] [varchar](255) NULL,
	[CustomFieldType] [varchar](255) NULL,
	[CustomFieldName] [varchar](255) NULL,
	[PARENT_ID] [varchar](255) NULL
) ON [PRIMARY]
GO



CREATE TABLE [dbo].[department](
	[Id] [varchar](255) NULL,
	[SyncToken] [varchar](4095) NULL,
	[CreateTime] [datetime] NULL,
	[LastUpdatedTime] [datetime] NULL,
	[Name] [varchar](4095) NULL,
	[SubDepartment] [bit] NULL,
	[SubDepartmentSpecified] [bit] NULL,
	[ParentRef_Id] [varchar](4095) NULL,
	[ParentRef_Name] [varchar](4095) NULL,
	[FullyQualifiedName] [varchar](4095) NULL,
	[Active] [bit] NULL,
	[ActiveSpecified] [bit] NULL,
	[Address_Id] [varchar](4095) NULL,
	[Address_Line1] [varchar](4095) NULL,
	[Address_Line2] [varchar](4095) NULL,
	[Address_Line3] [varchar](4095) NULL,
	[Address_Line4] [varchar](4095) NULL,
	[Address_Line5] [varchar](4095) NULL,
	[Address_City] [varchar](4095) NULL,
	[Address_Country] [varchar](4095) NULL,
	[Address_PostalCode] [varchar](4095) NULL,
	[Address_PostalCodeSuffix] [varchar](4095) NULL,
	[Address_CountryCode] [varchar](4095) NULL,
	[Address_CountrySubDivisionCode] [varchar](4095) NULL,
	[Address_Lat] [varchar](4095) NULL,
	[Address_Long] [varchar](4095) NULL,
	[Address_Note] [varchar](4095) NULL,
	[Address_Tag] [varchar](4095) NULL,
	[UserData] [varchar](4095) NULL,
	[Operation] [varchar](4095) NULL,
	[sparse] [bit] NULL,
	[LSData] [varchar](4095) NULL
) ON [PRIMARY]
GO


CREATE TABLE [dbo].[deposit](
	[Id] [varchar](255) NULL,
	[SyncToken] [varchar](4095) NULL,
	[CreateTime] [datetime] NULL,
	[LastUpdatedTime] [datetime] NULL,
	[Name] [varchar](4095) NULL,
	[AccountRef_Id] [varchar](4095) NULL,
	[AccountRef_Name] [varchar](4095) NULL,
	[Amount] [decimal](15, 2) NULL,
	[AmountSpecified] [bit] NULL,
	[Memo] [varchar](4095) NULL,
	[TxnSource] [varchar](4095) NULL,
	[PrivateNote] [varchar](4095) NULL,
	[ExchangeRate] [decimal](15, 2) NULL,
	[ExchangeRateSpecified] [bit] NULL,
	[CurrencyRef_Id] [varchar](4095) NULL,
	[CurrencyRef_Name] [varchar](4095) NULL,
	[DepartmentRef_Id] [varchar](4095) NULL,
	[DepartmentRef_Name] [varchar](4095) NULL,
	[TxnDateSpecified] [bit] NULL,
	[TxnDate] [datetime] NULL,
	[TransactionLocationType] [varchar](4095) NULL,
	[DepositToAccountRef_Id] [varchar](4095) NULL,
	[DepositToAccountRef_Name] [varchar](4095) NULL,
	[GlobalTaxCalculation] [varchar](4095) NULL,
	[GlobalTaxCalculationSpecified] [bit] NULL,
	[TotalAmt] [decimal](15, 2) NULL,
	[TotalAmtSpecified] [bit] NULL,
	[HomeTotalAmt] [decimal](15, 2) NULL,
	[HomeTotalAmtSpecified] [bit] NULL,
	[TotalTaxSpecified] [bit] NULL,
	[TotalTax] [decimal](15, 2) NULL,
	[TxnTaxCodeRef_Id] [varchar](4095) NULL,
	[TxnTaxCodeRef_Name] [varchar](4095) NULL,
	[DefaultTaxCodeRef_Id] [varchar](4095) NULL,
	[DefaultTaxCodeRef_Name] [varchar](4095) NULL,
	[UserData] [varchar](4095) NULL,
	[Operation] [varchar](4095) NULL,
	[sparse] [bit] NULL,
	[LSData] [varchar](4095) NULL
) ON [PRIMARY]
GO


CREATE TABLE [dbo].[depositlinedetail](
	[Id] [varchar](255) NULL,
	[LineNum] [varchar](4095) NULL,
	[Description] [varchar](4095) NULL,
	[Amount] [decimal](15, 2) NULL,
	[AmountSpecified] [bit] NULL,
	[Entity_Id] [varchar](4095) NULL,
	[Entity_Name] [varchar](4095) NULL,
	[ProjectRef_Id] [varchar](4095) NULL,
	[ProjectRef_Name] [varchar](4095) NULL,
	[ClassRef_Id] [varchar](4095) NULL,
	[ClassRef_Name] [varchar](4095) NULL,
	[AccountRef_Id] [varchar](4095) NULL,
	[AccountRef_Name] [varchar](4095) NULL,
	[PaymentMethodRef_Id] [varchar](4095) NULL,
	[PaymentMethodRef_Name] [varchar](4095) NULL,
	[CheckNum] [varchar](4095) NULL,
	[TxnType] [varchar](4095) NULL,
	[TxnTypeSpecified] [bit] NULL,
	[TaxCodeRef_Id] [varchar](4095) NULL,
	[TaxCodeRef_Name] [varchar](4095) NULL,
	[TaxApplicableOn] [varchar](4095) NULL,
	[TaxApplicableOnSpecified] [bit] NULL,
	[CustomField1] [varchar](4095) NULL,
	[CustomField2] [varchar](4095) NULL,
	[CustomField3] [varchar](4095) NULL,
	[CustomField4] [varchar](4095) NULL,
	[CustomField5] [varchar](4095) NULL,
	[CustomField6] [varchar](4095) NULL,
	[CustomField7] [varchar](4095) NULL,
	[CustomField8] [varchar](4095) NULL,
	[CustomField9] [varchar](4095) NULL,
	[CustomField10] [varchar](4095) NULL,
	[SeqNum] [int] NULL,
	[PARENT_GroupID] [varchar](255) NULL,
	[PARENT_ID] [varchar](255) NULL
) ON [PRIMARY]
GO



CREATE TABLE [dbo].[effectivetaxrate](
	[Id] [varchar](255) NULL,
	[RateValue] [decimal](15, 2) NULL,
	[RateValueSpecified] [bit] NULL,
	[EffectiveDate] [datetime] NULL,
	[EffectiveDateSpecified] [bit] NULL,
	[EndDate] [datetime] NULL,
	[EndDateSpecified] [bit] NULL,
	[SeqNum] [int] NULL,
	[LetSyncId] [bit] NULL,
	[ParentTableType] [varchar](255) NULL,
	[PARENT_ID] [varchar](255) NULL
) ON [PRIMARY]
GO



CREATE TABLE [dbo].[employee](
	[Id] [varchar](255) NULL,
	[SyncToken] [varchar](4095) NULL,
	[CreateTime] [datetime] NULL,
	[LastUpdatedTime] [datetime] NULL,
	[Name] [varchar](4095) NULL,
	[GivenName] [varchar](4095) NULL,
	[MiddleName] [varchar](4095) NULL,
	[FamilyName] [varchar](4095) NULL,
	[Suffix] [varchar](4095) NULL,
	[FullyQualifiedName] [varchar](4095) NULL,
	[DisplayName] [varchar](4095) NULL,
	[PrintOnCheckName] [varchar](4095) NULL,
	[Title] [varchar](4095) NULL,
	[Active] [bit] NULL,
	[ActiveSpecified] [bit] NULL,
	[PrimaryPhone] [varchar](4095) NULL,
	[Mobile] [varchar](4095) NULL,
	[Fax] [varchar](4095) NULL,
	[PrimaryEmailAddress] [varchar](4095) NULL,
	[Organization] [bit] NULL,
	[OrganizationSpecified] [bit] NULL,
	[UseTimeEntrySpecified] [bit] NULL,
	[UseTimeEntry] [varchar](4095) NULL,
	[ReleasedDateSpecified] [bit] NULL,
	[ReleasedDate] [datetime] NULL,
	[HiredDate] [datetime] NULL,
	[HiredDateSpecified] [bit] NULL,
	[Gender] [varchar](4095) NULL,
	[GenderSpecified] [bit] NULL,
	[BirthDateSpecified] [bit] NULL,
	[BirthDate] [datetime] NULL,
	[BillRateSpecified] [bit] NULL,
	[BillRate] [datetime] NULL,
	[BillableTimeSpecified] [bit] NULL,
	[BillableTime] [bit] NULL,
	[SSN] [varchar](4095) NULL,
	[EmployeeNumber] [varchar](4095) NULL,
	[EmployeeType] [varchar](4095) NULL,
	[V4IDPseudonym] [varchar](4095) NULL,
	[PrimaryAddr_Id] [varchar](4095) NULL,
	[PrimaryAddr_Line1] [varchar](4095) NULL,
	[PrimaryAddr_Line2] [varchar](4095) NULL,
	[PrimaryAddr_Line3] [varchar](4095) NULL,
	[PrimaryAddr_Line4] [varchar](4095) NULL,
	[PrimaryAddr_Line5] [varchar](4095) NULL,
	[PrimaryAddr_City] [varchar](4095) NULL,
	[PrimaryAddr_PostalCode] [varchar](4095) NULL,
	[PrimaryAddr_PostalCodeSuffix] [varchar](4095) NULL,
	[PrimaryAddr_Country] [varchar](4095) NULL,
	[PrimaryAddr_CountryCode] [varchar](4095) NULL,
	[PrimaryAddr_CountrySubDivisionCode] [varchar](4095) NULL,
	[PrimaryAddr_Note] [varchar](4095) NULL,
	[PrimaryAddr_Long] [varchar](4095) NULL,
	[PrimaryAddr_Lat] [varchar](4095) NULL,
	[PrimaryAddr_Tag] [varchar](4095) NULL,
	[UserData] [varchar](4095) NULL,
	[Operation] [varchar](4095) NULL,
	[sparse] [bit] NULL,
	[LSData] [varchar](4095) NULL
) ON [PRIMARY]
GO




CREATE TABLE [dbo].[error_table](
	[Id] [varchar](255) NULL,
	[DateTimeLog] [datetime] NULL,
	[StatusCode] [varchar](4095) NULL,
	[StatusMessage] [varchar](4095) NULL,
	[PossibleSolution] [varchar](4095) NULL,
	[Method] [varchar](4095) NULL,
	[TableName] [varchar](4095) NULL,
	[TaskName] [varchar](4095) NULL,
	[TaskId] [varchar](4095) NULL,
	[CompanyFile] [varchar](4095) NULL,
	[RunBy] [varchar](4095) NULL,
	[SessionId] [varchar](4095) NULL
) ON [PRIMARY]
GO



CREATE TABLE [dbo].[estimate](
	[Id] [varchar](255) NULL,
	[SyncToken] [varchar](4095) NULL,
	[CreateTime] [datetime] NULL,
	[LastUpdatedTime] [datetime] NULL,
	[Name] [varchar](4095) NULL,
	[TxnDate] [datetime] NULL,
	[DocNumber] [varchar](4095) NULL,
	[DepartmentRef_Id] [varchar](4095) NULL,
	[DepartmentRef_Name] [varchar](4095) NULL,
	[ProjectRef_Id] [varchar](4095) NULL,
	[ProjectRef_Name] [varchar](4095) NULL,
	[CurrencyRef_Id] [varchar](4095) NULL,
	[CurrencyRef_Name] [varchar](4095) NULL,
	[PrivateNote] [varchar](4095) NULL,
	[TxnStatus] [varchar](4095) NULL,
	[ExchangeRate] [decimal](15, 2) NULL,
	[ExchangeRateSpecified] [bit] NULL,
	[TransactionLocationType] [varchar](4095) NULL,
	[PrintStatus] [varchar](4095) NULL,
	[PrintStatusSpecified] [bit] NULL,
	[EmailStatus] [varchar](4095) NULL,
	[EmailStatusSpecified] [bit] NULL,
	[BillEmailAddress] [varchar](4095) NULL,
	[DeliveryType] [varchar](4095) NULL,
	[DeliveryTypeSpecified] [bit] NULL,
	[DeliveryTime] [datetime] NULL,
	[DeliveryTimeSpecified] [bit] NULL,
	[DeliveryErrorType] [varchar](4095) NULL,
	[DeliveryErrorTypeSpecified] [bit] NULL,
	[ApplyTaxAfterDiscount] [bit] NULL,
	[ApplyTaxAfterDiscountSpecified] [bit] NULL,
	[CustomerRef_Id] [varchar](4095) NULL,
	[CustomerRef_Name] [varchar](4095) NULL,
	[CustomerMemo] [varchar](4095) NULL,
	[FreeFormAddress] [bit] NULL,
	[FreeFormAddressSpecified] [bit] NULL,
	[ClassRef_Id] [varchar](4095) NULL,
	[ClassRef_Name] [varchar](4095) NULL,
	[SalesTermRef_Id] [varchar](4095) NULL,
	[SalesTermRef_Name] [varchar](4095) NULL,
	[DueDate] [datetime] NULL,
	[DueDateSpecified] [bit] NULL,
	[ShipMethodRef_Id] [varchar](4095) NULL,
	[ShipMethodRef_Name] [varchar](4095) NULL,
	[ShipDate] [datetime] NULL,
	[ShipDateSpecified] [bit] NULL,
	[GlobalTaxCalculation] [varchar](4095) NULL,
	[GlobalTaxCalculationSpecified] [bit] NULL,
	[TotalAmt] [decimal](15, 2) NULL,
	[TotalAmtSpecified] [bit] NULL,
	[HomeTotalAmt] [decimal](15, 2) NULL,
	[HomeTotalAmtSpecified] [bit] NULL,
	[TaxExemptionRef_Id] [varchar](4095) NULL,
	[TaxExemptionRef_Name] [varchar](4095) NULL,
	[ExpirationDate] [datetime] NULL,
	[ExpirationDateSpecified] [bit] NULL,
	[AcceptedBy] [varchar](4095) NULL,
	[AcceptedDate] [datetime] NULL,
	[AcceptedDateSpecified] [bit] NULL,
	[TotalTaxSpecified] [bit] NULL,
	[TotalTax] [decimal](15, 2) NULL,
	[TxnTaxCodeRef_Id] [varchar](4095) NULL,
	[TxnTaxCodeRef_Name] [varchar](4095) NULL,
	[DefaultTaxCodeRef_Id] [varchar](4095) NULL,
	[DefaultTaxCodeRef_Name] [varchar](4095) NULL,
	[BillAddr_Id] [varchar](4095) NULL,
	[BillAddr_Line1] [varchar](4095) NULL,
	[BillAddr_Line2] [varchar](4095) NULL,
	[BillAddr_Line3] [varchar](4095) NULL,
	[BillAddr_Line4] [varchar](4095) NULL,
	[BillAddr_Line5] [varchar](4095) NULL,
	[BillAddr_City] [varchar](4095) NULL,
	[BillAddr_Country] [varchar](4095) NULL,
	[BillAddr_PostalCode] [varchar](4095) NULL,
	[BillAddr_CountryCode] [varchar](4095) NULL,
	[BillAddr_CountrySubDivisionCode] [varchar](4095) NULL,
	[BillAddr_PostalCodeSuffix] [varchar](4095) NULL,
	[BillAddr_Long] [varchar](4095) NULL,
	[BillAddr_Lat] [varchar](4095) NULL,
	[BillAddr_Note] [varchar](4095) NULL,
	[BillAddr_Tag] [varchar](4095) NULL,
	[ShipFromAddr_Id] [varchar](4095) NULL,
	[ShipFromAddr_Line1] [varchar](4095) NULL,
	[ShipFromAddr_Line2] [varchar](4095) NULL,
	[ShipFromAddr_Line3] [varchar](4095) NULL,
	[ShipFromAddr_Line4] [varchar](4095) NULL,
	[ShipFromAddr_Line5] [varchar](4095) NULL,
	[ShipFromAddr_City] [varchar](4095) NULL,
	[ShipFromAddr_Country] [varchar](4095) NULL,
	[ShipFromAddr_PostalCode] [varchar](4095) NULL,
	[ShipFromAddr_CountryCode] [varchar](4095) NULL,
	[ShipFromAddr_CountrySubDivisionCode] [varchar](4095) NULL,
	[ShipFromAddr_PostalCodeSuffix] [varchar](4095) NULL,
	[ShipFromAddr_Long] [varchar](4095) NULL,
	[ShipFromAddr_Lat] [varchar](4095) NULL,
	[ShipFromAddr_Note] [varchar](4095) NULL,
	[ShipFromAddr_Tag] [varchar](4095) NULL,
	[ShipAddr_Id] [varchar](4095) NULL,
	[ShipAddr_Line1] [varchar](4095) NULL,
	[ShipAddr_Line2] [varchar](4095) NULL,
	[ShipAddr_Line3] [varchar](4095) NULL,
	[ShipAddr_Line4] [varchar](4095) NULL,
	[ShipAddr_Line5] [varchar](4095) NULL,
	[ShipAddr_City] [varchar](4095) NULL,
	[ShipAddr_Country] [varchar](4095) NULL,
	[ShipAddr_PostalCode] [varchar](4095) NULL,
	[ShipAddr_CountryCode] [varchar](4095) NULL,
	[ShipAddr_CountrySubDivisionCode] [varchar](4095) NULL,
	[ShipAddr_PostalCodeSuffix] [varchar](4095) NULL,
	[ShipAddr_Long] [varchar](4095) NULL,
	[ShipAddr_Lat] [varchar](4095) NULL,
	[ShipAddr_Note] [varchar](4095) NULL,
	[ShipAddr_Tag] [varchar](4095) NULL,
	[CustomField1] [varchar](4095) NULL,
	[CustomField2] [varchar](4095) NULL,
	[CustomField3] [varchar](4095) NULL,
	[CustomField4] [varchar](4095) NULL,
	[CustomField5] [varchar](4095) NULL,
	[CustomField6] [varchar](4095) NULL,
	[CustomField7] [varchar](4095) NULL,
	[CustomField8] [varchar](4095) NULL,
	[CustomField9] [varchar](4095) NULL,
	[CustomField10] [varchar](4095) NULL,
	[UserData] [varchar](4095) NULL,
	[Operation] [varchar](4095) NULL,
	[sparse] [bit] NULL,
	[LSData] [varchar](4095) NULL
) ON [PRIMARY]
GO




CREATE TABLE [dbo].[estimatelinedetail](
	[Id] [varchar](255) NULL,
	[LineNum] [varchar](4095) NULL,
	[Description] [varchar](4095) NULL,
	[Amount] [decimal](15, 2) NULL,
	[AmountSpecified] [bit] NULL,
	[DetailType] [varchar](4095) NULL,
	[DetailTypeSpecified] [bit] NULL,
	[PriceLevelRef_Id] [varchar](4095) NULL,
	[PriceLevelRef_Name] [varchar](4095) NULL,
	[RatePercent] [decimal](15, 2) NULL,
	[UnitPrice] [decimal](15, 2) NULL,
	[TaxInclusiveAmt] [decimal](15, 2) NULL,
	[TaxInclusiveAmtSpecified] [bit] NULL,
	[DiscountAmt] [decimal](15, 2) NULL,
	[DiscountAmtSpecified] [bit] NULL,
	[ServiceDate] [datetime] NULL,
	[ServiceDateSpecified] [bit] NULL,
	[DiscountRate] [decimal](15, 2) NULL,
	[DiscountRateSpecified] [bit] NULL,
	[TaxClassificationRef_Id] [varchar](4095) NULL,
	[TaxClassificationRef_Name] [varchar](4095) NULL,
	[ItemAccountRef_Id] [varchar](4095) NULL,
	[ItemAccountRef_Name] [varchar](4095) NULL,
	[InventorySiteRef_Id] [varchar](4095) NULL,
	[InventorySiteRef_Name] [varchar](4095) NULL,
	[TaxCodeRef_Id] [varchar](4095) NULL,
	[TaxCodeRef_Name] [varchar](4095) NULL,
	[ClassRef_Id] [varchar](4095) NULL,
	[ClassRef_Name] [varchar](4095) NULL,
	[ItemRef_Id] [varchar](4095) NULL,
	[ItemRef_Name] [varchar](4095) NULL,
	[UOMUnit] [varchar](4095) NULL,
	[UOMSetRef_Id] [varchar](4095) NULL,
	[UOMSetRef_Name] [varchar](4095) NULL,
	[Qty] [decimal](15, 2) NULL,
	[QtySpecified] [bit] NULL,
	[GroupItemRef_Id] [varchar](4095) NULL,
	[GroupItemRef_Name] [varchar](4095) NULL,
	[DiscountAccountRef_Id] [varchar](4095) NULL,
	[DiscountAccountRef_Name] [varchar](4095) NULL,
	[DiscountRef_Id] [varchar](4095) NULL,
	[DiscountRef_Name] [varchar](4095) NULL,
	[DiscountPercent] [decimal](15, 2) NULL,
	[DiscountPercentSpecified] [bit] NULL,
	[PercentBased] [bit] NULL,
	[PercentBasedSpecified] [bit] NULL,
	[MarkupPercentBased] [bit] NULL,
	[MarkupPercentBasedSpecified] [bit] NULL,
	[MarkupPriceLevelRef_Id] [varchar](4095) NULL,
	[MarkupPriceLevelRef_Name] [varchar](4095) NULL,
	[MarkupValue] [decimal](15, 2) NULL,
	[MarkupValueSpecified] [bit] NULL,
	[MarkupPercent] [decimal](15, 2) NULL,
	[MarkupPercentSpecified] [bit] NULL,
	[MarkupIncomeAccountRef_Id] [varchar](4095) NULL,
	[MarkupIncomeAccountRef_Name] [varchar](4095) NULL,
	[CustomField1] [varchar](4095) NULL,
	[CustomField2] [varchar](4095) NULL,
	[CustomField3] [varchar](4095) NULL,
	[CustomField4] [varchar](4095) NULL,
	[CustomField5] [varchar](4095) NULL,
	[CustomField6] [varchar](4095) NULL,
	[CustomField7] [varchar](4095) NULL,
	[CustomField8] [varchar](4095) NULL,
	[CustomField9] [varchar](4095) NULL,
	[CustomField10] [varchar](4095) NULL,
	[SeqNum] [int] NULL,
	[PARENT_GroupID] [varchar](255) NULL,
	[PARENT_ID] [varchar](255) NULL
) ON [PRIMARY]
GO



CREATE TABLE [dbo].[exchangerate](
	[Id] [varchar](255) NULL,
	[SyncToken] [varchar](4095) NULL,
	[CreateTime] [datetime] NULL,
	[LastUpdatedTime] [datetime] NULL,
	[Name] [varchar](4095) NULL,
	[SourceCurrencyCode] [varchar](4095) NULL,
	[TargetCurrencyCode] [varchar](4095) NULL,
	[Rate] [decimal](15, 2) NULL,
	[RateSpecified] [bit] NULL,
	[AsOfDate] [datetime] NULL,
	[AsOfDateSpecified] [bit] NULL,
	[UserData] [varchar](4095) NULL,
	[Operation] [varchar](4095) NULL,
	[sparse] [bit] NULL,
	[LSData] [varchar](4095) NULL
) ON [PRIMARY]
GO




CREATE TABLE [dbo].[history](
	[Id] [varchar](255) NULL,
	[TableOrTaskName] [varchar](4095) NULL,
	[ModifiedDateTime] [datetime] NULL,
	[RunBy] [varchar](4095) NULL,
	[CompanyFile] [varchar](255) NULL,
	[LSOperation] [varchar](4095) NULL,
	[RecordsAdded_ToQuickBooks] [int] NULL,
	[RecordsDeleted_FromQuickBoks] [int] NULL,
	[RecordsUpdated_ToQuickBooks] [int] NULL,
	[RecordsVoided_ToQuickBooks] [int] NULL,
	[RecordsAdded_ToDatabase] [int] NULL,
	[RecordsDeleted_FromDatabase] [int] NULL,
	[RecordsUpdated_ToDatabase] [int] NULL,
	[RecordsRefreshed_ToDatabase] [int] NULL,
	[RecordsAddedFromReport_ToDatabase] [int] NULL,
	[StartRunningDateTime] [datetime] NULL,
	[EndRunningDateTime] [datetime] NULL,
	[Result] [varchar](4095) NULL
) ON [PRIMARY]
GO




CREATE TABLE [dbo].[invoice](
	[Id] [varchar](255) NULL,
	[SyncToken] [varchar](4095) NULL,
	[CreateTime] [datetime] NULL,
	[LastUpdatedTime] [datetime] NULL,
	[Name] [varchar](4095) NULL,
	[TxnSource] [varchar](4095) NULL,
	[PrivateNote] [varchar](4095) NULL,
	[CurrencyRef_Id] [varchar](4095) NULL,
	[CurrencyRef_Name] [varchar](4095) NULL,
	[DepartmentRef_Id] [varchar](4095) NULL,
	[DepartmentRef_Name] [varchar](4095) NULL,
	[ProjectRef_Id] [varchar](4095) NULL,
	[ProjectRef_Name] [varchar](4095) NULL,
	[TxnDate] [datetime] NULL,
	[TxnDateSpecified] [bit] NULL,
	[DocNumber] [varchar](4095) NULL,
	[ExchangeRate] [decimal](15, 2) NULL,
	[ExchangeRateSpecified] [bit] NULL,
	[TransactionLocationType] [varchar](4095) NULL,
	[PrintStatus] [varchar](4095) NULL,
	[PrintStatusSpecified] [bit] NULL,
	[EmailStatus] [varchar](4095) NULL,
	[EmailStatusSpecified] [bit] NULL,
	[BillEmailAddress] [varchar](4095) NULL,
	[BillEmailAddressCc] [varchar](4095) NULL,
	[BillEmailAddressBcc] [varchar](4095) NULL,
	[Balance] [decimal](15, 2) NULL,
	[BalanceSpecified] [bit] NULL,
	[HomeBalance] [decimal](15, 2) NULL,
	[HomeBalanceSpecified] [bit] NULL,
	[DepositToAccountRef_Id] [varchar](4095) NULL,
	[DepositToAccountRef_Name] [varchar](4095) NULL,
	[DeliveryType] [varchar](4095) NULL,
	[DeliveryTypeSpecified] [bit] NULL,
	[DeliveryTime] [datetime] NULL,
	[DeliveryTimeSpecified] [bit] NULL,
	[DeliveryErrorType] [varchar](4095) NULL,
	[DeliveryErrorTypeSpecified] [bit] NULL,
	[ApplyTaxAfterDiscountSpecified] [bit] NULL,
	[ApplyTaxAfterDiscount] [bit] NULL,
	[CustomerRef_Id] [varchar](4095) NULL,
	[CustomerRef_Name] [varchar](4095) NULL,
	[CustomerMemo] [varchar](4095) NULL,
	[FreeFormAddress] [bit] NULL,
	[FreeFormAddressSpecified] [bit] NULL,
	[ClassRef_Id] [varchar](4095) NULL,
	[ClassRef_Name] [varchar](4095) NULL,
	[SalesTermRef_Id] [varchar](4095) NULL,
	[SalesTermRef_Name] [varchar](4095) NULL,
	[DueDate] [datetime] NULL,
	[DueDateSpecified] [bit] NULL,
	[ShipMethodRef_Id] [varchar](4095) NULL,
	[ShipMethodRef_Name] [varchar](4095) NULL,
	[ShipDate] [datetime] NULL,
	[ShipDateSpecified] [bit] NULL,
	[TrackingNum] [varchar](4095) NULL,
	[GlobalTaxCalculation] [varchar](4095) NULL,
	[GlobalTaxCalculationSpecified] [bit] NULL,
	[TotalAmt] [decimal](15, 2) NULL,
	[TotalAmtSpecified] [bit] NULL,
	[HomeTotalAmt] [decimal](15, 2) NULL,
	[HomeTotalAmtSpecified] [bit] NULL,
	[TaxExemptionRef_Id] [varchar](4095) NULL,
	[TaxExemptionRef_Name] [varchar](4095) NULL,
	[LessCIS] [decimal](15, 2) NULL,
	[CallToAction] [varchar](4095) NULL,
	[InvoiceStatus] [varchar](4095) NULL,
	[ECloudStatusTimeStampSpecified] [bit] NULL,
	[ECloudStatusTimeStamp] [datetime] NULL,
	[EInvoiceStatusSpecified] [bit] NULL,
	[EInvoiceStatus] [varchar](4095) NULL,
	[AllowOnlineACHPaymentSpecified] [bit] NULL,
	[AllowOnlineACHPayment] [bit] NULL,
	[AllowOnlineCreditCardPaymentSpecified] [bit] NULL,
	[AllowOnlineCreditCardPayment] [bit] NULL,
	[AllowOnlinePaymentSpecified] [bit] NULL,
	[AllowOnlinePayment] [bit] NULL,
	[AllowIPNPaymentSpecified] [bit] NULL,
	[AllowIPNPayment] [bit] NULL,
	[DepositSpecified] [bit] NULL,
	[Deposit] [decimal](15, 2) NULL,
	[LessCISSpecified] [bit] NULL,
	[InvoiceLink] [varchar](4095) NULL,
	[TotalTaxSpecified] [bit] NULL,
	[TotalTax] [decimal](15, 2) NULL,
	[TxnTaxCodeRef_Id] [varchar](4095) NULL,
	[TxnTaxCodeRef_Name] [varchar](4095) NULL,
	[DefaultTaxCodeRef_Id] [varchar](4095) NULL,
	[DefaultTaxCodeRef_Name] [varchar](4095) NULL,
	[BillAddr_Id] [varchar](4095) NULL,
	[BillAddr_Line1] [varchar](4095) NULL,
	[BillAddr_Line2] [varchar](4095) NULL,
	[BillAddr_Line3] [varchar](4095) NULL,
	[BillAddr_Line4] [varchar](4095) NULL,
	[BillAddr_Line5] [varchar](4095) NULL,
	[BillAddr_City] [varchar](4095) NULL,
	[BillAddr_Country] [varchar](4095) NULL,
	[BillAddr_PostalCode] [varchar](4095) NULL,
	[BillAddr_CountryCode] [varchar](4095) NULL,
	[BillAddr_CountrySubDivisionCode] [varchar](4095) NULL,
	[BillAddr_PostalCodeSuffix] [varchar](4095) NULL,
	[BillAddr_Long] [varchar](4095) NULL,
	[BillAddr_Lat] [varchar](4095) NULL,
	[BillAddr_Note] [varchar](4095) NULL,
	[BillAddr_Tag] [varchar](4095) NULL,
	[ShipFromAddr_Id] [varchar](4095) NULL,
	[ShipFromAddr_Line1] [varchar](4095) NULL,
	[ShipFromAddr_Line2] [varchar](4095) NULL,
	[ShipFromAddr_Line3] [varchar](4095) NULL,
	[ShipFromAddr_Line4] [varchar](4095) NULL,
	[ShipFromAddr_Line5] [varchar](4095) NULL,
	[ShipFromAddr_City] [varchar](4095) NULL,
	[ShipFromAddr_Country] [varchar](4095) NULL,
	[ShipFromAddr_PostalCode] [varchar](4095) NULL,
	[ShipFromAddr_CountryCode] [varchar](4095) NULL,
	[ShipFromAddr_CountrySubDivisionCode] [varchar](4095) NULL,
	[ShipFromAddr_PostalCodeSuffix] [varchar](4095) NULL,
	[ShipFromAddr_Long] [varchar](4095) NULL,
	[ShipFromAddr_Lat] [varchar](4095) NULL,
	[ShipFromAddr_Note] [varchar](4095) NULL,
	[ShipFromAddr_Tag] [varchar](4095) NULL,
	[ShipAddr_Id] [varchar](4095) NULL,
	[ShipAddr_Line1] [varchar](4095) NULL,
	[ShipAddr_Line2] [varchar](4095) NULL,
	[ShipAddr_Line3] [varchar](4095) NULL,
	[ShipAddr_Line4] [varchar](4095) NULL,
	[ShipAddr_Line5] [varchar](4095) NULL,
	[ShipAddr_City] [varchar](4095) NULL,
	[ShipAddr_Country] [varchar](4095) NULL,
	[ShipAddr_PostalCode] [varchar](4095) NULL,
	[ShipAddr_CountryCode] [varchar](4095) NULL,
	[ShipAddr_CountrySubDivisionCode] [varchar](4095) NULL,
	[ShipAddr_PostalCodeSuffix] [varchar](4095) NULL,
	[ShipAddr_Long] [varchar](4095) NULL,
	[ShipAddr_Lat] [varchar](4095) NULL,
	[ShipAddr_Note] [varchar](4095) NULL,
	[ShipAddr_Tag] [varchar](4095) NULL,
	[CustomField1] [varchar](4095) NULL,
	[CustomField2] [varchar](4095) NULL,
	[CustomField3] [varchar](4095) NULL,
	[CustomField4] [varchar](4095) NULL,
	[CustomField5] [varchar](4095) NULL,
	[CustomField6] [varchar](4095) NULL,
	[CustomField7] [varchar](4095) NULL,
	[CustomField8] [varchar](4095) NULL,
	[CustomField9] [varchar](4095) NULL,
	[CustomField10] [varchar](4095) NULL,
	[UserData] [varchar](4095) NULL,
	[Operation] [varchar](4095) NULL,
	[sparse] [bit] NULL,
	[LSData] [varchar](4095) NULL
) ON [PRIMARY]
GO



CREATE TABLE [dbo].[invoicelinedetail](
	[Id] [varchar](255) NULL,
	[LineNum] [varchar](4095) NULL,
	[Description] [varchar](4095) NULL,
	[Amount] [decimal](15, 2) NULL,
	[AmountSpecified] [bit] NULL,
	[DetailType] [varchar](4095) NULL,
	[DetailTypeSpecified] [bit] NULL,
	[PriceLevelRef_Id] [varchar](4095) NULL,
	[PriceLevelRef_Name] [varchar](4095) NULL,
	[RatePercent] [decimal](15, 2) NULL,
	[UnitPrice] [decimal](15, 2) NULL,
	[TaxInclusiveAmt] [decimal](15, 2) NULL,
	[TaxInclusiveAmtSpecified] [bit] NULL,
	[DiscountAmt] [decimal](15, 2) NULL,
	[DiscountAmtSpecified] [bit] NULL,
	[ServiceDate] [datetime] NULL,
	[ServiceDateSpecified] [bit] NULL,
	[DiscountRate] [decimal](15, 2) NULL,
	[DiscountRateSpecified] [bit] NULL,
	[TaxClassificationRef_Id] [varchar](4095) NULL,
	[TaxClassificationRef_Name] [varchar](4095) NULL,
	[ItemAccountRef_Id] [varchar](4095) NULL,
	[ItemAccountRef_Name] [varchar](4095) NULL,
	[InventorySiteRef_Id] [varchar](4095) NULL,
	[InventorySiteRef_Name] [varchar](4095) NULL,
	[TaxCodeRef_Id] [varchar](4095) NULL,
	[TaxCodeRef_Name] [varchar](4095) NULL,
	[ClassRef_Id] [varchar](4095) NULL,
	[ClassRef_Name] [varchar](4095) NULL,
	[ItemRef_Id] [varchar](4095) NULL,
	[ItemRef_Name] [varchar](4095) NULL,
	[UOMUnit] [varchar](4095) NULL,
	[UOMSetRef_Id] [varchar](4095) NULL,
	[UOMSetRef_Name] [varchar](4095) NULL,
	[Qty] [decimal](15, 2) NULL,
	[QtySpecified] [bit] NULL,
	[GroupItemRef_Id] [varchar](4095) NULL,
	[GroupItemRef_Name] [varchar](4095) NULL,
	[DiscountAccountRef_Id] [varchar](4095) NULL,
	[DiscountAccountRef_Name] [varchar](4095) NULL,
	[DiscountRef_Id] [varchar](4095) NULL,
	[DiscountRef_Name] [varchar](4095) NULL,
	[DiscountPercent] [decimal](15, 2) NULL,
	[DiscountPercentSpecified] [bit] NULL,
	[PercentBased] [bit] NULL,
	[PercentBasedSpecified] [bit] NULL,
	[MarkupPercentBased] [bit] NULL,
	[MarkupPercentBasedSpecified] [bit] NULL,
	[MarkupPriceLevelRef_Id] [varchar](4095) NULL,
	[MarkupPriceLevelRef_Name] [varchar](4095) NULL,
	[MarkupValue] [decimal](15, 2) NULL,
	[MarkupValueSpecified] [bit] NULL,
	[MarkupPercent] [decimal](15, 2) NULL,
	[MarkupPercentSpecified] [bit] NULL,
	[MarkupIncomeAccountRef_Id] [varchar](4095) NULL,
	[MarkupIncomeAccountRef_Name] [varchar](4095) NULL,
	[CustomField1] [varchar](4095) NULL,
	[CustomField2] [varchar](4095) NULL,
	[CustomField3] [varchar](4095) NULL,
	[CustomField4] [varchar](4095) NULL,
	[CustomField5] [varchar](4095) NULL,
	[CustomField6] [varchar](4095) NULL,
	[CustomField7] [varchar](4095) NULL,
	[CustomField8] [varchar](4095) NULL,
	[CustomField9] [varchar](4095) NULL,
	[CustomField10] [varchar](4095) NULL,
	[SeqNum] [int] NULL,
	[PARENT_GroupID] [varchar](255) NULL,
	[PARENT_ID] [varchar](255) NULL
) ON [PRIMARY]
GO



CREATE TABLE [dbo].[item](
	[Id] [varchar](255) NULL,
	[SyncToken] [varchar](4095) NULL,
	[CreateTime] [datetime] NULL,
	[LastUpdatedTime] [datetime] NULL,
	[Name] [varchar](4095) NULL,
	[FullyQualifiedName] [varchar](4095) NULL,
	[ItemType] [varchar](4095) NULL,
	[TypeSpecified] [bit] NULL,
	[InvStartDate] [datetime] NULL,
	[SubItem] [bit] NULL,
	[SubItemSpecified] [bit] NULL,
	[AbatementRate] [decimal](15, 2) NULL,
	[AbatementRateSpecified] [bit] NULL,
	[ReverseChargeRate] [decimal](15, 2) NULL,
	[ReverseChargeRateSpecified] [bit] NULL,
	[ServiceType] [varchar](4095) NULL,
	[ItemCategoryType] [varchar](4095) NULL,
	[Taxable] [bit] NULL,
	[TaxableSpecified] [bit] NULL,
	[TaxClassificationRef_Id] [varchar](4095) NULL,
	[TaxClassificationRef_Name] [varchar](4095) NULL,
	[PrintGroupedItems] [bit] NULL,
	[ReorderPoint] [decimal](15, 2) NULL,
	[QtyOnPurchaseOrder] [decimal](15, 2) NULL,
	[ManPartNum] [varchar](4095) NULL,
	[DepositToAccountRef_Id] [varchar](4095) NULL,
	[DepositToAccountRef_Name] [varchar](4095) NULL,
	[SalesTaxCodeRef_Id] [varchar](4095) NULL,
	[SalesTaxCodeRef_Name] [varchar](4095) NULL,
	[PurchaseTaxCodeRef_Id] [varchar](4095) NULL,
	[PurchaseTaxCodeRef_Name] [varchar](4095) NULL,
	[InvStartDateSpecified] [bit] NULL,
	[ReorderPointSpecified] [bit] NULL,
	[QtyOnPurchaseOrderSpecified] [bit] NULL,
	[QtyOnSalesOrder] [decimal](15, 2) NULL,
	[QtyOnSalesOrderSpecified] [bit] NULL,
	[QtyOnHand] [decimal](15, 2) NULL,
	[QtyOnHandSpecified] [bit] NULL,
	[TrackQtyOnHandSpecified] [bit] NULL,
	[BuildPoint] [decimal](15, 2) NULL,
	[BuildPointSpecified] [bit] NULL,
	[SalesTaxIncluded] [bit] NULL,
	[SalesTaxIncludedSpecified] [bit] NULL,
	[PrintGroupedItemsSpecified] [bit] NULL,
	[SpecialItemType] [varchar](4095) NULL,
	[SpecialItemTypeSpecified] [bit] NULL,
	[SpecialItem] [bit] NULL,
	[SpecialItemSpecified] [bit] NULL,
	[TrackQtyOnHand] [bit] NULL,
	[AvgCostSpecified] [bit] NULL,
	[AvgCost] [decimal](15, 2) NULL,
	[PrefVendorRef_Id] [varchar](4095) NULL,
	[PrefVendorRef_Name] [varchar](4095) NULL,
	[ParentRef_Id] [varchar](4095) NULL,
	[ParentRef_Name] [varchar](4095) NULL,
	[Active] [bit] NULL,
	[ActiveSpecified] [bit] NULL,
	[Level] [int] NULL,
	[LevelSpecified] [bit] NULL,
	[Description] [varchar](4095) NULL,
	[Sku] [varchar](4095) NULL,
	[PercentBased] [bit] NULL,
	[UQCDisplayText] [varchar](4095) NULL,
	[PercentBasedSpecified] [bit] NULL,
	[UnitPriceSpecified] [bit] NULL,
	[AssetAccountRef_Id] [varchar](4095) NULL,
	[AssetAccountRef_Name] [varchar](4095) NULL,
	[COGSAccountRef_Id] [varchar](4095) NULL,
	[COGSAccountRef_Name] [varchar](4095) NULL,
	[ExpenseAccountRef_Id] [varchar](4095) NULL,
	[ExpenseAccountRef_Name] [varchar](4095) NULL,
	[PurchaseCostSpecified] [bit] NULL,
	[PurchaseCost] [decimal](15, 2) NULL,
	[PurchaseTaxIncludedSpecified] [bit] NULL,
	[PurchaseTaxIncluded] [bit] NULL,
	[PurchaseDesc] [varchar](4095) NULL,
	[IncomeAccountRef_Id] [varchar](4095) NULL,
	[IncomeAccountRef_Name] [varchar](4095) NULL,
	[UOMSetRef_Id] [varchar](4095) NULL,
	[UOMSetRef_Name] [varchar](4095) NULL,
	[PaymentMethodRef_Id] [varchar](4095) NULL,
	[PaymentMethodRef_Name] [varchar](4095) NULL,
	[RatePercentSpecified] [bit] NULL,
	[RatePercent] [decimal](15, 2) NULL,
	[UnitPrice] [decimal](15, 2) NULL,
	[UQCId] [varchar](4095) NULL,
	[UserData] [varchar](4095) NULL,
	[Operation] [varchar](4095) NULL,
	[sparse] [bit] NULL,
	[LSData] [varchar](4095) NULL
) ON [PRIMARY]
GO




CREATE TABLE [dbo].[itemcomponentline](
	[Id] [varchar](255) NULL,
	[ItemRef_Id] [varchar](4095) NULL,
	[ItemRef_Name] [varchar](4095) NULL,
	[ItemType] [varchar](255) NULL,
	[Qty] [decimal](15, 2) NULL,
	[QtySpecified] [bit] NULL,
	[UOMRef_Unit] [varchar](4095) NULL,
	[UOMSetRef_Id] [varchar](4095) NULL,
	[UOMSetRef_Name] [varchar](4095) NULL,
	[SeqNum] [int] NULL,
	[LetSyncId] [bit] NULL,
	[ParentTableType] [varchar](255) NULL,
	[PARENT_ID] [varchar](255) NULL
) ON [PRIMARY]
GO




CREATE TABLE [dbo].[journalentry](
	[Id] [varchar](255) NULL,
	[SyncToken] [varchar](4095) NULL,
	[CreateTime] [datetime] NULL,
	[LastUpdatedTime] [datetime] NULL,
	[Name] [varchar](4095) NULL,
	[TxnDate] [datetime] NULL,
	[TxnDateSpecified] [bit] NULL,
	[PrivateNote] [varchar](4095) NULL,
	[ExchangeRate] [decimal](15, 2) NULL,
	[ExchangeRateSpecified] [bit] NULL,
	[CurrencyRef_Id] [varchar](4095) NULL,
	[CurrencyRef_Name] [varchar](4095) NULL,
	[DepartmentRef_Id] [varchar](4095) NULL,
	[DepartmentRef_Name] [varchar](4095) NULL,
	[DocNumber] [varchar](4095) NULL,
	[TransactionLocationType] [varchar](4095) NULL,
	[Adjustment] [bit] NULL,
	[AdjustmentSpecified] [bit] NULL,
	[HomeCurrencyAdjustment] [bit] NULL,
	[HomeCurrencyAdjustmentSpecified] [bit] NULL,
	[EnteredInHomeCurrency] [bit] NULL,
	[EnteredInHomeCurrencySpecified] [bit] NULL,
	[TotalAmt] [decimal](15, 2) NULL,
	[TotalAmtSpecified] [bit] NULL,
	[HomeTotalAmt] [decimal](15, 2) NULL,
	[HomeTotalAmtSpecified] [bit] NULL,
	[TotalTaxSpecified] [bit] NULL,
	[TotalTax] [decimal](15, 2) NULL,
	[TxnTaxCodeRef_Id] [varchar](4095) NULL,
	[TxnTaxCodeRef_Name] [varchar](4095) NULL,
	[DefaultTaxCodeRef_Id] [varchar](4095) NULL,
	[DefaultTaxCodeRef_Name] [varchar](4095) NULL,
	[UserData] [varchar](4095) NULL,
	[Operation] [varchar](4095) NULL,
	[sparse] [bit] NULL,
	[LSData] [varchar](4095) NULL
) ON [PRIMARY]
GO




CREATE TABLE [dbo].[journalentrylinedetail](
	[Id] [varchar](255) NULL,
	[LineNum] [varchar](4095) NULL,
	[Description] [varchar](4095) NULL,
	[Amount] [decimal](15, 2) NULL,
	[AmountSpecified] [bit] NULL,
	[DetailType] [varchar](4095) NULL,
	[DetailTypeSpecified] [bit] NULL,
	[PostingType] [varchar](4095) NULL,
	[PostingTypeSpecified] [bit] NULL,
	[EntityType] [varchar](4095) NULL,
	[EntityTypeSpecified] [bit] NULL,
	[EntityRef_Id] [varchar](4095) NULL,
	[EntityRef_Name] [varchar](4095) NULL,
	[ServiceDate] [varchar](4095) NULL,
	[ServiceDateSpecified] [datetime] NULL,
	[AccountRef_Id] [varchar](4095) NULL,
	[AccountRef_Name] [varchar](4095) NULL,
	[ClassRef_Id] [varchar](4095) NULL,
	[ClassRef_Name] [varchar](4095) NULL,
	[DepartmentRef_Id] [varchar](4095) NULL,
	[DepartmentRef_Name] [varchar](4095) NULL,
	[ProjectRef_Id] [varchar](4095) NULL,
	[ProjectRef_Name] [varchar](4095) NULL,
	[TaxCodeRef_Id] [varchar](4095) NULL,
	[TaxCodeRef_Name] [varchar](4095) NULL,
	[TaxApplicableOn] [varchar](4095) NULL,
	[TaxApplicableOnSpecified] [bit] NULL,
	[TaxAmount] [decimal](15, 2) NULL,
	[TaxAmountSpecified] [bit] NULL,
	[BillableStatus] [varchar](4095) NULL,
	[BillableStatusSpecified] [bit] NULL,
	[JournalCodeRef_Id] [varchar](4095) NULL,
	[JournalCodeRef_Name] [varchar](4095) NULL,
	[CustomField1] [varchar](4095) NULL,
	[CustomField2] [varchar](4095) NULL,
	[CustomField3] [varchar](4095) NULL,
	[CustomField4] [varchar](4095) NULL,
	[CustomField5] [varchar](4095) NULL,
	[CustomField6] [varchar](4095) NULL,
	[CustomField7] [varchar](4095) NULL,
	[CustomField8] [varchar](4095) NULL,
	[CustomField9] [varchar](4095) NULL,
	[CustomField10] [varchar](4095) NULL,
	[SeqNum] [int] NULL,
	[PARENT_GroupID] [varchar](255) NULL,
	[PARENT_ID] [varchar](255) NULL
) ON [PRIMARY]
GO




CREATE TABLE [dbo].[linkedtxn](
	[TxnId] [varchar](255) NULL,
	[TxnType] [varchar](4095) NULL,
	[TxnLineId] [varchar](4095) NULL,
	[SeqNum] [int] NULL,
	[PARENT_LineID] [varchar](255) NULL,
	[ParentTableType] [varchar](255) NULL,
	[PARENT_ID] [varchar](255) NULL
) ON [PRIMARY]
GO




CREATE TABLE [dbo].[lsologging](
	[Id] [varchar](255) NULL,
	[DateTimeLog] [datetime] NULL,
	[StatusCode] [varchar](4095) NULL,
	[StatusMessage] [varchar](4095) NULL,
	[PossibleSolution] [varchar](4095) NULL,
	[Method] [varchar](4095) NULL,
	[TableName] [varchar](4095) NULL,
	[TaskName] [varchar](4095) NULL,
	[TaskId] [varchar](4095) NULL,
	[CompanyFile] [varchar](4095) NULL,
	[RunBy] [varchar](4095) NULL,
	[SessionId] [varchar](4095) NULL
) ON [PRIMARY]
GO



CREATE TABLE [dbo].[namevalue](
	[Name] [varchar](255) NULL,
	[Value] [varchar](255) NULL,
	[PARENT_ID] [varchar](255) NULL
) ON [PRIMARY]
GO




CREATE TABLE [dbo].[otheraddress](
	[Id] [varchar](255) NULL,
	[Line1] [varchar](4095) NULL,
	[Line2] [varchar](4095) NULL,
	[Line3] [decimal](15, 2) NULL,
	[Line4] [varchar](4095) NULL,
	[Line5] [varchar](4095) NULL,
	[City] [varchar](4095) NULL,
	[PostalCode] [varchar](4095) NULL,
	[PostalCodeSuffix] [varchar](4095) NULL,
	[Country] [varchar](4095) NULL,
	[CountryCode] [varchar](4095) NULL,
	[CountrySubDivisionCode] [varchar](4095) NULL,
	[Note] [varchar](4095) NULL,
	[LongField] [varchar](4095) NULL,
	[Lat] [varchar](4095) NULL,
	[Tag] [varchar](4095) NULL,
	[SeqNum] [int] NULL,
	[LetSyncId] [bit] NULL,
	[ParentTableType] [varchar](255) NULL,
	[PARENT_ID] [varchar](255) NULL
) ON [PRIMARY]
GO



CREATE TABLE [dbo].[otherpreferences](
	[OtherPrefsName] [varchar](4095) NULL,
	[OtherPrefsValue] [varchar](4095) NULL,
	[PARENT_ID] [varchar](255) NULL
) ON [PRIMARY]
GO



CREATE TABLE [dbo].[payment](
	[Id] [varchar](255) NULL,
	[SyncToken] [varchar](4095) NULL,
	[CreateTime] [datetime] NULL,
	[LastUpdatedTime] [datetime] NULL,
	[TxnDate] [datetime] NULL,
	[TxnDateSpecified] [bit] NULL,
	[TaxFormType] [varchar](4095) NULL,
	[TxnStatus] [varchar](4095) NULL,
	[TaxFormNum] [varchar](4095) NULL,
	[DocNumber] [varchar](4095) NULL,
	[PrivateNote] [varchar](4095) NULL,
	[TxnSource] [varchar](4095) NULL,
	[ExchangeRate] [decimal](15, 2) NULL,
	[ExchangeRateSpecified] [bit] NULL,
	[TransactionLocationType] [varchar](4095) NULL,
	[ProcessPayment] [bit] NULL,
	[ProcessPaymentSpecified] [bit] NULL,
	[UnappliedAmt] [decimal](15, 2) NULL,
	[UnappliedAmtSpecified] [bit] NULL,
	[TotalAmt] [decimal](15, 2) NULL,
	[TotalAmtSpecified] [bit] NULL,
	[PaymentTypeSpecified] [bit] NULL,
	[PaymentRefNum] [varchar](4095) NULL,
	[CurrencyRef_Id] [varchar](4095) NULL,
	[CurrencyRef_Name] [varchar](4095) NULL,
	[ProjectRef_Id] [varchar](4095) NULL,
	[ProjectRef_Name] [varchar](4095) NULL,
	[DepartmentRef_Id] [varchar](4095) NULL,
	[DepartmentRef_Name] [varchar](4095) NULL,
	[PaymentMethodRef_Id] [varchar](4095) NULL,
	[PaymentMethodRef_Name] [varchar](4095) NULL,
	[DepositToAccountRef_Id] [varchar](4095) NULL,
	[DepositToAccountRef_Name] [varchar](4095) NULL,
	[ARAccountRef_Id] [varchar](4095) NULL,
	[ARAccountRef_Name] [varchar](4095) NULL,
	[RemitToRef_Id] [varchar](4095) NULL,
	[RemitToRef_Name] [varchar](4095) NULL,
	[CustomerRef_Id] [varchar](4095) NULL,
	[CustomerRef_Name] [varchar](4095) NULL,
	[PaymentType] [varchar](4095) NULL,
	[Check_CheckNum] [varchar](4095) NULL,
	[Check_Status] [varchar](4095) NULL,
	[Check_NameOnAcct] [varchar](4095) NULL,
	[Check_AcctNum] [varchar](4095) NULL,
	[Check_BankName] [varchar](4095) NULL,
	[TotalTaxSpecified] [bit] NULL,
	[TotalTax] [decimal](15, 2) NULL,
	[TxnTaxCodeRef_Id] [varchar](4095) NULL,
	[TxnTaxCodeRef_Name] [varchar](4095) NULL,
	[DefaultTaxCodeRef_Id] [varchar](4095) NULL,
	[DefaultTaxCodeRef_Name] [varchar](4095) NULL,
	[CCAccountRef_Id] [varchar](4095) NULL,
	[CCAccountRef_Name] [varchar](4095) NULL,
	[NameOnAcct] [varchar](4095) NULL,
	[Number] [varchar](4095) NULL,
	[Amount] [decimal](15, 2) NULL,
	[AmountSpecified] [bit] NULL,
	[CCProcessPayment] [bit] NULL,
	[CCProcessPaymentSpecified] [bit] NULL,
	[Type] [varchar](4095) NULL,
	[PostalCode] [varchar](4095) NULL,
	[CcExpiryMonth] [int] NULL,
	[CcExpiryMonthSpecified] [bit] NULL,
	[CcExpiryYear] [int] NULL,
	[CcExpiryYearSpecified] [bit] NULL,
	[BillAddrStreet] [varchar](4095) NULL,
	[CommercialCardCode] [varchar](4095) NULL,
	[CCTxnMode] [varchar](4095) NULL,
	[CCTxnModeSpecified] [bit] NULL,
	[CCTxnType] [varchar](4095) NULL,
	[CCTxnTypeSpecified] [bit] NULL,
	[PrevCCTransId] [varchar](4095) NULL,
	[TxnAuthorizationTime] [datetime] NULL,
	[TxnAuthorizationTimeSpecified] [bit] NULL,
	[TxnAuthorizationStamp] [int] NULL,
	[TxnAuthorizationStampSpecified] [bit] NULL,
	[PaymentGroupingCodeSpecified] [bit] NULL,
	[PaymentGroupingCode] [int] NULL,
	[ReconBatchId] [varchar](4095) NULL,
	[SecurityCode] [varchar](4095) NULL,
	[AvsZipSpecified] [bit] NULL,
	[AvsZip] [varchar](4095) NULL,
	[AvsStreetSpecified] [bit] NULL,
	[AvsStreet] [varchar](4095) NULL,
	[AuthCode] [varchar](4095) NULL,
	[CardSecurityCodeMatch] [varchar](4095) NULL,
	[CardSecurityCodeMatchSpecified] [bit] NULL,
	[MerchantAcctNum] [varchar](4095) NULL,
	[ResultMsg] [varchar](4095) NULL,
	[ResultCodeSpecified] [bit] NULL,
	[ResultCode] [int] NULL,
	[StatusSpecified] [bit] NULL,
	[Status] [varchar](4095) NULL,
	[CCTransId] [varchar](4095) NULL,
	[CCProcessor] [varchar](4095) NULL,
	[ClientTransID] [varchar](4095) NULL,
	[UserData] [varchar](4095) NULL,
	[Operation] [varchar](4095) NULL,
	[sparse] [bit] NULL,
	[LSData] [varchar](4095) NULL
) ON [PRIMARY]
GO


CREATE TABLE [dbo].[paymentlinedetail](
	[Id] [varchar](255) NULL,
	[LineNum] [varchar](4095) NULL,
	[Description] [varchar](4095) NULL,
	[Amount] [decimal](15, 2) NULL,
	[AmountSpecified] [bit] NULL,
	[ItemRef_Id] [varchar](4095) NULL,
	[ItemRef_Name] [varchar](4095) NULL,
	[ServiceDate] [datetime] NULL,
	[ServiceDateSpecified] [bit] NULL,
	[ClassRef_Id] [varchar](4095) NULL,
	[ClassRef_Name] [varchar](4095) NULL,
	[Balance] [decimal](15, 2) NULL,
	[BalanceSpecified] [bit] NULL,
	[HomeBalance] [decimal](15, 2) NULL,
	[HomeBalanceSpecified] [bit] NULL,
	[DiscountRef_Id] [varchar](4095) NULL,
	[DiscountRef_Name] [varchar](4095) NULL,
	[PercentBased] [bit] NULL,
	[PercentBasedSpecified] [bit] NULL,
	[DiscountPercent] [decimal](15, 2) NULL,
	[DiscountPercentSpecified] [bit] NULL,
	[DiscountAccountRef_Id] [varchar](4095) NULL,
	[DiscountAccountRef_Name] [varchar](4095) NULL,
	[CustomField1] [varchar](4095) NULL,
	[CustomField2] [varchar](4095) NULL,
	[CustomField3] [varchar](4095) NULL,
	[CustomField4] [varchar](4095) NULL,
	[CustomField5] [varchar](4095) NULL,
	[CustomField6] [varchar](4095) NULL,
	[CustomField7] [varchar](4095) NULL,
	[CustomField8] [varchar](4095) NULL,
	[CustomField9] [varchar](4095) NULL,
	[CustomField10] [varchar](4095) NULL,
	[SeqNum] [int] NULL,
	[PARENT_GroupID] [varchar](255) NULL,
	[PARENT_ID] [varchar](255) NULL
) ON [PRIMARY]
GO




CREATE TABLE [dbo].[paymentmethod](
	[Id] [varchar](255) NULL,
	[SyncToken] [varchar](4095) NULL,
	[CreateTime] [datetime] NULL,
	[LastUpdatedTime] [datetime] NULL,
	[Name] [varchar](4095) NULL,
	[Active] [bit] NULL,
	[ActiveSpecified] [bit] NULL,
	[Type] [varchar](4095) NULL,
	[UserData] [varchar](4095) NULL,
	[Operation] [varchar](4095) NULL,
	[sparse] [bit] NULL,
	[LSData] [varchar](4095) NULL
) ON [PRIMARY]
GO




CREATE TABLE [dbo].[purchase](
	[Id] [varchar](255) NULL,
	[SyncToken] [varchar](4095) NULL,
	[CreateTime] [datetime] NULL,
	[LastUpdatedTime] [datetime] NULL,
	[Name] [varchar](4095) NULL,
	[Credit] [bit] NULL,
	[TxnId] [varchar](4095) NULL,
	[TxnNum] [varchar](4095) NULL,
	[Memo] [varchar](4095) NULL,
	[TxnDate] [datetime] NULL,
	[TxnDateSpecified] [bit] NULL,
	[DocNumber] [varchar](4095) NULL,
	[TransactionLocationType] [varchar](4095) NULL,
	[ExchangeRate] [decimal](15, 2) NULL,
	[ExchangeRateSpecified] [bit] NULL,
	[PrintStatus] [varchar](4095) NULL,
	[PrintStatusSpecified] [bit] NULL,
	[GlobalTaxCalculation] [varchar](4095) NULL,
	[GlobalTaxCalculationSpecified] [bit] NULL,
	[LessCIS] [decimal](15, 2) NULL,
	[LessCISSpecified] [bit] NULL,
	[TotalAmt] [decimal](15, 2) NULL,
	[TotalAmtSpecified] [bit] NULL,
	[CreditSpecified] [bit] NULL,
	[PaymentType] [varchar](4095) NULL,
	[PaymentTypeSpecified] [bit] NULL,
	[TxnSource] [varchar](4095) NULL,
	[TaxFormType] [varchar](4095) NULL,
	[TxnStatus] [varchar](4095) NULL,
	[TaxFormNum] [varchar](4095) NULL,
	[PrivateNote] [varchar](4095) NULL,
	[PaymentRefNum] [varchar](4095) NULL,
	[CurrencyRef_Id] [varchar](4095) NULL,
	[CurrencyRef_Name] [varchar](4095) NULL,
	[DepartmentRef_Id] [varchar](4095) NULL,
	[DepartmentRef_Name] [varchar](4095) NULL,
	[EntityRef_Id] [varchar](4095) NULL,
	[EntityRef_Name] [varchar](4095) NULL,
	[PaymentMethodRef_Id] [varchar](4095) NULL,
	[PaymentMethodRef_Name] [varchar](4095) NULL,
	[AccountRef_Id] [varchar](4095) NULL,
	[AccountRef_Name] [varchar](4095) NULL,
	[Check_CheckNum] [varchar](4095) NULL,
	[Check_Status] [varchar](4095) NULL,
	[Check_NameOnAcct] [varchar](4095) NULL,
	[Check_AcctNum] [varchar](4095) NULL,
	[Check_BankName] [varchar](4095) NULL,
	[RemitToAddr_Id] [varchar](4095) NULL,
	[RemitToAddr_Line1] [varchar](4095) NULL,
	[RemitToAddr_Line2] [varchar](4095) NULL,
	[RemitToAddr_Line3] [varchar](4095) NULL,
	[RemitToAddr_Line4] [varchar](4095) NULL,
	[RemitToAddr_Line5] [varchar](4095) NULL,
	[RemitToAddr_City] [varchar](4095) NULL,
	[RemitToAddr_Country] [varchar](4095) NULL,
	[RemitToAddr_PostalCode] [varchar](4095) NULL,
	[RemitToAddr_CountryCode] [varchar](4095) NULL,
	[RemitToAddr_CountrySubDivisionCode] [varchar](4095) NULL,
	[RemitToAddr_PostalCodeSuffix] [varchar](4095) NULL,
	[RemitToAddr_Long] [varchar](4095) NULL,
	[RemitToAddr_Lat] [varchar](4095) NULL,
	[RemitToAddr_Note] [varchar](4095) NULL,
	[RemitToAddr_Tag] [varchar](4095) NULL,
	[TotalTaxSpecified] [bit] NULL,
	[TotalTax] [decimal](15, 2) NULL,
	[TxnTaxCodeRef_Id] [varchar](4095) NULL,
	[TxnTaxCodeRef_Name] [varchar](4095) NULL,
	[DefaultTaxCodeRef_Id] [varchar](4095) NULL,
	[DefaultTaxCodeRef_Name] [varchar](4095) NULL,
	[CCAccountRef_Id] [varchar](4095) NULL,
	[CCAccountRef_Name] [varchar](4095) NULL,
	[NameOnAcct] [varchar](4095) NULL,
	[Number] [varchar](4095) NULL,
	[Amount] [decimal](15, 2) NULL,
	[AmountSpecified] [bit] NULL,
	[ProcessPayment] [bit] NULL,
	[Type] [varchar](4095) NULL,
	[PostalCode] [varchar](4095) NULL,
	[CcExpiryMonth] [int] NULL,
	[CcExpiryMonthSpecified] [bit] NULL,
	[CcExpiryYear] [int] NULL,
	[CcExpiryYearSpecified] [bit] NULL,
	[BillAddrStreet] [varchar](4095) NULL,
	[CommercialCardCode] [varchar](4095) NULL,
	[ProcessPaymentSpecified] [bit] NULL,
	[CCTxnMode] [varchar](4095) NULL,
	[CCTxnModeSpecified] [bit] NULL,
	[CCTxnType] [varchar](4095) NULL,
	[CCTxnTypeSpecified] [bit] NULL,
	[PrevCCTransId] [varchar](4095) NULL,
	[TxnAuthorizationTime] [datetime] NULL,
	[TxnAuthorizationTimeSpecified] [bit] NULL,
	[TxnAuthorizationStamp] [int] NULL,
	[TxnAuthorizationStampSpecified] [bit] NULL,
	[PaymentGroupingCodeSpecified] [bit] NULL,
	[PaymentGroupingCode] [int] NULL,
	[ReconBatchId] [varchar](4095) NULL,
	[SecurityCode] [varchar](4095) NULL,
	[AvsZipSpecified] [bit] NULL,
	[AvsZip] [varchar](4095) NULL,
	[AvsStreetSpecified] [bit] NULL,
	[AvsStreet] [varchar](4095) NULL,
	[AuthCode] [varchar](4095) NULL,
	[CardSecurityCodeMatch] [varchar](4095) NULL,
	[CardSecurityCodeMatchSpecified] [bit] NULL,
	[MerchantAcctNum] [varchar](4095) NULL,
	[ResultMsg] [varchar](4095) NULL,
	[ResultCodeSpecified] [bit] NULL,
	[ResultCode] [int] NULL,
	[StatusSpecified] [bit] NULL,
	[Status] [varchar](4095) NULL,
	[CCTransId] [varchar](4095) NULL,
	[CCProcessor] [varchar](4095) NULL,
	[ClientTransID] [varchar](4095) NULL,
	[CustomField1] [varchar](4095) NULL,
	[CustomField2] [varchar](4095) NULL,
	[CustomField3] [varchar](4095) NULL,
	[CustomField4] [varchar](4095) NULL,
	[CustomField5] [varchar](4095) NULL,
	[CustomField6] [varchar](4095) NULL,
	[CustomField7] [varchar](4095) NULL,
	[CustomField8] [varchar](4095) NULL,
	[CustomField9] [varchar](4095) NULL,
	[CustomField10] [varchar](4095) NULL,
	[UserData] [varchar](4095) NULL,
	[Operation] [varchar](4095) NULL,
	[sparse] [bit] NULL,
	[LSData] [varchar](4095) NULL
) ON [PRIMARY]
GO




CREATE TABLE [dbo].[purchaselinedetail](
	[Id] [varchar](255) NULL,
	[LineNum] [varchar](4095) NULL,
	[Description] [varchar](4095) NULL,
	[Amount] [decimal](15, 2) NULL,
	[AmountSpecified] [bit] NULL,
	[DetailType] [varchar](4095) NULL,
	[DetailTypeSpecified] [bit] NULL,
	[ItemRef_Id] [varchar](4095) NULL,
	[ItemRef_Name] [varchar](4095) NULL,
	[ClassRef_Id] [varchar](4095) NULL,
	[ClassRef_Name] [varchar](4095) NULL,
	[PriceLevelRef_Id] [varchar](4095) NULL,
	[PriceLevelRef_Name] [varchar](4095) NULL,
	[RatePercent] [decimal](15, 2) NULL,
	[UnitPrice] [decimal](15, 2) NULL,
	[Qty] [decimal](15, 2) NULL,
	[QtySpecified] [bit] NULL,
	[UOMSetRef_Unit] [varchar](4095) NULL,
	[UOMSetRef_Id] [varchar](4095) NULL,
	[UOMSetRef_Name] [varchar](4095) NULL,
	[ItemAccountRef_Id] [varchar](4095) NULL,
	[ItemAccountRef_Name] [varchar](4095) NULL,
	[InventorySiteRef_Id] [varchar](4095) NULL,
	[InventorySiteRef_Name] [varchar](4095) NULL,
	[TaxCodeRef_Id] [varchar](4095) NULL,
	[TaxCodeRef_Name] [varchar](4095) NULL,
	[TaxClassificationRef_Id] [varchar](4095) NULL,
	[TaxClassificationRef_Name] [varchar](4095) NULL,
	[CustomerRef_Id] [varchar](4095) NULL,
	[CustomerRef_Name] [varchar](4095) NULL,
	[BillableStatus] [varchar](4095) NULL,
	[BillableStatusSpecified] [bit] NULL,
	[TaxInclusiveAmt] [decimal](15, 2) NULL,
	[TaxInclusiveAmtSpecified] [bit] NULL,
	[AccountRef_Id] [varchar](4095) NULL,
	[AccountRef_Name] [varchar](4095) NULL,
	[TaxAmount] [decimal](15, 2) NULL,
	[TaxAmountSpecified] [bit] NULL,
	[MarkupPercentBased] [bit] NULL,
	[MarkupPercentBasedSpecified] [bit] NULL,
	[MarkupValue] [decimal](15, 2) NULL,
	[MarkupValueSpecified] [bit] NULL,
	[MarkupPercent] [decimal](15, 2) NULL,
	[MarkupPercentSpecified] [bit] NULL,
	[MarkupPriceLevelRef_Id] [varchar](4095) NULL,
	[MarkupPriceLevelRef_Name] [varchar](4095) NULL,
	[MarkupIncomeAccountRef_Id] [varchar](4095) NULL,
	[MarkupIncomeAccountRef_Name] [varchar](4095) NULL,
	[CustomField1] [varchar](4095) NULL,
	[CustomField2] [varchar](4095) NULL,
	[CustomField3] [varchar](4095) NULL,
	[CustomField4] [varchar](4095) NULL,
	[CustomField5] [varchar](4095) NULL,
	[CustomField6] [varchar](4095) NULL,
	[CustomField7] [varchar](4095) NULL,
	[CustomField8] [varchar](4095) NULL,
	[CustomField9] [varchar](4095) NULL,
	[CustomField10] [varchar](4095) NULL,
	[SeqNum] [int] NULL,
	[PARENT_GroupID] [varchar](255) NULL,
	[PARENT_ID] [varchar](255) NULL
) ON [PRIMARY]
GO




CREATE TABLE [dbo].[purchaseorder](
	[Id] [varchar](255) NULL,
	[SyncToken] [varchar](4095) NULL,
	[CreateTime] [datetime] NULL,
	[LastUpdatedTime] [datetime] NULL,
	[Name] [varchar](4095) NULL,
	[DocNumber] [varchar](4095) NULL,
	[TxnDate] [datetime] NULL,
	[TxnDateSpecified] [bit] NULL,
	[DueDate] [datetime] NULL,
	[DueDateSpecified] [bit] NULL,
	[ExpectedDate] [datetime] NULL,
	[ExpectedDateSpecified] [bit] NULL,
	[TaxFormType] [varchar](4095) NULL,
	[TxnSource] [varchar](4095) NULL,
	[TxnStatus] [varchar](4095) NULL,
	[TaxFormNum] [varchar](4095) NULL,
	[PrivateNote] [varchar](4095) NULL,
	[CurrencyRef_Id] [varchar](4095) NULL,
	[CurrencyRef_Name] [varchar](4095) NULL,
	[ShipMethodRef_Id] [varchar](4095) NULL,
	[ShipMethodRef_Name] [varchar](4095) NULL,
	[SalesTermRef_Id] [varchar](4095) NULL,
	[SalesTermRef_Name] [varchar](4095) NULL,
	[ClassRef_Id] [varchar](4095) NULL,
	[ClassRef_Name] [varchar](4095) NULL,
	[TaxCodeRef_Id] [varchar](4095) NULL,
	[TaxCodeRef_Name] [varchar](4095) NULL,
	[ReimbursableInfoRef_Id] [varchar](4095) NULL,
	[ReimbursableInfoRef_Name] [varchar](4095) NULL,
	[TemplateRef_Id] [varchar](4095) NULL,
	[TemplateRef_Name] [varchar](4095) NULL,
	[APAccountRef_Id] [varchar](4095) NULL,
	[APAccountRef_Name] [varchar](4095) NULL,
	[DropShipToEntity_Id] [varchar](4095) NULL,
	[DropShipToEntity_Name] [varchar](4095) NULL,
	[InventorySiteRef_Id] [varchar](4095) NULL,
	[InventorySiteRef_Name] [varchar](4095) NULL,
	[VendorRef_Id] [varchar](4095) NULL,
	[VendorRef_Name] [varchar](4095) NULL,
	[DepartmentRef_Id] [varchar](4095) NULL,
	[DepartmentRef_Name] [varchar](4095) NULL,
	[TransactionLocationType] [varchar](4095) NULL,
	[ExchangeRate] [decimal](15, 2) NULL,
	[ExchangeRateSpecified] [bit] NULL,
	[POStatusSpecified] [bit] NULL,
	[FOB] [varchar](4095) NULL,
	[POEmailAddress] [varchar](4095) NULL,
	[PrintStatus] [varchar](4095) NULL,
	[PrintStatusSpecified] [bit] NULL,
	[BillEmail] [varchar](4095) NULL,
	[ReplyEmail] [varchar](4095) NULL,
	[EmailStatus] [varchar](4095) NULL,
	[EmailStatusSpecified] [bit] NULL,
	[ManuallyClosed] [bit] NULL,
	[ManuallyClosedSpecified] [bit] NULL,
	[TotalAmt] [decimal](15, 2) NULL,
	[TotalAmtSpecified] [bit] NULL,
	[Memo] [varchar](4095) NULL,
	[GlobalTaxCalculation] [varchar](4095) NULL,
	[GlobalTaxCalculationSpecified] [bit] NULL,
	[POStatus] [varchar](4095) NULL,
	[ShipAddr_Id] [varchar](4095) NULL,
	[ShipAddr_Line1] [varchar](4095) NULL,
	[ShipAddr_Line2] [varchar](4095) NULL,
	[ShipAddr_Line3] [varchar](4095) NULL,
	[ShipAddr_Line4] [varchar](4095) NULL,
	[ShipAddr_Line5] [varchar](4095) NULL,
	[ShipAddr_City] [varchar](4095) NULL,
	[ShipAddr_Country] [varchar](4095) NULL,
	[ShipAddr_PostalCode] [varchar](4095) NULL,
	[ShipAddr_CountryCode] [varchar](4095) NULL,
	[ShipAddr_CountrySubDivisionCode] [varchar](4095) NULL,
	[ShipAddr_PostalCodeSuffix] [varchar](4095) NULL,
	[ShipAddr_Long] [varchar](4095) NULL,
	[ShipAddr_Lat] [varchar](4095) NULL,
	[ShipAddr_Note] [varchar](4095) NULL,
	[ShipAddr_Tag] [varchar](4095) NULL,
	[VendorAddr_Id] [varchar](4095) NULL,
	[VendorAddr_Line1] [varchar](4095) NULL,
	[VendorAddr_Line2] [varchar](4095) NULL,
	[VendorAddr_Line3] [varchar](4095) NULL,
	[VendorAddr_Line4] [varchar](4095) NULL,
	[VendorAddr_Line5] [varchar](4095) NULL,
	[VendorAddr_City] [varchar](4095) NULL,
	[VendorAddr_Country] [varchar](4095) NULL,
	[VendorAddr_PostalCode] [varchar](4095) NULL,
	[VendorAddr_CountryCode] [varchar](4095) NULL,
	[VendorAddr_CountrySubDivisionCode] [varchar](4095) NULL,
	[VendorAddr_PostalCodeSuffix] [varchar](4095) NULL,
	[VendorAddr_Long] [varchar](4095) NULL,
	[VendorAddr_Lat] [varchar](4095) NULL,
	[VendorAddr_Note] [varchar](4095) NULL,
	[VendorAddr_Tag] [varchar](4095) NULL,
	[TotalTaxSpecified] [bit] NULL,
	[TotalTax] [decimal](15, 2) NULL,
	[TxnTaxCodeRef_Id] [varchar](4095) NULL,
	[TxnTaxCodeRef_Name] [varchar](4095) NULL,
	[DefaultTaxCodeRef_Id] [varchar](4095) NULL,
	[DefaultTaxCodeRef_Name] [varchar](4095) NULL,
	[CustomField1] [varchar](4095) NULL,
	[CustomField2] [varchar](4095) NULL,
	[CustomField3] [varchar](4095) NULL,
	[CustomField4] [varchar](4095) NULL,
	[CustomField5] [varchar](4095) NULL,
	[CustomField6] [varchar](4095) NULL,
	[CustomField7] [varchar](4095) NULL,
	[CustomField8] [varchar](4095) NULL,
	[CustomField9] [varchar](4095) NULL,
	[CustomField10] [varchar](4095) NULL,
	[UserData] [varchar](4095) NULL,
	[Operation] [varchar](4095) NULL,
	[sparse] [bit] NULL,
	[LSData] [varchar](4095) NULL
) ON [PRIMARY]
GO




CREATE TABLE [dbo].[purchaseorderlinedetail](
	[Id] [varchar](255) NULL,
	[LineNum] [varchar](4095) NULL,
	[Description] [varchar](4095) NULL,
	[Amount] [decimal](15, 2) NULL,
	[AmountSpecified] [bit] NULL,
	[DetailType] [varchar](4095) NULL,
	[DetailTypeSpecified] [bit] NULL,
	[ItemRef_Id] [varchar](4095) NULL,
	[ItemRef_Name] [varchar](4095) NULL,
	[ClassRef_Id] [varchar](4095) NULL,
	[ClassRef_Name] [varchar](4095) NULL,
	[PriceLevelRef_Id] [varchar](4095) NULL,
	[PriceLevelRef_Name] [varchar](4095) NULL,
	[RatePercent] [decimal](15, 2) NULL,
	[UnitPrice] [decimal](15, 2) NULL,
	[Qty] [decimal](15, 2) NULL,
	[QtySpecified] [bit] NULL,
	[UOMSetRef_Unit] [varchar](4095) NULL,
	[UOMSetRef_Id] [varchar](4095) NULL,
	[UOMSetRef_Name] [varchar](4095) NULL,
	[ItemAccountRef_Id] [varchar](4095) NULL,
	[ItemAccountRef_Name] [varchar](4095) NULL,
	[InventorySiteRef_Id] [varchar](4095) NULL,
	[InventorySiteRef_Name] [varchar](4095) NULL,
	[TaxCodeRef_Id] [varchar](4095) NULL,
	[TaxCodeRef_Name] [varchar](4095) NULL,
	[TaxClassificationRef_Id] [varchar](4095) NULL,
	[TaxClassificationRef_Name] [varchar](4095) NULL,
	[CustomerRef_Id] [varchar](4095) NULL,
	[CustomerRef_Name] [varchar](4095) NULL,
	[BillableStatus] [varchar](4095) NULL,
	[BillableStatusSpecified] [bit] NULL,
	[TaxInclusiveAmt] [decimal](15, 2) NULL,
	[TaxInclusiveAmtSpecified] [bit] NULL,
	[AccountRef_Id] [varchar](4095) NULL,
	[AccountRef_Name] [varchar](4095) NULL,
	[TaxAmount] [decimal](15, 2) NULL,
	[TaxAmountSpecified] [bit] NULL,
	[MarkupPercentBased] [bit] NULL,
	[MarkupPercentBasedSpecified] [bit] NULL,
	[MarkupValue] [decimal](15, 2) NULL,
	[MarkupValueSpecified] [bit] NULL,
	[MarkupPercent] [decimal](15, 2) NULL,
	[MarkupPercentSpecified] [bit] NULL,
	[MarkupPriceLevelRef_Id] [varchar](4095) NULL,
	[MarkupPriceLevelRef_Name] [varchar](4095) NULL,
	[MarkupIncomeAccountRef_Id] [varchar](4095) NULL,
	[MarkupIncomeAccountRef_Name] [varchar](4095) NULL,
	[CustomField1] [varchar](4095) NULL,
	[CustomField2] [varchar](4095) NULL,
	[CustomField3] [varchar](4095) NULL,
	[CustomField4] [varchar](4095) NULL,
	[CustomField5] [varchar](4095) NULL,
	[CustomField6] [varchar](4095) NULL,
	[CustomField7] [varchar](4095) NULL,
	[CustomField8] [varchar](4095) NULL,
	[CustomField9] [varchar](4095) NULL,
	[CustomField10] [varchar](4095) NULL,
	[SeqNum] [int] NULL,
	[PARENT_GroupID] [varchar](255) NULL,
	[PARENT_ID] [varchar](255) NULL
) ON [PRIMARY]
GO




CREATE TABLE [dbo].[refundreceipt](
	[Id] [varchar](255) NULL,
	[SyncToken] [varchar](4095) NULL,
	[CreateTime] [datetime] NULL,
	[LastUpdatedTime] [datetime] NULL,
	[Name] [varchar](4095) NULL,
	[TxnDate] [datetime] NULL,
	[TxnDateSpecified] [bit] NULL,
	[DueDate] [datetime] NULL,
	[DueDateSpecified] [bit] NULL,
	[ShipDate] [datetime] NULL,
	[ShipDateSpecified] [bit] NULL,
	[DeliveryType] [varchar](4095) NULL,
	[DeliveryTypeSpecified] [bit] NULL,
	[DeliveryTime] [datetime] NULL,
	[DeliveryTimeSpecified] [bit] NULL,
	[DeliveryErrorType] [varchar](4095) NULL,
	[DeliveryErrorTypeSpecified] [bit] NULL,
	[PrintStatus] [varchar](4095) NULL,
	[PrintStatusSpecified] [bit] NULL,
	[BillEmailAddress] [varchar](4095) NULL,
	[BillEmailAddressCc] [varchar](4095) NULL,
	[BillEmailAddressBcc] [varchar](4095) NULL,
	[EmailStatusSpecified] [bit] NULL,
	[PrivateNote] [varchar](4095) NULL,
	[TxnSource] [varchar](4095) NULL,
	[TransactionLocationType] [varchar](4095) NULL,
	[DocNumber] [varchar](4095) NULL,
	[TrackingNum] [varchar](4095) NULL,
	[FOB] [varchar](4095) NULL,
	[PONumber] [varchar](4095) NULL,
	[GovtTxnRefIdentifier] [varchar](4095) NULL,
	[FreeFormAddress] [bit] NULL,
	[FreeFormAddressSpecified] [bit] NULL,
	[ExchangeRate] [decimal](15, 2) NULL,
	[ExchangeRateSpecified] [bit] NULL,
	[Balance] [decimal](15, 2) NULL,
	[BalanceSpecified] [bit] NULL,
	[HomeBalance] [decimal](15, 2) NULL,
	[HomeBalanceSpecified] [bit] NULL,
	[PaymentRefNum] [varchar](4095) NULL,
	[PaymentType] [varchar](4095) NULL,
	[PaymentTypeSpecified] [bit] NULL,
	[ApplyTaxAfterDiscount] [bit] NULL,
	[ApplyTaxAfterDiscountSpecified] [bit] NULL,
	[DiscountRate] [decimal](15, 2) NULL,
	[DiscountRateSpecified] [bit] NULL,
	[DiscountAmt] [decimal](15, 2) NULL,
	[DiscountAmtSpecified] [bit] NULL,
	[AutoDocNumber] [bit] NULL,
	[AutoDocNumberSpecified] [bit] NULL,
	[CustomerMemo] [varchar](4095) NULL,
	[GlobalTaxCalculation] [varchar](4095) NULL,
	[GlobalTaxCalculationSpecified] [bit] NULL,
	[HomeTotalAmt] [decimal](15, 2) NULL,
	[HomeTotalAmtSpecified] [bit] NULL,
	[FinanceCharge] [decimal](15, 2) NULL,
	[FinanceChargeSpecified] [bit] NULL,
	[TotalAmt] [decimal](15, 2) NULL,
	[TotalAmtSpecified] [bit] NULL,
	[CurrencyRef_Id] [varchar](4095) NULL,
	[CurrencyRef_Name] [varchar](4095) NULL,
	[DepartmentRef_Id] [varchar](4095) NULL,
	[DepartmentRef_Name] [varchar](4095) NULL,
	[PaymentMethodRef_Id] [varchar](4095) NULL,
	[PaymentMethodRef_Name] [varchar](4095) NULL,
	[DepositToAccountRef_Id] [varchar](4095) NULL,
	[DepositToAccountRef_Name] [varchar](4095) NULL,
	[CustomerRef_Id] [varchar](4095) NULL,
	[CustomerRef_Name] [varchar](4095) NULL,
	[ClassRef_Id] [varchar](4095) NULL,
	[ClassRef_Name] [varchar](4095) NULL,
	[TaxExemptionRef_Id] [varchar](4095) NULL,
	[TaxExemptionRef_Name] [varchar](4095) NULL,
	[ShipMethodRef_Id] [varchar](4095) NULL,
	[ShipMethodRef_Name] [varchar](4095) NULL,
	[RemitToRef_Id] [varchar](4095) NULL,
	[RemitToRef_Name] [varchar](4095) NULL,
	[TemplateRef_Id] [varchar](4095) NULL,
	[TemplateRef_Name] [varchar](4095) NULL,
	[SalesTermRef_Id] [varchar](4095) NULL,
	[SalesTermRef_Name] [varchar](4095) NULL,
	[SalesRepRef_Id] [varchar](4095) NULL,
	[SalesRepRef_Name] [varchar](4095) NULL,
	[RemainingCredit] [decimal](15, 2) NULL,
	[RemainingCreditSpecified] [bit] NULL,
	[Check_CheckNum] [varchar](4095) NULL,
	[Check_Status] [varchar](4095) NULL,
	[Check_NameOnAcct] [varchar](4095) NULL,
	[Check_AcctNum] [varchar](4095) NULL,
	[Check_BankName] [varchar](4095) NULL,
	[TotalTaxSpecified] [bit] NULL,
	[TotalTax] [decimal](15, 2) NULL,
	[TxnTaxCodeRef_Id] [varchar](4095) NULL,
	[TxnTaxCodeRef_Name] [varchar](4095) NULL,
	[DefaultTaxCodeRef_Id] [varchar](4095) NULL,
	[DefaultTaxCodeRef_Name] [varchar](4095) NULL,
	[CCAccountRef_Id] [varchar](4095) NULL,
	[CCAccountRef_Name] [varchar](4095) NULL,
	[NameOnAcct] [varchar](4095) NULL,
	[Number] [varchar](4095) NULL,
	[Amount] [decimal](15, 2) NULL,
	[AmountSpecified] [bit] NULL,
	[ProcessPayment] [bit] NULL,
	[Type] [varchar](4095) NULL,
	[PostalCode] [varchar](4095) NULL,
	[CcExpiryMonth] [int] NULL,
	[CcExpiryMonthSpecified] [bit] NULL,
	[CcExpiryYear] [int] NULL,
	[CcExpiryYearSpecified] [bit] NULL,
	[BillAddrStreet] [varchar](4095) NULL,
	[CommercialCardCode] [varchar](4095) NULL,
	[ProcessPaymentSpecified] [bit] NULL,
	[CCTxnMode] [varchar](4095) NULL,
	[CCTxnModeSpecified] [bit] NULL,
	[CCTxnType] [varchar](4095) NULL,
	[CCTxnTypeSpecified] [bit] NULL,
	[PrevCCTransId] [varchar](4095) NULL,
	[TxnAuthorizationTime] [datetime] NULL,
	[TxnAuthorizationTimeSpecified] [bit] NULL,
	[TxnAuthorizationStamp] [int] NULL,
	[TxnAuthorizationStampSpecified] [bit] NULL,
	[PaymentGroupingCodeSpecified] [bit] NULL,
	[PaymentGroupingCode] [int] NULL,
	[ReconBatchId] [varchar](4095) NULL,
	[SecurityCode] [varchar](4095) NULL,
	[AvsZipSpecified] [bit] NULL,
	[AvsZip] [varchar](4095) NULL,
	[AvsStreetSpecified] [bit] NULL,
	[AvsStreet] [varchar](4095) NULL,
	[AuthCode] [varchar](4095) NULL,
	[CardSecurityCodeMatch] [varchar](4095) NULL,
	[CardSecurityCodeMatchSpecified] [bit] NULL,
	[MerchantAcctNum] [varchar](4095) NULL,
	[ResultMsg] [varchar](4095) NULL,
	[ResultCodeSpecified] [bit] NULL,
	[ResultCode] [int] NULL,
	[StatusSpecified] [bit] NULL,
	[Status] [varchar](4095) NULL,
	[CCTransId] [varchar](4095) NULL,
	[CCProcessor] [varchar](4095) NULL,
	[ClientTransID] [varchar](4095) NULL,
	[BillAddr_Id] [varchar](4095) NULL,
	[BillAddr_Line1] [varchar](4095) NULL,
	[BillAddr_Line2] [varchar](4095) NULL,
	[BillAddr_Line3] [varchar](4095) NULL,
	[BillAddr_Line4] [varchar](4095) NULL,
	[BillAddr_Line5] [varchar](4095) NULL,
	[BillAddr_PostalCode] [varchar](4095) NULL,
	[BillAddr_City] [varchar](4095) NULL,
	[BillAddr_Country] [varchar](4095) NULL,
	[BillAddr_Lat] [varchar](4095) NULL,
	[BillAddr_Long] [varchar](4095) NULL,
	[BillAddr_Note] [varchar](4095) NULL,
	[BillAddr_Tag] [varchar](4095) NULL,
	[BillAddr_CountryCode] [varchar](4095) NULL,
	[BillAddr_CountrySubDivisionCode] [varchar](4095) NULL,
	[ShipFromAddr_Id] [varchar](4095) NULL,
	[ShipFromAddr_Line1] [varchar](4095) NULL,
	[ShipFromAddr_Line2] [varchar](4095) NULL,
	[ShipFromAddr_Line3] [varchar](4095) NULL,
	[ShipFromAddr_Line4] [varchar](4095) NULL,
	[ShipFromAddr_Line5] [varchar](4095) NULL,
	[ShipFromAddr_PostalCode] [varchar](4095) NULL,
	[ShipFromAddr_City] [varchar](4095) NULL,
	[ShipFromAddr_Country] [varchar](4095) NULL,
	[ShipFromAddr_Lat] [varchar](4095) NULL,
	[ShipFromAddr_Long] [varchar](4095) NULL,
	[ShipFromAddr_Note] [varchar](4095) NULL,
	[ShipFromAddr_Tag] [varchar](4095) NULL,
	[ShipFromAddr_CountryCode] [varchar](4095) NULL,
	[ShipFromAddr_CountrySubDivisionCode] [varchar](4095) NULL,
	[ShipAddr_Id] [varchar](4095) NULL,
	[ShipAddr_Line1] [varchar](4095) NULL,
	[ShipAddr_Line2] [varchar](4095) NULL,
	[ShipAddr_Line3] [varchar](4095) NULL,
	[ShipAddr_Line4] [varchar](4095) NULL,
	[ShipAddr_Line5] [varchar](4095) NULL,
	[ShipAddr_PostalCode] [varchar](4095) NULL,
	[ShipAddr_City] [varchar](4095) NULL,
	[ShipAddr_Country] [varchar](4095) NULL,
	[ShipAddr_Lat] [varchar](4095) NULL,
	[ShipAddr_Long] [varchar](4095) NULL,
	[ShipAddr_Note] [varchar](4095) NULL,
	[ShipAddr_Tag] [varchar](4095) NULL,
	[ShipAddr_CountryCode] [varchar](4095) NULL,
	[ShipAddr_CountrySubDivisionCode] [varchar](4095) NULL,
	[CustomField1] [varchar](4095) NULL,
	[CustomField2] [varchar](4095) NULL,
	[CustomField3] [varchar](4095) NULL,
	[CustomField4] [varchar](4095) NULL,
	[CustomField5] [varchar](4095) NULL,
	[CustomField6] [varchar](4095) NULL,
	[CustomField7] [varchar](4095) NULL,
	[CustomField8] [varchar](4095) NULL,
	[CustomField9] [varchar](4095) NULL,
	[CustomField10] [varchar](4095) NULL,
	[UserData] [varchar](4095) NULL,
	[Operation] [varchar](4095) NULL,
	[sparse] [bit] NULL,
	[LSData] [varchar](4095) NULL
) ON [PRIMARY]
GO




CREATE TABLE [dbo].[refundreceiptlinedetail](
	[Id] [varchar](255) NULL,
	[LineNum] [varchar](4095) NULL,
	[Description] [varchar](4095) NULL,
	[Amount] [decimal](15, 2) NULL,
	[AmountSpecified] [bit] NULL,
	[DetailType] [varchar](4095) NULL,
	[DetailTypeSpecified] [bit] NULL,
	[PriceLevelRef_Id] [varchar](4095) NULL,
	[PriceLevelRef_Name] [varchar](4095) NULL,
	[RatePercent] [decimal](15, 2) NULL,
	[UnitPrice] [decimal](15, 2) NULL,
	[TaxInclusiveAmt] [decimal](15, 2) NULL,
	[TaxInclusiveAmtSpecified] [bit] NULL,
	[DiscountAmt] [decimal](15, 2) NULL,
	[DiscountAmtSpecified] [bit] NULL,
	[ServiceDate] [datetime] NULL,
	[ServiceDateSpecified] [bit] NULL,
	[DiscountRate] [decimal](15, 2) NULL,
	[DiscountRateSpecified] [bit] NULL,
	[TaxClassificationRef_Id] [varchar](4095) NULL,
	[TaxClassificationRef_Name] [varchar](4095) NULL,
	[ItemAccountRef_Id] [varchar](4095) NULL,
	[ItemAccountRef_Name] [varchar](4095) NULL,
	[InventorySiteRef_Id] [varchar](4095) NULL,
	[InventorySiteRef_Name] [varchar](4095) NULL,
	[TaxCodeRef_Id] [varchar](4095) NULL,
	[TaxCodeRef_Name] [varchar](4095) NULL,
	[ClassRef_Id] [varchar](4095) NULL,
	[ClassRef_Name] [varchar](4095) NULL,
	[ItemRef_Id] [varchar](4095) NULL,
	[ItemRef_Name] [varchar](4095) NULL,
	[UOMUnit] [varchar](4095) NULL,
	[UOMSetRef_Id] [varchar](4095) NULL,
	[UOMSetRef_Name] [varchar](4095) NULL,
	[Qty] [decimal](15, 2) NULL,
	[QtySpecified] [bit] NULL,
	[GroupItemRef_Id] [varchar](4095) NULL,
	[GroupItemRef_Name] [varchar](4095) NULL,
	[DiscountAccountRef_Id] [varchar](4095) NULL,
	[DiscountAccountRef_Name] [varchar](4095) NULL,
	[DiscountRef_Id] [varchar](4095) NULL,
	[DiscountRef_Name] [varchar](4095) NULL,
	[DiscountPercent] [decimal](15, 2) NULL,
	[DiscountPercentSpecified] [bit] NULL,
	[PercentBased] [bit] NULL,
	[PercentBasedSpecified] [bit] NULL,
	[MarkupPercentBased] [bit] NULL,
	[MarkupPercentBasedSpecified] [bit] NULL,
	[MarkupPriceLevelRef_Id] [varchar](4095) NULL,
	[MarkupPriceLevelRef_Name] [varchar](4095) NULL,
	[MarkupValue] [decimal](15, 2) NULL,
	[MarkupValueSpecified] [bit] NULL,
	[MarkupPercent] [decimal](15, 2) NULL,
	[MarkupPercentSpecified] [bit] NULL,
	[MarkupIncomeAccountRef_Id] [varchar](4095) NULL,
	[MarkupIncomeAccountRef_Name] [varchar](4095) NULL,
	[CustomField1] [varchar](4095) NULL,
	[CustomField2] [varchar](4095) NULL,
	[CustomField3] [varchar](4095) NULL,
	[CustomField4] [varchar](4095) NULL,
	[CustomField5] [varchar](4095) NULL,
	[CustomField6] [varchar](4095) NULL,
	[CustomField7] [varchar](4095) NULL,
	[CustomField8] [varchar](4095) NULL,
	[CustomField9] [varchar](4095) NULL,
	[CustomField10] [varchar](4095) NULL,
	[SeqNum] [int] NULL,
	[PARENT_GroupID] [varchar](255) NULL,
	[PARENT_ID] [varchar](255) NULL
) ON [PRIMARY]
GO



CREATE TABLE [dbo].[reimbursecharge](
	[Id] [varchar](255) NULL,
	[SyncToken] [varchar](4095) NULL,
	[CreateTime] [datetime] NULL,
	[LastUpdatedTime] [datetime] NULL,
	[Name] [varchar](4095) NULL,
	[TxnDate] [datetime] NULL,
	[TxnDateSpecified] [bit] NULL,
	[ExchangeRate] [decimal](15, 2) NULL,
	[ExchangeRateSpecified] [bit] NULL,
	[Amount] [decimal](15, 2) NULL,
	[AmountSpecified] [bit] NULL,
	[CustomerRef_Id] [varchar](4095) NULL,
	[CustomerRef_Name] [varchar](4095) NULL,
	[CurrencyRef_Id] [varchar](4095) NULL,
	[CurrencyRef_Name] [varchar](4095) NULL,
	[PrivateNote] [varchar](4095) NULL,
	[UserData] [varchar](4095) NULL,
	[Operation] [varchar](4095) NULL,
	[sparse] [bit] NULL,
	[LSData] [varchar](4095) NULL
) ON [PRIMARY]
GO




CREATE TABLE [dbo].[reimburselinedetail](
	[Id] [varchar](255) NULL,
	[LineNum] [varchar](4095) NULL,
	[Description] [varchar](4095) NULL,
	[Amount] [decimal](15, 2) NULL,
	[AmountSpecified] [bit] NULL,
	[DetailType] [varchar](4095) NULL,
	[DetailTypeSpecified] [bit] NULL,
	[ClassRef_Id] [varchar](4095) NULL,
	[ClassRef_Name] [varchar](4095) NULL,
	[TaxCodeRef_Id] [varchar](4095) NULL,
	[TaxCodeRef_Name] [varchar](4095) NULL,
	[TaxClassificationRef_Id] [varchar](4095) NULL,
	[TaxClassificationRef_Name] [varchar](4095) NULL,
	[ItemAccountRef_Id] [varchar](4095) NULL,
	[ItemAccountRef_Name] [varchar](4095) NULL,
	[InventorySiteRef_Id] [varchar](4095) NULL,
	[InventorySiteRef_Name] [varchar](4095) NULL,
	[ItemRef_Id] [varchar](4095) NULL,
	[ItemRef_Name] [varchar](4095) NULL,
	[UOMUnit] [varchar](4095) NULL,
	[UOMSetRef_Id] [varchar](4095) NULL,
	[UOMSetRef_Name] [varchar](4095) NULL,
	[Qty] [decimal](15, 2) NULL,
	[QtySpecified] [bit] NULL,
	[PriceLevelRef_Id] [varchar](4095) NULL,
	[PriceLevelRef_Name] [varchar](4095) NULL,
	[RatePercent] [decimal](15, 2) NULL,
	[UnitPrice] [decimal](15, 2) NULL,
	[MarkupPercentBased] [bit] NULL,
	[MarkupPercentBasedSpecified] [bit] NULL,
	[MarkupPriceLevelRef_Id] [varchar](4095) NULL,
	[MarkupPriceLevelRef_Name] [varchar](4095) NULL,
	[MarkupValue] [decimal](15, 2) NULL,
	[MarkupValueSpecified] [bit] NULL,
	[MarkupPercent] [decimal](15, 2) NULL,
	[MarkupPercentSpecified] [bit] NULL,
	[MarkupIncomeAccountRef_Id] [varchar](4095) NULL,
	[MarkupIncomeAccountRef_Name] [varchar](4095) NULL,
	[SeqNum] [int] NULL,
	[PARENT_ID] [varchar](255) NULL
) ON [PRIMARY]
GO




CREATE TABLE [dbo].[salesreceipt](
	[Id] [varchar](255) NULL,
	[SyncToken] [varchar](4095) NULL,
	[CreateTime] [datetime] NULL,
	[LastUpdatedTime] [datetime] NULL,
	[Name] [varchar](4095) NULL,
	[DocNumber] [varchar](4095) NULL,
	[TxnDate] [datetime] NULL,
	[TxnDateSpecified] [bit] NULL,
	[DueDate] [datetime] NULL,
	[DueDateSpecified] [bit] NULL,
	[TxnSource] [varchar](4095) NULL,
	[CustomerRef_Id] [varchar](4095) NULL,
	[CustomerRef_Name] [varchar](4095) NULL,
	[ClassRef_Id] [varchar](4095) NULL,
	[ClassRef_Name] [varchar](4095) NULL,
	[ShipMethodRef_Id] [varchar](4095) NULL,
	[ShipMethodRef_Name] [varchar](4095) NULL,
	[DepositToAccountRef_Id] [varchar](4095) NULL,
	[DepositToAccountRef_Name] [varchar](4095) NULL,
	[PaymentMethodRef_Id] [varchar](4095) NULL,
	[PaymentMethodRef_Name] [varchar](4095) NULL,
	[DepartmentRef_Id] [varchar](4095) NULL,
	[DepartmentRef_Name] [varchar](4095) NULL,
	[CurrencyRef_Id] [varchar](4095) NULL,
	[CurrencyRef_Name] [varchar](4095) NULL,
	[ARAccountRef_Id] [varchar](4095) NULL,
	[ARAccountRef_Name] [varchar](4095) NULL,
	[RemitToRef_Id] [varchar](4095) NULL,
	[RemitToRef_Name] [varchar](4095) NULL,
	[SalesRepRef_Id] [varchar](4095) NULL,
	[SalesRepRef_Name] [varchar](4095) NULL,
	[SalesTermRef_Id] [varchar](4095) NULL,
	[SalesTermRef_Name] [varchar](4095) NULL,
	[TaxExemptionRef_Id] [varchar](4095) NULL,
	[TaxExemptionRef_Name] [varchar](4095) NULL,
	[TemplateRef_Id] [varchar](4095) NULL,
	[TemplateRef_Name] [varchar](4095) NULL,
	[FOB] [varchar](4095) NULL,
	[PONumber] [varchar](4095) NULL,
	[FinanceCharge] [bit] NULL,
	[FinanceChargeSpecified] [bit] NULL,
	[PaymentType] [varchar](4095) NULL,
	[PaymentTypeSpecified] [bit] NULL,
	[GovtTxnRefIdentifier] [varchar](4095) NULL,
	[PrivateNote] [varchar](4095) NULL,
	[TaxFormNum] [varchar](4095) NULL,
	[TxnStatus] [varchar](4095) NULL,
	[TaxFormType] [varchar](4095) NULL,
	[ExchangeRate] [decimal](15, 2) NULL,
	[ExchangeRateSpecified] [bit] NULL,
	[Balance] [decimal](15, 2) NULL,
	[BalanceSpecified] [bit] NULL,
	[HomeBalanceSpecified] [bit] NULL,
	[HomeBalance] [decimal](15, 2) NULL,
	[TransactionLocationType] [varchar](4095) NULL,
	[PaymentRefNum] [varchar](4095) NULL,
	[PrintStatus] [varchar](4095) NULL,
	[PrintStatusSpecified] [bit] NULL,
	[EmailStatus] [varchar](4095) NULL,
	[EmailStatusSpecified] [bit] NULL,
	[BillEmailAddress] [varchar](4095) NULL,
	[BillEmailAddressCc] [varchar](4095) NULL,
	[BillEmailAddressBcc] [varchar](4095) NULL,
	[CustomerMemo] [varchar](4095) NULL,
	[ShipDate] [datetime] NULL,
	[ShipDateSpecified] [bit] NULL,
	[TrackingNum] [varchar](4095) NULL,
	[DiscountRate] [decimal](15, 2) NULL,
	[DiscountRateSpecified] [bit] NULL,
	[DiscountAmt] [decimal](15, 2) NULL,
	[DiscountAmtSpecified] [bit] NULL,
	[GlobalTaxCalculation] [varchar](4095) NULL,
	[GlobalTaxCalculationSpecified] [bit] NULL,
	[HomeTotalAmt] [decimal](15, 2) NULL,
	[HomeTotalAmtSpecified] [bit] NULL,
	[TotalAmt] [decimal](15, 2) NULL,
	[TotalAmtSpecified] [bit] NULL,
	[LessCIS] [decimal](15, 2) NULL,
	[LessCISSpecified] [bit] NULL,
	[FreeFormAddress] [bit] NULL,
	[FreeFormAddressSpecified] [bit] NULL,
	[AutoDocNumber] [bit] NULL,
	[AutoDocNumberSpecified] [bit] NULL,
	[ApplyTaxAfterDiscount] [bit] NULL,
	[ApplyTaxAfterDiscountSpecified] [bit] NULL,
	[DeliveryType] [varchar](4095) NULL,
	[DeliveryTypeSpecified] [bit] NULL,
	[DeliveryTime] [datetime] NULL,
	[DeliveryTimeSpecified] [bit] NULL,
	[DeliveryErrorType] [varchar](4095) NULL,
	[DeliveryErrorTypeSpecified] [bit] NULL,
	[Check_CheckNum] [varchar](4095) NULL,
	[Check_Status] [varchar](4095) NULL,
	[Check_NameOnAcct] [varchar](4095) NULL,
	[Check_AcctNum] [varchar](4095) NULL,
	[Check_BankName] [varchar](4095) NULL,
	[TotalTaxSpecified] [bit] NULL,
	[TotalTax] [decimal](15, 2) NULL,
	[TxnTaxCodeRef_Id] [varchar](4095) NULL,
	[TxnTaxCodeRef_Name] [varchar](4095) NULL,
	[DefaultTaxCodeRef_Id] [varchar](4095) NULL,
	[DefaultTaxCodeRef_Name] [varchar](4095) NULL,
	[CCAccountRef_Id] [varchar](4095) NULL,
	[CCAccountRef_Name] [varchar](4095) NULL,
	[NameOnAcct] [varchar](4095) NULL,
	[Number] [varchar](4095) NULL,
	[Amount] [decimal](15, 2) NULL,
	[AmountSpecified] [bit] NULL,
	[ProcessPayment] [bit] NULL,
	[Type] [varchar](4095) NULL,
	[PostalCode] [varchar](4095) NULL,
	[CcExpiryMonth] [int] NULL,
	[CcExpiryMonthSpecified] [bit] NULL,
	[CcExpiryYear] [int] NULL,
	[CcExpiryYearSpecified] [bit] NULL,
	[BillAddrStreet] [varchar](4095) NULL,
	[CommercialCardCode] [varchar](4095) NULL,
	[ProcessPaymentSpecified] [bit] NULL,
	[CCTxnMode] [varchar](4095) NULL,
	[CCTxnModeSpecified] [bit] NULL,
	[CCTxnType] [varchar](4095) NULL,
	[CCTxnTypeSpecified] [bit] NULL,
	[PrevCCTransId] [varchar](4095) NULL,
	[TxnAuthorizationTime] [datetime] NULL,
	[TxnAuthorizationTimeSpecified] [bit] NULL,
	[TxnAuthorizationStamp] [int] NULL,
	[TxnAuthorizationStampSpecified] [bit] NULL,
	[PaymentGroupingCodeSpecified] [bit] NULL,
	[PaymentGroupingCode] [int] NULL,
	[ReconBatchId] [varchar](4095) NULL,
	[SecurityCode] [varchar](4095) NULL,
	[AvsZipSpecified] [bit] NULL,
	[AvsZip] [varchar](4095) NULL,
	[AvsStreetSpecified] [bit] NULL,
	[AvsStreet] [varchar](4095) NULL,
	[AuthCode] [varchar](4095) NULL,
	[CardSecurityCodeMatch] [varchar](4095) NULL,
	[CardSecurityCodeMatchSpecified] [bit] NULL,
	[MerchantAcctNum] [varchar](4095) NULL,
	[ResultMsg] [varchar](4095) NULL,
	[ResultCodeSpecified] [bit] NULL,
	[ResultCode] [int] NULL,
	[StatusSpecified] [bit] NULL,
	[Status] [varchar](4095) NULL,
	[CCTransId] [varchar](4095) NULL,
	[CCProcessor] [varchar](4095) NULL,
	[ClientTransID] [varchar](4095) NULL,
	[BillAddr_Id] [varchar](4095) NULL,
	[BillAddr_Line1] [varchar](4095) NULL,
	[BillAddr_Line2] [varchar](4095) NULL,
	[BillAddr_Line3] [varchar](4095) NULL,
	[BillAddr_Line4] [varchar](4095) NULL,
	[BillAddr_Line5] [varchar](4095) NULL,
	[BillAddr_City] [varchar](4095) NULL,
	[BillAddr_Country] [varchar](4095) NULL,
	[BillAddr_PostalCode] [varchar](4095) NULL,
	[BillAddr_CountryCode] [varchar](4095) NULL,
	[BillAddr_CountrySubDivisionCode] [varchar](4095) NULL,
	[BillAddr_PostalCodeSuffix] [varchar](4095) NULL,
	[BillAddr_Long] [varchar](4095) NULL,
	[BillAddr_Lat] [varchar](4095) NULL,
	[BillAddr_Note] [varchar](4095) NULL,
	[BillAddr_Tag] [varchar](4095) NULL,
	[ShipFromAddr_Id] [varchar](4095) NULL,
	[ShipFromAddr_Line1] [varchar](4095) NULL,
	[ShipFromAddr_Line2] [varchar](4095) NULL,
	[ShipFromAddr_Line3] [varchar](4095) NULL,
	[ShipFromAddr_Line4] [varchar](4095) NULL,
	[ShipFromAddr_Line5] [varchar](4095) NULL,
	[ShipFromAddr_City] [varchar](4095) NULL,
	[ShipFromAddr_Country] [varchar](4095) NULL,
	[ShipFromAddr_PostalCode] [varchar](4095) NULL,
	[ShipFromAddr_CountryCode] [varchar](4095) NULL,
	[ShipFromAddr_CountrySubDivisionCode] [varchar](4095) NULL,
	[ShipFromAddr_PostalCodeSuffix] [varchar](4095) NULL,
	[ShipFromAddr_Long] [varchar](4095) NULL,
	[ShipFromAddr_Lat] [varchar](4095) NULL,
	[ShipFromAddr_Note] [varchar](4095) NULL,
	[ShipFromAddr_Tag] [varchar](4095) NULL,
	[ShipAddr_Id] [varchar](4095) NULL,
	[ShipAddr_Line1] [varchar](4095) NULL,
	[ShipAddr_Line2] [varchar](4095) NULL,
	[ShipAddr_Line3] [varchar](4095) NULL,
	[ShipAddr_Line4] [varchar](4095) NULL,
	[ShipAddr_Line5] [varchar](4095) NULL,
	[ShipAddr_City] [varchar](4095) NULL,
	[ShipAddr_Country] [varchar](4095) NULL,
	[ShipAddr_PostalCode] [varchar](4095) NULL,
	[ShipAddr_CountryCode] [varchar](4095) NULL,
	[ShipAddr_CountrySubDivisionCode] [varchar](4095) NULL,
	[ShipAddr_PostalCodeSuffix] [varchar](4095) NULL,
	[ShipAddr_Long] [varchar](4095) NULL,
	[ShipAddr_Lat] [varchar](4095) NULL,
	[ShipAddr_Note] [varchar](4095) NULL,
	[ShipAddr_Tag] [varchar](4095) NULL,
	[CustomField1] [varchar](4095) NULL,
	[CustomField2] [varchar](4095) NULL,
	[CustomField3] [varchar](4095) NULL,
	[CustomField4] [varchar](4095) NULL,
	[CustomField5] [varchar](4095) NULL,
	[CustomField6] [varchar](4095) NULL,
	[CustomField7] [varchar](4095) NULL,
	[CustomField8] [varchar](4095) NULL,
	[CustomField9] [varchar](4095) NULL,
	[CustomField10] [varchar](4095) NULL,
	[UserData] [varchar](4095) NULL,
	[Operation] [varchar](4095) NULL,
	[sparse] [bit] NULL,
	[LSData] [varchar](4095) NULL
) ON [PRIMARY]
GO





CREATE TABLE [dbo].[salesreceiptlinedetail](
	[Id] [varchar](255) NULL,
	[LineNum] [varchar](4095) NULL,
	[Description] [varchar](4095) NULL,
	[Amount] [decimal](15, 2) NULL,
	[AmountSpecified] [bit] NULL,
	[DetailType] [varchar](4095) NULL,
	[DetailTypeSpecified] [bit] NULL,
	[PriceLevelRef_Id] [varchar](4095) NULL,
	[PriceLevelRef_Name] [varchar](4095) NULL,
	[RatePercent] [decimal](15, 2) NULL,
	[UnitPrice] [decimal](15, 2) NULL,
	[TaxInclusiveAmt] [decimal](15, 2) NULL,
	[TaxInclusiveAmtSpecified] [bit] NULL,
	[DiscountAmt] [decimal](15, 2) NULL,
	[DiscountAmtSpecified] [bit] NULL,
	[ServiceDate] [datetime] NULL,
	[ServiceDateSpecified] [bit] NULL,
	[DiscountRate] [decimal](15, 2) NULL,
	[DiscountRateSpecified] [bit] NULL,
	[TaxClassificationRef_Id] [varchar](4095) NULL,
	[TaxClassificationRef_Name] [varchar](4095) NULL,
	[ItemAccountRef_Id] [varchar](4095) NULL,
	[ItemAccountRef_Name] [varchar](4095) NULL,
	[InventorySiteRef_Id] [varchar](4095) NULL,
	[InventorySiteRef_Name] [varchar](4095) NULL,
	[TaxCodeRef_Id] [varchar](4095) NULL,
	[TaxCodeRef_Name] [varchar](4095) NULL,
	[ClassRef_Id] [varchar](4095) NULL,
	[ClassRef_Name] [varchar](4095) NULL,
	[ItemRef_Id] [varchar](4095) NULL,
	[ItemRef_Name] [varchar](4095) NULL,
	[UOMUnit] [varchar](4095) NULL,
	[UOMSetRef_Id] [varchar](4095) NULL,
	[UOMSetRef_Name] [varchar](4095) NULL,
	[Qty] [decimal](15, 2) NULL,
	[QtySpecified] [bit] NULL,
	[GroupItemRef_Id] [varchar](4095) NULL,
	[GroupItemRef_Name] [varchar](4095) NULL,
	[DiscountAccountRef_Id] [varchar](4095) NULL,
	[DiscountAccountRef_Name] [varchar](4095) NULL,
	[DiscountRef_Id] [varchar](4095) NULL,
	[DiscountRef_Name] [varchar](4095) NULL,
	[DiscountPercent] [decimal](15, 2) NULL,
	[DiscountPercentSpecified] [bit] NULL,
	[PercentBased] [bit] NULL,
	[PercentBasedSpecified] [bit] NULL,
	[MarkupPercentBased] [bit] NULL,
	[MarkupPercentBasedSpecified] [bit] NULL,
	[MarkupPriceLevelRef_Id] [varchar](4095) NULL,
	[MarkupPriceLevelRef_Name] [varchar](4095) NULL,
	[MarkupValue] [decimal](15, 2) NULL,
	[MarkupValueSpecified] [bit] NULL,
	[MarkupPercent] [decimal](15, 2) NULL,
	[MarkupPercentSpecified] [bit] NULL,
	[MarkupIncomeAccountRef_Id] [varchar](4095) NULL,
	[MarkupIncomeAccountRef_Name] [varchar](4095) NULL,
	[CustomField1] [varchar](4095) NULL,
	[CustomField2] [varchar](4095) NULL,
	[CustomField3] [varchar](4095) NULL,
	[CustomField4] [varchar](4095) NULL,
	[CustomField5] [varchar](4095) NULL,
	[CustomField6] [varchar](4095) NULL,
	[CustomField7] [varchar](4095) NULL,
	[CustomField8] [varchar](4095) NULL,
	[CustomField9] [varchar](4095) NULL,
	[CustomField10] [varchar](4095) NULL,
	[SeqNum] [int] NULL,
	[PARENT_GroupID] [varchar](255) NULL,
	[PARENT_ID] [varchar](255) NULL
) ON [PRIMARY]
GO




CREATE TABLE [dbo].[statusinfo](
	[status] [varchar](4095) NULL,
	[statusDate] [datetime] NULL,
	[statusDateSpecified] [bit] NULL,
	[callToAction] [varchar](4095) NULL,
	[SeqNum] [int] NULL,
	[ParentTableType] [varchar](255) NULL,
	[PARENT_ID] [varchar](255) NULL
) ON [PRIMARY]
GO




CREATE TABLE [dbo].[taxagency](
	[Id] [varchar](255) NULL,
	[SyncToken] [varchar](4095) NULL,
	[CreateTime] [datetime] NULL,
	[LastUpdatedTime] [datetime] NULL,
	[DisplayName] [varchar](4095) NULL,
	[TaxTrackedOnSales] [bit] NULL,
	[TaxTrackedOnSalesSpecified] [bit] NULL,
	[LastFileDate] [datetime] NULL,
	[LastFileDateSpecified] [bit] NULL,
	[TaxOnTax] [bit] NULL,
	[TaxOnTaxSpecified] [bit] NULL,
	[ReportingPeriod] [varchar](4095) NULL,
	[TaxRegistrationNumber] [varchar](4095) NULL,
	[SalesTaxCountry] [varchar](4095) NULL,
	[TaxTrackedOnSalesAccountRef_Id] [varchar](4095) NULL,
	[TaxTrackedOnSalesAccountRef_Name] [varchar](4095) NULL,
	[TaxOnPurchasesAccountRef_Id] [varchar](4095) NULL,
	[TaxOnPurchasesAccountRef_Name] [varchar](4095) NULL,
	[SalesTaxReturnRef_Id] [varchar](4095) NULL,
	[SalesTaxReturnRef_Name] [varchar](4095) NULL,
	[SalesTaxCodeRef_Id] [varchar](4095) NULL,
	[SalesTaxCodeRef_Name] [varchar](4095) NULL,
	[TaxTrackedOnPurchases] [bit] NULL,
	[TaxTrackedOnPurchasesSpecified] [bit] NULL,
	[UserData] [varchar](4095) NULL,
	[Operation] [varchar](4095) NULL,
	[sparse] [bit] NULL,
	[LSData] [varchar](4095) NULL
) ON [PRIMARY]
GO




CREATE TABLE [dbo].[taxclassification](
	[Id] [varchar](255) NULL,
	[SyncToken] [varchar](4095) NULL,
	[CreateTime] [datetime] NULL,
	[LastUpdatedTime] [datetime] NULL,
	[Name] [varchar](4095) NULL,
	[Description] [varchar](4095) NULL,
	[Code] [varchar](4095) NULL,
	[Level] [varchar](4095) NULL,
	[ParentRef_Id] [varchar](4095) NULL,
	[ParentRef_Name] [varchar](4095) NULL,
	[ApplicableTo] [varchar](4095) NULL,
	[UserData] [varchar](4095) NULL,
	[Operation] [varchar](4095) NULL,
	[sparse] [bit] NULL,
	[LSData] [varchar](4095) NULL
) ON [PRIMARY]
GO



CREATE TABLE [dbo].[taxcode](
	[Id] [varchar](255) NULL,
	[SyncToken] [varchar](4095) NULL,
	[CreateTime] [datetime] NULL,
	[LastUpdatedTime] [datetime] NULL,
	[Name] [varchar](4095) NULL,
	[Description] [varchar](4095) NULL,
	[Active] [bit] NULL,
	[ActiveSpecified] [bit] NULL,
	[Hidden] [bit] NULL,
	[HiddenSpecified] [bit] NULL,
	[Taxable] [bit] NULL,
	[TaxableSpecified] [bit] NULL,
	[TaxGroup] [bit] NULL,
	[TaxGroupSpecified] [bit] NULL,
	[UserData] [varchar](4095) NULL,
	[Operation] [varchar](4095) NULL,
	[sparse] [bit] NULL,
	[LSData] [varchar](4095) NULL
) ON [PRIMARY]
GO




CREATE TABLE [dbo].[taxpayment](
	[Id] [varchar](255) NULL,
	[SyncToken] [varchar](4095) NULL,
	[CreateTime] [datetime] NULL,
	[LastUpdatedTime] [datetime] NULL,
	[Name] [varchar](4095) NULL,
	[PaymentDate] [datetime] NULL,
	[PaymentDateSpecified] [bit] NULL,
	[PaymentAccountRef_Id] [varchar](4095) NULL,
	[PaymentAccountRef_Name] [varchar](4095) NULL,
	[PaymentAmount] [decimal](15, 2) NULL,
	[PaymentAmountSpecified] [bit] NULL,
	[Description] [varchar](4095) NULL,
	[Refund] [bit] NULL,
	[RefundSpecified] [bit] NULL,
	[UserData] [varchar](4095) NULL,
	[Operation] [varchar](4095) NULL,
	[sparse] [bit] NULL,
	[LSData] [varchar](4095) NULL
) ON [PRIMARY]
GO




CREATE TABLE [dbo].[taxrate](
	[Id] [varchar](255) NULL,
	[SyncToken] [varchar](4095) NULL,
	[CreateTime] [datetime] NULL,
	[LastUpdatedTime] [datetime] NULL,
	[Name] [varchar](4095) NULL,
	[Description] [varchar](4095) NULL,
	[Active] [bit] NULL,
	[ActiveSpecified] [bit] NULL,
	[RateValue] [decimal](15, 2) NULL,
	[RateValueSpecified] [bit] NULL,
	[AgencyRef_Id] [varchar](4095) NULL,
	[AgencyRef_Name] [varchar](4095) NULL,
	[TaxReturnLineRef_Id] [varchar](4095) NULL,
	[TaxReturnLineRef_Name] [varchar](4095) NULL,
	[SpecialTaxType] [varchar](4095) NULL,
	[SpecialTaxTypeSpecified] [bit] NULL,
	[DisplayType] [varchar](4095) NULL,
	[DisplayTypeSpecified] [bit] NULL,
	[UserData] [varchar](4095) NULL,
	[Operation] [varchar](4095) NULL,
	[sparse] [bit] NULL,
	[LSData] [varchar](4095) NULL
) ON [PRIMARY]
GO



CREATE TABLE [dbo].[taxratedetail](
	[Id] [varchar](255) NULL,
	[TaxRateRef_Id] [varchar](4095) NULL,
	[TaxRateRef_Name] [varchar](4095) NULL,
	[TaxTypeApplicable] [varchar](4095) NULL,
	[TaxTypeApplicableSpecified] [bit] NULL,
	[TaxOrder] [int] NULL,
	[TaxOrderSpecified] [bit] NULL,
	[TaxOnTaxOrder] [int] NULL,
	[TaxOnTaxOrderSpecified] [bit] NULL,
	[SeqNum] [int] NULL,
	[LetSyncId] [bit] NULL,
	[ParentTableType] [varchar](255) NULL,
	[PARENT_ID] [varchar](255) NULL
) ON [PRIMARY]
GO



CREATE TABLE [dbo].[taxratedetails](
	[Id] [varchar](255) NULL,
	[TaxRateName] [varchar](4095) NULL,
	[TaxRateId] [varchar](4095) NULL,
	[RateValue] [decimal](15, 2) NULL,
	[RateValueSpecified] [bit] NULL,
	[TaxAgencyId] [varchar](4095) NULL,
	[TaxApplicableOn] [varchar](4095) NULL,
	[TaxApplicableOnSpecified] [bit] NULL,
	[SeqNum] [int] NULL,
	[LetSyncId] [bit] NULL,
	[ParentTableType] [varchar](255) NULL,
	[PARENT_LineID] [varchar](255) NULL,
	[PARENT_ID] [varchar](255) NULL
) ON [PRIMARY]
GO



CREATE TABLE [dbo].[taxservice](
	[Id] [varchar](255) NULL,
	[SyncToken] [varchar](4095) NULL,
	[CreateTime] [datetime] NULL,
	[LastUpdatedTime] [datetime] NULL,
	[Name] [varchar](4095) NULL,
	[TaxCode] [varchar](4095) NULL,
	[TaxCodeId] [varchar](4095) NULL,
	[UserData] [varchar](4095) NULL,
	[Operation] [varchar](4095) NULL,
	[sparse] [bit] NULL,
	[LSData] [varchar](4095) NULL
) ON [PRIMARY]
GO



CREATE TABLE [dbo].[term](
	[Id] [varchar](255) NULL,
	[SyncToken] [varchar](4095) NULL,
	[CreateTime] [datetime] NULL,
	[LastUpdatedTime] [datetime] NULL,
	[Name] [varchar](4095) NULL,
	[Active] [bit] NULL,
	[ActiveSpecified] [bit] NULL,
	[Type] [varchar](4095) NULL,
	[DiscountPercent] [decimal](15, 2) NULL,
	[DiscountPercentSpecified] [bit] NULL,
	[UserData] [varchar](4095) NULL,
	[Operation] [varchar](4095) NULL,
	[sparse] [bit] NULL,
	[LSData] [varchar](4095) NULL
) ON [PRIMARY]
GO



CREATE TABLE [dbo].[termlinedetail](
	[Id] [varchar](255) NULL,
	[DueDays] [int] NULL,
	[DueNextMonthDays] [varchar](255) NULL,
	[DiscountDayOfMonth] [varchar](255) NULL,
	[DayOfMonthDue] [varchar](255) NULL,
	[DiscountDays] [int] NULL,
	[SeqNum] [int] NULL,
	[LetSyncId] [bit] NULL,
	[ParentTableType] [varchar](255) NULL,
	[PARENT_LineID] [varchar](255) NULL,
	[PARENT_ID] [varchar](255) NULL
) ON [PRIMARY]
GO



CREATE TABLE [dbo].[timeactivity](
	[Id] [varchar](255) NULL,
	[SyncToken] [varchar](4095) NULL,
	[CreateTime] [datetime] NULL,
	[LastUpdatedTime] [datetime] NULL,
	[Name] [varchar](4095) NULL,
	[NameOfType] [varchar](4095) NULL,
	[NameOfSpecified] [bit] NULL,
	[TxnDate] [datetime] NULL,
	[TxnDateSpecified] [bit] NULL,
	[StartTime] [datetime] NULL,
	[StartTimeSpecified] [bit] NULL,
	[EndTime] [datetime] NULL,
	[EndTimeSpecified] [bit] NULL,
	[HourlyRate] [decimal](15, 2) NULL,
	[HourlyRateSpecified] [bit] NULL,
	[Minutes] [int] NULL,
	[MinutesSpecified] [bit] NULL,
	[Hours] [int] NULL,
	[HoursSpecified] [bit] NULL,
	[BreakHours] [int] NULL,
	[BreakHoursSpecified] [bit] NULL,
	[BreakMinutes] [int] NULL,
	[BreakMinutesSpecified] [bit] NULL,
	[ItemElementName] [varchar](4095) NULL,
	[ItemElementRef_Id] [varchar](4095) NULL,
	[ItemElementRef_Name] [varchar](4095) NULL,
	[EmployeeRef_Id] [varchar](4095) NULL,
	[EmployeeRef_Name] [varchar](4095) NULL,
	[OtherNameRef_Id] [varchar](4095) NULL,
	[OtherNameRef_Name] [varchar](4095) NULL,
	[VendorRef_Id] [varchar](4095) NULL,
	[VendorRef_Name] [varchar](4095) NULL,
	[CustomerRef_Id] [varchar](4095) NULL,
	[CustomerRef_Name] [varchar](4095) NULL,
	[DepartmentRef_Id] [varchar](4095) NULL,
	[DepartmentRef_Name] [varchar](4095) NULL,
	[ItemRef_Id] [varchar](4095) NULL,
	[ItemRef_Name] [varchar](4095) NULL,
	[ClassRef_Id] [varchar](4095) NULL,
	[ClassRef_Name] [varchar](4095) NULL,
	[PayrollItemRef_Id] [varchar](4095) NULL,
	[PayrollItemRef_Name] [varchar](4095) NULL,
	[BillableStatus] [varchar](4095) NULL,
	[BillableStatusSpecified] [bit] NULL,
	[TimeZone] [varchar](4095) NULL,
	[Taxable] [bit] NULL,
	[TaxableSpecified] [bit] NULL,
	[Description] [varchar](4095) NULL,
	[UserData] [varchar](4095) NULL,
	[Operation] [varchar](4095) NULL,
	[sparse] [bit] NULL,
	[LSData] [varchar](4095) NULL
) ON [PRIMARY]
GO



CREATE TABLE [dbo].[transfer](
	[Id] [varchar](255) NULL,
	[SyncToken] [varchar](4095) NULL,
	[CreateTime] [datetime] NULL,
	[LastUpdatedTime] [datetime] NULL,
	[Name] [varchar](4095) NULL,
	[TxnDate] [datetime] NULL,
	[TxnDateSpecified] [bit] NULL,
	[ExchangeRate] [decimal](15, 2) NULL,
	[ExchangeRateSpecified] [bit] NULL,
	[TransactionLocationType] [varchar](4095) NULL,
	[Amount] [decimal](15, 2) NULL,
	[AmountSpecified] [bit] NULL,
	[PrivateNote] [varchar](4095) NULL,
	[FromAccountRef_Id] [varchar](4095) NULL,
	[FromAccountRef_Name] [varchar](4095) NULL,
	[ToAccountRef_Id] [varchar](4095) NULL,
	[ToAccountRef_Name] [varchar](4095) NULL,
	[ClassRef_Id] [varchar](4095) NULL,
	[ClassRef_Name] [varchar](4095) NULL,
	[UserData] [varchar](4095) NULL,
	[Operation] [varchar](4095) NULL,
	[sparse] [bit] NULL,
	[LSData] [varchar](4095) NULL
) ON [PRIMARY]
GO




CREATE TABLE [dbo].[txntaxlinedetail](
	[Id] [varchar](255) NULL,
	[DetailType] [varchar](4095) NULL,
	[DetailTypeSpecified] [bit] NULL,
	[Amount] [decimal](15, 2) NULL,
	[AmountSpecified] [bit] NULL,
	[TaxRateRef_Id] [varchar](4095) NULL,
	[TaxRateRef_Name] [varchar](4095) NULL,
	[PercentBased] [bit] NULL,
	[PercentBasedSpecified] [bit] NULL,
	[TaxPercent] [decimal](15, 2) NULL,
	[TaxPercentSpecified] [bit] NULL,
	[NetAmountTaxable] [decimal](15, 2) NULL,
	[NetAmountTaxableSpecified] [bit] NULL,
	[TaxInclusiveAmount] [decimal](15, 2) NULL,
	[TaxInclusiveAmountSpecified] [bit] NULL,
	[OverrideDeltaAmount] [decimal](15, 2) NULL,
	[OverrideDeltaAmountSpecified] [bit] NULL,
	[ServiceDate] [datetime] NULL,
	[ServiceDateSpecified] [bit] NULL,
	[SeqNum] [int] NULL,
	[LetSyncId] [bit] NULL,
	[ParentTableType] [varchar](255) NULL,
	[PARENT_ID] [varchar](255) NULL
) ON [PRIMARY]
GO



CREATE TABLE [dbo].[vendor](
	[Id] [varchar](255) NULL,
	[SyncToken] [varchar](4095) NULL,
	[CreateTime] [datetime] NULL,
	[LastUpdatedTime] [datetime] NULL,
	[Name] [varchar](4095) NULL,
	[GivenName] [varchar](4095) NULL,
	[MiddleName] [varchar](4095) NULL,
	[FamilyName] [varchar](4095) NULL,
	[Title] [varchar](4095) NULL,
	[Suffix] [varchar](4095) NULL,
	[FullyQualifiedName] [varchar](4095) NULL,
	[PrintOnCheckName] [varchar](4095) NULL,
	[DisplayName] [varchar](4095) NULL,
	[CompanyName] [varchar](4095) NULL,
	[TaxCountry] [varchar](4095) NULL,
	[TaxIdentifier] [varchar](4095) NULL,
	[TaxIdEffectiveDate] [datetime] NULL,
	[TaxIdEffectiveDateSpecified] [bit] NULL,
	[BusinessNumber] [varchar](4095) NULL,
	[IntuitId] [varchar](4095) NULL,
	[UserId] [varchar](4095) NULL,
	[DefaultTaxCodeRef_Id] [varchar](4095) NULL,
	[DefaultTaxCodeRef_Name] [varchar](4095) NULL,
	[ParentRef_Id] [varchar](4095) NULL,
	[ParentRef_Name] [varchar](4095) NULL,
	[VendorTypeRef_Id] [varchar](4095) NULL,
	[VendorTypeRef_Name] [varchar](4095) NULL,
	[TermRef_Id] [varchar](4095) NULL,
	[TermRef_Name] [varchar](4095) NULL,
	[PrefillAccountRef_Id] [varchar](4095) NULL,
	[PrefillAccountRef_Name] [varchar](4095) NULL,
	[APAccountRef_Id] [varchar](4095) NULL,
	[APAccountRef_Name] [varchar](4095) NULL,
	[CurrencyRef_Id] [varchar](4095) NULL,
	[CurrencyRef_Name] [varchar](4095) NULL,
	[Active] [bit] NULL,
	[ActiveSpecified] [bit] NULL,
	[PrimaryPhone] [varchar](4095) NULL,
	[AlternatePhone] [varchar](4095) NULL,
	[Mobile] [varchar](4095) NULL,
	[Fax] [varchar](4095) NULL,
	[PrimaryEmailAddress] [varchar](4095) NULL,
	[WebAddress] [varchar](4095) NULL,
	[Balance] [decimal](15, 2) NULL,
	[BalanceSpecified] [bit] NULL,
	[BillRate] [decimal](15, 2) NULL,
	[BillRateSpecified] [bit] NULL,
	[OpenBalanceDate] [datetime] NULL,
	[OpenBalanceDateSpecified] [bit] NULL,
	[CreditLimit] [decimal](15, 2) NULL,
	[CreditLimitSpecified] [bit] NULL,
	[Organization] [bit] NULL,
	[OrganizationSpecified] [bit] NULL,
	[Vendor1099] [bit] NULL,
	[Vendor1099Specified] [bit] NULL,
	[IsSubContractor] [bit] NULL,
	[IsSubContractorSpecified] [bit] NULL,
	[TDSOverrideThreshold] [bit] NULL,
	[TDSOverrideThresholdSpecified] [bit] NULL,
	[TDSSectionTypeId] [int] NULL,
	[TDSSectionTypeIdSpecified] [bit] NULL,
	[TDSEntityTypeId] [int] NULL,
	[TDSEntityTypeIdSpecified] [bit] NULL,
	[TDSEnabled] [bit] NULL,
	[TDSEnabledSpecified] [bit] NULL,
	[T4AEligible] [bit] NULL,
	[T4AEligibleSpecified] [bit] NULL,
	[T5018Eligible] [bit] NULL,
	[T5018EligibleSpecified] [bit] NULL,
	[CISRate] [varchar](4095) NULL,
	[Notes] [varchar](4095) NULL,
	[AltContactName] [varchar](4095) NULL,
	[ContactName] [varchar](4095) NULL,
	[AcctNum] [varchar](4095) NULL,
	[SubcontractorType] [varchar](4095) NULL,
	[GSTIN] [varchar](4095) NULL,
	[GSTRegistrationType] [varchar](4095) NULL,
	[TaxReportingBasis] [varchar](4095) NULL,
	[BillAddr_Id] [varchar](4095) NULL,
	[BillAddr_Line1] [varchar](4095) NULL,
	[BillAddr_Line2] [varchar](4095) NULL,
	[BillAddr_Line3] [varchar](4095) NULL,
	[BillAddr_Line4] [varchar](4095) NULL,
	[BillAddr_Line5] [varchar](4095) NULL,
	[BillAddr_City] [varchar](4095) NULL,
	[BillAddr_Country] [varchar](4095) NULL,
	[BillAddr_PostalCode] [varchar](4095) NULL,
	[BillAddr_CountryCode] [varchar](4095) NULL,
	[BillAddr_CountrySubDivisionCode] [varchar](4095) NULL,
	[BillAddr_PostalCodeSuffix] [varchar](4095) NULL,
	[BillAddr_Long] [varchar](4095) NULL,
	[BillAddr_Lat] [varchar](4095) NULL,
	[BillAddr_Note] [varchar](4095) NULL,
	[BillAddr_Tag] [varchar](4095) NULL,
	[ShipAddr_Id] [varchar](4095) NULL,
	[ShipAddr_Line1] [varchar](4095) NULL,
	[ShipAddr_Line2] [varchar](4095) NULL,
	[ShipAddr_Line3] [varchar](4095) NULL,
	[ShipAddr_Line4] [varchar](4095) NULL,
	[ShipAddr_Line5] [varchar](4095) NULL,
	[ShipAddr_City] [varchar](4095) NULL,
	[ShipAddr_Country] [varchar](4095) NULL,
	[ShipAddr_PostalCode] [varchar](4095) NULL,
	[ShipAddr_CountryCode] [varchar](4095) NULL,
	[ShipAddr_CountrySubDivisionCode] [varchar](4095) NULL,
	[ShipAddr_PostalCodeSuffix] [varchar](4095) NULL,
	[ShipAddr_Long] [varchar](4095) NULL,
	[ShipAddr_Lat] [varchar](4095) NULL,
	[ShipAddr_Note] [varchar](4095) NULL,
	[ShipAddr_Tag] [varchar](4095) NULL,
	[CustomField1] [varchar](4095) NULL,
	[CustomField2] [varchar](4095) NULL,
	[CustomField3] [varchar](4095) NULL,
	[CustomField4] [varchar](4095) NULL,
	[CustomField5] [varchar](4095) NULL,
	[CustomField6] [varchar](4095) NULL,
	[CustomField7] [varchar](4095) NULL,
	[CustomField8] [varchar](4095) NULL,
	[CustomField9] [varchar](4095) NULL,
	[CustomField10] [varchar](4095) NULL,
	[UserData] [varchar](4095) NULL,
	[Operation] [varchar](4095) NULL,
	[sparse] [bit] NULL,
	[LSData] [varchar](4095) NULL
) ON [PRIMARY]
GO



CREATE TABLE [dbo].[vendorcredit](
	[Id] [varchar](255) NULL,
	[SyncToken] [varchar](4095) NULL,
	[CreateTime] [datetime] NULL,
	[LastUpdatedTime] [datetime] NULL,
	[Name] [varchar](4095) NULL,
	[TxnDate] [datetime] NULL,
	[TxnDateSpecified] [bit] NULL,
	[ExchangeRate] [decimal](15, 2) NULL,
	[ExchangeRateSpecified] [bit] NULL,
	[TotalAmt] [decimal](15, 2) NULL,
	[TotalAmtSpecified] [bit] NULL,
	[TransactionLocationType] [varchar](4095) NULL,
	[DocNumber] [varchar](4095) NULL,
	[PrivateNote] [varchar](4095) NULL,
	[TaxFormNum] [varchar](4095) NULL,
	[TaxFormType] [varchar](4095) NULL,
	[TxnSource] [varchar](4095) NULL,
	[TxnStatus] [varchar](4095) NULL,
	[CurrencyRef_Id] [varchar](4095) NULL,
	[CurrencyRef_Name] [varchar](4095) NULL,
	[DepartmentRef_Id] [varchar](4095) NULL,
	[DepartmentRef_Name] [varchar](4095) NULL,
	[APAccountRef_Id] [varchar](4095) NULL,
	[APAccountRef_Name] [varchar](4095) NULL,
	[VendorRef_Id] [varchar](4095) NULL,
	[VendorRef_Name] [varchar](4095) NULL,
	[BillEmailAddress] [varchar](4095) NULL,
	[ReplyEmailAddress] [varchar](4095) NULL,
	[Memo] [varchar](4095) NULL,
	[GlobalTaxCalculation] [varchar](4095) NULL,
	[GlobalTaxCalculationSpecified] [bit] NULL,
	[Balance] [decimal](15, 2) NULL,
	[BalanceSpecified] [bit] NULL,
	[TotalTaxSpecified] [bit] NULL,
	[TotalTax] [decimal](15, 2) NULL,
	[TxnTaxCodeRef_Id] [varchar](4095) NULL,
	[TxnTaxCodeRef_Name] [varchar](4095) NULL,
	[DefaultTaxCodeRef_Id] [varchar](4095) NULL,
	[DefaultTaxCodeRef_Name] [varchar](4095) NULL,
	[CustomField1] [varchar](4095) NULL,
	[CustomField2] [varchar](4095) NULL,
	[CustomField3] [varchar](4095) NULL,
	[CustomField4] [varchar](4095) NULL,
	[CustomField5] [varchar](4095) NULL,
	[CustomField6] [varchar](4095) NULL,
	[CustomField7] [varchar](4095) NULL,
	[CustomField8] [varchar](4095) NULL,
	[CustomField9] [varchar](4095) NULL,
	[CustomField10] [varchar](4095) NULL,
	[UserData] [varchar](4095) NULL,
	[Operation] [varchar](4095) NULL,
	[sparse] [bit] NULL,
	[LSData] [varchar](4095) NULL
) ON [PRIMARY]
GO




CREATE TABLE [dbo].[vendorcreditlinedetail](
	[Id] [varchar](255) NULL,
	[LineNum] [varchar](4095) NULL,
	[Description] [varchar](4095) NULL,
	[Amount] [decimal](15, 2) NULL,
	[AmountSpecified] [bit] NULL,
	[DetailType] [varchar](4095) NULL,
	[DetailTypeSpecified] [bit] NULL,
	[ItemRef_Id] [varchar](4095) NULL,
	[ItemRef_Name] [varchar](4095) NULL,
	[ClassRef_Id] [varchar](4095) NULL,
	[ClassRef_Name] [varchar](4095) NULL,
	[PriceLevelRef_Id] [varchar](4095) NULL,
	[PriceLevelRef_Name] [varchar](4095) NULL,
	[RatePercent] [decimal](15, 2) NULL,
	[UnitPrice] [decimal](15, 2) NULL,
	[Qty] [decimal](15, 2) NULL,
	[QtySpecified] [bit] NULL,
	[UOMSetRef_Unit] [varchar](4095) NULL,
	[UOMSetRef_Id] [varchar](4095) NULL,
	[UOMSetRef_Name] [varchar](4095) NULL,
	[ItemAccountRef_Id] [varchar](4095) NULL,
	[ItemAccountRef_Name] [varchar](4095) NULL,
	[InventorySiteRef_Id] [varchar](4095) NULL,
	[InventorySiteRef_Name] [varchar](4095) NULL,
	[TaxCodeRef_Id] [varchar](4095) NULL,
	[TaxCodeRef_Name] [varchar](4095) NULL,
	[TaxClassificationRef_Id] [varchar](4095) NULL,
	[TaxClassificationRef_Name] [varchar](4095) NULL,
	[CustomerRef_Id] [varchar](4095) NULL,
	[CustomerRef_Name] [varchar](4095) NULL,
	[BillableStatus] [varchar](4095) NULL,
	[BillableStatusSpecified] [bit] NULL,
	[TaxInclusiveAmt] [decimal](15, 2) NULL,
	[TaxInclusiveAmtSpecified] [bit] NULL,
	[AccountRef_Id] [varchar](4095) NULL,
	[AccountRef_Name] [varchar](4095) NULL,
	[TaxAmount] [decimal](15, 2) NULL,
	[TaxAmountSpecified] [bit] NULL,
	[MarkupPercentBased] [bit] NULL,
	[MarkupPercentBasedSpecified] [bit] NULL,
	[MarkupValue] [decimal](15, 2) NULL,
	[MarkupValueSpecified] [bit] NULL,
	[MarkupPercent] [decimal](15, 2) NULL,
	[MarkupPercentSpecified] [bit] NULL,
	[MarkupPriceLevelRef_Id] [varchar](4095) NULL,
	[MarkupPriceLevelRef_Name] [varchar](4095) NULL,
	[MarkupIncomeAccountRef_Id] [varchar](4095) NULL,
	[MarkupIncomeAccountRef_Name] [varchar](4095) NULL,
	[CustomField1] [varchar](4095) NULL,
	[CustomField2] [varchar](4095) NULL,
	[CustomField3] [varchar](4095) NULL,
	[CustomField4] [varchar](4095) NULL,
	[CustomField5] [varchar](4095) NULL,
	[CustomField6] [varchar](4095) NULL,
	[CustomField7] [varchar](4095) NULL,
	[CustomField8] [varchar](4095) NULL,
	[CustomField9] [varchar](4095) NULL,
	[CustomField10] [varchar](4095) NULL,
	[SeqNum] [int] NULL,
	[PARENT_GroupID] [varchar](255) NULL,
	[PARENT_ID] [varchar](255) NULL
) ON [PRIMARY]
GO