Skip to content

Donneray Consulting

The Computer Guy

Menu
  • Home
  • Here Be Notes
  • Pay Here
Menu

Table Structure for Peach Tree

Posted on August 14, 2012November 25, 2023 by Don Bremer

Although I would love to make a picture of the database tables, here are the tables anyway:

ADDRESS.DAT Customer ShipTo and Vendor RemitTo address data.  Added at V13.
AFLOCAT.DAT  Lookup data for city, state, zipcode and country.  Added at V13 to support pulldown lists.
ALARM.DAT Alarm events.
ALERT.DAT Alert events.
AUDITTR.DAT Audit trail information.
BANKREC.DAT Temporary file used for reconciliation.
BOM*.DAT Bill of material data for assemblies.  Added at V11.5. (Partly available with DDE.)
CHART.DAT Chart of Accounts data. (Available with Export and DDE.)
COMPANY.DAT Company specific data.  (Available with DDE.)
ConnCO.DAT Used to control multiple access.  Empty when PT not running.  Has record with Peachtree serial number when PT running.  Probably added at V9.
COST.DAT Job Cost data.  (Not available with Peachtree First Accounting.)
CUSTOMER.DAT Customer data. (Available with Export and DDE.)
EMPLOYEE.DAT Employee data. (Available with Export and DDE.)
EVENTLOG.DAT Log of certain transactions.
FORECAST.DAT Created when you use forecasting.
FOREDETL.DAT Created when you use forecasting.
FA*.DAT Fixed Asset data. (FALIMIT.DAT
GENERAL.DAT General and default data.  (Not available with Export.  Only  periods available with DDE.)
GLCOAT.DAT Text file listing the chart of accounts.  Added at V11.
GRPDATA.DAT Info about report groups.
INVCHAIN.DAT Supporting detail for line items.
INVCOMP.DAT Inventory assembly component data.  Possibly not used starting at V11.
INVCOST.DAT Details about inventory cost.
INVTAG.DAT Auxiliary Inventory data.
JOBEST.DAT Auxiliary job data.
JOBTAG.DAT V7 only: Auxiliary job data.
JOURNAL.DAT V7 only: All journal entries are stored in this one file. (Available with Export/DDE.)
JRNLHDR.DAT  V8 and later: Header information for all journals. (Available with Export and DDE)
JRNLROW.DAT  V8 and later: Detail information for all journals. (Available with Export and DDE)
JRNLSNO.DAT  V12 and later: Item serial number data.
LINEITEM.DAT Inventory item data. (Available with Export and DDE.)
OLACCT.DAT V13 and later: Purpose unknown.
OLTRANS.DAT V13 and later: Purpose unknown.
PERMISS.DAT User permission data.
PHASE.DAT Job phase data (Not available with Peachtree First Accounting)
PROJECT.DAT Job data.  (Available with Export and DDE.)
QTYDISC.DAT  V11.5 and later: Contains quantity discount data.
RAISEHST.DAT  V11 and later: Raise history data.  Not used in all flavors.
RECPTTAG.DAT Receipt tag information. Obsolete but may exist in older data.
REPORT.DAT Temporary report data.
RPTDATA.DAT Temporary report data.
RptFiltS.DAT V11 and later: Report Filter temporary data.
RstyDef.DAT V8 and later: Contains report styles for report groups.
Rstyle.DAT V8 and later: Contains constants for each of four styles.
SORTJOB.DAT  V7 only: Report speedup data.
STORETRX.DAT Obsolete at V13: Memorized Transaction data.
STXHDR.DAT  V13 and later: Memorized Transaction header data.
STXROW.DAT  V13 and later: Memorized Transaction detail data.
TAXAUTH.DAT Tax Authority data.
TAXCODE.DAT Sales tax data.
TAXTABLE.DAT Tax Table data.  (Available with DDE.)
TEMPLATE.DAT Stores data for template button that appears on various journal forms.
TICKET.DAT Ticket data. (Available with Export. Not available in First Accounting.)
UNITMEAS.DAT  V11.5 and later: Unit of measure data.
UPS*.DAT V12 and later: UPS Shipping information.
UserPref.DAT V8 and later: PT Today settings.
VENDINS.DAT V13 and later: Vendor insurance data.
VENDOR.DAT Vendor data. (Available with Export and DDE.)
WORKTKT.DAT V11.5 and later: Work Ticket data.

Recent Posts

  • Download
  • Handout
  • Creating a new folder with YYYY-MM-DD
  • Rules of Programming
  • About Faxes

Recent Comments

No comments to show.

Archives

  • January 2022
  • April 2021
  • October 2015
  • October 2014
  • December 2012
  • October 2012
  • September 2012
  • August 2012

Categories

  • Uncategorized
©2025 Donneray Consulting | Built using WordPress and Responsive Blogily theme by Superb