[ROOT] dt FactResellerSale WHERE DimSalesTerritoryId EQ '1' > SHUFFLE SKIP 2000 < SKIP 687 > < 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 |
---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
SO55291_3 | 4FAB-4BAB-88 | PO7076160432 | 100 | 293 | 560 | 505 | 1 | 2024-01-22 | 1457.82 | 36.45 | 2024-01-10 | 2 | 755.15 | 1 | 1457.82 | 3 | SO55291 | 2024-01-17 | 116.63 | 1510.30 | 728.91 | |||
SO51821_12 | 1CCD-45D4-80 | PO7917148134 | 100 | 287 | 517 | 401 | 1 | 2023-11-22 | 31.58 | 0.79 | 2023-11-10 | 1 | 23.37 | 1 | 31.58 | 12 | SO51821 | 2023-11-17 | 2.53 | 23.37 | 31.58 | |||
SO44109_14 | 1055-4F53-BB | PO783112882 | 100 | 286 | 262 | 91 | 1 | 2021-12-23 | 367.88 | 9.20 | 2021-12-11 | 2 | 181.49 | 1 | 367.88 | 14 | SO44109 | 2021-12-18 | 29.43 | 362.97 | 183.94 | |||
SO51721_15 | 9429-430D-89 | PO14500124798 | 100 | 282 | 474 | 650 | 1 | 2023-11-22 | 377.95 | 9.45 | 2023-11-10 | 9 | 26.18 | 1 | 377.95 | 15 | SO51721 | 2023-11-17 | 30.24 | 235.59 | 41.99 | |||
SO51123_30 | E412-45DF-AE | PO899150137 | 100 | 289 | 436 | 290 | 1 | 2023-10-22 | 1784.49 | 44.61 | 2023-10-10 | 5 | 360.94 | 1 | 1784.49 | 30 | SO51123 | 2023-10-17 | 142.76 | 1804.71 | 356.90 | |||
SO48385_5 | 753C-4EBE-B8 | PO7946110963 | 100 | 282 | 343 | 438 | 1 | 2023-03-24 | 939.59 | 23.49 | 2023-03-12 | 2 | 486.71 | 1 | 939.59 | 5 | SO48385 | 2023-03-19 | 75.17 | 973.41 | 469.79 | |||
SO48381_7 | C4B2-44F3-BF | PO7192163873 | 100 | 289 | 468 | 20 | 1 | 2023-03-24 | 22.79 | 0.57 | 2023-03-12 | 1 | 15.67 | 1 | 22.79 | 7 | SO48381 | 2023-03-19 | 1.82 | 15.67 | 22.79 | |||
SO47033_1 | 2797-46ED-BB | PO4727113716 | 100 | 286 | 403 | 343 | 1 | 2022-11-22 | 72.88 | 1.82 | 2022-11-10 | 3 | 17.98 | 1 | 72.88 | 1 | SO47033 | 2022-11-17 | 5.83 | 53.93 | 24.29 | |||
SO44762_20 | 553E-437E-92 | PO13543176259 | 100 | 287 | 220 | 2 | 293 | 1 | 4.29 | 2022-03-24 | 214.65 | 5.26 | 2022-03-12 | 11 | 12.03 | 1 | 210.36 | 20 | SO44762 | 2022-03-19 | 16.83 | 132.31 | 19.51 | 0.02 |
SO51789_29 | A5AF-4504-83 | PO18618169495 | 100 | 286 | 565 | 13 | 605 | 1 | 150.33 | 2023-11-22 | 1002.17 | 21.30 | 2023-11-10 | 3 | 461.44 | 1 | 851.85 | 29 | SO51789 | 2023-11-17 | 68.15 | 1384.33 | 334.06 | 0.15 |
SO47986_12 | 3373-4C22-A9 | PO16414116972 | 100 | 289 | 456 | 236 | 1 | 2023-02-22 | 359.95 | 9.00 | 2023-02-10 | 8 | 30.93 | 1 | 359.95 | 12 | SO47986 | 2023-02-17 | 28.80 | 247.47 | 44.99 | |||
SO63289_1 | AC2B-462B-AA | PO7917194869 | 100 | 287 | 359 | 401 | 1 | 2024-05-24 | 4130.98 | 103.27 | 2024-05-12 | 3 | 1251.98 | 1 | 4130.98 | 1 | SO63289 | 2024-05-19 | 330.48 | 3755.94 | 1376.99 | |||
SO63265_1 | EB16-47CF-A5 | PO754192732 | 100 | 289 | 589 | 645 | 1 | 2024-05-24 | 461.69 | 11.54 | 2024-05-12 | 1 | 419.78 | 1 | 461.69 | 1 | SO63265 | 2024-05-19 | 36.94 | 419.78 | 461.69 | |||
SO57099_5 | 410F-45E9-9C | PO18618199656 | 100 | 286 | 490 | 605 | 1 | 2024-02-22 | 226.76 | 5.67 | 2024-02-10 | 7 | 41.57 | 1 | 226.76 | 5 | SO57099 | 2024-02-17 | 18.14 | 291.01 | 32.39 | |||
SO47986_28 | 3373-4C22-A9 | PO16414116972 | 100 | 289 | 419 | 236 | 1 | 2023-02-22 | 52.65 | 1.32 | 2023-02-10 | 1 | 38.96 | 1 | 52.65 | 28 | SO47986 | 2023-02-17 | 4.21 | 38.96 | 52.65 | |||
SO53457_7 | B3F3-4A07-9B | PO19169151555 | 100 | 289 | 556 | 272 | 1 | 2023-12-23 | 315.88 | 7.90 | 2023-12-11 | 3 | 77.92 | 1 | 315.88 | 7 | SO53457 | 2023-12-18 | 25.27 | 233.75 | 105.29 | |||
SO69406_44 | E101-486C-A5 | PO16675181672 | 100 | 293 | 568 | 361 | 1 | 2024-08-22 | 445.41 | 11.14 | 2024-08-10 | 1 | 461.44 | 1 | 445.41 | 44 | SO69406 | 2024-08-17 | 35.63 | 461.44 | 445.41 | |||
SO46611_33 | 93A4-4A4D-99 | PO16588117269 | 100 | 289 | 411 | 146 | 1 | 2022-10-22 | 250.83 | 6.27 | 2022-10-10 | 2 | 92.81 | 1 | 250.83 | 33 | SO46611 | 2022-10-17 | 20.07 | 185.61 | 125.42 | |||
SO47992_19 | 3F55-4354-BD | PO15573158216 | 100 | 293 | 409 | 487 | 1 | 2023-02-22 | 418.51 | 10.46 | 2023-02-10 | 2 | 185.82 | 1 | 418.51 | 19 | SO47992 | 2023-02-17 | 33.48 | 371.64 | 209.26 | |||
SO48347_20 | 40D2-4DF5-93 | PO841112057 | 100 | 286 | 394 | 254 | 1 | 2023-03-24 | 61.56 | 1.54 | 2023-03-12 | 3 | 15.18 | 1 | 61.56 | 20 | SO48347 | 2023-03-19 | 4.92 | 45.55 | 20.52 | |||
SO55291_9 | 4FAB-4BAB-88 | PO7076160432 | 100 | 293 | 522 | 505 | 1 | 2024-01-22 | 46.97 | 1.17 | 2024-01-10 | 2 | 17.38 | 1 | 46.97 | 9 | SO55291 | 2024-01-17 | 3.76 | 34.76 | 23.48 | |||
SO49464_7 | C383-45FE-83 | PO841195010 | 100 | 286 | 453 | 254 | 1 | 2023-06-22 | 71.99 | 1.80 | 2023-06-10 | 2 | 24.75 | 1 | 71.99 | 7 | SO49464 | 2023-06-17 | 5.76 | 49.49 | 35.99 | |||
SO51089_2 | A635-4BAF-BC | PO16588151558 | 100 | 289 | 516 | 146 | 1 | 2023-10-22 | 140.90 | 3.52 | 2023-10-10 | 6 | 17.38 | 1 | 140.90 | 2 | SO51089 | 2023-10-17 | 11.27 | 104.27 | 23.48 | |||
SO47970_3 | 6203-4130-A9 | PO18676198287 | 100 | 282 | 411 | 697 | 1 | 2023-02-22 | 250.83 | 6.27 | 2023-02-10 | 2 | 92.81 | 1 | 250.83 | 3 | SO47970 | 2023-02-17 | 20.07 | 185.61 | 125.42 | |||
SO51123_12 | E412-45DF-AE | PO899150137 | 100 | 289 | 374 | 290 | 1 | 2023-10-22 | 11728.08 | 293.20 | 2023-10-10 | 8 | 1554.95 | 1 | 11728.08 | 12 | SO51123 | 2023-10-17 | 938.25 | 12439.58 | 1466.01 | |||
SO47999_19 | DF06-4F6A-9D | PO14500121568 | 100 | 282 | 420 | 650 | 1 | 2023-02-22 | 1416.15 | 35.40 | 2023-02-10 | 10 | 104.80 | 1 | 1416.15 | 19 | SO47999 | 2023-02-17 | 113.29 | 1047.95 | 141.62 | |||
SO47066_7 | 5E42-48DE-80 | PO8816154123 | 100 | 289 | 389 | 218 | 1 | 2022-11-22 | 1800.79 | 45.02 | 2022-11-10 | 3 | 605.65 | 1 | 1800.79 | 7 | SO47066 | 2022-11-17 | 144.06 | 1816.95 | 600.26 | |||
SO48310_11 | B389-4D7D-85 | PO17139173607 | 100 | 293 | 407 | 644 | 1 | 2023-03-24 | 131.20 | 3.28 | 2023-03-12 | 2 | 48.55 | 1 | 131.20 | 11 | SO48310 | 2023-03-19 | 10.50 | 97.09 | 65.60 | |||
SO71836_8 | E41E-40C1-84 | PO841118259 | 100 | 286 | 306 | 254 | 1 | 2024-09-22 | 1619.52 | 40.49 | 2024-09-10 | 2 | 739.04 | 1 | 1619.52 | 8 | SO71836 | 2024-09-17 | 129.56 | 1478.08 | 809.76 | |||
SO51123_5 | E412-45DF-AE | PO899150137 | 100 | 289 | 382 | 290 | 1 | 2023-10-22 | 1344.59 | 33.61 | 2023-10-10 | 2 | 713.08 | 1 | 1344.59 | 5 | SO51123 | 2023-10-17 | 107.57 | 1426.16 | 672.29 | |||
SO46053_10 | E530-47A7-9A | PO14471143194 | 100 | 286 | 212 | 145 | 1 | 2022-08-22 | 40.37 | 1.01 | 2022-08-10 | 2 | 12.03 | 1 | 40.37 | 10 | SO46053 | 2022-08-17 | 3.23 | 24.06 | 20.19 |
Generated 2024-11-10 02:29:29.450 UTC