[ROOT] dt FactResellerSale < WHERE DimSalesTerritoryId EQ '4' > SHUFFLE < SKIP 935 > < 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 |
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
| SO55296_1 | 7C52-4939-AE | PO6380144343 | 100 | 281 | 575 | 597 | 4 | 2024-01-23 | 1430.44 | 35.76 | 2024-01-11 | 1 | 1481.94 | 1 | 1430.44 | 1 | SO55296 | 2024-01-18 | 114.44 | 1481.94 | 1430.44 | |||
| SO61200_12 | 9B44-40EF-86 | PO2755113256 | 100 | 272 | 503 | 205 | 4 | 2024-04-24 | 200.05 | 5.00 | 2024-04-12 | 1 | 199.85 | 1 | 200.05 | 12 | SO61200 | 2024-04-19 | 16.00 | 199.85 | 200.05 | |||
| SO46377_14 | A45C-4A20-BA | PO6786151653 | 100 | 283 | 253 | 3 | 4 | 2022-09-23 | 357.16 | 8.93 | 2022-09-11 | 2 | 176.20 | 1 | 357.16 | 14 | SO46377 | 2022-09-18 | 28.57 | 352.40 | 178.58 | |||
| SO61243_28 | 0370-4B1B-9D | PO7859152962 | 100 | 287 | 214 | 221 | 4 | 2024-04-24 | 41.99 | 1.05 | 2024-04-12 | 2 | 13.09 | 1 | 41.99 | 28 | SO61243 | 2024-04-19 | 3.36 | 26.17 | 20.99 | |||
| SO58995_25 | DA16-4097-96 | PO16269190750 | 100 | 287 | 546 | 624 | 4 | 2024-03-24 | 149.02 | 3.73 | 2024-03-12 | 4 | 27.57 | 1 | 149.02 | 25 | SO58995 | 2024-03-19 | 11.92 | 110.27 | 37.25 | |||
| SO48356_5 | 3E64-467F-90 | PO2697152207 | 100 | 282 | 393 | 187 | 4 | 2023-03-25 | 826.16 | 20.65 | 2023-03-13 | 6 | 101.89 | 1 | 826.16 | 5 | SO48356 | 2023-03-20 | 66.09 | 611.36 | 137.69 | |||
| SO49481_29 | 474A-4DD1-9B | PO10701112208 | 100 | 282 | 356 | 133 | 4 | 2023-06-23 | 2485.70 | 62.14 | 2023-06-11 | 2 | 1117.86 | 1 | 2485.70 | 29 | SO49481 | 2023-06-18 | 198.86 | 2235.71 | 1242.85 | |||
| SO43678_11 | FBD8-4CE4-8B | PO10817150168 | 100 | 287 | 262 | 203 | 4 | 2021-10-23 | 367.88 | 9.20 | 2021-10-11 | 2 | 181.49 | 1 | 367.88 | 11 | SO43678 | 2021-10-18 | 29.43 | 362.97 | 183.94 | |||
| SO63280_16 | C73E-4203-80 | PO3654118854 | 100 | 281 | 531 | 435 | 4 | 2024-05-25 | 449.62 | 11.24 | 2024-05-13 | 3 | 136.79 | 1 | 449.62 | 16 | SO63280 | 2024-05-20 | 35.97 | 410.36 | 149.87 | |||
| SO45531_2 | A56B-4056-BC | PO15950134053 | 100 | 282 | 319 | 114 | 4 | 2022-06-23 | 874.79 | 21.87 | 2022-06-11 | 1 | 884.71 | 1 | 874.79 | 2 | SO45531 | 2022-06-18 | 69.98 | 884.71 | 874.79 | |||
| SO53606_26 | 6A19-463C-B7 | PO5539128997 | 100 | 282 | 544 | 61 | 4 | 2023-12-24 | 145.78 | 3.64 | 2023-12-12 | 3 | 35.96 | 1 | 145.78 | 26 | SO53606 | 2023-12-19 | 11.66 | 107.88 | 48.59 | |||
| SO46058_27 | FA37-4F46-97 | PO12557123934 | 100 | 282 | 235 | 240 | 4 | 2022-08-23 | 28.84 | 0.72 | 2022-08-11 | 1 | 31.72 | 1 | 28.84 | 27 | SO46058 | 2022-08-18 | 2.31 | 31.72 | 28.84 | |||
| SO53538_11 | D7FE-4E54-BD | PO18125134677 | 100 | 287 | 246 | 311 | 4 | 2023-12-24 | 2576.70 | 64.42 | 2023-12-12 | 3 | 868.63 | 1 | 2576.70 | 11 | SO53538 | 2023-12-19 | 206.14 | 2605.90 | 858.90 | |||
| SO48780_22 | F139-41F4-83 | PO5626121558 | 100 | 281 | 254 | 166 | 4 | 2023-04-25 | 551.81 | 13.80 | 2023-04-13 | 3 | 170.14 | 1 | 551.81 | 22 | SO48780 | 2023-04-20 | 44.15 | 510.43 | 183.94 | |||
| SO71881_19 | 8EDF-4F9F-97 | PO6757112103 | 100 | 281 | 516 | 21 | 4 | 2024-09-23 | 70.45 | 1.76 | 2024-09-11 | 3 | 17.38 | 1 | 70.45 | 19 | SO71881 | 2024-09-18 | 5.64 | 52.13 | 23.48 | |||
| SO51773_17 | 14B1-48BF-A0 | PO2523163173 | 100 | 287 | 482 | 167 | 4 | 2023-11-23 | 16.18 | 0.40 | 2023-11-11 | 3 | 3.36 | 1 | 16.18 | 17 | SO51773 | 2023-11-18 | 1.29 | 10.09 | 5.39 | |||
| SO69466_25 | 8B97-4CC6-8A | PO2523169620 | 100 | 287 | 234 | 167 | 4 | 2024-08-23 | 119.98 | 3.00 | 2024-08-11 | 4 | 38.49 | 1 | 119.98 | 25 | SO69466 | 2024-08-18 | 9.60 | 153.97 | 29.99 | |||
| SO59023_39 | 9975-4F2A-A7 | PO5539149469 | 100 | 282 | 474 | 61 | 4 | 2024-03-24 | 293.96 | 7.35 | 2024-03-12 | 7 | 26.18 | 1 | 293.96 | 39 | SO59023 | 2024-03-19 | 23.52 | 183.23 | 41.99 | |||
| SO55249_51 | 0527-4C9D-BA | PO13688172507 | 100 | 282 | 306 | 475 | 4 | 2024-01-23 | 809.76 | 20.24 | 2024-01-11 | 1 | 739.04 | 1 | 809.76 | 51 | SO55249 | 2024-01-18 | 64.78 | 739.04 | 809.76 | |||
| SO44314_15 | 6FDF-4206-A7 | PO5626111923 | 100 | 283 | 241 | 166 | 4 | 2022-01-23 | 758.08 | 18.95 | 2022-01-11 | 1 | 747.97 | 1 | 758.08 | 15 | SO44314 | 2022-01-18 | 60.65 | 747.97 | 758.08 | |||
| SO69412_23 | 14B1-47FE-BF | PO15689112657 | 100 | 281 | 481 | 328 | 4 | 2024-08-23 | 32.36 | 0.81 | 2024-08-11 | 6 | 3.36 | 1 | 32.36 | 23 | SO69412 | 2024-08-18 | 2.59 | 20.17 | 5.39 | |||
| SO47434_2 | 6848-4C33-98 | PO5539145068 | 100 | 282 | 356 | 61 | 4 | 2022-12-24 | 4971.41 | 124.29 | 2022-12-12 | 4 | 1117.86 | 1 | 4971.41 | 2 | SO47434 | 2022-12-19 | 397.71 | 4471.42 | 1242.85 | |||
| SO47990_37 | 7D80-4D9E-9A | PO15689162700 | 100 | 283 | 321 | 328 | 4 | 2023-02-23 | 1879.18 | 46.98 | 2023-02-11 | 4 | 486.71 | 1 | 1879.18 | 37 | SO47990 | 2023-02-18 | 150.33 | 1946.83 | 469.79 | |||
| SO45301_5 | 0BA8-4928-A7 | PO12499190711 | 100 | 282 | 212 | 78 | 4 | 2022-05-26 | 20.19 | 0.50 | 2022-05-14 | 1 | 12.03 | 1 | 20.19 | 5 | SO45301 | 2022-05-21 | 1.61 | 12.03 | 20.19 | |||
| SO43901_4 | 5FDB-4B73-97 | PO5684189260 | 100 | 282 | 344 | 385 | 4 | 2021-11-23 | 4079.99 | 102.00 | 2021-11-11 | 2 | 1912.15 | 1 | 4079.99 | 4 | SO43901 | 2021-11-18 | 326.40 | 3824.31 | 2039.99 | |||
| SO47711_2 | F428-41EA-8E | PO5394123420 | 100 | 283 | 468 | 94 | 4 | 2023-01-23 | 22.79 | 0.57 | 2023-01-11 | 1 | 15.67 | 1 | 22.79 | 2 | SO47711 | 2023-01-18 | 1.82 | 15.67 | 22.79 | |||
| SO71902_3 | AEC9-4070-9D | PO5539125166 | 100 | 282 | 511 | 61 | 4 | 2024-09-23 | 218.45 | 5.46 | 2024-09-11 | 1 | 199.38 | 1 | 218.45 | 3 | SO71902 | 2024-09-18 | 17.48 | 199.38 | 218.45 | |||
| SO44314_17 | 6FDF-4206-A7 | PO5626111923 | 100 | 283 | 279 | 166 | 4 | 2022-01-23 | 178.58 | 4.46 | 2022-01-11 | 1 | 176.20 | 1 | 178.58 | 17 | SO44314 | 2022-01-18 | 14.29 | 176.20 | 178.58 | |||
| SO65167_1 | D40C-4211-94 | PO18125182344 | 100 | 287 | 384 | 311 | 4 | 2024-06-23 | 1344.59 | 33.61 | 2024-06-11 | 2 | 713.08 | 1 | 1344.59 | 1 | SO65167 | 2024-06-18 | 107.57 | 1426.16 | 672.29 | |||
| SO44557_12 | 2D19-4C49-B1 | PO6351122593 | 100 | 283 | 253 | 255 | 4 | 2022-02-23 | 178.58 | 4.46 | 2022-02-11 | 1 | 176.20 | 1 | 178.58 | 12 | SO44557 | 2022-02-18 | 14.29 | 176.20 | 178.58 | |||
| SO49884_17 | 822A-428D-94 | PO5626129805 | 100 | 281 | 439 | 166 | 4 | 2023-07-24 | 3904.09 | 97.60 | 2023-07-12 | 5 | 722.26 | 1 | 3904.09 | 17 | SO49884 | 2023-07-19 | 312.33 | 3611.28 | 780.82 | |||
| SO63283_16 | 5DCA-44B0-BB | PO3799140598 | 100 | 282 | 355 | 312 | 4 | 2024-05-25 | 11135.95 | 278.40 | 2024-05-13 | 8 | 1265.62 | 1 | 11135.95 | 16 | SO63283 | 2024-05-20 | 890.88 | 10124.96 | 1391.99 | |||
| SO44127_6 | E778-471D-8A | PO7569162058 | 100 | 287 | 220 | 608 | 4 | 2021-12-24 | 40.37 | 1.01 | 2021-12-12 | 2 | 12.03 | 1 | 40.37 | 6 | SO44127 | 2021-12-19 | 3.23 | 24.06 | 20.19 | |||
| SO45568_1 | 32F9-4A87-9D | PO6786144925 | 100 | 283 | 342 | 3 | 4 | 2022-06-23 | 419.46 | 10.49 | 2022-06-11 | 1 | 413.15 | 1 | 419.46 | 1 | SO45568 | 2022-06-18 | 33.56 | 413.15 | 419.46 | |||
| SO48070_1 | 47A2-4D32-A7 | PO6351123191 | 100 | 283 | 254 | 255 | 4 | 2023-02-23 | 183.94 | 4.60 | 2023-02-11 | 1 | 170.14 | 1 | 183.94 | 1 | SO48070 | 2023-02-18 | 14.72 | 170.14 | 183.94 | |||
| SO71896_23 | A37A-4B16-B0 | PO4640135042 | 100 | 287 | 593 | 16 | 648 | 4 | 45.20 | 2024-09-23 | 113.00 | 1.70 | 2024-09-11 | 1 | 308.22 | 1 | 67.80 | 23 | SO71896 | 2024-09-18 | 5.42 | 308.22 | 113.00 | 0.40 |
| SO71902_25 | AEC9-4070-9D | PO5539125166 | 100 | 282 | 477 | 61 | 4 | 2024-09-23 | 20.96 | 0.52 | 2024-09-11 | 7 | 1.87 | 1 | 20.96 | 25 | SO71902 | 2024-09-18 | 1.68 | 13.06 | 2.99 | |||
| SO48769_2 | A39E-4380-A6 | PO7859190388 | 100 | 287 | 460 | 221 | 4 | 2023-04-25 | 161.98 | 4.05 | 2023-04-13 | 3 | 37.12 | 1 | 161.98 | 2 | SO48769 | 2023-04-20 | 12.96 | 111.36 | 53.99 | |||
| SO48071_9 | E6F7-41F8-92 | PO6525193011 | 100 | 283 | 365 | 345 | 4 | 2023-02-23 | 1943.98 | 48.60 | 2023-02-11 | 3 | 598.44 | 1 | 1943.98 | 9 | SO48071 | 2023-02-18 | 155.52 | 1795.31 | 647.99 | |||
| SO53459_6 | 9828-4F27-B0 | PO19372154638 | 100 | 282 | 555 | 582 | 4 | 2023-12-24 | 319.50 | 7.99 | 2023-12-12 | 5 | 47.29 | 1 | 319.50 | 6 | SO53459 | 2023-12-19 | 25.56 | 236.43 | 63.90 | |||
| SO44557_10 | 2D19-4C49-B1 | PO6351122593 | 100 | 283 | 342 | 255 | 4 | 2022-02-23 | 419.46 | 10.49 | 2022-02-11 | 1 | 413.15 | 1 | 419.46 | 10 | SO44557 | 2022-02-18 | 33.56 | 413.15 | 419.46 | |||
| SO65232_20 | 3D4B-4E94-8F | PO9715132845 | 100 | 281 | 363 | 490 | 4 | 2024-06-23 | 4130.98 | 103.27 | 2024-06-11 | 3 | 1251.98 | 1 | 4130.98 | 20 | SO65232 | 2024-06-18 | 330.48 | 3755.94 | 1376.99 | |||
| SO48341_10 | A747-471B-97 | PO10701176180 | 100 | 282 | 354 | 133 | 4 | 2023-03-25 | 3728.56 | 93.21 | 2023-03-13 | 3 | 1117.86 | 1 | 3728.56 | 10 | SO48341 | 2023-03-20 | 298.28 | 3353.57 | 1242.85 | |||
| SO48311_42 | AAD7-4EBC-A1 | PO16472177233 | 100 | 287 | 417 | 239 | 4 | 2023-03-25 | 1622.26 | 40.56 | 2023-03-13 | 5 | 300.12 | 1 | 1622.26 | 42 | SO48311 | 2023-03-20 | 129.78 | 1500.59 | 324.45 | |||
| SO47431_3 | 6368-404E-A7 | PO4582126105 | 100 | 282 | 460 | 25 | 4 | 2022-12-24 | 53.99 | 1.35 | 2022-12-12 | 1 | 37.12 | 1 | 53.99 | 3 | SO47431 | 2022-12-19 | 4.32 | 37.12 | 53.99 | |||
| SO51090_27 | EBDE-4A71-8E | PO13688110947 | 100 | 282 | 555 | 475 | 4 | 2023-10-23 | 255.60 | 6.39 | 2023-10-11 | 4 | 47.29 | 1 | 255.60 | 27 | SO51090 | 2023-10-18 | 20.45 | 189.14 | 63.90 | |||
| SO45534_11 | F5A4-4CEE-97 | PO14964111594 | 100 | 287 | 347 | 581 | 4 | 2022-06-23 | 4079.99 | 102.00 | 2022-06-11 | 2 | 1912.15 | 1 | 4079.99 | 11 | SO45534 | 2022-06-18 | 326.40 | 3824.31 | 2039.99 | |||
| SO69412_15 | 14B1-47FE-BF | PO15689112657 | 100 | 281 | 580 | 328 | 4 | 2024-08-23 | 2041.19 | 51.03 | 2024-08-11 | 2 | 1082.51 | 1 | 2041.19 | 15 | SO69412 | 2024-08-18 | 163.30 | 2165.02 | 1020.59 | |||
| SO51827_30 | B106-4221-AD | PO4611117026 | 100 | 287 | 569 | 13 | 131 | 4 | 50.11 | 2023-11-23 | 334.06 | 7.10 | 2023-11-11 | 1 | 461.44 | 1 | 283.95 | 30 | SO51827 | 2023-11-18 | 22.72 | 461.44 | 334.06 | 0.15 |
| SO47372_11 | 70B5-428B-86 | PO16124198007 | 100 | 282 | 323 | 649 | 4 | 2022-12-24 | 1409.38 | 35.23 | 2022-12-12 | 3 | 486.71 | 1 | 1409.38 | 11 | SO47372 | 2022-12-19 | 112.75 | 1460.12 | 469.79 | |||
| SO53586_12 | 37CB-4A82-96 | PO4002170204 | 100 | 282 | 490 | 674 | 4 | 2023-12-24 | 32.39 | 0.81 | 2023-12-12 | 1 | 41.57 | 1 | 32.39 | 12 | SO53586 | 2023-12-19 | 2.59 | 41.57 | 32.39 | |||
| SO51154_4 | 2A76-4451-99 | PO7859157852 | 100 | 287 | 434 | 221 | 4 | 2023-10-23 | 2141.39 | 53.53 | 2023-10-11 | 6 | 360.94 | 1 | 2141.39 | 4 | SO51154 | 2023-10-18 | 171.31 | 2165.66 | 356.90 | |||
| SO49541_27 | B736-4142-A1 | PO7569133326 | 100 | 287 | 410 | 608 | 4 | 2023-06-23 | 291.58 | 7.29 | 2023-06-11 | 8 | 26.97 | 1 | 291.58 | 27 | SO49541 | 2023-06-18 | 23.33 | 215.77 | 36.45 | |||
| SO46342_1 | 9BA4-4F6E-96 | PO14964115309 | 100 | 287 | 347 | 7 | 581 | 4 | 595.00 | 2022-09-23 | 1700.00 | 27.62 | 2022-09-11 | 2 | 1912.15 | 1 | 1105.00 | 1 | SO46342 | 2022-09-18 | 88.40 | 3824.31 | 850.00 | 0.35 |
| SO57034_30 | 57D0-46D3-B7 | PO15689142548 | 100 | 281 | 214 | 328 | 4 | 2024-02-23 | 104.97 | 2.62 | 2024-02-11 | 5 | 13.09 | 1 | 104.97 | 30 | SO57034 | 2024-02-18 | 8.40 | 65.43 | 20.99 | |||
| SO46076_14 | E898-4203-B0 | PO2523131751 | 100 | 287 | 215 | 167 | 4 | 2022-08-23 | 60.56 | 1.51 | 2022-08-11 | 3 | 12.03 | 1 | 60.56 | 14 | SO46076 | 2022-08-18 | 4.84 | 36.08 | 20.19 | |||
| SO58992_4 | 1646-48B2-8A | PO16182112796 | 100 | 287 | 361 | 23 | 4 | 2024-03-24 | 1376.99 | 34.42 | 2024-03-12 | 1 | 1251.98 | 1 | 1376.99 | 4 | SO58992 | 2024-03-19 | 110.16 | 1251.98 | 1376.99 | |||
| SO53580_16 | FFE9-4F36-B2 | PO4640164085 | 100 | 287 | 525 | 648 | 4 | 2023-12-24 | 158.43 | 3.96 | 2023-12-12 | 1 | 144.59 | 1 | 158.43 | 16 | SO53580 | 2023-12-19 | 12.67 | 144.59 | 158.43 | |||
| SO61193_10 | DFEB-4C0D-88 | PO551160749 | 100 | 281 | 481 | 4 | 4 | 2024-04-24 | 21.58 | 0.54 | 2024-04-12 | 4 | 3.36 | 1 | 21.58 | 10 | SO61193 | 2024-04-19 | 1.73 | 13.45 | 5.39 | |||
| SO44317_14 | BE9B-42BA-87 | PO7859142280 | 100 | 287 | 232 | 221 | 4 | 2022-01-23 | 230.72 | 5.77 | 2022-01-11 | 8 | 31.72 | 1 | 230.72 | 14 | SO44317 | 2022-01-18 | 18.46 | 253.80 | 28.84 |
Generated 2024-11-10 12:30:06.519 UTC