[ROOT] dt FactResellerSale < WHERE DimSalesTerritoryId EQ ALL < SKIP 3065 > < 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 |
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
| SO51132_5 | D4A8-472C-A4 | PO18444136544 | 19 | 291 | 258 | 227 | 6 | 2023-10-22 | 202.33 | 5.06 | 2023-10-10 | 1 | 204.63 | 1 | 202.33 | 5 | SO51132 | 2023-10-17 | 16.19 | 204.63 | 202.33 | |||
| SO59012_35 | 6620-4CEA-A0 | PO7685122244 | 100 | 283 | 601 | 539 | 2 | 2024-03-23 | 32.39 | 0.81 | 2024-03-11 | 1 | 23.97 | 1 | 32.39 | 35 | SO59012 | 2024-03-18 | 2.59 | 23.97 | 32.39 | |||
| SO43907_13 | 9CB1-46F4-8A | PO6641115253 | 100 | 281 | 270 | 342 | 2 | 2021-11-22 | 183.94 | 4.60 | 2021-11-10 | 1 | 181.49 | 1 | 183.94 | 13 | SO43907 | 2021-11-17 | 14.72 | 181.49 | 183.94 | |||
| SO51132_6 | D4A8-472C-A4 | PO18444136544 | 19 | 291 | 606 | 2 | 227 | 6 | 81.43 | 2023-10-22 | 4071.52 | 99.75 | 2023-10-10 | 13 | 343.65 | 1 | 3990.09 | 6 | SO51132 | 2023-10-17 | 319.21 | 4467.44 | 313.19 | 0.02 |
| SO59012_36 | 6620-4CEA-A0 | PO7685122244 | 100 | 283 | 488 | 539 | 2 | 2024-03-23 | 129.58 | 3.24 | 2024-03-11 | 4 | 41.57 | 1 | 129.58 | 36 | SO59012 | 2024-03-18 | 10.37 | 166.29 | 32.39 | |||
| SO43907_14 | 9CB1-46F4-8A | PO6641115253 | 100 | 281 | 220 | 342 | 2 | 2021-11-22 | 20.19 | 0.50 | 2021-11-10 | 1 | 12.03 | 1 | 20.19 | 14 | SO43907 | 2021-11-17 | 1.61 | 12.03 | 20.19 | |||
| SO51132_7 | D4A8-472C-A4 | PO18444136544 | 19 | 291 | 386 | 227 | 6 | 2023-10-22 | 1344.59 | 33.61 | 2023-10-10 | 2 | 713.08 | 1 | 1344.59 | 7 | SO51132 | 2023-10-17 | 107.57 | 1426.16 | 672.29 | |||
| SO59012_37 | 6620-4CEA-A0 | PO7685122244 | 100 | 283 | 234 | 539 | 2 | 2024-03-23 | 149.97 | 3.75 | 2024-03-11 | 5 | 38.49 | 1 | 149.97 | 37 | SO59012 | 2024-03-18 | 12.00 | 192.46 | 29.99 | |||
| SO43907_15 | 9CB1-46F4-8A | PO6641115253 | 100 | 281 | 328 | 342 | 2 | 2021-11-22 | 1677.84 | 41.95 | 2021-11-10 | 4 | 413.15 | 1 | 1677.84 | 15 | SO43907 | 2021-11-17 | 134.23 | 1652.59 | 419.46 | |||
| SO51132_8 | D4A8-472C-A4 | PO18444136544 | 19 | 291 | 436 | 227 | 6 | 2023-10-22 | 1070.69 | 26.77 | 2023-10-10 | 3 | 360.94 | 1 | 1070.69 | 8 | SO51132 | 2023-10-17 | 85.66 | 1082.83 | 356.90 | |||
| SO59012_38 | 6620-4CEA-A0 | PO7685122244 | 100 | 283 | 575 | 539 | 2 | 2024-03-23 | 4291.33 | 107.28 | 2024-03-11 | 3 | 1481.94 | 1 | 4291.33 | 38 | SO59012 | 2024-03-18 | 343.31 | 4445.81 | 1430.44 | |||
| SO43907_16 | 9CB1-46F4-8A | PO6641115253 | 100 | 281 | 285 | 342 | 2 | 2021-11-22 | 178.58 | 4.46 | 2021-11-10 | 1 | 176.20 | 1 | 178.58 | 16 | SO43907 | 2021-11-17 | 14.29 | 176.20 | 178.58 | |||
| SO51132_9 | D4A8-472C-A4 | PO18444136544 | 19 | 291 | 434 | 227 | 6 | 2023-10-22 | 3568.98 | 89.22 | 2023-10-10 | 10 | 360.94 | 1 | 3568.98 | 9 | SO51132 | 2023-10-17 | 285.52 | 3609.43 | 356.90 | |||
| SO59012_39 | 6620-4CEA-A0 | PO7685122244 | 100 | 283 | 471 | 2 | 539 | 2 | 9.58 | 2024-03-23 | 478.79 | 11.73 | 2024-03-11 | 13 | 23.75 | 1 | 469.21 | 39 | SO59012 | 2024-03-18 | 37.54 | 308.74 | 36.83 | 0.02 |
| SO43907_17 | 9CB1-46F4-8A | PO6641115253 | 100 | 281 | 264 | 342 | 2 | 2021-11-22 | 183.94 | 4.60 | 2021-11-10 | 1 | 181.49 | 1 | 183.94 | 17 | SO43907 | 2021-11-17 | 14.72 | 181.49 | 183.94 | |||
| SO51132_10 | D4A8-472C-A4 | PO18444136544 | 19 | 291 | 440 | 227 | 6 | 2023-10-22 | 5153.40 | 128.84 | 2023-10-10 | 6 | 868.63 | 1 | 5153.40 | 10 | SO51132 | 2023-10-17 | 412.27 | 5211.81 | 858.90 | |||
| SO59012_40 | 6620-4CEA-A0 | PO7685122244 | 100 | 283 | 490 | 539 | 2 | 2024-03-23 | 129.58 | 3.24 | 2024-03-11 | 4 | 41.57 | 1 | 129.58 | 40 | SO59012 | 2024-03-18 | 10.37 | 166.29 | 32.39 | |||
| SO43907_18 | 9CB1-46F4-8A | PO6641115253 | 100 | 281 | 342 | 342 | 2 | 2021-11-22 | 1258.38 | 31.46 | 2021-11-10 | 3 | 413.15 | 1 | 1258.38 | 18 | SO43907 | 2021-11-17 | 100.67 | 1239.44 | 419.46 | |||
| SO51132_11 | D4A8-472C-A4 | PO18444136544 | 19 | 291 | 520 | 227 | 6 | 2023-10-22 | 126.34 | 3.16 | 2023-10-10 | 4 | 23.37 | 1 | 126.34 | 11 | SO51132 | 2023-10-17 | 10.11 | 93.49 | 31.58 | |||
| SO59012_41 | 6620-4CEA-A0 | PO7685122244 | 100 | 283 | 586 | 539 | 2 | 2024-03-23 | 445.41 | 11.14 | 2024-03-11 | 1 | 461.44 | 1 | 445.41 | 41 | SO59012 | 2024-03-18 | 35.63 | 461.44 | 445.41 | |||
| SO43907_19 | 9CB1-46F4-8A | PO6641115253 | 100 | 281 | 317 | 342 | 2 | 2021-11-22 | 874.79 | 21.87 | 2021-11-10 | 1 | 884.71 | 1 | 874.79 | 19 | SO43907 | 2021-11-17 | 69.98 | 884.71 | 874.79 | |||
| SO51132_12 | D4A8-472C-A4 | PO18444136544 | 19 | 291 | 382 | 227 | 6 | 2023-10-22 | 2016.88 | 50.42 | 2023-10-10 | 3 | 713.08 | 1 | 2016.88 | 12 | SO51132 | 2023-10-17 | 161.35 | 2139.24 | 672.29 | |||
| SO59012_42 | 6620-4CEA-A0 | PO7685122244 | 100 | 283 | 603 | 539 | 2 | 2024-03-23 | 145.79 | 3.64 | 2024-03-11 | 2 | 53.94 | 1 | 145.79 | 42 | SO59012 | 2024-03-18 | 11.66 | 107.88 | 72.89 | |||
| SO43907_20 | 9CB1-46F4-8A | PO6641115253 | 100 | 281 | 316 | 342 | 2 | 2021-11-22 | 874.79 | 21.87 | 2021-11-10 | 1 | 884.71 | 1 | 874.79 | 20 | SO43907 | 2021-11-17 | 69.98 | 884.71 | 874.79 | |||
| SO51132_13 | D4A8-472C-A4 | PO18444136544 | 19 | 291 | 581 | 3 | 227 | 6 | 701.66 | 2023-10-22 | 14033.17 | 333.29 | 2023-10-10 | 15 | 1082.51 | 1 | 13331.51 | 13 | SO51132 | 2023-10-17 | 1066.52 | 16237.65 | 935.54 | 0.05 |
| SO59012_43 | 6620-4CEA-A0 | PO7685122244 | 100 | 283 | 558 | 539 | 2 | 2024-03-23 | 971.98 | 24.30 | 2024-03-11 | 4 | 179.82 | 1 | 971.98 | 43 | SO59012 | 2024-03-18 | 77.76 | 719.26 | 242.99 | |||
| SO43907_21 | 9CB1-46F4-8A | PO6641115253 | 100 | 281 | 235 | 342 | 2 | 2021-11-22 | 86.52 | 2.16 | 2021-11-10 | 3 | 31.72 | 1 | 86.52 | 21 | SO43907 | 2021-11-17 | 6.92 | 95.17 | 28.84 | |||
| SO51132_14 | D4A8-472C-A4 | PO18444136544 | 19 | 291 | 605 | 227 | 6 | 2023-10-22 | 971.98 | 24.30 | 2023-10-10 | 3 | 343.65 | 1 | 971.98 | 14 | SO51132 | 2023-10-17 | 77.76 | 1030.95 | 323.99 | |||
| SO59012_44 | 6620-4CEA-A0 | PO7685122244 | 100 | 283 | 483 | 539 | 2 | 2024-03-23 | 360.00 | 9.00 | 2024-03-11 | 5 | 44.88 | 1 | 360.00 | 44 | SO59012 | 2024-03-18 | 28.80 | 224.40 | 72.00 | |||
| SO43907_22 | 9CB1-46F4-8A | PO6641115253 | 100 | 281 | 223 | 342 | 2 | 2021-11-22 | 10.37 | 0.26 | 2021-11-10 | 2 | 5.71 | 1 | 10.37 | 22 | SO43907 | 2021-11-17 | 0.83 | 11.41 | 5.19 | |||
| SO51132_15 | D4A8-472C-A4 | PO18444136544 | 19 | 291 | 376 | 227 | 6 | 2023-10-22 | 4398.03 | 109.95 | 2023-10-10 | 3 | 1554.95 | 1 | 4398.03 | 15 | SO51132 | 2023-10-17 | 351.84 | 4664.84 | 1466.01 | |||
| SO59012_45 | 6620-4CEA-A0 | PO7685122244 | 100 | 283 | 579 | 539 | 2 | 2024-03-23 | 2186.73 | 54.67 | 2024-03-11 | 3 | 755.15 | 1 | 2186.73 | 45 | SO59012 | 2024-03-18 | 174.94 | 2265.45 | 728.91 | |||
| SO43908_1 | 2400-4CA7-88 | PO6670111729 | 100 | 281 | 276 | 432 | 2 | 2021-11-22 | 356.90 | 8.92 | 2021-11-10 | 1 | 352.14 | 1 | 356.90 | 1 | SO43908 | 2021-11-17 | 28.55 | 352.14 | 356.90 | |||
| SO51132_16 | D4A8-472C-A4 | PO18444136544 | 19 | 291 | 546 | 227 | 6 | 2023-10-22 | 149.02 | 3.73 | 2023-10-10 | 4 | 27.57 | 1 | 149.02 | 16 | SO51132 | 2023-10-17 | 11.92 | 110.27 | 37.25 | |||
| SO59012_46 | 6620-4CEA-A0 | PO7685122244 | 100 | 283 | 499 | 539 | 2 | 2024-03-23 | 1204.69 | 30.12 | 2024-03-11 | 2 | 601.74 | 1 | 1204.69 | 46 | SO59012 | 2024-03-18 | 96.38 | 1203.49 | 602.35 | |||
| SO43908_2 | 2400-4CA7-88 | PO6670111729 | 100 | 281 | 310 | 432 | 2 | 2021-11-22 | 2146.96 | 53.67 | 2021-11-10 | 1 | 2171.29 | 1 | 2146.96 | 2 | SO43908 | 2021-11-17 | 171.76 | 2171.29 | 2146.96 | |||
| SO51132_17 | D4A8-472C-A4 | PO18444136544 | 19 | 291 | 374 | 227 | 6 | 2023-10-22 | 8796.06 | 219.90 | 2023-10-10 | 6 | 1554.95 | 1 | 8796.06 | 17 | SO51132 | 2023-10-17 | 703.68 | 9329.69 | 1466.01 | |||
| SO59012_47 | 6620-4CEA-A0 | PO7685122244 | 100 | 283 | 217 | 539 | 2 | 2024-03-23 | 104.97 | 2.62 | 2024-03-11 | 5 | 13.09 | 1 | 104.97 | 47 | SO59012 | 2024-03-18 | 8.40 | 65.43 | 20.99 | |||
| SO43908_3 | 2400-4CA7-88 | PO6670111729 | 100 | 281 | 232 | 432 | 2 | 2021-11-22 | 57.68 | 1.44 | 2021-11-10 | 2 | 31.72 | 1 | 57.68 | 3 | SO43908 | 2021-11-17 | 4.61 | 63.45 | 28.84 | |||
| SO51132_18 | D4A8-472C-A4 | PO18444136544 | 19 | 291 | 442 | 227 | 6 | 2023-10-22 | 4294.50 | 107.36 | 2023-10-10 | 5 | 868.63 | 1 | 4294.50 | 18 | SO51132 | 2023-10-17 | 343.56 | 4343.17 | 858.90 | |||
| SO59012_48 | 6620-4CEA-A0 | PO7685122244 | 100 | 283 | 560 | 539 | 2 | 2024-03-23 | 4373.46 | 109.34 | 2024-03-11 | 6 | 755.15 | 1 | 4373.46 | 48 | SO59012 | 2024-03-18 | 349.88 | 4530.90 | 728.91 | |||
| SO43909_1 | 9467-4A37-A4 | PO7221199520 | 100 | 289 | 350 | 326 | 1 | 2021-11-22 | 4049.99 | 101.25 | 2021-11-10 | 2 | 1898.09 | 1 | 4049.99 | 1 | SO43909 | 2021-11-17 | 324.00 | 3796.19 | 2024.99 | |||
| SO51132_19 | D4A8-472C-A4 | PO18444136544 | 19 | 291 | 580 | 3 | 227 | 6 | 1029.10 | 2023-10-22 | 20581.98 | 488.82 | 2023-10-10 | 22 | 1082.51 | 1 | 19552.88 | 19 | SO51132 | 2023-10-17 | 1564.23 | 23815.22 | 935.54 | 0.05 |
| SO59012_49 | 6620-4CEA-A0 | PO7685122244 | 100 | 283 | 225 | 539 | 2 | 2024-03-23 | 37.76 | 0.94 | 2024-03-11 | 7 | 6.92 | 1 | 37.76 | 49 | SO59012 | 2024-03-18 | 3.02 | 48.46 | 5.39 | |||
| SO43909_2 | 9467-4A37-A4 | PO7221199520 | 100 | 289 | 349 | 326 | 1 | 2021-11-22 | 6074.98 | 151.87 | 2021-11-10 | 3 | 1898.09 | 1 | 6074.98 | 2 | SO43909 | 2021-11-17 | 486.00 | 5694.28 | 2024.99 | |||
| SO51132_20 | D4A8-472C-A4 | PO18444136544 | 19 | 291 | 408 | 227 | 6 | 2023-10-22 | 216.49 | 5.41 | 2023-10-10 | 3 | 53.40 | 1 | 216.49 | 20 | SO51132 | 2023-10-17 | 17.32 | 160.20 | 72.16 | |||
| SO59012_50 | 6620-4CEA-A0 | PO7685122244 | 100 | 283 | 568 | 539 | 2 | 2024-03-23 | 1336.23 | 33.41 | 2024-03-11 | 3 | 461.44 | 1 | 1336.23 | 50 | SO59012 | 2024-03-18 | 106.90 | 1384.33 | 445.41 | |||
| SO43909_3 | 9467-4A37-A4 | PO7221199520 | 100 | 289 | 296 | 326 | 1 | 2021-11-22 | 2144.11 | 53.60 | 2021-11-10 | 3 | 617.03 | 1 | 2144.11 | 3 | SO43909 | 2021-11-17 | 171.53 | 1851.08 | 714.70 | |||
| SO51132_21 | D4A8-472C-A4 | PO18444136544 | 19 | 291 | 281 | 227 | 6 | 2023-10-22 | 809.33 | 20.23 | 2023-10-10 | 4 | 204.63 | 1 | 809.33 | 21 | SO51132 | 2023-10-17 | 64.75 | 818.50 | 202.33 | |||
| SO59012_51 | 6620-4CEA-A0 | PO7685122244 | 100 | 283 | 585 | 539 | 2 | 2024-03-23 | 1336.23 | 33.41 | 2024-03-11 | 3 | 461.44 | 1 | 1336.23 | 51 | SO59012 | 2024-03-18 | 106.90 | 1384.33 | 445.41 | |||
| SO43909_4 | 9467-4A37-A4 | PO7221199520 | 100 | 289 | 292 | 326 | 1 | 2021-11-22 | 818.70 | 20.47 | 2021-11-10 | 1 | 706.81 | 1 | 818.70 | 4 | SO43909 | 2021-11-17 | 65.50 | 706.81 | 818.70 | |||
| SO51132_22 | D4A8-472C-A4 | PO18444136544 | 19 | 291 | 384 | 227 | 6 | 2023-10-22 | 2689.18 | 67.23 | 2023-10-10 | 4 | 713.08 | 1 | 2689.18 | 22 | SO51132 | 2023-10-17 | 215.13 | 2852.32 | 672.29 | |||
| SO59012_52 | 6620-4CEA-A0 | PO7685122244 | 100 | 283 | 567 | 539 | 2 | 2024-03-23 | 890.82 | 22.27 | 2024-03-11 | 2 | 461.44 | 1 | 890.82 | 52 | SO59012 | 2024-03-18 | 71.27 | 922.89 | 445.41 | |||
| SO43909_5 | 9467-4A37-A4 | PO7221199520 | 100 | 289 | 347 | 326 | 1 | 2021-11-22 | 4079.99 | 102.00 | 2021-11-10 | 2 | 1912.15 | 1 | 4079.99 | 5 | SO43909 | 2021-11-17 | 326.40 | 3824.31 | 2039.99 | |||
| SO51132_23 | D4A8-472C-A4 | PO18444136544 | 19 | 291 | 583 | 227 | 6 | 2023-10-22 | 8164.75 | 204.12 | 2023-10-10 | 8 | 1082.51 | 1 | 8164.75 | 23 | SO51132 | 2023-10-17 | 653.18 | 8660.08 | 1020.59 | |||
| SO59013_1 | C224-4535-BA | PO5597199820 | 100 | 281 | 512 | 75 | 4 | 2024-03-23 | 218.45 | 5.46 | 2024-03-11 | 1 | 199.38 | 1 | 218.45 | 1 | SO59013 | 2024-03-18 | 17.48 | 199.38 | 218.45 | |||
| SO43909_6 | 9467-4A37-A4 | PO7221199520 | 100 | 289 | 351 | 326 | 1 | 2021-11-22 | 6074.98 | 151.87 | 2021-11-10 | 3 | 1898.09 | 1 | 6074.98 | 6 | SO43909 | 2021-11-17 | 486.00 | 5694.28 | 2024.99 | |||
| SO51132_24 | D4A8-472C-A4 | PO18444136544 | 19 | 291 | 482 | 227 | 6 | 2023-10-22 | 16.18 | 0.40 | 2023-10-10 | 3 | 3.36 | 1 | 16.18 | 24 | SO51132 | 2023-10-17 | 1.29 | 10.09 | 5.39 | |||
| SO59013_2 | C224-4535-BA | PO5597199820 | 100 | 281 | 556 | 75 | 4 | 2024-03-23 | 315.88 | 7.90 | 2024-03-11 | 3 | 77.92 | 1 | 315.88 | 2 | SO59013 | 2024-03-18 | 25.27 | 233.75 | 105.29 | |||
| SO43909_7 | 9467-4A37-A4 | PO7221199520 | 100 | 289 | 304 | 326 | 1 | 2021-11-22 | 1429.41 | 35.74 | 2021-11-10 | 2 | 617.03 | 1 | 1429.41 | 7 | SO43909 | 2021-11-17 | 114.35 | 1234.06 | 714.70 |
Generated 2024-11-10 02:11:51.789 UTC