[ROOT] dt FactResellerSale < WHERE DimSalesTerritoryId EQ '4' > < SKIP 7344 > < 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 |
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
| SO45798_16 | 3FA4-4459-BD | PO10817199969 | 100 | 287 | 312 | 203 | 4 | 2022-07-28 | 6440.89 | 161.02 | 2022-07-16 | 3 | 2171.29 | 1 | 6440.89 | 16 | SO45798 | 2022-07-23 | 515.27 | 6513.88 | 2146.96 | |||
| SO45798_17 | 3FA4-4459-BD | PO10817199969 | 100 | 287 | 262 | 203 | 4 | 2022-07-28 | 183.94 | 4.60 | 2022-07-16 | 1 | 181.49 | 1 | 183.94 | 17 | SO45798 | 2022-07-23 | 14.72 | 181.49 | 183.94 | |||
| SO45798_18 | 3FA4-4459-BD | PO10817199969 | 100 | 287 | 229 | 203 | 4 | 2022-07-28 | 86.52 | 2.16 | 2022-07-16 | 3 | 31.72 | 1 | 86.52 | 18 | SO45798 | 2022-07-23 | 6.92 | 95.17 | 28.84 | |||
| SO45798_19 | 3FA4-4459-BD | PO10817199969 | 100 | 287 | 235 | 203 | 4 | 2022-07-28 | 144.20 | 3.61 | 2022-07-16 | 5 | 31.72 | 1 | 144.20 | 19 | SO45798 | 2022-07-23 | 11.54 | 158.62 | 28.84 | |||
| SO45798_20 | 3FA4-4459-BD | PO10817199969 | 100 | 287 | 320 | 203 | 4 | 2022-07-28 | 1258.38 | 31.46 | 2022-07-16 | 3 | 413.15 | 1 | 1258.38 | 20 | SO45798 | 2022-07-23 | 100.67 | 1239.44 | 419.46 | |||
| SO45798_21 | 3FA4-4459-BD | PO10817199969 | 100 | 287 | 322 | 203 | 4 | 2022-07-28 | 419.46 | 10.49 | 2022-07-16 | 1 | 413.15 | 1 | 419.46 | 21 | SO45798 | 2022-07-23 | 33.56 | 413.15 | 419.46 | |||
| SO45798_22 | 3FA4-4459-BD | PO10817199969 | 100 | 287 | 270 | 203 | 4 | 2022-07-28 | 367.88 | 9.20 | 2022-07-16 | 2 | 181.49 | 1 | 367.88 | 22 | SO45798 | 2022-07-23 | 29.43 | 362.97 | 183.94 | |||
| SO45798_23 | 3FA4-4459-BD | PO10817199969 | 100 | 287 | 275 | 203 | 4 | 2022-07-28 | 713.80 | 17.84 | 2022-07-16 | 2 | 352.14 | 1 | 713.80 | 23 | SO45798 | 2022-07-23 | 57.10 | 704.28 | 356.90 | |||
| SO45798_24 | 3FA4-4459-BD | PO10817199969 | 100 | 287 | 311 | 203 | 4 | 2022-07-28 | 4293.92 | 107.35 | 2022-07-16 | 2 | 2171.29 | 1 | 4293.92 | 24 | SO45798 | 2022-07-23 | 343.51 | 4342.59 | 2146.96 | |||
| SO45798_25 | 3FA4-4459-BD | PO10817199969 | 100 | 287 | 314 | 203 | 4 | 2022-07-28 | 2146.96 | 53.67 | 2022-07-16 | 1 | 2171.29 | 1 | 2146.96 | 25 | SO45798 | 2022-07-23 | 171.76 | 2171.29 | 2146.96 | |||
| SO45798_26 | 3FA4-4459-BD | PO10817199969 | 100 | 287 | 319 | 203 | 4 | 2022-07-28 | 2624.38 | 65.61 | 2022-07-16 | 3 | 884.71 | 1 | 2624.38 | 26 | SO45798 | 2022-07-23 | 209.95 | 2654.12 | 874.79 | |||
| SO45798_27 | 3FA4-4459-BD | PO10817199969 | 100 | 287 | 223 | 203 | 4 | 2022-07-28 | 5.19 | 0.13 | 2022-07-16 | 1 | 5.71 | 1 | 5.19 | 27 | SO45798 | 2022-07-23 | 0.41 | 5.71 | 5.19 | |||
| SO45799_1 | 4DE8-4B9B-A1 | PO10730195041 | 100 | 287 | 326 | 491 | 4 | 2022-07-28 | 419.46 | 10.49 | 2022-07-16 | 1 | 413.15 | 1 | 419.46 | 1 | SO45799 | 2022-07-23 | 33.56 | 413.15 | 419.46 | |||
| SO45799_2 | 4DE8-4B9B-A1 | PO10730195041 | 100 | 287 | 311 | 491 | 4 | 2022-07-28 | 6440.89 | 161.02 | 2022-07-16 | 3 | 2171.29 | 1 | 6440.89 | 2 | SO45799 | 2022-07-23 | 515.27 | 6513.88 | 2146.96 | |||
| SO45799_3 | 4DE8-4B9B-A1 | PO10730195041 | 100 | 287 | 253 | 491 | 4 | 2022-07-28 | 178.58 | 4.46 | 2022-07-16 | 1 | 176.20 | 1 | 178.58 | 3 | SO45799 | 2022-07-23 | 14.29 | 176.20 | 178.58 | |||
| SO45799_4 | 4DE8-4B9B-A1 | PO10730195041 | 100 | 287 | 232 | 491 | 4 | 2022-07-28 | 144.20 | 3.61 | 2022-07-16 | 5 | 31.72 | 1 | 144.20 | 4 | SO45799 | 2022-07-23 | 11.54 | 158.62 | 28.84 | |||
| SO69466_27 | 8B97-4CC6-8A | PO2523169620 | 100 | 287 | 484 | 167 | 4 | 2024-08-27 | 19.08 | 0.48 | 2024-08-15 | 4 | 2.97 | 1 | 19.08 | 27 | SO69466 | 2024-08-22 | 1.53 | 11.89 | 4.77 | |||
| SO69466_28 | 8B97-4CC6-8A | PO2523169620 | 100 | 287 | 606 | 167 | 4 | 2024-08-27 | 1619.97 | 40.50 | 2024-08-15 | 5 | 343.65 | 1 | 1619.97 | 28 | SO69466 | 2024-08-22 | 129.60 | 1718.25 | 323.99 | |||
| SO69466_29 | 8B97-4CC6-8A | PO2523169620 | 100 | 287 | 605 | 167 | 4 | 2024-08-27 | 647.99 | 16.20 | 2024-08-15 | 2 | 343.65 | 1 | 647.99 | 29 | SO69466 | 2024-08-22 | 51.84 | 687.30 | 323.99 | |||
| SO69466_30 | 8B97-4CC6-8A | PO2523169620 | 100 | 287 | 580 | 167 | 4 | 2024-08-27 | 3061.78 | 76.54 | 2024-08-15 | 3 | 1082.51 | 1 | 3061.78 | 30 | SO69466 | 2024-08-22 | 244.94 | 3247.53 | 1020.59 | |||
| SO69466_31 | 8B97-4CC6-8A | PO2523169620 | 100 | 287 | 390 | 167 | 4 | 2024-08-27 | 672.29 | 16.81 | 2024-08-15 | 1 | 713.08 | 1 | 672.29 | 31 | SO69466 | 2024-08-22 | 53.78 | 713.08 | 672.29 | |||
| SO69466_32 | 8B97-4CC6-8A | PO2523169620 | 100 | 287 | 384 | 167 | 4 | 2024-08-27 | 672.29 | 16.81 | 2024-08-15 | 1 | 713.08 | 1 | 672.29 | 32 | SO69466 | 2024-08-22 | 53.78 | 713.08 | 672.29 | |||
| SO69466_33 | 8B97-4CC6-8A | PO2523169620 | 100 | 287 | 490 | 167 | 4 | 2024-08-27 | 129.58 | 3.24 | 2024-08-15 | 4 | 41.57 | 1 | 129.58 | 33 | SO69466 | 2024-08-22 | 10.37 | 166.29 | 32.39 | |||
| SO69466_34 | 8B97-4CC6-8A | PO2523169620 | 100 | 287 | 465 | 167 | 4 | 2024-08-27 | 88.16 | 2.20 | 2024-08-15 | 6 | 9.16 | 1 | 88.16 | 34 | SO69466 | 2024-08-22 | 7.05 | 54.96 | 14.69 | |||
| SO69466_35 | 8B97-4CC6-8A | PO2523169620 | 100 | 287 | 376 | 167 | 4 | 2024-08-27 | 2932.02 | 73.30 | 2024-08-15 | 2 | 1554.95 | 1 | 2932.02 | 35 | SO69466 | 2024-08-22 | 234.56 | 3109.90 | 1466.01 | |||
| SO69466_36 | 8B97-4CC6-8A | PO2523169620 | 100 | 287 | 222 | 167 | 4 | 2024-08-27 | 20.99 | 0.52 | 2024-08-15 | 1 | 13.09 | 1 | 20.99 | 36 | SO69466 | 2024-08-22 | 1.68 | 13.09 | 20.99 | |||
| SO69466_37 | 8B97-4CC6-8A | PO2523169620 | 100 | 287 | 471 | 167 | 4 | 2024-08-27 | 266.70 | 6.67 | 2024-08-15 | 7 | 23.75 | 1 | 266.70 | 37 | SO69466 | 2024-08-22 | 21.34 | 166.24 | 38.10 | |||
| SO69486_1 | 6CD1-406A-B1 | PO15747152209 | 100 | 281 | 606 | 471 | 4 | 2024-08-27 | 323.99 | 8.10 | 2024-08-15 | 1 | 343.65 | 1 | 323.99 | 1 | SO69486 | 2024-08-22 | 25.92 | 343.65 | 323.99 | |||
| SO69501_1 | 8A65-4926-A6 | PO6525182870 | 100 | 281 | 400 | 345 | 4 | 2024-08-27 | 74.30 | 1.86 | 2024-08-15 | 2 | 27.49 | 1 | 74.30 | 1 | SO69501 | 2024-08-22 | 5.94 | 54.99 | 37.15 | |||
| SO69501_2 | 8A65-4926-A6 | PO6525182870 | 100 | 281 | 542 | 345 | 4 | 2024-08-27 | 48.59 | 1.21 | 2024-08-15 | 2 | 17.98 | 1 | 48.59 | 2 | SO69501 | 2024-08-22 | 3.89 | 35.96 | 24.29 | |||
| SO69501_3 | 8A65-4926-A6 | PO6525182870 | 100 | 281 | 544 | 345 | 4 | 2024-08-27 | 97.19 | 2.43 | 2024-08-15 | 2 | 35.96 | 1 | 97.19 | 3 | SO69501 | 2024-08-22 | 7.78 | 71.92 | 48.59 | |||
| SO69501_4 | 8A65-4926-A6 | PO6525182870 | 100 | 281 | 515 | 345 | 4 | 2024-08-27 | 16.27 | 0.41 | 2024-08-15 | 1 | 12.04 | 1 | 16.27 | 4 | SO69501 | 2024-08-22 | 1.30 | 12.04 | 16.27 | |||
| SO69501_5 | 8A65-4926-A6 | PO6525182870 | 100 | 281 | 517 | 345 | 4 | 2024-08-27 | 31.58 | 0.79 | 2024-08-15 | 1 | 23.37 | 1 | 31.58 | 5 | SO69501 | 2024-08-22 | 2.53 | 23.37 | 31.58 | |||
| SO69501_6 | 8A65-4926-A6 | PO6525182870 | 100 | 281 | 556 | 345 | 4 | 2024-08-27 | 105.29 | 2.63 | 2024-08-15 | 1 | 77.92 | 1 | 105.29 | 6 | SO69501 | 2024-08-22 | 8.42 | 77.92 | 105.29 | |||
| SO69501_7 | 8A65-4926-A6 | PO6525182870 | 100 | 281 | 309 | 345 | 4 | 2024-08-27 | 1637.40 | 40.94 | 2024-08-15 | 2 | 747.20 | 1 | 1637.40 | 7 | SO69501 | 2024-08-22 | 130.99 | 1494.40 | 818.70 | |||
| SO69501_8 | 8A65-4926-A6 | PO6525182870 | 100 | 281 | 555 | 345 | 4 | 2024-08-27 | 127.80 | 3.20 | 2024-08-15 | 2 | 47.29 | 1 | 127.80 | 8 | SO69501 | 2024-08-22 | 10.22 | 94.57 | 63.90 | |||
| SO69501_9 | 8A65-4926-A6 | PO6525182870 | 100 | 281 | 533 | 345 | 4 | 2024-08-27 | 149.87 | 3.75 | 2024-08-15 | 1 | 136.79 | 1 | 149.87 | 9 | SO69501 | 2024-08-22 | 11.99 | 136.79 | 149.87 | |||
| SO69501_10 | 8A65-4926-A6 | PO6525182870 | 100 | 281 | 475 | 345 | 4 | 2024-08-27 | 83.99 | 2.10 | 2024-08-15 | 2 | 26.18 | 1 | 83.99 | 10 | SO69501 | 2024-08-22 | 6.72 | 52.35 | 41.99 | |||
| SO69501_11 | 8A65-4926-A6 | PO6525182870 | 100 | 281 | 359 | 345 | 4 | 2024-08-27 | 5507.98 | 137.70 | 2024-08-15 | 4 | 1251.98 | 1 | 5507.98 | 11 | SO69501 | 2024-08-22 | 440.64 | 5007.93 | 1376.99 | |||
| SO69501_12 | 8A65-4926-A6 | PO6525182870 | 100 | 281 | 357 | 345 | 4 | 2024-08-27 | 2783.99 | 69.60 | 2024-08-15 | 2 | 1265.62 | 1 | 2783.99 | 12 | SO69501 | 2024-08-22 | 222.72 | 2531.24 | 1391.99 | |||
| SO69501_13 | 8A65-4926-A6 | PO6525182870 | 100 | 281 | 558 | 345 | 4 | 2024-08-27 | 728.98 | 18.22 | 2024-08-15 | 3 | 179.82 | 1 | 728.98 | 13 | SO69501 | 2024-08-22 | 58.32 | 539.45 | 242.99 | |||
| SO69501_14 | 8A65-4926-A6 | PO6525182870 | 100 | 281 | 361 | 345 | 4 | 2024-08-27 | 4130.98 | 103.27 | 2024-08-15 | 3 | 1251.98 | 1 | 4130.98 | 14 | SO69501 | 2024-08-22 | 330.48 | 3755.94 | 1376.99 | |||
| SO69501_15 | 8A65-4926-A6 | PO6525182870 | 100 | 281 | 474 | 345 | 4 | 2024-08-27 | 293.96 | 7.35 | 2024-08-15 | 7 | 26.18 | 1 | 293.96 | 15 | SO69501 | 2024-08-22 | 23.52 | 183.23 | 41.99 | |||
| SO69501_16 | 8A65-4926-A6 | PO6525182870 | 100 | 281 | 559 | 345 | 4 | 2024-08-27 | 36.43 | 0.91 | 2024-08-15 | 3 | 8.99 | 1 | 36.43 | 16 | SO69501 | 2024-08-22 | 2.91 | 26.96 | 12.14 | |||
| SO69501_17 | 8A65-4926-A6 | PO6525182870 | 100 | 281 | 552 | 345 | 4 | 2024-08-27 | 164.68 | 4.12 | 2024-08-15 | 3 | 40.62 | 1 | 164.68 | 17 | SO69501 | 2024-08-22 | 13.17 | 121.86 | 54.89 | |||
| SO69501_18 | 8A65-4926-A6 | PO6525182870 | 100 | 281 | 551 | 345 | 4 | 2024-08-27 | 158.43 | 3.96 | 2024-08-15 | 1 | 144.59 | 1 | 158.43 | 18 | SO69501 | 2024-08-22 | 12.67 | 144.59 | 158.43 | |||
| SO69501_19 | 8A65-4926-A6 | PO6525182870 | 100 | 281 | 525 | 345 | 4 | 2024-08-27 | 475.29 | 11.88 | 2024-08-15 | 3 | 144.59 | 1 | 475.29 | 19 | SO69501 | 2024-08-22 | 38.02 | 433.78 | 158.43 | |||
| SO69501_20 | 8A65-4926-A6 | PO6525182870 | 100 | 281 | 501 | 345 | 4 | 2024-08-27 | 364.38 | 9.11 | 2024-08-15 | 5 | 53.93 | 1 | 364.38 | 20 | SO69501 | 2024-08-22 | 29.15 | 269.64 | 72.88 | |||
| SO69501_21 | 8A65-4926-A6 | PO6525182870 | 100 | 281 | 594 | 16 | 345 | 4 | 45.20 | 2024-08-27 | 113.00 | 1.70 | 2024-08-15 | 1 | 308.22 | 1 | 67.80 | 21 | SO69501 | 2024-08-22 | 5.42 | 308.22 | 113.00 | 0.40 |
| SO69501_22 | 8A65-4926-A6 | PO6525182870 | 100 | 281 | 353 | 345 | 4 | 2024-08-27 | 8351.96 | 208.80 | 2024-08-15 | 6 | 1265.62 | 1 | 8351.96 | 22 | SO69501 | 2024-08-22 | 668.16 | 7593.72 | 1391.99 | |||
| SO69501_23 | 8A65-4926-A6 | PO6525182870 | 100 | 281 | 512 | 345 | 4 | 2024-08-27 | 655.36 | 16.38 | 2024-08-15 | 3 | 199.38 | 1 | 655.36 | 23 | SO69501 | 2024-08-22 | 52.43 | 598.13 | 218.45 | |||
| SO69501_24 | 8A65-4926-A6 | PO6525182870 | 100 | 281 | 595 | 16 | 345 | 4 | 45.20 | 2024-08-27 | 113.00 | 1.70 | 2024-08-15 | 1 | 308.22 | 1 | 67.80 | 24 | SO69501 | 2024-08-22 | 5.42 | 308.22 | 113.00 | 0.40 |
| SO69501_25 | 8A65-4926-A6 | PO6525182870 | 100 | 281 | 398 | 345 | 4 | 2024-08-27 | 80.17 | 2.00 | 2024-08-15 | 3 | 19.78 | 1 | 80.17 | 25 | SO69501 | 2024-08-22 | 6.41 | 59.33 | 26.72 | |||
| SO69501_26 | 8A65-4926-A6 | PO6525182870 | 100 | 281 | 476 | 345 | 4 | 2024-08-27 | 125.98 | 3.15 | 2024-08-15 | 3 | 26.18 | 1 | 125.98 | 26 | SO69501 | 2024-08-22 | 10.08 | 78.53 | 41.99 | |||
| SO69501_27 | 8A65-4926-A6 | PO6525182870 | 100 | 281 | 306 | 345 | 4 | 2024-08-27 | 809.76 | 20.24 | 2024-08-15 | 1 | 739.04 | 1 | 809.76 | 27 | SO69501 | 2024-08-22 | 64.78 | 739.04 | 809.76 | |||
| SO69501_28 | 8A65-4926-A6 | PO6525182870 | 100 | 281 | 601 | 345 | 4 | 2024-08-27 | 97.18 | 2.43 | 2024-08-15 | 3 | 23.97 | 1 | 97.18 | 28 | SO69501 | 2024-08-22 | 7.77 | 71.91 | 32.39 |
Generated 2024-11-14 08:04:51.669 UTC