[ROOT] dt FactResellerSale < WHERE DimSalesTerritoryId EQ '5' > SKIP 500 SHUFFLE < SKIP 1188 > < TAKE 30 >
30 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 |
---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
SO71802_6 | 6B80-41A7-89 | PO15457184141 | 100 | 285 | 501 | 297 | 5 | 2024-09-27 | 145.75 | 3.64 | 2024-09-15 | 2 | 53.93 | 1 | 145.75 | 6 | SO71802 | 2024-09-22 | 11.66 | 107.86 | 72.88 | |||
SO46631_9 | D8CB-44CB-87 | PO11861116846 | 100 | 281 | 360 | 17 | 5 | 2022-10-27 | 1229.46 | 30.74 | 2022-10-15 | 1 | 1105.81 | 1 | 1229.46 | 9 | SO46631 | 2022-10-22 | 98.36 | 1105.81 | 1229.46 | |||
SO44562_2 | 1856-47B2-AD | PO7598190472 | 100 | 285 | 332 | 45 | 5 | 2022-02-27 | 838.92 | 20.97 | 2022-02-15 | 2 | 413.15 | 1 | 838.92 | 2 | SO44562 | 2022-02-22 | 67.11 | 826.29 | 419.46 | |||
SO55253_38 | C58B-49D8-9F | PO12644132539 | 100 | 285 | 474 | 3 | 530 | 5 | 32.72 | 2024-01-27 | 654.41 | 15.54 | 2024-01-15 | 17 | 26.18 | 1 | 621.69 | 38 | SO55253 | 2024-01-22 | 49.73 | 445.00 | 38.49 | 0.05 |
SO58971_42 | 319A-4CAC-B1 | PO1537134870 | 100 | 285 | 577 | 611 | 5 | 2024-03-28 | 2186.73 | 54.67 | 2024-03-16 | 3 | 755.15 | 1 | 2186.73 | 42 | SO58971 | 2024-03-23 | 174.94 | 2265.45 | 728.91 | |||
SO53530_2 | A31D-483D-A1 | PO2813121313 | 100 | 283 | 465 | 2 | 90 | 5 | 3.98 | 2023-12-28 | 198.86 | 4.87 | 2023-12-16 | 14 | 9.16 | 1 | 194.88 | 2 | SO53530 | 2023-12-23 | 15.59 | 128.23 | 14.20 | 0.02 |
SO69533_1 | AC2B-4C39-84 | PO3596133486 | 100 | 285 | 600 | 476 | 5 | 2024-08-27 | 323.99 | 8.10 | 2024-08-15 | 1 | 294.58 | 1 | 323.99 | 1 | SO69533 | 2024-08-22 | 25.92 | 294.58 | 323.99 | |||
SO63185_1 | FD44-488D-98 | PO17255114491 | 100 | 285 | 576 | 80 | 5 | 2024-05-29 | 1430.44 | 35.76 | 2024-05-17 | 1 | 1481.94 | 1 | 1430.44 | 1 | SO63185 | 2024-05-24 | 114.44 | 1481.94 | 1430.44 | |||
SO49836_27 | 0E32-48F7-89 | PO12644185975 | 100 | 285 | 428 | 530 | 5 | 2023-07-28 | 837.02 | 20.93 | 2023-07-16 | 4 | 185.82 | 1 | 837.02 | 27 | SO49836 | 2023-07-23 | 66.96 | 743.28 | 209.26 | |||
SO44506_7 | CD67-4B07-B6 | PO16327113845 | 100 | 285 | 338 | 584 | 5 | 2022-02-27 | 1258.38 | 31.46 | 2022-02-15 | 3 | 413.15 | 1 | 1258.38 | 7 | SO44506 | 2022-02-22 | 100.67 | 1239.44 | 419.46 | |||
SO44779_7 | A6CC-4B73-8D | PO4089186617 | 100 | 285 | 345 | 368 | 5 | 2022-03-29 | 4079.99 | 102.00 | 2022-03-17 | 2 | 1912.15 | 1 | 4079.99 | 7 | SO44779 | 2022-03-24 | 326.40 | 3824.31 | 2039.99 | |||
SO48018_25 | 5D69-492B-A1 | PO11571175810 | 100 | 285 | 385 | 512 | 5 | 2023-02-27 | 1200.53 | 30.01 | 2023-02-15 | 2 | 605.65 | 1 | 1200.53 | 25 | SO48018 | 2023-02-22 | 96.04 | 1211.30 | 600.26 | |||
SO50756_18 | C414-447C-84 | PO9570119689 | 100 | 285 | 453 | 585 | 5 | 2023-09-27 | 107.98 | 2.70 | 2023-09-15 | 3 | 24.75 | 1 | 107.98 | 18 | SO50756 | 2023-09-22 | 8.64 | 74.24 | 35.99 | |||
SO44565_1 | 6A99-4B08-B3 | PO7714127691 | 100 | 285 | 342 | 495 | 5 | 2022-02-27 | 419.46 | 10.49 | 2022-02-15 | 1 | 413.15 | 1 | 419.46 | 1 | SO44565 | 2022-02-22 | 33.56 | 413.15 | 419.46 | |||
SO49868_2 | 6BF3-4FD0-B5 | PO11861146173 | 100 | 283 | 358 | 17 | 5 | 2023-07-28 | 1229.46 | 30.74 | 2023-07-16 | 1 | 1105.81 | 1 | 1229.46 | 2 | SO49868 | 2023-07-23 | 98.36 | 1105.81 | 1229.46 | |||
SO46604_23 | 8062-4A97-B3 | PO522154989 | 100 | 285 | 453 | 676 | 5 | 2022-10-27 | 107.98 | 2.70 | 2022-10-15 | 3 | 24.75 | 1 | 107.98 | 23 | SO46604 | 2022-10-22 | 8.64 | 74.24 | 35.99 | |||
SO44798_13 | 301F-4820-92 | PO9541179114 | 100 | 285 | 349 | 279 | 5 | 2022-03-29 | 12149.96 | 303.75 | 2022-03-17 | 6 | 1898.09 | 1 | 12149.96 | 13 | SO44798 | 2022-03-24 | 972.00 | 11388.57 | 2024.99 | |||
SO51780_9 | 30C4-4B8F-AA | PO18560115626 | 100 | 285 | 214 | 531 | 5 | 2023-11-27 | 41.99 | 1.05 | 2023-11-15 | 2 | 13.09 | 1 | 41.99 | 9 | SO51780 | 2023-11-22 | 3.36 | 26.17 | 20.99 | |||
SO48734_6 | F5F8-4E2A-98 | PO12644188680 | 100 | 285 | 367 | 530 | 5 | 2023-04-29 | 1943.98 | 48.60 | 2023-04-17 | 3 | 598.44 | 1 | 1943.98 | 6 | SO48734 | 2023-04-24 | 155.52 | 1795.31 | 647.99 | |||
SO45289_4 | 741A-40B6-8E | PO16211190433 | 100 | 285 | 218 | 99 | 5 | 2022-05-30 | 11.40 | 0.29 | 2022-05-18 | 2 | 3.40 | 1 | 11.40 | 4 | SO45289 | 2022-05-25 | 0.91 | 6.79 | 5.70 | |||
SO46099_13 | 7E3B-4362-99 | PO7598165395 | 100 | 285 | 212 | 45 | 5 | 2022-08-27 | 40.37 | 1.01 | 2022-08-15 | 2 | 12.03 | 1 | 40.37 | 13 | SO46099 | 2022-08-22 | 3.23 | 24.06 | 20.19 | |||
SO45801_13 | 588D-487D-A4 | PO10179161655 | 100 | 285 | 293 | 27 | 5 | 2022-07-28 | 722.59 | 18.06 | 2022-07-16 | 1 | 623.84 | 1 | 722.59 | 13 | SO45801 | 2022-07-23 | 57.81 | 623.84 | 722.59 | |||
SO49836_32 | 0E32-48F7-89 | PO12644185975 | 100 | 285 | 221 | 530 | 5 | 2023-07-28 | 100.93 | 2.52 | 2023-07-16 | 5 | 13.88 | 1 | 100.93 | 32 | SO49836 | 2023-07-23 | 8.07 | 69.39 | 20.19 | |||
SO46933_36 | 4D88-4B51-BF | PO19546168601 | 100 | 285 | 403 | 206 | 5 | 2022-11-27 | 24.29 | 0.61 | 2022-11-15 | 1 | 17.98 | 1 | 24.29 | 36 | SO46933 | 2022-11-22 | 1.94 | 17.98 | 24.29 | |||
SO44133_10 | 4899-4DD6-93 | PO9599144193 | 100 | 285 | 314 | 170 | 5 | 2021-12-28 | 8587.85 | 214.70 | 2021-12-16 | 4 | 2171.29 | 1 | 8587.85 | 10 | SO44133 | 2021-12-23 | 687.03 | 8685.18 | 2146.96 | |||
SO46056_5 | 4B9A-4022-AA | PO12586180466 | 100 | 285 | 351 | 278 | 5 | 2022-08-27 | 4049.99 | 101.25 | 2022-08-15 | 2 | 1898.09 | 1 | 4049.99 | 5 | SO46056 | 2022-08-22 | 324.00 | 3796.19 | 2024.99 | |||
SO51081_25 | EDBF-4FE1-8F | PO522116846 | 100 | 285 | 217 | 11 | 676 | 5 | 14.17 | 2023-10-27 | 94.47 | 2.01 | 2023-10-15 | 6 | 13.09 | 1 | 80.30 | 25 | SO51081 | 2023-10-22 | 6.42 | 78.52 | 15.75 | 0.15 |
SO71802_2 | 6B80-41A7-89 | PO15457184141 | 100 | 285 | 575 | 297 | 5 | 2024-09-27 | 2860.88 | 71.52 | 2024-09-15 | 2 | 1481.94 | 1 | 2860.88 | 2 | SO71802 | 2024-09-22 | 228.87 | 2963.88 | 1430.44 | |||
SO45329_7 | CFFE-4184-BD | PO5858128971 | 100 | 285 | 345 | 566 | 5 | 2022-05-30 | 14279.96 | 357.00 | 2022-05-18 | 7 | 1912.15 | 1 | 14279.96 | 7 | SO45329 | 2022-05-25 | 1142.40 | 13385.08 | 2039.99 | |||
SO46971_3 | 5CEA-463B-A2 | PO15051144269 | 100 | 285 | 420 | 207 | 5 | 2022-11-27 | 141.62 | 3.54 | 2022-11-15 | 1 | 104.80 | 1 | 141.62 | 3 | SO46971 | 2022-11-22 | 11.33 | 104.80 | 141.62 |
Generated 2024-11-14 05:37:31.278 UTC