[ROOT] dt FactResellerSale WHERE DimSalesTerritoryId EQ '1' > < SKIP 6185 > < TAKE 14 >
14 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 |
---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
SO53518_61 | 5712-444B-BC | PO841197199 | 100 | 286 | 592 | 254 | 1 | 2023-11-04 | 338.99 | 8.47 | 2023-10-23 | 1 | 308.22 | 1 | 338.99 | 61 | SO53518 | 2023-10-30 | 27.12 | 308.22 | 338.99 | |||
SO53522_1 | F389-4C2A-BD | PO1160127782 | 100 | 289 | 568 | 13 | 38 | 1 | 150.33 | 2023-11-04 | 1002.17 | 21.30 | 2023-10-23 | 3 | 461.44 | 1 | 851.85 | 1 | SO53522 | 2023-10-30 | 68.15 | 1384.33 | 334.06 | 0.15 |
SO53522_2 | F389-4C2A-BD | PO1160127782 | 100 | 289 | 572 | 13 | 38 | 1 | 50.11 | 2023-11-04 | 334.06 | 7.10 | 2023-10-23 | 1 | 461.44 | 1 | 283.95 | 2 | SO53522 | 2023-10-30 | 22.72 | 461.44 | 334.06 | 0.15 |
SO53547_1 | C80F-4007-AC | PO14065128727 | 100 | 293 | 240 | 379 | 1 | 2023-11-04 | 1717.80 | 42.95 | 2023-10-23 | 2 | 868.63 | 1 | 1717.80 | 1 | SO53547 | 2023-10-30 | 137.42 | 1737.27 | 858.90 | |||
SO53547_2 | C80F-4007-AC | PO14065128727 | 100 | 293 | 243 | 379 | 1 | 2023-11-04 | 2576.70 | 64.42 | 2023-10-23 | 3 | 868.63 | 1 | 2576.70 | 2 | SO53547 | 2023-10-30 | 206.14 | 2605.90 | 858.90 | |||
SO53547_3 | C80F-4007-AC | PO14065128727 | 100 | 293 | 404 | 379 | 1 | 2023-11-04 | 26.72 | 0.67 | 2023-10-23 | 1 | 19.78 | 1 | 26.72 | 3 | SO53547 | 2023-10-30 | 2.14 | 19.78 | 26.72 | |||
SO53569_1 | 113E-43AD-94 | PO9309141312 | 100 | 293 | 575 | 55 | 1 | 2023-11-04 | 2860.88 | 71.52 | 2023-10-23 | 2 | 1481.94 | 1 | 2860.88 | 1 | SO53569 | 2023-10-30 | 228.87 | 2963.88 | 1430.44 | |||
SO53569_2 | 113E-43AD-94 | PO9309141312 | 100 | 293 | 566 | 13 | 55 | 1 | 50.11 | 2023-11-04 | 334.06 | 7.10 | 2023-10-23 | 1 | 461.44 | 1 | 283.95 | 2 | SO53569 | 2023-10-30 | 22.72 | 461.44 | 334.06 | 0.15 |
SO53569_3 | 113E-43AD-94 | PO9309141312 | 100 | 293 | 501 | 55 | 1 | 2023-11-04 | 72.88 | 1.82 | 2023-10-23 | 1 | 53.93 | 1 | 72.88 | 3 | SO53569 | 2023-10-30 | 5.83 | 53.93 | 72.88 | |||
SO53569_4 | 113E-43AD-94 | PO9309141312 | 100 | 293 | 601 | 55 | 1 | 2023-11-04 | 32.39 | 0.81 | 2023-10-23 | 1 | 23.97 | 1 | 32.39 | 4 | SO53569 | 2023-10-30 | 2.59 | 23.97 | 32.39 | |||
SO53569_5 | 113E-43AD-94 | PO9309141312 | 100 | 293 | 585 | 13 | 55 | 1 | 150.33 | 2023-11-04 | 1002.17 | 21.30 | 2023-10-23 | 3 | 461.44 | 1 | 851.85 | 5 | SO53569 | 2023-10-30 | 68.15 | 1384.33 | 334.06 | 0.15 |
SO53569_6 | 113E-43AD-94 | PO9309141312 | 100 | 293 | 586 | 13 | 55 | 1 | 50.11 | 2023-11-04 | 334.06 | 7.10 | 2023-10-23 | 1 | 461.44 | 1 | 283.95 | 6 | SO53569 | 2023-10-30 | 22.72 | 461.44 | 334.06 | 0.15 |
SO53569_7 | 113E-43AD-94 | PO9309141312 | 100 | 293 | 554 | 55 | 1 | 2023-11-04 | 109.88 | 2.75 | 2023-10-23 | 2 | 40.66 | 1 | 109.88 | 7 | SO53569 | 2023-10-30 | 8.79 | 81.31 | 54.94 | |||
SO50314_5 | 5D9A-4B55-81 | PO7627146177 | 100 | 293 | 369 | 433 | 1 | 2023-07-04 | 2932.02 | 73.30 | 2023-06-22 | 2 | 1518.79 | 1 | 2932.02 | 5 | SO50314 | 2023-06-29 | 234.56 | 3037.57 | 1466.01 |
Generated 2024-09-21 11:45:30.920 UTC