[ROOT] dt FactResellerSale WHERE DimSalesTerritoryId EQ '1' > SKIP 0 < SKIP 3040 > < TAKE 12 >
12 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 |
---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
SO45518_4 | 2F4B-4BB7-98 | PO20155192513 | 100 | 289 | 348 | 92 | 1 | 2022-05-04 | 4049.99 | 101.25 | 2022-04-22 | 2 | 1898.09 | 1 | 4049.99 | 4 | SO45518 | 2022-04-29 | 324.00 | 3796.19 | 2024.99 | |||
SO48746_2 | 3C67-4620-90 | PO2552136060 | 100 | 286 | 233 | 506 | 1 | 2023-03-06 | 115.36 | 2.88 | 2023-02-22 | 4 | 29.08 | 1 | 115.36 | 2 | SO48746 | 2023-03-01 | 9.23 | 116.32 | 28.84 | |||
SO53452_26 | B555-4FD7-8B | PO870113712 | 100 | 286 | 603 | 621 | 1 | 2023-11-04 | 72.89 | 1.82 | 2023-10-23 | 1 | 53.94 | 1 | 72.89 | 26 | SO53452 | 2023-10-30 | 5.83 | 53.94 | 72.89 | |||
SO45518_5 | 2F4B-4BB7-98 | PO20155192513 | 100 | 289 | 347 | 92 | 1 | 2022-05-04 | 2039.99 | 51.00 | 2022-04-22 | 1 | 1912.15 | 1 | 2039.99 | 5 | SO45518 | 2022-04-29 | 163.20 | 1912.15 | 2039.99 | |||
SO48746_3 | 3C67-4620-90 | PO2552136060 | 100 | 286 | 458 | 506 | 1 | 2023-03-06 | 89.99 | 2.25 | 2023-02-22 | 2 | 30.93 | 1 | 89.99 | 3 | SO48746 | 2023-03-01 | 7.20 | 61.87 | 44.99 | |||
SO53452_27 | B555-4FD7-8B | PO870113712 | 100 | 286 | 559 | 621 | 1 | 2023-11-04 | 48.58 | 1.21 | 2023-10-23 | 4 | 8.99 | 1 | 48.58 | 27 | SO53452 | 2023-10-30 | 3.89 | 35.95 | 12.14 | |||
SO45521_1 | CD43-442B-91 | PO19169144736 | 100 | 289 | 346 | 272 | 1 | 2022-05-04 | 2039.99 | 51.00 | 2022-04-22 | 1 | 1912.15 | 1 | 2039.99 | 1 | SO45521 | 2022-04-29 | 163.20 | 1912.15 | 2039.99 | |||
SO48746_4 | 3C67-4620-90 | PO2552136060 | 100 | 286 | 358 | 506 | 1 | 2023-03-06 | 9835.67 | 245.89 | 2023-02-22 | 8 | 1105.81 | 1 | 9835.67 | 4 | SO48746 | 2023-03-01 | 786.85 | 8846.48 | 1229.46 | |||
SO53452_28 | B555-4FD7-8B | PO870113712 | 100 | 286 | 506 | 621 | 1 | 2023-11-04 | 400.10 | 10.00 | 2023-10-23 | 2 | 199.85 | 1 | 400.10 | 28 | SO53452 | 2023-10-30 | 32.01 | 399.70 | 200.05 | |||
SO45521_2 | CD43-442B-91 | PO19169144736 | 100 | 289 | 292 | 272 | 1 | 2022-05-04 | 818.70 | 20.47 | 2022-04-22 | 1 | 706.81 | 1 | 818.70 | 2 | SO45521 | 2022-04-29 | 65.50 | 706.81 | 818.70 | |||
SO48746_5 | 3C67-4620-90 | PO2552136060 | 100 | 286 | 362 | 506 | 1 | 2023-03-06 | 3688.38 | 92.21 | 2023-02-22 | 3 | 1105.81 | 1 | 3688.38 | 5 | SO48746 | 2023-03-01 | 295.07 | 3317.43 | 1229.46 | |||
SO53452_29 | B555-4FD7-8B | PO870113712 | 100 | 286 | 561 | 14 | 621 | 1 | 190.73 | 2023-11-04 | 953.63 | 19.07 | 2023-10-23 | 1 | 1481.94 | 1 | 762.90 | 29 | SO53452 | 2023-10-30 | 61.03 | 1481.94 | 953.63 | 0.20 |
Generated 2024-09-21 14:25:57.876 UTC