[ROOT] dt FactResellerSale < WHERE DimCurrency.AlternateKey EQ 'CAD' > < SKIP 1000 > < TAKE 15 >
15 items
FactResellerSaleId | CarrierTrackingNumber | CustomerPONumber | DimCurrencyId | DimEmployeeId | DimProductId | DimResellerId | DimSalesTerritoryId | DueDate | ExtendedAmount | Freight | OrderDate | OrderQuantity | ProductStandardCost | RevisionNumber | SalesAmount | SalesOrderLineNumber | SalesOrderNumber | ShipDate | TaxAmt | TotalProductCost | UnitPrice |
---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
SO61177_25 | DA64-4BC0-A0 | PO18473117778 | 19 | 291 | 558 | 442 | 6 | 2024-03-19 | 242.99 | 6.07 | 2024-03-07 | 1 | 179.82 | 1 | 242.99 | 25 | SO61177 | 2024-03-14 | 19.44 | 179.82 | 242.99 |
SO43882_1 | 8137-47B8-9B | PO10469165208 | 19 | 288 | 351 | 335 | 6 | 2021-10-18 | 2024.99 | 50.62 | 2021-10-06 | 1 | 1898.09 | 1 | 2024.99 | 1 | SO43882 | 2021-10-13 | 162.00 | 1898.09 | 2024.99 |
SO47973_20 | B9F1-47DA-87 | PO18705118148 | 19 | 291 | 387 | 479 | 6 | 2023-01-18 | 1200.53 | 30.01 | 2023-01-06 | 2 | 605.65 | 1 | 1200.53 | 20 | SO47973 | 2023-01-13 | 96.04 | 1211.30 | 600.26 |
SO61179_1 | 1443-4268-AC | PO18444157069 | 19 | 291 | 255 | 227 | 6 | 2024-03-19 | 607.00 | 15.17 | 2024-03-07 | 3 | 204.63 | 1 | 607.00 | 1 | SO61179 | 2024-03-14 | 48.56 | 613.88 | 202.33 |
SO43886_1 | CE58-49B5-82 | PO1827149671 | 19 | 288 | 315 | 317 | 6 | 2021-10-18 | 1749.59 | 43.74 | 2021-10-06 | 2 | 884.71 | 1 | 1749.59 | 1 | SO43886 | 2021-10-13 | 139.97 | 1769.42 | 874.79 |
SO47973_21 | B9F1-47DA-87 | PO18705118148 | 19 | 291 | 236 | 479 | 6 | 2023-01-18 | 144.20 | 3.61 | 2023-01-06 | 5 | 29.08 | 1 | 144.20 | 21 | SO47973 | 2023-01-13 | 11.54 | 145.40 | 28.84 |
SO61179_2 | 1443-4268-AC | PO18444157069 | 19 | 291 | 480 | 227 | 6 | 2024-03-19 | 4.12 | 0.10 | 2024-03-07 | 3 | 0.86 | 1 | 4.12 | 2 | SO61179 | 2024-03-14 | 0.33 | 2.57 | 1.37 |
SO43886_2 | CE58-49B5-82 | PO1827149671 | 19 | 288 | 328 | 317 | 6 | 2021-10-18 | 419.46 | 10.49 | 2021-10-06 | 1 | 413.15 | 1 | 419.46 | 2 | SO43886 | 2021-10-13 | 33.56 | 413.15 | 419.46 |
SO47973_22 | B9F1-47DA-87 | PO18705118148 | 19 | 291 | 221 | 479 | 6 | 2023-01-18 | 161.49 | 4.04 | 2023-01-06 | 8 | 13.88 | 1 | 161.49 | 22 | SO47973 | 2023-01-13 | 12.92 | 111.03 | 20.19 |
SO61179_3 | 1443-4268-AC | PO18444157069 | 19 | 291 | 581 | 227 | 6 | 2024-03-19 | 3061.78 | 76.54 | 2024-03-07 | 3 | 1082.51 | 1 | 3061.78 | 3 | SO61179 | 2024-03-14 | 244.94 | 3247.53 | 1020.59 |
SO43886_3 | CE58-49B5-82 | PO1827149671 | 19 | 288 | 264 | 317 | 6 | 2021-10-18 | 367.88 | 9.20 | 2021-10-06 | 2 | 181.49 | 1 | 367.88 | 3 | SO43886 | 2021-10-13 | 29.43 | 362.97 | 183.94 |
SO47973_23 | B9F1-47DA-87 | PO18705118148 | 19 | 291 | 371 | 479 | 6 | 2023-01-18 | 1308.94 | 32.72 | 2023-01-06 | 1 | 1320.68 | 1 | 1308.94 | 23 | SO47973 | 2023-01-13 | 104.72 | 1320.68 | 1308.94 |
SO61179_4 | 1443-4268-AC | PO18444157069 | 19 | 291 | 390 | 227 | 6 | 2024-03-19 | 6050.65 | 151.27 | 2024-03-07 | 9 | 713.08 | 1 | 6050.65 | 4 | SO61179 | 2024-03-14 | 484.05 | 6417.72 | 672.29 |
SO43886_4 | CE58-49B5-82 | PO1827149671 | 19 | 288 | 338 | 317 | 6 | 2021-10-18 | 419.46 | 10.49 | 2021-10-06 | 1 | 413.15 | 1 | 419.46 | 4 | SO43886 | 2021-10-13 | 33.56 | 413.15 | 419.46 |
SO47973_24 | B9F1-47DA-87 | PO18705118148 | 19 | 291 | 389 | 479 | 6 | 2023-01-18 | 1200.53 | 30.01 | 2023-01-06 | 2 | 605.65 | 1 | 1200.53 | 24 | SO47973 | 2023-01-13 | 96.04 | 1211.30 | 600.26 |
Generated 2024-10-05 04:20:53.116 UTC