Home » Categories » Multiple Categories

Datafile Software - File Naming Conventions

Datafile Software - File Naming Convention.

 

Each File is Prefixed with a Company ID e.g. DEM

Each Database File has an extension of .DFD

 

Examples :

 

DEM-SLA.DFD - Sales Ledger Accounts

DEM-SLT.DFD - Sales Ledger Transactions

DEM-MAT.DFD - Sales Discount Matrix

DEM-PLA.DFD - Purchase Ledger Accounts

DEM-PLT.DFD - Purchase Ledger Transactions

 

DEM-NLA.DFD - Nominal Ledger Accounts

DEM-NLT.DFD - Nominal Ledger Transactions

 

(Cashbook Module shares same files as Nominal Ledger)

 

DEM-STA.DFD - Stock Accounts

DEM-STT.DFD - Stock Transactions

DEM-LOC.DFD - Stock Locations

DEM-ASS.DFD - Stock Assemblies

DEM-COM.DFD - Stock Components

 

DEM-SOH.DFD - Sales Order Headers

DEM-SOD.DFD - Sales Order Details

 

DEM-POH.DFD - Purchase Order Headers

DEM-POD.DFD - Purchase Order Details

 

DEM-WOH.DFD - Works Order Headers

DEM-WOD.DFD - Works Order Details

 

DEM-BAT.DFD - Batch Header

DEM-BTT.DFD - Batch Transaction File

 

DEM-EMP.DFD - Employees

DEM-DEP.DFD - Department Summary

DEM-PTR.DFD - Transactions

DEM-OTR.DFD - Overtime Rates

DEM-SWT.DFD - Switches

 

DEM-JOB.DFD - Job File

DEM-JCT.DFD - Job Cost Transactions

DEM-JCD.DFD - Job Cost Codes

 

DEM-CUR.DFD - Currencies

DEM-RAT.DFD - Currency Rates

Custom Fields
  • Release ID: Standard
Attachments Attachments
There are no attachments for this article.
Related Articles RSS Feed
Landing Pages - Additional Options
Viewed 1902 times since Wed, Jun 17, 2020
Data Interchange - Import Large Text Strings
Viewed 3180 times since Fri, Oct 26, 2012
Emails in HTML Format (Outlook 2007) 2
Viewed 1365 times since Thu, Sep 4, 2014
Stock Enquiry - History / Detail Database Options
Viewed 10855 times since Mon, Nov 25, 2013
General System Options - My Reports
Viewed 503 times since Thu, Oct 17, 2024
Ledger Enquiry – Improved Scans Option
Viewed 1586 times since Wed, Jun 13, 2012
Customer / Product History Enquiry
Viewed 5518 times since Tue, Jun 12, 2012
Spooled Reports - Clear Selected Spool Files
Viewed 4721 times since Mon, Jun 11, 2012
Automatically Display Linked Files - Allow Items from Lookup Database in History/Details List - Link to BOM Detail Pick List
Viewed 3112 times since Fri, Jul 21, 2017