arapXML 
Home  XML Schema OMG submission Use Cases Discussion  Requirements Research About arapXML
Overview of Sage Peachtree 7 format For General Ledger Data

Peachtree 7 is the 2nd leading GL in the US.  It has several data import/export methods (Comma separated ASCII, DDE, and 3rd party attachments to the btrieve database) There are separate CDF formats matching the functionality of Peachtree.  

The Peachtree 7 GL is a classic double entry (CDEA) header/rows structure boiled down into a flatfile for the Comma delimited format.  The CSV files are very straightforward; for instance when clicked by users of Microsoft Office, they open up in Excel.  The Date and Reference elements are header elements, in the application screen (below).

Peachtree 7 has many transaction types (journal types).  The Journal Entry is not used as a container for any routine daily business such as payments or cash receipts; accordingly it has little direct bearing into the goals of ARAPXML which include transporting AR/AP entries, and GLs which store all transaction types comprehensively in the GL.

    


Example, as if the CSV file were represented in XML:

<peachtree7generalCSV>
   <Date></Date>
   <Reference></Reference>
   <DateClearinBankRec></DateClearinBankRec>
   <NumberofDistributions></NumberofDistributions>
   <GLAccount></GLAccount>
   <Description></Description>
   <Amount></Amount>
   <JobID></JobID>
   <UsedforReimbursableExpenses></UsedforReimbursableExpenses>
   <TransactionPeriod></TransactionPeriod>
   <TransactionNumber></TransactionNumber>
</peachtree7generalCSV>

Chart of Accounts:
 

 

Peachtree7 data import/export files (generally representing journal types)


CHART.CSV
COSTCODE.CSV
CUSTOMER.CSV
EXPENSE.CSV
GENERAL.CSV
ITEM.CSV
JOB.CSV
PAYMENTS.CSV
PAYROLL.CSV
PHASE.CSV
PO.CSV
PURCHASE.CSV
RECEIPTS.CSV
SALES.CSV
TIME.CSV
VENDOR.CSV

Peachtree7 General Journal screen