[ROOT] dt FactResellerSale < WHERE DimSalesTerritoryId EQ '6' > SHUFFLE < SKIP 314 > < 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 |
---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
SO49484_36 | B25F-4DF4-8E | PO18299142683 | 19 | 291 | 410 | 118 | 6 | 2023-05-03 | 36.45 | 0.91 | 2023-04-21 | 1 | 26.97 | 1 | 36.45 | 36 | SO49484 | 2023-04-28 | 2.92 | 26.97 | 36.45 | |||
SO53483_3 | A0BE-40E0-81 | PO14761137153 | 19 | 284 | 548 | 408 | 6 | 2023-11-03 | 97.19 | 2.43 | 2023-10-22 | 2 | 35.96 | 1 | 97.19 | 3 | SO53483 | 2023-10-29 | 7.78 | 71.92 | 48.59 | |||
SO43662_10 | 2E53-4802-85 | PO18444174044 | 19 | 288 | 317 | 227 | 6 | 2021-09-02 | 874.79 | 21.87 | 2021-08-21 | 1 | 884.71 | 1 | 874.79 | 10 | SO43662 | 2021-08-28 | 69.98 | 884.71 | 874.79 | |||
SO51704_9 | 13FA-4729-A9 | PO17661178081 | 19 | 284 | 568 | 13 | 264 | 6 | 50.11 | 2023-10-03 | 334.06 | 7.10 | 2023-09-21 | 1 | 461.44 | 1 | 283.95 | 9 | SO51704 | 2023-09-28 | 22.72 | 461.44 | 334.06 | 0.15 |
SO53536_45 | 5C09-4051-92 | PO18299189909 | 19 | 291 | 214 | 118 | 6 | 2023-11-03 | 167.95 | 4.20 | 2023-10-22 | 8 | 13.09 | 1 | 167.95 | 45 | SO53536 | 2023-10-29 | 13.44 | 104.69 | 20.99 | |||
SO46064_7 | EC45-4C82-8B | PO11020129544 | 19 | 284 | 326 | 336 | 6 | 2022-07-03 | 1258.38 | 31.46 | 2022-06-21 | 3 | 413.15 | 1 | 1258.38 | 7 | SO46064 | 2022-06-28 | 100.67 | 1239.44 | 419.46 | |||
SO51832_37 | 475C-432F-B2 | PO4466177904 | 19 | 291 | 600 | 352 | 6 | 2023-10-03 | 971.98 | 24.30 | 2023-09-21 | 3 | 294.58 | 1 | 971.98 | 37 | SO51832 | 2023-09-28 | 77.76 | 883.74 | 323.99 | |||
SO47037_46 | C1AE-48A5-9F | PO4901170321 | 19 | 284 | 343 | 84 | 6 | 2022-10-03 | 4228.15 | 105.70 | 2022-09-21 | 9 | 486.71 | 1 | 4228.15 | 46 | SO47037 | 2022-09-28 | 338.25 | 4380.36 | 469.79 | |||
SO46959_13 | 9007-4F97-9C | PO16733197949 | 19 | 291 | 387 | 533 | 6 | 2022-10-03 | 1800.79 | 45.02 | 2022-09-21 | 3 | 605.65 | 1 | 1800.79 | 13 | SO46959 | 2022-09-28 | 144.06 | 1816.95 | 600.26 | |||
SO71851_30 | AABE-4443-91 | PO18299133687 | 19 | 291 | 475 | 118 | 6 | 2024-08-03 | 125.98 | 3.15 | 2024-07-22 | 3 | 26.18 | 1 | 125.98 | 30 | SO71851 | 2024-07-29 | 10.08 | 78.53 | 41.99 | |||
SO63132_16 | C9E0-492C-AA | PO18705140198 | 19 | 291 | 225 | 479 | 6 | 2024-04-04 | 32.36 | 0.81 | 2024-03-23 | 6 | 6.92 | 1 | 32.36 | 16 | SO63132 | 2024-03-30 | 2.59 | 41.53 | 5.39 | |||
SO46614_5 | 0B65-4374-89 | PO15312137226 | 19 | 291 | 236 | 299 | 6 | 2022-09-02 | 288.40 | 7.21 | 2022-08-21 | 10 | 29.08 | 1 | 288.40 | 5 | SO46614 | 2022-08-28 | 23.07 | 290.81 | 28.84 | |||
SO71806_13 | 26A7-4E95-9B | PO14790111844 | 19 | 291 | 598 | 497 | 6 | 2024-08-03 | 971.98 | 24.30 | 2024-07-22 | 3 | 294.58 | 1 | 971.98 | 13 | SO71806 | 2024-07-29 | 77.76 | 883.74 | 323.99 | |||
SO63178_1 | 63E5-40BB-9E | PO2117138284 | 19 | 284 | 474 | 444 | 6 | 2024-04-04 | 419.94 | 10.50 | 2024-03-23 | 10 | 26.18 | 1 | 419.94 | 1 | SO63178 | 2024-03-30 | 33.60 | 261.76 | 41.99 | |||
SO51793_3 | D763-4929-9B | PO18705168707 | 19 | 291 | 382 | 479 | 6 | 2023-10-03 | 2016.88 | 50.42 | 2023-09-21 | 3 | 713.08 | 1 | 2016.88 | 3 | SO51793 | 2023-09-28 | 161.35 | 2139.24 | 672.29 | |||
SO46645_16 | F857-4A6D-9C | PO1711132491 | 19 | 291 | 305 | 245 | 6 | 2022-09-02 | 2208.44 | 55.21 | 2022-08-21 | 3 | 653.70 | 1 | 2208.44 | 16 | SO46645 | 2022-08-28 | 176.67 | 1961.09 | 736.15 | |||
SO48072_4 | D4FC-4834-8F | PO6496174950 | 19 | 291 | 470 | 226 | 6 | 2023-01-03 | 136.76 | 3.42 | 2022-12-22 | 6 | 15.67 | 1 | 136.76 | 4 | SO48072 | 2022-12-29 | 10.94 | 94.03 | 22.79 | |||
SO49052_23 | 8769-409E-94 | PO16733182723 | 19 | 291 | 323 | 533 | 6 | 2023-04-05 | 3288.56 | 82.21 | 2023-03-24 | 7 | 486.71 | 1 | 3288.56 | 23 | SO49052 | 2023-03-31 | 263.08 | 3406.95 | 469.79 | |||
SO53484_15 | CEC0-499D-80 | PO14790120337 | 19 | 291 | 524 | 497 | 6 | 2023-11-03 | 316.86 | 7.92 | 2023-10-22 | 2 | 144.59 | 1 | 316.86 | 15 | SO53484 | 2023-10-29 | 25.35 | 289.19 | 158.43 | |||
SO44283_6 | D5FF-488D-B7 | PO18444150042 | 19 | 288 | 326 | 227 | 6 | 2021-12-03 | 2097.29 | 52.43 | 2021-11-21 | 5 | 413.15 | 1 | 2097.29 | 6 | SO44283 | 2021-11-28 | 167.78 | 2065.73 | 419.46 | |||
SO51124_38 | 5EEF-4271-BB | PO1711177181 | 19 | 291 | 531 | 245 | 6 | 2023-09-02 | 1049.12 | 26.23 | 2023-08-21 | 7 | 136.79 | 1 | 1049.12 | 38 | SO51124 | 2023-08-28 | 83.93 | 957.50 | 149.87 | |||
SO50699_9 | FEA0-4613-AE | PO1885169186 | 19 | 284 | 362 | 588 | 6 | 2023-08-03 | 2458.92 | 61.47 | 2023-07-22 | 2 | 1105.81 | 1 | 2458.92 | 9 | SO50699 | 2023-07-29 | 196.71 | 2211.62 | 1229.46 | |||
SO49848_5 | 31E6-4A3B-9C | PO1711148241 | 19 | 291 | 395 | 245 | 6 | 2023-06-03 | 490.99 | 12.27 | 2023-05-22 | 8 | 45.42 | 1 | 490.99 | 5 | SO49848 | 2023-05-29 | 39.28 | 363.33 | 61.37 | |||
SO43668_27 | 365D-4C9A-BE | PO14732180295 | 19 | 288 | 215 | 514 | 6 | 2021-09-02 | 20.19 | 0.50 | 2021-08-21 | 1 | 12.03 | 1 | 20.19 | 27 | SO43668 | 2021-08-28 | 1.61 | 12.03 | 20.19 | |||
SO51130_39 | F38F-411F-B2 | PO18473180006 | 19 | 291 | 558 | 442 | 6 | 2023-09-02 | 1700.96 | 42.52 | 2023-08-21 | 7 | 179.82 | 1 | 1700.96 | 39 | SO51130 | 2023-08-28 | 136.08 | 1258.71 | 242.99 | |||
SO51793_45 | D763-4929-9B | PO18705168707 | 19 | 291 | 490 | 479 | 6 | 2023-10-03 | 161.97 | 4.05 | 2023-09-21 | 5 | 41.57 | 1 | 161.97 | 45 | SO51793 | 2023-09-28 | 12.96 | 207.86 | 32.39 | |||
SO43662_18 | 2E53-4802-85 | PO18444174044 | 19 | 288 | 264 | 227 | 6 | 2021-09-02 | 183.94 | 4.60 | 2021-08-21 | 1 | 181.49 | 1 | 183.94 | 18 | SO43662 | 2021-08-28 | 14.72 | 181.49 | 183.94 | |||
SO46938_27 | 2E58-4440-89 | PO19198122384 | 19 | 291 | 394 | 653 | 6 | 2022-10-03 | 41.04 | 1.03 | 2022-09-21 | 2 | 15.18 | 1 | 41.04 | 27 | SO46938 | 2022-09-28 | 3.28 | 30.37 | 20.52 |
Generated 2024-09-20 10:42:11.653 UTC