» Home » uncategorized » Sage Pastel Xpress/Partner, Table Names, Descriptions & Filenames

Sage Pastel Xpress/Partner, Table Names, Descriptions & Filenames

Table NameDescription Filename
AccountUserPasswords, User Settingsaccuser.dat
ActivityMasterTime & Billing Activitiesaccactiv.dat
AnalysisCodesReceipt Analysis Codesaccranal.dat
BankDetailsReceipting Bank Detailsaccbnk.dat
BICUsersBI Centre usersACCBIC.dat
BillingParametersTime & Billing Parametersaccprmts.dat
BOMHeaderBill Of Material Headeraccbomh.dat
BOMLinesBill Of Material Linesaccboml.dat
CashBookCurrencyForeign Cash Books / Currency Balancesacccbcur.dat
CostCodesCost Codesaccjcode.dat
CurrencyFileForeign Currencyaccfcurr.dat
CustomerCategoriesCustomer Categoriesaccdcat.dat
CustomerDiscountVolume Based pricesaccdisc.dat
CustomerMasterCustomer MasterAccMasD.dat
CustSuppParametersCustomer / Supplier Parametersaccprmdc.dat
DeliveryAddressesCustomer Delivery Addressaccdeliv.dat
EmployeeActivitiesTime & Billing Employee Activitiesaccempac.dat
EmployeeMasterTime & Billing Employeesaccemp.dat
EuroEuro Codeacceuro.dat
FinancialCategoriesFinancial Categoriesaccfcat.dat
FontsPrinter / Font Setupaccfont.dat
GAAPGAAPACCGAAP.DAT
HistoryHeaderHistory of Document (e.g. Inv/Crn) Headersacchisth.dat
HistoryLinesDocument Lines, Inventory Historyacchistl.dat
HistoryTaxTax Historyacchtax.dat
HistoryUserDescUser (Transaction) History Descriptionsacchistu.dat
HistoryUserSetupUser History Settingsacchistd.dat
InternetBankInternet Banking Cashbookaccbank.dat
InternetBenfInternet Banking Beneficiariesaccbenf.dat
InventoryInventory Masteraccprd.dat
InventoryCategoryInventory Categoriesaccicat.dat
InventoryGroupsInventory Groupaccgrp.dat
InventoryLinkStore Linkingaccstklk.dat
InventoryParametersInventory Parametersaccprmst.dat
JumpUserAccessJumpUserAccessACCUSERACCESS.DAT
LedgerBalancesGeneral Ledger BalancesACCMASB.DAT
LedgerMasterGeneral Ledger Masteraccmas.dat
LedgerParametersGeneral Ledger Parametersaccprmgl.dat
LedgerTransactionsGL, Customer, Supplier Transactionsacctrn.dat
LinkHeaderLink Headeracclinkh.dat
LinkLinesLink Linesacclinkl.dat
MenuAccessMenu AccessACCMACCESS.dat
MultiStoreMulti Storeaccstore.dat
MultiStoreTrnMulti Store Transactionsaccstkst.dat
NotesNotesaccnote.dat
OpenItemOpen Itemsaccoi.dat
POSAuditPoint of Sale Auditposaudit.dat
POSCashUpPoint of Sale Cashupposcash.dat
POSPaidOutsPoint of Sale Paid Outspospo.dat
POSPaymentsPoint of Sale Paymentspospaymt.dat
POSSetupPoint of Sale Setupaccprmps.dat
PreferredSupplierPreffered Supplieraccstkps.dat
ProcessOptionsProcess OptionsACCUSROPT.DAT
ReceiptTransactionsReceipt Transactionsaccrecpt.dat
ReportCategoriesReport Categoriesaccrcat.dat
ReportExportReport Exportaccrwexp.dat
ReportWriterReport Writeraccrepw.dat
SalesmanMasterSalesman Masteraccsale.dat
SerialMasterSerial Masteraccmassn.dat
SerialTransactionSerial Transactionsacctrnsn.dat
SupplierCategoriesSupplier CategoriesACCCCAT.DAT
SupplierMasterSupplier Masteraccmasc.dat
SystemParametersSystem Parametersaccprmsy.dat
TaxBoxTax Boxacctbox.dat
TaxDescriptionTax Descriptionacctdesc.dat
TaxParametersTax Parametersaccprmtx.dat
TimesheetHeadTimesheet Headeracctimeh.dat
TimesheetLinesTimesheet Linesacctimel.dat
UnpostedUnpostedaccprdq.dat
UserGroupsUser GroupsACCUSRGRP.DAT
UserStoreUser Storeaccusstr.dat

Leave a Reply

This site uses Akismet to reduce spam. Learn how your comment data is processed.