SQL 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 [dbo].[account](
	[ListID] [varchar](36) NOT NULL,
	[TimeCreated] [datetime] NULL,
	[TimeModified] [datetime] NULL,	[EditSequence] [varchar](16) NULL,
	[Name] [varchar](31) NULL,
	[FullName] [varchar](159) NULL,
	[IsActive] [bit] NULL,
	[ParentRef_ListID] [varchar](36) NULL,
	[ParentRef_FullName] [varchar](255) NULL,
	[Sublevel] [int] NULL,
	[AccountType] [varchar](255) NULL,
	[SpecialAccountType] [varchar](255) NULL,
	[IsTaxAccount] [bit] NULL,
	[AccountNumber] [varchar](7) NULL,
	[BankNumber] [varchar](25) NULL,
	[Desc] [varchar](200) NULL,
	[Balance] [decimal](15, 2) NULL,
	[TotalBalance] [decimal](15, 2) NULL,
	[OpenBalance] [decimal](15, 2) NULL,
	[OpenBalanceDate] [datetime] NULL,
	[CashFlowClassification] [varchar](255) NULL,
	[SalesTaxCodeRef_ListID] [varchar](36) NULL,
	[SalesTaxCodeRef_FullName] [varchar](3) NULL,
	[TaxLineID] [int] NULL,
	[TaxLineName] [varchar](255) NULL,
	[CurrencyRef_ListID] [varchar](36) NULL,
	[CurrencyRef_FullName] [varchar](64) NULL,
	[UserData] [varchar](255) NULL,
	[Operation] [varchar](10) NULL,
	[LSData] [varchar](10) NULL,
 CONSTRAINT [PK_account] PRIMARY KEY CLUSTERED 
(
	[ListID] ASC
)WITH (PAD_INDEX = OFF, STATISTICS_NORECOMPUTE = OFF, IGNORE_DUP_KEY = OFF, ALLOW_ROW_LOCKS = ON, ALLOW_PAGE_LOCKS = ON, OPTIMIZE_FOR_SEQUENTIAL_KEY = OFF) ON [PRIMARY]
) ON [PRIMARY]
GO



CREATE TABLE [dbo].[additionalcontactret](
	[ContactName] [varchar](40) NULL,
	[ContactValue] [varchar](255) NULL,
	[PARENT_IDKEY] [varchar](36) NULL,
	[SeqNum] [int] NULL,
	[LSData] [varchar](10) NULL
) ON [PRIMARY]
GO



CREATE TABLE [dbo].[additionalnotesret](
	[NoteID] [int] NULL,
	[DateNote] [datetime] NULL,
	[Notes] [varchar](4095) NULL,
	[PARENT_IDKEY] [varchar](36) NULL,
	[SeqNum] [int] NULL,
	[LSData] [varchar](10) NULL
) ON [PRIMARY]
GO



CREATE TABLE [dbo].[appliedtotxnret](
	[TxnID] [varchar](36) NOT NULL,
	[TxnType] [varchar](255) NULL,
	[TxnDate] [datetime] NULL,
	[RefNumber] [varchar](25) NULL,
	[BalanceRemaining] [decimal](15, 2) NULL,
	[CreditRemaining] [decimal](15, 5) NULL,
	[CreditRemainingInHomeCurrency] [decimal](15, 5) NULL,
	[RefundAmountInHomeCurrency] [decimal](15, 2) NULL,
	[Amount] [decimal](15, 2) NULL,
	[DiscountAmount] [decimal](15, 2) NULL,
	[DiscountAccountRef_ListID] [varchar](255) NULL,
	[DiscountAccountRef_FullName] [varchar](255) NULL,
	[DiscountClassRef_ListID] [varchar](36) NULL,
	[DiscountClassRef_FullName] [varchar](159) NULL,
	[CustomField1] [varchar](255) NULL,
	[CustomField2] [varchar](255) NULL,
	[CustomField3] [varchar](255) NULL,
	[CustomField4] [varchar](255) NULL,
	[CustomField5] [varchar](255) NULL,
	[CustomField6] [varchar](255) NULL,
	[CustomField7] [varchar](255) NULL,
	[CustomField8] [varchar](255) NULL,
	[CustomField9] [varchar](255) NULL,
	[CustomField10] [varchar](255) NULL,
	[CustomField11] [varchar](255) NULL,
	[CustomField12] [varchar](255) NULL,
	[CustomField13] [varchar](255) NULL,
	[CustomField14] [varchar](255) NULL,
	[CustomField15] [varchar](255) NULL,
	[PARENT_IDKEY] [varchar](36) NULL,
	[SeqNum] [int] NULL,
	[UserData] [varchar](255) NULL,
	[LSData] [varchar](10) NULL
) ON [PRIMARY]
GO




CREATE TABLE [dbo].[arrefundcreditcard](
	[TxnID] [varchar](36) NOT NULL,
	[TimeCreated] [datetime] NULL,
	[TimeModified] [datetime] NULL,
	[EditSequence] [varchar](16) NULL,
	[TxnNumber] [int] NULL,
	[CustomerRef_ListID] [varchar](36) NULL,
	[CustomerRef_FullName] [varchar](209) NULL,
	[RefundFromAccountRef_ListID] [varchar](36) NULL,
	[RefundFromAccountRef_FullName] [varchar](159) NULL,
	[ARAccountRef_ListID] [varchar](36) NULL,
	[ARAccountRef_FullName] [varchar](159) NULL,
	[TxnDate] [datetime] NULL,
	[RefNumber] [varchar](25) NULL,
	[TotalAmount] [decimal](15, 2) NULL,
	[Address_Addr1] [varchar](41) NULL,
	[Address_Addr2] [varchar](41) NULL,
	[Address_Addr3] [varchar](41) NULL,
	[Address_Addr4] [varchar](41) NULL,
	[Address_Addr5] [varchar](41) NULL,
	[Address_City] [varchar](31) NULL,
	[Address_State] [varchar](21) NULL,
	[Address_PostalCode] [varchar](13) NULL,
	[Address_Country] [varchar](31) NULL,
	[Address_Note] [varchar](41) NULL,
	[PaymentMethodRef_ListID] [varchar](36) NULL,
	[PaymentMethodRef_FullName] [varchar](31) NULL,
	[Memo] [varchar](4095) NULL,
	[CCTII_CreditCardNumber] [varchar](25) NULL,
	[CCTII_ExpirationMonth] [int] NULL,
	[CCTII_ExpirationYear] [int] NULL,
	[CCTII_NameOnCard] [varchar](41) NULL,
	[CCTII_CreditCardAddress] [varchar](41) NULL,
	[CCTII_CreditCardPostalCode] [varchar](18) NULL,
	[CCTII_CommercialCardCode] [varchar](24) NULL,
	[CCTII_TransactionMode] [varchar](255) NULL,
	[CCTII_CreditCardTxnType] [varchar](255) NULL,
	[CCTRI_ResultCode] [int] NULL,
	[CCTRI_ResultMessage] [varchar](60) NULL,
	[CCTRI_CreditCardTransID] [varchar](24) NULL,
	[CCTRI_MerchantAccountNumber] [varchar](32) NULL,
	[CCTRI_AuthorizationCode] [varchar](12) NULL,
	[CCTRI_AVSStreet] [varchar](255) NULL,
	[CCTRI_AVSZip] [varchar](255) NULL,
	[CCTRI_CardSecurityCodeMatch] [varchar](255) NULL,
	[CCTRI_ReconBatchID] [varchar](84) NULL,
	[CCTRI_PaymentGroupingCode] [int] NULL,
	[CCTRI_PaymentStatus] [varchar](255) NULL,
	[CCTRI_TxnAuthorizationTime] [datetime] NULL,
	[CCTRI_TxnAuthorizationStamp] [int] NULL,
	[CCTRI_ClientTransID] [varchar](16) NULL,
	[TotalAmountInHomeCurrency] [decimal](15, 2) NULL,
	[ExchangeRate] [decimal](15, 5) NULL,
	[CurrencyRef_ListID] [varchar](36) NULL,
	[CurrencyRef_FullName] [varchar](64) NULL,
	[ExternalGUID] [varchar](255) NULL,
	[UserData] [varchar](255) NULL,
	[Operation] [varchar](10) NULL,
	[LSData] [varchar](10) NULL,
 CONSTRAINT [PK_arrefundcreditcard] PRIMARY KEY CLUSTERED 
(
	[TxnID] ASC
)WITH (PAD_INDEX = OFF, STATISTICS_NORECOMPUTE = OFF, IGNORE_DUP_KEY = OFF, ALLOW_ROW_LOCKS = ON, ALLOW_PAGE_LOCKS = ON, OPTIMIZE_FOR_SEQUENTIAL_KEY = OFF) ON [PRIMARY]
) ON [PRIMARY]
GO




CREATE TABLE [dbo].[bill](
	[TxnID] [varchar](36) NOT NULL,
	[TimeCreated] [datetime] NULL,
	[TimeModified] [datetime] NULL,
	[EditSequence] [varchar](16) NULL,
	[TxnNumber] [int] NULL,
	[VendorRef_ListID] [varchar](36) NULL,
	[VendorRef_FullName] [varchar](41) NULL,
	[VendorAddress_Addr1] [varchar](41) NULL,
	[VendorAddress_Addr2] [varchar](41) NULL,
	[VendorAddress_Addr3] [varchar](41) NULL,
	[VendorAddress_Addr4] [varchar](41) NULL,
	[VendorAddress_Addr5] [varchar](41) NULL,
	[VendorAddress_City] [varchar](31) NULL,
	[VendorAddress_State] [varchar](21) NULL,
	[VendorAddress_PostalCode] [varchar](13) NULL,
	[VendorAddress_Country] [varchar](31) NULL,
	[VendorAddress_Note] [varchar](41) NULL,
	[APAccountRef_ListID] [varchar](36) NULL,
	[APAccountRef_FullName] [varchar](159) NULL,
	[TxnDate] [datetime] NULL,
	[DueDate] [datetime] NULL,
	[AmountDue] [decimal](15, 2) NULL,
	[CurrencyRef_ListID] [varchar](36) NULL,
	[CurrencyRef_FullName] [varchar](64) NULL,
	[ExchangeRate] [decimal](15, 5) NULL,
	[ClearExpenseLines] [bit] NULL,
	[ClearItemLines] [bit] NULL,
	[AmountDueInHomeCurrency] [decimal](15, 2) NULL,
	[RefNumber] [varchar](20) NULL,
	[TermsRef_ListID] [varchar](36) NULL,
	[TermsRef_FullName] [varchar](31) NULL,
	[Memo] [varchar](4095) NULL,
	[IsTaxIncluded] [bit] NULL,
	[SalesTaxCodeRef_ListID] [varchar](36) NULL,
	[SalesTaxCodeRef_FullName] [varchar](3) NULL,
	[IsPaid] [bit] NULL,
	[OpenAmount] [decimal](15, 2) NULL,
	[ExternalGUID] [varchar](255) NULL,
	[UserData] [varchar](255) NULL,
	[Operation] [varchar](10) NULL,
	[LSData] [varchar](10) NULL,
 CONSTRAINT [PK_bill] PRIMARY KEY CLUSTERED 
(
	[TxnID] ASC
)WITH (PAD_INDEX = OFF, STATISTICS_NORECOMPUTE = OFF, IGNORE_DUP_KEY = OFF, ALLOW_ROW_LOCKS = ON, ALLOW_PAGE_LOCKS = ON, OPTIMIZE_FOR_SEQUENTIAL_KEY = OFF) ON [PRIMARY]
) ON [PRIMARY]
GO



CREATE TABLE [dbo].[billingrate](
	[ListID] [varchar](36) NOT NULL,
	[TimeCreated] [datetime] NULL,
	[TimeModified] [datetime] NULL,
	[EditSequence] [varchar](16) NULL,
	[Name] [varchar](31) NULL,
	[BillingRateType] [varchar](255) NULL,
	[FixedBillingRate] [decimal](15, 5) NULL,
	[UserData] [varchar](255) NULL,
	[Operation] [varchar](10) NULL,
	[LSData] [varchar](10) NULL,
 CONSTRAINT [PK_billingrate] PRIMARY KEY CLUSTERED 
(
	[ListID] ASC
)WITH (PAD_INDEX = OFF, STATISTICS_NORECOMPUTE = OFF, IGNORE_DUP_KEY = OFF, ALLOW_ROW_LOCKS = ON, ALLOW_PAGE_LOCKS = ON, OPTIMIZE_FOR_SEQUENTIAL_KEY = OFF) ON [PRIMARY]
) ON [PRIMARY]
GO



CREATE TABLE [dbo].[billingrateperitemret](
	[ItemRef_ListID] [varchar](36) NULL,
	[ItemRef_FullName] [varchar](159) NULL,
	[CustomRate] [decimal](15, 5) NULL,
	[CustomRatePercent] [decimal](15, 5) NULL,
	[AdjustPercentage] [decimal](15, 5) NULL,
	[AdjustBillingRateRelativeTo] [varchar](255) NULL,
	[PARENT_IDKEY] [varchar](36) NULL,
	[SeqNum] [int] NULL,
	[LSData] [varchar](10) NULL
) ON [PRIMARY]
GO



CREATE TABLE [dbo].[billpaymentcheck](
	[TxnID] [varchar](36) NOT NULL,
	[TimeCreated] [datetime] NULL,
	[TimeModified] [datetime] NULL,
	[EditSequence] [varchar](16) NULL,
	[TxnNumber] [int] NULL,
	[PayeeEntityRef_ListID] [varchar](36) NULL,
	[PayeeEntityRef_FullName] [varchar](209) NULL,
	[APAccountRef_ListID] [varchar](36) NULL,
	[APAccountRef_FullName] [varchar](159) NULL,
	[TxnDate] [datetime] NULL,
	[BankAccountRef_ListID] [varchar](36) NULL,
	[BankAccountRef_FullName] [varchar](159) NULL,
	[Amount] [decimal](15, 2) NULL,
	[CurrencyRef_ListID] [varchar](36) NULL,
	[CurrencyRef_FullName] [varchar](64) NULL,
	[ExchangeRate] [decimal](15, 5) NULL,
	[AmountInHomeCurrency] [decimal](15, 2) NULL,
	[RefNumber] [varchar](25) NULL,
	[Memo] [varchar](4095) NULL,
	[Address_Addr1] [varchar](41) NULL,
	[Address_Addr2] [varchar](41) NULL,
	[Address_Addr3] [varchar](41) NULL,
	[Address_Addr4] [varchar](41) NULL,
	[Address_Addr5] [varchar](41) NULL,
	[Address_City] [varchar](31) NULL,
	[Address_State] [varchar](21) NULL,
	[Address_PostalCode] [varchar](13) NULL,
	[Address_Country] [varchar](31) NULL,
	[Address_Note] [varchar](41) NULL,
	[IsToBePrinted] [bit] NULL,
	[ExternalGUID] [varchar](255) NULL,
	[UserData] [varchar](255) NULL,
	[Operation] [varchar](10) NULL,
	[LSData] [varchar](10) NULL,
 CONSTRAINT [PK_billpaymentcheck] PRIMARY KEY CLUSTERED 
(
	[TxnID] ASC
)WITH (PAD_INDEX = OFF, STATISTICS_NORECOMPUTE = OFF, IGNORE_DUP_KEY = OFF, ALLOW_ROW_LOCKS = ON, ALLOW_PAGE_LOCKS = ON, OPTIMIZE_FOR_SEQUENTIAL_KEY = OFF) ON [PRIMARY]
) ON [PRIMARY]
GO



CREATE TABLE [dbo].[billpaymentcreditcard](
	[TxnID] [varchar](36) NOT NULL,
	[TimeCreated] [datetime] NULL,
	[TimeModified] [datetime] NULL,
	[EditSequence] [varchar](16) NULL,
	[TxnNumber] [int] NULL,
	[PayeeEntityRef_ListID] [varchar](36) NULL,
	[PayeeEntityRef_FullName] [varchar](209) NULL,
	[APAccountRef_ListID] [varchar](36) NULL,
	[APAccountRef_FullName] [varchar](159) NULL,
	[TxnDate] [datetime] NULL,
	[CreditCardAccountRef_ListID] [varchar](36) NULL,
	[CreditCardAccountRef_FullName] [varchar](159) NULL,
	[Amount] [decimal](15, 2) NULL,
	[CurrencyRef_ListID] [varchar](36) NULL,
	[CurrencyRef_FullName] [varchar](64) NULL,
	[ExchangeRate] [decimal](15, 5) NULL,
	[AmountInHomeCurrency] [decimal](15, 2) NULL,
	[RefNumber] [varchar](25) NULL,
	[Memo] [varchar](4095) NULL,
	[ExternalGUID] [varchar](255) NULL,
	[UserData] [varchar](255) NULL,
	[Operation] [varchar](10) NULL,
	[LSData] [varchar](10) NULL,
 CONSTRAINT [PK_billpaymentcreditcard] PRIMARY KEY CLUSTERED 
(
	[TxnID] ASC
)WITH (PAD_INDEX = OFF, STATISTICS_NORECOMPUTE = OFF, IGNORE_DUP_KEY = OFF, ALLOW_ROW_LOCKS = ON, ALLOW_PAGE_LOCKS = ON, OPTIMIZE_FOR_SEQUENTIAL_KEY = OFF) ON [PRIMARY]
) ON [PRIMARY]
GO




CREATE TABLE [dbo].[buildassembly](
	[TxnID] [varchar](36) NOT NULL,
	[TimeCreated] [datetime] NULL,
	[TimeModified] [datetime] NULL,
	[EditSequence] [varchar](16) NULL,
	[TxnNumber] [int] NULL,
	[ItemInvAssemblyRef_ListID] [varchar](36) NULL,
	[ItemInvAssemblyRef_FullName] [varchar](159) NULL,
	[InvSiteRef_ListID] [varchar](36) NULL,
	[InvSiteRef_FullName] [varchar](31) NULL,
	[InvSiteLocRef_ListID] [varchar](36) NULL,
	[InvSiteLocRef_FullName] [varchar](31) NULL,
	[SerialNumber] [varchar](4095) NULL,
	[LotNumber] [varchar](40) NULL,
	[TxnDate] [datetime] NULL,
	[RefNumber] [varchar](25) NULL,
	[Memo] [varchar](4095) NULL,
	[IsPending] [bit] NULL,
	[QuantityToBuild] [decimal](15, 5) NULL,
	[QuantityCanBuild] [decimal](15, 5) NULL,
	[QuantityOnHand] [decimal](15, 5) NULL,
	[QuantityOnSalesOrder] [decimal](15, 5) NULL,
	[MarkPendingIfRequired] [bit] NULL,
	[ExternalGUID] [varchar](255) NULL,
	[UserData] [varchar](255) NULL,
	[Operation] [varchar](10) NULL,
	[LSData] [varchar](10) NULL,
 CONSTRAINT [PK_buildassembly] PRIMARY KEY CLUSTERED 
(
	[TxnID] ASC
)WITH (PAD_INDEX = OFF, STATISTICS_NORECOMPUTE = OFF, IGNORE_DUP_KEY = OFF, ALLOW_ROW_LOCKS = ON, ALLOW_PAGE_LOCKS = ON, OPTIMIZE_FOR_SEQUENTIAL_KEY = OFF) ON [PRIMARY]
) ON [PRIMARY]
GO



CREATE TABLE [dbo].[cashbackinforet](
	[TxnLineID] [varchar](36) NULL,
	[AccountRef_ListID] [varchar](36) NULL,
	[AccountRef_FullName] [varchar](159) NULL,
	[Memo] [varchar](4095) NULL,
	[Amount] [decimal](15, 2) NULL,
	[PARENT_IDKEY] [varchar](36) NULL,
	[SeqNum] [int] NULL,
	[LSData] [varchar](10) NULL
) ON [PRIMARY]
GO




CREATE TABLE [dbo].[charge](
	[TxnID] [varchar](36) NOT NULL,
	[TimeCreated] [datetime] NULL,
	[TimeModified] [datetime] NULL,
	[EditSequence] [varchar](16) NULL,
	[TxnNumber] [int] NULL,
	[CustomerRef_ListID] [varchar](36) NULL,
	[CustomerRef_FullName] [varchar](209) NULL,
	[TxnDate] [datetime] NULL,
	[RefNumber] [varchar](25) NULL,
	[ItemRef_ListID] [varchar](36) NULL,
	[ItemRef_FullName] [varchar](159) NULL,
	[InvSiteRef_ListID] [varchar](36) NULL,
	[InvSiteRef_FullName] [varchar](31) NULL,
	[InvSiteLocRef_ListID] [varchar](36) NULL,
	[InvSiteLocRef_FullName] [varchar](31) NULL,
	[Quantity] [decimal](15, 5) NULL,
	[UnitOfMeasure] [varchar](31) NULL,
	[OverrideUOMSetRef_ListID] [varchar](36) NULL,
	[OverrideUOMSetRef_FullName] [varchar](31) NULL,
	[Rate] [decimal](15, 5) NULL,
	[Amount] [decimal](15, 2) NULL,
	[BalanceRemaining] [decimal](15, 2) NULL,
	[Desc] [varchar](4095) NULL,
	[ARAccountRef_ListID] [varchar](36) NULL,
	[ARAccountRef_FullName] [varchar](159) NULL,
	[ClassRef_ListID] [varchar](36) NULL,
	[ClassRef_FullName] [varchar](159) NULL,
	[BilledDate] [datetime] NULL,
	[DueDate] [datetime] NULL,
	[IsPaid] [bit] NULL,
	[ExternalGUID] [varchar](255) NULL,
	[UserData] [varchar](255) NULL,
	[Operation] [varchar](10) NULL,
	[LSData] [varchar](10) NULL,
 CONSTRAINT [PK_charge] PRIMARY KEY CLUSTERED 
(
	[TxnID] ASC
)WITH (PAD_INDEX = OFF, STATISTICS_NORECOMPUTE = OFF, IGNORE_DUP_KEY = OFF, ALLOW_ROW_LOCKS = ON, ALLOW_PAGE_LOCKS = ON, OPTIMIZE_FOR_SEQUENTIAL_KEY = OFF) ON [PRIMARY]
) ON [PRIMARY]
GO



CREATE TABLE [dbo].[check](
	[TxnID] [varchar](36) NOT NULL,
	[TimeCreated] [datetime] NULL,
	[TimeModified] [datetime] NULL,
	[EditSequence] [varchar](16) NULL,
	[TxnNumber] [int] NULL,
	[AccountRef_ListID] [varchar](36) NULL,
	[AccountRef_FullName] [varchar](159) NULL,
	[PayeeEntityRef_ListID] [varchar](36) NULL,
	[PayeeEntityRef_FullName] [varchar](209) NULL,
	[RefNumber] [varchar](25) NULL,
	[TxnDate] [datetime] NULL,
	[Amount] [decimal](15, 2) NULL,
	[CurrencyRef_ListID] [varchar](36) NULL,
	[CurrencyRef_FullName] [varchar](64) NULL,
	[ExchangeRate] [decimal](15, 5) NULL,
	[AmountInHomeCurrency] [decimal](15, 2) NULL,
	[Memo] [varchar](4095) NULL,
	[Address_Addr1] [varchar](41) NULL,
	[Address_Addr2] [varchar](41) NULL,
	[Address_Addr3] [varchar](41) NULL,
	[Address_Addr4] [varchar](41) NULL,
	[Address_Addr5] [varchar](41) NULL,
	[Address_City] [varchar](31) NULL,
	[Address_State] [varchar](21) NULL,
	[Address_PostalCode] [varchar](13) NULL,
	[Address_Country] [varchar](31) NULL,
	[Address_Note] [varchar](41) NULL,
	[IsToBePrinted] [bit] NULL,
	[IsTaxIncluded] [bit] NULL,
	[SalesTaxCodeRef_ListID] [varchar](36) NULL,
	[SalesTaxCodeRef_FullName] [varchar](3) NULL,
	[ExternalGUID] [varchar](255) NULL,
	[UserData] [varchar](255) NULL,
	[Operation] [varchar](10) NULL,
	[LSData] [varchar](10) NULL,
 CONSTRAINT [PK_check] PRIMARY KEY CLUSTERED 
(
	[TxnID] ASC
)WITH (PAD_INDEX = OFF, STATISTICS_NORECOMPUTE = OFF, IGNORE_DUP_KEY = OFF, ALLOW_ROW_LOCKS = ON, ALLOW_PAGE_LOCKS = ON, OPTIMIZE_FOR_SEQUENTIAL_KEY = OFF) ON [PRIMARY]
) ON [PRIMARY]
GO



CREATE TABLE [dbo].[class](
	[ListID] [varchar](36) NOT NULL,
	[TimeCreated] [datetime] NULL,
	[TimeModified] [datetime] NULL,
	[EditSequence] [varchar](16) NULL,
	[Name] [varchar](31) NULL,
	[FullName] [varchar](159) NULL,
	[IsActive] [bit] NULL,
	[ParentRef_ListID] [varchar](36) NULL,
	[ParentRef_FullName] [varchar](159) NULL,
	[Sublevel] [int] NULL,
	[UserData] [varchar](255) NULL,
	[Operation] [varchar](10) NULL,
	[LSData] [varchar](10) NULL,
 CONSTRAINT [PK_class] PRIMARY KEY CLUSTERED 
(
	[ListID] ASC
)WITH (PAD_INDEX = OFF, STATISTICS_NORECOMPUTE = OFF, IGNORE_DUP_KEY = OFF, ALLOW_ROW_LOCKS = ON, ALLOW_PAGE_LOCKS = ON, OPTIMIZE_FOR_SEQUENTIAL_KEY = OFF) ON [PRIMARY]
) ON [PRIMARY]
GO




