[ROOT] dt FactResellerSale < WHERE DimSalesTerritoryId EQ '4' > SHUFFLE < SKIP 2938 > < 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 |
---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
SO43873_18 | 494C-48D2-BD | PO12499138177 | 100 | 282 | 315 | 78 | 4 | 2021-10-02 | 5248.76 | 131.22 | 2021-09-20 | 6 | 884.71 | 1 | 5248.76 | 18 | SO43873 | 2021-09-27 | 419.90 | 5308.25 | 874.79 | |||
SO51808_4 | 92BB-45C4-89 | PO7540152834 | 100 | 281 | 559 | 607 | 4 | 2023-10-02 | 24.29 | 0.61 | 2023-09-20 | 2 | 8.99 | 1 | 24.29 | 4 | SO51808 | 2023-09-27 | 1.94 | 17.97 | 12.14 | |||
SO47434_22 | 6848-4C33-98 | PO5539145068 | 100 | 282 | 464 | 61 | 4 | 2022-11-02 | 42.39 | 1.06 | 2022-10-21 | 3 | 9.71 | 1 | 42.39 | 22 | SO47434 | 2022-10-28 | 3.39 | 29.14 | 14.13 | |||
SO57137_10 | 9401-4518-A4 | PO6438194874 | 100 | 281 | 587 | 309 | 4 | 2024-01-02 | 461.69 | 11.54 | 2023-12-21 | 1 | 419.78 | 1 | 461.69 | 10 | SO57137 | 2023-12-28 | 36.94 | 419.78 | 461.69 | |||
SO71881_42 | 8EDF-4F9F-97 | PO6757112103 | 100 | 281 | 309 | 21 | 4 | 2024-08-02 | 1637.40 | 40.94 | 2024-07-21 | 2 | 747.20 | 1 | 1637.40 | 42 | SO71881 | 2024-07-28 | 130.99 | 1494.40 | 818.70 | |||
SO43864_2 | B5D8-4B03-96 | PO16037151094 | 100 | 282 | 304 | 384 | 4 | 2021-10-02 | 714.70 | 17.87 | 2021-09-20 | 1 | 617.03 | 1 | 714.70 | 2 | SO43864 | 2021-09-27 | 57.18 | 617.03 | 714.70 | |||
SO44301_9 | 34BE-4E85-85 | PO10730158868 | 100 | 287 | 313 | 491 | 4 | 2021-12-02 | 2146.96 | 53.67 | 2021-11-20 | 1 | 2171.29 | 1 | 2146.96 | 9 | SO44301 | 2021-11-27 | 171.76 | 2171.29 | 2146.96 | |||
SO71796_8 | 9A29-45DE-BF | PO17052159664 | 100 | 282 | 574 | 420 | 4 | 2024-08-02 | 2860.88 | 71.52 | 2024-07-21 | 2 | 1481.94 | 1 | 2860.88 | 8 | SO71796 | 2024-07-28 | 228.87 | 2963.88 | 1430.44 | |||
SO47422_11 | 9D8D-4481-B6 | PO3915123127 | 100 | 283 | 457 | 130 | 4 | 2022-11-02 | 269.96 | 6.75 | 2022-10-21 | 6 | 30.93 | 1 | 269.96 | 11 | SO47422 | 2022-10-28 | 21.60 | 185.60 | 44.99 | |||
SO49498_15 | D9E7-4090-86 | PO16472151816 | 100 | 287 | 448 | 239 | 4 | 2023-05-02 | 59.97 | 1.50 | 2023-04-20 | 5 | 8.25 | 1 | 59.97 | 15 | SO49498 | 2023-04-27 | 4.80 | 41.23 | 11.99 | |||
SO46049_30 | 2C79-41BD-8A | PO15689114654 | 100 | 283 | 212 | 328 | 4 | 2022-07-02 | 100.93 | 2.52 | 2022-06-20 | 5 | 12.03 | 1 | 100.93 | 30 | SO46049 | 2022-06-27 | 8.07 | 60.14 | 20.19 | |||
SO71787_12 | 94A7-4406-B3 | PO18038111279 | 100 | 287 | 555 | 509 | 4 | 2024-08-02 | 127.80 | 3.20 | 2024-07-21 | 2 | 47.29 | 1 | 127.80 | 12 | SO71787 | 2024-07-28 | 10.22 | 94.57 | 63.90 | |||
SO46625_1 | 361B-4CAF-A2 | PO13688113829 | 100 | 282 | 459 | 475 | 4 | 2022-09-01 | 53.99 | 1.35 | 2022-08-20 | 1 | 37.12 | 1 | 53.99 | 1 | SO46625 | 2022-08-27 | 4.32 | 37.12 | 53.99 | |||
SO51842_27 | 2A39-4E97-9A | PO4843199898 | 100 | 287 | 606 | 257 | 4 | 2023-10-02 | 1943.96 | 48.60 | 2023-09-20 | 6 | 343.65 | 1 | 1943.96 | 27 | SO51842 | 2023-09-27 | 155.52 | 2061.90 | 323.99 | |||
SO57042_5 | 52C4-4348-BC | PO15196150289 | 100 | 282 | 408 | 258 | 4 | 2024-01-02 | 72.16 | 1.80 | 2023-12-21 | 1 | 53.40 | 1 | 72.16 | 5 | SO57042 | 2023-12-28 | 5.77 | 53.40 | 72.16 | |||
SO49491_1 | CD1A-4EC4-B4 | PO15834193758 | 100 | 281 | 286 | 417 | 4 | 2023-05-02 | 183.94 | 4.60 | 2023-04-20 | 1 | 170.14 | 1 | 183.94 | 1 | SO49491 | 2023-04-27 | 14.72 | 170.14 | 183.94 | |||
SO53552_7 | C686-48BD-B0 | PO16182115085 | 100 | 287 | 477 | 23 | 4 | 2023-11-02 | 8.98 | 0.22 | 2023-10-21 | 3 | 1.87 | 1 | 8.98 | 7 | SO53552 | 2023-10-28 | 0.72 | 5.60 | 2.99 | |||
SO50214_23 | 97D5-41D3-8F | PO15196120916 | 100 | 282 | 286 | 258 | 4 | 2023-07-02 | 367.88 | 9.20 | 2023-06-20 | 2 | 170.14 | 1 | 367.88 | 23 | SO50214 | 2023-06-27 | 29.43 | 340.29 | 183.94 | |||
SO69411_13 | E0BB-44D1-83 | PO15921144493 | 100 | 287 | 477 | 77 | 4 | 2024-07-02 | 2.99 | 0.07 | 2024-06-20 | 1 | 1.87 | 1 | 2.99 | 13 | SO69411 | 2024-06-27 | 0.24 | 1.87 | 2.99 | |||
SO48049_26 | C09A-49F5-80 | PO3799136256 | 100 | 282 | 448 | 312 | 4 | 2023-01-02 | 35.98 | 0.90 | 2022-12-21 | 3 | 8.25 | 1 | 35.98 | 26 | SO48049 | 2022-12-28 | 2.88 | 24.74 | 11.99 | |||
SO46625_34 | 361B-4CAF-A2 | PO13688113829 | 100 | 282 | 466 | 475 | 4 | 2022-09-01 | 70.64 | 1.77 | 2022-08-20 | 5 | 9.71 | 1 | 70.64 | 34 | SO46625 | 2022-08-27 | 5.65 | 48.57 | 14.13 | |||
SO47677_13 | 2C43-407F-B3 | PO13688179339 | 100 | 282 | 393 | 475 | 4 | 2022-12-02 | 275.39 | 6.88 | 2022-11-20 | 2 | 101.89 | 1 | 275.39 | 13 | SO47677 | 2022-11-27 | 22.03 | 203.79 | 137.69 | |||
SO48384_28 | C99C-4AEC-9E | PO7569115185 | 100 | 287 | 362 | 608 | 4 | 2023-02-01 | 6147.29 | 153.68 | 2023-01-20 | 5 | 1105.81 | 1 | 6147.29 | 28 | SO48384 | 2023-01-27 | 491.78 | 5529.05 | 1229.46 | |||
SO53614_9 | A1C5-4C4D-9C | PO6757196330 | 100 | 281 | 594 | 21 | 4 | 2023-11-02 | 1355.98 | 33.90 | 2023-10-21 | 4 | 308.22 | 1 | 1355.98 | 9 | SO53614 | 2023-10-28 | 108.48 | 1232.87 | 338.99 | |||
SO69505_4 | FE34-45B3-8D | PO5684197579 | 100 | 282 | 533 | 385 | 4 | 2024-07-02 | 149.87 | 3.75 | 2024-06-20 | 1 | 136.79 | 1 | 149.87 | 4 | SO69505 | 2024-06-27 | 11.99 | 136.79 | 149.87 | |||
SO49160_18 | 60E2-486C-AE | PO7656113690 | 100 | 282 | 460 | 403 | 4 | 2023-04-04 | 107.99 | 2.70 | 2023-03-23 | 2 | 37.12 | 1 | 107.99 | 18 | SO49160 | 2023-03-30 | 8.64 | 74.24 | 53.99 | |||
SO48363_4 | A9C9-4B7B-9B | PO3915186343 | 100 | 283 | 331 | 130 | 4 | 2023-02-01 | 1409.38 | 35.23 | 2023-01-20 | 3 | 486.71 | 1 | 1409.38 | 4 | SO48363 | 2023-01-27 | 112.75 | 1460.12 | 469.79 | |||
SO47712_7 | 299D-4C8A-BF | PO5626117491 | 100 | 283 | 369 | 166 | 4 | 2022-12-02 | 7330.05 | 183.25 | 2022-11-20 | 5 | 1518.79 | 1 | 7330.05 | 7 | SO47712 | 2022-11-27 | 586.40 | 7593.93 | 1466.01 | |||
SO44286_2 | 27D8-4398-9C | PO16008112311 | 100 | 282 | 314 | 511 | 4 | 2021-12-02 | 2146.96 | 53.67 | 2021-11-20 | 1 | 2171.29 | 1 | 2146.96 | 2 | SO44286 | 2021-11-27 | 171.76 | 2171.29 | 2146.96 | |||
SO44314_6 | 6FDF-4206-A7 | PO5626111923 | 100 | 283 | 264 | 166 | 4 | 2021-12-02 | 183.94 | 4.60 | 2021-11-20 | 1 | 181.49 | 1 | 183.94 | 6 | SO44314 | 2021-11-27 | 14.72 | 181.49 | 183.94 | |||
SO47422_25 | 9D8D-4481-B6 | PO3915123127 | 100 | 283 | 343 | 130 | 4 | 2022-11-02 | 3288.56 | 82.21 | 2022-10-21 | 7 | 486.71 | 1 | 3288.56 | 25 | SO47422 | 2022-10-28 | 263.08 | 3406.95 | 469.79 | |||
SO47034_30 | A5AA-46C3-92 | PO4843149248 | 100 | 287 | 424 | 257 | 4 | 2022-10-02 | 428.47 | 10.71 | 2022-09-20 | 2 | 158.53 | 1 | 428.47 | 30 | SO47034 | 2022-09-27 | 34.28 | 317.07 | 214.24 | |||
SO71952_22 | 9490-4552-81 | PO9715163911 | 100 | 281 | 476 | 3 | 490 | 4 | 28.87 | 2024-08-02 | 577.42 | 13.71 | 2024-07-21 | 15 | 26.18 | 1 | 548.55 | 22 | SO71952 | 2024-07-28 | 43.88 | 392.64 | 38.49 | 0.05 |
SO47373_4 | 93C8-4034-BB | PO16269116347 | 100 | 287 | 439 | 624 | 4 | 2022-11-02 | 780.82 | 19.52 | 2022-10-21 | 1 | 722.26 | 1 | 780.82 | 4 | SO47373 | 2022-10-28 | 62.47 | 722.26 | 780.82 | |||
SO46648_27 | 2073-4051-9E | PO2494191557 | 100 | 283 | 352 | 184 | 4 | 2022-09-01 | 4971.41 | 124.29 | 2022-08-20 | 4 | 1117.86 | 1 | 4971.41 | 27 | SO46648 | 2022-08-27 | 397.71 | 4471.42 | 1242.85 | |||
SO51833_19 | 67A5-4BBC-8F | PO5684113634 | 100 | 282 | 542 | 385 | 4 | 2023-10-02 | 72.88 | 1.82 | 2023-09-20 | 3 | 17.98 | 1 | 72.88 | 19 | SO51833 | 2023-09-27 | 5.83 | 53.93 | 24.29 | |||
SO44115_2 | 5360-4C42-90 | PO3248122509 | 100 | 282 | 304 | 366 | 4 | 2021-11-02 | 714.70 | 17.87 | 2021-10-21 | 1 | 617.03 | 1 | 714.70 | 2 | SO44115 | 2021-10-28 | 57.18 | 617.03 | 714.70 | |||
SO57042_26 | 52C4-4348-BC | PO15196150289 | 100 | 282 | 390 | 258 | 4 | 2024-01-02 | 2689.18 | 67.23 | 2023-12-21 | 4 | 713.08 | 1 | 2689.18 | 26 | SO57042 | 2023-12-28 | 215.13 | 2852.32 | 672.29 | |||
SO53533_1 | B8B0-46C0-AF | PO18038134377 | 100 | 287 | 523 | 509 | 4 | 2023-11-02 | 31.58 | 0.79 | 2023-10-21 | 1 | 23.37 | 1 | 31.58 | 1 | SO53533 | 2023-10-28 | 2.53 | 23.37 | 31.58 | |||
SO48066_5 | F00E-4B06-9D | PO5684167807 | 100 | 282 | 428 | 385 | 4 | 2023-01-02 | 209.26 | 5.23 | 2022-12-21 | 1 | 185.82 | 1 | 209.26 | 5 | SO48066 | 2022-12-28 | 16.74 | 185.82 | 209.26 | |||
SO44770_5 | D260-44B2-BE | PO667193267 | 100 | 287 | 232 | 365 | 4 | 2022-02-01 | 28.84 | 0.72 | 2022-01-20 | 1 | 31.72 | 1 | 28.84 | 5 | SO44770 | 2022-01-27 | 2.31 | 31.72 | 28.84 | |||
SO50663_4 | 286E-4915-89 | PO19343130555 | 100 | 282 | 263 | 24 | 4 | 2023-08-02 | 809.33 | 20.23 | 2023-07-21 | 4 | 187.16 | 1 | 809.33 | 4 | SO50663 | 2023-07-28 | 64.75 | 748.63 | 202.33 | |||
SO63212_6 | B54D-4C63-85 | PO5684113881 | 100 | 282 | 512 | 385 | 4 | 2024-04-03 | 436.91 | 10.92 | 2024-03-22 | 2 | 199.38 | 1 | 436.91 | 6 | SO63212 | 2024-03-29 | 34.95 | 398.75 | 218.45 | |||
SO55251_9 | 2481-4FF1-80 | PO13659159365 | 100 | 287 | 598 | 437 | 4 | 2023-12-02 | 323.99 | 8.10 | 2023-11-20 | 1 | 294.58 | 1 | 323.99 | 9 | SO55251 | 2023-11-27 | 25.92 | 294.58 | 323.99 | |||
SO47400_18 | F0B3-44C1-8F | PO10701186775 | 100 | 282 | 470 | 3 | 133 | 4 | 19.85 | 2022-11-02 | 397.00 | 9.43 | 2022-10-21 | 19 | 15.67 | 1 | 377.15 | 18 | SO47400 | 2022-10-28 | 30.17 | 297.75 | 20.89 | 0.05 |
SO49160_1 | 60E2-486C-AE | PO7656113690 | 100 | 282 | 369 | 403 | 4 | 2023-04-04 | 2932.02 | 73.30 | 2023-03-23 | 2 | 1518.79 | 1 | 2932.02 | 1 | SO49160 | 2023-03-30 | 234.56 | 3037.57 | 1466.01 | |||
SO50266_2 | 5A1A-4C41-B9 | PO15921150902 | 100 | 287 | 325 | 77 | 4 | 2023-07-02 | 469.79 | 11.74 | 2023-06-20 | 1 | 486.71 | 1 | 469.79 | 2 | SO50266 | 2023-06-27 | 37.58 | 486.71 | 469.79 | |||
SO48069_6 | 60CF-43B6-82 | PO6438117188 | 100 | 283 | 410 | 309 | 4 | 2023-01-02 | 182.24 | 4.56 | 2022-12-21 | 5 | 26.97 | 1 | 182.24 | 6 | SO48069 | 2022-12-28 | 14.58 | 134.85 | 36.45 | |||
SO65306_11 | 6B9B-439C-94 | PO5597142402 | 100 | 281 | 295 | 75 | 4 | 2024-05-02 | 818.70 | 20.47 | 2024-04-20 | 1 | 747.20 | 1 | 818.70 | 11 | SO65306 | 2024-04-27 | 65.50 | 747.20 | 818.70 | |||
SO53583_8 | 582E-4A53-9A | PO5597118655 | 100 | 281 | 552 | 75 | 4 | 2023-11-02 | 548.94 | 13.72 | 2023-10-21 | 10 | 40.62 | 1 | 548.94 | 8 | SO53583 | 2023-10-28 | 43.92 | 406.22 | 54.89 | |||
SO43689_4 | DCD9-4C9A-AB | PO5626159507 | 100 | 283 | 314 | 166 | 4 | 2021-09-01 | 2146.96 | 53.67 | 2021-08-20 | 1 | 2171.29 | 1 | 2146.96 | 4 | SO43689 | 2021-08-27 | 171.76 | 2171.29 | 2146.96 | |||
SO49127_13 | 01A1-43AB-A2 | PO3480145572 | 100 | 272 | 453 | 436 | 4 | 2023-04-04 | 35.99 | 0.90 | 2023-03-23 | 1 | 24.75 | 1 | 35.99 | 13 | SO49127 | 2023-03-30 | 2.88 | 24.75 | 35.99 | |||
SO51825_38 | E395-4F72-84 | PO6525184188 | 100 | 281 | 398 | 345 | 4 | 2023-10-02 | 53.45 | 1.34 | 2023-09-20 | 2 | 19.78 | 1 | 53.45 | 38 | SO51825 | 2023-09-27 | 4.28 | 39.55 | 26.72 | |||
SO44299_13 | AFF1-4CD9-9A | PO10817117580 | 100 | 287 | 312 | 203 | 4 | 2021-12-02 | 10734.81 | 268.37 | 2021-11-20 | 5 | 2171.29 | 1 | 10734.81 | 13 | SO44299 | 2021-11-27 | 858.78 | 10856.47 | 2146.96 | |||
SO67273_15 | 9BAE-4E69-B9 | PO13688176638 | 100 | 282 | 357 | 475 | 4 | 2024-06-02 | 4175.98 | 104.40 | 2024-05-21 | 3 | 1265.62 | 1 | 4175.98 | 15 | SO67273 | 2024-05-28 | 334.08 | 3796.86 | 1391.99 | |||
SO57033_1 | 6531-47CC-8F | PO16356151203 | 100 | 282 | 559 | 610 | 4 | 2024-01-02 | 12.14 | 0.30 | 2023-12-21 | 1 | 8.99 | 1 | 12.14 | 1 | SO57033 | 2023-12-28 | 0.97 | 8.99 | 12.14 | |||
SO49821_7 | 0B9B-460C-BC | PO551117366 | 100 | 281 | 331 | 4 | 4 | 2023-06-02 | 1879.18 | 46.98 | 2023-05-21 | 4 | 486.71 | 1 | 1879.18 | 7 | SO49821 | 2023-05-28 | 150.33 | 1946.83 | 469.79 | |||
SO69412_1 | 14B1-47FE-BF | PO15689112657 | 100 | 281 | 378 | 328 | 4 | 2024-07-02 | 7330.05 | 183.25 | 2024-06-20 | 5 | 1554.95 | 1 | 7330.05 | 1 | SO69412 | 2024-06-27 | 586.40 | 7774.74 | 1466.01 | |||
SO59023_37 | 9975-4F2A-A7 | PO5539149469 | 100 | 282 | 475 | 61 | 4 | 2024-02-01 | 125.98 | 3.15 | 2024-01-20 | 3 | 26.18 | 1 | 125.98 | 37 | SO59023 | 2024-01-27 | 10.08 | 78.53 | 41.99 | |||
SO57144_46 | 074E-478C-99 | PO3799111077 | 100 | 282 | 234 | 312 | 4 | 2024-01-02 | 239.95 | 6.00 | 2023-12-21 | 8 | 38.49 | 1 | 239.95 | 46 | SO57144 | 2023-12-28 | 19.20 | 307.94 | 29.99 | |||
SO55303_16 | 5C9C-4B35-B8 | PO5626137276 | 100 | 281 | 436 | 166 | 4 | 2023-12-02 | 1427.59 | 35.69 | 2023-11-20 | 4 | 360.94 | 1 | 1427.59 | 16 | SO55303 | 2023-11-27 | 114.21 | 1443.77 | 356.90 | |||
SO48745_9 | CDB4-4FFB-87 | PO2494111050 | 100 | 281 | 297 | 184 | 4 | 2023-03-04 | 2208.44 | 55.21 | 2023-02-20 | 3 | 653.70 | 1 | 2208.44 | 9 | SO48745 | 2023-02-27 | 176.67 | 1961.09 | 736.15 |
Generated 2024-09-19 23:37:34.358 UTC