[ROOT] dt FactResellerSale < WHERE DimSalesTerritoryId EQ '4' > SHUFFLE < SKIP 849 > < 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 |
---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
SO49523_28 | 852E-47A8-A9 | PO3915144057 | 100 | 281 | 213 | 130 | 4 | 2023-06-26 | 40.37 | 1.01 | 2023-06-14 | 2 | 13.88 | 1 | 40.37 | 28 | SO49523 | 2023-06-21 | 3.23 | 27.76 | 20.19 | |||
SO46660_16 | CF24-45E2-9D | PO5626129733 | 100 | 283 | 333 | 3 | 166 | 4 | 452.18 | 2022-10-26 | 9043.53 | 214.78 | 2022-10-14 | 21 | 486.71 | 1 | 8591.36 | 16 | SO46660 | 2022-10-21 | 687.31 | 10220.84 | 430.64 | 0.05 |
SO50753_8 | 8073-4F97-BA | PO7569170218 | 100 | 287 | 399 | 608 | 4 | 2023-09-26 | 33.77 | 0.84 | 2023-09-14 | 1 | 24.99 | 1 | 33.77 | 8 | SO50753 | 2023-09-21 | 2.70 | 24.99 | 33.77 | |||
SO69515_5 | D9C1-4837-A7 | PO6351170694 | 100 | 281 | 388 | 255 | 4 | 2024-08-26 | 672.29 | 16.81 | 2024-08-14 | 1 | 713.08 | 1 | 672.29 | 5 | SO69515 | 2024-08-21 | 53.78 | 713.08 | 672.29 | |||
SO44557_7 | 2D19-4C49-B1 | PO6351122593 | 100 | 283 | 313 | 255 | 4 | 2022-02-26 | 2146.96 | 53.67 | 2022-02-14 | 1 | 2171.29 | 1 | 2146.96 | 7 | SO44557 | 2022-02-21 | 171.76 | 2171.29 | 2146.96 | |||
SO51106_18 | 3D96-4D27-92 | PO12528166058 | 100 | 282 | 572 | 13 | 331 | 4 | 200.43 | 2023-10-26 | 1336.23 | 28.39 | 2023-10-14 | 4 | 461.44 | 1 | 1135.80 | 18 | SO51106 | 2023-10-21 | 90.86 | 1845.78 | 334.06 | 0.15 |
SO49515_3 | 52D0-4584-BC | PO9715144044 | 100 | 281 | 354 | 490 | 4 | 2023-06-26 | 3728.56 | 93.21 | 2023-06-14 | 3 | 1117.86 | 1 | 3728.56 | 3 | SO49515 | 2023-06-21 | 298.28 | 3353.57 | 1242.85 | |||
SO48384_3 | C99C-4AEC-9E | PO7569115185 | 100 | 287 | 289 | 608 | 4 | 2023-03-28 | 1488.55 | 37.21 | 2023-03-16 | 2 | 660.91 | 1 | 1488.55 | 3 | SO48384 | 2023-03-23 | 119.08 | 1321.83 | 744.27 | |||
SO53533_6 | B8B0-46C0-AF | PO18038134377 | 100 | 287 | 493 | 509 | 4 | 2023-12-27 | 400.10 | 10.00 | 2023-12-15 | 2 | 199.85 | 1 | 400.10 | 6 | SO53533 | 2023-12-22 | 32.01 | 399.70 | 200.05 | |||
SO46648_7 | 2073-4051-9E | PO2494191557 | 100 | 283 | 308 | 184 | 4 | 2022-10-26 | 3721.36 | 93.03 | 2022-10-14 | 5 | 660.91 | 1 | 3721.36 | 7 | SO46648 | 2022-10-21 | 297.71 | 3304.57 | 744.27 | |||
SO46988_11 | 2D2E-4EC3-AC | PO12499171502 | 100 | 282 | 325 | 78 | 4 | 2022-11-26 | 4228.15 | 105.70 | 2022-11-14 | 9 | 486.71 | 1 | 4228.15 | 11 | SO46988 | 2022-11-21 | 338.25 | 4380.36 | 469.79 | |||
SO51090_38 | EBDE-4A71-8E | PO13688110947 | 100 | 282 | 491 | 3 | 475 | 4 | 23.76 | 2023-10-26 | 475.11 | 11.28 | 2023-10-14 | 16 | 41.57 | 1 | 451.36 | 38 | SO51090 | 2023-10-21 | 36.11 | 665.16 | 29.69 | 0.05 |
SO53583_1 | 582E-4A53-9A | PO5597118655 | 100 | 281 | 501 | 75 | 4 | 2023-12-27 | 364.38 | 9.11 | 2023-12-15 | 5 | 53.93 | 1 | 364.38 | 1 | SO53583 | 2023-12-22 | 29.15 | 269.64 | 72.88 | |||
SO45291_10 | 3865-4B93-A6 | PO15689110696 | 100 | 283 | 324 | 328 | 4 | 2022-05-29 | 1258.38 | 31.46 | 2022-05-17 | 3 | 413.15 | 1 | 1258.38 | 10 | SO45291 | 2022-05-24 | 100.67 | 1239.44 | 419.46 | |||
SO55264_1 | 80F3-4A7B-A2 | PO10730163005 | 100 | 287 | 477 | 491 | 4 | 2024-01-26 | 11.98 | 0.30 | 2024-01-14 | 4 | 1.87 | 1 | 11.98 | 1 | SO55264 | 2024-01-21 | 0.96 | 7.47 | 2.99 | |||
SO67325_8 | 981F-41CE-8A | PO7859144943 | 100 | 287 | 436 | 221 | 4 | 2024-07-27 | 713.80 | 17.84 | 2024-07-15 | 2 | 360.94 | 1 | 713.80 | 8 | SO67325 | 2024-07-22 | 57.10 | 721.89 | 356.90 | |||
SO55233_24 | 1590-499E-95 | PO551184455 | 100 | 281 | 583 | 4 | 4 | 2024-01-26 | 2041.19 | 51.03 | 2024-01-14 | 2 | 1082.51 | 1 | 2041.19 | 24 | SO55233 | 2024-01-21 | 163.30 | 2165.02 | 1020.59 | |||
SO49884_18 | 822A-428D-94 | PO5626129805 | 100 | 281 | 414 | 166 | 4 | 2023-07-27 | 149.03 | 3.73 | 2023-07-15 | 1 | 110.28 | 1 | 149.03 | 18 | SO49884 | 2023-07-22 | 11.92 | 110.28 | 149.03 | |||
SO69466_13 | 8B97-4CC6-8A | PO2523169620 | 100 | 287 | 604 | 167 | 4 | 2024-08-26 | 323.99 | 8.10 | 2024-08-14 | 1 | 343.65 | 1 | 323.99 | 13 | SO69466 | 2024-08-21 | 25.92 | 343.65 | 323.99 | |||
SO55249_35 | 0527-4C9D-BA | PO13688172507 | 100 | 282 | 603 | 475 | 4 | 2024-01-26 | 291.58 | 7.29 | 2024-01-14 | 4 | 53.94 | 1 | 291.58 | 35 | SO55249 | 2024-01-21 | 23.33 | 215.77 | 72.89 | |||
SO47456_16 | 840E-4252-B7 | PO9715175233 | 100 | 283 | 427 | 490 | 4 | 2022-12-27 | 837.02 | 20.93 | 2022-12-15 | 4 | 185.82 | 1 | 837.02 | 16 | SO47456 | 2022-12-22 | 66.96 | 743.28 | 209.26 | |||
SO57085_34 | D1E5-454C-85 | PO2523188219 | 100 | 287 | 234 | 167 | 4 | 2024-02-26 | 179.96 | 4.50 | 2024-02-14 | 6 | 38.49 | 1 | 179.96 | 34 | SO57085 | 2024-02-21 | 14.40 | 230.95 | 29.99 | |||
SO57172_2 | 694F-4039-93 | PO5655181244 | 100 | 287 | 554 | 563 | 4 | 2024-02-26 | 164.83 | 4.12 | 2024-02-14 | 3 | 40.66 | 1 | 164.83 | 2 | SO57172 | 2024-02-21 | 13.19 | 121.97 | 54.94 | |||
SO53607_5 | 329F-491C-8E | PO5510117855 | 100 | 287 | 545 | 5 | 4 | 2023-12-27 | 72.88 | 1.82 | 2023-12-15 | 3 | 17.98 | 1 | 72.88 | 5 | SO53607 | 2023-12-22 | 5.83 | 53.93 | 24.29 | |||
SO46660_19 | CF24-45E2-9D | PO5626129733 | 100 | 283 | 325 | 166 | 4 | 2022-10-26 | 2818.76 | 70.47 | 2022-10-14 | 6 | 486.71 | 1 | 2818.76 | 19 | SO46660 | 2022-10-21 | 225.50 | 2920.24 | 469.79 | |||
SO65303_11 | 93EA-4158-A9 | PO5539133147 | 100 | 282 | 474 | 61 | 4 | 2024-06-26 | 167.98 | 4.20 | 2024-06-14 | 4 | 26.18 | 1 | 167.98 | 11 | SO65303 | 2024-06-21 | 13.44 | 104.71 | 41.99 | |||
SO51122_11 | D915-4225-97 | PO551181465 | 100 | 281 | 418 | 4 | 4 | 2023-10-26 | 713.80 | 17.84 | 2023-10-14 | 2 | 360.94 | 1 | 713.80 | 11 | SO51122 | 2023-10-21 | 57.10 | 721.89 | 356.90 | |||
SO61264_18 | 5396-4F0C-B0 | PO5626112601 | 100 | 281 | 434 | 166 | 4 | 2024-04-27 | 1070.69 | 26.77 | 2024-04-15 | 3 | 360.94 | 1 | 1070.69 | 18 | SO61264 | 2024-04-22 | 85.66 | 1082.83 | 356.90 |
Generated 2024-11-13 09:18:49.400 UTC