[ROOT] dt FactResellerSale < WHERE DimSalesTerritoryId EQ '6' > SHUFFLE < SKIP 606 > < 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 |
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
| SO46074_10 | 5178-4FDE-97 | PO2088179248 | 19 | 288 | 270 | 136 | 6 | 2022-08-23 | 183.94 | 4.60 | 2022-08-11 | 1 | 181.49 | 1 | 183.94 | 10 | SO46074 | 2022-08-18 | 14.72 | 181.49 | 183.94 | |||
| SO48338_1 | CF00-46C1-99 | PO11107115615 | 19 | 284 | 433 | 156 | 6 | 2023-03-25 | 648.91 | 16.22 | 2023-03-13 | 2 | 300.12 | 1 | 648.91 | 1 | SO48338 | 2023-03-20 | 51.91 | 600.24 | 324.45 | |||
| SO58980_30 | 8985-4B66-AD | PO18502175539 | 19 | 291 | 507 | 154 | 6 | 2024-03-24 | 200.05 | 5.00 | 2024-03-12 | 1 | 199.85 | 1 | 200.05 | 30 | SO58980 | 2024-03-19 | 16.00 | 199.85 | 200.05 | |||
| SO47662_17 | 9790-4A85-BE | PO18473142607 | 19 | 291 | 230 | 442 | 6 | 2023-01-23 | 57.68 | 1.44 | 2023-01-11 | 2 | 29.08 | 1 | 57.68 | 17 | SO47662 | 2023-01-18 | 4.61 | 58.16 | 28.84 | |||
| SO55280_14 | B925-404B-8B | PO18444178908 | 19 | 291 | 408 | 227 | 6 | 2024-01-23 | 288.65 | 7.22 | 2024-01-11 | 4 | 53.40 | 1 | 288.65 | 14 | SO55280 | 2024-01-18 | 23.09 | 213.60 | 72.16 | |||
| SO53535_24 | 8195-45C7-93 | PO18502176746 | 19 | 291 | 472 | 154 | 6 | 2023-12-24 | 76.20 | 1.91 | 2023-12-12 | 2 | 23.75 | 1 | 76.20 | 24 | SO53535 | 2023-12-19 | 6.10 | 47.50 | 38.10 | |||
| SO47413_16 | E274-4280-9B | PO1885161774 | 19 | 284 | 448 | 588 | 6 | 2022-12-24 | 59.97 | 1.50 | 2022-12-12 | 5 | 8.25 | 1 | 59.97 | 16 | SO47413 | 2022-12-19 | 4.80 | 41.23 | 11.99 | |||
| SO49140_23 | EFF3-483D-BE | PO4901154744 | 19 | 284 | 447 | 84 | 6 | 2023-05-26 | 45.00 | 1.13 | 2023-05-14 | 3 | 10.31 | 1 | 45.00 | 23 | SO49140 | 2023-05-21 | 3.60 | 30.94 | 15.00 | |||
| SO46044_18 | 029B-4675-9A | PO16733123313 | 19 | 288 | 312 | 533 | 6 | 2022-08-23 | 4293.92 | 107.35 | 2022-08-11 | 2 | 2171.29 | 1 | 4293.92 | 18 | SO46044 | 2022-08-18 | 343.51 | 4342.59 | 2146.96 | |||
| SO50204_37 | 4453-4267-A1 | PO16733169352 | 19 | 291 | 233 | 533 | 6 | 2023-08-23 | 173.04 | 4.33 | 2023-08-11 | 6 | 29.08 | 1 | 173.04 | 37 | SO50204 | 2023-08-18 | 13.84 | 174.48 | 28.84 | |||
| SO57122_24 | 048F-465A-A8 | PO4901112587 | 19 | 284 | 483 | 3 | 84 | 6 | 49.50 | 2024-02-23 | 990.00 | 23.51 | 2024-02-11 | 15 | 44.88 | 1 | 940.50 | 24 | SO57122 | 2024-02-18 | 75.24 | 673.20 | 66.00 | 0.05 |
| SO69396_3 | 210F-43F3-97 | PO19227139814 | 19 | 284 | 583 | 210 | 6 | 2024-08-23 | 2041.19 | 51.03 | 2024-08-11 | 2 | 1082.51 | 1 | 2041.19 | 3 | SO69396 | 2024-08-18 | 163.30 | 2165.02 | 1020.59 | |||
| SO48778_38 | 4F83-4D59-87 | PO4495173571 | 19 | 291 | 456 | 496 | 6 | 2023-04-25 | 179.98 | 4.50 | 2023-04-13 | 4 | 30.93 | 1 | 179.98 | 38 | SO48778 | 2023-04-20 | 14.40 | 123.73 | 44.99 | |||
| SO45313_20 | 181D-4E05-8D | PO1827151513 | 19 | 288 | 275 | 317 | 6 | 2022-05-26 | 356.90 | 8.92 | 2022-05-14 | 1 | 352.14 | 1 | 356.90 | 20 | SO45313 | 2022-05-21 | 28.55 | 352.14 | 356.90 | |||
| SO43661_9 | 4E0A-4F89-AE | PO18473189620 | 19 | 288 | 220 | 442 | 6 | 2021-10-23 | 40.37 | 1.01 | 2021-10-11 | 2 | 12.03 | 1 | 40.37 | 9 | SO43661 | 2021-10-18 | 3.23 | 24.06 | 20.19 | |||
| SO47696_8 | B251-4D0B-9C | PO1711162591 | 19 | 291 | 396 | 245 | 6 | 2023-01-23 | 299.35 | 7.48 | 2023-01-11 | 4 | 55.38 | 1 | 299.35 | 8 | SO47696 | 2023-01-18 | 23.95 | 221.52 | 74.84 | |||
| SO44744_14 | 6D80-4E9D-83 | PO19401124443 | 19 | 288 | 314 | 173 | 6 | 2022-03-25 | 2146.96 | 53.67 | 2022-03-13 | 1 | 2171.29 | 1 | 2146.96 | 14 | SO44744 | 2022-03-20 | 171.76 | 2171.29 | 2146.96 | |||
| SO46959_46 | 9007-4F97-9C | PO16733197949 | 19 | 291 | 447 | 533 | 6 | 2022-11-23 | 75.00 | 1.88 | 2022-11-11 | 5 | 10.31 | 1 | 75.00 | 46 | SO46959 | 2022-11-18 | 6.00 | 51.56 | 15.00 | |||
| SO58972_6 | 07C8-43BD-85 | PO1798131785 | 19 | 291 | 543 | 10 | 6 | 2024-03-24 | 149.02 | 3.73 | 2024-03-12 | 4 | 27.57 | 1 | 149.02 | 6 | SO58972 | 2024-03-19 | 11.92 | 110.27 | 37.25 | |||
| SO47690_8 | B248-4AA7-92 | PO10527158850 | 19 | 284 | 456 | 480 | 6 | 2023-01-23 | 89.99 | 2.25 | 2023-01-11 | 2 | 30.93 | 1 | 89.99 | 8 | SO47690 | 2023-01-18 | 7.20 | 61.87 | 44.99 | |||
| SO47966_3 | 86D0-4101-B5 | PO19227154269 | 19 | 284 | 329 | 210 | 6 | 2023-02-23 | 1409.38 | 35.23 | 2023-02-11 | 3 | 486.71 | 1 | 1409.38 | 3 | SO47966 | 2023-02-18 | 112.75 | 1460.12 | 469.79 | |||
| SO69399_1 | BEA9-4703-91 | PO17661173810 | 19 | 284 | 552 | 264 | 6 | 2024-08-23 | 54.89 | 1.37 | 2024-08-11 | 1 | 40.62 | 1 | 54.89 | 1 | SO69399 | 2024-08-18 | 4.39 | 40.62 | 54.89 | |||
| SO50204_9 | 4453-4267-A1 | PO16733169352 | 19 | 291 | 327 | 533 | 6 | 2023-08-23 | 1879.18 | 46.98 | 2023-08-11 | 4 | 486.71 | 1 | 1879.18 | 9 | SO50204 | 2023-08-18 | 150.33 | 1946.83 | 469.79 | |||
| SO44744_6 | 6D80-4E9D-83 | PO19401124443 | 19 | 288 | 326 | 173 | 6 | 2022-03-25 | 1258.38 | 31.46 | 2022-03-13 | 3 | 413.15 | 1 | 1258.38 | 6 | SO44744 | 2022-03-20 | 100.67 | 1239.44 | 419.46 | |||
| SO58957_25 | 13BB-49DB-84 | PO10962177270 | 19 | 284 | 599 | 685 | 6 | 2024-03-24 | 1295.98 | 32.40 | 2024-03-12 | 4 | 294.58 | 1 | 1295.98 | 25 | SO58957 | 2024-03-19 | 103.68 | 1178.32 | 323.99 | |||
| SO47668_1 | 7CB5-4904-AD | PO15312152020 | 19 | 291 | 221 | 299 | 6 | 2023-01-23 | 181.68 | 4.54 | 2023-01-11 | 9 | 13.88 | 1 | 181.68 | 1 | SO47668 | 2023-01-18 | 14.53 | 124.90 | 20.19 | |||
| SO44086_11 | B4B4-44C7-84 | PO17574175064 | 19 | 288 | 296 | 678 | 6 | 2021-12-24 | 3573.52 | 89.34 | 2021-12-12 | 5 | 617.03 | 1 | 3573.52 | 11 | SO44086 | 2021-12-19 | 285.88 | 3085.14 | 714.70 | |||
| SO58925_21 | ACBD-43C3-A2 | PO15544139465 | 19 | 284 | 569 | 282 | 6 | 2024-03-24 | 445.41 | 11.14 | 2024-03-12 | 1 | 461.44 | 1 | 445.41 | 21 | SO58925 | 2024-03-19 | 35.63 | 461.44 | 445.41 | |||
| SO71829_19 | 427E-46EE-B0 | PO10962123279 | 19 | 284 | 543 | 685 | 6 | 2024-09-23 | 37.25 | 0.93 | 2024-09-11 | 1 | 27.57 | 1 | 37.25 | 19 | SO71829 | 2024-09-18 | 2.98 | 27.57 | 37.25 | |||
| SO57079_3 | 1CB1-4EC7-8E | PO638182054 | 19 | 291 | 474 | 280 | 6 | 2024-02-23 | 83.99 | 2.10 | 2024-02-11 | 2 | 26.18 | 1 | 83.99 | 3 | SO57079 | 2024-02-18 | 6.72 | 52.35 | 41.99 | |||
| SO71825_3 | 13EC-4324-90 | PO11165197222 | 19 | 291 | 359 | 586 | 6 | 2024-09-23 | 2753.99 | 68.85 | 2024-09-11 | 2 | 1251.98 | 1 | 2753.99 | 3 | SO71825 | 2024-09-18 | 220.32 | 2503.96 | 1376.99 | |||
| SO58932_3 | CE5B-4A8C-96 | PO14761124028 | 19 | 284 | 564 | 408 | 6 | 2024-03-24 | 4291.33 | 107.28 | 2024-03-12 | 3 | 1481.94 | 1 | 4291.33 | 3 | SO58932 | 2024-03-19 | 343.31 | 4445.81 | 1430.44 | |||
| SO46075_1 | D380-48D0-9A | PO2204192145 | 19 | 288 | 326 | 370 | 6 | 2022-08-23 | 419.46 | 10.49 | 2022-08-11 | 1 | 413.15 | 1 | 419.46 | 1 | SO46075 | 2022-08-18 | 33.56 | 413.15 | 419.46 | |||
| SO57023_1 | EE6C-4089-A0 | PO17603140236 | 19 | 284 | 583 | 3 | 12 | 6 | 795.21 | 2024-02-23 | 15904.26 | 377.73 | 2024-02-11 | 17 | 1082.51 | 1 | 15109.04 | 1 | SO57023 | 2024-02-18 | 1208.72 | 18402.67 | 935.54 | 0.05 |
| SO47362_13 | 41E3-4BA0-99 | PO17690189228 | 19 | 291 | 419 | 47 | 6 | 2022-12-24 | 157.94 | 3.95 | 2022-12-12 | 3 | 38.96 | 1 | 157.94 | 13 | SO47362 | 2022-12-19 | 12.64 | 116.88 | 52.65 | |||
| SO46614_7 | 0B65-4374-89 | PO15312137226 | 19 | 291 | 417 | 299 | 6 | 2022-10-23 | 973.36 | 24.33 | 2022-10-11 | 3 | 300.12 | 1 | 973.36 | 7 | SO46614 | 2022-10-18 | 77.87 | 900.36 | 324.45 | |||
| SO67304_19 | 5E78-4926-A4 | PO18444191982 | 19 | 291 | 436 | 227 | 6 | 2024-07-24 | 1427.59 | 35.69 | 2024-07-12 | 4 | 360.94 | 1 | 1427.59 | 19 | SO67304 | 2024-07-19 | 114.21 | 1443.77 | 356.90 | |||
| SO53509_12 | 4718-4C12-86 | PO11107182902 | 19 | 284 | 483 | 156 | 6 | 2023-12-24 | 432.00 | 10.80 | 2023-12-12 | 6 | 44.88 | 1 | 432.00 | 12 | SO53509 | 2023-12-19 | 34.56 | 269.28 | 72.00 | |||
| SO53483_6 | A0BE-40E0-81 | PO14761137153 | 19 | 284 | 560 | 408 | 6 | 2023-12-24 | 6560.19 | 164.00 | 2023-12-12 | 9 | 755.15 | 1 | 6560.19 | 6 | SO53483 | 2023-12-19 | 524.82 | 6796.36 | 728.91 | |||
| SO49827_21 | E4F0-4B91-84 | PO15312199090 | 19 | 291 | 462 | 299 | 6 | 2023-07-24 | 42.39 | 1.06 | 2023-07-12 | 3 | 9.71 | 1 | 42.39 | 21 | SO49827 | 2023-07-19 | 3.39 | 29.14 | 14.13 | |||
| SO47012_1 | 5043-4C8B-B3 | PO1914167487 | 19 | 284 | 417 | 66 | 6 | 2022-11-23 | 1622.26 | 40.56 | 2022-11-11 | 5 | 300.12 | 1 | 1622.26 | 1 | SO47012 | 2022-11-18 | 129.78 | 1500.59 | 324.45 | |||
| SO48321_27 | FA9B-4026-BF | PO14790154902 | 19 | 291 | 460 | 497 | 6 | 2023-03-25 | 485.95 | 12.15 | 2023-03-13 | 9 | 37.12 | 1 | 485.95 | 27 | SO48321 | 2023-03-20 | 38.88 | 334.09 | 53.99 | |||
| SO57154_14 | 464B-46A4-B6 | PO1856185040 | 19 | 291 | 237 | 263 | 6 | 2024-02-23 | 149.97 | 3.75 | 2024-02-11 | 5 | 38.49 | 1 | 149.97 | 14 | SO57154 | 2024-02-18 | 12.00 | 192.46 | 29.99 | |||
| SO50676_34 | 66F1-4A9A-97 | PO14790188963 | 19 | 291 | 365 | 497 | 6 | 2023-09-23 | 647.99 | 16.20 | 2023-09-11 | 1 | 598.44 | 1 | 647.99 | 34 | SO50676 | 2023-09-18 | 51.84 | 598.44 | 647.99 | |||
| SO48304_5 | C44F-4632-AD | PO17690111423 | 19 | 291 | 469 | 47 | 6 | 2023-03-25 | 91.18 | 2.28 | 2023-03-13 | 4 | 15.67 | 1 | 91.18 | 5 | SO48304 | 2023-03-20 | 7.29 | 62.68 | 22.79 | |||
| SO71871_4 | DD8F-4CAB-A1 | PO14239120760 | 19 | 291 | 491 | 550 | 6 | 2024-09-23 | 226.76 | 5.67 | 2024-09-11 | 7 | 41.57 | 1 | 226.76 | 4 | SO71871 | 2024-09-18 | 18.14 | 291.01 | 32.39 | |||
| 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 | |||
| SO65238_12 | 896A-4ED1-B1 | PO10875188169 | 19 | 291 | 579 | 281 | 6 | 2024-06-23 | 1457.82 | 36.45 | 2024-06-11 | 2 | 755.15 | 1 | 1457.82 | 12 | SO65238 | 2024-06-18 | 116.63 | 1510.30 | 728.91 |
Generated 2024-11-11 02:25:45.550 UTC