[ROOT] dt FactResellerSale < WHERE DimSalesTerritoryId EQ '6' > SKIP 0 SHUFFLE < SKIP 797 > < TAKE 30 >
30 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 |
---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
SO67272_26 | F467-41BF-8B | PO13862111340 | 19 | 291 | 511 | 119 | 6 | 2024-06-03 | 218.45 | 5.46 | 2024-05-22 | 1 | 199.38 | 1 | 218.45 | 26 | SO67272 | 2024-05-29 | 17.48 | 199.38 | 218.45 | |||
SO69522_34 | 28C3-4615-8B | PO4901187436 | 19 | 284 | 418 | 84 | 6 | 2024-07-03 | 356.90 | 8.92 | 2024-06-21 | 1 | 360.94 | 1 | 356.90 | 34 | SO69522 | 2024-06-28 | 28.55 | 360.94 | 356.90 | |||
SO43856_2 | 745E-4F74-BC | PO17313123131 | 19 | 288 | 350 | 389 | 6 | 2021-10-03 | 2024.99 | 50.62 | 2021-09-21 | 1 | 1898.09 | 1 | 2024.99 | 2 | SO43856 | 2021-09-28 | 162.00 | 1898.09 | 2024.99 | |||
SO47031_7 | 3FA6-4120-BD | PO4466161844 | 19 | 291 | 447 | 352 | 6 | 2022-10-03 | 75.00 | 1.88 | 2022-09-21 | 5 | 10.31 | 1 | 75.00 | 7 | SO47031 | 2022-09-28 | 6.00 | 51.56 | 15.00 | |||
SO46334_23 | F652-4575-B7 | PO17574196050 | 19 | 272 | 349 | 7 | 678 | 6 | 590.62 | 2022-08-03 | 1687.50 | 27.42 | 2022-07-22 | 2 | 1898.09 | 1 | 1096.87 | 23 | SO46334 | 2022-07-29 | 87.75 | 3796.19 | 843.75 | 0.35 |
SO47668_17 | 7CB5-4904-AD | PO15312152020 | 19 | 291 | 415 | 299 | 6 | 2022-12-03 | 594.11 | 14.85 | 2022-11-21 | 3 | 146.55 | 1 | 594.11 | 17 | SO47668 | 2022-11-28 | 47.53 | 439.64 | 198.04 | |||
SO46930_16 | 73DA-4549-8B | PO20039167979 | 19 | 291 | 399 | 65 | 6 | 2022-10-03 | 33.77 | 0.84 | 2022-09-21 | 1 | 24.99 | 1 | 33.77 | 16 | SO46930 | 2022-09-28 | 2.70 | 24.99 | 33.77 | |||
SO45529_13 | 86CC-47BA-B3 | PO17574182721 | 19 | 288 | 292 | 678 | 6 | 2022-05-03 | 2456.10 | 61.40 | 2022-04-21 | 3 | 706.81 | 1 | 2456.10 | 13 | SO45529 | 2022-04-28 | 196.49 | 2120.43 | 818.70 | |||
SO48778_21 | 4F83-4D59-87 | PO4495173571 | 19 | 291 | 458 | 496 | 6 | 2023-03-05 | 269.96 | 6.75 | 2023-02-21 | 6 | 30.93 | 1 | 269.96 | 21 | SO48778 | 2023-02-28 | 21.60 | 185.60 | 44.99 | |||
SO53465_30 | D859-4DF3-84 | PO17574192592 | 19 | 272 | 514 | 678 | 6 | 2023-11-03 | 383.40 | 9.59 | 2023-10-22 | 6 | 47.29 | 1 | 383.40 | 30 | SO53465 | 2023-10-29 | 30.67 | 283.72 | 63.90 | |||
SO48296_18 | FC37-4F3E-BB | PO19401157526 | 19 | 291 | 343 | 173 | 6 | 2023-02-02 | 1879.18 | 46.98 | 2023-01-21 | 4 | 486.71 | 1 | 1879.18 | 18 | SO48296 | 2023-01-28 | 150.33 | 1946.83 | 469.79 | |||
SO47988_49 | 3979-4615-A9 | PO16733190266 | 19 | 291 | 263 | 533 | 6 | 2023-01-03 | 202.33 | 5.06 | 2022-12-22 | 1 | 187.16 | 1 | 202.33 | 49 | SO47988 | 2022-12-29 | 16.19 | 187.16 | 202.33 | |||
SO46607_12 | C1B5-40D6-8D | PO18444137892 | 19 | 291 | 381 | 227 | 6 | 2022-09-02 | 2401.05 | 60.03 | 2022-08-21 | 4 | 605.65 | 1 | 2401.05 | 12 | SO46607 | 2022-08-28 | 192.08 | 2422.60 | 600.26 | |||
SO61196_3 | 8DD6-4DC9-A5 | PO1711193720 | 19 | 291 | 298 | 245 | 6 | 2024-03-04 | 5668.32 | 141.71 | 2024-02-21 | 7 | 739.04 | 1 | 5668.32 | 3 | SO61196 | 2024-02-28 | 453.47 | 5173.29 | 809.76 | |||
SO49496_10 | 1BAD-4D34-B0 | PO10614179686 | 19 | 291 | 371 | 461 | 6 | 2023-05-03 | 6544.69 | 163.62 | 2023-04-21 | 5 | 1320.68 | 1 | 6544.69 | 10 | SO49496 | 2023-04-28 | 523.58 | 6603.42 | 1308.94 | |||
SO53542_1 | D309-4C20-A5 | PO18531154951 | 19 | 284 | 474 | 2 | 613 | 6 | 8.93 | 2023-11-03 | 446.54 | 10.94 | 2023-10-22 | 11 | 26.18 | 1 | 437.61 | 1 | SO53542 | 2023-10-29 | 35.01 | 287.94 | 40.59 | 0.02 |
SO44773_14 | D4D3-4657-AC | PO1740125070 | 19 | 288 | 326 | 460 | 6 | 2022-02-02 | 2097.29 | 52.43 | 2022-01-21 | 5 | 413.15 | 1 | 2097.29 | 14 | SO44773 | 2022-01-28 | 167.78 | 2065.73 | 419.46 | |||
SO43679_1 | 918F-49F3-AD | PO10527142759 | 19 | 284 | 322 | 480 | 6 | 2021-09-02 | 419.46 | 10.49 | 2021-08-21 | 1 | 413.15 | 1 | 419.46 | 1 | SO43679 | 2021-08-28 | 33.56 | 413.15 | 419.46 | |||
SO45038_10 | 2001-401A-83 | PO18473129920 | 19 | 288 | 292 | 442 | 6 | 2022-03-05 | 1637.40 | 40.94 | 2022-02-21 | 2 | 706.81 | 1 | 1637.40 | 10 | SO45038 | 2022-02-28 | 130.99 | 1413.62 | 818.70 | |||
SO46034_12 | BF2B-4539-A2 | PO18415186478 | 19 | 288 | 272 | 191 | 6 | 2022-07-03 | 183.94 | 4.60 | 2022-06-21 | 1 | 181.49 | 1 | 183.94 | 12 | SO46034 | 2022-06-28 | 14.72 | 181.49 | 183.94 | |||
SO44294_2 | F4DE-4BA0-B1 | PO13862172262 | 19 | 288 | 348 | 119 | 6 | 2021-12-03 | 8099.98 | 202.50 | 2021-11-21 | 4 | 1898.09 | 1 | 8099.98 | 2 | SO44294 | 2021-11-28 | 648.00 | 7592.38 | 2024.99 | |||
SO45323_1 | 8E16-4834-8A | PO4901118407 | 19 | 284 | 315 | 84 | 6 | 2022-04-05 | 3499.18 | 87.48 | 2022-03-24 | 4 | 884.71 | 1 | 3499.18 | 1 | SO45323 | 2022-03-31 | 279.93 | 3538.83 | 874.79 | |||
SO50668_9 | A5FC-4831-B4 | PO17574113752 | 19 | 291 | 308 | 678 | 6 | 2023-08-03 | 2977.09 | 74.43 | 2023-07-22 | 4 | 660.91 | 1 | 2977.09 | 9 | SO50668 | 2023-07-29 | 238.17 | 2643.66 | 744.27 | |||
SO48022_3 | 9AB0-4BC5-B5 | PO10991115418 | 19 | 284 | 412 | 570 | 6 | 2023-01-03 | 540.39 | 13.51 | 2022-12-22 | 3 | 133.30 | 1 | 540.39 | 3 | SO48022 | 2022-12-29 | 43.23 | 399.89 | 180.13 | |||
SO61177_13 | DA64-4BC0-A0 | PO18473117778 | 19 | 291 | 359 | 442 | 6 | 2024-03-04 | 1376.99 | 34.42 | 2024-02-21 | 1 | 1251.98 | 1 | 1376.99 | 13 | SO61177 | 2024-02-28 | 110.16 | 1251.98 | 1376.99 | |||
SO46334_16 | F652-4575-B7 | PO17574196050 | 19 | 272 | 293 | 678 | 6 | 2022-08-03 | 1445.19 | 36.13 | 2022-07-22 | 2 | 623.84 | 1 | 1445.19 | 16 | SO46334 | 2022-07-29 | 115.62 | 1247.68 | 722.59 | |||
SO51793_31 | D763-4929-9B | PO18705168707 | 19 | 291 | 482 | 479 | 6 | 2023-10-03 | 43.15 | 1.08 | 2023-09-21 | 8 | 3.36 | 1 | 43.15 | 31 | SO51793 | 2023-09-28 | 3.45 | 26.90 | 5.39 | |||
SO71788_1 | E55C-4CCA-85 | PO17951176595 | 19 | 284 | 390 | 637 | 6 | 2024-08-03 | 672.29 | 16.81 | 2024-07-22 | 1 | 713.08 | 1 | 672.29 | 1 | SO71788 | 2024-07-29 | 53.78 | 713.08 | 672.29 | |||
SO48351_23 | 0478-43AC-AB | PO1885129829 | 19 | 284 | 367 | 588 | 6 | 2023-02-02 | 1943.98 | 48.60 | 2023-01-21 | 3 | 598.44 | 1 | 1943.98 | 23 | SO48351 | 2023-01-28 | 155.52 | 1795.31 | 647.99 | |||
SO53465_59 | D859-4DF3-84 | PO17574192592 | 19 | 272 | 361 | 678 | 6 | 2023-11-03 | 2753.99 | 68.85 | 2023-10-22 | 2 | 1251.98 | 1 | 2753.99 | 59 | SO53465 | 2023-10-29 | 220.32 | 2503.96 | 1376.99 |
Generated 2024-09-21 00:38:32.661 UTC