[ROOT] dt FactResellerSale < WHERE DimSalesTerritoryId EQ '4' > SHUFFLE < SKIP 240 > < TAKE 32 >
32 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 |
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
| SO47720_32 | 30D0-4EF0-B1 | PO7859164121 | 100 | 287 | 273 | 221 | 4 | 2023-01-24 | 202.33 | 5.06 | 2023-01-12 | 1 | 187.16 | 1 | 202.33 | 32 | SO47720 | 2023-01-19 | 16.19 | 187.16 | 202.33 | |||
| SO45798_9 | 3FA4-4459-BD | PO10817199969 | 100 | 287 | 285 | 203 | 4 | 2022-07-25 | 178.58 | 4.46 | 2022-07-13 | 1 | 176.20 | 1 | 178.58 | 9 | SO45798 | 2022-07-20 | 14.29 | 176.20 | 178.58 | |||
| SO46049_18 | 2C79-41BD-8A | PO15689114654 | 100 | 283 | 326 | 328 | 4 | 2022-08-24 | 838.92 | 20.97 | 2022-08-12 | 2 | 413.15 | 1 | 838.92 | 18 | SO46049 | 2022-08-19 | 67.11 | 826.29 | 419.46 | |||
| SO46638_8 | 9659-44CE-A2 | PO10817110834 | 100 | 287 | 233 | 203 | 4 | 2022-10-24 | 201.88 | 5.05 | 2022-10-12 | 7 | 29.08 | 1 | 201.88 | 8 | SO46638 | 2022-10-19 | 16.15 | 203.56 | 28.84 | |||
| SO44551_1 | 5A94-49FB-8D | PO5684111258 | 100 | 282 | 220 | 385 | 4 | 2022-02-24 | 80.75 | 2.02 | 2022-02-12 | 4 | 12.03 | 1 | 80.75 | 1 | SO44551 | 2022-02-19 | 6.46 | 48.11 | 20.19 | |||
| SO57145_7 | 4C59-4193-B1 | PO3654153385 | 100 | 281 | 515 | 435 | 4 | 2024-02-24 | 32.54 | 0.81 | 2024-02-12 | 2 | 12.04 | 1 | 32.54 | 7 | SO57145 | 2024-02-19 | 2.60 | 24.08 | 16.27 | |||
| SO61243_12 | 0370-4B1B-9D | PO7859152962 | 100 | 287 | 374 | 221 | 4 | 2024-04-25 | 2932.02 | 73.30 | 2024-04-13 | 2 | 1554.95 | 1 | 2932.02 | 12 | SO61243 | 2024-04-20 | 234.56 | 3109.90 | 1466.01 | |||
| SO47422_47 | 9D8D-4481-B6 | PO3915123127 | 100 | 283 | 368 | 130 | 4 | 2022-12-25 | 5864.04 | 146.60 | 2022-12-13 | 4 | 1518.79 | 1 | 5864.04 | 47 | SO47422 | 2022-12-20 | 469.12 | 6075.15 | 1466.01 | |||
| SO49533_33 | 5895-4BD4-A3 | PO5597155395 | 100 | 281 | 420 | 75 | 4 | 2023-06-24 | 141.62 | 3.54 | 2023-06-12 | 1 | 104.80 | 1 | 141.62 | 33 | SO49533 | 2023-06-19 | 11.33 | 104.80 | 141.62 | |||
| SO46668_33 | 6711-47BE-BF | PO7859142972 | 100 | 287 | 456 | 221 | 4 | 2022-10-24 | 359.95 | 9.00 | 2022-10-12 | 8 | 30.93 | 1 | 359.95 | 33 | SO46668 | 2022-10-19 | 28.80 | 247.47 | 44.99 | |||
| SO45317_1 | 92DD-46A2-8D | PO2523164373 | 100 | 272 | 332 | 167 | 4 | 2022-05-27 | 838.92 | 20.97 | 2022-05-15 | 2 | 413.15 | 1 | 838.92 | 1 | SO45317 | 2022-05-22 | 67.11 | 826.29 | 419.46 | |||
| SO53616_8 | A692-4827-93 | PO6786150961 | 100 | 281 | 231 | 2 | 3 | 4 | 6.96 | 2023-12-25 | 347.93 | 8.52 | 2023-12-13 | 12 | 38.49 | 1 | 340.97 | 8 | SO53616 | 2023-12-20 | 27.28 | 461.91 | 28.99 | 0.02 |
| SO69536_14 | 9646-48B3-9E | PO3654177498 | 100 | 281 | 544 | 435 | 4 | 2024-08-24 | 97.19 | 2.43 | 2024-08-12 | 2 | 35.96 | 1 | 97.19 | 14 | SO69536 | 2024-08-19 | 7.78 | 71.92 | 48.59 | |||
| SO51122_4 | D915-4225-97 | PO551181465 | 100 | 281 | 382 | 4 | 4 | 2023-10-24 | 2689.18 | 67.23 | 2023-10-12 | 4 | 713.08 | 1 | 2689.18 | 4 | SO51122 | 2023-10-19 | 215.13 | 2852.32 | 672.29 | |||
| SO48775_20 | E56E-4C8C-AA | PO10817145980 | 100 | 287 | 456 | 203 | 4 | 2023-04-26 | 44.99 | 1.12 | 2023-04-14 | 1 | 30.93 | 1 | 44.99 | 20 | SO48775 | 2023-04-21 | 3.60 | 30.93 | 44.99 | |||
| SO58909_17 | EBC4-496C-90 | PO19343180161 | 100 | 282 | 484 | 24 | 4 | 2024-03-25 | 9.54 | 0.24 | 2024-03-13 | 2 | 2.97 | 1 | 9.54 | 17 | SO58909 | 2024-03-20 | 0.76 | 5.95 | 4.77 | |||
| SO49486_1 | 7DA8-4E15-AE | PO16124154108 | 100 | 282 | 325 | 649 | 4 | 2023-06-24 | 939.59 | 23.49 | 2023-06-12 | 2 | 486.71 | 1 | 939.59 | 1 | SO49486 | 2023-06-19 | 75.17 | 973.41 | 469.79 | |||
| SO48295_3 | 12F9-466B-B0 | PO19343197973 | 100 | 282 | 373 | 24 | 4 | 2023-03-26 | 6544.69 | 163.62 | 2023-03-14 | 5 | 1320.68 | 1 | 6544.69 | 3 | SO48295 | 2023-03-21 | 523.58 | 6603.42 | 1308.94 | |||
| SO43873_23 | 494C-48D2-BD | PO12499138177 | 100 | 282 | 232 | 78 | 4 | 2021-11-24 | 144.20 | 3.61 | 2021-11-12 | 5 | 31.72 | 1 | 144.20 | 23 | SO43873 | 2021-11-19 | 11.54 | 158.62 | 28.84 | |||
| SO44107_14 | 99CE-4ADA-B1 | PO261177749 | 100 | 283 | 275 | 647 | 4 | 2021-12-25 | 713.80 | 17.84 | 2021-12-13 | 2 | 352.14 | 1 | 713.80 | 14 | SO44107 | 2021-12-20 | 57.10 | 704.28 | 356.90 | |||
| SO46663_19 | 0EA2-42AA-A4 | PO6409112370 | 100 | 283 | 263 | 292 | 4 | 2022-10-24 | 809.33 | 20.23 | 2022-10-12 | 4 | 187.16 | 1 | 809.33 | 19 | SO46663 | 2022-10-19 | 64.75 | 748.63 | 202.33 | |||
| SO71783_8 | 7E03-4B8A-BA | PO19343113609 | 100 | 282 | 231 | 24 | 4 | 2024-09-24 | 179.96 | 4.50 | 2024-09-12 | 6 | 38.49 | 1 | 179.96 | 8 | SO71783 | 2024-09-19 | 14.40 | 230.95 | 29.99 | |||
| SO49851_19 | 14FB-4B97-95 | PO2494142030 | 100 | 281 | 409 | 184 | 4 | 2023-07-25 | 418.51 | 10.46 | 2023-07-13 | 2 | 185.82 | 1 | 418.51 | 19 | SO49851 | 2023-07-20 | 33.48 | 371.64 | 209.26 | |||
| SO67274_8 | EAF2-43E4-AB | PO13659172775 | 100 | 287 | 544 | 437 | 4 | 2024-07-25 | 48.59 | 1.21 | 2024-07-13 | 1 | 35.96 | 1 | 48.59 | 8 | SO67274 | 2024-07-20 | 3.89 | 35.96 | 48.59 | |||
| SO48041_2 | 5338-4283-B9 | PO2320117440 | 100 | 282 | 414 | 529 | 4 | 2023-02-24 | 298.06 | 7.45 | 2023-02-12 | 2 | 110.28 | 1 | 298.06 | 2 | SO48041 | 2023-02-19 | 23.85 | 220.57 | 149.03 | |||
| SO50747_38 | A59F-46DA-BE | PO5597196496 | 100 | 281 | 469 | 75 | 4 | 2023-09-24 | 45.59 | 1.14 | 2023-09-12 | 2 | 15.67 | 1 | 45.59 | 38 | SO50747 | 2023-09-19 | 3.65 | 31.34 | 22.79 | |||
| SO50298_4 | 2A9C-4236-85 | PO4843196377 | 100 | 287 | 422 | 257 | 4 | 2023-08-24 | 67.54 | 1.69 | 2023-08-12 | 1 | 49.98 | 1 | 67.54 | 4 | SO50298 | 2023-08-19 | 5.40 | 49.98 | 67.54 | |||
| SO44092_2 | 6AE1-4759-B9 | PO15167143312 | 100 | 283 | 332 | 273 | 4 | 2021-12-25 | 419.46 | 10.49 | 2021-12-13 | 1 | 413.15 | 1 | 419.46 | 2 | SO44092 | 2021-12-20 | 33.56 | 413.15 | 419.46 | |||
| SO49540_9 | FD60-4F29-B7 | PO6757123714 | 100 | 281 | 428 | 21 | 4 | 2023-06-24 | 209.26 | 5.23 | 2023-06-12 | 1 | 185.82 | 1 | 209.26 | 9 | SO49540 | 2023-06-19 | 16.74 | 185.82 | 209.26 | |||
| SO48363_40 | A9C9-4B7B-9B | PO3915186343 | 100 | 283 | 381 | 130 | 4 | 2023-03-26 | 6002.63 | 150.07 | 2023-03-14 | 10 | 605.65 | 1 | 6002.63 | 40 | SO48363 | 2023-03-21 | 480.21 | 6056.49 | 600.26 | |||
| SO46988_3 | 2D2E-4EC3-AC | PO12499171502 | 100 | 282 | 439 | 78 | 4 | 2022-11-24 | 780.82 | 19.52 | 2022-11-12 | 1 | 722.26 | 1 | 780.82 | 3 | SO46988 | 2022-11-19 | 62.47 | 722.26 | 780.82 | |||
| SO50313_33 | B452-44E9-91 | PO7656143984 | 100 | 282 | 221 | 403 | 4 | 2023-08-24 | 80.75 | 2.02 | 2023-08-12 | 4 | 13.88 | 1 | 80.75 | 33 | SO50313 | 2023-08-19 | 6.46 | 55.51 | 20.19 |
Generated 2024-11-11 05:05:28.711 UTC