Fields

lsPaymentMethods.PaymentMethod

lsPaymentMethods.ExternalAccess

lsPaymentMethods.Inactive

lsPaymentMethods.EditStamp

lsPaymentMethods.CONSTRAINT

lsItemFamilies.FamilyID

lsItemFamilies.Description

lsItemFamilies.PictureURL

lsItemFamilies.EditStamp

lsItemFamilies.CONSTRAINT

lsTerms.Term

lsTerms.Standard

lsTerms.DayTillNetDue

lsTerms.Discount

lsTerms.DaysTillDiscountExpires

lsTerms.DayOfMonthNetDue

lsTerms.DueNextMonthIfWithinDays

lsTerms.Discount1

lsTerms.DayDiscountExpires

lsTerms.Inactive

lsTerms.upsize_ts

lsTerms.CONSTRAINT

lsItemCategories.CategoryID

lsItemCategories.Description

lsItemCategories.PictureURL

lsItemCategories.familyID

lsItemCategories.EditStamp

lsItemCategories.CONSTRAINT

lsShippingMethods.ShippingMethod

lsShippingMethods.AccountNo

lsShippingMethods.Inactive

lsShippingMethods.EditStamp

lsShippingMethods.CONSTRAINT

lsClasses.ClassName

lsClasses.Subclass

lsClasses.ClassName1

lsClasses.Inactive

lsClasses.EditStamp

lsClasses.CONSTRAINT

lsCustomerTypes.CustomerType

lsCustomerTypes.Inactive

lsCustomerTypes.EditStamp

lsCustomerTypes.CONSTRAINT

Company.CompanyID

Company.CompanyName

Company.LegalName

Company.Address1

Company.Address2

Company.City

Company.State

Company.Zip

Company.Country

Company.Phone

Company.Fax

Company.email

Company.website

Company.FirstFiscalMonth

Company.PictureURL

Company.ConfirmDeletion

Company.UseAN

Company.DefaultCT

Company.DefaultIT

Company.DefaultSM

Company.AgingReportUse

Company.TaxFreight

Company.DefaultSalesTax

Company.ChargeHandling

Company.HandlingAsPercent

Company.HandlingAmount

Company.CurrencySymbol

Company.EditStamp

Company.CONSTRAINT

lsTaxGroups.TaxGroupID

lsTaxGroups.TaxGroupName

lsTaxGroups.TotalPercent

lsTaxGroups.Inactive

lsTaxGroups.IsDefault

lsTaxGroups.EditStamp

lsTaxGroups.CONSTRAINT

DocNumbers.CompanyID

DocNumbers.CheckNo

DocNumbers.Vouchers

DocNumbers.Orders

DocNumbers.BillPmt

DocNumbers.Invoices

DocNumbers.CustCredits

DocNumbers.CustPmt

DocNumbers.Adjustment

DocNumbers.TimeTracking

DocNumbers.Transfers

DocNumbers.EditStamp

DocNumbers.CONSTRAINT

lsVendorTypes.VendorType

lsVendorTypes.Inactive

lsVendorTypes.EditStamp

lsVendorTypes.CONSTRAINT

GeneralJournalEntry.EntryNo

GeneralJournalEntry.Date

GeneralJournalEntry.TrType

GeneralJournalEntry.TrID

GeneralJournalEntry.SystemGenerated

GeneralJournalEntry.PostedYN

GeneralJournalEntry.EditStamp

GeneralJournalEntry.CONSTRAINT

lsAccountTypes.Description

lsAccountTypes.EditStamp

lsAccountTypes.CONSTRAINT

OpBalWork.AccountID

OpBalWork.AccBalType

OpBalWork.OpeningBalance

OpBalWork.EditStamp

lsCustomerMessages.CustomerMessage

lsCustomerMessages.Inactive

lsCustomerMessages.EditStamp

lsCustomerMessages.CONSTRAINT

lsMemorized.Name

lsMemorized.TrType

lsMemorized.TransID

lsMemorized.EditStamp

lsMemorized.CONSTRAINT

Months.MonthID

Months.Name

Months.EditStamp

Months.CONSTRAINT

lsTaxGroupDetail.GrpID

lsTaxGroupDetail.TaxID

