[ROOT] dt FactResellerSale < WHERE DimSalesTerritoryId EQ '4' > SHUFFLE < SKIP 340 > < 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 |
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
| SO58979_22 | A35B-403A-A4 | PO18038174164 | 100 | 287 | 568 | 509 | 4 | 2024-03-24 | 1336.23 | 33.41 | 2024-03-12 | 3 | 461.44 | 1 | 1336.23 | 22 | SO58979 | 2024-03-19 | 106.90 | 1384.33 | 445.41 | |||
| SO57062_23 | D146-4B3C-BB | PO11745129321 | 100 | 282 | 583 | 97 | 4 | 2024-02-23 | 5102.97 | 127.57 | 2024-02-11 | 5 | 1082.51 | 1 | 5102.97 | 23 | SO57062 | 2024-02-18 | 408.24 | 5412.55 | 1020.59 | |||
| SO50208_2 | 6993-49B4-8B | PO15689114248 | 100 | 281 | 389 | 328 | 4 | 2023-08-23 | 4201.84 | 105.05 | 2023-08-11 | 7 | 605.65 | 1 | 4201.84 | 2 | SO50208 | 2023-08-18 | 336.15 | 4239.54 | 600.26 | |||
| SO49527_6 | BFD0-4AA2-AF | PO4640129987 | 100 | 287 | 362 | 648 | 4 | 2023-06-23 | 2458.92 | 61.47 | 2023-06-11 | 2 | 1105.81 | 1 | 2458.92 | 6 | SO49527 | 2023-06-18 | 196.71 | 2211.62 | 1229.46 | |||
| SO67305_25 | CBB5-42BF-9E | PO16298111473 | 100 | 287 | 502 | 599 | 4 | 2024-07-24 | 400.10 | 10.00 | 2024-07-12 | 2 | 199.85 | 1 | 400.10 | 25 | SO67305 | 2024-07-19 | 32.01 | 399.70 | 200.05 | |||
| SO49841_24 | 35A1-40DC-99 | PO10817181706 | 100 | 287 | 448 | 203 | 4 | 2023-07-24 | 11.99 | 0.30 | 2023-07-12 | 1 | 8.25 | 1 | 11.99 | 24 | SO49841 | 2023-07-19 | 0.96 | 8.25 | 11.99 | |||
| SO65315_25 | 0FFB-4EB5-A3 | PO6757194680 | 100 | 281 | 309 | 21 | 4 | 2024-06-23 | 818.70 | 20.47 | 2024-06-11 | 1 | 747.20 | 1 | 818.70 | 25 | SO65315 | 2024-06-18 | 65.50 | 747.20 | 818.70 | |||
| SO43904_11 | BB8E-4008-B7 | PO6351158788 | 100 | 283 | 326 | 255 | 4 | 2021-11-23 | 419.46 | 10.49 | 2021-11-11 | 1 | 413.15 | 1 | 419.46 | 11 | SO43904 | 2021-11-18 | 33.56 | 413.15 | 419.46 | |||
| SO50738_27 | 531C-4E52-80 | PO3915159731 | 100 | 281 | 456 | 130 | 4 | 2023-09-23 | 449.94 | 11.25 | 2023-09-11 | 10 | 30.93 | 1 | 449.94 | 27 | SO50738 | 2023-09-18 | 36.00 | 309.33 | 44.99 | |||
| SO50747_9 | A59F-46DA-BE | PO5597196496 | 100 | 281 | 445 | 75 | 4 | 2023-09-23 | 107.98 | 2.70 | 2023-09-11 | 3 | 24.75 | 1 | 107.98 | 9 | SO50747 | 2023-09-18 | 8.64 | 74.24 | 35.99 | |||
| SO46648_10 | 2073-4051-9E | PO2494191557 | 100 | 283 | 445 | 184 | 4 | 2022-10-23 | 143.98 | 3.60 | 2022-10-11 | 4 | 24.75 | 1 | 143.98 | 10 | SO46648 | 2022-10-18 | 11.52 | 98.98 | 35.99 | |||
| SO51131_33 | D489-4DF3-A2 | PO16298169856 | 100 | 287 | 577 | 599 | 4 | 2023-10-23 | 1457.82 | 36.45 | 2023-10-11 | 2 | 755.15 | 1 | 1457.82 | 33 | SO51131 | 2023-10-18 | 116.63 | 1510.30 | 728.91 | |||
| SO71782_13 | CA08-4A9B-8D | PO19372114749 | 100 | 282 | 562 | 582 | 4 | 2024-09-23 | 1430.44 | 35.76 | 2024-09-11 | 1 | 1481.94 | 1 | 1430.44 | 13 | SO71782 | 2024-09-18 | 114.44 | 1481.94 | 1430.44 | |||
| SO44314_14 | 6FDF-4206-A7 | PO5626111923 | 100 | 283 | 336 | 166 | 4 | 2022-01-23 | 838.92 | 20.97 | 2022-01-11 | 2 | 413.15 | 1 | 838.92 | 14 | SO44314 | 2022-01-18 | 67.11 | 826.29 | 419.46 | |||
| SO45568_14 | 32F9-4A87-9D | PO6786144925 | 100 | 283 | 315 | 3 | 4 | 2022-06-23 | 4373.97 | 109.35 | 2022-06-11 | 5 | 884.71 | 1 | 4373.97 | 14 | SO45568 | 2022-06-18 | 349.92 | 4423.54 | 874.79 | |||
| SO43873_3 | 494C-48D2-BD | PO12499138177 | 100 | 282 | 310 | 78 | 4 | 2021-11-23 | 4293.92 | 107.35 | 2021-11-11 | 2 | 2171.29 | 1 | 4293.92 | 3 | SO43873 | 2021-11-18 | 343.51 | 4342.59 | 2146.96 | |||
| SO57134_10 | 040D-4B73-AD | PO6351190175 | 100 | 281 | 390 | 255 | 4 | 2024-02-23 | 672.29 | 16.81 | 2024-02-11 | 1 | 713.08 | 1 | 672.29 | 10 | SO57134 | 2024-02-18 | 53.78 | 713.08 | 672.29 | |||
| SO44783_9 | 8DE2-4684-BC | PO4640171635 | 100 | 287 | 351 | 648 | 4 | 2022-03-25 | 4049.99 | 101.25 | 2022-03-13 | 2 | 1898.09 | 1 | 4049.99 | 9 | SO44783 | 2022-03-20 | 324.00 | 3796.19 | 2024.99 | |||
| SO49515_13 | 52D0-4584-BC | PO9715144044 | 100 | 281 | 409 | 490 | 4 | 2023-06-23 | 209.26 | 5.23 | 2023-06-11 | 1 | 185.82 | 1 | 209.26 | 13 | SO49515 | 2023-06-18 | 16.74 | 185.82 | 209.26 | |||
| SO67325_23 | 981F-41CE-8A | PO7859144943 | 100 | 287 | 234 | 2 | 221 | 4 | 8.12 | 2024-07-24 | 405.92 | 9.95 | 2024-07-12 | 14 | 38.49 | 1 | 397.80 | 23 | SO67325 | 2024-07-19 | 31.82 | 538.89 | 28.99 | 0.02 |
| SO47994_6 | 284B-45A1-94 | PO15196121630 | 100 | 282 | 417 | 258 | 4 | 2023-02-23 | 973.36 | 24.33 | 2023-02-11 | 3 | 300.12 | 1 | 973.36 | 6 | SO47994 | 2023-02-18 | 77.87 | 900.36 | 324.45 | |||
| SO58942_1 | 5900-4D8F-A6 | PO13021136057 | 100 | 282 | 380 | 276 | 4 | 2024-03-24 | 1466.01 | 36.65 | 2024-03-12 | 1 | 1554.95 | 1 | 1466.01 | 1 | SO58942 | 2024-03-19 | 117.28 | 1554.95 | 1466.01 | |||
| SO47677_39 | 2C43-407F-B3 | PO13688179339 | 100 | 282 | 289 | 475 | 4 | 2023-01-23 | 1488.55 | 37.21 | 2023-01-11 | 2 | 660.91 | 1 | 1488.55 | 39 | SO47677 | 2023-01-18 | 119.08 | 1321.83 | 744.27 | |||
| SO71845_22 | 4781-4673-85 | PO2697119362 | 100 | 282 | 551 | 187 | 4 | 2024-09-23 | 316.86 | 7.92 | 2024-09-11 | 2 | 144.59 | 1 | 316.86 | 22 | SO71845 | 2024-09-18 | 25.35 | 289.19 | 158.43 | |||
| SO44544_14 | E01E-42FD-93 | PO3799116414 | 100 | 282 | 223 | 312 | 4 | 2022-02-23 | 15.56 | 0.39 | 2022-02-11 | 3 | 5.71 | 1 | 15.56 | 14 | SO44544 | 2022-02-18 | 1.24 | 17.12 | 5.19 | |||
| SO51845_3 | 6AB8-4CEA-A9 | PO3799111961 | 100 | 282 | 587 | 312 | 4 | 2023-11-23 | 1385.08 | 34.63 | 2023-11-11 | 3 | 419.78 | 1 | 1385.08 | 3 | SO51845 | 2023-11-18 | 110.81 | 1259.34 | 461.69 | |||
| SO46355_4 | D579-4B15-AB | PO261195016 | 100 | 283 | 328 | 647 | 4 | 2022-09-23 | 1677.84 | 41.95 | 2022-09-11 | 4 | 413.15 | 1 | 1677.84 | 4 | SO46355 | 2022-09-18 | 134.23 | 1652.59 | 419.46 | |||
| SO46049_34 | 2C79-41BD-8A | PO15689114654 | 100 | 283 | 215 | 328 | 4 | 2022-08-23 | 80.75 | 2.02 | 2022-08-11 | 4 | 12.03 | 1 | 80.75 | 34 | SO46049 | 2022-08-18 | 6.46 | 48.11 | 20.19 | |||
| SO63288_1 | 5014-4E12-A4 | PO5655190400 | 100 | 287 | 566 | 563 | 4 | 2024-05-25 | 1336.23 | 33.41 | 2024-05-13 | 3 | 461.44 | 1 | 1336.23 | 1 | SO63288 | 2024-05-20 | 106.90 | 1384.33 | 445.41 | |||
| SO48740_13 | 158B-4BBF-9F | PO551143768 | 100 | 281 | 381 | 4 | 4 | 2023-04-25 | 600.26 | 15.01 | 2023-04-13 | 1 | 605.65 | 1 | 600.26 | 13 | SO48740 | 2023-04-20 | 48.02 | 605.65 | 600.26 | |||
| SO49532_17 | 25FB-49B5-A0 | PO5539144637 | 100 | 282 | 233 | 61 | 4 | 2023-06-23 | 57.68 | 1.44 | 2023-06-11 | 2 | 29.08 | 1 | 57.68 | 17 | SO49532 | 2023-06-18 | 4.61 | 58.16 | 28.84 | |||
| SO57042_5 | 52C4-4348-BC | PO15196150289 | 100 | 282 | 408 | 258 | 4 | 2024-02-23 | 72.16 | 1.80 | 2024-02-11 | 1 | 53.40 | 1 | 72.16 | 5 | SO57042 | 2024-02-18 | 5.77 | 53.40 | 72.16 | |||
| SO47355_60 | 6B7D-4E47-B5 | PO19343125466 | 100 | 282 | 464 | 2 | 24 | 4 | 3.82 | 2022-12-24 | 191.21 | 4.68 | 2022-12-12 | 14 | 9.71 | 1 | 187.39 | 60 | SO47355 | 2022-12-19 | 14.99 | 135.99 | 13.66 | 0.02 |
| SO46380_1 | C4E3-4894-81 | PO7569183330 | 100 | 287 | 288 | 608 | 4 | 2022-09-23 | 722.59 | 18.06 | 2022-09-11 | 1 | 623.84 | 1 | 722.59 | 1 | SO46380 | 2022-09-18 | 57.81 | 623.84 | 722.59 | |||
| SO46660_23 | CF24-45E2-9D | PO5626129733 | 100 | 283 | 389 | 166 | 4 | 2022-10-23 | 3001.31 | 75.03 | 2022-10-11 | 5 | 605.65 | 1 | 3001.31 | 23 | SO46660 | 2022-10-18 | 240.11 | 3028.25 | 600.26 | |||
| SO53606_3 | 6A19-463C-B7 | PO5539128997 | 100 | 282 | 234 | 2 | 61 | 4 | 6.38 | 2023-12-24 | 318.94 | 7.81 | 2023-12-12 | 11 | 38.49 | 1 | 312.56 | 3 | SO53606 | 2023-12-19 | 25.00 | 423.42 | 28.99 | 0.02 |
| SO50672_5 | 1BE9-437C-8A | PO16472110144 | 100 | 287 | 460 | 239 | 4 | 2023-09-23 | 269.97 | 6.75 | 2023-09-11 | 5 | 37.12 | 1 | 269.97 | 5 | SO50672 | 2023-09-18 | 21.60 | 185.60 | 53.99 | |||
| SO50313_26 | B452-44E9-91 | PO7656143984 | 100 | 282 | 373 | 403 | 4 | 2023-08-23 | 1308.94 | 32.72 | 2023-08-11 | 1 | 1320.68 | 1 | 1308.94 | 26 | SO50313 | 2023-08-18 | 104.72 | 1320.68 | 1308.94 | |||
| SO51090_17 | EBDE-4A71-8E | PO13688110947 | 100 | 282 | 557 | 475 | 4 | 2023-10-23 | 615.58 | 15.39 | 2023-10-11 | 4 | 113.88 | 1 | 615.58 | 17 | SO51090 | 2023-10-18 | 49.25 | 455.53 | 153.89 | |||
| SO57029_2 | F624-4906-AF | PO16762128411 | 100 | 282 | 545 | 259 | 4 | 2024-02-23 | 24.29 | 0.61 | 2024-02-11 | 1 | 17.98 | 1 | 24.29 | 2 | SO57029 | 2024-02-18 | 1.94 | 17.98 | 24.29 | |||
| SO45555_18 | B11A-41CE-84 | PO3248155143 | 100 | 282 | 348 | 366 | 4 | 2022-06-23 | 4049.99 | 101.25 | 2022-06-11 | 2 | 1898.09 | 1 | 4049.99 | 18 | SO45555 | 2022-06-18 | 324.00 | 3796.19 | 2024.99 | |||
| SO48370_19 | 2BBA-46FF-BD | PO4640118571 | 100 | 287 | 410 | 648 | 4 | 2023-03-25 | 72.89 | 1.82 | 2023-03-13 | 2 | 26.97 | 1 | 72.89 | 19 | SO48370 | 2023-03-20 | 5.83 | 53.94 | 36.45 | |||
| SO46648_28 | 2073-4051-9E | PO2494191557 | 100 | 283 | 297 | 184 | 4 | 2022-10-23 | 3680.73 | 92.02 | 2022-10-11 | 5 | 653.70 | 1 | 3680.73 | 28 | SO46648 | 2022-10-18 | 294.46 | 3268.49 | 736.15 | |||
| SO49533_21 | 5895-4BD4-A3 | PO5597155395 | 100 | 281 | 397 | 75 | 4 | 2023-06-23 | 72.88 | 1.82 | 2023-06-11 | 3 | 17.98 | 1 | 72.88 | 21 | SO49533 | 2023-06-18 | 5.83 | 53.93 | 24.29 | |||
| SO55265_6 | D45F-41FE-9B | PO10237157039 | 100 | 287 | 482 | 4 | 41 | 4 | 12.14 | 2024-01-23 | 121.37 | 2.73 | 2024-01-11 | 27 | 3.36 | 1 | 109.23 | 6 | SO55265 | 2024-01-18 | 8.74 | 90.78 | 4.50 | 0.10 |
| SO69528_32 | 2644-4747-86 | PO6438163496 | 100 | 272 | 217 | 309 | 4 | 2024-08-23 | 104.97 | 2.62 | 2024-08-11 | 5 | 13.09 | 1 | 104.97 | 32 | SO69528 | 2024-08-18 | 8.40 | 65.43 | 20.99 | |||
| SO51131_11 | D489-4DF3-A2 | PO16298169856 | 100 | 287 | 467 | 599 | 4 | 2023-10-23 | 44.08 | 1.10 | 2023-10-11 | 3 | 9.16 | 1 | 44.08 | 11 | SO51131 | 2023-10-18 | 3.53 | 27.48 | 14.69 | |||
| SO47700_2 | 5C46-42DE-AD | PO2494132198 | 100 | 283 | 448 | 184 | 4 | 2023-01-23 | 59.97 | 1.50 | 2023-01-11 | 5 | 8.25 | 1 | 59.97 | 2 | SO47700 | 2023-01-18 | 4.80 | 41.23 | 11.99 | |||
| SO58995_22 | DA16-4097-96 | PO16269190750 | 100 | 287 | 584 | 624 | 4 | 2024-03-24 | 323.99 | 8.10 | 2024-03-12 | 1 | 343.65 | 1 | 323.99 | 22 | SO58995 | 2024-03-19 | 25.92 | 343.65 | 323.99 | |||
| SO63285_7 | 6316-44BB-8E | PO3480176259 | 100 | 281 | 604 | 436 | 4 | 2024-05-25 | 971.98 | 24.30 | 2024-05-13 | 3 | 343.65 | 1 | 971.98 | 7 | SO63285 | 2024-05-20 | 77.76 | 1030.95 | 323.99 | |||
| SO47441_2 | 2582-4E47-98 | PO7569166535 | 100 | 287 | 364 | 608 | 4 | 2022-12-24 | 3239.97 | 81.00 | 2022-12-12 | 5 | 598.44 | 1 | 3239.97 | 2 | SO47441 | 2022-12-19 | 259.20 | 2992.18 | 647.99 | |||
| SO44777_4 | CCD0-4777-A4 | PO3248124126 | 100 | 282 | 348 | 366 | 4 | 2022-03-25 | 16199.95 | 405.00 | 2022-03-13 | 8 | 1898.09 | 1 | 16199.95 | 4 | SO44777 | 2022-03-20 | 1296.00 | 15184.76 | 2024.99 | |||
| SO48758_40 | 709A-4AE0-B1 | PO13688180139 | 100 | 282 | 448 | 475 | 4 | 2023-04-25 | 59.97 | 1.50 | 2023-04-13 | 5 | 8.25 | 1 | 59.97 | 40 | SO48758 | 2023-04-20 | 4.80 | 41.23 | 11.99 | |||
| SO71845_26 | 4781-4673-85 | PO2697119362 | 100 | 282 | 359 | 187 | 4 | 2024-09-23 | 2753.99 | 68.85 | 2024-09-11 | 2 | 1251.98 | 1 | 2753.99 | 26 | SO71845 | 2024-09-18 | 220.32 | 2503.96 | 1376.99 | |||
| SO48066_10 | F00E-4B06-9D | PO5684167807 | 100 | 282 | 354 | 385 | 4 | 2023-02-23 | 3728.56 | 93.21 | 2023-02-11 | 3 | 1117.86 | 1 | 3728.56 | 10 | SO48066 | 2023-02-18 | 298.28 | 3353.57 | 1242.85 | |||
| SO46049_2 | 2C79-41BD-8A | PO15689114654 | 100 | 283 | 334 | 328 | 4 | 2022-08-23 | 1677.84 | 41.95 | 2022-08-11 | 4 | 413.15 | 1 | 1677.84 | 2 | SO46049 | 2022-08-18 | 134.23 | 1652.59 | 419.46 | |||
| SO65209_7 | B869-4DFD-AB | PO2697179473 | 100 | 282 | 516 | 187 | 4 | 2024-06-23 | 23.48 | 0.59 | 2024-06-11 | 1 | 17.38 | 1 | 23.48 | 7 | SO65209 | 2024-06-18 | 1.88 | 17.38 | 23.48 | |||
| SO50208_1 | 6993-49B4-8B | PO15689114248 | 100 | 281 | 331 | 328 | 4 | 2023-08-23 | 1409.38 | 35.23 | 2023-08-11 | 3 | 486.71 | 1 | 1409.38 | 1 | SO50208 | 2023-08-18 | 112.75 | 1460.12 | 469.79 | |||
| SO69441_20 | F156-4EE0-B0 | PO11745165450 | 100 | 282 | 482 | 97 | 4 | 2024-08-23 | 16.18 | 0.40 | 2024-08-11 | 3 | 3.36 | 1 | 16.18 | 20 | SO69441 | 2024-08-18 | 1.29 | 10.09 | 5.39 | |||
| SO51825_2 | E395-4F72-84 | PO6525184188 | 100 | 281 | 515 | 345 | 4 | 2023-11-23 | 16.27 | 0.41 | 2023-11-11 | 1 | 12.04 | 1 | 16.27 | 2 | SO51825 | 2023-11-18 | 1.30 | 12.04 | 16.27 |
Generated 2024-11-10 08:51:19.320 UTC