IntelliDealer Main Files and Descriptions

All information displayed by IntelliDealer is stored within files specific to each module of the system. This note outlines the main files used by IntelliDealer.

Customer and Accounts Receivable

Information for the Customer and Accounts Receivable modules of IntelliDealer is stored in the following files:

Description File Name Comments
Customer Master CMASTR  
Customer A/R Information CMASTRE Summary A/R Aging and A/R Totals by G/L
Customer Fiscal Sales History CMFIS  
Customer Call Information CMASCP  
A/R Agency Information File CMASAA  
Ship To Addresses CMASSH  
Customer contacts information CMASCON  
Memos * MEMOS  
Comments PARTCOMM Parts comments AND customer comments. Customer comments have a $C under the Br. column to distinguish them from part comments
Accounts Receivable File ARFILE  
Customer Profitability CMASPRO  

Vendor and Accounts Payable

Information for the Vendor and Accounts Payable modules of IntelliDealer is stored in the following files:

Description File Name Comments
Vendor Master VMASTR  
Vendor Master Fiscal Year History VMFIS  
Vendor Master Calendar History VMCAL  
Memos MEMOS  
Accounts Payable Outstanding OUTSTD Header Information. OSRID is P for pending vouchers, O for outstanding and H for history
A/P voucher distribution entries YTDIST  

General Ledger

Information for the General Ledger module of IntelliDealer is stored in the following files:

Description File Name Comments
Account Group Descriptions GCDES  
Account Master ACCMAST  
Chart of Accounts COACMAST  
G/L Calendar History GLCAL New file as of IntelliDealer 6.7
G/L monthly bucket totals DEPTMAST  
G/L monthly by year by G/L account GLFIS  
Budgets GLBUD  
Fixed Assets FASSET  
General Invoice Header GBH  
General Invoice Detail GBD  

Parts

Information for the Parts module of IntelliDealer is stored in the following files:

Description File Name Comments
Part Master PARTMAST  
Bins PARTBIN Alternate Bin Info
Substitutions PARTSUB  
Cross Reference PARTXREF  
Parts history detail - receipts and sales PARTHIST  
Comments PARTCOMM Parts comments AND customer comments
Memos MEMOS  
Transfers PARTTFR  
Long Descriptions PARTDES  
Master Price File PARTPRC  
Active parts order header information PURORD  
Active parts order detail information PURPART  
Open parts invoice header information SALORD  
Open parts invoice detail information SALDET  
Parts inventory count files PARTCNT The 'header' record is stored with a bin number of '$$$$$$$'
Pending order receipts header PARTGRH  
Pending order receipts detail PARTGRD  
Related parts PARTLIST  
Special Terms Header STORDH  
Special Terms Details STORDD  

Service

Information for the Service module of IntelliDealer is stored in the following files:

Description File Name Comments
Open Work Order header information WOH  
Open Work Order Repair (Segment) information WOR  
Work Order Labor (WIP) WOLAB New file as of IntelliDealer 6.5
Work Order Parts (WIP) SALDET Work Order Parts Requisitions are records where SDSYS = 035
Work Order Technician Time WOTTM  
Work Order Time Analysis History WOTAH Only activated if the Down Time Delay code is set to mandatory in CMBR4 but it isn't fully used yet -- project to populate the dates is still pending. If the CMBR4 switch is activated as of 7.2 only four fields will be populated by work order: Machine Down indicator, Created By, Work Order Date Added, and Work Order Time Added. The data in this file is currently NOT purged (as of 7.2). There are no plans to change this at this time.

Equipment

Information for the Equipment module of IntelliDealer is stored in the following files:

Description File Name Comments
Base and Options Master BASE, OPTION  
Equipment Master CGIBASE  
Equipment Options CGIOPT  
History CGIHIST  
Group Codes CGIGRP  
Memos MEMOS  
Equipment invoice and quote header CGIINH  
Equipment invoice quote detail CGIIND  
Traffic CGIDR  
Equipment Warranty Information CGIWDT  

Payroll

Information for the Payroll module of IntelliDealer is stored in the following files:

Description File Name Comments
Master Records EMPLOYEE  
Deduction DEDN  
Payroll history file IEHIST  

Billing Files

Billing information for IntelliDealer is stored in the following files:

Description File Name Comments
Billing Header Information MNBDH
  • The freight terms from the parts requisition (ie C:Truck01) is now stored in the MNBDH file in the field BHFTRM for doing Crystals and Queries of consignment (ie. consignment inventory)
  • If you have a requisition number or labor number and you want to find the work order number, look in the BHORD for the requisition/labor number. The work order invoice number is stored in the BHCORD (purchase order number).
Billing Details Information MNBDD  
Billing Ship To MNBDM  
Billing Trace and Work Order Information MNBDT  
Billing Work Order Repair MNBDW  

Customized Screen Data

Information for customized screens within IntelliDealer is stored in the following files:

Description File Name Comments
Custom Screen Screens CSS  
Custom Screen Fields CSF  
Custom Screen Values CSV  
Custom Screen Data CSD  

Other

Other files that store important information for IntelliDealer include the following:

