[ROOT] dt FactResellerSale < WHERE DimCurrency.AlternateKey EQ 'CAD' > SKIP 875 < SKIP 375 > < TAKE 31 >
31 items
| FactResellerSaleId | CarrierTrackingNumber | CustomerPONumber | DimCurrencyId | DimEmployeeId | DimProductId | DimResellerId | DimSalesTerritoryId | DueDate | ExtendedAmount | Freight | OrderDate | OrderQuantity | ProductStandardCost | RevisionNumber | SalesAmount | SalesOrderLineNumber | SalesOrderNumber | ShipDate | TaxAmt | TotalProductCost | UnitPrice |
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
| SO44086_20 | B4B4-44C7-84 | PO17574175064 | 19 | 288 | 300 | 678 | 6 | 2021-12-23 | 2429.28 | 60.73 | 2021-12-11 | 3 | 699.09 | 1 | 2429.28 | 20 | SO44086 | 2021-12-18 | 194.34 | 2097.28 | 809.76 |
| SO47708_32 | 86B1-46A5-95 | PO4495147689 | 19 | 291 | 393 | 496 | 6 | 2023-01-22 | 275.39 | 6.88 | 2023-01-10 | 2 | 101.89 | 1 | 275.39 | 32 | SO47708 | 2023-01-17 | 22.03 | 203.79 | 137.69 |
| SO51694_2 | 75B1-457C-8C | PO19691118743 | 19 | 291 | 511 | 353 | 6 | 2023-11-22 | 218.45 | 5.46 | 2023-11-10 | 1 | 199.38 | 1 | 218.45 | 2 | SO51694 | 2023-11-17 | 17.48 | 199.38 | 218.45 |
| SO59042_3 | 8DB9-4316-8F | PO1972174730 | 19 | 291 | 559 | 190 | 6 | 2024-03-23 | 12.14 | 0.30 | 2024-03-11 | 1 | 8.99 | 1 | 12.14 | 3 | SO59042 | 2024-03-18 | 0.97 | 8.99 | 12.14 |
| SO44086_21 | B4B4-44C7-84 | PO17574175064 | 19 | 288 | 293 | 678 | 6 | 2021-12-23 | 2167.78 | 54.19 | 2021-12-11 | 3 | 623.84 | 1 | 2167.78 | 21 | SO44086 | 2021-12-18 | 173.42 | 1871.52 | 722.59 |
| SO47708_33 | 86B1-46A5-95 | PO4495147689 | 19 | 291 | 367 | 496 | 6 | 2023-01-22 | 1295.99 | 32.40 | 2023-01-10 | 2 | 598.44 | 1 | 1295.99 | 33 | SO47708 | 2023-01-17 | 103.68 | 1196.87 | 647.99 |
| SO51694_3 | 75B1-457C-8C | PO19691118743 | 19 | 291 | 476 | 353 | 6 | 2023-11-22 | 251.96 | 6.30 | 2023-11-10 | 6 | 26.18 | 1 | 251.96 | 3 | SO51694 | 2023-11-17 | 20.16 | 157.06 | 41.99 |
| SO59042_4 | 8DB9-4316-8F | PO1972174730 | 19 | 291 | 588 | 190 | 6 | 2024-03-23 | 923.39 | 23.08 | 2024-03-11 | 2 | 419.78 | 1 | 923.39 | 4 | SO59042 | 2024-03-18 | 73.87 | 839.56 | 461.69 |
| SO44094_1 | 5520-4202-8D | PO14877175150 | 19 | 288 | 344 | 172 | 6 | 2021-12-23 | 4079.99 | 102.00 | 2021-12-11 | 2 | 1912.15 | 1 | 4079.99 | 1 | SO44094 | 2021-12-18 | 326.40 | 3824.31 | 2039.99 |
| SO47708_34 | 86B1-46A5-95 | PO4495147689 | 19 | 291 | 470 | 496 | 6 | 2023-01-22 | 113.97 | 2.85 | 2023-01-10 | 5 | 15.67 | 1 | 113.97 | 34 | SO47708 | 2023-01-17 | 9.12 | 78.35 | 22.79 |
| SO51694_4 | 75B1-457C-8C | PO19691118743 | 19 | 291 | 400 | 353 | 6 | 2023-11-22 | 74.30 | 1.86 | 2023-11-10 | 2 | 27.49 | 1 | 74.30 | 4 | SO51694 | 2023-11-17 | 5.94 | 54.99 | 37.15 |
| SO59042_5 | 8DB9-4316-8F | PO1972174730 | 19 | 291 | 593 | 190 | 6 | 2024-03-23 | 1016.98 | 25.42 | 2024-03-11 | 3 | 308.22 | 1 | 1016.98 | 5 | SO59042 | 2024-03-18 | 81.36 | 924.65 | 338.99 |
| SO44103_1 | 5754-4536-B8 | PO11107175113 | 19 | 284 | 342 | 156 | 6 | 2021-12-23 | 1677.84 | 41.95 | 2021-12-11 | 4 | 413.15 | 1 | 1677.84 | 1 | SO44103 | 2021-12-18 | 134.23 | 1652.59 | 419.46 |
| SO47708_35 | 86B1-46A5-95 | PO4495147689 | 19 | 291 | 358 | 496 | 6 | 2023-01-22 | 2458.92 | 61.47 | 2023-01-10 | 2 | 1105.81 | 1 | 2458.92 | 35 | SO47708 | 2023-01-17 | 196.71 | 2211.62 | 1229.46 |
| SO51694_5 | 75B1-457C-8C | PO19691118743 | 19 | 291 | 359 | 353 | 6 | 2023-11-22 | 1376.99 | 34.42 | 2023-11-10 | 1 | 1251.98 | 1 | 1376.99 | 5 | SO51694 | 2023-11-17 | 110.16 | 1251.98 | 1376.99 |
| SO59042_6 | 8DB9-4316-8F | PO1972174730 | 19 | 291 | 597 | 190 | 6 | 2024-03-23 | 323.99 | 8.10 | 2024-03-11 | 1 | 294.58 | 1 | 323.99 | 6 | SO59042 | 2024-03-18 | 25.92 | 294.58 | 323.99 |
| SO44103_2 | 5754-4536-B8 | PO11107175113 | 19 | 284 | 326 | 156 | 6 | 2021-12-23 | 1258.38 | 31.46 | 2021-12-11 | 3 | 413.15 | 1 | 1258.38 | 2 | SO44103 | 2021-12-18 | 100.67 | 1239.44 | 419.46 |
| SO47708_36 | 86B1-46A5-95 | PO4495147689 | 19 | 291 | 396 | 496 | 6 | 2023-01-22 | 224.51 | 5.61 | 2023-01-10 | 3 | 55.38 | 1 | 224.51 | 36 | SO47708 | 2023-01-17 | 17.96 | 166.14 | 74.84 |
| SO51694_6 | 75B1-457C-8C | PO19691118743 | 19 | 291 | 475 | 353 | 6 | 2023-11-22 | 83.99 | 2.10 | 2023-11-10 | 2 | 26.18 | 1 | 83.99 | 6 | SO51694 | 2023-11-17 | 6.72 | 52.35 | 41.99 |
| SO59042_7 | 8DB9-4316-8F | PO1972174730 | 19 | 291 | 525 | 190 | 6 | 2024-03-23 | 316.86 | 7.92 | 2024-03-11 | 2 | 144.59 | 1 | 316.86 | 7 | SO59042 | 2024-03-18 | 25.35 | 289.19 | 158.43 |
| SO44103_3 | 5754-4536-B8 | PO11107175113 | 19 | 284 | 322 | 156 | 6 | 2021-12-23 | 838.92 | 20.97 | 2021-12-11 | 2 | 413.15 | 1 | 838.92 | 3 | SO44103 | 2021-12-18 | 67.11 | 826.29 | 419.46 |
| SO47708_37 | 86B1-46A5-95 | PO4495147689 | 19 | 291 | 294 | 496 | 6 | 2023-01-22 | 1488.55 | 37.21 | 2023-01-10 | 2 | 660.91 | 1 | 1488.55 | 37 | SO47708 | 2023-01-17 | 119.08 | 1321.83 | 744.27 |
| SO51694_7 | 75B1-457C-8C | PO19691118743 | 19 | 291 | 517 | 353 | 6 | 2023-11-22 | 31.58 | 0.79 | 2023-11-10 | 1 | 23.37 | 1 | 31.58 | 7 | SO51694 | 2023-11-17 | 2.53 | 23.37 | 31.58 |
| SO59042_8 | 8DB9-4316-8F | PO1972174730 | 19 | 291 | 543 | 190 | 6 | 2024-03-23 | 74.51 | 1.86 | 2024-03-11 | 2 | 27.57 | 1 | 74.51 | 8 | SO59042 | 2024-03-18 | 5.96 | 55.14 | 37.25 |
| SO44103_4 | 5754-4536-B8 | PO11107175113 | 19 | 284 | 232 | 156 | 6 | 2021-12-23 | 28.84 | 0.72 | 2021-12-11 | 1 | 31.72 | 1 | 28.84 | 4 | SO44103 | 2021-12-18 | 2.31 | 31.72 | 28.84 |
| SO47708_38 | 86B1-46A5-95 | PO4495147689 | 19 | 291 | 391 | 496 | 6 | 2023-01-22 | 177.86 | 4.45 | 2023-01-10 | 2 | 65.81 | 1 | 177.86 | 38 | SO47708 | 2023-01-17 | 14.23 | 131.62 | 88.93 |
| SO51698_1 | C8C8-43A4-AC | PO19227173300 | 19 | 284 | 491 | 210 | 6 | 2023-11-22 | 194.36 | 4.86 | 2023-11-10 | 6 | 41.57 | 1 | 194.36 | 1 | SO51698 | 2023-11-17 | 15.55 | 249.43 | 32.39 |
| SO59043_1 | CA52-44C6-BC | PO2001191738 | 19 | 291 | 281 | 701 | 6 | 2024-03-23 | 202.33 | 5.06 | 2024-03-11 | 1 | 204.63 | 1 | 202.33 | 1 | SO59043 | 2024-03-18 | 16.19 | 204.63 | 202.33 |
| SO44103_5 | 5754-4536-B8 | PO11107175113 | 19 | 284 | 223 | 156 | 6 | 2021-12-23 | 10.37 | 0.26 | 2021-12-11 | 2 | 5.71 | 1 | 10.37 | 5 | SO44103 | 2021-12-18 | 0.83 | 11.41 | 5.19 |
| SO47708_39 | 86B1-46A5-95 | PO4495147689 | 19 | 291 | 236 | 496 | 6 | 2023-01-22 | 230.72 | 5.77 | 2023-01-10 | 8 | 29.08 | 1 | 230.72 | 39 | SO47708 | 2023-01-17 | 18.46 | 232.65 | 28.84 |
| SO51698_2 | C8C8-43A4-AC | PO19227173300 | 19 | 284 | 234 | 210 | 6 | 2023-11-22 | 89.98 | 2.25 | 2023-11-10 | 3 | 38.49 | 1 | 89.98 | 2 | SO51698 | 2023-11-17 | 7.20 | 115.48 | 29.99 |
Generated 2024-11-10 03:19:38.923 UTC