[ROOT] dt FactResellerSale < WHERE DimSalesTerritoryId EQ '2' > SHUFFLE SKIP 2000 < SKIP 550 > < TAKE 28 >
28 items
FactResellerSaleId | CarrierTrackingNumber | CustomerPONumber | DimCurrencyId | DimEmployeeId | DimProductId | DimResellerId | DimSalesTerritoryId | DueDate | ExtendedAmount | Freight | OrderDate | OrderQuantity | ProductStandardCost | RevisionNumber | SalesAmount | SalesOrderLineNumber | SalesOrderNumber | ShipDate | TaxAmt | TotalProductCost | UnitPrice |
---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
SO50312_21 | 89ED-4505-8D | PO7424134798 | 100 | 283 | 221 | 642 | 2 | 2023-08-23 | 100.93 | 2.52 | 2023-08-11 | 5 | 13.88 | 1 | 100.93 | 21 | SO50312 | 2023-08-18 | 8.07 | 69.39 | 20.19 |
SO44129_22 | CE0D-4824-A6 | PO9483186106 | 100 | 281 | 314 | 54 | 2 | 2021-12-24 | 8587.85 | 214.70 | 2021-12-12 | 4 | 2171.29 | 1 | 8587.85 | 22 | SO44129 | 2021-12-19 | 687.03 | 8685.18 | 2146.96 |
SO47025_5 | 9A7F-452C-83 | PO3625180823 | 100 | 281 | 403 | 666 | 2 | 2022-11-23 | 97.18 | 2.43 | 2022-11-11 | 4 | 17.98 | 1 | 97.18 | 5 | SO47025 | 2022-11-18 | 7.77 | 71.91 | 24.29 |
SO49115_12 | 4A55-4351-88 | PO3625184218 | 100 | 283 | 454 | 666 | 2 | 2023-05-26 | 35.99 | 0.90 | 2023-05-14 | 1 | 24.75 | 1 | 35.99 | 12 | SO49115 | 2023-05-21 | 2.88 | 24.75 | 35.99 |
SO49825_3 | 2F7E-448D-B9 | PO17197161242 | 100 | 283 | 358 | 125 | 2 | 2023-07-24 | 6147.29 | 153.68 | 2023-07-12 | 5 | 1105.81 | 1 | 6147.29 | 3 | SO49825 | 2023-07-19 | 491.78 | 5529.05 | 1229.46 |
SO50228_10 | D5B0-4F26-BC | PO11629145611 | 100 | 283 | 352 | 396 | 2 | 2023-08-23 | 3728.56 | 93.21 | 2023-08-11 | 3 | 1117.86 | 1 | 3728.56 | 10 | SO50228 | 2023-08-18 | 298.28 | 3353.57 | 1242.85 |
SO48026_29 | E497-4BCF-A5 | PO10121196875 | 100 | 281 | 286 | 684 | 2 | 2023-02-23 | 183.94 | 4.60 | 2023-02-11 | 1 | 170.14 | 1 | 183.94 | 29 | SO48026 | 2023-02-18 | 14.72 | 170.14 | 183.94 |
SO46368_19 | BF32-47A9-90 | PO4408111909 | 100 | 281 | 336 | 143 | 2 | 2022-09-23 | 838.92 | 20.97 | 2022-09-11 | 2 | 413.15 | 1 | 838.92 | 19 | SO46368 | 2022-09-18 | 67.11 | 826.29 | 419.46 |
SO47685_2 | CC2F-4D47-8C | PO11484129630 | 100 | 281 | 453 | 594 | 2 | 2023-01-23 | 179.97 | 4.50 | 2023-01-11 | 5 | 24.75 | 1 | 179.97 | 2 | SO47685 | 2023-01-18 | 14.40 | 123.73 | 35.99 |
SO55239_26 | EDCD-45C2-B0 | PO17197177243 | 100 | 283 | 363 | 125 | 2 | 2024-01-23 | 2753.99 | 68.85 | 2024-01-11 | 2 | 1251.98 | 1 | 2753.99 | 26 | SO55239 | 2024-01-18 | 220.32 | 2503.96 | 1376.99 |
SO46385_5 | F727-48F0-AF | PO9483110086 | 100 | 281 | 314 | 54 | 2 | 2022-09-23 | 2146.96 | 53.67 | 2022-09-11 | 1 | 2171.29 | 1 | 2146.96 | 5 | SO46385 | 2022-09-18 | 171.76 | 2171.29 | 2146.96 |
SO69526_7 | E43D-4369-A8 | PO7453115394 | 100 | 283 | 465 | 108 | 2 | 2024-08-23 | 29.39 | 0.73 | 2024-08-11 | 2 | 9.16 | 1 | 29.39 | 7 | SO69526 | 2024-08-18 | 2.35 | 18.32 | 14.69 |
SO46385_31 | F727-48F0-AF | PO9483110086 | 100 | 281 | 223 | 54 | 2 | 2022-09-23 | 31.12 | 0.78 | 2022-09-11 | 6 | 5.71 | 1 | 31.12 | 31 | SO46385 | 2022-09-18 | 2.49 | 34.23 | 5.19 |
SO55261_5 | 130D-46E9-9B | PO11484193890 | 100 | 283 | 513 | 594 | 2 | 2024-01-23 | 436.91 | 10.92 | 2024-01-11 | 2 | 199.38 | 1 | 436.91 | 5 | SO55261 | 2024-01-18 | 34.95 | 398.75 | 218.45 |
SO44114_12 | 3082-4C08-AA | PO3190199320 | 100 | 281 | 223 | 575 | 2 | 2021-12-24 | 10.37 | 0.26 | 2021-12-12 | 2 | 5.71 | 1 | 10.37 | 12 | SO44114 | 2021-12-19 | 0.83 | 11.41 | 5.19 |
SO55301_27 | C4D6-4789-A9 | PO3828165579 | 100 | 283 | 476 | 414 | 2 | 2024-01-23 | 125.98 | 3.15 | 2024-01-11 | 3 | 26.18 | 1 | 125.98 | 27 | SO55301 | 2024-01-18 | 10.08 | 78.53 | 41.99 |
SO61239_36 | 6459-4F99-96 | PO3828136274 | 100 | 283 | 559 | 414 | 2 | 2024-04-24 | 48.58 | 1.21 | 2024-04-12 | 4 | 8.99 | 1 | 48.58 | 36 | SO61239 | 2024-04-19 | 3.89 | 35.95 | 12.14 |
SO44129_26 | CE0D-4824-A6 | PO9483186106 | 100 | 281 | 264 | 54 | 2 | 2021-12-24 | 183.94 | 4.60 | 2021-12-12 | 1 | 181.49 | 1 | 183.94 | 26 | SO44129 | 2021-12-19 | 14.72 | 181.49 | 183.94 |
SO46386_6 | 0DC2-47FA-A1 | PO9019117533 | 100 | 281 | 307 | 576 | 2 | 2022-09-23 | 2167.78 | 54.19 | 2022-09-11 | 3 | 623.84 | 1 | 2167.78 | 6 | SO46386 | 2022-09-18 | 173.42 | 1871.52 | 722.59 |
SO49113_2 | 4C8B-47E0-A7 | PO11658167469 | 100 | 283 | 447 | 233 | 2 | 2023-05-26 | 45.00 | 1.13 | 2023-05-14 | 3 | 10.31 | 1 | 45.00 | 2 | SO49113 | 2023-05-21 | 3.60 | 30.94 | 15.00 |
SO69467_1 | A38D-4E1B-93 | PO2871181396 | 100 | 283 | 490 | 522 | 2 | 2024-08-23 | 32.39 | 0.81 | 2024-08-11 | 1 | 41.57 | 1 | 32.39 | 1 | SO69467 | 2024-08-18 | 2.59 | 41.57 | 32.39 |
SO50280_42 | 7938-4E14-A7 | PO11658187917 | 100 | 283 | 447 | 233 | 2 | 2023-08-23 | 15.00 | 0.38 | 2023-08-11 | 1 | 10.31 | 1 | 15.00 | 42 | SO50280 | 2023-08-18 | 1.20 | 10.31 | 15.00 |
SO50312_27 | 89ED-4505-8D | PO7424134798 | 100 | 283 | 213 | 642 | 2 | 2023-08-23 | 40.37 | 1.01 | 2023-08-11 | 2 | 13.88 | 1 | 40.37 | 27 | SO50312 | 2023-08-18 | 3.23 | 27.76 | 20.19 |
SO57101_4 | E5FB-42E2-A9 | PO18386193019 | 100 | 283 | 408 | 558 | 2 | 2024-02-23 | 216.49 | 5.41 | 2024-02-11 | 3 | 53.40 | 1 | 216.49 | 4 | SO57101 | 2024-02-18 | 17.32 | 160.20 | 72.16 |
SO46666_18 | 1A94-4D1F-AF | PO6699130779 | 100 | 281 | 381 | 234 | 2 | 2022-10-23 | 4201.84 | 105.05 | 2022-10-11 | 7 | 605.65 | 1 | 4201.84 | 18 | SO46666 | 2022-10-18 | 336.15 | 4239.54 | 600.26 |
SO49117_16 | 9786-4FB8-81 | PO11629122690 | 100 | 283 | 393 | 396 | 2 | 2023-05-26 | 137.69 | 3.44 | 2023-05-14 | 1 | 101.89 | 1 | 137.69 | 16 | SO49117 | 2023-05-21 | 11.02 | 101.89 | 137.69 |
SO46640_8 | AE5D-418B-B7 | PO10092115747 | 100 | 281 | 289 | 252 | 2 | 2022-10-23 | 744.27 | 18.61 | 2022-10-11 | 1 | 660.91 | 1 | 744.27 | 8 | SO46640 | 2022-10-18 | 59.54 | 660.91 | 744.27 |
SO49169_20 | 73B1-4F93-B6 | PO10121138908 | 100 | 283 | 335 | 684 | 2 | 2023-05-26 | 469.79 | 11.74 | 2023-05-14 | 1 | 486.71 | 1 | 469.79 | 20 | SO49169 | 2023-05-21 | 37.58 | 486.71 | 469.79 |
Generated 2024-11-10 13:35:03.547 UTC