[ROOT] dt FactResellerSale < WHERE DimSalesTerritoryId EQ '7' > SHUFFLE < SKIP 228 > < 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 |
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
| SO46626_35 | CFB3-4671-A6 | PO13340194893 | 100 | 292 | 216 | 8 | 355 | 7 | 10.09 | 2022-09-01 | 100.93 | 2.27 | 2022-08-20 | 6 | 13.88 | 1 | 90.84 | 35 | SO46626 | 2022-08-27 | 7.27 | 83.27 | 16.82 | 0.10 |
| SO65286_7 | 8A77-4D51-91 | PO1305125843 | 100 | 292 | 586 | 319 | 7 | 2024-05-02 | 890.82 | 22.27 | 2024-04-20 | 2 | 461.44 | 1 | 890.82 | 7 | SO65286 | 2024-04-27 | 71.27 | 922.89 | 445.41 | |||
| SO71801_18 | 0DBE-43DA-9A | PO15515173664 | 100 | 292 | 472 | 481 | 7 | 2024-08-02 | 304.80 | 7.62 | 2024-07-21 | 8 | 23.75 | 1 | 304.80 | 18 | SO71801 | 2024-07-28 | 24.38 | 189.99 | 38.10 | |||
| SO50681_6 | C44A-4F6F-86 | PO12673115760 | 100 | 292 | 323 | 499 | 7 | 2023-08-02 | 2818.76 | 70.47 | 2023-07-21 | 6 | 486.71 | 1 | 2818.76 | 6 | SO50681 | 2023-07-28 | 225.50 | 2920.24 | 469.79 | |||
| SO63223_24 | 70F5-4AD9-A9 | PO13427118669 | 100 | 292 | 477 | 2 | 638 | 7 | 0.69 | 2024-04-03 | 34.73 | 0.85 | 2024-03-22 | 12 | 1.87 | 1 | 34.04 | 24 | SO63223 | 2024-03-29 | 2.72 | 22.40 | 2.89 | 0.02 |
| SO51857_9 | 918B-493C-BA | PO3683131763 | 100 | 292 | 564 | 14 | 85 | 7 | 953.63 | 2023-10-02 | 4768.14 | 95.36 | 2023-09-20 | 5 | 1481.94 | 1 | 3814.51 | 9 | SO51857 | 2023-09-27 | 305.16 | 7409.69 | 953.63 | 0.20 |
| SO69506_4 | DCE2-4698-93 | PO3712113892 | 100 | 292 | 560 | 662 | 7 | 2024-07-02 | 728.91 | 18.22 | 2024-06-20 | 1 | 755.15 | 1 | 728.91 | 4 | SO69506 | 2024-06-27 | 58.31 | 755.15 | 728.91 | |||
| SO61258_1 | 9DCB-43A8-8D | PO3509137345 | 36 | 292 | 490 | 139 | 7 | 2024-03-03 | 129.58 | 3.24 | 2024-02-20 | 4 | 41.57 | 1 | 129.58 | 1 | SO61258 | 2024-02-27 | 10.37 | 166.29 | 32.39 | |||
| SO51774_34 | 30BA-400A-89 | PO2668194455 | 100 | 292 | 516 | 535 | 7 | 2023-10-02 | 187.87 | 4.70 | 2023-09-20 | 8 | 17.38 | 1 | 187.87 | 34 | SO51774 | 2023-09-27 | 15.03 | 139.03 | 23.48 | |||
| SO47391_1 | 8A04-4F3F-97 | PO12673197440 | 100 | 292 | 333 | 499 | 7 | 2022-11-02 | 2818.76 | 70.47 | 2022-10-21 | 6 | 486.71 | 1 | 2818.76 | 1 | SO47391 | 2022-10-28 | 225.50 | 2920.24 | 469.79 | |||
| SO71820_16 | D332-4AF2-A3 | PO12673129941 | 100 | 292 | 545 | 499 | 7 | 2024-08-02 | 24.29 | 0.61 | 2024-07-21 | 1 | 17.98 | 1 | 24.29 | 16 | SO71820 | 2024-07-28 | 1.94 | 17.98 | 24.29 | |||
| SO57150_15 | 0163-41B3-92 | PO3683172338 | 100 | 292 | 561 | 85 | 7 | 2024-01-02 | 12873.98 | 321.85 | 2023-12-21 | 9 | 1481.94 | 1 | 12873.98 | 15 | SO57150 | 2023-12-28 | 1029.92 | 13337.44 | 1430.44 | |||
| SO46981_13 | 22E4-4440-81 | PO13427119728 | 100 | 292 | 321 | 638 | 7 | 2022-10-02 | 939.59 | 23.49 | 2022-09-20 | 2 | 486.71 | 1 | 939.59 | 13 | SO46981 | 2022-09-27 | 75.17 | 973.41 | 469.79 | |||
| SO69477_2 | 5330-4B68-B5 | PO18821146707 | 36 | 292 | 474 | 686 | 7 | 2024-07-02 | 251.96 | 6.30 | 2024-06-20 | 6 | 26.18 | 1 | 251.96 | 2 | SO69477 | 2024-06-27 | 20.16 | 157.06 | 41.99 | |||
| SO57061_29 | C48C-4776-A7 | PO12702183787 | 100 | 292 | 592 | 175 | 7 | 2024-01-02 | 338.99 | 8.47 | 2023-12-21 | 1 | 308.22 | 1 | 338.99 | 29 | SO57061 | 2023-12-28 | 27.12 | 308.22 | 338.99 | |||
| SO51734_41 | 9D8E-4873-8B | PO13427111801 | 100 | 292 | 482 | 638 | 7 | 2023-10-02 | 10.79 | 0.27 | 2023-09-20 | 2 | 3.36 | 1 | 10.79 | 41 | SO51734 | 2023-09-27 | 0.86 | 6.72 | 5.39 | |||
| SO55252_42 | 1F1C-4667-AE | PO13340115824 | 100 | 292 | 591 | 355 | 7 | 2023-12-02 | 1016.98 | 25.42 | 2023-11-20 | 3 | 308.22 | 1 | 1016.98 | 42 | SO55252 | 2023-11-27 | 81.36 | 924.65 | 338.99 | |||
| SO63216_6 | A61E-4461-B6 | PO12702151034 | 100 | 292 | 306 | 175 | 7 | 2024-04-03 | 809.76 | 20.24 | 2024-03-22 | 1 | 739.04 | 1 | 809.76 | 6 | SO63216 | 2024-03-29 | 64.78 | 739.04 | 809.76 | |||
| SO49056_1 | CB7A-4434-B5 | PO13282147301 | 36 | 292 | 366 | 157 | 7 | 2023-04-04 | 647.99 | 16.20 | 2023-03-23 | 1 | 598.44 | 1 | 647.99 | 1 | SO49056 | 2023-03-30 | 51.84 | 598.44 | 647.99 | |||
| SO63179_9 | F2C5-4376-B7 | PO2668147145 | 100 | 292 | 491 | 535 | 7 | 2024-04-03 | 259.15 | 6.48 | 2024-03-22 | 8 | 41.57 | 1 | 259.15 | 9 | SO63179 | 2024-03-29 | 20.73 | 332.58 | 32.39 | |||
| SO67339_2 | E214-4902-AC | PO3509143630 | 36 | 292 | 222 | 2 | 139 | 7 | 4.46 | 2024-06-02 | 223.24 | 5.47 | 2024-05-21 | 11 | 13.09 | 1 | 218.77 | 2 | SO67339 | 2024-05-28 | 17.50 | 143.95 | 20.29 | 0.02 |
| SO57061_20 | C48C-4776-A7 | PO12702183787 | 100 | 292 | 475 | 175 | 7 | 2024-01-02 | 83.99 | 2.10 | 2023-12-21 | 2 | 26.18 | 1 | 83.99 | 20 | SO57061 | 2023-12-28 | 6.72 | 52.35 | 41.99 | |||
| SO51734_38 | 9D8E-4873-8B | PO13427111801 | 100 | 292 | 434 | 638 | 7 | 2023-10-02 | 2498.29 | 62.46 | 2023-09-20 | 7 | 360.94 | 1 | 2498.29 | 38 | SO51734 | 2023-09-27 | 199.86 | 2526.60 | 356.90 | |||
| 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 | |||
| SO69447_35 | 1C7A-4B97-AA | PO11223139140 | 100 | 292 | 524 | 632 | 7 | 2024-07-02 | 316.86 | 7.92 | 2024-06-20 | 2 | 144.59 | 1 | 316.86 | 35 | SO69447 | 2024-06-27 | 25.35 | 289.19 | 158.43 | |||
| SO47377_15 | FA63-499A-AB | PO15515156459 | 100 | 292 | 333 | 481 | 7 | 2022-11-02 | 2348.97 | 58.72 | 2022-10-21 | 5 | 486.71 | 1 | 2348.97 | 15 | SO47377 | 2022-10-28 | 187.92 | 2433.53 | 469.79 | |||
| SO57055_2 | 3CBC-4CD2-B1 | PO13369127604 | 100 | 292 | 545 | 391 | 7 | 2024-01-02 | 72.88 | 1.82 | 2023-12-21 | 3 | 17.98 | 1 | 72.88 | 2 | SO57055 | 2023-12-28 | 5.83 | 53.93 | 24.29 | |||
| SO69426_25 | 4194-45D7-B6 | PO13427130433 | 100 | 292 | 584 | 638 | 7 | 2024-07-02 | 323.99 | 8.10 | 2024-06-20 | 1 | 343.65 | 1 | 323.99 | 25 | SO69426 | 2024-06-27 | 25.92 | 343.65 | 323.99 |
Generated 2024-09-20 02:27:21.139 UTC