[ROOT] dt FactResellerSale < WHERE DimSalesTerritoryId EQ '2' > SHUFFLE < SKIP 2563 > < TAKE 31 >
31 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 |
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
| SO46986_7 | A56F-42B9-BB | PO12383199580 | 100 | 281 | 327 | 9 | 89 | 2 | 281.88 | 2022-11-25 | 939.59 | 16.44 | 2022-11-13 | 4 | 486.71 | 1 | 657.71 | 7 | SO46986 | 2022-11-20 | 52.62 | 1946.83 | 234.90 | 0.30 |
| SO47055_40 | BF62-4954-A7 | PO7453164163 | 100 | 281 | 325 | 108 | 2 | 2022-11-25 | 469.79 | 11.74 | 2022-11-13 | 1 | 486.71 | 1 | 469.79 | 40 | SO47055 | 2022-11-20 | 37.58 | 486.71 | 469.79 | |||
| SO57091_1 | 46C3-4CC4-85 | PO18792158206 | 100 | 283 | 543 | 378 | 2 | 2024-02-25 | 74.51 | 1.86 | 2024-02-13 | 2 | 27.57 | 1 | 74.51 | 1 | SO57091 | 2024-02-20 | 5.96 | 55.14 | 37.25 | |||
| SO44313_12 | 6613-4427-84 | PO5365138960 | 100 | 281 | 270 | 161 | 2 | 2022-01-25 | 183.94 | 4.60 | 2022-01-13 | 1 | 181.49 | 1 | 183.94 | 12 | SO44313 | 2022-01-20 | 14.72 | 181.49 | 183.94 | |||
| SO51157_38 | 927E-4DB1-A3 | PO3828155781 | 100 | 283 | 552 | 414 | 2 | 2023-10-25 | 109.79 | 2.74 | 2023-10-13 | 2 | 40.62 | 1 | 109.79 | 38 | SO51157 | 2023-10-20 | 8.78 | 81.24 | 54.89 | |||
| SO55248_23 | 8E6C-4F5E-92 | PO13775186264 | 100 | 283 | 482 | 618 | 2 | 2024-01-25 | 37.76 | 0.94 | 2024-01-13 | 7 | 3.36 | 1 | 37.76 | 23 | SO55248 | 2024-01-20 | 3.02 | 23.54 | 5.39 | |||
| SO57141_23 | 5DE1-45D6-8B | PO3625112721 | 100 | 283 | 386 | 666 | 2 | 2024-02-25 | 672.29 | 16.81 | 2024-02-13 | 1 | 713.08 | 1 | 672.29 | 23 | SO57141 | 2024-02-20 | 53.78 | 713.08 | 672.29 | |||
| SO44531_11 | E4D9-426B-8B | PO10121174343 | 100 | 281 | 315 | 684 | 2 | 2022-02-25 | 3499.18 | 87.48 | 2022-02-13 | 4 | 884.71 | 1 | 3499.18 | 11 | SO44531 | 2022-02-20 | 279.93 | 3538.83 | 874.79 | |||
| SO47664_9 | 4F8A-4646-B5 | PO17197195500 | 100 | 281 | 366 | 125 | 2 | 2023-01-25 | 2591.98 | 64.80 | 2023-01-13 | 4 | 598.44 | 1 | 2591.98 | 9 | SO47664 | 2023-01-20 | 207.36 | 2393.74 | 647.99 | |||
| SO46994_11 | 5E92-4A19-9E | PO11629171210 | 100 | 281 | 395 | 396 | 2 | 2022-11-25 | 552.37 | 13.81 | 2022-11-13 | 9 | 45.42 | 1 | 552.37 | 11 | SO46994 | 2022-11-20 | 44.19 | 408.75 | 61.37 | |||
| SO49888_50 | 01BB-49D0-BD | PO6699147895 | 100 | 283 | 224 | 234 | 2 | 2023-07-26 | 25.93 | 0.65 | 2023-07-14 | 5 | 5.23 | 1 | 25.93 | 50 | SO49888 | 2023-07-21 | 2.07 | 26.15 | 5.19 | |||
| SO50259_22 | 2D7F-444F-AE | PO18386133550 | 100 | 283 | 273 | 558 | 2 | 2023-08-25 | 809.33 | 20.23 | 2023-08-13 | 4 | 187.16 | 1 | 809.33 | 22 | SO50259 | 2023-08-20 | 64.75 | 748.63 | 202.33 | |||
| SO61239_22 | 6459-4F99-96 | PO3828136274 | 100 | 283 | 488 | 414 | 2 | 2024-04-26 | 129.58 | 3.24 | 2024-04-14 | 4 | 41.57 | 1 | 129.58 | 22 | SO61239 | 2024-04-21 | 10.37 | 166.29 | 32.39 | |||
| SO48021_15 | 7215-4D49-AD | PO11629116216 | 100 | 281 | 410 | 396 | 2 | 2023-02-25 | 109.34 | 2.73 | 2023-02-13 | 3 | 26.97 | 1 | 109.34 | 15 | SO48021 | 2023-02-20 | 8.75 | 80.91 | 36.45 | |||
| SO57125_16 | 2D2B-4159-87 | PO7453119638 | 100 | 283 | 222 | 108 | 2 | 2024-02-25 | 167.95 | 4.20 | 2024-02-13 | 8 | 13.09 | 1 | 167.95 | 16 | SO57125 | 2024-02-20 | 13.44 | 104.69 | 20.99 | |||
| SO48776_8 | 81D9-4651-84 | PO3828123354 | 100 | 283 | 354 | 414 | 2 | 2023-04-27 | 1242.85 | 31.07 | 2023-04-15 | 1 | 1117.86 | 1 | 1242.85 | 8 | SO48776 | 2023-04-22 | 99.43 | 1117.86 | 1242.85 | |||
| SO47001_29 | DD9D-4987-9E | PO10121150577 | 100 | 281 | 339 | 684 | 2 | 2022-11-25 | 3288.56 | 82.21 | 2022-11-13 | 7 | 486.71 | 1 | 3288.56 | 29 | SO47001 | 2022-11-20 | 263.08 | 3406.95 | 469.79 | |||
| SO63200_19 | E73D-4A02-88 | PO11658161535 | 100 | 283 | 487 | 233 | 2 | 2024-05-27 | 263.95 | 6.60 | 2024-05-15 | 8 | 20.57 | 1 | 263.95 | 19 | SO63200 | 2024-05-22 | 21.12 | 164.53 | 32.99 | |||
| SO55301_48 | C4D6-4789-A9 | PO3828165579 | 100 | 283 | 357 | 414 | 2 | 2024-01-25 | 1391.99 | 34.80 | 2024-01-13 | 1 | 1265.62 | 1 | 1391.99 | 48 | SO55301 | 2024-01-20 | 111.36 | 1265.62 | 1391.99 | |||
| SO69467_6 | A38D-4E1B-93 | PO2871181396 | 100 | 283 | 564 | 522 | 2 | 2024-08-25 | 1430.44 | 35.76 | 2024-08-13 | 1 | 1481.94 | 1 | 1430.44 | 6 | SO69467 | 2024-08-20 | 114.44 | 1481.94 | 1430.44 | |||
| SO46655_26 | F5D5-409B-94 | PO3828139841 | 100 | 281 | 470 | 414 | 2 | 2022-10-25 | 182.35 | 4.56 | 2022-10-13 | 8 | 15.67 | 1 | 182.35 | 26 | SO46655 | 2022-10-20 | 14.59 | 125.37 | 22.79 | |||
| SO65152_4 | 9C5B-4E79-98 | PO20213135029 | 100 | 283 | 606 | 216 | 2 | 2024-06-25 | 323.99 | 8.10 | 2024-06-13 | 1 | 343.65 | 1 | 323.99 | 4 | SO65152 | 2024-06-20 | 25.92 | 343.65 | 323.99 | |||
| SO46027_4 | 13E3-4227-BD | PO19256159915 | 100 | 281 | 319 | 162 | 2 | 2022-08-25 | 874.79 | 21.87 | 2022-08-13 | 1 | 884.71 | 1 | 874.79 | 4 | SO46027 | 2022-08-20 | 69.98 | 884.71 | 874.79 | |||
| SO61209_3 | C31E-48AE-AF | PO11484136165 | 100 | 283 | 532 | 594 | 2 | 2024-04-26 | 149.87 | 3.75 | 2024-04-14 | 1 | 136.79 | 1 | 149.87 | 3 | SO61209 | 2024-04-21 | 11.99 | 136.79 | 149.87 | |||
| SO48076_18 | C38A-4C0F-BD | PO7424167037 | 100 | 281 | 360 | 642 | 2 | 2023-02-25 | 7376.75 | 184.42 | 2023-02-13 | 6 | 1105.81 | 1 | 7376.75 | 18 | SO48076 | 2023-02-20 | 590.14 | 6634.86 | 1229.46 | |||
| SO53506_24 | B5B1-4DF9-82 | PO11455145357 | 100 | 283 | 281 | 72 | 2 | 2023-12-26 | 1011.66 | 25.29 | 2023-12-14 | 5 | 204.63 | 1 | 1011.66 | 24 | SO53506 | 2023-12-21 | 80.93 | 1023.13 | 202.33 | |||
| SO48392_32 | B9C7-4F4D-82 | PO9483147187 | 100 | 281 | 445 | 54 | 2 | 2023-03-27 | 143.98 | 3.60 | 2023-03-15 | 4 | 24.75 | 1 | 143.98 | 32 | SO48392 | 2023-03-22 | 11.52 | 98.98 | 35.99 | |||
| SO67314_7 | 6653-491A-80 | PO3828116396 | 100 | 283 | 222 | 414 | 2 | 2024-07-26 | 167.95 | 4.20 | 2024-07-14 | 8 | 13.09 | 1 | 167.95 | 7 | SO67314 | 2024-07-21 | 13.44 | 104.69 | 20.99 | |||
| SO44293_8 | A1AE-48E7-A4 | PO13775127212 | 100 | 281 | 328 | 618 | 2 | 2022-01-25 | 838.92 | 20.97 | 2022-01-13 | 2 | 413.15 | 1 | 838.92 | 8 | SO44293 | 2022-01-20 | 67.11 | 826.29 | 419.46 | |||
| SO63167_8 | 86F4-4F8E-AE | PO10121113947 | 100 | 283 | 384 | 684 | 2 | 2024-05-27 | 672.29 | 16.81 | 2024-05-15 | 1 | 713.08 | 1 | 672.29 | 8 | SO63167 | 2024-05-22 | 53.78 | 713.08 | 672.29 | |||
| SO47675_12 | 8515-427F-B6 | PO13775136623 | 100 | 281 | 368 | 618 | 2 | 2023-01-25 | 2932.02 | 73.30 | 2023-01-13 | 2 | 1518.79 | 1 | 2932.02 | 12 | SO47675 | 2023-01-20 | 234.56 | 3037.57 | 1466.01 |
Generated 2024-11-13 01:12:55.753 UTC