[ROOT] dt FactResellerSale < WHERE DimSalesTerritoryId EQ '6' > SKIP 0 SHUFFLE < SKIP 1047 > < 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 |
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
| SO51160_41 | 3F3F-4135-B0 | PO4495157262 | 19 | 291 | 603 | 496 | 6 | 2023-10-23 | 291.58 | 7.29 | 2023-10-11 | 4 | 53.94 | 1 | 291.58 | 41 | SO51160 | 2023-10-18 | 23.33 | 215.77 | 72.89 | |||
| SO47359_4 | 8BC9-458A-82 | PO18299145297 | 19 | 291 | 470 | 2 | 118 | 6 | 4.85 | 2022-12-24 | 242.38 | 5.94 | 2022-12-12 | 11 | 15.67 | 1 | 237.53 | 4 | SO47359 | 2022-12-19 | 19.00 | 172.38 | 22.03 | 0.02 |
| SO47365_48 | 4535-457B-B0 | PO17574153673 | 19 | 291 | 457 | 678 | 6 | 2022-12-24 | 179.98 | 4.50 | 2022-12-12 | 4 | 30.93 | 1 | 179.98 | 48 | SO47365 | 2022-12-19 | 14.40 | 123.73 | 44.99 | |||
| SO48033_5 | BC9E-4246-AC | PO1595118269 | 19 | 284 | 368 | 426 | 6 | 2023-02-23 | 2932.02 | 73.30 | 2023-02-11 | 2 | 1518.79 | 1 | 2932.02 | 5 | SO48033 | 2023-02-18 | 234.56 | 3037.57 | 1466.01 | |||
| SO71794_5 | C39A-4835-99 | PO17574111985 | 19 | 291 | 542 | 678 | 6 | 2024-09-23 | 121.47 | 3.04 | 2024-09-11 | 5 | 17.98 | 1 | 121.47 | 5 | SO71794 | 2024-09-18 | 9.72 | 89.89 | 24.29 | |||
| SO53483_35 | A0BE-40E0-81 | PO14761137153 | 19 | 284 | 553 | 408 | 6 | 2023-12-24 | 27.65 | 0.69 | 2023-12-12 | 1 | 20.46 | 1 | 27.65 | 35 | SO53483 | 2023-12-19 | 2.21 | 20.46 | 27.65 | |||
| SO43662_18 | 2E53-4802-85 | PO18444174044 | 19 | 288 | 264 | 227 | 6 | 2021-10-23 | 183.94 | 4.60 | 2021-10-11 | 1 | 181.49 | 1 | 183.94 | 18 | SO43662 | 2021-10-18 | 14.72 | 181.49 | 183.94 | |||
| SO58911_12 | C991-4920-91 | PO19401135315 | 19 | 291 | 545 | 173 | 6 | 2024-03-24 | 72.88 | 1.82 | 2024-03-12 | 3 | 17.98 | 1 | 72.88 | 12 | SO58911 | 2024-03-19 | 5.83 | 53.93 | 24.29 | |||
| SO57154_17 | 464B-46A4-B6 | PO1856185040 | 19 | 291 | 477 | 263 | 6 | 2024-02-23 | 17.96 | 0.45 | 2024-02-11 | 6 | 1.87 | 1 | 17.96 | 17 | SO57154 | 2024-02-18 | 1.44 | 11.20 | 2.99 | |||
| SO48761_2 | E39C-4A4E-A3 | PO15312195795 | 19 | 291 | 271 | 299 | 6 | 2023-04-25 | 404.66 | 10.12 | 2023-04-13 | 2 | 187.16 | 1 | 404.66 | 2 | SO48761 | 2023-04-20 | 32.37 | 374.31 | 202.33 | |||
| SO45047_5 | B1C5-444F-BF | PO14732155479 | 19 | 288 | 334 | 514 | 6 | 2022-04-25 | 1258.38 | 31.46 | 2022-04-13 | 3 | 413.15 | 1 | 1258.38 | 5 | SO45047 | 2022-04-20 | 100.67 | 1239.44 | 419.46 | |||
| SO51124_31 | 5EEF-4271-BB | PO1711177181 | 19 | 291 | 516 | 245 | 6 | 2023-10-23 | 140.90 | 3.52 | 2023-10-11 | 6 | 17.38 | 1 | 140.90 | 31 | SO51124 | 2023-10-18 | 11.27 | 104.27 | 23.48 | |||
| SO49827_18 | E4F0-4B91-84 | PO15312199090 | 19 | 291 | 263 | 299 | 6 | 2023-07-24 | 607.00 | 15.17 | 2023-07-12 | 3 | 187.16 | 1 | 607.00 | 18 | SO49827 | 2023-07-19 | 48.56 | 561.47 | 202.33 | |||
| SO63122_1 | 49E9-48B0-81 | PO19459112433 | 19 | 291 | 545 | 334 | 6 | 2024-05-25 | 24.29 | 0.61 | 2024-05-13 | 1 | 17.98 | 1 | 24.29 | 1 | SO63122 | 2024-05-20 | 1.94 | 17.98 | 24.29 | |||
| SO51703_35 | 53F7-4B59-AA | PO17603160217 | 19 | 284 | 484 | 12 | 6 | 2023-11-23 | 42.93 | 1.07 | 2023-11-11 | 9 | 2.97 | 1 | 42.93 | 35 | SO51703 | 2023-11-18 | 3.43 | 26.76 | 4.77 | |||
| SO44081_11 | 32E7-4EA4-9F | PO18299115585 | 19 | 288 | 223 | 118 | 6 | 2021-12-24 | 15.56 | 0.39 | 2021-12-12 | 3 | 5.71 | 1 | 15.56 | 11 | SO44081 | 2021-12-19 | 1.24 | 17.12 | 5.19 | |||
| SO46614_58 | 0B65-4374-89 | PO15312137226 | 19 | 291 | 329 | 299 | 6 | 2022-10-23 | 939.59 | 23.49 | 2022-10-11 | 2 | 486.71 | 1 | 939.59 | 58 | SO46614 | 2022-10-18 | 75.17 | 973.41 | 469.79 | |||
| SO48299_27 | ABFA-41A9-A7 | PO18299110324 | 19 | 291 | 456 | 118 | 6 | 2023-03-25 | 179.98 | 4.50 | 2023-03-13 | 4 | 30.93 | 1 | 179.98 | 27 | SO48299 | 2023-03-20 | 14.40 | 123.73 | 44.99 | |||
| SO47037_33 | C1AE-48A5-9F | PO4901170321 | 19 | 284 | 415 | 84 | 6 | 2022-11-23 | 198.04 | 4.95 | 2022-11-11 | 1 | 146.55 | 1 | 198.04 | 33 | SO47037 | 2022-11-18 | 15.84 | 146.55 | 198.04 | |||
| SO46953_25 | C650-4C32-BE | PO17603154442 | 19 | 284 | 448 | 12 | 6 | 2022-11-23 | 119.94 | 3.00 | 2022-11-11 | 10 | 8.25 | 1 | 119.94 | 25 | SO46953 | 2022-11-18 | 9.60 | 82.46 | 11.99 | |||
| SO48299_14 | ABFA-41A9-A7 | PO18299110324 | 19 | 291 | 399 | 118 | 6 | 2023-03-25 | 67.55 | 1.69 | 2023-03-13 | 2 | 24.99 | 1 | 67.55 | 14 | SO48299 | 2023-03-20 | 5.40 | 49.99 | 33.77 | |||
| SO48023_16 | 18BD-4FA3-9F | PO11020197101 | 19 | 284 | 383 | 336 | 6 | 2023-02-23 | 1200.53 | 30.01 | 2023-02-11 | 2 | 605.65 | 1 | 1200.53 | 16 | SO48023 | 2023-02-18 | 96.04 | 1211.30 | 600.26 | |||
| SO47031_12 | 3FA6-4120-BD | PO4466161844 | 19 | 291 | 216 | 352 | 6 | 2022-11-23 | 141.31 | 3.53 | 2022-11-11 | 7 | 13.88 | 1 | 141.31 | 12 | SO47031 | 2022-11-18 | 11.30 | 97.15 | 20.19 | |||
| SO49069_22 | 251D-4CF2-8D | PO1914132192 | 19 | 284 | 213 | 66 | 6 | 2023-05-26 | 40.37 | 1.01 | 2023-05-14 | 2 | 13.88 | 1 | 40.37 | 22 | SO49069 | 2023-05-21 | 3.23 | 27.76 | 20.19 | |||
| SO46936_12 | 95A0-4327-AA | PO19227121833 | 19 | 284 | 271 | 210 | 6 | 2022-11-23 | 607.00 | 15.17 | 2022-11-11 | 3 | 187.16 | 1 | 607.00 | 12 | SO46936 | 2022-11-18 | 48.56 | 561.47 | 202.33 | |||
| SO47013_5 | 4AB0-4FA0-95 | PO1827132360 | 19 | 291 | 321 | 317 | 6 | 2022-11-23 | 1409.38 | 35.23 | 2022-11-11 | 3 | 486.71 | 1 | 1409.38 | 5 | SO47013 | 2022-11-18 | 112.75 | 1460.12 | 469.79 | |||
| SO49089_3 | 41D5-4730-84 | PO12789114136 | 19 | 291 | 468 | 677 | 6 | 2023-05-26 | 22.79 | 0.57 | 2023-05-14 | 1 | 15.67 | 1 | 22.79 | 3 | SO49089 | 2023-05-21 | 1.82 | 15.67 | 22.79 | |||
| SO47357_13 | 3E93-4357-9B | PO18531126368 | 19 | 284 | 460 | 613 | 6 | 2022-12-24 | 107.99 | 2.70 | 2022-12-12 | 2 | 37.12 | 1 | 107.99 | 13 | SO47357 | 2022-12-19 | 8.64 | 74.24 | 53.99 | |||
| SO44081_13 | 32E7-4EA4-9F | PO18299115585 | 19 | 288 | 350 | 118 | 6 | 2021-12-24 | 4049.99 | 101.25 | 2021-12-12 | 2 | 1898.09 | 1 | 4049.99 | 13 | SO44081 | 2021-12-19 | 324.00 | 3796.19 | 2024.99 | |||
| SO49855_13 | 0C94-4D84-A4 | PO18473166459 | 19 | 291 | 399 | 442 | 6 | 2023-07-24 | 168.87 | 4.22 | 2023-07-12 | 5 | 24.99 | 1 | 168.87 | 13 | SO49855 | 2023-07-19 | 13.51 | 124.97 | 33.77 |
Generated 2024-11-10 09:50:03.339 UTC