[ROOT] dt FactResellerSale WHERE DimSalesTerritoryId EQ '1' > SKIP 0 SHUFFLE < SKIP 1876 > < 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 |
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
| SO49053_33 | 5BE4-4969-A1 | PO16414175823 | 100 | 289 | 213 | 236 | 1 | 2023-05-26 | 121.12 | 3.03 | 2023-05-14 | 6 | 13.88 | 1 | 121.12 | 33 | SO49053 | 2023-05-21 | 9.69 | 83.27 | 20.19 | |||
| SO67266_16 | 3CFE-46C9-88 | PO16588161069 | 100 | 289 | 402 | 146 | 1 | 2024-07-24 | 144.32 | 3.61 | 2024-07-12 | 2 | 53.40 | 1 | 144.32 | 16 | SO67266 | 2024-07-19 | 11.55 | 106.80 | 72.16 | |||
| SO44762_6 | 553E-437E-92 | PO13543176259 | 100 | 287 | 350 | 293 | 1 | 2022-03-25 | 18224.95 | 455.62 | 2022-03-13 | 9 | 1898.09 | 1 | 18224.95 | 6 | SO44762 | 2022-03-20 | 1458.00 | 17082.85 | 2024.99 | |||
| SO58961_9 | 0848-4E9B-81 | PO10411162031 | 100 | 289 | 573 | 182 | 1 | 2024-03-24 | 4291.33 | 107.28 | 2024-03-12 | 3 | 1481.94 | 1 | 4291.33 | 9 | SO58961 | 2024-03-19 | 343.31 | 4445.81 | 1430.44 | |||
| SO51138_5 | 685D-4916-A6 | PO9338137293 | 100 | 293 | 503 | 451 | 1 | 2023-10-23 | 400.10 | 10.00 | 2023-10-11 | 2 | 199.85 | 1 | 400.10 | 5 | SO51138 | 2023-10-18 | 32.01 | 399.70 | 200.05 | |||
| SO63157_41 | 9E62-4577-80 | PO14500183845 | 100 | 282 | 361 | 650 | 1 | 2024-05-25 | 9638.96 | 240.97 | 2024-05-13 | 7 | 1251.98 | 1 | 9638.96 | 41 | SO63157 | 2024-05-20 | 771.12 | 8763.87 | 1376.99 | |||
| SO59010_7 | 2350-42CD-B1 | PO6815132533 | 100 | 293 | 214 | 109 | 1 | 2024-03-24 | 167.95 | 4.20 | 2024-03-12 | 8 | 13.09 | 1 | 167.95 | 7 | SO59010 | 2024-03-19 | 13.44 | 104.69 | 20.99 | |||
| SO45318_15 | 13CE-461F-B9 | PO2900174093 | 100 | 286 | 347 | 469 | 1 | 2022-05-26 | 2039.99 | 51.00 | 2022-05-14 | 1 | 1912.15 | 1 | 2039.99 | 15 | SO45318 | 2022-05-21 | 163.20 | 1912.15 | 2039.99 | |||
| SO43671_4 | DFD9-41B7-94 | PO13978119376 | 100 | 289 | 338 | 200 | 1 | 2021-10-23 | 838.92 | 20.97 | 2021-10-11 | 2 | 413.15 | 1 | 838.92 | 4 | SO43671 | 2021-10-18 | 67.11 | 826.29 | 419.46 | |||
| SO53452_12 | B555-4FD7-8B | PO870113712 | 100 | 286 | 586 | 13 | 621 | 1 | 300.65 | 2023-12-24 | 2004.35 | 42.59 | 2023-12-12 | 6 | 461.44 | 1 | 1703.69 | 12 | SO53452 | 2023-12-19 | 136.30 | 2768.67 | 334.06 | 0.15 |
| SO51830_4 | EBE1-4015-AE | PO7627127132 | 100 | 272 | 384 | 433 | 1 | 2023-11-23 | 6050.65 | 151.27 | 2023-11-11 | 9 | 713.08 | 1 | 6050.65 | 4 | SO51830 | 2023-11-18 | 484.05 | 6417.72 | 672.29 | |||
| SO46643_19 | 49E8-4C7A-85 | PO899110603 | 100 | 289 | 381 | 2 | 290 | 1 | 139.26 | 2022-10-23 | 6963.05 | 170.59 | 2022-10-11 | 12 | 605.65 | 1 | 6823.78 | 19 | SO46643 | 2022-10-18 | 545.90 | 7267.79 | 580.25 | 0.02 |
| SO51783_34 | B7A2-49BC-89 | PO18676114917 | 100 | 282 | 363 | 697 | 1 | 2023-11-23 | 13769.94 | 344.25 | 2023-11-11 | 10 | 1251.98 | 1 | 13769.94 | 34 | SO51783 | 2023-11-18 | 1101.60 | 12519.81 | 1376.99 | |||
| SO46974_9 | BEE6-4EC8-8E | PO14442112586 | 100 | 286 | 391 | 127 | 1 | 2022-11-23 | 177.86 | 4.45 | 2022-11-11 | 2 | 65.81 | 1 | 177.86 | 9 | SO46974 | 2022-11-18 | 14.23 | 131.62 | 88.93 | |||
| SO46372_9 | 236A-4108-B4 | PO5220136009 | 100 | 282 | 218 | 169 | 1 | 2022-09-23 | 17.10 | 0.43 | 2022-09-11 | 3 | 3.40 | 1 | 17.10 | 9 | SO46372 | 2022-09-18 | 1.37 | 10.19 | 5.70 | |||
| SO43869_5 | 96FA-4DF1-81 | PO14500145975 | 100 | 282 | 344 | 650 | 1 | 2021-11-23 | 10199.97 | 255.00 | 2021-11-11 | 5 | 1912.15 | 1 | 10199.97 | 5 | SO43869 | 2021-11-18 | 816.00 | 9560.77 | 2039.99 | |||
| SO46646_5 | A64B-4F46-92 | PO1421164577 | 100 | 286 | 458 | 325 | 1 | 2022-10-23 | 224.97 | 5.62 | 2022-10-11 | 5 | 30.93 | 1 | 224.97 | 5 | SO46646 | 2022-10-18 | 18.00 | 154.67 | 44.99 | |||
| SO69500_2 | 2AB8-4D0B-85 | PO5742135829 | 100 | 293 | 516 | 541 | 1 | 2024-08-23 | 46.97 | 1.17 | 2024-08-11 | 2 | 17.38 | 1 | 46.97 | 2 | SO69500 | 2024-08-18 | 3.76 | 34.76 | 23.48 | |||
| SO44126_1 | 0FC0-4BE3-AF | PO7192167220 | 100 | 289 | 349 | 20 | 1 | 2021-12-24 | 2024.99 | 50.62 | 2021-12-12 | 1 | 1898.09 | 1 | 2024.99 | 1 | SO44126 | 2021-12-19 | 162.00 | 1898.09 | 2024.99 | |||
| SO59019_1 | 5F5A-465D-A8 | PO7192182554 | 100 | 289 | 474 | 20 | 1 | 2024-03-24 | 125.98 | 3.15 | 2024-03-12 | 3 | 26.18 | 1 | 125.98 | 1 | SO59019 | 2024-03-19 | 10.08 | 78.53 | 41.99 | |||
| SO65175_8 | E1A8-440E-94 | PO17139119772 | 100 | 293 | 384 | 644 | 1 | 2024-06-23 | 2016.88 | 50.42 | 2024-06-11 | 3 | 713.08 | 1 | 2016.88 | 8 | SO65175 | 2024-06-18 | 161.35 | 2139.24 | 672.29 | |||
| SO69524_1 | B8BC-4D73-8B | PO5162129421 | 100 | 289 | 436 | 669 | 1 | 2024-08-23 | 356.90 | 8.92 | 2024-08-11 | 1 | 360.94 | 1 | 356.90 | 1 | SO69524 | 2024-08-18 | 28.55 | 360.94 | 356.90 | |||
| SO67321_15 | 7F43-4E4F-8E | PO7076150186 | 100 | 293 | 498 | 505 | 1 | 2024-07-24 | 602.35 | 15.06 | 2024-07-12 | 1 | 601.74 | 1 | 602.35 | 15 | SO67321 | 2024-07-19 | 48.19 | 601.74 | 602.35 | |||
| SO48741_7 | 5AA4-4194-B9 | PO899196006 | 100 | 289 | 433 | 290 | 1 | 2023-04-25 | 1622.26 | 40.56 | 2023-04-13 | 5 | 300.12 | 1 | 1622.26 | 7 | SO48741 | 2023-04-20 | 129.78 | 1500.59 | 324.45 | |||
| SO51089_10 | A635-4BAF-BC | PO16588151558 | 100 | 289 | 532 | 146 | 1 | 2023-10-23 | 599.50 | 14.99 | 2023-10-11 | 4 | 136.79 | 1 | 599.50 | 10 | SO51089 | 2023-10-18 | 47.96 | 547.14 | 149.87 | |||
| SO45549_15 | E477-44D2-B0 | PO783111978 | 100 | 286 | 328 | 91 | 1 | 2022-06-23 | 1258.38 | 31.46 | 2022-06-11 | 3 | 413.15 | 1 | 1258.38 | 15 | SO45549 | 2022-06-18 | 100.67 | 1239.44 | 419.46 | |||
| SO45518_2 | 2F4B-4BB7-98 | PO20155192513 | 100 | 289 | 346 | 92 | 1 | 2022-06-23 | 2039.99 | 51.00 | 2022-06-11 | 1 | 1912.15 | 1 | 2039.99 | 2 | SO45518 | 2022-06-18 | 163.20 | 1912.15 | 2039.99 | |||
| SO53613_47 | 4A10-4F98-84 | PO6815195063 | 100 | 293 | 597 | 109 | 1 | 2023-12-24 | 647.99 | 16.20 | 2023-12-12 | 2 | 294.58 | 1 | 647.99 | 47 | SO53613 | 2023-12-19 | 51.84 | 589.16 | 323.99 | |||
| SO47403_20 | 60A2-4F08-8B | PO841143108 | 100 | 286 | 401 | 254 | 1 | 2022-12-24 | 131.20 | 3.28 | 2022-12-12 | 2 | 48.55 | 1 | 131.20 | 20 | SO47403 | 2022-12-19 | 10.50 | 97.09 | 65.60 | |||
| SO69408_13 | 8DF5-4377-9D | PO16414161428 | 100 | 289 | 359 | 236 | 1 | 2024-08-23 | 8261.96 | 206.55 | 2024-08-11 | 6 | 1251.98 | 1 | 8261.96 | 13 | SO69408 | 2024-08-18 | 660.96 | 7511.89 | 1376.99 | |||
| SO65234_23 | 3BB7-4A9F-AF | PO10411160249 | 100 | 289 | 603 | 182 | 1 | 2024-06-23 | 291.58 | 7.29 | 2024-06-11 | 4 | 53.94 | 1 | 291.58 | 23 | SO65234 | 2024-06-18 | 23.33 | 215.77 | 72.89 | |||
| SO49136_2 | 3492-4F41-97 | PO4727180151 | 100 | 293 | 385 | 343 | 1 | 2023-05-26 | 2401.05 | 60.03 | 2023-05-14 | 4 | 605.65 | 1 | 2401.05 | 2 | SO49136 | 2023-05-21 | 192.08 | 2422.60 | 600.26 | |||
| SO45283_5 | 07F7-44C2-BA | PO16646111452 | 100 | 286 | 328 | 1 | 1 | 2022-05-26 | 1677.84 | 41.95 | 2022-05-14 | 4 | 413.15 | 1 | 1677.84 | 5 | SO45283 | 2022-05-21 | 134.23 | 1652.59 | 419.46 | |||
| SO49503_3 | 1FD6-48BE-A1 | PO13543189827 | 100 | 287 | 213 | 293 | 1 | 2023-06-23 | 20.19 | 0.50 | 2023-06-11 | 1 | 13.88 | 1 | 20.19 | 3 | SO49503 | 2023-06-18 | 1.61 | 13.88 | 20.19 | |||
| SO46025_3 | ADCD-4F7A-A7 | PO19981184028 | 100 | 286 | 319 | 271 | 1 | 2022-08-23 | 1749.59 | 43.74 | 2022-08-11 | 2 | 884.71 | 1 | 1749.59 | 3 | SO46025 | 2022-08-18 | 139.97 | 1769.42 | 874.79 | |||
| SO48083_5 | E4B1-4D02-90 | PO7917164304 | 100 | 287 | 356 | 401 | 1 | 2023-02-23 | 1242.85 | 31.07 | 2023-02-11 | 1 | 1117.86 | 1 | 1242.85 | 5 | SO48083 | 2023-02-18 | 99.43 | 1117.86 | 1242.85 | |||
| SO71833_8 | 8525-4645-AB | PO10411123072 | 100 | 289 | 552 | 182 | 1 | 2024-09-23 | 219.58 | 5.49 | 2024-09-11 | 4 | 40.62 | 1 | 219.58 | 8 | SO71833 | 2024-09-18 | 17.57 | 162.49 | 54.89 | |||
| SO46032_10 | 3A64-43B4-B5 | PO18676118909 | 100 | 282 | 218 | 697 | 1 | 2022-08-23 | 39.90 | 1.00 | 2022-08-11 | 7 | 3.40 | 1 | 39.90 | 10 | SO46032 | 2022-08-18 | 3.19 | 23.77 | 5.70 | |||
| SO53518_50 | 5712-444B-BC | PO841197199 | 100 | 286 | 599 | 254 | 1 | 2023-12-24 | 647.99 | 16.20 | 2023-12-12 | 2 | 294.58 | 1 | 647.99 | 50 | SO53518 | 2023-12-19 | 51.84 | 589.16 | 323.99 | |||
| SO43895_2 | 5233-4CB8-BC | PO2900121738 | 100 | 286 | 220 | 469 | 1 | 2021-11-23 | 40.37 | 1.01 | 2021-11-11 | 2 | 12.03 | 1 | 40.37 | 2 | SO43895 | 2021-11-18 | 3.23 | 24.06 | 20.19 | |||
| SO51127_3 | D321-4FEA-80 | PO2552155165 | 100 | 286 | 353 | 506 | 1 | 2023-10-23 | 2783.99 | 69.60 | 2023-10-11 | 2 | 1265.62 | 1 | 2783.99 | 3 | SO51127 | 2023-10-18 | 222.72 | 2531.24 | 1391.99 | |||
| SO59010_31 | 2350-42CD-B1 | PO6815132533 | 100 | 293 | 357 | 109 | 1 | 2024-03-24 | 1391.99 | 34.80 | 2024-03-12 | 1 | 1265.62 | 1 | 1391.99 | 31 | SO59010 | 2024-03-19 | 111.36 | 1265.62 | 1391.99 | |||
| SO46646_3 | A64B-4F46-92 | PO1421164577 | 100 | 286 | 410 | 325 | 1 | 2022-10-23 | 72.89 | 1.82 | 2022-10-11 | 2 | 26.97 | 1 | 72.89 | 3 | SO46646 | 2022-10-18 | 5.83 | 53.94 | 36.45 | |||
| SO46105_23 | 2590-40A7-BB | PO8816169858 | 100 | 289 | 215 | 218 | 1 | 2022-08-23 | 80.75 | 2.02 | 2022-08-11 | 4 | 12.03 | 1 | 80.75 | 23 | SO46105 | 2022-08-18 | 6.46 | 48.11 | 20.19 | |||
| SO46967_31 | 6486-4AF8-A6 | PO15573116583 | 100 | 286 | 469 | 487 | 1 | 2022-11-23 | 113.97 | 2.85 | 2022-11-11 | 5 | 15.67 | 1 | 113.97 | 31 | SO46967 | 2022-11-18 | 9.12 | 78.35 | 22.79 | |||
| SO47991_13 | 0F2E-4E6D-8E | PO15631116034 | 100 | 282 | 419 | 43 | 1 | 2023-02-23 | 52.65 | 1.32 | 2023-02-11 | 1 | 38.96 | 1 | 52.65 | 13 | SO47991 | 2023-02-18 | 4.21 | 38.96 | 52.65 | |||
| SO49136_31 | 3492-4F41-97 | PO4727180151 | 100 | 293 | 373 | 343 | 1 | 2023-05-26 | 9162.56 | 229.06 | 2023-05-14 | 7 | 1320.68 | 1 | 9162.56 | 31 | SO49136 | 2023-05-21 | 733.01 | 9244.79 | 1308.94 | |||
| SO47368_6 | 7A90-4975-A2 | PO17487188099 | 100 | 286 | 422 | 692 | 1 | 2022-12-24 | 67.54 | 1.69 | 2022-12-12 | 1 | 49.98 | 1 | 67.54 | 6 | SO47368 | 2022-12-19 | 5.40 | 49.98 | 67.54 | |||
| SO46322_1 | 5783-4DA3-B3 | PO20097117736 | 100 | 289 | 253 | 128 | 1 | 2022-09-23 | 178.58 | 4.46 | 2022-09-11 | 1 | 176.20 | 1 | 178.58 | 1 | SO46322 | 2022-09-18 | 14.29 | 176.20 | 178.58 | |||
| SO49167_10 | 5A78-4DE2-89 | PO8816115193 | 100 | 289 | 377 | 218 | 1 | 2023-05-26 | 2617.88 | 65.45 | 2023-05-14 | 2 | 1320.68 | 1 | 2617.88 | 10 | SO49167 | 2023-05-21 | 209.43 | 2641.37 | 1308.94 | |||
| SO57030_33 | 373C-4C0F-88 | PO16414180321 | 100 | 289 | 363 | 236 | 1 | 2024-02-23 | 4130.98 | 103.27 | 2024-02-11 | 3 | 1251.98 | 1 | 4130.98 | 33 | SO57030 | 2024-02-18 | 330.48 | 3755.94 | 1376.99 | |||
| SO44570_22 | 4132-4AE3-99 | PO8816195785 | 100 | 289 | 212 | 218 | 1 | 2022-02-23 | 80.75 | 2.02 | 2022-02-11 | 4 | 12.03 | 1 | 80.75 | 22 | SO44570 | 2022-02-18 | 6.46 | 48.11 | 20.19 | |||
| SO45549_14 | E477-44D2-B0 | PO783111978 | 100 | 286 | 334 | 91 | 1 | 2022-06-23 | 419.46 | 10.49 | 2022-06-11 | 1 | 413.15 | 1 | 419.46 | 14 | SO45549 | 2022-06-18 | 33.56 | 413.15 | 419.46 | |||
| SO63158_1 | FB05-4C2E-A4 | PO14529115132 | 100 | 293 | 475 | 289 | 1 | 2024-05-25 | 41.99 | 1.05 | 2024-05-13 | 1 | 26.18 | 1 | 41.99 | 1 | SO63158 | 2024-05-20 | 3.36 | 26.18 | 41.99 | |||
| SO53493_28 | F767-491F-84 | PO13543118174 | 100 | 287 | 542 | 293 | 1 | 2023-12-24 | 24.29 | 0.61 | 2023-12-12 | 1 | 17.98 | 1 | 24.29 | 28 | SO53493 | 2023-12-19 | 1.94 | 17.98 | 24.29 | |||
| SO71791_3 | AB1B-4CE2-BA | PO17139191080 | 100 | 293 | 382 | 644 | 1 | 2024-09-23 | 672.29 | 16.81 | 2024-09-11 | 1 | 713.08 | 1 | 672.29 | 3 | SO71791 | 2024-09-18 | 53.78 | 713.08 | 672.29 | |||
| SO50299_1 | 0946-4A09-8C | PO5046193357 | 100 | 289 | 396 | 596 | 1 | 2023-08-23 | 74.84 | 1.87 | 2023-08-11 | 1 | 55.38 | 1 | 74.84 | 1 | SO50299 | 2023-08-18 | 5.99 | 55.38 | 74.84 | |||
| SO49081_1 | 785C-4EC1-B6 | PO2958130222 | 100 | 293 | 358 | 559 | 1 | 2023-05-26 | 1229.46 | 30.74 | 2023-05-14 | 1 | 1105.81 | 1 | 1229.46 | 1 | SO49081 | 2023-05-21 | 98.36 | 1105.81 | 1229.46 | |||
| SO43671_5 | DFD9-41B7-94 | PO13978119376 | 100 | 289 | 275 | 200 | 1 | 2021-10-23 | 713.80 | 17.84 | 2021-10-11 | 2 | 352.14 | 1 | 713.80 | 5 | SO43671 | 2021-10-18 | 57.10 | 704.28 | 356.90 | |||
| SO46972_17 | 1A21-419F-8D | PO14500164221 | 100 | 282 | 411 | 650 | 1 | 2022-11-23 | 250.83 | 6.27 | 2022-11-11 | 2 | 92.81 | 1 | 250.83 | 17 | SO46972 | 2022-11-18 | 20.07 | 185.61 | 125.42 | |||
| SO44501_5 | 4971-4FC0-A3 | PO16646128920 | 100 | 286 | 318 | 1 | 1 | 2022-02-23 | 874.79 | 21.87 | 2022-02-11 | 1 | 884.71 | 1 | 874.79 | 5 | SO44501 | 2022-02-18 | 69.98 | 884.71 | 874.79 | |||
| SO43665_3 | 19F0-4638-8E | PO16588191572 | 100 | 289 | 212 | 146 | 1 | 2021-10-23 | 20.19 | 0.50 | 2021-10-11 | 1 | 12.03 | 1 | 20.19 | 3 | SO43665 | 2021-10-18 | 1.61 | 12.03 | 20.19 |
Generated 2024-11-10 05:08:55.229 UTC