[ROOT] dt FactResellerSale < WHERE DimSalesTerritoryId EQ ALL SKIP 4000 SHUFFLE < SKIP 1050 > < 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 |
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
| SO47680_23 | FD44-4F17-A1 | PO13340181659 | 100 | 292 | 448 | 355 | 7 | 2023-01-23 | 23.99 | 0.60 | 2023-01-11 | 2 | 8.25 | 1 | 23.99 | 23 | SO47680 | 2023-01-18 | 1.92 | 16.49 | 11.99 | |||
| SO47372_16 | 70B5-428B-86 | PO16124198007 | 100 | 282 | 230 | 649 | 4 | 2022-12-24 | 28.84 | 0.72 | 2022-12-12 | 1 | 29.08 | 1 | 28.84 | 16 | SO47372 | 2022-12-19 | 2.31 | 29.08 | 28.84 | |||
| SO65238_34 | 896A-4ED1-B1 | PO10875188169 | 19 | 291 | 491 | 281 | 6 | 2024-06-23 | 291.55 | 7.29 | 2024-06-11 | 9 | 41.57 | 1 | 291.55 | 34 | SO65238 | 2024-06-18 | 23.32 | 374.15 | 32.39 | |||
| SO48005_46 | 634C-42C5-AB | PO13427183371 | 100 | 292 | 385 | 638 | 7 | 2023-02-23 | 2401.05 | 60.03 | 2023-02-11 | 4 | 605.65 | 1 | 2401.05 | 46 | SO48005 | 2023-02-18 | 192.08 | 2422.60 | 600.26 | |||
| SO48012_18 | AF9F-4901-9E | PO12499156458 | 100 | 282 | 224 | 78 | 4 | 2023-02-23 | 46.68 | 1.17 | 2023-02-11 | 9 | 5.23 | 1 | 46.68 | 18 | SO48012 | 2023-02-18 | 3.73 | 47.07 | 5.19 | |||
| SO47013_14 | 4AB0-4FA0-95 | PO1827132360 | 19 | 291 | 337 | 317 | 6 | 2022-11-23 | 1409.38 | 35.23 | 2022-11-11 | 3 | 486.71 | 1 | 1409.38 | 14 | SO47013 | 2022-11-18 | 112.75 | 1460.12 | 469.79 | |||
| SO67289_32 | 5B09-42E8-A1 | PO10324110444 | 98 | 288 | 593 | 196 | 10 | 2024-07-24 | 677.99 | 16.95 | 2024-07-12 | 2 | 308.22 | 1 | 677.99 | 32 | SO67289 | 2024-07-19 | 54.24 | 616.44 | 338.99 | |||
| SO51085_22 | EB9F-4A76-97 | PO19314178917 | 100 | 281 | 477 | 622 | 3 | 2023-10-23 | 5.99 | 0.15 | 2023-10-11 | 2 | 1.87 | 1 | 5.99 | 22 | SO51085 | 2023-10-18 | 0.48 | 3.73 | 2.99 | |||
| SO57012_46 | BE3B-4D30-A7 | PO580126740 | 36 | 295 | 499 | 230 | 8 | 2024-02-23 | 2409.38 | 60.23 | 2024-02-11 | 4 | 601.74 | 1 | 2409.38 | 46 | SO57012 | 2024-02-18 | 192.75 | 2406.97 | 602.35 | |||
| SO71894_27 | 8013-4FC0-B4 | PO7685115663 | 100 | 283 | 217 | 539 | 2 | 2024-09-23 | 146.96 | 3.67 | 2024-09-11 | 7 | 13.09 | 1 | 146.96 | 27 | SO71894 | 2024-09-18 | 11.76 | 91.60 | 20.99 | |||
| SO44768_2 | 18BD-48B8-95 | PO261164909 | 100 | 283 | 332 | 647 | 4 | 2022-03-25 | 1258.38 | 31.46 | 2022-03-13 | 3 | 413.15 | 1 | 1258.38 | 2 | SO44768 | 2022-03-20 | 100.67 | 1239.44 | 419.46 | |||
| SO71833_10 | 8525-4645-AB | PO10411123072 | 100 | 289 | 572 | 182 | 1 | 2024-09-23 | 1781.64 | 44.54 | 2024-09-11 | 4 | 461.44 | 1 | 1781.64 | 10 | SO71833 | 2024-09-18 | 142.53 | 1845.78 | 445.41 | |||
| SO57024_2 | DED7-4CEF-90 | PO17661138970 | 19 | 284 | 576 | 264 | 6 | 2024-02-23 | 1430.44 | 35.76 | 2024-02-11 | 1 | 1481.94 | 1 | 1430.44 | 2 | SO57024 | 2024-02-18 | 114.44 | 1481.94 | 1430.44 | |||
| SO49852_6 | 5DD7-447A-8D | PO2581189096 | 100 | 282 | 343 | 698 | 1 | 2023-07-24 | 939.59 | 23.49 | 2023-07-12 | 2 | 486.71 | 1 | 939.59 | 6 | SO49852 | 2023-07-19 | 75.17 | 973.41 | 469.79 | |||
| SO49501_30 | EF67-4713-BD | PO17574111786 | 19 | 291 | 352 | 678 | 6 | 2023-06-23 | 3728.56 | 93.21 | 2023-06-11 | 3 | 1117.86 | 1 | 3728.56 | 30 | SO49501 | 2023-06-18 | 298.28 | 3353.57 | 1242.85 | |||
| SO47008_1 | FD36-4D89-AB | PO1595170889 | 19 | 284 | 454 | 426 | 6 | 2022-11-23 | 71.99 | 1.80 | 2022-11-11 | 2 | 24.75 | 1 | 71.99 | 1 | SO47008 | 2022-11-18 | 5.76 | 49.49 | 35.99 | |||
| SO65257_22 | 4659-4DD9-90 | PO7685190459 | 100 | 283 | 472 | 539 | 2 | 2024-06-23 | 38.10 | 0.95 | 2024-06-11 | 1 | 23.75 | 1 | 38.10 | 22 | SO65257 | 2024-06-18 | 3.05 | 23.75 | 38.10 | |||
| SO58915_27 | 1BBB-45DF-82 | PO17371111245 | 6 | 294 | 465 | 688 | 9 | 2024-03-24 | 58.78 | 1.47 | 2024-03-12 | 4 | 9.16 | 1 | 58.78 | 27 | SO58915 | 2024-03-19 | 4.70 | 36.64 | 14.69 | |||
| SO59068_17 | B7CC-4A9D-86 | PO9715112509 | 100 | 281 | 363 | 490 | 4 | 2024-03-24 | 5507.98 | 137.70 | 2024-03-12 | 4 | 1251.98 | 1 | 5507.98 | 17 | SO59068 | 2024-03-19 | 440.64 | 5007.93 | 1376.99 | |||
| SO71857_8 | CD4E-4DE8-81 | PO16269151631 | 100 | 287 | 378 | 624 | 4 | 2024-09-23 | 5864.04 | 146.60 | 2024-09-11 | 4 | 1554.95 | 1 | 5864.04 | 8 | SO71857 | 2024-09-18 | 469.12 | 6219.79 | 1466.01 | |||
| SO45811_5 | C0A1-43C4-AE | PO6409111249 | 100 | 283 | 232 | 292 | 4 | 2022-07-24 | 28.84 | 0.72 | 2022-07-12 | 1 | 31.72 | 1 | 28.84 | 5 | SO45811 | 2022-07-19 | 2.31 | 31.72 | 28.84 | |||
| SO49821_6 | 0B9B-460C-BC | PO551117366 | 100 | 281 | 327 | 4 | 4 | 2023-07-24 | 1409.38 | 35.23 | 2023-07-12 | 3 | 486.71 | 1 | 1409.38 | 6 | SO49821 | 2023-07-19 | 112.75 | 1460.12 | 469.79 | |||
| SO55252_7 | 1F1C-4667-AE | PO13340115824 | 100 | 292 | 511 | 355 | 7 | 2024-01-23 | 218.45 | 5.46 | 2024-01-11 | 1 | 199.38 | 1 | 218.45 | 7 | SO55252 | 2024-01-18 | 17.48 | 199.38 | 218.45 | |||
| SO46358_10 | 3BC7-40F4-99 | PO1624111969 | 100 | 283 | 285 | 579 | 3 | 2022-09-23 | 178.58 | 4.46 | 2022-09-11 | 1 | 176.20 | 1 | 178.58 | 10 | SO46358 | 2022-09-18 | 14.29 | 176.20 | 178.58 | |||
| SO46364_4 | BC3C-4FE8-AC | PO3248115921 | 100 | 282 | 307 | 366 | 4 | 2022-09-23 | 722.59 | 18.06 | 2022-09-11 | 1 | 623.84 | 1 | 722.59 | 4 | SO46364 | 2022-09-18 | 57.81 | 623.84 | 722.59 | |||
| SO46633_30 | D8C9-4AB8-A4 | PO11484122930 | 100 | 281 | 464 | 594 | 2 | 2022-10-23 | 28.26 | 0.71 | 2022-10-11 | 2 | 9.71 | 1 | 28.26 | 30 | SO46633 | 2022-10-18 | 2.26 | 19.43 | 14.13 | |||
| SO47419_2 | 7703-4F2C-92 | PO3103122578 | 100 | 283 | 333 | 147 | 3 | 2022-12-24 | 2348.97 | 58.72 | 2022-12-12 | 5 | 486.71 | 1 | 2348.97 | 2 | SO47419 | 2022-12-19 | 187.92 | 2433.53 | 469.79 | |||
| SO57168_4 | B6D5-41ED-B9 | PO3480129742 | 100 | 281 | 287 | 436 | 4 | 2024-02-23 | 809.33 | 20.23 | 2024-02-11 | 4 | 204.63 | 1 | 809.33 | 4 | SO57168 | 2024-02-18 | 64.75 | 818.50 | 202.33 | |||
| SO49170_6 | B501-448E-96 | PO10150180753 | 100 | 285 | 367 | 9 | 5 | 2023-05-26 | 647.99 | 16.20 | 2023-05-14 | 1 | 598.44 | 1 | 647.99 | 6 | SO49170 | 2023-05-21 | 51.84 | 598.44 | 647.99 | |||
| SO61189_1 | 1A25-4A8C-8B | PO12412183085 | 100 | 281 | 374 | 670 | 3 | 2024-04-24 | 5864.04 | 146.60 | 2024-04-12 | 4 | 1554.95 | 1 | 5864.04 | 1 | SO61189 | 2024-04-19 | 469.12 | 6219.79 | 1466.01 | |||
| SO44750_1 | B71E-4BBF-B5 | PO17574147002 | 19 | 288 | 304 | 678 | 6 | 2022-03-25 | 4288.23 | 107.21 | 2022-03-13 | 6 | 617.03 | 1 | 4288.23 | 1 | SO44750 | 2022-03-20 | 343.06 | 3702.17 | 714.70 | |||
| SO47395_59 | 98F1-44B4-97 | PO11455133549 | 100 | 281 | 464 | 72 | 2 | 2022-12-24 | 56.52 | 1.41 | 2022-12-12 | 4 | 9.71 | 1 | 56.52 | 59 | SO47395 | 2022-12-19 | 4.52 | 38.85 | 14.13 | |||
| SO55252_44 | 1F1C-4667-AE | PO13340115824 | 100 | 292 | 593 | 355 | 7 | 2024-01-23 | 338.99 | 8.47 | 2024-01-11 | 1 | 308.22 | 1 | 338.99 | 44 | SO55252 | 2024-01-18 | 27.12 | 308.22 | 338.99 | |||
| SO48757_13 | C817-44D2-B4 | PO16588132026 | 100 | 289 | 420 | 146 | 1 | 2023-04-25 | 566.46 | 14.16 | 2023-04-13 | 4 | 104.80 | 1 | 566.46 | 13 | SO48757 | 2023-04-20 | 45.32 | 419.18 | 141.62 | |||
| SO44511_4 | 4BD6-4CFA-B8 | PO14529113218 | 100 | 286 | 223 | 289 | 1 | 2022-02-23 | 5.19 | 0.13 | 2022-02-11 | 1 | 5.71 | 1 | 5.19 | 4 | SO44511 | 2022-02-18 | 0.41 | 5.71 | 5.19 | |||
| SO51157_10 | 927E-4DB1-A3 | PO3828155781 | 100 | 283 | 476 | 414 | 2 | 2023-10-23 | 125.98 | 3.15 | 2023-10-11 | 3 | 26.18 | 1 | 125.98 | 10 | SO51157 | 2023-10-18 | 10.08 | 78.53 | 41.99 | |||
| SO44110_12 | D69E-4EC8-8A | PO1624152036 | 100 | 283 | 285 | 579 | 3 | 2021-12-24 | 178.58 | 4.46 | 2021-12-12 | 1 | 176.20 | 1 | 178.58 | 12 | SO44110 | 2021-12-19 | 14.29 | 176.20 | 178.58 | |||
| SO47670_7 | 0CD2-463E-8F | PO14732184884 | 19 | 291 | 263 | 514 | 6 | 2023-01-23 | 1416.32 | 35.41 | 2023-01-11 | 7 | 187.16 | 1 | 1416.32 | 7 | SO47670 | 2023-01-18 | 113.31 | 1310.10 | 202.33 | |||
| SO55251_27 | 2481-4FF1-80 | PO13659159365 | 100 | 287 | 599 | 437 | 4 | 2024-01-23 | 647.99 | 16.20 | 2024-01-11 | 2 | 294.58 | 1 | 647.99 | 27 | SO55251 | 2024-01-18 | 51.84 | 589.16 | 323.99 | |||
| SO49118_37 | 532A-4BAE-8C | PO13427116278 | 100 | 292 | 459 | 638 | 7 | 2023-05-26 | 161.98 | 4.05 | 2023-05-14 | 3 | 37.12 | 1 | 161.98 | 37 | SO49118 | 2023-05-21 | 12.96 | 111.36 | 53.99 | |||
| SO57119_14 | 588B-4457-8A | PO3712174757 | 100 | 292 | 564 | 662 | 7 | 2024-02-23 | 2860.88 | 71.52 | 2024-02-11 | 2 | 1481.94 | 1 | 2860.88 | 14 | SO57119 | 2024-02-18 | 228.87 | 2963.88 | 1430.44 | |||
| SO71798_4 | AFA9-4B18-AD | PO16994135863 | 100 | 283 | 376 | 306 | 3 | 2024-09-23 | 5864.04 | 146.60 | 2024-09-11 | 4 | 1554.95 | 1 | 5864.04 | 4 | SO71798 | 2024-09-18 | 469.12 | 6219.79 | 1466.01 | |||
| SO50232_4 | 3919-46D4-A1 | PO11020171211 | 19 | 284 | 343 | 2 | 336 | 6 | 99.91 | 2023-08-23 | 4995.48 | 122.39 | 2023-08-11 | 11 | 486.71 | 1 | 4895.57 | 4 | SO50232 | 2023-08-18 | 391.65 | 5353.77 | 454.13 | 0.02 |
| SO44749_28 | 6F66-42B6-AB | PO17545111622 | 19 | 288 | 322 | 155 | 6 | 2022-03-25 | 838.92 | 20.97 | 2022-03-13 | 2 | 413.15 | 1 | 838.92 | 28 | SO44749 | 2022-03-20 | 67.11 | 826.29 | 419.46 | |||
| SO69462_2 | 05B6-4501-9B | PO1769122113 | 100 | 283 | 606 | 540 | 2 | 2024-08-23 | 1295.98 | 32.40 | 2024-08-11 | 4 | 343.65 | 1 | 1295.98 | 2 | SO69462 | 2024-08-18 | 103.68 | 1374.60 | 323.99 | |||
| SO48396_12 | F55B-45AE-8B | PO9715142000 | 100 | 283 | 358 | 490 | 4 | 2023-03-25 | 2458.92 | 61.47 | 2023-03-13 | 2 | 1105.81 | 1 | 2458.92 | 12 | SO48396 | 2023-03-20 | 196.71 | 2211.62 | 1229.46 | |||
| SO49510_25 | 34F7-4B7D-88 | PO8468119179 | 98 | 288 | 339 | 16 | 10 | 2023-06-23 | 1409.38 | 35.23 | 2023-06-11 | 3 | 486.71 | 1 | 1409.38 | 25 | SO49510 | 2023-06-18 | 112.75 | 1460.12 | 469.79 | |||
| SO53499_18 | A47F-48AD-83 | PO12354126576 | 100 | 283 | 592 | 197 | 3 | 2023-12-24 | 677.99 | 16.95 | 2023-12-12 | 2 | 308.22 | 1 | 677.99 | 18 | SO53499 | 2023-12-19 | 54.24 | 616.44 | 338.99 | |||
| SO46353_7 | D204-4F6B-A7 | PO10382113264 | 100 | 283 | 347 | 7 | 453 | 3 | 297.50 | 2022-09-23 | 850.00 | 13.81 | 2022-09-11 | 1 | 1912.15 | 1 | 552.50 | 7 | SO46353 | 2022-09-18 | 44.20 | 1912.15 | 850.00 | 0.35 |
| SO47052_40 | 1AAD-4284-B8 | PO7424197138 | 100 | 281 | 213 | 642 | 2 | 2022-11-23 | 60.56 | 1.51 | 2022-11-11 | 3 | 13.88 | 1 | 60.56 | 40 | SO47052 | 2022-11-18 | 4.84 | 41.63 | 20.19 | |||
| SO47683_18 | 619F-4ABF-8A | PO12412127983 | 100 | 283 | 414 | 670 | 3 | 2023-01-23 | 596.12 | 14.90 | 2023-01-11 | 4 | 110.28 | 1 | 596.12 | 18 | SO47683 | 2023-01-18 | 47.69 | 441.13 | 149.03 | |||
| SO67263_26 | EFEC-4A80-8F | PO17197178016 | 100 | 283 | 544 | 125 | 2 | 2024-07-24 | 97.19 | 2.43 | 2024-07-12 | 2 | 35.96 | 1 | 97.19 | 26 | SO67263 | 2024-07-19 | 7.78 | 71.92 | 48.59 | |||
| SO50295_10 | 575E-4F7A-9C | PO4466165095 | 19 | 291 | 419 | 352 | 6 | 2023-08-23 | 105.29 | 2.63 | 2023-08-11 | 2 | 38.96 | 1 | 105.29 | 10 | SO50295 | 2023-08-18 | 8.42 | 77.92 | 52.65 | |||
| SO71936_15 | 95F1-4758-A0 | PO8671170385 | 98 | 288 | 531 | 502 | 10 | 2024-09-23 | 749.37 | 18.73 | 2024-09-11 | 5 | 136.79 | 1 | 749.37 | 15 | SO71936 | 2024-09-18 | 59.95 | 683.93 | 149.87 | |||
| SO45529_2 | 86CC-47BA-B3 | PO17574182721 | 19 | 288 | 349 | 678 | 6 | 2022-06-23 | 12149.96 | 303.75 | 2022-06-11 | 6 | 1898.09 | 1 | 12149.96 | 2 | SO45529 | 2022-06-18 | 972.00 | 11388.57 | 2024.99 | |||
| SO51773_1 | 14B1-48BF-A0 | PO2523163173 | 100 | 287 | 584 | 167 | 4 | 2023-11-23 | 1295.98 | 32.40 | 2023-11-11 | 4 | 343.65 | 1 | 1295.98 | 1 | SO51773 | 2023-11-18 | 103.68 | 1374.60 | 323.99 |
Generated 2024-11-10 17:23:46.186 UTC