[ROOT] dt FactResellerSale < WHERE DimSalesTerritoryId EQ ALL SKIP 0 SHUFFLE < SKIP 626 > < 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 |
---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
SO63157_42 | 9E62-4577-80 | PO14500183845 | 100 | 282 | 400 | 650 | 1 | 2024-04-03 | 74.30 | 1.86 | 2024-03-22 | 2 | 27.49 | 1 | 74.30 | 42 | SO63157 | 2024-03-29 | 5.94 | 54.99 | 37.15 | |||
SO47714_1 | 884B-4F33-A1 | PO6235113773 | 100 | 281 | 433 | 431 | 3 | 2022-12-02 | 324.45 | 8.11 | 2022-11-20 | 1 | 300.12 | 1 | 324.45 | 1 | SO47714 | 2022-11-27 | 25.96 | 300.12 | 324.45 | |||
SO67317_4 | 4A70-41C2-8F | PO6032167181 | 6 | 296 | 568 | 177 | 9 | 2024-06-02 | 445.41 | 11.14 | 2024-05-21 | 1 | 461.44 | 1 | 445.41 | 4 | SO67317 | 2024-05-28 | 35.63 | 461.44 | 445.41 | |||
SO71820_9 | D332-4AF2-A3 | PO12673129941 | 100 | 292 | 547 | 499 | 7 | 2024-08-02 | 194.38 | 4.86 | 2024-07-21 | 4 | 35.96 | 1 | 194.38 | 9 | SO71820 | 2024-07-28 | 15.55 | 143.84 | 48.59 | |||
SO45570_4 | 530C-4FAB-9A | PO7192194940 | 100 | 289 | 348 | 20 | 1 | 2022-05-02 | 8099.98 | 202.50 | 2022-04-20 | 4 | 1898.09 | 1 | 8099.98 | 4 | SO45570 | 2022-04-27 | 648.00 | 7592.38 | 2024.99 | |||
SO47666_25 | 6551-4B29-BF | PO16588184420 | 100 | 289 | 354 | 146 | 1 | 2022-12-02 | 9942.81 | 248.57 | 2022-11-20 | 8 | 1117.86 | 1 | 9942.81 | 25 | SO47666 | 2022-11-27 | 795.43 | 8942.85 | 1242.85 | |||
SO57019_9 | D018-44A0-BF | PO18879140423 | 19 | 291 | 564 | 64 | 6 | 2024-01-02 | 2860.88 | 71.52 | 2023-12-21 | 2 | 1481.94 | 1 | 2860.88 | 9 | SO57019 | 2023-12-28 | 228.87 | 2963.88 | 1430.44 | |||
SO67289_51 | 5B09-42E8-A1 | PO10324110444 | 98 | 288 | 465 | 196 | 10 | 2024-06-02 | 146.94 | 3.67 | 2024-05-21 | 10 | 9.16 | 1 | 146.94 | 51 | SO67289 | 2024-05-28 | 11.76 | 91.59 | 14.69 | |||
SO50270_23 | A828-45A2-8B | PO18676112371 | 100 | 282 | 469 | 3 | 697 | 1 | 24.03 | 2023-07-02 | 480.57 | 11.41 | 2023-06-20 | 23 | 15.67 | 1 | 456.54 | 23 | SO50270 | 2023-06-27 | 36.52 | 360.43 | 20.89 | 0.05 |
SO49486_3 | 7DA8-4E15-AE | PO16124154108 | 100 | 282 | 329 | 649 | 4 | 2023-05-02 | 469.79 | 11.74 | 2023-04-20 | 1 | 486.71 | 1 | 469.79 | 3 | SO49486 | 2023-04-27 | 37.58 | 486.71 | 469.79 | |||
SO48328_1 | 5992-4AF8-B1 | PO13543152596 | 100 | 287 | 366 | 293 | 1 | 2023-02-01 | 1295.99 | 32.40 | 2023-01-20 | 2 | 598.44 | 1 | 1295.99 | 1 | SO48328 | 2023-01-27 | 103.68 | 1196.87 | 647.99 | |||
SO48069_15 | 60CF-43B6-82 | PO6438117188 | 100 | 283 | 460 | 309 | 4 | 2023-01-02 | 107.99 | 2.70 | 2022-12-21 | 2 | 37.12 | 1 | 107.99 | 15 | SO48069 | 2022-12-28 | 8.64 | 74.24 | 53.99 | |||
SO47422_13 | 9D8D-4481-B6 | PO3915123127 | 100 | 283 | 381 | 130 | 4 | 2022-11-02 | 1200.53 | 30.01 | 2022-10-21 | 2 | 605.65 | 1 | 1200.53 | 13 | SO47422 | 2022-10-28 | 96.04 | 1211.30 | 600.26 | |||
SO53563_24 | C955-44BD-A8 | PO9599165865 | 100 | 285 | 380 | 170 | 5 | 2023-11-02 | 4398.03 | 109.95 | 2023-10-21 | 3 | 1554.95 | 1 | 4398.03 | 24 | SO53563 | 2023-10-28 | 351.84 | 4664.84 | 1466.01 | |||
SO45055_2 | 0C6F-4406-A0 | PO12412126535 | 100 | 283 | 328 | 670 | 3 | 2022-03-04 | 419.46 | 10.49 | 2022-02-20 | 1 | 413.15 | 1 | 419.46 | 2 | SO45055 | 2022-02-27 | 33.56 | 413.15 | 419.46 | |||
SO46082_9 | E8B4-45CF-8C | PO3799169418 | 100 | 282 | 229 | 312 | 4 | 2022-07-02 | 86.52 | 2.16 | 2022-06-20 | 3 | 31.72 | 1 | 86.52 | 9 | SO46082 | 2022-06-27 | 6.92 | 95.17 | 28.84 | |||
SO53455_17 | ACD7-4AF3-84 | PO19604185529 | 98 | 288 | 476 | 3 | 340 | 10 | 30.80 | 2023-11-02 | 615.91 | 14.63 | 2023-10-21 | 16 | 26.18 | 1 | 585.12 | 17 | SO53455 | 2023-10-28 | 46.81 | 418.82 | 38.49 | 0.05 |
SO61182_19 | C1B1-4DBF-A9 | PO16588179661 | 100 | 289 | 532 | 146 | 1 | 2024-03-03 | 299.75 | 7.49 | 2024-02-20 | 2 | 136.79 | 1 | 299.75 | 19 | SO61182 | 2024-02-27 | 23.98 | 273.57 | 149.87 | |||
SO50205_11 | 9A7F-44D8-AF | PO16762191475 | 100 | 272 | 333 | 259 | 4 | 2023-07-02 | 1409.38 | 35.23 | 2023-06-20 | 3 | 486.71 | 1 | 1409.38 | 11 | SO50205 | 2023-06-27 | 112.75 | 1460.12 | 469.79 | |||
SO46669_20 | 7080-4FDD-BD | PO8410183627 | 98 | 288 | 461 | 538 | 10 | 2022-09-01 | 53.99 | 1.35 | 2022-08-20 | 1 | 37.12 | 1 | 53.99 | 20 | SO46669 | 2022-08-27 | 4.32 | 37.12 | 53.99 | |||
SO71851_10 | AABE-4443-91 | PO18299133687 | 19 | 291 | 398 | 118 | 6 | 2024-08-02 | 26.72 | 0.67 | 2024-07-21 | 1 | 19.78 | 1 | 26.72 | 10 | SO71851 | 2024-07-28 | 2.14 | 19.78 | 26.72 | |||
SO48038_10 | AF3A-47B6-B4 | PO2117194241 | 19 | 284 | 469 | 444 | 6 | 2023-01-02 | 91.18 | 2.28 | 2022-12-21 | 4 | 15.67 | 1 | 91.18 | 10 | SO48038 | 2022-12-28 | 7.29 | 62.68 | 22.79 | |||
SO51718_19 | 27D3-4968-89 | PO15051113417 | 100 | 285 | 511 | 207 | 5 | 2023-10-02 | 436.91 | 10.92 | 2023-09-20 | 2 | 199.38 | 1 | 436.91 | 19 | SO51718 | 2023-09-27 | 34.95 | 398.75 | 218.45 | |||
SO55300_10 | 40F4-470B-82 | PO8004112820 | 6 | 296 | 565 | 231 | 9 | 2023-12-02 | 890.82 | 22.27 | 2023-11-20 | 2 | 461.44 | 1 | 890.82 | 10 | SO55300 | 2023-11-27 | 71.27 | 922.89 | 445.41 | |||
SO47990_24 | 7D80-4D9E-9A | PO15689162700 | 100 | 283 | 341 | 328 | 4 | 2023-01-02 | 939.59 | 23.49 | 2022-12-21 | 2 | 486.71 | 1 | 939.59 | 24 | SO47990 | 2022-12-28 | 75.17 | 973.41 | 469.79 | |||
SO51739_4 | AF60-4F2F-9B | PO12702124697 | 100 | 292 | 295 | 175 | 7 | 2023-10-02 | 4912.20 | 122.81 | 2023-09-20 | 6 | 747.20 | 1 | 4912.20 | 4 | SO51739 | 2023-09-27 | 392.98 | 4483.20 | 818.70 | |||
SO47033_7 | 2797-46ED-BB | PO4727113716 | 100 | 286 | 381 | 343 | 1 | 2022-10-02 | 1800.79 | 45.02 | 2022-09-20 | 3 | 605.65 | 1 | 1800.79 | 7 | SO47033 | 2022-09-27 | 144.06 | 1816.95 | 600.26 | |||
SO47663_10 | 1B17-4C63-B6 | PO18444192283 | 19 | 291 | 329 | 227 | 6 | 2022-12-02 | 3758.35 | 93.96 | 2022-11-20 | 8 | 486.71 | 1 | 3758.35 | 10 | SO47663 | 2022-11-27 | 300.67 | 3893.65 | 469.79 | |||
SO69478_32 | E63C-4ABF-83 | PO18705185140 | 19 | 291 | 605 | 479 | 6 | 2024-07-02 | 323.99 | 8.10 | 2024-06-20 | 1 | 343.65 | 1 | 323.99 | 32 | SO69478 | 2024-06-27 | 25.92 | 343.65 | 323.99 | |||
SO59041_6 | C34F-429D-B5 | PO3973143022 | 100 | 281 | 573 | 201 | 4 | 2024-02-01 | 1430.44 | 35.76 | 2024-01-20 | 1 | 1481.94 | 1 | 1430.44 | 6 | SO59041 | 2024-01-27 | 114.44 | 1481.94 | 1430.44 | |||
SO51121_53 | 9E4C-40B6-B1 | PO10730114575 | 100 | 287 | 243 | 491 | 4 | 2023-09-01 | 1717.80 | 42.95 | 2023-08-20 | 2 | 868.63 | 1 | 1717.80 | 53 | SO51121 | 2023-08-27 | 137.42 | 1737.27 | 858.90 |
Generated 2024-09-19 23:03:53.015 UTC