[ROOT] dt FactResellerSale < WHERE DimSalesTerritoryId EQ '6' > SHUFFLE < SKIP 7147 > < TAKE 24 >
24 items
FactResellerSaleId | CarrierTrackingNumber | CustomerPONumber | DimCurrencyId | DimEmployeeId | DimProductId | DimResellerId | DimSalesTerritoryId | DueDate | ExtendedAmount | Freight | OrderDate | OrderQuantity | ProductStandardCost | RevisionNumber | SalesAmount | SalesOrderLineNumber | SalesOrderNumber | ShipDate | TaxAmt | TotalProductCost | UnitPrice |
---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
SO47663_37 | 1B17-4C63-B6 | PO18444192283 | 19 | 291 | 373 | 227 | 6 | 2022-12-04 | 3926.81 | 98.17 | 2022-11-22 | 3 | 1320.68 | 1 | 3926.81 | 37 | SO47663 | 2022-11-29 | 314.15 | 3962.05 | 1308.94 |
SO65185_1 | F67E-4928-A7 | PO14906159435 | 19 | 291 | 544 | 424 | 6 | 2024-05-04 | 48.59 | 1.21 | 2024-04-22 | 1 | 35.96 | 1 | 48.59 | 1 | SO65185 | 2024-04-29 | 3.89 | 35.96 | 48.59 |
SO45553_5 | 87C3-40D7-80 | PO1885177550 | 19 | 284 | 344 | 588 | 6 | 2022-05-04 | 10199.97 | 255.00 | 2022-04-22 | 5 | 1912.15 | 1 | 10199.97 | 5 | SO45553 | 2022-04-29 | 816.00 | 9560.77 | 2039.99 |
SO51850_6 | 57A9-4C32-8B | PO1856170170 | 19 | 291 | 560 | 263 | 6 | 2023-10-04 | 3644.55 | 91.11 | 2023-09-22 | 5 | 755.15 | 1 | 3644.55 | 6 | SO51850 | 2023-09-29 | 291.56 | 3775.75 | 728.91 |
SO46608_2 | ACF1-4852-B7 | PO18473177913 | 19 | 291 | 308 | 442 | 6 | 2022-09-03 | 2977.09 | 74.43 | 2022-08-22 | 4 | 660.91 | 1 | 2977.09 | 2 | SO46608 | 2022-08-29 | 238.17 | 2643.66 | 744.27 |
SO58981_28 | 2B52-4247-AF | PO18299143459 | 19 | 291 | 531 | 118 | 6 | 2024-02-03 | 449.62 | 11.24 | 2024-01-22 | 3 | 136.79 | 1 | 449.62 | 28 | SO58981 | 2024-01-29 | 35.97 | 410.36 | 149.87 |
SO69479_3 | 3D8D-4908-A6 | PO18328116976 | 19 | 284 | 382 | 552 | 6 | 2024-07-04 | 1344.59 | 33.61 | 2024-06-22 | 2 | 713.08 | 1 | 1344.59 | 3 | SO69479 | 2024-06-29 | 107.57 | 1426.16 | 672.29 |
SO47973_27 | B9F1-47DA-87 | PO18705118148 | 19 | 291 | 321 | 479 | 6 | 2023-01-04 | 939.59 | 23.49 | 2022-12-23 | 2 | 486.71 | 1 | 939.59 | 27 | SO47973 | 2022-12-30 | 75.17 | 973.41 | 469.79 |
SO63239_15 | AF5E-48ED-A4 | PO4901178462 | 19 | 284 | 487 | 84 | 6 | 2024-04-05 | 98.98 | 2.47 | 2024-03-24 | 3 | 20.57 | 1 | 98.98 | 15 | SO63239 | 2024-03-31 | 7.92 | 61.70 | 32.99 |
SO50694_37 | DAEB-4730-9B | PO17545120609 | 19 | 291 | 325 | 155 | 6 | 2023-08-04 | 2348.97 | 58.72 | 2023-07-23 | 5 | 486.71 | 1 | 2348.97 | 37 | SO50694 | 2023-07-30 | 187.92 | 2433.53 | 469.79 |
SO49039_5 | 4F9E-4A1A-B3 | PO20039119229 | 19 | 291 | 470 | 65 | 6 | 2023-04-06 | 91.18 | 2.28 | 2023-03-25 | 4 | 15.67 | 1 | 91.18 | 5 | SO49039 | 2023-04-01 | 7.29 | 62.68 | 22.79 |
SO63177_20 | 87AD-4113-AD | PO1856115383 | 19 | 291 | 499 | 263 | 6 | 2024-04-05 | 602.35 | 15.06 | 2024-03-24 | 1 | 601.74 | 1 | 602.35 | 20 | SO63177 | 2024-03-31 | 48.19 | 601.74 | 602.35 |
SO45310_5 | E43D-4178-B9 | PO10469159835 | 19 | 288 | 348 | 335 | 6 | 2022-04-06 | 4049.99 | 101.25 | 2022-03-25 | 2 | 1898.09 | 1 | 4049.99 | 5 | SO45310 | 2022-04-01 | 324.00 | 3796.19 | 2024.99 |
SO47365_16 | 4535-457B-B0 | PO17574153673 | 19 | 291 | 410 | 678 | 6 | 2022-11-04 | 36.45 | 0.91 | 2022-10-23 | 1 | 26.97 | 1 | 36.45 | 16 | SO47365 | 2022-10-30 | 2.92 | 26.97 | 36.45 |
SO51772_7 | 7800-4280-A7 | PO1827195162 | 19 | 291 | 481 | 317 | 6 | 2023-10-04 | 10.79 | 0.27 | 2023-09-22 | 2 | 3.36 | 1 | 10.79 | 7 | SO51772 | 2023-09-29 | 0.86 | 6.72 | 5.39 |
SO58958_34 | BC3F-443F-B5 | PO10875118816 | 19 | 291 | 480 | 281 | 6 | 2024-02-03 | 5.50 | 0.14 | 2024-01-22 | 4 | 0.86 | 1 | 5.50 | 34 | SO58958 | 2024-01-29 | 0.44 | 3.43 | 1.37 |
SO55275_20 | 72C3-4048-BC | PO1711122362 | 19 | 291 | 295 | 245 | 6 | 2023-12-04 | 3274.80 | 81.87 | 2023-11-22 | 4 | 747.20 | 1 | 3274.80 | 20 | SO55275 | 2023-11-29 | 261.98 | 2988.80 | 818.70 |
SO49454_1 | C24C-4087-A6 | PO17690116637 | 19 | 291 | 468 | 47 | 6 | 2023-05-04 | 22.79 | 0.57 | 2023-04-22 | 1 | 15.67 | 1 | 22.79 | 1 | SO49454 | 2023-04-29 | 1.82 | 15.67 | 22.79 |
SO47981_3 | A272-4BA9-85 | PO17313181161 | 19 | 272 | 469 | 389 | 6 | 2023-01-04 | 227.94 | 5.70 | 2022-12-23 | 10 | 15.67 | 1 | 227.94 | 3 | SO47981 | 2022-12-30 | 18.24 | 156.71 | 22.79 |
SO67316_22 | 6F7E-4455-9E | PO4495115494 | 19 | 291 | 231 | 496 | 6 | 2024-06-04 | 89.98 | 2.25 | 2024-05-23 | 3 | 38.49 | 1 | 89.98 | 22 | SO67316 | 2024-05-30 | 7.20 | 115.48 | 29.99 |
SO47399_14 | B5FA-4CC2-8C | PO10962177551 | 19 | 284 | 356 | 685 | 6 | 2022-11-04 | 3728.56 | 93.21 | 2022-10-23 | 3 | 1117.86 | 1 | 3728.56 | 14 | SO47399 | 2022-10-30 | 298.28 | 3353.57 | 1242.85 |
SO48778_5 | 4F83-4D59-87 | PO4495173571 | 19 | 291 | 421 | 496 | 6 | 2023-03-06 | 588.99 | 14.72 | 2023-02-22 | 3 | 145.28 | 1 | 588.99 | 5 | SO48778 | 2023-03-01 | 47.12 | 435.85 | 196.33 |
SO49140_30 | EFF3-483D-BE | PO4901154744 | 19 | 284 | 461 | 84 | 6 | 2023-04-06 | 269.97 | 6.75 | 2023-03-25 | 5 | 37.12 | 1 | 269.97 | 30 | SO49140 | 2023-04-01 | 21.60 | 185.60 | 53.99 |
SO67319_4 | 8C98-4B9E-AA | PO4930193183 | 19 | 291 | 475 | 425 | 6 | 2024-06-04 | 83.99 | 2.10 | 2024-05-23 | 2 | 26.18 | 1 | 83.99 | 4 | SO67319 | 2024-05-30 | 6.72 | 52.35 | 41.99 |
Generated 2024-09-21 04:40:28.747 UTC