1 | FlowTech Interface Device Settings

This article covers the device settings and technical details for the integration between FlowTech and Bepoz.

This article covers the device settings and technical details for the integration between FlowTech and Bepoz.

About

• This system utilises a SQL Server database similar to BEpoz
• In fact the configuration requires that their database is on the server and the same instance of SQL Server (this ensures database connections are always available)
• Smartcontroller will connect to the SQL Server using the same instance and security settings as it uses to connect to the BEpoz database
• The only difference is the actual database name
• If Smartcontroller cannot connect to the database, no sales will be sent across
• The interface connects to their database and runs a stored procedure on it, passing in the relevant details for each transaction

---

Device Settings

• Read Flow Data: This is supported by Flowtech. It will request the dispense data from Flowtech and enable the Dispense Summary Report. This should be on
• Database Name: This is the SQL Database name as setup in SQL Server. If nothing is put in this field, it will use the default database name of 'FlowTech'

---

Technical Details

• The Stored procedure is called spBEpozInterface
• The data sent across is as follows: 

Field Name Data Type BEpoz Data

• @PLU_Num SqlDbType.Int ExportCode1 + Size Number
• @Trans_Time SqlDbType.DateTimeTransaction Datetime
• @Qty SqlDbType.Int Item Sold Qty (Integer)
• @Sale_Price SqlDbType.Float Item Extended Price
• @Area_ID SqlDbType.Int Store ID
• @Cost_of_Sale SqlDbType.Float Item Extended Cost
• @Size SqlDbType.Int Mills Sold
• @TransID SqlDbType.Int TransactionID
• @PosID SqlDbType.Int TillID