lsTaxGroupDetail.Description

lsTaxGroupDetail.Account

lsTaxGroupDetail.TaxPercent

lsTaxGroupDetail.EditStamp

lsTaxGroupDetail.CONSTRAINT

csCustomerPaymentDetails.Reference

csCustomerPaymentDetails.FID

csCustomerPaymentDetails.ToPay

csCustomerPaymentDetails.textboxAmount

csCustomerPaymentDetails.EditStamp

csCustomerPaymentDetails.CONSTRAINT

vpBillPaymentDetails.Reference

vpBillPaymentDetails.FID

vpBillPaymentDetails.textboxAmount

vpBillPaymentDetails.EditStamp

vpBillPaymentDetails.CONSTRAINT

GeneralJournalDetail.EntryNo

GeneralJournalDetail.No

GeneralJournalDetail.Account

GeneralJournalDetail.Debit

GeneralJournalDetail.Credit

GeneralJournalDetail.Memo

GeneralJournalDetail.EditStamp

GeneralJournalDetail.CONSTRAINT

Commissions.ID

Commissions.EmpName

Commissions.Date

Commissions.Amount

Commissions.PaidYN

Commissions.EditStamp

Commissions.CONSTRAINT

GLWorkDetail.GLID

GLWorkDetail.No

GLWorkDetail.Credit

GLWorkDetail.Debit

GLWorkDetail.Memo

GLWorkDetail.Account

GLWorkDetail.EditStamp

GLWorkDetail.CONSTRAINT

csOrderTracking.OrderNo

csOrderTracking.InvoiceNo

csOrderTracking.EditStamp

Users.LoginID

Users.Username

Users.Password

Users.GroupLevel

Users.EditStamp

Users.CONSTRAINT

lsCustomersShipTo.CustomerName

lsCustomersShipTo.ShipingAddressID

lsCustomersShipTo.ShippingAddress

lsCustomersShipTo.City

lsCustomersShipTo.State

lsCustomersShipTo.Zip

lsCustomersShipTo.Country

lsCustomersShipTo.EditStamp

lsCustomersShipTo.CONSTRAINT

bCheckDetails.CheckID

bCheckDetails.InvDate

bCheckDetails.InvRef

bCheckDetails.InvOrigAmount

bCheckDetails.Amount

bCheckDetails.BillID

bCheckDetails.EditStamp

bCheckDetails.CONSTRAINT

vpBills.Date

vpBills.Vendor

vpBills.Reference

vpBills.Type

vpBills.Term

vpBills.DueDate

vpBills.VendorInvoice

vpBills.Freight

vpBills.Discount

vpBills.OtherCharges

vpBills.Amount

vpBills.Memo

vpBills.PayAmount

vpBills.DueAmount

vpBills.PORef

vpBills.PmtID

vpBills.PayYN

vpBills.CheckID

vpBills.PostedYN

vpBills.EditStamp

vpBills.CONSTRAINT

vpPurchaseOrders.PORef

vpPurchaseOrders.Date

vpPurchaseOrders.DueDate

vpPurchaseOrders.Term

vpPurchaseOrders.Vendor

vpPurchaseOrders.Class

vpPurchaseOrders.Memo

vpPurchaseOrders.BillTo

vpPurchaseOrders.ShipTo

vpPurchaseOrders.ReceiveBy

vpPurchaseOrders.VendorMessage

vpPurchaseOrders.ShipVia

vpPurchaseOrders.TrackingNumber

vpPurchaseOrders.ShipToD

vpPurchaseOrders.VendorInvoice

vpPurchaseOrders.Freight

vpPurchaseOrders.Discount

vpPurchaseOrders.OtherCharges

vpPurchaseOrders.ShippingCharge

vpPurchaseOrders.Total

vpPurchaseOrders.ReceivedYN

vpPurchaseOrders.EditStamp

vpPurchaseOrders.CONSTRAINT

vpBillPayments.Reference

vpBillPayments.Account

vpBillPayments.ToBePrinted

vpBillPayments.Vendor

vpBillPayments.Date

vpBillPayments.CheckNo

vpBillPayments.Amount

vpBillPayments.Memo

vpBillPayments.ClearedYN