CREATE TABLE [dbo].[company](
	[IsSampleCompany] [bit] NULL,
	[CompanyName] [varchar](59) NULL,
	[LegalCompanyName] [varchar](59) NULL,
	[Address_Addr1] [varchar](41) NULL,
	[Address_Addr2] [varchar](41) NULL,
	[Address_Addr3] [varchar](41) NULL,
	[Address_Addr4] [varchar](41) NULL,
	[Address_Addr5] [varchar](41) NULL,
	[Address_City] [varchar](31) NULL,
	[Address_State] [varchar](21) NULL,
	[Address_PostalCode] [varchar](13) NULL,
	[Address_Country] [varchar](31) NULL,
	[Address_Note] [varchar](41) NULL,
	[LegalAddress_Addr1] [varchar](41) NULL,
	[LegalAddress_Addr2] [varchar](41) NULL,
	[LegalAddress_Addr3] [varchar](41) NULL,
	[LegalAddress_Addr4] [varchar](41) NULL,
	[LegalAddress_Addr5] [varchar](41) NULL,
	[LegalAddress_City] [varchar](31) NULL,
	[LegalAddress_State] [varchar](21) NULL,
	[LegalAddress_PostalCode] [varchar](13) NULL,
	[LegalAddress_Country] [varchar](31) NULL,
	[LegalAddress_Note] [varchar](41) NULL,
	[AddressCust_Addr1] [varchar](41) NULL,
	[AddressCust_Addr2] [varchar](41) NULL,
	[AddressCust_Addr3] [varchar](41) NULL,
	[AddressCust_Addr4] [varchar](41) NULL,
	[AddressCust_Addr5] [varchar](41) NULL,
	[AddressCust_City] [varchar](31) NULL,
	[AddressCust_State] [varchar](21) NULL,
	[AddressCust_PostalCode] [varchar](13) NULL,
	[AddressCust_Country] [varchar](31) NULL,
	[AddressCust_Note] [varchar](41) NULL,
	[AddressBlockCust_Addr1] [varchar](41) NULL,
	[AddressBlockCust_Addr2] [varchar](41) NULL,
	[AddressBlockCust_Addr3] [varchar](41) NULL,
	[AddressBlockCust_Addr4] [varchar](41) NULL,
	[AddressBlockCust_Addr5] [varchar](41) NULL,
	[Phone] [varchar](51) NULL,
	[Fax] [varchar](51) NULL,
	[Email] [varchar](4095) NULL,
	[CompanyWebSite] [varchar](128) NULL,
	[FirstMonthFiscalYear] [varchar](255) NULL,
	[FirstMonthIncomeTaxYear] [varchar](255) NULL,
	[CompanyType] [varchar](255) NULL,
	[EIN] [varchar](20) NULL,
	[SSN] [varchar](11) NULL,
	[TaxForm] [varchar](255) NULL,
	[SubscribedServices] [varchar](4095) NULL,
	[AccountantCopy] [bit] NULL,
	[LSData] [varchar](10) NULL
) ON [PRIMARY]
GO




CREATE TABLE [dbo].[componentitemlineret](
	[ItemRef_ListID] [varchar](36) NULL,
	[ItemRef_FullName] [varchar](159) NULL,
	[InvSiteRef_ListID] [varchar](36) NULL,
	[InvSiteRef_FullName] [varchar](31) NULL,
	[InvSiteLocRef_ListID] [varchar](36) NULL,
	[InvSiteLocRef_FullName] [varchar](31) NULL,
	[Desc] [varchar](4095) NULL,
	[QuantityOnHand] [decimal](15, 5) NULL,
	[QuantityNeeded] [decimal](15, 5) NULL,
	[SerialNumber] [varchar](4095) NULL,
	[LotNumber] [varchar](40) NULL,
	[PARENT_IDKEY] [varchar](36) NULL,
	[SeqNum] [int] NULL,
	[LSData] [varchar](10) NULL
) ON [PRIMARY]
GO



CREATE TABLE [dbo].[contactsret](
	[ListID] [varchar](36) NOT NULL,
	[TimeCreated] [datetime] NULL,
	[TimeModified] [datetime] NULL,
	[EditSequence] [varchar](16) NULL,
	[Contact] [varchar](41) NULL,
	[Salutation] [varchar](15) NULL,
	[FirstName] [varchar](25) NULL,
	[MiddleName] [varchar](5) NULL,
	[LastName] [varchar](25) NULL,
	[JobTitle] [varchar](41) NULL,
	[PARENT_IDKEY] [varchar](36) NULL,
	[SeqNum] [int] NULL,
	[LSData] [varchar](10) NULL
) ON [PRIMARY]
GO



CREATE TABLE [dbo].[creditcardcharge](
	[TxnID] [varchar](36) NOT NULL,
	[TimeCreated] [datetime] NULL,
	[TimeModified] [datetime] NULL,
	[EditSequence] [varchar](16) NULL,
	[TxnNumber] [int] NULL,
	[AccountRef_ListID] [varchar](36) NULL,
	[AccountRef_FullName] [varchar](159) NULL,
	[PayeeEntityRef_ListID] [varchar](36) NULL,
	[PayeeEntityRef_FullName] [varchar](209) NULL,
	[TxnDate] [datetime] NULL,
	[Amount] [decimal](15, 2) NULL,
	[CurrencyRef_ListID] [varchar](36) NULL,
	[CurrencyRef_FullName] [varchar](64) NULL,
	[ExchangeRate] [decimal](15, 5) NULL,
	[AmountInHomeCurrency] [decimal](15, 2) NULL,
	[RefNumber] [varchar](25) NULL,
	[Memo] [varchar](4095) NULL,
	[IsTaxIncluded] [bit] NULL,
	[SalesTaxCodeRef_ListID] [varchar](36) NULL,
	[SalesTaxCodeRef_FullName] [varchar](3) NULL,
	[ExternalGUID] [varchar](255) NULL,
	[UserData] [varchar](255) NULL,
	[Operation] [varchar](10) NULL,
	[LSData] [varchar](10) NULL,
 CONSTRAINT [PK_creditcardcharge] PRIMARY KEY CLUSTERED 
(
	[TxnID] ASC
)WITH (PAD_INDEX = OFF, STATISTICS_NORECOMPUTE = OFF, IGNORE_DUP_KEY = OFF, ALLOW_ROW_LOCKS = ON, ALLOW_PAGE_LOCKS = ON, OPTIMIZE_FOR_SEQUENTIAL_KEY = OFF) ON [PRIMARY]
) ON [PRIMARY]
GO



CREATE TABLE [dbo].[creditcardcredit](
	[TxnID] [varchar](36) NOT NULL,
	[TimeCreated] [datetime] NULL,
	[TimeModified] [datetime] NULL,
	[EditSequence] [varchar](16) NULL,
	[TxnNumber] [int] NULL,
	[AccountRef_ListID] [varchar](36) NULL,
	[AccountRef_FullName] [varchar](159) NULL,
	[PayeeEntityRef_ListID] [varchar](36) NULL,
	[PayeeEntityRef_FullName] [varchar](209) NULL,
	[TxnDate] [datetime] NULL,
	[Amount] [decimal](15, 2) NULL,
	[CurrencyRef_ListID] [varchar](36) NULL,
	[CurrencyRef_FullName] [varchar](64) NULL,
	[ExchangeRate] [decimal](15, 5) NULL,
	[AmountInHomeCurrency] [decimal](15, 2) NULL,
	[RefNumber] [varchar](25) NULL,
	[Memo] [varchar](4095) NULL,
	[IsTaxIncluded] [bit] NULL,
	[SalesTaxCodeRef_ListID] [varchar](36) NULL,
	[SalesTaxCodeRef_FullName] [varchar](3) NULL,
	[ExternalGUID] [varchar](255) NULL,
	[UserData] [varchar](255) NULL,
	[Operation] [varchar](10) NULL,
	[LSData] [varchar](10) NULL,
 CONSTRAINT [PK_creditcardcredit] PRIMARY KEY CLUSTERED 
(
	[TxnID] ASC
)WITH (PAD_INDEX = OFF, STATISTICS_NORECOMPUTE = OFF, IGNORE_DUP_KEY = OFF, ALLOW_ROW_LOCKS = ON, ALLOW_PAGE_LOCKS = ON, OPTIMIZE_FOR_SEQUENTIAL_KEY = OFF) ON [PRIMARY]
) ON [PRIMARY]
GO



CREATE TABLE [dbo].[creditmemo](
	[TxnID] [varchar](36) NOT NULL,
	[TimeCreated] [datetime] NULL,
	[TimeModified] [datetime] NULL,
	[EditSequence] [varchar](16) NULL,
	[TxnNumber] [int] NULL,
	[CustomerRef_ListID] [varchar](36) NULL,
	[CustomerRef_FullName] [varchar](209) NULL,
	[ClassRef_ListID] [varchar](36) NULL,
	[ClassRef_FullName] [varchar](159) NULL,
	[ARAccountRef_ListID] [varchar](36) NULL,
	[ARAccountRef_FullName] [varchar](159) NULL,
	[TemplateRef_ListID] [varchar](36) NULL,
	[TemplateRef_FullName] [varchar](31) NULL,
	[TxnDate] [datetime] NULL,
	[RefNumber] [varchar](25) NULL,
	[BillAddress_Addr1] [varchar](41) NULL,
	[BillAddress_Addr2] [varchar](41) NULL,
	[BillAddress_Addr3] [varchar](41) NULL,
	[BillAddress_Addr4] [varchar](41) NULL,
	[BillAddress_Addr5] [varchar](41) NULL,
	[BillAddress_City] [varchar](31) NULL,
	[BillAddress_State] [varchar](21) NULL,
	[BillAddress_PostalCode] [varchar](13) NULL,
	[BillAddress_Country] [varchar](31) NULL,
	[BillAddress_Note] [varchar](41) NULL,
	[ShipAddress_Addr1] [varchar](41) NULL,
	[ShipAddress_Addr2] [varchar](41) NULL,
	[ShipAddress_Addr3] [varchar](41) NULL,
	[ShipAddress_Addr4] [varchar](41) NULL,
	[ShipAddress_Addr5] [varchar](41) NULL,
	[ShipAddress_City] [varchar](31) NULL,
	[ShipAddress_State] [varchar](21) NULL,
	[ShipAddress_PostalCode] [varchar](13) NULL,
	[ShipAddress_Country] [varchar](31) NULL,
	[ShipAddress_Note] [varchar](41) NULL,
	[IsPending] [bit] NULL,
	[PONumber] [varchar](25) NULL,
	[TermsRef_ListID] [varchar](36) NULL,
	[TermsRef_FullName] [varchar](31) NULL,
	[DueDate] [datetime] NULL,
	[SalesRepRef_ListID] [varchar](36) NULL,
	[SalesRepRef_FullName] [varchar](5) NULL,
	[FOB] [varchar](13) NULL,
	[ShipDate] [datetime] NULL,
	[ShipMethodRef_ListID] [varchar](36) NULL,
	[ShipMethodRef_FullName] [varchar](15) NULL,
	[Subtotal] [decimal](15, 2) NULL,
	[ItemSalesTaxRef_ListID] [varchar](36) NULL,
	[ItemSalesTaxRef_FullName] [varchar](31) NULL,
	[SalesTaxPercentage] [decimal](15, 5) NULL,
	[SalesTaxTotal] [decimal](15, 2) NULL,
	[TotalAmount] [decimal](15, 2) NULL,
	[CreditRemaining] [decimal](15, 5) NULL,
	[CurrencyRef_ListID] [varchar](36) NULL,
	[CurrencyRef_FullName] [varchar](64) NULL,
	[ExchangeRate] [decimal](15, 5) NULL,
	[CreditRemainingInHomeCurrency] [decimal](15, 5) NULL,
	[Memo] [varchar](4095) NULL,
	[CustomerMsgRef_ListID] [varchar](36) NULL,
	[CustomerMsgRef_FullName] [varchar](101) NULL,
	[IsToBePrinted] [bit] NULL,
	[IsToBeEmailed] [bit] NULL,
	[IsTaxIncluded] [bit] NULL,
	[CustSalesTaxCodeRef_ListID] [varchar](36) NULL,
	[CustSalesTaxCodeRef_FullName] [varchar](3) NULL,
	[Other] [varchar](29) NULL,
	[ExternalGUID] [varchar](255) NULL,
	[CustomField1] [varchar](255) NULL,
	[CustomField2] [varchar](255) NULL,
	[CustomField3] [varchar](255) NULL,
	[CustomField4] [varchar](255) NULL,
	[CustomField5] [varchar](255) NULL,
	[CustomField6] [varchar](255) NULL,
	[CustomField7] [varchar](255) NULL,
	[CustomField8] [varchar](255) NULL,
	[CustomField9] [varchar](255) NULL,
	[CustomField10] [varchar](255) NULL,
	[CustomField11] [varchar](255) NULL,
	[CustomField12] [varchar](255) NULL,
	[CustomField13] [varchar](255) NULL,
	[CustomField14] [varchar](255) NULL,
	[CustomField15] [varchar](255) NULL,
	[UserData] [varchar](255) NULL,
	[Operation] [varchar](10) NULL,
	[LSData] [varchar](10) NULL,
 CONSTRAINT [PK_creditmemo] PRIMARY KEY CLUSTERED 
(
	[TxnID] ASC
)WITH (PAD_INDEX = OFF, STATISTICS_NORECOMPUTE = OFF, IGNORE_DUP_KEY = OFF, ALLOW_ROW_LOCKS = ON, ALLOW_PAGE_LOCKS = ON, OPTIMIZE_FOR_SEQUENTIAL_KEY = OFF) ON [PRIMARY]
) ON [PRIMARY]
GO




CREATE TABLE [dbo].[creditmemolinegroupret](
	[TxnLineID] [varchar](36) NULL,
	[ItemGroupRef_ListID] [varchar](36) NULL,
	[ItemGroupRef_FullName] [varchar](31) NULL,
	[Desc] [varchar](4095) NULL,
	[Quantity] [decimal](15, 5) NULL,
	[IsPrintItemsInGroup] [bit] NULL,
	[TotalAmount] [decimal](15, 2) NULL,
	[ServiceDate] [datetime] NULL,
	[OverrideUOMSetRef_ListID] [varchar](36) NULL,
	[OverrideUOMSetRef_FullName] [varchar](31) NULL,
	[UnitOfMeasure] [varchar](31) NULL,
	[CustomField1] [varchar](255) NULL,
	[CustomField2] [varchar](255) NULL,
	[CustomField3] [varchar](255) NULL,
	[CustomField4] [varchar](255) NULL,
	[CustomField5] [varchar](255) NULL,
	[CustomField6] [varchar](255) NULL,
	[CustomField7] [varchar](255) NULL,
	[CustomField8] [varchar](255) NULL,
	[CustomField9] [varchar](255) NULL,
	[CustomField10] [varchar](255) NULL,
	[CustomField11] [varchar](255) NULL,
	[CustomField12] [varchar](255) NULL,
	[CustomField13] [varchar](255) NULL,
	[CustomField14] [varchar](255) NULL,
	[CustomField15] [varchar](255) NULL,
	[PARENT_IDKEY] [varchar](36) NULL,
	[GroupPARENT_IDKEY] [varchar](255) NULL,
	[SeqNum] [int] NULL,
	[LSData] [varchar](10) NULL
) ON [PRIMARY]
GO



CREATE TABLE [dbo].[creditmemolineret](
	[TxnLineID] [varchar](36) NULL,
	[ItemRef_ListID] [varchar](36) NULL,
	[ItemRef_FullName] [varchar](159) NULL,
	[Desc] [varchar](4095) NULL,
	[Quantity] [decimal](15, 5) NULL,
	[UnitOfMeasure] [varchar](31) NULL,
	[OverrideUOMSetRef_ListID] [varchar](36) NULL,
	[OverrideUOMSetRef_FullName] [varchar](31) NULL,
	[Rate] [decimal](15, 5) NULL,
	[RatePercent] [decimal](15, 5) NULL,
	[ClassRef_ListID] [varchar](36) NULL,
	[ClassRef_FullName] [varchar](159) NULL,
	[Amount] [decimal](15, 2) NULL,
	[TaxAmount] [decimal](15, 2) NULL,
	[InvSiteRef_ListID] [varchar](36) NULL,
	[InvSiteRef_FullName] [varchar](31) NULL,
	[InvSiteLocRef_ListID] [varchar](36) NULL,
	[InvSiteLocRef_FullName] [varchar](31) NULL,
	[SerialNumber] [varchar](4095) NULL,
	[LotNumber] [varchar](40) NULL,
	[ServiceDate] [datetime] NULL,
	[SalesTaxCodeRef_ListID] [varchar](36) NULL,
	[SalesTaxCodeRef_FullName] [varchar](3) NULL,
	[IsTaxable] [bit] NULL,
	[Other1] [varchar](29) NULL,
	[Other2] [varchar](29) NULL,
	[CCTII_CreditCardNumber] [varchar](25) NULL,
	[CCTII_ExpirationMonth] [int] NULL,
	[CCTII_ExpirationYear] [int] NULL,
	[CCTII_NameOnCard] [varchar](41) NULL,
	[CCTII_CreditCardAddress] [varchar](41) NULL,
	[CCTII_CreditCardPostalCode] [varchar](18) NULL,
	[CCTII_CommercialCardCode] [varchar](24) NULL,
	[CCTII_TransactionMode] [varchar](255) NULL,
	[CCTII_CreditCardTxnType] [varchar](255) NULL,
	[CCTRI_ResultCode] [int] NULL,
	[CCTRI_ResultMessage] [varchar](60) NULL,
	[CCTRI_CreditCardTransID] [varchar](24) NULL,
	[CCTRI_MerchantAccountNumber] [varchar](32) NULL,
	[CCTRI_AuthorizationCode] [varchar](12) NULL,
	[CCTRI_AVSStreet] [varchar](255) NULL,
	[CCTRI_AVSZip] [varchar](255) NULL,
	[CCTRI_CardSecurityCodeMatch] [varchar](255) NULL,
	[CCTRI_ReconBatchID] [varchar](84) NULL,
	[CCTRI_PaymentGroupingCode] [int] NULL,
	[CCTRI_PaymentStatus] [varchar](255) NULL,
	[CCTRI_TxnAuthorizationTime] [datetime] NULL,
	[CCTRI_TxnAuthorizationStamp] [int] NULL,
	[CCTRI_ClientTransID] [varchar](16) NULL,
	[CustomField1] [varchar](255) NULL,
	[CustomField2] [varchar](255) NULL,
	[CustomField3] [varchar](255) NULL,
	[CustomField4] [varchar](255) NULL,
	[CustomField5] [varchar](255) NULL,
	[CustomField6] [varchar](255) NULL,
	[CustomField7] [varchar](255) NULL,
	[CustomField8] [varchar](255) NULL,
	[CustomField9] [varchar](255) NULL,
	[CustomField10] [varchar](255) NULL,
	[CustomField11] [varchar](255) NULL,
	[CustomField12] [varchar](255) NULL,
	[CustomField13] [varchar](255) NULL,
	[CustomField14] [varchar](255) NULL,
	[CustomField15] [varchar](255) NULL,
	[PARENT_IDKEY] [varchar](36) NULL,
	[GroupPARENT_IDKEY] [varchar](255) NULL,
	[SeqNum] [int] NULL,
	[LSData] [varchar](10) NULL
) ON [PRIMARY]
GO




CREATE TABLE [dbo].[currency](
	[ListID] [varchar](36) NOT NULL,
	[TimeCreated] [datetime] NULL,
	[TimeModified] [datetime] NULL,
	[EditSequence] [varchar](16) NULL,
	[Name] [varchar](64) NULL,
	[IsActive] [bit] NULL,
	[CurrencyCode] [varchar](3) NULL,
	[ThousandSeparator] [varchar](255) NULL,
	[ThousandSeparatorGrouping] [varchar](255) NULL,
	[DecimalPlaces] [varchar](255) NULL,
	[DecimalSeparator] [varchar](255) NULL,
	[IsUserDefinedCurrency] [bit] NULL,
	[ExchangeRate] [decimal](15, 5) NULL,
	[AsOfDate] [datetime] NULL,
	[UserData] [varchar](255) NULL,
	[Operation] [varchar](10) NULL,
	[LSData] [varchar](10) NULL,
 CONSTRAINT [PK_currency] PRIMARY KEY CLUSTERED 
(
	[ListID] ASC
)WITH (PAD_INDEX = OFF, STATISTICS_NORECOMPUTE = OFF, IGNORE_DUP_KEY = OFF, ALLOW_ROW_LOCKS = ON, ALLOW_PAGE_LOCKS = ON, OPTIMIZE_FOR_SEQUENTIAL_KEY = OFF) ON [PRIMARY]
) ON [PRIMARY]
GO




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



CREATE TABLE [dbo].[customermsg](
	[ListID] [varchar](36) NOT NULL,
	[TimeCreated] [datetime] NULL,
	[TimeModified] [datetime] NULL,
	[EditSequence] [varchar](16) NULL,
	[Name] [varchar](101) NULL,
	[IsActive] [bit] NULL,
	[UserData] [varchar](255) NULL,
	[Operation] [varchar](10) NULL,
	[LSData] [varchar](10) NULL,
 CONSTRAINT [PK_customermsg] PRIMARY KEY CLUSTERED 
(
	[ListID] ASC
)WITH (PAD_INDEX = OFF, STATISTICS_NORECOMPUTE = OFF, IGNORE_DUP_KEY = OFF, ALLOW_ROW_LOCKS = ON, ALLOW_PAGE_LOCKS = ON, OPTIMIZE_FOR_SEQUENTIAL_KEY = OFF) ON [PRIMARY]
) ON [PRIMARY]
GO




CREATE TABLE [dbo].[customertype](
	[ListID] [varchar](36) NOT NULL,
	[TimeCreated] [datetime] NULL,
	[TimeModified] [datetime] NULL,
	[EditSequence] [varchar](16) NULL,
	[Name] [varchar](31) NULL,
	[FullName] [varchar](159) NULL,
	[IsActive] [bit] NULL,
	[ParentRef_ListID] [varchar](36) NULL,
	[ParentRef_FullName] [varchar](209) NULL,
	[Sublevel] [int] NULL,
	[UserData] [varchar](255) NULL,
	[Operation] [varchar](10) NULL,
	[LSData] [varchar](10) NULL,
 CONSTRAINT [PK_customertype] PRIMARY KEY CLUSTERED 
(
	[ListID] ASC
)WITH (PAD_INDEX = OFF, STATISTICS_NORECOMPUTE = OFF, IGNORE_DUP_KEY = OFF, ALLOW_ROW_LOCKS = ON, ALLOW_PAGE_LOCKS = ON, OPTIMIZE_FOR_SEQUENTIAL_KEY = OFF) ON [PRIMARY]
) ON [PRIMARY]
GO



CREATE TABLE [dbo].[dataextdef](
	[DataExtID] [varchar](36) NULL,
	[OwnerID] [varchar](36) NULL,
	[DataExtName] [varchar](31) NULL,
	[DataExtNewName] [varchar](31) NULL,
	[DataExtType] [varchar](255) NULL,
	[AssignToObject] [varchar](255) NULL,
	[RemoveFromObject] [varchar](255) NULL,
	[DataExtListRequire] [bit] NULL,
	[DataExtTxnRequire] [bit] NULL,
	[DataExtFormatString] [varchar](255) NULL,
	[UserData] [varchar](255) NULL,
	[Operation] [varchar](10) NULL,
	[LSData] [varchar](10) NULL
) ON [PRIMARY]
GO




CREATE TABLE [dbo].[datedriventerms](
	[ListID] [varchar](36) NOT NULL,
	[TimeCreated] [datetime] NULL,
	[TimeModified] [datetime] NULL,
	[EditSequence] [varchar](16) NULL,
	[Name] [varchar](31) NULL,
	[IsActive] [bit] NULL,
	[DayOfMonthDue] [int] NULL,
	[DueNextMonthDays] [int] NULL,
	[DiscountDayOfMonth] [int] NULL,
	[DiscountPct] [decimal](15, 5) NULL,
	[UserData] [varchar](255) NULL,
	[Operation] [varchar](10) NULL,
	[LSData] [varchar](10) NULL,
 CONSTRAINT [PK_datedriventerms] PRIMARY KEY CLUSTERED 
(
	[ListID] ASC
)WITH (PAD_INDEX = OFF, STATISTICS_NORECOMPUTE = OFF, IGNORE_DUP_KEY = OFF, ALLOW_ROW_LOCKS = ON, ALLOW_PAGE_LOCKS = ON, OPTIMIZE_FOR_SEQUENTIAL_KEY = OFF) ON [PRIMARY]
) ON [PRIMARY]
GO




CREATE TABLE [dbo].[defaultunitret](
	[UnitUsedFor] [varchar](255) NULL,
	[Unit] [varchar](31) NULL,
	[PARENT_IDKEY] [varchar](36) NULL,
	[SeqNum] [int] NULL,
	[LSData] [varchar](10) NULL
) ON [PRIMARY]
GO




