[ROOT] dt FactResellerSale < WHERE DimEmployeeId EQ '287' > SKIP 2500 SHUFFLE < SKIP 2000 > < TAKE 1000
45 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 |
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
| SO58946_26 | F9DD-426F-9A | PO12470155874 | 100 | 287 | 572 | 672 | 1 | 2024-03-23 | 2672.46 | 66.81 | 2024-03-11 | 6 | 461.44 | 1 | 2672.46 | 26 | SO58946 | 2024-03-18 | 213.80 | 2768.67 | 445.41 | |||
| SO53493_27 | F767-491F-84 | PO13543118174 | 100 | 287 | 398 | 293 | 1 | 2023-12-23 | 187.07 | 4.68 | 2023-12-11 | 7 | 19.78 | 1 | 187.07 | 27 | SO53493 | 2023-12-18 | 14.97 | 138.43 | 26.72 | |||
| SO47441_21 | 2582-4E47-98 | PO7569166535 | 100 | 287 | 412 | 608 | 4 | 2022-12-23 | 540.39 | 13.51 | 2022-12-11 | 3 | 133.30 | 1 | 540.39 | 21 | SO47441 | 2022-12-18 | 43.23 | 399.89 | 180.13 | |||
| SO49841_39 | 35A1-40DC-99 | PO10817181706 | 100 | 287 | 459 | 203 | 4 | 2023-07-23 | 107.99 | 2.70 | 2023-07-11 | 2 | 37.12 | 1 | 107.99 | 39 | SO49841 | 2023-07-18 | 8.64 | 74.24 | 53.99 | |||
| SO50672_4 | 1BE9-437C-8A | PO16472110144 | 100 | 287 | 224 | 239 | 4 | 2023-09-22 | 31.12 | 0.78 | 2023-09-10 | 6 | 5.23 | 1 | 31.12 | 4 | SO50672 | 2023-09-17 | 2.49 | 31.38 | 5.19 | |||
| SO53552_14 | C686-48BD-B0 | PO16182115085 | 100 | 287 | 544 | 23 | 4 | 2023-12-23 | 145.78 | 3.64 | 2023-12-11 | 3 | 35.96 | 1 | 145.78 | 14 | SO53552 | 2023-12-18 | 11.66 | 107.88 | 48.59 | |||
| SO50753_22 | 8073-4F97-BA | PO7569170218 | 100 | 287 | 409 | 608 | 4 | 2023-09-22 | 1046.28 | 26.16 | 2023-09-10 | 5 | 185.82 | 1 | 1046.28 | 22 | SO50753 | 2023-09-17 | 83.70 | 929.10 | 209.26 | |||
| SO55282_25 | A72A-4D3A-BA | PO16298125578 | 100 | 287 | 222 | 599 | 4 | 2024-01-22 | 209.94 | 5.25 | 2024-01-10 | 10 | 13.09 | 1 | 209.94 | 25 | SO55282 | 2024-01-17 | 16.80 | 130.86 | 20.99 | |||
| SO71848_7 | 7082-4BF5-AB | PO18763153352 | 100 | 287 | 573 | 59 | 4 | 2024-09-22 | 1430.44 | 35.76 | 2024-09-10 | 1 | 1481.94 | 1 | 1430.44 | 7 | SO71848 | 2024-09-17 | 114.44 | 1481.94 | 1430.44 | |||
| SO47352_1 | 9DF5-4A88-9C | PO19633111392 | 100 | 287 | 358 | 149 | 3 | 2022-12-23 | 3688.38 | 92.21 | 2022-12-11 | 3 | 1105.81 | 1 | 3688.38 | 1 | SO47352 | 2022-12-18 | 295.07 | 3317.43 | 1229.46 | |||
| SO55264_24 | 80F3-4A7B-A2 | PO10730163005 | 100 | 287 | 217 | 491 | 4 | 2024-01-22 | 104.97 | 2.62 | 2024-01-10 | 5 | 13.09 | 1 | 104.97 | 24 | SO55264 | 2024-01-17 | 8.40 | 65.43 | 20.99 | |||
| SO71857_13 | CD4E-4DE8-81 | PO16269151631 | 100 | 287 | 481 | 624 | 4 | 2024-09-22 | 32.36 | 0.81 | 2024-09-10 | 6 | 3.36 | 1 | 32.36 | 13 | SO71857 | 2024-09-17 | 2.59 | 20.17 | 5.39 | |||
| SO67305_12 | CBB5-42BF-9E | PO16298111473 | 100 | 287 | 498 | 599 | 4 | 2024-07-23 | 1204.69 | 30.12 | 2024-07-11 | 2 | 601.74 | 1 | 1204.69 | 12 | SO67305 | 2024-07-18 | 96.38 | 1203.49 | 602.35 | |||
| SO65258_13 | 6CDC-4EA0-B2 | PO13543123789 | 100 | 287 | 222 | 293 | 1 | 2024-06-22 | 20.99 | 0.52 | 2024-06-10 | 1 | 13.09 | 1 | 20.99 | 13 | SO65258 | 2024-06-17 | 1.68 | 13.09 | 20.99 | |||
| SO67305_41 | CBB5-42BF-9E | PO16298111473 | 100 | 287 | 214 | 599 | 4 | 2024-07-23 | 188.95 | 4.72 | 2024-07-11 | 9 | 13.09 | 1 | 188.95 | 41 | SO67305 | 2024-07-18 | 15.12 | 117.78 | 20.99 | |||
| SO55264_9 | 80F3-4A7B-A2 | PO10730163005 | 100 | 287 | 376 | 491 | 4 | 2024-01-22 | 2932.02 | 73.30 | 2024-01-10 | 2 | 1554.95 | 1 | 2932.02 | 9 | SO55264 | 2024-01-17 | 234.56 | 3109.90 | 1466.01 | |||
| SO47369_4 | B6B6-442B-8B | PO16472118462 | 100 | 287 | 239 | 239 | 4 | 2022-12-23 | 2342.45 | 58.56 | 2022-12-11 | 3 | 722.26 | 1 | 2342.45 | 4 | SO47369 | 2022-12-18 | 187.40 | 2166.77 | 780.82 | |||
| SO47387_17 | 4FFC-4663-AC | PO13543169662 | 100 | 287 | 399 | 293 | 1 | 2022-12-23 | 135.10 | 3.38 | 2022-12-11 | 4 | 24.99 | 1 | 135.10 | 17 | SO47387 | 2022-12-18 | 10.81 | 99.97 | 33.77 | |||
| SO58906_28 | 6BB0-48C1-BE | PO19633186598 | 100 | 287 | 472 | 149 | 3 | 2024-03-23 | 266.70 | 6.67 | 2024-03-11 | 7 | 23.75 | 1 | 266.70 | 28 | SO58906 | 2024-03-18 | 21.34 | 166.24 | 38.10 | |||
| SO58906_4 | 6BB0-48C1-BE | PO19633186598 | 100 | 287 | 490 | 149 | 3 | 2024-03-23 | 291.55 | 7.29 | 2024-03-11 | 9 | 41.57 | 1 | 291.55 | 4 | SO58906 | 2024-03-18 | 23.32 | 374.15 | 32.39 | |||
| SO57157_20 | 2435-487B-AC | PO4843135815 | 100 | 287 | 255 | 257 | 4 | 2024-02-22 | 202.33 | 5.06 | 2024-02-10 | 1 | 204.63 | 1 | 202.33 | 20 | SO57157 | 2024-02-17 | 16.19 | 204.63 | 202.33 | |||
| SO67287_1 | 3F1F-44DB-96 | PO10730119334 | 100 | 287 | 382 | 491 | 4 | 2024-07-23 | 2016.88 | 50.42 | 2024-07-11 | 3 | 713.08 | 1 | 2016.88 | 1 | SO67287 | 2024-07-18 | 161.35 | 2139.24 | 672.29 | |||
| SO51842_28 | 2A39-4E97-9A | PO4843199898 | 100 | 287 | 386 | 257 | 4 | 2023-11-22 | 1344.59 | 33.61 | 2023-11-10 | 2 | 713.08 | 1 | 1344.59 | 28 | SO51842 | 2023-11-17 | 107.57 | 1426.16 | 672.29 | |||
| SO47441_36 | 2582-4E47-98 | PO7569166535 | 100 | 287 | 397 | 608 | 4 | 2022-12-23 | 194.36 | 4.86 | 2022-12-11 | 8 | 17.98 | 1 | 194.36 | 36 | SO47441 | 2022-12-18 | 15.55 | 143.82 | 24.29 | |||
| SO53607_7 | 329F-491C-8E | PO5510117855 | 100 | 287 | 583 | 5 | 4 | 2023-12-23 | 6123.56 | 153.09 | 2023-12-11 | 6 | 1082.51 | 1 | 6123.56 | 7 | SO53607 | 2023-12-18 | 489.89 | 6495.06 | 1020.59 | |||
| SO69411_11 | E0BB-44D1-83 | PO15921144493 | 100 | 287 | 605 | 77 | 4 | 2024-08-22 | 647.99 | 16.20 | 2024-08-10 | 2 | 343.65 | 1 | 647.99 | 11 | SO69411 | 2024-08-17 | 51.84 | 687.30 | 323.99 | |||
| SO50661_5 | CE6E-45C9-A1 | PO19633184648 | 100 | 287 | 458 | 149 | 3 | 2023-09-22 | 269.96 | 6.75 | 2023-09-10 | 6 | 30.93 | 1 | 269.96 | 5 | SO50661 | 2023-09-17 | 21.60 | 185.60 | 44.99 | |||
| SO67325_19 | 981F-41CE-8A | PO7859144943 | 100 | 287 | 214 | 221 | 4 | 2024-07-23 | 188.95 | 4.72 | 2024-07-11 | 9 | 13.09 | 1 | 188.95 | 19 | SO67325 | 2024-07-18 | 15.12 | 117.78 | 20.99 | |||
| SO55322_11 | D600-436A-B7 | PO7859118281 | 100 | 287 | 217 | 2 | 221 | 4 | 4.46 | 2024-01-22 | 223.24 | 5.47 | 2024-01-10 | 11 | 13.09 | 1 | 218.77 | 11 | SO55322 | 2024-01-17 | 17.50 | 143.95 | 20.29 | 0.02 |
| SO47441_1 | 2582-4E47-98 | PO7569166535 | 100 | 287 | 358 | 2 | 608 | 4 | 332.77 | 2022-12-23 | 16638.68 | 407.65 | 2022-12-11 | 14 | 1105.81 | 1 | 16305.90 | 1 | SO47441 | 2022-12-18 | 1304.47 | 15481.34 | 1188.48 | 0.02 |
| SO47369_22 | B6B6-442B-8B | PO16472118462 | 100 | 287 | 335 | 239 | 4 | 2022-12-23 | 4228.15 | 105.70 | 2022-12-11 | 9 | 486.71 | 1 | 4228.15 | 22 | SO47369 | 2022-12-18 | 338.25 | 4380.36 | 469.79 | |||
| SO53552_5 | C686-48BD-B0 | PO16182115085 | 100 | 287 | 359 | 23 | 4 | 2023-12-23 | 4130.98 | 103.27 | 2023-12-11 | 3 | 1251.98 | 1 | 4130.98 | 5 | SO53552 | 2023-12-18 | 330.48 | 3755.94 | 1376.99 | |||
| SO49841_36 | 35A1-40DC-99 | PO10817181706 | 100 | 287 | 339 | 203 | 4 | 2023-07-23 | 939.59 | 23.49 | 2023-07-11 | 2 | 486.71 | 1 | 939.59 | 36 | SO49841 | 2023-07-18 | 75.17 | 973.41 | 469.79 | |||
| SO71890_14 | D31D-413E-BB | PO5510169156 | 100 | 287 | 477 | 5 | 4 | 2024-09-22 | 2.99 | 0.07 | 2024-09-10 | 1 | 1.87 | 1 | 2.99 | 14 | SO71890 | 2024-09-17 | 0.24 | 1.87 | 2.99 | |||
| SO47034_30 | A5AA-46C3-92 | PO4843149248 | 100 | 287 | 424 | 257 | 4 | 2022-11-22 | 428.47 | 10.71 | 2022-11-10 | 2 | 158.53 | 1 | 428.47 | 30 | SO47034 | 2022-11-17 | 34.28 | 317.07 | 214.24 | |||
| SO53454_11 | 278D-445A-99 | PO19633151350 | 100 | 287 | 491 | 149 | 3 | 2023-12-23 | 323.94 | 8.10 | 2023-12-11 | 10 | 41.57 | 1 | 323.94 | 11 | SO53454 | 2023-12-18 | 25.92 | 415.72 | 32.39 | |||
| SO47441_23 | 2582-4E47-98 | PO7569166535 | 100 | 287 | 365 | 608 | 4 | 2022-12-23 | 5183.95 | 129.60 | 2022-12-11 | 8 | 598.44 | 1 | 5183.95 | 23 | SO47441 | 2022-12-18 | 414.72 | 4787.48 | 647.99 | |||
| SO55322_5 | D600-436A-B7 | PO7859118281 | 100 | 287 | 471 | 2 | 221 | 4 | 8.10 | 2024-01-22 | 405.13 | 9.93 | 2024-01-10 | 11 | 23.75 | 1 | 397.03 | 5 | SO55322 | 2024-01-17 | 31.76 | 261.24 | 36.83 | 0.02 |
| SO50672_29 | 1BE9-437C-8A | PO16472110144 | 100 | 287 | 263 | 239 | 4 | 2023-09-22 | 809.33 | 20.23 | 2023-09-10 | 4 | 187.16 | 1 | 809.33 | 29 | SO50672 | 2023-09-17 | 64.75 | 748.63 | 202.33 | |||
| SO51842_13 | 2A39-4E97-9A | PO4843199898 | 100 | 287 | 258 | 257 | 4 | 2023-11-22 | 202.33 | 5.06 | 2023-11-10 | 1 | 204.63 | 1 | 202.33 | 13 | SO51842 | 2023-11-17 | 16.19 | 204.63 | 202.33 | |||
| SO57085_14 | D1E5-454C-85 | PO2523188219 | 100 | 287 | 472 | 167 | 4 | 2024-02-22 | 76.20 | 1.91 | 2024-02-10 | 2 | 23.75 | 1 | 76.20 | 14 | SO57085 | 2024-02-17 | 6.10 | 47.50 | 38.10 | |||
| SO47387_13 | 4FFC-4663-AC | PO13543169662 | 100 | 287 | 393 | 293 | 1 | 2022-12-23 | 550.78 | 13.77 | 2022-12-11 | 4 | 101.89 | 1 | 550.78 | 13 | SO47387 | 2022-12-18 | 44.06 | 407.57 | 137.69 | |||
| SO57131_24 | 635E-4BF2-B9 | PO4611148036 | 100 | 287 | 552 | 131 | 4 | 2024-02-22 | 109.79 | 2.74 | 2024-02-10 | 2 | 40.62 | 1 | 109.79 | 24 | SO57131 | 2024-02-17 | 8.78 | 81.24 | 54.89 | |||
| SO58906_31 | 6BB0-48C1-BE | PO19633186598 | 100 | 287 | 515 | 149 | 3 | 2024-03-23 | 32.54 | 0.81 | 2024-03-11 | 2 | 12.04 | 1 | 32.54 | 31 | SO58906 | 2024-03-18 | 2.60 | 24.08 | 16.27 | |||
| SO53500_8 | BEF0-4525-AF | PO12470126979 | 100 | 287 | 494 | 672 | 1 | 2023-12-23 | 1204.69 | 30.12 | 2023-12-11 | 2 | 601.74 | 1 | 1204.69 | 8 | SO53500 | 2023-12-18 | 96.38 | 1203.49 | 602.35 |
Generated 2024-11-10 03:18:13.303 UTC