[ROOT] dt FactResellerSale < WHERE DimProductId EQ ALL SHUFFLE SKIP 2000 < SKIP 63 > < 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 |
---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
SO51856_23 | E170-419C-92 | PO3654183134 | 100 | 281 | 549 | 435 | 4 | 2023-10-02 | 218.45 | 5.46 | 2023-09-20 | 1 | 199.38 | 1 | 218.45 | 23 | SO51856 | 2023-09-27 | 17.48 | 199.38 | 218.45 | |||
SO46940_31 | 6ADC-4363-B3 | PO18705126181 | 19 | 291 | 424 | 479 | 6 | 2022-10-02 | 428.47 | 10.71 | 2022-09-20 | 2 | 158.53 | 1 | 428.47 | 31 | SO46940 | 2022-09-27 | 34.28 | 317.07 | 214.24 | |||
SO47045_32 | 9DDC-4176-90 | PO6438144434 | 100 | 283 | 456 | 2 | 309 | 4 | 9.57 | 2022-10-02 | 478.44 | 11.72 | 2022-09-20 | 11 | 30.93 | 1 | 468.87 | 32 | SO47045 | 2022-09-27 | 37.51 | 340.27 | 43.49 | 0.02 |
SO45520_15 | 86A2-4B9B-8D | PO19488171523 | 100 | 283 | 223 | 57 | 3 | 2022-05-02 | 10.37 | 0.26 | 2022-04-20 | 2 | 5.71 | 1 | 10.37 | 15 | SO45520 | 2022-04-27 | 0.83 | 11.41 | 5.19 | |||
SO45280_1 | 46AF-4DA9-99 | PO17748162196 | 19 | 284 | 319 | 102 | 6 | 2022-04-04 | 1749.59 | 43.74 | 2022-03-23 | 2 | 884.71 | 1 | 1749.59 | 1 | SO45280 | 2022-03-30 | 139.97 | 1769.42 | 874.79 | |||
SO46057_28 | 6F2B-45A4-9C | PO12499164653 | 100 | 282 | 232 | 78 | 4 | 2022-07-02 | 57.68 | 1.44 | 2022-06-20 | 2 | 31.72 | 1 | 57.68 | 28 | SO46057 | 2022-06-27 | 4.61 | 63.45 | 28.84 | |||
SO46668_42 | 6711-47BE-BF | PO7859142972 | 100 | 287 | 242 | 221 | 4 | 2022-09-01 | 1561.64 | 39.04 | 2022-08-20 | 2 | 722.26 | 1 | 1561.64 | 42 | SO46668 | 2022-08-27 | 124.93 | 1444.51 | 780.82 | |||
SO61190_34 | 49D5-4AB6-A0 | PO12441157171 | 36 | 295 | 496 | 302 | 8 | 2024-03-03 | 1204.69 | 30.12 | 2024-02-20 | 2 | 601.74 | 1 | 1204.69 | 34 | SO61190 | 2024-02-27 | 96.38 | 1203.49 | 602.35 | |||
SO55275_9 | 72C3-4048-BC | PO1711122362 | 19 | 291 | 398 | 245 | 6 | 2023-12-02 | 26.72 | 0.67 | 2023-11-20 | 1 | 19.78 | 1 | 26.72 | 9 | SO55275 | 2023-11-27 | 2.14 | 19.78 | 26.72 | |||
SO57140_3 | 5E5D-46A1-94 | PO3161152145 | 100 | 283 | 483 | 359 | 2 | 2024-01-02 | 144.00 | 3.60 | 2023-12-21 | 2 | 44.88 | 1 | 144.00 | 3 | SO57140 | 2023-12-28 | 11.52 | 89.76 | 72.00 | |||
SO51832_44 | 475C-432F-B2 | PO4466177904 | 19 | 291 | 231 | 352 | 6 | 2023-10-02 | 119.98 | 3.00 | 2023-09-20 | 4 | 38.49 | 1 | 119.98 | 44 | SO51832 | 2023-09-27 | 9.60 | 153.97 | 29.99 | |||
SO57046_52 | 52CC-460F-B3 | PO14500161818 | 100 | 282 | 484 | 2 | 650 | 1 | 1.29 | 2024-01-02 | 64.55 | 1.58 | 2023-12-21 | 14 | 2.97 | 1 | 63.26 | 52 | SO57046 | 2023-12-28 | 5.06 | 41.63 | 4.61 | 0.02 |
SO46609_2 | 87E3-4F5C-AC | PO17458117152 | 100 | 286 | 236 | 577 | 1 | 2022-09-01 | 28.84 | 0.72 | 2022-08-20 | 1 | 29.08 | 1 | 28.84 | 2 | SO46609 | 2022-08-27 | 2.31 | 29.08 | 28.84 | |||
SO48770_2 | 28CC-48AC-B8 | PO11484112888 | 100 | 283 | 366 | 594 | 2 | 2023-03-04 | 3887.96 | 97.20 | 2023-02-20 | 6 | 598.44 | 1 | 3887.96 | 2 | SO48770 | 2023-02-27 | 311.04 | 3590.61 | 647.99 | |||
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 | |||
SO58918_54 | C811-4D40-80 | PO17574131484 | 19 | 291 | 531 | 678 | 6 | 2024-02-01 | 449.62 | 11.24 | 2024-01-20 | 3 | 136.79 | 1 | 449.62 | 54 | SO58918 | 2024-01-27 | 35.97 | 410.36 | 149.87 | |||
SO67289_12 | 5B09-42E8-A1 | PO10324110444 | 98 | 288 | 225 | 2 | 196 | 10 | 1.36 | 2024-06-02 | 67.78 | 1.66 | 2024-05-21 | 13 | 6.92 | 1 | 66.43 | 12 | SO67289 | 2024-05-28 | 5.31 | 89.99 | 5.21 | 0.02 |
SO44742_26 | BE6B-4A54-91 | PO19488180017 | 100 | 283 | 314 | 57 | 3 | 2022-02-01 | 8587.85 | 214.70 | 2022-01-20 | 4 | 2171.29 | 1 | 8587.85 | 26 | SO44742 | 2022-01-27 | 687.03 | 8685.18 | 2146.96 | |||
SO53539_5 | 2B21-4FAC-8C | PO18763121730 | 100 | 287 | 560 | 59 | 4 | 2023-11-02 | 728.91 | 18.22 | 2023-10-21 | 1 | 755.15 | 1 | 728.91 | 5 | SO53539 | 2023-10-28 | 58.31 | 755.15 | 728.91 | |||
SO61229_40 | AC88-46DA-A3 | PO10324197030 | 98 | 288 | 353 | 196 | 10 | 2024-03-03 | 2783.99 | 69.60 | 2024-02-20 | 2 | 1265.62 | 1 | 2783.99 | 40 | SO61229 | 2024-02-27 | 222.72 | 2531.24 | 1391.99 | |||
SO55236_15 | F466-42CE-8B | PO19575117252 | 98 | 288 | 560 | 34 | 10 | 2023-12-02 | 2186.73 | 54.67 | 2023-11-20 | 3 | 755.15 | 1 | 2186.73 | 15 | SO55236 | 2023-11-27 | 174.94 | 2265.45 | 728.91 | |||
SO55325_10 | 2A57-4E18-99 | PO9338115445 | 100 | 293 | 566 | 451 | 1 | 2023-12-02 | 1781.64 | 44.54 | 2023-11-20 | 4 | 461.44 | 1 | 1781.64 | 10 | SO55325 | 2023-11-27 | 142.53 | 1845.78 | 445.41 | |||
SO69389_6 | 4EEB-44A4-9C | PO20039111182 | 19 | 291 | 474 | 65 | 6 | 2024-07-02 | 377.95 | 9.45 | 2024-06-20 | 9 | 26.18 | 1 | 377.95 | 6 | SO69389 | 2024-06-27 | 30.24 | 235.59 | 41.99 | |||
SO67342_23 | E5A5-4795-BF | PO8004141573 | 6 | 296 | 574 | 231 | 9 | 2024-06-02 | 4291.33 | 107.28 | 2024-05-21 | 3 | 1481.94 | 1 | 4291.33 | 23 | SO67342 | 2024-05-28 | 343.31 | 4445.81 | 1430.44 | |||
SO65160_21 | 9375-44FE-94 | PO19343172976 | 100 | 282 | 374 | 24 | 4 | 2024-05-02 | 5864.04 | 146.60 | 2024-04-20 | 4 | 1554.95 | 1 | 5864.04 | 21 | SO65160 | 2024-04-27 | 469.12 | 6219.79 | 1466.01 | |||
SO53531_36 | B1FB-47B2-8E | PO2697181370 | 100 | 282 | 531 | 187 | 4 | 2023-11-02 | 299.75 | 7.49 | 2023-10-21 | 2 | 136.79 | 1 | 299.75 | 36 | SO53531 | 2023-10-28 | 23.98 | 273.57 | 149.87 | |||
SO61218_32 | 8441-4C6F-89 | PO13688193778 | 100 | 282 | 214 | 475 | 4 | 2024-03-03 | 104.97 | 2.62 | 2024-02-20 | 5 | 13.09 | 1 | 104.97 | 32 | SO61218 | 2024-02-27 | 8.40 | 65.43 | 20.99 | |||
SO50235_6 | 20B9-4308-A5 | PO10121141993 | 100 | 283 | 265 | 684 | 2 | 2023-07-02 | 1213.99 | 30.35 | 2023-06-20 | 6 | 187.16 | 1 | 1213.99 | 6 | SO50235 | 2023-06-27 | 97.12 | 1122.94 | 202.33 | |||
SO71881_2 | 8EDF-4F9F-97 | PO6757112103 | 100 | 281 | 559 | 21 | 4 | 2024-08-02 | 36.43 | 0.91 | 2024-07-21 | 3 | 8.99 | 1 | 36.43 | 2 | SO71881 | 2024-07-28 | 2.91 | 26.96 | 12.14 | |||
SO46630_14 | F512-40F2-91 | PO12644161356 | 100 | 285 | 421 | 530 | 5 | 2022-09-01 | 981.65 | 24.54 | 2022-08-20 | 5 | 145.28 | 1 | 981.65 | 14 | SO46630 | 2022-08-27 | 78.53 | 726.42 | 196.33 | |||
SO50284_20 | F8D1-49E1-A5 | PO4901178867 | 19 | 284 | 435 | 84 | 6 | 2023-07-02 | 324.45 | 8.11 | 2023-06-20 | 1 | 300.12 | 1 | 324.45 | 20 | SO50284 | 2023-06-27 | 25.96 | 300.12 | 324.45 | |||
SO47416_6 | 6B45-44AB-84 | PO2813155355 | 100 | 281 | 224 | 2 | 90 | 5 | 1.10 | 2022-11-02 | 55.15 | 1.35 | 2022-10-21 | 11 | 5.23 | 1 | 54.05 | 6 | SO47416 | 2022-10-28 | 4.32 | 57.53 | 5.01 | 0.02 |
SO49094_17 | FEDE-45BA-90 | PO18705130501 | 19 | 291 | 329 | 479 | 6 | 2023-04-04 | 939.59 | 23.49 | 2023-03-23 | 2 | 486.71 | 1 | 939.59 | 17 | SO49094 | 2023-03-30 | 75.17 | 973.41 | 469.79 | |||
SO69479_1 | 3D8D-4908-A6 | PO18328116976 | 19 | 284 | 604 | 552 | 6 | 2024-07-02 | 323.99 | 8.10 | 2024-06-20 | 1 | 343.65 | 1 | 323.99 | 1 | SO69479 | 2024-06-27 | 25.92 | 343.65 | 323.99 | |||
SO45797_13 | B3FE-4436-96 | PO11049120115 | 19 | 284 | 334 | 679 | 6 | 2022-06-02 | 1677.84 | 41.95 | 2022-05-21 | 4 | 413.15 | 1 | 1677.84 | 13 | SO45797 | 2022-05-28 | 134.23 | 1652.59 | 419.46 | |||
SO67333_19 | B219-43D3-AA | PO4524133435 | 36 | 295 | 584 | 482 | 8 | 2024-06-02 | 1295.98 | 32.40 | 2024-05-21 | 4 | 343.65 | 1 | 1295.98 | 19 | SO67333 | 2024-05-28 | 103.68 | 1374.60 | 323.99 | |||
SO51154_28 | 2A76-4451-99 | PO7859157852 | 100 | 287 | 488 | 2 | 221 | 4 | 7.52 | 2023-09-01 | 375.77 | 9.21 | 2023-08-20 | 12 | 41.57 | 1 | 368.26 | 28 | SO51154 | 2023-08-27 | 29.46 | 498.87 | 31.31 | 0.02 |
SO71801_9 | 0DBE-43DA-9A | PO15515173664 | 100 | 292 | 605 | 481 | 7 | 2024-08-02 | 971.98 | 24.30 | 2024-07-21 | 3 | 343.65 | 1 | 971.98 | 9 | SO71801 | 2024-07-28 | 77.76 | 1030.95 | 323.99 | |||
SO55277_20 | E9AB-453F-BA | PO2552111630 | 100 | 286 | 357 | 506 | 1 | 2023-12-02 | 11135.95 | 278.40 | 2023-11-20 | 8 | 1265.62 | 1 | 11135.95 | 20 | SO55277 | 2023-11-27 | 890.88 | 10124.96 | 1391.99 | |||
SO63266_20 | 4D6E-4BF2-B9 | PO4466196255 | 19 | 291 | 589 | 352 | 6 | 2024-04-03 | 2770.16 | 69.25 | 2024-03-22 | 6 | 419.78 | 1 | 2770.16 | 20 | SO63266 | 2024-03-29 | 221.61 | 2518.67 | 461.69 | |||
SO71851_29 | AABE-4443-91 | PO18299133687 | 19 | 291 | 484 | 2 | 118 | 6 | 1.11 | 2024-08-02 | 55.33 | 1.36 | 2024-07-21 | 12 | 2.97 | 1 | 54.23 | 29 | SO71851 | 2024-07-28 | 4.34 | 35.68 | 4.61 | 0.02 |
SO46330_17 | 4E4A-4105-8E | PO18299117472 | 19 | 288 | 348 | 7 | 118 | 6 | 885.93 | 2022-08-02 | 2531.24 | 41.13 | 2022-07-21 | 3 | 1898.09 | 1 | 1645.31 | 17 | SO46330 | 2022-07-28 | 131.62 | 5694.28 | 843.75 | 0.35 |
SO57091_3 | 46C3-4CC4-85 | PO18792158206 | 100 | 283 | 593 | 378 | 2 | 2024-01-02 | 677.99 | 16.95 | 2023-12-21 | 2 | 308.22 | 1 | 677.99 | 3 | SO57091 | 2023-12-28 | 54.24 | 616.44 | 338.99 | |||
SO65310_2 | 65CB-474A-9D | PO6786169596 | 100 | 281 | 390 | 3 | 4 | 2024-05-02 | 672.29 | 16.81 | 2024-04-20 | 1 | 713.08 | 1 | 672.29 | 2 | SO65310 | 2024-04-27 | 53.78 | 713.08 | 672.29 | |||
SO48363_36 | A9C9-4B7B-9B | PO3915186343 | 100 | 283 | 377 | 130 | 4 | 2023-02-01 | 3926.81 | 98.17 | 2023-01-20 | 3 | 1320.68 | 1 | 3926.81 | 36 | SO48363 | 2023-01-27 | 314.15 | 3962.05 | 1308.94 | |||
SO71886_10 | AE34-4CC5-9B | PO6815136550 | 100 | 293 | 477 | 109 | 1 | 2024-08-02 | 17.96 | 0.45 | 2024-07-21 | 6 | 1.87 | 1 | 17.96 | 10 | SO71886 | 2024-07-28 | 1.44 | 11.20 | 2.99 | |||
SO55263_14 | 10F0-498D-AE | PO11136189942 | 19 | 284 | 552 | 120 | 6 | 2023-12-02 | 109.79 | 2.74 | 2023-11-20 | 2 | 40.62 | 1 | 109.79 | 14 | SO55263 | 2023-11-27 | 8.78 | 81.24 | 54.89 | |||
SO50226_49 | 75E5-4EFD-A7 | PO12499165634 | 100 | 282 | 323 | 78 | 4 | 2023-07-02 | 2818.76 | 70.47 | 2023-06-20 | 6 | 486.71 | 1 | 2818.76 | 49 | SO50226 | 2023-06-27 | 225.50 | 2920.24 | 469.79 | |||
SO46629_13 | E8D3-4649-8A | PO12412165004 | 100 | 283 | 422 | 670 | 3 | 2022-09-01 | 270.16 | 6.75 | 2022-08-20 | 4 | 49.98 | 1 | 270.16 | 13 | SO46629 | 2022-08-27 | 21.61 | 199.92 | 67.54 | |||
SO48048_49 | B414-46CB-BA | PO3480117933 | 100 | 283 | 370 | 436 | 4 | 2023-01-02 | 13194.09 | 329.85 | 2022-12-21 | 9 | 1518.79 | 1 | 13194.09 | 49 | SO48048 | 2022-12-28 | 1055.53 | 13669.08 | 1466.01 | |||
SO69435_4 | 4A7D-4B66-95 | PO13108171449 | 100 | 292 | 552 | 103 | 7 | 2024-07-02 | 109.79 | 2.74 | 2024-06-20 | 2 | 40.62 | 1 | 109.79 | 4 | SO69435 | 2024-06-27 | 8.78 | 81.24 | 54.89 | |||
SO47451_25 | 6525-4619-9A | PO8671131661 | 98 | 288 | 399 | 502 | 10 | 2022-11-02 | 270.20 | 6.75 | 2022-10-21 | 8 | 24.99 | 1 | 270.20 | 25 | SO47451 | 2022-10-28 | 21.62 | 199.95 | 33.77 | |||
SO50693_16 | 0DA5-4EE4-93 | PO841149385 | 100 | 286 | 399 | 254 | 1 | 2023-08-02 | 67.55 | 1.69 | 2023-07-21 | 2 | 24.99 | 1 | 67.55 | 16 | SO50693 | 2023-07-28 | 5.40 | 49.99 | 33.77 | |||
SO48325_7 | 0A85-48D3-97 | PO14268111638 | 100 | 283 | 377 | 418 | 3 | 2023-02-01 | 3926.81 | 98.17 | 2023-01-20 | 3 | 1320.68 | 1 | 3926.81 | 7 | SO48325 | 2023-01-27 | 314.15 | 3962.05 | 1308.94 | |||
SO58919_14 | AF42-4FCB-BB | PO17052190887 | 100 | 282 | 564 | 2 | 420 | 4 | 304.21 | 2024-02-01 | 15210.37 | 372.65 | 2024-01-20 | 11 | 1481.94 | 1 | 14906.16 | 14 | SO58919 | 2024-01-27 | 1192.49 | 16301.32 | 1382.76 | 0.02 |
SO55324_17 | 35BE-456A-B8 | PO8787146999 | 100 | 282 | 465 | 2 | 523 | 3 | 3.98 | 2023-12-02 | 198.86 | 4.87 | 2023-11-20 | 14 | 9.16 | 1 | 194.88 | 17 | SO55324 | 2023-11-27 | 15.59 | 128.23 | 14.20 | 0.02 |
SO50218_9 | B8E9-4FE2-8B | PO14442144367 | 100 | 293 | 360 | 127 | 1 | 2023-07-02 | 4917.84 | 122.95 | 2023-06-20 | 4 | 1105.81 | 1 | 4917.84 | 9 | SO50218 | 2023-06-27 | 393.43 | 4423.24 | 1229.46 | |||
SO47372_5 | 70B5-428B-86 | PO16124198007 | 100 | 282 | 422 | 649 | 4 | 2022-11-02 | 202.62 | 5.07 | 2022-10-21 | 3 | 49.98 | 1 | 202.62 | 5 | SO47372 | 2022-10-28 | 16.21 | 149.94 | 67.54 | |||
SO55253_1 | C58B-49D8-9F | PO12644132539 | 100 | 285 | 599 | 530 | 5 | 2023-12-02 | 647.99 | 16.20 | 2023-11-20 | 2 | 294.58 | 1 | 647.99 | 1 | SO55253 | 2023-11-27 | 51.84 | 589.16 | 323.99 | |||
SO47387_21 | 4FFC-4663-AC | PO13543169662 | 100 | 287 | 308 | 293 | 1 | 2022-11-02 | 1488.55 | 37.21 | 2022-10-21 | 2 | 660.91 | 1 | 1488.55 | 21 | SO47387 | 2022-10-28 | 119.08 | 1321.83 | 744.27 | |||
SO65271_16 | 11E0-45B2-93 | PO8468172113 | 98 | 288 | 483 | 16 | 10 | 2024-05-02 | 288.00 | 7.20 | 2024-04-20 | 4 | 44.88 | 1 | 288.00 | 16 | SO65271 | 2024-04-27 | 23.04 | 179.52 | 72.00 | |||
SO58926_8 | B82A-4380-9C | PO15486118845 | 100 | 292 | 298 | 121 | 7 | 2024-02-01 | 2429.28 | 60.73 | 2024-01-20 | 3 | 739.04 | 1 | 2429.28 | 8 | SO58926 | 2024-01-27 | 194.34 | 2217.12 | 809.76 |
Generated 2024-09-19 15:17:51.511 UTC