[ROOT] dt FactResellerSale < WHERE DimSalesTerritoryId EQ ALL SKIP 4000 SHUFFLE < SKIP 312 > < 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 |
---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
SO50295_13 | 575E-4F7A-9C | PO4466165095 | 19 | 291 | 468 | 352 | 6 | 2023-07-02 | 68.38 | 1.71 | 2023-06-20 | 3 | 15.67 | 1 | 68.38 | 13 | SO50295 | 2023-06-27 | 5.47 | 47.01 | 22.79 | |||
SO65177_3 | 1619-495E-81 | PO16501143019 | 98 | 288 | 382 | 142 | 10 | 2024-05-02 | 2689.18 | 67.23 | 2024-04-20 | 4 | 713.08 | 1 | 2689.18 | 3 | SO65177 | 2024-04-27 | 215.13 | 2852.32 | 672.29 | |||
SO65175_13 | E1A8-440E-94 | PO17139119772 | 100 | 293 | 580 | 644 | 1 | 2024-05-02 | 2041.19 | 51.03 | 2024-04-20 | 2 | 1082.51 | 1 | 2041.19 | 13 | SO65175 | 2024-04-27 | 163.30 | 2165.02 | 1020.59 | |||
SO46994_1 | 5E92-4A19-9E | PO11629171210 | 100 | 281 | 396 | 396 | 2 | 2022-10-02 | 74.84 | 1.87 | 2022-09-20 | 1 | 55.38 | 1 | 74.84 | 1 | SO46994 | 2022-09-27 | 5.99 | 55.38 | 74.84 | |||
SO71785_25 | 28F9-4101-A1 | PO19169115427 | 100 | 289 | 531 | 272 | 1 | 2024-08-02 | 299.75 | 7.49 | 2024-07-21 | 2 | 136.79 | 1 | 299.75 | 25 | SO71785 | 2024-07-28 | 23.98 | 273.57 | 149.87 | |||
SO48755_14 | 038B-40BE-A4 | PO13340115035 | 100 | 292 | 469 | 2 | 355 | 7 | 6.17 | 2023-03-04 | 308.48 | 7.56 | 2023-02-20 | 14 | 15.67 | 1 | 302.31 | 14 | SO48755 | 2023-02-27 | 24.18 | 219.39 | 22.03 | 0.02 |
SO46334_22 | F652-4575-B7 | PO17574196050 | 19 | 272 | 292 | 678 | 6 | 2022-08-02 | 818.70 | 20.47 | 2022-07-21 | 1 | 706.81 | 1 | 818.70 | 22 | SO46334 | 2022-07-28 | 65.50 | 706.81 | 818.70 | |||
SO45540_7 | B193-41A9-87 | PO13746118798 | 100 | 285 | 344 | 567 | 5 | 2022-05-02 | 8159.98 | 204.00 | 2022-04-20 | 4 | 1912.15 | 1 | 8159.98 | 7 | SO45540 | 2022-04-27 | 652.80 | 7648.62 | 2039.99 | |||
SO59042_7 | 8DB9-4316-8F | PO1972174730 | 19 | 291 | 525 | 190 | 6 | 2024-02-01 | 316.86 | 7.92 | 2024-01-20 | 2 | 144.59 | 1 | 316.86 | 7 | SO59042 | 2024-01-27 | 25.35 | 289.19 | 158.43 | |||
SO53566_13 | 3543-47B0-87 | PO8033117470 | 6 | 296 | 402 | 15 | 9 | 2023-11-02 | 72.16 | 1.80 | 2023-10-21 | 1 | 53.40 | 1 | 72.16 | 13 | SO53566 | 2023-10-28 | 5.77 | 53.40 | 72.16 | |||
SO51156_3 | C598-4D75-B4 | PO4930142451 | 19 | 291 | 542 | 425 | 6 | 2023-09-01 | 48.59 | 1.21 | 2023-08-20 | 2 | 17.98 | 1 | 48.59 | 3 | SO51156 | 2023-08-27 | 3.89 | 35.96 | 24.29 | |||
SO57179_2 | 93FD-457E-8A | PO8584112874 | 98 | 288 | 484 | 592 | 10 | 2024-01-02 | 4.77 | 0.12 | 2023-12-21 | 1 | 2.97 | 1 | 4.77 | 2 | SO57179 | 2023-12-28 | 0.38 | 2.97 | 4.77 | |||
SO44119_11 | 6300-4202-8C | PO4640166555 | 100 | 287 | 350 | 648 | 4 | 2021-11-02 | 4049.99 | 101.25 | 2021-10-21 | 2 | 1898.09 | 1 | 4049.99 | 11 | SO44119 | 2021-10-28 | 324.00 | 3796.19 | 2024.99 | |||
SO46380_19 | C4E3-4894-81 | PO7569183330 | 100 | 287 | 351 | 7 | 608 | 4 | 1476.56 | 2022-08-02 | 4218.74 | 68.55 | 2022-07-21 | 5 | 1898.09 | 1 | 2742.18 | 19 | SO46380 | 2022-07-28 | 219.37 | 9490.47 | 843.75 | 0.35 |
SO45517_5 | 1980-4886-B0 | PO20213190120 | 100 | 281 | 342 | 216 | 2 | 2022-05-02 | 419.46 | 10.49 | 2022-04-20 | 1 | 413.15 | 1 | 419.46 | 5 | SO45517 | 2022-04-27 | 33.56 | 413.15 | 419.46 | |||
SO53485_58 | 4356-47ED-8B | PO14703131697 | 6 | 294 | 484 | 573 | 9 | 2023-11-02 | 38.16 | 0.95 | 2023-10-21 | 8 | 2.97 | 1 | 38.16 | 58 | SO53485 | 2023-10-28 | 3.05 | 23.79 | 4.77 | |||
SO50217_12 | 6AE5-491F-B6 | PO14500116814 | 100 | 282 | 305 | 650 | 1 | 2023-07-02 | 2208.44 | 55.21 | 2023-06-20 | 3 | 653.70 | 1 | 2208.44 | 12 | SO50217 | 2023-06-27 | 176.67 | 1961.09 | 736.15 | |||
SO69447_12 | 1C7A-4B97-AA | PO11223139140 | 100 | 292 | 588 | 632 | 7 | 2024-07-02 | 461.69 | 11.54 | 2024-06-20 | 1 | 419.78 | 1 | 461.69 | 12 | SO69447 | 2024-06-27 | 36.94 | 419.78 | 461.69 | |||
SO53537_4 | C14C-4596-A3 | PO19894159880 | 100 | 283 | 473 | 557 | 2 | 2023-11-02 | 38.10 | 0.95 | 2023-10-21 | 1 | 23.75 | 1 | 38.10 | 4 | SO53537 | 2023-10-28 | 3.05 | 23.75 | 38.10 | |||
SO50682_4 | 1145-4AD1-B8 | PO12354142084 | 100 | 283 | 468 | 197 | 3 | 2023-08-02 | 22.79 | 0.57 | 2023-07-21 | 1 | 15.67 | 1 | 22.79 | 4 | SO50682 | 2023-07-28 | 1.82 | 15.67 | 22.79 | |||
SO47018_37 | E622-43B1-98 | PO2523197473 | 100 | 287 | 422 | 167 | 4 | 2022-10-02 | 270.16 | 6.75 | 2022-09-20 | 4 | 49.98 | 1 | 270.16 | 37 | SO47018 | 2022-09-27 | 21.61 | 199.92 | 67.54 | |||
SO69415_3 | 3D39-4844-B5 | PO15080175978 | 100 | 292 | 564 | 283 | 7 | 2024-07-02 | 1430.44 | 35.76 | 2024-06-20 | 1 | 1481.94 | 1 | 1430.44 | 3 | SO69415 | 2024-06-27 | 114.44 | 1481.94 | 1430.44 | |||
SO59072_1 | 6A26-4ECF-9E | PO9193175448 | 6 | 296 | 569 | 616 | 9 | 2024-02-01 | 445.41 | 11.14 | 2024-01-20 | 1 | 461.44 | 1 | 445.41 | 1 | SO59072 | 2024-01-27 | 35.63 | 461.44 | 445.41 | |||
SO59068_25 | B7CC-4A9D-86 | PO9715112509 | 100 | 281 | 511 | 490 | 4 | 2024-02-01 | 873.82 | 21.85 | 2024-01-20 | 4 | 199.38 | 1 | 873.82 | 25 | SO59068 | 2024-01-27 | 69.91 | 797.50 | 218.45 | |||
SO48049_19 | C09A-49F5-80 | PO3799136256 | 100 | 282 | 297 | 312 | 4 | 2023-01-02 | 1472.29 | 36.81 | 2022-12-21 | 2 | 653.70 | 1 | 1472.29 | 19 | SO48049 | 2022-12-28 | 117.78 | 1307.39 | 736.15 | |||
SO67276_20 | 9FD9-4B05-AA | PO13340158801 | 100 | 292 | 487 | 355 | 7 | 2024-06-02 | 131.98 | 3.30 | 2024-05-21 | 4 | 20.57 | 1 | 131.98 | 20 | SO67276 | 2024-05-28 | 10.56 | 82.27 | 32.99 | |||
SO65151_1 | 901D-4BB2-B1 | PO19952180240 | 98 | 288 | 472 | 106 | 10 | 2024-05-02 | 76.20 | 1.91 | 2024-04-20 | 2 | 23.75 | 1 | 76.20 | 1 | SO65151 | 2024-04-27 | 6.10 | 47.50 | 38.10 | |||
SO48306_47 | EA27-471A-9D | PO17574166075 | 19 | 291 | 461 | 678 | 6 | 2023-02-01 | 107.99 | 2.70 | 2023-01-20 | 2 | 37.12 | 1 | 107.99 | 47 | SO48306 | 2023-01-27 | 8.64 | 74.24 | 53.99 | |||
SO47009_33 | 8F7C-4372-A2 | PO1508115971 | 98 | 288 | 373 | 430 | 10 | 2022-10-02 | 2617.88 | 65.45 | 2022-09-20 | 2 | 1320.68 | 1 | 2617.88 | 33 | SO47009 | 2022-09-27 | 209.43 | 2641.37 | 1308.94 | |||
SO57034_17 | 57D0-46D3-B7 | PO15689142548 | 100 | 281 | 234 | 328 | 4 | 2024-01-02 | 89.98 | 2.25 | 2023-12-21 | 3 | 38.49 | 1 | 89.98 | 17 | SO57034 | 2023-12-28 | 7.20 | 115.48 | 29.99 | |||
SO47052_37 | 1AAD-4284-B8 | PO7424197138 | 100 | 281 | 460 | 642 | 2 | 2022-10-02 | 323.96 | 8.10 | 2022-09-20 | 6 | 37.12 | 1 | 323.96 | 37 | SO47052 | 2022-09-27 | 25.92 | 222.73 | 53.99 |
Generated 2024-09-20 01:39:57.388 UTC