[ROOT] dt FactResellerSale < WHERE DimSalesTerritoryId EQ '10' > SHUFFLE SKIP 2000 < SKIP 285 > < TAKE 30 >
30 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 |
---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
SO49062_2 | D3FD-415F-A5 | PO928133820 | 98 | 288 | 397 | 484 | 10 | 2023-04-05 | 97.18 | 2.43 | 2023-03-24 | 4 | 17.98 | 1 | 97.18 | 2 | SO49062 | 2023-03-31 | 7.77 | 71.91 | 24.29 | |||
SO53455_26 | ACD7-4AF3-84 | PO19604185529 | 98 | 288 | 588 | 340 | 10 | 2023-11-03 | 923.39 | 23.08 | 2023-10-22 | 2 | 419.78 | 1 | 923.39 | 26 | SO53455 | 2023-10-29 | 73.87 | 839.56 | 461.69 | |||
SO48031_33 | 9EAA-4023-94 | PO957142471 | 98 | 288 | 365 | 376 | 10 | 2023-01-03 | 2591.98 | 64.80 | 2022-12-22 | 4 | 598.44 | 1 | 2591.98 | 33 | SO48031 | 2022-12-29 | 207.36 | 2393.74 | 647.99 | |||
SO71780_27 | 36CB-4A10-92 | PO19604173239 | 98 | 288 | 532 | 340 | 10 | 2024-08-03 | 149.87 | 3.75 | 2024-07-22 | 1 | 136.79 | 1 | 149.87 | 27 | SO71780 | 2024-07-29 | 11.99 | 136.79 | 149.87 | |||
SO71846_3 | 27C6-4DD9-83 | PO2378131604 | 98 | 288 | 591 | 16 | 635 | 10 | 45.20 | 2024-08-03 | 113.00 | 1.70 | 2024-07-22 | 1 | 308.22 | 1 | 67.80 | 3 | SO71846 | 2024-07-29 | 5.42 | 308.22 | 113.00 | 0.40 |
SO71832_3 | 269D-4F59-82 | PO10353140756 | 98 | 288 | 357 | 88 | 10 | 2024-08-03 | 2783.99 | 69.60 | 2024-07-22 | 2 | 1265.62 | 1 | 2783.99 | 3 | SO71832 | 2024-07-29 | 222.72 | 2531.24 | 1391.99 | |||
SO49510_19 | 34F7-4B7D-88 | PO8468119179 | 98 | 288 | 341 | 16 | 10 | 2023-05-03 | 1879.18 | 46.98 | 2023-04-21 | 4 | 486.71 | 1 | 1879.18 | 19 | SO49510 | 2023-04-28 | 150.33 | 1946.83 | 469.79 | |||
SO59063_36 | 81BA-420E-80 | PO8468196044 | 98 | 288 | 471 | 16 | 10 | 2024-02-02 | 190.50 | 4.76 | 2024-01-21 | 5 | 23.75 | 1 | 190.50 | 36 | SO59063 | 2024-01-28 | 15.24 | 118.75 | 38.10 | |||
SO53458_1 | 0728-4E88-9F | PO19285149036 | 98 | 288 | 502 | 448 | 10 | 2023-11-03 | 400.10 | 10.00 | 2023-10-22 | 2 | 199.85 | 1 | 400.10 | 1 | SO53458 | 2023-10-29 | 32.01 | 399.70 | 200.05 | |||
SO69392_3 | BEC8-4402-A2 | PO20184195444 | 98 | 288 | 463 | 358 | 10 | 2024-07-03 | 29.39 | 0.73 | 2024-06-21 | 2 | 9.16 | 1 | 29.39 | 3 | SO69392 | 2024-06-28 | 2.35 | 18.32 | 14.69 | |||
SO53455_23 | ACD7-4AF3-84 | PO19604185529 | 98 | 288 | 589 | 340 | 10 | 2023-11-03 | 1385.08 | 34.63 | 2023-10-22 | 3 | 419.78 | 1 | 1385.08 | 23 | SO53455 | 2023-10-29 | 110.81 | 1259.34 | 461.69 | |||
SO69456_46 | CCD9-4C53-AB | PO957172965 | 98 | 288 | 477 | 376 | 10 | 2024-07-03 | 11.98 | 0.30 | 2024-06-21 | 4 | 1.87 | 1 | 11.98 | 46 | SO69456 | 2024-06-28 | 0.96 | 7.47 | 2.99 | |||
SO49065_18 | E9BC-440A-9D | PO1508143526 | 98 | 288 | 369 | 430 | 10 | 2023-04-05 | 2932.02 | 73.30 | 2023-03-24 | 2 | 1518.79 | 1 | 2932.02 | 18 | SO49065 | 2023-03-31 | 234.56 | 3037.57 | 1466.01 | |||
SO50237_8 | 6856-44BE-87 | PO928122277 | 98 | 288 | 420 | 484 | 10 | 2023-07-03 | 283.23 | 7.08 | 2023-06-21 | 2 | 104.80 | 1 | 283.23 | 8 | SO50237 | 2023-06-28 | 22.66 | 209.59 | 141.62 | |||
SO55268_19 | 47E6-44B3-A4 | PO10324191521 | 98 | 288 | 472 | 3 | 196 | 10 | 26.19 | 2023-12-03 | 523.88 | 12.44 | 2023-11-21 | 15 | 23.75 | 1 | 497.68 | 19 | SO55268 | 2023-11-28 | 39.81 | 356.24 | 34.93 | 0.05 |
SO51083_14 | 742D-4BE9-A5 | PO696130231 | 98 | 288 | 487 | 232 | 10 | 2023-09-02 | 65.99 | 1.65 | 2023-08-21 | 2 | 20.57 | 1 | 65.99 | 14 | SO51083 | 2023-08-28 | 5.28 | 41.13 | 32.99 | |||
SO71784_21 | B186-4413-B4 | PO19285135919 | 98 | 288 | 564 | 2 | 448 | 10 | 331.86 | 2024-08-03 | 16593.13 | 406.53 | 2024-07-22 | 12 | 1481.94 | 1 | 16261.26 | 21 | SO71784 | 2024-07-29 | 1300.90 | 17783.25 | 1382.76 | 0.02 |
SO55236_24 | F466-42CE-8B | PO19575117252 | 98 | 288 | 559 | 34 | 10 | 2023-12-03 | 12.14 | 0.30 | 2023-11-21 | 1 | 8.99 | 1 | 12.14 | 24 | SO55236 | 2023-11-28 | 0.97 | 8.99 | 12.14 | |||
SO47451_4 | 6525-4619-9A | PO8671131661 | 98 | 288 | 412 | 502 | 10 | 2022-11-03 | 720.52 | 18.01 | 2022-10-22 | 4 | 133.30 | 1 | 720.52 | 4 | SO47451 | 2022-10-29 | 57.64 | 533.18 | 180.13 | |||
SO71797_45 | 8375-4C38-91 | PO16501134889 | 98 | 288 | 217 | 2 | 142 | 10 | 4.87 | 2024-08-03 | 243.53 | 5.97 | 2024-07-22 | 12 | 13.09 | 1 | 238.66 | 45 | SO71797 | 2024-07-29 | 19.09 | 157.04 | 20.29 | 0.02 |
SO53455_32 | ACD7-4AF3-84 | PO19604185529 | 98 | 288 | 594 | 340 | 10 | 2023-11-03 | 677.99 | 16.95 | 2023-10-22 | 2 | 308.22 | 1 | 677.99 | 32 | SO53455 | 2023-10-29 | 54.24 | 616.44 | 338.99 | |||
SO51763_50 | CDB1-4311-8D | PO957124084 | 98 | 288 | 359 | 376 | 10 | 2023-10-03 | 2753.99 | 68.85 | 2023-09-21 | 2 | 1251.98 | 1 | 2753.99 | 50 | SO51763 | 2023-09-28 | 220.32 | 2503.96 | 1376.99 | |||
SO57080_39 | A38F-4C07-81 | PO957167312 | 98 | 288 | 594 | 376 | 10 | 2024-01-03 | 338.99 | 8.47 | 2023-12-22 | 1 | 308.22 | 1 | 338.99 | 39 | SO57080 | 2023-12-29 | 27.12 | 308.22 | 338.99 | |||
SO58908_28 | A429-40BA-96 | PO19285116289 | 98 | 290 | 496 | 448 | 10 | 2024-02-02 | 2409.38 | 60.23 | 2024-01-21 | 4 | 601.74 | 1 | 2409.38 | 28 | SO58908 | 2024-01-28 | 192.75 | 2406.97 | 602.35 | |||
SO55288_5 | DA83-4A4B-A6 | PO14355177852 | 98 | 288 | 605 | 286 | 10 | 2023-12-03 | 323.99 | 8.10 | 2023-11-21 | 1 | 343.65 | 1 | 323.99 | 5 | SO55288 | 2023-11-28 | 25.92 | 343.65 | 323.99 | |||
SO53573_25 | F674-4899-B9 | PO8671117198 | 98 | 288 | 544 | 502 | 10 | 2023-11-03 | 194.38 | 4.86 | 2023-10-22 | 4 | 35.96 | 1 | 194.38 | 25 | SO53573 | 2023-10-29 | 15.55 | 143.84 | 48.59 | |||
SO71832_29 | 269D-4F59-82 | PO10353140756 | 98 | 288 | 524 | 88 | 10 | 2024-08-03 | 950.58 | 23.76 | 2024-07-22 | 6 | 144.59 | 1 | 950.58 | 29 | SO71832 | 2024-07-29 | 76.05 | 867.56 | 158.43 | |||
SO53577_37 | A44D-449C-80 | PO5713160840 | 98 | 288 | 585 | 13 | 52 | 10 | 50.11 | 2023-11-03 | 334.06 | 7.10 | 2023-10-22 | 1 | 461.44 | 1 | 283.95 | 37 | SO53577 | 2023-10-29 | 22.72 | 461.44 | 334.06 | 0.15 |
SO63170_37 | 9588-481B-B3 | PO957184615 | 98 | 288 | 593 | 376 | 10 | 2024-04-04 | 338.99 | 8.47 | 2024-03-23 | 1 | 308.22 | 1 | 338.99 | 37 | SO63170 | 2024-03-30 | 27.12 | 308.22 | 338.99 | |||
SO65154_22 | D373-4F8D-B5 | PO19604162014 | 98 | 288 | 589 | 340 | 10 | 2024-05-03 | 461.69 | 11.54 | 2024-04-21 | 1 | 419.78 | 1 | 461.69 | 22 | SO65154 | 2024-04-28 | 36.94 | 419.78 | 461.69 |
Generated 2024-09-20 07:27:35.517 UTC