[ROOT] dt FactResellerSale < WHERE DimSalesTerritoryId EQ ALL SKIP 1000 SKIP 0 SHUFFLE < SKIP 812 > < TAKE 31 >
31 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 |
---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
SO50696_15 | C32F-4FEE-A3 | PO1624119214 | 100 | 281 | 447 | 579 | 3 | 2023-08-03 | 75.00 | 1.88 | 2023-07-22 | 5 | 10.31 | 1 | 75.00 | 15 | SO50696 | 2023-07-29 | 6.00 | 51.56 | 15.00 | |||
SO65155_5 | 154D-4EBA-85 | PO19633122185 | 100 | 287 | 363 | 149 | 3 | 2024-05-03 | 2753.99 | 68.85 | 2024-04-21 | 2 | 1251.98 | 1 | 2753.99 | 5 | SO65155 | 2024-04-28 | 220.32 | 2503.96 | 1376.99 | |||
SO63128_14 | 9486-41CD-91 | PO18879146432 | 19 | 291 | 569 | 64 | 6 | 2024-04-04 | 890.82 | 22.27 | 2024-03-23 | 2 | 461.44 | 1 | 890.82 | 14 | SO63128 | 2024-03-30 | 71.27 | 922.89 | 445.41 | |||
SO49052_20 | 8769-409E-94 | PO16733182723 | 19 | 291 | 381 | 533 | 6 | 2023-04-05 | 3001.31 | 75.03 | 2023-03-24 | 5 | 605.65 | 1 | 3001.31 | 20 | SO49052 | 2023-03-31 | 240.11 | 3028.25 | 600.26 | |||
SO46385_2 | F727-48F0-AF | PO9483110086 | 100 | 281 | 330 | 54 | 2 | 2022-08-03 | 2516.75 | 62.92 | 2022-07-22 | 6 | 413.15 | 1 | 2516.75 | 2 | SO46385 | 2022-07-29 | 201.34 | 2478.88 | 419.46 | |||
SO71795_6 | 5843-4E7D-8D | PO17371184627 | 6 | 296 | 573 | 688 | 9 | 2024-08-03 | 1430.44 | 35.76 | 2024-07-22 | 1 | 1481.94 | 1 | 1430.44 | 6 | SO71795 | 2024-07-29 | 114.44 | 1481.94 | 1430.44 | |||
SO57080_27 | A38F-4C07-81 | PO957167312 | 98 | 288 | 474 | 4 | 376 | 10 | 87.49 | 2024-01-03 | 874.88 | 19.68 | 2023-12-22 | 25 | 26.18 | 1 | 787.39 | 27 | SO57080 | 2023-12-29 | 62.99 | 654.41 | 35.00 | 0.10 |
SO47985_1 | E577-440F-97 | PO16878189259 | 100 | 282 | 394 | 115 | 1 | 2023-01-03 | 20.52 | 0.51 | 2022-12-22 | 1 | 15.18 | 1 | 20.52 | 1 | SO47985 | 2022-12-29 | 1.64 | 15.18 | 20.52 | |||
SO46624_16 | 12A0-4CA7-93 | PO13659199342 | 100 | 287 | 427 | 437 | 4 | 2022-09-02 | 418.51 | 10.46 | 2022-08-21 | 2 | 185.82 | 1 | 418.51 | 16 | SO46624 | 2022-08-28 | 33.48 | 371.64 | 209.26 | |||
SO48069_9 | 60CF-43B6-82 | PO6438117188 | 100 | 283 | 221 | 309 | 4 | 2023-01-03 | 20.19 | 0.50 | 2022-12-22 | 1 | 13.88 | 1 | 20.19 | 9 | SO48069 | 2022-12-29 | 1.61 | 13.88 | 20.19 | |||
SO44533_5 | 6A24-4735-B2 | PO1827111566 | 19 | 288 | 275 | 317 | 6 | 2022-01-03 | 356.90 | 8.92 | 2021-12-22 | 1 | 352.14 | 1 | 356.90 | 5 | SO44533 | 2021-12-29 | 28.55 | 352.14 | 356.90 | |||
SO51169_9 | 995D-4C3D-86 | PO5452173982 | 36 | 295 | 498 | 320 | 8 | 2023-09-02 | 2409.38 | 60.23 | 2023-08-21 | 4 | 601.74 | 1 | 2409.38 | 9 | SO51169 | 2023-08-28 | 192.75 | 2406.97 | 602.35 | |||
SO49480_4 | BA71-43B7-82 | PO19401115391 | 19 | 291 | 379 | 173 | 6 | 2023-05-03 | 2617.88 | 65.45 | 2023-04-21 | 2 | 1320.68 | 1 | 2617.88 | 4 | SO49480 | 2023-04-28 | 209.43 | 2641.37 | 1308.94 | |||
SO57037_8 | F0A9-4A16-B9 | PO15370120234 | 100 | 281 | 525 | 381 | 3 | 2024-01-03 | 158.43 | 3.96 | 2023-12-22 | 1 | 144.59 | 1 | 158.43 | 8 | SO57037 | 2023-12-29 | 12.67 | 144.59 | 158.43 | |||
SO57186_18 | EF93-4946-97 | PO8845159326 | 100 | 282 | 524 | 546 | 3 | 2024-01-03 | 633.72 | 15.84 | 2023-12-22 | 4 | 144.59 | 1 | 633.72 | 18 | SO57186 | 2023-12-29 | 50.70 | 578.38 | 158.43 | |||
SO47716_9 | 619E-46D6-98 | PO6467148836 | 100 | 281 | 414 | 660 | 3 | 2022-12-03 | 447.09 | 11.18 | 2022-11-21 | 3 | 110.28 | 1 | 447.09 | 9 | SO47716 | 2022-11-28 | 35.77 | 330.85 | 149.03 | |||
SO48071_9 | E6F7-41F8-92 | PO6525193011 | 100 | 283 | 365 | 345 | 4 | 2023-01-03 | 1943.98 | 48.60 | 2022-12-22 | 3 | 598.44 | 1 | 1943.98 | 9 | SO48071 | 2022-12-29 | 155.52 | 1795.31 | 647.99 | |||
SO51740_21 | A7C0-406B-82 | PO12789111329 | 19 | 291 | 490 | 677 | 6 | 2023-10-03 | 32.39 | 0.81 | 2023-09-21 | 1 | 41.57 | 1 | 32.39 | 21 | SO51740 | 2023-09-28 | 2.59 | 41.57 | 32.39 | |||
SO44520_34 | 5BE0-436B-8C | PO12499152870 | 100 | 282 | 319 | 78 | 4 | 2022-01-03 | 7873.15 | 196.83 | 2021-12-22 | 9 | 884.71 | 1 | 7873.15 | 34 | SO44520 | 2021-12-29 | 629.85 | 7962.37 | 874.79 | |||
SO69532_2 | 27FB-4A86-85 | PO3799165791 | 100 | 282 | 353 | 312 | 4 | 2024-07-03 | 11135.95 | 278.40 | 2024-06-21 | 8 | 1265.62 | 1 | 11135.95 | 2 | SO69532 | 2024-06-28 | 890.88 | 10124.96 | 1391.99 | |||
SO50272_34 | E0A6-4CFA-90 | PO11745174916 | 100 | 282 | 371 | 97 | 4 | 2023-07-03 | 2617.88 | 65.45 | 2023-06-21 | 2 | 1320.68 | 1 | 2617.88 | 34 | SO50272 | 2023-06-28 | 209.43 | 2641.37 | 1308.94 | |||
SO45565_1 | B963-45A4-B4 | PO5597130894 | 100 | 283 | 344 | 75 | 4 | 2022-05-03 | 8159.98 | 204.00 | 2022-04-21 | 4 | 1912.15 | 1 | 8159.98 | 1 | SO45565 | 2022-04-28 | 652.80 | 7648.62 | 2039.99 | |||
SO47364_1 | 3411-4EF9-9A | PO16994146051 | 100 | 281 | 286 | 306 | 3 | 2022-11-03 | 183.94 | 4.60 | 2022-10-22 | 1 | 170.14 | 1 | 183.94 | 1 | SO47364 | 2022-10-29 | 14.72 | 170.14 | 183.94 | |||
SO51739_60 | AF60-4F2F-9B | PO12702124697 | 100 | 292 | 357 | 175 | 7 | 2023-10-03 | 13919.94 | 348.00 | 2023-09-21 | 10 | 1265.62 | 1 | 13919.94 | 60 | SO51739 | 2023-09-28 | 1113.60 | 12656.20 | 1391.99 | |||
SO50252_27 | B5DA-491E-A9 | PO2523194031 | 100 | 287 | 233 | 167 | 4 | 2023-07-03 | 86.52 | 2.16 | 2023-06-21 | 3 | 29.08 | 1 | 86.52 | 27 | SO50252 | 2023-06-28 | 6.92 | 87.24 | 28.84 | |||
SO44319_6 | FBB9-4CD9-A1 | PO9657142761 | 100 | 285 | 349 | 315 | 5 | 2021-12-03 | 8099.98 | 202.50 | 2021-11-21 | 4 | 1898.09 | 1 | 8099.98 | 6 | SO44319 | 2021-11-28 | 648.00 | 7592.38 | 2024.99 | |||
SO63182_2 | DA28-4B67-AB | PO2871138930 | 100 | 283 | 586 | 522 | 2 | 2024-04-04 | 890.82 | 22.27 | 2024-03-23 | 2 | 461.44 | 1 | 890.82 | 2 | SO63182 | 2024-03-30 | 71.27 | 922.89 | 445.41 | |||
SO59029_19 | E358-40C0-B2 | PO4640116818 | 100 | 287 | 589 | 648 | 4 | 2024-02-02 | 2308.47 | 57.71 | 2024-01-21 | 5 | 419.78 | 1 | 2308.47 | 19 | SO59029 | 2024-01-28 | 184.68 | 2098.89 | 461.69 | |||
SO47441_29 | 2582-4E47-98 | PO7569166535 | 100 | 287 | 427 | 608 | 4 | 2022-11-03 | 1674.05 | 41.85 | 2022-10-22 | 8 | 185.82 | 1 | 1674.05 | 29 | SO47441 | 2022-10-29 | 133.92 | 1486.55 | 209.26 | |||
SO48318_29 | 7FD9-425F-A3 | PO15341152410 | 100 | 283 | 448 | 327 | 3 | 2023-02-02 | 59.97 | 1.50 | 2023-01-21 | 5 | 8.25 | 1 | 59.97 | 29 | SO48318 | 2023-01-28 | 4.80 | 41.23 | 11.99 | |||
SO61227_18 | 9006-4208-8F | PO10730172247 | 100 | 287 | 580 | 491 | 4 | 2024-03-04 | 4082.38 | 102.06 | 2024-02-21 | 4 | 1082.51 | 1 | 4082.38 | 18 | SO61227 | 2024-02-28 | 326.59 | 4330.04 | 1020.59 |
Generated 2024-09-20 09:49:00.199 UTC