[ROOT] dt FactResellerSale WHERE DimSalesTerritoryId EQ '1' > SHUFFLE SKIP 2000 < SKIP 720 > < TAKE 30 >
30 items
FactResellerSaleId | CarrierTrackingNumber | CustomerPONumber | DimCurrencyId | DimEmployeeId | DimProductId | DimResellerId | DimSalesTerritoryId | DueDate | ExtendedAmount | Freight | OrderDate | OrderQuantity | ProductStandardCost | RevisionNumber | SalesAmount | SalesOrderLineNumber | SalesOrderNumber | ShipDate | TaxAmt | TotalProductCost | UnitPrice |
---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
SO48732_1 | 7BC4-48B4-BA | PO13978110372 | 100 | 289 | 453 | 200 | 1 | 2023-04-25 | 35.99 | 0.90 | 2023-04-13 | 1 | 24.75 | 1 | 35.99 | 1 | SO48732 | 2023-04-20 | 2.88 | 24.75 | 35.99 |
SO51148_27 | 1D20-490E-98 | PO6612158387 | 100 | 286 | 578 | 110 | 1 | 2023-10-23 | 728.91 | 18.22 | 2023-10-11 | 1 | 755.15 | 1 | 728.91 | 27 | SO51148 | 2023-10-18 | 58.31 | 755.15 | 728.91 |
SO46646_5 | A64B-4F46-92 | PO1421164577 | 100 | 286 | 458 | 325 | 1 | 2022-10-23 | 224.97 | 5.62 | 2022-10-11 | 5 | 30.93 | 1 | 224.97 | 5 | SO46646 | 2022-10-18 | 18.00 | 154.67 | 44.99 |
SO69406_41 | E101-486C-A5 | PO16675181672 | 100 | 293 | 577 | 361 | 1 | 2024-08-23 | 1457.82 | 36.45 | 2024-08-11 | 2 | 755.15 | 1 | 1457.82 | 41 | SO69406 | 2024-08-18 | 116.63 | 1510.30 | 728.91 |
SO49163_1 | DE2F-4D6A-99 | PO7917119932 | 100 | 287 | 469 | 401 | 1 | 2023-05-26 | 68.38 | 1.71 | 2023-05-14 | 3 | 15.67 | 1 | 68.38 | 1 | SO49163 | 2023-05-21 | 5.47 | 47.01 | 22.79 |
SO58940_20 | 72B7-4C82-8A | PO13543115032 | 100 | 287 | 398 | 293 | 1 | 2024-03-24 | 106.90 | 2.67 | 2024-03-12 | 4 | 19.78 | 1 | 106.90 | 20 | SO58940 | 2024-03-19 | 8.55 | 79.10 | 26.72 |
SO43665_6 | 19F0-4638-8E | PO16588191572 | 100 | 289 | 223 | 146 | 1 | 2021-10-23 | 10.37 | 0.26 | 2021-10-11 | 2 | 5.71 | 1 | 10.37 | 6 | SO43665 | 2021-10-18 | 0.83 | 11.41 | 5.19 |
SO46643_23 | 49E8-4C7A-85 | PO899110603 | 100 | 289 | 377 | 290 | 1 | 2022-10-23 | 2617.88 | 65.45 | 2022-10-11 | 2 | 1320.68 | 1 | 2617.88 | 23 | SO46643 | 2022-10-18 | 209.43 | 2641.37 | 1308.94 |
SO61267_12 | BCFD-47EE-BD | PO7076191943 | 100 | 293 | 576 | 505 | 1 | 2024-04-24 | 2860.88 | 71.52 | 2024-04-12 | 2 | 1481.94 | 1 | 2860.88 | 12 | SO61267 | 2024-04-19 | 228.87 | 2963.88 | 1430.44 |
SO47443_15 | DDB8-4FAB-92 | PO7192110823 | 100 | 289 | 233 | 20 | 1 | 2022-12-24 | 57.68 | 1.44 | 2022-12-12 | 2 | 29.08 | 1 | 57.68 | 15 | SO47443 | 2022-12-19 | 4.61 | 58.16 | 28.84 |
SO50209_23 | D138-4E7C-86 | PO15573136083 | 100 | 293 | 470 | 487 | 1 | 2023-08-23 | 136.76 | 3.42 | 2023-08-11 | 6 | 15.67 | 1 | 136.76 | 23 | SO50209 | 2023-08-18 | 10.94 | 94.03 | 22.79 |
SO49849_17 | C8F3-4DDE-A6 | PO2552190786 | 100 | 286 | 224 | 506 | 1 | 2023-07-24 | 25.93 | 0.65 | 2023-07-12 | 5 | 5.23 | 1 | 25.93 | 17 | SO49849 | 2023-07-19 | 2.07 | 26.15 | 5.19 |
SO53623_16 | 7BBF-43AA-B5 | PO8903169981 | 100 | 293 | 234 | 235 | 1 | 2023-12-24 | 59.99 | 1.50 | 2023-12-12 | 2 | 38.49 | 1 | 59.99 | 16 | SO53623 | 2023-12-19 | 4.80 | 76.98 | 29.99 |
SO67294_35 | 85E2-46A1-BE | PO899165491 | 100 | 289 | 231 | 290 | 1 | 2024-07-24 | 119.98 | 3.00 | 2024-07-12 | 4 | 38.49 | 1 | 119.98 | 35 | SO67294 | 2024-07-19 | 9.60 | 153.97 | 29.99 |
SO53518_47 | 5712-444B-BC | PO841197199 | 100 | 286 | 591 | 254 | 1 | 2023-12-24 | 677.99 | 16.95 | 2023-12-12 | 2 | 308.22 | 1 | 677.99 | 47 | SO53518 | 2023-12-19 | 54.24 | 616.44 | 338.99 |
SO46379_1 | 8ABD-4B11-A1 | PO7192140645 | 100 | 289 | 232 | 20 | 1 | 2022-09-23 | 115.36 | 2.88 | 2022-09-11 | 4 | 31.72 | 1 | 115.36 | 1 | SO46379 | 2022-09-18 | 9.23 | 126.90 | 28.84 |
SO59021_9 | A306-4E83-B7 | PO7395154426 | 100 | 286 | 355 | 542 | 1 | 2024-03-24 | 8351.96 | 208.80 | 2024-03-12 | 6 | 1265.62 | 1 | 8351.96 | 9 | SO59021 | 2024-03-19 | 668.16 | 7593.72 | 1391.99 |
SO71791_4 | AB1B-4CE2-BA | PO17139191080 | 100 | 293 | 384 | 644 | 1 | 2024-09-23 | 672.29 | 16.81 | 2024-09-11 | 1 | 713.08 | 1 | 672.29 | 4 | SO71791 | 2024-09-18 | 53.78 | 713.08 | 672.29 |
SO51783_35 | B7A2-49BC-89 | PO18676114917 | 100 | 282 | 298 | 697 | 1 | 2023-11-23 | 2429.28 | 60.73 | 2023-11-11 | 3 | 739.04 | 1 | 2429.28 | 35 | SO51783 | 2023-11-18 | 194.34 | 2217.12 | 809.76 |
SO46976_12 | 23E2-4510-88 | PO14558186797 | 100 | 289 | 233 | 2 | 1 | 2022-11-23 | 115.36 | 2.88 | 2022-11-11 | 4 | 29.08 | 1 | 115.36 | 12 | SO46976 | 2022-11-18 | 9.23 | 116.32 | 28.84 |
SO71836_13 | E41E-40C1-84 | PO841118259 | 100 | 286 | 533 | 254 | 1 | 2024-09-23 | 599.50 | 14.99 | 2024-09-11 | 4 | 136.79 | 1 | 599.50 | 13 | SO71836 | 2024-09-18 | 47.96 | 547.14 | 149.87 |
SO53613_3 | 4A10-4F98-84 | PO6815195063 | 100 | 293 | 551 | 109 | 1 | 2023-12-24 | 316.86 | 7.92 | 2023-12-12 | 2 | 144.59 | 1 | 316.86 | 3 | SO53613 | 2023-12-19 | 25.35 | 289.19 | 158.43 |
SO48347_27 | 40D2-4DF5-93 | PO841112057 | 100 | 286 | 447 | 254 | 1 | 2023-03-25 | 60.00 | 1.50 | 2023-03-13 | 4 | 10.31 | 1 | 60.00 | 27 | SO48347 | 2023-03-20 | 4.80 | 41.25 | 15.00 |
SO47999_16 | DF06-4F6A-9D | PO14500121568 | 100 | 282 | 305 | 650 | 1 | 2023-02-23 | 736.15 | 18.40 | 2023-02-11 | 1 | 653.70 | 1 | 736.15 | 16 | SO47999 | 2023-02-18 | 58.89 | 653.70 | 736.15 |
SO50297_51 | 5199-40AD-90 | PO4727113542 | 100 | 293 | 265 | 343 | 1 | 2023-08-23 | 404.66 | 10.12 | 2023-08-11 | 2 | 187.16 | 1 | 404.66 | 51 | SO50297 | 2023-08-18 | 32.37 | 374.31 | 202.33 |
SO46348_16 | CF4C-437D-97 | PO13543132672 | 100 | 287 | 300 | 293 | 1 | 2022-09-23 | 1619.52 | 40.49 | 2022-09-11 | 2 | 699.09 | 1 | 1619.52 | 16 | SO46348 | 2022-09-18 | 129.56 | 1398.19 | 809.76 |
SO46957_1 | C98D-43A5-8A | PO16414179284 | 100 | 289 | 289 | 236 | 1 | 2022-11-23 | 2977.09 | 74.43 | 2022-11-11 | 4 | 660.91 | 1 | 2977.09 | 1 | SO46957 | 2022-11-18 | 238.17 | 2643.66 | 744.27 |
SO45564_8 | DD65-42A2-80 | PO5220129554 | 100 | 282 | 346 | 169 | 1 | 2022-06-23 | 6119.98 | 153.00 | 2022-06-11 | 3 | 1912.15 | 1 | 6119.98 | 8 | SO45564 | 2022-06-18 | 489.60 | 5736.46 | 2039.99 |
SO43894_4 | 7DF2-4E54-B0 | PO2958194987 | 100 | 286 | 349 | 559 | 1 | 2021-11-23 | 8099.98 | 202.50 | 2021-11-11 | 4 | 1898.09 | 1 | 8099.98 | 4 | SO43894 | 2021-11-18 | 648.00 | 7592.38 | 2024.99 |
SO49092_19 | 72CE-4E29-82 | PO14442163644 | 100 | 293 | 460 | 127 | 1 | 2023-05-26 | 161.98 | 4.05 | 2023-05-14 | 3 | 37.12 | 1 | 161.98 | 19 | SO49092 | 2023-05-21 | 12.96 | 111.36 | 53.99 |
Generated 2024-11-10 06:59:03.645 UTC