[ROOT] dt FactResellerSale < WHERE DimSalesTerritoryId EQ '7' > < SKIP 2340 > < 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 |
---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
SO67339_24 | E214-4902-AC | PO3509143630 | 36 | 292 | 605 | 139 | 7 | 2024-07-24 | 647.99 | 16.20 | 2024-07-12 | 2 | 343.65 | 1 | 647.99 | 24 | SO67339 | 2024-07-19 | 51.84 | 687.30 | 323.99 | |||
SO46626_16 | CFB3-4671-A6 | PO13340194893 | 100 | 292 | 358 | 355 | 7 | 2022-10-23 | 9835.67 | 245.89 | 2022-10-11 | 8 | 1105.81 | 1 | 9835.67 | 16 | SO46626 | 2022-10-18 | 786.85 | 8846.48 | 1229.46 | |||
SO67339_25 | E214-4902-AC | PO3509143630 | 36 | 292 | 255 | 139 | 7 | 2024-07-24 | 404.66 | 10.12 | 2024-07-12 | 2 | 204.63 | 1 | 404.66 | 25 | SO67339 | 2024-07-19 | 32.37 | 409.25 | 202.33 | |||
SO46626_17 | CFB3-4671-A6 | PO13340194893 | 100 | 292 | 236 | 355 | 7 | 2022-10-23 | 86.52 | 2.16 | 2022-10-11 | 3 | 29.08 | 1 | 86.52 | 17 | SO46626 | 2022-10-18 | 6.92 | 87.24 | 28.84 | |||
SO67339_26 | E214-4902-AC | PO3509143630 | 36 | 292 | 465 | 2 | 139 | 7 | 3.12 | 2024-07-24 | 156.25 | 3.83 | 2024-07-12 | 11 | 9.16 | 1 | 153.12 | 26 | SO67339 | 2024-07-19 | 12.25 | 100.75 | 14.20 | 0.02 |
SO46626_18 | CFB3-4671-A6 | PO13340194893 | 100 | 292 | 409 | 355 | 7 | 2022-10-23 | 418.51 | 10.46 | 2022-10-11 | 2 | 185.82 | 1 | 418.51 | 18 | SO46626 | 2022-10-18 | 33.48 | 371.64 | 209.26 | |||
SO67339_27 | E214-4902-AC | PO3509143630 | 36 | 292 | 480 | 139 | 7 | 2024-07-24 | 5.50 | 0.14 | 2024-07-12 | 4 | 0.86 | 1 | 5.50 | 27 | SO67339 | 2024-07-19 | 0.44 | 3.43 | 1.37 | |||
SO46626_19 | CFB3-4671-A6 | PO13340194893 | 100 | 292 | 427 | 355 | 7 | 2022-10-23 | 1046.28 | 26.16 | 2022-10-11 | 5 | 185.82 | 1 | 1046.28 | 19 | SO46626 | 2022-10-18 | 83.70 | 929.10 | 209.26 | |||
SO67339_28 | E214-4902-AC | PO3509143630 | 36 | 292 | 488 | 139 | 7 | 2024-07-24 | 129.58 | 3.24 | 2024-07-12 | 4 | 41.57 | 1 | 129.58 | 28 | SO67339 | 2024-07-19 | 10.37 | 166.29 | 32.39 | |||
SO46626_20 | CFB3-4671-A6 | PO13340194893 | 100 | 292 | 453 | 355 | 7 | 2022-10-23 | 359.94 | 9.00 | 2022-10-11 | 10 | 24.75 | 1 | 359.94 | 20 | SO46626 | 2022-10-18 | 28.80 | 247.46 | 35.99 | |||
SO67339_29 | E214-4902-AC | PO3509143630 | 36 | 292 | 546 | 139 | 7 | 2024-07-24 | 149.02 | 3.73 | 2024-07-12 | 4 | 27.57 | 1 | 149.02 | 29 | SO67339 | 2024-07-19 | 11.92 | 110.27 | 37.25 | |||
SO46626_21 | CFB3-4671-A6 | PO13340194893 | 100 | 292 | 412 | 355 | 7 | 2022-10-23 | 180.13 | 4.50 | 2022-10-11 | 1 | 133.30 | 1 | 180.13 | 21 | SO46626 | 2022-10-18 | 14.41 | 133.30 | 180.13 | |||
SO67339_30 | E214-4902-AC | PO3509143630 | 36 | 292 | 237 | 139 | 7 | 2024-07-24 | 149.97 | 3.75 | 2024-07-12 | 5 | 38.49 | 1 | 149.97 | 30 | SO67339 | 2024-07-19 | 12.00 | 192.46 | 29.99 | |||
SO46626_22 | CFB3-4671-A6 | PO13340194893 | 100 | 292 | 448 | 355 | 7 | 2022-10-23 | 23.99 | 0.60 | 2022-10-11 | 2 | 8.25 | 1 | 23.99 | 22 | SO46626 | 2022-10-18 | 1.92 | 16.49 | 11.99 | |||
SO69404_1 | 2274-4413-B4 | PO16704110904 | 100 | 292 | 475 | 680 | 7 | 2024-08-23 | 167.98 | 4.20 | 2024-08-11 | 4 | 26.18 | 1 | 167.98 | 1 | SO69404 | 2024-08-18 | 13.44 | 104.71 | 41.99 | |||
SO46626_23 | CFB3-4671-A6 | PO13340194893 | 100 | 292 | 420 | 355 | 7 | 2022-10-23 | 141.62 | 3.54 | 2022-10-11 | 1 | 104.80 | 1 | 141.62 | 23 | SO46626 | 2022-10-18 | 11.33 | 104.80 | 141.62 | |||
SO69404_2 | 2274-4413-B4 | PO16704110904 | 100 | 292 | 359 | 680 | 7 | 2024-08-23 | 4130.98 | 103.27 | 2024-08-11 | 3 | 1251.98 | 1 | 4130.98 | 2 | SO69404 | 2024-08-18 | 330.48 | 3755.94 | 1376.99 | |||
SO46626_24 | CFB3-4671-A6 | PO13340194893 | 100 | 292 | 224 | 355 | 7 | 2022-10-23 | 20.75 | 0.52 | 2022-10-11 | 4 | 5.23 | 1 | 20.75 | 24 | SO46626 | 2022-10-18 | 1.66 | 20.92 | 5.19 | |||
SO69404_3 | 2274-4413-B4 | PO16704110904 | 100 | 292 | 474 | 2 | 680 | 7 | 9.74 | 2024-08-23 | 487.13 | 11.93 | 2024-08-11 | 12 | 26.18 | 1 | 477.39 | 3 | SO69404 | 2024-08-18 | 38.19 | 314.12 | 40.59 | 0.02 |
SO46626_25 | CFB3-4671-A6 | PO13340194893 | 100 | 292 | 447 | 355 | 7 | 2022-10-23 | 60.00 | 1.50 | 2022-10-11 | 4 | 10.31 | 1 | 60.00 | 25 | SO46626 | 2022-10-18 | 4.80 | 41.25 | 15.00 | |||
SO69404_4 | 2274-4413-B4 | PO16704110904 | 100 | 292 | 476 | 680 | 7 | 2024-08-23 | 251.96 | 6.30 | 2024-08-11 | 6 | 26.18 | 1 | 251.96 | 4 | SO69404 | 2024-08-18 | 20.16 | 157.06 | 41.99 | |||
SO46626_26 | CFB3-4671-A6 | PO13340194893 | 100 | 292 | 233 | 355 | 7 | 2022-10-23 | 86.52 | 2.16 | 2022-10-11 | 3 | 29.08 | 1 | 86.52 | 26 | SO46626 | 2022-10-18 | 6.92 | 87.24 | 28.84 | |||
SO69404_5 | 2274-4413-B4 | PO16704110904 | 100 | 292 | 471 | 680 | 7 | 2024-08-23 | 152.40 | 3.81 | 2024-08-11 | 4 | 23.75 | 1 | 152.40 | 5 | SO69404 | 2024-08-18 | 12.19 | 95.00 | 38.10 | |||
SO46626_27 | CFB3-4671-A6 | PO13340194893 | 100 | 292 | 397 | 355 | 7 | 2022-10-23 | 72.88 | 1.82 | 2022-10-11 | 3 | 17.98 | 1 | 72.88 | 27 | SO46626 | 2022-10-18 | 5.83 | 53.93 | 24.29 | |||
SO69404_6 | 2274-4413-B4 | PO16704110904 | 100 | 292 | 483 | 680 | 7 | 2024-08-23 | 144.00 | 3.60 | 2024-08-11 | 2 | 44.88 | 1 | 144.00 | 6 | SO69404 | 2024-08-18 | 11.52 | 89.76 | 72.00 | |||
SO46626_28 | CFB3-4671-A6 | PO13340194893 | 100 | 292 | 461 | 355 | 7 | 2022-10-23 | 269.97 | 6.75 | 2022-10-11 | 5 | 37.12 | 1 | 269.97 | 28 | SO46626 | 2022-10-18 | 21.60 | 185.60 | 53.99 | |||
SO69404_7 | 2274-4413-B4 | PO16704110904 | 100 | 292 | 491 | 680 | 7 | 2024-08-23 | 129.58 | 3.24 | 2024-08-11 | 4 | 41.57 | 1 | 129.58 | 7 | SO69404 | 2024-08-18 | 10.37 | 166.29 | 32.39 | |||
SO46626_29 | CFB3-4671-A6 | PO13340194893 | 100 | 292 | 456 | 355 | 7 | 2022-10-23 | 179.98 | 4.50 | 2022-10-11 | 4 | 30.93 | 1 | 179.98 | 29 | SO46626 | 2022-10-18 | 14.40 | 123.73 | 44.99 |
Generated 2024-11-10 17:01:40.349 UTC