[ROOT] dt FactResellerSale < WHERE DimSalesTerritoryId EQ ALL SHUFFLE < SKIP 352 > < 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 |
---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
SO46947_1 | 871C-4835-AD | PO18183118836 | 100 | 281 | 411 | 667 | 2 | 2022-11-23 | 376.25 | 9.41 | 2022-11-11 | 3 | 92.81 | 1 | 376.25 | 1 | SO46947 | 2022-11-18 | 30.10 | 278.42 | 125.42 | |||
SO69460_2 | D5C8-450E-9F | PO1595193276 | 19 | 284 | 418 | 426 | 6 | 2024-08-23 | 713.80 | 17.84 | 2024-08-11 | 2 | 360.94 | 1 | 713.80 | 2 | SO69460 | 2024-08-18 | 57.10 | 721.89 | 356.90 | |||
SO58991_5 | D7E6-4630-81 | PO16530115443 | 100 | 282 | 569 | 601 | 1 | 2024-03-24 | 890.82 | 22.27 | 2024-03-12 | 2 | 461.44 | 1 | 890.82 | 5 | SO58991 | 2024-03-19 | 71.27 | 922.89 | 445.41 | |||
SO47680_15 | FD44-4F17-A1 | PO13340181659 | 100 | 292 | 216 | 355 | 7 | 2023-01-23 | 80.75 | 2.02 | 2023-01-11 | 4 | 13.88 | 1 | 80.75 | 15 | SO47680 | 2023-01-18 | 6.46 | 55.51 | 20.19 | |||
SO53554_12 | 314F-4C97-94 | PO12151155457 | 6 | 294 | 477 | 195 | 9 | 2023-12-24 | 5.99 | 0.15 | 2023-12-12 | 2 | 1.87 | 1 | 5.99 | 12 | SO53554 | 2023-12-19 | 0.48 | 3.73 | 2.99 | |||
SO57162_1 | 83B5-43A6-BD | PO3596174424 | 100 | 285 | 596 | 476 | 5 | 2024-02-23 | 323.99 | 8.10 | 2024-02-11 | 1 | 294.58 | 1 | 323.99 | 1 | SO57162 | 2024-02-18 | 25.92 | 294.58 | 323.99 | |||
SO67320_26 | 771C-4E57-91 | PO5626199373 | 100 | 281 | 243 | 166 | 4 | 2024-07-24 | 1717.80 | 42.95 | 2024-07-12 | 2 | 868.63 | 1 | 1717.80 | 26 | SO67320 | 2024-07-19 | 137.42 | 1737.27 | 858.90 | |||
SO71806_3 | 26A7-4E95-9B | PO14790111844 | 19 | 291 | 594 | 16 | 497 | 6 | 90.40 | 2024-09-23 | 226.00 | 3.39 | 2024-09-11 | 2 | 308.22 | 1 | 135.60 | 3 | SO71806 | 2024-09-18 | 10.85 | 616.44 | 113.00 | 0.40 |
SO44505_4 | 5D07-4BE7-A6 | PO16037162003 | 100 | 282 | 351 | 384 | 4 | 2022-02-23 | 4049.99 | 101.25 | 2022-02-11 | 2 | 1898.09 | 1 | 4049.99 | 4 | SO44505 | 2022-02-18 | 324.00 | 3796.19 | 2024.99 | |||
SO58905_25 | 79BE-4713-94 | PO19604111681 | 98 | 288 | 589 | 340 | 10 | 2024-03-24 | 1846.78 | 46.17 | 2024-03-12 | 4 | 419.78 | 1 | 1846.78 | 25 | SO58905 | 2024-03-19 | 147.74 | 1679.11 | 461.69 | |||
SO63247_5 | 1EB8-4AE3-AC | PO6148143330 | 100 | 289 | 586 | 693 | 1 | 2024-05-25 | 890.82 | 22.27 | 2024-05-13 | 2 | 461.44 | 1 | 890.82 | 5 | SO63247 | 2024-05-20 | 71.27 | 922.89 | 445.41 | |||
SO53570_47 | 412A-483A-A3 | PO9483124574 | 100 | 283 | 214 | 54 | 2 | 2023-12-24 | 167.95 | 4.20 | 2023-12-12 | 8 | 13.09 | 1 | 167.95 | 47 | SO53570 | 2023-12-19 | 13.44 | 104.69 | 20.99 | |||
SO48306_39 | EA27-471A-9D | PO17574166075 | 19 | 291 | 213 | 678 | 6 | 2023-03-25 | 121.12 | 3.03 | 2023-03-13 | 6 | 13.88 | 1 | 121.12 | 39 | SO48306 | 2023-03-20 | 9.69 | 83.27 | 20.19 | |||
SO57028_2 | E080-4171-A4 | PO16704183706 | 100 | 292 | 471 | 680 | 7 | 2024-02-23 | 190.50 | 4.76 | 2024-02-11 | 5 | 23.75 | 1 | 190.50 | 2 | SO57028 | 2024-02-18 | 15.24 | 118.75 | 38.10 | |||
SO50676_15 | 66F1-4A9A-97 | PO14790188963 | 19 | 291 | 453 | 497 | 6 | 2023-09-23 | 71.99 | 1.80 | 2023-09-11 | 2 | 24.75 | 1 | 71.99 | 15 | SO50676 | 2023-09-18 | 5.76 | 49.49 | 35.99 | |||
SO50221_16 | EAD6-4841-B9 | PO13572116484 | 100 | 287 | 341 | 527 | 3 | 2023-08-23 | 1879.18 | 46.98 | 2023-08-11 | 4 | 486.71 | 1 | 1879.18 | 16 | SO50221 | 2023-08-18 | 150.33 | 1946.83 | 469.79 | |||
SO47439_20 | D4B6-4746-BE | PO6786128920 | 100 | 283 | 459 | 3 | 4 | 2022-12-24 | 377.96 | 9.45 | 2022-12-12 | 7 | 37.12 | 1 | 377.96 | 20 | SO47439 | 2022-12-19 | 30.24 | 259.85 | 53.99 | |||
SO58974_25 | FB64-4792-81 | PO2813115918 | 100 | 283 | 463 | 90 | 5 | 2024-03-24 | 58.78 | 1.47 | 2024-03-12 | 4 | 9.16 | 1 | 58.78 | 25 | SO58974 | 2024-03-19 | 4.70 | 36.64 | 14.69 | |||
SO49158_14 | 47CD-4C5F-B8 | PO7453124733 | 100 | 283 | 323 | 108 | 2 | 2023-05-26 | 4697.94 | 117.45 | 2023-05-14 | 10 | 486.71 | 1 | 4697.94 | 14 | SO49158 | 2023-05-21 | 375.84 | 4867.07 | 469.79 | |||
SO45815_14 | 80EF-464E-97 | PO9657174967 | 100 | 285 | 351 | 315 | 5 | 2022-07-24 | 8099.98 | 202.50 | 2022-07-12 | 4 | 1898.09 | 1 | 8099.98 | 14 | SO45815 | 2022-07-19 | 648.00 | 7592.38 | 2024.99 | |||
SO47662_32 | 9790-4A85-BE | PO18473142607 | 19 | 291 | 461 | 442 | 6 | 2023-01-23 | 161.98 | 4.05 | 2023-01-11 | 3 | 37.12 | 1 | 161.98 | 32 | SO47662 | 2023-01-18 | 12.96 | 111.36 | 53.99 | |||
SO65153_4 | 0F10-4B75-A4 | PO19894114601 | 100 | 283 | 570 | 557 | 2 | 2024-06-23 | 1336.23 | 33.41 | 2024-06-11 | 3 | 461.44 | 1 | 1336.23 | 4 | SO65153 | 2024-06-18 | 106.90 | 1384.33 | 445.41 | |||
SO49527_6 | BFD0-4AA2-AF | PO4640129987 | 100 | 287 | 362 | 648 | 4 | 2023-06-23 | 2458.92 | 61.47 | 2023-06-11 | 2 | 1105.81 | 1 | 2458.92 | 6 | SO49527 | 2023-06-18 | 196.71 | 2211.62 | 1229.46 | |||
SO69561_13 | BBC0-4CA4-A2 | PO8845186382 | 100 | 282 | 214 | 546 | 3 | 2024-08-23 | 125.96 | 3.15 | 2024-08-11 | 6 | 13.09 | 1 | 125.96 | 13 | SO69561 | 2024-08-18 | 10.08 | 78.52 | 20.99 | |||
SO47658_13 | C574-484B-83 | PO551177057 | 100 | 283 | 381 | 4 | 4 | 2023-01-23 | 1800.79 | 45.02 | 2023-01-11 | 3 | 605.65 | 1 | 1800.79 | 13 | SO47658 | 2023-01-18 | 144.06 | 1816.95 | 600.26 | |||
SO47041_40 | C543-4932-83 | PO5771188676 | 100 | 282 | 375 | 79 | 3 | 2022-11-23 | 5235.75 | 130.89 | 2022-11-11 | 4 | 1320.68 | 1 | 5235.75 | 40 | SO47041 | 2022-11-18 | 418.86 | 5282.74 | 1308.94 | |||
SO71864_4 | 2987-40A6-86 | PO14268188903 | 100 | 281 | 584 | 418 | 3 | 2024-09-23 | 323.99 | 8.10 | 2024-09-11 | 1 | 343.65 | 1 | 323.99 | 4 | SO71864 | 2024-09-18 | 25.92 | 343.65 | 323.99 | |||
SO47450_15 | 7E50-416D-A2 | PO9483124566 | 100 | 281 | 242 | 54 | 2 | 2022-12-24 | 1561.64 | 39.04 | 2022-12-12 | 2 | 722.26 | 1 | 1561.64 | 15 | SO47450 | 2022-12-19 | 124.93 | 1444.51 | 780.82 | |||
SO67314_12 | 6653-491A-80 | PO3828116396 | 100 | 283 | 471 | 3 | 414 | 2 | 31.43 | 2024-07-24 | 628.65 | 14.93 | 2024-07-12 | 18 | 23.75 | 1 | 597.22 | 12 | SO67314 | 2024-07-19 | 47.78 | 427.48 | 34.93 | 0.05 |
SO67282_1 | 50CB-4642-B1 | PO11687162635 | 100 | 283 | 572 | 691 | 2 | 2024-07-24 | 445.41 | 11.14 | 2024-07-12 | 1 | 461.44 | 1 | 445.41 | 1 | SO67282 | 2024-07-19 | 35.63 | 461.44 | 445.41 | |||
SO48089_32 | EACD-4BB9-97 | PO8845169807 | 100 | 282 | 216 | 546 | 3 | 2023-02-23 | 60.56 | 1.51 | 2023-02-11 | 3 | 13.88 | 1 | 60.56 | 32 | SO48089 | 2023-02-18 | 4.84 | 41.63 | 20.19 | |||
SO44533_2 | 6A24-4735-B2 | PO1827111566 | 19 | 288 | 330 | 317 | 6 | 2022-02-23 | 838.92 | 20.97 | 2022-02-11 | 2 | 413.15 | 1 | 838.92 | 2 | SO44533 | 2022-02-18 | 67.11 | 826.29 | 419.46 | |||
SO47443_2 | DDB8-4FAB-92 | PO7192110823 | 100 | 289 | 410 | 20 | 1 | 2022-12-24 | 109.34 | 2.73 | 2022-12-12 | 3 | 26.97 | 1 | 109.34 | 2 | SO47443 | 2022-12-19 | 8.75 | 80.91 | 36.45 | |||
SO44770_2 | D260-44B2-BE | PO667193267 | 100 | 287 | 326 | 365 | 4 | 2022-03-25 | 419.46 | 10.49 | 2022-03-13 | 1 | 413.15 | 1 | 419.46 | 2 | SO44770 | 2022-03-20 | 33.56 | 413.15 | 419.46 | |||
SO53475_49 | FFE3-4820-88 | PO15515192405 | 100 | 292 | 546 | 481 | 7 | 2023-12-24 | 74.51 | 1.86 | 2023-12-12 | 2 | 27.57 | 1 | 74.51 | 49 | SO53475 | 2023-12-19 | 5.96 | 55.14 | 37.25 | |||
SO45334_3 | D530-40FA-B3 | PO6438146078 | 100 | 283 | 350 | 309 | 4 | 2022-05-26 | 6074.98 | 151.87 | 2022-05-14 | 3 | 1898.09 | 1 | 6074.98 | 3 | SO45334 | 2022-05-21 | 486.00 | 5694.28 | 2024.99 | |||
SO51151_38 | D7A9-4DF6-B9 | PO8787179219 | 100 | 282 | 490 | 2 | 523 | 3 | 8.14 | 2023-10-23 | 407.08 | 9.97 | 2023-10-11 | 13 | 41.57 | 1 | 398.94 | 38 | SO51151 | 2023-10-18 | 31.92 | 540.44 | 31.31 | 0.02 |
SO53505_18 | B522-40FD-B5 | PO11397144048 | 36 | 295 | 237 | 176 | 8 | 2023-12-24 | 209.96 | 5.25 | 2023-12-12 | 7 | 38.49 | 1 | 209.96 | 18 | SO53505 | 2023-12-19 | 16.80 | 269.45 | 29.99 | |||
SO50698_7 | 304A-4672-BA | PO1798139213 | 19 | 291 | 420 | 10 | 6 | 2023-09-23 | 141.62 | 3.54 | 2023-09-11 | 1 | 104.80 | 1 | 141.62 | 7 | SO50698 | 2023-09-18 | 11.33 | 104.80 | 141.62 | |||
SO57046_34 | 52CC-460F-B3 | PO14500161818 | 100 | 282 | 588 | 650 | 1 | 2024-02-23 | 923.39 | 23.08 | 2024-02-11 | 2 | 419.78 | 1 | 923.39 | 34 | SO57046 | 2024-02-18 | 73.87 | 839.56 | 461.69 | |||
SO45323_14 | 8E16-4834-8A | PO4901118407 | 19 | 284 | 342 | 84 | 6 | 2022-05-26 | 1258.38 | 31.46 | 2022-05-14 | 3 | 413.15 | 1 | 1258.38 | 14 | SO45323 | 2022-05-21 | 100.67 | 1239.44 | 419.46 | |||
SO71805_13 | 99FD-47B9-97 | PO14703194514 | 6 | 296 | 488 | 2 | 573 | 9 | 6.89 | 2024-09-23 | 344.46 | 8.44 | 2024-09-11 | 11 | 41.57 | 1 | 337.57 | 13 | SO71805 | 2024-09-18 | 27.01 | 457.30 | 31.31 | 0.02 |
SO63203_1 | A519-4FDF-86 | PO12209121100 | 6 | 294 | 363 | 411 | 9 | 2024-05-25 | 1376.99 | 34.42 | 2024-05-13 | 1 | 1251.98 | 1 | 1376.99 | 1 | SO63203 | 2024-05-20 | 110.16 | 1251.98 | 1376.99 | |||
SO53565_14 | 7768-4A45-93 | PO9396130858 | 6 | 296 | 577 | 267 | 9 | 2023-12-24 | 2186.73 | 54.67 | 2023-12-12 | 3 | 755.15 | 1 | 2186.73 | 14 | SO53565 | 2023-12-19 | 174.94 | 2265.45 | 728.91 | |||
SO58915_16 | 1BBB-45DF-82 | PO17371111245 | 6 | 294 | 214 | 688 | 9 | 2024-03-24 | 188.95 | 4.72 | 2024-03-12 | 9 | 13.09 | 1 | 188.95 | 16 | SO58915 | 2024-03-19 | 15.12 | 117.78 | 20.99 | |||
SO49167_2 | 5A78-4DE2-89 | PO8816115193 | 100 | 289 | 422 | 218 | 1 | 2023-05-26 | 202.62 | 5.07 | 2023-05-14 | 3 | 49.98 | 1 | 202.62 | 2 | SO49167 | 2023-05-21 | 16.21 | 149.94 | 67.54 | |||
SO48031_27 | 9EAA-4023-94 | PO957142471 | 98 | 288 | 428 | 376 | 10 | 2023-02-23 | 627.77 | 15.69 | 2023-02-11 | 3 | 185.82 | 1 | 627.77 | 27 | SO48031 | 2023-02-18 | 50.22 | 557.46 | 209.26 | |||
SO49513_4 | 1A8D-4D25-AE | PO10962181499 | 19 | 284 | 352 | 685 | 6 | 2023-06-23 | 2485.70 | 62.14 | 2023-06-11 | 2 | 1117.86 | 1 | 2485.70 | 4 | SO49513 | 2023-06-18 | 198.86 | 2235.71 | 1242.85 | |||
SO43867_7 | 061F-4449-BE | PO14471123403 | 100 | 286 | 229 | 145 | 1 | 2021-11-23 | 86.52 | 2.16 | 2021-11-11 | 3 | 31.72 | 1 | 86.52 | 7 | SO43867 | 2021-11-18 | 6.92 | 95.17 | 28.84 | |||
SO47984_2 | 57E5-4CB3-B1 | PO16762171139 | 100 | 282 | 325 | 259 | 4 | 2023-02-23 | 1409.38 | 35.23 | 2023-02-11 | 3 | 486.71 | 1 | 1409.38 | 2 | SO47984 | 2023-02-18 | 112.75 | 1460.12 | 469.79 | |||
SO46995_8 | 9CEA-4AC3-95 | PO11542113352 | 100 | 285 | 286 | 62 | 5 | 2022-11-23 | 183.94 | 4.60 | 2022-11-11 | 1 | 170.14 | 1 | 183.94 | 8 | SO46995 | 2022-11-18 | 14.72 | 170.14 | 183.94 | |||
SO46608_19 | ACF1-4852-B7 | PO18473177913 | 19 | 291 | 411 | 442 | 6 | 2022-10-23 | 125.42 | 3.14 | 2022-10-11 | 1 | 92.81 | 1 | 125.42 | 19 | SO46608 | 2022-10-18 | 10.03 | 92.81 | 125.42 | |||
SO69482_6 | 0D35-42F6-9E | PO18357170772 | 19 | 284 | 491 | 138 | 6 | 2024-08-23 | 129.58 | 3.24 | 2024-08-11 | 4 | 41.57 | 1 | 129.58 | 6 | SO69482 | 2024-08-18 | 10.37 | 166.29 | 32.39 | |||
SO48066_11 | F00E-4B06-9D | PO5684167807 | 100 | 282 | 308 | 385 | 4 | 2023-02-23 | 1488.55 | 37.21 | 2023-02-11 | 2 | 660.91 | 1 | 1488.55 | 11 | SO48066 | 2023-02-18 | 119.08 | 1321.83 | 744.27 | |||
SO53565_40 | 7768-4A45-93 | PO9396130858 | 6 | 296 | 586 | 13 | 267 | 9 | 100.22 | 2023-12-24 | 668.12 | 14.20 | 2023-12-12 | 2 | 461.44 | 1 | 567.90 | 40 | SO53565 | 2023-12-19 | 45.43 | 922.89 | 334.06 | 0.15 |
SO63266_26 | 4D6E-4BF2-B9 | PO4466196255 | 19 | 291 | 476 | 352 | 6 | 2024-05-25 | 209.97 | 5.25 | 2024-05-13 | 5 | 26.18 | 1 | 209.97 | 26 | SO63266 | 2024-05-20 | 16.80 | 130.88 | 41.99 |
Generated 2024-11-10 11:42:30.002 UTC