[ROOT] dt FactResellerSale < WHERE DimSalesTerritoryId EQ '5' > SKIP 500 SHUFFLE < SKIP 1500 > < 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 |
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
| SO49091_14 | 7A94-486D-8A | PO19546118667 | 100 | 285 | 381 | 206 | 5 | 2023-05-26 | 1200.53 | 30.01 | 2023-05-14 | 2 | 605.65 | 1 | 1200.53 | 14 | SO49091 | 2023-05-21 | 96.04 | 1211.30 | 600.26 | |||
| SO48393_11 | 5B6A-41B6-BF | PO9599137631 | 100 | 285 | 387 | 170 | 5 | 2023-03-25 | 1800.79 | 45.02 | 2023-03-13 | 3 | 605.65 | 1 | 1800.79 | 11 | SO48393 | 2023-03-20 | 144.06 | 1816.95 | 600.26 | |||
| SO51874_4 | 0176-4E11-91 | PO9773132815 | 100 | 285 | 555 | 8 | 5 | 2023-11-23 | 63.90 | 1.60 | 2023-11-11 | 1 | 47.29 | 1 | 63.90 | 4 | SO51874 | 2023-11-18 | 5.11 | 47.29 | 63.90 | |||
| SO43875_7 | CE1F-4E31-89 | PO12586178184 | 100 | 285 | 344 | 278 | 5 | 2021-11-23 | 12239.96 | 306.00 | 2021-11-11 | 6 | 1912.15 | 1 | 12239.96 | 7 | SO43875 | 2021-11-18 | 979.20 | 11472.93 | 2039.99 | |||
| SO71948_16 | DCEE-428D-87 | PO9599179297 | 100 | 285 | 434 | 170 | 5 | 2024-09-23 | 1784.49 | 44.61 | 2024-09-11 | 5 | 360.94 | 1 | 1784.49 | 16 | SO71948 | 2024-09-18 | 142.76 | 1804.71 | 356.90 | |||
| SO51864_6 | 2389-4E32-92 | PO5568126648 | 100 | 285 | 487 | 422 | 5 | 2023-11-23 | 98.98 | 2.47 | 2023-11-11 | 3 | 20.57 | 1 | 98.98 | 6 | SO51864 | 2023-11-18 | 7.92 | 61.70 | 32.99 | |||
| SO46047_2 | 2520-47B8-B9 | PO16211157418 | 100 | 285 | 349 | 99 | 5 | 2022-08-23 | 10124.97 | 253.12 | 2022-08-11 | 5 | 1898.09 | 1 | 10124.97 | 2 | SO46047 | 2022-08-18 | 810.00 | 9490.47 | 2024.99 | |||
| SO63246_11 | 5008-4978-B3 | PO7598198768 | 100 | 285 | 584 | 45 | 5 | 2024-05-25 | 323.99 | 8.10 | 2024-05-13 | 1 | 343.65 | 1 | 323.99 | 11 | SO63246 | 2024-05-20 | 25.92 | 343.65 | 323.99 | |||
| SO48063_16 | AEA4-4489-90 | PO5858143254 | 100 | 285 | 427 | 566 | 5 | 2023-02-23 | 418.51 | 10.46 | 2023-02-11 | 2 | 185.82 | 1 | 418.51 | 16 | SO48063 | 2023-02-18 | 33.48 | 371.64 | 209.26 | |||
| SO57027_2 | 15A6-4057-85 | PO16965111189 | 100 | 285 | 483 | 441 | 5 | 2024-02-23 | 432.00 | 10.80 | 2024-02-11 | 6 | 44.88 | 1 | 432.00 | 2 | SO57027 | 2024-02-18 | 34.56 | 269.28 | 72.00 | |||
| SO57104_8 | D4EE-4716-83 | PO18560117786 | 100 | 285 | 580 | 531 | 5 | 2024-02-23 | 2041.19 | 51.03 | 2024-02-11 | 2 | 1082.51 | 1 | 2041.19 | 8 | SO57104 | 2024-02-18 | 163.30 | 2165.02 | 1020.59 | |||
| SO45551_1 | 5C52-4027-BE | PO1943115167 | 100 | 285 | 319 | 525 | 5 | 2022-06-23 | 3499.18 | 87.48 | 2022-06-11 | 4 | 884.71 | 1 | 3499.18 | 1 | SO45551 | 2022-06-18 | 279.93 | 3538.83 | 874.79 | |||
| SO53474_7 | E5B6-4103-8D | PO15457187993 | 100 | 285 | 564 | 14 | 297 | 5 | 190.73 | 2023-12-24 | 953.63 | 19.07 | 2023-12-12 | 1 | 1481.94 | 1 | 762.90 | 7 | SO53474 | 2023-12-19 | 61.03 | 1481.94 | 953.63 | 0.20 |
| SO67260_27 | 6224-4229-B8 | PO522163557 | 100 | 285 | 542 | 676 | 5 | 2024-07-24 | 72.88 | 1.82 | 2024-07-12 | 3 | 17.98 | 1 | 72.88 | 27 | SO67260 | 2024-07-19 | 5.83 | 53.93 | 24.29 | |||
| SO46099_8 | 7E3B-4362-99 | PO7598165395 | 100 | 285 | 334 | 45 | 5 | 2022-08-23 | 419.46 | 10.49 | 2022-08-11 | 1 | 413.15 | 1 | 419.46 | 8 | SO46099 | 2022-08-18 | 33.56 | 413.15 | 419.46 | |||
| SO45805_15 | 4E35-406B-B7 | PO3393138494 | 100 | 285 | 334 | 549 | 5 | 2022-07-24 | 1258.38 | 31.46 | 2022-07-12 | 3 | 413.15 | 1 | 1258.38 | 15 | SO45805 | 2022-07-19 | 100.67 | 1239.44 | 419.46 | |||
| SO67348_27 | 4BD1-4782-A3 | PO9889141767 | 100 | 285 | 298 | 494 | 5 | 2024-07-24 | 809.76 | 20.24 | 2024-07-12 | 1 | 739.04 | 1 | 809.76 | 27 | SO67348 | 2024-07-19 | 64.78 | 739.04 | 809.76 | |||
| SO48015_2 | AA12-417E-B1 | PO11803141907 | 100 | 285 | 360 | 513 | 5 | 2023-02-23 | 1229.46 | 30.74 | 2023-02-11 | 1 | 1105.81 | 1 | 1229.46 | 2 | SO48015 | 2023-02-18 | 98.36 | 1105.81 | 1229.46 | |||
| SO57162_17 | 83B5-43A6-BD | PO3596174424 | 100 | 285 | 531 | 476 | 5 | 2024-02-23 | 599.50 | 14.99 | 2024-02-11 | 4 | 136.79 | 1 | 599.50 | 17 | SO57162 | 2024-02-18 | 47.96 | 547.14 | 149.87 | |||
| SO51853_18 | 3754-4D33-92 | PO3596145757 | 100 | 285 | 512 | 476 | 5 | 2023-11-23 | 655.36 | 16.38 | 2023-11-11 | 3 | 199.38 | 1 | 655.36 | 18 | SO51853 | 2023-11-18 | 52.43 | 598.13 | 218.45 | |||
| SO49124_5 | 795F-4192-AD | PO3596184634 | 100 | 285 | 420 | 476 | 5 | 2023-05-26 | 283.23 | 7.08 | 2023-05-14 | 2 | 104.80 | 1 | 283.23 | 5 | SO49124 | 2023-05-21 | 22.66 | 209.59 | 141.62 | |||
| SO51824_24 | A1F7-477E-BA | PO5800114202 | 100 | 285 | 501 | 63 | 5 | 2023-11-23 | 72.88 | 1.82 | 2023-11-11 | 1 | 53.93 | 1 | 72.88 | 24 | SO51824 | 2023-11-18 | 5.83 | 53.93 | 72.88 | |||
| SO44488_19 | 18BD-4C15-81 | PO19546136242 | 100 | 285 | 223 | 206 | 5 | 2022-02-23 | 10.37 | 0.26 | 2022-02-11 | 2 | 5.71 | 1 | 10.37 | 19 | SO44488 | 2022-02-18 | 0.83 | 11.41 | 5.19 | |||
| SO71942_2 | A5F9-49B1-92 | PO9222123146 | 100 | 285 | 481 | 171 | 5 | 2024-09-23 | 5.39 | 0.13 | 2024-09-11 | 1 | 3.36 | 1 | 5.39 | 2 | SO71942 | 2024-09-18 | 0.43 | 3.36 | 5.39 | |||
| SO48359_47 | BFAE-4CA5-83 | PO2813116854 | 100 | 272 | 224 | 90 | 5 | 2023-03-25 | 10.37 | 0.26 | 2023-03-13 | 2 | 5.23 | 1 | 10.37 | 47 | SO48359 | 2023-03-20 | 0.83 | 10.46 | 5.19 | |||
| SO44304_4 | D34C-4225-A3 | PO10179168311 | 100 | 285 | 296 | 27 | 5 | 2022-01-23 | 714.70 | 17.87 | 2022-01-11 | 1 | 617.03 | 1 | 714.70 | 4 | SO44304 | 2022-01-18 | 57.18 | 617.03 | 714.70 | |||
| SO51864_14 | 2389-4E32-92 | PO5568126648 | 100 | 285 | 234 | 422 | 5 | 2023-11-23 | 89.98 | 2.25 | 2023-11-11 | 3 | 38.49 | 1 | 89.98 | 14 | SO51864 | 2023-11-18 | 7.20 | 115.48 | 29.99 | |||
| SO55253_8 | C58B-49D8-9F | PO12644132539 | 100 | 285 | 476 | 4 | 530 | 5 | 90.99 | 2024-01-23 | 909.87 | 20.47 | 2024-01-11 | 26 | 26.18 | 1 | 818.88 | 8 | SO55253 | 2024-01-18 | 65.51 | 680.58 | 35.00 | 0.10 |
| SO48359_31 | BFAE-4CA5-83 | PO2813116854 | 100 | 272 | 271 | 90 | 5 | 2023-03-25 | 1820.99 | 45.52 | 2023-03-13 | 9 | 187.16 | 1 | 1820.99 | 31 | SO48359 | 2023-03-20 | 145.68 | 1684.41 | 202.33 | |||
| SO44102_1 | BAC5-4B76-AB | PO11426145969 | 100 | 285 | 319 | 386 | 5 | 2021-12-24 | 1749.59 | 43.74 | 2021-12-12 | 2 | 884.71 | 1 | 1749.59 | 1 | SO44102 | 2021-12-19 | 139.97 | 1769.42 | 874.79 |
Generated 2024-11-10 09:55:56.041 UTC