[ROOT] dt FactResellerSale < WHERE DimSalesTerritoryId EQ ALL SHUFFLE < SKIP 412 > < TAKE 56 >
56 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 |
---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
SO55245_2 | B5AD-476D-B4 | PO14732112185 | 19 | 291 | 440 | 514 | 6 | 2023-12-03 | 2576.70 | 64.42 | 2023-11-21 | 3 | 868.63 | 1 | 2576.70 | 2 | SO55245 | 2023-11-28 | 206.14 | 2605.90 | 858.90 | |||
SO51822_20 | EEEE-45C1-87 | PO8845178563 | 100 | 282 | 594 | 546 | 3 | 2023-10-03 | 677.99 | 16.95 | 2023-09-21 | 2 | 308.22 | 1 | 677.99 | 20 | SO51822 | 2023-09-28 | 54.24 | 616.44 | 338.99 | |||
SO46604_6 | 8062-4A97-B3 | PO522154989 | 100 | 285 | 352 | 676 | 5 | 2022-09-02 | 3728.56 | 93.21 | 2022-08-21 | 3 | 1117.86 | 1 | 3728.56 | 6 | SO46604 | 2022-08-28 | 298.28 | 3353.57 | 1242.85 | |||
SO45799_12 | 4DE8-4B9B-A1 | PO10730195041 | 100 | 287 | 315 | 491 | 4 | 2022-06-03 | 1749.59 | 43.74 | 2022-05-22 | 2 | 884.71 | 1 | 1749.59 | 12 | SO45799 | 2022-05-29 | 139.97 | 1769.42 | 874.79 | |||
SO50298_12 | 2A9C-4236-85 | PO4843196377 | 100 | 287 | 263 | 257 | 4 | 2023-07-03 | 404.66 | 10.12 | 2023-06-21 | 2 | 187.16 | 1 | 404.66 | 12 | SO50298 | 2023-06-28 | 32.37 | 374.31 | 202.33 | |||
SO51140_18 | 0583-4C94-BA | PO6467148715 | 100 | 283 | 491 | 3 | 660 | 3 | 25.24 | 2023-09-02 | 504.81 | 11.99 | 2023-08-21 | 17 | 41.57 | 1 | 479.57 | 18 | SO51140 | 2023-08-28 | 38.37 | 706.73 | 29.69 | 0.05 |
SO69452_2 | 5ADC-4093-86 | PO10150198555 | 100 | 285 | 475 | 9 | 5 | 2024-07-03 | 41.99 | 1.05 | 2024-06-21 | 1 | 26.18 | 1 | 41.99 | 2 | SO69452 | 2024-06-28 | 3.36 | 26.18 | 41.99 | |||
SO50263_20 | 7D74-4A96-A3 | PO18183117532 | 100 | 283 | 420 | 667 | 2 | 2023-07-03 | 283.23 | 7.08 | 2023-06-21 | 2 | 104.80 | 1 | 283.23 | 20 | SO50263 | 2023-06-28 | 22.66 | 209.59 | 141.62 | |||
SO57177_1 | F48B-4DA6-9D | PO8149140075 | 36 | 290 | 418 | 615 | 8 | 2024-01-03 | 356.90 | 8.92 | 2023-12-22 | 1 | 360.94 | 1 | 356.90 | 1 | SO57177 | 2023-12-29 | 28.55 | 360.94 | 356.90 | |||
SO44083_3 | A5F2-4B59-BA | PO17719115878 | 19 | 284 | 223 | 631 | 6 | 2021-11-03 | 10.37 | 0.26 | 2021-10-22 | 2 | 5.71 | 1 | 10.37 | 3 | SO44083 | 2021-10-29 | 0.83 | 11.41 | 5.19 | |||
SO69464_57 | 8924-465B-BE | PO2668146931 | 100 | 292 | 353 | 535 | 7 | 2024-07-03 | 2783.99 | 69.60 | 2024-06-21 | 2 | 1265.62 | 1 | 2783.99 | 57 | SO69464 | 2024-06-28 | 222.72 | 2531.24 | 1391.99 | |||
SO61224_26 | 3D8E-4C8E-B7 | PO13775159907 | 100 | 283 | 390 | 618 | 2 | 2024-03-04 | 3361.47 | 84.04 | 2024-02-21 | 5 | 713.08 | 1 | 3361.47 | 26 | SO61224 | 2024-02-28 | 268.92 | 3565.40 | 672.29 | |||
SO53525_4 | F162-4A87-B4 | PO1305155715 | 100 | 292 | 572 | 13 | 319 | 7 | 100.22 | 2023-11-03 | 668.12 | 14.20 | 2023-10-22 | 2 | 461.44 | 1 | 567.90 | 4 | SO53525 | 2023-10-29 | 45.43 | 922.89 | 334.06 | 0.15 |
SO46973_3 | EE00-44C0-9F | PO14529114552 | 100 | 286 | 468 | 289 | 1 | 2022-10-03 | 45.59 | 1.14 | 2022-09-21 | 2 | 15.67 | 1 | 45.59 | 3 | SO46973 | 2022-09-28 | 3.65 | 31.34 | 22.79 | |||
SO44492_11 | 8AF8-4DDE-A8 | PO18676158978 | 100 | 282 | 347 | 697 | 1 | 2022-01-03 | 10199.97 | 255.00 | 2021-12-22 | 5 | 1912.15 | 1 | 10199.97 | 11 | SO44492 | 2021-12-29 | 816.00 | 9560.77 | 2039.99 | |||
SO53530_22 | A31D-483D-A1 | PO2813121313 | 100 | 283 | 488 | 90 | 5 | 2023-11-03 | 129.58 | 3.24 | 2023-10-22 | 4 | 41.57 | 1 | 129.58 | 22 | SO53530 | 2023-10-29 | 10.37 | 166.29 | 32.39 | |||
SO53554_6 | 314F-4C97-94 | PO12151155457 | 6 | 294 | 491 | 195 | 9 | 2023-11-03 | 129.58 | 3.24 | 2023-10-22 | 4 | 41.57 | 1 | 129.58 | 6 | SO53554 | 2023-10-29 | 10.37 | 166.29 | 32.39 | |||
SO57154_3 | 464B-46A4-B6 | PO1856185040 | 19 | 291 | 502 | 263 | 6 | 2024-01-03 | 200.05 | 5.00 | 2023-12-22 | 1 | 199.85 | 1 | 200.05 | 3 | SO57154 | 2023-12-29 | 16.00 | 199.85 | 200.05 | |||
SO47417_21 | 1CE8-4651-A9 | PO2697165938 | 100 | 282 | 391 | 187 | 4 | 2022-11-03 | 177.86 | 4.45 | 2022-10-22 | 2 | 65.81 | 1 | 177.86 | 21 | SO47417 | 2022-10-29 | 14.23 | 131.62 | 88.93 | |||
SO51774_58 | 30BA-400A-89 | PO2668194455 | 100 | 292 | 483 | 3 | 535 | 7 | 52.80 | 2023-10-03 | 1056.00 | 25.08 | 2023-09-21 | 16 | 44.88 | 1 | 1003.20 | 58 | SO51774 | 2023-09-28 | 80.26 | 718.08 | 66.00 | 0.05 |
SO53454_47 | 278D-445A-99 | PO19633151350 | 100 | 287 | 597 | 149 | 3 | 2023-11-03 | 323.99 | 8.10 | 2023-10-22 | 1 | 294.58 | 1 | 323.99 | 47 | SO53454 | 2023-10-29 | 25.92 | 294.58 | 323.99 | |||
SO50189_11 | 6D35-41E2-A6 | PO19923188059 | 100 | 283 | 393 | 18 | 3 | 2023-07-03 | 413.08 | 10.33 | 2023-06-21 | 3 | 101.89 | 1 | 413.08 | 11 | SO50189 | 2023-06-28 | 33.05 | 305.68 | 137.69 | |||
SO46049_7 | 2C79-41BD-8A | PO15689114654 | 100 | 283 | 285 | 328 | 4 | 2022-07-03 | 535.74 | 13.39 | 2022-06-21 | 3 | 176.20 | 1 | 535.74 | 7 | SO46049 | 2022-06-28 | 42.86 | 528.60 | 178.58 | |||
SO51691_26 | 8F72-4342-A4 | PO19923122474 | 100 | 283 | 601 | 18 | 3 | 2023-10-03 | 64.79 | 1.62 | 2023-09-21 | 2 | 23.97 | 1 | 64.79 | 26 | SO51691 | 2023-09-28 | 5.18 | 47.94 | 32.39 | |||
SO67268_5 | 9708-4E22-A4 | PO15312122688 | 19 | 291 | 390 | 299 | 6 | 2024-06-03 | 672.29 | 16.81 | 2024-05-22 | 1 | 713.08 | 1 | 672.29 | 5 | SO67268 | 2024-05-29 | 53.78 | 713.08 | 672.29 | |||
SO51735_30 | 6E95-4EE8-92 | PO13456167695 | 36 | 292 | 496 | 2 | 614 | 7 | 139.74 | 2023-10-03 | 6987.21 | 171.19 | 2023-09-21 | 12 | 601.74 | 1 | 6847.47 | 30 | SO51735 | 2023-09-28 | 547.80 | 7220.92 | 582.27 | 0.02 |
SO46055_20 | DDC5-498B-87 | PO13572168536 | 100 | 287 | 220 | 527 | 3 | 2022-07-03 | 60.56 | 1.51 | 2022-06-21 | 3 | 12.03 | 1 | 60.56 | 20 | SO46055 | 2022-06-28 | 4.84 | 36.08 | 20.19 | |||
SO53512_16 | 6AC2-4C2F-81 | PO10353157108 | 98 | 290 | 474 | 3 | 88 | 10 | 32.72 | 2023-11-03 | 654.41 | 15.54 | 2023-10-22 | 17 | 26.18 | 1 | 621.69 | 16 | SO53512 | 2023-10-29 | 49.73 | 445.00 | 38.49 | 0.05 |
SO51818_16 | B8CE-4C91-A9 | PO9077115532 | 19 | 291 | 532 | 100 | 6 | 2023-10-03 | 299.75 | 7.49 | 2023-09-21 | 2 | 136.79 | 1 | 299.75 | 16 | SO51818 | 2023-09-28 | 23.98 | 273.57 | 149.87 | |||
SO51151_3 | D7A9-4DF6-B9 | PO8787179219 | 100 | 282 | 386 | 523 | 3 | 2023-09-02 | 2016.88 | 50.42 | 2023-08-21 | 3 | 713.08 | 1 | 2016.88 | 3 | SO51151 | 2023-08-28 | 161.35 | 2139.24 | 672.29 | |||
SO45577_15 | 7B09-45DB-A3 | PO9599125078 | 100 | 285 | 314 | 170 | 5 | 2022-05-03 | 12881.77 | 322.04 | 2022-04-21 | 6 | 2171.29 | 1 | 12881.77 | 15 | SO45577 | 2022-04-28 | 1030.54 | 13027.77 | 2146.96 | |||
SO49052_24 | 8769-409E-94 | PO16733182723 | 19 | 291 | 321 | 533 | 6 | 2023-04-05 | 2348.97 | 58.72 | 2023-03-24 | 5 | 486.71 | 1 | 2348.97 | 24 | SO49052 | 2023-03-31 | 187.92 | 2433.53 | 469.79 | |||
SO71781_19 | 2FB9-4F05-82 | PO19401117806 | 19 | 291 | 545 | 173 | 6 | 2024-08-03 | 72.88 | 1.82 | 2024-07-22 | 3 | 17.98 | 1 | 72.88 | 19 | SO71781 | 2024-07-29 | 5.83 | 53.93 | 24.29 | |||
SO48310_11 | B389-4D7D-85 | PO17139173607 | 100 | 293 | 407 | 644 | 1 | 2023-02-02 | 131.20 | 3.28 | 2023-01-21 | 2 | 48.55 | 1 | 131.20 | 11 | SO48310 | 2023-01-28 | 10.50 | 97.09 | 65.60 | |||
SO46107_1 | 75E6-43D6-92 | PO8874169089 | 100 | 282 | 300 | 348 | 3 | 2022-07-03 | 1619.52 | 40.49 | 2022-06-21 | 2 | 699.09 | 1 | 1619.52 | 1 | SO46107 | 2022-06-28 | 129.56 | 1398.19 | 809.76 | |||
SO63167_2 | 86F4-4F8E-AE | PO10121113947 | 100 | 283 | 390 | 684 | 2 | 2024-04-04 | 2016.88 | 50.42 | 2024-03-23 | 3 | 713.08 | 1 | 2016.88 | 2 | SO63167 | 2024-03-30 | 161.35 | 2139.24 | 672.29 | |||
SO51694_7 | 75B1-457C-8C | PO19691118743 | 19 | 291 | 517 | 353 | 6 | 2023-10-03 | 31.58 | 0.79 | 2023-09-21 | 1 | 23.37 | 1 | 31.58 | 7 | SO51694 | 2023-09-28 | 2.53 | 23.37 | 31.58 | |||
SO48349_20 | CD94-4B46-9E | PO1624135169 | 100 | 283 | 460 | 579 | 3 | 2023-02-02 | 323.96 | 8.10 | 2023-01-21 | 6 | 37.12 | 1 | 323.96 | 20 | SO48349 | 2023-01-28 | 25.92 | 222.73 | 53.99 | |||
SO65180_5 | B9CA-46FC-B0 | PO16182138917 | 100 | 287 | 476 | 23 | 4 | 2024-05-03 | 125.98 | 3.15 | 2024-04-21 | 3 | 26.18 | 1 | 125.98 | 5 | SO65180 | 2024-04-28 | 10.08 | 78.53 | 41.99 | |||
SO49492_1 | 8C0F-4EEC-81 | PO19633118522 | 100 | 287 | 358 | 149 | 3 | 2023-05-03 | 3688.38 | 92.21 | 2023-04-21 | 3 | 1105.81 | 1 | 3688.38 | 1 | SO49492 | 2023-04-28 | 295.07 | 3317.43 | 1229.46 | |||
SO48393_26 | 5B6A-41B6-BF | PO9599137631 | 100 | 285 | 286 | 170 | 5 | 2023-02-02 | 551.81 | 13.80 | 2023-01-21 | 3 | 170.14 | 1 | 551.81 | 26 | SO48393 | 2023-01-28 | 44.15 | 510.43 | 183.94 | |||
SO46088_7 | 9E24-49CE-A7 | PO5568122777 | 100 | 285 | 345 | 422 | 5 | 2022-07-03 | 4079.99 | 102.00 | 2022-06-21 | 2 | 1912.15 | 1 | 4079.99 | 7 | SO46088 | 2022-06-28 | 326.40 | 3824.31 | 2039.99 | |||
SO58915_16 | 1BBB-45DF-82 | PO17371111245 | 6 | 294 | 214 | 688 | 9 | 2024-02-02 | 188.95 | 4.72 | 2024-01-21 | 9 | 13.09 | 1 | 188.95 | 16 | SO58915 | 2024-01-28 | 15.12 | 117.78 | 20.99 | |||
SO53499_39 | A47F-48AD-83 | PO12354126576 | 100 | 283 | 532 | 197 | 3 | 2023-11-03 | 599.50 | 14.99 | 2023-10-22 | 4 | 136.79 | 1 | 599.50 | 39 | SO53499 | 2023-10-29 | 47.96 | 547.14 | 149.87 | |||
SO48788_1 | DD66-4EC8-BF | PO6699145127 | 100 | 283 | 224 | 234 | 2 | 2023-03-05 | 10.37 | 0.26 | 2023-02-21 | 2 | 5.23 | 1 | 10.37 | 1 | SO48788 | 2023-02-28 | 0.83 | 10.46 | 5.19 | |||
SO50218_38 | B8E9-4FE2-8B | PO14442144367 | 100 | 293 | 356 | 127 | 1 | 2023-07-03 | 3728.56 | 93.21 | 2023-06-21 | 3 | 1117.86 | 1 | 3728.56 | 38 | SO50218 | 2023-06-28 | 298.28 | 3353.57 | 1242.85 | |||
SO71812_20 | 3257-4AE0-A8 | PO13543115747 | 100 | 287 | 400 | 293 | 1 | 2024-08-03 | 111.46 | 2.79 | 2024-07-22 | 3 | 27.49 | 1 | 111.46 | 20 | SO71812 | 2024-07-29 | 8.92 | 82.48 | 37.15 | |||
SO65282_10 | 2628-4FDF-B1 | PO5713156786 | 98 | 288 | 559 | 52 | 10 | 2024-05-03 | 48.58 | 1.21 | 2024-04-21 | 4 | 8.99 | 1 | 48.58 | 10 | SO65282 | 2024-04-28 | 3.89 | 35.95 | 12.14 | |||
SO55282_33 | A72A-4D3A-BA | PO16298125578 | 100 | 287 | 502 | 599 | 4 | 2023-12-03 | 400.10 | 10.00 | 2023-11-21 | 2 | 199.85 | 1 | 400.10 | 33 | SO55282 | 2023-11-28 | 32.01 | 399.70 | 200.05 | |||
SO51712_30 | 910D-4560-A7 | PO16675134576 | 100 | 293 | 514 | 361 | 1 | 2023-10-03 | 63.90 | 1.60 | 2023-09-21 | 1 | 47.29 | 1 | 63.90 | 30 | SO51712 | 2023-09-28 | 5.11 | 47.29 | 63.90 | |||
SO46957_27 | C98D-43A5-8A | PO16414179284 | 100 | 289 | 356 | 236 | 1 | 2022-10-03 | 9942.81 | 248.57 | 2022-09-21 | 8 | 1117.86 | 1 | 9942.81 | 27 | SO46957 | 2022-09-28 | 795.43 | 8942.85 | 1242.85 | |||
SO46666_18 | 1A94-4D1F-AF | PO6699130779 | 100 | 281 | 381 | 234 | 2 | 2022-09-02 | 4201.84 | 105.05 | 2022-08-21 | 7 | 605.65 | 1 | 4201.84 | 18 | SO46666 | 2022-08-28 | 336.15 | 4239.54 | 600.26 | |||
SO48032_3 | 6326-4EBF-93 | PO1218188435 | 98 | 288 | 254 | 412 | 10 | 2023-01-03 | 183.94 | 4.60 | 2022-12-22 | 1 | 170.14 | 1 | 183.94 | 3 | SO48032 | 2022-12-29 | 14.72 | 170.14 | 183.94 | |||
SO50696_18 | C32F-4FEE-A3 | PO1624119214 | 100 | 281 | 415 | 579 | 3 | 2023-08-03 | 198.04 | 4.95 | 2023-07-22 | 1 | 146.55 | 1 | 198.04 | 18 | SO50696 | 2023-07-29 | 15.84 | 146.55 | 198.04 | |||
SO69531_22 | 1871-4E54-BE | PO3683141039 | 100 | 292 | 601 | 85 | 7 | 2024-07-03 | 97.18 | 2.43 | 2024-06-21 | 3 | 23.97 | 1 | 97.18 | 22 | SO69531 | 2024-06-28 | 7.77 | 71.91 | 32.39 | |||
SO47387_5 | 4FFC-4663-AC | PO13543169662 | 100 | 287 | 362 | 293 | 1 | 2022-11-03 | 1229.46 | 30.74 | 2022-10-22 | 1 | 1105.81 | 1 | 1229.46 | 5 | SO47387 | 2022-10-29 | 98.36 | 1105.81 | 1229.46 |
Generated 2024-09-20 18:41:59.285 UTC