[ROOT] dt FactResellerSale WHERE DimSalesTerritoryId EQ '1' > SHUFFLE SKIP 2000 < SKIP 562 > < 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 |
---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
SO49849_29 | C8F3-4DDE-A6 | PO2552190786 | 100 | 286 | 213 | 506 | 1 | 2023-07-24 | 100.93 | 2.52 | 2023-07-12 | 5 | 13.88 | 1 | 100.93 | 29 | SO49849 | 2023-07-19 | 8.07 | 69.39 | 20.19 | |||
SO53457_12 | B3F3-4A07-9B | PO19169151555 | 100 | 289 | 306 | 272 | 1 | 2023-12-24 | 809.76 | 20.24 | 2023-12-12 | 1 | 739.04 | 1 | 809.76 | 12 | SO53457 | 2023-12-19 | 64.78 | 739.04 | 809.76 | |||
SO69413_11 | E8F8-4282-9E | PO15631191114 | 100 | 282 | 594 | 16 | 43 | 1 | 90.40 | 2024-08-23 | 226.00 | 3.39 | 2024-08-11 | 2 | 308.22 | 1 | 135.60 | 11 | SO69413 | 2024-08-18 | 10.85 | 616.44 | 113.00 | 0.40 |
SO46051_6 | DF61-462A-87 | PO14500186228 | 100 | 282 | 346 | 650 | 1 | 2022-08-23 | 4079.99 | 102.00 | 2022-08-11 | 2 | 1912.15 | 1 | 4079.99 | 6 | SO46051 | 2022-08-18 | 326.40 | 3824.31 | 2039.99 | |||
SO47992_39 | 3F55-4354-BD | PO15573158216 | 100 | 293 | 360 | 487 | 1 | 2023-02-23 | 9835.67 | 245.89 | 2023-02-11 | 8 | 1105.81 | 1 | 9835.67 | 39 | SO47992 | 2023-02-18 | 786.85 | 8846.48 | 1229.46 | |||
SO65312_4 | 19D1-4059-B8 | PO6815121334 | 100 | 293 | 588 | 109 | 1 | 2024-06-23 | 923.39 | 23.08 | 2024-06-11 | 2 | 419.78 | 1 | 923.39 | 4 | SO65312 | 2024-06-18 | 73.87 | 839.56 | 461.69 | |||
SO65312_9 | 19D1-4059-B8 | PO6815121334 | 100 | 293 | 598 | 109 | 1 | 2024-06-23 | 323.99 | 8.10 | 2024-06-11 | 1 | 294.58 | 1 | 323.99 | 9 | SO65312 | 2024-06-18 | 25.92 | 294.58 | 323.99 | |||
SO45338_14 | EA29-4912-A1 | PO7627114520 | 100 | 286 | 328 | 433 | 1 | 2022-05-26 | 419.46 | 10.49 | 2022-05-14 | 1 | 413.15 | 1 | 419.46 | 14 | SO45338 | 2022-05-21 | 33.56 | 413.15 | 419.46 | |||
SO48079_13 | A42B-43D5-B0 | PO7627191699 | 100 | 293 | 389 | 433 | 1 | 2023-02-23 | 600.26 | 15.01 | 2023-02-11 | 1 | 605.65 | 1 | 600.26 | 13 | SO48079 | 2023-02-18 | 48.02 | 605.65 | 600.26 | |||
SO46105_18 | 2590-40A7-BB | PO8816169858 | 100 | 289 | 332 | 218 | 1 | 2022-08-23 | 419.46 | 10.49 | 2022-08-11 | 1 | 413.15 | 1 | 419.46 | 18 | SO46105 | 2022-08-18 | 33.56 | 413.15 | 419.46 | |||
SO58946_25 | F9DD-426F-9A | PO12470155874 | 100 | 287 | 586 | 672 | 1 | 2024-03-24 | 890.82 | 22.27 | 2024-03-12 | 2 | 461.44 | 1 | 890.82 | 25 | SO58946 | 2024-03-19 | 71.27 | 922.89 | 445.41 | |||
SO45783_2 | AD5D-4FF2-82 | PO16617161291 | 100 | 286 | 235 | 397 | 1 | 2022-07-24 | 28.84 | 0.72 | 2022-07-12 | 1 | 31.72 | 1 | 28.84 | 2 | SO45783 | 2022-07-19 | 2.31 | 31.72 | 28.84 | |||
SO50693_33 | 0DA5-4EE4-93 | PO841149385 | 100 | 286 | 454 | 254 | 1 | 2023-09-23 | 35.99 | 0.90 | 2023-09-11 | 1 | 24.75 | 1 | 35.99 | 33 | SO50693 | 2023-09-18 | 2.88 | 24.75 | 35.99 | |||
SO58910_25 | A209-4ADD-98 | PO19169152738 | 100 | 289 | 555 | 272 | 1 | 2024-03-24 | 191.70 | 4.79 | 2024-03-12 | 3 | 47.29 | 1 | 191.70 | 25 | SO58910 | 2024-03-19 | 15.34 | 141.86 | 63.90 | |||
SO71893_16 | 9AE1-416A-8F | PO7482196160 | 100 | 293 | 496 | 163 | 1 | 2024-09-23 | 1204.69 | 30.12 | 2024-09-11 | 2 | 601.74 | 1 | 1204.69 | 16 | SO71893 | 2024-09-18 | 96.38 | 1203.49 | 602.35 | |||
SO69406_22 | E101-486C-A5 | PO16675181672 | 100 | 293 | 558 | 361 | 1 | 2024-08-23 | 242.99 | 6.07 | 2024-08-11 | 1 | 179.82 | 1 | 242.99 | 22 | SO69406 | 2024-08-18 | 19.44 | 179.82 | 242.99 | |||
SO43849_9 | D0B8-4476-BA | PO18676186169 | 100 | 272 | 212 | 697 | 1 | 2021-11-23 | 20.19 | 0.50 | 2021-11-11 | 1 | 12.03 | 1 | 20.19 | 9 | SO43849 | 2021-11-18 | 1.61 | 12.03 | 20.19 | |||
SO50206_15 | 7656-4E84-B8 | PO16414158832 | 100 | 289 | 461 | 236 | 1 | 2023-08-23 | 215.98 | 5.40 | 2023-08-11 | 4 | 37.12 | 1 | 215.98 | 15 | SO50206 | 2023-08-18 | 17.28 | 148.48 | 53.99 | |||
SO55269_33 | C087-4A55-8D | PO899192335 | 100 | 289 | 467 | 290 | 1 | 2024-01-23 | 102.86 | 2.57 | 2024-01-11 | 7 | 9.16 | 1 | 102.86 | 33 | SO55269 | 2024-01-18 | 8.23 | 64.12 | 14.69 | |||
SO63202_14 | 5C83-47EE-AA | PO15631193825 | 100 | 282 | 511 | 43 | 1 | 2024-05-25 | 436.91 | 10.92 | 2024-05-13 | 2 | 199.38 | 1 | 436.91 | 14 | SO63202 | 2024-05-20 | 34.95 | 398.75 | 218.45 | |||
SO51830_22 | EBE1-4015-AE | PO7627127132 | 100 | 272 | 582 | 433 | 1 | 2023-11-23 | 8164.75 | 204.12 | 2023-11-11 | 8 | 1082.51 | 1 | 8164.75 | 22 | SO51830 | 2023-11-18 | 653.18 | 8660.08 | 1020.59 | |||
SO50314_28 | 5D9A-4B55-81 | PO7627146177 | 100 | 293 | 383 | 433 | 1 | 2023-08-23 | 3001.31 | 75.03 | 2023-08-11 | 5 | 605.65 | 1 | 3001.31 | 28 | SO50314 | 2023-08-18 | 240.11 | 3028.25 | 600.26 | |||
SO67321_10 | 7F43-4E4F-8E | PO7076150186 | 100 | 293 | 569 | 505 | 1 | 2024-07-24 | 890.82 | 22.27 | 2024-07-12 | 2 | 461.44 | 1 | 890.82 | 10 | SO67321 | 2024-07-19 | 71.27 | 922.89 | 445.41 | |||
SO53605_28 | 6D2A-486B-AC | PO5017132122 | 100 | 289 | 553 | 308 | 1 | 2023-12-24 | 55.31 | 1.38 | 2023-12-12 | 2 | 20.46 | 1 | 55.31 | 28 | SO53605 | 2023-12-19 | 4.42 | 40.93 | 27.65 | |||
SO46974_27 | BEE6-4EC8-8E | PO14442112586 | 100 | 286 | 428 | 127 | 1 | 2022-11-23 | 418.51 | 10.46 | 2022-11-11 | 2 | 185.82 | 1 | 418.51 | 27 | SO46974 | 2022-11-18 | 33.48 | 371.64 | 209.26 | |||
SO47999_7 | DF06-4F6A-9D | PO14500121568 | 100 | 282 | 308 | 650 | 1 | 2023-02-23 | 744.27 | 18.61 | 2023-02-11 | 1 | 660.91 | 1 | 744.27 | 7 | SO47999 | 2023-02-18 | 59.54 | 660.91 | 744.27 | |||
SO71812_5 | 3257-4AE0-A8 | PO13543115747 | 100 | 287 | 306 | 293 | 1 | 2024-09-23 | 809.76 | 20.24 | 2024-09-11 | 1 | 739.04 | 1 | 809.76 | 5 | SO71812 | 2024-09-18 | 64.78 | 739.04 | 809.76 | |||
SO71833_9 | 8525-4645-AB | PO10411123072 | 100 | 289 | 565 | 182 | 1 | 2024-09-23 | 1781.64 | 44.54 | 2024-09-11 | 4 | 461.44 | 1 | 1781.64 | 9 | SO71833 | 2024-09-18 | 142.53 | 1845.78 | 445.41 | |||
SO50206_8 | 7656-4E84-B8 | PO16414158832 | 100 | 289 | 352 | 236 | 1 | 2023-08-23 | 7457.11 | 186.43 | 2023-08-11 | 6 | 1117.86 | 1 | 7457.11 | 8 | SO50206 | 2023-08-18 | 596.57 | 6707.14 | 1242.85 | |||
SO59050_1 | 0C0C-4810-A6 | PO3277119270 | 100 | 293 | 580 | 604 | 1 | 2024-03-24 | 2041.19 | 51.03 | 2024-03-12 | 2 | 1082.51 | 1 | 2041.19 | 1 | SO59050 | 2024-03-19 | 163.30 | 2165.02 | 1020.59 |
Generated 2024-11-10 05:11:56.062 UTC