[ROOT] dt FactResellerSale < WHERE DimSalesTerritoryId EQ ALL SHUFFLE < SKIP 375 > < TAKE 62 >
62 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 |
---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
SO47992_38 | 3F55-4354-BD | PO15573158216 | 100 | 293 | 213 | 487 | 1 | 2023-01-19 | 121.12 | 3.03 | 2023-01-07 | 6 | 13.88 | 1 | 121.12 | 38 | SO47992 | 2023-01-14 | 9.69 | 83.27 | 20.19 | |||
SO48380_5 | 580B-4A1F-A4 | PO6757155119 | 100 | 283 | 399 | 21 | 4 | 2023-02-18 | 33.77 | 0.84 | 2023-02-06 | 1 | 24.99 | 1 | 33.77 | 5 | SO48380 | 2023-02-13 | 2.70 | 24.99 | 33.77 | |||
SO49833_10 | 595A-4EFA-AC | PO13340158028 | 100 | 292 | 362 | 355 | 7 | 2023-06-19 | 2458.92 | 61.47 | 2023-06-07 | 2 | 1105.81 | 1 | 2458.92 | 10 | SO49833 | 2023-06-14 | 196.71 | 2211.62 | 1229.46 | |||
SO46333_3 | B042-408B-A8 | PO17545158984 | 19 | 288 | 262 | 155 | 6 | 2022-08-19 | 551.81 | 13.80 | 2022-08-07 | 3 | 181.49 | 1 | 551.81 | 3 | SO46333 | 2022-08-14 | 44.15 | 544.46 | 183.94 | |||
SO57088_10 | EA31-4951-8A | PO2842199218 | 100 | 285 | 463 | 700 | 5 | 2024-01-19 | 88.16 | 2.20 | 2024-01-07 | 6 | 9.16 | 1 | 88.16 | 10 | SO57088 | 2024-01-14 | 7.05 | 54.96 | 14.69 | |||
SO53485_12 | 4356-47ED-8B | PO14703131697 | 6 | 294 | 487 | 573 | 9 | 2023-11-19 | 296.95 | 7.42 | 2023-11-07 | 9 | 20.57 | 1 | 296.95 | 12 | SO53485 | 2023-11-14 | 23.76 | 185.10 | 32.99 | |||
SO57154_2 | 464B-46A4-B6 | PO1856185040 | 19 | 291 | 577 | 263 | 6 | 2024-01-19 | 728.91 | 18.22 | 2024-01-07 | 1 | 755.15 | 1 | 728.91 | 2 | SO57154 | 2024-01-14 | 58.31 | 755.15 | 728.91 | |||
SO58920_35 | 944F-4219-85 | PO16501139645 | 98 | 288 | 467 | 142 | 10 | 2024-02-18 | 88.16 | 2.20 | 2024-02-06 | 6 | 9.16 | 1 | 88.16 | 35 | SO58920 | 2024-02-13 | 7.05 | 54.96 | 14.69 | |||
SO55287_28 | 4BBD-4DA3-AD | PO13862128497 | 19 | 291 | 513 | 119 | 6 | 2023-12-19 | 218.45 | 5.46 | 2023-12-07 | 1 | 199.38 | 1 | 218.45 | 28 | SO55287 | 2023-12-14 | 17.48 | 199.38 | 218.45 | |||
SO51145_9 | BBD2-4A22-8C | PO7105118870 | 100 | 293 | 217 | 11 | 668 | 1 | 2.36 | 2023-09-18 | 15.75 | 0.33 | 2023-09-06 | 1 | 13.09 | 1 | 13.38 | 9 | SO51145 | 2023-09-13 | 1.07 | 13.09 | 15.75 | 0.15 |
SO57091_5 | 46C3-4CC4-85 | PO18792158206 | 100 | 283 | 525 | 378 | 2 | 2024-01-19 | 158.43 | 3.96 | 2024-01-07 | 1 | 144.59 | 1 | 158.43 | 5 | SO57091 | 2024-01-14 | 12.67 | 144.59 | 158.43 | |||
SO71797_18 | 8375-4C38-91 | PO16501134889 | 98 | 288 | 480 | 142 | 10 | 2024-08-19 | 8.24 | 0.21 | 2024-08-07 | 6 | 0.86 | 1 | 8.24 | 18 | SO71797 | 2024-08-14 | 0.66 | 5.14 | 1.37 | |||
SO69541_8 | 75C0-4A42-AE | PO2030150622 | 19 | 284 | 474 | 661 | 6 | 2024-07-19 | 251.96 | 6.30 | 2024-07-07 | 6 | 26.18 | 1 | 251.96 | 8 | SO69541 | 2024-07-14 | 20.16 | 157.06 | 41.99 | |||
SO49103_3 | 0B8A-4326-8A | PO17748175932 | 19 | 284 | 433 | 102 | 6 | 2023-04-21 | 324.45 | 8.11 | 2023-04-09 | 1 | 300.12 | 1 | 324.45 | 3 | SO49103 | 2023-04-16 | 25.96 | 300.12 | 324.45 | |||
SO58944_21 | 90AC-4F21-90 | PO12354164168 | 100 | 283 | 599 | 197 | 3 | 2024-02-18 | 647.99 | 16.20 | 2024-02-06 | 2 | 294.58 | 1 | 647.99 | 21 | SO58944 | 2024-02-13 | 51.84 | 589.16 | 323.99 | |||
SO50259_19 | 2D7F-444F-AE | PO18386133550 | 100 | 283 | 417 | 558 | 2 | 2023-07-19 | 648.91 | 16.22 | 2023-07-07 | 2 | 300.12 | 1 | 648.91 | 19 | SO50259 | 2023-07-14 | 51.91 | 600.24 | 324.45 | |||
SO63280_2 | C73E-4203-80 | PO3654118854 | 100 | 281 | 588 | 435 | 4 | 2024-04-20 | 1385.08 | 34.63 | 2024-04-08 | 3 | 419.78 | 1 | 1385.08 | 2 | SO63280 | 2024-04-15 | 110.81 | 1259.34 | 461.69 | |||
SO46956_7 | 158F-43CB-95 | PO16849143827 | 100 | 281 | 221 | 198 | 3 | 2022-10-19 | 60.56 | 1.51 | 2022-10-07 | 3 | 13.88 | 1 | 60.56 | 7 | SO46956 | 2022-10-14 | 4.84 | 41.63 | 20.19 | |||
SO63171_32 | 6618-4F16-BE | PO580178064 | 36 | 295 | 463 | 230 | 8 | 2024-04-20 | 102.86 | 2.57 | 2024-04-08 | 7 | 9.16 | 1 | 102.86 | 32 | SO63171 | 2024-04-15 | 8.23 | 64.12 | 14.69 | |||
SO50222_11 | 4FDE-4C03-A9 | PO13427181046 | 100 | 292 | 286 | 638 | 7 | 2023-07-19 | 183.94 | 4.60 | 2023-07-07 | 1 | 170.14 | 1 | 183.94 | 11 | SO50222 | 2023-07-14 | 14.72 | 170.14 | 183.94 | |||
SO58975_28 | 1BCF-4E62-A9 | PO2697145020 | 100 | 282 | 594 | 187 | 4 | 2024-02-18 | 1016.98 | 25.42 | 2024-02-06 | 3 | 308.22 | 1 | 1016.98 | 28 | SO58975 | 2024-02-13 | 81.36 | 924.65 | 338.99 | |||
SO51809_42 | F690-4F1D-B1 | PO6438145374 | 100 | 281 | 595 | 309 | 4 | 2023-10-19 | 1016.98 | 25.42 | 2023-10-07 | 3 | 308.22 | 1 | 1016.98 | 42 | SO51809 | 2023-10-14 | 81.36 | 924.65 | 338.99 | |||
SO46357_2 | EC98-4DEF-A4 | PO667186827 | 100 | 287 | 342 | 365 | 4 | 2022-08-19 | 1258.38 | 31.46 | 2022-08-07 | 3 | 413.15 | 1 | 1258.38 | 2 | SO46357 | 2022-08-14 | 100.67 | 1239.44 | 419.46 | |||
SO47024_3 | F254-4053-A3 | PO3654136382 | 100 | 283 | 356 | 435 | 4 | 2022-10-19 | 4971.41 | 124.29 | 2022-10-07 | 4 | 1117.86 | 1 | 4971.41 | 3 | SO47024 | 2022-10-14 | 397.71 | 4471.42 | 1242.85 | |||
SO46056_18 | 4B9A-4022-AA | PO12586180466 | 100 | 285 | 347 | 278 | 5 | 2022-07-19 | 14279.96 | 357.00 | 2022-07-07 | 7 | 1912.15 | 1 | 14279.96 | 18 | SO46056 | 2022-07-14 | 1142.40 | 13385.08 | 2039.99 | |||
SO45542_17 | A757-4830-AE | PO13543153598 | 100 | 287 | 348 | 293 | 1 | 2022-05-19 | 4049.99 | 101.25 | 2022-05-07 | 2 | 1898.09 | 1 | 4049.99 | 17 | SO45542 | 2022-05-14 | 324.00 | 3796.19 | 2024.99 | |||
SO43910_2 | 8233-42D0-BD | PO7598186753 | 100 | 285 | 322 | 45 | 5 | 2021-10-19 | 1677.84 | 41.95 | 2021-10-07 | 4 | 413.15 | 1 | 1677.84 | 2 | SO43910 | 2021-10-14 | 134.23 | 1652.59 | 419.46 | |||
SO49151_5 | D25B-462C-8C | PO6438151235 | 100 | 281 | 224 | 309 | 4 | 2023-04-21 | 41.49 | 1.04 | 2023-04-09 | 8 | 5.23 | 1 | 41.49 | 5 | SO49151 | 2023-04-16 | 3.32 | 41.84 | 5.19 | |||
SO59011_9 | CAAD-4857-B7 | PO6786194654 | 100 | 281 | 491 | 3 | 3 | 4 | 23.76 | 2024-02-18 | 475.11 | 11.28 | 2024-02-06 | 16 | 41.57 | 1 | 451.36 | 9 | SO59011 | 2024-02-13 | 36.11 | 665.16 | 29.69 | 0.05 |
SO71792_14 | 5257-4FC4-A5 | PO17545115036 | 19 | 291 | 386 | 155 | 6 | 2024-08-19 | 2016.88 | 50.42 | 2024-08-07 | 3 | 713.08 | 1 | 2016.88 | 14 | SO71792 | 2024-08-14 | 161.35 | 2139.24 | 672.29 | |||
SO50272_7 | E0A6-4CFA-90 | PO11745174916 | 100 | 282 | 329 | 97 | 4 | 2023-07-19 | 469.79 | 11.74 | 2023-07-07 | 1 | 486.71 | 1 | 469.79 | 7 | SO50272 | 2023-07-14 | 37.58 | 486.71 | 469.79 | |||
SO47369_16 | B6B6-442B-8B | PO16472118462 | 100 | 287 | 423 | 239 | 4 | 2022-11-19 | 660.92 | 16.52 | 2022-11-07 | 4 | 122.27 | 1 | 660.92 | 16 | SO47369 | 2022-11-14 | 52.87 | 489.08 | 165.23 | |||
SO59075_3 | 1ED6-419E-AF | PO9628136689 | 100 | 283 | 234 | 179 | 2 | 2024-02-18 | 269.95 | 6.75 | 2024-02-06 | 9 | 38.49 | 1 | 269.95 | 3 | SO59075 | 2024-02-13 | 21.60 | 346.43 | 29.99 | |||
SO58970_20 | 7853-4F60-87 | PO1624182044 | 100 | 281 | 581 | 579 | 3 | 2024-02-18 | 1020.59 | 25.51 | 2024-02-06 | 1 | 1082.51 | 1 | 1020.59 | 20 | SO58970 | 2024-02-13 | 81.65 | 1082.51 | 1020.59 | |||
SO58948_14 | 1534-4AB5-81 | PO11774195497 | 6 | 296 | 472 | 682 | 9 | 2024-02-18 | 38.10 | 0.95 | 2024-02-06 | 1 | 23.75 | 1 | 38.10 | 14 | SO58948 | 2024-02-13 | 3.05 | 23.75 | 38.10 | |||
SO44749_8 | 6F66-42B6-AB | PO17545111622 | 19 | 288 | 311 | 155 | 6 | 2022-02-18 | 6440.89 | 161.02 | 2022-02-06 | 3 | 2171.29 | 1 | 6440.89 | 8 | SO44749 | 2022-02-13 | 515.27 | 6513.88 | 2146.96 | |||
SO55238_8 | 3BEA-42A3-9A | PO19314197881 | 100 | 281 | 484 | 622 | 3 | 2023-12-19 | 4.77 | 0.12 | 2023-12-07 | 1 | 2.97 | 1 | 4.77 | 8 | SO55238 | 2023-12-14 | 0.38 | 2.97 | 4.77 | |||
SO58953_9 | 99EE-491E-BD | PO11107122647 | 19 | 284 | 481 | 156 | 6 | 2024-02-18 | 5.39 | 0.13 | 2024-02-06 | 1 | 3.36 | 1 | 5.39 | 9 | SO58953 | 2024-02-13 | 0.43 | 3.36 | 5.39 | |||
SO44107_15 | 99CE-4ADA-B1 | PO261177749 | 100 | 283 | 276 | 647 | 4 | 2021-11-19 | 356.90 | 8.92 | 2021-11-07 | 1 | 352.14 | 1 | 356.90 | 15 | SO44107 | 2021-11-14 | 28.55 | 352.14 | 356.90 | |||
SO47065_9 | D00A-426C-9B | PO8845147622 | 100 | 282 | 236 | 546 | 3 | 2022-10-19 | 57.68 | 1.44 | 2022-10-07 | 2 | 29.08 | 1 | 57.68 | 9 | SO47065 | 2022-10-14 | 4.61 | 58.16 | 28.84 | |||
SO44309_2 | F0DB-4889-AC | PO3393112350 | 100 | 285 | 310 | 549 | 5 | 2021-12-19 | 2146.96 | 53.67 | 2021-12-07 | 1 | 2171.29 | 1 | 2146.96 | 2 | SO44309 | 2021-12-14 | 171.76 | 2171.29 | 2146.96 | |||
SO51809_39 | F690-4F1D-B1 | PO6438145374 | 100 | 281 | 525 | 309 | 4 | 2023-10-19 | 158.43 | 3.96 | 2023-10-07 | 1 | 144.59 | 1 | 158.43 | 39 | SO51809 | 2023-10-14 | 12.67 | 144.59 | 158.43 | |||
SO49821_7 | 0B9B-460C-BC | PO551117366 | 100 | 281 | 331 | 4 | 4 | 2023-06-19 | 1879.18 | 46.98 | 2023-06-07 | 4 | 486.71 | 1 | 1879.18 | 7 | SO49821 | 2023-06-14 | 150.33 | 1946.83 | 469.79 | |||
SO58971_38 | 319A-4CAC-B1 | PO1537134870 | 100 | 285 | 562 | 611 | 5 | 2024-02-18 | 1430.44 | 35.76 | 2024-02-06 | 1 | 1481.94 | 1 | 1430.44 | 38 | SO58971 | 2024-02-13 | 114.44 | 1481.94 | 1430.44 | |||
SO59027_10 | C142-4AAA-AB | PO6757122081 | 100 | 281 | 511 | 21 | 4 | 2024-02-18 | 436.91 | 10.92 | 2024-02-06 | 2 | 199.38 | 1 | 436.91 | 10 | SO59027 | 2024-02-13 | 34.95 | 398.75 | 218.45 | |||
SO53483_19 | A0BE-40E0-81 | PO14761137153 | 19 | 284 | 488 | 408 | 6 | 2023-11-19 | 129.58 | 3.24 | 2023-11-07 | 4 | 41.57 | 1 | 129.58 | 19 | SO53483 | 2023-11-14 | 10.37 | 166.29 | 32.39 | |||
SO71806_27 | 26A7-4E95-9B | PO14790111844 | 19 | 291 | 472 | 497 | 6 | 2024-08-19 | 38.10 | 0.95 | 2024-08-07 | 1 | 23.75 | 1 | 38.10 | 27 | SO71806 | 2024-08-14 | 3.05 | 23.75 | 38.10 | |||
SO71835_28 | EBBF-4B16-99 | PO870120974 | 100 | 286 | 567 | 621 | 1 | 2024-08-19 | 1336.23 | 33.41 | 2024-08-07 | 3 | 461.44 | 1 | 1336.23 | 28 | SO71835 | 2024-08-14 | 106.90 | 1384.33 | 445.41 | |||
SO51760_22 | 2C2D-41C9-8C | PO9918180623 | 100 | 285 | 568 | 13 | 260 | 5 | 150.33 | 2023-10-19 | 1002.17 | 21.30 | 2023-10-07 | 3 | 461.44 | 1 | 851.85 | 22 | SO51760 | 2023-10-14 | 68.15 | 1384.33 | 334.06 | 0.15 |
SO48370_1 | 2BBA-46FF-BD | PO4640118571 | 100 | 287 | 356 | 648 | 4 | 2023-02-18 | 4971.41 | 124.29 | 2023-02-06 | 4 | 1117.86 | 1 | 4971.41 | 1 | SO48370 | 2023-02-13 | 397.71 | 4471.42 | 1242.85 | |||
SO57058_9 | 4A45-4678-8D | PO13108114535 | 100 | 290 | 552 | 103 | 7 | 2024-01-19 | 164.68 | 4.12 | 2024-01-07 | 3 | 40.62 | 1 | 164.68 | 9 | SO57058 | 2024-01-14 | 13.17 | 121.86 | 54.89 | |||
SO50712_40 | 9AAC-4C4A-AB | PO14268119350 | 100 | 281 | 333 | 418 | 3 | 2023-08-19 | 1879.18 | 46.98 | 2023-08-07 | 4 | 486.71 | 1 | 1879.18 | 40 | SO50712 | 2023-08-14 | 150.33 | 1946.83 | 469.79 | |||
SO48396_6 | F55B-45AE-8B | PO9715142000 | 100 | 283 | 397 | 490 | 4 | 2023-02-18 | 48.59 | 1.21 | 2023-02-06 | 2 | 17.98 | 1 | 48.59 | 6 | SO48396 | 2023-02-13 | 3.89 | 35.96 | 24.29 | |||
SO67277_2 | 9AB3-4F34-85 | PO12644174121 | 100 | 272 | 513 | 530 | 5 | 2024-06-19 | 655.36 | 16.38 | 2024-06-07 | 3 | 199.38 | 1 | 655.36 | 2 | SO67277 | 2024-06-14 | 52.43 | 598.13 | 218.45 | |||
SO50213_5 | E565-4331-83 | PO15370194449 | 100 | 281 | 365 | 381 | 3 | 2023-07-19 | 1943.98 | 48.60 | 2023-07-07 | 3 | 598.44 | 1 | 1943.98 | 5 | SO50213 | 2023-07-14 | 155.52 | 1795.31 | 647.99 | |||
SO47378_24 | E766-4274-A7 | PO15341116216 | 100 | 283 | 397 | 327 | 3 | 2022-11-19 | 24.29 | 0.61 | 2022-11-07 | 1 | 17.98 | 1 | 24.29 | 24 | SO47378 | 2022-11-14 | 1.94 | 17.98 | 24.29 | |||
SO50297_47 | 5199-40AD-90 | PO4727113542 | 100 | 293 | 414 | 343 | 1 | 2023-07-19 | 596.12 | 14.90 | 2023-07-07 | 4 | 110.28 | 1 | 596.12 | 47 | SO50297 | 2023-07-14 | 47.69 | 441.13 | 149.03 | |||
SO47384_2 | 8780-4D54-85 | PO14268113342 | 100 | 283 | 377 | 418 | 3 | 2022-11-19 | 2617.88 | 65.45 | 2022-11-07 | 2 | 1320.68 | 1 | 2617.88 | 2 | SO47384 | 2022-11-14 | 209.43 | 2641.37 | 1308.94 | |||
SO58993_18 | EEB4-42E9-B9 | PO14297167367 | 100 | 285 | 572 | 627 | 5 | 2024-02-18 | 445.41 | 11.14 | 2024-02-06 | 1 | 461.44 | 1 | 445.41 | 18 | SO58993 | 2024-02-13 | 35.63 | 461.44 | 445.41 | |||
SO67288_1 | C763-4CCD-AB | PO10527192676 | 19 | 284 | 483 | 480 | 6 | 2024-06-19 | 72.00 | 1.80 | 2024-06-07 | 1 | 44.88 | 1 | 72.00 | 1 | SO67288 | 2024-06-14 | 5.76 | 44.88 | 72.00 | |||
SO45535_6 | BDC5-404A-8E | PO15138174425 | 100 | 283 | 223 | 93 | 4 | 2022-05-19 | 5.19 | 0.13 | 2022-05-07 | 1 | 5.71 | 1 | 5.19 | 6 | SO45535 | 2022-05-14 | 0.41 | 5.71 | 5.19 | |||
SO53472_13 | 892C-445A-B6 | PO16501111174 | 98 | 288 | 430 | 142 | 10 | 2023-11-19 | 2141.39 | 53.53 | 2023-11-07 | 6 | 360.94 | 1 | 2141.39 | 13 | SO53472 | 2023-11-14 | 171.31 | 2165.66 | 356.90 |
Generated 2024-10-06 17:02:17.538 UTC