[ROOT] dt FactResellerSale < WHERE DimSalesTerritoryId EQ '6' > SHUFFLE < SKIP 620 > < TAKE 56 >
56 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 |
---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
SO61204_32 | E810-4164-82 | PO15312134209 | 19 | 291 | 225 | 299 | 6 | 2024-03-04 | 32.36 | 0.81 | 2024-02-21 | 6 | 6.92 | 1 | 32.36 | 32 | SO61204 | 2024-02-28 | 2.59 | 41.53 | 5.39 | |||
SO45522_8 | DB6E-40EF-A4 | PO19401195812 | 19 | 288 | 312 | 173 | 6 | 2022-05-03 | 4293.92 | 107.35 | 2022-04-21 | 2 | 2171.29 | 1 | 4293.92 | 8 | SO45522 | 2022-04-28 | 343.51 | 4342.59 | 2146.96 | |||
SO48754_21 | FC6A-4A9E-83 | PO18473150383 | 19 | 291 | 354 | 442 | 6 | 2023-03-05 | 2485.70 | 62.14 | 2023-02-21 | 2 | 1117.86 | 1 | 2485.70 | 21 | SO48754 | 2023-02-28 | 198.86 | 2235.71 | 1242.85 | |||
SO61222_19 | 9C3C-4330-8A | PO13862196260 | 19 | 291 | 357 | 119 | 6 | 2024-03-04 | 2783.99 | 69.60 | 2024-02-21 | 2 | 1265.62 | 1 | 2783.99 | 19 | SO61222 | 2024-02-28 | 222.72 | 2531.24 | 1391.99 | |||
SO49066_23 | 4065-4B0A-A2 | PO1595117888 | 19 | 284 | 458 | 426 | 6 | 2023-04-05 | 44.99 | 1.12 | 2023-03-24 | 1 | 30.93 | 1 | 44.99 | 23 | SO49066 | 2023-03-31 | 3.60 | 30.93 | 44.99 | |||
SO55243_27 | 2457-46EE-88 | PO15312160912 | 19 | 291 | 240 | 299 | 6 | 2023-12-03 | 858.90 | 21.47 | 2023-11-21 | 1 | 868.63 | 1 | 858.90 | 27 | SO55243 | 2023-11-28 | 68.71 | 868.63 | 858.90 | |||
SO57120_35 | 058D-436F-BF | PO4466170177 | 19 | 291 | 465 | 352 | 6 | 2024-01-03 | 73.47 | 1.84 | 2023-12-22 | 5 | 9.16 | 1 | 73.47 | 35 | SO57120 | 2023-12-29 | 5.88 | 45.80 | 14.69 | |||
SO67302_23 | E4B2-462D-AC | PO18473194134 | 19 | 291 | 559 | 442 | 6 | 2024-06-03 | 12.14 | 0.30 | 2024-05-22 | 1 | 8.99 | 1 | 12.14 | 23 | SO67302 | 2024-05-29 | 0.97 | 8.99 | 12.14 | |||
SO47359_51 | 8BC9-458A-82 | PO18299145297 | 19 | 291 | 420 | 118 | 6 | 2022-11-03 | 283.23 | 7.08 | 2022-10-22 | 2 | 104.80 | 1 | 283.23 | 51 | SO47359 | 2022-10-29 | 22.66 | 209.59 | 141.62 | |||
SO46062_25 | 114A-41C0-B5 | PO11600112515 | 19 | 288 | 215 | 569 | 6 | 2022-07-03 | 121.12 | 3.03 | 2022-06-21 | 6 | 12.03 | 1 | 121.12 | 25 | SO46062 | 2022-06-28 | 9.69 | 72.17 | 20.19 | |||
SO69522_19 | 28C3-4615-8B | PO4901187436 | 19 | 284 | 483 | 84 | 6 | 2024-07-03 | 288.00 | 7.20 | 2024-06-21 | 4 | 44.88 | 1 | 288.00 | 19 | SO69522 | 2024-06-28 | 23.04 | 179.52 | 72.00 | |||
SO50664_29 | 85F5-458B-8D | PO19401149024 | 19 | 291 | 385 | 173 | 6 | 2023-08-03 | 1800.79 | 45.02 | 2023-07-22 | 3 | 605.65 | 1 | 1800.79 | 29 | SO50664 | 2023-07-29 | 144.06 | 1816.95 | 600.26 | |||
SO49485_5 | 9EA5-4DEF-B8 | PO17545171443 | 19 | 291 | 368 | 155 | 6 | 2023-05-03 | 7330.05 | 183.25 | 2023-04-21 | 5 | 1518.79 | 1 | 7330.05 | 5 | SO49485 | 2023-04-28 | 586.40 | 7593.93 | 1466.01 | |||
SO47668_34 | 7CB5-4904-AD | PO15312152020 | 19 | 291 | 389 | 299 | 6 | 2022-12-03 | 600.26 | 15.01 | 2022-11-21 | 1 | 605.65 | 1 | 600.26 | 34 | SO47668 | 2022-11-28 | 48.02 | 605.65 | 600.26 | |||
SO50242_38 | A651-4343-86 | PO1595193228 | 19 | 284 | 369 | 426 | 6 | 2023-07-03 | 1466.01 | 36.65 | 2023-06-21 | 1 | 1518.79 | 1 | 1466.01 | 38 | SO50242 | 2023-06-28 | 117.28 | 1518.79 | 1466.01 | |||
SO46938_25 | 2E58-4440-89 | PO19198122384 | 19 | 291 | 393 | 653 | 6 | 2022-10-03 | 550.78 | 13.77 | 2022-09-21 | 4 | 101.89 | 1 | 550.78 | 25 | SO46938 | 2022-09-28 | 44.06 | 407.57 | 137.69 | |||
SO71794_4 | C39A-4835-99 | PO17574111985 | 19 | 291 | 531 | 678 | 6 | 2024-08-03 | 599.50 | 14.99 | 2024-07-22 | 4 | 136.79 | 1 | 599.50 | 4 | SO71794 | 2024-07-29 | 47.96 | 547.14 | 149.87 | |||
SO51700_23 | 6837-439E-BC | PO17806126316 | 19 | 291 | 484 | 101 | 6 | 2023-10-03 | 23.85 | 0.60 | 2023-09-21 | 5 | 2.97 | 1 | 23.85 | 23 | SO51700 | 2023-09-28 | 1.91 | 14.87 | 4.77 | |||
SO46044_24 | 029B-4675-9A | PO16733123313 | 19 | 288 | 220 | 533 | 6 | 2022-07-03 | 40.37 | 1.01 | 2022-06-21 | 2 | 12.03 | 1 | 40.37 | 24 | SO46044 | 2022-06-28 | 3.23 | 24.06 | 20.19 | |||
SO46608_49 | ACF1-4852-B7 | PO18473177913 | 19 | 291 | 352 | 442 | 6 | 2022-09-02 | 7457.11 | 186.43 | 2022-08-21 | 6 | 1117.86 | 1 | 7457.11 | 49 | SO46608 | 2022-08-28 | 596.57 | 6707.14 | 1242.85 | |||
SO71794_24 | C39A-4835-99 | PO17574111985 | 19 | 291 | 306 | 678 | 6 | 2024-08-03 | 2429.28 | 60.73 | 2024-07-22 | 3 | 739.04 | 1 | 2429.28 | 24 | SO71794 | 2024-07-29 | 194.34 | 2217.12 | 809.76 | |||
SO53535_30 | 8195-45C7-93 | PO18502176746 | 19 | 291 | 570 | 13 | 154 | 6 | 150.33 | 2023-11-03 | 1002.17 | 21.30 | 2023-10-22 | 3 | 461.44 | 1 | 851.85 | 30 | SO53535 | 2023-10-29 | 68.15 | 1384.33 | 334.06 | 0.15 |
SO51769_14 | 4AAC-4066-A6 | PO1595126190 | 19 | 284 | 408 | 426 | 6 | 2023-10-03 | 144.32 | 3.61 | 2023-09-21 | 2 | 53.40 | 1 | 144.32 | 14 | SO51769 | 2023-09-28 | 11.55 | 106.80 | 72.16 | |||
SO45038_12 | 2001-401A-83 | PO18473129920 | 19 | 288 | 307 | 442 | 6 | 2022-03-05 | 722.59 | 18.06 | 2022-02-21 | 1 | 623.84 | 1 | 722.59 | 12 | SO45038 | 2022-02-28 | 57.81 | 623.84 | 722.59 | |||
SO55287_12 | 4BBD-4DA3-AD | PO13862128497 | 19 | 291 | 592 | 119 | 6 | 2023-12-03 | 1016.98 | 25.42 | 2023-11-21 | 3 | 308.22 | 1 | 1016.98 | 12 | SO55287 | 2023-11-28 | 81.36 | 924.65 | 338.99 | |||
SO47031_7 | 3FA6-4120-BD | PO4466161844 | 19 | 291 | 447 | 352 | 6 | 2022-10-03 | 75.00 | 1.88 | 2022-09-21 | 5 | 10.31 | 1 | 75.00 | 7 | SO47031 | 2022-09-28 | 6.00 | 51.56 | 15.00 | |||
SO63174_11 | 0B72-4270-AC | PO1827182060 | 19 | 291 | 390 | 317 | 6 | 2024-04-04 | 2016.88 | 50.42 | 2024-03-23 | 3 | 713.08 | 1 | 2016.88 | 11 | SO63174 | 2024-03-30 | 161.35 | 2139.24 | 672.29 | |||
SO46608_10 | ACF1-4852-B7 | PO18473177913 | 19 | 291 | 230 | 442 | 6 | 2022-09-02 | 115.36 | 2.88 | 2022-08-21 | 4 | 29.08 | 1 | 115.36 | 10 | SO46608 | 2022-08-28 | 9.23 | 116.32 | 28.84 | |||
SO49485_32 | 9EA5-4DEF-B8 | PO17545171443 | 19 | 291 | 375 | 155 | 6 | 2023-05-03 | 3926.81 | 98.17 | 2023-04-21 | 3 | 1320.68 | 1 | 3926.81 | 32 | SO49485 | 2023-04-28 | 314.15 | 3962.05 | 1308.94 | |||
SO57122_2 | 048F-465A-A8 | PO4901112587 | 19 | 284 | 418 | 84 | 6 | 2024-01-03 | 356.90 | 8.92 | 2023-12-22 | 1 | 360.94 | 1 | 356.90 | 2 | SO57122 | 2023-12-29 | 28.55 | 360.94 | 356.90 | |||
SO49140_8 | EFF3-483D-BE | PO4901154744 | 19 | 284 | 213 | 84 | 6 | 2023-04-05 | 161.49 | 4.04 | 2023-03-24 | 8 | 13.88 | 1 | 161.49 | 8 | SO49140 | 2023-03-31 | 12.92 | 111.03 | 20.19 | |||
SO44484_3 | 99EE-44F9-BF | PO19691173790 | 19 | 288 | 219 | 353 | 6 | 2022-01-03 | 5.70 | 0.14 | 2021-12-22 | 1 | 3.40 | 1 | 5.70 | 3 | SO44484 | 2021-12-29 | 0.46 | 3.40 | 5.70 | |||
SO47708_49 | 86B1-46A5-95 | PO4495147689 | 19 | 291 | 457 | 496 | 6 | 2022-12-03 | 89.99 | 2.25 | 2022-11-21 | 2 | 30.93 | 1 | 89.99 | 49 | SO47708 | 2022-11-28 | 7.20 | 61.87 | 44.99 | |||
SO65174_47 | E2AA-4EEC-93 | PO17574133893 | 19 | 291 | 491 | 678 | 6 | 2024-05-03 | 323.94 | 8.10 | 2024-04-21 | 10 | 41.57 | 1 | 323.94 | 47 | SO65174 | 2024-04-28 | 25.92 | 415.72 | 32.39 | |||
SO47663_24 | 1B17-4C63-B6 | PO18444192283 | 19 | 291 | 383 | 227 | 6 | 2022-12-03 | 600.26 | 15.01 | 2022-11-21 | 1 | 605.65 | 1 | 600.26 | 24 | SO47663 | 2022-11-28 | 48.02 | 605.65 | 600.26 | |||
SO49871_4 | 032A-45C4-8D | PO4930185924 | 19 | 291 | 358 | 425 | 6 | 2023-06-03 | 2458.92 | 61.47 | 2023-05-22 | 2 | 1105.81 | 1 | 2458.92 | 4 | SO49871 | 2023-05-29 | 196.71 | 2211.62 | 1229.46 | |||
SO58932_1 | CE5B-4A8C-96 | PO14761124028 | 19 | 284 | 502 | 408 | 6 | 2024-02-02 | 600.16 | 15.00 | 2024-01-21 | 3 | 199.85 | 1 | 600.16 | 1 | SO58932 | 2024-01-28 | 48.01 | 599.56 | 200.05 | |||
SO49039_2 | 4F9E-4A1A-B3 | PO20039119229 | 19 | 291 | 468 | 65 | 6 | 2023-04-05 | 113.97 | 2.85 | 2023-03-24 | 5 | 15.67 | 1 | 113.97 | 2 | SO49039 | 2023-03-31 | 9.12 | 78.35 | 22.79 | |||
SO71828_8 | 73A0-490C-B1 | PO11194153355 | 19 | 284 | 496 | 48 | 6 | 2024-08-03 | 2409.38 | 60.23 | 2024-07-22 | 4 | 601.74 | 1 | 2409.38 | 8 | SO71828 | 2024-07-29 | 192.75 | 2406.97 | 602.35 | |||
SO58980_9 | 8985-4B66-AD | PO18502175539 | 19 | 291 | 565 | 154 | 6 | 2024-02-02 | 3563.28 | 89.08 | 2024-01-21 | 8 | 461.44 | 1 | 3563.28 | 9 | SO58980 | 2024-01-28 | 285.06 | 3691.56 | 445.41 | |||
SO50242_10 | A651-4343-86 | PO1595193228 | 19 | 284 | 286 | 426 | 6 | 2023-07-03 | 367.88 | 9.20 | 2023-06-21 | 2 | 170.14 | 1 | 367.88 | 10 | SO50242 | 2023-06-28 | 29.43 | 340.29 | 183.94 | |||
SO65198_2 | 8423-4A3C-93 | PO11165196805 | 19 | 291 | 475 | 586 | 6 | 2024-05-03 | 41.99 | 1.05 | 2024-04-21 | 1 | 26.18 | 1 | 41.99 | 2 | SO65198 | 2024-04-28 | 3.36 | 26.18 | 41.99 | |||
SO69478_8 | E63C-4ABF-83 | PO18705185140 | 19 | 291 | 374 | 479 | 6 | 2024-07-03 | 1466.01 | 36.65 | 2024-06-21 | 1 | 1554.95 | 1 | 1466.01 | 8 | SO69478 | 2024-06-28 | 117.28 | 1554.95 | 1466.01 | |||
SO46034_5 | BF2B-4539-A2 | PO18415186478 | 19 | 288 | 253 | 191 | 6 | 2022-07-03 | 357.16 | 8.93 | 2022-06-21 | 2 | 176.20 | 1 | 357.16 | 5 | SO46034 | 2022-06-28 | 28.57 | 352.40 | 178.58 | |||
SO65206_17 | 6CD1-4BEC-A0 | PO1798192797 | 19 | 291 | 589 | 10 | 6 | 2024-05-03 | 923.39 | 23.08 | 2024-04-21 | 2 | 419.78 | 1 | 923.39 | 17 | SO65206 | 2024-04-28 | 73.87 | 839.56 | 461.69 | |||
SO43844_4 | 15C3-40C5-AC | PO19691138342 | 19 | 288 | 351 | 353 | 6 | 2021-10-03 | 2024.99 | 50.62 | 2021-09-21 | 1 | 1898.09 | 1 | 2024.99 | 4 | SO43844 | 2021-09-28 | 162.00 | 1898.09 | 2024.99 | |||
SO50265_44 | 6C30-435D-9D | PO18705169014 | 19 | 291 | 371 | 479 | 6 | 2023-07-03 | 2617.88 | 65.45 | 2023-06-21 | 2 | 1320.68 | 1 | 2617.88 | 44 | SO50265 | 2023-06-28 | 209.43 | 2641.37 | 1308.94 | |||
SO55266_10 | 03C7-431B-BA | PO10527171106 | 19 | 284 | 481 | 480 | 6 | 2023-12-03 | 21.58 | 0.54 | 2023-11-21 | 4 | 3.36 | 1 | 21.58 | 10 | SO55266 | 2023-11-28 | 1.73 | 13.45 | 5.39 | |||
SO55297_3 | 2455-4B60-A5 | PO4495126679 | 19 | 291 | 467 | 496 | 6 | 2023-12-03 | 73.47 | 1.84 | 2023-11-21 | 5 | 9.16 | 1 | 73.47 | 3 | SO55297 | 2023-11-28 | 5.88 | 45.80 | 14.69 | |||
SO45781_6 | EB85-4E0C-A3 | PO18444138991 | 19 | 288 | 334 | 227 | 6 | 2022-06-03 | 838.92 | 20.97 | 2022-05-22 | 2 | 413.15 | 1 | 838.92 | 6 | SO45781 | 2022-05-29 | 67.11 | 826.29 | 419.46 | |||
SO47973_42 | B9F1-47DA-87 | PO18705118148 | 19 | 291 | 375 | 479 | 6 | 2023-01-03 | 6544.69 | 163.62 | 2022-12-22 | 5 | 1320.68 | 1 | 6544.69 | 42 | SO47973 | 2022-12-29 | 523.58 | 6603.42 | 1308.94 | |||
SO53509_9 | 4718-4C12-86 | PO11107182902 | 19 | 284 | 547 | 156 | 6 | 2023-11-03 | 48.59 | 1.21 | 2023-10-22 | 1 | 35.96 | 1 | 48.59 | 9 | SO53509 | 2023-10-29 | 3.89 | 35.96 | 48.59 | |||
SO50676_35 | 66F1-4A9A-97 | PO14790188963 | 19 | 291 | 354 | 497 | 6 | 2023-08-03 | 2485.70 | 62.14 | 2023-07-22 | 2 | 1117.86 | 1 | 2485.70 | 35 | SO50676 | 2023-07-29 | 198.86 | 2235.71 | 1242.85 | |||
SO69560_22 | B1B6-43F4-BC | PO9077167302 | 19 | 291 | 398 | 100 | 6 | 2024-07-03 | 26.72 | 0.67 | 2024-06-21 | 1 | 19.78 | 1 | 26.72 | 22 | SO69560 | 2024-06-28 | 2.14 | 19.78 | 26.72 | |||
SO65243_10 | F88F-4FB2-85 | PO11194174051 | 19 | 284 | 493 | 48 | 6 | 2024-05-03 | 400.10 | 10.00 | 2024-04-21 | 2 | 199.85 | 1 | 400.10 | 10 | SO65243 | 2024-04-28 | 32.01 | 399.70 | 200.05 | |||
SO53510_8 | 8E8D-4B13-B1 | PO10962181057 | 19 | 284 | 361 | 685 | 6 | 2023-11-03 | 2753.99 | 68.85 | 2023-10-22 | 2 | 1251.98 | 1 | 2753.99 | 8 | SO53510 | 2023-10-29 | 220.32 | 2503.96 | 1376.99 |
Generated 2024-09-20 20:41:06.726 UTC