[ROOT] dt FactResellerSale < WHERE DimProductId EQ ALL SHUFFLE < SKIP 1847 > < 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 |
---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
SO61229_8 | AC88-46DA-A3 | PO10324197030 | 98 | 288 | 524 | 196 | 10 | 2024-03-04 | 158.43 | 3.96 | 2024-02-21 | 1 | 144.59 | 1 | 158.43 | 8 | SO61229 | 2024-02-28 | 12.67 | 144.59 | 158.43 | |||
SO51112_2 | 6C36-4086-8D | PO11687117332 | 100 | 283 | 572 | 13 | 691 | 2 | 100.22 | 2023-09-02 | 668.12 | 14.20 | 2023-08-21 | 2 | 461.44 | 1 | 567.90 | 2 | SO51112 | 2023-08-28 | 45.43 | 922.89 | 334.06 | 0.15 |
SO63285_9 | 6316-44BB-8E | PO3480176259 | 100 | 281 | 222 | 436 | 4 | 2024-04-04 | 20.99 | 0.52 | 2024-03-23 | 1 | 13.09 | 1 | 20.99 | 9 | SO63285 | 2024-03-30 | 1.68 | 13.09 | 20.99 | |||
SO71795_9 | 5843-4E7D-8D | PO17371184627 | 6 | 296 | 556 | 688 | 9 | 2024-08-03 | 105.29 | 2.63 | 2024-07-22 | 1 | 77.92 | 1 | 105.29 | 9 | SO71795 | 2024-07-29 | 8.42 | 77.92 | 105.29 | |||
SO48292_7 | 7546-4477-B2 | PO19633112676 | 100 | 287 | 456 | 149 | 3 | 2023-02-02 | 269.96 | 6.75 | 2023-01-21 | 6 | 30.93 | 1 | 269.96 | 7 | SO48292 | 2023-01-28 | 21.60 | 185.60 | 44.99 | |||
SO47670_23 | 0CD2-463E-8F | PO14732184884 | 19 | 291 | 417 | 514 | 6 | 2022-12-03 | 1297.81 | 32.45 | 2022-11-21 | 4 | 300.12 | 1 | 1297.81 | 23 | SO47670 | 2022-11-28 | 103.82 | 1200.48 | 324.45 | |||
SO67287_27 | 3F1F-44DB-96 | PO10730119334 | 100 | 287 | 465 | 491 | 4 | 2024-06-03 | 58.78 | 1.47 | 2024-05-22 | 4 | 9.16 | 1 | 58.78 | 27 | SO67287 | 2024-05-29 | 4.70 | 36.64 | 14.69 | |||
SO71947_39 | 7269-4186-92 | PO9628115897 | 100 | 283 | 471 | 179 | 2 | 2024-08-03 | 190.50 | 4.76 | 2024-07-22 | 5 | 23.75 | 1 | 190.50 | 39 | SO71947 | 2024-07-29 | 15.24 | 118.75 | 38.10 | |||
SO46385_30 | F727-48F0-AF | PO9483110086 | 100 | 281 | 340 | 54 | 2 | 2022-08-03 | 838.92 | 20.97 | 2022-07-22 | 2 | 413.15 | 1 | 838.92 | 30 | SO46385 | 2022-07-29 | 67.11 | 826.29 | 419.46 | |||
SO45272_2 | 72C5-49C2-BA | PO19227144019 | 19 | 284 | 324 | 210 | 6 | 2022-04-05 | 419.46 | 10.49 | 2022-03-24 | 1 | 413.15 | 1 | 419.46 | 2 | SO45272 | 2022-03-31 | 33.56 | 413.15 | 419.46 | |||
SO57022_10 | 9202-4FEB-88 | PO17806175482 | 19 | 291 | 225 | 101 | 6 | 2024-01-03 | 10.79 | 0.27 | 2023-12-22 | 2 | 6.92 | 1 | 10.79 | 10 | SO57022 | 2023-12-29 | 0.86 | 13.84 | 5.39 | |||
SO51156_4 | C598-4D75-B4 | PO4930142451 | 19 | 291 | 476 | 425 | 6 | 2023-09-02 | 251.96 | 6.30 | 2023-08-21 | 6 | 26.18 | 1 | 251.96 | 4 | SO51156 | 2023-08-28 | 20.16 | 157.06 | 41.99 | |||
SO61248_28 | 67A0-4D10-87 | PO4495126386 | 19 | 291 | 234 | 496 | 6 | 2024-03-04 | 59.99 | 1.50 | 2024-02-21 | 2 | 38.49 | 1 | 59.99 | 28 | SO61248 | 2024-02-28 | 4.80 | 76.98 | 29.99 | |||
SO51716_12 | 232B-4C4C-97 | PO15283150425 | 100 | 281 | 586 | 13 | 363 | 3 | 200.43 | 2023-10-03 | 1336.23 | 28.39 | 2023-09-21 | 4 | 461.44 | 1 | 1135.80 | 12 | SO51716 | 2023-09-28 | 90.86 | 1845.78 | 334.06 | 0.15 |
SO69406_12 | E101-486C-A5 | PO16675181672 | 100 | 293 | 585 | 361 | 1 | 2024-07-03 | 1336.23 | 33.41 | 2024-06-21 | 3 | 461.44 | 1 | 1336.23 | 12 | SO69406 | 2024-06-28 | 106.90 | 1384.33 | 445.41 | |||
SO67298_10 | F9FB-4B4C-92 | PO2755196827 | 100 | 282 | 493 | 205 | 4 | 2024-06-03 | 800.21 | 20.01 | 2024-05-22 | 4 | 199.85 | 1 | 800.21 | 10 | SO67298 | 2024-05-29 | 64.02 | 799.41 | 200.05 | |||
SO51111_30 | 5E49-4F77-BB | PO11484190487 | 100 | 283 | 476 | 3 | 594 | 2 | 32.72 | 2023-09-02 | 654.41 | 15.54 | 2023-08-21 | 17 | 26.18 | 1 | 621.69 | 30 | SO51111 | 2023-08-28 | 49.73 | 445.00 | 38.49 | 0.05 |
SO43681_7 | 6D51-449D-B3 | PO1189177803 | 100 | 285 | 342 | 423 | 5 | 2021-09-02 | 1258.38 | 31.46 | 2021-08-21 | 3 | 413.15 | 1 | 1258.38 | 7 | SO43681 | 2021-08-28 | 100.67 | 1239.44 | 419.46 | |||
SO57081_5 | 2D14-4C3F-AB | PO1247134214 | 100 | 285 | 594 | 296 | 5 | 2024-01-03 | 1355.98 | 33.90 | 2023-12-22 | 4 | 308.22 | 1 | 1355.98 | 5 | SO57081 | 2023-12-29 | 108.48 | 1232.87 | 338.99 | |||
SO57082_13 | F79A-40C3-B7 | PO1595152621 | 19 | 284 | 376 | 426 | 6 | 2024-01-03 | 2932.02 | 73.30 | 2023-12-22 | 2 | 1554.95 | 1 | 2932.02 | 13 | SO57082 | 2023-12-29 | 234.56 | 3109.90 | 1466.01 | |||
SO47042_44 | 42DB-4E2E-B9 | PO5858114009 | 100 | 285 | 397 | 566 | 5 | 2022-10-03 | 24.29 | 0.61 | 2022-09-21 | 1 | 17.98 | 1 | 24.29 | 44 | SO47042 | 2022-09-28 | 1.94 | 17.98 | 24.29 | |||
SO44756_10 | 7857-4221-BA | PO15138192148 | 100 | 283 | 212 | 93 | 4 | 2022-02-02 | 20.19 | 0.50 | 2022-01-21 | 1 | 12.03 | 1 | 20.19 | 10 | SO44756 | 2022-01-28 | 1.61 | 12.03 | 20.19 | |||
SO57020_1 | 958C-4604-A0 | PO19140164267 | 36 | 295 | 384 | 681 | 8 | 2024-01-03 | 672.29 | 16.81 | 2023-12-22 | 1 | 713.08 | 2 | 672.29 | 1 | SO57020 | 2023-12-29 | 53.78 | 713.08 | 672.29 | |||
SO46953_32 | C650-4C32-BE | PO17603154442 | 19 | 284 | 286 | 12 | 6 | 2022-10-03 | 1287.57 | 32.19 | 2022-09-21 | 7 | 170.14 | 1 | 1287.57 | 32 | SO46953 | 2022-09-28 | 103.01 | 1191.00 | 183.94 | |||
SO48321_28 | FA9B-4026-BF | PO14790154902 | 19 | 291 | 401 | 497 | 6 | 2023-02-02 | 131.20 | 3.28 | 2023-01-21 | 2 | 48.55 | 1 | 131.20 | 28 | SO48321 | 2023-01-28 | 10.50 | 97.09 | 65.60 | |||
SO46974_26 | BEE6-4EC8-8E | PO14442112586 | 100 | 286 | 360 | 127 | 1 | 2022-10-03 | 6147.29 | 153.68 | 2022-09-21 | 5 | 1105.81 | 1 | 6147.29 | 26 | SO46974 | 2022-09-28 | 491.78 | 5529.05 | 1229.46 | |||
SO47365_44 | 4535-457B-B0 | PO17574153673 | 19 | 291 | 466 | 678 | 6 | 2022-11-03 | 56.52 | 1.41 | 2022-10-22 | 4 | 9.71 | 1 | 56.52 | 44 | SO47365 | 2022-10-29 | 4.52 | 38.85 | 14.13 | |||
SO46608_45 | ACF1-4852-B7 | PO18473177913 | 19 | 291 | 364 | 442 | 6 | 2022-09-02 | 1295.99 | 32.40 | 2022-08-21 | 2 | 598.44 | 1 | 1295.99 | 45 | SO46608 | 2022-08-28 | 103.68 | 1196.87 | 647.99 |
Generated 2024-09-20 11:26:34.819 UTC