[ROOT] dt FactResellerSale < WHERE DimSalesTerritoryId EQ '7' > < SKIP 383 > < 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 |
---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
SO51724_10 | 9157-480F-8E | PO15080116248 | 100 | 292 | 559 | 283 | 7 | 2023-10-04 | 24.29 | 0.61 | 2023-09-22 | 2 | 8.99 | 1 | 24.29 | 10 | SO51724 | 2023-09-29 | 1.94 | 17.97 | 12.14 | |||
SO63179_37 | F2C5-4376-B7 | PO2668147145 | 100 | 292 | 398 | 535 | 7 | 2024-04-05 | 26.72 | 0.67 | 2024-03-24 | 1 | 19.78 | 1 | 26.72 | 37 | SO63179 | 2024-03-31 | 2.14 | 19.78 | 26.72 | |||
SO48005_51 | 634C-42C5-AB | PO13427183371 | 100 | 292 | 415 | 638 | 7 | 2023-01-04 | 198.04 | 4.95 | 2022-12-23 | 1 | 146.55 | 1 | 198.04 | 51 | SO48005 | 2022-12-30 | 15.84 | 146.55 | 198.04 | |||
SO51724_11 | 9157-480F-8E | PO15080116248 | 100 | 292 | 231 | 283 | 7 | 2023-10-04 | 29.99 | 0.75 | 2023-09-22 | 1 | 38.49 | 1 | 29.99 | 11 | SO51724 | 2023-09-29 | 2.40 | 38.49 | 29.99 | |||
SO63179_38 | F2C5-4376-B7 | PO2668147145 | 100 | 292 | 309 | 535 | 7 | 2024-04-05 | 4093.50 | 102.34 | 2024-03-24 | 5 | 747.20 | 1 | 4093.50 | 38 | SO63179 | 2024-03-31 | 327.48 | 3736.00 | 818.70 | |||
SO48005_52 | 634C-42C5-AB | PO13427183371 | 100 | 292 | 271 | 638 | 7 | 2023-01-04 | 809.33 | 20.23 | 2022-12-23 | 4 | 187.16 | 1 | 809.33 | 52 | SO48005 | 2022-12-30 | 64.75 | 748.63 | 202.33 | |||
SO51724_12 | 9157-480F-8E | PO15080116248 | 100 | 292 | 586 | 13 | 283 | 7 | 100.22 | 2023-10-04 | 668.12 | 14.20 | 2023-09-22 | 2 | 461.44 | 1 | 567.90 | 12 | SO51724 | 2023-09-29 | 45.43 | 922.89 | 334.06 | 0.15 |
SO63179_39 | F2C5-4376-B7 | PO2668147145 | 100 | 292 | 487 | 535 | 7 | 2024-04-05 | 131.98 | 3.30 | 2024-03-24 | 4 | 20.57 | 1 | 131.98 | 39 | SO63179 | 2024-03-31 | 10.56 | 82.27 | 32.99 | |||
SO48005_53 | 634C-42C5-AB | PO13427183371 | 100 | 292 | 456 | 638 | 7 | 2023-01-04 | 269.96 | 6.75 | 2022-12-23 | 6 | 30.93 | 1 | 269.96 | 53 | SO48005 | 2022-12-30 | 21.60 | 185.60 | 44.99 | |||
SO51724_13 | 9157-480F-8E | PO15080116248 | 100 | 292 | 569 | 13 | 283 | 7 | 50.11 | 2023-10-04 | 334.06 | 7.10 | 2023-09-22 | 1 | 461.44 | 1 | 283.95 | 13 | SO51724 | 2023-09-29 | 22.72 | 461.44 | 334.06 | 0.15 |
SO63179_40 | F2C5-4376-B7 | PO2668147145 | 100 | 292 | 527 | 535 | 7 | 2024-04-05 | 792.15 | 19.80 | 2024-03-24 | 5 | 144.59 | 1 | 792.15 | 40 | SO63179 | 2024-03-31 | 63.37 | 722.97 | 158.43 | |||
SO48005_54 | 634C-42C5-AB | PO13427183371 | 100 | 292 | 280 | 638 | 7 | 2023-01-04 | 367.88 | 9.20 | 2022-12-23 | 2 | 170.14 | 1 | 367.88 | 54 | SO48005 | 2022-12-30 | 29.43 | 340.29 | 183.94 | |||
SO51724_14 | 9157-480F-8E | PO15080116248 | 100 | 292 | 499 | 283 | 7 | 2023-10-04 | 602.35 | 15.06 | 2023-09-22 | 1 | 601.74 | 1 | 602.35 | 14 | SO51724 | 2023-09-29 | 48.19 | 601.74 | 602.35 | |||
SO63179_41 | F2C5-4376-B7 | PO2668147145 | 100 | 292 | 400 | 535 | 7 | 2024-04-05 | 74.30 | 1.86 | 2024-03-24 | 2 | 27.49 | 1 | 74.30 | 41 | SO63179 | 2024-03-31 | 5.94 | 54.99 | 37.15 |
Generated 2024-09-21 08:48:41.011 UTC