[ROOT] dt FactResellerSale < WHERE DimSalesTerritoryId EQ '6' > SHUFFLE < SKIP 496 > < 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 |
---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
SO49860_19 | DB5C-4441-BE | PO13862128354 | 19 | 291 | 410 | 119 | 6 | 2023-07-24 | 36.45 | 0.91 | 2023-07-12 | 1 | 26.97 | 1 | 36.45 | 19 | SO49860 | 2023-07-19 | 2.92 | 26.97 | 36.45 | |||
SO50694_47 | DAEB-4730-9B | PO17545120609 | 19 | 291 | 383 | 155 | 6 | 2023-09-23 | 1800.79 | 45.02 | 2023-09-11 | 3 | 605.65 | 1 | 1800.79 | 47 | SO50694 | 2023-09-18 | 144.06 | 1816.95 | 600.26 | |||
SO69397_14 | 1339-46CA-AC | PO18879152551 | 19 | 291 | 561 | 64 | 6 | 2024-08-23 | 4291.33 | 107.28 | 2024-08-11 | 3 | 1481.94 | 1 | 4291.33 | 14 | SO69397 | 2024-08-18 | 343.31 | 4445.81 | 1430.44 | |||
SO44547_1 | 801C-4288-87 | PO4901179982 | 19 | 284 | 262 | 84 | 6 | 2022-02-23 | 367.88 | 9.20 | 2022-02-11 | 2 | 181.49 | 1 | 367.88 | 1 | SO44547 | 2022-02-18 | 29.43 | 362.97 | 183.94 | |||
SO57122_28 | 048F-465A-A8 | PO4901112587 | 19 | 284 | 606 | 84 | 6 | 2024-02-23 | 647.99 | 16.20 | 2024-02-11 | 2 | 343.65 | 1 | 647.99 | 28 | SO57122 | 2024-02-18 | 51.84 | 687.30 | 323.99 | |||
SO58918_41 | C811-4D40-80 | PO17574131484 | 19 | 291 | 225 | 3 | 678 | 6 | 4.94 | 2024-03-24 | 98.89 | 2.35 | 2024-03-12 | 20 | 6.92 | 1 | 93.95 | 41 | SO58918 | 2024-03-19 | 7.52 | 138.45 | 4.94 | 0.05 |
SO47357_7 | 3E93-4357-9B | PO18531126368 | 19 | 284 | 354 | 613 | 6 | 2022-12-24 | 1242.85 | 31.07 | 2022-12-12 | 1 | 1117.86 | 1 | 1242.85 | 7 | SO47357 | 2022-12-19 | 99.43 | 1117.86 | 1242.85 | |||
SO50284_6 | F8D1-49E1-A5 | PO4901178867 | 19 | 284 | 456 | 84 | 6 | 2023-08-23 | 89.99 | 2.25 | 2023-08-11 | 2 | 30.93 | 1 | 89.99 | 6 | SO50284 | 2023-08-18 | 7.20 | 61.87 | 44.99 | |||
SO47662_15 | 9790-4A85-BE | PO18473142607 | 19 | 291 | 358 | 442 | 6 | 2023-01-23 | 3688.38 | 92.21 | 2023-01-11 | 3 | 1105.81 | 1 | 3688.38 | 15 | SO47662 | 2023-01-18 | 295.07 | 3317.43 | 1229.46 | |||
SO49839_1 | 3123-41F3-9B | PO10527179463 | 19 | 284 | 233 | 480 | 6 | 2023-07-24 | 144.20 | 3.61 | 2023-07-12 | 5 | 29.08 | 1 | 144.20 | 1 | SO49839 | 2023-07-19 | 11.54 | 145.40 | 28.84 | |||
SO45552_15 | AF2A-49F1-92 | PO1740119260 | 19 | 288 | 285 | 460 | 6 | 2022-06-23 | 714.32 | 17.86 | 2022-06-11 | 4 | 176.20 | 1 | 714.32 | 15 | SO45552 | 2022-06-18 | 57.15 | 704.80 | 178.58 | |||
SO63141_6 | 96AB-479F-86 | PO17603143134 | 19 | 284 | 487 | 12 | 6 | 2024-05-25 | 164.97 | 4.12 | 2024-05-13 | 5 | 20.57 | 1 | 164.97 | 6 | SO63141 | 2024-05-20 | 13.20 | 102.83 | 32.99 | |||
SO51699_27 | 31D5-494C-BA | PO18879118606 | 19 | 291 | 514 | 64 | 6 | 2023-11-23 | 191.70 | 4.79 | 2023-11-11 | 3 | 47.29 | 1 | 191.70 | 27 | SO51699 | 2023-11-18 | 15.34 | 141.86 | 63.90 | |||
SO69399_23 | BEA9-4703-91 | PO17661173810 | 19 | 284 | 585 | 264 | 6 | 2024-08-23 | 1336.23 | 33.41 | 2024-08-11 | 3 | 461.44 | 1 | 1336.23 | 23 | SO69399 | 2024-08-18 | 106.90 | 1384.33 | 445.41 | |||
SO48750_26 | 9A71-449E-B6 | PO14732147398 | 19 | 291 | 381 | 514 | 6 | 2023-04-25 | 3001.31 | 75.03 | 2023-04-13 | 5 | 605.65 | 1 | 3001.31 | 26 | SO48750 | 2023-04-20 | 240.11 | 3028.25 | 600.26 | |||
SO48307_41 | 7DE5-4D74-A7 | PO17545123793 | 19 | 291 | 230 | 155 | 6 | 2023-03-25 | 230.72 | 5.77 | 2023-03-13 | 8 | 29.08 | 1 | 230.72 | 41 | SO48307 | 2023-03-20 | 18.46 | 232.65 | 28.84 | |||
SO47012_38 | 5043-4C8B-B3 | PO1914167487 | 19 | 284 | 369 | 66 | 6 | 2022-11-23 | 1466.01 | 36.65 | 2022-11-11 | 1 | 1518.79 | 1 | 1466.01 | 38 | SO47012 | 2022-11-18 | 117.28 | 1518.79 | 1466.01 | |||
SO46938_19 | 2E58-4440-89 | PO19198122384 | 19 | 291 | 294 | 653 | 6 | 2022-11-23 | 2232.82 | 55.82 | 2022-11-11 | 3 | 660.91 | 1 | 2232.82 | 19 | SO46938 | 2022-11-18 | 178.63 | 1982.74 | 744.27 | |||
SO48351_24 | 0478-43AC-AB | PO1885129829 | 19 | 284 | 419 | 588 | 6 | 2023-03-25 | 157.94 | 3.95 | 2023-03-13 | 3 | 38.96 | 1 | 157.94 | 24 | SO48351 | 2023-03-20 | 12.64 | 116.88 | 52.65 | |||
SO50676_25 | 66F1-4A9A-97 | PO14790188963 | 19 | 291 | 213 | 497 | 6 | 2023-09-23 | 80.75 | 2.02 | 2023-09-11 | 4 | 13.88 | 1 | 80.75 | 25 | SO50676 | 2023-09-18 | 6.46 | 55.51 | 20.19 | |||
SO51700_20 | 6837-439E-BC | PO17806126316 | 19 | 291 | 547 | 101 | 6 | 2023-11-23 | 242.97 | 6.07 | 2023-11-11 | 5 | 35.96 | 1 | 242.97 | 20 | SO51700 | 2023-11-18 | 19.44 | 179.80 | 48.59 | |||
SO48744_14 | 15DB-48CD-9B | PO1711156590 | 19 | 291 | 469 | 245 | 6 | 2023-04-25 | 45.59 | 1.14 | 2023-04-13 | 2 | 15.67 | 1 | 45.59 | 14 | SO48744 | 2023-04-20 | 3.65 | 31.34 | 22.79 | |||
SO57024_26 | DED7-4CEF-90 | PO17661138970 | 19 | 284 | 566 | 264 | 6 | 2024-02-23 | 1336.23 | 33.41 | 2024-02-11 | 3 | 461.44 | 1 | 1336.23 | 26 | SO57024 | 2024-02-18 | 106.90 | 1384.33 | 445.41 | |||
SO43850_9 | EBA6-4C6F-86 | PO18415143340 | 19 | 288 | 317 | 191 | 6 | 2021-11-23 | 874.79 | 21.87 | 2021-11-11 | 1 | 884.71 | 1 | 874.79 | 9 | SO43850 | 2021-11-18 | 69.98 | 884.71 | 874.79 | |||
SO47967_4 | DA42-41A7-BD | PO19198173391 | 19 | 291 | 360 | 653 | 6 | 2023-02-23 | 6147.29 | 153.68 | 2023-02-11 | 5 | 1105.81 | 1 | 6147.29 | 4 | SO47967 | 2023-02-18 | 491.78 | 5529.05 | 1229.46 | |||
SO50265_6 | 6C30-435D-9D | PO18705169014 | 19 | 291 | 286 | 479 | 6 | 2023-08-23 | 183.94 | 4.60 | 2023-08-11 | 1 | 170.14 | 1 | 183.94 | 6 | SO50265 | 2023-08-18 | 14.72 | 170.14 | 183.94 | |||
SO53527_53 | 0EBE-4ACB-B5 | PO1798140946 | 19 | 291 | 513 | 10 | 6 | 2023-12-24 | 1092.27 | 27.31 | 2023-12-12 | 5 | 199.38 | 1 | 1092.27 | 53 | SO53527 | 2023-12-19 | 87.38 | 996.88 | 218.45 | |||
SO47662_18 | 9790-4A85-BE | PO18473142607 | 19 | 291 | 428 | 442 | 6 | 2023-01-23 | 837.02 | 20.93 | 2023-01-11 | 4 | 185.82 | 1 | 837.02 | 18 | SO47662 | 2023-01-18 | 66.96 | 743.28 | 209.26 |
Generated 2024-11-10 17:41:13.727 UTC