[ROOT] dt FactResellerSale WHERE DimSalesTerritoryId EQ '1' > SHUFFLE SKIP 2000 < SKIP 500 > < 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 |
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
| SO51830_49 | EBE1-4015-AE | PO7627127132 | 100 | 272 | 376 | 433 | 1 | 2023-11-22 | 8796.06 | 219.90 | 2023-11-10 | 6 | 1554.95 | 1 | 8796.06 | 49 | SO51830 | 2023-11-17 | 703.68 | 9329.69 | 1466.01 | |||
| SO44570_32 | 4132-4AE3-99 | PO8816195785 | 100 | 289 | 326 | 218 | 1 | 2022-02-22 | 838.92 | 20.97 | 2022-02-10 | 2 | 413.15 | 1 | 838.92 | 32 | SO44570 | 2022-02-17 | 67.11 | 826.29 | 419.46 | |||
| SO44501_10 | 4971-4FC0-A3 | PO16646128920 | 100 | 286 | 317 | 1 | 1 | 2022-02-22 | 1749.59 | 43.74 | 2022-02-10 | 2 | 884.71 | 1 | 1749.59 | 10 | SO44501 | 2022-02-17 | 139.97 | 1769.42 | 874.79 | |||
| SO44511_1 | 4BD6-4CFA-B8 | PO14529113218 | 100 | 286 | 348 | 289 | 1 | 2022-02-22 | 4049.99 | 101.25 | 2022-02-10 | 2 | 1898.09 | 1 | 4049.99 | 1 | SO44511 | 2022-02-17 | 324.00 | 3796.19 | 2024.99 | |||
| SO63157_7 | 9E62-4577-80 | PO14500183845 | 100 | 282 | 524 | 650 | 1 | 2024-05-24 | 1109.01 | 27.73 | 2024-05-12 | 7 | 144.59 | 1 | 1109.01 | 7 | SO63157 | 2024-05-19 | 88.72 | 1012.16 | 158.43 | |||
| SO71932_4 | AC27-4EE0-AE | PO7192157995 | 100 | 289 | 475 | 20 | 1 | 2024-09-22 | 83.99 | 2.10 | 2024-09-10 | 2 | 26.18 | 1 | 83.99 | 4 | SO71932 | 2024-09-17 | 6.72 | 52.35 | 41.99 | |||
| SO46025_4 | ADCD-4F7A-A7 | PO19981184028 | 100 | 286 | 322 | 271 | 1 | 2022-08-22 | 419.46 | 10.49 | 2022-08-10 | 1 | 413.15 | 1 | 419.46 | 4 | SO46025 | 2022-08-17 | 33.56 | 413.15 | 419.46 | |||
| SO47666_25 | 6551-4B29-BF | PO16588184420 | 100 | 289 | 354 | 146 | 1 | 2023-01-22 | 9942.81 | 248.57 | 2023-01-10 | 8 | 1117.86 | 1 | 9942.81 | 25 | SO47666 | 2023-01-17 | 795.43 | 8942.85 | 1242.85 | |||
| SO46647_28 | FA5F-4878-9F | PO2552157860 | 100 | 286 | 367 | 506 | 1 | 2022-10-22 | 3887.96 | 97.20 | 2022-10-10 | 6 | 598.44 | 1 | 3887.96 | 28 | SO46647 | 2022-10-17 | 311.04 | 3590.61 | 647.99 | |||
| SO50693_20 | 0DA5-4EE4-93 | PO841149385 | 100 | 286 | 466 | 254 | 1 | 2023-09-22 | 98.90 | 2.47 | 2023-09-10 | 7 | 9.71 | 1 | 98.90 | 20 | SO50693 | 2023-09-17 | 7.91 | 68.00 | 14.13 | |||
| SO51723_5 | 4D27-4A2E-A7 | PO14529141662 | 100 | 293 | 544 | 289 | 1 | 2023-11-22 | 48.59 | 1.21 | 2023-11-10 | 1 | 35.96 | 1 | 48.59 | 5 | SO51723 | 2023-11-17 | 3.89 | 35.96 | 48.59 | |||
| SO46348_12 | CF4C-437D-97 | PO13543132672 | 100 | 287 | 220 | 293 | 1 | 2022-09-22 | 60.56 | 1.51 | 2022-09-10 | 3 | 12.03 | 1 | 60.56 | 12 | SO46348 | 2022-09-17 | 4.84 | 36.08 | 20.19 | |||
| SO51789_23 | A5AF-4504-83 | PO18618169495 | 100 | 286 | 579 | 605 | 1 | 2023-11-22 | 5831.28 | 145.78 | 2023-11-10 | 8 | 755.15 | 1 | 5831.28 | 23 | SO51789 | 2023-11-17 | 466.50 | 6041.21 | 728.91 | |||
| SO51711_36 | 5CB8-480D-A1 | PO16414129790 | 100 | 289 | 533 | 236 | 1 | 2023-11-22 | 449.62 | 11.24 | 2023-11-10 | 3 | 136.79 | 1 | 449.62 | 36 | SO51711 | 2023-11-17 | 35.97 | 410.36 | 149.87 | |||
| SO57036_4 | A71E-4FC0-8D | PO15631137127 | 100 | 282 | 511 | 43 | 1 | 2024-02-22 | 436.91 | 10.92 | 2024-02-10 | 2 | 199.38 | 1 | 436.91 | 4 | SO57036 | 2024-02-17 | 34.95 | 398.75 | 218.45 | |||
| SO50209_5 | D138-4E7C-86 | PO15573136083 | 100 | 293 | 454 | 487 | 1 | 2023-08-22 | 287.95 | 7.20 | 2023-08-10 | 8 | 24.75 | 1 | 287.95 | 5 | SO50209 | 2023-08-17 | 23.04 | 197.97 | 35.99 | |||
| SO43911_4 | EB9C-47A4-AC | PO7627190040 | 100 | 286 | 315 | 433 | 1 | 2021-11-22 | 2624.38 | 65.61 | 2021-11-10 | 3 | 884.71 | 1 | 2624.38 | 4 | SO43911 | 2021-11-17 | 209.95 | 2654.12 | 874.79 | |||
| SO58946_20 | F9DD-426F-9A | PO12470155874 | 100 | 287 | 562 | 672 | 1 | 2024-03-23 | 2860.88 | 71.52 | 2024-03-11 | 2 | 1481.94 | 1 | 2860.88 | 20 | SO58946 | 2024-03-18 | 228.87 | 2963.88 | 1430.44 | |||
| SO71893_17 | 9AE1-416A-8F | PO7482196160 | 100 | 293 | 493 | 163 | 1 | 2024-09-22 | 200.05 | 5.00 | 2024-09-10 | 1 | 199.85 | 1 | 200.05 | 17 | SO71893 | 2024-09-17 | 16.00 | 199.85 | 200.05 | |||
| SO50218_3 | B8E9-4FE2-8B | PO14442144367 | 100 | 293 | 224 | 127 | 1 | 2023-08-22 | 51.87 | 1.30 | 2023-08-10 | 10 | 5.23 | 1 | 51.87 | 3 | SO50218 | 2023-08-17 | 4.15 | 52.30 | 5.19 | |||
| SO48057_8 | 53D7-4BA4-AB | PO4727174880 | 100 | 293 | 368 | 343 | 1 | 2023-02-22 | 7330.05 | 183.25 | 2023-02-10 | 5 | 1518.79 | 1 | 7330.05 | 8 | SO48057 | 2023-02-17 | 586.40 | 7593.93 | 1466.01 | |||
| SO47387_13 | 4FFC-4663-AC | PO13543169662 | 100 | 287 | 393 | 293 | 1 | 2022-12-23 | 550.78 | 13.77 | 2022-12-11 | 4 | 101.89 | 1 | 550.78 | 13 | SO47387 | 2022-12-18 | 44.06 | 407.57 | 137.69 | |||
| SO69552_5 | 542B-4AC0-BA | PO7917166419 | 100 | 287 | 476 | 401 | 1 | 2024-08-22 | 167.98 | 4.20 | 2024-08-10 | 4 | 26.18 | 1 | 167.98 | 5 | SO69552 | 2024-08-17 | 13.44 | 104.71 | 41.99 | |||
| SO46348_17 | CF4C-437D-97 | PO13543132672 | 100 | 287 | 344 | 7 | 293 | 1 | 595.00 | 2022-09-22 | 1700.00 | 27.62 | 2022-09-10 | 2 | 1912.15 | 1 | 1105.00 | 17 | SO46348 | 2022-09-17 | 88.40 | 3824.31 | 850.00 | 0.35 |
| SO47986_19 | 3373-4C22-A9 | PO16414116972 | 100 | 289 | 396 | 236 | 1 | 2023-02-22 | 149.68 | 3.74 | 2023-02-10 | 2 | 55.38 | 1 | 149.68 | 19 | SO47986 | 2023-02-17 | 11.97 | 110.76 | 74.84 | |||
| SO44563_13 | 9AFF-40A9-96 | PO7627161014 | 100 | 286 | 212 | 433 | 1 | 2022-02-22 | 20.19 | 0.50 | 2022-02-10 | 1 | 12.03 | 1 | 20.19 | 13 | SO44563 | 2022-02-17 | 1.61 | 12.03 | 20.19 | |||
| SO46100_14 | 58B8-4157-97 | PO7627134166 | 100 | 286 | 232 | 433 | 1 | 2022-08-22 | 28.84 | 0.72 | 2022-08-10 | 1 | 31.72 | 1 | 28.84 | 14 | SO46100 | 2022-08-17 | 2.31 | 31.72 | 28.84 | |||
| SO45318_12 | 13CE-461F-B9 | PO2900174093 | 100 | 286 | 223 | 469 | 1 | 2022-05-25 | 5.19 | 0.13 | 2022-05-13 | 1 | 5.71 | 1 | 5.19 | 12 | SO45318 | 2022-05-20 | 0.41 | 5.71 | 5.19 | |||
| SO53578_4 | 55BE-495E-B7 | PO7946144630 | 100 | 282 | 547 | 438 | 1 | 2023-12-23 | 291.56 | 7.29 | 2023-12-11 | 6 | 35.96 | 1 | 291.56 | 4 | SO53578 | 2023-12-18 | 23.33 | 215.76 | 48.59 | |||
| SO44523_7 | BE2B-4DB0-8E | PO11919191573 | 100 | 286 | 346 | 73 | 1 | 2022-02-22 | 8159.98 | 204.00 | 2022-02-10 | 4 | 1912.15 | 1 | 8159.98 | 7 | SO44523 | 2022-02-17 | 652.80 | 7648.62 | 2039.99 |
Generated 2024-11-10 03:02:36.006 UTC