MySQL Server LetSync Desktop Schema Create

LetSync Desktop 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 Desktop 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”
• error_table: this table will record the errors that happen when running a task if it is any.
• dataextdef: this table is for the custom fields. This table will save which custom fields are assigned to which table.
• LSDatabase: this table will tell the version of the LetSync Desktop database you are running. If there is any future field that is added, this version will increase.

CREATE TABLE `account` (
  `ListID` varchar(36) NOT NULL,
  `TimeCreated` datetime DEFAULT NULL,
  `TimeModified` datetime DEFAULT NULL,
  `EditSequence` varchar(16) DEFAULT NULL,
  `Name` varchar(31) DEFAULT NULL,
  `FullName` varchar(159) DEFAULT NULL,
  `IsActive` varchar(5) DEFAULT NULL,
  `ParentRef_ListID` varchar(36) DEFAULT NULL,
  `ParentRef_FullName` varchar(255) DEFAULT NULL,
  `Sublevel` int DEFAULT NULL,
  `AccountType` varchar(255) DEFAULT NULL,
  `SpecialAccountType` varchar(255) DEFAULT NULL,
  `IsTaxAccount` varchar(5) DEFAULT NULL,
  `AccountNumber` varchar(7) DEFAULT NULL,
  `BankNumber` varchar(25) DEFAULT NULL,
  `Description` varchar(200) DEFAULT NULL,
  `Balance` decimal(15,2) DEFAULT NULL,
  `TotalBalance` decimal(15,2) DEFAULT NULL,
  `OpenBalance` decimal(15,2) DEFAULT NULL,
  `OpenBalanceDate` datetime DEFAULT NULL,
  `CashFlowClassification` varchar(255) DEFAULT NULL,
  `SalesTaxCodeRef_ListID` varchar(36) DEFAULT NULL,
  `SalesTaxCodeRef_FullName` varchar(3) DEFAULT NULL,
  `TaxLineID` int DEFAULT NULL,
  `TaxLineName` varchar(255) DEFAULT NULL,
  `CurrencyRef_ListID` varchar(36) DEFAULT NULL,
  `CurrencyRef_FullName` varchar(64) DEFAULT NULL,
  `UserData` varchar(255) DEFAULT NULL,
  `Operation` varchar(10) DEFAULT NULL,
  `LSData` varchar(10) DEFAULT NULL,
  PRIMARY KEY (`ListID`),
  UNIQUE KEY `accountIdIndex` (`ListID`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_0900_ai_ci;



CREATE TABLE `additionalcontactret` (
  `ContactName` varchar(40) DEFAULT NULL,
  `ContactValue` varchar(255) DEFAULT NULL,
  `PARENT_IDKEY` varchar(36) DEFAULT NULL,
  `SeqNum` int DEFAULT NULL,
  `LSData` varchar(10) DEFAULT NULL,
  KEY `additionalcontactretIdIndex` (`PARENT_IDKEY`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_0900_ai_ci;



CREATE TABLE `additionalnotesret` (
  `NoteID` int DEFAULT NULL,
  `DateNote` datetime DEFAULT NULL,
  `Notes` varchar(1000) DEFAULT NULL,
  `PARENT_IDKEY` varchar(36) DEFAULT NULL,
  `SeqNum` int DEFAULT NULL,
  `LSData` varchar(10) DEFAULT NULL,
  KEY `additionalnotesretIdIndex` (`PARENT_IDKEY`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_0900_ai_ci;



CREATE TABLE `appliedtotxnret` (
  `TxnID` varchar(36) NOT NULL,
  `TxnType` varchar(255) DEFAULT NULL,
  `TxnDate` datetime DEFAULT NULL,
  `RefNumber` varchar(25) DEFAULT NULL,
  `BalanceRemaining` decimal(15,2) DEFAULT NULL,
  `CreditRemaining` decimal(16,6) DEFAULT NULL,
  `CreditRemainingInHomeCurrency` decimal(16,6) DEFAULT NULL,
  `RefundAmountInHomeCurrency` decimal(15,2) DEFAULT NULL,
  `Amount` decimal(15,2) DEFAULT NULL,
  `DiscountAmount` decimal(15,2) DEFAULT NULL,
  `DiscountAccountRef_ListID` varchar(255) DEFAULT NULL,
  `DiscountAccountRef_FullName` varchar(255) DEFAULT NULL,
  `DiscountClassRef_ListID` varchar(36) DEFAULT NULL,
  `DiscountClassRef_FullName` varchar(159) DEFAULT NULL,
  `PARENT_IDKEY` varchar(36) DEFAULT NULL,
  `SeqNum` int DEFAULT NULL,
  `UserData` varchar(255) DEFAULT NULL,
  `LSData` varchar(10) DEFAULT NULL,
  KEY `appliedtotxnretIdIndex` (`PARENT_IDKEY`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_0900_ai_ci;


CREATE TABLE `earningsret` (
  `PayrollItemWageRef_ListID` varchar(36) DEFAULT NULL,
  `PayrollItemWageRef_FullName` varchar(159) DEFAULT NULL,
  `Rate` decimal(16,6) DEFAULT NULL,
  `RatePercent` decimal(16,6) DEFAULT NULL,
  `PARENT_IDKEY` varchar(36) DEFAULT NULL,
  `SeqNum` int DEFAULT NULL,
  `LSData` varchar(10) DEFAULT NULL,
  KEY `earningsretIdIndex` (`PARENT_IDKEY`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_0900_ai_ci;




CREATE TABLE `arrefundcreditcard` (
  `TxnID` varchar(36) NOT NULL,
  `TimeCreated` datetime DEFAULT NULL,
  `TimeModified` datetime DEFAULT NULL,
  `EditSequence` varchar(16) DEFAULT NULL,
  `TxnNumber` int DEFAULT NULL,
  `CustomerRef_ListID` varchar(36) DEFAULT NULL,
  `CustomerRef_FullName` varchar(209) DEFAULT NULL,
  `RefundFromAccountRef_ListID` varchar(36) DEFAULT NULL,
  `RefundFromAccountRef_FullName` varchar(159) DEFAULT NULL,
  `ARAccountRef_ListID` varchar(36) DEFAULT NULL,
  `ARAccountRef_FullName` varchar(159) DEFAULT NULL,
  `TxnDate` datetime DEFAULT NULL,
  `RefNumber` varchar(25) DEFAULT NULL,
  `TotalAmount` decimal(15,2) DEFAULT NULL,
  `Address_Addr1` varchar(41) DEFAULT NULL,
  `Address_Addr2` varchar(41) DEFAULT NULL,
  `Address_Addr3` varchar(41) DEFAULT NULL,
  `Address_Addr4` varchar(41) DEFAULT NULL,
  `Address_Addr5` varchar(41) DEFAULT NULL,
  `Address_City` varchar(31) DEFAULT NULL,
  `Address_State` varchar(21) DEFAULT NULL,
  `Address_PostalCode` varchar(13) DEFAULT NULL,
  `Address_Country` varchar(31) DEFAULT NULL,
  `Address_Note` varchar(41) DEFAULT NULL,
  `PaymentMethodRef_ListID` varchar(36) DEFAULT NULL,
  `PaymentMethodRef_FullName` varchar(31) DEFAULT NULL,
  `Memo` varchar(1000) DEFAULT NULL,
  `CCTII_CreditCardNumber` varchar(25) DEFAULT NULL,
  `CCTII_ExpirationMonth` int DEFAULT NULL,
  `CCTII_ExpirationYear` int DEFAULT NULL,
  `CCTII_NameOnCard` varchar(41) DEFAULT NULL,
  `CCTII_CreditCardAddress` varchar(41) DEFAULT NULL,
  `CCTII_CreditCardPostalCode` varchar(18) DEFAULT NULL,
  `CCTII_CommercialCardCode` varchar(24) DEFAULT NULL,
  `CCTII_TransactionMode` varchar(255) DEFAULT NULL,
  `CCTII_CreditCardTxnType` varchar(255) DEFAULT NULL,
  `CCTRI_ResultCode` int DEFAULT NULL,
  `CCTRI_ResultMessage` varchar(60) DEFAULT NULL,
  `CCTRI_CreditCardTransID` varchar(24) DEFAULT NULL,
  `CCTRI_MerchantAccountNumber` varchar(32) DEFAULT NULL,
  `CCTRI_AuthorizationCode` varchar(12) DEFAULT NULL,
  `CCTRI_AVSStreet` varchar(255) DEFAULT NULL,
  `CCTRI_AVSZip` varchar(255) DEFAULT NULL,
  `CCTRI_CardSecurityCodeMatch` varchar(255) DEFAULT NULL,
  `CCTRI_ReconBatchID` varchar(84) DEFAULT NULL,
  `CCTRI_PaymentGroupingCode` int DEFAULT NULL,
  `CCTRI_PaymentStatus` varchar(255) DEFAULT NULL,
  `CCTRI_TxnAuthorizationTime` datetime DEFAULT NULL,
  `CCTRI_TxnAuthorizationStamp` int DEFAULT NULL,
  `CCTRI_ClientTransID` varchar(16) DEFAULT NULL,
  `TotalAmountInHomeCurrency` decimal(15,2) DEFAULT NULL,
  `ExchangeRate` decimal(16,6) DEFAULT NULL,
  `CurrencyRef_ListID` varchar(36) DEFAULT NULL,
  `CurrencyRef_FullName` varchar(64) DEFAULT NULL,
  `ExternalGUID` varchar(255) DEFAULT NULL,
  `UserData` varchar(255) DEFAULT NULL,
  `Operation` varchar(10) DEFAULT NULL,
  `LSData` varchar(10) DEFAULT NULL,
  PRIMARY KEY (`TxnID`),
  UNIQUE KEY `arrefundcreditcardIdIndex` (`TxnID`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_0900_ai_ci;



CREATE TABLE `bill` (
  `TxnID` varchar(36) NOT NULL,
  `TimeCreated` datetime DEFAULT NULL,
  `TimeModified` datetime DEFAULT NULL,
  `EditSequence` varchar(16) DEFAULT NULL,
  `TxnNumber` int DEFAULT NULL,
  `VendorRef_ListID` varchar(36) DEFAULT NULL,
  `VendorRef_FullName` varchar(41) DEFAULT NULL,
  `VendorAddress_Addr1` varchar(41) DEFAULT NULL,
  `VendorAddress_Addr2` varchar(41) DEFAULT NULL,
  `VendorAddress_Addr3` varchar(41) DEFAULT NULL,
  `VendorAddress_Addr4` varchar(41) DEFAULT NULL,
  `VendorAddress_Addr5` varchar(41) DEFAULT NULL,
  `VendorAddress_City` varchar(31) DEFAULT NULL,
  `VendorAddress_State` varchar(21) DEFAULT NULL,
  `VendorAddress_PostalCode` varchar(13) DEFAULT NULL,
  `VendorAddress_Country` varchar(31) DEFAULT NULL,
  `VendorAddress_Note` varchar(41) DEFAULT NULL,
  `APAccountRef_ListID` varchar(36) DEFAULT NULL,
  `APAccountRef_FullName` varchar(159) DEFAULT NULL,
  `TxnDate` datetime DEFAULT NULL,
  `DueDate` datetime DEFAULT NULL,
  `AmountDue` decimal(15,2) DEFAULT NULL,
  `CurrencyRef_ListID` varchar(36) DEFAULT NULL,
  `CurrencyRef_FullName` varchar(64) DEFAULT NULL,
  `ExchangeRate` decimal(16,6) DEFAULT NULL,
  `ClearExpenseLines` varchar(5) DEFAULT NULL,
  `ClearItemLines` varchar(5) DEFAULT NULL,
  `AmountDueInHomeCurrency` decimal(15,2) DEFAULT NULL,
  `RefNumber` varchar(25) DEFAULT NULL,
  `TermsRef_ListID` varchar(36) DEFAULT NULL,
  `TermsRef_FullName` varchar(31) DEFAULT NULL,
  `Memo` varchar(1000) DEFAULT NULL,
  `IsTaxIncluded` varchar(5) DEFAULT NULL,
  `SalesTaxCodeRef_ListID` varchar(36) DEFAULT NULL,
  `SalesTaxCodeRef_FullName` varchar(3) DEFAULT NULL,
  `IsPaid` varchar(5) DEFAULT NULL,
  `OpenAmount` decimal(15,2) DEFAULT NULL,
  `ExternalGUID` varchar(255) DEFAULT NULL,
  `UserData` varchar(255) DEFAULT NULL,
  `Operation` varchar(10) DEFAULT NULL,
  `LSData` varchar(10) DEFAULT NULL,
  PRIMARY KEY (`TxnID`),
  UNIQUE KEY `billIdIndex` (`TxnID`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_0900_ai_ci;




CREATE TABLE `billingrate` (
  `ListID` varchar(36) NOT NULL,
  `TimeCreated` datetime DEFAULT NULL,
  `TimeModified` datetime DEFAULT NULL,
  `EditSequence` varchar(16) DEFAULT NULL,
  `Name` varchar(31) DEFAULT NULL,
  `BillingRateType` varchar(255) DEFAULT NULL,
  `FixedBillingRate` decimal(15,2) DEFAULT NULL,
  `UserData` varchar(255) DEFAULT NULL,
  `Operation` varchar(10) DEFAULT NULL,
  `LSData` varchar(10) DEFAULT NULL,
  PRIMARY KEY (`ListID`),
  UNIQUE KEY `billingrateIdIndex` (`ListID`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_0900_ai_ci;




CREATE TABLE `billingrateperitemret` (
  `ItemRef_ListID` varchar(36) DEFAULT NULL,
  `ItemRef_FullName` varchar(159) DEFAULT NULL,
  `CustomRate` decimal(16,6) DEFAULT NULL,
  `CustomRatePercent` decimal(16,6) DEFAULT NULL,
  `AdjustPercentage` decimal(16,6) DEFAULT NULL,
  `AdjustBillingRateRelativeTo` varchar(255) DEFAULT NULL,
  `PARENT_IDKEY` varchar(36) DEFAULT NULL,
  `SeqNum` int DEFAULT NULL,
  `LSData` varchar(10) DEFAULT NULL,
  KEY `billingrateperitemretIdIndex` (`PARENT_IDKEY`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_0900_ai_ci;



CREATE TABLE `billpaymentcheck` (
  `TxnID` varchar(36) NOT NULL,
  `TimeCreated` datetime DEFAULT NULL,
  `TimeModified` datetime DEFAULT NULL,
  `EditSequence` varchar(16) DEFAULT NULL,
  `TxnNumber` int DEFAULT NULL,
  `PayeeEntityRef_ListID` varchar(36) DEFAULT NULL,
  `PayeeEntityRef_FullName` varchar(209) DEFAULT NULL,
  `APAccountRef_ListID` varchar(36) DEFAULT NULL,
  `APAccountRef_FullName` varchar(159) DEFAULT NULL,
  `TxnDate` datetime DEFAULT NULL,
  `BankAccountRef_ListID` varchar(36) DEFAULT NULL,
  `BankAccountRef_FullName` varchar(159) DEFAULT NULL,
  `Amount` decimal(15,2) DEFAULT NULL,
  `CurrencyRef_ListID` varchar(36) DEFAULT NULL,
  `CurrencyRef_FullName` varchar(64) DEFAULT NULL,
  `ExchangeRate` decimal(16,6) DEFAULT NULL,
  `AmountInHomeCurrency` decimal(15,2) DEFAULT NULL,
  `RefNumber` varchar(25) DEFAULT NULL,
  `Memo` varchar(1000) DEFAULT NULL,
  `Address_Addr1` varchar(41) DEFAULT NULL,
  `Address_Addr2` varchar(41) DEFAULT NULL,
  `Address_Addr3` varchar(41) DEFAULT NULL,
  `Address_Addr4` varchar(41) DEFAULT NULL,
  `Address_Addr5` varchar(41) DEFAULT NULL,
  `Address_City` varchar(31) DEFAULT NULL,
  `Address_State` varchar(21) DEFAULT NULL,
  `Address_PostalCode` varchar(13) DEFAULT NULL,
  `Address_Country` varchar(31) DEFAULT NULL,
  `Address_Note` varchar(41) DEFAULT NULL,
  `IsToBePrinted` varchar(5) DEFAULT NULL,
  `ExternalGUID` varchar(255) DEFAULT NULL,
  `UserData` varchar(255) DEFAULT NULL,
  `Operation` varchar(10) DEFAULT NULL,
  `LSData` varchar(10) DEFAULT NULL,
  PRIMARY KEY (`TxnID`),
  UNIQUE KEY `billpaymentcheckIdIndex` (`TxnID`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_0900_ai_ci;



CREATE TABLE `billpaymentcreditcard` (
  `TxnID` varchar(36) NOT NULL,
  `TimeCreated` datetime DEFAULT NULL,
  `TimeModified` datetime DEFAULT NULL,
  `EditSequence` varchar(16) DEFAULT NULL,
  `TxnNumber` int DEFAULT NULL,
  `PayeeEntityRef_ListID` varchar(36) DEFAULT NULL,
  `PayeeEntityRef_FullName` varchar(209) DEFAULT NULL,
  `APAccountRef_ListID` varchar(36) DEFAULT NULL,
  `APAccountRef_FullName` varchar(159) DEFAULT NULL,
  `TxnDate` datetime DEFAULT NULL,
  `CreditCardAccountRef_ListID` varchar(36) DEFAULT NULL,
  `CreditCardAccountRef_FullName` varchar(159) DEFAULT NULL,
  `Amount` decimal(15,2) DEFAULT NULL,
  `CurrencyRef_ListID` varchar(36) DEFAULT NULL,
  `CurrencyRef_FullName` varchar(64) DEFAULT NULL,
  `ExchangeRate` decimal(16,6) DEFAULT NULL,
  `AmountInHomeCurrency` decimal(15,2) DEFAULT NULL,
  `RefNumber` varchar(25) DEFAULT NULL,
  `Memo` varchar(1000) DEFAULT NULL,
  `ExternalGUID` varchar(255) DEFAULT NULL,
  `UserData` varchar(255) DEFAULT NULL,
  `Operation` varchar(10) DEFAULT NULL,
  `LSData` varchar(10) DEFAULT NULL,
  PRIMARY KEY (`TxnID`),
  UNIQUE KEY `billpaymentcreditcardIdIndex` (`TxnID`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_0900_ai_ci;




CREATE TABLE `buildassembly` (
  `TxnID` varchar(36) NOT NULL,
  `TimeCreated` datetime DEFAULT NULL,
  `TimeModified` datetime DEFAULT NULL,
  `EditSequence` varchar(16) DEFAULT NULL,
  `TxnNumber` int DEFAULT NULL,
  `ItemInvAssemblyRef_ListID` varchar(36) DEFAULT NULL,
  `ItemInvAssemblyRef_FullName` varchar(159) DEFAULT NULL,
  `InvSiteRef_ListID` varchar(36) DEFAULT NULL,
  `InvSiteRef_FullName` varchar(31) DEFAULT NULL,
  `InvSiteLocRef_ListID` varchar(36) DEFAULT NULL,
  `InvSiteLocRef_FullName` varchar(31) DEFAULT NULL,
  `SerialNumber` varchar(1000) DEFAULT NULL,
  `LotNumber` varchar(40) DEFAULT NULL,
  `TxnDate` datetime DEFAULT NULL,
  `RefNumber` varchar(25) DEFAULT NULL,
  `Memo` varchar(1000) DEFAULT NULL,
  `IsPending` varchar(5) DEFAULT NULL,
  `QuantityToBuild` decimal(16,6) DEFAULT NULL,
  `QuantityCanBuild` decimal(16,6) DEFAULT NULL,
  `QuantityOnHand` decimal(16,6) DEFAULT NULL,
  `QuantityOnSalesOrder` decimal(16,6) DEFAULT NULL,
  `ExternalGUID` varchar(255) DEFAULT NULL,
  `UserData` varchar(255) DEFAULT NULL,
  `Operation` varchar(10) DEFAULT NULL,
  `LSData` varchar(10) DEFAULT NULL,
  PRIMARY KEY (`TxnID`),
  UNIQUE KEY `buildassemblyIdIndex` (`TxnID`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_0900_ai_ci;



CREATE TABLE `cashbackinforet` (
  `TxnLineID` varchar(36) DEFAULT NULL,
  `AccountRef_ListID` varchar(36) DEFAULT NULL,
  `AccountRef_FullName` varchar(159) DEFAULT NULL,
  `Memo` varchar(1000) DEFAULT NULL,
  `Amount` decimal(15,2) DEFAULT NULL,
  `PARENT_IDKEY` varchar(36) DEFAULT NULL,
  `SeqNum` int DEFAULT NULL,
  `LSData` varchar(10) DEFAULT NULL,
  KEY `cashbackinforetIdIndex` (`PARENT_IDKEY`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_0900_ai_ci;



CREATE TABLE `listdeleted`(
	`ListDelType` varchar(255) DEFAULT NULL,
	`ListID` varchar(255) NOT NULL,
	`TimeCreated` datetime DEFAULT NULL,
	`TimeDeleted` datetime DEFAULT NULL,
	`FullName` varchar(255) DEFAULT NULL,
UNIQUE KEY `listdeletedIdIndex` (`ListID`)
 )ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_0900_ai_ci;


CREATE TABLE `txndeleted`(
	`TxnDelType` varchar(255) DEFAULT NULL,
	`TxnID` varchar(255) NOT NULL,
	`TimeCreated` datetime DEFAULT NULL,
	`TimeDeleted` datetime DEFAULT NULL,
	`RefNumber` varchar(255) DEFAULT NULL,
 UNIQUE KEY `txndeletedIdIndex` (`TxnID`)
)ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_0900_ai_ci;


CREATE TABLE `charge` (
  `TxnID` varchar(36) NOT NULL,
  `TimeCreated` datetime DEFAULT NULL,
  `TimeModified` datetime DEFAULT NULL,
  `EditSequence` varchar(16) DEFAULT NULL,
  `TxnNumber` int DEFAULT NULL,
  `CustomerRef_ListID` varchar(36) DEFAULT NULL,
  `CustomerRef_FullName` varchar(209) DEFAULT NULL,
  `TxnDate` datetime DEFAULT NULL,
  `RefNumber` varchar(25) DEFAULT NULL,
  `ItemRef_ListID` varchar(36) DEFAULT NULL,
  `ItemRef_FullName` varchar(159) DEFAULT NULL,
  `InvSiteRef_ListID` varchar(36) DEFAULT NULL,
  `InvSiteRef_FullName` varchar(31) DEFAULT NULL,
  `InvSiteLocRef_ListID` varchar(36) DEFAULT NULL,
  `InvSiteLocRef_FullName` varchar(31) DEFAULT NULL,
  `Quantity` decimal(16,6) DEFAULT NULL,
  `UnitOfMeasure` varchar(31) DEFAULT NULL,
  `OverrideUOMSetRef_ListID` varchar(36) DEFAULT NULL,
  `OverrideUOMSetRef_FullName` varchar(31) DEFAULT NULL,
  `Rate` decimal(16,6) DEFAULT NULL,
  `Amount` decimal(15,2) DEFAULT NULL,
  `BalanceRemaining` decimal(15,2) DEFAULT NULL,
  `Description` varchar(1000) DEFAULT NULL,
  `ARAccountRef_ListID` varchar(36) DEFAULT NULL,
  `ARAccountRef_FullName` varchar(159) DEFAULT NULL,
  `ClassRef_ListID` varchar(36) DEFAULT NULL,
  `ClassRef_FullName` varchar(159) DEFAULT NULL,
  `BilledDate` datetime DEFAULT NULL,
  `DueDate` datetime DEFAULT NULL,
  `IsPaid` varchar(5) DEFAULT NULL,
  `ExternalGUID` varchar(255) DEFAULT NULL,
  `UserData` varchar(255) DEFAULT NULL,
  `Operation` varchar(10) DEFAULT NULL,
  `LSData` varchar(10) DEFAULT NULL,
  PRIMARY KEY (`TxnID`),
  UNIQUE KEY `chargeIdIndex` (`TxnID`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_0900_ai_ci;



CREATE TABLE `check` (
  `TxnID` varchar(36) NOT NULL,
  `TimeCreated` datetime DEFAULT NULL,
  `TimeModified` datetime DEFAULT NULL,
  `EditSequence` varchar(16) DEFAULT NULL,
  `TxnNumber` int DEFAULT NULL,
  `AccountRef_ListID` varchar(36) DEFAULT NULL,
  `AccountRef_FullName` varchar(159) DEFAULT NULL,
  `PayeeEntityRef_ListID` varchar(36) DEFAULT NULL,
  `PayeeEntityRef_FullName` varchar(209) DEFAULT NULL,
  `RefNumber` varchar(25) DEFAULT NULL,
  `TxnDate` datetime DEFAULT NULL,
  `Amount` decimal(15,2) DEFAULT NULL,
  `CurrencyRef_ListID` varchar(36) DEFAULT NULL,
  `CurrencyRef_FullName` varchar(64) DEFAULT NULL,
  `ExchangeRate` decimal(16,6) DEFAULT NULL,
  `AmountInHomeCurrency` decimal(15,2) DEFAULT NULL,
  `Memo` varchar(1000) DEFAULT NULL,
  `Address_Addr1` varchar(41) DEFAULT NULL,
  `Address_Addr2` varchar(41) DEFAULT NULL,
  `Address_Addr3` varchar(41) DEFAULT NULL,
  `Address_Addr4` varchar(41) DEFAULT NULL,
  `Address_Addr5` varchar(41) DEFAULT NULL,
  `Address_City` varchar(31) DEFAULT NULL,
  `Address_State` varchar(21) DEFAULT NULL,
  `Address_PostalCode` varchar(13) DEFAULT NULL,
  `Address_Country` varchar(31) DEFAULT NULL,
  `Address_Note` varchar(41) DEFAULT NULL,
  `IsToBePrinted` varchar(5) DEFAULT NULL,
  `IsTaxIncluded` varchar(5) DEFAULT NULL,
  `SalesTaxCodeRef_ListID` varchar(36) DEFAULT NULL,
  `SalesTaxCodeRef_FullName` varchar(3) DEFAULT NULL,
  `ExternalGUID` varchar(255) DEFAULT NULL,
  `UserData` varchar(255) DEFAULT NULL,
  `Operation` varchar(10) DEFAULT NULL,
  `LSData` varchar(10) DEFAULT NULL,
  PRIMARY KEY (`TxnID`),
  UNIQUE KEY `checkIdIndex` (`TxnID`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_0900_ai_ci;



CREATE TABLE `class` (
  `ListID` varchar(36) NOT NULL,
  `TimeCreated` datetime DEFAULT NULL,
  `TimeModified` datetime DEFAULT NULL,
  `EditSequence` varchar(16) DEFAULT NULL,
  `Name` varchar(31) DEFAULT NULL,
  `FullName` varchar(159) DEFAULT NULL,
  `IsActive` varchar(5) DEFAULT NULL,
  `ParentRef_ListID` varchar(36) DEFAULT NULL,
  `ParentRef_FullName` varchar(159) DEFAULT NULL,
  `Sublevel` int DEFAULT NULL,
  `UserData` varchar(255) DEFAULT NULL,
  `Operation` varchar(10) DEFAULT NULL,
  `LSData` varchar(10) DEFAULT NULL,
  PRIMARY KEY (`ListID`),
  UNIQUE KEY `classIdIndex` (`ListID`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_0900_ai_ci;



CREATE TABLE `company` (
  `IsSampleCompany` varchar(5) DEFAULT NULL,
  `CompanyName` varchar(59) DEFAULT NULL,
  `LegalCompanyName` varchar(59) DEFAULT NULL,
  `Address_Addr1` varchar(41) DEFAULT NULL,
  `Address_Addr2` varchar(41) DEFAULT NULL,
  `Address_Addr3` varchar(41) DEFAULT NULL,
  `Address_Addr4` varchar(41) DEFAULT NULL,
  `Address_Addr5` varchar(41) DEFAULT NULL,
  `Address_City` varchar(31) DEFAULT NULL,
  `Address_State` varchar(21) DEFAULT NULL,
  `Address_PostalCode` varchar(13) DEFAULT NULL,
  `Address_Country` varchar(31) DEFAULT NULL,
  `Address_Note` varchar(41) DEFAULT NULL,
  `LegalAddress_Addr1` varchar(41) DEFAULT NULL,
  `LegalAddress_Addr2` varchar(41) DEFAULT NULL,
  `LegalAddress_Addr3` varchar(41) DEFAULT NULL,
  `LegalAddress_Addr4` varchar(41) DEFAULT NULL,
  `LegalAddress_Addr5` varchar(41) DEFAULT NULL,
  `LegalAddress_City` varchar(31) DEFAULT NULL,
  `LegalAddress_State` varchar(21) DEFAULT NULL,
  `LegalAddress_PostalCode` varchar(13) DEFAULT NULL,
  `LegalAddress_Country` varchar(31) DEFAULT NULL,
  `LegalAddress_Note` varchar(41) DEFAULT NULL,
  `AddressCust_Addr1` varchar(41) DEFAULT NULL,
  `AddressCust_Addr2` varchar(41) DEFAULT NULL,
  `AddressCust_Addr3` varchar(41) DEFAULT NULL,
  `AddressCust_Addr4` varchar(41) DEFAULT NULL,
  `AddressCust_Addr5` varchar(41) DEFAULT NULL,
  `AddressCust_City` varchar(31) DEFAULT NULL,
  `AddressCust_State` varchar(21) DEFAULT NULL,
  `AddressCust_PostalCode` varchar(13) DEFAULT NULL,
  `AddressCust_Country` varchar(31) DEFAULT NULL,
  `AddressCust_Note` varchar(41) DEFAULT NULL,
  `AddressBlockCust_Addr1` varchar(41) DEFAULT NULL,
  `AddressBlockCust_Addr2` varchar(41) DEFAULT NULL,
  `AddressBlockCust_Addr3` varchar(41) DEFAULT NULL,
  `AddressBlockCust_Addr4` varchar(41) DEFAULT NULL,
  `AddressBlockCust_Addr5` varchar(41) DEFAULT NULL,
  `Phone` varchar(51) DEFAULT NULL,
  `Fax` varchar(51) DEFAULT NULL,
  `Email` varchar(1000) DEFAULT NULL,
  `CompanyWebSite` varchar(128) DEFAULT NULL,
  `FirstMonthFiscalYear` varchar(255) DEFAULT NULL,
  `FirstMonthIncomeTaxYear` varchar(255) DEFAULT NULL,
  `CompanyType` varchar(255) DEFAULT NULL,
  `EIN` varchar(20) DEFAULT NULL,
  `SSN` varchar(11) DEFAULT NULL,
  `TaxForm` varchar(255) DEFAULT NULL,
  `SubscribedServices` varchar(1000) DEFAULT NULL,
  `AccountantCopy` varchar(5) DEFAULT NULL,
  `LSData` varchar(10) DEFAULT NULL
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_0900_ai_ci;



CREATE TABLE `componentitemlineret` (
  `ItemRef_ListID` varchar(36) DEFAULT NULL,
  `ItemRef_FullName` varchar(159) DEFAULT NULL,
  `InvSiteRef_ListID` varchar(36) DEFAULT NULL,
  `InvSiteRef_FullName` varchar(31) DEFAULT NULL,
  `InvSiteLocRef_ListID` varchar(36) DEFAULT NULL,
  `InvSiteLocRef_FullName` varchar(31) DEFAULT NULL,
  `Description` varchar(1000) DEFAULT NULL,
  `QuantityOnHand` decimal(15,2) DEFAULT NULL,
  `QuantityNeeded` decimal(15,2) DEFAULT NULL,
  `SerialNumber` varchar(1000) DEFAULT NULL,
  `LotNumber` varchar(40) DEFAULT NULL,
  `PARENT_IDKEY` varchar(36) DEFAULT NULL,
  `SeqNum` int DEFAULT NULL,
  `LSData` varchar(10) DEFAULT NULL,
  KEY `componentitemlineretIdIndex` (`PARENT_IDKEY`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_0900_ai_ci;



CREATE TABLE `contactsret` (
  `ListID` varchar(36) NOT NULL,
  `TimeCreated` datetime DEFAULT NULL,
  `TimeModified` datetime DEFAULT NULL,
  `EditSequence` varchar(16) DEFAULT NULL,
  `Contact` varchar(41) DEFAULT NULL,
  `Salutation` varchar(15) DEFAULT NULL,
  `FirstName` varchar(25) DEFAULT NULL,
  `MiddleName` varchar(5) DEFAULT NULL,
  `LastName` varchar(25) DEFAULT NULL,
  `JobTitle` varchar(41) DEFAULT NULL,
  `PARENT_IDKEY` varchar(36) DEFAULT NULL,
  `SeqNum` int DEFAULT NULL,
  `LSData` varchar(10) DEFAULT NULL,
  KEY `contactsretIdIndex` (`PARENT_IDKEY`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_0900_ai_ci;



CREATE TABLE `creditcardcharge` (
  `TxnID` varchar(36) NOT NULL,
  `TimeCreated` datetime DEFAULT NULL,
  `TimeModified` datetime DEFAULT NULL,
  `EditSequence` varchar(16) DEFAULT NULL,
  `TxnNumber` int DEFAULT NULL,
  `AccountRef_ListID` varchar(36) DEFAULT NULL,
  `AccountRef_FullName` varchar(159) DEFAULT NULL,
  `PayeeEntityRef_ListID` varchar(36) DEFAULT NULL,
  `PayeeEntityRef_FullName` varchar(209) DEFAULT NULL,
  `TxnDate` datetime DEFAULT NULL,
  `Amount` decimal(15,2) DEFAULT NULL,
  `CurrencyRef_ListID` varchar(36) DEFAULT NULL,
  `CurrencyRef_FullName` varchar(64) DEFAULT NULL,
  `ExchangeRate` decimal(16,6) DEFAULT NULL,
  `AmountInHomeCurrency` decimal(15,2) DEFAULT NULL,
  `RefNumber` varchar(25) DEFAULT NULL,
  `Memo` varchar(1000) DEFAULT NULL,
  `IsTaxIncluded` varchar(5) DEFAULT NULL,
  `SalesTaxCodeRef_ListID` varchar(36) DEFAULT NULL,
  `SalesTaxCodeRef_FullName` varchar(3) DEFAULT NULL,
  `ExternalGUID` varchar(255) DEFAULT NULL,
  `UserData` varchar(255) DEFAULT NULL,
  `Operation` varchar(10) DEFAULT NULL,
  `LSData` varchar(10) DEFAULT NULL,
  PRIMARY KEY (`TxnID`),
  UNIQUE KEY `creditcardchargeIdIndex` (`TxnID`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_0900_ai_ci;




CREATE TABLE `creditcardcredit` (
  `TxnID` varchar(36) NOT NULL,
  `TimeCreated` datetime DEFAULT NULL,
  `TimeModified` datetime DEFAULT NULL,
  `EditSequence` varchar(16) DEFAULT NULL,
  `TxnNumber` int DEFAULT NULL,
  `AccountRef_ListID` varchar(36) DEFAULT NULL,
  `AccountRef_FullName` varchar(159) DEFAULT NULL,
  `PayeeEntityRef_ListID` varchar(36) DEFAULT NULL,
  `PayeeEntityRef_FullName` varchar(209) DEFAULT NULL,
  `TxnDate` datetime DEFAULT NULL,
  `Amount` decimal(15,2) DEFAULT NULL,
  `CurrencyRef_ListID` varchar(36) DEFAULT NULL,
  `CurrencyRef_FullName` varchar(64) DEFAULT NULL,
  `ExchangeRate` decimal(16,6) DEFAULT NULL,
  `AmountInHomeCurrency` decimal(15,2) DEFAULT NULL,
  `RefNumber` varchar(25) DEFAULT NULL,
  `Memo` varchar(1000) DEFAULT NULL,
  `IsTaxIncluded` varchar(5) DEFAULT NULL,
  `SalesTaxCodeRef_ListID` varchar(36) DEFAULT NULL,
  `SalesTaxCodeRef_FullName` varchar(3) DEFAULT NULL,
  `ExternalGUID` varchar(255) DEFAULT NULL,
  `UserData` varchar(255) DEFAULT NULL,
  `Operation` varchar(10) DEFAULT NULL,
  `LSData` varchar(10) DEFAULT NULL,
  PRIMARY KEY (`TxnID`),
  UNIQUE KEY `creditcardcreditIdIndex` (`TxnID`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_0900_ai_ci;



CREATE TABLE `creditmemo` (
  `TxnID` varchar(36) NOT NULL,
  `TimeCreated` datetime DEFAULT NULL,
  `TimeModified` datetime DEFAULT NULL,
  `EditSequence` varchar(16) DEFAULT NULL,
  `TxnNumber` int DEFAULT NULL,
  `CustomerRef_ListID` varchar(36) DEFAULT NULL,
  `CustomerRef_FullName` varchar(209) DEFAULT NULL,
  `ClassRef_ListID` varchar(36) DEFAULT NULL,
  `ClassRef_FullName` varchar(159) DEFAULT NULL,
  `ARAccountRef_ListID` varchar(36) DEFAULT NULL,
  `ARAccountRef_FullName` varchar(159) DEFAULT NULL,
  `TemplateRef_ListID` varchar(36) DEFAULT NULL,
  `TemplateRef_FullName` varchar(31) DEFAULT NULL,
  `TxnDate` datetime DEFAULT NULL,
  `RefNumber` varchar(25) DEFAULT NULL,
  `BillAddress_Addr1` varchar(41) DEFAULT NULL,
  `BillAddress_Addr2` varchar(41) DEFAULT NULL,
  `BillAddress_Addr3` varchar(41) DEFAULT NULL,
  `BillAddress_Addr4` varchar(41) DEFAULT NULL,
  `BillAddress_Addr5` varchar(41) DEFAULT NULL,
  `BillAddress_City` varchar(31) DEFAULT NULL,
  `BillAddress_State` varchar(21) DEFAULT NULL,
  `BillAddress_PostalCode` varchar(13) DEFAULT NULL,
  `BillAddress_Country` varchar(31) DEFAULT NULL,
  `BillAddress_Note` varchar(41) DEFAULT NULL,
  `ShipAddress_Addr1` varchar(41) DEFAULT NULL,
  `ShipAddress_Addr2` varchar(41) DEFAULT NULL,
  `ShipAddress_Addr3` varchar(41) DEFAULT NULL,
  `ShipAddress_Addr4` varchar(41) DEFAULT NULL,
  `ShipAddress_Addr5` varchar(41) DEFAULT NULL,
  `ShipAddress_City` varchar(31) DEFAULT NULL,
  `ShipAddress_State` varchar(21) DEFAULT NULL,
  `ShipAddress_PostalCode` varchar(13) DEFAULT NULL,
  `ShipAddress_Country` varchar(31) DEFAULT NULL,
  `ShipAddress_Note` varchar(41) DEFAULT NULL,
  `IsPending` varchar(5) DEFAULT NULL,
  `PONumber` varchar(25) DEFAULT NULL,
  `TermsRef_ListID` varchar(36) DEFAULT NULL,
  `TermsRef_FullName` varchar(31) DEFAULT NULL,
  `DueDate` datetime DEFAULT NULL,
  `SalesRepRef_ListID` varchar(36) DEFAULT NULL,
  `SalesRepRef_FullName` varchar(5) DEFAULT NULL,
  `FOB` varchar(13) DEFAULT NULL,
  `ShipDate` datetime DEFAULT NULL,
  `ShipMethodRef_ListID` varchar(36) DEFAULT NULL,
  `ShipMethodRef_FullName` varchar(15) DEFAULT NULL,
  `Subtotal` decimal(16,6) DEFAULT NULL,
  `ItemSalesTaxRef_ListID` varchar(36) DEFAULT NULL,
  `ItemSalesTaxRef_FullName` varchar(31) DEFAULT NULL,
  `SalesTaxPercentage` decimal(16,6) DEFAULT NULL,
  `SalesTaxTotal` decimal(16,6) DEFAULT NULL,
  `TotalAmount` decimal(15,2) DEFAULT NULL,
  `CreditRemaining` decimal(16,6) DEFAULT NULL,
  `CurrencyRef_ListID` varchar(36) DEFAULT NULL,
  `CurrencyRef_FullName` varchar(64) DEFAULT NULL,
  `ExchangeRate` decimal(16,6) DEFAULT NULL,
  `CreditRemainingInHomeCurrency` decimal(16,6) DEFAULT NULL,
  `Memo` varchar(1000) DEFAULT NULL,
  `CustomerMsgRef_ListID` varchar(36) DEFAULT NULL,
  `CustomerMsgRef_FullName` varchar(101) DEFAULT NULL,
  `IsToBePrinted` varchar(5) DEFAULT NULL,
  `IsToBeEmailed` varchar(5) DEFAULT NULL,
  `IsTaxIncluded` varchar(5) DEFAULT NULL,
  `CustSalesTaxCodeRef_ListID` varchar(36) DEFAULT NULL,
  `CustSalesTaxCodeRef_FullName` varchar(3) DEFAULT NULL,
  `Other` varchar(29) DEFAULT NULL,
  `ExternalGUID` varchar(255) DEFAULT NULL,
  `CustomField1` varchar(255) DEFAULT NULL,
  `CustomField2` varchar(255) DEFAULT NULL,
  `CustomField3` varchar(255) DEFAULT NULL,
  `CustomField4` varchar(255) DEFAULT NULL,
  `CustomField5` varchar(255) DEFAULT NULL,
  `CustomField6` varchar(255) DEFAULT NULL,
  `CustomField7` varchar(255) DEFAULT NULL,
  `CustomField8` varchar(255) DEFAULT NULL,
  `CustomField9` varchar(255) DEFAULT NULL,
  `CustomField10` varchar(255) DEFAULT NULL,
  `CustomField11` varchar(255) DEFAULT NULL,
  `CustomField12` varchar(255) DEFAULT NULL,
  `CustomField13` varchar(255) DEFAULT NULL,
  `CustomField14` varchar(255) DEFAULT NULL,
  `CustomField15` varchar(255) DEFAULT NULL,
  `UserData` varchar(255) DEFAULT NULL,
  `Operation` varchar(10) DEFAULT NULL,
  `LSData` varchar(10) DEFAULT NULL,
  PRIMARY KEY (`TxnID`),
  UNIQUE KEY `creditmemoIdIndex` (`TxnID`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_0900_ai_ci;




CREATE TABLE `creditmemolinegroupret` (
  `TxnLineID` varchar(36) DEFAULT NULL,
  `ItemGroupRef_ListID` varchar(36) DEFAULT NULL,
  `ItemGroupRef_FullName` varchar(31) DEFAULT NULL,
  `Description` varchar(1000) DEFAULT NULL,
  `Quantity` decimal(16,6) DEFAULT NULL,
  `IsPrintItemsInGroup` varchar(5) DEFAULT NULL,
  `TotalAmount` decimal(15,2) DEFAULT NULL,
  `ServiceDate` datetime DEFAULT NULL,
  `OverrideUOMSetRef_ListID` varchar(36) DEFAULT NULL,
  `OverrideUOMSetRef_FullName` varchar(31) DEFAULT NULL,
  `UnitOfMeasure` varchar(31) DEFAULT NULL,
  `CustomField1` varchar(255) DEFAULT NULL,
  `CustomField2` varchar(255) DEFAULT NULL,
  `CustomField3` varchar(255) DEFAULT NULL,
  `CustomField4` varchar(255) DEFAULT NULL,
  `CustomField5` varchar(255) DEFAULT NULL,
  `CustomField6` varchar(255) DEFAULT NULL,
  `CustomField7` varchar(255) DEFAULT NULL,
  `CustomField8` varchar(255) DEFAULT NULL,
  `CustomField9` varchar(255) DEFAULT NULL,
  `CustomField10` varchar(255) DEFAULT NULL,
  `CustomField11` varchar(255) DEFAULT NULL,
  `CustomField12` varchar(255) DEFAULT NULL,
  `CustomField13` varchar(255) DEFAULT NULL,
  `CustomField14` varchar(255) DEFAULT NULL,
  `CustomField15` varchar(255) DEFAULT NULL,
  `PARENT_IDKEY` varchar(36) DEFAULT NULL,
  `GroupPARENT_IDKEY` varchar(255) DEFAULT NULL,
  `SeqNum` int DEFAULT NULL,
  `LSData` varchar(10) DEFAULT NULL,
  KEY `creditmemolinegroupretIdIndex` (`PARENT_IDKEY`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_0900_ai_ci;




CREATE TABLE `creditmemolineret` (
  `TxnLineID` varchar(36) DEFAULT NULL,
  `ItemRef_ListID` varchar(36) DEFAULT NULL,
  `ItemRef_FullName` varchar(159) DEFAULT NULL,
  `Description` varchar(1000) DEFAULT NULL,
  `Quantity` decimal(16,6) DEFAULT NULL,
  `UnitOfMeasure` varchar(31) DEFAULT NULL,
  `OverrideUOMSetRef_ListID` varchar(36) DEFAULT NULL,
  `OverrideUOMSetRef_FullName` varchar(31) DEFAULT NULL,
  `Rate` decimal(16,6) DEFAULT NULL,
  `RatePercent` decimal(16,6) DEFAULT NULL,
  `ClassRef_ListID` varchar(36) DEFAULT NULL,
  `ClassRef_FullName` varchar(159) DEFAULT NULL,
  `Amount` decimal(15,2) DEFAULT NULL,
  `TaxAmount` decimal(15,2) DEFAULT NULL,
  `InvSiteRef_ListID` varchar(36) DEFAULT NULL,
  `InvSiteRef_FullName` varchar(31) DEFAULT NULL,
  `InvSiteLocRef_ListID` varchar(36) DEFAULT NULL,
  `InvSiteLocRef_FullName` varchar(31) DEFAULT NULL,
  `SerialNumber` varchar(1000) DEFAULT NULL,
  `LotNumber` varchar(40) DEFAULT NULL,
  `ServiceDate` datetime DEFAULT NULL,
  `SalesTaxCodeRef_ListID` varchar(36) DEFAULT NULL,
  `SalesTaxCodeRef_FullName` varchar(3) DEFAULT NULL,
  `IsTaxable` varchar(5) DEFAULT NULL,
  `Other1` varchar(29) DEFAULT NULL,
  `Other2` varchar(29) DEFAULT NULL,
  `CCTII_CreditCardNumber` varchar(25) DEFAULT NULL,
  `CCTII_ExpirationMonth` int DEFAULT NULL,
  `CCTII_ExpirationYear` int DEFAULT NULL,
  `CCTII_NameOnCard` varchar(41) DEFAULT NULL,
  `CCTII_CreditCardAddress` varchar(41) DEFAULT NULL,
  `CCTII_CreditCardPostalCode` varchar(18) DEFAULT NULL,
  `CCTII_CommercialCardCode` varchar(24) DEFAULT NULL,
  `CCTII_TransactionMode` varchar(255) DEFAULT NULL,
  `CCTII_CreditCardTxnType` varchar(255) DEFAULT NULL,
  `CCTRI_ResultCode` int DEFAULT NULL,
  `CCTRI_ResultMessage` varchar(60) DEFAULT NULL,
  `CCTRI_CreditCardTransID` varchar(24) DEFAULT NULL,
  `CCTRI_MerchantAccountNumber` varchar(32) DEFAULT NULL,
  `CCTRI_AuthorizationCode` varchar(12) DEFAULT NULL,
  `CCTRI_AVSStreet` varchar(255) DEFAULT NULL,
  `CCTRI_AVSZip` varchar(255) DEFAULT NULL,
  `CCTRI_CardSecurityCodeMatch` varchar(255) DEFAULT NULL,
  `CCTRI_ReconBatchID` varchar(84) DEFAULT NULL,
  `CCTRI_PaymentGroupingCode` int DEFAULT NULL,
  `CCTRI_PaymentStatus` varchar(255) DEFAULT NULL,
  `CCTRI_TxnAuthorizationTime` datetime DEFAULT NULL,
  `CCTRI_TxnAuthorizationStamp` int DEFAULT NULL,
  `CCTRI_ClientTransID` varchar(16) DEFAULT NULL,
  `CustomField1` varchar(255) DEFAULT NULL,
  `CustomField2` varchar(255) DEFAULT NULL,
  `CustomField3` varchar(255) DEFAULT NULL,
  `CustomField4` varchar(255) DEFAULT NULL,
  `CustomField5` varchar(255) DEFAULT NULL,
  `CustomField6` varchar(255) DEFAULT NULL,
  `CustomField7` varchar(255) DEFAULT NULL,
  `CustomField8` varchar(255) DEFAULT NULL,
  `CustomField9` varchar(255) DEFAULT NULL,
  `CustomField10` varchar(255) DEFAULT NULL,
  `CustomField11` varchar(255) DEFAULT NULL,
  `CustomField12` varchar(255) DEFAULT NULL,
  `CustomField13` varchar(255) DEFAULT NULL,
  `CustomField14` varchar(255) DEFAULT NULL,
  `CustomField15` varchar(255) DEFAULT NULL,
  `PARENT_IDKEY` varchar(36) DEFAULT NULL,
  `GroupPARENT_IDKEY` varchar(255) DEFAULT NULL,
  `SeqNum` int DEFAULT NULL,
  `LSData` varchar(10) DEFAULT NULL,
  KEY `creditmemolineretIdIndex` (`PARENT_IDKEY`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_0900_ai_ci;




CREATE TABLE `currency` (
  `ListID` varchar(36) NOT NULL,
  `TimeCreated` datetime DEFAULT NULL,
  `TimeModified` datetime DEFAULT NULL,
  `EditSequence` varchar(16) DEFAULT NULL,
  `Name` varchar(64) DEFAULT NULL,
  `IsActive` varchar(5) DEFAULT NULL,
  `CurrencyCode` varchar(3) DEFAULT NULL,
  `ThousandSeparator` varchar(255) DEFAULT NULL,
  `ThousandSeparatorGrouping` varchar(255) DEFAULT NULL,
  `DecimalPlaces` varchar(255) DEFAULT NULL,
  `DecimalSeparator` varchar(255) DEFAULT NULL,
  `IsUserDefinedCurrency` varchar(5) DEFAULT NULL,
  `ExchangeRate` decimal(16,6) DEFAULT NULL,
  `AsOfDate` datetime DEFAULT NULL,
  `UserData` varchar(255) DEFAULT NULL,
  `Operation` varchar(10) DEFAULT NULL,
  `LSData` varchar(10) DEFAULT NULL,
  PRIMARY KEY (`ListID`),
  UNIQUE KEY `currencyIdIndex` (`ListID`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_0900_ai_ci;



CREATE TABLE `customer` (
  `ListID` varchar(36) NOT NULL,
  `TimeCreated` datetime DEFAULT NULL,
  `TimeModified` datetime DEFAULT NULL,
  `EditSequence` varchar(16) DEFAULT NULL,
  `Name` varchar(41) DEFAULT NULL,
  `FullName` varchar(209) DEFAULT NULL,
  `IsActive` varchar(5) DEFAULT NULL,
  `ClassRef_ListID` varchar(36) DEFAULT NULL,
  `ClassRef_FullName` varchar(159) DEFAULT NULL,
  `ParentRef_ListID` varchar(36) DEFAULT NULL,
  `ParentRef_FullName` varchar(209) DEFAULT NULL,
  `Sublevel` int DEFAULT NULL,
  `CompanyName` varchar(41) DEFAULT NULL,
  `Salutation` varchar(15) DEFAULT NULL,
  `FirstName` varchar(25) DEFAULT NULL,
  `MiddleName` varchar(5) DEFAULT NULL,
  `LastName` varchar(25) DEFAULT NULL,
  `Suffix` varchar(25) DEFAULT NULL,
  `PrintAs` varchar(255) DEFAULT NULL,
  `BillAddress_Addr1` varchar(41) DEFAULT NULL,
  `BillAddress_Addr2` varchar(41) DEFAULT NULL,
  `BillAddress_Addr3` varchar(41) DEFAULT NULL,
  `BillAddress_Addr4` varchar(41) DEFAULT NULL,
  `BillAddress_Addr5` varchar(41) DEFAULT NULL,
  `BillAddress_City` varchar(31) DEFAULT NULL,
  `BillAddress_State` varchar(21) DEFAULT NULL,
  `BillAddress_PostalCode` varchar(13) DEFAULT NULL,
  `BillAddress_Country` varchar(31) DEFAULT NULL,
  `BillAddress_Note` varchar(41) DEFAULT NULL,
  `ShipAddress_Addr1` varchar(41) DEFAULT NULL,
  `ShipAddress_Addr2` varchar(41) DEFAULT NULL,
  `ShipAddress_Addr3` varchar(41) DEFAULT NULL,
  `ShipAddress_Addr4` varchar(41) DEFAULT NULL,
  `ShipAddress_Addr5` varchar(41) DEFAULT NULL,
  `ShipAddress_City` varchar(31) DEFAULT NULL,
  `ShipAddress_State` varchar(21) DEFAULT NULL,
  `ShipAddress_PostalCode` varchar(13) DEFAULT NULL,
  `ShipAddress_Country` varchar(31) DEFAULT NULL,
  `ShipAddress_Note` varchar(41) DEFAULT NULL,
  `Phone` varchar(255) DEFAULT NULL,
  `Mobile` varchar(255) DEFAULT NULL,
  `Pager` varchar(255) DEFAULT NULL,
  `AltPhone` varchar(255) DEFAULT NULL,
  `Fax` varchar(255) DEFAULT NULL,
  `Email` varchar(1000) DEFAULT NULL,
  `Contact` varchar(41) DEFAULT NULL,
  `AltContact` varchar(41) DEFAULT NULL,
  `CustomerTypeRef_ListID` varchar(36) DEFAULT NULL,
  `CustomerTypeRef_FullName` varchar(159) DEFAULT NULL,
  `TermsRef_ListID` varchar(36) DEFAULT NULL,
  `TermsRef_FullName` varchar(31) DEFAULT NULL,
  `SalesRepRef_ListID` varchar(36) DEFAULT NULL,
  `SalesRepRef_FullName` varchar(5) DEFAULT NULL,
  `Balance` decimal(15,2) DEFAULT NULL,
  `OpenBalanceDate` datetime DEFAULT NULL,
  `TotalBalance` decimal(15,2) DEFAULT NULL,
  `SalesTaxCodeRef_ListID` varchar(36) DEFAULT NULL,
  `SalesTaxCodeRef_FullName` varchar(3) DEFAULT NULL,
  `ItemSalesTaxRef_ListID` varchar(36) DEFAULT NULL,
  `ItemSalesTaxRef_FullName` varchar(31) DEFAULT NULL,
  `SalesTaxCountry` varchar(255) DEFAULT NULL,
  `ResaleNumber` varchar(15) DEFAULT NULL,
  `AccountNumber` varchar(99) DEFAULT NULL,
  `CreditLimit` decimal(15,2) DEFAULT NULL,
  `PFDPaymentMethodRef_ListID` varchar(36) DEFAULT NULL,
  `PFDPaymentMethodRef_FullName` varchar(31) DEFAULT NULL,
  `CreditCardNumber` varchar(25) DEFAULT NULL,
  `ExpirationMonth` int DEFAULT NULL,
  `ExpirationYear` int DEFAULT NULL,
  `NameOnCard` varchar(41) DEFAULT NULL,
  `CreditCardAddress` varchar(41) DEFAULT NULL,
  `CreditCardPostalCode` varchar(41) DEFAULT NULL,
  `JobStatus` varchar(255) DEFAULT NULL,
  `JobStartDate` datetime DEFAULT NULL,
  `JobProjectedEndDate` datetime DEFAULT NULL,
  `JobEndDate` datetime DEFAULT NULL,
  `JobDesc` varchar(99) DEFAULT NULL,
  `JobTypeRef_ListID` varchar(36) DEFAULT NULL,
  `JobTypeRef_FullName` varchar(159) DEFAULT NULL,
  `Notes` varchar(1000) DEFAULT NULL,
  `PriceLevelRef_ListID` varchar(36) DEFAULT NULL,
  `PriceLevelRef_FullName` varchar(31) DEFAULT NULL,
  `ExternalGUID` varchar(255) DEFAULT NULL,
  `TaxRegistrationNumber` varchar(30) DEFAULT NULL,
  `CurrencyRef_ListID` varchar(36) DEFAULT NULL,
  `CurrencyRef_FullName` varchar(64) DEFAULT NULL,
  `DeliveryMethod` varchar(255) DEFAULT NULL,
  `JobTitle` varchar(41) DEFAULT NULL,
  `Cc` varchar(1000) DEFAULT NULL,
  `PreferredDeliveryMethod` varchar(255) DEFAULT NULL,
  `CustomField1` varchar(255) DEFAULT NULL,
  `CustomField2` varchar(255) DEFAULT NULL,
  `CustomField3` varchar(255) DEFAULT NULL,
  `CustomField4` varchar(255) DEFAULT NULL,
  `CustomField5` varchar(255) DEFAULT NULL,
  `CustomField6` varchar(255) DEFAULT NULL,
  `CustomField7` varchar(255) DEFAULT NULL,
  `CustomField8` varchar(255) DEFAULT NULL,
  `CustomField9` varchar(255) DEFAULT NULL,
  `CustomField10` varchar(255) DEFAULT NULL,
  `CustomField11` varchar(255) DEFAULT NULL,
  `CustomField12` varchar(255) DEFAULT NULL,
  `CustomField13` varchar(255) DEFAULT NULL,
  `CustomField14` varchar(255) DEFAULT NULL,
  `CustomField15` varchar(255) DEFAULT NULL,
  `UserData` varchar(255) DEFAULT NULL,
  `Operation` varchar(10) DEFAULT NULL,
  `LSData` varchar(10) DEFAULT NULL,
  PRIMARY KEY (`ListID`),
  UNIQUE KEY `customerIdIndex` (`ListID`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_0900_ai_ci;



CREATE TABLE `customermsg` (
  `ListID` varchar(36) NOT NULL,
  `TimeCreated` datetime DEFAULT NULL,
  `TimeModified` datetime DEFAULT NULL,
  `EditSequence` varchar(16) DEFAULT NULL,
  `Name` varchar(101) DEFAULT NULL,
  `IsActive` varchar(5) DEFAULT NULL,
  `UserData` varchar(255) DEFAULT NULL,
  `Operation` varchar(10) DEFAULT NULL,
  `LSData` varchar(10) DEFAULT NULL,
  PRIMARY KEY (`ListID`),
  UNIQUE KEY `customermsgIdIndex` (`ListID`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_0900_ai_ci;




CREATE TABLE `customertype` (
  `ListID` varchar(36) NOT NULL,
  `TimeCreated` datetime DEFAULT NULL,
  `TimeModified` datetime DEFAULT NULL,
  `EditSequence` varchar(16) DEFAULT NULL,
  `Name` varchar(31) DEFAULT NULL,
  `FullName` varchar(159) DEFAULT NULL,
  `IsActive` varchar(5) DEFAULT NULL,
  `ParentRef_ListID` varchar(36) DEFAULT NULL,
  `ParentRef_FullName` varchar(209) DEFAULT NULL,
  `Sublevel` int DEFAULT NULL,
  `UserData` varchar(255) DEFAULT NULL,
  `Operation` varchar(10) DEFAULT NULL,
  `LSData` varchar(10) DEFAULT NULL,
  PRIMARY KEY (`ListID`),
  UNIQUE KEY `customertypeIdIndex` (`ListID`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_0900_ai_ci;




CREATE TABLE `dataextdef` (
  `DataExtID` varchar(36) DEFAULT NULL,
  `OwnerID` varchar(36) DEFAULT NULL,
  `DataExtName` varchar(31) DEFAULT NULL,
  `DataExtNewName` varchar(31) DEFAULT NULL,
  `DataExtType` varchar(255) DEFAULT NULL,
  `AssignToObject` varchar(255) DEFAULT NULL,
  `RemoveFromObject` varchar(255) DEFAULT NULL,
  `DataExtListRequire` varchar(5) DEFAULT NULL,
  `DataExtTxnRequire` varchar(5) DEFAULT NULL,
  `DataExtFormatString` varchar(255) DEFAULT NULL,
  `UserData` varchar(255) DEFAULT NULL,
  `Operation` varchar(10) DEFAULT NULL,
  `LSData` varchar(10) DEFAULT NULL
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_0900_ai_ci;




CREATE TABLE `datedriventerms` (
  `ListID` varchar(36) NOT NULL,
  `TimeCreated` datetime DEFAULT NULL,
  `TimeModified` datetime DEFAULT NULL,
  `EditSequence` varchar(16) DEFAULT NULL,
  `Name` varchar(31) DEFAULT NULL,
  `IsActive` varchar(5) DEFAULT NULL,
  `DayOfMonthDue` int DEFAULT NULL,
  `DueNextMonthDays` int DEFAULT NULL,
  `DiscountDayOfMonth` int DEFAULT NULL,
  `DiscountPct` decimal(16,6) DEFAULT NULL,
  `UserData` varchar(255) DEFAULT NULL,
  `Operation` varchar(10) DEFAULT NULL,
  `LSData` varchar(10) DEFAULT NULL,
  PRIMARY KEY (`ListID`),
  UNIQUE KEY `datedriventermsIdIndex` (`ListID`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_0900_ai_ci;




CREATE TABLE `defaultunitret` (
  `UnitUsedFor` varchar(255) DEFAULT NULL,
  `Unit` varchar(31) DEFAULT NULL,
  `PARENT_IDKEY` varchar(36) DEFAULT NULL,
  `SeqNum` int DEFAULT NULL,
  `LSData` varchar(10) DEFAULT NULL,
  KEY `defaultunitretIdIndex` (`PARENT_IDKEY`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_0900_ai_ci;




CREATE TABLE `deposit` (
  `TxnID` varchar(36) NOT NULL,
  `TimeCreated` datetime DEFAULT NULL,
  `TimeModified` datetime DEFAULT NULL,
  `EditSequence` varchar(16) DEFAULT NULL,
  `TxnNumber` int DEFAULT NULL,
  `TxnDate` datetime DEFAULT NULL,
  `DepositToAccountRef_ListID` varchar(36) DEFAULT NULL,
  `DepositToAccountRef_FullName` varchar(159) DEFAULT NULL,
  `Memo` varchar(1000) DEFAULT NULL,
  `DepositTotal` decimal(16,6) DEFAULT NULL,
  `CurrencyRef_ListID` varchar(36) DEFAULT NULL,
  `CurrencyRef_FullName` varchar(64) DEFAULT NULL,
  `ExchangeRate` decimal(16,6) DEFAULT NULL,
  `DepositTotalInHomeCurrency` decimal(16,6) DEFAULT NULL,
  `ExternalGUID` varchar(255) DEFAULT NULL,
  `UserData` varchar(255) DEFAULT NULL,
  `Operation` varchar(10) DEFAULT NULL,
  `LSData` varchar(10) DEFAULT NULL,
  PRIMARY KEY (`TxnID`),
  UNIQUE KEY `depositIdIndex` (`TxnID`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_0900_ai_ci;



CREATE TABLE `depositlineret` (
  `TxnType` varchar(255) DEFAULT NULL,
  `TxnID` varchar(36) DEFAULT NULL,
  `TxnLineID` varchar(36) DEFAULT NULL,
  `PaymentTxnLineID` varchar(36) DEFAULT NULL,
  `EntityRef_ListID` varchar(36) DEFAULT NULL,
  `EntityRef_FullName` varchar(209) DEFAULT NULL,
  `AccountRef_ListID` varchar(36) DEFAULT NULL,
  `AccountRef_FullName` varchar(159) DEFAULT NULL,
  `Memo` varchar(1000) DEFAULT NULL,
  `CheckNumber` varchar(25) DEFAULT NULL,
  `PaymentMethodRef_ListID` varchar(36) DEFAULT NULL,
  `PaymentMethodRef_FullName` varchar(31) DEFAULT NULL,
  `ClassRef_ListID` varchar(36) DEFAULT NULL,
  `ClassRef_FullName` varchar(159) DEFAULT NULL,
  `Amount` decimal(15,2) DEFAULT NULL,
  `PARENT_IDKEY` varchar(36) DEFAULT NULL,
  `SeqNum` int DEFAULT NULL,
  `LSData` varchar(10) DEFAULT NULL,
  KEY `depositlineretIdIndex` (`PARENT_IDKEY`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_0900_ai_ci;



CREATE TABLE `employee` (
  `ListID` varchar(36) NOT NULL,
  `TimeCreated` datetime DEFAULT NULL,
  `TimeModified` datetime DEFAULT NULL,
  `EditSequence` varchar(16) DEFAULT NULL,
  `Name` varchar(41) DEFAULT NULL,
  `IsActive` varchar(5) DEFAULT NULL,
  `Salutation` varchar(15) DEFAULT NULL,
  `FirstName` varchar(25) DEFAULT NULL,
  `MiddleName` varchar(5) DEFAULT NULL,
  `LastName` varchar(25) DEFAULT NULL,
  `Suffix` varchar(41) DEFAULT NULL,
  `JobTitle` varchar(41) DEFAULT NULL,
  `SupervisorRef_ListID` varchar(36) DEFAULT NULL,
  `SupervisorRef_FullName` varchar(209) DEFAULT NULL,
  `Department` varchar(31) DEFAULT NULL,
  `Description` varchar(64) DEFAULT NULL,
  `TargetBonus` decimal(15,2) DEFAULT NULL,
  `EmployeeAddress_Addr1` varchar(41) DEFAULT NULL,
  `EmployeeAddress_Addr2` varchar(41) DEFAULT NULL,
  `EmployeeAddress_City` varchar(31) DEFAULT NULL,
  `EmployeeAddress_State` varchar(21) DEFAULT NULL,
  `EmployeeAddress_PostalCode` varchar(13) DEFAULT NULL,
  `EmployeeAddress_Country` varchar(31) DEFAULT NULL,
  `PrintAs` varchar(41) DEFAULT NULL,
  `Phone` varchar(255) DEFAULT NULL,
  `Mobile` varchar(255) DEFAULT NULL,
  `Pager` varchar(255) DEFAULT NULL,
  `PagerPIN` varchar(255) DEFAULT NULL,
  `AltPhone` varchar(255) DEFAULT NULL,
  `Fax` varchar(255) DEFAULT NULL,
  `SSN` varchar(11) DEFAULT NULL,
  `Email` varchar(1000) DEFAULT NULL,
  `EmployeeType` varchar(1000) DEFAULT NULL,
  `Gender` varchar(255) DEFAULT NULL,
  `HiredDate` datetime DEFAULT NULL,
  `ReleasedDate` datetime DEFAULT NULL,
  `BirthDate` datetime DEFAULT NULL,
  `AccountNumber` varchar(99) DEFAULT NULL,
  `Notes` varchar(1000) DEFAULT NULL,
  `BillingRateRef_ListID` varchar(36) DEFAULT NULL,
  `BillingRateRef_FullName` varchar(31) DEFAULT NULL,
  `EmergContactPrimaryName` varchar(40) DEFAULT NULL,
  `EmergContactPrimaryValue` varchar(255) DEFAULT NULL,
  `EmergContactPrimaryRelation` varchar(255) DEFAULT NULL,
  `EmergContactSecondaryName` varchar(40) DEFAULT NULL,
  `EmergContactSecondaryValue` varchar(255) DEFAULT NULL,
  `EmergContactSecondaryRelation` varchar(255) DEFAULT NULL,
  `PartOrFullTime` varchar(255) DEFAULT NULL,
  `Exempt` varchar(255) DEFAULT NULL,
  `KeyEmployee` varchar(255) DEFAULT NULL,
  `OriginalHireDate` datetime DEFAULT NULL,
  `AdjustedServiceDate` datetime DEFAULT NULL,
  `USCitizen` varchar(255) DEFAULT NULL,
  `Ethnicity` varchar(255) DEFAULT NULL,
  `Disabled` varchar(255) DEFAULT NULL,
  `DisabilityDesc` varchar(25) DEFAULT NULL,
  `OnFile` varchar(255) DEFAULT NULL,
  `WorkAuthExpireDate` datetime DEFAULT NULL,
  `USVeteran` varchar(255) DEFAULT NULL,
  `MilitaryStatus` varchar(255) DEFAULT NULL,
  `PayPeriod` varchar(255) DEFAULT NULL,
  `ClassRef_ListID` varchar(36) DEFAULT NULL,
  `ClassRef_FullName` varchar(159) DEFAULT NULL,
  `ClearEarnings` varchar(5) DEFAULT NULL,
  `IsUsingTimeDataToCreatePaychecks` varchar(5) DEFAULT NULL,
  `UseTimeDataToCreatePaychecks` varchar(255) DEFAULT NULL,
  `SH_HoursAvailable` varchar(14) DEFAULT NULL,
  `SH_AccrualPeriod` varchar(255) DEFAULT NULL,
  `SH_HoursAccrued` varchar(14) DEFAULT NULL,
  `SH_MaximumHours` varchar(14) DEFAULT NULL,
  `SH_IsResettingHoursEachNewYear` varchar(5) DEFAULT NULL,
  `SH_HoursUsed` varchar(14) DEFAULT NULL,
  `SH_AccrualStartDate` datetime DEFAULT NULL,
  `VH_HoursAvailable` varchar(14) DEFAULT NULL,
  `VH_AccrualPeriod` varchar(255) DEFAULT NULL,
  `VH_HoursAccrued` varchar(14) DEFAULT NULL,
  `VH_MaximumHours` varchar(14) DEFAULT NULL,
  `VH_IsResettingHoursEachNewYear` varchar(5) DEFAULT NULL,
  `VH_HoursUsed` varchar(14) DEFAULT NULL,
  `VH_AccrualStartDate` datetime DEFAULT NULL,
  `CustomField1` varchar(50) DEFAULT NULL,
  `CustomField2` varchar(50) DEFAULT NULL,
  `CustomField3` varchar(50) DEFAULT NULL,
  `CustomField4` varchar(50) DEFAULT NULL,
  `CustomField5` varchar(50) DEFAULT NULL,
  `CustomField6` varchar(50) DEFAULT NULL,
  `CustomField7` varchar(50) DEFAULT NULL,
  `CustomField8` varchar(50) DEFAULT NULL,
  `CustomField9` varchar(50) DEFAULT NULL,
  `CustomField10` varchar(50) DEFAULT NULL,
  `CustomField11` varchar(50) DEFAULT NULL,
  `CustomField12` varchar(50) DEFAULT NULL,
  `CustomField13` varchar(50) DEFAULT NULL,
  `CustomField14` varchar(50) DEFAULT NULL,
  `CustomField15` varchar(50) DEFAULT NULL,
  `ExternalGUID` varchar(255) DEFAULT NULL,
  `UserData` varchar(255) DEFAULT NULL,
  `Operation` varchar(10) DEFAULT NULL,
  `LSData` varchar(10) DEFAULT NULL,
  PRIMARY KEY (`ListID`),
  UNIQUE KEY `employeeIdIndex` (`ListID`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_0900_ai_ci;



CREATE TABLE `entity` (
  `ListID` varchar(36) NOT NULL,
  `FullName` varchar(159) DEFAULT NULL,
  `TableName` varchar(159) DEFAULT NULL,
  `UserData` varchar(255) DEFAULT NULL,
  `Operation` varchar(10) DEFAULT NULL,
  `LSData` varchar(10) DEFAULT NULL,
  PRIMARY KEY (`ListID`),
  UNIQUE KEY `entityIdIndex` (`ListID`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_0900_ai_ci;




CREATE TABLE `error_table` (
  `TimeCreated` datetime DEFAULT NULL,
  `IDKEY` varchar(255) DEFAULT NULL,
  `TableName` varchar(255) DEFAULT NULL,
  `FunctionFail` varchar(255) DEFAULT NULL,
  `ErrorMessage` varchar(1000) DEFAULT NULL,
  `LSData` varchar(10) DEFAULT NULL
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_0900_ai_ci;



CREATE TABLE `estimate` (
  `TxnID` varchar(36) NOT NULL,
  `TimeCreated` datetime DEFAULT NULL,
  `TimeModified` datetime DEFAULT NULL,
  `EditSequence` varchar(16) DEFAULT NULL,
  `TxnNumber` int DEFAULT NULL,
  `CustomerRef_ListID` varchar(36) DEFAULT NULL,
  `CustomerRef_FullName` varchar(209) DEFAULT NULL,
  `ClassRef_ListID` varchar(36) DEFAULT NULL,
  `ClassRef_FullName` varchar(159) DEFAULT NULL,
  `TemplateRef_ListID` varchar(36) DEFAULT NULL,
  `TemplateRef_FullName` varchar(31) DEFAULT NULL,
  `TxnDate` datetime DEFAULT NULL,
  `RefNumber` varchar(25) DEFAULT NULL,
  `BillAddress_Addr1` varchar(41) DEFAULT NULL,
  `BillAddress_Addr2` varchar(41) DEFAULT NULL,
  `BillAddress_Addr3` varchar(41) DEFAULT NULL,
  `BillAddress_Addr4` varchar(41) DEFAULT NULL,
  `BillAddress_Addr5` varchar(41) DEFAULT NULL,
  `BillAddress_City` varchar(31) DEFAULT NULL,
  `BillAddress_State` varchar(21) DEFAULT NULL,
  `BillAddress_PostalCode` varchar(13) DEFAULT NULL,
  `BillAddress_Country` varchar(31) DEFAULT NULL,
  `BillAddress_Note` varchar(41) DEFAULT NULL,
  `ShipAddress_Addr1` varchar(41) DEFAULT NULL,
  `ShipAddress_Addr2` varchar(41) DEFAULT NULL,
  `ShipAddress_Addr3` varchar(41) DEFAULT NULL,
  `ShipAddress_Addr4` varchar(41) DEFAULT NULL,
  `ShipAddress_Addr5` varchar(41) DEFAULT NULL,
  `ShipAddress_City` varchar(31) DEFAULT NULL,
  `ShipAddress_State` varchar(21) DEFAULT NULL,
  `ShipAddress_PostalCode` varchar(13) DEFAULT NULL,
  `ShipAddress_Country` varchar(31) DEFAULT NULL,
  `ShipAddress_Note` varchar(41) DEFAULT NULL,
  `IsActive` varchar(5) DEFAULT NULL,
  `PONumber` varchar(25) DEFAULT NULL,
  `TermsRef_ListID` varchar(36) DEFAULT NULL,
  `TermsRef_FullName` varchar(31) DEFAULT NULL,
  `DueDate` datetime DEFAULT NULL,
  `SalesRepRef_ListID` varchar(36) DEFAULT NULL,
  `SalesRepRef_FullName` varchar(5) DEFAULT NULL,
  `FOB` varchar(13) DEFAULT NULL,
  `Subtotal` decimal(16,6) DEFAULT NULL,
  `ItemSalesTaxRef_ListID` varchar(36) DEFAULT NULL,
  `ItemSalesTaxRef_FullName` varchar(31) DEFAULT NULL,
  `SalesTaxPercentage` decimal(16,6) DEFAULT NULL,
  `SalesTaxTotal` decimal(16,6) DEFAULT NULL,
  `TotalAmount` decimal(15,2) DEFAULT NULL,
  `CurrencyRef_ListID` varchar(36) DEFAULT NULL,
  `CurrencyRef_FullName` varchar(64) DEFAULT NULL,
  `ExchangeRate` decimal(16,6) DEFAULT NULL,
  `TotalAmountInHomeCurrency` decimal(15,2) DEFAULT NULL,
  `Memo` varchar(1000) DEFAULT NULL,
  `CustomerMsgRef_ListID` varchar(36) DEFAULT NULL,
  `CustomerMsgRef_FullName` varchar(101) DEFAULT NULL,
  `IsToBeEmailed` varchar(5) DEFAULT NULL,
  `IsTaxIncluded` varchar(5) DEFAULT NULL,
  `ExternalGUID` varchar(255) DEFAULT NULL,
  `CustSalesTaxCodeRef_ListID` varchar(36) DEFAULT NULL,
  `CustSalesTaxCodeRef_FullName` varchar(3) DEFAULT NULL,
  `Other` varchar(29) DEFAULT NULL,
  `CustomField1` varchar(255) DEFAULT NULL,
  `CustomField2` varchar(255) DEFAULT NULL,
  `CustomField3` varchar(255) DEFAULT NULL,
  `CustomField4` varchar(255) DEFAULT NULL,
  `CustomField5` varchar(255) DEFAULT NULL,
  `CustomField6` varchar(255) DEFAULT NULL,
  `CustomField7` varchar(255) DEFAULT NULL,
  `CustomField8` varchar(255) DEFAULT NULL,
  `CustomField9` varchar(255) DEFAULT NULL,
  `CustomField10` varchar(255) DEFAULT NULL,
  `CustomField11` varchar(255) DEFAULT NULL,
  `CustomField12` varchar(255) DEFAULT NULL,
  `CustomField13` varchar(255) DEFAULT NULL,
  `CustomField14` varchar(255) DEFAULT NULL,
  `CustomField15` varchar(255) DEFAULT NULL,
  `UserData` varchar(255) DEFAULT NULL,
  `Operation` varchar(10) DEFAULT NULL,
  `LSData` varchar(10) DEFAULT NULL,
  PRIMARY KEY (`TxnID`),
  UNIQUE KEY `estimateIdIndex` (`TxnID`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_0900_ai_ci;




CREATE TABLE `estimatelinegroupret` (
  `TxnLineID` varchar(36) DEFAULT NULL,
  `ItemGroupRef_ListID` varchar(36) DEFAULT NULL,
  `ItemGroupRef_FullName` varchar(31) DEFAULT NULL,
  `Description` varchar(1000) DEFAULT NULL,
  `Quantity` decimal(16,6) DEFAULT NULL,
  `UnitOfMeasure` varchar(31) DEFAULT NULL,
  `OverrideUOMSetRef_ListID` varchar(36) DEFAULT NULL,
  `OverrideUOMSetRef_FullName` varchar(31) DEFAULT NULL,
  `IsPrintItemsInGroup` varchar(5) DEFAULT NULL,
  `TotalAmount` decimal(15,2) DEFAULT NULL,
  `CustomField1` varchar(50) DEFAULT NULL,
  `CustomField2` varchar(50) DEFAULT NULL,
  `CustomField3` varchar(50) DEFAULT NULL,
  `CustomField4` varchar(50) DEFAULT NULL,
  `CustomField5` varchar(50) DEFAULT NULL,
  `CustomField6` varchar(50) DEFAULT NULL,
  `CustomField7` varchar(50) DEFAULT NULL,
  `CustomField8` varchar(50) DEFAULT NULL,
  `CustomField9` varchar(50) DEFAULT NULL,
  `CustomField10` varchar(50) DEFAULT NULL,
  `CustomField11` varchar(50) DEFAULT NULL,
  `CustomField12` varchar(50) DEFAULT NULL,
  `CustomField13` varchar(50) DEFAULT NULL,
  `CustomField14` varchar(50) DEFAULT NULL,
  `CustomField15` varchar(50) DEFAULT NULL,
  `PARENT_IDKEY` varchar(36) DEFAULT NULL,
  `GroupPARENT_IDKEY` varchar(255) DEFAULT NULL,
  `SeqNum` int DEFAULT NULL,
  `LSData` varchar(10) DEFAULT NULL,
  KEY `estimatelinegroupretIdIndex` (`PARENT_IDKEY`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_0900_ai_ci;


CREATE TABLE `estimatelineret` (
  `TxnLineID` varchar(36) DEFAULT NULL,
  `ItemRef_ListID` varchar(36) DEFAULT NULL,
  `ItemRef_FullName` varchar(209) DEFAULT NULL,
  `Description` varchar(1000) DEFAULT NULL,
  `Quantity` decimal(16,6) DEFAULT NULL,
  `UnitOfMeasure` varchar(31) DEFAULT NULL,
  `OverrideUOMSetRef_ListID` varchar(36) DEFAULT NULL,
  `OverrideUOMSetRef_FullName` varchar(31) DEFAULT NULL,
  `Rate` decimal(16,6) DEFAULT NULL,
  `RatePercent` decimal(16,6) DEFAULT NULL,
  `ClassRef_ListID` varchar(36) DEFAULT NULL,
  `ClassRef_FullName` varchar(159) DEFAULT NULL,
  `Amount` decimal(15,2) DEFAULT NULL,
  `TaxAmount` decimal(15,2) DEFAULT NULL,
  `InvSiteRef_ListID` varchar(36) DEFAULT NULL,
  `InvSiteRef_FullName` varchar(31) DEFAULT NULL,
  `InvSiteLocRef_ListID` varchar(36) DEFAULT NULL,
  `InvSiteLocRef_FullName` varchar(31) DEFAULT NULL,
  `SalesTaxCodeRef_ListID` varchar(36) DEFAULT NULL,
  `SalesTaxCodeRef_FullName` varchar(3) DEFAULT NULL,
  `MarkupRate` decimal(16,6) DEFAULT NULL,
  `MarkupRatePercent` decimal(16,6) DEFAULT NULL,
  `Other1` varchar(29) DEFAULT NULL,
  `Other2` varchar(29) DEFAULT NULL,
  `CustomField1` varchar(50) DEFAULT NULL,
  `CustomField2` varchar(50) DEFAULT NULL,
  `CustomField3` varchar(50) DEFAULT NULL,
  `CustomField4` varchar(50) DEFAULT NULL,
  `CustomField5` varchar(50) DEFAULT NULL,
  `CustomField6` varchar(50) DEFAULT NULL,
  `CustomField7` varchar(50) DEFAULT NULL,
  `CustomField8` varchar(50) DEFAULT NULL,
  `CustomField9` varchar(50) DEFAULT NULL,
  `CustomField10` varchar(50) DEFAULT NULL,
  `CustomField11` varchar(50) DEFAULT NULL,
  `CustomField12` varchar(50) DEFAULT NULL,
  `CustomField13` varchar(50) DEFAULT NULL,
  `CustomField14` varchar(50) DEFAULT NULL,
  `CustomField15` varchar(50) DEFAULT NULL,
  `PARENT_IDKEY` varchar(36) DEFAULT NULL,
  `GroupPARENT_IDKEY` varchar(255) DEFAULT NULL,
  `SeqNum` int DEFAULT NULL,
  `LSData` varchar(10) DEFAULT NULL,
  KEY `estimatelineretIdIndex` (`PARENT_IDKEY`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_0900_ai_ci;




CREATE TABLE `expenselineret` (
  `TxnLineID` varchar(36) DEFAULT NULL,
  `AccountRef_ListID` varchar(36) DEFAULT NULL,
  `AccountRef_FullName` varchar(159) DEFAULT NULL,
  `Amount` decimal(15,2) DEFAULT NULL,
  `Memo` varchar(1000) DEFAULT NULL,
  `CustomerRef_ListID` varchar(36) DEFAULT NULL,
  `CustomerRef_FullName` varchar(209) DEFAULT NULL,
  `ClassRef_ListID` varchar(36) DEFAULT NULL,
  `ClassRef_FullName` varchar(159) DEFAULT NULL,
  `SalesTaxCodeRef_ListID` varchar(36) DEFAULT NULL,
  `SalesTaxCodeRef_FullName` varchar(3) DEFAULT NULL,
  `BillableStatus` varchar(255) DEFAULT NULL,
  `SalesRepRef_ListID` varchar(36) DEFAULT NULL,
  `SalesRepRef_FullName` varchar(5) DEFAULT NULL,
  `CustomField1` varchar(255) DEFAULT NULL,
  `CustomField2` varchar(255) DEFAULT NULL,
  `CustomField3` varchar(255) DEFAULT NULL,
  `CustomField4` varchar(255) DEFAULT NULL,
  `CustomField5` varchar(255) DEFAULT NULL,
  `CustomField6` varchar(255) DEFAULT NULL,
  `CustomField7` varchar(255) DEFAULT NULL,
  `CustomField8` varchar(255) DEFAULT NULL,
  `CustomField9` varchar(255) DEFAULT NULL,
  `CustomField10` varchar(255) DEFAULT NULL,
  `CustomField11` varchar(255) DEFAULT NULL,
  `CustomField12` varchar(255) DEFAULT NULL,
  `CustomField13` varchar(255) DEFAULT NULL,
  `CustomField14` varchar(255) DEFAULT NULL,
  `CustomField15` varchar(255) DEFAULT NULL,
  `PARENT_IDKEY` varchar(36) DEFAULT NULL,
  `SeqNum` int DEFAULT NULL,
  `LSData` varchar(10) DEFAULT NULL,
  KEY `expenselineretIdIndex` (`PARENT_IDKEY`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_0900_ai_ci;




CREATE TABLE `fixedassetsalesinforet` (
  `SalesDesc` varchar(255) DEFAULT NULL,
  `SalesDate` datetime DEFAULT NULL,
  `SalesPrice` varchar(255) DEFAULT NULL,
  `SalesExpense` varchar(255) DEFAULT NULL,
  `PARENT_IDKEY` varchar(36) DEFAULT NULL,
  `GroupPARENT_IDKEY` varchar(255) DEFAULT NULL,
  `LSData` varchar(10) DEFAULT NULL,
  KEY `fixedassetsalesinforetIdIndex` (`PARENT_IDKEY`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_0900_ai_ci;




CREATE TABLE `history` (
  `TableName` varchar(200) DEFAULT NULL,
  `ModifiedDateTime` datetime DEFAULT NULL,
  `CompanyFilePath` text,
  `WindowsUser` varchar(200) DEFAULT NULL,
  `LSOperation` varchar(50) DEFAULT NULL,
  `RowsAdded` int DEFAULT NULL,
  `RowsUpdated` int DEFAULT NULL,
  `RowsDeleted` int DEFAULT NULL,
  `StartRunningDateTime` datetime DEFAULT NULL,
  `EndRunningDateTime` datetime DEFAULT NULL,
  `RunningResult` varchar(255) DEFAULT NULL
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_0900_ai_ci;




CREATE TABLE `inventoryadjustment` (
  `TxnID` varchar(36) NOT NULL,
  `TimeCreated` datetime DEFAULT NULL,
  `TimeModified` datetime DEFAULT NULL,
  `EditSequence` varchar(16) DEFAULT NULL,
  `TxnNumber` int DEFAULT NULL,
  `AccountRef_ListID` varchar(36) DEFAULT NULL,
  `AccountRef_FullName` varchar(159) DEFAULT NULL,
  `InvSiteRef_ListID` varchar(36) DEFAULT NULL,
  `InvSiteRef_FullName` varchar(31) DEFAULT NULL,
  `TxnDate` datetime DEFAULT NULL,
  `RefNumber` varchar(25) DEFAULT NULL,
  `CustomerRef_ListID` varchar(36) DEFAULT NULL,
  `CustomerRef_FullName` varchar(209) DEFAULT NULL,
  `ClassRef_ListID` varchar(36) DEFAULT NULL,
  `ClassRef_FullName` varchar(159) DEFAULT NULL,
  `Memo` varchar(1000) DEFAULT NULL,
  `ExternalGUID` varchar(255) DEFAULT NULL,
  `UserData` varchar(255) DEFAULT NULL,
  `Operation` varchar(10) DEFAULT NULL,
  `LSData` varchar(10) DEFAULT NULL,
  PRIMARY KEY (`TxnID`),
  UNIQUE KEY `inventoryadjustmentIdIndex` (`TxnID`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_0900_ai_ci;



CREATE TABLE `inventoryadjustmentlineret` (
  `TxnLineID` varchar(36) DEFAULT NULL,
  `ItemRef_ListID` varchar(36) DEFAULT NULL,
  `ItemRef_FullName` varchar(209) DEFAULT NULL,
  `SerialNumber` varchar(1000) DEFAULT NULL,
  `LotNumber` varchar(40) DEFAULT NULL,
  `CountAdjustment` int DEFAULT NULL,
  `NewQuantity` decimal(16,6) DEFAULT NULL,
  `QuantityDifference` decimal(16,6) DEFAULT NULL,
  `NewValue` decimal(16,6) DEFAULT NULL,
  `ValueDifference` decimal(16,6) DEFAULT NULL,
  `SerialNumberAddedOrRemoved` varchar(255) DEFAULT NULL,
  `InvSiteLocRef_ListID` varchar(36) DEFAULT NULL,
  `InvSiteLocRef_FullName` varchar(31) DEFAULT NULL,
  `InventoryAdjustmentLineType` varchar(255) DEFAULT NULL,
  `PARENT_IDKEY` varchar(36) DEFAULT NULL,
  `SeqNum` int DEFAULT NULL,
  `LSData` varchar(10) DEFAULT NULL,
  KEY `inventoryadjustmentlineretIdIndex` (`PARENT_IDKEY`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_0900_ai_ci;




CREATE TABLE `inventorysite` (
  `ListID` varchar(36) NOT NULL,
  `TimeCreated` datetime DEFAULT NULL,
  `TimeModified` datetime DEFAULT NULL,
  `EditSequence` varchar(16) DEFAULT NULL,
  `Name` varchar(31) DEFAULT NULL,
  `IsActive` varchar(5) DEFAULT NULL,
  `ParentSiteRef_ListID` varchar(36) DEFAULT NULL,
  `ParentSiteRef_FullName` varchar(31) DEFAULT NULL,
  `IsDefaultSite` varchar(5) DEFAULT NULL,
  `SiteDesc` varchar(100) DEFAULT NULL,
  `Contact` varchar(41) DEFAULT NULL,
  `Phone` varchar(255) DEFAULT NULL,
  `Fax` varchar(255) DEFAULT NULL,
  `Email` varchar(1000) DEFAULT NULL,
  `SiteAddress_Addr1` varchar(41) DEFAULT NULL,
  `SiteAddress_Addr2` varchar(41) DEFAULT NULL,
  `SiteAddress_Addr3` varchar(41) DEFAULT NULL,
  `SiteAddress_Addr4` varchar(41) DEFAULT NULL,
  `SiteAddress_Addr5` varchar(41) DEFAULT NULL,
  `SiteAddress_City` varchar(31) DEFAULT NULL,
  `SiteAddress_State` varchar(21) DEFAULT NULL,
  `SiteAddress_PostalCode` varchar(13) DEFAULT NULL,
  `SiteAddress_Country` varchar(31) DEFAULT NULL,
  `SiteAddressBlock_Addr1` varchar(41) DEFAULT NULL,
  `SiteAddressBlock_Addr2` varchar(41) DEFAULT NULL,
  `SiteAddressBlock_Addr3` varchar(41) DEFAULT NULL,
  `SiteAddressBlock_Addr4` varchar(41) DEFAULT NULL,
  `SiteAddressBlock_Addr5` varchar(41) DEFAULT NULL,
  `UserData` varchar(255) DEFAULT NULL,
  `Operation` varchar(10) DEFAULT NULL,
  `LSData` varchar(10) DEFAULT NULL,
  PRIMARY KEY (`ListID`),
  UNIQUE KEY `inventorysiteIdIndex` (`ListID`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_0900_ai_ci;




CREATE TABLE `invoice` (
  `TxnID` varchar(36) NOT NULL,
  `TimeCreated` datetime DEFAULT NULL,
  `TimeModified` datetime DEFAULT NULL,
  `EditSequence` varchar(16) DEFAULT NULL,
  `TxnNumber` int DEFAULT NULL,
  `CustomerRef_ListID` varchar(36) DEFAULT NULL,
  `CustomerRef_FullName` varchar(209) DEFAULT NULL,
  `ClassRef_ListID` varchar(36) DEFAULT NULL,
  `ClassRef_FullName` varchar(159) DEFAULT NULL,
  `ARAccountRef_ListID` varchar(36) DEFAULT NULL,
  `ARAccountRef_FullName` varchar(159) DEFAULT NULL,
  `TemplateRef_ListID` varchar(36) DEFAULT NULL,
  `TemplateRef_FullName` varchar(31) DEFAULT NULL,
  `TxnDate` datetime DEFAULT NULL,
  `RefNumber` varchar(25) DEFAULT NULL,
  `BillAddress_Addr1` varchar(41) DEFAULT NULL,
  `BillAddress_Addr2` varchar(41) DEFAULT NULL,
  `BillAddress_Addr3` varchar(41) DEFAULT NULL,
  `BillAddress_Addr4` varchar(41) DEFAULT NULL,
  `BillAddress_Addr5` varchar(41) DEFAULT NULL,
  `BillAddress_City` varchar(31) DEFAULT NULL,
  `BillAddress_State` varchar(21) DEFAULT NULL,
  `BillAddress_PostalCode` varchar(13) DEFAULT NULL,
  `BillAddress_Country` varchar(31) DEFAULT NULL,
  `BillAddress_Note` varchar(41) DEFAULT NULL,
  `ShipAddress_Addr1` varchar(41) DEFAULT NULL,
  `ShipAddress_Addr2` varchar(41) DEFAULT NULL,
  `ShipAddress_Addr3` varchar(41) DEFAULT NULL,
  `ShipAddress_Addr4` varchar(41) DEFAULT NULL,
  `ShipAddress_Addr5` varchar(41) DEFAULT NULL,
  `ShipAddress_City` varchar(31) DEFAULT NULL,
  `ShipAddress_State` varchar(21) DEFAULT NULL,
  `ShipAddress_PostalCode` varchar(13) DEFAULT NULL,
  `ShipAddress_Country` varchar(31) DEFAULT NULL,
  `ShipAddress_Note` varchar(41) DEFAULT NULL,
  `IsPending` varchar(5) DEFAULT NULL,
  `IsFinanceCharge` varchar(5) DEFAULT NULL,
  `PONumber` varchar(25) DEFAULT NULL,
  `TermsRef_ListID` varchar(36) DEFAULT NULL,
  `TermsRef_FullName` varchar(31) DEFAULT NULL,
  `DueDate` datetime DEFAULT NULL,
  `SalesRepRef_ListID` varchar(36) DEFAULT NULL,
  `SalesRepRef_FullName` varchar(5) DEFAULT NULL,
  `FOB` varchar(13) DEFAULT NULL,
  `ShipDate` datetime DEFAULT NULL,
  `ShipMethodRef_ListID` varchar(36) DEFAULT NULL,
  `ShipMethodRef_FullName` varchar(15) DEFAULT NULL,
  `Subtotal` decimal(16,6) DEFAULT NULL,
  `ItemSalesTaxRef_ListID` varchar(36) DEFAULT NULL,
  `ItemSalesTaxRef_FullName` varchar(31) DEFAULT NULL,
  `SalesTaxPercentage` decimal(16,6) DEFAULT NULL,
  `SalesTaxTotal` decimal(16,6) DEFAULT NULL,
  `AppliedAmount` decimal(15,2) DEFAULT NULL,
  `BalanceRemaining` decimal(15,2) DEFAULT NULL,
  `CurrencyRef_ListID` varchar(36) DEFAULT NULL,
  `CurrencyRef_FullName` varchar(64) DEFAULT NULL,
  `ExchangeRate` decimal(16,6) DEFAULT NULL,
  `BalRemainingInHomeCurrency` decimal(16,6) DEFAULT NULL,
  `Memo` varchar(1000) DEFAULT NULL,
  `IsPaid` varchar(5) DEFAULT NULL,
  `CustomerMsgRef_ListID` varchar(36) DEFAULT NULL,
  `CustomerMsgRef_FullName` varchar(101) DEFAULT NULL,
  `IsToBePrinted` varchar(5) DEFAULT NULL,
  `IsToBeEmailed` varchar(5) DEFAULT NULL,
  `IsTaxIncluded` varchar(5) DEFAULT NULL,
  `CustSalesTaxCodeRef_ListID` varchar(36) DEFAULT NULL,
  `CustSalesTaxCodeRef_FullName` varchar(3) DEFAULT NULL,
  `SuggestedDiscountAmount` decimal(15,2) DEFAULT NULL,
  `SuggestedDiscountDate` datetime DEFAULT NULL,
  `Other` varchar(29) DEFAULT NULL,
  `ExternalGUID` varchar(255) DEFAULT NULL,
  `CustomField1` varchar(255) DEFAULT NULL,
  `CustomField2` varchar(255) DEFAULT NULL,
  `CustomField3` varchar(255) DEFAULT NULL,
  `CustomField4` varchar(255) DEFAULT NULL,
  `CustomField5` varchar(255) DEFAULT NULL,
  `CustomField6` varchar(255) DEFAULT NULL,
  `CustomField7` varchar(255) DEFAULT NULL,
  `CustomField8` varchar(255) DEFAULT NULL,
  `CustomField9` varchar(255) DEFAULT NULL,
  `CustomField10` varchar(255) DEFAULT NULL,
  `CustomField11` varchar(255) DEFAULT NULL,
  `CustomField12` varchar(255) DEFAULT NULL,
  `CustomField13` varchar(255) DEFAULT NULL,
  `CustomField14` varchar(255) DEFAULT NULL,
  `CustomField15` varchar(255) DEFAULT NULL,
  `LSData` varchar(10) DEFAULT NULL,
  `Operation` varchar(10) DEFAULT NULL,
  `UserData` varchar(255) DEFAULT NULL,
  PRIMARY KEY (`TxnID`),
  UNIQUE KEY `invoiceIdIndex` (`TxnID`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_0900_ai_ci;




CREATE TABLE `invoicelinegroupret` (
  `TxnLineID` varchar(36) DEFAULT NULL,
  `ItemGroupRef_ListID` varchar(36) DEFAULT NULL,
  `ItemGroupRef_FullName` varchar(31) DEFAULT NULL,
  `Description` varchar(1000) DEFAULT NULL,
  `Quantity` decimal(16,6) DEFAULT NULL,
  `UnitOfMeasure` varchar(31) DEFAULT NULL,
  `OverrideUOMSetRef_ListID` varchar(36) DEFAULT NULL,
  `OverrideUOMSetRef_FullName` varchar(31) DEFAULT NULL,
  `IsPrintItemsInGroup` varchar(5) DEFAULT NULL,
  `TotalAmount` decimal(15,2) DEFAULT NULL,
  `CustomField1` varchar(50) DEFAULT NULL,
  `CustomField2` varchar(50) DEFAULT NULL,
  `CustomField3` varchar(50) DEFAULT NULL,
  `CustomField4` varchar(50) DEFAULT NULL,
  `CustomField5` varchar(50) DEFAULT NULL,
  `CustomField6` varchar(50) DEFAULT NULL,
  `CustomField7` varchar(50) DEFAULT NULL,
  `CustomField8` varchar(50) DEFAULT NULL,
  `CustomField9` varchar(50) DEFAULT NULL,
  `CustomField10` varchar(50) DEFAULT NULL,
  `CustomField11` varchar(50) DEFAULT NULL,
  `CustomField12` varchar(50) DEFAULT NULL,
  `CustomField13` varchar(50) DEFAULT NULL,
  `CustomField14` varchar(50) DEFAULT NULL,
  `CustomField15` varchar(50) DEFAULT NULL,
  `PARENT_IDKEY` varchar(36) DEFAULT NULL,
  `SeqNum` int DEFAULT NULL,
  `LSData` varchar(10) DEFAULT NULL,
  KEY `invoicelinegroupretIdIndex` (`PARENT_IDKEY`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_0900_ai_ci;




CREATE TABLE `invoicelineret` (
  `TxnLineID` varchar(36) DEFAULT NULL,
  `ItemRef_ListID` varchar(36) DEFAULT NULL,
  `ItemRef_FullName` varchar(209) DEFAULT NULL,
  `Description` varchar(1000) DEFAULT NULL,
  `Quantity` decimal(16,6) DEFAULT NULL,
  `UnitOfMeasure` varchar(31) DEFAULT NULL,
  `OverrideUOMSetRef_ListID` varchar(36) DEFAULT NULL,
  `OverrideUOMSetRef_FullName` varchar(31) DEFAULT NULL,
  `Rate` decimal(16,6) DEFAULT NULL,
  `RatePercent` decimal(16,6) DEFAULT NULL,
  `ClassRef_ListID` varchar(36) DEFAULT NULL,
  `ClassRef_FullName` varchar(159) DEFAULT NULL,
  `Amount` decimal(15,2) DEFAULT NULL,
  `TaxAmount` decimal(15,2) DEFAULT NULL,
  `InvSiteRef_ListID` varchar(36) DEFAULT NULL,
  `InvSiteRef_FullName` varchar(31) DEFAULT NULL,
  `InvSiteLocRef_ListID` varchar(36) DEFAULT NULL,
  `InvSiteLocRef_FullName` varchar(31) DEFAULT NULL,
  `SerialNumber` varchar(1000) DEFAULT NULL,
  `LotNumber` varchar(40) DEFAULT NULL,
  `ServiceDate` datetime DEFAULT NULL,
  `SalesTaxCodeRef_ListID` varchar(36) DEFAULT NULL,
  `SalesTaxCodeRef_FullName` varchar(3) DEFAULT NULL,
  `IsTaxable` varchar(5) DEFAULT NULL,
  `Other1` varchar(29) DEFAULT NULL,
  `Other2` varchar(29) DEFAULT NULL,
  `LinkToTxn_TxnID` varchar(36) DEFAULT NULL,
  `LinkToTxn_TxnLineID` varchar(36) DEFAULT NULL,
  `CustomField1` varchar(50) DEFAULT NULL,
  `CustomField2` varchar(50) DEFAULT NULL,
  `CustomField3` varchar(50) DEFAULT NULL,
  `CustomField4` varchar(50) DEFAULT NULL,
  `CustomField5` varchar(50) DEFAULT NULL,
  `CustomField6` varchar(50) DEFAULT NULL,
  `CustomField7` varchar(50) DEFAULT NULL,
  `CustomField8` varchar(50) DEFAULT NULL,
  `CustomField9` varchar(50) DEFAULT NULL,
  `CustomField10` varchar(50) DEFAULT NULL,
  `CustomField11` varchar(50) DEFAULT NULL,
  `CustomField12` varchar(50) DEFAULT NULL,
  `CustomField13` varchar(50) DEFAULT NULL,
  `CustomField14` varchar(50) DEFAULT NULL,
  `CustomField15` varchar(50) DEFAULT NULL,
  `PARENT_IDKEY` varchar(36) DEFAULT NULL,
  `GroupPARENT_IDKEY` varchar(255) DEFAULT NULL,
  `SeqNum` int DEFAULT NULL,
  `LSData` varchar(10) DEFAULT NULL,
  KEY `invoicelineretIdIndex` (`PARENT_IDKEY`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_0900_ai_ci;




CREATE TABLE `itemdiscount` (
  `ListID` varchar(36) NOT NULL,
  `TimeCreated` datetime DEFAULT NULL,
  `TimeModified` datetime DEFAULT NULL,
  `EditSequence` varchar(16) DEFAULT NULL,
  `Name` varchar(31) DEFAULT NULL,
  `FullName` varchar(159) DEFAULT NULL,
  `IsActive` varchar(5) DEFAULT NULL,
  `BarCodeValue` varchar(50) DEFAULT NULL,
  `AssignEvenIfUsed` varchar(5) DEFAULT NULL,
  `AllowOverride` varchar(5) DEFAULT NULL,
  `ParentRef_ListID` varchar(36) DEFAULT NULL,
  `ParentRef_FullName` varchar(209) DEFAULT NULL,
  `ClassRef_ListID` varchar(36) DEFAULT NULL,
  `ClassRef_FullName` varchar(159) DEFAULT NULL,
  `Sublevel` int DEFAULT NULL,
  `ItemDesc` varchar(1000) DEFAULT NULL,
  `SalesTaxCodeRef_ListID` varchar(36) DEFAULT NULL,
  `SalesTaxCodeRef_FullName` varchar(3) DEFAULT NULL,
  `DiscountRate` decimal(16,6) DEFAULT NULL,
  `DiscountRatePercent` decimal(16,6) DEFAULT NULL,
  `AccountRef_ListID` varchar(36) DEFAULT NULL,
  `AccountRef_FullName` varchar(159) DEFAULT NULL,
  `ApplyAccountRefToExistingTxns` varchar(5) DEFAULT NULL,
  `ExternalGUID` varchar(255) DEFAULT NULL,
  `CustomField1` varchar(255) DEFAULT NULL,
  `CustomField2` varchar(255) DEFAULT NULL,
  `CustomField3` varchar(255) DEFAULT NULL,
  `CustomField4` varchar(255) DEFAULT NULL,
  `CustomField5` varchar(255) DEFAULT NULL,
  `CustomField6` varchar(255) DEFAULT NULL,
  `CustomField7` varchar(255) DEFAULT NULL,
  `CustomField8` varchar(255) DEFAULT NULL,
  `CustomField9` varchar(255) DEFAULT NULL,
  `CustomField10` varchar(255) DEFAULT NULL,
  `CustomField11` varchar(255) DEFAULT NULL,
  `CustomField12` varchar(255) DEFAULT NULL,
  `CustomField13` varchar(255) DEFAULT NULL,
  `CustomField14` varchar(255) DEFAULT NULL,
  `CustomField15` varchar(255) DEFAULT NULL,
  `UserData` varchar(255) DEFAULT NULL,
  `Operation` varchar(10) DEFAULT NULL,
  `LSData` varchar(10) DEFAULT NULL,
  PRIMARY KEY (`ListID`),
  UNIQUE KEY `itemdiscountIdIndex` (`ListID`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_0900_ai_ci;




CREATE TABLE `itemfixedasset` (
  `ListID` varchar(36) NOT NULL,
  `TimeCreated` datetime DEFAULT NULL,
  `TimeModified` datetime DEFAULT NULL,
  `EditSequence` varchar(16) DEFAULT NULL,
  `Name` varchar(31) DEFAULT NULL,
  `BarCodeValue` varchar(50) DEFAULT NULL,
  `AssignEvenIfUsed` varchar(5) DEFAULT NULL,
  `AllowOverride` varchar(5) DEFAULT NULL,
  `IsActive` varchar(5) DEFAULT NULL,
  `AcquiredAs` varchar(255) DEFAULT NULL,
  `PurchaseDesc` varchar(50) DEFAULT NULL,
  `ClassRef_ListID` varchar(36) DEFAULT NULL,
  `ClassRef_FullName` varchar(159) DEFAULT NULL,
  `PurchaseDate` datetime DEFAULT NULL,
  `PurchaseCost` decimal(16,6) DEFAULT NULL,
  `VendorOrPayeeName` varchar(50) DEFAULT NULL,
  `AssetAccountRef_ListID` varchar(36) DEFAULT NULL,
  `AssetAccountRef_FullName` varchar(159) DEFAULT NULL,
  `FixedAssetSalesInfo_SalesDesc` varchar(50) DEFAULT NULL,
  `FixedAssetSalesInfo_SalesDate` datetime DEFAULT NULL,
  `FixedAssetSalesInfo_SalesPrice` decimal(16,6) DEFAULT NULL,
  `FixedAssetSalesInfo_SalesExpense` decimal(16,6) DEFAULT NULL,
  `AssetDesc` varchar(50) DEFAULT NULL,
  `Location` varchar(50) DEFAULT NULL,
  `PONumber` varchar(30) DEFAULT NULL,
  `SerialNumber` varchar(30) DEFAULT NULL,
  `WarrantyExpDate` datetime DEFAULT NULL,
  `Notes` varchar(1000) DEFAULT NULL,
  `AssetNumber` varchar(10) DEFAULT NULL,
  `CostBasis` decimal(15,2) DEFAULT NULL,
  `YearEndAccumulatedDepreciation` decimal(15,2) DEFAULT NULL,
  `YearEndBookValue` decimal(15,2) DEFAULT NULL,
  `ExternalGUID` varchar(255) DEFAULT NULL,
  `CustomField1` varchar(255) DEFAULT NULL,
  `CustomField2` varchar(255) DEFAULT NULL,
  `CustomField3` varchar(255) DEFAULT NULL,
  `CustomField4` varchar(255) DEFAULT NULL,
  `CustomField5` varchar(255) DEFAULT NULL,
  `CustomField6` varchar(255) DEFAULT NULL,
  `CustomField7` varchar(255) DEFAULT NULL,
  `CustomField8` varchar(255) DEFAULT NULL,
  `CustomField9` varchar(255) DEFAULT NULL,
  `CustomField10` varchar(255) DEFAULT NULL,
  `CustomField11` varchar(255) DEFAULT NULL,
  `CustomField12` varchar(255) DEFAULT NULL,
  `CustomField13` varchar(255) DEFAULT NULL,
  `CustomField14` varchar(255) DEFAULT NULL,
  `CustomField15` varchar(255) DEFAULT NULL,
  `LSData` varchar(10) DEFAULT NULL,
  `Operation` varchar(10) DEFAULT NULL,
  `UserData` varchar(255) DEFAULT NULL,
  PRIMARY KEY (`ListID`),
  UNIQUE KEY `itemfixedassetIdIndex` (`ListID`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_0900_ai_ci;





CREATE TABLE `itemgroup` (
  `ListID` varchar(36) NOT NULL,
  `TimeCreated` datetime DEFAULT NULL,
  `TimeModified` datetime DEFAULT NULL,
  `EditSequence` varchar(16) DEFAULT NULL,
  `Name` varchar(31) DEFAULT NULL,
  `IsActive` varchar(5) DEFAULT NULL,
  `BarCodeValue` varchar(50) DEFAULT NULL,
  `UnitOfMeasureSetRef_ListID` varchar(36) DEFAULT NULL,
  `UnitOfMeasureSetRef_FullName` varchar(31) DEFAULT NULL,
  `ItemDesc` varchar(1000) DEFAULT NULL,
  `IsPrintItemsInGroup` varchar(5) DEFAULT NULL,
  `SpecialItemType` varchar(255) DEFAULT NULL,
  `ExternalGUID` varchar(255) DEFAULT NULL,
  `CustomField1` varchar(50) DEFAULT NULL,
  `CustomField2` varchar(50) DEFAULT NULL,
  `CustomField3` varchar(50) DEFAULT NULL,
  `CustomField4` varchar(50) DEFAULT NULL,
  `CustomField5` varchar(50) DEFAULT NULL,
  `CustomField6` varchar(50) DEFAULT NULL,
  `CustomField7` varchar(50) DEFAULT NULL,
  `CustomField8` varchar(50) DEFAULT NULL,
  `CustomField9` varchar(50) DEFAULT NULL,
  `CustomField10` varchar(50) DEFAULT NULL,
  `CustomField11` varchar(50) DEFAULT NULL,
  `CustomField12` varchar(50) DEFAULT NULL,
  `CustomField13` varchar(50) DEFAULT NULL,
  `CustomField14` varchar(50) DEFAULT NULL,
  `CustomField15` varchar(50) DEFAULT NULL,
  `UserData` varchar(255) DEFAULT NULL,
  `Operation` varchar(10) DEFAULT NULL,
  `LSData` varchar(10) DEFAULT NULL,
  PRIMARY KEY (`ListID`),
  UNIQUE KEY `itemgroupIdIndex` (`ListID`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_0900_ai_ci;




CREATE TABLE `itemgrouplineret` (
  `TxnLineID` varchar(36) DEFAULT NULL,
  `ItemRef_ListID` varchar(36) DEFAULT NULL,
  `ItemRef_FullName` varchar(209) DEFAULT NULL,
  `ItemGroupRef_ListID` varchar(36) DEFAULT NULL,
  `ItemGroupRef_FullName` varchar(31) DEFAULT NULL,
  `Description` varchar(1000) DEFAULT NULL,
  `Quantity` decimal(16,6) DEFAULT NULL,
  `UnitOfMeasure` varchar(31) DEFAULT NULL,
  `OverrideUOMSetRef_ListID` varchar(36) DEFAULT NULL,
  `OverrideUOMSetRef_FullName` varchar(31) DEFAULT NULL,
  `TotalAmount` decimal(15,2) DEFAULT NULL,
  `CustomField1` varchar(255) DEFAULT NULL,
  `CustomField2` varchar(255) DEFAULT NULL,
  `CustomField3` varchar(255) DEFAULT NULL,
  `CustomField4` varchar(255) DEFAULT NULL,
  `CustomField5` varchar(255) DEFAULT NULL,
  `CustomField6` varchar(255) DEFAULT NULL,
  `CustomField7` varchar(255) DEFAULT NULL,
  `CustomField8` varchar(255) DEFAULT NULL,
  `CustomField9` varchar(255) DEFAULT NULL,
  `CustomField10` varchar(255) DEFAULT NULL,
  `CustomField11` varchar(255) DEFAULT NULL,
  `CustomField12` varchar(255) DEFAULT NULL,
  `CustomField13` varchar(255) DEFAULT NULL,
  `CustomField14` varchar(255) DEFAULT NULL,
  `CustomField15` varchar(255) DEFAULT NULL,
  `PARENT_IDKEY` varchar(36) DEFAULT NULL,
  `SeqNum` int DEFAULT NULL,
  `LSData` varchar(10) DEFAULT NULL,
  KEY `itemgrouplineretIdIndex` (`PARENT_IDKEY`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_0900_ai_ci;




CREATE TABLE `iteminventory` (
  `ListID` varchar(36) NOT NULL,
  `TimeCreated` datetime DEFAULT NULL,
  `TimeModified` datetime DEFAULT NULL,
  `EditSequence` varchar(16) DEFAULT NULL,
  `Name` varchar(31) DEFAULT NULL,
  `FullName` varchar(159) DEFAULT NULL,
  `BarCodeValue` varchar(50) DEFAULT NULL,
  `AssignEvenIfUsed` varchar(5) DEFAULT NULL,
  `AllowOverride` varchar(5) DEFAULT NULL,
  `IsActive` varchar(5) DEFAULT NULL,
  `ClassRef_ListID` varchar(36) DEFAULT NULL,
  `ClassRef_FullName` varchar(159) DEFAULT NULL,
  `ParentRef_ListID` varchar(36) DEFAULT NULL,
  `ParentRef_FullName` varchar(209) DEFAULT NULL,
  `Sublevel` int DEFAULT NULL,
  `ManufacturerPartNumber` varchar(31) DEFAULT NULL,
  `UnitOfMeasureSetRef_ListID` varchar(36) DEFAULT NULL,
  `UnitOfMeasureSetRef_FullName` varchar(31) DEFAULT NULL,
  `ForceUOMChange` varchar(5) DEFAULT NULL,
  `IsTaxIncluded` varchar(5) DEFAULT NULL,
  `SalesTaxCodeRef_ListID` varchar(36) DEFAULT NULL,
  `SalesTaxCodeRef_FullName` varchar(3) DEFAULT NULL,
  `SalesDesc` varchar(1000) DEFAULT NULL,
  `SalesPrice` decimal(16,6) DEFAULT NULL,
  `IncomeAccountRef_ListID` varchar(36) DEFAULT NULL,
  `IncomeAccountRef_FullName` varchar(159) DEFAULT NULL,
  `PurchaseDesc` varchar(1000) DEFAULT NULL,
  `PurchaseCost` decimal(16,6) DEFAULT NULL,
  `PurchaseTaxCodeRef_ListID` varchar(36) DEFAULT NULL,
  `PurchaseTaxCodeRef_FullName` varchar(3) DEFAULT NULL,
  `COGSAccountRef_ListID` varchar(36) DEFAULT NULL,
  `COGSAccountRef_FullName` varchar(159) DEFAULT NULL,
  `PrefVendorRef_ListID` varchar(36) DEFAULT NULL,
  `PrefVendorRef_FullName` varchar(41) DEFAULT NULL,
  `AssetAccountRef_ListID` varchar(36) DEFAULT NULL,
  `AssetAccountRef_FullName` varchar(159) DEFAULT NULL,
  `ReorderPoint` decimal(16,6) DEFAULT NULL,
  `Max` decimal(16,6) DEFAULT NULL,
  `QuantityOnHand` decimal(16,6) DEFAULT NULL,
  `AverageCost` decimal(16,6) DEFAULT NULL,
  `QuantityOnOrder` decimal(16,6) DEFAULT NULL,
  `QuantityOnSalesOrder` decimal(16,6) DEFAULT NULL,
  `ExternalGUID` varchar(255) DEFAULT NULL,
  `CustomField1` varchar(255) DEFAULT NULL,
  `CustomField2` varchar(255) DEFAULT NULL,
  `CustomField3` varchar(255) DEFAULT NULL,
  `CustomField4` varchar(255) DEFAULT NULL,
  `CustomField5` varchar(255) DEFAULT NULL,
  `CustomField6` varchar(255) DEFAULT NULL,
  `CustomField7` varchar(255) DEFAULT NULL,
  `CustomField8` varchar(255) DEFAULT NULL,
  `CustomField9` varchar(255) DEFAULT NULL,
  `CustomField10` varchar(255) DEFAULT NULL,
  `CustomField11` varchar(255) DEFAULT NULL,
  `CustomField12` varchar(255) DEFAULT NULL,
  `CustomField13` varchar(255) DEFAULT NULL,
  `CustomField14` varchar(255) DEFAULT NULL,
  `CustomField15` varchar(255) DEFAULT NULL,
  `UserData` varchar(255) DEFAULT NULL,
  `Operation` varchar(10) DEFAULT NULL,
  `LSData` varchar(10) DEFAULT NULL,
  PRIMARY KEY (`ListID`),
  UNIQUE KEY `iteminventoryIdIndex` (`ListID`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_0900_ai_ci;




CREATE TABLE `iteminventoryassembly` (
  `ListID` varchar(36) NOT NULL,
  `TimeCreated` datetime DEFAULT NULL,
  `TimeModified` datetime DEFAULT NULL,
  `EditSequence` varchar(16) DEFAULT NULL,
  `Name` varchar(31) DEFAULT NULL,
  `FullName` varchar(159) DEFAULT NULL,
  `IsActive` varchar(5) DEFAULT NULL,
  `ClassRef_ListID` varchar(36) DEFAULT NULL,
  `ClassRef_FullName` varchar(159) DEFAULT NULL,
  `ParentRef_ListID` varchar(36) DEFAULT NULL,
  `ParentRef_FullName` varchar(209) DEFAULT NULL,
  `Sublevel` int DEFAULT NULL,
  `SalesTaxCodeRef_ListID` varchar(36) DEFAULT NULL,
  `SalesTaxCodeRef_FullName` varchar(3) DEFAULT NULL,
  `UnitOfMeasureSetRef_ListID` varchar(36) DEFAULT NULL,
  `UnitOfMeasureSetRef_FullName` varchar(31) DEFAULT NULL,
  `ForceUOMChange` varchar(5) DEFAULT NULL,
  `ManufacturerPartNumber` varchar(31) DEFAULT NULL,
  `SalesDesc` varchar(1000) DEFAULT NULL,
  `SalesPrice` decimal(16,6) DEFAULT NULL,
  `IncomeAccountRef_ListID` varchar(36) DEFAULT NULL,
  `IncomeAccountRef_FullName` varchar(159) DEFAULT NULL,
  `PurchaseDesc` varchar(1000) DEFAULT NULL,
  `PurchaseCost` decimal(16,6) DEFAULT NULL,
  `PurchaseTaxCodeRef_ListID` varchar(36) DEFAULT NULL,
  `PurchaseTaxCodeRef_FullName` varchar(3) DEFAULT NULL,
  `IsTaxIncluded` varchar(5) DEFAULT NULL,
  `COGSAccountRef_ListID` varchar(36) DEFAULT NULL,
  `COGSAccountRef_FullName` varchar(159) DEFAULT NULL,
  `PrefVendorRef_ListID` varchar(36) DEFAULT NULL,
  `PrefVendorRef_FullName` varchar(41) DEFAULT NULL,
  `AssetAccountRef_ListID` varchar(36) DEFAULT NULL,
  `AssetAccountRef_FullName` varchar(159) DEFAULT NULL,
  `BuildPoint` decimal(16,6) DEFAULT NULL,
  `Max` decimal(16,6) DEFAULT NULL,
  `QuantityOnHand` decimal(16,6) DEFAULT NULL,
  `TotalValue` decimal(15,2) DEFAULT NULL,
  `InventoryDate` datetime DEFAULT NULL,
  `AverageCost` decimal(16,6) DEFAULT NULL,
  `QuantityOnOrder` decimal(16,6) DEFAULT NULL,
  `QuantityOnSalesOrder` decimal(16,6) DEFAULT NULL,
  `BarCodeValue` varchar(50) DEFAULT NULL,
  `AssignEvenIfUsed` varchar(5) DEFAULT NULL,
  `AllowOverride` varchar(5) DEFAULT NULL,
  `ClearItemsInGroup` varchar(5) DEFAULT NULL,
  `ExternalGUID` varchar(255) DEFAULT NULL,
  `CustomField1` varchar(255) DEFAULT NULL,
  `CustomField2` varchar(255) DEFAULT NULL,
  `CustomField3` varchar(255) DEFAULT NULL,
  `CustomField4` varchar(255) DEFAULT NULL,
  `CustomField5` varchar(255) DEFAULT NULL,
  `CustomField6` varchar(255) DEFAULT NULL,
  `CustomField7` varchar(255) DEFAULT NULL,
  `CustomField8` varchar(255) DEFAULT NULL,
  `CustomField9` varchar(255) DEFAULT NULL,
  `CustomField10` varchar(255) DEFAULT NULL,
  `CustomField11` varchar(255) DEFAULT NULL,
  `CustomField12` varchar(255) DEFAULT NULL,
  `CustomField13` varchar(255) DEFAULT NULL,
  `CustomField14` varchar(255) DEFAULT NULL,
  `CustomField15` varchar(255) DEFAULT NULL,
  `UserData` varchar(255) DEFAULT NULL,
  `Operation` varchar(10) DEFAULT NULL,
  `LSData` varchar(10) DEFAULT NULL,
  PRIMARY KEY (`ListID`),
  UNIQUE KEY `iteminventoryassemblyIdIndex` (`ListID`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_0900_ai_ci;



CREATE TABLE `iteminventoryassemblylineret` (
  `ItemInventoryRef_ListID` varchar(36) DEFAULT NULL,
  `ItemInventoryRef_FullName` varchar(159) DEFAULT NULL,
  `Quantity` decimal(16,6) DEFAULT NULL,
  `PARENT_IDKEY` varchar(36) DEFAULT NULL,
  `SeqNum` int DEFAULT NULL,
  `LSData` varchar(10) DEFAULT NULL,
  KEY `iteminventoryassemblylineretIdIndex` (`PARENT_IDKEY`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_0900_ai_ci;




CREATE TABLE `itemlineret` (
  `TxnLineID` varchar(36) DEFAULT NULL,
  `ItemRef_ListID` varchar(36) DEFAULT NULL,
  `ItemRef_FullName` varchar(209) DEFAULT NULL,
  `SalesRepRef_ListID` varchar(36) DEFAULT NULL,
  `SalesRepRef_FullName` varchar(5) DEFAULT NULL,
  `InvSiteRef_ListID` varchar(36) DEFAULT NULL,
  `InvSiteRef_FullName` varchar(31) DEFAULT NULL,
  `InvSiteLocRef_ListID` varchar(36) DEFAULT NULL,
  `InvSiteLocRef_FullName` varchar(31) DEFAULT NULL,
  `SerialNumber` varchar(1000) DEFAULT NULL,
  `LotNumber` varchar(40) DEFAULT NULL,
  `Description` varchar(1000) DEFAULT NULL,
  `Quantity` decimal(16,6) DEFAULT NULL,
  `OverrideUOMSetRef_ListID` varchar(36) DEFAULT NULL,
  `OverrideUOMSetRef_FullName` varchar(31) DEFAULT NULL,
  `UnitOfMeasure` varchar(31) DEFAULT NULL,
  `Cost` decimal(16,6) DEFAULT NULL,
  `Amount` decimal(15,2) DEFAULT NULL,
  `CustomerRef_ListID` varchar(36) DEFAULT NULL,
  `CustomerRef_FullName` varchar(209) DEFAULT NULL,
  `ClassRef_ListID` varchar(36) DEFAULT NULL,
  `ClassRef_FullName` varchar(159) DEFAULT NULL,
  `SalesTaxCodeRef_ListID` varchar(36) DEFAULT NULL,
  `SalesTaxCodeRef_FullName` varchar(3) DEFAULT NULL,
  `BillableStatus` varchar(255) DEFAULT NULL,
  `LinkedTxnID` varchar(36) DEFAULT NULL,
  `LinkedTxnLineID` varchar(36) DEFAULT NULL,
  `CustomField1` varchar(255) DEFAULT NULL,
  `CustomField2` varchar(255) DEFAULT NULL,
  `CustomField3` varchar(255) DEFAULT NULL,
  `CustomField4` varchar(255) DEFAULT NULL,
  `CustomField5` varchar(255) DEFAULT NULL,
  `CustomField6` varchar(255) DEFAULT NULL,
  `CustomField7` varchar(255) DEFAULT NULL,
  `CustomField8` varchar(255) DEFAULT NULL,
  `CustomField9` varchar(255) DEFAULT NULL,
  `CustomField10` varchar(255) DEFAULT NULL,
  `CustomField11` varchar(255) DEFAULT NULL,
  `CustomField12` varchar(255) DEFAULT NULL,
  `CustomField13` varchar(255) DEFAULT NULL,
  `CustomField14` varchar(255) DEFAULT NULL,
  `CustomField15` varchar(255) DEFAULT NULL,
  `PARENT_IDKEY` varchar(36) DEFAULT NULL,
  `GroupPARENT_IDKEY` varchar(255) DEFAULT NULL,
  `SeqNum` int DEFAULT NULL,
  `LSData` varchar(10) DEFAULT NULL,
  KEY `itemlineretIdIndex` (`PARENT_IDKEY`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_0900_ai_ci;




CREATE TABLE `itemnoninventory` (
  `ListID` varchar(36) NOT NULL,
  `TimeCreated` datetime DEFAULT NULL,
  `TimeModified` datetime DEFAULT NULL,
  `EditSequence` varchar(16) DEFAULT NULL,
  `Name` varchar(31) DEFAULT NULL,
  `FullName` varchar(159) DEFAULT NULL,
  `BarCodeValue` varchar(50) DEFAULT NULL,
  `AssignEvenIfUsed` varchar(5) DEFAULT NULL,
  `AllowOverride` varchar(5) DEFAULT NULL,
  `IsActive` varchar(5) DEFAULT NULL,
  `ClassRef_ListID` varchar(36) DEFAULT NULL,
  `ClassRef_FullName` varchar(159) DEFAULT NULL,
  `ParentRef_ListID` varchar(36) DEFAULT NULL,
  `ParentRef_FullName` varchar(209) DEFAULT NULL,
  `Sublevel` int DEFAULT NULL,
  `ManufacturerPartNumber` varchar(31) DEFAULT NULL,
  `UnitOfMeasureSetRef_ListID` varchar(36) DEFAULT NULL,
  `UnitOfMeasureSetRef_FullName` varchar(31) DEFAULT NULL,
  `IsTaxIncluded` varchar(5) DEFAULT NULL,
  `SalesTaxCodeRef_ListID` varchar(36) DEFAULT NULL,
  `SalesTaxCodeRef_FullName` varchar(3) DEFAULT NULL,
  `PurchaseTaxCodeRef_ListID` varchar(36) DEFAULT NULL,
  `PurchaseTaxCodeRef_FullName` varchar(3) DEFAULT NULL,
  `ExternalGUID` varchar(255) DEFAULT NULL,
  `CustomField1` varchar(255) DEFAULT NULL,
  `CustomField2` varchar(255) DEFAULT NULL,
  `CustomField3` varchar(255) DEFAULT NULL,
  `CustomField4` varchar(255) DEFAULT NULL,
  `CustomField5` varchar(255) DEFAULT NULL,
  `CustomField6` varchar(255) DEFAULT NULL,
  `CustomField7` varchar(255) DEFAULT NULL,
  `CustomField8` varchar(255) DEFAULT NULL,
  `CustomField9` varchar(255) DEFAULT NULL,
  `CustomField10` varchar(255) DEFAULT NULL,
  `CustomField11` varchar(255) DEFAULT NULL,
  `CustomField12` varchar(255) DEFAULT NULL,
  `CustomField13` varchar(255) DEFAULT NULL,
  `CustomField14` varchar(255) DEFAULT NULL,
  `CustomField15` varchar(255) DEFAULT NULL,
  `UserData` varchar(255) DEFAULT NULL,
  `Operation` varchar(10) DEFAULT NULL,
  `LSData` varchar(10) DEFAULT NULL,
  PRIMARY KEY (`ListID`),
  UNIQUE KEY `itemnoninventoryIdIndex` (`ListID`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_0900_ai_ci;




CREATE TABLE `itemothercharge` (
  `ListID` varchar(36) NOT NULL,
  `TimeCreated` datetime DEFAULT NULL,
  `TimeModified` datetime DEFAULT NULL,
  `EditSequence` varchar(16) DEFAULT NULL,
  `Name` varchar(31) DEFAULT NULL,
  `FullName` varchar(159) DEFAULT NULL,
  `BarCodeValue` varchar(50) DEFAULT NULL,
  `AssignEvenIfUsed` varchar(5) DEFAULT NULL,
  `AllowOverride` varchar(5) DEFAULT NULL,
  `IsActive` varchar(5) DEFAULT NULL,
  `ClassRef_ListID` varchar(36) DEFAULT NULL,
  `ClassRef_FullName` varchar(159) DEFAULT NULL,
  `ParentRef_ListID` varchar(36) DEFAULT NULL,
  `ParentRef_FullName` varchar(209) DEFAULT NULL,
  `Sublevel` int DEFAULT NULL,
  `IsTaxIncluded` varchar(5) DEFAULT NULL,
  `SalesTaxCodeRef_ListID` varchar(36) DEFAULT NULL,
  `SalesTaxCodeRef_FullName` varchar(3) DEFAULT NULL,
  `SpecialItemType` varchar(255) DEFAULT NULL,
  `ExternalGUID` varchar(255) DEFAULT NULL,
  `CustomField1` varchar(255) DEFAULT NULL,
  `CustomField2` varchar(255) DEFAULT NULL,
  `CustomField3` varchar(255) DEFAULT NULL,
  `CustomField4` varchar(255) DEFAULT NULL,
  `CustomField5` varchar(255) DEFAULT NULL,
  `CustomField6` varchar(255) DEFAULT NULL,
  `CustomField7` varchar(255) DEFAULT NULL,
  `CustomField8` varchar(255) DEFAULT NULL,
  `CustomField9` varchar(255) DEFAULT NULL,
  `CustomField10` varchar(255) DEFAULT NULL,
  `CustomField11` varchar(255) DEFAULT NULL,
  `CustomField12` varchar(255) DEFAULT NULL,
  `CustomField13` varchar(255) DEFAULT NULL,
  `CustomField14` varchar(255) DEFAULT NULL,
  `CustomField15` varchar(255) DEFAULT NULL,
  `UserData` varchar(255) DEFAULT NULL,
  `Operation` varchar(10) DEFAULT NULL,
  `LSData` varchar(10) DEFAULT NULL,
  PRIMARY KEY (`ListID`),
  UNIQUE KEY `itemotherchargeIdIndex` (`ListID`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_0900_ai_ci;




CREATE TABLE `itempayment` (
  `ListID` varchar(36) NOT NULL,
  `TimeCreated` datetime DEFAULT NULL,
  `TimeModified` datetime DEFAULT NULL,
  `EditSequence` varchar(16) DEFAULT NULL,
  `Name` varchar(31) DEFAULT NULL,
  `BarCodeValue` varchar(50) DEFAULT NULL,
  `IsActive` varchar(5) DEFAULT NULL,
  `ClassRef_ListID` varchar(36) DEFAULT NULL,
  `ClassRef_FullName` varchar(159) DEFAULT NULL,
  `ItemDesc` varchar(1000) DEFAULT NULL,
  `DepositToAccountRef_ListID` varchar(36) DEFAULT NULL,
  `DepositToAccountRef_FullName` varchar(159) DEFAULT NULL,
  `PaymentMethodRef_ListID` varchar(36) DEFAULT NULL,
  `PaymentMethodRef_FullName` varchar(31) DEFAULT NULL,
  `ExternalGUID` varchar(255) DEFAULT NULL,
  `CustomField1` varchar(255) DEFAULT NULL,
  `CustomField2` varchar(255) DEFAULT NULL,
  `CustomField3` varchar(255) DEFAULT NULL,
  `CustomField4` varchar(255) DEFAULT NULL,
  `CustomField5` varchar(255) DEFAULT NULL,
  `CustomField6` varchar(255) DEFAULT NULL,
  `CustomField7` varchar(255) DEFAULT NULL,
  `CustomField8` varchar(255) DEFAULT NULL,
  `CustomField9` varchar(255) DEFAULT NULL,
  `CustomField10` varchar(255) DEFAULT NULL,
  `CustomField11` varchar(255) DEFAULT NULL,
  `CustomField12` varchar(255) DEFAULT NULL,
  `CustomField13` varchar(255) DEFAULT NULL,
  `CustomField14` varchar(255) DEFAULT NULL,
  `CustomField15` varchar(255) DEFAULT NULL,
  `UserData` varchar(255) DEFAULT NULL,
  `Operation` varchar(10) DEFAULT NULL,
  `LSData` varchar(10) DEFAULT NULL,
  PRIMARY KEY (`ListID`),
  UNIQUE KEY `itempaymentIdIndex` (`ListID`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_0900_ai_ci;




CREATE TABLE `itemreceipt` (
  `TxnID` varchar(36) NOT NULL,
  `TimeCreated` datetime DEFAULT NULL,
  `TimeModified` datetime DEFAULT NULL,
  `EditSequence` varchar(16) DEFAULT NULL,
  `TxnNumber` int DEFAULT NULL,
  `VendorRef_ListID` varchar(36) DEFAULT NULL,
  `VendorRef_FullName` varchar(41) DEFAULT NULL,
  `APAccountRef_ListID` varchar(36) DEFAULT NULL,
  `APAccountRef_FullName` varchar(159) DEFAULT NULL,
  `TxnDate` datetime DEFAULT NULL,
  `TotalAmount` decimal(15,2) DEFAULT NULL,
  `CurrencyRef_ListID` varchar(36) DEFAULT NULL,
  `CurrencyRef_FullName` varchar(64) DEFAULT NULL,
  `LiabilityAccountRef_ListID` varchar(36) DEFAULT NULL,
  `LiabilityAccountRef_FullName` varchar(159) DEFAULT NULL,
  `ExchangeRate` decimal(16,6) DEFAULT NULL,
  `TotalAmountInHomeCurrency` decimal(15,2) DEFAULT NULL,
  `RefNumber` varchar(25) DEFAULT NULL,
  `Memo` varchar(1000) DEFAULT NULL,
  `IsTaxIncluded` varchar(5) DEFAULT NULL,
  `SalesTaxCodeRef_ListID` varchar(36) DEFAULT NULL,
  `SalesTaxCodeRef_FullName` varchar(3) DEFAULT NULL,
  `ExternalGUID` varchar(255) DEFAULT NULL,
  `CustomField1` varchar(255) DEFAULT NULL,
  `CustomField2` varchar(255) DEFAULT NULL,
  `CustomField3` varchar(255) DEFAULT NULL,
  `CustomField4` varchar(255) DEFAULT NULL,
  `CustomField5` varchar(255) DEFAULT NULL,
  `CustomField6` varchar(255) DEFAULT NULL,
  `CustomField7` varchar(255) DEFAULT NULL,
  `CustomField8` varchar(255) DEFAULT NULL,
  `CustomField9` varchar(255) DEFAULT NULL,
  `CustomField10` varchar(255) DEFAULT NULL,
  `CustomField11` varchar(255) DEFAULT NULL,
  `CustomField12` varchar(255) DEFAULT NULL,
  `CustomField13` varchar(255) DEFAULT NULL,
  `CustomField14` varchar(255) DEFAULT NULL,
  `CustomField15` varchar(255) DEFAULT NULL,
  `UserData` varchar(255) DEFAULT NULL,
  `Operation` varchar(10) DEFAULT NULL,
  `LSData` varchar(10) DEFAULT NULL,
  PRIMARY KEY (`TxnID`),
  UNIQUE KEY `itemreceiptIdIndex` (`TxnID`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_0900_ai_ci;



CREATE TABLE `items` (
  `ListID` varchar(36) NOT NULL,
  `FullName` varchar(200) DEFAULT NULL,
  `TableName` varchar(200) DEFAULT NULL,
  `BarCodeValue` varchar(50) DEFAULT NULL,
  `ExternalGUID` varchar(255) DEFAULT NULL,
  `UserData` varchar(255) DEFAULT NULL,
  `Operation` varchar(10) DEFAULT NULL,
  `LSData` varchar(10) DEFAULT NULL,
  PRIMARY KEY (`ListID`),
  UNIQUE KEY `itemsIdIndex` (`ListID`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_0900_ai_ci;




CREATE TABLE `itemsalestax` (
  `ListID` varchar(36) NOT NULL,
  `TimeCreated` datetime DEFAULT NULL,
  `TimeModified` datetime DEFAULT NULL,
  `EditSequence` varchar(16) DEFAULT NULL,
  `Name` varchar(31) DEFAULT NULL,
  `BarCodeValue` varchar(50) DEFAULT NULL,
  `IsActive` varchar(5) DEFAULT NULL,
  `ClassRef_ListID` varchar(36) DEFAULT NULL,
  `ClassRef_FullName` varchar(159) DEFAULT NULL,
  `ItemDesc` varchar(1000) DEFAULT NULL,
  `IsUsedOnPurchaseTransaction` varchar(5) DEFAULT NULL,
  `TaxRate` decimal(16,6) DEFAULT NULL,
  `TaxVendorRef_ListID` varchar(36) DEFAULT NULL,
  `TaxVendorRef_FullName` varchar(41) DEFAULT NULL,
  `SalesTaxReturnLineRef_ListID` varchar(36) DEFAULT NULL,
  `SalesTaxReturnLineRef_FullName` varchar(209) DEFAULT NULL,
  `ExternalGUID` varchar(255) DEFAULT NULL,
  `UserData` varchar(255) DEFAULT NULL,
  `Operation` varchar(10) DEFAULT NULL,
  `LSData` varchar(10) DEFAULT NULL,
  PRIMARY KEY (`ListID`),
  UNIQUE KEY `itemsalestaxIdIndex` (`ListID`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_0900_ai_ci;




CREATE TABLE `itemsalestaxgroup` (
  `ListID` varchar(36) NOT NULL,
  `TimeCreated` datetime DEFAULT NULL,
  `TimeModified` datetime DEFAULT NULL,
  `EditSequence` varchar(16) DEFAULT NULL,
  `Name` varchar(31) DEFAULT NULL,
  `BarCodeValue` varchar(50) DEFAULT NULL,
  `IsActive` varchar(5) DEFAULT NULL,
  `ItemDesc` varchar(1000) DEFAULT NULL,
  `ExternalGUID` varchar(255) DEFAULT NULL,
  `UserData` varchar(255) DEFAULT NULL,
  `Operation` varchar(10) DEFAULT NULL,
  `LSData` varchar(10) DEFAULT NULL,
  PRIMARY KEY (`ListID`),
  UNIQUE KEY `itemsalestaxgroupIdIndex` (`ListID`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_0900_ai_ci;



CREATE TABLE `itemsalestaxrefret` (
  `ItemSalesTaxRef_ListID` varchar(36) DEFAULT NULL,
  `ItemSalesTaxRef_FullName` varchar(31) DEFAULT NULL,
  `PARENT_IDKEY` varchar(36) DEFAULT NULL,
  `SeqNum` int DEFAULT NULL,
  `LSData` varchar(10) DEFAULT NULL,
  KEY `itemsalestaxrefretIdIndex` (`PARENT_IDKEY`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_0900_ai_ci;




CREATE TABLE `itemservice` (
  `ListID` varchar(36) NOT NULL,
  `TimeCreated` datetime DEFAULT NULL,
  `TimeModified` datetime DEFAULT NULL,
  `EditSequence` varchar(16) DEFAULT NULL,
  `Name` varchar(31) DEFAULT NULL,
  `FullName` varchar(159) DEFAULT NULL,
  `BarCodeValue` varchar(50) DEFAULT NULL,
  `AssignEvenIfUsed` varchar(5) DEFAULT NULL,
  `AllowOverride` varchar(5) DEFAULT NULL,
  `IsActive` varchar(5) DEFAULT NULL,
  `ClassRef_ListID` varchar(36) DEFAULT NULL,
  `ClassRef_FullName` varchar(159) DEFAULT NULL,
  `ParentRef_ListID` varchar(36) DEFAULT NULL,
  `ParentRef_FullName` varchar(209) DEFAULT NULL,
  `Sublevel` int DEFAULT NULL,
  `UnitOfMeasureSetRef_ListID` varchar(36) DEFAULT NULL,
  `UnitOfMeasureSetRef_FullName` varchar(31) DEFAULT NULL,
  `IsTaxIncluded` varchar(5) DEFAULT NULL,
  `SalesTaxCodeRef_ListID` varchar(36) DEFAULT NULL,
  `SalesTaxCodeRef_FullName` varchar(3) DEFAULT NULL,
  `ExternalGUID` varchar(255) DEFAULT NULL,
  `CustomField1` varchar(255) DEFAULT NULL,
  `CustomField2` varchar(255) DEFAULT NULL,
  `CustomField3` varchar(255) DEFAULT NULL,
  `CustomField4` varchar(255) DEFAULT NULL,
  `CustomField5` varchar(255) DEFAULT NULL,
  `CustomField6` varchar(255) DEFAULT NULL,
  `CustomField7` varchar(255) DEFAULT NULL,
  `CustomField8` varchar(255) DEFAULT NULL,
  `CustomField9` varchar(255) DEFAULT NULL,
  `CustomField10` varchar(255) DEFAULT NULL,
  `CustomField11` varchar(255) DEFAULT NULL,
  `CustomField12` varchar(255) DEFAULT NULL,
  `CustomField13` varchar(255) DEFAULT NULL,
  `CustomField14` varchar(255) DEFAULT NULL,
  `CustomField15` varchar(255) DEFAULT NULL,
  `UserData` varchar(255) DEFAULT NULL,
  `Operation` varchar(10) DEFAULT NULL,
  `LSData` varchar(10) DEFAULT NULL,
  PRIMARY KEY (`ListID`),
  UNIQUE KEY `itemserviceIdIndex` (`ListID`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_0900_ai_ci;




CREATE TABLE `itemsites` (
  `ListID` varchar(36) NOT NULL,
  `TimeCreated` datetime DEFAULT NULL,
  `TimeModified` datetime DEFAULT NULL,
  `EditSequence` varchar(16) DEFAULT NULL,
  `ItemInvAssemblyRef_ListID` varchar(36) DEFAULT NULL,
  `ItemInvAssemblyRef_FullName` varchar(159) DEFAULT NULL,
  `ItemInventoryRef_ListID` varchar(36) DEFAULT NULL,
  `ItemInventoryRef_FullName` varchar(159) DEFAULT NULL,
  `InvSiteRef_ListID` varchar(36) DEFAULT NULL,
  `InvSiteRef_FullName` varchar(31) DEFAULT NULL,
  `InvSiteLocRef_ListID` varchar(36) DEFAULT NULL,
  `InvSiteLocRef_FullName` varchar(31) DEFAULT NULL,
  `ReorderLevel` decimal(16,6) DEFAULT NULL,
  `QuantityOnHand` decimal(16,6) DEFAULT NULL,
  `QuantityOnPurchaseOrders` decimal(16,6) DEFAULT NULL,
  `QuantityOnSalesOrders` decimal(16,6) DEFAULT NULL,
  `QuantityToBeBuiltByPendingBuildTxns` decimal(16,6) DEFAULT NULL,
  `QuantityRequiredByPendingBuildTxns` decimal(16,6) DEFAULT NULL,
  `QuantityOnPendingTransfers` decimal(16,6) DEFAULT NULL,
  `AssemblyBuildPoint` decimal(16,6) DEFAULT NULL,
  `UserData` varchar(255) DEFAULT NULL,
  `Operation` varchar(10) DEFAULT NULL,
  `LSData` varchar(10) DEFAULT NULL,
  PRIMARY KEY (`ListID`),
  UNIQUE KEY `itemsitesIdIndex` (`ListID`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_0900_ai_ci;




CREATE TABLE `itemsubtotal` (
  `ListID` varchar(36) NOT NULL,
  `TimeCreated` datetime DEFAULT NULL,
  `TimeModified` datetime DEFAULT NULL,
  `EditSequence` varchar(16) DEFAULT NULL,
  `Name` varchar(31) DEFAULT NULL,
  `BarCodeValue` varchar(50) DEFAULT NULL,
  `IsActive` varchar(5) DEFAULT NULL,
  `ItemDesc` varchar(1000) DEFAULT NULL,
  `SpecialItemType` varchar(255) DEFAULT NULL,
  `ExternalGUID` varchar(255) DEFAULT NULL,
  `UserData` varchar(255) DEFAULT NULL,
  `Operation` varchar(10) DEFAULT NULL,
  `LSData` varchar(10) DEFAULT NULL,
  PRIMARY KEY (`ListID`),
  UNIQUE KEY `itemsubtotalIdIndex` (`ListID`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_0900_ai_ci;




CREATE TABLE `jobtype` (
  `ListID` varchar(36) NOT NULL,
  `TimeCreated` datetime DEFAULT NULL,
  `TimeModified` datetime DEFAULT NULL,
  `EditSequence` varchar(16) DEFAULT NULL,
  `Name` varchar(31) DEFAULT NULL,
  `FullName` varchar(159) DEFAULT NULL,
  `IsActive` varchar(5) DEFAULT NULL,
  `ParentRef_ListID` varchar(36) DEFAULT NULL,
  `ParentRef_FullName` varchar(209) DEFAULT NULL,
  `Sublevel` int DEFAULT NULL,
  `UserData` varchar(255) DEFAULT NULL,
  `Operation` varchar(10) DEFAULT NULL,
  `LSData` varchar(10) DEFAULT NULL,
  PRIMARY KEY (`ListID`),
  UNIQUE KEY `jobtypeIdIndex` (`ListID`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_0900_ai_ci;




CREATE TABLE `journalcreditlineret` (
  `TxnLineID` varchar(36) DEFAULT NULL,
  `AccountRef_ListID` varchar(36) DEFAULT NULL,
  `AccountRef_FullName` varchar(159) DEFAULT NULL,
  `Amount` decimal(15,2) DEFAULT NULL,
  `Memo` varchar(1000) DEFAULT NULL,
  `IsAdjustment` varchar(5) DEFAULT NULL,
  `EntityRef_ListID` varchar(36) DEFAULT NULL,
  `EntityRef_FullName` varchar(209) DEFAULT NULL,
  `ClassRef_ListID` varchar(36) DEFAULT NULL,
  `ClassRef_FullName` varchar(159) DEFAULT NULL,
  `ItemSalesTaxRef_ListID` varchar(36) DEFAULT NULL,
  `ItemSalesTaxRef_FullName` varchar(159) DEFAULT NULL,
  `BillableStatus` varchar(255) DEFAULT NULL,
  `PARENT_IDKEY` varchar(36) DEFAULT NULL,
  `LSData` varchar(10) DEFAULT NULL,
  KEY `journalcreditlineretIdIndex` (`PARENT_IDKEY`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_0900_ai_ci;





CREATE TABLE `journaldebitlineret` (
  `TxnLineID` varchar(36) DEFAULT NULL,
  `AccountRef_ListID` varchar(36) DEFAULT NULL,
  `AccountRef_FullName` varchar(159) DEFAULT NULL,
  `Amount` decimal(15,2) DEFAULT NULL,
  `Memo` varchar(1000) DEFAULT NULL,
  `EntityRef_ListID` varchar(36) DEFAULT NULL,
  `EntityRef_FullName` varchar(209) DEFAULT NULL,
  `ClassRef_ListID` varchar(36) DEFAULT NULL,
  `ClassRef_FullName` varchar(159) DEFAULT NULL,
  `ItemSalesTaxRef_ListID` varchar(36) DEFAULT NULL,
  `ItemSalesTaxRef_FullName` varchar(31) DEFAULT NULL,
  `BillableStatus` varchar(255) DEFAULT NULL,
  `PARENT_IDKEY` varchar(36) DEFAULT NULL,
  `LSData` varchar(10) DEFAULT NULL,
  KEY `journaldebitlineretIdIndex` (`PARENT_IDKEY`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_0900_ai_ci;




CREATE TABLE `journalentry` (
  `TxnID` varchar(36) NOT NULL,
  `TimeCreated` datetime DEFAULT NULL,
  `TimeModified` datetime DEFAULT NULL,
  `EditSequence` varchar(16) DEFAULT NULL,
  `TxnNumber` int DEFAULT NULL,
  `TxnDate` datetime DEFAULT NULL,
  `RefNumber` varchar(25) DEFAULT NULL,
  `Memo` varchar(1000) DEFAULT NULL,
  `IsAdjustment` varchar(5) DEFAULT NULL,
  `IsHomeCurrencyAdjustment` varchar(5) DEFAULT NULL,
  `IsAmountsEnteredInHomeCurrency` varchar(5) DEFAULT NULL,
  `CurrencyRef_ListID` varchar(36) DEFAULT NULL,
  `CurrencyRef_FullName` varchar(64) DEFAULT NULL,
  `ExchangeRate` decimal(16,6) DEFAULT NULL,
  `ExternalGUID` varchar(255) DEFAULT NULL,
  `UserData` varchar(255) DEFAULT NULL,
  `Operation` varchar(10) DEFAULT NULL,
  `LSData` varchar(10) DEFAULT NULL,
  PRIMARY KEY (`TxnID`),
  UNIQUE KEY `journalentryIdIndex` (`TxnID`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_0900_ai_ci;




CREATE TABLE `linkedtxnret` (
  `TxnID` varchar(36) NOT NULL,
  `TxnType` varchar(255) DEFAULT NULL,
  `TxnDate` datetime DEFAULT NULL,
  `RefNumber` varchar(25) DEFAULT NULL,
  `LinkType` varchar(255) DEFAULT NULL,
  `Amount` decimal(15,2) DEFAULT NULL,
  `PARENT_IDKEY` varchar(36) DEFAULT NULL,
  `SeqNum` int DEFAULT NULL,
  `LSData` varchar(10) DEFAULT NULL,
  KEY `linkedtxnretIdIndex` (`PARENT_IDKEY`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_0900_ai_ci;




CREATE TABLE `othername` (
  `ListID` varchar(36) NOT NULL,
  `TimeCreated` datetime DEFAULT NULL,
  `TimeModified` datetime DEFAULT NULL,
  `EditSequence` varchar(16) DEFAULT NULL,
  `Name` varchar(41) DEFAULT NULL,
  `IsActive` varchar(5) DEFAULT NULL,
  `CompanyName` varchar(41) DEFAULT NULL,
  `Salutation` varchar(15) DEFAULT NULL,
  `FirstName` varchar(25) DEFAULT NULL,
  `MiddleName` varchar(5) DEFAULT NULL,
  `LastName` varchar(25) DEFAULT NULL,
  `Suffix` varchar(255) DEFAULT NULL,
  `OtherNameAddress_Addr1` varchar(41) DEFAULT NULL,
  `OtherNameAddress_Addr2` varchar(41) DEFAULT NULL,
  `OtherNameAddress_Addr3` varchar(41) DEFAULT NULL,
  `OtherNameAddress_Addr4` varchar(41) DEFAULT NULL,
  `OtherNameAddress_Addr5` varchar(41) DEFAULT NULL,
  `OtherNameAddress_City` varchar(31) DEFAULT NULL,
  `OtherNameAddress_State` varchar(21) DEFAULT NULL,
  `OtherNameAddress_PostalCode` varchar(13) DEFAULT NULL,
  `OtherNameAddress_Country` varchar(31) DEFAULT NULL,
  `OtherNameAddress_Note` varchar(41) DEFAULT NULL,
  `Phone` varchar(255) DEFAULT NULL,
  `Mobile` varchar(255) DEFAULT NULL,
  `Pager` varchar(10) DEFAULT NULL,
  `AltPhone` varchar(255) DEFAULT NULL,
  `Fax` varchar(255) DEFAULT NULL,
  `Email` varchar(1000) DEFAULT NULL,
  `Contact` varchar(41) DEFAULT NULL,
  `AltContact` varchar(41) DEFAULT NULL,
  `AccountNumber` varchar(99) DEFAULT NULL,
  `Notes` varchar(1000) DEFAULT NULL,
  `ExternalGUID` varchar(255) DEFAULT NULL,
  `UserData` varchar(255) DEFAULT NULL,
  `Operation` varchar(10) DEFAULT NULL,
  `LSData` varchar(10) DEFAULT NULL,
  PRIMARY KEY (`ListID`),
  UNIQUE KEY `othernameIdIndex` (`ListID`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_0900_ai_ci;




CREATE TABLE `paymentlineret` (
  `TxnID` varchar(36) NOT NULL,
  `TxnType` varchar(255) DEFAULT NULL,
  `TxnDate` datetime DEFAULT NULL,
  `RefNumber` varchar(25) DEFAULT NULL,
  `TotalAmount` decimal(15,2) DEFAULT NULL,
  `AppliedAmount` decimal(15,2) DEFAULT NULL,
  `PARENT_IDKEY` varchar(36) DEFAULT NULL,
  `GroupPARENT_IDKEY` varchar(255) DEFAULT NULL,
  `SeqNum` int DEFAULT NULL,
  `LSData` varchar(10) DEFAULT NULL,
  KEY `paymentlineretIdIndex` (`PARENT_IDKEY`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_0900_ai_ci;




CREATE TABLE `paymentmethod` (
  `ListID` varchar(36) NOT NULL,
  `TimeCreated` datetime DEFAULT NULL,
  `TimeModified` datetime DEFAULT NULL,
  `EditSequence` varchar(116) DEFAULT NULL,
  `Name` varchar(31) DEFAULT NULL,
  `IsActive` varchar(5) DEFAULT NULL,
  `PaymentMethodType` varchar(255) DEFAULT NULL,
  `UserData` varchar(255) DEFAULT NULL,
  `Operation` varchar(10) DEFAULT NULL,
  `LSData` varchar(10) DEFAULT NULL,
  PRIMARY KEY (`ListID`),
  UNIQUE KEY `paymentmethodIdIndex` (`ListID`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_0900_ai_ci;



CREATE TABLE `payrollitemnonwage` (
  `ListID` varchar(36) NOT NULL,
  `TimeCreated` datetime DEFAULT NULL,
  `TimeModified` datetime DEFAULT NULL,
  `EditSequence` varchar(16) DEFAULT NULL,
  `Name` varchar(31) DEFAULT NULL,
  `IsActive` varchar(5) DEFAULT NULL,
  `NonWageType` varchar(255) DEFAULT NULL,
  `ExpenseAccountRef_ListID` varchar(36) DEFAULT NULL,
  `ExpenseAccountRef_FullName` varchar(159) DEFAULT NULL,
  `LiabilityAccountRef_ListID` varchar(36) DEFAULT NULL,
  `LiabilityAccountRef_FullName` varchar(159) DEFAULT NULL,
  `UserData` varchar(255) DEFAULT NULL,
  `Operation` varchar(10) DEFAULT NULL,
  `LSData` varchar(10) DEFAULT NULL,
  PRIMARY KEY (`ListID`),
  UNIQUE KEY `payrollitemnonwageIdIndex` (`ListID`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_0900_ai_ci;




CREATE TABLE `payrollitemwage` (
  `ListID` varchar(36) NOT NULL,
  `TimeCreated` datetime DEFAULT NULL,
  `TimeModified` datetime DEFAULT NULL,
  `EditSequence` varchar(16) DEFAULT NULL,
  `Name` varchar(31) DEFAULT NULL,
  `IsActive` varchar(5) DEFAULT NULL,
  `WageType` varchar(255) DEFAULT NULL,
  `ExpenseAccountRef_ListID` varchar(36) DEFAULT NULL,
  `ExpenseAccountRef_FullName` varchar(159) DEFAULT NULL,
  `UserData` varchar(255) DEFAULT NULL,
  `Operation` varchar(10) DEFAULT NULL,
  `LSData` varchar(10) DEFAULT NULL,
  PRIMARY KEY (`ListID`),
  UNIQUE KEY `payrollitemwageIdIndex` (`ListID`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_0900_ai_ci;




CREATE TABLE `prefillaccountret` (
  `ListID` varchar(36) NOT NULL,
  `FullName` varchar(159) DEFAULT NULL,
  `PARENT_IDKEY` varchar(36) DEFAULT NULL,
  `SeqNum` int DEFAULT NULL,
  `LSData` varchar(10) DEFAULT NULL,
  KEY `prefillaccountretIdIndex` (`PARENT_IDKEY`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_0900_ai_ci;




CREATE TABLE `pricelevel` (
  `ListID` varchar(36) NOT NULL,
  `TimeCreated` datetime DEFAULT NULL,
  `TimeModified` datetime DEFAULT NULL,
  `EditSequence` varchar(16) DEFAULT NULL,
  `Name` varchar(31) DEFAULT NULL,
  `IsActive` varchar(5) DEFAULT NULL,
  `PriceLevelType` varchar(36) DEFAULT NULL,
  `PriceLevelFixedPercentage` decimal(16,6) DEFAULT NULL,
  `CurrencyRef_ListID` varchar(36) DEFAULT NULL,
  `CurrencyRef_FullName` varchar(64) DEFAULT NULL,
  `UserData` varchar(255) DEFAULT NULL,
  `Operation` varchar(10) DEFAULT NULL,
  `LSData` varchar(10) DEFAULT NULL,
  PRIMARY KEY (`ListID`),
  UNIQUE KEY `pricelevelIdIndex` (`ListID`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_0900_ai_ci;




CREATE TABLE `pricelevelperitemret` (
  `ItemRef_ListID` varchar(36) DEFAULT NULL,
  `ItemRef_FullName` varchar(36) DEFAULT NULL,
  `CustomPrice` decimal(16,6) DEFAULT NULL,
  `CustomPricePercent` decimal(16,6) DEFAULT NULL,
  `AdjustPercentage` decimal(16,6) DEFAULT NULL,
  `AdjustRelativeTo` varchar(255) DEFAULT NULL,
  `PARENT_IDKEY` varchar(36) DEFAULT NULL,
  `SeqNum` int DEFAULT NULL,
  `LSData` varchar(10) DEFAULT NULL,
  KEY `pricelevelperitemretIdIndex` (`PARENT_IDKEY`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_0900_ai_ci;




CREATE TABLE `purchaseorder` (
  `TxnID` varchar(36) NOT NULL,
  `TimeCreated` datetime DEFAULT NULL,
  `TimeModified` datetime DEFAULT NULL,
  `EditSequence` varchar(16) DEFAULT NULL,
  `TxnNumber` int DEFAULT NULL,
  `VendorRef_ListID` varchar(36) DEFAULT NULL,
  `VendorRef_FullName` varchar(41) DEFAULT NULL,
  `ClassRef_ListID` varchar(36) DEFAULT NULL,
  `ClassRef_FullName` varchar(159) DEFAULT NULL,
  `InvSiteRef_ListID` varchar(36) DEFAULT NULL,
  `InvSiteRef_FullName` varchar(31) DEFAULT NULL,
  `InvSiteLocRef_ListID` varchar(36) DEFAULT NULL,
  `InvSiteLocRef_FullName` varchar(209) DEFAULT NULL,
  `ShipToEntityRef_ListID` varchar(36) DEFAULT NULL,
  `ShipToEntityRef_FullName` varchar(209) DEFAULT NULL,
  `TemplateRef_ListID` varchar(36) DEFAULT NULL,
  `TemplateRef_FullName` varchar(31) DEFAULT NULL,
  `TxnDate` datetime DEFAULT NULL,
  `RefNumber` varchar(25) DEFAULT NULL,
  `VendorAddress_Addr1` varchar(41) DEFAULT NULL,
  `VendorAddress_Addr2` varchar(41) DEFAULT NULL,
  `VendorAddress_Addr3` varchar(41) DEFAULT NULL,
  `VendorAddress_Addr4` varchar(41) DEFAULT NULL,
  `VendorAddress_Addr5` varchar(41) DEFAULT NULL,
  `VendorAddress_City` varchar(31) DEFAULT NULL,
  `VendorAddress_State` varchar(21) DEFAULT NULL,
  `VendorAddress_PostalCode` varchar(13) DEFAULT NULL,
  `VendorAddress_Country` varchar(31) DEFAULT NULL,
  `VendorAddress_Note` varchar(41) DEFAULT NULL,
  `ShipAddress_Addr1` varchar(41) DEFAULT NULL,
  `ShipAddress_Addr2` varchar(41) DEFAULT NULL,
  `ShipAddress_Addr3` varchar(41) DEFAULT NULL,
  `ShipAddress_Addr4` varchar(41) DEFAULT NULL,
  `ShipAddress_Addr5` varchar(41) DEFAULT NULL,
  `ShipAddress_City` varchar(31) DEFAULT NULL,
  `ShipAddress_State` varchar(21) DEFAULT NULL,
  `ShipAddress_PostalCode` varchar(13) DEFAULT NULL,
  `ShipAddress_Country` varchar(31) DEFAULT NULL,
  `ShipAddress_Note` varchar(41) DEFAULT NULL,
  `TermsRef_ListID` varchar(36) DEFAULT NULL,
  `TermsRef_FullName` varchar(31) DEFAULT NULL,
  `DueDate` datetime DEFAULT NULL,
  `ExpectedDate` datetime DEFAULT NULL,
  `ShipMethodRef_ListID` varchar(36) DEFAULT NULL,
  `ShipMethodRef_FullName` varchar(15) DEFAULT NULL,
  `FOB` varchar(13) DEFAULT NULL,
  `TotalAmount` decimal(15,2) DEFAULT NULL,
  `CurrencyRef_ListID` varchar(36) DEFAULT NULL,
  `CurrencyRef_FullName` varchar(64) DEFAULT NULL,
  `ExchangeRate` decimal(16,6) DEFAULT NULL,
  `TotalAmountInHomeCurrency` decimal(15,2) DEFAULT NULL,
  `Memo` varchar(1000) DEFAULT NULL,
  `VendorMsg` varchar(99) DEFAULT NULL,
  `IsToBePrinted` varchar(5) DEFAULT NULL,
  `IsToBeEmailed` varchar(5) DEFAULT NULL,
  `IsTaxIncluded` varchar(5) DEFAULT NULL,
  `SalesTaxCodeRef_ListID` varchar(36) DEFAULT NULL,
  `SalesTaxCodeRef_FullName` varchar(3) DEFAULT NULL,
  `Other1` varchar(25) DEFAULT NULL,
  `Other2` varchar(29) DEFAULT NULL,
  `IsManuallyClosed` varchar(5) DEFAULT NULL,
  `IsFullyReceived` varchar(5) DEFAULT NULL,
  `ExternalGUID` varchar(255) DEFAULT NULL,
  `CustomField1` varchar(255) DEFAULT NULL,
  `CustomField2` varchar(255) DEFAULT NULL,
  `CustomField3` varchar(255) DEFAULT NULL,
  `CustomField4` varchar(255) DEFAULT NULL,
  `CustomField5` varchar(255) DEFAULT NULL,
  `CustomField6` varchar(255) DEFAULT NULL,
  `CustomField7` varchar(255) DEFAULT NULL,
  `CustomField8` varchar(255) DEFAULT NULL,
  `CustomField9` varchar(255) DEFAULT NULL,
  `CustomField10` varchar(255) DEFAULT NULL,
  `CustomField11` varchar(255) DEFAULT NULL,
  `CustomField12` varchar(255) DEFAULT NULL,
  `CustomField13` varchar(255) DEFAULT NULL,
  `CustomField14` varchar(255) DEFAULT NULL,
  `CustomField15` varchar(255) DEFAULT NULL,
  `UserData` varchar(255) DEFAULT NULL,
  `Operation` varchar(10) DEFAULT NULL,
  `LSData` varchar(10) DEFAULT NULL,
  PRIMARY KEY (`TxnID`),
  UNIQUE KEY `purchaseorderIdIndex` (`TxnID`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_0900_ai_ci;




CREATE TABLE `purchaseorderlinegroupret` (
  `TxnLineID` varchar(36) DEFAULT NULL,
  `ItemGroupRef_ListID` varchar(36) DEFAULT NULL,
  `ItemGroupRef_FullName` varchar(31) DEFAULT NULL,
  `Description` varchar(1000) DEFAULT NULL,
  `Quantity` decimal(16,6) DEFAULT NULL,
  `IsPrintItemsInGroup` varchar(5) DEFAULT NULL,
  `TotalAmount` decimal(15,2) DEFAULT NULL,
  `ServiceDate` datetime DEFAULT NULL,
  `CustomField1` varchar(255) DEFAULT NULL,
  `CustomField2` varchar(255) DEFAULT NULL,
  `CustomField3` varchar(255) DEFAULT NULL,
  `CustomField4` varchar(255) DEFAULT NULL,
  `CustomField5` varchar(255) DEFAULT NULL,
  `CustomField6` varchar(255) DEFAULT NULL,
  `CustomField7` varchar(255) DEFAULT NULL,
  `CustomField8` varchar(255) DEFAULT NULL,
  `CustomField9` varchar(255) DEFAULT NULL,
  `CustomField10` varchar(255) DEFAULT NULL,
  `CustomField11` varchar(255) DEFAULT NULL,
  `CustomField12` varchar(255) DEFAULT NULL,
  `CustomField13` varchar(255) DEFAULT NULL,
  `CustomField14` varchar(255) DEFAULT NULL,
  `CustomField15` varchar(255) DEFAULT NULL,
  `PARENT_IDKEY` varchar(36) DEFAULT NULL,
  `GroupPARENT_IDKEY` varchar(255) DEFAULT NULL,
  `SeqNum` int DEFAULT NULL,
  `LSData` varchar(10) DEFAULT NULL,
  KEY `purchaseorderlinegroupretIdIndex` (`PARENT_IDKEY`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_0900_ai_ci;




CREATE TABLE `purchaseorderlineret` (
  `TxnLineID` varchar(36) DEFAULT NULL,
  `ItemRef_ListID` varchar(36) DEFAULT NULL,
  `ItemRef_FullName` varchar(209) DEFAULT NULL,
  `ManufacturerPartNumber` varchar(31) DEFAULT NULL,
  `Description` varchar(1000) DEFAULT NULL,
  `Quantity` decimal(16,6) DEFAULT NULL,
  `UnitOfMeasure` varchar(31) DEFAULT NULL,
  `OverrideUOMSetRef_ListID` varchar(36) DEFAULT NULL,
  `OverrideUOMSetRef_FullName` varchar(31) DEFAULT NULL,
  `Rate` decimal(16,6) DEFAULT NULL,
  `ClassRef_ListID` varchar(36) DEFAULT NULL,
  `ClassRef_FullName` varchar(159) DEFAULT NULL,
  `Amount` decimal(15,2) DEFAULT NULL,
  `CustomerRef_ListID` varchar(36) DEFAULT NULL,
  `CustomerRef_FullName` varchar(209) DEFAULT NULL,
  `ServiceDate` datetime DEFAULT NULL,
  `SalesTaxCodeRef_ListID` varchar(36) DEFAULT NULL,
  `SalesTaxCodeRef_FullName` varchar(3) DEFAULT NULL,
  `ReceivedQuantity` decimal(16,6) DEFAULT NULL,
  `IsBilled` varchar(5) DEFAULT NULL,
  `Other1` varchar(29) DEFAULT NULL,
  `Other2` varchar(29) DEFAULT NULL,
  `IsManuallyClosed` varchar(5) DEFAULT NULL,
  `UnbilledQuantity` decimal(16,6) DEFAULT NULL,
  `InvSiteLocRef_ListID` varchar(36) DEFAULT NULL,
  `InvSiteLocRef_FullName` varchar(31) DEFAULT NULL,
  `CustomField1` varchar(255) DEFAULT NULL,
  `CustomField2` varchar(255) DEFAULT NULL,
  `CustomField3` varchar(255) DEFAULT NULL,
  `CustomField4` varchar(255) DEFAULT NULL,
  `CustomField5` varchar(255) DEFAULT NULL,
  `CustomField6` varchar(255) DEFAULT NULL,
  `CustomField7` varchar(255) DEFAULT NULL,
  `CustomField8` varchar(255) DEFAULT NULL,
  `CustomField9` varchar(255) DEFAULT NULL,
  `CustomField10` varchar(255) DEFAULT NULL,
  `CustomField11` varchar(255) DEFAULT NULL,
  `CustomField12` varchar(255) DEFAULT NULL,
  `CustomField13` varchar(255) DEFAULT NULL,
  `CustomField14` varchar(255) DEFAULT NULL,
  `CustomField15` varchar(255) DEFAULT NULL,
  `PARENT_IDKEY` varchar(36) DEFAULT NULL,
  `GroupPARENT_IDKEY` varchar(255) DEFAULT NULL,
  `SeqNum` int DEFAULT NULL,
  `LSData` varchar(10) DEFAULT NULL,
  KEY `purchaseorderlineretIdIndex` (`PARENT_IDKEY`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_0900_ai_ci;




CREATE TABLE `receivepayment` (
  `TxnID` varchar(36) NOT NULL,
  `TimeCreated` datetime DEFAULT NULL,
  `TimeModified` datetime DEFAULT NULL,
  `EditSequence` varchar(16) DEFAULT NULL,
  `TxnNumber` int DEFAULT NULL,
  `CustomerRef_ListID` varchar(36) DEFAULT NULL,
  `CustomerRef_FullName` varchar(209) DEFAULT NULL,
  `ARAccountRef_ListID` varchar(36) DEFAULT NULL,
  `ARAccountRef_FullName` varchar(159) DEFAULT NULL,
  `TxnDate` datetime DEFAULT NULL,
  `RefNumber` varchar(25) DEFAULT NULL,
  `TotalAmount` decimal(15,2) DEFAULT NULL,
  `CurrencyRef_ListID` varchar(36) DEFAULT NULL,
  `CurrencyRef_FullName` varchar(64) DEFAULT NULL,
  `ExchangeRate` decimal(16,6) DEFAULT NULL,
  `TotalAmountInHomeCurrency` decimal(15,2) DEFAULT NULL,
  `PaymentMethodRef_ListID` varchar(36) DEFAULT NULL,
  `PaymentMethodRef_FullName` varchar(31) DEFAULT NULL,
  `Memo` varchar(1000) DEFAULT NULL,
  `DepositToAccountRef_ListID` varchar(36) DEFAULT NULL,
  `DepositToAccountRef_FullName` varchar(159) DEFAULT NULL,
  `UnusedPayment` decimal(16,6) DEFAULT NULL,
  `UnusedCredits` decimal(16,6) DEFAULT NULL,
  `CCTII_CreditCardNumber` varchar(25) DEFAULT NULL,
  `CCTII_ExpirationMonth` int DEFAULT NULL,
  `CCTII_ExpirationYear` int DEFAULT NULL,
  `CCTII_NameOnCard` varchar(41) DEFAULT NULL,
  `CCTII_CreditCardAddress` varchar(41) DEFAULT NULL,
  `CCTII_CreditCardPostalCode` varchar(18) DEFAULT NULL,
  `CCTII_CommercialCardCode` varchar(24) DEFAULT NULL,
  `CCTII_TransactionMode` varchar(255) DEFAULT NULL,
  `CCTII_CreditCardTxnType` varchar(255) DEFAULT NULL,
  `CCTRI_ResultCode` int DEFAULT NULL,
  `CCTRI_ResultMessage` varchar(60) DEFAULT NULL,
  `CCTRI_CreditCardTransID` varchar(24) DEFAULT NULL,
  `CCTRI_MerchantAccountNumber` varchar(32) DEFAULT NULL,
  `CCTRI_AuthorizationCode` varchar(12) DEFAULT NULL,
  `CCTRI_AVSStreet` varchar(255) DEFAULT NULL,
  `CCTRI_AVSZip` varchar(255) DEFAULT NULL,
  `CCTRI_CardSecurityCodeMatch` varchar(255) DEFAULT NULL,
  `CCTRI_ReconBatchID` varchar(84) DEFAULT NULL,
  `CCTRI_PaymentGroupingCode` int DEFAULT NULL,
  `CCTRI_PaymentStatus` varchar(255) DEFAULT NULL,
  `CCTRI_TxnAuthorizationTime` datetime DEFAULT NULL,
  `CCTRI_TxnAuthorizationStamp` int DEFAULT NULL,
  `CCTRI_ClientTransID` varchar(16) DEFAULT NULL,
  `ExternalGUID` varchar(255) DEFAULT NULL,
  `LSData` varchar(10) DEFAULT NULL,
  `CustomField1` varchar(255) DEFAULT NULL,
  `CustomField2` varchar(255) DEFAULT NULL,
  `CustomField3` varchar(255) DEFAULT NULL,
  `CustomField4` varchar(255) DEFAULT NULL,
  `CustomField5` varchar(255) DEFAULT NULL,
  `CustomField6` varchar(255) DEFAULT NULL,
  `CustomField7` varchar(255) DEFAULT NULL,
  `CustomField8` varchar(255) DEFAULT NULL,
  `CustomField9` varchar(255) DEFAULT NULL,
  `CustomField10` varchar(255) DEFAULT NULL,
  `CustomField11` varchar(255) DEFAULT NULL,
  `CustomField12` varchar(255) DEFAULT NULL,
  `CustomField13` varchar(255) DEFAULT NULL,
  `CustomField14` varchar(255) DEFAULT NULL,
  `CustomField15` varchar(255) DEFAULT NULL,
  `Operation` varchar(10) DEFAULT NULL,
  `UserData` varchar(255) DEFAULT NULL,
  PRIMARY KEY (`TxnID`),
  UNIQUE KEY `receivepaymentIdIndex` (`TxnID`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_0900_ai_ci;





CREATE TABLE `receivepaymenttodeposit` (
  `TxnID` varchar(36) NOT NULL,
  `TxnLineID` varchar(36) DEFAULT NULL,
  `TxnType` varchar(255) DEFAULT NULL,
  `CustomerRef_ListID` varchar(36) DEFAULT NULL,
  `CustomerRef_FullName` varchar(209) DEFAULT NULL,
  `TxnDate` datetime DEFAULT NULL,
  `RefNumber` varchar(25) DEFAULT NULL,
  `Amount` decimal(15,2) DEFAULT NULL,
  `CurrencyRef_ListID` varchar(36) DEFAULT NULL,
  `CurrencyRef_FullName` varchar(64) DEFAULT NULL,
  `ExchangeRate` decimal(16,6) DEFAULT NULL,
  `AmountInHomeCurrency` decimal(15,2) DEFAULT NULL,
  `UserData` varchar(255) DEFAULT NULL,
  `Operation` varchar(10) DEFAULT NULL,
  `LSData` varchar(10) DEFAULT NULL,
  PRIMARY KEY (`TxnID`),
  UNIQUE KEY `receivepaymenttodepositIdIndex` (`TxnID`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_0900_ai_ci;




CREATE TABLE `relatedunitret` (
  `Name` varchar(31) DEFAULT NULL,
  `Abbreviation` varchar(31) DEFAULT NULL,
  `ConversionRatio` decimal(16,6) DEFAULT NULL,
  `PARENT_IDKEY` varchar(36) DEFAULT NULL,
  `SeqNum` int DEFAULT NULL,
  `LSData` varchar(10) DEFAULT NULL,
  KEY `relatedunitretIdIndex` (`PARENT_IDKEY`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_0900_ai_ci;




CREATE TABLE `salesandpurchaseret` (
  `SalesDesc` varchar(1000) DEFAULT NULL,
  `SalesPrice` decimal(16,6) DEFAULT NULL,
  `IncomeAccountRef_ListID` varchar(36) DEFAULT NULL,
  `IncomeAccountRef_FullName` varchar(159) DEFAULT NULL,
  `PurchaseDesc` varchar(1000) DEFAULT NULL,
  `PurchaseCost` decimal(16,6) DEFAULT NULL,
  `PurchaseTaxCodeRef_ListID` varchar(36) DEFAULT NULL,
  `PurchaseTaxCodeRef_FullName` varchar(3) DEFAULT NULL,
  `ExpenseAccountRef_ListID` varchar(36) DEFAULT NULL,
  `ExpenseAccountRef_FullName` varchar(159) DEFAULT NULL,
  `PrefVendorRef_ListID` varchar(36) DEFAULT NULL,
  `PrefVendorRef_FullName` varchar(41) DEFAULT NULL,
  `PARENT_IDKEY` varchar(36) DEFAULT NULL,
  `SeqNum` int DEFAULT NULL,
  `LSData` varchar(10) DEFAULT NULL,
  KEY `salesandpurchaseretIdIndex` (`PARENT_IDKEY`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_0900_ai_ci;




CREATE TABLE `salesorder` (
  `TxnID` varchar(36) NOT NULL,
  `TimeCreated` datetime DEFAULT NULL,
  `TimeModified` datetime DEFAULT NULL,
  `EditSequence` varchar(16) DEFAULT NULL,
  `TxnNumber` int DEFAULT NULL,
  `CustomerRef_ListID` varchar(36) DEFAULT NULL,
  `CustomerRef_FullName` varchar(209) DEFAULT NULL,
  `ClassRef_ListID` varchar(36) DEFAULT NULL,
  `ClassRef_FullName` varchar(159) DEFAULT NULL,
  `TemplateRef_ListID` varchar(36) DEFAULT NULL,
  `TemplateRef_FullName` varchar(31) DEFAULT NULL,
  `TxnDate` datetime DEFAULT NULL,
  `RefNumber` varchar(25) DEFAULT NULL,
  `BillAddress_Addr1` varchar(41) DEFAULT NULL,
  `BillAddress_Addr2` varchar(41) DEFAULT NULL,
  `BillAddress_Addr3` varchar(41) DEFAULT NULL,
  `BillAddress_Addr4` varchar(41) DEFAULT NULL,
  `BillAddress_Addr5` varchar(41) DEFAULT NULL,
  `BillAddress_City` varchar(31) DEFAULT NULL,
  `BillAddress_State` varchar(21) DEFAULT NULL,
  `BillAddress_PostalCode` varchar(13) DEFAULT NULL,
  `BillAddress_Country` varchar(31) DEFAULT NULL,
  `BillAddress_Note` varchar(41) DEFAULT NULL,
  `ShipAddress_Addr1` varchar(41) DEFAULT NULL,
  `ShipAddress_Addr2` varchar(41) DEFAULT NULL,
  `ShipAddress_Addr3` varchar(41) DEFAULT NULL,
  `ShipAddress_Addr4` varchar(41) DEFAULT NULL,
  `ShipAddress_Addr5` varchar(41) DEFAULT NULL,
  `ShipAddress_City` varchar(31) DEFAULT NULL,
  `ShipAddress_State` varchar(21) DEFAULT NULL,
  `ShipAddress_PostalCode` varchar(13) DEFAULT NULL,
  `ShipAddress_Country` varchar(31) DEFAULT NULL,
  `ShipAddress_Note` varchar(41) DEFAULT NULL,
  `PONumber` varchar(25) DEFAULT NULL,
  `TermsRef_ListID` varchar(36) DEFAULT NULL,
  `TermsRef_FullName` varchar(31) DEFAULT NULL,
  `DueDate` datetime DEFAULT NULL,
  `SalesRepRef_ListID` varchar(36) DEFAULT NULL,
  `SalesRepRef_FullName` varchar(5) DEFAULT NULL,
  `FOB` varchar(13) DEFAULT NULL,
  `ShipDate` datetime DEFAULT NULL,
  `ShipMethodRef_ListID` varchar(36) DEFAULT NULL,
  `ShipMethodRef_FullName` varchar(15) DEFAULT NULL,
  `Subtotal` decimal(16,6) DEFAULT NULL,
  `ItemSalesTaxRef_ListID` varchar(36) DEFAULT NULL,
  `ItemSalesTaxRef_FullName` varchar(31) DEFAULT NULL,
  `SalesTaxPercentage` decimal(16,6) DEFAULT NULL,
  `SalesTaxTotal` decimal(16,6) DEFAULT NULL,
  `TotalAmount` decimal(15,2) DEFAULT NULL,
  `CurrencyRef_ListID` varchar(36) DEFAULT NULL,
  `CurrencyRef_FullName` varchar(64) DEFAULT NULL,
  `ExchangeRate` decimal(16,6) DEFAULT NULL,
  `TotalAmountInHomeCurrency` decimal(15,2) DEFAULT NULL,
  `IsManuallyClosed` varchar(5) DEFAULT NULL,
  `IsFullyInvoiced` varchar(5) DEFAULT NULL,
  `Memo` varchar(1000) DEFAULT NULL,
  `CustomerMsgRef_ListID` varchar(36) DEFAULT NULL,
  `CustomerMsgRef_FullName` varchar(101) DEFAULT NULL,
  `IsToBePrinted` varchar(5) DEFAULT NULL,
  `IsToBeEmailed` varchar(5) DEFAULT NULL,
  `IsTaxIncluded` varchar(5) DEFAULT NULL,
  `CustSalesTaxCodeRef_ListID` varchar(36) DEFAULT NULL,
  `CustSalesTaxCodeRef_FullName` varchar(3) DEFAULT NULL,
  `Other` varchar(29) DEFAULT NULL,
  `ExternalGUID` varchar(255) DEFAULT NULL,
  `CustomField1` varchar(255) DEFAULT NULL,
  `CustomField2` varchar(255) DEFAULT NULL,
  `CustomField3` varchar(255) DEFAULT NULL,
  `CustomField4` varchar(255) DEFAULT NULL,
  `CustomField5` varchar(255) DEFAULT NULL,
  `CustomField6` varchar(255) DEFAULT NULL,
  `CustomField7` varchar(255) DEFAULT NULL,
  `CustomField8` varchar(255) DEFAULT NULL,
  `CustomField9` varchar(255) DEFAULT NULL,
  `CustomField10` varchar(255) DEFAULT NULL,
  `CustomField11` varchar(255) DEFAULT NULL,
  `CustomField12` varchar(255) DEFAULT NULL,
  `CustomField13` varchar(255) DEFAULT NULL,
  `CustomField14` varchar(255) DEFAULT NULL,
  `CustomField15` varchar(255) DEFAULT NULL,
  `UserData` varchar(255) DEFAULT NULL,
  `Operation` varchar(10) DEFAULT NULL,
  `LSData` varchar(10) DEFAULT NULL,
  PRIMARY KEY (`TxnID`),
  UNIQUE KEY `salesorderIdIndex` (`TxnID`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_0900_ai_ci;




CREATE TABLE `salesorderlinegroupret` (
  `TxnLineID` varchar(36) DEFAULT NULL,
  `ItemGroupRef_ListID` varchar(36) DEFAULT NULL,
  `ItemGroupRef_FullName` varchar(31) DEFAULT NULL,
  `Description` varchar(1000) DEFAULT NULL,
  `Quantity` decimal(16,6) DEFAULT NULL,
  `IsPrintItemsInGroup` varchar(5) DEFAULT NULL,
  `TotalAmount` decimal(15,2) DEFAULT NULL,
  `CustomField1` varchar(255) DEFAULT NULL,
  `CustomField2` varchar(255) DEFAULT NULL,
  `CustomField3` varchar(255) DEFAULT NULL,
  `CustomField4` varchar(255) DEFAULT NULL,
  `CustomField5` varchar(255) DEFAULT NULL,
  `CustomField6` varchar(255) DEFAULT NULL,
  `CustomField7` varchar(255) DEFAULT NULL,
  `CustomField8` varchar(255) DEFAULT NULL,
  `CustomField9` varchar(255) DEFAULT NULL,
  `CustomField10` varchar(255) DEFAULT NULL,
  `CustomField11` varchar(255) DEFAULT NULL,
  `CustomField12` varchar(255) DEFAULT NULL,
  `CustomField13` varchar(255) DEFAULT NULL,
  `CustomField14` varchar(255) DEFAULT NULL,
  `CustomField15` varchar(255) DEFAULT NULL,
  `PARENT_IDKEY` varchar(36) DEFAULT NULL,
  `GroupPARENT_IDKEY` varchar(255) DEFAULT NULL,
  `SeqNum` int DEFAULT NULL,
  `LSData` varchar(10) DEFAULT NULL,
  KEY `salesorderlinegroupretIdIndex` (`PARENT_IDKEY`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_0900_ai_ci;




CREATE TABLE `salesorderlineret` (
  `TxnLineID` varchar(36) DEFAULT NULL,
  `ItemRef_ListID` varchar(36) DEFAULT NULL,
  `ItemRef_FullName` varchar(209) DEFAULT NULL,
  `Description` varchar(1000) DEFAULT NULL,
  `Quantity` decimal(16,6) DEFAULT NULL,
  `UnitOfMeasure` varchar(31) DEFAULT NULL,
  `OverrideUOMSetRef_ListID` varchar(36) DEFAULT NULL,
  `OverrideUOMSetRef_FullName` varchar(31) DEFAULT NULL,
  `Rate` decimal(16,6) DEFAULT NULL,
  `RatePercent` decimal(16,6) DEFAULT NULL,
  `ClassRef_ListID` varchar(36) DEFAULT NULL,
  `ClassRef_FullName` varchar(209) DEFAULT NULL,
  `Amount` decimal(15,2) DEFAULT NULL,
  `InvSiteRef_ListID` varchar(36) DEFAULT NULL,
  `InvSiteRef_FullName` varchar(31) DEFAULT NULL,
  `InvSiteLocRef_ListID` varchar(36) DEFAULT NULL,
  `InvSiteLocRef_FullName` varchar(31) DEFAULT NULL,
  `SerialNumber` varchar(1000) DEFAULT NULL,
  `LotNumber` varchar(40) DEFAULT NULL,
  `SalesTaxCodeRef_ListID` varchar(36) DEFAULT NULL,
  `SalesTaxCodeRef_FullName` varchar(3) DEFAULT NULL,
  `Invoiced` decimal(16,6) DEFAULT NULL,
  `IsManuallyClosed` varchar(5) DEFAULT NULL,
  `Other1` varchar(29) DEFAULT NULL,
  `Other2` varchar(29) DEFAULT NULL,
  `CustomField1` varchar(255) DEFAULT NULL,
  `CustomField2` varchar(255) DEFAULT NULL,
  `CustomField3` varchar(255) DEFAULT NULL,
  `CustomField4` varchar(255) DEFAULT NULL,
  `CustomField5` varchar(255) DEFAULT NULL,
  `CustomField6` varchar(255) DEFAULT NULL,
  `CustomField7` varchar(255) DEFAULT NULL,
  `CustomField8` varchar(255) DEFAULT NULL,
  `CustomField9` varchar(255) DEFAULT NULL,
  `CustomField10` varchar(255) DEFAULT NULL,
  `CustomField11` varchar(255) DEFAULT NULL,
  `CustomField12` varchar(255) DEFAULT NULL,
  `CustomField13` varchar(255) DEFAULT NULL,
  `CustomField14` varchar(255) DEFAULT NULL,
  `CustomField15` varchar(255) DEFAULT NULL,
  `PARENT_IDKEY` varchar(36) DEFAULT NULL,
  `GroupPARENT_IDKEY` varchar(255) DEFAULT NULL,
  `SeqNum` int DEFAULT NULL,
  `LSData` varchar(10) DEFAULT NULL,
  KEY `salesorderlineretIdIndex` (`PARENT_IDKEY`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_0900_ai_ci;



CREATE TABLE `salesorpurchaseret` (
  `Description` varchar(1000) DEFAULT NULL,
  `Price` decimal(16,6) DEFAULT NULL,
  `PricePercent` decimal(16,6) DEFAULT NULL,
  `AccountRef_ListID` varchar(36) DEFAULT NULL,
  `AccountRef_FullName` varchar(159) DEFAULT NULL,
  `PARENT_IDKEY` varchar(36) DEFAULT NULL,
  `SeqNum` int DEFAULT NULL,
  `LSData` varchar(10) DEFAULT NULL,
  KEY `salesorpurchaseretIdIndex` (`PARENT_IDKEY`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_0900_ai_ci;




CREATE TABLE `salesreceipt` (
  `TxnID` varchar(36) NOT NULL,
  `TimeCreated` datetime DEFAULT NULL,
  `TimeModified` datetime DEFAULT NULL,
  `EditSequence` varchar(16) DEFAULT NULL,
  `TxnNumber` int DEFAULT NULL,
  `CustomerRef_ListID` varchar(36) DEFAULT NULL,
  `CustomerRef_FullName` varchar(209) DEFAULT NULL,
  `ClassRef_ListID` varchar(36) DEFAULT NULL,
  `ClassRef_FullName` varchar(159) DEFAULT NULL,
  `TemplateRef_ListID` varchar(36) DEFAULT NULL,
  `TemplateRef_FullName` varchar(31) DEFAULT NULL,
  `TxnDate` datetime DEFAULT NULL,
  `RefNumber` varchar(25) DEFAULT NULL,
  `BillAddress_Addr1` varchar(41) DEFAULT NULL,
  `BillAddress_Addr2` varchar(41) DEFAULT NULL,
  `BillAddress_Addr3` varchar(41) DEFAULT NULL,
  `BillAddress_Addr4` varchar(41) DEFAULT NULL,
  `BillAddress_Addr5` varchar(41) DEFAULT NULL,
  `BillAddress_City` varchar(31) DEFAULT NULL,
  `BillAddress_State` varchar(21) DEFAULT NULL,
  `BillAddress_PostalCode` varchar(13) DEFAULT NULL,
  `BillAddress_Country` varchar(31) DEFAULT NULL,
  `BillAddress_Note` varchar(41) DEFAULT NULL,
  `ShipAddress_Addr1` varchar(41) DEFAULT NULL,
  `ShipAddress_Addr2` varchar(41) DEFAULT NULL,
  `ShipAddress_Addr3` varchar(41) DEFAULT NULL,
  `ShipAddress_Addr4` varchar(41) DEFAULT NULL,
  `ShipAddress_Addr5` varchar(41) DEFAULT NULL,
  `ShipAddress_City` varchar(31) DEFAULT NULL,
  `ShipAddress_State` varchar(21) DEFAULT NULL,
  `ShipAddress_PostalCode` varchar(13) DEFAULT NULL,
  `ShipAddress_Country` varchar(31) DEFAULT NULL,
  `ShipAddress_Note` varchar(41) DEFAULT NULL,
  `IsPending` varchar(5) DEFAULT NULL,
  `CheckNumber` varchar(25) DEFAULT NULL,
  `PaymentMethodRef_ListID` varchar(36) DEFAULT NULL,
  `PaymentMethodRef_FullName` varchar(31) DEFAULT NULL,
  `DueDate` datetime DEFAULT NULL,
  `SalesRepRef_ListID` varchar(36) DEFAULT NULL,
  `SalesRepRef_FullName` varchar(5) DEFAULT NULL,
  `ShipDate` datetime DEFAULT NULL,
  `ShipMethodRef_ListID` varchar(36) DEFAULT NULL,
  `ShipMethodRef_FullName` varchar(15) DEFAULT NULL,
  `FOB` varchar(13) DEFAULT NULL,
  `Subtotal` decimal(16,6) DEFAULT NULL,
  `ItemSalesTaxRef_ListID` varchar(36) DEFAULT NULL,
  `ItemSalesTaxRef_FullName` varchar(31) DEFAULT NULL,
  `SalesTaxPercentage` decimal(16,6) DEFAULT NULL,
  `SalesTaxTotal` decimal(16,6) DEFAULT NULL,
  `TotalAmount` decimal(15,2) DEFAULT NULL,
  `CurrencyRef_ListID` varchar(36) DEFAULT NULL,
  `CurrencyRef_FullName` varchar(64) DEFAULT NULL,
  `ExchangeRate` decimal(16,6) DEFAULT NULL,
  `TotalAmountInHomeCurrency` decimal(15,2) DEFAULT NULL,
  `Memo` varchar(1000) DEFAULT NULL,
  `CustomerMsgRef_ListID` varchar(36) DEFAULT NULL,
  `CustomerMsgRef_FullName` varchar(101) DEFAULT NULL,
  `IsToBePrinted` varchar(5) DEFAULT NULL,
  `IsToBeEmailed` varchar(5) DEFAULT NULL,
  `IsTaxIncluded` varchar(5) DEFAULT NULL,
  `CustSalesTaxCodeRef_ListID` varchar(36) DEFAULT NULL,
  `CustSalesTaxCodeRef_FullName` varchar(3) DEFAULT NULL,
  `DepositToAccountRef_ListID` varchar(36) DEFAULT NULL,
  `DepositToAccountRef_FullName` varchar(159) DEFAULT NULL,
  `CCTII_CreditCardNumber` varchar(25) DEFAULT NULL,
  `CCTII_ExpirationMonth` int DEFAULT NULL,
  `CCTII_ExpirationYear` int DEFAULT NULL,
  `CCTII_NameOnCard` varchar(41) DEFAULT NULL,
  `CCTII_CreditCardAddress` varchar(41) DEFAULT NULL,
  `CCTII_CreditCardPostalCode` varchar(18) DEFAULT NULL,
  `CCTII_CommercialCardCode` varchar(24) DEFAULT NULL,
  `CCTII_TransactionMode` varchar(255) DEFAULT NULL,
  `CCTII_CreditCardTxnType` varchar(255) DEFAULT NULL,
  `CCTRI_ResultCode` int DEFAULT NULL,
  `CCTRI_ResultMessage` varchar(60) DEFAULT NULL,
  `CCTRI_CreditCardTransID` varchar(24) DEFAULT NULL,
  `CCTRI_MerchantAccountNumber` varchar(32) DEFAULT NULL,
  `CCTRI_AuthorizationCode` varchar(12) DEFAULT NULL,
  `CCTRI_AVSStreet` varchar(255) DEFAULT NULL,
  `CCTRI_AVSZip` varchar(255) DEFAULT NULL,
  `CCTRI_CardSecurityCodeMatch` varchar(255) DEFAULT NULL,
  `CCTRI_ReconBatchID` varchar(84) DEFAULT NULL,
  `CCTRI_PaymentGroupingCode` int DEFAULT NULL,
  `CCTRI_PaymentStatus` varchar(255) DEFAULT NULL,
  `CCTRI_TxnAuthorizationTime` datetime DEFAULT NULL,
  `CCTRI_TxnAuthorizationStamp` int DEFAULT NULL,
  `CCTRI_ClientTransID` varchar(16) DEFAULT NULL,
  `Other` varchar(29) DEFAULT NULL,
  `ExternalGUID` varchar(255) DEFAULT NULL,
  `CustomField1` varchar(255) DEFAULT NULL,
  `CustomField2` varchar(255) DEFAULT NULL,
  `CustomField3` varchar(255) DEFAULT NULL,
  `CustomField4` varchar(255) DEFAULT NULL,
  `CustomField5` varchar(255) DEFAULT NULL,
  `CustomField6` varchar(255) DEFAULT NULL,
  `CustomField7` varchar(255) DEFAULT NULL,
  `CustomField8` varchar(255) DEFAULT NULL,
  `CustomField9` varchar(255) DEFAULT NULL,
  `CustomField10` varchar(255) DEFAULT NULL,
  `CustomField11` varchar(255) DEFAULT NULL,
  `CustomField12` varchar(255) DEFAULT NULL,
  `CustomField13` varchar(255) DEFAULT NULL,
  `CustomField14` varchar(255) DEFAULT NULL,
  `CustomField15` varchar(255) DEFAULT NULL,
  `UserData` varchar(255) DEFAULT NULL,
  `Operation` varchar(10) DEFAULT NULL,
  `LSData` varchar(10) DEFAULT NULL,
  PRIMARY KEY (`TxnID`),
  UNIQUE KEY `salesreceiptIdIndex` (`TxnID`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_0900_ai_ci;





CREATE TABLE `salesreceiptlinegroupret` (
  `TxnLineID` varchar(36) DEFAULT NULL,
  `ItemGroupRef_ListID` varchar(36) DEFAULT NULL,
  `ItemGroupRef_FullName` varchar(159) DEFAULT NULL,
  `Description` varchar(1000) DEFAULT NULL,
  `Quantity` decimal(16,6) DEFAULT NULL,
  `UnitOfMeasure` varchar(31) DEFAULT NULL,
  `OverrideUOMSetRef_ListID` varchar(36) DEFAULT NULL,
  `OverrideUOMSetRef_FullName` varchar(31) DEFAULT NULL,
  `IsPrintItemsInGroup` varchar(5) DEFAULT NULL,
  `TotalAmount` decimal(15,2) DEFAULT NULL,
  `ServiceDate` datetime DEFAULT NULL,
  `CustomField1` varchar(255) DEFAULT NULL,
  `CustomField2` varchar(255) DEFAULT NULL,
  `CustomField3` varchar(255) DEFAULT NULL,
  `CustomField4` varchar(255) DEFAULT NULL,
  `CustomField5` varchar(255) DEFAULT NULL,
  `CustomField6` varchar(255) DEFAULT NULL,
  `CustomField7` varchar(255) DEFAULT NULL,
  `CustomField8` varchar(255) DEFAULT NULL,
  `CustomField9` varchar(255) DEFAULT NULL,
  `CustomField10` varchar(255) DEFAULT NULL,
  `CustomField11` varchar(255) DEFAULT NULL,
  `CustomField12` varchar(255) DEFAULT NULL,
  `CustomField13` varchar(255) DEFAULT NULL,
  `CustomField14` varchar(255) DEFAULT NULL,
  `CustomField15` varchar(255) DEFAULT NULL,
  `PARENT_IDKEY` varchar(36) DEFAULT NULL,
  `GroupPARENT_IDKEY` varchar(255) DEFAULT NULL,
  `SeqNum` int DEFAULT NULL,
  `LSData` varchar(10) DEFAULT NULL,
  KEY `salesreceiptlinegroupretIdIndex` (`PARENT_IDKEY`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_0900_ai_ci;





CREATE TABLE `salesreceiptlineret` (
  `TxnLineID` varchar(36) DEFAULT NULL,
  `ItemRef_ListID` varchar(36) DEFAULT NULL,
  `ItemRef_FullName` varchar(159) DEFAULT NULL,
  `Description` varchar(1000) DEFAULT NULL,
  `Quantity` decimal(16,6) DEFAULT NULL,
  `UnitOfMeasure` varchar(31) DEFAULT NULL,
  `OverrideUOMSetRef_ListID` varchar(36) DEFAULT NULL,
  `OverrideUOMSetRef_FullName` varchar(31) DEFAULT NULL,
  `Rate` decimal(16,6) DEFAULT NULL,
  `RatePercent` decimal(16,6) DEFAULT NULL,
  `ClassRef_ListID` varchar(36) DEFAULT NULL,
  `ClassRef_FullName` varchar(159) DEFAULT NULL,
  `Amount` decimal(15,2) DEFAULT NULL,
  `TaxAmount` decimal(15,2) DEFAULT NULL,
  `InvSiteRef_ListID` varchar(36) DEFAULT NULL,
  `InvSiteRef_FullName` varchar(31) DEFAULT NULL,
  `InvSiteLocRef_ListID` varchar(36) DEFAULT NULL,
  `InvSiteLocRef_FullName` varchar(209) DEFAULT NULL,
  `SerialNumber` varchar(1000) DEFAULT NULL,
  `LotNumber` varchar(40) DEFAULT NULL,
  `ServiceDate` datetime DEFAULT NULL,
  `SalesTaxCodeRef_ListID` varchar(36) DEFAULT NULL,
  `SalesTaxCodeRef_FullName` varchar(3) DEFAULT NULL,
  `Other1` varchar(29) DEFAULT NULL,
  `Other2` varchar(29) DEFAULT NULL,
  `CCTII_CreditCardNumber` varchar(25) DEFAULT NULL,
  `CCTII_ExpirationMonth` int DEFAULT NULL,
  `CCTII_ExpirationYear` int DEFAULT NULL,
  `CCTII_NameOnCard` varchar(41) DEFAULT NULL,
  `CCTII_CreditCardAddress` varchar(41) DEFAULT NULL,
  `CCTII_CreditCardPostalCode` varchar(18) DEFAULT NULL,
  `CCTII_CommercialCardCode` varchar(24) DEFAULT NULL,
  `CCTII_TransactionMode` varchar(255) DEFAULT NULL,
  `CCTII_CreditCardTxnType` varchar(255) DEFAULT NULL,
  `CCTRI_ResultCode` int DEFAULT NULL,
  `CCTRI_ResultMessage` varchar(60) DEFAULT NULL,
  `CCTRI_CreditCardTransID` varchar(24) DEFAULT NULL,
  `CCTRI_MerchantAccountNumber` varchar(32) DEFAULT NULL,
  `CCTRI_AuthorizationCode` varchar(12) DEFAULT NULL,
  `CCTRI_AVSStreet` varchar(255) DEFAULT NULL,
  `CCTRI_AVSZip` varchar(255) DEFAULT NULL,
  `CCTRI_CardSecurityCodeMatch` varchar(255) DEFAULT NULL,
  `CCTRI_ReconBatchID` varchar(84) DEFAULT NULL,
  `CCTRI_PaymentGroupingCode` int DEFAULT NULL,
  `CCTRI_PaymentStatus` varchar(255) DEFAULT NULL,
  `CCTRI_TxnAuthorizationTime` datetime DEFAULT NULL,
  `CCTRI_TxnAuthorizationStamp` int DEFAULT NULL,
  `CCTRI_ClientTransID` varchar(16) DEFAULT NULL,
  `CustomField1` varchar(255) DEFAULT NULL,
  `CustomField2` varchar(255) DEFAULT NULL,
  `CustomField3` varchar(255) DEFAULT NULL,
  `CustomField4` varchar(255) DEFAULT NULL,
  `CustomField5` varchar(255) DEFAULT NULL,
  `CustomField6` varchar(255) DEFAULT NULL,
  `CustomField7` varchar(255) DEFAULT NULL,
  `CustomField8` varchar(255) DEFAULT NULL,
  `CustomField9` varchar(255) DEFAULT NULL,
  `CustomField10` varchar(255) DEFAULT NULL,
  `CustomField11` varchar(255) DEFAULT NULL,
  `CustomField12` varchar(255) DEFAULT NULL,
  `CustomField13` varchar(255) DEFAULT NULL,
  `CustomField14` varchar(255) DEFAULT NULL,
  `CustomField15` varchar(255) DEFAULT NULL,
  `PARENT_IDKEY` varchar(36) DEFAULT NULL,
  `GroupPARENT_IDKEY` varchar(255) DEFAULT NULL,
  `SeqNum` int DEFAULT NULL,
  `LSData` varchar(10) DEFAULT NULL,
  KEY `salesreceiptlineretIdIndex` (`PARENT_IDKEY`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_0900_ai_ci;




CREATE TABLE `salesrep` (
  `ListID` varchar(36) NOT NULL,
  `TimeCreated` datetime DEFAULT NULL,
  `TimeModified` datetime DEFAULT NULL,
  `EditSequence` varchar(16) DEFAULT NULL,
  `Initial` varchar(5) DEFAULT NULL,
  `IsActive` varchar(5) DEFAULT NULL,
  `SalesRepEntityRef_ListID` varchar(36) DEFAULT NULL,
  `SalesRepEntityRef_FullName` varchar(41) DEFAULT NULL,
  `UserData` varchar(255) DEFAULT NULL,
  `Operation` varchar(10) DEFAULT NULL,
  `LSData` varchar(10) DEFAULT NULL,
  PRIMARY KEY (`ListID`),
  UNIQUE KEY `salesrepIdIndex` (`ListID`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_0900_ai_ci;




CREATE TABLE `salestaxcode` (
  `ListID` varchar(36) NOT NULL,
  `TimeCreated` datetime DEFAULT NULL,
  `TimeModified` datetime DEFAULT NULL,
  `EditSequence` varchar(16) DEFAULT NULL,
  `Name` varchar(3) DEFAULT NULL,
  `IsActive` varchar(5) DEFAULT NULL,
  `IsTaxable` varchar(5) DEFAULT NULL,
  `Description` varchar(31) DEFAULT NULL,
  `ItemPurchaseTaxRef_ListID` varchar(36) DEFAULT NULL,
  `ItemPurchaseTaxRef_FullName` varchar(31) DEFAULT NULL,
  `ItemSalesTaxRef_ListID` varchar(36) DEFAULT NULL,
  `ItemSalesTaxRef_FullName` varchar(31) DEFAULT NULL,
  `UserData` varchar(255) DEFAULT NULL,
  `Operation` varchar(10) DEFAULT NULL,
  `LSData` varchar(10) DEFAULT NULL,
  PRIMARY KEY (`ListID`),
  UNIQUE KEY `salestaxcodeIdIndex` (`ListID`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_0900_ai_ci;




CREATE TABLE `salestaxpaymentcheck` (
  `TxnID` varchar(36) NOT NULL,
  `TimeCreated` datetime DEFAULT NULL,
  `TimeModified` datetime DEFAULT NULL,
  `EditSequence` varchar(16) DEFAULT NULL,
  `TxnNumber` int DEFAULT NULL,
  `PayeeEntityRef_ListID` varchar(36) DEFAULT NULL,
  `PayeeEntityRef_FullName` varchar(209) DEFAULT NULL,
  `TxnDate` datetime DEFAULT NULL,
  `BankAccountRef_ListID` varchar(36) DEFAULT NULL,
  `BankAccountRef_FullName` varchar(159) DEFAULT NULL,
  `Amount` decimal(15,2) DEFAULT NULL,
  `RefNumber` varchar(25) DEFAULT NULL,
  `Memo` varchar(1000) DEFAULT NULL,
  `Address_Addr1` varchar(41) DEFAULT NULL,
  `Address_Addr2` varchar(41) DEFAULT NULL,
  `Address_Addr3` varchar(41) DEFAULT NULL,
  `Address_Addr4` varchar(41) DEFAULT NULL,
  `Address_Addr5` varchar(41) DEFAULT NULL,
  `Address_City` varchar(31) DEFAULT NULL,
  `Address_State` varchar(21) DEFAULT NULL,
  `Address_PostalCode` varchar(13) DEFAULT NULL,
  `Address_Country` varchar(31) DEFAULT NULL,
  `Address_Note` varchar(41) DEFAULT NULL,
  `IsToBePrinted` varchar(5) DEFAULT NULL,
  `ExternalGUID` varchar(255) DEFAULT NULL,
  `UserData` varchar(255) DEFAULT NULL,
  `Operation` varchar(10) DEFAULT NULL,
  `LSData` varchar(10) DEFAULT NULL,
  PRIMARY KEY (`TxnID`),
  UNIQUE KEY `salestaxpaymentcheckIdIndex` (`TxnID`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_0900_ai_ci;




CREATE TABLE `salestaxpaymentchecklineret` (
  `TxnLineID` varchar(36) DEFAULT NULL,
  `ItemSalesTaxRef_ListID` varchar(36) DEFAULT NULL,
  `ItemSalesTaxRef_FullName` varchar(31) DEFAULT NULL,
  `Amount` decimal(15,2) DEFAULT NULL,
  `TaxAmount` decimal(15,2) DEFAULT NULL,
  `PARENT_IDKEY` varchar(36) DEFAULT NULL,
  `SeqNum` int DEFAULT NULL,
  `LSData` varchar(10) DEFAULT NULL,
  KEY `salestaxpaymentchecklineretIdIndex` (`PARENT_IDKEY`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_0900_ai_ci;




CREATE TABLE `setcredit` (
  `CreditTxnID` varchar(36) NOT NULL,
  `AppliedAmount` decimal(15,2) DEFAULT NULL,
  `Override` varchar(5) DEFAULT NULL, 
  `PARENT_IDKEY` varchar(36) DEFAULT NULL,  
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_0900_ai_ci;



CREATE TABLE `shipmethod` (
  `ListID` varchar(36) NOT NULL,
  `TimeCreated` datetime DEFAULT NULL,
  `TimeModified` datetime DEFAULT NULL,
  `EditSequence` varchar(16) DEFAULT NULL,
  `Name` varchar(15) DEFAULT NULL,
  `IsActive` varchar(5) DEFAULT NULL,
  `UserData` varchar(255) DEFAULT NULL,
  `Operation` varchar(10) DEFAULT NULL,
  `LSData` varchar(10) DEFAULT NULL,
  PRIMARY KEY (`ListID`),
  UNIQUE KEY `shipmethodIdIndex` (`ListID`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_0900_ai_ci;




CREATE TABLE `shiptoaddressret` (
  `Name` varchar(41) DEFAULT NULL,
  `Addr1` varchar(41) DEFAULT NULL,
  `Addr2` varchar(41) DEFAULT NULL,
  `Addr3` varchar(41) DEFAULT NULL,
  `Addr4` varchar(41) DEFAULT NULL,
  `Addr5` varchar(41) DEFAULT NULL,
  `City` varchar(31) DEFAULT NULL,
  `State` varchar(21) DEFAULT NULL,
  `PostalCode` varchar(13) DEFAULT NULL,
  `Country` varchar(31) DEFAULT NULL,
  `Notes` varchar(41) DEFAULT NULL,
  `DefaultShipTo` varchar(5) DEFAULT NULL,
  `PARENT_IDKEY` varchar(36) DEFAULT NULL,
  `SeqNum` int DEFAULT NULL,
  `LSData` varchar(10) DEFAULT NULL,
  KEY `shiptoaddressretIdIndex` (`PARENT_IDKEY`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_0900_ai_ci;



CREATE TABLE `standardterms` (
  `ListID` varchar(36) NOT NULL,
  `TimeCreated` datetime DEFAULT NULL,
  `TimeModified` datetime DEFAULT NULL,
  `EditSequence` varchar(16) DEFAULT NULL,
  `Name` varchar(31) DEFAULT NULL,
  `IsActive` varchar(5) DEFAULT NULL,
  `StdDueDays` int DEFAULT NULL,
  `StdDiscountDays` int DEFAULT NULL,
  `DiscountPct` decimal(16,6) DEFAULT NULL,
  `UserData` varchar(255) DEFAULT NULL,
  `Operation` varchar(10) DEFAULT NULL,
  `LSData` varchar(10) DEFAULT NULL,
  PRIMARY KEY (`ListID`),
  UNIQUE KEY `standardtermsIdIndex` (`ListID`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_0900_ai_ci;



CREATE TABLE `template` (
  `ListID` varchar(36) NOT NULL,
  `TimeCreated` datetime DEFAULT NULL,
  `TimeModified` datetime DEFAULT NULL,
  `EditSequence` varchar(16) DEFAULT NULL,
  `Name` varchar(255) DEFAULT NULL,
  `IsActive` varchar(5) DEFAULT NULL,
  `TemplateType` varchar(255) DEFAULT NULL,
  `UserData` varchar(255) DEFAULT NULL,
  `Operation` varchar(10) DEFAULT NULL,
  `LSData` varchar(10) DEFAULT NULL,
  PRIMARY KEY (`ListID`),
  UNIQUE KEY `templateIdIndex` (`ListID`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_0900_ai_ci;



CREATE TABLE `terms` (
  `ListID` varchar(36) NOT NULL,
  `Name` varchar(200) DEFAULT NULL,
  `TableName` varchar(200) DEFAULT NULL,
  `UserData` varchar(255) DEFAULT NULL,
  `Operation` varchar(10) DEFAULT NULL,
  `LSData` varchar(10) DEFAULT NULL,
  PRIMARY KEY (`ListID`),
  UNIQUE KEY `termsIdIndex` (`ListID`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_0900_ai_ci;



CREATE TABLE `timetracking` (
  `TxnID` varchar(36) NOT NULL,
  `TimeCreated` datetime DEFAULT NULL,
  `TimeModified` datetime DEFAULT NULL,
  `EditSequence` varchar(16) DEFAULT NULL,
  `TxnNumber` int DEFAULT NULL,
  `TxnDate` datetime DEFAULT NULL,
  `EntityRef_ListID` varchar(36) DEFAULT NULL,
  `EntityRef_FullName` varchar(209) DEFAULT NULL,
  `CustomerRef_ListID` varchar(36) DEFAULT NULL,
  `CustomerRef_FullName` varchar(209) DEFAULT NULL,
  `ItemServiceRef_ListID` varchar(36) DEFAULT NULL,
  `ItemServiceRef_FullName` varchar(159) DEFAULT NULL,
  `Rate` decimal(16,6) DEFAULT NULL,
  `Duration` varchar(50) DEFAULT NULL,
  `ClassRef_ListID` varchar(36) DEFAULT NULL,
  `ClassRef_FullName` varchar(159) DEFAULT NULL,
  `PayrollItemWageRef_ListID` varchar(36) DEFAULT NULL,
  `PayrollItemWageRef_FullName` varchar(31) DEFAULT NULL,
  `Notes` varchar(1000) DEFAULT NULL,
  `IsBillable` varchar(5) DEFAULT NULL,
  `IsBilled` varchar(5) DEFAULT NULL,
  `BillableStatus` varchar(255) DEFAULT NULL,
  `ExternalGUID` varchar(255) DEFAULT NULL,
  `UserData` varchar(255) DEFAULT NULL,
  `Operation` varchar(10) DEFAULT NULL,
  `LSData` varchar(10) DEFAULT NULL,
  PRIMARY KEY (`TxnID`),
  UNIQUE KEY `timetrackingIdIndex` (`TxnID`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_0900_ai_ci;



CREATE TABLE `todo` (
  `ListID` varchar(36) NOT NULL,
  `TimeCreated` datetime DEFAULT NULL,
  `TimeModified` datetime DEFAULT NULL,
  `EditSequence` varchar(16) DEFAULT NULL,
  `Notes` varchar(1000) DEFAULT NULL,
  `Type` varchar(255) DEFAULT NULL,
  `Priority` varchar(255) DEFAULT NULL,
  `IsActive` varchar(5) DEFAULT NULL,
  `IsDone` varchar(5) DEFAULT NULL,
  `ReminderDate` datetime DEFAULT NULL,
  `ReminderTime` varchar(50) DEFAULT NULL,
  `CustomerRef_ListID` varchar(36) DEFAULT NULL,
  `CustomerRef_FullName` varchar(209) DEFAULT NULL,
  `EmployeeRef_ListID` varchar(36) DEFAULT NULL,
  `EmployeeRef_FullName` varchar(31) DEFAULT NULL,
  `LeadRef_ListID` varchar(36) DEFAULT NULL,
  `LeadRef_FullName` varchar(209) DEFAULT NULL,
  `VendorRef_ListID` varchar(36) DEFAULT NULL,
  `VendorRef_FullName` varchar(209) DEFAULT NULL,
  `UserData` varchar(255) DEFAULT NULL,
  `Operation` varchar(10) DEFAULT NULL,
  `LSData` varchar(10) DEFAULT NULL,
  PRIMARY KEY (`ListID`),
  UNIQUE KEY `todoIdIndex` (`ListID`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_0900_ai_ci;



CREATE TABLE `transaction` (
  `TxnID` varchar(36) NOT NULL,
  `TxnType` varchar(255) DEFAULT NULL,
  `TxnLineID` varchar(36) DEFAULT NULL,
  `TimeCreated` datetime DEFAULT NULL,
  `TimeModified` datetime DEFAULT NULL,
  `EntityRef_ListID` varchar(36) DEFAULT NULL,
  `EntityRef_FullName` varchar(209) DEFAULT NULL,
  `AccountRef_ListID` varchar(36) DEFAULT NULL,
  `AccountRef_FullName` varchar(159) DEFAULT NULL,
  `TxnDate` datetime DEFAULT NULL,
  `RefNumber` varchar(25) DEFAULT NULL,
  `Amount` decimal(15,2) DEFAULT NULL,
  `CurrencyRef_ListID` varchar(36) DEFAULT NULL,
  `CurrencyRef_FullName` varchar(64) DEFAULT NULL,
  `ExchangeRate` decimal(16,6) DEFAULT NULL,
  `AmountInHomeCurrency` decimal(15,2) DEFAULT NULL,
  `Memo` varchar(1000) DEFAULT NULL,
  `UserData` varchar(255) DEFAULT NULL,
  `Operation` varchar(10) DEFAULT NULL,
  `LSData` varchar(10) DEFAULT NULL,
  PRIMARY KEY (`TxnID`),
  UNIQUE KEY `transactionIdIndex` (`TxnID`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_0900_ai_ci;



CREATE TABLE `transfer` (
  `TxnID` varchar(36) NOT NULL,
  `TimeCreated` datetime DEFAULT NULL,
  `TimeModified` datetime DEFAULT NULL,
  `EditSequence` varchar(16) DEFAULT NULL,
  `TxnNumber` int DEFAULT NULL,
  `TxnDate` datetime DEFAULT NULL,
  `TransferFromAccountRef_ListID` varchar(36) DEFAULT NULL,
  `TransferFromAccountRef_FullName` varchar(159) DEFAULT NULL,
  `FromAccountBalance` decimal(15,2) DEFAULT NULL,
  `TransferToAccountRef_ListID` varchar(36) DEFAULT NULL,
  `TransferToAccountRef_FullName` varchar(159) DEFAULT NULL,
  `ToAccountBalance` decimal(15,2) DEFAULT NULL,
  `ClassRef_ListID` varchar(36) DEFAULT NULL,
  `ClassRef_FullName` varchar(159) DEFAULT NULL,
  `Amount` decimal(15,2) DEFAULT NULL,
  `Memo` varchar(1000) DEFAULT NULL,
  `UserData` varchar(255) DEFAULT NULL,
  `Operation` varchar(10) DEFAULT NULL,
  `LSData` varchar(10) DEFAULT NULL,
  PRIMARY KEY (`TxnID`),
  UNIQUE KEY `transferIdIndex` (`TxnID`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_0900_ai_ci;



CREATE TABLE `transferinventory` (
  `TxnID` varchar(36) NOT NULL,
  `TimeCreated` datetime DEFAULT NULL,
  `TimeModified` datetime DEFAULT NULL,
  `EditSequence` varchar(16) DEFAULT NULL,
  `TxnNumber` int DEFAULT NULL,
  `TxnDate` datetime DEFAULT NULL,
  `RefNumber` varchar(25) DEFAULT NULL,
  `FromInvSiteRef_ListID` varchar(36) DEFAULT NULL,
  `FromInvSiteRef_FullName` varchar(31) DEFAULT NULL,
  `ToInvSiteRef_ListID` varchar(36) DEFAULT NULL,
  `ToInvSiteRef_FullName` varchar(31) DEFAULT NULL,
  `FromInvSiteLocRef_ListID` varchar(36) DEFAULT NULL,
  `FromInvSiteLocRef_FullName` varchar(31) DEFAULT NULL,
  `ToInvSiteLocRef_ListID` varchar(36) DEFAULT NULL,
  `ToInvSiteLocRef_FullName` varchar(31) DEFAULT NULL,
  `Memo` varchar(1000) DEFAULT NULL,
  `ExternalGUID` varchar(255) DEFAULT NULL,
  `UserData` varchar(255) DEFAULT NULL,
  `Operation` varchar(10) DEFAULT NULL,
  `LSData` varchar(10) DEFAULT NULL,
  PRIMARY KEY (`TxnID`),
  UNIQUE KEY `transferinventoryIdIndex` (`TxnID`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_0900_ai_ci;



CREATE TABLE `transferinventorylineret` (
  `TxnLineID` varchar(36) DEFAULT NULL,
  `ItemRef_ListID` varchar(36) DEFAULT NULL,
  `ItemRef_FullName` varchar(159) DEFAULT NULL,
  `QuantityTransferred` decimal(16,6) DEFAULT NULL,
  `SerialNumber` varchar(1000) DEFAULT NULL,
  `LotNumber` varchar(40) DEFAULT NULL,
  `FromInvSiteLocRef_ListID` varchar(36) DEFAULT NULL,
  `FromInvSiteLocRef_FullName` varchar(31) DEFAULT NULL,
  `ToInvSiteLocRef_ListID` varchar(36) DEFAULT NULL,
  `ToInvSiteLocRef_FullName` varchar(31) DEFAULT NULL,
  `PARENT_IDKEY` varchar(36) DEFAULT NULL,
  `SeqNum` int DEFAULT NULL,
  `UserData` varchar(255) DEFAULT NULL,
  `Operation` varchar(10) DEFAULT NULL,
  `LSData` varchar(10) DEFAULT NULL,
  KEY `transferinventorylineretIdIndex` (`PARENT_IDKEY`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_0900_ai_ci;



CREATE TABLE `unitofmeasureset` (
  `ListID` varchar(36) NOT NULL,
  `TimeCreated` datetime DEFAULT NULL,
  `TimeModified` datetime DEFAULT NULL,
  `EditSequence` varchar(16) DEFAULT NULL,
  `Name` varchar(31) DEFAULT NULL,
  `IsActive` varchar(5) DEFAULT NULL,
  `UnitOfMeasureType` varchar(255) DEFAULT NULL,
  `BaseUnitName` varchar(31) DEFAULT NULL,
  `BaseUnitAbbreviation` varchar(31) DEFAULT NULL,
  `UserData` varchar(255) DEFAULT NULL,
  `Operation` varchar(10) DEFAULT NULL,
  `LSData` varchar(10) DEFAULT NULL,
  PRIMARY KEY (`ListID`),
  UNIQUE KEY `unitofmeasuresetIdIndex` (`ListID`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_0900_ai_ci;




CREATE TABLE `vehicle` (
  `ListID` varchar(36) NOT NULL,
  `TimeCreated` datetime DEFAULT NULL,
  `TimeModified` datetime DEFAULT NULL,
  `EditSequence` varchar(16) DEFAULT NULL,
  `Name` varchar(31) DEFAULT NULL,
  `IsActive` varchar(5) DEFAULT NULL,
  `Description` varchar(255) DEFAULT NULL,
  `UserData` varchar(255) DEFAULT NULL,
  `Operation` varchar(10) DEFAULT NULL,
  `LSData` varchar(10) DEFAULT NULL,
  PRIMARY KEY (`ListID`),
  UNIQUE KEY `vehicleIdIndex` (`ListID`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_0900_ai_ci;




CREATE TABLE `vehiclemileage` (
  `TxnID` varchar(36) NOT NULL,
  `TimeCreated` datetime DEFAULT NULL,
  `TimeModified` datetime DEFAULT NULL,
  `EditSequence` varchar(16) DEFAULT NULL,
  `VehicleRef_ListID` varchar(36) DEFAULT NULL,
  `VehicleRef_FullName` varchar(31) DEFAULT NULL,
  `CustomerRef_ListID` varchar(36) DEFAULT NULL,
  `CustomerRef_FullName` varchar(209) DEFAULT NULL,
  `ItemRef_ListID` varchar(36) DEFAULT NULL,
  `ItemRef_FullName` varchar(159) DEFAULT NULL,
  `ClassRef_ListID` varchar(36) DEFAULT NULL,
  `ClassRef_FullName` varchar(159) DEFAULT NULL,
  `TripStartDate` datetime DEFAULT NULL,
  `TripEndDate` datetime DEFAULT NULL,
  `OdometerStart` decimal(16,6) DEFAULT NULL,
  `OdometerEnd` decimal(16,6) DEFAULT NULL,
  `TotalMiles` decimal(16,6) DEFAULT NULL,
  `Notes` varchar(1000) DEFAULT NULL,
  `BillableStatus` varchar(255) DEFAULT NULL,
  `StandardMileageRate` decimal(16,6) DEFAULT NULL,
  `StandardMileageTotalAmount` decimal(15,2) DEFAULT NULL,
  `BillableRate` decimal(16,6) DEFAULT NULL,
  `BillableAmount` decimal(15,2) DEFAULT NULL,
  `UserData` varchar(255) DEFAULT NULL,
  `Operation` varchar(10) DEFAULT NULL,
  `LSData` varchar(10) DEFAULT NULL,
  PRIMARY KEY (`TxnID`),
  UNIQUE KEY `vehiclemileageIdIndex` (`TxnID`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_0900_ai_ci;




CREATE TABLE `vendor` (
  `ListID` varchar(36) NOT NULL,
  `TimeCreated` datetime DEFAULT NULL,
  `TimeModified` datetime DEFAULT NULL,
  `EditSequence` varchar(36) DEFAULT NULL,
  `Name` varchar(41) DEFAULT NULL,
  `IsActive` varchar(5) DEFAULT NULL,
  `ClassRef_ListID` varchar(36) DEFAULT NULL,
  `ClassRef_FullName` varchar(159) DEFAULT NULL,
  `IsTaxAgency` varchar(5) DEFAULT NULL,
  `CompanyName` varchar(41) DEFAULT NULL,
  `Salutation` varchar(15) DEFAULT NULL,
  `FirstName` varchar(25) DEFAULT NULL,
  `MiddleName` varchar(5) DEFAULT NULL,
  `LastName` varchar(25) DEFAULT NULL,
  `JobTitle` varchar(41) DEFAULT NULL,
  `VendorAddress_Addr1` varchar(41) DEFAULT NULL,
  `VendorAddress_Addr2` varchar(41) DEFAULT NULL,
  `VendorAddress_Addr3` varchar(41) DEFAULT NULL,
  `VendorAddress_Addr4` varchar(41) DEFAULT NULL,
  `VendorAddress_Addr5` varchar(41) DEFAULT NULL,
  `VendorAddress_City` varchar(31) DEFAULT NULL,
  `VendorAddress_State` varchar(21) DEFAULT NULL,
  `VendorAddress_PostalCode` varchar(13) DEFAULT NULL,
  `VendorAddress_Country` varchar(31) DEFAULT NULL,
  `VendorAddress_Note` varchar(41) DEFAULT NULL,
  `ShipAddress_Addr1` varchar(41) DEFAULT NULL,
  `ShipAddress_Addr2` varchar(41) DEFAULT NULL,
  `ShipAddress_Addr3` varchar(41) DEFAULT NULL,
  `ShipAddress_Addr4` varchar(41) DEFAULT NULL,
  `ShipAddress_Addr5` varchar(41) DEFAULT NULL,
  `ShipAddress_City` varchar(31) DEFAULT NULL,
  `ShipAddress_State` varchar(21) DEFAULT NULL,
  `ShipAddress_PostalCode` varchar(13) DEFAULT NULL,
  `ShipAddress_Country` varchar(31) DEFAULT NULL,
  `ShipAddress_Note` varchar(41) DEFAULT NULL,
  `Phone` varchar(255) DEFAULT NULL,
  `Mobile` varchar(255) DEFAULT NULL,
  `Pager` varchar(255) DEFAULT NULL,
  `AltPhone` varchar(255) DEFAULT NULL,
  `Fax` varchar(255) DEFAULT NULL,
  `Email` varchar(1000) DEFAULT NULL,
  `Cc` varchar(1000) DEFAULT NULL,
  `Contact` varchar(41) DEFAULT NULL,
  `AltContact` varchar(41) DEFAULT NULL,
  `NameOnCheck` varchar(41) DEFAULT NULL,
  `AccountNumber` varchar(99) DEFAULT NULL,
  `Notes` varchar(1000) DEFAULT NULL,
  `VendorTypeRef_ListID` varchar(36) DEFAULT NULL,
  `VendorTypeRef_FullName` varchar(159) DEFAULT NULL,
  `TermsRef_ListID` varchar(36) DEFAULT NULL,
  `TermsRef_FullName` varchar(31) DEFAULT NULL,
  `CreditLimit` decimal(15,2) DEFAULT NULL,
  `VendorTaxIdent` varchar(15) DEFAULT NULL,
  `IsVendorEligibleFor1099` varchar(5) DEFAULT NULL,
  `Balance` decimal(15,2) DEFAULT NULL,
  `BillingRateRef_ListID` varchar(36) DEFAULT NULL,
  `BillingRateRef_FullName` varchar(31) DEFAULT NULL,
  `ExternalGUID` varchar(255) DEFAULT NULL,
  `SalesTaxCodeRef_ListID` varchar(36) DEFAULT NULL,
  `SalesTaxCodeRef_FullName` varchar(3) DEFAULT NULL,
  `OpenBalanceDate` datetime DEFAULT NULL,
  `CurrencyRef_ListID` varchar(36) DEFAULT NULL,
  `CurrencyRef_FullName` varchar(64) DEFAULT NULL,
  `SalesTaxCountry` varchar(255) DEFAULT NULL,
  `IsSalesTaxAgency` varchar(5) DEFAULT NULL,
  `SalesTaxReturnRef_ListID` varchar(36) DEFAULT NULL,
  `SalesTaxReturnRef_FullName` varchar(255) DEFAULT NULL,
  `TaxRegistrationNumber` varchar(30) DEFAULT NULL,
  `ReportingPeriod` varchar(255) DEFAULT NULL,
  `IsTaxTrackedOnPurchases` varchar(5) DEFAULT NULL,
  `TaxOnPurchasesAccountRef_ListID` varchar(36) DEFAULT NULL,
  `TaxOnPurchasesAccountRef_FullName` varchar(159) DEFAULT NULL,
  `IsTaxTrackedOnSales` varchar(5) DEFAULT NULL,
  `TaxOnSalesAccountRef_ListID` varchar(36) DEFAULT NULL,
  `TaxOnSalesAccountRef_FullName` varchar(255) DEFAULT NULL,
  `IsTaxOnTax` varchar(5) DEFAULT NULL,
  `CustomField1` varchar(255) DEFAULT NULL,
  `CustomField2` varchar(255) DEFAULT NULL,
  `CustomField3` varchar(255) DEFAULT NULL,
  `CustomField4` varchar(255) DEFAULT NULL,
  `CustomField5` varchar(255) DEFAULT NULL,
  `CustomField6` varchar(255) DEFAULT NULL,
  `CustomField7` varchar(255) DEFAULT NULL,
  `CustomField8` varchar(255) DEFAULT NULL,
  `CustomField9` varchar(255) DEFAULT NULL,
  `CustomField10` varchar(255) DEFAULT NULL,
  `CustomField11` varchar(255) DEFAULT NULL,
  `CustomField12` varchar(255) DEFAULT NULL,
  `CustomField13` varchar(255) DEFAULT NULL,
  `CustomField14` varchar(255) DEFAULT NULL,
  `CustomField15` varchar(255) DEFAULT NULL,
  `UserData` varchar(255) DEFAULT NULL,
  `Operation` varchar(10) DEFAULT NULL,
  `LSData` varchar(10) DEFAULT NULL,
  PRIMARY KEY (`ListID`),
  UNIQUE KEY `vendorIdIndex` (`ListID`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_0900_ai_ci;



CREATE TABLE `vendorcredit` (
  `TxnID` varchar(36) NOT NULL,
  `TimeCreated` datetime DEFAULT NULL,
  `TimeModified` datetime DEFAULT NULL,
  `EditSequence` varchar(16) DEFAULT NULL,
  `TxnNumber` int DEFAULT NULL,
  `VendorRef_ListID` varchar(36) DEFAULT NULL,
  `VendorRef_FullName` varchar(41) DEFAULT NULL,
  `APAccountRef_ListID` varchar(36) DEFAULT NULL,
  `APAccountRef_FullName` varchar(159) DEFAULT NULL,
  `IsTaxIncluded` varchar(5) DEFAULT NULL,
  `SalesTaxCodeRef_ListID` varchar(36) DEFAULT NULL,
  `SalesTaxCodeRef_FullName` varchar(3) DEFAULT NULL,
  `TxnDate` datetime DEFAULT NULL,
  `CreditAmount` decimal(15,2) DEFAULT NULL,
  `CurrencyRef_ListID` varchar(36) DEFAULT NULL,
  `CurrencyRef_FullName` varchar(64) DEFAULT NULL,
  `ExchangeRate` decimal(16,6) DEFAULT NULL,
  `CreditAmountInHomeCurrency` decimal(15,2) DEFAULT NULL,
  `RefNumber` varchar(25) DEFAULT NULL,
  `Memo` varchar(1000) DEFAULT NULL,
  `OpenAmount` decimal(15,2) DEFAULT NULL,
  `ExternalGUID` varchar(255) DEFAULT NULL,
  `UserData` varchar(255) DEFAULT NULL,
  `Operation` varchar(10) DEFAULT NULL,
  `LSData` varchar(10) DEFAULT NULL,
  PRIMARY KEY (`TxnID`),
  UNIQUE KEY `vendorcreditIdIndex` (`TxnID`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_0900_ai_ci;



CREATE TABLE `vendortype` (
  `ListID` varchar(36) NOT NULL,
  `TimeCreated` datetime DEFAULT NULL,
  `TimeModified` datetime DEFAULT NULL,
  `EditSequence` varchar(16) DEFAULT NULL,
  `Name` varchar(41) DEFAULT NULL,
  `FullName` varchar(159) DEFAULT NULL,
  `IsActive` varchar(5) DEFAULT NULL,
  `ParentRef_ListID` varchar(36) DEFAULT NULL,
  `ParentRef_FullName` varchar(159) DEFAULT NULL,
  `Sublevel` int DEFAULT NULL,
  `UserData` varchar(255) DEFAULT NULL,
  `Operation` varchar(10) DEFAULT NULL,
  `LSData` varchar(10) DEFAULT NULL,
  PRIMARY KEY (`ListID`),
  UNIQUE KEY `vendortypeIdIndex` (`ListID`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_0900_ai_ci;



CREATE TABLE `ListMerge`(
	`ListMergeType` varchar(255) NULL,
	`MergeFrom_ListID` varchar(36) NULL,
	`MergeFrom_EditSequence` varchar(16) NULL,
	`MergeTo_ListID` varchar(36) NULL,
	`MergeTo_EditSequence` varchar(16) NULL,
	`SameShipAddrOk` varchar(5) NULL,
	`MergedFrom_ListID` varchar(36) NULL,
	`MergedFrom_TimeDeleted` datetime NULL,
	`MergedFrom_FullName` varchar(255) NULL,
	`MergedTo_ListID` varchar(36) NULL,
	`MergedTo_TimeCreated` datetime NULL,
	`MergedTo_TimeModified` datetime NULL,
	`MergedTo_EditSequence` varchar(16) NULL,
	`MergedTo_FullName` varchar(255) NULL,
	`Operation` varchar(10) NULL
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_0900_ai_ci;



CREATE TABLE `workerscompcode`(
	`ListID` varchar(36) NOT NULL,
	`TimeCreated` datetime DEFAUL T NULL,
	`TimeModified` datetime DEFAULT NULL,
	`EditSequence` varchar(16) DEFAULT NULL,
	`Name` varchar(41) DEFAULT NULL,
	`IsActive` varchar(5) DEFAULT NULL,
	`Desc` varchar(31) DEFAULT NULL,
	`CurrentRate` decimal(15, 5) DEFAULT NULL,
	`CurrentEffectiveDate` datetime DEFAULT NULL,
	`NextRate` decimal(15, 5) DEFAULT NULL,
	`UserData` varchar(255) DEFAULT NULL,
	`Operation` varchar(10) DEFAULT NULL,
	`LSData` varchar(10) DEFAULT NULL,
  UNIQUE KEY `workerscompcodeIdIndex` (`ListID`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_0900_ai_ci;