[ROOT] dt FactResellerSale < WHERE DimSalesTerritoryId EQ '5' > SHUFFLE < SKIP 2625 > < 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 |
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
| SO45779_11 | 983F-42E3-90 | PO522162183 | 100 | 285 | 223 | 676 | 5 | 2022-06-02 | 15.56 | 0.39 | 2022-05-21 | 3 | 5.71 | 1 | 15.56 | 11 | SO45779 | 2022-05-28 | 1.24 | 17.12 | 5.19 | |||
| SO47454_9 | E249-41EE-95 | PO9570119946 | 100 | 285 | 458 | 585 | 5 | 2022-11-02 | 89.99 | 2.25 | 2022-10-21 | 2 | 30.93 | 1 | 89.99 | 9 | SO47454 | 2022-10-28 | 7.20 | 61.87 | 44.99 | |||
| SO65210_13 | 08E4-4CC9-A7 | PO2813181442 | 100 | 283 | 477 | 90 | 5 | 2024-05-02 | 11.98 | 0.30 | 2024-04-20 | 4 | 1.87 | 1 | 11.98 | 13 | SO65210 | 2024-04-27 | 0.96 | 7.47 | 2.99 | |||
| SO69474_9 | 2DD3-46CB-BD | PO18560139140 | 100 | 285 | 491 | 531 | 5 | 2024-07-02 | 32.39 | 0.81 | 2024-06-20 | 1 | 41.57 | 1 | 32.39 | 9 | SO69474 | 2024-06-27 | 2.59 | 41.57 | 32.39 | |||
| SO59071_2 | EFC3-4244-A6 | PO9599176835 | 100 | 285 | 382 | 170 | 5 | 2024-02-01 | 4706.06 | 117.65 | 2024-01-20 | 7 | 713.08 | 1 | 4706.06 | 2 | SO59071 | 2024-01-27 | 376.48 | 4991.56 | 672.29 | |||
| SO71950_3 | 7D5C-49FE-BA | PO9744193484 | 100 | 285 | 476 | 98 | 5 | 2024-08-02 | 251.96 | 6.30 | 2024-07-21 | 6 | 26.18 | 1 | 251.96 | 3 | SO71950 | 2024-07-28 | 20.16 | 157.06 | 41.99 | |||
| SO61173_27 | 6B8D-47B8-8E | PO522171689 | 100 | 285 | 532 | 676 | 5 | 2024-03-03 | 299.75 | 7.49 | 2024-02-20 | 2 | 136.79 | 1 | 299.75 | 27 | SO61173 | 2024-02-27 | 23.98 | 273.57 | 149.87 | |||
| SO53551_6 | 8593-405C-AB | PO14297167079 | 100 | 285 | 514 | 627 | 5 | 2023-11-02 | 127.80 | 3.20 | 2023-10-21 | 2 | 47.29 | 1 | 127.80 | 6 | SO53551 | 2023-10-28 | 10.22 | 94.57 | 63.90 | |||
| SO51110_15 | 2713-42DF-AC | PO11861142261 | 100 | 283 | 474 | 17 | 5 | 2023-09-01 | 167.98 | 4.20 | 2023-08-20 | 4 | 26.18 | 1 | 167.98 | 15 | SO51110 | 2023-08-27 | 13.44 | 104.71 | 41.99 | |||
| SO51718_6 | 27D3-4968-89 | PO15051113417 | 100 | 285 | 465 | 207 | 5 | 2023-10-02 | 29.39 | 0.73 | 2023-09-20 | 2 | 9.16 | 1 | 29.39 | 6 | SO51718 | 2023-09-27 | 2.35 | 18.32 | 14.69 | |||
| SO48090_11 | E7D1-44A3-B2 | PO9512117066 | 100 | 285 | 456 | 135 | 5 | 2023-01-02 | 179.98 | 4.50 | 2022-12-21 | 4 | 30.93 | 1 | 179.98 | 11 | SO48090 | 2022-12-28 | 14.40 | 123.73 | 44.99 | |||
| SO47416_37 | 6B45-44AB-84 | PO2813155355 | 100 | 281 | 461 | 90 | 5 | 2022-11-02 | 107.99 | 2.70 | 2022-10-21 | 2 | 37.12 | 1 | 107.99 | 37 | SO47416 | 2022-10-28 | 8.64 | 74.24 | 53.99 | |||
| SO55328_6 | 577D-4DE9-B6 | PO9831188161 | 100 | 285 | 480 | 81 | 5 | 2023-12-02 | 8.24 | 0.21 | 2023-11-20 | 6 | 0.86 | 1 | 8.24 | 6 | SO55328 | 2023-11-27 | 0.66 | 5.14 | 1.37 | |||
| SO47454_35 | E249-41EE-95 | PO9570119946 | 100 | 285 | 464 | 585 | 5 | 2022-11-02 | 14.13 | 0.35 | 2022-10-21 | 1 | 9.71 | 1 | 14.13 | 35 | SO47454 | 2022-10-28 | 1.13 | 9.71 | 14.13 | |||
| SO71866_14 | 029A-46BE-80 | PO14297151936 | 100 | 285 | 500 | 627 | 5 | 2024-08-02 | 1204.69 | 30.12 | 2024-07-21 | 2 | 601.74 | 1 | 1204.69 | 14 | SO71866 | 2024-07-28 | 96.38 | 1203.49 | 602.35 | |||
| SO46388_2 | 4B6E-4FC0-A5 | PO9802185512 | 100 | 285 | 223 | 26 | 5 | 2022-08-02 | 10.37 | 0.26 | 2022-07-21 | 2 | 5.71 | 1 | 10.37 | 2 | SO46388 | 2022-07-28 | 0.83 | 11.41 | 5.19 | |||
| SO47416_49 | 6B45-44AB-84 | PO2813155355 | 100 | 281 | 407 | 90 | 5 | 2022-11-02 | 262.41 | 6.56 | 2022-10-21 | 4 | 48.55 | 1 | 262.41 | 49 | SO47416 | 2022-10-28 | 20.99 | 194.18 | 65.60 | |||
| SO46033_4 | 253E-48E3-85 | PO18560157809 | 100 | 285 | 324 | 531 | 5 | 2022-07-02 | 419.46 | 10.49 | 2022-06-20 | 1 | 413.15 | 1 | 419.46 | 4 | SO46033 | 2022-06-27 | 33.56 | 413.15 | 419.46 | |||
| SO44549_2 | 2479-4173-87 | PO5568135148 | 100 | 285 | 219 | 422 | 5 | 2022-01-02 | 17.10 | 0.43 | 2021-12-21 | 3 | 3.40 | 1 | 17.10 | 2 | SO44549 | 2021-12-28 | 1.37 | 10.19 | 5.70 | |||
| SO48063_8 | AEA4-4489-90 | PO5858143254 | 100 | 285 | 410 | 566 | 5 | 2023-01-02 | 36.45 | 0.91 | 2022-12-21 | 1 | 26.97 | 1 | 36.45 | 8 | SO48063 | 2022-12-28 | 2.92 | 26.97 | 36.45 | |||
| SO46388_5 | 4B6E-4FC0-A5 | PO9802185512 | 100 | 285 | 342 | 26 | 5 | 2022-08-02 | 1258.38 | 31.46 | 2022-07-21 | 3 | 413.15 | 1 | 1258.38 | 5 | SO46388 | 2022-07-28 | 100.67 | 1239.44 | 419.46 | |||
| SO57074_18 | FF65-4261-97 | PO9918191120 | 100 | 285 | 579 | 260 | 5 | 2024-01-02 | 2186.73 | 54.67 | 2023-12-21 | 3 | 755.15 | 1 | 2186.73 | 18 | SO57074 | 2023-12-28 | 174.94 | 2265.45 | 728.91 | |||
| SO44552_1 | 79A1-4836-9F | PO5858149301 | 100 | 285 | 344 | 566 | 5 | 2022-01-02 | 16319.95 | 408.00 | 2021-12-21 | 8 | 1912.15 | 1 | 16319.95 | 1 | SO44552 | 2021-12-28 | 1305.60 | 15297.24 | 2039.99 | |||
| SO53530_42 | A31D-483D-A1 | PO2813121313 | 100 | 283 | 547 | 90 | 5 | 2023-11-02 | 194.38 | 4.86 | 2023-10-21 | 4 | 35.96 | 1 | 194.38 | 42 | SO53530 | 2023-10-28 | 15.55 | 143.84 | 48.59 | |||
| SO44518_18 | 359F-48A3-B9 | PO12586169040 | 100 | 285 | 307 | 278 | 5 | 2022-01-02 | 1445.19 | 36.13 | 2021-12-21 | 2 | 623.84 | 1 | 1445.19 | 18 | SO44518 | 2021-12-28 | 115.62 | 1247.68 | 722.59 | |||
| SO67349_34 | 7BC2-4E87-BA | PO9831186318 | 100 | 285 | 214 | 81 | 5 | 2024-06-02 | 209.94 | 5.25 | 2024-05-21 | 10 | 13.09 | 1 | 209.94 | 34 | SO67349 | 2024-05-28 | 16.80 | 130.86 | 20.99 | |||
| SO46654_12 | 2FEC-47CC-84 | PO3741124832 | 100 | 285 | 230 | 404 | 5 | 2022-09-01 | 28.84 | 0.72 | 2022-08-20 | 1 | 29.08 | 1 | 28.84 | 12 | SO46654 | 2022-08-27 | 2.31 | 29.08 | 28.84 | |||
| SO46971_12 | 5CEA-463B-A2 | PO15051144269 | 100 | 285 | 221 | 207 | 5 | 2022-10-02 | 20.19 | 0.50 | 2022-09-20 | 1 | 13.88 | 1 | 20.19 | 12 | SO46971 | 2022-09-27 | 1.61 | 13.88 | 20.19 | |||
| SO55260_2 | 0097-43FD-B7 | PO11861162351 | 100 | 283 | 476 | 17 | 5 | 2023-12-02 | 83.99 | 2.10 | 2023-11-20 | 2 | 26.18 | 1 | 83.99 | 2 | SO55260 | 2023-11-27 | 6.72 | 52.35 | 41.99 | |||
| SO48730_8 | C918-466B-B1 | PO522152463 | 100 | 285 | 352 | 676 | 5 | 2023-03-04 | 7457.11 | 186.43 | 2023-02-20 | 6 | 1117.86 | 1 | 7457.11 | 8 | SO48730 | 2023-02-27 | 596.57 | 6707.14 | 1242.85 | |||
| SO51758_2 | 5E6D-4B3F-AB | PO10150121946 | 100 | 285 | 516 | 9 | 5 | 2023-10-02 | 46.97 | 1.17 | 2023-09-20 | 2 | 17.38 | 1 | 46.97 | 2 | SO51758 | 2023-09-27 | 3.76 | 34.76 | 23.48 | |||
| SO65220_21 | 6D87-4C24-98 | PO15457146892 | 100 | 285 | 576 | 297 | 5 | 2024-05-02 | 4291.33 | 107.28 | 2024-04-20 | 3 | 1481.94 | 1 | 4291.33 | 21 | SO65220 | 2024-04-27 | 343.31 | 4445.81 | 1430.44 | |||
| SO46673_20 | 578D-4F7B-A6 | PO9657163155 | 100 | 285 | 216 | 8 | 315 | 5 | 6.73 | 2022-09-01 | 67.29 | 1.51 | 2022-08-20 | 4 | 13.88 | 1 | 60.56 | 20 | SO46673 | 2022-08-27 | 4.84 | 55.51 | 16.82 | 0.10 |
| SO61230_8 | B9F1-4FF8-B4 | PO12644163346 | 100 | 285 | 359 | 530 | 5 | 2024-03-03 | 2753.99 | 68.85 | 2024-02-20 | 2 | 1251.98 | 1 | 2753.99 | 8 | SO61230 | 2024-02-27 | 220.32 | 2503.96 | 1376.99 | |||
| SO47067_15 | DDEC-4319-8A | PO9512118933 | 100 | 285 | 460 | 135 | 5 | 2022-10-02 | 269.97 | 6.75 | 2022-09-20 | 5 | 37.12 | 1 | 269.97 | 15 | SO47067 | 2022-09-27 | 21.60 | 185.60 | 53.99 | |||
| SO44763_4 | 42FB-4859-8F | PO11977198048 | 100 | 285 | 241 | 675 | 5 | 2022-02-01 | 1516.15 | 37.90 | 2022-01-20 | 2 | 747.97 | 1 | 1516.15 | 4 | SO44763 | 2022-01-27 | 121.29 | 1495.94 | 758.08 | |||
| SO48063_24 | AEA4-4489-90 | PO5858143254 | 100 | 285 | 394 | 566 | 5 | 2023-01-02 | 41.04 | 1.03 | 2022-12-21 | 2 | 15.18 | 1 | 41.04 | 24 | SO48063 | 2022-12-28 | 3.28 | 30.37 | 20.52 | |||
| SO46345_1 | 469D-4520-80 | PO13746192187 | 100 | 285 | 345 | 7 | 567 | 5 | 1190.00 | 2022-08-02 | 3399.99 | 55.25 | 2022-07-21 | 4 | 1912.15 | 1 | 2209.99 | 1 | SO46345 | 2022-07-28 | 176.80 | 7648.62 | 850.00 | 0.35 |
| SO63246_12 | 5008-4978-B3 | PO7598198768 | 100 | 285 | 434 | 45 | 5 | 2024-04-03 | 356.90 | 8.92 | 2024-03-22 | 1 | 360.94 | 1 | 356.90 | 12 | SO63246 | 2024-03-29 | 28.55 | 360.94 | 356.90 | |||
| SO53524_44 | 2B2B-440F-8B | PO1537151724 | 100 | 285 | 472 | 611 | 5 | 2023-11-02 | 152.40 | 3.81 | 2023-10-21 | 4 | 23.75 | 1 | 152.40 | 44 | SO53524 | 2023-10-28 | 12.19 | 95.00 | 38.10 | |||
| SO51874_11 | 0176-4E11-91 | PO9773132815 | 100 | 285 | 576 | 8 | 5 | 2023-10-02 | 1430.44 | 35.76 | 2023-09-20 | 1 | 1481.94 | 1 | 1430.44 | 11 | SO51874 | 2023-09-27 | 114.44 | 1481.94 | 1430.44 | |||
| SO44133_4 | 4899-4DD6-93 | PO9599144193 | 100 | 285 | 316 | 170 | 5 | 2021-11-02 | 4373.97 | 109.35 | 2021-10-21 | 5 | 884.71 | 1 | 4373.97 | 4 | SO44133 | 2021-10-28 | 349.92 | 4423.54 | 874.79 | |||
| SO49091_15 | 7A94-486D-8A | PO19546118667 | 100 | 285 | 375 | 206 | 5 | 2023-04-04 | 3926.81 | 98.17 | 2023-03-23 | 3 | 1320.68 | 1 | 3926.81 | 15 | SO49091 | 2023-03-30 | 314.15 | 3962.05 | 1308.94 | |||
| SO65272_1 | 2BA5-452C-BA | PO9106157142 | 100 | 285 | 400 | 602 | 5 | 2024-05-02 | 37.15 | 0.93 | 2024-04-20 | 1 | 27.49 | 1 | 37.15 | 1 | SO65272 | 2024-04-27 | 2.97 | 27.49 | 37.15 | |||
| SO46631_1 | D8CB-44CB-87 | PO11861116846 | 100 | 281 | 410 | 17 | 5 | 2022-09-01 | 72.89 | 1.82 | 2022-08-20 | 2 | 26.97 | 1 | 72.89 | 1 | SO46631 | 2022-08-27 | 5.83 | 53.94 | 36.45 | |||
| SO48393_32 | 5B6A-41B6-BF | PO9599137631 | 100 | 285 | 370 | 170 | 5 | 2023-02-01 | 10262.07 | 256.55 | 2023-01-20 | 7 | 1518.79 | 1 | 10262.07 | 32 | SO48393 | 2023-01-27 | 820.97 | 10631.50 | 1466.01 | |||
| SO71839_39 | 8F89-4B1E-A8 | PO1537119063 | 100 | 285 | 562 | 611 | 5 | 2024-08-02 | 1430.44 | 35.76 | 2024-07-21 | 1 | 1481.94 | 1 | 1430.44 | 39 | SO71839 | 2024-07-28 | 114.44 | 1481.94 | 1430.44 | |||
| SO49836_32 | 0E32-48F7-89 | PO12644185975 | 100 | 285 | 221 | 530 | 5 | 2023-06-02 | 100.93 | 2.52 | 2023-05-21 | 5 | 13.88 | 1 | 100.93 | 32 | SO49836 | 2023-05-28 | 8.07 | 69.39 | 20.19 | |||
| SO55253_28 | C58B-49D8-9F | PO12644132539 | 100 | 285 | 217 | 530 | 5 | 2023-12-02 | 62.98 | 1.57 | 2023-11-20 | 3 | 13.09 | 1 | 62.98 | 28 | SO55253 | 2023-11-27 | 5.04 | 39.26 | 20.99 | |||
| SO55328_17 | 577D-4DE9-B6 | PO9831188161 | 100 | 285 | 237 | 81 | 5 | 2023-12-02 | 59.99 | 1.50 | 2023-11-20 | 2 | 38.49 | 1 | 59.99 | 17 | SO55328 | 2023-11-27 | 4.80 | 76.98 | 29.99 | |||
| SO47965_8 | 953F-437D-84 | PO19546111394 | 100 | 285 | 286 | 206 | 5 | 2023-01-02 | 367.88 | 9.20 | 2022-12-21 | 2 | 170.14 | 1 | 367.88 | 8 | SO47965 | 2022-12-28 | 29.43 | 340.29 | 183.94 | |||
| SO50306_14 | D376-4A40-86 | PO5858194676 | 100 | 285 | 391 | 566 | 5 | 2023-07-02 | 177.86 | 4.45 | 2023-06-20 | 2 | 65.81 | 1 | 177.86 | 14 | SO50306 | 2023-06-27 | 14.23 | 131.62 | 88.93 | |||
| SO51852_5 | 5119-4E7B-97 | PO1247171617 | 100 | 285 | 593 | 296 | 5 | 2023-10-02 | 677.99 | 16.95 | 2023-09-20 | 2 | 308.22 | 1 | 677.99 | 5 | SO51852 | 2023-09-27 | 54.24 | 616.44 | 338.99 | |||
| SO63281_14 | 6B19-4C4E-92 | PO3596158829 | 100 | 285 | 589 | 476 | 5 | 2024-04-03 | 461.69 | 11.54 | 2024-03-22 | 1 | 419.78 | 1 | 461.69 | 14 | SO63281 | 2024-03-29 | 36.94 | 419.78 | 461.69 | |||
| SO49487_2 | 3BC2-4234-86 | PO9048166119 | 100 | 285 | 469 | 652 | 5 | 2023-05-02 | 68.38 | 1.71 | 2023-04-20 | 3 | 15.67 | 1 | 68.38 | 2 | SO49487 | 2023-04-27 | 5.47 | 47.01 | 22.79 | |||
| SO53551_23 | 8593-405C-AB | PO14297167079 | 100 | 285 | 558 | 627 | 5 | 2023-11-02 | 242.99 | 6.07 | 2023-10-21 | 1 | 179.82 | 1 | 242.99 | 23 | SO53551 | 2023-10-28 | 19.44 | 179.82 | 242.99 | |||
| SO49473_4 | EAA2-43E2-87 | PO2813142084 | 100 | 283 | 447 | 90 | 5 | 2023-05-02 | 30.00 | 0.75 | 2023-04-20 | 2 | 10.31 | 1 | 30.00 | 4 | SO49473 | 2023-04-27 | 2.40 | 20.63 | 15.00 | |||
| SO58993_13 | EEB4-42E9-B9 | PO14297167367 | 100 | 285 | 568 | 627 | 5 | 2024-02-01 | 445.41 | 11.14 | 2024-01-20 | 1 | 461.44 | 1 | 445.41 | 13 | SO58993 | 2024-01-27 | 35.63 | 461.44 | 445.41 | |||
| SO49509_10 | 1105-4F75-BE | PO9599181538 | 100 | 285 | 370 | 170 | 5 | 2023-05-02 | 11728.08 | 293.20 | 2023-04-20 | 8 | 1518.79 | 1 | 11728.08 | 10 | SO49509 | 2023-04-27 | 938.25 | 12150.29 | 1466.01 | |||
| SO44506_24 | CD67-4B07-B6 | PO16327113845 | 100 | 285 | 322 | 584 | 5 | 2022-01-02 | 3355.67 | 83.89 | 2021-12-21 | 8 | 413.15 | 1 | 3355.67 | 24 | SO44506 | 2021-12-28 | 268.45 | 3305.17 | 419.46 | |||
| SO57118_11 | 69CB-481B-8D | PO5800191707 | 100 | 285 | 309 | 63 | 5 | 2024-01-02 | 818.70 | 20.47 | 2023-12-21 | 1 | 747.20 | 1 | 818.70 | 11 | SO57118 | 2023-12-28 | 65.50 | 747.20 | 818.70 | |||
| SO45540_5 | B193-41A9-87 | PO13746118798 | 100 | 285 | 347 | 567 | 5 | 2022-05-02 | 8159.98 | 204.00 | 2022-04-20 | 4 | 1912.15 | 1 | 8159.98 | 5 | SO45540 | 2022-04-27 | 652.80 | 7648.62 | 2039.99 |
Generated 2024-09-19 20:34:59.580 UTC