[ROOT] dt FactResellerSale < WHERE DimSalesTerritoryId EQ '6' > SKIP 0 SHUFFLE < SKIP 1626 > < 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 |
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
| SO49454_2 | C24C-4087-A6 | PO17690116637 | 19 | 291 | 358 | 47 | 6 | 2023-06-23 | 6147.29 | 153.68 | 2023-06-11 | 5 | 1105.81 | 1 | 6147.29 | 2 | SO49454 | 2023-06-18 | 491.78 | 5529.05 | 1229.46 | |||
| SO43886_17 | CE58-49B5-82 | PO1827149671 | 19 | 288 | 229 | 317 | 6 | 2021-11-23 | 144.20 | 3.61 | 2021-11-11 | 5 | 31.72 | 1 | 144.20 | 17 | SO43886 | 2021-11-18 | 11.54 | 158.62 | 28.84 | |||
| SO47973_26 | B9F1-47DA-87 | PO18705118148 | 19 | 291 | 230 | 479 | 6 | 2023-02-23 | 173.04 | 4.33 | 2023-02-11 | 6 | 29.08 | 1 | 173.04 | 26 | SO47973 | 2023-02-18 | 13.84 | 174.48 | 28.84 | |||
| SO51781_9 | 63E7-4ABF-A9 | PO20039116715 | 19 | 291 | 517 | 65 | 6 | 2023-11-23 | 94.75 | 2.37 | 2023-11-11 | 3 | 23.37 | 1 | 94.75 | 9 | SO51781 | 2023-11-18 | 7.58 | 70.12 | 31.58 | |||
| SO46622_3 | 1009-4D99-85 | PO13862155069 | 19 | 291 | 362 | 119 | 6 | 2022-10-23 | 6147.29 | 153.68 | 2022-10-11 | 5 | 1105.81 | 1 | 6147.29 | 3 | SO46622 | 2022-10-18 | 491.78 | 5529.05 | 1229.46 | |||
| SO61248_18 | 67A0-4D10-87 | PO4495126386 | 19 | 291 | 487 | 496 | 6 | 2024-04-24 | 197.96 | 4.95 | 2024-04-12 | 6 | 20.57 | 1 | 197.96 | 18 | SO61248 | 2024-04-19 | 15.84 | 123.40 | 32.99 | |||
| SO45315_5 | A83F-4F76-BA | PO2146148184 | 19 | 284 | 218 | 354 | 6 | 2022-05-26 | 17.10 | 0.43 | 2022-05-14 | 3 | 3.40 | 1 | 17.10 | 5 | SO45315 | 2022-05-21 | 1.37 | 10.19 | 5.70 | |||
| SO57016_3 | 5FA2-418F-AF | PO19227187256 | 19 | 284 | 545 | 210 | 6 | 2024-02-23 | 24.29 | 0.61 | 2024-02-11 | 1 | 17.98 | 1 | 24.29 | 3 | SO57016 | 2024-02-18 | 1.94 | 17.98 | 24.29 | |||
| SO45269_1 | 74A3-4D71-A7 | PO19691172522 | 19 | 288 | 348 | 353 | 6 | 2022-05-26 | 2024.99 | 50.62 | 2022-05-14 | 1 | 1898.09 | 1 | 2024.99 | 1 | SO45269 | 2022-05-21 | 162.00 | 1898.09 | 2024.99 | |||
| SO57122_4 | 048F-465A-A8 | PO4901112587 | 19 | 284 | 482 | 84 | 6 | 2024-02-23 | 32.36 | 0.81 | 2024-02-11 | 6 | 3.36 | 1 | 32.36 | 4 | SO57122 | 2024-02-18 | 2.59 | 20.17 | 5.39 | |||
| SO69400_11 | 761C-4315-82 | PO17806199596 | 19 | 291 | 546 | 101 | 6 | 2024-08-23 | 149.02 | 3.73 | 2024-08-11 | 4 | 27.57 | 1 | 149.02 | 11 | SO69400 | 2024-08-18 | 11.92 | 110.27 | 37.25 | |||
| SO46657_24 | CA71-4EDF-A1 | PO4495116659 | 19 | 291 | 426 | 496 | 6 | 2022-10-23 | 209.26 | 5.23 | 2022-10-11 | 1 | 185.82 | 1 | 209.26 | 24 | SO46657 | 2022-10-18 | 16.74 | 185.82 | 209.26 | |||
| SO47399_12 | B5FA-4CC2-8C | PO10962177551 | 19 | 284 | 427 | 685 | 6 | 2022-12-24 | 418.51 | 10.46 | 2022-12-12 | 2 | 185.82 | 1 | 418.51 | 12 | SO47399 | 2022-12-19 | 33.48 | 371.64 | 209.26 | |||
| SO51704_41 | 13FA-4729-A9 | PO17661178081 | 19 | 284 | 561 | 14 | 264 | 6 | 572.18 | 2023-11-23 | 2860.88 | 57.22 | 2023-11-11 | 3 | 1481.94 | 1 | 2288.71 | 41 | SO51704 | 2023-11-18 | 183.10 | 4445.81 | 953.63 | 0.20 |
| SO46071_8 | 1563-4F33-9D | PO1827148074 | 19 | 288 | 275 | 317 | 6 | 2022-08-23 | 356.90 | 8.92 | 2022-08-11 | 1 | 352.14 | 1 | 356.90 | 8 | SO46071 | 2022-08-18 | 28.55 | 352.14 | 356.90 | |||
| SO50668_17 | A5FC-4831-B4 | PO17574113752 | 19 | 291 | 420 | 678 | 6 | 2023-09-23 | 1416.15 | 35.40 | 2023-09-11 | 10 | 104.80 | 1 | 1416.15 | 17 | SO50668 | 2023-09-18 | 113.29 | 1047.95 | 141.62 | |||
| SO58918_1 | C811-4D40-80 | PO17574131484 | 19 | 291 | 490 | 678 | 6 | 2024-03-24 | 194.36 | 4.86 | 2024-03-12 | 6 | 41.57 | 1 | 194.36 | 1 | SO58918 | 2024-03-19 | 15.55 | 249.43 | 32.39 | |||
| SO57120_23 | 058D-436F-BF | PO4466170177 | 19 | 291 | 309 | 352 | 6 | 2024-02-23 | 818.70 | 20.47 | 2024-02-11 | 1 | 747.20 | 1 | 818.70 | 23 | SO57120 | 2024-02-18 | 65.50 | 747.20 | 818.70 | |||
| SO69541_7 | 75C0-4A42-AE | PO2030150622 | 19 | 284 | 590 | 661 | 6 | 2024-08-23 | 461.69 | 11.54 | 2024-08-11 | 1 | 419.78 | 1 | 461.69 | 7 | SO69541 | 2024-08-18 | 36.94 | 419.78 | 461.69 | |||
| SO51116_9 | B371-45B5-B0 | PO10527115387 | 19 | 284 | 483 | 480 | 6 | 2023-10-23 | 144.00 | 3.60 | 2023-10-11 | 2 | 44.88 | 1 | 144.00 | 9 | SO51116 | 2023-10-18 | 11.52 | 89.76 | 72.00 | |||
| SO58957_11 | 13BB-49DB-84 | PO10962177270 | 19 | 284 | 353 | 685 | 6 | 2024-03-24 | 1391.99 | 34.80 | 2024-03-12 | 1 | 1265.62 | 1 | 1391.99 | 11 | SO58957 | 2024-03-19 | 111.36 | 1265.62 | 1391.99 | |||
| SO50233_3 | 1FF6-48A6-A7 | PO10469158272 | 19 | 291 | 470 | 335 | 6 | 2023-08-23 | 68.38 | 1.71 | 2023-08-11 | 3 | 15.67 | 1 | 68.38 | 3 | SO50233 | 2023-08-18 | 5.47 | 47.01 | 22.79 | |||
| SO58925_19 | ACBD-43C3-A2 | PO15544139465 | 19 | 284 | 552 | 282 | 6 | 2024-03-24 | 164.68 | 4.12 | 2024-03-12 | 3 | 40.62 | 1 | 164.68 | 19 | SO58925 | 2024-03-19 | 13.17 | 121.86 | 54.89 | |||
| SO51113_18 | C890-4CA6-90 | PO11136135505 | 19 | 284 | 565 | 13 | 120 | 6 | 50.11 | 2023-10-23 | 334.06 | 7.10 | 2023-10-11 | 1 | 461.44 | 1 | 283.95 | 18 | SO51113 | 2023-10-18 | 22.72 | 461.44 | 334.06 | 0.15 |
| SO50689_9 | 20BC-4161-86 | PO10614135588 | 19 | 291 | 448 | 461 | 6 | 2023-09-23 | 35.98 | 0.90 | 2023-09-11 | 3 | 8.25 | 1 | 35.98 | 9 | SO50689 | 2023-09-18 | 2.88 | 24.74 | 11.99 | |||
| SO47366_20 | DD3E-4DAA-BA | PO17545115575 | 19 | 291 | 341 | 155 | 6 | 2022-12-24 | 2348.97 | 58.72 | 2022-12-12 | 5 | 486.71 | 1 | 2348.97 | 20 | SO47366 | 2022-12-19 | 187.92 | 2433.53 | 469.79 | |||
| SO50687_5 | DF8C-416B-BA | PO10962187340 | 19 | 284 | 420 | 685 | 6 | 2023-09-23 | 283.23 | 7.08 | 2023-09-11 | 2 | 104.80 | 1 | 283.23 | 5 | SO50687 | 2023-09-18 | 22.66 | 209.59 | 141.62 | |||
| SO51791_37 | DAF1-41B6-96 | PO18328158624 | 19 | 284 | 376 | 552 | 6 | 2023-11-23 | 1466.01 | 36.65 | 2023-11-11 | 1 | 1554.95 | 1 | 1466.01 | 37 | SO51791 | 2023-11-18 | 117.28 | 1554.95 | 1466.01 | |||
| SO51755_17 | 46F4-477C-A7 | PO11020169365 | 19 | 284 | 376 | 336 | 6 | 2023-11-23 | 2932.02 | 73.30 | 2023-11-11 | 2 | 1554.95 | 1 | 2932.02 | 17 | SO51755 | 2023-11-18 | 234.56 | 3109.90 | 1466.01 | |||
| SO65235_18 | 0A92-4A75-90 | PO10962154595 | 19 | 284 | 588 | 685 | 6 | 2024-06-23 | 461.69 | 11.54 | 2024-06-11 | 1 | 419.78 | 1 | 461.69 | 18 | SO65235 | 2024-06-18 | 36.94 | 419.78 | 461.69 | |||
| SO50689_25 | 20BC-4161-86 | PO10614135588 | 19 | 291 | 458 | 461 | 6 | 2023-09-23 | 179.98 | 4.50 | 2023-09-11 | 4 | 30.93 | 1 | 179.98 | 25 | SO50689 | 2023-09-18 | 14.40 | 123.73 | 44.99 | |||
| SO46953_1 | C650-4C32-BE | PO17603154442 | 19 | 284 | 433 | 12 | 6 | 2022-11-23 | 2595.62 | 64.89 | 2022-11-11 | 8 | 300.12 | 1 | 2595.62 | 1 | SO46953 | 2022-11-18 | 207.65 | 2400.95 | 324.45 | |||
| SO57021_3 | D648-4574-9E | PO17632193909 | 19 | 291 | 488 | 28 | 6 | 2024-02-23 | 97.18 | 2.43 | 2024-02-11 | 3 | 41.57 | 1 | 97.18 | 3 | SO57021 | 2024-02-18 | 7.77 | 124.72 | 32.39 | |||
| SO50674_1 | 0316-488D-80 | PO14906132898 | 19 | 291 | 236 | 424 | 6 | 2023-09-23 | 115.36 | 2.88 | 2023-09-11 | 4 | 29.08 | 1 | 115.36 | 1 | SO50674 | 2023-09-18 | 9.23 | 116.32 | 28.84 | |||
| SO71794_55 | C39A-4835-99 | PO17574111985 | 19 | 291 | 475 | 678 | 6 | 2024-09-23 | 167.98 | 4.20 | 2024-09-11 | 4 | 26.18 | 1 | 167.98 | 55 | SO71794 | 2024-09-18 | 13.44 | 104.71 | 41.99 | |||
| SO51818_27 | B8CE-4C91-A9 | PO9077115532 | 19 | 291 | 544 | 100 | 6 | 2023-11-23 | 97.19 | 2.43 | 2023-11-11 | 2 | 35.96 | 1 | 97.19 | 27 | SO51818 | 2023-11-18 | 7.78 | 71.92 | 48.59 | |||
| SO50664_8 | 85F5-458B-8D | PO19401149024 | 19 | 291 | 389 | 173 | 6 | 2023-09-23 | 600.26 | 15.01 | 2023-09-11 | 1 | 605.65 | 1 | 600.26 | 8 | SO50664 | 2023-09-18 | 48.02 | 605.65 | 600.26 | |||
| SO53545_1 | 2CC7-4F36-B6 | PO14239178578 | 19 | 291 | 487 | 550 | 6 | 2023-12-24 | 98.98 | 2.47 | 2023-12-12 | 3 | 20.57 | 1 | 98.98 | 1 | SO53545 | 2023-12-19 | 7.92 | 61.70 | 32.99 | |||
| SO51703_1 | 53F7-4B59-AA | PO17603160217 | 19 | 284 | 546 | 12 | 6 | 2023-11-23 | 111.76 | 2.79 | 2023-11-11 | 3 | 27.57 | 1 | 111.76 | 1 | SO51703 | 2023-11-18 | 8.94 | 82.70 | 37.25 | |||
| SO51700_5 | 6837-439E-BC | PO17806126316 | 19 | 291 | 491 | 101 | 6 | 2023-11-23 | 64.79 | 1.62 | 2023-11-11 | 2 | 41.57 | 1 | 64.79 | 5 | SO51700 | 2023-11-18 | 5.18 | 83.14 | 32.39 | |||
| SO45527_6 | 610E-44BC-87 | PO17545114353 | 19 | 288 | 328 | 155 | 6 | 2022-06-23 | 1677.84 | 41.95 | 2022-06-11 | 4 | 413.15 | 1 | 1677.84 | 6 | SO45527 | 2022-06-18 | 134.23 | 1652.59 | 419.46 | |||
| SO53535_30 | 8195-45C7-93 | PO18502176746 | 19 | 291 | 570 | 13 | 154 | 6 | 150.33 | 2023-12-24 | 1002.17 | 21.30 | 2023-12-12 | 3 | 461.44 | 1 | 851.85 | 30 | SO53535 | 2023-12-19 | 68.15 | 1384.33 | 334.06 | 0.15 |
| SO67316_8 | 6F7E-4455-9E | PO4495115494 | 19 | 291 | 474 | 2 | 496 | 6 | 8.93 | 2024-07-24 | 446.54 | 10.94 | 2024-07-12 | 11 | 26.18 | 1 | 437.61 | 8 | SO67316 | 2024-07-19 | 35.01 | 287.94 | 40.59 | 0.02 |
| SO50242_44 | A651-4343-86 | PO1595193228 | 19 | 284 | 271 | 426 | 6 | 2023-08-23 | 202.33 | 5.06 | 2023-08-11 | 1 | 187.16 | 1 | 202.33 | 44 | SO50242 | 2023-08-18 | 16.19 | 187.16 | 202.33 | |||
| SO47411_5 | 4BDD-4511-AC | PO1798140269 | 19 | 291 | 365 | 10 | 6 | 2022-12-24 | 2591.98 | 64.80 | 2022-12-12 | 4 | 598.44 | 1 | 2591.98 | 5 | SO47411 | 2022-12-19 | 207.36 | 2393.74 | 647.99 | |||
| SO65174_5 | E2AA-4EEC-93 | PO17574133893 | 19 | 291 | 490 | 678 | 6 | 2024-06-23 | 97.18 | 2.43 | 2024-06-11 | 3 | 41.57 | 1 | 97.18 | 5 | SO65174 | 2024-06-18 | 7.77 | 124.72 | 32.39 | |||
| SO48033_43 | BC9E-4246-AC | PO1595118269 | 19 | 284 | 343 | 2 | 426 | 6 | 99.91 | 2023-02-23 | 4995.48 | 122.39 | 2023-02-11 | 11 | 486.71 | 1 | 4895.57 | 43 | SO48033 | 2023-02-18 | 391.65 | 5353.77 | 454.13 | 0.02 |
| SO46075_1 | D380-48D0-9A | PO2204192145 | 19 | 288 | 326 | 370 | 6 | 2022-08-23 | 419.46 | 10.49 | 2022-08-11 | 1 | 413.15 | 1 | 419.46 | 1 | SO46075 | 2022-08-18 | 33.56 | 413.15 | 419.46 | |||
| SO63290_10 | 0F43-405E-B8 | PO9077159728 | 19 | 291 | 472 | 100 | 6 | 2024-05-25 | 114.30 | 2.86 | 2024-05-13 | 3 | 23.75 | 1 | 114.30 | 10 | SO63290 | 2024-05-20 | 9.14 | 71.25 | 38.10 | |||
| SO63269_6 | B1E2-43BD-84 | PO2030137986 | 19 | 284 | 544 | 661 | 6 | 2024-05-25 | 97.19 | 2.43 | 2024-05-13 | 2 | 35.96 | 1 | 97.19 | 6 | SO63269 | 2024-05-20 | 7.78 | 71.92 | 48.59 | |||
| SO51100_17 | A159-4950-A0 | PO13862191766 | 19 | 291 | 544 | 119 | 6 | 2023-10-23 | 48.59 | 1.21 | 2023-10-11 | 1 | 35.96 | 1 | 48.59 | 17 | SO51100 | 2023-10-18 | 3.89 | 35.96 | 48.59 | |||
| SO57154_37 | 464B-46A4-B6 | PO1856185040 | 19 | 291 | 496 | 263 | 6 | 2024-02-23 | 2409.38 | 60.23 | 2024-02-11 | 4 | 601.74 | 1 | 2409.38 | 37 | SO57154 | 2024-02-18 | 192.75 | 2406.97 | 602.35 | |||
| SO47354_6 | 6E1C-48C6-89 | PO19401144959 | 19 | 291 | 271 | 173 | 6 | 2022-12-24 | 404.66 | 10.12 | 2022-12-12 | 2 | 187.16 | 1 | 404.66 | 6 | SO47354 | 2022-12-19 | 32.37 | 374.31 | 202.33 | |||
| SO57097_4 | 9A9E-444B-B1 | PO18328123706 | 19 | 284 | 487 | 552 | 6 | 2024-02-23 | 32.99 | 0.82 | 2024-02-11 | 1 | 20.57 | 1 | 32.99 | 4 | SO57097 | 2024-02-18 | 2.64 | 20.57 | 32.99 | |||
| SO69479_37 | 3D8D-4908-A6 | PO18328116976 | 19 | 284 | 482 | 552 | 6 | 2024-08-23 | 16.18 | 0.40 | 2024-08-11 | 3 | 3.36 | 1 | 16.18 | 37 | SO69479 | 2024-08-18 | 1.29 | 10.09 | 5.39 | |||
| SO53464_20 | E113-419B-8F | PO17545119283 | 19 | 291 | 384 | 155 | 6 | 2023-12-24 | 2016.88 | 50.42 | 2023-12-12 | 3 | 713.08 | 1 | 2016.88 | 20 | SO53464 | 2023-12-19 | 161.35 | 2139.24 | 672.29 | |||
| SO51704_32 | 13FA-4729-A9 | PO17661178081 | 19 | 284 | 564 | 14 | 264 | 6 | 190.73 | 2023-11-23 | 953.63 | 19.07 | 2023-11-11 | 1 | 1481.94 | 1 | 762.90 | 32 | SO51704 | 2023-11-18 | 61.03 | 1481.94 | 953.63 | 0.20 |
| SO51132_7 | D4A8-472C-A4 | PO18444136544 | 19 | 291 | 386 | 227 | 6 | 2023-10-23 | 1344.59 | 33.61 | 2023-10-11 | 2 | 713.08 | 1 | 1344.59 | 7 | SO51132 | 2023-10-18 | 107.57 | 1426.16 | 672.29 | |||
| SO69478_4 | E63C-4ABF-83 | PO18705185140 | 19 | 291 | 384 | 479 | 6 | 2024-08-23 | 1344.59 | 33.61 | 2024-08-11 | 2 | 713.08 | 1 | 1344.59 | 4 | SO69478 | 2024-08-18 | 107.57 | 1426.16 | 672.29 | |||
| SO71841_46 | 1544-4561-AB | PO1798133189 | 19 | 291 | 515 | 10 | 6 | 2024-09-23 | 65.09 | 1.63 | 2024-09-11 | 4 | 12.04 | 1 | 65.09 | 46 | SO71841 | 2024-09-18 | 5.21 | 48.17 | 16.27 | |||
| SO49085_8 | 7265-4D98-80 | PO19198152404 | 19 | 291 | 305 | 653 | 6 | 2023-05-26 | 2208.44 | 55.21 | 2023-05-14 | 3 | 653.70 | 1 | 2208.44 | 8 | SO49085 | 2023-05-21 | 176.67 | 1961.09 | 736.15 | |||
| SO53484_24 | CEC0-499D-80 | PO14790120337 | 19 | 291 | 542 | 497 | 6 | 2023-12-24 | 72.88 | 1.82 | 2023-12-12 | 3 | 17.98 | 1 | 72.88 | 24 | SO53484 | 2023-12-19 | 5.83 | 53.93 | 24.29 |
Generated 2024-11-10 12:27:22.414 UTC