[ROOT] dt FactResellerSale < WHERE DimSalesTerritoryId EQ '4' > SHUFFLE < SKIP 2565 > < 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 |
---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
SO50745_27 | 02DB-4CC5-85 | PO5539140407 | 100 | 282 | 354 | 61 | 4 | 2023-09-23 | 2485.70 | 62.14 | 2023-09-11 | 2 | 1117.86 | 1 | 2485.70 | 27 | SO50745 | 2023-09-18 | 198.86 | 2235.71 | 1242.85 | |||
SO51856_35 | E170-419C-92 | PO3654183134 | 100 | 281 | 603 | 435 | 4 | 2023-11-23 | 364.47 | 9.11 | 2023-11-11 | 5 | 53.94 | 1 | 364.47 | 35 | SO51856 | 2023-11-18 | 29.16 | 269.71 | 72.89 | |||
SO57168_5 | B6D5-41ED-B9 | PO3480129742 | 100 | 281 | 408 | 436 | 4 | 2024-02-23 | 216.49 | 5.41 | 2024-02-11 | 3 | 53.40 | 1 | 216.49 | 5 | SO57168 | 2024-02-18 | 17.32 | 160.20 | 72.16 | |||
SO69536_22 | 9646-48B3-9E | PO3654177498 | 100 | 281 | 517 | 435 | 4 | 2024-08-23 | 126.34 | 3.16 | 2024-08-11 | 4 | 23.37 | 1 | 126.34 | 22 | SO69536 | 2024-08-18 | 10.11 | 93.49 | 31.58 | |||
SO55282_39 | A72A-4D3A-BA | PO16298125578 | 100 | 287 | 561 | 4 | 599 | 4 | 3099.29 | 2024-01-23 | 30992.91 | 697.34 | 2024-01-11 | 26 | 1481.94 | 1 | 27893.62 | 39 | SO55282 | 2024-01-18 | 2231.49 | 38530.39 | 1192.04 | 0.10 |
SO48373_19 | 4C9A-49DD-BA | PO5539129597 | 100 | 282 | 308 | 61 | 4 | 2023-03-25 | 1488.55 | 37.21 | 2023-03-13 | 2 | 660.91 | 1 | 1488.55 | 19 | SO48373 | 2023-03-20 | 119.08 | 1321.83 | 744.27 | |||
SO45301_27 | 0BA8-4928-A7 | PO12499190711 | 100 | 282 | 319 | 78 | 4 | 2022-05-26 | 1749.59 | 43.74 | 2022-05-14 | 2 | 884.71 | 1 | 1749.59 | 27 | SO45301 | 2022-05-21 | 139.97 | 1769.42 | 874.79 | |||
SO61188_4 | 0CFA-4338-90 | PO12528143455 | 100 | 282 | 564 | 331 | 4 | 2024-04-24 | 2860.88 | 71.52 | 2024-04-12 | 2 | 1481.94 | 1 | 2860.88 | 4 | SO61188 | 2024-04-19 | 228.87 | 2963.88 | 1430.44 | |||
SO46343_5 | 2DB3-460D-85 | PO15167181233 | 100 | 283 | 317 | 273 | 4 | 2022-09-23 | 874.79 | 21.87 | 2022-09-11 | 1 | 884.71 | 1 | 874.79 | 5 | SO46343 | 2022-09-18 | 69.98 | 884.71 | 874.79 | |||
SO50272_1 | E0A6-4CFA-90 | PO11745174916 | 100 | 282 | 335 | 97 | 4 | 2023-08-23 | 469.79 | 11.74 | 2023-08-11 | 1 | 486.71 | 1 | 469.79 | 1 | SO50272 | 2023-08-18 | 37.58 | 486.71 | 469.79 | |||
SO47049_27 | 3D73-4468-AE | PO6525111066 | 100 | 283 | 367 | 345 | 4 | 2022-11-23 | 4535.96 | 113.40 | 2022-11-11 | 7 | 598.44 | 1 | 4535.96 | 27 | SO47049 | 2022-11-18 | 362.88 | 4189.05 | 647.99 | |||
SO71882_21 | D5D4-42D4-91 | PO5597123008 | 100 | 281 | 558 | 75 | 4 | 2024-09-23 | 485.99 | 12.15 | 2024-09-11 | 2 | 179.82 | 1 | 485.99 | 21 | SO71882 | 2024-09-18 | 38.88 | 359.63 | 242.99 | |||
SO57157_21 | 2435-487B-AC | PO4843135815 | 100 | 287 | 545 | 257 | 4 | 2024-02-23 | 24.29 | 0.61 | 2024-02-11 | 1 | 17.98 | 1 | 24.29 | 21 | SO57157 | 2024-02-18 | 1.94 | 17.98 | 24.29 | |||
SO46642_36 | 0A4E-465C-BB | PO551133122 | 100 | 283 | 435 | 4 | 4 | 2022-10-23 | 1622.26 | 40.56 | 2022-10-11 | 5 | 300.12 | 1 | 1622.26 | 36 | SO46642 | 2022-10-18 | 129.78 | 1500.59 | 324.45 | |||
SO45059_13 | C618-4998-BE | PO10730115502 | 100 | 287 | 334 | 491 | 4 | 2022-04-25 | 419.46 | 10.49 | 2022-04-13 | 1 | 413.15 | 1 | 419.46 | 13 | SO45059 | 2022-04-20 | 33.56 | 413.15 | 419.46 | |||
SO45534_7 | F5A4-4CEE-97 | PO14964111594 | 100 | 287 | 300 | 581 | 4 | 2022-06-23 | 809.76 | 20.24 | 2022-06-11 | 1 | 699.09 | 1 | 809.76 | 7 | SO45534 | 2022-06-18 | 64.78 | 699.09 | 809.76 | |||
SO51122_20 | D915-4225-97 | PO551181465 | 100 | 281 | 481 | 4 | 4 | 2023-10-23 | 53.94 | 1.35 | 2023-10-11 | 10 | 3.36 | 1 | 53.94 | 20 | SO51122 | 2023-10-18 | 4.32 | 33.62 | 5.39 | |||
SO53616_36 | A692-4827-93 | PO6786150961 | 100 | 281 | 584 | 3 | 4 | 2023-12-24 | 647.99 | 16.20 | 2023-12-12 | 2 | 343.65 | 1 | 647.99 | 36 | SO53616 | 2023-12-19 | 51.84 | 687.30 | 323.99 | |||
SO59013_23 | C224-4535-BA | PO5597199820 | 100 | 281 | 476 | 75 | 4 | 2024-03-24 | 335.95 | 8.40 | 2024-03-12 | 8 | 26.18 | 1 | 335.95 | 23 | SO59013 | 2024-03-19 | 26.88 | 209.41 | 41.99 | |||
SO65160_5 | 9375-44FE-94 | PO19343172976 | 100 | 282 | 231 | 24 | 4 | 2024-06-23 | 149.97 | 3.75 | 2024-06-11 | 5 | 38.49 | 1 | 149.97 | 5 | SO65160 | 2024-06-18 | 12.00 | 192.46 | 29.99 | |||
SO46660_5 | CF24-45E2-9D | PO5626129733 | 100 | 283 | 254 | 166 | 4 | 2022-10-23 | 1287.57 | 32.19 | 2022-10-11 | 7 | 170.14 | 1 | 1287.57 | 5 | SO46660 | 2022-10-18 | 103.01 | 1191.00 | 183.94 | |||
SO67318_8 | 5460-4BEE-A6 | PO6409141464 | 100 | 281 | 471 | 292 | 4 | 2024-07-24 | 152.40 | 3.81 | 2024-07-12 | 4 | 23.75 | 1 | 152.40 | 8 | SO67318 | 2024-07-19 | 12.19 | 95.00 | 38.10 | |||
SO46964_47 | B3E6-43CC-A2 | PO15689139014 | 100 | 283 | 343 | 328 | 4 | 2022-11-23 | 1409.38 | 35.23 | 2022-11-11 | 3 | 486.71 | 1 | 1409.38 | 47 | SO46964 | 2022-11-18 | 112.75 | 1460.12 | 469.79 | |||
SO58919_6 | AF42-4FCB-BB | PO17052190887 | 100 | 282 | 577 | 420 | 4 | 2024-03-24 | 728.91 | 18.22 | 2024-03-12 | 1 | 755.15 | 1 | 728.91 | 6 | SO58919 | 2024-03-19 | 58.31 | 755.15 | 728.91 | |||
SO47676_1 | 5DD7-4A1E-9B | PO13659142296 | 100 | 272 | 469 | 437 | 4 | 2023-01-23 | 182.35 | 4.56 | 2023-01-11 | 8 | 15.67 | 1 | 182.35 | 1 | SO47676 | 2023-01-18 | 14.59 | 125.37 | 22.79 | |||
SO45565_4 | B963-45A4-B4 | PO5597130894 | 100 | 283 | 348 | 75 | 4 | 2022-06-23 | 4049.99 | 101.25 | 2022-06-11 | 2 | 1898.09 | 1 | 4049.99 | 4 | SO45565 | 2022-06-18 | 324.00 | 3796.19 | 2024.99 | |||
SO47658_22 | C574-484B-83 | PO551177057 | 100 | 283 | 368 | 4 | 4 | 2023-01-23 | 10262.07 | 256.55 | 2023-01-11 | 7 | 1518.79 | 1 | 10262.07 | 22 | SO47658 | 2023-01-18 | 820.97 | 10631.50 | 1466.01 | |||
SO57137_15 | 9401-4518-A4 | PO6438194874 | 100 | 281 | 491 | 309 | 4 | 2024-02-23 | 129.58 | 3.24 | 2024-02-11 | 4 | 41.57 | 1 | 129.58 | 15 | SO57137 | 2024-02-18 | 10.37 | 166.29 | 32.39 | |||
SO47658_6 | C574-484B-83 | PO551177057 | 100 | 283 | 337 | 4 | 4 | 2023-01-23 | 3288.56 | 82.21 | 2023-01-11 | 7 | 486.71 | 1 | 3288.56 | 6 | SO47658 | 2023-01-18 | 263.08 | 3406.95 | 469.79 | |||
SO44317_15 | BE9B-42BA-87 | PO7859142280 | 100 | 287 | 272 | 221 | 4 | 2022-01-23 | 919.69 | 22.99 | 2022-01-11 | 5 | 181.49 | 1 | 919.69 | 15 | SO44317 | 2022-01-18 | 73.58 | 907.43 | 183.94 |
Generated 2024-11-10 10:04:36.249 UTC