[ROOT] dt FactResellerSale < WHERE DimSalesTerritoryId EQ '4' > SHUFFLE SKIP 2000 < SKIP 472 > < 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 |
---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
SO44538_11 | E495-47A9-AD | PO2523126243 | 100 | 287 | 317 | 167 | 4 | 2022-02-25 | 2624.38 | 65.61 | 2022-02-13 | 3 | 884.71 | 1 | 2624.38 | 11 | SO44538 | 2022-02-20 | 209.95 | 2654.12 | 874.79 | |||
SO51144_4 | 6330-4EB9-A5 | PO6409122852 | 100 | 281 | 484 | 292 | 4 | 2023-10-25 | 19.08 | 0.48 | 2023-10-13 | 4 | 2.97 | 1 | 19.08 | 4 | SO51144 | 2023-10-20 | 1.53 | 11.89 | 4.77 | |||
SO50214_28 | 97D5-41D3-8F | PO15196120916 | 100 | 282 | 373 | 258 | 4 | 2023-08-25 | 3926.81 | 98.17 | 2023-08-13 | 3 | 1320.68 | 1 | 3926.81 | 28 | SO50214 | 2023-08-20 | 314.15 | 3962.05 | 1308.94 | |||
SO59027_25 | C142-4AAA-AB | PO6757122081 | 100 | 281 | 517 | 21 | 4 | 2024-03-26 | 94.75 | 2.37 | 2024-03-14 | 3 | 23.37 | 1 | 94.75 | 25 | SO59027 | 2024-03-21 | 7.58 | 70.12 | 31.58 | |||
SO55256_23 | 686E-4D36-8B | PO12528136439 | 100 | 282 | 563 | 331 | 4 | 2024-01-25 | 5721.77 | 143.04 | 2024-01-13 | 4 | 1481.94 | 1 | 5721.77 | 23 | SO55256 | 2024-01-20 | 457.74 | 5927.75 | 1430.44 | |||
SO46355_19 | D579-4B15-AB | PO261195016 | 100 | 283 | 223 | 647 | 4 | 2022-09-25 | 41.49 | 1.04 | 2022-09-13 | 8 | 5.71 | 1 | 41.49 | 19 | SO46355 | 2022-09-20 | 3.32 | 45.64 | 5.19 | |||
SO51126_8 | 7A9E-43B4-B3 | PO2755153471 | 100 | 282 | 509 | 205 | 4 | 2023-10-25 | 400.10 | 10.00 | 2023-10-13 | 2 | 199.85 | 1 | 400.10 | 8 | SO51126 | 2023-10-20 | 32.01 | 399.70 | 200.05 | |||
SO63280_1 | C73E-4203-80 | PO3654118854 | 100 | 281 | 306 | 435 | 4 | 2024-05-27 | 809.76 | 20.24 | 2024-05-15 | 1 | 739.04 | 1 | 809.76 | 1 | SO63280 | 2024-05-22 | 64.78 | 739.04 | 809.76 | |||
SO71952_25 | 9490-4552-81 | PO9715163911 | 100 | 281 | 353 | 490 | 4 | 2024-09-25 | 13919.94 | 348.00 | 2024-09-13 | 10 | 1265.62 | 1 | 13919.94 | 25 | SO71952 | 2024-09-20 | 1113.60 | 12656.20 | 1391.99 | |||
SO50296_2 | F3B0-4811-BE | PO4553114154 | 100 | 282 | 327 | 313 | 4 | 2023-08-25 | 469.79 | 11.74 | 2023-08-13 | 1 | 486.71 | 1 | 469.79 | 2 | SO50296 | 2023-08-20 | 37.58 | 486.71 | 469.79 | |||
SO59023_33 | 9975-4F2A-A7 | PO5539149469 | 100 | 282 | 592 | 61 | 4 | 2024-03-26 | 1016.98 | 25.42 | 2024-03-14 | 3 | 308.22 | 1 | 1016.98 | 33 | SO59023 | 2024-03-21 | 81.36 | 924.65 | 338.99 | |||
SO67273_24 | 9BAE-4E69-B9 | PO13688176638 | 100 | 282 | 477 | 2 | 475 | 4 | 0.69 | 2024-07-26 | 34.73 | 0.85 | 2024-07-14 | 12 | 1.87 | 1 | 34.04 | 24 | SO67273 | 2024-07-21 | 2.72 | 22.40 | 2.89 | 0.02 |
SO47441_22 | 2582-4E47-98 | PO7569166535 | 100 | 287 | 297 | 608 | 4 | 2022-12-26 | 736.15 | 18.40 | 2022-12-14 | 1 | 653.70 | 1 | 736.15 | 22 | SO47441 | 2022-12-21 | 58.89 | 653.70 | 736.15 | |||
SO57168_36 | B6D5-41ED-B9 | PO3480129742 | 100 | 281 | 582 | 436 | 4 | 2024-02-25 | 2041.19 | 51.03 | 2024-02-13 | 2 | 1082.51 | 1 | 2041.19 | 36 | SO57168 | 2024-02-20 | 163.30 | 2165.02 | 1020.59 | |||
SO43692_16 | BFA9-470E-B4 | PO7859187017 | 100 | 287 | 316 | 221 | 4 | 2021-10-25 | 1749.59 | 43.74 | 2021-10-13 | 2 | 884.71 | 1 | 1749.59 | 16 | SO43692 | 2021-10-20 | 139.97 | 1769.42 | 874.79 | |||
SO51106_16 | 3D96-4D27-92 | PO12528166058 | 100 | 282 | 501 | 331 | 4 | 2023-10-25 | 145.75 | 3.64 | 2023-10-13 | 2 | 53.93 | 1 | 145.75 | 16 | SO51106 | 2023-10-20 | 11.66 | 107.86 | 72.88 | |||
SO53550_5 | C0B3-4A54-9F | PO16124171850 | 100 | 282 | 287 | 649 | 4 | 2023-12-26 | 202.33 | 5.06 | 2023-12-14 | 1 | 204.63 | 1 | 202.33 | 5 | SO53550 | 2023-12-21 | 16.19 | 204.63 | 202.33 | |||
SO44791_9 | CA2D-49E4-BD | PO6786162636 | 100 | 283 | 319 | 3 | 4 | 2022-03-27 | 2624.38 | 65.61 | 2022-03-15 | 3 | 884.71 | 1 | 2624.38 | 9 | SO44791 | 2022-03-22 | 209.95 | 2654.12 | 874.79 | |||
SO49821_20 | 0B9B-460C-BC | PO551117366 | 100 | 281 | 271 | 4 | 4 | 2023-07-26 | 1416.32 | 35.41 | 2023-07-14 | 7 | 187.16 | 1 | 1416.32 | 20 | SO49821 | 2023-07-21 | 113.31 | 1310.10 | 202.33 | |||
SO47049_28 | 3D73-4468-AE | PO6525111066 | 100 | 283 | 411 | 345 | 4 | 2022-11-25 | 125.42 | 3.14 | 2022-11-13 | 1 | 92.81 | 1 | 125.42 | 28 | SO47049 | 2022-11-20 | 10.03 | 92.81 | 125.42 | |||
SO47018_21 | E622-43B1-98 | PO2523197473 | 100 | 287 | 233 | 167 | 4 | 2022-11-25 | 230.72 | 5.77 | 2022-11-13 | 8 | 29.08 | 1 | 230.72 | 21 | SO47018 | 2022-11-20 | 18.46 | 232.65 | 28.84 | |||
SO71796_3 | 9A29-45DE-BF | PO17052159664 | 100 | 282 | 560 | 420 | 4 | 2024-09-25 | 1457.82 | 36.45 | 2024-09-13 | 2 | 755.15 | 1 | 1457.82 | 3 | SO71796 | 2024-09-20 | 116.63 | 1510.30 | 728.91 | |||
SO57042_17 | 52C4-4348-BC | PO15196150289 | 100 | 282 | 372 | 258 | 4 | 2024-02-25 | 5864.04 | 146.60 | 2024-02-13 | 4 | 1554.95 | 1 | 5864.04 | 17 | SO57042 | 2024-02-20 | 469.12 | 6219.79 | 1466.01 | |||
SO67290_7 | 763C-4FCC-8E | PO10237115936 | 100 | 287 | 490 | 41 | 4 | 2024-07-26 | 64.79 | 1.62 | 2024-07-14 | 2 | 41.57 | 1 | 64.79 | 7 | SO67290 | 2024-07-21 | 5.18 | 83.14 | 32.39 | |||
SO59014_2 | E148-47F7-98 | PO5510184760 | 100 | 287 | 605 | 5 | 4 | 2024-03-26 | 2267.96 | 56.70 | 2024-03-14 | 7 | 343.65 | 1 | 2267.96 | 2 | SO59014 | 2024-03-21 | 181.44 | 2405.55 | 323.99 | |||
SO47045_31 | 9DDC-4176-90 | PO6438144434 | 100 | 283 | 411 | 309 | 4 | 2022-11-25 | 250.83 | 6.27 | 2022-11-13 | 2 | 92.81 | 1 | 250.83 | 31 | SO47045 | 2022-11-20 | 20.07 | 185.61 | 125.42 | |||
SO46625_41 | 361B-4CAF-A2 | PO13688113829 | 100 | 282 | 393 | 475 | 4 | 2022-10-25 | 275.39 | 6.88 | 2022-10-13 | 2 | 101.89 | 1 | 275.39 | 41 | SO46625 | 2022-10-20 | 22.03 | 203.79 | 137.69 | |||
SO47355_24 | 6B7D-4E47-B5 | PO19343125466 | 100 | 282 | 331 | 24 | 4 | 2022-12-26 | 939.59 | 23.49 | 2022-12-14 | 2 | 486.71 | 1 | 939.59 | 24 | SO47355 | 2022-12-21 | 75.17 | 973.41 | 469.79 |
Generated 2024-11-13 03:07:21.015 UTC