[ROOT] dt FactResellerSale < WHERE DimSalesTerritoryId EQ ALL SKIP 0 SHUFFLE < SKIP 1751 > < 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 |
---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
SO71797_2 | 8375-4C38-91 | PO16501134889 | 98 | 288 | 440 | 142 | 10 | 2024-08-03 | 1717.80 | 42.95 | 2024-07-22 | 2 | 868.63 | 1 | 1717.80 | 2 | SO71797 | 2024-07-29 | 137.42 | 1737.27 | 858.90 | |||
SO46351_1 | 9218-4521-8F | PO11107115959 | 19 | 284 | 315 | 156 | 6 | 2022-08-03 | 874.79 | 21.87 | 2022-07-22 | 1 | 884.71 | 1 | 874.79 | 1 | SO46351 | 2022-07-29 | 69.98 | 884.71 | 874.79 | |||
SO49093_7 | A0B1-4C01-8A | PO15370113221 | 100 | 281 | 364 | 381 | 3 | 2023-04-05 | 647.99 | 16.20 | 2023-03-24 | 1 | 598.44 | 1 | 647.99 | 7 | SO49093 | 2023-03-31 | 51.84 | 598.44 | 647.99 | |||
SO69401_22 | 5377-4B5B-80 | PO17603155358 | 19 | 284 | 491 | 3 | 12 | 6 | 23.76 | 2024-07-03 | 475.11 | 11.28 | 2024-06-21 | 16 | 41.57 | 1 | 451.36 | 22 | SO69401 | 2024-06-28 | 36.11 | 665.16 | 29.69 | 0.05 |
SO69449_19 | 457F-4A9C-96 | PO10266117370 | 6 | 296 | 523 | 393 | 9 | 2024-07-03 | 31.58 | 0.79 | 2024-06-21 | 1 | 23.37 | 1 | 31.58 | 19 | SO69449 | 2024-06-28 | 2.53 | 23.37 | 31.58 | |||
SO65252_18 | F817-49F6-A9 | PO12470159616 | 100 | 287 | 574 | 672 | 1 | 2024-05-03 | 1430.44 | 35.76 | 2024-04-21 | 1 | 1481.94 | 1 | 1430.44 | 18 | SO65252 | 2024-04-28 | 114.44 | 1481.94 | 1430.44 | |||
SO51081_35 | EDBF-4FE1-8F | PO522116846 | 100 | 285 | 472 | 676 | 5 | 2023-09-02 | 266.70 | 6.67 | 2023-08-21 | 7 | 23.75 | 1 | 266.70 | 35 | SO51081 | 2023-08-28 | 21.34 | 166.24 | 38.10 | |||
SO47964_3 | 5CE9-4D75-8F | PO19459187071 | 19 | 291 | 447 | 334 | 6 | 2023-01-03 | 15.00 | 0.38 | 2022-12-22 | 1 | 10.31 | 1 | 15.00 | 3 | SO47964 | 2022-12-29 | 1.20 | 10.31 | 15.00 | |||
SO65207_22 | B20E-440F-A3 | PO1537156240 | 100 | 285 | 569 | 611 | 5 | 2024-05-03 | 445.41 | 11.14 | 2024-04-21 | 1 | 461.44 | 1 | 445.41 | 22 | SO65207 | 2024-04-28 | 35.63 | 461.44 | 445.41 | |||
SO48341_19 | A747-471B-97 | PO10701176180 | 100 | 282 | 221 | 2 | 133 | 4 | 4.68 | 2023-02-02 | 234.16 | 5.74 | 2023-01-21 | 12 | 13.88 | 1 | 229.48 | 19 | SO48341 | 2023-01-28 | 18.36 | 166.54 | 19.51 | 0.02 |
SO69501_26 | 8A65-4926-A6 | PO6525182870 | 100 | 281 | 476 | 345 | 4 | 2024-07-03 | 125.98 | 3.15 | 2024-06-21 | 3 | 26.18 | 1 | 125.98 | 26 | SO69501 | 2024-06-28 | 10.08 | 78.53 | 41.99 | |||
SO53533_29 | B8B0-46C0-AF | PO18038134377 | 100 | 287 | 514 | 509 | 4 | 2023-11-03 | 191.70 | 4.79 | 2023-10-22 | 3 | 47.29 | 1 | 191.70 | 29 | SO53533 | 2023-10-29 | 15.34 | 141.86 | 63.90 | |||
SO53605_3 | 6D2A-486B-AC | PO5017132122 | 100 | 289 | 492 | 308 | 1 | 2023-11-03 | 1204.69 | 30.12 | 2023-10-22 | 2 | 601.74 | 1 | 1204.69 | 3 | SO53605 | 2023-10-29 | 96.38 | 1203.49 | 602.35 | |||
SO55297_14 | 2455-4B60-A5 | PO4495126679 | 19 | 291 | 484 | 496 | 6 | 2023-12-03 | 23.85 | 0.60 | 2023-11-21 | 5 | 2.97 | 1 | 23.85 | 14 | SO55297 | 2023-11-28 | 1.91 | 14.87 | 4.77 | |||
SO49062_2 | D3FD-415F-A5 | PO928133820 | 98 | 288 | 397 | 484 | 10 | 2023-04-05 | 97.18 | 2.43 | 2023-03-24 | 4 | 17.98 | 1 | 97.18 | 2 | SO49062 | 2023-03-31 | 7.77 | 71.91 | 24.29 | |||
SO51084_25 | 3C77-43D1-83 | PO19575195218 | 98 | 288 | 564 | 14 | 34 | 10 | 190.73 | 2023-09-02 | 953.63 | 19.07 | 2023-08-21 | 1 | 1481.94 | 1 | 762.90 | 25 | SO51084 | 2023-08-28 | 61.03 | 1481.94 | 953.63 | 0.20 |
SO51143_4 | 5AF9-4974-90 | PO8410118711 | 98 | 288 | 258 | 538 | 10 | 2023-09-02 | 404.66 | 10.12 | 2023-08-21 | 2 | 204.63 | 1 | 404.66 | 4 | SO51143 | 2023-08-28 | 32.37 | 409.25 | 202.33 | |||
SO51825_17 | E395-4F72-84 | PO6525184188 | 100 | 281 | 542 | 345 | 4 | 2023-10-03 | 97.18 | 2.43 | 2023-09-21 | 4 | 17.98 | 1 | 97.18 | 17 | SO51825 | 2023-09-28 | 7.77 | 71.91 | 24.29 | |||
SO48023_3 | 18BD-4FA3-9F | PO11020197101 | 19 | 284 | 327 | 2 | 336 | 6 | 108.99 | 2023-01-03 | 5449.61 | 133.52 | 2022-12-22 | 12 | 486.71 | 1 | 5340.62 | 3 | SO48023 | 2022-12-29 | 427.25 | 5840.48 | 454.13 | 0.02 |
SO44764_2 | 85B4-4420-81 | PO11426178608 | 100 | 285 | 324 | 386 | 5 | 2022-02-02 | 419.46 | 10.49 | 2022-01-21 | 1 | 413.15 | 1 | 419.46 | 2 | SO44764 | 2022-01-28 | 33.56 | 413.15 | 419.46 | |||
SO47685_18 | CC2F-4D47-8C | PO11484129630 | 100 | 281 | 411 | 594 | 2 | 2022-12-03 | 501.66 | 12.54 | 2022-11-21 | 4 | 92.81 | 1 | 501.66 | 18 | SO47685 | 2022-11-28 | 40.13 | 371.23 | 125.42 | |||
SO47400_43 | F0B3-44C1-8F | PO10701186775 | 100 | 282 | 399 | 133 | 4 | 2022-11-03 | 202.65 | 5.07 | 2022-10-22 | 6 | 24.99 | 1 | 202.65 | 43 | SO47400 | 2022-10-29 | 16.21 | 149.96 | 33.77 | |||
SO48053_23 | 69FC-4D14-B1 | PO4466199959 | 19 | 291 | 401 | 352 | 6 | 2023-01-03 | 65.60 | 1.64 | 2022-12-22 | 1 | 48.55 | 1 | 65.60 | 23 | SO48053 | 2022-12-29 | 5.25 | 48.55 | 65.60 | |||
SO65245_29 | 80F6-437F-84 | PO9628129233 | 100 | 283 | 563 | 179 | 2 | 2024-05-03 | 1430.44 | 35.76 | 2024-04-21 | 1 | 1481.94 | 1 | 1430.44 | 29 | SO65245 | 2024-04-28 | 114.44 | 1481.94 | 1430.44 | |||
SO51775_39 | 5DF8-4C96-81 | PO2842127356 | 100 | 285 | 547 | 700 | 5 | 2023-10-03 | 48.59 | 1.21 | 2023-09-21 | 1 | 35.96 | 1 | 48.59 | 39 | SO51775 | 2023-09-28 | 3.89 | 35.96 | 48.59 | |||
SO48760_1 | D682-4FD4-94 | PO9657199450 | 100 | 285 | 470 | 315 | 5 | 2023-03-05 | 113.97 | 2.85 | 2023-02-21 | 5 | 15.67 | 1 | 113.97 | 1 | SO48760 | 2023-02-28 | 9.12 | 78.35 | 22.79 | |||
SO59028_13 | F0C6-4E08-A8 | PO4814117936 | 36 | 295 | 564 | 464 | 8 | 2024-02-02 | 1430.44 | 35.76 | 2024-01-21 | 1 | 1481.94 | 1 | 1430.44 | 13 | SO59028 | 2024-01-28 | 114.44 | 1481.94 | 1430.44 | |||
SO49140_15 | EFF3-483D-BE | PO4901154744 | 19 | 284 | 333 | 84 | 6 | 2023-04-05 | 2348.97 | 58.72 | 2023-03-24 | 5 | 486.71 | 1 | 2348.97 | 15 | SO49140 | 2023-03-31 | 187.92 | 2433.53 | 469.79 | |||
SO48048_16 | B414-46CB-BA | PO3480117933 | 100 | 283 | 456 | 436 | 4 | 2023-01-03 | 89.99 | 2.25 | 2022-12-22 | 2 | 30.93 | 1 | 89.99 | 16 | SO48048 | 2022-12-29 | 7.20 | 61.87 | 44.99 | |||
SO44488_3 | 18BD-4C15-81 | PO19546136242 | 100 | 285 | 212 | 206 | 5 | 2022-01-03 | 20.19 | 0.50 | 2021-12-22 | 1 | 12.03 | 1 | 20.19 | 3 | SO44488 | 2021-12-29 | 1.61 | 12.03 | 20.19 | |||
SO69410_4 | 1192-472D-A8 | PO16820123881 | 6 | 296 | 573 | 213 | 9 | 2024-07-03 | 2860.88 | 71.52 | 2024-06-21 | 2 | 1481.94 | 1 | 2860.88 | 4 | SO69410 | 2024-06-28 | 228.87 | 2963.88 | 1430.44 | |||
SO50218_27 | B8E9-4FE2-8B | PO14442144367 | 100 | 293 | 216 | 2 | 127 | 1 | 5.46 | 2023-07-03 | 273.19 | 6.69 | 2023-06-21 | 14 | 13.88 | 1 | 267.73 | 27 | SO50218 | 2023-06-28 | 21.42 | 194.29 | 19.51 | 0.02 |
SO57034_24 | 57D0-46D3-B7 | PO15689142548 | 100 | 281 | 231 | 328 | 4 | 2024-01-03 | 209.96 | 5.25 | 2023-12-22 | 7 | 38.49 | 1 | 209.96 | 24 | SO57034 | 2023-12-29 | 16.80 | 269.45 | 29.99 | |||
SO59065_14 | C012-48E8-A5 | PO8903194371 | 100 | 293 | 477 | 235 | 1 | 2024-02-02 | 5.99 | 0.15 | 2024-01-21 | 2 | 1.87 | 1 | 5.99 | 14 | SO59065 | 2024-01-28 | 0.48 | 3.73 | 2.99 | |||
SO71801_11 | 0DBE-43DA-9A | PO15515173664 | 100 | 292 | 463 | 481 | 7 | 2024-08-03 | 88.16 | 2.20 | 2024-07-22 | 6 | 9.16 | 1 | 88.16 | 11 | SO71801 | 2024-07-29 | 7.05 | 54.96 | 14.69 | |||
SO63261_6 | 47AD-4561-92 | PO2320130718 | 100 | 282 | 418 | 529 | 4 | 2024-04-04 | 356.90 | 8.92 | 2024-03-23 | 1 | 360.94 | 1 | 356.90 | 6 | SO63261 | 2024-03-30 | 28.55 | 360.94 | 356.90 | |||
SO61177_16 | DA64-4BC0-A0 | PO18473117778 | 19 | 291 | 559 | 442 | 6 | 2024-03-04 | 24.29 | 0.61 | 2024-02-21 | 2 | 8.99 | 1 | 24.29 | 16 | SO61177 | 2024-02-28 | 1.94 | 17.97 | 12.14 | |||
SO48010_25 | 81A7-4B68-B2 | PO12702168891 | 100 | 292 | 445 | 175 | 7 | 2023-01-03 | 143.98 | 3.60 | 2022-12-22 | 4 | 24.75 | 1 | 143.98 | 25 | SO48010 | 2022-12-29 | 11.52 | 98.98 | 35.99 | |||
SO47675_32 | 8515-427F-B6 | PO13775136623 | 100 | 281 | 343 | 618 | 2 | 2022-12-03 | 939.59 | 23.49 | 2022-11-21 | 2 | 486.71 | 1 | 939.59 | 32 | SO47675 | 2022-11-28 | 75.17 | 973.41 | 469.79 | |||
SO53458_51 | 0728-4E88-9F | PO19285149036 | 98 | 288 | 494 | 448 | 10 | 2023-11-03 | 602.35 | 15.06 | 2023-10-22 | 1 | 601.74 | 1 | 602.35 | 51 | SO53458 | 2023-10-29 | 48.19 | 601.74 | 602.35 | |||
SO53480_48 | 36E1-4FCF-B4 | PO15341137525 | 100 | 281 | 225 | 327 | 3 | 2023-11-03 | 43.15 | 1.08 | 2023-10-22 | 8 | 6.92 | 1 | 43.15 | 48 | SO53480 | 2023-10-29 | 3.45 | 55.38 | 5.39 | |||
SO49130_1 | 6D40-4F8C-85 | PO12122177177 | 100 | 281 | 379 | 22 | 3 | 2023-04-05 | 1308.94 | 32.72 | 2023-03-24 | 1 | 1320.68 | 1 | 1308.94 | 1 | SO49130 | 2023-03-31 | 104.72 | 1320.68 | 1308.94 | |||
SO58903_5 | A9DB-4EDD-B7 | PO19894119597 | 100 | 283 | 554 | 557 | 2 | 2024-02-02 | 109.88 | 2.75 | 2024-01-21 | 2 | 40.66 | 1 | 109.88 | 5 | SO58903 | 2024-01-28 | 8.79 | 81.31 | 54.94 | |||
SO59017_1 | 1571-4C89-99 | PO4582165909 | 100 | 282 | 513 | 25 | 4 | 2024-02-02 | 218.45 | 5.46 | 2024-01-21 | 1 | 199.38 | 1 | 218.45 | 1 | SO59017 | 2024-01-28 | 17.48 | 199.38 | 218.45 | |||
SO58905_24 | 79BE-4713-94 | PO19604111681 | 98 | 288 | 588 | 340 | 10 | 2024-02-02 | 461.69 | 11.54 | 2024-01-21 | 1 | 419.78 | 1 | 461.69 | 24 | SO58905 | 2024-01-28 | 36.94 | 419.78 | 461.69 | |||
SO57154_34 | 464B-46A4-B6 | PO1856185040 | 19 | 291 | 465 | 263 | 6 | 2024-01-03 | 146.94 | 3.67 | 2023-12-22 | 10 | 9.16 | 1 | 146.94 | 34 | SO57154 | 2023-12-29 | 11.76 | 91.59 | 14.69 | |||
SO46630_2 | F512-40F2-91 | PO12644161356 | 100 | 285 | 420 | 530 | 5 | 2022-09-02 | 283.23 | 7.08 | 2022-08-21 | 2 | 104.80 | 1 | 283.23 | 2 | SO46630 | 2022-08-28 | 22.66 | 209.59 | 141.62 | |||
SO44797_29 | 4297-4DF9-A8 | PO9483142524 | 100 | 281 | 275 | 54 | 2 | 2022-02-02 | 2855.18 | 71.38 | 2022-01-21 | 8 | 352.14 | 1 | 2855.18 | 29 | SO44797 | 2022-01-28 | 228.41 | 2817.12 | 356.90 | |||
SO53621_29 | 9324-4A3D-83 | PO9715186811 | 100 | 281 | 513 | 490 | 4 | 2023-11-03 | 655.36 | 16.38 | 2023-10-22 | 3 | 199.38 | 1 | 655.36 | 29 | SO53621 | 2023-10-29 | 52.43 | 598.13 | 218.45 | |||
SO48397_1 | A1DC-424B-A8 | PO9686169278 | 100 | 282 | 297 | 457 | 4 | 2023-02-02 | 2208.44 | 55.21 | 2023-01-21 | 3 | 653.70 | 1 | 2208.44 | 1 | SO48397 | 2023-01-28 | 176.67 | 1961.09 | 736.15 | |||
SO48083_4 | E4B1-4D02-90 | PO7917164304 | 100 | 287 | 224 | 401 | 1 | 2023-01-03 | 46.68 | 1.17 | 2022-12-22 | 9 | 5.23 | 1 | 46.68 | 4 | SO48083 | 2022-12-29 | 3.73 | 47.07 | 5.19 | |||
SO44079_7 | A180-4128-A7 | PO19488118734 | 100 | 283 | 316 | 57 | 3 | 2021-11-03 | 2624.38 | 65.61 | 2021-10-22 | 3 | 884.71 | 1 | 2624.38 | 7 | SO44079 | 2021-10-29 | 209.95 | 2654.12 | 874.79 | |||
SO53468_50 | C577-4CE9-93 | PO17371113808 | 6 | 296 | 472 | 688 | 9 | 2023-11-03 | 228.60 | 5.72 | 2023-10-22 | 6 | 23.75 | 1 | 228.60 | 50 | SO53468 | 2023-10-29 | 18.29 | 142.49 | 38.10 | |||
SO63181_7 | CB4E-4CF5-87 | PO2842135731 | 100 | 285 | 234 | 700 | 5 | 2024-04-04 | 59.99 | 1.50 | 2024-03-23 | 2 | 38.49 | 1 | 59.99 | 7 | SO63181 | 2024-03-30 | 4.80 | 76.98 | 29.99 | |||
SO69460_15 | D5C8-450E-9F | PO1595193276 | 19 | 284 | 580 | 426 | 6 | 2024-07-03 | 1020.59 | 25.51 | 2024-06-21 | 1 | 1082.51 | 1 | 1020.59 | 15 | SO69460 | 2024-06-28 | 81.65 | 1082.51 | 1020.59 | |||
SO47365_43 | 4535-457B-B0 | PO17574153673 | 19 | 291 | 356 | 678 | 6 | 2022-11-03 | 4971.41 | 124.29 | 2022-10-22 | 4 | 1117.86 | 1 | 4971.41 | 43 | SO47365 | 2022-10-29 | 397.71 | 4471.42 | 1242.85 | |||
SO50712_34 | 9AAC-4C4A-AB | PO14268119350 | 100 | 281 | 415 | 418 | 3 | 2023-08-03 | 594.11 | 14.85 | 2023-07-22 | 3 | 146.55 | 1 | 594.11 | 34 | SO50712 | 2023-07-29 | 47.53 | 439.64 | 198.04 | |||
SO71822_37 | AEDC-410A-9B | PO11774139099 | 6 | 296 | 603 | 682 | 9 | 2024-08-03 | 145.79 | 3.64 | 2024-07-22 | 2 | 53.94 | 1 | 145.79 | 37 | SO71822 | 2024-07-29 | 11.66 | 107.88 | 72.89 | |||
SO53468_10 | C577-4CE9-93 | PO17371113808 | 6 | 296 | 574 | 688 | 9 | 2023-11-03 | 1430.44 | 35.76 | 2023-10-22 | 1 | 1481.94 | 1 | 1430.44 | 10 | SO53468 | 2023-10-29 | 114.44 | 1481.94 | 1430.44 | |||
SO46953_40 | C650-4C32-BE | PO17603154442 | 19 | 284 | 461 | 12 | 6 | 2022-10-03 | 215.98 | 5.40 | 2022-09-21 | 4 | 37.12 | 1 | 215.98 | 40 | SO46953 | 2022-09-28 | 17.28 | 148.48 | 53.99 | |||
SO58926_16 | B82A-4380-9C | PO15486118845 | 100 | 292 | 476 | 121 | 7 | 2024-02-02 | 209.97 | 5.25 | 2024-01-21 | 5 | 26.18 | 1 | 209.97 | 16 | SO58926 | 2024-01-28 | 16.80 | 130.88 | 41.99 | |||
SO71942_7 | A5F9-49B1-92 | PO9222123146 | 100 | 285 | 484 | 171 | 5 | 2024-08-03 | 4.77 | 0.12 | 2024-07-22 | 1 | 2.97 | 1 | 4.77 | 7 | SO71942 | 2024-07-29 | 0.38 | 2.97 | 4.77 |
Generated 2024-09-20 09:44:28.505 UTC