[ROOT] dt FactResellerSale < WHERE DimProductId EQ ALL SHUFFLE < SKIP 1781 > < 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 |
---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
SO71802_25 | 6B80-41A7-89 | PO15457184141 | 100 | 285 | 576 | 297 | 5 | 2024-08-01 | 1430.44 | 35.76 | 2024-07-20 | 1 | 1481.94 | 1 | 1430.44 | 25 | SO71802 | 2024-07-27 | 114.44 | 1481.94 | 1430.44 | |||
SO48347_32 | 40D2-4DF5-93 | PO841112057 | 100 | 286 | 458 | 254 | 1 | 2023-01-31 | 449.94 | 11.25 | 2023-01-19 | 10 | 30.93 | 1 | 449.94 | 32 | SO48347 | 2023-01-26 | 36.00 | 309.33 | 44.99 | |||
SO58934_12 | 22EE-4D41-BA | PO13630180029 | 6 | 296 | 572 | 640 | 9 | 2024-01-31 | 445.41 | 11.14 | 2024-01-19 | 1 | 461.44 | 1 | 445.41 | 12 | SO58934 | 2024-01-26 | 35.63 | 461.44 | 445.41 | |||
SO58993_2 | EEB4-42E9-B9 | PO14297167367 | 100 | 285 | 565 | 627 | 5 | 2024-01-31 | 445.41 | 11.14 | 2024-01-19 | 1 | 461.44 | 1 | 445.41 | 2 | SO58993 | 2024-01-26 | 35.63 | 461.44 | 445.41 | |||
SO65235_18 | 0A92-4A75-90 | PO10962154595 | 19 | 284 | 588 | 685 | 6 | 2024-05-01 | 461.69 | 11.54 | 2024-04-19 | 1 | 419.78 | 1 | 461.69 | 18 | SO65235 | 2024-04-26 | 36.94 | 419.78 | 461.69 | |||
SO43916_10 | 974B-4BFD-AC | PO8874186100 | 100 | 282 | 346 | 348 | 3 | 2021-10-01 | 4079.99 | 102.00 | 2021-09-19 | 2 | 1912.15 | 1 | 4079.99 | 10 | SO43916 | 2021-09-26 | 326.40 | 3824.31 | 2039.99 | |||
SO48378_38 | 2FD7-4721-9D | PO6786131738 | 100 | 283 | 460 | 3 | 4 | 2023-01-31 | 323.96 | 8.10 | 2023-01-19 | 6 | 37.12 | 1 | 323.96 | 38 | SO48378 | 2023-01-26 | 25.92 | 222.73 | 53.99 | |||
SO65185_1 | F67E-4928-A7 | PO14906159435 | 19 | 291 | 544 | 424 | 6 | 2024-05-01 | 48.59 | 1.21 | 2024-04-19 | 1 | 35.96 | 1 | 48.59 | 1 | SO65185 | 2024-04-26 | 3.89 | 35.96 | 48.59 | |||
SO46605_5 | 88F6-4172-B3 | PO19314112090 | 100 | 283 | 456 | 622 | 3 | 2022-08-31 | 179.98 | 4.50 | 2022-08-19 | 4 | 30.93 | 1 | 179.98 | 5 | SO46605 | 2022-08-26 | 14.40 | 123.73 | 44.99 | |||
SO57045_10 | 4D3C-4309-BE | PO14587121888 | 100 | 293 | 493 | 199 | 1 | 2024-01-01 | 400.10 | 10.00 | 2023-12-20 | 2 | 199.85 | 1 | 400.10 | 10 | SO57045 | 2023-12-27 | 32.01 | 399.70 | 200.05 | |||
SO48001_8 | 02F1-4434-99 | PO14442151969 | 100 | 293 | 362 | 127 | 1 | 2023-01-01 | 1229.46 | 30.74 | 2022-12-20 | 1 | 1105.81 | 1 | 1229.46 | 8 | SO48001 | 2022-12-27 | 98.36 | 1105.81 | 1229.46 | |||
SO53527_53 | 0EBE-4ACB-B5 | PO1798140946 | 19 | 291 | 513 | 10 | 6 | 2023-11-01 | 1092.27 | 27.31 | 2023-10-20 | 5 | 199.38 | 1 | 1092.27 | 53 | SO53527 | 2023-10-27 | 87.38 | 996.88 | 218.45 | |||
SO51722_28 | 735D-4C32-A1 | PO15196144426 | 100 | 282 | 386 | 258 | 4 | 2023-10-01 | 672.29 | 16.81 | 2023-09-19 | 1 | 713.08 | 1 | 672.29 | 28 | SO51722 | 2023-09-26 | 53.78 | 713.08 | 672.29 | |||
SO57141_12 | 5DE1-45D6-8B | PO3625112721 | 100 | 283 | 440 | 666 | 2 | 2024-01-01 | 5153.40 | 128.84 | 2023-12-20 | 6 | 868.63 | 1 | 5153.40 | 12 | SO57141 | 2023-12-27 | 412.27 | 5211.81 | 858.90 | |||
SO49509_3 | 1105-4F75-BE | PO9599181538 | 100 | 285 | 387 | 170 | 5 | 2023-05-01 | 1200.53 | 30.01 | 2023-04-19 | 2 | 605.65 | 1 | 1200.53 | 3 | SO49509 | 2023-04-26 | 96.04 | 1211.30 | 600.26 | |||
SO44568_1 | F675-42E0-A0 | PO8932184745 | 100 | 281 | 293 | 287 | 3 | 2022-01-01 | 722.59 | 18.06 | 2021-12-20 | 1 | 623.84 | 1 | 722.59 | 1 | SO44568 | 2021-12-27 | 57.81 | 623.84 | 722.59 | |||
SO47973_26 | B9F1-47DA-87 | PO18705118148 | 19 | 291 | 230 | 479 | 6 | 2023-01-01 | 173.04 | 4.33 | 2022-12-20 | 6 | 29.08 | 1 | 173.04 | 26 | SO47973 | 2022-12-27 | 13.84 | 174.48 | 28.84 | |||
SO51821_18 | 1CCD-45D4-80 | PO7917148134 | 100 | 287 | 475 | 401 | 1 | 2023-10-01 | 167.98 | 4.20 | 2023-09-19 | 4 | 26.18 | 1 | 167.98 | 18 | SO51821 | 2023-09-26 | 13.44 | 104.71 | 41.99 | |||
SO46944_20 | 7854-48E8-92 | PO18676186070 | 100 | 282 | 470 | 3 | 697 | 1 | 16.72 | 2022-10-01 | 334.31 | 7.94 | 2022-09-19 | 16 | 15.67 | 1 | 317.60 | 20 | SO46944 | 2022-09-26 | 25.41 | 250.73 | 20.89 | 0.05 |
SO47365_25 | 4535-457B-B0 | PO17574153673 | 19 | 291 | 426 | 678 | 6 | 2022-11-01 | 1046.28 | 26.16 | 2022-10-20 | 5 | 185.82 | 1 | 1046.28 | 25 | SO47365 | 2022-10-27 | 83.70 | 929.10 | 209.26 | |||
SO59029_7 | E358-40C0-B2 | PO4640116818 | 100 | 287 | 532 | 648 | 4 | 2024-01-31 | 449.62 | 11.24 | 2024-01-19 | 3 | 136.79 | 1 | 449.62 | 7 | SO59029 | 2024-01-26 | 35.97 | 410.36 | 149.87 | |||
SO65158_28 | 3613-4FA2-B8 | PO19285194632 | 98 | 288 | 477 | 448 | 10 | 2024-05-01 | 14.97 | 0.37 | 2024-04-19 | 5 | 1.87 | 1 | 14.97 | 28 | SO65158 | 2024-04-26 | 1.20 | 9.33 | 2.99 | |||
SO53585_3 | 3C96-4A6F-BD | PO4756171285 | 100 | 283 | 481 | 126 | 2 | 2023-11-01 | 10.79 | 0.27 | 2023-10-20 | 2 | 3.36 | 1 | 10.79 | 3 | SO53585 | 2023-10-27 | 0.86 | 6.72 | 5.39 | |||
SO53468_26 | C577-4CE9-93 | PO17371113808 | 6 | 296 | 558 | 688 | 9 | 2023-11-01 | 242.99 | 6.07 | 2023-10-20 | 1 | 179.82 | 1 | 242.99 | 26 | SO53468 | 2023-10-27 | 19.44 | 179.82 | 242.99 | |||
SO50684_2 | 74E9-4949-91 | PO11165153787 | 19 | 291 | 468 | 586 | 6 | 2023-08-01 | 68.38 | 1.71 | 2023-07-20 | 3 | 15.67 | 1 | 68.38 | 2 | SO50684 | 2023-07-27 | 5.47 | 47.01 | 22.79 | |||
SO43907_17 | 9CB1-46F4-8A | PO6641115253 | 100 | 281 | 264 | 342 | 2 | 2021-10-01 | 183.94 | 4.60 | 2021-09-19 | 1 | 181.49 | 1 | 183.94 | 17 | SO43907 | 2021-09-26 | 14.72 | 181.49 | 183.94 | |||
SO57086_45 | 9159-4FEC-A8 | PO2668146833 | 100 | 292 | 511 | 535 | 7 | 2024-01-01 | 436.91 | 10.92 | 2023-12-20 | 2 | 199.38 | 1 | 436.91 | 45 | SO57086 | 2023-12-27 | 34.95 | 398.75 | 218.45 | |||
SO44547_27 | 801C-4288-87 | PO4901179982 | 19 | 284 | 272 | 84 | 6 | 2022-01-01 | 551.81 | 13.80 | 2021-12-20 | 3 | 181.49 | 1 | 551.81 | 27 | SO44547 | 2021-12-27 | 44.15 | 544.46 | 183.94 | |||
SO47451_1 | 6525-4619-9A | PO8671131661 | 98 | 288 | 421 | 2 | 502 | 10 | 45.55 | 2022-11-01 | 2277.42 | 55.80 | 2022-10-20 | 12 | 145.28 | 1 | 2231.87 | 1 | SO47451 | 2022-10-27 | 178.55 | 1743.40 | 189.78 | 0.02 |
SO57086_3 | 9159-4FEC-A8 | PO2668146833 | 100 | 292 | 400 | 535 | 7 | 2024-01-01 | 37.15 | 0.93 | 2023-12-20 | 1 | 27.49 | 1 | 37.15 | 3 | SO57086 | 2023-12-27 | 2.97 | 27.49 | 37.15 | |||
SO45308_12 | 81AA-4F3D-A7 | PO10440184078 | 100 | 283 | 296 | 623 | 3 | 2022-04-03 | 1429.41 | 35.74 | 2022-03-22 | 2 | 617.03 | 1 | 1429.41 | 12 | SO45308 | 2022-03-29 | 114.35 | 1234.06 | 714.70 |
Generated 2024-09-18 20:37:56.427 UTC