[ROOT] dt FactResellerSale < WHERE DimSalesTerritoryId EQ ALL SKIP 500 SKIP 0 SHUFFLE < SKIP 657 > < 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 |
---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
SO65207_29 | B20E-440F-A3 | PO1537156240 | 100 | 285 | 576 | 611 | 5 | 2024-06-23 | 5721.77 | 143.04 | 2024-06-11 | 4 | 1481.94 | 1 | 5721.77 | 29 | SO65207 | 2024-06-18 | 457.74 | 5927.75 | 1430.44 | |||
SO46957_43 | C98D-43A5-8A | PO16414179284 | 100 | 289 | 230 | 236 | 1 | 2022-11-23 | 230.72 | 5.77 | 2022-11-11 | 8 | 29.08 | 1 | 230.72 | 43 | SO46957 | 2022-11-18 | 18.46 | 232.65 | 28.84 | |||
SO50758_8 | 23D8-44CE-96 | PO8903112353 | 100 | 293 | 233 | 235 | 1 | 2023-09-23 | 57.68 | 1.44 | 2023-09-11 | 2 | 29.08 | 1 | 57.68 | 8 | SO50758 | 2023-09-18 | 4.61 | 58.16 | 28.84 | |||
SO58962_13 | 12B1-4451-9A | PO870180310 | 100 | 286 | 603 | 621 | 1 | 2024-03-24 | 437.36 | 10.93 | 2024-03-12 | 6 | 53.94 | 1 | 437.36 | 13 | SO58962 | 2024-03-19 | 34.99 | 323.65 | 72.89 | |||
SO71787_3 | 94A7-4406-B3 | PO18038111279 | 100 | 287 | 573 | 509 | 4 | 2024-09-23 | 2860.88 | 71.52 | 2024-09-11 | 2 | 1481.94 | 1 | 2860.88 | 3 | SO71787 | 2024-09-18 | 228.87 | 2963.88 | 1430.44 | |||
SO71818_1 | 2FCA-4131-BD | PO12470139718 | 100 | 287 | 499 | 672 | 1 | 2024-09-23 | 4818.77 | 120.47 | 2024-09-11 | 8 | 601.74 | 1 | 4818.77 | 1 | SO71818 | 2024-09-18 | 385.50 | 4813.95 | 602.35 | |||
SO61218_23 | 8441-4C6F-89 | PO13688193778 | 100 | 282 | 359 | 475 | 4 | 2024-04-24 | 11015.95 | 275.40 | 2024-04-12 | 8 | 1251.98 | 1 | 11015.95 | 23 | SO61218 | 2024-04-19 | 881.28 | 10015.85 | 1376.99 | |||
SO47400_29 | F0B3-44C1-8F | PO10701186775 | 100 | 282 | 233 | 4 | 133 | 4 | 76.91 | 2022-12-24 | 769.08 | 17.30 | 2022-12-12 | 32 | 29.08 | 1 | 692.17 | 29 | SO47400 | 2022-12-19 | 55.37 | 930.58 | 24.03 | 0.10 |
SO43869_3 | 96FA-4DF1-81 | PO14500145975 | 100 | 282 | 350 | 650 | 1 | 2021-11-23 | 4049.99 | 101.25 | 2021-11-11 | 2 | 1898.09 | 1 | 4049.99 | 3 | SO43869 | 2021-11-18 | 324.00 | 3796.19 | 2024.99 | |||
SO48021_26 | 7215-4D49-AD | PO11629116216 | 100 | 281 | 352 | 396 | 2 | 2023-02-23 | 2485.70 | 62.14 | 2023-02-11 | 2 | 1117.86 | 1 | 2485.70 | 26 | SO48021 | 2023-02-18 | 198.86 | 2235.71 | 1242.85 | |||
SO46355_17 | D579-4B15-AB | PO261195016 | 100 | 283 | 229 | 647 | 4 | 2022-09-23 | 86.52 | 2.16 | 2022-09-11 | 3 | 31.72 | 1 | 86.52 | 17 | SO46355 | 2022-09-18 | 6.92 | 95.17 | 28.84 | |||
SO44102_1 | BAC5-4B76-AB | PO11426145969 | 100 | 285 | 319 | 386 | 5 | 2021-12-24 | 1749.59 | 43.74 | 2021-12-12 | 2 | 884.71 | 1 | 1749.59 | 1 | SO44102 | 2021-12-19 | 139.97 | 1769.42 | 874.79 | |||
SO65315_25 | 0FFB-4EB5-A3 | PO6757194680 | 100 | 281 | 309 | 21 | 4 | 2024-06-23 | 818.70 | 20.47 | 2024-06-11 | 1 | 747.20 | 1 | 818.70 | 25 | SO65315 | 2024-06-18 | 65.50 | 747.20 | 818.70 | |||
SO53616_28 | A692-4827-93 | PO6786150961 | 100 | 281 | 583 | 2 | 3 | 4 | 276.24 | 2023-12-24 | 13812.04 | 338.40 | 2023-12-12 | 14 | 1082.51 | 1 | 13535.80 | 28 | SO53616 | 2023-12-19 | 1082.86 | 15155.14 | 986.57 | 0.02 |
SO67298_12 | F9FB-4B4C-92 | PO2755196827 | 100 | 282 | 576 | 3 | 205 | 4 | 983.43 | 2024-07-24 | 19668.58 | 467.13 | 2024-07-12 | 15 | 1481.94 | 1 | 18685.15 | 12 | SO67298 | 2024-07-19 | 1494.81 | 22229.07 | 1311.24 | 0.05 |
SO57063_3 | 41AF-4539-AE | PO11629118689 | 100 | 283 | 594 | 396 | 2 | 2024-02-23 | 338.99 | 8.47 | 2024-02-11 | 1 | 308.22 | 1 | 338.99 | 3 | SO57063 | 2024-02-18 | 27.12 | 308.22 | 338.99 | |||
SO51853_1 | 3754-4D33-92 | PO3596145757 | 100 | 285 | 476 | 3 | 476 | 5 | 32.72 | 2023-11-23 | 654.41 | 15.54 | 2023-11-11 | 17 | 26.18 | 1 | 621.69 | 1 | SO51853 | 2023-11-18 | 49.73 | 445.00 | 38.49 | 0.05 |
SO65188_18 | 86B3-49B3-A1 | PO14790112162 | 19 | 291 | 355 | 497 | 6 | 2024-06-23 | 2783.99 | 69.60 | 2024-06-11 | 2 | 1265.62 | 1 | 2783.99 | 18 | SO65188 | 2024-06-18 | 222.72 | 2531.24 | 1391.99 | |||
SO46660_37 | CF24-45E2-9D | PO5626129733 | 100 | 283 | 271 | 166 | 4 | 2022-10-23 | 2023.32 | 50.58 | 2022-10-11 | 10 | 187.16 | 1 | 2023.32 | 37 | SO46660 | 2022-10-18 | 161.87 | 1871.57 | 202.33 | |||
SO47992_43 | 3F55-4354-BD | PO15573158216 | 100 | 293 | 454 | 487 | 1 | 2023-02-23 | 143.98 | 3.60 | 2023-02-11 | 4 | 24.75 | 1 | 143.98 | 43 | SO47992 | 2023-02-18 | 11.52 | 98.98 | 35.99 | |||
SO69520_34 | 654B-484B-8F | PO4466144794 | 19 | 291 | 587 | 352 | 6 | 2024-08-23 | 461.69 | 11.54 | 2024-08-11 | 1 | 419.78 | 1 | 461.69 | 34 | SO69520 | 2024-08-18 | 36.94 | 419.78 | 461.69 | |||
SO69475_33 | F74A-4967-BA | PO18618162557 | 100 | 286 | 231 | 605 | 1 | 2024-08-23 | 119.98 | 3.00 | 2024-08-11 | 4 | 38.49 | 1 | 119.98 | 33 | SO69475 | 2024-08-18 | 9.60 | 153.97 | 29.99 | |||
SO58977_5 | 1BFB-45A0-B9 | PO18763128008 | 100 | 287 | 579 | 59 | 4 | 2024-03-24 | 728.91 | 18.22 | 2024-03-12 | 1 | 755.15 | 1 | 728.91 | 5 | SO58977 | 2024-03-19 | 58.31 | 755.15 | 728.91 | |||
SO65250_25 | B44C-40C3-83 | PO11774180512 | 6 | 296 | 563 | 682 | 9 | 2024-06-23 | 2860.88 | 71.52 | 2024-06-11 | 2 | 1481.94 | 1 | 2860.88 | 25 | SO65250 | 2024-06-18 | 228.87 | 2963.88 | 1430.44 | |||
SO50739_4 | 7F49-4009-8C | PO3886138724 | 100 | 281 | 456 | 165 | 4 | 2023-09-23 | 134.98 | 3.37 | 2023-09-11 | 3 | 30.93 | 1 | 134.98 | 4 | SO50739 | 2023-09-18 | 10.80 | 92.80 | 44.99 | |||
SO46385_25 | F727-48F0-AF | PO9483110086 | 100 | 281 | 220 | 54 | 2 | 2022-09-23 | 100.93 | 2.52 | 2022-09-11 | 5 | 12.03 | 1 | 100.93 | 25 | SO46385 | 2022-09-18 | 8.07 | 60.14 | 20.19 | |||
SO48001_37 | 02F1-4434-99 | PO14442151969 | 100 | 293 | 305 | 127 | 1 | 2023-02-23 | 736.15 | 18.40 | 2023-02-11 | 1 | 653.70 | 1 | 736.15 | 37 | SO48001 | 2023-02-18 | 58.89 | 653.70 | 736.15 | |||
SO51112_18 | 6C36-4086-8D | PO11687117332 | 100 | 283 | 548 | 691 | 2 | 2023-10-23 | 97.19 | 2.43 | 2023-10-11 | 2 | 35.96 | 1 | 97.19 | 18 | SO51112 | 2023-10-18 | 7.78 | 71.92 | 48.59 | |||
SO51110_15 | 2713-42DF-AC | PO11861142261 | 100 | 283 | 474 | 17 | 5 | 2023-10-23 | 167.98 | 4.20 | 2023-10-11 | 4 | 26.18 | 1 | 167.98 | 15 | SO51110 | 2023-10-18 | 13.44 | 104.71 | 41.99 | |||
SO67314_47 | 6653-491A-80 | PO3828116396 | 100 | 283 | 501 | 414 | 2 | 2024-07-24 | 72.88 | 1.82 | 2024-07-12 | 1 | 53.93 | 1 | 72.88 | 47 | SO67314 | 2024-07-19 | 5.83 | 53.93 | 72.88 | |||
SO71787_11 | 94A7-4406-B3 | PO18038111279 | 100 | 287 | 564 | 509 | 4 | 2024-09-23 | 1430.44 | 35.76 | 2024-09-11 | 1 | 1481.94 | 1 | 1430.44 | 11 | SO71787 | 2024-09-18 | 114.44 | 1481.94 | 1430.44 |
Generated 2024-11-10 16:01:07.731 UTC