[ROOT] dt FactResellerSale < WHERE DimSalesTerritoryId EQ ALL SHUFFLE < SKIP 114 > < 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 |
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
| SO71945_16 | 2AA4-4D12-9F | PO9396160769 | 6 | 296 | 555 | 267 | 9 | 2024-08-04 | 191.70 | 4.79 | 2024-07-23 | 3 | 47.29 | 1 | 191.70 | 16 | SO71945 | 2024-07-30 | 15.34 | 141.86 | 63.90 | |||
| SO48001_18 | 02F1-4434-99 | PO14442151969 | 100 | 293 | 410 | 127 | 1 | 2023-01-04 | 36.45 | 0.91 | 2022-12-23 | 1 | 26.97 | 1 | 36.45 | 18 | SO48001 | 2022-12-30 | 2.92 | 26.97 | 36.45 | |||
| SO49103_1 | 0B8A-4326-8A | PO17748175932 | 19 | 284 | 389 | 102 | 6 | 2023-04-06 | 600.26 | 15.01 | 2023-03-25 | 1 | 605.65 | 1 | 600.26 | 1 | SO49103 | 2023-04-01 | 48.02 | 605.65 | 600.26 | |||
| SO44772_11 | F5E6-4B81-A3 | PO1624122637 | 100 | 283 | 264 | 579 | 3 | 2022-02-03 | 367.88 | 9.20 | 2022-01-22 | 2 | 181.49 | 1 | 367.88 | 11 | SO44772 | 2022-01-29 | 29.43 | 362.97 | 183.94 | |||
| SO57141_13 | 5DE1-45D6-8B | PO3625112721 | 100 | 283 | 436 | 666 | 2 | 2024-01-04 | 713.80 | 17.84 | 2023-12-23 | 2 | 360.94 | 1 | 713.80 | 13 | SO57141 | 2023-12-30 | 57.10 | 721.89 | 356.90 | |||
| SO47403_38 | 60A2-4F08-8B | PO841143108 | 100 | 286 | 224 | 254 | 1 | 2022-11-04 | 51.87 | 1.30 | 2022-10-23 | 10 | 5.23 | 1 | 51.87 | 38 | SO47403 | 2022-10-30 | 4.15 | 52.30 | 5.19 | |||
| SO67315_5 | 02BE-4BB0-BD | PO7105133864 | 100 | 293 | 481 | 668 | 1 | 2024-06-04 | 37.76 | 0.94 | 2024-05-23 | 7 | 3.36 | 1 | 37.76 | 5 | SO67315 | 2024-05-30 | 3.02 | 23.54 | 5.39 | |||
| SO43884_4 | 728A-44AB-A8 | PO10440182311 | 100 | 283 | 232 | 623 | 3 | 2021-10-04 | 288.40 | 7.21 | 2021-09-22 | 10 | 31.72 | 1 | 288.40 | 4 | SO43884 | 2021-09-29 | 23.07 | 317.24 | 28.84 | |||
| SO63173_2 | CE32-441D-BF | PO1508158507 | 98 | 290 | 471 | 430 | 10 | 2024-04-05 | 228.60 | 5.72 | 2024-03-24 | 6 | 23.75 | 1 | 228.60 | 2 | SO63173 | 2024-03-31 | 18.29 | 142.49 | 38.10 | |||
| SO48311_1 | AAD7-4EBC-A1 | PO16472177233 | 100 | 287 | 389 | 239 | 4 | 2023-02-03 | 3001.31 | 75.03 | 2023-01-22 | 5 | 605.65 | 1 | 3001.31 | 1 | SO48311 | 2023-01-29 | 240.11 | 3028.25 | 600.26 | |||
| SO57026_42 | CD5A-4300-81 | PO16675118038 | 100 | 293 | 563 | 361 | 1 | 2024-01-04 | 1430.44 | 35.76 | 2023-12-23 | 1 | 1481.94 | 1 | 1430.44 | 42 | SO57026 | 2023-12-30 | 114.44 | 1481.94 | 1430.44 | |||
| SO48328_16 | 5992-4AF8-B1 | PO13543152596 | 100 | 287 | 365 | 293 | 1 | 2023-02-03 | 3239.97 | 81.00 | 2023-01-22 | 5 | 598.44 | 1 | 3239.97 | 16 | SO48328 | 2023-01-29 | 259.20 | 2992.18 | 647.99 | |||
| SO65224_16 | 6213-43FA-9B | PO10353176854 | 98 | 288 | 400 | 88 | 10 | 2024-05-04 | 37.15 | 0.93 | 2024-04-22 | 1 | 27.49 | 1 | 37.15 | 16 | SO65224 | 2024-04-29 | 2.97 | 27.49 | 37.15 | |||
| SO69414_13 | 47BD-4582-A4 | PO15283145065 | 100 | 281 | 506 | 363 | 3 | 2024-07-04 | 400.10 | 10.00 | 2024-06-22 | 2 | 199.85 | 1 | 400.10 | 13 | SO69414 | 2024-06-29 | 32.01 | 399.70 | 200.05 | |||
| SO51824_33 | A1F7-477E-BA | PO5800114202 | 100 | 285 | 544 | 63 | 5 | 2023-10-04 | 97.19 | 2.43 | 2023-09-22 | 2 | 35.96 | 1 | 97.19 | 33 | SO51824 | 2023-09-29 | 7.78 | 71.92 | 48.59 | |||
| SO50746_7 | 1B61-4F3B-85 | PO5510129653 | 100 | 287 | 329 | 5 | 4 | 2023-08-04 | 939.59 | 23.49 | 2023-07-23 | 2 | 486.71 | 1 | 939.59 | 7 | SO50746 | 2023-07-30 | 75.17 | 973.41 | 469.79 | |||
| SO46630_9 | F512-40F2-91 | PO12644161356 | 100 | 285 | 216 | 8 | 530 | 5 | 6.73 | 2022-09-03 | 67.29 | 1.51 | 2022-08-22 | 4 | 13.88 | 1 | 60.56 | 9 | SO46630 | 2022-08-29 | 4.84 | 55.51 | 16.82 | 0.10 |
| SO48791_8 | 9EBF-4C7E-82 | PO8787123349 | 100 | 282 | 381 | 523 | 3 | 2023-03-06 | 600.26 | 15.01 | 2023-02-22 | 1 | 605.65 | 1 | 600.26 | 8 | SO48791 | 2023-03-01 | 48.02 | 605.65 | 600.26 | |||
| SO47965_17 | 953F-437D-84 | PO19546111394 | 100 | 285 | 381 | 206 | 5 | 2023-01-04 | 1800.79 | 45.02 | 2022-12-23 | 3 | 605.65 | 1 | 1800.79 | 17 | SO47965 | 2022-12-30 | 144.06 | 1816.95 | 600.26 | |||
| SO47454_19 | E249-41EE-95 | PO9570119946 | 100 | 285 | 461 | 585 | 5 | 2022-11-04 | 53.99 | 1.35 | 2022-10-23 | 1 | 37.12 | 1 | 53.99 | 19 | SO47454 | 2022-10-30 | 4.32 | 37.12 | 53.99 | |||
| SO63136_18 | 0873-484A-AE | PO18328125904 | 19 | 284 | 380 | 552 | 6 | 2024-04-05 | 4398.03 | 109.95 | 2024-03-24 | 3 | 1554.95 | 1 | 4398.03 | 18 | SO63136 | 2024-03-31 | 351.84 | 4664.84 | 1466.01 | |||
| SO69411_7 | E0BB-44D1-83 | PO15921144493 | 100 | 287 | 225 | 77 | 4 | 2024-07-04 | 5.39 | 0.13 | 2024-06-22 | 1 | 6.92 | 1 | 5.39 | 7 | SO69411 | 2024-06-29 | 0.43 | 6.92 | 5.39 | |||
| SO61175_12 | 5850-42D5-A1 | PO19575149991 | 98 | 288 | 603 | 34 | 10 | 2024-03-05 | 291.58 | 7.29 | 2024-02-22 | 4 | 53.94 | 1 | 291.58 | 12 | SO61175 | 2024-02-29 | 23.33 | 215.77 | 72.89 | |||
| SO61264_14 | 5396-4F0C-B0 | PO5626112601 | 100 | 281 | 545 | 166 | 4 | 2024-03-05 | 97.18 | 2.43 | 2024-02-22 | 4 | 17.98 | 1 | 97.18 | 14 | SO61264 | 2024-02-29 | 7.77 | 71.91 | 24.29 | |||
| SO69503_2 | 559D-4568-82 | PO5771124379 | 100 | 282 | 376 | 79 | 3 | 2024-07-04 | 2932.02 | 73.30 | 2024-06-22 | 2 | 1554.95 | 1 | 2932.02 | 2 | SO69503 | 2024-06-29 | 234.56 | 3109.90 | 1466.01 | |||
| SO47362_2 | 41E3-4BA0-99 | PO17690189228 | 19 | 291 | 399 | 47 | 6 | 2022-11-04 | 168.87 | 4.22 | 2022-10-23 | 5 | 24.99 | 1 | 168.87 | 2 | SO47362 | 2022-10-30 | 13.51 | 124.97 | 33.77 | |||
| SO48336_50 | 48F2-4141-9A | PO11455111823 | 100 | 281 | 433 | 72 | 2 | 2023-02-03 | 1297.81 | 32.45 | 2023-01-22 | 4 | 300.12 | 1 | 1297.81 | 50 | SO48336 | 2023-01-29 | 103.82 | 1200.48 | 324.45 | |||
| SO46347_3 | 33F9-487C-A3 | PO13717117301 | 100 | 287 | 340 | 473 | 4 | 2022-08-04 | 419.46 | 10.49 | 2022-07-23 | 1 | 413.15 | 1 | 419.46 | 3 | SO46347 | 2022-07-30 | 33.56 | 413.15 | 419.46 | |||
| SO61181_5 | EF82-40B7-8E | PO17197117656 | 100 | 283 | 595 | 125 | 2 | 2024-03-05 | 677.99 | 16.95 | 2024-02-22 | 2 | 308.22 | 1 | 677.99 | 5 | SO61181 | 2024-02-29 | 54.24 | 616.44 | 338.99 | |||
| SO44767_2 | 8497-4169-8D | PO10382198343 | 100 | 283 | 347 | 453 | 3 | 2022-02-03 | 6119.98 | 153.00 | 2022-01-22 | 3 | 1912.15 | 1 | 6119.98 | 2 | SO44767 | 2022-01-29 | 489.60 | 5736.46 | 2039.99 | |||
| SO49139_5 | 2662-4BFD-96 | PO4843131080 | 100 | 287 | 339 | 257 | 4 | 2023-04-06 | 469.79 | 11.74 | 2023-03-25 | 1 | 486.71 | 1 | 469.79 | 5 | SO49139 | 2023-04-01 | 37.58 | 486.71 | 469.79 | |||
| SO57016_2 | 5FA2-418F-AF | PO19227187256 | 19 | 284 | 481 | 210 | 6 | 2024-01-04 | 5.39 | 0.13 | 2023-12-23 | 1 | 3.36 | 1 | 5.39 | 2 | SO57016 | 2023-12-30 | 0.43 | 3.36 | 5.39 | |||
| SO50671_7 | 9526-4D73-83 | PO17139132177 | 100 | 293 | 335 | 644 | 1 | 2023-08-04 | 939.59 | 23.49 | 2023-07-23 | 2 | 486.71 | 1 | 939.59 | 7 | SO50671 | 2023-07-30 | 75.17 | 973.41 | 469.79 | |||
| SO51836_26 | 8AA7-498C-8C | PO6351139034 | 100 | 281 | 547 | 255 | 4 | 2023-10-04 | 48.59 | 1.21 | 2023-09-22 | 1 | 35.96 | 1 | 48.59 | 26 | SO51836 | 2023-09-29 | 3.89 | 35.96 | 48.59 | |||
| SO59066_2 | 9FAA-410F-AB | PO9309141643 | 100 | 293 | 578 | 55 | 1 | 2024-02-03 | 2186.73 | 54.67 | 2024-01-22 | 3 | 755.15 | 1 | 2186.73 | 2 | SO59066 | 2024-01-29 | 174.94 | 2265.45 | 728.91 | |||
| SO61263_28 | 729E-4D96-91 | PO5452121402 | 36 | 295 | 499 | 320 | 8 | 2024-03-05 | 3011.73 | 75.29 | 2024-02-22 | 5 | 601.74 | 1 | 3011.73 | 28 | SO61263 | 2024-02-29 | 240.94 | 3008.72 | 602.35 | |||
| SO50197_2 | 626D-425C-BA | PO17777156799 | 19 | 291 | 377 | 208 | 6 | 2023-07-04 | 2617.88 | 65.45 | 2023-06-22 | 2 | 1320.68 | 1 | 2617.88 | 2 | SO50197 | 2023-06-29 | 209.43 | 2641.37 | 1308.94 | |||
| SO53513_17 | 5E21-438C-B3 | PO10875194431 | 19 | 291 | 565 | 13 | 281 | 6 | 551.19 | 2023-11-04 | 3674.63 | 78.09 | 2023-10-23 | 11 | 461.44 | 1 | 3123.44 | 17 | SO53513 | 2023-10-30 | 249.88 | 5075.89 | 334.06 | 0.15 |
| SO49849_30 | C8F3-4DDE-A6 | PO2552190786 | 100 | 286 | 456 | 506 | 1 | 2023-06-04 | 89.99 | 2.25 | 2023-05-23 | 2 | 30.93 | 1 | 89.99 | 30 | SO49849 | 2023-05-30 | 7.20 | 61.87 | 44.99 | |||
| SO49513_6 | 1A8D-4D25-AE | PO10962181499 | 19 | 284 | 366 | 685 | 6 | 2023-05-04 | 1295.99 | 32.40 | 2023-04-22 | 2 | 598.44 | 1 | 1295.99 | 6 | SO49513 | 2023-04-29 | 103.68 | 1196.87 | 647.99 | |||
| SO47359_45 | 8BC9-458A-82 | PO18299145297 | 19 | 291 | 358 | 118 | 6 | 2022-11-04 | 4917.84 | 122.95 | 2022-10-23 | 4 | 1105.81 | 1 | 4917.84 | 45 | SO47359 | 2022-10-30 | 393.43 | 4423.24 | 1229.46 | |||
| SO58976_1 | 3BF9-484F-A1 | PO20213146485 | 100 | 283 | 477 | 216 | 2 | 2024-02-03 | 14.97 | 0.37 | 2024-01-22 | 5 | 1.87 | 1 | 14.97 | 1 | SO58976 | 2024-01-29 | 1.20 | 9.33 | 2.99 | |||
| SO45549_21 | E477-44D2-B0 | PO783111978 | 100 | 286 | 310 | 91 | 1 | 2022-05-04 | 6440.89 | 161.02 | 2022-04-22 | 3 | 2171.29 | 1 | 6440.89 | 21 | SO45549 | 2022-04-29 | 515.27 | 6513.88 | 2146.96 | |||
| SO49095_4 | EDD6-411E-A3 | PO18676116817 | 100 | 282 | 354 | 697 | 1 | 2023-04-06 | 3728.56 | 93.21 | 2023-03-25 | 3 | 1117.86 | 1 | 3728.56 | 4 | SO49095 | 2023-04-01 | 298.28 | 3353.57 | 1242.85 | |||
| SO44534_6 | 07F6-4A99-A3 | PO2146113582 | 19 | 284 | 296 | 354 | 6 | 2022-01-04 | 714.70 | 17.87 | 2021-12-23 | 1 | 617.03 | 1 | 714.70 | 6 | SO44534 | 2021-12-30 | 57.18 | 617.03 | 714.70 | |||
| SO69467_4 | A38D-4E1B-93 | PO2871181396 | 100 | 283 | 586 | 522 | 2 | 2024-07-04 | 890.82 | 22.27 | 2024-06-22 | 2 | 461.44 | 1 | 890.82 | 4 | SO69467 | 2024-06-29 | 71.27 | 922.89 | 445.41 | |||
| SO65209_9 | B869-4DFD-AB | PO2697179473 | 100 | 282 | 524 | 187 | 4 | 2024-05-04 | 158.43 | 3.96 | 2024-04-22 | 1 | 144.59 | 1 | 158.43 | 9 | SO65209 | 2024-04-29 | 12.67 | 144.59 | 158.43 | |||
| SO63149_1 | 7EF2-4565-86 | PO16414166653 | 100 | 289 | 516 | 236 | 1 | 2024-04-05 | 23.48 | 0.59 | 2024-03-24 | 1 | 17.38 | 1 | 23.48 | 1 | SO63149 | 2024-03-31 | 1.88 | 17.38 | 23.48 | |||
| SO49877_5 | 493D-497C-AB | PO3828147687 | 100 | 283 | 360 | 414 | 2 | 2023-06-04 | 4917.84 | 122.95 | 2023-05-23 | 4 | 1105.81 | 1 | 4917.84 | 5 | SO49877 | 2023-05-30 | 393.43 | 4423.24 | 1229.46 | |||
| SO43860_5 | E57D-4B4B-BF | PO16646146654 | 100 | 286 | 275 | 1 | 1 | 2021-10-04 | 356.90 | 8.92 | 2021-09-22 | 1 | 352.14 | 1 | 356.90 | 5 | SO43860 | 2021-09-29 | 28.55 | 352.14 | 356.90 | |||
| SO48307_21 | 7DE5-4D74-A7 | PO17545123793 | 19 | 291 | 458 | 155 | 6 | 2023-02-03 | 404.95 | 10.12 | 2023-01-22 | 9 | 30.93 | 1 | 404.95 | 21 | SO48307 | 2023-01-29 | 32.40 | 278.40 | 44.99 | |||
| SO61230_30 | B9F1-4FF8-B4 | PO12644163346 | 100 | 285 | 491 | 530 | 5 | 2024-03-05 | 226.76 | 5.67 | 2024-02-22 | 7 | 41.57 | 1 | 226.76 | 30 | SO61230 | 2024-02-29 | 18.14 | 291.01 | 32.39 | |||
| SO57068_20 | 0E44-4044-B3 | PO11223190191 | 100 | 292 | 599 | 632 | 7 | 2024-01-04 | 1295.98 | 32.40 | 2023-12-23 | 4 | 294.58 | 1 | 1295.98 | 20 | SO57068 | 2023-12-30 | 103.68 | 1178.32 | 323.99 | |||
| SO51129_3 | 159A-4E9A-B1 | PO3016196014 | 100 | 281 | 477 | 183 | 3 | 2023-09-03 | 2.99 | 0.07 | 2023-08-22 | 1 | 1.87 | 1 | 2.99 | 3 | SO51129 | 2023-08-29 | 0.24 | 1.87 | 2.99 | |||
| SO59021_12 | A306-4E83-B7 | PO7395154426 | 100 | 286 | 600 | 542 | 1 | 2024-02-03 | 971.98 | 24.30 | 2024-01-22 | 3 | 294.58 | 1 | 971.98 | 12 | SO59021 | 2024-01-29 | 77.76 | 883.74 | 323.99 | |||
| SO48385_6 | 753C-4EBE-B8 | PO7946110963 | 100 | 282 | 333 | 438 | 1 | 2023-02-03 | 469.79 | 11.74 | 2023-01-22 | 1 | 486.71 | 1 | 469.79 | 6 | SO48385 | 2023-01-29 | 37.58 | 486.71 | 469.79 |
Generated 2024-09-21 06:41:28.854 UTC