[ROOT] dt FactResellerSale < WHERE DimSalesTerritoryId EQ '6' > SHUFFLE < SKIP 7195 > < 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 |
---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
SO69522_2 | 28C3-4615-8B | PO4901187436 | 19 | 284 | 467 | 84 | 6 | 2024-07-04 | 73.47 | 1.84 | 2024-06-22 | 5 | 9.16 | 1 | 73.47 | 2 | SO69522 | 2024-06-29 | 5.88 | 45.80 | 14.69 | |||
SO47967_22 | DA42-41A7-BD | PO19198173391 | 19 | 291 | 470 | 653 | 6 | 2023-01-04 | 113.97 | 2.85 | 2022-12-23 | 5 | 15.67 | 1 | 113.97 | 22 | SO47967 | 2022-12-30 | 9.12 | 78.35 | 22.79 | |||
SO58918_63 | C811-4D40-80 | PO17574131484 | 19 | 291 | 475 | 678 | 6 | 2024-02-03 | 41.99 | 1.05 | 2024-01-22 | 1 | 26.18 | 1 | 41.99 | 63 | SO58918 | 2024-01-29 | 3.36 | 26.18 | 41.99 | |||
SO47988_13 | 3979-4615-A9 | PO16733190266 | 19 | 291 | 271 | 533 | 6 | 2023-01-04 | 809.33 | 20.23 | 2022-12-23 | 4 | 187.16 | 1 | 809.33 | 13 | SO47988 | 2022-12-30 | 64.75 | 748.63 | 202.33 | |||
SO67270_20 | 685A-440D-8C | PO14732111382 | 19 | 291 | 436 | 514 | 6 | 2024-06-04 | 1427.59 | 35.69 | 2024-05-23 | 4 | 360.94 | 1 | 1427.59 | 20 | SO67270 | 2024-05-30 | 114.21 | 1443.77 | 356.90 | |||
SO49848_11 | 31E6-4A3B-9C | PO1711148241 | 19 | 291 | 362 | 245 | 6 | 2023-06-04 | 3688.38 | 92.21 | 2023-05-23 | 3 | 1105.81 | 1 | 3688.38 | 11 | SO49848 | 2023-05-30 | 295.07 | 3317.43 | 1229.46 | |||
SO46024_2 | BE5C-4FA6-9B | PO19691162154 | 19 | 288 | 350 | 353 | 6 | 2022-07-04 | 4049.99 | 101.25 | 2022-06-22 | 2 | 1898.09 | 1 | 4049.99 | 2 | SO46024 | 2022-06-29 | 324.00 | 3796.19 | 2024.99 | |||
SO55245_27 | B5AD-476D-B4 | PO14732112185 | 19 | 291 | 374 | 514 | 6 | 2023-12-04 | 8796.06 | 219.90 | 2023-11-22 | 6 | 1554.95 | 1 | 8796.06 | 27 | SO55245 | 2023-11-29 | 703.68 | 9329.69 | 1466.01 | |||
SO46333_28 | B042-408B-A8 | PO17545158984 | 19 | 288 | 342 | 155 | 6 | 2022-08-04 | 838.92 | 20.97 | 2022-07-23 | 2 | 413.15 | 1 | 838.92 | 28 | SO46333 | 2022-07-30 | 67.11 | 826.29 | 419.46 | |||
SO44288_15 | 6F5C-4E3C-B5 | PO14732190246 | 19 | 288 | 285 | 514 | 6 | 2021-12-04 | 535.74 | 13.39 | 2021-11-22 | 3 | 176.20 | 1 | 535.74 | 15 | SO44288 | 2021-11-29 | 42.86 | 528.60 | 178.58 | |||
SO46622_1 | 1009-4D99-85 | PO13862155069 | 19 | 291 | 412 | 119 | 6 | 2022-09-03 | 180.13 | 4.50 | 2022-08-22 | 1 | 133.30 | 1 | 180.13 | 1 | SO46622 | 2022-08-29 | 14.41 | 133.30 | 180.13 | |||
SO47365_55 | 4535-457B-B0 | PO17574153673 | 19 | 291 | 224 | 3 | 678 | 6 | 3.80 | 2022-11-04 | 76.07 | 1.81 | 2022-10-23 | 16 | 5.23 | 1 | 72.27 | 55 | SO47365 | 2022-10-30 | 5.78 | 83.68 | 4.75 | 0.05 |
SO69460_15 | D5C8-450E-9F | PO1595193276 | 19 | 284 | 580 | 426 | 6 | 2024-07-04 | 1020.59 | 25.51 | 2024-06-22 | 1 | 1082.51 | 1 | 1020.59 | 15 | SO69460 | 2024-06-29 | 81.65 | 1082.51 | 1020.59 | |||
SO49860_3 | DB5C-4441-BE | PO13862128354 | 19 | 291 | 399 | 119 | 6 | 2023-06-04 | 101.32 | 2.53 | 2023-05-23 | 3 | 24.99 | 1 | 101.32 | 3 | SO49860 | 2023-05-30 | 8.11 | 74.98 | 33.77 | |||
SO57120_12 | 058D-436F-BF | PO4466170177 | 19 | 291 | 593 | 352 | 6 | 2024-01-04 | 1016.98 | 25.42 | 2023-12-23 | 3 | 308.22 | 1 | 1016.98 | 12 | SO57120 | 2023-12-30 | 81.36 | 924.65 | 338.99 | |||
SO47398_11 | 283C-414B-A2 | PO10614138214 | 19 | 291 | 230 | 461 | 6 | 2022-11-04 | 144.20 | 3.61 | 2022-10-23 | 5 | 29.08 | 1 | 144.20 | 11 | SO47398 | 2022-10-30 | 11.54 | 145.40 | 28.84 | |||
SO51850_28 | 57A9-4C32-8B | PO1856170170 | 19 | 291 | 487 | 263 | 6 | 2023-10-04 | 263.95 | 6.60 | 2023-09-22 | 8 | 20.57 | 1 | 263.95 | 28 | SO51850 | 2023-09-29 | 21.12 | 164.53 | 32.99 | |||
SO45522_2 | DB6E-40EF-A4 | PO19401195812 | 19 | 288 | 328 | 173 | 6 | 2022-05-04 | 419.46 | 10.49 | 2022-04-22 | 1 | 413.15 | 1 | 419.46 | 2 | SO45522 | 2022-04-29 | 33.56 | 413.15 | 419.46 | |||
SO71830_29 | DA2D-4B00-A4 | PO10875112195 | 19 | 291 | 503 | 281 | 6 | 2024-08-04 | 200.05 | 5.00 | 2024-07-23 | 1 | 199.85 | 1 | 200.05 | 29 | SO71830 | 2024-07-30 | 16.00 | 199.85 | 200.05 | |||
SO51839_47 | 411D-4ACA-8E | PO4901195797 | 19 | 284 | 376 | 84 | 6 | 2023-10-04 | 1466.01 | 36.65 | 2023-09-22 | 1 | 1554.95 | 1 | 1466.01 | 47 | SO51839 | 2023-09-29 | 117.28 | 1554.95 | 1466.01 | |||
SO53508_22 | 38E7-428D-9B | PO11194139565 | 19 | 284 | 570 | 13 | 48 | 6 | 50.11 | 2023-11-04 | 334.06 | 7.10 | 2023-10-23 | 1 | 461.44 | 1 | 283.95 | 22 | SO53508 | 2023-10-30 | 22.72 | 461.44 | 334.06 | 0.15 |
SO46607_21 | C1B5-40D6-8D | PO18444137892 | 19 | 291 | 286 | 227 | 6 | 2022-09-03 | 1839.38 | 45.98 | 2022-08-22 | 10 | 170.14 | 1 | 1839.38 | 21 | SO46607 | 2022-08-29 | 147.15 | 1701.43 | 183.94 | |||
SO46331_4 | 729B-498D-BD | PO17719139668 | 19 | 284 | 232 | 631 | 6 | 2022-08-04 | 57.68 | 1.44 | 2022-07-23 | 2 | 31.72 | 1 | 57.68 | 4 | SO46331 | 2022-07-30 | 4.61 | 63.45 | 28.84 | |||
SO57019_16 | D018-44A0-BF | PO18879140423 | 19 | 291 | 577 | 64 | 6 | 2024-01-04 | 2186.73 | 54.67 | 2023-12-23 | 3 | 755.15 | 1 | 2186.73 | 16 | SO57019 | 2023-12-30 | 174.94 | 2265.45 | 728.91 | |||
SO51786_14 | CB32-4179-97 | PO18357130739 | 19 | 272 | 477 | 138 | 6 | 2023-10-04 | 11.98 | 0.30 | 2023-09-22 | 4 | 1.87 | 1 | 11.98 | 14 | SO51786 | 2023-09-29 | 0.96 | 7.47 | 2.99 | |||
SO53513_27 | 5E21-438C-B3 | PO10875194431 | 19 | 291 | 521 | 281 | 6 | 2023-11-04 | 32.54 | 0.81 | 2023-10-23 | 2 | 12.04 | 1 | 32.54 | 27 | SO53513 | 2023-10-30 | 2.60 | 24.08 | 16.27 | |||
SO47396_3 | 6B61-4DD9-AA | PO11165191815 | 19 | 291 | 352 | 586 | 6 | 2022-11-04 | 4971.41 | 124.29 | 2022-10-23 | 4 | 1117.86 | 1 | 4971.41 | 3 | SO47396 | 2022-10-30 | 397.71 | 4471.42 | 1242.85 | |||
SO63177_15 | 87AD-4113-AD | PO1856115383 | 19 | 291 | 237 | 263 | 6 | 2024-04-05 | 29.99 | 0.75 | 2024-03-24 | 1 | 38.49 | 1 | 29.99 | 15 | SO63177 | 2024-03-31 | 2.40 | 38.49 | 29.99 | |||
SO69482_2 | 0D35-42F6-9E | PO18357170772 | 19 | 284 | 573 | 138 | 6 | 2024-07-04 | 4291.33 | 107.28 | 2024-06-22 | 3 | 1481.94 | 1 | 4291.33 | 2 | SO69482 | 2024-06-29 | 343.31 | 4445.81 | 1430.44 | |||
SO48307_3 | 7DE5-4D74-A7 | PO17545123793 | 19 | 291 | 453 | 155 | 6 | 2023-02-03 | 359.94 | 9.00 | 2023-01-22 | 10 | 24.75 | 1 | 359.94 | 3 | SO48307 | 2023-01-29 | 28.80 | 247.46 | 35.99 | |||
SO48754_26 | FC6A-4A9E-83 | PO18473150383 | 19 | 291 | 448 | 442 | 6 | 2023-03-06 | 59.97 | 1.50 | 2023-02-22 | 5 | 8.25 | 1 | 59.97 | 26 | SO48754 | 2023-03-01 | 4.80 | 41.23 | 11.99 | |||
SO57103_13 | DAE3-4B11-97 | PO18357137706 | 19 | 284 | 561 | 138 | 6 | 2024-01-04 | 5721.77 | 143.04 | 2023-12-23 | 4 | 1481.94 | 1 | 5721.77 | 13 | SO57103 | 2023-12-30 | 457.74 | 5927.75 | 1430.44 | |||
SO53513_44 | 5E21-438C-B3 | PO10875194431 | 19 | 291 | 490 | 281 | 6 | 2023-11-04 | 161.97 | 4.05 | 2023-10-23 | 5 | 41.57 | 1 | 161.97 | 44 | SO53513 | 2023-10-30 | 12.96 | 207.86 | 32.39 | |||
SO46953_41 | C650-4C32-BE | PO17603154442 | 19 | 284 | 343 | 12 | 6 | 2022-10-04 | 4697.94 | 117.45 | 2022-09-22 | 10 | 486.71 | 1 | 4697.94 | 41 | SO46953 | 2022-09-29 | 375.84 | 4867.07 | 469.79 | |||
SO55297_24 | 2455-4B60-A5 | PO4495126679 | 19 | 291 | 225 | 496 | 6 | 2023-12-04 | 43.15 | 1.08 | 2023-11-22 | 8 | 6.92 | 1 | 43.15 | 24 | SO55297 | 2023-11-29 | 3.45 | 55.38 | 5.39 | |||
SO48306_14 | EA27-471A-9D | PO17574166075 | 19 | 291 | 396 | 678 | 6 | 2023-02-03 | 149.68 | 3.74 | 2023-01-22 | 2 | 55.38 | 1 | 149.68 | 14 | SO48306 | 2023-01-29 | 11.97 | 110.76 | 74.84 | |||
SO43880_3 | 3269-4442-87 | PO11020127453 | 19 | 284 | 326 | 336 | 6 | 2021-10-04 | 1258.38 | 31.46 | 2021-09-22 | 3 | 413.15 | 1 | 1258.38 | 3 | SO43880 | 2021-09-29 | 100.67 | 1239.44 | 419.46 | |||
SO63136_14 | 0873-484A-AE | PO18328125904 | 19 | 284 | 581 | 552 | 6 | 2024-04-05 | 2041.19 | 51.03 | 2024-03-24 | 2 | 1082.51 | 1 | 2041.19 | 14 | SO63136 | 2024-03-31 | 163.30 | 2165.02 | 1020.59 | |||
SO58958_30 | BC3F-443F-B5 | PO10875118816 | 19 | 291 | 463 | 281 | 6 | 2024-02-03 | 88.16 | 2.20 | 2024-01-22 | 6 | 9.16 | 1 | 88.16 | 30 | SO58958 | 2024-01-29 | 7.05 | 54.96 | 14.69 | |||
SO45529_12 | 86CC-47BA-B3 | PO17574182721 | 19 | 288 | 232 | 678 | 6 | 2022-05-04 | 115.36 | 2.88 | 2022-04-22 | 4 | 31.72 | 1 | 115.36 | 12 | SO45529 | 2022-04-29 | 9.23 | 126.90 | 28.84 | |||
SO48339_36 | EAB2-42EA-9C | PO10614150674 | 19 | 291 | 233 | 461 | 6 | 2023-02-03 | 173.04 | 4.33 | 2023-01-22 | 6 | 29.08 | 1 | 173.04 | 36 | SO48339 | 2023-01-29 | 13.84 | 174.48 | 28.84 | |||
SO46639_15 | 7CDF-4BF8-8E | PO10527141970 | 19 | 284 | 456 | 480 | 6 | 2022-09-03 | 89.99 | 2.25 | 2022-08-22 | 2 | 30.93 | 1 | 89.99 | 15 | SO46639 | 2022-08-29 | 7.20 | 61.87 | 44.99 | |||
SO57154_29 | 464B-46A4-B6 | PO1856185040 | 19 | 291 | 570 | 263 | 6 | 2024-01-04 | 445.41 | 11.14 | 2023-12-23 | 1 | 461.44 | 1 | 445.41 | 29 | SO57154 | 2023-12-30 | 35.63 | 461.44 | 445.41 | |||
SO46607_15 | C1B5-40D6-8D | PO18444137892 | 19 | 291 | 271 | 227 | 6 | 2022-09-03 | 1213.99 | 30.35 | 2022-08-22 | 6 | 187.16 | 1 | 1213.99 | 15 | SO46607 | 2022-08-29 | 97.12 | 1122.94 | 202.33 | |||
SO45323_21 | 8E16-4834-8A | PO4901118407 | 19 | 284 | 314 | 84 | 6 | 2022-04-06 | 4293.92 | 107.35 | 2022-03-25 | 2 | 2171.29 | 1 | 4293.92 | 21 | SO45323 | 2022-04-01 | 343.51 | 4342.59 | 2146.96 | |||
SO71830_13 | DA2D-4B00-A4 | PO10875112195 | 19 | 291 | 488 | 281 | 6 | 2024-08-04 | 226.76 | 5.67 | 2024-07-23 | 7 | 41.57 | 1 | 226.76 | 13 | SO71830 | 2024-07-30 | 18.14 | 291.01 | 32.39 | |||
SO69448_7 | 26BF-4CA1-97 | PO11020118669 | 19 | 284 | 583 | 336 | 6 | 2024-07-04 | 9185.35 | 229.63 | 2024-06-22 | 9 | 1082.51 | 1 | 9185.35 | 7 | SO69448 | 2024-06-29 | 734.83 | 9742.59 | 1020.59 | |||
SO71851_37 | AABE-4443-91 | PO18299133687 | 19 | 291 | 533 | 118 | 6 | 2024-08-04 | 299.75 | 7.49 | 2024-07-23 | 2 | 136.79 | 1 | 299.75 | 37 | SO71851 | 2024-07-30 | 23.98 | 273.57 | 149.87 |
Generated 2024-09-21 08:38:49.647 UTC