[ROOT] dt FactResellerSale < WHERE DimSalesTerritoryId EQ '4' > SHUFFLE < SKIP 2588 > < 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 |
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
| SO63251_11 | CA03-47EE-90 | PO6525146360 | 100 | 281 | 512 | 345 | 4 | 2024-05-29 | 655.36 | 16.38 | 2024-05-17 | 3 | 199.38 | 1 | 655.36 | 11 | SO63251 | 2024-05-24 | 52.43 | 598.13 | 218.45 | |||
| SO45516_2 | 3473-43AB-AE | PO261128364 | 100 | 283 | 332 | 647 | 4 | 2022-06-27 | 419.46 | 10.49 | 2022-06-15 | 1 | 413.15 | 1 | 419.46 | 2 | SO45516 | 2022-06-22 | 33.56 | 413.15 | 419.46 | |||
| SO50748_31 | 5FBE-4B52-B2 | PO6786143310 | 100 | 281 | 383 | 3 | 4 | 2023-09-27 | 600.26 | 15.01 | 2023-09-15 | 1 | 605.65 | 1 | 600.26 | 31 | SO50748 | 2023-09-22 | 48.02 | 605.65 | 600.26 | |||
| SO47417_27 | 1CE8-4651-A9 | PO2697165938 | 100 | 282 | 470 | 187 | 4 | 2022-12-28 | 91.18 | 2.28 | 2022-12-16 | 4 | 15.67 | 1 | 91.18 | 27 | SO47417 | 2022-12-23 | 7.29 | 62.68 | 22.79 | |||
| SO48069_2 | 60CF-43B6-82 | PO6438117188 | 100 | 283 | 356 | 309 | 4 | 2023-02-27 | 3728.56 | 93.21 | 2023-02-15 | 3 | 1117.86 | 1 | 3728.56 | 2 | SO48069 | 2023-02-22 | 298.28 | 3353.57 | 1242.85 | |||
| SO46049_11 | 2C79-41BD-8A | PO15689114654 | 100 | 283 | 342 | 328 | 4 | 2022-08-27 | 419.46 | 10.49 | 2022-08-15 | 1 | 413.15 | 1 | 419.46 | 11 | SO46049 | 2022-08-22 | 33.56 | 413.15 | 419.46 | |||
| SO50663_13 | 286E-4915-89 | PO19343130555 | 100 | 282 | 239 | 24 | 4 | 2023-09-27 | 2342.45 | 58.56 | 2023-09-15 | 3 | 722.26 | 1 | 2342.45 | 13 | SO50663 | 2023-09-22 | 187.40 | 2166.77 | 780.82 | |||
| SO47677_18 | 2C43-407F-B3 | PO13688179339 | 100 | 282 | 366 | 475 | 4 | 2023-01-27 | 1943.98 | 48.60 | 2023-01-15 | 3 | 598.44 | 1 | 1943.98 | 18 | SO47677 | 2023-01-22 | 155.52 | 1795.31 | 647.99 | |||
| SO47056_34 | 53BF-4950-9E | PO7656118289 | 100 | 282 | 368 | 403 | 4 | 2022-11-27 | 2932.02 | 73.30 | 2022-11-15 | 2 | 1518.79 | 1 | 2932.02 | 34 | SO47056 | 2022-11-22 | 234.56 | 3037.57 | 1466.01 | |||
| SO61193_17 | DFEB-4C0D-88 | PO551160749 | 100 | 281 | 606 | 4 | 4 | 2024-04-28 | 971.98 | 24.30 | 2024-04-16 | 3 | 343.65 | 1 | 971.98 | 17 | SO61193 | 2024-04-23 | 77.76 | 1030.95 | 323.99 | |||
| SO47689_2 | 8154-4308-AB | PO10730160354 | 100 | 287 | 464 | 491 | 4 | 2023-01-27 | 14.13 | 0.35 | 2023-01-15 | 1 | 9.71 | 1 | 14.13 | 2 | SO47689 | 2023-01-22 | 1.13 | 9.71 | 14.13 | |||
| SO63283_34 | 5DCA-44B0-BB | PO3799140598 | 100 | 282 | 471 | 312 | 4 | 2024-05-29 | 76.20 | 1.91 | 2024-05-17 | 2 | 23.75 | 1 | 76.20 | 34 | SO63283 | 2024-05-24 | 6.10 | 47.50 | 38.10 | |||
| SO55247_1 | 5120-4FF2-97 | PO13833112210 | 100 | 287 | 564 | 95 | 4 | 2024-01-27 | 1430.44 | 35.76 | 2024-01-15 | 1 | 1481.94 | 1 | 1430.44 | 1 | SO55247 | 2024-01-22 | 114.44 | 1481.94 | 1430.44 | |||
| SO45810_10 | 2A16-4AA7-89 | PO5626186069 | 100 | 283 | 340 | 166 | 4 | 2022-07-28 | 419.46 | 10.49 | 2022-07-16 | 1 | 413.15 | 1 | 419.46 | 10 | SO45810 | 2022-07-23 | 33.56 | 413.15 | 419.46 | |||
| SO44756_3 | 7857-4221-BA | PO15138192148 | 100 | 283 | 235 | 93 | 4 | 2022-03-29 | 28.84 | 0.72 | 2022-03-17 | 1 | 31.72 | 1 | 28.84 | 3 | SO44756 | 2022-03-24 | 2.31 | 31.72 | 28.84 | |||
| SO47032_1 | 090F-4070-AA | PO4553172367 | 100 | 282 | 422 | 313 | 4 | 2022-11-27 | 270.16 | 6.75 | 2022-11-15 | 4 | 49.98 | 1 | 270.16 | 1 | SO47032 | 2022-11-22 | 21.61 | 199.92 | 67.54 | |||
| SO49472_6 | 653C-45A9-B1 | PO2697138792 | 100 | 282 | 420 | 187 | 4 | 2023-06-27 | 283.23 | 7.08 | 2023-06-15 | 2 | 104.80 | 1 | 283.23 | 6 | SO49472 | 2023-06-22 | 22.66 | 209.59 | 141.62 | |||
| SO61184_8 | F33C-4C57-BD | PO16298116527 | 100 | 287 | 496 | 599 | 4 | 2024-04-28 | 1807.04 | 45.18 | 2024-04-16 | 3 | 601.74 | 1 | 1807.04 | 8 | SO61184 | 2024-04-23 | 144.56 | 1805.23 | 602.35 | |||
| SO55322_32 | D600-436A-B7 | PO7859118281 | 100 | 287 | 481 | 221 | 4 | 2024-01-27 | 21.58 | 0.54 | 2024-01-15 | 4 | 3.36 | 1 | 21.58 | 32 | SO55322 | 2024-01-22 | 1.73 | 13.45 | 5.39 | |||
| SO44317_9 | BE9B-42BA-87 | PO7859142280 | 100 | 287 | 322 | 221 | 4 | 2022-01-27 | 3355.67 | 83.89 | 2022-01-15 | 8 | 413.15 | 1 | 3355.67 | 9 | SO44317 | 2022-01-22 | 268.45 | 3305.17 | 419.46 | |||
| SO46668_48 | 6711-47BE-BF | PO7859142972 | 100 | 287 | 464 | 221 | 4 | 2022-10-27 | 70.64 | 1.77 | 2022-10-15 | 5 | 9.71 | 1 | 70.64 | 48 | SO46668 | 2022-10-22 | 5.65 | 48.57 | 14.13 | |||
| SO71858_6 | 32BA-49C8-8B | PO16153112278 | 100 | 282 | 564 | 186 | 4 | 2024-09-27 | 1430.44 | 35.76 | 2024-09-15 | 1 | 1481.94 | 1 | 1430.44 | 6 | SO71858 | 2024-09-22 | 114.44 | 1481.94 | 1430.44 | |||
| SO57034_4 | 57D0-46D3-B7 | PO15689142548 | 100 | 281 | 605 | 328 | 4 | 2024-02-27 | 323.99 | 8.10 | 2024-02-15 | 1 | 343.65 | 1 | 323.99 | 4 | SO57034 | 2024-02-22 | 25.92 | 343.65 | 323.99 | |||
| SO48080_26 | 4DC7-4772-87 | PO7656157590 | 100 | 282 | 373 | 403 | 4 | 2023-02-27 | 1308.94 | 32.72 | 2023-02-15 | 1 | 1320.68 | 1 | 1308.94 | 26 | SO48080 | 2023-02-22 | 104.72 | 1320.68 | 1308.94 | |||
| SO49841_23 | 35A1-40DC-99 | PO10817181706 | 100 | 287 | 433 | 203 | 4 | 2023-07-28 | 648.91 | 16.22 | 2023-07-16 | 2 | 300.12 | 1 | 648.91 | 23 | SO49841 | 2023-07-23 | 51.91 | 600.24 | 324.45 | |||
| SO57142_5 | C2D8-45D0-B5 | PO4553190603 | 100 | 282 | 471 | 313 | 4 | 2024-02-27 | 76.20 | 1.91 | 2024-02-15 | 2 | 23.75 | 1 | 76.20 | 5 | SO57142 | 2024-02-22 | 6.10 | 47.50 | 38.10 | |||
| SO44120_12 | E001-437D-A1 | PO5597155510 | 100 | 283 | 223 | 75 | 4 | 2021-12-28 | 15.56 | 0.39 | 2021-12-16 | 3 | 5.71 | 1 | 15.56 | 12 | SO44120 | 2021-12-23 | 1.24 | 17.12 | 5.19 | |||
| SO63262_8 | 3368-4317-8F | PO6351144702 | 100 | 281 | 388 | 255 | 4 | 2024-05-29 | 1344.59 | 33.61 | 2024-05-17 | 2 | 713.08 | 1 | 1344.59 | 8 | SO63262 | 2024-05-24 | 107.57 | 1426.16 | 672.29 | |||
| SO71882_12 | D5D4-42D4-91 | PO5597123008 | 100 | 281 | 355 | 75 | 4 | 2024-09-27 | 2783.99 | 69.60 | 2024-09-15 | 2 | 1265.62 | 1 | 2783.99 | 12 | SO71882 | 2024-09-22 | 222.72 | 2531.24 | 1391.99 | |||
| SO43692_24 | BFA9-470E-B4 | PO7859187017 | 100 | 287 | 220 | 221 | 4 | 2021-10-27 | 60.56 | 1.51 | 2021-10-15 | 3 | 12.03 | 1 | 60.56 | 24 | SO43692 | 2021-10-22 | 4.84 | 36.08 | 20.19 | |||
| SO48080_1 | 4DC7-4772-87 | PO7656157590 | 100 | 282 | 379 | 403 | 4 | 2023-02-27 | 3926.81 | 98.17 | 2023-02-15 | 3 | 1320.68 | 1 | 3926.81 | 1 | SO48080 | 2023-02-22 | 314.15 | 3962.05 | 1308.94 | |||
| SO51827_10 | B106-4221-AD | PO4611117026 | 100 | 287 | 573 | 131 | 4 | 2023-11-27 | 2860.88 | 71.52 | 2023-11-15 | 2 | 1481.94 | 1 | 2860.88 | 10 | SO51827 | 2023-11-22 | 228.87 | 2963.88 | 1430.44 | |||
| SO50672_12 | 1BE9-437C-8A | PO16472110144 | 100 | 287 | 462 | 239 | 4 | 2023-09-27 | 56.52 | 1.41 | 2023-09-15 | 4 | 9.71 | 1 | 56.52 | 12 | SO50672 | 2023-09-22 | 4.52 | 38.85 | 14.13 | |||
| SO50663_47 | 286E-4915-89 | PO19343130555 | 100 | 282 | 389 | 24 | 4 | 2023-09-27 | 2401.05 | 60.03 | 2023-09-15 | 4 | 605.65 | 1 | 2401.05 | 47 | SO50663 | 2023-09-22 | 192.08 | 2422.60 | 600.26 | |||
| SO57131_11 | 635E-4BF2-B9 | PO4611148036 | 100 | 287 | 561 | 131 | 4 | 2024-02-27 | 1430.44 | 35.76 | 2024-02-15 | 1 | 1481.94 | 1 | 1430.44 | 11 | SO57131 | 2024-02-22 | 114.44 | 1481.94 | 1430.44 | |||
| SO47035_2 | 661B-492D-B3 | PO4698148803 | 100 | 282 | 325 | 528 | 4 | 2022-11-27 | 1879.18 | 46.98 | 2022-11-15 | 4 | 486.71 | 1 | 1879.18 | 2 | SO47035 | 2022-11-22 | 150.33 | 1946.83 | 469.79 | |||
| SO69528_8 | 2644-4747-86 | PO6438163496 | 100 | 272 | 491 | 309 | 4 | 2024-08-27 | 97.18 | 2.43 | 2024-08-15 | 3 | 41.57 | 1 | 97.18 | 8 | SO69528 | 2024-08-22 | 7.77 | 124.72 | 32.39 | |||
| SO65269_2 | 999D-45C9-AA | PO4640162431 | 100 | 287 | 596 | 648 | 4 | 2024-06-27 | 323.99 | 8.10 | 2024-06-15 | 1 | 294.58 | 1 | 323.99 | 2 | SO65269 | 2024-06-22 | 25.92 | 294.58 | 323.99 | |||
| SO53531_25 | B1FB-47B2-8E | PO2697181370 | 100 | 282 | 474 | 187 | 4 | 2023-12-28 | 125.98 | 3.15 | 2023-12-16 | 3 | 26.18 | 1 | 125.98 | 25 | SO53531 | 2023-12-23 | 10.08 | 78.53 | 41.99 | |||
| SO47427_9 | 61AA-44CA-99 | PO4640137176 | 100 | 287 | 410 | 648 | 4 | 2022-12-28 | 72.89 | 1.82 | 2022-12-16 | 2 | 26.97 | 1 | 72.89 | 9 | SO47427 | 2022-12-23 | 5.83 | 53.94 | 36.45 | |||
| SO49533_5 | 5895-4BD4-A3 | PO5597155395 | 100 | 281 | 305 | 75 | 4 | 2023-06-27 | 736.15 | 18.40 | 2023-06-15 | 1 | 653.70 | 1 | 736.15 | 5 | SO49533 | 2023-06-22 | 58.89 | 653.70 | 736.15 | |||
| SO49481_9 | 474A-4DD1-9B | PO10701112208 | 100 | 282 | 224 | 133 | 4 | 2023-06-27 | 25.93 | 0.65 | 2023-06-15 | 5 | 5.23 | 1 | 25.93 | 9 | SO49481 | 2023-06-22 | 2.07 | 26.15 | 5.19 | |||
| SO46988_4 | 2D2E-4EC3-AC | PO12499171502 | 100 | 282 | 453 | 78 | 4 | 2022-11-27 | 251.96 | 6.30 | 2022-11-15 | 7 | 24.75 | 1 | 251.96 | 4 | SO46988 | 2022-11-22 | 20.16 | 173.22 | 35.99 | |||
| SO49831_35 | 8BCC-466B-AB | PO13688123267 | 100 | 282 | 397 | 475 | 4 | 2023-07-28 | 48.59 | 1.21 | 2023-07-16 | 2 | 17.98 | 1 | 48.59 | 35 | SO49831 | 2023-07-23 | 3.89 | 35.96 | 24.29 | |||
| SO47658_16 | C574-484B-83 | PO551177057 | 100 | 283 | 387 | 4 | 4 | 2023-01-27 | 1200.53 | 30.01 | 2023-01-15 | 2 | 605.65 | 1 | 1200.53 | 16 | SO47658 | 2023-01-22 | 96.04 | 1211.30 | 600.26 | |||
| SO43680_10 | FF1F-4DD0-98 | PO10730130087 | 100 | 287 | 324 | 491 | 4 | 2021-10-27 | 419.46 | 10.49 | 2021-10-15 | 1 | 413.15 | 1 | 419.46 | 10 | SO43680 | 2021-10-22 | 33.56 | 413.15 | 419.46 | |||
| SO53496_8 | 5404-4BB1-95 | PO12992153220 | 100 | 282 | 586 | 13 | 295 | 4 | 50.11 | 2023-12-28 | 334.06 | 7.10 | 2023-12-16 | 1 | 461.44 | 1 | 283.95 | 8 | SO53496 | 2023-12-23 | 22.72 | 461.44 | 334.06 | 0.15 |
| SO65277_5 | B368-4131-A5 | PO3973124151 | 100 | 281 | 560 | 201 | 4 | 2024-06-27 | 728.91 | 18.22 | 2024-06-15 | 1 | 755.15 | 1 | 728.91 | 5 | SO65277 | 2024-06-22 | 58.31 | 755.15 | 728.91 | |||
| SO48758_9 | 709A-4AE0-B1 | PO13688180139 | 100 | 282 | 447 | 475 | 4 | 2023-04-29 | 45.00 | 1.13 | 2023-04-17 | 3 | 10.31 | 1 | 45.00 | 9 | SO48758 | 2023-04-24 | 3.60 | 30.94 | 15.00 | |||
| SO51844_17 | DE76-4481-AA | PO4553182082 | 100 | 282 | 487 | 313 | 4 | 2023-11-27 | 65.99 | 1.65 | 2023-11-15 | 2 | 20.57 | 1 | 65.99 | 17 | SO51844 | 2023-11-22 | 5.28 | 41.13 | 32.99 | |||
| SO50208_16 | 6993-49B4-8B | PO15689114248 | 100 | 281 | 385 | 328 | 4 | 2023-08-27 | 1200.53 | 30.01 | 2023-08-15 | 2 | 605.65 | 1 | 1200.53 | 16 | SO50208 | 2023-08-22 | 96.04 | 1211.30 | 600.26 | |||
| SO45341_5 | AA2C-4A41-AD | PO7830178569 | 100 | 283 | 349 | 40 | 4 | 2022-05-30 | 4049.99 | 101.25 | 2022-05-18 | 2 | 1898.09 | 1 | 4049.99 | 5 | SO45341 | 2022-05-25 | 324.00 | 3796.19 | 2024.99 | |||
| SO48378_37 | 2FD7-4721-9D | PO6786131738 | 100 | 283 | 389 | 3 | 4 | 2023-03-29 | 2401.05 | 60.03 | 2023-03-17 | 4 | 605.65 | 1 | 2401.05 | 37 | SO48378 | 2023-03-24 | 192.08 | 2422.60 | 600.26 | |||
| SO58982_9 | EEA8-4A3B-AF | PO18125159249 | 100 | 287 | 545 | 311 | 4 | 2024-03-28 | 24.29 | 0.61 | 2024-03-16 | 1 | 17.98 | 1 | 24.29 | 9 | SO58982 | 2024-03-23 | 1.94 | 17.98 | 24.29 | |||
| SO53470_8 | 932B-41E0-AF | PO17052111209 | 100 | 282 | 579 | 420 | 4 | 2023-12-28 | 2915.64 | 72.89 | 2023-12-16 | 4 | 755.15 | 1 | 2915.64 | 8 | SO53470 | 2023-12-23 | 233.25 | 3020.60 | 728.91 | |||
| SO48356_1 | 3E64-467F-90 | PO2697152207 | 100 | 282 | 395 | 187 | 4 | 2023-03-29 | 490.99 | 12.27 | 2023-03-17 | 8 | 45.42 | 1 | 490.99 | 1 | SO48356 | 2023-03-24 | 39.28 | 363.33 | 61.37 | |||
| SO55303_18 | 5C9C-4B35-B8 | PO5626137276 | 100 | 281 | 481 | 166 | 4 | 2024-01-27 | 16.18 | 0.40 | 2024-01-15 | 3 | 3.36 | 1 | 16.18 | 18 | SO55303 | 2024-01-22 | 1.29 | 10.09 | 5.39 | |||
| SO59017_1 | 1571-4C89-99 | PO4582165909 | 100 | 282 | 513 | 25 | 4 | 2024-03-28 | 218.45 | 5.46 | 2024-03-16 | 1 | 199.38 | 1 | 218.45 | 1 | SO59017 | 2024-03-23 | 17.48 | 199.38 | 218.45 | |||
| SO65310_25 | 65CB-474A-9D | PO6786169596 | 100 | 281 | 465 | 3 | 4 | 2024-06-27 | 29.39 | 0.73 | 2024-06-15 | 2 | 9.16 | 1 | 29.39 | 25 | SO65310 | 2024-06-22 | 2.35 | 18.32 | 14.69 | |||
| SO50289_41 | 0809-4DE4-93 | PO3480117331 | 100 | 281 | 333 | 436 | 4 | 2023-08-27 | 1879.18 | 46.98 | 2023-08-15 | 4 | 486.71 | 1 | 1879.18 | 41 | SO50289 | 2023-08-22 | 150.33 | 1946.83 | 469.79 |
Generated 2024-11-14 16:59:47.355 UTC