[ROOT] dt FactResellerSale < WHERE DimSalesTerritoryId EQ '4' > SHUFFLE SKIP 3500 SKIP 1000 < SKIP 500 > < 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 |
---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
SO71816_2 | 52D4-4F3B-9E | PO12992180445 | 100 | 282 | 561 | 295 | 4 | 2024-08-03 | 1430.44 | 35.76 | 2024-07-22 | 1 | 1481.94 | 1 | 1430.44 | 2 | SO71816 | 2024-07-29 | 114.44 | 1481.94 | 1430.44 | |||
SO63155_16 | 000A-434D-BC | PO15196165529 | 100 | 282 | 545 | 258 | 4 | 2024-04-04 | 48.59 | 1.21 | 2024-03-23 | 2 | 17.98 | 1 | 48.59 | 16 | SO63155 | 2024-03-30 | 3.89 | 35.96 | 24.29 | |||
SO47045_41 | 9DDC-4176-90 | PO6438144434 | 100 | 283 | 453 | 309 | 4 | 2022-10-03 | 35.99 | 0.90 | 2022-09-21 | 1 | 24.75 | 1 | 35.99 | 41 | SO47045 | 2022-09-28 | 2.88 | 24.75 | 35.99 | |||
SO46341_21 | 7717-4086-86 | PO15138183971 | 100 | 283 | 253 | 93 | 4 | 2022-08-03 | 357.16 | 8.93 | 2022-07-22 | 2 | 176.20 | 1 | 357.16 | 21 | SO46341 | 2022-07-29 | 28.57 | 352.40 | 178.58 | |||
SO65303_24 | 93EA-4158-A9 | PO5539133147 | 100 | 282 | 483 | 61 | 4 | 2024-05-03 | 72.00 | 1.80 | 2024-04-21 | 1 | 44.88 | 1 | 72.00 | 24 | SO65303 | 2024-04-28 | 5.76 | 44.88 | 72.00 | |||
SO49125_21 | D58B-4B43-AA | PO3654156335 | 100 | 281 | 352 | 435 | 4 | 2023-04-05 | 1242.85 | 31.07 | 2023-03-24 | 1 | 1117.86 | 1 | 1242.85 | 21 | SO49125 | 2023-03-31 | 99.43 | 1117.86 | 1242.85 | |||
SO46101_17 | FAFC-4F06-B2 | PO7656119075 | 100 | 282 | 324 | 403 | 4 | 2022-07-03 | 838.92 | 20.97 | 2022-06-21 | 2 | 413.15 | 1 | 838.92 | 17 | SO46101 | 2022-06-28 | 67.11 | 826.29 | 419.46 | |||
SO53531_39 | B1FB-47B2-8E | PO2697181370 | 100 | 282 | 591 | 187 | 4 | 2023-11-03 | 2033.96 | 50.85 | 2023-10-22 | 6 | 308.22 | 1 | 2033.96 | 39 | SO53531 | 2023-10-29 | 162.72 | 1849.31 | 338.99 | |||
SO48396_24 | F55B-45AE-8B | PO9715142000 | 100 | 283 | 362 | 490 | 4 | 2023-02-02 | 1229.46 | 30.74 | 2023-01-21 | 1 | 1105.81 | 1 | 1229.46 | 24 | SO48396 | 2023-01-28 | 98.36 | 1105.81 | 1229.46 | |||
SO46049_21 | 2C79-41BD-8A | PO15689114654 | 100 | 283 | 318 | 328 | 4 | 2022-07-03 | 1749.59 | 43.74 | 2022-06-21 | 2 | 884.71 | 1 | 1749.59 | 21 | SO46049 | 2022-06-28 | 139.97 | 1769.42 | 874.79 | |||
SO67320_22 | 771C-4E57-91 | PO5626199373 | 100 | 281 | 255 | 166 | 4 | 2024-06-03 | 1011.66 | 25.29 | 2024-05-22 | 5 | 204.63 | 1 | 1011.66 | 22 | SO67320 | 2024-05-29 | 80.93 | 1023.13 | 202.33 | |||
SO69412_8 | 14B1-47FE-BF | PO15689112657 | 100 | 281 | 384 | 328 | 4 | 2024-07-03 | 2016.88 | 50.42 | 2024-06-21 | 3 | 713.08 | 1 | 2016.88 | 8 | SO69412 | 2024-06-28 | 161.35 | 2139.24 | 672.29 | |||
SO50310_2 | FCBD-48EE-A9 | PO6438126969 | 100 | 281 | 356 | 2 | 309 | 4 | 288.34 | 2023-07-03 | 14417.08 | 353.22 | 2023-06-21 | 12 | 1117.86 | 1 | 14128.74 | 2 | SO50310 | 2023-06-28 | 1130.30 | 13414.27 | 1201.42 | 0.02 |
SO47028_24 | 8DA0-456D-8F | PO3799132728 | 100 | 282 | 447 | 312 | 4 | 2022-10-03 | 45.00 | 1.13 | 2022-09-21 | 3 | 10.31 | 1 | 45.00 | 24 | SO47028 | 2022-09-28 | 3.60 | 30.94 | 15.00 | |||
SO43864_4 | B5D8-4B03-96 | PO16037151094 | 100 | 282 | 351 | 384 | 4 | 2021-10-03 | 4049.99 | 101.25 | 2021-09-21 | 2 | 1898.09 | 1 | 4049.99 | 4 | SO43864 | 2021-09-28 | 324.00 | 3796.19 | 2024.99 | |||
SO47435_9 | B7A7-4F07-94 | PO5597154214 | 100 | 283 | 401 | 75 | 4 | 2022-11-03 | 131.20 | 3.28 | 2022-10-22 | 2 | 48.55 | 1 | 131.20 | 9 | SO47435 | 2022-10-29 | 10.50 | 97.09 | 65.60 | |||
SO47028_29 | 8DA0-456D-8F | PO3799132728 | 100 | 282 | 221 | 312 | 4 | 2022-10-03 | 100.93 | 2.52 | 2022-09-21 | 5 | 13.88 | 1 | 100.93 | 29 | SO47028 | 2022-09-28 | 8.07 | 69.39 | 20.19 | |||
SO71889_11 | 79BB-4639-B8 | PO6786144643 | 100 | 281 | 472 | 3 | 4 | 2024-08-03 | 114.30 | 2.86 | 2024-07-22 | 3 | 23.75 | 1 | 114.30 | 11 | SO71889 | 2024-07-29 | 9.14 | 71.25 | 38.10 | |||
SO50739_6 | 7F49-4009-8C | PO3886138724 | 100 | 281 | 325 | 165 | 4 | 2023-08-03 | 939.59 | 23.49 | 2023-07-22 | 2 | 486.71 | 1 | 939.59 | 6 | SO50739 | 2023-07-29 | 75.17 | 973.41 | 469.79 | |||
SO49538_18 | CB52-4E7E-9B | PO6786132021 | 100 | 281 | 221 | 3 | 4 | 2023-05-03 | 60.56 | 1.51 | 2023-04-21 | 3 | 13.88 | 1 | 60.56 | 18 | SO49538 | 2023-04-28 | 4.84 | 41.63 | 20.19 | |||
SO59029_7 | E358-40C0-B2 | PO4640116818 | 100 | 287 | 532 | 648 | 4 | 2024-02-02 | 449.62 | 11.24 | 2024-01-21 | 3 | 136.79 | 1 | 449.62 | 7 | SO59029 | 2024-01-28 | 35.97 | 410.36 | 149.87 | |||
SO44768_7 | 18BD-48B8-95 | PO261164909 | 100 | 283 | 330 | 647 | 4 | 2022-02-02 | 1677.84 | 41.95 | 2022-01-21 | 4 | 413.15 | 1 | 1677.84 | 7 | SO44768 | 2022-01-28 | 134.23 | 1652.59 | 419.46 | |||
SO58909_3 | EBC4-496C-90 | PO19343180161 | 100 | 282 | 384 | 24 | 4 | 2024-02-02 | 1344.59 | 33.61 | 2024-01-21 | 2 | 713.08 | 1 | 1344.59 | 3 | SO58909 | 2024-01-28 | 107.57 | 1426.16 | 672.29 | |||
SO51090_54 | EBDE-4A71-8E | PO13688110947 | 100 | 282 | 309 | 475 | 4 | 2023-09-02 | 8187.00 | 204.68 | 2023-08-21 | 10 | 747.20 | 1 | 8187.00 | 54 | SO51090 | 2023-08-28 | 654.96 | 7472.00 | 818.70 | |||
SO58984_11 | 5D72-43BF-AB | PO16153135798 | 100 | 282 | 586 | 186 | 4 | 2024-02-02 | 1336.23 | 33.41 | 2024-01-21 | 3 | 461.44 | 1 | 1336.23 | 11 | SO58984 | 2024-01-28 | 106.90 | 1384.33 | 445.41 | |||
SO44520_7 | 5BE0-436B-8C | PO12499152870 | 100 | 282 | 223 | 78 | 4 | 2022-01-03 | 36.31 | 0.91 | 2021-12-22 | 7 | 5.71 | 1 | 36.31 | 7 | SO44520 | 2021-12-29 | 2.90 | 39.94 | 5.19 | |||
SO53539_4 | 2B21-4FAC-8C | PO18763121730 | 100 | 287 | 565 | 13 | 59 | 4 | 150.33 | 2023-11-03 | 1002.17 | 21.30 | 2023-10-22 | 3 | 461.44 | 1 | 851.85 | 4 | SO53539 | 2023-10-29 | 68.15 | 1384.33 | 334.06 | 0.15 |
SO45799_4 | 4DE8-4B9B-A1 | PO10730195041 | 100 | 287 | 232 | 491 | 4 | 2022-06-03 | 144.20 | 3.61 | 2022-05-22 | 5 | 31.72 | 1 | 144.20 | 4 | SO45799 | 2022-05-29 | 11.54 | 158.62 | 28.84 | |||
SO47427_5 | 61AA-44CA-99 | PO4640137176 | 100 | 287 | 427 | 648 | 4 | 2022-11-03 | 418.51 | 10.46 | 2022-10-22 | 2 | 185.82 | 1 | 418.51 | 5 | SO47427 | 2022-10-29 | 33.48 | 371.64 | 209.26 | |||
SO47677_45 | 2C43-407F-B3 | PO13688179339 | 100 | 282 | 233 | 475 | 4 | 2022-12-03 | 230.72 | 5.77 | 2022-11-21 | 8 | 29.08 | 1 | 230.72 | 45 | SO47677 | 2022-11-28 | 18.46 | 232.65 | 28.84 | |||
SO47438_9 | 69E0-4082-B4 | PO6757114691 | 100 | 283 | 356 | 21 | 4 | 2022-11-03 | 4971.41 | 124.29 | 2022-10-22 | 4 | 1117.86 | 1 | 4971.41 | 9 | SO47438 | 2022-10-29 | 397.71 | 4471.42 | 1242.85 | |||
SO71896_4 | A37A-4B16-B0 | PO4640135042 | 100 | 287 | 598 | 648 | 4 | 2024-08-03 | 323.99 | 8.10 | 2024-07-22 | 1 | 294.58 | 1 | 323.99 | 4 | SO71896 | 2024-07-29 | 25.92 | 294.58 | 323.99 | |||
SO51106_17 | 3D96-4D27-92 | PO12528166058 | 100 | 282 | 574 | 331 | 4 | 2023-09-02 | 2860.88 | 71.52 | 2023-08-21 | 2 | 1481.94 | 1 | 2860.88 | 17 | SO51106 | 2023-08-28 | 228.87 | 2963.88 | 1430.44 | |||
SO51827_28 | B106-4221-AD | PO4611117026 | 100 | 287 | 499 | 131 | 4 | 2023-10-03 | 602.35 | 15.06 | 2023-09-21 | 1 | 601.74 | 1 | 602.35 | 28 | SO51827 | 2023-09-28 | 48.19 | 601.74 | 602.35 | |||
SO49498_41 | D9E7-4090-86 | PO16472151816 | 100 | 287 | 230 | 239 | 4 | 2023-05-03 | 115.36 | 2.88 | 2023-04-21 | 4 | 29.08 | 1 | 115.36 | 41 | SO49498 | 2023-04-28 | 9.23 | 116.32 | 28.84 | |||
SO50753_19 | 8073-4F97-BA | PO7569170218 | 100 | 287 | 366 | 608 | 4 | 2023-08-03 | 647.99 | 16.20 | 2023-07-22 | 1 | 598.44 | 1 | 647.99 | 19 | SO50753 | 2023-07-29 | 51.84 | 598.44 | 647.99 | |||
SO49472_5 | 653C-45A9-B1 | PO2697138792 | 100 | 282 | 410 | 187 | 4 | 2023-05-03 | 36.45 | 0.91 | 2023-04-21 | 1 | 26.97 | 1 | 36.45 | 5 | SO49472 | 2023-04-28 | 2.92 | 26.97 | 36.45 | |||
SO47676_3 | 5DD7-4A1E-9B | PO13659142296 | 100 | 272 | 399 | 437 | 4 | 2022-12-03 | 67.55 | 1.69 | 2022-11-21 | 2 | 24.99 | 1 | 67.55 | 3 | SO47676 | 2022-11-28 | 5.40 | 49.99 | 33.77 | |||
SO61193_2 | DFEB-4C0D-88 | PO551160749 | 100 | 281 | 584 | 4 | 4 | 2024-03-04 | 1295.98 | 32.40 | 2024-02-21 | 4 | 343.65 | 1 | 1295.98 | 2 | SO61193 | 2024-02-28 | 103.68 | 1374.60 | 323.99 | |||
SO47024_1 | F254-4053-A3 | PO3654136382 | 100 | 283 | 366 | 435 | 4 | 2022-10-03 | 2591.98 | 64.80 | 2022-09-21 | 4 | 598.44 | 1 | 2591.98 | 1 | SO47024 | 2022-09-28 | 207.36 | 2393.74 | 647.99 | |||
SO51845_8 | 6AB8-4CEA-A9 | PO3799111961 | 100 | 282 | 353 | 312 | 4 | 2023-10-03 | 4175.98 | 104.40 | 2023-09-21 | 3 | 1265.62 | 1 | 4175.98 | 8 | SO51845 | 2023-09-28 | 334.08 | 3796.86 | 1391.99 | |||
SO51126_22 | 7A9E-43B4-B3 | PO2755153471 | 100 | 282 | 562 | 14 | 205 | 4 | 1525.80 | 2023-09-02 | 7629.02 | 152.58 | 2023-08-21 | 8 | 1481.94 | 1 | 6103.22 | 22 | SO51126 | 2023-08-28 | 488.26 | 11855.50 | 953.63 | 0.20 |
SO49541_19 | B736-4142-A1 | PO7569133326 | 100 | 287 | 305 | 608 | 4 | 2023-05-03 | 2208.44 | 55.21 | 2023-04-21 | 3 | 653.70 | 1 | 2208.44 | 19 | SO49541 | 2023-04-28 | 176.67 | 1961.09 | 736.15 | |||
SO48775_1 | E56E-4C8C-AA | PO10817145980 | 100 | 287 | 224 | 203 | 4 | 2023-03-05 | 15.56 | 0.39 | 2023-02-21 | 3 | 5.23 | 1 | 15.56 | 1 | SO48775 | 2023-02-28 | 1.24 | 15.69 | 5.19 | |||
SO51836_21 | 8AA7-498C-8C | PO6351139034 | 100 | 281 | 520 | 255 | 4 | 2023-10-03 | 31.58 | 0.79 | 2023-09-21 | 1 | 23.37 | 1 | 31.58 | 21 | SO51836 | 2023-09-28 | 2.53 | 23.37 | 31.58 | |||
SO53616_28 | A692-4827-93 | PO6786150961 | 100 | 281 | 583 | 2 | 3 | 4 | 276.24 | 2023-11-03 | 13812.04 | 338.40 | 2023-10-22 | 14 | 1082.51 | 1 | 13535.80 | 28 | SO53616 | 2023-10-29 | 1082.86 | 15155.14 | 986.57 | 0.02 |
SO46341_15 | 7717-4086-86 | PO15138183971 | 100 | 283 | 316 | 93 | 4 | 2022-08-03 | 1749.59 | 43.74 | 2022-07-22 | 2 | 884.71 | 1 | 1749.59 | 15 | SO46341 | 2022-07-29 | 139.97 | 1769.42 | 874.79 | |||
SO50747_9 | A59F-46DA-BE | PO5597196496 | 100 | 281 | 445 | 75 | 4 | 2023-08-03 | 107.98 | 2.70 | 2023-07-22 | 3 | 24.75 | 1 | 107.98 | 9 | SO50747 | 2023-07-29 | 8.64 | 74.24 | 35.99 | |||
SO49515_23 | 52D0-4584-BC | PO9715144044 | 100 | 281 | 352 | 490 | 4 | 2023-05-03 | 1242.85 | 31.07 | 2023-04-21 | 1 | 1117.86 | 1 | 1242.85 | 23 | SO49515 | 2023-04-28 | 99.43 | 1117.86 | 1242.85 | |||
SO50208_38 | 6993-49B4-8B | PO15689114248 | 100 | 281 | 422 | 328 | 4 | 2023-07-03 | 337.70 | 8.44 | 2023-06-21 | 5 | 49.98 | 1 | 337.70 | 38 | SO50208 | 2023-06-28 | 27.02 | 249.89 | 67.54 | |||
SO51131_59 | D489-4DF3-A2 | PO16298169856 | 100 | 287 | 484 | 3 | 599 | 4 | 4.37 | 2023-09-02 | 87.45 | 2.08 | 2023-08-21 | 20 | 2.97 | 1 | 83.08 | 59 | SO51131 | 2023-08-28 | 6.65 | 59.47 | 4.37 | 0.05 |
SO58975_2 | 1BCF-4E62-A9 | PO2697145020 | 100 | 282 | 398 | 187 | 4 | 2024-02-02 | 26.72 | 0.67 | 2024-01-21 | 1 | 19.78 | 1 | 26.72 | 2 | SO58975 | 2024-01-28 | 2.14 | 19.78 | 26.72 | |||
SO44755_17 | 3B0A-428C-99 | PO15167120207 | 100 | 283 | 342 | 273 | 4 | 2022-02-02 | 419.46 | 10.49 | 2022-01-21 | 1 | 413.15 | 1 | 419.46 | 17 | SO44755 | 2022-01-28 | 33.56 | 413.15 | 419.46 | |||
SO47400_18 | F0B3-44C1-8F | PO10701186775 | 100 | 282 | 470 | 3 | 133 | 4 | 19.85 | 2022-11-03 | 397.00 | 9.43 | 2022-10-22 | 19 | 15.67 | 1 | 377.15 | 18 | SO47400 | 2022-10-29 | 30.17 | 297.75 | 20.89 | 0.05 |
SO51745_6 | C261-441D-A5 | PO11745132954 | 100 | 282 | 234 | 97 | 4 | 2023-10-03 | 29.99 | 0.75 | 2023-09-21 | 1 | 38.49 | 1 | 29.99 | 6 | SO51745 | 2023-09-28 | 2.40 | 38.49 | 29.99 | |||
SO50252_34 | B5DA-491E-A9 | PO2523194031 | 100 | 287 | 263 | 167 | 4 | 2023-07-03 | 607.00 | 15.17 | 2023-06-21 | 3 | 187.16 | 1 | 607.00 | 34 | SO50252 | 2023-06-28 | 48.56 | 561.47 | 202.33 | |||
SO53607_14 | 329F-491C-8E | PO5510117855 | 100 | 287 | 231 | 5 | 4 | 2023-11-03 | 59.99 | 1.50 | 2023-10-22 | 2 | 38.49 | 1 | 59.99 | 14 | SO53607 | 2023-10-29 | 4.80 | 76.98 | 29.99 | |||
SO45072_2 | FFF9-4C3E-A9 | PO6409119280 | 100 | 283 | 332 | 292 | 4 | 2022-03-05 | 838.92 | 20.97 | 2022-02-21 | 2 | 413.15 | 1 | 838.92 | 2 | SO45072 | 2022-02-28 | 67.11 | 826.29 | 419.46 | |||
SO50289_19 | 0809-4DE4-93 | PO3480117331 | 100 | 281 | 236 | 436 | 4 | 2023-07-03 | 115.36 | 2.88 | 2023-06-21 | 4 | 29.08 | 1 | 115.36 | 19 | SO50289 | 2023-06-28 | 9.23 | 116.32 | 28.84 | |||
SO49821_12 | 0B9B-460C-BC | PO551117366 | 100 | 281 | 375 | 4 | 4 | 2023-06-03 | 3926.81 | 98.17 | 2023-05-22 | 3 | 1320.68 | 1 | 3926.81 | 12 | SO49821 | 2023-05-29 | 314.15 | 3962.05 | 1308.94 | |||
SO67320_11 | 771C-4E57-91 | PO5626199373 | 100 | 281 | 547 | 166 | 4 | 2024-06-03 | 145.78 | 3.64 | 2024-05-22 | 3 | 35.96 | 1 | 145.78 | 11 | SO67320 | 2024-05-29 | 11.66 | 107.88 | 48.59 | |||
SO53580_23 | FFE9-4F36-B2 | PO4640164085 | 100 | 287 | 592 | 648 | 4 | 2023-11-03 | 1016.98 | 25.42 | 2023-10-22 | 3 | 308.22 | 1 | 1016.98 | 23 | SO53580 | 2023-10-29 | 81.36 | 924.65 | 338.99 |
Generated 2024-09-20 15:46:43.349 UTC