[ROOT] dt FactResellerSale < WHERE DimSalesTerritoryId EQ ALL SKIP 3000 SHUFFLE < SKIP 1125 > < 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 |
---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
SO48022_1 | 9AB0-4BC5-B5 | PO10991115418 | 19 | 284 | 468 | 570 | 6 | 2023-01-03 | 22.79 | 0.57 | 2022-12-22 | 1 | 15.67 | 1 | 22.79 | 1 | SO48022 | 2022-12-29 | 1.82 | 15.67 | 22.79 | |||
SO67295_24 | D785-46A0-BC | PO1711155302 | 19 | 291 | 544 | 2 | 245 | 6 | 11.27 | 2024-06-03 | 563.69 | 13.81 | 2024-05-22 | 12 | 35.96 | 1 | 552.42 | 24 | SO67295 | 2024-05-29 | 44.19 | 431.52 | 46.97 | 0.02 |
SO46660_37 | CF24-45E2-9D | PO5626129733 | 100 | 283 | 271 | 166 | 4 | 2022-09-02 | 2023.32 | 50.58 | 2022-08-21 | 10 | 187.16 | 1 | 2023.32 | 37 | SO46660 | 2022-08-28 | 161.87 | 1871.57 | 202.33 | |||
SO71822_41 | AEDC-410A-9B | PO11774139099 | 6 | 296 | 472 | 682 | 9 | 2024-08-03 | 152.40 | 3.81 | 2024-07-22 | 4 | 23.75 | 1 | 152.40 | 41 | SO71822 | 2024-07-29 | 12.19 | 95.00 | 38.10 | |||
SO45536_16 | 260C-4755-B2 | PO15167166424 | 100 | 283 | 223 | 273 | 4 | 2022-05-03 | 5.19 | 0.13 | 2022-04-21 | 1 | 5.71 | 1 | 5.19 | 16 | SO45536 | 2022-04-28 | 0.41 | 5.71 | 5.19 | |||
SO57150_4 | 0163-41B3-92 | PO3683172338 | 100 | 292 | 573 | 85 | 7 | 2024-01-03 | 5721.77 | 143.04 | 2023-12-22 | 4 | 1481.94 | 1 | 5721.77 | 4 | SO57150 | 2023-12-29 | 457.74 | 5927.75 | 1430.44 | |||
SO51719_5 | ED05-475E-90 | PO15225174834 | 100 | 283 | 494 | 360 | 3 | 2023-10-03 | 602.35 | 15.06 | 2023-09-21 | 1 | 601.74 | 1 | 602.35 | 5 | SO51719 | 2023-09-28 | 48.19 | 601.74 | 602.35 | |||
SO44789_1 | D918-4308-9F | PO6322139904 | 100 | 281 | 275 | 503 | 2 | 2022-02-02 | 356.90 | 8.92 | 2022-01-21 | 1 | 352.14 | 1 | 356.90 | 1 | SO44789 | 2022-01-28 | 28.55 | 352.14 | 356.90 | |||
SO44481_6 | 379F-474E-B8 | PO609189211 | 100 | 282 | 223 | 492 | 4 | 2022-01-03 | 10.37 | 0.26 | 2021-12-22 | 2 | 5.71 | 1 | 10.37 | 6 | SO44481 | 2021-12-29 | 0.83 | 11.41 | 5.19 | |||
SO50727_37 | 5DD5-4A9A-B1 | PO9483181443 | 100 | 283 | 383 | 54 | 2 | 2023-08-03 | 1800.79 | 45.02 | 2023-07-22 | 3 | 605.65 | 1 | 1800.79 | 37 | SO50727 | 2023-07-29 | 144.06 | 1816.95 | 600.26 | |||
SO61251_1 | 0DCB-4D48-AF | PO6380165323 | 100 | 281 | 564 | 597 | 4 | 2024-03-04 | 1430.44 | 35.76 | 2024-02-21 | 1 | 1481.94 | 1 | 1430.44 | 1 | SO61251 | 2024-02-28 | 114.44 | 1481.94 | 1430.44 | |||
SO45060_1 | 39B0-42BB-92 | PO10817172372 | 100 | 287 | 326 | 203 | 4 | 2022-03-05 | 838.92 | 20.97 | 2022-02-21 | 2 | 413.15 | 1 | 838.92 | 1 | SO45060 | 2022-02-28 | 67.11 | 826.29 | 419.46 | |||
SO53606_43 | 6A19-463C-B7 | PO5539128997 | 100 | 282 | 525 | 61 | 4 | 2023-11-03 | 316.86 | 7.92 | 2023-10-22 | 2 | 144.59 | 1 | 316.86 | 43 | SO53606 | 2023-10-29 | 25.35 | 289.19 | 158.43 | |||
SO53497_25 | 1F74-43F0-9F | PO12673113349 | 100 | 292 | 408 | 499 | 7 | 2023-11-03 | 216.49 | 5.41 | 2023-10-22 | 3 | 53.40 | 1 | 216.49 | 25 | SO53497 | 2023-10-29 | 17.32 | 160.20 | 72.16 | |||
SO44494_17 | 8EF7-4B3A-A4 | PO18386158045 | 100 | 281 | 223 | 558 | 2 | 2022-01-03 | 5.19 | 0.13 | 2021-12-22 | 1 | 5.71 | 1 | 5.19 | 17 | SO44494 | 2021-12-29 | 0.41 | 5.71 | 5.19 | |||
SO53527_34 | 0EBE-4ACB-B5 | PO1798140946 | 19 | 291 | 402 | 10 | 6 | 2023-11-03 | 216.49 | 5.41 | 2023-10-22 | 3 | 53.40 | 1 | 216.49 | 34 | SO53527 | 2023-10-29 | 17.32 | 160.20 | 72.16 | |||
SO53478_5 | 6005-4C44-A8 | PO15486115045 | 100 | 292 | 514 | 121 | 7 | 2023-11-03 | 127.80 | 3.20 | 2023-10-22 | 2 | 47.29 | 1 | 127.80 | 5 | SO53478 | 2023-10-29 | 10.22 | 94.57 | 63.90 | |||
SO48025_3 | AE8D-4A49-83 | PO10469118037 | 19 | 291 | 470 | 335 | 6 | 2023-01-03 | 68.38 | 1.71 | 2022-12-22 | 3 | 15.67 | 1 | 68.38 | 3 | SO48025 | 2022-12-29 | 5.47 | 47.01 | 22.79 | |||
SO58948_4 | 1534-4AB5-81 | PO11774195497 | 6 | 296 | 586 | 682 | 9 | 2024-02-02 | 890.82 | 22.27 | 2024-01-21 | 2 | 461.44 | 1 | 890.82 | 4 | SO58948 | 2024-01-28 | 71.27 | 922.89 | 445.41 | |||
SO71894_8 | 8013-4FC0-B4 | PO7685115663 | 100 | 283 | 465 | 539 | 2 | 2024-08-03 | 102.86 | 2.57 | 2024-07-22 | 7 | 9.16 | 1 | 102.86 | 8 | SO71894 | 2024-07-29 | 8.23 | 64.12 | 14.69 | |||
SO50724_10 | E9DD-40CA-B2 | PO9686154363 | 100 | 282 | 420 | 457 | 4 | 2023-08-03 | 141.62 | 3.54 | 2023-07-22 | 1 | 104.80 | 1 | 141.62 | 10 | SO50724 | 2023-07-29 | 11.33 | 104.80 | 141.62 | |||
SO43897_4 | 128F-4FD9-A4 | PO3799116239 | 100 | 282 | 350 | 312 | 4 | 2021-10-03 | 8099.98 | 202.50 | 2021-09-21 | 4 | 1898.09 | 1 | 8099.98 | 4 | SO43897 | 2021-09-28 | 648.00 | 7592.38 | 2024.99 | |||
SO50310_22 | FCBD-48EE-A9 | PO6438126969 | 100 | 281 | 448 | 309 | 4 | 2023-07-03 | 47.98 | 1.20 | 2023-06-21 | 4 | 8.25 | 1 | 47.98 | 22 | SO50310 | 2023-06-28 | 3.84 | 32.98 | 11.99 | |||
SO46992_20 | C958-4FD6-A0 | PO11745117547 | 100 | 282 | 407 | 97 | 4 | 2022-10-03 | 196.81 | 4.92 | 2022-09-21 | 3 | 48.55 | 1 | 196.81 | 20 | SO46992 | 2022-09-28 | 15.74 | 145.64 | 65.60 | |||
SO48338_2 | CF00-46C1-99 | PO11107115615 | 19 | 284 | 343 | 156 | 6 | 2023-02-02 | 469.79 | 11.74 | 2023-01-21 | 1 | 486.71 | 1 | 469.79 | 2 | SO48338 | 2023-01-28 | 37.58 | 486.71 | 469.79 | |||
SO58909_44 | EBC4-496C-90 | PO19343180161 | 100 | 282 | 490 | 24 | 4 | 2024-02-02 | 259.15 | 6.48 | 2024-01-21 | 8 | 41.57 | 1 | 259.15 | 44 | SO58909 | 2024-01-28 | 20.73 | 332.58 | 32.39 | |||
SO55239_25 | EDCD-45C2-B0 | PO17197177243 | 100 | 283 | 355 | 125 | 2 | 2023-12-03 | 11135.95 | 278.40 | 2023-11-21 | 8 | 1265.62 | 1 | 11135.95 | 25 | SO55239 | 2023-11-28 | 890.88 | 10124.96 | 1391.99 | |||
SO51140_30 | 0583-4C94-BA | PO6467148715 | 100 | 283 | 488 | 2 | 660 | 3 | 6.89 | 2023-09-02 | 344.46 | 8.44 | 2023-08-21 | 11 | 41.57 | 1 | 337.57 | 30 | SO51140 | 2023-08-28 | 27.01 | 457.30 | 31.31 | 0.02 |
SO46076_25 | E898-4203-B0 | PO2523131751 | 100 | 287 | 314 | 167 | 4 | 2022-07-03 | 6440.89 | 161.02 | 2022-06-21 | 3 | 2171.29 | 1 | 6440.89 | 25 | SO46076 | 2022-06-28 | 515.27 | 6513.88 | 2146.96 | |||
SO63202_7 | 5C83-47EE-AA | PO15631193825 | 100 | 282 | 363 | 43 | 1 | 2024-04-04 | 4130.98 | 103.27 | 2024-03-23 | 3 | 1251.98 | 1 | 4130.98 | 7 | SO63202 | 2024-03-30 | 330.48 | 3755.94 | 1376.99 | |||
SO71892_9 | 5153-412B-84 | PO4814151834 | 36 | 295 | 571 | 464 | 8 | 2024-08-03 | 890.82 | 22.27 | 2024-07-22 | 2 | 461.44 | 1 | 890.82 | 9 | SO71892 | 2024-07-29 | 71.27 | 922.89 | 445.41 |
Generated 2024-09-20 03:44:48.483 UTC