[ROOT] dt FactResellerSale < WHERE DimSalesTerritoryId EQ '4' > SHUFFLE < SKIP 2268 > < 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 |
---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
SO53552_11 | C686-48BD-B0 | PO16182115085 | 100 | 287 | 234 | 23 | 4 | 2023-12-24 | 209.96 | 5.25 | 2023-12-12 | 7 | 38.49 | 1 | 209.96 | 11 | SO53552 | 2023-12-19 | 16.80 | 269.45 | 29.99 | |||
SO45339_16 | 1F94-40D0-86 | PO7656113434 | 100 | 282 | 232 | 403 | 4 | 2022-05-26 | 57.68 | 1.44 | 2022-05-14 | 2 | 31.72 | 1 | 57.68 | 16 | SO45339 | 2022-05-21 | 4.61 | 63.45 | 28.84 | |||
SO46362_8 | 0291-45A5-B2 | PO2697124986 | 100 | 282 | 346 | 7 | 187 | 4 | 595.00 | 2022-09-23 | 1700.00 | 27.62 | 2022-09-11 | 2 | 1912.15 | 1 | 1105.00 | 8 | SO46362 | 2022-09-18 | 88.40 | 3824.31 | 850.00 | 0.35 |
SO49104_26 | 7F8C-4702-BB | PO11745119484 | 100 | 282 | 370 | 97 | 4 | 2023-05-26 | 1466.01 | 36.65 | 2023-05-14 | 1 | 1518.79 | 1 | 1466.01 | 26 | SO49104 | 2023-05-21 | 117.28 | 1518.79 | 1466.01 | |||
SO55251_7 | 2481-4FF1-80 | PO13659159365 | 100 | 287 | 475 | 437 | 4 | 2024-01-23 | 41.99 | 1.05 | 2024-01-11 | 1 | 26.18 | 1 | 41.99 | 7 | SO55251 | 2024-01-18 | 3.36 | 26.18 | 41.99 | |||
SO47435_39 | B7A7-4F07-94 | PO5597154214 | 100 | 283 | 366 | 75 | 4 | 2022-12-24 | 2591.98 | 64.80 | 2022-12-12 | 4 | 598.44 | 1 | 2591.98 | 39 | SO47435 | 2022-12-19 | 207.36 | 2393.74 | 647.99 | |||
SO49498_1 | D9E7-4090-86 | PO16472151816 | 100 | 287 | 459 | 239 | 4 | 2023-06-23 | 107.99 | 2.70 | 2023-06-11 | 2 | 37.12 | 1 | 107.99 | 1 | SO49498 | 2023-06-18 | 8.64 | 74.24 | 53.99 | |||
SO51856_28 | E170-419C-92 | PO3654183134 | 100 | 281 | 601 | 435 | 4 | 2023-11-23 | 64.79 | 1.62 | 2023-11-11 | 2 | 23.97 | 1 | 64.79 | 28 | SO51856 | 2023-11-18 | 5.18 | 47.94 | 32.39 | |||
SO49884_24 | 822A-428D-94 | PO5626129805 | 100 | 281 | 329 | 166 | 4 | 2023-07-24 | 2348.97 | 58.72 | 2023-07-12 | 5 | 486.71 | 1 | 2348.97 | 24 | SO49884 | 2023-07-19 | 187.92 | 2433.53 | 469.79 | |||
SO47028_20 | 8DA0-456D-8F | PO3799132728 | 100 | 282 | 412 | 312 | 4 | 2022-11-23 | 360.26 | 9.01 | 2022-11-11 | 2 | 133.30 | 1 | 360.26 | 20 | SO47028 | 2022-11-18 | 28.82 | 266.59 | 180.13 | |||
SO43892_4 | 0D3C-4E1F-9C | PO2523117473 | 100 | 287 | 223 | 167 | 4 | 2021-11-23 | 15.56 | 0.39 | 2021-11-11 | 3 | 5.71 | 1 | 15.56 | 4 | SO43892 | 2021-11-18 | 1.24 | 17.12 | 5.19 | |||
SO50745_9 | 02DB-4CC5-85 | PO5539140407 | 100 | 282 | 401 | 61 | 4 | 2023-09-23 | 196.81 | 4.92 | 2023-09-11 | 3 | 48.55 | 1 | 196.81 | 9 | SO50745 | 2023-09-18 | 15.74 | 145.64 | 65.60 | |||
SO47045_32 | 9DDC-4176-90 | PO6438144434 | 100 | 283 | 456 | 2 | 309 | 4 | 9.57 | 2022-11-23 | 478.44 | 11.72 | 2022-11-11 | 11 | 30.93 | 1 | 468.87 | 32 | SO47045 | 2022-11-18 | 37.51 | 340.27 | 43.49 | 0.02 |
SO47028_7 | 8DA0-456D-8F | PO3799132728 | 100 | 282 | 367 | 312 | 4 | 2022-11-23 | 1943.98 | 48.60 | 2022-11-11 | 3 | 598.44 | 1 | 1943.98 | 7 | SO47028 | 2022-11-18 | 155.52 | 1795.31 | 647.99 | |||
SO47434_36 | 6848-4C33-98 | PO5539145068 | 100 | 282 | 447 | 61 | 4 | 2022-12-24 | 30.00 | 0.75 | 2022-12-12 | 2 | 10.31 | 1 | 30.00 | 36 | SO47434 | 2022-12-19 | 2.40 | 20.63 | 15.00 | |||
SO58909_40 | EBC4-496C-90 | PO19343180161 | 100 | 282 | 243 | 24 | 4 | 2024-03-24 | 858.90 | 21.47 | 2024-03-12 | 1 | 868.63 | 1 | 858.90 | 40 | SO58909 | 2024-03-19 | 68.71 | 868.63 | 858.90 | |||
SO71845_26 | 4781-4673-85 | PO2697119362 | 100 | 282 | 359 | 187 | 4 | 2024-09-23 | 2753.99 | 68.85 | 2024-09-11 | 2 | 1251.98 | 1 | 2753.99 | 26 | SO71845 | 2024-09-18 | 220.32 | 2503.96 | 1376.99 | |||
SO50269_1 | 78AA-40D5-B3 | PO18647136011 | 100 | 282 | 470 | 583 | 4 | 2023-08-23 | 136.76 | 3.42 | 2023-08-11 | 6 | 15.67 | 1 | 136.76 | 1 | SO50269 | 2023-08-18 | 10.94 | 94.03 | 22.79 | |||
SO45059_11 | C618-4998-BE | PO10730115502 | 100 | 287 | 310 | 491 | 4 | 2022-04-25 | 10734.81 | 268.37 | 2022-04-13 | 5 | 2171.29 | 1 | 10734.81 | 11 | SO45059 | 2022-04-20 | 858.78 | 10856.47 | 2146.96 | |||
SO57134_7 | 040D-4B73-AD | PO6351190175 | 100 | 281 | 372 | 255 | 4 | 2024-02-23 | 1466.01 | 36.65 | 2024-02-11 | 1 | 1554.95 | 1 | 1466.01 | 7 | SO57134 | 2024-02-18 | 117.28 | 1554.95 | 1466.01 | |||
SO46648_20 | 2073-4051-9E | PO2494191557 | 100 | 283 | 427 | 184 | 4 | 2022-10-23 | 418.51 | 10.46 | 2022-10-11 | 2 | 185.82 | 1 | 418.51 | 20 | SO46648 | 2022-10-18 | 33.48 | 371.64 | 209.26 | |||
SO53460_22 | 3BD9-47C3-94 | PO19343112747 | 100 | 282 | 418 | 24 | 4 | 2023-12-24 | 713.80 | 17.84 | 2023-12-12 | 2 | 360.94 | 1 | 713.80 | 22 | SO53460 | 2023-12-19 | 57.10 | 721.89 | 356.90 | |||
SO50720_11 | 38E2-4AA6-B4 | PO9715181953 | 100 | 281 | 354 | 490 | 4 | 2023-09-23 | 2485.70 | 62.14 | 2023-09-11 | 2 | 1117.86 | 1 | 2485.70 | 11 | SO50720 | 2023-09-18 | 198.86 | 2235.71 | 1242.85 | |||
SO55282_45 | A72A-4D3A-BA | PO16298125578 | 100 | 287 | 506 | 599 | 4 | 2024-01-23 | 600.16 | 15.00 | 2024-01-11 | 3 | 199.85 | 1 | 600.16 | 45 | SO55282 | 2024-01-18 | 48.01 | 599.56 | 200.05 | |||
SO48043_43 | BA6F-4F1F-B7 | PO2523167437 | 100 | 287 | 379 | 167 | 4 | 2023-02-23 | 10471.50 | 261.79 | 2023-02-11 | 8 | 1320.68 | 1 | 10471.50 | 43 | SO48043 | 2023-02-18 | 837.72 | 10565.47 | 1308.94 | |||
SO50745_7 | 02DB-4CC5-85 | PO5539140407 | 100 | 282 | 410 | 61 | 4 | 2023-09-23 | 36.45 | 0.91 | 2023-09-11 | 1 | 26.97 | 1 | 36.45 | 7 | SO50745 | 2023-09-18 | 2.92 | 26.97 | 36.45 | |||
SO48341_39 | A747-471B-97 | PO10701176180 | 100 | 282 | 360 | 133 | 4 | 2023-03-25 | 4917.84 | 122.95 | 2023-03-13 | 4 | 1105.81 | 1 | 4917.84 | 39 | SO48341 | 2023-03-20 | 393.43 | 4423.24 | 1229.46 | |||
SO51836_18 | 8AA7-498C-8C | PO6351139034 | 100 | 281 | 605 | 255 | 4 | 2023-11-23 | 323.99 | 8.10 | 2023-11-11 | 1 | 343.65 | 1 | 323.99 | 18 | SO51836 | 2023-11-18 | 25.92 | 343.65 | 323.99 | |||
SO47400_2 | F0B3-44C1-8F | PO10701186775 | 100 | 282 | 445 | 133 | 4 | 2022-12-24 | 215.96 | 5.40 | 2022-12-12 | 6 | 24.75 | 1 | 215.96 | 2 | SO47400 | 2022-12-19 | 17.28 | 148.48 | 35.99 | |||
SO47677_39 | 2C43-407F-B3 | PO13688179339 | 100 | 282 | 289 | 475 | 4 | 2023-01-23 | 1488.55 | 37.21 | 2023-01-11 | 2 | 660.91 | 1 | 1488.55 | 39 | SO47677 | 2023-01-18 | 119.08 | 1321.83 | 744.27 |
Generated 2024-11-10 11:51:43.840 UTC