[ROOT] dt FactResellerSale < WHERE DimSalesTerritoryId EQ ALL SHUFFLE < SKIP 625 > < 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 |
---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
SO47450_49 | 7E50-416D-A2 | PO9483124566 | 100 | 281 | 461 | 54 | 2 | 2022-11-19 | 215.98 | 5.40 | 2022-11-07 | 4 | 37.12 | 1 | 215.98 | 49 | SO47450 | 2022-11-14 | 17.28 | 148.48 | 53.99 | |||
SO57068_33 | 0E44-4044-B3 | PO11223190191 | 100 | 292 | 551 | 632 | 7 | 2024-01-19 | 316.86 | 7.92 | 2024-01-07 | 2 | 144.59 | 1 | 316.86 | 33 | SO57068 | 2024-01-14 | 25.35 | 289.19 | 158.43 | |||
SO57121_14 | A796-4C1D-A6 | PO5771187733 | 100 | 282 | 583 | 79 | 3 | 2024-01-19 | 1020.59 | 25.51 | 2024-01-07 | 1 | 1082.51 | 1 | 1020.59 | 14 | SO57121 | 2024-01-14 | 81.65 | 1082.51 | 1020.59 | |||
SO45321_2 | C4E4-4F04-B1 | PO3799119166 | 100 | 282 | 351 | 312 | 4 | 2022-04-21 | 2024.99 | 50.62 | 2022-04-09 | 1 | 1898.09 | 1 | 2024.99 | 2 | SO45321 | 2022-04-16 | 162.00 | 1898.09 | 2024.99 | |||
SO71847_12 | 3A74-467E-8B | PO18502143784 | 19 | 291 | 503 | 154 | 6 | 2024-08-19 | 200.05 | 5.00 | 2024-08-07 | 1 | 199.85 | 1 | 200.05 | 12 | SO71847 | 2024-08-14 | 16.00 | 199.85 | 200.05 | |||
SO45518_3 | 2F4B-4BB7-98 | PO20155192513 | 100 | 289 | 350 | 92 | 1 | 2022-05-19 | 2024.99 | 50.62 | 2022-05-07 | 1 | 1898.09 | 1 | 2024.99 | 3 | SO45518 | 2022-05-14 | 162.00 | 1898.09 | 2024.99 | |||
SO48295_46 | 12F9-466B-B0 | PO19343197973 | 100 | 282 | 466 | 24 | 4 | 2023-02-18 | 42.39 | 1.06 | 2023-02-06 | 3 | 9.71 | 1 | 42.39 | 46 | SO48295 | 2023-02-13 | 3.39 | 29.14 | 14.13 | |||
SO47377_33 | FA63-499A-AB | PO15515156459 | 100 | 292 | 343 | 481 | 7 | 2022-11-19 | 4697.94 | 117.45 | 2022-11-07 | 10 | 486.71 | 1 | 4697.94 | 33 | SO47377 | 2022-11-14 | 375.84 | 4867.07 | 469.79 | |||
SO48375_5 | B5F1-4C2A-94 | PO5597156214 | 100 | 283 | 364 | 75 | 4 | 2023-02-18 | 647.99 | 16.20 | 2023-02-06 | 1 | 598.44 | 1 | 647.99 | 5 | SO48375 | 2023-02-13 | 51.84 | 598.44 | 647.99 | |||
SO53527_18 | 0EBE-4ACB-B5 | PO1798140946 | 19 | 291 | 589 | 10 | 6 | 2023-11-19 | 923.39 | 23.08 | 2023-11-07 | 2 | 419.78 | 1 | 923.39 | 18 | SO53527 | 2023-11-14 | 73.87 | 839.56 | 461.69 | |||
SO50722_9 | 126E-410B-A5 | PO8468186428 | 98 | 290 | 370 | 16 | 10 | 2023-08-19 | 2932.02 | 73.30 | 2023-08-07 | 2 | 1518.79 | 1 | 2932.02 | 9 | SO50722 | 2023-08-14 | 234.56 | 3037.57 | 1466.01 | |||
SO43906_9 | BA78-4228-89 | PO6438197212 | 100 | 283 | 347 | 309 | 4 | 2021-10-19 | 6119.98 | 153.00 | 2021-10-07 | 3 | 1912.15 | 1 | 6119.98 | 9 | SO43906 | 2021-10-14 | 489.60 | 5736.46 | 2039.99 | |||
SO45321_8 | C4E4-4F04-B1 | PO3799119166 | 100 | 282 | 345 | 312 | 4 | 2022-04-21 | 8159.98 | 204.00 | 2022-04-09 | 4 | 1912.15 | 1 | 8159.98 | 8 | SO45321 | 2022-04-16 | 652.80 | 7648.62 | 2039.99 | |||
SO47354_3 | 6E1C-48C6-89 | PO19401144959 | 19 | 291 | 230 | 173 | 6 | 2022-11-19 | 28.84 | 0.72 | 2022-11-07 | 1 | 29.08 | 1 | 28.84 | 3 | SO47354 | 2022-11-14 | 2.31 | 29.08 | 28.84 | |||
SO53601_1 | B41F-4FBB-87 | PO3770165104 | 100 | 282 | 471 | 151 | 4 | 2023-11-19 | 114.30 | 2.86 | 2023-11-07 | 3 | 23.75 | 1 | 114.30 | 1 | SO53601 | 2023-11-14 | 9.14 | 71.25 | 38.10 | |||
SO47369_10 | B6B6-442B-8B | PO16472118462 | 100 | 287 | 257 | 239 | 4 | 2022-11-19 | 367.88 | 9.20 | 2022-11-07 | 2 | 170.14 | 1 | 367.88 | 10 | SO47369 | 2022-11-14 | 29.43 | 340.29 | 183.94 | |||
SO55311_15 | 2309-401E-BD | PO3509171799 | 36 | 292 | 545 | 139 | 7 | 2023-12-19 | 97.18 | 2.43 | 2023-12-07 | 4 | 17.98 | 1 | 97.18 | 15 | SO55311 | 2023-12-14 | 7.77 | 71.91 | 24.29 | |||
SO47416_37 | 6B45-44AB-84 | PO2813155355 | 100 | 281 | 461 | 90 | 5 | 2022-11-19 | 107.99 | 2.70 | 2022-11-07 | 2 | 37.12 | 1 | 107.99 | 37 | SO47416 | 2022-11-14 | 8.64 | 74.24 | 53.99 | |||
SO50280_3 | 7938-4E14-A7 | PO11658187917 | 100 | 283 | 358 | 233 | 2 | 2023-07-19 | 4917.84 | 122.95 | 2023-07-07 | 4 | 1105.81 | 1 | 4917.84 | 3 | SO50280 | 2023-07-14 | 393.43 | 4423.24 | 1229.46 | |||
SO58957_23 | 13BB-49DB-84 | PO10962177270 | 19 | 284 | 587 | 685 | 6 | 2024-02-18 | 1846.78 | 46.17 | 2024-02-06 | 4 | 419.78 | 1 | 1846.78 | 23 | SO58957 | 2024-02-13 | 147.74 | 1679.11 | 461.69 | |||
SO53525_16 | F162-4A87-B4 | PO1305155715 | 100 | 292 | 491 | 319 | 7 | 2023-11-19 | 64.79 | 1.62 | 2023-11-07 | 2 | 41.57 | 1 | 64.79 | 16 | SO53525 | 2023-11-14 | 5.18 | 83.14 | 32.39 | |||
SO48065_15 | 1B78-4DE6-BC | PO5771120852 | 100 | 282 | 331 | 79 | 3 | 2023-01-19 | 1409.38 | 35.23 | 2023-01-07 | 3 | 486.71 | 1 | 1409.38 | 15 | SO48065 | 2023-01-14 | 112.75 | 1460.12 | 469.79 | |||
SO47450_21 | 7E50-416D-A2 | PO9483124566 | 100 | 281 | 370 | 54 | 2 | 2022-11-19 | 4398.03 | 109.95 | 2022-11-07 | 3 | 1518.79 | 1 | 4398.03 | 21 | SO47450 | 2022-11-14 | 351.84 | 4556.36 | 1466.01 | |||
SO50226_42 | 75E5-4EFD-A7 | PO12499165634 | 100 | 282 | 325 | 78 | 4 | 2023-07-19 | 469.79 | 11.74 | 2023-07-07 | 1 | 486.71 | 1 | 469.79 | 42 | SO50226 | 2023-07-14 | 37.58 | 486.71 | 469.79 | |||
SO65199_20 | F8B4-4F74-87 | PO870111351 | 100 | 286 | 586 | 621 | 1 | 2024-05-19 | 2227.05 | 55.68 | 2024-05-07 | 5 | 461.44 | 1 | 2227.05 | 20 | SO65199 | 2024-05-14 | 178.16 | 2307.22 | 445.41 | |||
SO49888_25 | 01BB-49D0-BD | PO6699147895 | 100 | 283 | 414 | 234 | 2 | 2023-06-19 | 596.12 | 14.90 | 2023-06-07 | 4 | 110.28 | 1 | 596.12 | 25 | SO49888 | 2023-06-14 | 47.69 | 441.13 | 149.03 | |||
SO58979_16 | A35B-403A-A4 | PO18038174164 | 100 | 287 | 558 | 509 | 4 | 2024-02-18 | 242.99 | 6.07 | 2024-02-06 | 1 | 179.82 | 1 | 242.99 | 16 | SO58979 | 2024-02-13 | 19.44 | 179.82 | 242.99 | |||
SO61216_29 | B500-4250-B9 | PO13340173082 | 100 | 292 | 484 | 355 | 7 | 2024-03-20 | 14.31 | 0.36 | 2024-03-08 | 3 | 2.97 | 1 | 14.31 | 29 | SO61216 | 2024-03-15 | 1.14 | 8.92 | 4.77 | |||
SO46057_14 | 6F2B-45A4-9C | PO12499164653 | 100 | 282 | 338 | 78 | 4 | 2022-07-19 | 2516.75 | 62.92 | 2022-07-07 | 6 | 413.15 | 1 | 2516.75 | 14 | SO46057 | 2022-07-14 | 201.34 | 2478.88 | 419.46 | |||
SO55269_24 | C087-4A55-8D | PO899192335 | 100 | 289 | 546 | 290 | 1 | 2023-12-19 | 111.76 | 2.79 | 2023-12-07 | 3 | 27.57 | 1 | 111.76 | 24 | SO55269 | 2023-12-14 | 8.94 | 82.70 | 37.25 | |||
SO55322_29 | D600-436A-B7 | PO7859118281 | 100 | 287 | 434 | 221 | 4 | 2023-12-19 | 356.90 | 8.92 | 2023-12-07 | 1 | 360.94 | 1 | 356.90 | 29 | SO55322 | 2023-12-14 | 28.55 | 360.94 | 356.90 | |||
SO48069_17 | 60CF-43B6-82 | PO6438117188 | 100 | 283 | 236 | 309 | 4 | 2023-01-19 | 115.36 | 2.88 | 2023-01-07 | 4 | 29.08 | 1 | 115.36 | 17 | SO48069 | 2023-01-14 | 9.23 | 116.32 | 28.84 | |||
SO55265_8 | D45F-41FE-9B | PO10237157039 | 100 | 287 | 580 | 41 | 4 | 2023-12-19 | 4082.38 | 102.06 | 2023-12-07 | 4 | 1082.51 | 1 | 4082.38 | 8 | SO55265 | 2023-12-14 | 326.59 | 4330.04 | 1020.59 | |||
SO57067_16 | 08F2-42FC-BE | PO11368183380 | 36 | 295 | 601 | 687 | 8 | 2024-01-19 | 32.39 | 0.81 | 2024-01-07 | 1 | 23.97 | 1 | 32.39 | 16 | SO57067 | 2024-01-14 | 2.59 | 23.97 | 32.39 | |||
SO71836_20 | E41E-40C1-84 | PO841118259 | 100 | 286 | 542 | 254 | 1 | 2024-08-19 | 218.65 | 5.47 | 2024-08-07 | 9 | 17.98 | 1 | 218.65 | 20 | SO71836 | 2024-08-14 | 17.49 | 161.80 | 24.29 | |||
SO48084_2 | 6C3E-4F2C-A4 | PO8584164060 | 98 | 290 | 456 | 592 | 10 | 2023-01-19 | 44.99 | 1.12 | 2023-01-07 | 1 | 30.93 | 1 | 44.99 | 2 | SO48084 | 2023-01-14 | 3.60 | 30.93 | 44.99 | |||
SO44496_19 | 6ADA-4A25-AA | PO18415194469 | 19 | 288 | 319 | 191 | 6 | 2022-01-19 | 1749.59 | 43.74 | 2022-01-07 | 2 | 884.71 | 1 | 1749.59 | 19 | SO44496 | 2022-01-14 | 139.97 | 1769.42 | 874.79 | |||
SO44504_10 | CFE2-4C08-B0 | PO16733198490 | 19 | 288 | 270 | 533 | 6 | 2022-01-19 | 551.81 | 13.80 | 2022-01-07 | 3 | 181.49 | 1 | 551.81 | 10 | SO44504 | 2022-01-14 | 44.15 | 544.46 | 183.94 | |||
SO46649_10 | A093-4C86-B7 | PO2929149182 | 100 | 289 | 399 | 380 | 1 | 2022-09-18 | 67.55 | 1.69 | 2022-09-06 | 2 | 24.99 | 1 | 67.55 | 10 | SO46649 | 2022-09-13 | 5.40 | 49.99 | 33.77 | |||
SO55268_53 | 47E6-44B3-A4 | PO10324191521 | 98 | 288 | 465 | 2 | 196 | 10 | 3.41 | 2023-12-19 | 170.45 | 4.18 | 2023-12-07 | 12 | 9.16 | 1 | 167.04 | 53 | SO55268 | 2023-12-14 | 13.36 | 109.91 | 14.20 | 0.02 |
SO49485_6 | 9EA5-4DEF-B8 | PO17545171443 | 19 | 291 | 371 | 155 | 6 | 2023-05-19 | 7853.63 | 196.34 | 2023-05-07 | 6 | 1320.68 | 1 | 7853.63 | 6 | SO49485 | 2023-05-14 | 628.29 | 7924.10 | 1308.94 | |||
SO53551_3 | 8593-405C-AB | PO14297167079 | 100 | 285 | 493 | 627 | 5 | 2023-11-19 | 600.16 | 15.00 | 2023-11-07 | 3 | 199.85 | 1 | 600.16 | 3 | SO53551 | 2023-11-14 | 48.01 | 599.56 | 200.05 | |||
SO51169_12 | 995D-4C3D-86 | PO5452173982 | 36 | 295 | 484 | 320 | 8 | 2023-09-18 | 14.31 | 0.36 | 2023-09-06 | 3 | 2.97 | 1 | 14.31 | 12 | SO51169 | 2023-09-13 | 1.14 | 8.92 | 4.77 | |||
SO61211_19 | F16E-45D3-94 | PO13659160415 | 100 | 287 | 357 | 437 | 4 | 2024-03-20 | 6959.97 | 174.00 | 2024-03-08 | 5 | 1265.62 | 1 | 6959.97 | 19 | SO61211 | 2024-03-15 | 556.80 | 6328.10 | 1391.99 | |||
SO49869_22 | A2BD-4A89-93 | PO9657193666 | 100 | 285 | 236 | 315 | 5 | 2023-06-19 | 57.68 | 1.44 | 2023-06-07 | 2 | 29.08 | 1 | 57.68 | 22 | SO49869 | 2023-06-14 | 4.61 | 58.16 | 28.84 | |||
SO47034_36 | A5AA-46C3-92 | PO4843149248 | 100 | 287 | 327 | 9 | 257 | 4 | 281.88 | 2022-10-19 | 939.59 | 16.44 | 2022-10-07 | 4 | 486.71 | 1 | 657.71 | 36 | SO47034 | 2022-10-14 | 52.62 | 1946.83 | 234.90 | 0.30 |
SO46380_22 | C4E3-4894-81 | PO7569183330 | 100 | 287 | 232 | 608 | 4 | 2022-08-19 | 28.84 | 0.72 | 2022-08-07 | 1 | 31.72 | 1 | 28.84 | 22 | SO46380 | 2022-08-14 | 2.31 | 31.72 | 28.84 | |||
SO46972_21 | 1A21-419F-8D | PO14500164221 | 100 | 282 | 412 | 650 | 1 | 2022-10-19 | 180.13 | 4.50 | 2022-10-07 | 1 | 133.30 | 1 | 180.13 | 21 | SO46972 | 2022-10-14 | 14.41 | 133.30 | 180.13 | |||
SO45060_16 | 39B0-42BB-92 | PO10817172372 | 100 | 287 | 311 | 203 | 4 | 2022-03-21 | 4293.92 | 107.35 | 2022-03-09 | 2 | 2171.29 | 1 | 4293.92 | 16 | SO45060 | 2022-03-16 | 343.51 | 4342.59 | 2146.96 | |||
SO46057_1 | 6F2B-45A4-9C | PO12499164653 | 100 | 282 | 322 | 2 | 78 | 4 | 89.20 | 2022-07-19 | 4460.25 | 109.28 | 2022-07-07 | 11 | 413.15 | 1 | 4371.04 | 1 | SO46057 | 2022-07-14 | 349.68 | 4544.61 | 405.48 | 0.02 |
SO57012_17 | BE3B-4D30-A7 | PO580126740 | 36 | 295 | 564 | 2 | 230 | 8 | 304.21 | 2024-01-19 | 15210.37 | 372.65 | 2024-01-07 | 11 | 1481.94 | 1 | 14906.16 | 17 | SO57012 | 2024-01-14 | 1192.49 | 16301.32 | 1382.76 | 0.02 |
SO46971_7 | 5CEA-463B-A2 | PO15051144269 | 100 | 285 | 460 | 207 | 5 | 2022-10-19 | 53.99 | 1.35 | 2022-10-07 | 1 | 37.12 | 1 | 53.99 | 7 | SO46971 | 2022-10-14 | 4.32 | 37.12 | 53.99 | |||
SO69518_16 | 96AA-48F8-80 | PO5800191682 | 100 | 285 | 309 | 63 | 5 | 2024-07-19 | 2456.10 | 61.40 | 2024-07-07 | 3 | 747.20 | 1 | 2456.10 | 16 | SO69518 | 2024-07-14 | 196.49 | 2241.60 | 818.70 | |||
SO58976_12 | 3BF9-484F-A1 | PO20213146485 | 100 | 283 | 234 | 216 | 2 | 2024-02-18 | 59.99 | 1.50 | 2024-02-06 | 2 | 38.49 | 1 | 59.99 | 12 | SO58976 | 2024-02-13 | 4.80 | 76.98 | 29.99 | |||
SO50664_32 | 85F5-458B-8D | PO19401149024 | 19 | 291 | 335 | 173 | 6 | 2023-08-19 | 1409.38 | 35.23 | 2023-08-07 | 3 | 486.71 | 1 | 1409.38 | 32 | SO50664 | 2023-08-14 | 112.75 | 1460.12 | 469.79 | |||
SO55251_22 | 2481-4FF1-80 | PO13659159365 | 100 | 287 | 593 | 437 | 4 | 2023-12-19 | 338.99 | 8.47 | 2023-12-07 | 1 | 308.22 | 1 | 338.99 | 22 | SO55251 | 2023-12-14 | 27.12 | 308.22 | 338.99 | |||
SO69510_6 | 20D6-41A2-8F | PO5568198481 | 100 | 285 | 491 | 422 | 5 | 2024-07-19 | 64.79 | 1.62 | 2024-07-07 | 2 | 41.57 | 1 | 64.79 | 6 | SO69510 | 2024-07-14 | 5.18 | 83.14 | 32.39 | |||
SO69532_32 | 27FB-4A86-85 | PO3799165791 | 100 | 282 | 298 | 312 | 4 | 2024-07-19 | 809.76 | 20.24 | 2024-07-07 | 1 | 739.04 | 1 | 809.76 | 32 | SO69532 | 2024-07-14 | 64.78 | 739.04 | 809.76 | |||
SO50312_26 | 89ED-4505-8D | PO7424134798 | 100 | 283 | 356 | 642 | 2 | 2023-07-19 | 4971.41 | 124.29 | 2023-07-07 | 4 | 1117.86 | 1 | 4971.41 | 26 | SO50312 | 2023-07-14 | 397.71 | 4471.42 | 1242.85 | |||
SO51762_8 | E7DC-4AC1-AD | PO10121132749 | 100 | 283 | 482 | 684 | 2 | 2023-10-19 | 10.79 | 0.27 | 2023-10-07 | 2 | 3.36 | 1 | 10.79 | 8 | SO51762 | 2023-10-14 | 0.86 | 6.72 | 5.39 | |||
SO45298_5 | 7EEC-41A1-9E | PO13572147445 | 100 | 287 | 318 | 527 | 3 | 2022-04-21 | 1749.59 | 43.74 | 2022-04-09 | 2 | 884.71 | 1 | 1749.59 | 5 | SO45298 | 2022-04-16 | 139.97 | 1769.42 | 874.79 | |||
SO59038_5 | 708F-4F1E-84 | PO4321187546 | 36 | 295 | 477 | 104 | 8 | 2024-02-18 | 11.98 | 0.30 | 2024-02-06 | 4 | 1.87 | 1 | 11.98 | 5 | SO59038 | 2024-02-13 | 0.96 | 7.47 | 2.99 |
Generated 2024-10-06 16:38:15.403 UTC