Technical Note: 20011004153b

System Management

(Maitre'D 2005, from Service Pack 4 Hot Fix 13 and later versions of 2005)

System Configuration / Backup

When you Save or Restore a System Management or an Extended System Management, a portion of the database is copied.
Here is a list of all available database files, along with whether or not they are saved as part of the regular or extended System Management.
File Name

 

Save
System Management

Save Extended System Management

Description

File001.dat

 

X

Printer
File002.dat

X

X

Tax
File003.dat

 

X

Payment
File004.dat

X

X

Inventory Unit
File005.dat

 

 

Employee (P.O.S. Control)
File006.dat

X

X

Division
File007.dat

X

X

Sales Items Details
File008.dat

X

X

Sales Items
File009.dat

 

 

Configuration
File010.dat

 

 

Terminals (Workstations)
File011.dat

 

 

authorization
File012.dat

 

 

Misc. and dates
File013.dat

X

X

Promotion (Discounts)
File014.dat

 

 

Table
File015.dat

 

 

Client
File016.dat

 

 

Transaction
File017.dat

 

 

Bills
File018.dat

 

 

Table assignment reasons
File019.dat

 

 

Maintenance table
File020.dat

 

 

Stock quantity
File021.dat

X

X

Inventory
File022.dat

 

 

Work schedule
File023.dat

 

 

Archive table (Floppies)
File024.dat

 

X

Mode
File025.dat

 

 

Bills for archiving
File026.dat

 

 

Transaction for report
File027.dat

 

 

Client for A/R
File028.dat

 

 

Deleted tables
File029.dat

 

 

Personnel (Time and Attendance)
File030.dat

X

X

Preferential Screens for Small Devices
File031.dat

 

X

Revenue Center
File032.dat

 

 

Credit cards Payments
File033.dat

 

 

Credit cards training
File034.dat

 

 

Credit cards for report
File035.dat

X

X

Inventory Type
File036.dat

X

X

Bergs (Sales Units)
File037.dat

 

 

Segmentation
File038.dat

 

 

Client for delivery
File039.dat

 

 

Table for timely report (Hours Table)
File040.dat

 

 

Street code for delivery
File041.dat to
File047.dat

 

Transaction for daily report
File048.dat

 

 

Shared printers
File049.dat

 

 

Transaction for A/R
File050.dat

 

 

Old Sales report configuration  (only used during upgrade)
File051.dat

 

 

Dealer publicity
File052.dat

 

 

Descriptions for multi-location
File053.dat

 

 

Old Sales recipe (only used during upgrade)
File054.dat

X

X

Logical printers
File055.dat

X

X

Inventory configuration
File056.dat

 

 

Temporary file to generate summary of checks by server
File057.dat

X

X

Column selector for inventory reports
File058.dat

X

X

Product type (Inventory Category)
File059.dat

 

 

Supplier
File060.dat

 

 

Room for multi-location
File061.dat to
File067.dat

 

Credit card for daily report
File068.dat

 

 

Purchases header
File069.dat

 

 

Purchases detail
File070.dat

X

X

Preferential Screens
File071.dat

 

 

Old Preparation recipe  (only used during upgrade)
File072.dat

 

 

Inventory history
File073.dat

 

 

Production schedule
File074.dat

 

 

Production schedule, reserved products
File075.dat

 

 

Labor cost by tasks temporary report
File076.dat

 

 

Requisitions
File077.dat

 

X

Work tasks
File078.dat

 

 

Time and attendance temporary report
File079.dat

 

 

Category of taxes
File080.dat

 

 

Font
File081.dat

 

 

Accounts chart
File082.dat

 

 

Accounting configuration
File083.dat

 

 

Redirection table
File084.dat

 

 

Scan code
File085.dat

 

 

Old Printer report (only used during upgrade)
File086.dat

 

 

Old Preset (only used during upgrade)
File087.dat

 

 

Maintenance history
File088.dat

 

 

Employee schedule report
File089.dat

 

 

Transactions A/R for accounting interface
File090.dat

X

X

PLU conversion table for NCR2160
File091.dat

 

X

Second main configuration
File092.dat

X

X

Tax breakpoints table
File093.dat

 

 

Secondary employee file (P.O.S. Control)
File094.dat

X

X

Preference item for touch screen
File095.dat

 

 

Tasks and ports assignations (Hardware Extensions)
File096.dat

X

X

Included item
File097.dat

 

 

Inventory ratio report
File098.dat

 

X

Sales Item category (Division Category)
File099.dat

 

 

Temporary file
File100.dat

X

X

Mandatory division
File101.dat

 

 

Temporary file for fileman.c
File102.dat

 

X

Time intervals for color coding
File103.dat

 

 

Generic Input
File105.dat

 

 

Released tables
File106.dat

X

X

Item Class
File107.dat

 

 

Added EFT info to file 32
File108.dat

 

 

Added  EFT info to file 33
File109.dat

 

 

Current  EFT batch posted
File110.dat

 

 

Closed  EFT batch
File111.dat

 

 

Delay Management
File112.dat

 

X

Configuration for CCM
File113.dat

 

X

Departments TandA
File114.dat

 

X

Termination description TandA
File115.dat

 

X

Termination type TandA
File116.dat

 

X

Full / Part time description TandA
File117.dat

 

X

Other paid description TandA
File118.dat

 

X

Adjustment Reasons description TandA
File119.dat

 

X

Meal plan description TandA
File120.dat

 

X

EEOC
File121.dat

 

 

US Federal TandA
File122.dat

 

 

Extended employee info TandA
File123.dat

 

X

Configuration file for Employee (POS)
File124.dat

 

X

Screen Access file for Employee
File125.dat

 

 

Detailed configuration for General Ledger
File126.dat

 

 

Supplier account chart
File127.dat

 

 

Invoice detail account description and Number
File128.dat

 

 

Buffet descriptions
File129.dat

X

X

Weighted Modifier
File130.dat

 

 

Revenue Center Description for kitchen printing
File131.dat

 

X

Configuration for Time and Attendance
File132.dat

 

 

Details of checks (A/R)
File133.dat

 

 

Message displayed on each POS
File134.dat

 

 

Ratio between Division and Inventory Categories
File135.dat

 

X

Configuration for EFT
File136.dat

 

 

TandA punch file
File137.dat

 

X

Labor Distribution Report time period
File138.dat

 

 

Exploitation result
File139.dat

 

 

Scanner discounts array save
File140.dat

 

 

Scanner discounts array save training
File141.dat

 

 

Gift certificate transaction file see also file 195
File142.dat

 

X

Time and Attendance overtime configuration
File143.dat

 

X

Harvey's Corporate
File144.dat

 

 

EFT new format
File145.dat

 

 

Inventory Order Pad
File146.dat

X

X

Screen Layout Template
File147.dat

 

 

Temporary file for PLU report summary
File148.dat

X

X

Main configuration Exploitation report
File149.dat

X

X

Detail configuration Exploitation report
File150.dat

 

X

Detail of ASCII file EFTSETUP.DAT for NABANCO
File151.dat

 

 

Labor Distribution Report
File152.dat

 

 

Table name
File153.dat

X

X

Summary of sold items Report SETUP
File154.dat

X

X

Summary of sold items Report DATA
File155.dat

 

 

Report Control
File156.dat

 

 

Temp. file to sort the list of prompts
File157.dat

 

 

Pended batch
File158.dat

 

 

Previous closed EFT batch
File159.dat

X

X

Programmable lists
File160.dat

X

X

Programmable lists description
File161.dat

X

X

Detail of discounts definition
File162.dat

 

 

Set up for Canadian CCM
File163.dat

 

 

Phone List for CCM
File164.dat

X

X

PLU Number stored in BTREE
File165.dat

X

X

Sold Item report description
File166.dat

 

 

Temporary for punch report
File167.dat

 

 

Delivery History
File168.dat

 

 

Recipe by ingredient report
File169.dat

 

 

Reporting of delivery delay
File170.dat

 

 

Transaction for archiving
File171.dat

 

 

Last delivery order
File172.dat

 

 

Counter to be displayed on SFR (Customer Delivery)
File173.dat

 

 

Link list of pre-ordered items
File174.dat

 

 

Frequent diner customers file
File175.dat

 

 

Privilege card transaction file
File176.dat

 

 

Floor management table configuration
File177.dat

 

 

Floor management floor plan header
File178.dat

 

 

Floor management floor plan detail
File179.dat

 

 

Detail time period report configuration
File180.dat

 

 

Store for packet received EFT
File181.dat

 

 

Store relay packet and status EFT
File182.dat

 

 

Store current day electronic bar transactions
File183.dat

 

 

Temporary report file
File184.dat

 

 

Store currency setup for inventory
File185.dat

 

 

Current day tips declarations
File186.dat

 

 

Archive file for tips declarations
File187.dat

 

 

Current day tips transfers
File188.dat

 

 

Archive file for tips transfers
File189.dat

 

 

Void reasons descriptions
File190.dat

 

 

Delivery driver dispatch info
File191.dat

 

 

Configuration III
File192.dat

 

 

Predefined Printers
File193.dat

 

 

Dispatch Data
File194.dat

 

 

Servers Dispatch
File195.dat

 

 

Cumulative of all gift transaction see file 141
File196.dat

X

X

Item level Modifiers
File197.dat

 

 

AZBAR North American Protocol
File198.dat

X

X

Combo Meal
File199.dat

 

 

Data used for CCM Export.
File200.dat

X

X

Screen Layouts
File201.dat

X

X

Screen Layouts for Small Devices
File202.dat

X

X

Command list description
File203.dat

X

X

Command data
File204.dat

 

 

Break Punch
File205.dat

 

 

Service speed data
File206.dat

 

 

Global service speed data
File207.dat

 

 

Purchase Order Header
File208.dat

 

 

Purchase Order Detail
File209.dat

 

 

Undelivered Reason
File210.dat

 

 

Frequent Diner Promotion

File220.dat

X

X

Recipe Header

File221.dat

X

X

Inventory Recipe Detail

File222.dat

X

X

Item Recipe Detail

File247.dat

 

 

Dummy file

File248.dat

 

 

Macro Information
File249.dat

 

 

Setup for BTREE

File250.dat

 

 

BTREE

WScreen.prg

X

X

Workstation Custom Large Screens Design