[ROOT] dt FactResellerSale WHERE DimSalesTerritoryId EQ '1' > SKIP 0 SHUFFLE < SKIP 1127 > < 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 |
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
| SO47452_6 | 79C0-49E8-B3 | PO8903162839 | 100 | 286 | 221 | 235 | 1 | 2022-12-24 | 20.19 | 0.50 | 2022-12-12 | 1 | 13.88 | 1 | 20.19 | 6 | SO47452 | 2022-12-19 | 1.61 | 13.88 | 20.19 | |||
| SO53605_18 | 6D2A-486B-AC | PO5017132122 | 100 | 289 | 499 | 308 | 1 | 2023-12-24 | 1204.69 | 30.12 | 2023-12-12 | 2 | 601.74 | 1 | 1204.69 | 18 | SO53605 | 2023-12-19 | 96.38 | 1203.49 | 602.35 | |||
| SO58963_34 | 6ADC-4485-8C | PO841129336 | 100 | 286 | 355 | 254 | 1 | 2024-03-24 | 2783.99 | 69.60 | 2024-03-12 | 2 | 1265.62 | 1 | 2783.99 | 34 | SO58963 | 2024-03-19 | 222.72 | 2531.24 | 1391.99 | |||
| SO50218_13 | B8E9-4FE2-8B | PO14442144367 | 100 | 293 | 453 | 127 | 1 | 2023-08-23 | 71.99 | 1.80 | 2023-08-11 | 2 | 24.75 | 1 | 71.99 | 13 | SO50218 | 2023-08-18 | 5.76 | 49.49 | 35.99 | |||
| SO49464_5 | C383-45FE-83 | PO841195010 | 100 | 286 | 395 | 254 | 1 | 2023-06-23 | 245.50 | 6.14 | 2023-06-11 | 4 | 45.42 | 1 | 245.50 | 5 | SO49464 | 2023-06-18 | 19.64 | 181.67 | 61.37 | |||
| SO58963_3 | 6ADC-4485-8C | PO841129336 | 100 | 286 | 298 | 254 | 1 | 2024-03-24 | 4858.56 | 121.46 | 2024-03-12 | 6 | 739.04 | 1 | 4858.56 | 3 | SO58963 | 2024-03-19 | 388.68 | 4434.25 | 809.76 | |||
| SO59066_23 | 9FAA-410F-AB | PO9309141643 | 100 | 293 | 552 | 55 | 1 | 2024-03-24 | 54.89 | 1.37 | 2024-03-12 | 1 | 40.62 | 1 | 54.89 | 23 | SO59066 | 2024-03-19 | 4.39 | 40.62 | 54.89 | |||
| SO69525_8 | 9DCD-4F42-9E | PO4727119266 | 100 | 293 | 580 | 343 | 1 | 2024-08-23 | 3061.78 | 76.54 | 2024-08-11 | 3 | 1082.51 | 1 | 3061.78 | 8 | SO69525 | 2024-08-18 | 244.94 | 3247.53 | 1020.59 | |||
| SO49092_5 | 72CE-4E29-82 | PO14442163644 | 100 | 293 | 352 | 127 | 1 | 2023-05-26 | 2485.70 | 62.14 | 2023-05-14 | 2 | 1117.86 | 1 | 2485.70 | 5 | SO49092 | 2023-05-21 | 198.86 | 2235.71 | 1242.85 | |||
| SO69406_26 | E101-486C-A5 | PO16675181672 | 100 | 293 | 471 | 361 | 1 | 2024-08-23 | 266.70 | 6.67 | 2024-08-11 | 7 | 23.75 | 1 | 266.70 | 26 | SO69406 | 2024-08-18 | 21.34 | 166.24 | 38.10 | |||
| SO47694_30 | 8253-4E13-9D | PO899122764 | 100 | 289 | 435 | 290 | 1 | 2023-01-23 | 324.45 | 8.11 | 2023-01-11 | 1 | 300.12 | 1 | 324.45 | 30 | SO47694 | 2023-01-18 | 25.96 | 300.12 | 324.45 | |||
| SO50270_7 | A828-45A2-8B | PO18676112371 | 100 | 282 | 410 | 697 | 1 | 2023-08-23 | 182.24 | 4.56 | 2023-08-11 | 5 | 26.97 | 1 | 182.24 | 7 | SO50270 | 2023-08-18 | 14.58 | 134.85 | 36.45 | |||
| SO50314_26 | 5D9A-4B55-81 | PO7627146177 | 100 | 293 | 335 | 433 | 1 | 2023-08-23 | 1409.38 | 35.23 | 2023-08-11 | 3 | 486.71 | 1 | 1409.38 | 26 | SO50314 | 2023-08-18 | 112.75 | 1460.12 | 469.79 | |||
| SO53500_1 | BEF0-4525-AF | PO12470126979 | 100 | 287 | 509 | 672 | 1 | 2023-12-24 | 400.10 | 10.00 | 2023-12-12 | 2 | 199.85 | 1 | 400.10 | 1 | SO53500 | 2023-12-19 | 32.01 | 399.70 | 200.05 | |||
| SO51826_14 | DBF7-4FCA-86 | PO6148188136 | 100 | 289 | 500 | 693 | 1 | 2023-11-23 | 1204.69 | 30.12 | 2023-11-11 | 2 | 601.74 | 1 | 1204.69 | 14 | SO51826 | 2023-11-18 | 96.38 | 1203.49 | 602.35 | |||
| SO57030_5 | 373C-4C0F-88 | PO16414180321 | 100 | 289 | 515 | 236 | 1 | 2024-02-23 | 65.09 | 1.63 | 2024-02-11 | 4 | 12.04 | 1 | 65.09 | 5 | SO57030 | 2024-02-18 | 5.21 | 48.17 | 16.27 | |||
| SO51711_5 | 5CB8-480D-A1 | PO16414129790 | 100 | 289 | 355 | 236 | 1 | 2023-11-23 | 11135.95 | 278.40 | 2023-11-11 | 8 | 1265.62 | 1 | 11135.95 | 5 | SO51711 | 2023-11-18 | 890.88 | 10124.96 | 1391.99 | |||
| SO46105_1 | 2590-40A7-BB | PO8816169858 | 100 | 289 | 334 | 218 | 1 | 2022-08-23 | 1258.38 | 31.46 | 2022-08-11 | 3 | 413.15 | 1 | 1258.38 | 1 | SO46105 | 2022-08-18 | 100.67 | 1239.44 | 419.46 | |||
| SO47367_3 | 7C51-451A-B4 | PO17139175308 | 100 | 286 | 239 | 644 | 1 | 2022-12-24 | 780.82 | 19.52 | 2022-12-12 | 1 | 722.26 | 1 | 780.82 | 3 | SO47367 | 2022-12-19 | 62.47 | 722.26 | 780.82 | |||
| SO57046_59 | 52CC-460F-B3 | PO14500161818 | 100 | 282 | 558 | 650 | 1 | 2024-02-23 | 728.98 | 18.22 | 2024-02-11 | 3 | 179.82 | 1 | 728.98 | 59 | SO57046 | 2024-02-18 | 58.32 | 539.45 | 242.99 | |||
| SO51148_5 | 1D20-490E-98 | PO6612158387 | 100 | 286 | 568 | 13 | 110 | 1 | 250.54 | 2023-10-23 | 1670.29 | 35.49 | 2023-10-11 | 5 | 461.44 | 1 | 1419.74 | 5 | SO51148 | 2023-10-18 | 113.58 | 2307.22 | 334.06 | 0.15 |
| SO69471_9 | 2CF9-42DE-B1 | PO18676191433 | 100 | 282 | 353 | 697 | 1 | 2024-08-23 | 6959.97 | 174.00 | 2024-08-11 | 5 | 1265.62 | 1 | 6959.97 | 9 | SO69471 | 2024-08-18 | 556.80 | 6328.10 | 1391.99 | |||
| SO57046_9 | 52CC-460F-B3 | PO14500161818 | 100 | 282 | 355 | 650 | 1 | 2024-02-23 | 6959.97 | 174.00 | 2024-02-11 | 5 | 1265.62 | 1 | 6959.97 | 9 | SO57046 | 2024-02-18 | 556.80 | 6328.10 | 1391.99 | |||
| SO47992_45 | 3F55-4354-BD | PO15573158216 | 100 | 293 | 289 | 487 | 1 | 2023-02-23 | 744.27 | 18.61 | 2023-02-11 | 1 | 660.91 | 1 | 744.27 | 45 | SO47992 | 2023-02-18 | 59.54 | 660.91 | 744.27 | |||
| SO65200_25 | C4A9-49C4-AE | PO841148607 | 100 | 286 | 353 | 254 | 1 | 2024-06-23 | 1391.99 | 34.80 | 2024-06-11 | 1 | 1265.62 | 1 | 1391.99 | 25 | SO65200 | 2024-06-18 | 111.36 | 1265.62 | 1391.99 | |||
| SO57030_37 | 373C-4C0F-88 | PO16414180321 | 100 | 289 | 400 | 236 | 1 | 2024-02-23 | 260.06 | 6.50 | 2024-02-11 | 7 | 27.49 | 1 | 260.06 | 37 | SO57030 | 2024-02-18 | 20.81 | 192.45 | 37.15 | |||
| SO71812_14 | 3257-4AE0-A8 | PO13543115747 | 100 | 287 | 475 | 293 | 1 | 2024-09-23 | 83.99 | 2.10 | 2024-09-11 | 2 | 26.18 | 1 | 83.99 | 14 | SO71812 | 2024-09-18 | 6.72 | 52.35 | 41.99 | |||
| SO46611_16 | 93A4-4A4D-99 | PO16588117269 | 100 | 289 | 216 | 8 | 146 | 1 | 3.36 | 2022-10-23 | 33.64 | 0.76 | 2022-10-11 | 2 | 13.88 | 1 | 30.28 | 16 | SO46611 | 2022-10-18 | 2.42 | 27.76 | 16.82 | 0.10 |
| SO47986_2 | 3373-4C22-A9 | PO16414116972 | 100 | 289 | 294 | 236 | 1 | 2023-02-23 | 1488.55 | 37.21 | 2023-02-11 | 2 | 660.91 | 1 | 1488.55 | 2 | SO47986 | 2023-02-18 | 119.08 | 1321.83 | 744.27 | |||
| SO46098_4 | CB38-416D-A7 | PO7221115229 | 100 | 289 | 304 | 326 | 1 | 2022-08-23 | 714.70 | 17.87 | 2022-08-11 | 1 | 617.03 | 1 | 714.70 | 4 | SO46098 | 2022-08-18 | 57.18 | 617.03 | 714.70 | |||
| SO50206_38 | 7656-4E84-B8 | PO16414158832 | 100 | 289 | 447 | 236 | 1 | 2023-08-23 | 30.00 | 0.75 | 2023-08-11 | 2 | 10.31 | 1 | 30.00 | 38 | SO50206 | 2023-08-18 | 2.40 | 20.63 | 15.00 |
Generated 2024-11-10 16:20:03.812 UTC