[ROOT] dt FactResellerSale < WHERE DimSalesTerritoryId EQ '7' > SKIP 500 SHUFFLE < SKIP 29 > < 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 |
---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
SO50224_8 | 729B-4859-AB | PO12731112971 | 36 | 292 | 468 | 247 | 7 | 2023-07-03 | 45.59 | 1.14 | 2023-06-21 | 2 | 15.67 | 1 | 45.59 | 8 | SO50224 | 2023-06-28 | 3.65 | 31.34 | 22.79 | |||
SO67339_22 | E214-4902-AC | PO3509143630 | 36 | 292 | 463 | 139 | 7 | 2024-06-03 | 44.08 | 1.10 | 2024-05-22 | 3 | 9.16 | 1 | 44.08 | 22 | SO67339 | 2024-05-29 | 3.53 | 27.48 | 14.69 | |||
SO53479_3 | 0F6A-4DE7-BC | PO15109129210 | 100 | 292 | 553 | 49 | 7 | 2023-11-03 | 27.65 | 0.69 | 2023-10-22 | 1 | 20.46 | 1 | 27.65 | 3 | SO53479 | 2023-10-29 | 2.21 | 20.46 | 27.65 | |||
SO67276_34 | 9FD9-4B05-AA | PO13340158801 | 100 | 292 | 533 | 355 | 7 | 2024-06-03 | 149.87 | 3.75 | 2024-05-22 | 1 | 136.79 | 1 | 149.87 | 34 | SO67276 | 2024-05-29 | 11.99 | 136.79 | 149.87 | |||
SO69506_4 | DCE2-4698-93 | PO3712113892 | 100 | 292 | 560 | 662 | 7 | 2024-07-03 | 728.91 | 18.22 | 2024-06-21 | 1 | 755.15 | 1 | 728.91 | 4 | SO69506 | 2024-06-28 | 58.31 | 755.15 | 728.91 | |||
SO50225_5 | 6F8E-49A2-A5 | PO12702153410 | 100 | 292 | 399 | 175 | 7 | 2023-07-03 | 202.65 | 5.07 | 2023-06-21 | 6 | 24.99 | 1 | 202.65 | 5 | SO50225 | 2023-06-28 | 16.21 | 149.96 | 33.77 | |||
SO57051_38 | 0E3B-4DB5-83 | PO13427178709 | 100 | 292 | 376 | 638 | 7 | 2024-01-03 | 8796.06 | 219.90 | 2023-12-22 | 6 | 1554.95 | 1 | 8796.06 | 38 | SO57051 | 2023-12-29 | 703.68 | 9329.69 | 1466.01 | |||
SO47391_8 | 8A04-4F3F-97 | PO12673197440 | 100 | 292 | 383 | 499 | 7 | 2022-11-03 | 3001.31 | 75.03 | 2022-10-22 | 5 | 605.65 | 1 | 3001.31 | 8 | SO47391 | 2022-10-29 | 240.11 | 3028.25 | 600.26 | |||
SO63179_1 | F2C5-4376-B7 | PO2668147145 | 100 | 292 | 359 | 535 | 7 | 2024-04-04 | 5507.98 | 137.70 | 2024-03-23 | 4 | 1251.98 | 1 | 5507.98 | 1 | SO63179 | 2024-03-30 | 440.64 | 5007.93 | 1376.99 | |||
SO53525_10 | F162-4A87-B4 | PO1305155715 | 100 | 292 | 234 | 319 | 7 | 2023-11-03 | 59.99 | 1.50 | 2023-10-22 | 2 | 38.49 | 1 | 59.99 | 10 | SO53525 | 2023-10-29 | 4.80 | 76.98 | 29.99 | |||
SO61258_7 | 9DCB-43A8-8D | PO3509137345 | 36 | 292 | 217 | 139 | 7 | 2024-03-04 | 146.96 | 3.67 | 2024-02-21 | 7 | 13.09 | 1 | 146.96 | 7 | SO61258 | 2024-02-28 | 11.76 | 91.60 | 20.99 | |||
SO49833_34 | 595A-4EFA-AC | PO13340158028 | 100 | 292 | 360 | 355 | 7 | 2023-06-03 | 4917.84 | 122.95 | 2023-05-22 | 4 | 1105.81 | 1 | 4917.84 | 34 | SO49833 | 2023-05-29 | 393.43 | 4423.24 | 1229.46 | |||
SO51774_40 | 30BA-400A-89 | PO2668194455 | 100 | 292 | 214 | 535 | 7 | 2023-10-03 | 125.96 | 3.15 | 2023-09-21 | 6 | 13.09 | 1 | 125.96 | 40 | SO51774 | 2023-09-28 | 10.08 | 78.52 | 20.99 | |||
SO53525_6 | F162-4A87-B4 | PO1305155715 | 100 | 292 | 586 | 13 | 319 | 7 | 50.11 | 2023-11-03 | 334.06 | 7.10 | 2023-10-22 | 1 | 461.44 | 1 | 283.95 | 6 | SO53525 | 2023-10-29 | 22.72 | 461.44 | 334.06 | 0.15 |
Generated 2024-09-20 12:29:22.437 UTC