[ROOT] dt FactResellerSale < WHERE DimSalesTerritoryId EQ ALL SKIP 0 SHUFFLE < SKIP 813 > < 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 |
---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
SO51089_10 | A635-4BAF-BC | PO16588151558 | 100 | 289 | 532 | 146 | 1 | 2023-08-30 | 599.50 | 14.99 | 2023-08-18 | 4 | 136.79 | 1 | 599.50 | 10 | SO51089 | 2023-08-25 | 47.96 | 547.14 | 149.87 | |||
SO46993_1 | F652-4085-A4 | PO11658111433 | 100 | 272 | 391 | 233 | 2 | 2022-09-30 | 177.86 | 4.45 | 2022-09-18 | 2 | 65.81 | 1 | 177.86 | 1 | SO46993 | 2022-09-25 | 14.23 | 131.62 | 88.93 | |||
SO51123_30 | E412-45DF-AE | PO899150137 | 100 | 289 | 436 | 290 | 1 | 2023-08-30 | 1784.49 | 44.61 | 2023-08-18 | 5 | 360.94 | 1 | 1784.49 | 30 | SO51123 | 2023-08-25 | 142.76 | 1804.71 | 356.90 | |||
SO50237_38 | 6856-44BE-87 | PO928122277 | 98 | 288 | 469 | 484 | 10 | 2023-06-30 | 205.15 | 5.13 | 2023-06-18 | 9 | 15.67 | 1 | 205.15 | 38 | SO50237 | 2023-06-25 | 16.41 | 141.04 | 22.79 | |||
SO49149_30 | D41E-4EFF-A5 | PO5858123072 | 100 | 285 | 459 | 566 | 5 | 2023-04-02 | 53.99 | 1.35 | 2023-03-21 | 1 | 37.12 | 1 | 53.99 | 30 | SO49149 | 2023-03-28 | 4.32 | 37.12 | 53.99 | |||
SO51131_47 | D489-4DF3-A2 | PO16298169856 | 100 | 287 | 562 | 14 | 599 | 4 | 762.90 | 2023-08-30 | 3814.51 | 76.29 | 2023-08-18 | 4 | 1481.94 | 1 | 3051.61 | 47 | SO51131 | 2023-08-25 | 244.13 | 5927.75 | 953.63 | 0.20 |
SO53510_18 | 8E8D-4B13-B1 | PO10962181057 | 19 | 284 | 591 | 685 | 6 | 2023-10-31 | 677.99 | 16.95 | 2023-10-19 | 2 | 308.22 | 1 | 677.99 | 18 | SO53510 | 2023-10-26 | 54.24 | 616.44 | 338.99 | |||
SO51131_53 | D489-4DF3-A2 | PO16298169856 | 100 | 287 | 560 | 599 | 4 | 2023-08-30 | 5102.37 | 127.56 | 2023-08-18 | 7 | 755.15 | 1 | 5102.37 | 53 | SO51131 | 2023-08-25 | 408.19 | 5286.06 | 728.91 | |||
SO45317_22 | 92DD-46A2-8D | PO2523164373 | 100 | 272 | 314 | 167 | 4 | 2022-04-02 | 10734.81 | 268.37 | 2022-03-21 | 5 | 2171.29 | 1 | 10734.81 | 22 | SO45317 | 2022-03-28 | 858.78 | 10856.47 | 2146.96 | |||
SO51081_40 | EDBF-4FE1-8F | PO522116846 | 100 | 285 | 474 | 4 | 676 | 5 | 87.49 | 2023-08-30 | 874.88 | 19.68 | 2023-08-18 | 25 | 26.18 | 1 | 787.39 | 40 | SO51081 | 2023-08-25 | 62.99 | 654.41 | 35.00 | 0.10 |
SO46968_2 | 280B-4350-80 | PO15254133264 | 100 | 281 | 458 | 377 | 3 | 2022-09-30 | 179.98 | 4.50 | 2022-09-18 | 4 | 30.93 | 1 | 179.98 | 2 | SO46968 | 2022-09-25 | 14.40 | 123.73 | 44.99 | |||
SO65172_9 | B28D-458D-90 | PO17371161505 | 6 | 296 | 477 | 688 | 9 | 2024-04-30 | 8.98 | 0.22 | 2024-04-18 | 3 | 1.87 | 1 | 8.98 | 9 | SO65172 | 2024-04-25 | 0.72 | 5.60 | 2.99 | |||
SO50293_15 | D649-4CE8-91 | PO3596144572 | 100 | 285 | 409 | 476 | 5 | 2023-06-30 | 418.51 | 10.46 | 2023-06-18 | 2 | 185.82 | 1 | 418.51 | 15 | SO50293 | 2023-06-25 | 33.48 | 371.64 | 209.26 | |||
SO48741_19 | 5AA4-4194-B9 | PO899196006 | 100 | 289 | 461 | 290 | 1 | 2023-03-02 | 269.97 | 6.75 | 2023-02-18 | 5 | 37.12 | 1 | 269.97 | 19 | SO48741 | 2023-02-25 | 21.60 | 185.60 | 53.99 | |||
SO44778_2 | 32B2-4FA6-81 | PO3190112662 | 100 | 281 | 338 | 575 | 2 | 2022-01-30 | 838.92 | 20.97 | 2022-01-18 | 2 | 413.15 | 1 | 838.92 | 2 | SO44778 | 2022-01-25 | 67.11 | 826.29 | 419.46 | |||
SO61239_23 | 6459-4F99-96 | PO3828136274 | 100 | 283 | 359 | 414 | 2 | 2024-03-01 | 1376.99 | 34.42 | 2024-02-18 | 1 | 1251.98 | 1 | 1376.99 | 23 | SO61239 | 2024-02-25 | 110.16 | 1251.98 | 1376.99 | |||
SO45306_6 | F836-4C32-8D | PO11020195551 | 19 | 284 | 315 | 336 | 6 | 2022-04-02 | 874.79 | 21.87 | 2022-03-21 | 1 | 884.71 | 1 | 874.79 | 6 | SO45306 | 2022-03-28 | 69.98 | 884.71 | 874.79 | |||
SO45295_1 | 113A-4330-B0 | PO14529163242 | 100 | 286 | 348 | 289 | 1 | 2022-04-02 | 2024.99 | 50.62 | 2022-03-21 | 1 | 1898.09 | 1 | 2024.99 | 1 | SO45295 | 2022-03-28 | 162.00 | 1898.09 | 2024.99 | |||
SO63200_41 | E73D-4A02-88 | PO11658161535 | 100 | 283 | 527 | 233 | 2 | 2024-04-01 | 158.43 | 3.96 | 2024-03-20 | 1 | 144.59 | 1 | 158.43 | 41 | SO63200 | 2024-03-27 | 12.67 | 144.59 | 158.43 | |||
SO44288_23 | 6F5C-4E3C-B5 | PO14732190246 | 19 | 288 | 253 | 514 | 6 | 2021-11-30 | 892.90 | 22.32 | 2021-11-18 | 5 | 176.20 | 1 | 892.90 | 23 | SO44288 | 2021-11-25 | 71.43 | 881.00 | 178.58 | |||
SO49166_1 | 142E-4351-A4 | PO8845115490 | 100 | 282 | 409 | 546 | 3 | 2023-04-02 | 627.77 | 15.69 | 2023-03-21 | 3 | 185.82 | 1 | 627.77 | 1 | SO49166 | 2023-03-28 | 50.22 | 557.46 | 209.26 | |||
SO69418_35 | D0CE-41AD-AA | PO15370180703 | 100 | 281 | 533 | 381 | 3 | 2024-06-30 | 149.87 | 3.75 | 2024-06-18 | 1 | 136.79 | 1 | 149.87 | 35 | SO69418 | 2024-06-25 | 11.99 | 136.79 | 149.87 | |||
SO58972_10 | 07C8-43BD-85 | PO1798131785 | 19 | 291 | 533 | 10 | 6 | 2024-01-30 | 449.62 | 11.24 | 2024-01-18 | 3 | 136.79 | 1 | 449.62 | 10 | SO58972 | 2024-01-25 | 35.97 | 410.36 | 149.87 | |||
SO63282_10 | F7EE-4F12-B1 | PO3567146912 | 100 | 292 | 506 | 193 | 7 | 2024-04-01 | 800.21 | 20.01 | 2024-03-20 | 4 | 199.85 | 1 | 800.21 | 10 | SO63282 | 2024-03-27 | 64.02 | 799.41 | 200.05 | |||
SO49481_32 | 474A-4DD1-9B | PO10701112208 | 100 | 282 | 469 | 133 | 4 | 2023-04-30 | 91.18 | 2.28 | 2023-04-18 | 4 | 15.67 | 1 | 91.18 | 32 | SO49481 | 2023-04-25 | 7.29 | 62.68 | 22.79 | |||
SO67277_12 | 9AB3-4F34-85 | PO12644174121 | 100 | 272 | 214 | 530 | 5 | 2024-05-31 | 41.99 | 1.05 | 2024-05-19 | 2 | 13.09 | 1 | 41.99 | 12 | SO67277 | 2024-05-26 | 3.36 | 26.17 | 20.99 | |||
SO46654_3 | 2FEC-47CC-84 | PO3741124832 | 100 | 285 | 414 | 404 | 5 | 2022-08-30 | 447.09 | 11.18 | 2022-08-18 | 3 | 110.28 | 1 | 447.09 | 3 | SO46654 | 2022-08-25 | 35.77 | 330.85 | 149.03 | |||
SO53518_45 | 5712-444B-BC | PO841197199 | 100 | 286 | 601 | 254 | 1 | 2023-10-31 | 161.97 | 4.05 | 2023-10-19 | 5 | 23.97 | 1 | 161.97 | 45 | SO53518 | 2023-10-26 | 12.96 | 119.86 | 32.39 | |||
SO55297_29 | 2455-4B60-A5 | PO4495126679 | 19 | 291 | 357 | 496 | 6 | 2023-11-30 | 8351.96 | 208.80 | 2023-11-18 | 6 | 1265.62 | 1 | 8351.96 | 29 | SO55297 | 2023-11-25 | 668.16 | 7593.72 | 1391.99 | |||
SO69406_38 | E101-486C-A5 | PO16675181672 | 100 | 293 | 492 | 361 | 1 | 2024-06-30 | 2409.38 | 60.23 | 2024-06-18 | 4 | 601.74 | 1 | 2409.38 | 38 | SO69406 | 2024-06-25 | 192.75 | 2406.97 | 602.35 | |||
SO46993_28 | F652-4085-A4 | PO11658111433 | 100 | 272 | 448 | 233 | 2 | 2022-09-30 | 95.95 | 2.40 | 2022-09-18 | 8 | 8.25 | 1 | 95.95 | 28 | SO46993 | 2022-09-25 | 7.68 | 65.97 | 11.99 | |||
SO49115_18 | 4A55-4351-88 | PO3625184218 | 100 | 283 | 254 | 666 | 2 | 2023-04-02 | 735.75 | 18.39 | 2023-03-21 | 4 | 170.14 | 1 | 735.75 | 18 | SO49115 | 2023-03-28 | 58.86 | 680.57 | 183.94 | |||
SO50703_18 | 4A3D-44CB-B3 | PO2813140706 | 100 | 283 | 224 | 90 | 5 | 2023-07-31 | 10.37 | 0.26 | 2023-07-19 | 2 | 5.23 | 1 | 10.37 | 18 | SO50703 | 2023-07-26 | 0.83 | 10.46 | 5.19 | |||
SO69422_18 | BF3A-4F54-82 | PO14500139823 | 100 | 282 | 476 | 650 | 1 | 2024-06-30 | 125.98 | 3.15 | 2024-06-18 | 3 | 26.18 | 1 | 125.98 | 18 | SO69422 | 2024-06-25 | 10.08 | 78.53 | 41.99 | |||
SO47681_16 | 0580-4A09-A8 | PO12644124767 | 100 | 285 | 352 | 530 | 5 | 2022-11-30 | 3728.56 | 93.21 | 2022-11-18 | 3 | 1117.86 | 1 | 3728.56 | 16 | SO47681 | 2022-11-25 | 298.28 | 3353.57 | 1242.85 | |||
SO44530_12 | 46CE-47C5-B3 | PO10440138648 | 100 | 283 | 229 | 623 | 3 | 2021-12-31 | 230.72 | 5.77 | 2021-12-19 | 8 | 31.72 | 1 | 230.72 | 12 | SO44530 | 2021-12-26 | 18.46 | 253.80 | 28.84 | |||
SO49853_4 | 2A55-4B4E-95 | PO3016193618 | 100 | 281 | 358 | 183 | 3 | 2023-05-31 | 3688.38 | 92.21 | 2023-05-19 | 3 | 1105.81 | 1 | 3688.38 | 4 | SO49853 | 2023-05-26 | 295.07 | 3317.43 | 1229.46 | |||
SO49843_2 | D3CA-4A51-B6 | PO11484175391 | 100 | 283 | 362 | 594 | 2 | 2023-05-31 | 11065.13 | 276.63 | 2023-05-19 | 9 | 1105.81 | 1 | 11065.13 | 2 | SO49843 | 2023-05-26 | 885.21 | 9952.29 | 1229.46 | |||
SO47658_24 | C574-484B-83 | PO551177057 | 100 | 283 | 370 | 4 | 4 | 2022-11-30 | 4398.03 | 109.95 | 2022-11-18 | 3 | 1518.79 | 1 | 4398.03 | 24 | SO47658 | 2022-11-25 | 351.84 | 4556.36 | 1466.01 | |||
SO46966_19 | 8FBD-4E87-82 | PO15631150454 | 100 | 282 | 469 | 2 | 43 | 1 | 4.85 | 2022-09-30 | 242.38 | 5.94 | 2022-09-18 | 11 | 15.67 | 1 | 237.53 | 19 | SO46966 | 2022-09-25 | 19.00 | 172.38 | 22.03 | 0.02 |
SO46654_4 | 2FEC-47CC-84 | PO3741124832 | 100 | 285 | 323 | 404 | 5 | 2022-08-30 | 939.59 | 23.49 | 2022-08-18 | 2 | 486.71 | 1 | 939.59 | 4 | SO46654 | 2022-08-25 | 75.17 | 973.41 | 469.79 | |||
SO49499_1 | E899-4E47-A2 | PO15341196181 | 100 | 281 | 224 | 327 | 3 | 2023-04-30 | 15.56 | 0.39 | 2023-04-18 | 3 | 5.23 | 1 | 15.56 | 1 | SO49499 | 2023-04-25 | 1.24 | 15.69 | 5.19 | |||
SO43895_13 | 5233-4CB8-BC | PO2900121738 | 100 | 286 | 349 | 469 | 1 | 2021-09-30 | 8099.98 | 202.50 | 2021-09-18 | 4 | 1898.09 | 1 | 8099.98 | 13 | SO43895 | 2021-09-25 | 648.00 | 7592.38 | 2024.99 | |||
SO47450_44 | 7E50-416D-A2 | PO9483124566 | 100 | 281 | 257 | 54 | 2 | 2022-10-31 | 551.81 | 13.80 | 2022-10-19 | 3 | 170.14 | 1 | 551.81 | 44 | SO47450 | 2022-10-26 | 44.15 | 510.43 | 183.94 | |||
SO48288_2 | C999-4370-BD | PO20010115081 | 100 | 281 | 412 | 288 | 3 | 2023-01-30 | 360.26 | 9.01 | 2023-01-18 | 2 | 133.30 | 1 | 360.26 | 2 | SO48288 | 2023-01-25 | 28.82 | 266.59 | 180.13 | |||
SO51757_5 | 5056-414C-86 | PO10498137557 | 19 | 291 | 542 | 316 | 6 | 2023-09-30 | 72.88 | 1.82 | 2023-09-18 | 3 | 17.98 | 1 | 72.88 | 5 | SO51757 | 2023-09-25 | 5.83 | 53.93 | 24.29 | |||
SO50237_7 | 6856-44BE-87 | PO928122277 | 98 | 288 | 233 | 484 | 10 | 2023-06-30 | 57.68 | 1.44 | 2023-06-18 | 2 | 29.08 | 1 | 57.68 | 7 | SO50237 | 2023-06-25 | 4.61 | 58.16 | 28.84 | |||
SO53480_6 | 36E1-4FCF-B4 | PO15341137525 | 100 | 281 | 511 | 327 | 3 | 2023-10-31 | 873.82 | 21.85 | 2023-10-19 | 4 | 199.38 | 1 | 873.82 | 6 | SO53480 | 2023-10-26 | 69.91 | 797.50 | 218.45 | |||
SO65263_22 | C0DD-4323-8C | PO7395113656 | 100 | 286 | 357 | 542 | 1 | 2024-04-30 | 11135.95 | 278.40 | 2024-04-18 | 8 | 1265.62 | 1 | 11135.95 | 22 | SO65263 | 2024-04-25 | 890.88 | 10124.96 | 1391.99 | |||
SO44100_1 | D5BC-4BB2-BF | PO13543119495 | 100 | 287 | 218 | 293 | 1 | 2021-10-31 | 34.20 | 0.86 | 2021-10-19 | 6 | 3.40 | 1 | 34.20 | 1 | SO44100 | 2021-10-26 | 2.74 | 20.38 | 5.70 | |||
SO65312_16 | 19D1-4059-B8 | PO6815121334 | 100 | 293 | 225 | 109 | 1 | 2024-04-30 | 21.58 | 0.54 | 2024-04-18 | 4 | 6.92 | 1 | 21.58 | 16 | SO65312 | 2024-04-25 | 1.73 | 27.69 | 5.39 | |||
SO51748_25 | 1D77-486A-86 | PO11658169327 | 100 | 283 | 516 | 233 | 2 | 2023-09-30 | 140.90 | 3.52 | 2023-09-18 | 6 | 17.38 | 1 | 140.90 | 25 | SO51748 | 2023-09-25 | 11.27 | 104.27 | 23.48 | |||
SO44314_10 | 6FDF-4206-A7 | PO5626111923 | 100 | 283 | 314 | 166 | 4 | 2021-11-30 | 10734.81 | 268.37 | 2021-11-18 | 5 | 2171.29 | 1 | 10734.81 | 10 | SO44314 | 2021-11-25 | 858.78 | 10856.47 | 2146.96 | |||
SO67347_24 | 6E87-4127-80 | PO8787117055 | 100 | 282 | 390 | 523 | 3 | 2024-05-31 | 2689.18 | 67.23 | 2024-05-19 | 4 | 713.08 | 1 | 2689.18 | 24 | SO67347 | 2024-05-26 | 215.13 | 2852.32 | 672.29 | |||
SO69456_27 | CCD9-4C53-AB | PO957172965 | 98 | 288 | 596 | 376 | 10 | 2024-06-30 | 647.99 | 16.20 | 2024-06-18 | 2 | 294.58 | 1 | 647.99 | 27 | SO69456 | 2024-06-25 | 51.84 | 589.16 | 323.99 | |||
SO63179_23 | F2C5-4376-B7 | PO2668147145 | 100 | 292 | 551 | 535 | 7 | 2024-04-01 | 158.43 | 3.96 | 2024-03-20 | 1 | 144.59 | 1 | 158.43 | 23 | SO63179 | 2024-03-27 | 12.67 | 144.59 | 158.43 | |||
SO57026_19 | CD5A-4300-81 | PO16675118038 | 100 | 293 | 567 | 361 | 1 | 2023-12-31 | 1781.64 | 44.54 | 2023-12-19 | 4 | 461.44 | 1 | 1781.64 | 19 | SO57026 | 2023-12-26 | 142.53 | 1845.78 | 445.41 | |||
SO47416_7 | 6B45-44AB-84 | PO2813155355 | 100 | 281 | 323 | 90 | 5 | 2022-10-31 | 4697.94 | 117.45 | 2022-10-19 | 10 | 486.71 | 1 | 4697.94 | 7 | SO47416 | 2022-10-26 | 375.84 | 4867.07 | 469.79 | |||
SO46625_44 | 361B-4CAF-A2 | PO13688113829 | 100 | 282 | 289 | 475 | 4 | 2022-08-30 | 744.27 | 18.61 | 2022-08-18 | 1 | 660.91 | 1 | 744.27 | 44 | SO46625 | 2022-08-25 | 59.54 | 660.91 | 744.27 | |||
SO57027_1 | 15A6-4057-85 | PO16965111189 | 100 | 285 | 605 | 441 | 5 | 2023-12-31 | 323.99 | 8.10 | 2023-12-19 | 1 | 343.65 | 1 | 323.99 | 1 | SO57027 | 2023-12-26 | 25.92 | 343.65 | 323.99 | |||
SO49876_31 | 9450-4B7F-96 | PO3509138751 | 36 | 292 | 422 | 139 | 7 | 2023-05-31 | 67.54 | 1.69 | 2023-05-19 | 1 | 49.98 | 1 | 67.54 | 31 | SO49876 | 2023-05-26 | 5.40 | 49.98 | 67.54 | |||
SO58907_18 | F365-4683-97 | PO19372175613 | 100 | 282 | 552 | 582 | 4 | 2024-01-30 | 109.79 | 2.74 | 2024-01-18 | 2 | 40.62 | 1 | 109.79 | 18 | SO58907 | 2024-01-25 | 8.78 | 81.24 | 54.89 |
Generated 2024-09-18 01:51:52.689 UTC