[ROOT] dt FactResellerSale < WHERE DimProductId EQ ALL SHUFFLE SKIP 2000 < SKIP 375 > < TAKE 31 >
31 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 |
---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
SO53471_3 | 7B7E-4C32-B2 | PO16994189676 | 100 | 283 | 581 | 306 | 3 | 2023-11-02 | 1020.59 | 25.51 | 2023-10-21 | 1 | 1082.51 | 1 | 1020.59 | 3 | SO53471 | 2023-10-28 | 81.65 | 1082.51 | 1020.59 | |||
SO57131_15 | 635E-4BF2-B9 | PO4611148036 | 100 | 287 | 569 | 131 | 4 | 2024-01-02 | 1336.23 | 33.41 | 2023-12-21 | 3 | 461.44 | 1 | 1336.23 | 15 | SO57131 | 2023-12-28 | 106.90 | 1384.33 | 445.41 | |||
SO69542_25 | 990B-4CF0-A7 | PO1827116485 | 19 | 291 | 217 | 317 | 6 | 2024-07-02 | 20.99 | 0.52 | 2024-06-20 | 1 | 13.09 | 1 | 20.99 | 25 | SO69542 | 2024-06-27 | 1.68 | 13.09 | 20.99 | |||
SO50662_5 | 2ABC-4DD7-A1 | PO19604139855 | 98 | 288 | 362 | 340 | 10 | 2023-08-02 | 2458.92 | 61.47 | 2023-07-21 | 2 | 1105.81 | 1 | 2458.92 | 5 | SO50662 | 2023-07-28 | 196.71 | 2211.62 | 1229.46 | |||
SO51102_6 | F2B1-4561-84 | PO13659193365 | 100 | 287 | 590 | 437 | 4 | 2023-09-01 | 461.69 | 11.54 | 2023-08-20 | 1 | 419.78 | 1 | 461.69 | 6 | SO51102 | 2023-08-27 | 36.94 | 419.78 | 461.69 | |||
SO61199_21 | EFA0-4D12-A2 | PO2552199779 | 100 | 286 | 361 | 2 | 506 | 1 | 319.46 | 2024-03-03 | 15973.13 | 391.34 | 2024-02-20 | 12 | 1251.98 | 1 | 15653.67 | 21 | SO61199 | 2024-02-27 | 1252.29 | 15023.78 | 1331.09 | 0.02 |
SO49836_20 | 0E32-48F7-89 | PO12644185975 | 100 | 285 | 233 | 530 | 5 | 2023-06-02 | 115.36 | 2.88 | 2023-05-21 | 4 | 29.08 | 1 | 115.36 | 20 | SO49836 | 2023-05-28 | 9.23 | 116.32 | 28.84 | |||
SO55297_3 | 2455-4B60-A5 | PO4495126679 | 19 | 291 | 467 | 496 | 6 | 2023-12-02 | 73.47 | 1.84 | 2023-11-20 | 5 | 9.16 | 1 | 73.47 | 3 | SO55297 | 2023-11-27 | 5.88 | 45.80 | 14.69 | |||
SO49524_5 | 62E9-414A-91 | PO4089179431 | 100 | 285 | 358 | 368 | 5 | 2023-05-02 | 1229.46 | 30.74 | 2023-04-20 | 1 | 1105.81 | 1 | 1229.46 | 5 | SO49524 | 2023-04-27 | 98.36 | 1105.81 | 1229.46 | |||
SO43862_1 | 68A2-4B5C-A7 | PO16211194171 | 100 | 285 | 344 | 99 | 5 | 2021-10-02 | 8159.98 | 204.00 | 2021-09-20 | 4 | 1912.15 | 1 | 8159.98 | 1 | SO43862 | 2021-09-27 | 652.80 | 7648.62 | 2039.99 | |||
SO58948_7 | 1534-4AB5-81 | PO11774195497 | 6 | 296 | 484 | 682 | 9 | 2024-02-01 | 14.31 | 0.36 | 2024-01-20 | 3 | 2.97 | 1 | 14.31 | 7 | SO58948 | 2024-01-27 | 1.14 | 8.92 | 4.77 | |||
SO44114_8 | 3082-4C08-AA | PO3190199320 | 100 | 281 | 342 | 575 | 2 | 2021-11-02 | 2936.21 | 73.41 | 2021-10-21 | 7 | 413.15 | 1 | 2936.21 | 8 | SO44114 | 2021-10-28 | 234.90 | 2892.02 | 419.46 | |||
SO65278_10 | 5822-4DF1-92 | PO5017152408 | 100 | 289 | 564 | 2 | 308 | 1 | 304.21 | 2024-05-02 | 15210.37 | 372.65 | 2024-04-20 | 11 | 1481.94 | 1 | 14906.16 | 10 | SO65278 | 2024-04-27 | 1192.49 | 16301.32 | 1382.76 | 0.02 |
SO69454_20 | 0211-4E7F-80 | PO580171630 | 36 | 295 | 503 | 230 | 8 | 2024-07-02 | 400.10 | 10.00 | 2024-06-20 | 2 | 199.85 | 1 | 400.10 | 20 | SO69454 | 2024-06-27 | 32.01 | 399.70 | 200.05 | |||
SO55254_28 | BFF6-440D-80 | PO12441172246 | 36 | 295 | 576 | 302 | 8 | 2023-12-02 | 4291.33 | 107.28 | 2023-11-20 | 3 | 1481.94 | 1 | 4291.33 | 28 | SO55254 | 2023-11-27 | 343.31 | 4445.81 | 1430.44 | |||
SO49446_5 | 1C19-4187-94 | PO20213185083 | 100 | 283 | 333 | 216 | 2 | 2023-05-02 | 939.59 | 23.49 | 2023-04-20 | 2 | 486.71 | 1 | 939.59 | 5 | SO49446 | 2023-04-27 | 75.17 | 973.41 | 469.79 | |||
SO61209_15 | C31E-48AE-AF | PO11484136165 | 100 | 283 | 594 | 594 | 2 | 2024-03-03 | 677.99 | 16.95 | 2024-02-20 | 2 | 308.22 | 1 | 677.99 | 15 | SO61209 | 2024-02-27 | 54.24 | 616.44 | 338.99 | |||
SO53527_17 | 0EBE-4ACB-B5 | PO1798140946 | 19 | 291 | 588 | 10 | 6 | 2023-11-02 | 1846.78 | 46.17 | 2023-10-21 | 4 | 419.78 | 1 | 1846.78 | 17 | SO53527 | 2023-10-28 | 147.74 | 1679.11 | 461.69 | |||
SO63127_9 | BC04-42FB-8F | PO19227167253 | 19 | 284 | 482 | 210 | 6 | 2024-04-03 | 10.79 | 0.27 | 2024-03-22 | 2 | 3.36 | 1 | 10.79 | 9 | SO63127 | 2024-03-29 | 0.86 | 6.72 | 5.39 | |||
SO46107_14 | 75E6-43D6-92 | PO8874169089 | 100 | 282 | 220 | 348 | 3 | 2022-07-02 | 80.75 | 2.02 | 2022-06-20 | 4 | 12.03 | 1 | 80.75 | 14 | SO46107 | 2022-06-27 | 6.46 | 48.11 | 20.19 | |||
SO48306_34 | EA27-471A-9D | PO17574166075 | 19 | 291 | 393 | 678 | 6 | 2023-02-01 | 963.86 | 24.10 | 2023-01-20 | 7 | 101.89 | 1 | 963.86 | 34 | SO48306 | 2023-01-27 | 77.11 | 713.26 | 137.69 | |||
SO49498_6 | D9E7-4090-86 | PO16472151816 | 100 | 287 | 445 | 239 | 4 | 2023-05-02 | 107.98 | 2.70 | 2023-04-20 | 3 | 24.75 | 1 | 107.98 | 6 | SO49498 | 2023-04-27 | 8.64 | 74.24 | 35.99 | |||
SO51720_45 | E39F-4680-AC | PO15370128892 | 100 | 281 | 526 | 381 | 3 | 2023-10-02 | 475.29 | 11.88 | 2023-09-20 | 3 | 144.59 | 1 | 475.29 | 45 | SO51720 | 2023-09-27 | 38.02 | 433.78 | 158.43 | |||
SO43871_5 | 01F1-4AD5-A5 | PO13572145817 | 100 | 287 | 319 | 527 | 3 | 2021-10-02 | 874.79 | 21.87 | 2021-09-20 | 1 | 884.71 | 1 | 874.79 | 5 | SO43871 | 2021-09-27 | 69.98 | 884.71 | 874.79 | |||
SO71918_12 | 72E2-4769-B8 | PO1131159056 | 36 | 295 | 577 | 536 | 8 | 2024-08-02 | 5102.37 | 127.56 | 2024-07-21 | 7 | 755.15 | 1 | 5102.37 | 12 | SO71918 | 2024-07-28 | 408.19 | 5286.06 | 728.91 | |||
SO46359_3 | 95FD-4612-88 | PO1740167502 | 19 | 288 | 330 | 460 | 6 | 2022-08-02 | 838.92 | 20.97 | 2022-07-21 | 2 | 413.15 | 1 | 838.92 | 3 | SO46359 | 2022-07-28 | 67.11 | 826.29 | 419.46 | |||
SO51721_13 | 9429-430D-89 | PO14500124798 | 100 | 282 | 484 | 3 | 650 | 1 | 3.50 | 2023-10-02 | 69.96 | 1.66 | 2023-09-20 | 16 | 2.97 | 1 | 66.46 | 13 | SO51721 | 2023-09-27 | 5.32 | 47.57 | 4.37 | 0.05 |
SO50259_45 | 2D7F-444F-AE | PO18386133550 | 100 | 283 | 263 | 558 | 2 | 2023-07-02 | 404.66 | 10.12 | 2023-06-20 | 2 | 187.16 | 1 | 404.66 | 45 | SO50259 | 2023-06-27 | 32.37 | 374.31 | 202.33 | |||
SO49833_31 | 595A-4EFA-AC | PO13340158028 | 100 | 292 | 358 | 355 | 7 | 2023-06-02 | 6147.29 | 153.68 | 2023-05-21 | 5 | 1105.81 | 1 | 6147.29 | 31 | SO49833 | 2023-05-28 | 491.78 | 5529.05 | 1229.46 | |||
SO48026_19 | E497-4BCF-A5 | PO10121196875 | 100 | 281 | 385 | 684 | 2 | 2023-01-02 | 600.26 | 15.01 | 2022-12-21 | 1 | 605.65 | 1 | 600.26 | 19 | SO48026 | 2022-12-28 | 48.02 | 605.65 | 600.26 | |||
SO49481_32 | 474A-4DD1-9B | PO10701112208 | 100 | 282 | 469 | 133 | 4 | 2023-05-02 | 91.18 | 2.28 | 2023-04-20 | 4 | 15.67 | 1 | 91.18 | 32 | SO49481 | 2023-04-27 | 7.29 | 62.68 | 22.79 |
Generated 2024-09-19 21:08:37.219 UTC