[ROOT] dt FactResellerSale < WHERE DimProductId EQ ALL SHUFFLE SKIP 2000 SKIP 0 > < TAKE 56 >
56 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 |
---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
SO51821_3 | 1CCD-45D4-80 | PO7917148134 | 100 | 287 | 217 | 401 | 1 | 2023-10-03 | 20.99 | 0.52 | 2023-09-21 | 1 | 13.09 | 1 | 20.99 | 3 | SO51821 | 2023-09-28 | 1.68 | 13.09 | 20.99 | |||
SO51751_10 | 257C-4EC8-98 | PO11368156185 | 36 | 295 | 552 | 687 | 8 | 2023-10-03 | 548.94 | 13.72 | 2023-09-21 | 10 | 40.62 | 1 | 548.94 | 10 | SO51751 | 2023-09-28 | 43.92 | 406.22 | 54.89 | |||
SO69560_19 | B1B6-43F4-BC | PO9077167302 | 19 | 291 | 600 | 100 | 6 | 2024-07-03 | 647.99 | 16.20 | 2024-06-21 | 2 | 294.58 | 1 | 647.99 | 19 | SO69560 | 2024-06-28 | 51.84 | 589.16 | 323.99 | |||
SO50679_2 | 1B68-4DF6-B9 | PO13050137706 | 98 | 288 | 286 | 160 | 10 | 2023-08-03 | 183.94 | 4.60 | 2023-07-22 | 1 | 170.14 | 1 | 183.94 | 2 | SO50679 | 2023-07-29 | 14.72 | 170.14 | 183.94 | |||
SO45329_8 | CFFE-4184-BD | PO5858128971 | 100 | 285 | 346 | 566 | 5 | 2022-04-05 | 4079.99 | 102.00 | 2022-03-24 | 2 | 1912.15 | 1 | 4079.99 | 8 | SO45329 | 2022-03-31 | 326.40 | 3824.31 | 2039.99 | |||
SO49140_11 | EFF3-483D-BE | PO4901154744 | 19 | 284 | 458 | 84 | 6 | 2023-04-05 | 224.97 | 5.62 | 2023-03-24 | 5 | 30.93 | 1 | 224.97 | 11 | SO49140 | 2023-03-31 | 18.00 | 154.67 | 44.99 | |||
SO67278_42 | 22C9-42E1-BC | PO12441152483 | 36 | 295 | 231 | 302 | 8 | 2024-06-03 | 149.97 | 3.75 | 2024-05-22 | 5 | 38.49 | 1 | 149.97 | 42 | SO67278 | 2024-05-29 | 12.00 | 192.46 | 29.99 | |||
SO45317_12 | 92DD-46A2-8D | PO2523164373 | 100 | 272 | 223 | 167 | 4 | 2022-04-05 | 20.75 | 0.52 | 2022-03-24 | 4 | 5.71 | 1 | 20.75 | 12 | SO45317 | 2022-03-31 | 1.66 | 22.82 | 5.19 | |||
SO50276_1 | BB3F-4E95-B8 | PO9512139148 | 100 | 285 | 458 | 135 | 5 | 2023-07-03 | 269.96 | 6.75 | 2023-06-21 | 6 | 30.93 | 1 | 269.96 | 1 | SO50276 | 2023-06-28 | 21.60 | 185.60 | 44.99 | |||
SO51112_1 | 6C36-4086-8D | PO11687117332 | 100 | 283 | 563 | 14 | 691 | 2 | 190.73 | 2023-09-02 | 953.63 | 19.07 | 2023-08-21 | 1 | 1481.94 | 1 | 762.90 | 1 | SO51112 | 2023-08-28 | 61.03 | 1481.94 | 953.63 | 0.20 |
SO49831_45 | 8BCC-466B-AB | PO13688123267 | 100 | 282 | 221 | 475 | 4 | 2023-06-03 | 80.75 | 2.02 | 2023-05-22 | 4 | 13.88 | 1 | 80.75 | 45 | SO49831 | 2023-05-29 | 6.46 | 55.51 | 20.19 | |||
SO49479_8 | 12BA-4BD1-BB | PO11455112131 | 100 | 283 | 213 | 72 | 2 | 2023-05-03 | 60.56 | 1.51 | 2023-04-21 | 3 | 13.88 | 1 | 60.56 | 8 | SO49479 | 2023-04-28 | 4.84 | 41.63 | 20.19 | |||
SO46633_34 | D8C9-4AB8-A4 | PO11484122930 | 100 | 281 | 419 | 594 | 2 | 2022-09-02 | 368.53 | 9.21 | 2022-08-21 | 7 | 38.96 | 1 | 368.53 | 34 | SO46633 | 2022-08-28 | 29.48 | 272.71 | 52.65 | |||
SO67324_25 | E926-43C1-A2 | PO5452147202 | 36 | 295 | 480 | 320 | 8 | 2024-06-03 | 2.75 | 0.07 | 2024-05-22 | 2 | 0.86 | 1 | 2.75 | 25 | SO67324 | 2024-05-29 | 0.22 | 1.71 | 1.37 | |||
SO61247_1 | 813A-4977-AD | PO6409149613 | 100 | 281 | 605 | 292 | 4 | 2024-03-04 | 647.99 | 16.20 | 2024-02-21 | 2 | 343.65 | 1 | 647.99 | 1 | SO61247 | 2024-02-28 | 51.84 | 687.30 | 323.99 | |||
SO50727_9 | 5DD5-4A9A-B1 | PO9483181443 | 100 | 283 | 466 | 54 | 2 | 2023-08-03 | 14.13 | 0.35 | 2023-07-22 | 1 | 9.71 | 1 | 14.13 | 9 | SO50727 | 2023-07-29 | 1.13 | 9.71 | 14.13 | |||
SO71871_6 | DD8F-4CAB-A1 | PO14239120760 | 19 | 291 | 483 | 550 | 6 | 2024-08-03 | 144.00 | 3.60 | 2024-07-22 | 2 | 44.88 | 1 | 144.00 | 6 | SO71871 | 2024-07-29 | 11.52 | 89.76 | 72.00 | |||
SO69531_7 | 1871-4E54-BE | PO3683141039 | 100 | 292 | 564 | 85 | 7 | 2024-07-03 | 4291.33 | 107.28 | 2024-06-21 | 3 | 1481.94 | 1 | 4291.33 | 7 | SO69531 | 2024-06-28 | 343.31 | 4445.81 | 1430.44 | |||
SO46996_37 | 775B-42D6-A5 | PO11571149031 | 100 | 285 | 265 | 512 | 5 | 2022-10-03 | 202.33 | 5.06 | 2022-09-21 | 1 | 187.16 | 1 | 202.33 | 37 | SO46996 | 2022-09-28 | 16.19 | 187.16 | 202.33 | |||
SO53465_54 | D859-4DF3-84 | PO17574192592 | 19 | 272 | 516 | 678 | 6 | 2023-11-03 | 234.84 | 5.87 | 2023-10-22 | 10 | 17.38 | 1 | 234.84 | 54 | SO53465 | 2023-10-29 | 18.79 | 173.78 | 23.48 | |||
SO53614_17 | A1C5-4C4D-9C | PO6757196330 | 100 | 281 | 531 | 21 | 4 | 2023-11-03 | 149.87 | 3.75 | 2023-10-22 | 1 | 136.79 | 1 | 149.87 | 17 | SO53614 | 2023-10-29 | 11.99 | 136.79 | 149.87 | |||
SO71882_5 | D5D4-42D4-91 | PO5597123008 | 100 | 281 | 306 | 75 | 4 | 2024-08-03 | 2429.28 | 60.73 | 2024-07-22 | 3 | 739.04 | 1 | 2429.28 | 5 | SO71882 | 2024-07-29 | 194.34 | 2217.12 | 809.76 | |||
SO48306_15 | EA27-471A-9D | PO17574166075 | 19 | 291 | 457 | 678 | 6 | 2023-02-02 | 179.98 | 4.50 | 2023-01-21 | 4 | 30.93 | 1 | 179.98 | 15 | SO48306 | 2023-01-28 | 14.40 | 123.73 | 44.99 | |||
SO46094_5 | 6C13-4966-95 | PO6438128598 | 100 | 283 | 344 | 309 | 4 | 2022-07-03 | 12239.96 | 306.00 | 2022-06-21 | 6 | 1912.15 | 1 | 12239.96 | 5 | SO46094 | 2022-06-28 | 979.20 | 11472.93 | 2039.99 | |||
SO71936_45 | 95F1-4758-A0 | PO8671170385 | 98 | 288 | 543 | 502 | 10 | 2024-08-03 | 74.51 | 1.86 | 2024-07-22 | 2 | 27.57 | 1 | 74.51 | 45 | SO71936 | 2024-07-29 | 5.96 | 55.14 | 37.25 | |||
SO47041_4 | C543-4932-83 | PO5771188676 | 100 | 282 | 337 | 79 | 3 | 2022-10-03 | 1879.18 | 46.98 | 2022-09-21 | 4 | 486.71 | 1 | 1879.18 | 4 | SO47041 | 2022-09-28 | 150.33 | 1946.83 | 469.79 | |||
SO67287_31 | 3F1F-44DB-96 | PO10730119334 | 100 | 287 | 484 | 491 | 4 | 2024-06-03 | 4.77 | 0.12 | 2024-05-22 | 1 | 2.97 | 1 | 4.77 | 31 | SO67287 | 2024-05-29 | 0.38 | 2.97 | 4.77 | |||
SO46974_21 | BEE6-4EC8-8E | PO14442112586 | 100 | 286 | 427 | 127 | 1 | 2022-10-03 | 1255.54 | 31.39 | 2022-09-21 | 6 | 185.82 | 1 | 1255.54 | 21 | SO46974 | 2022-09-28 | 100.44 | 1114.92 | 209.26 | |||
SO51154_44 | 2A76-4451-99 | PO7859157852 | 100 | 287 | 246 | 221 | 4 | 2023-09-02 | 858.90 | 21.47 | 2023-08-21 | 1 | 868.63 | 1 | 858.90 | 44 | SO51154 | 2023-08-28 | 68.71 | 868.63 | 858.90 | |||
SO65238_20 | 896A-4ED1-B1 | PO10875188169 | 19 | 291 | 472 | 281 | 6 | 2024-05-03 | 228.60 | 5.72 | 2024-04-21 | 6 | 23.75 | 1 | 228.60 | 20 | SO65238 | 2024-04-28 | 18.29 | 142.49 | 38.10 | |||
SO51752_9 | C68C-4AF8-B1 | PO11223127670 | 100 | 292 | 398 | 632 | 7 | 2023-10-03 | 53.45 | 1.34 | 2023-09-21 | 2 | 19.78 | 1 | 53.45 | 9 | SO51752 | 2023-09-28 | 4.28 | 39.55 | 26.72 | |||
SO53455_21 | ACD7-4AF3-84 | PO19604185529 | 98 | 288 | 298 | 340 | 10 | 2023-11-03 | 809.76 | 20.24 | 2023-10-22 | 1 | 739.04 | 1 | 809.76 | 21 | SO53455 | 2023-10-29 | 64.78 | 739.04 | 809.76 | |||
SO61204_1 | E810-4164-82 | PO15312134209 | 19 | 291 | 490 | 299 | 6 | 2024-03-04 | 291.55 | 7.29 | 2024-02-21 | 9 | 41.57 | 1 | 291.55 | 1 | SO61204 | 2024-02-28 | 23.32 | 374.15 | 32.39 | |||
SO53475_47 | FFE3-4820-88 | PO15515192405 | 100 | 292 | 376 | 481 | 7 | 2023-11-03 | 2932.02 | 73.30 | 2023-10-22 | 2 | 1554.95 | 1 | 2932.02 | 47 | SO53475 | 2023-10-29 | 234.56 | 3109.90 | 1466.01 | |||
SO51822_55 | EEEE-45C1-87 | PO8845178563 | 100 | 282 | 488 | 546 | 3 | 2023-10-03 | 129.58 | 3.24 | 2023-09-21 | 4 | 41.57 | 1 | 129.58 | 55 | SO51822 | 2023-09-28 | 10.37 | 166.29 | 32.39 | |||
SO50672_3 | 1BE9-437C-8A | PO16472110144 | 100 | 287 | 454 | 239 | 4 | 2023-08-03 | 143.98 | 3.60 | 2023-07-22 | 4 | 24.75 | 1 | 143.98 | 3 | SO50672 | 2023-07-29 | 11.52 | 98.98 | 35.99 | |||
SO46967_19 | 6486-4AF8-A6 | PO15573116583 | 100 | 286 | 230 | 487 | 1 | 2022-10-03 | 173.04 | 4.33 | 2022-09-21 | 6 | 29.08 | 1 | 173.04 | 19 | SO46967 | 2022-09-28 | 13.84 | 174.48 | 28.84 | |||
SO48313_8 | 5D5B-4BBC-AB | PO16182116781 | 100 | 287 | 360 | 23 | 4 | 2023-02-02 | 3688.38 | 92.21 | 2023-01-21 | 3 | 1105.81 | 1 | 3688.38 | 8 | SO48313 | 2023-01-28 | 295.07 | 3317.43 | 1229.46 | |||
SO53570_51 | 412A-483A-A3 | PO9483124574 | 100 | 283 | 217 | 54 | 2 | 2023-11-03 | 209.94 | 5.25 | 2023-10-22 | 10 | 13.09 | 1 | 209.94 | 51 | SO53570 | 2023-10-29 | 16.80 | 130.86 | 20.99 | |||
SO71806_18 | 26A7-4E95-9B | PO14790111844 | 19 | 291 | 589 | 497 | 6 | 2024-08-03 | 1846.78 | 46.17 | 2024-07-22 | 4 | 419.78 | 1 | 1846.78 | 18 | SO71806 | 2024-07-29 | 147.74 | 1679.11 | 461.69 | |||
SO58908_1 | A429-40BA-96 | PO19285116289 | 98 | 290 | 574 | 448 | 10 | 2024-02-02 | 1430.44 | 35.76 | 2024-01-21 | 1 | 1481.94 | 1 | 1430.44 | 1 | SO58908 | 2024-01-28 | 114.44 | 1481.94 | 1430.44 | |||
SO55264_20 | 80F3-4A7B-A2 | PO10730163005 | 100 | 287 | 606 | 491 | 4 | 2023-12-03 | 971.98 | 24.30 | 2023-11-21 | 3 | 343.65 | 1 | 971.98 | 20 | SO55264 | 2023-11-28 | 77.76 | 1030.95 | 323.99 | |||
SO48341_35 | A747-471B-97 | PO10701176180 | 100 | 282 | 391 | 133 | 4 | 2023-02-02 | 266.80 | 6.67 | 2023-01-21 | 3 | 65.81 | 1 | 266.80 | 35 | SO48341 | 2023-01-28 | 21.34 | 197.43 | 88.93 | |||
SO47039_4 | B548-493E-AE | PO5684166879 | 100 | 282 | 362 | 385 | 4 | 2022-10-03 | 7376.75 | 184.42 | 2022-09-21 | 6 | 1105.81 | 1 | 7376.75 | 4 | SO47039 | 2022-09-28 | 590.14 | 6634.86 | 1229.46 | |||
SO57157_2 | 2435-487B-AC | PO4843135815 | 100 | 287 | 386 | 257 | 4 | 2024-01-03 | 3361.47 | 84.04 | 2023-12-22 | 5 | 713.08 | 1 | 3361.47 | 2 | SO57157 | 2023-12-29 | 268.92 | 3565.40 | 672.29 | |||
SO71886_8 | AE34-4CC5-9B | PO6815136550 | 100 | 293 | 588 | 109 | 1 | 2024-08-03 | 923.39 | 23.08 | 2024-07-22 | 2 | 419.78 | 1 | 923.39 | 8 | SO71886 | 2024-07-29 | 73.87 | 839.56 | 461.69 | |||
SO50672_13 | 1BE9-437C-8A | PO16472110144 | 100 | 287 | 457 | 239 | 4 | 2023-08-03 | 359.95 | 9.00 | 2023-07-22 | 8 | 30.93 | 1 | 359.95 | 13 | SO50672 | 2023-07-29 | 28.80 | 247.47 | 44.99 | |||
SO50242_17 | A651-4343-86 | PO1595193228 | 19 | 284 | 445 | 426 | 6 | 2023-07-03 | 143.98 | 3.60 | 2023-06-21 | 4 | 24.75 | 1 | 143.98 | 17 | SO50242 | 2023-06-28 | 11.52 | 98.98 | 35.99 | |||
SO51835_4 | 77C2-4BFE-A9 | PO7250132094 | 36 | 295 | 483 | 410 | 8 | 2023-10-03 | 288.00 | 7.20 | 2023-09-21 | 4 | 44.88 | 1 | 288.00 | 4 | SO51835 | 2023-09-28 | 23.04 | 179.52 | 72.00 | |||
SO71795_3 | 5843-4E7D-8D | PO17371184627 | 6 | 296 | 500 | 688 | 9 | 2024-08-03 | 2409.38 | 60.23 | 2024-07-22 | 4 | 601.74 | 1 | 2409.38 | 3 | SO71795 | 2024-07-29 | 192.75 | 2406.97 | 602.35 | |||
SO67321_7 | 7F43-4E4F-8E | PO7076150186 | 100 | 293 | 579 | 505 | 1 | 2024-06-03 | 5831.28 | 145.78 | 2024-05-22 | 8 | 755.15 | 1 | 5831.28 | 7 | SO67321 | 2024-05-29 | 466.50 | 6041.21 | 728.91 | |||
SO43681_2 | 6D51-449D-B3 | PO1189177803 | 100 | 285 | 326 | 423 | 5 | 2021-09-02 | 2097.29 | 52.43 | 2021-08-21 | 5 | 413.15 | 1 | 2097.29 | 2 | SO43681 | 2021-08-28 | 167.78 | 2065.73 | 419.46 | |||
SO65207_5 | B20E-440F-A3 | PO1537156240 | 100 | 285 | 465 | 611 | 5 | 2024-05-03 | 44.08 | 1.10 | 2024-04-21 | 3 | 9.16 | 1 | 44.08 | 5 | SO65207 | 2024-04-28 | 3.53 | 27.48 | 14.69 | |||
SO43879_8 | EDC5-4BD5-8F | PO11600128380 | 19 | 288 | 342 | 569 | 6 | 2021-10-03 | 1677.84 | 41.95 | 2021-09-21 | 4 | 413.15 | 1 | 1677.84 | 8 | SO43879 | 2021-09-28 | 134.23 | 1652.59 | 419.46 | |||
SO51102_19 | F2B1-4561-84 | PO13659193365 | 100 | 287 | 597 | 437 | 4 | 2023-09-02 | 971.98 | 24.30 | 2023-08-21 | 3 | 294.58 | 1 | 971.98 | 19 | SO51102 | 2023-08-28 | 77.76 | 883.74 | 323.99 | |||
SO47021_5 | 7B2C-4085-98 | PO3161191453 | 100 | 281 | 458 | 359 | 2 | 2022-10-03 | 89.99 | 2.25 | 2022-09-21 | 2 | 30.93 | 1 | 89.99 | 5 | SO47021 | 2022-09-28 | 7.20 | 61.87 | 44.99 |
Generated 2024-09-20 04:29:48.395 UTC