[ROOT] dt FactResellerSale < WHERE DimSalesTerritoryId EQ '4' > SHUFFLE < SKIP 6969 > < 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 |
---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
SO48384_19 | C99C-4AEC-9E | PO7569115185 | 100 | 287 | 391 | 608 | 4 | 2023-03-25 | 88.93 | 2.22 | 2023-03-13 | 1 | 65.81 | 1 | 88.93 | 19 | SO48384 | 2023-03-20 | 7.11 | 65.81 | 88.93 | |||
SO43872_16 | 52FF-45CD-9B | PO12557127067 | 100 | 282 | 223 | 240 | 4 | 2021-11-23 | 20.75 | 0.52 | 2021-11-11 | 4 | 5.71 | 1 | 20.75 | 16 | SO43872 | 2021-11-18 | 1.66 | 22.82 | 5.19 | |||
SO44520_28 | 5BE0-436B-8C | PO12499152870 | 100 | 282 | 262 | 78 | 4 | 2022-02-23 | 551.81 | 13.80 | 2022-02-11 | 3 | 181.49 | 1 | 551.81 | 28 | SO44520 | 2022-02-18 | 44.15 | 544.46 | 183.94 | |||
SO71848_4 | 7082-4BF5-AB | PO18763153352 | 100 | 287 | 565 | 59 | 4 | 2024-09-23 | 890.82 | 22.27 | 2024-09-11 | 2 | 461.44 | 1 | 890.82 | 4 | SO71848 | 2024-09-18 | 71.27 | 922.89 | 445.41 | |||
SO51764_14 | D5EC-49D5-9F | PO609164065 | 100 | 282 | 491 | 492 | 4 | 2023-11-23 | 226.76 | 5.67 | 2023-11-11 | 7 | 41.57 | 1 | 226.76 | 14 | SO51764 | 2023-11-18 | 18.14 | 291.01 | 32.39 | |||
SO50272_3 | E0A6-4CFA-90 | PO11745174916 | 100 | 282 | 327 | 97 | 4 | 2023-08-23 | 469.79 | 11.74 | 2023-08-11 | 1 | 486.71 | 1 | 469.79 | 3 | SO50272 | 2023-08-18 | 37.58 | 486.71 | 469.79 | |||
SO46648_39 | 2073-4051-9E | PO2494191557 | 100 | 283 | 362 | 184 | 4 | 2022-10-23 | 3688.38 | 92.21 | 2022-10-11 | 3 | 1105.81 | 1 | 3688.38 | 39 | SO46648 | 2022-10-18 | 295.07 | 3317.43 | 1229.46 | |||
SO49538_25 | CB52-4E7E-9B | PO6786132021 | 100 | 281 | 233 | 3 | 4 | 2023-06-23 | 115.36 | 2.88 | 2023-06-11 | 4 | 29.08 | 1 | 115.36 | 25 | SO49538 | 2023-06-18 | 9.23 | 116.32 | 28.84 | |||
SO46668_13 | 6711-47BE-BF | PO7859142972 | 100 | 287 | 466 | 221 | 4 | 2022-10-23 | 56.52 | 1.41 | 2022-10-11 | 4 | 9.71 | 1 | 56.52 | 13 | SO46668 | 2022-10-18 | 4.52 | 38.85 | 14.13 | |||
SO49832_16 | 3280-41FF-A3 | PO13659150841 | 100 | 287 | 411 | 437 | 4 | 2023-07-24 | 250.83 | 6.27 | 2023-07-12 | 2 | 92.81 | 1 | 250.83 | 16 | SO49832 | 2023-07-19 | 20.07 | 185.61 | 125.42 | |||
SO51714_33 | D33A-4EAE-B1 | PO15689195197 | 100 | 281 | 384 | 328 | 4 | 2023-11-23 | 2016.88 | 50.42 | 2023-11-11 | 3 | 713.08 | 1 | 2016.88 | 33 | SO51714 | 2023-11-18 | 161.35 | 2139.24 | 672.29 | |||
SO50724_17 | E9DD-40CA-B2 | PO9686154363 | 100 | 282 | 399 | 457 | 4 | 2023-09-23 | 135.10 | 3.38 | 2023-09-11 | 4 | 24.99 | 1 | 135.10 | 17 | SO50724 | 2023-09-18 | 10.81 | 99.97 | 33.77 | |||
SO55264_20 | 80F3-4A7B-A2 | PO10730163005 | 100 | 287 | 606 | 491 | 4 | 2024-01-23 | 971.98 | 24.30 | 2024-01-11 | 3 | 343.65 | 1 | 971.98 | 20 | SO55264 | 2024-01-18 | 77.76 | 1030.95 | 323.99 | |||
SO50292_8 | E329-4164-85 | PO3654177485 | 100 | 281 | 297 | 435 | 4 | 2023-08-23 | 1472.29 | 36.81 | 2023-08-11 | 2 | 653.70 | 1 | 1472.29 | 8 | SO50292 | 2023-08-18 | 117.78 | 1307.39 | 736.15 | |||
SO50249_8 | 72CA-4901-8D | PO2320117235 | 100 | 282 | 385 | 529 | 4 | 2023-08-23 | 1800.79 | 45.02 | 2023-08-11 | 3 | 605.65 | 1 | 1800.79 | 8 | SO50249 | 2023-08-18 | 144.06 | 1816.95 | 600.26 | |||
SO69441_11 | F156-4EE0-B0 | PO11745165450 | 100 | 282 | 580 | 97 | 4 | 2024-08-23 | 4082.38 | 102.06 | 2024-08-11 | 4 | 1082.51 | 1 | 4082.38 | 11 | SO69441 | 2024-08-18 | 326.59 | 4330.04 | 1020.59 | |||
SO43873_20 | 494C-48D2-BD | PO12499138177 | 100 | 282 | 324 | 78 | 4 | 2021-11-23 | 2516.75 | 62.92 | 2021-11-11 | 6 | 413.15 | 1 | 2516.75 | 20 | SO43873 | 2021-11-18 | 201.34 | 2478.88 | 419.46 | |||
SO49515_2 | 52D0-4584-BC | PO9715144044 | 100 | 281 | 421 | 490 | 4 | 2023-06-23 | 392.66 | 9.82 | 2023-06-11 | 2 | 145.28 | 1 | 392.66 | 2 | SO49515 | 2023-06-18 | 31.41 | 290.57 | 196.33 | |||
SO46642_29 | 0A4E-465C-BB | PO551133122 | 100 | 283 | 407 | 4 | 4 | 2022-10-23 | 131.20 | 3.28 | 2022-10-11 | 2 | 48.55 | 1 | 131.20 | 29 | SO46642 | 2022-10-18 | 10.50 | 97.09 | 65.60 | |||
SO46660_19 | CF24-45E2-9D | PO5626129733 | 100 | 283 | 325 | 166 | 4 | 2022-10-23 | 2818.76 | 70.47 | 2022-10-11 | 6 | 486.71 | 1 | 2818.76 | 19 | SO46660 | 2022-10-18 | 225.50 | 2920.24 | 469.79 | |||
SO48341_36 | A747-471B-97 | PO10701176180 | 100 | 282 | 459 | 133 | 4 | 2023-03-25 | 539.94 | 13.50 | 2023-03-13 | 10 | 37.12 | 1 | 539.94 | 36 | SO48341 | 2023-03-20 | 43.20 | 371.21 | 53.99 | |||
SO51090_62 | EBDE-4A71-8E | PO13688110947 | 100 | 282 | 597 | 475 | 4 | 2023-10-23 | 971.98 | 24.30 | 2023-10-11 | 3 | 294.58 | 1 | 971.98 | 62 | SO51090 | 2023-10-18 | 77.76 | 883.74 | 323.99 | |||
SO71783_33 | 7E03-4B8A-BA | PO19343113609 | 100 | 282 | 440 | 24 | 4 | 2024-09-23 | 3435.60 | 85.89 | 2024-09-11 | 4 | 868.63 | 1 | 3435.60 | 33 | SO71783 | 2024-09-18 | 274.85 | 3474.54 | 858.90 | |||
SO65157_13 | 51FF-4A62-89 | PO19372154832 | 100 | 282 | 471 | 582 | 4 | 2024-06-23 | 152.40 | 3.81 | 2024-06-11 | 4 | 23.75 | 1 | 152.40 | 13 | SO65157 | 2024-06-18 | 12.19 | 95.00 | 38.10 | |||
SO67274_24 | EAF2-43E4-AB | PO13659172775 | 100 | 287 | 532 | 437 | 4 | 2024-07-24 | 149.87 | 3.75 | 2024-07-12 | 1 | 136.79 | 1 | 149.87 | 24 | SO67274 | 2024-07-19 | 11.99 | 136.79 | 149.87 | |||
SO67273_16 | 9BAE-4E69-B9 | PO13688176638 | 100 | 282 | 533 | 475 | 4 | 2024-07-24 | 449.62 | 11.24 | 2024-07-12 | 3 | 136.79 | 1 | 449.62 | 16 | SO67273 | 2024-07-19 | 35.97 | 410.36 | 149.87 | |||
SO51827_8 | B106-4221-AD | PO4611117026 | 100 | 287 | 552 | 131 | 4 | 2023-11-23 | 109.79 | 2.74 | 2023-11-11 | 2 | 40.62 | 1 | 109.79 | 8 | SO51827 | 2023-11-18 | 8.78 | 81.24 | 54.89 | |||
SO71952_31 | 9490-4552-81 | PO9715163911 | 100 | 281 | 400 | 490 | 4 | 2024-09-23 | 260.06 | 6.50 | 2024-09-11 | 7 | 27.49 | 1 | 260.06 | 31 | SO71952 | 2024-09-18 | 20.81 | 192.45 | 37.15 | |||
SO55235_2 | CE6C-41A5-91 | PO20126150960 | 100 | 282 | 513 | 421 | 4 | 2024-01-23 | 436.91 | 10.92 | 2024-01-11 | 2 | 199.38 | 1 | 436.91 | 2 | SO55235 | 2024-01-18 | 34.95 | 398.75 | 218.45 | |||
SO51131_23 | D489-4DF3-A2 | PO16298169856 | 100 | 287 | 499 | 3 | 599 | 4 | 634.97 | 2023-10-23 | 12699.46 | 301.61 | 2023-10-11 | 23 | 601.74 | 1 | 12064.49 | 23 | SO51131 | 2023-10-18 | 965.16 | 13840.11 | 552.15 | 0.05 |
SO57085_10 | D1E5-454C-85 | PO2523188219 | 100 | 287 | 487 | 167 | 4 | 2024-02-23 | 98.98 | 2.47 | 2024-02-11 | 3 | 20.57 | 1 | 98.98 | 10 | SO57085 | 2024-02-18 | 7.92 | 61.70 | 32.99 |
Generated 2024-11-10 08:58:23.373 UTC