[ROOT] dt FactResellerSale < WHERE DimSalesTerritoryId EQ '3' > SHUFFLE < SKIP 1501 > < 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 |
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
| SO46358_11 | 3BC7-40F4-99 | PO1624111969 | 100 | 283 | 212 | 579 | 3 | 2022-09-23 | 80.75 | 2.02 | 2022-09-11 | 4 | 12.03 | 1 | 80.75 | 11 | SO46358 | 2022-09-18 | 6.46 | 48.11 | 20.19 | |||
| SO49499_6 | E899-4E47-A2 | PO15341196181 | 100 | 281 | 420 | 327 | 3 | 2023-06-23 | 141.62 | 3.54 | 2023-06-11 | 1 | 104.80 | 1 | 141.62 | 6 | SO49499 | 2023-06-18 | 11.33 | 104.80 | 141.62 | |||
| SO46353_7 | D204-4F6B-A7 | PO10382113264 | 100 | 283 | 347 | 7 | 453 | 3 | 297.50 | 2022-09-23 | 850.00 | 13.81 | 2022-09-11 | 1 | 1912.15 | 1 | 552.50 | 7 | SO46353 | 2022-09-18 | 44.20 | 1912.15 | 850.00 | 0.35 |
| SO46931_5 | EE3D-4B0A-B6 | PO19923131204 | 100 | 281 | 426 | 18 | 3 | 2022-11-23 | 209.26 | 5.23 | 2022-11-11 | 1 | 185.82 | 1 | 209.26 | 5 | SO46931 | 2022-11-18 | 16.74 | 185.82 | 209.26 | |||
| SO69414_9 | 47BD-4582-A4 | PO15283145065 | 100 | 281 | 577 | 363 | 3 | 2024-08-23 | 728.91 | 18.22 | 2024-08-11 | 1 | 755.15 | 1 | 728.91 | 9 | SO69414 | 2024-08-18 | 58.31 | 755.15 | 728.91 | |||
| SO47352_5 | 9DF5-4A88-9C | PO19633111392 | 100 | 287 | 236 | 149 | 3 | 2022-12-24 | 86.52 | 2.16 | 2022-12-12 | 3 | 29.08 | 1 | 86.52 | 5 | SO47352 | 2022-12-19 | 6.92 | 87.24 | 28.84 | |||
| SO48791_8 | 9EBF-4C7E-82 | PO8787123349 | 100 | 282 | 381 | 523 | 3 | 2023-04-25 | 600.26 | 15.01 | 2023-04-13 | 1 | 605.65 | 1 | 600.26 | 8 | SO48791 | 2023-04-20 | 48.02 | 605.65 | 600.26 | |||
| SO48089_32 | EACD-4BB9-97 | PO8845169807 | 100 | 282 | 216 | 546 | 3 | 2023-02-23 | 60.56 | 1.51 | 2023-02-11 | 3 | 13.88 | 1 | 60.56 | 32 | SO48089 | 2023-02-18 | 4.84 | 41.63 | 20.19 | |||
| SO57037_20 | F0A9-4A16-B9 | PO15370120234 | 100 | 281 | 512 | 381 | 3 | 2024-02-23 | 655.36 | 16.38 | 2024-02-11 | 3 | 199.38 | 1 | 655.36 | 20 | SO57037 | 2024-02-18 | 52.43 | 598.13 | 218.45 | |||
| SO53480_2 | 36E1-4FCF-B4 | PO15341137525 | 100 | 281 | 596 | 327 | 3 | 2023-12-24 | 647.99 | 16.20 | 2023-12-12 | 2 | 294.58 | 1 | 647.99 | 2 | SO53480 | 2023-12-19 | 51.84 | 589.16 | 323.99 | |||
| SO49512_16 | E722-4D76-AD | PO12354152645 | 100 | 283 | 367 | 197 | 3 | 2023-06-23 | 1943.98 | 48.60 | 2023-06-11 | 3 | 598.44 | 1 | 1943.98 | 16 | SO49512 | 2023-06-18 | 155.52 | 1795.31 | 647.99 | |||
| SO57037_17 | F0A9-4A16-B9 | PO15370120234 | 100 | 281 | 511 | 381 | 3 | 2024-02-23 | 655.36 | 16.38 | 2024-02-11 | 3 | 199.38 | 1 | 655.36 | 17 | SO57037 | 2024-02-18 | 52.43 | 598.13 | 218.45 | |||
| SO46055_14 | DDC5-498B-87 | PO13572168536 | 100 | 287 | 322 | 527 | 3 | 2022-08-23 | 419.46 | 10.49 | 2022-08-11 | 1 | 413.15 | 1 | 419.46 | 14 | SO46055 | 2022-08-18 | 33.56 | 413.15 | 419.46 | |||
| SO55314_4 | A6ED-4B1A-BF | PO3016114503 | 100 | 281 | 475 | 183 | 3 | 2024-01-23 | 83.99 | 2.10 | 2024-01-11 | 2 | 26.18 | 1 | 83.99 | 4 | SO55314 | 2024-01-18 | 6.72 | 52.35 | 41.99 | |||
| SO46980_21 | FAA2-449B-99 | PO13572170679 | 100 | 287 | 273 | 527 | 3 | 2022-11-23 | 404.66 | 10.12 | 2022-11-11 | 2 | 187.16 | 1 | 404.66 | 21 | SO46980 | 2022-11-18 | 32.37 | 374.31 | 202.33 | |||
| SO46956_5 | 158F-43CB-95 | PO16849143827 | 100 | 281 | 263 | 198 | 3 | 2022-11-23 | 404.66 | 10.12 | 2022-11-11 | 2 | 187.16 | 1 | 404.66 | 5 | SO46956 | 2022-11-18 | 32.37 | 374.31 | 202.33 | |||
| SO46671_40 | 13F6-4858-8D | PO8787194061 | 100 | 282 | 453 | 523 | 3 | 2022-10-23 | 323.95 | 8.10 | 2022-10-11 | 9 | 24.75 | 1 | 323.95 | 40 | SO46671 | 2022-10-18 | 25.92 | 222.71 | 35.99 | |||
| SO44550_3 | 0BDF-4CBE-88 | PO5191121845 | 100 | 283 | 338 | 364 | 3 | 2022-02-23 | 838.92 | 20.97 | 2022-02-11 | 2 | 413.15 | 1 | 838.92 | 3 | SO44550 | 2022-02-18 | 67.11 | 826.29 | 419.46 | |||
| SO46671_36 | 13F6-4858-8D | PO8787194061 | 100 | 282 | 333 | 523 | 3 | 2022-10-23 | 2348.97 | 58.72 | 2022-10-11 | 5 | 486.71 | 1 | 2348.97 | 36 | SO46671 | 2022-10-18 | 187.92 | 2433.53 | 469.79 | |||
| SO59016_8 | C817-476A-BF | PO4785180874 | 100 | 282 | 561 | 223 | 3 | 2024-03-24 | 1430.44 | 35.76 | 2024-03-12 | 1 | 1481.94 | 1 | 1430.44 | 8 | SO59016 | 2024-03-19 | 114.44 | 1481.94 | 1430.44 | |||
| SO48089_7 | EACD-4BB9-97 | PO8845169807 | 100 | 282 | 421 | 546 | 3 | 2023-02-23 | 392.66 | 9.82 | 2023-02-11 | 2 | 145.28 | 1 | 392.66 | 7 | SO48089 | 2023-02-18 | 31.41 | 290.57 | 196.33 | |||
| SO47065_22 | D00A-426C-9B | PO8845147622 | 100 | 282 | 459 | 546 | 3 | 2022-11-23 | 215.98 | 5.40 | 2022-11-11 | 4 | 37.12 | 1 | 215.98 | 22 | SO47065 | 2022-11-18 | 17.28 | 148.48 | 53.99 | |||
| SO48379_5 | 703B-461C-A7 | PO7018165155 | 100 | 283 | 360 | 695 | 3 | 2023-03-25 | 1229.46 | 30.74 | 2023-03-13 | 1 | 1105.81 | 1 | 1229.46 | 5 | SO48379 | 2023-03-20 | 98.36 | 1105.81 | 1229.46 | |||
| SO49119_5 | 92B0-4959-B5 | PO15254156972 | 100 | 283 | 325 | 377 | 3 | 2023-05-26 | 469.79 | 11.74 | 2023-05-14 | 1 | 486.71 | 1 | 469.79 | 5 | SO49119 | 2023-05-21 | 37.58 | 486.71 | 469.79 | |||
| SO48292_25 | 7546-4477-B2 | PO19633112676 | 100 | 287 | 409 | 149 | 3 | 2023-03-25 | 209.26 | 5.23 | 2023-03-13 | 1 | 185.82 | 1 | 209.26 | 25 | SO48292 | 2023-03-20 | 16.74 | 185.82 | 209.26 | |||
| SO65221_15 | 0AC4-40AE-B6 | PO15341198427 | 100 | 281 | 234 | 327 | 3 | 2024-06-23 | 59.99 | 1.50 | 2024-06-11 | 2 | 38.49 | 1 | 59.99 | 15 | SO65221 | 2024-06-18 | 4.80 | 76.98 | 29.99 | |||
| SO51822_6 | EEEE-45C1-87 | PO8845178563 | 100 | 282 | 588 | 546 | 3 | 2023-11-23 | 2308.47 | 57.71 | 2023-11-11 | 5 | 419.78 | 1 | 2308.47 | 6 | SO51822 | 2023-11-18 | 184.68 | 2098.89 | 461.69 | |||
| SO46055_9 | DDC5-498B-87 | PO13572168536 | 100 | 287 | 319 | 527 | 3 | 2022-08-23 | 2624.38 | 65.61 | 2022-08-11 | 3 | 884.71 | 1 | 2624.38 | 9 | SO46055 | 2022-08-18 | 209.95 | 2654.12 | 874.79 | |||
| SO44110_12 | D69E-4EC8-8A | PO1624152036 | 100 | 283 | 285 | 579 | 3 | 2021-12-24 | 178.58 | 4.46 | 2021-12-12 | 1 | 176.20 | 1 | 178.58 | 12 | SO44110 | 2021-12-19 | 14.29 | 176.20 | 178.58 | |||
| SO53454_41 | 278D-445A-99 | PO19633151350 | 100 | 287 | 472 | 149 | 3 | 2023-12-24 | 152.40 | 3.81 | 2023-12-12 | 4 | 23.75 | 1 | 152.40 | 41 | SO53454 | 2023-12-19 | 12.19 | 95.00 | 38.10 | |||
| SO47440_16 | 490D-4B3C-84 | PO7018185620 | 100 | 283 | 360 | 695 | 3 | 2022-12-24 | 2458.92 | 61.47 | 2022-12-12 | 2 | 1105.81 | 1 | 2458.92 | 16 | SO47440 | 2022-12-19 | 196.71 | 2211.62 | 1229.46 | |||
| SO49093_16 | A0B1-4C01-8A | PO15370113221 | 100 | 281 | 470 | 381 | 3 | 2023-05-26 | 45.59 | 1.14 | 2023-05-14 | 2 | 15.67 | 1 | 45.59 | 16 | SO49093 | 2023-05-21 | 3.65 | 31.34 | 22.79 | |||
| SO51730_5 | 5526-465E-B8 | PO13572190190 | 100 | 287 | 520 | 527 | 3 | 2023-11-23 | 63.17 | 1.58 | 2023-11-11 | 2 | 23.37 | 1 | 63.17 | 5 | SO51730 | 2023-11-18 | 5.05 | 46.74 | 31.58 | |||
| SO44767_9 | 8497-4169-8D | PO10382198343 | 100 | 283 | 232 | 453 | 3 | 2022-03-25 | 28.84 | 0.72 | 2022-03-13 | 1 | 31.72 | 1 | 28.84 | 9 | SO44767 | 2022-03-20 | 2.31 | 31.72 | 28.84 | |||
| SO46067_14 | 2767-4728-8E | PO10440122607 | 100 | 283 | 218 | 623 | 3 | 2022-08-23 | 28.50 | 0.71 | 2022-08-11 | 5 | 3.40 | 1 | 28.50 | 14 | SO46067 | 2022-08-18 | 2.28 | 16.98 | 5.70 | |||
| SO48004_27 | DC8C-40DC-8F | PO13572118942 | 100 | 287 | 323 | 527 | 3 | 2023-02-23 | 469.79 | 11.74 | 2023-02-11 | 1 | 486.71 | 1 | 469.79 | 27 | SO48004 | 2023-02-18 | 37.58 | 486.71 | 469.79 | |||
| SO69561_42 | BBC0-4CA4-A2 | PO8845186382 | 100 | 282 | 355 | 546 | 3 | 2024-08-23 | 12527.95 | 313.20 | 2024-08-11 | 9 | 1265.62 | 1 | 12527.95 | 42 | SO69561 | 2024-08-18 | 1002.24 | 11390.58 | 1391.99 | |||
| SO65261_9 | 5DAE-4844-AA | PO4785146431 | 100 | 282 | 560 | 223 | 3 | 2024-06-23 | 1457.82 | 36.45 | 2024-06-11 | 2 | 755.15 | 1 | 1457.82 | 9 | SO65261 | 2024-06-18 | 116.63 | 1510.30 | 728.91 | |||
| SO51720_37 | E39F-4680-AC | PO15370128892 | 100 | 281 | 599 | 381 | 3 | 2023-11-23 | 323.99 | 8.10 | 2023-11-11 | 1 | 294.58 | 1 | 323.99 | 37 | SO51720 | 2023-11-18 | 25.92 | 294.58 | 323.99 | |||
| SO57186_1 | EF93-4946-97 | PO8845159326 | 100 | 282 | 597 | 546 | 3 | 2024-02-23 | 647.99 | 16.20 | 2024-02-11 | 2 | 294.58 | 1 | 647.99 | 1 | SO57186 | 2024-02-18 | 51.84 | 589.16 | 323.99 | |||
| SO47440_12 | 490D-4B3C-84 | PO7018185620 | 100 | 283 | 356 | 695 | 3 | 2022-12-24 | 3728.56 | 93.21 | 2022-12-12 | 3 | 1117.86 | 1 | 3728.56 | 12 | SO47440 | 2022-12-19 | 298.28 | 3353.57 | 1242.85 | |||
| SO49093_8 | A0B1-4C01-8A | PO15370113221 | 100 | 281 | 358 | 381 | 3 | 2023-05-26 | 3688.38 | 92.21 | 2023-05-14 | 3 | 1105.81 | 1 | 3688.38 | 8 | SO49093 | 2023-05-21 | 295.07 | 3317.43 | 1229.46 | |||
| SO44530_3 | 46CE-47C5-B3 | PO10440138648 | 100 | 283 | 351 | 623 | 3 | 2022-02-23 | 16199.95 | 405.00 | 2022-02-11 | 8 | 1898.09 | 1 | 16199.95 | 3 | SO44530 | 2022-02-18 | 1296.00 | 15184.76 | 2024.99 | |||
| SO51731_9 | FF50-4EB1-9E | PO13601192740 | 100 | 281 | 547 | 310 | 3 | 2023-11-23 | 48.59 | 1.21 | 2023-11-11 | 1 | 35.96 | 1 | 48.59 | 9 | SO51731 | 2023-11-18 | 3.89 | 35.96 | 48.59 | |||
| SO48325_2 | 0A85-48D3-97 | PO14268111638 | 100 | 283 | 460 | 418 | 3 | 2023-03-25 | 215.98 | 5.40 | 2023-03-13 | 4 | 37.12 | 1 | 215.98 | 2 | SO48325 | 2023-03-20 | 17.28 | 148.48 | 53.99 | |||
| SO48786_4 | D12C-42C5-83 | PO6467115913 | 100 | 283 | 327 | 660 | 3 | 2023-04-25 | 939.59 | 23.49 | 2023-04-13 | 2 | 486.71 | 1 | 939.59 | 4 | SO48786 | 2023-04-20 | 75.17 | 973.41 | 469.79 | |||
| SO63123_3 | ADA9-4CA6-94 | PO19923184888 | 100 | 283 | 355 | 18 | 3 | 2024-05-25 | 1391.99 | 34.80 | 2024-05-13 | 1 | 1265.62 | 1 | 1391.99 | 3 | SO63123 | 2024-05-20 | 111.36 | 1265.62 | 1391.99 | |||
| SO48786_20 | D12C-42C5-83 | PO6467115913 | 100 | 283 | 447 | 660 | 3 | 2023-04-25 | 30.00 | 0.75 | 2023-04-13 | 2 | 10.31 | 1 | 30.00 | 20 | SO48786 | 2023-04-20 | 2.40 | 20.63 | 15.00 | |||
| SO50189_23 | 6D35-41E2-A6 | PO19923188059 | 100 | 283 | 397 | 18 | 3 | 2023-08-23 | 48.59 | 1.21 | 2023-08-11 | 2 | 17.98 | 1 | 48.59 | 23 | SO50189 | 2023-08-18 | 3.89 | 35.96 | 24.29 | |||
| SO44517_18 | 47C8-4635-A6 | PO13572181174 | 100 | 287 | 212 | 527 | 3 | 2022-02-23 | 80.75 | 2.02 | 2022-02-11 | 4 | 12.03 | 1 | 80.75 | 18 | SO44517 | 2022-02-18 | 6.46 | 48.11 | 20.19 | |||
| SO50322_25 | 4BC2-4C6D-83 | PO8845166508 | 100 | 282 | 459 | 546 | 3 | 2023-08-23 | 215.98 | 5.40 | 2023-08-11 | 4 | 37.12 | 1 | 215.98 | 25 | SO50322 | 2023-08-18 | 17.28 | 148.48 | 53.99 | |||
| SO63215_3 | A697-4D03-B0 | PO8874198670 | 100 | 282 | 475 | 348 | 3 | 2024-05-25 | 41.99 | 1.05 | 2024-05-13 | 1 | 26.18 | 1 | 41.99 | 3 | SO63215 | 2024-05-20 | 3.36 | 26.18 | 41.99 | |||
| SO49040_2 | 6653-43A9-8D | PO19923195099 | 100 | 283 | 393 | 18 | 3 | 2023-05-26 | 413.08 | 10.33 | 2023-05-14 | 3 | 101.89 | 1 | 413.08 | 2 | SO49040 | 2023-05-21 | 33.05 | 305.68 | 137.69 | |||
| SO48292_5 | 7546-4477-B2 | PO19633112676 | 100 | 287 | 410 | 149 | 3 | 2023-03-25 | 109.34 | 2.73 | 2023-03-13 | 3 | 26.97 | 1 | 109.34 | 5 | SO48292 | 2023-03-20 | 8.75 | 80.91 | 36.45 | |||
| SO47041_41 | C543-4932-83 | PO5771188676 | 100 | 282 | 385 | 79 | 3 | 2022-11-23 | 1800.79 | 45.02 | 2022-11-11 | 3 | 605.65 | 1 | 1800.79 | 41 | SO47041 | 2022-11-18 | 144.06 | 1816.95 | 600.26 | |||
| SO50675_11 | 4D87-4C93-9C | PO15341172035 | 100 | 281 | 233 | 327 | 3 | 2023-09-23 | 144.20 | 3.61 | 2023-09-11 | 5 | 29.08 | 1 | 144.20 | 11 | SO50675 | 2023-09-18 | 11.54 | 145.40 | 28.84 | |||
| SO48065_37 | 1B78-4DE6-BC | PO5771120852 | 100 | 282 | 456 | 79 | 3 | 2023-02-23 | 224.97 | 5.62 | 2023-02-11 | 5 | 30.93 | 1 | 224.97 | 37 | SO48065 | 2023-02-18 | 18.00 | 154.67 | 44.99 | |||
| SO48791_6 | 9EBF-4C7E-82 | PO8787123349 | 100 | 282 | 325 | 523 | 3 | 2023-04-25 | 2348.97 | 58.72 | 2023-04-13 | 5 | 486.71 | 1 | 2348.97 | 6 | SO48791 | 2023-04-20 | 187.92 | 2433.53 | 469.79 | |||
| SO46325_10 | D29B-490E-A9 | PO19488134185 | 100 | 283 | 317 | 57 | 3 | 2022-09-23 | 1749.59 | 43.74 | 2022-09-11 | 2 | 884.71 | 1 | 1749.59 | 10 | SO46325 | 2022-09-18 | 139.97 | 1769.42 | 874.79 | |||
| SO51828_29 | 3204-40B6-A5 | PO5771194719 | 100 | 282 | 231 | 79 | 3 | 2023-11-23 | 149.97 | 3.75 | 2023-11-11 | 5 | 38.49 | 1 | 149.97 | 29 | SO51828 | 2023-11-18 | 12.00 | 192.46 | 29.99 | |||
| SO48292_16 | 7546-4477-B2 | PO19633112676 | 100 | 287 | 401 | 149 | 3 | 2023-03-25 | 65.60 | 1.64 | 2023-03-13 | 1 | 48.55 | 1 | 65.60 | 16 | SO48292 | 2023-03-20 | 5.25 | 48.55 | 65.60 | |||
| SO50682_35 | 1145-4AD1-B8 | PO12354142084 | 100 | 283 | 356 | 197 | 3 | 2023-09-23 | 1242.85 | 31.07 | 2023-09-11 | 1 | 1117.86 | 1 | 1242.85 | 35 | SO50682 | 2023-09-18 | 99.43 | 1117.86 | 1242.85 |
Generated 2024-11-10 13:39:15.495 UTC