[ROOT] dt FactResellerSale < WHERE DimSalesTerritoryId EQ '5' > < SKIP 1359 > < 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 |
---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
SO63181_2 | CB4E-4CF5-87 | PO2842135731 | 100 | 285 | 225 | 700 | 5 | 2024-04-05 | 32.36 | 0.81 | 2024-03-24 | 6 | 6.92 | 1 | 32.36 | 2 | SO63181 | 2024-03-31 | 2.59 | 41.53 | 5.39 |
SO44319_2 | FBB9-4CD9-A1 | PO9657142761 | 100 | 285 | 235 | 315 | 5 | 2021-12-04 | 28.84 | 0.72 | 2021-11-22 | 1 | 31.72 | 1 | 28.84 | 2 | SO44319 | 2021-11-29 | 2.31 | 31.72 | 28.84 |
SO48051_21 | D18B-421F-99 | PO3596190178 | 100 | 285 | 419 | 476 | 5 | 2023-01-04 | 157.94 | 3.95 | 2022-12-23 | 3 | 38.96 | 1 | 157.94 | 21 | SO48051 | 2022-12-30 | 12.64 | 116.88 | 52.65 |
SO63181_3 | CB4E-4CF5-87 | PO2842135731 | 100 | 285 | 472 | 700 | 5 | 2024-04-05 | 152.40 | 3.81 | 2024-03-24 | 4 | 23.75 | 1 | 152.40 | 3 | SO63181 | 2024-03-31 | 12.19 | 95.00 | 38.10 |
SO44319_3 | FBB9-4CD9-A1 | PO9657142761 | 100 | 285 | 215 | 315 | 5 | 2021-12-04 | 40.37 | 1.01 | 2021-11-22 | 2 | 12.03 | 1 | 40.37 | 3 | SO44319 | 2021-11-29 | 3.23 | 24.06 | 20.19 |
SO48051_22 | D18B-421F-99 | PO3596190178 | 100 | 285 | 470 | 476 | 5 | 2023-01-04 | 113.97 | 2.85 | 2022-12-23 | 5 | 15.67 | 1 | 113.97 | 22 | SO48051 | 2022-12-30 | 9.12 | 78.35 | 22.79 |
SO63181_4 | CB4E-4CF5-87 | PO2842135731 | 100 | 285 | 605 | 700 | 5 | 2024-04-05 | 323.99 | 8.10 | 2024-03-24 | 1 | 343.65 | 1 | 323.99 | 4 | SO63181 | 2024-03-31 | 25.92 | 343.65 | 323.99 |
SO44319_4 | FBB9-4CD9-A1 | PO9657142761 | 100 | 285 | 212 | 315 | 5 | 2021-12-04 | 20.19 | 0.50 | 2021-11-22 | 1 | 12.03 | 1 | 20.19 | 4 | SO44319 | 2021-11-29 | 1.61 | 12.03 | 20.19 |
SO48051_23 | D18B-421F-99 | PO3596190178 | 100 | 285 | 360 | 476 | 5 | 2023-01-04 | 6147.29 | 153.68 | 2022-12-23 | 5 | 1105.81 | 1 | 6147.29 | 23 | SO48051 | 2022-12-30 | 491.78 | 5529.05 | 1229.46 |
SO63181_5 | CB4E-4CF5-87 | PO2842135731 | 100 | 285 | 547 | 700 | 5 | 2024-04-05 | 97.19 | 2.43 | 2024-03-24 | 2 | 35.96 | 1 | 97.19 | 5 | SO63181 | 2024-03-31 | 7.78 | 71.92 | 48.59 |
SO44319_5 | FBB9-4CD9-A1 | PO9657142761 | 100 | 285 | 220 | 315 | 5 | 2021-12-04 | 40.37 | 1.01 | 2021-11-22 | 2 | 12.03 | 1 | 40.37 | 5 | SO44319 | 2021-11-29 | 3.23 | 24.06 | 20.19 |
SO48051_24 | D18B-421F-99 | PO3596190178 | 100 | 285 | 410 | 476 | 5 | 2023-01-04 | 72.89 | 1.82 | 2022-12-23 | 2 | 26.97 | 1 | 72.89 | 24 | SO48051 | 2022-12-30 | 5.83 | 53.94 | 36.45 |
SO63181_6 | CB4E-4CF5-87 | PO2842135731 | 100 | 285 | 484 | 700 | 5 | 2024-04-05 | 23.85 | 0.60 | 2024-03-24 | 5 | 2.97 | 1 | 23.85 | 6 | SO63181 | 2024-03-31 | 1.91 | 14.87 | 4.77 |
SO44319_6 | FBB9-4CD9-A1 | PO9657142761 | 100 | 285 | 349 | 315 | 5 | 2021-12-04 | 8099.98 | 202.50 | 2021-11-22 | 4 | 1898.09 | 1 | 8099.98 | 6 | SO44319 | 2021-11-29 | 648.00 | 7592.38 | 2024.99 |
SO48061_1 | 40FD-4ECE-9E | PO5278186734 | 100 | 285 | 333 | 224 | 5 | 2023-01-04 | 939.59 | 23.49 | 2022-12-23 | 2 | 486.71 | 1 | 939.59 | 1 | SO48061 | 2022-12-30 | 75.17 | 973.41 | 469.79 |
SO63181_7 | CB4E-4CF5-87 | PO2842135731 | 100 | 285 | 234 | 700 | 5 | 2024-04-05 | 59.99 | 1.50 | 2024-03-24 | 2 | 38.49 | 1 | 59.99 | 7 | SO63181 | 2024-03-31 | 4.80 | 76.98 | 29.99 |
SO44319_7 | FBB9-4CD9-A1 | PO9657142761 | 100 | 285 | 232 | 315 | 5 | 2021-12-04 | 115.36 | 2.88 | 2021-11-22 | 4 | 31.72 | 1 | 115.36 | 7 | SO44319 | 2021-11-29 | 9.23 | 126.90 | 28.84 |
SO48062_1 | DB45-43CB-82 | PO5568119115 | 100 | 285 | 468 | 422 | 5 | 2023-01-04 | 45.59 | 1.14 | 2022-12-23 | 2 | 15.67 | 1 | 45.59 | 1 | SO48062 | 2022-12-30 | 3.65 | 31.34 | 22.79 |
SO63181_8 | CB4E-4CF5-87 | PO2842135731 | 100 | 285 | 482 | 700 | 5 | 2024-04-05 | 26.97 | 0.67 | 2024-03-24 | 5 | 3.36 | 1 | 26.97 | 8 | SO63181 | 2024-03-31 | 2.16 | 16.81 | 5.39 |
SO44319_8 | FBB9-4CD9-A1 | PO9657142761 | 100 | 285 | 348 | 315 | 5 | 2021-12-04 | 4049.99 | 101.25 | 2021-11-22 | 2 | 1898.09 | 1 | 4049.99 | 8 | SO44319 | 2021-11-29 | 324.00 | 3796.19 | 2024.99 |
SO48062_2 | DB45-43CB-82 | PO5568119115 | 100 | 285 | 356 | 422 | 5 | 2023-01-04 | 2485.70 | 62.14 | 2022-12-23 | 2 | 1117.86 | 1 | 2485.70 | 2 | SO48062 | 2022-12-30 | 198.86 | 2235.71 | 1242.85 |
SO63181_9 | CB4E-4CF5-87 | PO2842135731 | 100 | 285 | 376 | 700 | 5 | 2024-04-05 | 4398.03 | 109.95 | 2024-03-24 | 3 | 1554.95 | 1 | 4398.03 | 9 | SO63181 | 2024-03-31 | 351.84 | 4664.84 | 1466.01 |
SO44319_9 | FBB9-4CD9-A1 | PO9657142761 | 100 | 285 | 292 | 315 | 5 | 2021-12-04 | 818.70 | 20.47 | 2021-11-22 | 1 | 706.81 | 1 | 818.70 | 9 | SO44319 | 2021-11-29 | 65.50 | 706.81 | 818.70 |
SO48062_3 | DB45-43CB-82 | PO5568119115 | 100 | 285 | 456 | 422 | 5 | 2023-01-04 | 134.98 | 3.37 | 2022-12-23 | 3 | 30.93 | 1 | 134.98 | 3 | SO48062 | 2022-12-30 | 10.80 | 92.80 | 44.99 |
SO63181_10 | CB4E-4CF5-87 | PO2842135731 | 100 | 285 | 604 | 700 | 5 | 2024-04-05 | 647.99 | 16.20 | 2024-03-24 | 2 | 343.65 | 1 | 647.99 | 10 | SO63181 | 2024-03-31 | 51.84 | 687.30 | 323.99 |
SO44319_10 | FBB9-4CD9-A1 | PO9657142761 | 100 | 285 | 223 | 315 | 5 | 2021-12-04 | 5.19 | 0.13 | 2021-11-22 | 1 | 5.71 | 1 | 5.19 | 10 | SO44319 | 2021-11-29 | 0.41 | 5.71 | 5.19 |
SO48062_4 | DB45-43CB-82 | PO5568119115 | 100 | 285 | 358 | 422 | 5 | 2023-01-04 | 6147.29 | 153.68 | 2022-12-23 | 5 | 1105.81 | 1 | 6147.29 | 4 | SO48062 | 2022-12-30 | 491.78 | 5529.05 | 1229.46 |
SO63181_11 | CB4E-4CF5-87 | PO2842135731 | 100 | 285 | 222 | 700 | 5 | 2024-04-05 | 167.95 | 4.20 | 2024-03-24 | 8 | 13.09 | 1 | 167.95 | 11 | SO63181 | 2024-03-31 | 13.44 | 104.69 | 20.99 |
SO44319_11 | FBB9-4CD9-A1 | PO9657142761 | 100 | 285 | 350 | 315 | 5 | 2021-12-04 | 12149.96 | 303.75 | 2021-11-22 | 6 | 1898.09 | 1 | 12149.96 | 11 | SO44319 | 2021-11-29 | 972.00 | 11388.57 | 2024.99 |
SO48062_5 | DB45-43CB-82 | PO5568119115 | 100 | 285 | 469 | 422 | 5 | 2023-01-04 | 136.76 | 3.42 | 2022-12-23 | 6 | 15.67 | 1 | 136.76 | 5 | SO48062 | 2022-12-30 | 10.94 | 94.03 | 22.79 |
SO63181_12 | CB4E-4CF5-87 | PO2842135731 | 100 | 285 | 546 | 700 | 5 | 2024-04-05 | 111.76 | 2.79 | 2024-03-24 | 3 | 27.57 | 1 | 111.76 | 12 | SO63181 | 2024-03-31 | 8.94 | 82.70 | 37.25 |
Generated 2024-09-21 09:25:41.963 UTC