[ROOT] dt FactResellerSale < WHERE DimSalesTerritoryId EQ '6' > SKIP 3000 SHUFFLE < SKIP 2031 > < TAKE 31 >
31 items
FactResellerSaleId | CarrierTrackingNumber | CustomerPONumber | DimCurrencyId | DimEmployeeId | DimProductId | DimPromotionId | DimResellerId | DimSalesTerritoryId | DiscountAmount | DueDate | ExtendedAmount | Freight | OrderDate | OrderQuantity | ProductStandardCost | RevisionNumber | SalesAmount | SalesOrderLineNumber | SalesOrderNumber | ShipDate | TaxAmt | TotalProductCost | UnitPrice | UnitPriceDiscountPct |
---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
SO45323_16 | 8E16-4834-8A | PO4901118407 | 19 | 284 | 338 | 84 | 6 | 2022-05-28 | 419.46 | 10.49 | 2022-05-16 | 1 | 413.15 | 1 | 419.46 | 16 | SO45323 | 2022-05-23 | 33.56 | 413.15 | 419.46 | |||
SO69396_13 | 210F-43F3-97 | PO19227139814 | 19 | 284 | 482 | 210 | 6 | 2024-08-25 | 32.36 | 0.81 | 2024-08-13 | 6 | 3.36 | 1 | 32.36 | 13 | SO69396 | 2024-08-20 | 2.59 | 20.17 | 5.39 | |||
SO71841_48 | 1544-4561-AB | PO1798133189 | 19 | 291 | 483 | 10 | 6 | 2024-09-25 | 288.00 | 7.20 | 2024-09-13 | 4 | 44.88 | 1 | 288.00 | 48 | SO71841 | 2024-09-20 | 23.04 | 179.52 | 72.00 | |||
SO49140_6 | EFF3-483D-BE | PO4901154744 | 19 | 284 | 224 | 84 | 6 | 2023-05-28 | 20.75 | 0.52 | 2023-05-16 | 4 | 5.23 | 1 | 20.75 | 6 | SO49140 | 2023-05-23 | 1.66 | 20.92 | 5.19 | |||
SO46038_1 | D7B6-499A-87 | PO17748117802 | 19 | 284 | 232 | 102 | 6 | 2022-08-25 | 57.68 | 1.44 | 2022-08-13 | 2 | 31.72 | 1 | 57.68 | 1 | SO46038 | 2022-08-20 | 4.61 | 63.45 | 28.84 | |||
SO53510_23 | 8E8D-4B13-B1 | PO10962181057 | 19 | 284 | 357 | 685 | 6 | 2023-12-26 | 8351.96 | 208.80 | 2023-12-14 | 6 | 1265.62 | 1 | 8351.96 | 23 | SO53510 | 2023-12-21 | 668.16 | 7593.72 | 1391.99 | |||
SO49485_19 | 9EA5-4DEF-B8 | PO17545171443 | 19 | 291 | 343 | 155 | 6 | 2023-06-25 | 2348.97 | 58.72 | 2023-06-13 | 5 | 486.71 | 1 | 2348.97 | 19 | SO49485 | 2023-06-20 | 187.92 | 2433.53 | 469.79 | |||
SO49879_46 | 7A79-4FB0-85 | PO4495112714 | 19 | 291 | 396 | 496 | 6 | 2023-07-26 | 374.19 | 9.35 | 2023-07-14 | 5 | 55.38 | 1 | 374.19 | 46 | SO49879 | 2023-07-21 | 29.94 | 276.90 | 74.84 | |||
SO50716_41 | 0B80-45BD-98 | PO18299117393 | 19 | 291 | 461 | 118 | 6 | 2023-09-25 | 269.97 | 6.75 | 2023-09-13 | 5 | 37.12 | 1 | 269.97 | 41 | SO50716 | 2023-09-20 | 21.60 | 185.60 | 53.99 | |||
SO49855_23 | 0C94-4D84-A4 | PO18473166459 | 19 | 291 | 395 | 442 | 6 | 2023-07-26 | 368.24 | 9.21 | 2023-07-14 | 6 | 45.42 | 1 | 368.24 | 23 | SO49855 | 2023-07-21 | 29.46 | 272.50 | 61.37 | |||
SO48750_41 | 9A71-449E-B6 | PO14732147398 | 19 | 291 | 286 | 514 | 6 | 2023-04-27 | 551.81 | 13.80 | 2023-04-15 | 3 | 170.14 | 1 | 551.81 | 41 | SO48750 | 2023-04-22 | 44.15 | 510.43 | 183.94 | |||
SO69479_2 | 3D8D-4908-A6 | PO18328116976 | 19 | 284 | 606 | 552 | 6 | 2024-08-25 | 323.99 | 8.10 | 2024-08-13 | 1 | 343.65 | 1 | 323.99 | 2 | SO69479 | 2024-08-20 | 25.92 | 343.65 | 323.99 | |||
SO46071_17 | 1563-4F33-9D | PO1827148074 | 19 | 288 | 264 | 317 | 6 | 2022-08-25 | 367.88 | 9.20 | 2022-08-13 | 2 | 181.49 | 1 | 367.88 | 17 | SO46071 | 2022-08-20 | 29.43 | 362.97 | 183.94 | |||
SO53600_7 | 8E02-463C-A5 | PO2233133950 | 19 | 291 | 491 | 262 | 6 | 2023-12-26 | 129.58 | 3.24 | 2023-12-14 | 4 | 41.57 | 1 | 129.58 | 7 | SO53600 | 2023-12-21 | 10.37 | 166.29 | 32.39 | |||
SO48306_19 | EA27-471A-9D | PO17574166075 | 19 | 291 | 462 | 678 | 6 | 2023-03-27 | 56.52 | 1.41 | 2023-03-15 | 4 | 9.71 | 1 | 56.52 | 19 | SO48306 | 2023-03-22 | 4.52 | 38.85 | 14.13 | |||
SO51832_31 | 475C-432F-B2 | PO4466177904 | 19 | 291 | 475 | 352 | 6 | 2023-11-25 | 83.99 | 2.10 | 2023-11-13 | 2 | 26.18 | 1 | 83.99 | 31 | SO51832 | 2023-11-20 | 6.72 | 52.35 | 41.99 | |||
SO53465_1 | D859-4DF3-84 | PO17574192592 | 19 | 272 | 501 | 678 | 6 | 2023-12-26 | 510.13 | 12.75 | 2023-12-14 | 7 | 53.93 | 1 | 510.13 | 1 | SO53465 | 2023-12-21 | 40.81 | 377.50 | 72.88 | |||
SO71808_2 | 2E63-4616-B1 | PO14761198562 | 19 | 284 | 499 | 408 | 6 | 2024-09-25 | 1204.69 | 30.12 | 2024-09-13 | 2 | 601.74 | 1 | 1204.69 | 2 | SO71808 | 2024-09-20 | 96.38 | 1203.49 | 602.35 | |||
SO65156_11 | 3295-4FC6-BC | PO19401176373 | 19 | 291 | 388 | 173 | 6 | 2024-06-25 | 2016.88 | 50.42 | 2024-06-13 | 3 | 713.08 | 1 | 2016.88 | 11 | SO65156 | 2024-06-20 | 161.35 | 2139.24 | 672.29 | |||
SO57155_1 | 4EB5-4191-9E | PO2117166089 | 19 | 284 | 475 | 444 | 6 | 2024-02-25 | 83.99 | 2.10 | 2024-02-13 | 2 | 26.18 | 1 | 83.99 | 1 | SO57155 | 2024-02-20 | 6.72 | 52.35 | 41.99 | |||
SO47413_2 | E274-4280-9B | PO1885161774 | 19 | 284 | 409 | 588 | 6 | 2022-12-26 | 418.51 | 10.46 | 2022-12-14 | 2 | 185.82 | 1 | 418.51 | 2 | SO47413 | 2022-12-21 | 33.48 | 371.64 | 209.26 | |||
SO71829_15 | 427E-46EE-B0 | PO10962123279 | 19 | 284 | 361 | 685 | 6 | 2024-09-25 | 8261.96 | 206.55 | 2024-09-13 | 6 | 1251.98 | 1 | 8261.96 | 15 | SO71829 | 2024-09-20 | 660.96 | 7511.89 | 1376.99 | |||
SO53464_15 | E113-419B-8F | PO17545119283 | 19 | 291 | 243 | 155 | 6 | 2023-12-26 | 1717.80 | 42.95 | 2023-12-14 | 2 | 868.63 | 1 | 1717.80 | 15 | SO53464 | 2023-12-21 | 137.42 | 1737.27 | 858.90 | |||
SO49480_22 | BA71-43B7-82 | PO19401115391 | 19 | 291 | 339 | 173 | 6 | 2023-06-25 | 939.59 | 23.49 | 2023-06-13 | 2 | 486.71 | 1 | 939.59 | 22 | SO49480 | 2023-06-20 | 75.17 | 973.41 | 469.79 | |||
SO48307_42 | 7DE5-4D74-A7 | PO17545123793 | 19 | 291 | 379 | 155 | 6 | 2023-03-27 | 5235.75 | 130.89 | 2023-03-15 | 4 | 1320.68 | 1 | 5235.75 | 42 | SO48307 | 2023-03-22 | 418.86 | 5282.74 | 1308.94 | |||
SO53513_17 | 5E21-438C-B3 | PO10875194431 | 19 | 291 | 565 | 13 | 281 | 6 | 551.19 | 2023-12-26 | 3674.63 | 78.09 | 2023-12-14 | 11 | 461.44 | 1 | 3123.44 | 17 | SO53513 | 2023-12-21 | 249.88 | 5075.89 | 334.06 | 0.15 |
SO49879_20 | 7A79-4FB0-85 | PO4495112714 | 19 | 291 | 459 | 496 | 6 | 2023-07-26 | 269.97 | 6.75 | 2023-07-14 | 5 | 37.12 | 1 | 269.97 | 20 | SO49879 | 2023-07-21 | 21.60 | 185.60 | 53.99 | |||
SO45039_17 | F427-497C-A1 | PO18444197500 | 19 | 288 | 324 | 227 | 6 | 2022-04-27 | 1677.84 | 41.95 | 2022-04-15 | 4 | 413.15 | 1 | 1677.84 | 17 | SO45039 | 2022-04-22 | 134.23 | 1652.59 | 419.46 | |||
SO47359_23 | 8BC9-458A-82 | PO18299145297 | 19 | 291 | 447 | 2 | 118 | 6 | 3.19 | 2022-12-26 | 159.50 | 3.91 | 2022-12-14 | 11 | 10.31 | 1 | 156.31 | 23 | SO47359 | 2022-12-21 | 12.50 | 113.44 | 14.50 | 0.02 |
SO46608_46 | ACF1-4852-B7 | PO18473177913 | 19 | 291 | 421 | 442 | 6 | 2022-10-25 | 392.66 | 9.82 | 2022-10-13 | 2 | 145.28 | 1 | 392.66 | 46 | SO46608 | 2022-10-20 | 31.41 | 290.57 | 196.33 | |||
SO67295_28 | D785-46A0-BC | PO1711155302 | 19 | 291 | 476 | 3 | 245 | 6 | 28.87 | 2024-07-26 | 577.42 | 13.71 | 2024-07-14 | 15 | 26.18 | 1 | 548.55 | 28 | SO67295 | 2024-07-21 | 43.88 | 392.64 | 38.49 | 0.05 |
Generated 2024-11-13 02:45:03.733 UTC