[ROOT] dt FactResellerSale < WHERE DimSalesTerritoryId EQ '5' > SHUFFLE < SKIP 595 > < TAKE 60 >
60 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 |
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
| SO71866_22 | 029A-46BE-80 | PO14297151936 | 100 | 285 | 496 | 627 | 5 | 2024-09-23 | 2409.38 | 60.23 | 2024-09-11 | 4 | 601.74 | 1 | 2409.38 | 22 | SO71866 | 2024-09-18 | 192.75 | 2406.97 | 602.35 | |||
| SO46329_1 | 688B-4F92-AD | PO18067136592 | 100 | 285 | 288 | 314 | 5 | 2022-09-23 | 722.59 | 18.06 | 2022-09-11 | 1 | 623.84 | 1 | 722.59 | 1 | SO46329 | 2022-09-18 | 57.81 | 623.84 | 722.59 | |||
| SO47726_2 | 7256-4599-93 | PO9657190563 | 100 | 285 | 366 | 315 | 5 | 2023-01-23 | 647.99 | 16.20 | 2023-01-11 | 1 | 598.44 | 1 | 647.99 | 2 | SO47726 | 2023-01-18 | 51.84 | 598.44 | 647.99 | |||
| SO51108_8 | 8650-4A20-B1 | PO12644151814 | 100 | 285 | 222 | 11 | 530 | 5 | 9.45 | 2023-10-23 | 62.98 | 1.34 | 2023-10-11 | 4 | 13.09 | 1 | 53.53 | 8 | SO51108 | 2023-10-18 | 4.28 | 52.35 | 15.75 | 0.15 |
| SO44309_14 | F0DB-4889-AC | PO3393112350 | 100 | 285 | 311 | 549 | 5 | 2022-01-23 | 2146.96 | 53.67 | 2022-01-11 | 1 | 2171.29 | 1 | 2146.96 | 14 | SO44309 | 2022-01-18 | 171.76 | 2171.29 | 2146.96 | |||
| SO53625_2 | 98EA-458A-B9 | PO9744185498 | 100 | 285 | 359 | 98 | 5 | 2023-12-24 | 1376.99 | 34.42 | 2023-12-12 | 1 | 1251.98 | 1 | 1376.99 | 2 | SO53625 | 2023-12-19 | 110.16 | 1251.98 | 1376.99 | |||
| SO49124_5 | 795F-4192-AD | PO3596184634 | 100 | 285 | 420 | 476 | 5 | 2023-05-26 | 283.23 | 7.08 | 2023-05-14 | 2 | 104.80 | 1 | 283.23 | 5 | SO49124 | 2023-05-21 | 22.66 | 209.59 | 141.62 | |||
| SO55234_35 | C6FC-46EE-88 | PO522140495 | 100 | 285 | 511 | 676 | 5 | 2024-01-23 | 873.82 | 21.85 | 2024-01-11 | 4 | 199.38 | 1 | 873.82 | 35 | SO55234 | 2024-01-18 | 69.91 | 797.50 | 218.45 | |||
| SO43676_2 | 11BA-4D19-B7 | PO11861165059 | 100 | 281 | 351 | 17 | 5 | 2021-10-23 | 4049.99 | 101.25 | 2021-10-11 | 2 | 1898.09 | 1 | 4049.99 | 2 | SO43676 | 2021-10-18 | 324.00 | 3796.19 | 2024.99 | |||
| SO46673_13 | 578D-4F7B-A6 | PO9657163155 | 100 | 285 | 447 | 315 | 5 | 2022-10-23 | 45.00 | 1.13 | 2022-10-11 | 3 | 10.31 | 1 | 45.00 | 13 | SO46673 | 2022-10-18 | 3.60 | 30.94 | 15.00 | |||
| SO48075_5 | DB59-481D-87 | PO7598114627 | 100 | 285 | 429 | 45 | 5 | 2023-02-23 | 324.45 | 8.11 | 2023-02-11 | 1 | 300.12 | 1 | 324.45 | 5 | SO48075 | 2023-02-18 | 25.96 | 300.12 | 324.45 | |||
| SO47726_22 | 7256-4599-93 | PO9657190563 | 100 | 285 | 447 | 315 | 5 | 2023-01-23 | 60.00 | 1.50 | 2023-01-11 | 4 | 10.31 | 1 | 60.00 | 22 | SO47726 | 2023-01-18 | 4.80 | 41.25 | 15.00 | |||
| SO44518_19 | 359F-48A3-B9 | PO12586169040 | 100 | 285 | 223 | 278 | 5 | 2022-02-23 | 41.49 | 1.04 | 2022-02-11 | 8 | 5.71 | 1 | 41.49 | 19 | SO44518 | 2022-02-18 | 3.32 | 45.64 | 5.19 | |||
| SO65229_6 | 7557-4EA8-AD | PO11977163025 | 100 | 285 | 482 | 675 | 5 | 2024-06-23 | 10.79 | 0.27 | 2024-06-11 | 2 | 3.36 | 1 | 10.79 | 6 | SO65229 | 2024-06-18 | 0.86 | 6.72 | 5.39 | |||
| SO50726_29 | A80B-408E-B3 | PO9599192861 | 100 | 285 | 273 | 170 | 5 | 2023-09-23 | 809.33 | 20.23 | 2023-09-11 | 4 | 187.16 | 1 | 809.33 | 29 | SO50726 | 2023-09-18 | 64.75 | 748.63 | 202.33 | |||
| SO46091_1 | 6DCB-4063-BA | PO6293193126 | 100 | 285 | 320 | 612 | 5 | 2022-08-23 | 419.46 | 10.49 | 2022-08-11 | 1 | 413.15 | 1 | 419.46 | 1 | SO46091 | 2022-08-18 | 33.56 | 413.15 | 419.46 | |||
| SO50273_1 | 8358-4E59-86 | PO16211117741 | 100 | 285 | 308 | 99 | 5 | 2023-08-23 | 744.27 | 18.61 | 2023-08-11 | 1 | 660.91 | 1 | 744.27 | 1 | SO50273 | 2023-08-18 | 59.54 | 660.91 | 744.27 | |||
| SO57074_17 | FF65-4261-97 | PO9918191120 | 100 | 285 | 564 | 260 | 5 | 2024-02-23 | 4291.33 | 107.28 | 2024-02-11 | 3 | 1481.94 | 1 | 4291.33 | 17 | SO57074 | 2024-02-18 | 343.31 | 4445.81 | 1430.44 | |||
| SO57162_4 | 83B5-43A6-BD | PO3596174424 | 100 | 285 | 513 | 476 | 5 | 2024-02-23 | 218.45 | 5.46 | 2024-02-11 | 1 | 199.38 | 1 | 218.45 | 4 | SO57162 | 2024-02-18 | 17.48 | 199.38 | 218.45 | |||
| SO49509_14 | 1105-4F75-BE | PO9599181538 | 100 | 285 | 327 | 170 | 5 | 2023-06-23 | 939.59 | 23.49 | 2023-06-11 | 2 | 486.71 | 1 | 939.59 | 14 | SO49509 | 2023-06-18 | 75.17 | 973.41 | 469.79 | |||
| SO53474_7 | E5B6-4103-8D | PO15457187993 | 100 | 285 | 564 | 14 | 297 | 5 | 190.73 | 2023-12-24 | 953.63 | 19.07 | 2023-12-12 | 1 | 1481.94 | 1 | 762.90 | 7 | SO53474 | 2023-12-19 | 61.03 | 1481.94 | 953.63 | 0.20 |
| SO53524_25 | 2B2B-440F-8B | PO1537151724 | 100 | 285 | 561 | 14 | 611 | 5 | 572.18 | 2023-12-24 | 2860.88 | 57.22 | 2023-12-12 | 3 | 1481.94 | 1 | 2288.71 | 25 | SO53524 | 2023-12-19 | 183.10 | 4445.81 | 953.63 | 0.20 |
| SO51864_16 | 2389-4E32-92 | PO5568126648 | 100 | 285 | 217 | 422 | 5 | 2023-11-23 | 83.98 | 2.10 | 2023-11-11 | 4 | 13.09 | 1 | 83.98 | 16 | SO51864 | 2023-11-18 | 6.72 | 52.35 | 20.99 | |||
| SO69533_17 | AC2B-4C39-84 | PO3596133486 | 100 | 285 | 475 | 476 | 5 | 2024-08-23 | 125.98 | 3.15 | 2024-08-11 | 3 | 26.18 | 1 | 125.98 | 17 | SO69533 | 2024-08-18 | 10.08 | 78.53 | 41.99 | |||
| SO44518_14 | 359F-48A3-B9 | PO12586169040 | 100 | 285 | 345 | 278 | 5 | 2022-02-23 | 10199.97 | 255.00 | 2022-02-11 | 5 | 1912.15 | 1 | 10199.97 | 14 | SO44518 | 2022-02-18 | 816.00 | 9560.77 | 2039.99 | |||
| SO51816_1 | 415B-4D48-B0 | PO6293129251 | 100 | 285 | 255 | 612 | 5 | 2023-11-23 | 202.33 | 5.06 | 2023-11-11 | 1 | 204.63 | 1 | 202.33 | 1 | SO51816 | 2023-11-18 | 16.19 | 204.63 | 202.33 | |||
| SO49159_1 | 15B4-4CCD-9A | PO7598122487 | 100 | 285 | 454 | 45 | 5 | 2023-05-26 | 71.99 | 1.80 | 2023-05-14 | 2 | 24.75 | 1 | 71.99 | 1 | SO49159 | 2023-05-21 | 5.76 | 49.49 | 35.99 | |||
| SO51705_2 | DFFB-4C23-BD | PO16965171069 | 100 | 285 | 580 | 441 | 5 | 2023-11-23 | 2041.19 | 51.03 | 2023-11-11 | 2 | 1082.51 | 1 | 2041.19 | 2 | SO51705 | 2023-11-18 | 163.30 | 2165.02 | 1020.59 | |||
| SO47993_4 | 48A5-4EA7-AE | PO15051142366 | 100 | 285 | 233 | 207 | 5 | 2023-02-23 | 201.88 | 5.05 | 2023-02-11 | 7 | 29.08 | 1 | 201.88 | 4 | SO47993 | 2023-02-18 | 16.15 | 203.56 | 28.84 | |||
| SO44506_26 | CD67-4B07-B6 | PO16327113845 | 100 | 285 | 272 | 584 | 5 | 2022-02-23 | 183.94 | 4.60 | 2022-02-11 | 1 | 181.49 | 1 | 183.94 | 26 | SO44506 | 2022-02-18 | 14.72 | 181.49 | 183.94 | |||
| SO45289_1 | 741A-40B6-8E | PO16211190433 | 100 | 285 | 344 | 99 | 5 | 2022-05-26 | 12239.96 | 306.00 | 2022-05-14 | 6 | 1912.15 | 1 | 12239.96 | 1 | SO45289 | 2022-05-21 | 979.20 | 11472.93 | 2039.99 | |||
| SO50703_23 | 4A3D-44CB-B3 | PO2813140706 | 100 | 283 | 323 | 90 | 5 | 2023-09-23 | 4228.15 | 105.70 | 2023-09-11 | 9 | 486.71 | 1 | 4228.15 | 23 | SO50703 | 2023-09-18 | 338.25 | 4380.36 | 469.79 | |||
| SO43910_2 | 8233-42D0-BD | PO7598186753 | 100 | 285 | 322 | 45 | 5 | 2021-11-23 | 1677.84 | 41.95 | 2021-11-11 | 4 | 413.15 | 1 | 1677.84 | 2 | SO43910 | 2021-11-18 | 134.23 | 1652.59 | 419.46 | |||
| SO67348_29 | 4BD1-4782-A3 | PO9889141767 | 100 | 285 | 400 | 494 | 5 | 2024-07-24 | 37.15 | 0.93 | 2024-07-12 | 1 | 27.49 | 1 | 37.15 | 29 | SO67348 | 2024-07-19 | 2.97 | 27.49 | 37.15 | |||
| SO50293_2 | D649-4CE8-91 | PO3596144572 | 100 | 285 | 358 | 476 | 5 | 2023-08-23 | 2458.92 | 61.47 | 2023-08-11 | 2 | 1105.81 | 1 | 2458.92 | 2 | SO50293 | 2023-08-18 | 196.71 | 2211.62 | 1229.46 | |||
| SO47416_53 | 6B45-44AB-84 | PO2813155355 | 100 | 281 | 447 | 2 | 90 | 5 | 3.48 | 2022-12-24 | 174.00 | 4.26 | 2022-12-12 | 12 | 10.31 | 1 | 170.52 | 53 | SO47416 | 2022-12-19 | 13.64 | 123.75 | 14.50 | 0.02 |
| SO44488_8 | 18BD-4C15-81 | PO19546136242 | 100 | 285 | 232 | 206 | 5 | 2022-02-23 | 57.68 | 1.44 | 2022-02-11 | 2 | 31.72 | 1 | 57.68 | 8 | SO44488 | 2022-02-18 | 4.61 | 63.45 | 28.84 | |||
| SO48760_2 | D682-4FD4-94 | PO9657199450 | 100 | 285 | 233 | 315 | 5 | 2023-04-25 | 86.52 | 2.16 | 2023-04-13 | 3 | 29.08 | 1 | 86.52 | 2 | SO48760 | 2023-04-20 | 6.92 | 87.24 | 28.84 | |||
| SO45061_11 | 01FB-41EE-AE | PO522121303 | 100 | 285 | 223 | 676 | 5 | 2022-04-25 | 5.19 | 0.13 | 2022-04-13 | 1 | 5.71 | 1 | 5.19 | 11 | SO45061 | 2022-04-20 | 0.41 | 5.71 | 5.19 | |||
| SO43910_5 | 8233-42D0-BD | PO7598186753 | 100 | 285 | 310 | 45 | 5 | 2021-11-23 | 4293.92 | 107.35 | 2021-11-11 | 2 | 2171.29 | 1 | 4293.92 | 5 | SO43910 | 2021-11-18 | 343.51 | 4342.59 | 2146.96 | |||
| SO51718_2 | 27D3-4968-89 | PO15051113417 | 100 | 285 | 359 | 207 | 5 | 2023-11-23 | 1376.99 | 34.42 | 2023-11-11 | 1 | 1251.98 | 1 | 1376.99 | 2 | SO51718 | 2023-11-18 | 110.16 | 1251.98 | 1376.99 | |||
| SO46630_35 | F512-40F2-91 | PO12644161356 | 100 | 285 | 358 | 530 | 5 | 2022-10-23 | 4917.84 | 122.95 | 2022-10-11 | 4 | 1105.81 | 1 | 4917.84 | 35 | SO46630 | 2022-10-18 | 393.43 | 4423.24 | 1229.46 | |||
| SO65248_11 | A7B5-4EE1-98 | PO9599164617 | 100 | 285 | 482 | 170 | 5 | 2024-06-23 | 37.76 | 0.94 | 2024-06-11 | 7 | 3.36 | 1 | 37.76 | 11 | SO65248 | 2024-06-18 | 3.02 | 23.54 | 5.39 | |||
| SO65207_27 | B20E-440F-A3 | PO1537156240 | 100 | 285 | 502 | 611 | 5 | 2024-06-23 | 200.05 | 5.00 | 2024-06-11 | 1 | 199.85 | 1 | 200.05 | 27 | SO65207 | 2024-06-18 | 16.00 | 199.85 | 200.05 | |||
| SO50293_3 | D649-4CE8-91 | PO3596144572 | 100 | 285 | 365 | 476 | 5 | 2023-08-23 | 1295.99 | 32.40 | 2023-08-11 | 2 | 598.44 | 1 | 1295.99 | 3 | SO50293 | 2023-08-18 | 103.68 | 1196.87 | 647.99 | |||
| SO71839_7 | 8F89-4B1E-A8 | PO1537119063 | 100 | 285 | 467 | 611 | 5 | 2024-09-23 | 58.78 | 1.47 | 2024-09-11 | 4 | 9.16 | 1 | 58.78 | 7 | SO71839 | 2024-09-18 | 4.70 | 36.64 | 14.69 | |||
| SO46933_9 | 4D88-4B51-BF | PO19546168601 | 100 | 285 | 329 | 206 | 5 | 2022-11-23 | 469.79 | 11.74 | 2022-11-11 | 1 | 486.71 | 1 | 469.79 | 9 | SO46933 | 2022-11-18 | 37.58 | 486.71 | 469.79 | |||
| SO71844_7 | 410D-4079-9E | PO2813198985 | 100 | 283 | 234 | 90 | 5 | 2024-09-23 | 299.94 | 7.50 | 2024-09-11 | 10 | 38.49 | 1 | 299.94 | 7 | SO71844 | 2024-09-18 | 24.00 | 384.92 | 29.99 | |||
| SO71839_37 | 8F89-4B1E-A8 | PO1537119063 | 100 | 285 | 503 | 611 | 5 | 2024-09-23 | 400.10 | 10.00 | 2024-09-11 | 2 | 199.85 | 1 | 400.10 | 37 | SO71839 | 2024-09-18 | 32.01 | 399.70 | 200.05 | |||
| SO45331_15 | 4702-48B5-B8 | PO6293165974 | 100 | 285 | 220 | 612 | 5 | 2022-05-26 | 20.19 | 0.50 | 2022-05-14 | 1 | 12.03 | 1 | 20.19 | 15 | SO45331 | 2022-05-21 | 1.61 | 12.03 | 20.19 | |||
| SO67348_17 | 4BD1-4782-A3 | PO9889141767 | 100 | 285 | 542 | 494 | 5 | 2024-07-24 | 24.29 | 0.61 | 2024-07-12 | 1 | 17.98 | 1 | 24.29 | 17 | SO67348 | 2024-07-19 | 1.94 | 17.98 | 24.29 | |||
| SO44319_8 | FBB9-4CD9-A1 | PO9657142761 | 100 | 285 | 348 | 315 | 5 | 2022-01-23 | 4049.99 | 101.25 | 2022-01-11 | 2 | 1898.09 | 1 | 4049.99 | 8 | SO44319 | 2022-01-18 | 324.00 | 3796.19 | 2024.99 | |||
| SO50703_44 | 4A3D-44CB-B3 | PO2813140706 | 100 | 283 | 447 | 90 | 5 | 2023-09-23 | 150.00 | 3.75 | 2023-09-11 | 10 | 10.31 | 1 | 150.00 | 44 | SO50703 | 2023-09-18 | 12.00 | 103.13 | 15.00 | |||
| SO51760_24 | 2C2D-41C9-8C | PO9918180623 | 100 | 285 | 576 | 260 | 5 | 2023-11-23 | 11443.54 | 286.09 | 2023-11-11 | 8 | 1481.94 | 1 | 11443.54 | 24 | SO51760 | 2023-11-18 | 915.48 | 11855.50 | 1430.44 | |||
| SO47455_44 | 41F3-48C2-B7 | PO9599169586 | 100 | 285 | 263 | 170 | 5 | 2022-12-24 | 1011.66 | 25.29 | 2022-12-12 | 5 | 187.16 | 1 | 1011.66 | 44 | SO47455 | 2022-12-19 | 80.93 | 935.79 | 202.33 | |||
| SO51824_14 | A1F7-477E-BA | PO5800114202 | 100 | 285 | 526 | 63 | 5 | 2023-11-23 | 475.29 | 11.88 | 2023-11-11 | 3 | 144.59 | 1 | 475.29 | 14 | SO51824 | 2023-11-18 | 38.02 | 433.78 | 158.43 | |||
| SO48734_18 | F5F8-4E2A-98 | PO12644188680 | 100 | 285 | 365 | 530 | 5 | 2023-04-25 | 1943.98 | 48.60 | 2023-04-13 | 3 | 598.44 | 1 | 1943.98 | 18 | SO48734 | 2023-04-20 | 155.52 | 1795.31 | 647.99 | |||
| SO46091_10 | 6DCB-4063-BA | PO6293193126 | 100 | 285 | 326 | 612 | 5 | 2022-08-23 | 419.46 | 10.49 | 2022-08-11 | 1 | 413.15 | 1 | 419.46 | 10 | SO46091 | 2022-08-18 | 33.56 | 413.15 | 419.46 | |||
| SO49865_44 | E9A6-42D3-91 | PO9831136904 | 100 | 285 | 331 | 81 | 5 | 2023-07-24 | 939.59 | 23.49 | 2023-07-12 | 2 | 486.71 | 1 | 939.59 | 44 | SO49865 | 2023-07-19 | 75.17 | 973.41 | 469.79 | |||
| SO47416_31 | 6B45-44AB-84 | PO2813155355 | 100 | 281 | 375 | 90 | 5 | 2022-12-24 | 3926.81 | 98.17 | 2022-12-12 | 3 | 1320.68 | 1 | 3926.81 | 31 | SO47416 | 2022-12-19 | 314.15 | 3962.05 | 1308.94 |
Generated 2024-11-10 15:33:24.492 UTC