[ROOT] dt FactResellerSale WHERE DimSalesTerritoryId EQ '1' > SKIP 0 SHUFFLE < SKIP 626 > < 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 |
---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
SO59031_7 | 15F5-4B32-AC | PO5017142991 | 100 | 289 | 503 | 308 | 1 | 2024-02-01 | 400.10 | 10.00 | 2024-01-20 | 2 | 199.85 | 1 | 400.10 | 7 | SO59031 | 2024-01-27 | 32.01 | 399.70 | 200.05 | |||
SO65278_16 | 5822-4DF1-92 | PO5017152408 | 100 | 289 | 507 | 308 | 1 | 2024-05-02 | 800.21 | 20.01 | 2024-04-20 | 4 | 199.85 | 1 | 800.21 | 16 | SO65278 | 2024-04-27 | 64.02 | 799.41 | 200.05 | |||
SO45274_3 | D0B9-4CC5-B8 | PO18676111897 | 100 | 282 | 344 | 697 | 1 | 2022-04-04 | 4079.99 | 102.00 | 2022-03-23 | 2 | 1912.15 | 1 | 4079.99 | 3 | SO45274 | 2022-03-30 | 326.40 | 3824.31 | 2039.99 | |||
SO47403_7 | 60A2-4F08-8B | PO841143108 | 100 | 286 | 289 | 254 | 1 | 2022-11-02 | 1488.55 | 37.21 | 2022-10-21 | 2 | 660.91 | 1 | 1488.55 | 7 | SO47403 | 2022-10-28 | 119.08 | 1321.83 | 744.27 | |||
SO69413_1 | E8F8-4282-9E | PO15631191114 | 100 | 282 | 592 | 16 | 43 | 1 | 45.20 | 2024-07-02 | 113.00 | 1.70 | 2024-06-20 | 1 | 308.22 | 1 | 67.80 | 1 | SO69413 | 2024-06-27 | 5.42 | 308.22 | 113.00 | 0.40 |
SO53569_26 | 113E-43AD-94 | PO9309141312 | 100 | 293 | 567 | 13 | 55 | 1 | 100.22 | 2023-11-02 | 668.12 | 14.20 | 2023-10-21 | 2 | 461.44 | 1 | 567.90 | 26 | SO53569 | 2023-10-28 | 45.43 | 922.89 | 334.06 | 0.15 |
SO46348_16 | CF4C-437D-97 | PO13543132672 | 100 | 287 | 300 | 293 | 1 | 2022-08-02 | 1619.52 | 40.49 | 2022-07-21 | 2 | 699.09 | 1 | 1619.52 | 16 | SO46348 | 2022-07-28 | 129.56 | 1398.19 | 809.76 | |||
SO47066_39 | 5E42-48DE-80 | PO8816154123 | 100 | 289 | 273 | 218 | 1 | 2022-10-02 | 607.00 | 15.17 | 2022-09-20 | 3 | 187.16 | 1 | 607.00 | 39 | SO47066 | 2022-09-27 | 48.56 | 561.47 | 202.33 | |||
SO50669_3 | CEEB-4329-BA | PO17487120000 | 100 | 293 | 329 | 692 | 1 | 2023-08-02 | 469.79 | 11.74 | 2023-07-21 | 1 | 486.71 | 1 | 469.79 | 3 | SO50669 | 2023-07-28 | 37.58 | 486.71 | 469.79 | |||
SO46667_3 | D3CD-4A6E-94 | PO7105131549 | 100 | 286 | 263 | 668 | 1 | 2022-09-01 | 607.00 | 15.17 | 2022-08-20 | 3 | 187.16 | 1 | 607.00 | 3 | SO46667 | 2022-08-27 | 48.56 | 561.47 | 202.33 | |||
SO47694_1 | 8253-4E13-9D | PO899122764 | 100 | 289 | 333 | 2 | 290 | 1 | 108.99 | 2022-12-02 | 5449.61 | 133.52 | 2022-11-20 | 12 | 486.71 | 1 | 5340.62 | 1 | SO47694 | 2022-11-27 | 427.25 | 5840.48 | 454.13 | 0.02 |
SO47698_22 | 3841-4995-8C | PO2552129685 | 100 | 286 | 453 | 506 | 1 | 2022-12-02 | 71.99 | 1.80 | 2022-11-20 | 2 | 24.75 | 1 | 71.99 | 22 | SO47698 | 2022-11-27 | 5.76 | 49.49 | 35.99 | |||
SO47986_8 | 3373-4C22-A9 | PO16414116972 | 100 | 289 | 366 | 236 | 1 | 2023-01-02 | 3239.97 | 81.00 | 2022-12-21 | 5 | 598.44 | 1 | 3239.97 | 8 | SO47986 | 2022-12-28 | 259.20 | 2992.18 | 647.99 | |||
SO48001_1 | 02F1-4434-99 | PO14442151969 | 100 | 293 | 294 | 127 | 1 | 2023-01-02 | 744.27 | 18.61 | 2022-12-21 | 1 | 660.91 | 1 | 744.27 | 1 | SO48001 | 2022-12-28 | 59.54 | 660.91 | 744.27 | |||
SO51728_12 | 5481-42D0-8C | PO14558119777 | 100 | 289 | 214 | 2 | 1 | 2023-10-02 | 125.96 | 3.15 | 2023-09-20 | 6 | 13.09 | 1 | 125.96 | 12 | SO51728 | 2023-09-27 | 10.08 | 78.52 | 20.99 | |||
SO43917_11 | 9EDA-4CDB-A8 | PO8816199739 | 100 | 289 | 319 | 218 | 1 | 2021-10-02 | 6123.56 | 153.09 | 2021-09-20 | 7 | 884.71 | 1 | 6123.56 | 11 | SO43917 | 2021-09-27 | 489.88 | 6192.96 | 874.79 | |||
SO46972_28 | 1A21-419F-8D | PO14500164221 | 100 | 282 | 360 | 650 | 1 | 2022-10-02 | 4917.84 | 122.95 | 2022-09-20 | 4 | 1105.81 | 1 | 4917.84 | 28 | SO46972 | 2022-09-27 | 393.43 | 4423.24 | 1229.46 | |||
SO44121_8 | FE2E-4885-B3 | PO5220129819 | 100 | 282 | 296 | 169 | 1 | 2021-11-02 | 1429.41 | 35.74 | 2021-10-21 | 2 | 617.03 | 1 | 1429.41 | 8 | SO44121 | 2021-10-28 | 114.35 | 1234.06 | 714.70 | |||
SO46972_23 | 1A21-419F-8D | PO14500164221 | 100 | 282 | 365 | 650 | 1 | 2022-10-02 | 1943.98 | 48.60 | 2022-09-20 | 3 | 598.44 | 1 | 1943.98 | 23 | SO46972 | 2022-09-27 | 155.52 | 1795.31 | 647.99 | |||
SO59021_29 | A306-4E83-B7 | PO7395154426 | 100 | 286 | 599 | 542 | 1 | 2024-02-01 | 647.99 | 16.20 | 2024-01-20 | 2 | 294.58 | 1 | 647.99 | 29 | SO59021 | 2024-01-27 | 51.84 | 589.16 | 323.99 | |||
SO65234_11 | 3BB7-4A9F-AF | PO10411160249 | 100 | 289 | 225 | 182 | 1 | 2024-05-02 | 16.18 | 0.40 | 2024-04-20 | 3 | 6.92 | 1 | 16.18 | 11 | SO65234 | 2024-04-27 | 1.29 | 20.77 | 5.39 | |||
SO46105_18 | 2590-40A7-BB | PO8816169858 | 100 | 289 | 332 | 218 | 1 | 2022-07-02 | 419.46 | 10.49 | 2022-06-20 | 1 | 413.15 | 1 | 419.46 | 18 | SO46105 | 2022-06-27 | 33.56 | 413.15 | 419.46 | |||
SO57105_34 | 3AE1-4A72-91 | PO18676113963 | 100 | 282 | 594 | 697 | 1 | 2024-01-02 | 2372.96 | 59.32 | 2023-12-21 | 7 | 308.22 | 1 | 2372.96 | 34 | SO57105 | 2023-12-28 | 189.84 | 2157.53 | 338.99 | |||
SO45790_2 | 4BF3-4DED-94 | PO13978116594 | 100 | 289 | 272 | 200 | 1 | 2022-06-02 | 183.94 | 4.60 | 2022-05-21 | 1 | 181.49 | 1 | 183.94 | 2 | SO45790 | 2022-05-28 | 14.72 | 181.49 | 183.94 | |||
SO71941_12 | EF95-4DC0-B4 | PO8903143014 | 100 | 293 | 471 | 235 | 1 | 2024-08-02 | 190.50 | 4.76 | 2024-07-21 | 5 | 23.75 | 1 | 190.50 | 12 | SO71941 | 2024-07-28 | 15.24 | 118.75 | 38.10 | |||
SO67346_14 | 545C-4C6E-88 | PO9338145989 | 100 | 293 | 523 | 451 | 1 | 2024-06-02 | 63.17 | 1.58 | 2024-05-21 | 2 | 23.37 | 1 | 63.17 | 14 | SO67346 | 2024-05-28 | 5.05 | 46.74 | 31.58 | |||
SO48746_10 | 3C67-4620-90 | PO2552136060 | 100 | 286 | 399 | 506 | 1 | 2023-03-04 | 135.10 | 3.38 | 2023-02-20 | 4 | 24.99 | 1 | 135.10 | 10 | SO48746 | 2023-02-27 | 10.81 | 99.97 | 33.77 | |||
SO69408_42 | 8DF5-4377-9D | PO16414161428 | 100 | 289 | 516 | 236 | 1 | 2024-07-02 | 164.39 | 4.11 | 2024-06-20 | 7 | 17.38 | 1 | 164.39 | 42 | SO69408 | 2024-06-27 | 13.15 | 121.65 | 23.48 | |||
SO50693_43 | 0DA5-4EE4-93 | PO841149385 | 100 | 286 | 445 | 254 | 1 | 2023-08-02 | 35.99 | 0.90 | 2023-07-21 | 1 | 24.75 | 1 | 35.99 | 43 | SO50693 | 2023-07-28 | 2.88 | 24.75 | 35.99 | |||
SO44492_12 | 8AF8-4DDE-A8 | PO18676158978 | 100 | 282 | 351 | 697 | 1 | 2022-01-02 | 8099.98 | 202.50 | 2021-12-21 | 4 | 1898.09 | 1 | 8099.98 | 12 | SO44492 | 2021-12-28 | 648.00 | 7592.38 | 2024.99 | |||
SO53514_23 | 8580-40F8-81 | PO10411179199 | 100 | 289 | 465 | 182 | 1 | 2023-11-02 | 58.78 | 1.47 | 2023-10-21 | 4 | 9.16 | 1 | 58.78 | 23 | SO53514 | 2023-10-28 | 4.70 | 36.64 | 14.69 | |||
SO51789_29 | A5AF-4504-83 | PO18618169495 | 100 | 286 | 565 | 13 | 605 | 1 | 150.33 | 2023-10-02 | 1002.17 | 21.30 | 2023-09-20 | 3 | 461.44 | 1 | 851.85 | 29 | SO51789 | 2023-09-27 | 68.15 | 1384.33 | 334.06 | 0.15 |
SO44541_6 | 64BA-409F-A1 | PO2958192556 | 100 | 286 | 218 | 559 | 1 | 2022-01-02 | 17.10 | 0.43 | 2021-12-21 | 3 | 3.40 | 1 | 17.10 | 6 | SO44541 | 2021-12-28 | 1.37 | 10.19 | 5.70 | |||
SO67297_9 | 58AA-422C-BB | PO2552176926 | 100 | 286 | 587 | 506 | 1 | 2024-06-02 | 923.39 | 23.08 | 2024-05-21 | 2 | 419.78 | 1 | 923.39 | 9 | SO67297 | 2024-05-28 | 73.87 | 839.56 | 461.69 | |||
SO46972_32 | 1A21-419F-8D | PO14500164221 | 100 | 282 | 305 | 650 | 1 | 2022-10-02 | 736.15 | 18.40 | 2022-09-20 | 1 | 653.70 | 1 | 736.15 | 32 | SO46972 | 2022-09-27 | 58.89 | 653.70 | 736.15 | |||
SO71818_12 | 2FCA-4131-BD | PO12470139718 | 100 | 287 | 568 | 672 | 1 | 2024-08-02 | 890.82 | 22.27 | 2024-07-21 | 2 | 461.44 | 1 | 890.82 | 12 | SO71818 | 2024-07-28 | 71.27 | 922.89 | 445.41 | |||
SO58963_30 | 6ADC-4485-8C | PO841129336 | 100 | 286 | 592 | 254 | 1 | 2024-02-01 | 2033.96 | 50.85 | 2024-01-20 | 6 | 308.22 | 1 | 2033.96 | 30 | SO58963 | 2024-01-27 | 162.72 | 1849.31 | 338.99 | |||
SO50206_47 | 7656-4E84-B8 | PO16414158832 | 100 | 289 | 469 | 236 | 1 | 2023-07-02 | 227.94 | 5.70 | 2023-06-20 | 10 | 15.67 | 1 | 227.94 | 47 | SO50206 | 2023-06-27 | 18.24 | 156.71 | 22.79 | |||
SO51821_11 | 1CCD-45D4-80 | PO7917148134 | 100 | 287 | 474 | 401 | 1 | 2023-10-02 | 125.98 | 3.15 | 2023-09-20 | 3 | 26.18 | 1 | 125.98 | 11 | SO51821 | 2023-09-27 | 10.08 | 78.53 | 41.99 | |||
SO53518_43 | 5712-444B-BC | PO841197199 | 100 | 286 | 542 | 254 | 1 | 2023-11-02 | 24.29 | 0.61 | 2023-10-21 | 1 | 17.98 | 1 | 24.29 | 43 | SO53518 | 2023-10-28 | 1.94 | 17.98 | 24.29 | |||
SO71886_6 | AE34-4CC5-9B | PO6815136550 | 100 | 293 | 543 | 109 | 1 | 2024-08-02 | 74.51 | 1.86 | 2024-07-21 | 2 | 27.57 | 1 | 74.51 | 6 | SO71886 | 2024-07-28 | 5.96 | 55.14 | 37.25 | |||
SO50321_4 | 6B3D-47E0-99 | PO8816191637 | 100 | 289 | 343 | 218 | 1 | 2023-07-02 | 1409.38 | 35.23 | 2023-06-20 | 3 | 486.71 | 1 | 1409.38 | 4 | SO50321 | 2023-06-27 | 112.75 | 1460.12 | 469.79 | |||
SO51145_1 | BBD2-4A22-8C | PO7105118870 | 100 | 293 | 481 | 668 | 1 | 2023-09-01 | 43.15 | 1.08 | 2023-08-20 | 8 | 3.36 | 1 | 43.15 | 1 | SO51145 | 2023-08-27 | 3.45 | 26.90 | 5.39 | |||
SO67297_11 | 58AA-422C-BB | PO2552176926 | 100 | 286 | 515 | 506 | 1 | 2024-06-02 | 48.82 | 1.22 | 2024-05-21 | 3 | 12.04 | 1 | 48.82 | 11 | SO67297 | 2024-05-28 | 3.91 | 36.12 | 16.27 | |||
SO49101_23 | 0549-4175-A0 | PO15573181395 | 100 | 293 | 397 | 487 | 1 | 2023-04-04 | 97.18 | 2.43 | 2023-03-23 | 4 | 17.98 | 1 | 97.18 | 23 | SO49101 | 2023-03-30 | 7.77 | 71.91 | 24.29 | |||
SO71836_1 | E41E-40C1-84 | PO841118259 | 100 | 286 | 592 | 16 | 254 | 1 | 90.40 | 2024-08-02 | 226.00 | 3.39 | 2024-07-21 | 2 | 308.22 | 1 | 135.60 | 1 | SO71836 | 2024-07-28 | 10.85 | 616.44 | 113.00 | 0.40 |
SO53623_7 | 7BBF-43AA-B5 | PO8903169981 | 100 | 293 | 471 | 235 | 1 | 2023-11-02 | 152.40 | 3.81 | 2023-10-21 | 4 | 23.75 | 1 | 152.40 | 7 | SO53623 | 2023-10-28 | 12.19 | 95.00 | 38.10 | |||
SO69488_3 | 427A-4EFD-B8 | PO14558122038 | 100 | 289 | 483 | 2 | 1 | 2024-07-02 | 72.00 | 1.80 | 2024-06-20 | 1 | 44.88 | 1 | 72.00 | 3 | SO69488 | 2024-06-27 | 5.76 | 44.88 | 72.00 | |||
SO61244_24 | 22F5-4A88-BE | PO6612122199 | 100 | 286 | 484 | 110 | 1 | 2024-03-03 | 14.31 | 0.36 | 2024-02-20 | 3 | 2.97 | 1 | 14.31 | 24 | SO61244 | 2024-02-27 | 1.14 | 8.92 | 4.77 | |||
SO44523_7 | BE2B-4DB0-8E | PO11919191573 | 100 | 286 | 346 | 73 | 1 | 2022-01-02 | 8159.98 | 204.00 | 2021-12-21 | 4 | 1912.15 | 1 | 8159.98 | 7 | SO44523 | 2021-12-28 | 652.80 | 7648.62 | 2039.99 | |||
SO47999_14 | DF06-4F6A-9D | PO14500121568 | 100 | 282 | 358 | 650 | 1 | 2023-01-02 | 6147.29 | 153.68 | 2022-12-21 | 5 | 1105.81 | 1 | 6147.29 | 14 | SO47999 | 2022-12-28 | 491.78 | 5529.05 | 1229.46 | |||
SO44541_4 | 64BA-409F-A1 | PO2958192556 | 100 | 286 | 350 | 559 | 1 | 2022-01-02 | 8099.98 | 202.50 | 2021-12-21 | 4 | 1898.09 | 1 | 8099.98 | 4 | SO44541 | 2021-12-28 | 648.00 | 7592.38 | 2024.99 | |||
SO65234_5 | 3BB7-4A9F-AF | PO10411160249 | 100 | 289 | 570 | 182 | 1 | 2024-05-02 | 1781.64 | 44.54 | 2024-04-20 | 4 | 461.44 | 1 | 1781.64 | 5 | SO65234 | 2024-04-27 | 142.53 | 1845.78 | 445.41 | |||
SO50693_1 | 0DA5-4EE4-93 | PO841149385 | 100 | 286 | 391 | 254 | 1 | 2023-08-02 | 444.66 | 11.12 | 2023-07-21 | 5 | 65.81 | 1 | 444.66 | 1 | SO50693 | 2023-07-28 | 35.57 | 329.05 | 88.93 | |||
SO47443_8 | DDB8-4FAB-92 | PO7192110823 | 100 | 289 | 213 | 20 | 1 | 2022-11-02 | 20.19 | 0.50 | 2022-10-21 | 1 | 13.88 | 1 | 20.19 | 8 | SO47443 | 2022-10-28 | 1.61 | 13.88 | 20.19 | |||
SO48747_3 | EC0D-4B9B-B3 | PO2929132599 | 100 | 289 | 360 | 380 | 1 | 2023-03-04 | 3688.38 | 92.21 | 2023-02-20 | 3 | 1105.81 | 1 | 3688.38 | 3 | SO48747 | 2023-02-27 | 295.07 | 3317.43 | 1229.46 | |||
SO69475_36 | F74A-4967-BA | PO18618162557 | 100 | 286 | 222 | 605 | 1 | 2024-07-02 | 125.96 | 3.15 | 2024-06-20 | 6 | 13.09 | 1 | 125.96 | 36 | SO69475 | 2024-06-27 | 10.08 | 78.52 | 20.99 | |||
SO58910_20 | A209-4ADD-98 | PO19169152738 | 100 | 289 | 591 | 272 | 1 | 2024-02-01 | 1016.98 | 25.42 | 2024-01-20 | 3 | 308.22 | 1 | 1016.98 | 20 | SO58910 | 2024-01-27 | 81.36 | 924.65 | 338.99 | |||
SO69422_22 | BF3A-4F54-82 | PO14500139823 | 100 | 282 | 487 | 2 | 650 | 1 | 8.29 | 2024-07-02 | 414.62 | 10.16 | 2024-06-20 | 13 | 20.57 | 1 | 406.33 | 22 | SO69422 | 2024-06-27 | 32.51 | 267.36 | 31.89 | 0.02 |
SO47666_35 | 6551-4B29-BF | PO16588184420 | 100 | 289 | 421 | 146 | 1 | 2022-12-02 | 196.33 | 4.91 | 2022-11-20 | 1 | 145.28 | 1 | 196.33 | 35 | SO47666 | 2022-11-27 | 15.71 | 145.28 | 196.33 | |||
SO57099_20 | 410F-45E9-9C | PO18618199656 | 100 | 286 | 477 | 605 | 1 | 2024-01-02 | 14.97 | 0.37 | 2023-12-21 | 5 | 1.87 | 1 | 14.97 | 20 | SO57099 | 2023-12-28 | 1.20 | 9.33 | 2.99 | |||
SO53518_17 | 5712-444B-BC | PO841197199 | 100 | 286 | 552 | 254 | 1 | 2023-11-02 | 219.58 | 5.49 | 2023-10-21 | 4 | 40.62 | 1 | 219.58 | 17 | SO53518 | 2023-10-28 | 17.57 | 162.49 | 54.89 |
Generated 2024-09-20 01:40:26.791 UTC