CREATE TABLE [dbo].[deposit](
	[TxnID] [varchar](36) NOT NULL,
	[TimeCreated] [datetime] NULL,
	[TimeModified] [datetime] NULL,
	[EditSequence] [varchar](16) NULL,
	[TxnNumber] [int] NULL,
	[TxnDate] [datetime] NULL,
	[DepositToAccountRef_ListID] [varchar](36) NULL,
	[DepositToAccountRef_FullName] [varchar](159) NULL,
	[Memo] [varchar](4095) NULL,
	[DepositTotal] [decimal](15, 2) NULL,
	[CurrencyRef_ListID] [varchar](36) NULL,
	[CurrencyRef_FullName] [varchar](64) NULL,
	[ExchangeRate] [decimal](15, 5) NULL,
	[DepositTotalInHomeCurrency] [decimal](15, 2) NULL,
	[ExternalGUID] [varchar](255) NULL,
	[UserData] [varchar](255) NULL,
	[Operation] [varchar](10) NULL,
	[LSData] [varchar](10) NULL,
 CONSTRAINT [PK_deposit] PRIMARY KEY CLUSTERED 
(
	[TxnID] ASC
)WITH (PAD_INDEX = OFF, STATISTICS_NORECOMPUTE = OFF, IGNORE_DUP_KEY = OFF, ALLOW_ROW_LOCKS = ON, ALLOW_PAGE_LOCKS = ON, OPTIMIZE_FOR_SEQUENTIAL_KEY = OFF) ON [PRIMARY]
) ON [PRIMARY]
GO




CREATE TABLE [dbo].[depositlineret](
	[TxnType] [varchar](255) NULL,
	[TxnID] [varchar](36) NULL,
	[TxnLineID] [varchar](36) NULL,
	[PaymentTxnLineID] [varchar](36) NULL,
	[EntityRef_ListID] [varchar](36) NULL,
	[EntityRef_FullName] [varchar](209) NULL,
	[AccountRef_ListID] [varchar](36) NULL,
	[AccountRef_FullName] [varchar](159) NULL,
	[Memo] [varchar](4095) NULL,
	[CheckNumber] [varchar](25) NULL,
	[PaymentMethodRef_ListID] [varchar](36) NULL,
	[PaymentMethodRef_FullName] [varchar](31) NULL,
	[ClassRef_ListID] [varchar](36) NULL,
	[ClassRef_FullName] [varchar](159) NULL,
	[Amount] [decimal](15, 2) NULL,
	[PARENT_IDKEY] [varchar](36) NULL,
	[SeqNum] [int] NULL,
	[LSData] [varchar](10) NULL
) ON [PRIMARY]
GO



CREATE TABLE [dbo].[earningsret](
	[PayrollItemWageRef_ListID] [varchar](36) NULL,
	[PayrollItemWageRef_FullName] [varchar](159) NULL,
	[Rate] [decimal](15, 5) NULL,
	[RatePercent] [decimal](15, 5) NULL,
	[PARENT_IDKEY] [varchar](36) NULL,
	[SeqNum] [int] NULL,
	[LSData] [varchar](10) NULL
) ON [PRIMARY]
GO



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




CREATE TABLE [dbo].[entity](
	[ListID] [varchar](36) NOT NULL,
	[FullName] [varchar](159) NULL,
	[TableName] [varchar](159) NULL,
	[UserData] [varchar](255) NULL,
	[Operation] [varchar](10) NULL,
	[LSData] [varchar](10) NULL,
 CONSTRAINT [PK_entity] PRIMARY KEY CLUSTERED 
(
	[ListID] ASC
)WITH (PAD_INDEX = OFF, STATISTICS_NORECOMPUTE = OFF, IGNORE_DUP_KEY = OFF, ALLOW_ROW_LOCKS = ON, ALLOW_PAGE_LOCKS = ON, OPTIMIZE_FOR_SEQUENTIAL_KEY = OFF) ON [PRIMARY]
) ON [PRIMARY]
GO




CREATE TABLE [dbo].[error_table](
	[TimeCreated] [datetime] NULL,
	[IDKEY] [varchar](255) NULL,
	[TableName] [varchar](255) NULL,
	[FunctionFail] [varchar](255) NULL,
	[ErrorMessage] [varchar](4095) NULL,
	[LSData] [varchar](10) NULL
) ON [PRIMARY]
GO




CREATE TABLE [dbo].[estimate](
	[TxnID] [varchar](36) NOT NULL,
	[TimeCreated] [datetime] NULL,
	[TimeModified] [datetime] NULL,
	[EditSequence] [varchar](16) NULL,
	[TxnNumber] [int] NULL,
	[CustomerRef_ListID] [varchar](36) NULL,
	[CustomerRef_FullName] [varchar](209) NULL,
	[ClassRef_ListID] [varchar](36) NULL,
	[ClassRef_FullName] [varchar](159) NULL,
	[TemplateRef_ListID] [varchar](36) NULL,
	[TemplateRef_FullName] [varchar](31) NULL,
	[TxnDate] [datetime] NULL,
	[RefNumber] [varchar](25) NULL,
	[BillAddress_Addr1] [varchar](41) NULL,
	[BillAddress_Addr2] [varchar](41) NULL,
	[BillAddress_Addr3] [varchar](41) NULL,
	[BillAddress_Addr4] [varchar](41) NULL,
	[BillAddress_Addr5] [varchar](41) NULL,
	[BillAddress_City] [varchar](31) NULL,
	[BillAddress_State] [varchar](21) NULL,
	[BillAddress_PostalCode] [varchar](13) NULL,
	[BillAddress_Country] [varchar](31) NULL,
	[BillAddress_Note] [varchar](41) NULL,
	[ShipAddress_Addr1] [varchar](41) NULL,
	[ShipAddress_Addr2] [varchar](41) NULL,
	[ShipAddress_Addr3] [varchar](41) NULL,
	[ShipAddress_Addr4] [varchar](41) NULL,
	[ShipAddress_Addr5] [varchar](41) NULL,
	[ShipAddress_City] [varchar](31) NULL,
	[ShipAddress_State] [varchar](21) NULL,
	[ShipAddress_PostalCode] [varchar](13) NULL,
	[ShipAddress_Country] [varchar](31) NULL,
	[ShipAddress_Note] [varchar](41) NULL,
	[IsActive] [bit] NULL,
	[PONumber] [varchar](25) NULL,
	[TermsRef_ListID] [varchar](36) NULL,
	[TermsRef_FullName] [varchar](31) NULL,
	[DueDate] [datetime] NULL,
	[SalesRepRef_ListID] [varchar](36) NULL,
	[SalesRepRef_FullName] [varchar](5) NULL,
	[FOB] [varchar](13) NULL,
	[Subtotal] [decimal](15, 2) NULL,
	[ItemSalesTaxRef_ListID] [varchar](36) NULL,
	[ItemSalesTaxRef_FullName] [varchar](31) NULL,
	[SalesTaxPercentage] [decimal](15, 5) NULL,
	[SalesTaxTotal] [decimal](15, 2) NULL,
	[TotalAmount] [decimal](15, 2) NULL,
	[CurrencyRef_ListID] [varchar](36) NULL,
	[CurrencyRef_FullName] [varchar](64) NULL,
	[ExchangeRate] [decimal](15, 5) NULL,
	[TotalAmountInHomeCurrency] [decimal](15, 2) NULL,
	[Memo] [varchar](4095) NULL,
	[CustomerMsgRef_ListID] [varchar](36) NULL,
	[CustomerMsgRef_FullName] [varchar](101) NULL,
	[IsToBeEmailed] [bit] NULL,
	[IsTaxIncluded] [bit] NULL,
	[ExternalGUID] [varchar](255) NULL,
	[CustSalesTaxCodeRef_ListID] [varchar](36) NULL,
	[CustSalesTaxCodeRef_FullName] [varchar](3) NULL,
	[Other] [varchar](29) NULL,
	[CustomField1] [varchar](255) NULL,
	[CustomField2] [varchar](255) NULL,
	[CustomField3] [varchar](255) NULL,
	[CustomField4] [varchar](255) NULL,
	[CustomField5] [varchar](255) NULL,
	[CustomField6] [varchar](255) NULL,
	[CustomField7] [varchar](255) NULL,
	[CustomField8] [varchar](255) NULL,
	[CustomField9] [varchar](255) NULL,
	[CustomField10] [varchar](255) NULL,
	[CustomField11] [varchar](255) NULL,
	[CustomField12] [varchar](255) NULL,
	[CustomField13] [varchar](255) NULL,
	[CustomField14] [varchar](255) NULL,
	[CustomField15] [varchar](255) NULL,
	[UserData] [varchar](255) NULL,
	[Operation] [varchar](10) NULL,
	[LSData] [varchar](10) NULL,
 CONSTRAINT [PK_estimate] PRIMARY KEY CLUSTERED 
(
	[TxnID] ASC
)WITH (PAD_INDEX = OFF, STATISTICS_NORECOMPUTE = OFF, IGNORE_DUP_KEY = OFF, ALLOW_ROW_LOCKS = ON, ALLOW_PAGE_LOCKS = ON, OPTIMIZE_FOR_SEQUENTIAL_KEY = OFF) ON [PRIMARY]
) ON [PRIMARY]
GO




CREATE TABLE [dbo].[estimatelinegroupret](
	[TxnLineID] [varchar](36) NULL,
	[ItemGroupRef_ListID] [varchar](36) NULL,
	[ItemGroupRef_FullName] [varchar](31) NULL,
	[Desc] [varchar](4095) NULL,
	[Quantity] [decimal](15, 5) NULL,
	[UnitOfMeasure] [varchar](31) NULL,
	[OverrideUOMSetRef_ListID] [varchar](36) NULL,
	[OverrideUOMSetRef_FullName] [varchar](31) NULL,
	[IsPrintItemsInGroup] [bit] NULL,
	[TotalAmount] [decimal](15, 2) NULL,
	[CustomField1] [varchar](50) NULL,
	[CustomField2] [varchar](50) NULL,
	[CustomField3] [varchar](50) NULL,
	[CustomField4] [varchar](50) NULL,
	[CustomField5] [varchar](50) NULL,
	[CustomField6] [varchar](50) NULL,
	[CustomField7] [varchar](50) NULL,
	[CustomField8] [varchar](50) NULL,
	[CustomField9] [varchar](50) NULL,
	[CustomField10] [varchar](50) NULL,
	[CustomField11] [varchar](50) NULL,
	[CustomField12] [varchar](50) NULL,
	[CustomField13] [varchar](50) NULL,
	[CustomField14] [varchar](50) NULL,
	[CustomField15] [varchar](50) NULL,
	[PARENT_IDKEY] [varchar](36) NULL,
	[GroupPARENT_IDKEY] [varchar](255) NULL,
	[SeqNum] [int] NULL,
	[LSData] [varchar](10) NULL
) ON [PRIMARY]
GO




CREATE TABLE [dbo].[estimatelineret](
	[TxnLineID] [varchar](36) NULL,
	[ItemRef_ListID] [varchar](36) NULL,
	[ItemRef_FullName] [varchar](209) NULL,
	[Desc] [varchar](4095) NULL,
	[Quantity] [decimal](15, 5) NULL,
	[UnitOfMeasure] [varchar](31) NULL,
	[OverrideUOMSetRef_ListID] [varchar](36) NULL,
	[OverrideUOMSetRef_FullName] [varchar](31) NULL,
	[Rate] [decimal](15, 5) NULL,
	[RatePercent] [decimal](15, 5) NULL,
	[ClassRef_ListID] [varchar](36) NULL,
	[ClassRef_FullName] [varchar](159) NULL,
	[Amount] [decimal](15, 2) NULL,
	[TaxAmount] [decimal](15, 2) NULL,
	[InvSiteRef_ListID] [varchar](36) NULL,
	[InvSiteRef_FullName] [varchar](31) NULL,
	[InvSiteLocRef_ListID] [varchar](36) NULL,
	[InvSiteLocRef_FullName] [varchar](31) NULL,
	[SalesTaxCodeRef_ListID] [varchar](36) NULL,
	[SalesTaxCodeRef_FullName] [varchar](3) NULL,
	[MarkupRate] [decimal](15, 5) NULL,
	[MarkupRatePercent] [decimal](15, 5) NULL,
	[Other1] [varchar](29) NULL,
	[Other2] [varchar](29) NULL,
	[CustomField1] [varchar](50) NULL,
	[CustomField2] [varchar](50) NULL,
	[CustomField3] [varchar](50) NULL,
	[CustomField4] [varchar](50) NULL,
	[CustomField5] [varchar](50) NULL,
	[CustomField6] [varchar](50) NULL,
	[CustomField7] [varchar](50) NULL,
	[CustomField8] [varchar](50) NULL,
	[CustomField9] [varchar](50) NULL,
	[CustomField10] [varchar](50) NULL,
	[CustomField11] [varchar](50) NULL,
	[CustomField12] [varchar](50) NULL,
	[CustomField13] [varchar](50) NULL,
	[CustomField14] [varchar](50) NULL,
	[CustomField15] [varchar](50) NULL,
	[PARENT_IDKEY] [varchar](36) NULL,
	[GroupPARENT_IDKEY] [varchar](255) NULL,
	[SeqNum] [int] NULL,
	[LSData] [varchar](10) NULL
) ON [PRIMARY]
GO



CREATE TABLE [dbo].[expenselineret](
	[TxnLineID] [varchar](36) NULL,
	[AccountRef_ListID] [varchar](36) NULL,
	[AccountRef_FullName] [varchar](159) NULL,
	[Amount] [decimal](15, 2) NULL,
	[Memo] [varchar](4095) NULL,
	[CustomerRef_ListID] [varchar](36) NULL,
	[CustomerRef_FullName] [varchar](209) NULL,
	[ClassRef_ListID] [varchar](36) NULL,
	[ClassRef_FullName] [varchar](159) NULL,
	[SalesTaxCodeRef_ListID] [varchar](36) NULL,
	[SalesTaxCodeRef_FullName] [varchar](3) NULL,
	[BillableStatus] [varchar](255) NULL,
	[SalesRepRef_ListID] [varchar](36) NULL,
	[SalesRepRef_FullName] [varchar](5) NULL,
	[CustomField1] [varchar](255) NULL,
	[CustomField2] [varchar](255) NULL,
	[CustomField3] [varchar](255) NULL,
	[CustomField4] [varchar](255) NULL,
	[CustomField5] [varchar](255) NULL,
	[CustomField6] [varchar](255) NULL,
	[CustomField7] [varchar](255) NULL,
	[CustomField8] [varchar](255) NULL,
	[CustomField9] [varchar](255) NULL,
	[CustomField10] [varchar](255) NULL,
	[CustomField11] [varchar](255) NULL,
	[CustomField12] [varchar](255) NULL,
	[CustomField13] [varchar](255) NULL,
	[CustomField14] [varchar](255) NULL,
	[CustomField15] [varchar](255) NULL,
	[PARENT_IDKEY] [varchar](36) NULL,
	[SeqNum] [int] NULL,
	[LSData] [varchar](10) NULL
) ON [PRIMARY]
GO




CREATE TABLE [dbo].[fixedassetsalesinforet](
	[SalesDesc] [varchar](255) NULL,
	[SalesDate] [datetime] NULL,
	[SalesPrice] [varchar](255) NULL,
	[SalesExpense] [varchar](255) NULL,
	[PARENT_IDKEY] [varchar](36) NULL,
	[GroupPARENT_IDKEY] [varchar](255) NULL,
	[LSData] [varchar](10) NULL
) ON [PRIMARY]
GO




CREATE TABLE [dbo].[history](
	[TableName] [varchar](200) NULL,
	[ModifiedDateTime] [datetime] NULL,
	[CompanyFilePath] [varchar](4095) NULL,
	[WindowsUser] [varchar](200) NULL,
	[LSOperation] [varchar](50) NULL,
	[RowsAdded] [int] NULL,
	[RowsUpdated] [int] NULL,
	[RowsDeleted] [int] NULL,
	[StartRunningDateTime] [datetime] NULL,
	[EndRunningDateTime] [datetime] NULL,
	[RunningResult] [varchar](255) NULL
) ON [PRIMARY]
GO




CREATE TABLE [dbo].[inventoryadjustment](
	[TxnID] [varchar](36) NOT NULL,
	[TimeCreated] [datetime] NULL,
	[TimeModified] [datetime] NULL,
	[EditSequence] [varchar](16) NULL,
	[TxnNumber] [int] NULL,
	[AccountRef_ListID] [varchar](36) NULL,
	[AccountRef_FullName] [varchar](159) NULL,
	[InvSiteRef_ListID] [varchar](36) NULL,
	[InvSiteRef_FullName] [varchar](31) NULL,
	[TxnDate] [datetime] NULL,
	[RefNumber] [varchar](11) NULL,
	[CustomerRef_ListID] [varchar](36) NULL,
	[CustomerRef_FullName] [varchar](209) NULL,
	[ClassRef_ListID] [varchar](36) NULL,
	[ClassRef_FullName] [varchar](159) NULL,
	[Memo] [varchar](4095) NULL,
	[ExternalGUID] [varchar](255) NULL,
	[UserData] [varchar](255) NULL,
	[Operation] [varchar](10) NULL,
	[LSData] [varchar](10) NULL,
 CONSTRAINT [PK_inventoryadjustment] PRIMARY KEY CLUSTERED 
(
	[TxnID] ASC
)WITH (PAD_INDEX = OFF, STATISTICS_NORECOMPUTE = OFF, IGNORE_DUP_KEY = OFF, ALLOW_ROW_LOCKS = ON, ALLOW_PAGE_LOCKS = ON, OPTIMIZE_FOR_SEQUENTIAL_KEY = OFF) ON [PRIMARY]
) ON [PRIMARY]
GO




CREATE TABLE [dbo].[inventoryadjustmentlineret](
	[TxnLineID] [varchar](36) NULL,
	[ItemRef_ListID] [varchar](36) NULL,
	[ItemRef_FullName] [varchar](209) NULL,
	[SerialNumber] [varchar](4095) NULL,
	[LotNumber] [varchar](40) NULL,
	[CountAdjustment] [int] NULL,
	[NewQuantity] [decimal](15, 5) NULL,
	[QuantityDifference] [decimal](15, 5) NULL,
	[NewValue] [decimal](15, 5) NULL,
	[ValueDifference] [decimal](15, 5) NULL,
	[SerialNumberAddedOrRemoved] [varchar](255) NULL,
	[InvSiteLocRef_ListID] [varchar](36) NULL,
	[InvSiteLocRef_FullName] [varchar](31) NULL,
	[InventoryAdjustmentLineType] [varchar](255) NULL,
	[PARENT_IDKEY] [varchar](36) NULL,
	[SeqNum] [int] NULL,
	[LSData] [varchar](10) NULL
) ON [PRIMARY]
GO



CREATE TABLE [dbo].[inventorysite](
	[ListID] [varchar](36) NOT NULL,
	[TimeCreated] [datetime] NULL,
	[TimeModified] [datetime] NULL,
	[EditSequence] [varchar](16) NULL,
	[Name] [varchar](31) NULL,
	[IsActive] [bit] NULL,
	[ParentSiteRef_ListID] [varchar](36) NULL,
	[ParentSiteRef_FullName] [varchar](31) NULL,
	[IsDefaultSite] [bit] NULL,
	[SiteDesc] [varchar](100) NULL,
	[Contact] [varchar](41) NULL,
	[Phone] [varchar](255) NULL,
	[Fax] [varchar](255) NULL,
	[Email] [varchar](4095) NULL,
	[SiteAddress_Addr1] [varchar](41) NULL,
	[SiteAddress_Addr2] [varchar](41) NULL,
	[SiteAddress_Addr3] [varchar](41) NULL,
	[SiteAddress_Addr4] [varchar](41) NULL,
	[SiteAddress_Addr5] [varchar](41) NULL,
	[SiteAddress_City] [varchar](31) NULL,
	[SiteAddress_State] [varchar](21) NULL,
	[SiteAddress_PostalCode] [varchar](13) NULL,
	[SiteAddress_Country] [varchar](31) NULL,
	[SiteAddressBlock_Addr1] [varchar](41) NULL,
	[SiteAddressBlock_Addr2] [varchar](41) NULL,
	[SiteAddressBlock_Addr3] [varchar](41) NULL,
	[SiteAddressBlock_Addr4] [varchar](41) NULL,
	[SiteAddressBlock_Addr5] [varchar](41) NULL,
	[UserData] [varchar](255) NULL,
	[Operation] [varchar](10) NULL,
	[LSData] [varchar](10) NULL,
 CONSTRAINT [PK_inventorysite] PRIMARY KEY CLUSTERED 
(
	[ListID] ASC
)WITH (PAD_INDEX = OFF, STATISTICS_NORECOMPUTE = OFF, IGNORE_DUP_KEY = OFF, ALLOW_ROW_LOCKS = ON, ALLOW_PAGE_LOCKS = ON, OPTIMIZE_FOR_SEQUENTIAL_KEY = OFF) ON [PRIMARY]
) ON [PRIMARY]
GO




CREATE TABLE [dbo].[invoice](
	[TxnID] [varchar](36) NOT NULL,
	[TimeCreated] [datetime] NULL,
	[TimeModified] [datetime] NULL,
	[EditSequence] [varchar](16) NULL,
	[TxnNumber] [int] NULL,
	[CustomerRef_ListID] [varchar](36) NULL,
	[CustomerRef_FullName] [varchar](209) NULL,
	[ClassRef_ListID] [varchar](36) NULL,
	[ClassRef_FullName] [varchar](159) NULL,
	[ARAccountRef_ListID] [varchar](36) NULL,
	[ARAccountRef_FullName] [varchar](159) NULL,
	[TemplateRef_ListID] [varchar](36) NULL,
	[TemplateRef_FullName] [varchar](31) NULL,
	[TxnDate] [datetime] NULL,
	[RefNumber] [varchar](25) NULL,
	[BillAddress_Addr1] [varchar](41) NULL,
	[BillAddress_Addr2] [varchar](41) NULL,
	[BillAddress_Addr3] [varchar](41) NULL,
	[BillAddress_Addr4] [varchar](41) NULL,
	[BillAddress_Addr5] [varchar](41) NULL,
	[BillAddress_City] [varchar](31) NULL,
	[BillAddress_State] [varchar](21) NULL,
	[BillAddress_PostalCode] [varchar](13) NULL,
	[BillAddress_Country] [varchar](31) NULL,
	[BillAddress_Note] [varchar](41) NULL,
	[ShipAddress_Addr1] [varchar](41) NULL,
	[ShipAddress_Addr2] [varchar](41) NULL,
	[ShipAddress_Addr3] [varchar](41) NULL,
	[ShipAddress_Addr4] [varchar](41) NULL,
	[ShipAddress_Addr5] [varchar](41) NULL,
	[ShipAddress_City] [varchar](31) NULL,
	[ShipAddress_State] [varchar](21) NULL,
	[ShipAddress_PostalCode] [varchar](13) NULL,
	[ShipAddress_Country] [varchar](31) NULL,
	[ShipAddress_Note] [varchar](41) NULL,
	[IsPending] [bit] NULL,
	[IsFinanceCharge] [bit] NULL,
	[PONumber] [varchar](25) NULL,
	[TermsRef_ListID] [varchar](36) NULL,
	[TermsRef_FullName] [varchar](31) NULL,
	[DueDate] [datetime] NULL,
	[SalesRepRef_ListID] [varchar](36) NULL,
	[SalesRepRef_FullName] [varchar](5) NULL,
	[FOB] [varchar](13) NULL,
	[ShipDate] [datetime] NULL,
	[ShipMethodRef_ListID] [varchar](36) NULL,
	[ShipMethodRef_FullName] [varchar](15) NULL,
	[Subtotal] [decimal](15, 2) NULL,
	[ItemSalesTaxRef_ListID] [varchar](36) NULL,
	[ItemSalesTaxRef_FullName] [varchar](31) NULL,
	[SalesTaxPercentage] [decimal](15, 5) NULL,
	[SalesTaxTotal] [decimal](15, 2) NULL,
	[AppliedAmount] [decimal](15, 2) NULL,
	[BalanceRemaining] [decimal](15, 2) NULL,
	[CurrencyRef_ListID] [varchar](36) NULL,
	[CurrencyRef_FullName] [varchar](64) NULL,
	[ExchangeRate] [decimal](15, 5) NULL,
	[BalRemainingInHomeCurrency] [decimal](15, 5) NULL,
	[Memo] [varchar](4095) NULL,
	[IsPaid] [bit] NULL,
	[CustomerMsgRef_ListID] [varchar](36) NULL,
	[CustomerMsgRef_FullName] [varchar](101) NULL,
	[IsToBePrinted] [bit] NULL,
	[IsToBeEmailed] [bit] NULL,
	[IsTaxIncluded] [bit] NULL,
	[CustSalesTaxCodeRef_ListID] [varchar](36) NULL,
	[CustSalesTaxCodeRef_FullName] [varchar](3) NULL,
	[SuggestedDiscountAmount] [decimal](15, 2) NULL,
	[SuggestedDiscountDate] [datetime] NULL,
	[Other] [varchar](29) NULL,
	[ExternalGUID] [varchar](255) NULL,
	[CustomField1] [varchar](255) NULL,
	[CustomField2] [varchar](255) NULL,
	[CustomField3] [varchar](255) NULL,
	[CustomField4] [varchar](255) NULL,
	[CustomField5] [varchar](255) NULL,
	[CustomField6] [varchar](255) NULL,
	[CustomField7] [varchar](255) NULL,
	[CustomField8] [varchar](255) NULL,
	[CustomField9] [varchar](255) NULL,
	[CustomField10] [varchar](255) NULL,
	[CustomField11] [varchar](255) NULL,
	[CustomField12] [varchar](255) NULL,
	[CustomField13] [varchar](255) NULL,
	[CustomField14] [varchar](255) NULL,
	[CustomField15] [varchar](255) NULL,
	[LSData] [varchar](10) NULL,
	[Operation] [varchar](10) NULL,
	[UserData] [varchar](255) NULL,
 CONSTRAINT [PK_invoice] PRIMARY KEY CLUSTERED 
(
	[TxnID] ASC
)WITH (PAD_INDEX = OFF, STATISTICS_NORECOMPUTE = OFF, IGNORE_DUP_KEY = OFF, ALLOW_ROW_LOCKS = ON, ALLOW_PAGE_LOCKS = ON, OPTIMIZE_FOR_SEQUENTIAL_KEY = OFF) ON [PRIMARY]
) ON [PRIMARY]
GO




