[ROOT] dt FactResellerSale < WHERE DimSalesTerritoryId EQ '5' > < SKIP 2097 > < TAKE 28 >
28 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 |
---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
SO53524_31 | 2B2B-440F-8B | PO1537151724 | 100 | 285 | 495 | 611 | 5 | 2023-12-27 | 1807.04 | 45.18 | 2023-12-15 | 3 | 601.74 | 1 | 1807.04 | 31 | SO53524 | 2023-12-22 | 144.56 | 1805.23 | 602.35 | |||
SO53524_32 | 2B2B-440F-8B | PO1537151724 | 100 | 285 | 579 | 611 | 5 | 2023-12-27 | 5102.37 | 127.56 | 2023-12-15 | 7 | 755.15 | 1 | 5102.37 | 32 | SO53524 | 2023-12-22 | 408.19 | 5286.06 | 728.91 | |||
SO53524_33 | 2B2B-440F-8B | PO1537151724 | 100 | 285 | 506 | 611 | 5 | 2023-12-27 | 400.10 | 10.00 | 2023-12-15 | 2 | 199.85 | 1 | 400.10 | 33 | SO53524 | 2023-12-22 | 32.01 | 399.70 | 200.05 | |||
SO53524_34 | 2B2B-440F-8B | PO1537151724 | 100 | 285 | 499 | 611 | 5 | 2023-12-27 | 1807.04 | 45.18 | 2023-12-15 | 3 | 601.74 | 1 | 1807.04 | 34 | SO53524 | 2023-12-22 | 144.56 | 1805.23 | 602.35 | |||
SO53524_35 | 2B2B-440F-8B | PO1537151724 | 100 | 285 | 562 | 14 | 611 | 5 | 381.45 | 2023-12-27 | 1907.26 | 38.15 | 2023-12-15 | 2 | 1481.94 | 1 | 1525.80 | 35 | SO53524 | 2023-12-22 | 122.06 | 2963.88 | 953.63 | 0.20 |
SO53524_36 | 2B2B-440F-8B | PO1537151724 | 100 | 285 | 572 | 13 | 611 | 5 | 350.76 | 2023-12-27 | 2338.40 | 49.69 | 2023-12-15 | 7 | 461.44 | 1 | 1987.64 | 36 | SO53524 | 2023-12-22 | 159.01 | 3230.11 | 334.06 | 0.15 |
SO53524_37 | 2B2B-440F-8B | PO1537151724 | 100 | 285 | 480 | 611 | 5 | 2023-12-27 | 10.99 | 0.27 | 2023-12-15 | 8 | 0.86 | 1 | 10.99 | 37 | SO53524 | 2023-12-22 | 0.88 | 6.85 | 1.37 | |||
SO53524_38 | 2B2B-440F-8B | PO1537151724 | 100 | 285 | 577 | 611 | 5 | 2023-12-27 | 2915.64 | 72.89 | 2023-12-15 | 4 | 755.15 | 1 | 2915.64 | 38 | SO53524 | 2023-12-22 | 233.25 | 3020.60 | 728.91 | |||
SO53524_39 | 2B2B-440F-8B | PO1537151724 | 100 | 285 | 463 | 611 | 5 | 2023-12-27 | 117.55 | 2.94 | 2023-12-15 | 8 | 9.16 | 1 | 117.55 | 39 | SO53524 | 2023-12-22 | 9.40 | 73.27 | 14.69 | |||
SO53524_40 | 2B2B-440F-8B | PO1537151724 | 100 | 285 | 217 | 2 | 611 | 5 | 4.87 | 2023-12-27 | 243.53 | 5.97 | 2023-12-15 | 12 | 13.09 | 1 | 238.66 | 40 | SO53524 | 2023-12-22 | 19.09 | 157.04 | 20.29 | 0.02 |
SO53524_41 | 2B2B-440F-8B | PO1537151724 | 100 | 285 | 493 | 611 | 5 | 2023-12-27 | 400.10 | 10.00 | 2023-12-15 | 2 | 199.85 | 1 | 400.10 | 41 | SO53524 | 2023-12-22 | 32.01 | 399.70 | 200.05 | |||
SO53524_42 | 2B2B-440F-8B | PO1537151724 | 100 | 285 | 522 | 611 | 5 | 2023-12-27 | 93.94 | 2.35 | 2023-12-15 | 4 | 17.38 | 1 | 93.94 | 42 | SO53524 | 2023-12-22 | 7.51 | 69.51 | 23.48 | |||
SO53524_43 | 2B2B-440F-8B | PO1537151724 | 100 | 285 | 497 | 611 | 5 | 2023-12-27 | 602.35 | 15.06 | 2023-12-15 | 1 | 601.74 | 1 | 602.35 | 43 | SO53524 | 2023-12-22 | 48.19 | 601.74 | 602.35 | |||
SO53524_44 | 2B2B-440F-8B | PO1537151724 | 100 | 285 | 472 | 611 | 5 | 2023-12-27 | 152.40 | 3.81 | 2023-12-15 | 4 | 23.75 | 1 | 152.40 | 44 | SO53524 | 2023-12-22 | 12.19 | 95.00 | 38.10 | |||
SO53524_45 | 2B2B-440F-8B | PO1537151724 | 100 | 285 | 585 | 13 | 611 | 5 | 50.11 | 2023-12-27 | 334.06 | 7.10 | 2023-12-15 | 1 | 461.44 | 1 | 283.95 | 45 | SO53524 | 2023-12-22 | 22.72 | 461.44 | 334.06 | 0.15 |
SO48020_2 | 3995-4B91-82 | PO11542110776 | 100 | 285 | 323 | 62 | 5 | 2023-02-26 | 939.59 | 23.49 | 2023-02-14 | 2 | 486.71 | 1 | 939.59 | 2 | SO48020 | 2023-02-21 | 75.17 | 973.41 | 469.79 | |||
SO48020_3 | 3995-4B91-82 | PO11542110776 | 100 | 285 | 433 | 62 | 5 | 2023-02-26 | 324.45 | 8.11 | 2023-02-14 | 1 | 300.12 | 1 | 324.45 | 3 | SO48020 | 2023-02-21 | 25.96 | 300.12 | 324.45 | |||
SO48020_4 | 3995-4B91-82 | PO11542110776 | 100 | 285 | 325 | 62 | 5 | 2023-02-26 | 469.79 | 11.74 | 2023-02-14 | 1 | 486.71 | 1 | 469.79 | 4 | SO48020 | 2023-02-21 | 37.58 | 486.71 | 469.79 | |||
SO48020_5 | 3995-4B91-82 | PO11542110776 | 100 | 285 | 422 | 62 | 5 | 2023-02-26 | 202.62 | 5.07 | 2023-02-14 | 3 | 49.98 | 1 | 202.62 | 5 | SO48020 | 2023-02-21 | 16.21 | 149.94 | 67.54 | |||
SO48020_6 | 3995-4B91-82 | PO11542110776 | 100 | 285 | 333 | 62 | 5 | 2023-02-26 | 2348.97 | 58.72 | 2023-02-14 | 5 | 486.71 | 1 | 2348.97 | 6 | SO48020 | 2023-02-21 | 187.92 | 2433.53 | 469.79 | |||
SO48020_7 | 3995-4B91-82 | PO11542110776 | 100 | 285 | 329 | 62 | 5 | 2023-02-26 | 1879.18 | 46.98 | 2023-02-14 | 4 | 486.71 | 1 | 1879.18 | 7 | SO48020 | 2023-02-21 | 150.33 | 1946.83 | 469.79 | |||
SO48020_8 | 3995-4B91-82 | PO11542110776 | 100 | 285 | 327 | 62 | 5 | 2023-02-26 | 939.59 | 23.49 | 2023-02-14 | 2 | 486.71 | 1 | 939.59 | 8 | SO48020 | 2023-02-21 | 75.17 | 973.41 | 469.79 | |||
SO48051_1 | D18B-421F-99 | PO3596190178 | 100 | 285 | 401 | 476 | 5 | 2023-02-26 | 65.60 | 1.64 | 2023-02-14 | 1 | 48.55 | 1 | 65.60 | 1 | SO48051 | 2023-02-21 | 5.25 | 48.55 | 65.60 | |||
SO48051_2 | D18B-421F-99 | PO3596190178 | 100 | 285 | 364 | 476 | 5 | 2023-02-26 | 3887.96 | 97.20 | 2023-02-14 | 6 | 598.44 | 1 | 3887.96 | 2 | SO48051 | 2023-02-21 | 311.04 | 3590.61 | 647.99 | |||
SO48051_3 | D18B-421F-99 | PO3596190178 | 100 | 285 | 468 | 476 | 5 | 2023-02-26 | 22.79 | 0.57 | 2023-02-14 | 1 | 15.67 | 1 | 22.79 | 3 | SO48051 | 2023-02-21 | 1.82 | 15.67 | 22.79 | |||
SO48051_4 | D18B-421F-99 | PO3596190178 | 100 | 285 | 412 | 476 | 5 | 2023-02-26 | 180.13 | 4.50 | 2023-02-14 | 1 | 133.30 | 1 | 180.13 | 4 | SO48051 | 2023-02-21 | 14.41 | 133.30 | 180.13 | |||
SO48051_5 | D18B-421F-99 | PO3596190178 | 100 | 285 | 411 | 476 | 5 | 2023-02-26 | 250.83 | 6.27 | 2023-02-14 | 2 | 92.81 | 1 | 250.83 | 5 | SO48051 | 2023-02-21 | 20.07 | 185.61 | 125.42 | |||
SO48051_6 | D18B-421F-99 | PO3596190178 | 100 | 285 | 469 | 476 | 5 | 2023-02-26 | 182.35 | 4.56 | 2023-02-14 | 8 | 15.67 | 1 | 182.35 | 6 | SO48051 | 2023-02-21 | 14.59 | 125.37 | 22.79 |
Generated 2024-11-13 08:55:13.925 UTC