[ROOT] dt FactResellerSale WHERE DimSalesTerritoryId EQ '1' > SKIP 0 SHUFFLE < SKIP 969 > < 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 |
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
| SO46967_38 | 6486-4AF8-A6 | PO15573116583 | 100 | 286 | 396 | 487 | 1 | 2022-11-22 | 149.68 | 3.74 | 2022-11-10 | 2 | 55.38 | 1 | 149.68 | 38 | SO46967 | 2022-11-17 | 11.97 | 110.76 | 74.84 | |||
| SO51721_10 | 9429-430D-89 | PO14500124798 | 100 | 282 | 597 | 650 | 1 | 2023-11-22 | 323.99 | 8.10 | 2023-11-10 | 1 | 294.58 | 1 | 323.99 | 10 | SO51721 | 2023-11-17 | 25.92 | 294.58 | 323.99 | |||
| SO50209_26 | D138-4E7C-86 | PO15573136083 | 100 | 293 | 397 | 487 | 1 | 2023-08-22 | 72.88 | 1.82 | 2023-08-10 | 3 | 17.98 | 1 | 72.88 | 26 | SO50209 | 2023-08-17 | 5.83 | 53.93 | 24.29 | |||
| SO71880_17 | B0C7-4858-91 | PO7395117544 | 100 | 286 | 476 | 542 | 1 | 2024-09-22 | 293.96 | 7.35 | 2024-09-10 | 7 | 26.18 | 1 | 293.96 | 17 | SO71880 | 2024-09-17 | 23.52 | 183.23 | 41.99 | |||
| SO69471_24 | 2CF9-42DE-B1 | PO18676191433 | 100 | 282 | 214 | 697 | 1 | 2024-08-22 | 20.99 | 0.52 | 2024-08-10 | 1 | 13.09 | 1 | 20.99 | 24 | SO69471 | 2024-08-17 | 1.68 | 13.09 | 20.99 | |||
| SO46098_1 | CB38-416D-A7 | PO7221115229 | 100 | 289 | 288 | 326 | 1 | 2022-08-22 | 722.59 | 18.06 | 2022-08-10 | 1 | 623.84 | 1 | 722.59 | 1 | SO46098 | 2022-08-17 | 57.81 | 623.84 | 722.59 | |||
| SO49054_1 | 8503-488C-AA | PO14558112909 | 100 | 289 | 470 | 2 | 1 | 2023-05-25 | 45.59 | 1.14 | 2023-05-13 | 2 | 15.67 | 1 | 45.59 | 1 | SO49054 | 2023-05-20 | 3.65 | 31.34 | 22.79 | |||
| SO53457_32 | B3F3-4A07-9B | PO19169151555 | 100 | 289 | 514 | 272 | 1 | 2023-12-23 | 63.90 | 1.60 | 2023-12-11 | 1 | 47.29 | 1 | 63.90 | 32 | SO53457 | 2023-12-18 | 5.11 | 47.29 | 63.90 | |||
| SO46379_7 | 8ABD-4B11-A1 | PO7192140645 | 100 | 289 | 344 | 7 | 20 | 1 | 297.50 | 2022-09-22 | 850.00 | 13.81 | 2022-09-10 | 1 | 1912.15 | 1 | 552.50 | 7 | SO46379 | 2022-09-17 | 44.20 | 1912.15 | 850.00 | 0.35 |
| SO55291_18 | 4FAB-4BAB-88 | PO7076160432 | 100 | 293 | 574 | 505 | 1 | 2024-01-22 | 2860.88 | 71.52 | 2024-01-10 | 2 | 1481.94 | 1 | 2860.88 | 18 | SO55291 | 2024-01-17 | 228.87 | 2963.88 | 1430.44 | |||
| SO44501_9 | 4971-4FC0-A3 | PO16646128920 | 100 | 286 | 310 | 1 | 1 | 2022-02-22 | 2146.96 | 53.67 | 2022-02-10 | 1 | 2171.29 | 1 | 2146.96 | 9 | SO44501 | 2022-02-17 | 171.76 | 2171.29 | 2146.96 | |||
| SO48347_19 | 40D2-4DF5-93 | PO841112057 | 100 | 286 | 305 | 254 | 1 | 2023-03-24 | 2208.44 | 55.21 | 2023-03-12 | 3 | 653.70 | 1 | 2208.44 | 19 | SO48347 | 2023-03-19 | 176.67 | 1961.09 | 736.15 | |||
| SO67297_27 | 58AA-422C-BB | PO2552176926 | 100 | 286 | 475 | 506 | 1 | 2024-07-23 | 125.98 | 3.15 | 2024-07-11 | 3 | 26.18 | 1 | 125.98 | 27 | SO67297 | 2024-07-18 | 10.08 | 78.53 | 41.99 | |||
| SO46649_10 | A093-4C86-B7 | PO2929149182 | 100 | 289 | 399 | 380 | 1 | 2022-10-22 | 67.55 | 1.69 | 2022-10-10 | 2 | 24.99 | 1 | 67.55 | 10 | SO46649 | 2022-10-17 | 5.40 | 49.99 | 33.77 | |||
| SO53571_10 | 89B3-4B87-A8 | PO7482124191 | 100 | 293 | 496 | 163 | 1 | 2023-12-23 | 1807.04 | 45.18 | 2023-12-11 | 3 | 601.74 | 1 | 1807.04 | 10 | SO53571 | 2023-12-18 | 144.56 | 1805.23 | 602.35 | |||
| SO51146_9 | FC91-4E19-86 | PO7076128836 | 100 | 293 | 553 | 505 | 1 | 2023-10-22 | 27.65 | 0.69 | 2023-10-10 | 1 | 20.46 | 1 | 27.65 | 9 | SO51146 | 2023-10-17 | 2.21 | 20.46 | 27.65 | |||
| SO47986_7 | 3373-4C22-A9 | PO16414116972 | 100 | 289 | 454 | 236 | 1 | 2023-02-22 | 143.98 | 3.60 | 2023-02-10 | 4 | 24.75 | 1 | 143.98 | 7 | SO47986 | 2023-02-17 | 11.52 | 98.98 | 35.99 | |||
| SO46976_9 | 23E2-4510-88 | PO14558186797 | 100 | 289 | 354 | 2 | 1 | 2022-11-22 | 1242.85 | 31.07 | 2022-11-10 | 1 | 1117.86 | 1 | 1242.85 | 9 | SO46976 | 2022-11-17 | 99.43 | 1117.86 | 1242.85 | |||
| SO69475_1 | F74A-4967-BA | PO18618162557 | 100 | 286 | 565 | 605 | 1 | 2024-08-22 | 445.41 | 11.14 | 2024-08-10 | 1 | 461.44 | 1 | 445.41 | 1 | SO69475 | 2024-08-17 | 35.63 | 461.44 | 445.41 | |||
| SO57105_12 | 3AE1-4A72-91 | PO18676113963 | 100 | 282 | 474 | 3 | 697 | 1 | 34.65 | 2024-02-22 | 692.90 | 16.46 | 2024-02-10 | 18 | 26.18 | 1 | 658.26 | 12 | SO57105 | 2024-02-17 | 52.66 | 471.17 | 38.49 | 0.05 |
| SO69475_18 | F74A-4967-BA | PO18618162557 | 100 | 286 | 487 | 605 | 1 | 2024-08-22 | 329.94 | 8.25 | 2024-08-10 | 10 | 20.57 | 1 | 329.94 | 18 | SO69475 | 2024-08-17 | 26.40 | 205.66 | 32.99 | |||
| SO51711_6 | 5CB8-480D-A1 | PO16414129790 | 100 | 289 | 359 | 236 | 1 | 2023-11-22 | 12392.95 | 309.82 | 2023-11-10 | 9 | 1251.98 | 1 | 12392.95 | 6 | SO51711 | 2023-11-17 | 991.44 | 11267.83 | 1376.99 | |||
| SO45572_4 | 998A-428B-A3 | PO7946181052 | 100 | 282 | 332 | 438 | 1 | 2022-06-22 | 838.92 | 20.97 | 2022-06-10 | 2 | 413.15 | 1 | 838.92 | 4 | SO45572 | 2022-06-17 | 67.11 | 826.29 | 419.46 | |||
| SO50206_39 | 7656-4E84-B8 | PO16414158832 | 100 | 289 | 460 | 236 | 1 | 2023-08-22 | 323.96 | 8.10 | 2023-08-10 | 6 | 37.12 | 1 | 323.96 | 39 | SO50206 | 2023-08-17 | 25.92 | 222.73 | 53.99 | |||
| SO71836_29 | E41E-40C1-84 | PO841118259 | 100 | 286 | 400 | 254 | 1 | 2024-09-22 | 222.91 | 5.57 | 2024-09-10 | 6 | 27.49 | 1 | 222.91 | 29 | SO71836 | 2024-09-17 | 17.83 | 164.96 | 37.15 | |||
| SO48746_18 | 3C67-4620-90 | PO2552136060 | 100 | 286 | 354 | 2 | 506 | 1 | 264.31 | 2023-04-24 | 13215.66 | 323.78 | 2023-04-12 | 11 | 1117.86 | 1 | 12951.34 | 18 | SO48746 | 2023-04-19 | 1036.11 | 12296.41 | 1201.42 | 0.02 |
| SO59061_3 | FF84-46FB-BB | PO7946192154 | 100 | 282 | 580 | 438 | 1 | 2024-03-23 | 3061.78 | 76.54 | 2024-03-11 | 3 | 1082.51 | 1 | 3061.78 | 3 | SO59061 | 2024-03-18 | 244.94 | 3247.53 | 1020.59 | |||
| SO49092_11 | 72CE-4E29-82 | PO14442163644 | 100 | 293 | 397 | 127 | 1 | 2023-05-25 | 24.29 | 0.61 | 2023-05-13 | 1 | 17.98 | 1 | 24.29 | 11 | SO49092 | 2023-05-20 | 1.94 | 17.98 | 24.29 | |||
| SO53457_34 | B3F3-4A07-9B | PO19169151555 | 100 | 289 | 527 | 272 | 1 | 2023-12-23 | 792.15 | 19.80 | 2023-12-11 | 5 | 144.59 | 1 | 792.15 | 34 | SO53457 | 2023-12-18 | 63.37 | 722.97 | 158.43 | |||
| SO44570_2 | 4132-4AE3-99 | PO8816195785 | 100 | 289 | 322 | 218 | 1 | 2022-02-22 | 838.92 | 20.97 | 2022-02-10 | 2 | 413.15 | 1 | 838.92 | 2 | SO44570 | 2022-02-17 | 67.11 | 826.29 | 419.46 | |||
| SO45783_8 | AD5D-4FF2-82 | PO16617161291 | 100 | 286 | 296 | 397 | 1 | 2022-07-23 | 714.70 | 17.87 | 2022-07-11 | 1 | 617.03 | 1 | 714.70 | 8 | SO45783 | 2022-07-18 | 57.18 | 617.03 | 714.70 |
Generated 2024-11-10 01:55:41.672 UTC