Owner's manual
In order to interface with and pull data from your back ofce
software, DMS Ofce needs the dispatch data to be in an
ASCII text le format. ASCII text les can be generated
by your back ofce software.
ASCII text les are divided into records, and records are
divided into elds. A record contains data specic to one
product, customer, or tank, and a eld represents detail for
that specic record (Example: a unit price of a product).
Each record is terminated by a carriage return and line
feed (CR/LF), and each eld within the record is comma
and quotation mark delimited.
“Field 1”, “Field 2”, Field 3”, “Field 4”, .... (CR/LF)
Some elds are strictly numeric and some are alphanumeric.
All numeric elds must contain a value. If a numeric eld
does not have a positive or negative value, it must be 0.
An alphanumeric eld with no data is represented by a
space between the quotation marks.
After the les are generated, export them to a common
destination (see Source and Destination Window - pg. 14).
Throughout this manual the ASCII text le created by the
back ofce software will be refered to as DELLOAD.DAT,
and the ASCII text le created by DMS Ofce for the back
ofce software will be refered to as DELREAD.DAT.
An example of each record and a table containing a
description of every eld can be found in Appendix.
The Totalizer Record and the Dispatch Records are
generated by the back ofce software and converted into
.500 les by LCLoad for transfer to DMS Delivery.
The Totalizer Record contains data pertaining to
products.
Each Dispatch Record contains customer specic 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 les and converted by DMS Ofce into
ASCII text les for transfer to the back ofce software.
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 ofce
software.
This record contains data for miscellaneous billable
services not associated with a delivery.