[ROOT] dt FactResellerSale < WHERE DimSalesTerritoryId EQ '6' > SHUFFLE < SKIP 454 > < 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 |
---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
SO69482_9 | 0D35-42F6-9E | PO18357170772 | 19 | 284 | 568 | 138 | 6 | 2024-07-03 | 445.41 | 11.14 | 2024-06-21 | 1 | 461.44 | 1 | 445.41 | 9 | SO69482 | 2024-06-28 | 35.63 | 461.44 | 445.41 | |||
SO48754_11 | FC6A-4A9E-83 | PO18473150383 | 19 | 291 | 427 | 442 | 6 | 2023-03-05 | 209.26 | 5.23 | 2023-02-21 | 1 | 185.82 | 1 | 209.26 | 11 | SO48754 | 2023-02-28 | 16.74 | 185.82 | 209.26 | |||
SO47359_35 | 8BC9-458A-82 | PO18299145297 | 19 | 291 | 401 | 118 | 6 | 2022-11-03 | 65.60 | 1.64 | 2022-10-22 | 1 | 48.55 | 1 | 65.60 | 35 | SO47359 | 2022-10-29 | 5.25 | 48.55 | 65.60 | |||
SO71860_1 | 53BF-44EF-9F | PO17835163979 | 19 | 291 | 361 | 551 | 6 | 2024-08-03 | 2753.99 | 68.85 | 2024-07-22 | 2 | 1251.98 | 1 | 2753.99 | 1 | SO71860 | 2024-07-29 | 220.32 | 2503.96 | 1376.99 | |||
SO71806_15 | 26A7-4E95-9B | PO14790111844 | 19 | 291 | 591 | 16 | 497 | 6 | 90.40 | 2024-08-03 | 226.00 | 3.39 | 2024-07-22 | 2 | 308.22 | 1 | 135.60 | 15 | SO71806 | 2024-07-29 | 10.85 | 616.44 | 113.00 | 0.40 |
SO53513_13 | 5E21-438C-B3 | PO10875194431 | 19 | 291 | 483 | 281 | 6 | 2023-11-03 | 216.00 | 5.40 | 2023-10-22 | 3 | 44.88 | 1 | 216.00 | 13 | SO53513 | 2023-10-29 | 17.28 | 134.64 | 72.00 | |||
SO67302_20 | E4B2-462D-AC | PO18473194134 | 19 | 291 | 295 | 442 | 6 | 2024-06-03 | 2456.10 | 61.40 | 2024-05-22 | 3 | 747.20 | 1 | 2456.10 | 20 | SO67302 | 2024-05-29 | 196.49 | 2241.60 | 818.70 | |||
SO49052_4 | 8769-409E-94 | PO16733182723 | 19 | 291 | 341 | 533 | 6 | 2023-04-05 | 3288.56 | 82.21 | 2023-03-24 | 7 | 486.71 | 1 | 3288.56 | 4 | SO49052 | 2023-03-31 | 263.08 | 3406.95 | 469.79 | |||
SO46071_9 | 1563-4F33-9D | PO1827148074 | 19 | 288 | 212 | 317 | 6 | 2022-07-03 | 100.93 | 2.52 | 2022-06-21 | 5 | 12.03 | 1 | 100.93 | 9 | SO46071 | 2022-06-28 | 8.07 | 60.14 | 20.19 | |||
SO48299_12 | ABFA-41A9-A7 | PO18299110324 | 19 | 291 | 236 | 118 | 6 | 2023-02-02 | 144.20 | 3.61 | 2023-01-21 | 5 | 29.08 | 1 | 144.20 | 12 | SO48299 | 2023-01-28 | 11.54 | 145.40 | 28.84 | |||
SO46645_14 | F857-4A6D-9C | PO1711132491 | 19 | 291 | 420 | 2 | 245 | 6 | 30.12 | 2022-09-02 | 1505.84 | 36.89 | 2022-08-21 | 11 | 104.80 | 1 | 1475.72 | 14 | SO46645 | 2022-08-28 | 118.06 | 1152.75 | 136.89 | 0.02 |
SO67316_52 | 6F7E-4455-9E | PO4495115494 | 19 | 291 | 603 | 496 | 6 | 2024-06-03 | 291.58 | 7.29 | 2024-05-22 | 4 | 53.94 | 1 | 291.58 | 52 | SO67316 | 2024-05-29 | 23.33 | 215.77 | 72.89 | |||
SO51130_22 | F38F-411F-B2 | PO18473180006 | 19 | 291 | 290 | 442 | 6 | 2023-09-02 | 818.70 | 20.47 | 2023-08-21 | 1 | 747.20 | 1 | 818.70 | 22 | SO51130 | 2023-08-28 | 65.50 | 747.20 | 818.70 | |||
SO57154_28 | 464B-46A4-B6 | PO1856185040 | 19 | 291 | 222 | 263 | 6 | 2024-01-03 | 188.95 | 4.72 | 2023-12-22 | 9 | 13.09 | 1 | 188.95 | 28 | SO57154 | 2023-12-29 | 15.12 | 117.78 | 20.99 | |||
SO53536_51 | 5C09-4051-92 | PO18299189909 | 19 | 291 | 217 | 2 | 118 | 6 | 5.68 | 2023-11-03 | 284.12 | 6.96 | 2023-10-22 | 14 | 13.09 | 1 | 278.44 | 51 | SO53536 | 2023-10-29 | 22.27 | 183.21 | 20.29 | 0.02 |
SO65243_4 | F88F-4FB2-85 | PO11194174051 | 19 | 284 | 507 | 48 | 6 | 2024-05-03 | 200.05 | 5.00 | 2024-04-21 | 1 | 199.85 | 1 | 200.05 | 4 | SO65243 | 2024-04-28 | 16.00 | 199.85 | 200.05 | |||
SO63267_2 | A573-4A2E-B5 | PO2262115390 | 19 | 291 | 480 | 629 | 6 | 2024-04-04 | 1.37 | 0.03 | 2024-03-23 | 1 | 0.86 | 1 | 1.37 | 2 | SO63267 | 2024-03-30 | 0.11 | 0.86 | 1.37 | |||
SO46616_51 | 1264-43E6-B7 | PO14732122562 | 19 | 291 | 414 | 514 | 6 | 2022-09-02 | 447.09 | 11.18 | 2022-08-21 | 3 | 110.28 | 1 | 447.09 | 51 | SO46616 | 2022-08-28 | 35.77 | 330.85 | 149.03 | |||
SO71851_52 | AABE-4443-91 | PO18299133687 | 19 | 291 | 298 | 118 | 6 | 2024-08-03 | 809.76 | 20.24 | 2024-07-22 | 1 | 739.04 | 1 | 809.76 | 52 | SO71851 | 2024-07-29 | 64.78 | 739.04 | 809.76 | |||
SO71808_9 | 2E63-4616-B1 | PO14761198562 | 19 | 284 | 234 | 2 | 408 | 6 | 6.96 | 2024-08-03 | 347.93 | 8.52 | 2024-07-22 | 12 | 38.49 | 1 | 340.97 | 9 | SO71808 | 2024-07-29 | 27.28 | 461.91 | 28.99 | 0.02 |
SO46616_21 | 1264-43E6-B7 | PO14732122562 | 19 | 291 | 213 | 8 | 514 | 6 | 6.73 | 2022-09-02 | 67.29 | 1.51 | 2022-08-21 | 4 | 13.88 | 1 | 60.56 | 21 | SO46616 | 2022-08-28 | 4.84 | 55.51 | 16.82 | 0.10 |
SO48059_10 | E21D-4968-B0 | PO4901134783 | 19 | 284 | 383 | 84 | 6 | 2023-01-03 | 600.26 | 15.01 | 2022-12-22 | 1 | 605.65 | 1 | 600.26 | 10 | SO48059 | 2022-12-29 | 48.02 | 605.65 | 600.26 | |||
SO47366_2 | DD3E-4DAA-BA | PO17545115575 | 19 | 291 | 333 | 155 | 6 | 2022-11-03 | 939.59 | 23.49 | 2022-10-22 | 2 | 486.71 | 1 | 939.59 | 2 | SO47366 | 2022-10-29 | 75.17 | 973.41 | 469.79 | |||
SO53484_18 | CEC0-499D-80 | PO14790120337 | 19 | 291 | 543 | 497 | 6 | 2023-11-03 | 37.25 | 0.93 | 2023-10-22 | 1 | 27.57 | 1 | 37.25 | 18 | SO53484 | 2023-10-29 | 2.98 | 27.57 | 37.25 | |||
SO47037_27 | C1AE-48A5-9F | PO4901170321 | 19 | 284 | 233 | 2 | 84 | 6 | 6.69 | 2022-10-03 | 334.55 | 8.20 | 2022-09-21 | 12 | 29.08 | 1 | 327.86 | 27 | SO47037 | 2022-09-28 | 26.23 | 348.97 | 27.88 | 0.02 |
SO53464_15 | E113-419B-8F | PO17545119283 | 19 | 291 | 243 | 155 | 6 | 2023-11-03 | 1717.80 | 42.95 | 2023-10-22 | 2 | 868.63 | 1 | 1717.80 | 15 | SO53464 | 2023-10-29 | 137.42 | 1737.27 | 858.90 | |||
SO46953_1 | C650-4C32-BE | PO17603154442 | 19 | 284 | 433 | 12 | 6 | 2022-10-03 | 2595.62 | 64.89 | 2022-09-21 | 8 | 300.12 | 1 | 2595.62 | 1 | SO46953 | 2022-09-28 | 207.65 | 2400.95 | 324.45 | |||
SO45797_14 | B3FE-4436-96 | PO11049120115 | 19 | 284 | 232 | 679 | 6 | 2022-06-03 | 28.84 | 0.72 | 2022-05-22 | 1 | 31.72 | 1 | 28.84 | 14 | SO45797 | 2022-05-29 | 2.31 | 31.72 | 28.84 |
Generated 2024-09-21 02:35:52.777 UTC