[ROOT] dt FactResellerSale < WHERE DimSalesTerritoryId EQ '4' > SHUFFLE SKIP 2000 < SKIP 345 > < 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 |
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
| SO44317_28 | BE9B-42BA-87 | PO7859142280 | 100 | 287 | 223 | 221 | 4 | 2022-01-23 | 51.87 | 1.30 | 2022-01-11 | 10 | 5.71 | 1 | 51.87 | 28 | SO44317 | 2022-01-18 | 4.15 | 57.05 | 5.19 | |||
| SO44754_11 | 2F58-4025-92 | PO15834116970 | 100 | 283 | 212 | 417 | 4 | 2022-03-25 | 20.19 | 0.50 | 2022-03-13 | 1 | 12.03 | 1 | 20.19 | 11 | SO44754 | 2022-03-20 | 1.61 | 12.03 | 20.19 | |||
| SO50252_14 | B5DA-491E-A9 | PO2523194031 | 100 | 287 | 381 | 167 | 4 | 2023-08-23 | 2401.05 | 60.03 | 2023-08-11 | 4 | 605.65 | 1 | 2401.05 | 14 | SO50252 | 2023-08-18 | 192.08 | 2422.60 | 600.26 | |||
| SO45560_4 | B195-4977-8E | PO4640111403 | 100 | 287 | 218 | 648 | 4 | 2022-06-23 | 28.50 | 0.71 | 2022-06-11 | 5 | 3.40 | 1 | 28.50 | 4 | SO45560 | 2022-06-18 | 2.28 | 16.98 | 5.70 | |||
| SO44299_8 | AFF1-4CD9-9A | PO10817117580 | 100 | 287 | 232 | 203 | 4 | 2022-01-23 | 28.84 | 0.72 | 2022-01-11 | 1 | 31.72 | 1 | 28.84 | 8 | SO44299 | 2022-01-18 | 2.31 | 31.72 | 28.84 | |||
| SO45059_14 | C618-4998-BE | PO10730115502 | 100 | 287 | 330 | 491 | 4 | 2022-04-25 | 838.92 | 20.97 | 2022-04-13 | 2 | 413.15 | 1 | 838.92 | 14 | SO45059 | 2022-04-20 | 67.11 | 826.29 | 419.46 | |||
| SO55282_27 | A72A-4D3A-BA | PO16298125578 | 100 | 287 | 565 | 599 | 4 | 2024-01-23 | 1336.23 | 33.41 | 2024-01-11 | 3 | 461.44 | 1 | 1336.23 | 27 | SO55282 | 2024-01-18 | 106.90 | 1384.33 | 445.41 | |||
| SO49851_3 | 14FB-4B97-95 | PO2494142030 | 100 | 281 | 458 | 2 | 184 | 4 | 9.57 | 2023-07-24 | 478.44 | 11.72 | 2023-07-12 | 11 | 30.93 | 1 | 468.87 | 3 | SO49851 | 2023-07-19 | 37.51 | 340.27 | 43.49 | 0.02 |
| SO50743_6 | C1F5-4D36-9F | PO4640120853 | 100 | 287 | 399 | 648 | 4 | 2023-09-23 | 67.55 | 1.69 | 2023-09-11 | 2 | 24.99 | 1 | 67.55 | 6 | SO50743 | 2023-09-18 | 5.40 | 49.99 | 33.77 | |||
| SO47372_6 | 70B5-428B-86 | PO16124198007 | 100 | 282 | 236 | 649 | 4 | 2022-12-24 | 28.84 | 0.72 | 2022-12-12 | 1 | 29.08 | 1 | 28.84 | 6 | SO47372 | 2022-12-19 | 2.31 | 29.08 | 28.84 | |||
| SO71896_10 | A37A-4B16-B0 | PO4640135042 | 100 | 287 | 359 | 648 | 4 | 2024-09-23 | 2753.99 | 68.85 | 2024-09-11 | 2 | 1251.98 | 1 | 2753.99 | 10 | SO71896 | 2024-09-18 | 220.32 | 2503.96 | 1376.99 | |||
| SO50702_7 | 6D0A-413E-BE | PO2697119650 | 100 | 282 | 308 | 187 | 4 | 2023-09-23 | 744.27 | 18.61 | 2023-09-11 | 1 | 660.91 | 1 | 744.27 | 7 | SO50702 | 2023-09-18 | 59.54 | 660.91 | 744.27 | |||
| SO53533_26 | B8B0-46C0-AF | PO18038134377 | 100 | 287 | 560 | 509 | 4 | 2023-12-24 | 1457.82 | 36.45 | 2023-12-12 | 2 | 755.15 | 1 | 1457.82 | 26 | SO53533 | 2023-12-19 | 116.63 | 1510.30 | 728.91 | |||
| SO50753_22 | 8073-4F97-BA | PO7569170218 | 100 | 287 | 409 | 608 | 4 | 2023-09-23 | 1046.28 | 26.16 | 2023-09-11 | 5 | 185.82 | 1 | 1046.28 | 22 | SO50753 | 2023-09-18 | 83.70 | 929.10 | 209.26 | |||
| SO51714_8 | D33A-4EAE-B1 | PO15689195197 | 100 | 281 | 243 | 328 | 4 | 2023-11-23 | 1717.80 | 42.95 | 2023-11-11 | 2 | 868.63 | 1 | 1717.80 | 8 | SO51714 | 2023-11-18 | 137.42 | 1737.27 | 858.90 | |||
| SO46942_3 | B18D-4253-81 | PO18647164826 | 100 | 282 | 420 | 583 | 4 | 2022-11-23 | 283.23 | 7.08 | 2022-11-11 | 2 | 104.80 | 1 | 283.23 | 3 | SO46942 | 2022-11-18 | 22.66 | 209.59 | 141.62 | |||
| SO49540_14 | FD60-4F29-B7 | PO6757123714 | 100 | 281 | 470 | 21 | 4 | 2023-06-23 | 182.35 | 4.56 | 2023-06-11 | 8 | 15.67 | 1 | 182.35 | 14 | SO49540 | 2023-06-18 | 14.59 | 125.37 | 22.79 | |||
| SO67292_22 | 09EF-4688-BB | PO551144976 | 100 | 281 | 372 | 4 | 4 | 2024-07-24 | 2932.02 | 73.30 | 2024-07-12 | 2 | 1554.95 | 1 | 2932.02 | 22 | SO67292 | 2024-07-19 | 234.56 | 3109.90 | 1466.01 | |||
| SO51745_29 | C261-441D-A5 | PO11745132954 | 100 | 282 | 380 | 97 | 4 | 2023-11-23 | 11728.08 | 293.20 | 2023-11-11 | 8 | 1554.95 | 1 | 11728.08 | 29 | SO51745 | 2023-11-18 | 938.25 | 12439.58 | 1466.01 | |||
| SO45070_4 | B035-4728-8C | PO5626126979 | 100 | 283 | 310 | 166 | 4 | 2022-04-25 | 4293.92 | 107.35 | 2022-04-13 | 2 | 2171.29 | 1 | 4293.92 | 4 | SO45070 | 2022-04-20 | 343.51 | 4342.59 | 2146.96 | |||
| SO51809_22 | F690-4F1D-B1 | PO6438145374 | 100 | 281 | 477 | 309 | 4 | 2023-11-23 | 8.98 | 0.22 | 2023-11-11 | 3 | 1.87 | 1 | 8.98 | 22 | SO51809 | 2023-11-18 | 0.72 | 5.60 | 2.99 | |||
| SO45317_6 | 92DD-46A2-8D | PO2523164373 | 100 | 272 | 334 | 167 | 4 | 2022-05-26 | 419.46 | 10.49 | 2022-05-14 | 1 | 413.15 | 1 | 419.46 | 6 | SO45317 | 2022-05-21 | 33.56 | 413.15 | 419.46 | |||
| SO50707_1 | C071-42D6-B3 | PO16124195115 | 100 | 282 | 327 | 649 | 4 | 2023-09-23 | 469.79 | 11.74 | 2023-09-11 | 1 | 486.71 | 1 | 469.79 | 1 | SO50707 | 2023-09-18 | 37.58 | 486.71 | 469.79 | |||
| SO51714_25 | D33A-4EAE-B1 | PO15689195197 | 100 | 281 | 408 | 328 | 4 | 2023-11-23 | 216.49 | 5.41 | 2023-11-11 | 3 | 53.40 | 1 | 216.49 | 25 | SO51714 | 2023-11-18 | 17.32 | 160.20 | 72.16 | |||
| SO46048_1 | DDA0-4A8A-9C | PO16037150345 | 100 | 282 | 344 | 384 | 4 | 2022-08-23 | 6119.98 | 153.00 | 2022-08-11 | 3 | 1912.15 | 1 | 6119.98 | 1 | SO46048 | 2022-08-18 | 489.60 | 5736.46 | 2039.99 | |||
| SO61218_46 | 8441-4C6F-89 | PO13688193778 | 100 | 282 | 472 | 475 | 4 | 2024-04-24 | 152.40 | 3.81 | 2024-04-12 | 4 | 23.75 | 1 | 152.40 | 46 | SO61218 | 2024-04-19 | 12.19 | 95.00 | 38.10 | |||
| SO49831_10 | 8BCC-466B-AB | PO13688123267 | 100 | 282 | 213 | 2 | 475 | 4 | 5.46 | 2023-07-24 | 273.19 | 6.69 | 2023-07-12 | 14 | 13.88 | 1 | 267.73 | 10 | SO49831 | 2023-07-19 | 21.42 | 194.29 | 19.51 | 0.02 |
| SO71782_26 | CA08-4A9B-8D | PO19372114749 | 100 | 282 | 586 | 582 | 4 | 2024-09-23 | 890.82 | 22.27 | 2024-09-11 | 2 | 461.44 | 1 | 890.82 | 26 | SO71782 | 2024-09-18 | 71.27 | 922.89 | 445.41 | |||
| SO71816_5 | 52D4-4F3B-9E | PO12992180445 | 100 | 282 | 490 | 295 | 4 | 2024-09-23 | 97.18 | 2.43 | 2024-09-11 | 3 | 41.57 | 1 | 97.18 | 5 | SO71816 | 2024-09-18 | 7.77 | 124.72 | 32.39 | |||
| SO71848_9 | 7082-4BF5-AB | PO18763153352 | 100 | 287 | 579 | 59 | 4 | 2024-09-23 | 728.91 | 18.22 | 2024-09-11 | 1 | 755.15 | 1 | 728.91 | 9 | SO71848 | 2024-09-18 | 58.31 | 755.15 | 728.91 | |||
| SO47417_22 | 1CE8-4651-A9 | PO2697165938 | 100 | 282 | 364 | 187 | 4 | 2022-12-24 | 647.99 | 16.20 | 2022-12-12 | 1 | 598.44 | 1 | 647.99 | 22 | SO47417 | 2022-12-19 | 51.84 | 598.44 | 647.99 |
Generated 2024-11-10 22:36:56.656 UTC