[ROOT] dt FactResellerSale WHERE DimSalesTerritoryId EQ '1' > SHUFFLE SKIP 2000 < SKIP 375 > < 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 |
---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
SO67322_6 | 1881-4634-82 | PO6612121393 | 100 | 286 | 493 | 110 | 1 | 2024-06-02 | 200.05 | 5.00 | 2024-05-21 | 1 | 199.85 | 1 | 200.05 | 6 | SO67322 | 2024-05-28 | 16.00 | 199.85 | 200.05 | |||
SO51721_72 | 9429-430D-89 | PO14500124798 | 100 | 282 | 465 | 650 | 1 | 2023-10-02 | 117.55 | 2.94 | 2023-09-20 | 8 | 9.16 | 1 | 117.55 | 72 | SO51721 | 2023-09-27 | 9.40 | 73.27 | 14.69 | |||
SO55291_2 | 4FAB-4BAB-88 | PO7076160432 | 100 | 293 | 500 | 505 | 1 | 2023-12-02 | 602.35 | 15.06 | 2023-11-20 | 1 | 601.74 | 1 | 602.35 | 2 | SO55291 | 2023-11-27 | 48.19 | 601.74 | 602.35 | |||
SO43866_2 | B6E8-4721-85 | PO14529112624 | 100 | 286 | 350 | 289 | 1 | 2021-10-02 | 2024.99 | 50.62 | 2021-09-20 | 1 | 1898.09 | 1 | 2024.99 | 2 | SO43866 | 2021-09-27 | 162.00 | 1898.09 | 2024.99 | |||
SO55277_16 | E9AB-453F-BA | PO2552111630 | 100 | 286 | 355 | 506 | 1 | 2023-12-02 | 9743.96 | 243.60 | 2023-11-20 | 7 | 1265.62 | 1 | 9743.96 | 16 | SO55277 | 2023-11-27 | 779.52 | 8859.34 | 1391.99 | |||
SO44121_7 | FE2E-4885-B3 | PO5220129819 | 100 | 282 | 300 | 169 | 1 | 2021-11-02 | 1619.52 | 40.49 | 2021-10-21 | 2 | 699.09 | 1 | 1619.52 | 7 | SO44121 | 2021-10-28 | 129.56 | 1398.19 | 809.76 | |||
SO44285_8 | 33BA-457C-B7 | PO16617120120 | 100 | 286 | 346 | 397 | 1 | 2021-12-02 | 10199.97 | 255.00 | 2021-11-20 | 5 | 1912.15 | 1 | 10199.97 | 8 | SO44285 | 2021-11-27 | 816.00 | 9560.77 | 2039.99 | |||
SO51800_4 | A082-4BC8-96 | PO14181145795 | 100 | 293 | 475 | 307 | 1 | 2023-10-02 | 83.99 | 2.10 | 2023-09-20 | 2 | 26.18 | 1 | 83.99 | 4 | SO51800 | 2023-09-27 | 6.72 | 52.35 | 41.99 | |||
SO51728_12 | 5481-42D0-8C | PO14558119777 | 100 | 289 | 214 | 2 | 1 | 2023-10-02 | 125.96 | 3.15 | 2023-09-20 | 6 | 13.09 | 1 | 125.96 | 12 | SO51728 | 2023-09-27 | 10.08 | 78.52 | 20.99 | |||
SO49849_18 | C8F3-4DDE-A6 | PO2552190786 | 100 | 286 | 365 | 2 | 506 | 1 | 137.81 | 2023-06-02 | 6890.34 | 168.81 | 2023-05-21 | 11 | 598.44 | 1 | 6752.53 | 18 | SO49849 | 2023-05-28 | 540.20 | 6582.79 | 626.39 | 0.02 |
SO53500_11 | BEF0-4525-AF | PO12470126979 | 100 | 287 | 495 | 672 | 1 | 2023-11-02 | 1204.69 | 30.12 | 2023-10-21 | 2 | 601.74 | 1 | 1204.69 | 11 | SO53500 | 2023-10-28 | 96.38 | 1203.49 | 602.35 | |||
SO44501_18 | 4971-4FC0-A3 | PO16646128920 | 100 | 286 | 322 | 1 | 1 | 2022-01-02 | 1677.84 | 41.95 | 2021-12-21 | 4 | 413.15 | 1 | 1677.84 | 18 | SO44501 | 2021-12-28 | 134.23 | 1652.59 | 419.46 | |||
SO71893_17 | 9AE1-416A-8F | PO7482196160 | 100 | 293 | 493 | 163 | 1 | 2024-08-02 | 200.05 | 5.00 | 2024-07-21 | 1 | 199.85 | 1 | 200.05 | 17 | SO71893 | 2024-07-28 | 16.00 | 199.85 | 200.05 | |||
SO53457_33 | B3F3-4A07-9B | PO19169151555 | 100 | 289 | 309 | 272 | 1 | 2023-11-02 | 6549.60 | 163.74 | 2023-10-21 | 8 | 747.20 | 1 | 6549.60 | 33 | SO53457 | 2023-10-28 | 523.97 | 5977.60 | 818.70 | |||
SO51148_5 | 1D20-490E-98 | PO6612158387 | 100 | 286 | 568 | 13 | 110 | 1 | 250.54 | 2023-09-01 | 1670.29 | 35.49 | 2023-08-20 | 5 | 461.44 | 1 | 1419.74 | 5 | SO51148 | 2023-08-27 | 113.58 | 2307.22 | 334.06 | 0.15 |
SO71836_20 | E41E-40C1-84 | PO841118259 | 100 | 286 | 542 | 254 | 1 | 2024-08-02 | 218.65 | 5.47 | 2024-07-21 | 9 | 17.98 | 1 | 218.65 | 20 | SO71836 | 2024-07-28 | 17.49 | 161.80 | 24.29 | |||
SO51123_46 | E412-45DF-AE | PO899150137 | 100 | 289 | 258 | 290 | 1 | 2023-09-01 | 809.33 | 20.23 | 2023-08-20 | 4 | 204.63 | 1 | 809.33 | 46 | SO51123 | 2023-08-27 | 64.75 | 818.50 | 202.33 | |||
SO65234_5 | 3BB7-4A9F-AF | PO10411160249 | 100 | 289 | 570 | 182 | 1 | 2024-05-02 | 1781.64 | 44.54 | 2024-04-20 | 4 | 461.44 | 1 | 1781.64 | 5 | SO65234 | 2024-04-27 | 142.53 | 1845.78 | 445.41 | |||
SO53613_4 | 4A10-4F98-84 | PO6815195063 | 100 | 293 | 234 | 109 | 1 | 2023-11-02 | 119.98 | 3.00 | 2023-10-21 | 4 | 38.49 | 1 | 119.98 | 4 | SO53613 | 2023-10-28 | 9.60 | 153.97 | 29.99 | |||
SO51721_65 | 9429-430D-89 | PO14500124798 | 100 | 282 | 550 | 650 | 1 | 2023-10-02 | 149.87 | 3.75 | 2023-09-20 | 1 | 136.79 | 1 | 149.87 | 65 | SO51721 | 2023-09-27 | 11.99 | 136.79 | 149.87 | |||
SO47452_15 | 79C0-49E8-B3 | PO8903162839 | 100 | 286 | 329 | 235 | 1 | 2022-11-02 | 469.79 | 11.74 | 2022-10-21 | 1 | 486.71 | 1 | 469.79 | 15 | SO47452 | 2022-10-28 | 37.58 | 486.71 | 469.79 | |||
SO45068_2 | 6E46-440A-B5 | PO5075140071 | 100 | 289 | 315 | 344 | 1 | 2022-03-04 | 874.79 | 21.87 | 2022-02-20 | 1 | 884.71 | 1 | 874.79 | 2 | SO45068 | 2022-02-27 | 69.98 | 884.71 | 874.79 | |||
SO61244_23 | 22F5-4A88-BE | PO6612122199 | 100 | 286 | 585 | 110 | 1 | 2024-03-03 | 1781.64 | 44.54 | 2024-02-20 | 4 | 461.44 | 1 | 1781.64 | 23 | SO61244 | 2024-02-27 | 142.53 | 1845.78 | 445.41 | |||
SO59019_4 | 5F5A-465D-A8 | PO7192182554 | 100 | 289 | 359 | 20 | 1 | 2024-02-01 | 1376.99 | 34.42 | 2024-01-20 | 1 | 1251.98 | 1 | 1376.99 | 4 | SO59019 | 2024-01-27 | 110.16 | 1251.98 | 1376.99 | |||
SO47057_9 | 0D4D-45B2-91 | PO7917141916 | 100 | 287 | 360 | 401 | 1 | 2022-10-02 | 2458.92 | 61.47 | 2022-09-20 | 2 | 1105.81 | 1 | 2458.92 | 9 | SO47057 | 2022-09-27 | 196.71 | 2211.62 | 1229.46 | |||
SO46612_2 | 8645-4FD3-B4 | PO16443150420 | 100 | 289 | 236 | 398 | 1 | 2022-09-01 | 28.84 | 0.72 | 2022-08-20 | 1 | 29.08 | 1 | 28.84 | 2 | SO46612 | 2022-08-27 | 2.31 | 29.08 | 28.84 | |||
SO51146_3 | FC91-4E19-86 | PO7076128836 | 100 | 293 | 573 | 505 | 1 | 2023-09-01 | 2860.88 | 71.52 | 2023-08-20 | 2 | 1481.94 | 1 | 2860.88 | 3 | SO51146 | 2023-08-27 | 228.87 | 2963.88 | 1430.44 | |||
SO50693_41 | 0DA5-4EE4-93 | PO841149385 | 100 | 286 | 469 | 254 | 1 | 2023-08-02 | 91.18 | 2.28 | 2023-07-21 | 4 | 15.67 | 1 | 91.18 | 41 | SO50693 | 2023-07-28 | 7.29 | 62.68 | 22.79 | |||
SO43664_4 | 2F44-4BA1-BB | PO16617121983 | 100 | 286 | 235 | 397 | 1 | 2021-09-01 | 28.84 | 0.72 | 2021-08-20 | 1 | 31.72 | 1 | 28.84 | 4 | SO43664 | 2021-08-27 | 2.31 | 31.72 | 28.84 | |||
SO49114_4 | 354C-48D4-9B | PO15631175128 | 100 | 282 | 409 | 43 | 1 | 2023-04-04 | 627.77 | 15.69 | 2023-03-23 | 3 | 185.82 | 1 | 627.77 | 4 | SO49114 | 2023-03-30 | 50.22 | 557.46 | 209.26 | |||
SO44078_2 | 6487-4A93-82 | PO19169159771 | 100 | 289 | 296 | 272 | 1 | 2021-11-02 | 1429.41 | 35.74 | 2021-10-21 | 2 | 617.03 | 1 | 1429.41 | 2 | SO44078 | 2021-10-28 | 114.35 | 1234.06 | 714.70 |
Generated 2024-09-19 21:05:20.488 UTC