[ROOT] dt FactResellerSale < WHERE DimSalesTerritoryId EQ ALL SKIP 0 SHUFFLE < SKIP 1373 > < TAKE 62 >
62 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 |
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
| SO63141_16 | 96AB-479F-86 | PO17603143134 | 19 | 284 | 214 | 12 | 6 | 2024-04-03 | 83.98 | 2.10 | 2024-03-22 | 4 | 13.09 | 1 | 83.98 | 16 | SO63141 | 2024-03-29 | 6.72 | 52.35 | 20.99 | |||
| SO69560_24 | B1B6-43F4-BC | PO9077167302 | 19 | 291 | 525 | 100 | 6 | 2024-07-02 | 316.86 | 7.92 | 2024-06-20 | 2 | 144.59 | 1 | 316.86 | 24 | SO69560 | 2024-06-27 | 25.35 | 289.19 | 158.43 | |||
| SO48778_24 | 4F83-4D59-87 | PO4495173571 | 19 | 291 | 470 | 496 | 6 | 2023-03-04 | 136.76 | 3.42 | 2023-02-20 | 6 | 15.67 | 1 | 136.76 | 24 | SO48778 | 2023-02-27 | 10.94 | 94.03 | 22.79 | |||
| SO44286_2 | 27D8-4398-9C | PO16008112311 | 100 | 282 | 314 | 511 | 4 | 2021-12-02 | 2146.96 | 53.67 | 2021-11-20 | 1 | 2171.29 | 1 | 2146.96 | 2 | SO44286 | 2021-11-27 | 171.76 | 2171.29 | 2146.96 | |||
| SO46980_4 | FAA2-449B-99 | PO13572170679 | 100 | 287 | 369 | 527 | 3 | 2022-10-02 | 7330.05 | 183.25 | 2022-09-20 | 5 | 1518.79 | 1 | 7330.05 | 4 | SO46980 | 2022-09-27 | 586.40 | 7593.93 | 1466.01 | |||
| SO58927_36 | BEF7-43AF-A2 | PO15515112432 | 100 | 292 | 487 | 481 | 7 | 2024-02-01 | 230.96 | 5.77 | 2024-01-20 | 7 | 20.57 | 1 | 230.96 | 36 | SO58927 | 2024-01-27 | 18.48 | 143.96 | 32.99 | |||
| SO65182_18 | 130D-4FE9-83 | PO16385138124 | 6 | 296 | 563 | 249 | 9 | 2024-05-02 | 1430.44 | 35.76 | 2024-04-20 | 1 | 1481.94 | 1 | 1430.44 | 18 | SO65182 | 2024-04-27 | 114.44 | 1481.94 | 1430.44 | |||
| SO51694_6 | 75B1-457C-8C | PO19691118743 | 19 | 291 | 475 | 353 | 6 | 2023-10-02 | 83.99 | 2.10 | 2023-09-20 | 2 | 26.18 | 1 | 83.99 | 6 | SO51694 | 2023-09-27 | 6.72 | 52.35 | 41.99 | |||
| SO57046_11 | 52CC-460F-B3 | PO14500161818 | 100 | 282 | 491 | 2 | 650 | 1 | 8.77 | 2024-01-02 | 438.40 | 10.74 | 2023-12-21 | 14 | 41.57 | 1 | 429.63 | 11 | SO57046 | 2023-12-28 | 34.37 | 582.01 | 31.31 | 0.02 |
| SO49062_33 | D3FD-415F-A5 | PO928133820 | 98 | 288 | 399 | 484 | 10 | 2023-04-04 | 67.55 | 1.69 | 2023-03-23 | 2 | 24.99 | 1 | 67.55 | 33 | SO49062 | 2023-03-30 | 5.40 | 49.99 | 33.77 | |||
| SO47422_8 | 9D8D-4481-B6 | PO3915123127 | 100 | 283 | 224 | 2 | 130 | 4 | 1.20 | 2022-11-02 | 60.16 | 1.47 | 2022-10-21 | 12 | 5.23 | 1 | 58.96 | 8 | SO47422 | 2022-10-28 | 4.72 | 62.76 | 5.01 | 0.02 |
| SO48005_50 | 634C-42C5-AB | PO13427183371 | 100 | 292 | 458 | 638 | 7 | 2023-01-02 | 179.98 | 4.50 | 2022-12-21 | 4 | 30.93 | 1 | 179.98 | 50 | SO48005 | 2022-12-28 | 14.40 | 123.73 | 44.99 | |||
| SO65168_7 | 7CDD-4B4A-AE | PO18038110078 | 100 | 287 | 603 | 509 | 4 | 2024-05-02 | 218.68 | 5.47 | 2024-04-20 | 3 | 53.94 | 1 | 218.68 | 7 | SO65168 | 2024-04-27 | 17.49 | 161.82 | 72.89 | |||
| SO65259_2 | A72A-4E95-A8 | PO9251144255 | 100 | 285 | 577 | 351 | 5 | 2024-05-02 | 728.91 | 18.22 | 2024-04-20 | 1 | 755.15 | 1 | 728.91 | 2 | SO65259 | 2024-04-27 | 58.31 | 755.15 | 728.91 | |||
| SO48090_4 | E7D1-44A3-B2 | PO9512117066 | 100 | 285 | 224 | 135 | 5 | 2023-01-02 | 10.37 | 0.26 | 2022-12-21 | 2 | 5.23 | 1 | 10.37 | 4 | SO48090 | 2022-12-28 | 0.83 | 10.46 | 5.19 | |||
| SO50682_29 | 1145-4AD1-B8 | PO12354142084 | 100 | 283 | 308 | 197 | 3 | 2023-08-02 | 2232.82 | 55.82 | 2023-07-21 | 3 | 660.91 | 1 | 2232.82 | 29 | SO50682 | 2023-07-28 | 178.63 | 1982.74 | 744.27 | |||
| SO51774_37 | 30BA-400A-89 | PO2668194455 | 100 | 292 | 400 | 535 | 7 | 2023-10-02 | 297.22 | 7.43 | 2023-09-20 | 8 | 27.49 | 1 | 297.22 | 37 | SO51774 | 2023-09-27 | 23.78 | 219.94 | 37.15 | |||
| SO46959_32 | 9007-4F97-9C | PO16733197949 | 19 | 291 | 216 | 533 | 6 | 2022-10-02 | 100.93 | 2.52 | 2022-09-20 | 5 | 13.88 | 1 | 100.93 | 32 | SO46959 | 2022-09-27 | 8.07 | 69.39 | 20.19 | |||
| SO45305_3 | AC1B-4242-9C | PO11600132440 | 19 | 288 | 212 | 569 | 6 | 2022-04-04 | 121.12 | 3.03 | 2022-03-23 | 6 | 12.03 | 1 | 121.12 | 3 | SO45305 | 2022-03-30 | 9.69 | 72.17 | 20.19 | |||
| SO57080_15 | A38F-4C07-81 | PO957167312 | 98 | 288 | 513 | 376 | 10 | 2024-01-02 | 218.45 | 5.46 | 2023-12-21 | 1 | 199.38 | 1 | 218.45 | 15 | SO57080 | 2023-12-28 | 17.48 | 199.38 | 218.45 | |||
| SO55243_19 | 2457-46EE-88 | PO15312160912 | 19 | 291 | 234 | 299 | 6 | 2023-12-02 | 239.95 | 6.00 | 2023-11-20 | 8 | 38.49 | 1 | 239.95 | 19 | SO55243 | 2023-11-27 | 19.20 | 307.94 | 29.99 | |||
| SO57132_25 | C079-4BDD-A1 | PO5829189627 | 36 | 295 | 471 | 266 | 8 | 2024-01-02 | 228.60 | 5.72 | 2023-12-21 | 6 | 23.75 | 1 | 228.60 | 25 | SO57132 | 2023-12-28 | 18.29 | 142.49 | 38.10 | |||
| SO63290_10 | 0F43-405E-B8 | PO9077159728 | 19 | 291 | 472 | 100 | 6 | 2024-04-03 | 114.30 | 2.86 | 2024-03-22 | 3 | 23.75 | 1 | 114.30 | 10 | SO63290 | 2024-03-29 | 9.14 | 71.25 | 38.10 | |||
| SO46605_11 | 88F6-4172-B3 | PO19314112090 | 100 | 283 | 333 | 622 | 3 | 2022-09-01 | 1409.38 | 35.23 | 2022-08-20 | 3 | 486.71 | 1 | 1409.38 | 11 | SO46605 | 2022-08-27 | 112.75 | 1460.12 | 469.79 | |||
| SO63257_12 | B81B-4565-85 | PO5771197507 | 100 | 282 | 471 | 79 | 3 | 2024-04-03 | 152.40 | 3.81 | 2024-03-22 | 4 | 23.75 | 1 | 152.40 | 12 | SO63257 | 2024-03-29 | 12.19 | 95.00 | 38.10 | |||
| SO50191_19 | 1DDA-4B5A-95 | PO19546193423 | 100 | 285 | 368 | 206 | 5 | 2023-07-02 | 1466.01 | 36.65 | 2023-06-20 | 1 | 1518.79 | 1 | 1466.01 | 19 | SO50191 | 2023-06-27 | 117.28 | 1518.79 | 1466.01 | |||
| SO63209_22 | 1C23-4681-BF | PO11223142410 | 100 | 292 | 524 | 632 | 7 | 2024-04-03 | 633.72 | 15.84 | 2024-03-22 | 4 | 144.59 | 1 | 633.72 | 22 | SO63209 | 2024-03-29 | 50.70 | 578.38 | 158.43 | |||
| SO69426_41 | 4194-45D7-B6 | PO13427130433 | 100 | 292 | 463 | 638 | 7 | 2024-07-02 | 102.86 | 2.57 | 2024-06-20 | 7 | 9.16 | 1 | 102.86 | 41 | SO69426 | 2024-06-27 | 8.23 | 64.12 | 14.69 | |||
| SO47720_32 | 30D0-4EF0-B1 | PO7859164121 | 100 | 287 | 273 | 221 | 4 | 2022-12-02 | 202.33 | 5.06 | 2022-11-20 | 1 | 187.16 | 1 | 202.33 | 32 | SO47720 | 2022-11-27 | 16.19 | 187.16 | 202.33 | |||
| SO49828_42 | 8223-49DF-83 | PO14732189078 | 19 | 291 | 343 | 514 | 6 | 2023-06-02 | 4697.94 | 117.45 | 2023-05-21 | 10 | 486.71 | 1 | 4697.94 | 42 | SO49828 | 2023-05-28 | 375.84 | 4867.07 | 469.79 | |||
| SO47721_44 | 1629-4338-BE | PO8410190478 | 98 | 288 | 460 | 2 | 538 | 10 | 11.48 | 2022-12-02 | 574.14 | 14.07 | 2022-11-20 | 11 | 37.12 | 1 | 562.65 | 44 | SO47721 | 2022-11-27 | 45.01 | 408.33 | 52.19 | 0.02 |
| SO53525_17 | F162-4A87-B4 | PO1305155715 | 100 | 292 | 465 | 319 | 7 | 2023-11-02 | 58.78 | 1.47 | 2023-10-21 | 4 | 9.16 | 1 | 58.78 | 17 | SO53525 | 2023-10-28 | 4.70 | 36.64 | 14.69 | |||
| SO69430_2 | 5918-4A34-B0 | PO13311147802 | 100 | 292 | 605 | 301 | 7 | 2024-07-02 | 1295.98 | 32.40 | 2024-06-20 | 4 | 343.65 | 1 | 1295.98 | 2 | SO69430 | 2024-06-27 | 103.68 | 1374.60 | 323.99 | |||
| SO58948_37 | 1534-4AB5-81 | PO11774195497 | 6 | 296 | 491 | 682 | 9 | 2024-02-01 | 129.58 | 3.24 | 2024-01-20 | 4 | 41.57 | 1 | 129.58 | 37 | SO58948 | 2024-01-27 | 10.37 | 166.29 | 32.39 | |||
| SO47427_9 | 61AA-44CA-99 | PO4640137176 | 100 | 287 | 410 | 648 | 4 | 2022-11-02 | 72.89 | 1.82 | 2022-10-21 | 2 | 26.97 | 1 | 72.89 | 9 | SO47427 | 2022-10-28 | 5.83 | 53.94 | 36.45 | |||
| SO53557_2 | DCED-40C5-8E | PO12093112290 | 6 | 296 | 503 | 285 | 9 | 2023-11-02 | 200.05 | 5.00 | 2023-10-21 | 1 | 199.85 | 1 | 200.05 | 2 | SO53557 | 2023-10-28 | 16.00 | 199.85 | 200.05 | |||
| SO67327_13 | 2D2C-4C57-A2 | PO6467126287 | 100 | 283 | 240 | 660 | 3 | 2024-06-02 | 858.90 | 21.47 | 2024-05-21 | 1 | 868.63 | 1 | 858.90 | 13 | SO67327 | 2024-05-28 | 68.71 | 868.63 | 858.90 | |||
| SO49486_3 | 7DA8-4E15-AE | PO16124154108 | 100 | 282 | 329 | 649 | 4 | 2023-05-02 | 469.79 | 11.74 | 2023-04-20 | 1 | 486.71 | 1 | 469.79 | 3 | SO49486 | 2023-04-27 | 37.58 | 486.71 | 469.79 | |||
| SO58963_9 | 6ADC-4485-8C | PO841129336 | 100 | 286 | 517 | 254 | 1 | 2024-02-01 | 126.34 | 3.16 | 2024-01-20 | 4 | 23.37 | 1 | 126.34 | 9 | SO58963 | 2024-01-27 | 10.11 | 93.49 | 31.58 | |||
| SO51822_60 | EEEE-45C1-87 | PO8845178563 | 100 | 282 | 517 | 546 | 3 | 2023-10-02 | 126.34 | 3.16 | 2023-09-20 | 4 | 23.37 | 1 | 126.34 | 60 | SO51822 | 2023-09-27 | 10.11 | 93.49 | 31.58 | |||
| SO69437_55 | AEEE-4ABB-A6 | PO12702116983 | 100 | 292 | 231 | 175 | 7 | 2024-07-02 | 239.95 | 6.00 | 2024-06-20 | 8 | 38.49 | 1 | 239.95 | 55 | SO69437 | 2024-06-27 | 19.20 | 307.94 | 29.99 | |||
| SO50716_6 | 0B80-45BD-98 | PO18299117393 | 19 | 291 | 456 | 118 | 6 | 2023-08-02 | 224.97 | 5.62 | 2023-07-21 | 5 | 30.93 | 1 | 224.97 | 6 | SO50716 | 2023-07-28 | 18.00 | 154.67 | 44.99 | |||
| SO45070_1 | B035-4728-8C | PO5626126979 | 100 | 283 | 316 | 166 | 4 | 2022-03-04 | 874.79 | 21.87 | 2022-02-20 | 1 | 884.71 | 1 | 874.79 | 1 | SO45070 | 2022-02-27 | 69.98 | 884.71 | 874.79 | |||
| SO53577_22 | A44D-449C-80 | PO5713160840 | 98 | 288 | 521 | 52 | 10 | 2023-11-02 | 16.27 | 0.41 | 2023-10-21 | 1 | 12.04 | 1 | 16.27 | 22 | SO53577 | 2023-10-28 | 1.30 | 12.04 | 16.27 | |||
| SO50284_44 | F8D1-49E1-A5 | PO4901178867 | 19 | 284 | 458 | 84 | 6 | 2023-07-02 | 404.95 | 10.12 | 2023-06-20 | 9 | 30.93 | 1 | 404.95 | 44 | SO50284 | 2023-06-27 | 32.40 | 278.40 | 44.99 | |||
| SO43871_8 | 01F1-4AD5-A5 | PO13572145817 | 100 | 287 | 232 | 527 | 3 | 2021-10-02 | 57.68 | 1.44 | 2021-09-20 | 2 | 31.72 | 1 | 57.68 | 8 | SO43871 | 2021-09-27 | 4.61 | 63.45 | 28.84 | |||
| SO46343_10 | 2DB3-460D-85 | PO15167181233 | 100 | 283 | 338 | 273 | 4 | 2022-08-02 | 419.46 | 10.49 | 2022-07-21 | 1 | 413.15 | 1 | 419.46 | 10 | SO46343 | 2022-07-28 | 33.56 | 413.15 | 419.46 | |||
| SO51789_34 | A5AF-4504-83 | PO18618169495 | 100 | 286 | 484 | 605 | 1 | 2023-10-02 | 28.62 | 0.72 | 2023-09-20 | 6 | 2.97 | 1 | 28.62 | 34 | SO51789 | 2023-09-27 | 2.29 | 17.84 | 4.77 | |||
| SO46630_36 | F512-40F2-91 | PO12644161356 | 100 | 285 | 236 | 530 | 5 | 2022-09-01 | 288.40 | 7.21 | 2022-08-20 | 10 | 29.08 | 1 | 288.40 | 36 | SO46630 | 2022-08-27 | 23.07 | 290.81 | 28.84 | |||
| SO48787_4 | 0EAC-4469-9A | PO6409126669 | 100 | 281 | 327 | 292 | 4 | 2023-03-04 | 469.79 | 11.74 | 2023-02-20 | 1 | 486.71 | 1 | 469.79 | 4 | SO48787 | 2023-02-27 | 37.58 | 486.71 | 469.79 | |||
| SO50738_6 | 531C-4E52-80 | PO3915159731 | 100 | 281 | 447 | 130 | 4 | 2023-08-02 | 15.00 | 0.38 | 2023-07-21 | 1 | 10.31 | 1 | 15.00 | 6 | SO50738 | 2023-07-28 | 1.20 | 10.31 | 15.00 | |||
| SO53560_46 | 3D25-4203-A4 | PO7685199983 | 100 | 283 | 493 | 539 | 2 | 2023-11-02 | 600.16 | 15.00 | 2023-10-21 | 3 | 199.85 | 1 | 600.16 | 46 | SO53560 | 2023-10-28 | 48.01 | 599.56 | 200.05 | |||
| SO45069_12 | 720B-4C18-89 | PO5365112854 | 100 | 281 | 324 | 161 | 2 | 2022-03-04 | 419.46 | 10.49 | 2022-02-20 | 1 | 413.15 | 1 | 419.46 | 12 | SO45069 | 2022-02-27 | 33.56 | 413.15 | 419.46 | |||
| SO49856_12 | 6ADC-4789-8A | PO18444116791 | 19 | 291 | 435 | 227 | 6 | 2023-06-02 | 973.36 | 24.33 | 2023-05-21 | 3 | 300.12 | 1 | 973.36 | 12 | SO49856 | 2023-05-28 | 77.87 | 900.36 | 324.45 | |||
| SO47677_8 | 2C43-407F-B3 | PO13688179339 | 100 | 282 | 448 | 475 | 4 | 2022-12-02 | 59.97 | 1.50 | 2022-11-20 | 5 | 8.25 | 1 | 59.97 | 8 | SO47677 | 2022-11-27 | 4.80 | 41.23 | 11.99 | |||
| SO63282_1 | F7EE-4F12-B1 | PO3567146912 | 100 | 292 | 586 | 193 | 7 | 2024-04-03 | 3563.28 | 89.08 | 2024-03-22 | 8 | 461.44 | 1 | 3563.28 | 1 | SO63282 | 2024-03-29 | 285.06 | 3691.56 | 445.41 | |||
| SO46044_25 | 029B-4675-9A | PO16733123313 | 19 | 288 | 342 | 533 | 6 | 2022-07-02 | 419.46 | 10.49 | 2022-06-20 | 1 | 413.15 | 1 | 419.46 | 25 | SO46044 | 2022-06-27 | 33.56 | 413.15 | 419.46 | |||
| SO71798_12 | AFA9-4B18-AD | PO16994135863 | 100 | 283 | 605 | 306 | 3 | 2024-08-02 | 647.99 | 16.20 | 2024-07-21 | 2 | 343.65 | 1 | 647.99 | 12 | SO71798 | 2024-07-28 | 51.84 | 687.30 | 323.99 | |||
| SO69532_44 | 27FB-4A86-85 | PO3799165791 | 100 | 282 | 487 | 312 | 4 | 2024-07-02 | 131.98 | 3.30 | 2024-06-20 | 4 | 20.57 | 1 | 131.98 | 44 | SO69532 | 2024-06-27 | 10.56 | 82.27 | 32.99 | |||
| SO43682_1 | ECD4-43A8-A8 | PO1566124200 | 100 | 281 | 319 | 486 | 2 | 2021-09-01 | 1749.59 | 43.74 | 2021-08-20 | 2 | 884.71 | 1 | 1749.59 | 1 | SO43682 | 2021-08-27 | 139.97 | 1769.42 | 874.79 | |||
| SO69451_13 | EE16-4615-B7 | PO9918189570 | 100 | 285 | 523 | 260 | 5 | 2024-07-02 | 31.58 | 0.79 | 2024-06-20 | 1 | 23.37 | 1 | 31.58 | 13 | SO69451 | 2024-06-27 | 2.53 | 23.37 | 31.58 | |||
| SO69466_35 | 8B97-4CC6-8A | PO2523169620 | 100 | 287 | 376 | 167 | 4 | 2024-07-02 | 2932.02 | 73.30 | 2024-06-20 | 2 | 1554.95 | 1 | 2932.02 | 35 | SO69466 | 2024-06-27 | 234.56 | 3109.90 | 1466.01 |
Generated 2024-09-19 23:25:12.243 UTC