[ROOT] dt FactResellerSale < WHERE DimSalesTerritoryId EQ '5' > SHUFFLE < SKIP 345 > < TAKE 56 >
56 items
FactResellerSaleId | CarrierTrackingNumber | CustomerPONumber | DimCurrencyId | DimEmployeeId | DimProductId | DimResellerId | DimSalesTerritoryId | DueDate | ExtendedAmount | Freight | OrderDate | OrderQuantity | ProductStandardCost | RevisionNumber | SalesAmount | SalesOrderLineNumber | SalesOrderNumber | ShipDate | TaxAmt | TotalProductCost | UnitPrice |
---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
SO46673_24 | 578D-4F7B-A6 | PO9657163155 | 100 | 285 | 410 | 315 | 5 | 2022-10-25 | 72.89 | 1.82 | 2022-10-13 | 2 | 26.97 | 1 | 72.89 | 24 | SO46673 | 2022-10-20 | 5.83 | 53.94 | 36.45 |
SO53474_22 | E5B6-4103-8D | PO15457187993 | 100 | 285 | 560 | 297 | 5 | 2023-12-26 | 2186.73 | 54.67 | 2023-12-14 | 3 | 755.15 | 1 | 2186.73 | 22 | SO53474 | 2023-12-21 | 174.94 | 2265.45 | 728.91 |
SO69513_6 | 21F8-4626-B9 | PO7598121355 | 100 | 285 | 408 | 45 | 5 | 2024-08-25 | 144.32 | 3.61 | 2024-08-13 | 2 | 53.40 | 1 | 144.32 | 6 | SO69513 | 2024-08-20 | 11.55 | 106.80 | 72.16 |
SO63144_1 | F622-47B8-BF | PO16965152780 | 100 | 285 | 605 | 441 | 5 | 2024-05-27 | 323.99 | 8.10 | 2024-05-15 | 1 | 343.65 | 1 | 323.99 | 1 | SO63144 | 2024-05-22 | 25.92 | 343.65 | 323.99 |
SO45270_17 | 61D0-418B-8C | PO19546173994 | 100 | 285 | 313 | 206 | 5 | 2022-05-28 | 4293.92 | 107.35 | 2022-05-16 | 2 | 2171.29 | 1 | 4293.92 | 17 | SO45270 | 2022-05-23 | 343.51 | 4342.59 | 2146.96 |
SO57162_23 | 83B5-43A6-BD | PO3596174424 | 100 | 285 | 594 | 476 | 5 | 2024-02-25 | 1016.98 | 25.42 | 2024-02-13 | 3 | 308.22 | 1 | 1016.98 | 23 | SO57162 | 2024-02-20 | 81.36 | 924.65 | 338.99 |
SO43875_5 | CE1F-4E31-89 | PO12586178184 | 100 | 285 | 232 | 278 | 5 | 2021-11-25 | 57.68 | 1.44 | 2021-11-13 | 2 | 31.72 | 1 | 57.68 | 5 | SO43875 | 2021-11-20 | 4.61 | 63.45 | 28.84 |
SO50703_23 | 4A3D-44CB-B3 | PO2813140706 | 100 | 283 | 323 | 90 | 5 | 2023-09-25 | 4228.15 | 105.70 | 2023-09-13 | 9 | 486.71 | 1 | 4228.15 | 23 | SO50703 | 2023-09-20 | 338.25 | 4380.36 | 469.79 |
SO50293_20 | D649-4CE8-91 | PO3596144572 | 100 | 285 | 401 | 476 | 5 | 2023-08-25 | 65.60 | 1.64 | 2023-08-13 | 1 | 48.55 | 1 | 65.60 | 20 | SO50293 | 2023-08-20 | 5.25 | 48.55 | 65.60 |
SO46672_13 | FFCF-4848-99 | PO9831178966 | 100 | 285 | 461 | 81 | 5 | 2022-10-25 | 215.98 | 5.40 | 2022-10-13 | 4 | 37.12 | 1 | 215.98 | 13 | SO46672 | 2022-10-20 | 17.28 | 148.48 | 53.99 |
SO51147_32 | C4D7-458D-A6 | PO9831167474 | 100 | 285 | 465 | 81 | 5 | 2023-10-25 | 88.16 | 2.20 | 2023-10-13 | 6 | 9.16 | 1 | 88.16 | 32 | SO51147 | 2023-10-20 | 7.05 | 54.96 | 14.69 |
SO50703_24 | 4A3D-44CB-B3 | PO2813140706 | 100 | 283 | 383 | 90 | 5 | 2023-09-25 | 2401.05 | 60.03 | 2023-09-13 | 4 | 605.65 | 1 | 2401.05 | 24 | SO50703 | 2023-09-20 | 192.08 | 2422.60 | 600.26 |
SO67348_30 | 4BD1-4782-A3 | PO9889141767 | 100 | 285 | 517 | 494 | 5 | 2024-07-26 | 221.09 | 5.53 | 2024-07-14 | 7 | 23.37 | 1 | 221.09 | 30 | SO67348 | 2024-07-21 | 17.69 | 163.61 | 31.58 |
SO49509_23 | 1105-4F75-BE | PO9599181538 | 100 | 285 | 375 | 170 | 5 | 2023-06-25 | 2617.88 | 65.45 | 2023-06-13 | 2 | 1320.68 | 1 | 2617.88 | 23 | SO49509 | 2023-06-20 | 209.43 | 2641.37 | 1308.94 |
SO49091_10 | 7A94-486D-8A | PO19546118667 | 100 | 285 | 379 | 206 | 5 | 2023-05-28 | 3926.81 | 98.17 | 2023-05-16 | 3 | 1320.68 | 1 | 3926.81 | 10 | SO49091 | 2023-05-23 | 314.15 | 3962.05 | 1308.94 |
SO65248_21 | A7B5-4EE1-98 | PO9599164617 | 100 | 285 | 382 | 170 | 5 | 2024-06-25 | 3361.47 | 84.04 | 2024-06-13 | 5 | 713.08 | 1 | 3361.47 | 21 | SO65248 | 2024-06-20 | 268.92 | 3565.40 | 672.29 |
SO45574_8 | 45BA-4B97-AB | PO9106197912 | 100 | 285 | 296 | 602 | 5 | 2022-06-25 | 714.70 | 17.87 | 2022-06-13 | 1 | 617.03 | 1 | 714.70 | 8 | SO45574 | 2022-06-20 | 57.18 | 617.03 | 714.70 |
SO65165_3 | E659-4F16-8A | PO18241154115 | 100 | 285 | 560 | 477 | 5 | 2024-06-25 | 728.91 | 18.22 | 2024-06-13 | 1 | 755.15 | 1 | 728.91 | 3 | SO65165 | 2024-06-20 | 58.31 | 755.15 | 728.91 |
SO63181_23 | CB4E-4CF5-87 | PO2842135731 | 100 | 285 | 384 | 700 | 5 | 2024-05-27 | 672.29 | 16.81 | 2024-05-15 | 1 | 713.08 | 1 | 672.29 | 23 | SO63181 | 2024-05-22 | 53.78 | 713.08 | 672.29 |
SO49869_19 | A2BD-4A89-93 | PO9657193666 | 100 | 285 | 456 | 315 | 5 | 2023-07-26 | 179.98 | 4.50 | 2023-07-14 | 4 | 30.93 | 1 | 179.98 | 19 | SO49869 | 2023-07-21 | 14.40 | 123.73 | 44.99 |
SO71844_2 | 410D-4079-9E | PO2813198985 | 100 | 283 | 487 | 90 | 5 | 2024-09-25 | 98.98 | 2.47 | 2024-09-13 | 3 | 20.57 | 1 | 98.98 | 2 | SO71844 | 2024-09-20 | 7.92 | 61.70 | 32.99 |
SO58993_21 | EEB4-42E9-B9 | PO14297167367 | 100 | 285 | 566 | 627 | 5 | 2024-03-26 | 445.41 | 11.14 | 2024-03-14 | 1 | 461.44 | 1 | 445.41 | 21 | SO58993 | 2024-03-21 | 35.63 | 461.44 | 445.41 |
SO51824_17 | A1F7-477E-BA | PO5800114202 | 100 | 285 | 556 | 63 | 5 | 2023-11-25 | 210.59 | 5.26 | 2023-11-13 | 2 | 77.92 | 1 | 210.59 | 17 | SO51824 | 2023-11-20 | 16.85 | 155.84 | 105.29 |
SO49473_26 | EAA2-43E2-87 | PO2813142084 | 100 | 283 | 323 | 90 | 5 | 2023-06-25 | 1409.38 | 35.23 | 2023-06-13 | 3 | 486.71 | 1 | 1409.38 | 26 | SO49473 | 2023-06-20 | 112.75 | 1460.12 | 469.79 |
SO67277_4 | 9AB3-4F34-85 | PO12644174121 | 100 | 272 | 532 | 530 | 5 | 2024-07-26 | 149.87 | 3.75 | 2024-07-14 | 1 | 136.79 | 1 | 149.87 | 4 | SO67277 | 2024-07-21 | 11.99 | 136.79 | 149.87 |
SO51746_1 | 719B-4DC5-B3 | PO11542153436 | 100 | 285 | 545 | 62 | 5 | 2023-11-25 | 24.29 | 0.61 | 2023-11-13 | 1 | 17.98 | 1 | 24.29 | 1 | SO51746 | 2023-11-20 | 1.94 | 17.98 | 24.29 |
SO53530_28 | A31D-483D-A1 | PO2813121313 | 100 | 283 | 434 | 90 | 5 | 2023-12-26 | 2498.29 | 62.46 | 2023-12-14 | 7 | 360.94 | 1 | 2498.29 | 28 | SO53530 | 2023-12-21 | 199.86 | 2526.60 | 356.90 |
SO67277_33 | 9AB3-4F34-85 | PO12644174121 | 100 | 272 | 542 | 530 | 5 | 2024-07-26 | 24.29 | 0.61 | 2024-07-14 | 1 | 17.98 | 1 | 24.29 | 33 | SO67277 | 2024-07-21 | 1.94 | 17.98 | 24.29 |
SO50293_16 | D649-4CE8-91 | PO3596144572 | 100 | 285 | 356 | 476 | 5 | 2023-08-25 | 2485.70 | 62.14 | 2023-08-13 | 2 | 1117.86 | 1 | 2485.70 | 16 | SO50293 | 2023-08-20 | 198.86 | 2235.71 | 1242.85 |
SO58989_3 | 0A23-4D44-A4 | PO11977137958 | 100 | 285 | 440 | 675 | 5 | 2024-03-26 | 1717.80 | 42.95 | 2024-03-14 | 2 | 868.63 | 1 | 1717.80 | 3 | SO58989 | 2024-03-21 | 137.42 | 1737.27 | 858.90 |
SO44133_14 | 4899-4DD6-93 | PO9599144193 | 100 | 285 | 285 | 170 | 5 | 2021-12-26 | 535.74 | 13.39 | 2021-12-14 | 3 | 176.20 | 1 | 535.74 | 14 | SO44133 | 2021-12-21 | 42.86 | 528.60 | 178.58 |
SO53524_51 | 2B2B-440F-8B | PO1537151724 | 100 | 285 | 231 | 611 | 5 | 2023-12-26 | 119.98 | 3.00 | 2023-12-14 | 4 | 38.49 | 1 | 119.98 | 51 | SO53524 | 2023-12-21 | 9.60 | 153.97 | 29.99 |
SO69465_42 | B8B2-4B14-99 | PO2842153886 | 100 | 285 | 465 | 700 | 5 | 2024-08-25 | 88.16 | 2.20 | 2024-08-13 | 6 | 9.16 | 1 | 88.16 | 42 | SO69465 | 2024-08-20 | 7.05 | 54.96 | 14.69 |
SO44309_4 | F0DB-4889-AC | PO3393112350 | 100 | 285 | 314 | 549 | 5 | 2022-01-25 | 4293.92 | 107.35 | 2022-01-13 | 2 | 2171.29 | 1 | 4293.92 | 4 | SO44309 | 2022-01-20 | 343.51 | 4342.59 | 2146.96 |
SO44518_15 | 359F-48A3-B9 | PO12586169040 | 100 | 285 | 347 | 278 | 5 | 2022-02-25 | 12239.96 | 306.00 | 2022-02-13 | 6 | 1912.15 | 1 | 12239.96 | 15 | SO44518 | 2022-02-20 | 979.20 | 11472.93 | 2039.99 |
SO44133_6 | 4899-4DD6-93 | PO9599144193 | 100 | 285 | 338 | 170 | 5 | 2021-12-26 | 419.46 | 10.49 | 2021-12-14 | 1 | 413.15 | 1 | 419.46 | 6 | SO44133 | 2021-12-21 | 33.56 | 413.15 | 419.46 |
SO45802_10 | 8C6D-42B3-AA | PO1189157476 | 100 | 285 | 334 | 423 | 5 | 2022-07-26 | 838.92 | 20.97 | 2022-07-14 | 2 | 413.15 | 1 | 838.92 | 10 | SO45802 | 2022-07-21 | 67.11 | 826.29 | 419.46 |
SO44555_5 | 51FA-451D-A2 | PO6293176988 | 100 | 285 | 315 | 612 | 5 | 2022-02-25 | 1749.59 | 43.74 | 2022-02-13 | 2 | 884.71 | 1 | 1749.59 | 5 | SO44555 | 2022-02-20 | 139.97 | 1769.42 | 874.79 |
SO51693_29 | 6FEB-4D5B-92 | PO19546179477 | 100 | 285 | 546 | 206 | 5 | 2023-11-25 | 74.51 | 1.86 | 2023-11-13 | 2 | 27.57 | 1 | 74.51 | 29 | SO51693 | 2023-11-20 | 5.96 | 55.14 | 37.25 |
SO44306_10 | 464C-43BA-9F | PO1189114917 | 100 | 285 | 272 | 423 | 5 | 2022-01-25 | 367.88 | 9.20 | 2022-01-13 | 2 | 181.49 | 1 | 367.88 | 10 | SO44306 | 2022-01-20 | 29.43 | 362.97 | 183.94 |
SO57017_12 | 4C6E-47EA-AD | PO19546126186 | 100 | 285 | 545 | 206 | 5 | 2024-02-25 | 48.59 | 1.21 | 2024-02-13 | 2 | 17.98 | 1 | 48.59 | 12 | SO57017 | 2024-02-20 | 3.89 | 35.96 | 24.29 |
SO47681_6 | 0580-4A09-A8 | PO12644124767 | 100 | 285 | 308 | 530 | 5 | 2023-01-25 | 744.27 | 18.61 | 2023-01-13 | 1 | 660.91 | 1 | 744.27 | 6 | SO47681 | 2023-01-20 | 59.54 | 660.91 | 744.27 |
SO69451_4 | EE16-4615-B7 | PO9918189570 | 100 | 285 | 506 | 260 | 5 | 2024-08-25 | 400.10 | 10.00 | 2024-08-13 | 2 | 199.85 | 1 | 400.10 | 4 | SO69451 | 2024-08-20 | 32.01 | 399.70 | 200.05 |
SO71866_32 | 029A-46BE-80 | PO14297151936 | 100 | 285 | 569 | 627 | 5 | 2024-09-25 | 445.41 | 11.14 | 2024-09-13 | 1 | 461.44 | 1 | 445.41 | 32 | SO71866 | 2024-09-20 | 35.63 | 461.44 | 445.41 |
SO49822_10 | 191D-4AD7-93 | PO522119337 | 100 | 285 | 419 | 676 | 5 | 2023-07-26 | 52.65 | 1.32 | 2023-07-14 | 1 | 38.96 | 1 | 52.65 | 10 | SO49822 | 2023-07-21 | 4.21 | 38.96 | 52.65 |
SO55281_1 | E19D-4F17-B4 | PO18850196229 | 100 | 285 | 605 | 117 | 5 | 2024-01-25 | 323.99 | 8.10 | 2024-01-13 | 1 | 343.65 | 1 | 323.99 | 1 | SO55281 | 2024-01-20 | 25.92 | 343.65 | 323.99 |
SO45289_4 | 741A-40B6-8E | PO16211190433 | 100 | 285 | 218 | 99 | 5 | 2022-05-28 | 11.40 | 0.29 | 2022-05-16 | 2 | 3.40 | 1 | 11.40 | 4 | SO45289 | 2022-05-23 | 0.91 | 6.79 | 5.70 |
SO45805_14 | 4E35-406B-B7 | PO3393138494 | 100 | 285 | 322 | 549 | 5 | 2022-07-26 | 419.46 | 10.49 | 2022-07-14 | 1 | 413.15 | 1 | 419.46 | 14 | SO45805 | 2022-07-21 | 33.56 | 413.15 | 419.46 |
SO69518_25 | 96AA-48F8-80 | PO5800191682 | 100 | 285 | 544 | 63 | 5 | 2024-08-25 | 437.35 | 10.93 | 2024-08-13 | 9 | 35.96 | 1 | 437.35 | 25 | SO69518 | 2024-08-20 | 34.99 | 323.64 | 48.59 |
SO44801_17 | 4DBD-4E98-A7 | PO9599152040 | 100 | 285 | 313 | 170 | 5 | 2022-03-27 | 4293.92 | 107.35 | 2022-03-15 | 2 | 2171.29 | 1 | 4293.92 | 17 | SO44801 | 2022-03-22 | 343.51 | 4342.59 | 2146.96 |
SO49149_18 | D41E-4EFF-A5 | PO5858123072 | 100 | 285 | 428 | 566 | 5 | 2023-05-28 | 209.26 | 5.23 | 2023-05-16 | 1 | 185.82 | 1 | 209.26 | 18 | SO49149 | 2023-05-23 | 16.74 | 185.82 | 209.26 |
SO47042_39 | 42DB-4E2E-B9 | PO5858114009 | 100 | 285 | 445 | 566 | 5 | 2022-11-25 | 143.98 | 3.60 | 2022-11-13 | 4 | 24.75 | 1 | 143.98 | 39 | SO47042 | 2022-11-20 | 11.52 | 98.98 | 35.99 |
SO49509_5 | 1105-4F75-BE | PO9599181538 | 100 | 285 | 343 | 170 | 5 | 2023-06-25 | 1409.38 | 35.23 | 2023-06-13 | 3 | 486.71 | 1 | 1409.38 | 5 | SO49509 | 2023-06-20 | 112.75 | 1460.12 | 469.79 |
SO51718_21 | 27D3-4968-89 | PO15051113417 | 100 | 285 | 471 | 207 | 5 | 2023-11-25 | 190.50 | 4.76 | 2023-11-13 | 5 | 23.75 | 1 | 190.50 | 21 | SO51718 | 2023-11-20 | 15.24 | 118.75 | 38.10 |
SO44565_1 | 6A99-4B08-B3 | PO7714127691 | 100 | 285 | 342 | 495 | 5 | 2022-02-25 | 419.46 | 10.49 | 2022-02-13 | 1 | 413.15 | 1 | 419.46 | 1 | SO44565 | 2022-02-20 | 33.56 | 413.15 | 419.46 |
SO49878_7 | 3EF0-4F28-B3 | PO3741190259 | 100 | 285 | 224 | 404 | 5 | 2023-07-26 | 20.75 | 0.52 | 2023-07-14 | 4 | 5.23 | 1 | 20.75 | 7 | SO49878 | 2023-07-21 | 1.66 | 20.92 | 5.19 |
Generated 2024-11-13 03:39:56.984 UTC