[ROOT] dt FactResellerSale WHERE DimSalesTerritoryId EQ '1' > SHUFFLE < SKIP 6126 > < 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 |
---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
SO69475_33 | F74A-4967-BA | PO18618162557 | 100 | 286 | 231 | 605 | 1 | 2024-08-23 | 119.98 | 3.00 | 2024-08-11 | 4 | 38.49 | 1 | 119.98 | 33 | SO69475 | 2024-08-18 | 9.60 | 153.97 | 29.99 | |||
SO49889_3 | 8783-45FC-96 | PO7105112550 | 100 | 293 | 456 | 668 | 1 | 2023-07-24 | 44.99 | 1.12 | 2023-07-12 | 1 | 30.93 | 1 | 44.99 | 3 | SO49889 | 2023-07-19 | 3.60 | 30.93 | 44.99 | |||
SO50321_13 | 6B3D-47E0-99 | PO8816191637 | 100 | 289 | 414 | 218 | 1 | 2023-08-23 | 596.12 | 14.90 | 2023-08-11 | 4 | 110.28 | 1 | 596.12 | 13 | SO50321 | 2023-08-18 | 47.69 | 441.13 | 149.03 | |||
SO71818_4 | 2FCA-4131-BD | PO12470139718 | 100 | 287 | 494 | 672 | 1 | 2024-09-23 | 1204.69 | 30.12 | 2024-09-11 | 2 | 601.74 | 1 | 1204.69 | 4 | SO71818 | 2024-09-18 | 96.38 | 1203.49 | 602.35 | |||
SO51138_21 | 685D-4916-A6 | PO9338137293 | 100 | 293 | 579 | 451 | 1 | 2023-10-23 | 5102.37 | 127.56 | 2023-10-11 | 7 | 755.15 | 1 | 5102.37 | 21 | SO51138 | 2023-10-18 | 408.19 | 5286.06 | 728.91 | |||
SO57046_55 | 52CC-460F-B3 | PO14500161818 | 100 | 282 | 490 | 650 | 1 | 2024-02-23 | 194.36 | 4.86 | 2024-02-11 | 6 | 41.57 | 1 | 194.36 | 55 | SO57046 | 2024-02-18 | 15.55 | 249.43 | 32.39 | |||
SO47033_37 | 2797-46ED-BB | PO4727113716 | 100 | 286 | 216 | 343 | 1 | 2022-11-23 | 80.75 | 2.02 | 2022-11-11 | 4 | 13.88 | 1 | 80.75 | 37 | SO47033 | 2022-11-18 | 6.46 | 55.51 | 20.19 | |||
SO57030_9 | 373C-4C0F-88 | PO16414180321 | 100 | 289 | 476 | 236 | 1 | 2024-02-23 | 251.96 | 6.30 | 2024-02-11 | 6 | 26.18 | 1 | 251.96 | 9 | SO57030 | 2024-02-18 | 20.16 | 157.06 | 41.99 | |||
SO69422_24 | BF3A-4F54-82 | PO14500139823 | 100 | 282 | 484 | 650 | 1 | 2024-08-23 | 38.16 | 0.95 | 2024-08-11 | 8 | 2.97 | 1 | 38.16 | 24 | SO69422 | 2024-08-18 | 3.05 | 23.79 | 4.77 | |||
SO46105_31 | 2590-40A7-BB | PO8816169858 | 100 | 289 | 336 | 218 | 1 | 2022-08-23 | 1677.84 | 41.95 | 2022-08-11 | 4 | 413.15 | 1 | 1677.84 | 31 | SO46105 | 2022-08-18 | 134.23 | 1652.59 | 419.46 | |||
SO71836_10 | E41E-40C1-84 | PO841118259 | 100 | 286 | 474 | 2 | 254 | 1 | 10.55 | 2024-09-23 | 527.72 | 12.93 | 2024-09-11 | 13 | 26.18 | 1 | 517.17 | 10 | SO71836 | 2024-09-18 | 41.37 | 340.29 | 40.59 | 0.02 |
SO69406_16 | E101-486C-A5 | PO16675181672 | 100 | 293 | 578 | 361 | 1 | 2024-08-23 | 1457.82 | 36.45 | 2024-08-11 | 2 | 755.15 | 1 | 1457.82 | 16 | SO69406 | 2024-08-18 | 116.63 | 1510.30 | 728.91 | |||
SO50758_5 | 23D8-44CE-96 | PO8903112353 | 100 | 293 | 329 | 235 | 1 | 2023-09-23 | 1409.38 | 35.23 | 2023-09-11 | 3 | 486.71 | 1 | 1409.38 | 5 | SO50758 | 2023-09-18 | 112.75 | 1460.12 | 469.79 | |||
SO51127_7 | D321-4FEA-80 | PO2552155165 | 100 | 286 | 398 | 506 | 1 | 2023-10-23 | 133.62 | 3.34 | 2023-10-11 | 5 | 19.78 | 1 | 133.62 | 7 | SO51127 | 2023-10-18 | 10.69 | 98.88 | 26.72 | |||
SO50758_3 | 23D8-44CE-96 | PO8903112353 | 100 | 293 | 458 | 235 | 1 | 2023-09-23 | 134.98 | 3.37 | 2023-09-11 | 3 | 30.93 | 1 | 134.98 | 3 | SO50758 | 2023-09-18 | 10.80 | 92.80 | 44.99 | |||
SO53613_28 | 4A10-4F98-84 | PO6815195063 | 100 | 293 | 588 | 109 | 1 | 2023-12-24 | 923.39 | 23.08 | 2023-12-12 | 2 | 419.78 | 1 | 923.39 | 28 | SO53613 | 2023-12-19 | 73.87 | 839.56 | 461.69 | |||
SO46372_4 | 236A-4108-B4 | PO5220136009 | 100 | 282 | 307 | 169 | 1 | 2022-09-23 | 1445.19 | 36.13 | 2022-09-11 | 2 | 623.84 | 1 | 1445.19 | 4 | SO46372 | 2022-09-18 | 115.62 | 1247.68 | 722.59 | |||
SO46030_1 | 8D5D-4CBC-8F | PO18908181698 | 100 | 289 | 346 | 164 | 1 | 2022-08-23 | 4079.99 | 102.00 | 2022-08-11 | 2 | 1912.15 | 1 | 4079.99 | 1 | SO46030 | 2022-08-18 | 326.40 | 3824.31 | 2039.99 | |||
SO50270_24 | A828-45A2-8B | PO18676112371 | 100 | 282 | 367 | 697 | 1 | 2023-08-23 | 6479.94 | 162.00 | 2023-08-11 | 10 | 598.44 | 1 | 6479.94 | 24 | SO50270 | 2023-08-18 | 518.40 | 5984.35 | 647.99 | |||
SO57036_2 | A71E-4FC0-8D | PO15631137127 | 100 | 282 | 543 | 43 | 1 | 2024-02-23 | 37.25 | 0.93 | 2024-02-11 | 1 | 27.57 | 1 | 37.25 | 2 | SO57036 | 2024-02-18 | 2.98 | 27.57 | 37.25 | |||
SO50314_25 | 5D9A-4B55-81 | PO7627146177 | 100 | 293 | 422 | 433 | 1 | 2023-08-23 | 270.16 | 6.75 | 2023-08-11 | 4 | 49.98 | 1 | 270.16 | 25 | SO50314 | 2023-08-18 | 21.61 | 199.92 | 67.54 | |||
SO46105_13 | 2590-40A7-BB | PO8816169858 | 100 | 289 | 338 | 218 | 1 | 2022-08-23 | 1258.38 | 31.46 | 2022-08-11 | 3 | 413.15 | 1 | 1258.38 | 13 | SO46105 | 2022-08-18 | 100.67 | 1239.44 | 419.46 | |||
SO48741_17 | 5AA4-4194-B9 | PO899196006 | 100 | 289 | 271 | 290 | 1 | 2023-04-25 | 607.00 | 15.17 | 2023-04-13 | 3 | 187.16 | 1 | 607.00 | 17 | SO48741 | 2023-04-20 | 48.56 | 561.47 | 202.33 | |||
SO55241_20 | F7DC-49D7-89 | PO16588188882 | 100 | 289 | 589 | 146 | 1 | 2024-01-23 | 1846.78 | 46.17 | 2024-01-11 | 4 | 419.78 | 1 | 1846.78 | 20 | SO55241 | 2024-01-18 | 147.74 | 1679.11 | 461.69 | |||
SO47033_43 | 2797-46ED-BB | PO4727113716 | 100 | 286 | 377 | 343 | 1 | 2022-11-23 | 2617.88 | 65.45 | 2022-11-11 | 2 | 1320.68 | 1 | 2617.88 | 43 | SO47033 | 2022-11-18 | 209.43 | 2641.37 | 1308.94 | |||
SO57045_20 | 4D3C-4309-BE | PO14587121888 | 100 | 293 | 574 | 199 | 1 | 2024-02-23 | 8582.65 | 214.57 | 2024-02-11 | 6 | 1481.94 | 1 | 8582.65 | 20 | SO57045 | 2024-02-18 | 686.61 | 8891.63 | 1430.44 | |||
SO55241_31 | F7DC-49D7-89 | PO16588188882 | 100 | 289 | 488 | 146 | 1 | 2024-01-23 | 64.79 | 1.62 | 2024-01-11 | 2 | 41.57 | 1 | 64.79 | 31 | SO55241 | 2024-01-18 | 5.18 | 83.14 | 32.39 | |||
SO53518_7 | 5712-444B-BC | PO841197199 | 100 | 286 | 517 | 254 | 1 | 2023-12-24 | 94.75 | 2.37 | 2023-12-12 | 3 | 23.37 | 1 | 94.75 | 7 | SO53518 | 2023-12-19 | 7.58 | 70.12 | 31.58 | |||
SO63148_6 | 00FA-42B1-88 | PO16675153915 | 100 | 293 | 562 | 361 | 1 | 2024-05-25 | 1430.44 | 35.76 | 2024-05-13 | 1 | 1481.94 | 1 | 1430.44 | 6 | SO63148 | 2024-05-20 | 114.44 | 1481.94 | 1430.44 | |||
SO43683_1 | 2299-44F7-95 | PO2552113807 | 100 | 289 | 349 | 506 | 1 | 2021-10-23 | 4049.99 | 101.25 | 2021-10-11 | 2 | 1898.09 | 1 | 4049.99 | 1 | SO43683 | 2021-10-18 | 324.00 | 3796.19 | 2024.99 | |||
SO49092_36 | 72CE-4E29-82 | PO14442163644 | 100 | 293 | 448 | 127 | 1 | 2023-05-26 | 35.98 | 0.90 | 2023-05-14 | 3 | 8.25 | 1 | 35.98 | 36 | SO49092 | 2023-05-21 | 2.88 | 24.74 | 11.99 |
Generated 2024-11-10 11:05:50.133 UTC