[ROOT] dt FactResellerSale < WHERE DimSalesTerritoryId EQ '2' > SHUFFLE SKIP 2000 < SKIP 520 > < 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 |
---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
SO58976_3 | 3BF9-484F-A1 | PO20213146485 | 100 | 283 | 390 | 216 | 2 | 2024-02-02 | 672.29 | 16.81 | 2024-01-21 | 1 | 713.08 | 1 | 672.29 | 3 | SO58976 | 2024-01-28 | 53.78 | 713.08 | 672.29 |
SO47055_26 | BF62-4954-A7 | PO7453164163 | 100 | 281 | 466 | 108 | 2 | 2022-10-03 | 56.52 | 1.41 | 2022-09-21 | 4 | 9.71 | 1 | 56.52 | 26 | SO47055 | 2022-09-28 | 4.52 | 38.85 | 14.13 |
SO48077_35 | 02FD-483D-8C | PO7453110437 | 100 | 281 | 460 | 108 | 2 | 2023-01-03 | 107.99 | 2.70 | 2022-12-22 | 2 | 37.12 | 1 | 107.99 | 35 | SO48077 | 2022-12-29 | 8.64 | 74.24 | 53.99 |
SO53585_5 | 3C96-4A6F-BD | PO4756171285 | 100 | 283 | 482 | 126 | 2 | 2023-11-03 | 26.97 | 0.67 | 2023-10-22 | 5 | 3.36 | 1 | 26.97 | 5 | SO53585 | 2023-10-29 | 2.16 | 16.81 | 5.39 |
SO47001_13 | DD9D-4987-9E | PO10121150577 | 100 | 281 | 335 | 684 | 2 | 2022-10-03 | 939.59 | 23.49 | 2022-09-21 | 2 | 486.71 | 1 | 939.59 | 13 | SO47001 | 2022-09-28 | 75.17 | 973.41 | 469.79 |
SO47052_15 | 1AAD-4284-B8 | PO7424197138 | 100 | 281 | 367 | 642 | 2 | 2022-10-03 | 3239.97 | 81.00 | 2022-09-21 | 5 | 598.44 | 1 | 3239.97 | 15 | SO47052 | 2022-09-28 | 259.20 | 2992.18 | 647.99 |
SO51794_1 | 8FDF-461F-8D | PO18792199024 | 100 | 283 | 534 | 378 | 2 | 2023-10-03 | 149.87 | 3.75 | 2023-09-21 | 1 | 136.79 | 1 | 149.87 | 1 | SO51794 | 2023-09-28 | 11.99 | 136.79 | 149.87 |
SO53506_2 | B5B1-4DF9-82 | PO11455145357 | 100 | 283 | 243 | 72 | 2 | 2023-11-03 | 3435.60 | 85.89 | 2023-10-22 | 4 | 868.63 | 1 | 3435.60 | 2 | SO53506 | 2023-10-29 | 274.85 | 3474.54 | 858.90 |
SO47450_9 | 7E50-416D-A2 | PO9483124566 | 100 | 281 | 373 | 54 | 2 | 2022-11-03 | 2617.88 | 65.45 | 2022-10-22 | 2 | 1320.68 | 1 | 2617.88 | 9 | SO47450 | 2022-10-29 | 209.43 | 2641.37 | 1308.94 |
SO45302_14 | 485F-48BA-86 | PO12006146340 | 100 | 281 | 320 | 270 | 2 | 2022-04-05 | 838.92 | 20.97 | 2022-03-24 | 2 | 413.15 | 1 | 838.92 | 14 | SO45302 | 2022-03-31 | 67.11 | 826.29 | 419.46 |
SO47351_21 | E79A-4588-B4 | PO20213129467 | 100 | 281 | 323 | 216 | 2 | 2022-11-03 | 469.79 | 11.74 | 2022-10-22 | 1 | 486.71 | 1 | 469.79 | 21 | SO47351 | 2022-10-29 | 37.58 | 486.71 | 469.79 |
SO44293_14 | A1AE-48E7-A4 | PO13775127212 | 100 | 281 | 326 | 618 | 2 | 2021-12-03 | 419.46 | 10.49 | 2021-11-21 | 1 | 413.15 | 1 | 419.46 | 14 | SO44293 | 2021-11-28 | 33.56 | 413.15 | 419.46 |
SO49825_16 | 2F7E-448D-B9 | PO17197161242 | 100 | 283 | 367 | 125 | 2 | 2023-06-03 | 1295.99 | 32.40 | 2023-05-22 | 2 | 598.44 | 1 | 1295.99 | 16 | SO49825 | 2023-05-29 | 103.68 | 1196.87 | 647.99 |
SO71908_1 | FE06-44A0-AE | PO4756144176 | 100 | 283 | 583 | 126 | 2 | 2024-08-03 | 2041.19 | 51.03 | 2024-07-22 | 2 | 1082.51 | 1 | 2041.19 | 1 | SO71908 | 2024-07-29 | 163.30 | 2165.02 | 1020.59 |
SO48076_21 | C38A-4C0F-BD | PO7424167037 | 100 | 281 | 427 | 642 | 2 | 2023-01-03 | 418.51 | 10.46 | 2022-12-22 | 2 | 185.82 | 1 | 418.51 | 21 | SO48076 | 2022-12-29 | 33.48 | 371.64 | 209.26 |
SO69402_1 | CF2F-4864-B4 | PO16791116995 | 100 | 283 | 418 | 36 | 2 | 2024-07-03 | 356.90 | 8.92 | 2024-06-21 | 1 | 360.94 | 1 | 356.90 | 1 | SO69402 | 2024-06-28 | 28.55 | 360.94 | 356.90 |
SO53560_29 | 3D25-4203-A4 | PO7685199983 | 100 | 283 | 553 | 539 | 2 | 2023-11-03 | 27.65 | 0.69 | 2023-10-22 | 1 | 20.46 | 1 | 27.65 | 29 | SO53560 | 2023-10-29 | 2.21 | 20.46 | 27.65 |
SO50733_1 | CFF7-40BF-8E | PO4756133761 | 100 | 283 | 325 | 126 | 2 | 2023-08-03 | 469.79 | 11.74 | 2023-07-22 | 1 | 486.71 | 1 | 469.79 | 1 | SO50733 | 2023-07-29 | 37.58 | 486.71 | 469.79 |
SO53537_4 | C14C-4596-A3 | PO19894159880 | 100 | 283 | 473 | 557 | 2 | 2023-11-03 | 38.10 | 0.95 | 2023-10-22 | 1 | 23.75 | 1 | 38.10 | 4 | SO53537 | 2023-10-29 | 3.05 | 23.75 | 38.10 |
SO43883_1 | E43E-40BF-9B | PO10121175623 | 100 | 281 | 264 | 684 | 2 | 2021-10-03 | 367.88 | 9.20 | 2021-09-21 | 2 | 181.49 | 1 | 367.88 | 1 | SO43883 | 2021-09-28 | 29.43 | 362.97 | 183.94 |
SO48336_14 | 48F2-4141-9A | PO11455111823 | 100 | 281 | 464 | 72 | 2 | 2023-02-02 | 84.77 | 2.12 | 2023-01-21 | 6 | 9.71 | 1 | 84.77 | 14 | SO48336 | 2023-01-28 | 6.78 | 58.28 | 14.13 |
SO44311_2 | 1B1A-46AE-93 | PO4959115826 | 100 | 281 | 314 | 269 | 2 | 2021-12-03 | 2146.96 | 53.67 | 2021-11-21 | 1 | 2171.29 | 1 | 2146.96 | 2 | SO44311 | 2021-11-28 | 171.76 | 2171.29 | 2146.96 |
SO43876_4 | 1E6F-4150-A3 | PO12006119347 | 100 | 281 | 315 | 270 | 2 | 2021-10-03 | 1749.59 | 43.74 | 2021-09-21 | 2 | 884.71 | 1 | 1749.59 | 4 | SO43876 | 2021-09-28 | 139.97 | 1769.42 | 874.79 |
SO46620_4 | FEE3-4994-8E | PO13775143788 | 100 | 281 | 368 | 618 | 2 | 2022-09-02 | 2932.02 | 73.30 | 2022-08-21 | 2 | 1518.79 | 1 | 2932.02 | 4 | SO46620 | 2022-08-28 | 234.56 | 3037.57 | 1466.01 |
SO43673_2 | 260F-4DCF-A1 | PO13775141242 | 100 | 281 | 232 | 618 | 2 | 2021-09-02 | 86.52 | 2.16 | 2021-08-21 | 3 | 31.72 | 1 | 86.52 | 2 | SO43673 | 2021-08-28 | 6.92 | 95.17 | 28.84 |
SO46666_39 | 1A94-4D1F-AF | PO6699130779 | 100 | 281 | 448 | 234 | 2 | 2022-09-02 | 35.98 | 0.90 | 2022-08-21 | 3 | 8.25 | 1 | 35.98 | 39 | SO46666 | 2022-08-28 | 2.88 | 24.74 | 11.99 |
SO65237_13 | 5F94-404B-AE | PO11455137092 | 100 | 283 | 418 | 72 | 2 | 2024-05-03 | 1070.69 | 26.77 | 2024-04-21 | 3 | 360.94 | 1 | 1070.69 | 13 | SO65237 | 2024-04-28 | 85.66 | 1082.83 | 356.90 |
SO48336_17 | 48F2-4141-9A | PO11455111823 | 100 | 281 | 422 | 72 | 2 | 2023-02-02 | 135.08 | 3.38 | 2023-01-21 | 2 | 49.98 | 1 | 135.08 | 17 | SO48336 | 2023-01-28 | 10.81 | 99.96 | 67.54 |
Generated 2024-09-20 20:40:06.993 UTC