[ROOT] dt FactResellerSale < WHERE DimSalesTerritoryId EQ '6' > SHUFFLE < SKIP 2182 > < TAKE 48 >
48 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 |
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
| SO65188_4 | 86B3-49B3-A1 | PO14790112162 | 19 | 291 | 544 | 497 | 6 | 2024-06-23 | 48.59 | 1.21 | 2024-06-11 | 1 | 35.96 | 1 | 48.59 | 4 | SO65188 | 2024-06-18 | 3.89 | 35.96 | 48.59 | |||
| SO71830_5 | DA2D-4B00-A4 | PO10875112195 | 19 | 291 | 499 | 281 | 6 | 2024-09-23 | 1204.69 | 30.12 | 2024-09-11 | 2 | 601.74 | 1 | 1204.69 | 5 | SO71830 | 2024-09-18 | 96.38 | 1203.49 | 602.35 | |||
| SO50676_7 | 66F1-4A9A-97 | PO14790188963 | 19 | 291 | 410 | 497 | 6 | 2023-09-23 | 182.24 | 4.56 | 2023-09-11 | 5 | 26.97 | 1 | 182.24 | 7 | SO50676 | 2023-09-18 | 14.58 | 134.85 | 36.45 | |||
| SO69398_4 | 29DF-4EAC-8D | PO17632193764 | 19 | 291 | 585 | 28 | 6 | 2024-08-23 | 445.41 | 11.14 | 2024-08-11 | 1 | 461.44 | 1 | 445.41 | 4 | SO69398 | 2024-08-18 | 35.63 | 461.44 | 445.41 | |||
| SO50689_22 | 20BC-4161-86 | PO10614135588 | 19 | 291 | 224 | 461 | 6 | 2023-09-23 | 15.56 | 0.39 | 2023-09-11 | 3 | 5.23 | 1 | 15.56 | 22 | SO50689 | 2023-09-18 | 1.24 | 15.69 | 5.19 | |||
| SO65290_4 | 0B33-4556-B6 | PO1972142380 | 19 | 291 | 295 | 190 | 6 | 2024-06-23 | 818.70 | 20.47 | 2024-06-11 | 1 | 747.20 | 1 | 818.70 | 4 | SO65290 | 2024-06-18 | 65.50 | 747.20 | 818.70 | |||
| SO57016_3 | 5FA2-418F-AF | PO19227187256 | 19 | 284 | 545 | 210 | 6 | 2024-02-23 | 24.29 | 0.61 | 2024-02-11 | 1 | 17.98 | 1 | 24.29 | 3 | SO57016 | 2024-02-18 | 1.94 | 17.98 | 24.29 | |||
| SO65240_1 | 8555-4591-9E | PO14877131396 | 19 | 291 | 512 | 172 | 6 | 2024-06-23 | 218.45 | 5.46 | 2024-06-11 | 1 | 199.38 | 1 | 218.45 | 1 | SO65240 | 2024-06-18 | 17.48 | 199.38 | 218.45 | |||
| SO63128_15 | 9486-41CD-91 | PO18879146432 | 19 | 291 | 585 | 64 | 6 | 2024-05-25 | 890.82 | 22.27 | 2024-05-13 | 2 | 461.44 | 1 | 890.82 | 15 | SO63128 | 2024-05-20 | 71.27 | 922.89 | 445.41 | |||
| SO47380_34 | EF71-4036-91 | PO14790123967 | 19 | 291 | 397 | 497 | 6 | 2022-12-24 | 48.59 | 1.21 | 2022-12-12 | 2 | 17.98 | 1 | 48.59 | 34 | SO47380 | 2022-12-19 | 3.89 | 35.96 | 24.29 | |||
| SO67295_20 | D785-46A0-BC | PO1711155302 | 19 | 291 | 511 | 245 | 6 | 2024-07-24 | 1966.09 | 49.15 | 2024-07-12 | 9 | 199.38 | 1 | 1966.09 | 20 | SO67295 | 2024-07-19 | 157.29 | 1794.38 | 218.45 | |||
| SO45057_14 | 568E-472E-9C | PO11049133413 | 19 | 284 | 338 | 679 | 6 | 2022-04-25 | 419.46 | 10.49 | 2022-04-13 | 1 | 413.15 | 1 | 419.46 | 14 | SO45057 | 2022-04-20 | 33.56 | 413.15 | 419.46 | |||
| SO46326_14 | EDD8-4703-B2 | PO19401160698 | 19 | 288 | 220 | 173 | 6 | 2022-09-23 | 40.37 | 1.01 | 2022-09-11 | 2 | 12.03 | 1 | 40.37 | 14 | SO46326 | 2022-09-18 | 3.23 | 24.06 | 20.19 | |||
| SO67295_21 | D785-46A0-BC | PO1711155302 | 19 | 291 | 559 | 245 | 6 | 2024-07-24 | 60.72 | 1.52 | 2024-07-12 | 5 | 8.99 | 1 | 60.72 | 21 | SO67295 | 2024-07-19 | 4.86 | 44.93 | 12.14 | |||
| SO67270_8 | 685A-440D-8C | PO14732111382 | 19 | 291 | 231 | 514 | 6 | 2024-07-24 | 29.99 | 0.75 | 2024-07-12 | 1 | 38.49 | 1 | 29.99 | 8 | SO67270 | 2024-07-19 | 2.40 | 38.49 | 29.99 | |||
| SO69522_28 | 28C3-4615-8B | PO4901187436 | 19 | 284 | 472 | 2 | 84 | 6 | 10.31 | 2024-08-23 | 515.62 | 12.63 | 2024-08-11 | 14 | 23.75 | 1 | 505.31 | 28 | SO69522 | 2024-08-18 | 40.42 | 332.49 | 36.83 | 0.02 |
| SO57097_17 | 9A9E-444B-B1 | PO18328123706 | 19 | 284 | 231 | 552 | 6 | 2024-02-23 | 239.95 | 6.00 | 2024-02-11 | 8 | 38.49 | 1 | 239.95 | 17 | SO57097 | 2024-02-18 | 19.20 | 307.94 | 29.99 | |||
| SO51160_60 | 3F3F-4135-B0 | PO4495157262 | 19 | 291 | 222 | 11 | 496 | 6 | 4.72 | 2023-10-23 | 31.49 | 0.67 | 2023-10-11 | 2 | 13.09 | 1 | 26.77 | 60 | SO51160 | 2023-10-18 | 2.14 | 26.17 | 15.75 | 0.15 |
| SO47988_37 | 3979-4615-A9 | PO16733190266 | 19 | 291 | 448 | 533 | 6 | 2023-02-23 | 95.95 | 2.40 | 2023-02-11 | 8 | 8.25 | 1 | 95.95 | 37 | SO47988 | 2023-02-18 | 7.68 | 65.97 | 11.99 | |||
| SO47696_2 | B251-4D0B-9C | PO1711162591 | 19 | 291 | 354 | 245 | 6 | 2023-01-23 | 9942.81 | 248.57 | 2023-01-11 | 8 | 1117.86 | 1 | 9942.81 | 2 | SO47696 | 2023-01-18 | 795.43 | 8942.85 | 1242.85 | |||
| SO55275_3 | 72C3-4048-BC | PO1711122362 | 19 | 291 | 511 | 2 | 245 | 6 | 50.68 | 2024-01-23 | 2534.07 | 62.08 | 2024-01-11 | 12 | 199.38 | 1 | 2483.39 | 3 | SO55275 | 2024-01-18 | 198.67 | 2392.51 | 211.17 | 0.02 |
| SO65206_29 | 6CD1-4BEC-A0 | PO1798192797 | 19 | 291 | 474 | 10 | 6 | 2024-06-23 | 167.98 | 4.20 | 2024-06-11 | 4 | 26.18 | 1 | 167.98 | 29 | SO65206 | 2024-06-18 | 13.44 | 104.71 | 41.99 | |||
| SO69540_3 | 75AA-4D8C-83 | PO1856168639 | 19 | 291 | 570 | 263 | 6 | 2024-08-23 | 1336.23 | 33.41 | 2024-08-11 | 3 | 461.44 | 1 | 1336.23 | 3 | SO69540 | 2024-08-18 | 106.90 | 1384.33 | 445.41 | |||
| SO67268_14 | 9708-4E22-A4 | PO15312122688 | 19 | 291 | 231 | 299 | 6 | 2024-07-24 | 269.95 | 6.75 | 2024-07-12 | 9 | 38.49 | 1 | 269.95 | 14 | SO67268 | 2024-07-19 | 21.60 | 346.43 | 29.99 | |||
| SO45797_12 | B3FE-4436-96 | PO11049120115 | 19 | 284 | 320 | 679 | 6 | 2022-07-24 | 419.46 | 10.49 | 2022-07-12 | 1 | 413.15 | 1 | 419.46 | 12 | SO45797 | 2022-07-19 | 33.56 | 413.15 | 419.46 | |||
| SO49848_20 | 31E6-4A3B-9C | PO1711148241 | 19 | 291 | 297 | 245 | 6 | 2023-07-24 | 2944.58 | 73.61 | 2023-07-12 | 4 | 653.70 | 1 | 2944.58 | 20 | SO49848 | 2023-07-19 | 235.57 | 2614.79 | 736.15 | |||
| SO63174_10 | 0B72-4270-AC | PO1827182060 | 19 | 291 | 374 | 317 | 6 | 2024-05-25 | 1466.01 | 36.65 | 2024-05-13 | 1 | 1554.95 | 1 | 1466.01 | 10 | SO63174 | 2024-05-20 | 117.28 | 1554.95 | 1466.01 | |||
| SO47668_48 | 7CB5-4904-AD | PO15312152020 | 19 | 291 | 233 | 299 | 6 | 2023-01-23 | 288.40 | 7.21 | 2023-01-11 | 10 | 29.08 | 1 | 288.40 | 48 | SO47668 | 2023-01-18 | 23.07 | 290.81 | 28.84 | |||
| SO49484_33 | B25F-4DF4-8E | PO18299142683 | 19 | 291 | 365 | 118 | 6 | 2023-06-23 | 1943.98 | 48.60 | 2023-06-11 | 3 | 598.44 | 1 | 1943.98 | 33 | SO49484 | 2023-06-18 | 155.52 | 1795.31 | 647.99 | |||
| SO43857_3 | 0CD4-4091-9B | PO16733124458 | 19 | 288 | 326 | 533 | 6 | 2021-11-23 | 838.92 | 20.97 | 2021-11-11 | 2 | 413.15 | 1 | 838.92 | 3 | SO43857 | 2021-11-18 | 67.11 | 826.29 | 419.46 | |||
| SO44288_7 | 6F5C-4E3C-B5 | PO14732190246 | 19 | 288 | 336 | 514 | 6 | 2022-01-23 | 419.46 | 10.49 | 2022-01-11 | 1 | 413.15 | 1 | 419.46 | 7 | SO44288 | 2022-01-18 | 33.56 | 413.15 | 419.46 | |||
| SO48307_17 | 7DE5-4D74-A7 | PO17545123793 | 19 | 291 | 368 | 155 | 6 | 2023-03-25 | 2932.02 | 73.30 | 2023-03-13 | 2 | 1518.79 | 1 | 2932.02 | 17 | SO48307 | 2023-03-20 | 234.56 | 3037.57 | 1466.01 | |||
| SO49513_13 | 1A8D-4D25-AE | PO10962181499 | 19 | 284 | 356 | 685 | 6 | 2023-06-23 | 7457.11 | 186.43 | 2023-06-11 | 6 | 1117.86 | 1 | 7457.11 | 13 | SO49513 | 2023-06-18 | 596.57 | 6707.14 | 1242.85 | |||
| SO46351_1 | 9218-4521-8F | PO11107115959 | 19 | 284 | 315 | 156 | 6 | 2022-09-23 | 874.79 | 21.87 | 2022-09-11 | 1 | 884.71 | 1 | 874.79 | 1 | SO46351 | 2022-09-18 | 69.98 | 884.71 | 874.79 | |||
| SO55275_24 | 72C3-4048-BC | PO1711122362 | 19 | 291 | 532 | 245 | 6 | 2024-01-23 | 599.50 | 14.99 | 2024-01-11 | 4 | 136.79 | 1 | 599.50 | 24 | SO55275 | 2024-01-18 | 47.96 | 547.14 | 149.87 | |||
| SO71830_4 | DA2D-4B00-A4 | PO10875112195 | 19 | 291 | 491 | 3 | 281 | 6 | 25.24 | 2024-09-23 | 504.81 | 11.99 | 2024-09-11 | 17 | 41.57 | 1 | 479.57 | 4 | SO71830 | 2024-09-18 | 38.37 | 706.73 | 29.69 | 0.05 |
| SO50699_4 | FEA0-4613-AE | PO1885169186 | 19 | 284 | 365 | 588 | 6 | 2023-09-23 | 647.99 | 16.20 | 2023-09-11 | 1 | 598.44 | 1 | 647.99 | 4 | SO50699 | 2023-09-18 | 51.84 | 598.44 | 647.99 | |||
| SO47031_25 | 3FA6-4120-BD | PO4466161844 | 19 | 291 | 297 | 352 | 6 | 2022-11-23 | 736.15 | 18.40 | 2022-11-11 | 1 | 653.70 | 1 | 736.15 | 25 | SO47031 | 2022-11-18 | 58.89 | 653.70 | 736.15 | |||
| SO53508_15 | 38E7-428D-9B | PO11194139565 | 19 | 284 | 498 | 48 | 6 | 2023-12-24 | 602.35 | 15.06 | 2023-12-12 | 1 | 601.74 | 1 | 602.35 | 15 | SO53508 | 2023-12-19 | 48.19 | 601.74 | 602.35 | |||
| SO47708_8 | 86B1-46A5-95 | PO4495147689 | 19 | 291 | 420 | 496 | 6 | 2023-01-23 | 849.69 | 21.24 | 2023-01-11 | 6 | 104.80 | 1 | 849.69 | 8 | SO47708 | 2023-01-18 | 67.98 | 628.77 | 141.62 | |||
| SO47354_50 | 6E1C-48C6-89 | PO19401144959 | 19 | 291 | 368 | 173 | 6 | 2022-12-24 | 1466.01 | 36.65 | 2022-12-12 | 1 | 1518.79 | 1 | 1466.01 | 50 | SO47354 | 2022-12-19 | 117.28 | 1518.79 | 1466.01 | |||
| SO49501_6 | EF67-4713-BD | PO17574111786 | 19 | 291 | 367 | 678 | 6 | 2023-06-23 | 647.99 | 16.20 | 2023-06-11 | 1 | 598.44 | 1 | 647.99 | 6 | SO49501 | 2023-06-18 | 51.84 | 598.44 | 647.99 | |||
| SO48304_1 | C44F-4632-AD | PO17690111423 | 19 | 291 | 358 | 47 | 6 | 2023-03-25 | 3688.38 | 92.21 | 2023-03-13 | 3 | 1105.81 | 1 | 3688.38 | 1 | SO48304 | 2023-03-20 | 295.07 | 3317.43 | 1229.46 | |||
| SO61196_6 | 8DD6-4DC9-A5 | PO1711193720 | 19 | 291 | 476 | 245 | 6 | 2024-04-24 | 335.95 | 8.40 | 2024-04-12 | 8 | 26.18 | 1 | 335.95 | 6 | SO61196 | 2024-04-19 | 26.88 | 209.41 | 41.99 | |||
| SO47670_50 | 0CD2-463E-8F | PO14732184884 | 19 | 291 | 433 | 514 | 6 | 2023-01-23 | 648.91 | 16.22 | 2023-01-11 | 2 | 300.12 | 1 | 648.91 | 50 | SO47670 | 2023-01-18 | 51.91 | 600.24 | 324.45 | |||
| SO51781_8 | 63E7-4ABF-A9 | PO20039116715 | 19 | 291 | 490 | 65 | 6 | 2023-11-23 | 226.76 | 5.67 | 2023-11-11 | 7 | 41.57 | 1 | 226.76 | 8 | SO51781 | 2023-11-18 | 18.14 | 291.01 | 32.39 | |||
| SO50687_13 | DF8C-416B-BA | PO10962187340 | 19 | 284 | 470 | 685 | 6 | 2023-09-23 | 159.56 | 3.99 | 2023-09-11 | 7 | 15.67 | 1 | 159.56 | 13 | SO50687 | 2023-09-18 | 12.76 | 109.70 | 22.79 | |||
| SO51704_3 | 13FA-4729-A9 | PO17661178081 | 19 | 284 | 514 | 264 | 6 | 2023-11-23 | 127.80 | 3.20 | 2023-11-11 | 2 | 47.29 | 1 | 127.80 | 3 | SO51704 | 2023-11-18 | 10.22 | 94.57 | 63.90 |
Generated 2024-11-11 00:13:01.205 UTC