CREATE TABLE [dbo].[invoicelinegroupret](
	[TxnLineID] [varchar](36) NULL,
	[ItemGroupRef_ListID] [varchar](36) NULL,
	[ItemGroupRef_FullName] [varchar](31) NULL,
	[Desc] [varchar](4095) NULL,
	[Quantity] [decimal](15, 5) NULL,
	[UnitOfMeasure] [varchar](31) NULL,
	[OverrideUOMSetRef_ListID] [varchar](36) NULL,
	[OverrideUOMSetRef_FullName] [varchar](31) NULL,
	[IsPrintItemsInGroup] [bit] NULL,
	[TotalAmount] [decimal](15, 2) NULL,
	[CustomField1] [varchar](50) NULL,
	[CustomField2] [varchar](50) NULL,
	[CustomField3] [varchar](50) NULL,
	[CustomField4] [varchar](50) NULL,
	[CustomField5] [varchar](50) NULL,
	[CustomField6] [varchar](50) NULL,
	[CustomField7] [varchar](50) NULL,
	[CustomField8] [varchar](50) NULL,
	[CustomField9] [varchar](50) NULL,
	[CustomField10] [varchar](50) NULL,
	[CustomField11] [varchar](50) NULL,
	[CustomField12] [varchar](50) NULL,
	[CustomField13] [varchar](50) NULL,
	[CustomField14] [varchar](50) NULL,
	[CustomField15] [varchar](50) NULL,
	[PARENT_IDKEY] [varchar](36) NULL,
	[SeqNum] [int] NULL,
	[LSData] [varchar](10) NULL
) ON [PRIMARY]
GO




CREATE TABLE [dbo].[invoicelineret](
	[TxnLineID] [varchar](36) NULL,
	[ItemRef_ListID] [varchar](36) NULL,
	[ItemRef_FullName] [varchar](209) NULL,
	[Desc] [varchar](4095) NULL,
	[Quantity] [decimal](15, 5) NULL,
	[UnitOfMeasure] [varchar](31) NULL,
	[OverrideUOMSetRef_ListID] [varchar](36) NULL,
	[OverrideUOMSetRef_FullName] [varchar](31) NULL,
	[Rate] [decimal](15, 5) NULL,
	[RatePercent] [decimal](15, 5) NULL,
	[ClassRef_ListID] [varchar](36) NULL,
	[ClassRef_FullName] [varchar](159) NULL,
	[Amount] [decimal](15, 2) NULL,
	[TaxAmount] [decimal](15, 2) NULL,
	[InvSiteRef_ListID] [varchar](36) NULL,
	[InvSiteRef_FullName] [varchar](31) NULL,
	[InvSiteLocRef_ListID] [varchar](36) NULL,
	[InvSiteLocRef_FullName] [varchar](31) NULL,
	[SerialNumber] [varchar](4095) NULL,
	[LotNumber] [varchar](40) NULL,
	[ServiceDate] [datetime] NULL,
	[SalesTaxCodeRef_ListID] [varchar](36) NULL,
	[SalesTaxCodeRef_FullName] [varchar](3) NULL,
	[IsTaxable] [bit] NULL,
	[Other1] [varchar](29) NULL,
	[Other2] [varchar](29) NULL,
	[LinkToTxn_TxnID] [varchar](36) NULL,
	[LinkToTxn_TxnLineID] [varchar](36) NULL,
	[CustomField1] [varchar](50) NULL,
	[CustomField2] [varchar](50) NULL,
	[CustomField3] [varchar](50) NULL,
	[CustomField4] [varchar](50) NULL,
	[CustomField5] [varchar](50) NULL,
	[CustomField6] [varchar](50) NULL,
	[CustomField7] [varchar](50) NULL,
	[CustomField8] [varchar](50) NULL,
	[CustomField9] [varchar](50) NULL,
	[CustomField10] [varchar](50) NULL,
	[CustomField11] [varchar](50) NULL,
	[CustomField12] [varchar](50) NULL,
	[CustomField13] [varchar](50) NULL,
	[CustomField14] [varchar](50) NULL,
	[CustomField15] [varchar](50) NULL,
	[PARENT_IDKEY] [varchar](36) NULL,
	[GroupPARENT_IDKEY] [varchar](255) NULL,
	[SeqNum] [int] NULL,
	[LSData] [varchar](10) NULL
) ON [PRIMARY]
GO




CREATE TABLE [dbo].[itemdiscount](
	[ListID] [varchar](36) NOT NULL,
	[TimeCreated] [datetime] NULL,
	[TimeModified] [datetime] NULL,
	[EditSequence] [varchar](16) NULL,
	[Name] [varchar](31) NULL,
	[FullName] [varchar](159) NULL,
	[IsActive] [bit] NULL,
	[BarCodeValue] [varchar](50) NULL,
	[AssignEvenIfUsed] [bit] NULL,
	[AllowOverride] [bit] NULL,
	[ParentRef_ListID] [varchar](36) NULL,
	[ParentRef_FullName] [varchar](209) NULL,
	[ClassRef_ListID] [varchar](36) NULL,
	[ClassRef_FullName] [varchar](159) NULL,
	[Sublevel] [int] NULL,
	[ItemDesc] [varchar](4095) NULL,
	[SalesTaxCodeRef_ListID] [varchar](36) NULL,
	[SalesTaxCodeRef_FullName] [varchar](3) NULL,
	[DiscountRate] [decimal](15, 5) NULL,
	[DiscountRatePercent] [decimal](15, 5) NULL,
	[AccountRef_ListID] [varchar](36) NULL,
	[AccountRef_FullName] [varchar](159) NULL,
	[ApplyAccountRefToExistingTxns] [bit] NULL,
	[ExternalGUID] [varchar](255) NULL,
	[CustomField1] [varchar](255) NULL,
	[CustomField2] [varchar](255) NULL,
	[CustomField3] [varchar](255) NULL,
	[CustomField4] [varchar](255) NULL,
	[CustomField5] [varchar](255) NULL,
	[CustomField6] [varchar](255) NULL,
	[CustomField7] [varchar](255) NULL,
	[CustomField8] [varchar](255) NULL,
	[CustomField9] [varchar](255) NULL,
	[CustomField10] [varchar](255) NULL,
	[CustomField11] [varchar](255) NULL,
	[CustomField12] [varchar](255) NULL,
	[CustomField13] [varchar](255) NULL,
	[CustomField14] [varchar](255) NULL,
	[CustomField15] [varchar](255) NULL,
	[UserData] [varchar](255) NULL,
	[Operation] [varchar](10) NULL,
	[LSData] [varchar](10) NULL,
 CONSTRAINT [PK_itemdiscount] PRIMARY KEY CLUSTERED 
(
	[ListID] ASC
)WITH (PAD_INDEX = OFF, STATISTICS_NORECOMPUTE = OFF, IGNORE_DUP_KEY = OFF, ALLOW_ROW_LOCKS = ON, ALLOW_PAGE_LOCKS = ON, OPTIMIZE_FOR_SEQUENTIAL_KEY = OFF) ON [PRIMARY]
) ON [PRIMARY]
GO




CREATE TABLE [dbo].[itemfixedasset](
	[ListID] [varchar](36) NOT NULL,
	[TimeCreated] [datetime] NULL,
	[TimeModified] [datetime] NULL,
	[EditSequence] [varchar](16) NULL,
	[Name] [varchar](31) NULL,
	[BarCodeValue] [varchar](50) NULL,
	[AssignEvenIfUsed] [bit] NULL,
	[AllowOverride] [bit] NULL,
	[IsActive] [bit] NULL,
	[AcquiredAs] [varchar](255) NULL,
	[PurchaseDesc] [varchar](50) NULL,
	[ClassRef_ListID] [varchar](36) NULL,
	[ClassRef_FullName] [varchar](159) NULL,
	[PurchaseDate] [datetime] NULL,
	[PurchaseCost] [decimal](15, 5) NULL,
	[VendorOrPayeeName] [varchar](50) NULL,
	[AssetAccountRef_ListID] [varchar](36) NULL,
	[AssetAccountRef_FullName] [varchar](159) NULL,
	[FixedAssetSalesInfo_SalesDesc] [varchar](50) NULL,
	[FixedAssetSalesInfo_SalesDate] [datetime] NULL,
	[FixedAssetSalesInfo_SalesPrice] [decimal](15, 5) NULL,
	[FixedAssetSalesInfo_SalesExpense] [decimal](15, 5) NULL,
	[AssetDesc] [varchar](50) NULL,
	[Location] [varchar](50) NULL,
	[PONumber] [varchar](30) NULL,
	[SerialNumber] [varchar](30) NULL,
	[WarrantyExpDate] [datetime] NULL,
	[Notes] [varchar](4095) NULL,
	[AssetNumber] [varchar](10) NULL,
	[CostBasis] [decimal](15, 2) NULL,
	[YearEndAccumulatedDepreciation] [decimal](15, 2) NULL,
	[YearEndBookValue] [decimal](15, 2) NULL,
	[ExternalGUID] [varchar](255) NULL,
	[CustomField1] [varchar](255) NULL,
	[CustomField2] [varchar](255) NULL,
	[CustomField3] [varchar](255) NULL,
	[CustomField4] [varchar](255) NULL,
	[CustomField5] [varchar](255) NULL,
	[CustomField6] [varchar](255) NULL,
	[CustomField7] [varchar](255) NULL,
	[CustomField8] [varchar](255) NULL,
	[CustomField9] [varchar](255) NULL,
	[CustomField10] [varchar](255) NULL,
	[CustomField11] [varchar](255) NULL,
	[CustomField12] [varchar](255) NULL,
	[CustomField13] [varchar](255) NULL,
	[CustomField14] [varchar](255) NULL,
	[CustomField15] [varchar](255) NULL,
	[LSData] [varchar](10) NULL,
	[Operation] [varchar](10) NULL,
	[UserData] [varchar](255) NULL,
 CONSTRAINT [PK_itemfixedasset] PRIMARY KEY CLUSTERED 
(
	[ListID] ASC
)WITH (PAD_INDEX = OFF, STATISTICS_NORECOMPUTE = OFF, IGNORE_DUP_KEY = OFF, ALLOW_ROW_LOCKS = ON, ALLOW_PAGE_LOCKS = ON, OPTIMIZE_FOR_SEQUENTIAL_KEY = OFF) ON [PRIMARY]
) ON [PRIMARY]
GO




CREATE TABLE [dbo].[itemgroup](
	[ListID] [varchar](36) NOT NULL,
	[TimeCreated] [datetime] NULL,
	[TimeModified] [datetime] NULL,
	[EditSequence] [varchar](16) NULL,
	[Name] [varchar](31) NULL,
	[IsActive] [bit] NULL,
	[BarCodeValue] [varchar](50) NULL,
	[UnitOfMeasureSetRef_ListID] [varchar](36) NULL,
	[UnitOfMeasureSetRef_FullName] [varchar](31) NULL,
	[ItemDesc] [varchar](4095) NULL,
	[IsPrintItemsInGroup] [bit] NULL,
	[SpecialItemType] [varchar](255) NULL,
	[ExternalGUID] [varchar](255) NULL,
	[CustomField1] [varchar](255) NULL,
	[CustomField2] [varchar](255) NULL,
	[CustomField3] [varchar](255) NULL,
	[CustomField4] [varchar](255) NULL,
	[CustomField5] [varchar](255) NULL,
	[CustomField6] [varchar](255) NULL,
	[CustomField7] [varchar](255) NULL,
	[CustomField8] [varchar](255) NULL,
	[CustomField9] [varchar](255) NULL,
	[CustomField10] [varchar](255) NULL,
	[CustomField11] [varchar](255) NULL,
	[CustomField12] [varchar](255) NULL,
	[CustomField13] [varchar](255) NULL,
	[CustomField14] [varchar](255) NULL,
	[CustomField15] [varchar](255) NULL,
	[UserData] [varchar](255) NULL,
	[Operation] [varchar](10) NULL,
	[LSData] [varchar](10) NULL,
 CONSTRAINT [PK_itemgroup] PRIMARY KEY CLUSTERED 
(
	[ListID] ASC
)WITH (PAD_INDEX = OFF, STATISTICS_NORECOMPUTE = OFF, IGNORE_DUP_KEY = OFF, ALLOW_ROW_LOCKS = ON, ALLOW_PAGE_LOCKS = ON, OPTIMIZE_FOR_SEQUENTIAL_KEY = OFF) ON [PRIMARY]
) ON [PRIMARY]
GO




CREATE TABLE [dbo].[itemgrouplineret](
	[TxnLineID] [varchar](36) NULL,
	[ItemRef_ListID] [varchar](36) NULL,
	[ItemRef_FullName] [varchar](209) NULL,
	[ItemGroupRef_ListID] [varchar](36) NULL,
	[ItemGroupRef_FullName] [varchar](31) NULL,
	[Desc] [varchar](4095) NULL,
	[Quantity] [decimal](15, 5) NULL,
	[UnitOfMeasure] [varchar](31) NULL,
	[OverrideUOMSetRef_ListID] [varchar](36) NULL,
	[OverrideUOMSetRef_FullName] [varchar](31) NULL,
	[TotalAmount] [decimal](15, 2) NULL,
	[CustomField1] [varchar](255) NULL,
	[CustomField2] [varchar](255) NULL,
	[CustomField3] [varchar](255) NULL,
	[CustomField4] [varchar](255) NULL,
	[CustomField5] [varchar](255) NULL,
	[CustomField6] [varchar](255) NULL,
	[CustomField7] [varchar](255) NULL,
	[CustomField8] [varchar](255) NULL,
	[CustomField9] [varchar](255) NULL,
	[CustomField10] [varchar](255) NULL,
	[CustomField11] [varchar](255) NULL,
	[CustomField12] [varchar](255) NULL,
	[CustomField13] [varchar](255) NULL,
	[CustomField14] [varchar](255) NULL,
	[CustomField15] [varchar](255) NULL,
	[PARENT_IDKEY] [varchar](36) NULL,
	[SeqNum] [int] NULL,
	[LSData] [varchar](10) NULL
) ON [PRIMARY]
GO




CREATE TABLE [dbo].[iteminventory](
	[ListID] [varchar](36) NOT NULL,
	[TimeCreated] [datetime] NULL,
	[TimeModified] [datetime] NULL,
	[EditSequence] [varchar](16) NULL,
	[Name] [varchar](31) NULL,
	[FullName] [varchar](159) NULL,
	[BarCodeValue] [varchar](50) NULL,
	[AssignEvenIfUsed] [bit] NULL,
	[AllowOverride] [bit] NULL,
	[IsActive] [bit] NULL,
	[ClassRef_ListID] [varchar](36) NULL,
	[ClassRef_FullName] [varchar](159) NULL,
	[ParentRef_ListID] [varchar](36) NULL,
	[ParentRef_FullName] [varchar](209) NULL,
	[Sublevel] [int] NULL,
	[ManufacturerPartNumber] [varchar](31) NULL,
	[UnitOfMeasureSetRef_ListID] [varchar](36) NULL,
	[UnitOfMeasureSetRef_FullName] [varchar](31) NULL,
	[ForceUOMChange] [bit] NULL,
	[IsTaxIncluded] [bit] NULL,
	[SalesTaxCodeRef_ListID] [varchar](36) NULL,
	[SalesTaxCodeRef_FullName] [varchar](3) NULL,
	[SalesDesc] [varchar](4095) NULL,
	[SalesPrice] [decimal](15, 5) NULL,
	[IncomeAccountRef_ListID] [varchar](36) NULL,
	[IncomeAccountRef_FullName] [varchar](159) NULL,
	[PurchaseDesc] [varchar](4095) NULL,
	[PurchaseCost] [decimal](15, 5) NULL,
	[PurchaseTaxCodeRef_ListID] [varchar](36) NULL,
	[PurchaseTaxCodeRef_FullName] [varchar](3) NULL,
	[COGSAccountRef_ListID] [varchar](36) NULL,
	[COGSAccountRef_FullName] [varchar](159) NULL,
	[PrefVendorRef_ListID] [varchar](36) NULL,
	[PrefVendorRef_FullName] [varchar](41) NULL,
	[AssetAccountRef_ListID] [varchar](36) NULL,
	[AssetAccountRef_FullName] [varchar](159) NULL,
	[ReorderPoint] [decimal](15, 5) NULL,
	[Max] [decimal](15, 5) NULL,
	[QuantityOnHand] [decimal](15, 5) NULL,
	[AverageCost] [decimal](15, 5) NULL,
	[QuantityOnOrder] [decimal](15, 5) NULL,
	[QuantityOnSalesOrder] [decimal](15, 5) NULL,
	[ExternalGUID] [varchar](255) NULL,
	[CustomField1] [varchar](255) NULL,
	[CustomField2] [varchar](255) NULL,
	[CustomField3] [varchar](255) NULL,
	[CustomField4] [varchar](255) NULL,
	[CustomField5] [varchar](255) NULL,
	[CustomField6] [varchar](255) NULL,
	[CustomField7] [varchar](255) NULL,
	[CustomField8] [varchar](255) NULL,
	[CustomField9] [varchar](255) NULL,
	[CustomField10] [varchar](255) NULL,
	[CustomField11] [varchar](255) NULL,
	[CustomField12] [varchar](255) NULL,
	[CustomField13] [varchar](255) NULL,
	[CustomField14] [varchar](255) NULL,
	[CustomField15] [varchar](255) NULL,
	[UserData] [varchar](255) NULL,
	[Operation] [varchar](10) NULL,
	[LSData] [varchar](10) NULL,
 CONSTRAINT [PK_iteminventory] PRIMARY KEY CLUSTERED 
(
	[ListID] ASC
)WITH (PAD_INDEX = OFF, STATISTICS_NORECOMPUTE = OFF, IGNORE_DUP_KEY = OFF, ALLOW_ROW_LOCKS = ON, ALLOW_PAGE_LOCKS = ON, OPTIMIZE_FOR_SEQUENTIAL_KEY = OFF) ON [PRIMARY]
) ON [PRIMARY]
GO




CREATE TABLE [dbo].[iteminventoryassembly](
	[ListID] [varchar](36) NOT NULL,
	[TimeCreated] [datetime] NULL,
	[TimeModified] [datetime] NULL,
	[EditSequence] [varchar](16) NULL,
	[Name] [varchar](31) NULL,
	[FullName] [varchar](159) NULL,
	[IsActive] [bit] NULL,
	[ClassRef_ListID] [varchar](36) NULL,
	[ClassRef_FullName] [varchar](159) NULL,
	[ParentRef_ListID] [varchar](36) NULL,
	[ParentRef_FullName] [varchar](209) NULL,
	[Sublevel] [int] NULL,
	[SalesTaxCodeRef_ListID] [varchar](36) NULL,
	[SalesTaxCodeRef_FullName] [varchar](3) NULL,
	[UnitOfMeasureSetRef_ListID] [varchar](36) NULL,
	[UnitOfMeasureSetRef_FullName] [varchar](31) NULL,
	[ForceUOMChange] [bit] NULL,
	[ManufacturerPartNumber] [varchar](31) NULL,
	[SalesDesc] [varchar](4095) NULL,
	[SalesPrice] [decimal](15, 5) NULL,
	[IncomeAccountRef_ListID] [varchar](36) NULL,
	[IncomeAccountRef_FullName] [varchar](159) NULL,
	[PurchaseDesc] [varchar](4095) NULL,
	[PurchaseCost] [decimal](15, 5) NULL,
	[PurchaseTaxCodeRef_ListID] [varchar](36) NULL,
	[PurchaseTaxCodeRef_FullName] [varchar](3) NULL,
	[IsTaxIncluded] [bit] NULL,
	[COGSAccountRef_ListID] [varchar](36) NULL,
	[COGSAccountRef_FullName] [varchar](159) NULL,
	[PrefVendorRef_ListID] [varchar](36) NULL,
	[PrefVendorRef_FullName] [varchar](41) NULL,
	[AssetAccountRef_ListID] [varchar](36) NULL,
	[AssetAccountRef_FullName] [varchar](159) NULL,
	[BuildPoint] [decimal](15, 5) NULL,
	[Max] [decimal](15, 5) NULL,
	[QuantityOnHand] [decimal](15, 5) NULL,
	[TotalValue] [decimal](15, 2) NULL,
	[InventoryDate] [datetime] NULL,
	[AverageCost] [decimal](15, 5) NULL,
	[QuantityOnOrder] [decimal](15, 5) NULL,
	[QuantityOnSalesOrder] [decimal](15, 5) NULL,
	[BarCodeValue] [varchar](50) NULL,
	[AssignEvenIfUsed] [bit] NULL,
	[AllowOverride] [bit] NULL,
	[ClearItemsInGroup] [bit] NULL,
	[ExternalGUID] [varchar](255) NULL,
	[CustomField1] [varchar](255) NULL,
	[CustomField2] [varchar](255) NULL,
	[CustomField3] [varchar](255) NULL,
	[CustomField4] [varchar](255) NULL,
	[CustomField5] [varchar](255) NULL,
	[CustomField6] [varchar](255) NULL,
	[CustomField7] [varchar](255) NULL,
	[CustomField8] [varchar](255) NULL,
	[CustomField9] [varchar](255) NULL,
	[CustomField10] [varchar](255) NULL,
	[CustomField11] [varchar](255) NULL,
	[CustomField12] [varchar](255) NULL,
	[CustomField13] [varchar](255) NULL,
	[CustomField14] [varchar](255) NULL,
	[CustomField15] [varchar](255) NULL,
	[UserData] [varchar](255) NULL,
	[Operation] [varchar](10) NULL,
	[LSData] [varchar](10) NULL,
 CONSTRAINT [PK_iteminventoryassembly] PRIMARY KEY CLUSTERED 
(
	[ListID] ASC
)WITH (PAD_INDEX = OFF, STATISTICS_NORECOMPUTE = OFF, IGNORE_DUP_KEY = OFF, ALLOW_ROW_LOCKS = ON, ALLOW_PAGE_LOCKS = ON, OPTIMIZE_FOR_SEQUENTIAL_KEY = OFF) ON [PRIMARY]
) ON [PRIMARY]
GO




CREATE TABLE [dbo].[iteminventoryassemblylineret](
	[ItemInventoryRef_ListID] [varchar](36) NULL,
	[ItemInventoryRef_FullName] [varchar](159) NULL,
	[Quantity] [decimal](15, 5) NULL,
	[PARENT_IDKEY] [varchar](36) NULL,
	[SeqNum] [int] NULL,
	[LSData] [varchar](10) NULL
) ON [PRIMARY]
GO




CREATE TABLE [dbo].[itemlineret](
	[TxnLineID] [varchar](36) NULL,
	[ItemRef_ListID] [varchar](36) NULL,
	[ItemRef_FullName] [varchar](209) NULL,
	[SalesRepRef_ListID] [varchar](36) NULL,
	[SalesRepRef_FullName] [varchar](5) NULL,
	[InvSiteRef_ListID] [varchar](36) NULL,
	[InvSiteRef_FullName] [varchar](31) NULL,
	[InvSiteLocRef_ListID] [varchar](36) NULL,
	[InvSiteLocRef_FullName] [varchar](31) NULL,
	[SerialNumber] [varchar](4095) NULL,
	[LotNumber] [varchar](40) NULL,
	[Desc] [varchar](4095) NULL,
	[Quantity] [decimal](15, 5) NULL,
	[OverrideUOMSetRef_ListID] [varchar](36) NULL,
	[OverrideUOMSetRef_FullName] [varchar](31) NULL,
	[UnitOfMeasure] [varchar](31) NULL,
	[Cost] [decimal](15, 5) NULL,
	[Amount] [decimal](15, 2) NULL,
	[CustomerRef_ListID] [varchar](36) NULL,
	[CustomerRef_FullName] [varchar](209) NULL,
	[ClassRef_ListID] [varchar](36) NULL,
	[ClassRef_FullName] [varchar](159) NULL,
	[SalesTaxCodeRef_ListID] [varchar](36) NULL,
	[SalesTaxCodeRef_FullName] [varchar](3) NULL,
	[BillableStatus] [varchar](255) NULL,
	[LinkedTxnID] [varchar](36) NULL,
	[LinkedTxnLineID] [varchar](36) NULL,
	[CustomField1] [varchar](255) NULL,
	[CustomField2] [varchar](255) NULL,
	[CustomField3] [varchar](255) NULL,
	[CustomField4] [varchar](255) NULL,
	[CustomField5] [varchar](255) NULL,
	[CustomField6] [varchar](255) NULL,
	[CustomField7] [varchar](255) NULL,
	[CustomField8] [varchar](255) NULL,
	[CustomField9] [varchar](255) NULL,
	[CustomField10] [varchar](255) NULL,
	[CustomField11] [varchar](255) NULL,
	[CustomField12] [varchar](255) NULL,
	[CustomField13] [varchar](255) NULL,
	[CustomField14] [varchar](255) NULL,
	[CustomField15] [varchar](255) NULL,
	[PARENT_IDKEY] [varchar](36) NULL,
	[GroupPARENT_IDKEY] [varchar](255) NULL,
	[SeqNum] [int] NULL,
	[LSData] [varchar](10) NULL
) ON [PRIMARY]
GO




