[ROOT] dt FactResellerSale < WHERE DimSalesTerritoryId EQ '4' > SHUFFLE < SKIP 397 > < TAKE 28 >
28 items
FactResellerSaleId | CarrierTrackingNumber | CustomerPONumber | DimCurrencyId | DimEmployeeId | DimProductId | DimResellerId | DimSalesTerritoryId | DueDate | ExtendedAmount | Freight | OrderDate | OrderQuantity | ProductStandardCost | RevisionNumber | SalesAmount | SalesOrderLineNumber | SalesOrderNumber | ShipDate | TaxAmt | TotalProductCost | UnitPrice |
---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
SO48311_45 | AAD7-4EBC-A1 | PO16472177233 | 100 | 287 | 464 | 239 | 4 | 2023-02-02 | 42.39 | 1.06 | 2023-01-21 | 3 | 9.71 | 1 | 42.39 | 45 | SO48311 | 2023-01-28 | 3.39 | 29.14 | 14.13 |
SO46964_48 | B3E6-43CC-A2 | PO15689139014 | 100 | 283 | 381 | 328 | 4 | 2022-10-03 | 3001.31 | 75.03 | 2022-09-21 | 5 | 605.65 | 1 | 3001.31 | 48 | SO46964 | 2022-09-28 | 240.11 | 3028.25 | 600.26 |
SO51131_11 | D489-4DF3-A2 | PO16298169856 | 100 | 287 | 467 | 599 | 4 | 2023-09-02 | 44.08 | 1.10 | 2023-08-21 | 3 | 9.16 | 1 | 44.08 | 11 | SO51131 | 2023-08-28 | 3.53 | 27.48 | 14.69 |
SO50747_24 | A59F-46DA-BE | PO5597196496 | 100 | 281 | 428 | 75 | 4 | 2023-08-03 | 837.02 | 20.93 | 2023-07-22 | 4 | 185.82 | 1 | 837.02 | 24 | SO50747 | 2023-07-29 | 66.96 | 743.28 | 209.26 |
SO53531_16 | B1FB-47B2-8E | PO2697181370 | 100 | 282 | 557 | 187 | 4 | 2023-11-03 | 153.89 | 3.85 | 2023-10-22 | 1 | 113.88 | 1 | 153.89 | 16 | SO53531 | 2023-10-29 | 12.31 | 113.88 | 153.89 |
SO59013_4 | C224-4535-BA | PO5597199820 | 100 | 281 | 543 | 75 | 4 | 2024-02-02 | 37.25 | 0.93 | 2024-01-21 | 1 | 27.57 | 1 | 37.25 | 4 | SO59013 | 2024-01-28 | 2.98 | 27.57 | 37.25 |
SO47427_1 | 61AA-44CA-99 | PO4640137176 | 100 | 287 | 358 | 648 | 4 | 2022-11-03 | 8606.21 | 215.16 | 2022-10-22 | 7 | 1105.81 | 1 | 8606.21 | 1 | SO47427 | 2022-10-29 | 688.50 | 7740.67 | 1229.46 |
SO44538_15 | E495-47A9-AD | PO2523126243 | 100 | 287 | 232 | 167 | 4 | 2022-01-03 | 28.84 | 0.72 | 2021-12-22 | 1 | 31.72 | 1 | 28.84 | 15 | SO44538 | 2021-12-29 | 2.31 | 31.72 | 28.84 |
SO46057_16 | 6F2B-45A4-9C | PO12499164653 | 100 | 282 | 220 | 78 | 4 | 2022-07-03 | 100.93 | 2.52 | 2022-06-21 | 5 | 12.03 | 1 | 100.93 | 16 | SO46057 | 2022-06-28 | 8.07 | 60.14 | 20.19 |
SO47687_21 | 738F-43EE-95 | PO10817185499 | 100 | 287 | 453 | 203 | 4 | 2022-12-03 | 107.98 | 2.70 | 2022-11-21 | 3 | 24.75 | 1 | 107.98 | 21 | SO47687 | 2022-11-28 | 8.64 | 74.24 | 35.99 |
SO49851_24 | 14FB-4B97-95 | PO2494142030 | 100 | 281 | 308 | 184 | 4 | 2023-06-03 | 2232.82 | 55.82 | 2023-05-22 | 3 | 660.91 | 1 | 2232.82 | 24 | SO49851 | 2023-05-29 | 178.63 | 1982.74 | 744.27 |
SO47027_34 | 1A9C-4166-A7 | PO3480112515 | 100 | 283 | 242 | 436 | 4 | 2022-10-03 | 4684.91 | 117.12 | 2022-09-21 | 6 | 722.26 | 1 | 4684.91 | 34 | SO47027 | 2022-09-28 | 374.79 | 4333.54 | 780.82 |
SO59068_12 | B7CC-4A9D-86 | PO9715112509 | 100 | 281 | 525 | 490 | 4 | 2024-02-02 | 316.86 | 7.92 | 2024-01-21 | 2 | 144.59 | 1 | 316.86 | 12 | SO59068 | 2024-01-28 | 25.35 | 289.19 | 158.43 |
SO44113_1 | B9C7-4334-81 | PO2697181021 | 100 | 282 | 348 | 187 | 4 | 2021-11-03 | 8099.98 | 202.50 | 2021-10-22 | 4 | 1898.09 | 1 | 8099.98 | 1 | SO44113 | 2021-10-29 | 648.00 | 7592.38 | 2024.99 |
SO43912_4 | 69B6-46F8-A4 | PO7656175368 | 100 | 282 | 322 | 403 | 4 | 2021-10-03 | 419.46 | 10.49 | 2021-09-21 | 1 | 413.15 | 1 | 419.46 | 4 | SO43912 | 2021-09-28 | 33.56 | 413.15 | 419.46 |
SO49890_16 | 9B22-4240-83 | PO7859114282 | 100 | 272 | 414 | 221 | 4 | 2023-06-03 | 298.06 | 7.45 | 2023-05-22 | 2 | 110.28 | 1 | 298.06 | 16 | SO49890 | 2023-05-29 | 23.85 | 220.57 | 149.03 |
SO45074_12 | 7225-40DF-B0 | PO7859191751 | 100 | 287 | 220 | 221 | 4 | 2022-03-05 | 40.37 | 1.01 | 2022-02-21 | 2 | 12.03 | 1 | 40.37 | 12 | SO45074 | 2022-02-28 | 3.23 | 24.06 | 20.19 |
SO44787_6 | CFC8-46AC-A7 | PO5597180446 | 100 | 283 | 292 | 75 | 4 | 2022-02-02 | 818.70 | 20.47 | 2022-01-21 | 1 | 706.81 | 1 | 818.70 | 6 | SO44787 | 2022-01-28 | 65.50 | 706.81 | 818.70 |
SO50738_41 | 531C-4E52-80 | PO3915159731 | 100 | 281 | 327 | 130 | 4 | 2023-08-03 | 1409.38 | 35.23 | 2023-07-22 | 3 | 486.71 | 1 | 1409.38 | 41 | SO50738 | 2023-07-29 | 112.75 | 1460.12 | 469.79 |
SO59017_3 | 1571-4C89-99 | PO4582165909 | 100 | 282 | 595 | 25 | 4 | 2024-02-02 | 338.99 | 8.47 | 2024-01-21 | 1 | 308.22 | 1 | 338.99 | 3 | SO59017 | 2024-01-28 | 27.12 | 308.22 | 338.99 |
SO50745_9 | 02DB-4CC5-85 | PO5539140407 | 100 | 282 | 401 | 61 | 4 | 2023-08-03 | 196.81 | 4.92 | 2023-07-22 | 3 | 48.55 | 1 | 196.81 | 9 | SO50745 | 2023-07-29 | 15.74 | 145.64 | 65.60 |
SO63262_9 | 3368-4317-8F | PO6351144702 | 100 | 281 | 582 | 255 | 4 | 2024-04-04 | 5102.97 | 127.57 | 2024-03-23 | 5 | 1082.51 | 1 | 5102.97 | 9 | SO63262 | 2024-03-30 | 408.24 | 5412.55 | 1020.59 |
SO69532_17 | 27FB-4A86-85 | PO3799165791 | 100 | 282 | 472 | 312 | 4 | 2024-07-03 | 266.70 | 6.67 | 2024-06-21 | 7 | 23.75 | 1 | 266.70 | 17 | SO69532 | 2024-06-28 | 21.34 | 166.24 | 38.10 |
SO53586_8 | 37CB-4A82-96 | PO4002170204 | 100 | 282 | 471 | 674 | 4 | 2023-11-03 | 76.20 | 1.91 | 2023-10-22 | 2 | 23.75 | 1 | 76.20 | 8 | SO53586 | 2023-10-29 | 6.10 | 47.50 | 38.10 |
SO48369_10 | 92AB-4468-B5 | PO4582138864 | 100 | 282 | 230 | 25 | 4 | 2023-02-02 | 144.20 | 3.61 | 2023-01-21 | 5 | 29.08 | 1 | 144.20 | 10 | SO48369 | 2023-01-28 | 11.54 | 145.40 | 28.84 |
SO48378_18 | 2FD7-4721-9D | PO6786131738 | 100 | 283 | 333 | 3 | 4 | 2023-02-02 | 939.59 | 23.49 | 2023-01-21 | 2 | 486.71 | 1 | 939.59 | 18 | SO48378 | 2023-01-28 | 75.17 | 973.41 | 469.79 |
SO69528_47 | 2644-4747-86 | PO6438163496 | 100 | 272 | 353 | 309 | 4 | 2024-07-03 | 1391.99 | 34.80 | 2024-06-21 | 1 | 1265.62 | 1 | 1391.99 | 47 | SO69528 | 2024-06-28 | 111.36 | 1265.62 | 1391.99 |
SO69505_13 | FE34-45B3-8D | PO5684197579 | 100 | 282 | 515 | 385 | 4 | 2024-07-03 | 32.54 | 0.81 | 2024-06-21 | 2 | 12.04 | 1 | 32.54 | 13 | SO69505 | 2024-06-28 | 2.60 | 24.08 | 16.27 |
Generated 2024-09-20 16:38:47.605 UTC