[ROOT] dt FactResellerSale < WHERE DimSalesTerritoryId EQ '5' > SHUFFLE < SKIP 1293 > < TAKE 28 >
28 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 |
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
| SO53551_33 | 8593-405C-AB | PO14297167079 | 100 | 285 | 564 | 14 | 627 | 5 | 190.73 | 2023-12-24 | 953.63 | 19.07 | 2023-12-12 | 1 | 1481.94 | 1 | 762.90 | 33 | SO53551 | 2023-12-19 | 61.03 | 1481.94 | 953.63 | 0.20 |
| SO49836_35 | 0E32-48F7-89 | PO12644185975 | 100 | 285 | 213 | 530 | 5 | 2023-07-24 | 60.56 | 1.51 | 2023-07-12 | 3 | 13.88 | 1 | 60.56 | 35 | SO49836 | 2023-07-19 | 4.84 | 41.63 | 20.19 | |||
| SO46604_37 | 8062-4A97-B3 | PO522154989 | 100 | 285 | 216 | 8 | 676 | 5 | 6.73 | 2022-10-23 | 67.29 | 1.51 | 2022-10-11 | 4 | 13.88 | 1 | 60.56 | 37 | SO46604 | 2022-10-18 | 4.84 | 55.51 | 16.82 | 0.10 |
| SO48730_6 | C918-466B-B1 | PO522152463 | 100 | 285 | 360 | 676 | 5 | 2023-04-25 | 3688.38 | 92.21 | 2023-04-13 | 3 | 1105.81 | 1 | 3688.38 | 6 | SO48730 | 2023-04-20 | 295.07 | 3317.43 | 1229.46 | |||
| SO48063_22 | AEA4-4489-90 | PO5858143254 | 100 | 285 | 396 | 566 | 5 | 2023-02-23 | 74.84 | 1.87 | 2023-02-11 | 1 | 55.38 | 1 | 74.84 | 22 | SO48063 | 2023-02-18 | 5.99 | 55.38 | 74.84 | |||
| SO48051_9 | D18B-421F-99 | PO3596190178 | 100 | 285 | 421 | 476 | 5 | 2023-02-23 | 392.66 | 9.82 | 2023-02-11 | 2 | 145.28 | 1 | 392.66 | 9 | SO48051 | 2023-02-18 | 31.41 | 290.57 | 196.33 | |||
| SO46384_13 | 9F38-4366-91 | PO9541189751 | 100 | 285 | 220 | 279 | 5 | 2022-09-23 | 80.75 | 2.02 | 2022-09-11 | 4 | 12.03 | 1 | 80.75 | 13 | SO46384 | 2022-09-18 | 6.46 | 48.11 | 20.19 | |||
| SO67260_36 | 6224-4229-B8 | PO522163557 | 100 | 285 | 587 | 676 | 5 | 2024-07-24 | 2308.47 | 57.71 | 2024-07-12 | 5 | 419.78 | 1 | 2308.47 | 36 | SO67260 | 2024-07-19 | 184.68 | 2098.89 | 461.69 | |||
| SO48730_22 | C918-466B-B1 | PO522152463 | 100 | 285 | 221 | 676 | 5 | 2023-04-25 | 40.37 | 1.01 | 2023-04-13 | 2 | 13.88 | 1 | 40.37 | 22 | SO48730 | 2023-04-20 | 3.23 | 27.76 | 20.19 | |||
| SO51081_16 | EDBF-4FE1-8F | PO522116846 | 100 | 285 | 525 | 676 | 5 | 2023-10-23 | 158.43 | 3.96 | 2023-10-11 | 1 | 144.59 | 1 | 158.43 | 16 | SO51081 | 2023-10-18 | 12.67 | 144.59 | 158.43 | |||
| SO63181_20 | CB4E-4CF5-87 | PO2842135731 | 100 | 285 | 380 | 700 | 5 | 2024-05-25 | 1466.01 | 36.65 | 2024-05-13 | 1 | 1554.95 | 1 | 1466.01 | 20 | SO63181 | 2024-05-20 | 117.28 | 1554.95 | 1466.01 | |||
| SO51081_25 | EDBF-4FE1-8F | PO522116846 | 100 | 285 | 217 | 11 | 676 | 5 | 14.17 | 2023-10-23 | 94.47 | 2.01 | 2023-10-11 | 6 | 13.09 | 1 | 80.30 | 25 | SO51081 | 2023-10-18 | 6.42 | 78.52 | 15.75 | 0.15 |
| SO48062_4 | DB45-43CB-82 | PO5568119115 | 100 | 285 | 358 | 422 | 5 | 2023-02-23 | 6147.29 | 153.68 | 2023-02-11 | 5 | 1105.81 | 1 | 6147.29 | 4 | SO48062 | 2023-02-18 | 491.78 | 5529.05 | 1229.46 | |||
| SO67277_42 | 9AB3-4F34-85 | PO12644174121 | 100 | 272 | 490 | 530 | 5 | 2024-07-24 | 194.36 | 4.86 | 2024-07-12 | 6 | 41.57 | 1 | 194.36 | 42 | SO67277 | 2024-07-19 | 15.55 | 249.43 | 32.39 | |||
| SO46630_22 | F512-40F2-91 | PO12644161356 | 100 | 285 | 230 | 530 | 5 | 2022-10-23 | 57.68 | 1.44 | 2022-10-11 | 2 | 29.08 | 1 | 57.68 | 22 | SO46630 | 2022-10-18 | 4.61 | 58.16 | 28.84 | |||
| SO46384_5 | 9F38-4366-91 | PO9541189751 | 100 | 285 | 218 | 279 | 5 | 2022-09-23 | 34.20 | 0.86 | 2022-09-11 | 6 | 3.40 | 1 | 34.20 | 5 | SO46384 | 2022-09-18 | 2.74 | 20.38 | 5.70 | |||
| SO46091_20 | 6DCB-4063-BA | PO6293193126 | 100 | 285 | 262 | 612 | 5 | 2022-08-23 | 183.94 | 4.60 | 2022-08-11 | 1 | 181.49 | 1 | 183.94 | 20 | SO46091 | 2022-08-18 | 14.72 | 181.49 | 183.94 | |||
| SO48063_28 | AEA4-4489-90 | PO5858143254 | 100 | 285 | 216 | 566 | 5 | 2023-02-23 | 141.31 | 3.53 | 2023-02-11 | 7 | 13.88 | 1 | 141.31 | 28 | SO48063 | 2023-02-18 | 11.30 | 97.15 | 20.19 | |||
| SO61230_9 | B9F1-4FF8-B4 | PO12644163346 | 100 | 285 | 471 | 530 | 5 | 2024-04-24 | 152.40 | 3.81 | 2024-04-12 | 4 | 23.75 | 1 | 152.40 | 9 | SO61230 | 2024-04-19 | 12.19 | 95.00 | 38.10 | |||
| SO45802_10 | 8C6D-42B3-AA | PO1189157476 | 100 | 285 | 334 | 423 | 5 | 2022-07-24 | 838.92 | 20.97 | 2022-07-12 | 2 | 413.15 | 1 | 838.92 | 10 | SO45802 | 2022-07-19 | 67.11 | 826.29 | 419.46 | |||
| SO71844_18 | 410D-4079-9E | PO2813198985 | 100 | 283 | 382 | 90 | 5 | 2024-09-23 | 2689.18 | 67.23 | 2024-09-11 | 4 | 713.08 | 1 | 2689.18 | 18 | SO71844 | 2024-09-18 | 215.13 | 2852.32 | 672.29 | |||
| SO58987_2 | 9A04-4070-80 | PO18241161045 | 100 | 285 | 559 | 477 | 5 | 2024-03-24 | 12.14 | 0.30 | 2024-03-12 | 1 | 8.99 | 1 | 12.14 | 2 | SO58987 | 2024-03-19 | 0.97 | 8.99 | 12.14 | |||
| SO49124_10 | 795F-4192-AD | PO3596184634 | 100 | 285 | 360 | 476 | 5 | 2023-05-26 | 4917.84 | 122.95 | 2023-05-14 | 4 | 1105.81 | 1 | 4917.84 | 10 | SO49124 | 2023-05-21 | 393.43 | 4423.24 | 1229.46 | |||
| SO53524_15 | 2B2B-440F-8B | PO1537151724 | 100 | 285 | 477 | 2 | 611 | 5 | 0.81 | 2023-12-24 | 40.52 | 0.99 | 2023-12-12 | 14 | 1.87 | 1 | 39.71 | 15 | SO53524 | 2023-12-19 | 3.18 | 26.13 | 2.89 | 0.02 |
| SO53563_17 | C955-44BD-A8 | PO9599165865 | 100 | 285 | 520 | 170 | 5 | 2023-12-24 | 63.17 | 1.58 | 2023-12-12 | 2 | 23.37 | 1 | 63.17 | 17 | SO53563 | 2023-12-19 | 5.05 | 46.74 | 31.58 | |||
| SO46637_1 | 2223-4926-AF | PO10179129449 | 100 | 285 | 426 | 27 | 5 | 2022-10-23 | 209.26 | 5.23 | 2022-10-11 | 1 | 185.82 | 1 | 209.26 | 1 | SO46637 | 2022-10-18 | 16.74 | 185.82 | 209.26 | |||
| SO46630_33 | F512-40F2-91 | PO12644161356 | 100 | 285 | 412 | 530 | 5 | 2022-10-23 | 540.39 | 13.51 | 2022-10-11 | 3 | 133.30 | 1 | 540.39 | 33 | SO46630 | 2022-10-18 | 43.23 | 399.89 | 180.13 | |||
| SO44488_25 | 18BD-4C15-81 | PO19546136242 | 100 | 285 | 317 | 206 | 5 | 2022-02-23 | 1749.59 | 43.74 | 2022-02-11 | 2 | 884.71 | 1 | 1749.59 | 25 | SO44488 | 2022-02-18 | 139.97 | 1769.42 | 874.79 |
Generated 2024-11-10 17:38:06.203 UTC