[ROOT] dt FactResellerSale < WHERE DimSalesTerritoryId EQ '5' > SHUFFLE < SKIP 2469 > < TAKE 31 >
31 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 |
---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
SO67349_35 | 7BC2-4E87-BA | PO9831186318 | 100 | 285 | 491 | 3 | 81 | 5 | 23.76 | 2024-07-23 | 475.11 | 11.28 | 2024-07-11 | 16 | 41.57 | 1 | 451.36 | 35 | SO67349 | 2024-07-18 | 36.11 | 665.16 | 29.69 | 0.05 |
SO44319_6 | FBB9-4CD9-A1 | PO9657142761 | 100 | 285 | 349 | 315 | 5 | 2022-01-22 | 8099.98 | 202.50 | 2022-01-10 | 4 | 1898.09 | 1 | 8099.98 | 6 | SO44319 | 2022-01-17 | 648.00 | 7592.38 | 2024.99 | |||
SO49091_20 | 7A94-486D-8A | PO19546118667 | 100 | 285 | 329 | 206 | 5 | 2023-05-25 | 1409.38 | 35.23 | 2023-05-13 | 3 | 486.71 | 1 | 1409.38 | 20 | SO49091 | 2023-05-20 | 112.75 | 1460.12 | 469.79 | |||
SO50756_32 | C414-447C-84 | PO9570119689 | 100 | 285 | 213 | 585 | 5 | 2023-09-22 | 40.37 | 1.01 | 2023-09-10 | 2 | 13.88 | 1 | 40.37 | 32 | SO50756 | 2023-09-17 | 3.23 | 27.76 | 20.19 | |||
SO48766_40 | A56F-4A7B-AD | PO9831126274 | 100 | 285 | 368 | 81 | 5 | 2023-04-24 | 2932.02 | 73.30 | 2023-04-12 | 2 | 1518.79 | 1 | 2932.02 | 40 | SO48766 | 2023-04-19 | 234.56 | 3037.57 | 1466.01 | |||
SO46383_2 | 2398-4D5E-8F | PO9106128085 | 100 | 285 | 344 | 7 | 602 | 5 | 595.00 | 2022-09-22 | 1700.00 | 27.62 | 2022-09-10 | 2 | 1912.15 | 1 | 1105.00 | 2 | SO46383 | 2022-09-17 | 88.40 | 3824.31 | 850.00 | 0.35 |
SO46090_2 | 987E-4B5B-B6 | PO5858172038 | 100 | 285 | 344 | 566 | 5 | 2022-08-22 | 6119.98 | 153.00 | 2022-08-10 | 3 | 1912.15 | 1 | 6119.98 | 2 | SO46090 | 2022-08-17 | 489.60 | 5736.46 | 2039.99 | |||
SO47026_14 | 123B-481F-8F | PO3596190739 | 100 | 285 | 428 | 476 | 5 | 2022-11-22 | 418.51 | 10.46 | 2022-11-10 | 2 | 185.82 | 1 | 418.51 | 14 | SO47026 | 2022-11-17 | 33.48 | 371.64 | 209.26 | |||
SO50701_3 | B67A-4C0A-B3 | PO2407199018 | 100 | 285 | 254 | 225 | 5 | 2023-09-22 | 183.94 | 4.60 | 2023-09-10 | 1 | 170.14 | 1 | 183.94 | 3 | SO50701 | 2023-09-17 | 14.72 | 170.14 | 183.94 | |||
SO49090_15 | BA90-48D0-89 | PO11571148651 | 100 | 285 | 369 | 512 | 5 | 2023-05-25 | 1466.01 | 36.65 | 2023-05-13 | 1 | 1518.79 | 1 | 1466.01 | 15 | SO49090 | 2023-05-20 | 117.28 | 1518.79 | 1466.01 | |||
SO47042_44 | 42DB-4E2E-B9 | PO5858114009 | 100 | 285 | 397 | 566 | 5 | 2022-11-22 | 24.29 | 0.61 | 2022-11-10 | 1 | 17.98 | 1 | 24.29 | 44 | SO47042 | 2022-11-17 | 1.94 | 17.98 | 24.29 | |||
SO47725_17 | 2501-4A1D-99 | PO9831133395 | 100 | 285 | 381 | 81 | 5 | 2023-01-22 | 1800.79 | 45.02 | 2023-01-10 | 3 | 605.65 | 1 | 1800.79 | 17 | SO47725 | 2023-01-17 | 144.06 | 1816.95 | 600.26 | |||
SO43861_2 | 0CC0-4166-9E | PO16327172067 | 100 | 285 | 330 | 584 | 5 | 2021-11-22 | 1258.38 | 31.46 | 2021-11-10 | 3 | 413.15 | 1 | 1258.38 | 2 | SO43861 | 2021-11-17 | 100.67 | 1239.44 | 419.46 | |||
SO67260_21 | 6224-4229-B8 | PO522163557 | 100 | 285 | 477 | 676 | 5 | 2024-07-23 | 26.95 | 0.67 | 2024-07-11 | 9 | 1.87 | 1 | 26.95 | 21 | SO67260 | 2024-07-18 | 2.16 | 16.80 | 2.99 | |||
SO69533_11 | AC2B-4C39-84 | PO3596133486 | 100 | 285 | 511 | 476 | 5 | 2024-08-22 | 218.45 | 5.46 | 2024-08-10 | 1 | 199.38 | 1 | 218.45 | 11 | SO69533 | 2024-08-17 | 17.48 | 199.38 | 218.45 | |||
SO69465_18 | B8B2-4B14-99 | PO2842153886 | 100 | 285 | 378 | 700 | 5 | 2024-08-22 | 2932.02 | 73.30 | 2024-08-10 | 2 | 1554.95 | 1 | 2932.02 | 18 | SO69465 | 2024-08-17 | 234.56 | 3109.90 | 1466.01 | |||
SO71866_14 | 029A-46BE-80 | PO14297151936 | 100 | 285 | 500 | 627 | 5 | 2024-09-22 | 1204.69 | 30.12 | 2024-09-10 | 2 | 601.74 | 1 | 1204.69 | 14 | SO71866 | 2024-09-17 | 96.38 | 1203.49 | 602.35 | |||
SO43861_18 | 0CC0-4166-9E | PO16327172067 | 100 | 285 | 235 | 584 | 5 | 2021-11-22 | 173.04 | 4.33 | 2021-11-10 | 6 | 31.72 | 1 | 173.04 | 18 | SO43861 | 2021-11-17 | 13.84 | 190.35 | 28.84 | |||
SO69565_1 | F165-437F-B9 | PO9773181473 | 100 | 285 | 559 | 8 | 5 | 2024-08-22 | 12.14 | 0.30 | 2024-08-10 | 1 | 8.99 | 1 | 12.14 | 1 | SO69565 | 2024-08-17 | 0.97 | 8.99 | 12.14 | |||
SO51760_16 | 2C2D-41C9-8C | PO9918180623 | 100 | 285 | 577 | 260 | 5 | 2023-11-22 | 2186.73 | 54.67 | 2023-11-10 | 3 | 755.15 | 1 | 2186.73 | 16 | SO51760 | 2023-11-17 | 174.94 | 2265.45 | 728.91 | |||
SO46047_1 | 2520-47B8-B9 | PO16211157418 | 100 | 285 | 347 | 99 | 5 | 2022-08-22 | 8159.98 | 204.00 | 2022-08-10 | 4 | 1912.15 | 1 | 8159.98 | 1 | SO46047 | 2022-08-17 | 652.80 | 7648.62 | 2039.99 | |||
SO67260_33 | 6224-4229-B8 | PO522163557 | 100 | 285 | 222 | 676 | 5 | 2024-07-23 | 209.94 | 5.25 | 2024-07-11 | 10 | 13.09 | 1 | 209.94 | 33 | SO67260 | 2024-07-18 | 16.80 | 130.86 | 20.99 | |||
SO51864_13 | 2389-4E32-92 | PO5568126648 | 100 | 285 | 542 | 422 | 5 | 2023-11-22 | 97.18 | 2.43 | 2023-11-10 | 4 | 17.98 | 1 | 97.18 | 13 | SO51864 | 2023-11-17 | 7.77 | 71.91 | 24.29 | |||
SO46672_35 | FFCF-4848-99 | PO9831178966 | 100 | 285 | 462 | 81 | 5 | 2022-10-22 | 70.64 | 1.77 | 2022-10-10 | 5 | 9.71 | 1 | 70.64 | 35 | SO46672 | 2022-10-17 | 5.65 | 48.57 | 14.13 | |||
SO51775_39 | 5DF8-4C96-81 | PO2842127356 | 100 | 285 | 547 | 700 | 5 | 2023-11-22 | 48.59 | 1.21 | 2023-11-10 | 1 | 35.96 | 1 | 48.59 | 39 | SO51775 | 2023-11-17 | 3.89 | 35.96 | 48.59 | |||
SO65248_14 | A7B5-4EE1-98 | PO9599164617 | 100 | 285 | 386 | 170 | 5 | 2024-06-22 | 2689.18 | 67.23 | 2024-06-10 | 4 | 713.08 | 1 | 2689.18 | 14 | SO65248 | 2024-06-17 | 215.13 | 2852.32 | 672.29 | |||
SO67277_36 | 9AB3-4F34-85 | PO12644174121 | 100 | 272 | 517 | 530 | 5 | 2024-07-23 | 63.17 | 1.58 | 2024-07-11 | 2 | 23.37 | 1 | 63.17 | 36 | SO67277 | 2024-07-18 | 5.05 | 46.74 | 31.58 | |||
SO57074_11 | FF65-4261-97 | PO9918191120 | 100 | 285 | 492 | 260 | 5 | 2024-02-22 | 3011.73 | 75.29 | 2024-02-10 | 5 | 601.74 | 1 | 3011.73 | 11 | SO57074 | 2024-02-17 | 240.94 | 3008.72 | 602.35 | |||
SO47965_1 | 953F-437D-84 | PO19546111394 | 100 | 285 | 325 | 206 | 5 | 2023-02-22 | 939.59 | 23.49 | 2023-02-10 | 2 | 486.71 | 1 | 939.59 | 1 | SO47965 | 2023-02-17 | 75.17 | 973.41 | 469.79 | |||
SO57175_1 | 8997-4142-90 | PO7714123713 | 100 | 285 | 580 | 495 | 5 | 2024-02-22 | 1020.59 | 25.51 | 2024-02-10 | 1 | 1082.51 | 1 | 1020.59 | 1 | SO57175 | 2024-02-17 | 81.65 | 1082.51 | 1020.59 | |||
SO65242_10 | 0175-4222-B3 | PO14297142992 | 100 | 285 | 575 | 627 | 5 | 2024-06-22 | 4291.33 | 107.28 | 2024-06-10 | 3 | 1481.94 | 1 | 4291.33 | 10 | SO65242 | 2024-06-17 | 343.31 | 4445.81 | 1430.44 |
Generated 2024-11-10 02:05:32.839 UTC