[ROOT] dt FactResellerSale < WHERE DimSalesTerritoryId EQ '2' > SHUFFLE < SKIP 1097 > < 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 |
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
| SO49888_45 | 01BB-49D0-BD | PO6699147895 | 100 | 283 | 327 | 234 | 2 | 2023-07-27 | 2348.97 | 58.72 | 2023-07-15 | 5 | 486.71 | 1 | 2348.97 | 45 | SO49888 | 2023-07-22 | 187.92 | 2433.53 | 469.79 | |||
| SO44494_5 | 8EF7-4B3A-A4 | PO18386158045 | 100 | 281 | 312 | 558 | 2 | 2022-02-26 | 2146.96 | 53.67 | 2022-02-14 | 1 | 2171.29 | 1 | 2146.96 | 5 | SO44494 | 2022-02-21 | 171.76 | 2171.29 | 2146.96 | |||
| SO48017_38 | 40DA-4972-BB | PO11658177389 | 100 | 281 | 427 | 233 | 2 | 2023-02-26 | 1046.28 | 26.16 | 2023-02-14 | 5 | 185.82 | 1 | 1046.28 | 38 | SO48017 | 2023-02-21 | 83.70 | 929.10 | 209.26 | |||
| SO67284_22 | 8286-4B8D-89 | PO11484111023 | 100 | 283 | 357 | 594 | 2 | 2024-07-27 | 1391.99 | 34.80 | 2024-07-15 | 1 | 1265.62 | 1 | 1391.99 | 22 | SO67284 | 2024-07-22 | 111.36 | 1265.62 | 1391.99 | |||
| SO48371_2 | AD41-4927-9B | PO4756123920 | 100 | 281 | 233 | 126 | 2 | 2023-03-28 | 57.68 | 1.44 | 2023-03-16 | 2 | 29.08 | 1 | 57.68 | 2 | SO48371 | 2023-03-23 | 4.61 | 58.16 | 28.84 | |||
| SO45803_4 | 6F0B-4638-93 | PO1566112039 | 100 | 281 | 332 | 486 | 2 | 2022-07-27 | 838.92 | 20.97 | 2022-07-15 | 2 | 413.15 | 1 | 838.92 | 4 | SO45803 | 2022-07-22 | 67.11 | 826.29 | 419.46 | |||
| SO45335_9 | CF69-4308-92 | PO6641155631 | 100 | 281 | 338 | 342 | 2 | 2022-05-29 | 419.46 | 10.49 | 2022-05-17 | 1 | 413.15 | 1 | 419.46 | 9 | SO45335 | 2022-05-24 | 33.56 | 413.15 | 419.46 | |||
| SO46385_1 | F727-48F0-AF | PO9483110086 | 100 | 281 | 334 | 54 | 2 | 2022-09-26 | 2097.29 | 52.43 | 2022-09-14 | 5 | 413.15 | 1 | 2097.29 | 1 | SO46385 | 2022-09-21 | 167.78 | 2065.73 | 419.46 | |||
| SO47718_45 | B391-4A07-98 | PO6699137967 | 100 | 281 | 369 | 234 | 2 | 2023-01-26 | 2932.02 | 73.30 | 2023-01-14 | 2 | 1518.79 | 1 | 2932.02 | 45 | SO47718 | 2023-01-21 | 234.56 | 3037.57 | 1466.01 | |||
| SO48076_5 | C38A-4C0F-BD | PO7424167037 | 100 | 281 | 410 | 642 | 2 | 2023-02-26 | 182.24 | 4.56 | 2023-02-14 | 5 | 26.97 | 1 | 182.24 | 5 | SO48076 | 2023-02-21 | 14.58 | 134.85 | 36.45 | |||
| SO49530_2 | 2F7E-4447-A6 | PO4408110478 | 100 | 283 | 375 | 143 | 2 | 2023-06-26 | 1308.94 | 32.72 | 2023-06-14 | 1 | 1320.68 | 1 | 1308.94 | 2 | SO49530 | 2023-06-21 | 104.72 | 1320.68 | 1308.94 | |||
| SO48076_25 | C38A-4C0F-BD | PO7424167037 | 100 | 281 | 409 | 642 | 2 | 2023-02-26 | 209.26 | 5.23 | 2023-02-14 | 1 | 185.82 | 1 | 209.26 | 25 | SO48076 | 2023-02-21 | 16.74 | 185.82 | 209.26 | |||
| SO53556_4 | 05D7-4FCA-9D | PO12325153851 | 100 | 283 | 579 | 53 | 2 | 2023-12-27 | 1457.82 | 36.45 | 2023-12-15 | 2 | 755.15 | 1 | 1457.82 | 4 | SO53556 | 2023-12-22 | 116.63 | 1510.30 | 728.91 | |||
| SO53570_46 | 412A-483A-A3 | PO9483124574 | 100 | 283 | 463 | 54 | 2 | 2023-12-27 | 58.78 | 1.47 | 2023-12-15 | 4 | 9.16 | 1 | 58.78 | 46 | SO53570 | 2023-12-22 | 4.70 | 36.64 | 14.69 | |||
| SO65245_17 | 80F6-437F-84 | PO9628129233 | 100 | 283 | 572 | 179 | 2 | 2024-06-26 | 1336.23 | 33.41 | 2024-06-14 | 3 | 461.44 | 1 | 1336.23 | 17 | SO65245 | 2024-06-21 | 106.90 | 1384.33 | 445.41 | |||
| SO45333_3 | 5BB5-4C37-92 | PO6670131417 | 100 | 281 | 253 | 432 | 2 | 2022-05-29 | 178.58 | 4.46 | 2022-05-17 | 1 | 176.20 | 1 | 178.58 | 3 | SO45333 | 2022-05-24 | 14.29 | 176.20 | 178.58 | |||
| SO46385_29 | F727-48F0-AF | PO9483110086 | 100 | 281 | 235 | 54 | 2 | 2022-09-26 | 57.68 | 1.44 | 2022-09-14 | 2 | 31.72 | 1 | 57.68 | 29 | SO46385 | 2022-09-21 | 4.61 | 63.45 | 28.84 | |||
| SO47706_5 | D1C6-4062-AA | PO3828168588 | 100 | 281 | 308 | 414 | 2 | 2023-01-26 | 744.27 | 18.61 | 2023-01-14 | 1 | 660.91 | 1 | 744.27 | 5 | SO47706 | 2023-01-21 | 59.54 | 660.91 | 744.27 | |||
| SO49888_26 | 01BB-49D0-BD | PO6699147895 | 100 | 283 | 453 | 234 | 2 | 2023-07-27 | 107.98 | 2.70 | 2023-07-15 | 3 | 24.75 | 1 | 107.98 | 26 | SO49888 | 2023-07-22 | 8.64 | 74.24 | 35.99 | |||
| SO50683_24 | 8EBE-4D2C-AB | PO11455112273 | 100 | 283 | 230 | 72 | 2 | 2023-09-26 | 144.20 | 3.61 | 2023-09-14 | 5 | 29.08 | 1 | 144.20 | 24 | SO50683 | 2023-09-21 | 11.54 | 145.40 | 28.84 | |||
| SO65237_8 | 5F94-404B-AE | PO11455137092 | 100 | 283 | 546 | 72 | 2 | 2024-06-26 | 74.51 | 1.86 | 2024-06-14 | 2 | 27.57 | 1 | 74.51 | 8 | SO65237 | 2024-06-21 | 5.96 | 55.14 | 37.25 | |||
| SO51810_18 | 0D49-491D-BD | PO7453119597 | 100 | 283 | 491 | 3 | 108 | 2 | 31.18 | 2023-11-26 | 623.58 | 14.81 | 2023-11-14 | 21 | 41.57 | 1 | 592.41 | 18 | SO51810 | 2023-11-21 | 47.39 | 873.02 | 29.69 | 0.05 |
| SO49108_2 | 9FF7-43C4-B6 | PO14326188033 | 100 | 283 | 325 | 107 | 2 | 2023-05-29 | 469.79 | 11.74 | 2023-05-17 | 1 | 486.71 | 1 | 469.79 | 2 | SO49108 | 2023-05-24 | 37.58 | 486.71 | 469.79 | |||
| SO65245_4 | 80F6-437F-84 | PO9628129233 | 100 | 283 | 577 | 179 | 2 | 2024-06-26 | 1457.82 | 36.45 | 2024-06-14 | 2 | 755.15 | 1 | 1457.82 | 4 | SO65245 | 2024-06-21 | 116.63 | 1510.30 | 728.91 | |||
| SO50683_47 | 8EBE-4D2C-AB | PO11455112273 | 100 | 283 | 373 | 72 | 2 | 2023-09-26 | 13089.38 | 327.23 | 2023-09-14 | 10 | 1320.68 | 1 | 13089.38 | 47 | SO50683 | 2023-09-21 | 1047.15 | 13206.84 | 1308.94 | |||
| SO67314_35 | 6653-491A-80 | PO3828116396 | 100 | 283 | 400 | 414 | 2 | 2024-07-27 | 37.15 | 0.93 | 2024-07-15 | 1 | 27.49 | 1 | 37.15 | 35 | SO67314 | 2024-07-22 | 2.97 | 27.49 | 37.15 | |||
| SO71947_44 | 7269-4186-92 | PO9628115897 | 100 | 283 | 472 | 179 | 2 | 2024-09-26 | 152.40 | 3.81 | 2024-09-14 | 4 | 23.75 | 1 | 152.40 | 44 | SO71947 | 2024-09-21 | 12.19 | 95.00 | 38.10 | |||
| SO46655_13 | F5D5-409B-94 | PO3828139841 | 100 | 281 | 412 | 414 | 2 | 2022-10-26 | 360.26 | 9.01 | 2022-10-14 | 2 | 133.30 | 1 | 360.26 | 13 | SO46655 | 2022-10-21 | 28.82 | 266.59 | 180.13 | |||
| SO49825_20 | 2F7E-448D-B9 | PO17197161242 | 100 | 283 | 366 | 125 | 2 | 2023-07-27 | 647.99 | 16.20 | 2023-07-15 | 1 | 598.44 | 1 | 647.99 | 20 | SO49825 | 2023-07-22 | 51.84 | 598.44 | 647.99 | |||
| SO48336_13 | 48F2-4141-9A | PO11455111823 | 100 | 281 | 242 | 72 | 2 | 2023-03-28 | 3123.27 | 78.08 | 2023-03-16 | 4 | 722.26 | 1 | 3123.27 | 13 | SO48336 | 2023-03-23 | 249.86 | 2889.03 | 780.82 | |||
| SO49518_22 | AF02-4E4D-BA | PO9483189305 | 100 | 283 | 335 | 54 | 2 | 2023-06-26 | 939.59 | 23.49 | 2023-06-14 | 2 | 486.71 | 1 | 939.59 | 22 | SO49518 | 2023-06-21 | 75.17 | 973.41 | 469.79 | |||
| SO57065_4 | B68A-407E-99 | PO11658151711 | 100 | 283 | 361 | 233 | 2 | 2024-02-26 | 5507.98 | 137.70 | 2024-02-14 | 4 | 1251.98 | 1 | 5507.98 | 4 | SO57065 | 2024-02-21 | 440.64 | 5007.93 | 1376.99 | |||
| SO46640_3 | AE5D-418B-B7 | PO10092115747 | 100 | 281 | 401 | 252 | 2 | 2022-10-26 | 131.20 | 3.28 | 2022-10-14 | 2 | 48.55 | 1 | 131.20 | 3 | SO46640 | 2022-10-21 | 10.50 | 97.09 | 65.60 | |||
| SO44114_18 | 3082-4C08-AA | PO3190199320 | 100 | 281 | 334 | 575 | 2 | 2021-12-27 | 1258.38 | 31.46 | 2021-12-15 | 3 | 413.15 | 1 | 1258.38 | 18 | SO44114 | 2021-12-22 | 100.67 | 1239.44 | 419.46 | |||
| SO57087_12 | 423C-428C-BB | PO2871167176 | 100 | 283 | 564 | 522 | 2 | 2024-02-26 | 2860.88 | 71.52 | 2024-02-14 | 2 | 1481.94 | 1 | 2860.88 | 12 | SO57087 | 2024-02-21 | 228.87 | 2963.88 | 1430.44 | |||
| SO50235_1 | 20B9-4308-A5 | PO10121141993 | 100 | 283 | 335 | 684 | 2 | 2023-08-26 | 939.59 | 23.49 | 2023-08-14 | 2 | 486.71 | 1 | 939.59 | 1 | SO50235 | 2023-08-21 | 75.17 | 973.41 | 469.79 | |||
| SO47718_12 | B391-4A07-98 | PO6699137967 | 100 | 281 | 224 | 234 | 2 | 2023-01-26 | 10.37 | 0.26 | 2023-01-14 | 2 | 5.23 | 1 | 10.37 | 12 | SO47718 | 2023-01-21 | 0.83 | 10.46 | 5.19 | |||
| SO53570_43 | 412A-483A-A3 | PO9483124574 | 100 | 283 | 418 | 54 | 2 | 2023-12-27 | 713.80 | 17.84 | 2023-12-15 | 2 | 360.94 | 1 | 713.80 | 43 | SO53570 | 2023-12-22 | 57.10 | 721.89 | 356.90 | |||
| SO51784_5 | E52A-4F3F-B3 | PO18386130679 | 100 | 283 | 255 | 558 | 2 | 2023-11-26 | 404.66 | 10.12 | 2023-11-14 | 2 | 204.63 | 1 | 404.66 | 5 | SO51784 | 2023-11-21 | 32.37 | 409.25 | 202.33 | |||
| SO50683_2 | 8EBE-4D2C-AB | PO11455112273 | 100 | 283 | 422 | 72 | 2 | 2023-09-26 | 270.16 | 6.75 | 2023-09-14 | 4 | 49.98 | 1 | 270.16 | 2 | SO50683 | 2023-09-21 | 21.61 | 199.92 | 67.54 | |||
| SO59007_1 | 2145-4E0C-A4 | PO8352188193 | 100 | 283 | 408 | 636 | 2 | 2024-03-27 | 72.16 | 1.80 | 2024-03-15 | 1 | 53.40 | 1 | 72.16 | 1 | SO59007 | 2024-03-22 | 5.77 | 53.40 | 72.16 | |||
| SO49843_39 | D3CA-4A51-B6 | PO11484175391 | 100 | 283 | 464 | 594 | 2 | 2023-07-27 | 56.52 | 1.41 | 2023-07-15 | 4 | 9.71 | 1 | 56.52 | 39 | SO49843 | 2023-07-22 | 4.52 | 38.85 | 14.13 | |||
| SO47395_42 | 98F1-44B4-97 | PO11455133549 | 100 | 281 | 224 | 72 | 2 | 2022-12-27 | 15.56 | 0.39 | 2022-12-15 | 3 | 5.23 | 1 | 15.56 | 42 | SO47395 | 2022-12-22 | 1.24 | 15.69 | 5.19 | |||
| SO48017_44 | 40DA-4972-BB | PO11658177389 | 100 | 281 | 356 | 233 | 2 | 2023-02-26 | 3728.56 | 93.21 | 2023-02-14 | 3 | 1117.86 | 1 | 3728.56 | 44 | SO48017 | 2023-02-21 | 298.28 | 3353.57 | 1242.85 | |||
| SO48336_7 | 48F2-4141-9A | PO11455111823 | 100 | 281 | 383 | 72 | 2 | 2023-03-28 | 1800.79 | 45.02 | 2023-03-16 | 3 | 605.65 | 1 | 1800.79 | 7 | SO48336 | 2023-03-23 | 144.06 | 1816.95 | 600.26 | |||
| SO47718_43 | B391-4A07-98 | PO6699137967 | 100 | 281 | 370 | 234 | 2 | 2023-01-26 | 2932.02 | 73.30 | 2023-01-14 | 2 | 1518.79 | 1 | 2932.02 | 43 | SO47718 | 2023-01-21 | 234.56 | 3037.57 | 1466.01 | |||
| SO43858_9 | 8FFA-4339-B7 | PO16791124272 | 100 | 281 | 314 | 36 | 2 | 2021-11-26 | 4293.92 | 107.35 | 2021-11-14 | 2 | 2171.29 | 1 | 4293.92 | 9 | SO43858 | 2021-11-21 | 343.51 | 4342.59 | 2146.96 | |||
| SO44311_6 | 1B1A-46AE-93 | PO4959115826 | 100 | 281 | 241 | 269 | 2 | 2022-01-26 | 758.08 | 18.95 | 2022-01-14 | 1 | 747.97 | 1 | 758.08 | 6 | SO44311 | 2022-01-21 | 60.65 | 747.97 | 758.08 | |||
| SO71894_52 | 8013-4FC0-B4 | PO7685115663 | 100 | 283 | 487 | 539 | 2 | 2024-09-26 | 263.95 | 6.60 | 2024-09-14 | 8 | 20.57 | 1 | 263.95 | 52 | SO71894 | 2024-09-21 | 21.12 | 164.53 | 32.99 | |||
| SO63163_1 | F62A-48E2-BB | PO12383112537 | 100 | 283 | 481 | 89 | 2 | 2024-05-28 | 10.79 | 0.27 | 2024-05-16 | 2 | 3.36 | 1 | 10.79 | 1 | SO63163 | 2024-05-23 | 0.86 | 6.72 | 5.39 | |||
| SO63199_3 | 82B1-418A-A4 | PO14326132826 | 100 | 283 | 605 | 107 | 2 | 2024-05-28 | 323.99 | 8.10 | 2024-05-16 | 1 | 343.65 | 1 | 323.99 | 3 | SO63199 | 2024-05-23 | 25.92 | 343.65 | 323.99 | |||
| SO51741_3 | 96BB-4004-AE | PO12383191952 | 100 | 283 | 583 | 89 | 2 | 2023-11-26 | 2041.19 | 51.03 | 2023-11-14 | 2 | 1082.51 | 1 | 2041.19 | 3 | SO51741 | 2023-11-21 | 163.30 | 2165.02 | 1020.59 | |||
| SO50312_21 | 89ED-4505-8D | PO7424134798 | 100 | 283 | 221 | 642 | 2 | 2023-08-26 | 100.93 | 2.52 | 2023-08-14 | 5 | 13.88 | 1 | 100.93 | 21 | SO50312 | 2023-08-21 | 8.07 | 69.39 | 20.19 | |||
| SO53570_18 | 412A-483A-A3 | PO9483124574 | 100 | 283 | 581 | 54 | 2 | 2023-12-27 | 6123.56 | 153.09 | 2023-12-15 | 6 | 1082.51 | 1 | 6123.56 | 18 | SO53570 | 2023-12-22 | 489.89 | 6495.06 | 1020.59 | |||
| SO49894_17 | C75C-4AA6-B6 | PO10092140429 | 100 | 283 | 358 | 252 | 2 | 2023-07-27 | 2458.92 | 61.47 | 2023-07-15 | 2 | 1105.81 | 1 | 2458.92 | 17 | SO49894 | 2023-07-22 | 196.71 | 2211.62 | 1229.46 | |||
| SO53570_16 | 412A-483A-A3 | PO9483124574 | 100 | 283 | 481 | 54 | 2 | 2023-12-27 | 5.39 | 0.13 | 2023-12-15 | 1 | 3.36 | 1 | 5.39 | 16 | SO53570 | 2023-12-22 | 0.43 | 3.36 | 5.39 |
Generated 2024-11-13 06:55:09.547 UTC