[ROOT] dt FactResellerSale < WHERE DimCurrency.AlternateKey EQ 'CAD' > SKIP 875 < SKIP 144 > < TAKE 14 >
14 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 |
---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
SO51132_24 | D4A8-472C-A4 | PO18444136544 | 19 | 291 | 482 | 227 | 6 | 2023-10-23 | 16.18 | 0.40 | 2023-10-11 | 3 | 3.36 | 1 | 16.18 | 24 | SO51132 | 2023-10-18 | 1.29 | 10.09 | 5.39 | |||
SO58985_2 | 8414-4012-AB | PO17951195513 | 19 | 284 | 434 | 637 | 6 | 2024-03-24 | 356.90 | 8.92 | 2024-03-12 | 1 | 360.94 | 1 | 356.90 | 2 | SO58985 | 2024-03-19 | 28.55 | 360.94 | 356.90 | |||
SO43898_11 | 420C-4ECE-85 | PO4901196283 | 19 | 284 | 215 | 84 | 6 | 2021-11-23 | 161.49 | 4.04 | 2021-11-11 | 8 | 12.03 | 1 | 161.49 | 11 | SO43898 | 2021-11-18 | 12.92 | 96.22 | 20.19 | |||
SO47708_7 | 86B1-46A5-95 | PO4495147689 | 19 | 291 | 362 | 496 | 6 | 2023-01-23 | 3688.38 | 92.21 | 2023-01-11 | 3 | 1105.81 | 1 | 3688.38 | 7 | SO47708 | 2023-01-18 | 295.07 | 3317.43 | 1229.46 | |||
SO51132_25 | D4A8-472C-A4 | PO18444136544 | 19 | 291 | 404 | 227 | 6 | 2023-10-23 | 26.72 | 0.67 | 2023-10-11 | 1 | 19.78 | 1 | 26.72 | 25 | SO51132 | 2023-10-18 | 2.14 | 19.78 | 26.72 | |||
SO43898_12 | 420C-4ECE-85 | PO4901196283 | 19 | 284 | 322 | 84 | 6 | 2021-11-23 | 1258.38 | 31.46 | 2021-11-11 | 3 | 413.15 | 1 | 1258.38 | 12 | SO43898 | 2021-11-18 | 100.67 | 1239.44 | 419.46 | |||
SO47708_8 | 86B1-46A5-95 | PO4495147689 | 19 | 291 | 420 | 496 | 6 | 2023-01-23 | 849.69 | 21.24 | 2023-01-11 | 6 | 104.80 | 1 | 849.69 | 8 | SO47708 | 2023-01-18 | 67.98 | 628.77 | 141.62 | |||
SO43898_13 | 420C-4ECE-85 | PO4901196283 | 19 | 284 | 232 | 2 | 84 | 6 | 6.13 | 2021-11-23 | 306.67 | 7.51 | 2021-11-11 | 11 | 31.72 | 1 | 300.54 | 13 | SO43898 | 2021-11-18 | 24.04 | 348.97 | 27.88 | 0.02 |
SO47708_9 | 86B1-46A5-95 | PO4495147689 | 19 | 291 | 409 | 496 | 6 | 2023-01-23 | 627.77 | 15.69 | 2023-01-11 | 3 | 185.82 | 1 | 627.77 | 9 | SO47708 | 2023-01-18 | 50.22 | 557.46 | 209.26 | |||
SO43898_14 | 420C-4ECE-85 | PO4901196283 | 19 | 284 | 330 | 84 | 6 | 2021-11-23 | 838.92 | 20.97 | 2021-11-11 | 2 | 413.15 | 1 | 838.92 | 14 | SO43898 | 2021-11-18 | 67.11 | 826.29 | 419.46 | |||
SO47708_10 | 86B1-46A5-95 | PO4495147689 | 19 | 291 | 366 | 496 | 6 | 2023-01-23 | 2591.98 | 64.80 | 2023-01-11 | 4 | 598.44 | 1 | 2591.98 | 10 | SO47708 | 2023-01-18 | 207.36 | 2393.74 | 647.99 | |||
SO43898_15 | 420C-4ECE-85 | PO4901196283 | 19 | 284 | 270 | 84 | 6 | 2021-11-23 | 735.75 | 18.39 | 2021-11-11 | 4 | 181.49 | 1 | 735.75 | 15 | SO43898 | 2021-11-18 | 58.86 | 725.94 | 183.94 | |||
SO47708_11 | 86B1-46A5-95 | PO4495147689 | 19 | 291 | 459 | 496 | 6 | 2023-01-23 | 215.98 | 5.40 | 2023-01-11 | 4 | 37.12 | 1 | 215.98 | 11 | SO47708 | 2023-01-18 | 17.28 | 148.48 | 53.99 | |||
SO43898_16 | 420C-4ECE-85 | PO4901196283 | 19 | 284 | 275 | 84 | 6 | 2021-11-23 | 1070.69 | 26.77 | 2021-11-11 | 3 | 352.14 | 1 | 1070.69 | 16 | SO43898 | 2021-11-18 | 85.66 | 1056.42 | 356.90 |
Generated 2024-11-10 20:19:10.378 UTC