[ROOT] dt FactResellerSale < WHERE DimEmployeeId EQ '285' > < SKIP 281 > < 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 |
---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
SO43684_4 | 8C01-4CC0-A9 | PO3393188842 | 100 | 285 | 319 | 549 | 5 | 2021-09-17 | 1749.59 | 43.74 | 2021-09-05 | 2 | 884.71 | 1 | 1749.59 | 4 | SO43684 | 2021-09-12 | 139.97 | 1769.42 | 874.79 | |||
SO47693_16 | 3962-4A1A-93 | PO522165713 | 100 | 285 | 419 | 676 | 5 | 2022-12-18 | 52.65 | 1.32 | 2022-12-06 | 1 | 38.96 | 1 | 52.65 | 16 | SO47693 | 2022-12-13 | 4.21 | 38.96 | 52.65 | |||
SO51108_37 | 8650-4A20-B1 | PO12644151814 | 100 | 285 | 533 | 530 | 5 | 2023-09-17 | 149.87 | 3.75 | 2023-09-05 | 1 | 136.79 | 1 | 149.87 | 37 | SO51108 | 2023-09-12 | 11.99 | 136.79 | 149.87 | |||
SO59071_6 | EFC3-4244-A6 | PO9599176835 | 100 | 285 | 545 | 170 | 5 | 2024-02-17 | 72.88 | 1.82 | 2024-02-05 | 3 | 17.98 | 1 | 72.88 | 6 | SO59071 | 2024-02-12 | 5.83 | 53.93 | 24.29 | |||
SO43684_5 | 8C01-4CC0-A9 | PO3393188842 | 100 | 285 | 342 | 549 | 5 | 2021-09-17 | 419.46 | 10.49 | 2021-09-05 | 1 | 413.15 | 1 | 419.46 | 5 | SO43684 | 2021-09-12 | 33.56 | 413.15 | 419.46 | |||
SO47693_17 | 3962-4A1A-93 | PO522165713 | 100 | 285 | 420 | 676 | 5 | 2022-12-18 | 141.62 | 3.54 | 2022-12-06 | 1 | 104.80 | 1 | 141.62 | 17 | SO47693 | 2022-12-13 | 11.33 | 104.80 | 141.62 | |||
SO51108_38 | 8650-4A20-B1 | PO12644151814 | 100 | 285 | 593 | 530 | 5 | 2023-09-17 | 677.99 | 16.95 | 2023-09-05 | 2 | 308.22 | 1 | 677.99 | 38 | SO51108 | 2023-09-12 | 54.24 | 616.44 | 338.99 | |||
SO59071_7 | EFC3-4244-A6 | PO9599176835 | 100 | 285 | 604 | 170 | 5 | 2024-02-17 | 971.98 | 24.30 | 2024-02-05 | 3 | 343.65 | 1 | 971.98 | 7 | SO59071 | 2024-02-12 | 77.76 | 1030.95 | 323.99 | |||
SO43684_6 | 8C01-4CC0-A9 | PO3393188842 | 100 | 285 | 328 | 549 | 5 | 2021-09-17 | 419.46 | 10.49 | 2021-09-05 | 1 | 413.15 | 1 | 419.46 | 6 | SO43684 | 2021-09-12 | 33.56 | 413.15 | 419.46 | |||
SO47693_18 | 3962-4A1A-93 | PO522165713 | 100 | 285 | 421 | 676 | 5 | 2022-12-18 | 196.33 | 4.91 | 2022-12-06 | 1 | 145.28 | 1 | 196.33 | 18 | SO47693 | 2022-12-13 | 15.71 | 145.28 | 196.33 | |||
SO51108_39 | 8650-4A20-B1 | PO12644151814 | 100 | 285 | 516 | 530 | 5 | 2023-09-17 | 23.48 | 0.59 | 2023-09-05 | 1 | 17.38 | 1 | 23.48 | 39 | SO51108 | 2023-09-12 | 1.88 | 17.38 | 23.48 | |||
SO59071_8 | EFC3-4244-A6 | PO9599176835 | 100 | 285 | 434 | 170 | 5 | 2024-02-17 | 713.80 | 17.84 | 2024-02-05 | 2 | 360.94 | 1 | 713.80 | 8 | SO59071 | 2024-02-12 | 57.10 | 721.89 | 356.90 | |||
SO43685_1 | C519-4AB3-88 | PO4176124783 | 100 | 285 | 332 | 458 | 5 | 2021-09-17 | 1258.38 | 31.46 | 2021-09-05 | 3 | 413.15 | 1 | 1258.38 | 1 | SO43685 | 2021-09-12 | 100.67 | 1239.44 | 419.46 | |||
SO47693_19 | 3962-4A1A-93 | PO522165713 | 100 | 285 | 427 | 676 | 5 | 2022-12-18 | 418.51 | 10.46 | 2022-12-06 | 2 | 185.82 | 1 | 418.51 | 19 | SO47693 | 2022-12-13 | 33.48 | 371.64 | 209.26 | |||
SO51108_40 | 8650-4A20-B1 | PO12644151814 | 100 | 285 | 491 | 2 | 530 | 5 | 8.14 | 2023-09-17 | 407.08 | 9.97 | 2023-09-05 | 13 | 41.57 | 1 | 398.94 | 40 | SO51108 | 2023-09-12 | 31.92 | 540.44 | 31.31 | 0.02 |
SO59071_9 | EFC3-4244-A6 | PO9599176835 | 100 | 285 | 584 | 170 | 5 | 2024-02-17 | 647.99 | 16.20 | 2024-02-05 | 2 | 343.65 | 1 | 647.99 | 9 | SO59071 | 2024-02-12 | 51.84 | 687.30 | 323.99 | |||
SO43685_2 | C519-4AB3-88 | PO4176124783 | 100 | 285 | 328 | 458 | 5 | 2021-09-17 | 419.46 | 10.49 | 2021-09-05 | 1 | 413.15 | 1 | 419.46 | 2 | SO43685 | 2021-09-12 | 33.56 | 413.15 | 419.46 | |||
SO47693_20 | 3962-4A1A-93 | PO522165713 | 100 | 285 | 297 | 676 | 5 | 2022-12-18 | 736.15 | 18.40 | 2022-12-06 | 1 | 653.70 | 1 | 736.15 | 20 | SO47693 | 2022-12-13 | 58.89 | 653.70 | 736.15 | |||
SO51108_41 | 8650-4A20-B1 | PO12644151814 | 100 | 285 | 465 | 530 | 5 | 2023-09-17 | 58.78 | 1.47 | 2023-09-05 | 4 | 9.16 | 1 | 58.78 | 41 | SO51108 | 2023-09-12 | 4.70 | 36.64 | 14.69 | |||
SO59071_10 | EFC3-4244-A6 | PO9599176835 | 100 | 285 | 388 | 170 | 5 | 2024-02-17 | 4033.76 | 100.84 | 2024-02-05 | 6 | 713.08 | 1 | 4033.76 | 10 | SO59071 | 2024-02-12 | 322.70 | 4278.48 | 672.29 | |||
SO43685_3 | C519-4AB3-88 | PO4176124783 | 100 | 285 | 315 | 458 | 5 | 2021-09-17 | 874.79 | 21.87 | 2021-09-05 | 1 | 884.71 | 1 | 874.79 | 3 | SO43685 | 2021-09-12 | 69.98 | 884.71 | 874.79 | |||
SO47693_21 | 3962-4A1A-93 | PO522165713 | 100 | 285 | 233 | 676 | 5 | 2022-12-18 | 86.52 | 2.16 | 2022-12-06 | 3 | 29.08 | 1 | 86.52 | 21 | SO47693 | 2022-12-13 | 6.92 | 87.24 | 28.84 | |||
SO51108_42 | 8650-4A20-B1 | PO12644151814 | 100 | 285 | 474 | 530 | 5 | 2023-09-17 | 377.95 | 9.45 | 2023-09-05 | 9 | 26.18 | 1 | 377.95 | 42 | SO51108 | 2023-09-12 | 30.24 | 235.59 | 41.99 | |||
SO59071_11 | EFC3-4244-A6 | PO9599176835 | 100 | 285 | 580 | 170 | 5 | 2024-02-17 | 1020.59 | 25.51 | 2024-02-05 | 1 | 1082.51 | 1 | 1020.59 | 11 | SO59071 | 2024-02-12 | 81.65 | 1082.51 | 1020.59 | |||
SO43685_4 | C519-4AB3-88 | PO4176124783 | 100 | 285 | 262 | 458 | 5 | 2021-09-17 | 183.94 | 4.60 | 2021-09-05 | 1 | 181.49 | 1 | 183.94 | 4 | SO43685 | 2021-09-12 | 14.72 | 181.49 | 183.94 | |||
SO47693_22 | 3962-4A1A-93 | PO522165713 | 100 | 285 | 236 | 676 | 5 | 2022-12-18 | 57.68 | 1.44 | 2022-12-06 | 2 | 29.08 | 1 | 57.68 | 22 | SO47693 | 2022-12-13 | 4.61 | 58.16 | 28.84 | |||
SO51108_43 | 8650-4A20-B1 | PO12644151814 | 100 | 285 | 472 | 530 | 5 | 2023-09-17 | 38.10 | 0.95 | 2023-09-05 | 1 | 23.75 | 1 | 38.10 | 43 | SO51108 | 2023-09-12 | 3.05 | 23.75 | 38.10 | |||
SO59071_12 | EFC3-4244-A6 | PO9599176835 | 100 | 285 | 376 | 170 | 5 | 2024-02-17 | 1466.01 | 36.65 | 2024-02-05 | 1 | 1554.95 | 1 | 1466.01 | 12 | SO59071 | 2024-02-12 | 117.28 | 1554.95 | 1466.01 | |||
SO43694_1 | EC3D-48E0-A6 | PO9657130250 | 100 | 285 | 349 | 315 | 5 | 2021-09-17 | 6074.98 | 151.87 | 2021-09-05 | 3 | 1898.09 | 1 | 6074.98 | 1 | SO43694 | 2021-09-12 | 486.00 | 5694.28 | 2024.99 | |||
SO47693_23 | 3962-4A1A-93 | PO522165713 | 100 | 285 | 453 | 676 | 5 | 2022-12-18 | 215.96 | 5.40 | 2022-12-06 | 6 | 24.75 | 1 | 215.96 | 23 | SO47693 | 2022-12-13 | 17.28 | 148.48 | 35.99 | |||
SO51108_44 | 8650-4A20-B1 | PO12644151814 | 100 | 285 | 487 | 530 | 5 | 2023-09-17 | 131.98 | 3.30 | 2023-09-05 | 4 | 20.57 | 1 | 131.98 | 44 | SO51108 | 2023-09-12 | 10.56 | 82.27 | 32.99 |
Generated 2024-10-05 18:41:50.356 UTC