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 - Include Filtered Records in Count
Viewed 159 times since Tue, Oct 15, 2024
Landing Pages - Edit Data Items from Landing Page
Viewed 184 times since Tue, Oct 15, 2024
Ledger Enquiry - Additional CRM Categories
Viewed 4789 times since Fri, Jun 8, 2012
Bar Code Printing
Viewed 1077 times since Mon, Jan 6, 2020
Ledger Enquiry – Update Sales / Purchase Accounts
Viewed 1748 times since Wed, Jun 13, 2012
Microsoft Office Links 2018
Viewed 1417 times since Thu, Jun 18, 2020
General System Options - D02.DFD – Include Sales and Purchase Order Authorisation Limits
Viewed 72 times since Thu, Oct 17, 2024
Additional Display Options for Nominal / Cashbook Enquiry
Viewed 2241 times since Fri, Oct 26, 2012
ASCII Import with Line Feed Only Record Delimiter
Viewed 4327 times since Wed, Jun 13, 2012
Ledger Enquiries – Application Web Links
Viewed 690 times since Wed, Jun 17, 2020