[ROOT] dt FactResellerSale < WHERE DimEmployeeId EQ '287' > SKIP 2500 SHUFFLE < SKIP 2 > < TAKE 48 >
48 items
FactResellerSaleId | CarrierTrackingNumber | CustomerPONumber | DimCurrencyId | DimEmployeeId | DimProductId | DimResellerId | DimSalesTerritoryId | DueDate | ExtendedAmount | Freight | OrderDate | OrderQuantity | ProductStandardCost | RevisionNumber | SalesAmount | SalesOrderLineNumber | SalesOrderNumber | ShipDate | TaxAmt | TotalProductCost | UnitPrice |
---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
SO57157_5 | 2435-487B-AC | PO4843135815 | 100 | 287 | 225 | 257 | 4 | 2024-02-23 | 10.79 | 0.27 | 2024-02-11 | 2 | 6.92 | 1 | 10.79 | 5 | SO57157 | 2024-02-18 | 0.86 | 13.84 | 5.39 |
SO55282_19 | A72A-4D3A-BA | PO16298125578 | 100 | 287 | 477 | 599 | 4 | 2024-01-23 | 20.96 | 0.52 | 2024-01-11 | 7 | 1.87 | 1 | 20.96 | 19 | SO55282 | 2024-01-18 | 1.68 | 13.06 | 2.99 |
SO47018_36 | E622-43B1-98 | PO2523197473 | 100 | 287 | 447 | 167 | 4 | 2022-11-23 | 60.00 | 1.50 | 2022-11-11 | 4 | 10.31 | 1 | 60.00 | 36 | SO47018 | 2022-11-18 | 4.80 | 41.25 | 15.00 |
SO47374_16 | C6BE-481A-A0 | PO16182131046 | 100 | 287 | 224 | 23 | 4 | 2022-12-24 | 10.37 | 0.26 | 2022-12-12 | 2 | 5.23 | 1 | 10.37 | 16 | SO47374 | 2022-12-19 | 0.83 | 10.46 | 5.19 |
SO71896_26 | A37A-4B16-B0 | PO4640135042 | 100 | 287 | 515 | 648 | 4 | 2024-09-23 | 16.27 | 0.41 | 2024-09-11 | 1 | 12.04 | 1 | 16.27 | 26 | SO71896 | 2024-09-18 | 1.30 | 12.04 | 16.27 |
SO67287_10 | 3F1F-44DB-96 | PO10730119334 | 100 | 287 | 234 | 491 | 4 | 2024-07-24 | 149.97 | 3.75 | 2024-07-12 | 5 | 38.49 | 1 | 149.97 | 10 | SO67287 | 2024-07-19 | 12.00 | 192.46 | 29.99 |
SO48738_1 | 07F3-4BF5-82 | PO10237154959 | 100 | 287 | 333 | 41 | 4 | 2023-04-25 | 939.59 | 23.49 | 2023-04-13 | 2 | 486.71 | 1 | 939.59 | 1 | SO48738 | 2023-04-20 | 75.17 | 973.41 | 469.79 |
SO46980_15 | FAA2-449B-99 | PO13572170679 | 100 | 287 | 323 | 527 | 3 | 2022-11-23 | 1409.38 | 35.23 | 2022-11-11 | 3 | 486.71 | 1 | 1409.38 | 15 | SO46980 | 2022-11-18 | 112.75 | 1460.12 | 469.79 |
SO65168_1 | 7CDD-4B4A-AE | PO18038110078 | 100 | 287 | 578 | 509 | 4 | 2024-06-23 | 1457.82 | 36.45 | 2024-06-11 | 2 | 755.15 | 1 | 1457.82 | 1 | SO65168 | 2024-06-18 | 116.63 | 1510.30 | 728.91 |
SO49541_1 | B736-4142-A1 | PO7569133326 | 100 | 287 | 469 | 608 | 4 | 2023-06-23 | 91.18 | 2.28 | 2023-06-11 | 4 | 15.67 | 1 | 91.18 | 1 | SO49541 | 2023-06-18 | 7.29 | 62.68 | 22.79 |
SO48775_14 | E56E-4C8C-AA | PO10817145980 | 100 | 287 | 375 | 203 | 4 | 2023-04-25 | 1308.94 | 32.72 | 2023-04-13 | 1 | 1320.68 | 1 | 1308.94 | 14 | SO48775 | 2023-04-20 | 104.72 | 1320.68 | 1308.94 |
SO65258_11 | 6CDC-4EA0-B2 | PO13543123789 | 100 | 287 | 511 | 293 | 1 | 2024-06-23 | 436.91 | 10.92 | 2024-06-11 | 2 | 199.38 | 1 | 436.91 | 11 | SO65258 | 2024-06-18 | 34.95 | 398.75 | 218.45 |
SO58946_10 | F9DD-426F-9A | PO12470155874 | 100 | 287 | 570 | 672 | 1 | 2024-03-24 | 890.82 | 22.27 | 2024-03-12 | 2 | 461.44 | 1 | 890.82 | 10 | SO58946 | 2024-03-19 | 71.27 | 922.89 | 445.41 |
SO49498_33 | D9E7-4090-86 | PO16472151816 | 100 | 287 | 368 | 239 | 4 | 2023-06-23 | 8796.06 | 219.90 | 2023-06-11 | 6 | 1518.79 | 1 | 8796.06 | 33 | SO49498 | 2023-06-18 | 703.68 | 9112.72 | 1466.01 |
SO50298_18 | 2A9C-4236-85 | PO4843196377 | 100 | 287 | 383 | 257 | 4 | 2023-08-23 | 1200.53 | 30.01 | 2023-08-11 | 2 | 605.65 | 1 | 1200.53 | 18 | SO50298 | 2023-08-18 | 96.04 | 1211.30 | 600.26 |
SO49534_3 | 2910-41C4-A3 | PO5510112224 | 100 | 287 | 343 | 5 | 4 | 2023-06-23 | 1879.18 | 46.98 | 2023-06-11 | 4 | 486.71 | 1 | 1879.18 | 3 | SO49534 | 2023-06-18 | 150.33 | 1946.83 | 469.79 |
SO65183_1 | 4E49-448C-93 | PO16269127603 | 100 | 287 | 547 | 624 | 4 | 2024-06-23 | 97.19 | 2.43 | 2024-06-11 | 2 | 35.96 | 1 | 97.19 | 1 | SO65183 | 2024-06-18 | 7.78 | 71.92 | 48.59 |
SO50672_23 | 1BE9-437C-8A | PO16472110144 | 100 | 287 | 221 | 239 | 4 | 2023-09-23 | 121.12 | 3.03 | 2023-09-11 | 6 | 13.88 | 1 | 121.12 | 23 | SO50672 | 2023-09-18 | 9.69 | 83.27 | 20.19 |
SO65258_14 | 6CDC-4EA0-B2 | PO13543123789 | 100 | 287 | 531 | 293 | 1 | 2024-06-23 | 449.62 | 11.24 | 2024-06-11 | 3 | 136.79 | 1 | 449.62 | 14 | SO65258 | 2024-06-18 | 35.97 | 410.36 | 149.87 |
SO50252_28 | B5DA-491E-A9 | PO2523194031 | 100 | 287 | 389 | 167 | 4 | 2023-08-23 | 4201.84 | 105.05 | 2023-08-11 | 7 | 605.65 | 1 | 4201.84 | 28 | SO50252 | 2023-08-18 | 336.15 | 4239.54 | 600.26 |
SO67325_25 | 981F-41CE-8A | PO7859144943 | 100 | 287 | 382 | 221 | 4 | 2024-07-24 | 1344.59 | 33.61 | 2024-07-12 | 2 | 713.08 | 1 | 1344.59 | 25 | SO67325 | 2024-07-19 | 107.57 | 1426.16 | 672.29 |
SO57035_3 | CD56-4460-9B | PO15921199440 | 100 | 287 | 606 | 77 | 4 | 2024-02-23 | 971.98 | 24.30 | 2024-02-11 | 3 | 343.65 | 1 | 971.98 | 3 | SO57035 | 2024-02-18 | 77.76 | 1030.95 | 323.99 |
SO67290_2 | 763C-4FCC-8E | PO10237115936 | 100 | 287 | 491 | 41 | 4 | 2024-07-24 | 161.97 | 4.05 | 2024-07-12 | 5 | 41.57 | 1 | 161.97 | 2 | SO67290 | 2024-07-19 | 12.96 | 207.86 | 32.39 |
SO69509_24 | 3683-45BF-B7 | PO4611111760 | 100 | 287 | 603 | 131 | 4 | 2024-08-23 | 72.89 | 1.82 | 2024-08-11 | 1 | 53.94 | 1 | 72.89 | 24 | SO69509 | 2024-08-18 | 5.83 | 53.94 | 72.89 |
SO67274_16 | EAF2-43E4-AB | PO13659172775 | 100 | 287 | 598 | 437 | 4 | 2024-07-24 | 323.99 | 8.10 | 2024-07-12 | 1 | 294.58 | 1 | 323.99 | 16 | SO67274 | 2024-07-19 | 25.92 | 294.58 | 323.99 |
SO50725_6 | 84DA-4CF7-8D | PO13717128221 | 100 | 287 | 368 | 473 | 4 | 2023-09-23 | 1466.01 | 36.65 | 2023-09-11 | 1 | 1518.79 | 1 | 1466.01 | 6 | SO50725 | 2023-09-18 | 117.28 | 1518.79 | 1466.01 |
SO50672_33 | 1BE9-437C-8A | PO16472110144 | 100 | 287 | 333 | 239 | 4 | 2023-09-23 | 3758.35 | 93.96 | 2023-09-11 | 8 | 486.71 | 1 | 3758.35 | 33 | SO50672 | 2023-09-18 | 300.67 | 3893.65 | 469.79 |
SO50672_28 | 1BE9-437C-8A | PO16472110144 | 100 | 287 | 339 | 239 | 4 | 2023-09-23 | 3288.56 | 82.21 | 2023-09-11 | 7 | 486.71 | 1 | 3288.56 | 28 | SO50672 | 2023-09-18 | 263.08 | 3406.95 | 469.79 |
SO50672_18 | 1BE9-437C-8A | PO16472110144 | 100 | 287 | 335 | 239 | 4 | 2023-09-23 | 1409.38 | 35.23 | 2023-09-11 | 3 | 486.71 | 1 | 1409.38 | 18 | SO50672 | 2023-09-18 | 112.75 | 1460.12 | 469.79 |
SO47018_43 | E622-43B1-98 | PO2523197473 | 100 | 287 | 221 | 167 | 4 | 2022-11-23 | 121.12 | 3.03 | 2022-11-11 | 6 | 13.88 | 1 | 121.12 | 43 | SO47018 | 2022-11-18 | 9.69 | 83.27 | 20.19 |
SO48737_1 | 87E3-4D91-A1 | PO10730182359 | 100 | 287 | 387 | 491 | 4 | 2023-04-25 | 600.26 | 15.01 | 2023-04-13 | 1 | 605.65 | 1 | 600.26 | 1 | SO48737 | 2023-04-20 | 48.02 | 605.65 | 600.26 |
SO69466_15 | 8B97-4CC6-8A | PO2523169620 | 100 | 287 | 582 | 167 | 4 | 2024-08-23 | 1020.59 | 25.51 | 2024-08-11 | 1 | 1082.51 | 1 | 1020.59 | 15 | SO69466 | 2024-08-18 | 81.65 | 1082.51 | 1020.59 |
SO65252_4 | F817-49F6-A9 | PO12470159616 | 100 | 287 | 503 | 672 | 1 | 2024-06-23 | 1000.26 | 25.01 | 2024-06-11 | 5 | 199.85 | 1 | 1000.26 | 4 | SO65252 | 2024-06-18 | 80.02 | 999.26 | 200.05 |
SO65167_14 | D40C-4211-94 | PO18125182344 | 100 | 287 | 584 | 311 | 4 | 2024-06-23 | 971.98 | 24.30 | 2024-06-11 | 3 | 343.65 | 1 | 971.98 | 14 | SO65167 | 2024-06-18 | 77.76 | 1030.95 | 323.99 |
SO49498_8 | D9E7-4090-86 | PO16472151816 | 100 | 287 | 224 | 239 | 4 | 2023-06-23 | 41.49 | 1.04 | 2023-06-11 | 8 | 5.23 | 1 | 41.49 | 8 | SO49498 | 2023-06-18 | 3.32 | 41.84 | 5.19 |
SO71896_6 | A37A-4B16-B0 | PO4640135042 | 100 | 287 | 363 | 648 | 4 | 2024-09-23 | 2753.99 | 68.85 | 2024-09-11 | 2 | 1251.98 | 1 | 2753.99 | 6 | SO71896 | 2024-09-18 | 220.32 | 2503.96 | 1376.99 |
SO50298_26 | 2A9C-4236-85 | PO4843196377 | 100 | 287 | 433 | 257 | 4 | 2023-08-23 | 324.45 | 8.11 | 2023-08-11 | 1 | 300.12 | 1 | 324.45 | 26 | SO50298 | 2023-08-18 | 25.96 | 300.12 | 324.45 |
SO50221_3 | EAD6-4841-B9 | PO13572116484 | 100 | 287 | 329 | 527 | 3 | 2023-08-23 | 469.79 | 11.74 | 2023-08-11 | 1 | 486.71 | 1 | 469.79 | 3 | SO50221 | 2023-08-18 | 37.58 | 486.71 | 469.79 |
SO48384_20 | C99C-4AEC-9E | PO7569115185 | 100 | 287 | 354 | 608 | 4 | 2023-03-25 | 7457.11 | 186.43 | 2023-03-13 | 6 | 1117.86 | 1 | 7457.11 | 20 | SO48384 | 2023-03-20 | 596.57 | 6707.14 | 1242.85 |
SO50661_31 | CE6E-45C9-A1 | PO19633184648 | 100 | 287 | 460 | 149 | 3 | 2023-09-23 | 215.98 | 5.40 | 2023-09-11 | 4 | 37.12 | 1 | 215.98 | 31 | SO50661 | 2023-09-18 | 17.28 | 148.48 | 53.99 |
SO49503_1 | 1FD6-48BE-A1 | PO13543189827 | 100 | 287 | 420 | 293 | 1 | 2023-06-23 | 141.62 | 3.54 | 2023-06-11 | 1 | 104.80 | 1 | 141.62 | 1 | SO49503 | 2023-06-18 | 11.33 | 104.80 | 141.62 |
SO48374_2 | 6271-4D04-BE | PO5510147369 | 100 | 287 | 325 | 5 | 4 | 2023-03-25 | 1879.18 | 46.98 | 2023-03-13 | 4 | 486.71 | 1 | 1879.18 | 2 | SO48374 | 2023-03-20 | 150.33 | 1946.83 | 469.79 |
SO71812_17 | 3257-4AE0-A8 | PO13543115747 | 100 | 287 | 552 | 293 | 1 | 2024-09-23 | 219.58 | 5.49 | 2024-09-11 | 4 | 40.62 | 1 | 219.58 | 17 | SO71812 | 2024-09-18 | 17.57 | 162.49 | 54.89 |
SO48769_3 | A39E-4380-A6 | PO7859190388 | 100 | 287 | 233 | 221 | 4 | 2023-04-25 | 201.88 | 5.05 | 2023-04-13 | 7 | 29.08 | 1 | 201.88 | 3 | SO48769 | 2023-04-20 | 16.15 | 203.56 | 28.84 |
SO55265_12 | D45F-41FE-9B | PO10237157039 | 100 | 287 | 491 | 41 | 4 | 2024-01-23 | 194.36 | 4.86 | 2024-01-11 | 6 | 41.57 | 1 | 194.36 | 12 | SO55265 | 2024-01-18 | 15.55 | 249.43 | 32.39 |
SO67290_9 | 763C-4FCC-8E | PO10237115936 | 100 | 287 | 481 | 41 | 4 | 2024-07-24 | 32.36 | 0.81 | 2024-07-12 | 6 | 3.36 | 1 | 32.36 | 9 | SO67290 | 2024-07-19 | 2.59 | 20.17 | 5.39 |
SO49506_1 | A1B2-45C6-A2 | PO13717198252 | 100 | 287 | 422 | 473 | 4 | 2023-06-23 | 202.62 | 5.07 | 2023-06-11 | 3 | 49.98 | 1 | 202.62 | 1 | SO49506 | 2023-06-18 | 16.21 | 149.94 | 67.54 |
SO50298_23 | 2A9C-4236-85 | PO4843196377 | 100 | 287 | 377 | 257 | 4 | 2023-08-23 | 9162.56 | 229.06 | 2023-08-11 | 7 | 1320.68 | 1 | 9162.56 | 23 | SO50298 | 2023-08-18 | 733.01 | 9244.79 | 1308.94 |
Generated 2024-11-11 00:07:02.822 UTC