[ROOT] dt FactResellerSale < WHERE DimSalesTerritoryId EQ '5' > < SKIP 2581 > < 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 |
---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
SO46354_1 | 6226-4881-B8 | PO319132451 | 100 | 285 | 336 | 116 | 5 | 2022-08-04 | 419.46 | 10.49 | 2022-07-23 | 1 | 413.15 | 1 | 419.46 | 1 | SO46354 | 2022-07-30 | 33.56 | 413.15 | 419.46 | |||
SO48063_9 | AEA4-4489-90 | PO5858143254 | 100 | 285 | 470 | 566 | 5 | 2023-01-04 | 205.15 | 5.13 | 2022-12-23 | 9 | 15.67 | 1 | 205.15 | 9 | SO48063 | 2022-12-30 | 16.41 | 141.04 | 22.79 | |||
SO65207_9 | B20E-440F-A3 | PO1537156240 | 100 | 285 | 503 | 611 | 5 | 2024-05-04 | 200.05 | 5.00 | 2024-04-22 | 1 | 199.85 | 1 | 200.05 | 9 | SO65207 | 2024-04-29 | 16.00 | 199.85 | 200.05 | |||
SO46361_1 | 904E-4D86-AC | PO1943193225 | 100 | 285 | 322 | 525 | 5 | 2022-08-04 | 1258.38 | 31.46 | 2022-07-23 | 3 | 413.15 | 1 | 1258.38 | 1 | SO46361 | 2022-07-30 | 100.67 | 1239.44 | 419.46 | |||
SO48063_10 | AEA4-4489-90 | PO5858143254 | 100 | 285 | 308 | 566 | 5 | 2023-01-04 | 1488.55 | 37.21 | 2022-12-23 | 2 | 660.91 | 1 | 1488.55 | 10 | SO48063 | 2022-12-30 | 119.08 | 1321.83 | 744.27 | |||
SO65207_10 | B20E-440F-A3 | PO1537156240 | 100 | 285 | 217 | 611 | 5 | 2024-05-04 | 83.98 | 2.10 | 2024-04-22 | 4 | 13.09 | 1 | 83.98 | 10 | SO65207 | 2024-04-29 | 6.72 | 52.35 | 20.99 | |||
SO46361_2 | 904E-4D86-AC | PO1943193225 | 100 | 285 | 319 | 525 | 5 | 2022-08-04 | 1749.59 | 43.74 | 2022-07-23 | 2 | 884.71 | 1 | 1749.59 | 2 | SO46361 | 2022-07-30 | 139.97 | 1769.42 | 874.79 | |||
SO48063_11 | AEA4-4489-90 | PO5858143254 | 100 | 285 | 360 | 566 | 5 | 2023-01-04 | 1229.46 | 30.74 | 2022-12-23 | 1 | 1105.81 | 1 | 1229.46 | 11 | SO48063 | 2022-12-30 | 98.36 | 1105.81 | 1229.46 | |||
SO65207_11 | B20E-440F-A3 | PO1537156240 | 100 | 285 | 477 | 611 | 5 | 2024-05-04 | 11.98 | 0.30 | 2024-04-22 | 4 | 1.87 | 1 | 11.98 | 11 | SO65207 | 2024-04-29 | 0.96 | 7.47 | 2.99 | |||
SO46361_3 | 904E-4D86-AC | PO1943193225 | 100 | 285 | 223 | 525 | 5 | 2022-08-04 | 5.19 | 0.13 | 2022-07-23 | 1 | 5.71 | 1 | 5.19 | 3 | SO46361 | 2022-07-30 | 0.41 | 5.71 | 5.19 | |||
SO48063_12 | AEA4-4489-90 | PO5858143254 | 100 | 285 | 367 | 566 | 5 | 2023-01-04 | 1295.99 | 32.40 | 2022-12-23 | 2 | 598.44 | 1 | 1295.99 | 12 | SO48063 | 2022-12-30 | 103.68 | 1196.87 | 647.99 | |||
SO65207_12 | B20E-440F-A3 | PO1537156240 | 100 | 285 | 565 | 611 | 5 | 2024-05-04 | 445.41 | 11.14 | 2024-04-22 | 1 | 461.44 | 1 | 445.41 | 12 | SO65207 | 2024-04-29 | 35.63 | 461.44 | 445.41 | |||
SO46361_4 | 904E-4D86-AC | PO1943193225 | 100 | 285 | 342 | 525 | 5 | 2022-08-04 | 1258.38 | 31.46 | 2022-07-23 | 3 | 413.15 | 1 | 1258.38 | 4 | SO46361 | 2022-07-30 | 100.67 | 1239.44 | 419.46 | |||
SO48063_13 | AEA4-4489-90 | PO5858143254 | 100 | 285 | 230 | 566 | 5 | 2023-01-04 | 201.88 | 5.05 | 2022-12-23 | 7 | 29.08 | 1 | 201.88 | 13 | SO48063 | 2022-12-30 | 16.15 | 203.56 | 28.84 | |||
SO65207_13 | B20E-440F-A3 | PO1537156240 | 100 | 285 | 237 | 611 | 5 | 2024-05-04 | 59.99 | 1.50 | 2024-04-22 | 2 | 38.49 | 1 | 59.99 | 13 | SO65207 | 2024-04-29 | 4.80 | 76.98 | 29.99 | |||
SO46361_5 | 904E-4D86-AC | PO1943193225 | 100 | 285 | 326 | 525 | 5 | 2022-08-04 | 1258.38 | 31.46 | 2022-07-23 | 3 | 413.15 | 1 | 1258.38 | 5 | SO46361 | 2022-07-30 | 100.67 | 1239.44 | 419.46 | |||
SO48063_14 | AEA4-4489-90 | PO5858143254 | 100 | 285 | 233 | 566 | 5 | 2023-01-04 | 115.36 | 2.88 | 2022-12-23 | 4 | 29.08 | 1 | 115.36 | 14 | SO48063 | 2022-12-30 | 9.23 | 116.32 | 28.84 | |||
SO65207_14 | B20E-440F-A3 | PO1537156240 | 100 | 285 | 484 | 611 | 5 | 2024-05-04 | 14.31 | 0.36 | 2024-04-22 | 3 | 2.97 | 1 | 14.31 | 14 | SO65207 | 2024-04-29 | 1.14 | 8.92 | 4.77 | |||
SO46365_1 | BFDB-4B9A-83 | PO4089182386 | 100 | 285 | 348 | 7 | 368 | 5 | 590.62 | 2022-08-04 | 1687.50 | 27.42 | 2022-07-23 | 2 | 1898.09 | 1 | 1096.87 | 1 | SO46365 | 2022-07-30 | 87.75 | 3796.19 | 843.75 | 0.35 |
SO48063_15 | AEA4-4489-90 | PO5858143254 | 100 | 285 | 445 | 566 | 5 | 2023-01-04 | 107.98 | 2.70 | 2022-12-23 | 3 | 24.75 | 1 | 107.98 | 15 | SO48063 | 2022-12-30 | 8.64 | 74.24 | 35.99 | |||
SO65207_15 | B20E-440F-A3 | PO1537156240 | 100 | 285 | 568 | 611 | 5 | 2024-05-04 | 1781.64 | 44.54 | 2024-04-22 | 4 | 461.44 | 1 | 1781.64 | 15 | SO65207 | 2024-04-29 | 142.53 | 1845.78 | 445.41 | |||
SO46365_2 | BFDB-4B9A-83 | PO4089182386 | 100 | 285 | 347 | 7 | 368 | 5 | 297.50 | 2022-08-04 | 850.00 | 13.81 | 2022-07-23 | 1 | 1912.15 | 1 | 552.50 | 2 | SO46365 | 2022-07-30 | 44.20 | 1912.15 | 850.00 | 0.35 |
SO48063_16 | AEA4-4489-90 | PO5858143254 | 100 | 285 | 427 | 566 | 5 | 2023-01-04 | 418.51 | 10.46 | 2022-12-23 | 2 | 185.82 | 1 | 418.51 | 16 | SO48063 | 2022-12-30 | 33.48 | 371.64 | 209.26 | |||
SO65207_16 | B20E-440F-A3 | PO1537156240 | 100 | 285 | 488 | 611 | 5 | 2024-05-04 | 129.58 | 3.24 | 2024-04-22 | 4 | 41.57 | 1 | 129.58 | 16 | SO65207 | 2024-04-29 | 10.37 | 166.29 | 32.39 |
Generated 2024-09-21 08:47:58.200 UTC