The Hach WIMS Direct Server-Side Interface to Mettler Toledo OverDrive looks at three specific tables for data: TRANSACTION_TABLE, TRANSACTION_DETAIL, and PRODUCT.

TRANSACTION_TABLE

This table contains most of the information imported. Among many other fields, the display below shows the ones imported.

TRANS_NO is used to retrieve data from TRANSACTION_DETAIL.

VEHICLE_ID is used to match with the Hach WIMS variable NAME field. If the variable does not exist, the interface will create it.

ACCOUNT_ID is used to match with the Hach WIMS Location. In Hach WIMS, locations are defined as plain text, the description of the location contains the account ID number that matches with the OverDrive database. When the Account_ID cannot be found in the description field, a new Location is created in Hach WIMS, with location description set to Account_ID and location name is set to the description in the OverDrive database. The description in the OverDrive database comes from the ACCOUNT table.

EXTENDED_TABLE1 is imported as FROM_SERVICE_AREA.

EXTENDED_TABLE2 is imported as FROM_ZIPCODE.

The other fields are self-explanitory.

TRANSACTION_DETAIL Table

This table is used to retrieve a Product ID. The ID is used to locate a matching record in the PRODUCT table. Also, the WEIGHING_NO must be set to 1 (one) in this table.

PRODUCT Table

The PRODUCT Table contains the description of the product.