MUSE – Bring future to talk to legacy

Sales Data from Top 5 POS Systems

Please find the Sales Data from Top 5 POS Systems. The files are pipe delimited with column headers.

• BUSY
• EASYSOL
• MARG
• RETAIL_EXPER
• SOFT_GEN

Please note that column “Barcode” is the input stream. Inputs from keyboards, scanners get captured in this column as next line item. Bill number is the primary key at bill level. From the data, many line items have manual inputs as text, numeric values other than barcodes that can either be discounted price (in case retailer is over riding the master price by giving discounts) or manual quantity inputs. This feed needs to be converted into an accurate bill that provides readable line item along with barcode description as well as quantity and price (by using masters).

Product Master

Please find the product master at barcode level: Product Master