[ROOT] dt FactResellerSale WHERE DimSalesTerritoryId EQ '1' > < SKIP 5965 > < TAKE 30 >
30 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 |
---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
SO58946_9 | F9DD-426F-9A | PO12470155874 | 100 | 287 | 568 | 672 | 1 | 2024-03-24 | 2672.46 | 66.81 | 2024-03-12 | 6 | 461.44 | 1 | 2672.46 | 9 | SO58946 | 2024-03-19 | 213.80 | 2768.67 | 445.41 | |||
SO58946_10 | F9DD-426F-9A | PO12470155874 | 100 | 287 | 570 | 672 | 1 | 2024-03-24 | 890.82 | 22.27 | 2024-03-12 | 2 | 461.44 | 1 | 890.82 | 10 | SO58946 | 2024-03-19 | 71.27 | 922.89 | 445.41 | |||
SO58946_11 | F9DD-426F-9A | PO12470155874 | 100 | 287 | 554 | 672 | 1 | 2024-03-24 | 219.77 | 5.49 | 2024-03-12 | 4 | 40.66 | 1 | 219.77 | 11 | SO58946 | 2024-03-19 | 17.58 | 162.63 | 54.94 | |||
SO58946_12 | F9DD-426F-9A | PO12470155874 | 100 | 287 | 522 | 672 | 1 | 2024-03-24 | 70.45 | 1.76 | 2024-03-12 | 3 | 17.38 | 1 | 70.45 | 12 | SO58946 | 2024-03-19 | 5.64 | 52.13 | 23.48 | |||
SO58946_13 | F9DD-426F-9A | PO12470155874 | 100 | 287 | 503 | 672 | 1 | 2024-03-24 | 400.10 | 10.00 | 2024-03-12 | 2 | 199.85 | 1 | 400.10 | 13 | SO58946 | 2024-03-19 | 32.01 | 399.70 | 200.05 | |||
SO58946_14 | F9DD-426F-9A | PO12470155874 | 100 | 287 | 497 | 672 | 1 | 2024-03-24 | 602.35 | 15.06 | 2024-03-12 | 1 | 601.74 | 1 | 602.35 | 14 | SO58946 | 2024-03-19 | 48.19 | 601.74 | 602.35 | |||
SO58946_15 | F9DD-426F-9A | PO12470155874 | 100 | 287 | 573 | 672 | 1 | 2024-03-24 | 4291.33 | 107.28 | 2024-03-12 | 3 | 1481.94 | 1 | 4291.33 | 15 | SO58946 | 2024-03-19 | 343.31 | 4445.81 | 1430.44 | |||
SO58946_16 | F9DD-426F-9A | PO12470155874 | 100 | 287 | 566 | 672 | 1 | 2024-03-24 | 445.41 | 11.14 | 2024-03-12 | 1 | 461.44 | 1 | 445.41 | 16 | SO58946 | 2024-03-19 | 35.63 | 461.44 | 445.41 | |||
SO58946_17 | F9DD-426F-9A | PO12470155874 | 100 | 287 | 492 | 672 | 1 | 2024-03-24 | 2409.38 | 60.23 | 2024-03-12 | 4 | 601.74 | 1 | 2409.38 | 17 | SO58946 | 2024-03-19 | 192.75 | 2406.97 | 602.35 | |||
SO58946_18 | F9DD-426F-9A | PO12470155874 | 100 | 287 | 506 | 672 | 1 | 2024-03-24 | 200.05 | 5.00 | 2024-03-12 | 1 | 199.85 | 1 | 200.05 | 18 | SO58946 | 2024-03-19 | 16.00 | 199.85 | 200.05 | |||
SO58946_19 | F9DD-426F-9A | PO12470155874 | 100 | 287 | 498 | 672 | 1 | 2024-03-24 | 602.35 | 15.06 | 2024-03-12 | 1 | 601.74 | 1 | 602.35 | 19 | SO58946 | 2024-03-19 | 48.19 | 601.74 | 602.35 | |||
SO58946_20 | F9DD-426F-9A | PO12470155874 | 100 | 287 | 562 | 672 | 1 | 2024-03-24 | 2860.88 | 71.52 | 2024-03-12 | 2 | 1481.94 | 1 | 2860.88 | 20 | SO58946 | 2024-03-19 | 228.87 | 2963.88 | 1430.44 | |||
SO58946_21 | F9DD-426F-9A | PO12470155874 | 100 | 287 | 569 | 672 | 1 | 2024-03-24 | 890.82 | 22.27 | 2024-03-12 | 2 | 461.44 | 1 | 890.82 | 21 | SO58946 | 2024-03-19 | 71.27 | 922.89 | 445.41 | |||
SO58946_22 | F9DD-426F-9A | PO12470155874 | 100 | 287 | 579 | 2 | 672 | 1 | 169.11 | 2024-03-24 | 8455.36 | 207.16 | 2024-03-12 | 12 | 755.15 | 1 | 8286.25 | 22 | SO58946 | 2024-03-19 | 662.90 | 9061.81 | 704.61 | 0.02 |
SO58946_23 | F9DD-426F-9A | PO12470155874 | 100 | 287 | 477 | 672 | 1 | 2024-03-24 | 2.99 | 0.07 | 2024-03-12 | 1 | 1.87 | 1 | 2.99 | 23 | SO58946 | 2024-03-19 | 0.24 | 1.87 | 2.99 | |||
SO58946_24 | F9DD-426F-9A | PO12470155874 | 100 | 287 | 560 | 672 | 1 | 2024-03-24 | 4373.46 | 109.34 | 2024-03-12 | 6 | 755.15 | 1 | 4373.46 | 24 | SO58946 | 2024-03-19 | 349.88 | 4530.90 | 728.91 | |||
SO58946_25 | F9DD-426F-9A | PO12470155874 | 100 | 287 | 586 | 672 | 1 | 2024-03-24 | 890.82 | 22.27 | 2024-03-12 | 2 | 461.44 | 1 | 890.82 | 25 | SO58946 | 2024-03-19 | 71.27 | 922.89 | 445.41 | |||
SO58946_26 | F9DD-426F-9A | PO12470155874 | 100 | 287 | 572 | 672 | 1 | 2024-03-24 | 2672.46 | 66.81 | 2024-03-12 | 6 | 461.44 | 1 | 2672.46 | 26 | SO58946 | 2024-03-19 | 213.80 | 2768.67 | 445.41 | |||
SO49112_2 | 6ADE-4BB3-8A | PO14529148314 | 100 | 293 | 470 | 289 | 1 | 2023-05-26 | 91.18 | 2.28 | 2023-05-14 | 4 | 15.67 | 1 | 91.18 | 2 | SO49112 | 2023-05-21 | 7.29 | 62.68 | 22.79 | |||
SO49112_3 | 6ADE-4BB3-8A | PO14529148314 | 100 | 293 | 469 | 289 | 1 | 2023-05-26 | 22.79 | 0.57 | 2023-05-14 | 1 | 15.67 | 1 | 22.79 | 3 | SO49112 | 2023-05-21 | 1.82 | 15.67 | 22.79 | |||
SO49112_4 | 6ADE-4BB3-8A | PO14529148314 | 100 | 293 | 358 | 289 | 1 | 2023-05-26 | 1229.46 | 30.74 | 2023-05-14 | 1 | 1105.81 | 1 | 1229.46 | 4 | SO49112 | 2023-05-21 | 98.36 | 1105.81 | 1229.46 | |||
SO49112_5 | 6ADE-4BB3-8A | PO14529148314 | 100 | 293 | 468 | 289 | 1 | 2023-05-26 | 22.79 | 0.57 | 2023-05-14 | 1 | 15.67 | 1 | 22.79 | 5 | SO49112 | 2023-05-21 | 1.82 | 15.67 | 22.79 | |||
SO49114_1 | 354C-48D4-9B | PO15631175128 | 100 | 282 | 470 | 43 | 1 | 2023-05-26 | 227.94 | 5.70 | 2023-05-14 | 10 | 15.67 | 1 | 227.94 | 1 | SO49114 | 2023-05-21 | 18.24 | 156.71 | 22.79 | |||
SO49114_2 | 354C-48D4-9B | PO15631175128 | 100 | 282 | 356 | 43 | 1 | 2023-05-26 | 4971.41 | 124.29 | 2023-05-14 | 4 | 1117.86 | 1 | 4971.41 | 2 | SO49114 | 2023-05-21 | 397.71 | 4471.42 | 1242.85 | |||
SO49114_3 | 354C-48D4-9B | PO15631175128 | 100 | 282 | 458 | 43 | 1 | 2023-05-26 | 44.99 | 1.12 | 2023-05-14 | 1 | 30.93 | 1 | 44.99 | 3 | SO49114 | 2023-05-21 | 3.60 | 30.93 | 44.99 | |||
SO49114_4 | 354C-48D4-9B | PO15631175128 | 100 | 282 | 409 | 43 | 1 | 2023-05-26 | 627.77 | 15.69 | 2023-05-14 | 3 | 185.82 | 1 | 627.77 | 4 | SO49114 | 2023-05-21 | 50.22 | 557.46 | 209.26 | |||
SO49114_5 | 354C-48D4-9B | PO15631175128 | 100 | 282 | 362 | 43 | 1 | 2023-05-26 | 4917.84 | 122.95 | 2023-05-14 | 4 | 1105.81 | 1 | 4917.84 | 5 | SO49114 | 2023-05-21 | 393.43 | 4423.24 | 1229.46 | |||
SO49114_6 | 354C-48D4-9B | PO15631175128 | 100 | 282 | 358 | 43 | 1 | 2023-05-26 | 4917.84 | 122.95 | 2023-05-14 | 4 | 1105.81 | 1 | 4917.84 | 6 | SO49114 | 2023-05-21 | 393.43 | 4423.24 | 1229.46 | |||
SO49114_7 | 354C-48D4-9B | PO15631175128 | 100 | 282 | 469 | 43 | 1 | 2023-05-26 | 227.94 | 5.70 | 2023-05-14 | 10 | 15.67 | 1 | 227.94 | 7 | SO49114 | 2023-05-21 | 18.24 | 156.71 | 22.79 | |||
SO49114_8 | 354C-48D4-9B | PO15631175128 | 100 | 282 | 360 | 43 | 1 | 2023-05-26 | 7376.75 | 184.42 | 2023-05-14 | 6 | 1105.81 | 1 | 7376.75 | 8 | SO49114 | 2023-05-21 | 590.14 | 6634.86 | 1229.46 |
Generated 2024-11-10 15:46:32.849 UTC