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.
- Make the table collation to utf8_general_ci. This will support special characters like quotation marks.
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