[ROOT] dt FactResellerSale < WHERE DimCurrency.AlternateKey EQ 'CAD' > SKIP 875 < SKIP 3248 > < 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 |
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
| SO58932_1 | CE5B-4A8C-96 | PO14761124028 | 19 | 284 | 502 | 408 | 6 | 2024-03-24 | 600.16 | 15.00 | 2024-03-12 | 3 | 199.85 | 1 | 600.16 | 1 | SO58932 | 2024-03-19 | 48.01 | 599.56 | 200.05 | |||
| SO58932_2 | CE5B-4A8C-96 | PO14761124028 | 19 | 284 | 506 | 408 | 6 | 2024-03-24 | 400.10 | 10.00 | 2024-03-12 | 2 | 199.85 | 1 | 400.10 | 2 | SO58932 | 2024-03-19 | 32.01 | 399.70 | 200.05 | |||
| SO58932_3 | CE5B-4A8C-96 | PO14761124028 | 19 | 284 | 564 | 408 | 6 | 2024-03-24 | 4291.33 | 107.28 | 2024-03-12 | 3 | 1481.94 | 1 | 4291.33 | 3 | SO58932 | 2024-03-19 | 343.31 | 4445.81 | 1430.44 | |||
| SO58932_4 | CE5B-4A8C-96 | PO14761124028 | 19 | 284 | 574 | 408 | 6 | 2024-03-24 | 1430.44 | 35.76 | 2024-03-12 | 1 | 1481.94 | 1 | 1430.44 | 4 | SO58932 | 2024-03-19 | 114.44 | 1481.94 | 1430.44 | |||
| SO58932_5 | CE5B-4A8C-96 | PO14761124028 | 19 | 284 | 507 | 408 | 6 | 2024-03-24 | 200.05 | 5.00 | 2024-03-12 | 1 | 199.85 | 1 | 200.05 | 5 | SO58932 | 2024-03-19 | 16.00 | 199.85 | 200.05 | |||
| SO58932_6 | CE5B-4A8C-96 | PO14761124028 | 19 | 284 | 572 | 408 | 6 | 2024-03-24 | 1336.23 | 33.41 | 2024-03-12 | 3 | 461.44 | 1 | 1336.23 | 6 | SO58932 | 2024-03-19 | 106.90 | 1384.33 | 445.41 | |||
| SO58932_7 | CE5B-4A8C-96 | PO14761124028 | 19 | 284 | 222 | 2 | 408 | 6 | 4.87 | 2024-03-24 | 243.53 | 5.97 | 2024-03-12 | 12 | 13.09 | 1 | 238.66 | 7 | SO58932 | 2024-03-19 | 19.09 | 157.04 | 20.29 | 0.02 |
| SO58932_8 | CE5B-4A8C-96 | PO14761124028 | 19 | 284 | 480 | 408 | 6 | 2024-03-24 | 5.50 | 0.14 | 2024-03-12 | 4 | 0.86 | 1 | 5.50 | 8 | SO58932 | 2024-03-19 | 0.44 | 3.43 | 1.37 | |||
| SO58932_9 | CE5B-4A8C-96 | PO14761124028 | 19 | 284 | 503 | 408 | 6 | 2024-03-24 | 200.05 | 5.00 | 2024-03-12 | 1 | 199.85 | 1 | 200.05 | 9 | SO58932 | 2024-03-19 | 16.00 | 199.85 | 200.05 | |||
| SO58932_10 | CE5B-4A8C-96 | PO14761124028 | 19 | 284 | 231 | 408 | 6 | 2024-03-24 | 119.98 | 3.00 | 2024-03-12 | 4 | 38.49 | 1 | 119.98 | 10 | SO58932 | 2024-03-19 | 9.60 | 153.97 | 29.99 | |||
| SO58932_11 | CE5B-4A8C-96 | PO14761124028 | 19 | 284 | 237 | 408 | 6 | 2024-03-24 | 89.98 | 2.25 | 2024-03-12 | 3 | 38.49 | 1 | 89.98 | 11 | SO58932 | 2024-03-19 | 7.20 | 115.48 | 29.99 | |||
| SO58932_12 | CE5B-4A8C-96 | PO14761124028 | 19 | 284 | 225 | 2 | 408 | 6 | 1.15 | 2024-03-24 | 57.36 | 1.41 | 2024-03-12 | 11 | 6.92 | 1 | 56.21 | 12 | SO58932 | 2024-03-19 | 4.50 | 76.15 | 5.21 | 0.02 |
| SO58932_13 | CE5B-4A8C-96 | PO14761124028 | 19 | 284 | 484 | 408 | 6 | 2024-03-24 | 47.70 | 1.19 | 2024-03-12 | 10 | 2.97 | 1 | 47.70 | 13 | SO58932 | 2024-03-19 | 3.82 | 29.73 | 4.77 | |||
| SO58932_14 | CE5B-4A8C-96 | PO14761124028 | 19 | 284 | 560 | 408 | 6 | 2024-03-24 | 5831.28 | 145.78 | 2024-03-12 | 8 | 755.15 | 1 | 5831.28 | 14 | SO58932 | 2024-03-19 | 466.50 | 6041.21 | 728.91 | |||
| SO58932_15 | CE5B-4A8C-96 | PO14761124028 | 19 | 284 | 472 | 408 | 6 | 2024-03-24 | 304.80 | 7.62 | 2024-03-12 | 8 | 23.75 | 1 | 304.80 | 15 | SO58932 | 2024-03-19 | 24.38 | 189.99 | 38.10 | |||
| SO58932_16 | CE5B-4A8C-96 | PO14761124028 | 19 | 284 | 499 | 408 | 6 | 2024-03-24 | 2409.38 | 60.23 | 2024-03-12 | 4 | 601.74 | 1 | 2409.38 | 16 | SO58932 | 2024-03-19 | 192.75 | 2406.97 | 602.35 | |||
| SO58932_17 | CE5B-4A8C-96 | PO14761124028 | 19 | 284 | 491 | 408 | 6 | 2024-03-24 | 226.76 | 5.67 | 2024-03-12 | 7 | 41.57 | 1 | 226.76 | 17 | SO58932 | 2024-03-19 | 18.14 | 291.01 | 32.39 | |||
| SO58932_18 | CE5B-4A8C-96 | PO14761124028 | 19 | 284 | 477 | 408 | 6 | 2024-03-24 | 29.94 | 0.75 | 2024-03-12 | 10 | 1.87 | 1 | 29.94 | 18 | SO58932 | 2024-03-19 | 2.40 | 18.66 | 2.99 | |||
| SO58932_19 | CE5B-4A8C-96 | PO14761124028 | 19 | 284 | 568 | 408 | 6 | 2024-03-24 | 2672.46 | 66.81 | 2024-03-12 | 6 | 461.44 | 1 | 2672.46 | 19 | SO58932 | 2024-03-19 | 213.80 | 2768.67 | 445.41 | |||
| SO58932_20 | CE5B-4A8C-96 | PO14761124028 | 19 | 284 | 562 | 408 | 6 | 2024-03-24 | 2860.88 | 71.52 | 2024-03-12 | 2 | 1481.94 | 1 | 2860.88 | 20 | SO58932 | 2024-03-19 | 228.87 | 2963.88 | 1430.44 | |||
| SO58932_21 | CE5B-4A8C-96 | PO14761124028 | 19 | 284 | 465 | 408 | 6 | 2024-03-24 | 29.39 | 0.73 | 2024-03-12 | 2 | 9.16 | 1 | 29.39 | 21 | SO58932 | 2024-03-19 | 2.35 | 18.32 | 14.69 | |||
| SO58932_22 | CE5B-4A8C-96 | PO14761124028 | 19 | 284 | 523 | 408 | 6 | 2024-03-24 | 31.58 | 0.79 | 2024-03-12 | 1 | 23.37 | 1 | 31.58 | 22 | SO58932 | 2024-03-19 | 2.53 | 23.37 | 31.58 | |||
| SO58932_23 | CE5B-4A8C-96 | PO14761124028 | 19 | 284 | 467 | 408 | 6 | 2024-03-24 | 29.39 | 0.73 | 2024-03-12 | 2 | 9.16 | 1 | 29.39 | 23 | SO58932 | 2024-03-19 | 2.35 | 18.32 | 14.69 | |||
| SO58932_24 | CE5B-4A8C-96 | PO14761124028 | 19 | 284 | 487 | 408 | 6 | 2024-03-24 | 329.94 | 8.25 | 2024-03-12 | 10 | 20.57 | 1 | 329.94 | 24 | SO58932 | 2024-03-19 | 26.40 | 205.66 | 32.99 | |||
| SO58932_25 | CE5B-4A8C-96 | PO14761124028 | 19 | 284 | 577 | 408 | 6 | 2024-03-24 | 1457.82 | 36.45 | 2024-03-12 | 2 | 755.15 | 1 | 1457.82 | 25 | SO58932 | 2024-03-19 | 116.63 | 1510.30 | 728.91 | |||
| SO58932_26 | CE5B-4A8C-96 | PO14761124028 | 19 | 284 | 463 | 408 | 6 | 2024-03-24 | 132.25 | 3.31 | 2024-03-12 | 9 | 9.16 | 1 | 132.25 | 26 | SO58932 | 2024-03-19 | 10.58 | 82.43 | 14.69 | |||
| SO58932_27 | CE5B-4A8C-96 | PO14761124028 | 19 | 284 | 488 | 408 | 6 | 2024-03-24 | 259.15 | 6.48 | 2024-03-12 | 8 | 41.57 | 1 | 259.15 | 27 | SO58932 | 2024-03-19 | 20.73 | 332.58 | 32.39 | |||
| SO58932_28 | CE5B-4A8C-96 | PO14761124028 | 19 | 284 | 490 | 408 | 6 | 2024-03-24 | 259.15 | 6.48 | 2024-03-12 | 8 | 41.57 | 1 | 259.15 | 28 | SO58932 | 2024-03-19 | 20.73 | 332.58 | 32.39 | |||
| SO58932_29 | CE5B-4A8C-96 | PO14761124028 | 19 | 284 | 579 | 408 | 6 | 2024-03-24 | 2915.64 | 72.89 | 2024-03-12 | 4 | 755.15 | 1 | 2915.64 | 29 | SO58932 | 2024-03-19 | 233.25 | 3020.60 | 728.91 | |||
| SO58932_30 | CE5B-4A8C-96 | PO14761124028 | 19 | 284 | 576 | 2 | 408 | 6 | 359.52 | 2024-03-24 | 17975.89 | 440.41 | 2024-03-12 | 13 | 1481.94 | 1 | 17616.37 | 30 | SO58932 | 2024-03-19 | 1409.31 | 19265.19 | 1382.76 | 0.02 |
| SO58932_31 | CE5B-4A8C-96 | PO14761124028 | 19 | 284 | 471 | 2 | 408 | 6 | 8.84 | 2024-03-24 | 441.96 | 10.83 | 2024-03-12 | 12 | 23.75 | 1 | 433.12 | 31 | SO58932 | 2024-03-19 | 34.65 | 284.99 | 36.83 | 0.02 |
Generated 2024-11-10 14:38:39.196 UTC