[ROOT] dt FactResellerSale < WHERE DimSalesTerritoryId EQ '5' > < SKIP 2242 > < 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 |
---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
SO51853_26 | 3754-4D33-92 | PO3596145757 | 100 | 285 | 543 | 476 | 5 | 2023-10-04 | 111.76 | 2.79 | 2023-09-22 | 3 | 27.57 | 1 | 111.76 | 26 | SO51853 | 2023-09-29 | 8.94 | 82.70 | 37.25 | |||
SO63220_6 | 25AE-42A1-80 | PO9773177410 | 100 | 285 | 564 | 8 | 5 | 2024-04-05 | 1430.44 | 35.76 | 2024-03-24 | 1 | 1481.94 | 1 | 1430.44 | 6 | SO63220 | 2024-03-31 | 114.44 | 1481.94 | 1430.44 | |||
SO48395_28 | 46D3-4C51-AD | PO9570174316 | 100 | 285 | 352 | 585 | 5 | 2023-02-03 | 6214.26 | 155.36 | 2023-01-22 | 5 | 1117.86 | 1 | 6214.26 | 28 | SO48395 | 2023-01-29 | 497.14 | 5589.28 | 1242.85 | |||
SO51853_27 | 3754-4D33-92 | PO3596145757 | 100 | 285 | 363 | 476 | 5 | 2023-10-04 | 1376.99 | 34.42 | 2023-09-22 | 1 | 1251.98 | 1 | 1376.99 | 27 | SO51853 | 2023-09-29 | 110.16 | 1251.98 | 1376.99 | |||
SO63228_1 | 8736-4385-98 | PO11542125349 | 100 | 285 | 390 | 62 | 5 | 2024-04-05 | 672.29 | 16.81 | 2024-03-24 | 1 | 713.08 | 1 | 672.29 | 1 | SO63228 | 2024-03-31 | 53.78 | 713.08 | 672.29 | |||
SO48395_29 | 46D3-4C51-AD | PO9570174316 | 100 | 285 | 419 | 585 | 5 | 2023-02-03 | 52.65 | 1.32 | 2023-01-22 | 1 | 38.96 | 1 | 52.65 | 29 | SO48395 | 2023-01-29 | 4.21 | 38.96 | 52.65 | |||
SO51853_28 | 3754-4D33-92 | PO3596145757 | 100 | 285 | 400 | 476 | 5 | 2023-10-04 | 111.46 | 2.79 | 2023-09-22 | 3 | 27.49 | 1 | 111.46 | 28 | SO51853 | 2023-09-29 | 8.92 | 82.48 | 37.15 | |||
SO63228_2 | 8736-4385-98 | PO11542125349 | 100 | 285 | 382 | 62 | 5 | 2024-04-05 | 3361.47 | 84.04 | 2024-03-24 | 5 | 713.08 | 1 | 3361.47 | 2 | SO63228 | 2024-03-31 | 268.92 | 3565.40 | 672.29 | |||
SO48395_30 | 46D3-4C51-AD | PO9570174316 | 100 | 285 | 354 | 585 | 5 | 2023-02-03 | 2485.70 | 62.14 | 2023-01-22 | 2 | 1117.86 | 1 | 2485.70 | 30 | SO48395 | 2023-01-29 | 198.86 | 2235.71 | 1242.85 | |||
SO51853_29 | 3754-4D33-92 | PO3596145757 | 100 | 285 | 290 | 476 | 5 | 2023-10-04 | 818.70 | 20.47 | 2023-09-22 | 1 | 747.20 | 1 | 818.70 | 29 | SO51853 | 2023-09-29 | 65.50 | 747.20 | 818.70 | |||
SO63228_3 | 8736-4385-98 | PO11542125349 | 100 | 285 | 583 | 62 | 5 | 2024-04-05 | 1020.59 | 25.51 | 2024-03-24 | 1 | 1082.51 | 1 | 1020.59 | 3 | SO63228 | 2024-03-31 | 81.65 | 1082.51 | 1020.59 | |||
SO48395_31 | 46D3-4C51-AD | PO9570174316 | 100 | 285 | 356 | 585 | 5 | 2023-02-03 | 4971.41 | 124.29 | 2023-01-22 | 4 | 1117.86 | 1 | 4971.41 | 31 | SO48395 | 2023-01-29 | 397.71 | 4471.42 | 1242.85 | |||
SO51853_30 | 3754-4D33-92 | PO3596145757 | 100 | 285 | 596 | 476 | 5 | 2023-10-04 | 323.99 | 8.10 | 2023-09-22 | 1 | 294.58 | 1 | 323.99 | 30 | SO51853 | 2023-09-29 | 25.92 | 294.58 | 323.99 | |||
SO63228_4 | 8736-4385-98 | PO11542125349 | 100 | 285 | 481 | 62 | 5 | 2024-04-05 | 10.79 | 0.27 | 2024-03-24 | 2 | 3.36 | 1 | 10.79 | 4 | SO63228 | 2024-03-31 | 0.86 | 6.72 | 5.39 | |||
SO48395_32 | 46D3-4C51-AD | PO9570174316 | 100 | 285 | 236 | 585 | 5 | 2023-02-03 | 86.52 | 2.16 | 2023-01-22 | 3 | 29.08 | 1 | 86.52 | 32 | SO48395 | 2023-01-29 | 6.92 | 87.24 | 28.84 | |||
SO51853_31 | 3754-4D33-92 | PO3596145757 | 100 | 285 | 531 | 476 | 5 | 2023-10-04 | 299.75 | 7.49 | 2023-09-22 | 2 | 136.79 | 1 | 299.75 | 31 | SO51853 | 2023-09-29 | 23.98 | 273.57 | 149.87 | |||
SO63228_5 | 8736-4385-98 | PO11542125349 | 100 | 285 | 605 | 62 | 5 | 2024-04-05 | 2267.96 | 56.70 | 2024-03-24 | 7 | 343.65 | 1 | 2267.96 | 5 | SO63228 | 2024-03-31 | 181.44 | 2405.55 | 323.99 | |||
SO48395_33 | 46D3-4C51-AD | PO9570174316 | 100 | 285 | 469 | 585 | 5 | 2023-02-03 | 227.94 | 5.70 | 2023-01-22 | 10 | 15.67 | 1 | 227.94 | 33 | SO48395 | 2023-01-29 | 18.24 | 156.71 | 22.79 | |||
SO51853_32 | 3754-4D33-92 | PO3596145757 | 100 | 285 | 599 | 476 | 5 | 2023-10-04 | 971.98 | 24.30 | 2023-09-22 | 3 | 294.58 | 1 | 971.98 | 32 | SO51853 | 2023-09-29 | 77.76 | 883.74 | 323.99 | |||
SO63228_6 | 8736-4385-98 | PO11542125349 | 100 | 285 | 606 | 62 | 5 | 2024-04-05 | 1619.97 | 40.50 | 2024-03-24 | 5 | 343.65 | 1 | 1619.97 | 6 | SO63228 | 2024-03-31 | 129.60 | 1718.25 | 323.99 | |||
SO48395_34 | 46D3-4C51-AD | PO9570174316 | 100 | 285 | 213 | 585 | 5 | 2023-02-03 | 80.75 | 2.02 | 2023-01-22 | 4 | 13.88 | 1 | 80.75 | 34 | SO48395 | 2023-01-29 | 6.46 | 55.51 | 20.19 | |||
SO51853_33 | 3754-4D33-92 | PO3596145757 | 100 | 285 | 475 | 476 | 5 | 2023-10-04 | 83.99 | 2.10 | 2023-09-22 | 2 | 26.18 | 1 | 83.99 | 33 | SO51853 | 2023-09-29 | 6.72 | 52.35 | 41.99 | |||
SO63228_7 | 8736-4385-98 | PO11542125349 | 100 | 285 | 482 | 62 | 5 | 2024-04-05 | 21.58 | 0.54 | 2024-03-24 | 4 | 3.36 | 1 | 21.58 | 7 | SO63228 | 2024-03-31 | 1.73 | 13.45 | 5.39 | |||
SO48398_1 | E6C8-48FB-BB | PO9744171621 | 100 | 285 | 358 | 98 | 5 | 2023-02-03 | 2458.92 | 61.47 | 2023-01-22 | 2 | 1105.81 | 1 | 2458.92 | 1 | SO48398 | 2023-01-29 | 196.71 | 2211.62 | 1229.46 | |||
SO51853_34 | 3754-4D33-92 | PO3596145757 | 100 | 285 | 590 | 476 | 5 | 2023-10-04 | 923.39 | 23.08 | 2023-09-22 | 2 | 419.78 | 1 | 923.39 | 34 | SO51853 | 2023-09-29 | 73.87 | 839.56 | 461.69 | |||
SO63234_1 | 7538-4150-82 | PO10150167352 | 100 | 285 | 475 | 9 | 5 | 2024-04-05 | 41.99 | 1.05 | 2024-03-24 | 1 | 26.18 | 1 | 41.99 | 1 | SO63234 | 2024-03-31 | 3.36 | 26.18 | 41.99 | |||
SO48398_2 | E6C8-48FB-BB | PO9744171621 | 100 | 285 | 468 | 98 | 5 | 2023-02-03 | 22.79 | 0.57 | 2023-01-22 | 1 | 15.67 | 1 | 22.79 | 2 | SO48398 | 2023-01-29 | 1.82 | 15.67 | 22.79 | |||
SO51853_35 | 3754-4D33-92 | PO3596145757 | 100 | 285 | 517 | 476 | 5 | 2023-10-04 | 63.17 | 1.58 | 2023-09-22 | 2 | 23.37 | 1 | 63.17 | 35 | SO51853 | 2023-09-29 | 5.05 | 46.74 | 31.58 | |||
SO63234_2 | 7538-4150-82 | PO10150167352 | 100 | 285 | 398 | 9 | 5 | 2024-04-05 | 26.72 | 0.67 | 2024-03-24 | 1 | 19.78 | 1 | 26.72 | 2 | SO63234 | 2024-03-31 | 2.14 | 19.78 | 26.72 | |||
SO48398_3 | E6C8-48FB-BB | PO9744171621 | 100 | 285 | 360 | 98 | 5 | 2023-02-03 | 1229.46 | 30.74 | 2023-01-22 | 1 | 1105.81 | 1 | 1229.46 | 3 | SO48398 | 2023-01-29 | 98.36 | 1105.81 | 1229.46 | |||
SO51853_36 | 3754-4D33-92 | PO3596145757 | 100 | 285 | 532 | 476 | 5 | 2023-10-04 | 299.75 | 7.49 | 2023-09-22 | 2 | 136.79 | 1 | 299.75 | 36 | SO51853 | 2023-09-29 | 23.98 | 273.57 | 149.87 | |||
SO63234_3 | 7538-4150-82 | PO10150167352 | 100 | 285 | 588 | 9 | 5 | 2024-04-05 | 461.69 | 11.54 | 2024-03-24 | 1 | 419.78 | 1 | 461.69 | 3 | SO63234 | 2024-03-31 | 36.94 | 419.78 | 461.69 | |||
SO48730_1 | C918-466B-B1 | PO522152463 | 100 | 285 | 364 | 676 | 5 | 2023-03-06 | 1943.98 | 48.60 | 2023-02-22 | 3 | 598.44 | 1 | 1943.98 | 1 | SO48730 | 2023-03-01 | 155.52 | 1795.31 | 647.99 | |||
SO51854_1 | EC80-4677-9F | PO3335117872 | 100 | 285 | 404 | 152 | 5 | 2023-10-04 | 26.72 | 0.67 | 2023-09-22 | 1 | 19.78 | 1 | 26.72 | 1 | SO51854 | 2023-09-29 | 2.14 | 19.78 | 26.72 | |||
SO63235_1 | 2F82-44A0-A0 | PO5568158964 | 100 | 285 | 359 | 422 | 5 | 2024-04-05 | 2753.99 | 68.85 | 2024-03-24 | 2 | 1251.98 | 1 | 2753.99 | 1 | SO63235 | 2024-03-31 | 220.32 | 2503.96 | 1376.99 | |||
SO48730_2 | C918-466B-B1 | PO522152463 | 100 | 285 | 365 | 676 | 5 | 2023-03-06 | 1295.99 | 32.40 | 2023-02-22 | 2 | 598.44 | 1 | 1295.99 | 2 | SO48730 | 2023-03-01 | 103.68 | 1196.87 | 647.99 | |||
SO51864_1 | 2389-4E32-92 | PO5568126648 | 100 | 285 | 474 | 3 | 422 | 5 | 34.65 | 2023-10-04 | 692.90 | 16.46 | 2023-09-22 | 18 | 26.18 | 1 | 658.26 | 1 | SO51864 | 2023-09-29 | 52.66 | 471.17 | 38.49 | 0.05 |
SO63235_2 | 2F82-44A0-A0 | PO5568158964 | 100 | 285 | 475 | 422 | 5 | 2024-04-05 | 83.99 | 2.10 | 2024-03-24 | 2 | 26.18 | 1 | 83.99 | 2 | SO63235 | 2024-03-31 | 6.72 | 52.35 | 41.99 | |||
SO48730_3 | C918-466B-B1 | PO522152463 | 100 | 285 | 366 | 676 | 5 | 2023-03-06 | 647.99 | 16.20 | 2023-02-22 | 1 | 598.44 | 1 | 647.99 | 3 | SO48730 | 2023-03-01 | 51.84 | 598.44 | 647.99 | |||
SO51864_2 | 2389-4E32-92 | PO5568126648 | 100 | 285 | 477 | 422 | 5 | 2023-10-04 | 5.99 | 0.15 | 2023-09-22 | 2 | 1.87 | 1 | 5.99 | 2 | SO51864 | 2023-09-29 | 0.48 | 3.73 | 2.99 | |||
SO63235_3 | 2F82-44A0-A0 | PO5568158964 | 100 | 285 | 476 | 422 | 5 | 2024-04-05 | 167.98 | 4.20 | 2024-03-24 | 4 | 26.18 | 1 | 167.98 | 3 | SO63235 | 2024-03-31 | 13.44 | 104.71 | 41.99 | |||
SO48730_4 | C918-466B-B1 | PO522152463 | 100 | 285 | 367 | 676 | 5 | 2023-03-06 | 3887.96 | 97.20 | 2023-02-22 | 6 | 598.44 | 1 | 3887.96 | 4 | SO48730 | 2023-03-01 | 311.04 | 3590.61 | 647.99 | |||
SO51864_3 | 2389-4E32-92 | PO5568126648 | 100 | 285 | 472 | 422 | 5 | 2023-10-04 | 152.40 | 3.81 | 2023-09-22 | 4 | 23.75 | 1 | 152.40 | 3 | SO51864 | 2023-09-29 | 12.19 | 95.00 | 38.10 | |||
SO63235_4 | 2F82-44A0-A0 | PO5568158964 | 100 | 285 | 474 | 422 | 5 | 2024-04-05 | 419.94 | 10.50 | 2024-03-24 | 10 | 26.18 | 1 | 419.94 | 4 | SO63235 | 2024-03-31 | 33.60 | 261.76 | 41.99 | |||
SO48730_5 | C918-466B-B1 | PO522152463 | 100 | 285 | 358 | 676 | 5 | 2023-03-06 | 3688.38 | 92.21 | 2023-02-22 | 3 | 1105.81 | 1 | 3688.38 | 5 | SO48730 | 2023-03-01 | 295.07 | 3317.43 | 1229.46 | |||
SO51864_4 | 2389-4E32-92 | PO5568126648 | 100 | 285 | 483 | 422 | 5 | 2023-10-04 | 144.00 | 3.60 | 2023-09-22 | 2 | 44.88 | 1 | 144.00 | 4 | SO51864 | 2023-09-29 | 11.52 | 89.76 | 72.00 | |||
SO63238_1 | ED26-4E7B-83 | PO6293160371 | 100 | 285 | 546 | 612 | 5 | 2024-04-05 | 37.25 | 0.93 | 2024-03-24 | 1 | 27.57 | 1 | 37.25 | 1 | SO63238 | 2024-03-31 | 2.98 | 27.57 | 37.25 | |||
SO48730_6 | C918-466B-B1 | PO522152463 | 100 | 285 | 360 | 676 | 5 | 2023-03-06 | 3688.38 | 92.21 | 2023-02-22 | 3 | 1105.81 | 1 | 3688.38 | 6 | SO48730 | 2023-03-01 | 295.07 | 3317.43 | 1229.46 | |||
SO51864_5 | 2389-4E32-92 | PO5568126648 | 100 | 285 | 511 | 422 | 5 | 2023-10-04 | 1092.27 | 27.31 | 2023-09-22 | 5 | 199.38 | 1 | 1092.27 | 5 | SO51864 | 2023-09-29 | 87.38 | 996.88 | 218.45 | |||
SO63245_1 | 1025-4AD1-A1 | PO5800120355 | 100 | 285 | 559 | 63 | 5 | 2024-04-05 | 12.14 | 0.30 | 2024-03-24 | 1 | 8.99 | 1 | 12.14 | 1 | SO63245 | 2024-03-31 | 0.97 | 8.99 | 12.14 | |||
SO48730_7 | C918-466B-B1 | PO522152463 | 100 | 285 | 362 | 676 | 5 | 2023-03-06 | 3688.38 | 92.21 | 2023-02-22 | 3 | 1105.81 | 1 | 3688.38 | 7 | SO48730 | 2023-03-01 | 295.07 | 3317.43 | 1229.46 | |||
SO51864_6 | 2389-4E32-92 | PO5568126648 | 100 | 285 | 487 | 422 | 5 | 2023-10-04 | 98.98 | 2.47 | 2023-09-22 | 3 | 20.57 | 1 | 98.98 | 6 | SO51864 | 2023-09-29 | 7.92 | 61.70 | 32.99 | |||
SO63245_2 | 1025-4AD1-A1 | PO5800120355 | 100 | 285 | 516 | 63 | 5 | 2024-04-05 | 23.48 | 0.59 | 2024-03-24 | 1 | 17.38 | 1 | 23.48 | 2 | SO63245 | 2024-03-31 | 1.88 | 17.38 | 23.48 | |||
SO48730_8 | C918-466B-B1 | PO522152463 | 100 | 285 | 352 | 676 | 5 | 2023-03-06 | 7457.11 | 186.43 | 2023-02-22 | 6 | 1117.86 | 1 | 7457.11 | 8 | SO48730 | 2023-03-01 | 596.57 | 6707.14 | 1242.85 | |||
SO51864_7 | 2389-4E32-92 | PO5568126648 | 100 | 285 | 544 | 422 | 5 | 2023-10-04 | 97.19 | 2.43 | 2023-09-22 | 2 | 35.96 | 1 | 97.19 | 7 | SO51864 | 2023-09-29 | 7.78 | 71.92 | 48.59 | |||
SO63245_3 | 1025-4AD1-A1 | PO5800120355 | 100 | 285 | 359 | 63 | 5 | 2024-04-05 | 4130.98 | 103.27 | 2024-03-24 | 3 | 1251.98 | 1 | 4130.98 | 3 | SO63245 | 2024-03-31 | 330.48 | 3755.94 | 1376.99 |
Generated 2024-09-21 08:33:58.212 UTC