Description File Name Comments
Active SPECACCT entries from tables TBXUSE Will be removed in IntelliDealer 6.7
User group security USRGRP  
Web User Information and Defaults WEBUSR Lists all user id's for IntelliDealer
PFW Tables PFWTAB Prior to IntelliDealer 6.6, this file was called "TABLES"
Invoice History Header INVHH  
Invoice History Detail INVHD  
Fixed Assets Master FASSET  

Log Files

Used to log events, (such as changes or adds), to specific files in the system.

Warning: These logs were implemented for specific analysis of certain areas of the system and should only be turned on when necessary. Activating logs will impact the performance of the server and affect the speed of applications.

On the System Settings screen you can select the files to monitor and the specific retention period. See System Specific File Monitoring & Retention in the System Settings topic.

Once the switches are activated, a file for each area starts to build log entries after the next full database run. Each file starts with 'LOG' so that they are easier to find. These LOG files have essentially the same definition of the files they log but with these additional fields:

Field Description Length
UserID The person who performed the change/ update. 10 characters
JobID The job that performed the change/ update. 10 characters
Date The date on which the change/ update occurred.

8 characters in format "YYYYMMDD"

For example "20070430" is April 30th 2007.
Time The time at which the change/ update occurred.

6 characters in format "HHMMSS"

For example "140835" is 2:08:35 pm.
Record Activity

The record activity. One of:

  • A—after record. A snapshot of a record after a change has been made.

  • B—before record. A snapshot of a record before any changes were made to it.

  • C—creation record. An entry that did not exist in the file until it was created.
  • D—delete record. Normally this record is not actually seen in the log file itself. The programs that do the physical deletion are run during a database run when file triggers are turned off. This means you may see a C(creation) record and some B (before) and A (after) types in the file, but you probably will not see the D type. The only exception to this rule is green screen A/R agency maintenance which does a physical delete of a file and then an add every time a change is made.
 1 character

By using Query or Crystal reports, you can create reports of this data. In Query or Crystal reports you can view what the record looked like before and after by simply displaying the file without any sorting applied.

The purge routine for the log files is run during the first database run after the A/R month-end. For example, if the setting indicates 0 months of retention, the files are built over the course of the month and cleared during the month-end. If the table setting is 2 months it accumulates almost 3 months of data until the purge, which would reduce the files back to 2 months of data.

Warning: Most logs were designed to be turned on or off as needed as each log/trigger uses a substantial amount of system overhead. As such, leaving the logs on can dramatically impact performance.
If you are unsure of the need for logs, contact support for further clarification. The size of the log files can be extremely large, so again: keep an eye on disk space usage; the higher the usage, the slower the machine will be.

The available log files are:

System Settings -

System Specific File Monitoring & Retention

 Description Log File Data Source
Customer Master Customer Master log file LOGCMAS CMASTR
Customer Ship To Customer Master Ship To log file LOGCMSH CMASSH
Customer Contacts Customer Contacts log file LOGCMSC CMASCON
Customer Credit Info

 

 A/R Agency log file LOGCMAA CMASAA

Credit card authorizations

 LOGCCAU CCAUTH
Credit card postings LOGXMDT XMITDTRN
Equipment Master Wholegoods master log file LOGCGIB CGIBASE
General Invoice General Invoicing - Customer tab LOGGBH GBH
General Invoicing - G/L Details tab LOGGBD GBD
General Invoicing - Frequency tab LOGGBC GBC
Parts Master

Part Master log file

If you turn on this switch for PARTMAST be careful as it can take up a substantial amount of disk space, especially if you are running parts price updates.

 LOGPART PARTMAST
Work Order Files Work order description information LOGWOD WODES
Work order header information LOGWOH WOH
Work order labor information LOGWOL WOLAB
Work order repair information LOGWOR WOR
Rental Files Rental Management Contract log file LOGRMCT RMCONT
Rental Management Detail log file LOGRMDT RMDETL
Rental Invoice log file LOGRMIN RMINV
Rental Invoice Detail log file LOGRMID RMINVD
Vendor Master Files Vendor Master Log File LOGVMST VMASTR
Vendor Dealers Log file LOGVMDL VMDLR
Vendor Contacts Log file LOGVMCN VMCON
Vendor G/L Distribution Log file LOGVMDS VMDIST
Vendor Manufacturers Log file LOGVMMF VMMFG
Sales Order Header and Detail Sales Order Header file LOGSD SALDET
Sales Order Detail file LOGSO SALORD
PFWTAB File Tables log file (formerly TABLES) LOGTABL PFWTAB
Subledger File Subledger log file LOGSUBL SUBLED
Chart Of Accounts Chart Of Accounts log file LOGCOAC COACMAST
Employee Master Employee Master log file LOGEMPL EMPLOYEE
Employee Secondary log file LOGEMPS EMPSEC
Parts Purchase Orders Purchase Order header LOGPORD PURORD
Purchase Order details LOGPPRT PURPART
YTD Journal Files Journal log for manually keyed journals only LOGYTDJ YTDJRL
Security switch in system 995 by user Web Browsers by user LOGUSER WEBLOG
All dealers log three months of security history. Security Switch file LOGLGRP LOCGRP
User group security LOGUGGRP USRGRP
Contact support to have the file created. The retention period is hard-coded to three months. Bank reconciliation file LOGBANK BANKREC

Revision: 2025.08