[ROOT] dt FactResellerSale < WHERE DimSalesTerritoryId EQ '6' > SHUFFLE < SKIP 821 > < 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 |
---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
SO71830_34 | DA2D-4B00-A4 | PO10875112195 | 19 | 291 | 231 | 281 | 6 | 2024-09-27 | 119.98 | 3.00 | 2024-09-15 | 4 | 38.49 | 1 | 119.98 | 34 | SO71830 | 2024-09-22 | 9.60 | 153.97 | 29.99 | |||
SO55275_34 | 72C3-4048-BC | PO1711122362 | 19 | 291 | 556 | 245 | 6 | 2024-01-27 | 315.88 | 7.90 | 2024-01-15 | 3 | 77.92 | 1 | 315.88 | 34 | SO55275 | 2024-01-22 | 25.27 | 233.75 | 105.29 | |||
SO48023_1 | 18BD-4FA3-9F | PO11020197101 | 19 | 284 | 325 | 336 | 6 | 2023-02-27 | 469.79 | 11.74 | 2023-02-15 | 1 | 486.71 | 1 | 469.79 | 1 | SO48023 | 2023-02-22 | 37.58 | 486.71 | 469.79 | |||
SO46333_8 | B042-408B-A8 | PO17545158984 | 19 | 288 | 215 | 155 | 6 | 2022-09-27 | 80.75 | 2.02 | 2022-09-15 | 4 | 12.03 | 1 | 80.75 | 8 | SO46333 | 2022-09-22 | 6.46 | 48.11 | 20.19 | |||
SO63177_2 | 87AD-4113-AD | PO1856115383 | 19 | 291 | 502 | 263 | 6 | 2024-05-29 | 400.10 | 10.00 | 2024-05-17 | 2 | 199.85 | 1 | 400.10 | 2 | SO63177 | 2024-05-24 | 32.01 | 399.70 | 200.05 | |||
SO46940_35 | 6ADC-4363-B3 | PO18705126181 | 19 | 291 | 415 | 479 | 6 | 2022-11-27 | 396.07 | 9.90 | 2022-11-15 | 2 | 146.55 | 1 | 396.07 | 35 | SO46940 | 2022-11-22 | 31.69 | 293.09 | 198.04 | |||
SO47663_23 | 1B17-4C63-B6 | PO18444192283 | 19 | 291 | 415 | 227 | 6 | 2023-01-27 | 792.14 | 19.80 | 2023-01-15 | 4 | 146.55 | 1 | 792.14 | 23 | SO47663 | 2023-01-22 | 63.37 | 586.19 | 198.04 | |||
SO58980_24 | 8985-4B66-AD | PO18502175539 | 19 | 291 | 490 | 154 | 6 | 2024-03-28 | 64.79 | 1.62 | 2024-03-16 | 2 | 41.57 | 1 | 64.79 | 24 | SO58980 | 2024-03-23 | 5.18 | 83.14 | 32.39 | |||
SO63136_7 | 0873-484A-AE | PO18328125904 | 19 | 284 | 606 | 552 | 6 | 2024-05-29 | 323.99 | 8.10 | 2024-05-17 | 1 | 343.65 | 1 | 323.99 | 7 | SO63136 | 2024-05-24 | 25.92 | 343.65 | 323.99 | |||
SO44086_6 | B4B4-44C7-84 | PO17574175064 | 19 | 288 | 349 | 678 | 6 | 2021-12-28 | 10124.97 | 253.12 | 2021-12-16 | 5 | 1898.09 | 1 | 10124.97 | 6 | SO44086 | 2021-12-23 | 810.00 | 9490.47 | 2024.99 | |||
SO50698_14 | 304A-4672-BA | PO1798139213 | 19 | 291 | 469 | 10 | 6 | 2023-09-27 | 205.15 | 5.13 | 2023-09-15 | 9 | 15.67 | 1 | 205.15 | 14 | SO50698 | 2023-09-22 | 16.41 | 141.04 | 22.79 | |||
SO51769_21 | 4AAC-4066-A6 | PO1595126190 | 19 | 284 | 374 | 426 | 6 | 2023-11-27 | 2932.02 | 73.30 | 2023-11-15 | 2 | 1554.95 | 1 | 2932.02 | 21 | SO51769 | 2023-11-22 | 234.56 | 3109.90 | 1466.01 | |||
SO50698_17 | 304A-4672-BA | PO1798139213 | 19 | 291 | 352 | 10 | 6 | 2023-09-27 | 2485.70 | 62.14 | 2023-09-15 | 2 | 1117.86 | 1 | 2485.70 | 17 | SO50698 | 2023-09-22 | 198.86 | 2235.71 | 1242.85 | |||
SO49827_19 | E4F0-4B91-84 | PO15312199090 | 19 | 291 | 373 | 299 | 6 | 2023-07-28 | 3926.81 | 98.17 | 2023-07-16 | 3 | 1320.68 | 1 | 3926.81 | 19 | SO49827 | 2023-07-23 | 314.15 | 3962.05 | 1308.94 | |||
SO47357_4 | 3E93-4357-9B | PO18531126368 | 19 | 284 | 356 | 613 | 6 | 2022-12-28 | 3728.56 | 93.21 | 2022-12-16 | 3 | 1117.86 | 1 | 3728.56 | 4 | SO47357 | 2022-12-23 | 298.28 | 3353.57 | 1242.85 | |||
SO69478_24 | E63C-4ABF-83 | PO18705185140 | 19 | 291 | 482 | 479 | 6 | 2024-08-27 | 16.18 | 0.40 | 2024-08-15 | 3 | 3.36 | 1 | 16.18 | 24 | SO69478 | 2024-08-22 | 1.29 | 10.09 | 5.39 | |||
SO48036_32 | AB80-4ACE-AF | PO1914139946 | 19 | 284 | 460 | 66 | 6 | 2023-02-27 | 161.98 | 4.05 | 2023-02-15 | 3 | 37.12 | 1 | 161.98 | 32 | SO48036 | 2023-02-22 | 12.96 | 111.36 | 53.99 | |||
SO47015_21 | 853D-4913-A7 | PO2117171072 | 19 | 284 | 468 | 444 | 6 | 2022-11-27 | 91.18 | 2.28 | 2022-11-15 | 4 | 15.67 | 1 | 91.18 | 21 | SO47015 | 2022-11-22 | 7.29 | 62.68 | 22.79 | |||
SO49140_20 | EFF3-483D-BE | PO4901154744 | 19 | 284 | 459 | 84 | 6 | 2023-05-30 | 269.97 | 6.75 | 2023-05-18 | 5 | 37.12 | 1 | 269.97 | 20 | SO49140 | 2023-05-25 | 21.60 | 185.60 | 53.99 | |||
SO47380_26 | EF71-4036-91 | PO14790123967 | 19 | 291 | 213 | 497 | 6 | 2022-12-28 | 80.75 | 2.02 | 2022-12-16 | 4 | 13.88 | 1 | 80.75 | 26 | SO47380 | 2022-12-23 | 6.46 | 55.51 | 20.19 | |||
SO48754_36 | FC6A-4A9E-83 | PO18473150383 | 19 | 291 | 460 | 442 | 6 | 2023-04-29 | 161.98 | 4.05 | 2023-04-17 | 3 | 37.12 | 1 | 161.98 | 36 | SO48754 | 2023-04-24 | 12.96 | 111.36 | 53.99 | |||
SO47359_4 | 8BC9-458A-82 | PO18299145297 | 19 | 291 | 470 | 2 | 118 | 6 | 4.85 | 2022-12-28 | 242.38 | 5.94 | 2022-12-16 | 11 | 15.67 | 1 | 237.53 | 4 | SO47359 | 2022-12-23 | 19.00 | 172.38 | 22.03 | 0.02 |
SO67270_4 | 685A-440D-8C | PO14732111382 | 19 | 291 | 546 | 514 | 6 | 2024-07-28 | 149.02 | 3.73 | 2024-07-16 | 4 | 27.57 | 1 | 149.02 | 4 | SO67270 | 2024-07-23 | 11.92 | 110.27 | 37.25 | |||
SO46657_23 | CA71-4EDF-A1 | PO4495116659 | 19 | 291 | 236 | 496 | 6 | 2022-10-27 | 86.52 | 2.16 | 2022-10-15 | 3 | 29.08 | 1 | 86.52 | 23 | SO46657 | 2022-10-22 | 6.92 | 87.24 | 28.84 | |||
SO48331_1 | CF29-4690-9A | PO12876158230 | 19 | 284 | 371 | 300 | 6 | 2023-03-29 | 1308.94 | 32.72 | 2023-03-17 | 1 | 1320.68 | 1 | 1308.94 | 1 | SO48331 | 2023-03-24 | 104.72 | 1320.68 | 1308.94 | |||
SO49085_25 | 7265-4D98-80 | PO19198152404 | 19 | 291 | 470 | 653 | 6 | 2023-05-30 | 68.38 | 1.71 | 2023-05-18 | 3 | 15.67 | 1 | 68.38 | 25 | SO49085 | 2023-05-25 | 5.47 | 47.01 | 22.79 | |||
SO48750_42 | 9A71-449E-B6 | PO14732147398 | 19 | 291 | 464 | 514 | 6 | 2023-04-29 | 42.39 | 1.06 | 2023-04-17 | 3 | 9.71 | 1 | 42.39 | 42 | SO48750 | 2023-04-24 | 3.39 | 29.14 | 14.13 | |||
SO51793_33 | D763-4929-9B | PO18705168707 | 19 | 291 | 520 | 479 | 6 | 2023-11-27 | 63.17 | 1.58 | 2023-11-15 | 2 | 23.37 | 1 | 63.17 | 33 | SO51793 | 2023-11-22 | 5.05 | 46.74 | 31.58 | |||
SO47988_2 | 3979-4615-A9 | PO16733190266 | 19 | 291 | 381 | 533 | 6 | 2023-02-27 | 2401.05 | 60.03 | 2023-02-15 | 4 | 605.65 | 1 | 2401.05 | 2 | SO47988 | 2023-02-22 | 192.08 | 2422.60 | 600.26 | |||
SO47354_28 | 6E1C-48C6-89 | PO19401144959 | 19 | 291 | 263 | 173 | 6 | 2022-12-28 | 607.00 | 15.17 | 2022-12-16 | 3 | 187.16 | 1 | 607.00 | 28 | SO47354 | 2022-12-23 | 48.56 | 561.47 | 202.33 |
Generated 2024-11-14 08:08:57.219 UTC