[ROOT] dt FactResellerSale WHERE DimSalesTerritoryId EQ '1' > SHUFFLE < SKIP 649 > < 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 |
---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
SO44109_9 | 1055-4F53-BB | PO783112882 | 100 | 286 | 315 | 91 | 1 | 2021-12-25 | 1749.59 | 43.74 | 2021-12-13 | 2 | 884.71 | 1 | 1749.59 | 9 | SO44109 | 2021-12-20 | 139.97 | 1769.42 | 874.79 | |||
SO61182_13 | C1B1-4DBF-A9 | PO16588179661 | 100 | 289 | 596 | 146 | 1 | 2024-04-25 | 647.99 | 16.20 | 2024-04-13 | 2 | 294.58 | 1 | 647.99 | 13 | SO61182 | 2024-04-20 | 51.84 | 589.16 | 323.99 | |||
SO71835_36 | EBBF-4B16-99 | PO870120974 | 100 | 286 | 571 | 621 | 1 | 2024-09-24 | 1336.23 | 33.41 | 2024-09-12 | 3 | 461.44 | 1 | 1336.23 | 36 | SO71835 | 2024-09-19 | 106.90 | 1384.33 | 445.41 | |||
SO48328_14 | 5992-4AF8-B1 | PO13543152596 | 100 | 287 | 358 | 293 | 1 | 2023-03-26 | 1229.46 | 30.74 | 2023-03-14 | 1 | 1105.81 | 1 | 1229.46 | 14 | SO48328 | 2023-03-21 | 98.36 | 1105.81 | 1229.46 | |||
SO51721_44 | 9429-430D-89 | PO14500124798 | 100 | 282 | 595 | 650 | 1 | 2023-11-24 | 1016.98 | 25.42 | 2023-11-12 | 3 | 308.22 | 1 | 1016.98 | 44 | SO51721 | 2023-11-19 | 81.36 | 924.65 | 338.99 | |||
SO53613_23 | 4A10-4F98-84 | PO6815195063 | 100 | 293 | 591 | 109 | 1 | 2023-12-25 | 677.99 | 16.95 | 2023-12-13 | 2 | 308.22 | 1 | 677.99 | 23 | SO53613 | 2023-12-20 | 54.24 | 616.44 | 338.99 | |||
SO49054_3 | 8503-488C-AA | PO14558112909 | 100 | 289 | 468 | 2 | 1 | 2023-05-27 | 22.79 | 0.57 | 2023-05-15 | 1 | 15.67 | 1 | 22.79 | 3 | SO49054 | 2023-05-22 | 1.82 | 15.67 | 22.79 | |||
SO48757_1 | C817-44D2-B4 | PO16588132026 | 100 | 289 | 469 | 146 | 1 | 2023-04-26 | 68.38 | 1.71 | 2023-04-14 | 3 | 15.67 | 1 | 68.38 | 1 | SO48757 | 2023-04-21 | 5.47 | 47.01 | 22.79 | |||
SO58946_26 | F9DD-426F-9A | PO12470155874 | 100 | 287 | 572 | 672 | 1 | 2024-03-25 | 2672.46 | 66.81 | 2024-03-13 | 6 | 461.44 | 1 | 2672.46 | 26 | SO58946 | 2024-03-20 | 213.80 | 2768.67 | 445.41 | |||
SO44567_8 | A14C-49FF-A8 | PO7917171062 | 100 | 287 | 351 | 401 | 1 | 2022-02-24 | 4049.99 | 101.25 | 2022-02-12 | 2 | 1898.09 | 1 | 4049.99 | 8 | SO44567 | 2022-02-19 | 324.00 | 3796.19 | 2024.99 | |||
SO58917_2 | 0658-4A38-93 | PO17487197562 | 100 | 293 | 481 | 692 | 1 | 2024-03-25 | 10.79 | 0.27 | 2024-03-13 | 2 | 3.36 | 1 | 10.79 | 2 | SO58917 | 2024-03-20 | 0.86 | 6.72 | 5.39 | |||
SO50210_4 | 6347-4C03-9B | PO15631112842 | 100 | 282 | 469 | 43 | 1 | 2023-08-24 | 113.97 | 2.85 | 2023-08-12 | 5 | 15.67 | 1 | 113.97 | 4 | SO50210 | 2023-08-19 | 9.12 | 78.35 | 22.79 | |||
SO58910_28 | A209-4ADD-98 | PO19169152738 | 100 | 289 | 516 | 272 | 1 | 2024-03-25 | 93.94 | 2.35 | 2024-03-13 | 4 | 17.38 | 1 | 93.94 | 28 | SO58910 | 2024-03-20 | 7.51 | 69.51 | 23.48 | |||
SO50218_36 | B8E9-4FE2-8B | PO14442144367 | 100 | 293 | 221 | 127 | 1 | 2023-08-24 | 161.49 | 4.04 | 2023-08-12 | 8 | 13.88 | 1 | 161.49 | 36 | SO50218 | 2023-08-19 | 12.92 | 111.03 | 20.19 | |||
SO50218_21 | B8E9-4FE2-8B | PO14442144367 | 100 | 293 | 458 | 127 | 1 | 2023-08-24 | 359.95 | 9.00 | 2023-08-12 | 8 | 30.93 | 1 | 359.95 | 21 | SO50218 | 2023-08-19 | 28.80 | 247.47 | 44.99 | |||
SO57099_38 | 410F-45E9-9C | PO18618199656 | 100 | 286 | 506 | 605 | 1 | 2024-02-24 | 400.10 | 10.00 | 2024-02-12 | 2 | 199.85 | 1 | 400.10 | 38 | SO57099 | 2024-02-19 | 32.01 | 399.70 | 200.05 | |||
SO46667_11 | D3CD-4A6E-94 | PO7105131549 | 100 | 286 | 286 | 668 | 1 | 2022-10-24 | 551.81 | 13.80 | 2022-10-12 | 3 | 170.14 | 1 | 551.81 | 11 | SO46667 | 2022-10-19 | 44.15 | 510.43 | 183.94 | |||
SO48001_12 | 02F1-4434-99 | PO14442151969 | 100 | 293 | 460 | 127 | 1 | 2023-02-24 | 107.99 | 2.70 | 2023-02-12 | 2 | 37.12 | 1 | 107.99 | 12 | SO48001 | 2023-02-19 | 8.64 | 74.24 | 53.99 | |||
SO59021_26 | A306-4E83-B7 | PO7395154426 | 100 | 286 | 588 | 542 | 1 | 2024-03-25 | 923.39 | 23.08 | 2024-03-13 | 2 | 419.78 | 1 | 923.39 | 26 | SO59021 | 2024-03-20 | 73.87 | 839.56 | 461.69 | |||
SO63157_7 | 9E62-4577-80 | PO14500183845 | 100 | 282 | 524 | 650 | 1 | 2024-05-26 | 1109.01 | 27.73 | 2024-05-14 | 7 | 144.59 | 1 | 1109.01 | 7 | SO63157 | 2024-05-21 | 88.72 | 1012.16 | 158.43 | |||
SO50669_4 | CEEB-4329-BA | PO17487120000 | 100 | 293 | 422 | 692 | 1 | 2023-09-24 | 67.54 | 1.69 | 2023-09-12 | 1 | 49.98 | 1 | 67.54 | 4 | SO50669 | 2023-09-19 | 5.40 | 49.98 | 67.54 | |||
SO49161_24 | 0377-44E6-AA | PO7627157444 | 100 | 293 | 389 | 433 | 1 | 2023-05-27 | 1200.53 | 30.01 | 2023-05-15 | 2 | 605.65 | 1 | 1200.53 | 24 | SO49161 | 2023-05-22 | 96.04 | 1211.30 | 600.26 | |||
SO67315_2 | 02BE-4BB0-BD | PO7105133864 | 100 | 293 | 546 | 668 | 1 | 2024-07-25 | 111.76 | 2.79 | 2024-07-13 | 3 | 27.57 | 1 | 111.76 | 2 | SO67315 | 2024-07-20 | 8.94 | 82.70 | 37.25 | |||
SO57026_22 | CD5A-4300-81 | PO16675118038 | 100 | 293 | 558 | 361 | 1 | 2024-02-24 | 242.99 | 6.07 | 2024-02-12 | 1 | 179.82 | 1 | 242.99 | 22 | SO57026 | 2024-02-19 | 19.44 | 179.82 | 242.99 | |||
SO46643_1 | 49E8-4C7A-85 | PO899110603 | 100 | 289 | 343 | 290 | 1 | 2022-10-24 | 3758.35 | 93.96 | 2022-10-12 | 8 | 486.71 | 1 | 3758.35 | 1 | SO46643 | 2022-10-19 | 300.67 | 3893.65 | 469.79 | |||
SO51123_41 | E412-45DF-AE | PO899150137 | 100 | 289 | 231 | 2 | 290 | 1 | 7.54 | 2023-10-24 | 376.92 | 9.23 | 2023-10-12 | 13 | 38.49 | 1 | 369.39 | 41 | SO51123 | 2023-10-19 | 29.55 | 500.40 | 28.99 | 0.02 |
SO50270_13 | A828-45A2-8B | PO18676112371 | 100 | 282 | 360 | 697 | 1 | 2023-08-24 | 8606.21 | 215.16 | 2023-08-12 | 7 | 1105.81 | 1 | 8606.21 | 13 | SO50270 | 2023-08-19 | 688.50 | 7740.67 | 1229.46 | |||
SO47403_37 | 60A2-4F08-8B | PO841143108 | 100 | 286 | 470 | 254 | 1 | 2022-12-25 | 227.94 | 5.70 | 2022-12-13 | 10 | 15.67 | 1 | 227.94 | 37 | SO47403 | 2022-12-20 | 18.24 | 156.71 | 22.79 |
Generated 2024-11-11 04:17:25.141 UTC