[ROOT] dt FactResellerSale < WHERE DimSalesTerritoryId EQ ALL SHUFFLE < SKIP 84 > < 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 |
---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
SO46967_8 | 6486-4AF8-A6 | PO15573116583 | 100 | 286 | 428 | 487 | 1 | 2022-10-03 | 837.02 | 20.93 | 2022-09-21 | 4 | 185.82 | 1 | 837.02 | 8 | SO46967 | 2022-09-28 | 66.96 | 743.28 | 209.26 | |||
SO47060_1 | EB95-4576-BD | PO8439173348 | 98 | 288 | 263 | 574 | 10 | 2022-10-03 | 607.00 | 15.17 | 2022-09-21 | 3 | 187.16 | 1 | 607.00 | 1 | SO47060 | 2022-09-28 | 48.56 | 561.47 | 202.33 | |||
SO47055_22 | BF62-4954-A7 | PO7453164163 | 100 | 281 | 323 | 108 | 2 | 2022-10-03 | 3758.35 | 93.96 | 2022-09-21 | 8 | 486.71 | 1 | 3758.35 | 22 | SO47055 | 2022-09-28 | 300.67 | 3893.65 | 469.79 | |||
SO49464_26 | C383-45FE-83 | PO841195010 | 100 | 286 | 421 | 254 | 1 | 2023-05-03 | 196.33 | 4.91 | 2023-04-21 | 1 | 145.28 | 1 | 196.33 | 26 | SO49464 | 2023-04-28 | 15.71 | 145.28 | 196.33 | |||
SO47009_7 | 8F7C-4372-A2 | PO1508115971 | 98 | 288 | 370 | 430 | 10 | 2022-10-03 | 5864.04 | 146.60 | 2022-09-21 | 4 | 1518.79 | 1 | 5864.04 | 7 | SO47009 | 2022-09-28 | 469.12 | 6075.15 | 1466.01 | |||
SO69475_24 | F74A-4967-BA | PO18618162557 | 100 | 286 | 480 | 605 | 1 | 2024-07-03 | 1.37 | 0.03 | 2024-06-21 | 1 | 0.86 | 1 | 1.37 | 24 | SO69475 | 2024-06-28 | 0.11 | 0.86 | 1.37 | |||
SO65258_8 | 6CDC-4EA0-B2 | PO13543123789 | 100 | 287 | 524 | 293 | 1 | 2024-05-03 | 158.43 | 3.96 | 2024-04-21 | 1 | 144.59 | 1 | 158.43 | 8 | SO65258 | 2024-04-28 | 12.67 | 144.59 | 158.43 | |||
SO51108_27 | 8650-4A20-B1 | PO12644151814 | 100 | 285 | 551 | 530 | 5 | 2023-09-02 | 158.43 | 3.96 | 2023-08-21 | 1 | 144.59 | 1 | 158.43 | 27 | SO51108 | 2023-08-28 | 12.67 | 144.59 | 158.43 | |||
SO71791_1 | AB1B-4CE2-BA | PO17139191080 | 100 | 293 | 378 | 644 | 1 | 2024-08-03 | 2932.02 | 73.30 | 2024-07-22 | 2 | 1554.95 | 1 | 2932.02 | 1 | SO71791 | 2024-07-29 | 234.56 | 3109.90 | 1466.01 | |||
SO55291_8 | 4FAB-4BAB-88 | PO7076160432 | 100 | 293 | 523 | 505 | 1 | 2023-12-03 | 31.58 | 0.79 | 2023-11-21 | 1 | 23.37 | 1 | 31.58 | 8 | SO55291 | 2023-11-28 | 2.53 | 23.37 | 31.58 | |||
SO50668_13 | A5FC-4831-B4 | PO17574113752 | 19 | 291 | 410 | 678 | 6 | 2023-08-03 | 218.68 | 5.47 | 2023-07-22 | 6 | 26.97 | 1 | 218.68 | 13 | SO50668 | 2023-07-29 | 17.49 | 161.82 | 36.45 | |||
SO51739_39 | AF60-4F2F-9B | PO12702124697 | 100 | 292 | 477 | 175 | 7 | 2023-10-03 | 20.96 | 0.52 | 2023-09-21 | 7 | 1.87 | 1 | 20.96 | 39 | SO51739 | 2023-09-28 | 1.68 | 13.06 | 2.99 | |||
SO47996_19 | B6EA-4582-9E | PO15370152849 | 100 | 283 | 360 | 381 | 3 | 2023-01-03 | 6147.29 | 153.68 | 2022-12-22 | 5 | 1105.81 | 1 | 6147.29 | 19 | SO47996 | 2022-12-29 | 491.78 | 5529.05 | 1229.46 | |||
SO50306_16 | D376-4A40-86 | PO5858194676 | 100 | 285 | 305 | 566 | 5 | 2023-07-03 | 736.15 | 18.40 | 2023-06-21 | 1 | 653.70 | 1 | 736.15 | 16 | SO50306 | 2023-06-28 | 58.89 | 653.70 | 736.15 | |||
SO61204_15 | E810-4164-82 | PO15312134209 | 19 | 291 | 231 | 299 | 6 | 2024-03-04 | 89.98 | 2.25 | 2024-02-21 | 3 | 38.49 | 1 | 89.98 | 15 | SO61204 | 2024-02-28 | 7.20 | 115.48 | 29.99 | |||
SO51826_3 | DBF7-4FCA-86 | PO6148188136 | 100 | 289 | 575 | 693 | 1 | 2023-10-03 | 2860.88 | 71.52 | 2023-09-21 | 2 | 1481.94 | 1 | 2860.88 | 3 | SO51826 | 2023-09-28 | 228.87 | 2963.88 | 1430.44 | |||
SO67273_30 | 9BAE-4E69-B9 | PO13688176638 | 100 | 282 | 217 | 475 | 4 | 2024-06-03 | 41.99 | 1.05 | 2024-05-22 | 2 | 13.09 | 1 | 41.99 | 30 | SO67273 | 2024-05-29 | 3.36 | 26.17 | 20.99 | |||
SO45298_3 | 7EEC-41A1-9E | PO13572147445 | 100 | 287 | 313 | 527 | 3 | 2022-04-05 | 2146.96 | 53.67 | 2022-03-24 | 1 | 2171.29 | 1 | 2146.96 | 3 | SO45298 | 2022-03-31 | 171.76 | 2171.29 | 2146.96 | |||
SO44496_7 | 6ADA-4A25-AA | PO18415194469 | 19 | 288 | 340 | 191 | 6 | 2022-01-03 | 419.46 | 10.49 | 2021-12-22 | 1 | 413.15 | 1 | 419.46 | 7 | SO44496 | 2021-12-29 | 33.56 | 413.15 | 419.46 | |||
SO51108_20 | 8650-4A20-B1 | PO12644151814 | 100 | 285 | 402 | 530 | 5 | 2023-09-02 | 288.65 | 7.22 | 2023-08-21 | 4 | 53.40 | 1 | 288.65 | 20 | SO51108 | 2023-08-28 | 23.09 | 213.60 | 72.16 | |||
SO46616_43 | 1264-43E6-B7 | PO14732122562 | 19 | 291 | 333 | 2 | 514 | 6 | 118.07 | 2022-09-02 | 5903.74 | 144.64 | 2022-08-21 | 13 | 486.71 | 1 | 5785.67 | 43 | SO46616 | 2022-08-28 | 462.85 | 6327.19 | 454.13 | 0.02 |
SO55254_25 | BFF6-440D-80 | PO12441172246 | 36 | 295 | 491 | 302 | 8 | 2023-12-03 | 323.94 | 8.10 | 2023-11-21 | 10 | 41.57 | 1 | 323.94 | 25 | SO55254 | 2023-11-28 | 25.92 | 415.72 | 32.39 | |||
SO58951_21 | 96F8-470F-9B | PO11397163065 | 36 | 295 | 490 | 176 | 8 | 2024-02-02 | 129.58 | 3.24 | 2024-01-21 | 4 | 41.57 | 1 | 129.58 | 21 | SO58951 | 2024-01-28 | 10.37 | 166.29 | 32.39 | |||
SO69522_1 | 28C3-4615-8B | PO4901187436 | 19 | 284 | 237 | 84 | 6 | 2024-07-03 | 119.98 | 3.00 | 2024-06-21 | 4 | 38.49 | 1 | 119.98 | 1 | SO69522 | 2024-06-28 | 9.60 | 153.97 | 29.99 | |||
SO69461_33 | F8C1-4A85-91 | PO1508119064 | 98 | 288 | 483 | 430 | 10 | 2024-07-03 | 648.00 | 16.20 | 2024-06-21 | 9 | 44.88 | 1 | 648.00 | 33 | SO69461 | 2024-06-28 | 51.84 | 403.92 | 72.00 | |||
SO67347_26 | 6E87-4127-80 | PO8787117055 | 100 | 282 | 237 | 523 | 3 | 2024-06-03 | 209.96 | 5.25 | 2024-05-22 | 7 | 38.49 | 1 | 209.96 | 26 | SO67347 | 2024-05-29 | 16.80 | 269.45 | 29.99 | |||
SO51828_15 | 3204-40B6-A5 | PO5771194719 | 100 | 282 | 386 | 79 | 3 | 2023-10-03 | 2016.88 | 50.42 | 2023-09-21 | 3 | 713.08 | 1 | 2016.88 | 15 | SO51828 | 2023-09-28 | 161.35 | 2139.24 | 672.29 | |||
SO63180_18 | B8CD-47BA-8C | PO2523117609 | 100 | 287 | 491 | 167 | 4 | 2024-04-04 | 161.97 | 4.05 | 2024-03-23 | 5 | 41.57 | 1 | 161.97 | 18 | SO63180 | 2024-03-30 | 12.96 | 207.86 | 32.39 | |||
SO50228_12 | D5B0-4F26-BC | PO11629145611 | 100 | 283 | 421 | 396 | 2 | 2023-07-03 | 1177.97 | 29.45 | 2023-06-21 | 6 | 145.28 | 1 | 1177.97 | 12 | SO50228 | 2023-06-28 | 94.24 | 871.70 | 196.33 | |||
SO53614_21 | A1C5-4C4D-9C | PO6757196330 | 100 | 281 | 598 | 21 | 4 | 2023-11-03 | 323.99 | 8.10 | 2023-10-22 | 1 | 294.58 | 1 | 323.99 | 21 | SO53614 | 2023-10-29 | 25.92 | 294.58 | 323.99 | |||
SO53613_2 | 4A10-4F98-84 | PO6815195063 | 100 | 293 | 222 | 109 | 1 | 2023-11-03 | 62.98 | 1.57 | 2023-10-22 | 3 | 13.09 | 1 | 62.98 | 2 | SO53613 | 2023-10-29 | 5.04 | 39.26 | 20.99 | |||
SO46970_14 | 01AF-420A-B9 | PO15196114472 | 100 | 282 | 343 | 258 | 4 | 2022-10-03 | 1409.38 | 35.23 | 2022-09-21 | 3 | 486.71 | 1 | 1409.38 | 14 | SO46970 | 2022-09-28 | 112.75 | 1460.12 | 469.79 | |||
SO50724_10 | E9DD-40CA-B2 | PO9686154363 | 100 | 282 | 420 | 457 | 4 | 2023-08-03 | 141.62 | 3.54 | 2023-07-22 | 1 | 104.80 | 1 | 141.62 | 10 | SO50724 | 2023-07-29 | 11.33 | 104.80 | 141.62 | |||
SO43898_11 | 420C-4ECE-85 | PO4901196283 | 19 | 284 | 215 | 84 | 6 | 2021-10-03 | 161.49 | 4.04 | 2021-09-21 | 8 | 12.03 | 1 | 161.49 | 11 | SO43898 | 2021-09-28 | 12.92 | 96.22 | 20.19 | |||
SO49839_2 | 3123-41F3-9B | PO10527179463 | 19 | 284 | 456 | 480 | 6 | 2023-06-03 | 44.99 | 1.12 | 2023-05-22 | 1 | 30.93 | 1 | 44.99 | 2 | SO49839 | 2023-05-29 | 3.60 | 30.93 | 44.99 | |||
SO57041_2 | 214B-45FE-BA | PO15283137428 | 100 | 281 | 566 | 363 | 3 | 2024-01-03 | 445.41 | 11.14 | 2023-12-22 | 1 | 461.44 | 1 | 445.41 | 2 | SO57041 | 2023-12-29 | 35.63 | 461.44 | 445.41 | |||
SO51771_8 | F78B-4D68-8E | PO1508157846 | 98 | 288 | 225 | 430 | 10 | 2023-10-03 | 43.15 | 1.08 | 2023-09-21 | 8 | 6.92 | 1 | 43.15 | 8 | SO51771 | 2023-09-28 | 3.45 | 55.38 | 5.39 | |||
SO49484_13 | B25F-4DF4-8E | PO18299142683 | 19 | 291 | 397 | 118 | 6 | 2023-05-03 | 72.88 | 1.82 | 2023-04-21 | 3 | 17.98 | 1 | 72.88 | 13 | SO49484 | 2023-04-28 | 5.83 | 53.93 | 24.29 | |||
SO63246_7 | 5008-4978-B3 | PO7598198768 | 100 | 285 | 606 | 45 | 5 | 2024-04-04 | 323.99 | 8.10 | 2024-03-23 | 1 | 343.65 | 1 | 323.99 | 7 | SO63246 | 2024-03-30 | 25.92 | 343.65 | 323.99 | |||
SO65226_15 | 55DE-4772-82 | PO15515186601 | 100 | 292 | 237 | 481 | 7 | 2024-05-03 | 149.97 | 3.75 | 2024-04-21 | 5 | 38.49 | 1 | 149.97 | 15 | SO65226 | 2024-04-28 | 12.00 | 192.46 | 29.99 | |||
SO44772_30 | F5E6-4B81-A3 | PO1624122637 | 100 | 283 | 313 | 579 | 3 | 2022-02-02 | 8587.85 | 214.70 | 2022-01-21 | 4 | 2171.29 | 1 | 8587.85 | 30 | SO44772 | 2022-01-28 | 687.03 | 8685.18 | 2146.96 | |||
SO51780_18 | 30C4-4B8F-AA | PO18560115626 | 100 | 285 | 471 | 531 | 5 | 2023-10-03 | 114.30 | 2.86 | 2023-09-21 | 3 | 23.75 | 1 | 114.30 | 18 | SO51780 | 2023-09-28 | 9.14 | 71.25 | 38.10 | |||
SO49877_18 | 493D-497C-AB | PO3828147687 | 100 | 283 | 358 | 414 | 2 | 2023-06-03 | 4917.84 | 122.95 | 2023-05-22 | 4 | 1105.81 | 1 | 4917.84 | 18 | SO49877 | 2023-05-29 | 393.43 | 4423.24 | 1229.46 | |||
SO47018_28 | E622-43B1-98 | PO2523197473 | 100 | 287 | 325 | 167 | 4 | 2022-10-03 | 1879.18 | 46.98 | 2022-09-21 | 4 | 486.71 | 1 | 1879.18 | 28 | SO47018 | 2022-09-28 | 150.33 | 1946.83 | 469.79 | |||
SO50289_4 | 0809-4DE4-93 | PO3480117331 | 100 | 281 | 459 | 436 | 4 | 2023-07-03 | 215.98 | 5.40 | 2023-06-21 | 4 | 37.12 | 1 | 215.98 | 4 | SO50289 | 2023-06-28 | 17.28 | 148.48 | 53.99 | |||
SO58906_10 | 6BB0-48C1-BE | PO19633186598 | 100 | 287 | 588 | 149 | 3 | 2024-02-02 | 923.39 | 23.08 | 2024-01-21 | 2 | 419.78 | 1 | 923.39 | 10 | SO58906 | 2024-01-28 | 73.87 | 839.56 | 461.69 | |||
SO43858_5 | 8FFA-4339-B7 | PO16791124272 | 100 | 281 | 285 | 36 | 2 | 2021-10-03 | 357.16 | 8.93 | 2021-09-21 | 2 | 176.20 | 1 | 357.16 | 5 | SO43858 | 2021-09-28 | 28.57 | 352.40 | 178.58 | |||
SO48771_9 | E98F-4302-92 | PO8410125811 | 98 | 288 | 233 | 538 | 10 | 2023-03-05 | 173.04 | 4.33 | 2023-02-21 | 6 | 29.08 | 1 | 173.04 | 9 | SO48771 | 2023-02-28 | 13.84 | 174.48 | 28.84 | |||
SO57038_1 | 1B47-4998-A2 | PO15254164728 | 100 | 283 | 583 | 377 | 3 | 2024-01-03 | 3061.78 | 76.54 | 2023-12-22 | 3 | 1082.51 | 1 | 3061.78 | 1 | SO57038 | 2023-12-29 | 244.94 | 3247.53 | 1020.59 | |||
SO46058_17 | FA37-4F46-97 | PO12557123934 | 100 | 282 | 340 | 240 | 4 | 2022-07-03 | 419.46 | 10.49 | 2022-06-21 | 1 | 413.15 | 1 | 419.46 | 17 | SO46058 | 2022-06-28 | 33.56 | 413.15 | 419.46 | |||
SO53474_25 | E5B6-4103-8D | PO15457187993 | 100 | 285 | 500 | 297 | 5 | 2023-11-03 | 602.35 | 15.06 | 2023-10-22 | 1 | 601.74 | 1 | 602.35 | 25 | SO53474 | 2023-10-29 | 48.19 | 601.74 | 602.35 | |||
SO71876_2 | ACFB-45B8-91 | PO12180111728 | 6 | 296 | 492 | 303 | 9 | 2024-08-03 | 602.35 | 15.06 | 2024-07-22 | 1 | 601.74 | 1 | 602.35 | 2 | SO71876 | 2024-07-29 | 48.19 | 601.74 | 602.35 | |||
SO50258_1 | 838F-4C0C-86 | PO3161121594 | 100 | 283 | 224 | 359 | 2 | 2023-07-03 | 10.37 | 0.26 | 2023-06-21 | 2 | 5.23 | 1 | 10.37 | 1 | SO50258 | 2023-06-28 | 0.83 | 10.46 | 5.19 | |||
SO47666_26 | 6551-4B29-BF | PO16588184420 | 100 | 289 | 236 | 146 | 1 | 2022-12-03 | 57.68 | 1.44 | 2022-11-21 | 2 | 29.08 | 1 | 57.68 | 26 | SO47666 | 2022-11-28 | 4.61 | 58.16 | 28.84 | |||
SO51131_41 | D489-4DF3-A2 | PO16298169856 | 100 | 287 | 465 | 599 | 4 | 2023-09-02 | 88.16 | 2.20 | 2023-08-21 | 6 | 9.16 | 1 | 88.16 | 41 | SO51131 | 2023-08-28 | 7.05 | 54.96 | 14.69 | |||
SO53601_4 | B41F-4FBB-87 | PO3770165104 | 100 | 282 | 526 | 151 | 4 | 2023-11-03 | 158.43 | 3.96 | 2023-10-22 | 1 | 144.59 | 1 | 158.43 | 4 | SO53601 | 2023-10-29 | 12.67 | 144.59 | 158.43 |
Generated 2024-09-20 18:39:43.206 UTC