[ROOT] dt FactResellerSale < WHERE DimEmployeeId EQ '287' > SKIP 2500 SHUFFLE < SKIP 1117 > < 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 |
---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
SO69527_3 | A6FE-49DA-BE | PO4843110434 | 100 | 287 | 240 | 257 | 4 | 2024-07-04 | 2576.70 | 64.42 | 2024-06-22 | 3 | 868.63 | 1 | 2576.70 | 3 | SO69527 | 2024-06-29 | 206.14 | 2605.90 | 858.90 | |||
SO67287_34 | 3F1F-44DB-96 | PO10730119334 | 100 | 287 | 584 | 491 | 4 | 2024-06-04 | 1619.97 | 40.50 | 2024-05-23 | 5 | 343.65 | 1 | 1619.97 | 34 | SO67287 | 2024-05-30 | 129.60 | 1718.25 | 323.99 | |||
SO46668_10 | 6711-47BE-BF | PO7859142972 | 100 | 287 | 257 | 221 | 4 | 2022-09-03 | 183.94 | 4.60 | 2022-08-22 | 1 | 170.14 | 1 | 183.94 | 10 | SO46668 | 2022-08-29 | 14.72 | 170.14 | 183.94 | |||
SO71896_19 | A37A-4B16-B0 | PO4640135042 | 100 | 287 | 309 | 648 | 4 | 2024-08-04 | 2456.10 | 61.40 | 2024-07-23 | 3 | 747.20 | 1 | 2456.10 | 19 | SO71896 | 2024-07-30 | 196.49 | 2241.60 | 818.70 | |||
SO45074_13 | 7225-40DF-B0 | PO7859191751 | 100 | 287 | 328 | 221 | 4 | 2022-03-06 | 838.92 | 20.97 | 2022-02-22 | 2 | 413.15 | 1 | 838.92 | 13 | SO45074 | 2022-03-01 | 67.11 | 826.29 | 419.46 | |||
SO45799_21 | 4DE8-4B9B-A1 | PO10730195041 | 100 | 287 | 332 | 491 | 4 | 2022-06-04 | 838.92 | 20.97 | 2022-05-23 | 2 | 413.15 | 1 | 838.92 | 21 | SO45799 | 2022-05-30 | 67.11 | 826.29 | 419.46 | |||
SO50672_23 | 1BE9-437C-8A | PO16472110144 | 100 | 287 | 221 | 239 | 4 | 2023-08-04 | 121.12 | 3.03 | 2023-07-23 | 6 | 13.88 | 1 | 121.12 | 23 | SO50672 | 2023-07-30 | 9.69 | 83.27 | 20.19 | |||
SO46380_18 | C4E3-4894-81 | PO7569183330 | 100 | 287 | 223 | 608 | 4 | 2022-08-04 | 20.75 | 0.52 | 2022-07-23 | 4 | 5.71 | 1 | 20.75 | 18 | SO46380 | 2022-07-30 | 1.66 | 22.82 | 5.19 | |||
SO57176_4 | 6881-42A1-B6 | PO7917176909 | 100 | 287 | 474 | 401 | 1 | 2024-01-04 | 125.98 | 3.15 | 2023-12-23 | 3 | 26.18 | 1 | 125.98 | 4 | SO57176 | 2023-12-30 | 10.08 | 78.53 | 41.99 | |||
SO50725_5 | 84DA-4CF7-8D | PO13717128221 | 100 | 287 | 265 | 473 | 4 | 2023-08-04 | 809.33 | 20.23 | 2023-07-23 | 4 | 187.16 | 1 | 809.33 | 5 | SO50725 | 2023-07-30 | 64.75 | 748.63 | 202.33 | |||
SO50678_8 | CAED-407A-BA | PO13543174640 | 100 | 287 | 427 | 293 | 1 | 2023-08-04 | 1046.28 | 26.16 | 2023-07-23 | 5 | 185.82 | 1 | 1046.28 | 8 | SO50678 | 2023-07-30 | 83.70 | 929.10 | 209.26 | |||
SO47034_6 | A5AA-46C3-92 | PO4843149248 | 100 | 287 | 343 | 257 | 4 | 2022-10-04 | 1879.18 | 46.98 | 2022-09-22 | 4 | 486.71 | 1 | 1879.18 | 6 | SO47034 | 2022-09-29 | 150.33 | 1946.83 | 469.79 | |||
SO50298_4 | 2A9C-4236-85 | PO4843196377 | 100 | 287 | 422 | 257 | 4 | 2023-07-04 | 67.54 | 1.69 | 2023-06-22 | 1 | 49.98 | 1 | 67.54 | 4 | SO50298 | 2023-06-29 | 5.40 | 49.98 | 67.54 | |||
SO47373_1 | 93C8-4034-BB | PO16269116347 | 100 | 287 | 254 | 624 | 4 | 2022-11-04 | 183.94 | 4.60 | 2022-10-23 | 1 | 170.14 | 1 | 183.94 | 1 | SO47373 | 2022-10-30 | 14.72 | 170.14 | 183.94 | |||
SO47369_35 | B6B6-442B-8B | PO16472118462 | 100 | 287 | 333 | 2 | 239 | 4 | 127.16 | 2022-11-04 | 6357.88 | 155.77 | 2022-10-23 | 14 | 486.71 | 1 | 6230.72 | 35 | SO47369 | 2022-10-30 | 498.46 | 6813.89 | 454.13 | 0.02 |
SO50661_21 | CE6E-45C9-A1 | PO19633184648 | 100 | 287 | 360 | 149 | 3 | 2023-08-04 | 4917.84 | 122.95 | 2023-07-23 | 4 | 1105.81 | 1 | 4917.84 | 21 | SO50661 | 2023-07-30 | 393.43 | 4423.24 | 1229.46 | |||
SO58946_1 | F9DD-426F-9A | PO12470155874 | 100 | 287 | 548 | 672 | 1 | 2024-02-03 | 48.59 | 1.21 | 2024-01-22 | 1 | 35.96 | 1 | 48.59 | 1 | SO58946 | 2024-01-29 | 3.89 | 35.96 | 48.59 | |||
SO46668_28 | 6711-47BE-BF | PO7859142972 | 100 | 287 | 230 | 221 | 4 | 2022-09-03 | 230.72 | 5.77 | 2022-08-22 | 8 | 29.08 | 1 | 230.72 | 28 | SO46668 | 2022-08-29 | 18.46 | 232.65 | 28.84 | |||
SO45813_14 | 36A5-446C-96 | PO7859120230 | 100 | 287 | 272 | 221 | 4 | 2022-06-04 | 367.88 | 9.20 | 2022-05-23 | 2 | 181.49 | 1 | 367.88 | 14 | SO45813 | 2022-05-30 | 29.43 | 362.97 | 183.94 | |||
SO47441_31 | 2582-4E47-98 | PO7569166535 | 100 | 287 | 428 | 608 | 4 | 2022-11-04 | 1674.05 | 41.85 | 2022-10-23 | 8 | 185.82 | 1 | 1674.05 | 31 | SO47441 | 2022-10-30 | 133.92 | 1486.55 | 209.26 | |||
SO69466_1 | 8B97-4CC6-8A | PO2523169620 | 100 | 287 | 374 | 167 | 4 | 2024-07-04 | 4398.03 | 109.95 | 2024-06-22 | 3 | 1554.95 | 1 | 4398.03 | 1 | SO69466 | 2024-06-29 | 351.84 | 4664.84 | 1466.01 | |||
SO46638_47 | 9659-44CE-A2 | PO10817110834 | 100 | 287 | 254 | 203 | 4 | 2022-09-03 | 367.88 | 9.20 | 2022-08-22 | 2 | 170.14 | 1 | 367.88 | 47 | SO46638 | 2022-08-29 | 29.43 | 340.29 | 183.94 | |||
SO69466_28 | 8B97-4CC6-8A | PO2523169620 | 100 | 287 | 606 | 167 | 4 | 2024-07-04 | 1619.97 | 40.50 | 2024-06-22 | 5 | 343.65 | 1 | 1619.97 | 28 | SO69466 | 2024-06-29 | 129.60 | 1718.25 | 323.99 | |||
SO45798_15 | 3FA4-4459-BD | PO10817199969 | 100 | 287 | 232 | 203 | 4 | 2022-06-04 | 28.84 | 0.72 | 2022-05-23 | 1 | 31.72 | 1 | 28.84 | 15 | SO45798 | 2022-05-30 | 2.31 | 31.72 | 28.84 | |||
SO50266_6 | 5A1A-4C41-B9 | PO15921150902 | 100 | 287 | 422 | 77 | 4 | 2023-07-04 | 67.54 | 1.69 | 2023-06-22 | 1 | 49.98 | 1 | 67.54 | 6 | SO50266 | 2023-06-29 | 5.40 | 49.98 | 67.54 | |||
SO67305_46 | CBB5-42BF-9E | PO16298111473 | 100 | 287 | 463 | 599 | 4 | 2024-06-04 | 88.16 | 2.20 | 2024-05-23 | 6 | 9.16 | 1 | 88.16 | 46 | SO67305 | 2024-05-30 | 7.05 | 54.96 | 14.69 | |||
SO47352_15 | 9DF5-4A88-9C | PO19633111392 | 100 | 287 | 409 | 149 | 3 | 2022-11-04 | 627.77 | 15.69 | 2022-10-23 | 3 | 185.82 | 1 | 627.77 | 15 | SO47352 | 2022-10-30 | 50.22 | 557.46 | 209.26 | |||
SO47369_49 | B6B6-442B-8B | PO16472118462 | 100 | 287 | 254 | 239 | 4 | 2022-11-04 | 919.69 | 22.99 | 2022-10-23 | 5 | 170.14 | 1 | 919.69 | 49 | SO47369 | 2022-10-30 | 73.58 | 850.71 | 183.94 | |||
SO67325_7 | 981F-41CE-8A | PO7859144943 | 100 | 287 | 374 | 221 | 4 | 2024-06-04 | 2932.02 | 73.30 | 2024-05-23 | 2 | 1554.95 | 1 | 2932.02 | 7 | SO67325 | 2024-05-30 | 234.56 | 3109.90 | 1466.01 | |||
SO46668_45 | 6711-47BE-BF | PO7859142972 | 100 | 287 | 453 | 2 | 221 | 4 | 7.65 | 2022-09-03 | 382.74 | 9.38 | 2022-08-22 | 11 | 24.75 | 1 | 375.08 | 45 | SO46668 | 2022-08-29 | 30.01 | 272.20 | 34.79 | 0.02 |
SO69552_4 | 542B-4AC0-BA | PO7917166419 | 100 | 287 | 483 | 401 | 1 | 2024-07-04 | 216.00 | 5.40 | 2024-06-22 | 3 | 44.88 | 1 | 216.00 | 4 | SO69552 | 2024-06-29 | 17.28 | 134.64 | 72.00 |
Generated 2024-09-21 07:57:07.940 UTC