[ROOT] dt FactResellerSale WHERE DimSalesTerritoryId EQ '1' > < SKIP 5814 > < 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 |
---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
SO58916_11 | E928-4943-BC | PO17139180025 | 100 | 293 | 440 | 644 | 1 | 2024-02-02 | 1717.80 | 42.95 | 2024-01-21 | 2 | 868.63 | 1 | 1717.80 | 11 | SO58916 | 2024-01-28 | 137.42 | 1737.27 | 858.90 | |||
SO67309_5 | 9B68-41C2-90 | PO14094179707 | 100 | 293 | 546 | 253 | 1 | 2024-06-03 | 37.25 | 0.93 | 2024-05-22 | 1 | 27.57 | 1 | 37.25 | 5 | SO67309 | 2024-05-29 | 2.98 | 27.57 | 37.25 | |||
SO49092_25 | 72CE-4E29-82 | PO14442163644 | 100 | 293 | 469 | 127 | 1 | 2023-04-05 | 45.59 | 1.14 | 2023-03-24 | 2 | 15.67 | 1 | 45.59 | 25 | SO49092 | 2023-03-31 | 3.65 | 31.34 | 22.79 | |||
SO58917_1 | 0658-4A38-93 | PO17487197562 | 100 | 293 | 605 | 692 | 1 | 2024-02-02 | 323.99 | 8.10 | 2024-01-21 | 1 | 343.65 | 1 | 323.99 | 1 | SO58917 | 2024-01-28 | 25.92 | 343.65 | 323.99 | |||
SO67309_6 | 9B68-41C2-90 | PO14094179707 | 100 | 293 | 222 | 253 | 1 | 2024-06-03 | 20.99 | 0.52 | 2024-05-22 | 1 | 13.09 | 1 | 20.99 | 6 | SO67309 | 2024-05-29 | 1.68 | 13.09 | 20.99 | |||
SO49092_26 | 72CE-4E29-82 | PO14442163644 | 100 | 293 | 216 | 127 | 1 | 2023-04-05 | 80.75 | 2.02 | 2023-03-24 | 4 | 13.88 | 1 | 80.75 | 26 | SO49092 | 2023-03-31 | 6.46 | 55.51 | 20.19 | |||
SO58917_2 | 0658-4A38-93 | PO17487197562 | 100 | 293 | 481 | 692 | 1 | 2024-02-02 | 10.79 | 0.27 | 2024-01-21 | 2 | 3.36 | 1 | 10.79 | 2 | SO58917 | 2024-01-28 | 0.86 | 6.72 | 5.39 | |||
SO67310_1 | 88DD-495F-8F | PO14123148808 | 100 | 289 | 558 | 578 | 1 | 2024-06-03 | 242.99 | 6.07 | 2024-05-22 | 1 | 179.82 | 1 | 242.99 | 1 | SO67310 | 2024-05-29 | 19.44 | 179.82 | 242.99 | |||
SO49092_27 | 72CE-4E29-82 | PO14442163644 | 100 | 293 | 461 | 127 | 1 | 2023-04-05 | 107.99 | 2.70 | 2023-03-24 | 2 | 37.12 | 1 | 107.99 | 27 | SO49092 | 2023-03-31 | 8.64 | 74.24 | 53.99 | |||
SO58917_3 | 0658-4A38-93 | PO17487197562 | 100 | 293 | 491 | 692 | 1 | 2024-02-02 | 64.79 | 1.62 | 2024-01-21 | 2 | 41.57 | 1 | 64.79 | 3 | SO58917 | 2024-01-28 | 5.18 | 83.14 | 32.39 | |||
SO67315_1 | 02BE-4BB0-BD | PO7105133864 | 100 | 293 | 606 | 668 | 1 | 2024-06-03 | 647.99 | 16.20 | 2024-05-22 | 2 | 343.65 | 1 | 647.99 | 1 | SO67315 | 2024-05-29 | 51.84 | 687.30 | 323.99 | |||
SO49092_28 | 72CE-4E29-82 | PO14442163644 | 100 | 293 | 221 | 127 | 1 | 2023-04-05 | 100.93 | 2.52 | 2023-03-24 | 5 | 13.88 | 1 | 100.93 | 28 | SO49092 | 2023-03-31 | 8.07 | 69.39 | 20.19 | |||
SO58917_4 | 0658-4A38-93 | PO17487197562 | 100 | 293 | 606 | 692 | 1 | 2024-02-02 | 323.99 | 8.10 | 2024-01-21 | 1 | 343.65 | 1 | 323.99 | 4 | SO58917 | 2024-01-28 | 25.92 | 343.65 | 323.99 | |||
SO67315_2 | 02BE-4BB0-BD | PO7105133864 | 100 | 293 | 546 | 668 | 1 | 2024-06-03 | 111.76 | 2.79 | 2024-05-22 | 3 | 27.57 | 1 | 111.76 | 2 | SO67315 | 2024-05-29 | 8.94 | 82.70 | 37.25 | |||
SO49092_29 | 72CE-4E29-82 | PO14442163644 | 100 | 293 | 456 | 127 | 1 | 2023-04-05 | 404.95 | 10.12 | 2023-03-24 | 9 | 30.93 | 1 | 404.95 | 29 | SO49092 | 2023-03-31 | 32.40 | 278.40 | 44.99 | |||
SO58917_5 | 0658-4A38-93 | PO17487197562 | 100 | 293 | 471 | 692 | 1 | 2024-02-02 | 76.20 | 1.91 | 2024-01-21 | 2 | 23.75 | 1 | 76.20 | 5 | SO58917 | 2024-01-28 | 6.10 | 47.50 | 38.10 | |||
SO67315_3 | 02BE-4BB0-BD | PO7105133864 | 100 | 293 | 234 | 668 | 1 | 2024-06-03 | 119.98 | 3.00 | 2024-05-22 | 4 | 38.49 | 1 | 119.98 | 3 | SO67315 | 2024-05-29 | 9.60 | 153.97 | 29.99 | |||
SO49092_30 | 72CE-4E29-82 | PO14442163644 | 100 | 293 | 224 | 127 | 1 | 2023-04-05 | 46.68 | 1.17 | 2023-03-24 | 9 | 5.23 | 1 | 46.68 | 30 | SO49092 | 2023-03-31 | 3.73 | 47.07 | 5.19 | |||
SO58917_6 | 0658-4A38-93 | PO17487197562 | 100 | 293 | 483 | 692 | 1 | 2024-02-02 | 144.00 | 3.60 | 2024-01-21 | 2 | 44.88 | 1 | 144.00 | 6 | SO58917 | 2024-01-28 | 11.52 | 89.76 | 72.00 | |||
SO67315_4 | 02BE-4BB0-BD | PO7105133864 | 100 | 293 | 490 | 668 | 1 | 2024-06-03 | 161.97 | 4.05 | 2024-05-22 | 5 | 41.57 | 1 | 161.97 | 4 | SO67315 | 2024-05-29 | 12.96 | 207.86 | 32.39 | |||
SO49092_31 | 72CE-4E29-82 | PO14442163644 | 100 | 293 | 354 | 127 | 1 | 2023-04-05 | 2485.70 | 62.14 | 2023-03-24 | 2 | 1117.86 | 1 | 2485.70 | 31 | SO49092 | 2023-03-31 | 198.86 | 2235.71 | 1242.85 | |||
SO58917_7 | 0658-4A38-93 | PO17487197562 | 100 | 293 | 477 | 692 | 1 | 2024-02-02 | 2.99 | 0.07 | 2024-01-21 | 1 | 1.87 | 1 | 2.99 | 7 | SO58917 | 2024-01-28 | 0.24 | 1.87 | 2.99 | |||
SO67315_5 | 02BE-4BB0-BD | PO7105133864 | 100 | 293 | 481 | 668 | 1 | 2024-06-03 | 37.76 | 0.94 | 2024-05-22 | 7 | 3.36 | 1 | 37.76 | 5 | SO67315 | 2024-05-29 | 3.02 | 23.54 | 5.39 | |||
SO49092_32 | 72CE-4E29-82 | PO14442163644 | 100 | 293 | 428 | 127 | 1 | 2023-04-05 | 418.51 | 10.46 | 2023-03-24 | 2 | 185.82 | 1 | 418.51 | 32 | SO49092 | 2023-03-31 | 33.48 | 371.64 | 209.26 | |||
SO58917_8 | 0658-4A38-93 | PO17487197562 | 100 | 293 | 234 | 692 | 1 | 2024-02-02 | 59.99 | 1.50 | 2024-01-21 | 2 | 38.49 | 1 | 59.99 | 8 | SO58917 | 2024-01-28 | 4.80 | 76.98 | 29.99 | |||
SO67315_6 | 02BE-4BB0-BD | PO7105133864 | 100 | 293 | 482 | 3 | 668 | 1 | 4.45 | 2024-06-03 | 89.00 | 2.11 | 2024-05-22 | 18 | 3.36 | 1 | 84.55 | 6 | SO67315 | 2024-05-29 | 6.76 | 60.52 | 4.94 | 0.05 |
SO49092_33 | 72CE-4E29-82 | PO14442163644 | 100 | 293 | 464 | 127 | 1 | 2023-04-05 | 28.26 | 0.71 | 2023-03-24 | 2 | 9.71 | 1 | 28.26 | 33 | SO49092 | 2023-03-31 | 2.26 | 19.43 | 14.13 | |||
SO58917_9 | 0658-4A38-93 | PO17487197562 | 100 | 293 | 583 | 692 | 1 | 2024-02-02 | 4082.38 | 102.06 | 2024-01-21 | 4 | 1082.51 | 1 | 4082.38 | 9 | SO58917 | 2024-01-28 | 326.59 | 4330.04 | 1020.59 | |||
SO67315_7 | 02BE-4BB0-BD | PO7105133864 | 100 | 293 | 545 | 668 | 1 | 2024-06-03 | 121.47 | 3.04 | 2024-05-22 | 5 | 17.98 | 1 | 121.47 | 7 | SO67315 | 2024-05-29 | 9.72 | 89.89 | 24.29 | |||
SO49092_34 | 72CE-4E29-82 | PO14442163644 | 100 | 293 | 410 | 127 | 1 | 2023-04-05 | 36.45 | 0.91 | 2023-03-24 | 1 | 26.97 | 1 | 36.45 | 34 | SO49092 | 2023-03-31 | 2.92 | 26.97 | 36.45 | |||
SO58917_10 | 0658-4A38-93 | PO17487197562 | 100 | 293 | 545 | 692 | 1 | 2024-02-02 | 48.59 | 1.21 | 2024-01-21 | 2 | 17.98 | 1 | 48.59 | 10 | SO58917 | 2024-01-28 | 3.89 | 35.96 | 24.29 |
Generated 2024-09-20 11:49:45.883 UTC