[ROOT] dt FactResellerSale < WHERE DimSalesTerritoryId EQ '4' > SHUFFLE SKIP 2000 < SKIP 720 > < 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 |
---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
SO46364_14 | BC3C-4FE8-AC | PO3248115921 | 100 | 282 | 346 | 7 | 366 | 4 | 892.50 | 2022-08-03 | 2549.99 | 41.44 | 2022-07-22 | 3 | 1912.15 | 1 | 1657.50 | 14 | SO46364 | 2022-07-29 | 132.60 | 5736.46 | 850.00 | 0.35 |
SO47056_11 | 53BF-4950-9E | PO7656118289 | 100 | 282 | 464 | 403 | 4 | 2022-10-03 | 42.39 | 1.06 | 2022-09-21 | 3 | 9.71 | 1 | 42.39 | 11 | SO47056 | 2022-09-28 | 3.39 | 29.14 | 14.13 | |||
SO45059_7 | C618-4998-BE | PO10730115502 | 100 | 287 | 316 | 491 | 4 | 2022-03-05 | 1749.59 | 43.74 | 2022-02-21 | 2 | 884.71 | 1 | 1749.59 | 7 | SO45059 | 2022-02-28 | 139.97 | 1769.42 | 874.79 | |||
SO47692_6 | F786-4312-9B | PO10237186654 | 100 | 287 | 323 | 41 | 4 | 2022-12-03 | 469.79 | 11.74 | 2022-11-21 | 1 | 486.71 | 1 | 469.79 | 6 | SO47692 | 2022-11-28 | 37.58 | 486.71 | 469.79 | |||
SO71845_24 | 4781-4673-85 | PO2697119362 | 100 | 282 | 516 | 187 | 4 | 2024-08-03 | 187.87 | 4.70 | 2024-07-22 | 8 | 17.38 | 1 | 187.87 | 24 | SO71845 | 2024-07-29 | 15.03 | 139.03 | 23.48 | |||
SO59068_8 | B7CC-4A9D-86 | PO9715112509 | 100 | 281 | 551 | 490 | 4 | 2024-02-02 | 475.29 | 11.88 | 2024-01-21 | 3 | 144.59 | 1 | 475.29 | 8 | SO59068 | 2024-01-28 | 38.02 | 433.78 | 158.43 | |||
SO71952_14 | 9490-4552-81 | PO9715163911 | 100 | 281 | 555 | 490 | 4 | 2024-08-03 | 255.60 | 6.39 | 2024-07-22 | 4 | 47.29 | 1 | 255.60 | 14 | SO71952 | 2024-07-29 | 20.45 | 189.14 | 63.90 | |||
SO51745_14 | C261-441D-A5 | PO11745132954 | 100 | 282 | 604 | 97 | 4 | 2023-10-03 | 647.99 | 16.20 | 2023-09-21 | 2 | 343.65 | 1 | 647.99 | 14 | SO51745 | 2023-09-28 | 51.84 | 687.30 | 323.99 | |||
SO50252_23 | B5DA-491E-A9 | PO2523194031 | 100 | 287 | 375 | 167 | 4 | 2023-07-03 | 5235.75 | 130.89 | 2023-06-21 | 4 | 1320.68 | 1 | 5235.75 | 23 | SO50252 | 2023-06-28 | 418.86 | 5282.74 | 1308.94 | |||
SO48048_13 | B414-46CB-BA | PO3480117933 | 100 | 283 | 373 | 436 | 4 | 2023-01-03 | 2617.88 | 65.45 | 2022-12-22 | 2 | 1320.68 | 1 | 2617.88 | 13 | SO48048 | 2022-12-29 | 209.43 | 2641.37 | 1308.94 | |||
SO51795_23 | 30DF-4333-9E | PO15921146523 | 100 | 287 | 472 | 77 | 4 | 2023-10-03 | 76.20 | 1.91 | 2023-09-21 | 2 | 23.75 | 1 | 76.20 | 23 | SO51795 | 2023-09-28 | 6.10 | 47.50 | 38.10 | |||
SO71787_4 | 94A7-4406-B3 | PO18038111279 | 100 | 287 | 585 | 509 | 4 | 2024-08-03 | 445.41 | 11.14 | 2024-07-22 | 1 | 461.44 | 1 | 445.41 | 4 | SO71787 | 2024-07-29 | 35.63 | 461.44 | 445.41 | |||
SO50702_6 | 6D0A-413E-BE | PO2697119650 | 100 | 282 | 470 | 187 | 4 | 2023-08-03 | 182.35 | 4.56 | 2023-07-22 | 8 | 15.67 | 1 | 182.35 | 6 | SO50702 | 2023-07-29 | 14.59 | 125.37 | 22.79 | |||
SO65315_20 | 0FFB-4EB5-A3 | PO6757194680 | 100 | 281 | 398 | 21 | 4 | 2024-05-03 | 106.90 | 2.67 | 2024-04-21 | 4 | 19.78 | 1 | 106.90 | 20 | SO65315 | 2024-04-28 | 8.55 | 79.10 | 26.72 | |||
SO46988_38 | 2D2E-4EC3-AC | PO12499171502 | 100 | 282 | 383 | 78 | 4 | 2022-10-03 | 1200.53 | 30.01 | 2022-09-21 | 2 | 605.65 | 1 | 1200.53 | 38 | SO46988 | 2022-09-28 | 96.04 | 1211.30 | 600.26 | |||
SO61200_6 | 9B44-40EF-86 | PO2755113256 | 100 | 272 | 586 | 205 | 4 | 2024-03-04 | 890.82 | 22.27 | 2024-02-21 | 2 | 461.44 | 1 | 890.82 | 6 | SO61200 | 2024-02-28 | 71.27 | 922.89 | 445.41 | |||
SO47676_13 | 5DD7-4A1E-9B | PO13659142296 | 100 | 272 | 365 | 437 | 4 | 2022-12-03 | 3887.96 | 97.20 | 2022-11-21 | 6 | 598.44 | 1 | 3887.96 | 13 | SO47676 | 2022-11-28 | 311.04 | 3590.61 | 647.99 | |||
SO48345_3 | 1E07-4139-96 | PO261145056 | 100 | 283 | 280 | 647 | 4 | 2023-02-02 | 183.94 | 4.60 | 2023-01-21 | 1 | 170.14 | 1 | 183.94 | 3 | SO48345 | 2023-01-28 | 14.72 | 170.14 | 183.94 | |||
SO47034_35 | A5AA-46C3-92 | PO4843149248 | 100 | 287 | 439 | 257 | 4 | 2022-10-03 | 2342.45 | 58.56 | 2022-09-21 | 3 | 722.26 | 1 | 2342.45 | 35 | SO47034 | 2022-09-28 | 187.40 | 2166.77 | 780.82 | |||
SO48043_25 | BA6F-4F1F-B7 | PO2523167437 | 100 | 287 | 375 | 167 | 4 | 2023-01-03 | 3926.81 | 98.17 | 2022-12-22 | 3 | 1320.68 | 1 | 3926.81 | 25 | SO48043 | 2022-12-29 | 314.15 | 3962.05 | 1308.94 | |||
SO49058_3 | BD1B-4C7F-A9 | PO12499147561 | 100 | 282 | 453 | 78 | 4 | 2023-04-05 | 215.96 | 5.40 | 2023-03-24 | 6 | 24.75 | 1 | 215.96 | 3 | SO49058 | 2023-03-31 | 17.28 | 148.48 | 35.99 | |||
SO46377_5 | A45C-4A20-BA | PO6786151653 | 100 | 283 | 262 | 3 | 4 | 2022-08-03 | 367.88 | 9.20 | 2022-07-22 | 2 | 181.49 | 1 | 367.88 | 5 | SO46377 | 2022-07-29 | 29.43 | 362.97 | 183.94 | |||
SO57137_47 | 9401-4518-A4 | PO6438194874 | 100 | 281 | 217 | 309 | 4 | 2024-01-03 | 41.99 | 1.05 | 2023-12-22 | 2 | 13.09 | 1 | 41.99 | 47 | SO57137 | 2023-12-29 | 3.36 | 26.17 | 20.99 | |||
SO48048_38 | B414-46CB-BA | PO3480117933 | 100 | 283 | 263 | 436 | 4 | 2023-01-03 | 809.33 | 20.23 | 2022-12-22 | 4 | 187.16 | 1 | 809.33 | 38 | SO48048 | 2022-12-29 | 64.75 | 748.63 | 202.33 | |||
SO47994_22 | 284B-45A1-94 | PO15196121630 | 100 | 282 | 375 | 258 | 4 | 2023-01-03 | 3926.81 | 98.17 | 2022-12-22 | 3 | 1320.68 | 1 | 3926.81 | 22 | SO47994 | 2022-12-29 | 314.15 | 3962.05 | 1308.94 | |||
SO49127_9 | 01A1-43AB-A2 | PO3480145572 | 100 | 272 | 341 | 436 | 4 | 2023-04-05 | 3758.35 | 93.96 | 2023-03-24 | 8 | 486.71 | 1 | 3758.35 | 9 | SO49127 | 2023-03-31 | 300.67 | 3893.65 | 469.79 | |||
SO46364_20 | BC3C-4FE8-AC | PO3248115921 | 100 | 282 | 345 | 7 | 366 | 4 | 1784.99 | 2022-08-03 | 5099.99 | 82.87 | 2022-07-22 | 6 | 1912.15 | 1 | 3314.99 | 20 | SO46364 | 2022-07-29 | 265.20 | 11472.93 | 850.00 | 0.35 |
SO67273_56 | 9BAE-4E69-B9 | PO13688176638 | 100 | 282 | 484 | 2 | 475 | 4 | 1.29 | 2024-06-03 | 64.55 | 1.58 | 2024-05-22 | 14 | 2.97 | 1 | 63.26 | 56 | SO67273 | 2024-05-29 | 5.06 | 41.63 | 4.61 | 0.02 |
SO46660_15 | CF24-45E2-9D | PO5626129733 | 100 | 283 | 424 | 166 | 4 | 2022-09-02 | 642.71 | 16.07 | 2022-08-21 | 3 | 158.53 | 1 | 642.71 | 15 | SO46660 | 2022-08-28 | 51.42 | 475.60 | 214.24 | |||
SO46093_14 | B221-4D2A-99 | PO6351171482 | 100 | 283 | 311 | 255 | 4 | 2022-07-03 | 6440.89 | 161.02 | 2022-06-21 | 3 | 2171.29 | 1 | 6440.89 | 14 | SO46093 | 2022-06-28 | 515.27 | 6513.88 | 2146.96 | |||
SO47700_12 | 5C46-42DE-AD | PO2494132198 | 100 | 283 | 360 | 184 | 4 | 2022-12-03 | 4917.84 | 122.95 | 2022-11-21 | 4 | 1105.81 | 1 | 4917.84 | 12 | SO47700 | 2022-11-28 | 393.43 | 4423.24 | 1229.46 |
Generated 2024-09-20 17:43:26.408 UTC