[ROOT] dt FactResellerSale WHERE DimSalesTerritoryId EQ '1' > SHUFFLE < SKIP 7170 > < TAKE 30 >
30 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 |
---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
SO67294_16 | 85E2-46A1-BE | PO899165491 | 100 | 289 | 487 | 2 | 290 | 1 | 7.65 | 2024-06-03 | 382.73 | 9.38 | 2024-05-22 | 12 | 20.57 | 1 | 375.08 | 16 | SO67294 | 2024-05-29 | 30.01 | 246.80 | 31.89 | 0.02 |
SO49053_42 | 5BE4-4969-A1 | PO16414175823 | 100 | 289 | 397 | 236 | 1 | 2023-04-05 | 121.47 | 3.04 | 2023-03-24 | 5 | 17.98 | 1 | 121.47 | 42 | SO49053 | 2023-03-31 | 9.72 | 89.89 | 24.29 | |||
SO47694_5 | 8253-4E13-9D | PO899122764 | 100 | 289 | 325 | 290 | 1 | 2022-12-03 | 4697.94 | 117.45 | 2022-11-21 | 10 | 486.71 | 1 | 4697.94 | 5 | SO47694 | 2022-11-28 | 375.84 | 4867.07 | 469.79 | |||
SO59059_15 | FD9E-44C4-97 | PO7482187440 | 100 | 293 | 493 | 163 | 1 | 2024-02-02 | 400.10 | 10.00 | 2024-01-21 | 2 | 199.85 | 1 | 400.10 | 15 | SO59059 | 2024-01-28 | 32.01 | 399.70 | 200.05 | |||
SO69471_20 | 2CF9-42DE-B1 | PO18676191433 | 100 | 282 | 587 | 697 | 1 | 2024-07-03 | 3231.86 | 80.80 | 2024-06-21 | 7 | 419.78 | 1 | 3231.86 | 20 | SO69471 | 2024-06-28 | 258.55 | 2938.45 | 461.69 | |||
SO49163_3 | DE2F-4D6A-99 | PO7917119932 | 100 | 287 | 470 | 401 | 1 | 2023-04-05 | 182.35 | 4.56 | 2023-03-24 | 8 | 15.67 | 1 | 182.35 | 3 | SO49163 | 2023-03-31 | 14.59 | 125.37 | 22.79 | |||
SO47442_2 | A001-44B5-B6 | PO7395183872 | 100 | 286 | 409 | 542 | 1 | 2022-11-03 | 209.26 | 5.23 | 2022-10-22 | 1 | 185.82 | 1 | 209.26 | 2 | SO47442 | 2022-10-29 | 16.74 | 185.82 | 209.26 | |||
SO46972_2 | 1A21-419F-8D | PO14500164221 | 100 | 282 | 396 | 650 | 1 | 2022-10-03 | 74.84 | 1.87 | 2022-09-21 | 1 | 55.38 | 1 | 74.84 | 2 | SO46972 | 2022-09-28 | 5.99 | 55.38 | 74.84 | |||
SO47054_9 | E4B1-4C58-AE | PO7627150376 | 100 | 286 | 368 | 433 | 1 | 2022-10-03 | 4398.03 | 109.95 | 2022-09-21 | 3 | 1518.79 | 1 | 4398.03 | 9 | SO47054 | 2022-09-28 | 351.84 | 4556.36 | 1466.01 | |||
SO50218_21 | B8E9-4FE2-8B | PO14442144367 | 100 | 293 | 458 | 127 | 1 | 2023-07-03 | 359.95 | 9.00 | 2023-06-21 | 8 | 30.93 | 1 | 359.95 | 21 | SO50218 | 2023-06-28 | 28.80 | 247.47 | 44.99 | |||
SO50217_14 | 6AE5-491F-B6 | PO14500116814 | 100 | 282 | 409 | 650 | 1 | 2023-07-03 | 209.26 | 5.23 | 2023-06-21 | 1 | 185.82 | 1 | 209.26 | 14 | SO50217 | 2023-06-28 | 16.74 | 185.82 | 209.26 | |||
SO47698_15 | 3841-4995-8C | PO2552129685 | 100 | 286 | 420 | 506 | 1 | 2022-12-03 | 708.08 | 17.70 | 2022-11-21 | 5 | 104.80 | 1 | 708.08 | 15 | SO47698 | 2022-11-28 | 56.65 | 523.98 | 141.62 | |||
SO48741_5 | 5AA4-4194-B9 | PO899196006 | 100 | 289 | 383 | 290 | 1 | 2023-03-05 | 4201.84 | 105.05 | 2023-02-21 | 7 | 605.65 | 1 | 4201.84 | 5 | SO48741 | 2023-02-28 | 336.15 | 4239.54 | 600.26 | |||
SO65263_18 | C0DD-4323-8C | PO7395113656 | 100 | 286 | 511 | 542 | 1 | 2024-05-03 | 218.45 | 5.46 | 2024-04-21 | 1 | 199.38 | 1 | 218.45 | 18 | SO65263 | 2024-04-28 | 17.48 | 199.38 | 218.45 | |||
SO51789_35 | A5AF-4504-83 | PO18618169495 | 100 | 286 | 463 | 605 | 1 | 2023-10-03 | 117.55 | 2.94 | 2023-09-21 | 8 | 9.16 | 1 | 117.55 | 35 | SO51789 | 2023-09-28 | 9.40 | 73.27 | 14.69 | |||
SO65234_21 | 3BB7-4A9F-AF | PO10411160249 | 100 | 289 | 568 | 182 | 1 | 2024-05-03 | 445.41 | 11.14 | 2024-04-21 | 1 | 461.44 | 1 | 445.41 | 21 | SO65234 | 2024-04-28 | 35.63 | 461.44 | 445.41 | |||
SO71941_11 | EF95-4DC0-B4 | PO8903143014 | 100 | 293 | 482 | 235 | 1 | 2024-08-03 | 53.94 | 1.35 | 2024-07-22 | 10 | 3.36 | 1 | 53.94 | 11 | SO71941 | 2024-07-29 | 4.32 | 33.62 | 5.39 | |||
SO59021_11 | A306-4E83-B7 | PO7395154426 | 100 | 286 | 511 | 542 | 1 | 2024-02-02 | 1092.27 | 27.31 | 2024-01-21 | 5 | 199.38 | 1 | 1092.27 | 11 | SO59021 | 2024-01-28 | 87.38 | 996.88 | 218.45 | |||
SO50218_26 | B8E9-4FE2-8B | PO14442144367 | 100 | 293 | 354 | 127 | 1 | 2023-07-03 | 4971.41 | 124.29 | 2023-06-21 | 4 | 1117.86 | 1 | 4971.41 | 26 | SO50218 | 2023-06-28 | 397.71 | 4471.42 | 1242.85 | |||
SO47033_43 | 2797-46ED-BB | PO4727113716 | 100 | 286 | 377 | 343 | 1 | 2022-10-03 | 2617.88 | 65.45 | 2022-09-21 | 2 | 1320.68 | 1 | 2617.88 | 43 | SO47033 | 2022-09-28 | 209.43 | 2641.37 | 1308.94 | |||
SO55325_4 | 2A57-4E18-99 | PO9338115445 | 100 | 293 | 568 | 451 | 1 | 2023-12-03 | 3563.28 | 89.08 | 2023-11-21 | 8 | 461.44 | 1 | 3563.28 | 4 | SO55325 | 2023-11-28 | 285.06 | 3691.56 | 445.41 | |||
SO47719_8 | 97AE-407F-90 | PO7105121606 | 100 | 286 | 327 | 668 | 1 | 2022-12-03 | 1409.38 | 35.23 | 2022-11-21 | 3 | 486.71 | 1 | 1409.38 | 8 | SO47719 | 2022-11-28 | 112.75 | 1460.12 | 469.79 | |||
SO49846_1 | 5B51-4482-BB | PO1392138093 | 100 | 293 | 254 | 19 | 1 | 2023-06-03 | 183.94 | 4.60 | 2023-05-22 | 1 | 170.14 | 1 | 183.94 | 1 | SO49846 | 2023-05-29 | 14.72 | 170.14 | 183.94 | |||
SO46957_5 | C98D-43A5-8A | PO16414179284 | 100 | 289 | 453 | 236 | 1 | 2022-10-03 | 359.94 | 9.00 | 2022-09-21 | 10 | 24.75 | 1 | 359.94 | 5 | SO46957 | 2022-09-28 | 28.80 | 247.46 | 35.99 | |||
SO69525_17 | 9DCD-4F42-9E | PO4727119266 | 100 | 293 | 384 | 343 | 1 | 2024-07-03 | 672.29 | 16.81 | 2024-06-21 | 1 | 713.08 | 1 | 672.29 | 17 | SO69525 | 2024-06-28 | 53.78 | 713.08 | 672.29 | |||
SO43877_2 | 4ECF-42F2-A7 | PO11919119101 | 100 | 286 | 215 | 73 | 1 | 2021-10-03 | 40.37 | 1.01 | 2021-09-21 | 2 | 12.03 | 1 | 40.37 | 2 | SO43877 | 2021-09-28 | 3.23 | 24.06 | 20.19 | |||
SO47992_19 | 3F55-4354-BD | PO15573158216 | 100 | 293 | 409 | 487 | 1 | 2023-01-03 | 418.51 | 10.46 | 2022-12-22 | 2 | 185.82 | 1 | 418.51 | 19 | SO47992 | 2022-12-29 | 33.48 | 371.64 | 209.26 | |||
SO51723_7 | 4D27-4A2E-A7 | PO14529141662 | 100 | 293 | 400 | 289 | 1 | 2023-10-03 | 37.15 | 0.93 | 2023-09-21 | 1 | 27.49 | 1 | 37.15 | 7 | SO51723 | 2023-09-28 | 2.97 | 27.49 | 37.15 | |||
SO71836_39 | E41E-40C1-84 | PO841118259 | 100 | 286 | 515 | 254 | 1 | 2024-08-03 | 65.09 | 1.63 | 2024-07-22 | 4 | 12.04 | 1 | 65.09 | 39 | SO71836 | 2024-07-29 | 5.21 | 48.17 | 16.27 | |||
SO61244_18 | 22F5-4A88-BE | PO6612122199 | 100 | 286 | 578 | 110 | 1 | 2024-03-04 | 1457.82 | 36.45 | 2024-02-21 | 2 | 755.15 | 1 | 1457.82 | 18 | SO61244 | 2024-02-28 | 116.63 | 1510.30 | 728.91 |
Generated 2024-09-20 15:33:42.159 UTC