[ROOT] dt FactResellerSale WHERE DimSalesTerritoryId EQ '1' > SHUFFLE SKIP 2000 < SKIP 344 > < 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 |
---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
SO47701_2 | 5718-4DDD-B7 | PO2929114832 | 100 | 289 | 470 | 380 | 1 | 2022-12-02 | 68.38 | 1.71 | 2022-11-20 | 3 | 15.67 | 1 | 68.38 | 2 | SO47701 | 2022-11-27 | 5.47 | 47.01 | 22.79 | |||
SO51838_21 | 8AB1-478C-86 | PO4727199391 | 100 | 293 | 440 | 343 | 1 | 2023-10-02 | 3435.60 | 85.89 | 2023-09-20 | 4 | 868.63 | 1 | 3435.60 | 21 | SO51838 | 2023-09-27 | 274.85 | 3474.54 | 858.90 | |||
SO61199_14 | EFA0-4D12-A2 | PO2552199779 | 100 | 286 | 598 | 506 | 1 | 2024-03-03 | 323.99 | 8.10 | 2024-02-20 | 1 | 294.58 | 1 | 323.99 | 14 | SO61199 | 2024-02-27 | 25.92 | 294.58 | 323.99 | |||
SO50215_1 | 820D-41FC-BE | PO14529171237 | 100 | 293 | 470 | 289 | 1 | 2023-07-02 | 45.59 | 1.14 | 2023-06-20 | 2 | 15.67 | 1 | 45.59 | 1 | SO50215 | 2023-06-27 | 3.65 | 31.34 | 22.79 | |||
SO50750_4 | 373D-417C-AE | PO7192170677 | 100 | 289 | 470 | 20 | 1 | 2023-08-02 | 68.38 | 1.71 | 2023-07-21 | 3 | 15.67 | 1 | 68.38 | 4 | SO50750 | 2023-07-28 | 5.47 | 47.01 | 22.79 | |||
SO48747_3 | EC0D-4B9B-B3 | PO2929132599 | 100 | 289 | 360 | 380 | 1 | 2023-03-04 | 3688.38 | 92.21 | 2023-02-20 | 3 | 1105.81 | 1 | 3688.38 | 3 | SO48747 | 2023-02-27 | 295.07 | 3317.43 | 1229.46 | |||
SO48289_2 | 5243-4D2E-A2 | PO20097151054 | 100 | 289 | 407 | 128 | 1 | 2023-02-01 | 65.60 | 1.64 | 2023-01-20 | 1 | 48.55 | 1 | 65.60 | 2 | SO48289 | 2023-01-27 | 5.25 | 48.55 | 65.60 | |||
SO69406_30 | E101-486C-A5 | PO16675181672 | 100 | 293 | 222 | 361 | 1 | 2024-07-02 | 125.96 | 3.15 | 2024-06-20 | 6 | 13.09 | 1 | 125.96 | 30 | SO69406 | 2024-06-27 | 10.08 | 78.52 | 20.99 | |||
SO44501_19 | 4971-4FC0-A3 | PO16646128920 | 100 | 286 | 336 | 1 | 1 | 2022-01-02 | 838.92 | 20.97 | 2021-12-21 | 2 | 413.15 | 1 | 838.92 | 19 | SO44501 | 2021-12-28 | 67.11 | 826.29 | 419.46 | |||
SO49849_14 | C8F3-4DDE-A6 | PO2552190786 | 100 | 286 | 233 | 506 | 1 | 2023-06-02 | 201.88 | 5.05 | 2023-05-21 | 7 | 29.08 | 1 | 201.88 | 14 | SO49849 | 2023-05-28 | 16.15 | 203.56 | 28.84 | |||
SO44570_16 | 4132-4AE3-99 | PO8816195785 | 100 | 289 | 220 | 218 | 1 | 2022-01-02 | 60.56 | 1.51 | 2021-12-21 | 3 | 12.03 | 1 | 60.56 | 16 | SO44570 | 2021-12-28 | 4.84 | 36.08 | 20.19 | |||
SO67346_14 | 545C-4C6E-88 | PO9338145989 | 100 | 293 | 523 | 451 | 1 | 2024-06-02 | 63.17 | 1.58 | 2024-05-21 | 2 | 23.37 | 1 | 63.17 | 14 | SO67346 | 2024-05-28 | 5.05 | 46.74 | 31.58 | |||
SO65159_4 | DDDD-4736-9B | PO19169187435 | 100 | 289 | 512 | 272 | 1 | 2024-05-02 | 218.45 | 5.46 | 2024-04-20 | 1 | 199.38 | 1 | 218.45 | 4 | SO65159 | 2024-04-27 | 17.48 | 199.38 | 218.45 | |||
SO58910_5 | A209-4ADD-98 | PO19169152738 | 100 | 289 | 556 | 272 | 1 | 2024-02-01 | 105.29 | 2.63 | 2024-01-20 | 1 | 77.92 | 1 | 105.29 | 5 | SO58910 | 2024-01-27 | 8.42 | 77.92 | 105.29 | |||
SO71833_42 | 8525-4645-AB | PO10411123072 | 100 | 289 | 499 | 182 | 1 | 2024-08-02 | 602.35 | 15.06 | 2024-07-21 | 1 | 601.74 | 1 | 602.35 | 42 | SO71833 | 2024-07-28 | 48.19 | 601.74 | 602.35 | |||
SO53467_11 | BE84-4F9B-8E | PO17487177251 | 100 | 293 | 484 | 692 | 1 | 2023-11-02 | 14.31 | 0.36 | 2023-10-21 | 3 | 2.97 | 1 | 14.31 | 11 | SO53467 | 2023-10-28 | 1.14 | 8.92 | 4.77 | |||
SO51123_37 | E412-45DF-AE | PO899150137 | 100 | 289 | 234 | 2 | 290 | 1 | 6.96 | 2023-09-01 | 347.93 | 8.52 | 2023-08-20 | 12 | 38.49 | 1 | 340.97 | 37 | SO51123 | 2023-08-27 | 27.28 | 461.91 | 28.99 | 0.02 |
SO53500_10 | BEF0-4525-AF | PO12470126979 | 100 | 287 | 502 | 672 | 1 | 2023-11-02 | 800.21 | 20.01 | 2023-10-21 | 4 | 199.85 | 1 | 800.21 | 10 | SO53500 | 2023-10-28 | 64.02 | 799.41 | 200.05 | |||
SO48747_4 | EC0D-4B9B-B3 | PO2929132599 | 100 | 289 | 468 | 380 | 1 | 2023-03-04 | 22.79 | 0.57 | 2023-02-20 | 1 | 15.67 | 1 | 22.79 | 4 | SO48747 | 2023-02-27 | 1.82 | 15.67 | 22.79 | |||
SO47033_17 | 2797-46ED-BB | PO4727113716 | 100 | 286 | 389 | 343 | 1 | 2022-10-02 | 2401.05 | 60.03 | 2022-09-20 | 4 | 605.65 | 1 | 2401.05 | 17 | SO47033 | 2022-09-27 | 192.08 | 2422.60 | 600.26 | |||
SO69422_21 | BF3A-4F54-82 | PO14500139823 | 100 | 282 | 472 | 650 | 1 | 2024-07-02 | 190.50 | 4.76 | 2024-06-20 | 5 | 23.75 | 1 | 190.50 | 21 | SO69422 | 2024-06-27 | 15.24 | 118.75 | 38.10 | |||
SO44501_10 | 4971-4FC0-A3 | PO16646128920 | 100 | 286 | 317 | 1 | 1 | 2022-01-02 | 1749.59 | 43.74 | 2021-12-21 | 2 | 884.71 | 1 | 1749.59 | 10 | SO44501 | 2021-12-28 | 139.97 | 1769.42 | 874.79 | |||
SO48079_25 | A42B-43D5-B0 | PO7627191699 | 100 | 293 | 371 | 433 | 1 | 2023-01-02 | 1308.94 | 32.72 | 2022-12-21 | 1 | 1320.68 | 1 | 1308.94 | 25 | SO48079 | 2022-12-28 | 104.72 | 1320.68 | 1308.94 | |||
SO46379_2 | 8ABD-4B11-A1 | PO7192140645 | 100 | 289 | 346 | 7 | 20 | 1 | 595.00 | 2022-08-02 | 1700.00 | 27.62 | 2022-07-21 | 2 | 1912.15 | 1 | 1105.00 | 2 | SO46379 | 2022-07-28 | 88.40 | 3824.31 | 850.00 | 0.35 |
SO58963_34 | 6ADC-4485-8C | PO841129336 | 100 | 286 | 355 | 254 | 1 | 2024-02-01 | 2783.99 | 69.60 | 2024-01-20 | 2 | 1265.62 | 1 | 2783.99 | 34 | SO58963 | 2024-01-27 | 222.72 | 2531.24 | 1391.99 | |||
SO69521_4 | EAFC-4D00-94 | PO6148143676 | 100 | 289 | 568 | 693 | 1 | 2024-07-02 | 2672.46 | 66.81 | 2024-06-20 | 6 | 461.44 | 1 | 2672.46 | 4 | SO69521 | 2024-06-27 | 213.80 | 2768.67 | 445.41 | |||
SO48328_8 | 5992-4AF8-B1 | PO13543152596 | 100 | 287 | 469 | 293 | 1 | 2023-02-01 | 91.18 | 2.28 | 2023-01-20 | 4 | 15.67 | 1 | 91.18 | 8 | SO48328 | 2023-01-27 | 7.29 | 62.68 | 22.79 | |||
SO53493_29 | F767-491F-84 | PO13543118174 | 100 | 287 | 531 | 293 | 1 | 2023-11-02 | 299.75 | 7.49 | 2023-10-21 | 2 | 136.79 | 1 | 299.75 | 29 | SO53493 | 2023-10-28 | 23.98 | 273.57 | 149.87 | |||
SO69525_4 | 9DCD-4F42-9E | PO4727119266 | 100 | 293 | 418 | 343 | 1 | 2024-07-02 | 356.90 | 8.92 | 2024-06-20 | 1 | 360.94 | 1 | 356.90 | 4 | SO69525 | 2024-06-27 | 28.55 | 360.94 | 356.90 | |||
SO51089_28 | A635-4BAF-BC | PO16588151558 | 100 | 289 | 599 | 146 | 1 | 2023-09-01 | 1619.97 | 40.50 | 2023-08-20 | 5 | 294.58 | 1 | 1619.97 | 28 | SO51089 | 2023-08-27 | 129.60 | 1472.90 | 323.99 | |||
SO69508_22 | 387A-4EC2-A7 | PO7627176234 | 100 | 293 | 606 | 433 | 1 | 2024-07-02 | 1943.96 | 48.60 | 2024-06-20 | 6 | 343.65 | 1 | 1943.96 | 22 | SO69508 | 2024-06-27 | 155.52 | 2061.90 | 323.99 |
Generated 2024-09-20 00:07:01.319 UTC