[ROOT] dt FactResellerSale < WHERE DimSalesTerritoryId EQ ALL SKIP 0 SHUFFLE < SKIP 471 > < TAKE 60 >
60 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 |
---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
SO55243_29 | 2457-46EE-88 | PO15312160912 | 19 | 291 | 386 | 299 | 6 | 2023-12-03 | 1344.59 | 33.61 | 2023-11-21 | 2 | 713.08 | 1 | 1344.59 | 29 | SO55243 | 2023-11-28 | 107.57 | 1426.16 | 672.29 | |||
SO65236_12 | 46EF-4D44-A9 | PO9483140017 | 100 | 283 | 605 | 54 | 2 | 2024-05-03 | 1295.98 | 32.40 | 2024-04-21 | 4 | 343.65 | 1 | 1295.98 | 12 | SO65236 | 2024-04-28 | 103.68 | 1374.60 | 323.99 | |||
SO51152_4 | 4AC3-4FB1-92 | PO6032186778 | 6 | 296 | 561 | 14 | 177 | 9 | 190.73 | 2023-09-02 | 953.63 | 19.07 | 2023-08-21 | 1 | 1481.94 | 1 | 762.90 | 4 | SO51152 | 2023-08-28 | 61.03 | 1481.94 | 953.63 | 0.20 |
SO65155_26 | 154D-4EBA-85 | PO19633122185 | 100 | 287 | 588 | 149 | 3 | 2024-05-03 | 461.69 | 11.54 | 2024-04-21 | 1 | 419.78 | 1 | 461.69 | 26 | SO65155 | 2024-04-28 | 36.94 | 419.78 | 461.69 | |||
SO49515_5 | 52D0-4584-BC | PO9715144044 | 100 | 281 | 294 | 490 | 4 | 2023-05-03 | 2977.09 | 74.43 | 2023-04-21 | 4 | 660.91 | 1 | 2977.09 | 5 | SO49515 | 2023-04-28 | 238.17 | 2643.66 | 744.27 | |||
SO53459_9 | 9828-4F27-B0 | PO19372154638 | 100 | 282 | 477 | 582 | 4 | 2023-11-03 | 11.98 | 0.30 | 2023-10-22 | 4 | 1.87 | 1 | 11.98 | 9 | SO53459 | 2023-10-29 | 0.96 | 7.47 | 2.99 | |||
SO53548_11 | CF97-4D6F-95 | PO14268111072 | 100 | 281 | 583 | 418 | 3 | 2023-11-03 | 1020.59 | 25.51 | 2023-10-22 | 1 | 1082.51 | 1 | 1020.59 | 11 | SO53548 | 2023-10-29 | 81.65 | 1082.51 | 1020.59 | |||
SO48770_9 | 28CC-48AC-B8 | PO11484112888 | 100 | 283 | 460 | 594 | 2 | 2023-03-05 | 107.99 | 2.70 | 2023-02-21 | 2 | 37.12 | 1 | 107.99 | 9 | SO48770 | 2023-02-28 | 8.64 | 74.24 | 53.99 | |||
SO67273_39 | 9BAE-4E69-B9 | PO13688176638 | 100 | 282 | 309 | 475 | 4 | 2024-06-03 | 818.70 | 20.47 | 2024-05-22 | 1 | 747.20 | 1 | 818.70 | 39 | SO67273 | 2024-05-29 | 65.50 | 747.20 | 818.70 | |||
SO51855_2 | 8551-4CDF-A1 | PO3480115731 | 100 | 281 | 605 | 436 | 4 | 2023-10-03 | 971.98 | 24.30 | 2023-09-21 | 3 | 343.65 | 1 | 971.98 | 2 | SO51855 | 2023-09-28 | 77.76 | 1030.95 | 323.99 | |||
SO63123_15 | ADA9-4CA6-94 | PO19923184888 | 100 | 283 | 474 | 18 | 3 | 2024-04-04 | 167.98 | 4.20 | 2024-03-23 | 4 | 26.18 | 1 | 167.98 | 15 | SO63123 | 2024-03-30 | 13.44 | 104.71 | 41.99 | |||
SO57143_25 | 69ED-4172-83 | PO3567189986 | 100 | 292 | 562 | 193 | 7 | 2024-01-03 | 2860.88 | 71.52 | 2023-12-22 | 2 | 1481.94 | 1 | 2860.88 | 25 | SO57143 | 2023-12-29 | 228.87 | 2963.88 | 1430.44 | |||
SO49891_46 | 78CA-4790-95 | PO8410166354 | 98 | 288 | 453 | 538 | 10 | 2023-06-03 | 107.98 | 2.70 | 2023-05-22 | 3 | 24.75 | 1 | 107.98 | 46 | SO49891 | 2023-05-29 | 8.64 | 74.24 | 35.99 | |||
SO69545_27 | 2C06-44D9-96 | PO3480123333 | 100 | 272 | 482 | 436 | 4 | 2024-07-03 | 26.97 | 0.67 | 2024-06-21 | 5 | 3.36 | 1 | 26.97 | 27 | SO69545 | 2024-06-28 | 2.16 | 16.81 | 5.39 | |||
SO53556_6 | 05D7-4FCA-9D | PO12325153851 | 100 | 283 | 559 | 53 | 2 | 2023-11-03 | 12.14 | 0.30 | 2023-10-22 | 1 | 8.99 | 1 | 12.14 | 6 | SO53556 | 2023-10-29 | 0.97 | 8.99 | 12.14 | |||
SO47024_18 | F254-4053-A3 | PO3654136382 | 100 | 283 | 469 | 435 | 4 | 2022-10-03 | 136.76 | 3.42 | 2022-09-21 | 6 | 15.67 | 1 | 136.76 | 18 | SO47024 | 2022-09-28 | 10.94 | 94.03 | 22.79 | |||
SO69560_6 | B1B6-43F4-BC | PO9077167302 | 19 | 291 | 589 | 100 | 6 | 2024-07-03 | 923.39 | 23.08 | 2024-06-21 | 2 | 419.78 | 1 | 923.39 | 6 | SO69560 | 2024-06-28 | 73.87 | 839.56 | 461.69 | |||
SO53520_16 | 7FFF-4635-B3 | PO1131160733 | 36 | 295 | 507 | 536 | 8 | 2023-11-03 | 800.21 | 20.01 | 2023-10-22 | 4 | 199.85 | 1 | 800.21 | 16 | SO53520 | 2023-10-29 | 64.02 | 799.41 | 200.05 | |||
SO69459_1 | 8CD0-4540-AA | PO1247182751 | 100 | 285 | 603 | 296 | 5 | 2024-07-03 | 72.89 | 1.82 | 2024-06-21 | 1 | 53.94 | 1 | 72.89 | 1 | SO69459 | 2024-06-28 | 5.83 | 53.94 | 72.89 | |||
SO63171_16 | 6618-4F16-BE | PO580178064 | 36 | 295 | 500 | 230 | 8 | 2024-04-04 | 1204.69 | 30.12 | 2024-03-23 | 2 | 601.74 | 1 | 1204.69 | 16 | SO63171 | 2024-03-30 | 96.38 | 1203.49 | 602.35 | |||
SO49538_8 | CB52-4E7E-9B | PO6786132021 | 100 | 281 | 329 | 3 | 4 | 2023-05-03 | 939.59 | 23.49 | 2023-04-21 | 2 | 486.71 | 1 | 939.59 | 8 | SO49538 | 2023-04-28 | 75.17 | 973.41 | 469.79 | |||
SO46614_5 | 0B65-4374-89 | PO15312137226 | 19 | 291 | 236 | 299 | 6 | 2022-09-02 | 288.40 | 7.21 | 2022-08-21 | 10 | 29.08 | 1 | 288.40 | 5 | SO46614 | 2022-08-28 | 23.07 | 290.81 | 28.84 | |||
SO48387_6 | C0BE-45D3-9D | PO8294167884 | 100 | 289 | 297 | 488 | 1 | 2023-02-02 | 736.15 | 18.40 | 2023-01-21 | 1 | 653.70 | 1 | 736.15 | 6 | SO48387 | 2023-01-28 | 58.89 | 653.70 | 736.15 | |||
SO50313_4 | B452-44E9-91 | PO7656143984 | 100 | 282 | 385 | 403 | 4 | 2023-07-03 | 3001.31 | 75.03 | 2023-06-21 | 5 | 605.65 | 1 | 3001.31 | 4 | SO50313 | 2023-06-28 | 240.11 | 3028.25 | 600.26 | |||
SO71847_13 | 3A74-467E-8B | PO18502143784 | 19 | 291 | 507 | 154 | 6 | 2024-08-03 | 200.05 | 5.00 | 2024-07-22 | 1 | 199.85 | 1 | 200.05 | 13 | SO71847 | 2024-07-29 | 16.00 | 199.85 | 200.05 | |||
SO53526_10 | 6EEB-4506-89 | PO1624140151 | 100 | 281 | 404 | 579 | 3 | 2023-11-03 | 53.45 | 1.34 | 2023-10-22 | 2 | 19.78 | 1 | 53.45 | 10 | SO53526 | 2023-10-29 | 4.28 | 39.55 | 26.72 | |||
SO51154_41 | 2A76-4451-99 | PO7859157852 | 100 | 287 | 481 | 221 | 4 | 2023-09-02 | 21.58 | 0.54 | 2023-08-21 | 4 | 3.36 | 1 | 21.58 | 41 | SO51154 | 2023-08-28 | 1.73 | 13.45 | 5.39 | |||
SO47718_27 | B391-4A07-98 | PO6699137967 | 100 | 281 | 415 | 234 | 2 | 2022-12-03 | 792.14 | 19.80 | 2022-11-21 | 4 | 146.55 | 1 | 792.14 | 27 | SO47718 | 2022-11-28 | 63.37 | 586.19 | 198.04 | |||
SO51862_1 | 54E8-4E89-AF | PO4205186101 | 100 | 283 | 359 | 323 | 3 | 2023-10-03 | 4130.98 | 103.27 | 2023-09-21 | 3 | 1251.98 | 1 | 4130.98 | 1 | SO51862 | 2023-09-28 | 330.48 | 3755.94 | 1376.99 | |||
SO51734_30 | 9D8E-4873-8B | PO13427111801 | 100 | 292 | 243 | 638 | 7 | 2023-10-03 | 1717.80 | 42.95 | 2023-09-21 | 2 | 868.63 | 1 | 1717.80 | 30 | SO51734 | 2023-09-28 | 137.42 | 1737.27 | 858.90 | |||
SO48731_3 | 2DDD-453B-85 | PO19314141866 | 100 | 281 | 327 | 622 | 3 | 2023-03-05 | 939.59 | 23.49 | 2023-02-21 | 2 | 486.71 | 1 | 939.59 | 3 | SO48731 | 2023-02-28 | 75.17 | 973.41 | 469.79 | |||
SO49052_23 | 8769-409E-94 | PO16733182723 | 19 | 291 | 323 | 533 | 6 | 2023-04-05 | 3288.56 | 82.21 | 2023-03-24 | 7 | 486.71 | 1 | 3288.56 | 23 | SO49052 | 2023-03-31 | 263.08 | 3406.95 | 469.79 | |||
SO71886_34 | AE34-4CC5-9B | PO6815136550 | 100 | 293 | 512 | 109 | 1 | 2024-08-03 | 218.45 | 5.46 | 2024-07-22 | 1 | 199.38 | 1 | 218.45 | 34 | SO71886 | 2024-07-29 | 17.48 | 199.38 | 218.45 | |||
SO46993_3 | F652-4085-A4 | PO11658111433 | 100 | 272 | 421 | 233 | 2 | 2022-10-03 | 981.65 | 24.54 | 2022-09-21 | 5 | 145.28 | 1 | 981.65 | 3 | SO46993 | 2022-09-28 | 78.53 | 726.42 | 196.33 | |||
SO47028_27 | 8DA0-456D-8F | PO3799132728 | 100 | 282 | 468 | 312 | 4 | 2022-10-03 | 45.59 | 1.14 | 2022-09-21 | 2 | 15.67 | 1 | 45.59 | 27 | SO47028 | 2022-09-28 | 3.65 | 31.34 | 22.79 | |||
SO45285_4 | 91C9-46BD-A9 | PO16791139915 | 100 | 281 | 319 | 36 | 2 | 2022-04-05 | 3499.18 | 87.48 | 2022-03-24 | 4 | 884.71 | 1 | 3499.18 | 4 | SO45285 | 2022-03-31 | 279.93 | 3538.83 | 874.79 | |||
SO53565_19 | 7768-4A45-93 | PO9396130858 | 6 | 296 | 484 | 267 | 9 | 2023-11-03 | 28.62 | 0.72 | 2023-10-22 | 6 | 2.97 | 1 | 28.62 | 19 | SO53565 | 2023-10-29 | 2.29 | 17.84 | 4.77 | |||
SO69418_1 | D0CE-41AD-AA | PO15370180703 | 100 | 281 | 551 | 381 | 3 | 2024-07-03 | 316.86 | 7.92 | 2024-06-21 | 2 | 144.59 | 1 | 316.86 | 1 | SO69418 | 2024-06-28 | 25.35 | 289.19 | 158.43 | |||
SO47673_10 | AFCF-4DA6-99 | PO13862175462 | 19 | 291 | 360 | 119 | 6 | 2022-12-03 | 7376.75 | 184.42 | 2022-11-21 | 6 | 1105.81 | 1 | 7376.75 | 10 | SO47673 | 2022-11-28 | 590.14 | 6634.86 | 1229.46 | |||
SO44768_22 | 18BD-48B8-95 | PO261164909 | 100 | 283 | 232 | 647 | 4 | 2022-02-02 | 173.04 | 4.33 | 2022-01-21 | 6 | 31.72 | 1 | 173.04 | 22 | SO44768 | 2022-01-28 | 13.84 | 190.35 | 28.84 | |||
SO44771_5 | A78D-40A1-9E | PO783176074 | 100 | 286 | 285 | 91 | 1 | 2022-02-02 | 357.16 | 8.93 | 2022-01-21 | 2 | 176.20 | 1 | 357.16 | 5 | SO44771 | 2022-01-28 | 28.57 | 352.40 | 178.58 | |||
SO51704_42 | 13FA-4729-A9 | PO17661178081 | 19 | 284 | 490 | 264 | 6 | 2023-10-03 | 291.55 | 7.29 | 2023-09-21 | 9 | 41.57 | 1 | 291.55 | 42 | SO51704 | 2023-09-28 | 23.32 | 374.15 | 32.39 | |||
SO69543_1 | 5CDC-4A5C-B9 | PO1218172017 | 98 | 288 | 436 | 412 | 10 | 2024-07-03 | 356.90 | 8.92 | 2024-06-21 | 1 | 360.94 | 1 | 356.90 | 1 | SO69543 | 2024-06-28 | 28.55 | 360.94 | 356.90 | |||
SO51088_4 | 4E58-4FFA-9F | PO17197140322 | 100 | 283 | 400 | 125 | 2 | 2023-09-02 | 74.30 | 1.86 | 2023-08-21 | 2 | 27.49 | 1 | 74.30 | 4 | SO51088 | 2023-08-28 | 5.94 | 54.99 | 37.15 | |||
SO65243_1 | F88F-4FB2-85 | PO11194174051 | 19 | 284 | 500 | 48 | 6 | 2024-05-03 | 602.35 | 15.06 | 2024-04-21 | 1 | 601.74 | 1 | 602.35 | 1 | SO65243 | 2024-04-28 | 48.19 | 601.74 | 602.35 | |||
SO51700_12 | 6837-439E-BC | PO17806126316 | 19 | 291 | 545 | 101 | 6 | 2023-10-03 | 48.59 | 1.21 | 2023-09-21 | 2 | 17.98 | 1 | 48.59 | 12 | SO51700 | 2023-09-28 | 3.89 | 35.96 | 24.29 | |||
SO44115_17 | 5360-4C42-90 | PO3248122509 | 100 | 282 | 345 | 366 | 4 | 2021-11-03 | 18359.95 | 459.00 | 2021-10-22 | 9 | 1912.15 | 1 | 18359.95 | 17 | SO44115 | 2021-10-29 | 1468.80 | 17209.39 | 2039.99 | |||
SO59071_2 | EFC3-4244-A6 | PO9599176835 | 100 | 285 | 382 | 170 | 5 | 2024-02-02 | 4706.06 | 117.65 | 2024-01-21 | 7 | 713.08 | 1 | 4706.06 | 2 | SO59071 | 2024-01-28 | 376.48 | 4991.56 | 672.29 | |||
SO49864_3 | D282-4C24-9B | PO13775121562 | 100 | 283 | 213 | 618 | 2 | 2023-06-03 | 100.93 | 2.52 | 2023-05-22 | 5 | 13.88 | 1 | 100.93 | 3 | SO49864 | 2023-05-29 | 8.07 | 69.39 | 20.19 | |||
SO50225_14 | 6F8E-49A2-A5 | PO12702153410 | 100 | 292 | 457 | 175 | 7 | 2023-07-03 | 89.99 | 2.25 | 2023-06-21 | 2 | 30.93 | 1 | 89.99 | 14 | SO50225 | 2023-06-28 | 7.20 | 61.87 | 44.99 | |||
SO45053_12 | 1527-4B4C-8B | PO13775163879 | 100 | 281 | 326 | 618 | 2 | 2022-03-05 | 419.46 | 10.49 | 2022-02-21 | 1 | 413.15 | 1 | 419.46 | 12 | SO45053 | 2022-02-28 | 33.56 | 413.15 | 419.46 | |||
SO51786_23 | CB32-4179-97 | PO18357130739 | 19 | 272 | 579 | 138 | 6 | 2023-10-03 | 1457.82 | 36.45 | 2023-09-21 | 2 | 755.15 | 1 | 1457.82 | 23 | SO51786 | 2023-09-28 | 116.63 | 1510.30 | 728.91 | |||
SO65200_27 | C4A9-49C4-AE | PO841148607 | 100 | 286 | 400 | 254 | 1 | 2024-05-03 | 148.61 | 3.72 | 2024-04-21 | 4 | 27.49 | 1 | 148.61 | 27 | SO65200 | 2024-04-28 | 11.89 | 109.97 | 37.15 | |||
SO45811_1 | C0A1-43C4-AE | PO6409111249 | 100 | 283 | 328 | 292 | 4 | 2022-06-03 | 419.46 | 10.49 | 2022-05-22 | 1 | 413.15 | 1 | 419.46 | 1 | SO45811 | 2022-05-29 | 33.56 | 413.15 | 419.46 | |||
SO57024_20 | DED7-4CEF-90 | PO17661138970 | 19 | 284 | 217 | 264 | 6 | 2024-01-03 | 188.95 | 4.72 | 2023-12-22 | 9 | 13.09 | 1 | 188.95 | 20 | SO57024 | 2023-12-29 | 15.12 | 117.78 | 20.99 | |||
SO51096_30 | 2D8A-4DAD-96 | PO14732111307 | 19 | 291 | 374 | 514 | 6 | 2023-09-02 | 5864.04 | 146.60 | 2023-08-21 | 4 | 1554.95 | 1 | 5864.04 | 30 | SO51096 | 2023-08-28 | 469.12 | 6219.79 | 1466.01 | |||
SO57088_19 | EA31-4951-8A | PO2842199218 | 100 | 285 | 390 | 700 | 5 | 2024-01-03 | 3361.47 | 84.04 | 2023-12-22 | 5 | 713.08 | 1 | 3361.47 | 19 | SO57088 | 2023-12-29 | 268.92 | 3565.40 | 672.29 | |||
SO49161_5 | 0377-44E6-AA | PO7627157444 | 100 | 293 | 373 | 433 | 1 | 2023-04-05 | 2617.88 | 65.45 | 2023-03-24 | 2 | 1320.68 | 1 | 2617.88 | 5 | SO49161 | 2023-03-31 | 209.43 | 2641.37 | 1308.94 | |||
SO65209_11 | B869-4DFD-AB | PO2697179473 | 100 | 282 | 359 | 187 | 4 | 2024-05-03 | 1376.99 | 34.42 | 2024-04-21 | 1 | 1251.98 | 1 | 1376.99 | 11 | SO65209 | 2024-04-28 | 110.16 | 1251.98 | 1376.99 | |||
SO44314_12 | 6FDF-4206-A7 | PO5626111923 | 100 | 283 | 316 | 166 | 4 | 2021-12-03 | 1749.59 | 43.74 | 2021-11-21 | 2 | 884.71 | 1 | 1749.59 | 12 | SO44314 | 2021-11-28 | 139.97 | 1769.42 | 874.79 |
Generated 2024-09-20 09:22:44.809 UTC