[ROOT] dt FactResellerSale WHERE DimSalesTerritoryId EQ '1' > SKIP 0 SHUFFLE < SKIP 1219 > < 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 |
---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
SO57130_11 | 2182-4ADD-88 | PO6148161629 | 100 | 289 | 572 | 693 | 1 | 2024-02-23 | 2672.46 | 66.81 | 2024-02-11 | 6 | 461.44 | 1 | 2672.46 | 11 | SO57130 | 2024-02-18 | 213.80 | 2768.67 | 445.41 | |||
SO49464_25 | C383-45FE-83 | PO841195010 | 100 | 286 | 362 | 254 | 1 | 2023-06-23 | 7376.75 | 184.42 | 2023-06-11 | 6 | 1105.81 | 1 | 7376.75 | 25 | SO49464 | 2023-06-18 | 590.14 | 6634.86 | 1229.46 | |||
SO61241_5 | 13FB-4126-88 | PO9338116236 | 100 | 293 | 579 | 451 | 1 | 2024-04-24 | 1457.82 | 36.45 | 2024-04-12 | 2 | 755.15 | 1 | 1457.82 | 5 | SO61241 | 2024-04-19 | 116.63 | 1510.30 | 728.91 | |||
SO47057_18 | 0D4D-45B2-91 | PO7917141916 | 100 | 287 | 221 | 401 | 1 | 2022-11-23 | 20.19 | 0.50 | 2022-11-11 | 1 | 13.88 | 1 | 20.19 | 18 | SO47057 | 2022-11-18 | 1.61 | 13.88 | 20.19 | |||
SO69471_6 | 2CF9-42DE-B1 | PO18676191433 | 100 | 282 | 590 | 697 | 1 | 2024-08-23 | 2308.47 | 57.71 | 2024-08-11 | 5 | 419.78 | 1 | 2308.47 | 6 | SO69471 | 2024-08-18 | 184.68 | 2098.89 | 461.69 | |||
SO48328_11 | 5992-4AF8-B1 | PO13543152596 | 100 | 287 | 352 | 293 | 1 | 2023-03-25 | 2485.70 | 62.14 | 2023-03-13 | 2 | 1117.86 | 1 | 2485.70 | 11 | SO48328 | 2023-03-20 | 198.86 | 2235.71 | 1242.85 | |||
SO47054_26 | E4B1-4C58-AE | PO7627150376 | 100 | 286 | 329 | 433 | 1 | 2022-11-23 | 469.79 | 11.74 | 2022-11-11 | 1 | 486.71 | 1 | 469.79 | 26 | SO47054 | 2022-11-18 | 37.58 | 486.71 | 469.79 | |||
SO57105_39 | 3AE1-4A72-91 | PO18676113963 | 100 | 282 | 531 | 697 | 1 | 2024-02-23 | 749.37 | 18.73 | 2024-02-11 | 5 | 136.79 | 1 | 749.37 | 39 | SO57105 | 2024-02-18 | 59.95 | 683.93 | 149.87 | |||
SO71812_4 | 3257-4AE0-A8 | PO13543115747 | 100 | 287 | 361 | 293 | 1 | 2024-09-23 | 9638.96 | 240.97 | 2024-09-11 | 7 | 1251.98 | 1 | 9638.96 | 4 | SO71812 | 2024-09-18 | 771.12 | 8763.87 | 1376.99 | |||
SO49544_1 | 9647-4E6D-B8 | PO8294194867 | 100 | 289 | 409 | 488 | 1 | 2023-06-23 | 209.26 | 5.23 | 2023-06-11 | 1 | 185.82 | 1 | 209.26 | 1 | SO49544 | 2023-06-18 | 16.74 | 185.82 | 209.26 | |||
SO49167_1 | 5A78-4DE2-89 | PO8816115193 | 100 | 289 | 371 | 218 | 1 | 2023-05-26 | 2617.88 | 65.45 | 2023-05-14 | 2 | 1320.68 | 1 | 2617.88 | 1 | SO49167 | 2023-05-21 | 209.43 | 2641.37 | 1308.94 | |||
SO46967_20 | 6486-4AF8-A6 | PO15573116583 | 100 | 286 | 460 | 487 | 1 | 2022-11-23 | 269.97 | 6.75 | 2022-11-11 | 5 | 37.12 | 1 | 269.97 | 20 | SO46967 | 2022-11-18 | 21.60 | 185.60 | 53.99 | |||
SO49161_3 | 0377-44E6-AA | PO7627157444 | 100 | 293 | 368 | 433 | 1 | 2023-05-26 | 2932.02 | 73.30 | 2023-05-14 | 2 | 1518.79 | 1 | 2932.02 | 3 | SO49161 | 2023-05-21 | 234.56 | 3037.57 | 1466.01 | |||
SO57046_11 | 52CC-460F-B3 | PO14500161818 | 100 | 282 | 491 | 2 | 650 | 1 | 8.77 | 2024-02-23 | 438.40 | 10.74 | 2024-02-11 | 14 | 41.57 | 1 | 429.63 | 11 | SO57046 | 2024-02-18 | 34.37 | 582.01 | 31.31 | 0.02 |
SO53569_7 | 113E-43AD-94 | PO9309141312 | 100 | 293 | 554 | 55 | 1 | 2023-12-24 | 109.88 | 2.75 | 2023-12-12 | 2 | 40.66 | 1 | 109.88 | 7 | SO53569 | 2023-12-19 | 8.79 | 81.31 | 54.94 | |||
SO48741_1 | 5AA4-4194-B9 | PO899196006 | 100 | 289 | 343 | 290 | 1 | 2023-04-25 | 1409.38 | 35.23 | 2023-04-13 | 3 | 486.71 | 1 | 1409.38 | 1 | SO48741 | 2023-04-20 | 112.75 | 1460.12 | 469.79 | |||
SO47992_5 | 3F55-4354-BD | PO15573158216 | 100 | 293 | 427 | 487 | 1 | 2023-02-23 | 1674.05 | 41.85 | 2023-02-11 | 8 | 185.82 | 1 | 1674.05 | 5 | SO47992 | 2023-02-18 | 133.92 | 1486.55 | 209.26 | |||
SO51800_6 | A082-4BC8-96 | PO14181145795 | 100 | 293 | 542 | 307 | 1 | 2023-11-23 | 24.29 | 0.61 | 2023-11-11 | 1 | 17.98 | 1 | 24.29 | 6 | SO51800 | 2023-11-18 | 1.94 | 17.98 | 24.29 | |||
SO51128_5 | 5A2E-45E2-A5 | PO2929192490 | 100 | 289 | 476 | 380 | 1 | 2023-10-23 | 125.98 | 3.15 | 2023-10-11 | 3 | 26.18 | 1 | 125.98 | 5 | SO51128 | 2023-10-18 | 10.08 | 78.53 | 41.99 | |||
SO51728_19 | 5481-42D0-8C | PO14558119777 | 100 | 289 | 491 | 2 | 1 | 2023-11-23 | 129.58 | 3.24 | 2023-11-11 | 4 | 41.57 | 1 | 129.58 | 19 | SO51728 | 2023-11-18 | 10.37 | 166.29 | 32.39 | |||
SO59021_25 | A306-4E83-B7 | PO7395154426 | 100 | 286 | 298 | 542 | 1 | 2024-03-24 | 4048.80 | 101.22 | 2024-03-12 | 5 | 739.04 | 1 | 4048.80 | 25 | SO59021 | 2024-03-19 | 323.90 | 3695.21 | 809.76 | |||
SO57045_16 | 4D3C-4309-BE | PO14587121888 | 100 | 293 | 560 | 199 | 1 | 2024-02-23 | 3644.55 | 91.11 | 2024-02-11 | 5 | 755.15 | 1 | 3644.55 | 16 | SO57045 | 2024-02-18 | 291.56 | 3775.75 | 728.91 | |||
SO48087_29 | 2285-4C77-9B | PO8816162044 | 100 | 289 | 415 | 218 | 1 | 2023-02-23 | 396.07 | 9.90 | 2023-02-11 | 2 | 146.55 | 1 | 396.07 | 29 | SO48087 | 2023-02-18 | 31.69 | 293.09 | 198.04 | |||
SO47066_30 | 5E42-48DE-80 | PO8816154123 | 100 | 289 | 381 | 218 | 1 | 2022-11-23 | 1200.53 | 30.01 | 2022-11-11 | 2 | 605.65 | 1 | 1200.53 | 30 | SO47066 | 2022-11-18 | 96.04 | 1211.30 | 600.26 | |||
SO49163_3 | DE2F-4D6A-99 | PO7917119932 | 100 | 287 | 470 | 401 | 1 | 2023-05-26 | 182.35 | 4.56 | 2023-05-14 | 8 | 15.67 | 1 | 182.35 | 3 | SO49163 | 2023-05-21 | 14.59 | 125.37 | 22.79 | |||
SO47403_36 | 60A2-4F08-8B | PO841143108 | 100 | 286 | 466 | 254 | 1 | 2022-12-24 | 42.39 | 1.06 | 2022-12-12 | 3 | 9.71 | 1 | 42.39 | 36 | SO47403 | 2022-12-19 | 3.39 | 29.14 | 14.13 | |||
SO49849_2 | C8F3-4DDE-A6 | PO2552190786 | 100 | 286 | 470 | 4 | 506 | 1 | 53.19 | 2023-07-24 | 531.86 | 11.97 | 2023-07-12 | 28 | 15.67 | 1 | 478.67 | 2 | SO49849 | 2023-07-19 | 38.29 | 438.79 | 19.00 | 0.10 |
SO50209_12 | D138-4E7C-86 | PO15573136083 | 100 | 293 | 354 | 487 | 1 | 2023-08-23 | 2485.70 | 62.14 | 2023-08-11 | 2 | 1117.86 | 1 | 2485.70 | 12 | SO50209 | 2023-08-18 | 198.86 | 2235.71 | 1242.85 | |||
SO49852_4 | 5DD7-447A-8D | PO2581189096 | 100 | 282 | 327 | 698 | 1 | 2023-07-24 | 1879.18 | 46.98 | 2023-07-12 | 4 | 486.71 | 1 | 1879.18 | 4 | SO49852 | 2023-07-19 | 150.33 | 1946.83 | 469.79 | |||
SO57099_33 | 410F-45E9-9C | PO18618199656 | 100 | 286 | 562 | 605 | 1 | 2024-02-23 | 2860.88 | 71.52 | 2024-02-11 | 2 | 1481.94 | 1 | 2860.88 | 33 | SO57099 | 2024-02-18 | 228.87 | 2963.88 | 1430.44 | |||
SO47701_5 | 5718-4DDD-B7 | PO2929114832 | 100 | 289 | 224 | 380 | 1 | 2023-01-23 | 15.56 | 0.39 | 2023-01-11 | 3 | 5.23 | 1 | 15.56 | 5 | SO47701 | 2023-01-18 | 1.24 | 15.69 | 5.19 |
Generated 2024-11-10 12:11:20.844 UTC