[ROOT] dt FactResellerSale WHERE DimSalesTerritoryId EQ '1' > SHUFFLE < SKIP 7195 > < 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 |
---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
SO45296_8 | 1FA6-4616-B7 | PO14471199142 | 100 | 286 | 304 | 145 | 1 | 2022-05-26 | 714.70 | 17.87 | 2022-05-14 | 1 | 617.03 | 1 | 714.70 | 8 | SO45296 | 2022-05-21 | 57.18 | 617.03 | 714.70 | |||
SO46957_3 | C98D-43A5-8A | PO16414179284 | 100 | 289 | 464 | 236 | 1 | 2022-11-23 | 127.16 | 3.18 | 2022-11-11 | 9 | 9.71 | 1 | 127.16 | 3 | SO46957 | 2022-11-18 | 10.17 | 87.42 | 14.13 | |||
SO63202_15 | 5C83-47EE-AA | PO15631193825 | 100 | 282 | 596 | 43 | 1 | 2024-05-25 | 323.99 | 8.10 | 2024-05-13 | 1 | 294.58 | 1 | 323.99 | 15 | SO63202 | 2024-05-20 | 25.92 | 294.58 | 323.99 | |||
SO48757_3 | C817-44D2-B4 | PO16588132026 | 100 | 289 | 409 | 146 | 1 | 2023-04-25 | 627.77 | 15.69 | 2023-04-13 | 3 | 185.82 | 1 | 627.77 | 3 | SO48757 | 2023-04-20 | 50.22 | 557.46 | 209.26 | |||
SO63156_4 | B5C5-474E-8D | PO14587116412 | 100 | 293 | 493 | 199 | 1 | 2024-05-25 | 200.05 | 5.00 | 2024-05-13 | 1 | 199.85 | 1 | 200.05 | 4 | SO63156 | 2024-05-20 | 16.00 | 199.85 | 200.05 | |||
SO47694_27 | 8253-4E13-9D | PO899122764 | 100 | 289 | 433 | 290 | 1 | 2023-01-23 | 1622.26 | 40.56 | 2023-01-11 | 5 | 300.12 | 1 | 1622.26 | 27 | SO47694 | 2023-01-18 | 129.78 | 1500.59 | 324.45 | |||
SO43848_5 | FB94-4C38-B1 | PO18908190536 | 100 | 289 | 344 | 164 | 1 | 2021-11-23 | 4079.99 | 102.00 | 2021-11-11 | 2 | 1912.15 | 1 | 4079.99 | 5 | SO43848 | 2021-11-18 | 326.40 | 3824.31 | 2039.99 | |||
SO49861_1 | C812-4BE2-8D | PO15602115974 | 100 | 282 | 412 | 7 | 1 | 2023-07-24 | 540.39 | 13.51 | 2023-07-12 | 3 | 133.30 | 1 | 540.39 | 1 | SO49861 | 2023-07-19 | 43.23 | 399.89 | 180.13 | |||
SO47986_19 | 3373-4C22-A9 | PO16414116972 | 100 | 289 | 396 | 236 | 1 | 2023-02-23 | 149.68 | 3.74 | 2023-02-11 | 2 | 55.38 | 1 | 149.68 | 19 | SO47986 | 2023-02-18 | 11.97 | 110.76 | 74.84 | |||
SO63131_5 | E035-4732-84 | PO18676136384 | 100 | 282 | 595 | 697 | 1 | 2024-05-25 | 677.99 | 16.95 | 2024-05-13 | 2 | 308.22 | 1 | 677.99 | 5 | SO63131 | 2024-05-20 | 54.24 | 616.44 | 338.99 | |||
SO50693_19 | 0DA5-4EE4-93 | PO841149385 | 100 | 286 | 230 | 254 | 1 | 2023-09-23 | 28.84 | 0.72 | 2023-09-11 | 1 | 29.08 | 1 | 28.84 | 19 | SO50693 | 2023-09-18 | 2.31 | 29.08 | 28.84 | |||
SO65252_15 | F817-49F6-A9 | PO12470159616 | 100 | 287 | 500 | 672 | 1 | 2024-06-23 | 1204.69 | 30.12 | 2024-06-11 | 2 | 601.74 | 1 | 1204.69 | 15 | SO65252 | 2024-06-18 | 96.38 | 1203.49 | 602.35 | |||
SO57111_1 | 8478-4B8E-95 | PO14181151887 | 100 | 272 | 475 | 307 | 1 | 2024-02-23 | 209.97 | 5.25 | 2024-02-11 | 5 | 26.18 | 1 | 209.97 | 1 | SO57111 | 2024-02-18 | 16.80 | 130.88 | 41.99 | |||
SO59019_5 | 5F5A-465D-A8 | PO7192182554 | 100 | 289 | 234 | 20 | 1 | 2024-03-24 | 59.99 | 1.50 | 2024-03-12 | 2 | 38.49 | 1 | 59.99 | 5 | SO59019 | 2024-03-19 | 4.80 | 76.98 | 29.99 | |||
SO61267_7 | BCFD-47EE-BD | PO7076191943 | 100 | 293 | 507 | 505 | 1 | 2024-04-24 | 200.05 | 5.00 | 2024-04-12 | 1 | 199.85 | 1 | 200.05 | 7 | SO61267 | 2024-04-19 | 16.00 | 199.85 | 200.05 | |||
SO48001_19 | 02F1-4434-99 | PO14442151969 | 100 | 293 | 469 | 127 | 1 | 2023-02-23 | 91.18 | 2.28 | 2023-02-11 | 4 | 15.67 | 1 | 91.18 | 19 | SO48001 | 2023-02-18 | 7.29 | 62.68 | 22.79 | |||
SO48385_5 | 753C-4EBE-B8 | PO7946110963 | 100 | 282 | 343 | 438 | 1 | 2023-03-25 | 939.59 | 23.49 | 2023-03-13 | 2 | 486.71 | 1 | 939.59 | 5 | SO48385 | 2023-03-20 | 75.17 | 973.41 | 469.79 | |||
SO49849_8 | C8F3-4DDE-A6 | PO2552190786 | 100 | 286 | 410 | 506 | 1 | 2023-07-24 | 72.89 | 1.82 | 2023-07-12 | 2 | 26.97 | 1 | 72.89 | 8 | SO49849 | 2023-07-19 | 5.83 | 53.94 | 36.45 | |||
SO51783_18 | B7A2-49BC-89 | PO18676114917 | 100 | 282 | 551 | 697 | 1 | 2023-11-23 | 475.29 | 11.88 | 2023-11-11 | 3 | 144.59 | 1 | 475.29 | 18 | SO51783 | 2023-11-18 | 38.02 | 433.78 | 158.43 | |||
SO45790_3 | 4BF3-4DED-94 | PO13978116594 | 100 | 289 | 264 | 200 | 1 | 2022-07-24 | 551.81 | 13.80 | 2022-07-12 | 3 | 181.49 | 1 | 551.81 | 3 | SO45790 | 2022-07-19 | 44.15 | 544.46 | 183.94 | |||
SO46348_9 | CF4C-437D-97 | PO13543132672 | 100 | 287 | 296 | 293 | 1 | 2022-09-23 | 2144.11 | 53.60 | 2022-09-11 | 3 | 617.03 | 1 | 2144.11 | 9 | SO46348 | 2022-09-18 | 171.53 | 1851.08 | 714.70 | |||
SO47054_35 | E4B1-4C58-AE | PO7627150376 | 100 | 286 | 407 | 433 | 1 | 2022-11-23 | 196.81 | 4.92 | 2022-11-11 | 3 | 48.55 | 1 | 196.81 | 35 | SO47054 | 2022-11-18 | 15.74 | 145.64 | 65.60 | |||
SO51723_5 | 4D27-4A2E-A7 | PO14529141662 | 100 | 293 | 544 | 289 | 1 | 2023-11-23 | 48.59 | 1.21 | 2023-11-11 | 1 | 35.96 | 1 | 48.59 | 5 | SO51723 | 2023-11-18 | 3.89 | 35.96 | 48.59 | |||
SO58963_26 | 6ADC-4485-8C | PO841129336 | 100 | 286 | 400 | 254 | 1 | 2024-03-24 | 111.46 | 2.79 | 2024-03-12 | 3 | 27.49 | 1 | 111.46 | 26 | SO58963 | 2024-03-19 | 8.92 | 82.48 | 37.15 | |||
SO69521_15 | EAFC-4D00-94 | PO6148143676 | 100 | 289 | 502 | 693 | 1 | 2024-08-23 | 600.16 | 15.00 | 2024-08-11 | 3 | 199.85 | 1 | 600.16 | 15 | SO69521 | 2024-08-18 | 48.01 | 599.56 | 200.05 | |||
SO44489_2 | 165A-4B70-89 | PO18908177526 | 100 | 289 | 218 | 3 | 164 | 1 | 4.70 | 2022-02-23 | 94.05 | 2.23 | 2022-02-11 | 18 | 3.40 | 1 | 89.35 | 2 | SO44489 | 2022-02-18 | 7.15 | 61.13 | 5.23 | 0.05 |
SO55241_36 | F7DC-49D7-89 | PO16588188882 | 100 | 289 | 597 | 146 | 1 | 2024-01-23 | 323.99 | 8.10 | 2024-01-11 | 1 | 294.58 | 1 | 323.99 | 36 | SO55241 | 2024-01-18 | 25.92 | 294.58 | 323.99 | |||
SO50210_5 | 6347-4C03-9B | PO15631112842 | 100 | 282 | 399 | 43 | 1 | 2023-08-23 | 67.55 | 1.69 | 2023-08-11 | 2 | 24.99 | 1 | 67.55 | 5 | SO50210 | 2023-08-18 | 5.40 | 49.99 | 33.77 |
Generated 2024-11-10 16:00:38.759 UTC