Liquid Controls DMS Office - Manual (Page 35)

35
APPEnDIX
DELLoAD.DAT
The first section of the appendix includes examples of ASCII text files and tables describing each field. Examples
from page 36 to 41 (one type of Totalizer Record and four types Dispatch records) are generated by the back office
software for DMS Office. These files make up DELLOAD.DAT which LCLoad converts to .500 files for DMS Delivery.
Examples from page 41 to 46 (one type of Totalizer Record, four types Delivery records and one type of Completed
Miscellaneous Transactions record) are converted into text files by DMS Office for the back office software.
DATA FILE FoRMAT
Standard Totalizer Record
The first record in the DELLOAD.DAT file, the Totalizer
Record contains data for all products. Most of the numeric
fields, as well as the date and time, are set to zero, and the
alphanumeric fields are blank. DMS Delivery will populate
these fields in DELREAD.DAT.
Dispatch Records
Each Dispatch Record contains account-specific data for a
customer tank. This record contains all information relevant
to fulfilling a particular customer’s request including preset
type and amount, price, taxes, and discounts. There are
four examples in this appendix. They are exclusive and
not to be used together. In the examples, deviations from
the original Standard Dispatch Record are in bold type.
Standard Totalizer Record
The DELREAD.DAT Totalizer Record contains product
data gathered in DMSDelivery.
DELREAD.DAT
Delivery Record
Each Delivery Record contains account-specific data
relevant to a particular customer tank’s completed delivery.
The Dispatch Record and its corresponding completed
Delivery Record are linked via the access number field
There are four examples in this appendix. In the examples,
deviations from the original Standard Dispatch Record
are in bold type.
Completed Miscellaneous Transactions Record
Each Miscellaneous Transaction Record contains data for
a miscellaneous billable service(s) or unmetered product
delivery for a customer.
Included Dispatch Record Examples:
S
TanDarD
D
iSpaTcH
r
ecOrD
S
TanDarD
D
iSpaTcH
r
ecOrD wiTH
B
eGinninG
B
alance
Adds numeric field (Beginning Balance Field).
S
TanDarD
D
iSpaTcH
r
ecOrD wiTH
e
xTenDeD
D
river
i
nSTrucTiOnS
Adds two alphanumeric fields (Driver Instruction).
Increases the size of one alphanumeric field (Driver
Instruction)
S
TanDarD
D
iSpaTcH
r
ecOrD wiTH
B
eGinninG
B
alance
anD
ee
xTenDeD
D
river
i
nSTrucTiOnS
Adds numeric field (Beginning Balance Field).
Adds two alphanumeric fields (Driver Instruction).
Increases the size of one alphanumeric field
(Driver Instruction).
Included Delivery Record Examples:
S
TanDarD
D
elivery
r
ecOrD
S
TanDarD
D
elivery
r
ecOrD wiTH
B
eGinninG
B
alance
Adds numeric field (Beginning Balance Field)
S
TanDarD
D
elivery
r
ecOrD wiTH
e
xTenDeD
D
river
i
nSTrucTiOnS
Adds three alphanumeric fields ((2) Twenty-four
bytes of reserved pad space, Sixteen bytes of reserved
pad space).
S
TanDarD
D
elivery
r
ecOrD wiTH
B
eGinninG
B
alance
anD
e
xTenDeD
D
river
i
nSTrucTiOnS
Adds numeric field (Beginning Balance Field). Adds
three alphanumeric fields ((2) Twenty-four bytes of reserved
pad space, Sixteen bytes of reserved pad space).
QUICK TEXT FILE KEy
Field number
H2 - H = Header • 2 = Sequence #
n - Numeric
A - Alphanumeric
Field Type
Integer - Numeric value, no decimal point
Floating - Numeric value, decimal point
A - Alphanumeric
Numeric fields must contain a value. If the field does not
have a value, use a “0”.
If an alphanumeric fields does not have a value, use a
blank space “ “.