[ROOT] dt FactResellerSale < WHERE DimSalesTerritoryId EQ ALL < SKIP 2810 > < 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 |
---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
SO51121_50 | 9E4C-40B6-B1 | PO10730114575 | 100 | 287 | 520 | 491 | 4 | 2023-09-02 | 94.75 | 2.37 | 2023-08-21 | 3 | 23.37 | 1 | 94.75 | 50 | SO51121 | 2023-08-28 | 7.58 | 70.12 | 31.58 | |||
SO58982_4 | EEA8-4A3B-AF | PO18125159249 | 100 | 287 | 384 | 311 | 4 | 2024-02-02 | 672.29 | 16.81 | 2024-01-21 | 1 | 713.08 | 1 | 672.29 | 4 | SO58982 | 2024-01-28 | 53.78 | 713.08 | 672.29 | |||
SO43879_16 | EDC5-4BD5-8F | PO11600128380 | 19 | 288 | 338 | 569 | 6 | 2021-10-03 | 419.46 | 10.49 | 2021-09-21 | 1 | 413.15 | 1 | 419.46 | 16 | SO43879 | 2021-09-28 | 33.56 | 413.15 | 419.46 | |||
SO47685_28 | CC2F-4D47-8C | PO11484129630 | 100 | 281 | 401 | 594 | 2 | 2022-12-03 | 459.21 | 11.48 | 2022-11-21 | 7 | 48.55 | 1 | 459.21 | 28 | SO47685 | 2022-11-28 | 36.74 | 339.82 | 65.60 | |||
SO51121_51 | 9E4C-40B6-B1 | PO10730114575 | 100 | 287 | 487 | 491 | 4 | 2023-09-02 | 98.98 | 2.47 | 2023-08-21 | 3 | 20.57 | 1 | 98.98 | 51 | SO51121 | 2023-08-28 | 7.92 | 61.70 | 32.99 | |||
SO58982_5 | EEA8-4A3B-AF | PO18125159249 | 100 | 287 | 376 | 311 | 4 | 2024-02-02 | 2932.02 | 73.30 | 2024-01-21 | 2 | 1554.95 | 1 | 2932.02 | 5 | SO58982 | 2024-01-28 | 234.56 | 3109.90 | 1466.01 | |||
SO43879_17 | EDC5-4BD5-8F | PO11600128380 | 19 | 288 | 215 | 569 | 6 | 2021-10-03 | 100.93 | 2.52 | 2021-09-21 | 5 | 12.03 | 1 | 100.93 | 17 | SO43879 | 2021-09-28 | 8.07 | 60.14 | 20.19 | |||
SO47685_29 | CC2F-4D47-8C | PO11484129630 | 100 | 281 | 399 | 594 | 2 | 2022-12-03 | 67.55 | 1.69 | 2022-11-21 | 2 | 24.99 | 1 | 67.55 | 29 | SO47685 | 2022-11-28 | 5.40 | 49.99 | 33.77 | |||
SO51121_52 | 9E4C-40B6-B1 | PO10730114575 | 100 | 287 | 390 | 491 | 4 | 2023-09-02 | 2016.88 | 50.42 | 2023-08-21 | 3 | 713.08 | 1 | 2016.88 | 52 | SO51121 | 2023-08-28 | 161.35 | 2139.24 | 672.29 | |||
SO58982_6 | EEA8-4A3B-AF | PO18125159249 | 100 | 287 | 243 | 311 | 4 | 2024-02-02 | 858.90 | 21.47 | 2024-01-21 | 1 | 868.63 | 1 | 858.90 | 6 | SO58982 | 2024-01-28 | 68.71 | 868.63 | 858.90 | |||
SO43879_18 | EDC5-4BD5-8F | PO11600128380 | 19 | 288 | 319 | 569 | 6 | 2021-10-03 | 2624.38 | 65.61 | 2021-09-21 | 3 | 884.71 | 1 | 2624.38 | 18 | SO43879 | 2021-09-28 | 209.95 | 2654.12 | 874.79 | |||
SO47685_30 | CC2F-4D47-8C | PO11484129630 | 100 | 281 | 421 | 594 | 2 | 2022-12-03 | 392.66 | 9.82 | 2022-11-21 | 2 | 145.28 | 1 | 392.66 | 30 | SO47685 | 2022-11-28 | 31.41 | 290.57 | 196.33 | |||
SO51121_53 | 9E4C-40B6-B1 | PO10730114575 | 100 | 287 | 243 | 491 | 4 | 2023-09-02 | 1717.80 | 42.95 | 2023-08-21 | 2 | 868.63 | 1 | 1717.80 | 53 | SO51121 | 2023-08-28 | 137.42 | 1737.27 | 858.90 | |||
SO58982_7 | EEA8-4A3B-AF | PO18125159249 | 100 | 287 | 584 | 311 | 4 | 2024-02-02 | 323.99 | 8.10 | 2024-01-21 | 1 | 343.65 | 1 | 323.99 | 7 | SO58982 | 2024-01-28 | 25.92 | 343.65 | 323.99 | |||
SO43879_19 | EDC5-4BD5-8F | PO11600128380 | 19 | 288 | 317 | 569 | 6 | 2021-10-03 | 874.79 | 21.87 | 2021-09-21 | 1 | 884.71 | 1 | 874.79 | 19 | SO43879 | 2021-09-28 | 69.98 | 884.71 | 874.79 | |||
SO47685_31 | CC2F-4D47-8C | PO11484129630 | 100 | 281 | 419 | 594 | 2 | 2022-12-03 | 263.24 | 6.58 | 2022-11-21 | 5 | 38.96 | 1 | 263.24 | 31 | SO47685 | 2022-11-28 | 21.06 | 194.79 | 52.65 | |||
SO51122_1 | D915-4225-97 | PO551181465 | 100 | 281 | 581 | 4 | 4 | 2023-09-02 | 3061.78 | 76.54 | 2023-08-21 | 3 | 1082.51 | 1 | 3061.78 | 1 | SO51122 | 2023-08-28 | 244.94 | 3247.53 | 1020.59 | |||
SO58982_8 | EEA8-4A3B-AF | PO18125159249 | 100 | 287 | 581 | 311 | 4 | 2024-02-02 | 3061.78 | 76.54 | 2024-01-21 | 3 | 1082.51 | 1 | 3061.78 | 8 | SO58982 | 2024-01-28 | 244.94 | 3247.53 | 1020.59 | |||
SO43879_20 | EDC5-4BD5-8F | PO11600128380 | 19 | 288 | 285 | 569 | 6 | 2021-10-03 | 535.74 | 13.39 | 2021-09-21 | 3 | 176.20 | 1 | 535.74 | 20 | SO43879 | 2021-09-28 | 42.86 | 528.60 | 178.58 | |||
SO47685_32 | CC2F-4D47-8C | PO11484129630 | 100 | 281 | 221 | 594 | 2 | 2022-12-03 | 100.93 | 2.52 | 2022-11-21 | 5 | 13.88 | 1 | 100.93 | 32 | SO47685 | 2022-11-28 | 8.07 | 69.39 | 20.19 | |||
SO51122_2 | D915-4225-97 | PO551181465 | 100 | 281 | 604 | 4 | 4 | 2023-09-02 | 1295.98 | 32.40 | 2023-08-21 | 4 | 343.65 | 1 | 1295.98 | 2 | SO51122 | 2023-08-28 | 103.68 | 1374.60 | 323.99 | |||
SO58982_9 | EEA8-4A3B-AF | PO18125159249 | 100 | 287 | 545 | 311 | 4 | 2024-02-02 | 24.29 | 0.61 | 2024-01-21 | 1 | 17.98 | 1 | 24.29 | 9 | SO58982 | 2024-01-28 | 1.94 | 17.98 | 24.29 | |||
SO43879_21 | EDC5-4BD5-8F | PO11600128380 | 19 | 288 | 316 | 569 | 6 | 2021-10-03 | 1749.59 | 43.74 | 2021-09-21 | 2 | 884.71 | 1 | 1749.59 | 21 | SO43879 | 2021-09-28 | 139.97 | 1769.42 | 874.79 | |||
SO47685_33 | CC2F-4D47-8C | PO11484129630 | 100 | 281 | 468 | 594 | 2 | 2022-12-03 | 68.38 | 1.71 | 2022-11-21 | 3 | 15.67 | 1 | 68.38 | 33 | SO47685 | 2022-11-28 | 5.47 | 47.01 | 22.79 | |||
SO51122_3 | D915-4225-97 | PO551181465 | 100 | 281 | 606 | 4 | 4 | 2023-09-02 | 1619.97 | 40.50 | 2023-08-21 | 5 | 343.65 | 1 | 1619.97 | 3 | SO51122 | 2023-08-28 | 129.60 | 1718.25 | 323.99 | |||
SO58982_10 | EEA8-4A3B-AF | PO18125159249 | 100 | 287 | 481 | 311 | 4 | 2024-02-02 | 10.79 | 0.27 | 2024-01-21 | 2 | 3.36 | 1 | 10.79 | 10 | SO58982 | 2024-01-28 | 0.86 | 6.72 | 5.39 | |||
SO43879_22 | EDC5-4BD5-8F | PO11600128380 | 19 | 288 | 212 | 569 | 6 | 2021-10-03 | 80.75 | 2.02 | 2021-09-21 | 4 | 12.03 | 1 | 80.75 | 22 | SO43879 | 2021-09-28 | 6.46 | 48.11 | 20.19 | |||
SO47685_34 | CC2F-4D47-8C | PO11484129630 | 100 | 281 | 469 | 2 | 594 | 2 | 5.29 | 2022-12-03 | 264.41 | 6.48 | 2022-11-21 | 12 | 15.67 | 1 | 259.12 | 34 | SO47685 | 2022-11-28 | 20.73 | 188.05 | 22.03 | 0.02 |
SO51122_4 | D915-4225-97 | PO551181465 | 100 | 281 | 382 | 4 | 4 | 2023-09-02 | 2689.18 | 67.23 | 2023-08-21 | 4 | 713.08 | 1 | 2689.18 | 4 | SO51122 | 2023-08-28 | 215.13 | 2852.32 | 672.29 | |||
SO58982_11 | EEA8-4A3B-AF | PO18125159249 | 100 | 287 | 378 | 311 | 4 | 2024-02-02 | 4398.03 | 109.95 | 2024-01-21 | 3 | 1554.95 | 1 | 4398.03 | 11 | SO58982 | 2024-01-28 | 351.84 | 4664.84 | 1466.01 | |||
SO43879_23 | EDC5-4BD5-8F | PO11600128380 | 19 | 288 | 220 | 569 | 6 | 2021-10-03 | 100.93 | 2.52 | 2021-09-21 | 5 | 12.03 | 1 | 100.93 | 23 | SO43879 | 2021-09-28 | 8.07 | 60.14 | 20.19 |
Generated 2024-09-20 11:51:55.609 UTC