[ROOT] dt FactResellerSale < WHERE DimSalesTerritoryId EQ '5' > SKIP 0 SHUFFLE < SKIP 2187 > < 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 |
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
| SO49473_5 | EAA2-43E2-87 | PO2813142084 | 100 | 283 | 221 | 90 | 5 | 2023-06-23 | 100.93 | 2.52 | 2023-06-11 | 5 | 13.88 | 1 | 100.93 | 5 | SO49473 | 2023-06-18 | 8.07 | 69.39 | 20.19 | |||
| SO45062_14 | 017E-486E-BC | PO1189166374 | 100 | 285 | 316 | 423 | 5 | 2022-04-25 | 2624.38 | 65.61 | 2022-04-13 | 3 | 884.71 | 1 | 2624.38 | 14 | SO45062 | 2022-04-20 | 209.95 | 2654.12 | 874.79 | |||
| SO47455_31 | 41F3-48C2-B7 | PO9599169586 | 100 | 285 | 423 | 170 | 5 | 2022-12-24 | 330.46 | 8.26 | 2022-12-12 | 2 | 122.27 | 1 | 330.46 | 31 | SO47455 | 2022-12-19 | 26.44 | 244.54 | 165.23 | |||
| SO55260_8 | 0097-43FD-B7 | PO11861162351 | 100 | 283 | 474 | 2 | 17 | 5 | 9.74 | 2024-01-23 | 487.13 | 11.93 | 2024-01-11 | 12 | 26.18 | 1 | 477.39 | 8 | SO55260 | 2024-01-18 | 38.19 | 314.12 | 40.59 | 0.02 |
| SO55234_28 | C6FC-46EE-88 | PO522140495 | 100 | 285 | 214 | 676 | 5 | 2024-01-23 | 146.96 | 3.67 | 2024-01-11 | 7 | 13.09 | 1 | 146.96 | 28 | SO55234 | 2024-01-18 | 11.76 | 91.60 | 20.99 | |||
| SO50703_32 | 4A3D-44CB-B3 | PO2813140706 | 100 | 283 | 415 | 90 | 5 | 2023-09-23 | 792.14 | 19.80 | 2023-09-11 | 4 | 146.55 | 1 | 792.14 | 32 | SO50703 | 2023-09-18 | 63.37 | 586.19 | 198.04 | |||
| SO51760_7 | 2C2D-41C9-8C | PO9918180623 | 100 | 285 | 506 | 260 | 5 | 2023-11-23 | 400.10 | 10.00 | 2023-11-11 | 2 | 199.85 | 1 | 400.10 | 7 | SO51760 | 2023-11-18 | 32.01 | 399.70 | 200.05 | |||
| SO49869_12 | A2BD-4A89-93 | PO9657193666 | 100 | 285 | 360 | 315 | 5 | 2023-07-24 | 7376.75 | 184.42 | 2023-07-12 | 6 | 1105.81 | 1 | 7376.75 | 12 | SO49869 | 2023-07-19 | 590.14 | 6634.86 | 1229.46 | |||
| SO50723_1 | 9670-429D-93 | PO11977146614 | 100 | 285 | 429 | 675 | 5 | 2023-09-23 | 324.45 | 8.11 | 2023-09-11 | 1 | 300.12 | 1 | 324.45 | 1 | SO50723 | 2023-09-18 | 25.96 | 300.12 | 324.45 | |||
| SO51775_15 | 5DF8-4C96-81 | PO2842127356 | 100 | 285 | 388 | 700 | 5 | 2023-11-23 | 1344.59 | 33.61 | 2023-11-11 | 2 | 713.08 | 1 | 1344.59 | 15 | SO51775 | 2023-11-18 | 107.57 | 1426.16 | 672.29 | |||
| SO65242_20 | 0175-4222-B3 | PO14297142992 | 100 | 285 | 574 | 627 | 5 | 2024-06-23 | 2860.88 | 71.52 | 2024-06-11 | 2 | 1481.94 | 1 | 2860.88 | 20 | SO65242 | 2024-06-18 | 228.87 | 2963.88 | 1430.44 | |||
| SO47026_10 | 123B-481F-8F | PO3596190739 | 100 | 285 | 468 | 476 | 5 | 2022-11-23 | 45.59 | 1.14 | 2022-11-11 | 2 | 15.67 | 1 | 45.59 | 10 | SO47026 | 2022-11-18 | 3.65 | 31.34 | 22.79 | |||
| SO53524_33 | 2B2B-440F-8B | PO1537151724 | 100 | 285 | 506 | 611 | 5 | 2023-12-24 | 400.10 | 10.00 | 2023-12-12 | 2 | 199.85 | 1 | 400.10 | 33 | SO53524 | 2023-12-19 | 32.01 | 399.70 | 200.05 | |||
| SO43684_2 | 8C01-4CC0-A9 | PO3393188842 | 100 | 285 | 326 | 549 | 5 | 2021-10-23 | 838.92 | 20.97 | 2021-10-11 | 2 | 413.15 | 1 | 838.92 | 2 | SO43684 | 2021-10-18 | 67.11 | 826.29 | 419.46 | |||
| SO63245_17 | 1025-4AD1-A1 | PO5800120355 | 100 | 285 | 551 | 63 | 5 | 2024-05-25 | 158.43 | 3.96 | 2024-05-13 | 1 | 144.59 | 1 | 158.43 | 17 | SO63245 | 2024-05-20 | 12.67 | 144.59 | 158.43 | |||
| SO46943_4 | 6F43-4A10-80 | PO18560122957 | 100 | 285 | 414 | 531 | 5 | 2022-11-23 | 298.06 | 7.45 | 2022-11-11 | 2 | 110.28 | 1 | 298.06 | 4 | SO46943 | 2022-11-18 | 23.85 | 220.57 | 149.03 | |||
| SO47965_14 | 953F-437D-84 | PO19546111394 | 100 | 285 | 375 | 206 | 5 | 2023-02-23 | 2617.88 | 65.45 | 2023-02-11 | 2 | 1320.68 | 1 | 2617.88 | 14 | SO47965 | 2023-02-18 | 209.43 | 2641.37 | 1308.94 | |||
| SO50191_34 | 1DDA-4B5A-95 | PO19546193423 | 100 | 285 | 375 | 206 | 5 | 2023-08-23 | 2617.88 | 65.45 | 2023-08-11 | 2 | 1320.68 | 1 | 2617.88 | 34 | SO50191 | 2023-08-18 | 209.43 | 2641.37 | 1308.94 | |||
| SO65249_5 | E573-4D05-8A | PO9222183651 | 100 | 285 | 482 | 171 | 5 | 2024-06-23 | 43.15 | 1.08 | 2024-06-11 | 8 | 3.36 | 1 | 43.15 | 5 | SO65249 | 2024-06-18 | 3.45 | 26.90 | 5.39 | |||
| SO63246_5 | 5008-4978-B3 | PO7598198768 | 100 | 285 | 482 | 45 | 5 | 2024-05-25 | 5.39 | 0.13 | 2024-05-13 | 1 | 3.36 | 1 | 5.39 | 5 | SO63246 | 2024-05-20 | 0.43 | 3.36 | 5.39 | |||
| SO63151_1 | 0403-41DE-B0 | PO15051199768 | 100 | 285 | 476 | 207 | 5 | 2024-05-25 | 167.98 | 4.20 | 2024-05-13 | 4 | 26.18 | 1 | 167.98 | 1 | SO63151 | 2024-05-20 | 13.44 | 104.71 | 41.99 | |||
| SO44506_20 | CD67-4B07-B6 | PO16327113845 | 100 | 285 | 253 | 584 | 5 | 2022-02-23 | 178.58 | 4.46 | 2022-02-11 | 1 | 176.20 | 1 | 178.58 | 20 | SO44506 | 2022-02-18 | 14.29 | 176.20 | 178.58 | |||
| SO44305_4 | E906-4DF2-BE | PO522153226 | 100 | 285 | 347 | 676 | 5 | 2022-01-23 | 4079.99 | 102.00 | 2022-01-11 | 2 | 1912.15 | 1 | 4079.99 | 4 | SO44305 | 2022-01-18 | 326.40 | 3824.31 | 2039.99 | |||
| SO61230_16 | B9F1-4FF8-B4 | PO12644163346 | 100 | 285 | 484 | 530 | 5 | 2024-04-24 | 9.54 | 0.24 | 2024-04-12 | 2 | 2.97 | 1 | 9.54 | 16 | SO61230 | 2024-04-19 | 0.76 | 5.95 | 4.77 | |||
| SO51780_16 | 30C4-4B8F-AA | PO18560115626 | 100 | 285 | 225 | 531 | 5 | 2023-11-23 | 10.79 | 0.27 | 2023-11-11 | 2 | 6.92 | 1 | 10.79 | 16 | SO51780 | 2023-11-18 | 0.86 | 13.84 | 5.39 | |||
| SO46045_14 | 9345-48CB-A5 | PO16327127643 | 100 | 285 | 223 | 584 | 5 | 2022-08-23 | 31.12 | 0.78 | 2022-08-11 | 6 | 5.71 | 1 | 31.12 | 14 | SO46045 | 2022-08-18 | 2.49 | 34.23 | 5.19 | |||
| SO51775_41 | 5DF8-4C96-81 | PO2842127356 | 100 | 285 | 408 | 700 | 5 | 2023-11-23 | 144.32 | 3.61 | 2023-11-11 | 2 | 53.40 | 1 | 144.32 | 41 | SO51775 | 2023-11-18 | 11.55 | 106.80 | 72.16 | |||
| SO71839_7 | 8F89-4B1E-A8 | PO1537119063 | 100 | 285 | 467 | 611 | 5 | 2024-09-23 | 58.78 | 1.47 | 2024-09-11 | 4 | 9.16 | 1 | 58.78 | 7 | SO71839 | 2024-09-18 | 4.70 | 36.64 | 14.69 | |||
| SO65248_24 | A7B5-4EE1-98 | PO9599164617 | 100 | 285 | 545 | 170 | 5 | 2024-06-23 | 48.59 | 1.21 | 2024-06-11 | 2 | 17.98 | 1 | 48.59 | 24 | SO65248 | 2024-06-18 | 3.89 | 35.96 | 24.29 | |||
| SO47067_13 | DDEC-4319-8A | PO9512118933 | 100 | 285 | 216 | 135 | 5 | 2022-11-23 | 60.56 | 1.51 | 2022-11-11 | 3 | 13.88 | 1 | 60.56 | 13 | SO47067 | 2022-11-18 | 4.84 | 41.63 | 20.19 | |||
| SO47693_32 | 3962-4A1A-93 | PO522165713 | 100 | 285 | 213 | 676 | 5 | 2023-01-23 | 161.49 | 4.04 | 2023-01-11 | 8 | 13.88 | 1 | 161.49 | 32 | SO47693 | 2023-01-18 | 12.92 | 111.03 | 20.19 | |||
| SO50306_35 | D376-4A40-86 | PO5858194676 | 100 | 285 | 462 | 566 | 5 | 2023-08-23 | 70.64 | 1.77 | 2023-08-11 | 5 | 9.71 | 1 | 70.64 | 35 | SO50306 | 2023-08-18 | 5.65 | 48.57 | 14.13 | |||
| SO63246_13 | 5008-4978-B3 | PO7598198768 | 100 | 285 | 436 | 45 | 5 | 2024-05-25 | 356.90 | 8.92 | 2024-05-13 | 1 | 360.94 | 1 | 356.90 | 13 | SO63246 | 2024-05-20 | 28.55 | 360.94 | 356.90 | |||
| SO51758_1 | 5E6D-4B3F-AB | PO10150121946 | 100 | 285 | 549 | 9 | 5 | 2023-11-23 | 655.36 | 16.38 | 2023-11-11 | 3 | 199.38 | 1 | 655.36 | 1 | SO51758 | 2023-11-18 | 52.43 | 598.13 | 218.45 | |||
| SO47693_8 | 3962-4A1A-93 | PO522165713 | 100 | 285 | 354 | 676 | 5 | 2023-01-23 | 2485.70 | 62.14 | 2023-01-11 | 2 | 1117.86 | 1 | 2485.70 | 8 | SO47693 | 2023-01-18 | 198.86 | 2235.71 | 1242.85 | |||
| SO53551_21 | 8593-405C-AB | PO14297167079 | 100 | 285 | 575 | 627 | 5 | 2023-12-24 | 1430.44 | 35.76 | 2023-12-12 | 1 | 1481.94 | 1 | 1430.44 | 21 | SO53551 | 2023-12-19 | 114.44 | 1481.94 | 1430.44 | |||
| SO71821_5 | 3D95-45AC-A2 | PO11977190694 | 100 | 285 | 378 | 675 | 5 | 2024-09-23 | 1466.01 | 36.65 | 2024-09-11 | 1 | 1554.95 | 1 | 1466.01 | 5 | SO71821 | 2024-09-18 | 117.28 | 1554.95 | 1466.01 | |||
| SO63235_4 | 2F82-44A0-A0 | PO5568158964 | 100 | 285 | 474 | 422 | 5 | 2024-05-25 | 419.94 | 10.50 | 2024-05-13 | 10 | 26.18 | 1 | 419.94 | 4 | SO63235 | 2024-05-20 | 33.60 | 261.76 | 41.99 | |||
| SO43902_5 | E3ED-44B5-B2 | PO5858178400 | 100 | 285 | 307 | 566 | 5 | 2021-11-23 | 3612.97 | 90.32 | 2021-11-11 | 5 | 623.84 | 1 | 3612.97 | 5 | SO43902 | 2021-11-18 | 289.04 | 3119.20 | 722.59 | |||
| SO63228_3 | 8736-4385-98 | PO11542125349 | 100 | 285 | 583 | 62 | 5 | 2024-05-25 | 1020.59 | 25.51 | 2024-05-13 | 1 | 1082.51 | 1 | 1020.59 | 3 | SO63228 | 2024-05-20 | 81.65 | 1082.51 | 1020.59 | |||
| SO67348_14 | 4BD1-4782-A3 | PO9889141767 | 100 | 285 | 361 | 494 | 5 | 2024-07-24 | 1376.99 | 34.42 | 2024-07-12 | 1 | 1251.98 | 1 | 1376.99 | 14 | SO67348 | 2024-07-19 | 110.16 | 1251.98 | 1376.99 | |||
| SO57088_15 | EA31-4951-8A | PO2842199218 | 100 | 285 | 580 | 700 | 5 | 2024-02-23 | 1020.59 | 25.51 | 2024-02-11 | 1 | 1082.51 | 1 | 1020.59 | 15 | SO57088 | 2024-02-18 | 81.65 | 1082.51 | 1020.59 | |||
| SO55328_17 | 577D-4DE9-B6 | PO9831188161 | 100 | 285 | 237 | 81 | 5 | 2024-01-23 | 59.99 | 1.50 | 2024-01-11 | 2 | 38.49 | 1 | 59.99 | 17 | SO55328 | 2024-01-18 | 4.80 | 76.98 | 29.99 | |||
| SO69518_22 | 96AA-48F8-80 | PO5800191682 | 100 | 285 | 398 | 63 | 5 | 2024-08-23 | 26.72 | 0.67 | 2024-08-11 | 1 | 19.78 | 1 | 26.72 | 22 | SO69518 | 2024-08-18 | 2.14 | 19.78 | 26.72 | |||
| SO43875_4 | CE1F-4E31-89 | PO12586178184 | 100 | 285 | 218 | 278 | 5 | 2021-11-23 | 11.40 | 0.29 | 2021-11-11 | 2 | 3.40 | 1 | 11.40 | 4 | SO43875 | 2021-11-18 | 0.91 | 6.79 | 5.70 | |||
| SO45270_15 | 61D0-418B-8C | PO19546173994 | 100 | 285 | 314 | 206 | 5 | 2022-05-26 | 2146.96 | 53.67 | 2022-05-14 | 1 | 2171.29 | 1 | 2146.96 | 15 | SO45270 | 2022-05-21 | 171.76 | 2171.29 | 2146.96 | |||
| SO47726_29 | 7256-4599-93 | PO9657190563 | 100 | 285 | 221 | 315 | 5 | 2023-01-23 | 80.75 | 2.02 | 2023-01-11 | 4 | 13.88 | 1 | 80.75 | 29 | SO47726 | 2023-01-18 | 6.46 | 55.51 | 20.19 | |||
| SO47026_7 | 123B-481F-8F | PO3596190739 | 100 | 285 | 409 | 476 | 5 | 2022-11-23 | 418.51 | 10.46 | 2022-11-11 | 2 | 185.82 | 1 | 418.51 | 7 | SO47026 | 2022-11-18 | 33.48 | 371.64 | 209.26 | |||
| SO63293_2 | 12C9-43D2-B4 | PO9918196921 | 100 | 285 | 562 | 260 | 5 | 2024-05-25 | 1430.44 | 35.76 | 2024-05-13 | 1 | 1481.94 | 1 | 1430.44 | 2 | SO63293 | 2024-05-20 | 114.44 | 1481.94 | 1430.44 | |||
| SO53474_28 | E5B6-4103-8D | PO15457187993 | 100 | 285 | 559 | 297 | 5 | 2023-12-24 | 48.58 | 1.21 | 2023-12-12 | 4 | 8.99 | 1 | 48.58 | 28 | SO53474 | 2023-12-19 | 3.89 | 35.95 | 12.14 | |||
| SO46604_21 | 8062-4A97-B3 | PO522154989 | 100 | 285 | 233 | 676 | 5 | 2022-10-23 | 201.88 | 5.05 | 2022-10-11 | 7 | 29.08 | 1 | 201.88 | 21 | SO46604 | 2022-10-18 | 16.15 | 203.56 | 28.84 | |||
| SO50703_21 | 4A3D-44CB-B3 | PO2813140706 | 100 | 283 | 254 | 90 | 5 | 2023-09-23 | 919.69 | 22.99 | 2023-09-11 | 5 | 170.14 | 1 | 919.69 | 21 | SO50703 | 2023-09-18 | 73.58 | 850.71 | 183.94 | |||
| SO50293_15 | D649-4CE8-91 | PO3596144572 | 100 | 285 | 409 | 476 | 5 | 2023-08-23 | 418.51 | 10.46 | 2023-08-11 | 2 | 185.82 | 1 | 418.51 | 15 | SO50293 | 2023-08-18 | 33.48 | 371.64 | 209.26 | |||
| SO55328_35 | 577D-4DE9-B6 | PO9831188161 | 100 | 285 | 488 | 81 | 5 | 2024-01-23 | 323.94 | 8.10 | 2024-01-11 | 10 | 41.57 | 1 | 323.94 | 35 | SO55328 | 2024-01-18 | 25.92 | 415.72 | 32.39 | |||
| SO45779_1 | 983F-42E3-90 | PO522162183 | 100 | 285 | 348 | 676 | 5 | 2022-07-24 | 4049.99 | 101.25 | 2022-07-12 | 2 | 1898.09 | 1 | 4049.99 | 1 | SO45779 | 2022-07-19 | 324.00 | 3796.19 | 2024.99 | |||
| SO48075_14 | DB59-481D-87 | PO7598114627 | 100 | 285 | 415 | 45 | 5 | 2023-02-23 | 396.07 | 9.90 | 2023-02-11 | 2 | 146.55 | 1 | 396.07 | 14 | SO48075 | 2023-02-18 | 31.69 | 293.09 | 198.04 | |||
| SO44488_8 | 18BD-4C15-81 | PO19546136242 | 100 | 285 | 232 | 206 | 5 | 2022-02-23 | 57.68 | 1.44 | 2022-02-11 | 2 | 31.72 | 1 | 57.68 | 8 | SO44488 | 2022-02-18 | 4.61 | 63.45 | 28.84 | |||
| SO49524_3 | 62E9-414A-91 | PO4089179431 | 100 | 285 | 468 | 368 | 5 | 2023-06-23 | 91.18 | 2.28 | 2023-06-11 | 4 | 15.67 | 1 | 91.18 | 3 | SO49524 | 2023-06-18 | 7.29 | 62.68 | 22.79 | |||
| SO53524_51 | 2B2B-440F-8B | PO1537151724 | 100 | 285 | 231 | 611 | 5 | 2023-12-24 | 119.98 | 3.00 | 2023-12-12 | 4 | 38.49 | 1 | 119.98 | 51 | SO53524 | 2023-12-19 | 9.60 | 153.97 | 29.99 | |||
| SO69465_5 | B8B2-4B14-99 | PO2842153886 | 100 | 285 | 547 | 700 | 5 | 2024-08-23 | 145.78 | 3.64 | 2024-08-11 | 3 | 35.96 | 1 | 145.78 | 5 | SO69465 | 2024-08-18 | 11.66 | 107.88 | 48.59 | |||
| SO43875_19 | CE1F-4E31-89 | PO12586178184 | 100 | 285 | 215 | 278 | 5 | 2021-11-23 | 100.93 | 2.52 | 2021-11-11 | 5 | 12.03 | 1 | 100.93 | 19 | SO43875 | 2021-11-18 | 8.07 | 60.14 | 20.19 | |||
| SO46673_5 | 578D-4F7B-A6 | PO9657163155 | 100 | 285 | 221 | 8 | 315 | 5 | 16.82 | 2022-10-23 | 168.22 | 3.79 | 2022-10-11 | 10 | 13.88 | 1 | 151.40 | 5 | SO46673 | 2022-10-18 | 12.11 | 138.78 | 16.82 | 0.10 |
Generated 2024-11-10 12:17:44.771 UTC