[ROOT] dt FactResellerSale < WHERE DimSalesTerritoryId EQ '2' > SHUFFLE < SKIP 257 > < 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 |
---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
SO46666_31 | 1A94-4D1F-AF | PO6699130779 | 100 | 281 | 371 | 234 | 2 | 2022-09-02 | 3926.81 | 98.17 | 2022-08-21 | 3 | 1320.68 | 1 | 3926.81 | 31 | SO46666 | 2022-08-28 | 314.15 | 3962.05 | 1308.94 | |||
SO46620_13 | FEE3-4994-8E | PO13775143788 | 100 | 281 | 459 | 618 | 2 | 2022-09-02 | 215.98 | 5.40 | 2022-08-21 | 4 | 37.12 | 1 | 215.98 | 13 | SO46620 | 2022-08-28 | 17.28 | 148.48 | 53.99 | |||
SO71947_1 | 7269-4186-92 | PO9628115897 | 100 | 283 | 552 | 179 | 2 | 2024-08-03 | 109.79 | 2.74 | 2024-07-22 | 2 | 40.62 | 1 | 109.79 | 1 | SO71947 | 2024-07-29 | 8.78 | 81.24 | 54.89 | |||
SO61209_11 | C31E-48AE-AF | PO11484136165 | 100 | 283 | 357 | 594 | 2 | 2024-03-04 | 2783.99 | 69.60 | 2024-02-21 | 2 | 1265.62 | 1 | 2783.99 | 11 | SO61209 | 2024-02-28 | 222.72 | 2531.24 | 1391.99 | |||
SO71778_3 | C735-48DB-B1 | PO19894146890 | 100 | 283 | 554 | 557 | 2 | 2024-08-03 | 54.94 | 1.37 | 2024-07-22 | 1 | 40.66 | 1 | 54.94 | 3 | SO71778 | 2024-07-29 | 4.40 | 40.66 | 54.94 | |||
SO53560_22 | 3D25-4203-A4 | PO7685199983 | 100 | 283 | 572 | 13 | 539 | 2 | 200.43 | 2023-11-03 | 1336.23 | 28.39 | 2023-10-22 | 4 | 461.44 | 1 | 1135.80 | 22 | SO53560 | 2023-10-29 | 90.86 | 1845.78 | 334.06 | 0.15 |
SO45809_6 | D8A0-4462-8A | PO5365154898 | 100 | 281 | 338 | 161 | 2 | 2022-06-03 | 419.46 | 10.49 | 2022-05-22 | 1 | 413.15 | 1 | 419.46 | 6 | SO45809 | 2022-05-29 | 33.56 | 413.15 | 419.46 | |||
SO47025_1 | 9A7F-452C-83 | PO3625180823 | 100 | 281 | 257 | 666 | 2 | 2022-10-03 | 551.81 | 13.80 | 2022-09-21 | 3 | 170.14 | 1 | 551.81 | 1 | SO47025 | 2022-09-28 | 44.15 | 510.43 | 183.94 | |||
SO45297_6 | F91F-4D55-94 | PO14326121383 | 100 | 281 | 328 | 107 | 2 | 2022-04-05 | 838.92 | 20.97 | 2022-03-24 | 2 | 413.15 | 1 | 838.92 | 6 | SO45297 | 2022-03-31 | 67.11 | 826.29 | 419.46 | |||
SO55259_14 | 68EA-4A46-81 | PO11687179986 | 100 | 283 | 567 | 691 | 2 | 2023-12-03 | 445.41 | 11.14 | 2023-11-21 | 1 | 461.44 | 1 | 445.41 | 14 | SO55259 | 2023-11-28 | 35.63 | 461.44 | 445.41 | |||
SO61209_15 | C31E-48AE-AF | PO11484136165 | 100 | 283 | 594 | 594 | 2 | 2024-03-04 | 677.99 | 16.95 | 2024-02-21 | 2 | 308.22 | 1 | 677.99 | 15 | SO61209 | 2024-02-28 | 54.24 | 616.44 | 338.99 | |||
SO51770_2 | 9F77-4259-BE | PO1769187686 | 100 | 283 | 606 | 540 | 2 | 2023-10-03 | 647.99 | 16.20 | 2023-09-21 | 2 | 343.65 | 1 | 647.99 | 2 | SO51770 | 2023-09-28 | 51.84 | 687.30 | 323.99 | |||
SO46994_21 | 5E92-4A19-9E | PO11629171210 | 100 | 281 | 294 | 396 | 2 | 2022-10-03 | 2232.82 | 55.82 | 2022-09-21 | 3 | 660.91 | 1 | 2232.82 | 21 | SO46994 | 2022-09-28 | 178.63 | 1982.74 | 744.27 | |||
SO63200_16 | E73D-4A02-88 | PO11658161535 | 100 | 283 | 488 | 233 | 2 | 2024-04-04 | 64.79 | 1.62 | 2024-03-23 | 2 | 41.57 | 1 | 64.79 | 16 | SO63200 | 2024-03-30 | 5.18 | 83.14 | 32.39 | |||
SO71949_14 | D52C-4E65-AA | PO9483195097 | 100 | 283 | 408 | 54 | 2 | 2024-08-03 | 72.16 | 1.80 | 2024-07-22 | 1 | 53.40 | 1 | 72.16 | 14 | SO71949 | 2024-07-29 | 5.77 | 53.40 | 72.16 | |||
SO46036_20 | DBE7-4B0A-93 | PO18386134137 | 100 | 281 | 330 | 558 | 2 | 2022-07-03 | 419.46 | 10.49 | 2022-06-21 | 1 | 413.15 | 1 | 419.46 | 20 | SO46036 | 2022-06-28 | 33.56 | 413.15 | 419.46 | |||
SO51741_6 | 96BB-4004-AE | PO12383191952 | 100 | 283 | 547 | 89 | 2 | 2023-10-03 | 194.38 | 4.86 | 2023-09-21 | 4 | 35.96 | 1 | 194.38 | 6 | SO51741 | 2023-09-28 | 15.55 | 143.84 | 48.59 | |||
SO57063_3 | 41AF-4539-AE | PO11629118689 | 100 | 283 | 594 | 396 | 2 | 2024-01-03 | 338.99 | 8.47 | 2023-12-22 | 1 | 308.22 | 1 | 338.99 | 3 | SO57063 | 2023-12-29 | 27.12 | 308.22 | 338.99 | |||
SO51810_20 | 0D49-491D-BD | PO7453119597 | 100 | 283 | 231 | 108 | 2 | 2023-10-03 | 209.96 | 5.25 | 2023-09-21 | 7 | 38.49 | 1 | 209.96 | 20 | SO51810 | 2023-09-28 | 16.80 | 269.45 | 29.99 | |||
SO69442_9 | 9833-459C-A2 | PO11658194725 | 100 | 283 | 471 | 3 | 233 | 2 | 29.69 | 2024-07-03 | 593.73 | 14.10 | 2024-06-21 | 17 | 23.75 | 1 | 564.04 | 9 | SO69442 | 2024-06-28 | 45.12 | 403.73 | 34.93 | 0.05 |
SO47055_37 | BF62-4954-A7 | PO7453164163 | 100 | 281 | 435 | 108 | 2 | 2022-10-03 | 973.36 | 24.33 | 2022-09-21 | 3 | 300.12 | 1 | 973.36 | 37 | SO47055 | 2022-09-28 | 77.87 | 900.36 | 324.45 | |||
SO57076_15 | 4D9A-45E4-88 | PO10121190262 | 100 | 283 | 376 | 684 | 2 | 2024-01-03 | 1466.01 | 36.65 | 2023-12-22 | 1 | 1554.95 | 1 | 1466.01 | 15 | SO57076 | 2023-12-29 | 117.28 | 1554.95 | 1466.01 | |||
SO48076_4 | C38A-4C0F-BD | PO7424167037 | 100 | 281 | 358 | 642 | 2 | 2023-01-03 | 9835.67 | 245.89 | 2022-12-22 | 8 | 1105.81 | 1 | 9835.67 | 4 | SO48076 | 2022-12-29 | 786.85 | 8846.48 | 1229.46 | |||
SO51790_1 | E757-43BD-B1 | PO18183195762 | 100 | 283 | 309 | 667 | 2 | 2023-10-03 | 2456.10 | 61.40 | 2023-09-21 | 3 | 747.20 | 1 | 2456.10 | 1 | SO51790 | 2023-09-28 | 196.49 | 2241.60 | 818.70 | |||
SO51101_34 | 5853-46B4-AC | PO13775166153 | 100 | 283 | 604 | 618 | 2 | 2023-09-02 | 323.99 | 8.10 | 2023-08-21 | 1 | 343.65 | 1 | 323.99 | 34 | SO51101 | 2023-08-28 | 25.92 | 343.65 | 323.99 | |||
SO69493_4 | FA5D-44EF-A7 | PO12383119310 | 100 | 283 | 225 | 89 | 2 | 2024-07-03 | 5.39 | 0.13 | 2024-06-21 | 1 | 6.92 | 1 | 5.39 | 4 | SO69493 | 2024-06-28 | 0.43 | 6.92 | 5.39 | |||
SO67271_2 | E734-4CEC-A8 | PO13775181029 | 100 | 283 | 546 | 618 | 2 | 2024-06-03 | 74.51 | 1.86 | 2024-05-22 | 2 | 27.57 | 1 | 74.51 | 2 | SO67271 | 2024-05-29 | 5.96 | 55.14 | 37.25 | |||
SO51088_35 | 4E58-4FFA-9F | PO17197140322 | 100 | 283 | 595 | 125 | 2 | 2023-09-02 | 1694.97 | 42.37 | 2023-08-21 | 5 | 308.22 | 1 | 1694.97 | 35 | SO51088 | 2023-08-28 | 135.60 | 1541.09 | 338.99 |
Generated 2024-09-20 10:48:02.255 UTC