[ROOT] dt FactResellerSale < WHERE DimProductId EQ ALL SHUFFLE < SKIP 1631 > < 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 |
---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
SO58927_37 | BEF7-43AF-A2 | PO15515112432 | 100 | 292 | 481 | 481 | 7 | 2024-02-02 | 10.79 | 0.27 | 2024-01-21 | 2 | 3.36 | 1 | 10.79 | 37 | SO58927 | 2024-01-28 | 0.86 | 6.72 | 5.39 | |||
SO44798_6 | 301F-4820-92 | PO9541179114 | 100 | 285 | 235 | 279 | 5 | 2022-02-02 | 28.84 | 0.72 | 2022-01-21 | 1 | 31.72 | 1 | 28.84 | 6 | SO44798 | 2022-01-28 | 2.31 | 31.72 | 28.84 | |||
SO58940_2 | 72B7-4C82-8A | PO13543115032 | 100 | 287 | 306 | 293 | 1 | 2024-02-02 | 2429.28 | 60.73 | 2024-01-21 | 3 | 739.04 | 1 | 2429.28 | 2 | SO58940 | 2024-01-28 | 194.34 | 2217.12 | 809.76 | |||
SO51810_27 | 0D49-491D-BD | PO7453119597 | 100 | 283 | 472 | 108 | 2 | 2023-10-03 | 76.20 | 1.91 | 2023-09-21 | 2 | 23.75 | 1 | 76.20 | 27 | SO51810 | 2023-09-28 | 6.10 | 47.50 | 38.10 | |||
SO47039_19 | B548-493E-AE | PO5684166879 | 100 | 282 | 358 | 385 | 4 | 2022-10-03 | 4917.84 | 122.95 | 2022-09-21 | 4 | 1105.81 | 1 | 4917.84 | 19 | SO47039 | 2022-09-28 | 393.43 | 4423.24 | 1229.46 | |||
SO49893_39 | 99ED-4EEC-9C | PO8787173621 | 100 | 282 | 447 | 523 | 3 | 2023-06-03 | 30.00 | 0.75 | 2023-05-22 | 2 | 10.31 | 1 | 30.00 | 39 | SO49893 | 2023-05-29 | 2.40 | 20.63 | 15.00 | |||
SO65303_33 | 93EA-4158-A9 | PO5539133147 | 100 | 282 | 532 | 61 | 4 | 2024-05-03 | 149.87 | 3.75 | 2024-04-21 | 1 | 136.79 | 1 | 149.87 | 33 | SO65303 | 2024-04-28 | 11.99 | 136.79 | 149.87 | |||
SO57088_13 | EA31-4951-8A | PO2842199218 | 100 | 285 | 477 | 700 | 5 | 2024-01-03 | 8.98 | 0.22 | 2023-12-22 | 3 | 1.87 | 1 | 8.98 | 13 | SO57088 | 2023-12-29 | 0.72 | 5.60 | 2.99 | |||
SO50310_11 | FCBD-48EE-A9 | PO6438126969 | 100 | 281 | 468 | 309 | 4 | 2023-07-03 | 68.38 | 1.71 | 2023-06-21 | 3 | 15.67 | 1 | 68.38 | 11 | SO50310 | 2023-06-28 | 5.47 | 47.01 | 22.79 | |||
SO51127_20 | D321-4FEA-80 | PO2552155165 | 100 | 286 | 512 | 506 | 1 | 2023-09-02 | 218.45 | 5.46 | 2023-08-21 | 1 | 199.38 | 1 | 218.45 | 20 | SO51127 | 2023-08-28 | 17.48 | 199.38 | 218.45 | |||
SO65226_29 | 55DE-4772-82 | PO15515186601 | 100 | 292 | 214 | 481 | 7 | 2024-05-03 | 83.98 | 2.10 | 2024-04-21 | 4 | 13.09 | 1 | 83.98 | 29 | SO65226 | 2024-04-28 | 6.72 | 52.35 | 20.99 | |||
SO46673_28 | 578D-4F7B-A6 | PO9657163155 | 100 | 285 | 352 | 315 | 5 | 2022-09-02 | 2485.70 | 62.14 | 2022-08-21 | 2 | 1117.86 | 1 | 2485.70 | 28 | SO46673 | 2022-08-28 | 198.86 | 2235.71 | 1242.85 | |||
SO57026_13 | CD5A-4300-81 | PO16675118038 | 100 | 293 | 586 | 361 | 1 | 2024-01-03 | 890.82 | 22.27 | 2023-12-22 | 2 | 461.44 | 1 | 890.82 | 13 | SO57026 | 2023-12-29 | 71.27 | 922.89 | 445.41 | |||
SO45555_16 | B11A-41CE-84 | PO3248155143 | 100 | 282 | 347 | 366 | 4 | 2022-05-03 | 6119.98 | 153.00 | 2022-04-21 | 3 | 1912.15 | 1 | 6119.98 | 16 | SO45555 | 2022-04-28 | 489.60 | 5736.46 | 2039.99 | |||
SO49111_4 | FF3D-423F-98 | PO15921116106 | 100 | 287 | 333 | 77 | 4 | 2023-04-05 | 1409.38 | 35.23 | 2023-03-24 | 3 | 486.71 | 1 | 1409.38 | 4 | SO49111 | 2023-03-31 | 112.75 | 1460.12 | 469.79 | |||
SO57067_41 | 08F2-42FC-BE | PO11368183380 | 36 | 295 | 515 | 687 | 8 | 2024-01-03 | 32.54 | 0.81 | 2023-12-22 | 2 | 12.04 | 1 | 32.54 | 41 | SO57067 | 2023-12-29 | 2.60 | 24.08 | 16.27 | |||
SO51830_32 | EBE1-4015-AE | PO7627127132 | 100 | 272 | 471 | 2 | 433 | 1 | 9.58 | 2023-10-03 | 478.79 | 11.73 | 2023-09-21 | 13 | 23.75 | 1 | 469.21 | 32 | SO51830 | 2023-09-28 | 37.54 | 308.74 | 36.83 | 0.02 |
SO47438_1 | 69E0-4082-B4 | PO6757114691 | 100 | 283 | 428 | 21 | 4 | 2022-11-03 | 418.51 | 10.46 | 2022-10-22 | 2 | 185.82 | 1 | 418.51 | 1 | SO47438 | 2022-10-29 | 33.48 | 371.64 | 209.26 | |||
SO49518_5 | AF02-4E4D-BA | PO9483189305 | 100 | 283 | 331 | 54 | 2 | 2023-05-03 | 939.59 | 23.49 | 2023-04-21 | 2 | 486.71 | 1 | 939.59 | 5 | SO49518 | 2023-04-28 | 75.17 | 973.41 | 469.79 | |||
SO49058_8 | BD1B-4C7F-A9 | PO12499147561 | 100 | 282 | 236 | 78 | 4 | 2023-04-05 | 86.52 | 2.16 | 2023-03-24 | 3 | 29.08 | 1 | 86.52 | 8 | SO49058 | 2023-03-31 | 6.92 | 87.24 | 28.84 | |||
SO69492_1 | FD40-425E-B6 | PO11252160870 | 100 | 281 | 287 | 606 | 3 | 2024-07-03 | 607.00 | 15.17 | 2024-06-21 | 3 | 204.63 | 1 | 607.00 | 1 | SO69492 | 2024-06-28 | 48.56 | 613.88 | 202.33 | |||
SO63123_5 | ADA9-4CA6-94 | PO19923184888 | 100 | 283 | 544 | 18 | 3 | 2024-04-04 | 145.78 | 3.64 | 2024-03-23 | 3 | 35.96 | 1 | 145.78 | 5 | SO63123 | 2024-03-30 | 11.66 | 107.88 | 48.59 | |||
SO57105_31 | 3AE1-4A72-91 | PO18676113963 | 100 | 282 | 599 | 697 | 1 | 2024-01-03 | 323.99 | 8.10 | 2023-12-22 | 1 | 294.58 | 1 | 323.99 | 31 | SO57105 | 2023-12-29 | 25.92 | 294.58 | 323.99 | |||
SO47438_27 | 69E0-4082-B4 | PO6757114691 | 100 | 283 | 354 | 21 | 4 | 2022-11-03 | 2485.70 | 62.14 | 2022-10-22 | 2 | 1117.86 | 1 | 2485.70 | 27 | SO47438 | 2022-10-29 | 198.86 | 2235.71 | 1242.85 | |||
SO50203_14 | 821E-4862-9A | PO17603125956 | 19 | 284 | 333 | 2 | 12 | 6 | 118.07 | 2023-07-03 | 5903.74 | 144.64 | 2023-06-21 | 13 | 486.71 | 1 | 5785.67 | 14 | SO50203 | 2023-06-28 | 462.85 | 6327.19 | 454.13 | 0.02 |
SO49533_8 | 5895-4BD4-A3 | PO5597155395 | 100 | 281 | 470 | 75 | 4 | 2023-05-03 | 91.18 | 2.28 | 2023-04-21 | 4 | 15.67 | 1 | 91.18 | 8 | SO49533 | 2023-04-28 | 7.29 | 62.68 | 22.79 | |||
SO47965_23 | 953F-437D-84 | PO19546111394 | 100 | 285 | 371 | 206 | 5 | 2023-01-03 | 3926.81 | 98.17 | 2022-12-22 | 3 | 1320.68 | 1 | 3926.81 | 23 | SO47965 | 2022-12-29 | 314.15 | 3962.05 | 1308.94 | |||
SO71866_21 | 029A-46BE-80 | PO14297151936 | 100 | 285 | 555 | 627 | 5 | 2024-08-03 | 127.80 | 3.20 | 2024-07-22 | 2 | 47.29 | 1 | 127.80 | 21 | SO71866 | 2024-07-29 | 10.22 | 94.57 | 63.90 | |||
SO69418_34 | D0CE-41AD-AA | PO15370180703 | 100 | 281 | 531 | 381 | 3 | 2024-07-03 | 149.87 | 3.75 | 2024-06-21 | 1 | 136.79 | 1 | 149.87 | 34 | SO69418 | 2024-06-28 | 11.99 | 136.79 | 149.87 | |||
SO46625_7 | 361B-4CAF-A2 | PO13688113829 | 100 | 282 | 464 | 475 | 4 | 2022-09-02 | 56.52 | 1.41 | 2022-08-21 | 4 | 9.71 | 1 | 56.52 | 7 | SO46625 | 2022-08-28 | 4.52 | 38.85 | 14.13 | |||
SO49169_8 | 73B1-4F93-B6 | PO10121138908 | 100 | 283 | 323 | 684 | 2 | 2023-04-05 | 2818.76 | 70.47 | 2023-03-24 | 6 | 486.71 | 1 | 2818.76 | 8 | SO49169 | 2023-03-31 | 225.50 | 2920.24 | 469.79 | |||
SO51132_3 | D4A8-472C-A4 | PO18444136544 | 19 | 291 | 243 | 227 | 6 | 2023-09-02 | 3435.60 | 85.89 | 2023-08-21 | 4 | 868.63 | 1 | 3435.60 | 3 | SO51132 | 2023-08-28 | 274.85 | 3474.54 | 858.90 | |||
SO48764_27 | B2E5-4B83-BC | PO18444188685 | 19 | 291 | 333 | 227 | 6 | 2023-03-05 | 939.59 | 23.49 | 2023-02-21 | 2 | 486.71 | 1 | 939.59 | 27 | SO48764 | 2023-02-28 | 75.17 | 973.41 | 469.79 | |||
SO71839_4 | 8F89-4B1E-A8 | PO1537119063 | 100 | 285 | 506 | 611 | 5 | 2024-08-03 | 400.10 | 10.00 | 2024-07-22 | 2 | 199.85 | 1 | 400.10 | 4 | SO71839 | 2024-07-29 | 32.01 | 399.70 | 200.05 | |||
SO49831_47 | 8BCC-466B-AB | PO13688123267 | 100 | 282 | 364 | 475 | 4 | 2023-06-03 | 1295.99 | 32.40 | 2023-05-22 | 2 | 598.44 | 1 | 1295.99 | 47 | SO49831 | 2023-05-29 | 103.68 | 1196.87 | 647.99 | |||
SO61248_33 | 67A0-4D10-87 | PO4495126386 | 19 | 291 | 306 | 496 | 6 | 2024-03-04 | 1619.52 | 40.49 | 2024-02-21 | 2 | 739.04 | 1 | 1619.52 | 33 | SO61248 | 2024-02-28 | 129.56 | 1478.08 | 809.76 | |||
SO46948_25 | B040-4261-B3 | PO18386128096 | 100 | 281 | 221 | 558 | 2 | 2022-10-03 | 80.75 | 2.02 | 2022-09-21 | 4 | 13.88 | 1 | 80.75 | 25 | SO46948 | 2022-09-28 | 6.46 | 55.51 | 20.19 | |||
SO57137_36 | 9401-4518-A4 | PO6438194874 | 100 | 281 | 483 | 309 | 4 | 2024-01-03 | 288.00 | 7.20 | 2023-12-22 | 4 | 44.88 | 1 | 288.00 | 36 | SO57137 | 2023-12-29 | 23.04 | 179.52 | 72.00 | |||
SO51863_1 | 95F2-4901-BB | PO5046174812 | 100 | 289 | 588 | 596 | 1 | 2023-10-03 | 461.69 | 11.54 | 2023-09-21 | 1 | 419.78 | 1 | 461.69 | 1 | SO51863 | 2023-09-28 | 36.94 | 419.78 | 461.69 | |||
SO48761_1 | E39C-4A4E-A3 | PO15312195795 | 19 | 291 | 464 | 299 | 6 | 2023-03-05 | 70.64 | 1.77 | 2023-02-21 | 5 | 9.71 | 1 | 70.64 | 1 | SO48761 | 2023-02-28 | 5.65 | 48.57 | 14.13 | |||
SO46323_1 | 3AF8-4F1A-97 | PO20155112356 | 100 | 289 | 344 | 7 | 92 | 1 | 297.50 | 2022-08-03 | 850.00 | 13.81 | 2022-07-22 | 1 | 1912.15 | 1 | 552.50 | 1 | SO46323 | 2022-07-29 | 44.20 | 1912.15 | 850.00 | 0.35 |
SO57068_23 | 0E44-4044-B3 | PO11223190191 | 100 | 292 | 515 | 632 | 7 | 2024-01-03 | 48.82 | 1.22 | 2023-12-22 | 3 | 12.04 | 1 | 48.82 | 23 | SO57068 | 2023-12-29 | 3.91 | 36.12 | 16.27 | |||
SO49870_20 | 7E0A-4D6E-9E | PO6467181139 | 100 | 283 | 323 | 660 | 3 | 2023-06-03 | 1409.38 | 35.23 | 2023-05-22 | 3 | 486.71 | 1 | 1409.38 | 20 | SO49870 | 2023-05-29 | 112.75 | 1460.12 | 469.79 | |||
SO53460_52 | 3BD9-47C3-94 | PO19343112747 | 100 | 282 | 281 | 24 | 4 | 2023-11-03 | 809.33 | 20.23 | 2023-10-22 | 4 | 204.63 | 1 | 809.33 | 52 | SO53460 | 2023-10-29 | 64.75 | 818.50 | 202.33 | |||
SO49836_22 | 0E32-48F7-89 | PO12644185975 | 100 | 285 | 409 | 530 | 5 | 2023-06-03 | 209.26 | 5.23 | 2023-05-22 | 1 | 185.82 | 1 | 209.26 | 22 | SO49836 | 2023-05-29 | 16.74 | 185.82 | 209.26 | |||
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 | |||
SO49101_23 | 0549-4175-A0 | PO15573181395 | 100 | 293 | 397 | 487 | 1 | 2023-04-05 | 97.18 | 2.43 | 2023-03-24 | 4 | 17.98 | 1 | 97.18 | 23 | SO49101 | 2023-03-31 | 7.77 | 71.91 | 24.29 | |||
SO48048_47 | B414-46CB-BA | PO3480117933 | 100 | 283 | 213 | 436 | 4 | 2023-01-03 | 60.56 | 1.51 | 2022-12-22 | 3 | 13.88 | 1 | 60.56 | 47 | SO48048 | 2022-12-29 | 4.84 | 41.63 | 20.19 | |||
SO51131_12 | D489-4DF3-A2 | PO16298169856 | 100 | 287 | 576 | 3 | 599 | 4 | 1376.80 | 2023-09-02 | 27536.01 | 653.98 | 2023-08-21 | 21 | 1481.94 | 1 | 26159.21 | 12 | SO51131 | 2023-08-28 | 2092.74 | 31120.70 | 1311.24 | 0.05 |
SO63255_3 | AA89-4F8F-A0 | PO8555130097 | 98 | 288 | 474 | 250 | 10 | 2024-04-04 | 83.99 | 2.10 | 2024-03-23 | 2 | 26.18 | 1 | 83.99 | 3 | SO63255 | 2024-03-30 | 6.72 | 52.35 | 41.99 | |||
SO46974_17 | BEE6-4EC8-8E | PO14442112586 | 100 | 286 | 401 | 127 | 1 | 2022-10-03 | 131.20 | 3.28 | 2022-09-21 | 2 | 48.55 | 1 | 131.20 | 17 | SO46974 | 2022-09-28 | 10.50 | 97.09 | 65.60 | |||
SO49169_17 | 73B1-4F93-B6 | PO10121138908 | 100 | 283 | 415 | 684 | 2 | 2023-04-05 | 198.04 | 4.95 | 2023-03-24 | 1 | 146.55 | 1 | 198.04 | 17 | SO49169 | 2023-03-31 | 15.84 | 146.55 | 198.04 | |||
SO45796_8 | 8929-4623-95 | PO11861125955 | 100 | 281 | 344 | 17 | 5 | 2022-06-03 | 14279.96 | 357.00 | 2022-05-22 | 7 | 1912.15 | 1 | 14279.96 | 8 | SO45796 | 2022-05-29 | 1142.40 | 13385.08 | 2039.99 | |||
SO53460_30 | 3BD9-47C3-94 | PO19343112747 | 100 | 282 | 225 | 3 | 24 | 4 | 5.19 | 2023-11-03 | 103.83 | 2.47 | 2023-10-22 | 21 | 6.92 | 1 | 98.64 | 30 | SO53460 | 2023-10-29 | 7.89 | 145.37 | 4.94 | 0.05 |
SO55253_39 | C58B-49D8-9F | PO12644132539 | 100 | 285 | 214 | 530 | 5 | 2023-12-03 | 83.98 | 2.10 | 2023-11-21 | 4 | 13.09 | 1 | 83.98 | 39 | SO55253 | 2023-11-28 | 6.72 | 52.35 | 20.99 | |||
SO44295_8 | DEAE-4D52-B8 | PO12760122918 | 19 | 288 | 315 | 83 | 6 | 2021-12-03 | 2624.38 | 65.61 | 2021-11-21 | 3 | 884.71 | 1 | 2624.38 | 8 | SO44295 | 2021-11-28 | 209.95 | 2654.12 | 874.79 |
Generated 2024-09-20 14:39:01.626 UTC