[ROOT] dt FactResellerSale < WHERE DimSalesTerritoryId EQ ALL < SKIP 2821 > < 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 |
---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
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_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_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_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_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_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_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_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_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_12 | EEA8-4A3B-AF | PO18125159249 | 100 | 287 | 390 | 311 | 4 | 2024-02-02 | 2016.88 | 50.42 | 2024-01-21 | 3 | 713.08 | 1 | 2016.88 | 12 | SO58982 | 2024-01-28 | 161.35 | 2139.24 | 672.29 | |||
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 | |||
SO47685_35 | CC2F-4D47-8C | PO11484129630 | 100 | 281 | 470 | 2 | 594 | 2 | 5.73 | 2022-12-03 | 286.44 | 7.02 | 2022-11-21 | 13 | 15.67 | 1 | 280.72 | 35 | SO47685 | 2022-11-28 | 22.46 | 203.72 | 22.03 | 0.02 |
SO51122_5 | D915-4225-97 | PO551181465 | 100 | 281 | 386 | 4 | 4 | 2023-09-02 | 672.29 | 16.81 | 2023-08-21 | 1 | 713.08 | 1 | 672.29 | 5 | SO51122 | 2023-08-28 | 53.78 | 713.08 | 672.29 | |||
SO58982_13 | EEA8-4A3B-AF | PO18125159249 | 100 | 287 | 240 | 311 | 4 | 2024-02-02 | 858.90 | 21.47 | 2024-01-21 | 1 | 868.63 | 1 | 858.90 | 13 | SO58982 | 2024-01-28 | 68.71 | 868.63 | 858.90 | |||
SO43879_24 | EDC5-4BD5-8F | PO11600128380 | 19 | 288 | 253 | 569 | 6 | 2021-10-03 | 892.90 | 22.32 | 2021-09-21 | 5 | 176.20 | 1 | 892.90 | 24 | SO43879 | 2021-09-28 | 71.43 | 881.00 | 178.58 | |||
SO47685_36 | CC2F-4D47-8C | PO11484129630 | 100 | 281 | 233 | 594 | 2 | 2022-12-03 | 28.84 | 0.72 | 2022-11-21 | 1 | 29.08 | 1 | 28.84 | 36 | SO47685 | 2022-11-28 | 2.31 | 29.08 | 28.84 | |||
SO51122_6 | D915-4225-97 | PO551181465 | 100 | 281 | 580 | 4 | 4 | 2023-09-02 | 4082.38 | 102.06 | 2023-08-21 | 4 | 1082.51 | 1 | 4082.38 | 6 | SO51122 | 2023-08-28 | 326.59 | 4330.04 | 1020.59 | |||
SO58982_14 | EEA8-4A3B-AF | PO18125159249 | 100 | 287 | 606 | 311 | 4 | 2024-02-02 | 647.99 | 16.20 | 2024-01-21 | 2 | 343.65 | 1 | 647.99 | 14 | SO58982 | 2024-01-28 | 51.84 | 687.30 | 323.99 | |||
SO43879_25 | EDC5-4BD5-8F | PO11600128380 | 19 | 288 | 314 | 569 | 6 | 2021-10-03 | 2146.96 | 53.67 | 2021-09-21 | 1 | 2171.29 | 1 | 2146.96 | 25 | SO43879 | 2021-09-28 | 171.76 | 2171.29 | 2146.96 | |||
SO47686_1 | 0A45-45F2-91 | PO11049110051 | 19 | 284 | 407 | 679 | 6 | 2022-12-03 | 65.60 | 1.64 | 2022-11-21 | 1 | 48.55 | 1 | 65.60 | 1 | SO47686 | 2022-11-28 | 5.25 | 48.55 | 65.60 |
Generated 2024-09-20 13:30:03.655 UTC