[ROOT] dt FactResellerSale < WHERE DimSalesTerritoryId EQ '4' > SHUFFLE < SKIP 2874 > < TAKE 62 >
62 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 |
---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
SO43912_10 | 69B6-46F8-A4 | PO7656175368 | 100 | 282 | 270 | 403 | 4 | 2021-11-22 | 183.94 | 4.60 | 2021-11-10 | 1 | 181.49 | 1 | 183.94 | 10 | SO43912 | 2021-11-17 | 14.72 | 181.49 | 183.94 | |||
SO71882_3 | D5D4-42D4-91 | PO5597123008 | 100 | 281 | 603 | 75 | 4 | 2024-09-22 | 145.79 | 3.64 | 2024-09-10 | 2 | 53.94 | 1 | 145.79 | 3 | SO71882 | 2024-09-17 | 11.66 | 107.88 | 72.89 | |||
SO49540_2 | FD60-4F29-B7 | PO6757123714 | 100 | 281 | 360 | 21 | 4 | 2023-06-22 | 2458.92 | 61.47 | 2023-06-10 | 2 | 1105.81 | 1 | 2458.92 | 2 | SO49540 | 2023-06-17 | 196.71 | 2211.62 | 1229.46 | |||
SO51833_23 | 67A5-4BBC-8F | PO5684113634 | 100 | 282 | 525 | 385 | 4 | 2023-11-22 | 316.86 | 7.92 | 2023-11-10 | 2 | 144.59 | 1 | 316.86 | 23 | SO51833 | 2023-11-17 | 25.35 | 289.19 | 158.43 | |||
SO46083_9 | 9B96-4D38-AE | PO3857186802 | 100 | 283 | 322 | 256 | 4 | 2022-08-22 | 1258.38 | 31.46 | 2022-08-10 | 3 | 413.15 | 1 | 1258.38 | 9 | SO46083 | 2022-08-17 | 100.67 | 1239.44 | 419.46 | |||
SO47990_46 | 7D80-4D9E-9A | PO15689162700 | 100 | 283 | 435 | 328 | 4 | 2023-02-22 | 1946.72 | 48.67 | 2023-02-10 | 6 | 300.12 | 1 | 1946.72 | 46 | SO47990 | 2023-02-17 | 155.74 | 1800.71 | 324.45 | |||
SO61184_28 | F33C-4C57-BD | PO16298116527 | 100 | 287 | 231 | 599 | 4 | 2024-04-23 | 119.98 | 3.00 | 2024-04-11 | 4 | 38.49 | 1 | 119.98 | 28 | SO61184 | 2024-04-18 | 9.60 | 153.97 | 29.99 | |||
SO51833_10 | 67A5-4BBC-8F | PO5684113634 | 100 | 282 | 513 | 385 | 4 | 2023-11-22 | 436.91 | 10.92 | 2023-11-10 | 2 | 199.38 | 1 | 436.91 | 10 | SO51833 | 2023-11-17 | 34.95 | 398.75 | 218.45 | |||
SO51131_48 | D489-4DF3-A2 | PO16298169856 | 100 | 287 | 495 | 599 | 4 | 2023-10-22 | 1807.04 | 45.18 | 2023-10-10 | 3 | 601.74 | 1 | 1807.04 | 48 | SO51131 | 2023-10-17 | 144.56 | 1805.23 | 602.35 | |||
SO46970_28 | 01AF-420A-B9 | PO15196114472 | 100 | 282 | 273 | 258 | 4 | 2022-11-22 | 607.00 | 15.17 | 2022-11-10 | 3 | 187.16 | 1 | 607.00 | 28 | SO46970 | 2022-11-17 | 48.56 | 561.47 | 202.33 | |||
SO47056_8 | 53BF-4950-9E | PO7656118289 | 100 | 282 | 403 | 403 | 4 | 2022-11-22 | 48.59 | 1.21 | 2022-11-10 | 2 | 17.98 | 1 | 48.59 | 8 | SO47056 | 2022-11-17 | 3.89 | 35.96 | 24.29 | |||
SO47425_5 | E539-44F6-AA | PO4002163465 | 100 | 282 | 323 | 674 | 4 | 2022-12-23 | 2348.97 | 58.72 | 2022-12-11 | 5 | 486.71 | 1 | 2348.97 | 5 | SO47425 | 2022-12-18 | 187.92 | 2433.53 | 469.79 | |||
SO50688_21 | C55C-41B0-92 | PO10701178438 | 100 | 282 | 354 | 133 | 4 | 2023-09-22 | 1242.85 | 31.07 | 2023-09-10 | 1 | 1117.86 | 1 | 1242.85 | 21 | SO50688 | 2023-09-17 | 99.43 | 1117.86 | 1242.85 | |||
SO53531_10 | B1FB-47B2-8E | PO2697181370 | 100 | 282 | 475 | 187 | 4 | 2023-12-23 | 83.99 | 2.10 | 2023-12-11 | 2 | 26.18 | 1 | 83.99 | 10 | SO53531 | 2023-12-18 | 6.72 | 52.35 | 41.99 | |||
SO47422_4 | 9D8D-4481-B6 | PO3915123127 | 100 | 283 | 454 | 130 | 4 | 2022-12-23 | 143.98 | 3.60 | 2022-12-11 | 4 | 24.75 | 1 | 143.98 | 4 | SO47422 | 2022-12-18 | 11.52 | 98.98 | 35.99 | |||
SO45798_24 | 3FA4-4459-BD | PO10817199969 | 100 | 287 | 311 | 203 | 4 | 2022-07-23 | 4293.92 | 107.35 | 2022-07-11 | 2 | 2171.29 | 1 | 4293.92 | 24 | SO45798 | 2022-07-18 | 343.51 | 4342.59 | 2146.96 | |||
SO48380_2 | 580B-4A1F-A4 | PO6757155119 | 100 | 283 | 297 | 21 | 4 | 2023-03-24 | 736.15 | 18.40 | 2023-03-12 | 1 | 653.70 | 1 | 736.15 | 2 | SO48380 | 2023-03-19 | 58.89 | 653.70 | 736.15 | |||
SO46094_8 | 6C13-4966-95 | PO6438128598 | 100 | 283 | 212 | 309 | 4 | 2022-08-22 | 100.93 | 2.52 | 2022-08-10 | 5 | 12.03 | 1 | 100.93 | 8 | SO46094 | 2022-08-17 | 8.07 | 60.14 | 20.19 | |||
SO65269_21 | 999D-45C9-AA | PO4640162431 | 100 | 287 | 355 | 648 | 4 | 2024-06-22 | 2783.99 | 69.60 | 2024-06-10 | 2 | 1265.62 | 1 | 2783.99 | 21 | SO65269 | 2024-06-17 | 222.72 | 2531.24 | 1391.99 | |||
SO45339_15 | 1F94-40D0-86 | PO7656113434 | 100 | 282 | 316 | 403 | 4 | 2022-05-25 | 4373.97 | 109.35 | 2022-05-13 | 5 | 884.71 | 1 | 4373.97 | 15 | SO45339 | 2022-05-20 | 349.92 | 4423.54 | 874.79 | |||
SO46049_22 | 2C79-41BD-8A | PO15689114654 | 100 | 283 | 275 | 328 | 4 | 2022-08-22 | 1070.69 | 26.77 | 2022-08-10 | 3 | 352.14 | 1 | 1070.69 | 22 | SO46049 | 2022-08-17 | 85.66 | 1056.42 | 356.90 | |||
SO47994_24 | 284B-45A1-94 | PO15196121630 | 100 | 282 | 325 | 258 | 4 | 2023-02-22 | 469.79 | 11.74 | 2023-02-10 | 1 | 486.71 | 1 | 469.79 | 24 | SO47994 | 2023-02-17 | 37.58 | 486.71 | 469.79 | |||
SO47018_39 | E622-43B1-98 | PO2523197473 | 100 | 287 | 439 | 167 | 4 | 2022-11-22 | 6246.55 | 156.16 | 2022-11-10 | 8 | 722.26 | 1 | 6246.55 | 39 | SO47018 | 2022-11-17 | 499.72 | 5778.05 | 780.82 | |||
SO46076_2 | E898-4203-B0 | PO2523131751 | 100 | 287 | 220 | 167 | 4 | 2022-08-22 | 40.37 | 1.01 | 2022-08-10 | 2 | 12.03 | 1 | 40.37 | 2 | SO46076 | 2022-08-17 | 3.23 | 24.06 | 20.19 | |||
SO51773_39 | 14B1-48BF-A0 | PO2523163173 | 100 | 287 | 234 | 167 | 4 | 2023-11-22 | 209.96 | 5.25 | 2023-11-10 | 7 | 38.49 | 1 | 209.96 | 39 | SO51773 | 2023-11-17 | 16.80 | 269.45 | 29.99 | |||
SO53583_25 | 582E-4A53-9A | PO5597118655 | 100 | 281 | 594 | 75 | 4 | 2023-12-23 | 1355.98 | 33.90 | 2023-12-11 | 4 | 308.22 | 1 | 1355.98 | 25 | SO53583 | 2023-12-18 | 108.48 | 1232.87 | 338.99 | |||
SO67318_6 | 5460-4BEE-A6 | PO6409141464 | 100 | 281 | 545 | 292 | 4 | 2024-07-23 | 72.88 | 1.82 | 2024-07-11 | 3 | 17.98 | 1 | 72.88 | 6 | SO67318 | 2024-07-18 | 5.83 | 53.93 | 24.29 | |||
SO49831_38 | 8BCC-466B-AB | PO13688123267 | 100 | 282 | 297 | 475 | 4 | 2023-07-23 | 1472.29 | 36.81 | 2023-07-11 | 2 | 653.70 | 1 | 1472.29 | 38 | SO49831 | 2023-07-18 | 117.78 | 1307.39 | 736.15 | |||
SO48364_7 | 93FF-4A54-BA | PO3886118778 | 100 | 283 | 221 | 165 | 4 | 2023-03-24 | 20.19 | 0.50 | 2023-03-12 | 1 | 13.88 | 1 | 20.19 | 7 | SO48364 | 2023-03-19 | 1.61 | 13.88 | 20.19 | |||
SO57142_1 | C2D8-45D0-B5 | PO4553190603 | 100 | 282 | 482 | 313 | 4 | 2024-02-22 | 53.94 | 1.35 | 2024-02-10 | 10 | 3.36 | 1 | 53.94 | 1 | SO57142 | 2024-02-17 | 4.32 | 33.62 | 5.39 | |||
SO69532_9 | 27FB-4A86-85 | PO3799165791 | 100 | 282 | 596 | 312 | 4 | 2024-08-22 | 323.99 | 8.10 | 2024-08-10 | 1 | 294.58 | 1 | 323.99 | 9 | SO69532 | 2024-08-17 | 25.92 | 294.58 | 323.99 | |||
SO50208_7 | 6993-49B4-8B | PO15689114248 | 100 | 281 | 327 | 328 | 4 | 2023-08-22 | 3288.56 | 82.21 | 2023-08-10 | 7 | 486.71 | 1 | 3288.56 | 7 | SO50208 | 2023-08-17 | 263.08 | 3406.95 | 469.79 | |||
SO45533_2 | 120C-4720-9A | PO15718114961 | 100 | 283 | 326 | 580 | 4 | 2022-06-22 | 419.46 | 10.49 | 2022-06-10 | 1 | 413.15 | 1 | 419.46 | 2 | SO45533 | 2022-06-17 | 33.56 | 413.15 | 419.46 | |||
SO47018_19 | E622-43B1-98 | PO2523197473 | 100 | 287 | 341 | 167 | 4 | 2022-11-22 | 4228.15 | 105.70 | 2022-11-10 | 9 | 486.71 | 1 | 4228.15 | 19 | SO47018 | 2022-11-17 | 338.25 | 4380.36 | 469.79 | |||
SO65183_11 | 4E49-448C-93 | PO16269127603 | 100 | 287 | 386 | 624 | 4 | 2024-06-22 | 1344.59 | 33.61 | 2024-06-10 | 2 | 713.08 | 1 | 1344.59 | 11 | SO65183 | 2024-06-17 | 107.57 | 1426.16 | 672.29 | |||
SO48043_5 | BA6F-4F1F-B7 | PO2523167437 | 100 | 287 | 373 | 167 | 4 | 2023-02-22 | 6544.69 | 163.62 | 2023-02-10 | 5 | 1320.68 | 1 | 6544.69 | 5 | SO48043 | 2023-02-17 | 523.58 | 6603.42 | 1308.94 | |||
SO61188_7 | 0CFA-4338-90 | PO12528143455 | 100 | 282 | 578 | 331 | 4 | 2024-04-23 | 2915.64 | 72.89 | 2024-04-11 | 4 | 755.15 | 1 | 2915.64 | 7 | SO61188 | 2024-04-18 | 233.25 | 3020.60 | 728.91 | |||
SO50313_14 | B452-44E9-91 | PO7656143984 | 100 | 282 | 233 | 403 | 4 | 2023-08-22 | 57.68 | 1.44 | 2023-08-10 | 2 | 29.08 | 1 | 57.68 | 14 | SO50313 | 2023-08-17 | 4.61 | 58.16 | 28.84 | |||
SO57131_17 | 635E-4BF2-B9 | PO4611148036 | 100 | 287 | 565 | 131 | 4 | 2024-02-22 | 445.41 | 11.14 | 2024-02-10 | 1 | 461.44 | 1 | 445.41 | 17 | SO57131 | 2024-02-17 | 35.63 | 461.44 | 445.41 | |||
SO69515_3 | D9C1-4837-A7 | PO6351170694 | 100 | 281 | 606 | 255 | 4 | 2024-08-22 | 971.98 | 24.30 | 2024-08-10 | 3 | 343.65 | 1 | 971.98 | 3 | SO69515 | 2024-08-17 | 77.76 | 1030.95 | 323.99 | |||
SO51121_15 | 9E4C-40B6-B1 | PO10730114575 | 100 | 287 | 488 | 491 | 4 | 2023-10-22 | 64.79 | 1.62 | 2023-10-10 | 2 | 41.57 | 1 | 64.79 | 15 | SO51121 | 2023-10-17 | 5.18 | 83.14 | 32.39 | |||
SO53459_42 | 9828-4F27-B0 | PO19372154638 | 100 | 282 | 225 | 582 | 4 | 2023-12-23 | 32.36 | 0.81 | 2023-12-11 | 6 | 6.92 | 1 | 32.36 | 42 | SO53459 | 2023-12-18 | 2.59 | 41.53 | 5.39 | |||
SO57168_32 | B6D5-41ED-B9 | PO3480129742 | 100 | 281 | 477 | 436 | 4 | 2024-02-22 | 17.96 | 0.45 | 2024-02-10 | 6 | 1.87 | 1 | 17.96 | 32 | SO57168 | 2024-02-17 | 1.44 | 11.20 | 2.99 | |||
SO50294_2 | F34B-46CA-8D | PO3799186112 | 100 | 282 | 453 | 312 | 4 | 2023-08-22 | 179.97 | 4.50 | 2023-08-10 | 5 | 24.75 | 1 | 179.97 | 2 | SO50294 | 2023-08-17 | 14.40 | 123.73 | 35.99 | |||
SO46624_14 | 12A0-4CA7-93 | PO13659199342 | 100 | 287 | 412 | 437 | 4 | 2022-10-22 | 360.26 | 9.01 | 2022-10-10 | 2 | 133.30 | 1 | 360.26 | 14 | SO46624 | 2022-10-17 | 28.82 | 266.59 | 180.13 | |||
SO55285_2 | A4FF-46C9-A8 | PO18009165066 | 100 | 282 | 546 | 510 | 4 | 2024-01-22 | 74.51 | 1.86 | 2024-01-10 | 2 | 27.57 | 1 | 74.51 | 2 | SO55285 | 2024-01-17 | 5.96 | 55.14 | 37.25 | |||
SO46076_32 | E898-4203-B0 | PO2523131751 | 100 | 287 | 311 | 167 | 4 | 2022-08-22 | 6440.89 | 161.02 | 2022-08-10 | 3 | 2171.29 | 1 | 6440.89 | 32 | SO46076 | 2022-08-17 | 515.27 | 6513.88 | 2146.96 | |||
SO59023_25 | 9975-4F2A-A7 | PO5539149469 | 100 | 282 | 517 | 61 | 4 | 2024-03-23 | 126.34 | 3.16 | 2024-03-11 | 4 | 23.37 | 1 | 126.34 | 25 | SO59023 | 2024-03-18 | 10.11 | 93.49 | 31.58 | |||
SO53616_42 | A692-4827-93 | PO6786150961 | 100 | 281 | 520 | 3 | 4 | 2023-12-23 | 31.58 | 0.79 | 2023-12-11 | 1 | 23.37 | 1 | 31.58 | 42 | SO53616 | 2023-12-18 | 2.53 | 23.37 | 31.58 | |||
SO44520_17 | 5BE0-436B-8C | PO12499152870 | 100 | 282 | 276 | 78 | 4 | 2022-02-22 | 356.90 | 8.92 | 2022-02-10 | 1 | 352.14 | 1 | 356.90 | 17 | SO44520 | 2022-02-17 | 28.55 | 352.14 | 356.90 | |||
SO48056_6 | 5868-43E3-AD | PO4843164827 | 100 | 287 | 453 | 257 | 4 | 2023-02-22 | 35.99 | 0.90 | 2023-02-10 | 1 | 24.75 | 1 | 35.99 | 6 | SO48056 | 2023-02-17 | 2.88 | 24.75 | 35.99 | |||
SO59027_15 | C142-4AAA-AB | PO6757122081 | 100 | 281 | 474 | 21 | 4 | 2024-03-23 | 293.96 | 7.35 | 2024-03-11 | 7 | 26.18 | 1 | 293.96 | 15 | SO59027 | 2024-03-18 | 23.52 | 183.23 | 41.99 | |||
SO71796_1 | 9A29-45DE-BF | PO17052159664 | 100 | 282 | 498 | 420 | 4 | 2024-09-22 | 602.35 | 15.06 | 2024-09-10 | 1 | 601.74 | 1 | 602.35 | 1 | SO71796 | 2024-09-17 | 48.19 | 601.74 | 602.35 | |||
SO46638_11 | 9659-44CE-A2 | PO10817110834 | 100 | 287 | 387 | 203 | 4 | 2022-10-22 | 1200.53 | 30.01 | 2022-10-10 | 2 | 605.65 | 1 | 1200.53 | 11 | SO46638 | 2022-10-17 | 96.04 | 1211.30 | 600.26 | |||
SO48066_21 | F00E-4B06-9D | PO5684167807 | 100 | 282 | 448 | 385 | 4 | 2023-02-22 | 23.99 | 0.60 | 2023-02-10 | 2 | 8.25 | 1 | 23.99 | 21 | SO48066 | 2023-02-17 | 1.92 | 16.49 | 11.99 | |||
SO47439_22 | D4B6-4746-BE | PO6786128920 | 100 | 283 | 456 | 2 | 3 | 4 | 10.44 | 2022-12-23 | 521.93 | 12.79 | 2022-12-11 | 12 | 30.93 | 1 | 511.49 | 22 | SO47439 | 2022-12-18 | 40.92 | 371.20 | 43.49 | 0.02 |
SO50663_3 | 286E-4915-89 | PO19343130555 | 100 | 282 | 414 | 24 | 4 | 2023-09-22 | 745.16 | 18.63 | 2023-09-10 | 5 | 110.28 | 1 | 745.16 | 3 | SO50663 | 2023-09-17 | 59.61 | 551.41 | 149.03 | |||
SO46094_11 | 6C13-4966-95 | PO6438128598 | 100 | 283 | 345 | 309 | 4 | 2022-08-22 | 14279.96 | 357.00 | 2022-08-10 | 7 | 1912.15 | 1 | 14279.96 | 11 | SO46094 | 2022-08-17 | 1142.40 | 13385.08 | 2039.99 | |||
SO51131_27 | D489-4DF3-A2 | PO16298169856 | 100 | 287 | 225 | 2 | 599 | 4 | 1.46 | 2023-10-22 | 73.00 | 1.79 | 2023-10-10 | 14 | 6.92 | 1 | 71.54 | 27 | SO51131 | 2023-10-17 | 5.72 | 96.91 | 5.21 | 0.02 |
SO50688_10 | C55C-41B0-92 | PO10701178438 | 100 | 282 | 362 | 133 | 4 | 2023-09-22 | 4917.84 | 122.95 | 2023-09-10 | 4 | 1105.81 | 1 | 4917.84 | 10 | SO50688 | 2023-09-17 | 393.43 | 4423.24 | 1229.46 | |||
SO71882_25 | D5D4-42D4-91 | PO5597123008 | 100 | 281 | 559 | 75 | 4 | 2024-09-22 | 60.72 | 1.52 | 2024-09-10 | 5 | 8.99 | 1 | 60.72 | 25 | SO71882 | 2024-09-17 | 4.86 | 44.93 | 12.14 | |||
SO65160_25 | 9375-44FE-94 | PO19343172976 | 100 | 282 | 222 | 24 | 4 | 2024-06-22 | 125.96 | 3.15 | 2024-06-10 | 6 | 13.09 | 1 | 125.96 | 25 | SO65160 | 2024-06-17 | 10.08 | 78.52 | 20.99 |
Generated 2024-11-10 01:32:50.001 UTC