[ROOT] dt FactResellerSale < WHERE DimSalesTerritoryId EQ '6' > SHUFFLE < SKIP 280 > < TAKE 30 >
30 items
FactResellerSaleId | CarrierTrackingNumber | CustomerPONumber | DimCurrencyId | DimEmployeeId | DimProductId | DimResellerId | DimSalesTerritoryId | DueDate | ExtendedAmount | Freight | OrderDate | OrderQuantity | ProductStandardCost | RevisionNumber | SalesAmount | SalesOrderLineNumber | SalesOrderNumber | ShipDate | TaxAmt | TotalProductCost | UnitPrice |
---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
SO69400_9 | 761C-4315-82 | PO17806199596 | 19 | 291 | 477 | 101 | 6 | 2024-07-02 | 5.99 | 0.15 | 2024-06-20 | 2 | 1.87 | 1 | 5.99 | 9 | SO69400 | 2024-06-27 | 0.48 | 3.73 | 2.99 |
SO65164_17 | 07B8-4AF8-8A | PO18299114573 | 19 | 291 | 559 | 118 | 6 | 2024-05-02 | 12.14 | 0.30 | 2024-04-20 | 1 | 8.99 | 1 | 12.14 | 17 | SO65164 | 2024-04-27 | 0.97 | 8.99 | 12.14 |
SO69396_14 | 210F-43F3-97 | PO19227139814 | 19 | 284 | 605 | 210 | 6 | 2024-07-02 | 647.99 | 16.20 | 2024-06-20 | 2 | 343.65 | 1 | 647.99 | 14 | SO69396 | 2024-06-27 | 51.84 | 687.30 | 323.99 |
SO47668_21 | 7CB5-4904-AD | PO15312152020 | 19 | 291 | 375 | 299 | 6 | 2022-12-02 | 5235.75 | 130.89 | 2022-11-20 | 4 | 1320.68 | 1 | 5235.75 | 21 | SO47668 | 2022-11-27 | 418.86 | 5282.74 | 1308.94 |
SO55245_2 | B5AD-476D-B4 | PO14732112185 | 19 | 291 | 440 | 514 | 6 | 2023-12-02 | 2576.70 | 64.42 | 2023-11-20 | 3 | 868.63 | 1 | 2576.70 | 2 | SO55245 | 2023-11-27 | 206.14 | 2605.90 | 858.90 |
SO49045_3 | B1B9-4F02-A4 | PO19227111923 | 19 | 284 | 343 | 210 | 6 | 2023-04-04 | 1879.18 | 46.98 | 2023-03-23 | 4 | 486.71 | 1 | 1879.18 | 3 | SO49045 | 2023-03-30 | 150.33 | 1946.83 | 469.79 |
SO47037_3 | C1AE-48A5-9F | PO4901170321 | 19 | 284 | 242 | 84 | 6 | 2022-10-02 | 1561.64 | 39.04 | 2022-09-20 | 2 | 722.26 | 1 | 1561.64 | 3 | SO47037 | 2022-09-27 | 124.93 | 1444.51 | 780.82 |
SO49856_3 | 6ADC-4789-8A | PO18444116791 | 19 | 291 | 333 | 227 | 6 | 2023-06-02 | 4697.94 | 117.45 | 2023-05-21 | 10 | 486.71 | 1 | 4697.94 | 3 | SO49856 | 2023-05-28 | 375.84 | 4867.07 | 469.79 |
SO48754_18 | FC6A-4A9E-83 | PO18473150383 | 19 | 291 | 356 | 442 | 6 | 2023-03-04 | 2485.70 | 62.14 | 2023-02-20 | 2 | 1117.86 | 1 | 2485.70 | 18 | SO48754 | 2023-02-27 | 198.86 | 2235.71 | 1242.85 |
SO47354_38 | 6E1C-48C6-89 | PO19401144959 | 19 | 291 | 370 | 173 | 6 | 2022-11-02 | 4398.03 | 109.95 | 2022-10-21 | 3 | 1518.79 | 1 | 4398.03 | 38 | SO47354 | 2022-10-28 | 351.84 | 4556.36 | 1466.01 |
SO58914_12 | 8547-437A-B2 | PO17545129441 | 19 | 291 | 434 | 155 | 6 | 2024-02-01 | 2141.39 | 53.53 | 2024-01-20 | 6 | 360.94 | 1 | 2141.39 | 12 | SO58914 | 2024-01-27 | 171.31 | 2165.66 | 356.90 |
SO44745_1 | 5CFC-4DD5-A7 | PO18299187625 | 19 | 288 | 292 | 118 | 6 | 2022-02-01 | 1637.40 | 40.94 | 2022-01-20 | 2 | 706.81 | 1 | 1637.40 | 1 | SO44745 | 2022-01-27 | 130.99 | 1413.62 | 818.70 |
SO61204_15 | E810-4164-82 | PO15312134209 | 19 | 291 | 231 | 299 | 6 | 2024-03-03 | 89.98 | 2.25 | 2024-02-20 | 3 | 38.49 | 1 | 89.98 | 15 | SO61204 | 2024-02-27 | 7.20 | 115.48 | 29.99 |
SO46024_7 | BE5C-4FA6-9B | PO19691162154 | 19 | 288 | 219 | 353 | 6 | 2022-07-02 | 11.40 | 0.29 | 2022-06-20 | 2 | 3.40 | 1 | 11.40 | 7 | SO46024 | 2022-06-27 | 0.91 | 6.79 | 5.70 |
SO71828_9 | 73A0-490C-B1 | PO11194153355 | 19 | 284 | 586 | 48 | 6 | 2024-08-02 | 3563.28 | 89.08 | 2024-07-21 | 8 | 461.44 | 1 | 3563.28 | 9 | SO71828 | 2024-07-28 | 285.06 | 3691.56 | 445.41 |
SO50195_21 | F28B-4548-99 | PO19198175870 | 19 | 291 | 308 | 653 | 6 | 2023-07-02 | 2977.09 | 74.43 | 2023-06-20 | 4 | 660.91 | 1 | 2977.09 | 21 | SO50195 | 2023-06-27 | 238.17 | 2643.66 | 744.27 |
SO51781_7 | 63E7-4ABF-A9 | PO20039116715 | 19 | 291 | 400 | 65 | 6 | 2023-10-02 | 111.46 | 2.79 | 2023-09-20 | 3 | 27.49 | 1 | 111.46 | 7 | SO51781 | 2023-09-27 | 8.92 | 82.48 | 37.15 |
SO45280_10 | 46AF-4DA9-99 | PO17748162196 | 19 | 284 | 332 | 102 | 6 | 2022-04-04 | 419.46 | 10.49 | 2022-03-23 | 1 | 413.15 | 1 | 419.46 | 10 | SO45280 | 2022-03-30 | 33.56 | 413.15 | 419.46 |
SO53510_12 | 8E8D-4B13-B1 | PO10962181057 | 19 | 284 | 475 | 685 | 6 | 2023-11-02 | 41.99 | 1.05 | 2023-10-21 | 1 | 26.18 | 1 | 41.99 | 12 | SO53510 | 2023-10-28 | 3.36 | 26.18 | 41.99 |
SO58914_3 | 8547-437A-B2 | PO17545129441 | 19 | 291 | 545 | 155 | 6 | 2024-02-01 | 97.18 | 2.43 | 2024-01-20 | 4 | 17.98 | 1 | 97.18 | 3 | SO58914 | 2024-01-27 | 7.77 | 71.91 | 24.29 |
SO51092_4 | FB68-47B7-9D | PO15312133079 | 19 | 291 | 580 | 299 | 6 | 2023-09-01 | 3061.78 | 76.54 | 2023-08-20 | 3 | 1082.51 | 1 | 3061.78 | 4 | SO51092 | 2023-08-27 | 244.94 | 3247.53 | 1020.59 |
SO47662_13 | 9790-4A85-BE | PO18473142607 | 19 | 291 | 360 | 442 | 6 | 2022-12-02 | 2458.92 | 61.47 | 2022-11-20 | 2 | 1105.81 | 1 | 2458.92 | 13 | SO47662 | 2022-11-27 | 196.71 | 2211.62 | 1229.46 |
SO43677_4 | 8E3A-4564-99 | PO11049174786 | 19 | 284 | 342 | 679 | 6 | 2021-09-01 | 419.46 | 10.49 | 2021-08-20 | 1 | 413.15 | 1 | 419.46 | 4 | SO43677 | 2021-08-27 | 33.56 | 413.15 | 419.46 |
SO46359_7 | 95FD-4612-88 | PO1740167502 | 19 | 288 | 223 | 460 | 6 | 2022-08-02 | 10.37 | 0.26 | 2022-07-21 | 2 | 5.71 | 1 | 10.37 | 7 | SO46359 | 2022-07-28 | 0.83 | 11.41 | 5.19 |
SO46333_22 | B042-408B-A8 | PO17545158984 | 19 | 288 | 322 | 155 | 6 | 2022-08-02 | 1258.38 | 31.46 | 2022-07-21 | 3 | 413.15 | 1 | 1258.38 | 22 | SO46333 | 2022-07-28 | 100.67 | 1239.44 | 419.46 |
SO49085_17 | 7265-4D98-80 | PO19198152404 | 19 | 291 | 409 | 653 | 6 | 2023-04-04 | 209.26 | 5.23 | 2023-03-23 | 1 | 185.82 | 1 | 209.26 | 17 | SO49085 | 2023-03-30 | 16.74 | 185.82 | 209.26 |
SO46331_2 | 729B-498D-BD | PO17719139668 | 19 | 284 | 342 | 631 | 6 | 2022-08-02 | 838.92 | 20.97 | 2022-07-21 | 2 | 413.15 | 1 | 838.92 | 2 | SO46331 | 2022-07-28 | 67.11 | 826.29 | 419.46 |
SO51124_2 | 5EEF-4271-BB | PO1711177181 | 19 | 291 | 555 | 245 | 6 | 2023-09-01 | 383.40 | 9.59 | 2023-08-20 | 6 | 47.29 | 1 | 383.40 | 2 | SO51124 | 2023-08-27 | 30.67 | 283.72 | 63.90 |
SO48339_25 | EAB2-42EA-9C | PO10614150674 | 19 | 291 | 327 | 461 | 6 | 2023-02-01 | 469.79 | 11.74 | 2023-01-20 | 1 | 486.71 | 1 | 469.79 | 25 | SO48339 | 2023-01-27 | 37.58 | 486.71 | 469.79 |
SO57019_18 | D018-44A0-BF | PO18879140423 | 19 | 291 | 561 | 64 | 6 | 2024-01-02 | 1430.44 | 35.76 | 2023-12-21 | 1 | 1481.94 | 1 | 1430.44 | 18 | SO57019 | 2023-12-28 | 114.44 | 1481.94 | 1430.44 |
Generated 2024-09-19 21:13:43.186 UTC