[ROOT] dt FactResellerSale < WHERE DimSalesTerritoryId EQ '7' > < SKIP 269 > < TAKE 24 >
24 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 |
---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
SO51696_1 | 761E-41C4-85 | PO18821111879 | 36 | 292 | 474 | 686 | 7 | 2023-11-27 | 125.98 | 3.15 | 2023-11-15 | 3 | 26.18 | 1 | 125.98 | 1 | SO51696 | 2023-11-22 | 10.08 | 78.53 | 41.99 | |||
SO63161_1 | C577-47A3-88 | PO12731197186 | 36 | 290 | 476 | 247 | 7 | 2024-05-29 | 41.99 | 1.05 | 2024-05-17 | 1 | 26.18 | 1 | 41.99 | 1 | SO63161 | 2024-05-24 | 3.36 | 26.18 | 41.99 | |||
SO48005_13 | 634C-42C5-AB | PO13427183371 | 100 | 292 | 433 | 638 | 7 | 2023-02-27 | 1622.26 | 40.56 | 2023-02-15 | 5 | 300.12 | 1 | 1622.26 | 13 | SO48005 | 2023-02-22 | 129.78 | 1500.59 | 324.45 | |||
SO51696_2 | 761E-41C4-85 | PO18821111879 | 36 | 292 | 511 | 686 | 7 | 2023-11-27 | 218.45 | 5.46 | 2023-11-15 | 1 | 199.38 | 1 | 218.45 | 2 | SO51696 | 2023-11-22 | 17.48 | 199.38 | 218.45 | |||
SO63161_2 | C577-47A3-88 | PO12731197186 | 36 | 290 | 474 | 247 | 7 | 2024-05-29 | 167.98 | 4.20 | 2024-05-17 | 4 | 26.18 | 1 | 167.98 | 2 | SO63161 | 2024-05-24 | 13.44 | 104.71 | 41.99 | |||
SO48005_14 | 634C-42C5-AB | PO13427183371 | 100 | 292 | 333 | 638 | 7 | 2023-02-27 | 2818.76 | 70.47 | 2023-02-15 | 6 | 486.71 | 1 | 2818.76 | 14 | SO48005 | 2023-02-22 | 225.50 | 2920.24 | 469.79 | |||
SO51696_3 | 761E-41C4-85 | PO18821111879 | 36 | 292 | 542 | 686 | 7 | 2023-11-27 | 24.29 | 0.61 | 2023-11-15 | 1 | 17.98 | 1 | 24.29 | 3 | SO51696 | 2023-11-22 | 1.94 | 17.98 | 24.29 | |||
SO63179_1 | F2C5-4376-B7 | PO2668147145 | 100 | 292 | 359 | 535 | 7 | 2024-05-29 | 5507.98 | 137.70 | 2024-05-17 | 4 | 1251.98 | 1 | 5507.98 | 1 | SO63179 | 2024-05-24 | 440.64 | 5007.93 | 1376.99 | |||
SO48005_15 | 634C-42C5-AB | PO13427183371 | 100 | 292 | 267 | 638 | 7 | 2023-02-27 | 404.66 | 10.12 | 2023-02-15 | 2 | 187.16 | 1 | 404.66 | 15 | SO48005 | 2023-02-22 | 32.37 | 374.31 | 202.33 | |||
SO51696_4 | 761E-41C4-85 | PO18821111879 | 36 | 292 | 400 | 686 | 7 | 2023-11-27 | 37.15 | 0.93 | 2023-11-15 | 1 | 27.49 | 1 | 37.15 | 4 | SO51696 | 2023-11-22 | 2.97 | 27.49 | 37.15 | |||
SO63179_2 | F2C5-4376-B7 | PO2668147145 | 100 | 292 | 544 | 535 | 7 | 2024-05-29 | 48.59 | 1.21 | 2024-05-17 | 1 | 35.96 | 1 | 48.59 | 2 | SO63179 | 2024-05-24 | 3.89 | 35.96 | 48.59 | |||
SO48005_16 | 634C-42C5-AB | PO13427183371 | 100 | 292 | 383 | 638 | 7 | 2023-02-27 | 2401.05 | 60.03 | 2023-02-15 | 4 | 605.65 | 1 | 2401.05 | 16 | SO48005 | 2023-02-22 | 192.08 | 2422.60 | 600.26 | |||
SO51696_5 | 761E-41C4-85 | PO18821111879 | 36 | 292 | 359 | 686 | 7 | 2023-11-27 | 1376.99 | 34.42 | 2023-11-15 | 1 | 1251.98 | 1 | 1376.99 | 5 | SO51696 | 2023-11-22 | 110.16 | 1251.98 | 1376.99 | |||
SO63179_3 | F2C5-4376-B7 | PO2668147145 | 100 | 292 | 555 | 535 | 7 | 2024-05-29 | 63.90 | 1.60 | 2024-05-17 | 1 | 47.29 | 1 | 63.90 | 3 | SO63179 | 2024-05-24 | 5.11 | 47.29 | 63.90 | |||
SO48005_17 | 634C-42C5-AB | PO13427183371 | 100 | 292 | 460 | 638 | 7 | 2023-02-27 | 377.96 | 9.45 | 2023-02-15 | 7 | 37.12 | 1 | 377.96 | 17 | SO48005 | 2023-02-22 | 30.24 | 259.85 | 53.99 | |||
SO51696_6 | 761E-41C4-85 | PO18821111879 | 36 | 292 | 476 | 686 | 7 | 2023-11-27 | 125.98 | 3.15 | 2023-11-15 | 3 | 26.18 | 1 | 125.98 | 6 | SO51696 | 2023-11-22 | 10.08 | 78.53 | 41.99 | |||
SO63179_4 | F2C5-4376-B7 | PO2668147145 | 100 | 292 | 471 | 2 | 535 | 7 | 8.84 | 2024-05-29 | 441.96 | 10.83 | 2024-05-17 | 12 | 23.75 | 1 | 433.12 | 4 | SO63179 | 2024-05-24 | 34.65 | 284.99 | 36.83 | 0.02 |
SO48005_18 | 634C-42C5-AB | PO13427183371 | 100 | 292 | 453 | 638 | 7 | 2023-02-27 | 179.97 | 4.50 | 2023-02-15 | 5 | 24.75 | 1 | 179.97 | 18 | SO48005 | 2023-02-22 | 14.40 | 123.73 | 35.99 | |||
SO51696_7 | 761E-41C4-85 | PO18821111879 | 36 | 292 | 544 | 686 | 7 | 2023-11-27 | 97.19 | 2.43 | 2023-11-15 | 2 | 35.96 | 1 | 97.19 | 7 | SO51696 | 2023-11-22 | 7.78 | 71.92 | 48.59 | |||
SO63179_5 | F2C5-4376-B7 | PO2668147145 | 100 | 292 | 595 | 535 | 7 | 2024-05-29 | 677.99 | 16.95 | 2024-05-17 | 2 | 308.22 | 1 | 677.99 | 5 | SO63179 | 2024-05-24 | 54.24 | 616.44 | 338.99 | |||
SO48005_19 | 634C-42C5-AB | PO13427183371 | 100 | 292 | 368 | 638 | 7 | 2023-02-27 | 10262.07 | 256.55 | 2023-02-15 | 7 | 1518.79 | 1 | 10262.07 | 19 | SO48005 | 2023-02-22 | 820.97 | 10631.50 | 1466.01 | |||
SO51708_1 | C46E-4C6C-95 | PO16704159960 | 100 | 292 | 477 | 680 | 7 | 2023-11-27 | 14.97 | 0.37 | 2023-11-15 | 5 | 1.87 | 1 | 14.97 | 1 | SO51708 | 2023-11-22 | 1.20 | 9.33 | 2.99 | |||
SO63179_6 | F2C5-4376-B7 | PO2668147145 | 100 | 292 | 516 | 535 | 7 | 2024-05-29 | 70.45 | 1.76 | 2024-05-17 | 3 | 17.38 | 1 | 70.45 | 6 | SO63179 | 2024-05-24 | 5.64 | 52.13 | 23.48 | |||
SO48005_20 | 634C-42C5-AB | PO13427183371 | 100 | 292 | 254 | 638 | 7 | 2023-02-27 | 1287.57 | 32.19 | 2023-02-15 | 7 | 170.14 | 1 | 1287.57 | 20 | SO48005 | 2023-02-22 | 103.01 | 1191.00 | 183.94 |
Generated 2024-11-14 07:28:59.094 UTC