[ROOT] dt FactResellerSale < WHERE DimSalesTerritoryId EQ ALL SKIP 4000 SHUFFLE < SKIP 2125 > < 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 |
---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
SO49078_15 | 827E-4512-AD | PO2668184206 | 100 | 290 | 354 | 535 | 7 | 2023-04-04 | 2485.70 | 62.14 | 2023-03-23 | 2 | 1117.86 | 1 | 2485.70 | 15 | SO49078 | 2023-03-30 | 198.86 | 2235.71 | 1242.85 | |||
SO58908_29 | A429-40BA-96 | PO19285116289 | 98 | 290 | 491 | 2 | 448 | 10 | 6.89 | 2024-02-01 | 344.46 | 8.44 | 2024-01-20 | 11 | 41.57 | 1 | 337.57 | 29 | SO58908 | 2024-01-27 | 27.01 | 457.30 | 31.31 | 0.02 |
SO61266_4 | CE88-43C2-A3 | PO7105127855 | 100 | 293 | 606 | 668 | 1 | 2024-03-03 | 1295.98 | 32.40 | 2024-02-20 | 4 | 343.65 | 1 | 1295.98 | 4 | SO61266 | 2024-02-27 | 103.68 | 1374.60 | 323.99 | |||
SO51153_3 | AC8D-4688-81 | PO5626119823 | 100 | 281 | 430 | 166 | 4 | 2023-09-01 | 1427.59 | 35.69 | 2023-08-20 | 4 | 360.94 | 1 | 1427.59 | 3 | SO51153 | 2023-08-27 | 114.21 | 1443.77 | 356.90 | |||
SO71854_31 | AF3C-4FDF-A6 | PO16385143469 | 6 | 296 | 225 | 249 | 9 | 2024-08-02 | 16.18 | 0.40 | 2024-07-21 | 3 | 6.92 | 1 | 16.18 | 31 | SO71854 | 2024-07-28 | 1.29 | 20.77 | 5.39 | |||
SO55297_3 | 2455-4B60-A5 | PO4495126679 | 19 | 291 | 467 | 496 | 6 | 2023-12-02 | 73.47 | 1.84 | 2023-11-20 | 5 | 9.16 | 1 | 73.47 | 3 | SO55297 | 2023-11-27 | 5.88 | 45.80 | 14.69 | |||
SO51715_1 | 2360-48BD-86 | PO15631184297 | 100 | 282 | 475 | 43 | 1 | 2023-10-02 | 83.99 | 2.10 | 2023-09-20 | 2 | 26.18 | 1 | 83.99 | 1 | SO51715 | 2023-09-27 | 6.72 | 52.35 | 41.99 | |||
SO44788_5 | 4CD8-41D6-AE | PO5220181334 | 100 | 282 | 348 | 169 | 1 | 2022-02-01 | 18224.95 | 455.62 | 2022-01-20 | 9 | 1898.09 | 1 | 18224.95 | 5 | SO44788 | 2022-01-27 | 1458.00 | 17082.85 | 2024.99 | |||
SO67262_4 | 5BD7-455E-9A | PO19314114641 | 100 | 281 | 225 | 622 | 3 | 2024-06-02 | 5.39 | 0.13 | 2024-05-21 | 1 | 6.92 | 1 | 5.39 | 4 | SO67262 | 2024-05-28 | 0.43 | 6.92 | 5.39 | |||
SO49894_13 | C75C-4AA6-B6 | PO10092140429 | 100 | 283 | 428 | 252 | 2 | 2023-06-02 | 209.26 | 5.23 | 2023-05-21 | 1 | 185.82 | 1 | 209.26 | 13 | SO49894 | 2023-05-28 | 16.74 | 185.82 | 209.26 | |||
SO61181_18 | EF82-40B7-8E | PO17197117656 | 100 | 283 | 357 | 125 | 2 | 2024-03-03 | 5567.98 | 139.20 | 2024-02-20 | 4 | 1265.62 | 1 | 5567.98 | 18 | SO61181 | 2024-02-27 | 445.44 | 5062.48 | 1391.99 | |||
SO48017_22 | 40DA-4972-BB | PO11658177389 | 100 | 281 | 394 | 233 | 2 | 2023-01-02 | 20.52 | 0.51 | 2022-12-21 | 1 | 15.18 | 1 | 20.52 | 22 | SO48017 | 2022-12-28 | 1.64 | 15.18 | 20.52 | |||
SO51696_3 | 761E-41C4-85 | PO18821111879 | 36 | 292 | 542 | 686 | 7 | 2023-10-02 | 24.29 | 0.61 | 2023-09-20 | 1 | 17.98 | 1 | 24.29 | 3 | SO51696 | 2023-09-27 | 1.94 | 17.98 | 24.29 | |||
SO51770_9 | 9F77-4259-BE | PO1769187686 | 100 | 283 | 287 | 540 | 2 | 2023-10-02 | 809.33 | 20.23 | 2023-09-20 | 4 | 204.63 | 1 | 809.33 | 9 | SO51770 | 2023-09-27 | 64.75 | 818.50 | 202.33 | |||
SO67349_13 | 7BC2-4E87-BA | PO9831186318 | 100 | 285 | 471 | 3 | 81 | 5 | 34.93 | 2024-06-02 | 698.50 | 16.59 | 2024-05-21 | 20 | 23.75 | 1 | 663.58 | 13 | SO67349 | 2024-05-28 | 53.09 | 474.98 | 34.93 | 0.05 |
SO50292_2 | E329-4164-85 | PO3654177485 | 100 | 281 | 365 | 435 | 4 | 2023-07-02 | 647.99 | 16.20 | 2023-06-20 | 1 | 598.44 | 1 | 647.99 | 2 | SO50292 | 2023-06-27 | 51.84 | 598.44 | 647.99 | |||
SO47708_37 | 86B1-46A5-95 | PO4495147689 | 19 | 291 | 294 | 496 | 6 | 2022-12-02 | 1488.55 | 37.21 | 2022-11-20 | 2 | 660.91 | 1 | 1488.55 | 37 | SO47708 | 2022-11-27 | 119.08 | 1321.83 | 744.27 | |||
SO51693_13 | 6FEB-4D5B-92 | PO19546179477 | 100 | 285 | 380 | 206 | 5 | 2023-10-02 | 1466.01 | 36.65 | 2023-09-20 | 1 | 1554.95 | 1 | 1466.01 | 13 | SO51693 | 2023-09-27 | 117.28 | 1554.95 | 1466.01 | |||
SO50297_15 | 5199-40AD-90 | PO4727113542 | 100 | 293 | 224 | 343 | 1 | 2023-07-02 | 36.31 | 0.91 | 2023-06-20 | 7 | 5.23 | 1 | 36.31 | 15 | SO50297 | 2023-06-27 | 2.90 | 36.61 | 5.19 | |||
SO63247_3 | 1EB8-4AE3-AC | PO6148143330 | 100 | 289 | 493 | 693 | 1 | 2024-04-03 | 200.05 | 5.00 | 2024-03-22 | 1 | 199.85 | 1 | 200.05 | 3 | SO63247 | 2024-03-29 | 16.00 | 199.85 | 200.05 | |||
SO53457_2 | B3F3-4A07-9B | PO19169151555 | 100 | 289 | 475 | 272 | 1 | 2023-11-02 | 83.99 | 2.10 | 2023-10-21 | 2 | 26.18 | 1 | 83.99 | 2 | SO53457 | 2023-10-28 | 6.72 | 52.35 | 41.99 | |||
SO58948_35 | 1534-4AB5-81 | PO11774195497 | 6 | 296 | 603 | 682 | 9 | 2024-02-01 | 72.89 | 1.82 | 2024-01-20 | 1 | 53.94 | 1 | 72.89 | 35 | SO58948 | 2024-01-27 | 5.83 | 53.94 | 72.89 | |||
SO45529_6 | 86CC-47BA-B3 | PO17574182721 | 19 | 288 | 346 | 678 | 6 | 2022-05-02 | 12239.96 | 306.00 | 2022-04-20 | 6 | 1912.15 | 1 | 12239.96 | 6 | SO45529 | 2022-04-27 | 979.20 | 11472.93 | 2039.99 | |||
SO65155_18 | 154D-4EBA-85 | PO19633122185 | 100 | 287 | 491 | 149 | 3 | 2024-05-02 | 194.36 | 4.86 | 2024-04-20 | 6 | 41.57 | 1 | 194.36 | 18 | SO65155 | 2024-04-27 | 15.55 | 249.43 | 32.39 | |||
SO44511_2 | 4BD6-4CFA-B8 | PO14529113218 | 100 | 286 | 347 | 289 | 1 | 2022-01-02 | 2039.99 | 51.00 | 2021-12-21 | 1 | 1912.15 | 1 | 2039.99 | 2 | SO44511 | 2021-12-28 | 163.20 | 1912.15 | 2039.99 | |||
SO49446_1 | 1C19-4187-94 | PO20213185083 | 100 | 283 | 325 | 216 | 2 | 2023-05-02 | 3288.56 | 82.21 | 2023-04-20 | 7 | 486.71 | 1 | 3288.56 | 1 | SO49446 | 2023-04-27 | 263.08 | 3406.95 | 469.79 | |||
SO48395_8 | 46D3-4C51-AD | PO9570174316 | 100 | 285 | 458 | 585 | 5 | 2023-02-01 | 134.98 | 3.37 | 2023-01-20 | 3 | 30.93 | 1 | 134.98 | 8 | SO48395 | 2023-01-27 | 10.80 | 92.80 | 44.99 | |||
SO46101_11 | FAFC-4F06-B2 | PO7656119075 | 100 | 282 | 326 | 403 | 4 | 2022-07-02 | 1258.38 | 31.46 | 2022-06-20 | 3 | 413.15 | 1 | 1258.38 | 11 | SO46101 | 2022-06-27 | 100.67 | 1239.44 | 419.46 | |||
SO46326_24 | EDD8-4703-B2 | PO19401160698 | 19 | 288 | 212 | 173 | 6 | 2022-08-02 | 60.56 | 1.51 | 2022-07-21 | 3 | 12.03 | 1 | 60.56 | 24 | SO46326 | 2022-07-28 | 4.84 | 36.08 | 20.19 | |||
SO65195_23 | 11FD-44C6-95 | PO12354156814 | 100 | 283 | 476 | 2 | 197 | 3 | 10.55 | 2024-05-02 | 527.72 | 12.93 | 2024-04-20 | 13 | 26.18 | 1 | 517.17 | 23 | SO65195 | 2024-04-27 | 41.37 | 340.29 | 40.59 | 0.02 |
SO57132_33 | C079-4BDD-A1 | PO5829189627 | 36 | 295 | 237 | 266 | 8 | 2024-01-02 | 239.95 | 6.00 | 2023-12-21 | 8 | 38.49 | 1 | 239.95 | 33 | SO57132 | 2023-12-28 | 19.20 | 307.94 | 29.99 | |||
SO63131_19 | E035-4732-84 | PO18676136384 | 100 | 282 | 599 | 697 | 1 | 2024-04-03 | 971.98 | 24.30 | 2024-03-22 | 3 | 294.58 | 1 | 971.98 | 19 | SO63131 | 2024-03-29 | 77.76 | 883.74 | 323.99 | |||
SO46035_5 | F6D4-48D1-A2 | PO18270199753 | 19 | 288 | 349 | 11 | 6 | 2022-07-02 | 2024.99 | 50.62 | 2022-06-20 | 1 | 1898.09 | 1 | 2024.99 | 5 | SO46035 | 2022-06-27 | 162.00 | 1898.09 | 2024.99 | |||
SO51092_9 | FB68-47B7-9D | PO15312133079 | 19 | 291 | 487 | 299 | 6 | 2023-09-01 | 263.95 | 6.60 | 2023-08-20 | 8 | 20.57 | 1 | 263.95 | 9 | SO51092 | 2023-08-27 | 21.12 | 164.53 | 32.99 | |||
SO44288_6 | 6F5C-4E3C-B5 | PO14732190246 | 19 | 288 | 322 | 514 | 6 | 2021-12-02 | 2516.75 | 62.92 | 2021-11-20 | 6 | 413.15 | 1 | 2516.75 | 6 | SO44288 | 2021-11-27 | 201.34 | 2478.88 | 419.46 | |||
SO50712_2 | 9AAC-4C4A-AB | PO14268119350 | 100 | 281 | 448 | 418 | 3 | 2023-08-02 | 59.97 | 1.50 | 2023-07-21 | 5 | 8.25 | 1 | 59.97 | 2 | SO50712 | 2023-07-28 | 4.80 | 41.23 | 11.99 | |||
SO50681_27 | C44A-4F6F-86 | PO12673115760 | 100 | 292 | 339 | 499 | 7 | 2023-08-02 | 469.79 | 11.74 | 2023-07-21 | 1 | 486.71 | 1 | 469.79 | 27 | SO50681 | 2023-07-28 | 37.58 | 486.71 | 469.79 | |||
SO57188_1 | BA1D-4480-AA | PO9077120275 | 19 | 291 | 590 | 100 | 6 | 2024-01-02 | 461.69 | 11.54 | 2023-12-21 | 1 | 419.78 | 1 | 461.69 | 1 | SO57188 | 2023-12-28 | 36.94 | 419.78 | 461.69 | |||
SO69460_3 | D5C8-450E-9F | PO1595193276 | 19 | 284 | 581 | 426 | 6 | 2024-07-02 | 1020.59 | 25.51 | 2024-06-20 | 1 | 1082.51 | 1 | 1020.59 | 3 | SO69460 | 2024-06-27 | 81.65 | 1082.51 | 1020.59 | |||
SO57052_1 | A473-463C-BA | PO13601132246 | 100 | 281 | 234 | 310 | 3 | 2024-01-02 | 149.97 | 3.75 | 2023-12-21 | 5 | 38.49 | 1 | 149.97 | 1 | SO57052 | 2023-12-28 | 12.00 | 192.46 | 29.99 | |||
SO61200_7 | 9B44-40EF-86 | PO2755113256 | 100 | 272 | 506 | 205 | 4 | 2024-03-03 | 600.16 | 15.00 | 2024-02-20 | 3 | 199.85 | 1 | 600.16 | 7 | SO61200 | 2024-02-27 | 48.01 | 599.56 | 200.05 | |||
SO55280_28 | B925-404B-8B | PO18444178908 | 19 | 291 | 547 | 227 | 6 | 2023-12-02 | 145.78 | 3.64 | 2023-11-20 | 3 | 35.96 | 1 | 145.78 | 28 | SO55280 | 2023-11-27 | 11.66 | 107.88 | 48.59 | |||
SO45283_1 | 07F7-44C2-BA | PO16646111452 | 100 | 286 | 320 | 1 | 1 | 2022-04-04 | 419.46 | 10.49 | 2022-03-23 | 1 | 413.15 | 1 | 419.46 | 1 | SO45283 | 2022-03-30 | 33.56 | 413.15 | 419.46 | |||
SO51861_5 | 1365-48AA-87 | PO3712133982 | 100 | 290 | 222 | 662 | 7 | 2023-10-02 | 104.97 | 2.62 | 2023-09-20 | 5 | 13.09 | 1 | 104.97 | 5 | SO51861 | 2023-09-27 | 8.40 | 65.43 | 20.99 | |||
SO53560_56 | 3D25-4203-A4 | PO7685199983 | 100 | 283 | 548 | 539 | 2 | 2023-11-02 | 145.78 | 3.64 | 2023-10-21 | 3 | 35.96 | 1 | 145.78 | 56 | SO53560 | 2023-10-28 | 11.66 | 107.88 | 48.59 | |||
SO47999_23 | DF06-4F6A-9D | PO14500121568 | 100 | 282 | 469 | 650 | 1 | 2023-01-02 | 91.18 | 2.28 | 2022-12-21 | 4 | 15.67 | 1 | 91.18 | 23 | SO47999 | 2022-12-28 | 7.29 | 62.68 | 22.79 | |||
SO53470_14 | 932B-41E0-AF | PO17052111209 | 100 | 282 | 499 | 2 | 420 | 4 | 128.10 | 2023-11-02 | 6404.95 | 156.92 | 2023-10-21 | 11 | 601.74 | 1 | 6276.85 | 14 | SO53470 | 2023-10-28 | 502.15 | 6619.18 | 582.27 | 0.02 |
SO46969_19 | 3C39-4176-A8 | PO15370166954 | 100 | 283 | 352 | 381 | 3 | 2022-10-02 | 4971.41 | 124.29 | 2022-09-20 | 4 | 1117.86 | 1 | 4971.41 | 19 | SO46969 | 2022-09-27 | 397.71 | 4471.42 | 1242.85 | |||
SO47967_3 | DA42-41A7-BD | PO19198173391 | 19 | 291 | 421 | 653 | 6 | 2023-01-02 | 785.32 | 19.63 | 2022-12-21 | 4 | 145.28 | 1 | 785.32 | 3 | SO47967 | 2022-12-28 | 62.83 | 581.13 | 196.33 | |||
SO50205_2 | 9A7F-44D8-AF | PO16762191475 | 100 | 272 | 323 | 259 | 4 | 2023-07-02 | 469.79 | 11.74 | 2023-06-20 | 1 | 486.71 | 1 | 469.79 | 2 | SO50205 | 2023-06-27 | 37.58 | 486.71 | 469.79 | |||
SO47377_13 | FA63-499A-AB | PO15515156459 | 100 | 292 | 273 | 481 | 7 | 2022-11-02 | 202.33 | 5.06 | 2022-10-21 | 1 | 187.16 | 1 | 202.33 | 13 | SO47377 | 2022-10-28 | 16.19 | 187.16 | 202.33 | |||
SO69448_2 | 26BF-4CA1-97 | PO11020118669 | 19 | 284 | 472 | 336 | 6 | 2024-07-02 | 76.20 | 1.91 | 2024-06-20 | 2 | 23.75 | 1 | 76.20 | 2 | SO69448 | 2024-06-27 | 6.10 | 47.50 | 38.10 | |||
SO53473_3 | E4F8-4F0B-BC | PO16530183958 | 100 | 282 | 558 | 601 | 1 | 2023-11-02 | 728.98 | 18.22 | 2023-10-21 | 3 | 179.82 | 1 | 728.98 | 3 | SO53473 | 2023-10-28 | 58.32 | 539.45 | 242.99 | |||
SO51147_8 | C4D7-458D-A6 | PO9831167474 | 100 | 285 | 243 | 81 | 5 | 2023-09-01 | 2576.70 | 64.42 | 2023-08-20 | 3 | 868.63 | 1 | 2576.70 | 8 | SO51147 | 2023-08-27 | 206.14 | 2605.90 | 858.90 | |||
SO65269_14 | 999D-45C9-AA | PO4640162431 | 100 | 287 | 593 | 648 | 4 | 2024-05-02 | 338.99 | 8.47 | 2024-04-20 | 1 | 308.22 | 1 | 338.99 | 14 | SO65269 | 2024-04-27 | 27.12 | 308.22 | 338.99 | |||
SO44504_6 | CFE2-4C08-B0 | PO16733198490 | 19 | 288 | 264 | 533 | 6 | 2022-01-02 | 367.88 | 9.20 | 2021-12-21 | 2 | 181.49 | 1 | 367.88 | 6 | SO44504 | 2021-12-28 | 29.43 | 362.97 | 183.94 | |||
SO55249_20 | 0527-4C9D-BA | PO13688172507 | 100 | 282 | 472 | 475 | 4 | 2023-12-02 | 342.90 | 8.57 | 2023-11-20 | 9 | 23.75 | 1 | 342.90 | 20 | SO55249 | 2023-11-27 | 27.43 | 213.74 | 38.10 | |||
SO50284_45 | F8D1-49E1-A5 | PO4901178867 | 19 | 284 | 213 | 84 | 6 | 2023-07-02 | 40.37 | 1.01 | 2023-06-20 | 2 | 13.88 | 1 | 40.37 | 45 | SO50284 | 2023-06-27 | 3.23 | 27.76 | 20.19 | |||
SO50676_31 | 66F1-4A9A-97 | PO14790188963 | 19 | 291 | 356 | 497 | 6 | 2023-08-02 | 4971.41 | 124.29 | 2023-07-21 | 4 | 1117.86 | 1 | 4971.41 | 31 | SO50676 | 2023-07-28 | 397.71 | 4471.42 | 1242.85 | |||
SO49053_39 | 5BE4-4969-A1 | PO16414175823 | 100 | 289 | 428 | 236 | 1 | 2023-04-04 | 627.77 | 15.69 | 2023-03-23 | 3 | 185.82 | 1 | 627.77 | 39 | SO49053 | 2023-03-30 | 50.22 | 557.46 | 209.26 | |||
SO65199_7 | F8B4-4F74-87 | PO870111351 | 100 | 286 | 578 | 621 | 1 | 2024-05-02 | 2186.73 | 54.67 | 2024-04-20 | 3 | 755.15 | 1 | 2186.73 | 7 | SO65199 | 2024-04-27 | 174.94 | 2265.45 | 728.91 | |||
SO69399_15 | BEA9-4703-91 | PO17661173810 | 19 | 284 | 471 | 2 | 264 | 6 | 10.31 | 2024-07-02 | 515.62 | 12.63 | 2024-06-20 | 14 | 23.75 | 1 | 505.31 | 15 | SO69399 | 2024-06-27 | 40.42 | 332.49 | 36.83 | 0.02 |
Generated 2024-09-20 01:33:12.339 UTC