[ROOT] dt FactResellerSale < WHERE DimSalesTerritoryId EQ '3' > SHUFFLE < SKIP 2298 > < TAKE 30 >
30 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 |
---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
SO51828_39 | 3204-40B6-A5 | PO5771194719 | 100 | 282 | 482 | 3 | 79 | 3 | 4.70 | 2023-10-03 | 93.95 | 2.23 | 2023-09-21 | 19 | 3.36 | 1 | 89.25 | 39 | SO51828 | 2023-09-28 | 7.14 | 63.88 | 4.94 | 0.05 |
SO53499_33 | A47F-48AD-83 | PO12354126576 | 100 | 283 | 225 | 197 | 3 | 2023-11-03 | 21.58 | 0.54 | 2023-10-22 | 4 | 6.92 | 1 | 21.58 | 33 | SO53499 | 2023-10-29 | 1.73 | 27.69 | 5.39 | |||
SO53526_26 | 6EEB-4506-89 | PO1624140151 | 100 | 281 | 583 | 579 | 3 | 2023-11-03 | 1020.59 | 25.51 | 2023-10-22 | 1 | 1082.51 | 1 | 1020.59 | 26 | SO53526 | 2023-10-29 | 81.65 | 1082.51 | 1020.59 | |||
SO51140_39 | 0583-4C94-BA | PO6467148715 | 100 | 283 | 225 | 3 | 660 | 3 | 4.45 | 2023-09-02 | 89.00 | 2.11 | 2023-08-21 | 18 | 6.92 | 1 | 84.55 | 39 | SO51140 | 2023-08-28 | 6.76 | 124.60 | 4.94 | 0.05 |
SO48360_4 | 5091-4B56-A9 | PO3103179096 | 100 | 283 | 422 | 147 | 3 | 2023-02-02 | 270.16 | 6.75 | 2023-01-21 | 4 | 49.98 | 1 | 270.16 | 4 | SO48360 | 2023-01-28 | 21.61 | 199.92 | 67.54 | |||
SO45795_13 | EA72-4C1D-BB | PO12412125626 | 100 | 283 | 338 | 670 | 3 | 2022-06-03 | 838.92 | 20.97 | 2022-05-22 | 2 | 413.15 | 1 | 838.92 | 13 | SO45795 | 2022-05-29 | 67.11 | 826.29 | 419.46 | |||
SO45538_10 | 0310-4DCB-B5 | PO14268192541 | 100 | 283 | 326 | 418 | 3 | 2022-05-03 | 419.46 | 10.49 | 2022-04-21 | 1 | 413.15 | 1 | 419.46 | 10 | SO45538 | 2022-04-28 | 33.56 | 413.15 | 419.46 | |||
SO67262_6 | 5BD7-455E-9A | PO19314114641 | 100 | 281 | 583 | 622 | 3 | 2024-06-03 | 2041.19 | 51.03 | 2024-05-22 | 2 | 1082.51 | 1 | 2041.19 | 6 | SO67262 | 2024-05-29 | 163.30 | 2165.02 | 1020.59 | |||
SO46358_3 | 3BC7-40F4-99 | PO1624111969 | 100 | 283 | 310 | 579 | 3 | 2022-08-03 | 4293.92 | 107.35 | 2022-07-22 | 2 | 2171.29 | 1 | 4293.92 | 3 | SO46358 | 2022-07-29 | 343.51 | 4342.59 | 2146.96 | |||
SO59058_30 | 98B6-49AA-A5 | PO7047118388 | 100 | 281 | 552 | 544 | 3 | 2024-02-02 | 109.79 | 2.74 | 2024-01-21 | 2 | 40.62 | 1 | 109.79 | 30 | SO59058 | 2024-01-28 | 8.78 | 81.24 | 54.89 | |||
SO49837_10 | C136-4536-9D | PO12412160791 | 100 | 281 | 377 | 670 | 3 | 2023-06-03 | 7853.63 | 196.34 | 2023-05-22 | 6 | 1320.68 | 1 | 7853.63 | 10 | SO49837 | 2023-05-29 | 628.29 | 7924.10 | 1308.94 | |||
SO49465_17 | DE18-49CF-B2 | PO1624120205 | 100 | 281 | 323 | 579 | 3 | 2023-05-03 | 939.59 | 23.49 | 2023-04-21 | 2 | 486.71 | 1 | 939.59 | 17 | SO49465 | 2023-04-28 | 75.17 | 973.41 | 469.79 | |||
SO50696_36 | C32F-4FEE-A3 | PO1624119214 | 100 | 281 | 385 | 579 | 3 | 2023-08-03 | 1800.79 | 45.02 | 2023-07-22 | 3 | 605.65 | 1 | 1800.79 | 36 | SO50696 | 2023-07-29 | 144.06 | 1816.95 | 600.26 | |||
SO61189_20 | 1A25-4A8C-8B | PO12412183085 | 100 | 281 | 372 | 670 | 3 | 2024-03-04 | 2932.02 | 73.30 | 2024-02-21 | 2 | 1554.95 | 1 | 2932.02 | 20 | SO61189 | 2024-02-28 | 234.56 | 3109.90 | 1466.01 | |||
SO57015_28 | 8C70-4374-B5 | PO19923181245 | 100 | 283 | 558 | 18 | 3 | 2024-01-03 | 485.99 | 12.15 | 2023-12-22 | 2 | 179.82 | 1 | 485.99 | 28 | SO57015 | 2023-12-29 | 38.88 | 359.63 | 242.99 | |||
SO63257_7 | B81B-4565-85 | PO5771197507 | 100 | 282 | 380 | 79 | 3 | 2024-04-04 | 2932.02 | 73.30 | 2024-03-23 | 2 | 1554.95 | 1 | 2932.02 | 7 | SO63257 | 2024-03-30 | 234.56 | 3109.90 | 1466.01 | |||
SO69393_15 | 3E84-4AA4-B6 | PO19923114948 | 100 | 283 | 359 | 18 | 3 | 2024-07-03 | 6884.97 | 172.12 | 2024-06-21 | 5 | 1251.98 | 1 | 6884.97 | 15 | SO69393 | 2024-06-28 | 550.80 | 6259.91 | 1376.99 | |||
SO44079_24 | A180-4128-A7 | PO19488118734 | 100 | 283 | 322 | 57 | 3 | 2021-11-03 | 2097.29 | 52.43 | 2021-10-22 | 5 | 413.15 | 1 | 2097.29 | 24 | SO44079 | 2021-10-29 | 167.78 | 2065.73 | 419.46 | |||
SO47394_27 | 7FC9-4002-83 | PO12354143510 | 100 | 281 | 410 | 197 | 3 | 2022-11-03 | 36.45 | 0.91 | 2022-10-22 | 1 | 26.97 | 1 | 36.45 | 27 | SO47394 | 2022-10-29 | 2.92 | 26.97 | 36.45 | |||
SO65221_27 | 0AC4-40AE-B6 | PO15341198427 | 100 | 281 | 592 | 327 | 3 | 2024-05-03 | 677.99 | 16.95 | 2024-04-21 | 2 | 308.22 | 1 | 677.99 | 27 | SO65221 | 2024-04-28 | 54.24 | 616.44 | 338.99 | |||
SO57148_6 | AE28-4B3B-9D | PO3074151668 | 100 | 281 | 591 | 237 | 3 | 2024-01-03 | 677.99 | 16.95 | 2023-12-22 | 2 | 308.22 | 1 | 677.99 | 6 | SO57148 | 2023-12-29 | 54.24 | 616.44 | 338.99 | |||
SO57186_51 | EF93-4946-97 | PO8845159326 | 100 | 282 | 491 | 546 | 3 | 2024-01-03 | 64.79 | 1.62 | 2023-12-22 | 2 | 41.57 | 1 | 64.79 | 51 | SO57186 | 2023-12-29 | 5.18 | 83.14 | 32.39 | |||
SO69503_27 | 559D-4568-82 | PO5771124379 | 100 | 282 | 580 | 79 | 3 | 2024-07-03 | 5102.97 | 127.57 | 2024-06-21 | 5 | 1082.51 | 1 | 5102.97 | 27 | SO69503 | 2024-06-28 | 408.24 | 5412.55 | 1020.59 | |||
SO69561_20 | BBC0-4CA4-A2 | PO8845186382 | 100 | 282 | 595 | 16 | 546 | 3 | 271.20 | 2024-07-03 | 677.99 | 10.17 | 2024-06-21 | 6 | 308.22 | 1 | 406.79 | 20 | SO69561 | 2024-06-28 | 32.54 | 1849.31 | 113.00 | 0.40 |
SO46067_4 | 2767-4728-8E | PO10440122607 | 100 | 283 | 235 | 623 | 3 | 2022-07-03 | 201.88 | 5.05 | 2022-06-21 | 7 | 31.72 | 1 | 201.88 | 4 | SO46067 | 2022-06-28 | 16.15 | 222.07 | 28.84 | |||
SO47724_4 | FDA2-4CD7-92 | PO8787160870 | 100 | 282 | 265 | 523 | 3 | 2022-12-03 | 202.33 | 5.06 | 2022-11-21 | 1 | 187.16 | 1 | 202.33 | 4 | SO47724 | 2022-11-28 | 16.19 | 187.16 | 202.33 | |||
SO51691_6 | 8F72-4342-A4 | PO19923122474 | 100 | 283 | 559 | 18 | 3 | 2023-10-03 | 72.86 | 1.82 | 2023-09-21 | 6 | 8.99 | 1 | 72.86 | 6 | SO51691 | 2023-09-28 | 5.83 | 53.92 | 12.14 | |||
SO50221_1 | EAD6-4841-B9 | PO13572116484 | 100 | 287 | 273 | 527 | 3 | 2023-07-03 | 809.33 | 20.23 | 2023-06-21 | 4 | 187.16 | 1 | 809.33 | 1 | SO50221 | 2023-06-28 | 64.75 | 748.63 | 202.33 | |||
SO58944_42 | 90AC-4F21-90 | PO12354164168 | 100 | 283 | 591 | 197 | 3 | 2024-02-02 | 338.99 | 8.47 | 2024-01-21 | 1 | 308.22 | 1 | 338.99 | 42 | SO58944 | 2024-01-28 | 27.12 | 308.22 | 338.99 | |||
SO71803_21 | 9C57-4821-9B | PO15341174104 | 100 | 281 | 591 | 16 | 327 | 3 | 45.20 | 2024-08-03 | 113.00 | 1.70 | 2024-07-22 | 1 | 308.22 | 1 | 67.80 | 21 | SO71803 | 2024-07-29 | 5.42 | 308.22 | 113.00 | 0.40 |
Generated 2024-09-20 11:25:55.149 UTC