[ROOT] dt FactResellerSale < WHERE DimSalesTerritoryId EQ '5' > SHUFFLE < SKIP 754 > < TAKE 32 >
32 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 |
---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
SO51175_1 | CB3E-40EB-B7 | PO9947150647 | 100 | 285 | 482 | 603 | 5 | 2023-09-03 | 21.58 | 0.54 | 2023-08-22 | 4 | 3.36 | 1 | 21.58 | 1 | SO51175 | 2023-08-29 | 1.73 | 13.45 | 5.39 | |||
SO45331_5 | 4702-48B5-B8 | PO6293165974 | 100 | 285 | 332 | 612 | 5 | 2022-04-06 | 419.46 | 10.49 | 2022-03-25 | 1 | 413.15 | 1 | 419.46 | 5 | SO45331 | 2022-04-01 | 33.56 | 413.15 | 419.46 | |||
SO53530_7 | A31D-483D-A1 | PO2813121313 | 100 | 283 | 408 | 90 | 5 | 2023-11-04 | 505.13 | 12.63 | 2023-10-23 | 7 | 53.40 | 1 | 505.13 | 7 | SO53530 | 2023-10-30 | 40.41 | 373.80 | 72.16 | |||
SO50306_33 | D376-4A40-86 | PO5858194676 | 100 | 285 | 421 | 566 | 5 | 2023-07-04 | 1177.97 | 29.45 | 2023-06-22 | 6 | 145.28 | 1 | 1177.97 | 33 | SO50306 | 2023-06-29 | 94.24 | 871.70 | 196.33 | |||
SO53524_4 | 2B2B-440F-8B | PO1537151724 | 100 | 285 | 507 | 611 | 5 | 2023-11-04 | 200.05 | 5.00 | 2023-10-23 | 1 | 199.85 | 1 | 200.05 | 4 | SO53524 | 2023-10-30 | 16.00 | 199.85 | 200.05 | |||
SO47455_44 | 41F3-48C2-B7 | PO9599169586 | 100 | 285 | 263 | 170 | 5 | 2022-11-04 | 1011.66 | 25.29 | 2022-10-23 | 5 | 187.16 | 1 | 1011.66 | 44 | SO47455 | 2022-10-30 | 80.93 | 935.79 | 202.33 | |||
SO51162_1 | E13E-474C-B5 | PO4176153007 | 100 | 285 | 418 | 458 | 5 | 2023-09-03 | 356.90 | 8.92 | 2023-08-22 | 1 | 360.94 | 1 | 356.90 | 1 | SO51162 | 2023-08-29 | 28.55 | 360.94 | 356.90 | |||
SO49869_5 | A2BD-4A89-93 | PO9657193666 | 100 | 285 | 352 | 315 | 5 | 2023-06-04 | 2485.70 | 62.14 | 2023-05-23 | 2 | 1117.86 | 1 | 2485.70 | 5 | SO49869 | 2023-05-30 | 198.86 | 2235.71 | 1242.85 | |||
SO58993_12 | EEB4-42E9-B9 | PO14297167367 | 100 | 285 | 601 | 627 | 5 | 2024-02-03 | 32.39 | 0.81 | 2024-01-22 | 1 | 23.97 | 1 | 32.39 | 12 | SO58993 | 2024-01-29 | 2.59 | 23.97 | 32.39 | |||
SO50756_2 | C414-447C-84 | PO9570119689 | 100 | 285 | 470 | 585 | 5 | 2023-08-04 | 159.56 | 3.99 | 2023-07-23 | 7 | 15.67 | 1 | 159.56 | 2 | SO50756 | 2023-07-30 | 12.76 | 109.70 | 22.79 | |||
SO43861_3 | 0CC0-4166-9E | PO16327172067 | 100 | 285 | 342 | 584 | 5 | 2021-10-04 | 2097.29 | 52.43 | 2021-09-22 | 5 | 413.15 | 1 | 2097.29 | 3 | SO43861 | 2021-09-29 | 167.78 | 2065.73 | 419.46 | |||
SO53568_5 | 4523-4AB4-99 | PO9222138547 | 100 | 285 | 606 | 171 | 5 | 2023-11-04 | 647.99 | 16.20 | 2023-10-23 | 2 | 343.65 | 1 | 647.99 | 5 | SO53568 | 2023-10-30 | 51.84 | 687.30 | 323.99 | |||
SO61173_13 | 6B8D-47B8-8E | PO522171689 | 100 | 285 | 490 | 676 | 5 | 2024-03-05 | 161.97 | 4.05 | 2024-02-22 | 5 | 41.57 | 1 | 161.97 | 13 | SO61173 | 2024-02-29 | 12.96 | 207.86 | 32.39 | |||
SO49145_2 | 31DA-4BD5-9C | PO5568187962 | 100 | 285 | 468 | 422 | 5 | 2023-04-06 | 22.79 | 0.57 | 2023-03-25 | 1 | 15.67 | 1 | 22.79 | 2 | SO49145 | 2023-04-01 | 1.82 | 15.67 | 22.79 | |||
SO49822_26 | 191D-4AD7-93 | PO522119337 | 100 | 285 | 360 | 676 | 5 | 2023-06-04 | 2458.92 | 61.47 | 2023-05-23 | 2 | 1105.81 | 1 | 2458.92 | 26 | SO49822 | 2023-05-30 | 196.71 | 2211.62 | 1229.46 | |||
SO46635_2 | 61A1-4A71-99 | PO10005144378 | 100 | 285 | 453 | 628 | 5 | 2022-09-03 | 35.99 | 0.90 | 2022-08-22 | 1 | 24.75 | 1 | 35.99 | 2 | SO46635 | 2022-08-29 | 2.88 | 24.75 | 35.99 | |||
SO48018_24 | 5D69-492B-A1 | PO11571175810 | 100 | 285 | 417 | 512 | 5 | 2023-01-04 | 648.91 | 16.22 | 2022-12-23 | 2 | 300.12 | 1 | 648.91 | 24 | SO48018 | 2022-12-30 | 51.91 | 600.24 | 324.45 | |||
SO46090_1 | 987E-4B5B-B6 | PO5858172038 | 100 | 285 | 212 | 566 | 5 | 2022-07-04 | 100.93 | 2.52 | 2022-06-22 | 5 | 12.03 | 1 | 100.93 | 1 | SO46090 | 2022-06-29 | 8.07 | 60.14 | 20.19 | |||
SO51775_15 | 5DF8-4C96-81 | PO2842127356 | 100 | 285 | 388 | 700 | 5 | 2023-10-04 | 1344.59 | 33.61 | 2023-09-22 | 2 | 713.08 | 1 | 1344.59 | 15 | SO51775 | 2023-09-29 | 107.57 | 1426.16 | 672.29 | |||
SO69518_23 | 96AA-48F8-80 | PO5800191682 | 100 | 285 | 512 | 63 | 5 | 2024-07-04 | 655.36 | 16.38 | 2024-06-22 | 3 | 199.38 | 1 | 655.36 | 23 | SO69518 | 2024-06-29 | 52.43 | 598.13 | 218.45 | |||
SO46991_1 | 6D99-4D79-AA | PO11803111101 | 100 | 285 | 233 | 513 | 5 | 2022-10-04 | 57.68 | 1.44 | 2022-09-22 | 2 | 29.08 | 1 | 57.68 | 1 | SO46991 | 2022-09-29 | 4.61 | 58.16 | 28.84 | |||
SO48395_34 | 46D3-4C51-AD | PO9570174316 | 100 | 285 | 213 | 585 | 5 | 2023-02-03 | 80.75 | 2.02 | 2023-01-22 | 4 | 13.88 | 1 | 80.75 | 34 | SO48395 | 2023-01-29 | 6.46 | 55.51 | 20.19 | |||
SO51824_26 | A1F7-477E-BA | PO5800114202 | 100 | 285 | 559 | 63 | 5 | 2023-10-04 | 24.29 | 0.61 | 2023-09-22 | 2 | 8.99 | 1 | 24.29 | 26 | SO51824 | 2023-09-29 | 1.94 | 17.97 | 12.14 | |||
SO67277_11 | 9AB3-4F34-85 | PO12644174121 | 100 | 272 | 531 | 530 | 5 | 2024-06-04 | 299.75 | 7.49 | 2024-05-23 | 2 | 136.79 | 1 | 299.75 | 11 | SO67277 | 2024-05-30 | 23.98 | 273.57 | 149.87 | |||
SO55331_10 | 4195-4A79-A3 | PO9889143385 | 100 | 285 | 594 | 494 | 5 | 2023-12-04 | 1016.98 | 25.42 | 2023-11-22 | 3 | 308.22 | 1 | 1016.98 | 10 | SO55331 | 2023-11-29 | 81.36 | 924.65 | 338.99 | |||
SO50306_29 | D376-4A40-86 | PO5858194676 | 100 | 285 | 358 | 566 | 5 | 2023-07-04 | 2458.92 | 61.47 | 2023-06-22 | 2 | 1105.81 | 1 | 2458.92 | 29 | SO50306 | 2023-06-29 | 196.71 | 2211.62 | 1229.46 | |||
SO49124_8 | 795F-4192-AD | PO3596184634 | 100 | 285 | 470 | 476 | 5 | 2023-04-06 | 113.97 | 2.85 | 2023-03-25 | 5 | 15.67 | 1 | 113.97 | 8 | SO49124 | 2023-04-01 | 9.12 | 78.35 | 22.79 | |||
SO44098_5 | AB18-4E5B-98 | PO13746121367 | 100 | 285 | 218 | 3 | 567 | 5 | 5.75 | 2021-11-04 | 114.95 | 2.73 | 2021-10-23 | 22 | 3.40 | 1 | 109.20 | 5 | SO44098 | 2021-10-30 | 8.74 | 74.72 | 5.23 | 0.05 |
SO71909_2 | 2E44-4C3C-BC | PO4089160365 | 100 | 285 | 474 | 368 | 5 | 2024-08-04 | 209.97 | 5.25 | 2024-07-23 | 5 | 26.18 | 1 | 209.97 | 2 | SO71909 | 2024-07-30 | 16.80 | 130.88 | 41.99 | |||
SO46604_25 | 8062-4A97-B3 | PO522154989 | 100 | 285 | 458 | 676 | 5 | 2022-09-03 | 134.98 | 3.37 | 2022-08-22 | 3 | 30.93 | 1 | 134.98 | 25 | SO46604 | 2022-08-29 | 10.80 | 92.80 | 44.99 | |||
SO46631_14 | D8CB-44CB-87 | PO11861116846 | 100 | 281 | 428 | 17 | 5 | 2022-09-03 | 418.51 | 10.46 | 2022-08-22 | 2 | 185.82 | 1 | 418.51 | 14 | SO46631 | 2022-08-29 | 33.48 | 371.64 | 209.26 | |||
SO51705_1 | DFFB-4C23-BD | PO16965171069 | 100 | 285 | 490 | 441 | 5 | 2023-10-04 | 226.76 | 5.67 | 2023-09-22 | 7 | 41.57 | 1 | 226.76 | 1 | SO51705 | 2023-09-29 | 18.14 | 291.01 | 32.39 |
Generated 2024-09-21 07:45:48.917 UTC