[ROOT] dt FactResellerSale < WHERE DimSalesTerritoryId EQ ALL SKIP 0 SHUFFLE < SKIP 1066 > < 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 |
---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
SO47427_2 | 61AA-44CA-99 | PO4640137176 | 100 | 287 | 366 | 648 | 4 | 2022-11-03 | 2591.98 | 64.80 | 2022-10-22 | 4 | 598.44 | 1 | 2591.98 | 2 | SO47427 | 2022-10-29 | 207.36 | 2393.74 | 647.99 | |||
SO57088_2 | EA31-4951-8A | PO2842199218 | 100 | 285 | 217 | 700 | 5 | 2024-01-03 | 104.97 | 2.62 | 2023-12-22 | 5 | 13.09 | 1 | 104.97 | 2 | SO57088 | 2023-12-29 | 8.40 | 65.43 | 20.99 | |||
SO45797_6 | B3FE-4436-96 | PO11049120115 | 19 | 284 | 220 | 679 | 6 | 2022-06-03 | 40.37 | 1.01 | 2022-05-22 | 2 | 12.03 | 1 | 40.37 | 6 | SO45797 | 2022-05-29 | 3.23 | 24.06 | 20.19 | |||
SO67287_35 | 3F1F-44DB-96 | PO10730119334 | 100 | 287 | 580 | 491 | 4 | 2024-06-03 | 5102.97 | 127.57 | 2024-05-22 | 5 | 1082.51 | 1 | 5102.97 | 35 | SO67287 | 2024-05-29 | 408.24 | 5412.55 | 1020.59 | |||
SO58981_38 | 2B52-4247-AF | PO18299143459 | 19 | 291 | 544 | 118 | 6 | 2024-02-02 | 194.38 | 4.86 | 2024-01-21 | 4 | 35.96 | 1 | 194.38 | 38 | SO58981 | 2024-01-28 | 15.55 | 143.84 | 48.59 | |||
SO53623_11 | 7BBF-43AA-B5 | PO8903169981 | 100 | 293 | 225 | 235 | 1 | 2023-11-03 | 10.79 | 0.27 | 2023-10-22 | 2 | 6.92 | 1 | 10.79 | 11 | SO53623 | 2023-10-29 | 0.86 | 13.84 | 5.39 | |||
SO45074_5 | 7225-40DF-B0 | PO7859191751 | 100 | 287 | 324 | 221 | 4 | 2022-03-05 | 1258.38 | 31.46 | 2022-02-21 | 3 | 413.15 | 1 | 1258.38 | 5 | SO45074 | 2022-02-28 | 100.67 | 1239.44 | 419.46 | |||
SO57080_7 | A38F-4C07-81 | PO957167312 | 98 | 288 | 589 | 376 | 10 | 2024-01-03 | 1385.08 | 34.63 | 2023-12-22 | 3 | 419.78 | 1 | 1385.08 | 7 | SO57080 | 2023-12-29 | 110.81 | 1259.34 | 461.69 | |||
SO47368_19 | 7A90-4975-A2 | PO17487188099 | 100 | 286 | 221 | 692 | 1 | 2022-11-03 | 60.56 | 1.51 | 2022-10-22 | 3 | 13.88 | 1 | 60.56 | 19 | SO47368 | 2022-10-29 | 4.84 | 41.63 | 20.19 | |||
SO63171_24 | 6618-4F16-BE | PO580178064 | 36 | 295 | 506 | 230 | 8 | 2024-04-04 | 400.10 | 10.00 | 2024-03-23 | 2 | 199.85 | 1 | 400.10 | 24 | SO63171 | 2024-03-30 | 32.01 | 399.70 | 200.05 | |||
SO49147_8 | B753-40C9-A6 | PO5771172608 | 100 | 282 | 337 | 79 | 3 | 2023-04-05 | 3758.35 | 93.96 | 2023-03-24 | 8 | 486.71 | 1 | 3758.35 | 8 | SO49147 | 2023-03-31 | 300.67 | 3893.65 | 469.79 | |||
SO58959_25 | 1330-4B17-AF | PO10353115061 | 98 | 288 | 463 | 88 | 10 | 2024-02-02 | 14.69 | 0.37 | 2024-01-21 | 1 | 9.16 | 1 | 14.69 | 25 | SO58959 | 2024-01-28 | 1.18 | 9.16 | 14.69 | |||
SO45804_7 | A72B-452A-BA | PO2552178124 | 100 | 289 | 232 | 506 | 1 | 2022-06-03 | 86.52 | 2.16 | 2022-05-22 | 3 | 31.72 | 1 | 86.52 | 7 | SO45804 | 2022-05-29 | 6.92 | 95.17 | 28.84 | |||
SO53452_36 | B555-4FD7-8B | PO870113712 | 100 | 286 | 562 | 14 | 621 | 1 | 572.18 | 2023-11-03 | 2860.88 | 57.22 | 2023-10-22 | 3 | 1481.94 | 1 | 2288.71 | 36 | SO53452 | 2023-10-29 | 183.10 | 4445.81 | 953.63 | 0.20 |
SO49836_27 | 0E32-48F7-89 | PO12644185975 | 100 | 285 | 428 | 530 | 5 | 2023-06-03 | 837.02 | 20.93 | 2023-05-22 | 4 | 185.82 | 1 | 837.02 | 27 | SO49836 | 2023-05-29 | 66.96 | 743.28 | 209.26 | |||
SO43906_14 | BA78-4228-89 | PO6438197212 | 100 | 283 | 235 | 309 | 4 | 2021-10-03 | 57.68 | 1.44 | 2021-09-21 | 2 | 31.72 | 1 | 57.68 | 14 | SO43906 | 2021-09-28 | 4.61 | 63.45 | 28.84 | |||
SO47725_33 | 2501-4A1D-99 | PO9831133395 | 100 | 285 | 329 | 81 | 5 | 2022-12-03 | 2818.76 | 70.47 | 2022-11-21 | 6 | 486.71 | 1 | 2818.76 | 33 | SO47725 | 2022-11-28 | 225.50 | 2920.24 | 469.79 | |||
SO55268_56 | 47E6-44B3-A4 | PO10324191521 | 98 | 288 | 543 | 196 | 10 | 2023-12-03 | 111.76 | 2.79 | 2023-11-21 | 3 | 27.57 | 1 | 111.76 | 56 | SO55268 | 2023-11-28 | 8.94 | 82.70 | 37.25 | |||
SO50741_2 | B860-44B9-90 | PO4408114284 | 100 | 283 | 417 | 143 | 2 | 2023-08-03 | 324.45 | 8.11 | 2023-07-22 | 1 | 300.12 | 1 | 324.45 | 2 | SO50741 | 2023-07-29 | 25.96 | 300.12 | 324.45 | |||
SO50687_13 | DF8C-416B-BA | PO10962187340 | 19 | 284 | 470 | 685 | 6 | 2023-08-03 | 159.56 | 3.99 | 2023-07-22 | 7 | 15.67 | 1 | 159.56 | 13 | SO50687 | 2023-07-29 | 12.76 | 109.70 | 22.79 | |||
SO61263_32 | 729E-4D96-91 | PO5452121402 | 36 | 295 | 579 | 320 | 8 | 2024-03-04 | 2186.73 | 54.67 | 2024-02-21 | 3 | 755.15 | 1 | 2186.73 | 32 | SO61263 | 2024-02-28 | 174.94 | 2265.45 | 728.91 | |||
SO49843_27 | D3CA-4A51-B6 | PO11484175391 | 100 | 283 | 428 | 594 | 2 | 2023-06-03 | 627.77 | 15.69 | 2023-05-22 | 3 | 185.82 | 1 | 627.77 | 27 | SO49843 | 2023-05-29 | 50.22 | 557.46 | 209.26 | |||
SO48392_3 | B9C7-4F4D-82 | PO9483147187 | 100 | 281 | 460 | 54 | 2 | 2023-02-02 | 269.97 | 6.75 | 2023-01-21 | 5 | 37.12 | 1 | 269.97 | 3 | SO48392 | 2023-01-28 | 21.60 | 185.60 | 53.99 | |||
SO69448_9 | 26BF-4CA1-97 | PO11020118669 | 19 | 284 | 482 | 336 | 6 | 2024-07-03 | 16.18 | 0.40 | 2024-06-21 | 3 | 3.36 | 1 | 16.18 | 9 | SO69448 | 2024-06-28 | 1.29 | 10.09 | 5.39 | |||
SO50225_10 | 6F8E-49A2-A5 | PO12702153410 | 100 | 292 | 393 | 175 | 7 | 2023-07-03 | 688.47 | 17.21 | 2023-06-21 | 5 | 101.89 | 1 | 688.47 | 10 | SO50225 | 2023-06-28 | 55.08 | 509.47 | 137.69 | |||
SO47015_6 | 853D-4913-A7 | PO2117171072 | 19 | 284 | 470 | 444 | 6 | 2022-10-03 | 182.35 | 4.56 | 2022-09-21 | 8 | 15.67 | 1 | 182.35 | 6 | SO47015 | 2022-09-28 | 14.59 | 125.37 | 22.79 | |||
SO65306_1 | 6B9B-439C-94 | PO5597142402 | 100 | 281 | 603 | 75 | 4 | 2024-05-03 | 72.89 | 1.82 | 2024-04-21 | 1 | 53.94 | 1 | 72.89 | 1 | SO65306 | 2024-04-28 | 5.83 | 53.94 | 72.89 | |||
SO51096_13 | 2D8A-4DAD-96 | PO14732111307 | 19 | 291 | 378 | 514 | 6 | 2023-09-02 | 7330.05 | 183.25 | 2023-08-21 | 5 | 1554.95 | 1 | 7330.05 | 13 | SO51096 | 2023-08-28 | 586.40 | 7774.74 | 1466.01 | |||
SO71783_14 | 7E03-4B8A-BA | PO19343113609 | 100 | 282 | 418 | 24 | 4 | 2024-08-03 | 356.90 | 8.92 | 2024-07-22 | 1 | 360.94 | 1 | 356.90 | 14 | SO71783 | 2024-07-29 | 28.55 | 360.94 | 356.90 | |||
SO48341_41 | A747-471B-97 | PO10701176180 | 100 | 282 | 454 | 133 | 4 | 2023-02-02 | 323.95 | 8.10 | 2023-01-21 | 9 | 24.75 | 1 | 323.95 | 41 | SO48341 | 2023-01-28 | 25.92 | 222.71 | 35.99 | |||
SO71866_21 | 029A-46BE-80 | PO14297151936 | 100 | 285 | 555 | 627 | 5 | 2024-08-03 | 127.80 | 3.20 | 2024-07-22 | 2 | 47.29 | 1 | 127.80 | 21 | SO71866 | 2024-07-29 | 10.22 | 94.57 | 63.90 | |||
SO50222_33 | 4FDE-4C03-A9 | PO13427181046 | 100 | 292 | 224 | 638 | 7 | 2023-07-03 | 20.75 | 0.52 | 2023-06-21 | 4 | 5.23 | 1 | 20.75 | 33 | SO50222 | 2023-06-28 | 1.66 | 20.92 | 5.19 | |||
SO63133_22 | C3D9-4B73-83 | PO18618146912 | 100 | 286 | 560 | 605 | 1 | 2024-04-04 | 3644.55 | 91.11 | 2024-03-23 | 5 | 755.15 | 1 | 3644.55 | 22 | SO63133 | 2024-03-30 | 291.56 | 3775.75 | 728.91 | |||
SO59010_13 | 2350-42CD-B1 | PO6815132533 | 100 | 293 | 512 | 109 | 1 | 2024-02-02 | 655.36 | 16.38 | 2024-01-21 | 3 | 199.38 | 1 | 655.36 | 13 | SO59010 | 2024-01-28 | 52.43 | 598.13 | 218.45 | |||
SO55300_22 | 40F4-470B-82 | PO8004112820 | 6 | 296 | 560 | 231 | 9 | 2023-12-03 | 728.91 | 18.22 | 2023-11-21 | 1 | 755.15 | 1 | 728.91 | 22 | SO55300 | 2023-11-28 | 58.31 | 755.15 | 728.91 | |||
SO49445_1 | 943B-43E1-AE | PO174113233 | 100 | 282 | 343 | 277 | 4 | 2023-05-03 | 469.79 | 11.74 | 2023-04-21 | 1 | 486.71 | 1 | 469.79 | 1 | SO49445 | 2023-04-28 | 37.58 | 486.71 | 469.79 | |||
SO57137_9 | 9401-4518-A4 | PO6438194874 | 100 | 281 | 487 | 309 | 4 | 2024-01-03 | 164.97 | 4.12 | 2023-12-22 | 5 | 20.57 | 1 | 164.97 | 9 | SO57137 | 2023-12-29 | 13.20 | 102.83 | 32.99 | |||
SO51814_9 | A4D8-45E5-BB | PO7801116238 | 6 | 296 | 561 | 14 | 87 | 9 | 1144.35 | 2023-10-03 | 5721.77 | 114.44 | 2023-09-21 | 6 | 1481.94 | 1 | 4577.41 | 9 | SO51814 | 2023-09-28 | 366.19 | 8891.63 | 953.63 | 0.20 |
SO57067_50 | 08F2-42FC-BE | PO11368183380 | 36 | 295 | 533 | 687 | 8 | 2024-01-03 | 149.87 | 3.75 | 2023-12-22 | 1 | 136.79 | 1 | 149.87 | 50 | SO57067 | 2023-12-29 | 11.99 | 136.79 | 149.87 | |||
SO45288_17 | D4D0-4662-A9 | PO16327170541 | 100 | 285 | 326 | 584 | 5 | 2022-04-05 | 3355.67 | 83.89 | 2022-03-24 | 8 | 413.15 | 1 | 3355.67 | 17 | SO45288 | 2022-03-31 | 268.45 | 3305.17 | 419.46 | |||
SO71854_10 | AF3C-4FDF-A6 | PO16385143469 | 6 | 296 | 552 | 249 | 9 | 2024-08-03 | 109.79 | 2.74 | 2024-07-22 | 2 | 40.62 | 1 | 109.79 | 10 | SO71854 | 2024-07-29 | 8.78 | 81.24 | 54.89 | |||
SO49101_8 | 0549-4175-A0 | PO15573181395 | 100 | 293 | 216 | 487 | 1 | 2023-04-05 | 80.75 | 2.02 | 2023-03-24 | 4 | 13.88 | 1 | 80.75 | 8 | SO49101 | 2023-03-31 | 6.46 | 55.51 | 20.19 | |||
SO45331_2 | 4702-48B5-B8 | PO6293165974 | 100 | 285 | 322 | 612 | 5 | 2022-04-05 | 419.46 | 10.49 | 2022-03-24 | 1 | 413.15 | 1 | 419.46 | 2 | SO45331 | 2022-03-31 | 33.56 | 413.15 | 419.46 | |||
SO44559_17 | 8618-4A1B-AD | PO6641148111 | 100 | 281 | 319 | 342 | 2 | 2022-01-03 | 1749.59 | 43.74 | 2021-12-22 | 2 | 884.71 | 1 | 1749.59 | 17 | SO44559 | 2021-12-29 | 139.97 | 1769.42 | 874.79 | |||
SO44501_1 | 4971-4FC0-A3 | PO16646128920 | 100 | 286 | 324 | 1 | 1 | 2022-01-03 | 419.46 | 10.49 | 2021-12-22 | 1 | 413.15 | 1 | 419.46 | 1 | SO44501 | 2021-12-29 | 33.56 | 413.15 | 419.46 | |||
SO46076_15 | E898-4203-B0 | PO2523131751 | 100 | 287 | 270 | 167 | 4 | 2022-07-03 | 551.81 | 13.80 | 2022-06-21 | 3 | 181.49 | 1 | 551.81 | 15 | SO46076 | 2022-06-28 | 44.15 | 544.46 | 183.94 | |||
SO45053_8 | 1527-4B4C-8B | PO13775163879 | 100 | 281 | 318 | 618 | 2 | 2022-03-05 | 874.79 | 21.87 | 2022-02-21 | 1 | 884.71 | 1 | 874.79 | 8 | SO45053 | 2022-02-28 | 69.98 | 884.71 | 874.79 | |||
SO49118_35 | 532A-4BAE-8C | PO13427116278 | 100 | 292 | 447 | 638 | 7 | 2023-04-05 | 75.00 | 1.88 | 2023-03-24 | 5 | 10.31 | 1 | 75.00 | 35 | SO49118 | 2023-03-31 | 6.00 | 51.56 | 15.00 | |||
SO51823_12 | 2FB1-4AE1-BC | PO8642173409 | 98 | 288 | 504 | 520 | 10 | 2023-10-03 | 200.05 | 5.00 | 2023-09-21 | 1 | 199.85 | 1 | 200.05 | 12 | SO51823 | 2023-09-28 | 16.00 | 199.85 | 200.05 | |||
SO51871_1 | 6397-49EC-9C | PO9164147296 | 6 | 296 | 510 | 339 | 9 | 2023-10-03 | 200.05 | 5.00 | 2023-09-21 | 1 | 199.85 | 1 | 200.05 | 1 | SO51871 | 2023-09-28 | 16.00 | 199.85 | 200.05 | |||
SO69564_11 | 9BAA-4E23-A3 | PO9425176552 | 6 | 294 | 225 | 519 | 9 | 2024-07-03 | 26.97 | 0.67 | 2024-06-21 | 5 | 6.92 | 1 | 26.97 | 11 | SO69564 | 2024-06-28 | 2.16 | 34.61 | 5.39 | |||
SO49058_19 | BD1B-4C7F-A9 | PO12499147561 | 100 | 282 | 263 | 78 | 4 | 2023-04-05 | 202.33 | 5.06 | 2023-03-24 | 1 | 187.16 | 1 | 202.33 | 19 | SO49058 | 2023-03-31 | 16.19 | 187.16 | 202.33 | |||
SO46074_7 | 5178-4FDE-97 | PO2088179248 | 19 | 288 | 264 | 136 | 6 | 2022-07-03 | 367.88 | 9.20 | 2022-06-21 | 2 | 181.49 | 1 | 367.88 | 7 | SO46074 | 2022-06-28 | 29.43 | 362.97 | 183.94 | |||
SO57105_5 | 3AE1-4A72-91 | PO18676113963 | 100 | 282 | 512 | 697 | 1 | 2024-01-03 | 655.36 | 16.38 | 2023-12-22 | 3 | 199.38 | 1 | 655.36 | 5 | SO57105 | 2023-12-29 | 52.43 | 598.13 | 218.45 | |||
SO65182_22 | 130D-4FE9-83 | PO16385138124 | 6 | 296 | 483 | 249 | 9 | 2024-05-03 | 432.00 | 10.80 | 2024-04-21 | 6 | 44.88 | 1 | 432.00 | 22 | SO65182 | 2024-04-28 | 34.56 | 269.28 | 72.00 | |||
SO48750_14 | 9A71-449E-B6 | PO14732147398 | 19 | 291 | 325 | 514 | 6 | 2023-03-05 | 1409.38 | 35.23 | 2023-02-21 | 3 | 486.71 | 1 | 1409.38 | 14 | SO48750 | 2023-02-28 | 112.75 | 1460.12 | 469.79 |
Generated 2024-09-20 09:32:43.127 UTC