[ROOT] dt FactResellerSale < WHERE DimSalesTerritoryId EQ '5' > SKIP 2875 SHUFFLE < SKIP 3000 > < TAKE 1000
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 |
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
| SO55328_11 | 577D-4DE9-B6 | PO9831188161 | 100 | 285 | 378 | 81 | 5 | 2023-12-02 | 2932.02 | 73.30 | 2023-11-20 | 2 | 1554.95 | 1 | 2932.02 | 11 | SO55328 | 2023-11-27 | 234.56 | 3109.90 | 1466.01 | |||
| SO46604_1 | 8062-4A97-B3 | PO522154989 | 100 | 285 | 365 | 676 | 5 | 2022-09-01 | 1943.98 | 48.60 | 2022-08-20 | 3 | 598.44 | 1 | 1943.98 | 1 | SO46604 | 2022-08-27 | 155.52 | 1795.31 | 647.99 | |||
| SO50701_6 | B67A-4C0A-B3 | PO2407199018 | 100 | 285 | 236 | 225 | 5 | 2023-08-02 | 28.84 | 0.72 | 2023-07-21 | 1 | 29.08 | 1 | 28.84 | 6 | SO50701 | 2023-07-28 | 2.31 | 29.08 | 28.84 | |||
| SO46373_1 | EEB7-4AA8-94 | PO5307177432 | 100 | 285 | 299 | 369 | 5 | 2022-08-02 | 1619.52 | 40.49 | 2022-07-21 | 2 | 699.09 | 1 | 1619.52 | 1 | SO46373 | 2022-07-28 | 129.56 | 1398.19 | 809.76 | |||
| SO46604_16 | 8062-4A97-B3 | PO522154989 | 100 | 285 | 420 | 676 | 5 | 2022-09-01 | 424.85 | 10.62 | 2022-08-20 | 3 | 104.80 | 1 | 424.85 | 16 | SO46604 | 2022-08-27 | 33.99 | 314.39 | 141.62 | |||
| SO47040_13 | 5A71-45F5-B9 | PO5568168365 | 100 | 285 | 358 | 422 | 5 | 2022-10-02 | 4917.84 | 122.95 | 2022-09-20 | 4 | 1105.81 | 1 | 4917.84 | 13 | SO47040 | 2022-09-27 | 393.43 | 4423.24 | 1229.46 | |||
| SO50231_15 | B2CA-498D-9B | PO11571129150 | 100 | 285 | 389 | 512 | 5 | 2023-07-02 | 2401.05 | 60.03 | 2023-06-20 | 4 | 605.65 | 1 | 2401.05 | 15 | SO50231 | 2023-06-27 | 192.08 | 2422.60 | 600.26 | |||
| SO49149_8 | D41E-4EFF-A5 | PO5858123072 | 100 | 285 | 221 | 566 | 5 | 2023-04-04 | 40.37 | 1.01 | 2023-03-23 | 2 | 13.88 | 1 | 40.37 | 8 | SO49149 | 2023-03-30 | 3.23 | 27.76 | 20.19 | |||
| SO46630_37 | F512-40F2-91 | PO12644161356 | 100 | 285 | 464 | 530 | 5 | 2022-09-01 | 28.26 | 0.71 | 2022-08-20 | 2 | 9.71 | 1 | 28.26 | 37 | SO46630 | 2022-08-27 | 2.26 | 19.43 | 14.13 | |||
| SO49091_6 | 7A94-486D-8A | PO19546118667 | 100 | 285 | 321 | 206 | 5 | 2023-04-04 | 939.59 | 23.49 | 2023-03-23 | 2 | 486.71 | 1 | 939.59 | 6 | SO49091 | 2023-03-30 | 75.17 | 973.41 | 469.79 | |||
| SO50231_18 | B2CA-498D-9B | PO11571129150 | 100 | 285 | 265 | 512 | 5 | 2023-07-02 | 202.33 | 5.06 | 2023-06-20 | 1 | 187.16 | 1 | 202.33 | 18 | SO50231 | 2023-06-27 | 16.19 | 187.16 | 202.33 | |||
| SO55234_7 | C6FC-46EE-88 | PO522140495 | 100 | 285 | 359 | 676 | 5 | 2023-12-02 | 8261.96 | 206.55 | 2023-11-20 | 6 | 1251.98 | 1 | 8261.96 | 7 | SO55234 | 2023-11-27 | 660.96 | 7511.89 | 1376.99 | |||
| SO47416_9 | 6B45-44AB-84 | PO2813155355 | 100 | 281 | 383 | 90 | 5 | 2022-11-02 | 600.26 | 15.01 | 2022-10-21 | 1 | 605.65 | 1 | 600.26 | 9 | SO47416 | 2022-10-28 | 48.02 | 605.65 | 600.26 | |||
| SO46345_2 | 469D-4520-80 | PO13746192187 | 100 | 285 | 307 | 567 | 5 | 2022-08-02 | 3612.97 | 90.32 | 2022-07-21 | 5 | 623.84 | 1 | 3612.97 | 2 | SO46345 | 2022-07-28 | 289.04 | 3119.20 | 722.59 | |||
| SO57074_6 | FF65-4261-97 | PO9918191120 | 100 | 285 | 566 | 260 | 5 | 2024-01-02 | 1336.23 | 33.41 | 2023-12-21 | 3 | 461.44 | 1 | 1336.23 | 6 | SO57074 | 2023-12-28 | 106.90 | 1384.33 | 445.41 | |||
| SO65249_4 | E573-4D05-8A | PO9222183651 | 100 | 285 | 580 | 171 | 5 | 2024-05-02 | 2041.19 | 51.03 | 2024-04-20 | 2 | 1082.51 | 1 | 2041.19 | 4 | SO65249 | 2024-04-27 | 163.30 | 2165.02 | 1020.59 | |||
| SO69533_5 | AC2B-4C39-84 | PO3596133486 | 100 | 285 | 591 | 16 | 476 | 5 | 90.40 | 2024-07-02 | 226.00 | 3.39 | 2024-06-20 | 2 | 308.22 | 1 | 135.60 | 5 | SO69533 | 2024-06-27 | 10.85 | 616.44 | 113.00 | 0.40 |
| SO46673_35 | 578D-4F7B-A6 | PO9657163155 | 100 | 285 | 308 | 315 | 5 | 2022-09-01 | 744.27 | 18.61 | 2022-08-20 | 1 | 660.91 | 1 | 744.27 | 35 | SO46673 | 2022-08-27 | 59.54 | 660.91 | 744.27 | |||
| SO69533_16 | AC2B-4C39-84 | PO3596133486 | 100 | 285 | 400 | 476 | 5 | 2024-07-02 | 74.30 | 1.86 | 2024-06-20 | 2 | 27.49 | 1 | 74.30 | 16 | SO69533 | 2024-06-27 | 5.94 | 54.99 | 37.15 | |||
| SO53563_12 | C955-44BD-A8 | PO9599165865 | 100 | 285 | 580 | 170 | 5 | 2023-11-02 | 4082.38 | 102.06 | 2023-10-21 | 4 | 1082.51 | 1 | 4082.38 | 12 | SO53563 | 2023-10-28 | 326.59 | 4330.04 | 1020.59 | |||
| SO53563_17 | C955-44BD-A8 | PO9599165865 | 100 | 285 | 520 | 170 | 5 | 2023-11-02 | 63.17 | 1.58 | 2023-10-21 | 2 | 23.37 | 1 | 63.17 | 17 | SO53563 | 2023-10-28 | 5.05 | 46.74 | 31.58 | |||
| SO57162_11 | 83B5-43A6-BD | PO3596174424 | 100 | 285 | 357 | 476 | 5 | 2024-01-02 | 1391.99 | 34.80 | 2023-12-21 | 1 | 1265.62 | 1 | 1391.99 | 11 | SO57162 | 2023-12-28 | 111.36 | 1265.62 | 1391.99 | |||
| SO50306_1 | D376-4A40-86 | PO5858194676 | 100 | 285 | 447 | 566 | 5 | 2023-07-02 | 60.00 | 1.50 | 2023-06-20 | 4 | 10.31 | 1 | 60.00 | 1 | SO50306 | 2023-06-27 | 4.80 | 41.25 | 15.00 | |||
| SO50703_26 | 4A3D-44CB-B3 | PO2813140706 | 100 | 283 | 213 | 90 | 5 | 2023-08-02 | 181.68 | 4.54 | 2023-07-21 | 9 | 13.88 | 1 | 181.68 | 26 | SO50703 | 2023-07-28 | 14.53 | 124.90 | 20.19 | |||
| SO69465_31 | B8B2-4B14-99 | PO2842153886 | 100 | 285 | 390 | 700 | 5 | 2024-07-02 | 672.29 | 16.81 | 2024-06-20 | 1 | 713.08 | 1 | 672.29 | 31 | SO69465 | 2024-06-27 | 53.78 | 713.08 | 672.29 | |||
| SO49509_8 | 1105-4F75-BE | PO9599181538 | 100 | 285 | 341 | 170 | 5 | 2023-05-02 | 939.59 | 23.49 | 2023-04-20 | 2 | 486.71 | 1 | 939.59 | 8 | SO49509 | 2023-04-27 | 75.17 | 973.41 | 469.79 | |||
| SO55234_18 | C6FC-46EE-88 | PO522140495 | 100 | 285 | 465 | 676 | 5 | 2023-12-02 | 58.78 | 1.47 | 2023-11-20 | 4 | 9.16 | 1 | 58.78 | 18 | SO55234 | 2023-11-27 | 4.70 | 36.64 | 14.69 | |||
| SO50212_9 | BDB8-4FEA-94 | PO15051162285 | 100 | 285 | 352 | 207 | 5 | 2023-07-02 | 1242.85 | 31.07 | 2023-06-20 | 1 | 1117.86 | 1 | 1242.85 | 9 | SO50212 | 2023-06-27 | 99.43 | 1117.86 | 1242.85 | |||
| SO67331_8 | F7D7-49F2-83 | PO3741116971 | 100 | 285 | 606 | 404 | 5 | 2024-06-02 | 323.99 | 8.10 | 2024-05-21 | 1 | 343.65 | 1 | 323.99 | 8 | SO67331 | 2024-05-28 | 25.92 | 343.65 | 323.99 | |||
| SO55253_21 | C58B-49D8-9F | PO12644132539 | 100 | 285 | 596 | 530 | 5 | 2023-12-02 | 323.99 | 8.10 | 2023-11-20 | 1 | 294.58 | 1 | 323.99 | 21 | SO55253 | 2023-11-27 | 25.92 | 294.58 | 323.99 | |||
| SO50306_39 | D376-4A40-86 | PO5858194676 | 100 | 285 | 459 | 566 | 5 | 2023-07-02 | 161.98 | 4.05 | 2023-06-20 | 3 | 37.12 | 1 | 161.98 | 39 | SO50306 | 2023-06-27 | 12.96 | 111.36 | 53.99 | |||
| SO69518_28 | 96AA-48F8-80 | PO5800191682 | 100 | 285 | 555 | 63 | 5 | 2024-07-02 | 191.70 | 4.79 | 2024-06-20 | 3 | 47.29 | 1 | 191.70 | 28 | SO69518 | 2024-06-27 | 15.34 | 141.86 | 63.90 | |||
| SO47424_4 | 9DF2-4A59-AE | PO4089167750 | 100 | 285 | 399 | 368 | 5 | 2022-11-02 | 67.55 | 1.69 | 2022-10-21 | 2 | 24.99 | 1 | 67.55 | 4 | SO47424 | 2022-10-28 | 5.40 | 49.99 | 33.77 | |||
| SO69465_36 | B8B2-4B14-99 | PO2842153886 | 100 | 285 | 372 | 700 | 5 | 2024-07-02 | 1466.01 | 36.65 | 2024-06-20 | 1 | 1554.95 | 1 | 1466.01 | 36 | SO69465 | 2024-06-27 | 117.28 | 1554.95 | 1466.01 | |||
| SO51081_39 | EDBF-4FE1-8F | PO522116846 | 100 | 285 | 543 | 676 | 5 | 2023-09-01 | 37.25 | 0.93 | 2023-08-20 | 1 | 27.57 | 1 | 37.25 | 39 | SO51081 | 2023-08-27 | 2.98 | 27.57 | 37.25 | |||
| SO69565_7 | F165-437F-B9 | PO9773181473 | 100 | 285 | 484 | 8 | 5 | 2024-07-02 | 4.77 | 0.12 | 2024-06-20 | 1 | 2.97 | 1 | 4.77 | 7 | SO69565 | 2024-06-27 | 0.38 | 2.97 | 4.77 | |||
| SO53474_29 | E5B6-4103-8D | PO15457187993 | 100 | 285 | 573 | 297 | 5 | 2023-11-02 | 4291.33 | 107.28 | 2023-10-21 | 3 | 1481.94 | 1 | 4291.33 | 29 | SO53474 | 2023-10-28 | 343.31 | 4445.81 | 1430.44 | |||
| SO49090_20 | BA90-48D0-89 | PO11571148651 | 100 | 285 | 331 | 512 | 5 | 2023-04-04 | 1879.18 | 46.98 | 2023-03-23 | 4 | 486.71 | 1 | 1879.18 | 20 | SO49090 | 2023-03-30 | 150.33 | 1946.83 | 469.79 | |||
| SO46673_11 | 578D-4F7B-A6 | PO9657163155 | 100 | 285 | 456 | 315 | 5 | 2022-09-01 | 179.98 | 4.50 | 2022-08-20 | 4 | 30.93 | 1 | 179.98 | 11 | SO46673 | 2022-08-27 | 14.40 | 123.73 | 44.99 | |||
| SO50756_32 | C414-447C-84 | PO9570119689 | 100 | 285 | 213 | 585 | 5 | 2023-08-02 | 40.37 | 1.01 | 2023-07-21 | 2 | 13.88 | 1 | 40.37 | 32 | SO50756 | 2023-07-28 | 3.23 | 27.76 | 20.19 | |||
| SO49509_25 | 1105-4F75-BE | PO9599181538 | 100 | 285 | 339 | 170 | 5 | 2023-05-02 | 2348.97 | 58.72 | 2023-04-20 | 5 | 486.71 | 1 | 2348.97 | 25 | SO49509 | 2023-04-27 | 187.92 | 2433.53 | 469.79 | |||
| SO55331_6 | 4195-4A79-A3 | PO9889143385 | 100 | 285 | 400 | 494 | 5 | 2023-12-02 | 148.61 | 3.72 | 2023-11-20 | 4 | 27.49 | 1 | 148.61 | 6 | SO55331 | 2023-11-27 | 11.89 | 109.97 | 37.15 | |||
| SO53524_20 | 2B2B-440F-8B | PO1537151724 | 100 | 285 | 471 | 611 | 5 | 2023-11-02 | 152.40 | 3.81 | 2023-10-21 | 4 | 23.75 | 1 | 152.40 | 20 | SO53524 | 2023-10-28 | 12.19 | 95.00 | 38.10 | |||
| SO46933_15 | 4D88-4B51-BF | PO19546168601 | 100 | 285 | 337 | 206 | 5 | 2022-10-02 | 939.59 | 23.49 | 2022-09-20 | 2 | 486.71 | 1 | 939.59 | 15 | SO46933 | 2022-09-27 | 75.17 | 973.41 | 469.79 | |||
| SO50306_28 | D376-4A40-86 | PO5858194676 | 100 | 285 | 458 | 566 | 5 | 2023-07-02 | 179.98 | 4.50 | 2023-06-20 | 4 | 30.93 | 1 | 179.98 | 28 | SO50306 | 2023-06-27 | 14.40 | 123.73 | 44.99 | |||
| SO53563_1 | C955-44BD-A8 | PO9599165865 | 100 | 285 | 378 | 170 | 5 | 2023-11-02 | 5864.04 | 146.60 | 2023-10-21 | 4 | 1554.95 | 1 | 5864.04 | 1 | SO53563 | 2023-10-28 | 469.12 | 6219.79 | 1466.01 | |||
| SO50703_42 | 4A3D-44CB-B3 | PO2813140706 | 100 | 283 | 460 | 90 | 5 | 2023-08-02 | 107.99 | 2.70 | 2023-07-21 | 2 | 37.12 | 1 | 107.99 | 42 | SO50703 | 2023-07-28 | 8.64 | 74.24 | 53.99 | |||
| SO67348_22 | 4BD1-4782-A3 | PO9889141767 | 100 | 285 | 512 | 494 | 5 | 2024-06-02 | 218.45 | 5.46 | 2024-05-21 | 1 | 199.38 | 1 | 218.45 | 22 | SO67348 | 2024-05-28 | 17.48 | 199.38 | 218.45 | |||
| SO49865_21 | E9A6-42D3-91 | PO9831136904 | 100 | 285 | 329 | 81 | 5 | 2023-06-02 | 939.59 | 23.49 | 2023-05-21 | 2 | 486.71 | 1 | 939.59 | 21 | SO49865 | 2023-05-28 | 75.17 | 973.41 | 469.79 | |||
| SO57118_6 | 69CB-481B-8D | PO5800191707 | 100 | 285 | 527 | 63 | 5 | 2024-01-02 | 475.29 | 11.88 | 2023-12-21 | 3 | 144.59 | 1 | 475.29 | 6 | SO57118 | 2023-12-28 | 38.02 | 433.78 | 158.43 | |||
| SO49090_3 | BA90-48D0-89 | PO11571148651 | 100 | 285 | 327 | 512 | 5 | 2023-04-04 | 1409.38 | 35.23 | 2023-03-23 | 3 | 486.71 | 1 | 1409.38 | 3 | SO49090 | 2023-03-30 | 112.75 | 1460.12 | 469.79 | |||
| SO50212_1 | BDB8-4FEA-94 | PO15051162285 | 100 | 285 | 469 | 207 | 5 | 2023-07-02 | 91.18 | 2.28 | 2023-06-20 | 4 | 15.67 | 1 | 91.18 | 1 | SO50212 | 2023-06-27 | 7.29 | 62.68 | 22.79 | |||
| SO46672_27 | FFCF-4848-99 | PO9831178966 | 100 | 285 | 221 | 8 | 81 | 5 | 6.73 | 2022-09-01 | 67.29 | 1.51 | 2022-08-20 | 4 | 13.88 | 1 | 60.56 | 27 | SO46672 | 2022-08-27 | 4.84 | 55.51 | 16.82 | 0.10 |
| SO47067_25 | DDEC-4319-8A | PO9512118933 | 100 | 285 | 242 | 135 | 5 | 2022-10-02 | 780.82 | 19.52 | 2022-09-20 | 1 | 722.26 | 1 | 780.82 | 25 | SO47067 | 2022-09-27 | 62.47 | 722.26 | 780.82 | |||
| SO49122_4 | 816D-4941-B1 | PO18560157781 | 100 | 285 | 323 | 531 | 5 | 2023-04-04 | 1409.38 | 35.23 | 2023-03-23 | 3 | 486.71 | 1 | 1409.38 | 4 | SO49122 | 2023-03-30 | 112.75 | 1460.12 | 469.79 | |||
| SO46604_23 | 8062-4A97-B3 | PO522154989 | 100 | 285 | 453 | 676 | 5 | 2022-09-01 | 107.98 | 2.70 | 2022-08-20 | 3 | 24.75 | 1 | 107.98 | 23 | SO46604 | 2022-08-27 | 8.64 | 74.24 | 35.99 | |||
| SO57106_1 | 7981-4CAF-8C | PO18734144812 | 100 | 283 | 551 | 449 | 5 | 2024-01-02 | 158.43 | 3.96 | 2023-12-21 | 1 | 144.59 | 1 | 158.43 | 1 | SO57106 | 2023-12-28 | 12.67 | 144.59 | 158.43 | |||
| SO53551_23 | 8593-405C-AB | PO14297167079 | 100 | 285 | 558 | 627 | 5 | 2023-11-02 | 242.99 | 6.07 | 2023-10-21 | 1 | 179.82 | 1 | 242.99 | 23 | SO53551 | 2023-10-28 | 19.44 | 179.82 | 242.99 | |||
| SO57162_31 | 83B5-43A6-BD | PO3596174424 | 100 | 285 | 402 | 476 | 5 | 2024-01-02 | 144.32 | 3.61 | 2023-12-21 | 2 | 53.40 | 1 | 144.32 | 31 | SO57162 | 2023-12-28 | 11.55 | 106.80 | 72.16 | |||
| SO57088_5 | EA31-4951-8A | PO2842199218 | 100 | 285 | 484 | 700 | 5 | 2024-01-02 | 33.39 | 0.83 | 2023-12-21 | 7 | 2.97 | 1 | 33.39 | 5 | SO57088 | 2023-12-28 | 2.67 | 20.81 | 4.77 | |||
| SO65242_13 | 0175-4222-B3 | PO14297142992 | 100 | 285 | 561 | 627 | 5 | 2024-05-02 | 1430.44 | 35.76 | 2024-04-20 | 1 | 1481.94 | 1 | 1430.44 | 13 | SO65242 | 2024-04-27 | 114.44 | 1481.94 | 1430.44 | |||
| SO55234_24 | C6FC-46EE-88 | PO522140495 | 100 | 285 | 477 | 676 | 5 | 2023-12-02 | 17.96 | 0.45 | 2023-11-20 | 6 | 1.87 | 1 | 17.96 | 24 | SO55234 | 2023-11-27 | 1.44 | 11.20 | 2.99 |
Generated 2024-09-19 21:19:38.561 UTC