[ROOT] dt FactResellerSale < WHERE DimSalesTerritoryId EQ '2' > SHUFFLE < SKIP 1537 > < 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 |
---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
SO47706_6 | D1C6-4062-AA | PO3828168588 | 100 | 281 | 427 | 414 | 2 | 2023-01-27 | 837.02 | 20.93 | 2023-01-15 | 4 | 185.82 | 1 | 837.02 | 6 | SO47706 | 2023-01-22 | 66.96 | 743.28 | 209.26 | |||
SO48076_22 | C38A-4C0F-BD | PO7424167037 | 100 | 281 | 420 | 642 | 2 | 2023-02-27 | 708.08 | 17.70 | 2023-02-15 | 5 | 104.80 | 1 | 708.08 | 22 | SO48076 | 2023-02-22 | 56.65 | 523.98 | 141.62 | |||
SO46986_5 | A56F-42B9-BB | PO12383199580 | 100 | 281 | 286 | 89 | 2 | 2022-11-27 | 735.75 | 18.39 | 2022-11-15 | 4 | 170.14 | 1 | 735.75 | 5 | SO46986 | 2022-11-22 | 58.86 | 680.57 | 183.94 | |||
SO53560_50 | 3D25-4203-A4 | PO7685199983 | 100 | 283 | 496 | 539 | 2 | 2023-12-28 | 1807.04 | 45.18 | 2023-12-16 | 3 | 601.74 | 1 | 1807.04 | 50 | SO53560 | 2023-12-23 | 144.56 | 1805.23 | 602.35 | |||
SO44313_14 | 6613-4427-84 | PO5365138960 | 100 | 281 | 272 | 161 | 2 | 2022-01-27 | 367.88 | 9.20 | 2022-01-15 | 2 | 181.49 | 1 | 367.88 | 14 | SO44313 | 2022-01-22 | 29.43 | 362.97 | 183.94 | |||
SO55301_6 | C4D6-4789-A9 | PO3828165579 | 100 | 283 | 512 | 414 | 2 | 2024-01-27 | 218.45 | 5.46 | 2024-01-15 | 1 | 199.38 | 1 | 218.45 | 6 | SO55301 | 2024-01-22 | 17.48 | 199.38 | 218.45 | |||
SO53567_8 | 2385-4ADE-B6 | PO9628113784 | 100 | 283 | 575 | 179 | 2 | 2023-12-28 | 2860.88 | 71.52 | 2023-12-16 | 2 | 1481.94 | 1 | 2860.88 | 8 | SO53567 | 2023-12-23 | 228.87 | 2963.88 | 1430.44 | |||
SO55261_24 | 130D-46E9-9B | PO11484193890 | 100 | 283 | 527 | 594 | 2 | 2024-01-27 | 475.29 | 11.88 | 2024-01-15 | 3 | 144.59 | 1 | 475.29 | 24 | SO55261 | 2024-01-22 | 38.02 | 433.78 | 158.43 | |||
SO65245_18 | 80F6-437F-84 | PO9628129233 | 100 | 283 | 561 | 179 | 2 | 2024-06-27 | 1430.44 | 35.76 | 2024-06-15 | 1 | 1481.94 | 1 | 1430.44 | 18 | SO65245 | 2024-06-22 | 114.44 | 1481.94 | 1430.44 | |||
SO47706_2 | D1C6-4062-AA | PO3828168588 | 100 | 281 | 428 | 414 | 2 | 2023-01-27 | 1255.54 | 31.39 | 2023-01-15 | 6 | 185.82 | 1 | 1255.54 | 2 | SO47706 | 2023-01-22 | 100.44 | 1114.92 | 209.26 | |||
SO57087_13 | 423C-428C-BB | PO2871167176 | 100 | 283 | 576 | 522 | 2 | 2024-02-27 | 2860.88 | 71.52 | 2024-02-15 | 2 | 1481.94 | 1 | 2860.88 | 13 | SO57087 | 2024-02-22 | 228.87 | 2963.88 | 1430.44 | |||
SO49479_1 | 12BA-4BD1-BB | PO11455112131 | 100 | 283 | 375 | 72 | 2 | 2023-06-27 | 11780.44 | 294.51 | 2023-06-15 | 9 | 1320.68 | 1 | 11780.44 | 1 | SO49479 | 2023-06-22 | 942.44 | 11886.15 | 1308.94 | |||
SO48377_1 | 1A8D-4732-94 | PO6090160190 | 100 | 281 | 341 | 690 | 2 | 2023-03-29 | 1409.38 | 35.23 | 2023-03-17 | 3 | 486.71 | 1 | 1409.38 | 1 | SO48377 | 2023-03-24 | 112.75 | 1460.12 | 469.79 | |||
SO47050_5 | 8424-417D-8D | PO6670168837 | 100 | 281 | 337 | 432 | 2 | 2022-11-27 | 1409.38 | 35.23 | 2022-11-15 | 3 | 486.71 | 1 | 1409.38 | 5 | SO47050 | 2022-11-22 | 112.75 | 1460.12 | 469.79 | |||
SO47664_11 | 4F8A-4646-B5 | PO17197195500 | 100 | 281 | 419 | 125 | 2 | 2023-01-27 | 105.29 | 2.63 | 2023-01-15 | 2 | 38.96 | 1 | 105.29 | 11 | SO47664 | 2023-01-22 | 8.42 | 77.92 | 52.65 | |||
SO51101_8 | 5853-46B4-AC | PO13775166153 | 100 | 283 | 408 | 618 | 2 | 2023-10-27 | 360.81 | 9.02 | 2023-10-15 | 5 | 53.40 | 1 | 360.81 | 8 | SO51101 | 2023-10-22 | 28.86 | 267.00 | 72.16 | |||
SO48021_2 | 7215-4D49-AD | PO11629116216 | 100 | 281 | 409 | 396 | 2 | 2023-02-27 | 209.26 | 5.23 | 2023-02-15 | 1 | 185.82 | 1 | 209.26 | 2 | SO48021 | 2023-02-22 | 16.74 | 185.82 | 209.26 | |||
SO50683_27 | 8EBE-4D2C-AB | PO11455112273 | 100 | 283 | 335 | 72 | 2 | 2023-09-27 | 2348.97 | 58.72 | 2023-09-15 | 5 | 486.71 | 1 | 2348.97 | 27 | SO50683 | 2023-09-22 | 187.92 | 2433.53 | 469.79 | |||
SO48336_28 | 48F2-4141-9A | PO11455111823 | 100 | 281 | 239 | 72 | 2 | 2023-03-29 | 2342.45 | 58.56 | 2023-03-17 | 3 | 722.26 | 1 | 2342.45 | 28 | SO48336 | 2023-03-24 | 187.40 | 2166.77 | 780.82 | |||
SO48392_35 | B9C7-4F4D-82 | PO9483147187 | 100 | 281 | 263 | 54 | 2 | 2023-03-29 | 404.66 | 10.12 | 2023-03-17 | 2 | 187.16 | 1 | 404.66 | 35 | SO48392 | 2023-03-24 | 32.37 | 374.31 | 202.33 | |||
SO50311_15 | E09E-4D02-9F | PO7453115958 | 100 | 283 | 216 | 108 | 2 | 2023-08-27 | 161.49 | 4.04 | 2023-08-15 | 8 | 13.88 | 1 | 161.49 | 15 | SO50311 | 2023-08-22 | 12.92 | 111.03 | 20.19 | |||
SO46610_13 | B7D1-4895-B6 | PO17197125590 | 100 | 281 | 411 | 125 | 2 | 2022-10-27 | 501.66 | 12.54 | 2022-10-15 | 4 | 92.81 | 1 | 501.66 | 13 | SO46610 | 2022-10-22 | 40.13 | 371.23 | 125.42 | |||
SO55301_29 | C4D6-4789-A9 | PO3828165579 | 100 | 283 | 465 | 414 | 2 | 2024-01-27 | 132.25 | 3.31 | 2024-01-15 | 9 | 9.16 | 1 | 132.25 | 29 | SO55301 | 2024-01-22 | 10.58 | 82.43 | 14.69 | |||
SO50311_2 | E09E-4D02-9F | PO7453115958 | 100 | 283 | 327 | 2 | 108 | 2 | 118.07 | 2023-08-27 | 5903.74 | 144.64 | 2023-08-15 | 13 | 486.71 | 1 | 5785.67 | 2 | SO50311 | 2023-08-22 | 462.85 | 6327.19 | 454.13 | 0.02 |
SO53570_49 | 412A-483A-A3 | PO9483124574 | 100 | 283 | 231 | 54 | 2 | 2023-12-28 | 299.94 | 7.50 | 2023-12-16 | 10 | 38.49 | 1 | 299.94 | 49 | SO53570 | 2023-12-23 | 24.00 | 384.92 | 29.99 | |||
SO48751_19 | 1B86-4985-89 | PO13775132235 | 100 | 283 | 216 | 618 | 2 | 2023-04-29 | 40.37 | 1.01 | 2023-04-17 | 2 | 13.88 | 1 | 40.37 | 19 | SO48751 | 2023-04-24 | 3.23 | 27.76 | 20.19 | |||
SO46994_30 | 5E92-4A19-9E | PO11629171210 | 100 | 281 | 421 | 396 | 2 | 2022-11-27 | 785.32 | 19.63 | 2022-11-15 | 4 | 145.28 | 1 | 785.32 | 30 | SO46994 | 2022-11-22 | 62.83 | 581.13 | 196.33 | |||
SO51762_10 | E7DC-4AC1-AD | PO10121132749 | 100 | 283 | 546 | 684 | 2 | 2023-11-27 | 74.51 | 1.86 | 2023-11-15 | 2 | 27.57 | 1 | 74.51 | 10 | SO51762 | 2023-11-22 | 5.96 | 55.14 | 37.25 |
Generated 2024-11-14 07:09:58.874 UTC