CREATE TABLE [dbo].[itemnoninventory](
	[ListID] [varchar](36) NOT NULL,
	[TimeCreated] [datetime] NULL,
	[TimeModified] [datetime] NULL,
	[EditSequence] [varchar](16) NULL,
	[Name] [varchar](31) NULL,
	[FullName] [varchar](159) NULL,
	[BarCodeValue] [varchar](50) NULL,
	[AssignEvenIfUsed] [bit] NULL,
	[AllowOverride] [bit] NULL,
	[IsActive] [bit] NULL,
	[ClassRef_ListID] [varchar](36) NULL,
	[ClassRef_FullName] [varchar](159) NULL,
	[ParentRef_ListID] [varchar](36) NULL,
	[ParentRef_FullName] [varchar](209) NULL,
	[Sublevel] [int] NULL,
	[ManufacturerPartNumber] [varchar](31) NULL,
	[UnitOfMeasureSetRef_ListID] [varchar](36) NULL,
	[UnitOfMeasureSetRef_FullName] [varchar](31) NULL,
	[IsTaxIncluded] [bit] NULL,
	[SalesTaxCodeRef_ListID] [varchar](36) NULL,
	[SalesTaxCodeRef_FullName] [varchar](3) NULL,
	[PurchaseTaxCodeRef_ListID] [varchar](36) NULL,
	[PurchaseTaxCodeRef_FullName] [varchar](3) NULL,
	[ExternalGUID] [varchar](255) NULL,
	[CustomField1] [varchar](255) NULL,
	[CustomField2] [varchar](255) NULL,
	[CustomField3] [varchar](255) NULL,
	[CustomField4] [varchar](255) NULL,
	[CustomField5] [varchar](255) NULL,
	[CustomField6] [varchar](255) NULL,
	[CustomField7] [varchar](255) NULL,
	[CustomField8] [varchar](255) NULL,
	[CustomField9] [varchar](255) NULL,
	[CustomField10] [varchar](255) NULL,
	[CustomField11] [varchar](255) NULL,
	[CustomField12] [varchar](255) NULL,
	[CustomField13] [varchar](255) NULL,
	[CustomField14] [varchar](255) NULL,
	[CustomField15] [varchar](255) NULL,
	[UserData] [varchar](255) NULL,
	[Operation] [varchar](10) NULL,
	[LSData] [varchar](10) NULL,
 CONSTRAINT [PK_itemnoninventory] PRIMARY KEY CLUSTERED 
(
	[ListID] ASC
)WITH (PAD_INDEX = OFF, STATISTICS_NORECOMPUTE = OFF, IGNORE_DUP_KEY = OFF, ALLOW_ROW_LOCKS = ON, ALLOW_PAGE_LOCKS = ON, OPTIMIZE_FOR_SEQUENTIAL_KEY = OFF) ON [PRIMARY]
) ON [PRIMARY]
GO




CREATE TABLE [dbo].[itemothercharge](
	[ListID] [varchar](36) NOT NULL,
	[TimeCreated] [datetime] NULL,
	[TimeModified] [datetime] NULL,
	[EditSequence] [varchar](16) NULL,
	[Name] [varchar](31) NULL,
	[FullName] [varchar](159) NULL,
	[BarCodeValue] [varchar](50) NULL,
	[AssignEvenIfUsed] [bit] NULL,
	[AllowOverride] [bit] NULL,
	[IsActive] [bit] NULL,
	[ClassRef_ListID] [varchar](36) NULL,
	[ClassRef_FullName] [varchar](159) NULL,
	[ParentRef_ListID] [varchar](36) NULL,
	[ParentRef_FullName] [varchar](209) NULL,
	[Sublevel] [int] NULL,
	[IsTaxIncluded] [bit] NULL,
	[SalesTaxCodeRef_ListID] [varchar](36) NULL,
	[SalesTaxCodeRef_FullName] [varchar](3) NULL,
	[SpecialItemType] [varchar](255) NULL,
	[ExternalGUID] [varchar](255) NULL,
	[CustomField1] [varchar](255) NULL,
	[CustomField2] [varchar](255) NULL,
	[CustomField3] [varchar](255) NULL,
	[CustomField4] [varchar](255) NULL,
	[CustomField5] [varchar](255) NULL,
	[CustomField6] [varchar](255) NULL,
	[CustomField7] [varchar](255) NULL,
	[CustomField8] [varchar](255) NULL,
	[CustomField9] [varchar](255) NULL,
	[CustomField10] [varchar](255) NULL,
	[CustomField11] [varchar](255) NULL,
	[CustomField12] [varchar](255) NULL,
	[CustomField13] [varchar](255) NULL,
	[CustomField14] [varchar](255) NULL,
	[CustomField15] [varchar](255) NULL,
	[UserData] [varchar](255) NULL,
	[Operation] [varchar](10) NULL,
	[LSData] [varchar](10) NULL,
 CONSTRAINT [PK_itemothercharge] PRIMARY KEY CLUSTERED 
(
	[ListID] ASC
)WITH (PAD_INDEX = OFF, STATISTICS_NORECOMPUTE = OFF, IGNORE_DUP_KEY = OFF, ALLOW_ROW_LOCKS = ON, ALLOW_PAGE_LOCKS = ON, OPTIMIZE_FOR_SEQUENTIAL_KEY = OFF) ON [PRIMARY]
) ON [PRIMARY]
GO




CREATE TABLE [dbo].[itempayment](
	[ListID] [varchar](36) NOT NULL,
	[TimeCreated] [datetime] NULL,
	[TimeModified] [datetime] NULL,
	[EditSequence] [varchar](16) NULL,
	[Name] [varchar](31) NULL,
	[BarCodeValue] [varchar](50) NULL,
	[IsActive] [bit] NULL,
	[ClassRef_ListID] [varchar](36) NULL,
	[ClassRef_FullName] [varchar](159) NULL,
	[ItemDesc] [varchar](4095) NULL,
	[DepositToAccountRef_ListID] [varchar](36) NULL,
	[DepositToAccountRef_FullName] [varchar](159) NULL,
	[PaymentMethodRef_ListID] [varchar](36) NULL,
	[PaymentMethodRef_FullName] [varchar](31) NULL,
	[ExternalGUID] [varchar](255) NULL,
	[CustomField1] [varchar](255) NULL,
	[CustomField2] [varchar](255) NULL,
	[CustomField3] [varchar](255) NULL,
	[CustomField4] [varchar](255) NULL,
	[CustomField5] [varchar](255) NULL,
	[CustomField6] [varchar](255) NULL,
	[CustomField7] [varchar](255) NULL,
	[CustomField8] [varchar](255) NULL,
	[CustomField9] [varchar](255) NULL,
	[CustomField10] [varchar](255) NULL,
	[CustomField11] [varchar](255) NULL,
	[CustomField12] [varchar](255) NULL,
	[CustomField13] [varchar](255) NULL,
	[CustomField14] [varchar](255) NULL,
	[CustomField15] [varchar](255) NULL,
	[UserData] [varchar](255) NULL,
	[Operation] [varchar](10) NULL,
	[LSData] [varchar](10) NULL,
 CONSTRAINT [PK_itempayment] PRIMARY KEY CLUSTERED 
(
	[ListID] ASC
)WITH (PAD_INDEX = OFF, STATISTICS_NORECOMPUTE = OFF, IGNORE_DUP_KEY = OFF, ALLOW_ROW_LOCKS = ON, ALLOW_PAGE_LOCKS = ON, OPTIMIZE_FOR_SEQUENTIAL_KEY = OFF) ON [PRIMARY]
) ON [PRIMARY]
GO




CREATE TABLE [dbo].[itemreceipt](
	[TxnID] [varchar](36) NOT NULL,
	[TimeCreated] [datetime] NULL,
	[TimeModified] [datetime] NULL,
	[EditSequence] [varchar](16) NULL,
	[TxnNumber] [int] NULL,
	[VendorRef_ListID] [varchar](36) NULL,
	[VendorRef_FullName] [varchar](41) NULL,
	[APAccountRef_ListID] [varchar](36) NULL,
	[APAccountRef_FullName] [varchar](159) NULL,
	[TxnDate] [datetime] NULL,
	[TotalAmount] [decimal](15, 2) NULL,
	[CurrencyRef_ListID] [varchar](36) NULL,
	[CurrencyRef_FullName] [varchar](64) NULL,
	[LiabilityAccountRef_ListID] [varchar](36) NULL,
	[LiabilityAccountRef_FullName] [varchar](159) NULL,
	[ExchangeRate] [decimal](15, 5) NULL,
	[TotalAmountInHomeCurrency] [decimal](15, 2) NULL,
	[RefNumber] [varchar](25) NULL,
	[Memo] [varchar](4095) NULL,
	[IsTaxIncluded] [bit] NULL,
	[SalesTaxCodeRef_ListID] [varchar](36) NULL,
	[SalesTaxCodeRef_FullName] [varchar](3) NULL,
	[ExternalGUID] [varchar](255) NULL,
	[CustomField1] [varchar](255) NULL,
	[CustomField2] [varchar](255) NULL,
	[CustomField3] [varchar](255) NULL,
	[CustomField4] [varchar](255) NULL,
	[CustomField5] [varchar](255) NULL,
	[CustomField6] [varchar](255) NULL,
	[CustomField7] [varchar](255) NULL,
	[CustomField8] [varchar](255) NULL,
	[CustomField9] [varchar](255) NULL,
	[CustomField10] [varchar](255) NULL,
	[CustomField11] [varchar](255) NULL,
	[CustomField12] [varchar](255) NULL,
	[CustomField13] [varchar](255) NULL,
	[CustomField14] [varchar](255) NULL,
	[CustomField15] [varchar](255) NULL,
	[UserData] [varchar](255) NULL,
	[Operation] [varchar](10) NULL,
	[LSData] [varchar](10) NULL,
 CONSTRAINT [PK_itemreceipt] PRIMARY KEY CLUSTERED 
(
	[TxnID] ASC
)WITH (PAD_INDEX = OFF, STATISTICS_NORECOMPUTE = OFF, IGNORE_DUP_KEY = OFF, ALLOW_ROW_LOCKS = ON, ALLOW_PAGE_LOCKS = ON, OPTIMIZE_FOR_SEQUENTIAL_KEY = OFF) ON [PRIMARY]
) ON [PRIMARY]
GO




CREATE TABLE [dbo].[items](
	[ListID] [varchar](36) NOT NULL,
	[FullName] [varchar](200) NULL,
	[TableName] [varchar](200) NULL,
	[BarCodeValue] [varchar](50) NULL,
	[ExternalGUID] [varchar](255) NULL,
	[UserData] [varchar](255) NULL,
	[Operation] [varchar](10) NULL,
	[LSData] [varchar](10) NULL,
 CONSTRAINT [PK_items] PRIMARY KEY CLUSTERED 
(
	[ListID] ASC
)WITH (PAD_INDEX = OFF, STATISTICS_NORECOMPUTE = OFF, IGNORE_DUP_KEY = OFF, ALLOW_ROW_LOCKS = ON, ALLOW_PAGE_LOCKS = ON, OPTIMIZE_FOR_SEQUENTIAL_KEY = OFF) ON [PRIMARY]
) ON [PRIMARY]
GO




CREATE TABLE [dbo].[itemsalestax](
	[ListID] [varchar](36) NOT NULL,
	[TimeCreated] [datetime] NULL,
	[TimeModified] [datetime] NULL,
	[EditSequence] [varchar](16) NULL,
	[Name] [varchar](31) NULL,
	[BarCodeValue] [varchar](50) NULL,
	[IsActive] [bit] NULL,
	[ClassRef_ListID] [varchar](36) NULL,
	[ClassRef_FullName] [varchar](159) NULL,
	[ItemDesc] [varchar](4095) NULL,
	[IsUsedOnPurchaseTransaction] [bit] NULL,
	[TaxRate] [decimal](15, 5) NULL,
	[TaxVendorRef_ListID] [varchar](36) NULL,
	[TaxVendorRef_FullName] [varchar](41) NULL,
	[SalesTaxReturnLineRef_ListID] [varchar](36) NULL,
	[SalesTaxReturnLineRef_FullName] [varchar](209) NULL,
	[ExternalGUID] [varchar](255) NULL,
	[UserData] [varchar](255) NULL,
	[Operation] [varchar](10) NULL,
	[LSData] [varchar](10) NULL,
 CONSTRAINT [PK_itemsalestax] PRIMARY KEY CLUSTERED 
(
	[ListID] ASC
)WITH (PAD_INDEX = OFF, STATISTICS_NORECOMPUTE = OFF, IGNORE_DUP_KEY = OFF, ALLOW_ROW_LOCKS = ON, ALLOW_PAGE_LOCKS = ON, OPTIMIZE_FOR_SEQUENTIAL_KEY = OFF) ON [PRIMARY]
) ON [PRIMARY]
GO



CREATE TABLE [dbo].[itemsalestaxgroup](
	[ListID] [varchar](36) NOT NULL,
	[TimeCreated] [datetime] NULL,
	[TimeModified] [datetime] NULL,
	[EditSequence] [varchar](16) NULL,
	[Name] [varchar](31) NULL,
	[BarCodeValue] [varchar](50) NULL,
	[IsActive] [bit] NULL,
	[ItemDesc] [varchar](4095) NULL,
	[ExternalGUID] [varchar](255) NULL,
	[UserData] [varchar](255) NULL,
	[Operation] [varchar](10) NULL,
	[LSData] [varchar](10) NULL,
 CONSTRAINT [PK_itemsalestaxgroup] PRIMARY KEY CLUSTERED 
(
	[ListID] ASC
)WITH (PAD_INDEX = OFF, STATISTICS_NORECOMPUTE = OFF, IGNORE_DUP_KEY = OFF, ALLOW_ROW_LOCKS = ON, ALLOW_PAGE_LOCKS = ON, OPTIMIZE_FOR_SEQUENTIAL_KEY = OFF) ON [PRIMARY]
) ON [PRIMARY]
GO




CREATE TABLE [dbo].[itemsalestaxrefret](
	[ItemSalesTaxRef_ListID] [varchar](36) NULL,
	[ItemSalesTaxRef_FullName] [varchar](31) NULL,
	[PARENT_IDKEY] [varchar](36) NULL,
	[SeqNum] [int] NULL,
	[LSData] [varchar](10) NULL
) ON [PRIMARY]
GO




CREATE TABLE [dbo].[itemservice](
	[ListID] [varchar](36) NOT NULL,
	[TimeCreated] [datetime] NULL,
	[TimeModified] [datetime] NULL,
	[EditSequence] [varchar](16) NULL,
	[Name] [varchar](31) NULL,
	[FullName] [varchar](159) NULL,
	[BarCodeValue] [varchar](50) NULL,
	[AssignEvenIfUsed] [bit] NULL,
	[AllowOverride] [bit] NULL,
	[IsActive] [bit] NULL,
	[ClassRef_ListID] [varchar](36) NULL,
	[ClassRef_FullName] [varchar](159) NULL,
	[ParentRef_ListID] [varchar](36) NULL,
	[ParentRef_FullName] [varchar](209) NULL,
	[Sublevel] [int] NULL,
	[UnitOfMeasureSetRef_ListID] [varchar](36) NULL,
	[UnitOfMeasureSetRef_FullName] [varchar](31) NULL,
	[IsTaxIncluded] [bit] NULL,
	[SalesTaxCodeRef_ListID] [varchar](36) NULL,
	[SalesTaxCodeRef_FullName] [varchar](3) NULL,
	[ExternalGUID] [varchar](255) NULL,
	[CustomField1] [varchar](255) NULL,
	[CustomField2] [varchar](255) NULL,
	[CustomField3] [varchar](255) NULL,
	[CustomField4] [varchar](255) NULL,
	[CustomField5] [varchar](255) NULL,
	[CustomField6] [varchar](255) NULL,
	[CustomField7] [varchar](255) NULL,
	[CustomField8] [varchar](255) NULL,
	[CustomField9] [varchar](255) NULL,
	[CustomField10] [varchar](255) NULL,
	[CustomField11] [varchar](255) NULL,
	[CustomField12] [varchar](255) NULL,
	[CustomField13] [varchar](255) NULL,
	[CustomField14] [varchar](255) NULL,
	[CustomField15] [varchar](255) NULL,
	[UserData] [varchar](255) NULL,
	[Operation] [varchar](10) NULL,
	[LSData] [varchar](10) NULL,
 CONSTRAINT [PK_itemservice] PRIMARY KEY CLUSTERED 
(
	[ListID] ASC
)WITH (PAD_INDEX = OFF, STATISTICS_NORECOMPUTE = OFF, IGNORE_DUP_KEY = OFF, ALLOW_ROW_LOCKS = ON, ALLOW_PAGE_LOCKS = ON, OPTIMIZE_FOR_SEQUENTIAL_KEY = OFF) ON [PRIMARY]
) ON [PRIMARY]
GO





CREATE TABLE [dbo].[itemsites](
	[ListID] [varchar](36) NOT NULL,
	[TimeCreated] [datetime] NULL,
	[TimeModified] [datetime] NULL,
	[EditSequence] [varchar](16) NULL,
	[ItemInvAssemblyRef_ListID] [varchar](36) NULL,
	[ItemInvAssemblyRef_FullName] [varchar](159) NULL,
	[ItemInventoryRef_ListID] [varchar](36) NULL,
	[ItemInventoryRef_FullName] [varchar](159) NULL,
	[InvSiteRef_ListID] [varchar](36) NULL,
	[InvSiteRef_FullName] [varchar](31) NULL,
	[InvSiteLocRef_ListID] [varchar](36) NULL,
	[InvSiteLocRef_FullName] [varchar](31) NULL,
	[ReorderLevel] [decimal](15, 5) NULL,
	[QuantityOnHand] [decimal](15, 5) NULL,
	[QuantityOnPurchaseOrders] [decimal](15, 5) NULL,
	[QuantityOnSalesOrders] [decimal](15, 5) NULL,
	[QuantityToBeBuiltByPendingBuildTxns] [decimal](15, 5) NULL,
	[QuantityRequiredByPendingBuildTxns] [decimal](15, 5) NULL,
	[QuantityOnPendingTransfers] [decimal](15, 5) NULL,
	[AssemblyBuildPoint] [decimal](15, 5) NULL,
	[UserData] [varchar](255) NULL,
	[Operation] [varchar](10) NULL,
	[LSData] [varchar](10) NULL,
 CONSTRAINT [PK_itemsites] PRIMARY KEY CLUSTERED 
(
	[ListID] ASC
)WITH (PAD_INDEX = OFF, STATISTICS_NORECOMPUTE = OFF, IGNORE_DUP_KEY = OFF, ALLOW_ROW_LOCKS = ON, ALLOW_PAGE_LOCKS = ON, OPTIMIZE_FOR_SEQUENTIAL_KEY = OFF) ON [PRIMARY]
) ON [PRIMARY]
GO





CREATE TABLE [dbo].[itemsubtotal](
	[ListID] [varchar](36) NOT NULL,
	[TimeCreated] [datetime] NULL,
	[TimeModified] [datetime] NULL,
	[EditSequence] [varchar](16) NULL,
	[Name] [varchar](31) NULL,
	[BarCodeValue] [varchar](50) NULL,
	[IsActive] [bit] NULL,
	[ItemDesc] [varchar](4095) NULL,
	[SpecialItemType] [varchar](255) NULL,
	[ExternalGUID] [varchar](255) NULL,
	[UserData] [varchar](255) NULL,
	[Operation] [varchar](10) NULL,
	[LSData] [varchar](10) NULL,
 CONSTRAINT [PK_itemsubtotal] PRIMARY KEY CLUSTERED 
(
	[ListID] ASC
)WITH (PAD_INDEX = OFF, STATISTICS_NORECOMPUTE = OFF, IGNORE_DUP_KEY = OFF, ALLOW_ROW_LOCKS = ON, ALLOW_PAGE_LOCKS = ON, OPTIMIZE_FOR_SEQUENTIAL_KEY = OFF) ON [PRIMARY]
) ON [PRIMARY]
GO





CREATE TABLE [dbo].[jobtype](
	[ListID] [varchar](36) NOT NULL,
	[TimeCreated] [datetime] NULL,
	[TimeModified] [datetime] NULL,
	[EditSequence] [varchar](16) NULL,
	[Name] [varchar](31) NULL,
	[FullName] [varchar](159) NULL,
	[IsActive] [bit] NULL,
	[ParentRef_ListID] [varchar](36) NULL,
	[ParentRef_FullName] [varchar](209) NULL,
	[Sublevel] [int] NULL,
	[UserData] [varchar](255) NULL,
	[Operation] [varchar](10) NULL,
	[LSData] [varchar](10) NULL,
 CONSTRAINT [PK_jobtype] PRIMARY KEY CLUSTERED 
(
	[ListID] ASC
)WITH (PAD_INDEX = OFF, STATISTICS_NORECOMPUTE = OFF, IGNORE_DUP_KEY = OFF, ALLOW_ROW_LOCKS = ON, ALLOW_PAGE_LOCKS = ON, OPTIMIZE_FOR_SEQUENTIAL_KEY = OFF) ON [PRIMARY]
) ON [PRIMARY]
GO





CREATE TABLE [dbo].[journalcreditlineret](
	[TxnLineID] [varchar](36) NULL,
	[AccountRef_ListID] [varchar](36) NULL,
	[AccountRef_FullName] [varchar](159) NULL,
	[Amount] [decimal](15, 2) NULL,
	[Memo] [varchar](4095) NULL,
	[IsAdjustment] [bit] NULL,
	[EntityRef_ListID] [varchar](36) NULL,
	[EntityRef_FullName] [varchar](209) NULL,
	[ClassRef_ListID] [varchar](36) NULL,
	[ClassRef_FullName] [varchar](159) NULL,
	[ItemSalesTaxRef_ListID] [varchar](36) NULL,
	[ItemSalesTaxRef_FullName] [varchar](159) NULL,
	[BillableStatus] [varchar](255) NULL,
	[PARENT_IDKEY] [varchar](36) NULL,
	[LSData] [varchar](10) NULL
) ON [PRIMARY]
GO





CREATE TABLE [dbo].[journaldebitlineret](
	[TxnLineID] [varchar](36) NULL,
	[AccountRef_ListID] [varchar](36) NULL,
	[AccountRef_FullName] [varchar](159) NULL,
	[Amount] [decimal](15, 2) NULL,
	[Memo] [varchar](4095) NULL,
	[EntityRef_ListID] [varchar](36) NULL,
	[EntityRef_FullName] [varchar](209) NULL,
	[ClassRef_ListID] [varchar](36) NULL,
	[ClassRef_FullName] [varchar](159) NULL,
	[ItemSalesTaxRef_ListID] [varchar](36) NULL,
	[ItemSalesTaxRef_FullName] [varchar](31) NULL,
	[BillableStatus] [varchar](255) NULL,
	[PARENT_IDKEY] [varchar](36) NULL,
	[LSData] [varchar](10) NULL
) ON [PRIMARY]
GO





CREATE TABLE [dbo].[journalentry](
	[TxnID] [varchar](36) NOT NULL,
	[TimeCreated] [datetime] NULL,
	[TimeModified] [datetime] NULL,
	[EditSequence] [varchar](16) NULL,
	[TxnNumber] [int] NULL,
	[TxnDate] [datetime] NULL,
	[RefNumber] [varchar](11) NULL,
	[Memo] [varchar](4095) NULL,
	[IsAdjustment] [bit] NULL,
	[IsHomeCurrencyAdjustment] [bit] NULL,
	[IsAmountsEnteredInHomeCurrency] [bit] NULL,
	[CurrencyRef_ListID] [varchar](36) NULL,
	[CurrencyRef_FullName] [varchar](64) NULL,
	[ExchangeRate] [decimal](15, 5) NULL,
	[ExternalGUID] [varchar](255) NULL,
	[UserData] [varchar](255) NULL,
	[Operation] [varchar](10) NULL,
	[LSData] [varchar](10) NULL,
 CONSTRAINT [PK_journalentry] PRIMARY KEY CLUSTERED 
(
	[TxnID] ASC
)WITH (PAD_INDEX = OFF, STATISTICS_NORECOMPUTE = OFF, IGNORE_DUP_KEY = OFF, ALLOW_ROW_LOCKS = ON, ALLOW_PAGE_LOCKS = ON, OPTIMIZE_FOR_SEQUENTIAL_KEY = OFF) ON [PRIMARY]
) ON [PRIMARY]
GO





CREATE TABLE [dbo].[linkedtxnret](
	[TxnID] [varchar](36) NOT NULL,
	[TxnType] [varchar](255) NULL,
	[TxnDate] [datetime] NULL,
	[RefNumber] [varchar](25) NULL,
	[LinkType] [varchar](255) NULL,
	[Amount] [decimal](15, 2) NULL,
	[PARENT_IDKEY] [varchar](36) NULL,
	[SeqNum] [int] NULL,
	[LSData] [varchar](10) NULL
) ON [PRIMARY]
GO





