[ROOT] dt FactResellerSale < WHERE DimSalesTerritoryId EQ '4' > SHUFFLE < SKIP 2563 > < TAKE 30 >
30 items
FactResellerSaleId | CarrierTrackingNumber | CustomerPONumber | DimCurrencyId | DimEmployeeId | DimProductId | DimResellerId | DimSalesTerritoryId | DueDate | ExtendedAmount | Freight | OrderDate | OrderQuantity | ProductStandardCost | RevisionNumber | SalesAmount | SalesOrderLineNumber | SalesOrderNumber | ShipDate | TaxAmt | TotalProductCost | UnitPrice |
---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
SO46660_11 | CF24-45E2-9D | PO5626129733 | 100 | 283 | 415 | 166 | 4 | 2022-10-23 | 792.14 | 19.80 | 2022-10-11 | 4 | 146.55 | 1 | 792.14 | 11 | SO46660 | 2022-10-18 | 63.37 | 586.19 | 198.04 |
SO59026_2 | 6264-4C83-B2 | PO4002182599 | 100 | 282 | 545 | 674 | 4 | 2024-03-24 | 24.29 | 0.61 | 2024-03-12 | 1 | 17.98 | 1 | 24.29 | 2 | SO59026 | 2024-03-19 | 1.94 | 17.98 | 24.29 |
SO55264_9 | 80F3-4A7B-A2 | PO10730163005 | 100 | 287 | 376 | 491 | 4 | 2024-01-23 | 2932.02 | 73.30 | 2024-01-11 | 2 | 1554.95 | 1 | 2932.02 | 9 | SO55264 | 2024-01-18 | 234.56 | 3109.90 | 1466.01 |
SO53531_5 | B1FB-47B2-8E | PO2697181370 | 100 | 282 | 527 | 187 | 4 | 2023-12-24 | 633.72 | 15.84 | 2023-12-12 | 4 | 144.59 | 1 | 633.72 | 5 | SO53531 | 2023-12-19 | 50.70 | 578.38 | 158.43 |
SO50672_40 | 1BE9-437C-8A | PO16472110144 | 100 | 287 | 377 | 239 | 4 | 2023-09-23 | 5235.75 | 130.89 | 2023-09-11 | 4 | 1320.68 | 1 | 5235.75 | 40 | SO50672 | 2023-09-18 | 418.86 | 5282.74 | 1308.94 |
SO44317_1 | BE9B-42BA-87 | PO7859142280 | 100 | 287 | 316 | 221 | 4 | 2022-01-23 | 3499.18 | 87.48 | 2022-01-11 | 4 | 884.71 | 1 | 3499.18 | 1 | SO44317 | 2022-01-18 | 279.93 | 3538.83 | 874.79 |
SO59013_34 | C224-4535-BA | PO5597199820 | 100 | 281 | 594 | 75 | 4 | 2024-03-24 | 677.99 | 16.95 | 2024-03-12 | 2 | 308.22 | 1 | 677.99 | 34 | SO59013 | 2024-03-19 | 54.24 | 616.44 | 338.99 |
SO45044_4 | DC47-40A2-8F | PO16008114038 | 100 | 282 | 314 | 511 | 4 | 2022-04-25 | 2146.96 | 53.67 | 2022-04-13 | 1 | 2171.29 | 1 | 2146.96 | 4 | SO45044 | 2022-04-20 | 171.76 | 2171.29 | 2146.96 |
SO55256_25 | 686E-4D36-8B | PO12528136439 | 100 | 282 | 569 | 331 | 4 | 2024-01-23 | 445.41 | 11.14 | 2024-01-11 | 1 | 461.44 | 1 | 445.41 | 25 | SO55256 | 2024-01-18 | 35.63 | 461.44 | 445.41 |
SO65303_30 | 93EA-4158-A9 | PO5539133147 | 100 | 282 | 363 | 61 | 4 | 2024-06-23 | 9638.96 | 240.97 | 2024-06-11 | 7 | 1251.98 | 1 | 9638.96 | 30 | SO65303 | 2024-06-18 | 771.12 | 8763.87 | 1376.99 |
SO51090_7 | EBDE-4A71-8E | PO13688110947 | 100 | 282 | 588 | 475 | 4 | 2023-10-23 | 1846.78 | 46.17 | 2023-10-11 | 4 | 419.78 | 1 | 1846.78 | 7 | SO51090 | 2023-10-18 | 147.74 | 1679.11 | 461.69 |
SO69515_9 | D9C1-4837-A7 | PO6351170694 | 100 | 281 | 434 | 255 | 4 | 2024-08-23 | 1427.59 | 35.69 | 2024-08-11 | 4 | 360.94 | 1 | 1427.59 | 9 | SO69515 | 2024-08-18 | 114.21 | 1443.77 | 356.90 |
SO50738_24 | 531C-4E52-80 | PO3915159731 | 100 | 281 | 385 | 130 | 4 | 2023-09-23 | 1800.79 | 45.02 | 2023-09-11 | 3 | 605.65 | 1 | 1800.79 | 24 | SO50738 | 2023-09-18 | 144.06 | 1816.95 | 600.26 |
SO53580_2 | FFE9-4F36-B2 | PO4640164085 | 100 | 287 | 588 | 648 | 4 | 2023-12-24 | 461.69 | 11.54 | 2023-12-12 | 1 | 419.78 | 1 | 461.69 | 2 | SO53580 | 2023-12-19 | 36.94 | 419.78 | 461.69 |
SO47712_19 | 299D-4C8A-BF | PO5626117491 | 100 | 283 | 417 | 166 | 4 | 2023-01-23 | 1622.26 | 40.56 | 2023-01-11 | 5 | 300.12 | 1 | 1622.26 | 19 | SO47712 | 2023-01-18 | 129.78 | 1500.59 | 324.45 |
SO49490_29 | 0396-4322-83 | PO19343175441 | 100 | 282 | 271 | 24 | 4 | 2023-06-23 | 1011.66 | 25.29 | 2023-06-11 | 5 | 187.16 | 1 | 1011.66 | 29 | SO49490 | 2023-06-18 | 80.93 | 935.79 | 202.33 |
SO63283_11 | 5DCA-44B0-BB | PO3799140598 | 100 | 282 | 532 | 312 | 4 | 2024-05-25 | 149.87 | 3.75 | 2024-05-13 | 1 | 136.79 | 1 | 149.87 | 11 | SO63283 | 2024-05-20 | 11.99 | 136.79 | 149.87 |
SO46964_47 | B3E6-43CC-A2 | PO15689139014 | 100 | 283 | 343 | 328 | 4 | 2022-11-23 | 1409.38 | 35.23 | 2022-11-11 | 3 | 486.71 | 1 | 1409.38 | 47 | SO46964 | 2022-11-18 | 112.75 | 1460.12 | 469.79 |
SO67292_16 | 09EF-4688-BB | PO551144976 | 100 | 281 | 388 | 4 | 4 | 2024-07-24 | 1344.59 | 33.61 | 2024-07-12 | 2 | 713.08 | 1 | 1344.59 | 16 | SO67292 | 2024-07-19 | 107.57 | 1426.16 | 672.29 |
SO50739_1 | 7F49-4009-8C | PO3886138724 | 100 | 281 | 329 | 165 | 4 | 2023-09-23 | 469.79 | 11.74 | 2023-09-11 | 1 | 486.71 | 1 | 469.79 | 1 | SO50739 | 2023-09-18 | 37.58 | 486.71 | 469.79 |
SO55265_12 | D45F-41FE-9B | PO10237157039 | 100 | 287 | 491 | 41 | 4 | 2024-01-23 | 194.36 | 4.86 | 2024-01-11 | 6 | 41.57 | 1 | 194.36 | 12 | SO55265 | 2024-01-18 | 15.55 | 249.43 | 32.39 |
SO45799_25 | 4DE8-4B9B-A1 | PO10730195041 | 100 | 287 | 270 | 491 | 4 | 2022-07-24 | 367.88 | 9.20 | 2022-07-12 | 2 | 181.49 | 1 | 367.88 | 25 | SO45799 | 2022-07-19 | 29.43 | 362.97 | 183.94 |
SO50738_25 | 531C-4E52-80 | PO3915159731 | 100 | 281 | 224 | 130 | 4 | 2023-09-23 | 41.49 | 1.04 | 2023-09-11 | 8 | 5.23 | 1 | 41.49 | 25 | SO50738 | 2023-09-18 | 3.32 | 41.84 | 5.19 |
SO46357_1 | EC98-4DEF-A4 | PO667186827 | 100 | 287 | 326 | 365 | 4 | 2022-09-23 | 419.46 | 10.49 | 2022-09-11 | 1 | 413.15 | 1 | 419.46 | 1 | SO46357 | 2022-09-18 | 33.56 | 413.15 | 419.46 |
SO51121_28 | 9E4C-40B6-B1 | PO10730114575 | 100 | 287 | 605 | 491 | 4 | 2023-10-23 | 1619.97 | 40.50 | 2023-10-11 | 5 | 343.65 | 1 | 1619.97 | 28 | SO51121 | 2023-10-18 | 129.60 | 1718.25 | 323.99 |
SO51714_45 | D33A-4EAE-B1 | PO15689195197 | 100 | 281 | 440 | 328 | 4 | 2023-11-23 | 3435.60 | 85.89 | 2023-11-11 | 4 | 868.63 | 1 | 3435.60 | 45 | SO51714 | 2023-11-18 | 274.85 | 3474.54 | 858.90 |
SO47045_8 | 9DDC-4176-90 | PO6438144434 | 100 | 283 | 399 | 309 | 4 | 2022-11-23 | 135.10 | 3.38 | 2022-11-11 | 4 | 24.99 | 1 | 135.10 | 8 | SO47045 | 2022-11-18 | 10.81 | 99.97 | 33.77 |
SO44120_12 | E001-437D-A1 | PO5597155510 | 100 | 283 | 223 | 75 | 4 | 2021-12-24 | 15.56 | 0.39 | 2021-12-12 | 3 | 5.71 | 1 | 15.56 | 12 | SO44120 | 2021-12-19 | 1.24 | 17.12 | 5.19 |
SO57138_5 | CD80-4144-8A | PO5684168325 | 100 | 282 | 543 | 385 | 4 | 2024-02-23 | 111.76 | 2.79 | 2024-02-11 | 3 | 27.57 | 1 | 111.76 | 5 | SO57138 | 2024-02-18 | 8.94 | 82.70 | 37.25 |
SO51773_28 | 14B1-48BF-A0 | PO2523163173 | 100 | 287 | 386 | 167 | 4 | 2023-11-23 | 1344.59 | 33.61 | 2023-11-11 | 2 | 713.08 | 1 | 1344.59 | 28 | SO51773 | 2023-11-18 | 107.57 | 1426.16 | 672.29 |
Generated 2024-11-10 05:41:13.424 UTC