Database Tables

The full list of tables available in the Sage 50 US database is listed below. The Export Query task can be used to obtain data from any of these tables.

Address
AdviceMessageHistory
AdviceUserData
AIDocTransaction
AIDocVendorSync
Alarms
Alerts
APIApplicationAccess
ArchivedBudgetSumm
ArchivedChartSumm
ArchivedPeriodInfo
Attachment
AttachmentBundle
Audit_Trail
AutoFillLocation
BankAcntIDMap
BankRecords
BOMHist
BOMItems
Budget Details
Budgets
CashFlow
CashFlowAccount
CashFlowTransaction
ChangeOrder
ChangeOrderDetail
Chart
Company
CompanySession
Contacts
CostCode
Customers
DefaultPayrollField
EarningSummary
EarnSummPRFld
EarnSummWage
Employee
EmployeePayInfo
EmployeePayrollField
EmployeeReview
EventLogs
FinancialReport
General_AP
General_AR
General_GL
General_Inv
General_Jobs
General_PR
General_W2
GRPDATA
InventoryChains
InventoryCosts
JobEst
Jobs
JrnlHdr
JrnlRow
JrnlSNum
LineItem
NotificationAddMsg
NotificationCdVal
NotificationMsg
NotificationRecip
NotificationRules
Notifications
OnlineAccount
OnlineTransaction
PaymentMethod
PayTypes
PEPUsage
Permission
Phase
PRSpecialFields
Quantity Discount
Raise_History
ReceiptTags
Reconsolidation
Recurring Trxns
ReportDefaultStyle
ReportFilter
ReportStyle
Roles
SageNetworkHash
SageNetworkStatus
SageOneAcntIDMap
SageOneTaxIDMap
SagePDSIDMap
StatusCode
StatusHistory
StatusNote
StoredTransHeaders
StoredTransRows
SystemPreference
Tax_Authority
Tax_Code
TaxTable
Template
Ticket
UnitMeasure
UserPreference
UserRoles
Vendor Insurance
Vendors
Worktkt