[ROOT] dt FactResellerSale < WHERE DimSalesTerritoryId EQ '2' > SHUFFLE SKIP 2000 < SKIP 899 > < TAKE 30 >
30 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 |
---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
SO71947_39 | 7269-4186-92 | PO9628115897 | 100 | 283 | 471 | 179 | 2 | 2024-08-04 | 190.50 | 4.76 | 2024-07-23 | 5 | 23.75 | 1 | 190.50 | 39 | SO71947 | 2024-07-30 | 15.24 | 118.75 | 38.10 | |||
SO53537_6 | C14C-4596-A3 | PO19894159880 | 100 | 283 | 521 | 557 | 2 | 2023-11-04 | 32.54 | 0.81 | 2023-10-23 | 2 | 12.04 | 1 | 32.54 | 6 | SO53537 | 2023-10-30 | 2.60 | 24.08 | 16.27 | |||
SO44313_17 | 6613-4427-84 | PO5365138960 | 100 | 281 | 275 | 161 | 2 | 2021-12-04 | 356.90 | 8.92 | 2021-11-22 | 1 | 352.14 | 1 | 356.90 | 17 | SO44313 | 2021-11-29 | 28.55 | 352.14 | 356.90 | |||
SO57065_25 | B68A-407E-99 | PO11658151711 | 100 | 283 | 476 | 233 | 2 | 2024-01-04 | 125.98 | 3.15 | 2023-12-23 | 3 | 26.18 | 1 | 125.98 | 25 | SO57065 | 2023-12-30 | 10.08 | 78.53 | 41.99 | |||
SO50741_2 | B860-44B9-90 | PO4408114284 | 100 | 283 | 417 | 143 | 2 | 2023-08-04 | 324.45 | 8.11 | 2023-07-23 | 1 | 300.12 | 1 | 324.45 | 2 | SO50741 | 2023-07-30 | 25.96 | 300.12 | 324.45 | |||
SO43907_13 | 9CB1-46F4-8A | PO6641115253 | 100 | 281 | 270 | 342 | 2 | 2021-10-04 | 183.94 | 4.60 | 2021-09-22 | 1 | 181.49 | 1 | 183.94 | 13 | SO43907 | 2021-09-29 | 14.72 | 181.49 | 183.94 | |||
SO48739_4 | D31C-4E9E-A0 | PO10092156492 | 100 | 283 | 469 | 2 | 252 | 2 | 5.29 | 2023-03-06 | 264.41 | 6.48 | 2023-02-22 | 12 | 15.67 | 1 | 259.12 | 4 | SO48739 | 2023-03-01 | 20.73 | 188.05 | 22.03 | 0.02 |
SO71824_4 | BBB4-42D9-86 | PO11455162600 | 100 | 283 | 545 | 72 | 2 | 2024-08-04 | 97.18 | 2.43 | 2024-07-23 | 4 | 17.98 | 1 | 97.18 | 4 | SO71824 | 2024-07-30 | 7.77 | 71.91 | 24.29 | |||
SO49113_36 | 4C8B-47E0-A7 | PO11658167469 | 100 | 283 | 294 | 233 | 2 | 2023-04-06 | 744.27 | 18.61 | 2023-03-25 | 1 | 660.91 | 1 | 744.27 | 36 | SO49113 | 2023-04-01 | 59.54 | 660.91 | 744.27 | |||
SO47675_36 | 8515-427F-B6 | PO13775136623 | 100 | 281 | 224 | 618 | 2 | 2022-12-04 | 31.12 | 0.78 | 2022-11-22 | 6 | 5.23 | 1 | 31.12 | 36 | SO47675 | 2022-11-29 | 2.49 | 31.38 | 5.19 | |||
SO49881_1 | 4C01-4D40-87 | PO5365121745 | 100 | 283 | 371 | 161 | 2 | 2023-06-04 | 1308.94 | 32.72 | 2023-05-23 | 1 | 1320.68 | 1 | 1308.94 | 1 | SO49881 | 2023-05-30 | 104.72 | 1320.68 | 1308.94 | |||
SO63219_20 | E19D-4F90-91 | PO7453184328 | 100 | 283 | 487 | 108 | 2 | 2024-04-05 | 98.98 | 2.47 | 2024-03-24 | 3 | 20.57 | 1 | 98.98 | 20 | SO63219 | 2024-03-31 | 7.92 | 61.70 | 32.99 | |||
SO44129_7 | CE0D-4824-A6 | PO9483186106 | 100 | 281 | 232 | 54 | 2 | 2021-11-04 | 144.20 | 3.61 | 2021-10-23 | 5 | 31.72 | 1 | 144.20 | 7 | SO44129 | 2021-10-30 | 11.54 | 158.62 | 28.84 | |||
SO45069_11 | 720B-4C18-89 | PO5365112854 | 100 | 281 | 315 | 161 | 2 | 2022-03-06 | 1749.59 | 43.74 | 2022-02-22 | 2 | 884.71 | 1 | 1749.59 | 11 | SO45069 | 2022-03-01 | 139.97 | 1769.42 | 874.79 | |||
SO71947_34 | 7269-4186-92 | PO9628115897 | 100 | 283 | 559 | 179 | 2 | 2024-08-04 | 12.14 | 0.30 | 2024-07-23 | 1 | 8.99 | 1 | 12.14 | 34 | SO71947 | 2024-07-30 | 0.97 | 8.99 | 12.14 | |||
SO48753_5 | 1DDA-42B2-AF | PO17197151135 | 100 | 283 | 354 | 125 | 2 | 2023-03-06 | 4971.41 | 124.29 | 2023-02-22 | 4 | 1117.86 | 1 | 4971.41 | 5 | SO48753 | 2023-03-01 | 397.71 | 4471.42 | 1242.85 | |||
SO51157_38 | 927E-4DB1-A3 | PO3828155781 | 100 | 283 | 552 | 414 | 2 | 2023-09-03 | 109.79 | 2.74 | 2023-08-22 | 2 | 40.62 | 1 | 109.79 | 38 | SO51157 | 2023-08-29 | 8.78 | 81.24 | 54.89 | |||
SO47975_5 | 5E8C-4BD8-B5 | PO18386179371 | 100 | 281 | 460 | 558 | 2 | 2023-01-04 | 107.99 | 2.70 | 2022-12-23 | 2 | 37.12 | 1 | 107.99 | 5 | SO47975 | 2022-12-30 | 8.64 | 74.24 | 53.99 | |||
SO71824_10 | BBB4-42D9-86 | PO11455162600 | 100 | 283 | 482 | 72 | 2 | 2024-08-04 | 10.79 | 0.27 | 2024-07-23 | 2 | 3.36 | 1 | 10.79 | 10 | SO71824 | 2024-07-30 | 0.86 | 6.72 | 5.39 | |||
SO57065_39 | B68A-407E-99 | PO11658151711 | 100 | 283 | 595 | 233 | 2 | 2024-01-04 | 1694.97 | 42.37 | 2023-12-23 | 5 | 308.22 | 1 | 1694.97 | 39 | SO57065 | 2023-12-30 | 135.60 | 1541.09 | 338.99 | |||
SO51810_10 | 0D49-491D-BD | PO7453119597 | 100 | 283 | 583 | 108 | 2 | 2023-10-04 | 4082.38 | 102.06 | 2023-09-22 | 4 | 1082.51 | 1 | 4082.38 | 10 | SO51810 | 2023-09-29 | 326.59 | 4330.04 | 1020.59 | |||
SO67314_39 | 6653-491A-80 | PO3828116396 | 100 | 283 | 476 | 414 | 2 | 2024-06-04 | 83.99 | 2.10 | 2024-05-23 | 2 | 26.18 | 1 | 83.99 | 39 | SO67314 | 2024-05-30 | 6.72 | 52.35 | 41.99 | |||
SO51112_19 | 6C36-4086-8D | PO11687117332 | 100 | 283 | 568 | 13 | 691 | 2 | 150.33 | 2023-09-03 | 1002.17 | 21.30 | 2023-08-22 | 3 | 461.44 | 1 | 851.85 | 19 | SO51112 | 2023-08-29 | 68.15 | 1384.33 | 334.06 | 0.15 |
SO49113_7 | 4C8B-47E0-A7 | PO11658167469 | 100 | 283 | 470 | 233 | 2 | 2023-04-06 | 136.76 | 3.42 | 2023-03-25 | 6 | 15.67 | 1 | 136.76 | 7 | SO49113 | 2023-04-01 | 10.94 | 94.03 | 22.79 | |||
SO48021_22 | 7215-4D49-AD | PO11629116216 | 100 | 281 | 367 | 396 | 2 | 2023-01-04 | 1295.99 | 32.40 | 2022-12-23 | 2 | 598.44 | 1 | 1295.99 | 22 | SO48021 | 2022-12-30 | 103.68 | 1196.87 | 647.99 | |||
SO46666_29 | 1A94-4D1F-AF | PO6699130779 | 100 | 281 | 373 | 234 | 2 | 2022-09-03 | 3926.81 | 98.17 | 2022-08-22 | 3 | 1320.68 | 1 | 3926.81 | 29 | SO46666 | 2022-08-29 | 314.15 | 3962.05 | 1308.94 | |||
SO51762_25 | E7DC-4AC1-AD | PO10121132749 | 100 | 283 | 583 | 2 | 684 | 2 | 217.05 | 2023-10-04 | 10852.32 | 265.88 | 2023-09-22 | 11 | 1082.51 | 1 | 10635.27 | 25 | SO51762 | 2023-09-29 | 850.82 | 11907.61 | 986.57 | 0.02 |
SO46620_30 | FEE3-4994-8E | PO13775143788 | 100 | 281 | 343 | 618 | 2 | 2022-09-03 | 1409.38 | 35.23 | 2022-08-22 | 3 | 486.71 | 1 | 1409.38 | 30 | SO46620 | 2022-08-29 | 112.75 | 1460.12 | 469.79 | |||
SO47055_9 | BF62-4954-A7 | PO7453164163 | 100 | 281 | 369 | 108 | 2 | 2022-10-04 | 2932.02 | 73.30 | 2022-09-22 | 2 | 1518.79 | 1 | 2932.02 | 9 | SO47055 | 2022-09-29 | 234.56 | 3037.57 | 1466.01 | |||
SO53570_13 | 412A-483A-A3 | PO9483124574 | 100 | 283 | 287 | 54 | 2 | 2023-11-04 | 809.33 | 20.23 | 2023-10-23 | 4 | 204.63 | 1 | 809.33 | 13 | SO53570 | 2023-10-30 | 64.75 | 818.50 | 202.33 |
Generated 2024-09-21 08:30:43.437 UTC