CREATE TABLE [dbo].[listdeleted](
	[ListDelType] [varchar](255) NULL,
	[ListID] [varchar](255) NOT NULL,
	[TimeCreated] [datetime] NULL,
	[TimeDeleted] [datetime] NULL,
	[FullName] [varchar](255) NULL,
 CONSTRAINT [PK_listdeleted] PRIMARY KEY CLUSTERED 
(
	[ListID] ASC
)WITH (PAD_INDEX = OFF, STATISTICS_NORECOMPUTE = OFF, IGNORE_DUP_KEY = OFF, ALLOW_ROW_LOCKS = ON, ALLOW_PAGE_LOCKS = ON, OPTIMIZE_FOR_SEQUENTIAL_KEY = OFF) ON [PRIMARY]
) ON [PRIMARY]
GO




CREATE TABLE [dbo].[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] [bit] 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
) ON [PRIMARY]
GO





CREATE TABLE [dbo].[LSDatabase](
	[Version] [int] NULL,
	[LSData] [varchar](10) NULL
) ON [PRIMARY]
GO




CREATE TABLE [dbo].[othername](
	[ListID] [varchar](36) NOT NULL,
	[TimeCreated] [datetime] NULL,
	[TimeModified] [datetime] NULL,
	[EditSequence] [varchar](16) NULL,
	[Name] [varchar](41) NULL,
	[IsActive] [bit] NULL,
	[CompanyName] [varchar](41) NULL,
	[Salutation] [varchar](15) NULL,
	[FirstName] [varchar](25) NULL,
	[MiddleName] [varchar](5) NULL,
	[LastName] [varchar](25) NULL,
	[Suffix] [varchar](255) NULL,
	[OtherNameAddress_Addr1] [varchar](41) NULL,
	[OtherNameAddress_Addr2] [varchar](41) NULL,
	[OtherNameAddress_Addr3] [varchar](41) NULL,
	[OtherNameAddress_Addr4] [varchar](41) NULL,
	[OtherNameAddress_Addr5] [varchar](41) NULL,
	[OtherNameAddress_City] [varchar](31) NULL,
	[OtherNameAddress_State] [varchar](21) NULL,
	[OtherNameAddress_PostalCode] [varchar](13) NULL,
	[OtherNameAddress_Country] [varchar](31) NULL,
	[OtherNameAddress_Note] [varchar](41) NULL,
	[Phone] [varchar](255) NULL,
	[Mobile] [varchar](255) NULL,
	[Pager] [varchar](10) NULL,
	[AltPhone] [varchar](255) NULL,
	[Fax] [varchar](255) NULL,
	[Email] [varchar](4095) NULL,
	[Contact] [varchar](41) NULL,
	[AltContact] [varchar](41) NULL,
	[AccountNumber] [varchar](99) NULL,
	[Notes] [varchar](4095) NULL,
	[ExternalGUID] [varchar](255) NULL,
	[UserData] [varchar](255) NULL,
	[Operation] [varchar](10) NULL,
	[LSData] [varchar](10) NULL,
 CONSTRAINT [PK_othername] PRIMARY KEY CLUSTERED 
(
	[ListID] ASC
)WITH (PAD_INDEX = OFF, STATISTICS_NORECOMPUTE = OFF, IGNORE_DUP_KEY = OFF, ALLOW_ROW_LOCKS = ON, ALLOW_PAGE_LOCKS = ON, OPTIMIZE_FOR_SEQUENTIAL_KEY = OFF) ON [PRIMARY]
) ON [PRIMARY]
GO




CREATE TABLE [dbo].[paymentlineret](
	[TxnID] [varchar](36) NOT NULL,
	[TxnType] [varchar](255) NULL,
	[TxnDate] [datetime] NULL,
	[RefNumber] [varchar](25) NULL,
	[TotalAmount] [decimal](15, 2) NULL,
	[AppliedAmount] [decimal](15, 2) NULL,
	[PARENT_IDKEY] [varchar](36) NULL,
	[GroupPARENT_IDKEY] [varchar](255) NULL,
	[SeqNum] [int] NULL,
	[LSData] [varchar](10) NULL
) ON [PRIMARY]
GO




CREATE TABLE [dbo].[paymentmethod](
	[ListID] [varchar](36) NOT NULL,
	[TimeCreated] [datetime] NULL,
	[TimeModified] [datetime] NULL,
	[EditSequence] [varchar](116) NULL,
	[Name] [varchar](31) NULL,
	[IsActive] [bit] NULL,
	[PaymentMethodType] [varchar](255) NULL,
	[UserData] [varchar](255) NULL,
	[Operation] [varchar](10) NULL,
	[LSData] [varchar](10) NULL,
 CONSTRAINT [PK_paymentmethod] PRIMARY KEY CLUSTERED 
(
	[ListID] ASC
)WITH (PAD_INDEX = OFF, STATISTICS_NORECOMPUTE = OFF, IGNORE_DUP_KEY = OFF, ALLOW_ROW_LOCKS = ON, ALLOW_PAGE_LOCKS = ON, OPTIMIZE_FOR_SEQUENTIAL_KEY = OFF) ON [PRIMARY]
) ON [PRIMARY]
GO




CREATE TABLE [dbo].[payrollitemnonwage](
	[ListID] [varchar](36) NOT NULL,
	[TimeCreated] [datetime] NULL,
	[TimeModified] [datetime] NULL,
	[EditSequence] [varchar](16) NULL,
	[Name] [varchar](31) NULL,
	[IsActive] [bit] NULL,
	[NonWageType] [varchar](255) NULL,
	[ExpenseAccountRef_ListID] [varchar](36) NULL,
	[ExpenseAccountRef_FullName] [varchar](159) NULL,
	[LiabilityAccountRef_ListID] [varchar](36) NULL,
	[LiabilityAccountRef_FullName] [varchar](159) NULL,
	[UserData] [varchar](255) NULL,
	[Operation] [varchar](10) NULL,
	[LSData] [varchar](10) NULL,
 CONSTRAINT [PK_payrollitemnonwage] PRIMARY KEY CLUSTERED 
(
	[ListID] ASC
)WITH (PAD_INDEX = OFF, STATISTICS_NORECOMPUTE = OFF, IGNORE_DUP_KEY = OFF, ALLOW_ROW_LOCKS = ON, ALLOW_PAGE_LOCKS = ON, OPTIMIZE_FOR_SEQUENTIAL_KEY = OFF) ON [PRIMARY]
) ON [PRIMARY]
GO




CREATE TABLE [dbo].[payrollitemwage](
	[ListID] [varchar](36) NOT NULL,
	[TimeCreated] [datetime] NULL,
	[TimeModified] [datetime] NULL,
	[EditSequence] [varchar](16) NULL,
	[Name] [varchar](31) NULL,
	[IsActive] [bit] NULL,
	[WageType] [varchar](255) NULL,
	[ExpenseAccountRef_ListID] [varchar](36) NULL,
	[ExpenseAccountRef_FullName] [varchar](159) NULL,
	[UserData] [varchar](255) NULL,
	[Operation] [varchar](10) NULL,
	[LSData] [varchar](10) NULL,
 CONSTRAINT [PK_payrollitemwage] PRIMARY KEY CLUSTERED 
(
	[ListID] ASC
)WITH (PAD_INDEX = OFF, STATISTICS_NORECOMPUTE = OFF, IGNORE_DUP_KEY = OFF, ALLOW_ROW_LOCKS = ON, ALLOW_PAGE_LOCKS = ON, OPTIMIZE_FOR_SEQUENTIAL_KEY = OFF) ON [PRIMARY]
) ON [PRIMARY]
GO




CREATE TABLE [dbo].[prefillaccountret](
	[ListID] [varchar](36) NOT NULL,
	[FullName] [varchar](159) NULL,
	[PARENT_IDKEY] [varchar](36) NULL,
	[SeqNum] [int] NULL,
	[LSData] [varchar](10) NULL
) ON [PRIMARY]
GO




CREATE TABLE [dbo].[pricelevel](
	[ListID] [varchar](36) NOT NULL,
	[TimeCreated] [datetime] NULL,
	[TimeModified] [datetime] NULL,
	[EditSequence] [varchar](16) NULL,
	[Name] [varchar](31) NULL,
	[IsActive] [bit] NULL,
	[PriceLevelType] [varchar](255) NULL,
	[PriceLevelFixedPercentage] [decimal](15, 5) NULL,
	[CurrencyRef_ListID] [varchar](36) NULL,
	[CurrencyRef_FullName] [varchar](64) NULL,
	[UserData] [varchar](255) NULL,
	[Operation] [varchar](10) NULL,
	[LSData] [varchar](10) NULL,
 CONSTRAINT [PK_pricelevel] PRIMARY KEY CLUSTERED 
(
	[ListID] ASC
)WITH (PAD_INDEX = OFF, STATISTICS_NORECOMPUTE = OFF, IGNORE_DUP_KEY = OFF, ALLOW_ROW_LOCKS = ON, ALLOW_PAGE_LOCKS = ON, OPTIMIZE_FOR_SEQUENTIAL_KEY = OFF) ON [PRIMARY]
) ON [PRIMARY]
GO




CREATE TABLE [dbo].[pricelevelperitemret](
	[ItemRef_ListID] [varchar](36) NULL,
	[ItemRef_FullName] [varchar](159) NULL,
	[CustomPrice] [decimal](15, 5) NULL,
	[CustomPricePercent] [decimal](15, 5) NULL,
	[AdjustPercentage] [decimal](15, 5) NULL,
	[AdjustRelativeTo] [varchar](255) NULL,
	[PARENT_IDKEY] [varchar](36) NULL,
	[SeqNum] [int] NULL,
	[LSData] [varchar](10) NULL
) ON [PRIMARY]
GO




CREATE TABLE [dbo].[purchaseorder](
	[TxnID] [varchar](36) NOT NULL,
	[TimeCreated] [datetime] NULL,
	[TimeModified] [datetime] NULL,
	[EditSequence] [varchar](16) NULL,
	[TxnNumber] [int] NULL,
	[VendorRef_ListID] [varchar](36) NULL,
	[VendorRef_FullName] [varchar](41) NULL,
	[ClassRef_ListID] [varchar](36) NULL,
	[ClassRef_FullName] [varchar](159) NULL,
	[InvSiteRef_ListID] [varchar](36) NULL,
	[InvSiteRef_FullName] [varchar](31) NULL,
	[InvSiteLocRef_ListID] [varchar](36) NULL,
	[InvSiteLocRef_FullName] [varchar](209) NULL,
	[ShipToEntityRef_ListID] [varchar](36) NULL,
	[ShipToEntityRef_FullName] [varchar](209) NULL,
	[TemplateRef_ListID] [varchar](36) NULL,
	[TemplateRef_FullName] [varchar](31) NULL,
	[TxnDate] [datetime] NULL,
	[RefNumber] [varchar](25) NULL,
	[VendorAddress_Addr1] [varchar](41) NULL,
	[VendorAddress_Addr2] [varchar](41) NULL,
	[VendorAddress_Addr3] [varchar](41) NULL,
	[VendorAddress_Addr4] [varchar](41) NULL,
	[VendorAddress_Addr5] [varchar](41) NULL,
	[VendorAddress_City] [varchar](31) NULL,
	[VendorAddress_State] [varchar](21) NULL,
	[VendorAddress_PostalCode] [varchar](13) NULL,
	[VendorAddress_Country] [varchar](31) NULL,
	[VendorAddress_Note] [varchar](41) NULL,
	[ShipAddress_Addr1] [varchar](41) NULL,
	[ShipAddress_Addr2] [varchar](41) NULL,
	[ShipAddress_Addr3] [varchar](41) NULL,
	[ShipAddress_Addr4] [varchar](41) NULL,
	[ShipAddress_Addr5] [varchar](41) NULL,
	[ShipAddress_City] [varchar](31) NULL,
	[ShipAddress_State] [varchar](21) NULL,
	[ShipAddress_PostalCode] [varchar](13) NULL,
	[ShipAddress_Country] [varchar](31) NULL,
	[ShipAddress_Note] [varchar](41) NULL,
	[TermsRef_ListID] [varchar](36) NULL,
	[TermsRef_FullName] [varchar](31) NULL,
	[DueDate] [datetime] NULL,
	[ExpectedDate] [datetime] NULL,
	[ShipMethodRef_ListID] [varchar](36) NULL,
	[ShipMethodRef_FullName] [varchar](15) NULL,
	[FOB] [varchar](13) NULL,
	[TotalAmount] [decimal](15, 2) NULL,
	[CurrencyRef_ListID] [varchar](36) NULL,
	[CurrencyRef_FullName] [varchar](64) NULL,
	[ExchangeRate] [decimal](15, 5) NULL,
	[TotalAmountInHomeCurrency] [decimal](15, 2) NULL,
	[Memo] [varchar](4095) NULL,
	[VendorMsg] [varchar](99) NULL,
	[IsToBePrinted] [bit] NULL,
	[IsToBeEmailed] [bit] NULL,
	[IsTaxIncluded] [bit] NULL,
	[SalesTaxCodeRef_ListID] [varchar](36) NULL,
	[SalesTaxCodeRef_FullName] [varchar](3) NULL,
	[Other1] [varchar](25) NULL,
	[Other2] [varchar](29) NULL,
	[IsManuallyClosed] [bit] NULL,
	[IsFullyReceived] [bit] NULL,
	[ExternalGUID] [varchar](255) NULL,
	[CustomField1] [varchar](255) NULL,
	[CustomField2] [varchar](255) NULL,
	[CustomField3] [varchar](255) NULL,
	[CustomField4] [varchar](255) NULL,
	[CustomField5] [varchar](255) NULL,
	[CustomField6] [varchar](255) NULL,
	[CustomField7] [varchar](255) NULL,
	[CustomField8] [varchar](255) NULL,
	[CustomField9] [varchar](255) NULL,
	[CustomField10] [varchar](255) NULL,
	[CustomField11] [varchar](255) NULL,
	[CustomField12] [varchar](255) NULL,
	[CustomField13] [varchar](255) NULL,
	[CustomField14] [varchar](255) NULL,
	[CustomField15] [varchar](255) NULL,
	[UserData] [varchar](255) NULL,
	[Operation] [varchar](10) NULL,
	[LSData] [varchar](10) NULL,
 CONSTRAINT [PK_purchaseorder] PRIMARY KEY CLUSTERED 
(
	[TxnID] ASC
)WITH (PAD_INDEX = OFF, STATISTICS_NORECOMPUTE = OFF, IGNORE_DUP_KEY = OFF, ALLOW_ROW_LOCKS = ON, ALLOW_PAGE_LOCKS = ON, OPTIMIZE_FOR_SEQUENTIAL_KEY = OFF) ON [PRIMARY]
) ON [PRIMARY]
GO




CREATE TABLE [dbo].[purchaseorderlinegroupret](
	[TxnLineID] [varchar](36) NULL,
	[ItemGroupRef_ListID] [varchar](36) NULL,
	[ItemGroupRef_FullName] [varchar](31) NULL,
	[Desc] [varchar](4095) NULL,
	[Quantity] [decimal](15, 5) NULL,
	[IsPrintItemsInGroup] [bit] NULL,
	[TotalAmount] [decimal](15, 2) NULL,
	[ServiceDate] [datetime] NULL,
	[CustomField1] [varchar](255) NULL,
	[CustomField2] [varchar](255) NULL,
	[CustomField3] [varchar](255) NULL,
	[CustomField4] [varchar](255) NULL,
	[CustomField5] [varchar](255) NULL,
	[CustomField6] [varchar](255) NULL,
	[CustomField7] [varchar](255) NULL,
	[CustomField8] [varchar](255) NULL,
	[CustomField9] [varchar](255) NULL,
	[CustomField10] [varchar](255) NULL,
	[CustomField11] [varchar](255) NULL,
	[CustomField12] [varchar](255) NULL,
	[CustomField13] [varchar](255) NULL,
	[CustomField14] [varchar](255) NULL,
	[CustomField15] [varchar](255) NULL,
	[PARENT_IDKEY] [varchar](36) NULL,
	[GroupPARENT_IDKEY] [varchar](255) NULL,
	[SeqNum] [int] NULL,
	[LSData] [varchar](10) NULL
) ON [PRIMARY]
GO




CREATE TABLE [dbo].[purchaseorderlineret](
	[TxnLineID] [varchar](36) NULL,
	[ItemRef_ListID] [varchar](36) NULL,
	[ItemRef_FullName] [varchar](209) NULL,
	[ManufacturerPartNumber] [varchar](31) NULL,
	[Desc] [varchar](4095) NULL,
	[Quantity] [decimal](15, 5) NULL,
	[UnitOfMeasure] [varchar](31) NULL,
	[OverrideUOMSetRef_ListID] [varchar](36) NULL,
	[OverrideUOMSetRef_FullName] [varchar](31) NULL,
	[Rate] [decimal](15, 5) NULL,
	[ClassRef_ListID] [varchar](36) NULL,
	[ClassRef_FullName] [varchar](159) NULL,
	[Amount] [decimal](15, 2) NULL,
	[CustomerRef_ListID] [varchar](36) NULL,
	[CustomerRef_FullName] [varchar](209) NULL,
	[ServiceDate] [datetime] NULL,
	[SalesTaxCodeRef_ListID] [varchar](36) NULL,
	[SalesTaxCodeRef_FullName] [varchar](3) NULL,
	[ReceivedQuantity] [decimal](15, 5) NULL,
	[IsBilled] [bit] NULL,
	[Other1] [varchar](29) NULL,
	[Other2] [varchar](29) NULL,
	[IsManuallyClosed] [bit] NULL,
	[UnbilledQuantity] [decimal](15, 5) NULL,
	[InvSiteLocRef_ListID] [varchar](36) NULL,
	[InvSiteLocRef_FullName] [varchar](255) NULL,
	[CustomField1] [varchar](255) NULL,
	[CustomField2] [varchar](255) NULL,
	[CustomField3] [varchar](255) NULL,
	[CustomField4] [varchar](255) NULL,
	[CustomField5] [varchar](255) NULL,
	[CustomField6] [varchar](255) NULL,
	[CustomField7] [varchar](255) NULL,
	[CustomField8] [varchar](255) NULL,
	[CustomField9] [varchar](255) NULL,
	[CustomField10] [varchar](255) NULL,
	[CustomField11] [varchar](255) NULL,
	[CustomField12] [varchar](255) NULL,
	[CustomField13] [varchar](255) NULL,
	[CustomField14] [varchar](255) NULL,
	[CustomField15] [varchar](255) NULL,
	[PARENT_IDKEY] [varchar](36) NULL,
	[GroupPARENT_IDKEY] [varchar](255) NULL,
	[SeqNum] [int] NULL,
	[LSData] [varchar](10) NULL
) ON [PRIMARY]
GO




CREATE TABLE [dbo].[ratehistory](
	[Rate] [decimal](15, 5) NULL,
	[EffectiveDate] [datetime] NULL,
	[PARENT_IDKEY] [varchar](36) NULL,
	[SeqNum] [int] NULL,
	[LSData] [varchar](10) NULL
) ON [PRIMARY]
GO




CREATE TABLE [dbo].[receivepayment](
	[TxnID] [varchar](36) NOT NULL,
	[TimeCreated] [datetime] NULL,
	[TimeModified] [datetime] NULL,
	[EditSequence] [varchar](16) NULL,
	[TxnNumber] [int] NULL,
	[CustomerRef_ListID] [varchar](36) NULL,
	[CustomerRef_FullName] [varchar](209) NULL,
	[ARAccountRef_ListID] [varchar](36) NULL,
	[ARAccountRef_FullName] [varchar](159) NULL,
	[TxnDate] [datetime] NULL,
	[RefNumber] [varchar](25) NULL,
	[TotalAmount] [decimal](15, 2) NULL,
	[CurrencyRef_ListID] [varchar](36) NULL,
	[CurrencyRef_FullName] [varchar](64) NULL,
	[ExchangeRate] [decimal](15, 5) NULL,
	[TotalAmountInHomeCurrency] [decimal](15, 2) NULL,
	[PaymentMethodRef_ListID] [varchar](36) NULL,
	[PaymentMethodRef_FullName] [varchar](31) NULL,
	[Memo] [varchar](4095) NULL,
	[DepositToAccountRef_ListID] [varchar](36) NULL,
	[DepositToAccountRef_FullName] [varchar](159) NULL,
	[UnusedPayment] [decimal](15, 5) NULL,
	[UnusedCredits] [decimal](15, 5) NULL,
	[CCTII_CreditCardNumber] [varchar](25) NULL,
	[CCTII_ExpirationMonth] [int] NULL,
	[CCTII_ExpirationYear] [int] NULL,
	[CCTII_NameOnCard] [varchar](41) NULL,
	[CCTII_CreditCardAddress] [varchar](41) NULL,
	[CCTII_CreditCardPostalCode] [varchar](18) NULL,
	[CCTII_CommercialCardCode] [varchar](24) NULL,
	[CCTII_TransactionMode] [varchar](255) NULL,
	[CCTII_CreditCardTxnType] [varchar](255) NULL,
	[CCTRI_ResultCode] [int] NULL,
	[CCTRI_ResultMessage] [varchar](60) NULL,
	[CCTRI_CreditCardTransID] [varchar](24) NULL,
	[CCTRI_MerchantAccountNumber] [varchar](32) NULL,
	[CCTRI_AuthorizationCode] [varchar](12) NULL,
	[CCTRI_AVSStreet] [varchar](255) NULL,
	[CCTRI_AVSZip] [varchar](255) NULL,
	[CCTRI_CardSecurityCodeMatch] [varchar](255) NULL,
	[CCTRI_ReconBatchID] [varchar](84) NULL,
	[CCTRI_PaymentGroupingCode] [int] NULL,
	[CCTRI_PaymentStatus] [varchar](255) NULL,
	[CCTRI_TxnAuthorizationTime] [datetime] NULL,
	[CCTRI_TxnAuthorizationStamp] [int] NULL,
	[CCTRI_ClientTransID] [varchar](16) NULL,
	[ExternalGUID] [varchar](255) NULL,
	[LSData] [varchar](10) NULL,
	[CustomField1] [varchar](255) NULL,
	[CustomField2] [varchar](255) NULL,
	[CustomField3] [varchar](255) NULL,
	[CustomField4] [varchar](255) NULL,
	[CustomField5] [varchar](255) NULL,
	[CustomField6] [varchar](255) NULL,
	[CustomField7] [varchar](255) NULL,
	[CustomField8] [varchar](255) NULL,
	[CustomField9] [varchar](255) NULL,
	[CustomField10] [varchar](255) NULL,
	[CustomField11] [varchar](255) NULL,
	[CustomField12] [varchar](255) NULL,
	[CustomField13] [varchar](255) NULL,
	[CustomField14] [varchar](255) NULL,
	[CustomField15] [varchar](255) NULL,
	[Operation] [varchar](10) NULL,
	[UserData] [varchar](255) NULL,
 CONSTRAINT [PK_receivepayment] PRIMARY KEY CLUSTERED 
(
	[TxnID] ASC
)WITH (PAD_INDEX = OFF, STATISTICS_NORECOMPUTE = OFF, IGNORE_DUP_KEY = OFF, ALLOW_ROW_LOCKS = ON, ALLOW_PAGE_LOCKS = ON, OPTIMIZE_FOR_SEQUENTIAL_KEY = OFF) ON [PRIMARY]
) ON [PRIMARY]
GO




CREATE TABLE [dbo].[receivepaymenttodeposit](
	[TxnID] [varchar](36) NOT NULL,
	[TxnLineID] [varchar](36) NULL,
	[TxnType] [varchar](255) NULL,
	[CustomerRef_ListID] [varchar](36) NULL,
	[CustomerRef_FullName] [varchar](209) NULL,
	[TxnDate] [datetime] NULL,
	[RefNumber] [varchar](25) NULL,
	[Amount] [decimal](15, 2) NULL,
	[CurrencyRef_ListID] [varchar](36) NULL,
	[CurrencyRef_FullName] [varchar](64) NULL,
	[ExchangeRate] [decimal](15, 5) NULL,
	[AmountInHomeCurrency] [decimal](15, 2) NULL,
	[UserData] [varchar](255) NULL,
	[Operation] [varchar](10) NULL,
	[LSData] [varchar](10) NULL,
 CONSTRAINT [PK_receivepaymenttodeposit] PRIMARY KEY CLUSTERED 
(
	[TxnID] ASC
)WITH (PAD_INDEX = OFF, STATISTICS_NORECOMPUTE = OFF, IGNORE_DUP_KEY = OFF, ALLOW_ROW_LOCKS = ON, ALLOW_PAGE_LOCKS = ON, OPTIMIZE_FOR_SEQUENTIAL_KEY = OFF) ON [PRIMARY]
) ON [PRIMARY]
GO




CREATE TABLE [dbo].[relatedunitret](
	[Name] [varchar](31) NULL,
	[Abbreviation] [varchar](31) NULL,
	[ConversionRatio] [decimal](15, 5) NULL,
	[PARENT_IDKEY] [varchar](36) NULL,
	[SeqNum] [int] NULL,
	[LSData] [varchar](10) NULL
) ON [PRIMARY]
GO




