[ROOT] dt FactResellerSale WHERE DimSalesTerritoryId EQ '1' > SHUFFLE < SKIP 257 > < TAKE 28 >
28 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 |
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
| SO50206_1 | 7656-4E84-B8 | PO16414158832 | 100 | 289 | 294 | 236 | 1 | 2023-08-23 | 3721.36 | 93.03 | 2023-08-11 | 5 | 660.91 | 1 | 3721.36 | 1 | SO50206 | 2023-08-18 | 297.71 | 3304.57 | 744.27 | |||
| SO71943_2 | E676-4002-A7 | PO9309168525 | 100 | 293 | 576 | 55 | 1 | 2024-09-23 | 5721.77 | 143.04 | 2024-09-11 | 4 | 1481.94 | 1 | 5721.77 | 2 | SO71943 | 2024-09-18 | 457.74 | 5927.75 | 1430.44 | |||
| 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 | |||
| SO48087_16 | 2285-4C77-9B | PO8816162044 | 100 | 289 | 370 | 218 | 1 | 2023-02-23 | 4398.03 | 109.95 | 2023-02-11 | 3 | 1518.79 | 1 | 4398.03 | 16 | SO48087 | 2023-02-18 | 351.84 | 4556.36 | 1466.01 | |||
| SO57111_4 | 8478-4B8E-95 | PO14181151887 | 100 | 272 | 476 | 307 | 1 | 2024-02-23 | 83.99 | 2.10 | 2024-02-11 | 2 | 26.18 | 1 | 83.99 | 4 | SO57111 | 2024-02-18 | 6.72 | 52.35 | 41.99 | |||
| SO58963_23 | 6ADC-4485-8C | PO841129336 | 100 | 286 | 552 | 254 | 1 | 2024-03-24 | 274.47 | 6.86 | 2024-03-12 | 5 | 40.62 | 1 | 274.47 | 23 | SO58963 | 2024-03-19 | 21.96 | 203.11 | 54.89 | |||
| SO53500_21 | BEF0-4525-AF | PO12470126979 | 100 | 287 | 507 | 672 | 1 | 2023-12-24 | 400.10 | 10.00 | 2023-12-12 | 2 | 199.85 | 1 | 400.10 | 21 | SO53500 | 2023-12-19 | 32.01 | 399.70 | 200.05 | |||
| SO58963_21 | 6ADC-4485-8C | PO841129336 | 100 | 286 | 543 | 254 | 1 | 2024-03-24 | 37.25 | 0.93 | 2024-03-12 | 1 | 27.57 | 1 | 37.25 | 21 | SO58963 | 2024-03-19 | 2.98 | 27.57 | 37.25 | |||
| SO71835_18 | EBBF-4B16-99 | PO870120974 | 100 | 286 | 560 | 621 | 1 | 2024-09-23 | 2915.64 | 72.89 | 2024-09-11 | 4 | 755.15 | 1 | 2915.64 | 18 | SO71835 | 2024-09-18 | 233.25 | 3020.60 | 728.91 | |||
| SO63133_5 | C3D9-4B73-83 | PO18618146912 | 100 | 286 | 496 | 605 | 1 | 2024-05-25 | 602.35 | 15.06 | 2024-05-13 | 1 | 601.74 | 1 | 602.35 | 5 | SO63133 | 2024-05-20 | 48.19 | 601.74 | 602.35 | |||
| SO48310_5 | B389-4D7D-85 | PO17139173607 | 100 | 293 | 466 | 644 | 1 | 2023-03-25 | 14.13 | 0.35 | 2023-03-13 | 1 | 9.71 | 1 | 14.13 | 5 | SO48310 | 2023-03-20 | 1.13 | 9.71 | 14.13 | |||
| SO57105_11 | 3AE1-4A72-91 | PO18676113963 | 100 | 282 | 353 | 2 | 697 | 1 | 349.85 | 2024-02-23 | 17492.72 | 428.57 | 2024-02-11 | 13 | 1265.62 | 1 | 17142.87 | 11 | SO57105 | 2024-02-18 | 1371.43 | 16453.05 | 1345.59 | 0.02 |
| SO48057_24 | 53D7-4BA4-AB | PO4727174880 | 100 | 293 | 373 | 343 | 1 | 2023-02-23 | 3926.81 | 98.17 | 2023-02-11 | 3 | 1320.68 | 1 | 3926.81 | 24 | SO48057 | 2023-02-18 | 314.15 | 3962.05 | 1308.94 | |||
| SO44121_11 | FE2E-4885-B3 | PO5220129819 | 100 | 282 | 349 | 169 | 1 | 2021-12-24 | 4049.99 | 101.25 | 2021-12-12 | 2 | 1898.09 | 1 | 4049.99 | 11 | SO44121 | 2021-12-19 | 324.00 | 3796.19 | 2024.99 | |||
| SO45570_1 | 530C-4FAB-9A | PO7192194940 | 100 | 289 | 349 | 20 | 1 | 2022-06-23 | 10124.97 | 253.12 | 2022-06-11 | 5 | 1898.09 | 1 | 10124.97 | 1 | SO45570 | 2022-06-18 | 810.00 | 9490.47 | 2024.99 | |||
| SO51145_1 | BBD2-4A22-8C | PO7105118870 | 100 | 293 | 481 | 668 | 1 | 2023-10-23 | 43.15 | 1.08 | 2023-10-11 | 8 | 3.36 | 1 | 43.15 | 1 | SO51145 | 2023-10-18 | 3.45 | 26.90 | 5.39 | |||
| SO47666_21 | 6551-4B29-BF | PO16588184420 | 100 | 289 | 460 | 146 | 1 | 2023-01-23 | 161.98 | 4.05 | 2023-01-11 | 3 | 37.12 | 1 | 161.98 | 21 | SO47666 | 2023-01-18 | 12.96 | 111.36 | 53.99 | |||
| SO47986_19 | 3373-4C22-A9 | PO16414116972 | 100 | 289 | 396 | 236 | 1 | 2023-02-23 | 149.68 | 3.74 | 2023-02-11 | 2 | 55.38 | 1 | 149.68 | 19 | SO47986 | 2023-02-18 | 11.97 | 110.76 | 74.84 | |||
| SO63133_27 | C3D9-4B73-83 | PO18618146912 | 100 | 286 | 577 | 605 | 1 | 2024-05-25 | 1457.82 | 36.45 | 2024-05-13 | 2 | 755.15 | 1 | 1457.82 | 27 | SO63133 | 2024-05-20 | 116.63 | 1510.30 | 728.91 | |||
| SO67322_2 | 1881-4634-82 | PO6612121393 | 100 | 286 | 496 | 110 | 1 | 2024-07-24 | 602.35 | 15.06 | 2024-07-12 | 1 | 601.74 | 1 | 602.35 | 2 | SO67322 | 2024-07-19 | 48.19 | 601.74 | 602.35 | |||
| SO48083_7 | E4B1-4D02-90 | PO7917164304 | 100 | 287 | 233 | 401 | 1 | 2023-02-23 | 144.20 | 3.61 | 2023-02-11 | 5 | 29.08 | 1 | 144.20 | 7 | SO48083 | 2023-02-18 | 11.54 | 145.40 | 28.84 | |||
| SO59010_29 | 2350-42CD-B1 | PO6815132533 | 100 | 293 | 298 | 109 | 1 | 2024-03-24 | 809.76 | 20.24 | 2024-03-12 | 1 | 739.04 | 1 | 809.76 | 29 | SO59010 | 2024-03-19 | 64.78 | 739.04 | 809.76 | |||
| SO45782_16 | D609-4F2A-9B | PO16588186502 | 100 | 289 | 345 | 146 | 1 | 2022-07-24 | 8159.98 | 204.00 | 2022-07-12 | 4 | 1912.15 | 1 | 8159.98 | 16 | SO45782 | 2022-07-19 | 652.80 | 7648.62 | 2039.99 | |||
| SO47694_1 | 8253-4E13-9D | PO899122764 | 100 | 289 | 333 | 2 | 290 | 1 | 108.99 | 2023-01-23 | 5449.61 | 133.52 | 2023-01-11 | 12 | 486.71 | 1 | 5340.62 | 1 | SO47694 | 2023-01-18 | 427.25 | 5840.48 | 454.13 | 0.02 |
| SO59010_45 | 2350-42CD-B1 | PO6815132533 | 100 | 293 | 471 | 2 | 109 | 1 | 8.10 | 2024-03-24 | 405.13 | 9.93 | 2024-03-12 | 11 | 23.75 | 1 | 397.03 | 45 | SO59010 | 2024-03-19 | 31.76 | 261.24 | 36.83 | 0.02 |
| SO69552_2 | 542B-4AC0-BA | PO7917166419 | 100 | 287 | 359 | 401 | 1 | 2024-08-23 | 4130.98 | 103.27 | 2024-08-11 | 3 | 1251.98 | 1 | 4130.98 | 2 | SO69552 | 2024-08-18 | 330.48 | 3755.94 | 1376.99 | |||
| SO48347_29 | 40D2-4DF5-93 | PO841112057 | 100 | 286 | 469 | 254 | 1 | 2023-03-25 | 45.59 | 1.14 | 2023-03-13 | 2 | 15.67 | 1 | 45.59 | 29 | SO48347 | 2023-03-20 | 3.65 | 31.34 | 22.79 | |||
| SO47998_5 | 3E7A-47BA-B0 | PO14529157781 | 100 | 293 | 358 | 289 | 1 | 2023-02-23 | 3688.38 | 92.21 | 2023-02-11 | 3 | 1105.81 | 1 | 3688.38 | 5 | SO47998 | 2023-02-18 | 295.07 | 3317.43 | 1229.46 |
Generated 2024-11-10 13:29:11.589 UTC