[ROOT] dt FactResellerSale < WHERE DimSalesTerritoryId EQ ALL SHUFFLE < SKIP 1310 > < 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 |
---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
SO55259_13 | 68EA-4A46-81 | PO11687179986 | 100 | 283 | 558 | 691 | 2 | 2023-12-03 | 728.98 | 18.22 | 2023-11-21 | 3 | 179.82 | 1 | 728.98 | 13 | SO55259 | 2023-11-28 | 58.32 | 539.45 | 242.99 | |||
SO44778_7 | 32B2-4FA6-81 | PO3190112662 | 100 | 281 | 332 | 575 | 2 | 2022-02-02 | 1677.84 | 41.95 | 2022-01-21 | 4 | 413.15 | 1 | 1677.84 | 7 | SO44778 | 2022-01-28 | 134.23 | 1652.59 | 419.46 | |||
SO48307_4 | 7DE5-4D74-A7 | PO17545123793 | 19 | 291 | 433 | 155 | 6 | 2023-02-02 | 1297.81 | 32.45 | 2023-01-21 | 4 | 300.12 | 1 | 1297.81 | 4 | SO48307 | 2023-01-28 | 103.82 | 1200.48 | 324.45 | |||
SO48771_14 | E98F-4302-92 | PO8410125811 | 98 | 288 | 464 | 538 | 10 | 2023-03-05 | 70.64 | 1.77 | 2023-02-21 | 5 | 9.71 | 1 | 70.64 | 14 | SO48771 | 2023-02-28 | 5.65 | 48.57 | 14.13 | |||
SO51138_16 | 685D-4916-A6 | PO9338137293 | 100 | 293 | 566 | 13 | 451 | 1 | 150.33 | 2023-09-02 | 1002.17 | 21.30 | 2023-08-21 | 3 | 461.44 | 1 | 851.85 | 16 | SO51138 | 2023-08-28 | 68.15 | 1384.33 | 334.06 | 0.15 |
SO47042_45 | 42DB-4E2E-B9 | PO5858114009 | 100 | 285 | 412 | 566 | 5 | 2022-10-03 | 540.39 | 13.51 | 2022-09-21 | 3 | 133.30 | 1 | 540.39 | 45 | SO47042 | 2022-09-28 | 43.23 | 399.89 | 180.13 | |||
SO58951_31 | 96F8-470F-9B | PO11397163065 | 36 | 295 | 475 | 176 | 8 | 2024-02-02 | 167.98 | 4.20 | 2024-01-21 | 4 | 26.18 | 1 | 167.98 | 31 | SO58951 | 2024-01-28 | 13.44 | 104.71 | 41.99 | |||
SO59012_31 | 6620-4CEA-A0 | PO7685122244 | 100 | 283 | 472 | 539 | 2 | 2024-02-02 | 152.40 | 3.81 | 2024-01-21 | 4 | 23.75 | 1 | 152.40 | 31 | SO59012 | 2024-01-28 | 12.19 | 95.00 | 38.10 | |||
SO57127_11 | 31B1-4EAC-B8 | PO7801155405 | 6 | 296 | 562 | 87 | 9 | 2024-01-03 | 2860.88 | 71.52 | 2023-12-22 | 2 | 1481.94 | 1 | 2860.88 | 11 | SO57127 | 2023-12-29 | 228.87 | 2963.88 | 1430.44 | |||
SO48010_19 | 81A7-4B68-B2 | PO12702168891 | 100 | 292 | 297 | 175 | 7 | 2023-01-03 | 3680.73 | 92.02 | 2022-12-22 | 5 | 653.70 | 1 | 3680.73 | 19 | SO48010 | 2022-12-29 | 294.46 | 3268.49 | 736.15 | |||
SO48002_1 | C49A-4171-8A | PO14326161105 | 100 | 281 | 329 | 107 | 2 | 2023-01-03 | 2818.76 | 70.47 | 2022-12-22 | 6 | 486.71 | 1 | 2818.76 | 1 | SO48002 | 2022-12-29 | 225.50 | 2920.24 | 469.79 | |||
SO46049_25 | 2C79-41BD-8A | PO15689114654 | 100 | 283 | 330 | 328 | 4 | 2022-07-03 | 1677.84 | 41.95 | 2022-06-21 | 4 | 413.15 | 1 | 1677.84 | 25 | SO46049 | 2022-06-28 | 134.23 | 1652.59 | 419.46 | |||
SO50304_32 | 9338-4FCD-A5 | PO5771132420 | 100 | 282 | 379 | 79 | 3 | 2023-07-03 | 5235.75 | 130.89 | 2023-06-21 | 4 | 1320.68 | 1 | 5235.75 | 32 | SO50304 | 2023-06-28 | 418.86 | 5282.74 | 1308.94 | |||
SO51836_28 | 8AA7-498C-8C | PO6351139034 | 100 | 281 | 243 | 255 | 4 | 2023-10-03 | 858.90 | 21.47 | 2023-09-21 | 1 | 868.63 | 1 | 858.90 | 28 | SO51836 | 2023-09-28 | 68.71 | 868.63 | 858.90 | |||
SO44749_16 | 6F66-42B6-AB | PO17545111622 | 19 | 288 | 328 | 155 | 6 | 2022-02-02 | 838.92 | 20.97 | 2022-01-21 | 2 | 413.15 | 1 | 838.92 | 16 | SO44749 | 2022-01-28 | 67.11 | 826.29 | 419.46 | |||
SO53502_34 | DC5E-4F14-87 | PO11774190456 | 6 | 294 | 561 | 14 | 682 | 9 | 190.73 | 2023-11-03 | 953.63 | 19.07 | 2023-10-22 | 1 | 1481.94 | 1 | 762.90 | 34 | SO53502 | 2023-10-29 | 61.03 | 1481.94 | 953.63 | 0.20 |
SO48041_7 | 5338-4283-B9 | PO2320117440 | 100 | 282 | 417 | 529 | 4 | 2023-01-03 | 324.45 | 8.11 | 2022-12-22 | 1 | 300.12 | 1 | 324.45 | 7 | SO48041 | 2022-12-29 | 25.96 | 300.12 | 324.45 | |||
SO44494_1 | 8EF7-4B3A-A4 | PO18386158045 | 100 | 281 | 320 | 558 | 2 | 2022-01-03 | 838.92 | 20.97 | 2021-12-22 | 2 | 413.15 | 1 | 838.92 | 1 | SO44494 | 2021-12-29 | 67.11 | 826.29 | 419.46 | |||
SO69526_5 | E43D-4369-A8 | PO7453115394 | 100 | 283 | 222 | 3 | 108 | 2 | 16.36 | 2024-07-03 | 327.16 | 7.77 | 2024-06-21 | 17 | 13.09 | 1 | 310.80 | 5 | SO69526 | 2024-06-28 | 24.86 | 222.47 | 19.24 | 0.05 |
SO69421_10 | 61D3-4E33-AF | PO14587164345 | 100 | 293 | 561 | 199 | 1 | 2024-07-03 | 4291.33 | 107.28 | 2024-06-21 | 3 | 1481.94 | 1 | 4291.33 | 10 | SO69421 | 2024-06-28 | 343.31 | 4445.81 | 1430.44 | |||
SO71839_3 | 8F89-4B1E-A8 | PO1537119063 | 100 | 285 | 490 | 2 | 611 | 5 | 8.77 | 2024-08-03 | 438.40 | 10.74 | 2024-07-22 | 14 | 41.57 | 1 | 429.63 | 3 | SO71839 | 2024-07-29 | 34.37 | 582.01 | 31.31 | 0.02 |
SO49501_40 | EF67-4713-BD | PO17574111786 | 19 | 291 | 224 | 678 | 6 | 2023-05-03 | 25.93 | 0.65 | 2023-04-21 | 5 | 5.23 | 1 | 25.93 | 40 | SO49501 | 2023-04-28 | 2.07 | 26.15 | 5.19 | |||
SO53570_25 | 412A-483A-A3 | PO9483124574 | 100 | 283 | 240 | 54 | 2 | 2023-11-03 | 1717.80 | 42.95 | 2023-10-22 | 2 | 868.63 | 1 | 1717.80 | 25 | SO53570 | 2023-10-29 | 137.42 | 1737.27 | 858.90 | |||
SO47397_15 | B964-4D2F-B3 | PO11107130091 | 19 | 284 | 221 | 156 | 6 | 2022-11-03 | 60.56 | 1.51 | 2022-10-22 | 3 | 13.88 | 1 | 60.56 | 15 | SO47397 | 2022-10-29 | 4.84 | 41.63 | 20.19 | |||
SO48028_18 | B23F-4743-B9 | PO928137953 | 98 | 288 | 458 | 484 | 10 | 2023-01-03 | 179.98 | 4.50 | 2022-12-22 | 4 | 30.93 | 1 | 179.98 | 18 | SO48028 | 2022-12-29 | 14.40 | 123.73 | 44.99 | |||
SO51170_2 | C764-4927-87 | PO5423111367 | 36 | 290 | 520 | 639 | 8 | 2023-09-02 | 31.58 | 0.79 | 2023-08-21 | 1 | 23.37 | 1 | 31.58 | 2 | SO51170 | 2023-08-28 | 2.53 | 23.37 | 31.58 | |||
SO61243_2 | 0370-4B1B-9D | PO7859152962 | 100 | 287 | 606 | 221 | 4 | 2024-03-04 | 647.99 | 16.20 | 2024-02-21 | 2 | 343.65 | 1 | 647.99 | 2 | SO61243 | 2024-02-28 | 51.84 | 687.30 | 323.99 | |||
SO49166_15 | 142E-4351-A4 | PO8845115490 | 100 | 282 | 456 | 546 | 3 | 2023-04-05 | 134.98 | 3.37 | 2023-03-24 | 3 | 30.93 | 1 | 134.98 | 15 | SO49166 | 2023-03-31 | 10.80 | 92.80 | 44.99 | |||
SO49053_32 | 5BE4-4969-A1 | PO16414175823 | 100 | 289 | 365 | 236 | 1 | 2023-04-05 | 647.99 | 16.20 | 2023-03-24 | 1 | 598.44 | 1 | 647.99 | 32 | SO49053 | 2023-03-31 | 51.84 | 598.44 | 647.99 | |||
SO46988_40 | 2D2E-4EC3-AC | PO12499171502 | 100 | 282 | 273 | 78 | 4 | 2022-10-03 | 607.00 | 15.17 | 2022-09-21 | 3 | 187.16 | 1 | 607.00 | 40 | SO46988 | 2022-09-28 | 48.56 | 561.47 | 202.33 | |||
SO47450_7 | 7E50-416D-A2 | PO9483124566 | 100 | 281 | 327 | 2 | 54 | 2 | 118.07 | 2022-11-03 | 5903.74 | 144.64 | 2022-10-22 | 13 | 486.71 | 1 | 5785.67 | 7 | SO47450 | 2022-10-29 | 462.85 | 6327.19 | 454.13 | 0.02 |
SO48323_2 | 5C46-4F8D-9E | PO14239114372 | 19 | 291 | 224 | 550 | 6 | 2023-02-02 | 10.37 | 0.26 | 2023-01-21 | 2 | 5.23 | 1 | 10.37 | 2 | SO48323 | 2023-01-28 | 0.83 | 10.46 | 5.19 | |||
SO51751_53 | 257C-4EC8-98 | PO11368156185 | 36 | 295 | 603 | 687 | 8 | 2023-10-03 | 364.47 | 9.11 | 2023-09-21 | 5 | 53.94 | 1 | 364.47 | 53 | SO51751 | 2023-09-28 | 29.16 | 269.71 | 72.89 | |||
SO63171_15 | 6618-4F16-BE | PO580178064 | 36 | 295 | 562 | 230 | 8 | 2024-04-04 | 2860.88 | 71.52 | 2024-03-23 | 2 | 1481.94 | 1 | 2860.88 | 15 | SO63171 | 2024-03-30 | 228.87 | 2963.88 | 1430.44 | |||
SO58922_31 | 2509-4E40-B4 | PO16385147925 | 6 | 296 | 572 | 249 | 9 | 2024-02-02 | 445.41 | 11.14 | 2024-01-21 | 1 | 461.44 | 1 | 445.41 | 31 | SO58922 | 2024-01-28 | 35.63 | 461.44 | 445.41 | |||
SO50295_6 | 575E-4F7A-9C | PO4466165095 | 19 | 291 | 352 | 352 | 6 | 2023-07-03 | 1242.85 | 31.07 | 2023-06-21 | 1 | 1117.86 | 1 | 1242.85 | 6 | SO50295 | 2023-06-28 | 99.43 | 1117.86 | 1242.85 | |||
SO71783_18 | 7E03-4B8A-BA | PO19343113609 | 100 | 282 | 471 | 3 | 24 | 4 | 26.19 | 2024-08-03 | 523.88 | 12.44 | 2024-07-22 | 15 | 23.75 | 1 | 497.68 | 18 | SO71783 | 2024-07-29 | 39.81 | 356.24 | 34.93 | 0.05 |
SO51156_5 | C598-4D75-B4 | PO4930142451 | 19 | 291 | 474 | 3 | 425 | 6 | 30.80 | 2023-09-02 | 615.91 | 14.63 | 2023-08-21 | 16 | 26.18 | 1 | 585.12 | 5 | SO51156 | 2023-08-28 | 46.81 | 418.82 | 38.49 | 0.05 |
SO49888_35 | 01BB-49D0-BD | PO6699147895 | 100 | 283 | 343 | 234 | 2 | 2023-06-03 | 2818.76 | 70.47 | 2023-05-22 | 6 | 486.71 | 1 | 2818.76 | 35 | SO49888 | 2023-05-29 | 225.50 | 2920.24 | 469.79 | |||
SO57137_18 | 9401-4518-A4 | PO6438194874 | 100 | 281 | 593 | 309 | 4 | 2024-01-03 | 677.99 | 16.95 | 2023-12-22 | 2 | 308.22 | 1 | 677.99 | 18 | SO57137 | 2023-12-29 | 54.24 | 616.44 | 338.99 | |||
SO44301_23 | 34BE-4E85-85 | PO10730158868 | 100 | 287 | 285 | 491 | 4 | 2021-12-03 | 178.58 | 4.46 | 2021-11-21 | 1 | 176.20 | 1 | 178.58 | 23 | SO44301 | 2021-11-28 | 14.29 | 176.20 | 178.58 | |||
SO50293_9 | D649-4CE8-91 | PO3596144572 | 100 | 285 | 308 | 476 | 5 | 2023-07-03 | 744.27 | 18.61 | 2023-06-21 | 1 | 660.91 | 1 | 744.27 | 9 | SO50293 | 2023-06-28 | 59.54 | 660.91 | 744.27 | |||
SO48780_2 | F139-41F4-83 | PO5626121558 | 100 | 281 | 383 | 166 | 4 | 2023-03-05 | 600.26 | 15.01 | 2023-02-21 | 1 | 605.65 | 1 | 600.26 | 2 | SO48780 | 2023-02-28 | 48.02 | 605.65 | 600.26 | |||
SO59028_6 | F0C6-4E08-A8 | PO4814117936 | 36 | 295 | 483 | 464 | 8 | 2024-02-02 | 144.00 | 3.60 | 2024-01-21 | 2 | 44.88 | 1 | 144.00 | 6 | SO59028 | 2024-01-28 | 11.52 | 89.76 | 72.00 | |||
SO48780_26 | F139-41F4-83 | PO5626121558 | 100 | 281 | 422 | 166 | 4 | 2023-03-05 | 135.08 | 3.38 | 2023-02-21 | 2 | 49.98 | 1 | 135.08 | 26 | SO48780 | 2023-02-28 | 10.81 | 99.96 | 67.54 | |||
SO58927_22 | BEF7-43AF-A2 | PO15515112432 | 100 | 292 | 482 | 481 | 7 | 2024-02-02 | 10.79 | 0.27 | 2024-01-21 | 2 | 3.36 | 1 | 10.79 | 22 | SO58927 | 2024-01-28 | 0.86 | 6.72 | 5.39 | |||
SO43662_2 | 2E53-4802-85 | PO18444174044 | 19 | 288 | 342 | 227 | 6 | 2021-09-02 | 2097.29 | 52.43 | 2021-08-21 | 5 | 413.15 | 1 | 2097.29 | 2 | SO43662 | 2021-08-28 | 167.78 | 2065.73 | 419.46 | |||
SO69505_3 | FE34-45B3-8D | PO5684197579 | 100 | 282 | 298 | 385 | 4 | 2024-07-03 | 1619.52 | 40.49 | 2024-06-21 | 2 | 739.04 | 1 | 1619.52 | 3 | SO69505 | 2024-06-28 | 129.56 | 1478.08 | 809.76 | |||
SO67273_52 | 9BAE-4E69-B9 | PO13688176638 | 100 | 282 | 471 | 475 | 4 | 2024-06-03 | 266.70 | 6.67 | 2024-05-22 | 7 | 23.75 | 1 | 266.70 | 52 | SO67273 | 2024-05-29 | 21.34 | 166.24 | 38.10 | |||
SO46325_2 | D29B-490E-A9 | PO19488134185 | 100 | 283 | 212 | 57 | 3 | 2022-08-03 | 141.31 | 3.53 | 2022-07-22 | 7 | 12.03 | 1 | 141.31 | 2 | SO46325 | 2022-07-29 | 11.30 | 84.19 | 20.19 | |||
SO58922_33 | 2509-4E40-B4 | PO16385147925 | 6 | 296 | 585 | 249 | 9 | 2024-02-02 | 1336.23 | 33.41 | 2024-01-21 | 3 | 461.44 | 1 | 1336.23 | 33 | SO58922 | 2024-01-28 | 106.90 | 1384.33 | 445.41 | |||
SO46959_44 | 9007-4F97-9C | PO16733197949 | 19 | 291 | 254 | 533 | 6 | 2022-10-03 | 1287.57 | 32.19 | 2022-09-21 | 7 | 170.14 | 1 | 1287.57 | 44 | SO46959 | 2022-09-28 | 103.01 | 1191.00 | 183.94 | |||
SO46356_5 | 30BA-40DA-B4 | PO783139385 | 100 | 286 | 215 | 91 | 1 | 2022-08-03 | 20.19 | 0.50 | 2022-07-22 | 1 | 12.03 | 1 | 20.19 | 5 | SO46356 | 2022-07-29 | 1.61 | 12.03 | 20.19 | |||
SO47996_27 | B6EA-4582-9E | PO15370152849 | 100 | 283 | 294 | 381 | 3 | 2023-01-03 | 744.27 | 18.61 | 2022-12-22 | 1 | 660.91 | 1 | 744.27 | 27 | SO47996 | 2022-12-29 | 59.54 | 660.91 | 744.27 | |||
SO53536_29 | 5C09-4051-92 | PO18299189909 | 19 | 291 | 400 | 118 | 6 | 2023-11-03 | 297.22 | 7.43 | 2023-10-22 | 8 | 27.49 | 1 | 297.22 | 29 | SO53536 | 2023-10-29 | 23.78 | 219.94 | 37.15 | |||
SO51132_1 | D4A8-472C-A4 | PO18444136544 | 19 | 291 | 418 | 227 | 6 | 2023-09-02 | 713.80 | 17.84 | 2023-08-21 | 2 | 360.94 | 1 | 713.80 | 1 | SO51132 | 2023-08-28 | 57.10 | 721.89 | 356.90 | |||
SO50209_22 | D138-4E7C-86 | PO15573136083 | 100 | 293 | 233 | 487 | 1 | 2023-07-03 | 115.36 | 2.88 | 2023-06-21 | 4 | 29.08 | 1 | 115.36 | 22 | SO50209 | 2023-06-28 | 9.23 | 116.32 | 28.84 | |||
SO57151_3 | 017C-41CB-BB | PO5162182690 | 100 | 289 | 378 | 669 | 1 | 2024-01-03 | 1466.01 | 36.65 | 2023-12-22 | 1 | 1554.95 | 1 | 1466.01 | 3 | SO57151 | 2023-12-29 | 117.28 | 1554.95 | 1466.01 | |||
SO44567_2 | A14C-49FF-A8 | PO7917171062 | 100 | 287 | 346 | 401 | 1 | 2022-01-03 | 4079.99 | 102.00 | 2021-12-22 | 2 | 1912.15 | 1 | 4079.99 | 2 | SO44567 | 2021-12-29 | 326.40 | 3824.31 | 2039.99 | |||
SO47012_5 | 5043-4C8B-B3 | PO1914167487 | 19 | 284 | 460 | 2 | 66 | 6 | 14.61 | 2022-10-03 | 730.72 | 17.90 | 2022-09-21 | 14 | 37.12 | 1 | 716.10 | 5 | SO47012 | 2022-09-28 | 57.29 | 519.69 | 52.19 | 0.02 |
SO50246_6 | F243-44EB-B2 | PO1827174701 | 19 | 291 | 224 | 317 | 6 | 2023-07-03 | 31.12 | 0.78 | 2023-06-21 | 6 | 5.23 | 1 | 31.12 | 6 | SO50246 | 2023-06-28 | 2.49 | 31.38 | 5.19 | |||
SO49101_21 | 0549-4175-A0 | PO15573181395 | 100 | 293 | 395 | 487 | 1 | 2023-04-05 | 122.75 | 3.07 | 2023-03-24 | 2 | 45.42 | 1 | 122.75 | 21 | SO49101 | 2023-03-31 | 9.82 | 90.83 | 61.37 |
Generated 2024-09-20 03:45:00.254 UTC