[ROOT] dt FactResellerSale < WHERE DimSalesTerritoryId EQ ALL SHUFFLE < SKIP 264 > < TAKE 30 >
30 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 |
---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
SO51812_8 | 24E8-4559-AB | PO8555114368 | 98 | 288 | 476 | 250 | 10 | 2023-10-02 | 125.98 | 3.15 | 2023-09-20 | 3 | 26.18 | 1 | 125.98 | 8 | SO51812 | 2023-09-27 | 10.08 | 78.53 | 41.99 | |||
SO63125_4 | F7DD-4FA0-B5 | PO18792150789 | 100 | 283 | 556 | 378 | 2 | 2024-04-03 | 315.88 | 7.90 | 2024-03-22 | 3 | 77.92 | 1 | 315.88 | 4 | SO63125 | 2024-03-29 | 25.27 | 233.75 | 105.29 | |||
SO50265_32 | 6C30-435D-9D | PO18705169014 | 19 | 291 | 407 | 479 | 6 | 2023-07-02 | 65.60 | 1.64 | 2023-06-20 | 1 | 48.55 | 1 | 65.60 | 32 | SO50265 | 2023-06-27 | 5.25 | 48.55 | 65.60 | |||
SO47698_11 | 3841-4995-8C | PO2552129685 | 100 | 286 | 224 | 506 | 1 | 2022-12-02 | 31.12 | 0.78 | 2022-11-20 | 6 | 5.23 | 1 | 31.12 | 11 | SO47698 | 2022-11-27 | 2.49 | 31.38 | 5.19 | |||
SO48065_21 | 1B78-4DE6-BC | PO5771120852 | 100 | 282 | 385 | 79 | 3 | 2023-01-02 | 4201.84 | 105.05 | 2022-12-21 | 7 | 605.65 | 1 | 4201.84 | 21 | SO48065 | 2022-12-28 | 336.15 | 4239.54 | 600.26 | |||
SO69532_22 | 27FB-4A86-85 | PO3799165791 | 100 | 282 | 542 | 312 | 4 | 2024-07-02 | 48.59 | 1.21 | 2024-06-20 | 2 | 17.98 | 1 | 48.59 | 22 | SO69532 | 2024-06-27 | 3.89 | 35.96 | 24.29 | |||
SO53561_35 | CDF6-4B12-87 | PO7047187583 | 100 | 281 | 298 | 544 | 3 | 2023-11-02 | 2429.28 | 60.73 | 2023-10-21 | 3 | 739.04 | 1 | 2429.28 | 35 | SO53561 | 2023-10-28 | 194.34 | 2217.12 | 809.76 | |||
SO51102_26 | F2B1-4561-84 | PO13659193365 | 100 | 287 | 551 | 437 | 4 | 2023-09-01 | 158.43 | 3.96 | 2023-08-20 | 1 | 144.59 | 1 | 158.43 | 26 | SO51102 | 2023-08-27 | 12.67 | 144.59 | 158.43 | |||
SO48341_45 | A747-471B-97 | PO10701176180 | 100 | 282 | 366 | 133 | 4 | 2023-02-01 | 2591.98 | 64.80 | 2023-01-20 | 4 | 598.44 | 1 | 2591.98 | 45 | SO48341 | 2023-01-27 | 207.36 | 2393.74 | 647.99 | |||
SO47986_9 | 3373-4C22-A9 | PO16414116972 | 100 | 289 | 464 | 236 | 1 | 2023-01-02 | 28.26 | 0.71 | 2022-12-21 | 2 | 9.71 | 1 | 28.26 | 9 | SO47986 | 2022-12-28 | 2.26 | 19.43 | 14.13 | |||
SO51845_25 | 6AB8-4CEA-A9 | PO3799111961 | 100 | 282 | 532 | 312 | 4 | 2023-10-02 | 599.50 | 14.99 | 2023-09-20 | 4 | 136.79 | 1 | 599.50 | 25 | SO51845 | 2023-09-27 | 47.96 | 547.14 | 149.87 | |||
SO57125_12 | 2D2B-4159-87 | PO7453119638 | 100 | 283 | 465 | 108 | 2 | 2024-01-02 | 102.86 | 2.57 | 2023-12-21 | 7 | 9.16 | 1 | 102.86 | 12 | SO57125 | 2023-12-28 | 8.23 | 64.12 | 14.69 | |||
SO51828_13 | 3204-40B6-A5 | PO5771194719 | 100 | 282 | 463 | 79 | 3 | 2023-10-02 | 73.47 | 1.84 | 2023-09-20 | 5 | 9.16 | 1 | 73.47 | 13 | SO51828 | 2023-09-27 | 5.88 | 45.80 | 14.69 | |||
SO57093_11 | 2F7C-4AF6-8B | PO18705165751 | 19 | 291 | 477 | 479 | 6 | 2024-01-02 | 2.99 | 0.07 | 2023-12-21 | 1 | 1.87 | 1 | 2.99 | 11 | SO57093 | 2023-12-28 | 0.24 | 1.87 | 2.99 | |||
SO51089_5 | A635-4BAF-BC | PO16588151558 | 100 | 289 | 587 | 146 | 1 | 2023-09-01 | 2308.47 | 57.71 | 2023-08-20 | 5 | 419.78 | 1 | 2308.47 | 5 | SO51089 | 2023-08-27 | 184.68 | 2098.89 | 461.69 | |||
SO58980_11 | 8985-4B66-AD | PO18502175539 | 19 | 291 | 560 | 154 | 6 | 2024-02-01 | 1457.82 | 36.45 | 2024-01-20 | 2 | 755.15 | 1 | 1457.82 | 11 | SO58980 | 2024-01-27 | 116.63 | 1510.30 | 728.91 | |||
SO46608_2 | ACF1-4852-B7 | PO18473177913 | 19 | 291 | 308 | 442 | 6 | 2022-09-01 | 2977.09 | 74.43 | 2022-08-20 | 4 | 660.91 | 1 | 2977.09 | 2 | SO46608 | 2022-08-27 | 238.17 | 2643.66 | 744.27 | |||
SO67305_13 | CBB5-42BF-9E | PO16298111473 | 100 | 287 | 500 | 599 | 4 | 2024-06-02 | 1807.04 | 45.18 | 2024-05-21 | 3 | 601.74 | 1 | 1807.04 | 13 | SO67305 | 2024-05-28 | 144.56 | 1805.23 | 602.35 | |||
SO46993_2 | F652-4085-A4 | PO11658111433 | 100 | 272 | 224 | 2 | 233 | 2 | 1.40 | 2022-10-02 | 70.19 | 1.72 | 2022-09-20 | 14 | 5.23 | 1 | 68.79 | 2 | SO46993 | 2022-09-27 | 5.50 | 73.22 | 5.01 | 0.02 |
SO51127_28 | D321-4FEA-80 | PO2552155165 | 100 | 286 | 544 | 506 | 1 | 2023-09-01 | 194.38 | 4.86 | 2023-08-20 | 4 | 35.96 | 1 | 194.38 | 28 | SO51127 | 2023-08-27 | 15.55 | 143.84 | 48.59 | |||
SO44538_3 | E495-47A9-AD | PO2523126243 | 100 | 287 | 316 | 167 | 4 | 2022-01-02 | 2624.38 | 65.61 | 2021-12-21 | 3 | 884.71 | 1 | 2624.38 | 3 | SO44538 | 2021-12-28 | 209.95 | 2654.12 | 874.79 | |||
SO47028_12 | 8DA0-456D-8F | PO3799132728 | 100 | 282 | 224 | 312 | 4 | 2022-10-02 | 5.19 | 0.13 | 2022-09-20 | 1 | 5.23 | 1 | 5.19 | 12 | SO47028 | 2022-09-27 | 0.41 | 5.23 | 5.19 | |||
SO46957_6 | C98D-43A5-8A | PO16414179284 | 100 | 289 | 410 | 236 | 1 | 2022-10-02 | 364.47 | 9.11 | 2022-09-20 | 10 | 26.97 | 1 | 364.47 | 6 | SO46957 | 2022-09-27 | 29.16 | 269.71 | 36.45 | |||
SO47001_2 | DD9D-4987-9E | PO10121150577 | 100 | 281 | 323 | 684 | 2 | 2022-10-02 | 2348.97 | 58.72 | 2022-09-20 | 5 | 486.71 | 1 | 2348.97 | 2 | SO47001 | 2022-09-27 | 187.92 | 2433.53 | 469.79 | |||
SO48296_32 | FC37-4F3E-BB | PO19401157526 | 19 | 291 | 230 | 173 | 6 | 2023-02-01 | 57.68 | 1.44 | 2023-01-20 | 2 | 29.08 | 1 | 57.68 | 32 | SO48296 | 2023-01-27 | 4.61 | 58.16 | 28.84 | |||
SO47438_8 | 69E0-4082-B4 | PO6757114691 | 100 | 283 | 367 | 21 | 4 | 2022-11-02 | 3239.97 | 81.00 | 2022-10-21 | 5 | 598.44 | 1 | 3239.97 | 8 | SO47438 | 2022-10-28 | 259.20 | 2992.18 | 647.99 | |||
SO69522_22 | 28C3-4615-8B | PO4901187436 | 19 | 284 | 488 | 84 | 6 | 2024-07-02 | 97.18 | 2.43 | 2024-06-20 | 3 | 41.57 | 1 | 97.18 | 22 | SO69522 | 2024-06-27 | 7.77 | 124.72 | 32.39 | |||
SO50314_3 | 5D9A-4B55-81 | PO7627146177 | 100 | 293 | 273 | 433 | 1 | 2023-07-02 | 404.66 | 10.12 | 2023-06-20 | 2 | 187.16 | 1 | 404.66 | 3 | SO50314 | 2023-06-27 | 32.37 | 374.31 | 202.33 | |||
SO44114_7 | 3082-4C08-AA | PO3190199320 | 100 | 281 | 285 | 575 | 2 | 2021-11-02 | 535.74 | 13.39 | 2021-10-21 | 3 | 176.20 | 1 | 535.74 | 7 | SO44114 | 2021-10-28 | 42.86 | 528.60 | 178.58 | |||
SO43872_7 | 52FF-45CD-9B | PO12557127067 | 100 | 282 | 212 | 240 | 4 | 2021-10-02 | 80.75 | 2.02 | 2021-09-20 | 4 | 12.03 | 1 | 80.75 | 7 | SO43872 | 2021-09-27 | 6.46 | 48.11 | 20.19 |
Generated 2024-09-20 02:36:13.533 UTC