[ROOT] dt FactResellerSale < WHERE DimSalesTerritoryId EQ '3' > SHUFFLE < SKIP 140 > < TAKE 30 >
30 items
FactResellerSaleId | CarrierTrackingNumber | CustomerPONumber | DimCurrencyId | DimEmployeeId | DimProductId | DimResellerId | DimSalesTerritoryId | DueDate | ExtendedAmount | Freight | OrderDate | OrderQuantity | ProductStandardCost | RevisionNumber | SalesAmount | SalesOrderLineNumber | SalesOrderNumber | ShipDate | TaxAmt | TotalProductCost | UnitPrice |
---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
SO51822_47 | EEEE-45C1-87 | PO8845178563 | 100 | 282 | 544 | 546 | 3 | 2023-11-27 | 291.56 | 7.29 | 2023-11-15 | 6 | 35.96 | 1 | 291.56 | 47 | SO51822 | 2023-11-22 | 23.33 | 215.76 | 48.59 |
SO50675_4 | 4D87-4C93-9C | PO15341172035 | 100 | 281 | 352 | 327 | 3 | 2023-09-27 | 1242.85 | 31.07 | 2023-09-15 | 1 | 1117.86 | 1 | 1242.85 | 4 | SO50675 | 2023-09-22 | 99.43 | 1117.86 | 1242.85 |
SO63193_1 | 7E1D-4DF4-8C | PO15225149104 | 100 | 283 | 480 | 360 | 3 | 2024-05-29 | 4.12 | 0.10 | 2024-05-17 | 3 | 0.86 | 1 | 4.12 | 1 | SO63193 | 2024-05-24 | 0.33 | 2.57 | 1.37 |
SO71884_37 | 5F6A-4027-A6 | PO7047195292 | 100 | 281 | 400 | 544 | 3 | 2024-09-27 | 74.30 | 1.86 | 2024-09-15 | 2 | 27.49 | 1 | 74.30 | 37 | SO71884 | 2024-09-22 | 5.94 | 54.99 | 37.15 |
SO46969_2 | 3C39-4176-A8 | PO15370166954 | 100 | 283 | 305 | 381 | 3 | 2022-11-27 | 2208.44 | 55.21 | 2022-11-15 | 3 | 653.70 | 1 | 2208.44 | 2 | SO46969 | 2022-11-22 | 176.67 | 1961.09 | 736.15 |
SO49893_6 | 99ED-4EEC-9C | PO8787173621 | 100 | 282 | 325 | 523 | 3 | 2023-07-28 | 1879.18 | 46.98 | 2023-07-16 | 4 | 486.71 | 1 | 1879.18 | 6 | SO49893 | 2023-07-23 | 150.33 | 1946.83 | 469.79 |
SO53590_25 | E7FF-4C04-9E | PO4118162346 | 100 | 281 | 507 | 454 | 3 | 2023-12-28 | 200.05 | 5.00 | 2023-12-16 | 1 | 199.85 | 1 | 200.05 | 25 | SO53590 | 2023-12-23 | 16.00 | 199.85 | 200.05 |
SO63291_34 | 9B60-437E-88 | PO8845151318 | 100 | 282 | 593 | 546 | 3 | 2024-05-29 | 1355.98 | 33.90 | 2024-05-17 | 4 | 308.22 | 1 | 1355.98 | 34 | SO63291 | 2024-05-24 | 108.48 | 1232.87 | 338.99 |
SO61210_14 | 7860-4CE8-A9 | PO8787168827 | 100 | 282 | 287 | 523 | 3 | 2024-04-28 | 202.33 | 5.06 | 2024-04-16 | 1 | 204.63 | 1 | 202.33 | 14 | SO61210 | 2024-04-23 | 16.19 | 204.63 | 202.33 |
SO43843_2 | AEB6-4356-80 | PO19923118772 | 100 | 281 | 351 | 18 | 3 | 2021-11-27 | 4049.99 | 101.25 | 2021-11-15 | 2 | 1898.09 | 1 | 4049.99 | 2 | SO43843 | 2021-11-22 | 324.00 | 3796.19 | 2024.99 |
SO59005_1 | 1873-4FCC-AA | PO11890144892 | 100 | 281 | 515 | 472 | 3 | 2024-03-28 | 16.27 | 0.41 | 2024-03-16 | 1 | 12.04 | 1 | 16.27 | 1 | SO59005 | 2024-03-23 | 1.30 | 12.04 | 16.27 |
SO47394_8 | 7FC9-4002-83 | PO12354143510 | 100 | 281 | 401 | 197 | 3 | 2022-12-28 | 131.20 | 3.28 | 2022-12-16 | 2 | 48.55 | 1 | 131.20 | 8 | SO47394 | 2022-12-23 | 10.50 | 97.09 | 65.60 |
SO63123_9 | ADA9-4CA6-94 | PO19923184888 | 100 | 283 | 603 | 18 | 3 | 2024-05-29 | 72.89 | 1.82 | 2024-05-17 | 1 | 53.94 | 1 | 72.89 | 9 | SO63123 | 2024-05-24 | 5.83 | 53.94 | 72.89 |
SO67347_24 | 6E87-4127-80 | PO8787117055 | 100 | 282 | 390 | 523 | 3 | 2024-07-28 | 2689.18 | 67.23 | 2024-07-16 | 4 | 713.08 | 1 | 2689.18 | 24 | SO67347 | 2024-07-23 | 215.13 | 2852.32 | 672.29 |
SO51151_47 | D7A9-4DF6-B9 | PO8787179219 | 100 | 282 | 418 | 523 | 3 | 2023-10-27 | 1427.59 | 35.69 | 2023-10-15 | 4 | 360.94 | 1 | 1427.59 | 47 | SO51151 | 2023-10-22 | 114.21 | 1443.77 | 356.90 |
SO49859_4 | C69C-4337-A7 | PO13949161597 | 100 | 283 | 323 | 643 | 3 | 2023-07-28 | 469.79 | 11.74 | 2023-07-16 | 1 | 486.71 | 1 | 469.79 | 4 | SO49859 | 2023-07-23 | 37.58 | 486.71 | 469.79 |
SO47020_1 | 60D5-4798-AF | PO3074119112 | 100 | 283 | 411 | 237 | 3 | 2022-11-27 | 125.42 | 3.14 | 2022-11-15 | 1 | 92.81 | 1 | 125.42 | 1 | SO47020 | 2022-11-22 | 10.03 | 92.81 | 125.42 |
SO44296_23 | DE85-42AB-AC | PO12412194442 | 100 | 283 | 319 | 670 | 3 | 2022-01-27 | 874.79 | 21.87 | 2022-01-15 | 1 | 884.71 | 1 | 874.79 | 23 | SO44296 | 2022-01-22 | 69.98 | 884.71 | 874.79 |
SO46979_10 | 5605-4AB3-96 | PO13601184435 | 100 | 283 | 233 | 310 | 3 | 2022-11-27 | 28.84 | 0.72 | 2022-11-15 | 1 | 29.08 | 1 | 28.84 | 10 | SO46979 | 2022-11-22 | 2.31 | 29.08 | 28.84 |
SO49465_3 | DE18-49CF-B2 | PO1624120205 | 100 | 281 | 216 | 579 | 3 | 2023-06-27 | 40.37 | 1.01 | 2023-06-15 | 2 | 13.88 | 1 | 40.37 | 3 | SO49465 | 2023-06-22 | 3.23 | 27.76 | 20.19 |
SO47716_29 | 619E-46D6-98 | PO6467148836 | 100 | 281 | 466 | 660 | 3 | 2023-01-27 | 56.52 | 1.41 | 2023-01-15 | 4 | 9.71 | 1 | 56.52 | 29 | SO47716 | 2023-01-22 | 4.52 | 38.85 | 14.13 |
SO47041_3 | C543-4932-83 | PO5771188676 | 100 | 282 | 339 | 79 | 3 | 2022-11-27 | 1409.38 | 35.23 | 2022-11-15 | 3 | 486.71 | 1 | 1409.38 | 3 | SO47041 | 2022-11-22 | 112.75 | 1460.12 | 469.79 |
SO45538_8 | 0310-4DCB-B5 | PO14268192541 | 100 | 283 | 315 | 418 | 3 | 2022-06-27 | 874.79 | 21.87 | 2022-06-15 | 1 | 884.71 | 1 | 874.79 | 8 | SO45538 | 2022-06-22 | 69.98 | 884.71 | 874.79 |
SO51828_27 | 3204-40B6-A5 | PO5771194719 | 100 | 282 | 477 | 79 | 3 | 2023-11-27 | 11.98 | 0.30 | 2023-11-15 | 4 | 1.87 | 1 | 11.98 | 27 | SO51828 | 2023-11-22 | 0.96 | 7.47 | 2.99 |
SO49492_6 | 8C0F-4EEC-81 | PO19633118522 | 100 | 287 | 362 | 149 | 3 | 2023-06-27 | 7376.75 | 184.42 | 2023-06-15 | 6 | 1105.81 | 1 | 7376.75 | 6 | SO49492 | 2023-06-22 | 590.14 | 6634.86 | 1229.46 |
SO48791_27 | 9EBF-4C7E-82 | PO8787123349 | 100 | 282 | 458 | 523 | 3 | 2023-04-29 | 314.96 | 7.87 | 2023-04-17 | 7 | 30.93 | 1 | 314.96 | 27 | SO48791 | 2023-04-24 | 25.20 | 216.53 | 44.99 |
SO51822_53 | EEEE-45C1-87 | PO8845178563 | 100 | 282 | 398 | 546 | 3 | 2023-11-27 | 133.62 | 3.34 | 2023-11-15 | 5 | 19.78 | 1 | 133.62 | 53 | SO51822 | 2023-11-22 | 10.69 | 98.88 | 26.72 |
SO61189_1 | 1A25-4A8C-8B | PO12412183085 | 100 | 281 | 374 | 670 | 3 | 2024-04-28 | 5864.04 | 146.60 | 2024-04-16 | 4 | 1554.95 | 1 | 5864.04 | 1 | SO61189 | 2024-04-23 | 469.12 | 6219.79 | 1466.01 |
SO63257_21 | B81B-4565-85 | PO5771197507 | 100 | 282 | 584 | 79 | 3 | 2024-05-29 | 971.98 | 24.30 | 2024-05-17 | 3 | 343.65 | 1 | 971.98 | 21 | SO63257 | 2024-05-24 | 77.76 | 1030.95 | 323.99 |
SO63162_3 | E3D1-4029-85 | PO12122191571 | 100 | 281 | 547 | 22 | 3 | 2024-05-29 | 194.38 | 4.86 | 2024-05-17 | 4 | 35.96 | 1 | 194.38 | 3 | SO63162 | 2024-05-24 | 15.55 | 143.84 | 48.59 |
Generated 2024-11-14 16:53:58.136 UTC