[ROOT] dt FactResellerSale < WHERE DimProductId EQ ALL SHUFFLE < SKIP 1697 > < 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 |
---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
SO53471_31 | 7B7E-4C32-B2 | PO16994189676 | 100 | 283 | 481 | 306 | 3 | 2023-12-24 | 26.97 | 0.67 | 2023-12-12 | 5 | 3.36 | 1 | 26.97 | 31 | SO53471 | 2023-12-19 | 2.16 | 16.81 | 5.39 |
SO49843_4 | D3CA-4A51-B6 | PO11484175391 | 100 | 283 | 412 | 594 | 2 | 2023-07-24 | 180.13 | 4.50 | 2023-07-12 | 1 | 133.30 | 1 | 180.13 | 4 | SO49843 | 2023-07-19 | 14.41 | 133.30 | 180.13 |
SO47028_35 | 8DA0-456D-8F | PO3799132728 | 100 | 282 | 409 | 312 | 4 | 2022-11-23 | 418.51 | 10.46 | 2022-11-11 | 2 | 185.82 | 1 | 418.51 | 35 | SO47028 | 2022-11-18 | 33.48 | 371.64 | 209.26 |
SO44758_19 | 28CF-4701-9C | PO14268184289 | 100 | 283 | 312 | 418 | 3 | 2022-03-25 | 2146.96 | 53.67 | 2022-03-13 | 1 | 2171.29 | 1 | 2146.96 | 19 | SO44758 | 2022-03-20 | 171.76 | 2171.29 | 2146.96 |
SO71827_13 | C6C1-47DB-95 | PO11107195325 | 19 | 284 | 547 | 156 | 6 | 2024-09-23 | 48.59 | 1.21 | 2024-09-11 | 1 | 35.96 | 1 | 48.59 | 13 | SO71827 | 2024-09-18 | 3.89 | 35.96 | 48.59 |
SO69414_3 | 47BD-4582-A4 | PO15283145065 | 100 | 281 | 566 | 363 | 3 | 2024-08-23 | 890.82 | 22.27 | 2024-08-11 | 2 | 461.44 | 1 | 890.82 | 3 | SO69414 | 2024-08-18 | 71.27 | 922.89 | 445.41 |
SO48351_8 | 0478-43AC-AB | PO1885129829 | 19 | 284 | 360 | 588 | 6 | 2023-03-25 | 1229.46 | 30.74 | 2023-03-13 | 1 | 1105.81 | 1 | 1229.46 | 8 | SO48351 | 2023-03-20 | 98.36 | 1105.81 | 1229.46 |
SO48311_44 | AAD7-4EBC-A1 | PO16472177233 | 100 | 287 | 381 | 239 | 4 | 2023-03-25 | 1200.53 | 30.01 | 2023-03-13 | 2 | 605.65 | 1 | 1200.53 | 44 | SO48311 | 2023-03-20 | 96.04 | 1211.30 | 600.26 |
SO44547_1 | 801C-4288-87 | PO4901179982 | 19 | 284 | 262 | 84 | 6 | 2022-02-23 | 367.88 | 9.20 | 2022-02-11 | 2 | 181.49 | 1 | 367.88 | 1 | SO44547 | 2022-02-18 | 29.43 | 362.97 | 183.94 |
SO59021_16 | A306-4E83-B7 | PO7395154426 | 100 | 286 | 512 | 542 | 1 | 2024-03-24 | 873.82 | 21.85 | 2024-03-12 | 4 | 199.38 | 1 | 873.82 | 16 | SO59021 | 2024-03-19 | 69.91 | 797.50 | 218.45 |
SO67284_9 | 8286-4B8D-89 | PO11484111023 | 100 | 283 | 400 | 594 | 2 | 2024-07-24 | 37.15 | 0.93 | 2024-07-12 | 1 | 27.49 | 1 | 37.15 | 9 | SO67284 | 2024-07-19 | 2.97 | 27.49 | 37.15 |
SO51084_13 | 3C77-43D1-83 | PO19575195218 | 98 | 288 | 574 | 34 | 10 | 2023-10-23 | 2860.88 | 71.52 | 2023-10-11 | 2 | 1481.94 | 1 | 2860.88 | 13 | SO51084 | 2023-10-18 | 228.87 | 2963.88 | 1430.44 |
SO69465_27 | B8B2-4B14-99 | PO2842153886 | 100 | 285 | 584 | 700 | 5 | 2024-08-23 | 1619.97 | 40.50 | 2024-08-11 | 5 | 343.65 | 1 | 1619.97 | 27 | SO69465 | 2024-08-18 | 129.60 | 1718.25 | 323.99 |
SO51774_9 | 30BA-400A-89 | PO2668194455 | 100 | 292 | 524 | 535 | 7 | 2023-11-23 | 316.86 | 7.92 | 2023-11-11 | 2 | 144.59 | 1 | 316.86 | 9 | SO51774 | 2023-11-18 | 25.35 | 289.19 | 158.43 |
SO46972_32 | 1A21-419F-8D | PO14500164221 | 100 | 282 | 305 | 650 | 1 | 2022-11-23 | 736.15 | 18.40 | 2022-11-11 | 1 | 653.70 | 1 | 736.15 | 32 | SO46972 | 2022-11-18 | 58.89 | 653.70 | 736.15 |
SO58981_51 | 2B52-4247-AF | PO18299143459 | 19 | 291 | 483 | 118 | 6 | 2024-03-24 | 576.00 | 14.40 | 2024-03-12 | 8 | 44.88 | 1 | 576.00 | 51 | SO58981 | 2024-03-19 | 46.08 | 359.04 | 72.00 |
SO44097_7 | 0F82-4F60-8B | PO14268131774 | 100 | 283 | 324 | 418 | 3 | 2021-12-24 | 419.46 | 10.49 | 2021-12-12 | 1 | 413.15 | 1 | 419.46 | 7 | SO44097 | 2021-12-19 | 33.56 | 413.15 | 419.46 |
SO45813_14 | 36A5-446C-96 | PO7859120230 | 100 | 287 | 272 | 221 | 4 | 2022-07-24 | 367.88 | 9.20 | 2022-07-12 | 2 | 181.49 | 1 | 367.88 | 14 | SO45813 | 2022-07-19 | 29.43 | 362.97 | 183.94 |
SO71784_2 | B186-4413-B4 | PO19285135919 | 98 | 288 | 492 | 448 | 10 | 2024-09-23 | 4818.77 | 120.47 | 2024-09-11 | 8 | 601.74 | 1 | 4818.77 | 2 | SO71784 | 2024-09-18 | 385.50 | 4813.95 | 602.35 |
SO51735_29 | 6E95-4EE8-92 | PO13456167695 | 36 | 292 | 503 | 614 | 7 | 2023-11-23 | 1400.36 | 35.01 | 2023-11-11 | 7 | 199.85 | 1 | 1400.36 | 29 | SO51735 | 2023-11-18 | 112.03 | 1398.96 | 200.05 |
SO50281_3 | 165A-47D3-A3 | PO8584140957 | 98 | 288 | 458 | 592 | 10 | 2023-08-23 | 44.99 | 1.12 | 2023-08-11 | 1 | 30.93 | 1 | 44.99 | 3 | SO50281 | 2023-08-18 | 3.60 | 30.93 | 44.99 |
SO55287_20 | 4BBD-4DA3-AD | PO13862128497 | 19 | 291 | 511 | 119 | 6 | 2024-01-23 | 218.45 | 5.46 | 2024-01-11 | 1 | 199.38 | 1 | 218.45 | 20 | SO55287 | 2024-01-18 | 17.48 | 199.38 | 218.45 |
SO48009_4 | C43C-4314-86 | PO12731113176 | 36 | 292 | 458 | 247 | 7 | 2023-02-23 | 134.98 | 3.37 | 2023-02-11 | 3 | 30.93 | 1 | 134.98 | 4 | SO48009 | 2023-02-18 | 10.80 | 92.80 | 44.99 |
SO51856_7 | E170-419C-92 | PO3654183134 | 100 | 281 | 558 | 435 | 4 | 2023-11-23 | 485.99 | 12.15 | 2023-11-11 | 2 | 179.82 | 1 | 485.99 | 7 | SO51856 | 2023-11-18 | 38.88 | 359.63 | 242.99 |
SO51774_24 | 30BA-400A-89 | PO2668194455 | 100 | 292 | 290 | 535 | 7 | 2023-11-23 | 1637.40 | 40.94 | 2023-11-11 | 2 | 747.20 | 1 | 1637.40 | 24 | SO51774 | 2023-11-18 | 130.99 | 1494.40 | 818.70 |
SO69509_2 | 3683-45BF-B7 | PO4611111760 | 100 | 287 | 496 | 131 | 4 | 2024-08-23 | 1807.04 | 45.18 | 2024-08-11 | 3 | 601.74 | 1 | 1807.04 | 2 | SO69509 | 2024-08-18 | 144.56 | 1805.23 | 602.35 |
SO71933_17 | 11D0-4CAD-81 | PO8033133106 | 6 | 296 | 603 | 15 | 9 | 2024-09-23 | 145.79 | 3.64 | 2024-09-11 | 2 | 53.94 | 1 | 145.79 | 17 | SO71933 | 2024-09-18 | 11.66 | 107.88 | 72.89 |
SO71780_25 | 36CB-4A10-92 | PO19604173239 | 98 | 288 | 402 | 340 | 10 | 2024-09-23 | 72.16 | 1.80 | 2024-09-11 | 1 | 53.40 | 1 | 72.16 | 25 | SO71780 | 2024-09-18 | 5.77 | 53.40 | 72.16 |
Generated 2024-11-10 08:00:16.999 UTC