[ROOT] dt FactResellerSale < WHERE DimSalesTerritoryId EQ '4' > SHUFFLE < SKIP 792 > < 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 |
---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
SO46988_50 | 2D2E-4EC3-AC | PO12499171502 | 100 | 282 | 224 | 78 | 4 | 2022-11-27 | 51.87 | 1.30 | 2022-11-15 | 10 | 5.23 | 1 | 51.87 | 50 | SO46988 | 2022-11-22 | 4.15 | 52.30 | 5.19 | |||
SO47400_11 | F0B3-44C1-8F | PO10701186775 | 100 | 282 | 468 | 133 | 4 | 2022-12-28 | 91.18 | 2.28 | 2022-12-16 | 4 | 15.67 | 1 | 91.18 | 11 | SO47400 | 2022-12-23 | 7.29 | 62.68 | 22.79 | |||
SO53476_15 | BF5A-472F-98 | PO16153121709 | 100 | 282 | 568 | 13 | 186 | 4 | 50.11 | 2023-12-28 | 334.06 | 7.10 | 2023-12-16 | 1 | 461.44 | 1 | 283.95 | 15 | SO53476 | 2023-12-23 | 22.72 | 461.44 | 334.06 | 0.15 |
SO50272_13 | E0A6-4CFA-90 | PO11745174916 | 100 | 282 | 286 | 97 | 4 | 2023-08-27 | 183.94 | 4.60 | 2023-08-15 | 1 | 170.14 | 1 | 183.94 | 13 | SO50272 | 2023-08-22 | 14.72 | 170.14 | 183.94 | |||
SO51099_4 | FF5E-417D-8D | PO13833111492 | 100 | 287 | 561 | 14 | 95 | 4 | 190.73 | 2023-10-27 | 953.63 | 19.07 | 2023-10-15 | 1 | 1481.94 | 1 | 762.90 | 4 | SO51099 | 2023-10-22 | 61.03 | 1481.94 | 953.63 | 0.20 |
SO48373_25 | 4C9A-49DD-BA | PO5539129597 | 100 | 282 | 412 | 61 | 4 | 2023-03-29 | 720.52 | 18.01 | 2023-03-17 | 4 | 133.30 | 1 | 720.52 | 25 | SO48373 | 2023-03-24 | 57.64 | 533.18 | 180.13 | |||
SO47441_10 | 2582-4E47-98 | PO7569166535 | 100 | 287 | 401 | 608 | 4 | 2022-12-28 | 196.81 | 4.92 | 2022-12-16 | 3 | 48.55 | 1 | 196.81 | 10 | SO47441 | 2022-12-23 | 15.74 | 145.64 | 65.60 | |||
SO49160_17 | 60E2-486C-AE | PO7656113690 | 100 | 282 | 224 | 403 | 4 | 2023-05-30 | 15.56 | 0.39 | 2023-05-18 | 3 | 5.23 | 1 | 15.56 | 17 | SO49160 | 2023-05-25 | 1.24 | 15.69 | 5.19 | |||
SO47687_44 | 738F-43EE-95 | PO10817185499 | 100 | 287 | 273 | 203 | 4 | 2023-01-27 | 202.33 | 5.06 | 2023-01-15 | 1 | 187.16 | 1 | 202.33 | 44 | SO47687 | 2023-01-22 | 16.19 | 187.16 | 202.33 | |||
SO58982_2 | EEA8-4A3B-AF | PO18125159249 | 100 | 287 | 386 | 311 | 4 | 2024-03-28 | 1344.59 | 33.61 | 2024-03-16 | 2 | 713.08 | 1 | 1344.59 | 2 | SO58982 | 2024-03-23 | 107.57 | 1426.16 | 672.29 | |||
SO44777_11 | CCD0-4777-A4 | PO3248124126 | 100 | 282 | 347 | 366 | 4 | 2022-03-29 | 8159.98 | 204.00 | 2022-03-17 | 4 | 1912.15 | 1 | 8159.98 | 11 | SO44777 | 2022-03-24 | 652.80 | 7648.62 | 2039.99 | |||
SO44791_3 | CA2D-49E4-BD | PO6786162636 | 100 | 283 | 235 | 3 | 4 | 2022-03-29 | 86.52 | 2.16 | 2022-03-17 | 3 | 31.72 | 1 | 86.52 | 3 | SO44791 | 2022-03-24 | 6.92 | 95.17 | 28.84 | |||
SO49523_33 | 852E-47A8-A9 | PO3915144057 | 100 | 281 | 422 | 130 | 4 | 2023-06-27 | 135.08 | 3.38 | 2023-06-15 | 2 | 49.98 | 1 | 135.08 | 33 | SO49523 | 2023-06-22 | 10.81 | 99.96 | 67.54 | |||
SO46374_11 | 67B2-494E-90 | PO5597118034 | 100 | 283 | 220 | 75 | 4 | 2022-09-27 | 121.12 | 3.03 | 2022-09-15 | 6 | 12.03 | 1 | 121.12 | 11 | SO46374 | 2022-09-22 | 9.69 | 72.17 | 20.19 | |||
SO48369_3 | 92AB-4468-B5 | PO4582138864 | 100 | 282 | 409 | 25 | 4 | 2023-03-29 | 209.26 | 5.23 | 2023-03-17 | 1 | 185.82 | 1 | 209.26 | 3 | SO48369 | 2023-03-24 | 16.74 | 185.82 | 209.26 | |||
SO49104_25 | 7F8C-4702-BB | PO11745119484 | 100 | 282 | 385 | 97 | 4 | 2023-05-30 | 1200.53 | 30.01 | 2023-05-18 | 2 | 605.65 | 1 | 1200.53 | 25 | SO49104 | 2023-05-25 | 96.04 | 1211.30 | 600.26 | |||
SO51121_2 | 9E4C-40B6-B1 | PO10730114575 | 100 | 287 | 606 | 491 | 4 | 2023-10-27 | 1943.96 | 48.60 | 2023-10-15 | 6 | 343.65 | 1 | 1943.96 | 2 | SO51121 | 2023-10-22 | 155.52 | 2061.90 | 323.99 | |||
SO46970_38 | 01AF-420A-B9 | PO15196114472 | 100 | 282 | 381 | 258 | 4 | 2022-11-27 | 2401.05 | 60.03 | 2022-11-15 | 4 | 605.65 | 1 | 2401.05 | 38 | SO46970 | 2022-11-22 | 192.08 | 2422.60 | 600.26 | |||
SO47423_3 | 091B-4715-B2 | PO3886127119 | 100 | 283 | 325 | 165 | 4 | 2022-12-28 | 939.59 | 23.49 | 2022-12-16 | 2 | 486.71 | 1 | 939.59 | 3 | SO47423 | 2022-12-23 | 75.17 | 973.41 | 469.79 | |||
SO51833_21 | 67A5-4BBC-8F | PO5684113634 | 100 | 282 | 515 | 385 | 4 | 2023-11-27 | 48.82 | 1.22 | 2023-11-15 | 3 | 12.04 | 1 | 48.82 | 21 | SO51833 | 2023-11-22 | 3.91 | 36.12 | 16.27 | |||
SO44521_4 | E46D-4692-AC | PO12557171689 | 100 | 282 | 232 | 240 | 4 | 2022-02-27 | 57.68 | 1.44 | 2022-02-15 | 2 | 31.72 | 1 | 57.68 | 4 | SO44521 | 2022-02-22 | 4.61 | 63.45 | 28.84 | |||
SO51844_8 | DE76-4481-AA | PO4553182082 | 100 | 282 | 481 | 313 | 4 | 2023-11-27 | 10.79 | 0.27 | 2023-11-15 | 2 | 3.36 | 1 | 10.79 | 8 | SO51844 | 2023-11-22 | 0.86 | 6.72 | 5.39 | |||
SO45799_22 | 4DE8-4B9B-A1 | PO10730195041 | 100 | 287 | 318 | 491 | 4 | 2022-07-28 | 2624.38 | 65.61 | 2022-07-16 | 3 | 884.71 | 1 | 2624.38 | 22 | SO45799 | 2022-07-23 | 209.95 | 2654.12 | 874.79 | |||
SO61218_28 | 8441-4C6F-89 | PO13688193778 | 100 | 282 | 524 | 475 | 4 | 2024-04-28 | 316.86 | 7.92 | 2024-04-16 | 2 | 144.59 | 1 | 316.86 | 28 | SO61218 | 2024-04-23 | 25.35 | 289.19 | 158.43 | |||
SO49099_24 | D567-4CCE-A4 | PO15689170019 | 100 | 281 | 456 | 328 | 4 | 2023-05-30 | 179.98 | 4.50 | 2023-05-18 | 4 | 30.93 | 1 | 179.98 | 24 | SO49099 | 2023-05-25 | 14.40 | 123.73 | 44.99 | |||
SO49523_21 | 852E-47A8-A9 | PO3915144057 | 100 | 281 | 230 | 130 | 4 | 2023-06-27 | 57.68 | 1.44 | 2023-06-15 | 2 | 29.08 | 1 | 57.68 | 21 | SO49523 | 2023-06-22 | 4.61 | 58.16 | 28.84 | |||
SO53531_37 | B1FB-47B2-8E | PO2697181370 | 100 | 282 | 471 | 187 | 4 | 2023-12-28 | 152.40 | 3.81 | 2023-12-16 | 4 | 23.75 | 1 | 152.40 | 37 | SO53531 | 2023-12-23 | 12.19 | 95.00 | 38.10 | |||
SO55276_23 | 81AA-41E5-B0 | PO2755182998 | 100 | 282 | 493 | 205 | 4 | 2024-01-27 | 1000.26 | 25.01 | 2024-01-15 | 5 | 199.85 | 1 | 1000.26 | 23 | SO55276 | 2024-01-22 | 80.02 | 999.26 | 200.05 |
Generated 2024-11-14 23:08:41.233 UTC