[ROOT] dt FactResellerSale < WHERE DimSalesTerritoryId EQ '10' > SHUFFLE SKIP 2000 < SKIP 1062 > < 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 |
---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
SO47451_24 | 6525-4619-9A | PO8671131661 | 98 | 288 | 354 | 2 | 502 | 10 | 264.31 | 2022-11-02 | 13215.66 | 323.78 | 2022-10-21 | 11 | 1117.86 | 1 | 12951.34 | 24 | SO47451 | 2022-10-28 | 1036.11 | 12296.41 | 1201.42 | 0.02 |
SO47447_25 | 5913-43AF-8D | PO8468183786 | 98 | 288 | 458 | 16 | 10 | 2022-11-02 | 179.98 | 4.50 | 2022-10-21 | 4 | 30.93 | 1 | 179.98 | 25 | SO47447 | 2022-10-28 | 14.40 | 123.73 | 44.99 | |||
SO50728_9 | 4054-4DE7-86 | PO8671171267 | 98 | 288 | 364 | 502 | 10 | 2023-08-02 | 1295.99 | 32.40 | 2023-07-21 | 2 | 598.44 | 1 | 1295.99 | 9 | SO50728 | 2023-07-28 | 103.68 | 1196.87 | 647.99 | |||
SO55323_36 | 7398-4A3C-BE | PO8410135313 | 98 | 288 | 605 | 538 | 10 | 2023-12-02 | 971.98 | 24.30 | 2023-11-20 | 3 | 343.65 | 1 | 971.98 | 36 | SO55323 | 2023-11-27 | 77.76 | 1030.95 | 323.99 | |||
SO48389_22 | 304D-46A7-8E | PO8671159284 | 98 | 288 | 297 | 502 | 10 | 2023-02-01 | 1472.29 | 36.81 | 2023-01-20 | 2 | 653.70 | 1 | 1472.29 | 22 | SO48389 | 2023-01-27 | 117.78 | 1307.39 | 736.15 | |||
SO65319_9 | 9F05-4591-9D | PO8671197482 | 98 | 288 | 357 | 502 | 10 | 2024-05-02 | 1391.99 | 34.80 | 2024-04-20 | 1 | 1265.62 | 1 | 1391.99 | 9 | SO65319 | 2024-04-27 | 111.36 | 1265.62 | 1391.99 | |||
SO65271_21 | 11E0-45B2-93 | PO8468172113 | 98 | 288 | 605 | 16 | 10 | 2024-05-02 | 2267.96 | 56.70 | 2024-04-20 | 7 | 343.65 | 1 | 2267.96 | 21 | SO65271 | 2024-04-27 | 181.44 | 2405.55 | 323.99 | |||
SO51771_13 | F78B-4D68-8E | PO1508157846 | 98 | 288 | 237 | 430 | 10 | 2023-10-02 | 179.96 | 4.50 | 2023-09-20 | 6 | 38.49 | 1 | 179.96 | 13 | SO51771 | 2023-09-27 | 14.40 | 230.95 | 29.99 | |||
SO71780_24 | 36CB-4A10-92 | PO19604173239 | 98 | 288 | 400 | 340 | 10 | 2024-08-02 | 111.46 | 2.79 | 2024-07-21 | 3 | 27.49 | 1 | 111.46 | 24 | SO71780 | 2024-07-28 | 8.92 | 82.48 | 37.15 | |||
SO51143_15 | 5AF9-4974-90 | PO8410118711 | 98 | 288 | 482 | 538 | 10 | 2023-09-01 | 26.97 | 0.67 | 2023-08-20 | 5 | 3.36 | 1 | 26.97 | 15 | SO51143 | 2023-08-27 | 2.16 | 16.81 | 5.39 | |||
SO49521_8 | 48A5-48F5-80 | PO8671117542 | 98 | 288 | 421 | 502 | 10 | 2023-05-02 | 392.66 | 9.82 | 2023-04-20 | 2 | 145.28 | 1 | 392.66 | 8 | SO49521 | 2023-04-27 | 31.41 | 290.57 | 196.33 | |||
SO71832_23 | 269D-4F59-82 | PO10353140756 | 98 | 288 | 355 | 88 | 10 | 2024-08-02 | 1391.99 | 34.80 | 2024-07-21 | 1 | 1265.62 | 1 | 1391.99 | 23 | SO71832 | 2024-07-28 | 111.36 | 1265.62 | 1391.99 | |||
SO49521_4 | 48A5-48F5-80 | PO8671117542 | 98 | 288 | 294 | 502 | 10 | 2023-05-02 | 1488.55 | 37.21 | 2023-04-20 | 2 | 660.91 | 1 | 1488.55 | 4 | SO49521 | 2023-04-27 | 119.08 | 1321.83 | 744.27 | |||
SO65224_13 | 6213-43FA-9B | PO10353176854 | 98 | 288 | 590 | 88 | 10 | 2024-05-02 | 1846.78 | 46.17 | 2024-04-20 | 4 | 419.78 | 1 | 1846.78 | 13 | SO65224 | 2024-04-27 | 147.74 | 1679.11 | 461.69 | |||
SO53472_8 | 892C-445A-B6 | PO16501111174 | 98 | 288 | 583 | 142 | 10 | 2023-11-02 | 3061.78 | 76.54 | 2023-10-21 | 3 | 1082.51 | 1 | 3061.78 | 8 | SO53472 | 2023-10-28 | 244.94 | 3247.53 | 1020.59 | |||
SO57083_5 | 37CC-47DA-BC | PO1508182511 | 98 | 288 | 384 | 430 | 10 | 2024-01-02 | 3361.47 | 84.04 | 2023-12-21 | 5 | 713.08 | 1 | 3361.47 | 5 | SO57083 | 2023-12-28 | 268.92 | 3565.40 | 672.29 | |||
SO47447_44 | 5913-43AF-8D | PO8468183786 | 98 | 288 | 459 | 16 | 10 | 2022-11-02 | 53.99 | 1.35 | 2022-10-21 | 1 | 37.12 | 1 | 53.99 | 44 | SO47447 | 2022-10-28 | 4.32 | 37.12 | 53.99 | |||
SO49521_26 | 48A5-48F5-80 | PO8671117542 | 98 | 288 | 428 | 502 | 10 | 2023-05-02 | 837.02 | 20.93 | 2023-04-20 | 4 | 185.82 | 1 | 837.02 | 26 | SO49521 | 2023-04-27 | 66.96 | 743.28 | 209.26 | |||
SO58908_15 | A429-40BA-96 | PO19285116289 | 98 | 290 | 483 | 448 | 10 | 2024-02-01 | 144.00 | 3.60 | 2024-01-20 | 2 | 44.88 | 1 | 144.00 | 15 | SO58908 | 2024-01-27 | 11.52 | 89.76 | 72.00 | |||
SO69497_1 | 92DE-45C8-BB | PO8439178627 | 98 | 288 | 225 | 574 | 10 | 2024-07-02 | 21.58 | 0.54 | 2024-06-20 | 4 | 6.92 | 1 | 21.58 | 1 | SO69497 | 2024-06-27 | 1.73 | 27.69 | 5.39 | |||
SO69470_1 | 44E4-4264-A5 | PO19024173467 | 98 | 288 | 580 | 124 | 10 | 2024-07-02 | 3061.78 | 76.54 | 2024-06-20 | 3 | 1082.51 | 1 | 3061.78 | 1 | SO69470 | 2024-06-27 | 244.94 | 3247.53 | 1020.59 | |||
SO65224_8 | 6213-43FA-9B | PO10353176854 | 98 | 288 | 588 | 88 | 10 | 2024-05-02 | 461.69 | 11.54 | 2024-04-20 | 1 | 419.78 | 1 | 461.69 | 8 | SO65224 | 2024-04-27 | 36.94 | 419.78 | 461.69 | |||
SO65224_2 | 6213-43FA-9B | PO10353176854 | 98 | 288 | 524 | 88 | 10 | 2024-05-02 | 158.43 | 3.96 | 2024-04-20 | 1 | 144.59 | 1 | 158.43 | 2 | SO65224 | 2024-04-27 | 12.67 | 144.59 | 158.43 | |||
SO53562_47 | 9FC2-4D08-A7 | PO8468156175 | 98 | 288 | 388 | 16 | 10 | 2023-11-02 | 2689.18 | 67.23 | 2023-10-21 | 4 | 713.08 | 1 | 2689.18 | 47 | SO53562 | 2023-10-28 | 215.13 | 2852.32 | 672.29 | |||
SO57180_8 | 32F1-420E-BD | PO8642124468 | 98 | 288 | 499 | 520 | 10 | 2024-01-02 | 1204.69 | 30.12 | 2023-12-21 | 2 | 601.74 | 1 | 1204.69 | 8 | SO57180 | 2023-12-28 | 96.38 | 1203.49 | 602.35 | |||
SO47451_22 | 6525-4619-9A | PO8671131661 | 98 | 288 | 395 | 3 | 502 | 10 | 42.19 | 2022-11-02 | 843.89 | 20.04 | 2022-10-21 | 15 | 45.42 | 1 | 801.70 | 22 | SO47451 | 2022-10-28 | 64.14 | 681.25 | 56.26 | 0.05 |
SO55323_4 | 7398-4A3C-BE | PO8410135313 | 98 | 288 | 231 | 538 | 10 | 2023-12-02 | 239.95 | 6.00 | 2023-11-20 | 8 | 38.49 | 1 | 239.95 | 4 | SO55323 | 2023-11-27 | 19.20 | 307.94 | 29.99 | |||
SO53573_3 | F674-4899-B9 | PO8671117198 | 98 | 288 | 514 | 502 | 10 | 2023-11-02 | 191.70 | 4.79 | 2023-10-21 | 3 | 47.29 | 1 | 191.70 | 3 | SO53573 | 2023-10-28 | 15.34 | 141.86 | 63.90 | |||
SO53472_54 | 892C-445A-B6 | PO16501111174 | 98 | 288 | 581 | 142 | 10 | 2023-11-02 | 2041.19 | 51.03 | 2023-10-21 | 2 | 1082.51 | 1 | 2041.19 | 54 | SO53472 | 2023-10-28 | 163.30 | 2165.02 | 1020.59 | |||
SO47451_2 | 6525-4619-9A | PO8671131661 | 98 | 288 | 294 | 502 | 10 | 2022-11-02 | 744.27 | 18.61 | 2022-10-21 | 1 | 660.91 | 1 | 744.27 | 2 | SO47451 | 2022-10-28 | 59.54 | 660.91 | 744.27 | |||
SO48389_27 | 304D-46A7-8E | PO8671159284 | 98 | 288 | 362 | 502 | 10 | 2023-02-01 | 4917.84 | 122.95 | 2023-01-20 | 4 | 1105.81 | 1 | 4917.84 | 27 | SO48389 | 2023-01-27 | 393.43 | 4423.24 | 1229.46 |
Generated 2024-09-20 02:50:31.779 UTC