[ROOT] dt FactResellerSale < WHERE DimSalesTerritoryId EQ '7' > < SKIP 3315 > < TAKE 28 >
28 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 |
---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
SO57150_26 | 0163-41B3-92 | PO3683172338 | 100 | 292 | 555 | 85 | 7 | 2024-01-04 | 255.60 | 6.39 | 2023-12-23 | 4 | 47.29 | 1 | 255.60 | 26 | SO57150 | 2023-12-30 | 20.45 | 189.14 | 63.90 | |||
SO57150_27 | 0163-41B3-92 | PO3683172338 | 100 | 292 | 501 | 85 | 7 | 2024-01-04 | 437.26 | 10.93 | 2023-12-23 | 6 | 53.93 | 1 | 437.26 | 27 | SO57150 | 2023-12-30 | 34.98 | 323.57 | 72.88 | |||
SO57150_28 | 0163-41B3-92 | PO3683172338 | 100 | 292 | 563 | 85 | 7 | 2024-01-04 | 8582.65 | 214.57 | 2023-12-23 | 6 | 1481.94 | 1 | 8582.65 | 28 | SO57150 | 2023-12-30 | 686.61 | 8891.63 | 1430.44 | |||
SO57150_29 | 0163-41B3-92 | PO3683172338 | 100 | 292 | 578 | 85 | 7 | 2024-01-04 | 2915.64 | 72.89 | 2023-12-23 | 4 | 755.15 | 1 | 2915.64 | 29 | SO57150 | 2023-12-30 | 233.25 | 3020.60 | 728.91 | |||
SO57150_30 | 0163-41B3-92 | PO3683172338 | 100 | 292 | 564 | 85 | 7 | 2024-01-04 | 8582.65 | 214.57 | 2023-12-23 | 6 | 1481.94 | 1 | 8582.65 | 30 | SO57150 | 2023-12-30 | 686.61 | 8891.63 | 1430.44 | |||
SO57150_31 | 0163-41B3-92 | PO3683172338 | 100 | 292 | 570 | 85 | 7 | 2024-01-04 | 445.41 | 11.14 | 2023-12-23 | 1 | 461.44 | 1 | 445.41 | 31 | SO57150 | 2023-12-30 | 35.63 | 461.44 | 445.41 | |||
SO57150_32 | 0163-41B3-92 | PO3683172338 | 100 | 292 | 571 | 85 | 7 | 2024-01-04 | 2672.46 | 66.81 | 2023-12-23 | 6 | 461.44 | 1 | 2672.46 | 32 | SO57150 | 2023-12-30 | 213.80 | 2768.67 | 445.41 | |||
SO57150_33 | 0163-41B3-92 | PO3683172338 | 100 | 292 | 574 | 85 | 7 | 2024-01-04 | 14304.42 | 357.61 | 2023-12-23 | 10 | 1481.94 | 1 | 14304.42 | 33 | SO57150 | 2023-12-30 | 1144.35 | 14819.38 | 1430.44 | |||
SO57150_34 | 0163-41B3-92 | PO3683172338 | 100 | 292 | 601 | 85 | 7 | 2024-01-04 | 97.18 | 2.43 | 2023-12-23 | 3 | 23.97 | 1 | 97.18 | 34 | SO57150 | 2023-12-30 | 7.77 | 71.91 | 32.39 | |||
SO57150_35 | 0163-41B3-92 | PO3683172338 | 100 | 292 | 548 | 85 | 7 | 2024-01-04 | 48.59 | 1.21 | 2023-12-23 | 1 | 35.96 | 1 | 48.59 | 35 | SO57150 | 2023-12-30 | 3.89 | 35.96 | 48.59 | |||
SO57150_36 | 0163-41B3-92 | PO3683172338 | 100 | 292 | 576 | 85 | 7 | 2024-01-04 | 7152.21 | 178.81 | 2023-12-23 | 5 | 1481.94 | 1 | 7152.21 | 36 | SO57150 | 2023-12-30 | 572.18 | 7409.69 | 1430.44 | |||
SO57181_1 | 9ADA-417F-90 | PO8323175925 | 100 | 292 | 430 | 211 | 7 | 2024-01-04 | 356.90 | 8.92 | 2023-12-23 | 1 | 360.94 | 1 | 356.90 | 1 | SO57181 | 2023-12-30 | 28.55 | 360.94 | 356.90 | |||
SO58912_1 | CE8F-4A71-98 | PO18589183922 | 100 | 292 | 604 | 67 | 7 | 2024-02-03 | 323.99 | 8.10 | 2024-01-22 | 1 | 343.65 | 1 | 323.99 | 1 | SO58912 | 2024-01-29 | 25.92 | 343.65 | 323.99 | |||
SO58926_1 | B82A-4380-9C | PO15486118845 | 100 | 292 | 474 | 121 | 7 | 2024-02-03 | 83.99 | 2.10 | 2024-01-22 | 2 | 26.18 | 1 | 83.99 | 1 | SO58926 | 2024-01-29 | 6.72 | 52.35 | 41.99 | |||
SO58926_2 | B82A-4380-9C | PO15486118845 | 100 | 292 | 363 | 121 | 7 | 2024-02-03 | 1376.99 | 34.42 | 2024-01-22 | 1 | 1251.98 | 1 | 1376.99 | 2 | SO58926 | 2024-01-29 | 110.16 | 1251.98 | 1376.99 | |||
SO58926_3 | B82A-4380-9C | PO15486118845 | 100 | 292 | 398 | 121 | 7 | 2024-02-03 | 53.45 | 1.34 | 2024-01-22 | 2 | 19.78 | 1 | 53.45 | 3 | SO58926 | 2024-01-29 | 4.28 | 39.55 | 26.72 | |||
SO58926_4 | B82A-4380-9C | PO15486118845 | 100 | 292 | 601 | 121 | 7 | 2024-02-03 | 32.39 | 0.81 | 2024-01-22 | 1 | 23.97 | 1 | 32.39 | 4 | SO58926 | 2024-01-29 | 2.59 | 23.97 | 32.39 | |||
SO58926_5 | B82A-4380-9C | PO15486118845 | 100 | 292 | 542 | 121 | 7 | 2024-02-03 | 24.29 | 0.61 | 2024-01-22 | 1 | 17.98 | 1 | 24.29 | 5 | SO58926 | 2024-01-29 | 1.94 | 17.98 | 24.29 | |||
SO58926_6 | B82A-4380-9C | PO15486118845 | 100 | 292 | 475 | 121 | 7 | 2024-02-03 | 41.99 | 1.05 | 2024-01-22 | 1 | 26.18 | 1 | 41.99 | 6 | SO58926 | 2024-01-29 | 3.36 | 26.18 | 41.99 | |||
SO58926_7 | B82A-4380-9C | PO15486118845 | 100 | 292 | 517 | 121 | 7 | 2024-02-03 | 94.75 | 2.37 | 2024-01-22 | 3 | 23.37 | 1 | 94.75 | 7 | SO58926 | 2024-01-29 | 7.58 | 70.12 | 31.58 | |||
SO58926_8 | B82A-4380-9C | PO15486118845 | 100 | 292 | 298 | 121 | 7 | 2024-02-03 | 2429.28 | 60.73 | 2024-01-22 | 3 | 739.04 | 1 | 2429.28 | 8 | SO58926 | 2024-01-29 | 194.34 | 2217.12 | 809.76 | |||
SO46987_51 | 60CF-4768-AF | PO12702179544 | 100 | 292 | 409 | 175 | 7 | 2022-10-04 | 627.77 | 15.69 | 2022-09-22 | 3 | 185.82 | 1 | 627.77 | 51 | SO46987 | 2022-09-29 | 50.22 | 557.46 | 209.26 | |||
SO46987_52 | 60CF-4768-AF | PO12702179544 | 100 | 292 | 466 | 175 | 7 | 2022-10-04 | 84.77 | 2.12 | 2022-09-22 | 6 | 9.71 | 1 | 84.77 | 52 | SO46987 | 2022-09-29 | 6.78 | 58.28 | 14.13 | |||
SO46987_53 | 60CF-4768-AF | PO12702179544 | 100 | 292 | 397 | 175 | 7 | 2022-10-04 | 145.77 | 3.64 | 2022-09-22 | 6 | 17.98 | 1 | 145.77 | 53 | SO46987 | 2022-09-29 | 11.66 | 107.87 | 24.29 | |||
SO46987_54 | 60CF-4768-AF | PO12702179544 | 100 | 292 | 421 | 175 | 7 | 2022-10-04 | 1177.97 | 29.45 | 2022-09-22 | 6 | 145.28 | 1 | 1177.97 | 54 | SO46987 | 2022-09-29 | 94.24 | 871.70 | 196.33 | |||
SO46987_55 | 60CF-4768-AF | PO12702179544 | 100 | 292 | 460 | 2 | 175 | 7 | 11.48 | 2022-10-04 | 574.14 | 14.07 | 2022-09-22 | 11 | 37.12 | 1 | 562.65 | 55 | SO46987 | 2022-09-29 | 45.01 | 408.33 | 52.19 | 0.02 |
SO46987_56 | 60CF-4768-AF | PO12702179544 | 100 | 292 | 448 | 175 | 7 | 2022-10-04 | 47.98 | 1.20 | 2022-09-22 | 4 | 8.25 | 1 | 47.98 | 56 | SO46987 | 2022-09-29 | 3.84 | 32.98 | 11.99 | |||
SO47019_1 | 835A-4E34-9E | PO2668115692 | 100 | 292 | 401 | 535 | 7 | 2022-10-04 | 65.60 | 1.64 | 2022-09-22 | 1 | 48.55 | 1 | 65.60 | 1 | SO47019 | 2022-09-29 | 5.25 | 48.55 | 65.60 |
Generated 2024-09-21 05:49:27.955 UTC