vpBillPayments.LastCheckNo

vpBillPayments.EditStamp

vpBillPayments.CONSTRAINT

csOrders.Date

csOrders.Customer

csOrders.ShipToID

csOrders.Class

csOrders.Memo

csOrders.Term

csOrders.OrderNo

csOrders.DueDate

csOrders.ShipVia

csOrders.ShipDate

csOrders.POID

csOrders.CustomerMessage

csOrders.Discount

csOrders.Freight

csOrders.SalesTax

csOrders.Tax

csOrders.TaxTotal

csOrders.Total

csOrders.TotalWeight

csOrders.ShippingCharge

csOrders.Handling

csOrders.ApplyYN

csOrders.Picked

csOrders.Billed

csOrders.Printed

csOrders.Shipped

csOrders.Backordered

csOrders.Invoiced

csOrders.TrackingNumber

csOrders.CCType

csOrders.CCName

csOrders.CCNumber

csOrders.CCExpDate

csOrders.ApprovalNumber

csOrders.PostedYN

csOrders.EditStamp

csOrders.CONSTRAINT

csInvoices.Date

csInvoices.Customer

csInvoices.ShipToID

csInvoices.Class

csInvoices.Memo

csInvoices.Term

csInvoices.InvoiceNo

csInvoices.DueDate

csInvoices.ShipVia

csInvoices.ShipDate

csInvoices.POID

csInvoices.CustomerMessage

csInvoices.TrackingNumber

csInvoices.Handling

csInvoices.Freight

csInvoices.Discount

csInvoices.SalesTax

csInvoices.Tax

csInvoices.TaxTotal

csInvoices.Total

csInvoices.TotalWeight

csInvoices.ShippingCharge

csInvoices.ApplyYN

csInvoices.PaidYN

csInvoices.PayAmount

csInvoices.PostedYN

csInvoices.EditStamp

csInvoices.CONSTRAINT

lsCustomers.Login

lsCustomers.Password

lsCustomers.CustomerName

lsCustomers.Company

lsCustomers.MrMs

lsCustomers.FirstName

lsCustomers.MiddleInitial

lsCustomers.LastName

lsCustomers.BillingAddress1

lsCustomers.BillingAddress2

lsCustomers.City

lsCustomers.State

lsCustomers.Zip

lsCustomers.Country

lsCustomers.Contact

lsCustomers.Phone

lsCustomers.Email

lsCustomers.Fax

lsCustomers.AltPhone

lsCustomers.AltContact

lsCustomers.Account

lsCustomers.CustomerType

lsCustomers.Term

lsCustomers.Rep

lsCustomers.CreditLimit

lsCustomers.Taxable

lsCustomers.TaxItem

lsCustomers.ResaleNumber

lsCustomers.OpeningBalance

lsCustomers.OpeningBalanceDate

lsCustomers.Inactive

lsCustomers.PasswordCA

lsCustomers.Balance

lsCustomers.ExistingCredit

lsCustomers.EditStamp

lsCustomers.CONSTRAINT

csCustomerCredits.Customer

csCustomerCredits.Class

csCustomerCredits.Memo

csCustomerCredits.BillTo

csCustomerCredits.Date

csCustomerCredits.CreditNumber

csCustomerCredits.POID

csCustomerCredits.CustomerMessage

csCustomerCredits.Discount

csCustomerCredits.Handling

csCustomerCredits.Freight

csCustomerCredits.SalesTax

csCustomerCredits.Tax

csCustomerCredits.TaxTotal

csCustomerCredits.Total

csCustomerCredits.PostedYN

csCustomerCredits.EditStamp

csCustomerCredits.CONSTRAINT

csCustomerPayments.Reference

csCustomerPayments.Customer

csCustomerPayments.PaymentAmount

csCustomerPayments.Date

csCustomerPayments.PaymentMethod

csCustomerPayments.Memo

csCustomerPayments.CheckNo

csCustomerPayments.CreditCardNo

csCustomerPayments.CardExpires

csCustomerPayments.NameOnCard

csCustomerPayments.CardZipCode

csCustomerPayments.CardApproved

csCustomerPayments.UndepFunds

csCustomerPayments.DepositTo

csCustomerPayments.Account

