[ROOT] dt FactResellerSale < WHERE DimSalesTerritoryId EQ ALL SKIP 0 SHUFFLE < SKIP 563 > < 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 |
---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
SO43845_10 | 2E65-4D8B-9A | PO19546184286 | 100 | 285 | 223 | 206 | 5 | 2021-10-02 | 20.75 | 0.52 | 2021-09-20 | 4 | 5.71 | 1 | 20.75 | 10 | SO43845 | 2021-09-27 | 1.66 | 22.82 | 5.19 | |||
SO43890_1 | 6787-4174-98 | PO2146115360 | 19 | 284 | 344 | 354 | 6 | 2021-10-02 | 10199.97 | 255.00 | 2021-09-20 | 5 | 1912.15 | 1 | 10199.97 | 1 | SO43890 | 2021-09-27 | 816.00 | 9560.77 | 2039.99 | |||
SO55280_6 | B925-404B-8B | PO18444178908 | 19 | 291 | 440 | 227 | 6 | 2023-12-02 | 858.90 | 21.47 | 2023-11-20 | 1 | 868.63 | 1 | 858.90 | 6 | SO55280 | 2023-11-27 | 68.71 | 868.63 | 858.90 | |||
SO45795_4 | EA72-4C1D-BB | PO12412125626 | 100 | 283 | 223 | 670 | 3 | 2022-06-02 | 10.37 | 0.26 | 2022-05-21 | 2 | 5.71 | 1 | 10.37 | 4 | SO45795 | 2022-05-28 | 0.83 | 11.41 | 5.19 | |||
SO58906_16 | 6BB0-48C1-BE | PO19633186598 | 100 | 287 | 225 | 149 | 3 | 2024-02-01 | 26.97 | 0.67 | 2024-01-20 | 5 | 6.92 | 1 | 26.97 | 16 | SO58906 | 2024-01-27 | 2.16 | 34.61 | 5.39 | |||
SO44127_6 | E778-471D-8A | PO7569162058 | 100 | 287 | 220 | 608 | 4 | 2021-11-02 | 40.37 | 1.01 | 2021-10-21 | 2 | 12.03 | 1 | 40.37 | 6 | SO44127 | 2021-10-28 | 3.23 | 24.06 | 20.19 | |||
SO59027_6 | C142-4AAA-AB | PO6757122081 | 100 | 281 | 516 | 21 | 4 | 2024-02-01 | 46.97 | 1.17 | 2024-01-20 | 2 | 17.38 | 1 | 46.97 | 6 | SO59027 | 2024-01-27 | 3.76 | 34.76 | 23.48 | |||
SO58979_14 | A35B-403A-A4 | PO18038174164 | 100 | 287 | 563 | 509 | 4 | 2024-02-01 | 1430.44 | 35.76 | 2024-01-20 | 1 | 1481.94 | 1 | 1430.44 | 14 | SO58979 | 2024-01-27 | 114.44 | 1481.94 | 1430.44 | |||
SO67295_15 | D785-46A0-BC | PO1711155302 | 19 | 291 | 298 | 245 | 6 | 2024-06-02 | 3239.04 | 80.98 | 2024-05-21 | 4 | 739.04 | 1 | 3239.04 | 15 | SO67295 | 2024-05-28 | 259.12 | 2956.16 | 809.76 | |||
SO51776_7 | 9800-4D08-BA | PO2871145495 | 100 | 283 | 558 | 522 | 2 | 2023-10-02 | 728.98 | 18.22 | 2023-09-20 | 3 | 179.82 | 1 | 728.98 | 7 | SO51776 | 2023-09-27 | 58.32 | 539.45 | 242.99 | |||
SO58908_35 | A429-40BA-96 | PO19285116289 | 98 | 290 | 492 | 448 | 10 | 2024-02-01 | 4216.42 | 105.41 | 2024-01-20 | 7 | 601.74 | 1 | 4216.42 | 35 | SO58908 | 2024-01-27 | 337.31 | 4212.21 | 602.35 | |||
SO71938_31 | 7D23-4E70-B4 | PO8468183315 | 98 | 288 | 582 | 16 | 10 | 2024-08-02 | 5102.97 | 127.57 | 2024-07-21 | 5 | 1082.51 | 1 | 5102.97 | 31 | SO71938 | 2024-07-28 | 408.24 | 5412.55 | 1020.59 | |||
SO55249_51 | 0527-4C9D-BA | PO13688172507 | 100 | 282 | 306 | 475 | 4 | 2023-12-02 | 809.76 | 20.24 | 2023-11-20 | 1 | 739.04 | 1 | 809.76 | 51 | SO55249 | 2023-11-27 | 64.78 | 739.04 | 809.76 | |||
SO44319_12 | FBB9-4CD9-A1 | PO9657142761 | 100 | 285 | 307 | 315 | 5 | 2021-12-02 | 722.59 | 18.06 | 2021-11-20 | 1 | 623.84 | 1 | 722.59 | 12 | SO44319 | 2021-11-27 | 57.81 | 623.84 | 722.59 | |||
SO55233_4 | 1590-499E-95 | PO551184455 | 100 | 281 | 388 | 4 | 4 | 2023-12-02 | 672.29 | 16.81 | 2023-11-20 | 1 | 713.08 | 1 | 672.29 | 4 | SO55233 | 2023-11-27 | 53.78 | 713.08 | 672.29 | |||
SO69552_6 | 542B-4AC0-BA | PO7917166419 | 100 | 287 | 491 | 401 | 1 | 2024-07-02 | 97.18 | 2.43 | 2024-06-20 | 3 | 41.57 | 1 | 97.18 | 6 | SO69552 | 2024-06-27 | 7.77 | 124.72 | 32.39 | |||
SO44559_10 | 8618-4A1B-AD | PO6641148111 | 100 | 281 | 229 | 342 | 2 | 2022-01-02 | 57.68 | 1.44 | 2021-12-21 | 2 | 31.72 | 1 | 57.68 | 10 | SO44559 | 2021-12-28 | 4.61 | 63.45 | 28.84 | |||
SO49844_7 | 84A1-4FF2-A9 | PO899181442 | 100 | 289 | 329 | 290 | 1 | 2023-06-02 | 4697.94 | 117.45 | 2023-05-21 | 10 | 486.71 | 1 | 4697.94 | 7 | SO49844 | 2023-05-28 | 375.84 | 4867.07 | 469.79 | |||
SO50663_25 | 286E-4915-89 | PO19343130555 | 100 | 282 | 459 | 24 | 4 | 2023-08-02 | 485.95 | 12.15 | 2023-07-21 | 9 | 37.12 | 1 | 485.95 | 25 | SO50663 | 2023-07-28 | 38.88 | 334.09 | 53.99 | |||
SO47004_27 | BB9D-49AE-A9 | PO928175019 | 98 | 290 | 356 | 484 | 10 | 2022-10-02 | 4971.41 | 124.29 | 2022-09-20 | 4 | 1117.86 | 1 | 4971.41 | 27 | SO47004 | 2022-09-27 | 397.71 | 4471.42 | 1242.85 | |||
SO48780_14 | F139-41F4-83 | PO5626121558 | 100 | 281 | 417 | 166 | 4 | 2023-03-04 | 324.45 | 8.11 | 2023-02-20 | 1 | 300.12 | 1 | 324.45 | 14 | SO48780 | 2023-02-27 | 25.96 | 300.12 | 324.45 | |||
SO48010_23 | 81A7-4B68-B2 | PO12702168891 | 100 | 292 | 233 | 175 | 7 | 2023-01-02 | 201.88 | 5.05 | 2022-12-21 | 7 | 29.08 | 1 | 201.88 | 23 | SO48010 | 2022-12-28 | 16.15 | 203.56 | 28.84 | |||
SO46627_1 | A7A2-45B6-97 | PO13485114699 | 100 | 292 | 419 | 265 | 7 | 2022-09-01 | 157.94 | 3.95 | 2022-08-20 | 3 | 38.96 | 1 | 157.94 | 1 | SO46627 | 2022-08-27 | 12.64 | 116.88 | 52.65 | |||
SO63133_9 | C3D9-4B73-83 | PO18618146912 | 100 | 286 | 562 | 605 | 1 | 2024-04-03 | 2860.88 | 71.52 | 2024-03-22 | 2 | 1481.94 | 1 | 2860.88 | 9 | SO63133 | 2024-03-29 | 228.87 | 2963.88 | 1430.44 | |||
SO46090_8 | 987E-4B5B-B6 | PO5858172038 | 100 | 285 | 229 | 566 | 5 | 2022-07-02 | 28.84 | 0.72 | 2022-06-20 | 1 | 31.72 | 1 | 28.84 | 8 | SO46090 | 2022-06-27 | 2.31 | 31.72 | 28.84 | |||
SO46640_5 | AE5D-418B-B7 | PO10092115747 | 100 | 281 | 468 | 252 | 2 | 2022-09-01 | 68.38 | 1.71 | 2022-08-20 | 3 | 15.67 | 1 | 68.38 | 5 | SO46640 | 2022-08-27 | 5.47 | 47.01 | 22.79 | |||
SO51778_5 | 420A-4268-A8 | PO3161175221 | 100 | 283 | 487 | 359 | 2 | 2023-10-02 | 131.98 | 3.30 | 2023-09-20 | 4 | 20.57 | 1 | 131.98 | 5 | SO51778 | 2023-09-27 | 10.56 | 82.27 | 32.99 | |||
SO43906_13 | BA78-4228-89 | PO6438197212 | 100 | 283 | 220 | 309 | 4 | 2021-10-02 | 40.37 | 1.01 | 2021-09-20 | 2 | 12.03 | 1 | 40.37 | 13 | SO43906 | 2021-09-27 | 3.23 | 24.06 | 20.19 | |||
SO46994_6 | 5E92-4A19-9E | PO11629171210 | 100 | 281 | 427 | 396 | 2 | 2022-10-02 | 1674.05 | 41.85 | 2022-09-20 | 8 | 185.82 | 1 | 1674.05 | 6 | SO46994 | 2022-09-27 | 133.92 | 1486.55 | 209.26 | |||
SO67294_36 | 85E2-46A1-BE | PO899165491 | 100 | 289 | 214 | 290 | 1 | 2024-06-02 | 20.99 | 0.52 | 2024-05-21 | 1 | 13.09 | 1 | 20.99 | 36 | SO67294 | 2024-05-28 | 1.68 | 13.09 | 20.99 | |||
SO48339_41 | EAB2-42EA-9C | PO10614150674 | 19 | 291 | 422 | 461 | 6 | 2023-02-01 | 67.54 | 1.69 | 2023-01-20 | 1 | 49.98 | 1 | 67.54 | 41 | SO48339 | 2023-01-27 | 5.40 | 49.98 | 67.54 | |||
SO48336_26 | 48F2-4141-9A | PO11455111823 | 100 | 281 | 407 | 72 | 2 | 2023-02-01 | 459.21 | 11.48 | 2023-01-20 | 7 | 48.55 | 1 | 459.21 | 26 | SO48336 | 2023-01-27 | 36.74 | 339.82 | 65.60 | |||
SO49054_1 | 8503-488C-AA | PO14558112909 | 100 | 289 | 470 | 2 | 1 | 2023-04-04 | 45.59 | 1.14 | 2023-03-23 | 2 | 15.67 | 1 | 45.59 | 1 | SO49054 | 2023-03-30 | 3.65 | 31.34 | 22.79 | |||
SO45281_2 | 6423-4DCE-A3 | PO16849114209 | 100 | 281 | 319 | 198 | 3 | 2022-04-04 | 874.79 | 21.87 | 2022-03-23 | 1 | 884.71 | 1 | 874.79 | 2 | SO45281 | 2022-03-30 | 69.98 | 884.71 | 874.79 | |||
SO50726_12 | A80B-408E-B3 | PO9599192861 | 100 | 285 | 337 | 170 | 5 | 2023-08-02 | 2818.76 | 70.47 | 2023-07-21 | 6 | 486.71 | 1 | 2818.76 | 12 | SO50726 | 2023-07-28 | 225.50 | 2920.24 | 469.79 | |||
SO46028_5 | 7BBE-413C-83 | PO19546126425 | 100 | 285 | 330 | 206 | 5 | 2022-07-02 | 419.46 | 10.49 | 2022-06-20 | 1 | 413.15 | 1 | 419.46 | 5 | SO46028 | 2022-06-27 | 33.56 | 413.15 | 419.46 | |||
SO50222_37 | 4FDE-4C03-A9 | PO13427181046 | 100 | 292 | 339 | 638 | 7 | 2023-07-02 | 939.59 | 23.49 | 2023-06-20 | 2 | 486.71 | 1 | 939.59 | 37 | SO50222 | 2023-06-27 | 75.17 | 973.41 | 469.79 | |||
SO67284_20 | 8286-4B8D-89 | PO11484111023 | 100 | 283 | 361 | 594 | 2 | 2024-06-02 | 5507.98 | 137.70 | 2024-05-21 | 4 | 1251.98 | 1 | 5507.98 | 20 | SO67284 | 2024-05-28 | 440.64 | 5007.93 | 1376.99 | |||
SO65199_10 | F8B4-4F74-87 | PO870111351 | 100 | 286 | 570 | 621 | 1 | 2024-05-02 | 890.82 | 22.27 | 2024-04-20 | 2 | 461.44 | 1 | 890.82 | 10 | SO65199 | 2024-04-27 | 71.27 | 922.89 | 445.41 | |||
SO50215_3 | 820D-41FC-BE | PO14529171237 | 100 | 293 | 358 | 289 | 1 | 2023-07-02 | 1229.46 | 30.74 | 2023-06-20 | 1 | 1105.81 | 1 | 1229.46 | 3 | SO50215 | 2023-06-27 | 98.36 | 1105.81 | 1229.46 | |||
SO48771_1 | E98F-4302-92 | PO8410125811 | 98 | 288 | 461 | 538 | 10 | 2023-03-04 | 107.99 | 2.70 | 2023-02-20 | 2 | 37.12 | 1 | 107.99 | 1 | SO48771 | 2023-02-27 | 8.64 | 74.24 | 53.99 | |||
SO47441_33 | 2582-4E47-98 | PO7569166535 | 100 | 287 | 289 | 608 | 4 | 2022-11-02 | 2977.09 | 74.43 | 2022-10-21 | 4 | 660.91 | 1 | 2977.09 | 33 | SO47441 | 2022-10-28 | 238.17 | 2643.66 | 744.27 | |||
SO51720_9 | E39F-4680-AC | PO15370128892 | 100 | 281 | 516 | 381 | 3 | 2023-10-02 | 46.97 | 1.17 | 2023-09-20 | 2 | 17.38 | 1 | 46.97 | 9 | SO51720 | 2023-09-27 | 3.76 | 34.76 | 23.48 | |||
SO53567_3 | 2385-4ADE-B6 | PO9628113784 | 100 | 283 | 225 | 3 | 179 | 2 | 4.20 | 2023-11-02 | 84.06 | 2.00 | 2023-10-21 | 17 | 6.92 | 1 | 79.85 | 3 | SO53567 | 2023-10-28 | 6.39 | 117.68 | 4.94 | 0.05 |
SO46368_21 | BF32-47A9-90 | PO4408111909 | 100 | 281 | 342 | 143 | 2 | 2022-08-02 | 1258.38 | 31.46 | 2022-07-21 | 3 | 413.15 | 1 | 1258.38 | 21 | SO46368 | 2022-07-28 | 100.67 | 1239.44 | 419.46 | |||
SO46620_13 | FEE3-4994-8E | PO13775143788 | 100 | 281 | 459 | 618 | 2 | 2022-09-01 | 215.98 | 5.40 | 2022-08-20 | 4 | 37.12 | 1 | 215.98 | 13 | SO46620 | 2022-08-27 | 17.28 | 148.48 | 53.99 | |||
SO57037_31 | F0A9-4A16-B9 | PO15370120234 | 100 | 281 | 298 | 381 | 3 | 2024-01-02 | 809.76 | 20.24 | 2023-12-21 | 1 | 739.04 | 1 | 809.76 | 31 | SO57037 | 2023-12-28 | 64.78 | 739.04 | 809.76 | |||
SO51712_33 | 910D-4560-A7 | PO16675134576 | 100 | 293 | 491 | 3 | 361 | 1 | 22.27 | 2023-10-02 | 445.42 | 10.58 | 2023-09-20 | 15 | 41.57 | 1 | 423.15 | 33 | SO51712 | 2023-09-27 | 33.85 | 623.58 | 29.69 | 0.05 |
SO46645_35 | F857-4A6D-9C | PO1711132491 | 19 | 291 | 352 | 245 | 6 | 2022-09-01 | 7457.11 | 186.43 | 2022-08-20 | 6 | 1117.86 | 1 | 7457.11 | 35 | SO46645 | 2022-08-27 | 596.57 | 6707.14 | 1242.85 | |||
SO65311_11 | 8732-477D-BC | PO7047142102 | 100 | 281 | 306 | 544 | 3 | 2024-05-02 | 809.76 | 20.24 | 2024-04-20 | 1 | 739.04 | 1 | 809.76 | 11 | SO65311 | 2024-04-27 | 64.78 | 739.04 | 809.76 | |||
SO45299_20 | 0D55-4B85-AD | PO12557162961 | 100 | 282 | 220 | 240 | 4 | 2022-04-04 | 60.56 | 1.51 | 2022-03-23 | 3 | 12.03 | 1 | 60.56 | 20 | SO45299 | 2022-03-30 | 4.84 | 36.08 | 20.19 | |||
SO49893_16 | 99ED-4EEC-9C | PO8787173621 | 100 | 282 | 331 | 523 | 3 | 2023-06-02 | 3288.56 | 82.21 | 2023-05-21 | 7 | 486.71 | 1 | 3288.56 | 16 | SO49893 | 2023-05-28 | 263.08 | 3406.95 | 469.79 | |||
SO53474_33 | E5B6-4103-8D | PO15457187993 | 100 | 285 | 554 | 297 | 5 | 2023-11-02 | 109.88 | 2.75 | 2023-10-21 | 2 | 40.66 | 1 | 109.88 | 33 | SO53474 | 2023-10-28 | 8.79 | 81.31 | 54.94 | |||
SO69485_1 | E19F-443F-BB | PO16211116121 | 100 | 285 | 599 | 99 | 5 | 2024-07-02 | 323.99 | 8.10 | 2024-06-20 | 1 | 294.58 | 1 | 323.99 | 1 | SO69485 | 2024-06-27 | 25.92 | 294.58 | 323.99 | |||
SO50683_12 | 8EBE-4D2C-AB | PO11455112273 | 100 | 283 | 323 | 72 | 2 | 2023-08-02 | 1879.18 | 46.98 | 2023-07-21 | 4 | 486.71 | 1 | 1879.18 | 12 | SO50683 | 2023-07-28 | 150.33 | 1946.83 | 469.79 | |||
SO58940_18 | 72B7-4C82-8A | PO13543115032 | 100 | 287 | 512 | 293 | 1 | 2024-02-01 | 655.36 | 16.38 | 2024-01-20 | 3 | 199.38 | 1 | 655.36 | 18 | SO58940 | 2024-01-27 | 52.43 | 598.13 | 218.45 | |||
SO65248_21 | A7B5-4EE1-98 | PO9599164617 | 100 | 285 | 382 | 170 | 5 | 2024-05-02 | 3361.47 | 84.04 | 2024-04-20 | 5 | 713.08 | 1 | 3361.47 | 21 | SO65248 | 2024-04-27 | 268.92 | 3565.40 | 672.29 | |||
SO49053_21 | 5BE4-4969-A1 | PO16414175823 | 100 | 289 | 447 | 236 | 1 | 2023-04-04 | 75.00 | 1.88 | 2023-03-23 | 5 | 10.31 | 1 | 75.00 | 21 | SO49053 | 2023-03-30 | 6.00 | 51.56 | 15.00 | |||
SO50294_26 | F34B-46CA-8D | PO3799186112 | 100 | 282 | 447 | 312 | 4 | 2023-07-02 | 60.00 | 1.50 | 2023-06-20 | 4 | 10.31 | 1 | 60.00 | 26 | SO50294 | 2023-06-27 | 4.80 | 41.25 | 15.00 | |||
SO48053_3 | 69FC-4D14-B1 | PO4466199959 | 19 | 291 | 367 | 352 | 6 | 2023-01-02 | 647.99 | 16.20 | 2022-12-21 | 1 | 598.44 | 1 | 647.99 | 3 | SO48053 | 2022-12-28 | 51.84 | 598.44 | 647.99 | |||
SO47436_11 | 4AA1-4884-91 | PO5510133089 | 100 | 287 | 414 | 5 | 4 | 2022-11-02 | 149.03 | 3.73 | 2022-10-21 | 1 | 110.28 | 1 | 149.03 | 11 | SO47436 | 2022-10-28 | 11.92 | 110.28 | 149.03 | |||
SO51104_44 | D008-4004-A4 | PO13340177593 | 100 | 292 | 595 | 355 | 7 | 2023-09-01 | 338.99 | 8.47 | 2023-08-20 | 1 | 308.22 | 1 | 338.99 | 44 | SO51104 | 2023-08-27 | 27.12 | 308.22 | 338.99 |
Generated 2024-09-19 19:12:58.986 UTC