CREATE TABLE [dbo].[salesandpurchaseret](
	[SalesDesc] [varchar](4095) NULL,
	[SalesPrice] [decimal](15, 5) NULL,
	[IncomeAccountRef_ListID] [varchar](36) NULL,
	[IncomeAccountRef_FullName] [varchar](159) NULL,
	[PurchaseDesc] [varchar](4095) NULL,
	[PurchaseCost] [decimal](15, 5) NULL,
	[PurchaseTaxCodeRef_ListID] [varchar](36) NULL,
	[PurchaseTaxCodeRef_FullName] [varchar](3) NULL,
	[ExpenseAccountRef_ListID] [varchar](36) NULL,
	[ExpenseAccountRef_FullName] [varchar](159) NULL,
	[PrefVendorRef_ListID] [varchar](36) NULL,
	[PrefVendorRef_FullName] [varchar](41) NULL,
	[PARENT_IDKEY] [varchar](36) NULL,
	[SeqNum] [int] NULL,
	[LSData] [varchar](10) NULL
) ON [PRIMARY]
GO




CREATE TABLE [dbo].[salesorder](
	[TxnID] [varchar](36) NOT NULL,
	[TimeCreated] [datetime] NULL,
	[TimeModified] [datetime] NULL,
	[EditSequence] [varchar](16) NULL,
	[TxnNumber] [int] NULL,
	[CustomerRef_ListID] [varchar](36) NULL,
	[CustomerRef_FullName] [varchar](209) NULL,
	[ClassRef_ListID] [varchar](36) NULL,
	[ClassRef_FullName] [varchar](159) NULL,
	[TemplateRef_ListID] [varchar](36) NULL,
	[TemplateRef_FullName] [varchar](31) NULL,
	[TxnDate] [datetime] NULL,
	[RefNumber] [varchar](25) NULL,
	[BillAddress_Addr1] [varchar](41) NULL,
	[BillAddress_Addr2] [varchar](41) NULL,
	[BillAddress_Addr3] [varchar](41) NULL,
	[BillAddress_Addr4] [varchar](41) NULL,
	[BillAddress_Addr5] [varchar](41) NULL,
	[BillAddress_City] [varchar](31) NULL,
	[BillAddress_State] [varchar](21) NULL,
	[BillAddress_PostalCode] [varchar](13) NULL,
	[BillAddress_Country] [varchar](31) NULL,
	[BillAddress_Note] [varchar](41) NULL,
	[ShipAddress_Addr1] [varchar](41) NULL,
	[ShipAddress_Addr2] [varchar](41) NULL,
	[ShipAddress_Addr3] [varchar](41) NULL,
	[ShipAddress_Addr4] [varchar](41) NULL,
	[ShipAddress_Addr5] [varchar](41) NULL,
	[ShipAddress_City] [varchar](31) NULL,
	[ShipAddress_State] [varchar](21) NULL,
	[ShipAddress_PostalCode] [varchar](13) NULL,
	[ShipAddress_Country] [varchar](31) NULL,
	[ShipAddress_Note] [varchar](41) NULL,
	[PONumber] [varchar](25) NULL,
	[TermsRef_ListID] [varchar](36) NULL,
	[TermsRef_FullName] [varchar](31) NULL,
	[DueDate] [datetime] NULL,
	[SalesRepRef_ListID] [varchar](36) NULL,
	[SalesRepRef_FullName] [varchar](5) NULL,
	[FOB] [varchar](13) NULL,
	[ShipDate] [datetime] NULL,
	[ShipMethodRef_ListID] [varchar](36) NULL,
	[ShipMethodRef_FullName] [varchar](15) NULL,
	[Subtotal] [decimal](15, 2) NULL,
	[ItemSalesTaxRef_ListID] [varchar](36) NULL,
	[ItemSalesTaxRef_FullName] [varchar](31) NULL,
	[SalesTaxPercentage] [decimal](15, 5) NULL,
	[SalesTaxTotal] [decimal](15, 2) NULL,
	[TotalAmount] [decimal](15, 2) NULL,
	[CurrencyRef_ListID] [varchar](36) NULL,
	[CurrencyRef_FullName] [varchar](64) NULL,
	[ExchangeRate] [decimal](15, 5) NULL,
	[TotalAmountInHomeCurrency] [decimal](15, 2) NULL,
	[IsManuallyClosed] [bit] NULL,
	[IsFullyInvoiced] [bit] NULL,
	[Memo] [varchar](4095) NULL,
	[CustomerMsgRef_ListID] [varchar](36) NULL,
	[CustomerMsgRef_FullName] [varchar](101) NULL,
	[IsToBePrinted] [bit] NULL,
	[IsToBeEmailed] [bit] NULL,
	[IsTaxIncluded] [bit] NULL,
	[CustSalesTaxCodeRef_ListID] [varchar](36) NULL,
	[CustSalesTaxCodeRef_FullName] [varchar](3) NULL,
	[Other] [varchar](29) NULL,
	[ExternalGUID] [varchar](255) NULL,
	[CustomField1] [varchar](255) NULL,
	[CustomField2] [varchar](255) NULL,
	[CustomField3] [varchar](255) NULL,
	[CustomField4] [varchar](255) NULL,
	[CustomField5] [varchar](255) NULL,
	[CustomField6] [varchar](255) NULL,
	[CustomField7] [varchar](255) NULL,
	[CustomField8] [varchar](255) NULL,
	[CustomField9] [varchar](255) NULL,
	[CustomField10] [varchar](255) NULL,
	[CustomField11] [varchar](255) NULL,
	[CustomField12] [varchar](255) NULL,
	[CustomField13] [varchar](255) NULL,
	[CustomField14] [varchar](255) NULL,
	[CustomField15] [varchar](255) NULL,
	[UserData] [varchar](255) NULL,
	[Operation] [varchar](10) NULL,
	[LSData] [varchar](10) NULL,
 CONSTRAINT [PK_salesorder] PRIMARY KEY CLUSTERED 
(
	[TxnID] ASC
)WITH (PAD_INDEX = OFF, STATISTICS_NORECOMPUTE = OFF, IGNORE_DUP_KEY = OFF, ALLOW_ROW_LOCKS = ON, ALLOW_PAGE_LOCKS = ON, OPTIMIZE_FOR_SEQUENTIAL_KEY = OFF) ON [PRIMARY]
) ON [PRIMARY]
GO




CREATE TABLE [dbo].[salesorderlinegroupret](
	[TxnLineID] [varchar](36) NULL,
	[ItemGroupRef_ListID] [varchar](36) NULL,
	[ItemGroupRef_FullName] [varchar](31) NULL,
	[Desc] [varchar](4095) NULL,
	[Quantity] [decimal](15, 5) NULL,
	[IsPrintItemsInGroup] [bit] NULL,
	[TotalAmount] [decimal](15, 2) NULL,
	[CustomField1] [varchar](255) NULL,
	[CustomField2] [varchar](255) NULL,
	[CustomField3] [varchar](255) NULL,
	[CustomField4] [varchar](255) NULL,
	[CustomField5] [varchar](255) NULL,
	[CustomField6] [varchar](255) NULL,
	[CustomField7] [varchar](255) NULL,
	[CustomField8] [varchar](255) NULL,
	[CustomField9] [varchar](255) NULL,
	[CustomField10] [varchar](255) NULL,
	[CustomField11] [varchar](255) NULL,
	[CustomField12] [varchar](255) NULL,
	[CustomField13] [varchar](255) NULL,
	[CustomField14] [varchar](255) NULL,
	[CustomField15] [varchar](255) NULL,
	[PARENT_IDKEY] [varchar](36) NULL,
	[GroupPARENT_IDKEY] [varchar](255) NULL,
	[SeqNum] [int] NULL,
	[LSData] [varchar](10) NULL
) ON [PRIMARY]
GO




CREATE TABLE [dbo].[salesorderlineret](
	[TxnLineID] [varchar](36) NULL,
	[ItemRef_ListID] [varchar](36) NULL,
	[ItemRef_FullName] [varchar](209) NULL,
	[Desc] [varchar](4095) NULL,
	[Quantity] [decimal](15, 5) NULL,
	[UnitOfMeasure] [varchar](31) NULL,
	[OverrideUOMSetRef_ListID] [varchar](36) NULL,
	[OverrideUOMSetRef_FullName] [varchar](31) NULL,
	[Rate] [decimal](15, 5) NULL,
	[RatePercent] [decimal](15, 5) NULL,
	[ClassRef_ListID] [varchar](36) NULL,
	[ClassRef_FullName] [varchar](209) NULL,
	[Amount] [decimal](15, 2) NULL,
	[InvSiteRef_ListID] [varchar](36) NULL,
	[InvSiteRef_FullName] [varchar](31) NULL,
	[InvSiteLocRef_ListID] [varchar](36) NULL,
	[InvSiteLocRef_FullName] [varchar](31) NULL,
	[SerialNumber] [varchar](4095) NULL,
	[LotNumber] [varchar](40) NULL,
	[SalesTaxCodeRef_ListID] [varchar](36) NULL,
	[SalesTaxCodeRef_FullName] [varchar](3) NULL,
	[Invoiced] [decimal](15, 5) NULL,
	[IsManuallyClosed] [bit] NULL,
	[Other1] [varchar](29) NULL,
	[Other2] [varchar](29) NULL,
	[CustomField1] [varchar](255) NULL,
	[CustomField2] [varchar](255) NULL,
	[CustomField3] [varchar](255) NULL,
	[CustomField4] [varchar](255) NULL,
	[CustomField5] [varchar](255) NULL,
	[CustomField6] [varchar](255) NULL,
	[CustomField7] [varchar](255) NULL,
	[CustomField8] [varchar](255) NULL,
	[CustomField9] [varchar](255) NULL,
	[CustomField10] [varchar](255) NULL,
	[CustomField11] [varchar](255) NULL,
	[CustomField12] [varchar](255) NULL,
	[CustomField13] [varchar](255) NULL,
	[CustomField14] [varchar](255) NULL,
	[CustomField15] [varchar](255) NULL,
	[PARENT_IDKEY] [varchar](36) NULL,
	[GroupPARENT_IDKEY] [varchar](255) NULL,
	[SeqNum] [int] NULL,
	[LSData] [varchar](10) NULL
) ON [PRIMARY]
GO




CREATE TABLE [dbo].[salesorpurchaseret](
	[Desc] [varchar](4095) NULL,
	[Price] [decimal](15, 5) NULL,
	[PricePercent] [decimal](15, 5) NULL,
	[AccountRef_ListID] [varchar](36) NULL,
	[AccountRef_FullName] [varchar](159) NULL,
	[PARENT_IDKEY] [varchar](36) NULL,
	[SeqNum] [int] NULL,
	[LSData] [varchar](10) NULL
) ON [PRIMARY]
GO




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




CREATE TABLE [dbo].[salesreceiptlinegroupret](
	[TxnLineID] [varchar](36) NULL,
	[ItemGroupRef_ListID] [varchar](36) NULL,
	[ItemGroupRef_FullName] [varchar](159) NULL,
	[Desc] [varchar](4095) NULL,
	[Quantity] [decimal](15, 5) NULL,
	[UnitOfMeasure] [varchar](31) NULL,
	[OverrideUOMSetRef_ListID] [varchar](36) NULL,
	[OverrideUOMSetRef_FullName] [varchar](31) NULL,
	[IsPrintItemsInGroup] [bit] NULL,
	[TotalAmount] [decimal](15, 2) NULL,
	[ServiceDate] [datetime] NULL,
	[CustomField1] [varchar](255) NULL,
	[CustomField2] [varchar](255) NULL,
	[CustomField3] [varchar](255) NULL,
	[CustomField4] [varchar](255) NULL,
	[CustomField5] [varchar](255) NULL,
	[CustomField6] [varchar](255) NULL,
	[CustomField7] [varchar](255) NULL,
	[CustomField8] [varchar](255) NULL,
	[CustomField9] [varchar](255) NULL,
	[CustomField10] [varchar](255) NULL,
	[CustomField11] [varchar](255) NULL,
	[CustomField12] [varchar](255) NULL,
	[CustomField13] [varchar](255) NULL,
	[CustomField14] [varchar](255) NULL,
	[CustomField15] [varchar](255) NULL,
	[PARENT_IDKEY] [varchar](36) NULL,
	[GroupPARENT_IDKEY] [varchar](255) NULL,
	[SeqNum] [int] NULL,
	[LSData] [varchar](10) NULL
) ON [PRIMARY]
GO




CREATE TABLE [dbo].[salesreceiptlineret](
	[TxnLineID] [varchar](36) NULL,
	[ItemRef_ListID] [varchar](36) NULL,
	[ItemRef_FullName] [varchar](159) NULL,
	[Desc] [varchar](4095) NULL,
	[Quantity] [decimal](15, 5) NULL,
	[UnitOfMeasure] [varchar](31) NULL,
	[OverrideUOMSetRef_ListID] [varchar](36) NULL,
	[OverrideUOMSetRef_FullName] [varchar](31) NULL,
	[Rate] [decimal](15, 5) NULL,
	[RatePercent] [decimal](15, 5) NULL,
	[ClassRef_ListID] [varchar](36) NULL,
	[ClassRef_FullName] [varchar](159) NULL,
	[Amount] [decimal](15, 2) NULL,
	[TaxAmount] [decimal](15, 2) NULL,
	[InvSiteRef_ListID] [varchar](36) NULL,
	[InvSiteRef_FullName] [varchar](31) NULL,
	[InvSiteLocRef_ListID] [varchar](36) NULL,
	[InvSiteLocRef_FullName] [varchar](209) NULL,
	[SerialNumber] [varchar](4095) NULL,
	[LotNumber] [varchar](40) NULL,
	[ServiceDate] [datetime] NULL,
	[SalesTaxCodeRef_ListID] [varchar](36) NULL,
	[SalesTaxCodeRef_FullName] [varchar](3) NULL,
	[Other1] [varchar](29) NULL,
	[Other2] [varchar](29) NULL,
	[CCTII_CreditCardNumber] [varchar](25) NULL,
	[CCTII_ExpirationMonth] [int] NULL,
	[CCTII_ExpirationYear] [int] NULL,
	[CCTII_NameOnCard] [varchar](41) NULL,
	[CCTII_CreditCardAddress] [varchar](41) NULL,
	[CCTII_CreditCardPostalCode] [varchar](18) NULL,
	[CCTII_CommercialCardCode] [varchar](24) NULL,
	[CCTII_TransactionMode] [varchar](255) NULL,
	[CCTII_CreditCardTxnType] [varchar](255) NULL,
	[CCTRI_ResultCode] [int] NULL,
	[CCTRI_ResultMessage] [varchar](60) NULL,
	[CCTRI_CreditCardTransID] [varchar](24) NULL,
	[CCTRI_MerchantAccountNumber] [varchar](32) NULL,
	[CCTRI_AuthorizationCode] [varchar](12) NULL,
	[CCTRI_AVSStreet] [varchar](255) NULL,
	[CCTRI_AVSZip] [varchar](255) NULL,
	[CCTRI_CardSecurityCodeMatch] [varchar](255) NULL,
	[CCTRI_ReconBatchID] [varchar](84) NULL,
	[CCTRI_PaymentGroupingCode] [int] NULL,
	[CCTRI_PaymentStatus] [varchar](255) NULL,
	[CCTRI_TxnAuthorizationTime] [datetime] NULL,
	[CCTRI_TxnAuthorizationStamp] [int] NULL,
	[CCTRI_ClientTransID] [varchar](16) NULL,
	[CustomField1] [varchar](255) NULL,
	[CustomField2] [varchar](255) NULL,
	[CustomField3] [varchar](255) NULL,
	[CustomField4] [varchar](255) NULL,
	[CustomField5] [varchar](255) NULL,
	[CustomField6] [varchar](255) NULL,
	[CustomField7] [varchar](255) NULL,
	[CustomField8] [varchar](255) NULL,
	[CustomField9] [varchar](255) NULL,
	[CustomField10] [varchar](255) NULL,
	[CustomField11] [varchar](255) NULL,
	[CustomField12] [varchar](255) NULL,
	[CustomField13] [varchar](255) NULL,
	[CustomField14] [varchar](255) NULL,
	[CustomField15] [varchar](255) NULL,
	[PARENT_IDKEY] [varchar](36) NULL,
	[GroupPARENT_IDKEY] [varchar](255) NULL,
	[SeqNum] [int] NULL,
	[LSData] [varchar](10) NULL
) ON [PRIMARY]
GO




CREATE TABLE [dbo].[salesrep](
	[ListID] [varchar](36) NOT NULL,
	[TimeCreated] [datetime] NULL,
	[TimeModified] [datetime] NULL,
	[EditSequence] [varchar](16) NULL,
	[Initial] [varchar](5) NULL,
	[IsActive] [bit] NULL,
	[SalesRepEntityRef_ListID] [varchar](36) NULL,
	[SalesRepEntityRef_FullName] [varchar](41) NULL,
	[UserData] [varchar](255) NULL,
	[Operation] [varchar](10) NULL,
	[LSData] [varchar](10) NULL,
 CONSTRAINT [PK_salesrep] PRIMARY KEY CLUSTERED 
(
	[ListID] ASC
)WITH (PAD_INDEX = OFF, STATISTICS_NORECOMPUTE = OFF, IGNORE_DUP_KEY = OFF, ALLOW_ROW_LOCKS = ON, ALLOW_PAGE_LOCKS = ON, OPTIMIZE_FOR_SEQUENTIAL_KEY = OFF) ON [PRIMARY]
) ON [PRIMARY]
GO




CREATE TABLE [dbo].[salestaxcode](
	[ListID] [varchar](36) NOT NULL,
	[TimeCreated] [datetime] NULL,
	[TimeModified] [datetime] NULL,
	[EditSequence] [varchar](16) NULL,
	[Name] [varchar](3) NULL,
	[IsActive] [bit] NULL,
	[IsTaxable] [bit] NULL,
	[Desc] [varchar](31) NULL,
	[ItemPurchaseTaxRef_ListID] [varchar](36) NULL,
	[ItemPurchaseTaxRef_FullName] [varchar](31) NULL,
	[ItemSalesTaxRef_ListID] [varchar](36) NULL,
	[ItemSalesTaxRef_FullName] [varchar](31) NULL,
	[UserData] [varchar](255) NULL,
	[Operation] [varchar](10) NULL,
	[LSData] [varchar](10) NULL,
 CONSTRAINT [PK_salestaxcode] PRIMARY KEY CLUSTERED 
(
	[ListID] ASC
)WITH (PAD_INDEX = OFF, STATISTICS_NORECOMPUTE = OFF, IGNORE_DUP_KEY = OFF, ALLOW_ROW_LOCKS = ON, ALLOW_PAGE_LOCKS = ON, OPTIMIZE_FOR_SEQUENTIAL_KEY = OFF) ON [PRIMARY]
) ON [PRIMARY]
GO




CREATE TABLE [dbo].[salestaxpaymentcheck](
	[TxnID] [varchar](36) NOT NULL,
	[TimeCreated] [datetime] NULL,
	[TimeModified] [datetime] NULL,
	[EditSequence] [varchar](16) NULL,
	[TxnNumber] [int] NULL,
	[PayeeEntityRef_ListID] [varchar](36) NULL,
	[PayeeEntityRef_FullName] [varchar](209) NULL,
	[TxnDate] [datetime] NULL,
	[BankAccountRef_ListID] [varchar](36) NULL,
	[BankAccountRef_FullName] [varchar](159) NULL,
	[Amount] [decimal](15, 2) NULL,
	[RefNumber] [varchar](25) NULL,
	[Memo] [varchar](4095) NULL,
	[Address_Addr1] [varchar](41) NULL,
	[Address_Addr2] [varchar](41) NULL,
	[Address_Addr3] [varchar](41) NULL,
	[Address_Addr4] [varchar](41) NULL,
	[Address_Addr5] [varchar](41) NULL,
	[Address_City] [varchar](31) NULL,
	[Address_State] [varchar](21) NULL,
	[Address_PostalCode] [varchar](13) NULL,
	[Address_Country] [varchar](31) NULL,
	[Address_Note] [varchar](41) NULL,
	[IsToBePrinted] [bit] NULL,
	[ExternalGUID] [varchar](255) NULL,
	[UserData] [varchar](255) NULL,
	[Operation] [varchar](10) NULL,
	[LSData] [varchar](10) NULL,
 CONSTRAINT [PK_salestaxpaymentcheck] PRIMARY KEY CLUSTERED 
(
	[TxnID] ASC
)WITH (PAD_INDEX = OFF, STATISTICS_NORECOMPUTE = OFF, IGNORE_DUP_KEY = OFF, ALLOW_ROW_LOCKS = ON, ALLOW_PAGE_LOCKS = ON, OPTIMIZE_FOR_SEQUENTIAL_KEY = OFF) ON [PRIMARY]
) ON [PRIMARY]
GO




CREATE TABLE [dbo].[salestaxpaymentchecklineret](
	[TxnLineID] [varchar](36) NULL,
	[ItemSalesTaxRef_ListID] [varchar](36) NULL,
	[ItemSalesTaxRef_FullName] [varchar](31) NULL,
	[Amount] [decimal](15, 2) NULL,
	[TaxAmount] [decimal](15, 2) NULL,
	[PARENT_IDKEY] [varchar](36) NULL,
	[SeqNum] [int] NULL,
	[LSData] [varchar](10) NULL
) ON [PRIMARY]
GO




CREATE TABLE [dbo].[setcredit](
	[CreditTxnID] [varchar](36) NULL,
	[AppliedAmount] [decimal](15, 2) NULL,
	[Override] [bit] NULL,
	[PARENT_IDKEY] [varchar](36) NULL
) ON [PRIMARY]
GO




CREATE TABLE [dbo].[shipmethod](
	[ListID] [varchar](36) NOT NULL,
	[TimeCreated] [datetime] NULL,
	[TimeModified] [datetime] NULL,
	[EditSequence] [varchar](16) NULL,
	[Name] [varchar](15) NULL,
	[IsActive] [bit] NULL,
	[UserData] [varchar](255) NULL,
	[Operation] [varchar](10) NULL,
	[LSData] [varchar](10) NULL,
 CONSTRAINT [PK_shipmethod] PRIMARY KEY CLUSTERED 
(
	[ListID] ASC
)WITH (PAD_INDEX = OFF, STATISTICS_NORECOMPUTE = OFF, IGNORE_DUP_KEY = OFF, ALLOW_ROW_LOCKS = ON, ALLOW_PAGE_LOCKS = ON, OPTIMIZE_FOR_SEQUENTIAL_KEY = OFF) ON [PRIMARY]
) ON [PRIMARY]
GO




CREATE TABLE [dbo].[shiptoaddressret](
	[Name] [varchar](41) NULL,
	[Addr1] [varchar](41) NULL,
	[Addr2] [varchar](41) NULL,
	[Addr3] [varchar](41) NULL,
	[Addr4] [varchar](41) NULL,
	[Addr5] [varchar](41) NULL,
	[City] [varchar](31) NULL,
	[State] [varchar](21) NULL,
	[PostalCode] [varchar](13) NULL,
	[Country] [varchar](31) NULL,
	[Notes] [varchar](41) NULL,
	[DefaultShipTo] [bit] NULL,
	[PARENT_IDKEY] [varchar](36) NULL,
	[SeqNum] [int] NULL,
	[LSData] [varchar](10) NULL
) ON [PRIMARY]
GO




CREATE TABLE [dbo].[standardterms](
	[ListID] [varchar](36) NOT NULL,
	[TimeCreated] [datetime] NULL,
	[TimeModified] [datetime] NULL,
	[EditSequence] [varchar](16) NULL,
	[Name] [varchar](31) NULL,
	[IsActive] [bit] NULL,
	[StdDueDays] [int] NULL,
	[StdDiscountDays] [int] NULL,
	[DiscountPct] [decimal](15, 5) NULL,
	[UserData] [varchar](255) NULL,
	[Operation] [varchar](10) NULL,
	[LSData] [varchar](10) NULL,
 CONSTRAINT [PK_standardterms] PRIMARY KEY CLUSTERED 
(
	[ListID] ASC
)WITH (PAD_INDEX = OFF, STATISTICS_NORECOMPUTE = OFF, IGNORE_DUP_KEY = OFF, ALLOW_ROW_LOCKS = ON, ALLOW_PAGE_LOCKS = ON, OPTIMIZE_FOR_SEQUENTIAL_KEY = OFF) ON [PRIMARY]
) ON [PRIMARY]
GO




CREATE TABLE [dbo].[template](
	[ListID] [varchar](36) NOT NULL,
	[TimeCreated] [datetime] NULL,
	[TimeModified] [datetime] NULL,
	[EditSequence] [varchar](16) NULL,
	[Name] [varchar](255) NULL,
	[IsActive] [bit] NULL,
	[TemplateType] [varchar](255) NULL,
	[UserData] [varchar](255) NULL,
	[Operation] [varchar](10) NULL,
	[LSData] [varchar](10) NULL,
 CONSTRAINT [PK_template] PRIMARY KEY CLUSTERED 
(
	[ListID] ASC
)WITH (PAD_INDEX = OFF, STATISTICS_NORECOMPUTE = OFF, IGNORE_DUP_KEY = OFF, ALLOW_ROW_LOCKS = ON, ALLOW_PAGE_LOCKS = ON, OPTIMIZE_FOR_SEQUENTIAL_KEY = OFF) ON [PRIMARY]
) ON [PRIMARY]
GO




