[ROOT] dt FactResellerSale WHERE DimSalesTerritoryId EQ '1' > SHUFFLE SKIP 2000 < SKIP 967 > < 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 |
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
| SO67322_8 | 1881-4634-82 | PO6612121393 | 100 | 286 | 514 | 110 | 1 | 2024-07-24 | 191.70 | 4.79 | 2024-07-12 | 3 | 47.29 | 1 | 191.70 | 8 | SO67322 | 2024-07-19 | 15.34 | 141.86 | 63.90 | |||
| SO47403_12 | 60A2-4F08-8B | PO841143108 | 100 | 286 | 354 | 254 | 1 | 2022-12-24 | 4971.41 | 124.29 | 2022-12-12 | 4 | 1117.86 | 1 | 4971.41 | 12 | SO47403 | 2022-12-19 | 397.71 | 4471.42 | 1242.85 | |||
| SO65278_15 | 5822-4DF1-92 | PO5017152408 | 100 | 289 | 565 | 308 | 1 | 2024-06-23 | 445.41 | 11.14 | 2024-06-11 | 1 | 461.44 | 1 | 445.41 | 15 | SO65278 | 2024-06-18 | 35.63 | 461.44 | 445.41 | |||
| SO46957_23 | C98D-43A5-8A | PO16414179284 | 100 | 289 | 213 | 2 | 236 | 1 | 5.46 | 2022-11-23 | 273.19 | 6.69 | 2022-11-11 | 14 | 13.88 | 1 | 267.73 | 23 | SO46957 | 2022-11-18 | 21.42 | 194.29 | 19.51 | 0.02 |
| SO49053_4 | 5BE4-4969-A1 | PO16414175823 | 100 | 289 | 445 | 236 | 1 | 2023-05-26 | 71.99 | 1.80 | 2023-05-14 | 2 | 24.75 | 1 | 71.99 | 4 | SO49053 | 2023-05-21 | 5.76 | 49.49 | 35.99 | |||
| SO50316_6 | A6A4-4479-89 | PO7917123398 | 100 | 287 | 468 | 401 | 1 | 2023-08-23 | 91.18 | 2.28 | 2023-08-11 | 4 | 15.67 | 1 | 91.18 | 6 | SO50316 | 2023-08-18 | 7.29 | 62.68 | 22.79 | |||
| SO46105_22 | 2590-40A7-BB | PO8816169858 | 100 | 289 | 223 | 218 | 1 | 2022-08-23 | 20.75 | 0.52 | 2022-08-11 | 4 | 5.71 | 1 | 20.75 | 22 | SO46105 | 2022-08-18 | 1.66 | 22.82 | 5.19 | |||
| SO51089_16 | A635-4BAF-BC | PO16588151558 | 100 | 289 | 359 | 146 | 1 | 2023-10-23 | 6884.97 | 172.12 | 2023-10-11 | 5 | 1251.98 | 1 | 6884.97 | 16 | SO51089 | 2023-10-18 | 550.80 | 6259.91 | 1376.99 | |||
| SO57136_24 | 0031-4C10-84 | PO7627163680 | 100 | 272 | 477 | 433 | 1 | 2024-02-23 | 20.96 | 0.52 | 2024-02-11 | 7 | 1.87 | 1 | 20.96 | 24 | SO57136 | 2024-02-18 | 1.68 | 13.06 | 2.99 | |||
| SO46974_23 | BEE6-4EC8-8E | PO14442112586 | 100 | 286 | 464 | 127 | 1 | 2022-11-23 | 84.77 | 2.12 | 2022-11-11 | 6 | 9.71 | 1 | 84.77 | 23 | SO46974 | 2022-11-18 | 6.78 | 58.28 | 14.13 | |||
| SO50305_1 | 95CA-477E-A9 | PO5742159120 | 100 | 293 | 366 | 541 | 1 | 2023-08-23 | 647.99 | 16.20 | 2023-08-11 | 1 | 598.44 | 1 | 647.99 | 1 | SO50305 | 2023-08-18 | 51.84 | 598.44 | 647.99 | |||
| SO69422_50 | BF3A-4F54-82 | PO14500139823 | 100 | 282 | 558 | 650 | 1 | 2024-08-23 | 242.99 | 6.07 | 2024-08-11 | 1 | 179.82 | 1 | 242.99 | 50 | SO69422 | 2024-08-18 | 19.44 | 179.82 | 242.99 | |||
| SO58901_1 | 0A75-45E9-B9 | PO58157962 | 100 | 293 | 561 | 595 | 1 | 2024-03-24 | 1430.44 | 35.76 | 2024-03-12 | 1 | 1481.94 | 1 | 1430.44 | 1 | SO58901 | 2024-03-19 | 114.44 | 1481.94 | 1430.44 | |||
| SO58916_9 | E928-4943-BC | PO17139180025 | 100 | 293 | 240 | 644 | 1 | 2024-03-24 | 858.90 | 21.47 | 2024-03-12 | 1 | 868.63 | 1 | 858.90 | 9 | SO58916 | 2024-03-19 | 68.71 | 868.63 | 858.90 | |||
| SO67266_22 | 3CFE-46C9-88 | PO16588161069 | 100 | 289 | 511 | 146 | 1 | 2024-07-24 | 1747.63 | 43.69 | 2024-07-12 | 8 | 199.38 | 1 | 1747.63 | 22 | SO67266 | 2024-07-19 | 139.81 | 1595.01 | 218.45 | |||
| SO48001_21 | 02F1-4434-99 | PO14442151969 | 100 | 293 | 459 | 127 | 1 | 2023-02-23 | 53.99 | 1.35 | 2023-02-11 | 1 | 37.12 | 1 | 53.99 | 21 | SO48001 | 2023-02-18 | 4.32 | 37.12 | 53.99 | |||
| SO47403_35 | 60A2-4F08-8B | PO841143108 | 100 | 286 | 460 | 254 | 1 | 2022-12-24 | 323.96 | 8.10 | 2022-12-12 | 6 | 37.12 | 1 | 323.96 | 35 | SO47403 | 2022-12-19 | 25.92 | 222.73 | 53.99 | |||
| SO57176_8 | 6881-42A1-B6 | PO7917176909 | 100 | 287 | 477 | 401 | 1 | 2024-02-23 | 20.96 | 0.52 | 2024-02-11 | 7 | 1.87 | 1 | 20.96 | 8 | SO57176 | 2024-02-18 | 1.68 | 13.06 | 2.99 | |||
| SO46643_17 | 49E8-4C7A-85 | PO899110603 | 100 | 289 | 257 | 290 | 1 | 2022-10-23 | 919.69 | 22.99 | 2022-10-11 | 5 | 170.14 | 1 | 919.69 | 17 | SO46643 | 2022-10-18 | 73.58 | 850.71 | 183.94 | |||
| SO44762_10 | 553E-437E-92 | PO13543176259 | 100 | 287 | 307 | 293 | 1 | 2022-03-25 | 2167.78 | 54.19 | 2022-03-13 | 3 | 623.84 | 1 | 2167.78 | 10 | SO44762 | 2022-03-20 | 173.42 | 1871.52 | 722.59 | |||
| SO58962_9 | 12B1-4451-9A | PO870180310 | 100 | 286 | 565 | 621 | 1 | 2024-03-24 | 1336.23 | 33.41 | 2024-03-12 | 3 | 461.44 | 1 | 1336.23 | 9 | SO58962 | 2024-03-19 | 106.90 | 1384.33 | 445.41 | |||
| SO63148_4 | 00FA-42B1-88 | PO16675153915 | 100 | 293 | 573 | 361 | 1 | 2024-05-25 | 1430.44 | 35.76 | 2024-05-13 | 1 | 1481.94 | 1 | 1430.44 | 4 | SO63148 | 2024-05-20 | 114.44 | 1481.94 | 1430.44 | |||
| SO48087_28 | 2285-4C77-9B | PO8816162044 | 100 | 289 | 368 | 218 | 1 | 2023-02-23 | 5864.04 | 146.60 | 2023-02-11 | 4 | 1518.79 | 1 | 5864.04 | 28 | SO48087 | 2023-02-18 | 469.12 | 6075.15 | 1466.01 | |||
| SO50321_1 | 6B3D-47E0-99 | PO8816191637 | 100 | 289 | 377 | 218 | 1 | 2023-08-23 | 1308.94 | 32.72 | 2023-08-11 | 1 | 1320.68 | 1 | 1308.94 | 1 | SO50321 | 2023-08-18 | 104.72 | 1320.68 | 1308.94 | |||
| SO46974_25 | BEE6-4EC8-8E | PO14442112586 | 100 | 286 | 224 | 3 | 127 | 1 | 4.52 | 2022-11-23 | 90.33 | 2.15 | 2022-11-11 | 19 | 5.23 | 1 | 85.82 | 25 | SO46974 | 2022-11-18 | 6.87 | 99.36 | 4.75 | 0.05 |
| SO53457_12 | B3F3-4A07-9B | PO19169151555 | 100 | 289 | 306 | 272 | 1 | 2023-12-24 | 809.76 | 20.24 | 2023-12-12 | 1 | 739.04 | 1 | 809.76 | 12 | SO53457 | 2023-12-19 | 64.78 | 739.04 | 809.76 | |||
| SO44513_11 | A881-41E7-AD | PO14471116260 | 100 | 286 | 223 | 145 | 1 | 2022-02-23 | 10.37 | 0.26 | 2022-02-11 | 2 | 5.71 | 1 | 10.37 | 11 | SO44513 | 2022-02-18 | 0.83 | 11.41 | 5.19 | |||
| SO55269_15 | C087-4A55-8D | PO899192335 | 100 | 289 | 471 | 290 | 1 | 2024-01-23 | 304.80 | 7.62 | 2024-01-11 | 8 | 23.75 | 1 | 304.80 | 15 | SO55269 | 2024-01-18 | 24.38 | 189.99 | 38.10 | |||
| SO44570_26 | 4132-4AE3-99 | PO8816195785 | 100 | 289 | 285 | 218 | 1 | 2022-02-23 | 535.74 | 13.39 | 2022-02-11 | 3 | 176.20 | 1 | 535.74 | 26 | SO44570 | 2022-02-18 | 42.86 | 528.60 | 178.58 | |||
| SO51721_29 | 9429-430D-89 | PO14500124798 | 100 | 282 | 594 | 650 | 1 | 2023-11-23 | 1694.97 | 42.37 | 2023-11-11 | 5 | 308.22 | 1 | 1694.97 | 29 | SO51721 | 2023-11-18 | 135.60 | 1541.09 | 338.99 | |||
| SO71818_12 | 2FCA-4131-BD | PO12470139718 | 100 | 287 | 568 | 672 | 1 | 2024-09-23 | 890.82 | 22.27 | 2024-09-11 | 2 | 461.44 | 1 | 890.82 | 12 | SO71818 | 2024-09-18 | 71.27 | 922.89 | 445.41 |
Generated 2024-11-10 08:17:02.001 UTC