[ROOT] dt FactResellerSale < WHERE DimSalesTerritoryId EQ '4' > SHUFFLE < SKIP 642 > < 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 |
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
| SO69532_31 | 27FB-4A86-85 | PO3799165791 | 100 | 282 | 588 | 312 | 4 | 2024-08-26 | 2308.47 | 57.71 | 2024-08-14 | 5 | 419.78 | 1 | 2308.47 | 31 | SO69532 | 2024-08-21 | 184.68 | 2098.89 | 461.69 | |||
| SO44755_23 | 3B0A-428C-99 | PO15167120207 | 100 | 283 | 324 | 273 | 4 | 2022-03-28 | 838.92 | 20.97 | 2022-03-16 | 2 | 413.15 | 1 | 838.92 | 23 | SO44755 | 2022-03-23 | 67.11 | 826.29 | 419.46 | |||
| SO55296_3 | 7C52-4939-AE | PO6380144343 | 100 | 281 | 501 | 597 | 4 | 2024-01-26 | 145.75 | 3.64 | 2024-01-14 | 2 | 53.93 | 1 | 145.75 | 3 | SO55296 | 2024-01-21 | 11.66 | 107.86 | 72.88 | |||
| SO44113_10 | B9C7-4334-81 | PO2697181021 | 100 | 282 | 232 | 187 | 4 | 2021-12-27 | 230.72 | 5.77 | 2021-12-15 | 8 | 31.72 | 1 | 230.72 | 10 | SO44113 | 2021-12-22 | 18.46 | 253.80 | 28.84 | |||
| SO71848_6 | 7082-4BF5-AB | PO18763153352 | 100 | 287 | 572 | 59 | 4 | 2024-09-26 | 445.41 | 11.14 | 2024-09-14 | 1 | 461.44 | 1 | 445.41 | 6 | SO71848 | 2024-09-21 | 35.63 | 461.44 | 445.41 | |||
| SO69412_33 | 14B1-47FE-BF | PO15689112657 | 100 | 281 | 372 | 328 | 4 | 2024-08-26 | 5864.04 | 146.60 | 2024-08-14 | 4 | 1554.95 | 1 | 5864.04 | 33 | SO69412 | 2024-08-21 | 469.12 | 6219.79 | 1466.01 | |||
| SO46089_1 | 5E3C-4A0D-BD | PO5684142532 | 100 | 282 | 345 | 385 | 4 | 2022-08-26 | 8159.98 | 204.00 | 2022-08-14 | 4 | 1912.15 | 1 | 8159.98 | 1 | SO46089 | 2022-08-21 | 652.80 | 7648.62 | 2039.99 | |||
| SO49884_33 | 822A-428D-94 | PO5626129805 | 100 | 281 | 280 | 166 | 4 | 2023-07-27 | 183.94 | 4.60 | 2023-07-15 | 1 | 170.14 | 1 | 183.94 | 33 | SO49884 | 2023-07-22 | 14.72 | 170.14 | 183.94 | |||
| SO67279_16 | 5395-4C5C-A0 | PO12528190770 | 100 | 282 | 552 | 331 | 4 | 2024-07-27 | 274.47 | 6.86 | 2024-07-15 | 5 | 40.62 | 1 | 274.47 | 16 | SO67279 | 2024-07-22 | 21.96 | 203.11 | 54.89 | |||
| SO53531_4 | B1FB-47B2-8E | PO2697181370 | 100 | 282 | 593 | 187 | 4 | 2023-12-27 | 1016.98 | 25.42 | 2023-12-15 | 3 | 308.22 | 1 | 1016.98 | 4 | SO53531 | 2023-12-22 | 81.36 | 924.65 | 338.99 | |||
| SO48049_32 | C09A-49F5-80 | PO3799136256 | 100 | 282 | 352 | 312 | 4 | 2023-02-26 | 4971.41 | 124.29 | 2023-02-14 | 4 | 1117.86 | 1 | 4971.41 | 32 | SO48049 | 2023-02-21 | 397.71 | 4471.42 | 1242.85 | |||
| SO50249_12 | 72CA-4901-8D | PO2320117235 | 100 | 282 | 280 | 529 | 4 | 2023-08-26 | 183.94 | 4.60 | 2023-08-14 | 1 | 170.14 | 1 | 183.94 | 12 | SO50249 | 2023-08-21 | 14.72 | 170.14 | 183.94 | |||
| SO67273_15 | 9BAE-4E69-B9 | PO13688176638 | 100 | 282 | 357 | 475 | 4 | 2024-07-27 | 4175.98 | 104.40 | 2024-07-15 | 3 | 1265.62 | 1 | 4175.98 | 15 | SO67273 | 2024-07-22 | 334.08 | 3796.86 | 1391.99 | |||
| SO65269_16 | 999D-45C9-AA | PO4640162431 | 100 | 287 | 599 | 648 | 4 | 2024-06-26 | 323.99 | 8.10 | 2024-06-14 | 1 | 294.58 | 1 | 323.99 | 16 | SO65269 | 2024-06-21 | 25.92 | 294.58 | 323.99 | |||
| SO51122_29 | D915-4225-97 | PO551181465 | 100 | 281 | 583 | 4 | 4 | 2023-10-26 | 3061.78 | 76.54 | 2023-10-14 | 3 | 1082.51 | 1 | 3061.78 | 29 | SO51122 | 2023-10-21 | 244.94 | 3247.53 | 1020.59 | |||
| SO46965_12 | C9A7-4125-95 | PO15921113146 | 100 | 287 | 422 | 77 | 4 | 2022-11-26 | 202.62 | 5.07 | 2022-11-14 | 3 | 49.98 | 1 | 202.62 | 12 | SO46965 | 2022-11-21 | 16.21 | 149.94 | 67.54 | |||
| SO57168_42 | B6D5-41ED-B9 | PO3480129742 | 100 | 281 | 231 | 436 | 4 | 2024-02-26 | 239.95 | 6.00 | 2024-02-14 | 8 | 38.49 | 1 | 239.95 | 42 | SO57168 | 2024-02-21 | 19.20 | 307.94 | 29.99 | |||
| SO50208_35 | 6993-49B4-8B | PO15689114248 | 100 | 281 | 435 | 328 | 4 | 2023-08-26 | 1622.26 | 40.56 | 2023-08-14 | 5 | 300.12 | 1 | 1622.26 | 35 | SO50208 | 2023-08-21 | 129.78 | 1500.59 | 324.45 | |||
| SO46380_6 | C4E3-4894-81 | PO7569183330 | 100 | 287 | 345 | 7 | 608 | 4 | 595.00 | 2022-09-26 | 1700.00 | 27.62 | 2022-09-14 | 2 | 1912.15 | 1 | 1105.00 | 6 | SO46380 | 2022-09-21 | 88.40 | 3824.31 | 850.00 | 0.35 |
| SO71782_15 | CA08-4A9B-8D | PO19372114749 | 100 | 282 | 601 | 582 | 4 | 2024-09-26 | 32.39 | 0.81 | 2024-09-14 | 1 | 23.97 | 1 | 32.39 | 15 | SO71782 | 2024-09-21 | 2.59 | 23.97 | 32.39 | |||
| SO51121_24 | 9E4C-40B6-B1 | PO10730114575 | 100 | 287 | 234 | 2 | 491 | 4 | 6.38 | 2023-10-26 | 318.94 | 7.81 | 2023-10-14 | 11 | 38.49 | 1 | 312.56 | 24 | SO51121 | 2023-10-21 | 25.00 | 423.42 | 28.99 | 0.02 |
| SO47700_12 | 5C46-42DE-AD | PO2494132198 | 100 | 283 | 360 | 184 | 4 | 2023-01-26 | 4917.84 | 122.95 | 2023-01-14 | 4 | 1105.81 | 1 | 4917.84 | 12 | SO47700 | 2023-01-21 | 393.43 | 4423.24 | 1229.46 | |||
| SO53606_48 | 6A19-463C-B7 | PO5539128997 | 100 | 282 | 477 | 61 | 4 | 2023-12-27 | 20.96 | 0.52 | 2023-12-15 | 7 | 1.87 | 1 | 20.96 | 48 | SO53606 | 2023-12-22 | 1.68 | 13.06 | 2.99 | |||
| SO47369_16 | B6B6-442B-8B | PO16472118462 | 100 | 287 | 423 | 239 | 4 | 2022-12-27 | 660.92 | 16.52 | 2022-12-15 | 4 | 122.27 | 1 | 660.92 | 16 | SO47369 | 2022-12-22 | 52.87 | 489.08 | 165.23 | |||
| SO46364_1 | BC3C-4FE8-AC | PO3248115921 | 100 | 282 | 344 | 7 | 366 | 4 | 595.00 | 2022-09-26 | 1700.00 | 27.62 | 2022-09-14 | 2 | 1912.15 | 1 | 1105.00 | 1 | SO46364 | 2022-09-21 | 88.40 | 3824.31 | 850.00 | 0.35 |
| SO48380_15 | 580B-4A1F-A4 | PO6757155119 | 100 | 283 | 470 | 21 | 4 | 2023-03-28 | 68.38 | 1.71 | 2023-03-16 | 3 | 15.67 | 1 | 68.38 | 15 | SO48380 | 2023-03-23 | 5.47 | 47.01 | 22.79 | |||
| SO61243_20 | 0370-4B1B-9D | PO7859152962 | 100 | 287 | 580 | 221 | 4 | 2024-04-27 | 1020.59 | 25.51 | 2024-04-15 | 1 | 1082.51 | 1 | 1020.59 | 20 | SO61243 | 2024-04-22 | 81.65 | 1082.51 | 1020.59 | |||
| SO51121_51 | 9E4C-40B6-B1 | PO10730114575 | 100 | 287 | 487 | 491 | 4 | 2023-10-26 | 98.98 | 2.47 | 2023-10-14 | 3 | 20.57 | 1 | 98.98 | 51 | SO51121 | 2023-10-21 | 7.92 | 61.70 | 32.99 | |||
| SO45555_14 | B11A-41CE-84 | PO3248155143 | 100 | 282 | 345 | 366 | 4 | 2022-06-26 | 12239.96 | 306.00 | 2022-06-14 | 6 | 1912.15 | 1 | 12239.96 | 14 | SO45555 | 2022-06-21 | 979.20 | 11472.93 | 2039.99 | |||
| SO53496_5 | 5404-4BB1-95 | PO12992153220 | 100 | 282 | 552 | 295 | 4 | 2023-12-27 | 109.79 | 2.74 | 2023-12-15 | 2 | 40.62 | 1 | 109.79 | 5 | SO53496 | 2023-12-22 | 8.78 | 81.24 | 54.89 | |||
| SO43865_13 | 071C-4913-89 | PO15689147174 | 100 | 283 | 324 | 328 | 4 | 2021-11-26 | 1258.38 | 31.46 | 2021-11-14 | 3 | 413.15 | 1 | 1258.38 | 13 | SO43865 | 2021-11-21 | 100.67 | 1239.44 | 419.46 | |||
| SO63251_4 | CA03-47EE-90 | PO6525146360 | 100 | 281 | 517 | 345 | 4 | 2024-05-28 | 31.58 | 0.79 | 2024-05-16 | 1 | 23.37 | 1 | 31.58 | 4 | SO63251 | 2024-05-23 | 2.53 | 23.37 | 31.58 | |||
| SO65167_5 | D40C-4211-94 | PO18125182344 | 100 | 287 | 418 | 311 | 4 | 2024-06-26 | 713.80 | 17.84 | 2024-06-14 | 2 | 360.94 | 1 | 713.80 | 5 | SO65167 | 2024-06-21 | 57.10 | 721.89 | 356.90 | |||
| SO63262_16 | 3368-4317-8F | PO6351144702 | 100 | 281 | 606 | 255 | 4 | 2024-05-28 | 323.99 | 8.10 | 2024-05-16 | 1 | 343.65 | 1 | 323.99 | 16 | SO63262 | 2024-05-23 | 25.92 | 343.65 | 323.99 | |||
| SO48780_8 | F139-41F4-83 | PO5626121558 | 100 | 281 | 271 | 166 | 4 | 2023-04-28 | 1618.66 | 40.47 | 2023-04-16 | 8 | 187.16 | 1 | 1618.66 | 8 | SO48780 | 2023-04-23 | 129.49 | 1497.26 | 202.33 | |||
| SO69417_19 | 6746-4842-AD | PO15196165910 | 100 | 282 | 418 | 258 | 4 | 2024-08-26 | 1070.69 | 26.77 | 2024-08-14 | 3 | 360.94 | 1 | 1070.69 | 19 | SO69417 | 2024-08-21 | 85.66 | 1082.83 | 356.90 | |||
| SO47435_43 | B7A7-4F07-94 | PO5597154214 | 100 | 283 | 356 | 75 | 4 | 2022-12-27 | 4971.41 | 124.29 | 2022-12-15 | 4 | 1117.86 | 1 | 4971.41 | 43 | SO47435 | 2022-12-22 | 397.71 | 4471.42 | 1242.85 | |||
| SO71902_19 | AEC9-4070-9D | PO5539125166 | 100 | 282 | 589 | 61 | 4 | 2024-09-26 | 923.39 | 23.08 | 2024-09-14 | 2 | 419.78 | 1 | 923.39 | 19 | SO71902 | 2024-09-21 | 73.87 | 839.56 | 461.69 | |||
| SO48016_8 | 0FF6-4F4B-B4 | PO11745112366 | 100 | 282 | 321 | 97 | 4 | 2023-02-26 | 469.79 | 11.74 | 2023-02-14 | 1 | 486.71 | 1 | 469.79 | 8 | SO48016 | 2023-02-21 | 37.58 | 486.71 | 469.79 | |||
| SO46970_1 | 01AF-420A-B9 | PO15196114472 | 100 | 282 | 368 | 258 | 4 | 2022-11-26 | 1466.01 | 36.65 | 2022-11-14 | 1 | 1518.79 | 1 | 1466.01 | 1 | SO46970 | 2022-11-21 | 117.28 | 1518.79 | 1466.01 | |||
| SO53490_4 | 48D0-4BD6-8A | PO13717132596 | 100 | 287 | 240 | 473 | 4 | 2023-12-27 | 1717.80 | 42.95 | 2023-12-15 | 2 | 868.63 | 1 | 1717.80 | 4 | SO53490 | 2023-12-22 | 137.42 | 1737.27 | 858.90 | |||
| SO50198_2 | D819-45BD-AA | PO17400169446 | 100 | 282 | 360 | 150 | 4 | 2023-08-26 | 2458.92 | 61.47 | 2023-08-14 | 2 | 1105.81 | 1 | 2458.92 | 2 | SO50198 | 2023-08-21 | 196.71 | 2211.62 | 1229.46 | |||
| SO51764_9 | D5EC-49D5-9F | PO609164065 | 100 | 282 | 474 | 492 | 4 | 2023-11-26 | 167.98 | 4.20 | 2023-11-14 | 4 | 26.18 | 1 | 167.98 | 9 | SO51764 | 2023-11-21 | 13.44 | 104.71 | 41.99 | |||
| SO45571_6 | BAA6-412D-87 | PO7569141774 | 100 | 287 | 351 | 608 | 4 | 2022-06-26 | 4049.99 | 101.25 | 2022-06-14 | 2 | 1898.09 | 1 | 4049.99 | 6 | SO45571 | 2022-06-21 | 324.00 | 3796.19 | 2024.99 | |||
| SO58909_5 | EBC4-496C-90 | PO19343180161 | 100 | 282 | 222 | 24 | 4 | 2024-03-27 | 125.96 | 3.15 | 2024-03-15 | 6 | 13.09 | 1 | 125.96 | 5 | SO58909 | 2024-03-22 | 10.08 | 78.52 | 20.99 | |||
| SO46347_4 | 33F9-487C-A3 | PO13717117301 | 100 | 287 | 272 | 473 | 4 | 2022-09-26 | 183.94 | 4.60 | 2022-09-14 | 1 | 181.49 | 1 | 183.94 | 4 | SO46347 | 2022-09-21 | 14.72 | 181.49 | 183.94 | |||
| SO51090_3 | EBDE-4A71-8E | PO13688110947 | 100 | 282 | 490 | 475 | 4 | 2023-10-26 | 259.15 | 6.48 | 2023-10-14 | 8 | 41.57 | 1 | 259.15 | 3 | SO51090 | 2023-10-21 | 20.73 | 332.58 | 32.39 | |||
| SO51131_59 | D489-4DF3-A2 | PO16298169856 | 100 | 287 | 484 | 3 | 599 | 4 | 4.37 | 2023-10-26 | 87.45 | 2.08 | 2023-10-14 | 20 | 2.97 | 1 | 83.08 | 59 | SO51131 | 2023-10-21 | 6.65 | 59.47 | 4.37 | 0.05 |
Generated 2024-11-13 08:54:35.777 UTC