[ROOT] dt FactResellerSale < WHERE DimSalesTerritoryId EQ '5' > SHUFFLE < SKIP 2472 > < 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 |
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
| SO61173_13 | 6B8D-47B8-8E | PO522171689 | 100 | 285 | 490 | 676 | 5 | 2024-04-24 | 161.97 | 4.05 | 2024-04-12 | 5 | 41.57 | 1 | 161.97 | 13 | SO61173 | 2024-04-19 | 12.96 | 207.86 | 32.39 | |||
| SO69465_38 | B8B2-4B14-99 | PO2842153886 | 100 | 285 | 217 | 700 | 5 | 2024-08-23 | 188.95 | 4.72 | 2024-08-11 | 9 | 13.09 | 1 | 188.95 | 38 | SO69465 | 2024-08-18 | 15.12 | 117.78 | 20.99 | |||
| SO45329_5 | CFFE-4184-BD | PO5858128971 | 100 | 285 | 348 | 566 | 5 | 2022-05-26 | 6074.98 | 151.87 | 2022-05-14 | 3 | 1898.09 | 1 | 6074.98 | 5 | SO45329 | 2022-05-21 | 486.00 | 5694.28 | 2024.99 | |||
| SO47042_43 | 42DB-4E2E-B9 | PO5858114009 | 100 | 285 | 469 | 566 | 5 | 2022-11-23 | 113.97 | 2.85 | 2022-11-11 | 5 | 15.67 | 1 | 113.97 | 43 | SO47042 | 2022-11-18 | 9.12 | 78.35 | 22.79 | |||
| SO71866_30 | 029A-46BE-80 | PO14297151936 | 100 | 285 | 563 | 627 | 5 | 2024-09-23 | 2860.88 | 71.52 | 2024-09-11 | 2 | 1481.94 | 1 | 2860.88 | 30 | SO71866 | 2024-09-18 | 228.87 | 2963.88 | 1430.44 | |||
| SO49090_23 | BA90-48D0-89 | PO11571148651 | 100 | 285 | 341 | 512 | 5 | 2023-05-26 | 1409.38 | 35.23 | 2023-05-14 | 3 | 486.71 | 1 | 1409.38 | 23 | SO49090 | 2023-05-21 | 112.75 | 1460.12 | 469.79 | |||
| SO69513_6 | 21F8-4626-B9 | PO7598121355 | 100 | 285 | 408 | 45 | 5 | 2024-08-23 | 144.32 | 3.61 | 2024-08-11 | 2 | 53.40 | 1 | 144.32 | 6 | SO69513 | 2024-08-18 | 11.55 | 106.80 | 72.16 | |||
| SO46672_19 | FFCF-4848-99 | PO9831178966 | 100 | 285 | 435 | 81 | 5 | 2022-10-23 | 973.36 | 24.33 | 2022-10-11 | 3 | 300.12 | 1 | 973.36 | 19 | SO46672 | 2022-10-18 | 77.87 | 900.36 | 324.45 | |||
| SO50231_28 | B2CA-498D-9B | PO11571129150 | 100 | 285 | 273 | 512 | 5 | 2023-08-23 | 607.00 | 15.17 | 2023-08-11 | 3 | 187.16 | 1 | 607.00 | 28 | SO50231 | 2023-08-18 | 48.56 | 561.47 | 202.33 | |||
| SO67348_22 | 4BD1-4782-A3 | PO9889141767 | 100 | 285 | 512 | 494 | 5 | 2024-07-24 | 218.45 | 5.46 | 2024-07-12 | 1 | 199.38 | 1 | 218.45 | 22 | SO67348 | 2024-07-19 | 17.48 | 199.38 | 218.45 | |||
| SO49509_23 | 1105-4F75-BE | PO9599181538 | 100 | 285 | 375 | 170 | 5 | 2023-06-23 | 2617.88 | 65.45 | 2023-06-11 | 2 | 1320.68 | 1 | 2617.88 | 23 | SO49509 | 2023-06-18 | 209.43 | 2641.37 | 1308.94 | |||
| SO63281_21 | 6B19-4C4E-92 | PO3596158829 | 100 | 285 | 400 | 476 | 5 | 2024-05-25 | 37.15 | 0.93 | 2024-05-13 | 1 | 27.49 | 1 | 37.15 | 21 | SO63281 | 2024-05-20 | 2.97 | 27.49 | 37.15 | |||
| SO69465_25 | B8B2-4B14-99 | PO2842153886 | 100 | 285 | 408 | 700 | 5 | 2024-08-23 | 72.16 | 1.80 | 2024-08-11 | 1 | 53.40 | 1 | 72.16 | 25 | SO69465 | 2024-08-18 | 5.77 | 53.40 | 72.16 | |||
| SO51147_22 | C4D7-458D-A6 | PO9831167474 | 100 | 285 | 374 | 81 | 5 | 2023-10-23 | 4398.03 | 109.95 | 2023-10-11 | 3 | 1554.95 | 1 | 4398.03 | 22 | SO51147 | 2023-10-18 | 351.84 | 4664.84 | 1466.01 | |||
| SO48730_15 | C918-466B-B1 | PO522152463 | 100 | 285 | 233 | 676 | 5 | 2023-04-25 | 144.20 | 3.61 | 2023-04-13 | 5 | 29.08 | 1 | 144.20 | 15 | SO48730 | 2023-04-20 | 11.54 | 145.40 | 28.84 | |||
| SO51108_49 | 8650-4A20-B1 | PO12644151814 | 100 | 285 | 398 | 530 | 5 | 2023-10-23 | 80.17 | 2.00 | 2023-10-11 | 3 | 19.78 | 1 | 80.17 | 49 | SO51108 | 2023-10-18 | 6.41 | 59.33 | 26.72 | |||
| SO43681_20 | 6D51-449D-B3 | PO1189177803 | 100 | 285 | 262 | 423 | 5 | 2021-10-23 | 183.94 | 4.60 | 2021-10-11 | 1 | 181.49 | 1 | 183.94 | 20 | SO43681 | 2021-10-18 | 14.72 | 181.49 | 183.94 | |||
| SO57104_12 | D4EE-4716-83 | PO18560117786 | 100 | 285 | 234 | 531 | 5 | 2024-02-23 | 179.96 | 4.50 | 2024-02-11 | 6 | 38.49 | 1 | 179.96 | 12 | SO57104 | 2024-02-18 | 14.40 | 230.95 | 29.99 | |||
| SO69518_20 | 96AA-48F8-80 | PO5800191682 | 100 | 285 | 527 | 63 | 5 | 2024-08-23 | 316.86 | 7.92 | 2024-08-11 | 2 | 144.59 | 1 | 316.86 | 20 | SO69518 | 2024-08-18 | 25.35 | 289.19 | 158.43 | |||
| SO61173_9 | 6B8D-47B8-8E | PO522171689 | 100 | 285 | 355 | 676 | 5 | 2024-04-24 | 1391.99 | 34.80 | 2024-04-12 | 1 | 1265.62 | 1 | 1391.99 | 9 | SO61173 | 2024-04-19 | 111.36 | 1265.62 | 1391.99 | |||
| SO49149_19 | D41E-4EFF-A5 | PO5858123072 | 100 | 285 | 230 | 566 | 5 | 2023-05-26 | 115.36 | 2.88 | 2023-05-14 | 4 | 29.08 | 1 | 115.36 | 19 | SO49149 | 2023-05-21 | 9.23 | 116.32 | 28.84 | |||
| SO46996_22 | 775B-42D6-A5 | PO11571149031 | 100 | 285 | 368 | 512 | 5 | 2022-11-23 | 4398.03 | 109.95 | 2022-11-11 | 3 | 1518.79 | 1 | 4398.03 | 22 | SO46996 | 2022-11-18 | 351.84 | 4556.36 | 1466.01 | |||
| SO44801_13 | 4DBD-4E98-A7 | PO9599152040 | 100 | 285 | 319 | 170 | 5 | 2022-03-25 | 874.79 | 21.87 | 2022-03-13 | 1 | 884.71 | 1 | 874.79 | 13 | SO44801 | 2022-03-20 | 69.98 | 884.71 | 874.79 | |||
| SO47026_18 | 123B-481F-8F | PO3596190739 | 100 | 285 | 356 | 476 | 5 | 2022-11-23 | 7457.11 | 186.43 | 2022-11-11 | 6 | 1117.86 | 1 | 7457.11 | 18 | SO47026 | 2022-11-18 | 596.57 | 6707.14 | 1242.85 | |||
| SO49868_7 | 6BF3-4FD0-B5 | PO11861146173 | 100 | 283 | 224 | 17 | 5 | 2023-07-24 | 31.12 | 0.78 | 2023-07-12 | 6 | 5.23 | 1 | 31.12 | 7 | SO49868 | 2023-07-19 | 2.49 | 31.38 | 5.19 | |||
| SO50231_33 | B2CA-498D-9B | PO11571129150 | 100 | 285 | 323 | 512 | 5 | 2023-08-23 | 939.59 | 23.49 | 2023-08-11 | 2 | 486.71 | 1 | 939.59 | 33 | SO50231 | 2023-08-18 | 75.17 | 973.41 | 469.79 | |||
| SO48777_1 | 6378-4AB9-80 | PO3741115378 | 100 | 285 | 323 | 404 | 5 | 2023-04-25 | 1409.38 | 35.23 | 2023-04-13 | 3 | 486.71 | 1 | 1409.38 | 1 | SO48777 | 2023-04-20 | 112.75 | 1460.12 | 469.79 | |||
| SO47416_13 | 6B45-44AB-84 | PO2813155355 | 100 | 281 | 233 | 2 | 90 | 5 | 6.13 | 2022-12-24 | 306.67 | 7.51 | 2022-12-12 | 11 | 29.08 | 1 | 300.54 | 13 | SO47416 | 2022-12-19 | 24.04 | 319.89 | 27.88 | 0.02 |
| SO48020_4 | 3995-4B91-82 | PO11542110776 | 100 | 285 | 325 | 62 | 5 | 2023-02-23 | 469.79 | 11.74 | 2023-02-11 | 1 | 486.71 | 1 | 469.79 | 4 | SO48020 | 2023-02-18 | 37.58 | 486.71 | 469.79 | |||
| SO50276_7 | BB3F-4E95-B8 | PO9512139148 | 100 | 285 | 422 | 135 | 5 | 2023-08-23 | 270.16 | 6.75 | 2023-08-11 | 4 | 49.98 | 1 | 270.16 | 7 | SO50276 | 2023-08-18 | 21.61 | 199.92 | 67.54 |
Generated 2024-11-11 02:34:47.484 UTC