[ROOT] dt FactResellerSale < WHERE DimSalesTerritoryId EQ '2' > SHUFFLE < SKIP 62 > < TAKE 31 >
31 items
FactResellerSaleId | CarrierTrackingNumber | CustomerPONumber | DimCurrencyId | DimEmployeeId | DimProductId | DimPromotionId | DimResellerId | DimSalesTerritoryId | DiscountAmount | DueDate | ExtendedAmount | Freight | OrderDate | OrderQuantity | ProductStandardCost | RevisionNumber | SalesAmount | SalesOrderLineNumber | SalesOrderNumber | ShipDate | TaxAmt | TotalProductCost | UnitPrice | UnitPriceDiscountPct |
---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
SO49888_37 | 01BB-49D0-BD | PO6699147895 | 100 | 283 | 221 | 234 | 2 | 2023-06-19 | 60.56 | 1.51 | 2023-06-07 | 3 | 13.88 | 1 | 60.56 | 37 | SO49888 | 2023-06-14 | 4.84 | 41.63 | 20.19 | |||
SO46369_3 | 624F-4843-9F | PO4756125698 | 100 | 272 | 319 | 126 | 2 | 2022-08-19 | 874.79 | 21.87 | 2022-08-07 | 1 | 884.71 | 1 | 874.79 | 3 | SO46369 | 2022-08-14 | 69.98 | 884.71 | 874.79 | |||
SO63200_41 | E73D-4A02-88 | PO11658161535 | 100 | 283 | 527 | 233 | 2 | 2024-04-20 | 158.43 | 3.96 | 2024-04-08 | 1 | 144.59 | 1 | 158.43 | 41 | SO63200 | 2024-04-15 | 12.67 | 144.59 | 158.43 | |||
SO46655_19 | F5D5-409B-94 | PO3828139841 | 100 | 281 | 364 | 414 | 2 | 2022-09-18 | 1295.99 | 32.40 | 2022-09-06 | 2 | 598.44 | 1 | 1295.99 | 19 | SO46655 | 2022-09-13 | 103.68 | 1196.87 | 647.99 | |||
SO51810_16 | 0D49-491D-BD | PO7453119597 | 100 | 283 | 234 | 3 | 108 | 2 | 24.75 | 2023-10-19 | 494.90 | 11.75 | 2023-10-07 | 18 | 38.49 | 1 | 470.16 | 16 | SO51810 | 2023-10-14 | 37.61 | 692.86 | 27.49 | 0.05 |
SO51157_45 | 927E-4DB1-A3 | PO3828155781 | 100 | 283 | 556 | 414 | 2 | 2023-09-18 | 210.59 | 5.26 | 2023-09-06 | 2 | 77.92 | 1 | 210.59 | 45 | SO51157 | 2023-09-13 | 16.85 | 155.84 | 105.29 | |||
SO48017_1 | 40DA-4972-BB | PO11658177389 | 100 | 281 | 391 | 233 | 2 | 2023-01-19 | 88.93 | 2.22 | 2023-01-07 | 1 | 65.81 | 1 | 88.93 | 1 | SO48017 | 2023-01-14 | 7.11 | 65.81 | 88.93 | |||
SO65153_3 | 0F10-4B75-A4 | PO19894114601 | 100 | 283 | 568 | 557 | 2 | 2024-05-19 | 445.41 | 11.14 | 2024-05-07 | 1 | 461.44 | 1 | 445.41 | 3 | SO65153 | 2024-05-14 | 35.63 | 461.44 | 445.41 | |||
SO44782_13 | 8A91-4DA7-97 | PO4408110571 | 100 | 281 | 270 | 143 | 2 | 2022-02-18 | 183.94 | 4.60 | 2022-02-06 | 1 | 181.49 | 1 | 183.94 | 13 | SO44782 | 2022-02-13 | 14.72 | 181.49 | 183.94 | |||
SO69544_21 | 89F3-4833-92 | PO3625111592 | 100 | 283 | 243 | 666 | 2 | 2024-07-19 | 3435.60 | 85.89 | 2024-07-07 | 4 | 868.63 | 1 | 3435.60 | 21 | SO69544 | 2024-07-14 | 274.85 | 3474.54 | 858.90 | |||
SO65236_17 | 46EF-4D44-A9 | PO9483140017 | 100 | 283 | 606 | 54 | 2 | 2024-05-19 | 971.98 | 24.30 | 2024-05-07 | 3 | 343.65 | 1 | 971.98 | 17 | SO65236 | 2024-05-14 | 77.76 | 1030.95 | 323.99 | |||
SO48077_9 | 02FD-483D-8C | PO7453110437 | 100 | 281 | 462 | 108 | 2 | 2023-01-19 | 28.26 | 0.71 | 2023-01-07 | 2 | 9.71 | 1 | 28.26 | 9 | SO48077 | 2023-01-14 | 2.26 | 19.43 | 14.13 | |||
SO59032_4 | DB21-4653-88 | PO4756173322 | 100 | 283 | 605 | 126 | 2 | 2024-02-18 | 647.99 | 16.20 | 2024-02-06 | 2 | 343.65 | 1 | 647.99 | 4 | SO59032 | 2024-02-13 | 51.84 | 687.30 | 323.99 | |||
SO48753_4 | 1DDA-42B2-AF | PO17197151135 | 100 | 283 | 358 | 125 | 2 | 2023-03-21 | 4917.84 | 122.95 | 2023-03-09 | 4 | 1105.81 | 1 | 4917.84 | 4 | SO48753 | 2023-03-16 | 393.43 | 4423.24 | 1229.46 | |||
SO50727_15 | 5DD5-4A9A-B1 | PO9483181443 | 100 | 283 | 265 | 54 | 2 | 2023-08-19 | 404.66 | 10.12 | 2023-08-07 | 2 | 187.16 | 1 | 404.66 | 15 | SO50727 | 2023-08-14 | 32.37 | 374.31 | 202.33 | |||
SO51810_1 | 0D49-491D-BD | PO7453119597 | 100 | 283 | 547 | 108 | 2 | 2023-10-19 | 97.19 | 2.43 | 2023-10-07 | 2 | 35.96 | 1 | 97.19 | 1 | SO51810 | 2023-10-14 | 7.78 | 71.92 | 48.59 | |||
SO69450_8 | 7050-466D-9B | PO10121172172 | 100 | 283 | 547 | 684 | 2 | 2024-07-19 | 97.19 | 2.43 | 2024-07-07 | 2 | 35.96 | 1 | 97.19 | 8 | SO69450 | 2024-07-14 | 7.78 | 71.92 | 48.59 | |||
SO46948_40 | B040-4261-B3 | PO18386128096 | 100 | 281 | 286 | 558 | 2 | 2022-10-19 | 551.81 | 13.80 | 2022-10-07 | 3 | 170.14 | 1 | 551.81 | 40 | SO46948 | 2022-10-14 | 44.15 | 510.43 | 183.94 | |||
SO47395_1 | 98F1-44B4-97 | PO11455133549 | 100 | 281 | 271 | 72 | 2 | 2022-11-19 | 2023.32 | 50.58 | 2022-11-07 | 10 | 187.16 | 1 | 2023.32 | 1 | SO47395 | 2022-11-14 | 161.87 | 1871.57 | 202.33 | |||
SO48739_13 | D31C-4E9E-A0 | PO10092156492 | 100 | 283 | 367 | 252 | 2 | 2023-03-21 | 1295.99 | 32.40 | 2023-03-09 | 2 | 598.44 | 1 | 1295.99 | 13 | SO48739 | 2023-03-16 | 103.68 | 1196.87 | 647.99 | |||
SO51111_30 | 5E49-4F77-BB | PO11484190487 | 100 | 283 | 476 | 3 | 594 | 2 | 32.72 | 2023-09-18 | 654.41 | 15.54 | 2023-09-06 | 17 | 26.18 | 1 | 621.69 | 30 | SO51111 | 2023-09-13 | 49.73 | 445.00 | 38.49 | 0.05 |
SO55239_28 | EDCD-45C2-B0 | PO17197177243 | 100 | 283 | 298 | 125 | 2 | 2023-12-19 | 2429.28 | 60.73 | 2023-12-07 | 3 | 739.04 | 1 | 2429.28 | 28 | SO55239 | 2023-12-14 | 194.34 | 2217.12 | 809.76 | |||
SO50290_8 | 241B-4766-8D | PO3625125287 | 100 | 283 | 329 | 666 | 2 | 2023-07-19 | 1409.38 | 35.23 | 2023-07-07 | 3 | 486.71 | 1 | 1409.38 | 8 | SO50290 | 2023-07-14 | 112.75 | 1460.12 | 469.79 | |||
SO46993_9 | F652-4085-A4 | PO11658111433 | 100 | 272 | 393 | 233 | 2 | 2022-10-19 | 275.39 | 6.88 | 2022-10-07 | 2 | 101.89 | 1 | 275.39 | 9 | SO46993 | 2022-10-14 | 22.03 | 203.79 | 137.69 | |||
SO63200_11 | E73D-4A02-88 | PO11658161535 | 100 | 283 | 512 | 233 | 2 | 2024-04-20 | 873.82 | 21.85 | 2024-04-08 | 4 | 199.38 | 1 | 873.82 | 11 | SO63200 | 2024-04-15 | 69.91 | 797.50 | 218.45 | |||
SO50259_33 | 2D7F-444F-AE | PO18386133550 | 100 | 283 | 369 | 558 | 2 | 2023-07-19 | 5864.04 | 146.60 | 2023-07-07 | 4 | 1518.79 | 1 | 5864.04 | 33 | SO50259 | 2023-07-14 | 469.12 | 6075.15 | 1466.01 | |||
SO46620_30 | FEE3-4994-8E | PO13775143788 | 100 | 281 | 343 | 618 | 2 | 2022-09-18 | 1409.38 | 35.23 | 2022-09-06 | 3 | 486.71 | 1 | 1409.38 | 30 | SO46620 | 2022-09-13 | 112.75 | 1460.12 | 469.79 | |||
SO47718_2 | B391-4A07-98 | PO6699137967 | 100 | 281 | 414 | 234 | 2 | 2022-12-19 | 447.09 | 11.18 | 2022-12-07 | 3 | 110.28 | 1 | 447.09 | 2 | SO47718 | 2022-12-14 | 35.77 | 330.85 | 149.03 | |||
SO61209_5 | C31E-48AE-AF | PO11484136165 | 100 | 283 | 544 | 594 | 2 | 2024-03-20 | 97.19 | 2.43 | 2024-03-08 | 2 | 35.96 | 1 | 97.19 | 5 | SO61209 | 2024-03-15 | 7.78 | 71.92 | 48.59 | |||
SO47718_23 | B391-4A07-98 | PO6699137967 | 100 | 281 | 213 | 234 | 2 | 2022-12-19 | 100.93 | 2.52 | 2022-12-07 | 5 | 13.88 | 1 | 100.93 | 23 | SO47718 | 2022-12-14 | 8.07 | 69.39 | 20.19 | |||
SO61209_3 | C31E-48AE-AF | PO11484136165 | 100 | 283 | 532 | 594 | 2 | 2024-03-20 | 149.87 | 3.75 | 2024-03-08 | 1 | 136.79 | 1 | 149.87 | 3 | SO61209 | 2024-03-15 | 11.99 | 136.79 | 149.87 |
Generated 2024-10-06 12:53:10.897 UTC