[ROOT] dt FactResellerSale < WHERE DimSalesTerritoryId EQ ALL SHUFFLE < SKIP 651 > < TAKE 60 >
60 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 |
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
| SO71803_29 | 9C57-4821-9B | PO15341174104 | 100 | 281 | 484 | 327 | 3 | 2024-09-27 | 19.08 | 0.48 | 2024-09-15 | 4 | 2.97 | 1 | 19.08 | 29 | SO71803 | 2024-09-22 | 1.53 | 11.89 | 4.77 | |||
| SO50301_15 | 94B2-4C2F-8C | PO5684190027 | 100 | 282 | 399 | 385 | 4 | 2023-08-27 | 67.55 | 1.69 | 2023-08-15 | 2 | 24.99 | 1 | 67.55 | 15 | SO50301 | 2023-08-22 | 5.40 | 49.99 | 33.77 | |||
| SO65236_2 | 46EF-4D44-A9 | PO9483140017 | 100 | 283 | 217 | 54 | 2 | 2024-06-27 | 125.96 | 3.15 | 2024-06-15 | 6 | 13.09 | 1 | 125.96 | 2 | SO65236 | 2024-06-22 | 10.08 | 78.52 | 20.99 | |||
| SO57013_2 | E12C-431B-BD | PO19691121735 | 19 | 291 | 361 | 353 | 6 | 2024-02-27 | 1376.99 | 34.42 | 2024-02-15 | 1 | 1251.98 | 1 | 1376.99 | 2 | SO57013 | 2024-02-22 | 110.16 | 1251.98 | 1376.99 | |||
| SO49045_2 | B1B9-4F02-A4 | PO19227111923 | 19 | 284 | 327 | 210 | 6 | 2023-05-30 | 1409.38 | 35.23 | 2023-05-18 | 3 | 486.71 | 1 | 1409.38 | 2 | SO49045 | 2023-05-25 | 112.75 | 1460.12 | 469.79 | |||
| SO47055_36 | BF62-4954-A7 | PO7453164163 | 100 | 281 | 263 | 108 | 2 | 2022-11-27 | 202.33 | 5.06 | 2022-11-15 | 1 | 187.16 | 1 | 202.33 | 36 | SO47055 | 2022-11-22 | 16.19 | 187.16 | 202.33 | |||
| SO53561_35 | CDF6-4B12-87 | PO7047187583 | 100 | 281 | 298 | 544 | 3 | 2023-12-28 | 2429.28 | 60.73 | 2023-12-16 | 3 | 739.04 | 1 | 2429.28 | 35 | SO53561 | 2023-12-23 | 194.34 | 2217.12 | 809.76 | |||
| SO67272_4 | F467-41BF-8B | PO13862111340 | 19 | 291 | 475 | 119 | 6 | 2024-07-28 | 83.99 | 2.10 | 2024-07-16 | 2 | 26.18 | 1 | 83.99 | 4 | SO67272 | 2024-07-23 | 6.72 | 52.35 | 41.99 | |||
| SO50206_41 | 7656-4E84-B8 | PO16414158832 | 100 | 289 | 230 | 236 | 1 | 2023-08-27 | 173.04 | 4.33 | 2023-08-15 | 6 | 29.08 | 1 | 173.04 | 41 | SO50206 | 2023-08-22 | 13.84 | 174.48 | 28.84 | |||
| SO49865_21 | E9A6-42D3-91 | PO9831136904 | 100 | 285 | 329 | 81 | 5 | 2023-07-28 | 939.59 | 23.49 | 2023-07-16 | 2 | 486.71 | 1 | 939.59 | 21 | SO49865 | 2023-07-23 | 75.17 | 973.41 | 469.79 | |||
| SO51104_23 | D008-4004-A4 | PO13340177593 | 100 | 292 | 511 | 355 | 7 | 2023-10-27 | 1310.72 | 32.77 | 2023-10-15 | 6 | 199.38 | 1 | 1310.72 | 23 | SO51104 | 2023-10-22 | 104.86 | 1196.25 | 218.45 | |||
| SO50662_21 | 2ABC-4DD7-A1 | PO19604139855 | 98 | 288 | 308 | 340 | 10 | 2023-09-27 | 744.27 | 18.61 | 2023-09-15 | 1 | 660.91 | 1 | 744.27 | 21 | SO50662 | 2023-09-22 | 59.54 | 660.91 | 744.27 | |||
| SO58959_28 | 1330-4B17-AF | PO10353115061 | 98 | 288 | 357 | 88 | 10 | 2024-03-28 | 1391.99 | 34.80 | 2024-03-16 | 1 | 1265.62 | 1 | 1391.99 | 28 | SO58959 | 2024-03-23 | 111.36 | 1265.62 | 1391.99 | |||
| SO49839_11 | 3123-41F3-9B | PO10527179463 | 19 | 284 | 224 | 480 | 6 | 2023-07-28 | 10.37 | 0.26 | 2023-07-16 | 2 | 5.23 | 1 | 10.37 | 11 | SO49839 | 2023-07-23 | 0.83 | 10.46 | 5.19 | |||
| SO47703_9 | 0E62-43AC-8E | PO3741184156 | 100 | 285 | 458 | 404 | 5 | 2023-01-27 | 44.99 | 1.12 | 2023-01-15 | 1 | 30.93 | 1 | 44.99 | 9 | SO47703 | 2023-01-22 | 3.60 | 30.93 | 44.99 | |||
| SO49158_21 | 47CD-4C5F-B8 | PO7453124733 | 100 | 283 | 448 | 108 | 2 | 2023-05-30 | 47.98 | 1.20 | 2023-05-18 | 4 | 8.25 | 1 | 47.98 | 21 | SO49158 | 2023-05-25 | 3.84 | 32.98 | 11.99 | |||
| SO65210_12 | 08E4-4CC9-A7 | PO2813181442 | 100 | 283 | 606 | 90 | 5 | 2024-06-27 | 971.98 | 24.30 | 2024-06-15 | 3 | 343.65 | 1 | 971.98 | 12 | SO65210 | 2024-06-22 | 77.76 | 1030.95 | 323.99 | |||
| SO71801_30 | 0DBE-43DA-9A | PO15515173664 | 100 | 292 | 467 | 481 | 7 | 2024-09-27 | 14.69 | 0.37 | 2024-09-15 | 1 | 9.16 | 1 | 14.69 | 30 | SO71801 | 2024-09-22 | 1.18 | 9.16 | 14.69 | |||
| SO65234_20 | 3BB7-4A9F-AF | PO10411160249 | 100 | 289 | 491 | 182 | 1 | 2024-06-27 | 194.36 | 4.86 | 2024-06-15 | 6 | 41.57 | 1 | 194.36 | 20 | SO65234 | 2024-06-22 | 15.55 | 249.43 | 32.39 | |||
| SO49479_20 | 12BA-4BD1-BB | PO11455112131 | 100 | 283 | 333 | 72 | 2 | 2023-06-27 | 939.59 | 23.49 | 2023-06-15 | 2 | 486.71 | 1 | 939.59 | 20 | SO49479 | 2023-06-22 | 75.17 | 973.41 | 469.79 | |||
| SO57055_8 | 3CBC-4CD2-B1 | PO13369127604 | 100 | 292 | 606 | 391 | 7 | 2024-02-27 | 971.98 | 24.30 | 2024-02-15 | 3 | 343.65 | 1 | 971.98 | 8 | SO57055 | 2024-02-22 | 77.76 | 1030.95 | 323.99 | |||
| SO48057_32 | 53D7-4BA4-AB | PO4727174880 | 100 | 293 | 325 | 343 | 1 | 2023-02-27 | 1879.18 | 46.98 | 2023-02-15 | 4 | 486.71 | 1 | 1879.18 | 32 | SO48057 | 2023-02-22 | 150.33 | 1946.83 | 469.79 | |||
| SO44121_2 | FE2E-4885-B3 | PO5220129819 | 100 | 282 | 307 | 169 | 1 | 2021-12-28 | 722.59 | 18.06 | 2021-12-16 | 1 | 623.84 | 1 | 722.59 | 2 | SO44121 | 2021-12-23 | 57.81 | 623.84 | 722.59 | |||
| SO49066_23 | 4065-4B0A-A2 | PO1595117888 | 19 | 284 | 458 | 426 | 6 | 2023-05-30 | 44.99 | 1.12 | 2023-05-18 | 1 | 30.93 | 1 | 44.99 | 23 | SO49066 | 2023-05-25 | 3.60 | 30.93 | 44.99 | |||
| SO55259_24 | 68EA-4A46-81 | PO11687179986 | 100 | 283 | 578 | 691 | 2 | 2024-01-27 | 728.91 | 18.22 | 2024-01-15 | 1 | 755.15 | 1 | 728.91 | 24 | SO55259 | 2024-01-22 | 58.31 | 755.15 | 728.91 | |||
| SO71891_2 | A2BC-4140-A6 | PO7366158003 | 19 | 284 | 494 | 372 | 6 | 2024-09-27 | 602.35 | 15.06 | 2024-09-15 | 1 | 601.74 | 1 | 602.35 | 2 | SO71891 | 2024-09-22 | 48.19 | 601.74 | 602.35 | |||
| SO63179_20 | F2C5-4376-B7 | PO2668147145 | 100 | 292 | 472 | 535 | 7 | 2024-05-29 | 114.30 | 2.86 | 2024-05-17 | 3 | 23.75 | 1 | 114.30 | 20 | SO63179 | 2024-05-24 | 9.14 | 71.25 | 38.10 | |||
| SO50199_5 | 8C45-47E6-93 | PO17748185472 | 19 | 284 | 368 | 102 | 6 | 2023-08-27 | 5864.04 | 146.60 | 2023-08-15 | 4 | 1518.79 | 1 | 5864.04 | 5 | SO50199 | 2023-08-22 | 469.12 | 6075.15 | 1466.01 | |||
| SO46671_29 | 13F6-4858-8D | PO8787194061 | 100 | 282 | 339 | 523 | 3 | 2022-10-27 | 1879.18 | 46.98 | 2022-10-15 | 4 | 486.71 | 1 | 1879.18 | 29 | SO46671 | 2022-10-22 | 150.33 | 1946.83 | 469.79 | |||
| SO51795_8 | 30DF-4333-9E | PO15921146523 | 100 | 287 | 491 | 77 | 4 | 2023-11-27 | 129.58 | 3.24 | 2023-11-15 | 4 | 41.57 | 1 | 129.58 | 8 | SO51795 | 2023-11-22 | 10.37 | 166.29 | 32.39 | |||
| SO71894_26 | 8013-4FC0-B4 | PO7685115663 | 100 | 283 | 499 | 539 | 2 | 2024-09-27 | 2409.38 | 60.23 | 2024-09-15 | 4 | 601.74 | 1 | 2409.38 | 26 | SO71894 | 2024-09-22 | 192.75 | 2406.97 | 602.35 | |||
| SO53554_18 | 314F-4C97-94 | PO12151155457 | 6 | 294 | 222 | 195 | 9 | 2023-12-28 | 83.98 | 2.10 | 2023-12-16 | 4 | 13.09 | 1 | 83.98 | 18 | SO53554 | 2023-12-23 | 6.72 | 52.35 | 20.99 | |||
| SO46057_23 | 6F2B-45A4-9C | PO12499164653 | 100 | 282 | 272 | 78 | 4 | 2022-08-27 | 183.94 | 4.60 | 2022-08-15 | 1 | 181.49 | 1 | 183.94 | 23 | SO46057 | 2022-08-22 | 14.72 | 181.49 | 183.94 | |||
| SO44506_27 | CD67-4B07-B6 | PO16327113845 | 100 | 285 | 270 | 584 | 5 | 2022-02-27 | 551.81 | 13.80 | 2022-02-15 | 3 | 181.49 | 1 | 551.81 | 27 | SO44506 | 2022-02-22 | 44.15 | 544.46 | 183.94 | |||
| SO47441_10 | 2582-4E47-98 | PO7569166535 | 100 | 287 | 401 | 608 | 4 | 2022-12-28 | 196.81 | 4.92 | 2022-12-16 | 3 | 48.55 | 1 | 196.81 | 10 | SO47441 | 2022-12-23 | 15.74 | 145.64 | 65.60 | |||
| SO45339_18 | 1F94-40D0-86 | PO7656113434 | 100 | 282 | 310 | 403 | 4 | 2022-05-30 | 2146.96 | 53.67 | 2022-05-18 | 1 | 2171.29 | 1 | 2146.96 | 18 | SO45339 | 2022-05-25 | 171.76 | 2171.29 | 2146.96 | |||
| SO69393_8 | 3E84-4AA4-B6 | PO19923114948 | 100 | 283 | 357 | 18 | 3 | 2024-08-27 | 4175.98 | 104.40 | 2024-08-15 | 3 | 1265.62 | 1 | 4175.98 | 8 | SO69393 | 2024-08-22 | 334.08 | 3796.86 | 1391.99 | |||
| SO57162_5 | 83B5-43A6-BD | PO3596174424 | 100 | 285 | 475 | 476 | 5 | 2024-02-27 | 83.99 | 2.10 | 2024-02-15 | 2 | 26.18 | 1 | 83.99 | 5 | SO57162 | 2024-02-22 | 6.72 | 52.35 | 41.99 | |||
| SO65245_6 | 80F6-437F-84 | PO9628129233 | 100 | 283 | 491 | 179 | 2 | 2024-06-27 | 64.79 | 1.62 | 2024-06-15 | 2 | 41.57 | 1 | 64.79 | 6 | SO65245 | 2024-06-22 | 5.18 | 83.14 | 32.39 | |||
| SO55322_16 | D600-436A-B7 | PO7859118281 | 100 | 287 | 488 | 221 | 4 | 2024-01-27 | 129.58 | 3.24 | 2024-01-15 | 4 | 41.57 | 1 | 129.58 | 16 | SO55322 | 2024-01-22 | 10.37 | 166.29 | 32.39 | |||
| SO53468_30 | C577-4CE9-93 | PO17371113808 | 6 | 296 | 577 | 688 | 9 | 2023-12-28 | 1457.82 | 36.45 | 2023-12-16 | 2 | 755.15 | 1 | 1457.82 | 30 | SO53468 | 2023-12-23 | 116.63 | 1510.30 | 728.91 | |||
| SO47042_34 | 42DB-4E2E-B9 | PO5858114009 | 100 | 285 | 365 | 566 | 5 | 2022-11-27 | 3239.97 | 81.00 | 2022-11-15 | 5 | 598.44 | 1 | 3239.97 | 34 | SO47042 | 2022-11-22 | 259.20 | 2992.18 | 647.99 | |||
| SO51714_26 | D33A-4EAE-B1 | PO15689195197 | 100 | 281 | 386 | 328 | 4 | 2023-11-27 | 2689.18 | 67.23 | 2023-11-15 | 4 | 713.08 | 1 | 2689.18 | 26 | SO51714 | 2023-11-22 | 215.13 | 2852.32 | 672.29 | |||
| SO65158_26 | 3613-4FA2-B8 | PO19285194632 | 98 | 288 | 237 | 448 | 10 | 2024-06-27 | 59.99 | 1.50 | 2024-06-15 | 2 | 38.49 | 1 | 59.99 | 26 | SO65158 | 2024-06-22 | 4.80 | 76.98 | 29.99 | |||
| SO48744_2 | 15DB-48CD-9B | PO1711156590 | 19 | 291 | 395 | 2 | 245 | 6 | 13.05 | 2023-04-29 | 652.61 | 15.99 | 2023-04-17 | 11 | 45.42 | 1 | 639.56 | 2 | SO48744 | 2023-04-24 | 51.16 | 499.58 | 59.33 | 0.02 |
| SO69454_30 | 0211-4E7F-80 | PO580171630 | 36 | 295 | 500 | 230 | 8 | 2024-08-27 | 602.35 | 15.06 | 2024-08-15 | 1 | 601.74 | 1 | 602.35 | 30 | SO69454 | 2024-08-22 | 48.19 | 601.74 | 602.35 | |||
| SO48761_20 | E39C-4A4E-A3 | PO15312195795 | 19 | 291 | 369 | 299 | 6 | 2023-04-29 | 2932.02 | 73.30 | 2023-04-17 | 2 | 1518.79 | 1 | 2932.02 | 20 | SO48761 | 2023-04-24 | 234.56 | 3037.57 | 1466.01 | |||
| SO61189_19 | 1A25-4A8C-8B | PO12412183085 | 100 | 281 | 386 | 670 | 3 | 2024-04-28 | 3361.47 | 84.04 | 2024-04-16 | 5 | 713.08 | 1 | 3361.47 | 19 | SO61189 | 2024-04-23 | 268.92 | 3565.40 | 672.29 | |||
| SO48336_52 | 48F2-4141-9A | PO11455111823 | 100 | 281 | 368 | 72 | 2 | 2023-03-29 | 1466.01 | 36.65 | 2023-03-17 | 1 | 1518.79 | 1 | 1466.01 | 52 | SO48336 | 2023-03-24 | 117.28 | 1518.79 | 1466.01 | |||
| SO48049_22 | C09A-49F5-80 | PO3799136256 | 100 | 282 | 409 | 312 | 4 | 2023-02-27 | 418.51 | 10.46 | 2023-02-15 | 2 | 185.82 | 1 | 418.51 | 22 | SO48049 | 2023-02-22 | 33.48 | 371.64 | 209.26 | |||
| SO69422_26 | BF3A-4F54-82 | PO14500139823 | 100 | 282 | 591 | 16 | 650 | 1 | 90.40 | 2024-08-27 | 226.00 | 3.39 | 2024-08-15 | 2 | 308.22 | 1 | 135.60 | 26 | SO69422 | 2024-08-22 | 10.85 | 616.44 | 113.00 | 0.40 |
| SO48735_13 | BFBE-46B9-A1 | PO12412161905 | 100 | 281 | 325 | 670 | 3 | 2023-04-29 | 2348.97 | 58.72 | 2023-04-17 | 5 | 486.71 | 1 | 2348.97 | 13 | SO48735 | 2023-04-24 | 187.92 | 2433.53 | 469.79 | |||
| SO45074_6 | 7225-40DF-B0 | PO7859191751 | 100 | 287 | 338 | 221 | 4 | 2022-04-29 | 419.46 | 10.49 | 2022-04-17 | 1 | 413.15 | 1 | 419.46 | 6 | SO45074 | 2022-04-24 | 33.56 | 413.15 | 419.46 | |||
| SO44787_5 | CFC8-46AC-A7 | PO5597180446 | 100 | 283 | 215 | 75 | 4 | 2022-03-29 | 20.19 | 0.50 | 2022-03-17 | 1 | 12.03 | 1 | 20.19 | 5 | SO44787 | 2022-03-24 | 1.61 | 12.03 | 20.19 | |||
| SO46049_25 | 2C79-41BD-8A | PO15689114654 | 100 | 283 | 330 | 328 | 4 | 2022-08-27 | 1677.84 | 41.95 | 2022-08-15 | 4 | 413.15 | 1 | 1677.84 | 25 | SO46049 | 2022-08-22 | 134.23 | 1652.59 | 419.46 | |||
| SO53567_3 | 2385-4ADE-B6 | PO9628113784 | 100 | 283 | 225 | 3 | 179 | 2 | 4.20 | 2023-12-28 | 84.06 | 2.00 | 2023-12-16 | 17 | 6.92 | 1 | 79.85 | 3 | SO53567 | 2023-12-23 | 6.39 | 117.68 | 4.94 | 0.05 |
| SO50208_40 | 6993-49B4-8B | PO15689114248 | 100 | 281 | 337 | 328 | 4 | 2023-08-27 | 3758.35 | 93.96 | 2023-08-15 | 8 | 486.71 | 1 | 3758.35 | 40 | SO50208 | 2023-08-22 | 300.67 | 3893.65 | 469.79 | |||
| SO57147_3 | 0E55-4CF4-AD | PO7975143358 | 6 | 296 | 475 | 141 | 9 | 2024-02-27 | 41.99 | 1.05 | 2024-02-15 | 1 | 26.18 | 1 | 41.99 | 3 | SO57147 | 2024-02-22 | 3.36 | 26.18 | 41.99 | |||
| SO47724_39 | FDA2-4CD7-92 | PO8787160870 | 100 | 282 | 461 | 523 | 3 | 2023-01-27 | 377.96 | 9.45 | 2023-01-15 | 7 | 37.12 | 1 | 377.96 | 39 | SO47724 | 2023-01-22 | 30.24 | 259.85 | 53.99 | |||
| SO49132_18 | 3562-4169-86 | PO3799126007 | 100 | 282 | 356 | 312 | 4 | 2023-05-30 | 1242.85 | 31.07 | 2023-05-18 | 1 | 1117.86 | 1 | 1242.85 | 18 | SO49132 | 2023-05-25 | 99.43 | 1117.86 | 1242.85 |
Generated 2024-11-14 05:23:55.222 UTC