[ROOT] dt FactResellerSale < WHERE DimSalesTerritoryId EQ '6' > SKIP 4000 SHUFFLE < SKIP 843 > < 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 |
---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
SO47359_19 | 8BC9-458A-82 | PO18299145297 | 19 | 291 | 421 | 2 | 118 | 6 | 41.75 | 2022-11-03 | 2087.63 | 51.15 | 2022-10-22 | 11 | 145.28 | 1 | 2045.88 | 19 | SO47359 | 2022-10-29 | 163.67 | 1598.12 | 189.78 | 0.02 |
SO47003_11 | 2C85-4918-94 | PO638185142 | 19 | 291 | 469 | 280 | 6 | 2022-10-03 | 45.59 | 1.14 | 2022-09-21 | 2 | 15.67 | 1 | 45.59 | 11 | SO47003 | 2022-09-28 | 3.65 | 31.34 | 22.79 | |||
SO50676_34 | 66F1-4A9A-97 | PO14790188963 | 19 | 291 | 365 | 497 | 6 | 2023-08-03 | 647.99 | 16.20 | 2023-07-22 | 1 | 598.44 | 1 | 647.99 | 34 | SO50676 | 2023-07-29 | 51.84 | 598.44 | 647.99 | |||
SO63239_2 | AF5E-48ED-A4 | PO4901178462 | 19 | 284 | 234 | 84 | 6 | 2024-04-04 | 239.95 | 6.00 | 2024-03-23 | 8 | 38.49 | 1 | 239.95 | 2 | SO63239 | 2024-03-30 | 19.20 | 307.94 | 29.99 | |||
SO49828_26 | 8223-49DF-83 | PO14732189078 | 19 | 291 | 286 | 514 | 6 | 2023-06-03 | 551.81 | 13.80 | 2023-05-22 | 3 | 170.14 | 1 | 551.81 | 26 | SO49828 | 2023-05-29 | 44.15 | 510.43 | 183.94 | |||
SO46997_3 | 9714-4035-90 | PO11020181604 | 19 | 284 | 383 | 336 | 6 | 2022-10-03 | 4802.10 | 120.05 | 2022-09-21 | 8 | 605.65 | 1 | 4802.10 | 3 | SO46997 | 2022-09-28 | 384.17 | 4845.19 | 600.26 | |||
SO65164_33 | 07B8-4AF8-8A | PO18299114573 | 19 | 291 | 217 | 118 | 6 | 2024-05-03 | 83.98 | 2.10 | 2024-04-21 | 4 | 13.09 | 1 | 83.98 | 33 | SO65164 | 2024-04-28 | 6.72 | 52.35 | 20.99 | |||
SO47411_6 | 4BDD-4511-AC | PO1798140269 | 19 | 291 | 360 | 10 | 6 | 2022-11-03 | 4917.84 | 122.95 | 2022-10-22 | 4 | 1105.81 | 1 | 4917.84 | 6 | SO47411 | 2022-10-29 | 393.43 | 4423.24 | 1229.46 | |||
SO58911_3 | C991-4920-91 | PO19401135315 | 19 | 291 | 605 | 173 | 6 | 2024-02-02 | 1619.97 | 40.50 | 2024-01-21 | 5 | 343.65 | 1 | 1619.97 | 3 | SO58911 | 2024-01-28 | 129.60 | 1718.25 | 323.99 | |||
SO58958_12 | BC3F-443F-B5 | PO10875118816 | 19 | 291 | 500 | 281 | 6 | 2024-02-02 | 2409.38 | 60.23 | 2024-01-21 | 4 | 601.74 | 1 | 2409.38 | 12 | SO58958 | 2024-01-28 | 192.75 | 2406.97 | 602.35 | |||
SO49066_27 | 4065-4B0A-A2 | PO1595117888 | 19 | 284 | 233 | 426 | 6 | 2023-04-05 | 173.04 | 4.33 | 2023-03-24 | 6 | 29.08 | 1 | 173.04 | 27 | SO49066 | 2023-03-31 | 13.84 | 174.48 | 28.84 | |||
SO63290_2 | 0F43-405E-B8 | PO9077159728 | 19 | 291 | 476 | 100 | 6 | 2024-04-04 | 167.98 | 4.20 | 2024-03-23 | 4 | 26.18 | 1 | 167.98 | 2 | SO63290 | 2024-03-30 | 13.44 | 104.71 | 41.99 | |||
SO59042_4 | 8DB9-4316-8F | PO1972174730 | 19 | 291 | 588 | 190 | 6 | 2024-02-02 | 923.39 | 23.08 | 2024-01-21 | 2 | 419.78 | 1 | 923.39 | 4 | SO59042 | 2024-01-28 | 73.87 | 839.56 | 461.69 | |||
SO47354_28 | 6E1C-48C6-89 | PO19401144959 | 19 | 291 | 263 | 173 | 6 | 2022-11-03 | 607.00 | 15.17 | 2022-10-22 | 3 | 187.16 | 1 | 607.00 | 28 | SO47354 | 2022-10-29 | 48.56 | 561.47 | 202.33 | |||
SO71806_19 | 26A7-4E95-9B | PO14790111844 | 19 | 291 | 309 | 497 | 6 | 2024-08-03 | 818.70 | 20.47 | 2024-07-22 | 1 | 747.20 | 1 | 818.70 | 19 | SO71806 | 2024-07-29 | 65.50 | 747.20 | 818.70 | |||
SO47012_3 | 5043-4C8B-B3 | PO1914167487 | 19 | 284 | 236 | 66 | 6 | 2022-10-03 | 230.72 | 5.77 | 2022-09-21 | 8 | 29.08 | 1 | 230.72 | 3 | SO47012 | 2022-09-28 | 18.46 | 232.65 | 28.84 | |||
SO63140_7 | 0582-4EB7-B7 | PO17661112720 | 19 | 284 | 568 | 264 | 6 | 2024-04-04 | 890.82 | 22.27 | 2024-03-23 | 2 | 461.44 | 1 | 890.82 | 7 | SO63140 | 2024-03-30 | 71.27 | 922.89 | 445.41 | |||
SO58949_4 | 5D37-48BC-B5 | PO11165128759 | 19 | 291 | 359 | 586 | 6 | 2024-02-02 | 6884.97 | 172.12 | 2024-01-21 | 5 | 1251.98 | 1 | 6884.97 | 4 | SO58949 | 2024-01-28 | 550.80 | 6259.91 | 1376.99 | |||
SO46959_50 | 9007-4F97-9C | PO16733197949 | 19 | 291 | 369 | 533 | 6 | 2022-10-03 | 4398.03 | 109.95 | 2022-09-21 | 3 | 1518.79 | 1 | 4398.03 | 50 | SO46959 | 2022-09-28 | 351.84 | 4556.36 | 1466.01 | |||
SO47366_2 | DD3E-4DAA-BA | PO17545115575 | 19 | 291 | 333 | 155 | 6 | 2022-11-03 | 939.59 | 23.49 | 2022-10-22 | 2 | 486.71 | 1 | 939.59 | 2 | SO47366 | 2022-10-29 | 75.17 | 973.41 | 469.79 | |||
SO49055_1 | 1FED-4D8E-86 | PO14819164751 | 19 | 284 | 468 | 462 | 6 | 2023-04-05 | 22.79 | 0.57 | 2023-03-24 | 1 | 15.67 | 1 | 22.79 | 1 | SO49055 | 2023-03-31 | 1.82 | 15.67 | 22.79 | |||
SO50295_1 | 575E-4F7A-9C | PO4466165095 | 19 | 291 | 365 | 352 | 6 | 2023-07-03 | 1943.98 | 48.60 | 2023-06-21 | 3 | 598.44 | 1 | 1943.98 | 1 | SO50295 | 2023-06-28 | 155.52 | 1795.31 | 647.99 | |||
SO49072_5 | B98C-4814-B1 | PO2146179731 | 19 | 284 | 294 | 354 | 6 | 2023-04-05 | 2232.82 | 55.82 | 2023-03-24 | 3 | 660.91 | 1 | 2232.82 | 5 | SO49072 | 2023-03-31 | 178.63 | 1982.74 | 744.27 | |||
SO57120_34 | 058D-436F-BF | PO4466170177 | 19 | 291 | 588 | 352 | 6 | 2024-01-03 | 2770.16 | 69.25 | 2023-12-22 | 6 | 419.78 | 1 | 2770.16 | 34 | SO57120 | 2023-12-29 | 221.61 | 2518.67 | 461.69 | |||
SO46614_29 | 0B65-4374-89 | PO15312137226 | 19 | 291 | 383 | 299 | 6 | 2022-09-02 | 600.26 | 15.01 | 2022-08-21 | 1 | 605.65 | 1 | 600.26 | 29 | SO46614 | 2022-08-28 | 48.02 | 605.65 | 600.26 | |||
SO49140_22 | EFF3-483D-BE | PO4901154744 | 19 | 284 | 417 | 84 | 6 | 2023-04-05 | 648.91 | 16.22 | 2023-03-24 | 2 | 300.12 | 1 | 648.91 | 22 | SO49140 | 2023-03-31 | 51.91 | 600.24 | 324.45 | |||
SO46326_15 | EDD8-4703-B2 | PO19401160698 | 19 | 288 | 311 | 173 | 6 | 2022-08-03 | 2146.96 | 53.67 | 2022-07-22 | 1 | 2171.29 | 1 | 2146.96 | 15 | SO46326 | 2022-07-29 | 171.76 | 2171.29 | 2146.96 | |||
SO55283_25 | 8D6B-460A-83 | PO18473174493 | 19 | 291 | 558 | 442 | 6 | 2023-12-03 | 242.99 | 6.07 | 2023-11-21 | 1 | 179.82 | 1 | 242.99 | 25 | SO55283 | 2023-11-28 | 19.44 | 179.82 | 242.99 | |||
SO58973_1 | DB2C-4D5F-86 | PO1740110032 | 19 | 291 | 481 | 460 | 6 | 2024-02-02 | 16.18 | 0.40 | 2024-01-21 | 3 | 3.36 | 1 | 16.18 | 1 | SO58973 | 2024-01-28 | 1.29 | 10.09 | 5.39 | |||
SO47362_2 | 41E3-4BA0-99 | PO17690189228 | 19 | 291 | 399 | 47 | 6 | 2022-11-03 | 168.87 | 4.22 | 2022-10-22 | 5 | 24.99 | 1 | 168.87 | 2 | SO47362 | 2022-10-29 | 13.51 | 124.97 | 33.77 | |||
SO46034_5 | BF2B-4539-A2 | PO18415186478 | 19 | 288 | 253 | 191 | 6 | 2022-07-03 | 357.16 | 8.93 | 2022-06-21 | 2 | 176.20 | 1 | 357.16 | 5 | SO46034 | 2022-06-28 | 28.57 | 352.40 | 178.58 |
Generated 2024-09-20 15:34:45.720 UTC