[ROOT] dt FactResellerSale < WHERE DimSalesTerritoryId EQ '6' > SHUFFLE < SKIP 876 > < TAKE 60 >
60 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 |
---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
SO45310_2 | E43D-4178-B9 | PO10469159835 | 19 | 288 | 350 | 335 | 6 | 2022-04-04 | 2024.99 | 50.62 | 2022-03-23 | 1 | 1898.09 | 1 | 2024.99 | 2 | SO45310 | 2022-03-30 | 162.00 | 1898.09 | 2024.99 | |||
SO65173_16 | 5315-45D4-AA | PO17545119578 | 19 | 291 | 380 | 155 | 6 | 2024-05-02 | 7330.05 | 183.25 | 2024-04-20 | 5 | 1554.95 | 1 | 7330.05 | 16 | SO65173 | 2024-04-27 | 586.40 | 7774.74 | 1466.01 | |||
SO46608_28 | ACF1-4852-B7 | PO18473177913 | 19 | 291 | 394 | 442 | 6 | 2022-09-01 | 20.52 | 0.51 | 2022-08-20 | 1 | 15.18 | 1 | 20.52 | 28 | SO46608 | 2022-08-27 | 1.64 | 15.18 | 20.52 | |||
SO44085_16 | D35C-4208-A3 | PO17545192039 | 19 | 288 | 220 | 155 | 6 | 2021-11-02 | 80.75 | 2.02 | 2021-10-21 | 4 | 12.03 | 1 | 80.75 | 16 | SO44085 | 2021-10-28 | 6.46 | 48.11 | 20.19 | |||
SO47663_4 | 1B17-4C63-B6 | PO18444192283 | 19 | 291 | 273 | 227 | 6 | 2022-12-02 | 202.33 | 5.06 | 2022-11-20 | 1 | 187.16 | 1 | 202.33 | 4 | SO47663 | 2022-11-27 | 16.19 | 187.16 | 202.33 | |||
SO51839_32 | 411D-4ACA-8E | PO4901195797 | 19 | 284 | 386 | 84 | 6 | 2023-10-02 | 2016.88 | 50.42 | 2023-09-20 | 3 | 713.08 | 1 | 2016.88 | 32 | SO51839 | 2023-09-27 | 161.35 | 2139.24 | 672.29 | |||
SO45057_3 | 568E-472E-9C | PO11049133413 | 19 | 284 | 342 | 679 | 6 | 2022-03-04 | 419.46 | 10.49 | 2022-02-20 | 1 | 413.15 | 1 | 419.46 | 3 | SO45057 | 2022-02-27 | 33.56 | 413.15 | 419.46 | |||
SO48350_15 | 1505-4FEA-92 | PO1798152196 | 19 | 291 | 420 | 10 | 6 | 2023-02-01 | 424.85 | 10.62 | 2023-01-20 | 3 | 104.80 | 1 | 424.85 | 15 | SO48350 | 2023-01-27 | 33.99 | 314.39 | 141.62 | |||
SO49513_4 | 1A8D-4D25-AE | PO10962181499 | 19 | 284 | 352 | 685 | 6 | 2023-05-02 | 2485.70 | 62.14 | 2023-04-20 | 2 | 1117.86 | 1 | 2485.70 | 4 | SO49513 | 2023-04-27 | 198.86 | 2235.71 | 1242.85 | |||
SO63174_18 | 0B72-4270-AC | PO1827182060 | 19 | 291 | 546 | 317 | 6 | 2024-04-03 | 74.51 | 1.86 | 2024-03-22 | 2 | 27.57 | 1 | 74.51 | 18 | SO63174 | 2024-03-29 | 5.96 | 55.14 | 37.25 | |||
SO45315_6 | A83F-4F76-BA | PO2146148184 | 19 | 284 | 350 | 354 | 6 | 2022-04-04 | 8099.98 | 202.50 | 2022-03-23 | 4 | 1898.09 | 1 | 8099.98 | 6 | SO45315 | 2022-03-30 | 648.00 | 7592.38 | 2024.99 | |||
SO55275_35 | 72C3-4048-BC | PO1711122362 | 19 | 291 | 359 | 245 | 6 | 2023-12-02 | 9638.96 | 240.97 | 2023-11-20 | 7 | 1251.98 | 1 | 9638.96 | 35 | SO55275 | 2023-11-27 | 771.12 | 8763.87 | 1376.99 | |||
SO44750_6 | B71E-4BBF-B5 | PO17574147002 | 19 | 288 | 349 | 678 | 6 | 2022-02-01 | 16199.95 | 405.00 | 2022-01-20 | 8 | 1898.09 | 1 | 16199.95 | 6 | SO44750 | 2022-01-27 | 1296.00 | 15184.76 | 2024.99 | |||
SO53535_36 | 8195-45C7-93 | PO18502176746 | 19 | 291 | 586 | 13 | 154 | 6 | 701.52 | 2023-11-02 | 4676.81 | 99.38 | 2023-10-21 | 14 | 461.44 | 1 | 3975.28 | 36 | SO53535 | 2023-10-28 | 318.02 | 6460.23 | 334.06 | 0.15 |
SO50265_33 | 6C30-435D-9D | PO18705169014 | 19 | 291 | 369 | 479 | 6 | 2023-07-02 | 4398.03 | 109.95 | 2023-06-20 | 3 | 1518.79 | 1 | 4398.03 | 33 | SO50265 | 2023-06-27 | 351.84 | 4556.36 | 1466.01 | |||
SO48754_12 | FC6A-4A9E-83 | PO18473150383 | 19 | 291 | 459 | 442 | 6 | 2023-03-04 | 161.98 | 4.05 | 2023-02-20 | 3 | 37.12 | 1 | 161.98 | 12 | SO48754 | 2023-02-27 | 12.96 | 111.36 | 53.99 | |||
SO45047_14 | B1C5-444F-BF | PO14732155479 | 19 | 288 | 332 | 514 | 6 | 2022-03-04 | 3355.67 | 83.89 | 2022-02-20 | 8 | 413.15 | 1 | 3355.67 | 14 | SO45047 | 2022-02-27 | 268.45 | 3305.17 | 419.46 | |||
SO44533_4 | 6A24-4735-B2 | PO1827111566 | 19 | 288 | 253 | 317 | 6 | 2022-01-02 | 178.58 | 4.46 | 2021-12-21 | 1 | 176.20 | 1 | 178.58 | 4 | SO44533 | 2021-12-28 | 14.29 | 176.20 | 178.58 | |||
SO71828_11 | 73A0-490C-B1 | PO11194153355 | 19 | 284 | 569 | 48 | 6 | 2024-08-02 | 1781.64 | 44.54 | 2024-07-21 | 4 | 461.44 | 1 | 1781.64 | 11 | SO71828 | 2024-07-28 | 142.53 | 1845.78 | 445.41 | |||
SO53544_1 | 6A46-4037-85 | PO17516134934 | 19 | 291 | 483 | 630 | 6 | 2023-11-02 | 144.00 | 3.60 | 2023-10-21 | 2 | 44.88 | 1 | 144.00 | 1 | SO53544 | 2023-10-28 | 11.52 | 89.76 | 72.00 | |||
SO51704_28 | 13FA-4729-A9 | PO17661178081 | 19 | 284 | 491 | 264 | 6 | 2023-10-02 | 323.94 | 8.10 | 2023-09-20 | 10 | 41.57 | 1 | 323.94 | 28 | SO51704 | 2023-09-27 | 25.92 | 415.72 | 32.39 | |||
SO53464_10 | E113-419B-8F | PO17545119283 | 19 | 291 | 584 | 155 | 6 | 2023-11-02 | 1295.98 | 32.40 | 2023-10-21 | 4 | 343.65 | 1 | 1295.98 | 10 | SO53464 | 2023-10-28 | 103.68 | 1374.60 | 323.99 | |||
SO50232_7 | 3919-46D4-A1 | PO11020171211 | 19 | 284 | 454 | 336 | 6 | 2023-07-02 | 107.98 | 2.70 | 2023-06-20 | 3 | 24.75 | 1 | 107.98 | 7 | SO50232 | 2023-06-27 | 8.64 | 74.24 | 35.99 | |||
SO53465_51 | D859-4DF3-84 | PO17574192592 | 19 | 272 | 234 | 2 | 678 | 6 | 6.96 | 2023-11-02 | 347.93 | 8.52 | 2023-10-21 | 12 | 38.49 | 1 | 340.97 | 51 | SO53465 | 2023-10-28 | 27.28 | 461.91 | 28.99 | 0.02 |
SO43668_4 | 365D-4C9A-BE | PO14732180295 | 19 | 288 | 332 | 514 | 6 | 2021-09-01 | 2516.75 | 62.92 | 2021-08-20 | 6 | 413.15 | 1 | 2516.75 | 4 | SO43668 | 2021-08-27 | 201.34 | 2478.88 | 419.46 | |||
SO51160_62 | 3F3F-4135-B0 | PO4495157262 | 19 | 291 | 558 | 2 | 496 | 6 | 65.77 | 2023-09-01 | 3288.52 | 80.57 | 2023-08-20 | 14 | 179.82 | 1 | 3222.75 | 62 | SO51160 | 2023-08-27 | 257.82 | 2517.42 | 234.89 | 0.02 |
SO44081_6 | 32E7-4EA4-9F | PO18299115585 | 19 | 288 | 235 | 118 | 6 | 2021-11-02 | 28.84 | 0.72 | 2021-10-21 | 1 | 31.72 | 1 | 28.84 | 6 | SO44081 | 2021-10-28 | 2.31 | 31.72 | 28.84 | |||
SO63154_1 | 6418-416B-96 | PO14848162038 | 19 | 291 | 376 | 478 | 6 | 2024-04-03 | 1466.01 | 36.65 | 2024-03-22 | 1 | 1554.95 | 1 | 1466.01 | 1 | SO63154 | 2024-03-29 | 117.28 | 1554.95 | 1466.01 | |||
SO51699_7 | 31D5-494C-BA | PO18879118606 | 19 | 291 | 564 | 14 | 64 | 6 | 190.73 | 2023-10-02 | 953.63 | 19.07 | 2023-09-20 | 1 | 1481.94 | 1 | 762.90 | 7 | SO51699 | 2023-09-27 | 61.03 | 1481.94 | 953.63 | 0.20 |
SO51793_25 | D763-4929-9B | PO18705168707 | 19 | 291 | 463 | 479 | 6 | 2023-10-02 | 102.86 | 2.57 | 2023-09-20 | 7 | 9.16 | 1 | 102.86 | 25 | SO51793 | 2023-09-27 | 8.23 | 64.12 | 14.69 | |||
SO69540_33 | 75AA-4D8C-83 | PO1856168639 | 19 | 291 | 463 | 263 | 6 | 2024-07-02 | 73.47 | 1.84 | 2024-06-20 | 5 | 9.16 | 1 | 73.47 | 33 | SO69540 | 2024-06-27 | 5.88 | 45.80 | 14.69 | |||
SO46614_17 | 0B65-4374-89 | PO15312137226 | 19 | 291 | 445 | 299 | 6 | 2022-09-01 | 143.98 | 3.60 | 2022-08-20 | 4 | 24.75 | 1 | 143.98 | 17 | SO46614 | 2022-08-27 | 11.52 | 98.98 | 35.99 | |||
SO45800_3 | 5B67-4FE2-B9 | PO10527156525 | 19 | 284 | 326 | 480 | 6 | 2022-06-02 | 1258.38 | 31.46 | 2022-05-21 | 3 | 413.15 | 1 | 1258.38 | 3 | SO45800 | 2022-05-28 | 100.67 | 1239.44 | 419.46 | |||
SO65164_37 | 07B8-4AF8-8A | PO18299114573 | 19 | 291 | 214 | 118 | 6 | 2024-05-02 | 83.98 | 2.10 | 2024-04-20 | 4 | 13.09 | 1 | 83.98 | 37 | SO65164 | 2024-04-27 | 6.72 | 52.35 | 20.99 | |||
SO51839_21 | 411D-4ACA-8E | PO4901195797 | 19 | 284 | 390 | 84 | 6 | 2023-10-02 | 1344.59 | 33.61 | 2023-09-20 | 2 | 713.08 | 1 | 1344.59 | 21 | SO51839 | 2023-09-27 | 107.57 | 1426.16 | 672.29 | |||
SO47012_5 | 5043-4C8B-B3 | PO1914167487 | 19 | 284 | 460 | 2 | 66 | 6 | 14.61 | 2022-10-02 | 730.72 | 17.90 | 2022-09-20 | 14 | 37.12 | 1 | 716.10 | 5 | SO47012 | 2022-09-27 | 57.29 | 519.69 | 52.19 | 0.02 |
SO69478_11 | E63C-4ABF-83 | PO18705185140 | 19 | 291 | 547 | 479 | 6 | 2024-07-02 | 97.19 | 2.43 | 2024-06-20 | 2 | 35.96 | 1 | 97.19 | 11 | SO69478 | 2024-06-27 | 7.78 | 71.92 | 48.59 | |||
SO67270_28 | 685A-440D-8C | PO14732111382 | 19 | 291 | 408 | 514 | 6 | 2024-06-02 | 144.32 | 3.61 | 2024-05-21 | 2 | 53.40 | 1 | 144.32 | 28 | SO67270 | 2024-05-28 | 11.55 | 106.80 | 72.16 | |||
SO48306_24 | EA27-471A-9D | PO17574166075 | 19 | 291 | 448 | 678 | 6 | 2023-02-01 | 35.98 | 0.90 | 2023-01-20 | 3 | 8.25 | 1 | 35.98 | 24 | SO48306 | 2023-01-27 | 2.88 | 24.74 | 11.99 | |||
SO51818_18 | B8CE-4C91-A9 | PO9077115532 | 19 | 291 | 589 | 100 | 6 | 2023-10-02 | 461.69 | 11.54 | 2023-09-20 | 1 | 419.78 | 1 | 461.69 | 18 | SO51818 | 2023-09-27 | 36.94 | 419.78 | 461.69 | |||
SO69560_18 | B1B6-43F4-BC | PO9077167302 | 19 | 291 | 597 | 100 | 6 | 2024-07-02 | 971.98 | 24.30 | 2024-06-20 | 3 | 294.58 | 1 | 971.98 | 18 | SO69560 | 2024-06-27 | 77.76 | 883.74 | 323.99 | |||
SO49848_7 | 31E6-4A3B-9C | PO1711148241 | 19 | 291 | 360 | 245 | 6 | 2023-06-02 | 1229.46 | 30.74 | 2023-05-21 | 1 | 1105.81 | 1 | 1229.46 | 7 | SO49848 | 2023-05-28 | 98.36 | 1105.81 | 1229.46 | |||
SO58972_18 | 07C8-43BD-85 | PO1798131785 | 19 | 291 | 353 | 10 | 6 | 2024-02-01 | 9743.96 | 243.60 | 2024-01-20 | 7 | 1265.62 | 1 | 9743.96 | 18 | SO58972 | 2024-01-27 | 779.52 | 8859.34 | 1391.99 | |||
SO55243_9 | 2457-46EE-88 | PO15312160912 | 19 | 291 | 490 | 3 | 299 | 6 | 22.27 | 2023-12-02 | 445.42 | 10.58 | 2023-11-20 | 15 | 41.57 | 1 | 423.15 | 9 | SO55243 | 2023-11-27 | 33.85 | 623.58 | 29.69 | 0.05 |
SO49485_11 | 9EA5-4DEF-B8 | PO17545171443 | 19 | 291 | 453 | 155 | 6 | 2023-05-02 | 107.98 | 2.70 | 2023-04-20 | 3 | 24.75 | 1 | 107.98 | 11 | SO49485 | 2023-04-27 | 8.64 | 74.24 | 35.99 | |||
SO45794_6 | 945F-4477-83 | PO12760191318 | 19 | 288 | 342 | 83 | 6 | 2022-06-02 | 1677.84 | 41.95 | 2022-05-21 | 4 | 413.15 | 1 | 1677.84 | 6 | SO45794 | 2022-05-28 | 134.23 | 1652.59 | 419.46 | |||
SO51769_16 | 4AAC-4066-A6 | PO1595126190 | 19 | 284 | 234 | 426 | 6 | 2023-10-02 | 149.97 | 3.75 | 2023-09-20 | 5 | 38.49 | 1 | 149.97 | 16 | SO51769 | 2023-09-27 | 12.00 | 192.46 | 29.99 | |||
SO51766_6 | 1118-4A2A-80 | PO638122353 | 19 | 291 | 474 | 280 | 6 | 2023-10-02 | 167.98 | 4.20 | 2023-09-20 | 4 | 26.18 | 1 | 167.98 | 6 | SO51766 | 2023-09-27 | 13.44 | 104.71 | 41.99 | |||
SO55297_4 | 2455-4B60-A5 | PO4495126679 | 19 | 291 | 543 | 496 | 6 | 2023-12-02 | 74.51 | 1.86 | 2023-11-20 | 2 | 27.57 | 1 | 74.51 | 4 | SO55297 | 2023-11-27 | 5.96 | 55.14 | 37.25 | |||
SO47411_24 | 4BDD-4511-AC | PO1798140269 | 19 | 291 | 358 | 10 | 6 | 2022-11-02 | 8606.21 | 215.16 | 2022-10-21 | 7 | 1105.81 | 1 | 8606.21 | 24 | SO47411 | 2022-10-28 | 688.50 | 7740.67 | 1229.46 | |||
SO58958_40 | BC3F-443F-B5 | PO10875118816 | 19 | 291 | 490 | 3 | 281 | 6 | 22.27 | 2024-02-01 | 445.42 | 10.58 | 2024-01-20 | 15 | 41.57 | 1 | 423.15 | 40 | SO58958 | 2024-01-27 | 33.85 | 623.58 | 29.69 | 0.05 |
SO50199_10 | 8C45-47E6-93 | PO17748185472 | 19 | 284 | 383 | 102 | 6 | 2023-07-02 | 1800.79 | 45.02 | 2023-06-20 | 3 | 605.65 | 1 | 1800.79 | 10 | SO50199 | 2023-06-27 | 144.06 | 1816.95 | 600.26 | |||
SO50192_3 | A5BA-4696-96 | PO19227162823 | 19 | 284 | 458 | 210 | 6 | 2023-07-02 | 314.96 | 7.87 | 2023-06-20 | 7 | 30.93 | 1 | 314.96 | 3 | SO50192 | 2023-06-27 | 25.20 | 216.53 | 44.99 | |||
SO50676_29 | 66F1-4A9A-97 | PO14790188963 | 19 | 291 | 367 | 497 | 6 | 2023-08-02 | 4535.96 | 113.40 | 2023-07-21 | 7 | 598.44 | 1 | 4535.96 | 29 | SO50676 | 2023-07-28 | 362.88 | 4189.05 | 647.99 | |||
SO71806_22 | 26A7-4E95-9B | PO14790111844 | 19 | 291 | 517 | 497 | 6 | 2024-08-02 | 31.58 | 0.79 | 2024-07-21 | 1 | 23.37 | 1 | 31.58 | 22 | SO71806 | 2024-07-28 | 2.53 | 23.37 | 31.58 | |||
SO71806_5 | 26A7-4E95-9B | PO14790111844 | 19 | 291 | 597 | 497 | 6 | 2024-08-02 | 323.99 | 8.10 | 2024-07-21 | 1 | 294.58 | 1 | 323.99 | 5 | SO71806 | 2024-07-28 | 25.92 | 294.58 | 323.99 | |||
SO53483_26 | A0BE-40E0-81 | PO14761137153 | 19 | 284 | 577 | 408 | 6 | 2023-11-02 | 728.91 | 18.22 | 2023-10-21 | 1 | 755.15 | 1 | 728.91 | 26 | SO53483 | 2023-10-28 | 58.31 | 755.15 | 728.91 | |||
SO44298_20 | 960B-4C26-9F | PO11049118093 | 19 | 284 | 272 | 679 | 6 | 2021-12-02 | 183.94 | 4.60 | 2021-11-20 | 1 | 181.49 | 1 | 183.94 | 20 | SO44298 | 2021-11-27 | 14.72 | 181.49 | 183.94 | |||
SO51160_6 | 3F3F-4135-B0 | PO4495157262 | 19 | 291 | 591 | 496 | 6 | 2023-09-01 | 677.99 | 16.95 | 2023-08-20 | 2 | 308.22 | 1 | 677.99 | 6 | SO51160 | 2023-08-27 | 54.24 | 616.44 | 338.99 | |||
SO58918_32 | C811-4D40-80 | PO17574131484 | 19 | 291 | 298 | 678 | 6 | 2024-02-01 | 1619.52 | 40.49 | 2024-01-20 | 2 | 739.04 | 1 | 1619.52 | 32 | SO58918 | 2024-01-27 | 129.56 | 1478.08 | 809.76 |
Generated 2024-09-20 02:56:29.174 UTC