LetSync Desktop database schema. Alphabetical listed
These tables can be used for listing reports, or to tie to other activity tables.
- Account
- AppliedToTxnRet
- ARRefundCreditCard
- Bill
- BillingRate
- AdditionalContactRet
- BillPaymentCheck
- BillPaymentCreditCard
- BuildAssembly
- CashBackInfoRet
- Charge
- Check
- Class
- Company
- ComponentItemLineRet
- ContactsRet
- CreditCardCharge
- CreditCardCredit
- CreditMemo
- CreditMemoLineGroupRet
- CreditMemoLineRet
- Currency
- Customer
- CustomerMsg
- CustomerType
- DataExtDef
- DateDrivenTerms
- DefaultUnitRet
- Deposit
- DepositLineRet
- EarningsRet
- Employee
- Estimate
- EstimateLineGroupRet
- EstimateLineRet
- ExpenseLineRet
- InventoryAdjustment
- InventoryAdjustmentLineRet
- InventorySite
- Invoice
- InvoiceLineGroupRet
- InvoiceLineRet
- AdditionalNotesRet
- BillingRatePerItemRet
- ItemDiscount
- ItemFixedAsset
- ItemGroup
- ItemGroupLineRet
- ItemInventory
- ItemInventoryAssembly
- ItemInventoryAssemblyLineRet
- ItemLineRet
- ItemNonInventory
- ItemOtherCharge
- ItemPayment
- ItemReceipt
- ItemSalesTax
- ItemSalesTaxGroup
- ItemSalesTaxRefRet
- ItemService
- ItemSites
- ItemSubtotal
- JobType
- JournalCreditLineRet
- JournalDebitLineRet
- LinkedTxnRet
- OtherName
- PaymentMethod
- PayrollItemNonWage
- PayrollItemWage
- PrefillAccountRet
- PriceLevel
- PriceLevelPerItemRet
- PurchaseOrder
- PurchaseOrderLineGroupRet
- PurchaseOrderLineRet
- ReceivePayment
- ReceivePaymentToDeposit
- RelatedUnitRet
- Report
- SalesAndPurchaseRet
- SalesOrPurchaseRet
- SalesOrder
- SalesOrderLineGroupRet
- SalesOrderLineRet
- SalesReceipt
- SalesReceiptLineGroupRet
- SalesReceiptLineRet
- SalesRep
- SalesTaxCode
- SalesTaxPaymentCheck
- SalesTaxPaymentCheckLineRet
- ShipMethod
- ShipToAddressRet
- StandardTerms
- Template
- Terms
- TimeTracking
- ToDo
- Transaction
- Transfer
- TransferInventory
- TransferInventoryLineRet
- UnitOfMeasureSet
- Vehicle
- VehicleMileage
- Vendor
- VendorCredit
- VendorType
- JournalEntry
- LetSync Desktop operational tables
- ListMerge
- Schema Differences
- Pay a Bill with CreditCardCharge/BillPaymentCreditCard
- Pay a Bill with Check / BillPaymentCheck
- ExternalGUID