[ROOT] dt FactResellerSale < WHERE DimSalesTerritoryId EQ '2' > SHUFFLE SKIP 2000 < SKIP 503 > < 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 |
---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
SO50235_30 | 20B9-4308-A5 | PO10121141993 | 100 | 283 | 242 | 684 | 2 | 2023-07-03 | 780.82 | 19.52 | 2023-06-21 | 1 | 722.26 | 1 | 780.82 | 30 | SO50235 | 2023-06-28 | 62.47 | 722.26 | 780.82 |
SO46948_6 | B040-4261-B3 | PO18386128096 | 100 | 281 | 230 | 558 | 2 | 2022-10-03 | 201.88 | 5.05 | 2022-09-21 | 7 | 29.08 | 1 | 201.88 | 6 | SO46948 | 2022-09-28 | 16.15 | 203.56 | 28.84 |
SO51748_3 | 1D77-486A-86 | PO11658169327 | 100 | 283 | 544 | 233 | 2 | 2023-10-03 | 97.19 | 2.43 | 2023-09-21 | 2 | 35.96 | 1 | 97.19 | 3 | SO51748 | 2023-09-28 | 7.78 | 71.92 | 48.59 |
SO46655_18 | F5D5-409B-94 | PO3828139841 | 100 | 281 | 396 | 414 | 2 | 2022-09-02 | 149.68 | 3.74 | 2022-08-21 | 2 | 55.38 | 1 | 149.68 | 18 | SO46655 | 2022-08-28 | 11.97 | 110.76 | 74.84 |
SO48770_2 | 28CC-48AC-B8 | PO11484112888 | 100 | 283 | 366 | 594 | 2 | 2023-03-05 | 3887.96 | 97.20 | 2023-02-21 | 6 | 598.44 | 1 | 3887.96 | 2 | SO48770 | 2023-02-28 | 311.04 | 3590.61 | 647.99 |
SO47664_7 | 4F8A-4646-B5 | PO17197195500 | 100 | 281 | 409 | 125 | 2 | 2022-12-03 | 209.26 | 5.23 | 2022-11-21 | 1 | 185.82 | 1 | 209.26 | 7 | SO47664 | 2022-11-28 | 16.74 | 185.82 | 209.26 |
SO46655_7 | F5D5-409B-94 | PO3828139841 | 100 | 281 | 394 | 414 | 2 | 2022-09-02 | 41.04 | 1.03 | 2022-08-21 | 2 | 15.18 | 1 | 41.04 | 7 | SO46655 | 2022-08-28 | 3.28 | 30.37 | 20.52 |
SO50683_10 | 8EBE-4D2C-AB | PO11455112273 | 100 | 283 | 435 | 72 | 2 | 2023-08-03 | 1297.81 | 32.45 | 2023-07-22 | 4 | 300.12 | 1 | 1297.81 | 10 | SO50683 | 2023-07-29 | 103.82 | 1200.48 | 324.45 |
SO67314_22 | 6653-491A-80 | PO3828116396 | 100 | 283 | 542 | 414 | 2 | 2024-06-03 | 24.29 | 0.61 | 2024-05-22 | 1 | 17.98 | 1 | 24.29 | 22 | SO67314 | 2024-05-29 | 1.94 | 17.98 | 24.29 |
SO55239_3 | EDCD-45C2-B0 | PO17197177243 | 100 | 283 | 588 | 125 | 2 | 2023-12-03 | 461.69 | 11.54 | 2023-11-21 | 1 | 419.78 | 1 | 461.69 | 3 | SO55239 | 2023-11-28 | 36.94 | 419.78 | 461.69 |
SO48077_18 | 02FD-483D-8C | PO7453110437 | 100 | 281 | 417 | 108 | 2 | 2023-01-03 | 973.36 | 24.33 | 2022-12-22 | 3 | 300.12 | 1 | 973.36 | 18 | SO48077 | 2022-12-29 | 77.87 | 900.36 | 324.45 |
SO63200_7 | E73D-4A02-88 | PO11658161535 | 100 | 283 | 465 | 233 | 2 | 2024-04-04 | 58.78 | 1.47 | 2024-03-23 | 4 | 9.16 | 1 | 58.78 | 7 | SO63200 | 2024-03-30 | 4.70 | 36.64 | 14.69 |
SO46655_2 | F5D5-409B-94 | PO3828139841 | 100 | 281 | 469 | 414 | 2 | 2022-09-02 | 68.38 | 1.71 | 2022-08-21 | 3 | 15.67 | 1 | 68.38 | 2 | SO46655 | 2022-08-28 | 5.47 | 47.01 | 22.79 |
SO45067_3 | 59F9-45DB-B4 | PO4959186788 | 100 | 281 | 264 | 269 | 2 | 2022-03-05 | 183.94 | 4.60 | 2022-02-21 | 1 | 181.49 | 1 | 183.94 | 3 | SO45067 | 2022-02-28 | 14.72 | 181.49 | 183.94 |
SO65262_2 | 2D76-4C33-96 | PO8352189306 | 100 | 283 | 547 | 636 | 2 | 2024-05-03 | 145.78 | 3.64 | 2024-04-21 | 3 | 35.96 | 1 | 145.78 | 2 | SO65262 | 2024-04-28 | 11.66 | 107.88 | 48.59 |
SO63219_8 | E19D-4F90-91 | PO7453184328 | 100 | 283 | 231 | 108 | 2 | 2024-04-04 | 269.95 | 6.75 | 2024-03-23 | 9 | 38.49 | 1 | 269.95 | 8 | SO63219 | 2024-03-30 | 21.60 | 346.43 | 29.99 |
SO47685_36 | CC2F-4D47-8C | PO11484129630 | 100 | 281 | 233 | 594 | 2 | 2022-12-03 | 28.84 | 0.72 | 2022-11-21 | 1 | 29.08 | 1 | 28.84 | 36 | SO47685 | 2022-11-28 | 2.31 | 29.08 | 28.84 |
SO59074_26 | 1711-471C-82 | PO9483120932 | 100 | 283 | 386 | 54 | 2 | 2024-02-02 | 672.29 | 16.81 | 2024-01-21 | 1 | 713.08 | 1 | 672.29 | 26 | SO59074 | 2024-01-28 | 53.78 | 713.08 | 672.29 |
SO51762_19 | E7DC-4AC1-AD | PO10121132749 | 100 | 283 | 374 | 684 | 2 | 2023-10-03 | 5864.04 | 146.60 | 2023-09-21 | 4 | 1554.95 | 1 | 5864.04 | 19 | SO51762 | 2023-09-28 | 469.12 | 6219.79 | 1466.01 |
SO48002_1 | C49A-4171-8A | PO14326161105 | 100 | 281 | 329 | 107 | 2 | 2023-01-03 | 2818.76 | 70.47 | 2022-12-22 | 6 | 486.71 | 1 | 2818.76 | 1 | SO48002 | 2022-12-29 | 225.50 | 2920.24 | 469.79 |
SO59012_46 | 6620-4CEA-A0 | PO7685122244 | 100 | 283 | 499 | 539 | 2 | 2024-02-02 | 1204.69 | 30.12 | 2024-01-21 | 2 | 601.74 | 1 | 1204.69 | 46 | SO59012 | 2024-01-28 | 96.38 | 1203.49 | 602.35 |
SO46948_19 | B040-4261-B3 | PO18386128096 | 100 | 281 | 337 | 558 | 2 | 2022-10-03 | 469.79 | 11.74 | 2022-09-21 | 1 | 486.71 | 1 | 469.79 | 19 | SO46948 | 2022-09-28 | 37.58 | 486.71 | 469.79 |
SO44559_13 | 8618-4A1B-AD | PO6641148111 | 100 | 281 | 253 | 342 | 2 | 2022-01-03 | 357.16 | 8.93 | 2021-12-22 | 2 | 176.20 | 1 | 357.16 | 13 | SO44559 | 2021-12-29 | 28.57 | 352.40 | 178.58 |
SO48392_47 | B9C7-4F4D-82 | PO9483147187 | 100 | 281 | 368 | 54 | 2 | 2023-02-02 | 4398.03 | 109.95 | 2023-01-21 | 3 | 1518.79 | 1 | 4398.03 | 47 | SO48392 | 2023-01-28 | 351.84 | 4556.36 | 1466.01 |
SO65302_1 | D099-43BF-9C | PO4408195941 | 100 | 283 | 487 | 143 | 2 | 2024-05-03 | 65.99 | 1.65 | 2024-04-21 | 2 | 20.57 | 1 | 65.99 | 1 | SO65302 | 2024-04-28 | 5.28 | 41.13 | 32.99 |
SO46036_17 | DBE7-4B0A-93 | PO18386134137 | 100 | 281 | 215 | 558 | 2 | 2022-07-03 | 20.19 | 0.50 | 2022-06-21 | 1 | 12.03 | 1 | 20.19 | 17 | SO46036 | 2022-06-28 | 1.61 | 12.03 | 20.19 |
SO65194_6 | 3164-44BE-9B | PO12325153918 | 100 | 283 | 579 | 53 | 2 | 2024-05-03 | 1457.82 | 36.45 | 2024-04-21 | 2 | 755.15 | 1 | 1457.82 | 6 | SO65194 | 2024-04-28 | 116.63 | 1510.30 | 728.91 |
SO61224_18 | 3D8E-4C8E-B7 | PO13775159907 | 100 | 283 | 582 | 618 | 2 | 2024-03-04 | 3061.78 | 76.54 | 2024-02-21 | 3 | 1082.51 | 1 | 3061.78 | 18 | SO61224 | 2024-02-28 | 244.94 | 3247.53 | 1020.59 |
Generated 2024-09-20 07:44:26.648 UTC