[ROOT] dt FactResellerSale < WHERE DimSalesTerritoryId EQ ALL SHUFFLE < SKIP 3563 > < TAKE 31 >
31 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 |
---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
SO59075_24 | 1ED6-419E-AF | PO9628136689 | 100 | 283 | 570 | 179 | 2 | 2024-02-02 | 890.82 | 22.27 | 2024-01-21 | 2 | 461.44 | 1 | 890.82 | 24 | SO59075 | 2024-01-28 | 71.27 | 922.89 | 445.41 | |||
SO49472_5 | 653C-45A9-B1 | PO2697138792 | 100 | 282 | 410 | 187 | 4 | 2023-05-03 | 36.45 | 0.91 | 2023-04-21 | 1 | 26.97 | 1 | 36.45 | 5 | SO49472 | 2023-04-28 | 2.92 | 26.97 | 36.45 | |||
SO61264_4 | 5396-4F0C-B0 | PO5626112601 | 100 | 281 | 581 | 166 | 4 | 2024-03-04 | 2041.19 | 51.03 | 2024-02-21 | 2 | 1082.51 | 1 | 2041.19 | 4 | SO61264 | 2024-02-28 | 163.30 | 2165.02 | 1020.59 | |||
SO45328_3 | 2212-4E8E-82 | PO5684113284 | 100 | 282 | 351 | 385 | 4 | 2022-04-05 | 16199.95 | 405.00 | 2022-03-24 | 8 | 1898.09 | 1 | 16199.95 | 3 | SO45328 | 2022-03-31 | 1296.00 | 15184.76 | 2024.99 | |||
SO57130_19 | 2182-4ADD-88 | PO6148161629 | 100 | 289 | 495 | 693 | 1 | 2024-01-03 | 602.35 | 15.06 | 2023-12-22 | 1 | 601.74 | 1 | 602.35 | 19 | SO57130 | 2023-12-29 | 48.19 | 601.74 | 602.35 | |||
SO50321_5 | 6B3D-47E0-99 | PO8816191637 | 100 | 289 | 325 | 218 | 1 | 2023-07-03 | 1879.18 | 46.98 | 2023-06-21 | 4 | 486.71 | 1 | 1879.18 | 5 | SO50321 | 2023-06-28 | 150.33 | 1946.83 | 469.79 | |||
SO46093_5 | B221-4D2A-99 | PO6351171482 | 100 | 283 | 330 | 255 | 4 | 2022-07-03 | 838.92 | 20.97 | 2022-06-21 | 2 | 413.15 | 1 | 838.92 | 5 | SO46093 | 2022-06-28 | 67.11 | 826.29 | 419.46 | |||
SO71786_4 | 80E7-439C-8F | PO17690128583 | 19 | 291 | 475 | 47 | 6 | 2024-08-03 | 125.98 | 3.15 | 2024-07-22 | 3 | 26.18 | 1 | 125.98 | 4 | SO71786 | 2024-07-29 | 10.08 | 78.53 | 41.99 | |||
SO51124_39 | 5EEF-4271-BB | PO1711177181 | 19 | 291 | 353 | 2 | 245 | 6 | 376.77 | 2023-09-02 | 18838.32 | 461.54 | 2023-08-21 | 14 | 1265.62 | 1 | 18461.55 | 39 | SO51124 | 2023-08-28 | 1476.92 | 17718.67 | 1345.59 | 0.02 |
SO45337_9 | C8D2-41D4-AF | PO7598166612 | 100 | 285 | 328 | 45 | 5 | 2022-04-05 | 419.46 | 10.49 | 2022-03-24 | 1 | 413.15 | 1 | 419.46 | 9 | SO45337 | 2022-03-31 | 33.56 | 413.15 | 419.46 | |||
SO43898_9 | 420C-4ECE-85 | PO4901196283 | 19 | 284 | 220 | 84 | 6 | 2021-10-03 | 121.12 | 3.03 | 2021-09-21 | 6 | 12.03 | 1 | 121.12 | 9 | SO43898 | 2021-09-28 | 9.69 | 72.17 | 20.19 | |||
SO65158_22 | 3613-4FA2-B8 | PO19285194632 | 98 | 288 | 561 | 448 | 10 | 2024-05-03 | 5721.77 | 143.04 | 2024-04-21 | 4 | 1481.94 | 1 | 5721.77 | 22 | SO65158 | 2024-04-28 | 457.74 | 5927.75 | 1430.44 | |||
SO50313_36 | B452-44E9-91 | PO7656143984 | 100 | 282 | 464 | 403 | 4 | 2023-07-03 | 70.64 | 1.77 | 2023-06-21 | 5 | 9.71 | 1 | 70.64 | 36 | SO50313 | 2023-06-28 | 5.65 | 48.57 | 14.13 | |||
SO50683_6 | 8EBE-4D2C-AB | PO11455112273 | 100 | 283 | 273 | 2 | 72 | 2 | 43.03 | 2023-08-03 | 2151.46 | 52.71 | 2023-07-22 | 11 | 187.16 | 1 | 2108.43 | 6 | SO50683 | 2023-07-29 | 168.67 | 2058.73 | 195.59 | 0.02 |
SO63148_3 | 00FA-42B1-88 | PO16675153915 | 100 | 293 | 567 | 361 | 1 | 2024-04-04 | 445.41 | 11.14 | 2024-03-23 | 1 | 461.44 | 1 | 445.41 | 3 | SO63148 | 2024-03-30 | 35.63 | 461.44 | 445.41 | |||
SO49502_13 | 6C08-4C4C-B8 | PO14268145224 | 100 | 281 | 233 | 418 | 3 | 2023-05-03 | 28.84 | 0.72 | 2023-04-21 | 1 | 29.08 | 1 | 28.84 | 13 | SO49502 | 2023-04-28 | 2.31 | 29.08 | 28.84 | |||
SO71782_43 | CA08-4A9B-8D | PO19372114749 | 100 | 282 | 214 | 582 | 4 | 2024-08-03 | 62.98 | 1.57 | 2024-07-22 | 3 | 13.09 | 1 | 62.98 | 43 | SO71782 | 2024-07-29 | 5.04 | 39.26 | 20.99 | |||
SO53457_1 | B3F3-4A07-9B | PO19169151555 | 100 | 289 | 355 | 272 | 1 | 2023-11-03 | 5567.98 | 139.20 | 2023-10-22 | 4 | 1265.62 | 1 | 5567.98 | 1 | SO53457 | 2023-10-29 | 445.44 | 5062.48 | 1391.99 | |||
SO51734_13 | 9D8E-4873-8B | PO13427111801 | 100 | 292 | 483 | 638 | 7 | 2023-10-03 | 648.00 | 16.20 | 2023-09-21 | 9 | 44.88 | 1 | 648.00 | 13 | SO51734 | 2023-09-28 | 51.84 | 403.92 | 72.00 | |||
SO63188_3 | 4BD6-4AB7-A0 | PO16704191200 | 100 | 292 | 359 | 680 | 7 | 2024-04-04 | 2753.99 | 68.85 | 2024-03-23 | 2 | 1251.98 | 1 | 2753.99 | 3 | SO63188 | 2024-03-30 | 220.32 | 2503.96 | 1376.99 | |||
SO47018_40 | E622-43B1-98 | PO2523197473 | 100 | 287 | 230 | 167 | 4 | 2022-10-03 | 115.36 | 2.88 | 2022-09-21 | 4 | 29.08 | 1 | 115.36 | 40 | SO47018 | 2022-09-28 | 9.23 | 116.32 | 28.84 | |||
SO47712_15 | 299D-4C8A-BF | PO5626117491 | 100 | 283 | 273 | 166 | 4 | 2022-12-03 | 202.33 | 5.06 | 2022-11-21 | 1 | 187.16 | 1 | 202.33 | 15 | SO47712 | 2022-11-28 | 16.19 | 187.16 | 202.33 | |||
SO71943_14 | E676-4002-A7 | PO9309168525 | 100 | 293 | 564 | 55 | 1 | 2024-08-03 | 5721.77 | 143.04 | 2024-07-22 | 4 | 1481.94 | 1 | 5721.77 | 14 | SO71943 | 2024-07-29 | 457.74 | 5927.75 | 1430.44 | |||
SO57045_19 | 4D3C-4309-BE | PO14587121888 | 100 | 293 | 586 | 199 | 1 | 2024-01-03 | 890.82 | 22.27 | 2023-12-22 | 2 | 461.44 | 1 | 890.82 | 19 | SO57045 | 2023-12-29 | 71.27 | 922.89 | 445.41 | |||
SO53590_14 | E7FF-4C04-9E | PO4118162346 | 100 | 281 | 566 | 13 | 454 | 3 | 100.22 | 2023-11-03 | 668.12 | 14.20 | 2023-10-22 | 2 | 461.44 | 1 | 567.90 | 14 | SO53590 | 2023-10-29 | 45.43 | 922.89 | 334.06 | 0.15 |
SO47391_9 | 8A04-4F3F-97 | PO12673197440 | 100 | 292 | 329 | 499 | 7 | 2022-11-03 | 3288.56 | 82.21 | 2022-10-22 | 7 | 486.71 | 1 | 3288.56 | 9 | SO47391 | 2022-10-29 | 263.08 | 3406.95 | 469.79 | |||
SO51088_12 | 4E58-4FFA-9F | PO17197140322 | 100 | 283 | 290 | 125 | 2 | 2023-09-02 | 818.70 | 20.47 | 2023-08-21 | 1 | 747.20 | 1 | 818.70 | 12 | SO51088 | 2023-08-28 | 65.50 | 747.20 | 818.70 | |||
SO50753_3 | 8073-4F97-BA | PO7569170218 | 100 | 287 | 362 | 608 | 4 | 2023-08-03 | 2458.92 | 61.47 | 2023-07-22 | 2 | 1105.81 | 1 | 2458.92 | 3 | SO50753 | 2023-07-29 | 196.71 | 2211.62 | 1229.46 | |||
SO71949_8 | D52C-4E65-AA | PO9483195097 | 100 | 283 | 546 | 54 | 2 | 2024-08-03 | 111.76 | 2.79 | 2024-07-22 | 3 | 27.57 | 1 | 111.76 | 8 | SO71949 | 2024-07-29 | 8.94 | 82.70 | 37.25 | |||
SO51826_16 | DBF7-4FCA-86 | PO6148188136 | 100 | 289 | 495 | 693 | 1 | 2023-10-03 | 602.35 | 15.06 | 2023-09-21 | 1 | 601.74 | 1 | 602.35 | 16 | SO51826 | 2023-09-28 | 48.19 | 601.74 | 602.35 | |||
SO51717_2 | 9761-4974-87 | PO15254118280 | 100 | 283 | 434 | 377 | 3 | 2023-10-03 | 1070.69 | 26.77 | 2023-09-21 | 3 | 360.94 | 1 | 1070.69 | 2 | SO51717 | 2023-09-28 | 85.66 | 1082.83 | 356.90 |
Generated 2024-09-20 11:42:24.716 UTC