[ROOT] dt FactResellerSale WHERE DimSalesTerritoryId EQ '1' > SKIP 0 SHUFFLE < SKIP 1062 > < 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 |
---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
SO46105_30 | 2590-40A7-BB | PO8816169858 | 100 | 289 | 328 | 218 | 1 | 2022-07-02 | 1258.38 | 31.46 | 2022-06-20 | 3 | 413.15 | 1 | 1258.38 | 30 | SO46105 | 2022-06-27 | 100.67 | 1239.44 | 419.46 | |||
SO46100_14 | 58B8-4157-97 | PO7627134166 | 100 | 286 | 232 | 433 | 1 | 2022-07-02 | 28.84 | 0.72 | 2022-06-20 | 1 | 31.72 | 1 | 28.84 | 14 | SO46100 | 2022-06-27 | 2.31 | 31.72 | 28.84 | |||
SO71785_1 | 28F9-4101-A1 | PO19169115427 | 100 | 289 | 532 | 272 | 1 | 2024-08-02 | 449.62 | 11.24 | 2024-07-21 | 3 | 136.79 | 1 | 449.62 | 1 | SO71785 | 2024-07-28 | 35.97 | 410.36 | 149.87 | |||
SO57036_13 | A71E-4FC0-8D | PO15631137127 | 100 | 282 | 309 | 43 | 1 | 2024-01-02 | 3274.80 | 81.87 | 2023-12-21 | 4 | 747.20 | 1 | 3274.80 | 13 | SO57036 | 2023-12-28 | 261.98 | 2988.80 | 818.70 | |||
SO50241_2 | ACB7-4116-A8 | PO18908114626 | 100 | 289 | 468 | 164 | 1 | 2023-07-02 | 45.59 | 1.14 | 2023-06-20 | 2 | 15.67 | 1 | 45.59 | 2 | SO50241 | 2023-06-27 | 3.65 | 31.34 | 22.79 | |||
SO49826_29 | 2EBD-4312-9C | PO16588178669 | 100 | 289 | 365 | 146 | 1 | 2023-06-02 | 4535.96 | 113.40 | 2023-05-21 | 7 | 598.44 | 1 | 4535.96 | 29 | SO49826 | 2023-05-28 | 362.88 | 4189.05 | 647.99 | |||
SO47443_2 | DDB8-4FAB-92 | PO7192110823 | 100 | 289 | 410 | 20 | 1 | 2022-11-02 | 109.34 | 2.73 | 2022-10-21 | 3 | 26.97 | 1 | 109.34 | 2 | SO47443 | 2022-10-28 | 8.75 | 80.91 | 36.45 | |||
SO49161_17 | 0377-44E6-AA | PO7627157444 | 100 | 293 | 385 | 433 | 1 | 2023-04-04 | 600.26 | 15.01 | 2023-03-23 | 1 | 605.65 | 1 | 600.26 | 17 | SO49161 | 2023-03-30 | 48.02 | 605.65 | 600.26 | |||
SO59010_41 | 2350-42CD-B1 | PO6815132533 | 100 | 293 | 515 | 109 | 1 | 2024-02-01 | 48.82 | 1.22 | 2024-01-20 | 3 | 12.04 | 1 | 48.82 | 41 | SO59010 | 2024-01-27 | 3.91 | 36.12 | 16.27 | |||
SO46957_45 | C98D-43A5-8A | PO16414179284 | 100 | 289 | 365 | 236 | 1 | 2022-10-02 | 5831.95 | 145.80 | 2022-09-20 | 9 | 598.44 | 1 | 5831.95 | 45 | SO46957 | 2022-09-27 | 466.56 | 5385.92 | 647.99 | |||
SO51164_7 | 595F-419D-AD | PO1421153638 | 100 | 293 | 474 | 325 | 1 | 2023-09-01 | 125.98 | 3.15 | 2023-08-20 | 3 | 26.18 | 1 | 125.98 | 7 | SO51164 | 2023-08-27 | 10.08 | 78.53 | 41.99 | |||
SO46647_7 | FA5F-4878-9F | PO2552157860 | 100 | 286 | 456 | 506 | 1 | 2022-09-01 | 224.97 | 5.62 | 2022-08-20 | 5 | 30.93 | 1 | 224.97 | 7 | SO46647 | 2022-08-27 | 18.00 | 154.67 | 44.99 | |||
SO53457_4 | B3F3-4A07-9B | PO19169151555 | 100 | 289 | 298 | 272 | 1 | 2023-11-02 | 1619.52 | 40.49 | 2023-10-21 | 2 | 739.04 | 1 | 1619.52 | 4 | SO53457 | 2023-10-28 | 129.56 | 1478.08 | 809.76 | |||
SO69475_28 | F74A-4967-BA | PO18618162557 | 100 | 286 | 561 | 605 | 1 | 2024-07-02 | 4291.33 | 107.28 | 2024-06-20 | 3 | 1481.94 | 1 | 4291.33 | 28 | SO69475 | 2024-06-27 | 343.31 | 4445.81 | 1430.44 | |||
SO63202_9 | 5C83-47EE-AA | PO15631193825 | 100 | 282 | 593 | 43 | 1 | 2024-04-03 | 677.99 | 16.95 | 2024-03-22 | 2 | 308.22 | 1 | 677.99 | 9 | SO63202 | 2024-03-29 | 54.24 | 616.44 | 338.99 | |||
SO47991_15 | 0F2E-4E6D-8E | PO15631116034 | 100 | 282 | 470 | 2 | 43 | 1 | 5.29 | 2023-01-02 | 264.41 | 6.48 | 2022-12-21 | 12 | 15.67 | 1 | 259.12 | 15 | SO47991 | 2022-12-28 | 20.73 | 188.05 | 22.03 | 0.02 |
SO51726_2 | 9BC5-4281-AF | PO14587157005 | 100 | 293 | 492 | 199 | 1 | 2023-10-02 | 2409.38 | 60.23 | 2023-09-20 | 4 | 601.74 | 1 | 2409.38 | 2 | SO51726 | 2023-09-27 | 192.75 | 2406.97 | 602.35 | |||
SO47036_1 | 7EED-4436-B5 | PO5046113427 | 100 | 289 | 354 | 596 | 1 | 2022-10-02 | 2485.70 | 62.14 | 2022-09-20 | 2 | 1117.86 | 1 | 2485.70 | 1 | SO47036 | 2022-09-27 | 198.86 | 2235.71 | 1242.85 | |||
SO45783_6 | AD5D-4FF2-82 | PO16617161291 | 100 | 286 | 350 | 397 | 1 | 2022-06-02 | 8099.98 | 202.50 | 2022-05-21 | 4 | 1898.09 | 1 | 8099.98 | 6 | SO45783 | 2022-05-28 | 648.00 | 7592.38 | 2024.99 | |||
SO44570_22 | 4132-4AE3-99 | PO8816195785 | 100 | 289 | 212 | 218 | 1 | 2022-01-02 | 80.75 | 2.02 | 2021-12-21 | 4 | 12.03 | 1 | 80.75 | 22 | SO44570 | 2021-12-28 | 6.46 | 48.11 | 20.19 | |||
SO48381_5 | C4B2-44F3-BF | PO7192163873 | 100 | 289 | 354 | 20 | 1 | 2023-02-01 | 1242.85 | 31.07 | 2023-01-20 | 1 | 1117.86 | 1 | 1242.85 | 5 | SO48381 | 2023-01-27 | 99.43 | 1117.86 | 1242.85 | |||
SO50314_18 | 5D9A-4B55-81 | PO7627146177 | 100 | 293 | 263 | 433 | 1 | 2023-07-02 | 404.66 | 10.12 | 2023-06-20 | 2 | 187.16 | 1 | 404.66 | 18 | SO50314 | 2023-06-27 | 32.37 | 374.31 | 202.33 | |||
SO46957_30 | C98D-43A5-8A | PO16414179284 | 100 | 289 | 401 | 236 | 1 | 2022-10-02 | 196.81 | 4.92 | 2022-09-20 | 3 | 48.55 | 1 | 196.81 | 30 | SO46957 | 2022-09-27 | 15.74 | 145.64 | 65.60 | |||
SO47033_1 | 2797-46ED-BB | PO4727113716 | 100 | 286 | 403 | 343 | 1 | 2022-10-02 | 72.88 | 1.82 | 2022-09-20 | 3 | 17.98 | 1 | 72.88 | 1 | SO47033 | 2022-09-27 | 5.83 | 53.93 | 24.29 | |||
SO59066_20 | 9FAA-410F-AB | PO9309141643 | 100 | 293 | 499 | 55 | 1 | 2024-02-01 | 602.35 | 15.06 | 2024-01-20 | 1 | 601.74 | 1 | 602.35 | 20 | SO59066 | 2024-01-27 | 48.19 | 601.74 | 602.35 | |||
SO51838_4 | 8AB1-478C-86 | PO4727199391 | 100 | 293 | 372 | 343 | 1 | 2023-10-02 | 4398.03 | 109.95 | 2023-09-20 | 3 | 1554.95 | 1 | 4398.03 | 4 | SO51838 | 2023-09-27 | 351.84 | 4664.84 | 1466.01 | |||
SO47033_48 | 2797-46ED-BB | PO4727113716 | 100 | 286 | 373 | 343 | 1 | 2022-10-02 | 2617.88 | 65.45 | 2022-09-20 | 2 | 1320.68 | 1 | 2617.88 | 48 | SO47033 | 2022-09-27 | 209.43 | 2641.37 | 1308.94 | |||
SO71904_6 | DBF0-4665-A7 | PO5017189568 | 100 | 289 | 569 | 308 | 1 | 2024-08-02 | 2227.05 | 55.68 | 2024-07-21 | 5 | 461.44 | 1 | 2227.05 | 6 | SO71904 | 2024-07-28 | 178.16 | 2307.22 | 445.41 | |||
SO43917_6 | 9EDA-4CDB-A8 | PO8816199739 | 100 | 289 | 220 | 218 | 1 | 2021-10-02 | 60.56 | 1.51 | 2021-09-20 | 3 | 12.03 | 1 | 60.56 | 6 | SO43917 | 2021-09-27 | 4.84 | 36.08 | 20.19 | |||
SO44743_8 | F9C5-4063-B1 | PO19169113389 | 100 | 289 | 346 | 272 | 1 | 2022-02-01 | 6119.98 | 153.00 | 2022-01-20 | 3 | 1912.15 | 1 | 6119.98 | 8 | SO44743 | 2022-01-27 | 489.60 | 5736.46 | 2039.99 | |||
SO50209_13 | D138-4E7C-86 | PO15573136083 | 100 | 293 | 362 | 487 | 1 | 2023-07-02 | 3688.38 | 92.21 | 2023-06-20 | 3 | 1105.81 | 1 | 3688.38 | 13 | SO50209 | 2023-06-27 | 295.07 | 3317.43 | 1229.46 | |||
SO53576_4 | 7638-4151-96 | PO7395119515 | 100 | 286 | 593 | 542 | 1 | 2023-11-02 | 677.99 | 16.95 | 2023-10-21 | 2 | 308.22 | 1 | 677.99 | 4 | SO53576 | 2023-10-28 | 54.24 | 616.44 | 338.99 | |||
SO71790_1 | 4C33-40F1-BC | PO17487184338 | 100 | 293 | 471 | 692 | 1 | 2024-08-02 | 114.30 | 2.86 | 2024-07-21 | 3 | 23.75 | 1 | 114.30 | 1 | SO71790 | 2024-07-28 | 9.14 | 71.25 | 38.10 | |||
SO48326_3 | C7D9-4798-BF | PO14065114327 | 100 | 293 | 265 | 379 | 1 | 2023-02-01 | 202.33 | 5.06 | 2023-01-20 | 1 | 187.16 | 1 | 202.33 | 3 | SO48326 | 2023-01-27 | 16.19 | 187.16 | 202.33 | |||
SO47403_23 | 60A2-4F08-8B | PO841143108 | 100 | 286 | 395 | 254 | 1 | 2022-11-02 | 368.24 | 9.21 | 2022-10-21 | 6 | 45.42 | 1 | 368.24 | 23 | SO47403 | 2022-10-28 | 29.46 | 272.50 | 61.37 | |||
SO47997_3 | 2B6D-4DAC-9A | PO14558139554 | 100 | 289 | 469 | 2 | 1 | 2023-01-02 | 45.59 | 1.14 | 2022-12-21 | 2 | 15.67 | 1 | 45.59 | 3 | SO47997 | 2022-12-28 | 3.65 | 31.34 | 22.79 | |||
SO47367_16 | 7C51-451A-B4 | PO17139175308 | 100 | 286 | 280 | 644 | 1 | 2022-11-02 | 367.88 | 9.20 | 2022-10-21 | 2 | 170.14 | 1 | 367.88 | 16 | SO47367 | 2022-10-28 | 29.43 | 340.29 | 183.94 | |||
SO48057_22 | 53D7-4BA4-AB | PO4727174880 | 100 | 293 | 329 | 343 | 1 | 2023-01-02 | 939.59 | 23.49 | 2022-12-21 | 2 | 486.71 | 1 | 939.59 | 22 | SO48057 | 2022-12-28 | 75.17 | 973.41 | 469.79 | |||
SO50718_2 | 21A7-4A53-A7 | PO14152142093 | 100 | 293 | 375 | 37 | 1 | 2023-08-02 | 1308.94 | 32.72 | 2023-07-21 | 1 | 1320.68 | 1 | 1308.94 | 2 | SO50718 | 2023-07-28 | 104.72 | 1320.68 | 1308.94 | |||
SO50270_1 | A828-45A2-8B | PO18676112371 | 100 | 282 | 354 | 697 | 1 | 2023-07-02 | 11185.67 | 279.64 | 2023-06-20 | 9 | 1117.86 | 1 | 11185.67 | 1 | SO50270 | 2023-06-27 | 894.85 | 10060.70 | 1242.85 | |||
SO47403_25 | 60A2-4F08-8B | PO841143108 | 100 | 286 | 391 | 254 | 1 | 2022-11-02 | 266.80 | 6.67 | 2022-10-21 | 3 | 65.81 | 1 | 266.80 | 25 | SO47403 | 2022-10-28 | 21.34 | 197.43 | 88.93 | |||
SO46611_8 | 93A4-4A4D-99 | PO16588117269 | 100 | 289 | 230 | 146 | 1 | 2022-09-01 | 57.68 | 1.44 | 2022-08-20 | 2 | 29.08 | 1 | 57.68 | 8 | SO46611 | 2022-08-27 | 4.61 | 58.16 | 28.84 | |||
SO50216_4 | 5648-4FA8-B5 | PO14558158414 | 100 | 289 | 468 | 2 | 1 | 2023-07-02 | 45.59 | 1.14 | 2023-06-20 | 2 | 15.67 | 1 | 45.59 | 4 | SO50216 | 2023-06-27 | 3.65 | 31.34 | 22.79 | |||
SO46356_26 | 30BA-40DA-B4 | PO783139385 | 100 | 286 | 312 | 91 | 1 | 2022-08-02 | 8587.85 | 214.70 | 2022-07-21 | 4 | 2171.29 | 1 | 8587.85 | 26 | SO46356 | 2022-07-28 | 687.03 | 8685.18 | 2146.96 | |||
SO46967_4 | 6486-4AF8-A6 | PO15573116583 | 100 | 286 | 308 | 487 | 1 | 2022-10-02 | 3721.36 | 93.03 | 2022-09-20 | 5 | 660.91 | 1 | 3721.36 | 4 | SO46967 | 2022-09-27 | 297.71 | 3304.57 | 744.27 | |||
SO43671_3 | DFD9-41B7-94 | PO13978119376 | 100 | 289 | 317 | 200 | 1 | 2021-09-01 | 874.79 | 21.87 | 2021-08-20 | 1 | 884.71 | 1 | 874.79 | 3 | SO43671 | 2021-08-27 | 69.98 | 884.71 | 874.79 | |||
SO47403_20 | 60A2-4F08-8B | PO841143108 | 100 | 286 | 401 | 254 | 1 | 2022-11-02 | 131.20 | 3.28 | 2022-10-21 | 2 | 48.55 | 1 | 131.20 | 20 | SO47403 | 2022-10-28 | 10.50 | 97.09 | 65.60 | |||
SO71785_26 | 28F9-4101-A1 | PO19169115427 | 100 | 289 | 476 | 272 | 1 | 2024-08-02 | 377.95 | 9.45 | 2024-07-21 | 9 | 26.18 | 1 | 377.95 | 26 | SO71785 | 2024-07-28 | 30.24 | 235.59 | 41.99 | |||
SO57030_47 | 373C-4C0F-88 | PO16414180321 | 100 | 289 | 295 | 236 | 1 | 2024-01-02 | 4093.50 | 102.34 | 2023-12-21 | 5 | 747.20 | 1 | 4093.50 | 47 | SO57030 | 2023-12-28 | 327.48 | 3736.00 | 818.70 | |||
SO51127_15 | D321-4FEA-80 | PO2552155165 | 100 | 286 | 513 | 506 | 1 | 2023-09-01 | 218.45 | 5.46 | 2023-08-20 | 1 | 199.38 | 1 | 218.45 | 15 | SO51127 | 2023-08-27 | 17.48 | 199.38 | 218.45 | |||
SO47698_11 | 3841-4995-8C | PO2552129685 | 100 | 286 | 224 | 506 | 1 | 2022-12-02 | 31.12 | 0.78 | 2022-11-20 | 6 | 5.23 | 1 | 31.12 | 11 | SO47698 | 2022-11-27 | 2.49 | 31.38 | 5.19 | |||
SO47666_2 | 6551-4B29-BF | PO16588184420 | 100 | 289 | 366 | 146 | 1 | 2022-12-02 | 4535.96 | 113.40 | 2022-11-20 | 7 | 598.44 | 1 | 4535.96 | 2 | SO47666 | 2022-11-27 | 362.88 | 4189.05 | 647.99 | |||
SO71835_36 | EBBF-4B16-99 | PO870120974 | 100 | 286 | 571 | 621 | 1 | 2024-08-02 | 1336.23 | 33.41 | 2024-07-21 | 3 | 461.44 | 1 | 1336.23 | 36 | SO71835 | 2024-07-28 | 106.90 | 1384.33 | 445.41 | |||
SO63224_4 | 668F-4A18-A0 | PO7627111844 | 100 | 293 | 471 | 433 | 1 | 2024-04-03 | 38.10 | 0.95 | 2024-03-22 | 1 | 23.75 | 1 | 38.10 | 4 | SO63224 | 2024-03-29 | 3.05 | 23.75 | 38.10 | |||
SO53514_11 | 8580-40F8-81 | PO10411179199 | 100 | 289 | 559 | 182 | 1 | 2023-11-02 | 97.15 | 2.43 | 2023-10-21 | 8 | 8.99 | 1 | 97.15 | 11 | SO53514 | 2023-10-28 | 7.77 | 71.89 | 12.14 | |||
SO69508_6 | 387A-4EC2-A7 | PO7627176234 | 100 | 293 | 390 | 433 | 1 | 2024-07-02 | 2689.18 | 67.23 | 2024-06-20 | 4 | 713.08 | 1 | 2689.18 | 6 | SO69508 | 2024-06-27 | 215.13 | 2852.32 | 672.29 | |||
SO65255_19 | D40C-4F32-BB | PO7482156945 | 100 | 293 | 492 | 163 | 1 | 2024-05-02 | 1204.69 | 30.12 | 2024-04-20 | 2 | 601.74 | 1 | 1204.69 | 19 | SO65255 | 2024-04-27 | 96.38 | 1203.49 | 602.35 | |||
SO69422_5 | BF3A-4F54-82 | PO14500139823 | 100 | 282 | 234 | 2 | 650 | 1 | 6.96 | 2024-07-02 | 347.93 | 8.52 | 2024-06-20 | 12 | 38.49 | 1 | 340.97 | 5 | SO69422 | 2024-06-27 | 27.28 | 461.91 | 28.99 | 0.02 |
SO46100_7 | 58B8-4157-97 | PO7627134166 | 100 | 286 | 342 | 433 | 1 | 2022-07-02 | 1258.38 | 31.46 | 2022-06-20 | 3 | 413.15 | 1 | 1258.38 | 7 | SO46100 | 2022-06-27 | 100.67 | 1239.44 | 419.46 | |||
SO55284_3 | DE78-41C8-9F | PO16443112174 | 100 | 289 | 217 | 398 | 1 | 2023-12-02 | 20.99 | 0.52 | 2023-11-20 | 1 | 13.09 | 1 | 20.99 | 3 | SO55284 | 2023-11-27 | 1.68 | 13.09 | 20.99 | |||
SO65252_15 | F817-49F6-A9 | PO12470159616 | 100 | 287 | 500 | 672 | 1 | 2024-05-02 | 1204.69 | 30.12 | 2024-04-20 | 2 | 601.74 | 1 | 1204.69 | 15 | SO65252 | 2024-04-27 | 96.38 | 1203.49 | 602.35 | |||
SO53576_13 | 7638-4151-96 | PO7395119515 | 100 | 286 | 516 | 542 | 1 | 2023-11-02 | 70.45 | 1.76 | 2023-10-21 | 3 | 17.38 | 1 | 70.45 | 13 | SO53576 | 2023-10-28 | 5.64 | 52.13 | 23.48 |
Generated 2024-09-19 20:49:10.827 UTC