[ROOT] dt FactResellerSale < WHERE DimSalesTerritoryId EQ '6' > SHUFFLE < SKIP 233 > < TAKE 28 >
28 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 |
---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
SO57122_3 | 048F-465A-A8 | PO4901112587 | 19 | 284 | 225 | 3 | 84 | 6 | 3.96 | 2024-01-03 | 79.11 | 1.88 | 2023-12-22 | 16 | 6.92 | 1 | 75.16 | 3 | SO57122 | 2023-12-29 | 6.01 | 110.76 | 4.94 | 0.05 |
SO55243_2 | 2457-46EE-88 | PO15312160912 | 19 | 291 | 440 | 299 | 6 | 2023-12-03 | 858.90 | 21.47 | 2023-11-21 | 1 | 868.63 | 1 | 858.90 | 2 | SO55243 | 2023-11-28 | 68.71 | 868.63 | 858.90 | |||
SO63239_10 | AF5E-48ED-A4 | PO4901178462 | 19 | 284 | 374 | 84 | 6 | 2024-04-04 | 2932.02 | 73.30 | 2024-03-23 | 2 | 1554.95 | 1 | 2932.02 | 10 | SO63239 | 2024-03-30 | 234.56 | 3109.90 | 1466.01 | |||
SO45323_24 | 8E16-4834-8A | PO4901118407 | 19 | 284 | 319 | 84 | 6 | 2022-04-05 | 6123.56 | 153.09 | 2022-03-24 | 7 | 884.71 | 1 | 6123.56 | 24 | SO45323 | 2022-03-31 | 489.88 | 6192.96 | 874.79 | |||
SO49094_13 | FEDE-45BA-90 | PO18705130501 | 19 | 291 | 221 | 479 | 6 | 2023-04-05 | 20.19 | 0.50 | 2023-03-24 | 1 | 13.88 | 1 | 20.19 | 13 | SO49094 | 2023-03-31 | 1.61 | 13.88 | 20.19 | |||
SO65206_5 | 6CD1-4BEC-A0 | PO1798192797 | 19 | 291 | 511 | 10 | 6 | 2024-05-03 | 436.91 | 10.92 | 2024-04-21 | 2 | 199.38 | 1 | 436.91 | 5 | SO65206 | 2024-04-28 | 34.95 | 398.75 | 218.45 | |||
SO46953_9 | C650-4C32-BE | PO17603154442 | 19 | 284 | 327 | 9 | 12 | 6 | 1197.97 | 2022-10-03 | 3993.25 | 69.88 | 2022-09-21 | 17 | 486.71 | 1 | 2795.27 | 9 | SO46953 | 2022-09-28 | 223.62 | 8274.01 | 234.90 | 0.30 |
SO71916_2 | A839-4E9B-82 | PO1972110209 | 19 | 291 | 599 | 190 | 6 | 2024-08-03 | 971.98 | 24.30 | 2024-07-22 | 3 | 294.58 | 1 | 971.98 | 2 | SO71916 | 2024-07-29 | 77.76 | 883.74 | 323.99 | |||
SO57122_26 | 048F-465A-A8 | PO4901112587 | 19 | 284 | 465 | 84 | 6 | 2024-01-03 | 58.78 | 1.47 | 2023-12-22 | 4 | 9.16 | 1 | 58.78 | 26 | SO57122 | 2023-12-29 | 4.70 | 36.64 | 14.69 | |||
SO53545_9 | 2CC7-4F36-B6 | PO14239178578 | 19 | 291 | 481 | 550 | 6 | 2023-11-03 | 21.58 | 0.54 | 2023-10-22 | 4 | 3.36 | 1 | 21.58 | 9 | SO53545 | 2023-10-29 | 1.73 | 13.45 | 5.39 | |||
SO51755_7 | 46F4-477C-A7 | PO11020169365 | 19 | 284 | 482 | 336 | 6 | 2023-10-03 | 16.18 | 0.40 | 2023-09-21 | 3 | 3.36 | 1 | 16.18 | 7 | SO51755 | 2023-09-28 | 1.29 | 10.09 | 5.39 | |||
SO65174_20 | E2AA-4EEC-93 | PO17574133893 | 19 | 291 | 217 | 678 | 6 | 2024-05-03 | 146.96 | 3.67 | 2024-04-21 | 7 | 13.09 | 1 | 146.96 | 20 | SO65174 | 2024-04-28 | 11.76 | 91.60 | 20.99 | |||
SO43888_5 | 7AED-4154-93 | PO2088113013 | 19 | 288 | 338 | 136 | 6 | 2021-10-03 | 419.46 | 10.49 | 2021-09-21 | 1 | 413.15 | 1 | 419.46 | 5 | SO43888 | 2021-09-28 | 33.56 | 413.15 | 419.46 | |||
SO71806_4 | 26A7-4E95-9B | PO14790111844 | 19 | 291 | 524 | 497 | 6 | 2024-08-03 | 316.86 | 7.92 | 2024-07-22 | 2 | 144.59 | 1 | 316.86 | 4 | SO71806 | 2024-07-29 | 25.35 | 289.19 | 158.43 | |||
SO50689_42 | 20BC-4161-86 | PO10614135588 | 19 | 291 | 230 | 461 | 6 | 2023-08-03 | 144.20 | 3.61 | 2023-07-22 | 5 | 29.08 | 1 | 144.20 | 42 | SO50689 | 2023-07-29 | 11.54 | 145.40 | 28.84 | |||
SO46333_20 | B042-408B-A8 | PO17545158984 | 19 | 288 | 316 | 155 | 6 | 2022-08-03 | 3499.18 | 87.48 | 2022-07-22 | 4 | 884.71 | 1 | 3499.18 | 20 | SO46333 | 2022-07-29 | 279.93 | 3538.83 | 874.79 | |||
SO55275_32 | 72C3-4048-BC | PO1711122362 | 19 | 291 | 298 | 245 | 6 | 2023-12-03 | 1619.52 | 40.49 | 2023-11-21 | 2 | 739.04 | 1 | 1619.52 | 32 | SO55275 | 2023-11-28 | 129.56 | 1478.08 | 809.76 | |||
SO51124_43 | 5EEF-4271-BB | PO1711177181 | 19 | 291 | 517 | 245 | 6 | 2023-09-02 | 157.92 | 3.95 | 2023-08-21 | 5 | 23.37 | 1 | 157.92 | 43 | SO51124 | 2023-08-28 | 12.63 | 116.86 | 31.58 | |||
SO45057_1 | 568E-472E-9C | PO11049133413 | 19 | 284 | 326 | 679 | 6 | 2022-03-05 | 419.46 | 10.49 | 2022-02-21 | 1 | 413.15 | 1 | 419.46 | 1 | SO45057 | 2022-02-28 | 33.56 | 413.15 | 419.46 | |||
SO59042_2 | 8DB9-4316-8F | PO1972174730 | 19 | 291 | 592 | 190 | 6 | 2024-02-02 | 338.99 | 8.47 | 2024-01-21 | 1 | 308.22 | 1 | 338.99 | 2 | SO59042 | 2024-01-28 | 27.12 | 308.22 | 338.99 | |||
SO48750_24 | 9A71-449E-B6 | PO14732147398 | 19 | 291 | 271 | 514 | 6 | 2023-03-05 | 1618.66 | 40.47 | 2023-02-21 | 8 | 187.16 | 1 | 1618.66 | 24 | SO48750 | 2023-02-28 | 129.49 | 1497.26 | 202.33 | |||
SO49138_17 | 487B-46D8-9B | PO4466190674 | 19 | 291 | 470 | 352 | 6 | 2023-04-05 | 205.15 | 5.13 | 2023-03-24 | 9 | 15.67 | 1 | 205.15 | 17 | SO49138 | 2023-03-31 | 16.41 | 141.04 | 22.79 | |||
SO69399_4 | BEA9-4703-91 | PO17661173810 | 19 | 284 | 565 | 264 | 6 | 2024-07-03 | 1336.23 | 33.41 | 2024-06-21 | 3 | 461.44 | 1 | 1336.23 | 4 | SO69399 | 2024-06-28 | 106.90 | 1384.33 | 445.41 | |||
SO57019_7 | D018-44A0-BF | PO18879140423 | 19 | 291 | 552 | 64 | 6 | 2024-01-03 | 54.89 | 1.37 | 2023-12-22 | 1 | 40.62 | 1 | 54.89 | 7 | SO57019 | 2023-12-29 | 4.39 | 40.62 | 54.89 | |||
SO48778_42 | 4F83-4D59-87 | PO4495173571 | 19 | 291 | 354 | 496 | 6 | 2023-03-05 | 4971.41 | 124.29 | 2023-02-21 | 4 | 1117.86 | 1 | 4971.41 | 42 | SO48778 | 2023-02-28 | 397.71 | 4471.42 | 1242.85 | |||
SO63138_1 | 3BDB-40B5-A6 | PO17806142534 | 19 | 291 | 605 | 101 | 6 | 2024-04-04 | 323.99 | 8.10 | 2024-03-23 | 1 | 343.65 | 1 | 323.99 | 1 | SO63138 | 2024-03-30 | 25.92 | 343.65 | 323.99 | |||
SO49140_20 | EFF3-483D-BE | PO4901154744 | 19 | 284 | 459 | 84 | 6 | 2023-04-05 | 269.97 | 6.75 | 2023-03-24 | 5 | 37.12 | 1 | 269.97 | 20 | SO49140 | 2023-03-31 | 21.60 | 185.60 | 53.99 | |||
SO46330_12 | 4E4A-4105-8E | PO18299117472 | 19 | 288 | 296 | 118 | 6 | 2022-08-03 | 714.70 | 17.87 | 2022-07-22 | 1 | 617.03 | 1 | 714.70 | 12 | SO46330 | 2022-07-29 | 57.18 | 617.03 | 714.70 |
Generated 2024-09-20 09:24:30.252 UTC