[ROOT] dt FactResellerSale WHERE DimSalesTerritoryId EQ '1' > SHUFFLE < SKIP 677 > < TAKE 28 >
28 items
FactResellerSaleId | CarrierTrackingNumber | CustomerPONumber | DimCurrencyId | DimEmployeeId | DimProductId | DimResellerId | DimSalesTerritoryId | DueDate | ExtendedAmount | Freight | OrderDate | OrderQuantity | ProductStandardCost | RevisionNumber | SalesAmount | SalesOrderLineNumber | SalesOrderNumber | ShipDate | TaxAmt | TotalProductCost | UnitPrice |
---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
SO48383_2 | 2788-4429-AB | PO7395199388 | 100 | 286 | 297 | 542 | 1 | 2023-02-03 | 1472.29 | 36.81 | 2023-01-22 | 2 | 653.70 | 1 | 1472.29 | 2 | SO48383 | 2023-01-29 | 117.78 | 1307.39 | 736.15 |
SO50297_36 | 5199-40AD-90 | PO4727113542 | 100 | 293 | 371 | 343 | 1 | 2023-07-04 | 7853.63 | 196.34 | 2023-06-22 | 6 | 1320.68 | 1 | 7853.63 | 36 | SO50297 | 2023-06-29 | 628.29 | 7924.10 | 1308.94 |
SO46042_11 | FE13-4E1B-A4 | PO16646156443 | 100 | 286 | 322 | 1 | 1 | 2022-07-04 | 419.46 | 10.49 | 2022-06-22 | 1 | 413.15 | 1 | 419.46 | 11 | SO46042 | 2022-06-29 | 33.56 | 413.15 | 419.46 |
SO71886_42 | AE34-4CC5-9B | PO6815136550 | 100 | 293 | 525 | 109 | 1 | 2024-08-04 | 158.43 | 3.96 | 2024-07-23 | 1 | 144.59 | 1 | 158.43 | 42 | SO71886 | 2024-07-30 | 12.67 | 144.59 | 158.43 |
SO51783_7 | B7A2-49BC-89 | PO18676114917 | 100 | 282 | 290 | 697 | 1 | 2023-10-04 | 2456.10 | 61.40 | 2023-09-22 | 3 | 747.20 | 1 | 2456.10 | 7 | SO51783 | 2023-09-29 | 196.49 | 2241.60 | 818.70 |
SO44541_2 | 64BA-409F-A1 | PO2958192556 | 100 | 286 | 346 | 559 | 1 | 2022-01-04 | 6119.98 | 153.00 | 2021-12-23 | 3 | 1912.15 | 1 | 6119.98 | 2 | SO44541 | 2021-12-30 | 489.60 | 5736.46 | 2039.99 |
SO71836_25 | E41E-40C1-84 | PO841118259 | 100 | 286 | 361 | 254 | 1 | 2024-08-04 | 8261.96 | 206.55 | 2024-07-23 | 6 | 1251.98 | 1 | 8261.96 | 25 | SO71836 | 2024-07-30 | 660.96 | 7511.89 | 1376.99 |
SO67346_12 | 545C-4C6E-88 | PO9338145989 | 100 | 293 | 502 | 451 | 1 | 2024-06-04 | 400.10 | 10.00 | 2024-05-23 | 2 | 199.85 | 1 | 400.10 | 12 | SO67346 | 2024-05-30 | 32.01 | 399.70 | 200.05 |
SO53452_2 | B555-4FD7-8B | PO870113712 | 100 | 286 | 507 | 621 | 1 | 2023-11-04 | 200.05 | 5.00 | 2023-10-23 | 1 | 199.85 | 1 | 200.05 | 2 | SO53452 | 2023-10-30 | 16.00 | 199.85 | 200.05 |
SO44514_11 | 7135-4E3F-B3 | PO14500153038 | 100 | 282 | 346 | 650 | 1 | 2022-01-04 | 4079.99 | 102.00 | 2021-12-23 | 2 | 1912.15 | 1 | 4079.99 | 11 | SO44514 | 2021-12-30 | 326.40 | 3824.31 | 2039.99 |
SO53452_9 | B555-4FD7-8B | PO870113712 | 100 | 286 | 502 | 621 | 1 | 2023-11-04 | 1200.31 | 30.01 | 2023-10-23 | 6 | 199.85 | 1 | 1200.31 | 9 | SO53452 | 2023-10-30 | 96.03 | 1199.11 | 200.05 |
SO51721_39 | 9429-430D-89 | PO14500124798 | 100 | 282 | 483 | 650 | 1 | 2023-10-04 | 576.00 | 14.40 | 2023-09-22 | 8 | 44.88 | 1 | 576.00 | 39 | SO51721 | 2023-09-29 | 46.08 | 359.04 | 72.00 |
SO50206_32 | 7656-4E84-B8 | PO16414158832 | 100 | 289 | 445 | 236 | 1 | 2023-07-04 | 215.96 | 5.40 | 2023-06-22 | 6 | 24.75 | 1 | 215.96 | 32 | SO50206 | 2023-06-29 | 17.28 | 148.48 | 35.99 |
SO44284_2 | 2A6B-46DE-96 | PO16588183754 | 100 | 289 | 232 | 146 | 1 | 2021-12-04 | 28.84 | 0.72 | 2021-11-22 | 1 | 31.72 | 1 | 28.84 | 2 | SO44284 | 2021-11-29 | 2.31 | 31.72 | 28.84 |
SO45549_15 | E477-44D2-B0 | PO783111978 | 100 | 286 | 328 | 91 | 1 | 2022-05-04 | 1258.38 | 31.46 | 2022-04-22 | 3 | 413.15 | 1 | 1258.38 | 15 | SO45549 | 2022-04-29 | 100.67 | 1239.44 | 419.46 |
SO59061_6 | FF84-46FB-BB | PO7946192154 | 100 | 282 | 471 | 438 | 1 | 2024-02-03 | 38.10 | 0.95 | 2024-01-22 | 1 | 23.75 | 1 | 38.10 | 6 | SO59061 | 2024-01-29 | 3.05 | 23.75 | 38.10 |
SO48001_34 | 02F1-4434-99 | PO14442151969 | 100 | 293 | 462 | 127 | 1 | 2023-01-04 | 56.52 | 1.41 | 2022-12-23 | 4 | 9.71 | 1 | 56.52 | 34 | SO48001 | 2022-12-30 | 4.52 | 38.85 | 14.13 |
SO47694_21 | 8253-4E13-9D | PO899122764 | 100 | 289 | 466 | 290 | 1 | 2022-12-04 | 42.39 | 1.06 | 2022-11-22 | 3 | 9.71 | 1 | 42.39 | 21 | SO47694 | 2022-11-29 | 3.39 | 29.14 | 14.13 |
SO47991_16 | 0F2E-4E6D-8E | PO15631116034 | 100 | 282 | 427 | 43 | 1 | 2023-01-04 | 418.51 | 10.46 | 2022-12-23 | 2 | 185.82 | 1 | 418.51 | 16 | SO47991 | 2022-12-30 | 33.48 | 371.64 | 209.26 |
SO47991_8 | 0F2E-4E6D-8E | PO15631116034 | 100 | 282 | 447 | 43 | 1 | 2023-01-04 | 45.00 | 1.13 | 2022-12-23 | 3 | 10.31 | 1 | 45.00 | 8 | SO47991 | 2022-12-30 | 3.60 | 30.94 | 15.00 |
SO47033_47 | 2797-46ED-BB | PO4727113716 | 100 | 286 | 433 | 343 | 1 | 2022-10-04 | 324.45 | 8.11 | 2022-09-22 | 1 | 300.12 | 1 | 324.45 | 47 | SO47033 | 2022-09-29 | 25.96 | 300.12 | 324.45 |
SO53569_8 | 113E-43AD-94 | PO9309141312 | 100 | 293 | 493 | 55 | 1 | 2023-11-04 | 400.10 | 10.00 | 2023-10-23 | 2 | 199.85 | 1 | 400.10 | 8 | SO53569 | 2023-10-30 | 32.01 | 399.70 | 200.05 |
SO71861_1 | 21C6-4FE7-96 | PO14152156429 | 100 | 293 | 376 | 37 | 1 | 2024-08-04 | 1466.01 | 36.65 | 2024-07-23 | 1 | 1554.95 | 1 | 1466.01 | 1 | SO71861 | 2024-07-30 | 117.28 | 1554.95 | 1466.01 |
SO67266_37 | 3CFE-46C9-88 | PO16588161069 | 100 | 289 | 587 | 146 | 1 | 2024-06-04 | 1385.08 | 34.63 | 2024-05-23 | 3 | 419.78 | 1 | 1385.08 | 37 | SO67266 | 2024-05-30 | 110.81 | 1259.34 | 461.69 |
SO44788_13 | 4CD8-41D6-AE | PO5220181334 | 100 | 282 | 349 | 169 | 1 | 2022-02-03 | 10124.97 | 253.12 | 2022-01-22 | 5 | 1898.09 | 1 | 10124.97 | 13 | SO44788 | 2022-01-29 | 810.00 | 9490.47 | 2024.99 |
SO53514_6 | 8580-40F8-81 | PO10411179199 | 100 | 289 | 506 | 182 | 1 | 2023-11-04 | 400.10 | 10.00 | 2023-10-23 | 2 | 199.85 | 1 | 400.10 | 6 | SO53514 | 2023-10-30 | 32.01 | 399.70 | 200.05 |
SO58962_10 | 12B1-4451-9A | PO870180310 | 100 | 286 | 564 | 621 | 1 | 2024-02-03 | 2860.88 | 71.52 | 2024-01-22 | 2 | 1481.94 | 1 | 2860.88 | 10 | SO58962 | 2024-01-29 | 228.87 | 2963.88 | 1430.44 |
SO49826_21 | 2EBD-4312-9C | PO16588178669 | 100 | 289 | 216 | 146 | 1 | 2023-06-04 | 100.93 | 2.52 | 2023-05-23 | 5 | 13.88 | 1 | 100.93 | 21 | SO49826 | 2023-05-30 | 8.07 | 69.39 | 20.19 |
Generated 2024-09-21 12:45:06.435 UTC