[ROOT] dt FactResellerSale WHERE DimSalesTerritoryId EQ '1' > SHUFFLE < SKIP 2231 > < 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 |
---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
SO57105_21 | 3AE1-4A72-91 | PO18676113963 | 100 | 282 | 596 | 697 | 1 | 2024-02-24 | 1295.98 | 32.40 | 2024-02-12 | 4 | 294.58 | 1 | 1295.98 | 21 | SO57105 | 2024-02-19 | 103.68 | 1178.32 | 323.99 | |||
SO57046_36 | 52CC-460F-B3 | PO14500161818 | 100 | 282 | 222 | 2 | 650 | 1 | 4.87 | 2024-02-24 | 243.53 | 5.97 | 2024-02-12 | 12 | 13.09 | 1 | 238.66 | 36 | SO57046 | 2024-02-19 | 19.09 | 157.04 | 20.29 | 0.02 |
SO51783_37 | B7A2-49BC-89 | PO18676114917 | 100 | 282 | 476 | 4 | 697 | 1 | 125.98 | 2023-11-24 | 1259.82 | 28.35 | 2023-11-12 | 36 | 26.18 | 1 | 1133.84 | 37 | SO51783 | 2023-11-19 | 90.71 | 942.35 | 35.00 | 0.10 |
SO51797_1 | 801F-408E-93 | PO16907168167 | 100 | 293 | 517 | 217 | 1 | 2023-11-24 | 31.58 | 0.79 | 2023-11-12 | 1 | 23.37 | 1 | 31.58 | 1 | SO51797 | 2023-11-19 | 2.53 | 23.37 | 31.58 | |||
SO57099_25 | 410F-45E9-9C | PO18618199656 | 100 | 286 | 576 | 605 | 1 | 2024-02-24 | 4291.33 | 107.28 | 2024-02-12 | 3 | 1481.94 | 1 | 4291.33 | 25 | SO57099 | 2024-02-19 | 343.31 | 4445.81 | 1430.44 | |||
SO69408_4 | 8DF5-4377-9D | PO16414161428 | 100 | 289 | 594 | 16 | 236 | 1 | 90.40 | 2024-08-24 | 226.00 | 3.39 | 2024-08-12 | 2 | 308.22 | 1 | 135.60 | 4 | SO69408 | 2024-08-19 | 10.85 | 616.44 | 113.00 | 0.40 |
SO53514_5 | 8580-40F8-81 | PO10411179199 | 100 | 289 | 573 | 182 | 1 | 2023-12-25 | 5721.77 | 143.04 | 2023-12-13 | 4 | 1481.94 | 1 | 5721.77 | 5 | SO53514 | 2023-12-20 | 457.74 | 5927.75 | 1430.44 | |||
SO67266_1 | 3CFE-46C9-88 | PO16588161069 | 100 | 289 | 361 | 146 | 1 | 2024-07-25 | 6884.97 | 172.12 | 2024-07-13 | 5 | 1251.98 | 1 | 6884.97 | 1 | SO67266 | 2024-07-20 | 550.80 | 6259.91 | 1376.99 | |||
SO45303_4 | 72FC-4DAD-BA | PO11919121030 | 100 | 286 | 351 | 73 | 1 | 2022-05-27 | 8099.98 | 202.50 | 2022-05-15 | 4 | 1898.09 | 1 | 8099.98 | 4 | SO45303 | 2022-05-22 | 648.00 | 7592.38 | 2024.99 | |||
SO53514_27 | 8580-40F8-81 | PO10411179199 | 100 | 289 | 500 | 182 | 1 | 2023-12-25 | 1204.69 | 30.12 | 2023-12-13 | 2 | 601.74 | 1 | 1204.69 | 27 | SO53514 | 2023-12-20 | 96.38 | 1203.49 | 602.35 | |||
SO57105_34 | 3AE1-4A72-91 | PO18676113963 | 100 | 282 | 594 | 697 | 1 | 2024-02-24 | 2372.96 | 59.32 | 2024-02-12 | 7 | 308.22 | 1 | 2372.96 | 34 | SO57105 | 2024-02-19 | 189.84 | 2157.53 | 338.99 | |||
SO48078_1 | BCF1-4BE4-A7 | PO7221113204 | 100 | 289 | 358 | 326 | 1 | 2023-02-24 | 2458.92 | 61.47 | 2023-02-12 | 2 | 1105.81 | 1 | 2458.92 | 1 | SO48078 | 2023-02-19 | 196.71 | 2211.62 | 1229.46 | |||
SO51711_38 | 5CB8-480D-A1 | PO16414129790 | 100 | 289 | 558 | 236 | 1 | 2023-11-24 | 1457.96 | 36.45 | 2023-11-12 | 6 | 179.82 | 1 | 1457.96 | 38 | SO51711 | 2023-11-19 | 116.64 | 1078.89 | 242.99 | |||
SO69552_6 | 542B-4AC0-BA | PO7917166419 | 100 | 287 | 491 | 401 | 1 | 2024-08-24 | 97.18 | 2.43 | 2024-08-12 | 3 | 41.57 | 1 | 97.18 | 6 | SO69552 | 2024-08-19 | 7.77 | 124.72 | 32.39 | |||
SO67266_20 | 3CFE-46C9-88 | PO16588161069 | 100 | 289 | 524 | 146 | 1 | 2024-07-25 | 475.29 | 11.88 | 2024-07-13 | 3 | 144.59 | 1 | 475.29 | 20 | SO67266 | 2024-07-20 | 38.02 | 433.78 | 158.43 | |||
SO46327_3 | 62A7-4A24-82 | PO19169130329 | 100 | 289 | 293 | 272 | 1 | 2022-09-24 | 722.59 | 18.06 | 2022-09-12 | 1 | 623.84 | 1 | 722.59 | 3 | SO46327 | 2022-09-19 | 57.81 | 623.84 | 722.59 | |||
SO46650_3 | 85DE-4E77-BD | PO2581114875 | 100 | 282 | 327 | 9 | 698 | 1 | 211.41 | 2022-10-24 | 704.69 | 12.33 | 2022-10-12 | 3 | 486.71 | 1 | 493.28 | 3 | SO46650 | 2022-10-19 | 39.46 | 1460.12 | 234.90 | 0.30 |
SO47991_14 | 0F2E-4E6D-8E | PO15631116034 | 100 | 282 | 358 | 43 | 1 | 2023-02-24 | 6147.29 | 153.68 | 2023-02-12 | 5 | 1105.81 | 1 | 6147.29 | 14 | SO47991 | 2023-02-19 | 491.78 | 5529.05 | 1229.46 | |||
SO58916_10 | E928-4943-BC | PO17139180025 | 100 | 293 | 390 | 644 | 1 | 2024-03-25 | 3361.47 | 84.04 | 2024-03-13 | 5 | 713.08 | 1 | 3361.47 | 10 | SO58916 | 2024-03-20 | 268.92 | 3565.40 | 672.29 | |||
SO55325_15 | 2A57-4E18-99 | PO9338115445 | 100 | 293 | 579 | 451 | 1 | 2024-01-24 | 4373.46 | 109.34 | 2024-01-12 | 6 | 755.15 | 1 | 4373.46 | 15 | SO55325 | 2024-01-19 | 349.88 | 4530.90 | 728.91 | |||
SO43683_7 | 2299-44F7-95 | PO2552113807 | 100 | 289 | 223 | 506 | 1 | 2021-10-24 | 15.56 | 0.39 | 2021-10-12 | 3 | 5.71 | 1 | 15.56 | 7 | SO43683 | 2021-10-19 | 1.24 | 17.12 | 5.19 | |||
SO49850_9 | CBD2-4015-97 | PO2929118431 | 100 | 289 | 469 | 380 | 1 | 2023-07-25 | 45.59 | 1.14 | 2023-07-13 | 2 | 15.67 | 1 | 45.59 | 9 | SO49850 | 2023-07-20 | 3.65 | 31.34 | 22.79 | |||
SO57136_35 | 0031-4C10-84 | PO7627163680 | 100 | 272 | 482 | 3 | 433 | 1 | 4.45 | 2024-02-24 | 89.00 | 2.11 | 2024-02-12 | 18 | 3.36 | 1 | 84.55 | 35 | SO57136 | 2024-02-19 | 6.76 | 60.52 | 4.94 | 0.05 |
SO51721_46 | 9429-430D-89 | PO14500124798 | 100 | 282 | 471 | 650 | 1 | 2023-11-24 | 266.70 | 6.67 | 2023-11-12 | 7 | 23.75 | 1 | 266.70 | 46 | SO51721 | 2023-11-19 | 21.34 | 166.24 | 38.10 |
Generated 2024-11-11 08:24:04.270 UTC