[ROOT] dt FactResellerSale < WHERE DimSalesTerritoryId EQ '3' > SHUFFLE < SKIP 142 > < 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 |
---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
SO46358_18 | 3BC7-40F4-99 | PO1624111969 | 100 | 283 | 270 | 579 | 3 | 2022-08-03 | 551.81 | 13.80 | 2022-07-22 | 3 | 181.49 | 1 | 551.81 | 18 | SO46358 | 2022-07-29 | 44.15 | 544.46 | 183.94 | |||
SO49837_17 | C136-4536-9D | PO12412160791 | 100 | 281 | 448 | 670 | 3 | 2023-06-03 | 23.99 | 0.60 | 2023-05-22 | 2 | 8.25 | 1 | 23.99 | 17 | SO49837 | 2023-05-29 | 1.92 | 16.49 | 11.99 | |||
SO63194_22 | A6B4-4109-B0 | PO15370118285 | 100 | 281 | 357 | 381 | 3 | 2024-04-04 | 2783.99 | 69.60 | 2024-03-23 | 2 | 1265.62 | 1 | 2783.99 | 22 | SO63194 | 2024-03-30 | 222.72 | 2531.24 | 1391.99 | |||
SO45266_6 | D9B4-4694-99 | PO19923129248 | 100 | 281 | 345 | 18 | 3 | 2022-04-05 | 4079.99 | 102.00 | 2022-03-24 | 2 | 1912.15 | 1 | 4079.99 | 6 | SO45266 | 2022-03-31 | 326.40 | 3824.31 | 2039.99 | |||
SO50304_29 | 9338-4FCD-A5 | PO5771132420 | 100 | 282 | 460 | 79 | 3 | 2023-07-03 | 269.97 | 6.75 | 2023-06-21 | 5 | 37.12 | 1 | 269.97 | 29 | SO50304 | 2023-06-28 | 21.60 | 185.60 | 53.99 | |||
SO67327_6 | 2D2C-4C57-A2 | PO6467126287 | 100 | 283 | 463 | 660 | 3 | 2024-06-03 | 58.78 | 1.47 | 2024-05-22 | 4 | 9.16 | 1 | 58.78 | 6 | SO67327 | 2024-05-29 | 4.70 | 36.64 | 14.69 | |||
SO47440_2 | 490D-4B3C-84 | PO7018185620 | 100 | 283 | 456 | 695 | 3 | 2022-11-03 | 224.97 | 5.62 | 2022-10-22 | 5 | 30.93 | 1 | 224.97 | 2 | SO47440 | 2022-10-29 | 18.00 | 154.67 | 44.99 | |||
SO57148_4 | AE28-4B3B-9D | PO3074151668 | 100 | 281 | 599 | 237 | 3 | 2024-01-03 | 971.98 | 24.30 | 2023-12-22 | 3 | 294.58 | 1 | 971.98 | 4 | SO57148 | 2023-12-29 | 77.76 | 883.74 | 323.99 | |||
SO53526_28 | 6EEB-4506-89 | PO1624140151 | 100 | 281 | 520 | 579 | 3 | 2023-11-03 | 94.75 | 2.37 | 2023-10-22 | 3 | 23.37 | 1 | 94.75 | 28 | SO53526 | 2023-10-29 | 7.58 | 70.12 | 31.58 | |||
SO46980_1 | FAA2-449B-99 | PO13572170679 | 100 | 287 | 286 | 527 | 3 | 2022-10-03 | 183.94 | 4.60 | 2022-09-21 | 1 | 170.14 | 1 | 183.94 | 1 | SO46980 | 2022-09-28 | 14.72 | 170.14 | 183.94 | |||
SO67332_12 | E97E-4BCF-92 | PO6235122123 | 100 | 283 | 546 | 431 | 3 | 2024-06-03 | 37.25 | 0.93 | 2024-05-22 | 1 | 27.57 | 1 | 37.25 | 12 | SO67332 | 2024-05-29 | 2.98 | 27.57 | 37.25 | |||
SO46067_11 | 2767-4728-8E | PO10440122607 | 100 | 283 | 223 | 623 | 3 | 2022-07-03 | 20.75 | 0.52 | 2022-06-21 | 4 | 5.71 | 1 | 20.75 | 11 | SO46067 | 2022-06-28 | 1.66 | 22.82 | 5.19 | |||
SO50661_4 | CE6E-45C9-A1 | PO19633184648 | 100 | 287 | 420 | 149 | 3 | 2023-08-03 | 283.23 | 7.08 | 2023-07-22 | 2 | 104.80 | 1 | 283.23 | 4 | SO50661 | 2023-07-29 | 22.66 | 209.59 | 141.62 | |||
SO48318_26 | 7FD9-425F-A3 | PO15341152410 | 100 | 283 | 213 | 327 | 3 | 2023-02-02 | 80.75 | 2.02 | 2023-01-21 | 4 | 13.88 | 1 | 80.75 | 26 | SO48318 | 2023-01-28 | 6.46 | 55.51 | 20.19 | |||
SO61240_24 | 16E9-4057-BF | PO6467181082 | 100 | 283 | 465 | 660 | 3 | 2024-03-04 | 102.86 | 2.57 | 2024-02-21 | 7 | 9.16 | 1 | 102.86 | 24 | SO61240 | 2024-02-28 | 8.23 | 64.12 | 14.69 | |||
SO65178_5 | 808E-413C-94 | PO16994175277 | 100 | 283 | 390 | 306 | 3 | 2024-05-03 | 1344.59 | 33.61 | 2024-04-21 | 2 | 713.08 | 1 | 1344.59 | 5 | SO65178 | 2024-04-28 | 107.57 | 1426.16 | 672.29 | |||
SO47996_17 | B6EA-4582-9E | PO15370152849 | 100 | 283 | 305 | 381 | 3 | 2023-01-03 | 2208.44 | 55.21 | 2022-12-22 | 3 | 653.70 | 1 | 2208.44 | 17 | SO47996 | 2022-12-29 | 176.67 | 1961.09 | 736.15 | |||
SO51828_36 | 3204-40B6-A5 | PO5771194719 | 100 | 282 | 471 | 2 | 79 | 3 | 10.31 | 2023-10-03 | 515.62 | 12.63 | 2023-09-21 | 14 | 23.75 | 1 | 505.31 | 36 | SO51828 | 2023-09-28 | 40.42 | 332.49 | 36.83 | 0.02 |
SO59016_1 | C817-476A-BF | PO4785180874 | 100 | 282 | 234 | 223 | 3 | 2024-02-02 | 179.96 | 4.50 | 2024-01-21 | 6 | 38.49 | 1 | 179.96 | 1 | SO59016 | 2024-01-28 | 14.40 | 230.95 | 29.99 | |||
SO46026_2 | 4EE4-41C6-BC | PO19923199302 | 100 | 281 | 300 | 18 | 3 | 2022-07-03 | 2429.28 | 60.73 | 2022-06-21 | 3 | 699.09 | 1 | 2429.28 | 2 | SO46026 | 2022-06-28 | 194.34 | 2097.28 | 809.76 | |||
SO58970_18 | 7853-4F60-87 | PO1624182044 | 100 | 281 | 287 | 579 | 3 | 2024-02-02 | 607.00 | 15.17 | 2024-01-21 | 3 | 204.63 | 1 | 607.00 | 18 | SO58970 | 2024-01-28 | 48.56 | 613.88 | 202.33 | |||
SO50304_28 | 9338-4FCD-A5 | PO5771132420 | 100 | 282 | 448 | 79 | 3 | 2023-07-03 | 83.96 | 2.10 | 2023-06-21 | 7 | 8.25 | 1 | 83.96 | 28 | SO50304 | 2023-06-28 | 6.72 | 57.72 | 11.99 | |||
SO57121_30 | A796-4C1D-A6 | PO5771187733 | 100 | 282 | 546 | 79 | 3 | 2024-01-03 | 111.76 | 2.79 | 2023-12-22 | 3 | 27.57 | 1 | 111.76 | 30 | SO57121 | 2023-12-29 | 8.94 | 82.70 | 37.25 | |||
SO57129_2 | 7845-422E-91 | PO4205185094 | 100 | 283 | 555 | 323 | 3 | 2024-01-03 | 127.80 | 3.20 | 2023-12-22 | 2 | 47.29 | 1 | 127.80 | 2 | SO57129 | 2023-12-29 | 10.22 | 94.57 | 63.90 | |||
SO46931_18 | EE3D-4B0A-B6 | PO19923131204 | 100 | 281 | 308 | 18 | 3 | 2022-10-03 | 1488.55 | 37.21 | 2022-09-21 | 2 | 660.91 | 1 | 1488.55 | 18 | SO46931 | 2022-09-28 | 119.08 | 1321.83 | 744.27 | |||
SO48325_16 | 0A85-48D3-97 | PO14268111638 | 100 | 283 | 379 | 418 | 3 | 2023-02-02 | 6544.69 | 163.62 | 2023-01-21 | 5 | 1320.68 | 1 | 6544.69 | 16 | SO48325 | 2023-01-28 | 523.58 | 6603.42 | 1308.94 | |||
SO51828_26 | 3204-40B6-A5 | PO5771194719 | 100 | 282 | 483 | 79 | 3 | 2023-10-03 | 288.00 | 7.20 | 2023-09-21 | 4 | 44.88 | 1 | 288.00 | 26 | SO51828 | 2023-09-28 | 23.04 | 179.52 | 72.00 | |||
SO61189_8 | 1A25-4A8C-8B | PO12412183085 | 100 | 281 | 477 | 670 | 3 | 2024-03-04 | 20.96 | 0.52 | 2024-02-21 | 7 | 1.87 | 1 | 20.96 | 8 | SO61189 | 2024-02-28 | 1.68 | 13.06 | 2.99 | |||
SO48004_23 | DC8C-40DC-8F | PO13572118942 | 100 | 287 | 415 | 527 | 3 | 2023-01-03 | 990.18 | 24.75 | 2022-12-22 | 5 | 146.55 | 1 | 990.18 | 23 | SO48004 | 2022-12-29 | 79.21 | 732.73 | 198.04 | |||
SO51828_7 | 3204-40B6-A5 | PO5771194719 | 100 | 282 | 380 | 79 | 3 | 2023-10-03 | 1466.01 | 36.65 | 2023-09-21 | 1 | 1554.95 | 1 | 1466.01 | 7 | SO51828 | 2023-09-28 | 117.28 | 1554.95 | 1466.01 |
Generated 2024-09-20 11:32:17.266 UTC