[ROOT] dt FactResellerSale < WHERE DimSalesTerritoryId EQ '4' > SHUFFLE < SKIP 529 > < TAKE 56 >
56 items
| FactResellerSaleId | CarrierTrackingNumber | CustomerPONumber | DimCurrencyId | DimEmployeeId | DimProductId | DimResellerId | DimSalesTerritoryId | DueDate | ExtendedAmount | Freight | OrderDate | OrderQuantity | ProductStandardCost | RevisionNumber | SalesAmount | SalesOrderLineNumber | SalesOrderNumber | ShipDate | TaxAmt | TotalProductCost | UnitPrice |
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
| SO63180_21 | B8CD-47BA-8C | PO2523117609 | 100 | 287 | 481 | 167 | 4 | 2024-05-29 | 16.18 | 0.40 | 2024-05-17 | 3 | 3.36 | 1 | 16.18 | 21 | SO63180 | 2024-05-24 | 1.29 | 10.09 | 5.39 |
| SO47677_43 | 2C43-407F-B3 | PO13688179339 | 100 | 282 | 458 | 475 | 4 | 2023-01-27 | 89.99 | 2.25 | 2023-01-15 | 2 | 30.93 | 1 | 89.99 | 43 | SO47677 | 2023-01-22 | 7.20 | 61.87 | 44.99 |
| SO50747_36 | A59F-46DA-BE | PO5597196496 | 100 | 281 | 362 | 75 | 4 | 2023-09-27 | 3688.38 | 92.21 | 2023-09-15 | 3 | 1105.81 | 1 | 3688.38 | 36 | SO50747 | 2023-09-22 | 295.07 | 3317.43 | 1229.46 |
| SO43873_21 | 494C-48D2-BD | PO12499138177 | 100 | 282 | 328 | 78 | 4 | 2021-11-27 | 2097.29 | 52.43 | 2021-11-15 | 5 | 413.15 | 1 | 2097.29 | 21 | SO43873 | 2021-11-22 | 167.78 | 2065.73 | 419.46 |
| SO44099_3 | B4BD-41B2-87 | PO13717176693 | 100 | 287 | 317 | 473 | 4 | 2021-12-28 | 874.79 | 21.87 | 2021-12-16 | 1 | 884.71 | 1 | 874.79 | 3 | SO44099 | 2021-12-23 | 69.98 | 884.71 | 874.79 |
| SO58979_12 | A35B-403A-A4 | PO18038174164 | 100 | 287 | 552 | 509 | 4 | 2024-03-28 | 54.89 | 1.37 | 2024-03-16 | 1 | 40.62 | 1 | 54.89 | 12 | SO58979 | 2024-03-23 | 4.39 | 40.62 | 54.89 |
| SO45290_3 | 913D-41B7-81 | PO16037118184 | 100 | 282 | 296 | 384 | 4 | 2022-05-30 | 714.70 | 17.87 | 2022-05-18 | 1 | 617.03 | 1 | 714.70 | 3 | SO45290 | 2022-05-25 | 57.18 | 617.03 | 714.70 |
| SO46625_20 | 361B-4CAF-A2 | PO13688113829 | 100 | 282 | 410 | 475 | 4 | 2022-10-27 | 72.89 | 1.82 | 2022-10-15 | 2 | 26.97 | 1 | 72.89 | 20 | SO46625 | 2022-10-22 | 5.83 | 53.94 | 36.45 |
| SO44768_1 | 18BD-48B8-95 | PO261164909 | 100 | 283 | 338 | 647 | 4 | 2022-03-29 | 419.46 | 10.49 | 2022-03-17 | 1 | 413.15 | 1 | 419.46 | 1 | SO44768 | 2022-03-24 | 33.56 | 413.15 | 419.46 |
| SO46960_12 | F05E-41EB-90 | PO16762181648 | 100 | 282 | 216 | 259 | 4 | 2022-11-27 | 60.56 | 1.51 | 2022-11-15 | 3 | 13.88 | 1 | 60.56 | 12 | SO46960 | 2022-11-22 | 4.84 | 41.63 | 20.19 |
| SO69528_36 | 2644-4747-86 | PO6438163496 | 100 | 272 | 465 | 309 | 4 | 2024-08-27 | 73.47 | 1.84 | 2024-08-15 | 5 | 9.16 | 1 | 73.47 | 36 | SO69528 | 2024-08-22 | 5.88 | 45.80 | 14.69 |
| SO48356_23 | 3E64-467F-90 | PO2697152207 | 100 | 282 | 358 | 187 | 4 | 2023-03-29 | 2458.92 | 61.47 | 2023-03-17 | 2 | 1105.81 | 1 | 2458.92 | 23 | SO48356 | 2023-03-24 | 196.71 | 2211.62 | 1229.46 |
| SO67307_1 | ED03-4D31-93 | PO14413128868 | 100 | 287 | 481 | 383 | 4 | 2024-07-28 | 26.97 | 0.67 | 2024-07-16 | 5 | 3.36 | 1 | 26.97 | 1 | SO67307 | 2024-07-23 | 2.16 | 16.81 | 5.39 |
| SO59017_7 | 1571-4C89-99 | PO4582165909 | 100 | 282 | 587 | 25 | 4 | 2024-03-28 | 461.69 | 11.54 | 2024-03-16 | 1 | 419.78 | 1 | 461.69 | 7 | SO59017 | 2024-03-23 | 36.94 | 419.78 | 461.69 |
| SO46338_13 | 0BAC-4D7E-AD | PO15834128897 | 100 | 283 | 232 | 417 | 4 | 2022-09-27 | 115.36 | 2.88 | 2022-09-15 | 4 | 31.72 | 1 | 115.36 | 13 | SO46338 | 2022-09-22 | 9.23 | 126.90 | 28.84 |
| SO45291_21 | 3865-4B93-A6 | PO15689110696 | 100 | 283 | 310 | 328 | 4 | 2022-05-30 | 4293.92 | 107.35 | 2022-05-18 | 2 | 2171.29 | 1 | 4293.92 | 21 | SO45291 | 2022-05-25 | 343.51 | 4342.59 | 2146.96 |
| SO45516_21 | 3473-43AB-AE | PO261128364 | 100 | 283 | 215 | 647 | 4 | 2022-06-27 | 20.19 | 0.50 | 2022-06-15 | 1 | 12.03 | 1 | 20.19 | 21 | SO45516 | 2022-06-22 | 1.61 | 12.03 | 20.19 |
| SO53621_40 | 9324-4A3D-83 | PO9715186811 | 100 | 281 | 357 | 490 | 4 | 2023-12-28 | 12527.95 | 313.20 | 2023-12-16 | 9 | 1265.62 | 1 | 12527.95 | 40 | SO53621 | 2023-12-23 | 1002.24 | 11390.58 | 1391.99 |
| SO67274_2 | EAF2-43E4-AB | PO13659172775 | 100 | 287 | 542 | 437 | 4 | 2024-07-28 | 48.59 | 1.21 | 2024-07-16 | 2 | 17.98 | 1 | 48.59 | 2 | SO67274 | 2024-07-23 | 3.89 | 35.96 | 24.29 |
| SO47458_20 | 5D5A-47FC-AE | PO9686113121 | 100 | 282 | 366 | 457 | 4 | 2022-12-28 | 1295.99 | 32.40 | 2022-12-16 | 2 | 598.44 | 1 | 1295.99 | 20 | SO47458 | 2022-12-23 | 103.68 | 1196.87 | 647.99 |
| SO46057_13 | 6F2B-45A4-9C | PO12499164653 | 100 | 282 | 262 | 78 | 4 | 2022-08-27 | 919.69 | 22.99 | 2022-08-15 | 5 | 181.49 | 1 | 919.69 | 13 | SO46057 | 2022-08-22 | 73.58 | 907.43 | 183.94 |
| SO48049_19 | C09A-49F5-80 | PO3799136256 | 100 | 282 | 297 | 312 | 4 | 2023-02-27 | 1472.29 | 36.81 | 2023-02-15 | 2 | 653.70 | 1 | 1472.29 | 19 | SO48049 | 2023-02-22 | 117.78 | 1307.39 | 736.15 |
| SO55256_12 | 686E-4D36-8B | PO12528136439 | 100 | 282 | 559 | 331 | 4 | 2024-01-27 | 36.43 | 0.91 | 2024-01-15 | 3 | 8.99 | 1 | 36.43 | 12 | SO55256 | 2024-01-22 | 2.91 | 26.96 | 12.14 |
| SO43692_6 | BFA9-470E-B4 | PO7859187017 | 100 | 287 | 338 | 221 | 4 | 2021-10-27 | 419.46 | 10.49 | 2021-10-15 | 1 | 413.15 | 1 | 419.46 | 6 | SO43692 | 2021-10-22 | 33.56 | 413.15 | 419.46 |
| SO49132_13 | 3562-4169-86 | PO3799126007 | 100 | 282 | 460 | 312 | 4 | 2023-05-30 | 53.99 | 1.35 | 2023-05-18 | 1 | 37.12 | 1 | 53.99 | 13 | SO49132 | 2023-05-25 | 4.32 | 37.12 | 53.99 |
| SO47374_2 | C6BE-481A-A0 | PO16182131046 | 100 | 287 | 358 | 23 | 4 | 2022-12-28 | 4917.84 | 122.95 | 2022-12-16 | 4 | 1105.81 | 1 | 4917.84 | 2 | SO47374 | 2022-12-23 | 393.43 | 4423.24 | 1229.46 |
| SO51121_47 | 9E4C-40B6-B1 | PO10730114575 | 100 | 287 | 481 | 491 | 4 | 2023-10-27 | 32.36 | 0.81 | 2023-10-15 | 6 | 3.36 | 1 | 32.36 | 47 | SO51121 | 2023-10-22 | 2.59 | 20.17 | 5.39 |
| SO50252_38 | B5DA-491E-A9 | PO2523194031 | 100 | 287 | 417 | 167 | 4 | 2023-08-27 | 324.45 | 8.11 | 2023-08-15 | 1 | 300.12 | 1 | 324.45 | 38 | SO50252 | 2023-08-22 | 25.96 | 300.12 | 324.45 |
| SO50672_11 | 1BE9-437C-8A | PO16472110144 | 100 | 287 | 236 | 239 | 4 | 2023-09-27 | 173.04 | 4.33 | 2023-09-15 | 6 | 29.08 | 1 | 173.04 | 11 | SO50672 | 2023-09-22 | 13.84 | 174.48 | 28.84 |
| SO51102_7 | F2B1-4561-84 | PO13659193365 | 100 | 287 | 400 | 437 | 4 | 2023-10-27 | 111.46 | 2.79 | 2023-10-15 | 3 | 27.49 | 1 | 111.46 | 7 | SO51102 | 2023-10-22 | 8.92 | 82.48 | 37.15 |
| SO58995_4 | DA16-4097-96 | PO16269190750 | 100 | 287 | 583 | 624 | 4 | 2024-03-28 | 2041.19 | 51.03 | 2024-03-16 | 2 | 1082.51 | 1 | 2041.19 | 4 | SO58995 | 2024-03-23 | 163.30 | 2165.02 | 1020.59 |
| SO48012_28 | AF9F-4901-9E | PO12499156458 | 100 | 282 | 457 | 78 | 4 | 2023-02-27 | 44.99 | 1.12 | 2023-02-15 | 1 | 30.93 | 1 | 44.99 | 28 | SO48012 | 2023-02-22 | 3.60 | 30.93 | 44.99 |
| SO57168_4 | B6D5-41ED-B9 | PO3480129742 | 100 | 281 | 287 | 436 | 4 | 2024-02-27 | 809.33 | 20.23 | 2024-02-15 | 4 | 204.63 | 1 | 809.33 | 4 | SO57168 | 2024-02-22 | 64.75 | 818.50 | 202.33 |
| SO53460_46 | 3BD9-47C3-94 | PO19343112747 | 100 | 282 | 376 | 24 | 4 | 2023-12-28 | 2932.02 | 73.30 | 2023-12-16 | 2 | 1554.95 | 1 | 2932.02 | 46 | SO53460 | 2023-12-23 | 234.56 | 3109.90 | 1466.01 |
| SO63263_2 | 1E1A-44EE-94 | PO4843118280 | 100 | 287 | 580 | 257 | 4 | 2024-05-29 | 1020.59 | 25.51 | 2024-05-17 | 1 | 1082.51 | 1 | 1020.59 | 2 | SO63263 | 2024-05-24 | 81.65 | 1082.51 | 1020.59 |
| SO65315_26 | 0FFB-4EB5-A3 | PO6757194680 | 100 | 281 | 237 | 21 | 4 | 2024-06-27 | 269.95 | 6.75 | 2024-06-15 | 9 | 38.49 | 1 | 269.95 | 26 | SO65315 | 2024-06-22 | 21.60 | 346.43 | 29.99 |
| SO47417_19 | 1CE8-4651-A9 | PO2697165938 | 100 | 282 | 294 | 187 | 4 | 2022-12-28 | 1488.55 | 37.21 | 2022-12-16 | 2 | 660.91 | 1 | 1488.55 | 19 | SO47417 | 2022-12-23 | 119.08 | 1321.83 | 744.27 |
| SO43863_2 | D0C0-435D-A2 | PO15747169584 | 100 | 283 | 223 | 471 | 4 | 2021-11-27 | 5.19 | 0.13 | 2021-11-15 | 1 | 5.71 | 1 | 5.19 | 2 | SO43863 | 2021-11-22 | 0.41 | 5.71 | 5.19 |
| SO63212_3 | B54D-4C63-85 | PO5684113881 | 100 | 282 | 359 | 385 | 4 | 2024-05-29 | 11015.95 | 275.40 | 2024-05-17 | 8 | 1251.98 | 1 | 11015.95 | 3 | SO63212 | 2024-05-24 | 881.28 | 10015.85 | 1376.99 |
| SO49058_19 | BD1B-4C7F-A9 | PO12499147561 | 100 | 282 | 263 | 78 | 4 | 2023-05-30 | 202.33 | 5.06 | 2023-05-18 | 1 | 187.16 | 1 | 202.33 | 19 | SO49058 | 2023-05-25 | 16.19 | 187.16 | 202.33 |
| SO57034_34 | 57D0-46D3-B7 | PO15689142548 | 100 | 281 | 581 | 328 | 4 | 2024-02-27 | 7144.16 | 178.60 | 2024-02-15 | 7 | 1082.51 | 1 | 7144.16 | 34 | SO57034 | 2024-02-22 | 571.53 | 7577.57 | 1020.59 |
| SO48780_8 | F139-41F4-83 | PO5626121558 | 100 | 281 | 271 | 166 | 4 | 2023-04-29 | 1618.66 | 40.47 | 2023-04-17 | 8 | 187.16 | 1 | 1618.66 | 8 | SO48780 | 2023-04-24 | 129.49 | 1497.26 | 202.33 |
| SO71863_6 | F39F-4A8F-B9 | PO16124166561 | 100 | 282 | 606 | 649 | 4 | 2024-09-27 | 971.98 | 24.30 | 2024-09-15 | 3 | 343.65 | 1 | 971.98 | 6 | SO71863 | 2024-09-22 | 77.76 | 1030.95 | 323.99 |
| SO44314_14 | 6FDF-4206-A7 | PO5626111923 | 100 | 283 | 336 | 166 | 4 | 2022-01-27 | 838.92 | 20.97 | 2022-01-15 | 2 | 413.15 | 1 | 838.92 | 14 | SO44314 | 2022-01-22 | 67.11 | 826.29 | 419.46 |
| SO47027_5 | 1A9C-4166-A7 | PO3480112515 | 100 | 283 | 265 | 436 | 4 | 2022-11-27 | 809.33 | 20.23 | 2022-11-15 | 4 | 187.16 | 1 | 809.33 | 5 | SO47027 | 2022-11-22 | 64.75 | 748.63 | 202.33 |
| SO51855_36 | 8551-4CDF-A1 | PO3480115731 | 100 | 281 | 404 | 436 | 4 | 2023-11-27 | 53.45 | 1.34 | 2023-11-15 | 2 | 19.78 | 1 | 53.45 | 36 | SO51855 | 2023-11-22 | 4.28 | 39.55 | 26.72 |
| SO49523_14 | 852E-47A8-A9 | PO3915144057 | 100 | 281 | 369 | 130 | 4 | 2023-06-27 | 1466.01 | 36.65 | 2023-06-15 | 1 | 1518.79 | 1 | 1466.01 | 14 | SO49523 | 2023-06-22 | 117.28 | 1518.79 | 1466.01 |
| SO67305_29 | CBB5-42BF-9E | PO16298111473 | 100 | 287 | 566 | 599 | 4 | 2024-07-28 | 445.41 | 11.14 | 2024-07-16 | 1 | 461.44 | 1 | 445.41 | 29 | SO67305 | 2024-07-23 | 35.63 | 461.44 | 445.41 |
| SO51845_8 | 6AB8-4CEA-A9 | PO3799111961 | 100 | 282 | 353 | 312 | 4 | 2023-11-27 | 4175.98 | 104.40 | 2023-11-15 | 3 | 1265.62 | 1 | 4175.98 | 8 | SO51845 | 2023-11-22 | 334.08 | 3796.86 | 1391.99 |
| SO50282_15 | 9C0C-42E0-B6 | PO6525160235 | 100 | 281 | 305 | 345 | 4 | 2023-08-27 | 3680.73 | 92.02 | 2023-08-15 | 5 | 653.70 | 1 | 3680.73 | 15 | SO50282 | 2023-08-22 | 294.46 | 3268.49 | 736.15 |
| SO49058_20 | BD1B-4C7F-A9 | PO12499147561 | 100 | 282 | 323 | 78 | 4 | 2023-05-30 | 939.59 | 23.49 | 2023-05-18 | 2 | 486.71 | 1 | 939.59 | 20 | SO49058 | 2023-05-25 | 75.17 | 973.41 | 469.79 |
| SO49538_26 | CB52-4E7E-9B | PO6786132021 | 100 | 281 | 325 | 3 | 4 | 2023-06-27 | 939.59 | 23.49 | 2023-06-15 | 2 | 486.71 | 1 | 939.59 | 26 | SO49538 | 2023-06-22 | 75.17 | 973.41 | 469.79 |
| SO47720_36 | 30D0-4EF0-B1 | PO7859164121 | 100 | 287 | 221 | 221 | 4 | 2023-01-27 | 40.37 | 1.01 | 2023-01-15 | 2 | 13.88 | 1 | 40.37 | 36 | SO47720 | 2023-01-22 | 3.23 | 27.76 | 20.19 |
| SO57134_15 | 040D-4B73-AD | PO6351190175 | 100 | 281 | 481 | 255 | 4 | 2024-02-27 | 32.36 | 0.81 | 2024-02-15 | 6 | 3.36 | 1 | 32.36 | 15 | SO57134 | 2024-02-22 | 2.59 | 20.17 | 5.39 |
| SO49498_7 | D9E7-4090-86 | PO16472151816 | 100 | 287 | 369 | 239 | 4 | 2023-06-27 | 2932.02 | 73.30 | 2023-06-15 | 2 | 1518.79 | 1 | 2932.02 | 7 | SO49498 | 2023-06-22 | 234.56 | 3037.57 | 1466.01 |
| SO44564_8 | 142F-443C-90 | PO7656157194 | 100 | 282 | 270 | 403 | 4 | 2022-02-27 | 551.81 | 13.80 | 2022-02-15 | 3 | 181.49 | 1 | 551.81 | 8 | SO44564 | 2022-02-22 | 44.15 | 544.46 | 183.94 |
Generated 2024-11-14 07:00:22.992 UTC