[ROOT] dt FactResellerSale WHERE DimSalesTerritoryId EQ '1' > SHUFFLE < SKIP 7092 > < 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 |
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
| SO46974_24 | BEE6-4EC8-8E | PO14442112586 | 100 | 286 | 469 | 127 | 1 | 2022-11-23 | 45.59 | 1.14 | 2022-11-11 | 2 | 15.67 | 1 | 45.59 | 24 | SO46974 | 2022-11-18 | 3.65 | 31.34 | 22.79 | |||
| SO53518_2 | 5712-444B-BC | PO841197199 | 100 | 286 | 514 | 254 | 1 | 2023-12-24 | 319.50 | 7.99 | 2023-12-12 | 5 | 47.29 | 1 | 319.50 | 2 | SO53518 | 2023-12-19 | 25.56 | 236.43 | 63.90 | |||
| SO45518_3 | 2F4B-4BB7-98 | PO20155192513 | 100 | 289 | 350 | 92 | 1 | 2022-06-23 | 2024.99 | 50.62 | 2022-06-11 | 1 | 1898.09 | 1 | 2024.99 | 3 | SO45518 | 2022-06-18 | 162.00 | 1898.09 | 2024.99 | |||
| 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 | |||
| SO63247_1 | 1EB8-4AE3-AC | PO6148143330 | 100 | 289 | 576 | 693 | 1 | 2024-05-25 | 2860.88 | 71.52 | 2024-05-13 | 2 | 1481.94 | 1 | 2860.88 | 1 | SO63247 | 2024-05-20 | 228.87 | 2963.88 | 1430.44 | |||
| SO44541_6 | 64BA-409F-A1 | PO2958192556 | 100 | 286 | 218 | 559 | 1 | 2022-02-23 | 17.10 | 0.43 | 2022-02-11 | 3 | 3.40 | 1 | 17.10 | 6 | SO44541 | 2022-02-18 | 1.37 | 10.19 | 5.70 | |||
| SO53603_3 | D324-4435-B1 | PO3277197939 | 100 | 293 | 606 | 604 | 1 | 2023-12-24 | 971.98 | 24.30 | 2023-12-12 | 3 | 343.65 | 1 | 971.98 | 3 | SO53603 | 2023-12-19 | 77.76 | 1030.95 | 323.99 | |||
| SO46974_51 | BEE6-4EC8-8E | PO14442112586 | 100 | 286 | 412 | 127 | 1 | 2022-11-23 | 540.39 | 13.51 | 2022-11-11 | 3 | 133.30 | 1 | 540.39 | 51 | SO46974 | 2022-11-18 | 43.23 | 399.89 | 180.13 | |||
| SO50671_3 | 9526-4D73-83 | PO17139132177 | 100 | 293 | 389 | 644 | 1 | 2023-09-23 | 1800.79 | 45.02 | 2023-09-11 | 3 | 605.65 | 1 | 1800.79 | 3 | SO50671 | 2023-09-18 | 144.06 | 1816.95 | 600.26 | |||
| SO58963_4 | 6ADC-4485-8C | PO841129336 | 100 | 286 | 363 | 254 | 1 | 2024-03-24 | 6884.97 | 172.12 | 2024-03-12 | 5 | 1251.98 | 1 | 6884.97 | 4 | SO58963 | 2024-03-19 | 550.80 | 6259.91 | 1376.99 | |||
| SO44741_1 | B08B-4964-AE | PO20155135930 | 100 | 289 | 346 | 92 | 1 | 2022-03-25 | 2039.99 | 51.00 | 2022-03-13 | 1 | 1912.15 | 1 | 2039.99 | 1 | SO44741 | 2022-03-20 | 163.20 | 1912.15 | 2039.99 | |||
| SO47368_7 | 7A90-4975-A2 | PO17487188099 | 100 | 286 | 224 | 692 | 1 | 2022-12-24 | 15.56 | 0.39 | 2022-12-12 | 3 | 5.23 | 1 | 15.56 | 7 | SO47368 | 2022-12-19 | 1.24 | 15.69 | 5.19 | |||
| SO49850_9 | CBD2-4015-97 | PO2929118431 | 100 | 289 | 469 | 380 | 1 | 2023-07-24 | 45.59 | 1.14 | 2023-07-12 | 2 | 15.67 | 1 | 45.59 | 9 | SO49850 | 2023-07-19 | 3.65 | 31.34 | 22.79 | |||
| SO51721_11 | 9429-430D-89 | PO14500124798 | 100 | 282 | 488 | 2 | 650 | 1 | 8.14 | 2023-11-23 | 407.08 | 9.97 | 2023-11-11 | 13 | 41.57 | 1 | 398.94 | 11 | SO51721 | 2023-11-18 | 31.92 | 540.44 | 31.31 | 0.02 |
| SO43867_2 | 061F-4449-BE | PO14471123403 | 100 | 286 | 347 | 145 | 1 | 2021-11-23 | 2039.99 | 51.00 | 2021-11-11 | 1 | 1912.15 | 1 | 2039.99 | 2 | SO43867 | 2021-11-18 | 163.20 | 1912.15 | 2039.99 | |||
| SO59065_9 | C012-48E8-A5 | PO8903194371 | 100 | 293 | 605 | 235 | 1 | 2024-03-24 | 323.99 | 8.10 | 2024-03-12 | 1 | 343.65 | 1 | 323.99 | 9 | SO59065 | 2024-03-19 | 25.92 | 343.65 | 323.99 | |||
| SO47066_26 | 5E42-48DE-80 | PO8816154123 | 100 | 289 | 373 | 218 | 1 | 2022-11-23 | 5235.75 | 130.89 | 2022-11-11 | 4 | 1320.68 | 1 | 5235.75 | 26 | SO47066 | 2022-11-18 | 418.86 | 5282.74 | 1308.94 | |||
| SO50314_23 | 5D9A-4B55-81 | PO7627146177 | 100 | 293 | 323 | 433 | 1 | 2023-08-23 | 1879.18 | 46.98 | 2023-08-11 | 4 | 486.71 | 1 | 1879.18 | 23 | SO50314 | 2023-08-18 | 150.33 | 1946.83 | 469.79 | |||
| SO65263_11 | C0DD-4323-8C | PO7395113656 | 100 | 286 | 544 | 542 | 1 | 2024-06-23 | 48.59 | 1.21 | 2024-06-11 | 1 | 35.96 | 1 | 48.59 | 11 | SO65263 | 2024-06-18 | 3.89 | 35.96 | 48.59 | |||
| SO47992_25 | 3F55-4354-BD | PO15573158216 | 100 | 293 | 236 | 487 | 1 | 2023-02-23 | 173.04 | 4.33 | 2023-02-11 | 6 | 29.08 | 1 | 173.04 | 25 | SO47992 | 2023-02-18 | 13.84 | 174.48 | 28.84 | |||
| SO69525_9 | 9DCD-4F42-9E | PO4727119266 | 100 | 293 | 581 | 343 | 1 | 2024-08-23 | 1020.59 | 25.51 | 2024-08-11 | 1 | 1082.51 | 1 | 1020.59 | 9 | SO69525 | 2024-08-18 | 81.65 | 1082.51 | 1020.59 | |||
| SO51789_29 | A5AF-4504-83 | PO18618169495 | 100 | 286 | 565 | 13 | 605 | 1 | 150.33 | 2023-11-23 | 1002.17 | 21.30 | 2023-11-11 | 3 | 461.44 | 1 | 851.85 | 29 | SO51789 | 2023-11-18 | 68.15 | 1384.33 | 334.06 | 0.15 |
| SO71836_13 | E41E-40C1-84 | PO841118259 | 100 | 286 | 533 | 254 | 1 | 2024-09-23 | 599.50 | 14.99 | 2024-09-11 | 4 | 136.79 | 1 | 599.50 | 13 | SO71836 | 2024-09-18 | 47.96 | 547.14 | 149.87 | |||
| SO44541_5 | 64BA-409F-A1 | PO2958192556 | 100 | 286 | 345 | 559 | 1 | 2022-02-23 | 8159.98 | 204.00 | 2022-02-11 | 4 | 1912.15 | 1 | 8159.98 | 5 | SO44541 | 2022-02-18 | 652.80 | 7648.62 | 2039.99 | |||
| SO69524_2 | B8BC-4D73-8B | PO5162129421 | 100 | 289 | 378 | 669 | 1 | 2024-08-23 | 1466.01 | 36.65 | 2024-08-11 | 1 | 1554.95 | 1 | 1466.01 | 2 | SO69524 | 2024-08-18 | 117.28 | 1554.95 | 1466.01 | |||
| SO45296_9 | 1FA6-4616-B7 | PO14471199142 | 100 | 286 | 351 | 145 | 1 | 2022-05-26 | 6074.98 | 151.87 | 2022-05-14 | 3 | 1898.09 | 1 | 6074.98 | 9 | SO45296 | 2022-05-21 | 486.00 | 5694.28 | 2024.99 | |||
| SO51830_30 | EBE1-4015-AE | PO7627127132 | 100 | 272 | 240 | 433 | 1 | 2023-11-23 | 2576.70 | 64.42 | 2023-11-11 | 3 | 868.63 | 1 | 2576.70 | 30 | SO51830 | 2023-11-18 | 206.14 | 2605.90 | 858.90 | |||
| SO43860_4 | E57D-4B4B-BF | PO16646146654 | 100 | 286 | 332 | 1 | 1 | 2021-11-23 | 838.92 | 20.97 | 2021-11-11 | 2 | 413.15 | 1 | 838.92 | 4 | SO43860 | 2021-11-18 | 67.11 | 826.29 | 419.46 | |||
| SO44771_25 | A78D-40A1-9E | PO783176074 | 100 | 286 | 262 | 91 | 1 | 2022-03-25 | 551.81 | 13.80 | 2022-03-13 | 3 | 181.49 | 1 | 551.81 | 25 | SO44771 | 2022-03-20 | 44.15 | 544.46 | 183.94 | |||
| SO69521_7 | EAFC-4D00-94 | PO6148143676 | 100 | 289 | 579 | 693 | 1 | 2024-08-23 | 1457.82 | 36.45 | 2024-08-11 | 2 | 755.15 | 1 | 1457.82 | 7 | SO69521 | 2024-08-18 | 116.63 | 1510.30 | 728.91 | |||
| SO49826_2 | 2EBD-4312-9C | PO16588178669 | 100 | 289 | 409 | 146 | 1 | 2023-07-24 | 837.02 | 20.93 | 2023-07-12 | 4 | 185.82 | 1 | 837.02 | 2 | SO49826 | 2023-07-19 | 66.96 | 743.28 | 209.26 |
Generated 2024-11-10 11:29:02.049 UTC