[ROOT] dt FactResellerSale WHERE DimSalesTerritoryId EQ '1' > SHUFFLE SKIP 2000 < SKIP 83 > < TAKE 24 >
24 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 |
---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
SO45342_1 | 9E99-4922-A4 | PO7917111421 | 100 | 287 | 350 | 401 | 1 | 2022-04-06 | 8099.98 | 202.50 | 2022-03-25 | 4 | 1898.09 | 1 | 8099.98 | 1 | SO45342 | 2022-04-01 | 648.00 | 7592.38 | 2024.99 | |||
SO50321_11 | 6B3D-47E0-99 | PO8816191637 | 100 | 289 | 331 | 218 | 1 | 2023-07-04 | 1409.38 | 35.23 | 2023-06-22 | 3 | 486.71 | 1 | 1409.38 | 11 | SO50321 | 2023-06-29 | 112.75 | 1460.12 | 469.79 | |||
SO49464_3 | C383-45FE-83 | PO841195010 | 100 | 286 | 393 | 254 | 1 | 2023-05-04 | 137.69 | 3.44 | 2023-04-22 | 1 | 101.89 | 1 | 137.69 | 3 | SO49464 | 2023-04-29 | 11.02 | 101.89 | 137.69 | |||
SO45064_1 | 2DCA-4F00-94 | PO2552154948 | 100 | 289 | 350 | 506 | 1 | 2022-03-06 | 4049.99 | 101.25 | 2022-02-22 | 2 | 1898.09 | 1 | 4049.99 | 1 | SO45064 | 2022-03-01 | 324.00 | 3796.19 | 2024.99 | |||
SO65270_2 | E73B-4A64-B4 | PO7192196898 | 100 | 289 | 361 | 20 | 1 | 2024-05-04 | 1376.99 | 34.42 | 2024-04-22 | 1 | 1251.98 | 1 | 1376.99 | 2 | SO65270 | 2024-04-29 | 110.16 | 1251.98 | 1376.99 | |||
SO71886_28 | AE34-4CC5-9B | PO6815136550 | 100 | 293 | 591 | 16 | 109 | 1 | 90.40 | 2024-08-04 | 226.00 | 3.39 | 2024-07-23 | 2 | 308.22 | 1 | 135.60 | 28 | SO71886 | 2024-07-30 | 10.85 | 616.44 | 113.00 | 0.40 |
SO46967_24 | 6486-4AF8-A6 | PO15573116583 | 100 | 286 | 458 | 487 | 1 | 2022-10-04 | 359.95 | 9.00 | 2022-09-22 | 8 | 30.93 | 1 | 359.95 | 24 | SO46967 | 2022-09-29 | 28.80 | 247.47 | 44.99 | |||
SO51721_58 | 9429-430D-89 | PO14500124798 | 100 | 282 | 398 | 3 | 650 | 1 | 19.60 | 2023-10-04 | 391.95 | 9.31 | 2023-09-22 | 16 | 19.78 | 1 | 372.35 | 58 | SO51721 | 2023-09-29 | 29.79 | 316.41 | 24.50 | 0.05 |
SO61241_13 | 13FB-4126-88 | PO9338116236 | 100 | 293 | 586 | 451 | 1 | 2024-03-05 | 2672.46 | 66.81 | 2024-02-22 | 6 | 461.44 | 1 | 2672.46 | 13 | SO61241 | 2024-02-29 | 213.80 | 2768.67 | 445.41 | |||
SO71836_20 | E41E-40C1-84 | PO841118259 | 100 | 286 | 542 | 254 | 1 | 2024-08-04 | 218.65 | 5.47 | 2024-07-23 | 9 | 17.98 | 1 | 218.65 | 20 | SO71836 | 2024-07-30 | 17.49 | 161.80 | 24.29 | |||
SO65175_7 | E1A8-440E-94 | PO17139119772 | 100 | 293 | 436 | 644 | 1 | 2024-05-04 | 356.90 | 8.92 | 2024-04-22 | 1 | 360.94 | 1 | 356.90 | 7 | SO65175 | 2024-04-29 | 28.55 | 360.94 | 356.90 | |||
SO46967_38 | 6486-4AF8-A6 | PO15573116583 | 100 | 286 | 396 | 487 | 1 | 2022-10-04 | 149.68 | 3.74 | 2022-09-22 | 2 | 55.38 | 1 | 149.68 | 38 | SO46967 | 2022-09-29 | 11.97 | 110.76 | 74.84 | |||
SO46647_32 | FA5F-4878-9F | PO2552157860 | 100 | 286 | 365 | 506 | 1 | 2022-09-03 | 1943.98 | 48.60 | 2022-08-22 | 3 | 598.44 | 1 | 1943.98 | 32 | SO46647 | 2022-08-29 | 155.52 | 1795.31 | 647.99 | |||
SO51783_20 | B7A2-49BC-89 | PO18676114917 | 100 | 282 | 513 | 697 | 1 | 2023-10-04 | 873.82 | 21.85 | 2023-09-22 | 4 | 199.38 | 1 | 873.82 | 20 | SO51783 | 2023-09-29 | 69.91 | 797.50 | 218.45 | |||
SO46100_6 | 58B8-4157-97 | PO7627134166 | 100 | 286 | 314 | 433 | 1 | 2022-07-04 | 4293.92 | 107.35 | 2022-06-22 | 2 | 2171.29 | 1 | 4293.92 | 6 | SO46100 | 2022-06-29 | 343.51 | 4342.59 | 2146.96 | |||
SO50297_44 | 5199-40AD-90 | PO4727113542 | 100 | 293 | 327 | 343 | 1 | 2023-07-04 | 939.59 | 23.49 | 2023-06-22 | 2 | 486.71 | 1 | 939.59 | 44 | SO50297 | 2023-06-29 | 75.17 | 973.41 | 469.79 | |||
SO53493_24 | F767-491F-84 | PO13543118174 | 100 | 287 | 306 | 293 | 1 | 2023-11-04 | 4858.56 | 121.46 | 2023-10-23 | 6 | 739.04 | 1 | 4858.56 | 24 | SO53493 | 2023-10-30 | 388.68 | 4434.25 | 809.76 | |||
SO51783_17 | B7A2-49BC-89 | PO18676114917 | 100 | 282 | 355 | 697 | 1 | 2023-10-04 | 9743.96 | 243.60 | 2023-09-22 | 7 | 1265.62 | 1 | 9743.96 | 17 | SO51783 | 2023-09-29 | 779.52 | 8859.34 | 1391.99 | |||
SO50218_10 | B8E9-4FE2-8B | PO14442144367 | 100 | 293 | 308 | 127 | 1 | 2023-07-04 | 2232.82 | 55.82 | 2023-06-22 | 3 | 660.91 | 1 | 2232.82 | 10 | SO50218 | 2023-06-29 | 178.63 | 1982.74 | 744.27 | |||
SO46667_3 | D3CD-4A6E-94 | PO7105131549 | 100 | 286 | 263 | 668 | 1 | 2022-09-03 | 607.00 | 15.17 | 2022-08-22 | 3 | 187.16 | 1 | 607.00 | 3 | SO46667 | 2022-08-29 | 48.56 | 561.47 | 202.33 | |||
SO63249_2 | ABDD-4795-8F | PO4727178983 | 100 | 293 | 606 | 343 | 1 | 2024-04-05 | 647.99 | 16.20 | 2024-03-24 | 2 | 343.65 | 1 | 647.99 | 2 | SO63249 | 2024-03-31 | 51.84 | 687.30 | 323.99 | |||
SO57105_37 | 3AE1-4A72-91 | PO18676113963 | 100 | 282 | 542 | 697 | 1 | 2024-01-04 | 72.88 | 1.82 | 2023-12-23 | 3 | 17.98 | 1 | 72.88 | 37 | SO57105 | 2023-12-30 | 5.83 | 53.93 | 24.29 | |||
SO58962_11 | 12B1-4451-9A | PO870180310 | 100 | 286 | 573 | 621 | 1 | 2024-02-03 | 4291.33 | 107.28 | 2024-01-22 | 3 | 1481.94 | 1 | 4291.33 | 11 | SO58962 | 2024-01-29 | 343.31 | 4445.81 | 1430.44 | |||
SO63247_16 | 1EB8-4AE3-AC | PO6148143330 | 100 | 289 | 502 | 693 | 1 | 2024-04-05 | 400.10 | 10.00 | 2024-03-24 | 2 | 199.85 | 1 | 400.10 | 16 | SO63247 | 2024-03-31 | 32.01 | 399.70 | 200.05 |
Generated 2024-09-21 11:38:09.671 UTC