[ROOT] dt FactResellerSale < WHERE DimSalesTerritoryId EQ ALL SHUFFLE < SKIP 207 > < TAKE 56 >
56 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 |
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
| SO48384_8 | C99C-4AEC-9E | PO7569115185 | 100 | 287 | 360 | 608 | 4 | 2023-03-27 | 7376.75 | 184.42 | 2023-03-15 | 6 | 1105.81 | 1 | 7376.75 | 8 | SO48384 | 2023-03-22 | 590.14 | 6634.86 | 1229.46 | |||
| SO51793_45 | D763-4929-9B | PO18705168707 | 19 | 291 | 490 | 479 | 6 | 2023-11-25 | 161.97 | 4.05 | 2023-11-13 | 5 | 41.57 | 1 | 161.97 | 45 | SO51793 | 2023-11-20 | 12.96 | 207.86 | 32.39 | |||
| SO48780_1 | F139-41F4-83 | PO5626121558 | 100 | 281 | 273 | 166 | 4 | 2023-04-27 | 809.33 | 20.23 | 2023-04-15 | 4 | 187.16 | 1 | 809.33 | 1 | SO48780 | 2023-04-22 | 64.75 | 748.63 | 202.33 | |||
| SO47693_23 | 3962-4A1A-93 | PO522165713 | 100 | 285 | 453 | 676 | 5 | 2023-01-25 | 215.96 | 5.40 | 2023-01-13 | 6 | 24.75 | 1 | 215.96 | 23 | SO47693 | 2023-01-20 | 17.28 | 148.48 | 35.99 | |||
| SO48746_11 | 3C67-4620-90 | PO2552136060 | 100 | 286 | 360 | 506 | 1 | 2023-04-27 | 9835.67 | 245.89 | 2023-04-15 | 8 | 1105.81 | 1 | 9835.67 | 11 | SO48746 | 2023-04-22 | 786.85 | 8846.48 | 1229.46 | |||
| SO46358_34 | 3BC7-40F4-99 | PO1624111969 | 100 | 283 | 311 | 579 | 3 | 2022-09-25 | 8587.85 | 214.70 | 2022-09-13 | 4 | 2171.29 | 1 | 8587.85 | 34 | SO46358 | 2022-09-20 | 687.03 | 8685.18 | 2146.96 | |||
| SO48017_22 | 40DA-4972-BB | PO11658177389 | 100 | 281 | 394 | 233 | 2 | 2023-02-25 | 20.52 | 0.51 | 2023-02-13 | 1 | 15.18 | 1 | 20.52 | 22 | SO48017 | 2023-02-20 | 1.64 | 15.18 | 20.52 | |||
| SO71844_1 | 410D-4079-9E | PO2813198985 | 100 | 283 | 606 | 90 | 5 | 2024-09-25 | 323.99 | 8.10 | 2024-09-13 | 1 | 343.65 | 1 | 323.99 | 1 | SO71844 | 2024-09-20 | 25.92 | 343.65 | 323.99 | |||
| SO69554_5 | 7525-4F6A-93 | PO8584128240 | 98 | 288 | 545 | 592 | 10 | 2024-08-25 | 48.59 | 1.21 | 2024-08-13 | 2 | 17.98 | 1 | 48.59 | 5 | SO69554 | 2024-08-20 | 3.89 | 35.96 | 24.29 | |||
| SO47014_2 | CBFB-454F-9D | PO2146119554 | 19 | 284 | 401 | 354 | 6 | 2022-11-25 | 65.60 | 1.64 | 2022-11-13 | 1 | 48.55 | 1 | 65.60 | 2 | SO47014 | 2022-11-20 | 5.25 | 48.55 | 65.60 | |||
| SO48296_1 | FC37-4F3E-BB | PO19401157526 | 19 | 291 | 369 | 173 | 6 | 2023-03-27 | 1466.01 | 36.65 | 2023-03-15 | 1 | 1518.79 | 1 | 1466.01 | 1 | SO48296 | 2023-03-22 | 117.28 | 1518.79 | 1466.01 | |||
| SO49884_20 | 822A-428D-94 | PO5626129805 | 100 | 281 | 415 | 166 | 4 | 2023-07-26 | 594.11 | 14.85 | 2023-07-14 | 3 | 146.55 | 1 | 594.11 | 20 | SO49884 | 2023-07-21 | 47.53 | 439.64 | 198.04 | |||
| SO50199_10 | 8C45-47E6-93 | PO17748185472 | 19 | 284 | 383 | 102 | 6 | 2023-08-25 | 1800.79 | 45.02 | 2023-08-13 | 3 | 605.65 | 1 | 1800.79 | 10 | SO50199 | 2023-08-20 | 144.06 | 1816.95 | 600.26 | |||
| SO65172_13 | B28D-458D-90 | PO17371161505 | 6 | 296 | 569 | 688 | 9 | 2024-06-25 | 1336.23 | 33.41 | 2024-06-13 | 3 | 461.44 | 1 | 1336.23 | 13 | SO65172 | 2024-06-20 | 106.90 | 1384.33 | 445.41 | |||
| SO51121_22 | 9E4C-40B6-B1 | PO10730114575 | 100 | 287 | 378 | 491 | 4 | 2023-10-25 | 4398.03 | 109.95 | 2023-10-13 | 3 | 1554.95 | 1 | 4398.03 | 22 | SO51121 | 2023-10-20 | 351.84 | 4664.84 | 1466.01 | |||
| SO53505_17 | B522-40FD-B5 | PO11397144048 | 36 | 295 | 400 | 176 | 8 | 2023-12-26 | 148.61 | 3.72 | 2023-12-14 | 4 | 27.49 | 1 | 148.61 | 17 | SO53505 | 2023-12-21 | 11.89 | 109.97 | 37.15 | |||
| SO51151_31 | D7A9-4DF6-B9 | PO8787179219 | 100 | 282 | 467 | 523 | 3 | 2023-10-25 | 102.86 | 2.57 | 2023-10-13 | 7 | 9.16 | 1 | 102.86 | 31 | SO51151 | 2023-10-20 | 8.23 | 64.12 | 14.69 | |||
| SO65280_27 | FE9D-45E4-AE | PO4814116369 | 36 | 295 | 577 | 464 | 8 | 2024-06-25 | 728.91 | 18.22 | 2024-06-13 | 1 | 755.15 | 1 | 728.91 | 27 | SO65280 | 2024-06-20 | 58.31 | 755.15 | 728.91 | |||
| SO55324_6 | 35BE-456A-B8 | PO8787146999 | 100 | 282 | 477 | 3 | 523 | 3 | 2.74 | 2024-01-25 | 54.89 | 1.30 | 2024-01-13 | 20 | 1.87 | 1 | 52.15 | 6 | SO55324 | 2024-01-20 | 4.17 | 37.33 | 2.74 | 0.05 |
| SO63230_1 | BF4A-4BBC-89 | PO7250182275 | 36 | 295 | 564 | 410 | 8 | 2024-05-27 | 1430.44 | 35.76 | 2024-05-15 | 1 | 1481.94 | 1 | 1430.44 | 1 | SO63230 | 2024-05-22 | 114.44 | 1481.94 | 1430.44 | |||
| SO48320_1 | 3964-4D30-8E | PO14906174466 | 19 | 291 | 458 | 424 | 6 | 2023-03-27 | 44.99 | 1.12 | 2023-03-15 | 1 | 30.93 | 1 | 44.99 | 1 | SO48320 | 2023-03-22 | 3.60 | 30.93 | 44.99 | |||
| SO53605_5 | 6D2A-486B-AC | PO5017132122 | 100 | 289 | 562 | 14 | 308 | 1 | 381.45 | 2023-12-26 | 1907.26 | 38.15 | 2023-12-14 | 2 | 1481.94 | 1 | 1525.80 | 5 | SO53605 | 2023-12-21 | 122.06 | 2963.88 | 953.63 | 0.20 |
| SO61249_14 | 8FD3-4473-B2 | PO4524119518 | 36 | 295 | 605 | 482 | 8 | 2024-04-26 | 647.99 | 16.20 | 2024-04-14 | 2 | 343.65 | 1 | 647.99 | 14 | SO61249 | 2024-04-21 | 51.84 | 687.30 | 323.99 | |||
| SO44081_5 | 32E7-4EA4-9F | PO18299115585 | 19 | 288 | 296 | 118 | 6 | 2021-12-26 | 714.70 | 17.87 | 2021-12-14 | 1 | 617.03 | 1 | 714.70 | 5 | SO44081 | 2021-12-21 | 57.18 | 617.03 | 714.70 | |||
| SO51168_25 | 10E0-426C-9D | PO3509110394 | 36 | 292 | 463 | 139 | 7 | 2023-10-25 | 44.08 | 1.10 | 2023-10-13 | 3 | 9.16 | 1 | 44.08 | 25 | SO51168 | 2023-10-20 | 3.53 | 27.48 | 14.69 | |||
| SO44078_4 | 6487-4A93-82 | PO19169159771 | 100 | 289 | 350 | 272 | 1 | 2021-12-26 | 6074.98 | 151.87 | 2021-12-14 | 3 | 1898.09 | 1 | 6074.98 | 4 | SO44078 | 2021-12-21 | 486.00 | 5694.28 | 2024.99 | |||
| SO49509_13 | 1105-4F75-BE | PO9599181538 | 100 | 285 | 335 | 170 | 5 | 2023-06-25 | 3758.35 | 93.96 | 2023-06-13 | 8 | 486.71 | 1 | 3758.35 | 13 | SO49509 | 2023-06-20 | 300.67 | 3893.65 | 469.79 | |||
| SO63241_8 | 2A80-4F60-8C | PO8642159891 | 98 | 288 | 572 | 520 | 10 | 2024-05-27 | 445.41 | 11.14 | 2024-05-15 | 1 | 461.44 | 1 | 445.41 | 8 | SO63241 | 2024-05-22 | 35.63 | 461.44 | 445.41 | |||
| SO51863_1 | 95F2-4901-BB | PO5046174812 | 100 | 289 | 588 | 596 | 1 | 2023-11-25 | 461.69 | 11.54 | 2023-11-13 | 1 | 419.78 | 1 | 461.69 | 1 | SO51863 | 2023-11-20 | 36.94 | 419.78 | 461.69 | |||
| SO47973_31 | B9F1-47DA-87 | PO18705118148 | 19 | 291 | 370 | 479 | 6 | 2023-02-25 | 1466.01 | 36.65 | 2023-02-13 | 1 | 1518.79 | 1 | 1466.01 | 31 | SO47973 | 2023-02-20 | 117.28 | 1518.79 | 1466.01 | |||
| SO47424_12 | 9DF2-4A59-AE | PO4089167750 | 100 | 285 | 420 | 368 | 5 | 2022-12-26 | 141.62 | 3.54 | 2022-12-14 | 1 | 104.80 | 1 | 141.62 | 12 | SO47424 | 2022-12-21 | 11.33 | 104.80 | 141.62 | |||
| SO51147_39 | C4D7-458D-A6 | PO9831167474 | 100 | 285 | 404 | 81 | 5 | 2023-10-25 | 26.72 | 0.67 | 2023-10-13 | 1 | 19.78 | 1 | 26.72 | 39 | SO51147 | 2023-10-20 | 2.14 | 19.78 | 26.72 | |||
| SO45792_1 | D5D3-43B4-A2 | PO13862173868 | 19 | 288 | 349 | 119 | 6 | 2022-07-26 | 4049.99 | 101.25 | 2022-07-14 | 2 | 1898.09 | 1 | 4049.99 | 1 | SO45792 | 2022-07-21 | 324.00 | 3796.19 | 2024.99 | |||
| SO48730_17 | C918-466B-B1 | PO522152463 | 100 | 285 | 458 | 676 | 5 | 2023-04-27 | 44.99 | 1.12 | 2023-04-15 | 1 | 30.93 | 1 | 44.99 | 17 | SO48730 | 2023-04-22 | 3.60 | 30.93 | 44.99 | |||
| SO57143_1 | 69ED-4172-83 | PO3567189986 | 100 | 292 | 569 | 193 | 7 | 2024-02-25 | 890.82 | 22.27 | 2024-02-13 | 2 | 461.44 | 1 | 890.82 | 1 | SO57143 | 2024-02-20 | 71.27 | 922.89 | 445.41 | |||
| SO46964_22 | B3E6-43CC-A2 | PO15689139014 | 100 | 283 | 375 | 328 | 4 | 2022-11-25 | 2617.88 | 65.45 | 2022-11-13 | 2 | 1320.68 | 1 | 2617.88 | 22 | SO46964 | 2022-11-20 | 209.43 | 2641.37 | 1308.94 | |||
| SO69461_7 | F8C1-4A85-91 | PO1508119064 | 98 | 288 | 225 | 430 | 10 | 2024-08-25 | 37.76 | 0.94 | 2024-08-13 | 7 | 6.92 | 1 | 37.76 | 7 | SO69461 | 2024-08-20 | 3.02 | 48.46 | 5.39 | |||
| SO55297_53 | 2455-4B60-A5 | PO4495126679 | 19 | 291 | 558 | 496 | 6 | 2024-01-25 | 728.98 | 18.22 | 2024-01-13 | 3 | 179.82 | 1 | 728.98 | 53 | SO55297 | 2024-01-20 | 58.32 | 539.45 | 242.99 | |||
| SO46604_36 | 8062-4A97-B3 | PO522154989 | 100 | 285 | 213 | 8 | 676 | 5 | 6.73 | 2022-10-25 | 67.29 | 1.51 | 2022-10-13 | 4 | 13.88 | 1 | 60.56 | 36 | SO46604 | 2022-10-20 | 4.84 | 55.51 | 16.82 | 0.10 |
| SO44296_4 | DE85-42AB-AC | PO12412194442 | 100 | 283 | 215 | 670 | 3 | 2022-01-25 | 100.93 | 2.52 | 2022-01-13 | 5 | 12.03 | 1 | 100.93 | 4 | SO44296 | 2022-01-20 | 8.07 | 60.14 | 20.19 | |||
| SO63225_13 | 016B-4765-8A | PO10266190042 | 6 | 296 | 586 | 393 | 9 | 2024-05-27 | 445.41 | 11.14 | 2024-05-15 | 1 | 461.44 | 1 | 445.41 | 13 | SO63225 | 2024-05-22 | 35.63 | 461.44 | 445.41 | |||
| SO69529_1 | D890-4BC3-89 | PO5046186347 | 100 | 289 | 593 | 16 | 596 | 1 | 45.20 | 2024-08-25 | 113.00 | 1.70 | 2024-08-13 | 1 | 308.22 | 1 | 67.80 | 1 | SO69529 | 2024-08-20 | 5.42 | 308.22 | 113.00 | 0.40 |
| SO48791_17 | 9EBF-4C7E-82 | PO8787123349 | 100 | 282 | 456 | 523 | 3 | 2023-04-27 | 134.98 | 3.37 | 2023-04-15 | 3 | 30.93 | 1 | 134.98 | 17 | SO48791 | 2023-04-22 | 10.80 | 92.80 | 44.99 | |||
| SO59063_28 | 81BA-420E-80 | PO8468196044 | 98 | 288 | 390 | 16 | 10 | 2024-03-26 | 2689.18 | 67.23 | 2024-03-14 | 4 | 713.08 | 1 | 2689.18 | 28 | SO59063 | 2024-03-21 | 215.13 | 2852.32 | 672.29 | |||
| SO48306_9 | EA27-471A-9D | PO17574166075 | 19 | 291 | 391 | 678 | 6 | 2023-03-27 | 355.73 | 8.89 | 2023-03-15 | 4 | 65.81 | 1 | 355.73 | 9 | SO48306 | 2023-03-22 | 28.46 | 263.24 | 88.93 | |||
| SO48310_1 | B389-4D7D-85 | PO17139173607 | 100 | 293 | 375 | 644 | 1 | 2023-03-27 | 1308.94 | 32.72 | 2023-03-15 | 1 | 1320.68 | 1 | 1308.94 | 1 | SO48310 | 2023-03-22 | 104.72 | 1320.68 | 1308.94 | |||
| SO53470_26 | 932B-41E0-AF | PO17052111209 | 100 | 282 | 570 | 13 | 420 | 4 | 50.11 | 2023-12-26 | 334.06 | 7.10 | 2023-12-14 | 1 | 461.44 | 1 | 283.95 | 26 | SO53470 | 2023-12-21 | 22.72 | 461.44 | 334.06 | 0.15 |
| SO58924_7 | D17F-4E31-90 | PO15457121920 | 100 | 285 | 565 | 297 | 5 | 2024-03-26 | 445.41 | 11.14 | 2024-03-14 | 1 | 461.44 | 1 | 445.41 | 7 | SO58924 | 2024-03-21 | 35.63 | 461.44 | 445.41 | |||
| SO65207_17 | B20E-440F-A3 | PO1537156240 | 100 | 285 | 523 | 611 | 5 | 2024-06-25 | 63.17 | 1.58 | 2024-06-13 | 2 | 23.37 | 1 | 63.17 | 17 | SO65207 | 2024-06-20 | 5.05 | 46.74 | 31.58 | |||
| SO71808_16 | 2E63-4616-B1 | PO14761198562 | 19 | 284 | 568 | 408 | 6 | 2024-09-25 | 890.82 | 22.27 | 2024-09-13 | 2 | 461.44 | 1 | 890.82 | 16 | SO71808 | 2024-09-20 | 71.27 | 922.89 | 445.41 | |||
| SO47726_21 | 7256-4599-93 | PO9657190563 | 100 | 285 | 233 | 315 | 5 | 2023-01-25 | 86.52 | 2.16 | 2023-01-13 | 3 | 29.08 | 1 | 86.52 | 21 | SO47726 | 2023-01-20 | 6.92 | 87.24 | 28.84 | |||
| SO49888_6 | 01BB-49D0-BD | PO6699147895 | 100 | 283 | 375 | 234 | 2 | 2023-07-26 | 3926.81 | 98.17 | 2023-07-14 | 3 | 1320.68 | 1 | 3926.81 | 6 | SO49888 | 2023-07-21 | 314.15 | 3962.05 | 1308.94 | |||
| SO67282_26 | 50CB-4642-B1 | PO11687162635 | 100 | 283 | 571 | 691 | 2 | 2024-07-26 | 890.82 | 22.27 | 2024-07-14 | 2 | 461.44 | 1 | 890.82 | 26 | SO67282 | 2024-07-21 | 71.27 | 922.89 | 445.41 | |||
| SO44115_11 | 5360-4C42-90 | PO3248122509 | 100 | 282 | 351 | 366 | 4 | 2021-12-26 | 8099.98 | 202.50 | 2021-12-14 | 4 | 1898.09 | 1 | 8099.98 | 11 | SO44115 | 2021-12-21 | 648.00 | 7592.38 | 2024.99 | |||
| SO51148_28 | 1D20-490E-98 | PO6612158387 | 100 | 286 | 558 | 110 | 1 | 2023-10-25 | 728.98 | 18.22 | 2023-10-13 | 3 | 179.82 | 1 | 728.98 | 28 | SO51148 | 2023-10-20 | 58.32 | 539.45 | 242.99 | |||
| SO57026_17 | CD5A-4300-81 | PO16675118038 | 100 | 293 | 568 | 361 | 1 | 2024-02-25 | 445.41 | 11.14 | 2024-02-13 | 1 | 461.44 | 1 | 445.41 | 17 | SO57026 | 2024-02-20 | 35.63 | 461.44 | 445.41 |
Generated 2024-11-13 03:23:40.063 UTC