[ROOT] dt FactResellerSale < WHERE DimSalesTerritoryId EQ '6' > SHUFFLE < SKIP 7195 > < 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 |
---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
SO61222_5 | 9C3C-4330-8A | PO13862196260 | 19 | 291 | 592 | 119 | 6 | 2024-03-05 | 677.99 | 16.95 | 2024-02-22 | 2 | 308.22 | 1 | 677.99 | 5 | SO61222 | 2024-02-29 | 54.24 | 616.44 | 338.99 | |||
SO46616_44 | 1264-43E6-B7 | PO14732122562 | 19 | 291 | 257 | 514 | 6 | 2022-09-03 | 367.88 | 9.20 | 2022-08-22 | 2 | 170.14 | 1 | 367.88 | 44 | SO46616 | 2022-08-29 | 29.43 | 340.29 | 183.94 | |||
SO65188_8 | 86B3-49B3-A1 | PO14790112162 | 19 | 291 | 512 | 497 | 6 | 2024-05-04 | 218.45 | 5.46 | 2024-04-22 | 1 | 199.38 | 1 | 218.45 | 8 | SO65188 | 2024-04-29 | 17.48 | 199.38 | 218.45 | |||
SO46997_18 | 9714-4035-90 | PO11020181604 | 19 | 284 | 415 | 336 | 6 | 2022-10-04 | 198.04 | 4.95 | 2022-09-22 | 1 | 146.55 | 1 | 198.04 | 18 | SO46997 | 2022-09-29 | 15.84 | 146.55 | 198.04 | |||
SO46935_2 | B87B-4E1A-81 | PO19459188557 | 19 | 291 | 417 | 334 | 6 | 2022-10-04 | 324.45 | 8.11 | 2022-09-22 | 1 | 300.12 | 1 | 324.45 | 2 | SO46935 | 2022-09-29 | 25.96 | 300.12 | 324.45 | |||
SO47012_40 | 5043-4C8B-B3 | PO1914167487 | 19 | 284 | 381 | 66 | 6 | 2022-10-04 | 1200.53 | 30.01 | 2022-09-22 | 2 | 605.65 | 1 | 1200.53 | 40 | SO47012 | 2022-09-29 | 96.04 | 1211.30 | 600.26 | |||
SO50676_8 | 66F1-4A9A-97 | PO14790188963 | 19 | 291 | 364 | 497 | 6 | 2023-08-04 | 1295.99 | 32.40 | 2023-07-23 | 2 | 598.44 | 1 | 1295.99 | 8 | SO50676 | 2023-07-30 | 103.68 | 1196.87 | 647.99 | |||
SO47980_16 | 4C76-4276-8E | PO17603160708 | 19 | 284 | 327 | 12 | 6 | 2023-01-04 | 1409.38 | 35.23 | 2022-12-23 | 3 | 486.71 | 1 | 1409.38 | 16 | SO47980 | 2022-12-30 | 112.75 | 1460.12 | 469.79 | |||
SO47031_17 | 3FA6-4120-BD | PO4466161844 | 19 | 291 | 397 | 352 | 6 | 2022-10-04 | 48.59 | 1.21 | 2022-09-22 | 2 | 17.98 | 1 | 48.59 | 17 | SO47031 | 2022-09-29 | 3.89 | 35.96 | 24.29 | |||
SO44103_4 | 5754-4536-B8 | PO11107175113 | 19 | 284 | 232 | 156 | 6 | 2021-11-04 | 28.84 | 0.72 | 2021-10-23 | 1 | 31.72 | 1 | 28.84 | 4 | SO44103 | 2021-10-30 | 2.31 | 31.72 | 28.84 | |||
SO47663_23 | 1B17-4C63-B6 | PO18444192283 | 19 | 291 | 415 | 227 | 6 | 2022-12-04 | 792.14 | 19.80 | 2022-11-22 | 4 | 146.55 | 1 | 792.14 | 23 | SO47663 | 2022-11-29 | 63.37 | 586.19 | 198.04 | |||
SO43898_7 | 420C-4ECE-85 | PO4901196283 | 19 | 284 | 212 | 84 | 6 | 2021-10-04 | 100.93 | 2.52 | 2021-09-22 | 5 | 12.03 | 1 | 100.93 | 7 | SO43898 | 2021-09-29 | 8.07 | 60.14 | 20.19 | |||
SO48754_23 | FC6A-4A9E-83 | PO18473150383 | 19 | 291 | 470 | 442 | 6 | 2023-03-06 | 91.18 | 2.28 | 2023-02-22 | 4 | 15.67 | 1 | 91.18 | 23 | SO48754 | 2023-03-01 | 7.29 | 62.68 | 22.79 | |||
SO46333_14 | B042-408B-A8 | PO17545158984 | 19 | 288 | 264 | 155 | 6 | 2022-08-04 | 367.88 | 9.20 | 2022-07-23 | 2 | 181.49 | 1 | 367.88 | 14 | SO46333 | 2022-07-30 | 29.43 | 362.97 | 183.94 | |||
SO50284_32 | F8D1-49E1-A5 | PO4901178867 | 19 | 284 | 333 | 84 | 6 | 2023-07-04 | 939.59 | 23.49 | 2023-06-22 | 2 | 486.71 | 1 | 939.59 | 32 | SO50284 | 2023-06-29 | 75.17 | 973.41 | 469.79 | |||
SO58953_18 | 99EE-491E-BD | PO11107122647 | 19 | 284 | 605 | 156 | 6 | 2024-02-03 | 647.99 | 16.20 | 2024-01-22 | 2 | 343.65 | 1 | 647.99 | 18 | SO58953 | 2024-01-29 | 51.84 | 687.30 | 323.99 | |||
SO48082_1 | CF66-4E36-A0 | PO7337178378 | 19 | 284 | 360 | 516 | 6 | 2023-01-04 | 1229.46 | 30.74 | 2022-12-23 | 1 | 1105.81 | 1 | 1229.46 | 1 | SO48082 | 2022-12-30 | 98.36 | 1105.81 | 1229.46 | |||
SO53536_37 | 5C09-4051-92 | PO18299189909 | 19 | 291 | 588 | 118 | 6 | 2023-11-04 | 461.69 | 11.54 | 2023-10-23 | 1 | 419.78 | 1 | 461.69 | 37 | SO53536 | 2023-10-30 | 36.94 | 419.78 | 461.69 | |||
SO51092_13 | FB68-47B7-9D | PO15312133079 | 19 | 291 | 520 | 299 | 6 | 2023-09-03 | 63.17 | 1.58 | 2023-08-22 | 2 | 23.37 | 1 | 63.17 | 13 | SO51092 | 2023-08-29 | 5.05 | 46.74 | 31.58 | |||
SO53535_2 | 8195-45C7-93 | PO18502176746 | 19 | 291 | 521 | 154 | 6 | 2023-11-04 | 32.54 | 0.81 | 2023-10-23 | 2 | 12.04 | 1 | 32.54 | 2 | SO53535 | 2023-10-30 | 2.60 | 24.08 | 16.27 | |||
SO53527_32 | 0EBE-4ACB-B5 | PO1798140946 | 19 | 291 | 595 | 10 | 6 | 2023-11-04 | 1016.98 | 25.42 | 2023-10-23 | 3 | 308.22 | 1 | 1016.98 | 32 | SO53527 | 2023-10-30 | 81.36 | 924.65 | 338.99 | |||
SO46608_2 | ACF1-4852-B7 | PO18473177913 | 19 | 291 | 308 | 442 | 6 | 2022-09-03 | 2977.09 | 74.43 | 2022-08-22 | 4 | 660.91 | 1 | 2977.09 | 2 | SO46608 | 2022-08-29 | 238.17 | 2643.66 | 744.27 | |||
SO50668_43 | A5FC-4831-B4 | PO17574113752 | 19 | 291 | 456 | 678 | 6 | 2023-08-04 | 404.95 | 10.12 | 2023-07-23 | 9 | 30.93 | 1 | 404.95 | 43 | SO50668 | 2023-07-30 | 32.40 | 278.40 | 44.99 | |||
SO69401_10 | 5377-4B5B-80 | PO17603155358 | 19 | 284 | 225 | 3 | 12 | 6 | 3.96 | 2024-07-04 | 79.11 | 1.88 | 2024-06-22 | 16 | 6.92 | 1 | 75.16 | 10 | SO69401 | 2024-06-29 | 6.01 | 110.76 | 4.94 | 0.05 |
Generated 2024-09-21 10:31:59.525 UTC