[ROOT] dt FactResellerSale < WHERE DimSalesTerritoryId EQ '2' > SHUFFLE < SKIP 855 > < TAKE 28 >
28 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 |
---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
SO43688_9 | 16F4-456B-9A | PO5365136389 | 100 | 281 | 332 | 161 | 2 | 2021-10-26 | 1258.38 | 31.46 | 2021-10-14 | 3 | 413.15 | 1 | 1258.38 | 9 | SO43688 | 2021-10-21 | 100.67 | 1239.44 | 419.46 | |||
SO49156_2 | EB2D-4339-B0 | PO6670170231 | 100 | 283 | 417 | 432 | 2 | 2023-05-29 | 324.45 | 8.11 | 2023-05-17 | 1 | 300.12 | 1 | 324.45 | 2 | SO49156 | 2023-05-24 | 25.96 | 300.12 | 324.45 | |||
SO51112_27 | 6C36-4086-8D | PO11687117332 | 100 | 283 | 569 | 13 | 691 | 2 | 150.33 | 2023-10-26 | 1002.17 | 21.30 | 2023-10-14 | 3 | 461.44 | 1 | 851.85 | 27 | SO51112 | 2023-10-21 | 68.15 | 1384.33 | 334.06 | 0.15 |
SO57125_7 | 2D2B-4159-87 | PO7453119638 | 100 | 283 | 581 | 108 | 2 | 2024-02-26 | 4082.38 | 102.06 | 2024-02-14 | 4 | 1082.51 | 1 | 4082.38 | 7 | SO57125 | 2024-02-21 | 326.59 | 4330.04 | 1020.59 | |||
SO51101_5 | 5853-46B4-AC | PO13775166153 | 100 | 283 | 380 | 618 | 2 | 2023-10-26 | 1466.01 | 36.65 | 2023-10-14 | 1 | 1554.95 | 1 | 1466.01 | 5 | SO51101 | 2023-10-21 | 117.28 | 1554.95 | 1466.01 | |||
SO44502_3 | 5EC5-4410-9C | PO16791147707 | 100 | 281 | 315 | 36 | 2 | 2022-02-26 | 1749.59 | 43.74 | 2022-02-14 | 2 | 884.71 | 1 | 1749.59 | 3 | SO44502 | 2022-02-21 | 139.97 | 1769.42 | 874.79 | |||
SO48392_15 | B9C7-4F4D-82 | PO9483147187 | 100 | 281 | 435 | 54 | 2 | 2023-03-28 | 324.45 | 8.11 | 2023-03-16 | 1 | 300.12 | 1 | 324.45 | 15 | SO48392 | 2023-03-23 | 25.96 | 300.12 | 324.45 | |||
SO46385_16 | F727-48F0-AF | PO9483110086 | 100 | 281 | 319 | 54 | 2 | 2022-09-26 | 2624.38 | 65.61 | 2022-09-14 | 3 | 884.71 | 1 | 2624.38 | 16 | SO46385 | 2022-09-21 | 209.95 | 2654.12 | 874.79 | |||
SO63279_15 | 6869-4687-B7 | PO3625136290 | 100 | 283 | 287 | 666 | 2 | 2024-05-28 | 1416.32 | 35.41 | 2024-05-16 | 7 | 204.63 | 1 | 1416.32 | 15 | SO63279 | 2024-05-23 | 113.31 | 1432.38 | 202.33 | |||
SO49479_41 | 12BA-4BD1-BB | PO11455112131 | 100 | 283 | 369 | 72 | 2 | 2023-06-26 | 8796.06 | 219.90 | 2023-06-14 | 6 | 1518.79 | 1 | 8796.06 | 41 | SO49479 | 2023-06-21 | 703.68 | 9112.72 | 1466.01 | |||
SO48788_22 | DD66-4EC8-BF | PO6699145127 | 100 | 283 | 335 | 234 | 2 | 2023-04-28 | 1409.38 | 35.23 | 2023-04-16 | 3 | 486.71 | 1 | 1409.38 | 22 | SO48788 | 2023-04-23 | 112.75 | 1460.12 | 469.79 | |||
SO69442_41 | 9833-459C-A2 | PO11658194725 | 100 | 283 | 298 | 233 | 2 | 2024-08-26 | 809.76 | 20.24 | 2024-08-14 | 1 | 739.04 | 1 | 809.76 | 41 | SO69442 | 2024-08-21 | 64.78 | 739.04 | 809.76 | |||
SO55301_40 | C4D6-4789-A9 | PO3828165579 | 100 | 283 | 467 | 414 | 2 | 2024-01-26 | 58.78 | 1.47 | 2024-01-14 | 4 | 9.16 | 1 | 58.78 | 40 | SO55301 | 2024-01-21 | 4.70 | 36.64 | 14.69 | |||
SO46027_2 | 13E3-4227-BD | PO19256159915 | 100 | 281 | 315 | 162 | 2 | 2022-08-26 | 874.79 | 21.87 | 2022-08-14 | 1 | 884.71 | 1 | 874.79 | 2 | SO46027 | 2022-08-21 | 69.98 | 884.71 | 874.79 | |||
SO43907_20 | 9CB1-46F4-8A | PO6641115253 | 100 | 281 | 316 | 342 | 2 | 2021-11-26 | 874.79 | 21.87 | 2021-11-14 | 1 | 884.71 | 1 | 874.79 | 20 | SO43907 | 2021-11-21 | 69.98 | 884.71 | 874.79 | |||
SO59074_37 | 1711-471C-82 | PO9483120932 | 100 | 283 | 580 | 54 | 2 | 2024-03-27 | 6123.56 | 153.09 | 2024-03-15 | 6 | 1082.51 | 1 | 6123.56 | 37 | SO59074 | 2024-03-22 | 489.89 | 6495.06 | 1020.59 | |||
SO47421_6 | ECD3-4E13-8E | PO3190135008 | 100 | 281 | 441 | 575 | 2 | 2022-12-27 | 780.82 | 19.52 | 2022-12-15 | 1 | 722.26 | 1 | 780.82 | 6 | SO47421 | 2022-12-22 | 62.47 | 722.26 | 780.82 | |||
SO65152_5 | 9C5B-4E79-98 | PO20213135029 | 100 | 283 | 583 | 216 | 2 | 2024-06-26 | 2041.19 | 51.03 | 2024-06-14 | 2 | 1082.51 | 1 | 2041.19 | 5 | SO65152 | 2024-06-21 | 163.30 | 2165.02 | 1020.59 | |||
SO48021_7 | 7215-4D49-AD | PO11629116216 | 100 | 281 | 421 | 396 | 2 | 2023-02-26 | 1177.97 | 29.45 | 2023-02-14 | 6 | 145.28 | 1 | 1177.97 | 7 | SO48021 | 2023-02-21 | 94.24 | 871.70 | 196.33 | |||
SO50235_23 | 20B9-4308-A5 | PO10121141993 | 100 | 283 | 333 | 684 | 2 | 2023-08-26 | 3758.35 | 93.96 | 2023-08-14 | 8 | 486.71 | 1 | 3758.35 | 23 | SO50235 | 2023-08-21 | 300.67 | 3893.65 | 469.79 | |||
SO47706_1 | D1C6-4062-AA | PO3828168588 | 100 | 281 | 409 | 414 | 2 | 2023-01-26 | 418.51 | 10.46 | 2023-01-14 | 2 | 185.82 | 1 | 418.51 | 1 | SO47706 | 2023-01-21 | 33.48 | 371.64 | 209.26 | |||
SO47685_9 | CC2F-4D47-8C | PO11484129630 | 100 | 281 | 367 | 594 | 2 | 2023-01-26 | 3239.97 | 81.00 | 2023-01-14 | 5 | 598.44 | 1 | 3239.97 | 9 | SO47685 | 2023-01-21 | 259.20 | 2992.18 | 647.99 | |||
SO45297_5 | F91F-4D55-94 | PO14326121383 | 100 | 281 | 326 | 107 | 2 | 2022-05-29 | 419.46 | 10.49 | 2022-05-17 | 1 | 413.15 | 1 | 419.46 | 5 | SO45297 | 2022-05-24 | 33.56 | 413.15 | 419.46 | |||
SO46666_3 | 1A94-4D1F-AF | PO6699130779 | 100 | 281 | 331 | 234 | 2 | 2022-10-26 | 3288.56 | 82.21 | 2022-10-14 | 7 | 486.71 | 1 | 3288.56 | 3 | SO46666 | 2022-10-21 | 263.08 | 3406.95 | 469.79 | |||
SO49169_7 | 73B1-4F93-B6 | PO10121138908 | 100 | 283 | 383 | 684 | 2 | 2023-05-29 | 600.26 | 15.01 | 2023-05-17 | 1 | 605.65 | 1 | 600.26 | 7 | SO49169 | 2023-05-24 | 48.02 | 605.65 | 600.26 | |||
SO46043_16 | 1230-4EA4-83 | PO16791123625 | 100 | 281 | 334 | 36 | 2 | 2022-08-26 | 1677.84 | 41.95 | 2022-08-14 | 4 | 413.15 | 1 | 1677.84 | 16 | SO46043 | 2022-08-21 | 134.23 | 1652.59 | 419.46 | |||
SO50683_23 | 8EBE-4D2C-AB | PO11455112273 | 100 | 283 | 368 | 72 | 2 | 2023-09-26 | 5864.04 | 146.60 | 2023-09-14 | 4 | 1518.79 | 1 | 5864.04 | 23 | SO50683 | 2023-09-21 | 469.12 | 6075.15 | 1466.01 | |||
SO44800_3 | 3119-4CF3-BF | PO9019144492 | 100 | 281 | 229 | 576 | 2 | 2022-03-28 | 28.84 | 0.72 | 2022-03-16 | 1 | 31.72 | 1 | 28.84 | 3 | SO44800 | 2022-03-23 | 2.31 | 31.72 | 28.84 |
Generated 2024-11-13 07:31:51.504 UTC