[ROOT] dt FactResellerSale < WHERE DimSalesTerritoryId EQ ALL SHUFFLE < SKIP 876 > < TAKE 30 >
30 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 |
---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
SO46625_19 | 361B-4CAF-A2 | PO13688113829 | 100 | 282 | 460 | 2 | 475 | 4 | 12.53 | 2022-09-01 | 626.33 | 15.35 | 2022-08-20 | 12 | 37.12 | 1 | 613.80 | 19 | SO46625 | 2022-08-27 | 49.10 | 445.45 | 52.19 | 0.02 |
SO53571_9 | 89B3-4B87-A8 | PO7482124191 | 100 | 293 | 560 | 163 | 1 | 2023-11-02 | 6560.19 | 164.00 | 2023-10-21 | 9 | 755.15 | 1 | 6560.19 | 9 | SO53571 | 2023-10-28 | 524.82 | 6796.36 | 728.91 | |||
SO44081_9 | 32E7-4EA4-9F | PO18299115585 | 19 | 288 | 292 | 118 | 6 | 2021-11-02 | 1637.40 | 40.94 | 2021-10-21 | 2 | 706.81 | 1 | 1637.40 | 9 | SO44081 | 2021-10-28 | 130.99 | 1413.62 | 818.70 | |||
SO50722_31 | 126E-410B-A5 | PO8468186428 | 98 | 290 | 373 | 16 | 10 | 2023-08-02 | 2617.88 | 65.45 | 2023-07-21 | 2 | 1320.68 | 1 | 2617.88 | 31 | SO50722 | 2023-07-28 | 209.43 | 2641.37 | 1308.94 | |||
SO71818_10 | 2FCA-4131-BD | PO12470139718 | 100 | 287 | 565 | 672 | 1 | 2024-08-02 | 890.82 | 22.27 | 2024-07-21 | 2 | 461.44 | 1 | 890.82 | 10 | SO71818 | 2024-07-28 | 71.27 | 922.89 | 445.41 | |||
SO61221_2 | 1B1D-4F1B-90 | PO15399128383 | 100 | 281 | 471 | 220 | 3 | 2024-03-03 | 152.40 | 3.81 | 2024-02-20 | 4 | 23.75 | 1 | 152.40 | 2 | SO61221 | 2024-02-27 | 12.19 | 95.00 | 38.10 | |||
SO46608_16 | ACF1-4852-B7 | PO18473177913 | 19 | 291 | 447 | 2 | 442 | 6 | 3.19 | 2022-09-01 | 159.50 | 3.91 | 2022-08-20 | 11 | 10.31 | 1 | 156.31 | 16 | SO46608 | 2022-08-27 | 12.50 | 113.44 | 14.50 | 0.02 |
SO50672_55 | 1BE9-437C-8A | PO16472110144 | 100 | 287 | 439 | 239 | 4 | 2023-08-02 | 2342.45 | 58.56 | 2023-07-21 | 3 | 722.26 | 1 | 2342.45 | 55 | SO50672 | 2023-07-28 | 187.40 | 2166.77 | 780.82 | |||
SO67296_1 | 1B2E-44D8-80 | PO1682139621 | 36 | 295 | 545 | 572 | 8 | 2024-06-02 | 24.29 | 0.61 | 2024-05-21 | 1 | 17.98 | 1 | 24.29 | 1 | SO67296 | 2024-05-28 | 1.94 | 17.98 | 24.29 | |||
SO49128_1 | 2621-4A5A-94 | PO16849144058 | 100 | 283 | 327 | 198 | 3 | 2023-04-04 | 469.79 | 11.74 | 2023-03-23 | 1 | 486.71 | 1 | 469.79 | 1 | SO49128 | 2023-03-30 | 37.58 | 486.71 | 469.79 | |||
SO51144_20 | 6330-4EB9-A5 | PO6409122852 | 100 | 281 | 545 | 292 | 4 | 2023-09-01 | 121.47 | 3.04 | 2023-08-20 | 5 | 17.98 | 1 | 121.47 | 20 | SO51144 | 2023-08-27 | 9.72 | 89.89 | 24.29 | |||
SO53566_14 | 3543-47B0-87 | PO8033117470 | 6 | 296 | 525 | 15 | 9 | 2023-11-02 | 316.86 | 7.92 | 2023-10-21 | 2 | 144.59 | 1 | 316.86 | 14 | SO53566 | 2023-10-28 | 25.35 | 289.19 | 158.43 | |||
SO47049_18 | 3D73-4468-AE | PO6525111066 | 100 | 283 | 366 | 345 | 4 | 2022-10-02 | 3239.97 | 81.00 | 2022-09-20 | 5 | 598.44 | 1 | 3239.97 | 18 | SO47049 | 2022-09-27 | 259.20 | 2992.18 | 647.99 | |||
SO59064_11 | AE68-4CAD-B8 | PO8671111477 | 98 | 290 | 517 | 502 | 10 | 2024-02-01 | 94.75 | 2.37 | 2024-01-20 | 3 | 23.37 | 1 | 94.75 | 11 | SO59064 | 2024-01-27 | 7.58 | 70.12 | 31.58 | |||
SO48776_6 | 81D9-4651-84 | PO3828123354 | 100 | 283 | 365 | 414 | 2 | 2023-03-04 | 647.99 | 16.20 | 2023-02-20 | 1 | 598.44 | 1 | 647.99 | 6 | SO48776 | 2023-02-27 | 51.84 | 598.44 | 647.99 | |||
SO53496_6 | 5404-4BB1-95 | PO12992153220 | 100 | 282 | 579 | 295 | 4 | 2023-11-02 | 728.91 | 18.22 | 2023-10-21 | 1 | 755.15 | 1 | 728.91 | 6 | SO53496 | 2023-10-28 | 58.31 | 755.15 | 728.91 | |||
SO47683_25 | 619F-4ABF-8A | PO12412127983 | 100 | 283 | 379 | 670 | 3 | 2022-12-02 | 2617.88 | 65.45 | 2022-11-20 | 2 | 1320.68 | 1 | 2617.88 | 25 | SO47683 | 2022-11-27 | 209.43 | 2641.37 | 1308.94 | |||
SO53518_22 | 5712-444B-BC | PO841197199 | 100 | 286 | 501 | 254 | 1 | 2023-11-02 | 218.63 | 5.47 | 2023-10-21 | 3 | 53.93 | 1 | 218.63 | 22 | SO53518 | 2023-10-28 | 17.49 | 161.78 | 72.88 | |||
SO50272_2 | E0A6-4CFA-90 | PO11745174916 | 100 | 282 | 385 | 97 | 4 | 2023-07-02 | 1800.79 | 45.02 | 2023-06-20 | 3 | 605.65 | 1 | 1800.79 | 2 | SO50272 | 2023-06-27 | 144.06 | 1816.95 | 600.26 | |||
SO59018_15 | F605-4DA0-8F | PO8033148787 | 6 | 296 | 400 | 15 | 9 | 2024-02-01 | 185.76 | 4.64 | 2024-01-20 | 5 | 27.49 | 1 | 185.76 | 15 | SO59018 | 2024-01-27 | 14.86 | 137.46 | 37.15 | |||
SO53551_8 | 8593-405C-AB | PO14297167079 | 100 | 285 | 565 | 13 | 627 | 5 | 100.22 | 2023-11-02 | 668.12 | 14.20 | 2023-10-21 | 2 | 461.44 | 1 | 567.90 | 8 | SO53551 | 2023-10-28 | 45.43 | 922.89 | 334.06 | 0.15 |
SO48317_21 | FA92-4B66-88 | PO15515198588 | 100 | 292 | 271 | 481 | 7 | 2023-02-01 | 404.66 | 10.12 | 2023-01-20 | 2 | 187.16 | 1 | 404.66 | 21 | SO48317 | 2023-01-27 | 32.37 | 374.31 | 202.33 | |||
SO47724_3 | FDA2-4CD7-92 | PO8787160870 | 100 | 282 | 453 | 523 | 3 | 2022-12-02 | 107.98 | 2.70 | 2022-11-20 | 3 | 24.75 | 1 | 107.98 | 3 | SO47724 | 2022-11-27 | 8.64 | 74.24 | 35.99 | |||
SO45307_6 | 9854-452F-A1 | PO10759149389 | 100 | 283 | 346 | 346 | 3 | 2022-04-04 | 8159.98 | 204.00 | 2022-03-23 | 4 | 1912.15 | 1 | 8159.98 | 6 | SO45307 | 2022-03-30 | 652.80 | 7648.62 | 2039.99 | |||
SO71948_12 | DCEE-428D-87 | PO9599179297 | 100 | 285 | 388 | 170 | 5 | 2024-08-02 | 3361.47 | 84.04 | 2024-07-21 | 5 | 713.08 | 1 | 3361.47 | 12 | SO71948 | 2024-07-28 | 268.92 | 3565.40 | 672.29 | |||
SO50748_16 | 5FBE-4B52-B2 | PO6786143310 | 100 | 281 | 417 | 3 | 4 | 2023-08-02 | 1297.81 | 32.45 | 2023-07-21 | 4 | 300.12 | 1 | 1297.81 | 16 | SO50748 | 2023-07-28 | 103.82 | 1200.48 | 324.45 | |||
SO71949_33 | D52C-4E65-AA | PO9483195097 | 100 | 283 | 234 | 2 | 54 | 2 | 6.96 | 2024-08-02 | 347.93 | 8.52 | 2024-07-21 | 12 | 38.49 | 1 | 340.97 | 33 | SO71949 | 2024-07-28 | 27.28 | 461.91 | 28.99 | 0.02 |
SO69479_19 | 3D8D-4908-A6 | PO18328116976 | 19 | 284 | 477 | 552 | 6 | 2024-07-02 | 8.98 | 0.22 | 2024-06-20 | 3 | 1.87 | 1 | 8.98 | 19 | SO69479 | 2024-06-27 | 0.72 | 5.60 | 2.99 | |||
SO49104_27 | 7F8C-4702-BB | PO11745119484 | 100 | 282 | 233 | 97 | 4 | 2023-04-04 | 144.20 | 3.61 | 2023-03-23 | 5 | 29.08 | 1 | 144.20 | 27 | SO49104 | 2023-03-30 | 11.54 | 145.40 | 28.84 | |||
SO58950_14 | E67E-435E-9F | PO11455199372 | 100 | 283 | 243 | 72 | 2 | 2024-02-01 | 1717.80 | 42.95 | 2024-01-20 | 2 | 868.63 | 1 | 1717.80 | 14 | SO58950 | 2024-01-27 | 137.42 | 1737.27 | 858.90 |
Generated 2024-09-19 15:13:13.056 UTC