[ROOT] dt FactResellerSale < WHERE DimSalesTerritoryId EQ ALL SHUFFLE < SKIP 749 > < TAKE 48 >
48 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 |
---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
SO53562_18 | 9FC2-4D08-A7 | PO8468156175 | 98 | 288 | 434 | 16 | 10 | 2023-12-24 | 1070.69 | 26.77 | 2023-12-12 | 3 | 360.94 | 1 | 1070.69 | 18 | SO53562 | 2023-12-19 | 85.66 | 1082.83 | 356.90 | |||
SO67316_55 | 6F7E-4455-9E | PO4495115494 | 19 | 291 | 544 | 496 | 6 | 2024-07-24 | 97.19 | 2.43 | 2024-07-12 | 2 | 35.96 | 1 | 97.19 | 55 | SO67316 | 2024-07-19 | 7.78 | 71.92 | 48.59 | |||
SO71858_5 | 32BA-49C8-8B | PO16153112278 | 100 | 282 | 490 | 186 | 4 | 2024-09-23 | 64.79 | 1.62 | 2024-09-11 | 2 | 41.57 | 1 | 64.79 | 5 | SO71858 | 2024-09-18 | 5.18 | 83.14 | 32.39 | |||
SO44120_13 | E001-437D-A1 | PO5597155510 | 100 | 283 | 220 | 75 | 4 | 2021-12-24 | 20.19 | 0.50 | 2021-12-12 | 1 | 12.03 | 1 | 20.19 | 13 | SO44120 | 2021-12-19 | 1.61 | 12.03 | 20.19 | |||
SO46671_21 | 13F6-4858-8D | PO8787194061 | 100 | 282 | 445 | 523 | 3 | 2022-10-23 | 71.99 | 1.80 | 2022-10-11 | 2 | 24.75 | 1 | 71.99 | 21 | SO46671 | 2022-10-18 | 5.76 | 49.49 | 35.99 | |||
SO61263_30 | 729E-4D96-91 | PO5452121402 | 36 | 295 | 568 | 320 | 8 | 2024-04-24 | 890.82 | 22.27 | 2024-04-12 | 2 | 461.44 | 1 | 890.82 | 30 | SO61263 | 2024-04-19 | 71.27 | 922.89 | 445.41 | |||
SO59010_40 | 2350-42CD-B1 | PO6815132533 | 100 | 293 | 525 | 109 | 1 | 2024-03-24 | 633.72 | 15.84 | 2024-03-12 | 4 | 144.59 | 1 | 633.72 | 40 | SO59010 | 2024-03-19 | 50.70 | 578.38 | 158.43 | |||
SO47422_18 | 9D8D-4481-B6 | PO3915123127 | 100 | 283 | 373 | 130 | 4 | 2022-12-24 | 1308.94 | 32.72 | 2022-12-12 | 1 | 1320.68 | 1 | 1308.94 | 18 | SO47422 | 2022-12-19 | 104.72 | 1320.68 | 1308.94 | |||
SO71882_8 | D5D4-42D4-91 | PO5597123008 | 100 | 281 | 595 | 16 | 75 | 4 | 90.40 | 2024-09-23 | 226.00 | 3.39 | 2024-09-11 | 2 | 308.22 | 1 | 135.60 | 8 | SO71882 | 2024-09-18 | 10.85 | 616.44 | 113.00 | 0.40 |
SO45794_4 | 945F-4477-83 | PO12760191318 | 19 | 288 | 326 | 83 | 6 | 2022-07-24 | 1258.38 | 31.46 | 2022-07-12 | 3 | 413.15 | 1 | 1258.38 | 4 | SO45794 | 2022-07-19 | 100.67 | 1239.44 | 419.46 | |||
SO49040_17 | 6653-43A9-8D | PO19923195099 | 100 | 283 | 308 | 18 | 3 | 2023-05-26 | 1488.55 | 37.21 | 2023-05-14 | 2 | 660.91 | 1 | 1488.55 | 17 | SO49040 | 2023-05-21 | 119.08 | 1321.83 | 744.27 | |||
SO57043_4 | F448-4B5D-89 | PO15080130371 | 100 | 292 | 555 | 283 | 7 | 2024-02-23 | 63.90 | 1.60 | 2024-02-11 | 1 | 47.29 | 1 | 63.90 | 4 | SO57043 | 2024-02-18 | 5.11 | 47.29 | 63.90 | |||
SO48293_5 | 85D2-4CB9-A6 | PO19604177614 | 98 | 288 | 399 | 340 | 10 | 2023-03-25 | 33.77 | 0.84 | 2023-03-13 | 1 | 24.99 | 1 | 33.77 | 5 | SO48293 | 2023-03-20 | 2.70 | 24.99 | 33.77 | |||
SO65269_7 | 999D-45C9-AA | PO4640162431 | 100 | 287 | 588 | 648 | 4 | 2024-06-23 | 1385.08 | 34.63 | 2024-06-11 | 3 | 419.78 | 1 | 1385.08 | 7 | SO65269 | 2024-06-18 | 110.81 | 1259.34 | 461.69 | |||
SO47377_11 | FA63-499A-AB | PO15515156459 | 100 | 292 | 286 | 481 | 7 | 2022-12-24 | 735.75 | 18.39 | 2022-12-12 | 4 | 170.14 | 1 | 735.75 | 11 | SO47377 | 2022-12-19 | 58.86 | 680.57 | 183.94 | |||
SO47006_20 | 142D-4F23-BF | PO957186440 | 98 | 288 | 409 | 376 | 10 | 2022-11-23 | 209.26 | 5.23 | 2022-11-11 | 1 | 185.82 | 1 | 209.26 | 20 | SO47006 | 2022-11-18 | 16.74 | 185.82 | 209.26 | |||
SO71828_12 | 73A0-490C-B1 | PO11194153355 | 19 | 284 | 579 | 48 | 6 | 2024-09-23 | 2915.64 | 72.89 | 2024-09-11 | 4 | 755.15 | 1 | 2915.64 | 12 | SO71828 | 2024-09-18 | 233.25 | 3020.60 | 728.91 | |||
SO51714_31 | D33A-4EAE-B1 | PO15689195197 | 100 | 281 | 490 | 328 | 4 | 2023-11-23 | 32.39 | 0.81 | 2023-11-11 | 1 | 41.57 | 1 | 32.39 | 31 | SO51714 | 2023-11-18 | 2.59 | 41.57 | 32.39 | |||
SO49498_26 | D9E7-4090-86 | PO16472151816 | 100 | 287 | 327 | 239 | 4 | 2023-06-23 | 4697.94 | 117.45 | 2023-06-11 | 10 | 486.71 | 1 | 4697.94 | 26 | SO49498 | 2023-06-18 | 375.84 | 4867.07 | 469.79 | |||
SO44559_13 | 8618-4A1B-AD | PO6641148111 | 100 | 281 | 253 | 342 | 2 | 2022-02-23 | 357.16 | 8.93 | 2022-02-11 | 2 | 176.20 | 1 | 357.16 | 13 | SO44559 | 2022-02-18 | 28.57 | 352.40 | 178.58 | |||
SO51817_2 | 244D-4F94-89 | PO8149119969 | 36 | 295 | 418 | 615 | 8 | 2023-11-23 | 356.90 | 8.92 | 2023-11-11 | 1 | 360.94 | 1 | 356.90 | 2 | SO51817 | 2023-11-18 | 28.55 | 360.94 | 356.90 | |||
SO71844_28 | 410D-4079-9E | PO2813198985 | 100 | 283 | 483 | 2 | 90 | 5 | 19.49 | 2024-09-23 | 974.40 | 23.87 | 2024-09-11 | 14 | 44.88 | 1 | 954.91 | 28 | SO71844 | 2024-09-18 | 76.39 | 628.32 | 69.60 | 0.02 |
SO51124_38 | 5EEF-4271-BB | PO1711177181 | 19 | 291 | 531 | 245 | 6 | 2023-10-23 | 1049.12 | 26.23 | 2023-10-11 | 7 | 136.79 | 1 | 1049.12 | 38 | SO51124 | 2023-10-18 | 83.93 | 957.50 | 149.87 | |||
SO48057_18 | 53D7-4BA4-AB | PO4727174880 | 100 | 293 | 233 | 343 | 1 | 2023-02-23 | 144.20 | 3.61 | 2023-02-11 | 5 | 29.08 | 1 | 144.20 | 18 | SO48057 | 2023-02-18 | 11.54 | 145.40 | 28.84 | |||
SO58918_54 | C811-4D40-80 | PO17574131484 | 19 | 291 | 531 | 678 | 6 | 2024-03-24 | 449.62 | 11.24 | 2024-03-12 | 3 | 136.79 | 1 | 449.62 | 54 | SO58918 | 2024-03-19 | 35.97 | 410.36 | 149.87 | |||
SO50693_44 | 0DA5-4EE4-93 | PO841149385 | 100 | 286 | 460 | 254 | 1 | 2023-09-23 | 269.97 | 6.75 | 2023-09-11 | 5 | 37.12 | 1 | 269.97 | 44 | SO50693 | 2023-09-18 | 21.60 | 185.60 | 53.99 | |||
SO53455_3 | ACD7-4AF3-84 | PO19604185529 | 98 | 288 | 309 | 340 | 10 | 2023-12-24 | 818.70 | 20.47 | 2023-12-12 | 1 | 747.20 | 1 | 818.70 | 3 | SO53455 | 2023-12-19 | 65.50 | 747.20 | 818.70 | |||
SO69552_2 | 542B-4AC0-BA | PO7917166419 | 100 | 287 | 359 | 401 | 1 | 2024-08-23 | 4130.98 | 103.27 | 2024-08-11 | 3 | 1251.98 | 1 | 4130.98 | 2 | SO69552 | 2024-08-18 | 330.48 | 3755.94 | 1376.99 | |||
SO53573_29 | F674-4899-B9 | PO8671117198 | 98 | 288 | 532 | 502 | 10 | 2023-12-24 | 299.75 | 7.49 | 2023-12-12 | 2 | 136.79 | 1 | 299.75 | 29 | SO53573 | 2023-12-19 | 23.98 | 273.57 | 149.87 | |||
SO47354_42 | 6E1C-48C6-89 | PO19401144959 | 19 | 291 | 417 | 173 | 6 | 2022-12-24 | 324.45 | 8.11 | 2022-12-12 | 1 | 300.12 | 1 | 324.45 | 42 | SO47354 | 2022-12-19 | 25.96 | 300.12 | 324.45 | |||
SO48396_19 | F55B-45AE-8B | PO9715142000 | 100 | 283 | 289 | 490 | 4 | 2023-03-25 | 2232.82 | 55.82 | 2023-03-13 | 3 | 660.91 | 1 | 2232.82 | 19 | SO48396 | 2023-03-20 | 178.63 | 1982.74 | 744.27 | |||
SO69503_22 | 559D-4568-82 | PO5771124379 | 100 | 282 | 581 | 79 | 3 | 2024-08-23 | 3061.78 | 76.54 | 2024-08-11 | 3 | 1082.51 | 1 | 3061.78 | 22 | SO69503 | 2024-08-18 | 244.94 | 3247.53 | 1020.59 | |||
SO51123_22 | E412-45DF-AE | PO899150137 | 100 | 289 | 477 | 2 | 290 | 1 | 0.69 | 2023-10-23 | 34.73 | 0.85 | 2023-10-11 | 12 | 1.87 | 1 | 34.04 | 22 | SO51123 | 2023-10-18 | 2.72 | 22.40 | 2.89 | 0.02 |
SO44561_9 | C323-4470-8B | PO7221158411 | 100 | 289 | 349 | 326 | 1 | 2022-02-23 | 10124.97 | 253.12 | 2022-02-11 | 5 | 1898.09 | 1 | 10124.97 | 9 | SO44561 | 2022-02-18 | 810.00 | 9490.47 | 2024.99 | |||
SO57154_30 | 464B-46A4-B6 | PO1856185040 | 19 | 291 | 471 | 2 | 263 | 6 | 10.31 | 2024-02-23 | 515.62 | 12.63 | 2024-02-11 | 14 | 23.75 | 1 | 505.31 | 30 | SO57154 | 2024-02-18 | 40.42 | 332.49 | 36.83 | 0.02 |
SO51081_6 | EDBF-4FE1-8F | PO522116846 | 100 | 285 | 593 | 676 | 5 | 2023-10-23 | 677.99 | 16.95 | 2023-10-11 | 2 | 308.22 | 1 | 677.99 | 6 | SO51081 | 2023-10-18 | 54.24 | 616.44 | 338.99 | |||
SO46977_4 | D697-4F61-88 | PO14326152394 | 100 | 272 | 333 | 107 | 2 | 2022-11-23 | 1409.38 | 35.23 | 2022-11-11 | 3 | 486.71 | 1 | 1409.38 | 4 | SO46977 | 2022-11-18 | 112.75 | 1460.12 | 469.79 | |||
SO50217_13 | 6AE5-491F-B6 | PO14500116814 | 100 | 282 | 421 | 650 | 1 | 2023-08-23 | 785.32 | 19.63 | 2023-08-11 | 4 | 145.28 | 1 | 785.32 | 13 | SO50217 | 2023-08-18 | 62.83 | 581.13 | 196.33 | |||
SO51081_1 | EDBF-4FE1-8F | PO522116846 | 100 | 285 | 237 | 676 | 5 | 2023-10-23 | 119.98 | 3.00 | 2023-10-11 | 4 | 38.49 | 1 | 119.98 | 1 | SO51081 | 2023-10-18 | 9.60 | 153.97 | 29.99 | |||
SO69404_3 | 2274-4413-B4 | PO16704110904 | 100 | 292 | 474 | 2 | 680 | 7 | 9.74 | 2024-08-23 | 487.13 | 11.93 | 2024-08-11 | 12 | 26.18 | 1 | 477.39 | 3 | SO69404 | 2024-08-18 | 38.19 | 314.12 | 40.59 | 0.02 |
SO47435_40 | B7A7-4F07-94 | PO5597154214 | 100 | 283 | 399 | 75 | 4 | 2022-12-24 | 202.65 | 5.07 | 2022-12-12 | 6 | 24.99 | 1 | 202.65 | 40 | SO47435 | 2022-12-19 | 16.21 | 149.96 | 33.77 | |||
SO69451_18 | EE16-4615-B7 | PO9918189570 | 100 | 285 | 496 | 260 | 5 | 2024-08-23 | 2409.38 | 60.23 | 2024-08-11 | 4 | 601.74 | 1 | 2409.38 | 18 | SO69451 | 2024-08-18 | 192.75 | 2406.97 | 602.35 | |||
SO65226_10 | 55DE-4772-82 | PO15515186601 | 100 | 292 | 581 | 481 | 7 | 2024-06-23 | 3061.78 | 76.54 | 2024-06-11 | 3 | 1082.51 | 1 | 3061.78 | 10 | SO65226 | 2024-06-18 | 244.94 | 3247.53 | 1020.59 | |||
SO45804_10 | A72B-452A-BA | PO2552178124 | 100 | 289 | 349 | 506 | 1 | 2022-07-24 | 8099.98 | 202.50 | 2022-07-12 | 4 | 1898.09 | 1 | 8099.98 | 10 | SO45804 | 2022-07-19 | 648.00 | 7592.38 | 2024.99 | |||
SO48349_24 | CD94-4B46-9E | PO1624135169 | 100 | 283 | 414 | 579 | 3 | 2023-03-25 | 149.03 | 3.73 | 2023-03-13 | 1 | 110.28 | 1 | 149.03 | 24 | SO48349 | 2023-03-20 | 11.92 | 110.28 | 149.03 | |||
SO69410_8 | 1192-472D-A8 | PO16820123881 | 6 | 296 | 579 | 213 | 9 | 2024-08-23 | 1457.82 | 36.45 | 2024-08-11 | 2 | 755.15 | 1 | 1457.82 | 8 | SO69410 | 2024-08-18 | 116.63 | 1510.30 | 728.91 | |||
SO48317_21 | FA92-4B66-88 | PO15515198588 | 100 | 292 | 271 | 481 | 7 | 2023-03-25 | 404.66 | 10.12 | 2023-03-13 | 2 | 187.16 | 1 | 404.66 | 21 | SO48317 | 2023-03-20 | 32.37 | 374.31 | 202.33 | |||
SO53465_29 | D859-4DF3-84 | PO17574192592 | 19 | 272 | 588 | 678 | 6 | 2023-12-24 | 1385.08 | 34.63 | 2023-12-12 | 3 | 419.78 | 1 | 1385.08 | 29 | SO53465 | 2023-12-19 | 110.81 | 1259.34 | 461.69 |
Generated 2024-11-10 23:57:57.186 UTC