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
Select Enquiry
Viewed 2611 times since Tue, Jun 12, 2012
Landing Pages - Sorting and Grouping on Table Items
Viewed 332 times since Thu, Oct 17, 2024
Compress Address Lines and Post Code
Viewed 3507 times since Wed, Jun 13, 2012
Database Table - Date Item Types - "F" Type Forecast Date Field
Viewed 3292 times since Fri, Mar 6, 2015
Landing Pages - Company / Key-Item Selection
Viewed 686 times since Tue, Oct 15, 2024
Landing Pages - Field Chooser Display Sequence
Viewed 777 times since Wed, Oct 23, 2024
General System Options - Email Address Format Validation
Viewed 851 times since Thu, Oct 17, 2024
Ledger Enquiry Hyperlinks on Application Report Output to Excel
Viewed 11140 times since Mon, Jun 11, 2012
Ledger Enquiry - Alternate Link Item for History Databases
Viewed 731 times since Tue, Oct 15, 2024
Ledger Enquiry - Prevent Auto Close of Associated File Folder on Enquiry
Viewed 658 times since Wed, Oct 23, 2024