[ROOT] dt FactResellerSale < WHERE DimSalesTerritoryId EQ '6' > < SKIP 3000 > < 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 |
---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
SO65164_35 | 07B8-4AF8-8A | PO18299114573 | 19 | 291 | 231 | 118 | 6 | 2024-05-17 | 59.99 | 1.50 | 2024-05-05 | 2 | 38.49 | 1 | 59.99 | 35 | SO65164 | 2024-05-12 | 4.80 | 76.98 | 29.99 |
SO65164_36 | 07B8-4AF8-8A | PO18299114573 | 19 | 291 | 237 | 118 | 6 | 2024-05-17 | 89.98 | 2.25 | 2024-05-05 | 3 | 38.49 | 1 | 89.98 | 36 | SO65164 | 2024-05-12 | 7.20 | 115.48 | 29.99 |
SO65164_37 | 07B8-4AF8-8A | PO18299114573 | 19 | 291 | 214 | 118 | 6 | 2024-05-17 | 83.98 | 2.10 | 2024-05-05 | 4 | 13.09 | 1 | 83.98 | 37 | SO65164 | 2024-05-12 | 6.72 | 52.35 | 20.99 |
SO65164_38 | 07B8-4AF8-8A | PO18299114573 | 19 | 291 | 544 | 118 | 6 | 2024-05-17 | 97.19 | 2.43 | 2024-05-05 | 2 | 35.96 | 1 | 97.19 | 38 | SO65164 | 2024-05-12 | 7.78 | 71.92 | 48.59 |
SO65164_39 | 07B8-4AF8-8A | PO18299114573 | 19 | 291 | 511 | 118 | 6 | 2024-05-17 | 436.91 | 10.92 | 2024-05-05 | 2 | 199.38 | 1 | 436.91 | 39 | SO65164 | 2024-05-12 | 34.95 | 398.75 | 218.45 |
SO65164_40 | 07B8-4AF8-8A | PO18299114573 | 19 | 291 | 472 | 118 | 6 | 2024-05-17 | 114.30 | 2.86 | 2024-05-05 | 3 | 23.75 | 1 | 114.30 | 40 | SO65164 | 2024-05-12 | 9.14 | 71.25 | 38.10 |
SO65166_1 | FB7B-4351-80 | PO17835116706 | 19 | 291 | 398 | 551 | 6 | 2024-05-17 | 26.72 | 0.67 | 2024-05-05 | 1 | 19.78 | 1 | 26.72 | 1 | SO65166 | 2024-05-12 | 2.14 | 19.78 | 26.72 |
SO65169_1 | B30E-4E74-9F | PO17516119401 | 19 | 291 | 559 | 630 | 6 | 2024-05-17 | 12.14 | 0.30 | 2024-05-05 | 1 | 8.99 | 1 | 12.14 | 1 | SO65169 | 2024-05-12 | 0.97 | 8.99 | 12.14 |
SO44484_2 | 99EE-44F9-BF | PO19691173790 | 19 | 288 | 218 | 353 | 6 | 2022-01-17 | 34.20 | 0.86 | 2022-01-05 | 6 | 3.40 | 1 | 34.20 | 2 | SO44484 | 2022-01-12 | 2.74 | 20.38 | 5.70 |
SO44484_3 | 99EE-44F9-BF | PO19691173790 | 19 | 288 | 219 | 353 | 6 | 2022-01-17 | 5.70 | 0.14 | 2022-01-05 | 1 | 3.40 | 1 | 5.70 | 3 | SO44484 | 2022-01-12 | 0.46 | 3.40 | 5.70 |
SO44484_4 | 99EE-44F9-BF | PO19691173790 | 19 | 288 | 344 | 353 | 6 | 2022-01-17 | 2039.99 | 51.00 | 2022-01-05 | 1 | 1912.15 | 1 | 2039.99 | 4 | SO44484 | 2022-01-12 | 163.20 | 1912.15 | 2039.99 |
SO44484_5 | 99EE-44F9-BF | PO19691173790 | 19 | 288 | 350 | 353 | 6 | 2022-01-17 | 2024.99 | 50.62 | 2022-01-05 | 1 | 1898.09 | 1 | 2024.99 | 5 | SO44484 | 2022-01-12 | 162.00 | 1898.09 | 2024.99 |
SO44485_1 | 3A5D-4384-BA | PO20242116788 | 19 | 284 | 349 | 390 | 6 | 2022-01-17 | 4049.99 | 101.25 | 2022-01-05 | 2 | 1898.09 | 1 | 4049.99 | 1 | SO44485 | 2022-01-12 | 324.00 | 3796.19 | 2024.99 |
SO44486_1 | DC9F-4F79-B1 | PO19430111880 | 19 | 284 | 340 | 318 | 6 | 2022-01-17 | 419.46 | 10.49 | 2022-01-05 | 1 | 413.15 | 1 | 419.46 | 1 | SO44486 | 2022-01-12 | 33.56 | 413.15 | 419.46 |
SO44486_2 | DC9F-4F79-B1 | PO19430111880 | 19 | 284 | 272 | 318 | 6 | 2022-01-17 | 183.94 | 4.60 | 2022-01-05 | 1 | 181.49 | 1 | 183.94 | 2 | SO44486 | 2022-01-12 | 14.72 | 181.49 | 183.94 |
SO44490_1 | 0CC4-4097-80 | PO19227160482 | 19 | 284 | 322 | 210 | 6 | 2022-01-17 | 419.46 | 10.49 | 2022-01-05 | 1 | 413.15 | 1 | 419.46 | 1 | SO44490 | 2022-01-12 | 33.56 | 413.15 | 419.46 |
SO44490_2 | 0CC4-4097-80 | PO19227160482 | 19 | 284 | 223 | 210 | 6 | 2022-01-17 | 5.19 | 0.13 | 2022-01-05 | 1 | 5.71 | 1 | 5.19 | 2 | SO44490 | 2022-01-12 | 0.41 | 5.71 | 5.19 |
SO44490_3 | 0CC4-4097-80 | PO19227160482 | 19 | 284 | 324 | 210 | 6 | 2022-01-17 | 838.92 | 20.97 | 2022-01-05 | 2 | 413.15 | 1 | 838.92 | 3 | SO44490 | 2022-01-12 | 67.11 | 826.29 | 419.46 |
SO44490_4 | 0CC4-4097-80 | PO19227160482 | 19 | 284 | 326 | 210 | 6 | 2022-01-17 | 419.46 | 10.49 | 2022-01-05 | 1 | 413.15 | 1 | 419.46 | 4 | SO44490 | 2022-01-12 | 33.56 | 413.15 | 419.46 |
SO44490_5 | 0CC4-4097-80 | PO19227160482 | 19 | 284 | 328 | 210 | 6 | 2022-01-17 | 838.92 | 20.97 | 2022-01-05 | 2 | 413.15 | 1 | 838.92 | 5 | SO44490 | 2022-01-12 | 67.11 | 826.29 | 419.46 |
SO44490_6 | 0CC4-4097-80 | PO19227160482 | 19 | 284 | 332 | 210 | 6 | 2022-01-17 | 838.92 | 20.97 | 2022-01-05 | 2 | 413.15 | 1 | 838.92 | 6 | SO44490 | 2022-01-12 | 67.11 | 826.29 | 419.46 |
SO44490_7 | 0CC4-4097-80 | PO19227160482 | 19 | 284 | 232 | 210 | 6 | 2022-01-17 | 28.84 | 0.72 | 2022-01-05 | 1 | 31.72 | 1 | 28.84 | 7 | SO44490 | 2022-01-12 | 2.31 | 31.72 | 28.84 |
SO44495_1 | 7929-4E62-AE | PO18270111190 | 19 | 288 | 219 | 11 | 6 | 2022-01-17 | 11.40 | 0.29 | 2022-01-05 | 2 | 3.40 | 1 | 11.40 | 1 | SO44495 | 2022-01-12 | 0.91 | 6.79 | 5.70 |
SO44495_2 | 7929-4E62-AE | PO18270111190 | 19 | 288 | 345 | 11 | 6 | 2022-01-17 | 2039.99 | 51.00 | 2022-01-05 | 1 | 1912.15 | 1 | 2039.99 | 2 | SO44495 | 2022-01-12 | 163.20 | 1912.15 | 2039.99 |
SO44495_3 | 7929-4E62-AE | PO18270111190 | 19 | 288 | 351 | 11 | 6 | 2022-01-17 | 2024.99 | 50.62 | 2022-01-05 | 1 | 1898.09 | 1 | 2024.99 | 3 | SO44495 | 2022-01-12 | 162.00 | 1898.09 | 2024.99 |
SO44496_1 | 6ADA-4A25-AA | PO18415194469 | 19 | 288 | 332 | 191 | 6 | 2022-01-17 | 419.46 | 10.49 | 2022-01-05 | 1 | 413.15 | 1 | 419.46 | 1 | SO44496 | 2022-01-12 | 33.56 | 413.15 | 419.46 |
SO44496_2 | 6ADA-4A25-AA | PO18415194469 | 19 | 288 | 314 | 191 | 6 | 2022-01-17 | 4293.92 | 107.35 | 2022-01-05 | 2 | 2171.29 | 1 | 4293.92 | 2 | SO44496 | 2022-01-12 | 343.51 | 4342.59 | 2146.96 |
SO44496_3 | 6ADA-4A25-AA | PO18415194469 | 19 | 288 | 313 | 191 | 6 | 2022-01-17 | 2146.96 | 53.67 | 2022-01-05 | 1 | 2171.29 | 1 | 2146.96 | 3 | SO44496 | 2022-01-12 | 171.76 | 2171.29 | 2146.96 |
SO44496_4 | 6ADA-4A25-AA | PO18415194469 | 19 | 288 | 312 | 191 | 6 | 2022-01-17 | 2146.96 | 53.67 | 2022-01-05 | 1 | 2171.29 | 1 | 2146.96 | 4 | SO44496 | 2022-01-12 | 171.76 | 2171.29 | 2146.96 |
SO44496_5 | 6ADA-4A25-AA | PO18415194469 | 19 | 288 | 328 | 191 | 6 | 2022-01-17 | 419.46 | 10.49 | 2022-01-05 | 1 | 413.15 | 1 | 419.46 | 5 | SO44496 | 2022-01-12 | 33.56 | 413.15 | 419.46 |
SO44496_6 | 6ADA-4A25-AA | PO18415194469 | 19 | 288 | 270 | 191 | 6 | 2022-01-17 | 183.94 | 4.60 | 2022-01-05 | 1 | 181.49 | 1 | 183.94 | 6 | SO44496 | 2022-01-12 | 14.72 | 181.49 | 183.94 |
Generated 2024-10-04 21:58:12.193 UTC