[ROOT] dt FactResellerSale < WHERE DimSalesTerritoryId EQ '2' > SHUFFLE < SKIP 114 > < 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 |
---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
SO57076_21 | 4D9A-45E4-88 | PO10121190262 | 100 | 283 | 390 | 684 | 2 | 2024-02-27 | 2016.88 | 50.42 | 2024-02-15 | 3 | 713.08 | 1 | 2016.88 | 21 | SO57076 | 2024-02-22 | 161.35 | 2139.24 | 672.29 | |||
SO67271_13 | E734-4CEC-A8 | PO13775181029 | 100 | 283 | 604 | 618 | 2 | 2024-07-28 | 647.99 | 16.20 | 2024-07-16 | 2 | 343.65 | 1 | 647.99 | 13 | SO67271 | 2024-07-23 | 51.84 | 687.30 | 323.99 | |||
SO48361_6 | EC7D-4984-95 | PO3190190749 | 100 | 281 | 242 | 575 | 2 | 2023-03-29 | 2342.45 | 58.56 | 2023-03-17 | 3 | 722.26 | 1 | 2342.45 | 6 | SO48361 | 2023-03-24 | 187.40 | 2166.77 | 780.82 | |||
SO51860_19 | 3799-43C6-B7 | PO3625164674 | 100 | 283 | 384 | 666 | 2 | 2023-11-27 | 4706.06 | 117.65 | 2023-11-15 | 7 | 713.08 | 1 | 4706.06 | 19 | SO51860 | 2023-11-22 | 376.48 | 4991.56 | 672.29 | |||
SO46640_15 | AE5D-418B-B7 | PO10092115747 | 100 | 281 | 297 | 252 | 2 | 2022-10-27 | 2944.58 | 73.61 | 2022-10-15 | 4 | 653.70 | 1 | 2944.58 | 15 | SO46640 | 2022-10-22 | 235.57 | 2614.79 | 736.15 | |||
SO63137_1 | 269D-49DF-89 | PO18183116686 | 100 | 283 | 511 | 667 | 2 | 2024-05-29 | 218.45 | 5.46 | 2024-05-17 | 1 | 199.38 | 1 | 218.45 | 1 | SO63137 | 2024-05-24 | 17.48 | 199.38 | 218.45 | |||
SO48076_12 | C38A-4C0F-BD | PO7424167037 | 100 | 281 | 224 | 642 | 2 | 2023-02-27 | 15.56 | 0.39 | 2023-02-15 | 3 | 5.23 | 1 | 15.56 | 12 | SO48076 | 2023-02-22 | 1.24 | 15.69 | 5.19 | |||
SO67314_16 | 6653-491A-80 | PO3828116396 | 100 | 283 | 357 | 414 | 2 | 2024-07-28 | 2783.99 | 69.60 | 2024-07-16 | 2 | 1265.62 | 1 | 2783.99 | 16 | SO67314 | 2024-07-23 | 222.72 | 2531.24 | 1391.99 | |||
SO50263_4 | 7D74-4A96-A3 | PO18183117532 | 100 | 283 | 427 | 667 | 2 | 2023-08-27 | 627.77 | 15.69 | 2023-08-15 | 3 | 185.82 | 1 | 627.77 | 4 | SO50263 | 2023-08-22 | 50.22 | 557.46 | 209.26 | |||
SO53506_29 | B5B1-4DF9-82 | PO11455145357 | 100 | 283 | 442 | 72 | 2 | 2023-12-28 | 3435.60 | 85.89 | 2023-12-16 | 4 | 868.63 | 1 | 3435.60 | 29 | SO53506 | 2023-12-23 | 274.85 | 3474.54 | 858.90 | |||
SO53567_26 | 2385-4ADE-B6 | PO9628113784 | 100 | 283 | 570 | 13 | 179 | 2 | 100.22 | 2023-12-28 | 668.12 | 14.20 | 2023-12-16 | 2 | 461.44 | 1 | 567.90 | 26 | SO53567 | 2023-12-23 | 45.43 | 922.89 | 334.06 | 0.15 |
SO57101_1 | E5FB-42E2-A9 | PO18386193019 | 100 | 283 | 287 | 558 | 2 | 2024-02-27 | 202.33 | 5.06 | 2024-02-15 | 1 | 204.63 | 1 | 202.33 | 1 | SO57101 | 2024-02-22 | 16.19 | 204.63 | 202.33 | |||
SO53506_14 | B5B1-4DF9-82 | PO11455145357 | 100 | 283 | 384 | 72 | 2 | 2023-12-28 | 1344.59 | 33.61 | 2023-12-16 | 2 | 713.08 | 1 | 1344.59 | 14 | SO53506 | 2023-12-23 | 107.57 | 1426.16 | 672.29 | |||
SO48371_6 | AD41-4927-9B | PO4756123920 | 100 | 281 | 325 | 126 | 2 | 2023-03-29 | 469.79 | 11.74 | 2023-03-17 | 1 | 486.71 | 1 | 469.79 | 6 | SO48371 | 2023-03-24 | 37.58 | 486.71 | 469.79 | |||
SO53534_22 | F0B1-423E-8B | PO20213153510 | 100 | 283 | 214 | 216 | 2 | 2023-12-28 | 83.98 | 2.10 | 2023-12-16 | 4 | 13.09 | 1 | 83.98 | 22 | SO53534 | 2023-12-23 | 6.72 | 52.35 | 20.99 | |||
SO46363_8 | 29D0-4A7E-9E | PO3190140768 | 100 | 281 | 253 | 575 | 2 | 2022-09-27 | 178.58 | 4.46 | 2022-09-15 | 1 | 176.20 | 1 | 178.58 | 8 | SO46363 | 2022-09-22 | 14.29 | 176.20 | 178.58 | |||
SO50259_7 | 2D7F-444F-AE | PO18386133550 | 100 | 283 | 415 | 558 | 2 | 2023-08-27 | 792.14 | 19.80 | 2023-08-15 | 4 | 146.55 | 1 | 792.14 | 7 | SO50259 | 2023-08-22 | 63.37 | 586.19 | 198.04 | |||
SO67314_3 | 6653-491A-80 | PO3828116396 | 100 | 283 | 363 | 414 | 2 | 2024-07-28 | 1376.99 | 34.42 | 2024-07-16 | 1 | 1251.98 | 1 | 1376.99 | 3 | SO67314 | 2024-07-23 | 110.16 | 1251.98 | 1376.99 | |||
SO44129_8 | CE0D-4824-A6 | PO9483186106 | 100 | 281 | 272 | 54 | 2 | 2021-12-28 | 551.81 | 13.80 | 2021-12-16 | 3 | 181.49 | 1 | 551.81 | 8 | SO44129 | 2021-12-23 | 44.15 | 544.46 | 183.94 | |||
SO47975_33 | 5E8C-4BD8-B5 | PO18386179371 | 100 | 281 | 370 | 558 | 2 | 2023-02-27 | 1466.01 | 36.65 | 2023-02-15 | 1 | 1518.79 | 1 | 1466.01 | 33 | SO47975 | 2023-02-22 | 117.28 | 1518.79 | 1466.01 | |||
SO46993_43 | F652-4085-A4 | PO11658111433 | 100 | 272 | 233 | 233 | 2 | 2022-11-27 | 86.52 | 2.16 | 2022-11-15 | 3 | 29.08 | 1 | 86.52 | 43 | SO46993 | 2022-11-22 | 6.92 | 87.24 | 28.84 | |||
SO45562_4 | 75B5-4F4F-84 | PO4756131313 | 100 | 281 | 315 | 126 | 2 | 2022-06-27 | 874.79 | 21.87 | 2022-06-15 | 1 | 884.71 | 1 | 874.79 | 4 | SO45562 | 2022-06-22 | 69.98 | 884.71 | 874.79 | |||
SO55261_6 | 130D-46E9-9B | PO11484193890 | 100 | 283 | 533 | 594 | 2 | 2024-01-27 | 299.75 | 7.49 | 2024-01-15 | 2 | 136.79 | 1 | 299.75 | 6 | SO55261 | 2024-01-22 | 23.98 | 273.57 | 149.87 | |||
SO49157_20 | 9DDB-4852-A8 | PO7424122254 | 100 | 283 | 233 | 642 | 2 | 2023-05-30 | 115.36 | 2.88 | 2023-05-18 | 4 | 29.08 | 1 | 115.36 | 20 | SO49157 | 2023-05-25 | 9.23 | 116.32 | 28.84 |
Generated 2024-11-14 07:00:06.603 UTC