[ROOT] dt FactResellerSale < WHERE DimEmployeeId EQ '287' > SKIP 2500 SHUFFLE < SKIP 251 > < TAKE 62 >
62 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 |
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
| SO47018_57 | E622-43B1-98 | PO2523197473 | 100 | 287 | 458 | 167 | 4 | 2022-11-26 | 269.96 | 6.75 | 2022-11-14 | 6 | 30.93 | 1 | 269.96 | 57 | SO47018 | 2022-11-21 | 21.60 | 185.60 | 44.99 | |||
| SO46624_11 | 12A0-4CA7-93 | PO13659199342 | 100 | 287 | 428 | 437 | 4 | 2022-10-26 | 2092.56 | 52.31 | 2022-10-14 | 10 | 185.82 | 1 | 2092.56 | 11 | SO46624 | 2022-10-21 | 167.40 | 1858.19 | 209.26 | |||
| SO47387_4 | 4FFC-4663-AC | PO13543169662 | 100 | 287 | 420 | 293 | 1 | 2022-12-27 | 566.46 | 14.16 | 2022-12-15 | 4 | 104.80 | 1 | 566.46 | 4 | SO47387 | 2022-12-22 | 45.32 | 419.18 | 141.62 | |||
| SO47034_15 | A5AA-46C3-92 | PO4843149248 | 100 | 287 | 435 | 257 | 4 | 2022-11-26 | 648.91 | 16.22 | 2022-11-14 | 2 | 300.12 | 1 | 648.91 | 15 | SO47034 | 2022-11-21 | 51.91 | 600.24 | 324.45 | |||
| SO50252_37 | B5DA-491E-A9 | PO2523194031 | 100 | 287 | 370 | 167 | 4 | 2023-08-26 | 4398.03 | 109.95 | 2023-08-14 | 3 | 1518.79 | 1 | 4398.03 | 37 | SO50252 | 2023-08-21 | 351.84 | 4556.36 | 1466.01 | |||
| SO53552_2 | C686-48BD-B0 | PO16182115085 | 100 | 287 | 476 | 3 | 23 | 4 | 28.87 | 2023-12-27 | 577.42 | 13.71 | 2023-12-15 | 15 | 26.18 | 1 | 548.55 | 2 | SO53552 | 2023-12-22 | 43.88 | 392.64 | 38.49 | 0.05 |
| SO58946_19 | F9DD-426F-9A | PO12470155874 | 100 | 287 | 498 | 672 | 1 | 2024-03-27 | 602.35 | 15.06 | 2024-03-15 | 1 | 601.74 | 1 | 602.35 | 19 | SO58946 | 2024-03-22 | 48.19 | 601.74 | 602.35 | |||
| SO49841_3 | 35A1-40DC-99 | PO10817181706 | 100 | 287 | 216 | 203 | 4 | 2023-07-27 | 80.75 | 2.02 | 2023-07-15 | 4 | 13.88 | 1 | 80.75 | 3 | SO49841 | 2023-07-22 | 6.46 | 55.51 | 20.19 | |||
| SO55322_6 | D600-436A-B7 | PO7859118281 | 100 | 287 | 477 | 221 | 4 | 2024-01-26 | 11.98 | 0.30 | 2024-01-14 | 4 | 1.87 | 1 | 11.98 | 6 | SO55322 | 2024-01-21 | 0.96 | 7.47 | 2.99 | |||
| SO47018_22 | E622-43B1-98 | PO2523197473 | 100 | 287 | 323 | 167 | 4 | 2022-11-26 | 939.59 | 23.49 | 2022-11-14 | 2 | 486.71 | 1 | 939.59 | 22 | SO47018 | 2022-11-21 | 75.17 | 973.41 | 469.79 | |||
| SO49527_1 | BFD0-4AA2-AF | PO4640129987 | 100 | 287 | 367 | 648 | 4 | 2023-06-26 | 3887.96 | 97.20 | 2023-06-14 | 6 | 598.44 | 1 | 3887.96 | 1 | SO49527 | 2023-06-21 | 311.04 | 3590.61 | 647.99 | |||
| SO71849_11 | D1AA-4C46-B9 | PO18125130930 | 100 | 287 | 376 | 311 | 4 | 2024-09-26 | 2932.02 | 73.30 | 2024-09-14 | 2 | 1554.95 | 1 | 2932.02 | 11 | SO71849 | 2024-09-21 | 234.56 | 3109.90 | 1466.01 | |||
| SO46380_14 | C4E3-4894-81 | PO7569183330 | 100 | 287 | 349 | 7 | 608 | 4 | 3248.43 | 2022-09-26 | 9281.22 | 150.82 | 2022-09-14 | 11 | 1898.09 | 1 | 6032.79 | 14 | SO46380 | 2022-09-21 | 482.62 | 20879.04 | 843.75 | 0.35 |
| SO47034_27 | A5AA-46C3-92 | PO4843149248 | 100 | 287 | 381 | 257 | 4 | 2022-11-26 | 2401.05 | 60.03 | 2022-11-14 | 4 | 605.65 | 1 | 2401.05 | 27 | SO47034 | 2022-11-21 | 192.08 | 2422.60 | 600.26 | |||
| SO57049_2 | BC2C-45CA-91 | PO13572121800 | 100 | 287 | 408 | 527 | 3 | 2024-02-26 | 72.16 | 1.80 | 2024-02-14 | 1 | 53.40 | 1 | 72.16 | 2 | SO57049 | 2024-02-21 | 5.77 | 53.40 | 72.16 | |||
| SO47369_15 | B6B6-442B-8B | PO16472118462 | 100 | 287 | 462 | 239 | 4 | 2022-12-27 | 28.26 | 0.71 | 2022-12-15 | 2 | 9.71 | 1 | 28.26 | 15 | SO47369 | 2022-12-22 | 2.26 | 19.43 | 14.13 | |||
| SO67290_3 | 763C-4FCC-8E | PO10237115936 | 100 | 287 | 583 | 41 | 4 | 2024-07-27 | 3061.78 | 76.54 | 2024-07-15 | 3 | 1082.51 | 1 | 3061.78 | 3 | SO67290 | 2024-07-22 | 244.94 | 3247.53 | 1020.59 | |||
| SO47369_62 | B6B6-442B-8B | PO16472118462 | 100 | 287 | 407 | 239 | 4 | 2022-12-27 | 459.21 | 11.48 | 2022-12-15 | 7 | 48.55 | 1 | 459.21 | 62 | SO47369 | 2022-12-22 | 36.74 | 339.82 | 65.60 | |||
| SO47427_13 | 61AA-44CA-99 | PO4640137176 | 100 | 287 | 419 | 648 | 4 | 2022-12-27 | 52.65 | 1.32 | 2022-12-15 | 1 | 38.96 | 1 | 52.65 | 13 | SO47427 | 2022-12-22 | 4.21 | 38.96 | 52.65 | |||
| SO49503_1 | 1FD6-48BE-A1 | PO13543189827 | 100 | 287 | 420 | 293 | 1 | 2023-06-26 | 141.62 | 3.54 | 2023-06-14 | 1 | 104.80 | 1 | 141.62 | 1 | SO49503 | 2023-06-21 | 11.33 | 104.80 | 141.62 | |||
| SO47057_20 | 0D4D-45B2-91 | PO7917141916 | 100 | 287 | 469 | 401 | 1 | 2022-11-26 | 45.59 | 1.14 | 2022-11-14 | 2 | 15.67 | 1 | 45.59 | 20 | SO47057 | 2022-11-21 | 3.65 | 31.34 | 22.79 | |||
| SO55290_2 | 86B1-47CC-94 | PO14413186228 | 100 | 287 | 481 | 383 | 4 | 2024-01-26 | 37.76 | 0.94 | 2024-01-14 | 7 | 3.36 | 1 | 37.76 | 2 | SO55290 | 2024-01-21 | 3.02 | 23.54 | 5.39 | |||
| SO50221_30 | EAD6-4841-B9 | PO13572116484 | 100 | 287 | 377 | 527 | 3 | 2023-08-26 | 1308.94 | 32.72 | 2023-08-14 | 1 | 1320.68 | 1 | 1308.94 | 30 | SO50221 | 2023-08-21 | 104.72 | 1320.68 | 1308.94 | |||
| SO46668_12 | 6711-47BE-BF | PO7859142972 | 100 | 287 | 461 | 221 | 4 | 2022-10-26 | 269.97 | 6.75 | 2022-10-14 | 5 | 37.12 | 1 | 269.97 | 12 | SO46668 | 2022-10-21 | 21.60 | 185.60 | 53.99 | |||
| SO67325_10 | 981F-41CE-8A | PO7859144943 | 100 | 287 | 490 | 221 | 4 | 2024-07-27 | 323.94 | 8.10 | 2024-07-15 | 10 | 41.57 | 1 | 323.94 | 10 | SO67325 | 2024-07-22 | 25.92 | 415.72 | 32.39 | |||
| SO47352_17 | 9DF5-4A88-9C | PO19633111392 | 100 | 287 | 468 | 149 | 3 | 2022-12-27 | 45.59 | 1.14 | 2022-12-15 | 2 | 15.67 | 1 | 45.59 | 17 | SO47352 | 2022-12-22 | 3.65 | 31.34 | 22.79 | |||
| SO46980_32 | FAA2-449B-99 | PO13572170679 | 100 | 287 | 381 | 527 | 3 | 2022-11-26 | 1800.79 | 45.02 | 2022-11-14 | 3 | 605.65 | 1 | 1800.79 | 32 | SO46980 | 2022-11-21 | 144.06 | 1816.95 | 600.26 | |||
| SO53580_26 | FFE9-4F36-B2 | PO4640164085 | 100 | 287 | 361 | 648 | 4 | 2023-12-27 | 2753.99 | 68.85 | 2023-12-15 | 2 | 1251.98 | 1 | 2753.99 | 26 | SO53580 | 2023-12-22 | 220.32 | 2503.96 | 1376.99 | |||
| SO50298_22 | 2A9C-4236-85 | PO4843196377 | 100 | 287 | 331 | 257 | 4 | 2023-08-26 | 939.59 | 23.49 | 2023-08-14 | 2 | 486.71 | 1 | 939.59 | 22 | SO50298 | 2023-08-21 | 75.17 | 973.41 | 469.79 | |||
| SO57035_11 | CD56-4460-9B | PO15921199440 | 100 | 287 | 234 | 77 | 4 | 2024-02-26 | 59.99 | 1.50 | 2024-02-14 | 2 | 38.49 | 1 | 59.99 | 11 | SO57035 | 2024-02-21 | 4.80 | 76.98 | 29.99 | |||
| SO71896_6 | A37A-4B16-B0 | PO4640135042 | 100 | 287 | 363 | 648 | 4 | 2024-09-26 | 2753.99 | 68.85 | 2024-09-14 | 2 | 1251.98 | 1 | 2753.99 | 6 | SO71896 | 2024-09-21 | 220.32 | 2503.96 | 1376.99 | |||
| SO47436_7 | 4AA1-4884-91 | PO5510133089 | 100 | 287 | 433 | 5 | 4 | 2022-12-27 | 1297.81 | 32.45 | 2022-12-15 | 4 | 300.12 | 1 | 1297.81 | 7 | SO47436 | 2022-12-22 | 103.82 | 1200.48 | 324.45 | |||
| SO46624_20 | 12A0-4CA7-93 | PO13659199342 | 100 | 287 | 362 | 437 | 4 | 2022-10-26 | 4917.84 | 122.95 | 2022-10-14 | 4 | 1105.81 | 1 | 4917.84 | 20 | SO46624 | 2022-10-21 | 393.43 | 4423.24 | 1229.46 | |||
| SO57176_1 | 6881-42A1-B6 | PO7917176909 | 100 | 287 | 491 | 401 | 1 | 2024-02-26 | 161.97 | 4.05 | 2024-02-14 | 5 | 41.57 | 1 | 161.97 | 1 | SO57176 | 2024-02-21 | 12.96 | 207.86 | 32.39 | |||
| SO55282_18 | A72A-4D3A-BA | PO16298125578 | 100 | 287 | 493 | 599 | 4 | 2024-01-26 | 1200.31 | 30.01 | 2024-01-14 | 6 | 199.85 | 1 | 1200.31 | 18 | SO55282 | 2024-01-21 | 96.03 | 1199.11 | 200.05 | |||
| SO49841_11 | 35A1-40DC-99 | PO10817181706 | 100 | 287 | 379 | 203 | 4 | 2023-07-27 | 6544.69 | 163.62 | 2023-07-15 | 5 | 1320.68 | 1 | 6544.69 | 11 | SO49841 | 2023-07-22 | 523.58 | 6603.42 | 1308.94 | |||
| SO49541_10 | B736-4142-A1 | PO7569133326 | 100 | 287 | 409 | 608 | 4 | 2023-06-26 | 627.77 | 15.69 | 2023-06-14 | 3 | 185.82 | 1 | 627.77 | 10 | SO49541 | 2023-06-21 | 50.22 | 557.46 | 209.26 | |||
| SO49527_7 | BFD0-4AA2-AF | PO4640129987 | 100 | 287 | 421 | 648 | 4 | 2023-06-26 | 392.66 | 9.82 | 2023-06-14 | 2 | 145.28 | 1 | 392.66 | 7 | SO49527 | 2023-06-21 | 31.41 | 290.57 | 196.33 | |||
| SO50252_42 | B5DA-491E-A9 | PO2523194031 | 100 | 287 | 333 | 167 | 4 | 2023-08-26 | 3288.56 | 82.21 | 2023-08-14 | 7 | 486.71 | 1 | 3288.56 | 42 | SO50252 | 2023-08-21 | 263.08 | 3406.95 | 469.79 | |||
| SO50298_12 | 2A9C-4236-85 | PO4843196377 | 100 | 287 | 263 | 257 | 4 | 2023-08-26 | 404.66 | 10.12 | 2023-08-14 | 2 | 187.16 | 1 | 404.66 | 12 | SO50298 | 2023-08-21 | 32.37 | 374.31 | 202.33 | |||
| SO57176_3 | 6881-42A1-B6 | PO7917176909 | 100 | 287 | 471 | 401 | 1 | 2024-02-26 | 76.20 | 1.91 | 2024-02-14 | 2 | 23.75 | 1 | 76.20 | 3 | SO57176 | 2024-02-21 | 6.10 | 47.50 | 38.10 | |||
| SO67305_18 | CBB5-42BF-9E | PO16298111473 | 100 | 287 | 471 | 599 | 4 | 2024-07-27 | 114.30 | 2.86 | 2024-07-15 | 3 | 23.75 | 1 | 114.30 | 18 | SO67305 | 2024-07-22 | 9.14 | 71.25 | 38.10 | |||
| SO49503_7 | 1FD6-48BE-A1 | PO13543189827 | 100 | 287 | 470 | 293 | 1 | 2023-06-26 | 45.59 | 1.14 | 2023-06-14 | 2 | 15.67 | 1 | 45.59 | 7 | SO49503 | 2023-06-21 | 3.65 | 31.34 | 22.79 | |||
| SO47441_16 | 2582-4E47-98 | PO7569166535 | 100 | 287 | 469 | 608 | 4 | 2022-12-27 | 113.97 | 2.85 | 2022-12-15 | 5 | 15.67 | 1 | 113.97 | 16 | SO47441 | 2022-12-22 | 9.12 | 78.35 | 22.79 | |||
| SO55282_31 | A72A-4D3A-BA | PO16298125578 | 100 | 287 | 480 | 599 | 4 | 2024-01-26 | 8.24 | 0.21 | 2024-01-14 | 6 | 0.86 | 1 | 8.24 | 31 | SO55282 | 2024-01-21 | 0.66 | 5.14 | 1.37 | |||
| SO67305_33 | CBB5-42BF-9E | PO16298111473 | 100 | 287 | 231 | 599 | 4 | 2024-07-27 | 89.98 | 2.25 | 2024-07-15 | 3 | 38.49 | 1 | 89.98 | 33 | SO67305 | 2024-07-22 | 7.20 | 115.48 | 29.99 | |||
| SO53546_18 | 57CF-465D-B2 | PO16269114010 | 100 | 287 | 372 | 624 | 4 | 2023-12-27 | 2932.02 | 73.30 | 2023-12-15 | 2 | 1554.95 | 1 | 2932.02 | 18 | SO53546 | 2023-12-22 | 234.56 | 3109.90 | 1466.01 | |||
| SO49832_9 | 3280-41FF-A3 | PO13659150841 | 100 | 287 | 358 | 437 | 4 | 2023-07-27 | 1229.46 | 30.74 | 2023-07-15 | 1 | 1105.81 | 1 | 1229.46 | 9 | SO49832 | 2023-07-22 | 98.36 | 1105.81 | 1229.46 | |||
| SO50678_3 | CAED-407A-BA | PO13543174640 | 100 | 287 | 470 | 293 | 1 | 2023-09-26 | 136.76 | 3.42 | 2023-09-14 | 6 | 15.67 | 1 | 136.76 | 3 | SO50678 | 2023-09-21 | 10.94 | 94.03 | 22.79 | |||
| SO47374_4 | C6BE-481A-A0 | PO16182131046 | 100 | 287 | 420 | 23 | 4 | 2022-12-27 | 424.85 | 10.62 | 2022-12-15 | 3 | 104.80 | 1 | 424.85 | 4 | SO47374 | 2022-12-22 | 33.99 | 314.39 | 141.62 | |||
| SO57085_2 | D1E5-454C-85 | PO2523188219 | 100 | 287 | 477 | 167 | 4 | 2024-02-26 | 23.95 | 0.60 | 2024-02-14 | 8 | 1.87 | 1 | 23.95 | 2 | SO57085 | 2024-02-21 | 1.92 | 14.93 | 2.99 | |||
| SO50298_19 | 2A9C-4236-85 | PO4843196377 | 100 | 287 | 417 | 257 | 4 | 2023-08-26 | 648.91 | 16.22 | 2023-08-14 | 2 | 300.12 | 1 | 648.91 | 19 | SO50298 | 2023-08-21 | 51.91 | 600.24 | 324.45 | |||
| SO46668_26 | 6711-47BE-BF | PO7859142972 | 100 | 287 | 389 | 221 | 4 | 2022-10-26 | 2401.05 | 60.03 | 2022-10-14 | 4 | 605.65 | 1 | 2401.05 | 26 | SO46668 | 2022-10-21 | 192.08 | 2422.60 | 600.26 | |||
| SO50678_9 | CAED-407A-BA | PO13543174640 | 100 | 287 | 352 | 293 | 1 | 2023-09-26 | 4971.41 | 124.29 | 2023-09-14 | 4 | 1117.86 | 1 | 4971.41 | 9 | SO50678 | 2023-09-21 | 397.71 | 4471.42 | 1242.85 | |||
| SO71896_29 | A37A-4B16-B0 | PO4640135042 | 100 | 287 | 525 | 648 | 4 | 2024-09-26 | 158.43 | 3.96 | 2024-09-14 | 1 | 144.59 | 1 | 158.43 | 29 | SO71896 | 2024-09-21 | 12.67 | 144.59 | 158.43 | |||
| SO50661_26 | CE6E-45C9-A1 | PO19633184648 | 100 | 287 | 224 | 149 | 3 | 2023-09-26 | 20.75 | 0.52 | 2023-09-14 | 4 | 5.23 | 1 | 20.75 | 26 | SO50661 | 2023-09-21 | 1.66 | 20.92 | 5.19 | |||
| SO69527_13 | A6FE-49DA-BE | PO4843110434 | 100 | 287 | 605 | 257 | 4 | 2024-08-26 | 1619.97 | 40.50 | 2024-08-14 | 5 | 343.65 | 1 | 1619.97 | 13 | SO69527 | 2024-08-21 | 129.60 | 1718.25 | 323.99 | |||
| SO47441_21 | 2582-4E47-98 | PO7569166535 | 100 | 287 | 412 | 608 | 4 | 2022-12-27 | 540.39 | 13.51 | 2022-12-15 | 3 | 133.30 | 1 | 540.39 | 21 | SO47441 | 2022-12-22 | 43.23 | 399.89 | 180.13 | |||
| SO46668_29 | 6711-47BE-BF | PO7859142972 | 100 | 287 | 445 | 221 | 4 | 2022-10-26 | 71.99 | 1.80 | 2022-10-14 | 2 | 24.75 | 1 | 71.99 | 29 | SO46668 | 2022-10-21 | 5.76 | 49.49 | 35.99 | |||
| SO47386_5 | 53D3-4CF9-BD | PO13717112244 | 100 | 287 | 239 | 473 | 4 | 2022-12-27 | 780.82 | 19.52 | 2022-12-15 | 1 | 722.26 | 1 | 780.82 | 5 | SO47386 | 2022-12-22 | 62.47 | 722.26 | 780.82 | |||
| SO47034_35 | A5AA-46C3-92 | PO4843149248 | 100 | 287 | 439 | 257 | 4 | 2022-11-26 | 2342.45 | 58.56 | 2022-11-14 | 3 | 722.26 | 1 | 2342.45 | 35 | SO47034 | 2022-11-21 | 187.40 | 2166.77 | 780.82 | |||
| SO49498_27 | D9E7-4090-86 | PO16472151816 | 100 | 287 | 433 | 239 | 4 | 2023-06-26 | 2271.17 | 56.78 | 2023-06-14 | 7 | 300.12 | 1 | 2271.17 | 27 | SO49498 | 2023-06-21 | 181.69 | 2100.83 | 324.45 |
Generated 2024-11-13 05:33:33.349 UTC