Liquid Controls DMS Office - Manual (Page 13)

13
In order to interface with and pull data from your back office
software, DMS Office needs the dispatch data to be in an
ASCII text file format. ASCII text files can be generated
by your back office software.
ASCII text files are divided into records, and records are
divided into fields. A record contains data specific to one
product, customer, or tank, and a field represents detail for
that specific record (Example: a unit price of a product).
Each record is terminated by a carriage return and line
feed (CR/LF), and each field within the record is comma
and quotation mark delimited.
“Field 1”, “Field 2”, Field 3”, “Field 4”, .... (CR/LF)
Some fields are strictly numeric and some are alphanumeric.
All numeric fields must contain a value. If a numeric field
does not have a positive or negative value, it must be 0.
An alphanumeric field with no data is represented by a
space between the quotation marks.
After the files are generated, export them to a common
destination (see Source and Destination Window - pg. 14).
Throughout this manual the ASCII text file created by the
back office software will be refered to as DELLOAD.DAT,
and the ASCII text file created by DMS Office for the back
office software will be refered to as DELREAD.DAT.
DATA FILE FoRMAT
Set Up
An example of each record and a table containing a
description of every field can be found in Appendix.
The Totalizer Record and the Dispatch Records are
generated by the back office software and converted into
.500 files by LCLoad for transfer to DMS Delivery.
Totalizer Record
The Totalizer Record contains data pertaining to
products.
Dispatch Record
Each Dispatch Record contains customer specific account
data such as account number, address, taxes, price,
preset amounts, and discounts.
The Completed Delivery Record and the Completed
Miscellaneous Transactions Record are produced by DMS
Delivery as .trn files and converted by DMS Office into
ASCII text files for transfer to the back office software.
Completed Delivery Record
The Completed Delivery Record contains the data
recorded by DMS Delivery during delivery. DMS Delivery
creates this record and then sends it to the back office
software.
Completed Miscellaneous Transactions Record
This record contains data for miscellaneous billable
services not associated with a delivery.
RECoRD TyPES