[ROOT] dt FactResellerSale < WHERE DimSalesTerritoryId EQ '7' > SKIP 0 SHUFFLE < SKIP 906 > < 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 |
---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
SO48005_7 | 634C-42C5-AB | PO13427183371 | 100 | 292 | 331 | 638 | 7 | 2023-02-23 | 2348.97 | 58.72 | 2023-02-11 | 5 | 486.71 | 1 | 2348.97 | 7 | SO48005 | 2023-02-18 | 187.92 | 2433.53 | 469.79 | |||
SO48005_33 | 634C-42C5-AB | PO13427183371 | 100 | 292 | 454 | 638 | 7 | 2023-02-23 | 179.97 | 4.50 | 2023-02-11 | 5 | 24.75 | 1 | 179.97 | 33 | SO48005 | 2023-02-18 | 14.40 | 123.73 | 35.99 | |||
SO69429_7 | 3A09-48B2-AA | PO13369166572 | 100 | 292 | 378 | 391 | 7 | 2024-08-23 | 4398.03 | 109.95 | 2024-08-11 | 3 | 1554.95 | 1 | 4398.03 | 7 | SO69429 | 2024-08-18 | 351.84 | 4664.84 | 1466.01 | |||
SO63282_7 | F7EE-4F12-B1 | PO3567146912 | 100 | 292 | 579 | 193 | 7 | 2024-05-25 | 3644.55 | 91.11 | 2024-05-13 | 5 | 755.15 | 1 | 3644.55 | 7 | SO63282 | 2024-05-20 | 291.56 | 3775.75 | 728.91 | |||
SO57061_56 | C48C-4776-A7 | PO12702183787 | 100 | 292 | 516 | 175 | 7 | 2024-02-23 | 117.42 | 2.94 | 2024-02-11 | 5 | 17.38 | 1 | 117.42 | 56 | SO57061 | 2024-02-18 | 9.39 | 86.89 | 23.48 | |||
SO53478_36 | 6005-4C44-A8 | PO15486115045 | 100 | 292 | 400 | 121 | 7 | 2023-12-24 | 74.30 | 1.86 | 2023-12-12 | 2 | 27.49 | 1 | 74.30 | 36 | SO53478 | 2023-12-19 | 5.94 | 54.99 | 37.15 | |||
SO57068_7 | 0E44-4044-B3 | PO11223190191 | 100 | 292 | 517 | 632 | 7 | 2024-02-23 | 31.58 | 0.79 | 2024-02-11 | 1 | 23.37 | 1 | 31.58 | 7 | SO57068 | 2024-02-18 | 2.53 | 23.37 | 31.58 | |||
SO57143_28 | 69ED-4172-83 | PO3567189986 | 100 | 292 | 560 | 2 | 193 | 7 | 155.01 | 2024-02-23 | 7750.74 | 189.89 | 2024-02-11 | 11 | 755.15 | 1 | 7595.73 | 28 | SO57143 | 2024-02-18 | 607.66 | 8306.66 | 704.61 | 0.02 |
SO63217_3 | 4893-4FE9-B2 | PO13108196385 | 100 | 292 | 573 | 103 | 7 | 2024-05-25 | 4291.33 | 107.28 | 2024-05-13 | 3 | 1481.94 | 1 | 4291.33 | 3 | SO63217 | 2024-05-20 | 343.31 | 4445.81 | 1430.44 | |||
SO71820_7 | D332-4AF2-A3 | PO12673129941 | 100 | 292 | 374 | 499 | 7 | 2024-09-23 | 7330.05 | 183.25 | 2024-09-11 | 5 | 1554.95 | 1 | 7330.05 | 7 | SO71820 | 2024-09-18 | 586.40 | 7774.74 | 1466.01 | |||
SO53523_1 | F9D7-4438-8C | PO1450197859 | 100 | 292 | 474 | 571 | 7 | 2023-12-24 | 167.98 | 4.20 | 2023-12-12 | 4 | 26.18 | 1 | 167.98 | 1 | SO53523 | 2023-12-19 | 13.44 | 104.71 | 41.99 | |||
SO57054_1 | 8D1A-4AF0-91 | PO13456189029 | 36 | 292 | 568 | 614 | 7 | 2024-02-23 | 1336.23 | 33.41 | 2024-02-11 | 3 | 461.44 | 1 | 1336.23 | 1 | SO57054 | 2024-02-18 | 106.90 | 1384.33 | 445.41 | |||
SO58926_4 | B82A-4380-9C | PO15486118845 | 100 | 292 | 601 | 121 | 7 | 2024-03-24 | 32.39 | 0.81 | 2024-03-12 | 1 | 23.97 | 1 | 32.39 | 4 | SO58926 | 2024-03-19 | 2.59 | 23.97 | 32.39 | |||
SO63161_2 | C577-47A3-88 | PO12731197186 | 36 | 290 | 474 | 247 | 7 | 2024-05-25 | 167.98 | 4.20 | 2024-05-13 | 4 | 26.18 | 1 | 167.98 | 2 | SO63161 | 2024-05-20 | 13.44 | 104.71 | 41.99 | |||
SO67275_2 | 9BA9-48CF-B1 | PO13514118901 | 100 | 292 | 596 | 337 | 7 | 2024-07-24 | 323.99 | 8.10 | 2024-07-12 | 1 | 294.58 | 1 | 323.99 | 2 | SO67275 | 2024-07-19 | 25.92 | 294.58 | 323.99 | |||
SO51168_28 | 10E0-426C-9D | PO3509110394 | 36 | 292 | 231 | 139 | 7 | 2023-10-23 | 179.96 | 4.50 | 2023-10-11 | 6 | 38.49 | 1 | 179.96 | 28 | SO51168 | 2023-10-18 | 14.40 | 230.95 | 29.99 | |||
SO69531_28 | 1871-4E54-BE | PO3683141039 | 100 | 292 | 570 | 85 | 7 | 2024-08-23 | 4454.10 | 111.35 | 2024-08-11 | 10 | 461.44 | 1 | 4454.10 | 28 | SO69531 | 2024-08-18 | 356.33 | 4614.45 | 445.41 | |||
SO58927_18 | BEF7-43AF-A2 | PO15515112432 | 100 | 292 | 214 | 2 | 481 | 7 | 4.87 | 2024-03-24 | 243.53 | 5.97 | 2024-03-12 | 12 | 13.09 | 1 | 238.66 | 18 | SO58927 | 2024-03-19 | 19.09 | 157.04 | 20.29 | 0.02 |
SO63284_4 | E5FB-4341-8A | PO3683186679 | 100 | 292 | 561 | 85 | 7 | 2024-05-25 | 10013.09 | 250.33 | 2024-05-13 | 7 | 1481.94 | 1 | 10013.09 | 4 | SO63284 | 2024-05-20 | 801.05 | 10373.57 | 1430.44 | |||
SO51774_13 | 30BA-400A-89 | PO2668194455 | 100 | 292 | 551 | 535 | 7 | 2023-11-23 | 316.86 | 7.92 | 2023-11-11 | 2 | 144.59 | 1 | 316.86 | 13 | SO51774 | 2023-11-18 | 25.35 | 289.19 | 158.43 | |||
SO51708_9 | C46E-4C6C-95 | PO16704159960 | 100 | 292 | 217 | 680 | 7 | 2023-11-23 | 41.99 | 1.05 | 2023-11-11 | 2 | 13.09 | 1 | 41.99 | 9 | SO51708 | 2023-11-18 | 3.36 | 26.17 | 20.99 | |||
SO51752_8 | C68C-4AF8-B1 | PO11223127670 | 100 | 292 | 556 | 632 | 7 | 2023-11-23 | 421.18 | 10.53 | 2023-11-11 | 4 | 77.92 | 1 | 421.18 | 8 | SO51752 | 2023-11-18 | 33.69 | 311.67 | 105.29 | |||
SO46623_3 | 7E34-4681-95 | PO13514159069 | 100 | 292 | 289 | 337 | 7 | 2022-10-23 | 1488.55 | 37.21 | 2022-10-11 | 2 | 660.91 | 1 | 1488.55 | 3 | SO46623 | 2022-10-18 | 119.08 | 1321.83 | 744.27 | |||
SO63223_10 | 70F5-4AD9-A9 | PO13427118669 | 100 | 292 | 583 | 638 | 7 | 2024-05-25 | 3061.78 | 76.54 | 2024-05-13 | 3 | 1082.51 | 1 | 3061.78 | 10 | SO63223 | 2024-05-20 | 244.94 | 3247.53 | 1020.59 | |||
SO46981_33 | 22E4-4440-81 | PO13427119728 | 100 | 292 | 224 | 3 | 638 | 7 | 3.57 | 2022-11-23 | 71.31 | 1.69 | 2022-11-11 | 15 | 5.23 | 1 | 67.75 | 33 | SO46981 | 2022-11-18 | 5.42 | 78.45 | 4.75 | 0.05 |
SO57086_49 | 9159-4FEC-A8 | PO2668146833 | 100 | 292 | 514 | 535 | 7 | 2024-02-23 | 191.70 | 4.79 | 2024-02-11 | 3 | 47.29 | 1 | 191.70 | 49 | SO57086 | 2024-02-18 | 15.34 | 141.86 | 63.90 | |||
SO47680_22 | FD44-4F17-A1 | PO13340181659 | 100 | 292 | 456 | 355 | 7 | 2023-01-23 | 449.94 | 11.25 | 2023-01-11 | 10 | 30.93 | 1 | 449.94 | 22 | SO47680 | 2023-01-18 | 36.00 | 309.33 | 44.99 | |||
SO57068_6 | 0E44-4044-B3 | PO11223190191 | 100 | 292 | 555 | 632 | 7 | 2024-02-23 | 191.70 | 4.79 | 2024-02-11 | 3 | 47.29 | 1 | 191.70 | 6 | SO57068 | 2024-02-18 | 15.34 | 141.86 | 63.90 | |||
SO51729_11 | 5C3E-453A-B0 | PO13369147165 | 100 | 292 | 582 | 391 | 7 | 2023-11-23 | 4082.38 | 102.06 | 2023-11-11 | 4 | 1082.51 | 1 | 4082.38 | 11 | SO51729 | 2023-11-18 | 326.59 | 4330.04 | 1020.59 | |||
SO57054_23 | 8D1A-4AF0-91 | PO13456189029 | 36 | 292 | 548 | 614 | 7 | 2024-02-23 | 97.19 | 2.43 | 2024-02-11 | 2 | 35.96 | 1 | 97.19 | 23 | SO57054 | 2024-02-18 | 7.78 | 71.92 | 48.59 | |||
SO48317_8 | FA92-4B66-88 | PO15515198588 | 100 | 292 | 439 | 481 | 7 | 2023-03-25 | 1561.64 | 39.04 | 2023-03-13 | 2 | 722.26 | 1 | 1561.64 | 8 | SO48317 | 2023-03-20 | 124.93 | 1444.51 | 780.82 |
Generated 2024-11-10 04:28:01.576 UTC