[ROOT] dt FactResellerSale < WHERE DimSalesTerritoryId EQ '5' > < SKIP 2438 > < TAKE 31 >
31 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 |
---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
SO46090_12 | 987E-4B5B-B6 | PO5858172038 | 100 | 285 | 346 | 566 | 5 | 2022-07-02 | 10199.97 | 255.00 | 2022-06-20 | 5 | 1912.15 | 1 | 10199.97 | 12 | SO46090 | 2022-06-27 | 816.00 | 9560.77 | 2039.99 | |||
SO49091_12 | 7A94-486D-8A | PO19546118667 | 100 | 285 | 339 | 206 | 5 | 2023-04-04 | 939.59 | 23.49 | 2023-03-23 | 2 | 486.71 | 1 | 939.59 | 12 | SO49091 | 2023-03-30 | 75.17 | 973.41 | 469.79 | |||
SO51824_9 | A1F7-477E-BA | PO5800114202 | 100 | 285 | 359 | 2 | 63 | 5 | 292.84 | 2023-10-02 | 14642.04 | 358.73 | 2023-09-20 | 11 | 1251.98 | 1 | 14349.20 | 9 | SO51824 | 2023-09-27 | 1147.94 | 13771.79 | 1331.09 | 0.02 |
SO46090_13 | 987E-4B5B-B6 | PO5858172038 | 100 | 285 | 348 | 2 | 566 | 5 | 469.80 | 2022-07-02 | 23489.93 | 575.50 | 2022-06-20 | 12 | 1898.09 | 1 | 23020.13 | 13 | SO46090 | 2022-06-27 | 1841.61 | 22777.13 | 1957.49 | 0.02 |
SO49091_13 | 7A94-486D-8A | PO19546118667 | 100 | 285 | 389 | 206 | 5 | 2023-04-04 | 3001.31 | 75.03 | 2023-03-23 | 5 | 605.65 | 1 | 3001.31 | 13 | SO49091 | 2023-03-30 | 240.11 | 3028.25 | 600.26 | |||
SO51824_10 | A1F7-477E-BA | PO5800114202 | 100 | 285 | 516 | 63 | 5 | 2023-10-02 | 46.97 | 1.17 | 2023-09-20 | 2 | 17.38 | 1 | 46.97 | 10 | SO51824 | 2023-09-27 | 3.76 | 34.76 | 23.48 | |||
SO46090_14 | 987E-4B5B-B6 | PO5858172038 | 100 | 285 | 232 | 566 | 5 | 2022-07-02 | 173.04 | 4.33 | 2022-06-20 | 6 | 31.72 | 1 | 173.04 | 14 | SO46090 | 2022-06-27 | 13.84 | 190.35 | 28.84 | |||
SO49091_14 | 7A94-486D-8A | PO19546118667 | 100 | 285 | 381 | 206 | 5 | 2023-04-04 | 1200.53 | 30.01 | 2023-03-23 | 2 | 605.65 | 1 | 1200.53 | 14 | SO49091 | 2023-03-30 | 96.04 | 1211.30 | 600.26 | |||
SO51824_11 | A1F7-477E-BA | PO5800114202 | 100 | 285 | 595 | 63 | 5 | 2023-10-02 | 1694.97 | 42.37 | 2023-09-20 | 5 | 308.22 | 1 | 1694.97 | 11 | SO51824 | 2023-09-27 | 135.60 | 1541.09 | 338.99 | |||
SO46090_15 | 987E-4B5B-B6 | PO5858172038 | 100 | 285 | 215 | 566 | 5 | 2022-07-02 | 40.37 | 1.01 | 2022-06-20 | 2 | 12.03 | 1 | 40.37 | 15 | SO46090 | 2022-06-27 | 3.23 | 24.06 | 20.19 | |||
SO49091_15 | 7A94-486D-8A | PO19546118667 | 100 | 285 | 375 | 206 | 5 | 2023-04-04 | 3926.81 | 98.17 | 2023-03-23 | 3 | 1320.68 | 1 | 3926.81 | 15 | SO49091 | 2023-03-30 | 314.15 | 3962.05 | 1308.94 | |||
SO51824_12 | A1F7-477E-BA | PO5800114202 | 100 | 285 | 599 | 63 | 5 | 2023-10-02 | 323.99 | 8.10 | 2023-09-20 | 1 | 294.58 | 1 | 323.99 | 12 | SO51824 | 2023-09-27 | 25.92 | 294.58 | 323.99 | |||
SO46090_16 | 987E-4B5B-B6 | PO5858172038 | 100 | 285 | 307 | 566 | 5 | 2022-07-02 | 1445.19 | 36.13 | 2022-06-20 | 2 | 623.84 | 1 | 1445.19 | 16 | SO46090 | 2022-06-27 | 115.62 | 1247.68 | 722.59 | |||
SO49091_16 | 7A94-486D-8A | PO19546118667 | 100 | 285 | 383 | 206 | 5 | 2023-04-04 | 600.26 | 15.01 | 2023-03-23 | 1 | 605.65 | 1 | 600.26 | 16 | SO49091 | 2023-03-30 | 48.02 | 605.65 | 600.26 | |||
SO51824_13 | A1F7-477E-BA | PO5800114202 | 100 | 285 | 533 | 63 | 5 | 2023-10-02 | 149.87 | 3.75 | 2023-09-20 | 1 | 136.79 | 1 | 149.87 | 13 | SO51824 | 2023-09-27 | 11.99 | 136.79 | 149.87 | |||
SO46090_17 | 987E-4B5B-B6 | PO5858172038 | 100 | 285 | 235 | 566 | 5 | 2022-07-02 | 28.84 | 0.72 | 2022-06-20 | 1 | 31.72 | 1 | 28.84 | 17 | SO46090 | 2022-06-27 | 2.31 | 31.72 | 28.84 | |||
SO49091_17 | 7A94-486D-8A | PO19546118667 | 100 | 285 | 333 | 206 | 5 | 2023-04-04 | 2348.97 | 58.72 | 2023-03-23 | 5 | 486.71 | 1 | 2348.97 | 17 | SO49091 | 2023-03-30 | 187.92 | 2433.53 | 469.79 | |||
SO51824_14 | A1F7-477E-BA | PO5800114202 | 100 | 285 | 526 | 63 | 5 | 2023-10-02 | 475.29 | 11.88 | 2023-09-20 | 3 | 144.59 | 1 | 475.29 | 14 | SO51824 | 2023-09-27 | 38.02 | 433.78 | 158.43 | |||
SO46090_18 | 987E-4B5B-B6 | PO5858172038 | 100 | 285 | 350 | 566 | 5 | 2022-07-02 | 12149.96 | 303.75 | 2022-06-20 | 6 | 1898.09 | 1 | 12149.96 | 18 | SO46090 | 2022-06-27 | 972.00 | 11388.57 | 2024.99 | |||
SO49091_18 | 7A94-486D-8A | PO19546118667 | 100 | 285 | 331 | 206 | 5 | 2023-04-04 | 2348.97 | 58.72 | 2023-03-23 | 5 | 486.71 | 1 | 2348.97 | 18 | SO49091 | 2023-03-30 | 187.92 | 2433.53 | 469.79 | |||
SO51824_15 | A1F7-477E-BA | PO5800114202 | 100 | 285 | 531 | 63 | 5 | 2023-10-02 | 1049.12 | 26.23 | 2023-09-20 | 7 | 136.79 | 1 | 1049.12 | 15 | SO51824 | 2023-09-27 | 83.93 | 957.50 | 149.87 | |||
SO46090_19 | 987E-4B5B-B6 | PO5858172038 | 100 | 285 | 300 | 566 | 5 | 2022-07-02 | 1619.52 | 40.49 | 2022-06-20 | 2 | 699.09 | 1 | 1619.52 | 19 | SO46090 | 2022-06-27 | 129.56 | 1398.19 | 809.76 | |||
SO49091_19 | 7A94-486D-8A | PO19546118667 | 100 | 285 | 327 | 206 | 5 | 2023-04-04 | 939.59 | 23.49 | 2023-03-23 | 2 | 486.71 | 1 | 939.59 | 19 | SO49091 | 2023-03-30 | 75.17 | 973.41 | 469.79 | |||
SO51824_16 | A1F7-477E-BA | PO5800114202 | 100 | 285 | 363 | 63 | 5 | 2023-10-02 | 4130.98 | 103.27 | 2023-09-20 | 3 | 1251.98 | 1 | 4130.98 | 16 | SO51824 | 2023-09-27 | 330.48 | 3755.94 | 1376.99 | |||
SO46090_20 | 987E-4B5B-B6 | PO5858172038 | 100 | 285 | 296 | 566 | 5 | 2022-07-02 | 1429.41 | 35.74 | 2022-06-20 | 2 | 617.03 | 1 | 1429.41 | 20 | SO46090 | 2022-06-27 | 114.35 | 1234.06 | 714.70 | |||
SO49091_20 | 7A94-486D-8A | PO19546118667 | 100 | 285 | 329 | 206 | 5 | 2023-04-04 | 1409.38 | 35.23 | 2023-03-23 | 3 | 486.71 | 1 | 1409.38 | 20 | SO49091 | 2023-03-30 | 112.75 | 1460.12 | 469.79 | |||
SO51824_17 | A1F7-477E-BA | PO5800114202 | 100 | 285 | 556 | 63 | 5 | 2023-10-02 | 210.59 | 5.26 | 2023-09-20 | 2 | 77.92 | 1 | 210.59 | 17 | SO51824 | 2023-09-27 | 16.85 | 155.84 | 105.29 | |||
SO46090_21 | 987E-4B5B-B6 | PO5858172038 | 100 | 285 | 223 | 566 | 5 | 2022-07-02 | 10.37 | 0.26 | 2022-06-20 | 2 | 5.71 | 1 | 10.37 | 21 | SO46090 | 2022-06-27 | 0.83 | 11.41 | 5.19 | |||
SO49091_21 | 7A94-486D-8A | PO19546118667 | 100 | 285 | 422 | 206 | 5 | 2023-04-04 | 270.16 | 6.75 | 2023-03-23 | 4 | 49.98 | 1 | 270.16 | 21 | SO49091 | 2023-03-30 | 21.61 | 199.92 | 67.54 | |||
SO51824_18 | A1F7-477E-BA | PO5800114202 | 100 | 285 | 298 | 63 | 5 | 2023-10-02 | 809.76 | 20.24 | 2023-09-20 | 1 | 739.04 | 1 | 809.76 | 18 | SO51824 | 2023-09-27 | 64.78 | 739.04 | 809.76 | |||
SO46090_22 | 987E-4B5B-B6 | PO5858172038 | 100 | 285 | 349 | 566 | 5 | 2022-07-02 | 4049.99 | 101.25 | 2022-06-20 | 2 | 1898.09 | 1 | 4049.99 | 22 | SO46090 | 2022-06-27 | 324.00 | 3796.19 | 2024.99 |
Generated 2024-09-19 20:04:45.196 UTC