[ROOT] dt FactResellerSale < WHERE DimEmployeeId EQ '282' > SKIP 2500 SHUFFLE SKIP 1000 SKIP 0 > < 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 |
---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
SO47444_13 | 4361-4317-91 | PO7946191257 | 100 | 282 | 221 | 438 | 1 | 2022-12-24 | 100.93 | 2.52 | 2022-12-12 | 5 | 13.88 | 1 | 100.93 | 13 | SO47444 | 2022-12-19 | 8.07 | 69.39 | 20.19 | |||
SO61178_2 | 7FDF-4C47-A4 | PO18009130007 | 100 | 282 | 390 | 510 | 4 | 2024-04-24 | 2016.88 | 50.42 | 2024-04-12 | 3 | 713.08 | 1 | 2016.88 | 2 | SO61178 | 2024-04-19 | 161.35 | 2139.24 | 672.29 | |||
SO47417_6 | 1CE8-4651-A9 | PO2697165938 | 100 | 282 | 469 | 187 | 4 | 2022-12-24 | 68.38 | 1.71 | 2022-12-12 | 3 | 15.67 | 1 | 68.38 | 6 | SO47417 | 2022-12-19 | 5.47 | 47.01 | 22.79 | |||
SO69453_1 | EE3C-40A0-9C | PO609154424 | 100 | 282 | 476 | 492 | 4 | 2024-08-23 | 251.96 | 6.30 | 2024-08-11 | 6 | 26.18 | 1 | 251.96 | 1 | SO69453 | 2024-08-18 | 20.16 | 157.06 | 41.99 | |||
SO46966_8 | 8FBD-4E87-82 | PO15631150454 | 100 | 282 | 354 | 43 | 1 | 2022-11-23 | 6214.26 | 155.36 | 2022-11-11 | 5 | 1117.86 | 1 | 6214.26 | 8 | SO46966 | 2022-11-18 | 497.14 | 5589.28 | 1242.85 | |||
SO50214_1 | 97D5-41D3-8F | PO15196120916 | 100 | 282 | 339 | 258 | 4 | 2023-08-23 | 1879.18 | 46.98 | 2023-08-11 | 4 | 486.71 | 1 | 1879.18 | 1 | SO50214 | 2023-08-18 | 150.33 | 1946.83 | 469.79 | |||
SO69503_2 | 559D-4568-82 | PO5771124379 | 100 | 282 | 376 | 79 | 3 | 2024-08-23 | 2932.02 | 73.30 | 2024-08-11 | 2 | 1554.95 | 1 | 2932.02 | 2 | SO69503 | 2024-08-18 | 234.56 | 3109.90 | 1466.01 | |||
SO57144_4 | 074E-478C-99 | PO3799111077 | 100 | 282 | 465 | 312 | 4 | 2024-02-23 | 44.08 | 1.10 | 2024-02-11 | 3 | 9.16 | 1 | 44.08 | 4 | SO57144 | 2024-02-18 | 3.53 | 27.48 | 14.69 | |||
SO65299_2 | 2FED-4E5A-B6 | PO3770146082 | 100 | 282 | 214 | 151 | 4 | 2024-06-23 | 20.99 | 0.52 | 2024-06-11 | 1 | 13.09 | 1 | 20.99 | 2 | SO65299 | 2024-06-18 | 1.68 | 13.09 | 20.99 | |||
SO49445_2 | 943B-43E1-AE | PO174113233 | 100 | 282 | 327 | 277 | 4 | 2023-06-23 | 1409.38 | 35.23 | 2023-06-11 | 3 | 486.71 | 1 | 1409.38 | 2 | SO49445 | 2023-06-18 | 112.75 | 1460.12 | 469.79 | |||
SO57042_12 | 52C4-4348-BC | PO15196150289 | 100 | 282 | 545 | 258 | 4 | 2024-02-23 | 24.29 | 0.61 | 2024-02-11 | 1 | 17.98 | 1 | 24.29 | 12 | SO57042 | 2024-02-18 | 1.94 | 17.98 | 24.29 | |||
SO53606_5 | 6A19-463C-B7 | PO5539128997 | 100 | 282 | 487 | 61 | 4 | 2023-12-24 | 131.98 | 3.30 | 2023-12-12 | 4 | 20.57 | 1 | 131.98 | 5 | SO53606 | 2023-12-19 | 10.56 | 82.27 | 32.99 | |||
SO49893_26 | 99ED-4EEC-9C | PO8787173621 | 100 | 282 | 373 | 523 | 3 | 2023-07-24 | 1308.94 | 32.72 | 2023-07-12 | 1 | 1320.68 | 1 | 1308.94 | 26 | SO49893 | 2023-07-19 | 104.72 | 1320.68 | 1308.94 | |||
SO67347_32 | 6E87-4127-80 | PO8787117055 | 100 | 282 | 234 | 523 | 3 | 2024-07-24 | 299.94 | 7.50 | 2024-07-12 | 10 | 38.49 | 1 | 299.94 | 32 | SO67347 | 2024-07-19 | 24.00 | 384.92 | 29.99 | |||
SO63155_2 | 000A-434D-BC | PO15196165529 | 100 | 282 | 390 | 258 | 4 | 2024-05-25 | 2016.88 | 50.42 | 2024-05-13 | 3 | 713.08 | 1 | 2016.88 | 2 | SO63155 | 2024-05-20 | 161.35 | 2139.24 | 672.29 | |||
SO71935_6 | 053A-47E3-AC | PO7946145876 | 100 | 282 | 482 | 2 | 438 | 1 | 1.36 | 2024-09-23 | 67.78 | 1.66 | 2024-09-11 | 13 | 3.36 | 1 | 66.43 | 6 | SO71935 | 2024-09-18 | 5.31 | 43.71 | 5.21 | 0.02 |
SO65261_5 | 5DAE-4844-AA | PO4785146431 | 100 | 282 | 568 | 223 | 3 | 2024-06-23 | 445.41 | 11.14 | 2024-06-11 | 1 | 461.44 | 1 | 445.41 | 5 | SO65261 | 2024-06-18 | 35.63 | 461.44 | 445.41 | |||
SO46058_7 | FA37-4F46-97 | PO12557123934 | 100 | 282 | 316 | 240 | 4 | 2022-08-23 | 2624.38 | 65.61 | 2022-08-11 | 3 | 884.71 | 1 | 2624.38 | 7 | SO46058 | 2022-08-18 | 209.95 | 2654.12 | 874.79 | |||
SO47355_39 | 6B7D-4E47-B5 | PO19343125466 | 100 | 282 | 456 | 4 | 24 | 4 | 104.99 | 2022-12-24 | 1049.86 | 23.62 | 2022-12-12 | 28 | 30.93 | 1 | 944.87 | 39 | SO47355 | 2022-12-19 | 75.59 | 866.14 | 37.50 | 0.10 |
SO71915_5 | F5D1-4554-94 | PO2349143275 | 100 | 282 | 547 | 6 | 4 | 2024-09-23 | 48.59 | 1.21 | 2024-09-11 | 1 | 35.96 | 1 | 48.59 | 5 | SO71915 | 2024-09-18 | 3.89 | 35.96 | 48.59 | |||
SO69422_41 | BF3A-4F54-82 | PO14500139823 | 100 | 282 | 533 | 650 | 1 | 2024-08-23 | 449.62 | 11.24 | 2024-08-11 | 3 | 136.79 | 1 | 449.62 | 41 | SO69422 | 2024-08-18 | 35.97 | 410.36 | 149.87 | |||
SO47039_14 | B548-493E-AE | PO5684166879 | 100 | 282 | 428 | 385 | 4 | 2022-11-23 | 1255.54 | 31.39 | 2022-11-11 | 6 | 185.82 | 1 | 1255.54 | 14 | SO47039 | 2022-11-18 | 100.44 | 1114.92 | 209.26 | |||
SO50226_35 | 75E5-4EFD-A7 | PO12499165634 | 100 | 282 | 385 | 78 | 4 | 2023-08-23 | 1200.53 | 30.01 | 2023-08-11 | 2 | 605.65 | 1 | 1200.53 | 35 | SO50226 | 2023-08-18 | 96.04 | 1211.30 | 600.26 | |||
SO50304_35 | 9338-4FCD-A5 | PO5771132420 | 100 | 282 | 323 | 79 | 3 | 2023-08-23 | 1879.18 | 46.98 | 2023-08-11 | 4 | 486.71 | 1 | 1879.18 | 35 | SO50304 | 2023-08-18 | 150.33 | 1946.83 | 469.79 | |||
SO50272_11 | E0A6-4CFA-90 | PO11745174916 | 100 | 282 | 460 | 97 | 4 | 2023-08-23 | 107.99 | 2.70 | 2023-08-11 | 2 | 37.12 | 1 | 107.99 | 11 | SO50272 | 2023-08-18 | 8.64 | 74.24 | 53.99 | |||
SO69532_47 | 27FB-4A86-85 | PO3799165791 | 100 | 282 | 309 | 312 | 4 | 2024-08-23 | 2456.10 | 61.40 | 2024-08-11 | 3 | 747.20 | 1 | 2456.10 | 47 | SO69532 | 2024-08-18 | 196.49 | 2241.60 | 818.70 | |||
SO46972_23 | 1A21-419F-8D | PO14500164221 | 100 | 282 | 365 | 650 | 1 | 2022-11-23 | 1943.98 | 48.60 | 2022-11-11 | 3 | 598.44 | 1 | 1943.98 | 23 | SO46972 | 2022-11-18 | 155.52 | 1795.31 | 647.99 | |||
SO67347_17 | 6E87-4127-80 | PO8787117055 | 100 | 282 | 580 | 523 | 3 | 2024-07-24 | 2041.19 | 51.03 | 2024-07-12 | 2 | 1082.51 | 1 | 2041.19 | 17 | SO67347 | 2024-07-19 | 163.30 | 2165.02 | 1020.59 | |||
SO47056_18 | 53BF-4950-9E | PO7656118289 | 100 | 282 | 422 | 403 | 4 | 2022-11-23 | 135.08 | 3.38 | 2022-11-11 | 2 | 49.98 | 1 | 135.08 | 18 | SO47056 | 2022-11-18 | 10.81 | 99.96 | 67.54 | |||
SO65299_3 | 2FED-4E5A-B6 | PO3770146082 | 100 | 282 | 306 | 151 | 4 | 2024-06-23 | 809.76 | 20.24 | 2024-06-11 | 1 | 739.04 | 1 | 809.76 | 3 | SO65299 | 2024-06-18 | 64.78 | 739.04 | 809.76 | |||
SO65176_11 | 2516-4DF3-BB | PO17052135284 | 100 | 282 | 493 | 420 | 4 | 2024-06-23 | 200.05 | 5.00 | 2024-06-11 | 1 | 199.85 | 1 | 200.05 | 11 | SO65176 | 2024-06-18 | 16.00 | 199.85 | 200.05 |
Generated 2024-11-10 06:28:00.631 UTC