[ROOT] dt FactResellerSale < WHERE DimSalesTerritoryId EQ ALL SHUFFLE < SKIP 356 > < 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 |
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
| SO49129_23 | 1D0F-41F4-9F | PO12702195272 | 100 | 292 | 447 | 175 | 7 | 2023-05-26 | 60.00 | 1.50 | 2023-05-14 | 4 | 10.31 | 1 | 60.00 | 23 | SO49129 | 2023-05-21 | 4.80 | 41.25 | 15.00 | |||
| SO65191_23 | 1CE2-46FD-83 | PO14703119228 | 6 | 296 | 471 | 3 | 573 | 9 | 31.43 | 2024-06-23 | 628.65 | 14.93 | 2024-06-11 | 18 | 23.75 | 1 | 597.22 | 23 | SO65191 | 2024-06-18 | 47.78 | 427.48 | 34.93 | 0.05 |
| SO45296_11 | 1FA6-4616-B7 | PO14471199142 | 100 | 286 | 232 | 145 | 1 | 2022-05-26 | 57.68 | 1.44 | 2022-05-14 | 2 | 31.72 | 1 | 57.68 | 11 | SO45296 | 2022-05-21 | 4.61 | 63.45 | 28.84 | |||
| SO65245_25 | 80F6-437F-84 | PO9628129233 | 100 | 283 | 471 | 179 | 2 | 2024-06-23 | 152.40 | 3.81 | 2024-06-11 | 4 | 23.75 | 1 | 152.40 | 25 | SO65245 | 2024-06-18 | 12.19 | 95.00 | 38.10 | |||
| SO63129_1 | 8D7E-4578-92 | PO18821188245 | 36 | 292 | 475 | 686 | 7 | 2024-05-25 | 41.99 | 1.05 | 2024-05-13 | 1 | 26.18 | 1 | 41.99 | 1 | SO63129 | 2024-05-20 | 3.36 | 26.18 | 41.99 | |||
| SO48028_7 | B23F-4743-B9 | PO928137953 | 98 | 288 | 216 | 484 | 10 | 2023-02-23 | 161.49 | 4.04 | 2023-02-11 | 8 | 13.88 | 1 | 161.49 | 7 | SO48028 | 2023-02-18 | 12.92 | 111.03 | 20.19 | |||
| SO71844_7 | 410D-4079-9E | PO2813198985 | 100 | 283 | 234 | 90 | 5 | 2024-09-23 | 299.94 | 7.50 | 2024-09-11 | 10 | 38.49 | 1 | 299.94 | 7 | SO71844 | 2024-09-18 | 24.00 | 384.92 | 29.99 | |||
| SO53584_2 | BB5C-4DD6-B2 | PO7192178651 | 100 | 289 | 359 | 20 | 1 | 2023-12-24 | 2753.99 | 68.85 | 2023-12-12 | 2 | 1251.98 | 1 | 2753.99 | 2 | SO53584 | 2023-12-19 | 220.32 | 2503.96 | 1376.99 | |||
| SO57185_6 | 683A-464C-8C | PO8729178515 | 98 | 290 | 579 | 556 | 10 | 2024-02-23 | 3644.55 | 91.11 | 2024-02-11 | 5 | 755.15 | 1 | 3644.55 | 6 | SO57185 | 2024-02-18 | 291.56 | 3775.75 | 728.91 | |||
| SO44079_8 | A180-4128-A7 | PO19488118734 | 100 | 283 | 328 | 57 | 3 | 2021-12-24 | 1677.84 | 41.95 | 2021-12-12 | 4 | 413.15 | 1 | 1677.84 | 8 | SO44079 | 2021-12-19 | 134.23 | 1652.59 | 419.46 | |||
| SO53567_22 | 2385-4ADE-B6 | PO9628113784 | 100 | 283 | 214 | 179 | 2 | 2023-12-24 | 125.96 | 3.15 | 2023-12-12 | 6 | 13.09 | 1 | 125.96 | 22 | SO53567 | 2023-12-19 | 10.08 | 78.52 | 20.99 | |||
| SO45318_11 | 13CE-461F-B9 | PO2900174093 | 100 | 286 | 349 | 469 | 1 | 2022-05-26 | 8099.98 | 202.50 | 2022-05-14 | 4 | 1898.09 | 1 | 8099.98 | 11 | SO45318 | 2022-05-21 | 648.00 | 7592.38 | 2024.99 | |||
| SO47006_18 | 142D-4F23-BF | PO957186440 | 98 | 288 | 469 | 2 | 376 | 10 | 5.29 | 2022-11-23 | 264.41 | 6.48 | 2022-11-11 | 12 | 15.67 | 1 | 259.12 | 18 | SO47006 | 2022-11-18 | 20.73 | 188.05 | 22.03 | 0.02 |
| SO67277_29 | 9AB3-4F34-85 | PO12644174121 | 100 | 272 | 353 | 530 | 5 | 2024-07-24 | 5567.98 | 139.20 | 2024-07-12 | 4 | 1265.62 | 1 | 5567.98 | 29 | SO67277 | 2024-07-19 | 445.44 | 5062.48 | 1391.99 | |||
| SO50746_10 | 1B61-4F3B-85 | PO5510129653 | 100 | 287 | 333 | 5 | 4 | 2023-09-23 | 1409.38 | 35.23 | 2023-09-11 | 3 | 486.71 | 1 | 1409.38 | 10 | SO50746 | 2023-09-18 | 112.75 | 1460.12 | 469.79 | |||
| SO48083_4 | E4B1-4D02-90 | PO7917164304 | 100 | 287 | 224 | 401 | 1 | 2023-02-23 | 46.68 | 1.17 | 2023-02-11 | 9 | 5.23 | 1 | 46.68 | 4 | SO48083 | 2023-02-18 | 3.73 | 47.07 | 5.19 | |||
| SO48747_4 | EC0D-4B9B-B3 | PO2929132599 | 100 | 289 | 468 | 380 | 1 | 2023-04-25 | 22.79 | 0.57 | 2023-04-13 | 1 | 15.67 | 1 | 22.79 | 4 | SO48747 | 2023-04-20 | 1.82 | 15.67 | 22.79 | |||
| SO58925_5 | ACBD-43C3-A2 | PO15544139465 | 19 | 284 | 570 | 282 | 6 | 2024-03-24 | 445.41 | 11.14 | 2024-03-12 | 1 | 461.44 | 1 | 445.41 | 5 | SO58925 | 2024-03-19 | 35.63 | 461.44 | 445.41 | |||
| SO47356_1 | ED57-4277-84 | PO18589189544 | 100 | 292 | 321 | 67 | 7 | 2022-12-24 | 469.79 | 11.74 | 2022-12-12 | 1 | 486.71 | 1 | 469.79 | 1 | SO47356 | 2022-12-19 | 37.58 | 486.71 | 469.79 | |||
| SO59059_2 | FD9E-44C4-97 | PO7482187440 | 100 | 293 | 492 | 163 | 1 | 2024-03-24 | 3011.73 | 75.29 | 2024-03-12 | 5 | 601.74 | 1 | 3011.73 | 2 | SO59059 | 2024-03-19 | 240.94 | 3008.72 | 602.35 | |||
| SO71802_17 | 6B80-41A7-89 | PO15457184141 | 100 | 285 | 560 | 297 | 5 | 2024-09-23 | 728.91 | 18.22 | 2024-09-11 | 1 | 755.15 | 1 | 728.91 | 17 | SO71802 | 2024-09-18 | 58.31 | 755.15 | 728.91 | |||
| SO43869_1 | 96FA-4DF1-81 | PO14500145975 | 100 | 282 | 304 | 650 | 1 | 2021-11-23 | 714.70 | 17.87 | 2021-11-11 | 1 | 617.03 | 1 | 714.70 | 1 | SO43869 | 2021-11-18 | 57.18 | 617.03 | 714.70 | |||
| SO50745_31 | 02DB-4CC5-85 | PO5539140407 | 100 | 282 | 464 | 61 | 4 | 2023-09-23 | 84.77 | 2.12 | 2023-09-11 | 6 | 9.71 | 1 | 84.77 | 31 | SO50745 | 2023-09-18 | 6.78 | 58.28 | 14.13 | |||
| SO46638_23 | 9659-44CE-A2 | PO10817110834 | 100 | 287 | 286 | 203 | 4 | 2022-10-23 | 367.88 | 9.20 | 2022-10-11 | 2 | 170.14 | 1 | 367.88 | 23 | SO46638 | 2022-10-18 | 29.43 | 340.29 | 183.94 | |||
| SO58942_1 | 5900-4D8F-A6 | PO13021136057 | 100 | 282 | 380 | 276 | 4 | 2024-03-24 | 1466.01 | 36.65 | 2024-03-12 | 1 | 1554.95 | 1 | 1466.01 | 1 | SO58942 | 2024-03-19 | 117.28 | 1554.95 | 1466.01 | |||
| SO48049_33 | C09A-49F5-80 | PO3799136256 | 100 | 282 | 308 | 312 | 4 | 2023-02-23 | 2232.82 | 55.82 | 2023-02-11 | 3 | 660.91 | 1 | 2232.82 | 33 | SO48049 | 2023-02-18 | 178.63 | 1982.74 | 744.27 | |||
| SO50678_1 | CAED-407A-BA | PO13543174640 | 100 | 287 | 395 | 293 | 1 | 2023-09-23 | 245.50 | 6.14 | 2023-09-11 | 4 | 45.42 | 1 | 245.50 | 1 | SO50678 | 2023-09-18 | 19.64 | 181.67 | 61.37 | |||
| SO51830_7 | EBE1-4015-AE | PO7627127132 | 100 | 272 | 374 | 433 | 1 | 2023-11-23 | 13194.09 | 329.85 | 2023-11-11 | 9 | 1554.95 | 1 | 13194.09 | 7 | SO51830 | 2023-11-18 | 1055.53 | 13994.53 | 1466.01 | |||
| SO49826_12 | 2EBD-4312-9C | PO16588178669 | 100 | 289 | 458 | 146 | 1 | 2023-07-24 | 179.98 | 4.50 | 2023-07-12 | 4 | 30.93 | 1 | 179.98 | 12 | SO49826 | 2023-07-19 | 14.40 | 123.73 | 44.99 | |||
| SO65202_2 | 1802-4CA2-B9 | PO1073154434 | 36 | 295 | 546 | 284 | 8 | 2024-06-23 | 37.25 | 0.93 | 2024-06-11 | 1 | 27.57 | 1 | 37.25 | 2 | SO65202 | 2024-06-18 | 2.98 | 27.57 | 37.25 | |||
| SO65258_11 | 6CDC-4EA0-B2 | PO13543123789 | 100 | 287 | 511 | 293 | 1 | 2024-06-23 | 436.91 | 10.92 | 2024-06-11 | 2 | 199.38 | 1 | 436.91 | 11 | SO65258 | 2024-06-18 | 34.95 | 398.75 | 218.45 | |||
| SO57099_39 | 410F-45E9-9C | PO18618199656 | 100 | 286 | 565 | 605 | 1 | 2024-02-23 | 890.82 | 22.27 | 2024-02-11 | 2 | 461.44 | 1 | 890.82 | 39 | SO57099 | 2024-02-18 | 71.27 | 922.89 | 445.41 | |||
| SO55243_31 | 2457-46EE-88 | PO15312160912 | 19 | 291 | 225 | 299 | 6 | 2024-01-23 | 43.15 | 1.08 | 2024-01-11 | 8 | 6.92 | 1 | 43.15 | 31 | SO55243 | 2024-01-18 | 3.45 | 55.38 | 5.39 | |||
| SO46082_5 | E8B4-45CF-8C | PO3799169418 | 100 | 282 | 232 | 312 | 4 | 2022-08-23 | 57.68 | 1.44 | 2022-08-11 | 2 | 31.72 | 1 | 57.68 | 5 | SO46082 | 2022-08-18 | 4.61 | 63.45 | 28.84 | |||
| SO71794_4 | C39A-4835-99 | PO17574111985 | 19 | 291 | 531 | 678 | 6 | 2024-09-23 | 599.50 | 14.99 | 2024-09-11 | 4 | 136.79 | 1 | 599.50 | 4 | SO71794 | 2024-09-18 | 47.96 | 547.14 | 149.87 | |||
| SO67261_14 | 69A6-43AC-8B | PO19575128867 | 98 | 288 | 565 | 34 | 10 | 2024-07-24 | 445.41 | 11.14 | 2024-07-12 | 1 | 461.44 | 1 | 445.41 | 14 | SO67261 | 2024-07-19 | 35.63 | 461.44 | 445.41 | |||
| SO46960_16 | F05E-41EB-90 | PO16762181648 | 100 | 282 | 343 | 259 | 4 | 2022-11-23 | 469.79 | 11.74 | 2022-11-11 | 1 | 486.71 | 1 | 469.79 | 16 | SO46960 | 2022-11-18 | 37.58 | 486.71 | 469.79 | |||
| SO44306_6 | 464C-43BA-9F | PO1189114917 | 100 | 285 | 212 | 423 | 5 | 2022-01-23 | 161.49 | 4.04 | 2022-01-11 | 8 | 12.03 | 1 | 161.49 | 6 | SO44306 | 2022-01-18 | 12.92 | 96.22 | 20.19 | |||
| SO51091_6 | DEAC-431D-94 | PO15399127644 | 100 | 281 | 234 | 220 | 3 | 2023-10-23 | 89.98 | 2.25 | 2023-10-11 | 3 | 38.49 | 1 | 89.98 | 6 | SO51091 | 2023-10-18 | 7.20 | 115.48 | 29.99 | |||
| SO47697_2 | 46E0-4D93-B6 | PO1479130990 | 100 | 272 | 468 | 673 | 1 | 2023-01-23 | 22.79 | 0.57 | 2023-01-11 | 1 | 15.67 | 1 | 22.79 | 2 | SO47697 | 2023-01-18 | 1.82 | 15.67 | 22.79 | |||
| SO47992_26 | 3F55-4354-BD | PO15573158216 | 100 | 293 | 447 | 487 | 1 | 2023-02-23 | 75.00 | 1.88 | 2023-02-11 | 5 | 10.31 | 1 | 75.00 | 26 | SO47992 | 2023-02-18 | 6.00 | 51.56 | 15.00 | |||
| SO65210_17 | 08E4-4CC9-A7 | PO2813181442 | 100 | 283 | 487 | 90 | 5 | 2024-06-23 | 230.96 | 5.77 | 2024-06-11 | 7 | 20.57 | 1 | 230.96 | 17 | SO65210 | 2024-06-18 | 18.48 | 143.96 | 32.99 | |||
| SO65218_4 | 582E-4D6F-9C | PO15544112763 | 19 | 284 | 559 | 282 | 6 | 2024-06-23 | 24.29 | 0.61 | 2024-06-11 | 2 | 8.99 | 1 | 24.29 | 4 | SO65218 | 2024-06-18 | 1.94 | 17.97 | 12.14 | |||
| SO59012_4 | 6620-4CEA-A0 | PO7685122244 | 100 | 283 | 576 | 539 | 2 | 2024-03-24 | 4291.33 | 107.28 | 2024-03-12 | 3 | 1481.94 | 1 | 4291.33 | 4 | SO59012 | 2024-03-19 | 343.31 | 4445.81 | 1430.44 | |||
| SO53615_6 | FBF4-4FC7-A6 | PO4814189523 | 36 | 295 | 463 | 464 | 8 | 2023-12-24 | 88.16 | 2.20 | 2023-12-12 | 6 | 9.16 | 1 | 88.16 | 6 | SO53615 | 2023-12-19 | 7.05 | 54.96 | 14.69 | |||
| SO44772_2 | F5E6-4B81-A3 | PO1624122637 | 100 | 283 | 334 | 579 | 3 | 2022-03-25 | 838.92 | 20.97 | 2022-03-13 | 2 | 413.15 | 1 | 838.92 | 2 | SO44772 | 2022-03-20 | 67.11 | 826.29 | 419.46 | |||
| SO69511_38 | 80CF-4941-99 | PO5829113904 | 36 | 295 | 231 | 266 | 8 | 2024-08-23 | 149.97 | 3.75 | 2024-08-11 | 5 | 38.49 | 1 | 149.97 | 38 | SO69511 | 2024-08-18 | 12.00 | 192.46 | 29.99 | |||
| SO55249_58 | 0527-4C9D-BA | PO13688172507 | 100 | 282 | 592 | 475 | 4 | 2024-01-23 | 1016.98 | 25.42 | 2024-01-11 | 3 | 308.22 | 1 | 1016.98 | 58 | SO55249 | 2024-01-18 | 81.36 | 924.65 | 338.99 | |||
| SO47456_10 | 840E-4252-B7 | PO9715175233 | 100 | 283 | 354 | 490 | 4 | 2022-12-24 | 3728.56 | 93.21 | 2022-12-12 | 3 | 1117.86 | 1 | 3728.56 | 10 | SO47456 | 2022-12-19 | 298.28 | 3353.57 | 1242.85 | |||
| SO48364_1 | 93FF-4A54-BA | PO3886118778 | 100 | 283 | 422 | 165 | 4 | 2023-03-25 | 135.08 | 3.38 | 2023-03-13 | 2 | 49.98 | 1 | 135.08 | 1 | SO48364 | 2023-03-20 | 10.81 | 99.96 | 67.54 | |||
| SO69520_4 | 654B-484B-8F | PO4466144794 | 19 | 291 | 217 | 352 | 6 | 2024-08-23 | 20.99 | 0.52 | 2024-08-11 | 1 | 13.09 | 1 | 20.99 | 4 | SO69520 | 2024-08-18 | 1.68 | 13.09 | 20.99 | |||
| SO57108_1 | FF80-4FA7-94 | PO16211160206 | 100 | 285 | 595 | 99 | 5 | 2024-02-23 | 338.99 | 8.47 | 2024-02-11 | 1 | 308.22 | 1 | 338.99 | 1 | SO57108 | 2024-02-18 | 27.12 | 308.22 | 338.99 | |||
| SO58944_14 | 90AC-4F21-90 | PO12354164168 | 100 | 283 | 484 | 197 | 3 | 2024-03-24 | 19.08 | 0.48 | 2024-03-12 | 4 | 2.97 | 1 | 19.08 | 14 | SO58944 | 2024-03-19 | 1.53 | 11.89 | 4.77 | |||
| SO69460_7 | D5C8-450E-9F | PO1595193276 | 19 | 284 | 546 | 426 | 6 | 2024-08-23 | 37.25 | 0.93 | 2024-08-11 | 1 | 27.57 | 1 | 37.25 | 7 | SO69460 | 2024-08-18 | 2.98 | 27.57 | 37.25 | |||
| SO65269_4 | 999D-45C9-AA | PO4640162431 | 100 | 287 | 524 | 648 | 4 | 2024-06-23 | 316.86 | 7.92 | 2024-06-11 | 2 | 144.59 | 1 | 316.86 | 4 | SO65269 | 2024-06-18 | 25.35 | 289.19 | 158.43 | |||
| SO53509_14 | 4718-4C12-86 | PO11107182902 | 19 | 284 | 488 | 156 | 6 | 2023-12-24 | 32.39 | 0.81 | 2023-12-12 | 1 | 41.57 | 1 | 32.39 | 14 | SO53509 | 2023-12-19 | 2.59 | 41.57 | 32.39 |
Generated 2024-11-10 13:46:01.029 UTC