[ROOT] dt FactResellerSale < WHERE DimSalesTerritoryId EQ '4' > SHUFFLE < SKIP 898 > < TAKE 28 >
28 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 |
---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
SO49139_3 | 2662-4BFD-96 | PO4843131080 | 100 | 287 | 265 | 257 | 4 | 2023-04-05 | 1011.66 | 25.29 | 2023-03-24 | 5 | 187.16 | 1 | 1011.66 | 3 | SO49139 | 2023-03-31 | 80.93 | 935.79 | 202.33 | |||
SO51121_2 | 9E4C-40B6-B1 | PO10730114575 | 100 | 287 | 606 | 491 | 4 | 2023-09-02 | 1943.96 | 48.60 | 2023-08-21 | 6 | 343.65 | 1 | 1943.96 | 2 | SO51121 | 2023-08-28 | 155.52 | 2061.90 | 323.99 | |||
SO50226_34 | 75E5-4EFD-A7 | PO12499165634 | 100 | 282 | 273 | 78 | 4 | 2023-07-03 | 202.33 | 5.06 | 2023-06-21 | 1 | 187.16 | 1 | 202.33 | 34 | SO50226 | 2023-06-28 | 16.19 | 187.16 | 202.33 | |||
SO45810_6 | 2A16-4AA7-89 | PO5626186069 | 100 | 283 | 285 | 166 | 4 | 2022-06-03 | 357.16 | 8.93 | 2022-05-22 | 2 | 176.20 | 1 | 357.16 | 6 | SO45810 | 2022-05-29 | 28.57 | 352.40 | 178.58 | |||
SO51090_37 | EBDE-4A71-8E | PO13688110947 | 100 | 282 | 593 | 475 | 4 | 2023-09-02 | 338.99 | 8.47 | 2023-08-21 | 1 | 308.22 | 1 | 338.99 | 37 | SO51090 | 2023-08-28 | 27.12 | 308.22 | 338.99 | |||
SO48758_27 | 709A-4AE0-B1 | PO13688180139 | 100 | 282 | 409 | 475 | 4 | 2023-03-05 | 209.26 | 5.23 | 2023-02-21 | 1 | 185.82 | 1 | 209.26 | 27 | SO48758 | 2023-02-28 | 16.74 | 185.82 | 209.26 | |||
SO65232_1 | 3D4B-4E94-8F | PO9715132845 | 100 | 281 | 558 | 490 | 4 | 2024-05-03 | 971.98 | 24.30 | 2024-04-21 | 4 | 179.82 | 1 | 971.98 | 1 | SO65232 | 2024-04-28 | 77.76 | 719.26 | 242.99 | |||
SO58919_5 | AF42-4FCB-BB | PO17052190887 | 100 | 282 | 523 | 420 | 4 | 2024-02-02 | 126.34 | 3.16 | 2024-01-21 | 4 | 23.37 | 1 | 126.34 | 5 | SO58919 | 2024-01-28 | 10.11 | 93.49 | 31.58 | |||
SO50289_32 | 0809-4DE4-93 | PO3480117331 | 100 | 281 | 216 | 436 | 4 | 2023-07-03 | 100.93 | 2.52 | 2023-06-21 | 5 | 13.88 | 1 | 100.93 | 32 | SO50289 | 2023-06-28 | 8.07 | 69.39 | 20.19 | |||
SO50663_20 | 286E-4915-89 | PO19343130555 | 100 | 282 | 271 | 24 | 4 | 2023-08-03 | 1011.66 | 25.29 | 2023-07-22 | 5 | 187.16 | 1 | 1011.66 | 20 | SO50663 | 2023-07-29 | 80.93 | 935.79 | 202.33 | |||
SO46970_18 | 01AF-420A-B9 | PO15196114472 | 100 | 282 | 423 | 258 | 4 | 2022-10-03 | 330.46 | 8.26 | 2022-09-21 | 2 | 122.27 | 1 | 330.46 | 18 | SO46970 | 2022-09-28 | 26.44 | 244.54 | 165.23 | |||
SO69412_15 | 14B1-47FE-BF | PO15689112657 | 100 | 281 | 580 | 328 | 4 | 2024-07-03 | 2041.19 | 51.03 | 2024-06-21 | 2 | 1082.51 | 1 | 2041.19 | 15 | SO69412 | 2024-06-28 | 163.30 | 2165.02 | 1020.59 | |||
SO53621_47 | 9324-4A3D-83 | PO9715186811 | 100 | 281 | 398 | 490 | 4 | 2023-11-03 | 106.90 | 2.67 | 2023-10-22 | 4 | 19.78 | 1 | 106.90 | 47 | SO53621 | 2023-10-29 | 8.55 | 79.10 | 26.72 | |||
SO50208_10 | 6993-49B4-8B | PO15689114248 | 100 | 281 | 381 | 328 | 4 | 2023-07-03 | 1200.53 | 30.01 | 2023-06-21 | 2 | 605.65 | 1 | 1200.53 | 10 | SO50208 | 2023-06-28 | 96.04 | 1211.30 | 600.26 | |||
SO69532_16 | 27FB-4A86-85 | PO3799165791 | 100 | 282 | 488 | 312 | 4 | 2024-07-03 | 194.36 | 4.86 | 2024-06-21 | 6 | 41.57 | 1 | 194.36 | 16 | SO69532 | 2024-06-28 | 15.55 | 249.43 | 32.39 | |||
SO47677_26 | 2C43-407F-B3 | PO13688179339 | 100 | 282 | 213 | 475 | 4 | 2022-12-03 | 141.31 | 3.53 | 2022-11-21 | 7 | 13.88 | 1 | 141.31 | 26 | SO47677 | 2022-11-28 | 11.30 | 97.15 | 20.19 | |||
SO46364_6 | BC3C-4FE8-AC | PO3248115921 | 100 | 282 | 215 | 366 | 4 | 2022-08-03 | 80.75 | 2.02 | 2022-07-22 | 4 | 12.03 | 1 | 80.75 | 6 | SO46364 | 2022-07-29 | 6.46 | 48.11 | 20.19 | |||
SO48066_19 | F00E-4B06-9D | PO5684167807 | 100 | 282 | 360 | 385 | 4 | 2023-01-03 | 7376.75 | 184.42 | 2022-12-22 | 6 | 1105.81 | 1 | 7376.75 | 19 | SO48066 | 2022-12-29 | 590.14 | 6634.86 | 1229.46 | |||
SO57137_36 | 9401-4518-A4 | PO6438194874 | 100 | 281 | 483 | 309 | 4 | 2024-01-03 | 288.00 | 7.20 | 2023-12-22 | 4 | 44.88 | 1 | 288.00 | 36 | SO57137 | 2023-12-29 | 23.04 | 179.52 | 72.00 | |||
SO47456_30 | 840E-4252-B7 | PO9715175233 | 100 | 283 | 366 | 490 | 4 | 2022-11-03 | 3239.97 | 81.00 | 2022-10-22 | 5 | 598.44 | 1 | 3239.97 | 30 | SO47456 | 2022-10-29 | 259.20 | 2992.18 | 647.99 | |||
SO49890_20 | 9B22-4240-83 | PO7859114282 | 100 | 272 | 456 | 221 | 4 | 2023-06-03 | 179.98 | 4.50 | 2023-05-22 | 4 | 30.93 | 1 | 179.98 | 20 | SO49890 | 2023-05-29 | 14.40 | 123.73 | 44.99 | |||
SO51849_1 | E697-4968-AD | PO2320117582 | 100 | 282 | 246 | 529 | 4 | 2023-10-03 | 2576.70 | 64.42 | 2023-09-21 | 3 | 868.63 | 1 | 2576.70 | 1 | SO51849 | 2023-09-28 | 206.14 | 2605.90 | 858.90 | |||
SO49525_1 | 7324-4E99-8A | PO4002117785 | 100 | 282 | 323 | 674 | 4 | 2023-05-03 | 469.79 | 11.74 | 2023-04-21 | 1 | 486.71 | 1 | 469.79 | 1 | SO49525 | 2023-04-28 | 37.58 | 486.71 | 469.79 | |||
SO48052_12 | FBD0-4407-84 | PO3654150499 | 100 | 283 | 410 | 435 | 4 | 2023-01-03 | 109.34 | 2.73 | 2022-12-22 | 3 | 26.97 | 1 | 109.34 | 12 | SO48052 | 2022-12-29 | 8.75 | 80.91 | 36.45 | |||
SO51106_25 | 3D96-4D27-92 | PO12528166058 | 100 | 282 | 586 | 13 | 331 | 4 | 100.22 | 2023-09-02 | 668.12 | 14.20 | 2023-08-21 | 2 | 461.44 | 1 | 567.90 | 25 | SO51106 | 2023-08-28 | 45.43 | 922.89 | 334.06 | 0.15 |
SO53476_11 | BF5A-472F-98 | PO16153121709 | 100 | 282 | 558 | 186 | 4 | 2023-11-03 | 242.99 | 6.07 | 2023-10-22 | 1 | 179.82 | 1 | 242.99 | 11 | SO53476 | 2023-10-29 | 19.44 | 179.82 | 242.99 | |||
SO47438_26 | 69E0-4082-B4 | PO6757114691 | 100 | 283 | 470 | 21 | 4 | 2022-11-03 | 91.18 | 2.28 | 2022-10-22 | 4 | 15.67 | 1 | 91.18 | 26 | SO47438 | 2022-10-29 | 7.29 | 62.68 | 22.79 | |||
SO58984_9 | 5D72-43BF-AB | PO16153135798 | 100 | 282 | 555 | 186 | 4 | 2024-02-02 | 63.90 | 1.60 | 2024-01-21 | 1 | 47.29 | 1 | 63.90 | 9 | SO58984 | 2024-01-28 | 5.11 | 47.29 | 63.90 |
Generated 2024-09-20 20:24:02.341 UTC