[ROOT] dt FactResellerSale < WHERE DimSalesTerritoryId EQ '3' > SHUFFLE SKIP 2000 < SKIP 593 > < TAKE 62 >
62 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 |
---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
SO69561_49 | BBC0-4CA4-A2 | PO8845186382 | 100 | 282 | 484 | 546 | 3 | 2024-07-03 | 14.31 | 0.36 | 2024-06-21 | 3 | 2.97 | 1 | 14.31 | 49 | SO69561 | 2024-06-28 | 1.14 | 8.92 | 4.77 | |||
SO61210_5 | 7860-4CE8-A9 | PO8787168827 | 100 | 282 | 491 | 2 | 523 | 3 | 6.89 | 2024-03-04 | 344.46 | 8.44 | 2024-02-21 | 11 | 41.57 | 1 | 337.57 | 5 | SO61210 | 2024-02-28 | 27.01 | 457.30 | 31.31 | 0.02 |
SO53561_29 | CDF6-4B12-87 | PO7047187583 | 100 | 281 | 475 | 544 | 3 | 2023-11-03 | 83.99 | 2.10 | 2023-10-22 | 2 | 26.18 | 1 | 83.99 | 29 | SO53561 | 2023-10-29 | 6.72 | 52.35 | 41.99 | |||
SO71864_12 | 2987-40A6-86 | PO14268188903 | 100 | 281 | 545 | 418 | 3 | 2024-08-03 | 97.18 | 2.43 | 2024-07-22 | 4 | 17.98 | 1 | 97.18 | 12 | SO71864 | 2024-07-29 | 7.77 | 71.91 | 24.29 | |||
SO46662_2 | 07F7-472E-AC | PO6467187386 | 100 | 281 | 414 | 660 | 3 | 2022-09-02 | 596.12 | 14.90 | 2022-08-21 | 4 | 110.28 | 1 | 596.12 | 2 | SO46662 | 2022-08-28 | 47.69 | 441.13 | 149.03 | |||
SO71884_15 | 5F6A-4027-A6 | PO7047195292 | 100 | 281 | 599 | 544 | 3 | 2024-08-03 | 323.99 | 8.10 | 2024-07-22 | 1 | 294.58 | 1 | 323.99 | 15 | SO71884 | 2024-07-29 | 25.92 | 294.58 | 323.99 | |||
SO43690_1 | 7A3C-492F-A6 | PO6235146326 | 100 | 281 | 232 | 431 | 3 | 2021-09-02 | 28.84 | 0.72 | 2021-08-21 | 1 | 31.72 | 1 | 28.84 | 1 | SO43690 | 2021-08-28 | 2.31 | 31.72 | 28.84 | |||
SO71897_2 | 01B7-40D7-B0 | PO4785152479 | 100 | 282 | 586 | 223 | 3 | 2024-08-03 | 1781.64 | 44.54 | 2024-07-22 | 4 | 461.44 | 1 | 1781.64 | 2 | SO71897 | 2024-07-29 | 142.53 | 1845.78 | 445.41 | |||
SO47714_6 | 884B-4F33-A1 | PO6235113773 | 100 | 281 | 458 | 431 | 3 | 2022-12-03 | 179.98 | 4.50 | 2022-11-21 | 4 | 30.93 | 1 | 179.98 | 6 | SO47714 | 2022-11-28 | 14.40 | 123.73 | 44.99 | |||
SO46968_11 | 280B-4350-80 | PO15254133264 | 100 | 281 | 233 | 377 | 3 | 2022-10-03 | 28.84 | 0.72 | 2022-09-21 | 1 | 29.08 | 1 | 28.84 | 11 | SO46968 | 2022-09-28 | 2.31 | 29.08 | 28.84 | |||
SO48004_12 | DC8C-40DC-8F | PO13572118942 | 100 | 287 | 422 | 527 | 3 | 2023-01-03 | 67.54 | 1.69 | 2022-12-22 | 1 | 49.98 | 1 | 67.54 | 12 | SO48004 | 2022-12-29 | 5.40 | 49.98 | 67.54 | |||
SO47409_15 | FC23-4384-86 | PO1624119173 | 100 | 283 | 242 | 579 | 3 | 2022-11-03 | 2342.45 | 58.56 | 2022-10-22 | 3 | 722.26 | 1 | 2342.45 | 15 | SO47409 | 2022-10-29 | 187.40 | 2166.77 | 780.82 | |||
SO53561_18 | CDF6-4B12-87 | PO7047187583 | 100 | 281 | 557 | 544 | 3 | 2023-11-03 | 307.79 | 7.69 | 2023-10-22 | 2 | 113.88 | 1 | 307.79 | 18 | SO53561 | 2023-10-29 | 24.62 | 227.76 | 153.89 | |||
SO45055_10 | 0C6F-4406-A0 | PO12412126535 | 100 | 283 | 330 | 670 | 3 | 2022-03-05 | 419.46 | 10.49 | 2022-02-21 | 1 | 413.15 | 1 | 419.46 | 10 | SO45055 | 2022-02-28 | 33.56 | 413.15 | 419.46 | |||
SO45539_3 | B54E-42F9-AB | PO13920158775 | 100 | 281 | 351 | 180 | 3 | 2022-05-03 | 4049.99 | 101.25 | 2022-04-21 | 2 | 1898.09 | 1 | 4049.99 | 3 | SO45539 | 2022-04-28 | 324.00 | 3796.19 | 2024.99 | |||
SO45785_10 | 695A-4F07-88 | PO15428114828 | 100 | 283 | 349 | 646 | 3 | 2022-06-03 | 6074.98 | 151.87 | 2022-05-22 | 3 | 1898.09 | 1 | 6074.98 | 10 | SO45785 | 2022-05-29 | 486.00 | 5694.28 | 2024.99 | |||
SO47440_15 | 490D-4B3C-84 | PO7018185620 | 100 | 283 | 213 | 695 | 3 | 2022-11-03 | 60.56 | 1.51 | 2022-10-22 | 3 | 13.88 | 1 | 60.56 | 15 | SO47440 | 2022-10-29 | 4.84 | 41.63 | 20.19 | |||
SO46662_12 | 07F7-472E-AC | PO6467187386 | 100 | 281 | 370 | 660 | 3 | 2022-09-02 | 1466.01 | 36.65 | 2022-08-21 | 1 | 1518.79 | 1 | 1466.01 | 12 | SO46662 | 2022-08-28 | 117.28 | 1518.79 | 1466.01 | |||
SO44759_1 | F134-481F-9F | PO13920149157 | 100 | 281 | 350 | 180 | 3 | 2022-02-02 | 2024.99 | 50.62 | 2022-01-21 | 1 | 1898.09 | 1 | 2024.99 | 1 | SO44759 | 2022-01-28 | 162.00 | 1898.09 | 2024.99 | |||
SO47041_20 | C543-4932-83 | PO5771188676 | 100 | 282 | 370 | 79 | 3 | 2022-10-03 | 4398.03 | 109.95 | 2022-09-21 | 3 | 1518.79 | 1 | 4398.03 | 20 | SO47041 | 2022-09-28 | 351.84 | 4556.36 | 1466.01 | |||
SO49116_13 | 5844-47DC-B2 | PO13572169665 | 100 | 287 | 329 | 527 | 3 | 2023-04-05 | 1409.38 | 35.23 | 2023-03-24 | 3 | 486.71 | 1 | 1409.38 | 13 | SO49116 | 2023-03-31 | 112.75 | 1460.12 | 469.79 | |||
SO47419_2 | 7703-4F2C-92 | PO3103122578 | 100 | 283 | 333 | 147 | 3 | 2022-11-03 | 2348.97 | 58.72 | 2022-10-22 | 5 | 486.71 | 1 | 2348.97 | 2 | SO47419 | 2022-10-29 | 187.92 | 2433.53 | 469.79 | |||
SO53480_1 | 36E1-4FCF-B4 | PO15341137525 | 100 | 281 | 542 | 327 | 3 | 2023-11-03 | 24.29 | 0.61 | 2023-10-22 | 1 | 17.98 | 1 | 24.29 | 1 | SO53480 | 2023-10-29 | 1.94 | 17.98 | 24.29 | |||
SO51091_2 | DEAC-431D-94 | PO15399127644 | 100 | 281 | 555 | 220 | 3 | 2023-09-02 | 127.80 | 3.20 | 2023-08-21 | 2 | 47.29 | 1 | 127.80 | 2 | SO51091 | 2023-08-28 | 10.22 | 94.57 | 63.90 | |||
SO71884_27 | 5F6A-4027-A6 | PO7047195292 | 100 | 281 | 531 | 544 | 3 | 2024-08-03 | 299.75 | 7.49 | 2024-07-22 | 2 | 136.79 | 1 | 299.75 | 27 | SO71884 | 2024-07-29 | 23.98 | 273.57 | 149.87 | |||
SO48004_20 | DC8C-40DC-8F | PO13572118942 | 100 | 287 | 329 | 527 | 3 | 2023-01-03 | 2348.97 | 58.72 | 2022-12-22 | 5 | 486.71 | 1 | 2348.97 | 20 | SO48004 | 2022-12-29 | 187.92 | 2433.53 | 469.79 | |||
SO48325_22 | 0A85-48D3-97 | PO14268111638 | 100 | 283 | 329 | 418 | 3 | 2023-02-02 | 939.59 | 23.49 | 2023-01-21 | 2 | 486.71 | 1 | 939.59 | 22 | SO48325 | 2023-01-28 | 75.17 | 973.41 | 469.79 | |||
SO46969_15 | 3C39-4176-A8 | PO15370166954 | 100 | 283 | 468 | 381 | 3 | 2022-10-03 | 45.59 | 1.14 | 2022-09-21 | 2 | 15.67 | 1 | 45.59 | 15 | SO46969 | 2022-09-28 | 3.65 | 31.34 | 22.79 | |||
SO69424_2 | 27D0-406C-81 | PO13601112941 | 100 | 281 | 471 | 310 | 3 | 2024-07-03 | 38.10 | 0.95 | 2024-06-21 | 1 | 23.75 | 1 | 38.10 | 2 | SO69424 | 2024-06-28 | 3.05 | 23.75 | 38.10 | |||
SO67332_8 | E97E-4BCF-92 | PO6235122123 | 100 | 283 | 225 | 431 | 3 | 2024-06-03 | 5.39 | 0.13 | 2024-05-22 | 1 | 6.92 | 1 | 5.39 | 8 | SO67332 | 2024-05-29 | 0.43 | 6.92 | 5.39 | |||
SO63123_4 | ADA9-4CA6-94 | PO19923184888 | 100 | 283 | 400 | 18 | 3 | 2024-04-04 | 74.30 | 1.86 | 2024-03-23 | 2 | 27.49 | 1 | 74.30 | 4 | SO63123 | 2024-03-30 | 5.94 | 54.99 | 37.15 | |||
SO45538_2 | 0310-4DCB-B5 | PO14268192541 | 100 | 283 | 332 | 418 | 3 | 2022-05-03 | 419.46 | 10.49 | 2022-04-21 | 1 | 413.15 | 1 | 419.46 | 2 | SO45538 | 2022-04-28 | 33.56 | 413.15 | 419.46 | |||
SO58928_42 | 6C1A-4E73-97 | PO15341119997 | 100 | 281 | 591 | 327 | 3 | 2024-02-02 | 338.99 | 8.47 | 2024-01-21 | 1 | 308.22 | 1 | 338.99 | 42 | SO58928 | 2024-01-28 | 27.12 | 308.22 | 338.99 | |||
SO49837_25 | C136-4536-9D | PO12412160791 | 100 | 281 | 327 | 670 | 3 | 2023-06-03 | 939.59 | 23.49 | 2023-05-22 | 2 | 486.71 | 1 | 939.59 | 25 | SO49837 | 2023-05-29 | 75.17 | 973.41 | 469.79 | |||
SO71864_10 | 2987-40A6-86 | PO14268188903 | 100 | 281 | 372 | 418 | 3 | 2024-08-03 | 2932.02 | 73.30 | 2024-07-22 | 2 | 1554.95 | 1 | 2932.02 | 10 | SO71864 | 2024-07-29 | 234.56 | 3109.90 | 1466.01 | |||
SO45557_5 | 2C02-480B-8E | PO4147117065 | 100 | 282 | 318 | 222 | 3 | 2022-05-03 | 1749.59 | 43.74 | 2022-04-21 | 2 | 884.71 | 1 | 1749.59 | 5 | SO45557 | 2022-04-28 | 139.97 | 1769.42 | 874.79 | |||
SO67347_30 | 6E87-4127-80 | PO8787117055 | 100 | 282 | 488 | 523 | 3 | 2024-06-03 | 226.76 | 5.67 | 2024-05-22 | 7 | 41.57 | 1 | 226.76 | 30 | SO67347 | 2024-05-29 | 18.14 | 291.01 | 32.39 | |||
SO44079_13 | A180-4128-A7 | PO19488118734 | 100 | 283 | 229 | 57 | 3 | 2021-11-03 | 144.20 | 3.61 | 2021-10-22 | 5 | 31.72 | 1 | 144.20 | 13 | SO44079 | 2021-10-29 | 11.54 | 158.62 | 28.84 | |||
SO47683_31 | 619F-4ABF-8A | PO12412127983 | 100 | 283 | 371 | 670 | 3 | 2022-12-03 | 3926.81 | 98.17 | 2022-11-21 | 3 | 1320.68 | 1 | 3926.81 | 31 | SO47683 | 2022-11-28 | 314.15 | 3962.05 | 1308.94 | |||
SO57037_17 | F0A9-4A16-B9 | PO15370120234 | 100 | 281 | 511 | 381 | 3 | 2024-01-03 | 655.36 | 16.38 | 2023-12-22 | 3 | 199.38 | 1 | 655.36 | 17 | SO57037 | 2023-12-29 | 52.43 | 598.13 | 218.45 | |||
SO46968_5 | 280B-4350-80 | PO15254133264 | 100 | 281 | 221 | 377 | 3 | 2022-10-03 | 40.37 | 1.01 | 2022-09-21 | 2 | 13.88 | 1 | 40.37 | 5 | SO46968 | 2022-09-28 | 3.23 | 27.76 | 20.19 | |||
SO51822_39 | EEEE-45C1-87 | PO8845178563 | 100 | 282 | 222 | 546 | 3 | 2023-10-03 | 83.98 | 2.10 | 2023-09-21 | 4 | 13.09 | 1 | 83.98 | 39 | SO51822 | 2023-09-28 | 6.72 | 52.35 | 20.99 | |||
SO48367_3 | 43A1-4D40-AB | PO4437174115 | 100 | 283 | 429 | 39 | 3 | 2023-02-02 | 324.45 | 8.11 | 2023-01-21 | 1 | 300.12 | 1 | 324.45 | 3 | SO48367 | 2023-01-28 | 25.96 | 300.12 | 324.45 | |||
SO47716_1 | 619E-46D6-98 | PO6467148836 | 100 | 281 | 370 | 660 | 3 | 2022-12-03 | 4398.03 | 109.95 | 2022-11-21 | 3 | 1518.79 | 1 | 4398.03 | 1 | SO47716 | 2022-11-28 | 351.84 | 4556.36 | 1466.01 | |||
SO71798_5 | AFA9-4B18-AD | PO16994135863 | 100 | 283 | 545 | 306 | 3 | 2024-08-03 | 48.59 | 1.21 | 2024-07-22 | 2 | 17.98 | 1 | 48.59 | 5 | SO71798 | 2024-07-29 | 3.89 | 35.96 | 24.29 | |||
SO47429_4 | 2D59-4D85-83 | PO4669176830 | 100 | 283 | 216 | 111 | 3 | 2022-11-03 | 80.75 | 2.02 | 2022-10-22 | 4 | 13.88 | 1 | 80.75 | 4 | SO47429 | 2022-10-29 | 6.46 | 55.51 | 20.19 | |||
SO47394_33 | 7FC9-4002-83 | PO12354143510 | 100 | 281 | 421 | 197 | 3 | 2022-11-03 | 392.66 | 9.82 | 2022-10-22 | 2 | 145.28 | 1 | 392.66 | 33 | SO47394 | 2022-10-29 | 31.41 | 290.57 | 196.33 | |||
SO58906_5 | 6BB0-48C1-BE | PO19633186598 | 100 | 287 | 525 | 149 | 3 | 2024-02-02 | 158.43 | 3.96 | 2024-01-21 | 1 | 144.59 | 1 | 158.43 | 5 | SO58906 | 2024-01-28 | 12.67 | 144.59 | 158.43 | |||
SO49093_2 | A0B1-4C01-8A | PO15370113221 | 100 | 281 | 395 | 381 | 3 | 2023-04-05 | 122.75 | 3.07 | 2023-03-24 | 2 | 45.42 | 1 | 122.75 | 2 | SO49093 | 2023-03-31 | 9.82 | 90.83 | 61.37 | |||
SO55324_38 | 35BE-456A-B8 | PO8787146999 | 100 | 282 | 472 | 523 | 3 | 2023-12-03 | 228.60 | 5.72 | 2023-11-21 | 6 | 23.75 | 1 | 228.60 | 38 | SO55324 | 2023-11-28 | 18.29 | 142.49 | 38.10 | |||
SO57121_15 | A796-4C1D-A6 | PO5771187733 | 100 | 282 | 386 | 79 | 3 | 2024-01-03 | 672.29 | 16.81 | 2023-12-22 | 1 | 713.08 | 1 | 672.29 | 15 | SO57121 | 2023-12-29 | 53.78 | 713.08 | 672.29 | |||
SO46651_7 | 68A1-47A8-9A | PO3016181627 | 100 | 283 | 356 | 183 | 3 | 2022-09-02 | 1242.85 | 31.07 | 2022-08-21 | 1 | 1117.86 | 1 | 1242.85 | 7 | SO46651 | 2022-08-28 | 99.43 | 1117.86 | 1242.85 | |||
SO58996_9 | 5A1A-4E3D-B2 | PO14268110627 | 100 | 281 | 482 | 418 | 3 | 2024-02-02 | 48.55 | 1.21 | 2024-01-21 | 9 | 3.36 | 1 | 48.55 | 9 | SO58996 | 2024-01-28 | 3.88 | 30.26 | 5.39 | |||
SO57148_2 | AE28-4B3B-9D | PO3074151668 | 100 | 281 | 512 | 237 | 3 | 2024-01-03 | 218.45 | 5.46 | 2023-12-22 | 1 | 199.38 | 1 | 218.45 | 2 | SO57148 | 2023-12-29 | 17.48 | 199.38 | 218.45 | |||
SO47409_21 | FC23-4384-86 | PO1624119173 | 100 | 283 | 370 | 579 | 3 | 2022-11-03 | 1466.01 | 36.65 | 2022-10-22 | 1 | 1518.79 | 1 | 1466.01 | 21 | SO47409 | 2022-10-29 | 117.28 | 1518.79 | 1466.01 | |||
SO69503_33 | 559D-4568-82 | PO5771124379 | 100 | 282 | 547 | 79 | 3 | 2024-07-03 | 242.97 | 6.07 | 2024-06-21 | 5 | 35.96 | 1 | 242.97 | 33 | SO69503 | 2024-06-28 | 19.44 | 179.80 | 48.59 | |||
SO71819_20 | DBA3-430C-8B | PO12354153257 | 100 | 283 | 517 | 197 | 3 | 2024-08-03 | 31.58 | 0.79 | 2024-07-22 | 1 | 23.37 | 1 | 31.58 | 20 | SO71819 | 2024-07-29 | 2.53 | 23.37 | 31.58 | |||
SO46066_6 | ADF8-444D-9C | PO10759115463 | 100 | 283 | 344 | 346 | 3 | 2022-07-03 | 20399.94 | 510.00 | 2022-06-21 | 10 | 1912.15 | 1 | 20399.94 | 6 | SO46066 | 2022-06-28 | 1632.00 | 19121.54 | 2039.99 | |||
SO47996_12 | B6EA-4582-9E | PO15370152849 | 100 | 283 | 393 | 381 | 3 | 2023-01-03 | 550.78 | 13.77 | 2022-12-22 | 4 | 101.89 | 1 | 550.78 | 12 | SO47996 | 2022-12-29 | 44.06 | 407.57 | 137.69 | |||
SO47428_1 | 7740-494F-95 | PO4437183290 | 100 | 283 | 423 | 39 | 3 | 2022-11-03 | 495.69 | 12.39 | 2022-10-22 | 3 | 122.27 | 1 | 495.69 | 1 | SO47428 | 2022-10-29 | 39.66 | 366.81 | 165.23 | |||
SO58944_4 | 90AC-4F21-90 | PO12354164168 | 100 | 283 | 402 | 197 | 3 | 2024-02-02 | 288.65 | 7.22 | 2024-01-21 | 4 | 53.40 | 1 | 288.65 | 4 | SO58944 | 2024-01-28 | 23.09 | 213.60 | 72.16 | |||
SO48325_37 | 0A85-48D3-97 | PO14268111638 | 100 | 283 | 224 | 418 | 3 | 2023-02-02 | 20.75 | 0.52 | 2023-01-21 | 4 | 5.23 | 1 | 20.75 | 37 | SO48325 | 2023-01-28 | 1.66 | 20.92 | 5.19 |
Generated 2024-09-20 04:34:38.434 UTC