[ROOT] dt FactResellerSale WHERE DimSalesTerritoryId EQ '1' > SHUFFLE < SKIP 1600 > < 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 |
---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
SO44523_7 | BE2B-4DB0-8E | PO11919191573 | 100 | 286 | 346 | 73 | 1 | 2022-02-24 | 8159.98 | 204.00 | 2022-02-12 | 4 | 1912.15 | 1 | 8159.98 | 7 | SO44523 | 2022-02-19 | 652.80 | 7648.62 | 2039.99 | |||
SO46611_38 | 93A4-4A4D-99 | PO16588117269 | 100 | 289 | 470 | 4 | 146 | 1 | 64.58 | 2022-10-24 | 645.83 | 14.53 | 2022-10-12 | 34 | 15.67 | 1 | 581.25 | 38 | SO46611 | 2022-10-19 | 46.50 | 532.81 | 19.00 | 0.10 |
SO63133_23 | C3D9-4B73-83 | PO18618146912 | 100 | 286 | 564 | 605 | 1 | 2024-05-26 | 4291.33 | 107.28 | 2024-05-14 | 3 | 1481.94 | 1 | 4291.33 | 23 | SO63133 | 2024-05-21 | 343.31 | 4445.81 | 1430.44 | |||
SO50209_14 | D138-4E7C-86 | PO15573136083 | 100 | 293 | 457 | 487 | 1 | 2023-08-24 | 44.99 | 1.12 | 2023-08-12 | 1 | 30.93 | 1 | 44.99 | 14 | SO50209 | 2023-08-19 | 3.60 | 30.93 | 44.99 | |||
SO47403_41 | 60A2-4F08-8B | PO841143108 | 100 | 286 | 360 | 254 | 1 | 2022-12-25 | 4917.84 | 122.95 | 2022-12-13 | 4 | 1105.81 | 1 | 4917.84 | 41 | SO47403 | 2022-12-20 | 393.43 | 4423.24 | 1229.46 | |||
SO53603_9 | D324-4435-B1 | PO3277197939 | 100 | 293 | 605 | 604 | 1 | 2023-12-25 | 323.99 | 8.10 | 2023-12-13 | 1 | 343.65 | 1 | 323.99 | 9 | SO53603 | 2023-12-20 | 25.92 | 343.65 | 323.99 | |||
SO46025_2 | ADCD-4F7A-A7 | PO19981184028 | 100 | 286 | 342 | 271 | 1 | 2022-08-24 | 419.46 | 10.49 | 2022-08-12 | 1 | 413.15 | 1 | 419.46 | 2 | SO46025 | 2022-08-19 | 33.56 | 413.15 | 419.46 | |||
SO50297_44 | 5199-40AD-90 | PO4727113542 | 100 | 293 | 327 | 343 | 1 | 2023-08-24 | 939.59 | 23.49 | 2023-08-12 | 2 | 486.71 | 1 | 939.59 | 44 | SO50297 | 2023-08-19 | 75.17 | 973.41 | 469.79 | |||
SO48328_13 | 5992-4AF8-B1 | PO13543152596 | 100 | 287 | 410 | 293 | 1 | 2023-03-26 | 109.34 | 2.73 | 2023-03-14 | 3 | 26.97 | 1 | 109.34 | 13 | SO48328 | 2023-03-21 | 8.75 | 80.91 | 36.45 | |||
SO71904_21 | DBF0-4665-A7 | PO5017189568 | 100 | 289 | 564 | 308 | 1 | 2024-09-24 | 8582.65 | 214.57 | 2024-09-12 | 6 | 1481.94 | 1 | 8582.65 | 21 | SO71904 | 2024-09-19 | 686.61 | 8891.63 | 1430.44 | |||
SO43909_6 | 9467-4A37-A4 | PO7221199520 | 100 | 289 | 351 | 326 | 1 | 2021-11-24 | 6074.98 | 151.87 | 2021-11-12 | 3 | 1898.09 | 1 | 6074.98 | 6 | SO43909 | 2021-11-19 | 486.00 | 5694.28 | 2024.99 | |||
SO67322_13 | 1881-4634-82 | PO6612121393 | 100 | 286 | 565 | 110 | 1 | 2024-07-25 | 1781.64 | 44.54 | 2024-07-13 | 4 | 461.44 | 1 | 1781.64 | 13 | SO67322 | 2024-07-20 | 142.53 | 1845.78 | 445.41 | |||
SO61182_10 | C1B1-4DBF-A9 | PO16588179661 | 100 | 289 | 598 | 146 | 1 | 2024-04-25 | 647.99 | 16.20 | 2024-04-13 | 2 | 294.58 | 1 | 647.99 | 10 | SO61182 | 2024-04-20 | 51.84 | 589.16 | 323.99 | |||
SO50206_18 | 7656-4E84-B8 | PO16414158832 | 100 | 289 | 464 | 236 | 1 | 2023-08-24 | 56.52 | 1.41 | 2023-08-12 | 4 | 9.71 | 1 | 56.52 | 18 | SO50206 | 2023-08-19 | 4.52 | 38.85 | 14.13 | |||
SO44100_13 | D5BC-4BB2-BF | PO13543119495 | 100 | 287 | 232 | 293 | 1 | 2021-12-25 | 173.04 | 4.33 | 2021-12-13 | 6 | 31.72 | 1 | 173.04 | 13 | SO44100 | 2021-12-20 | 13.84 | 190.35 | 28.84 | |||
SO43671_6 | DFD9-41B7-94 | PO13978119376 | 100 | 289 | 328 | 200 | 1 | 2021-10-24 | 838.92 | 20.97 | 2021-10-12 | 2 | 413.15 | 1 | 838.92 | 6 | SO43671 | 2021-10-19 | 67.11 | 826.29 | 419.46 | |||
SO53613_3 | 4A10-4F98-84 | PO6815195063 | 100 | 293 | 551 | 109 | 1 | 2023-12-25 | 316.86 | 7.92 | 2023-12-13 | 2 | 144.59 | 1 | 316.86 | 3 | SO53613 | 2023-12-20 | 25.35 | 289.19 | 158.43 | |||
SO46944_23 | 7854-48E8-92 | PO18676186070 | 100 | 282 | 421 | 697 | 1 | 2022-11-24 | 1177.97 | 29.45 | 2022-11-12 | 6 | 145.28 | 1 | 1177.97 | 23 | SO46944 | 2022-11-19 | 94.24 | 871.70 | 196.33 | |||
SO43894_2 | 7DF2-4E54-B0 | PO2958194987 | 100 | 286 | 350 | 559 | 1 | 2021-11-24 | 4049.99 | 101.25 | 2021-11-12 | 2 | 1898.09 | 1 | 4049.99 | 2 | SO43894 | 2021-11-19 | 324.00 | 3796.19 | 2024.99 | |||
SO49849_10 | C8F3-4DDE-A6 | PO2552190786 | 100 | 286 | 366 | 506 | 1 | 2023-07-25 | 5831.95 | 145.80 | 2023-07-13 | 9 | 598.44 | 1 | 5831.95 | 10 | SO49849 | 2023-07-20 | 466.56 | 5385.92 | 647.99 | |||
SO51712_3 | 910D-4560-A7 | PO16675134576 | 100 | 293 | 487 | 361 | 1 | 2023-11-24 | 230.96 | 5.77 | 2023-11-12 | 7 | 20.57 | 1 | 230.96 | 3 | SO51712 | 2023-11-19 | 18.48 | 143.96 | 32.99 | |||
SO43849_10 | D0B8-4476-BA | PO18676186169 | 100 | 272 | 347 | 697 | 1 | 2021-11-24 | 4079.99 | 102.00 | 2021-11-12 | 2 | 1912.15 | 1 | 4079.99 | 10 | SO43849 | 2021-11-19 | 326.40 | 3824.31 | 2039.99 | |||
SO50715_3 | 2C43-4B41-B4 | PO14065128023 | 100 | 293 | 273 | 379 | 1 | 2023-09-24 | 809.33 | 20.23 | 2023-09-12 | 4 | 187.16 | 1 | 809.33 | 3 | SO50715 | 2023-09-19 | 64.75 | 748.63 | 202.33 | |||
SO50215_4 | 820D-41FC-BE | PO14529171237 | 100 | 293 | 468 | 289 | 1 | 2023-08-24 | 45.59 | 1.14 | 2023-08-12 | 2 | 15.67 | 1 | 45.59 | 4 | SO50215 | 2023-08-19 | 3.65 | 31.34 | 22.79 | |||
SO44492_14 | 8AF8-4DDE-A8 | PO18676158978 | 100 | 282 | 220 | 697 | 1 | 2022-02-24 | 20.19 | 0.50 | 2022-02-12 | 1 | 12.03 | 1 | 20.19 | 14 | SO44492 | 2022-02-19 | 1.61 | 12.03 | 20.19 | |||
SO47452_17 | 79C0-49E8-B3 | PO8903162839 | 100 | 286 | 343 | 235 | 1 | 2022-12-25 | 469.79 | 11.74 | 2022-12-13 | 1 | 486.71 | 1 | 469.79 | 17 | SO47452 | 2022-12-20 | 37.58 | 486.71 | 469.79 | |||
SO47066_6 | 5E42-48DE-80 | PO8816154123 | 100 | 289 | 333 | 218 | 1 | 2022-11-24 | 1409.38 | 35.23 | 2022-11-12 | 3 | 486.71 | 1 | 1409.38 | 6 | SO47066 | 2022-11-19 | 112.75 | 1460.12 | 469.79 | |||
SO47066_30 | 5E42-48DE-80 | PO8816154123 | 100 | 289 | 381 | 218 | 1 | 2022-11-24 | 1200.53 | 30.01 | 2022-11-12 | 2 | 605.65 | 1 | 1200.53 | 30 | SO47066 | 2022-11-19 | 96.04 | 1211.30 | 600.26 |
Generated 2024-11-11 05:53:55.530 UTC