[ROOT] dt FactResellerSale < WHERE DimSalesTerritoryId EQ '5' > SKIP 0 SHUFFLE < SKIP 1565 > < 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 |
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
| SO47726_2 | 7256-4599-93 | PO9657190563 | 100 | 285 | 366 | 315 | 5 | 2022-12-03 | 647.99 | 16.20 | 2022-11-21 | 1 | 598.44 | 1 | 647.99 | 2 | SO47726 | 2022-11-28 | 51.84 | 598.44 | 647.99 | |||
| SO71866_11 | 029A-46BE-80 | PO14297151936 | 100 | 285 | 558 | 627 | 5 | 2024-08-03 | 728.98 | 18.22 | 2024-07-22 | 3 | 179.82 | 1 | 728.98 | 11 | SO71866 | 2024-07-29 | 58.32 | 539.45 | 242.99 | |||
| SO53524_29 | 2B2B-440F-8B | PO1537151724 | 100 | 285 | 509 | 611 | 5 | 2023-11-03 | 200.05 | 5.00 | 2023-10-22 | 1 | 199.85 | 1 | 200.05 | 29 | SO53524 | 2023-10-29 | 16.00 | 199.85 | 200.05 | |||
| SO45275_4 | 43C2-4392-A6 | PO18560176206 | 100 | 285 | 342 | 531 | 5 | 2022-04-05 | 2097.29 | 52.43 | 2022-03-24 | 5 | 413.15 | 1 | 2097.29 | 4 | SO45275 | 2022-03-31 | 167.78 | 2065.73 | 419.46 | |||
| SO69465_9 | B8B2-4B14-99 | PO2842153886 | 100 | 285 | 481 | 700 | 5 | 2024-07-03 | 10.79 | 0.27 | 2024-06-21 | 2 | 3.36 | 1 | 10.79 | 9 | SO69465 | 2024-06-28 | 0.86 | 6.72 | 5.39 | |||
| SO55331_10 | 4195-4A79-A3 | PO9889143385 | 100 | 285 | 594 | 494 | 5 | 2023-12-03 | 1016.98 | 25.42 | 2023-11-21 | 3 | 308.22 | 1 | 1016.98 | 10 | SO55331 | 2023-11-28 | 81.36 | 924.65 | 338.99 | |||
| SO57088_12 | EA31-4951-8A | PO2842199218 | 100 | 285 | 372 | 700 | 5 | 2024-01-03 | 4398.03 | 109.95 | 2023-12-22 | 3 | 1554.95 | 1 | 4398.03 | 12 | SO57088 | 2023-12-29 | 351.84 | 4664.84 | 1466.01 | |||
| SO46345_1 | 469D-4520-80 | PO13746192187 | 100 | 285 | 345 | 7 | 567 | 5 | 1190.00 | 2022-08-03 | 3399.99 | 55.25 | 2022-07-22 | 4 | 1912.15 | 1 | 2209.99 | 1 | SO46345 | 2022-07-29 | 176.80 | 7648.62 | 850.00 | 0.35 |
| SO43693_5 | EC62-4BB3-9B | PO8120182325 | 100 | 281 | 344 | 485 | 5 | 2021-09-02 | 6119.98 | 153.00 | 2021-08-21 | 3 | 1912.15 | 1 | 6119.98 | 5 | SO43693 | 2021-08-28 | 489.60 | 5736.46 | 2039.99 | |||
| SO57104_10 | D4EE-4716-83 | PO18560117786 | 100 | 285 | 606 | 531 | 5 | 2024-01-03 | 647.99 | 16.20 | 2023-12-22 | 2 | 343.65 | 1 | 647.99 | 10 | SO57104 | 2023-12-29 | 51.84 | 687.30 | 323.99 | |||
| SO44532_1 | 046E-4BB5-A1 | PO1276112318 | 100 | 272 | 310 | 548 | 5 | 2022-01-03 | 2146.96 | 53.67 | 2021-12-22 | 1 | 2171.29 | 1 | 2146.96 | 1 | SO44532 | 2021-12-29 | 171.76 | 2171.29 | 2146.96 | |||
| SO51081_38 | EDBF-4FE1-8F | PO522116846 | 100 | 285 | 490 | 676 | 5 | 2023-09-02 | 194.36 | 4.86 | 2023-08-21 | 6 | 41.57 | 1 | 194.36 | 38 | SO51081 | 2023-08-28 | 15.55 | 249.43 | 32.39 | |||
| SO51081_24 | EDBF-4FE1-8F | PO522116846 | 100 | 285 | 471 | 676 | 5 | 2023-09-02 | 304.80 | 7.62 | 2023-08-21 | 8 | 23.75 | 1 | 304.80 | 24 | SO51081 | 2023-08-28 | 24.38 | 189.99 | 38.10 | |||
| SO61230_18 | B9F1-4FF8-B4 | PO12644163346 | 100 | 285 | 363 | 530 | 5 | 2024-03-04 | 1376.99 | 34.42 | 2024-02-21 | 1 | 1251.98 | 1 | 1376.99 | 18 | SO61230 | 2024-02-28 | 110.16 | 1251.98 | 1376.99 | |||
| SO53524_49 | 2B2B-440F-8B | PO1537151724 | 100 | 285 | 484 | 611 | 5 | 2023-11-03 | 19.08 | 0.48 | 2023-10-22 | 4 | 2.97 | 1 | 19.08 | 49 | SO53524 | 2023-10-29 | 1.53 | 11.89 | 4.77 | |||
| SO49088_4 | ED04-4B44-9B | PO11542199639 | 100 | 285 | 329 | 62 | 5 | 2023-04-05 | 1409.38 | 35.23 | 2023-03-24 | 3 | 486.71 | 1 | 1409.38 | 4 | SO49088 | 2023-03-31 | 112.75 | 1460.12 | 469.79 | |||
| SO51780_2 | 30C4-4B8F-AA | PO18560115626 | 100 | 285 | 487 | 531 | 5 | 2023-10-03 | 98.98 | 2.47 | 2023-09-21 | 3 | 20.57 | 1 | 98.98 | 2 | SO51780 | 2023-09-28 | 7.92 | 61.70 | 32.99 | |||
| SO51693_17 | 6FEB-4D5B-92 | PO19546179477 | 100 | 285 | 581 | 206 | 5 | 2023-10-03 | 1020.59 | 25.51 | 2023-09-21 | 1 | 1082.51 | 1 | 1020.59 | 17 | SO51693 | 2023-09-28 | 81.65 | 1082.51 | 1020.59 | |||
| SO71948_28 | DCEE-428D-87 | PO9599179297 | 100 | 285 | 390 | 170 | 5 | 2024-08-03 | 2689.18 | 67.23 | 2024-07-22 | 4 | 713.08 | 1 | 2689.18 | 28 | SO71948 | 2024-07-29 | 215.13 | 2852.32 | 672.29 | |||
| SO46045_6 | 9345-48CB-A5 | PO16327127643 | 100 | 285 | 212 | 584 | 5 | 2022-07-03 | 80.75 | 2.02 | 2022-06-21 | 4 | 12.03 | 1 | 80.75 | 6 | SO46045 | 2022-06-28 | 6.46 | 48.11 | 20.19 | |||
| SO50306_2 | D376-4A40-86 | PO5858194676 | 100 | 285 | 427 | 566 | 5 | 2023-07-03 | 1046.28 | 26.16 | 2023-06-21 | 5 | 185.82 | 1 | 1046.28 | 2 | SO50306 | 2023-06-28 | 83.70 | 929.10 | 209.26 | |||
| SO43659_12 | 4911-403C-98 | PO522145787 | 100 | 285 | 220 | 676 | 5 | 2021-09-02 | 80.75 | 2.02 | 2021-08-21 | 4 | 12.03 | 1 | 80.75 | 12 | SO43659 | 2021-08-28 | 6.46 | 48.11 | 20.19 | |||
| SO53563_25 | C955-44BD-A8 | PO9599165865 | 100 | 285 | 408 | 170 | 5 | 2023-11-03 | 360.81 | 9.02 | 2023-10-22 | 5 | 53.40 | 1 | 360.81 | 25 | SO53563 | 2023-10-29 | 28.86 | 267.00 | 72.16 | |||
| SO47416_53 | 6B45-44AB-84 | PO2813155355 | 100 | 281 | 447 | 2 | 90 | 5 | 3.48 | 2022-11-03 | 174.00 | 4.26 | 2022-10-22 | 12 | 10.31 | 1 | 170.52 | 53 | SO47416 | 2022-10-29 | 13.64 | 123.75 | 14.50 | 0.02 |
| SO47042_24 | 42DB-4E2E-B9 | PO5858114009 | 100 | 285 | 367 | 566 | 5 | 2022-10-03 | 2591.98 | 64.80 | 2022-09-21 | 4 | 598.44 | 1 | 2591.98 | 24 | SO47042 | 2022-09-28 | 207.36 | 2393.74 | 647.99 | |||
| SO63181_1 | CB4E-4CF5-87 | PO2842135731 | 100 | 285 | 545 | 700 | 5 | 2024-04-04 | 48.59 | 1.21 | 2024-03-23 | 2 | 17.98 | 1 | 48.59 | 1 | SO63181 | 2024-03-30 | 3.89 | 35.96 | 24.29 | |||
| SO53563_2 | C955-44BD-A8 | PO9599165865 | 100 | 285 | 255 | 170 | 5 | 2023-11-03 | 404.66 | 10.12 | 2023-10-22 | 2 | 204.63 | 1 | 404.66 | 2 | SO53563 | 2023-10-29 | 32.37 | 409.25 | 202.33 | |||
| SO50726_39 | A80B-408E-B3 | PO9599192861 | 100 | 285 | 385 | 170 | 5 | 2023-08-03 | 3601.58 | 90.04 | 2023-07-22 | 6 | 605.65 | 1 | 3601.58 | 39 | SO50726 | 2023-07-29 | 288.13 | 3633.90 | 600.26 | |||
| SO71844_28 | 410D-4079-9E | PO2813198985 | 100 | 283 | 483 | 2 | 90 | 5 | 19.49 | 2024-08-03 | 974.40 | 23.87 | 2024-07-22 | 14 | 44.88 | 1 | 954.91 | 28 | SO71844 | 2024-07-29 | 76.39 | 628.32 | 69.60 | 0.02 |
| SO46995_1 | 9CEA-4AC3-95 | PO11542113352 | 100 | 285 | 327 | 9 | 62 | 5 | 70.47 | 2022-10-03 | 234.90 | 4.11 | 2022-09-21 | 1 | 486.71 | 1 | 164.43 | 1 | SO46995 | 2022-09-28 | 13.15 | 486.71 | 234.90 | 0.30 |
| SO44319_13 | FBB9-4CD9-A1 | PO9657142761 | 100 | 285 | 229 | 315 | 5 | 2021-12-03 | 28.84 | 0.72 | 2021-11-21 | 1 | 31.72 | 1 | 28.84 | 13 | SO44319 | 2021-11-28 | 2.31 | 31.72 | 28.84 | |||
| SO51760_16 | 2C2D-41C9-8C | PO9918180623 | 100 | 285 | 577 | 260 | 5 | 2023-10-03 | 2186.73 | 54.67 | 2023-09-21 | 3 | 755.15 | 1 | 2186.73 | 16 | SO51760 | 2023-09-28 | 174.94 | 2265.45 | 728.91 | |||
| SO46090_13 | 987E-4B5B-B6 | PO5858172038 | 100 | 285 | 348 | 2 | 566 | 5 | 469.80 | 2022-07-03 | 23489.93 | 575.50 | 2022-06-21 | 12 | 1898.09 | 1 | 23020.13 | 13 | SO46090 | 2022-06-28 | 1841.61 | 22777.13 | 1957.49 | 0.02 |
| SO44799_4 | 2146-417A-8D | PO9106161251 | 100 | 285 | 351 | 602 | 5 | 2022-02-02 | 4049.99 | 101.25 | 2022-01-21 | 2 | 1898.09 | 1 | 4049.99 | 4 | SO44799 | 2022-01-28 | 324.00 | 3796.19 | 2024.99 | |||
| SO51759_1 | D9CE-4CAE-90 | PO10208129572 | 100 | 285 | 386 | 134 | 5 | 2023-10-03 | 672.29 | 16.81 | 2023-09-21 | 1 | 713.08 | 1 | 672.29 | 1 | SO51759 | 2023-09-28 | 53.78 | 713.08 | 672.29 | |||
| SO51108_3 | 8650-4A20-B1 | PO12644151814 | 100 | 285 | 588 | 530 | 5 | 2023-09-02 | 923.39 | 23.08 | 2023-08-21 | 2 | 419.78 | 1 | 923.39 | 3 | SO51108 | 2023-08-28 | 73.87 | 839.56 | 461.69 | |||
| SO51108_19 | 8650-4A20-B1 | PO12644151814 | 100 | 285 | 599 | 530 | 5 | 2023-09-02 | 647.99 | 16.20 | 2023-08-21 | 2 | 294.58 | 1 | 647.99 | 19 | SO51108 | 2023-08-28 | 51.84 | 589.16 | 323.99 | |||
| SO47454_27 | E249-41EE-95 | PO9570119946 | 100 | 285 | 421 | 585 | 5 | 2022-11-03 | 785.32 | 19.63 | 2022-10-22 | 4 | 145.28 | 1 | 785.32 | 27 | SO47454 | 2022-10-29 | 62.83 | 581.13 | 196.33 | |||
| SO44779_3 | A6CC-4B73-8D | PO4089186617 | 100 | 285 | 347 | 368 | 5 | 2022-02-02 | 6119.98 | 153.00 | 2022-01-21 | 3 | 1912.15 | 1 | 6119.98 | 3 | SO44779 | 2022-01-28 | 489.60 | 5736.46 | 2039.99 | |||
| SO47455_45 | 41F3-48C2-B7 | PO9599169586 | 100 | 285 | 271 | 170 | 5 | 2022-11-03 | 1011.66 | 25.29 | 2022-10-22 | 5 | 187.16 | 1 | 1011.66 | 45 | SO47455 | 2022-10-29 | 80.93 | 935.79 | 202.33 | |||
| SO49088_3 | ED04-4B44-9B | PO11542199639 | 100 | 285 | 325 | 62 | 5 | 2023-04-05 | 469.79 | 11.74 | 2023-03-24 | 1 | 486.71 | 1 | 469.79 | 3 | SO49088 | 2023-03-31 | 37.58 | 486.71 | 469.79 | |||
| SO63130_7 | EE88-4C2F-98 | PO18560122888 | 100 | 285 | 481 | 531 | 5 | 2024-04-04 | 26.97 | 0.67 | 2024-03-23 | 5 | 3.36 | 1 | 26.97 | 7 | SO63130 | 2024-03-30 | 2.16 | 16.81 | 5.39 | |||
| SO44306_7 | 464C-43BA-9F | PO1189114917 | 100 | 285 | 275 | 423 | 5 | 2021-12-03 | 356.90 | 8.92 | 2021-11-21 | 1 | 352.14 | 1 | 356.90 | 7 | SO44306 | 2021-11-28 | 28.55 | 352.14 | 356.90 | |||
| SO51137_17 | A47F-4FEF-94 | PO9889144162 | 100 | 285 | 591 | 494 | 5 | 2023-09-02 | 1016.98 | 25.42 | 2023-08-21 | 3 | 308.22 | 1 | 1016.98 | 17 | SO51137 | 2023-08-28 | 81.36 | 924.65 | 338.99 | |||
| SO49865_21 | E9A6-42D3-91 | PO9831136904 | 100 | 285 | 329 | 81 | 5 | 2023-06-03 | 939.59 | 23.49 | 2023-05-22 | 2 | 486.71 | 1 | 939.59 | 21 | SO49865 | 2023-05-29 | 75.17 | 973.41 | 469.79 | |||
| SO55328_31 | 577D-4DE9-B6 | PO9831188161 | 100 | 285 | 408 | 81 | 5 | 2023-12-03 | 72.16 | 1.80 | 2023-11-21 | 1 | 53.40 | 1 | 72.16 | 31 | SO55328 | 2023-11-28 | 5.77 | 53.40 | 72.16 | |||
| SO46630_26 | F512-40F2-91 | PO12644161356 | 100 | 285 | 360 | 530 | 5 | 2022-09-02 | 3688.38 | 92.21 | 2022-08-21 | 3 | 1105.81 | 1 | 3688.38 | 26 | SO46630 | 2022-08-28 | 295.07 | 3317.43 | 1229.46 | |||
| SO46354_1 | 6226-4881-B8 | PO319132451 | 100 | 285 | 336 | 116 | 5 | 2022-08-03 | 419.46 | 10.49 | 2022-07-22 | 1 | 413.15 | 1 | 419.46 | 1 | SO46354 | 2022-07-29 | 33.56 | 413.15 | 419.46 | |||
| SO55253_32 | C58B-49D8-9F | PO12644132539 | 100 | 285 | 590 | 530 | 5 | 2023-12-03 | 1385.08 | 34.63 | 2023-11-21 | 3 | 419.78 | 1 | 1385.08 | 32 | SO55253 | 2023-11-28 | 110.81 | 1259.34 | 461.69 | |||
| SO44764_1 | 85B4-4420-81 | PO11426178608 | 100 | 285 | 315 | 386 | 5 | 2022-02-02 | 874.79 | 21.87 | 2022-01-21 | 1 | 884.71 | 1 | 874.79 | 1 | SO44764 | 2022-01-28 | 69.98 | 884.71 | 874.79 | |||
| SO44128_3 | 2EFE-4DBD-95 | PO9541192839 | 100 | 285 | 346 | 279 | 5 | 2021-11-03 | 2039.99 | 51.00 | 2021-10-22 | 1 | 1912.15 | 1 | 2039.99 | 3 | SO44128 | 2021-10-29 | 163.20 | 1912.15 | 2039.99 | |||
| SO47026_15 | 123B-481F-8F | PO3596190739 | 100 | 285 | 427 | 476 | 5 | 2022-10-03 | 209.26 | 5.23 | 2022-09-21 | 1 | 185.82 | 1 | 209.26 | 15 | SO47026 | 2022-09-28 | 16.74 | 185.82 | 209.26 | |||
| SO45337_12 | C8D2-41D4-AF | PO7598166612 | 100 | 285 | 319 | 45 | 5 | 2022-04-05 | 3499.18 | 87.48 | 2022-03-24 | 4 | 884.71 | 1 | 3499.18 | 12 | SO45337 | 2022-03-31 | 279.93 | 3538.83 | 874.79 | |||
| SO43693_7 | EC62-4BB3-9B | PO8120182325 | 100 | 281 | 347 | 485 | 5 | 2021-09-02 | 2039.99 | 51.00 | 2021-08-21 | 1 | 1912.15 | 1 | 2039.99 | 7 | SO43693 | 2021-08-28 | 163.20 | 1912.15 | 2039.99 | |||
| SO44488_26 | 18BD-4C15-81 | PO19546136242 | 100 | 285 | 310 | 206 | 5 | 2022-01-03 | 2146.96 | 53.67 | 2021-12-22 | 1 | 2171.29 | 1 | 2146.96 | 26 | SO44488 | 2021-12-29 | 171.76 | 2171.29 | 2146.96 | |||
| SO47725_12 | 2501-4A1D-99 | PO9831133395 | 100 | 285 | 417 | 81 | 5 | 2022-12-03 | 324.45 | 8.11 | 2022-11-21 | 1 | 300.12 | 1 | 324.45 | 12 | SO47725 | 2022-11-28 | 25.96 | 300.12 | 324.45 | |||
| SO50306_10 | D376-4A40-86 | PO5858194676 | 100 | 285 | 367 | 566 | 5 | 2023-07-03 | 1295.99 | 32.40 | 2023-06-21 | 2 | 598.44 | 1 | 1295.99 | 10 | SO50306 | 2023-06-28 | 103.68 | 1196.87 | 647.99 | |||
| SO61228_6 | 06C7-43A1-85 | PO9831151400 | 100 | 285 | 384 | 81 | 5 | 2024-03-04 | 672.29 | 16.81 | 2024-02-21 | 1 | 713.08 | 1 | 672.29 | 6 | SO61228 | 2024-02-28 | 53.78 | 713.08 | 672.29 | |||
| SO50726_14 | A80B-408E-B3 | PO9599192861 | 100 | 285 | 447 | 170 | 5 | 2023-08-03 | 15.00 | 0.38 | 2023-07-22 | 1 | 10.31 | 1 | 15.00 | 14 | SO50726 | 2023-07-29 | 1.20 | 10.31 | 15.00 | |||
| SO53595_3 | 4160-4910-92 | PO4089179449 | 100 | 285 | 544 | 368 | 5 | 2023-11-03 | 97.19 | 2.43 | 2023-10-22 | 2 | 35.96 | 1 | 97.19 | 3 | SO53595 | 2023-10-29 | 7.78 | 71.92 | 48.59 | |||
| SO71850_6 | 3DA6-4E97-9F | PO18241134627 | 100 | 285 | 555 | 477 | 5 | 2024-08-03 | 63.90 | 1.60 | 2024-07-22 | 1 | 47.29 | 1 | 63.90 | 6 | SO71850 | 2024-07-29 | 5.11 | 47.29 | 63.90 | |||
| SO55255_2 | C51C-4242-88 | PO12615180482 | 100 | 285 | 599 | 440 | 5 | 2023-12-03 | 323.99 | 8.10 | 2023-11-21 | 1 | 294.58 | 1 | 323.99 | 2 | SO55255 | 2023-11-28 | 25.92 | 294.58 | 323.99 |
Generated 2024-09-20 19:15:20.022 UTC