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
Document Design Manager - Print Preview and Test Print
Viewed 3401 times since Wed, Jun 13, 2012
Application Pick Lists - Apply Colour Highlighting Rules
Viewed 2722 times since Wed, Sep 21, 2016
Document Design Manager - Save and Exit
Viewed 4528 times since Wed, Jun 13, 2012
Ledger Enquiry - Additional CRM Categories
Viewed 5665 times since Fri, Jun 8, 2012
Large File Sizes
Viewed 3038 times since Mon, Jun 11, 2012
Application Reports - Save PDF Copy to Folder
Viewed 2408 times since Mon, Nov 25, 2013
Connection to SQL Server via ODBC and SQL Log Housekeeping
Viewed 6342 times since Fri, Jul 21, 2017
Order Enquiry - Allow Label Print from Order Details
Viewed 2408 times since Mon, Jun 11, 2012
General System Options - Application Pick Lists – Default Action on <Enter>
Viewed 282 times since Thu, Oct 17, 2024