[ROOT] dt FactResellerSale < WHERE DimSalesTerritoryId EQ '4' > SHUFFLE < SKIP 130 > < 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 |
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
| SO49127_21 | 01A1-43AB-A2 | PO3480145572 | 100 | 272 | 456 | 436 | 4 | 2023-05-26 | 179.98 | 4.50 | 2023-05-14 | 4 | 30.93 | 1 | 179.98 | 21 | SO49127 | 2023-05-21 | 14.40 | 123.73 | 44.99 | |||
| SO53470_10 | 932B-41E0-AF | PO17052111209 | 100 | 282 | 574 | 420 | 4 | 2023-12-24 | 2860.88 | 71.52 | 2023-12-12 | 2 | 1481.94 | 1 | 2860.88 | 10 | SO53470 | 2023-12-19 | 228.87 | 2963.88 | 1430.44 | |||
| SO50753_27 | 8073-4F97-BA | PO7569170218 | 100 | 287 | 297 | 608 | 4 | 2023-09-23 | 2944.58 | 73.61 | 2023-09-11 | 4 | 653.70 | 1 | 2944.58 | 27 | SO50753 | 2023-09-18 | 235.57 | 2614.79 | 736.15 | |||
| SO69417_24 | 6746-4842-AD | PO15196165910 | 100 | 282 | 374 | 258 | 4 | 2024-08-23 | 4398.03 | 109.95 | 2024-08-11 | 3 | 1554.95 | 1 | 4398.03 | 24 | SO69417 | 2024-08-18 | 351.84 | 4664.84 | 1466.01 | |||
| SO69515_22 | D9C1-4837-A7 | PO6351170694 | 100 | 281 | 482 | 255 | 4 | 2024-08-23 | 32.36 | 0.81 | 2024-08-11 | 6 | 3.36 | 1 | 32.36 | 22 | SO69515 | 2024-08-18 | 2.59 | 20.17 | 5.39 | |||
| SO55249_13 | 0527-4C9D-BA | PO13688172507 | 100 | 282 | 491 | 2 | 475 | 4 | 8.77 | 2024-01-23 | 438.40 | 10.74 | 2024-01-11 | 14 | 41.57 | 1 | 429.63 | 13 | SO55249 | 2024-01-18 | 34.37 | 582.01 | 31.31 | 0.02 |
| SO48775_15 | E56E-4C8C-AA | PO10817145980 | 100 | 287 | 341 | 203 | 4 | 2023-04-25 | 939.59 | 23.49 | 2023-04-13 | 2 | 486.71 | 1 | 939.59 | 15 | SO48775 | 2023-04-20 | 75.17 | 973.41 | 469.79 | |||
| SO51090_56 | EBDE-4A71-8E | PO13688110947 | 100 | 282 | 231 | 3 | 475 | 4 | 20.62 | 2023-10-23 | 412.42 | 9.79 | 2023-10-11 | 15 | 38.49 | 1 | 391.80 | 56 | SO51090 | 2023-10-18 | 31.34 | 577.38 | 27.49 | 0.05 |
| SO47045_39 | 9DDC-4176-90 | PO6438144434 | 100 | 283 | 289 | 309 | 4 | 2022-11-23 | 2977.09 | 74.43 | 2022-11-11 | 4 | 660.91 | 1 | 2977.09 | 39 | SO47045 | 2022-11-18 | 238.17 | 2643.66 | 744.27 | |||
| SO48397_15 | A1DC-424B-A8 | PO9686169278 | 100 | 282 | 397 | 457 | 4 | 2023-03-25 | 24.29 | 0.61 | 2023-03-13 | 1 | 17.98 | 1 | 24.29 | 15 | SO48397 | 2023-03-20 | 1.94 | 17.98 | 24.29 | |||
| SO47400_21 | F0B3-44C1-8F | PO10701186775 | 100 | 282 | 352 | 133 | 4 | 2022-12-24 | 11185.67 | 279.64 | 2022-12-12 | 9 | 1117.86 | 1 | 11185.67 | 21 | SO47400 | 2022-12-19 | 894.85 | 10060.70 | 1242.85 | |||
| SO49890_40 | 9B22-4240-83 | PO7859114282 | 100 | 272 | 230 | 221 | 4 | 2023-07-24 | 86.52 | 2.16 | 2023-07-12 | 3 | 29.08 | 1 | 86.52 | 40 | SO49890 | 2023-07-19 | 6.92 | 87.24 | 28.84 | |||
| SO57153_2 | 6322-496F-9C | PO3219142707 | 100 | 282 | 376 | 493 | 4 | 2024-02-23 | 1466.01 | 36.65 | 2024-02-11 | 1 | 1554.95 | 1 | 1466.01 | 2 | SO57153 | 2024-02-18 | 117.28 | 1554.95 | 1466.01 | |||
| SO71881_7 | 8EDF-4F9F-97 | PO6757112103 | 100 | 281 | 543 | 21 | 4 | 2024-09-23 | 37.25 | 0.93 | 2024-09-11 | 1 | 27.57 | 1 | 37.25 | 7 | SO71881 | 2024-09-18 | 2.98 | 27.57 | 37.25 | |||
| SO57145_30 | 4C59-4193-B1 | PO3654153385 | 100 | 281 | 514 | 435 | 4 | 2024-02-23 | 191.70 | 4.79 | 2024-02-11 | 3 | 47.29 | 1 | 191.70 | 30 | SO57145 | 2024-02-18 | 15.34 | 141.86 | 63.90 | |||
| SO71782_13 | CA08-4A9B-8D | PO19372114749 | 100 | 282 | 562 | 582 | 4 | 2024-09-23 | 1430.44 | 35.76 | 2024-09-11 | 1 | 1481.94 | 1 | 1430.44 | 13 | SO71782 | 2024-09-18 | 114.44 | 1481.94 | 1430.44 | |||
| SO51844_10 | DE76-4481-AA | PO4553182082 | 100 | 282 | 580 | 313 | 4 | 2023-11-23 | 1020.59 | 25.51 | 2023-11-11 | 1 | 1082.51 | 1 | 1020.59 | 10 | SO51844 | 2023-11-18 | 81.65 | 1082.51 | 1020.59 | |||
| SO48295_53 | 12F9-466B-B0 | PO19343197973 | 100 | 282 | 271 | 24 | 4 | 2023-03-25 | 1618.66 | 40.47 | 2023-03-13 | 8 | 187.16 | 1 | 1618.66 | 53 | SO48295 | 2023-03-20 | 129.49 | 1497.26 | 202.33 | |||
| SO48358_1 | 7C46-49DA-9F | PO2610174643 | 100 | 283 | 470 | 489 | 4 | 2023-03-25 | 68.38 | 1.71 | 2023-03-13 | 3 | 15.67 | 1 | 68.38 | 1 | SO48358 | 2023-03-20 | 5.47 | 47.01 | 22.79 | |||
| SO46660_7 | CF24-45E2-9D | PO5626129733 | 100 | 283 | 385 | 166 | 4 | 2022-10-23 | 2401.05 | 60.03 | 2022-10-11 | 4 | 605.65 | 1 | 2401.05 | 7 | SO46660 | 2022-10-18 | 192.08 | 2422.60 | 600.26 | |||
| SO69466_19 | 8B97-4CC6-8A | PO2523169620 | 100 | 287 | 214 | 167 | 4 | 2024-08-23 | 188.95 | 4.72 | 2024-08-11 | 9 | 13.09 | 1 | 188.95 | 19 | SO69466 | 2024-08-18 | 15.12 | 117.78 | 20.99 | |||
| SO65310_20 | 65CB-474A-9D | PO6786169596 | 100 | 281 | 605 | 3 | 4 | 2024-06-23 | 971.98 | 24.30 | 2024-06-11 | 3 | 343.65 | 1 | 971.98 | 20 | SO65310 | 2024-06-18 | 77.76 | 1030.95 | 323.99 | |||
| SO53531_36 | B1FB-47B2-8E | PO2697181370 | 100 | 282 | 531 | 187 | 4 | 2023-12-24 | 299.75 | 7.49 | 2023-12-12 | 2 | 136.79 | 1 | 299.75 | 36 | SO53531 | 2023-12-19 | 23.98 | 273.57 | 149.87 | |||
| SO69545_41 | 2C06-44D9-96 | PO3480123333 | 100 | 272 | 581 | 436 | 4 | 2024-08-23 | 2041.19 | 51.03 | 2024-08-11 | 2 | 1082.51 | 1 | 2041.19 | 41 | SO69545 | 2024-08-18 | 163.30 | 2165.02 | 1020.59 | |||
| SO71899_8 | C395-434F-89 | PO4582142611 | 100 | 282 | 544 | 25 | 4 | 2024-09-23 | 48.59 | 1.21 | 2024-09-11 | 1 | 35.96 | 1 | 48.59 | 8 | SO71899 | 2024-09-18 | 3.89 | 35.96 | 48.59 | |||
| SO47372_6 | 70B5-428B-86 | PO16124198007 | 100 | 282 | 236 | 649 | 4 | 2022-12-24 | 28.84 | 0.72 | 2022-12-12 | 1 | 29.08 | 1 | 28.84 | 6 | SO47372 | 2022-12-19 | 2.31 | 29.08 | 28.84 | |||
| SO48363_42 | A9C9-4B7B-9B | PO3915186343 | 100 | 283 | 461 | 130 | 4 | 2023-03-25 | 269.97 | 6.75 | 2023-03-13 | 5 | 37.12 | 1 | 269.97 | 42 | SO48363 | 2023-03-20 | 21.60 | 185.60 | 53.99 | |||
| SO47990_45 | 7D80-4D9E-9A | PO15689162700 | 100 | 283 | 271 | 328 | 4 | 2023-02-23 | 1011.66 | 25.29 | 2023-02-11 | 5 | 187.16 | 1 | 1011.66 | 45 | SO47990 | 2023-02-18 | 80.93 | 935.79 | 202.33 | |||
| SO51827_9 | B106-4221-AD | PO4611117026 | 100 | 287 | 601 | 131 | 4 | 2023-11-23 | 32.39 | 0.81 | 2023-11-11 | 1 | 23.97 | 1 | 32.39 | 9 | SO51827 | 2023-11-18 | 2.59 | 23.97 | 32.39 | |||
| SO46642_24 | 0A4E-465C-BB | PO551133122 | 100 | 283 | 370 | 4 | 4 | 2022-10-23 | 4398.03 | 109.95 | 2022-10-11 | 3 | 1518.79 | 1 | 4398.03 | 24 | SO46642 | 2022-10-18 | 351.84 | 4556.36 | 1466.01 |
Generated 2024-11-10 10:25:30.809 UTC