[ROOT] dt FactResellerSale < WHERE DimSalesTerritoryId EQ '7' > SKIP 0 SHUFFLE < SKIP 1241 > < TAKE 24 >
24 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 |
---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
SO71799_25 | EBC1-4D4C-8E | PO15486196616 | 100 | 292 | 552 | 121 | 7 | 2024-09-27 | 164.68 | 4.12 | 2024-09-15 | 3 | 40.62 | 1 | 164.68 | 25 | SO71799 | 2024-09-22 | 13.17 | 121.86 | 54.89 | |||
SO50225_45 | 6F8E-49A2-A5 | PO12702153410 | 100 | 292 | 236 | 175 | 7 | 2023-08-27 | 57.68 | 1.44 | 2023-08-15 | 2 | 29.08 | 1 | 57.68 | 45 | SO50225 | 2023-08-22 | 4.61 | 58.16 | 28.84 | |||
SO63284_11 | E5FB-4341-8A | PO3683186679 | 100 | 292 | 575 | 85 | 7 | 2024-05-29 | 11443.54 | 286.09 | 2024-05-17 | 8 | 1481.94 | 1 | 11443.54 | 11 | SO63284 | 2024-05-24 | 915.48 | 11855.50 | 1430.44 | |||
SO63216_26 | A61E-4461-B6 | PO12702151034 | 100 | 292 | 512 | 175 | 7 | 2024-05-29 | 655.36 | 16.38 | 2024-05-17 | 3 | 199.38 | 1 | 655.36 | 26 | SO63216 | 2024-05-24 | 52.43 | 598.13 | 218.45 | |||
SO51734_53 | 9D8E-4873-8B | PO13427111801 | 100 | 292 | 408 | 638 | 7 | 2023-11-27 | 360.81 | 9.02 | 2023-11-15 | 5 | 53.40 | 1 | 360.81 | 53 | SO51734 | 2023-11-22 | 28.86 | 267.00 | 72.16 | |||
SO67339_1 | E214-4902-AC | PO3509143630 | 36 | 292 | 580 | 139 | 7 | 2024-07-28 | 6123.56 | 153.09 | 2024-07-16 | 6 | 1082.51 | 1 | 6123.56 | 1 | SO67339 | 2024-07-23 | 489.89 | 6495.06 | 1020.59 | |||
SO49833_37 | 595A-4EFA-AC | PO13340158028 | 100 | 292 | 356 | 355 | 7 | 2023-07-28 | 2485.70 | 62.14 | 2023-07-16 | 2 | 1117.86 | 1 | 2485.70 | 37 | SO49833 | 2023-07-23 | 198.86 | 2235.71 | 1242.85 | |||
SO51739_13 | AF60-4F2F-9B | PO12702124697 | 100 | 292 | 556 | 175 | 7 | 2023-11-27 | 421.18 | 10.53 | 2023-11-15 | 4 | 77.92 | 1 | 421.18 | 13 | SO51739 | 2023-11-22 | 33.69 | 311.67 | 105.29 | |||
SO46981_57 | 22E4-4440-81 | PO13427119728 | 100 | 292 | 459 | 2 | 638 | 7 | 11.48 | 2022-11-27 | 574.14 | 14.07 | 2022-11-15 | 11 | 37.12 | 1 | 562.65 | 57 | SO46981 | 2022-11-22 | 45.01 | 408.33 | 52.19 | 0.02 |
SO48763_2 | 06A5-45C0-A2 | PO3509163189 | 36 | 292 | 447 | 139 | 7 | 2023-04-29 | 75.00 | 1.88 | 2023-04-17 | 5 | 10.31 | 1 | 75.00 | 2 | SO48763 | 2023-04-24 | 6.00 | 51.56 | 15.00 | |||
SO51739_68 | AF60-4F2F-9B | PO12702124697 | 100 | 292 | 484 | 175 | 7 | 2023-11-27 | 47.70 | 1.19 | 2023-11-15 | 10 | 2.97 | 1 | 47.70 | 68 | SO51739 | 2023-11-22 | 3.82 | 29.73 | 4.77 | |||
SO51742_5 | 1720-457C-B3 | PO12731111072 | 36 | 292 | 477 | 247 | 7 | 2023-11-27 | 2.99 | 0.07 | 2023-11-15 | 1 | 1.87 | 1 | 2.99 | 5 | SO51742 | 2023-11-22 | 0.24 | 1.87 | 2.99 | |||
SO50225_19 | 6F8E-49A2-A5 | PO12702153410 | 100 | 292 | 427 | 175 | 7 | 2023-08-27 | 1046.28 | 26.16 | 2023-08-15 | 5 | 185.82 | 1 | 1046.28 | 19 | SO50225 | 2023-08-22 | 83.70 | 929.10 | 209.26 | |||
SO51752_35 | C68C-4AF8-B1 | PO11223127670 | 100 | 292 | 512 | 632 | 7 | 2023-11-27 | 1529.18 | 38.23 | 2023-11-15 | 7 | 199.38 | 1 | 1529.18 | 35 | SO51752 | 2023-11-22 | 122.33 | 1395.63 | 218.45 | |||
SO51752_19 | C68C-4AF8-B1 | PO11223127670 | 100 | 292 | 402 | 632 | 7 | 2023-11-27 | 72.16 | 1.80 | 2023-11-15 | 1 | 53.40 | 1 | 72.16 | 19 | SO51752 | 2023-11-22 | 5.77 | 53.40 | 72.16 | |||
SO57143_7 | 69ED-4172-83 | PO3567189986 | 100 | 292 | 561 | 193 | 7 | 2024-02-27 | 2860.88 | 71.52 | 2024-02-15 | 2 | 1481.94 | 1 | 2860.88 | 7 | SO57143 | 2024-02-22 | 228.87 | 2963.88 | 1430.44 | |||
SO51774_21 | 30BA-400A-89 | PO2668194455 | 100 | 292 | 511 | 535 | 7 | 2023-11-27 | 2184.54 | 54.61 | 2023-11-15 | 10 | 199.38 | 1 | 2184.54 | 21 | SO51774 | 2023-11-22 | 174.76 | 1993.76 | 218.45 | |||
SO51861_7 | 1365-48AA-87 | PO3712133982 | 100 | 290 | 568 | 13 | 662 | 7 | 50.11 | 2023-11-27 | 334.06 | 7.10 | 2023-11-15 | 1 | 461.44 | 1 | 283.95 | 7 | SO51861 | 2023-11-22 | 22.72 | 461.44 | 334.06 | 0.15 |
SO67276_28 | 9FD9-4B05-AA | PO13340158801 | 100 | 292 | 594 | 355 | 7 | 2024-07-28 | 1016.98 | 25.42 | 2024-07-16 | 3 | 308.22 | 1 | 1016.98 | 28 | SO67276 | 2024-07-23 | 81.36 | 924.65 | 338.99 | |||
SO48005_37 | 634C-42C5-AB | PO13427183371 | 100 | 292 | 230 | 638 | 7 | 2023-02-27 | 144.20 | 3.61 | 2023-02-15 | 5 | 29.08 | 1 | 144.20 | 37 | SO48005 | 2023-02-22 | 11.54 | 145.40 | 28.84 | |||
SO65286_5 | 8A77-4D51-91 | PO1305125843 | 100 | 292 | 576 | 319 | 7 | 2024-06-27 | 2860.88 | 71.52 | 2024-06-15 | 2 | 1481.94 | 1 | 2860.88 | 5 | SO65286 | 2024-06-22 | 228.87 | 2963.88 | 1430.44 | |||
SO65226_26 | 55DE-4772-82 | PO15515186601 | 100 | 292 | 472 | 481 | 7 | 2024-06-27 | 190.50 | 4.76 | 2024-06-15 | 5 | 23.75 | 1 | 190.50 | 26 | SO65226 | 2024-06-22 | 15.24 | 118.75 | 38.10 | |||
SO50681_4 | C44A-4F6F-86 | PO12673115760 | 100 | 292 | 271 | 499 | 7 | 2023-09-27 | 404.66 | 10.12 | 2023-09-15 | 2 | 187.16 | 1 | 404.66 | 4 | SO50681 | 2023-09-22 | 32.37 | 374.31 | 202.33 | |||
SO48348_8 | 2F90-4686-B1 | PO1450144617 | 100 | 292 | 224 | 571 | 7 | 2023-03-29 | 25.93 | 0.65 | 2023-03-17 | 5 | 5.23 | 1 | 25.93 | 8 | SO48348 | 2023-03-24 | 2.07 | 26.15 | 5.19 |
Generated 2024-11-14 17:52:59.173 UTC