[ROOT] dt FactResellerSale < WHERE DimSalesTerritoryId EQ '6' > < SKIP 4655 > < 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 |
---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
SO49039_5 | 4F9E-4A1A-B3 | PO20039119229 | 19 | 291 | 470 | 65 | 6 | 2023-05-28 | 91.18 | 2.28 | 2023-05-16 | 4 | 15.67 | 1 | 91.18 | 5 | SO49039 | 2023-05-23 | 7.29 | 62.68 | 22.79 |
SO45786_26 | C4AF-4371-B7 | PO14732192241 | 19 | 288 | 332 | 514 | 6 | 2022-07-26 | 3775.13 | 94.38 | 2022-07-14 | 9 | 413.15 | 1 | 3775.13 | 26 | SO45786 | 2022-07-21 | 302.01 | 3718.32 | 419.46 |
SO49041_1 | F980-4BCB-AB | PO19691174434 | 19 | 291 | 469 | 353 | 6 | 2023-05-28 | 22.79 | 0.57 | 2023-05-16 | 1 | 15.67 | 1 | 22.79 | 1 | SO49041 | 2023-05-23 | 1.82 | 15.67 | 22.79 |
SO45786_27 | C4AF-4371-B7 | PO14732192241 | 19 | 288 | 319 | 514 | 6 | 2022-07-26 | 7873.15 | 196.83 | 2022-07-14 | 9 | 884.71 | 1 | 7873.15 | 27 | SO45786 | 2022-07-21 | 629.85 | 7962.37 | 874.79 |
SO49041_2 | F980-4BCB-AB | PO19691174434 | 19 | 291 | 468 | 353 | 6 | 2023-05-28 | 45.59 | 1.14 | 2023-05-16 | 2 | 15.67 | 1 | 45.59 | 2 | SO49041 | 2023-05-23 | 3.65 | 31.34 | 22.79 |
SO45786_28 | C4AF-4371-B7 | PO14732192241 | 19 | 288 | 264 | 514 | 6 | 2022-07-26 | 735.75 | 18.39 | 2022-07-14 | 4 | 181.49 | 1 | 735.75 | 28 | SO45786 | 2022-07-21 | 58.86 | 725.94 | 183.94 |
SO49041_3 | F980-4BCB-AB | PO19691174434 | 19 | 291 | 470 | 353 | 6 | 2023-05-28 | 136.76 | 3.42 | 2023-05-16 | 6 | 15.67 | 1 | 136.76 | 3 | SO49041 | 2023-05-23 | 10.94 | 94.03 | 22.79 |
SO45786_29 | C4AF-4371-B7 | PO14732192241 | 19 | 288 | 338 | 514 | 6 | 2022-07-26 | 838.92 | 20.97 | 2022-07-14 | 2 | 413.15 | 1 | 838.92 | 29 | SO45786 | 2022-07-21 | 67.11 | 826.29 | 419.46 |
SO49042_1 | CCD3-4B59-81 | PO19459119840 | 19 | 291 | 335 | 334 | 6 | 2023-05-28 | 469.79 | 11.74 | 2023-05-16 | 1 | 486.71 | 1 | 469.79 | 1 | SO49042 | 2023-05-23 | 37.58 | 486.71 | 469.79 |
SO45792_1 | D5D3-43B4-A2 | PO13862173868 | 19 | 288 | 349 | 119 | 6 | 2022-07-26 | 4049.99 | 101.25 | 2022-07-14 | 2 | 1898.09 | 1 | 4049.99 | 1 | SO45792 | 2022-07-21 | 324.00 | 3796.19 | 2024.99 |
SO49042_2 | CCD3-4B59-81 | PO19459119840 | 19 | 291 | 221 | 334 | 6 | 2023-05-28 | 60.56 | 1.51 | 2023-05-16 | 3 | 13.88 | 1 | 60.56 | 2 | SO49042 | 2023-05-23 | 4.84 | 41.63 | 20.19 |
SO45792_2 | D5D3-43B4-A2 | PO13862173868 | 19 | 288 | 351 | 119 | 6 | 2022-07-26 | 4049.99 | 101.25 | 2022-07-14 | 2 | 1898.09 | 1 | 4049.99 | 2 | SO45792 | 2022-07-21 | 324.00 | 3796.19 | 2024.99 |
SO49042_3 | CCD3-4B59-81 | PO19459119840 | 19 | 291 | 373 | 334 | 6 | 2023-05-28 | 1308.94 | 32.72 | 2023-05-16 | 1 | 1320.68 | 1 | 1308.94 | 3 | SO49042 | 2023-05-23 | 104.72 | 1320.68 | 1308.94 |
SO45792_3 | D5D3-43B4-A2 | PO13862173868 | 19 | 288 | 347 | 119 | 6 | 2022-07-26 | 4079.99 | 102.00 | 2022-07-14 | 2 | 1912.15 | 1 | 4079.99 | 3 | SO45792 | 2022-07-21 | 326.40 | 3824.31 | 2039.99 |
SO49045_1 | B1B9-4F02-A4 | PO19227111923 | 19 | 284 | 329 | 210 | 6 | 2023-05-28 | 1879.18 | 46.98 | 2023-05-16 | 4 | 486.71 | 1 | 1879.18 | 1 | SO49045 | 2023-05-23 | 150.33 | 1946.83 | 469.79 |
SO45792_4 | D5D3-43B4-A2 | PO13862173868 | 19 | 288 | 296 | 119 | 6 | 2022-07-26 | 714.70 | 17.87 | 2022-07-14 | 1 | 617.03 | 1 | 714.70 | 4 | SO45792 | 2022-07-21 | 57.18 | 617.03 | 714.70 |
SO49045_2 | B1B9-4F02-A4 | PO19227111923 | 19 | 284 | 327 | 210 | 6 | 2023-05-28 | 1409.38 | 35.23 | 2023-05-16 | 3 | 486.71 | 1 | 1409.38 | 2 | SO49045 | 2023-05-23 | 112.75 | 1460.12 | 469.79 |
SO45792_5 | D5D3-43B4-A2 | PO13862173868 | 19 | 288 | 292 | 119 | 6 | 2022-07-26 | 1637.40 | 40.94 | 2022-07-14 | 2 | 706.81 | 1 | 1637.40 | 5 | SO45792 | 2022-07-21 | 130.99 | 1413.62 | 818.70 |
SO49045_3 | B1B9-4F02-A4 | PO19227111923 | 19 | 284 | 343 | 210 | 6 | 2023-05-28 | 1879.18 | 46.98 | 2023-05-16 | 4 | 486.71 | 1 | 1879.18 | 3 | SO49045 | 2023-05-23 | 150.33 | 1946.83 | 469.79 |
SO45792_6 | D5D3-43B4-A2 | PO13862173868 | 19 | 288 | 307 | 119 | 6 | 2022-07-26 | 722.59 | 18.06 | 2022-07-14 | 1 | 623.84 | 1 | 722.59 | 6 | SO45792 | 2022-07-21 | 57.81 | 623.84 | 722.59 |
SO49045_4 | B1B9-4F02-A4 | PO19227111923 | 19 | 284 | 333 | 210 | 6 | 2023-05-28 | 939.59 | 23.49 | 2023-05-16 | 2 | 486.71 | 1 | 939.59 | 4 | SO49045 | 2023-05-23 | 75.17 | 973.41 | 469.79 |
SO45792_7 | D5D3-43B4-A2 | PO13862173868 | 19 | 288 | 344 | 119 | 6 | 2022-07-26 | 4079.99 | 102.00 | 2022-07-14 | 2 | 1912.15 | 1 | 4079.99 | 7 | SO45792 | 2022-07-21 | 326.40 | 3824.31 | 2039.99 |
SO49045_5 | B1B9-4F02-A4 | PO19227111923 | 19 | 284 | 323 | 210 | 6 | 2023-05-28 | 939.59 | 23.49 | 2023-05-16 | 2 | 486.71 | 1 | 939.59 | 5 | SO49045 | 2023-05-23 | 75.17 | 973.41 | 469.79 |
SO45792_8 | D5D3-43B4-A2 | PO13862173868 | 19 | 288 | 346 | 119 | 6 | 2022-07-26 | 8159.98 | 204.00 | 2022-07-14 | 4 | 1912.15 | 1 | 8159.98 | 8 | SO45792 | 2022-07-21 | 652.80 | 7648.62 | 2039.99 |
SO49047_1 | C77B-4B8C-AA | PO18415191482 | 19 | 291 | 216 | 191 | 6 | 2023-05-28 | 20.19 | 0.50 | 2023-05-16 | 1 | 13.88 | 1 | 20.19 | 1 | SO49047 | 2023-05-23 | 1.61 | 13.88 | 20.19 |
SO45792_9 | D5D3-43B4-A2 | PO13862173868 | 19 | 288 | 218 | 119 | 6 | 2022-07-26 | 34.20 | 0.86 | 2022-07-14 | 6 | 3.40 | 1 | 34.20 | 9 | SO45792 | 2022-07-21 | 2.74 | 20.38 | 5.70 |
SO49047_2 | C77B-4B8C-AA | PO18415191482 | 19 | 291 | 341 | 191 | 6 | 2023-05-28 | 469.79 | 11.74 | 2023-05-16 | 1 | 486.71 | 1 | 469.79 | 2 | SO49047 | 2023-05-23 | 37.58 | 486.71 | 469.79 |
SO45792_10 | D5D3-43B4-A2 | PO13862173868 | 19 | 288 | 348 | 119 | 6 | 2022-07-26 | 4049.99 | 101.25 | 2022-07-14 | 2 | 1898.09 | 1 | 4049.99 | 10 | SO45792 | 2022-07-21 | 324.00 | 3796.19 | 2024.99 |
SO49048_1 | 5A3D-4A7B-98 | PO17806160287 | 19 | 291 | 323 | 101 | 6 | 2023-05-28 | 469.79 | 11.74 | 2023-05-16 | 1 | 486.71 | 1 | 469.79 | 1 | SO49048 | 2023-05-23 | 37.58 | 486.71 | 469.79 |
SO45794_1 | 945F-4477-83 | PO12760191318 | 19 | 288 | 322 | 83 | 6 | 2022-07-26 | 1677.84 | 41.95 | 2022-07-14 | 4 | 413.15 | 1 | 1677.84 | 1 | SO45794 | 2022-07-21 | 134.23 | 1652.59 | 419.46 |
SO49048_2 | 5A3D-4A7B-98 | PO17806160287 | 19 | 291 | 329 | 101 | 6 | 2023-05-28 | 1409.38 | 35.23 | 2023-05-16 | 3 | 486.71 | 1 | 1409.38 | 2 | SO49048 | 2023-05-23 | 112.75 | 1460.12 | 469.79 |
Generated 2024-11-13 03:21:03.173 UTC