[ROOT] dt FactResellerSale WHERE DimSalesTerritoryId EQ '1' > SHUFFLE < SKIP 6862 > < TAKE 28 >
28 items
| FactResellerSaleId | CarrierTrackingNumber | CustomerPONumber | DimCurrencyId | DimEmployeeId | DimProductId | DimPromotionId | DimResellerId | DimSalesTerritoryId | DiscountAmount | DueDate | ExtendedAmount | Freight | OrderDate | OrderQuantity | ProductStandardCost | RevisionNumber | SalesAmount | SalesOrderLineNumber | SalesOrderNumber | ShipDate | TaxAmt | TotalProductCost | UnitPrice | UnitPriceDiscountPct |
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
| SO50209_19 | D138-4E7C-86 | PO15573136083 | 100 | 293 | 213 | 487 | 1 | 2023-08-23 | 141.31 | 3.53 | 2023-08-11 | 7 | 13.88 | 1 | 141.31 | 19 | SO50209 | 2023-08-18 | 11.30 | 97.15 | 20.19 | |||
| SO46649_17 | A093-4C86-B7 | PO2929149182 | 100 | 289 | 224 | 380 | 1 | 2022-10-23 | 10.37 | 0.26 | 2022-10-11 | 2 | 5.23 | 1 | 10.37 | 17 | SO46649 | 2022-10-18 | 0.83 | 10.46 | 5.19 | |||
| SO71943_11 | E676-4002-A7 | PO9309168525 | 100 | 293 | 575 | 55 | 1 | 2024-09-23 | 1430.44 | 35.76 | 2024-09-11 | 1 | 1481.94 | 1 | 1430.44 | 11 | SO71943 | 2024-09-18 | 114.44 | 1481.94 | 1430.44 | |||
| SO59021_15 | A306-4E83-B7 | PO7395154426 | 100 | 286 | 591 | 542 | 1 | 2024-03-24 | 1355.98 | 33.90 | 2024-03-12 | 4 | 308.22 | 1 | 1355.98 | 15 | SO59021 | 2024-03-19 | 108.48 | 1232.87 | 338.99 | |||
| SO71785_2 | 28F9-4101-A1 | PO19169115427 | 100 | 289 | 516 | 272 | 1 | 2024-09-23 | 140.90 | 3.52 | 2024-09-11 | 6 | 17.38 | 1 | 140.90 | 2 | SO71785 | 2024-09-18 | 11.27 | 104.27 | 23.48 | |||
| SO43867_5 | 061F-4449-BE | PO14471123403 | 100 | 286 | 346 | 145 | 1 | 2021-11-23 | 4079.99 | 102.00 | 2021-11-11 | 2 | 1912.15 | 1 | 4079.99 | 5 | SO43867 | 2021-11-18 | 326.40 | 3824.31 | 2039.99 | |||
| SO57046_45 | 52CC-460F-B3 | PO14500161818 | 100 | 282 | 544 | 650 | 1 | 2024-02-23 | 291.56 | 7.29 | 2024-02-11 | 6 | 35.96 | 1 | 291.56 | 45 | SO57046 | 2024-02-18 | 23.33 | 215.76 | 48.59 | |||
| SO44540_9 | 4773-44B5-9B | PO2900111031 | 100 | 286 | 212 | 469 | 1 | 2022-02-23 | 40.37 | 1.01 | 2022-02-11 | 2 | 12.03 | 1 | 40.37 | 9 | SO44540 | 2022-02-18 | 3.23 | 24.06 | 20.19 | |||
| SO65268_12 | E14C-42AB-92 | PO9309127032 | 100 | 293 | 566 | 55 | 1 | 2024-06-23 | 1336.23 | 33.41 | 2024-06-11 | 3 | 461.44 | 1 | 1336.23 | 12 | SO65268 | 2024-06-18 | 106.90 | 1384.33 | 445.41 | |||
| SO53605_18 | 6D2A-486B-AC | PO5017132122 | 100 | 289 | 499 | 308 | 1 | 2023-12-24 | 1204.69 | 30.12 | 2023-12-12 | 2 | 601.74 | 1 | 1204.69 | 18 | SO53605 | 2023-12-19 | 96.38 | 1203.49 | 602.35 | |||
| SO71836_18 | E41E-40C1-84 | PO841118259 | 100 | 286 | 588 | 254 | 1 | 2024-09-23 | 1846.78 | 46.17 | 2024-09-11 | 4 | 419.78 | 1 | 1846.78 | 18 | SO71836 | 2024-09-18 | 147.74 | 1679.11 | 461.69 | |||
| SO63224_19 | 668F-4A18-A0 | PO7627111844 | 100 | 293 | 380 | 433 | 1 | 2024-05-25 | 5864.04 | 146.60 | 2024-05-13 | 4 | 1554.95 | 1 | 5864.04 | 19 | SO63224 | 2024-05-20 | 469.12 | 6219.79 | 1466.01 | |||
| SO67335_2 | A016-4C1A-9B | PO1479138681 | 100 | 282 | 359 | 673 | 1 | 2024-07-24 | 1376.99 | 34.42 | 2024-07-12 | 1 | 1251.98 | 1 | 1376.99 | 2 | SO67335 | 2024-07-19 | 110.16 | 1251.98 | 1376.99 | |||
| SO43848_4 | FB94-4C38-B1 | PO18908190536 | 100 | 289 | 349 | 164 | 1 | 2021-11-23 | 8099.98 | 202.50 | 2021-11-11 | 4 | 1898.09 | 1 | 8099.98 | 4 | SO43848 | 2021-11-18 | 648.00 | 7592.38 | 2024.99 | |||
| SO63156_7 | B5C5-474E-8D | PO14587116412 | 100 | 293 | 560 | 199 | 1 | 2024-05-25 | 2915.64 | 72.89 | 2024-05-13 | 4 | 755.15 | 1 | 2915.64 | 7 | SO63156 | 2024-05-20 | 233.25 | 3020.60 | 728.91 | |||
| SO51711_17 | 5CB8-480D-A1 | PO16414129790 | 100 | 289 | 550 | 236 | 1 | 2023-11-23 | 149.87 | 3.75 | 2023-11-11 | 1 | 136.79 | 1 | 149.87 | 17 | SO51711 | 2023-11-18 | 11.99 | 136.79 | 149.87 | |||
| SO71836_46 | E41E-40C1-84 | PO841118259 | 100 | 286 | 551 | 254 | 1 | 2024-09-23 | 316.86 | 7.92 | 2024-09-11 | 2 | 144.59 | 1 | 316.86 | 46 | SO71836 | 2024-09-18 | 25.35 | 289.19 | 158.43 | |||
| SO49092_31 | 72CE-4E29-82 | PO14442163644 | 100 | 293 | 354 | 127 | 1 | 2023-05-26 | 2485.70 | 62.14 | 2023-05-14 | 2 | 1117.86 | 1 | 2485.70 | 31 | SO49092 | 2023-05-21 | 198.86 | 2235.71 | 1242.85 | |||
| SO43894_5 | 7DF2-4E54-B0 | PO2958194987 | 100 | 286 | 218 | 559 | 1 | 2021-11-23 | 45.60 | 1.14 | 2021-11-11 | 8 | 3.40 | 1 | 45.60 | 5 | SO43894 | 2021-11-18 | 3.65 | 27.17 | 5.70 | |||
| SO57110_3 | 2CB8-4486-8F | PO14007199730 | 100 | 289 | 580 | 56 | 1 | 2024-02-23 | 3061.78 | 76.54 | 2024-02-11 | 3 | 1082.51 | 1 | 3061.78 | 3 | SO57110 | 2024-02-18 | 244.94 | 3247.53 | 1020.59 | |||
| SO65200_25 | C4A9-49C4-AE | PO841148607 | 100 | 286 | 353 | 254 | 1 | 2024-06-23 | 1391.99 | 34.80 | 2024-06-11 | 1 | 1265.62 | 1 | 1391.99 | 25 | SO65200 | 2024-06-18 | 111.36 | 1265.62 | 1391.99 | |||
| SO44285_8 | 33BA-457C-B7 | PO16617120120 | 100 | 286 | 346 | 397 | 1 | 2022-01-23 | 10199.97 | 255.00 | 2022-01-11 | 5 | 1912.15 | 1 | 10199.97 | 8 | SO44285 | 2022-01-18 | 816.00 | 9560.77 | 2039.99 | |||
| SO53452_34 | B555-4FD7-8B | PO870113712 | 100 | 286 | 579 | 621 | 1 | 2023-12-24 | 728.91 | 18.22 | 2023-12-12 | 1 | 755.15 | 1 | 728.91 | 34 | SO53452 | 2023-12-19 | 58.31 | 755.15 | 728.91 | |||
| SO57136_24 | 0031-4C10-84 | PO7627163680 | 100 | 272 | 477 | 433 | 1 | 2024-02-23 | 20.96 | 0.52 | 2024-02-11 | 7 | 1.87 | 1 | 20.96 | 24 | SO57136 | 2024-02-18 | 1.68 | 13.06 | 2.99 | |||
| SO43917_1 | 9EDA-4CDB-A8 | PO8816199739 | 100 | 289 | 332 | 218 | 1 | 2021-11-23 | 1258.38 | 31.46 | 2021-11-11 | 3 | 413.15 | 1 | 1258.38 | 1 | SO43917 | 2021-11-18 | 100.67 | 1239.44 | 419.46 | |||
| SO63247_5 | 1EB8-4AE3-AC | PO6148143330 | 100 | 289 | 586 | 693 | 1 | 2024-05-25 | 890.82 | 22.27 | 2024-05-13 | 2 | 461.44 | 1 | 890.82 | 5 | SO63247 | 2024-05-20 | 71.27 | 922.89 | 445.41 | |||
| SO45295_2 | 113A-4330-B0 | PO14529163242 | 100 | 286 | 345 | 289 | 1 | 2022-05-26 | 2039.99 | 51.00 | 2022-05-14 | 1 | 1912.15 | 1 | 2039.99 | 2 | SO45295 | 2022-05-21 | 163.20 | 1912.15 | 2039.99 | |||
| SO51138_3 | 685D-4916-A6 | PO9338137293 | 100 | 293 | 565 | 13 | 451 | 1 | 100.22 | 2023-10-23 | 668.12 | 14.20 | 2023-10-11 | 2 | 461.44 | 1 | 567.90 | 3 | SO51138 | 2023-10-18 | 45.43 | 922.89 | 334.06 | 0.15 |
Generated 2024-11-11 01:40:45.024 UTC