[ROOT] dt FactResellerSale < WHERE DimSalesTerritoryId EQ '5' > SHUFFLE < SKIP 2437 > < TAKE 62 >
62 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 |
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
| SO46045_19 | 9345-48CB-A5 | PO16327127643 | 100 | 285 | 279 | 584 | 5 | 2022-08-22 | 535.74 | 13.39 | 2022-08-10 | 3 | 176.20 | 1 | 535.74 | 19 | SO46045 | 2022-08-17 | 42.86 | 528.60 | 178.58 | |||
| SO57088_22 | EA31-4951-8A | PO2842199218 | 100 | 285 | 604 | 700 | 5 | 2024-02-22 | 323.99 | 8.10 | 2024-02-10 | 1 | 343.65 | 1 | 323.99 | 22 | SO57088 | 2024-02-17 | 25.92 | 343.65 | 323.99 | |||
| SO47042_30 | 42DB-4E2E-B9 | PO5858114009 | 100 | 285 | 224 | 2 | 566 | 5 | 1.20 | 2022-11-22 | 60.16 | 1.47 | 2022-11-10 | 12 | 5.23 | 1 | 58.96 | 30 | SO47042 | 2022-11-17 | 4.72 | 62.76 | 5.01 | 0.02 |
| SO47067_7 | DDEC-4319-8A | PO9512118933 | 100 | 285 | 263 | 135 | 5 | 2022-11-22 | 404.66 | 10.12 | 2022-11-10 | 2 | 187.16 | 1 | 404.66 | 7 | SO47067 | 2022-11-17 | 32.37 | 374.31 | 202.33 | |||
| SO63245_17 | 1025-4AD1-A1 | PO5800120355 | 100 | 285 | 551 | 63 | 5 | 2024-05-24 | 158.43 | 3.96 | 2024-05-12 | 1 | 144.59 | 1 | 158.43 | 17 | SO63245 | 2024-05-19 | 12.67 | 144.59 | 158.43 | |||
| SO59071_9 | EFC3-4244-A6 | PO9599176835 | 100 | 285 | 584 | 170 | 5 | 2024-03-23 | 647.99 | 16.20 | 2024-03-11 | 2 | 343.65 | 1 | 647.99 | 9 | SO59071 | 2024-03-18 | 51.84 | 687.30 | 323.99 | |||
| SO51108_35 | 8650-4A20-B1 | PO12644151814 | 100 | 285 | 231 | 530 | 5 | 2023-10-22 | 149.97 | 3.75 | 2023-10-10 | 5 | 38.49 | 1 | 149.97 | 35 | SO51108 | 2023-10-17 | 12.00 | 192.46 | 29.99 | |||
| SO53524_44 | 2B2B-440F-8B | PO1537151724 | 100 | 285 | 472 | 611 | 5 | 2023-12-23 | 152.40 | 3.81 | 2023-12-11 | 4 | 23.75 | 1 | 152.40 | 44 | SO53524 | 2023-12-18 | 12.19 | 95.00 | 38.10 | |||
| SO48090_10 | E7D1-44A3-B2 | PO9512117066 | 100 | 285 | 433 | 135 | 5 | 2023-02-22 | 648.91 | 16.22 | 2023-02-10 | 2 | 300.12 | 1 | 648.91 | 10 | SO48090 | 2023-02-17 | 51.91 | 600.24 | 324.45 | |||
| SO45288_6 | D4D0-4662-A9 | PO16327170541 | 100 | 285 | 317 | 584 | 5 | 2022-05-25 | 874.79 | 21.87 | 2022-05-13 | 1 | 884.71 | 1 | 874.79 | 6 | SO45288 | 2022-05-20 | 69.98 | 884.71 | 874.79 | |||
| SO65210_20 | 08E4-4CC9-A7 | PO2813181442 | 100 | 283 | 491 | 90 | 5 | 2024-06-22 | 194.36 | 4.86 | 2024-06-10 | 6 | 41.57 | 1 | 194.36 | 20 | SO65210 | 2024-06-17 | 15.55 | 249.43 | 32.39 | |||
| SO58974_15 | FB64-4792-81 | PO2813115918 | 100 | 283 | 434 | 90 | 5 | 2024-03-23 | 2141.39 | 53.53 | 2024-03-11 | 6 | 360.94 | 1 | 2141.39 | 15 | SO58974 | 2024-03-18 | 171.31 | 2165.66 | 356.90 | |||
| SO44116_3 | 1D67-419C-A1 | PO4089171650 | 100 | 285 | 344 | 368 | 5 | 2021-12-23 | 2039.99 | 51.00 | 2021-12-11 | 1 | 1912.15 | 1 | 2039.99 | 3 | SO44116 | 2021-12-18 | 163.20 | 1912.15 | 2039.99 | |||
| SO48359_43 | BFAE-4CA5-83 | PO2813116854 | 100 | 272 | 457 | 90 | 5 | 2023-03-24 | 269.96 | 6.75 | 2023-03-12 | 6 | 30.93 | 1 | 269.96 | 43 | SO48359 | 2023-03-19 | 21.60 | 185.60 | 44.99 | |||
| SO48752_1 | 6272-4B8A-84 | PO12615149669 | 100 | 285 | 367 | 440 | 5 | 2023-04-24 | 647.99 | 16.20 | 2023-04-12 | 1 | 598.44 | 1 | 647.99 | 1 | SO48752 | 2023-04-19 | 51.84 | 598.44 | 647.99 | |||
| SO67260_35 | 6224-4229-B8 | PO522163557 | 100 | 285 | 600 | 676 | 5 | 2024-07-23 | 971.98 | 24.30 | 2024-07-11 | 3 | 294.58 | 1 | 971.98 | 35 | SO67260 | 2024-07-18 | 77.76 | 883.74 | 323.99 | |||
| SO71839_15 | 8F89-4B1E-A8 | PO1537119063 | 100 | 285 | 234 | 611 | 5 | 2024-09-22 | 299.94 | 7.50 | 2024-09-10 | 10 | 38.49 | 1 | 299.94 | 15 | SO71839 | 2024-09-17 | 24.00 | 384.92 | 29.99 | |||
| SO43875_13 | CE1F-4E31-89 | PO12586178184 | 100 | 285 | 345 | 278 | 5 | 2021-11-22 | 4079.99 | 102.00 | 2021-11-10 | 2 | 1912.15 | 1 | 4079.99 | 13 | SO43875 | 2021-11-17 | 326.40 | 3824.31 | 2039.99 | |||
| SO71802_15 | 6B80-41A7-89 | PO15457184141 | 100 | 285 | 571 | 297 | 5 | 2024-09-22 | 890.82 | 22.27 | 2024-09-10 | 2 | 461.44 | 1 | 890.82 | 15 | SO71802 | 2024-09-17 | 71.27 | 922.89 | 445.41 | |||
| SO65207_8 | B20E-440F-A3 | PO1537156240 | 100 | 285 | 214 | 611 | 5 | 2024-06-22 | 125.96 | 3.15 | 2024-06-10 | 6 | 13.09 | 1 | 125.96 | 8 | SO65207 | 2024-06-17 | 10.08 | 78.52 | 20.99 | |||
| SO48063_4 | AEA4-4489-90 | PO5858143254 | 100 | 285 | 224 | 566 | 5 | 2023-02-22 | 51.87 | 1.30 | 2023-02-10 | 10 | 5.23 | 1 | 51.87 | 4 | SO48063 | 2023-02-17 | 4.15 | 52.30 | 5.19 | |||
| SO71839_41 | 8F89-4B1E-A8 | PO1537119063 | 100 | 285 | 523 | 611 | 5 | 2024-09-22 | 31.58 | 0.79 | 2024-09-10 | 1 | 23.37 | 1 | 31.58 | 41 | SO71839 | 2024-09-17 | 2.53 | 23.37 | 31.58 | |||
| SO48760_10 | D682-4FD4-94 | PO9657199450 | 100 | 285 | 453 | 315 | 5 | 2023-04-24 | 35.99 | 0.90 | 2023-04-12 | 1 | 24.75 | 1 | 35.99 | 10 | SO48760 | 2023-04-19 | 2.88 | 24.75 | 35.99 | |||
| SO45563_1 | BFF8-43A8-AF | PO5307147884 | 100 | 285 | 293 | 369 | 5 | 2022-06-22 | 1445.19 | 36.13 | 2022-06-10 | 2 | 623.84 | 1 | 1445.19 | 1 | SO45563 | 2022-06-17 | 115.62 | 1247.68 | 722.59 | |||
| SO65207_28 | B20E-440F-A3 | PO1537156240 | 100 | 285 | 225 | 611 | 5 | 2024-06-22 | 32.36 | 0.81 | 2024-06-10 | 6 | 6.92 | 1 | 32.36 | 28 | SO65207 | 2024-06-17 | 2.59 | 41.53 | 5.39 | |||
| SO58924_17 | D17F-4E31-90 | PO15457121920 | 100 | 285 | 586 | 297 | 5 | 2024-03-23 | 1336.23 | 33.41 | 2024-03-11 | 3 | 461.44 | 1 | 1336.23 | 17 | SO58924 | 2024-03-18 | 106.90 | 1384.33 | 445.41 | |||
| SO45805_5 | 4E35-406B-B7 | PO3393138494 | 100 | 285 | 324 | 549 | 5 | 2022-07-23 | 1258.38 | 31.46 | 2022-07-11 | 3 | 413.15 | 1 | 1258.38 | 5 | SO45805 | 2022-07-18 | 100.67 | 1239.44 | 419.46 | |||
| SO45077_8 | 4002-46AC-B7 | PO10179199539 | 100 | 285 | 218 | 27 | 5 | 2022-04-24 | 11.40 | 0.29 | 2022-04-12 | 2 | 3.40 | 1 | 11.40 | 8 | SO45077 | 2022-04-19 | 0.91 | 6.79 | 5.70 | |||
| SO51718_10 | 27D3-4968-89 | PO15051113417 | 100 | 285 | 544 | 207 | 5 | 2023-11-22 | 194.38 | 4.86 | 2023-11-10 | 4 | 35.96 | 1 | 194.38 | 10 | SO51718 | 2023-11-17 | 15.55 | 143.84 | 48.59 | |||
| SO47703_2 | 0E62-43AC-8E | PO3741184156 | 100 | 285 | 224 | 404 | 5 | 2023-01-22 | 5.19 | 0.13 | 2023-01-10 | 1 | 5.23 | 1 | 5.19 | 2 | SO47703 | 2023-01-17 | 0.41 | 5.23 | 5.19 | |||
| SO57149_10 | C32D-4E78-97 | PO5568130124 | 100 | 285 | 225 | 422 | 5 | 2024-02-22 | 10.79 | 0.27 | 2024-02-10 | 2 | 6.92 | 1 | 10.79 | 10 | SO57149 | 2024-02-17 | 0.86 | 13.84 | 5.39 | |||
| SO69465_6 | B8B2-4B14-99 | PO2842153886 | 100 | 285 | 472 | 700 | 5 | 2024-08-22 | 152.40 | 3.81 | 2024-08-10 | 4 | 23.75 | 1 | 152.40 | 6 | SO69465 | 2024-08-17 | 12.19 | 95.00 | 38.10 | |||
| SO67348_2 | 4BD1-4782-A3 | PO9889141767 | 100 | 285 | 533 | 494 | 5 | 2024-07-23 | 299.75 | 7.49 | 2024-07-11 | 2 | 136.79 | 1 | 299.75 | 2 | SO67348 | 2024-07-18 | 23.98 | 273.57 | 149.87 | |||
| SO43693_1 | EC62-4BB3-9B | PO8120182325 | 100 | 281 | 235 | 485 | 5 | 2021-10-22 | 86.52 | 2.16 | 2021-10-10 | 3 | 31.72 | 1 | 86.52 | 1 | SO43693 | 2021-10-17 | 6.92 | 95.17 | 28.84 | |||
| SO67277_41 | 9AB3-4F34-85 | PO12644174121 | 100 | 272 | 234 | 530 | 5 | 2024-07-23 | 209.96 | 5.25 | 2024-07-11 | 7 | 38.49 | 1 | 209.96 | 41 | SO67277 | 2024-07-18 | 16.80 | 269.45 | 29.99 | |||
| SO50307_6 | C275-40B9-98 | PO6293157460 | 100 | 285 | 321 | 612 | 5 | 2023-08-22 | 469.79 | 11.74 | 2023-08-10 | 1 | 486.71 | 1 | 469.79 | 6 | SO50307 | 2023-08-17 | 37.58 | 486.71 | 469.79 | |||
| SO47725_48 | 2501-4A1D-99 | PO9831133395 | 100 | 285 | 447 | 81 | 5 | 2023-01-22 | 45.00 | 1.13 | 2023-01-10 | 3 | 10.31 | 1 | 45.00 | 48 | SO47725 | 2023-01-17 | 3.60 | 30.94 | 15.00 | |||
| SO48734_2 | F5F8-4E2A-98 | PO12644188680 | 100 | 285 | 352 | 530 | 5 | 2023-04-24 | 2485.70 | 62.14 | 2023-04-12 | 2 | 1117.86 | 1 | 2485.70 | 2 | SO48734 | 2023-04-19 | 198.86 | 2235.71 | 1242.85 | |||
| SO45779_1 | 983F-42E3-90 | PO522162183 | 100 | 285 | 348 | 676 | 5 | 2022-07-23 | 4049.99 | 101.25 | 2022-07-11 | 2 | 1898.09 | 1 | 4049.99 | 1 | SO45779 | 2022-07-18 | 324.00 | 3796.19 | 2024.99 | |||
| SO53524_45 | 2B2B-440F-8B | PO1537151724 | 100 | 285 | 585 | 13 | 611 | 5 | 50.11 | 2023-12-23 | 334.06 | 7.10 | 2023-12-11 | 1 | 461.44 | 1 | 283.95 | 45 | SO53524 | 2023-12-18 | 22.72 | 461.44 | 334.06 | 0.15 |
| SO71909_1 | 2E44-4C3C-BC | PO4089160365 | 100 | 285 | 359 | 368 | 5 | 2024-09-22 | 5507.98 | 137.70 | 2024-09-10 | 4 | 1251.98 | 1 | 5507.98 | 1 | SO71909 | 2024-09-17 | 440.64 | 5007.93 | 1376.99 | |||
| SO43695_7 | A89C-4D25-B9 | PO10179176559 | 100 | 285 | 218 | 27 | 5 | 2021-10-22 | 11.40 | 0.29 | 2021-10-10 | 2 | 3.40 | 1 | 11.40 | 7 | SO43695 | 2021-10-17 | 0.91 | 6.79 | 5.70 | |||
| SO65242_2 | 0175-4222-B3 | PO14297142992 | 100 | 285 | 555 | 627 | 5 | 2024-06-22 | 63.90 | 1.60 | 2024-06-10 | 1 | 47.29 | 1 | 63.90 | 2 | SO65242 | 2024-06-17 | 5.11 | 47.29 | 63.90 | |||
| SO44309_14 | F0DB-4889-AC | PO3393112350 | 100 | 285 | 311 | 549 | 5 | 2022-01-22 | 2146.96 | 53.67 | 2022-01-10 | 1 | 2171.29 | 1 | 2146.96 | 14 | SO44309 | 2022-01-17 | 171.76 | 2171.29 | 2146.96 | |||
| SO49149_29 | D41E-4EFF-A5 | PO5858123072 | 100 | 285 | 410 | 566 | 5 | 2023-05-25 | 72.89 | 1.82 | 2023-05-13 | 2 | 26.97 | 1 | 72.89 | 29 | SO49149 | 2023-05-20 | 5.83 | 53.94 | 36.45 | |||
| SO57126_13 | 6350-4E4D-85 | PO7598164370 | 100 | 285 | 376 | 45 | 5 | 2024-02-22 | 2932.02 | 73.30 | 2024-02-10 | 2 | 1554.95 | 1 | 2932.02 | 13 | SO57126 | 2024-02-17 | 234.56 | 3109.90 | 1466.01 | |||
| SO65242_11 | 0175-4222-B3 | PO14297142992 | 100 | 285 | 585 | 627 | 5 | 2024-06-22 | 890.82 | 22.27 | 2024-06-10 | 2 | 461.44 | 1 | 890.82 | 11 | SO65242 | 2024-06-17 | 71.27 | 922.89 | 445.41 | |||
| SO49124_15 | 795F-4192-AD | PO3596184634 | 100 | 285 | 356 | 476 | 5 | 2023-05-25 | 7457.11 | 186.43 | 2023-05-13 | 6 | 1117.86 | 1 | 7457.11 | 15 | SO49124 | 2023-05-20 | 596.57 | 6707.14 | 1242.85 | |||
| SO47040_12 | 5A71-45F5-B9 | PO5568168365 | 100 | 285 | 221 | 422 | 5 | 2022-11-22 | 60.56 | 1.51 | 2022-11-10 | 3 | 13.88 | 1 | 60.56 | 12 | SO47040 | 2022-11-17 | 4.84 | 41.63 | 20.19 | |||
| SO44555_17 | 51FA-451D-A2 | PO6293176988 | 100 | 285 | 320 | 612 | 5 | 2022-02-22 | 419.46 | 10.49 | 2022-02-10 | 1 | 413.15 | 1 | 419.46 | 17 | SO44555 | 2022-02-17 | 33.56 | 413.15 | 419.46 | |||
| SO57126_15 | 6350-4E4D-85 | PO7598164370 | 100 | 285 | 240 | 45 | 5 | 2024-02-22 | 3435.60 | 85.89 | 2024-02-10 | 4 | 868.63 | 1 | 3435.60 | 15 | SO57126 | 2024-02-17 | 274.85 | 3474.54 | 858.90 | |||
| SO51874_9 | 0176-4E11-91 | PO9773132815 | 100 | 285 | 579 | 8 | 5 | 2023-11-22 | 728.91 | 18.22 | 2023-11-10 | 1 | 755.15 | 1 | 728.91 | 9 | SO51874 | 2023-11-17 | 58.31 | 755.15 | 728.91 | |||
| SO53474_23 | E5B6-4103-8D | PO15457187993 | 100 | 285 | 501 | 297 | 5 | 2023-12-23 | 145.75 | 3.64 | 2023-12-11 | 2 | 53.93 | 1 | 145.75 | 23 | SO53474 | 2023-12-18 | 11.66 | 107.86 | 72.88 | |||
| SO71844_23 | 410D-4079-9E | PO2813198985 | 100 | 283 | 480 | 90 | 5 | 2024-09-22 | 8.24 | 0.21 | 2024-09-10 | 6 | 0.86 | 1 | 8.24 | 23 | SO71844 | 2024-09-17 | 0.66 | 5.14 | 1.37 | |||
| SO69502_4 | 2A73-4DAC-AB | PO6293127965 | 100 | 285 | 418 | 612 | 5 | 2024-08-22 | 356.90 | 8.92 | 2024-08-10 | 1 | 360.94 | 1 | 356.90 | 4 | SO69502 | 2024-08-17 | 28.55 | 360.94 | 356.90 | |||
| SO48018_10 | 5D69-492B-A1 | PO11571175810 | 100 | 285 | 435 | 512 | 5 | 2023-02-22 | 648.91 | 16.22 | 2023-02-10 | 2 | 300.12 | 1 | 648.91 | 10 | SO48018 | 2023-02-17 | 51.91 | 600.24 | 324.45 | |||
| SO57162_4 | 83B5-43A6-BD | PO3596174424 | 100 | 285 | 513 | 476 | 5 | 2024-02-22 | 218.45 | 5.46 | 2024-02-10 | 1 | 199.38 | 1 | 218.45 | 4 | SO57162 | 2024-02-17 | 17.48 | 199.38 | 218.45 | |||
| SO71866_29 | 029A-46BE-80 | PO14297151936 | 100 | 285 | 225 | 627 | 5 | 2024-09-22 | 5.39 | 0.13 | 2024-09-10 | 1 | 6.92 | 1 | 5.39 | 29 | SO71866 | 2024-09-17 | 0.43 | 6.92 | 5.39 | |||
| SO46943_9 | 6F43-4A10-80 | PO18560122957 | 100 | 285 | 271 | 531 | 5 | 2022-11-22 | 1011.66 | 25.29 | 2022-11-10 | 5 | 187.16 | 1 | 1011.66 | 9 | SO46943 | 2022-11-17 | 80.93 | 935.79 | 202.33 | |||
| SO48393_14 | 5B6A-41B6-BF | PO9599137631 | 100 | 285 | 383 | 170 | 5 | 2023-03-24 | 2401.05 | 60.03 | 2023-03-12 | 4 | 605.65 | 1 | 2401.05 | 14 | SO48393 | 2023-03-19 | 192.08 | 2422.60 | 600.26 | |||
| SO51718_4 | 27D3-4968-89 | PO15051113417 | 100 | 285 | 222 | 207 | 5 | 2023-11-22 | 62.98 | 1.57 | 2023-11-10 | 3 | 13.09 | 1 | 62.98 | 4 | SO51718 | 2023-11-17 | 5.04 | 39.26 | 20.99 | |||
| SO51780_18 | 30C4-4B8F-AA | PO18560115626 | 100 | 285 | 471 | 531 | 5 | 2023-11-22 | 114.30 | 2.86 | 2023-11-10 | 3 | 23.75 | 1 | 114.30 | 18 | SO51780 | 2023-11-17 | 9.14 | 71.25 | 38.10 |
Generated 2024-11-10 01:40:24.973 UTC