[ROOT] dt FactResellerSale < WHERE DimSalesTerritoryId EQ '6' > < SKIP 5736 > < 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 |
---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
SO65189_2 | 985E-4937-94 | PO14761195376 | 19 | 284 | 231 | 408 | 6 | 2024-05-04 | 179.96 | 4.50 | 2024-04-22 | 6 | 38.49 | 1 | 179.96 | 2 | SO65189 | 2024-04-29 | 14.40 | 230.95 | 29.99 | |||
SO65189_3 | 985E-4937-94 | PO14761195376 | 19 | 284 | 492 | 408 | 6 | 2024-05-04 | 602.35 | 15.06 | 2024-04-22 | 1 | 601.74 | 1 | 602.35 | 3 | SO65189 | 2024-04-29 | 48.19 | 601.74 | 602.35 | |||
SO65189_4 | 985E-4937-94 | PO14761195376 | 19 | 284 | 477 | 408 | 6 | 2024-05-04 | 23.95 | 0.60 | 2024-04-22 | 8 | 1.87 | 1 | 23.95 | 4 | SO65189 | 2024-04-29 | 1.92 | 14.93 | 2.99 | |||
SO65189_5 | 985E-4937-94 | PO14761195376 | 19 | 284 | 484 | 408 | 6 | 2024-05-04 | 42.93 | 1.07 | 2024-04-22 | 9 | 2.97 | 1 | 42.93 | 5 | SO65189 | 2024-04-29 | 3.43 | 26.76 | 4.77 | |||
SO65189_6 | 985E-4937-94 | PO14761195376 | 19 | 284 | 565 | 408 | 6 | 2024-05-04 | 1336.23 | 33.41 | 2024-04-22 | 3 | 461.44 | 1 | 1336.23 | 6 | SO65189 | 2024-04-29 | 106.90 | 1384.33 | 445.41 | |||
SO65189_7 | 985E-4937-94 | PO14761195376 | 19 | 284 | 490 | 408 | 6 | 2024-05-04 | 129.58 | 3.24 | 2024-04-22 | 4 | 41.57 | 1 | 129.58 | 7 | SO65189 | 2024-04-29 | 10.37 | 166.29 | 32.39 | |||
SO65189_8 | 985E-4937-94 | PO14761195376 | 19 | 284 | 471 | 2 | 408 | 6 | 10.31 | 2024-05-04 | 515.62 | 12.63 | 2024-04-22 | 14 | 23.75 | 1 | 505.31 | 8 | SO65189 | 2024-04-29 | 40.42 | 332.49 | 36.83 | 0.02 |
SO65189_9 | 985E-4937-94 | PO14761195376 | 19 | 284 | 463 | 408 | 6 | 2024-05-04 | 44.08 | 1.10 | 2024-04-22 | 3 | 9.16 | 1 | 44.08 | 9 | SO65189 | 2024-04-29 | 3.53 | 27.48 | 14.69 | |||
SO65189_10 | 985E-4937-94 | PO14761195376 | 19 | 284 | 225 | 408 | 6 | 2024-05-04 | 37.76 | 0.94 | 2024-04-22 | 7 | 6.92 | 1 | 37.76 | 10 | SO65189 | 2024-04-29 | 3.02 | 48.46 | 5.39 | |||
SO65189_11 | 985E-4937-94 | PO14761195376 | 19 | 284 | 483 | 408 | 6 | 2024-05-04 | 504.00 | 12.60 | 2024-04-22 | 7 | 44.88 | 1 | 504.00 | 11 | SO65189 | 2024-04-29 | 40.32 | 314.16 | 72.00 | |||
SO65189_12 | 985E-4937-94 | PO14761195376 | 19 | 284 | 502 | 408 | 6 | 2024-05-04 | 200.05 | 5.00 | 2024-04-22 | 1 | 199.85 | 1 | 200.05 | 12 | SO65189 | 2024-04-29 | 16.00 | 199.85 | 200.05 | |||
SO65189_13 | 985E-4937-94 | PO14761195376 | 19 | 284 | 573 | 408 | 6 | 2024-05-04 | 8582.65 | 214.57 | 2024-04-22 | 6 | 1481.94 | 1 | 8582.65 | 13 | SO65189 | 2024-04-29 | 686.61 | 8891.63 | 1430.44 | |||
SO65189_14 | 985E-4937-94 | PO14761195376 | 19 | 284 | 574 | 408 | 6 | 2024-05-04 | 2860.88 | 71.52 | 2024-04-22 | 2 | 1481.94 | 1 | 2860.88 | 14 | SO65189 | 2024-04-29 | 228.87 | 2963.88 | 1430.44 | |||
SO65189_15 | 985E-4937-94 | PO14761195376 | 19 | 284 | 564 | 408 | 6 | 2024-05-04 | 2860.88 | 71.52 | 2024-04-22 | 2 | 1481.94 | 1 | 2860.88 | 15 | SO65189 | 2024-04-29 | 228.87 | 2963.88 | 1430.44 | |||
SO65189_16 | 985E-4937-94 | PO14761195376 | 19 | 284 | 568 | 408 | 6 | 2024-05-04 | 1336.23 | 33.41 | 2024-04-22 | 3 | 461.44 | 1 | 1336.23 | 16 | SO65189 | 2024-04-29 | 106.90 | 1384.33 | 445.41 | |||
SO65189_17 | 985E-4937-94 | PO14761195376 | 19 | 284 | 500 | 408 | 6 | 2024-05-04 | 1807.04 | 45.18 | 2024-04-22 | 3 | 601.74 | 1 | 1807.04 | 17 | SO65189 | 2024-04-29 | 144.56 | 1805.23 | 602.35 | |||
SO65189_18 | 985E-4937-94 | PO14761195376 | 19 | 284 | 572 | 408 | 6 | 2024-05-04 | 1336.23 | 33.41 | 2024-04-22 | 3 | 461.44 | 1 | 1336.23 | 18 | SO65189 | 2024-04-29 | 106.90 | 1384.33 | 445.41 | |||
SO65189_19 | 985E-4937-94 | PO14761195376 | 19 | 284 | 560 | 408 | 6 | 2024-05-04 | 2186.73 | 54.67 | 2024-04-22 | 3 | 755.15 | 1 | 2186.73 | 19 | SO65189 | 2024-04-29 | 174.94 | 2265.45 | 728.91 | |||
SO65189_20 | 985E-4937-94 | PO14761195376 | 19 | 284 | 561 | 408 | 6 | 2024-05-04 | 2860.88 | 71.52 | 2024-04-22 | 2 | 1481.94 | 1 | 2860.88 | 20 | SO65189 | 2024-04-29 | 228.87 | 2963.88 | 1430.44 | |||
SO65189_21 | 985E-4937-94 | PO14761195376 | 19 | 284 | 222 | 408 | 6 | 2024-05-04 | 83.98 | 2.10 | 2024-04-22 | 4 | 13.09 | 1 | 83.98 | 21 | SO65189 | 2024-04-29 | 6.72 | 52.35 | 20.99 | |||
SO65189_22 | 985E-4937-94 | PO14761195376 | 19 | 284 | 234 | 408 | 6 | 2024-05-04 | 239.95 | 6.00 | 2024-04-22 | 8 | 38.49 | 1 | 239.95 | 22 | SO65189 | 2024-04-29 | 19.20 | 307.94 | 29.99 | |||
SO65189_23 | 985E-4937-94 | PO14761195376 | 19 | 284 | 487 | 408 | 6 | 2024-05-04 | 131.98 | 3.30 | 2024-04-22 | 4 | 20.57 | 1 | 131.98 | 23 | SO65189 | 2024-04-29 | 10.56 | 82.27 | 32.99 | |||
SO65189_24 | 985E-4937-94 | PO14761195376 | 19 | 284 | 569 | 408 | 6 | 2024-05-04 | 445.41 | 11.14 | 2024-04-22 | 1 | 461.44 | 1 | 445.41 | 24 | SO65189 | 2024-04-29 | 35.63 | 461.44 | 445.41 | |||
SO65189_25 | 985E-4937-94 | PO14761195376 | 19 | 284 | 491 | 408 | 6 | 2024-05-04 | 161.97 | 4.05 | 2024-04-22 | 5 | 41.57 | 1 | 161.97 | 25 | SO65189 | 2024-04-29 | 12.96 | 207.86 | 32.39 | |||
SO46352_4 | A467-4700-9C | PO10585133264 | 19 | 284 | 346 | 7 | 498 | 6 | 297.50 | 2022-08-04 | 850.00 | 13.81 | 2022-07-23 | 1 | 1912.15 | 1 | 552.50 | 4 | SO46352 | 2022-07-30 | 44.20 | 1912.15 | 850.00 | 0.35 |
SO46359_1 | 95FD-4612-88 | PO1740167502 | 19 | 288 | 262 | 460 | 6 | 2022-08-04 | 183.94 | 4.60 | 2022-07-23 | 1 | 181.49 | 1 | 183.94 | 1 | SO46359 | 2022-07-30 | 14.72 | 181.49 | 183.94 | |||
SO46359_2 | 95FD-4612-88 | PO1740167502 | 19 | 288 | 232 | 460 | 6 | 2022-08-04 | 173.04 | 4.33 | 2022-07-23 | 6 | 31.72 | 1 | 173.04 | 2 | SO46359 | 2022-07-30 | 13.84 | 190.35 | 28.84 | |||
SO46359_3 | 95FD-4612-88 | PO1740167502 | 19 | 288 | 330 | 460 | 6 | 2022-08-04 | 838.92 | 20.97 | 2022-07-23 | 2 | 413.15 | 1 | 838.92 | 3 | SO46359 | 2022-07-30 | 67.11 | 826.29 | 419.46 | |||
SO46359_4 | 95FD-4612-88 | PO1740167502 | 19 | 288 | 272 | 460 | 6 | 2022-08-04 | 183.94 | 4.60 | 2022-07-23 | 1 | 181.49 | 1 | 183.94 | 4 | SO46359 | 2022-07-30 | 14.72 | 181.49 | 183.94 | |||
SO46359_5 | 95FD-4612-88 | PO1740167502 | 19 | 288 | 328 | 460 | 6 | 2022-08-04 | 1677.84 | 41.95 | 2022-07-23 | 4 | 413.15 | 1 | 1677.84 | 5 | SO46359 | 2022-07-30 | 134.23 | 1652.59 | 419.46 | |||
SO46359_6 | 95FD-4612-88 | PO1740167502 | 19 | 288 | 285 | 460 | 6 | 2022-08-04 | 357.16 | 8.93 | 2022-07-23 | 2 | 176.20 | 1 | 357.16 | 6 | SO46359 | 2022-07-30 | 28.57 | 352.40 | 178.58 | |||
SO46359_7 | 95FD-4612-88 | PO1740167502 | 19 | 288 | 223 | 460 | 6 | 2022-08-04 | 10.37 | 0.26 | 2022-07-23 | 2 | 5.71 | 1 | 10.37 | 7 | SO46359 | 2022-07-30 | 0.83 | 11.41 | 5.19 | |||
SO46359_8 | 95FD-4612-88 | PO1740167502 | 19 | 288 | 229 | 460 | 6 | 2022-08-04 | 115.36 | 2.88 | 2022-07-23 | 4 | 31.72 | 1 | 115.36 | 8 | SO46359 | 2022-07-30 | 9.23 | 126.90 | 28.84 | |||
SO46359_9 | 95FD-4612-88 | PO1740167502 | 19 | 288 | 253 | 460 | 6 | 2022-08-04 | 178.58 | 4.46 | 2022-07-23 | 1 | 176.20 | 1 | 178.58 | 9 | SO46359 | 2022-07-30 | 14.29 | 176.20 | 178.58 | |||
SO46359_10 | 95FD-4612-88 | PO1740167502 | 19 | 288 | 342 | 460 | 6 | 2022-08-04 | 838.92 | 20.97 | 2022-07-23 | 2 | 413.15 | 1 | 838.92 | 10 | SO46359 | 2022-07-30 | 67.11 | 826.29 | 419.46 | |||
SO46359_11 | 95FD-4612-88 | PO1740167502 | 19 | 288 | 215 | 460 | 6 | 2022-08-04 | 60.56 | 1.51 | 2022-07-23 | 3 | 12.03 | 1 | 60.56 | 11 | SO46359 | 2022-07-30 | 4.84 | 36.08 | 20.19 | |||
SO46359_12 | 95FD-4612-88 | PO1740167502 | 19 | 288 | 324 | 460 | 6 | 2022-08-04 | 838.92 | 20.97 | 2022-07-23 | 2 | 413.15 | 1 | 838.92 | 12 | SO46359 | 2022-07-30 | 67.11 | 826.29 | 419.46 | |||
SO46359_13 | 95FD-4612-88 | PO1740167502 | 19 | 288 | 310 | 460 | 6 | 2022-08-04 | 2146.96 | 53.67 | 2022-07-23 | 1 | 2171.29 | 1 | 2146.96 | 13 | SO46359 | 2022-07-30 | 171.76 | 2171.29 | 2146.96 | |||
SO46359_14 | 95FD-4612-88 | PO1740167502 | 19 | 288 | 275 | 460 | 6 | 2022-08-04 | 1070.69 | 26.77 | 2022-07-23 | 3 | 352.14 | 1 | 1070.69 | 14 | SO46359 | 2022-07-30 | 85.66 | 1056.42 | 356.90 | |||
SO46359_15 | 95FD-4612-88 | PO1740167502 | 19 | 288 | 235 | 460 | 6 | 2022-08-04 | 86.52 | 2.16 | 2022-07-23 | 3 | 31.72 | 1 | 86.52 | 15 | SO46359 | 2022-07-30 | 6.92 | 95.17 | 28.84 | |||
SO46359_16 | 95FD-4612-88 | PO1740167502 | 19 | 288 | 276 | 460 | 6 | 2022-08-04 | 356.90 | 8.92 | 2022-07-23 | 1 | 352.14 | 1 | 356.90 | 16 | SO46359 | 2022-07-30 | 28.55 | 352.14 | 356.90 | |||
SO46359_17 | 95FD-4612-88 | PO1740167502 | 19 | 288 | 314 | 460 | 6 | 2022-08-04 | 4293.92 | 107.35 | 2022-07-23 | 2 | 2171.29 | 1 | 4293.92 | 17 | SO46359 | 2022-07-30 | 343.51 | 4342.59 | 2146.96 | |||
SO46359_18 | 95FD-4612-88 | PO1740167502 | 19 | 288 | 220 | 460 | 6 | 2022-08-04 | 141.31 | 3.53 | 2022-07-23 | 7 | 12.03 | 1 | 141.31 | 18 | SO46359 | 2022-07-30 | 11.30 | 84.19 | 20.19 | |||
SO46359_19 | 95FD-4612-88 | PO1740167502 | 19 | 288 | 317 | 460 | 6 | 2022-08-04 | 5248.76 | 131.22 | 2022-07-23 | 6 | 884.71 | 1 | 5248.76 | 19 | SO46359 | 2022-07-30 | 419.90 | 5308.25 | 874.79 | |||
SO46360_1 | 00EC-47DF-BB | PO1885143134 | 19 | 284 | 348 | 7 | 588 | 6 | 885.93 | 2022-08-04 | 2531.24 | 41.13 | 2022-07-23 | 3 | 1898.09 | 1 | 1645.31 | 1 | SO46360 | 2022-07-30 | 131.62 | 5694.28 | 843.75 | 0.35 |
SO46360_2 | 00EC-47DF-BB | PO1885143134 | 19 | 284 | 218 | 588 | 6 | 2022-08-04 | 34.20 | 0.86 | 2022-07-23 | 6 | 3.40 | 1 | 34.20 | 2 | SO46360 | 2022-07-30 | 2.74 | 20.38 | 5.70 | |||
SO46360_3 | 00EC-47DF-BB | PO1885143134 | 19 | 284 | 223 | 588 | 6 | 2022-08-04 | 10.37 | 0.26 | 2022-07-23 | 2 | 5.71 | 1 | 10.37 | 3 | SO46360 | 2022-07-30 | 0.83 | 11.41 | 5.19 | |||
SO46360_4 | 00EC-47DF-BB | PO1885143134 | 19 | 284 | 212 | 588 | 6 | 2022-08-04 | 40.37 | 1.01 | 2022-07-23 | 2 | 12.03 | 1 | 40.37 | 4 | SO46360 | 2022-07-30 | 3.23 | 24.06 | 20.19 | |||
SO46360_5 | 00EC-47DF-BB | PO1885143134 | 19 | 284 | 350 | 7 | 588 | 6 | 590.62 | 2022-08-04 | 1687.50 | 27.42 | 2022-07-23 | 2 | 1898.09 | 1 | 1096.87 | 5 | SO46360 | 2022-07-30 | 87.75 | 3796.19 | 843.75 | 0.35 |
SO46360_6 | 00EC-47DF-BB | PO1885143134 | 19 | 284 | 232 | 588 | 6 | 2022-08-04 | 28.84 | 0.72 | 2022-07-23 | 1 | 31.72 | 1 | 28.84 | 6 | SO46360 | 2022-07-30 | 2.31 | 31.72 | 28.84 | |||
SO46360_7 | 00EC-47DF-BB | PO1885143134 | 19 | 284 | 345 | 7 | 588 | 6 | 595.00 | 2022-08-04 | 1700.00 | 27.62 | 2022-07-23 | 2 | 1912.15 | 1 | 1105.00 | 7 | SO46360 | 2022-07-30 | 88.40 | 3824.31 | 850.00 | 0.35 |
SO46360_8 | 00EC-47DF-BB | PO1885143134 | 19 | 284 | 349 | 7 | 588 | 6 | 590.62 | 2022-08-04 | 1687.50 | 27.42 | 2022-07-23 | 2 | 1898.09 | 1 | 1096.87 | 8 | SO46360 | 2022-07-30 | 87.75 | 3796.19 | 843.75 | 0.35 |
SO46360_9 | 00EC-47DF-BB | PO1885143134 | 19 | 284 | 215 | 588 | 6 | 2022-08-04 | 60.56 | 1.51 | 2022-07-23 | 3 | 12.03 | 1 | 60.56 | 9 | SO46360 | 2022-07-30 | 4.84 | 36.08 | 20.19 | |||
SO46360_10 | 00EC-47DF-BB | PO1885143134 | 19 | 284 | 344 | 7 | 588 | 6 | 595.00 | 2022-08-04 | 1700.00 | 27.62 | 2022-07-23 | 2 | 1912.15 | 1 | 1105.00 | 10 | SO46360 | 2022-07-30 | 88.40 | 3824.31 | 850.00 | 0.35 |
SO46607_1 | C1B5-40D6-8D | PO18444137892 | 19 | 291 | 369 | 227 | 6 | 2022-09-03 | 5864.04 | 146.60 | 2022-08-22 | 4 | 1518.79 | 1 | 5864.04 | 1 | SO46607 | 2022-08-29 | 469.12 | 6075.15 | 1466.01 | |||
SO46607_2 | C1B5-40D6-8D | PO18444137892 | 19 | 291 | 335 | 227 | 6 | 2022-09-03 | 2348.97 | 58.72 | 2022-08-22 | 5 | 486.71 | 1 | 2348.97 | 2 | SO46607 | 2022-08-29 | 187.92 | 2433.53 | 469.79 |
Generated 2024-09-21 17:34:44.947 UTC