csCustomerPayments.ApplyExistingCredits

csCustomerPayments.Apply

csCustomerPayments.TotalToApply

csCustomerPayments.TotalApplied

csCustomerPayments.UnappliedAmount

csCustomerPayments.Deposit

csCustomerPayments.PayAmount

csCustomerPayments.ReceivedYN

csCustomerPayments.ClearedYN

csCustomerPayments.PostedYN

csCustomerPayments.EditStamp

csCustomerPayments.CONSTRAINT

lsProjects.Customer

lsProjects.ProjectName

lsProjects.Description

lsProjects.ProjectManager

lsProjects.StartDate

lsProjects.EndDate

lsProjects.Inactive

lsProjects.EditStamp

lsProjects.CONSTRAINT

TimeTracking.Reference

TimeTracking.Employee

TimeTracking.Date

TimeTracking.Customer

TimeTracking.ServiceItem

TimeTracking.Class

TimeTracking.Duration

TimeTracking.Memo

TimeTracking.EditStamp

TimeTracking.CONSTRAINT

lsAccounts.AccountNumber

lsAccounts.AccountName

lsAccounts.AccountType

lsAccounts.Subaccount

lsAccounts.AccountName1

lsAccounts.Description

lsAccounts.OpeningBalance

lsAccounts.Date

lsAccounts.Inactive

lsAccounts.Balance

lsAccounts.BalanceType

lsAccounts.Modified

lsAccounts.OpBalID

lsAccounts.IsDefault

lsAccounts.EditStamp

lsAccounts.CONSTRAINT

EmpChecks.CheckID

EmpChecks.CheckNo

EmpChecks.Account

EmpChecks.Payee

EmpChecks.Amount

EmpChecks.Address

EmpChecks.Date

EmpChecks.EditStamp

EmpChecks.CONSTRAINT

InventoryAdjustments.Date

InventoryAdjustments.RefNo

InventoryAdjustments.AdjustmentAccount

InventoryAdjustments.Customer

InventoryAdjustments.Memo

InventoryAdjustments.TotalValue

InventoryAdjustments.PostedYN

InventoryAdjustments.EditStamp

InventoryAdjustments.CONSTRAINT

lsTaxes.TaxID

lsTaxes.Description

lsTaxes.TaxPercent

lsTaxes.Account

lsTaxes.Inactive

lsTaxes.EditStamp

lsTaxes.CONSTRAINT

lsVendors.VendorName

lsVendors.Company

lsVendors.MrMs

lsVendors.FirstName

lsVendors.MiddleInitial

lsVendors.LastName

lsVendors.Contact

lsVendors.Address1

lsVendors.Address2

lsVendors.City

lsVendors.State

lsVendors.Zip

lsVendors.Country

lsVendors.Phone

lsVendors.Fax

lsVendors.AltPhone

lsVendors.AltContact

lsVendors.PrintOnCheckAs

lsVendors.AccountNumber

lsVendors.DefaultExpenseAccount

lsVendors.VendorType

lsVendors.Term

lsVendors.PMID

lsVendors.CreditLimit

lsVendors.TaxID

lsVendors.Eligible

lsVendors.Email

lsVendors.OpeningBalance

lsVendors.OpeningBalanceDate

lsVendors.Balance

lsVendors.Inactive

lsVendors.EditStamp

lsVendors.CONSTRAINT

lsEmployees.EmployeeName

lsEmployees.SalesmanID

lsEmployees.Initials

lsEmployees.TaxID

lsEmployees.MrMs

lsEmployees.FirstName

lsEmployees.MiddleInitial

lsEmployees.LastName

lsEmployees.Address1

lsEmployees.Address2

lsEmployees.City

lsEmployees.State

lsEmployees.Zip

lsEmployees.Country

lsEmployees.Phone

lsEmployees.email

lsEmployees.Account

lsEmployees.Inactive

lsEmployees.PasswordTTA

lsEmployees.YN1099

lsEmployees.CommissionYN

lsEmployees.CommissionRate

lsEmployees.Commission

lsEmployees.Refferal

lsEmployees.EditStamp

lsEmployees.CONSTRAINT

lsItems.ItemName

lsItems.ItemName1

lsItems.ItemType

