[ROOT] dt FactResellerSale < WHERE DimSalesTerritoryId EQ '7' > SHUFFLE < SKIP 370 > < TAKE 30 >
30 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 |
---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
SO51739_52 | AF60-4F2F-9B | PO12702124697 | 100 | 292 | 597 | 175 | 7 | 2023-10-02 | 323.99 | 8.10 | 2023-09-20 | 1 | 294.58 | 1 | 323.99 | 52 | SO51739 | 2023-09-27 | 25.92 | 294.58 | 323.99 | |||
SO58926_15 | B82A-4380-9C | PO15486118845 | 100 | 292 | 603 | 121 | 7 | 2024-02-01 | 145.79 | 3.64 | 2024-01-20 | 2 | 53.94 | 1 | 145.79 | 15 | SO58926 | 2024-01-27 | 11.66 | 107.88 | 72.89 | |||
SO57068_33 | 0E44-4044-B3 | PO11223190191 | 100 | 292 | 551 | 632 | 7 | 2024-01-02 | 316.86 | 7.92 | 2023-12-21 | 2 | 144.59 | 1 | 316.86 | 33 | SO57068 | 2023-12-28 | 25.35 | 289.19 | 158.43 | |||
SO53478_23 | 6005-4C44-A8 | PO15486115045 | 100 | 292 | 532 | 121 | 7 | 2023-11-02 | 299.75 | 7.49 | 2023-10-21 | 2 | 136.79 | 1 | 299.75 | 23 | SO53478 | 2023-10-28 | 23.98 | 273.57 | 149.87 | |||
SO51742_11 | 1720-457C-B3 | PO12731111072 | 36 | 292 | 222 | 247 | 7 | 2023-10-02 | 41.99 | 1.05 | 2023-09-20 | 2 | 13.09 | 1 | 41.99 | 11 | SO51742 | 2023-09-27 | 3.36 | 26.17 | 20.99 | |||
SO61216_11 | B500-4250-B9 | PO13340173082 | 100 | 292 | 477 | 355 | 7 | 2024-03-03 | 11.98 | 0.30 | 2024-02-20 | 4 | 1.87 | 1 | 11.98 | 11 | SO61216 | 2024-02-27 | 0.96 | 7.47 | 2.99 | |||
SO51861_25 | 1365-48AA-87 | PO3712133982 | 100 | 290 | 234 | 662 | 7 | 2023-10-02 | 29.99 | 0.75 | 2023-09-20 | 1 | 38.49 | 1 | 29.99 | 25 | SO51861 | 2023-09-27 | 2.40 | 38.49 | 29.99 | |||
SO49833_5 | 595A-4EFA-AC | PO13340158028 | 100 | 292 | 409 | 355 | 7 | 2023-06-02 | 1046.28 | 26.16 | 2023-05-21 | 5 | 185.82 | 1 | 1046.28 | 5 | SO49833 | 2023-05-28 | 83.70 | 929.10 | 209.26 | |||
SO69447_20 | 1C7A-4B97-AA | PO11223139140 | 100 | 292 | 599 | 632 | 7 | 2024-07-02 | 323.99 | 8.10 | 2024-06-20 | 1 | 294.58 | 1 | 323.99 | 20 | SO69447 | 2024-06-27 | 25.92 | 294.58 | 323.99 | |||
SO61216_14 | B500-4250-B9 | PO13340173082 | 100 | 292 | 483 | 355 | 7 | 2024-03-03 | 432.00 | 10.80 | 2024-02-20 | 6 | 44.88 | 1 | 432.00 | 14 | SO61216 | 2024-02-27 | 34.56 | 269.28 | 72.00 | |||
SO46627_13 | A7A2-45B6-97 | PO13485114699 | 100 | 292 | 428 | 265 | 7 | 2022-09-01 | 418.51 | 10.46 | 2022-08-20 | 2 | 185.82 | 1 | 418.51 | 13 | SO46627 | 2022-08-27 | 33.48 | 371.64 | 209.26 | |||
SO51104_46 | D008-4004-A4 | PO13340177593 | 100 | 292 | 515 | 355 | 7 | 2023-09-01 | 16.27 | 0.41 | 2023-08-20 | 1 | 12.04 | 1 | 16.27 | 46 | SO51104 | 2023-08-27 | 1.30 | 12.04 | 16.27 | |||
SO69437_7 | AEEE-4ABB-A6 | PO12702116983 | 100 | 292 | 542 | 175 | 7 | 2024-07-02 | 121.47 | 3.04 | 2024-06-20 | 5 | 17.98 | 1 | 121.47 | 7 | SO69437 | 2024-06-27 | 9.72 | 89.89 | 24.29 | |||
SO51733_16 | 5E45-4EBB-89 | PO13108175772 | 100 | 292 | 576 | 103 | 7 | 2023-10-02 | 1430.44 | 35.76 | 2023-09-20 | 1 | 1481.94 | 1 | 1430.44 | 16 | SO51733 | 2023-09-27 | 114.44 | 1481.94 | 1430.44 | |||
SO46626_20 | CFB3-4671-A6 | PO13340194893 | 100 | 292 | 453 | 355 | 7 | 2022-09-01 | 359.94 | 9.00 | 2022-08-20 | 10 | 24.75 | 1 | 359.94 | 20 | SO46626 | 2022-08-27 | 28.80 | 247.46 | 35.99 | |||
SO49833_16 | 595A-4EFA-AC | PO13340158028 | 100 | 292 | 411 | 355 | 7 | 2023-06-02 | 376.25 | 9.41 | 2023-05-21 | 3 | 92.81 | 1 | 376.25 | 16 | SO49833 | 2023-05-28 | 30.10 | 278.42 | 125.42 | |||
SO47377_10 | FA63-499A-AB | PO15515156459 | 100 | 292 | 368 | 481 | 7 | 2022-11-02 | 8796.06 | 219.90 | 2022-10-21 | 6 | 1518.79 | 1 | 8796.06 | 10 | SO47377 | 2022-10-28 | 703.68 | 9112.72 | 1466.01 | |||
SO51739_44 | AF60-4F2F-9B | PO12702124697 | 100 | 292 | 558 | 175 | 7 | 2023-10-02 | 2186.95 | 54.67 | 2023-09-20 | 9 | 179.82 | 1 | 2186.95 | 44 | SO51739 | 2023-09-27 | 174.96 | 1618.34 | 242.99 | |||
SO71838_2 | C65D-4244-8E | PO1305123041 | 100 | 292 | 568 | 319 | 7 | 2024-08-02 | 445.41 | 11.14 | 2024-07-21 | 1 | 461.44 | 1 | 445.41 | 2 | SO71838 | 2024-07-28 | 35.63 | 461.44 | 445.41 | |||
SO47377_31 | FA63-499A-AB | PO15515156459 | 100 | 292 | 331 | 481 | 7 | 2022-11-02 | 469.79 | 11.74 | 2022-10-21 | 1 | 486.71 | 1 | 469.79 | 31 | SO47377 | 2022-10-28 | 37.58 | 486.71 | 469.79 | |||
SO63223_18 | 70F5-4AD9-A9 | PO13427118669 | 100 | 292 | 287 | 638 | 7 | 2024-04-03 | 1213.99 | 30.35 | 2024-03-22 | 6 | 204.63 | 1 | 1213.99 | 18 | SO63223 | 2024-03-29 | 97.12 | 1227.75 | 202.33 | |||
SO63179_21 | F2C5-4376-B7 | PO2668147145 | 100 | 292 | 512 | 535 | 7 | 2024-04-03 | 436.91 | 10.92 | 2024-03-22 | 2 | 199.38 | 1 | 436.91 | 21 | SO63179 | 2024-03-29 | 34.95 | 398.75 | 218.45 | |||
SO46987_20 | 60CF-4768-AF | PO12702179544 | 100 | 292 | 462 | 175 | 7 | 2022-10-02 | 70.64 | 1.77 | 2022-09-20 | 5 | 9.71 | 1 | 70.64 | 20 | SO46987 | 2022-09-27 | 5.65 | 48.57 | 14.13 | |||
SO51729_16 | 5C3E-453A-B0 | PO13369147165 | 100 | 292 | 545 | 391 | 7 | 2023-10-02 | 72.88 | 1.82 | 2023-09-20 | 3 | 17.98 | 1 | 72.88 | 16 | SO51729 | 2023-09-27 | 5.83 | 53.93 | 24.29 | |||
SO47969_3 | 437D-4650-BB | PO18821182050 | 100 | 290 | 358 | 686 | 7 | 2023-01-02 | 3688.38 | 92.21 | 2022-12-21 | 3 | 1105.81 | 1 | 3688.38 | 3 | SO47969 | 2022-12-28 | 295.07 | 3317.43 | 1229.46 | |||
SO51857_8 | 918B-493C-BA | PO3683131763 | 100 | 292 | 571 | 13 | 85 | 7 | 300.65 | 2023-10-02 | 2004.35 | 42.59 | 2023-09-20 | 6 | 461.44 | 1 | 1703.69 | 8 | SO51857 | 2023-09-27 | 136.30 | 2768.67 | 334.06 | 0.15 |
SO69433_18 | C243-44BD-B7 | PO13456135245 | 36 | 292 | 562 | 614 | 7 | 2024-07-02 | 1430.44 | 35.76 | 2024-06-20 | 1 | 1481.94 | 1 | 1430.44 | 18 | SO69433 | 2024-06-27 | 114.44 | 1481.94 | 1430.44 | |||
SO47391_30 | 8A04-4F3F-97 | PO12673197440 | 100 | 292 | 439 | 499 | 7 | 2022-11-02 | 780.82 | 19.52 | 2022-10-21 | 1 | 722.26 | 1 | 780.82 | 30 | SO47391 | 2022-10-28 | 62.47 | 722.26 | 780.82 | |||
SO69437_15 | AEEE-4ABB-A6 | PO12702116983 | 100 | 292 | 556 | 175 | 7 | 2024-07-02 | 526.47 | 13.16 | 2024-06-20 | 5 | 77.92 | 1 | 526.47 | 15 | SO69437 | 2024-06-27 | 42.12 | 389.59 | 105.29 | |||
SO50673_25 | 5E3E-4044-A0 | PO15515116492 | 100 | 292 | 414 | 481 | 7 | 2023-08-02 | 1043.22 | 26.08 | 2023-07-21 | 7 | 110.28 | 1 | 1043.22 | 25 | SO50673 | 2023-07-28 | 83.46 | 771.98 | 149.03 |
Generated 2024-09-20 01:31:01.988 UTC