[ROOT] dt FactResellerSale < WHERE DimSalesTerritoryId EQ '6' > SHUFFLE < SKIP 844 > < TAKE 30 >
30 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 |
---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
SO49879_3 | 7A79-4FB0-85 | PO4495112714 | 19 | 291 | 365 | 496 | 6 | 2023-06-03 | 1943.98 | 48.60 | 2023-05-22 | 3 | 598.44 | 1 | 1943.98 | 3 | SO49879 | 2023-05-29 | 155.52 | 1795.31 | 647.99 | |||
SO57188_8 | BA1D-4480-AA | PO9077120275 | 19 | 291 | 525 | 100 | 6 | 2024-01-03 | 316.86 | 7.92 | 2023-12-22 | 2 | 144.59 | 1 | 316.86 | 8 | SO57188 | 2023-12-29 | 25.35 | 289.19 | 158.43 | |||
SO57093_34 | 2F7C-4AF6-8B | PO18705165751 | 19 | 291 | 583 | 479 | 6 | 2024-01-03 | 2041.19 | 51.03 | 2023-12-22 | 2 | 1082.51 | 1 | 2041.19 | 34 | SO57093 | 2023-12-29 | 163.30 | 2165.02 | 1020.59 | |||
SO50698_6 | 304A-4672-BA | PO1798139213 | 19 | 291 | 411 | 10 | 6 | 2023-08-03 | 501.66 | 12.54 | 2023-07-22 | 4 | 92.81 | 1 | 501.66 | 6 | SO50698 | 2023-07-29 | 40.13 | 371.23 | 125.42 | |||
SO47673_12 | AFCF-4DA6-99 | PO13862175462 | 19 | 291 | 358 | 119 | 6 | 2022-12-03 | 2458.92 | 61.47 | 2022-11-21 | 2 | 1105.81 | 1 | 2458.92 | 12 | SO47673 | 2022-11-28 | 196.71 | 2211.62 | 1229.46 | |||
SO55280_17 | B925-404B-8B | PO18444178908 | 19 | 291 | 390 | 227 | 6 | 2023-12-03 | 2689.18 | 67.23 | 2023-11-21 | 4 | 713.08 | 1 | 2689.18 | 17 | SO55280 | 2023-11-28 | 215.13 | 2852.32 | 672.29 | |||
SO51769_32 | 4AAC-4066-A6 | PO1595126190 | 19 | 284 | 287 | 426 | 6 | 2023-10-03 | 607.00 | 15.17 | 2023-09-21 | 3 | 204.63 | 1 | 607.00 | 32 | SO51769 | 2023-09-28 | 48.56 | 613.88 | 202.33 | |||
SO71792_10 | 5257-4FC4-A5 | PO17545115036 | 19 | 291 | 481 | 155 | 6 | 2024-08-03 | 43.15 | 1.08 | 2024-07-22 | 8 | 3.36 | 1 | 43.15 | 10 | SO71792 | 2024-07-29 | 3.45 | 26.90 | 5.39 | |||
SO58958_21 | BC3F-443F-B5 | PO10875118816 | 19 | 291 | 507 | 281 | 6 | 2024-02-02 | 200.05 | 5.00 | 2024-01-21 | 1 | 199.85 | 1 | 200.05 | 21 | SO58958 | 2024-01-28 | 16.00 | 199.85 | 200.05 | |||
SO47354_51 | 6E1C-48C6-89 | PO19401144959 | 19 | 291 | 415 | 173 | 6 | 2022-11-03 | 198.04 | 4.95 | 2022-10-22 | 1 | 146.55 | 1 | 198.04 | 51 | SO47354 | 2022-10-29 | 15.84 | 146.55 | 198.04 | |||
SO53513_19 | 5E21-438C-B3 | PO10875194431 | 19 | 291 | 569 | 13 | 281 | 6 | 100.22 | 2023-11-03 | 668.12 | 14.20 | 2023-10-22 | 2 | 461.44 | 1 | 567.90 | 19 | SO53513 | 2023-10-29 | 45.43 | 922.89 | 334.06 | 0.15 |
SO47396_1 | 6B61-4DD9-AA | PO11165191815 | 19 | 291 | 420 | 586 | 6 | 2022-11-03 | 566.46 | 14.16 | 2022-10-22 | 4 | 104.80 | 1 | 566.46 | 1 | SO47396 | 2022-10-29 | 45.32 | 419.18 | 141.62 | |||
SO51699_28 | 31D5-494C-BA | PO18879118606 | 19 | 291 | 558 | 64 | 6 | 2023-10-03 | 242.99 | 6.07 | 2023-09-21 | 1 | 179.82 | 1 | 242.99 | 28 | SO51699 | 2023-09-28 | 19.44 | 179.82 | 242.99 | |||
SO46953_21 | C650-4C32-BE | PO17603154442 | 19 | 284 | 445 | 12 | 6 | 2022-10-03 | 143.98 | 3.60 | 2022-09-21 | 4 | 24.75 | 1 | 143.98 | 21 | SO46953 | 2022-09-28 | 11.52 | 98.98 | 35.99 | |||
SO48761_9 | E39C-4A4E-A3 | PO15312195795 | 19 | 291 | 343 | 299 | 6 | 2023-03-05 | 939.59 | 23.49 | 2023-02-21 | 2 | 486.71 | 1 | 939.59 | 9 | SO48761 | 2023-02-28 | 75.17 | 973.41 | 469.79 | |||
SO71871_4 | DD8F-4CAB-A1 | PO14239120760 | 19 | 291 | 491 | 550 | 6 | 2024-08-03 | 226.76 | 5.67 | 2024-07-22 | 7 | 41.57 | 1 | 226.76 | 4 | SO71871 | 2024-07-29 | 18.14 | 291.01 | 32.39 | |||
SO57154_16 | 464B-46A4-B6 | PO1856185040 | 19 | 291 | 472 | 2 | 263 | 6 | 8.84 | 2024-01-03 | 441.96 | 10.83 | 2023-12-22 | 12 | 23.75 | 1 | 433.12 | 16 | SO57154 | 2023-12-29 | 34.65 | 284.99 | 36.83 | 0.02 |
SO50245_31 | 28E4-4CC9-BF | PO1914152990 | 19 | 284 | 453 | 66 | 6 | 2023-07-03 | 215.96 | 5.40 | 2023-06-21 | 6 | 24.75 | 1 | 215.96 | 31 | SO50245 | 2023-06-28 | 17.28 | 148.48 | 35.99 | |||
SO46614_55 | 0B65-4374-89 | PO15312137226 | 19 | 291 | 337 | 299 | 6 | 2022-09-02 | 469.79 | 11.74 | 2022-08-21 | 1 | 486.71 | 1 | 469.79 | 55 | SO46614 | 2022-08-28 | 37.58 | 486.71 | 469.79 | |||
SO71800_22 | 6DBE-44CC-BD | PO15544127760 | 19 | 284 | 523 | 282 | 6 | 2024-08-03 | 63.17 | 1.58 | 2024-07-22 | 2 | 23.37 | 1 | 63.17 | 22 | SO71800 | 2024-07-29 | 5.05 | 46.74 | 31.58 | |||
SO47967_19 | DA42-41A7-BD | PO19198173391 | 19 | 291 | 305 | 653 | 6 | 2023-01-03 | 2944.58 | 73.61 | 2022-12-22 | 4 | 653.70 | 1 | 2944.58 | 19 | SO47967 | 2022-12-29 | 235.57 | 2614.79 | 736.15 | |||
SO48306_23 | EA27-471A-9D | PO17574166075 | 19 | 291 | 427 | 678 | 6 | 2023-02-02 | 627.77 | 15.69 | 2023-01-21 | 3 | 185.82 | 1 | 627.77 | 23 | SO48306 | 2023-01-28 | 50.22 | 557.46 | 209.26 | |||
SO58918_32 | C811-4D40-80 | PO17574131484 | 19 | 291 | 298 | 678 | 6 | 2024-02-02 | 1619.52 | 40.49 | 2024-01-21 | 2 | 739.04 | 1 | 1619.52 | 32 | SO58918 | 2024-01-28 | 129.56 | 1478.08 | 809.76 | |||
SO46044_4 | 029B-4675-9A | PO16733123313 | 19 | 288 | 310 | 533 | 6 | 2022-07-03 | 6440.89 | 161.02 | 2022-06-21 | 3 | 2171.29 | 1 | 6440.89 | 4 | SO46044 | 2022-06-28 | 515.27 | 6513.88 | 2146.96 | |||
SO44300_10 | 5132-4204-BB | PO10527120063 | 19 | 284 | 332 | 480 | 6 | 2021-12-03 | 838.92 | 20.97 | 2021-11-21 | 2 | 413.15 | 1 | 838.92 | 10 | SO44300 | 2021-11-28 | 67.11 | 826.29 | 419.46 | |||
SO69401_29 | 5377-4B5B-80 | PO17603155358 | 19 | 284 | 484 | 12 | 6 | 2024-07-03 | 23.85 | 0.60 | 2024-06-21 | 5 | 2.97 | 1 | 23.85 | 29 | SO69401 | 2024-06-28 | 1.91 | 14.87 | 4.77 | |||
SO57093_14 | 2F7C-4AF6-8B | PO18705165751 | 19 | 291 | 225 | 479 | 6 | 2024-01-03 | 21.58 | 0.54 | 2023-12-22 | 4 | 6.92 | 1 | 21.58 | 14 | SO57093 | 2023-12-29 | 1.73 | 27.69 | 5.39 | |||
SO50195_3 | F28B-4548-99 | PO19198175870 | 19 | 291 | 469 | 653 | 6 | 2023-07-03 | 91.18 | 2.28 | 2023-06-21 | 4 | 15.67 | 1 | 91.18 | 3 | SO50195 | 2023-06-28 | 7.29 | 62.68 | 22.79 | |||
SO47012_34 | 5043-4C8B-B3 | PO1914167487 | 19 | 284 | 456 | 66 | 6 | 2022-10-03 | 179.98 | 4.50 | 2022-09-21 | 4 | 30.93 | 1 | 179.98 | 34 | SO47012 | 2022-09-28 | 14.40 | 123.73 | 44.99 | |||
SO46953_29 | C650-4C32-BE | PO17603154442 | 19 | 284 | 221 | 2 | 12 | 6 | 5.07 | 2022-10-03 | 253.68 | 6.22 | 2022-09-21 | 13 | 13.88 | 1 | 248.60 | 29 | SO46953 | 2022-09-28 | 19.89 | 180.42 | 19.51 | 0.02 |
Generated 2024-09-20 03:47:13.809 UTC