lsItems.Subitem

lsItems.CategoryID

lsItems.PurchaseDescription

lsItems.Cost

lsItems.COGSAccount

lsItems.PrefferedVendor

lsItems.SalesDescription

lsItems.IncomeAccount

lsItems.SalesPrice

lsItems.Taxable

lsItems.AssetAccount

lsItems.QuantityOnHand

lsItems.TotalValue

lsItems.ReorderPoint

lsItems.ItemWeight

lsItems.PictureURL

lsItems.Inactive

lsItems.EditStamp

lsItems.CONSTRAINT

bTransferFunds.Reference

bTransferFunds.FromAccount

bTransferFunds.ToAccount

bTransferFunds.Date

bTransferFunds.Amount

bTransferFunds.Memo

bTransferFunds.ClearedYN

bTransferFunds.PostedYN

bTransferFunds.EditStamp

bTransferFunds.CONSTRAINT

vpBillExpenses.BillID

vpBillExpenses.Reference

vpBillExpenses.No

vpBillExpenses.Account

vpBillExpenses.Amount

vpBillExpenses.Memo

vpBillExpenses.Project

vpBillExpenses.EditStamp

vpBillExpenses.CONSTRAINT

bChecks.CheckID

bChecks.CheckNo

bChecks.Account

bChecks.Payee

bChecks.Address

bChecks.Date

bChecks.Amount

bChecks.Memo

bChecks.GroupID

bChecks.ClearedYN

bChecks.VoidedYN

bChecks.EditStamp

bChecks.CONSTRAINT

InventoryAdjustmentDetail.RefNo

InventoryAdjustmentDetail.Item

InventoryAdjustmentDetail.Description

InventoryAdjustmentDetail.CurrentQty

InventoryAdjustmentDetail.CurrentValue

InventoryAdjustmentDetail.NewQty

InventoryAdjustmentDetail.NewValue

InventoryAdjustmentDetail.QtyDifference

InventoryAdjustmentDetail.ValueDifference

InventoryAdjustmentDetail.EditStamp

InventoryAdjustmentDetail.CONSTRAINT

vpBillItems.BillID

vpBillItems.No

vpBillItems.Item

vpBillItems.Description

vpBillItems.Quantity

vpBillItems.Rate

vpBillItems.Amount

vpBillItems.Project

vpBillItems.Billable

vpBillItems.EditStamp

vpBillItems.CONSTRAINT

csInvoiceItems.InvoiceNo

csInvoiceItems.No

csInvoiceItems.Item

csInvoiceItems.Description

csInvoiceItems.Quantity

csInvoiceItems.Rate

csInvoiceItems.Amount

csInvoiceItems.ItemWeight

csInvoiceItems.Shipped

csInvoiceItems.ShippedDate

csInvoiceItems.TrackingNumber

csInvoiceItems.EditStamp

csInvoiceItems.CONSTRAINT

vpPurchaseOrderDetails.ID

vpPurchaseOrderDetails.PORef

vpPurchaseOrderDetails.No

vpPurchaseOrderDetails.Item

vpPurchaseOrderDetails.Quantity

vpPurchaseOrderDetails.ReceivedQty

vpPurchaseOrderDetails.Rate

vpPurchaseOrderDetails.Amount

vpPurchaseOrderDetails.Description

vpPurchaseOrderDetails.Project

vpPurchaseOrderDetails.EditStamp

vpPurchaseOrderDetails.CONSTRAINT

csOrderItems.OrderNo

csOrderItems.No

csOrderItems.Item

csOrderItems.Description

csOrderItems.Quantity

csOrderItems.Ship

csOrderItems.Rate

csOrderItems.Amount

csOrderItems.ItemWeight

csOrderItems.ShipDate

csOrderItems.EditStamp

csOrderItems.CONSTRAINT

csCustomerCreditItems.CustomerCreditNo

csCustomerCreditItems.No

csCustomerCreditItems.Item

csCustomerCreditItems.Description

csCustomerCreditItems.Quantity

csCustomerCreditItems.Rate

csCustomerCreditItems.Amount

csCustomerCreditItems.Tax

csCustomerCreditItems.EditStamp

csCustomerCreditItems.CONSTRAINT