[ROOT] dt FactResellerSale < WHERE DimSalesTerritoryId EQ '3' > SHUFFLE < SKIP 219 > < 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 |
---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
SO58928_21 | 6C1A-4E73-97 | PO15341119997 | 100 | 281 | 487 | 327 | 3 | 2024-03-26 | 296.95 | 7.42 | 2024-03-14 | 9 | 20.57 | 1 | 296.95 | 21 | SO58928 | 2024-03-21 | 23.76 | 185.10 | 32.99 | |||
SO48731_3 | 2DDD-453B-85 | PO19314141866 | 100 | 281 | 327 | 622 | 3 | 2023-04-27 | 939.59 | 23.49 | 2023-04-15 | 2 | 486.71 | 1 | 939.59 | 3 | SO48731 | 2023-04-22 | 75.17 | 973.41 | 469.79 | |||
SO58944_33 | 90AC-4F21-90 | PO12354164168 | 100 | 283 | 355 | 197 | 3 | 2024-03-26 | 2783.99 | 69.60 | 2024-03-14 | 2 | 1265.62 | 1 | 2783.99 | 33 | SO58944 | 2024-03-21 | 222.72 | 2531.24 | 1391.99 | |||
SO51822_49 | EEEE-45C1-87 | PO8845178563 | 100 | 282 | 590 | 2 | 546 | 3 | 98.19 | 2023-11-25 | 4909.35 | 120.28 | 2023-11-13 | 11 | 419.78 | 1 | 4811.16 | 49 | SO51822 | 2023-11-20 | 384.89 | 4617.56 | 446.30 | 0.02 |
SO46066_9 | ADF8-444D-9C | PO10759115463 | 100 | 283 | 307 | 346 | 3 | 2022-08-25 | 1445.19 | 36.13 | 2022-08-13 | 2 | 623.84 | 1 | 1445.19 | 9 | SO46066 | 2022-08-20 | 115.62 | 1247.68 | 722.59 | |||
SO47394_1 | 7FC9-4002-83 | PO12354143510 | 100 | 281 | 460 | 197 | 3 | 2022-12-26 | 215.98 | 5.40 | 2022-12-14 | 4 | 37.12 | 1 | 215.98 | 1 | SO47394 | 2022-12-21 | 17.28 | 148.48 | 53.99 | |||
SO50712_32 | 9AAC-4C4A-AB | PO14268119350 | 100 | 281 | 453 | 418 | 3 | 2023-09-25 | 215.96 | 5.40 | 2023-09-13 | 6 | 24.75 | 1 | 215.96 | 32 | SO50712 | 2023-09-20 | 17.28 | 148.48 | 35.99 | |||
SO48089_17 | EACD-4BB9-97 | PO8845169807 | 100 | 282 | 236 | 546 | 3 | 2023-02-25 | 57.68 | 1.44 | 2023-02-13 | 2 | 29.08 | 1 | 57.68 | 17 | SO48089 | 2023-02-20 | 4.61 | 58.16 | 28.84 | |||
SO47659_3 | 8639-4639-AA | PO19314173599 | 100 | 283 | 458 | 622 | 3 | 2023-01-25 | 224.97 | 5.62 | 2023-01-13 | 5 | 30.93 | 1 | 224.97 | 3 | SO47659 | 2023-01-20 | 18.00 | 154.67 | 44.99 | |||
SO50304_35 | 9338-4FCD-A5 | PO5771132420 | 100 | 282 | 323 | 79 | 3 | 2023-08-25 | 1879.18 | 46.98 | 2023-08-13 | 4 | 486.71 | 1 | 1879.18 | 35 | SO50304 | 2023-08-20 | 150.33 | 1946.83 | 469.79 | |||
SO53471_8 | 7B7E-4C32-B2 | PO16994189676 | 100 | 283 | 520 | 306 | 3 | 2023-12-26 | 31.58 | 0.79 | 2023-12-14 | 1 | 23.37 | 1 | 31.58 | 8 | SO53471 | 2023-12-21 | 2.53 | 23.37 | 31.58 | |||
SO57121_23 | A796-4C1D-A6 | PO5771187733 | 100 | 282 | 477 | 79 | 3 | 2024-02-25 | 8.98 | 0.22 | 2024-02-13 | 3 | 1.87 | 1 | 8.98 | 23 | SO57121 | 2024-02-20 | 0.72 | 5.60 | 2.99 | |||
SO71907_8 | D656-4305-83 | PO4118115030 | 100 | 281 | 492 | 454 | 3 | 2024-09-25 | 2409.38 | 60.23 | 2024-09-13 | 4 | 601.74 | 1 | 2409.38 | 8 | SO71907 | 2024-09-20 | 192.75 | 2406.97 | 602.35 | |||
SO48065_5 | 1B78-4DE6-BC | PO5771120852 | 100 | 282 | 263 | 79 | 3 | 2023-02-25 | 1416.32 | 35.41 | 2023-02-13 | 7 | 187.16 | 1 | 1416.32 | 5 | SO48065 | 2023-02-20 | 113.31 | 1310.10 | 202.33 | |||
SO44758_23 | 28CF-4701-9C | PO14268184289 | 100 | 283 | 223 | 418 | 3 | 2022-03-27 | 10.37 | 0.26 | 2022-03-15 | 2 | 5.71 | 1 | 10.37 | 23 | SO44758 | 2022-03-22 | 0.83 | 11.41 | 5.19 | |||
SO45520_6 | 86A2-4B9B-8D | PO19488171523 | 100 | 283 | 324 | 57 | 3 | 2022-06-25 | 838.92 | 20.97 | 2022-06-13 | 2 | 413.15 | 1 | 838.92 | 6 | SO45520 | 2022-06-20 | 67.11 | 826.29 | 419.46 | |||
SO71803_31 | 9C57-4821-9B | PO15341174104 | 100 | 281 | 361 | 327 | 3 | 2024-09-25 | 5507.98 | 137.70 | 2024-09-13 | 4 | 1251.98 | 1 | 5507.98 | 31 | SO71803 | 2024-09-20 | 440.64 | 5007.93 | 1376.99 | |||
SO48065_21 | 1B78-4DE6-BC | PO5771120852 | 100 | 282 | 385 | 79 | 3 | 2023-02-25 | 4201.84 | 105.05 | 2023-02-13 | 7 | 605.65 | 1 | 4201.84 | 21 | SO48065 | 2023-02-20 | 336.15 | 4239.54 | 600.26 | |||
SO55238_14 | 3BEA-42A3-9A | PO19314197881 | 100 | 281 | 471 | 622 | 3 | 2024-01-25 | 228.60 | 5.72 | 2024-01-13 | 6 | 23.75 | 1 | 228.60 | 14 | SO55238 | 2024-01-20 | 18.29 | 142.49 | 38.10 | |||
SO44550_17 | 0BDF-4CBE-88 | PO5191121845 | 100 | 283 | 320 | 364 | 3 | 2022-02-25 | 419.46 | 10.49 | 2022-02-13 | 1 | 413.15 | 1 | 419.46 | 17 | SO44550 | 2022-02-20 | 33.56 | 413.15 | 419.46 | |||
SO46662_31 | 07F7-472E-AC | PO6467187386 | 100 | 281 | 448 | 660 | 3 | 2022-10-25 | 23.99 | 0.60 | 2022-10-13 | 2 | 8.25 | 1 | 23.99 | 31 | SO46662 | 2022-10-20 | 1.92 | 16.49 | 11.99 | |||
SO46664_17 | B900-4D0D-AF | PO6235159004 | 100 | 281 | 323 | 431 | 3 | 2022-10-25 | 2348.97 | 58.72 | 2022-10-13 | 5 | 486.71 | 1 | 2348.97 | 17 | SO46664 | 2022-10-20 | 187.92 | 2433.53 | 469.79 | |||
SO65195_17 | 11FD-44C6-95 | PO12354156814 | 100 | 283 | 595 | 197 | 3 | 2024-06-25 | 677.99 | 16.95 | 2024-06-13 | 2 | 308.22 | 1 | 677.99 | 17 | SO65195 | 2024-06-20 | 54.24 | 616.44 | 338.99 | |||
SO44758_10 | 28CF-4701-9C | PO14268184289 | 100 | 283 | 270 | 418 | 3 | 2022-03-27 | 735.75 | 18.39 | 2022-03-15 | 4 | 181.49 | 1 | 735.75 | 10 | SO44758 | 2022-03-22 | 58.86 | 725.94 | 183.94 | |||
SO51720_29 | E39F-4680-AC | PO15370128892 | 100 | 281 | 531 | 381 | 3 | 2023-11-25 | 149.87 | 3.75 | 2023-11-13 | 1 | 136.79 | 1 | 149.87 | 29 | SO51720 | 2023-11-20 | 11.99 | 136.79 | 149.87 | |||
SO45326_4 | 8C75-4F67-95 | PO5191186622 | 100 | 283 | 315 | 364 | 3 | 2022-05-28 | 874.79 | 21.87 | 2022-05-16 | 1 | 884.71 | 1 | 874.79 | 4 | SO45326 | 2022-05-23 | 69.98 | 884.71 | 874.79 | |||
SO48089_13 | EACD-4BB9-97 | PO8845169807 | 100 | 282 | 352 | 546 | 3 | 2023-02-25 | 7457.11 | 186.43 | 2023-02-13 | 6 | 1117.86 | 1 | 7457.11 | 13 | SO48089 | 2023-02-20 | 596.57 | 6707.14 | 1242.85 | |||
SO48065_28 | 1B78-4DE6-BC | PO5771120852 | 100 | 282 | 368 | 79 | 3 | 2023-02-25 | 2932.02 | 73.30 | 2023-02-13 | 2 | 1518.79 | 1 | 2932.02 | 28 | SO48065 | 2023-02-20 | 234.56 | 3037.57 | 1466.01 | |||
SO69503_8 | 559D-4568-82 | PO5771124379 | 100 | 282 | 487 | 79 | 3 | 2024-08-25 | 98.98 | 2.47 | 2024-08-13 | 3 | 20.57 | 1 | 98.98 | 8 | SO69503 | 2024-08-20 | 7.92 | 61.70 | 32.99 | |||
SO50189_13 | 6D35-41E2-A6 | PO19923188059 | 100 | 283 | 294 | 18 | 3 | 2023-08-25 | 1488.55 | 37.21 | 2023-08-13 | 2 | 660.91 | 1 | 1488.55 | 13 | SO50189 | 2023-08-20 | 119.08 | 1321.83 | 744.27 | |||
SO51716_4 | 232B-4C4C-97 | PO15283150425 | 100 | 281 | 576 | 363 | 3 | 2023-11-25 | 10013.09 | 250.33 | 2023-11-13 | 7 | 1481.94 | 1 | 10013.09 | 4 | SO51716 | 2023-11-20 | 801.05 | 10373.57 | 1430.44 |
Generated 2024-11-13 00:02:29.306 UTC