CREATE TABLE [dbo].[terms](
	[ListID] [varchar](36) NOT NULL,
	[Name] [varchar](200) NULL,
	[TableName] [varchar](200) NULL,
	[UserData] [varchar](255) NULL,
	[Operation] [varchar](10) NULL,
	[LSData] [varchar](10) NULL,
 CONSTRAINT [PK_terms] PRIMARY KEY CLUSTERED 
(
	[ListID] ASC
)WITH (PAD_INDEX = OFF, STATISTICS_NORECOMPUTE = OFF, IGNORE_DUP_KEY = OFF, ALLOW_ROW_LOCKS = ON, ALLOW_PAGE_LOCKS = ON, OPTIMIZE_FOR_SEQUENTIAL_KEY = OFF) ON [PRIMARY]
) ON [PRIMARY]
GO




CREATE TABLE [dbo].[timetracking](
	[TxnID] [varchar](36) NOT NULL,
	[TimeCreated] [datetime] NULL,
	[TimeModified] [datetime] NULL,
	[EditSequence] [varchar](16) NULL,
	[TxnNumber] [int] NULL,
	[TxnDate] [datetime] NULL,
	[EntityRef_ListID] [varchar](36) NULL,
	[EntityRef_FullName] [varchar](209) NULL,
	[CustomerRef_ListID] [varchar](36) NULL,
	[CustomerRef_FullName] [varchar](209) NULL,
	[ItemServiceRef_ListID] [varchar](36) NULL,
	[ItemServiceRef_FullName] [varchar](159) NULL,
	[Rate] [decimal](15, 5) NULL,
	[Duration] [varchar](50) NULL,
	[ClassRef_ListID] [varchar](36) NULL,
	[ClassRef_FullName] [varchar](159) NULL,
	[PayrollItemWageRef_ListID] [varchar](36) NULL,
	[PayrollItemWageRef_FullName] [varchar](31) NULL,
	[Notes] [varchar](4095) NULL,
	[IsBillable] [bit] NULL,
	[IsBilled] [bit] NULL,
	[BillableStatus] [varchar](255) NULL,
	[ExternalGUID] [varchar](255) NULL,
	[UserData] [varchar](255) NULL,
	[Operation] [varchar](10) NULL,
	[LSData] [varchar](10) NULL,
 CONSTRAINT [PK_timetracking] PRIMARY KEY CLUSTERED 
(
	[TxnID] ASC
)WITH (PAD_INDEX = OFF, STATISTICS_NORECOMPUTE = OFF, IGNORE_DUP_KEY = OFF, ALLOW_ROW_LOCKS = ON, ALLOW_PAGE_LOCKS = ON, OPTIMIZE_FOR_SEQUENTIAL_KEY = OFF) ON [PRIMARY]
) ON [PRIMARY]
GO




CREATE TABLE [dbo].[todo](
	[ListID] [varchar](36) NOT NULL,
	[TimeCreated] [datetime] NULL,
	[TimeModified] [datetime] NULL,
	[EditSequence] [varchar](16) NULL,
	[Notes] [varchar](4095) NULL,
	[Type] [varchar](255) NULL,
	[Priority] [varchar](255) NULL,
	[IsActive] [bit] NULL,
	[IsDone] [bit] NULL,
	[ReminderDate] [datetime] NULL,
	[ReminderTime] [varchar](50) NULL,
	[CustomerRef_ListID] [varchar](36) NULL,
	[CustomerRef_FullName] [varchar](209) NULL,
	[EmployeeRef_ListID] [varchar](36) NULL,
	[EmployeeRef_FullName] [varchar](31) NULL,
	[LeadRef_ListID] [varchar](36) NULL,
	[LeadRef_FullName] [varchar](209) NULL,
	[VendorRef_ListID] [varchar](36) NULL,
	[VendorRef_FullName] [varchar](209) NULL,
	[UserData] [varchar](255) NULL,
	[Operation] [varchar](10) NULL,
	[LSData] [varchar](10) NULL,
 CONSTRAINT [PK_todo] PRIMARY KEY CLUSTERED 
(
	[ListID] ASC
)WITH (PAD_INDEX = OFF, STATISTICS_NORECOMPUTE = OFF, IGNORE_DUP_KEY = OFF, ALLOW_ROW_LOCKS = ON, ALLOW_PAGE_LOCKS = ON, OPTIMIZE_FOR_SEQUENTIAL_KEY = OFF) ON [PRIMARY]
) ON [PRIMARY]
GO




CREATE TABLE [dbo].[transaction](
	[TxnID] [varchar](36) NOT NULL,
	[TxnType] [varchar](255) NULL,
	[TxnLineID] [varchar](36) NULL,
	[TimeCreated] [datetime] NULL,
	[TimeModified] [datetime] NULL,
	[EntityRef_ListID] [varchar](36) NULL,
	[EntityRef_FullName] [varchar](209) NULL,
	[AccountRef_ListID] [varchar](36) NULL,
	[AccountRef_FullName] [varchar](159) NULL,
	[TxnDate] [datetime] NULL,
	[RefNumber] [varchar](25) NULL,
	[Amount] [decimal](15, 2) NULL,
	[CurrencyRef_ListID] [varchar](36) NULL,
	[CurrencyRef_FullName] [varchar](64) NULL,
	[ExchangeRate] [decimal](15, 5) NULL,
	[AmountInHomeCurrency] [decimal](15, 2) NULL,
	[Memo] [varchar](4095) NULL,
	[UserData] [varchar](255) NULL,
	[Operation] [varchar](10) NULL,
	[LSData] [varchar](10) NULL,
 CONSTRAINT [PK_transaction] PRIMARY KEY CLUSTERED 
(
	[TxnID] ASC
)WITH (PAD_INDEX = OFF, STATISTICS_NORECOMPUTE = OFF, IGNORE_DUP_KEY = OFF, ALLOW_ROW_LOCKS = ON, ALLOW_PAGE_LOCKS = ON, OPTIMIZE_FOR_SEQUENTIAL_KEY = OFF) ON [PRIMARY]
) ON [PRIMARY]
GO




CREATE TABLE [dbo].[transfer](
	[TxnID] [varchar](36) NOT NULL,
	[TimeCreated] [datetime] NULL,
	[TimeModified] [datetime] NULL,
	[EditSequence] [varchar](16) NULL,
	[TxnNumber] [int] NULL,
	[TxnDate] [datetime] NULL,
	[TransferFromAccountRef_ListID] [varchar](36) NULL,
	[TransferFromAccountRef_FullName] [varchar](159) NULL,
	[FromAccountBalance] [decimal](15, 2) NULL,
	[TransferToAccountRef_ListID] [varchar](36) NULL,
	[TransferToAccountRef_FullName] [varchar](159) NULL,
	[ToAccountBalance] [decimal](15, 2) NULL,
	[ClassRef_ListID] [varchar](36) NULL,
	[ClassRef_FullName] [varchar](159) NULL,
	[Amount] [decimal](15, 2) NULL,
	[Memo] [varchar](4095) NULL,
	[UserData] [varchar](255) NULL,
	[Operation] [varchar](10) NULL,
	[LSData] [varchar](10) NULL,
 CONSTRAINT [PK_transfer] PRIMARY KEY CLUSTERED 
(
	[TxnID] ASC
)WITH (PAD_INDEX = OFF, STATISTICS_NORECOMPUTE = OFF, IGNORE_DUP_KEY = OFF, ALLOW_ROW_LOCKS = ON, ALLOW_PAGE_LOCKS = ON, OPTIMIZE_FOR_SEQUENTIAL_KEY = OFF) ON [PRIMARY]
) ON [PRIMARY]
GO




CREATE TABLE [dbo].[transferinventory](
	[TxnID] [varchar](36) NOT NULL,
	[TimeCreated] [datetime] NULL,
	[TimeModified] [datetime] NULL,
	[EditSequence] [varchar](16) NULL,
	[TxnNumber] [int] NULL,
	[TxnDate] [datetime] NULL,
	[RefNumber] [varchar](25) NULL,
	[FromInvSiteRef_ListID] [varchar](36) NULL,
	[FromInvSiteRef_FullName] [varchar](31) NULL,
	[ToInvSiteRef_ListID] [varchar](36) NULL,
	[ToInvSiteRef_FullName] [varchar](31) NULL,
	[FromInvSiteLocRef_ListID] [varchar](36) NULL,
	[FromInvSiteLocRef_FullName] [varchar](31) NULL,
	[ToInvSiteLocRef_ListID] [varchar](36) NULL,
	[ToInvSiteLocRef_FullName] [varchar](31) NULL,
	[Memo] [varchar](4095) NULL,
	[ExternalGUID] [varchar](255) NULL,
	[UserData] [varchar](255) NULL,
	[Operation] [varchar](10) NULL,
	[LSData] [varchar](10) NULL,
 CONSTRAINT [PK_transferinventory] PRIMARY KEY CLUSTERED 
(
	[TxnID] ASC
)WITH (PAD_INDEX = OFF, STATISTICS_NORECOMPUTE = OFF, IGNORE_DUP_KEY = OFF, ALLOW_ROW_LOCKS = ON, ALLOW_PAGE_LOCKS = ON, OPTIMIZE_FOR_SEQUENTIAL_KEY = OFF) ON [PRIMARY]
) ON [PRIMARY]
GO




CREATE TABLE [dbo].[transferinventorylineret](
	[TxnLineID] [varchar](36) NULL,
	[ItemRef_ListID] [varchar](36) NULL,
	[ItemRef_FullName] [varchar](159) NULL,
	[QuantityTransferred] [decimal](15, 5) NULL,
	[SerialNumber] [varchar](4095) NULL,
	[LotNumber] [varchar](40) NULL,
	[FromInvSiteLocRef_ListID] [varchar](36) NULL,
	[FromInvSiteLocRef_FullName] [varchar](31) NULL,
	[ToInvSiteLocRef_ListID] [varchar](36) NULL,
	[ToInvSiteLocRef_FullName] [varchar](31) NULL,
	[PARENT_IDKEY] [varchar](36) NULL,
	[SeqNum] [int] NULL,
	[UserData] [varchar](255) NULL,
	[Operation] [varchar](10) NULL,
	[LSData] [varchar](10) NULL
) ON [PRIMARY]
GO




CREATE TABLE [dbo].[txndeleted](
	[TxnDelType] [varchar](255) NULL,
	[TxnID] [varchar](255) NOT NULL,
	[TimeCreated] [datetime] NULL,
	[TimeDeleted] [datetime] NULL,
	[RefNumber] [varchar](255) NULL,
 CONSTRAINT [PK_txndeleted] PRIMARY KEY CLUSTERED 
(
	[TxnID] ASC
)WITH (PAD_INDEX = OFF, STATISTICS_NORECOMPUTE = OFF, IGNORE_DUP_KEY = OFF, ALLOW_ROW_LOCKS = ON, ALLOW_PAGE_LOCKS = ON, OPTIMIZE_FOR_SEQUENTIAL_KEY = OFF) ON [PRIMARY]
) ON [PRIMARY]
GO




CREATE TABLE [dbo].[unitofmeasureset](
	[ListID] [varchar](36) NOT NULL,
	[TimeCreated] [datetime] NULL,
	[TimeModified] [datetime] NULL,
	[EditSequence] [varchar](16) NULL,
	[Name] [varchar](31) NULL,
	[IsActive] [bit] NULL,
	[UnitOfMeasureType] [varchar](255) NULL,
	[BaseUnitName] [varchar](31) NULL,
	[BaseUnitAbbreviation] [varchar](31) NULL,
	[UserData] [varchar](255) NULL,
	[Operation] [varchar](10) NULL,
	[LSData] [varchar](10) NULL,
 CONSTRAINT [PK_unitofmeasureset] PRIMARY KEY CLUSTERED 
(
	[ListID] ASC
)WITH (PAD_INDEX = OFF, STATISTICS_NORECOMPUTE = OFF, IGNORE_DUP_KEY = OFF, ALLOW_ROW_LOCKS = ON, ALLOW_PAGE_LOCKS = ON, OPTIMIZE_FOR_SEQUENTIAL_KEY = OFF) ON [PRIMARY]
) ON [PRIMARY]
GO




CREATE TABLE [dbo].[userconfig](
	[Name] [varchar](200) NULL,
	[Password] [varchar](200) NULL,
	[Email] [varchar](200) NULL,
	[Type] [varchar](100) NULL,
	[LastLogin] [datetime] NULL,
	[LSData] [varchar](10) NULL
) ON [PRIMARY]
GO




CREATE TABLE [dbo].[vehicle](
	[ListID] [varchar](36) NOT NULL,
	[TimeCreated] [datetime] NULL,
	[TimeModified] [datetime] NULL,
	[EditSequence] [varchar](16) NULL,
	[Name] [varchar](31) NULL,
	[IsActive] [bit] NULL,
	[Desc] [varchar](255) NULL,
	[UserData] [varchar](255) NULL,
	[Operation] [varchar](10) NULL,
	[LSData] [varchar](10) NULL,
 CONSTRAINT [PK_vehicle] PRIMARY KEY CLUSTERED 
(
	[ListID] ASC
)WITH (PAD_INDEX = OFF, STATISTICS_NORECOMPUTE = OFF, IGNORE_DUP_KEY = OFF, ALLOW_ROW_LOCKS = ON, ALLOW_PAGE_LOCKS = ON, OPTIMIZE_FOR_SEQUENTIAL_KEY = OFF) ON [PRIMARY]
) ON [PRIMARY]
GO




CREATE TABLE [dbo].[vehiclemileage](
	[TxnID] [varchar](36) NOT NULL,
	[TimeCreated] [datetime] NULL,
	[TimeModified] [datetime] NULL,
	[EditSequence] [varchar](16) NULL,
	[VehicleRef_ListID] [varchar](36) NULL,
	[VehicleRef_FullName] [varchar](31) NULL,
	[CustomerRef_ListID] [varchar](36) NULL,
	[CustomerRef_FullName] [varchar](209) NULL,
	[ItemRef_ListID] [varchar](36) NULL,
	[ItemRef_FullName] [varchar](159) NULL,
	[ClassRef_ListID] [varchar](36) NULL,
	[ClassRef_FullName] [varchar](159) NULL,
	[TripStartDate] [datetime] NULL,
	[TripEndDate] [datetime] NULL,
	[OdometerStart] [decimal](15, 5) NULL,
	[OdometerEnd] [decimal](15, 5) NULL,
	[TotalMiles] [decimal](15, 5) NULL,
	[Notes] [varchar](4095) NULL,
	[BillableStatus] [varchar](255) NULL,
	[StandardMileageRate] [decimal](15, 5) NULL,
	[StandardMileageTotalAmount] [decimal](15, 2) NULL,
	[BillableRate] [decimal](15, 5) NULL,
	[BillableAmount] [decimal](15, 2) NULL,
	[UserData] [varchar](255) NULL,
	[Operation] [varchar](10) NULL,
	[LSData] [varchar](10) NULL,
 CONSTRAINT [PK_vehiclemileage] PRIMARY KEY CLUSTERED 
(
	[TxnID] ASC
)WITH (PAD_INDEX = OFF, STATISTICS_NORECOMPUTE = OFF, IGNORE_DUP_KEY = OFF, ALLOW_ROW_LOCKS = ON, ALLOW_PAGE_LOCKS = ON, OPTIMIZE_FOR_SEQUENTIAL_KEY = OFF) ON [PRIMARY]
) ON [PRIMARY]
GO




CREATE TABLE [dbo].[vendor](
	[ListID] [varchar](36) NOT NULL,
	[TimeCreated] [datetime] NULL,
	[TimeModified] [datetime] NULL,
	[EditSequence] [varchar](36) NULL,
	[Name] [varchar](41) NULL,
	[IsActive] [bit] NULL,
	[ClassRef_ListID] [varchar](36) NULL,
	[ClassRef_FullName] [varchar](159) NULL,
	[IsTaxAgency] [bit] NULL,
	[CompanyName] [varchar](41) NULL,
	[Salutation] [varchar](15) NULL,
	[FirstName] [varchar](25) NULL,
	[MiddleName] [varchar](5) NULL,
	[LastName] [varchar](25) NULL,
	[JobTitle] [varchar](41) NULL,
	[VendorAddress_Addr1] [varchar](41) NULL,
	[VendorAddress_Addr2] [varchar](41) NULL,
	[VendorAddress_Addr3] [varchar](41) NULL,
	[VendorAddress_Addr4] [varchar](41) NULL,
	[VendorAddress_Addr5] [varchar](41) NULL,
	[VendorAddress_City] [varchar](31) NULL,
	[VendorAddress_State] [varchar](21) NULL,
	[VendorAddress_PostalCode] [varchar](13) NULL,
	[VendorAddress_Country] [varchar](31) NULL,
	[VendorAddress_Note] [varchar](41) NULL,
	[ShipAddress_Addr1] [varchar](41) NULL,
	[ShipAddress_Addr2] [varchar](41) NULL,
	[ShipAddress_Addr3] [varchar](41) NULL,
	[ShipAddress_Addr4] [varchar](41) NULL,
	[ShipAddress_Addr5] [varchar](41) NULL,
	[ShipAddress_City] [varchar](31) NULL,
	[ShipAddress_State] [varchar](21) NULL,
	[ShipAddress_PostalCode] [varchar](13) NULL,
	[ShipAddress_Country] [varchar](31) NULL,
	[ShipAddress_Note] [varchar](41) NULL,
	[Phone] [varchar](255) NULL,
	[Mobile] [varchar](255) NULL,
	[Pager] [varchar](255) NULL,
	[AltPhone] [varchar](255) NULL,
	[Fax] [varchar](255) NULL,
	[Email] [varchar](4095) NULL,
	[Cc] [varchar](4095) NULL,
	[Contact] [varchar](41) NULL,
	[AltContact] [varchar](41) NULL,
	[NameOnCheck] [varchar](41) NULL,
	[AccountNumber] [varchar](99) NULL,
	[Notes] [varchar](4095) NULL,
	[VendorTypeRef_ListID] [varchar](36) NULL,
	[VendorTypeRef_FullName] [varchar](159) NULL,
	[TermsRef_ListID] [varchar](36) NULL,
	[TermsRef_FullName] [varchar](31) NULL,
	[CreditLimit] [decimal](15, 2) NULL,
	[VendorTaxIdent] [varchar](15) NULL,
	[IsVendorEligibleFor1099] [bit] NULL,
	[Balance] [decimal](15, 2) NULL,
	[BillingRateRef_ListID] [varchar](36) NULL,
	[BillingRateRef_FullName] [varchar](31) NULL,
	[ExternalGUID] [varchar](255) NULL,
	[SalesTaxCodeRef_ListID] [varchar](36) NULL,
	[SalesTaxCodeRef_FullName] [varchar](3) NULL,
	[OpenBalanceDate] [datetime] NULL,
	[CurrencyRef_ListID] [varchar](36) NULL,
	[CurrencyRef_FullName] [varchar](64) NULL,
	[SalesTaxCountry] [varchar](255) NULL,
	[IsSalesTaxAgency] [bit] NULL,
	[SalesTaxReturnRef_ListID] [varchar](36) NULL,
	[SalesTaxReturnRef_FullName] [varchar](255) NULL,
	[TaxRegistrationNumber] [varchar](30) NULL,
	[ReportingPeriod] [varchar](255) NULL,
	[IsTaxTrackedOnPurchases] [bit] NULL,
	[TaxOnPurchasesAccountRef_ListID] [varchar](36) NULL,
	[TaxOnPurchasesAccountRef_FullName] [varchar](159) NULL,
	[IsTaxTrackedOnSales] [bit] NULL,
	[TaxOnSalesAccountRef_ListID] [varchar](36) NULL,
	[TaxOnSalesAccountRef_FullName] [varchar](255) NULL,
	[IsTaxOnTax] [bit] NULL,
	[CustomField1] [varchar](255) NULL,
	[CustomField2] [varchar](255) NULL,
	[CustomField3] [varchar](255) NULL,
	[CustomField4] [varchar](255) NULL,
	[CustomField5] [varchar](255) NULL,
	[CustomField6] [varchar](255) NULL,
	[CustomField7] [varchar](255) NULL,
	[CustomField8] [varchar](255) NULL,
	[CustomField9] [varchar](255) NULL,
	[CustomField10] [varchar](255) NULL,
	[CustomField11] [varchar](255) NULL,
	[CustomField12] [varchar](255) NULL,
	[CustomField13] [varchar](255) NULL,
	[CustomField14] [varchar](255) NULL,
	[CustomField15] [varchar](255) NULL,
	[UserData] [varchar](255) NULL,
	[Operation] [varchar](10) NULL,
	[LSData] [varchar](10) NULL,
 CONSTRAINT [PK_vendor] PRIMARY KEY CLUSTERED 
(
	[ListID] ASC
)WITH (PAD_INDEX = OFF, STATISTICS_NORECOMPUTE = OFF, IGNORE_DUP_KEY = OFF, ALLOW_ROW_LOCKS = ON, ALLOW_PAGE_LOCKS = ON, OPTIMIZE_FOR_SEQUENTIAL_KEY = OFF) ON [PRIMARY]
) ON [PRIMARY]
GO




CREATE TABLE [dbo].[vendorcredit](
	[TxnID] [varchar](36) NOT NULL,
	[TimeCreated] [datetime] NULL,
	[TimeModified] [datetime] NULL,
	[EditSequence] [varchar](16) NULL,
	[TxnNumber] [int] NULL,
	[VendorRef_ListID] [varchar](36) NULL,
	[VendorRef_FullName] [varchar](41) NULL,
	[APAccountRef_ListID] [varchar](36) NULL,
	[APAccountRef_FullName] [varchar](159) NULL,
	[IsTaxIncluded] [bit] NULL,
	[SalesTaxCodeRef_ListID] [varchar](36) NULL,
	[SalesTaxCodeRef_FullName] [varchar](3) NULL,
	[TxnDate] [datetime] NULL,
	[CreditAmount] [decimal](15, 2) NULL,
	[CurrencyRef_ListID] [varchar](36) NULL,
	[CurrencyRef_FullName] [varchar](64) NULL,
	[ExchangeRate] [decimal](15, 5) NULL,
	[CreditAmountInHomeCurrency] [decimal](15, 2) NULL,
	[RefNumber] [varchar](25) NULL,
	[Memo] [varchar](4095) NULL,
	[OpenAmount] [decimal](15, 2) NULL,
	[ExternalGUID] [varchar](255) NULL,
	[UserData] [varchar](255) NULL,
	[Operation] [varchar](10) NULL,
	[LSData] [varchar](10) NULL,
 CONSTRAINT [PK_vendorcredit] PRIMARY KEY CLUSTERED 
(
	[TxnID] ASC
)WITH (PAD_INDEX = OFF, STATISTICS_NORECOMPUTE = OFF, IGNORE_DUP_KEY = OFF, ALLOW_ROW_LOCKS = ON, ALLOW_PAGE_LOCKS = ON, OPTIMIZE_FOR_SEQUENTIAL_KEY = OFF) ON [PRIMARY]
) ON [PRIMARY]
GO




CREATE TABLE [dbo].[vendortype](
	[ListID] [varchar](36) NOT NULL,
	[TimeCreated] [datetime] NULL,
	[TimeModified] [datetime] NULL,
	[EditSequence] [varchar](16) NULL,
	[Name] [varchar](41) NULL,
	[FullName] [varchar](159) NULL,
	[IsActive] [bit] NULL,
	[ParentRef_ListID] [varchar](36) NULL,
	[ParentRef_FullName] [varchar](159) NULL,
	[Sublevel] [int] NULL,
	[UserData] [varchar](255) NULL,
	[Operation] [varchar](10) NULL,
	[LSData] [varchar](10) NULL,
 CONSTRAINT [PK_vendortype] PRIMARY KEY CLUSTERED 
(
	[ListID] ASC
)WITH (PAD_INDEX = OFF, STATISTICS_NORECOMPUTE = OFF, IGNORE_DUP_KEY = OFF, ALLOW_ROW_LOCKS = ON, ALLOW_PAGE_LOCKS = ON, OPTIMIZE_FOR_SEQUENTIAL_KEY = OFF) ON [PRIMARY]
) ON [PRIMARY]
GO




CREATE TABLE [dbo].[workerscompcode](
	[ListID] [varchar](36) NOT NULL,
	[TimeCreated] [datetime] NULL,
	[TimeModified] [datetime] NULL,
	[EditSequence] [varchar](16) NULL,
	[Name] [varchar](41) NULL,
	[IsActive] [bit] NULL,
	[Desc] [varchar](31) NULL,
	[CurrentRate] [decimal](15, 5) NULL,
	[CurrentEffectiveDate] [datetime] NULL,
	[NextRate] [decimal](15, 5) NULL,
	[NextEffectiveDate] [datetime] NULL,
	[UserData] [varchar](255) NULL,
	[Operation] [varchar](10) NULL,
	[LSData] [varchar](10) NULL,
 CONSTRAINT [PK_workerscompcode] PRIMARY KEY CLUSTERED 
(
	[ListID] ASC
)WITH (PAD_INDEX = OFF, STATISTICS_NORECOMPUTE = OFF, IGNORE_DUP_KEY = OFF, ALLOW_ROW_LOCKS = ON, ALLOW_PAGE_LOCKS = ON, OPTIMIZE_FOR_SEQUENTIAL_KEY = OFF) ON [PRIMARY]
) ON [PRIMARY]
GO


Powered by BetterDocs