Reference ID,Company code,Subsidiary,Store ID,Customer Number,Posting Date,Currency,Net sales (excluding tax),VAT,Delivery costs,Total AR,Inventory change,COGS,Royalty,Know-how,Brand,Category,UUID,Order ID 1601150021990007,0021,0099,0002,0001010670,07/20/2017,CAD,34.98,19.70,0,54.68,8.99-,8.99,0.00,0.00,0.00,Sales,,600 1601150021990007,0021,0099,0002,0001010670,07/19/2017,CAD,24.99,4.90,1.00,30.89,12.99-,12.99,2.12,3.50,4.90,Gift Card,,601 1601150021990007,0021,0099,0002,0001010670,07/19/2017,CAD,24.99,4.90,1.00,30.89,0.00,0.00,1.00,2.00,3.00,Gift Card,,601 1601150021990007,0021,0099,0002,0001010670,07/19/2017,CAD,13.99,4.65,5.00,23.64,12.99-,12.99,0.00,0.00,0.00,Sales,1435271249HJDGHS354fgdh,602 1601150021020008,0021,0002,0004,0001010655,07/20/2017,CAD,34.98,19.70,4.00,54.68-,8.99,8.99-,0.00,0.00,0.00,Sales,,603 1601150021020008,0021,0002,0004,0001010655,07/20/2017,CAD,34.98,19.70,4.00,54.68-,8.99,8.99-,5.00,4.00,3.00,Sales,,603 1601150021020013,0021,0002,0004,0001010655,07/19/2017,CAD,24.99,5.90,2.00,30.89-,12.99,12.99-,2.12,3.50,4.90,Gift Card,,604 1601150021020013,0021,0002,0004,0001010655,07/19/2017,CAD,24.99,5.90,2.00,32.89-,12.99,12.99-,2.12,3.50,4.90,Gift Card,,605