[ROOT] dt FactResellerSale WHERE DimSalesTerritoryId EQ '1' > SHUFFLE < SKIP 6844 > < TAKE 31 >
31 items
FactResellerSaleId | CarrierTrackingNumber | CustomerPONumber | DimCurrencyId | DimEmployeeId | DimProductId | DimResellerId | DimSalesTerritoryId | DueDate | ExtendedAmount | Freight | OrderDate | OrderQuantity | ProductStandardCost | RevisionNumber | SalesAmount | SalesOrderLineNumber | SalesOrderNumber | ShipDate | TaxAmt | TotalProductCost | UnitPrice |
---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
SO46379_5 | 8ABD-4B11-A1 | PO7192140645 | 100 | 289 | 223 | 20 | 1 | 2022-08-03 | 5.19 | 0.13 | 2022-07-22 | 1 | 5.71 | 1 | 5.19 | 5 | SO46379 | 2022-07-29 | 0.41 | 5.71 | 5.19 |
SO50321_10 | 6B3D-47E0-99 | PO8816191637 | 100 | 289 | 375 | 218 | 1 | 2023-07-03 | 2617.88 | 65.45 | 2023-06-21 | 2 | 1320.68 | 1 | 2617.88 | 10 | SO50321 | 2023-06-28 | 209.43 | 2641.37 | 1308.94 |
SO46105_34 | 2590-40A7-BB | PO8816169858 | 100 | 289 | 330 | 218 | 1 | 2022-07-03 | 1258.38 | 31.46 | 2022-06-21 | 3 | 413.15 | 1 | 1258.38 | 34 | SO46105 | 2022-06-28 | 100.67 | 1239.44 | 419.46 |
SO53500_29 | BEF0-4525-AF | PO12470126979 | 100 | 287 | 499 | 672 | 1 | 2023-11-03 | 2409.38 | 60.23 | 2023-10-22 | 4 | 601.74 | 1 | 2409.38 | 29 | SO53500 | 2023-10-29 | 192.75 | 2406.97 | 602.35 |
SO46102_5 | ADBC-4E22-85 | PO7917135523 | 100 | 287 | 346 | 401 | 1 | 2022-07-03 | 2039.99 | 51.00 | 2022-06-21 | 1 | 1912.15 | 1 | 2039.99 | 5 | SO46102 | 2022-06-28 | 163.20 | 1912.15 | 2039.99 |
SO46974_48 | BEE6-4EC8-8E | PO14442112586 | 100 | 286 | 410 | 127 | 1 | 2022-10-03 | 145.79 | 3.64 | 2022-09-21 | 4 | 26.97 | 1 | 145.79 | 48 | SO46974 | 2022-09-28 | 11.66 | 107.88 | 36.45 |
SO48057_36 | 53D7-4BA4-AB | PO4727174880 | 100 | 293 | 369 | 343 | 1 | 2023-01-03 | 4398.03 | 109.95 | 2022-12-22 | 3 | 1518.79 | 1 | 4398.03 | 36 | SO48057 | 2022-12-29 | 351.84 | 4556.36 | 1466.01 |
SO63157_12 | 9E62-4577-80 | PO14500183845 | 100 | 282 | 556 | 650 | 1 | 2024-04-04 | 105.29 | 2.63 | 2024-03-23 | 1 | 77.92 | 1 | 105.29 | 12 | SO63157 | 2024-03-30 | 8.42 | 77.92 | 105.29 |
SO45782_5 | D609-4F2A-9B | PO16588186502 | 100 | 289 | 292 | 146 | 1 | 2022-06-03 | 1637.40 | 40.94 | 2022-05-22 | 2 | 706.81 | 1 | 1637.40 | 5 | SO45782 | 2022-05-29 | 130.99 | 1413.62 | 818.70 |
SO44511_2 | 4BD6-4CFA-B8 | PO14529113218 | 100 | 286 | 347 | 289 | 1 | 2022-01-03 | 2039.99 | 51.00 | 2021-12-22 | 1 | 1912.15 | 1 | 2039.99 | 2 | SO44511 | 2021-12-29 | 163.20 | 1912.15 | 2039.99 |
SO50210_14 | 6347-4C03-9B | PO15631112842 | 100 | 282 | 419 | 43 | 1 | 2023-07-03 | 157.94 | 3.95 | 2023-06-21 | 3 | 38.96 | 1 | 157.94 | 14 | SO50210 | 2023-06-28 | 12.64 | 116.88 | 52.65 |
SO63156_13 | B5C5-474E-8D | PO14587116412 | 100 | 293 | 586 | 199 | 1 | 2024-04-04 | 1781.64 | 44.54 | 2024-03-23 | 4 | 461.44 | 1 | 1781.64 | 13 | SO63156 | 2024-03-30 | 142.53 | 1845.78 | 445.41 |
SO46967_21 | 6486-4AF8-A6 | PO15573116583 | 100 | 286 | 358 | 487 | 1 | 2022-10-03 | 2458.92 | 61.47 | 2022-09-21 | 2 | 1105.81 | 1 | 2458.92 | 21 | SO46967 | 2022-09-28 | 196.71 | 2211.62 | 1229.46 |
SO46974_12 | BEE6-4EC8-8E | PO14442112586 | 100 | 286 | 466 | 127 | 1 | 2022-10-03 | 28.26 | 0.71 | 2022-09-21 | 2 | 9.71 | 1 | 28.26 | 12 | SO46974 | 2022-09-28 | 2.26 | 19.43 | 14.13 |
SO46611_39 | 93A4-4A4D-99 | PO16588117269 | 100 | 289 | 308 | 146 | 1 | 2022-09-02 | 5209.91 | 130.25 | 2022-08-21 | 7 | 660.91 | 1 | 5209.91 | 39 | SO46611 | 2022-08-28 | 416.79 | 4626.40 | 744.27 |
SO44109_6 | 1055-4F53-BB | PO783112882 | 100 | 286 | 232 | 91 | 1 | 2021-11-03 | 57.68 | 1.44 | 2021-10-22 | 2 | 31.72 | 1 | 57.68 | 6 | SO44109 | 2021-10-29 | 4.61 | 63.45 | 28.84 |
SO65312_16 | 19D1-4059-B8 | PO6815121334 | 100 | 293 | 225 | 109 | 1 | 2024-05-03 | 21.58 | 0.54 | 2024-04-21 | 4 | 6.92 | 1 | 21.58 | 16 | SO65312 | 2024-04-28 | 1.73 | 27.69 | 5.39 |
SO44121_12 | FE2E-4885-B3 | PO5220129819 | 100 | 282 | 346 | 169 | 1 | 2021-11-03 | 16319.95 | 408.00 | 2021-10-22 | 8 | 1912.15 | 1 | 16319.95 | 12 | SO44121 | 2021-10-29 | 1305.60 | 15297.24 | 2039.99 |
SO57036_15 | A71E-4FC0-8D | PO15631137127 | 100 | 282 | 474 | 43 | 1 | 2024-01-03 | 209.97 | 5.25 | 2023-12-22 | 5 | 26.18 | 1 | 209.97 | 15 | SO57036 | 2023-12-29 | 16.80 | 130.88 | 41.99 |
SO71943_2 | E676-4002-A7 | PO9309168525 | 100 | 293 | 576 | 55 | 1 | 2024-08-03 | 5721.77 | 143.04 | 2024-07-22 | 4 | 1481.94 | 1 | 5721.77 | 2 | SO71943 | 2024-07-29 | 457.74 | 5927.75 | 1430.44 |
SO50218_35 | B8E9-4FE2-8B | PO14442144367 | 100 | 293 | 305 | 127 | 1 | 2023-07-03 | 1472.29 | 36.81 | 2023-06-21 | 2 | 653.70 | 1 | 1472.29 | 35 | SO50218 | 2023-06-28 | 117.78 | 1307.39 | 736.15 |
SO49852_5 | 5DD7-447A-8D | PO2581189096 | 100 | 282 | 422 | 698 | 1 | 2023-06-03 | 135.08 | 3.38 | 2023-05-22 | 2 | 49.98 | 1 | 135.08 | 5 | SO49852 | 2023-05-29 | 10.81 | 99.96 | 67.54 |
SO65270_1 | E73B-4A64-B4 | PO7192196898 | 100 | 289 | 474 | 20 | 1 | 2024-05-03 | 83.99 | 2.10 | 2024-04-21 | 2 | 26.18 | 1 | 83.99 | 1 | SO65270 | 2024-04-28 | 6.72 | 52.35 | 41.99 |
SO50693_23 | 0DA5-4EE4-93 | PO841149385 | 100 | 286 | 396 | 254 | 1 | 2023-08-03 | 74.84 | 1.87 | 2023-07-22 | 1 | 55.38 | 1 | 74.84 | 23 | SO50693 | 2023-07-29 | 5.99 | 55.38 | 74.84 |
SO58961_44 | 0848-4E9B-81 | PO10411162031 | 100 | 289 | 560 | 182 | 1 | 2024-02-02 | 1457.82 | 36.45 | 2024-01-21 | 2 | 755.15 | 1 | 1457.82 | 44 | SO58961 | 2024-01-28 | 116.63 | 1510.30 | 728.91 |
SO46611_28 | 93A4-4A4D-99 | PO16588117269 | 100 | 289 | 366 | 146 | 1 | 2022-09-02 | 647.99 | 16.20 | 2022-08-21 | 1 | 598.44 | 1 | 647.99 | 28 | SO46611 | 2022-08-28 | 51.84 | 598.44 | 647.99 |
SO43860_5 | E57D-4B4B-BF | PO16646146654 | 100 | 286 | 275 | 1 | 1 | 2021-10-03 | 356.90 | 8.92 | 2021-09-21 | 1 | 352.14 | 1 | 356.90 | 5 | SO43860 | 2021-09-28 | 28.55 | 352.14 | 356.90 |
SO47033_16 | 2797-46ED-BB | PO4727113716 | 100 | 286 | 387 | 343 | 1 | 2022-10-03 | 3001.31 | 75.03 | 2022-09-21 | 5 | 605.65 | 1 | 3001.31 | 16 | SO47033 | 2022-09-28 | 240.11 | 3028.25 | 600.26 |
SO50209_8 | D138-4E7C-86 | PO15573136083 | 100 | 293 | 448 | 487 | 1 | 2023-07-03 | 59.97 | 1.50 | 2023-06-21 | 5 | 8.25 | 1 | 59.97 | 8 | SO50209 | 2023-06-28 | 4.80 | 41.23 | 11.99 |
SO43895_9 | 5233-4CB8-BC | PO2900121738 | 100 | 286 | 351 | 469 | 1 | 2021-10-03 | 8099.98 | 202.50 | 2021-09-21 | 4 | 1898.09 | 1 | 8099.98 | 9 | SO43895 | 2021-09-28 | 648.00 | 7592.38 | 2024.99 |
SO47701_7 | 5718-4DDD-B7 | PO2929114832 | 100 | 289 | 456 | 380 | 1 | 2022-12-03 | 44.99 | 1.12 | 2022-11-21 | 1 | 30.93 | 1 | 44.99 | 7 | SO47701 | 2022-11-28 | 3.60 | 30.93 | 44.99 |
Generated 2024-09-20 03:38:13.346 UTC