Reference ID,Company code,Subsidiary,Store ID,Customer Number,Posting Date,Currency,Net sales (excluding tax),Taxes,Freight,Total AR,Inventory change,COGS,Royalty,Know-how,Brand,Category,UUID,Order Number
1601150021990030,0021,0099,0002,0001010670,07/20/2017,CAD,34.98,14.70,5.00,54.68,8.99-,8.99,0.00,0.00,0.00,Sales,,0001
1601150021990030,0021,0099,0002,0001010670,07/19/2017,CAD,24.99,5.90,0.00,30.89,12.99-,12.99,2.12,3.50,4.90,Gift Card,,0002
1601150021990030,0021,0099,0002,0001010670,07/18/2017,CAD,37.99,5.90,0.00,43.89,0,0.00,1.00,2.00,3.00,Gift Card,,0002
1601150021990030,0021,0099,0002,0001010670,07/19/2017,CAD,18.99,3.65,1.00,23.64,12.99-,12.99,0.00,0.00,0.00,Sales,1435271249HJDGHS354fgdh,0003
1601150021020031,0021,0002,0004,0001010655,07/20/2017,CAD,34.98,15.70,4.00,54.68-,8.99,8.99-,0.00,0.00,0.00,Sales,,0004
1601150021020032,0021,0002,0004,0001010655,07/19/2017,CAD,24.99,5.90,0.00,30.89-,12.99,12.99-,2.12,3.50,4.90,Gift Card,,0005
1601150021020032,0021,0002,0004,0001010655,07/19/2017,CAD,24.99,5.90,0.00,34.89-,12.99,12.99-,2.12,3.50,4.90,Gift Card,,0006