[ROOT] dt FactResellerSale < WHERE DimSalesTerritoryId EQ '5' > SHUFFLE < SKIP 251 > < 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 |
---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
SO51081_50 | EDBF-4FE1-8F | PO522116846 | 100 | 285 | 594 | 676 | 5 | 2023-10-25 | 677.99 | 16.95 | 2023-10-13 | 2 | 308.22 | 1 | 677.99 | 50 | SO51081 | 2023-10-20 | 54.24 | 616.44 | 338.99 | |||
SO57064_6 | EDFD-4B3C-AF | PO11542177395 | 100 | 285 | 545 | 62 | 5 | 2024-02-25 | 48.59 | 1.21 | 2024-02-13 | 2 | 17.98 | 1 | 48.59 | 6 | SO57064 | 2024-02-20 | 3.89 | 35.96 | 24.29 | |||
SO50703_1 | 4A3D-44CB-B3 | PO2813140706 | 100 | 283 | 433 | 90 | 5 | 2023-09-25 | 648.91 | 16.22 | 2023-09-13 | 2 | 300.12 | 1 | 648.91 | 1 | SO50703 | 2023-09-20 | 51.91 | 600.24 | 324.45 | |||
SO49495_3 | A868-43CF-A4 | PO9570115481 | 100 | 285 | 367 | 585 | 5 | 2023-06-25 | 1295.99 | 32.40 | 2023-06-13 | 2 | 598.44 | 1 | 1295.99 | 3 | SO49495 | 2023-06-20 | 103.68 | 1196.87 | 647.99 | |||
SO47416_34 | 6B45-44AB-84 | PO2813155355 | 100 | 281 | 343 | 90 | 5 | 2022-12-26 | 1879.18 | 46.98 | 2022-12-14 | 4 | 486.71 | 1 | 1879.18 | 34 | SO47416 | 2022-12-21 | 150.33 | 1946.83 | 469.79 | |||
SO57088_33 | EA31-4951-8A | PO2842199218 | 100 | 285 | 436 | 700 | 5 | 2024-02-25 | 713.80 | 17.84 | 2024-02-13 | 2 | 360.94 | 1 | 713.80 | 33 | SO57088 | 2024-02-20 | 57.10 | 721.89 | 356.90 | |||
SO44318_3 | 6965-4539-96 | PO8120137646 | 100 | 281 | 307 | 485 | 5 | 2022-01-25 | 722.59 | 18.06 | 2022-01-13 | 1 | 623.84 | 1 | 722.59 | 3 | SO44318 | 2022-01-20 | 57.81 | 623.84 | 722.59 | |||
SO50726_36 | A80B-408E-B3 | PO9599192861 | 100 | 285 | 422 | 170 | 5 | 2023-09-25 | 135.08 | 3.38 | 2023-09-13 | 2 | 49.98 | 1 | 135.08 | 36 | SO50726 | 2023-09-20 | 10.81 | 99.96 | 67.54 | |||
SO50723_3 | 9670-429D-93 | PO11977146614 | 100 | 285 | 267 | 675 | 5 | 2023-09-25 | 607.00 | 15.17 | 2023-09-13 | 3 | 187.16 | 1 | 607.00 | 3 | SO50723 | 2023-09-20 | 48.56 | 561.47 | 202.33 | |||
SO50726_21 | A80B-408E-B3 | PO9599192861 | 100 | 285 | 433 | 170 | 5 | 2023-09-25 | 2271.17 | 56.78 | 2023-09-13 | 7 | 300.12 | 1 | 2271.17 | 21 | SO50726 | 2023-09-20 | 181.69 | 2100.83 | 324.45 | |||
SO71866_1 | 029A-46BE-80 | PO14297151936 | 100 | 285 | 603 | 627 | 5 | 2024-09-25 | 291.58 | 7.29 | 2024-09-13 | 4 | 53.94 | 1 | 291.58 | 1 | SO71866 | 2024-09-20 | 23.33 | 215.77 | 72.89 | |||
SO61228_24 | 06C7-43A1-85 | PO9831151400 | 100 | 285 | 434 | 81 | 5 | 2024-04-26 | 356.90 | 8.92 | 2024-04-14 | 1 | 360.94 | 1 | 356.90 | 24 | SO61228 | 2024-04-21 | 28.55 | 360.94 | 356.90 | |||
SO45300_12 | 650B-4342-95 | PO12586158748 | 100 | 285 | 348 | 278 | 5 | 2022-05-28 | 20249.94 | 506.25 | 2022-05-16 | 10 | 1898.09 | 1 | 20249.94 | 12 | SO45300 | 2022-05-23 | 1620.00 | 18980.94 | 2024.99 | |||
SO53563_1 | C955-44BD-A8 | PO9599165865 | 100 | 285 | 378 | 170 | 5 | 2023-12-26 | 5864.04 | 146.60 | 2023-12-14 | 4 | 1554.95 | 1 | 5864.04 | 1 | SO53563 | 2023-12-21 | 469.12 | 6219.79 | 1466.01 | |||
SO65288_1 | 375A-456E-A7 | PO6583156870 | 100 | 285 | 564 | 44 | 5 | 2024-06-25 | 4291.33 | 107.28 | 2024-06-13 | 3 | 1481.94 | 1 | 4291.33 | 1 | SO65288 | 2024-06-20 | 343.31 | 4445.81 | 1430.44 | |||
SO48760_2 | D682-4FD4-94 | PO9657199450 | 100 | 285 | 233 | 315 | 5 | 2023-04-27 | 86.52 | 2.16 | 2023-04-15 | 3 | 29.08 | 1 | 86.52 | 2 | SO48760 | 2023-04-22 | 6.92 | 87.24 | 28.84 | |||
SO46047_1 | 2520-47B8-B9 | PO16211157418 | 100 | 285 | 347 | 99 | 5 | 2022-08-25 | 8159.98 | 204.00 | 2022-08-13 | 4 | 1912.15 | 1 | 8159.98 | 1 | SO46047 | 2022-08-20 | 652.80 | 7648.62 | 2039.99 | |||
SO51693_28 | 6FEB-4D5B-92 | PO19546179477 | 100 | 285 | 545 | 206 | 5 | 2023-11-25 | 24.29 | 0.61 | 2023-11-13 | 1 | 17.98 | 1 | 24.29 | 28 | SO51693 | 2023-11-20 | 1.94 | 17.98 | 24.29 | |||
SO57162_10 | 83B5-43A6-BD | PO3596174424 | 100 | 285 | 590 | 476 | 5 | 2024-02-25 | 461.69 | 11.54 | 2024-02-13 | 1 | 419.78 | 1 | 461.69 | 10 | SO57162 | 2024-02-20 | 36.94 | 419.78 | 461.69 | |||
SO49091_1 | 7A94-486D-8A | PO19546118667 | 100 | 285 | 456 | 206 | 5 | 2023-05-28 | 44.99 | 1.12 | 2023-05-16 | 1 | 30.93 | 1 | 44.99 | 1 | SO49091 | 2023-05-23 | 3.60 | 30.93 | 44.99 | |||
SO47703_8 | 0E62-43AC-8E | PO3741184156 | 100 | 285 | 325 | 404 | 5 | 2023-01-25 | 939.59 | 23.49 | 2023-01-13 | 2 | 486.71 | 1 | 939.59 | 8 | SO47703 | 2023-01-20 | 75.17 | 973.41 | 469.79 | |||
SO46654_1 | 2FEC-47CC-84 | PO3741124832 | 100 | 285 | 422 | 404 | 5 | 2022-10-25 | 135.08 | 3.38 | 2022-10-13 | 2 | 49.98 | 1 | 135.08 | 1 | SO46654 | 2022-10-20 | 10.81 | 99.96 | 67.54 | |||
SO47457_8 | 37E5-4B0F-9D | PO9744168861 | 100 | 285 | 470 | 98 | 5 | 2022-12-26 | 91.18 | 2.28 | 2022-12-14 | 4 | 15.67 | 1 | 91.18 | 8 | SO47457 | 2022-12-21 | 7.29 | 62.68 | 22.79 | |||
SO71850_4 | 3DA6-4E97-9F | PO18241134627 | 100 | 285 | 576 | 477 | 5 | 2024-09-25 | 1430.44 | 35.76 | 2024-09-13 | 1 | 1481.94 | 1 | 1430.44 | 4 | SO71850 | 2024-09-20 | 114.44 | 1481.94 | 1430.44 | |||
SO49869_30 | A2BD-4A89-93 | PO9657193666 | 100 | 285 | 401 | 315 | 5 | 2023-07-26 | 262.41 | 6.56 | 2023-07-14 | 4 | 48.55 | 1 | 262.41 | 30 | SO49869 | 2023-07-21 | 20.99 | 194.18 | 65.60 | |||
SO44799_9 | 2146-417A-8D | PO9106161251 | 100 | 285 | 296 | 602 | 5 | 2022-03-27 | 714.70 | 17.87 | 2022-03-15 | 1 | 617.03 | 1 | 714.70 | 9 | SO44799 | 2022-03-22 | 57.18 | 617.03 | 714.70 | |||
SO51760_22 | 2C2D-41C9-8C | PO9918180623 | 100 | 285 | 568 | 13 | 260 | 5 | 150.33 | 2023-11-25 | 1002.17 | 21.30 | 2023-11-13 | 3 | 461.44 | 1 | 851.85 | 22 | SO51760 | 2023-11-20 | 68.15 | 1384.33 | 334.06 | 0.15 |
SO71839_19 | 8F89-4B1E-A8 | PO1537119063 | 100 | 285 | 484 | 2 | 611 | 5 | 1.01 | 2024-09-25 | 50.72 | 1.24 | 2024-09-13 | 11 | 2.97 | 1 | 49.71 | 19 | SO71839 | 2024-09-20 | 3.98 | 32.71 | 4.61 | 0.02 |
Generated 2024-11-13 01:51:53.905 UTC