[ROOT] dt FactResellerSale WHERE DimSalesTerritoryId EQ '1' > SHUFFLE < SKIP 7000 > < TAKE 31 >
31 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 |
---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
SO47368_16 | 7A90-4975-A2 | PO17487188099 | 100 | 286 | 415 | 692 | 1 | 2022-11-02 | 594.11 | 14.85 | 2022-10-21 | 3 | 146.55 | 1 | 594.11 | 16 | SO47368 | 2022-10-28 | 47.53 | 439.64 | 198.04 | |||
SO45549_5 | E477-44D2-B0 | PO783111978 | 100 | 286 | 326 | 91 | 1 | 2022-05-02 | 1677.84 | 41.95 | 2022-04-20 | 4 | 413.15 | 1 | 1677.84 | 5 | SO45549 | 2022-04-27 | 134.23 | 1652.59 | 419.46 | |||
SO48749_3 | 5843-40F4-97 | PO2581113508 | 100 | 282 | 329 | 698 | 1 | 2023-03-04 | 469.79 | 11.74 | 2023-02-20 | 1 | 486.71 | 1 | 469.79 | 3 | SO48749 | 2023-02-27 | 37.58 | 486.71 | 469.79 | |||
SO49167_7 | 5A78-4DE2-89 | PO8816115193 | 100 | 289 | 343 | 218 | 1 | 2023-04-04 | 1879.18 | 46.98 | 2023-03-23 | 4 | 486.71 | 1 | 1879.18 | 7 | SO49167 | 2023-03-30 | 150.33 | 1946.83 | 469.79 | |||
SO45267_1 | E20E-4F50-AC | PO19981117950 | 100 | 286 | 326 | 271 | 1 | 2022-04-04 | 419.46 | 10.49 | 2022-03-23 | 1 | 413.15 | 1 | 419.46 | 1 | SO45267 | 2022-03-30 | 33.56 | 413.15 | 419.46 | |||
SO53569_23 | 113E-43AD-94 | PO9309141312 | 100 | 293 | 562 | 14 | 55 | 1 | 381.45 | 2023-11-02 | 1907.26 | 38.15 | 2023-10-21 | 2 | 1481.94 | 1 | 1525.80 | 23 | SO53569 | 2023-10-28 | 122.06 | 2963.88 | 953.63 | 0.20 |
SO55299_32 | 0B56-423B-B7 | PO6612171212 | 100 | 286 | 552 | 110 | 1 | 2023-12-02 | 164.68 | 4.12 | 2023-11-20 | 3 | 40.62 | 1 | 164.68 | 32 | SO55299 | 2023-11-27 | 13.17 | 121.86 | 54.89 | |||
SO45804_8 | A72B-452A-BA | PO2552178124 | 100 | 289 | 220 | 506 | 1 | 2022-06-02 | 40.37 | 1.01 | 2022-05-21 | 2 | 12.03 | 1 | 40.37 | 8 | SO45804 | 2022-05-28 | 3.23 | 24.06 | 20.19 | |||
SO50297_27 | 5199-40AD-90 | PO4727113542 | 100 | 293 | 387 | 343 | 1 | 2023-07-02 | 3001.31 | 75.03 | 2023-06-20 | 5 | 605.65 | 1 | 3001.31 | 27 | SO50297 | 2023-06-27 | 240.11 | 3028.25 | 600.26 | |||
SO58946_8 | F9DD-426F-9A | PO12470155874 | 100 | 287 | 564 | 672 | 1 | 2024-02-01 | 4291.33 | 107.28 | 2024-01-20 | 3 | 1481.94 | 1 | 4291.33 | 8 | SO58946 | 2024-01-27 | 343.31 | 4445.81 | 1430.44 | |||
SO58962_1 | 12B1-4451-9A | PO870180310 | 100 | 286 | 586 | 621 | 1 | 2024-02-01 | 445.41 | 11.14 | 2024-01-20 | 1 | 461.44 | 1 | 445.41 | 1 | SO58962 | 2024-01-27 | 35.63 | 461.44 | 445.41 | |||
SO51712_35 | 910D-4560-A7 | PO16675134576 | 100 | 293 | 565 | 13 | 361 | 1 | 100.22 | 2023-10-02 | 668.12 | 14.20 | 2023-09-20 | 2 | 461.44 | 1 | 567.90 | 35 | SO51712 | 2023-09-27 | 45.43 | 922.89 | 334.06 | 0.15 |
SO55277_25 | E9AB-453F-BA | PO2552111630 | 100 | 286 | 363 | 506 | 1 | 2023-12-02 | 9638.96 | 240.97 | 2023-11-20 | 7 | 1251.98 | 1 | 9638.96 | 25 | SO55277 | 2023-11-27 | 771.12 | 8763.87 | 1376.99 | |||
SO53518_13 | 5712-444B-BC | PO841197199 | 100 | 286 | 298 | 254 | 1 | 2023-11-02 | 4048.80 | 101.22 | 2023-10-21 | 5 | 739.04 | 1 | 4048.80 | 13 | SO53518 | 2023-10-28 | 323.90 | 3695.21 | 809.76 | |||
SO65312_23 | 19D1-4059-B8 | PO6815121334 | 100 | 293 | 532 | 109 | 1 | 2024-05-02 | 149.87 | 3.75 | 2024-04-20 | 1 | 136.79 | 1 | 149.87 | 23 | SO65312 | 2024-04-27 | 11.99 | 136.79 | 149.87 | |||
SO49494_4 | 81A4-4876-94 | PO17139199930 | 100 | 293 | 417 | 644 | 1 | 2023-05-02 | 1297.81 | 32.45 | 2023-04-20 | 4 | 300.12 | 1 | 1297.81 | 4 | SO49494 | 2023-04-27 | 103.82 | 1200.48 | 324.45 | |||
SO46957_9 | C98D-43A5-8A | PO16414179284 | 100 | 289 | 354 | 236 | 1 | 2022-10-02 | 4971.41 | 124.29 | 2022-09-20 | 4 | 1117.86 | 1 | 4971.41 | 9 | SO46957 | 2022-09-27 | 397.71 | 4471.42 | 1242.85 | |||
SO49092_4 | 72CE-4E29-82 | PO14442163644 | 100 | 293 | 396 | 127 | 1 | 2023-04-04 | 74.84 | 1.87 | 2023-03-23 | 1 | 55.38 | 1 | 74.84 | 4 | SO49092 | 2023-03-30 | 5.99 | 55.38 | 74.84 | |||
SO46053_10 | E530-47A7-9A | PO14471143194 | 100 | 286 | 212 | 145 | 1 | 2022-07-02 | 40.37 | 1.01 | 2022-06-20 | 2 | 12.03 | 1 | 40.37 | 10 | SO46053 | 2022-06-27 | 3.23 | 24.06 | 20.19 | |||
SO59021_14 | A306-4E83-B7 | PO7395154426 | 100 | 286 | 587 | 542 | 1 | 2024-02-01 | 461.69 | 11.54 | 2024-01-20 | 1 | 419.78 | 1 | 461.69 | 14 | SO59021 | 2024-01-27 | 36.94 | 419.78 | 461.69 | |||
SO57031_2 | DBE2-481E-96 | PO16907113073 | 100 | 293 | 599 | 217 | 1 | 2024-01-02 | 323.99 | 8.10 | 2023-12-21 | 1 | 294.58 | 1 | 323.99 | 2 | SO57031 | 2023-12-28 | 25.92 | 294.58 | 323.99 | |||
SO57160_3 | 86C3-4E21-9D | PO4727197868 | 100 | 293 | 287 | 343 | 1 | 2024-01-02 | 202.33 | 5.06 | 2023-12-21 | 1 | 204.63 | 1 | 202.33 | 3 | SO57160 | 2023-12-28 | 16.19 | 204.63 | 202.33 | |||
SO63157_39 | 9E62-4577-80 | PO14500183845 | 100 | 282 | 483 | 650 | 1 | 2024-04-03 | 648.00 | 16.20 | 2024-03-22 | 9 | 44.88 | 1 | 648.00 | 39 | SO63157 | 2024-03-29 | 51.84 | 403.92 | 72.00 | |||
SO45283_3 | 07F7-44C2-BA | PO16646111452 | 100 | 286 | 311 | 1 | 1 | 2022-04-04 | 4293.92 | 107.35 | 2022-03-23 | 2 | 2171.29 | 1 | 4293.92 | 3 | SO45283 | 2022-03-30 | 343.51 | 4342.59 | 2146.96 | |||
SO59031_17 | 15F5-4B32-AC | PO5017142991 | 100 | 289 | 498 | 308 | 1 | 2024-02-01 | 1204.69 | 30.12 | 2024-01-20 | 2 | 601.74 | 1 | 1204.69 | 17 | SO59031 | 2024-01-27 | 96.38 | 1203.49 | 602.35 | |||
SO46643_8 | 49E8-4C7A-85 | PO899110603 | 100 | 289 | 331 | 290 | 1 | 2022-09-01 | 2348.97 | 58.72 | 2022-08-20 | 5 | 486.71 | 1 | 2348.97 | 8 | SO46643 | 2022-08-27 | 187.92 | 2433.53 | 469.79 | |||
SO47033_52 | 2797-46ED-BB | PO4727113716 | 100 | 286 | 236 | 343 | 1 | 2022-10-02 | 230.72 | 5.77 | 2022-09-20 | 8 | 29.08 | 1 | 230.72 | 52 | SO47033 | 2022-09-27 | 18.46 | 232.65 | 28.84 | |||
SO65234_14 | 3BB7-4A9F-AF | PO10411160249 | 100 | 289 | 585 | 182 | 1 | 2024-05-02 | 890.82 | 22.27 | 2024-04-20 | 2 | 461.44 | 1 | 890.82 | 14 | SO65234 | 2024-04-27 | 71.27 | 922.89 | 445.41 | |||
SO49464_18 | C383-45FE-83 | PO841195010 | 100 | 286 | 352 | 254 | 1 | 2023-05-02 | 1242.85 | 31.07 | 2023-04-20 | 1 | 1117.86 | 1 | 1242.85 | 18 | SO49464 | 2023-04-27 | 99.43 | 1117.86 | 1242.85 | |||
SO67321_1 | 7F43-4E4F-8E | PO7076150186 | 100 | 293 | 577 | 505 | 1 | 2024-06-02 | 728.91 | 18.22 | 2024-05-21 | 1 | 755.15 | 1 | 728.91 | 1 | SO67321 | 2024-05-28 | 58.31 | 755.15 | 728.91 | |||
SO44743_6 | F9C5-4063-B1 | PO19169113389 | 100 | 289 | 304 | 272 | 1 | 2022-02-01 | 1429.41 | 35.74 | 2022-01-20 | 2 | 617.03 | 1 | 1429.41 | 6 | SO44743 | 2022-01-27 | 114.35 | 1234.06 | 714.70 |
Generated 2024-09-19 23:40:29.064 UTC