[ROOT] dt FactResellerSale < WHERE DimSalesTerritoryId EQ '6' > SHUFFLE < SKIP 222 > < TAKE 24 >
24 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 |
---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
SO65164_40 | 07B8-4AF8-8A | PO18299114573 | 19 | 291 | 472 | 118 | 6 | 2024-05-03 | 114.30 | 2.86 | 2024-04-21 | 3 | 23.75 | 1 | 114.30 | 40 | SO65164 | 2024-04-28 | 9.14 | 71.25 | 38.10 | |||
SO51850_40 | 57A9-4C32-8B | PO1856170170 | 19 | 291 | 570 | 13 | 263 | 6 | 100.22 | 2023-10-03 | 668.12 | 14.20 | 2023-09-21 | 2 | 461.44 | 1 | 567.90 | 40 | SO51850 | 2023-09-28 | 45.43 | 922.89 | 334.06 | 0.15 |
SO43857_2 | 0CD4-4091-9B | PO16733124458 | 19 | 288 | 332 | 533 | 6 | 2021-10-03 | 419.46 | 10.49 | 2021-09-21 | 1 | 413.15 | 1 | 419.46 | 2 | SO43857 | 2021-09-28 | 33.56 | 413.15 | 419.46 | |||
SO45305_6 | AC1B-4242-9C | PO11600132440 | 19 | 288 | 319 | 569 | 6 | 2022-04-05 | 1749.59 | 43.74 | 2022-03-24 | 2 | 884.71 | 1 | 1749.59 | 6 | SO45305 | 2022-03-31 | 139.97 | 1769.42 | 874.79 | |||
SO69478_22 | E63C-4ABF-83 | PO18705185140 | 19 | 291 | 390 | 479 | 6 | 2024-07-03 | 1344.59 | 33.61 | 2024-06-21 | 2 | 713.08 | 1 | 1344.59 | 22 | SO69478 | 2024-06-28 | 107.57 | 1426.16 | 672.29 | |||
SO53510_24 | 8E8D-4B13-B1 | PO10962181057 | 19 | 284 | 402 | 685 | 6 | 2023-11-03 | 72.16 | 1.80 | 2023-10-22 | 1 | 53.40 | 1 | 72.16 | 24 | SO53510 | 2023-10-29 | 5.77 | 53.40 | 72.16 | |||
SO46330_14 | 4E4A-4105-8E | PO18299117472 | 19 | 288 | 212 | 118 | 6 | 2022-08-03 | 20.19 | 0.50 | 2022-07-22 | 1 | 12.03 | 1 | 20.19 | 14 | SO46330 | 2022-07-29 | 1.61 | 12.03 | 20.19 | |||
SO44504_22 | CFE2-4C08-B0 | PO16733198490 | 19 | 288 | 212 | 533 | 6 | 2022-01-03 | 80.75 | 2.02 | 2021-12-22 | 4 | 12.03 | 1 | 80.75 | 22 | SO44504 | 2021-12-29 | 6.46 | 48.11 | 20.19 | |||
SO51113_6 | C890-4CA6-90 | PO11136135505 | 19 | 284 | 552 | 120 | 6 | 2023-09-02 | 109.79 | 2.74 | 2023-08-21 | 2 | 40.62 | 1 | 109.79 | 6 | SO51113 | 2023-08-28 | 8.78 | 81.24 | 54.89 | |||
SO46616_58 | 1264-43E6-B7 | PO14732122562 | 19 | 291 | 325 | 514 | 6 | 2022-09-02 | 4228.15 | 105.70 | 2022-08-21 | 9 | 486.71 | 1 | 4228.15 | 58 | SO46616 | 2022-08-28 | 338.25 | 4380.36 | 469.79 | |||
SO45323_25 | 8E16-4834-8A | PO4901118407 | 19 | 284 | 232 | 84 | 6 | 2022-04-05 | 259.56 | 6.49 | 2022-03-24 | 9 | 31.72 | 1 | 259.56 | 25 | SO45323 | 2022-03-31 | 20.77 | 285.52 | 28.84 | |||
SO69479_8 | 3D8D-4908-A6 | PO18328116976 | 19 | 284 | 581 | 552 | 6 | 2024-07-03 | 1020.59 | 25.51 | 2024-06-21 | 1 | 1082.51 | 1 | 1020.59 | 8 | SO69479 | 2024-06-28 | 81.65 | 1082.51 | 1020.59 | |||
SO53527_16 | 0EBE-4ACB-B5 | PO1798140946 | 19 | 291 | 543 | 10 | 6 | 2023-11-03 | 111.76 | 2.79 | 2023-10-22 | 3 | 27.57 | 1 | 111.76 | 16 | SO53527 | 2023-10-29 | 8.94 | 82.70 | 37.25 | |||
SO57019_9 | D018-44A0-BF | PO18879140423 | 19 | 291 | 564 | 64 | 6 | 2024-01-03 | 2860.88 | 71.52 | 2023-12-22 | 2 | 1481.94 | 1 | 2860.88 | 9 | SO57019 | 2023-12-29 | 228.87 | 2963.88 | 1430.44 | |||
SO53536_31 | 5C09-4051-92 | PO18299189909 | 19 | 291 | 471 | 4 | 118 | 6 | 82.55 | 2023-11-03 | 825.50 | 18.57 | 2023-10-22 | 26 | 23.75 | 1 | 742.95 | 31 | SO53536 | 2023-10-29 | 59.44 | 617.47 | 31.75 | 0.10 |
SO57071_1 | 576F-449A-A3 | PO10991157868 | 19 | 284 | 513 | 570 | 6 | 2024-01-03 | 218.45 | 5.46 | 2023-12-22 | 1 | 199.38 | 1 | 218.45 | 1 | SO57071 | 2023-12-29 | 17.48 | 199.38 | 218.45 | |||
SO51704_19 | 13FA-4729-A9 | PO17661178081 | 19 | 284 | 237 | 264 | 6 | 2023-10-03 | 149.97 | 3.75 | 2023-09-21 | 5 | 38.49 | 1 | 149.97 | 19 | SO51704 | 2023-09-28 | 12.00 | 192.46 | 29.99 | |||
SO50265_27 | 6C30-435D-9D | PO18705169014 | 19 | 291 | 422 | 479 | 6 | 2023-07-03 | 202.62 | 5.07 | 2023-06-21 | 3 | 49.98 | 1 | 202.62 | 27 | SO50265 | 2023-06-28 | 16.21 | 149.94 | 67.54 | |||
SO47383_7 | C260-48F6-A0 | PO14239114721 | 19 | 291 | 460 | 550 | 6 | 2022-11-03 | 161.98 | 4.05 | 2022-10-22 | 3 | 37.12 | 1 | 161.98 | 7 | SO47383 | 2022-10-29 | 12.96 | 111.36 | 53.99 | |||
SO71794_53 | C39A-4835-99 | PO17574111985 | 19 | 291 | 490 | 2 | 678 | 6 | 8.77 | 2024-08-03 | 438.40 | 10.74 | 2024-07-22 | 14 | 41.57 | 1 | 429.63 | 53 | SO71794 | 2024-07-29 | 34.37 | 582.01 | 31.31 | 0.02 |
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 | |||
SO69479_35 | 3D8D-4908-A6 | PO18328116976 | 19 | 284 | 583 | 552 | 6 | 2024-07-03 | 1020.59 | 25.51 | 2024-06-21 | 1 | 1082.51 | 1 | 1020.59 | 35 | SO69479 | 2024-06-28 | 81.65 | 1082.51 | 1020.59 | |||
SO45054_4 | 308A-4BE0-A7 | PO12760127685 | 19 | 288 | 319 | 83 | 6 | 2022-03-05 | 4373.97 | 109.35 | 2022-02-21 | 5 | 884.71 | 1 | 4373.97 | 4 | SO45054 | 2022-02-28 | 349.92 | 4423.54 | 874.79 | |||
SO71781_9 | 2FB9-4F05-82 | PO19401117806 | 19 | 291 | 388 | 173 | 6 | 2024-08-03 | 1344.59 | 33.61 | 2024-07-22 | 2 | 713.08 | 1 | 1344.59 | 9 | SO71781 | 2024-07-29 | 107.57 | 1426.16 | 672.29 |
Generated 2024-09-20 09:45:39.616 UTC