[ROOT] dt FactResellerSale < WHERE DimSalesTerritoryId EQ '5' > SHUFFLE < SKIP 2196 > < TAKE 28 >
28 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 |
---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
SO63130_1 | EE88-4C2F-98 | PO18560122888 | 100 | 285 | 482 | 2 | 531 | 5 | 1.15 | 2024-05-28 | 57.36 | 1.41 | 2024-05-16 | 11 | 3.36 | 1 | 56.21 | 1 | SO63130 | 2024-05-23 | 4.50 | 36.99 | 5.21 | 0.02 |
SO53530_36 | A31D-483D-A1 | PO2813121313 | 100 | 283 | 477 | 90 | 5 | 2023-12-27 | 14.97 | 0.37 | 2023-12-15 | 5 | 1.87 | 1 | 14.97 | 36 | SO53530 | 2023-12-22 | 1.20 | 9.33 | 2.99 | |||
SO44493_8 | 152B-4DC8-B9 | PO18560118950 | 100 | 285 | 328 | 531 | 5 | 2022-02-26 | 838.92 | 20.97 | 2022-02-14 | 2 | 413.15 | 1 | 838.92 | 8 | SO44493 | 2022-02-21 | 67.11 | 826.29 | 419.46 | |||
SO47067_14 | DDEC-4319-8A | PO9512118933 | 100 | 285 | 233 | 3 | 135 | 5 | 19.83 | 2022-11-26 | 396.56 | 9.42 | 2022-11-14 | 15 | 29.08 | 1 | 376.73 | 14 | SO47067 | 2022-11-21 | 30.14 | 436.21 | 26.44 | 0.05 |
SO46349_4 | C053-4BA7-A1 | PO11977118598 | 100 | 285 | 279 | 675 | 5 | 2022-09-26 | 178.58 | 4.46 | 2022-09-14 | 1 | 176.20 | 1 | 178.58 | 4 | SO46349 | 2022-09-21 | 14.29 | 176.20 | 178.58 | |||
SO55234_24 | C6FC-46EE-88 | PO522140495 | 100 | 285 | 477 | 676 | 5 | 2024-01-26 | 17.96 | 0.45 | 2024-01-14 | 6 | 1.87 | 1 | 17.96 | 24 | SO55234 | 2024-01-21 | 1.44 | 11.20 | 2.99 | |||
SO63246_5 | 5008-4978-B3 | PO7598198768 | 100 | 285 | 482 | 45 | 5 | 2024-05-28 | 5.39 | 0.13 | 2024-05-16 | 1 | 3.36 | 1 | 5.39 | 5 | SO63246 | 2024-05-23 | 0.43 | 3.36 | 5.39 | |||
SO45288_20 | D4D0-4662-A9 | PO16327170541 | 100 | 285 | 330 | 584 | 5 | 2022-05-29 | 1258.38 | 31.46 | 2022-05-17 | 3 | 413.15 | 1 | 1258.38 | 20 | SO45288 | 2022-05-24 | 100.67 | 1239.44 | 419.46 | |||
SO71850_3 | 3DA6-4E97-9F | PO18241134627 | 100 | 285 | 573 | 477 | 5 | 2024-09-26 | 1430.44 | 35.76 | 2024-09-14 | 1 | 1481.94 | 1 | 1430.44 | 3 | SO71850 | 2024-09-21 | 114.44 | 1481.94 | 1430.44 | |||
SO47042_21 | 42DB-4E2E-B9 | PO5858114009 | 100 | 285 | 393 | 566 | 5 | 2022-11-26 | 826.16 | 20.65 | 2022-11-14 | 6 | 101.89 | 1 | 826.16 | 21 | SO47042 | 2022-11-21 | 66.09 | 611.36 | 137.69 | |||
SO61228_22 | 06C7-43A1-85 | PO9831151400 | 100 | 285 | 237 | 81 | 5 | 2024-04-27 | 59.99 | 1.50 | 2024-04-15 | 2 | 38.49 | 1 | 59.99 | 22 | SO61228 | 2024-04-22 | 4.80 | 76.98 | 29.99 | |||
SO49064_4 | A2CA-44DC-80 | PO1247190988 | 100 | 285 | 356 | 296 | 5 | 2023-05-29 | 3728.56 | 93.21 | 2023-05-17 | 3 | 1117.86 | 1 | 3728.56 | 4 | SO49064 | 2023-05-24 | 298.28 | 3353.57 | 1242.85 | |||
SO49149_10 | D41E-4EFF-A5 | PO5858123072 | 100 | 285 | 365 | 566 | 5 | 2023-05-29 | 1295.99 | 32.40 | 2023-05-17 | 2 | 598.44 | 1 | 1295.99 | 10 | SO49149 | 2023-05-24 | 103.68 | 1196.87 | 647.99 | |||
SO50726_18 | A80B-408E-B3 | PO9599192861 | 100 | 285 | 387 | 170 | 5 | 2023-09-26 | 2401.05 | 60.03 | 2023-09-14 | 4 | 605.65 | 1 | 2401.05 | 18 | SO50726 | 2023-09-21 | 192.08 | 2422.60 | 600.26 | |||
SO49473_7 | EAA2-43E2-87 | PO2813142084 | 100 | 283 | 433 | 90 | 5 | 2023-06-26 | 324.45 | 8.11 | 2023-06-14 | 1 | 300.12 | 1 | 324.45 | 7 | SO49473 | 2023-06-21 | 25.96 | 300.12 | 324.45 | |||
SO50293_11 | D649-4CE8-91 | PO3596144572 | 100 | 285 | 360 | 476 | 5 | 2023-08-26 | 1229.46 | 30.74 | 2023-08-14 | 1 | 1105.81 | 1 | 1229.46 | 11 | SO50293 | 2023-08-21 | 98.36 | 1105.81 | 1229.46 | |||
SO67348_27 | 4BD1-4782-A3 | PO9889141767 | 100 | 285 | 298 | 494 | 5 | 2024-07-27 | 809.76 | 20.24 | 2024-07-15 | 1 | 739.04 | 1 | 809.76 | 27 | SO67348 | 2024-07-22 | 64.78 | 739.04 | 809.76 | |||
SO53540_3 | 1C52-4046-BA | PO18241135767 | 100 | 285 | 560 | 477 | 5 | 2023-12-27 | 728.91 | 18.22 | 2023-12-15 | 1 | 755.15 | 1 | 728.91 | 3 | SO53540 | 2023-12-22 | 58.31 | 755.15 | 728.91 | |||
SO46971_5 | 5CEA-463B-A2 | PO15051144269 | 100 | 285 | 360 | 207 | 5 | 2022-11-26 | 3688.38 | 92.21 | 2022-11-14 | 3 | 1105.81 | 1 | 3688.38 | 5 | SO46971 | 2022-11-21 | 295.07 | 3317.43 | 1229.46 | |||
SO51759_1 | D9CE-4CAE-90 | PO10208129572 | 100 | 285 | 386 | 134 | 5 | 2023-11-26 | 672.29 | 16.81 | 2023-11-14 | 1 | 713.08 | 1 | 672.29 | 1 | SO51759 | 2023-11-21 | 53.78 | 713.08 | 672.29 | |||
SO50306_1 | D376-4A40-86 | PO5858194676 | 100 | 285 | 447 | 566 | 5 | 2023-08-26 | 60.00 | 1.50 | 2023-08-14 | 4 | 10.31 | 1 | 60.00 | 1 | SO50306 | 2023-08-21 | 4.80 | 41.25 | 15.00 | |||
SO47454_21 | E249-41EE-95 | PO9570119946 | 100 | 285 | 362 | 585 | 5 | 2022-12-27 | 2458.92 | 61.47 | 2022-12-15 | 2 | 1105.81 | 1 | 2458.92 | 21 | SO47454 | 2022-12-22 | 196.71 | 2211.62 | 1229.46 | |||
SO50291_2 | 4767-4F8F-BC | PO3335142904 | 100 | 285 | 265 | 152 | 5 | 2023-08-26 | 404.66 | 10.12 | 2023-08-14 | 2 | 187.16 | 1 | 404.66 | 2 | SO50291 | 2023-08-21 | 32.37 | 374.31 | 202.33 | |||
SO63228_7 | 8736-4385-98 | PO11542125349 | 100 | 285 | 482 | 62 | 5 | 2024-05-28 | 21.58 | 0.54 | 2024-05-16 | 4 | 3.36 | 1 | 21.58 | 7 | SO63228 | 2024-05-23 | 1.73 | 13.45 | 5.39 | |||
SO51147_22 | C4D7-458D-A6 | PO9831167474 | 100 | 285 | 374 | 81 | 5 | 2023-10-26 | 4398.03 | 109.95 | 2023-10-14 | 3 | 1554.95 | 1 | 4398.03 | 22 | SO51147 | 2023-10-21 | 351.84 | 4664.84 | 1466.01 | |||
SO71883_1 | 1A43-4395-84 | PO9251166541 | 100 | 285 | 498 | 351 | 5 | 2024-09-26 | 602.35 | 15.06 | 2024-09-14 | 1 | 601.74 | 1 | 602.35 | 1 | SO71883 | 2024-09-21 | 48.19 | 601.74 | 602.35 | |||
SO50302_2 | 11AB-4878-A8 | PO5568123194 | 100 | 285 | 468 | 422 | 5 | 2023-08-26 | 91.18 | 2.28 | 2023-08-14 | 4 | 15.67 | 1 | 91.18 | 2 | SO50302 | 2023-08-21 | 7.29 | 62.68 | 22.79 | |||
SO51137_5 | A47F-4FEF-94 | PO9889144162 | 100 | 285 | 359 | 494 | 5 | 2023-10-26 | 6884.97 | 172.12 | 2023-10-14 | 5 | 1251.98 | 1 | 6884.97 | 5 | SO51137 | 2023-10-21 | 550.80 | 6259.91 | 1376.99 |
Generated 2024-11-13 05:22:02.918 UTC