[ROOT] dt FactResellerSale < WHERE DimSalesTerritoryId EQ '6' > SKIP 500 SHUFFLE < SKIP 94 > < TAKE 31 >
31 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 |
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
| SO46039_1 | D5C9-4969-86 | PO17313170717 | 19 | 288 | 349 | 389 | 6 | 2022-07-03 | 2024.99 | 50.62 | 2022-06-21 | 1 | 1898.09 | 1 | 2024.99 | 1 | SO46039 | 2022-06-28 | 162.00 | 1898.09 | 2024.99 | |||
| SO48778_21 | 4F83-4D59-87 | PO4495173571 | 19 | 291 | 458 | 496 | 6 | 2023-03-05 | 269.96 | 6.75 | 2023-02-21 | 6 | 30.93 | 1 | 269.96 | 21 | SO48778 | 2023-02-28 | 21.60 | 185.60 | 44.99 | |||
| SO44547_12 | 801C-4288-87 | PO4901179982 | 19 | 284 | 317 | 84 | 6 | 2022-01-03 | 2624.38 | 65.61 | 2021-12-22 | 3 | 884.71 | 1 | 2624.38 | 12 | SO44547 | 2021-12-29 | 209.95 | 2654.12 | 874.79 | |||
| SO57120_12 | 058D-436F-BF | PO4466170177 | 19 | 291 | 593 | 352 | 6 | 2024-01-03 | 1016.98 | 25.42 | 2023-12-22 | 3 | 308.22 | 1 | 1016.98 | 12 | SO57120 | 2023-12-29 | 81.36 | 924.65 | 338.99 | |||
| SO43889_2 | F108-4D76-8A | PO2030112412 | 19 | 284 | 235 | 661 | 6 | 2021-10-03 | 57.68 | 1.44 | 2021-09-21 | 2 | 31.72 | 1 | 57.68 | 2 | SO43889 | 2021-09-28 | 4.61 | 63.45 | 28.84 | |||
| SO57154_29 | 464B-46A4-B6 | PO1856185040 | 19 | 291 | 570 | 263 | 6 | 2024-01-03 | 445.41 | 11.14 | 2023-12-22 | 1 | 461.44 | 1 | 445.41 | 29 | SO57154 | 2023-12-29 | 35.63 | 461.44 | 445.41 | |||
| SO49070_11 | 2B81-47B6-AD | PO1827112158 | 19 | 291 | 335 | 317 | 6 | 2023-04-05 | 469.79 | 11.74 | 2023-03-24 | 1 | 486.71 | 1 | 469.79 | 11 | SO49070 | 2023-03-31 | 37.58 | 486.71 | 469.79 | |||
| SO44298_6 | 960B-4C26-9F | PO11049118093 | 19 | 284 | 319 | 679 | 6 | 2021-12-03 | 874.79 | 21.87 | 2021-11-21 | 1 | 884.71 | 1 | 874.79 | 6 | SO44298 | 2021-11-28 | 69.98 | 884.71 | 874.79 | |||
| SO51851_4 | E1D7-4D0E-9B | PO2262123570 | 19 | 291 | 575 | 629 | 6 | 2023-10-03 | 1430.44 | 35.76 | 2023-09-21 | 1 | 1481.94 | 1 | 1430.44 | 4 | SO51851 | 2023-09-28 | 114.44 | 1481.94 | 1430.44 | |||
| SO45278_14 | 7EE7-4F70-81 | PO18415191281 | 19 | 288 | 232 | 191 | 6 | 2022-04-05 | 28.84 | 0.72 | 2022-03-24 | 1 | 31.72 | 1 | 28.84 | 14 | SO45278 | 2022-03-31 | 2.31 | 31.72 | 28.84 | |||
| SO48033_34 | BC9E-4246-AC | PO1595118269 | 19 | 284 | 213 | 426 | 6 | 2023-01-03 | 100.93 | 2.52 | 2022-12-22 | 5 | 13.88 | 1 | 100.93 | 34 | SO48033 | 2022-12-29 | 8.07 | 69.39 | 20.19 | |||
| SO49052_22 | 8769-409E-94 | PO16733182723 | 19 | 291 | 233 | 533 | 6 | 2023-04-05 | 57.68 | 1.44 | 2023-03-24 | 2 | 29.08 | 1 | 57.68 | 22 | SO49052 | 2023-03-31 | 4.61 | 58.16 | 28.84 | |||
| SO57120_1 | 058D-436F-BF | PO4466170177 | 19 | 291 | 225 | 352 | 6 | 2024-01-03 | 26.97 | 0.67 | 2023-12-22 | 5 | 6.92 | 1 | 26.97 | 1 | SO57120 | 2023-12-29 | 2.16 | 34.61 | 5.39 | |||
| SO51793_21 | D763-4929-9B | PO18705168707 | 19 | 291 | 418 | 479 | 6 | 2023-10-03 | 1427.59 | 35.69 | 2023-09-21 | 4 | 360.94 | 1 | 1427.59 | 21 | SO51793 | 2023-09-28 | 114.21 | 1443.77 | 356.90 | |||
| SO49860_11 | DB5C-4441-BE | PO13862128354 | 19 | 291 | 401 | 119 | 6 | 2023-06-03 | 131.20 | 3.28 | 2023-05-22 | 2 | 48.55 | 1 | 131.20 | 11 | SO49860 | 2023-05-29 | 10.50 | 97.09 | 65.60 | |||
| SO61204_26 | E810-4164-82 | PO15312134209 | 19 | 291 | 374 | 299 | 6 | 2024-03-04 | 1466.01 | 36.65 | 2024-02-21 | 1 | 1554.95 | 1 | 1466.01 | 26 | SO61204 | 2024-02-28 | 117.28 | 1554.95 | 1466.01 | |||
| SO53536_61 | 5C09-4051-92 | PO18299189909 | 19 | 291 | 491 | 118 | 6 | 2023-11-03 | 323.94 | 8.10 | 2023-10-22 | 10 | 41.57 | 1 | 323.94 | 61 | SO53536 | 2023-10-29 | 25.92 | 415.72 | 32.39 | |||
| SO50664_28 | 85F5-458B-8D | PO19401149024 | 19 | 291 | 221 | 173 | 6 | 2023-08-03 | 121.12 | 3.03 | 2023-07-22 | 6 | 13.88 | 1 | 121.12 | 28 | SO50664 | 2023-07-29 | 9.69 | 83.27 | 20.19 | |||
| SO45323_5 | 8E16-4834-8A | PO4901118407 | 19 | 284 | 316 | 84 | 6 | 2022-04-05 | 874.79 | 21.87 | 2022-03-24 | 1 | 884.71 | 1 | 874.79 | 5 | SO45323 | 2022-03-31 | 69.98 | 884.71 | 874.79 | |||
| SO48072_5 | D4FC-4834-8F | PO6496174950 | 19 | 291 | 468 | 226 | 6 | 2023-01-03 | 22.79 | 0.57 | 2022-12-22 | 1 | 15.67 | 1 | 22.79 | 5 | SO48072 | 2022-12-29 | 1.82 | 15.67 | 22.79 | |||
| SO46936_2 | 95A0-4327-AA | PO19227121833 | 19 | 284 | 233 | 210 | 6 | 2022-10-03 | 144.20 | 3.61 | 2022-09-21 | 5 | 29.08 | 1 | 144.20 | 2 | SO46936 | 2022-09-28 | 11.54 | 145.40 | 28.84 | |||
| SO45792_4 | D5D3-43B4-A2 | PO13862173868 | 19 | 288 | 296 | 119 | 6 | 2022-06-03 | 714.70 | 17.87 | 2022-05-22 | 1 | 617.03 | 1 | 714.70 | 4 | SO45792 | 2022-05-29 | 57.18 | 617.03 | 714.70 | |||
| SO55297_24 | 2455-4B60-A5 | PO4495126679 | 19 | 291 | 225 | 496 | 6 | 2023-12-03 | 43.15 | 1.08 | 2023-11-21 | 8 | 6.92 | 1 | 43.15 | 24 | SO55297 | 2023-11-28 | 3.45 | 55.38 | 5.39 | |||
| SO48338_5 | CF00-46C1-99 | PO11107115615 | 19 | 284 | 325 | 156 | 6 | 2023-02-02 | 469.79 | 11.74 | 2023-01-21 | 1 | 486.71 | 1 | 469.79 | 5 | SO48338 | 2023-01-28 | 37.58 | 486.71 | 469.79 | |||
| SO65206_23 | 6CD1-4BEC-A0 | PO1798192797 | 19 | 291 | 355 | 10 | 6 | 2024-05-03 | 11135.95 | 278.40 | 2024-04-21 | 8 | 1265.62 | 1 | 11135.95 | 23 | SO65206 | 2024-04-28 | 890.88 | 10124.96 | 1391.99 | |||
| SO47015_14 | 853D-4913-A7 | PO2117171072 | 19 | 284 | 354 | 444 | 6 | 2022-10-03 | 2485.70 | 62.14 | 2022-09-21 | 2 | 1117.86 | 1 | 2485.70 | 14 | SO47015 | 2022-09-28 | 198.86 | 2235.71 | 1242.85 | |||
| SO45522_10 | DB6E-40EF-A4 | PO19401195812 | 19 | 288 | 342 | 173 | 6 | 2022-05-03 | 419.46 | 10.49 | 2022-04-21 | 1 | 413.15 | 1 | 419.46 | 10 | SO45522 | 2022-04-28 | 33.56 | 413.15 | 419.46 | |||
| SO51850_40 | 57A9-4C32-8B | PO1856170170 | 19 | 291 | 570 | 13 | 263 | 6 | 100.22 | 2023-10-03 | 668.12 | 14.20 | 2023-09-21 | 2 | 461.44 | 1 | 567.90 | 40 | SO51850 | 2023-09-28 | 45.43 | 922.89 | 334.06 | 0.15 |
| SO55243_38 | 2457-46EE-88 | PO15312160912 | 19 | 291 | 481 | 299 | 6 | 2023-12-03 | 5.39 | 0.13 | 2023-11-21 | 1 | 3.36 | 1 | 5.39 | 38 | SO55243 | 2023-11-28 | 0.43 | 3.36 | 5.39 | |||
| SO46645_3 | F857-4A6D-9C | PO1711132491 | 19 | 291 | 395 | 245 | 6 | 2022-09-02 | 306.87 | 7.67 | 2022-08-21 | 5 | 45.42 | 1 | 306.87 | 3 | SO46645 | 2022-08-28 | 24.55 | 227.08 | 61.37 | |||
| SO45792_1 | D5D3-43B4-A2 | PO13862173868 | 19 | 288 | 349 | 119 | 6 | 2022-06-03 | 4049.99 | 101.25 | 2022-05-22 | 2 | 1898.09 | 1 | 4049.99 | 1 | SO45792 | 2022-05-29 | 324.00 | 3796.19 | 2024.99 |
Generated 2024-09-20 09:22:48.130 UTC