Moving this post to the Sage 50 US (formerly Sage Peachtree) Support Group.

Thanks,

Derek

All transactions are stored in the JrnHdr and JrnlRow files. In the JrnlHdr file, JrnlKey_Journal holds a number identifying the journal type for each transaction. This list is copied from the help:

0 = General Journal
1 = Cash Receipts Journal
2 = Cash Disbursements (Payments) Journal
3 = Sales Journal
4 = Purchase Journal
5 = Payroll Journal
6 =Cost of Goods Sold Journal
7 = Inventory Adjustment Journal
8 = Assembly Adjustments (Build/Unbuild) Journal
9 = TempBelowZeroInvAdj (These are system-generated transactions within Sage 50's inventory costing engine. The Sage 50 user will never see this journal. Also, these transactions do not contain header records.)
10 = Purchase Orders Journal
11 = Sales Orders Journal
12 = Quotes Journal

To find explanations of each data file, go to the Help in Sage 50 and look in the index for "data (.DAT) files"

Thanks StephenC, And also what is the difference between  " 3 = Sales Journal & 11 = Sales Orders Journal " ?

A Sale Journal comes from an invoice.  It is also hits the General Ledger.   The Sales Order is basically a customers wish to order goods.  It does not go to General Ledger until it is converted to an invoice at which time it becomes a Sales Journal. 

Thanks