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
Application Utilities Panel - Allow Scans Enquiry
Viewed 2644 times since Fri, Jun 8, 2012
User Help Notes
Viewed 2315 times since Fri, Jun 8, 2012
Microsoft Office Links 2018
Viewed 2235 times since Thu, Jun 18, 2020
Help Bubble Display Size
Viewed 2115 times since Fri, Jun 8, 2012
User-Definable Ledger Enquiry Applications
Viewed 22064 times since Tue, Jun 12, 2012
Image Display on Maintenance Screens
Viewed 3057 times since Wed, Jun 13, 2012
Pre-Defined Criteria - $USER for Current User Id
Viewed 1378 times since Thu, Jun 18, 2020
Desktop Database Tools - Additional F4-Select Options
Viewed 2959 times since Fri, Jun 8, 2012
Ledger Enquiry – Improved Scans Option
Viewed 1295 times since Wed, Jun 13, 2012
Copy to Clipboard - Use <TAB> Delimiter
Viewed 4458 times since Fri, Oct 26, 2012