[ROOT] dt FactResellerSale < WHERE DimProductId EQ ALL SHUFFLE < SKIP 1951 > < TAKE 56 >
56 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 |
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
| SO51172_5 | 09C7-45AC-9A | PO5916165378 | 36 | 295 | 240 | 392 | 8 | 2023-10-23 | 858.90 | 21.47 | 2023-10-11 | 1 | 868.63 | 2 | 858.90 | 5 | SO51172 | 2023-10-18 | 68.71 | 868.63 | 858.90 | |||
| SO71785_19 | 28F9-4101-A1 | PO19169115427 | 100 | 289 | 357 | 272 | 1 | 2024-09-23 | 2783.99 | 69.60 | 2024-09-11 | 2 | 1265.62 | 1 | 2783.99 | 19 | SO71785 | 2024-09-18 | 222.72 | 2531.24 | 1391.99 | |||
| SO44773_3 | D4D3-4657-AC | PO1740125070 | 19 | 288 | 223 | 460 | 6 | 2022-03-25 | 20.75 | 0.52 | 2022-03-13 | 4 | 5.71 | 1 | 20.75 | 3 | SO44773 | 2022-03-20 | 1.66 | 22.82 | 5.19 | |||
| SO57065_12 | B68A-407E-99 | PO11658151711 | 100 | 283 | 517 | 233 | 2 | 2024-02-23 | 31.58 | 0.79 | 2024-02-11 | 1 | 23.37 | 1 | 31.58 | 12 | SO57065 | 2024-02-18 | 2.53 | 23.37 | 31.58 | |||
| SO65209_6 | B869-4DFD-AB | PO2697179473 | 100 | 282 | 558 | 187 | 4 | 2024-06-23 | 242.99 | 6.07 | 2024-06-11 | 1 | 179.82 | 1 | 242.99 | 6 | SO65209 | 2024-06-18 | 19.44 | 179.82 | 242.99 | |||
| SO46944_21 | 7854-48E8-92 | PO18676186070 | 100 | 282 | 469 | 697 | 1 | 2022-11-23 | 113.97 | 2.85 | 2022-11-11 | 5 | 15.67 | 1 | 113.97 | 21 | SO46944 | 2022-11-18 | 9.12 | 78.35 | 22.79 | |||
| SO67278_34 | 22C9-42E1-BC | PO12441152483 | 36 | 295 | 487 | 302 | 8 | 2024-07-24 | 230.96 | 5.77 | 2024-07-12 | 7 | 20.57 | 1 | 230.96 | 34 | SO67278 | 2024-07-19 | 18.48 | 143.96 | 32.99 | |||
| SO46384_11 | 9F38-4366-91 | PO9541189751 | 100 | 285 | 232 | 279 | 5 | 2022-09-23 | 86.52 | 2.16 | 2022-09-11 | 3 | 31.72 | 1 | 86.52 | 11 | SO46384 | 2022-09-18 | 6.92 | 95.17 | 28.84 | |||
| SO45571_19 | BAA6-412D-87 | PO7569141774 | 100 | 287 | 346 | 608 | 4 | 2022-06-23 | 10199.97 | 255.00 | 2022-06-11 | 5 | 1912.15 | 1 | 10199.97 | 19 | SO45571 | 2022-06-18 | 816.00 | 9560.77 | 2039.99 | |||
| SO48750_1 | 9A71-449E-B6 | PO14732147398 | 19 | 291 | 224 | 514 | 6 | 2023-04-25 | 5.19 | 0.13 | 2023-04-13 | 1 | 5.23 | 1 | 5.19 | 1 | SO48750 | 2023-04-20 | 0.41 | 5.23 | 5.19 | |||
| SO48360_6 | 5091-4B56-A9 | PO3103179096 | 100 | 283 | 333 | 147 | 3 | 2023-03-25 | 1879.18 | 46.98 | 2023-03-13 | 4 | 486.71 | 1 | 1879.18 | 6 | SO48360 | 2023-03-20 | 150.33 | 1946.83 | 469.79 | |||
| SO51154_25 | 2A76-4451-99 | PO7859157852 | 100 | 287 | 463 | 2 | 221 | 4 | 3.12 | 2023-10-23 | 156.25 | 3.83 | 2023-10-11 | 11 | 9.16 | 1 | 153.12 | 25 | SO51154 | 2023-10-18 | 12.25 | 100.75 | 14.20 | 0.02 |
| SO53472_4 | 892C-445A-B6 | PO16501111174 | 98 | 288 | 520 | 142 | 10 | 2023-12-24 | 31.58 | 0.79 | 2023-12-12 | 1 | 23.37 | 1 | 31.58 | 4 | SO53472 | 2023-12-19 | 2.53 | 23.37 | 31.58 | |||
| SO47996_2 | B6EA-4582-9E | PO15370152849 | 100 | 283 | 297 | 381 | 3 | 2023-02-23 | 736.15 | 18.40 | 2023-02-11 | 1 | 653.70 | 1 | 736.15 | 2 | SO47996 | 2023-02-18 | 58.89 | 653.70 | 736.15 | |||
| SO47391_23 | 8A04-4F3F-97 | PO12673197440 | 100 | 292 | 433 | 499 | 7 | 2022-12-24 | 1946.72 | 48.67 | 2022-12-12 | 6 | 300.12 | 1 | 1946.72 | 23 | SO47391 | 2022-12-19 | 155.74 | 1800.71 | 324.45 | |||
| SO46942_4 | B18D-4253-81 | PO18647164826 | 100 | 282 | 419 | 583 | 4 | 2022-11-23 | 52.65 | 1.32 | 2022-11-11 | 1 | 38.96 | 1 | 52.65 | 4 | SO46942 | 2022-11-18 | 4.21 | 38.96 | 52.65 | |||
| SO51712_35 | 910D-4560-A7 | PO16675134576 | 100 | 293 | 565 | 13 | 361 | 1 | 100.22 | 2023-11-23 | 668.12 | 14.20 | 2023-11-11 | 2 | 461.44 | 1 | 567.90 | 35 | SO51712 | 2023-11-18 | 45.43 | 922.89 | 334.06 | 0.15 |
| SO69544_13 | 89F3-4833-92 | PO3625111592 | 100 | 283 | 287 | 666 | 2 | 2024-08-23 | 404.66 | 10.12 | 2024-08-11 | 2 | 204.63 | 1 | 404.66 | 13 | SO69544 | 2024-08-18 | 32.37 | 409.25 | 202.33 | |||
| SO46042_20 | FE13-4E1B-A4 | PO16646156443 | 100 | 286 | 326 | 1 | 1 | 2022-08-23 | 838.92 | 20.97 | 2022-08-11 | 2 | 413.15 | 1 | 838.92 | 20 | SO46042 | 2022-08-18 | 67.11 | 826.29 | 419.46 | |||
| SO47354_25 | 6E1C-48C6-89 | PO19401144959 | 19 | 291 | 414 | 173 | 6 | 2022-12-24 | 149.03 | 3.73 | 2022-12-12 | 1 | 110.28 | 1 | 149.03 | 25 | SO47354 | 2022-12-19 | 11.92 | 110.28 | 149.03 | |||
| SO58920_43 | 944F-4219-85 | PO16501139645 | 98 | 288 | 487 | 142 | 10 | 2024-03-24 | 131.98 | 3.30 | 2024-03-12 | 4 | 20.57 | 1 | 131.98 | 43 | SO58920 | 2024-03-19 | 10.56 | 82.27 | 32.99 | |||
| SO53527_25 | 0EBE-4ACB-B5 | PO1798140946 | 19 | 291 | 590 | 10 | 6 | 2023-12-24 | 2770.16 | 69.25 | 2023-12-12 | 6 | 419.78 | 1 | 2770.16 | 25 | SO53527 | 2023-12-19 | 221.61 | 2518.67 | 461.69 | |||
| SO59021_3 | A306-4E83-B7 | PO7395154426 | 100 | 286 | 544 | 542 | 1 | 2024-03-24 | 97.19 | 2.43 | 2024-03-12 | 2 | 35.96 | 1 | 97.19 | 3 | SO59021 | 2024-03-19 | 7.78 | 71.92 | 48.59 | |||
| SO47670_49 | 0CD2-463E-8F | PO14732184884 | 19 | 291 | 331 | 514 | 6 | 2023-01-23 | 469.79 | 11.74 | 2023-01-11 | 1 | 486.71 | 1 | 469.79 | 49 | SO47670 | 2023-01-18 | 37.58 | 486.71 | 469.79 | |||
| SO47447_53 | 5913-43AF-8D | PO8468183786 | 98 | 288 | 373 | 16 | 10 | 2022-12-24 | 7853.63 | 196.34 | 2022-12-12 | 6 | 1320.68 | 1 | 7853.63 | 53 | SO47447 | 2022-12-19 | 628.29 | 7924.10 | 1308.94 | |||
| SO69448_5 | 26BF-4CA1-97 | PO11020118669 | 19 | 284 | 605 | 336 | 6 | 2024-08-23 | 647.99 | 16.20 | 2024-08-11 | 2 | 343.65 | 1 | 647.99 | 5 | SO69448 | 2024-08-18 | 51.84 | 687.30 | 323.99 | |||
| SO51113_15 | C890-4CA6-90 | PO11136135505 | 19 | 284 | 573 | 120 | 6 | 2023-10-23 | 1430.44 | 35.76 | 2023-10-11 | 1 | 1481.94 | 1 | 1430.44 | 15 | SO51113 | 2023-10-18 | 114.44 | 1481.94 | 1430.44 | |||
| SO69429_8 | 3A09-48B2-AA | PO13369166572 | 100 | 292 | 545 | 391 | 7 | 2024-08-23 | 48.59 | 1.21 | 2024-08-11 | 2 | 17.98 | 1 | 48.59 | 8 | SO69429 | 2024-08-18 | 3.89 | 35.96 | 24.29 | |||
| SO50322_37 | 4BC2-4C6D-83 | PO8845166508 | 100 | 282 | 420 | 546 | 3 | 2023-08-23 | 141.62 | 3.54 | 2023-08-11 | 1 | 104.80 | 1 | 141.62 | 37 | SO50322 | 2023-08-18 | 11.33 | 104.80 | 141.62 | |||
| SO58925_1 | ACBD-43C3-A2 | PO15544139465 | 19 | 284 | 555 | 282 | 6 | 2024-03-24 | 63.90 | 1.60 | 2024-03-12 | 1 | 47.29 | 1 | 63.90 | 1 | SO58925 | 2024-03-19 | 5.11 | 47.29 | 63.90 | |||
| SO61229_30 | AC88-46DA-A3 | PO10324197030 | 98 | 288 | 309 | 196 | 10 | 2024-04-24 | 3274.80 | 81.87 | 2024-04-12 | 4 | 747.20 | 1 | 3274.80 | 30 | SO61229 | 2024-04-19 | 261.98 | 2988.80 | 818.70 | |||
| SO47355_21 | 6B7D-4E47-B5 | PO19343125466 | 100 | 282 | 333 | 24 | 4 | 2022-12-24 | 2818.76 | 70.47 | 2022-12-12 | 6 | 486.71 | 1 | 2818.76 | 21 | SO47355 | 2022-12-19 | 225.50 | 2920.24 | 469.79 | |||
| SO46940_13 | 6ADC-4363-B3 | PO18705126181 | 19 | 291 | 377 | 479 | 6 | 2022-11-23 | 2617.88 | 65.45 | 2022-11-11 | 2 | 1320.68 | 1 | 2617.88 | 13 | SO46940 | 2022-11-18 | 209.43 | 2641.37 | 1308.94 | |||
| SO63125_5 | F7DD-4FA0-B5 | PO18792150789 | 100 | 283 | 551 | 378 | 2 | 2024-05-25 | 158.43 | 3.96 | 2024-05-13 | 1 | 144.59 | 1 | 158.43 | 5 | SO63125 | 2024-05-20 | 12.67 | 144.59 | 158.43 | |||
| SO53540_11 | 1C52-4046-BA | PO18241135767 | 100 | 285 | 572 | 13 | 477 | 5 | 50.11 | 2023-12-24 | 334.06 | 7.10 | 2023-12-12 | 1 | 461.44 | 1 | 283.95 | 11 | SO53540 | 2023-12-19 | 22.72 | 461.44 | 334.06 | 0.15 |
| SO53483_32 | A0BE-40E0-81 | PO14761137153 | 19 | 284 | 492 | 408 | 6 | 2023-12-24 | 1204.69 | 30.12 | 2023-12-12 | 2 | 601.74 | 1 | 1204.69 | 32 | SO53483 | 2023-12-19 | 96.38 | 1203.49 | 602.35 | |||
| SO47724_1 | FDA2-4CD7-92 | PO8787160870 | 100 | 282 | 375 | 523 | 3 | 2023-01-23 | 3926.81 | 98.17 | 2023-01-11 | 3 | 1320.68 | 1 | 3926.81 | 1 | SO47724 | 2023-01-18 | 314.15 | 3962.05 | 1308.94 | |||
| SO48341_29 | A747-471B-97 | PO10701176180 | 100 | 282 | 294 | 133 | 4 | 2023-03-25 | 3721.36 | 93.03 | 2023-03-13 | 5 | 660.91 | 1 | 3721.36 | 29 | SO48341 | 2023-03-20 | 297.71 | 3304.57 | 744.27 | |||
| SO50293_20 | D649-4CE8-91 | PO3596144572 | 100 | 285 | 401 | 476 | 5 | 2023-08-23 | 65.60 | 1.64 | 2023-08-11 | 1 | 48.55 | 1 | 65.60 | 20 | SO50293 | 2023-08-18 | 5.25 | 48.55 | 65.60 | |||
| SO59027_21 | C142-4AAA-AB | PO6757122081 | 100 | 281 | 512 | 21 | 4 | 2024-03-24 | 655.36 | 16.38 | 2024-03-12 | 3 | 199.38 | 1 | 655.36 | 21 | SO59027 | 2024-03-19 | 52.43 | 598.13 | 218.45 | |||
| SO44772_8 | F5E6-4B81-A3 | PO1624122637 | 100 | 283 | 316 | 579 | 3 | 2022-03-25 | 2624.38 | 65.61 | 2022-03-13 | 3 | 884.71 | 1 | 2624.38 | 8 | SO44772 | 2022-03-20 | 209.95 | 2654.12 | 874.79 | |||
| SO49066_20 | 4065-4B0A-A2 | PO1595117888 | 19 | 284 | 236 | 426 | 6 | 2023-05-26 | 28.84 | 0.72 | 2023-05-14 | 1 | 29.08 | 1 | 28.84 | 20 | SO49066 | 2023-05-21 | 2.31 | 29.08 | 28.84 | |||
| SO65250_24 | B44C-40C3-83 | PO11774180512 | 6 | 296 | 560 | 682 | 9 | 2024-06-23 | 2186.73 | 54.67 | 2024-06-11 | 3 | 755.15 | 1 | 2186.73 | 24 | SO65250 | 2024-06-18 | 174.94 | 2265.45 | 728.91 | |||
| SO48307_12 | 7DE5-4D74-A7 | PO17545123793 | 19 | 291 | 333 | 155 | 6 | 2023-03-25 | 1409.38 | 35.23 | 2023-03-13 | 3 | 486.71 | 1 | 1409.38 | 12 | SO48307 | 2023-03-20 | 112.75 | 1460.12 | 469.79 | |||
| SO47439_32 | D4B6-4746-BE | PO6786128920 | 100 | 283 | 433 | 3 | 4 | 2022-12-24 | 1946.72 | 48.67 | 2022-12-12 | 6 | 300.12 | 1 | 1946.72 | 32 | SO47439 | 2022-12-19 | 155.74 | 1800.71 | 324.45 | |||
| SO46930_9 | 73DA-4549-8B | PO20039167979 | 19 | 291 | 420 | 65 | 6 | 2022-11-23 | 566.46 | 14.16 | 2022-11-11 | 4 | 104.80 | 1 | 566.46 | 9 | SO46930 | 2022-11-18 | 45.32 | 419.18 | 141.62 | |||
| SO46100_14 | 58B8-4157-97 | PO7627134166 | 100 | 286 | 232 | 433 | 1 | 2022-08-23 | 28.84 | 0.72 | 2022-08-11 | 1 | 31.72 | 1 | 28.84 | 14 | SO46100 | 2022-08-18 | 2.31 | 31.72 | 28.84 | |||
| SO47033_50 | 2797-46ED-BB | PO4727113716 | 100 | 286 | 383 | 343 | 1 | 2022-11-23 | 1800.79 | 45.02 | 2022-11-11 | 3 | 605.65 | 1 | 1800.79 | 50 | SO47033 | 2022-11-18 | 144.06 | 1816.95 | 600.26 | |||
| SO50214_15 | 97D5-41D3-8F | PO15196120916 | 100 | 282 | 414 | 258 | 4 | 2023-08-23 | 298.06 | 7.45 | 2023-08-11 | 2 | 110.28 | 1 | 298.06 | 15 | SO50214 | 2023-08-18 | 23.85 | 220.57 | 149.03 | |||
| SO58969_8 | A453-4A31-B6 | PO1450136230 | 100 | 292 | 234 | 571 | 7 | 2024-03-24 | 209.96 | 5.25 | 2024-03-12 | 7 | 38.49 | 1 | 209.96 | 8 | SO58969 | 2024-03-19 | 16.80 | 269.45 | 29.99 | |||
| SO46967_19 | 6486-4AF8-A6 | PO15573116583 | 100 | 286 | 230 | 487 | 1 | 2022-11-23 | 173.04 | 4.33 | 2022-11-11 | 6 | 29.08 | 1 | 173.04 | 19 | SO46967 | 2022-11-18 | 13.84 | 174.48 | 28.84 | |||
| SO51721_7 | 9429-430D-89 | PO14500124798 | 100 | 282 | 601 | 650 | 1 | 2023-11-23 | 226.76 | 5.67 | 2023-11-11 | 7 | 23.97 | 1 | 226.76 | 7 | SO51721 | 2023-11-18 | 18.14 | 167.80 | 32.39 | |||
| SO53598_7 | 6B0D-4AF3-AB | PO174179317 | 100 | 282 | 546 | 277 | 4 | 2023-12-24 | 149.02 | 3.73 | 2023-12-12 | 4 | 27.57 | 1 | 149.02 | 7 | SO53598 | 2023-12-19 | 11.92 | 110.27 | 37.25 | |||
| SO51844_10 | DE76-4481-AA | PO4553182082 | 100 | 282 | 580 | 313 | 4 | 2023-11-23 | 1020.59 | 25.51 | 2023-11-11 | 1 | 1082.51 | 1 | 1020.59 | 10 | SO51844 | 2023-11-18 | 81.65 | 1082.51 | 1020.59 | |||
| SO49877_15 | 493D-497C-AB | PO3828147687 | 100 | 283 | 365 | 414 | 2 | 2023-07-24 | 1295.99 | 32.40 | 2023-07-12 | 2 | 598.44 | 1 | 1295.99 | 15 | SO49877 | 2023-07-19 | 103.68 | 1196.87 | 647.99 | |||
| SO53614_33 | A1C5-4C4D-9C | PO6757196330 | 100 | 281 | 512 | 21 | 4 | 2023-12-24 | 873.82 | 21.85 | 2023-12-12 | 4 | 199.38 | 1 | 873.82 | 33 | SO53614 | 2023-12-19 | 69.91 | 797.50 | 218.45 |
Generated 2024-11-11 01:16:34.322 UTC