[ROOT] dt FactResellerSale < WHERE DimSalesTerritoryId EQ '3' > SKIP 0 < SKIP 3249 > < TAKE 62 >
62 items
FactResellerSaleId | CarrierTrackingNumber | CustomerPONumber | DimCurrencyId | DimEmployeeId | DimProductId | DimResellerId | DimSalesTerritoryId | DueDate | ExtendedAmount | Freight | OrderDate | OrderQuantity | ProductStandardCost | RevisionNumber | SalesAmount | SalesOrderLineNumber | SalesOrderNumber | ShipDate | TaxAmt | TotalProductCost | UnitPrice |
---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
SO46980_33 | FAA2-449B-99 | PO13572170679 | 100 | 287 | 407 | 527 | 3 | 2022-11-23 | 131.20 | 3.28 | 2022-11-11 | 2 | 48.55 | 1 | 131.20 | 33 | SO46980 | 2022-11-18 | 10.50 | 97.09 | 65.60 |
SO65309_1 | 2657-4F2D-AD | PO6902173230 | 100 | 281 | 476 | 543 | 3 | 2024-06-23 | 83.99 | 2.10 | 2024-06-11 | 2 | 26.18 | 1 | 83.99 | 1 | SO65309 | 2024-06-18 | 6.72 | 52.35 | 41.99 |
SO46980_34 | FAA2-449B-99 | PO13572170679 | 100 | 287 | 385 | 527 | 3 | 2022-11-23 | 600.26 | 15.01 | 2022-11-11 | 1 | 605.65 | 1 | 600.26 | 34 | SO46980 | 2022-11-18 | 48.02 | 605.65 | 600.26 |
SO65309_2 | 2657-4F2D-AD | PO6902173230 | 100 | 281 | 359 | 543 | 3 | 2024-06-23 | 4130.98 | 103.27 | 2024-06-11 | 3 | 1251.98 | 1 | 4130.98 | 2 | SO65309 | 2024-06-18 | 330.48 | 3755.94 | 1376.99 |
SO46980_35 | FAA2-449B-99 | PO13572170679 | 100 | 287 | 417 | 527 | 3 | 2022-11-23 | 973.36 | 24.33 | 2022-11-11 | 3 | 300.12 | 1 | 973.36 | 35 | SO46980 | 2022-11-18 | 77.87 | 900.36 | 324.45 |
SO65309_3 | 2657-4F2D-AD | PO6902173230 | 100 | 281 | 475 | 543 | 3 | 2024-06-23 | 83.99 | 2.10 | 2024-06-11 | 2 | 26.18 | 1 | 83.99 | 3 | SO65309 | 2024-06-18 | 6.72 | 52.35 | 41.99 |
SO46980_36 | FAA2-449B-99 | PO13572170679 | 100 | 287 | 389 | 527 | 3 | 2022-11-23 | 1200.53 | 30.01 | 2022-11-11 | 2 | 605.65 | 1 | 1200.53 | 36 | SO46980 | 2022-11-18 | 96.04 | 1211.30 | 600.26 |
SO65311_1 | 8732-477D-BC | PO7047142102 | 100 | 281 | 558 | 544 | 3 | 2024-06-23 | 242.99 | 6.07 | 2024-06-11 | 1 | 179.82 | 1 | 242.99 | 1 | SO65311 | 2024-06-18 | 19.44 | 179.82 | 242.99 |
SO46980_37 | FAA2-449B-99 | PO13572170679 | 100 | 287 | 379 | 527 | 3 | 2022-11-23 | 2617.88 | 65.45 | 2022-11-11 | 2 | 1320.68 | 1 | 2617.88 | 37 | SO46980 | 2022-11-18 | 209.43 | 2641.37 | 1308.94 |
SO65311_2 | 8732-477D-BC | PO7047142102 | 100 | 281 | 555 | 544 | 3 | 2024-06-23 | 191.70 | 4.79 | 2024-06-11 | 3 | 47.29 | 1 | 191.70 | 2 | SO65311 | 2024-06-18 | 15.34 | 141.86 | 63.90 |
SO46989_1 | 32DF-41DF-BF | PO12122190140 | 100 | 283 | 242 | 22 | 3 | 2022-11-23 | 2342.45 | 58.56 | 2022-11-11 | 3 | 722.26 | 1 | 2342.45 | 1 | SO46989 | 2022-11-18 | 187.40 | 2166.77 | 780.82 |
SO65311_3 | 8732-477D-BC | PO7047142102 | 100 | 281 | 355 | 544 | 3 | 2024-06-23 | 1391.99 | 34.80 | 2024-06-11 | 1 | 1265.62 | 1 | 1391.99 | 3 | SO65311 | 2024-06-18 | 111.36 | 1265.62 | 1391.99 |
SO46999_1 | 8B5C-4086-B9 | PO10788189891 | 100 | 281 | 242 | 468 | 3 | 2022-11-23 | 2342.45 | 58.56 | 2022-11-11 | 3 | 722.26 | 1 | 2342.45 | 1 | SO46999 | 2022-11-18 | 187.40 | 2166.77 | 780.82 |
SO65311_4 | 8732-477D-BC | PO7047142102 | 100 | 281 | 556 | 544 | 3 | 2024-06-23 | 421.18 | 10.53 | 2024-06-11 | 4 | 77.92 | 1 | 421.18 | 4 | SO65311 | 2024-06-18 | 33.69 | 311.67 | 105.29 |
SO46999_2 | 8B5C-4086-B9 | PO10788189891 | 100 | 281 | 236 | 468 | 3 | 2022-11-23 | 28.84 | 0.72 | 2022-11-11 | 1 | 29.08 | 1 | 28.84 | 2 | SO46999 | 2022-11-18 | 2.31 | 29.08 | 28.84 |
SO53526_19 | 6EEB-4506-89 | PO1624140151 | 100 | 281 | 378 | 579 | 3 | 2023-12-24 | 2932.02 | 73.30 | 2023-12-12 | 2 | 1554.95 | 1 | 2932.02 | 19 | SO53526 | 2023-12-19 | 234.56 | 3109.90 | 1466.01 |
SO53526_20 | 6EEB-4506-89 | PO1624140151 | 100 | 281 | 374 | 579 | 3 | 2023-12-24 | 2932.02 | 73.30 | 2023-12-12 | 2 | 1554.95 | 1 | 2932.02 | 20 | SO53526 | 2023-12-19 | 234.56 | 3109.90 | 1466.01 |
SO53526_21 | 6EEB-4506-89 | PO1624140151 | 100 | 281 | 605 | 579 | 3 | 2023-12-24 | 647.99 | 16.20 | 2023-12-12 | 2 | 343.65 | 1 | 647.99 | 21 | SO53526 | 2023-12-19 | 51.84 | 687.30 | 323.99 |
SO53526_22 | 6EEB-4506-89 | PO1624140151 | 100 | 281 | 606 | 579 | 3 | 2023-12-24 | 1295.98 | 32.40 | 2023-12-12 | 4 | 343.65 | 1 | 1295.98 | 22 | SO53526 | 2023-12-19 | 103.68 | 1374.60 | 323.99 |
SO53526_23 | 6EEB-4506-89 | PO1624140151 | 100 | 281 | 418 | 579 | 3 | 2023-12-24 | 1070.69 | 26.77 | 2023-12-12 | 3 | 360.94 | 1 | 1070.69 | 23 | SO53526 | 2023-12-19 | 85.66 | 1082.83 | 356.90 |
SO53526_24 | 6EEB-4506-89 | PO1624140151 | 100 | 281 | 440 | 579 | 3 | 2023-12-24 | 3435.60 | 85.89 | 2023-12-12 | 4 | 868.63 | 1 | 3435.60 | 24 | SO53526 | 2023-12-19 | 274.85 | 3474.54 | 858.90 |
SO53526_25 | 6EEB-4506-89 | PO1624140151 | 100 | 281 | 376 | 579 | 3 | 2023-12-24 | 1466.01 | 36.65 | 2023-12-12 | 1 | 1554.95 | 1 | 1466.01 | 25 | SO53526 | 2023-12-19 | 117.28 | 1554.95 | 1466.01 |
SO53526_26 | 6EEB-4506-89 | PO1624140151 | 100 | 281 | 583 | 579 | 3 | 2023-12-24 | 1020.59 | 25.51 | 2023-12-12 | 1 | 1082.51 | 1 | 1020.59 | 26 | SO53526 | 2023-12-19 | 81.65 | 1082.51 | 1020.59 |
SO53526_27 | 6EEB-4506-89 | PO1624140151 | 100 | 281 | 384 | 579 | 3 | 2023-12-24 | 1344.59 | 33.61 | 2023-12-12 | 2 | 713.08 | 1 | 1344.59 | 27 | SO53526 | 2023-12-19 | 107.57 | 1426.16 | 672.29 |
SO53526_28 | 6EEB-4506-89 | PO1624140151 | 100 | 281 | 520 | 579 | 3 | 2023-12-24 | 94.75 | 2.37 | 2023-12-12 | 3 | 23.37 | 1 | 94.75 | 28 | SO53526 | 2023-12-19 | 7.58 | 70.12 | 31.58 |
SO53526_29 | 6EEB-4506-89 | PO1624140151 | 100 | 281 | 408 | 579 | 3 | 2023-12-24 | 72.16 | 1.80 | 2023-12-12 | 1 | 53.40 | 1 | 72.16 | 29 | SO53526 | 2023-12-19 | 5.77 | 53.40 | 72.16 |
SO53548_1 | CF97-4D6F-95 | PO14268111072 | 100 | 281 | 390 | 418 | 3 | 2023-12-24 | 1344.59 | 33.61 | 2023-12-12 | 2 | 713.08 | 1 | 1344.59 | 1 | SO53548 | 2023-12-19 | 107.57 | 1426.16 | 672.29 |
SO53548_2 | CF97-4D6F-95 | PO14268111072 | 100 | 281 | 255 | 418 | 3 | 2023-12-24 | 202.33 | 5.06 | 2023-12-12 | 1 | 204.63 | 1 | 202.33 | 2 | SO53548 | 2023-12-19 | 16.19 | 204.63 | 202.33 |
SO53548_3 | CF97-4D6F-95 | PO14268111072 | 100 | 281 | 382 | 418 | 3 | 2023-12-24 | 2016.88 | 50.42 | 2023-12-12 | 3 | 713.08 | 1 | 2016.88 | 3 | SO53548 | 2023-12-19 | 161.35 | 2139.24 | 672.29 |
SO53548_4 | CF97-4D6F-95 | PO14268111072 | 100 | 281 | 481 | 418 | 3 | 2023-12-24 | 21.58 | 0.54 | 2023-12-12 | 4 | 3.36 | 1 | 21.58 | 4 | SO53548 | 2023-12-19 | 1.73 | 13.45 | 5.39 |
SO53548_5 | CF97-4D6F-95 | PO14268111072 | 100 | 281 | 482 | 418 | 3 | 2023-12-24 | 21.58 | 0.54 | 2023-12-12 | 4 | 3.36 | 1 | 21.58 | 5 | SO53548 | 2023-12-19 | 1.73 | 13.45 | 5.39 |
SO53548_6 | CF97-4D6F-95 | PO14268111072 | 100 | 281 | 436 | 418 | 3 | 2023-12-24 | 713.80 | 17.84 | 2023-12-12 | 2 | 360.94 | 1 | 713.80 | 6 | SO53548 | 2023-12-19 | 57.10 | 721.89 | 356.90 |
SO53548_7 | CF97-4D6F-95 | PO14268111072 | 100 | 281 | 388 | 418 | 3 | 2023-12-24 | 672.29 | 16.81 | 2023-12-12 | 1 | 713.08 | 1 | 672.29 | 7 | SO53548 | 2023-12-19 | 53.78 | 713.08 | 672.29 |
SO53548_8 | CF97-4D6F-95 | PO14268111072 | 100 | 281 | 408 | 418 | 3 | 2023-12-24 | 144.32 | 3.61 | 2023-12-12 | 2 | 53.40 | 1 | 144.32 | 8 | SO53548 | 2023-12-19 | 11.55 | 106.80 | 72.16 |
SO53548_9 | CF97-4D6F-95 | PO14268111072 | 100 | 281 | 287 | 418 | 3 | 2023-12-24 | 1213.99 | 30.35 | 2023-12-12 | 6 | 204.63 | 1 | 1213.99 | 9 | SO53548 | 2023-12-19 | 97.12 | 1227.75 | 202.33 |
SO53548_10 | CF97-4D6F-95 | PO14268111072 | 100 | 281 | 434 | 418 | 3 | 2023-12-24 | 713.80 | 17.84 | 2023-12-12 | 2 | 360.94 | 1 | 713.80 | 10 | SO53548 | 2023-12-19 | 57.10 | 721.89 | 356.90 |
SO53548_11 | CF97-4D6F-95 | PO14268111072 | 100 | 281 | 583 | 418 | 3 | 2023-12-24 | 1020.59 | 25.51 | 2023-12-12 | 1 | 1082.51 | 1 | 1020.59 | 11 | SO53548 | 2023-12-19 | 81.65 | 1082.51 | 1020.59 |
SO53548_12 | CF97-4D6F-95 | PO14268111072 | 100 | 281 | 380 | 418 | 3 | 2023-12-24 | 2932.02 | 73.30 | 2023-12-12 | 2 | 1554.95 | 1 | 2932.02 | 12 | SO53548 | 2023-12-19 | 234.56 | 3109.90 | 1466.01 |
SO53548_13 | CF97-4D6F-95 | PO14268111072 | 100 | 281 | 582 | 418 | 3 | 2023-12-24 | 1020.59 | 25.51 | 2023-12-12 | 1 | 1082.51 | 1 | 1020.59 | 13 | SO53548 | 2023-12-19 | 81.65 | 1082.51 | 1020.59 |
SO53548_14 | CF97-4D6F-95 | PO14268111072 | 100 | 281 | 581 | 418 | 3 | 2023-12-24 | 5102.97 | 127.57 | 2023-12-12 | 5 | 1082.51 | 1 | 5102.97 | 14 | SO53548 | 2023-12-19 | 408.24 | 5412.55 | 1020.59 |
SO53548_15 | CF97-4D6F-95 | PO14268111072 | 100 | 281 | 605 | 418 | 3 | 2023-12-24 | 647.99 | 16.20 | 2023-12-12 | 2 | 343.65 | 1 | 647.99 | 15 | SO53548 | 2023-12-19 | 51.84 | 687.30 | 323.99 |
SO53548_16 | CF97-4D6F-95 | PO14268111072 | 100 | 281 | 604 | 418 | 3 | 2023-12-24 | 323.99 | 8.10 | 2023-12-12 | 1 | 343.65 | 1 | 323.99 | 16 | SO53548 | 2023-12-19 | 25.92 | 343.65 | 323.99 |
SO53548_17 | CF97-4D6F-95 | PO14268111072 | 100 | 281 | 378 | 418 | 3 | 2023-12-24 | 4398.03 | 109.95 | 2023-12-12 | 3 | 1554.95 | 1 | 4398.03 | 17 | SO53548 | 2023-12-19 | 351.84 | 4664.84 | 1466.01 |
SO53548_18 | CF97-4D6F-95 | PO14268111072 | 100 | 281 | 372 | 418 | 3 | 2023-12-24 | 1466.01 | 36.65 | 2023-12-12 | 1 | 1554.95 | 1 | 1466.01 | 18 | SO53548 | 2023-12-19 | 117.28 | 1554.95 | 1466.01 |
SO53548_19 | CF97-4D6F-95 | PO14268111072 | 100 | 281 | 374 | 418 | 3 | 2023-12-24 | 1466.01 | 36.65 | 2023-12-12 | 1 | 1554.95 | 1 | 1466.01 | 19 | SO53548 | 2023-12-19 | 117.28 | 1554.95 | 1466.01 |
SO53548_20 | CF97-4D6F-95 | PO14268111072 | 100 | 281 | 418 | 418 | 3 | 2023-12-24 | 356.90 | 8.92 | 2023-12-12 | 1 | 360.94 | 1 | 356.90 | 20 | SO53548 | 2023-12-19 | 28.55 | 360.94 | 356.90 |
SO53548_21 | CF97-4D6F-95 | PO14268111072 | 100 | 281 | 384 | 418 | 3 | 2023-12-24 | 672.29 | 16.81 | 2023-12-12 | 1 | 713.08 | 1 | 672.29 | 21 | SO53548 | 2023-12-19 | 53.78 | 713.08 | 672.29 |
SO53548_22 | CF97-4D6F-95 | PO14268111072 | 100 | 281 | 606 | 418 | 3 | 2023-12-24 | 323.99 | 8.10 | 2023-12-12 | 1 | 343.65 | 1 | 323.99 | 22 | SO53548 | 2023-12-19 | 25.92 | 343.65 | 323.99 |
SO53548_23 | CF97-4D6F-95 | PO14268111072 | 100 | 281 | 546 | 418 | 3 | 2023-12-24 | 186.27 | 4.66 | 2023-12-12 | 5 | 27.57 | 1 | 186.27 | 23 | SO53548 | 2023-12-19 | 14.90 | 137.84 | 37.25 |
SO53548_24 | CF97-4D6F-95 | PO14268111072 | 100 | 281 | 376 | 418 | 3 | 2023-12-24 | 5864.04 | 146.60 | 2023-12-12 | 4 | 1554.95 | 1 | 5864.04 | 24 | SO53548 | 2023-12-19 | 469.12 | 6219.79 | 1466.01 |
SO53548_25 | CF97-4D6F-95 | PO14268111072 | 100 | 281 | 547 | 418 | 3 | 2023-12-24 | 48.59 | 1.21 | 2023-12-12 | 1 | 35.96 | 1 | 48.59 | 25 | SO53548 | 2023-12-19 | 3.89 | 35.96 | 48.59 |
SO53548_26 | CF97-4D6F-95 | PO14268111072 | 100 | 281 | 386 | 418 | 3 | 2023-12-24 | 672.29 | 16.81 | 2023-12-12 | 1 | 713.08 | 1 | 672.29 | 26 | SO53548 | 2023-12-19 | 53.78 | 713.08 | 672.29 |
SO53548_27 | CF97-4D6F-95 | PO14268111072 | 100 | 281 | 545 | 418 | 3 | 2023-12-24 | 24.29 | 0.61 | 2023-12-12 | 1 | 17.98 | 1 | 24.29 | 27 | SO53548 | 2023-12-19 | 1.94 | 17.98 | 24.29 |
SO53561_1 | CDF6-4B12-87 | PO7047187583 | 100 | 281 | 559 | 544 | 3 | 2023-12-24 | 72.86 | 1.82 | 2023-12-12 | 6 | 8.99 | 1 | 72.86 | 1 | SO53561 | 2023-12-19 | 5.83 | 53.92 | 12.14 |
SO53561_2 | CDF6-4B12-87 | PO7047187583 | 100 | 281 | 290 | 544 | 3 | 2023-12-24 | 818.70 | 20.47 | 2023-12-12 | 1 | 747.20 | 1 | 818.70 | 2 | SO53561 | 2023-12-19 | 65.50 | 747.20 | 818.70 |
SO53561_3 | CDF6-4B12-87 | PO7047187583 | 100 | 281 | 592 | 544 | 3 | 2023-12-24 | 1355.98 | 33.90 | 2023-12-12 | 4 | 308.22 | 1 | 1355.98 | 3 | SO53561 | 2023-12-19 | 108.48 | 1232.87 | 338.99 |
SO53561_4 | CDF6-4B12-87 | PO7047187583 | 100 | 281 | 588 | 544 | 3 | 2023-12-24 | 1846.78 | 46.17 | 2023-12-12 | 4 | 419.78 | 1 | 1846.78 | 4 | SO53561 | 2023-12-19 | 147.74 | 1679.11 | 461.69 |
SO53561_5 | CDF6-4B12-87 | PO7047187583 | 100 | 281 | 526 | 544 | 3 | 2023-12-24 | 158.43 | 3.96 | 2023-12-12 | 1 | 144.59 | 1 | 158.43 | 5 | SO53561 | 2023-12-19 | 12.67 | 144.59 | 158.43 |
SO53561_6 | CDF6-4B12-87 | PO7047187583 | 100 | 281 | 306 | 544 | 3 | 2023-12-24 | 809.76 | 20.24 | 2023-12-12 | 1 | 739.04 | 1 | 809.76 | 6 | SO53561 | 2023-12-19 | 64.78 | 739.04 | 809.76 |
SO53561_7 | CDF6-4B12-87 | PO7047187583 | 100 | 281 | 552 | 544 | 3 | 2023-12-24 | 219.58 | 5.49 | 2023-12-12 | 4 | 40.62 | 1 | 219.58 | 7 | SO53561 | 2023-12-19 | 17.57 | 162.49 | 54.89 |
SO53561_8 | CDF6-4B12-87 | PO7047187583 | 100 | 281 | 533 | 544 | 3 | 2023-12-24 | 149.87 | 3.75 | 2023-12-12 | 1 | 136.79 | 1 | 149.87 | 8 | SO53561 | 2023-12-19 | 11.99 | 136.79 | 149.87 |
SO53561_9 | CDF6-4B12-87 | PO7047187583 | 100 | 281 | 357 | 544 | 3 | 2023-12-24 | 4175.98 | 104.40 | 2023-12-12 | 3 | 1265.62 | 1 | 4175.98 | 9 | SO53561 | 2023-12-19 | 334.08 | 3796.86 | 1391.99 |
Generated 2024-11-10 07:48:20.272 UTC