[ROOT] dt FactResellerSale < WHERE DimSalesTerritoryId EQ '3' > SHUFFLE < SKIP 4500 > < TAKE 31 >
31 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 |
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
| SO48065_25 | 1B78-4DE6-BC | PO5771120852 | 100 | 282 | 460 | 79 | 3 | 2023-02-25 | 323.96 | 8.10 | 2023-02-13 | 6 | 37.12 | 1 | 323.96 | 25 | SO48065 | 2023-02-20 | 25.92 | 222.73 | 53.99 | |||
| SO58944_19 | 90AC-4F21-90 | PO12354164168 | 100 | 283 | 593 | 197 | 3 | 2024-03-26 | 1355.98 | 33.90 | 2024-03-14 | 4 | 308.22 | 1 | 1355.98 | 19 | SO58944 | 2024-03-21 | 108.48 | 1232.87 | 338.99 | |||
| SO71864_17 | 2987-40A6-86 | PO14268188903 | 100 | 281 | 380 | 418 | 3 | 2024-09-25 | 4398.03 | 109.95 | 2024-09-13 | 3 | 1554.95 | 1 | 4398.03 | 17 | SO71864 | 2024-09-20 | 351.84 | 4664.84 | 1466.01 | |||
| SO44772_5 | F5E6-4B81-A3 | PO1624122637 | 100 | 283 | 310 | 579 | 3 | 2022-03-27 | 10734.81 | 268.37 | 2022-03-15 | 5 | 2171.29 | 1 | 10734.81 | 5 | SO44772 | 2022-03-22 | 858.78 | 10856.47 | 2146.96 | |||
| SO58944_17 | 90AC-4F21-90 | PO12354164168 | 100 | 283 | 471 | 197 | 3 | 2024-03-26 | 114.30 | 2.86 | 2024-03-14 | 3 | 23.75 | 1 | 114.30 | 17 | SO58944 | 2024-03-21 | 9.14 | 71.25 | 38.10 | |||
| SO71819_24 | DBA3-430C-8B | PO12354153257 | 100 | 283 | 490 | 197 | 3 | 2024-09-25 | 259.15 | 6.48 | 2024-09-13 | 8 | 41.57 | 1 | 259.15 | 24 | SO71819 | 2024-09-20 | 20.73 | 332.58 | 32.39 | |||
| SO47683_24 | 619F-4ABF-8A | PO12412127983 | 100 | 283 | 381 | 670 | 3 | 2023-01-25 | 3001.31 | 75.03 | 2023-01-13 | 5 | 605.65 | 1 | 3001.31 | 24 | SO47683 | 2023-01-20 | 240.11 | 3028.25 | 600.26 | |||
| SO47352_23 | 9DF5-4A88-9C | PO19633111392 | 100 | 287 | 399 | 149 | 3 | 2022-12-26 | 101.32 | 2.53 | 2022-12-14 | 3 | 24.99 | 1 | 101.32 | 23 | SO47352 | 2022-12-21 | 8.11 | 74.98 | 33.77 | |||
| SO44079_3 | A180-4128-A7 | PO19488118734 | 100 | 283 | 342 | 57 | 3 | 2021-12-26 | 838.92 | 20.97 | 2021-12-14 | 2 | 413.15 | 1 | 838.92 | 3 | SO44079 | 2021-12-21 | 67.11 | 826.29 | 419.46 | |||
| SO46087_11 | 7F79-4A44-AB | PO5191162942 | 100 | 283 | 272 | 364 | 3 | 2022-08-25 | 183.94 | 4.60 | 2022-08-13 | 1 | 181.49 | 1 | 183.94 | 11 | SO46087 | 2022-08-20 | 14.72 | 181.49 | 183.94 | |||
| SO44530_22 | 46CE-47C5-B3 | PO10440138648 | 100 | 283 | 235 | 623 | 3 | 2022-02-25 | 115.36 | 2.88 | 2022-02-13 | 4 | 31.72 | 1 | 115.36 | 22 | SO44530 | 2022-02-20 | 9.23 | 126.90 | 28.84 | |||
| SO63123_16 | ADA9-4CA6-94 | PO19923184888 | 100 | 283 | 551 | 18 | 3 | 2024-05-27 | 792.15 | 19.80 | 2024-05-15 | 5 | 144.59 | 1 | 792.15 | 16 | SO63123 | 2024-05-22 | 63.37 | 722.97 | 158.43 | |||
| SO44772_16 | F5E6-4B81-A3 | PO1624122637 | 100 | 283 | 311 | 579 | 3 | 2022-03-27 | 2146.96 | 53.67 | 2022-03-15 | 1 | 2171.29 | 1 | 2146.96 | 16 | SO44772 | 2022-03-22 | 171.76 | 2171.29 | 2146.96 | |||
| SO44316_6 | A335-431B-B9 | PO6235117320 | 100 | 281 | 332 | 431 | 3 | 2022-01-25 | 419.46 | 10.49 | 2022-01-13 | 1 | 413.15 | 1 | 419.46 | 6 | SO44316 | 2022-01-20 | 33.56 | 413.15 | 419.46 | |||
| SO53454_6 | 278D-445A-99 | PO19633151350 | 100 | 287 | 595 | 149 | 3 | 2023-12-26 | 338.99 | 8.47 | 2023-12-14 | 1 | 308.22 | 1 | 338.99 | 6 | SO53454 | 2023-12-21 | 27.12 | 308.22 | 338.99 | |||
| SO46371_1 | 22CF-4A21-AC | PO4669193749 | 100 | 283 | 232 | 111 | 3 | 2022-09-25 | 28.84 | 0.72 | 2022-09-13 | 1 | 31.72 | 1 | 28.84 | 1 | SO46371 | 2022-09-20 | 2.31 | 31.72 | 28.84 | |||
| SO51719_4 | ED05-475E-90 | PO15225174834 | 100 | 283 | 565 | 13 | 360 | 3 | 100.22 | 2023-11-25 | 668.12 | 14.20 | 2023-11-13 | 2 | 461.44 | 1 | 567.90 | 4 | SO51719 | 2023-11-20 | 45.43 | 922.89 | 334.06 | 0.15 |
| SO65281_13 | 709C-4F19-A4 | PO4118143390 | 100 | 281 | 506 | 454 | 3 | 2024-06-25 | 400.10 | 10.00 | 2024-06-13 | 2 | 199.85 | 1 | 400.10 | 13 | SO65281 | 2024-06-20 | 32.01 | 399.70 | 200.05 | |||
| SO47724_25 | FDA2-4CD7-92 | PO8787160870 | 100 | 282 | 458 | 2 | 523 | 3 | 9.57 | 2023-01-25 | 478.44 | 11.72 | 2023-01-13 | 11 | 30.93 | 1 | 468.87 | 25 | SO47724 | 2023-01-20 | 37.51 | 340.27 | 43.49 | 0.02 |
| SO47394_27 | 7FC9-4002-83 | PO12354143510 | 100 | 281 | 410 | 197 | 3 | 2022-12-26 | 36.45 | 0.91 | 2022-12-14 | 1 | 26.97 | 1 | 36.45 | 27 | SO47394 | 2022-12-21 | 2.92 | 26.97 | 36.45 | |||
| SO71798_21 | AFA9-4B18-AD | PO16994135863 | 100 | 283 | 408 | 306 | 3 | 2024-09-25 | 144.32 | 3.61 | 2024-09-13 | 2 | 53.40 | 1 | 144.32 | 21 | SO71798 | 2024-09-20 | 11.55 | 106.80 | 72.16 | |||
| SO51807_5 | D0BE-4C14-81 | PO12122119705 | 100 | 281 | 240 | 22 | 3 | 2023-11-25 | 858.90 | 21.47 | 2023-11-13 | 1 | 868.63 | 1 | 858.90 | 5 | SO51807 | 2023-11-20 | 68.71 | 868.63 | 858.90 | |||
| SO48065_45 | 1B78-4DE6-BC | PO5771120852 | 100 | 282 | 415 | 79 | 3 | 2023-02-25 | 1584.29 | 39.61 | 2023-02-13 | 8 | 146.55 | 1 | 1584.29 | 45 | SO48065 | 2023-02-20 | 126.74 | 1172.37 | 198.04 | |||
| SO46346_3 | 894E-400C-AE | PO13920182971 | 100 | 281 | 350 | 7 | 180 | 3 | 295.31 | 2022-09-25 | 843.75 | 13.71 | 2022-09-13 | 1 | 1898.09 | 1 | 548.44 | 3 | SO46346 | 2022-09-20 | 43.87 | 1898.09 | 843.75 | 0.35 |
| SO55324_17 | 35BE-456A-B8 | PO8787146999 | 100 | 282 | 465 | 2 | 523 | 3 | 3.98 | 2024-01-25 | 198.86 | 4.87 | 2024-01-13 | 14 | 9.16 | 1 | 194.88 | 17 | SO55324 | 2024-01-20 | 15.59 | 128.23 | 14.20 | 0.02 |
| SO45785_6 | 695A-4F07-88 | PO15428114828 | 100 | 283 | 218 | 646 | 3 | 2022-07-26 | 11.40 | 0.29 | 2022-07-14 | 2 | 3.40 | 1 | 11.40 | 6 | SO45785 | 2022-07-21 | 0.91 | 6.79 | 5.70 | |||
| SO47041_11 | C543-4932-83 | PO5771188676 | 100 | 282 | 213 | 79 | 3 | 2022-11-25 | 20.19 | 0.50 | 2022-11-13 | 1 | 13.88 | 1 | 20.19 | 11 | SO47041 | 2022-11-20 | 1.61 | 13.88 | 20.19 | |||
| SO67262_13 | 5BD7-455E-9A | PO19314114641 | 100 | 281 | 491 | 622 | 3 | 2024-07-26 | 291.55 | 7.29 | 2024-07-14 | 9 | 41.57 | 1 | 291.55 | 13 | SO67262 | 2024-07-21 | 23.32 | 374.15 | 32.39 | |||
| SO67347_21 | 6E87-4127-80 | PO8787117055 | 100 | 282 | 487 | 523 | 3 | 2024-07-26 | 164.97 | 4.12 | 2024-07-14 | 5 | 20.57 | 1 | 164.97 | 21 | SO67347 | 2024-07-21 | 13.20 | 102.83 | 32.99 | |||
| SO71864_16 | 2987-40A6-86 | PO14268188903 | 100 | 281 | 376 | 418 | 3 | 2024-09-25 | 2932.02 | 73.30 | 2024-09-13 | 2 | 1554.95 | 1 | 2932.02 | 16 | SO71864 | 2024-09-20 | 234.56 | 3109.90 | 1466.01 | |||
| SO63291_5 | 9B60-437E-88 | PO8845151318 | 100 | 282 | 490 | 546 | 3 | 2024-05-27 | 129.58 | 3.24 | 2024-05-15 | 4 | 41.57 | 1 | 129.58 | 5 | SO63291 | 2024-05-22 | 10.37 | 166.29 | 32.39 |
Generated 2024-11-13 03:22:37.791 UTC