[ROOT] dt FactResellerSale < WHERE DimSalesTerritoryId EQ '4' > SHUFFLE SKIP 2298 < SKIP 938 > < 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 |
---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
SO49821_22 | 0B9B-460C-BC | PO551117366 | 100 | 281 | 383 | 4 | 4 | 2023-07-28 | 2401.05 | 60.03 | 2023-07-16 | 4 | 605.65 | 1 | 2401.05 | 22 | SO49821 | 2023-07-23 | 192.08 | 2422.60 | 600.26 | |||
SO61184_37 | F33C-4C57-BD | PO16298116527 | 100 | 287 | 465 | 599 | 4 | 2024-04-28 | 88.16 | 2.20 | 2024-04-16 | 6 | 9.16 | 1 | 88.16 | 37 | SO61184 | 2024-04-23 | 7.05 | 54.96 | 14.69 | |||
SO65303_11 | 93EA-4158-A9 | PO5539133147 | 100 | 282 | 474 | 61 | 4 | 2024-06-27 | 167.98 | 4.20 | 2024-06-15 | 4 | 26.18 | 1 | 167.98 | 11 | SO65303 | 2024-06-22 | 13.44 | 104.71 | 41.99 | |||
SO49890_19 | 9B22-4240-83 | PO7859114282 | 100 | 272 | 236 | 221 | 4 | 2023-07-28 | 86.52 | 2.16 | 2023-07-16 | 3 | 29.08 | 1 | 86.52 | 19 | SO49890 | 2023-07-23 | 6.92 | 87.24 | 28.84 | |||
SO47028_32 | 8DA0-456D-8F | PO3799132728 | 100 | 282 | 360 | 312 | 4 | 2022-11-27 | 2458.92 | 61.47 | 2022-11-15 | 2 | 1105.81 | 1 | 2458.92 | 32 | SO47028 | 2022-11-22 | 196.71 | 2211.62 | 1229.46 | |||
SO46093_8 | B221-4D2A-99 | PO6351171482 | 100 | 283 | 322 | 255 | 4 | 2022-08-27 | 1258.38 | 31.46 | 2022-08-15 | 3 | 413.15 | 1 | 1258.38 | 8 | SO46093 | 2022-08-22 | 100.67 | 1239.44 | 419.46 | |||
SO49063_2 | 3E8C-4275-B6 | PO609128703 | 100 | 282 | 470 | 492 | 4 | 2023-05-30 | 91.18 | 2.28 | 2023-05-18 | 4 | 15.67 | 1 | 91.18 | 2 | SO49063 | 2023-05-25 | 7.29 | 62.68 | 22.79 | |||
SO49851_26 | 14FB-4B97-95 | PO2494142030 | 100 | 281 | 427 | 184 | 4 | 2023-07-28 | 627.77 | 15.69 | 2023-07-16 | 3 | 185.82 | 1 | 627.77 | 26 | SO49851 | 2023-07-23 | 50.22 | 557.46 | 209.26 | |||
SO49540_8 | FD60-4F29-B7 | PO6757123714 | 100 | 281 | 469 | 21 | 4 | 2023-06-27 | 22.79 | 0.57 | 2023-06-15 | 1 | 15.67 | 1 | 22.79 | 8 | SO49540 | 2023-06-22 | 1.82 | 15.67 | 22.79 | |||
SO44113_11 | B9C7-4334-81 | PO2697181021 | 100 | 282 | 296 | 187 | 4 | 2021-12-28 | 714.70 | 17.87 | 2021-12-16 | 1 | 617.03 | 1 | 714.70 | 11 | SO44113 | 2021-12-23 | 57.18 | 617.03 | 714.70 | |||
SO69412_18 | 14B1-47FE-BF | PO15689112657 | 100 | 281 | 583 | 328 | 4 | 2024-08-27 | 7144.16 | 178.60 | 2024-08-15 | 7 | 1082.51 | 1 | 7144.16 | 18 | SO69412 | 2024-08-22 | 571.53 | 7577.57 | 1020.59 | |||
SO49533_17 | 5895-4BD4-A3 | PO5597155395 | 100 | 281 | 352 | 75 | 4 | 2023-06-27 | 6214.26 | 155.36 | 2023-06-15 | 5 | 1117.86 | 1 | 6214.26 | 17 | SO49533 | 2023-06-22 | 497.14 | 5589.28 | 1242.85 | |||
SO53606_34 | 6A19-463C-B7 | PO5539128997 | 100 | 282 | 309 | 61 | 4 | 2023-12-28 | 3274.80 | 81.87 | 2023-12-16 | 4 | 747.20 | 1 | 3274.80 | 34 | SO53606 | 2023-12-23 | 261.98 | 2988.80 | 818.70 | |||
SO44127_12 | E778-471D-8A | PO7569162058 | 100 | 287 | 348 | 608 | 4 | 2021-12-28 | 12149.96 | 303.75 | 2021-12-16 | 6 | 1898.09 | 1 | 12149.96 | 12 | SO44127 | 2021-12-23 | 972.00 | 11388.57 | 2024.99 | |||
SO46625_28 | 361B-4CAF-A2 | PO13688113829 | 100 | 282 | 445 | 475 | 4 | 2022-10-27 | 143.98 | 3.60 | 2022-10-15 | 4 | 24.75 | 1 | 143.98 | 28 | SO46625 | 2022-10-22 | 11.52 | 98.98 | 35.99 | |||
SO50289_5 | 0809-4DE4-93 | PO3480117331 | 100 | 281 | 458 | 436 | 4 | 2023-08-27 | 89.99 | 2.25 | 2023-08-15 | 2 | 30.93 | 1 | 89.99 | 5 | SO50289 | 2023-08-22 | 7.20 | 61.87 | 44.99 | |||
SO48375_39 | B5F1-4C2A-94 | PO5597156214 | 100 | 283 | 459 | 75 | 4 | 2023-03-29 | 107.99 | 2.70 | 2023-03-17 | 2 | 37.12 | 1 | 107.99 | 39 | SO48375 | 2023-03-24 | 8.64 | 74.24 | 53.99 | |||
SO46089_11 | 5E3C-4A0D-BD | PO5684142532 | 100 | 282 | 235 | 385 | 4 | 2022-08-27 | 86.52 | 2.16 | 2022-08-15 | 3 | 31.72 | 1 | 86.52 | 11 | SO46089 | 2022-08-22 | 6.92 | 95.17 | 28.84 | |||
SO49146_1 | 273A-4635-9D | PO5684148238 | 100 | 282 | 420 | 385 | 4 | 2023-05-30 | 566.46 | 14.16 | 2023-05-18 | 4 | 104.80 | 1 | 566.46 | 1 | SO49146 | 2023-05-25 | 45.32 | 419.18 | 141.62 | |||
SO51722_12 | 735D-4C32-A1 | PO15196144426 | 100 | 282 | 482 | 258 | 4 | 2023-11-27 | 16.18 | 0.40 | 2023-11-15 | 3 | 3.36 | 1 | 16.18 | 12 | SO51722 | 2023-11-22 | 1.29 | 10.09 | 5.39 | |||
SO47435_3 | B7A7-4F07-94 | PO5597154214 | 100 | 283 | 367 | 75 | 4 | 2022-12-28 | 2591.98 | 64.80 | 2022-12-16 | 4 | 598.44 | 1 | 2591.98 | 3 | SO47435 | 2022-12-23 | 207.36 | 2393.74 | 647.99 | |||
SO48370_5 | 2BBA-46FF-BD | PO4640118571 | 100 | 287 | 308 | 648 | 4 | 2023-03-29 | 744.27 | 18.61 | 2023-03-17 | 1 | 660.91 | 1 | 744.27 | 5 | SO48370 | 2023-03-24 | 59.54 | 660.91 | 744.27 | |||
SO57034_3 | 57D0-46D3-B7 | PO15689142548 | 100 | 281 | 583 | 328 | 4 | 2024-02-27 | 3061.78 | 76.54 | 2024-02-15 | 3 | 1082.51 | 1 | 3061.78 | 3 | SO57034 | 2024-02-22 | 244.94 | 3247.53 | 1020.59 | |||
SO46076_22 | E898-4203-B0 | PO2523131751 | 100 | 287 | 310 | 167 | 4 | 2022-08-27 | 8587.85 | 214.70 | 2022-08-15 | 4 | 2171.29 | 1 | 8587.85 | 22 | SO46076 | 2022-08-22 | 687.03 | 8685.18 | 2146.96 | |||
SO47720_34 | 30D0-4EF0-B1 | PO7859164121 | 100 | 287 | 422 | 221 | 4 | 2023-01-27 | 270.16 | 6.75 | 2023-01-15 | 4 | 49.98 | 1 | 270.16 | 34 | SO47720 | 2023-01-22 | 21.61 | 199.92 | 67.54 | |||
SO67305_35 | CBB5-42BF-9E | PO16298111473 | 100 | 287 | 496 | 599 | 4 | 2024-07-28 | 6023.46 | 150.59 | 2024-07-16 | 10 | 601.74 | 1 | 6023.46 | 35 | SO67305 | 2024-07-23 | 481.88 | 6017.44 | 602.35 | |||
SO57035_1 | CD56-4460-9B | PO15921199440 | 100 | 287 | 546 | 77 | 4 | 2024-02-27 | 74.51 | 1.86 | 2024-02-15 | 2 | 27.57 | 1 | 74.51 | 1 | SO57035 | 2024-02-22 | 5.96 | 55.14 | 37.25 | |||
SO49890_8 | 9B22-4240-83 | PO7859114282 | 100 | 272 | 213 | 3 | 221 | 4 | 13.88 | 2023-07-28 | 277.56 | 6.59 | 2023-07-16 | 15 | 13.88 | 1 | 263.69 | 8 | SO49890 | 2023-07-23 | 21.09 | 208.17 | 18.50 | 0.05 |
SO67305_40 | CBB5-42BF-9E | PO16298111473 | 100 | 287 | 573 | 599 | 4 | 2024-07-28 | 14304.42 | 357.61 | 2024-07-16 | 10 | 1481.94 | 1 | 14304.42 | 40 | SO67305 | 2024-07-23 | 1144.35 | 14819.38 | 1430.44 | |||
SO65303_28 | 93EA-4158-A9 | PO5539133147 | 100 | 282 | 588 | 61 | 4 | 2024-06-27 | 2308.47 | 57.71 | 2024-06-15 | 5 | 419.78 | 1 | 2308.47 | 28 | SO65303 | 2024-06-22 | 184.68 | 2098.89 | 461.69 | |||
SO49127_20 | 01A1-43AB-A2 | PO3480145572 | 100 | 272 | 335 | 436 | 4 | 2023-05-30 | 2348.97 | 58.72 | 2023-05-18 | 5 | 486.71 | 1 | 2348.97 | 20 | SO49127 | 2023-05-25 | 187.92 | 2433.53 | 469.79 |
Generated 2024-11-14 07:35:38.681 UTC