[ROOT] dt FactResellerSale < WHERE DimSalesTerritoryId EQ '6' > SHUFFLE < SKIP 170 > < TAKE 28 >
28 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 |
---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
SO58930_24 | 3C7F-464E-B2 | PO14790187151 | 19 | 291 | 532 | 497 | 6 | 2024-02-02 | 149.87 | 3.75 | 2024-01-21 | 1 | 136.79 | 1 | 149.87 | 24 | SO58930 | 2024-01-28 | 11.99 | 136.79 | 149.87 | |||
SO48778_34 | 4F83-4D59-87 | PO4495173571 | 19 | 291 | 395 | 496 | 6 | 2023-03-05 | 122.75 | 3.07 | 2023-02-21 | 2 | 45.42 | 1 | 122.75 | 34 | SO48778 | 2023-02-28 | 9.82 | 90.83 | 61.37 | |||
SO51113_3 | C890-4CA6-90 | PO11136135505 | 19 | 284 | 569 | 13 | 120 | 6 | 50.11 | 2023-09-02 | 334.06 | 7.10 | 2023-08-21 | 1 | 461.44 | 1 | 283.95 | 3 | SO51113 | 2023-08-28 | 22.72 | 461.44 | 334.06 | 0.15 |
SO46072_12 | 0D05-4D9C-87 | PO2146167606 | 19 | 284 | 293 | 354 | 6 | 2022-07-03 | 1445.19 | 36.13 | 2022-06-21 | 2 | 623.84 | 1 | 1445.19 | 12 | SO46072 | 2022-06-28 | 115.62 | 1247.68 | 722.59 | |||
SO45038_12 | 2001-401A-83 | PO18473129920 | 19 | 288 | 307 | 442 | 6 | 2022-03-05 | 722.59 | 18.06 | 2022-02-21 | 1 | 623.84 | 1 | 722.59 | 12 | SO45038 | 2022-02-28 | 57.81 | 623.84 | 722.59 | |||
SO51839_2 | 411D-4ACA-8E | PO4901195797 | 19 | 284 | 404 | 84 | 6 | 2023-10-03 | 53.45 | 1.34 | 2023-09-21 | 2 | 19.78 | 1 | 53.45 | 2 | SO51839 | 2023-09-28 | 4.28 | 39.55 | 26.72 | |||
SO61177_20 | DA64-4BC0-A0 | PO18473117778 | 19 | 291 | 398 | 442 | 6 | 2024-03-04 | 53.45 | 1.34 | 2024-02-21 | 2 | 19.78 | 1 | 53.45 | 20 | SO61177 | 2024-02-28 | 4.28 | 39.55 | 26.72 | |||
SO49848_8 | 31E6-4A3B-9C | PO1711148241 | 19 | 291 | 409 | 245 | 6 | 2023-06-03 | 837.02 | 20.93 | 2023-05-22 | 4 | 185.82 | 1 | 837.02 | 8 | SO49848 | 2023-05-29 | 66.96 | 743.28 | 209.26 | |||
SO55266_4 | 03C7-431B-BA | PO10527171106 | 19 | 284 | 225 | 480 | 6 | 2023-12-03 | 16.18 | 0.40 | 2023-11-21 | 3 | 6.92 | 1 | 16.18 | 4 | SO55266 | 2023-11-28 | 1.29 | 20.77 | 5.39 | |||
SO46034_8 | BF2B-4539-A2 | PO18415186478 | 19 | 288 | 318 | 191 | 6 | 2022-07-03 | 874.79 | 21.87 | 2022-06-21 | 1 | 884.71 | 1 | 874.79 | 8 | SO46034 | 2022-06-28 | 69.98 | 884.71 | 874.79 | |||
SO48338_5 | CF00-46C1-99 | PO11107115615 | 19 | 284 | 325 | 156 | 6 | 2023-02-02 | 469.79 | 11.74 | 2023-01-21 | 1 | 486.71 | 1 | 469.79 | 5 | SO48338 | 2023-01-28 | 37.58 | 486.71 | 469.79 | |||
SO48306_34 | EA27-471A-9D | PO17574166075 | 19 | 291 | 393 | 678 | 6 | 2023-02-02 | 963.86 | 24.10 | 2023-01-21 | 7 | 101.89 | 1 | 963.86 | 34 | SO48306 | 2023-01-28 | 77.11 | 713.26 | 137.69 | |||
SO61204_20 | E810-4164-82 | PO15312134209 | 19 | 291 | 547 | 299 | 6 | 2024-03-04 | 97.19 | 2.43 | 2024-02-21 | 2 | 35.96 | 1 | 97.19 | 20 | SO61204 | 2024-02-28 | 7.78 | 71.92 | 48.59 | |||
SO51698_10 | C8C8-43A4-AC | PO19227173300 | 19 | 284 | 481 | 210 | 6 | 2023-10-03 | 21.58 | 0.54 | 2023-09-21 | 4 | 3.36 | 1 | 21.58 | 10 | SO51698 | 2023-09-28 | 1.73 | 13.45 | 5.39 | |||
SO57022_4 | 9202-4FEB-88 | PO17806175482 | 19 | 291 | 583 | 101 | 6 | 2024-01-03 | 1020.59 | 25.51 | 2023-12-22 | 1 | 1082.51 | 1 | 1020.59 | 4 | SO57022 | 2023-12-29 | 81.65 | 1082.51 | 1020.59 | |||
SO47668_16 | 7CB5-4904-AD | PO15312152020 | 19 | 291 | 447 | 299 | 6 | 2022-12-03 | 30.00 | 0.75 | 2022-11-21 | 2 | 10.31 | 1 | 30.00 | 16 | SO47668 | 2022-11-28 | 2.40 | 20.63 | 15.00 | |||
SO71829_10 | 427E-46EE-B0 | PO10962123279 | 19 | 284 | 591 | 16 | 685 | 6 | 90.40 | 2024-08-03 | 226.00 | 3.39 | 2024-07-22 | 2 | 308.22 | 1 | 135.60 | 10 | SO71829 | 2024-07-29 | 10.85 | 616.44 | 113.00 | 0.40 |
SO58958_21 | BC3F-443F-B5 | PO10875118816 | 19 | 291 | 507 | 281 | 6 | 2024-02-02 | 200.05 | 5.00 | 2024-01-21 | 1 | 199.85 | 1 | 200.05 | 21 | SO58958 | 2024-01-28 | 16.00 | 199.85 | 200.05 | |||
SO57084_1 | B9C4-4E53-A3 | PO2146163643 | 19 | 284 | 599 | 354 | 6 | 2024-01-03 | 323.99 | 8.10 | 2023-12-22 | 1 | 294.58 | 1 | 323.99 | 1 | SO57084 | 2023-12-29 | 25.92 | 294.58 | 323.99 | |||
SO44084_2 | 3E29-4002-91 | PO17835143404 | 19 | 288 | 345 | 551 | 6 | 2021-11-03 | 4079.99 | 102.00 | 2021-10-22 | 2 | 1912.15 | 1 | 4079.99 | 2 | SO44084 | 2021-10-29 | 326.40 | 3824.31 | 2039.99 | |||
SO47366_32 | DD3E-4DAA-BA | PO17545115575 | 19 | 291 | 389 | 155 | 6 | 2022-11-03 | 3601.58 | 90.04 | 2022-10-22 | 6 | 605.65 | 1 | 3601.58 | 32 | SO47366 | 2022-10-29 | 288.13 | 3633.90 | 600.26 | |||
SO63177_11 | 87AD-4113-AD | PO1856115383 | 19 | 291 | 493 | 263 | 6 | 2024-04-04 | 400.10 | 10.00 | 2024-03-23 | 2 | 199.85 | 1 | 400.10 | 11 | SO63177 | 2024-03-30 | 32.01 | 399.70 | 200.05 | |||
SO47708_6 | 86B1-46A5-95 | PO4495147689 | 19 | 291 | 308 | 496 | 6 | 2022-12-03 | 3721.36 | 93.03 | 2022-11-21 | 5 | 660.91 | 1 | 3721.36 | 6 | SO47708 | 2022-11-28 | 297.71 | 3304.57 | 744.27 | |||
SO67295_2 | D785-46A0-BC | PO1711155302 | 19 | 291 | 501 | 245 | 6 | 2024-06-03 | 655.88 | 16.40 | 2024-05-22 | 9 | 53.93 | 1 | 655.88 | 2 | SO67295 | 2024-05-29 | 52.47 | 485.35 | 72.88 | |||
SO53483_11 | A0BE-40E0-81 | PO14761137153 | 19 | 284 | 502 | 408 | 6 | 2023-11-03 | 400.10 | 10.00 | 2023-10-22 | 2 | 199.85 | 1 | 400.10 | 11 | SO53483 | 2023-10-29 | 32.01 | 399.70 | 200.05 | |||
SO55297_65 | 2455-4B60-A5 | PO4495126679 | 19 | 291 | 501 | 496 | 6 | 2023-12-03 | 145.75 | 3.64 | 2023-11-21 | 2 | 53.93 | 1 | 145.75 | 65 | SO55297 | 2023-11-28 | 11.66 | 107.86 | 72.88 | |||
SO49871_5 | 032A-45C4-8D | PO4930185924 | 19 | 291 | 458 | 425 | 6 | 2023-06-03 | 179.98 | 4.50 | 2023-05-22 | 4 | 30.93 | 1 | 179.98 | 5 | SO49871 | 2023-05-29 | 14.40 | 123.73 | 44.99 | |||
SO44496_8 | 6ADA-4A25-AA | PO18415194469 | 19 | 288 | 310 | 191 | 6 | 2022-01-03 | 2146.96 | 53.67 | 2021-12-22 | 1 | 2171.29 | 1 | 2146.96 | 8 | SO44496 | 2021-12-29 | 171.76 | 2171.29 | 2146.96 |
Generated 2024-09-20 16:44:07.240 UTC