[ROOT] dt FactResellerSale < WHERE DimCurrency.AlternateKey EQ 'GBP' > SKIP 875 < SKIP 77 > < 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 |
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
| SO50237_12 | 6856-44BE-87 | PO928122277 | 98 | 288 | 421 | 484 | 10 | 2023-08-23 | 1177.97 | 29.45 | 2023-08-11 | 6 | 145.28 | 1 | 1177.97 | 12 | SO50237 | 2023-08-18 | 94.24 | 871.70 | 196.33 | |||
| SO50237_13 | 6856-44BE-87 | PO928122277 | 98 | 288 | 453 | 484 | 10 | 2023-08-23 | 35.99 | 0.90 | 2023-08-11 | 1 | 24.75 | 1 | 35.99 | 13 | SO50237 | 2023-08-18 | 2.88 | 24.75 | 35.99 | |||
| SO50237_14 | 6856-44BE-87 | PO928122277 | 98 | 288 | 448 | 484 | 10 | 2023-08-23 | 47.98 | 1.20 | 2023-08-11 | 4 | 8.25 | 1 | 47.98 | 14 | SO50237 | 2023-08-18 | 3.84 | 32.98 | 11.99 | |||
| SO50237_15 | 6856-44BE-87 | PO928122277 | 98 | 288 | 366 | 484 | 10 | 2023-08-23 | 2591.98 | 64.80 | 2023-08-11 | 4 | 598.44 | 1 | 2591.98 | 15 | SO50237 | 2023-08-18 | 207.36 | 2393.74 | 647.99 | |||
| SO50237_16 | 6856-44BE-87 | PO928122277 | 98 | 288 | 461 | 484 | 10 | 2023-08-23 | 161.98 | 4.05 | 2023-08-11 | 3 | 37.12 | 1 | 161.98 | 16 | SO50237 | 2023-08-18 | 12.96 | 111.36 | 53.99 | |||
| SO50237_17 | 6856-44BE-87 | PO928122277 | 98 | 288 | 358 | 484 | 10 | 2023-08-23 | 1229.46 | 30.74 | 2023-08-11 | 1 | 1105.81 | 1 | 1229.46 | 17 | SO50237 | 2023-08-18 | 98.36 | 1105.81 | 1229.46 | |||
| SO50237_18 | 6856-44BE-87 | PO928122277 | 98 | 288 | 236 | 484 | 10 | 2023-08-23 | 173.04 | 4.33 | 2023-08-11 | 6 | 29.08 | 1 | 173.04 | 18 | SO50237 | 2023-08-18 | 13.84 | 174.48 | 28.84 | |||
| SO50237_19 | 6856-44BE-87 | PO928122277 | 98 | 288 | 456 | 484 | 10 | 2023-08-23 | 89.99 | 2.25 | 2023-08-11 | 2 | 30.93 | 1 | 89.99 | 19 | SO50237 | 2023-08-18 | 7.20 | 61.87 | 44.99 | |||
| SO50237_20 | 6856-44BE-87 | PO928122277 | 98 | 288 | 297 | 484 | 10 | 2023-08-23 | 736.15 | 18.40 | 2023-08-11 | 1 | 653.70 | 1 | 736.15 | 20 | SO50237 | 2023-08-18 | 58.89 | 653.70 | 736.15 | |||
| SO50237_21 | 6856-44BE-87 | PO928122277 | 98 | 288 | 458 | 484 | 10 | 2023-08-23 | 89.99 | 2.25 | 2023-08-11 | 2 | 30.93 | 1 | 89.99 | 21 | SO50237 | 2023-08-18 | 7.20 | 61.87 | 44.99 | |||
| SO50237_22 | 6856-44BE-87 | PO928122277 | 98 | 288 | 427 | 484 | 10 | 2023-08-23 | 1046.28 | 26.16 | 2023-08-11 | 5 | 185.82 | 1 | 1046.28 | 22 | SO50237 | 2023-08-18 | 83.70 | 929.10 | 209.26 | |||
| SO50237_23 | 6856-44BE-87 | PO928122277 | 98 | 288 | 230 | 484 | 10 | 2023-08-23 | 144.20 | 3.61 | 2023-08-11 | 5 | 29.08 | 1 | 144.20 | 23 | SO50237 | 2023-08-18 | 11.54 | 145.40 | 28.84 | |||
| SO50237_24 | 6856-44BE-87 | PO928122277 | 98 | 288 | 397 | 484 | 10 | 2023-08-23 | 97.18 | 2.43 | 2023-08-11 | 4 | 17.98 | 1 | 97.18 | 24 | SO50237 | 2023-08-18 | 7.77 | 71.91 | 24.29 | |||
| SO50237_25 | 6856-44BE-87 | PO928122277 | 98 | 288 | 354 | 484 | 10 | 2023-08-23 | 1242.85 | 31.07 | 2023-08-11 | 1 | 1117.86 | 1 | 1242.85 | 25 | SO50237 | 2023-08-18 | 99.43 | 1117.86 | 1242.85 | |||
| SO50237_26 | 6856-44BE-87 | PO928122277 | 98 | 288 | 396 | 484 | 10 | 2023-08-23 | 149.68 | 3.74 | 2023-08-11 | 2 | 55.38 | 1 | 149.68 | 26 | SO50237 | 2023-08-18 | 11.97 | 110.76 | 74.84 | |||
| SO50237_27 | 6856-44BE-87 | PO928122277 | 98 | 288 | 364 | 484 | 10 | 2023-08-23 | 1943.98 | 48.60 | 2023-08-11 | 3 | 598.44 | 1 | 1943.98 | 27 | SO50237 | 2023-08-18 | 155.52 | 1795.31 | 647.99 | |||
| SO50237_28 | 6856-44BE-87 | PO928122277 | 98 | 288 | 395 | 484 | 10 | 2023-08-23 | 122.75 | 3.07 | 2023-08-11 | 2 | 45.42 | 1 | 122.75 | 28 | SO50237 | 2023-08-18 | 9.82 | 90.83 | 61.37 | |||
| SO50237_29 | 6856-44BE-87 | PO928122277 | 98 | 288 | 213 | 484 | 10 | 2023-08-23 | 121.12 | 3.03 | 2023-08-11 | 6 | 13.88 | 1 | 121.12 | 29 | SO50237 | 2023-08-18 | 9.69 | 83.27 | 20.19 | |||
| SO50237_30 | 6856-44BE-87 | PO928122277 | 98 | 288 | 447 | 484 | 10 | 2023-08-23 | 60.00 | 1.50 | 2023-08-11 | 4 | 10.31 | 1 | 60.00 | 30 | SO50237 | 2023-08-18 | 4.80 | 41.25 | 15.00 | |||
| SO50237_31 | 6856-44BE-87 | PO928122277 | 98 | 288 | 445 | 484 | 10 | 2023-08-23 | 143.98 | 3.60 | 2023-08-11 | 4 | 24.75 | 1 | 143.98 | 31 | SO50237 | 2023-08-18 | 11.52 | 98.98 | 35.99 | |||
| SO50237_32 | 6856-44BE-87 | PO928122277 | 98 | 288 | 393 | 484 | 10 | 2023-08-23 | 688.47 | 17.21 | 2023-08-11 | 5 | 101.89 | 1 | 688.47 | 32 | SO50237 | 2023-08-18 | 55.08 | 509.47 | 137.69 | |||
| SO50237_33 | 6856-44BE-87 | PO928122277 | 98 | 288 | 428 | 484 | 10 | 2023-08-23 | 418.51 | 10.46 | 2023-08-11 | 2 | 185.82 | 1 | 418.51 | 33 | SO50237 | 2023-08-18 | 33.48 | 371.64 | 209.26 | |||
| SO50237_34 | 6856-44BE-87 | PO928122277 | 98 | 288 | 294 | 484 | 10 | 2023-08-23 | 2232.82 | 55.82 | 2023-08-11 | 3 | 660.91 | 1 | 2232.82 | 34 | SO50237 | 2023-08-18 | 178.63 | 1982.74 | 744.27 | |||
| SO50237_35 | 6856-44BE-87 | PO928122277 | 98 | 288 | 365 | 484 | 10 | 2023-08-23 | 2591.98 | 64.80 | 2023-08-11 | 4 | 598.44 | 1 | 2591.98 | 35 | SO50237 | 2023-08-18 | 207.36 | 2393.74 | 647.99 | |||
| SO50237_36 | 6856-44BE-87 | PO928122277 | 98 | 288 | 460 | 484 | 10 | 2023-08-23 | 539.94 | 13.50 | 2023-08-11 | 10 | 37.12 | 1 | 539.94 | 36 | SO50237 | 2023-08-18 | 43.20 | 371.21 | 53.99 | |||
| SO50237_37 | 6856-44BE-87 | PO928122277 | 98 | 288 | 459 | 484 | 10 | 2023-08-23 | 323.96 | 8.10 | 2023-08-11 | 6 | 37.12 | 1 | 323.96 | 37 | SO50237 | 2023-08-18 | 25.92 | 222.73 | 53.99 | |||
| SO50237_38 | 6856-44BE-87 | PO928122277 | 98 | 288 | 469 | 484 | 10 | 2023-08-23 | 205.15 | 5.13 | 2023-08-11 | 9 | 15.67 | 1 | 205.15 | 38 | SO50237 | 2023-08-18 | 16.41 | 141.04 | 22.79 | |||
| SO50237_39 | 6856-44BE-87 | PO928122277 | 98 | 288 | 352 | 484 | 10 | 2023-08-23 | 3728.56 | 93.21 | 2023-08-11 | 3 | 1117.86 | 1 | 3728.56 | 39 | SO50237 | 2023-08-18 | 298.28 | 3353.57 | 1242.85 | |||
| SO50237_40 | 6856-44BE-87 | PO928122277 | 98 | 288 | 224 | 2 | 484 | 10 | 1.10 | 2023-08-23 | 55.15 | 1.35 | 2023-08-11 | 11 | 5.23 | 1 | 54.05 | 40 | SO50237 | 2023-08-18 | 4.32 | 57.53 | 5.01 | 0.02 |
| SO50244_1 | 8887-4F96-A3 | PO1508168261 | 98 | 290 | 422 | 430 | 10 | 2023-08-23 | 202.62 | 5.07 | 2023-08-11 | 3 | 49.98 | 1 | 202.62 | 1 | SO50244 | 2023-08-18 | 16.21 | 149.94 | 67.54 |
Generated 2024-11-10 14:40:30.214 UTC