[ROOT] dt FactResellerSale < WHERE DimSalesTerritoryId EQ ALL SKIP 0 SHUFFLE < SKIP 1310 > < TAKE 60 >
60 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 |
---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
SO50694_49 | DAEB-4730-9B | PO17545120609 | 19 | 291 | 335 | 155 | 6 | 2023-08-03 | 1409.38 | 35.23 | 2023-07-22 | 3 | 486.71 | 1 | 1409.38 | 49 | SO50694 | 2023-07-29 | 112.75 | 1460.12 | 469.79 | |||
SO67273_15 | 9BAE-4E69-B9 | PO13688176638 | 100 | 282 | 357 | 475 | 4 | 2024-06-03 | 4175.98 | 104.40 | 2024-05-22 | 3 | 1265.62 | 1 | 4175.98 | 15 | SO67273 | 2024-05-29 | 334.08 | 3796.86 | 1391.99 | |||
SO71802_10 | 6B80-41A7-89 | PO15457184141 | 100 | 285 | 565 | 297 | 5 | 2024-08-03 | 445.41 | 11.14 | 2024-07-22 | 1 | 461.44 | 1 | 445.41 | 10 | SO71802 | 2024-07-29 | 35.63 | 461.44 | 445.41 | |||
SO59014_2 | E148-47F7-98 | PO5510184760 | 100 | 287 | 605 | 5 | 4 | 2024-02-02 | 2267.96 | 56.70 | 2024-01-21 | 7 | 343.65 | 1 | 2267.96 | 2 | SO59014 | 2024-01-28 | 181.44 | 2405.55 | 323.99 | |||
SO53518_22 | 5712-444B-BC | PO841197199 | 100 | 286 | 501 | 254 | 1 | 2023-11-03 | 218.63 | 5.47 | 2023-10-22 | 3 | 53.93 | 1 | 218.63 | 22 | SO53518 | 2023-10-29 | 17.49 | 161.78 | 72.88 | |||
SO50726_22 | A80B-408E-B3 | PO9599192861 | 100 | 285 | 265 | 170 | 5 | 2023-08-03 | 1011.66 | 25.29 | 2023-07-22 | 5 | 187.16 | 1 | 1011.66 | 22 | SO50726 | 2023-07-29 | 80.93 | 935.79 | 202.33 | |||
SO71902_14 | AEC9-4070-9D | PO5539125166 | 100 | 282 | 587 | 61 | 4 | 2024-08-03 | 1385.08 | 34.63 | 2024-07-22 | 3 | 419.78 | 1 | 1385.08 | 14 | SO71902 | 2024-07-29 | 110.81 | 1259.34 | 461.69 | |||
SO50265_2 | 6C30-435D-9D | PO18705169014 | 19 | 291 | 329 | 479 | 6 | 2023-07-03 | 469.79 | 11.74 | 2023-06-21 | 1 | 486.71 | 1 | 469.79 | 2 | SO50265 | 2023-06-28 | 37.58 | 486.71 | 469.79 | |||
SO46988_53 | 2D2E-4EC3-AC | PO12499171502 | 100 | 282 | 447 | 78 | 4 | 2022-10-03 | 60.00 | 1.50 | 2022-09-21 | 4 | 10.31 | 1 | 60.00 | 53 | SO46988 | 2022-09-28 | 4.80 | 41.25 | 15.00 | |||
SO44298_13 | 960B-4C26-9F | PO11049118093 | 19 | 284 | 212 | 679 | 6 | 2021-12-03 | 100.93 | 2.52 | 2021-11-21 | 5 | 12.03 | 1 | 100.93 | 13 | SO44298 | 2021-11-28 | 8.07 | 60.14 | 20.19 | |||
SO51139_1 | 892A-4EAD-98 | PO7743143396 | 100 | 287 | 497 | 275 | 4 | 2023-09-02 | 602.35 | 15.06 | 2023-08-21 | 1 | 601.74 | 1 | 602.35 | 1 | SO51139 | 2023-08-28 | 48.19 | 601.74 | 602.35 | |||
SO58981_14 | 2B52-4247-AF | PO18299143459 | 19 | 291 | 237 | 118 | 6 | 2024-02-02 | 179.96 | 4.50 | 2024-01-21 | 6 | 38.49 | 1 | 179.96 | 14 | SO58981 | 2024-01-28 | 14.40 | 230.95 | 29.99 | |||
SO63280_13 | C73E-4203-80 | PO3654118854 | 100 | 281 | 516 | 435 | 4 | 2024-04-04 | 46.97 | 1.17 | 2024-03-23 | 2 | 17.38 | 1 | 46.97 | 13 | SO63280 | 2024-03-30 | 3.76 | 34.76 | 23.48 | |||
SO57122_14 | 048F-465A-A8 | PO4901112587 | 19 | 284 | 488 | 84 | 6 | 2024-01-03 | 97.18 | 2.43 | 2023-12-22 | 3 | 41.57 | 1 | 97.18 | 14 | SO57122 | 2023-12-29 | 7.77 | 124.72 | 32.39 | |||
SO47377_9 | FA63-499A-AB | PO15515156459 | 100 | 292 | 245 | 481 | 7 | 2022-11-03 | 1561.64 | 39.04 | 2022-10-22 | 2 | 722.26 | 1 | 1561.64 | 9 | SO47377 | 2022-10-29 | 124.93 | 1444.51 | 780.82 | |||
SO71805_13 | 99FD-47B9-97 | PO14703194514 | 6 | 296 | 488 | 2 | 573 | 9 | 6.89 | 2024-08-03 | 344.46 | 8.44 | 2024-07-22 | 11 | 41.57 | 1 | 337.57 | 13 | SO71805 | 2024-07-29 | 27.01 | 457.30 | 31.31 | 0.02 |
SO53531_36 | B1FB-47B2-8E | PO2697181370 | 100 | 282 | 531 | 187 | 4 | 2023-11-03 | 299.75 | 7.49 | 2023-10-22 | 2 | 136.79 | 1 | 299.75 | 36 | SO53531 | 2023-10-29 | 23.98 | 273.57 | 149.87 | |||
SO47008_49 | FD36-4D89-AB | PO1595170889 | 19 | 284 | 263 | 426 | 6 | 2022-10-03 | 1213.99 | 30.35 | 2022-09-21 | 6 | 187.16 | 1 | 1213.99 | 49 | SO47008 | 2022-09-28 | 97.12 | 1122.94 | 202.33 | |||
SO46028_21 | 7BBE-413C-83 | PO19546126425 | 100 | 285 | 318 | 206 | 5 | 2022-07-03 | 1749.59 | 43.74 | 2022-06-21 | 2 | 884.71 | 1 | 1749.59 | 21 | SO46028 | 2022-06-28 | 139.97 | 1769.42 | 874.79 | |||
SO69508_12 | 387A-4EC2-A7 | PO7627176234 | 100 | 293 | 376 | 433 | 1 | 2024-07-03 | 8796.06 | 219.90 | 2024-06-21 | 6 | 1554.95 | 1 | 8796.06 | 12 | SO69508 | 2024-06-28 | 703.68 | 9329.69 | 1466.01 | |||
SO67274_12 | EAF2-43E4-AB | PO13659172775 | 100 | 287 | 402 | 437 | 4 | 2024-06-03 | 216.49 | 5.41 | 2024-05-22 | 3 | 53.40 | 1 | 216.49 | 12 | SO67274 | 2024-05-29 | 17.32 | 160.20 | 72.16 | |||
SO48396_16 | F55B-45AE-8B | PO9715142000 | 100 | 283 | 308 | 490 | 4 | 2023-02-02 | 744.27 | 18.61 | 2023-01-21 | 1 | 660.91 | 1 | 744.27 | 16 | SO48396 | 2023-01-28 | 59.54 | 660.91 | 744.27 | |||
SO44562_6 | 1856-47B2-AD | PO7598190472 | 100 | 285 | 334 | 45 | 5 | 2022-01-03 | 419.46 | 10.49 | 2021-12-22 | 1 | 413.15 | 1 | 419.46 | 6 | SO44562 | 2021-12-29 | 33.56 | 413.15 | 419.46 | |||
SO67318_2 | 5460-4BEE-A6 | PO6409141464 | 100 | 281 | 583 | 292 | 4 | 2024-06-03 | 3061.78 | 76.54 | 2024-05-22 | 3 | 1082.51 | 1 | 3061.78 | 2 | SO67318 | 2024-05-29 | 244.94 | 3247.53 | 1020.59 | |||
SO50298_28 | 2A9C-4236-85 | PO4843196377 | 100 | 287 | 381 | 257 | 4 | 2023-07-03 | 2401.05 | 60.03 | 2023-06-21 | 4 | 605.65 | 1 | 2401.05 | 28 | SO50298 | 2023-06-28 | 192.08 | 2422.60 | 600.26 | |||
SO55245_6 | B5AD-476D-B4 | PO14732112185 | 19 | 291 | 580 | 2 | 514 | 6 | 217.05 | 2023-12-03 | 10852.32 | 265.88 | 2023-11-21 | 11 | 1082.51 | 1 | 10635.27 | 6 | SO55245 | 2023-11-28 | 850.82 | 11907.61 | 986.57 | 0.02 |
SO45527_23 | 610E-44BC-87 | PO17545114353 | 19 | 288 | 320 | 155 | 6 | 2022-05-03 | 2516.75 | 62.92 | 2022-04-21 | 6 | 413.15 | 1 | 2516.75 | 23 | SO45527 | 2022-04-28 | 201.34 | 2478.88 | 419.46 | |||
SO46348_2 | CF4C-437D-97 | PO13543132672 | 100 | 287 | 348 | 7 | 293 | 1 | 2657.80 | 2022-08-03 | 7593.73 | 123.40 | 2022-07-22 | 9 | 1898.09 | 1 | 4935.92 | 2 | SO46348 | 2022-07-29 | 394.87 | 17082.85 | 843.75 | 0.35 |
SO55258_6 | D620-45DD-96 | PO12035165890 | 6 | 296 | 477 | 123 | 9 | 2023-12-03 | 8.98 | 0.22 | 2023-11-21 | 3 | 1.87 | 1 | 8.98 | 6 | SO55258 | 2023-11-28 | 0.72 | 5.60 | 2.99 | |||
SO58948_31 | 1534-4AB5-81 | PO11774195497 | 6 | 296 | 579 | 682 | 9 | 2024-02-02 | 728.91 | 18.22 | 2024-01-21 | 1 | 755.15 | 1 | 728.91 | 31 | SO58948 | 2024-01-28 | 58.31 | 755.15 | 728.91 | |||
SO50321_18 | 6B3D-47E0-99 | PO8816191637 | 100 | 289 | 383 | 218 | 1 | 2023-07-03 | 2401.05 | 60.03 | 2023-06-21 | 4 | 605.65 | 1 | 2401.05 | 18 | SO50321 | 2023-06-28 | 192.08 | 2422.60 | 600.26 | |||
SO59065_10 | C012-48E8-A5 | PO8903194371 | 100 | 293 | 490 | 235 | 1 | 2024-02-02 | 64.79 | 1.62 | 2024-01-21 | 2 | 41.57 | 1 | 64.79 | 10 | SO59065 | 2024-01-28 | 5.18 | 83.14 | 32.39 | |||
SO51699_18 | 31D5-494C-BA | PO18879118606 | 19 | 291 | 573 | 64 | 6 | 2023-10-03 | 1430.44 | 35.76 | 2023-09-21 | 1 | 1481.94 | 1 | 1430.44 | 18 | SO51699 | 2023-09-28 | 114.44 | 1481.94 | 1430.44 | |||
SO57160_14 | 86C3-4E21-9D | PO4727197868 | 100 | 293 | 581 | 343 | 1 | 2024-01-03 | 1020.59 | 25.51 | 2023-12-22 | 1 | 1082.51 | 1 | 1020.59 | 14 | SO57160 | 2023-12-29 | 81.65 | 1082.51 | 1020.59 | |||
SO57134_21 | 040D-4B73-AD | PO6351190175 | 100 | 281 | 376 | 255 | 4 | 2024-01-03 | 1466.01 | 36.65 | 2023-12-22 | 1 | 1554.95 | 1 | 1466.01 | 21 | SO57134 | 2023-12-29 | 117.28 | 1554.95 | 1466.01 | |||
SO53468_44 | C577-4CE9-93 | PO17371113808 | 6 | 296 | 477 | 688 | 9 | 2023-11-03 | 20.96 | 0.52 | 2023-10-22 | 7 | 1.87 | 1 | 20.96 | 44 | SO53468 | 2023-10-29 | 1.68 | 13.06 | 2.99 | |||
SO53573_42 | F674-4899-B9 | PO8671117198 | 98 | 288 | 597 | 502 | 10 | 2023-11-03 | 1295.98 | 32.40 | 2023-10-22 | 4 | 294.58 | 1 | 1295.98 | 42 | SO53573 | 2023-10-29 | 103.68 | 1178.32 | 323.99 | |||
SO46664_12 | B900-4D0D-AF | PO6235159004 | 100 | 281 | 236 | 431 | 3 | 2022-09-02 | 28.84 | 0.72 | 2022-08-21 | 1 | 29.08 | 1 | 28.84 | 12 | SO46664 | 2022-08-28 | 2.31 | 29.08 | 28.84 | |||
SO67292_10 | 09EF-4688-BB | PO551144976 | 100 | 281 | 434 | 4 | 4 | 2024-06-03 | 356.90 | 8.92 | 2024-05-22 | 1 | 360.94 | 1 | 356.90 | 10 | SO67292 | 2024-05-29 | 28.55 | 360.94 | 356.90 | |||
SO67279_23 | 5395-4C5C-A0 | PO12528190770 | 100 | 282 | 578 | 331 | 4 | 2024-06-03 | 2186.73 | 54.67 | 2024-05-22 | 3 | 755.15 | 1 | 2186.73 | 23 | SO67279 | 2024-05-29 | 174.94 | 2265.45 | 728.91 | |||
SO44298_3 | 960B-4C26-9F | PO11049118093 | 19 | 284 | 275 | 679 | 6 | 2021-12-03 | 356.90 | 8.92 | 2021-11-21 | 1 | 352.14 | 1 | 356.90 | 3 | SO44298 | 2021-11-28 | 28.55 | 352.14 | 356.90 | |||
SO58963_22 | 6ADC-4485-8C | PO841129336 | 100 | 286 | 597 | 254 | 1 | 2024-02-02 | 1295.98 | 32.40 | 2024-01-21 | 4 | 294.58 | 1 | 1295.98 | 22 | SO58963 | 2024-01-28 | 103.68 | 1178.32 | 323.99 | |||
SO53537_4 | C14C-4596-A3 | PO19894159880 | 100 | 283 | 473 | 557 | 2 | 2023-11-03 | 38.10 | 0.95 | 2023-10-22 | 1 | 23.75 | 1 | 38.10 | 4 | SO53537 | 2023-10-29 | 3.05 | 23.75 | 38.10 | |||
SO71814_4 | D83E-436E-BB | PO12818173864 | 19 | 291 | 243 | 587 | 6 | 2024-08-03 | 858.90 | 21.47 | 2024-07-22 | 1 | 868.63 | 1 | 858.90 | 4 | SO71814 | 2024-07-29 | 68.71 | 868.63 | 858.90 | |||
SO50306_12 | D376-4A40-86 | PO5858194676 | 100 | 285 | 457 | 566 | 5 | 2023-07-03 | 44.99 | 1.12 | 2023-06-21 | 1 | 30.93 | 1 | 44.99 | 12 | SO50306 | 2023-06-28 | 3.60 | 30.93 | 44.99 | |||
SO47013_5 | 4AB0-4FA0-95 | PO1827132360 | 19 | 291 | 321 | 317 | 6 | 2022-10-03 | 1409.38 | 35.23 | 2022-09-21 | 3 | 486.71 | 1 | 1409.38 | 5 | SO47013 | 2022-09-28 | 112.75 | 1460.12 | 469.79 | |||
SO58910_2 | A209-4ADD-98 | PO19169152738 | 100 | 289 | 592 | 272 | 1 | 2024-02-02 | 677.99 | 16.95 | 2024-01-21 | 2 | 308.22 | 1 | 677.99 | 2 | SO58910 | 2024-01-28 | 54.24 | 616.44 | 338.99 | |||
SO65296_1 | 6520-4B75-AC | PO58169168 | 100 | 293 | 586 | 595 | 1 | 2024-05-03 | 1336.23 | 33.41 | 2024-04-21 | 3 | 461.44 | 1 | 1336.23 | 1 | SO65296 | 2024-04-28 | 106.90 | 1384.33 | 445.41 | |||
SO49823_3 | DD31-40C0-B6 | PO19314153883 | 100 | 281 | 323 | 622 | 3 | 2023-06-03 | 1409.38 | 35.23 | 2023-05-22 | 3 | 486.71 | 1 | 1409.38 | 3 | SO49823 | 2023-05-29 | 112.75 | 1460.12 | 469.79 | |||
SO46666_13 | 1A94-4D1F-AF | PO6699130779 | 100 | 281 | 385 | 234 | 2 | 2022-09-02 | 5402.36 | 135.06 | 2022-08-21 | 9 | 605.65 | 1 | 5402.36 | 13 | SO46666 | 2022-08-28 | 432.19 | 5450.84 | 600.26 | |||
SO48768_12 | 590A-4550-A0 | PO13862146668 | 19 | 291 | 356 | 119 | 6 | 2023-03-05 | 2485.70 | 62.14 | 2023-02-21 | 2 | 1117.86 | 1 | 2485.70 | 12 | SO48768 | 2023-02-28 | 198.86 | 2235.71 | 1242.85 | |||
SO46970_28 | 01AF-420A-B9 | PO15196114472 | 100 | 282 | 273 | 258 | 4 | 2022-10-03 | 607.00 | 15.17 | 2022-09-21 | 3 | 187.16 | 1 | 607.00 | 28 | SO46970 | 2022-09-28 | 48.56 | 561.47 | 202.33 | |||
SO51705_14 | DFFB-4C23-BD | PO16965171069 | 100 | 285 | 491 | 441 | 5 | 2023-10-03 | 129.58 | 3.24 | 2023-09-21 | 4 | 41.57 | 1 | 129.58 | 14 | SO51705 | 2023-09-28 | 10.37 | 166.29 | 32.39 | |||
SO46062_22 | 114A-41C0-B5 | PO11600112515 | 19 | 288 | 223 | 2 | 569 | 6 | 1.40 | 2022-07-03 | 70.19 | 1.72 | 2022-06-21 | 14 | 5.71 | 1 | 68.79 | 22 | SO46062 | 2022-06-28 | 5.50 | 79.87 | 5.01 | 0.02 |
SO51085_14 | EB9F-4A76-97 | PO19314178917 | 100 | 281 | 234 | 622 | 3 | 2023-09-02 | 239.95 | 6.00 | 2023-08-21 | 8 | 38.49 | 1 | 239.95 | 14 | SO51085 | 2023-08-28 | 19.20 | 307.94 | 29.99 | |||
SO46058_5 | FA37-4F46-97 | PO12557123934 | 100 | 282 | 223 | 240 | 4 | 2022-07-03 | 15.56 | 0.39 | 2022-06-21 | 3 | 5.71 | 1 | 15.56 | 5 | SO46058 | 2022-06-28 | 1.24 | 17.12 | 5.19 | |||
SO51828_22 | 3204-40B6-A5 | PO5771194719 | 100 | 282 | 372 | 79 | 3 | 2023-10-03 | 5864.04 | 146.60 | 2023-09-21 | 4 | 1554.95 | 1 | 5864.04 | 22 | SO51828 | 2023-09-28 | 469.12 | 6219.79 | 1466.01 | |||
SO51844_3 | DE76-4481-AA | PO4553182082 | 100 | 282 | 472 | 313 | 4 | 2023-10-03 | 38.10 | 0.95 | 2023-09-21 | 1 | 23.75 | 1 | 38.10 | 3 | SO51844 | 2023-09-28 | 3.05 | 23.75 | 38.10 | |||
SO51795_14 | 30DF-4333-9E | PO15921146523 | 100 | 287 | 465 | 77 | 4 | 2023-10-03 | 29.39 | 0.73 | 2023-09-21 | 2 | 9.16 | 1 | 29.39 | 14 | SO51795 | 2023-09-28 | 2.35 | 18.32 | 14.69 | |||
SO55307_11 | 242A-4FD9-94 | PO6032153793 | 6 | 296 | 564 | 177 | 9 | 2023-12-03 | 1430.44 | 35.76 | 2023-11-21 | 1 | 1481.94 | 1 | 1430.44 | 11 | SO55307 | 2023-11-28 | 114.44 | 1481.94 | 1430.44 |
Generated 2024-09-20 03:50:06.395 UTC