[ROOT] dt FactResellerSale < WHERE DimSalesTerritoryId EQ '4' > SHUFFLE < SKIP 3281 > < TAKE 60 >
60 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 |
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
| SO44127_4 | E778-471D-8A | PO7569162058 | 100 | 287 | 304 | 608 | 4 | 2021-12-24 | 1429.41 | 35.74 | 2021-12-12 | 2 | 617.03 | 1 | 1429.41 | 4 | SO44127 | 2021-12-19 | 114.35 | 1234.06 | 714.70 | |||
| SO69536_39 | 9646-48B3-9E | PO3654177498 | 100 | 281 | 359 | 435 | 4 | 2024-08-23 | 5507.98 | 137.70 | 2024-08-11 | 4 | 1251.98 | 1 | 5507.98 | 39 | SO69536 | 2024-08-18 | 440.64 | 5007.93 | 1376.99 | |||
| SO50282_16 | 9C0C-42E0-B6 | PO6525160235 | 100 | 281 | 360 | 345 | 4 | 2023-08-23 | 4917.84 | 122.95 | 2023-08-11 | 4 | 1105.81 | 1 | 4917.84 | 16 | SO50282 | 2023-08-18 | 393.43 | 4423.24 | 1229.46 | |||
| SO44795_8 | 629B-45A2-8B | PO7569171528 | 100 | 287 | 288 | 608 | 4 | 2022-03-25 | 722.59 | 18.06 | 2022-03-13 | 1 | 623.84 | 1 | 722.59 | 8 | SO44795 | 2022-03-20 | 57.81 | 623.84 | 722.59 | |||
| SO51121_3 | 9E4C-40B6-B1 | PO10730114575 | 100 | 287 | 440 | 491 | 4 | 2023-10-23 | 2576.70 | 64.42 | 2023-10-11 | 3 | 868.63 | 1 | 2576.70 | 3 | SO51121 | 2023-10-18 | 206.14 | 2605.90 | 858.90 | |||
| SO45813_2 | 36A5-446C-96 | PO7859120230 | 100 | 287 | 326 | 221 | 4 | 2022-07-24 | 2097.29 | 52.43 | 2022-07-12 | 5 | 413.15 | 1 | 2097.29 | 2 | SO45813 | 2022-07-19 | 167.78 | 2065.73 | 419.46 | |||
| SO50214_28 | 97D5-41D3-8F | PO15196120916 | 100 | 282 | 373 | 258 | 4 | 2023-08-23 | 3926.81 | 98.17 | 2023-08-11 | 3 | 1320.68 | 1 | 3926.81 | 28 | SO50214 | 2023-08-18 | 314.15 | 3962.05 | 1308.94 | |||
| SO59034_2 | 44AD-4786-BA | PO3770195498 | 100 | 282 | 515 | 151 | 4 | 2024-03-24 | 16.27 | 0.41 | 2024-03-12 | 1 | 12.04 | 1 | 16.27 | 2 | SO59034 | 2024-03-19 | 1.30 | 12.04 | 16.27 | |||
| SO48375_10 | B5F1-4C2A-94 | PO5597156214 | 100 | 283 | 308 | 75 | 4 | 2023-03-25 | 744.27 | 18.61 | 2023-03-13 | 1 | 660.91 | 1 | 744.27 | 10 | SO48375 | 2023-03-20 | 59.54 | 660.91 | 744.27 | |||
| SO67292_10 | 09EF-4688-BB | PO551144976 | 100 | 281 | 434 | 4 | 4 | 2024-07-24 | 356.90 | 8.92 | 2024-07-12 | 1 | 360.94 | 1 | 356.90 | 10 | SO67292 | 2024-07-19 | 28.55 | 360.94 | 356.90 | |||
| SO49058_17 | BD1B-4C7F-A9 | PO12499147561 | 100 | 282 | 369 | 78 | 4 | 2023-05-26 | 7330.05 | 183.25 | 2023-05-14 | 5 | 1518.79 | 1 | 7330.05 | 17 | SO49058 | 2023-05-21 | 586.40 | 7593.93 | 1466.01 | |||
| SO47422_54 | 9D8D-4481-B6 | PO3915123127 | 100 | 283 | 216 | 130 | 4 | 2022-12-24 | 80.75 | 2.02 | 2022-12-12 | 4 | 13.88 | 1 | 80.75 | 54 | SO47422 | 2022-12-19 | 6.46 | 55.51 | 20.19 | |||
| SO49127_23 | 01A1-43AB-A2 | PO3480145572 | 100 | 272 | 375 | 436 | 4 | 2023-05-26 | 1308.94 | 32.72 | 2023-05-14 | 1 | 1320.68 | 1 | 1308.94 | 23 | SO49127 | 2023-05-21 | 104.72 | 1320.68 | 1308.94 | |||
| SO53470_6 | 932B-41E0-AF | PO17052111209 | 100 | 282 | 564 | 14 | 420 | 4 | 1525.80 | 2023-12-24 | 7629.02 | 152.58 | 2023-12-12 | 8 | 1481.94 | 1 | 6103.22 | 6 | SO53470 | 2023-12-19 | 488.26 | 11855.50 | 953.63 | 0.20 |
| SO48012_5 | AF9F-4901-9E | PO12499156458 | 100 | 282 | 343 | 78 | 4 | 2023-02-23 | 1409.38 | 35.23 | 2023-02-11 | 3 | 486.71 | 1 | 1409.38 | 5 | SO48012 | 2023-02-18 | 112.75 | 1460.12 | 469.79 | |||
| SO48012_47 | AF9F-4901-9E | PO12499156458 | 100 | 282 | 263 | 78 | 4 | 2023-02-23 | 607.00 | 15.17 | 2023-02-11 | 3 | 187.16 | 1 | 607.00 | 47 | SO48012 | 2023-02-18 | 48.56 | 561.47 | 202.33 | |||
| SO69515_10 | D9C1-4837-A7 | PO6351170694 | 100 | 281 | 374 | 255 | 4 | 2024-08-23 | 2932.02 | 73.30 | 2024-08-11 | 2 | 1554.95 | 1 | 2932.02 | 10 | SO69515 | 2024-08-18 | 234.56 | 3109.90 | 1466.01 | |||
| SO48769_32 | A39E-4380-A6 | PO7859190388 | 100 | 287 | 224 | 221 | 4 | 2023-04-25 | 15.56 | 0.39 | 2023-04-13 | 3 | 5.23 | 1 | 15.56 | 32 | SO48769 | 2023-04-20 | 1.24 | 15.69 | 5.19 | |||
| SO48384_26 | C99C-4AEC-9E | PO7569115185 | 100 | 287 | 395 | 608 | 4 | 2023-03-25 | 552.37 | 13.81 | 2023-03-13 | 9 | 45.42 | 1 | 552.37 | 26 | SO48384 | 2023-03-20 | 44.19 | 408.75 | 61.37 | |||
| SO50748_8 | 5FBE-4B52-B2 | PO6786143310 | 100 | 281 | 435 | 3 | 4 | 2023-09-23 | 648.91 | 16.22 | 2023-09-11 | 2 | 300.12 | 1 | 648.91 | 8 | SO50748 | 2023-09-18 | 51.91 | 600.24 | 324.45 | |||
| SO59013_30 | C224-4535-BA | PO5597199820 | 100 | 281 | 474 | 75 | 4 | 2024-03-24 | 83.99 | 2.10 | 2024-03-12 | 2 | 26.18 | 1 | 83.99 | 30 | SO59013 | 2024-03-19 | 6.72 | 52.35 | 41.99 | |||
| SO46374_7 | 67B2-494E-90 | PO5597118034 | 100 | 283 | 235 | 75 | 4 | 2022-09-23 | 57.68 | 1.44 | 2022-09-11 | 2 | 31.72 | 1 | 57.68 | 7 | SO46374 | 2022-09-18 | 4.61 | 63.45 | 28.84 | |||
| SO53531_26 | B1FB-47B2-8E | PO2697181370 | 100 | 282 | 359 | 187 | 4 | 2023-12-24 | 4130.98 | 103.27 | 2023-12-12 | 3 | 1251.98 | 1 | 4130.98 | 26 | SO53531 | 2023-12-19 | 330.48 | 3755.94 | 1376.99 | |||
| SO48311_55 | AAD7-4EBC-A1 | PO16472177233 | 100 | 287 | 414 | 239 | 4 | 2023-03-25 | 298.06 | 7.45 | 2023-03-13 | 2 | 110.28 | 1 | 298.06 | 55 | SO48311 | 2023-03-20 | 23.85 | 220.57 | 149.03 | |||
| SO46082_6 | E8B4-45CF-8C | PO3799169418 | 100 | 282 | 296 | 312 | 4 | 2022-08-23 | 714.70 | 17.87 | 2022-08-11 | 1 | 617.03 | 1 | 714.70 | 6 | SO46082 | 2022-08-18 | 57.18 | 617.03 | 714.70 | |||
| SO49457_1 | AB73-4D64-A7 | PO15979195348 | 100 | 282 | 399 | 349 | 4 | 2023-06-23 | 67.55 | 1.69 | 2023-06-11 | 2 | 24.99 | 1 | 67.55 | 1 | SO49457 | 2023-06-18 | 5.40 | 49.99 | 33.77 | |||
| SO57145_30 | 4C59-4193-B1 | PO3654153385 | 100 | 281 | 514 | 435 | 4 | 2024-02-23 | 191.70 | 4.79 | 2024-02-11 | 3 | 47.29 | 1 | 191.70 | 30 | SO57145 | 2024-02-18 | 15.34 | 141.86 | 63.90 | |||
| SO51121_36 | 9E4C-40B6-B1 | PO10730114575 | 100 | 287 | 418 | 491 | 4 | 2023-10-23 | 1070.69 | 26.77 | 2023-10-11 | 3 | 360.94 | 1 | 1070.69 | 36 | SO51121 | 2023-10-18 | 85.66 | 1082.83 | 356.90 | |||
| SO50672_10 | 1BE9-437C-8A | PO16472110144 | 100 | 287 | 273 | 239 | 4 | 2023-09-23 | 1011.66 | 25.29 | 2023-09-11 | 5 | 187.16 | 1 | 1011.66 | 10 | SO50672 | 2023-09-18 | 80.93 | 935.79 | 202.33 | |||
| SO59068_24 | B7CC-4A9D-86 | PO9715112509 | 100 | 281 | 353 | 490 | 4 | 2024-03-24 | 2783.99 | 69.60 | 2024-03-12 | 2 | 1265.62 | 1 | 2783.99 | 24 | SO59068 | 2024-03-19 | 222.72 | 2531.24 | 1391.99 | |||
| SO49832_20 | 3280-41FF-A3 | PO13659150841 | 100 | 287 | 367 | 437 | 4 | 2023-07-24 | 1295.99 | 32.40 | 2023-07-12 | 2 | 598.44 | 1 | 1295.99 | 20 | SO49832 | 2023-07-19 | 103.68 | 1196.87 | 647.99 | |||
| SO48740_15 | 158B-4BBF-9F | PO551143768 | 100 | 281 | 385 | 4 | 4 | 2023-04-25 | 1800.79 | 45.02 | 2023-04-13 | 3 | 605.65 | 1 | 1800.79 | 15 | SO48740 | 2023-04-20 | 144.06 | 1816.95 | 600.26 | |||
| SO47712_20 | 299D-4C8A-BF | PO5626117491 | 100 | 283 | 377 | 166 | 4 | 2023-01-23 | 2617.88 | 65.45 | 2023-01-11 | 2 | 1320.68 | 1 | 2617.88 | 20 | SO47712 | 2023-01-18 | 209.43 | 2641.37 | 1308.94 | |||
| SO46964_54 | B3E6-43CC-A2 | PO15689139014 | 100 | 283 | 371 | 328 | 4 | 2022-11-23 | 3926.81 | 98.17 | 2022-11-11 | 3 | 1320.68 | 1 | 3926.81 | 54 | SO46964 | 2022-11-18 | 314.15 | 3962.05 | 1308.94 | |||
| SO58909_28 | EBC4-496C-90 | PO19343180161 | 100 | 282 | 225 | 24 | 4 | 2024-03-24 | 48.55 | 1.21 | 2024-03-12 | 9 | 6.92 | 1 | 48.55 | 28 | SO58909 | 2024-03-19 | 3.88 | 62.30 | 5.39 | |||
| SO50208_13 | 6993-49B4-8B | PO15689114248 | 100 | 281 | 233 | 328 | 4 | 2023-08-23 | 115.36 | 2.88 | 2023-08-11 | 4 | 29.08 | 1 | 115.36 | 13 | SO50208 | 2023-08-18 | 9.23 | 116.32 | 28.84 | |||
| SO57128_12 | 52E0-4277-80 | PO6525176590 | 100 | 281 | 476 | 345 | 4 | 2024-02-23 | 83.99 | 2.10 | 2024-02-11 | 2 | 26.18 | 1 | 83.99 | 12 | SO57128 | 2024-02-18 | 6.72 | 52.35 | 41.99 | |||
| SO47990_41 | 7D80-4D9E-9A | PO15689162700 | 100 | 283 | 381 | 328 | 4 | 2023-02-23 | 4201.84 | 105.05 | 2023-02-11 | 7 | 605.65 | 1 | 4201.84 | 41 | SO47990 | 2023-02-18 | 336.15 | 4239.54 | 600.26 | |||
| SO51722_8 | 735D-4C32-A1 | PO15196144426 | 100 | 282 | 545 | 258 | 4 | 2023-11-23 | 121.47 | 3.04 | 2023-11-11 | 5 | 17.98 | 1 | 121.47 | 8 | SO51722 | 2023-11-18 | 9.72 | 89.89 | 24.29 | |||
| SO48375_43 | B5F1-4C2A-94 | PO5597156214 | 100 | 283 | 469 | 75 | 4 | 2023-03-25 | 136.76 | 3.42 | 2023-03-13 | 6 | 15.67 | 1 | 136.76 | 43 | SO48375 | 2023-03-20 | 10.94 | 94.03 | 22.79 | |||
| SO69486_1 | 6CD1-406A-B1 | PO15747152209 | 100 | 281 | 606 | 471 | 4 | 2024-08-23 | 323.99 | 8.10 | 2024-08-11 | 1 | 343.65 | 1 | 323.99 | 1 | SO69486 | 2024-08-18 | 25.92 | 343.65 | 323.99 | |||
| SO71859_5 | 326E-4365-A3 | PO16182112142 | 100 | 287 | 491 | 23 | 4 | 2024-09-23 | 64.79 | 1.62 | 2024-09-11 | 2 | 41.57 | 1 | 64.79 | 5 | SO71859 | 2024-09-18 | 5.18 | 83.14 | 32.39 | |||
| SO50663_38 | 286E-4915-89 | PO19343130555 | 100 | 282 | 381 | 24 | 4 | 2023-09-23 | 2401.05 | 60.03 | 2023-09-11 | 4 | 605.65 | 1 | 2401.05 | 38 | SO50663 | 2023-09-18 | 192.08 | 2422.60 | 600.26 | |||
| SO67279_22 | 5395-4C5C-A0 | PO12528190770 | 100 | 282 | 572 | 331 | 4 | 2024-07-24 | 445.41 | 11.14 | 2024-07-12 | 1 | 461.44 | 1 | 445.41 | 22 | SO67279 | 2024-07-19 | 35.63 | 461.44 | 445.41 | |||
| SO67273_33 | 9BAE-4E69-B9 | PO13688176638 | 100 | 282 | 594 | 475 | 4 | 2024-07-24 | 338.99 | 8.47 | 2024-07-12 | 1 | 308.22 | 1 | 338.99 | 33 | SO67273 | 2024-07-19 | 27.12 | 308.22 | 338.99 | |||
| SO53539_9 | 2B21-4FAC-8C | PO18763121730 | 100 | 287 | 603 | 59 | 4 | 2023-12-24 | 145.79 | 3.64 | 2023-12-12 | 2 | 53.94 | 1 | 145.79 | 9 | SO53539 | 2023-12-19 | 11.66 | 107.88 | 72.89 | |||
| SO69545_36 | 2C06-44D9-96 | PO3480123333 | 100 | 272 | 484 | 436 | 4 | 2024-08-23 | 4.77 | 0.12 | 2024-08-11 | 1 | 2.97 | 1 | 4.77 | 36 | SO69545 | 2024-08-18 | 0.38 | 2.97 | 4.77 | |||
| SO63243_1 | 673E-4AB8-BF | PO7540138097 | 100 | 281 | 579 | 607 | 4 | 2024-05-25 | 728.91 | 18.22 | 2024-05-13 | 1 | 755.15 | 1 | 728.91 | 1 | SO63243 | 2024-05-20 | 58.31 | 755.15 | 728.91 | |||
| SO53589_2 | C92F-4DDF-B6 | PO4582196134 | 100 | 282 | 544 | 25 | 4 | 2023-12-24 | 48.59 | 1.21 | 2023-12-12 | 1 | 35.96 | 1 | 48.59 | 2 | SO53589 | 2023-12-19 | 3.89 | 35.96 | 48.59 | |||
| SO49058_23 | BD1B-4C7F-A9 | PO12499147561 | 100 | 282 | 456 | 78 | 4 | 2023-05-26 | 134.98 | 3.37 | 2023-05-14 | 3 | 30.93 | 1 | 134.98 | 23 | SO49058 | 2023-05-21 | 10.80 | 92.80 | 44.99 | |||
| SO50266_6 | 5A1A-4C41-B9 | PO15921150902 | 100 | 287 | 422 | 77 | 4 | 2023-08-23 | 67.54 | 1.69 | 2023-08-11 | 1 | 49.98 | 1 | 67.54 | 6 | SO50266 | 2023-08-18 | 5.40 | 49.98 | 67.54 | |||
| SO51102_13 | F2B1-4561-84 | PO13659193365 | 100 | 287 | 591 | 437 | 4 | 2023-10-23 | 677.99 | 16.95 | 2023-10-11 | 2 | 308.22 | 1 | 677.99 | 13 | SO51102 | 2023-10-18 | 54.24 | 616.44 | 338.99 | |||
| SO67287_9 | 3F1F-44DB-96 | PO10730119334 | 100 | 287 | 481 | 491 | 4 | 2024-07-24 | 21.58 | 0.54 | 2024-07-12 | 4 | 3.36 | 1 | 21.58 | 9 | SO67287 | 2024-07-19 | 1.73 | 13.45 | 5.39 | |||
| SO47369_31 | B6B6-442B-8B | PO16472118462 | 100 | 287 | 429 | 239 | 4 | 2022-12-24 | 973.36 | 24.33 | 2022-12-12 | 3 | 300.12 | 1 | 973.36 | 31 | SO47369 | 2022-12-19 | 77.87 | 900.36 | 324.45 | |||
| SO44768_17 | 18BD-48B8-95 | PO261164909 | 100 | 283 | 272 | 647 | 4 | 2022-03-25 | 183.94 | 4.60 | 2022-03-13 | 1 | 181.49 | 1 | 183.94 | 17 | SO44768 | 2022-03-20 | 14.72 | 181.49 | 183.94 | |||
| SO71783_22 | 7E03-4B8A-BA | PO19343113609 | 100 | 282 | 491 | 24 | 4 | 2024-09-23 | 291.55 | 7.29 | 2024-09-11 | 9 | 41.57 | 1 | 291.55 | 22 | SO71783 | 2024-09-18 | 23.32 | 374.15 | 32.39 | |||
| SO45301_14 | 0BA8-4928-A7 | PO12499190711 | 100 | 282 | 328 | 78 | 4 | 2022-05-26 | 1258.38 | 31.46 | 2022-05-14 | 3 | 413.15 | 1 | 1258.38 | 14 | SO45301 | 2022-05-21 | 100.67 | 1239.44 | 419.46 | |||
| SO46638_12 | 9659-44CE-A2 | PO10817110834 | 100 | 287 | 236 | 203 | 4 | 2022-10-23 | 115.36 | 2.88 | 2022-10-11 | 4 | 29.08 | 1 | 115.36 | 12 | SO46638 | 2022-10-18 | 9.23 | 116.32 | 28.84 | |||
| SO69466_12 | 8B97-4CC6-8A | PO2523169620 | 100 | 287 | 380 | 167 | 4 | 2024-08-23 | 1466.01 | 36.65 | 2024-08-11 | 1 | 1554.95 | 1 | 1466.01 | 12 | SO69466 | 2024-08-18 | 117.28 | 1554.95 | 1466.01 | |||
| SO49160_17 | 60E2-486C-AE | PO7656113690 | 100 | 282 | 224 | 403 | 4 | 2023-05-26 | 15.56 | 0.39 | 2023-05-14 | 3 | 5.23 | 1 | 15.56 | 17 | SO49160 | 2023-05-21 | 1.24 | 15.69 | 5.19 |
Generated 2024-11-10 11:54:41.542 UTC