[ROOT] dt FactResellerSale < WHERE DimSalesTerritoryId EQ '4' > SHUFFLE < SKIP 1153 > < TAKE 56 >
56 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 |
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
| SO57131_9 | 635E-4BF2-B9 | PO4611148036 | 100 | 287 | 555 | 131 | 4 | 2024-02-27 | 63.90 | 1.60 | 2024-02-15 | 1 | 47.29 | 1 | 63.90 | 9 | SO57131 | 2024-02-22 | 5.11 | 47.29 | 63.90 | |||
| SO47056_43 | 53BF-4950-9E | PO7656118289 | 100 | 282 | 435 | 403 | 4 | 2022-11-27 | 973.36 | 24.33 | 2022-11-15 | 3 | 300.12 | 1 | 973.36 | 43 | SO47056 | 2022-11-22 | 77.87 | 900.36 | 324.45 | |||
| SO67290_11 | 763C-4FCC-8E | PO10237115936 | 100 | 287 | 471 | 41 | 4 | 2024-07-28 | 114.30 | 2.86 | 2024-07-16 | 3 | 23.75 | 1 | 114.30 | 11 | SO67290 | 2024-07-23 | 9.14 | 71.25 | 38.10 | |||
| SO48378_21 | 2FD7-4721-9D | PO6786131738 | 100 | 283 | 458 | 3 | 4 | 2023-03-29 | 359.95 | 9.00 | 2023-03-17 | 8 | 30.93 | 1 | 359.95 | 21 | SO48378 | 2023-03-24 | 28.80 | 247.47 | 44.99 | |||
| SO43906_11 | BA78-4228-89 | PO6438197212 | 100 | 283 | 349 | 309 | 4 | 2021-11-27 | 6074.98 | 151.87 | 2021-11-15 | 3 | 1898.09 | 1 | 6074.98 | 11 | SO43906 | 2021-11-22 | 486.00 | 5694.28 | 2024.99 | |||
| SO53538_11 | D7FE-4E54-BD | PO18125134677 | 100 | 287 | 246 | 311 | 4 | 2023-12-28 | 2576.70 | 64.42 | 2023-12-16 | 3 | 868.63 | 1 | 2576.70 | 11 | SO53538 | 2023-12-23 | 206.14 | 2605.90 | 858.90 | |||
| SO71858_9 | 32BA-49C8-8B | PO16153112278 | 100 | 282 | 555 | 186 | 4 | 2024-09-27 | 127.80 | 3.20 | 2024-09-15 | 2 | 47.29 | 1 | 127.80 | 9 | SO71858 | 2024-09-22 | 10.22 | 94.57 | 63.90 | |||
| SO44520_16 | 5BE0-436B-8C | PO12499152870 | 100 | 282 | 212 | 78 | 4 | 2022-02-27 | 60.56 | 1.51 | 2022-02-15 | 3 | 12.03 | 1 | 60.56 | 16 | SO44520 | 2022-02-22 | 4.84 | 36.08 | 20.19 | |||
| SO69501_18 | 8A65-4926-A6 | PO6525182870 | 100 | 281 | 551 | 345 | 4 | 2024-08-27 | 158.43 | 3.96 | 2024-08-15 | 1 | 144.59 | 1 | 158.43 | 18 | SO69501 | 2024-08-22 | 12.67 | 144.59 | 158.43 | |||
| SO49541_18 | B736-4142-A1 | PO7569133326 | 100 | 287 | 396 | 608 | 4 | 2023-06-27 | 224.51 | 5.61 | 2023-06-15 | 3 | 55.38 | 1 | 224.51 | 18 | SO49541 | 2023-06-22 | 17.96 | 166.14 | 74.84 | |||
| SO51131_23 | D489-4DF3-A2 | PO16298169856 | 100 | 287 | 499 | 3 | 599 | 4 | 634.97 | 2023-10-27 | 12699.46 | 301.61 | 2023-10-15 | 23 | 601.74 | 1 | 12064.49 | 23 | SO51131 | 2023-10-22 | 965.16 | 13840.11 | 552.15 | 0.05 |
| SO46964_10 | B3E6-43CC-A2 | PO15689139014 | 100 | 283 | 407 | 328 | 4 | 2022-11-27 | 65.60 | 1.64 | 2022-11-15 | 1 | 48.55 | 1 | 65.60 | 10 | SO46964 | 2022-11-22 | 5.25 | 48.55 | 65.60 | |||
| SO65299_1 | 2FED-4E5A-B6 | PO3770146082 | 100 | 282 | 353 | 151 | 4 | 2024-06-27 | 1391.99 | 34.80 | 2024-06-15 | 1 | 1265.62 | 1 | 1391.99 | 1 | SO65299 | 2024-06-22 | 111.36 | 1265.62 | 1391.99 | |||
| SO69515_8 | D9C1-4837-A7 | PO6351170694 | 100 | 281 | 545 | 255 | 4 | 2024-08-27 | 24.29 | 0.61 | 2024-08-15 | 1 | 17.98 | 1 | 24.29 | 8 | SO69515 | 2024-08-22 | 1.94 | 17.98 | 24.29 | |||
| SO71890_12 | D31D-413E-BB | PO5510169156 | 100 | 287 | 225 | 5 | 4 | 2024-09-27 | 5.39 | 0.13 | 2024-09-15 | 1 | 6.92 | 1 | 5.39 | 12 | SO71890 | 2024-09-22 | 0.43 | 6.92 | 5.39 | |||
| SO49160_22 | 60E2-486C-AE | PO7656113690 | 100 | 282 | 233 | 403 | 4 | 2023-05-30 | 57.68 | 1.44 | 2023-05-18 | 2 | 29.08 | 1 | 57.68 | 22 | SO49160 | 2023-05-25 | 4.61 | 58.16 | 28.84 | |||
| SO71845_12 | 4781-4673-85 | PO2697119362 | 100 | 282 | 357 | 187 | 4 | 2024-09-27 | 2783.99 | 69.60 | 2024-09-15 | 2 | 1265.62 | 1 | 2783.99 | 12 | SO71845 | 2024-09-22 | 222.72 | 2531.24 | 1391.99 | |||
| SO47034_29 | A5AA-46C3-92 | PO4843149248 | 100 | 287 | 383 | 257 | 4 | 2022-11-27 | 1200.53 | 30.01 | 2022-11-15 | 2 | 605.65 | 1 | 1200.53 | 29 | SO47034 | 2022-11-22 | 96.04 | 1211.30 | 600.26 | |||
| SO50208_20 | 6993-49B4-8B | PO15689114248 | 100 | 281 | 379 | 328 | 4 | 2023-08-27 | 7853.63 | 196.34 | 2023-08-15 | 6 | 1320.68 | 1 | 7853.63 | 20 | SO50208 | 2023-08-22 | 628.29 | 7924.10 | 1308.94 | |||
| SO49498_16 | D9E7-4090-86 | PO16472151816 | 100 | 287 | 273 | 239 | 4 | 2023-06-27 | 404.66 | 10.12 | 2023-06-15 | 2 | 187.16 | 1 | 404.66 | 16 | SO49498 | 2023-06-22 | 32.37 | 374.31 | 202.33 | |||
| SO45070_1 | B035-4728-8C | PO5626126979 | 100 | 283 | 316 | 166 | 4 | 2022-04-29 | 874.79 | 21.87 | 2022-04-17 | 1 | 884.71 | 1 | 874.79 | 1 | SO45070 | 2022-04-24 | 69.98 | 884.71 | 874.79 | |||
| SO51833_12 | 67A5-4BBC-8F | PO5684113634 | 100 | 282 | 512 | 385 | 4 | 2023-11-27 | 873.82 | 21.85 | 2023-11-15 | 4 | 199.38 | 1 | 873.82 | 12 | SO51833 | 2023-11-22 | 69.91 | 797.50 | 218.45 | |||
| SO65306_13 | 6B9B-439C-94 | PO5597142402 | 100 | 281 | 355 | 75 | 4 | 2024-06-27 | 2783.99 | 69.60 | 2024-06-15 | 2 | 1265.62 | 1 | 2783.99 | 13 | SO65306 | 2024-06-22 | 222.72 | 2531.24 | 1391.99 | |||
| SO48311_45 | AAD7-4EBC-A1 | PO16472177233 | 100 | 287 | 464 | 239 | 4 | 2023-03-29 | 42.39 | 1.06 | 2023-03-17 | 3 | 9.71 | 1 | 42.39 | 45 | SO48311 | 2023-03-24 | 3.39 | 29.14 | 14.13 | |||
| SO50226_11 | 75E5-4EFD-A7 | PO12499165634 | 100 | 282 | 448 | 78 | 4 | 2023-08-27 | 11.99 | 0.30 | 2023-08-15 | 1 | 8.25 | 1 | 11.99 | 11 | SO50226 | 2023-08-22 | 0.96 | 8.25 | 11.99 | |||
| SO71782_20 | CA08-4A9B-8D | PO19372114749 | 100 | 282 | 234 | 582 | 4 | 2024-09-27 | 239.95 | 6.00 | 2024-09-15 | 8 | 38.49 | 1 | 239.95 | 20 | SO71782 | 2024-09-22 | 19.20 | 307.94 | 29.99 | |||
| SO55251_12 | 2481-4FF1-80 | PO13659159365 | 100 | 287 | 400 | 437 | 4 | 2024-01-27 | 74.30 | 1.86 | 2024-01-15 | 2 | 27.49 | 1 | 74.30 | 12 | SO55251 | 2024-01-22 | 5.94 | 54.99 | 37.15 | |||
| SO59027_5 | C142-4AAA-AB | PO6757122081 | 100 | 281 | 357 | 21 | 4 | 2024-03-28 | 2783.99 | 69.60 | 2024-03-16 | 2 | 1265.62 | 1 | 2783.99 | 5 | SO59027 | 2024-03-23 | 222.72 | 2531.24 | 1391.99 | |||
| SO45516_17 | 3473-43AB-AE | PO261128364 | 100 | 283 | 235 | 647 | 4 | 2022-06-27 | 57.68 | 1.44 | 2022-06-15 | 2 | 31.72 | 1 | 57.68 | 17 | SO45516 | 2022-06-22 | 4.61 | 63.45 | 28.84 | |||
| SO48775_17 | E56E-4C8C-AA | PO10817145980 | 100 | 287 | 369 | 203 | 4 | 2023-04-29 | 2932.02 | 73.30 | 2023-04-17 | 2 | 1518.79 | 1 | 2932.02 | 17 | SO48775 | 2023-04-24 | 234.56 | 3037.57 | 1466.01 | |||
| SO46103_8 | 1902-406D-BF | PO7830116487 | 100 | 283 | 235 | 40 | 4 | 2022-08-27 | 28.84 | 0.72 | 2022-08-15 | 1 | 31.72 | 1 | 28.84 | 8 | SO46103 | 2022-08-22 | 2.31 | 31.72 | 28.84 | |||
| SO57144_4 | 074E-478C-99 | PO3799111077 | 100 | 282 | 465 | 312 | 4 | 2024-02-27 | 44.08 | 1.10 | 2024-02-15 | 3 | 9.16 | 1 | 44.08 | 4 | SO57144 | 2024-02-22 | 3.53 | 27.48 | 14.69 | |||
| SO48769_5 | A39E-4380-A6 | PO7859190388 | 100 | 287 | 236 | 221 | 4 | 2023-04-29 | 144.20 | 3.61 | 2023-04-17 | 5 | 29.08 | 1 | 144.20 | 5 | SO48769 | 2023-04-24 | 11.54 | 145.40 | 28.84 | |||
| SO47369_12 | B6B6-442B-8B | PO16472118462 | 100 | 287 | 414 | 239 | 4 | 2022-12-28 | 447.09 | 11.18 | 2022-12-16 | 3 | 110.28 | 1 | 447.09 | 12 | SO47369 | 2022-12-23 | 35.77 | 330.85 | 149.03 | |||
| SO48048_46 | B414-46CB-BA | PO3480117933 | 100 | 283 | 389 | 436 | 4 | 2023-02-27 | 1200.53 | 30.01 | 2023-02-15 | 2 | 605.65 | 1 | 1200.53 | 46 | SO48048 | 2023-02-22 | 96.04 | 1211.30 | 600.26 | |||
| SO51773_33 | 14B1-48BF-A0 | PO2523163173 | 100 | 287 | 481 | 167 | 4 | 2023-11-27 | 10.79 | 0.27 | 2023-11-15 | 2 | 3.36 | 1 | 10.79 | 33 | SO51773 | 2023-11-22 | 0.86 | 6.72 | 5.39 | |||
| SO71857_12 | CD4E-4DE8-81 | PO16269151631 | 100 | 287 | 434 | 624 | 4 | 2024-09-27 | 1070.69 | 26.77 | 2024-09-15 | 3 | 360.94 | 1 | 1070.69 | 12 | SO71857 | 2024-09-22 | 85.66 | 1082.83 | 356.90 | |||
| SO53596_1 | 6DDB-4913-AA | PO2349157569 | 100 | 282 | 547 | 6 | 4 | 2023-12-28 | 48.59 | 1.21 | 2023-12-16 | 1 | 35.96 | 1 | 48.59 | 1 | SO53596 | 2023-12-23 | 3.89 | 35.96 | 48.59 | |||
| SO55251_7 | 2481-4FF1-80 | PO13659159365 | 100 | 287 | 475 | 437 | 4 | 2024-01-27 | 41.99 | 1.05 | 2024-01-15 | 1 | 26.18 | 1 | 41.99 | 7 | SO55251 | 2024-01-22 | 3.36 | 26.18 | 41.99 | |||
| SO55256_11 | 686E-4D36-8B | PO12528136439 | 100 | 282 | 571 | 331 | 4 | 2024-01-27 | 445.41 | 11.14 | 2024-01-15 | 1 | 461.44 | 1 | 445.41 | 11 | SO55256 | 2024-01-22 | 35.63 | 461.44 | 445.41 | |||
| SO53459_29 | 9828-4F27-B0 | PO19372154638 | 100 | 282 | 560 | 582 | 4 | 2023-12-28 | 2186.73 | 54.67 | 2023-12-16 | 3 | 755.15 | 1 | 2186.73 | 29 | SO53459 | 2023-12-23 | 174.94 | 2265.45 | 728.91 | |||
| SO50743_8 | C1F5-4D36-9F | PO4640120853 | 100 | 287 | 411 | 648 | 4 | 2023-09-27 | 250.83 | 6.27 | 2023-09-15 | 2 | 92.81 | 1 | 250.83 | 8 | SO50743 | 2023-09-22 | 20.07 | 185.61 | 125.42 | |||
| SO48341_27 | A747-471B-97 | PO10701176180 | 100 | 282 | 447 | 133 | 4 | 2023-03-29 | 45.00 | 1.13 | 2023-03-17 | 3 | 10.31 | 1 | 45.00 | 27 | SO48341 | 2023-03-24 | 3.60 | 30.94 | 15.00 | |||
| SO55249_44 | 0527-4C9D-BA | PO13688172507 | 100 | 282 | 543 | 475 | 4 | 2024-01-27 | 74.51 | 1.86 | 2024-01-15 | 2 | 27.57 | 1 | 74.51 | 44 | SO55249 | 2024-01-22 | 5.96 | 55.14 | 37.25 | |||
| SO61227_27 | 9006-4208-8F | PO10730172247 | 100 | 287 | 483 | 491 | 4 | 2024-04-28 | 648.00 | 16.20 | 2024-04-16 | 9 | 44.88 | 1 | 648.00 | 27 | SO61227 | 2024-04-23 | 51.84 | 403.92 | 72.00 | |||
| SO65310_9 | 65CB-474A-9D | PO6786169596 | 100 | 281 | 234 | 3 | 4 | 2024-06-27 | 149.97 | 3.75 | 2024-06-15 | 5 | 38.49 | 1 | 149.97 | 9 | SO65310 | 2024-06-22 | 12.00 | 192.46 | 29.99 | |||
| SO50208_4 | 6993-49B4-8B | PO15689114248 | 100 | 281 | 230 | 328 | 4 | 2023-08-27 | 86.52 | 2.16 | 2023-08-15 | 3 | 29.08 | 1 | 86.52 | 4 | SO50208 | 2023-08-22 | 6.92 | 87.24 | 28.84 | |||
| SO67298_10 | F9FB-4B4C-92 | PO2755196827 | 100 | 282 | 493 | 205 | 4 | 2024-07-28 | 800.21 | 20.01 | 2024-07-16 | 4 | 199.85 | 1 | 800.21 | 10 | SO67298 | 2024-07-23 | 64.02 | 799.41 | 200.05 | |||
| SO50663_26 | 286E-4915-89 | PO19343130555 | 100 | 282 | 236 | 24 | 4 | 2023-09-27 | 144.20 | 3.61 | 2023-09-15 | 5 | 29.08 | 1 | 144.20 | 26 | SO50663 | 2023-09-22 | 11.54 | 145.40 | 28.84 | |||
| SO55276_5 | 81AA-41E5-B0 | PO2755182998 | 100 | 282 | 496 | 205 | 4 | 2024-01-27 | 1204.69 | 30.12 | 2024-01-15 | 2 | 601.74 | 1 | 1204.69 | 5 | SO55276 | 2024-01-22 | 96.38 | 1203.49 | 602.35 | |||
| SO69545_35 | 2C06-44D9-96 | PO3480123333 | 100 | 272 | 483 | 436 | 4 | 2024-08-27 | 504.00 | 12.60 | 2024-08-15 | 7 | 44.88 | 1 | 504.00 | 35 | SO69545 | 2024-08-22 | 40.32 | 314.16 | 72.00 | |||
| SO71787_4 | 94A7-4406-B3 | PO18038111279 | 100 | 287 | 585 | 509 | 4 | 2024-09-27 | 445.41 | 11.14 | 2024-09-15 | 1 | 461.44 | 1 | 445.41 | 4 | SO71787 | 2024-09-22 | 35.63 | 461.44 | 445.41 | |||
| SO71783_5 | 7E03-4B8A-BA | PO19343113609 | 100 | 282 | 487 | 24 | 4 | 2024-09-27 | 296.95 | 7.42 | 2024-09-15 | 9 | 20.57 | 1 | 296.95 | 5 | SO71783 | 2024-09-22 | 23.76 | 185.10 | 32.99 | |||
| SO45813_8 | 36A5-446C-96 | PO7859120230 | 100 | 287 | 215 | 221 | 4 | 2022-07-28 | 100.93 | 2.52 | 2022-07-16 | 5 | 12.03 | 1 | 100.93 | 8 | SO45813 | 2022-07-23 | 8.07 | 60.14 | 20.19 | |||
| SO53459_16 | 9828-4F27-B0 | PO19372154638 | 100 | 282 | 575 | 582 | 4 | 2023-12-28 | 1430.44 | 35.76 | 2023-12-16 | 1 | 1481.94 | 1 | 1430.44 | 16 | SO53459 | 2023-12-23 | 114.44 | 1481.94 | 1430.44 | |||
| SO49831_26 | 8BCC-466B-AB | PO13688123267 | 100 | 282 | 391 | 475 | 4 | 2023-07-28 | 88.93 | 2.22 | 2023-07-16 | 1 | 65.81 | 1 | 88.93 | 26 | SO49831 | 2023-07-23 | 7.11 | 65.81 | 88.93 |
Generated 2024-11-14 07:00:48.420 UTC