[ROOT] dt FactResellerSale WHERE DimSalesTerritoryId EQ '1' > SHUFFLE SKIP 2000 < SKIP 700 > < TAKE 60 >
60 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 |
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
| SO63157_31 | 9E62-4577-80 | PO14500183845 | 100 | 282 | 298 | 650 | 1 | 2024-05-25 | 1619.52 | 40.49 | 2024-05-13 | 2 | 739.04 | 1 | 1619.52 | 31 | SO63157 | 2024-05-20 | 129.56 | 1478.08 | 809.76 | |||
| SO47698_29 | 3841-4995-8C | PO2552129685 | 100 | 286 | 236 | 506 | 1 | 2023-01-23 | 115.36 | 2.88 | 2023-01-11 | 4 | 29.08 | 1 | 115.36 | 29 | SO47698 | 2023-01-18 | 9.23 | 116.32 | 28.84 | |||
| SO58963_10 | 6ADC-4485-8C | PO841129336 | 100 | 286 | 556 | 254 | 1 | 2024-03-24 | 526.47 | 13.16 | 2024-03-12 | 5 | 77.92 | 1 | 526.47 | 10 | SO58963 | 2024-03-19 | 42.12 | 389.59 | 105.29 | |||
| SO48347_30 | 40D2-4DF5-93 | PO841112057 | 100 | 286 | 391 | 254 | 1 | 2023-03-25 | 266.80 | 6.67 | 2023-03-13 | 3 | 65.81 | 1 | 266.80 | 30 | SO48347 | 2023-03-20 | 21.34 | 197.43 | 88.93 | |||
| SO53518_26 | 5712-444B-BC | PO841197199 | 100 | 286 | 513 | 254 | 1 | 2023-12-24 | 218.45 | 5.46 | 2023-12-12 | 1 | 199.38 | 1 | 218.45 | 26 | SO53518 | 2023-12-19 | 17.48 | 199.38 | 218.45 | |||
| SO67266_6 | 3CFE-46C9-88 | PO16588161069 | 100 | 289 | 476 | 5 | 146 | 1 | 193.70 | 2024-07-24 | 1291.32 | 27.44 | 2024-07-12 | 41 | 26.18 | 1 | 1097.62 | 6 | SO67266 | 2024-07-19 | 87.81 | 1073.23 | 31.50 | 0.15 |
| SO47986_32 | 3373-4C22-A9 | PO16414116972 | 100 | 289 | 221 | 236 | 1 | 2023-02-23 | 121.12 | 3.03 | 2023-02-11 | 6 | 13.88 | 1 | 121.12 | 32 | SO47986 | 2023-02-18 | 9.69 | 83.27 | 20.19 | |||
| SO48310_8 | B389-4D7D-85 | PO17139173607 | 100 | 293 | 369 | 644 | 1 | 2023-03-25 | 1466.01 | 36.65 | 2023-03-13 | 1 | 1518.79 | 1 | 1466.01 | 8 | SO48310 | 2023-03-20 | 117.28 | 1518.79 | 1466.01 | |||
| SO61213_3 | 30C9-4B2A-B1 | PO14094112722 | 100 | 293 | 382 | 253 | 1 | 2024-04-24 | 672.29 | 16.81 | 2024-04-12 | 1 | 713.08 | 1 | 672.29 | 3 | SO61213 | 2024-04-19 | 53.78 | 713.08 | 672.29 | |||
| SO45338_19 | EA29-4912-A1 | PO7627114520 | 100 | 286 | 336 | 433 | 1 | 2022-05-26 | 419.46 | 10.49 | 2022-05-14 | 1 | 413.15 | 1 | 419.46 | 19 | SO45338 | 2022-05-21 | 33.56 | 413.15 | 419.46 | |||
| SO49852_1 | 5DD7-447A-8D | PO2581189096 | 100 | 282 | 325 | 698 | 1 | 2023-07-24 | 1409.38 | 35.23 | 2023-07-12 | 3 | 486.71 | 1 | 1409.38 | 1 | SO49852 | 2023-07-19 | 112.75 | 1460.12 | 469.79 | |||
| SO48347_19 | 40D2-4DF5-93 | PO841112057 | 100 | 286 | 305 | 254 | 1 | 2023-03-25 | 2208.44 | 55.21 | 2023-03-13 | 3 | 653.70 | 1 | 2208.44 | 19 | SO48347 | 2023-03-20 | 176.67 | 1961.09 | 736.15 | |||
| SO45804_2 | A72B-452A-BA | PO2552178124 | 100 | 289 | 212 | 506 | 1 | 2022-07-24 | 40.37 | 1.01 | 2022-07-12 | 2 | 12.03 | 1 | 40.37 | 2 | SO45804 | 2022-07-19 | 3.23 | 24.06 | 20.19 | |||
| SO47033_8 | 2797-46ED-BB | PO4727113716 | 100 | 286 | 439 | 343 | 1 | 2022-11-23 | 2342.45 | 58.56 | 2022-11-11 | 3 | 722.26 | 1 | 2342.45 | 8 | SO47033 | 2022-11-18 | 187.40 | 2166.77 | 780.82 | |||
| SO48347_32 | 40D2-4DF5-93 | PO841112057 | 100 | 286 | 458 | 254 | 1 | 2023-03-25 | 449.94 | 11.25 | 2023-03-13 | 10 | 30.93 | 1 | 449.94 | 32 | SO48347 | 2023-03-20 | 36.00 | 309.33 | 44.99 | |||
| SO71785_17 | 28F9-4101-A1 | PO19169115427 | 100 | 289 | 363 | 272 | 1 | 2024-09-23 | 2753.99 | 68.85 | 2024-09-11 | 2 | 1251.98 | 1 | 2753.99 | 17 | SO71785 | 2024-09-18 | 220.32 | 2503.96 | 1376.99 | |||
| SO48087_30 | 2285-4C77-9B | PO8816162044 | 100 | 289 | 323 | 218 | 1 | 2023-02-23 | 939.59 | 23.49 | 2023-02-11 | 2 | 486.71 | 1 | 939.59 | 30 | SO48087 | 2023-02-18 | 75.17 | 973.41 | 469.79 | |||
| SO63133_13 | C3D9-4B73-83 | PO18618146912 | 100 | 286 | 237 | 605 | 1 | 2024-05-25 | 149.97 | 3.75 | 2024-05-13 | 5 | 38.49 | 1 | 149.97 | 13 | SO63133 | 2024-05-20 | 12.00 | 192.46 | 29.99 | |||
| SO44100_16 | D5BC-4BB2-BF | PO13543119495 | 100 | 287 | 292 | 293 | 1 | 2021-12-24 | 2456.10 | 61.40 | 2021-12-12 | 3 | 706.81 | 1 | 2456.10 | 16 | SO44100 | 2021-12-19 | 196.49 | 2120.43 | 818.70 | |||
| SO47054_7 | E4B1-4C58-AE | PO7627150376 | 100 | 286 | 415 | 433 | 1 | 2022-11-23 | 198.04 | 4.95 | 2022-11-11 | 1 | 146.55 | 1 | 198.04 | 7 | SO47054 | 2022-11-18 | 15.84 | 146.55 | 198.04 | |||
| SO59031_16 | 15F5-4B32-AC | PO5017142991 | 100 | 289 | 500 | 308 | 1 | 2024-03-24 | 4818.77 | 120.47 | 2024-03-12 | 8 | 601.74 | 1 | 4818.77 | 16 | SO59031 | 2024-03-19 | 385.50 | 4813.95 | 602.35 | |||
| SO50669_3 | CEEB-4329-BA | PO17487120000 | 100 | 293 | 329 | 692 | 1 | 2023-09-23 | 469.79 | 11.74 | 2023-09-11 | 1 | 486.71 | 1 | 469.79 | 3 | SO50669 | 2023-09-18 | 37.58 | 486.71 | 469.79 | |||
| SO53514_26 | 8580-40F8-81 | PO10411179199 | 100 | 289 | 576 | 182 | 1 | 2023-12-24 | 2860.88 | 71.52 | 2023-12-12 | 2 | 1481.94 | 1 | 2860.88 | 26 | SO53514 | 2023-12-19 | 228.87 | 2963.88 | 1430.44 | |||
| SO46030_2 | 8D5D-4CBC-8F | PO18908181698 | 100 | 289 | 218 | 164 | 1 | 2022-08-23 | 34.20 | 0.86 | 2022-08-11 | 6 | 3.40 | 1 | 34.20 | 2 | SO46030 | 2022-08-18 | 2.74 | 20.38 | 5.70 | |||
| SO44501_19 | 4971-4FC0-A3 | PO16646128920 | 100 | 286 | 336 | 1 | 1 | 2022-02-23 | 838.92 | 20.97 | 2022-02-11 | 2 | 413.15 | 1 | 838.92 | 19 | SO44501 | 2022-02-18 | 67.11 | 826.29 | 419.46 | |||
| SO50206_41 | 7656-4E84-B8 | PO16414158832 | 100 | 289 | 230 | 236 | 1 | 2023-08-23 | 173.04 | 4.33 | 2023-08-11 | 6 | 29.08 | 1 | 173.04 | 41 | SO50206 | 2023-08-18 | 13.84 | 174.48 | 28.84 | |||
| SO51146_9 | FC91-4E19-86 | PO7076128836 | 100 | 293 | 553 | 505 | 1 | 2023-10-23 | 27.65 | 0.69 | 2023-10-11 | 1 | 20.46 | 1 | 27.65 | 9 | SO51146 | 2023-10-18 | 2.21 | 20.46 | 27.65 | |||
| SO50216_1 | 5648-4FA8-B5 | PO14558158414 | 100 | 289 | 224 | 2 | 1 | 2023-08-23 | 15.56 | 0.39 | 2023-08-11 | 3 | 5.23 | 1 | 15.56 | 1 | SO50216 | 2023-08-18 | 1.24 | 15.69 | 5.19 | |||
| SO47033_41 | 2797-46ED-BB | PO4727113716 | 100 | 286 | 461 | 343 | 1 | 2022-11-23 | 107.99 | 2.70 | 2022-11-11 | 2 | 37.12 | 1 | 107.99 | 41 | SO47033 | 2022-11-18 | 8.64 | 74.24 | 53.99 | |||
| SO65270_2 | E73B-4A64-B4 | PO7192196898 | 100 | 289 | 361 | 20 | 1 | 2024-06-23 | 1376.99 | 34.42 | 2024-06-11 | 1 | 1251.98 | 1 | 1376.99 | 2 | SO65270 | 2024-06-18 | 110.16 | 1251.98 | 1376.99 | |||
| SO61199_16 | EFA0-4D12-A2 | PO2552199779 | 100 | 286 | 512 | 506 | 1 | 2024-04-24 | 655.36 | 16.38 | 2024-04-12 | 3 | 199.38 | 1 | 655.36 | 16 | SO61199 | 2024-04-19 | 52.43 | 598.13 | 218.45 | |||
| SO49503_8 | 1FD6-48BE-A1 | PO13543189827 | 100 | 287 | 399 | 293 | 1 | 2023-06-23 | 67.55 | 1.69 | 2023-06-11 | 2 | 24.99 | 1 | 67.55 | 8 | SO49503 | 2023-06-18 | 5.40 | 49.99 | 33.77 | |||
| SO48757_2 | C817-44D2-B4 | PO16588132026 | 100 | 289 | 458 | 146 | 1 | 2023-04-25 | 179.98 | 4.50 | 2023-04-13 | 4 | 30.93 | 1 | 179.98 | 2 | SO48757 | 2023-04-20 | 14.40 | 123.73 | 44.99 | |||
| SO58963_40 | 6ADC-4485-8C | PO841129336 | 100 | 286 | 558 | 254 | 1 | 2024-03-24 | 728.98 | 18.22 | 2024-03-12 | 3 | 179.82 | 1 | 728.98 | 40 | SO58963 | 2024-03-19 | 58.32 | 539.45 | 242.99 | |||
| SO58910_11 | A209-4ADD-98 | PO19169152738 | 100 | 289 | 512 | 272 | 1 | 2024-03-24 | 655.36 | 16.38 | 2024-03-12 | 3 | 199.38 | 1 | 655.36 | 11 | SO58910 | 2024-03-19 | 52.43 | 598.13 | 218.45 | |||
| SO46944_24 | 7854-48E8-92 | PO18676186070 | 100 | 282 | 428 | 697 | 1 | 2022-11-23 | 418.51 | 10.46 | 2022-11-11 | 2 | 185.82 | 1 | 418.51 | 24 | SO46944 | 2022-11-18 | 33.48 | 371.64 | 209.26 | |||
| SO50206_48 | 7656-4E84-B8 | PO16414158832 | 100 | 289 | 396 | 236 | 1 | 2023-08-23 | 224.51 | 5.61 | 2023-08-11 | 3 | 55.38 | 1 | 224.51 | 48 | SO50206 | 2023-08-18 | 17.96 | 166.14 | 74.84 | |||
| SO65159_11 | DDDD-4736-9B | PO19169187435 | 100 | 289 | 558 | 272 | 1 | 2024-06-23 | 485.99 | 12.15 | 2024-06-11 | 2 | 179.82 | 1 | 485.99 | 11 | SO65159 | 2024-06-18 | 38.88 | 359.63 | 242.99 | |||
| SO51826_4 | DBF7-4FCA-86 | PO6148188136 | 100 | 289 | 576 | 2 | 693 | 1 | 359.52 | 2023-11-23 | 17975.89 | 440.41 | 2023-11-11 | 13 | 1481.94 | 1 | 17616.37 | 4 | SO51826 | 2023-11-18 | 1409.31 | 19265.19 | 1382.76 | 0.02 |
| SO44563_7 | 9AFF-40A9-96 | PO7627161014 | 100 | 286 | 313 | 433 | 1 | 2022-02-23 | 4293.92 | 107.35 | 2022-02-11 | 2 | 2171.29 | 1 | 4293.92 | 7 | SO44563 | 2022-02-18 | 343.51 | 4342.59 | 2146.96 | |||
| SO48757_18 | C817-44D2-B4 | PO16588132026 | 100 | 289 | 365 | 146 | 1 | 2023-04-25 | 3887.96 | 97.20 | 2023-04-13 | 6 | 598.44 | 1 | 3887.96 | 18 | SO48757 | 2023-04-20 | 311.04 | 3590.61 | 647.99 | |||
| SO43664_2 | 2F44-4BA1-BB | PO16617121983 | 100 | 286 | 348 | 397 | 1 | 2021-10-23 | 8099.98 | 202.50 | 2021-10-11 | 4 | 1898.09 | 1 | 8099.98 | 2 | SO43664 | 2021-10-18 | 648.00 | 7592.38 | 2024.99 | |||
| SO47701_7 | 5718-4DDD-B7 | PO2929114832 | 100 | 289 | 456 | 380 | 1 | 2023-01-23 | 44.99 | 1.12 | 2023-01-11 | 1 | 30.93 | 1 | 44.99 | 7 | SO47701 | 2023-01-18 | 3.60 | 30.93 | 44.99 | |||
| SO51726_17 | 9BC5-4281-AF | PO14587157005 | 100 | 293 | 503 | 199 | 1 | 2023-11-23 | 200.05 | 5.00 | 2023-11-11 | 1 | 199.85 | 1 | 200.05 | 17 | SO51726 | 2023-11-18 | 16.00 | 199.85 | 200.05 | |||
| SO58910_4 | A209-4ADD-98 | PO19169152738 | 100 | 289 | 353 | 272 | 1 | 2024-03-24 | 5567.98 | 139.20 | 2024-03-12 | 4 | 1265.62 | 1 | 5567.98 | 4 | SO58910 | 2024-03-19 | 445.44 | 5062.48 | 1391.99 | |||
| SO47367_12 | 7C51-451A-B4 | PO17139175308 | 100 | 286 | 375 | 644 | 1 | 2022-12-24 | 7853.63 | 196.34 | 2022-12-12 | 6 | 1320.68 | 1 | 7853.63 | 12 | SO47367 | 2022-12-19 | 628.29 | 7924.10 | 1308.94 | |||
| SO45521_4 | CD43-442B-91 | PO19169144736 | 100 | 289 | 344 | 272 | 1 | 2022-06-23 | 4079.99 | 102.00 | 2022-06-11 | 2 | 1912.15 | 1 | 4079.99 | 4 | SO45521 | 2022-06-18 | 326.40 | 3824.31 | 2039.99 | |||
| SO44514_9 | 7135-4E3F-B3 | PO14500153038 | 100 | 282 | 347 | 650 | 1 | 2022-02-23 | 4079.99 | 102.00 | 2022-02-11 | 2 | 1912.15 | 1 | 4079.99 | 9 | SO44514 | 2022-02-18 | 326.40 | 3824.31 | 2039.99 | |||
| SO71932_5 | AC27-4EE0-AE | PO7192157995 | 100 | 289 | 477 | 20 | 1 | 2024-09-23 | 8.98 | 0.22 | 2024-09-11 | 3 | 1.87 | 1 | 8.98 | 5 | SO71932 | 2024-09-18 | 0.72 | 5.60 | 2.99 | |||
| SO47992_8 | 3F55-4354-BD | PO15573158216 | 100 | 293 | 356 | 487 | 1 | 2023-02-23 | 1242.85 | 31.07 | 2023-02-11 | 1 | 1117.86 | 1 | 1242.85 | 8 | SO47992 | 2023-02-18 | 99.43 | 1117.86 | 1242.85 | |||
| SO51712_25 | 910D-4560-A7 | PO16675134576 | 100 | 293 | 214 | 361 | 1 | 2023-11-23 | 41.99 | 1.05 | 2023-11-11 | 2 | 13.09 | 1 | 41.99 | 25 | SO51712 | 2023-11-18 | 3.36 | 26.17 | 20.99 | |||
| SO50321_18 | 6B3D-47E0-99 | PO8816191637 | 100 | 289 | 383 | 218 | 1 | 2023-08-23 | 2401.05 | 60.03 | 2023-08-11 | 4 | 605.65 | 1 | 2401.05 | 18 | SO50321 | 2023-08-18 | 192.08 | 2422.60 | 600.26 | |||
| SO46042_19 | FE13-4E1B-A4 | PO16646156443 | 100 | 286 | 340 | 1 | 1 | 2022-08-23 | 419.46 | 10.49 | 2022-08-11 | 1 | 413.15 | 1 | 419.46 | 19 | SO46042 | 2022-08-18 | 33.56 | 413.15 | 419.46 | |||
| SO49053_25 | 5BE4-4969-A1 | PO16414175823 | 100 | 289 | 469 | 236 | 1 | 2023-05-26 | 182.35 | 4.56 | 2023-05-14 | 8 | 15.67 | 1 | 182.35 | 25 | SO49053 | 2023-05-21 | 14.59 | 125.37 | 22.79 | |||
| SO57136_23 | 0031-4C10-84 | PO7627163680 | 100 | 272 | 545 | 433 | 1 | 2024-02-23 | 145.76 | 3.64 | 2024-02-11 | 6 | 17.98 | 1 | 145.76 | 23 | SO57136 | 2024-02-18 | 11.66 | 107.87 | 24.29 | |||
| SO51089_41 | A635-4BAF-BC | PO16588151558 | 100 | 289 | 592 | 146 | 1 | 2023-10-23 | 1355.98 | 33.90 | 2023-10-11 | 4 | 308.22 | 1 | 1355.98 | 41 | SO51089 | 2023-10-18 | 108.48 | 1232.87 | 338.99 | |||
| SO51728_6 | 5481-42D0-8C | PO14558119777 | 100 | 289 | 465 | 2 | 1 | 2023-11-23 | 73.47 | 1.84 | 2023-11-11 | 5 | 9.16 | 1 | 73.47 | 6 | SO51728 | 2023-11-18 | 5.88 | 45.80 | 14.69 | |||
| SO57176_3 | 6881-42A1-B6 | PO7917176909 | 100 | 287 | 471 | 401 | 1 | 2024-02-23 | 76.20 | 1.91 | 2024-02-11 | 2 | 23.75 | 1 | 76.20 | 3 | SO57176 | 2024-02-18 | 6.10 | 47.50 | 38.10 | |||
| SO47999_12 | DF06-4F6A-9D | PO14500121568 | 100 | 282 | 394 | 650 | 1 | 2023-02-23 | 41.04 | 1.03 | 2023-02-11 | 2 | 15.18 | 1 | 41.04 | 12 | SO47999 | 2023-02-18 | 3.28 | 30.37 | 20.52 | |||
| SO46667_3 | D3CD-4A6E-94 | PO7105131549 | 100 | 286 | 263 | 668 | 1 | 2022-10-23 | 607.00 | 15.17 | 2022-10-11 | 3 | 187.16 | 1 | 607.00 | 3 | SO46667 | 2022-10-18 | 48.56 | 561.47 | 202.33 |
Generated 2024-11-10 09:26:50.496 UTC