[ROOT] dt FactResellerSale < WHERE DimSalesTerritoryId EQ '4' > SHUFFLE SKIP 2000 < SKIP 500 > < 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 |
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
| SO47048_1 | F65E-4A78-AE | PO6351144877 | 100 | 283 | 323 | 255 | 4 | 2022-11-22 | 469.79 | 11.74 | 2022-11-10 | 1 | 486.71 | 1 | 469.79 | 1 | SO47048 | 2022-11-17 | 37.58 | 486.71 | 469.79 | |||
| SO46648_32 | 2073-4051-9E | PO2494191557 | 100 | 283 | 213 | 8 | 184 | 4 | 13.46 | 2022-10-22 | 134.58 | 3.03 | 2022-10-10 | 8 | 13.88 | 1 | 121.12 | 32 | SO46648 | 2022-10-17 | 9.69 | 111.03 | 16.82 | 0.10 |
| SO46970_32 | 01AF-420A-B9 | PO15196114472 | 100 | 282 | 435 | 258 | 4 | 2022-11-22 | 648.91 | 16.22 | 2022-11-10 | 2 | 300.12 | 1 | 648.91 | 32 | SO46970 | 2022-11-17 | 51.91 | 600.24 | 324.45 | |||
| SO46638_36 | 9659-44CE-A2 | PO10817110834 | 100 | 287 | 415 | 203 | 4 | 2022-10-22 | 396.07 | 9.90 | 2022-10-10 | 2 | 146.55 | 1 | 396.07 | 36 | SO46638 | 2022-10-17 | 31.69 | 293.09 | 198.04 | |||
| SO59026_3 | 6264-4C83-B2 | PO4002182599 | 100 | 282 | 491 | 674 | 4 | 2024-03-23 | 129.58 | 3.24 | 2024-03-11 | 4 | 41.57 | 1 | 129.58 | 3 | SO59026 | 2024-03-18 | 10.37 | 166.29 | 32.39 | |||
| SO71896_9 | A37A-4B16-B0 | PO4640135042 | 100 | 287 | 588 | 648 | 4 | 2024-09-22 | 923.39 | 23.08 | 2024-09-10 | 2 | 419.78 | 1 | 923.39 | 9 | SO71896 | 2024-09-17 | 73.87 | 839.56 | 461.69 | |||
| SO71890_3 | D31D-413E-BB | PO5510169156 | 100 | 287 | 234 | 5 | 4 | 2024-09-22 | 179.96 | 4.50 | 2024-09-10 | 6 | 38.49 | 1 | 179.96 | 3 | SO71890 | 2024-09-17 | 14.40 | 230.95 | 29.99 | |||
| SO49821_1 | 0B9B-460C-BC | PO551117366 | 100 | 281 | 325 | 4 | 4 | 2023-07-23 | 1879.18 | 46.98 | 2023-07-11 | 4 | 486.71 | 1 | 1879.18 | 1 | SO49821 | 2023-07-18 | 150.33 | 1946.83 | 469.79 | |||
| SO57034_34 | 57D0-46D3-B7 | PO15689142548 | 100 | 281 | 581 | 328 | 4 | 2024-02-22 | 7144.16 | 178.60 | 2024-02-10 | 7 | 1082.51 | 1 | 7144.16 | 34 | SO57034 | 2024-02-17 | 571.53 | 7577.57 | 1020.59 | |||
| SO53580_18 | FFE9-4F36-B2 | PO4640164085 | 100 | 287 | 359 | 648 | 4 | 2023-12-23 | 2753.99 | 68.85 | 2023-12-11 | 2 | 1251.98 | 1 | 2753.99 | 18 | SO53580 | 2023-12-18 | 220.32 | 2503.96 | 1376.99 | |||
| SO47045_31 | 9DDC-4176-90 | PO6438144434 | 100 | 283 | 411 | 309 | 4 | 2022-11-22 | 250.83 | 6.27 | 2022-11-10 | 2 | 92.81 | 1 | 250.83 | 31 | SO47045 | 2022-11-17 | 20.07 | 185.61 | 125.42 | |||
| SO47049_31 | 3D73-4468-AE | PO6525111066 | 100 | 283 | 364 | 345 | 4 | 2022-11-22 | 647.99 | 16.20 | 2022-11-10 | 1 | 598.44 | 1 | 647.99 | 31 | SO47049 | 2022-11-17 | 51.84 | 598.44 | 647.99 | |||
| SO51842_32 | 2A39-4E97-9A | PO4843199898 | 100 | 287 | 545 | 257 | 4 | 2023-11-22 | 48.59 | 1.21 | 2023-11-10 | 2 | 17.98 | 1 | 48.59 | 32 | SO51842 | 2023-11-17 | 3.89 | 35.96 | 24.29 | |||
| SO51809_47 | F690-4F1D-B1 | PO6438145374 | 100 | 281 | 588 | 309 | 4 | 2023-11-22 | 2308.47 | 57.71 | 2023-11-10 | 5 | 419.78 | 1 | 2308.47 | 47 | SO51809 | 2023-11-17 | 184.68 | 2098.89 | 461.69 | |||
| SO50214_19 | 97D5-41D3-8F | PO15196120916 | 100 | 282 | 370 | 258 | 4 | 2023-08-22 | 2932.02 | 73.30 | 2023-08-10 | 2 | 1518.79 | 1 | 2932.02 | 19 | SO50214 | 2023-08-17 | 234.56 | 3037.57 | 1466.01 | |||
| SO57042_14 | 52C4-4348-BC | PO15196150289 | 100 | 282 | 547 | 258 | 4 | 2024-02-22 | 242.97 | 6.07 | 2024-02-10 | 5 | 35.96 | 1 | 242.97 | 14 | SO57042 | 2024-02-17 | 19.44 | 179.80 | 48.59 | |||
| SO51795_16 | 30DF-4333-9E | PO15921146523 | 100 | 287 | 214 | 77 | 4 | 2023-11-22 | 104.97 | 2.62 | 2023-11-10 | 5 | 13.09 | 1 | 104.97 | 16 | SO51795 | 2023-11-17 | 8.40 | 65.43 | 20.99 | |||
| SO46970_23 | 01AF-420A-B9 | PO15196114472 | 100 | 282 | 263 | 258 | 4 | 2022-11-22 | 202.33 | 5.06 | 2022-11-10 | 1 | 187.16 | 1 | 202.33 | 23 | SO46970 | 2022-11-17 | 16.19 | 187.16 | 202.33 | |||
| SO45299_1 | 0D55-4B85-AD | PO12557162961 | 100 | 282 | 223 | 240 | 4 | 2022-05-25 | 15.56 | 0.39 | 2022-05-13 | 3 | 5.71 | 1 | 15.56 | 1 | SO45299 | 2022-05-20 | 1.24 | 17.12 | 5.19 | |||
| SO57128_23 | 52E0-4277-80 | PO6525176590 | 100 | 281 | 516 | 345 | 4 | 2024-02-22 | 93.94 | 2.35 | 2024-02-10 | 4 | 17.38 | 1 | 93.94 | 23 | SO57128 | 2024-02-17 | 7.51 | 69.51 | 23.48 | |||
| SO57144_31 | 074E-478C-99 | PO3799111077 | 100 | 282 | 588 | 312 | 4 | 2024-02-22 | 923.39 | 23.08 | 2024-02-10 | 2 | 419.78 | 1 | 923.39 | 31 | SO57144 | 2024-02-17 | 73.87 | 839.56 | 461.69 | |||
| SO49099_7 | D567-4CCE-A4 | PO15689170019 | 100 | 281 | 323 | 328 | 4 | 2023-05-25 | 2348.97 | 58.72 | 2023-05-13 | 5 | 486.71 | 1 | 2348.97 | 7 | SO49099 | 2023-05-20 | 187.92 | 2433.53 | 469.79 | |||
| SO47658_30 | C574-484B-83 | PO551177057 | 100 | 283 | 271 | 4 | 4 | 2023-01-22 | 1618.66 | 40.47 | 2023-01-10 | 8 | 187.16 | 1 | 1618.66 | 30 | SO47658 | 2023-01-17 | 129.49 | 1497.26 | 202.33 | |||
| SO50720_18 | 38E2-4AA6-B4 | PO9715181953 | 100 | 281 | 308 | 490 | 4 | 2023-09-22 | 744.27 | 18.61 | 2023-09-10 | 1 | 660.91 | 1 | 744.27 | 18 | SO50720 | 2023-09-17 | 59.54 | 660.91 | 744.27 | |||
| SO53616_9 | A692-4827-93 | PO6786150961 | 100 | 281 | 234 | 3 | 3 | 4 | 20.62 | 2023-12-23 | 412.42 | 9.79 | 2023-12-11 | 15 | 38.49 | 1 | 391.80 | 9 | SO53616 | 2023-12-18 | 31.34 | 577.38 | 27.49 | 0.05 |
| SO51090_58 | EBDE-4A71-8E | PO13688110947 | 100 | 282 | 471 | 3 | 475 | 4 | 26.19 | 2023-10-22 | 523.88 | 12.44 | 2023-10-10 | 15 | 23.75 | 1 | 497.68 | 58 | SO51090 | 2023-10-17 | 39.81 | 356.24 | 34.93 | 0.05 |
| SO58919_12 | AF42-4FCB-BB | PO17052190887 | 100 | 282 | 569 | 420 | 4 | 2024-03-23 | 890.82 | 22.27 | 2024-03-11 | 2 | 461.44 | 1 | 890.82 | 12 | SO58919 | 2024-03-18 | 71.27 | 922.89 | 445.41 | |||
| SO46988_13 | 2D2E-4EC3-AC | PO12499171502 | 100 | 282 | 459 | 78 | 4 | 2022-11-22 | 377.96 | 9.45 | 2022-11-10 | 7 | 37.12 | 1 | 377.96 | 13 | SO46988 | 2022-11-17 | 30.24 | 259.85 | 53.99 | |||
| SO46960_9 | F05E-41EB-90 | PO16762181648 | 100 | 282 | 323 | 259 | 4 | 2022-11-22 | 1409.38 | 35.23 | 2022-11-10 | 3 | 486.71 | 1 | 1409.38 | 9 | SO46960 | 2022-11-17 | 112.75 | 1460.12 | 469.79 | |||
| SO49058_12 | BD1B-4C7F-A9 | PO12499147561 | 100 | 282 | 433 | 78 | 4 | 2023-05-25 | 324.45 | 8.11 | 2023-05-13 | 1 | 300.12 | 1 | 324.45 | 12 | SO49058 | 2023-05-20 | 25.96 | 300.12 | 324.45 | |||
| SO53531_27 | B1FB-47B2-8E | PO2697181370 | 100 | 282 | 512 | 187 | 4 | 2023-12-23 | 1747.63 | 43.69 | 2023-12-11 | 8 | 199.38 | 1 | 1747.63 | 27 | SO53531 | 2023-12-18 | 139.81 | 1595.01 | 218.45 |
Generated 2024-11-10 03:09:22.123 UTC