[ROOT] dt FactResellerSale < WHERE DimSalesTerritoryId EQ '4' > SHUFFLE < SKIP 2574 > < 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 |
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
| SO49523_20 | 852E-47A8-A9 | PO3915144057 | 100 | 281 | 435 | 130 | 4 | 2023-06-27 | 324.45 | 8.11 | 2023-06-15 | 1 | 300.12 | 1 | 324.45 | 20 | SO49523 | 2023-06-22 | 25.96 | 300.12 | 324.45 | |||
| SO58979_11 | A35B-403A-A4 | PO18038174164 | 100 | 287 | 501 | 509 | 4 | 2024-03-28 | 145.75 | 3.64 | 2024-03-16 | 2 | 53.93 | 1 | 145.75 | 11 | SO58979 | 2024-03-23 | 11.66 | 107.86 | 72.88 | |||
| SO57131_8 | 635E-4BF2-B9 | PO4611148036 | 100 | 287 | 558 | 131 | 4 | 2024-02-27 | 242.99 | 6.07 | 2024-02-15 | 1 | 179.82 | 1 | 242.99 | 8 | SO57131 | 2024-02-22 | 19.44 | 179.82 | 242.99 | |||
| SO51855_33 | 8551-4CDF-A1 | PO3480115731 | 100 | 281 | 382 | 436 | 4 | 2023-11-27 | 2016.88 | 50.42 | 2023-11-15 | 3 | 713.08 | 1 | 2016.88 | 33 | SO51855 | 2023-11-22 | 161.35 | 2139.24 | 672.29 | |||
| SO46342_3 | 9BA4-4F6E-96 | PO14964115309 | 100 | 287 | 344 | 7 | 581 | 4 | 1487.50 | 2022-09-27 | 4249.99 | 69.06 | 2022-09-15 | 5 | 1912.15 | 1 | 2762.49 | 3 | SO46342 | 2022-09-22 | 221.00 | 9560.77 | 850.00 | 0.35 |
| SO67305_44 | CBB5-42BF-9E | PO16298111473 | 100 | 287 | 490 | 2 | 599 | 4 | 7.52 | 2024-07-28 | 375.77 | 9.21 | 2024-07-16 | 12 | 41.57 | 1 | 368.26 | 44 | SO67305 | 2024-07-23 | 29.46 | 498.87 | 31.31 | 0.02 |
| SO50672_3 | 1BE9-437C-8A | PO16472110144 | 100 | 287 | 454 | 239 | 4 | 2023-09-27 | 143.98 | 3.60 | 2023-09-15 | 4 | 24.75 | 1 | 143.98 | 3 | SO50672 | 2023-09-22 | 11.52 | 98.98 | 35.99 | |||
| SO46988_10 | 2D2E-4EC3-AC | PO12499171502 | 100 | 282 | 457 | 78 | 4 | 2022-11-27 | 269.96 | 6.75 | 2022-11-15 | 6 | 30.93 | 1 | 269.96 | 10 | SO46988 | 2022-11-22 | 21.60 | 185.60 | 44.99 | |||
| SO51102_33 | F2B1-4561-84 | PO13659193365 | 100 | 287 | 298 | 437 | 4 | 2023-10-27 | 809.76 | 20.24 | 2023-10-15 | 1 | 739.04 | 1 | 809.76 | 33 | SO51102 | 2023-10-22 | 64.78 | 739.04 | 809.76 | |||
| SO43678_5 | FBD8-4CE4-8B | PO10817150168 | 100 | 287 | 326 | 203 | 4 | 2021-10-27 | 1258.38 | 31.46 | 2021-10-15 | 3 | 413.15 | 1 | 1258.38 | 5 | SO43678 | 2021-10-22 | 100.67 | 1239.44 | 419.46 | |||
| SO65315_12 | 0FFB-4EB5-A3 | PO6757194680 | 100 | 281 | 295 | 21 | 4 | 2024-06-27 | 2456.10 | 61.40 | 2024-06-15 | 3 | 747.20 | 1 | 2456.10 | 12 | SO65315 | 2024-06-22 | 196.49 | 2241.60 | 818.70 | |||
| SO65303_30 | 93EA-4158-A9 | PO5539133147 | 100 | 282 | 363 | 61 | 4 | 2024-06-27 | 9638.96 | 240.97 | 2024-06-15 | 7 | 1251.98 | 1 | 9638.96 | 30 | SO65303 | 2024-06-22 | 771.12 | 8763.87 | 1376.99 | |||
| SO47425_3 | E539-44F6-AA | PO4002163465 | 100 | 282 | 221 | 674 | 4 | 2022-12-28 | 80.75 | 2.02 | 2022-12-16 | 4 | 13.88 | 1 | 80.75 | 3 | SO47425 | 2022-12-23 | 6.46 | 55.51 | 20.19 | |||
| SO71882_14 | D5D4-42D4-91 | PO5597123008 | 100 | 281 | 476 | 75 | 4 | 2024-09-27 | 125.98 | 3.15 | 2024-09-15 | 3 | 26.18 | 1 | 125.98 | 14 | SO71882 | 2024-09-22 | 10.08 | 78.53 | 41.99 | |||
| SO50289_13 | 0809-4DE4-93 | PO3480117331 | 100 | 281 | 379 | 436 | 4 | 2023-08-27 | 5235.75 | 130.89 | 2023-08-15 | 4 | 1320.68 | 1 | 5235.75 | 13 | SO50289 | 2023-08-22 | 418.86 | 5282.74 | 1308.94 | |||
| SO47994_8 | 284B-45A1-94 | PO15196121630 | 100 | 282 | 337 | 258 | 4 | 2023-02-27 | 1409.38 | 35.23 | 2023-02-15 | 3 | 486.71 | 1 | 1409.38 | 8 | SO47994 | 2023-02-22 | 112.75 | 1460.12 | 469.79 | |||
| SO57168_21 | B6D5-41ED-B9 | PO3480129742 | 100 | 281 | 584 | 436 | 4 | 2024-02-27 | 971.98 | 24.30 | 2024-02-15 | 3 | 343.65 | 1 | 971.98 | 21 | SO57168 | 2024-02-22 | 77.76 | 1030.95 | 323.99 | |||
| SO55282_22 | A72A-4D3A-BA | PO16298125578 | 100 | 287 | 496 | 599 | 4 | 2024-01-27 | 1204.69 | 30.12 | 2024-01-15 | 2 | 601.74 | 1 | 1204.69 | 22 | SO55282 | 2024-01-22 | 96.38 | 1203.49 | 602.35 | |||
| SO53606_36 | 6A19-463C-B7 | PO5539128997 | 100 | 282 | 353 | 61 | 4 | 2023-12-28 | 5567.98 | 139.20 | 2023-12-16 | 4 | 1265.62 | 1 | 5567.98 | 36 | SO53606 | 2023-12-23 | 445.44 | 5062.48 | 1391.99 | |||
| SO48378_23 | 2FD7-4721-9D | PO6786131738 | 100 | 283 | 462 | 3 | 4 | 2023-03-29 | 28.26 | 0.71 | 2023-03-17 | 2 | 9.71 | 1 | 28.26 | 23 | SO48378 | 2023-03-24 | 2.26 | 19.43 | 14.13 | |||
| SO71889_24 | 79BB-4639-B8 | PO6786144643 | 100 | 281 | 583 | 3 | 4 | 2024-09-27 | 5102.97 | 127.57 | 2024-09-15 | 5 | 1082.51 | 1 | 5102.97 | 24 | SO71889 | 2024-09-22 | 408.24 | 5412.55 | 1020.59 | |||
| SO69509_20 | 3683-45BF-B7 | PO4611111760 | 100 | 287 | 555 | 131 | 4 | 2024-08-27 | 127.80 | 3.20 | 2024-08-15 | 2 | 47.29 | 1 | 127.80 | 20 | SO69509 | 2024-08-22 | 10.22 | 94.57 | 63.90 | |||
| SO53616_8 | A692-4827-93 | PO6786150961 | 100 | 281 | 231 | 2 | 3 | 4 | 6.96 | 2023-12-28 | 347.93 | 8.52 | 2023-12-16 | 12 | 38.49 | 1 | 340.97 | 8 | SO53616 | 2023-12-23 | 27.28 | 461.91 | 28.99 | 0.02 |
| SO50249_5 | 72CA-4901-8D | PO2320117235 | 100 | 282 | 375 | 529 | 4 | 2023-08-27 | 1308.94 | 32.72 | 2023-08-15 | 1 | 1320.68 | 1 | 1308.94 | 5 | SO50249 | 2023-08-22 | 104.72 | 1320.68 | 1308.94 | |||
| SO65183_9 | 4E49-448C-93 | PO16269127603 | 100 | 287 | 582 | 624 | 4 | 2024-06-27 | 4082.38 | 102.06 | 2024-06-15 | 4 | 1082.51 | 1 | 4082.38 | 9 | SO65183 | 2024-06-22 | 326.59 | 4330.04 | 1020.59 | |||
| SO55256_7 | 686E-4D36-8B | PO12528136439 | 100 | 282 | 578 | 331 | 4 | 2024-01-27 | 1457.82 | 36.45 | 2024-01-15 | 2 | 755.15 | 1 | 1457.82 | 7 | SO55256 | 2024-01-22 | 116.63 | 1510.30 | 728.91 | |||
| SO49890_24 | 9B22-4240-83 | PO7859114282 | 100 | 272 | 325 | 221 | 4 | 2023-07-28 | 939.59 | 23.49 | 2023-07-16 | 2 | 486.71 | 1 | 939.59 | 24 | SO49890 | 2023-07-23 | 75.17 | 973.41 | 469.79 | |||
| SO51122_10 | D915-4225-97 | PO551181465 | 100 | 281 | 372 | 4 | 4 | 2023-10-27 | 2932.02 | 73.30 | 2023-10-15 | 2 | 1554.95 | 1 | 2932.02 | 10 | SO51122 | 2023-10-22 | 234.56 | 3109.90 | 1466.01 | |||
| SO57145_13 | 4C59-4193-B1 | PO3654153385 | 100 | 281 | 501 | 435 | 4 | 2024-02-27 | 72.88 | 1.82 | 2024-02-15 | 1 | 53.93 | 1 | 72.88 | 13 | SO57145 | 2024-02-22 | 5.83 | 53.93 | 72.88 | |||
| SO43680_15 | FF1F-4DD0-98 | PO10730130087 | 100 | 287 | 328 | 491 | 4 | 2021-10-27 | 419.46 | 10.49 | 2021-10-15 | 1 | 413.15 | 1 | 419.46 | 15 | SO43680 | 2021-10-22 | 33.56 | 413.15 | 419.46 |
Generated 2024-11-14 05:32:43.881 UTC