[ROOT] dt FactResellerSale < WHERE DimProductId EQ ALL SHUFFLE SKIP 2000 < SKIP 500 > < 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 |
---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
SO50231_5 | B2CA-498D-9B | PO11571129150 | 100 | 285 | 341 | 512 | 5 | 2023-07-02 | 939.59 | 23.49 | 2023-06-20 | 2 | 486.71 | 1 | 939.59 | 5 | SO50231 | 2023-06-27 | 75.17 | 973.41 | 469.79 | |||
SO45335_14 | CF69-4308-92 | PO6641155631 | 100 | 281 | 324 | 342 | 2 | 2022-04-04 | 838.92 | 20.97 | 2022-03-23 | 2 | 413.15 | 1 | 838.92 | 14 | SO45335 | 2022-03-30 | 67.11 | 826.29 | 419.46 | |||
SO65303_30 | 93EA-4158-A9 | PO5539133147 | 100 | 282 | 363 | 61 | 4 | 2024-05-02 | 9638.96 | 240.97 | 2024-04-20 | 7 | 1251.98 | 1 | 9638.96 | 30 | SO65303 | 2024-04-27 | 771.12 | 8763.87 | 1376.99 | |||
SO51164_5 | 595F-419D-AD | PO1421153638 | 100 | 293 | 217 | 11 | 325 | 1 | 4.72 | 2023-09-01 | 31.49 | 0.67 | 2023-08-20 | 2 | 13.09 | 1 | 26.77 | 5 | SO51164 | 2023-08-27 | 2.14 | 26.17 | 15.75 | 0.15 |
SO46648_5 | 2073-4051-9E | PO2494191557 | 100 | 283 | 397 | 184 | 4 | 2022-09-01 | 97.18 | 2.43 | 2022-08-20 | 4 | 17.98 | 1 | 97.18 | 5 | SO46648 | 2022-08-27 | 7.77 | 71.91 | 24.29 | |||
SO47019_5 | 835A-4E34-9E | PO2668115692 | 100 | 292 | 410 | 535 | 7 | 2022-10-02 | 36.45 | 0.91 | 2022-09-20 | 1 | 26.97 | 1 | 36.45 | 5 | SO47019 | 2022-09-27 | 2.92 | 26.97 | 36.45 | |||
SO48339_3 | EAB2-42EA-9C | PO10614150674 | 19 | 291 | 323 | 461 | 6 | 2023-02-01 | 1409.38 | 35.23 | 2023-01-20 | 3 | 486.71 | 1 | 1409.38 | 3 | SO48339 | 2023-01-27 | 112.75 | 1460.12 | 469.79 | |||
SO47009_19 | 8F7C-4372-A2 | PO1508115971 | 98 | 288 | 329 | 430 | 10 | 2022-10-02 | 469.79 | 11.74 | 2022-09-20 | 1 | 486.71 | 1 | 469.79 | 19 | SO47009 | 2022-09-27 | 37.58 | 486.71 | 469.79 | |||
SO51131_2 | D489-4DF3-A2 | PO16298169856 | 100 | 287 | 488 | 2 | 599 | 4 | 7.52 | 2023-09-01 | 375.77 | 9.21 | 2023-08-20 | 12 | 41.57 | 1 | 368.26 | 2 | SO51131 | 2023-08-27 | 29.46 | 498.87 | 31.31 | 0.02 |
SO53502_23 | DC5E-4F14-87 | PO11774190456 | 6 | 294 | 560 | 682 | 9 | 2023-11-02 | 728.91 | 18.22 | 2023-10-21 | 1 | 755.15 | 1 | 728.91 | 23 | SO53502 | 2023-10-28 | 58.31 | 755.15 | 728.91 | |||
SO55261_18 | 130D-46E9-9B | PO11484193890 | 100 | 283 | 357 | 594 | 2 | 2023-12-02 | 2783.99 | 69.60 | 2023-11-20 | 2 | 1265.62 | 1 | 2783.99 | 18 | SO55261 | 2023-11-27 | 222.72 | 2531.24 | 1391.99 | |||
SO48741_6 | 5AA4-4194-B9 | PO899196006 | 100 | 289 | 286 | 290 | 1 | 2023-03-04 | 367.88 | 9.20 | 2023-02-20 | 2 | 170.14 | 1 | 367.88 | 6 | SO48741 | 2023-02-27 | 29.43 | 340.29 | 183.94 | |||
SO53452_11 | B555-4FD7-8B | PO870113712 | 100 | 286 | 565 | 13 | 621 | 1 | 200.43 | 2023-11-02 | 1336.23 | 28.39 | 2023-10-21 | 4 | 461.44 | 1 | 1135.80 | 11 | SO53452 | 2023-10-28 | 90.86 | 1845.78 | 334.06 | 0.15 |
SO46359_16 | 95FD-4612-88 | PO1740167502 | 19 | 288 | 276 | 460 | 6 | 2022-08-02 | 356.90 | 8.92 | 2022-07-21 | 1 | 352.14 | 1 | 356.90 | 16 | SO46359 | 2022-07-28 | 28.55 | 352.14 | 356.90 | |||
SO57065_41 | B68A-407E-99 | PO11658151711 | 100 | 283 | 234 | 233 | 2 | 2024-01-02 | 299.94 | 7.50 | 2023-12-21 | 10 | 38.49 | 1 | 299.94 | 41 | SO57065 | 2023-12-28 | 24.00 | 384.92 | 29.99 | |||
SO58948_33 | 1534-4AB5-81 | PO11774195497 | 6 | 296 | 571 | 682 | 9 | 2024-02-01 | 890.82 | 22.27 | 2024-01-20 | 2 | 461.44 | 1 | 890.82 | 33 | SO58948 | 2024-01-27 | 71.27 | 922.89 | 445.41 | |||
SO48331_4 | CF29-4690-9A | PO12876158230 | 19 | 284 | 435 | 300 | 6 | 2023-02-01 | 648.91 | 16.22 | 2023-01-20 | 2 | 300.12 | 1 | 648.91 | 4 | SO48331 | 2023-01-27 | 51.91 | 600.24 | 324.45 | |||
SO49494_17 | 81A4-4876-94 | PO17139199930 | 100 | 293 | 435 | 644 | 1 | 2023-05-02 | 324.45 | 8.11 | 2023-04-20 | 1 | 300.12 | 1 | 324.45 | 17 | SO49494 | 2023-04-27 | 25.96 | 300.12 | 324.45 | |||
SO71818_21 | 2FCA-4131-BD | PO12470139718 | 100 | 287 | 500 | 672 | 1 | 2024-08-02 | 1807.04 | 45.18 | 2024-07-21 | 3 | 601.74 | 1 | 1807.04 | 21 | SO71818 | 2024-07-28 | 144.56 | 1805.23 | 602.35 | |||
SO51783_16 | B7A2-49BC-89 | PO18676114917 | 100 | 282 | 532 | 697 | 1 | 2023-10-02 | 1049.12 | 26.23 | 2023-09-20 | 7 | 136.79 | 1 | 1049.12 | 16 | SO51783 | 2023-09-27 | 83.93 | 957.50 | 149.87 | |||
SO51763_30 | CDB1-4311-8D | PO957124084 | 98 | 288 | 491 | 2 | 376 | 10 | 7.52 | 2023-10-02 | 375.77 | 9.21 | 2023-09-20 | 12 | 41.57 | 1 | 368.26 | 30 | SO51763 | 2023-09-27 | 29.46 | 498.87 | 31.31 | 0.02 |
SO48752_1 | 6272-4B8A-84 | PO12615149669 | 100 | 285 | 367 | 440 | 5 | 2023-03-04 | 647.99 | 16.20 | 2023-02-20 | 1 | 598.44 | 1 | 647.99 | 1 | SO48752 | 2023-02-27 | 51.84 | 598.44 | 647.99 | |||
SO51110_14 | 2713-42DF-AC | PO11861142261 | 100 | 283 | 483 | 17 | 5 | 2023-09-01 | 360.00 | 9.00 | 2023-08-20 | 5 | 44.88 | 1 | 360.00 | 14 | SO51110 | 2023-08-27 | 28.80 | 224.40 | 72.00 | |||
SO71781_1 | 2FB9-4F05-82 | PO19401117806 | 19 | 291 | 604 | 173 | 6 | 2024-08-02 | 971.98 | 24.30 | 2024-07-21 | 3 | 343.65 | 1 | 971.98 | 1 | SO71781 | 2024-07-28 | 77.76 | 1030.95 | 323.99 | |||
SO47027_58 | 1A9C-4166-A7 | PO3480112515 | 100 | 283 | 424 | 436 | 4 | 2022-10-02 | 856.94 | 21.42 | 2022-09-20 | 4 | 158.53 | 1 | 856.94 | 58 | SO47027 | 2022-09-27 | 68.56 | 634.14 | 214.24 | |||
SO44092_3 | 6AE1-4759-B9 | PO15167143312 | 100 | 283 | 285 | 273 | 4 | 2021-11-02 | 714.32 | 17.86 | 2021-10-21 | 4 | 176.20 | 1 | 714.32 | 3 | SO44092 | 2021-10-28 | 57.15 | 704.80 | 178.58 | |||
SO58991_3 | D7E6-4630-81 | PO16530115443 | 100 | 282 | 565 | 601 | 1 | 2024-02-01 | 890.82 | 22.27 | 2024-01-20 | 2 | 461.44 | 1 | 890.82 | 3 | SO58991 | 2024-01-27 | 71.27 | 922.89 | 445.41 | |||
SO47384_24 | 8780-4D54-85 | PO14268113342 | 100 | 283 | 375 | 418 | 3 | 2022-11-02 | 1308.94 | 32.72 | 2022-10-21 | 1 | 1320.68 | 1 | 1308.94 | 24 | SO47384 | 2022-10-28 | 104.72 | 1320.68 | 1308.94 | |||
SO44544_6 | E01E-42FD-93 | PO3799116414 | 100 | 282 | 212 | 312 | 4 | 2022-01-02 | 20.19 | 0.50 | 2021-12-21 | 1 | 12.03 | 1 | 20.19 | 6 | SO44544 | 2021-12-28 | 1.61 | 12.03 | 20.19 | |||
SO47458_7 | 5D5A-47FC-AE | PO9686113121 | 100 | 282 | 358 | 457 | 4 | 2022-11-02 | 7376.75 | 184.42 | 2022-10-21 | 6 | 1105.81 | 1 | 7376.75 | 7 | SO47458 | 2022-10-28 | 590.14 | 6634.86 | 1229.46 | |||
SO44525_27 | E0C6-40AA-AD | PO11600189203 | 19 | 288 | 315 | 569 | 6 | 2022-01-02 | 3499.18 | 87.48 | 2021-12-21 | 4 | 884.71 | 1 | 3499.18 | 27 | SO44525 | 2021-12-28 | 279.93 | 3538.83 | 874.79 |
Generated 2024-09-19 21:26:11.748 UTC