[ROOT] dt FactResellerSale WHERE DimSalesTerritoryId EQ '1' > SHUFFLE < SKIP 3236 > < TAKE 30 >
30 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_49 | 5712-444B-BC | PO841197199 | 100 | 286 | 306 | 254 | 1 | 2023-12-24 | 3239.04 | 80.98 | 2023-12-12 | 4 | 739.04 | 1 | 3239.04 | 49 | SO53518 | 2023-12-19 | 259.12 | 2956.16 | 809.76 | |||
SO57026_29 | CD5A-4300-81 | PO16675118038 | 100 | 293 | 501 | 361 | 1 | 2024-02-23 | 218.63 | 5.47 | 2024-02-11 | 3 | 53.93 | 1 | 218.63 | 29 | SO57026 | 2024-02-18 | 17.49 | 161.78 | 72.88 | |||
SO46957_19 | C98D-43A5-8A | PO16414179284 | 100 | 289 | 468 | 236 | 1 | 2022-11-23 | 45.59 | 1.14 | 2022-11-11 | 2 | 15.67 | 1 | 45.59 | 19 | SO46957 | 2022-11-18 | 3.65 | 31.34 | 22.79 | |||
SO50218_17 | B8E9-4FE2-8B | PO14442144367 | 100 | 293 | 456 | 127 | 1 | 2023-08-23 | 269.96 | 6.75 | 2023-08-11 | 6 | 30.93 | 1 | 269.96 | 17 | SO50218 | 2023-08-18 | 21.60 | 185.60 | 44.99 | |||
SO63131_8 | E035-4732-84 | PO18676136384 | 100 | 282 | 532 | 697 | 1 | 2024-05-25 | 299.75 | 7.49 | 2024-05-13 | 2 | 136.79 | 1 | 299.75 | 8 | SO63131 | 2024-05-20 | 23.98 | 273.57 | 149.87 | |||
SO51128_3 | 5A2E-45E2-A5 | PO2929192490 | 100 | 289 | 475 | 380 | 1 | 2023-10-23 | 83.99 | 2.10 | 2023-10-11 | 2 | 26.18 | 1 | 83.99 | 3 | SO51128 | 2023-10-18 | 6.72 | 52.35 | 41.99 | |||
SO58961_35 | 0848-4E9B-81 | PO10411162031 | 100 | 289 | 234 | 182 | 1 | 2024-03-24 | 89.98 | 2.25 | 2024-03-12 | 3 | 38.49 | 1 | 89.98 | 35 | SO58961 | 2024-03-19 | 7.20 | 115.48 | 29.99 | |||
SO57160_3 | 86C3-4E21-9D | PO4727197868 | 100 | 293 | 287 | 343 | 1 | 2024-02-23 | 202.33 | 5.06 | 2024-02-11 | 1 | 204.63 | 1 | 202.33 | 3 | SO57160 | 2024-02-18 | 16.19 | 204.63 | 202.33 | |||
SO69475_35 | F74A-4967-BA | PO18618162557 | 100 | 286 | 217 | 605 | 1 | 2024-08-23 | 83.98 | 2.10 | 2024-08-11 | 4 | 13.09 | 1 | 83.98 | 35 | SO69475 | 2024-08-18 | 6.72 | 52.35 | 20.99 | |||
SO58917_7 | 0658-4A38-93 | PO17487197562 | 100 | 293 | 477 | 692 | 1 | 2024-03-24 | 2.99 | 0.07 | 2024-03-12 | 1 | 1.87 | 1 | 2.99 | 7 | SO58917 | 2024-03-19 | 0.24 | 1.87 | 2.99 | |||
SO65312_1 | 19D1-4059-B8 | PO6815121334 | 100 | 293 | 511 | 109 | 1 | 2024-06-23 | 1092.27 | 27.31 | 2024-06-11 | 5 | 199.38 | 1 | 1092.27 | 1 | SO65312 | 2024-06-18 | 87.38 | 996.88 | 218.45 | |||
SO43860_1 | E57D-4B4B-BF | PO16646146654 | 100 | 286 | 324 | 1 | 1 | 2021-11-23 | 838.92 | 20.97 | 2021-11-11 | 2 | 413.15 | 1 | 838.92 | 1 | SO43860 | 2021-11-18 | 67.11 | 826.29 | 419.46 | |||
SO59066_16 | 9FAA-410F-AB | PO9309141643 | 100 | 293 | 575 | 55 | 1 | 2024-03-24 | 1430.44 | 35.76 | 2024-03-12 | 1 | 1481.94 | 1 | 1430.44 | 16 | SO59066 | 2024-03-19 | 114.44 | 1481.94 | 1430.44 | |||
SO53514_11 | 8580-40F8-81 | PO10411179199 | 100 | 289 | 559 | 182 | 1 | 2023-12-24 | 97.15 | 2.43 | 2023-12-12 | 8 | 8.99 | 1 | 97.15 | 11 | SO53514 | 2023-12-19 | 7.77 | 71.89 | 12.14 | |||
SO69406_35 | E101-486C-A5 | PO16675181672 | 100 | 293 | 225 | 2 | 361 | 1 | 1.15 | 2024-08-23 | 57.36 | 1.41 | 2024-08-11 | 11 | 6.92 | 1 | 56.21 | 35 | SO69406 | 2024-08-18 | 4.50 | 76.15 | 5.21 | 0.02 |
SO71861_1 | 21C6-4FE7-96 | PO14152156429 | 100 | 293 | 376 | 37 | 1 | 2024-09-23 | 1466.01 | 36.65 | 2024-09-11 | 1 | 1554.95 | 1 | 1466.01 | 1 | SO71861 | 2024-09-18 | 117.28 | 1554.95 | 1466.01 | |||
SO47666_16 | 6551-4B29-BF | PO16588184420 | 100 | 289 | 224 | 146 | 1 | 2023-01-23 | 10.37 | 0.26 | 2023-01-11 | 2 | 5.23 | 1 | 10.37 | 16 | SO47666 | 2023-01-18 | 0.83 | 10.46 | 5.19 | |||
SO63133_34 | C3D9-4B73-83 | PO18618146912 | 100 | 286 | 500 | 605 | 1 | 2024-05-25 | 602.35 | 15.06 | 2024-05-13 | 1 | 601.74 | 1 | 602.35 | 34 | SO63133 | 2024-05-20 | 48.19 | 601.74 | 602.35 | |||
SO63149_15 | 7EF2-4565-86 | PO16414166653 | 100 | 289 | 398 | 236 | 1 | 2024-05-25 | 133.62 | 3.34 | 2024-05-13 | 5 | 19.78 | 1 | 133.62 | 15 | SO63149 | 2024-05-20 | 10.69 | 98.88 | 26.72 | |||
SO47368_6 | 7A90-4975-A2 | PO17487188099 | 100 | 286 | 422 | 692 | 1 | 2022-12-24 | 67.54 | 1.69 | 2022-12-12 | 1 | 49.98 | 1 | 67.54 | 6 | SO47368 | 2022-12-19 | 5.40 | 49.98 | 67.54 | |||
SO47694_21 | 8253-4E13-9D | PO899122764 | 100 | 289 | 466 | 290 | 1 | 2023-01-23 | 42.39 | 1.06 | 2023-01-11 | 3 | 9.71 | 1 | 42.39 | 21 | SO47694 | 2023-01-18 | 3.39 | 29.14 | 14.13 | |||
SO50693_20 | 0DA5-4EE4-93 | PO841149385 | 100 | 286 | 466 | 254 | 1 | 2023-09-23 | 98.90 | 2.47 | 2023-09-11 | 7 | 9.71 | 1 | 98.90 | 20 | SO50693 | 2023-09-18 | 7.91 | 68.00 | 14.13 | |||
SO51127_10 | D321-4FEA-80 | PO2552155165 | 100 | 286 | 543 | 506 | 1 | 2023-10-23 | 111.76 | 2.79 | 2023-10-11 | 3 | 27.57 | 1 | 111.76 | 10 | SO51127 | 2023-10-18 | 8.94 | 82.70 | 37.25 | |||
SO65200_16 | C4A9-49C4-AE | PO841148607 | 100 | 286 | 475 | 254 | 1 | 2024-06-23 | 83.99 | 2.10 | 2024-06-11 | 2 | 26.18 | 1 | 83.99 | 16 | SO65200 | 2024-06-18 | 6.72 | 52.35 | 41.99 | |||
SO65268_16 | E14C-42AB-92 | PO9309127032 | 100 | 293 | 575 | 55 | 1 | 2024-06-23 | 5721.77 | 143.04 | 2024-06-11 | 4 | 1481.94 | 1 | 5721.77 | 16 | SO65268 | 2024-06-18 | 457.74 | 5927.75 | 1430.44 | |||
SO44109_10 | 1055-4F53-BB | PO783112882 | 100 | 286 | 322 | 91 | 1 | 2021-12-24 | 838.92 | 20.97 | 2021-12-12 | 2 | 413.15 | 1 | 838.92 | 10 | SO44109 | 2021-12-19 | 67.11 | 826.29 | 419.46 | |||
SO65203_2 | 9BC1-42EB-81 | PO1160175245 | 100 | 289 | 568 | 38 | 1 | 2024-06-23 | 445.41 | 11.14 | 2024-06-11 | 1 | 461.44 | 1 | 445.41 | 2 | SO65203 | 2024-06-18 | 35.63 | 461.44 | 445.41 | |||
SO46356_10 | 30BA-40DA-B4 | PO783139385 | 100 | 286 | 311 | 91 | 1 | 2022-09-23 | 8587.85 | 214.70 | 2022-09-11 | 4 | 2171.29 | 1 | 8587.85 | 10 | SO46356 | 2022-09-18 | 687.03 | 8685.18 | 2146.96 | |||
SO44511_2 | 4BD6-4CFA-B8 | PO14529113218 | 100 | 286 | 347 | 289 | 1 | 2022-02-23 | 2039.99 | 51.00 | 2022-02-11 | 1 | 1912.15 | 1 | 2039.99 | 2 | SO44511 | 2022-02-18 | 163.20 | 1912.15 | 2039.99 | |||
SO53518_18 | 5712-444B-BC | PO841197199 | 100 | 286 | 532 | 2 | 254 | 1 | 31.87 | 2023-12-24 | 1593.66 | 39.04 | 2023-12-12 | 11 | 136.79 | 1 | 1561.79 | 18 | SO53518 | 2023-12-19 | 124.94 | 1504.64 | 144.88 | 0.02 |
Generated 2024-11-10 20:56:52.762 UTC