[ROOT] dt FactResellerSale < WHERE DimProductId EQ ALL SHUFFLE < SKIP 1707 > < TAKE 28 >
28 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 |
---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
SO46358_5 | 3BC7-40F4-99 | PO1624111969 | 100 | 283 | 262 | 579 | 3 | 2022-09-27 | 735.75 | 18.39 | 2022-09-15 | 4 | 181.49 | 1 | 735.75 | 5 | SO46358 | 2022-09-22 | 58.86 | 725.94 | 183.94 | |||
SO58940_21 | 72B7-4C82-8A | PO13543115032 | 100 | 287 | 516 | 293 | 1 | 2024-03-28 | 140.90 | 3.52 | 2024-03-16 | 6 | 17.38 | 1 | 140.90 | 21 | SO58940 | 2024-03-23 | 11.27 | 104.27 | 23.48 | |||
SO69517_3 | B70F-4B16-A6 | PO5655130015 | 100 | 287 | 554 | 563 | 4 | 2024-08-27 | 54.94 | 1.37 | 2024-08-15 | 1 | 40.66 | 1 | 54.94 | 3 | SO69517 | 2024-08-22 | 4.40 | 40.66 | 54.94 | |||
SO47666_28 | 6551-4B29-BF | PO16588184420 | 100 | 289 | 428 | 146 | 1 | 2023-01-27 | 1464.79 | 36.62 | 2023-01-15 | 7 | 185.82 | 1 | 1464.79 | 28 | SO47666 | 2023-01-22 | 117.18 | 1300.74 | 209.26 | |||
SO47424_6 | 9DF2-4A59-AE | PO4089167750 | 100 | 285 | 470 | 368 | 5 | 2022-12-28 | 91.18 | 2.28 | 2022-12-16 | 4 | 15.67 | 1 | 91.18 | 6 | SO47424 | 2022-12-23 | 7.29 | 62.68 | 22.79 | |||
SO55300_23 | 40F4-470B-82 | PO8004112820 | 6 | 296 | 575 | 231 | 9 | 2024-01-27 | 4291.33 | 107.28 | 2024-01-15 | 3 | 1481.94 | 1 | 4291.33 | 23 | SO55300 | 2024-01-22 | 343.31 | 4445.81 | 1430.44 | |||
SO53497_9 | 1F74-43F0-9F | PO12673113349 | 100 | 292 | 287 | 2 | 499 | 7 | 43.03 | 2023-12-28 | 2151.46 | 52.71 | 2023-12-16 | 11 | 204.63 | 1 | 2108.43 | 9 | SO53497 | 2023-12-23 | 168.67 | 2250.88 | 195.59 | 0.02 |
SO65228_18 | 31AA-4A4E-AE | PO11397130924 | 36 | 295 | 592 | 176 | 8 | 2024-06-27 | 677.99 | 16.95 | 2024-06-15 | 2 | 308.22 | 1 | 677.99 | 18 | SO65228 | 2024-06-22 | 54.24 | 616.44 | 338.99 | |||
SO43694_9 | EC3D-48E0-A6 | PO9657130250 | 100 | 285 | 346 | 315 | 5 | 2021-10-27 | 4079.99 | 102.00 | 2021-10-15 | 2 | 1912.15 | 1 | 4079.99 | 9 | SO43694 | 2021-10-22 | 326.40 | 3824.31 | 2039.99 | |||
SO49495_12 | A868-43CF-A4 | PO9570115481 | 100 | 285 | 428 | 585 | 5 | 2023-06-27 | 209.26 | 5.23 | 2023-06-15 | 1 | 185.82 | 1 | 209.26 | 12 | SO49495 | 2023-06-22 | 16.74 | 185.82 | 209.26 | |||
SO53513_45 | 5E21-438C-B3 | PO10875194431 | 19 | 291 | 564 | 14 | 281 | 6 | 2479.43 | 2023-12-28 | 12397.16 | 247.94 | 2023-12-16 | 13 | 1481.94 | 1 | 9917.73 | 45 | SO53513 | 2023-12-23 | 793.42 | 19265.19 | 953.63 | 0.20 |
SO47033_28 | 2797-46ED-BB | PO4727113716 | 100 | 286 | 273 | 343 | 1 | 2022-11-27 | 809.33 | 20.23 | 2022-11-15 | 4 | 187.16 | 1 | 809.33 | 28 | SO47033 | 2022-11-22 | 64.75 | 748.63 | 202.33 | |||
SO65237_18 | 5F94-404B-AE | PO11455137092 | 100 | 283 | 287 | 72 | 2 | 2024-06-27 | 809.33 | 20.23 | 2024-06-15 | 4 | 204.63 | 1 | 809.33 | 18 | SO65237 | 2024-06-22 | 64.75 | 818.50 | 202.33 | |||
SO49512_4 | E722-4D76-AD | PO12354152645 | 100 | 283 | 366 | 197 | 3 | 2023-06-27 | 1943.98 | 48.60 | 2023-06-15 | 3 | 598.44 | 1 | 1943.98 | 4 | SO49512 | 2023-06-22 | 155.52 | 1795.31 | 647.99 | |||
SO48386_13 | 7AB1-4817-8F | PO8468170337 | 98 | 288 | 271 | 16 | 10 | 2023-03-29 | 607.00 | 15.17 | 2023-03-17 | 3 | 187.16 | 1 | 607.00 | 13 | SO48386 | 2023-03-24 | 48.56 | 561.47 | 202.33 | |||
SO51751_22 | 257C-4EC8-98 | PO11368156185 | 36 | 295 | 359 | 687 | 8 | 2023-11-27 | 4130.98 | 103.27 | 2023-11-15 | 3 | 1251.98 | 1 | 4130.98 | 22 | SO51751 | 2023-11-22 | 330.48 | 3755.94 | 1376.99 | |||
SO65189_3 | 985E-4937-94 | PO14761195376 | 19 | 284 | 492 | 408 | 6 | 2024-06-27 | 602.35 | 15.06 | 2024-06-15 | 1 | 601.74 | 1 | 602.35 | 3 | SO65189 | 2024-06-22 | 48.19 | 601.74 | 602.35 | |||
SO45069_9 | 720B-4C18-89 | PO5365112854 | 100 | 281 | 318 | 161 | 2 | 2022-04-29 | 874.79 | 21.87 | 2022-04-17 | 1 | 884.71 | 1 | 874.79 | 9 | SO45069 | 2022-04-24 | 69.98 | 884.71 | 874.79 | |||
SO71948_5 | DCEE-428D-87 | PO9599179297 | 100 | 285 | 604 | 170 | 5 | 2024-09-27 | 2267.96 | 56.70 | 2024-09-15 | 7 | 343.65 | 1 | 2267.96 | 5 | SO71948 | 2024-09-22 | 181.44 | 2405.55 | 323.99 | |||
SO67329_5 | EDD5-41CD-A3 | PO4872112080 | 36 | 295 | 483 | 86 | 8 | 2024-07-28 | 216.00 | 5.40 | 2024-07-16 | 3 | 44.88 | 1 | 216.00 | 5 | SO67329 | 2024-07-23 | 17.28 | 134.64 | 72.00 | |||
SO61188_3 | 0CFA-4338-90 | PO12528143455 | 100 | 282 | 586 | 331 | 4 | 2024-04-28 | 1336.23 | 33.41 | 2024-04-16 | 3 | 461.44 | 1 | 1336.23 | 3 | SO61188 | 2024-04-23 | 106.90 | 1384.33 | 445.41 | |||
SO48379_8 | 703B-461C-A7 | PO7018165155 | 100 | 283 | 469 | 695 | 3 | 2023-03-29 | 91.18 | 2.28 | 2023-03-17 | 4 | 15.67 | 1 | 91.18 | 8 | SO48379 | 2023-03-24 | 7.29 | 62.68 | 22.79 | |||
SO71902_38 | AEC9-4070-9D | PO5539125166 | 100 | 282 | 598 | 61 | 4 | 2024-09-27 | 647.99 | 16.20 | 2024-09-15 | 2 | 294.58 | 1 | 647.99 | 38 | SO71902 | 2024-09-22 | 51.84 | 589.16 | 323.99 | |||
SO71802_26 | 6B80-41A7-89 | PO15457184141 | 100 | 285 | 523 | 297 | 5 | 2024-09-27 | 63.17 | 1.58 | 2024-09-15 | 2 | 23.37 | 1 | 63.17 | 26 | SO71802 | 2024-09-22 | 5.05 | 46.74 | 31.58 | |||
SO71945_32 | 2AA4-4D12-9F | PO9396160769 | 6 | 296 | 225 | 267 | 9 | 2024-09-27 | 16.18 | 0.40 | 2024-09-15 | 3 | 6.92 | 1 | 16.18 | 32 | SO71945 | 2024-09-22 | 1.29 | 20.77 | 5.39 | |||
SO44752_6 | 584D-40E8-AF | PO15950187592 | 100 | 282 | 319 | 114 | 4 | 2022-03-29 | 3499.18 | 87.48 | 2022-03-17 | 4 | 884.71 | 1 | 3499.18 | 6 | SO44752 | 2022-03-24 | 279.93 | 3538.83 | 874.79 | |||
SO53518_6 | 5712-444B-BC | PO841197199 | 100 | 286 | 400 | 2 | 254 | 1 | 8.62 | 2023-12-28 | 430.96 | 10.56 | 2023-12-16 | 12 | 27.49 | 1 | 422.34 | 6 | SO53518 | 2023-12-23 | 33.79 | 329.91 | 35.91 | 0.02 |
SO48314_6 | A003-4969-BC | PO16124161457 | 100 | 282 | 221 | 649 | 4 | 2023-03-29 | 20.19 | 0.50 | 2023-03-17 | 1 | 13.88 | 1 | 20.19 | 6 | SO48314 | 2023-03-24 | 1.61 | 13.88 | 20.19 |
Generated 2024-11-14 05:14:08.238 UTC