MySQL Server Database Schema Create for QuickBooks Online

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

CREATE TABLE `account` (
  `Id` varchar(255) DEFAULT NULL,
  `SyncToken` text,
  `CreateTime` datetime DEFAULT NULL,
  `LastUpdatedTime` datetime DEFAULT NULL,
  `Domain` text,
  `Name` text,
  `AcctNum` text,
  `FullyQualifiedName` text,
  `AccountAlias` text,
  `Active` varchar(5) DEFAULT NULL,
  `SubAccount` varchar(5) DEFAULT NULL,
  `ParentRef_Id` text,
  `ParentRef_Name` text,
  `CurrencyRef_Id` text,
  `CurrencyRef_Name` text,
  `Description` text,
  `Classification` text,
  `ClassificationSpecified` varchar(5) DEFAULT NULL,
  `TxnLocationType` text,
  `AccountType` text,
  `CurrentBalance` decimal(15,2) DEFAULT NULL,
  `CurrentBalanceSpecified` varchar(5) DEFAULT NULL,
  `CurrentBalanceWithSubAccounts` decimal(15,2) DEFAULT NULL,
  `CurrentBalanceWithSubAccountsSpecified` varchar(5) DEFAULT NULL,
  `TaxCodeRef_Id` text,
  `TaxCodeRef_Name` text,
  `TaxAccount` varchar(5) DEFAULT NULL,
  `TaxAccountSpecified` varchar(5) DEFAULT NULL,
  `AccountSubType` text,
  `SubAccountSpecified` varchar(5) DEFAULT NULL,
  `JournalCodeRef_Id` text,
  `JournalCodeRef_Name` text,
  `AccountTypeSpecified` varchar(5) DEFAULT NULL,
  `ActiveSpecified` varchar(5) DEFAULT NULL,
  `AcctNumExtn` text,
  `BankNum` text,
  `FIName` text,
  `OpeningBalance` decimal(15,2) DEFAULT NULL,
  `OpeningBalanceDate` datetime DEFAULT NULL,
  `OpeningBalanceDateSpecified` varchar(5) DEFAULT NULL,
  `OpeningBalanceSpecified` varchar(5) DEFAULT NULL,
  `OnlineBankingEnabledSpecified` varchar(5) DEFAULT NULL,
  `OnlineBankingEnabled` varchar(5) DEFAULT NULL,
  `UserData` text,
  `Operation` text,
  `sparse` varchar(5) DEFAULT NULL,
  `LSData` text
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_0900_ai_ci;


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



CREATE TABLE `billlinedetail` (
  `Id` varchar(255) DEFAULT NULL,
  `LineNum` text,
  `Description` text,
  `Amount` decimal(15,2) DEFAULT NULL,
  `AmountSpecified` varchar(5) DEFAULT NULL,
  `DetailType` text,
  `DetailTypeSpecified` varchar(5) DEFAULT NULL,
  `ItemRef_Id` text,
  `ItemRef_Name` text,
  `ClassRef_Id` text,
  `ClassRef_Name` text,
  `PriceLevelRef_Id` text,
  `PriceLevelRef_Name` text,
  `RatePercent` decimal(15,2) DEFAULT NULL,
  `UnitPrice` decimal(15,2) DEFAULT NULL,
  `Qty` decimal(15,2) DEFAULT NULL,
  `QtySpecified` varchar(5) DEFAULT NULL,
  `UOMSetRef_Unit` text,
  `UOMSetRef_Id` text,
  `UOMSetRef_Name` text,
  `ItemAccountRef_Id` text,
  `ItemAccountRef_Name` text,
  `InventorySiteRef_Id` text,
  `InventorySiteRef_Name` text,
  `TaxCodeRef_Id` text,
  `TaxCodeRef_Name` text,
  `TaxClassificationRef_Id` text,
  `TaxClassificationRef_Name` text,
  `CustomerRef_Id` text,
  `CustomerRef_Name` text,
  `BillableStatus` text,
  `BillableStatusSpecified` varchar(5) DEFAULT NULL,
  `TaxInclusiveAmt` decimal(15,2) DEFAULT NULL,
  `TaxInclusiveAmtSpecified` varchar(5) DEFAULT NULL,
  `AccountRef_Id` text,
  `AccountRef_Name` text,
  `TaxAmount` decimal(15,2) DEFAULT NULL,
  `TaxAmountSpecified` varchar(5) DEFAULT NULL,
  `MarkupPercentBased` varchar(5) DEFAULT NULL,
  `MarkupPercentBasedSpecified` varchar(5) DEFAULT NULL,
  `MarkupValue` decimal(15,2) DEFAULT NULL,
  `MarkupValueSpecified` varchar(5) DEFAULT NULL,
  `MarkupPercent` decimal(15,2) DEFAULT NULL,
  `MarkupPercentSpecified` varchar(5) DEFAULT NULL,
  `MarkupPriceLevelRef_Id` text,
  `MarkupPriceLevelRef_Name` text,
  `MarkupIncomeAccountRef_Id` text,
  `MarkupIncomeAccountRef_Name` text,
  `CustomField1` text,
  `CustomField2` text,
  `CustomField3` text,
  `CustomField4` text,
  `CustomField5` text,
  `CustomField6` text,
  `CustomField7` text,
  `CustomField8` text,
  `CustomField9` text,
  `CustomField10` text,
  `SeqNum` int DEFAULT NULL,
  `PARENT_GroupID` varchar(255) DEFAULT NULL,
  `PARENT_ID` varchar(255) DEFAULT NULL
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_0900_ai_ci;




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




CREATE TABLE `billpaymentlinedetail` (
  `Id` varchar(255) DEFAULT NULL,
  `LineNum` text,
  `Description` text,
  `Amount` decimal(15,2) DEFAULT NULL,
  `AmountSpecified` varchar(5) DEFAULT NULL,
  `CustomField1` text,
  `CustomField2` text,
  `CustomField3` text,
  `CustomField4` text,
  `CustomField5` text,
  `CustomField6` text,
  `CustomField7` text,
  `CustomField8` text,
  `CustomField9` text,
  `CustomField10` text,
  `SeqNum` int DEFAULT NULL,
  `PARENT_GroupID` varchar(255) DEFAULT NULL,
  `PARENT_ID` varchar(255) DEFAULT NULL
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_0900_ai_ci;




CREATE TABLE `class` (
  `Id` varchar(255) DEFAULT NULL,
  `SyncToken` text,
  `CreateTime` datetime DEFAULT NULL,
  `LastUpdatedTime` datetime DEFAULT NULL,
  `Name` text,
  `FullyQualifiedName` text,
  `ParentRef_Id` text,
  `ParentRef_Name` text,
  `SubClassSpecified` varchar(5) DEFAULT NULL,
  `SubClass` varchar(5) DEFAULT NULL,
  `Active` varchar(5) DEFAULT NULL,
  `ActiveSpecified` varchar(5) DEFAULT NULL,
  `UserData` text,
  `Operation` text,
  `sparse` varchar(5) DEFAULT NULL,
  `LSData` text
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_0900_ai_ci;





CREATE TABLE `company` (
  `Id` varchar(255) DEFAULT NULL,
  `SyncToken` text,
  `CreateTime` datetime DEFAULT NULL,
  `LastUpdatedTime` datetime DEFAULT NULL,
  `Domain` text,
  `LegalAddr_Id` text,
  `LegalAddr_City` text,
  `LegalAddr_Country` text,
  `LegalAddr_Line1` text,
  `LegalAddr_PostalCode` text,
  `LegalAddr_CountryCode` text,
  `SupportedLanguages` text,
  `CompanyName` text,
  `Country` text,
  `CompanyAddr_Id` text,
  `CompanyAddr_City` text,
  `CompanyAddr_Country` text,
  `CompanyAddr_Line1` text,
  `CompanyAddr_PostalCode` text,
  `CompanyAddr_CountryCode` text,
  `WebAddrURI` text,
  `FiscalYearStartMonth` text,
  `CommunicationAddr_Id` text,
  `CommunicationAddr_City` text,
  `CommunicationAddr_Country` text,
  `CommunicationAddr_Line1` text,
  `CommunicationAddr_PostalCode` text,
  `CommunicationAddr_CountryCode` text,
  `CommunicationEmailAddress` text,
  `PrimaryPhone` text,
  `LegalName` text,
  `CompanyStartDate` text,
  `Email` text,
  `NameValue` text,
  `UserData` text,
  `Operation` text,
  `sparse` varchar(5) DEFAULT NULL,
  `LSData` text
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_0900_ai_ci;





CREATE TABLE `companycurrency` (
  `Id` varchar(255) DEFAULT NULL,
  `SyncToken` text,
  `CreateTime` datetime DEFAULT NULL,
  `LastUpdatedTime` datetime DEFAULT NULL,
  `Name` text,
  `Code` text,
  `Active` varchar(5) DEFAULT NULL,
  `ActiveSpecified` varchar(5) DEFAULT NULL,
  `CustomField1` text,
  `CustomField2` text,
  `CustomField3` text,
  `CustomField4` text,
  `CustomField5` text,
  `CustomField6` text,
  `CustomField7` text,
  `CustomField8` text,
  `CustomField9` text,
  `CustomField10` text,
  `UserData` text,
  `Operation` text,
  `sparse` varchar(5) DEFAULT NULL,
  `LSData` text
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_0900_ai_ci;






CREATE TABLE `companypreferences` (
  `Id` varchar(255) DEFAULT NULL,
  `SyncToken` text,
  `CreateTime` datetime DEFAULT NULL,
  `LastUpdatedTime` datetime DEFAULT NULL,
  `InvoiceMessage` text,
  `InvoiceSubject` text,
  `EstimateMessage` text,
  `EstimateSubject` text,
  `SalesReceiptMessage` text,
  `SalesReceiptSubject` text,
  `StatementMessage` text,
  `StatementSubject` text,
  `QuantityWithPriceAndRate` varchar(5) DEFAULT NULL,
  `ForPurchase` varchar(5) DEFAULT NULL,
  `QuantityOnHand` varchar(5) DEFAULT NULL,
  `ForSales` varchar(5) DEFAULT NULL,
  `ReportBasis` text,
  `CalcAgingReportFromTxnDate` varchar(5) DEFAULT NULL,
  `FirstMonthOfFiscalYear` text,
  `UseAccountNumbers` varchar(5) DEFAULT NULL,
  `TaxYearMonth` text,
  `ClassTrackingPerTxn` varchar(5) DEFAULT NULL,
  `TrackDepartments` varchar(5) DEFAULT NULL,
  `TaxForm` text,
  `CustomerTerminology` text,
  `BookCloseDate` datetime DEFAULT NULL,
  `DepartmentTerminology` text,
  `ClassTrackingPerTxnLine` varchar(5) DEFAULT NULL,
  `ETransactionPaymentEnabled` varchar(5) DEFAULT NULL,
  `CustomTxnNumbers` varchar(5) DEFAULT NULL,
  `AllowShipping` varchar(5) DEFAULT NULL,
  `AllowServiceDate` varchar(5) DEFAULT NULL,
  `ETransactionEnabledStatus` text,
  `DefaultCustomerMessage` text,
  `EmailCopyToCompany` varchar(5) DEFAULT NULL,
  `AllowEstimates` varchar(5) DEFAULT NULL,
  `DefaultTerms` text,
  `AllowDiscount` varchar(5) DEFAULT NULL,
  `DefaultDiscountAccount` text,
  `AllowDeposit` varchar(5) DEFAULT NULL,
  `AutoApplyPayments` varchar(5) DEFAULT NULL,
  `IPNSupportEnabled` varchar(5) DEFAULT NULL,
  `AutoApplyCredit` varchar(5) DEFAULT NULL,
  `UsingSalesTax` varchar(5) DEFAULT NULL,
  `WorkWeekStartDate` text,
  `MarkTimeEntriesBillable` varchar(5) DEFAULT NULL,
  `ShowBillRateToAll` varchar(5) DEFAULT NULL,
  `UseServices` varchar(5) DEFAULT NULL,
  `BillCustomers` varchar(5) DEFAULT NULL,
  `HomeCurrency` text,
  `MultiCurrencyEnabled` varchar(5) DEFAULT NULL,
  `UserData` text,
  `Operation` text,
  `sparse` varchar(5) DEFAULT NULL,
  `LSData` text
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_0900_ai_ci;






CREATE TABLE `contactinfo` (
  `TypeContactValue` text,
  `TypeContactInfo` text,
  `TypeSpecified` text,
  `SeqNum` int DEFAULT NULL,
  `ParentTableType` varchar(255) DEFAULT NULL,
  `PARENT_ID` varchar(255) DEFAULT NULL
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_0900_ai_ci;






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





CREATE TABLE `creditmemolinedetail` (
  `Id` varchar(255) DEFAULT NULL,
  `LineNum` text,
  `Description` text,
  `Amount` decimal(15,2) DEFAULT NULL,
  `AmountSpecified` varchar(5) DEFAULT NULL,
  `DetailType` text,
  `DetailTypeSpecified` varchar(5) DEFAULT NULL,
  `PriceLevelRef_Id` text,
  `PriceLevelRef_Name` text,
  `RatePercent` decimal(15,2) DEFAULT NULL,
  `UnitPrice` decimal(15,2) DEFAULT NULL,
  `TaxInclusiveAmt` decimal(15,2) DEFAULT NULL,
  `TaxInclusiveAmtSpecified` varchar(5) DEFAULT NULL,
  `DiscountAmt` decimal(15,2) DEFAULT NULL,
  `DiscountAmtSpecified` varchar(5) DEFAULT NULL,
  `ServiceDate` datetime DEFAULT NULL,
  `ServiceDateSpecified` varchar(5) DEFAULT NULL,
  `DiscountRate` decimal(15,2) DEFAULT NULL,
  `DiscountRateSpecified` varchar(5) DEFAULT NULL,
  `TaxClassificationRef_Id` text,
  `TaxClassificationRef_Name` text,
  `ItemAccountRef_Id` text,
  `ItemAccountRef_Name` text,
  `InventorySiteRef_Id` text,
  `InventorySiteRef_Name` text,
  `TaxCodeRef_Id` text,
  `TaxCodeRef_Name` text,
  `ClassRef_Id` text,
  `ClassRef_Name` text,
  `ItemRef_Id` text,
  `ItemRef_Name` text,
  `UOMUnit` text,
  `UOMSetRef_Id` text,
  `UOMSetRef_Name` text,
  `Qty` decimal(15,2) DEFAULT NULL,
  `QtySpecified` varchar(5) DEFAULT NULL,
  `GroupItemRef_Id` text,
  `GroupItemRef_Name` text,
  `DiscountAccountRef_Id` text,
  `DiscountAccountRef_Name` text,
  `DiscountRef_Id` text,
  `DiscountRef_Name` text,
  `DiscountPercent` decimal(15,2) DEFAULT NULL,
  `DiscountPercentSpecified` varchar(5) DEFAULT NULL,
  `PercentBased` varchar(5) DEFAULT NULL,
  `PercentBasedSpecified` varchar(5) DEFAULT NULL,
  `MarkupPercentBased` varchar(5) DEFAULT NULL,
  `MarkupPercentBasedSpecified` varchar(5) DEFAULT NULL,
  `MarkupPriceLevelRef_Id` text,
  `MarkupPriceLevelRef_Name` text,
  `MarkupValue` decimal(15,2) DEFAULT NULL,
  `MarkupValueSpecified` varchar(5) DEFAULT NULL,
  `MarkupPercent` decimal(15,2) DEFAULT NULL,
  `MarkupPercentSpecified` varchar(5) DEFAULT NULL,
  `MarkupIncomeAccountRef_Id` text,
  `MarkupIncomeAccountRef_Name` text,
  `CustomField1` text,
  `CustomField2` text,
  `CustomField3` text,
  `CustomField4` text,
  `CustomField5` text,
  `CustomField6` text,
  `CustomField7` text,
  `CustomField8` text,
  `CustomField9` text,
  `CustomField10` text,
  `SeqNum` int DEFAULT NULL,
  `PARENT_GroupID` varchar(255) DEFAULT NULL,
  `PARENT_ID` varchar(255) DEFAULT NULL
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_0900_ai_ci;





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






CREATE TABLE `customertype` (
  `Id` varchar(255) DEFAULT NULL,
  `SyncToken` text,
  `CreateTime` datetime DEFAULT NULL,
  `LastUpdatedTime` datetime DEFAULT NULL,
  `Name` text,
  `ParentRef_Id` text,
  `ParentRef_Name` text,
  `FullyQualifiedName` text,
  `Active` varchar(5) DEFAULT NULL,
  `ActiveSpecified` varchar(5) DEFAULT NULL,
  `UserData` text,
  `Operation` text,
  `sparse` varchar(5) DEFAULT NULL,
  `LSData` text
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_0900_ai_ci;





CREATE TABLE `customfieldpreferences` (
  `BooleanValue` varchar(255) DEFAULT NULL,
  `CustomFieldType` varchar(255) DEFAULT NULL,
  `CustomFieldName` varchar(255) DEFAULT NULL,
  `PARENT_ID` varchar(255) DEFAULT NULL
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_0900_ai_ci;





CREATE TABLE `department` (
  `Id` varchar(255) DEFAULT NULL,
  `SyncToken` text,
  `CreateTime` datetime DEFAULT NULL,
  `LastUpdatedTime` datetime DEFAULT NULL,
  `Name` text,
  `SubDepartment` varchar(5) DEFAULT NULL,
  `SubDepartmentSpecified` varchar(5) DEFAULT NULL,
  `ParentRef_Id` text,
  `ParentRef_Name` text,
  `FullyQualifiedName` text,
  `Active` varchar(5) DEFAULT NULL,
  `ActiveSpecified` varchar(5) DEFAULT NULL,
  `Address_Id` text,
  `Address_Line1` text,
  `Address_Line2` text,
  `Address_Line3` text,
  `Address_Line4` text,
  `Address_Line5` text,
  `Address_City` text,
  `Address_Country` text,
  `Address_PostalCode` text,
  `Address_PostalCodeSuffix` text,
  `Address_CountryCode` text,
  `Address_CountrySubDivisionCode` text,
  `Address_Lat` text,
  `Address_Long` text,
  `Address_Note` text,
  `Address_Tag` text,
  `UserData` text,
  `Operation` text,
  `sparse` varchar(5) DEFAULT NULL,
  `LSData` text
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_0900_ai_ci;





CREATE TABLE `deposit` (
  `Id` varchar(255) DEFAULT NULL,
  `SyncToken` text,
  `CreateTime` datetime DEFAULT NULL,
  `LastUpdatedTime` datetime DEFAULT NULL,
  `Name` text,
  `AccountRef_Id` text,
  `AccountRef_Name` text,
  `Amount` decimal(15,2) DEFAULT NULL,
  `AmountSpecified` varchar(5) DEFAULT NULL,
  `Memo` text,
  `TxnSource` text,
  `PrivateNote` text,
  `ExchangeRate` decimal(15,2) DEFAULT NULL,
  `ExchangeRateSpecified` varchar(5) DEFAULT NULL,
  `CurrencyRef_Id` text,
  `CurrencyRef_Name` text,
  `DepartmentRef_Id` text,
  `DepartmentRef_Name` text,
  `TxnDateSpecified` varchar(5) DEFAULT NULL,
  `TxnDate` datetime DEFAULT NULL,
  `TransactionLocationType` text,
  `DepositToAccountRef_Id` text,
  `DepositToAccountRef_Name` text,
  `GlobalTaxCalculation` text,
  `GlobalTaxCalculationSpecified` varchar(5) DEFAULT NULL,
  `TotalAmt` decimal(15,2) DEFAULT NULL,
  `TotalAmtSpecified` varchar(5) DEFAULT NULL,
  `HomeTotalAmt` decimal(15,2) DEFAULT NULL,
  `HomeTotalAmtSpecified` varchar(5) DEFAULT NULL,
  `TotalTaxSpecified` varchar(5) DEFAULT NULL,
  `TotalTax` decimal(15,2) DEFAULT NULL,
  `TxnTaxCodeRef_Id` text,
  `TxnTaxCodeRef_Name` text,
  `DefaultTaxCodeRef_Id` text,
  `DefaultTaxCodeRef_Name` text,
  `UserData` text,
  `Operation` text,
  `sparse` varchar(5) DEFAULT NULL,
  `LSData` text
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_0900_ai_ci;




CREATE TABLE `depositlinedetail` (
  `Id` varchar(255) DEFAULT NULL,
  `LineNum` text,
  `Description` text,
  `Amount` decimal(15,2) DEFAULT NULL,
  `AmountSpecified` varchar(5) DEFAULT NULL,
  `Entity_Id` text,
  `Entity_Name` text,
  `ProjectRef_Id` text,
  `ProjectRef_Name` text,
  `ClassRef_Id` text,
  `ClassRef_Name` text,
  `AccountRef_Id` text,
  `AccountRef_Name` text,
  `PaymentMethodRef_Id` text,
  `PaymentMethodRef_Name` text,
  `CheckNum` text,
  `TxnType` text,
  `TxnTypeSpecified` varchar(5) DEFAULT NULL,
  `TaxCodeRef_Id` text,
  `TaxCodeRef_Name` text,
  `TaxApplicableOn` text,
  `TaxApplicableOnSpecified` varchar(5) DEFAULT NULL,
  `CustomField1` text,
  `CustomField2` text,
  `CustomField3` text,
  `CustomField4` text,
  `CustomField5` text,
  `CustomField6` text,
  `CustomField7` text,
  `CustomField8` text,
  `CustomField9` text,
  `CustomField10` text,
  `SeqNum` int DEFAULT NULL,
  `PARENT_GroupID` varchar(255) DEFAULT NULL,
  `PARENT_ID` varchar(255) DEFAULT NULL
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_0900_ai_ci;





CREATE TABLE `effectivetaxrate` (
  `Id` varchar(255) DEFAULT NULL,
  `RateValue` decimal(15,2) DEFAULT NULL,
  `RateValueSpecified` varchar(5) DEFAULT NULL,
  `EffectiveDate` datetime DEFAULT NULL,
  `EffectiveDateSpecified` varchar(5) DEFAULT NULL,
  `EndDate` datetime DEFAULT NULL,
  `EndDateSpecified` varchar(5) DEFAULT NULL,
  `SeqNum` int DEFAULT NULL,
  `LetSyncId` varchar(5) DEFAULT NULL,
  `ParentTableType` varchar(255) DEFAULT NULL,
  `PARENT_ID` varchar(255) DEFAULT NULL
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_0900_ai_ci;






CREATE TABLE `employee` (
  `Id` varchar(255) DEFAULT NULL,
  `SyncToken` text,
  `CreateTime` datetime DEFAULT NULL,
  `LastUpdatedTime` datetime DEFAULT NULL,
  `Name` text,
  `GivenName` text,
  `MiddleName` text,
  `FamilyName` text,
  `Suffix` text,
  `FullyQualifiedName` text,
  `DisplayName` text,
  `PrintOnCheckName` text,
  `Title` text,
  `Active` varchar(5) DEFAULT NULL,
  `ActiveSpecified` varchar(5) DEFAULT NULL,
  `PrimaryPhone` text,
  `Mobile` text,
  `Fax` text,
  `PrimaryEmailAddress` text,
  `Organization` varchar(5) DEFAULT NULL,
  `OrganizationSpecified` varchar(5) DEFAULT NULL,
  `UseTimeEntrySpecified` varchar(5) DEFAULT NULL,
  `UseTimeEntry` text,
  `ReleasedDateSpecified` varchar(5) DEFAULT NULL,
  `ReleasedDate` datetime DEFAULT NULL,
  `HiredDate` datetime DEFAULT NULL,
  `HiredDateSpecified` varchar(5) DEFAULT NULL,
  `Gender` text,
  `GenderSpecified` varchar(5) DEFAULT NULL,
  `BirthDateSpecified` varchar(5) DEFAULT NULL,
  `BirthDate` datetime DEFAULT NULL,
  `BillRateSpecified` varchar(5) DEFAULT NULL,
  `BillRate` datetime DEFAULT NULL,
  `BillableTimeSpecified` varchar(5) DEFAULT NULL,
  `BillableTime` varchar(5) DEFAULT NULL,
  `SSN` text,
  `EmployeeNumber` text,
  `EmployeeType` text,
  `V4IDPseudonym` text,
  `PrimaryAddr_Id` text,
  `PrimaryAddr_Line1` text,
  `PrimaryAddr_Line2` text,
  `PrimaryAddr_Line3` text,
  `PrimaryAddr_Line4` text,
  `PrimaryAddr_Line5` text,
  `PrimaryAddr_City` text,
  `PrimaryAddr_PostalCode` text,
  `PrimaryAddr_PostalCodeSuffix` text,
  `PrimaryAddr_Country` text,
  `PrimaryAddr_CountryCode` text,
  `PrimaryAddr_CountrySubDivisionCode` text,
  `PrimaryAddr_Note` text,
  `PrimaryAddr_Long` text,
  `PrimaryAddr_Lat` text,
  `PrimaryAddr_Tag` text,
  `UserData` text,
  `Operation` text,
  `sparse` varchar(5) DEFAULT NULL,
  `LSData` text
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_0900_ai_ci;







CREATE TABLE `error_table` (
  `Id` varchar(255) DEFAULT NULL,
  `DateTimeLog` datetime DEFAULT NULL,
  `StatusCode` text,
  `StatusMessage` text,
  `PossibleSolution` text,
  `Method` text,
  `TableName` text,
  `TaskName` text,
  `TaskId` text,
  `CompanyFile` text,
  `RunBy` text,
  `SessionId` text
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_0900_ai_ci;





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





CREATE TABLE `estimatelinedetail` (
  `Id` varchar(255) DEFAULT NULL,
  `LineNum` text,
  `Description` text,
  `Amount` decimal(15,2) DEFAULT NULL,
  `AmountSpecified` varchar(5) DEFAULT NULL,
  `DetailType` text,
  `DetailTypeSpecified` varchar(5) DEFAULT NULL,
  `PriceLevelRef_Id` text,
  `PriceLevelRef_Name` text,
  `RatePercent` decimal(15,2) DEFAULT NULL,
  `UnitPrice` decimal(15,2) DEFAULT NULL,
  `TaxInclusiveAmt` decimal(15,2) DEFAULT NULL,
  `TaxInclusiveAmtSpecified` varchar(5) DEFAULT NULL,
  `DiscountAmt` decimal(15,2) DEFAULT NULL,
  `DiscountAmtSpecified` varchar(5) DEFAULT NULL,
  `ServiceDate` datetime DEFAULT NULL,
  `ServiceDateSpecified` varchar(5) DEFAULT NULL,
  `DiscountRate` decimal(15,2) DEFAULT NULL,
  `DiscountRateSpecified` varchar(5) DEFAULT NULL,
  `TaxClassificationRef_Id` text,
  `TaxClassificationRef_Name` text,
  `ItemAccountRef_Id` text,
  `ItemAccountRef_Name` text,
  `InventorySiteRef_Id` text,
  `InventorySiteRef_Name` text,
  `TaxCodeRef_Id` text,
  `TaxCodeRef_Name` text,
  `ClassRef_Id` text,
  `ClassRef_Name` text,
  `ItemRef_Id` text,
  `ItemRef_Name` text,
  `UOMUnit` text,
  `UOMSetRef_Id` text,
  `UOMSetRef_Name` text,
  `Qty` decimal(15,2) DEFAULT NULL,
  `QtySpecified` varchar(5) DEFAULT NULL,
  `GroupItemRef_Id` text,
  `GroupItemRef_Name` text,
  `DiscountAccountRef_Id` text,
  `DiscountAccountRef_Name` text,
  `DiscountRef_Id` text,
  `DiscountRef_Name` text,
  `DiscountPercent` decimal(15,2) DEFAULT NULL,
  `DiscountPercentSpecified` varchar(5) DEFAULT NULL,
  `PercentBased` varchar(5) DEFAULT NULL,
  `PercentBasedSpecified` varchar(5) DEFAULT NULL,
  `MarkupPercentBased` varchar(5) DEFAULT NULL,
  `MarkupPercentBasedSpecified` varchar(5) DEFAULT NULL,
  `MarkupPriceLevelRef_Id` text,
  `MarkupPriceLevelRef_Name` text,
  `MarkupValue` decimal(15,2) DEFAULT NULL,
  `MarkupValueSpecified` varchar(5) DEFAULT NULL,
  `MarkupPercent` decimal(15,2) DEFAULT NULL,
  `MarkupPercentSpecified` varchar(5) DEFAULT NULL,
  `MarkupIncomeAccountRef_Id` text,
  `MarkupIncomeAccountRef_Name` text,
  `CustomField1` text,
  `CustomField2` text,
  `CustomField3` text,
  `CustomField4` text,
  `CustomField5` text,
  `CustomField6` text,
  `CustomField7` text,
  `CustomField8` text,
  `CustomField9` text,
  `CustomField10` text,
  `SeqNum` int DEFAULT NULL,
  `PARENT_GroupID` varchar(255) DEFAULT NULL,
  `PARENT_ID` varchar(255) DEFAULT NULL
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_0900_ai_ci;






CREATE TABLE `exchangerate` (
  `Id` varchar(255) DEFAULT NULL,
  `SyncToken` text,
  `CreateTime` datetime DEFAULT NULL,
  `LastUpdatedTime` datetime DEFAULT NULL,
  `Name` text,
  `SourceCurrencyCode` text,
  `TargetCurrencyCode` text,
  `Rate` decimal(15,2) DEFAULT NULL,
  `RateSpecified` varchar(5) DEFAULT NULL,
  `AsOfDate` datetime DEFAULT NULL,
  `AsOfDateSpecified` varchar(5) DEFAULT NULL,
  `UserData` text,
  `Operation` text,
  `sparse` varchar(5) DEFAULT NULL,
  `LSData` text
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_0900_ai_ci;





CREATE TABLE `history` (
  `Id` varchar(255) DEFAULT NULL,
  `TableOrTaskName` text,
  `ModifiedDateTime` datetime DEFAULT NULL,
  `RunBy` text,
  `CompanyFile` varchar(255) DEFAULT NULL,
  `LSOperation` text,
  `RecordsAdded_ToQuickBooks` int DEFAULT NULL,
  `RecordsDeleted_FromQuickBoks` int DEFAULT NULL,
  `RecordsUpdated_ToQuickBooks` int DEFAULT NULL,
  `RecordsVoided_ToQuickBooks` int DEFAULT NULL,
  `RecordsAdded_ToDatabase` int DEFAULT NULL,
  `RecordsDeleted_FromDatabase` int DEFAULT NULL,
  `RecordsUpdated_ToDatabase` int DEFAULT NULL,
  `RecordsRefreshed_ToDatabase` int DEFAULT NULL,
  `RecordsAddedFromReport_ToDatabase` int DEFAULT NULL,
  `StartRunningDateTime` datetime DEFAULT NULL,
  `EndRunningDateTime` datetime DEFAULT NULL,
  `Result` text
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_0900_ai_ci;





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





CREATE TABLE `invoicelinedetail` (
  `Id` varchar(255) DEFAULT NULL,
  `LineNum` text,
  `Description` text,
  `Amount` decimal(15,2) DEFAULT NULL,
  `AmountSpecified` varchar(5) DEFAULT NULL,
  `DetailType` text,
  `DetailTypeSpecified` varchar(5) DEFAULT NULL,
  `PriceLevelRef_Id` text,
  `PriceLevelRef_Name` text,
  `RatePercent` decimal(15,2) DEFAULT NULL,
  `UnitPrice` decimal(15,2) DEFAULT NULL,
  `TaxInclusiveAmt` decimal(15,2) DEFAULT NULL,
  `TaxInclusiveAmtSpecified` varchar(5) DEFAULT NULL,
  `DiscountAmt` decimal(15,2) DEFAULT NULL,
  `DiscountAmtSpecified` varchar(5) DEFAULT NULL,
  `ServiceDate` datetime DEFAULT NULL,
  `ServiceDateSpecified` varchar(5) DEFAULT NULL,
  `DiscountRate` decimal(15,2) DEFAULT NULL,
  `DiscountRateSpecified` varchar(5) DEFAULT NULL,
  `TaxClassificationRef_Id` text,
  `TaxClassificationRef_Name` text,
  `ItemAccountRef_Id` text,
  `ItemAccountRef_Name` text,
  `InventorySiteRef_Id` text,
  `InventorySiteRef_Name` text,
  `TaxCodeRef_Id` text,
  `TaxCodeRef_Name` text,
  `ClassRef_Id` text,
  `ClassRef_Name` text,
  `ItemRef_Id` text,
  `ItemRef_Name` text,
  `UOMUnit` text,
  `UOMSetRef_Id` text,
  `UOMSetRef_Name` text,
  `Qty` decimal(15,2) DEFAULT NULL,
  `QtySpecified` varchar(5) DEFAULT NULL,
  `GroupItemRef_Id` text,
  `GroupItemRef_Name` text,
  `DiscountAccountRef_Id` text,
  `DiscountAccountRef_Name` text,
  `DiscountRef_Id` text,
  `DiscountRef_Name` text,
  `DiscountPercent` decimal(15,2) DEFAULT NULL,
  `DiscountPercentSpecified` varchar(5) DEFAULT NULL,
  `PercentBased` varchar(5) DEFAULT NULL,
  `PercentBasedSpecified` varchar(5) DEFAULT NULL,
  `MarkupPercentBased` varchar(5) DEFAULT NULL,
  `MarkupPercentBasedSpecified` varchar(5) DEFAULT NULL,
  `MarkupPriceLevelRef_Id` text,
  `MarkupPriceLevelRef_Name` text,
  `MarkupValue` decimal(15,2) DEFAULT NULL,
  `MarkupValueSpecified` varchar(5) DEFAULT NULL,
  `MarkupPercent` decimal(15,2) DEFAULT NULL,
  `MarkupPercentSpecified` varchar(5) DEFAULT NULL,
  `MarkupIncomeAccountRef_Id` text,
  `MarkupIncomeAccountRef_Name` text,
  `CustomField1` text,
  `CustomField2` text,
  `CustomField3` text,
  `CustomField4` text,
  `CustomField5` text,
  `CustomField6` text,
  `CustomField7` text,
  `CustomField8` text,
  `CustomField9` text,
  `CustomField10` text,
  `SeqNum` int DEFAULT NULL,
  `PARENT_GroupID` varchar(255) DEFAULT NULL,
  `PARENT_ID` varchar(255) DEFAULT NULL
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_0900_ai_ci;






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





CREATE TABLE `itemcomponentline` (
  `Id` varchar(255) DEFAULT NULL,
  `ItemRef_Id` text,
  `ItemRef_Name` text,
  `ItemType` varchar(255) DEFAULT NULL,
  `Qty` decimal(15,2) DEFAULT NULL,
  `QtySpecified` varchar(5) DEFAULT NULL,
  `UOMRef_Unit` text,
  `UOMSetRef_Id` text,
  `UOMSetRef_Name` text,
  `SeqNum` int DEFAULT NULL,
  `LetSyncId` varchar(5) DEFAULT NULL,
  `ParentTableType` varchar(255) DEFAULT NULL,
  `PARENT_ID` varchar(255) DEFAULT NULL
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_0900_ai_ci;





CREATE TABLE `journalentry` (
  `Id` varchar(255) DEFAULT NULL,
  `SyncToken` text,
  `CreateTime` datetime DEFAULT NULL,
  `LastUpdatedTime` datetime DEFAULT NULL,
  `Name` text,
  `TxnDate` datetime DEFAULT NULL,
  `TxnDateSpecified` varchar(5) DEFAULT NULL,
  `PrivateNote` text,
  `ExchangeRate` decimal(15,2) DEFAULT NULL,
  `ExchangeRateSpecified` varchar(5) DEFAULT NULL,
  `CurrencyRef_Id` text,
  `CurrencyRef_Name` text,
  `DepartmentRef_Id` text,
  `DepartmentRef_Name` text,
  `DocNumber` text,
  `TransactionLocationType` text,
  `Adjustment` varchar(5) DEFAULT NULL,
  `AdjustmentSpecified` varchar(5) DEFAULT NULL,
  `HomeCurrencyAdjustment` varchar(5) DEFAULT NULL,
  `HomeCurrencyAdjustmentSpecified` varchar(5) DEFAULT NULL,
  `EnteredInHomeCurrency` varchar(5) DEFAULT NULL,
  `EnteredInHomeCurrencySpecified` varchar(5) DEFAULT NULL,
  `TotalAmt` decimal(15,2) DEFAULT NULL,
  `TotalAmtSpecified` varchar(5) DEFAULT NULL,
  `HomeTotalAmt` decimal(15,2) DEFAULT NULL,
  `HomeTotalAmtSpecified` varchar(5) DEFAULT NULL,
  `TotalTaxSpecified` varchar(5) DEFAULT NULL,
  `TotalTax` decimal(15,2) DEFAULT NULL,
  `TxnTaxCodeRef_Id` text,
  `TxnTaxCodeRef_Name` text,
  `DefaultTaxCodeRef_Id` text,
  `DefaultTaxCodeRef_Name` text,
  `UserData` text,
  `Operation` text,
  `sparse` varchar(5) DEFAULT NULL,
  `LSData` text
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_0900_ai_ci;





CREATE TABLE `journalentrylinedetail` (
  `Id` varchar(255) DEFAULT NULL,
  `LineNum` text,
  `Description` text,
  `Amount` decimal(15,2) DEFAULT NULL,
  `AmountSpecified` varchar(5) DEFAULT NULL,
  `DetailType` text,
  `DetailTypeSpecified` varchar(5) DEFAULT NULL,
  `PostingType` text,
  `PostingTypeSpecified` varchar(5) DEFAULT NULL,
  `EntityType` text,
  `EntityTypeSpecified` varchar(5) DEFAULT NULL,
  `EntityRef_Id` text,
  `EntityRef_Name` text,
  `ServiceDate` text,
  `ServiceDateSpecified` datetime DEFAULT NULL,
  `AccountRef_Id` text,
  `AccountRef_Name` text,
  `ClassRef_Id` text,
  `ClassRef_Name` text,
  `DepartmentRef_Id` text,
  `DepartmentRef_Name` text,
  `ProjectRef_Id` text,
  `ProjectRef_Name` text,
  `TaxCodeRef_Id` text,
  `TaxCodeRef_Name` text,
  `TaxApplicableOn` text,
  `TaxApplicableOnSpecified` varchar(5) DEFAULT NULL,
  `TaxAmount` decimal(15,2) DEFAULT NULL,
  `TaxAmountSpecified` varchar(5) DEFAULT NULL,
  `BillableStatus` text,
  `BillableStatusSpecified` varchar(5) DEFAULT NULL,
  `JournalCodeRef_Id` text,
  `JournalCodeRef_Name` text,
  `CustomField1` text,
  `CustomField2` text,
  `CustomField3` text,
  `CustomField4` text,
  `CustomField5` text,
  `CustomField6` text,
  `CustomField7` text,
  `CustomField8` text,
  `CustomField9` text,
  `CustomField10` text,
  `SeqNum` int DEFAULT NULL,
  `PARENT_GroupID` varchar(255) DEFAULT NULL,
  `PARENT_ID` varchar(255) DEFAULT NULL
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_0900_ai_ci;





CREATE TABLE `linkedtxn` (
  `TxnId` varchar(255) DEFAULT NULL,
  `TxnType` text,
  `TxnLineId` text,
  `SeqNum` int DEFAULT NULL,
  `PARENT_LineID` varchar(255) DEFAULT NULL,
  `ParentTableType` varchar(255) DEFAULT NULL,
  `PARENT_ID` varchar(255) DEFAULT NULL
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_0900_ai_ci;





CREATE TABLE `lsologging` (
  `Id` varchar(255) DEFAULT NULL,
  `DateTimeLog` datetime DEFAULT NULL,
  `StatusCode` text,
  `StatusMessage` text,
  `PossibleSolution` text,
  `Method` text,
  `TableName` text,
  `TaskName` text,
  `TaskId` text,
  `CompanyFile` text,
  `RunBy` text,
  `SessionId` text
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_0900_ai_ci;




CREATE TABLE `namevalue` (
  `Name` varchar(255) DEFAULT NULL,
  `Value` varchar(255) DEFAULT NULL,
  `PARENT_ID` varchar(255) DEFAULT NULL
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_0900_ai_ci;





CREATE TABLE `otheraddress` (
  `Id` varchar(255) DEFAULT NULL,
  `Line1` text,
  `Line2` text,
  `Line3` decimal(15,2) DEFAULT NULL,
  `Line4` text,
  `Line5` text,
  `City` text,
  `PostalCode` text,
  `PostalCodeSuffix` text,
  `Country` text,
  `CountryCode` text,
  `CountrySubDivisionCode` text,
  `Note` text,
  `LongField` text,
  `Lat` text,
  `Tag` text,
  `SeqNum` int DEFAULT NULL,
  `LetSyncId` varchar(5) DEFAULT NULL,
  `ParentTableType` varchar(255) DEFAULT NULL,
  `PARENT_ID` varchar(255) DEFAULT NULL
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_0900_ai_ci;





CREATE TABLE `otherpreferences` (
  `OtherPrefsName` text,
  `OtherPrefsValue` text,
  `PARENT_ID` varchar(255) DEFAULT NULL
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_0900_ai_ci;





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





CREATE TABLE `paymentlinedetail` (
  `Id` varchar(255) DEFAULT NULL,
  `LineNum` text,
  `Description` text,
  `Amount` decimal(15,2) DEFAULT NULL,
  `AmountSpecified` varchar(5) DEFAULT NULL,
  `ItemRef_Id` text,
  `ItemRef_Name` text,
  `ServiceDate` datetime DEFAULT NULL,
  `ServiceDateSpecified` varchar(5) DEFAULT NULL,
  `ClassRef_Id` text,
  `ClassRef_Name` text,
  `Balance` decimal(15,2) DEFAULT NULL,
  `BalanceSpecified` varchar(5) DEFAULT NULL,
  `HomeBalance` decimal(15,2) DEFAULT NULL,
  `HomeBalanceSpecified` varchar(5) DEFAULT NULL,
  `DiscountRef_Id` text,
  `DiscountRef_Name` text,
  `PercentBased` varchar(5) DEFAULT NULL,
  `PercentBasedSpecified` varchar(5) DEFAULT NULL,
  `DiscountPercent` decimal(15,2) DEFAULT NULL,
  `DiscountPercentSpecified` varchar(5) DEFAULT NULL,
  `DiscountAccountRef_Id` text,
  `DiscountAccountRef_Name` text,
  `CustomField1` text,
  `CustomField2` text,
  `CustomField3` text,
  `CustomField4` text,
  `CustomField5` text,
  `CustomField6` text,
  `CustomField7` text,
  `CustomField8` text,
  `CustomField9` text,
  `CustomField10` text,
  `SeqNum` int DEFAULT NULL,
  `PARENT_GroupID` varchar(255) DEFAULT NULL,
  `PARENT_ID` varchar(255) DEFAULT NULL
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_0900_ai_ci;






CREATE TABLE `paymentmethod` (
  `Id` varchar(255) DEFAULT NULL,
  `SyncToken` text,
  `CreateTime` datetime DEFAULT NULL,
  `LastUpdatedTime` datetime DEFAULT NULL,
  `Name` text,
  `Active` varchar(5) DEFAULT NULL,
  `ActiveSpecified` varchar(5) DEFAULT NULL,
  `Type` text,
  `UserData` text,
  `Operation` text,
  `sparse` varchar(5) DEFAULT NULL,
  `LSData` text
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_0900_ai_ci;





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





CREATE TABLE `purchaselinedetail` (
  `Id` varchar(255) DEFAULT NULL,
  `LineNum` text,
  `Description` text,
  `Amount` decimal(15,2) DEFAULT NULL,
  `AmountSpecified` varchar(5) DEFAULT NULL,
  `DetailType` text,
  `DetailTypeSpecified` varchar(5) DEFAULT NULL,
  `ItemRef_Id` text,
  `ItemRef_Name` text,
  `ClassRef_Id` text,
  `ClassRef_Name` text,
  `PriceLevelRef_Id` text,
  `PriceLevelRef_Name` text,
  `RatePercent` decimal(15,2) DEFAULT NULL,
  `UnitPrice` decimal(15,2) DEFAULT NULL,
  `Qty` decimal(15,2) DEFAULT NULL,
  `QtySpecified` varchar(5) DEFAULT NULL,
  `UOMSetRef_Unit` text,
  `UOMSetRef_Id` text,
  `UOMSetRef_Name` text,
  `ItemAccountRef_Id` text,
  `ItemAccountRef_Name` text,
  `InventorySiteRef_Id` text,
  `InventorySiteRef_Name` text,
  `TaxCodeRef_Id` text,
  `TaxCodeRef_Name` text,
  `TaxClassificationRef_Id` text,
  `TaxClassificationRef_Name` text,
  `CustomerRef_Id` text,
  `CustomerRef_Name` text,
  `BillableStatus` text,
  `BillableStatusSpecified` varchar(5) DEFAULT NULL,
  `TaxInclusiveAmt` decimal(15,2) DEFAULT NULL,
  `TaxInclusiveAmtSpecified` varchar(5) DEFAULT NULL,
  `AccountRef_Id` text,
  `AccountRef_Name` text,
  `TaxAmount` decimal(15,2) DEFAULT NULL,
  `TaxAmountSpecified` varchar(5) DEFAULT NULL,
  `MarkupPercentBased` varchar(5) DEFAULT NULL,
  `MarkupPercentBasedSpecified` varchar(5) DEFAULT NULL,
  `MarkupValue` decimal(15,2) DEFAULT NULL,
  `MarkupValueSpecified` varchar(5) DEFAULT NULL,
  `MarkupPercent` decimal(15,2) DEFAULT NULL,
  `MarkupPercentSpecified` varchar(5) DEFAULT NULL,
  `MarkupPriceLevelRef_Id` text,
  `MarkupPriceLevelRef_Name` text,
  `MarkupIncomeAccountRef_Id` text,
  `MarkupIncomeAccountRef_Name` text,
  `CustomField1` text,
  `CustomField2` text,
  `CustomField3` text,
  `CustomField4` text,
  `CustomField5` text,
  `CustomField6` text,
  `CustomField7` text,
  `CustomField8` text,
  `CustomField9` text,
  `CustomField10` text,
  `SeqNum` int DEFAULT NULL,
  `PARENT_GroupID` varchar(255) DEFAULT NULL,
  `PARENT_ID` varchar(255) DEFAULT NULL
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_0900_ai_ci;





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






CREATE TABLE `purchaseorderlinedetail` (
  `Id` varchar(255) DEFAULT NULL,
  `LineNum` text,
  `Description` text,
  `Amount` decimal(15,2) DEFAULT NULL,
  `AmountSpecified` varchar(5) DEFAULT NULL,
  `DetailType` text,
  `DetailTypeSpecified` varchar(5) DEFAULT NULL,
  `ItemRef_Id` text,
  `ItemRef_Name` text,
  `ClassRef_Id` text,
  `ClassRef_Name` text,
  `PriceLevelRef_Id` text,
  `PriceLevelRef_Name` text,
  `RatePercent` decimal(15,2) DEFAULT NULL,
  `UnitPrice` decimal(15,2) DEFAULT NULL,
  `Qty` decimal(15,2) DEFAULT NULL,
  `QtySpecified` varchar(5) DEFAULT NULL,
  `UOMSetRef_Unit` text,
  `UOMSetRef_Id` text,
  `UOMSetRef_Name` text,
  `ItemAccountRef_Id` text,
  `ItemAccountRef_Name` text,
  `InventorySiteRef_Id` text,
  `InventorySiteRef_Name` text,
  `TaxCodeRef_Id` text,
  `TaxCodeRef_Name` text,
  `TaxClassificationRef_Id` text,
  `TaxClassificationRef_Name` text,
  `CustomerRef_Id` text,
  `CustomerRef_Name` text,
  `BillableStatus` text,
  `BillableStatusSpecified` varchar(5) DEFAULT NULL,
  `TaxInclusiveAmt` decimal(15,2) DEFAULT NULL,
  `TaxInclusiveAmtSpecified` varchar(5) DEFAULT NULL,
  `AccountRef_Id` text,
  `AccountRef_Name` text,
  `TaxAmount` decimal(15,2) DEFAULT NULL,
  `TaxAmountSpecified` varchar(5) DEFAULT NULL,
  `MarkupPercentBased` varchar(5) DEFAULT NULL,
  `MarkupPercentBasedSpecified` varchar(5) DEFAULT NULL,
  `MarkupValue` decimal(15,2) DEFAULT NULL,
  `MarkupValueSpecified` varchar(5) DEFAULT NULL,
  `MarkupPercent` decimal(15,2) DEFAULT NULL,
  `MarkupPercentSpecified` varchar(5) DEFAULT NULL,
  `MarkupPriceLevelRef_Id` text,
  `MarkupPriceLevelRef_Name` text,
  `MarkupIncomeAccountRef_Id` text,
  `MarkupIncomeAccountRef_Name` text,
  `CustomField1` text,
  `CustomField2` text,
  `CustomField3` text,
  `CustomField4` text,
  `CustomField5` text,
  `CustomField6` text,
  `CustomField7` text,
  `CustomField8` text,
  `CustomField9` text,
  `CustomField10` text,
  `SeqNum` int DEFAULT NULL,
  `PARENT_GroupID` varchar(255) DEFAULT NULL,
  `PARENT_ID` varchar(255) DEFAULT NULL
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_0900_ai_ci;






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






CREATE TABLE `refundreceiptlinedetail` (
  `Id` varchar(255) DEFAULT NULL,
  `LineNum` text,
  `Description` text,
  `Amount` decimal(15,2) DEFAULT NULL,
  `AmountSpecified` varchar(5) DEFAULT NULL,
  `DetailType` text,
  `DetailTypeSpecified` varchar(5) DEFAULT NULL,
  `PriceLevelRef_Id` text,
  `PriceLevelRef_Name` text,
  `RatePercent` decimal(15,2) DEFAULT NULL,
  `UnitPrice` decimal(15,2) DEFAULT NULL,
  `TaxInclusiveAmt` decimal(15,2) DEFAULT NULL,
  `TaxInclusiveAmtSpecified` varchar(5) DEFAULT NULL,
  `DiscountAmt` decimal(15,2) DEFAULT NULL,
  `DiscountAmtSpecified` varchar(5) DEFAULT NULL,
  `ServiceDate` datetime DEFAULT NULL,
  `ServiceDateSpecified` varchar(5) DEFAULT NULL,
  `DiscountRate` decimal(15,2) DEFAULT NULL,
  `DiscountRateSpecified` varchar(5) DEFAULT NULL,
  `TaxClassificationRef_Id` text,
  `TaxClassificationRef_Name` text,
  `ItemAccountRef_Id` text,
  `ItemAccountRef_Name` text,
  `InventorySiteRef_Id` text,
  `InventorySiteRef_Name` text,
  `TaxCodeRef_Id` text,
  `TaxCodeRef_Name` text,
  `ClassRef_Id` text,
  `ClassRef_Name` text,
  `ItemRef_Id` text,
  `ItemRef_Name` text,
  `UOMUnit` text,
  `UOMSetRef_Id` text,
  `UOMSetRef_Name` text,
  `Qty` decimal(15,2) DEFAULT NULL,
  `QtySpecified` varchar(5) DEFAULT NULL,
  `GroupItemRef_Id` text,
  `GroupItemRef_Name` text,
  `DiscountAccountRef_Id` text,
  `DiscountAccountRef_Name` text,
  `DiscountRef_Id` text,
  `DiscountRef_Name` text,
  `DiscountPercent` decimal(15,2) DEFAULT NULL,
  `DiscountPercentSpecified` varchar(5) DEFAULT NULL,
  `PercentBased` varchar(5) DEFAULT NULL,
  `PercentBasedSpecified` varchar(5) DEFAULT NULL,
  `MarkupPercentBased` varchar(5) DEFAULT NULL,
  `MarkupPercentBasedSpecified` varchar(5) DEFAULT NULL,
  `MarkupPriceLevelRef_Id` text,
  `MarkupPriceLevelRef_Name` text,
  `MarkupValue` decimal(15,2) DEFAULT NULL,
  `MarkupValueSpecified` varchar(5) DEFAULT NULL,
  `MarkupPercent` decimal(15,2) DEFAULT NULL,
  `MarkupPercentSpecified` varchar(5) DEFAULT NULL,
  `MarkupIncomeAccountRef_Id` text,
  `MarkupIncomeAccountRef_Name` text,
  `CustomField1` text,
  `CustomField2` text,
  `CustomField3` text,
  `CustomField4` text,
  `CustomField5` text,
  `CustomField6` text,
  `CustomField7` text,
  `CustomField8` text,
  `CustomField9` text,
  `CustomField10` text,
  `SeqNum` int DEFAULT NULL,
  `PARENT_GroupID` varchar(255) DEFAULT NULL,
  `PARENT_ID` varchar(255) DEFAULT NULL
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_0900_ai_ci;






CREATE TABLE `reimbursecharge` (
  `Id` varchar(255) DEFAULT NULL,
  `SyncToken` text,
  `CreateTime` datetime DEFAULT NULL,
  `LastUpdatedTime` datetime DEFAULT NULL,
  `Name` text,
  `TxnDate` datetime DEFAULT NULL,
  `TxnDateSpecified` varchar(5) DEFAULT NULL,
  `ExchangeRate` decimal(15,2) DEFAULT NULL,
  `ExchangeRateSpecified` varchar(5) DEFAULT NULL,
  `Amount` decimal(15,2) DEFAULT NULL,
  `AmountSpecified` varchar(5) DEFAULT NULL,
  `CustomerRef_Id` text,
  `CustomerRef_Name` text,
  `CurrencyRef_Id` text,
  `CurrencyRef_Name` text,
  `PrivateNote` text,
  `UserData` text,
  `Operation` text,
  `sparse` varchar(5) DEFAULT NULL,
  `LSData` text
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_0900_ai_ci;





CREATE TABLE `reimburselinedetail` (
  `Id` varchar(255) DEFAULT NULL,
  `LineNum` text,
  `Description` text,
  `Amount` decimal(15,2) DEFAULT NULL,
  `AmountSpecified` varchar(5) DEFAULT NULL,
  `DetailType` text,
  `DetailTypeSpecified` varchar(5) DEFAULT NULL,
  `ClassRef_Id` text,
  `ClassRef_Name` text,
  `TaxCodeRef_Id` text,
  `TaxCodeRef_Name` text,
  `TaxClassificationRef_Id` text,
  `TaxClassificationRef_Name` text,
  `ItemAccountRef_Id` text,
  `ItemAccountRef_Name` text,
  `InventorySiteRef_Id` text,
  `InventorySiteRef_Name` text,
  `ItemRef_Id` text,
  `ItemRef_Name` text,
  `UOMUnit` text,
  `UOMSetRef_Id` text,
  `UOMSetRef_Name` text,
  `Qty` decimal(15,2) DEFAULT NULL,
  `QtySpecified` varchar(5) DEFAULT NULL,
  `PriceLevelRef_Id` text,
  `PriceLevelRef_Name` text,
  `RatePercent` decimal(15,2) DEFAULT NULL,
  `UnitPrice` decimal(15,2) DEFAULT NULL,
  `MarkupPercentBased` varchar(5) DEFAULT NULL,
  `MarkupPercentBasedSpecified` varchar(5) DEFAULT NULL,
  `MarkupPriceLevelRef_Id` text,
  `MarkupPriceLevelRef_Name` text,
  `MarkupValue` decimal(15,2) DEFAULT NULL,
  `MarkupValueSpecified` varchar(5) DEFAULT NULL,
  `MarkupPercent` decimal(15,2) DEFAULT NULL,
  `MarkupPercentSpecified` varchar(5) DEFAULT NULL,
  `MarkupIncomeAccountRef_Id` text,
  `MarkupIncomeAccountRef_Name` text,
  `SeqNum` int DEFAULT NULL,
  `PARENT_ID` varchar(255) DEFAULT NULL
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_0900_ai_ci;






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





CREATE TABLE `salesreceiptlinedetail` (
  `Id` varchar(255) DEFAULT NULL,
  `LineNum` text,
  `Description` text,
  `Amount` decimal(15,2) DEFAULT NULL,
  `AmountSpecified` varchar(5) DEFAULT NULL,
  `DetailType` text,
  `DetailTypeSpecified` varchar(5) DEFAULT NULL,
  `PriceLevelRef_Id` text,
  `PriceLevelRef_Name` text,
  `RatePercent` decimal(15,2) DEFAULT NULL,
  `UnitPrice` decimal(15,2) DEFAULT NULL,
  `TaxInclusiveAmt` decimal(15,2) DEFAULT NULL,
  `TaxInclusiveAmtSpecified` varchar(5) DEFAULT NULL,
  `DiscountAmt` decimal(15,2) DEFAULT NULL,
  `DiscountAmtSpecified` varchar(5) DEFAULT NULL,
  `ServiceDate` datetime DEFAULT NULL,
  `ServiceDateSpecified` varchar(5) DEFAULT NULL,
  `DiscountRate` decimal(15,2) DEFAULT NULL,
  `DiscountRateSpecified` varchar(5) DEFAULT NULL,
  `TaxClassificationRef_Id` text,
  `TaxClassificationRef_Name` text,
  `ItemAccountRef_Id` text,
  `ItemAccountRef_Name` text,
  `InventorySiteRef_Id` text,
  `InventorySiteRef_Name` text,
  `TaxCodeRef_Id` text,
  `TaxCodeRef_Name` text,
  `ClassRef_Id` text,
  `ClassRef_Name` text,
  `ItemRef_Id` text,
  `ItemRef_Name` text,
  `UOMUnit` text,
  `UOMSetRef_Id` text,
  `UOMSetRef_Name` text,
  `Qty` decimal(15,2) DEFAULT NULL,
  `QtySpecified` varchar(5) DEFAULT NULL,
  `GroupItemRef_Id` text,
  `GroupItemRef_Name` text,
  `DiscountAccountRef_Id` text,
  `DiscountAccountRef_Name` text,
  `DiscountRef_Id` text,
  `DiscountRef_Name` text,
  `DiscountPercent` decimal(15,2) DEFAULT NULL,
  `DiscountPercentSpecified` varchar(5) DEFAULT NULL,
  `PercentBased` varchar(5) DEFAULT NULL,
  `PercentBasedSpecified` varchar(5) DEFAULT NULL,
  `MarkupPercentBased` varchar(5) DEFAULT NULL,
  `MarkupPercentBasedSpecified` varchar(5) DEFAULT NULL,
  `MarkupPriceLevelRef_Id` text,
  `MarkupPriceLevelRef_Name` text,
  `MarkupValue` decimal(15,2) DEFAULT NULL,
  `MarkupValueSpecified` varchar(5) DEFAULT NULL,
  `MarkupPercent` decimal(15,2) DEFAULT NULL,
  `MarkupPercentSpecified` varchar(5) DEFAULT NULL,
  `MarkupIncomeAccountRef_Id` text,
  `MarkupIncomeAccountRef_Name` text,
  `CustomField1` text,
  `CustomField2` text,
  `CustomField3` text,
  `CustomField4` text,
  `CustomField5` text,
  `CustomField6` text,
  `CustomField7` text,
  `CustomField8` text,
  `CustomField9` text,
  `CustomField10` text,
  `SeqNum` int DEFAULT NULL,
  `PARENT_GroupID` varchar(255) DEFAULT NULL,
  `PARENT_ID` varchar(255) DEFAULT NULL
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_0900_ai_ci;





CREATE TABLE `statusinfo` (
  `status` text,
  `statusDate` datetime DEFAULT NULL,
  `statusDateSpecified` varchar(5) DEFAULT NULL,
  `callToAction` text,
  `SeqNum` int DEFAULT NULL,
  `ParentTableType` varchar(255) DEFAULT NULL,
  `PARENT_ID` varchar(255) DEFAULT NULL
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_0900_ai_ci;





CREATE TABLE `taxagency` (
  `Id` varchar(255) DEFAULT NULL,
  `SyncToken` text,
  `CreateTime` datetime DEFAULT NULL,
  `LastUpdatedTime` datetime DEFAULT NULL,
  `DisplayName` text,
  `TaxTrackedOnSales` varchar(5) DEFAULT NULL,
  `TaxTrackedOnSalesSpecified` varchar(5) DEFAULT NULL,
  `LastFileDate` datetime DEFAULT NULL,
  `LastFileDateSpecified` varchar(5) DEFAULT NULL,
  `TaxOnTax` varchar(5) DEFAULT NULL,
  `TaxOnTaxSpecified` varchar(5) DEFAULT NULL,
  `ReportingPeriod` text,
  `TaxRegistrationNumber` text,
  `SalesTaxCountry` text,
  `TaxTrackedOnSalesAccountRef_Id` text,
  `TaxTrackedOnSalesAccountRef_Name` text,
  `TaxOnPurchasesAccountRef_Id` text,
  `TaxOnPurchasesAccountRef_Name` text,
  `SalesTaxReturnRef_Id` text,
  `SalesTaxReturnRef_Name` text,
  `SalesTaxCodeRef_Id` text,
  `SalesTaxCodeRef_Name` text,
  `TaxTrackedOnPurchases` varchar(5) DEFAULT NULL,
  `TaxTrackedOnPurchasesSpecified` varchar(5) DEFAULT NULL,
  `UserData` text,
  `Operation` text,
  `sparse` varchar(5) DEFAULT NULL,
  `LSData` text
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_0900_ai_ci;






CREATE TABLE `taxclassification` (
  `Id` varchar(255) DEFAULT NULL,
  `SyncToken` text,
  `CreateTime` datetime DEFAULT NULL,
  `LastUpdatedTime` datetime DEFAULT NULL,
  `Name` text,
  `Description` text,
  `Code` text,
  `Level` text,
  `ParentRef_Id` text,
  `ParentRef_Name` text,
  `ApplicableTo` text,
  `UserData` text,
  `Operation` text,
  `sparse` varchar(5) DEFAULT NULL,
  `LSData` text
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_0900_ai_ci;






CREATE TABLE `taxcode` (
  `Id` varchar(255) DEFAULT NULL,
  `SyncToken` text,
  `CreateTime` datetime DEFAULT NULL,
  `LastUpdatedTime` datetime DEFAULT NULL,
  `Name` text,
  `Description` text,
  `Active` varchar(5) DEFAULT NULL,
  `ActiveSpecified` varchar(5) DEFAULT NULL,
  `Hidden` varchar(5) DEFAULT NULL,
  `HiddenSpecified` varchar(5) DEFAULT NULL,
  `Taxable` varchar(5) DEFAULT NULL,
  `TaxableSpecified` varchar(5) DEFAULT NULL,
  `TaxGroup` varchar(5) DEFAULT NULL,
  `TaxGroupSpecified` varchar(5) DEFAULT NULL,
  `UserData` text,
  `Operation` text,
  `sparse` varchar(5) DEFAULT NULL,
  `LSData` text
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_0900_ai_ci;






CREATE TABLE `taxpayment` (
  `Id` varchar(255) DEFAULT NULL,
  `SyncToken` text,
  `CreateTime` datetime DEFAULT NULL,
  `LastUpdatedTime` datetime DEFAULT NULL,
  `Name` text,
  `PaymentDate` datetime DEFAULT NULL,
  `PaymentDateSpecified` varchar(5) DEFAULT NULL,
  `PaymentAccountRef_Id` text,
  `PaymentAccountRef_Name` text,
  `PaymentAmount` decimal(15,2) DEFAULT NULL,
  `PaymentAmountSpecified` varchar(5) DEFAULT NULL,
  `Description` text,
  `Refund` varchar(5) DEFAULT NULL,
  `RefundSpecified` varchar(5) DEFAULT NULL,
  `UserData` text,
  `Operation` text,
  `sparse` varchar(5) DEFAULT NULL,
  `LSData` text
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_0900_ai_ci;




CREATE TABLE `taxrate` (
  `Id` varchar(255) DEFAULT NULL,
  `SyncToken` text,
  `CreateTime` datetime DEFAULT NULL,
  `LastUpdatedTime` datetime DEFAULT NULL,
  `Name` text,
  `Description` text,
  `Active` varchar(5) DEFAULT NULL,
  `ActiveSpecified` varchar(5) DEFAULT NULL,
  `RateValue` decimal(15,2) DEFAULT NULL,
  `RateValueSpecified` varchar(5) DEFAULT NULL,
  `AgencyRef_Id` text,
  `AgencyRef_Name` text,
  `TaxReturnLineRef_Id` text,
  `TaxReturnLineRef_Name` text,
  `SpecialTaxType` text,
  `SpecialTaxTypeSpecified` varchar(5) DEFAULT NULL,
  `DisplayType` text,
  `DisplayTypeSpecified` varchar(5) DEFAULT NULL,
  `UserData` text,
  `Operation` text,
  `sparse` varchar(5) DEFAULT NULL,
  `LSData` text
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_0900_ai_ci;




CREATE TABLE `taxratedetail` (
  `Id` varchar(255) DEFAULT NULL,
  `TaxRateRef_Id` text,
  `TaxRateRef_Name` text,
  `TaxTypeApplicable` text,
  `TaxTypeApplicableSpecified` varchar(5) DEFAULT NULL,
  `TaxOrder` int DEFAULT NULL,
  `TaxOrderSpecified` varchar(5) DEFAULT NULL,
  `TaxOnTaxOrder` int DEFAULT NULL,
  `TaxOnTaxOrderSpecified` varchar(5) DEFAULT NULL,
  `SeqNum` int DEFAULT NULL,
  `LetSyncId` varchar(5) DEFAULT NULL,
  `ParentTableType` varchar(255) DEFAULT NULL,
  `PARENT_ID` varchar(255) DEFAULT NULL
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_0900_ai_ci;






CREATE TABLE `taxratedetails` (
  `Id` varchar(255) DEFAULT NULL,
  `TaxRateName` text,
  `TaxRateId` text,
  `RateValue` decimal(15,2) DEFAULT NULL,
  `RateValueSpecified` varchar(5) DEFAULT NULL,
  `TaxAgencyId` text,
  `TaxApplicableOn` text,
  `TaxApplicableOnSpecified` varchar(5) DEFAULT NULL,
  `SeqNum` int DEFAULT NULL,
  `LetSyncId` varchar(5) DEFAULT NULL,
  `ParentTableType` varchar(255) DEFAULT NULL,
  `PARENT_LineID` varchar(255) DEFAULT NULL,
  `PARENT_ID` varchar(255) DEFAULT NULL
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_0900_ai_ci;





CREATE TABLE `taxservice` (
  `Id` varchar(255) DEFAULT NULL,
  `SyncToken` text,
  `CreateTime` datetime DEFAULT NULL,
  `LastUpdatedTime` datetime DEFAULT NULL,
  `Name` text,
  `TaxCode` text,
  `TaxCodeId` text,
  `UserData` text,
  `Operation` text,
  `sparse` varchar(5) DEFAULT NULL,
  `LSData` text
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_0900_ai_ci;




CREATE TABLE `term` (
  `Id` varchar(255) DEFAULT NULL,
  `SyncToken` text,
  `CreateTime` datetime DEFAULT NULL,
  `LastUpdatedTime` datetime DEFAULT NULL,
  `Name` text,
  `Active` varchar(5) DEFAULT NULL,
  `ActiveSpecified` varchar(5) DEFAULT NULL,
  `Type` text,
  `DiscountPercent` decimal(15,2) DEFAULT NULL,
  `DiscountPercentSpecified` varchar(5) DEFAULT NULL,
  `UserData` text,
  `Operation` text,
  `sparse` varchar(5) DEFAULT NULL,
  `LSData` text
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_0900_ai_ci;






CREATE TABLE `termlinedetail` (
  `Id` varchar(255) DEFAULT NULL,
  `DueDays` int DEFAULT NULL,
  `DueNextMonthDays` varchar(255) DEFAULT NULL,
  `DiscountDayOfMonth` varchar(255) DEFAULT NULL,
  `DayOfMonthDue` varchar(255) DEFAULT NULL,
  `DiscountDays` int DEFAULT NULL,
  `SeqNum` int DEFAULT NULL,
  `LetSyncId` varchar(5) DEFAULT NULL,
  `ParentTableType` varchar(255) DEFAULT NULL,
  `PARENT_LineID` varchar(255) DEFAULT NULL,
  `PARENT_ID` varchar(255) DEFAULT NULL
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_0900_ai_ci;






CREATE TABLE `timeactivity` (
  `Id` varchar(255) DEFAULT NULL,
  `SyncToken` text,
  `CreateTime` datetime DEFAULT NULL,
  `LastUpdatedTime` datetime DEFAULT NULL,
  `Name` text,
  `NameOfType` text,
  `NameOfSpecified` varchar(5) DEFAULT NULL,
  `TxnDate` datetime DEFAULT NULL,
  `TxnDateSpecified` varchar(5) DEFAULT NULL,
  `StartTime` datetime DEFAULT NULL,
  `StartTimeSpecified` varchar(5) DEFAULT NULL,
  `EndTime` datetime DEFAULT NULL,
  `EndTimeSpecified` varchar(5) DEFAULT NULL,
  `HourlyRate` decimal(15,2) DEFAULT NULL,
  `HourlyRateSpecified` varchar(5) DEFAULT NULL,
  `Minutes` int DEFAULT NULL,
  `MinutesSpecified` varchar(5) DEFAULT NULL,
  `Hours` int DEFAULT NULL,
  `HoursSpecified` varchar(5) DEFAULT NULL,
  `BreakHours` int DEFAULT NULL,
  `BreakHoursSpecified` varchar(5) DEFAULT NULL,
  `BreakMinutes` int DEFAULT NULL,
  `BreakMinutesSpecified` varchar(5) DEFAULT NULL,
  `ItemElementName` text,
  `ItemElementRef_Id` text,
  `ItemElementRef_Name` text,
  `EmployeeRef_Id` text,
  `EmployeeRef_Name` text,
  `OtherNameRef_Id` text,
  `OtherNameRef_Name` text,
  `VendorRef_Id` text,
  `VendorRef_Name` text,
  `CustomerRef_Id` text,
  `CustomerRef_Name` text,
  `DepartmentRef_Id` text,
  `DepartmentRef_Name` text,
  `ItemRef_Id` text,
  `ItemRef_Name` text,
  `ClassRef_Id` text,
  `ClassRef_Name` text,
  `PayrollItemRef_Id` text,
  `PayrollItemRef_Name` text,
  `BillableStatus` text,
  `BillableStatusSpecified` varchar(5) DEFAULT NULL,
  `TimeZone` text,
  `Taxable` varchar(5) DEFAULT NULL,
  `TaxableSpecified` varchar(5) DEFAULT NULL,
  `Description` text,
  `UserData` text,
  `Operation` text,
  `sparse` varchar(5) DEFAULT NULL,
  `LSData` text
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_0900_ai_ci;





CREATE TABLE `transfer` (
  `Id` varchar(255) DEFAULT NULL,
  `SyncToken` text,
  `CreateTime` datetime DEFAULT NULL,
  `LastUpdatedTime` datetime DEFAULT NULL,
  `Name` text,
  `TxnDate` datetime DEFAULT NULL,
  `TxnDateSpecified` varchar(5) DEFAULT NULL,
  `ExchangeRate` decimal(15,2) DEFAULT NULL,
  `ExchangeRateSpecified` varchar(5) DEFAULT NULL,
  `TransactionLocationType` text,
  `Amount` decimal(15,2) DEFAULT NULL,
  `AmountSpecified` varchar(5) DEFAULT NULL,
  `PrivateNote` text,
  `FromAccountRef_Id` text,
  `FromAccountRef_Name` text,
  `ToAccountRef_Id` text,
  `ToAccountRef_Name` text,
  `ClassRef_Id` text,
  `ClassRef_Name` text,
  `UserData` text,
  `Operation` text,
  `sparse` varchar(5) DEFAULT NULL,
  `LSData` text
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_0900_ai_ci;






CREATE TABLE `txntaxlinedetail` (
  `Id` varchar(255) DEFAULT NULL,
  `DetailType` text,
  `DetailTypeSpecified` varchar(5) DEFAULT NULL,
  `Amount` decimal(15,2) DEFAULT NULL,
  `AmountSpecified` varchar(5) DEFAULT NULL,
  `TaxRateRef_Id` text,
  `TaxRateRef_Name` text,
  `PercentBased` varchar(5) DEFAULT NULL,
  `PercentBasedSpecified` varchar(5) DEFAULT NULL,
  `TaxPercent` decimal(15,2) DEFAULT NULL,
  `TaxPercentSpecified` varchar(5) DEFAULT NULL,
  `NetAmountTaxable` decimal(15,2) DEFAULT NULL,
  `NetAmountTaxableSpecified` varchar(5) DEFAULT NULL,
  `TaxInclusiveAmount` decimal(15,2) DEFAULT NULL,
  `TaxInclusiveAmountSpecified` varchar(5) DEFAULT NULL,
  `OverrideDeltaAmount` decimal(15,2) DEFAULT NULL,
  `OverrideDeltaAmountSpecified` varchar(5) DEFAULT NULL,
  `ServiceDate` datetime DEFAULT NULL,
  `ServiceDateSpecified` varchar(5) DEFAULT NULL,
  `SeqNum` int DEFAULT NULL,
  `LetSyncId` varchar(5) DEFAULT NULL,
  `ParentTableType` varchar(255) DEFAULT NULL,
  `PARENT_ID` varchar(255) DEFAULT NULL
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_0900_ai_ci;




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





CREATE TABLE `vendorcredit` (
  `Id` varchar(255) DEFAULT NULL,
  `SyncToken` text,
  `CreateTime` datetime DEFAULT NULL,
  `LastUpdatedTime` datetime DEFAULT NULL,
  `Name` text,
  `TxnDate` datetime DEFAULT NULL,
  `TxnDateSpecified` varchar(5) DEFAULT NULL,
  `ExchangeRate` decimal(15,2) DEFAULT NULL,
  `ExchangeRateSpecified` varchar(5) DEFAULT NULL,
  `TotalAmt` decimal(15,2) DEFAULT NULL,
  `TotalAmtSpecified` varchar(5) DEFAULT NULL,
  `TransactionLocationType` text,
  `DocNumber` text,
  `PrivateNote` text,
  `TaxFormNum` text,
  `TaxFormType` text,
  `TxnSource` text,
  `TxnStatus` text,
  `CurrencyRef_Id` text,
  `CurrencyRef_Name` text,
  `DepartmentRef_Id` text,
  `DepartmentRef_Name` text,
  `APAccountRef_Id` text,
  `APAccountRef_Name` text,
  `VendorRef_Id` text,
  `VendorRef_Name` text,
  `BillEmailAddress` text,
  `ReplyEmailAddress` text,
  `Memo` text,
  `GlobalTaxCalculation` text,
  `GlobalTaxCalculationSpecified` varchar(5) DEFAULT NULL,
  `Balance` decimal(15,2) DEFAULT NULL,
  `BalanceSpecified` varchar(5) DEFAULT NULL,
  `TotalTaxSpecified` varchar(5) DEFAULT NULL,
  `TotalTax` decimal(15,2) DEFAULT NULL,
  `TxnTaxCodeRef_Id` text,
  `TxnTaxCodeRef_Name` text,
  `DefaultTaxCodeRef_Id` text,
  `DefaultTaxCodeRef_Name` text,
  `CustomField1` text,
  `CustomField2` text,
  `CustomField3` text,
  `CustomField4` text,
  `CustomField5` text,
  `CustomField6` text,
  `CustomField7` text,
  `CustomField8` text,
  `CustomField9` text,
  `CustomField10` text,
  `UserData` text,
  `Operation` text,
  `sparse` varchar(5) DEFAULT NULL,
  `LSData` text
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_0900_ai_ci;



CREATE TABLE `vendorcreditlinedetail` (
  `Id` varchar(255) DEFAULT NULL,
  `LineNum` text,
  `Description` text,
  `Amount` decimal(15,2) DEFAULT NULL,
  `AmountSpecified` varchar(5) DEFAULT NULL,
  `DetailType` text,
  `DetailTypeSpecified` varchar(5) DEFAULT NULL,
  `ItemRef_Id` text,
  `ItemRef_Name` text,
  `ClassRef_Id` text,
  `ClassRef_Name` text,
  `PriceLevelRef_Id` text,
  `PriceLevelRef_Name` text,
  `RatePercent` decimal(15,2) DEFAULT NULL,
  `UnitPrice` decimal(15,2) DEFAULT NULL,
  `Qty` decimal(15,2) DEFAULT NULL,
  `QtySpecified` varchar(5) DEFAULT NULL,
  `UOMSetRef_Unit` text,
  `UOMSetRef_Id` text,
  `UOMSetRef_Name` text,
  `ItemAccountRef_Id` text,
  `ItemAccountRef_Name` text,
  `InventorySiteRef_Id` text,
  `InventorySiteRef_Name` text,
  `TaxCodeRef_Id` text,
  `TaxCodeRef_Name` text,
  `TaxClassificationRef_Id` text,
  `TaxClassificationRef_Name` text,
  `CustomerRef_Id` text,
  `CustomerRef_Name` text,
  `BillableStatus` text,
  `BillableStatusSpecified` varchar(5) DEFAULT NULL,
  `TaxInclusiveAmt` decimal(15,2) DEFAULT NULL,
  `TaxInclusiveAmtSpecified` varchar(5) DEFAULT NULL,
  `AccountRef_Id` text,
  `AccountRef_Name` text,
  `TaxAmount` decimal(15,2) DEFAULT NULL,
  `TaxAmountSpecified` varchar(5) DEFAULT NULL,
  `MarkupPercentBased` varchar(5) DEFAULT NULL,
  `MarkupPercentBasedSpecified` varchar(5) DEFAULT NULL,
  `MarkupValue` decimal(15,2) DEFAULT NULL,
  `MarkupValueSpecified` varchar(5) DEFAULT NULL,
  `MarkupPercent` decimal(15,2) DEFAULT NULL,
  `MarkupPercentSpecified` varchar(5) DEFAULT NULL,
  `MarkupPriceLevelRef_Id` text,
  `MarkupPriceLevelRef_Name` text,
  `MarkupIncomeAccountRef_Id` text,
  `MarkupIncomeAccountRef_Name` text,
  `CustomField1` text,
  `CustomField2` text,
  `CustomField3` text,
  `CustomField4` text,
  `CustomField5` text,
  `CustomField6` text,
  `CustomField7` text,
  `CustomField8` text,
  `CustomField9` text,
  `CustomField10` text,
  `SeqNum` int DEFAULT NULL,
  `PARENT_GroupID` varchar(255) DEFAULT NULL,
  `PARENT_ID` varchar(255) DEFAULT NULL
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_0900_ai_ci;