[ROOT] dt FactResellerSale < WHERE DimEmployeeId EQ '285' > SKIP 2500 SHUFFLE < SKIP 95 > < 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 |
---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
SO47026_19 | 123B-481F-8F | PO3596190739 | 100 | 285 | 412 | 476 | 5 | 2022-11-23 | 540.39 | 13.51 | 2022-11-11 | 3 | 133.30 | 1 | 540.39 | 19 | SO47026 | 2022-11-18 | 43.23 | 399.89 | 180.13 | |||
SO69451_5 | EE16-4615-B7 | PO9918189570 | 100 | 285 | 499 | 260 | 5 | 2024-08-23 | 2409.38 | 60.23 | 2024-08-11 | 4 | 601.74 | 1 | 2409.38 | 5 | SO69451 | 2024-08-18 | 192.75 | 2406.97 | 602.35 | |||
SO61230_29 | B9F1-4FF8-B4 | PO12644163346 | 100 | 285 | 355 | 530 | 5 | 2024-04-24 | 4175.98 | 104.40 | 2024-04-12 | 3 | 1265.62 | 1 | 4175.98 | 29 | SO61230 | 2024-04-19 | 334.08 | 3796.86 | 1391.99 | |||
SO53474_25 | E5B6-4103-8D | PO15457187993 | 100 | 285 | 500 | 297 | 5 | 2023-12-24 | 602.35 | 15.06 | 2023-12-12 | 1 | 601.74 | 1 | 602.35 | 25 | SO53474 | 2023-12-19 | 48.19 | 601.74 | 602.35 | |||
SO58924_29 | D17F-4E31-90 | PO15457121920 | 100 | 285 | 556 | 297 | 5 | 2024-03-24 | 210.59 | 5.26 | 2024-03-12 | 2 | 77.92 | 1 | 210.59 | 29 | SO58924 | 2024-03-19 | 16.85 | 155.84 | 105.29 | |||
SO55234_15 | C6FC-46EE-88 | PO522140495 | 100 | 285 | 234 | 676 | 5 | 2024-01-23 | 29.99 | 0.75 | 2024-01-11 | 1 | 38.49 | 1 | 29.99 | 15 | SO55234 | 2024-01-18 | 2.40 | 38.49 | 29.99 | |||
SO46384_5 | 9F38-4366-91 | PO9541189751 | 100 | 285 | 218 | 279 | 5 | 2022-09-23 | 34.20 | 0.86 | 2022-09-11 | 6 | 3.40 | 1 | 34.20 | 5 | SO46384 | 2022-09-18 | 2.74 | 20.38 | 5.70 | |||
SO46673_20 | 578D-4F7B-A6 | PO9657163155 | 100 | 285 | 216 | 8 | 315 | 5 | 6.73 | 2022-10-23 | 67.29 | 1.51 | 2022-10-11 | 4 | 13.88 | 1 | 60.56 | 20 | SO46673 | 2022-10-18 | 4.84 | 55.51 | 16.82 | 0.10 |
SO69518_15 | 96AA-48F8-80 | PO5800191682 | 100 | 285 | 524 | 63 | 5 | 2024-08-23 | 475.29 | 11.88 | 2024-08-11 | 3 | 144.59 | 1 | 475.29 | 15 | SO69518 | 2024-08-18 | 38.02 | 433.78 | 158.43 | |||
SO50212_8 | BDB8-4FEA-94 | PO15051162285 | 100 | 285 | 458 | 207 | 5 | 2023-08-23 | 44.99 | 1.12 | 2023-08-11 | 1 | 30.93 | 1 | 44.99 | 8 | SO50212 | 2023-08-18 | 3.60 | 30.93 | 44.99 | |||
SO46943_5 | 6F43-4A10-80 | PO18560122957 | 100 | 285 | 323 | 531 | 5 | 2022-11-23 | 469.79 | 11.74 | 2022-11-11 | 1 | 486.71 | 1 | 469.79 | 5 | SO46943 | 2022-11-18 | 37.58 | 486.71 | 469.79 | |||
SO69510_2 | 20D6-41A2-8F | PO5568198481 | 100 | 285 | 477 | 422 | 5 | 2024-08-23 | 2.99 | 0.07 | 2024-08-11 | 1 | 1.87 | 1 | 2.99 | 2 | SO69510 | 2024-08-18 | 0.24 | 1.87 | 2.99 | |||
SO53595_2 | 4160-4910-92 | PO4089179449 | 100 | 285 | 475 | 368 | 5 | 2023-12-24 | 419.94 | 10.50 | 2023-12-12 | 10 | 26.18 | 1 | 419.94 | 2 | SO53595 | 2023-12-19 | 33.60 | 261.76 | 41.99 | |||
SO57162_9 | 83B5-43A6-BD | PO3596174424 | 100 | 285 | 551 | 476 | 5 | 2024-02-23 | 316.86 | 7.92 | 2024-02-11 | 2 | 144.59 | 1 | 316.86 | 9 | SO57162 | 2024-02-18 | 25.35 | 289.19 | 158.43 | |||
SO46971_16 | 5CEA-463B-A2 | PO15051144269 | 100 | 285 | 224 | 207 | 5 | 2022-11-23 | 15.56 | 0.39 | 2022-11-11 | 3 | 5.23 | 1 | 15.56 | 16 | SO46971 | 2022-11-18 | 1.24 | 15.69 | 5.19 | |||
SO50726_12 | A80B-408E-B3 | PO9599192861 | 100 | 285 | 337 | 170 | 5 | 2023-09-23 | 2818.76 | 70.47 | 2023-09-11 | 6 | 486.71 | 1 | 2818.76 | 12 | SO50726 | 2023-09-18 | 225.50 | 2920.24 | 469.79 | |||
SO53595_4 | 4160-4910-92 | PO4089179449 | 100 | 285 | 517 | 368 | 5 | 2023-12-24 | 189.50 | 4.74 | 2023-12-12 | 6 | 23.37 | 1 | 189.50 | 4 | SO53595 | 2023-12-19 | 15.16 | 140.23 | 31.58 | |||
SO49869_4 | A2BD-4A89-93 | PO9657193666 | 100 | 285 | 464 | 315 | 5 | 2023-07-24 | 28.26 | 0.71 | 2023-07-12 | 2 | 9.71 | 1 | 28.26 | 4 | SO49869 | 2023-07-19 | 2.26 | 19.43 | 14.13 | |||
SO55234_28 | C6FC-46EE-88 | PO522140495 | 100 | 285 | 214 | 676 | 5 | 2024-01-23 | 146.96 | 3.67 | 2024-01-11 | 7 | 13.09 | 1 | 146.96 | 28 | SO55234 | 2024-01-18 | 11.76 | 91.60 | 20.99 | |||
SO46943_1 | 6F43-4A10-80 | PO18560122957 | 100 | 285 | 263 | 531 | 5 | 2022-11-23 | 809.33 | 20.23 | 2022-11-11 | 4 | 187.16 | 1 | 809.33 | 1 | SO46943 | 2022-11-18 | 64.75 | 748.63 | 202.33 | |||
SO71839_14 | 8F89-4B1E-A8 | PO1537119063 | 100 | 285 | 496 | 611 | 5 | 2024-09-23 | 1204.69 | 30.12 | 2024-09-11 | 2 | 601.74 | 1 | 1204.69 | 14 | SO71839 | 2024-09-18 | 96.38 | 1203.49 | 602.35 | |||
SO46630_3 | F512-40F2-91 | PO12644161356 | 100 | 285 | 458 | 530 | 5 | 2022-10-23 | 224.97 | 5.62 | 2022-10-11 | 5 | 30.93 | 1 | 224.97 | 3 | SO46630 | 2022-10-18 | 18.00 | 154.67 | 44.99 | |||
SO58924_9 | D17F-4E31-90 | PO15457121920 | 100 | 285 | 552 | 297 | 5 | 2024-03-24 | 54.89 | 1.37 | 2024-03-12 | 1 | 40.62 | 1 | 54.89 | 9 | SO58924 | 2024-03-19 | 4.39 | 40.62 | 54.89 | |||
SO63245_14 | 1025-4AD1-A1 | PO5800120355 | 100 | 285 | 527 | 63 | 5 | 2024-05-25 | 158.43 | 3.96 | 2024-05-13 | 1 | 144.59 | 1 | 158.43 | 14 | SO63245 | 2024-05-20 | 12.67 | 144.59 | 158.43 | |||
SO46933_5 | 4D88-4B51-BF | PO19546168601 | 100 | 285 | 370 | 206 | 5 | 2022-11-23 | 4398.03 | 109.95 | 2022-11-11 | 3 | 1518.79 | 1 | 4398.03 | 5 | SO46933 | 2022-11-18 | 351.84 | 4556.36 | 1466.01 | |||
SO65220_6 | 6D87-4C24-98 | PO15457146892 | 100 | 285 | 555 | 297 | 5 | 2024-06-23 | 127.80 | 3.20 | 2024-06-11 | 2 | 47.29 | 1 | 127.80 | 6 | SO65220 | 2024-06-18 | 10.22 | 94.57 | 63.90 | |||
SO50756_17 | C414-447C-84 | PO9570119689 | 100 | 285 | 427 | 585 | 5 | 2023-09-23 | 209.26 | 5.23 | 2023-09-11 | 1 | 185.82 | 1 | 209.26 | 17 | SO50756 | 2023-09-18 | 16.74 | 185.82 | 209.26 | |||
SO71948_19 | DCEE-428D-87 | PO9599179297 | 100 | 285 | 581 | 170 | 5 | 2024-09-23 | 5102.97 | 127.57 | 2024-09-11 | 5 | 1082.51 | 1 | 5102.97 | 19 | SO71948 | 2024-09-18 | 408.24 | 5412.55 | 1020.59 | |||
SO49869_17 | A2BD-4A89-93 | PO9657193666 | 100 | 285 | 230 | 315 | 5 | 2023-07-24 | 86.52 | 2.16 | 2023-07-12 | 3 | 29.08 | 1 | 86.52 | 17 | SO49869 | 2023-07-19 | 6.92 | 87.24 | 28.84 | |||
SO49495_5 | A868-43CF-A4 | PO9570115481 | 100 | 285 | 399 | 585 | 5 | 2023-06-23 | 33.77 | 0.84 | 2023-06-11 | 1 | 24.99 | 1 | 33.77 | 5 | SO49495 | 2023-06-18 | 2.70 | 24.99 | 33.77 |
Generated 2024-11-10 11:54:47.127 UTC