[ROOT] dt FactResellerSale < WHERE DimSalesTerritoryId EQ '4' > SHUFFLE < SKIP 2283 > < 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 |
---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
SO50702_14 | 6D0A-413E-BE | PO2697119650 | 100 | 282 | 428 | 187 | 4 | 2023-08-03 | 627.77 | 15.69 | 2023-07-22 | 3 | 185.82 | 1 | 627.77 | 14 | SO50702 | 2023-07-29 | 50.22 | 557.46 | 209.26 | |||
SO61200_19 | 9B44-40EF-86 | PO2755113256 | 100 | 272 | 562 | 205 | 4 | 2024-03-04 | 2860.88 | 71.52 | 2024-02-21 | 2 | 1481.94 | 1 | 2860.88 | 19 | SO61200 | 2024-02-28 | 228.87 | 2963.88 | 1430.44 | |||
SO69527_9 | A6FE-49DA-BE | PO4843110434 | 100 | 287 | 255 | 257 | 4 | 2024-07-03 | 404.66 | 10.12 | 2024-06-21 | 2 | 204.63 | 1 | 404.66 | 9 | SO69527 | 2024-06-28 | 32.37 | 409.25 | 202.33 | |||
SO57128_9 | 52E0-4277-80 | PO6525176590 | 100 | 281 | 309 | 345 | 4 | 2024-01-03 | 3274.80 | 81.87 | 2023-12-22 | 4 | 747.20 | 1 | 3274.80 | 9 | SO57128 | 2023-12-29 | 261.98 | 2988.80 | 818.70 | |||
SO49099_27 | D567-4CCE-A4 | PO15689170019 | 100 | 281 | 373 | 328 | 4 | 2023-04-05 | 6544.69 | 163.62 | 2023-03-24 | 5 | 1320.68 | 1 | 6544.69 | 27 | SO49099 | 2023-03-31 | 523.58 | 6603.42 | 1308.94 | |||
SO58988_4 | 419B-4310-83 | PO16124114660 | 100 | 282 | 580 | 649 | 4 | 2024-02-02 | 1020.59 | 25.51 | 2024-01-21 | 1 | 1082.51 | 1 | 1020.59 | 4 | SO58988 | 2024-01-28 | 81.65 | 1082.51 | 1020.59 | |||
SO50289_10 | 0809-4DE4-93 | PO3480117331 | 100 | 281 | 415 | 436 | 4 | 2023-07-03 | 396.07 | 9.90 | 2023-06-21 | 2 | 146.55 | 1 | 396.07 | 10 | SO50289 | 2023-06-28 | 31.69 | 293.09 | 198.04 | |||
SO69539_6 | 9591-4159-98 | PO2320111510 | 100 | 282 | 376 | 529 | 4 | 2024-07-03 | 1466.01 | 36.65 | 2024-06-21 | 1 | 1554.95 | 1 | 1466.01 | 6 | SO69539 | 2024-06-28 | 117.28 | 1554.95 | 1466.01 | |||
SO48780_22 | F139-41F4-83 | PO5626121558 | 100 | 281 | 254 | 166 | 4 | 2023-03-05 | 551.81 | 13.80 | 2023-02-21 | 3 | 170.14 | 1 | 551.81 | 22 | SO48780 | 2023-02-28 | 44.15 | 510.43 | 183.94 | |||
SO47355_46 | 6B7D-4E47-B5 | PO19343125466 | 100 | 282 | 339 | 24 | 4 | 2022-11-03 | 469.79 | 11.74 | 2022-10-22 | 1 | 486.71 | 1 | 469.79 | 46 | SO47355 | 2022-10-29 | 37.58 | 486.71 | 469.79 | |||
SO51126_14 | 7A9E-43B4-B3 | PO2755153471 | 100 | 282 | 572 | 13 | 205 | 4 | 701.52 | 2023-09-02 | 4676.81 | 99.38 | 2023-08-21 | 14 | 461.44 | 1 | 3975.28 | 14 | SO51126 | 2023-08-28 | 318.02 | 6460.23 | 334.06 | 0.15 |
SO50748_10 | 5FBE-4B52-B2 | PO6786143310 | 100 | 281 | 329 | 3 | 4 | 2023-08-03 | 2818.76 | 70.47 | 2023-07-22 | 6 | 486.71 | 1 | 2818.76 | 10 | SO50748 | 2023-07-29 | 225.50 | 2920.24 | 469.79 | |||
SO46642_13 | 0A4E-465C-BB | PO551133122 | 100 | 283 | 381 | 4 | 4 | 2022-09-02 | 1800.79 | 45.02 | 2022-08-21 | 3 | 605.65 | 1 | 1800.79 | 13 | SO46642 | 2022-08-28 | 144.06 | 1816.95 | 600.26 | |||
SO46660_12 | CF24-45E2-9D | PO5626129733 | 100 | 283 | 329 | 166 | 4 | 2022-09-02 | 2818.76 | 70.47 | 2022-08-21 | 6 | 486.71 | 1 | 2818.76 | 12 | SO46660 | 2022-08-28 | 225.50 | 2920.24 | 469.79 | |||
SO44500_1 | E9A4-477A-83 | PO16762152605 | 100 | 282 | 328 | 259 | 4 | 2022-01-03 | 419.46 | 10.49 | 2021-12-22 | 1 | 413.15 | 1 | 419.46 | 1 | SO44500 | 2021-12-29 | 33.56 | 413.15 | 419.46 | |||
SO48313_9 | 5D5B-4BBC-AB | PO16182116781 | 100 | 287 | 458 | 23 | 4 | 2023-02-02 | 44.99 | 1.12 | 2023-01-21 | 1 | 30.93 | 1 | 44.99 | 9 | SO48313 | 2023-01-28 | 3.60 | 30.93 | 44.99 | |||
SO45571_14 | BAA6-412D-87 | PO7569141774 | 100 | 287 | 215 | 608 | 4 | 2022-05-03 | 60.56 | 1.51 | 2022-04-21 | 3 | 12.03 | 1 | 60.56 | 14 | SO45571 | 2022-04-28 | 4.84 | 36.08 | 20.19 | |||
SO44795_7 | 629B-45A2-8B | PO7569171528 | 100 | 287 | 345 | 608 | 4 | 2022-02-02 | 4079.99 | 102.00 | 2022-01-21 | 2 | 1912.15 | 1 | 4079.99 | 7 | SO44795 | 2022-01-28 | 326.40 | 3824.31 | 2039.99 | |||
SO49058_38 | BD1B-4C7F-A9 | PO12499147561 | 100 | 282 | 333 | 78 | 4 | 2023-04-05 | 1879.18 | 46.98 | 2023-03-24 | 4 | 486.71 | 1 | 1879.18 | 38 | SO49058 | 2023-03-31 | 150.33 | 1946.83 | 469.79 | |||
SO59011_26 | CAAD-4857-B7 | PO6786194654 | 100 | 281 | 480 | 3 | 4 | 2024-02-02 | 5.50 | 0.14 | 2024-01-21 | 4 | 0.86 | 1 | 5.50 | 26 | SO59011 | 2024-01-28 | 0.44 | 3.43 | 1.37 | |||
SO48295_29 | 12F9-466B-B0 | PO19343197973 | 100 | 282 | 456 | 3 | 24 | 4 | 33.00 | 2023-02-02 | 659.91 | 15.67 | 2023-01-21 | 16 | 30.93 | 1 | 626.92 | 29 | SO48295 | 2023-01-28 | 50.15 | 494.93 | 41.24 | 0.05 |
SO57042_8 | 52C4-4348-BC | PO15196150289 | 100 | 282 | 380 | 258 | 4 | 2024-01-03 | 2932.02 | 73.30 | 2023-12-22 | 2 | 1554.95 | 1 | 2932.02 | 8 | SO57042 | 2023-12-29 | 234.56 | 3109.90 | 1466.01 | |||
SO46057_18 | 6F2B-45A4-9C | PO12499164653 | 100 | 282 | 253 | 78 | 4 | 2022-07-03 | 357.16 | 8.93 | 2022-06-21 | 2 | 176.20 | 1 | 357.16 | 18 | SO46057 | 2022-06-28 | 28.57 | 352.40 | 178.58 | |||
SO53583_24 | 582E-4A53-9A | PO5597118655 | 100 | 281 | 477 | 75 | 4 | 2023-11-03 | 29.94 | 0.75 | 2023-10-22 | 10 | 1.87 | 1 | 29.94 | 24 | SO53583 | 2023-10-29 | 2.40 | 18.66 | 2.99 | |||
SO55264_23 | 80F3-4A7B-A2 | PO10730163005 | 100 | 287 | 481 | 491 | 4 | 2023-12-03 | 21.58 | 0.54 | 2023-11-21 | 4 | 3.36 | 1 | 21.58 | 23 | SO55264 | 2023-11-28 | 1.73 | 13.45 | 5.39 | |||
SO49884_7 | 822A-428D-94 | PO5626129805 | 100 | 281 | 271 | 166 | 4 | 2023-06-03 | 607.00 | 15.17 | 2023-05-22 | 3 | 187.16 | 1 | 607.00 | 7 | SO49884 | 2023-05-29 | 48.56 | 561.47 | 202.33 | |||
SO49498_24 | D9E7-4090-86 | PO16472151816 | 100 | 287 | 458 | 239 | 4 | 2023-05-03 | 44.99 | 1.12 | 2023-04-21 | 1 | 30.93 | 1 | 44.99 | 24 | SO49498 | 2023-04-28 | 3.60 | 30.93 | 44.99 | |||
SO50310_20 | FCBD-48EE-A9 | PO6438126969 | 100 | 281 | 365 | 309 | 4 | 2023-07-03 | 1295.99 | 32.40 | 2023-06-21 | 2 | 598.44 | 1 | 1295.99 | 20 | SO50310 | 2023-06-28 | 103.68 | 1196.87 | 647.99 | |||
SO48740_20 | 158B-4BBF-9F | PO551143768 | 100 | 281 | 379 | 4 | 4 | 2023-03-05 | 6544.69 | 163.62 | 2023-02-21 | 5 | 1320.68 | 1 | 6544.69 | 20 | SO48740 | 2023-02-28 | 523.58 | 6603.42 | 1308.94 | |||
SO59027_5 | C142-4AAA-AB | PO6757122081 | 100 | 281 | 357 | 21 | 4 | 2024-02-02 | 2783.99 | 69.60 | 2024-01-21 | 2 | 1265.62 | 1 | 2783.99 | 5 | SO59027 | 2024-01-28 | 222.72 | 2531.24 | 1391.99 | |||
SO50292_17 | E329-4164-85 | PO3654177485 | 100 | 281 | 428 | 435 | 4 | 2023-07-03 | 418.51 | 10.46 | 2023-06-21 | 2 | 185.82 | 1 | 418.51 | 17 | SO50292 | 2023-06-28 | 33.48 | 371.64 | 209.26 | |||
SO45560_7 | B195-4977-8E | PO4640111403 | 100 | 287 | 346 | 648 | 4 | 2022-05-03 | 4079.99 | 102.00 | 2022-04-21 | 2 | 1912.15 | 1 | 4079.99 | 7 | SO45560 | 2022-04-28 | 326.40 | 3824.31 | 2039.99 | |||
SO61200_2 | 9B44-40EF-86 | PO2755113256 | 100 | 272 | 472 | 205 | 4 | 2024-03-04 | 38.10 | 0.95 | 2024-02-21 | 1 | 23.75 | 1 | 38.10 | 2 | SO61200 | 2024-02-28 | 3.05 | 23.75 | 38.10 | |||
SO63240_20 | AC0A-4F08-91 | PO4611157476 | 100 | 287 | 572 | 131 | 4 | 2024-04-04 | 445.41 | 11.14 | 2024-03-23 | 1 | 461.44 | 1 | 445.41 | 20 | SO63240 | 2024-03-30 | 35.63 | 461.44 | 445.41 | |||
SO47990_30 | 7D80-4D9E-9A | PO15689162700 | 100 | 283 | 417 | 328 | 4 | 2023-01-03 | 648.91 | 16.22 | 2022-12-22 | 2 | 300.12 | 1 | 648.91 | 30 | SO47990 | 2022-12-29 | 51.91 | 600.24 | 324.45 | |||
SO59049_1 | 7571-4CB5-B6 | PO174156394 | 100 | 282 | 481 | 277 | 4 | 2024-02-02 | 26.97 | 0.67 | 2024-01-21 | 5 | 3.36 | 1 | 26.97 | 1 | SO59049 | 2024-01-28 | 2.16 | 16.81 | 5.39 | |||
SO47435_46 | B7A7-4F07-94 | PO5597154214 | 100 | 283 | 352 | 75 | 4 | 2022-11-03 | 2485.70 | 62.14 | 2022-10-22 | 2 | 1117.86 | 1 | 2485.70 | 46 | SO47435 | 2022-10-29 | 198.86 | 2235.71 | 1242.85 | |||
SO44755_14 | 3B0A-428C-99 | PO15167120207 | 100 | 283 | 220 | 273 | 4 | 2022-02-02 | 40.37 | 1.01 | 2022-01-21 | 2 | 12.03 | 1 | 40.37 | 14 | SO44755 | 2022-01-28 | 3.23 | 24.06 | 20.19 | |||
SO47355_26 | 6B7D-4E47-B5 | PO19343125466 | 100 | 282 | 267 | 24 | 4 | 2022-11-03 | 202.33 | 5.06 | 2022-10-22 | 1 | 187.16 | 1 | 202.33 | 26 | SO47355 | 2022-10-29 | 16.19 | 187.16 | 202.33 | |||
SO45799_17 | 4DE8-4B9B-A1 | PO10730195041 | 100 | 287 | 215 | 491 | 4 | 2022-06-03 | 80.75 | 2.02 | 2022-05-22 | 4 | 12.03 | 1 | 80.75 | 17 | SO45799 | 2022-05-29 | 6.46 | 48.11 | 20.19 | |||
SO46380_19 | C4E3-4894-81 | PO7569183330 | 100 | 287 | 351 | 7 | 608 | 4 | 1476.56 | 2022-08-03 | 4218.74 | 68.55 | 2022-07-22 | 5 | 1898.09 | 1 | 2742.18 | 19 | SO46380 | 2022-07-29 | 219.37 | 9490.47 | 843.75 | 0.35 |
SO65306_22 | 6B9B-439C-94 | PO5597142402 | 100 | 281 | 359 | 75 | 4 | 2024-05-03 | 2753.99 | 68.85 | 2024-04-21 | 2 | 1251.98 | 1 | 2753.99 | 22 | SO65306 | 2024-04-28 | 220.32 | 2503.96 | 1376.99 | |||
SO58937_4 | 858A-41E6-B7 | PO12992156722 | 100 | 282 | 586 | 295 | 4 | 2024-02-02 | 445.41 | 11.14 | 2024-01-21 | 1 | 461.44 | 1 | 445.41 | 4 | SO58937 | 2024-01-28 | 35.63 | 461.44 | 445.41 | |||
SO48363_36 | A9C9-4B7B-9B | PO3915186343 | 100 | 283 | 377 | 130 | 4 | 2023-02-02 | 3926.81 | 98.17 | 2023-01-21 | 3 | 1320.68 | 1 | 3926.81 | 36 | SO48363 | 2023-01-28 | 314.15 | 3962.05 | 1308.94 | |||
SO47990_42 | 7D80-4D9E-9A | PO15689162700 | 100 | 283 | 213 | 328 | 4 | 2023-01-03 | 121.12 | 3.03 | 2022-12-22 | 6 | 13.88 | 1 | 121.12 | 42 | SO47990 | 2022-12-29 | 9.69 | 83.27 | 20.19 | |||
SO67273_38 | 9BAE-4E69-B9 | PO13688176638 | 100 | 282 | 306 | 475 | 4 | 2024-06-03 | 3239.04 | 80.98 | 2024-05-22 | 4 | 739.04 | 1 | 3239.04 | 38 | SO67273 | 2024-05-29 | 259.12 | 2956.16 | 809.76 | |||
SO47990_17 | 7D80-4D9E-9A | PO15689162700 | 100 | 283 | 385 | 328 | 4 | 2023-01-03 | 1200.53 | 30.01 | 2022-12-22 | 2 | 605.65 | 1 | 1200.53 | 17 | SO47990 | 2022-12-29 | 96.04 | 1211.30 | 600.26 | |||
SO51090_59 | EBDE-4A71-8E | PO13688110947 | 100 | 282 | 533 | 475 | 4 | 2023-09-02 | 449.62 | 11.24 | 2023-08-21 | 3 | 136.79 | 1 | 449.62 | 59 | SO51090 | 2023-08-28 | 35.97 | 410.36 | 149.87 | |||
SO61218_44 | 8441-4C6F-89 | PO13688193778 | 100 | 282 | 531 | 475 | 4 | 2024-03-04 | 599.50 | 14.99 | 2024-02-21 | 4 | 136.79 | 1 | 599.50 | 44 | SO61218 | 2024-02-28 | 47.96 | 547.14 | 149.87 | |||
SO50713_1 | 7FC4-488D-A0 | PO16269188475 | 100 | 287 | 407 | 624 | 4 | 2023-08-03 | 65.60 | 1.64 | 2023-07-22 | 1 | 48.55 | 1 | 65.60 | 1 | SO50713 | 2023-07-29 | 5.25 | 48.55 | 65.60 | |||
SO53460_2 | 3BD9-47C3-94 | PO19343112747 | 100 | 282 | 436 | 24 | 4 | 2023-11-03 | 1070.69 | 26.77 | 2023-10-22 | 3 | 360.94 | 1 | 1070.69 | 2 | SO53460 | 2023-10-29 | 85.66 | 1082.83 | 356.90 | |||
SO69527_16 | A6FE-49DA-BE | PO4843110434 | 100 | 287 | 547 | 257 | 4 | 2024-07-03 | 48.59 | 1.21 | 2024-06-21 | 1 | 35.96 | 1 | 48.59 | 16 | SO69527 | 2024-06-28 | 3.89 | 35.96 | 48.59 | |||
SO47417_24 | 1CE8-4651-A9 | PO2697165938 | 100 | 282 | 305 | 187 | 4 | 2022-11-03 | 1472.29 | 36.81 | 2022-10-22 | 2 | 653.70 | 1 | 1472.29 | 24 | SO47417 | 2022-10-29 | 117.78 | 1307.39 | 736.15 | |||
SO48048_40 | B414-46CB-BA | PO3480117933 | 100 | 283 | 337 | 436 | 4 | 2023-01-03 | 939.59 | 23.49 | 2022-12-22 | 2 | 486.71 | 1 | 939.59 | 40 | SO48048 | 2022-12-29 | 75.17 | 973.41 | 469.79 | |||
SO49127_31 | 01A1-43AB-A2 | PO3480145572 | 100 | 272 | 339 | 436 | 4 | 2023-04-05 | 2348.97 | 58.72 | 2023-03-24 | 5 | 486.71 | 1 | 2348.97 | 31 | SO49127 | 2023-03-31 | 187.92 | 2433.53 | 469.79 | |||
SO51809_48 | F690-4F1D-B1 | PO6438145374 | 100 | 281 | 355 | 309 | 4 | 2023-10-03 | 2783.99 | 69.60 | 2023-09-21 | 2 | 1265.62 | 1 | 2783.99 | 48 | SO51809 | 2023-09-28 | 222.72 | 2531.24 | 1391.99 | |||
SO53586_14 | 37CB-4A82-96 | PO4002170204 | 100 | 282 | 483 | 674 | 4 | 2023-11-03 | 504.00 | 12.60 | 2023-10-22 | 7 | 44.88 | 1 | 504.00 | 14 | SO53586 | 2023-10-29 | 40.32 | 314.16 | 72.00 | |||
SO48373_6 | 4C9A-49DD-BA | PO5539129597 | 100 | 282 | 358 | 61 | 4 | 2023-02-02 | 7376.75 | 184.42 | 2023-01-21 | 6 | 1105.81 | 1 | 7376.75 | 6 | SO48373 | 2023-01-28 | 590.14 | 6634.86 | 1229.46 | |||
SO44107_8 | 99CE-4ADA-B1 | PO261177749 | 100 | 283 | 319 | 647 | 4 | 2021-11-03 | 1749.59 | 43.74 | 2021-10-22 | 2 | 884.71 | 1 | 1749.59 | 8 | SO44107 | 2021-10-29 | 139.97 | 1769.42 | 874.79 | |||
SO57139_6 | A281-4DDD-BC | PO2320173115 | 100 | 282 | 408 | 529 | 4 | 2024-01-03 | 144.32 | 3.61 | 2023-12-22 | 2 | 53.40 | 1 | 144.32 | 6 | SO57139 | 2023-12-29 | 11.55 | 106.80 | 72.16 | |||
SO48048_22 | B414-46CB-BA | PO3480117933 | 100 | 283 | 369 | 436 | 4 | 2023-01-03 | 11728.08 | 293.20 | 2022-12-22 | 8 | 1518.79 | 1 | 11728.08 | 22 | SO48048 | 2022-12-29 | 938.25 | 12150.29 | 1466.01 | |||
SO61227_11 | 9006-4208-8F | PO10730172247 | 100 | 287 | 604 | 491 | 4 | 2024-03-04 | 971.98 | 24.30 | 2024-02-21 | 3 | 343.65 | 1 | 971.98 | 11 | SO61227 | 2024-02-28 | 77.76 | 1030.95 | 323.99 |
Generated 2024-09-20 14:31:20.854 UTC