[ROOT] dt FactResellerSale < WHERE DimSalesTerritoryId EQ ALL SKIP 0 SHUFFLE < SKIP 1061 > < 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 |
---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
SO57144_40 | 074E-478C-99 | PO3799111077 | 100 | 282 | 596 | 312 | 4 | 2024-01-02 | 323.99 | 8.10 | 2023-12-21 | 1 | 294.58 | 1 | 323.99 | 40 | SO57144 | 2023-12-28 | 25.92 | 294.58 | 323.99 | |||
SO71850_7 | 3DA6-4E97-9F | PO18241134627 | 100 | 285 | 484 | 477 | 5 | 2024-08-02 | 9.54 | 0.24 | 2024-07-21 | 2 | 2.97 | 1 | 9.54 | 7 | SO71850 | 2024-07-28 | 0.76 | 5.95 | 4.77 | |||
SO71798_25 | AFA9-4B18-AD | PO16994135863 | 100 | 283 | 482 | 306 | 3 | 2024-08-02 | 37.76 | 0.94 | 2024-07-21 | 7 | 3.36 | 1 | 37.76 | 25 | SO71798 | 2024-07-28 | 3.02 | 23.54 | 5.39 | |||
SO58920_10 | 944F-4219-85 | PO16501139645 | 98 | 288 | 490 | 142 | 10 | 2024-02-01 | 259.15 | 6.48 | 2024-01-20 | 8 | 41.57 | 1 | 259.15 | 10 | SO58920 | 2024-01-27 | 20.73 | 332.58 | 32.39 | |||
SO58963_20 | 6ADC-4485-8C | PO841129336 | 100 | 286 | 594 | 254 | 1 | 2024-02-01 | 2372.96 | 59.32 | 2024-01-20 | 7 | 308.22 | 1 | 2372.96 | 20 | SO58963 | 2024-01-27 | 189.84 | 2157.53 | 338.99 | |||
SO49147_4 | B753-40C9-A6 | PO5771172608 | 100 | 282 | 321 | 79 | 3 | 2023-04-04 | 2348.97 | 58.72 | 2023-03-23 | 5 | 486.71 | 1 | 2348.97 | 4 | SO49147 | 2023-03-30 | 187.92 | 2433.53 | 469.79 | |||
SO65322_1 | 841D-45EE-9F | PO8903163985 | 100 | 293 | 390 | 235 | 1 | 2024-05-02 | 1344.59 | 33.61 | 2024-04-20 | 2 | 713.08 | 1 | 1344.59 | 1 | SO65322 | 2024-04-27 | 107.57 | 1426.16 | 672.29 | |||
SO51088_20 | 4E58-4FFA-9F | PO17197140322 | 100 | 283 | 357 | 125 | 2 | 2023-09-01 | 2783.99 | 69.60 | 2023-08-20 | 2 | 1265.62 | 1 | 2783.99 | 20 | SO51088 | 2023-08-27 | 222.72 | 2531.24 | 1391.99 | |||
SO51089_12 | A635-4BAF-BC | PO16588151558 | 100 | 289 | 357 | 146 | 1 | 2023-09-01 | 9743.96 | 243.60 | 2023-08-20 | 7 | 1265.62 | 1 | 9743.96 | 12 | SO51089 | 2023-08-27 | 779.52 | 8859.34 | 1391.99 | |||
SO46058_15 | FA37-4F46-97 | PO12557123934 | 100 | 282 | 332 | 240 | 4 | 2022-07-02 | 419.46 | 10.49 | 2022-06-20 | 1 | 413.15 | 1 | 419.46 | 15 | SO46058 | 2022-06-27 | 33.56 | 413.15 | 419.46 | |||
SO46625_36 | 361B-4CAF-A2 | PO13688113829 | 100 | 282 | 230 | 475 | 4 | 2022-09-01 | 173.04 | 4.33 | 2022-08-20 | 6 | 29.08 | 1 | 173.04 | 36 | SO46625 | 2022-08-27 | 13.84 | 174.48 | 28.84 | |||
SO45538_10 | 0310-4DCB-B5 | PO14268192541 | 100 | 283 | 326 | 418 | 3 | 2022-05-02 | 419.46 | 10.49 | 2022-04-20 | 1 | 413.15 | 1 | 419.46 | 10 | SO45538 | 2022-04-27 | 33.56 | 413.15 | 419.46 | |||
SO53574_6 | A501-443D-A3 | PO6119138590 | 98 | 288 | 225 | 268 | 10 | 2023-11-02 | 26.97 | 0.67 | 2023-10-21 | 5 | 6.92 | 1 | 26.97 | 6 | SO53574 | 2023-10-28 | 2.16 | 34.61 | 5.39 | |||
SO53496_1 | 5404-4BB1-95 | PO12992153220 | 100 | 282 | 558 | 295 | 4 | 2023-11-02 | 242.99 | 6.07 | 2023-10-21 | 1 | 179.82 | 1 | 242.99 | 1 | SO53496 | 2023-10-28 | 19.44 | 179.82 | 242.99 | |||
SO44520_33 | 5BE0-436B-8C | PO12499152870 | 100 | 282 | 322 | 78 | 4 | 2022-01-02 | 2516.75 | 62.92 | 2021-12-21 | 6 | 413.15 | 1 | 2516.75 | 33 | SO44520 | 2021-12-28 | 201.34 | 2478.88 | 419.46 | |||
SO69528_38 | 2644-4747-86 | PO6438163496 | 100 | 272 | 483 | 309 | 4 | 2024-07-02 | 504.00 | 12.60 | 2024-06-20 | 7 | 44.88 | 1 | 504.00 | 38 | SO69528 | 2024-06-27 | 40.32 | 314.16 | 72.00 | |||
SO69502_3 | 2A73-4DAC-AB | PO6293127965 | 100 | 285 | 434 | 612 | 5 | 2024-07-02 | 713.80 | 17.84 | 2024-06-20 | 2 | 360.94 | 1 | 713.80 | 3 | SO69502 | 2024-06-27 | 57.10 | 721.89 | 356.90 | |||
SO67298_8 | F9FB-4B4C-92 | PO2755196827 | 100 | 282 | 569 | 205 | 4 | 2024-06-02 | 2672.46 | 66.81 | 2024-05-21 | 6 | 461.44 | 1 | 2672.46 | 8 | SO67298 | 2024-05-28 | 213.80 | 2768.67 | 445.41 | |||
SO57128_14 | 52E0-4277-80 | PO6525176590 | 100 | 281 | 353 | 345 | 4 | 2024-01-02 | 4175.98 | 104.40 | 2023-12-21 | 3 | 1265.62 | 1 | 4175.98 | 14 | SO57128 | 2023-12-28 | 334.08 | 3796.86 | 1391.99 | |||
SO46643_9 | 49E8-4C7A-85 | PO899110603 | 100 | 289 | 383 | 290 | 1 | 2022-09-01 | 1800.79 | 45.02 | 2022-08-20 | 3 | 605.65 | 1 | 1800.79 | 9 | SO46643 | 2022-08-27 | 144.06 | 1816.95 | 600.26 | |||
SO49532_7 | 25FB-49B5-A0 | PO5539144637 | 100 | 282 | 356 | 61 | 4 | 2023-05-02 | 2485.70 | 62.14 | 2023-04-20 | 2 | 1117.86 | 1 | 2485.70 | 7 | SO49532 | 2023-04-27 | 198.86 | 2235.71 | 1242.85 | |||
SO51809_9 | F690-4F1D-B1 | PO6438145374 | 100 | 281 | 480 | 309 | 4 | 2023-10-02 | 1.37 | 0.03 | 2023-09-20 | 1 | 0.86 | 1 | 1.37 | 9 | SO51809 | 2023-09-27 | 0.11 | 0.86 | 1.37 | |||
SO51169_13 | 995D-4C3D-86 | PO5452173982 | 36 | 295 | 586 | 13 | 320 | 8 | 300.65 | 2023-09-01 | 2004.35 | 42.59 | 2023-08-20 | 6 | 461.44 | 1 | 1703.69 | 13 | SO51169 | 2023-08-27 | 136.30 | 2768.67 | 334.06 | 0.15 |
SO44126_7 | 0FC0-4BE3-AF | PO7192167220 | 100 | 289 | 346 | 20 | 1 | 2021-11-02 | 2039.99 | 51.00 | 2021-10-21 | 1 | 1912.15 | 1 | 2039.99 | 7 | SO44126 | 2021-10-28 | 163.20 | 1912.15 | 2039.99 | |||
SO53539_16 | 2B21-4FAC-8C | PO18763121730 | 100 | 287 | 576 | 59 | 4 | 2023-11-02 | 4291.33 | 107.28 | 2023-10-21 | 3 | 1481.94 | 1 | 4291.33 | 16 | SO53539 | 2023-10-28 | 343.31 | 4445.81 | 1430.44 | |||
SO45343_7 | 9A71-4101-BA | PO8874137222 | 100 | 282 | 215 | 348 | 3 | 2022-04-04 | 80.75 | 2.02 | 2022-03-23 | 4 | 12.03 | 1 | 80.75 | 7 | SO45343 | 2022-03-30 | 6.46 | 48.11 | 20.19 | |||
SO53460_15 | 3BD9-47C3-94 | PO19343112747 | 100 | 282 | 390 | 24 | 4 | 2023-11-02 | 2689.18 | 67.23 | 2023-10-21 | 4 | 713.08 | 1 | 2689.18 | 15 | SO53460 | 2023-10-28 | 215.13 | 2852.32 | 672.29 | |||
SO55282_34 | A72A-4D3A-BA | PO16298125578 | 100 | 287 | 487 | 599 | 4 | 2023-12-02 | 230.96 | 5.77 | 2023-11-20 | 7 | 20.57 | 1 | 230.96 | 34 | SO55282 | 2023-11-27 | 18.48 | 143.96 | 32.99 | |||
SO46979_1 | 5605-4AB3-96 | PO13601184435 | 100 | 283 | 286 | 310 | 3 | 2022-10-02 | 919.69 | 22.99 | 2022-09-20 | 5 | 170.14 | 1 | 919.69 | 1 | SO46979 | 2022-09-27 | 73.58 | 850.71 | 183.94 | |||
SO51766_6 | 1118-4A2A-80 | PO638122353 | 19 | 291 | 474 | 280 | 6 | 2023-10-02 | 167.98 | 4.20 | 2023-09-20 | 4 | 26.18 | 1 | 167.98 | 6 | SO51766 | 2023-09-27 | 13.44 | 104.71 | 41.99 | |||
SO47354_1 | 6E1C-48C6-89 | PO19401144959 | 19 | 291 | 329 | 173 | 6 | 2022-11-02 | 469.79 | 11.74 | 2022-10-21 | 1 | 486.71 | 1 | 469.79 | 1 | SO47354 | 2022-10-28 | 37.58 | 486.71 | 469.79 | |||
SO55263_4 | 10F0-498D-AE | PO11136189942 | 19 | 284 | 572 | 120 | 6 | 2023-12-02 | 445.41 | 11.14 | 2023-11-20 | 1 | 461.44 | 1 | 445.41 | 4 | SO55263 | 2023-11-27 | 35.63 | 461.44 | 445.41 | |||
SO53605_17 | 6D2A-486B-AC | PO5017132122 | 100 | 289 | 570 | 13 | 308 | 1 | 100.22 | 2023-11-02 | 668.12 | 14.20 | 2023-10-21 | 2 | 461.44 | 1 | 567.90 | 17 | SO53605 | 2023-10-28 | 45.43 | 922.89 | 334.06 | 0.15 |
SO47033_45 | 2797-46ED-BB | PO4727113716 | 100 | 286 | 423 | 343 | 1 | 2022-10-02 | 165.23 | 4.13 | 2022-09-20 | 1 | 122.27 | 1 | 165.23 | 45 | SO47033 | 2022-09-27 | 13.22 | 122.27 | 165.23 | |||
SO47714_1 | 884B-4F33-A1 | PO6235113773 | 100 | 281 | 433 | 431 | 3 | 2022-12-02 | 324.45 | 8.11 | 2022-11-20 | 1 | 300.12 | 1 | 324.45 | 1 | SO47714 | 2022-11-27 | 25.96 | 300.12 | 324.45 | |||
SO63291_28 | 9B60-437E-88 | PO8845151318 | 100 | 282 | 471 | 546 | 3 | 2024-04-03 | 228.60 | 5.72 | 2024-03-22 | 6 | 23.75 | 1 | 228.60 | 28 | SO63291 | 2024-03-29 | 18.29 | 142.49 | 38.10 | |||
SO47006_21 | 142D-4F23-BF | PO957186440 | 98 | 288 | 410 | 376 | 10 | 2022-10-02 | 109.34 | 2.73 | 2022-09-20 | 3 | 26.97 | 1 | 109.34 | 21 | SO47006 | 2022-09-27 | 8.75 | 80.91 | 36.45 | |||
SO61235_6 | CFAF-4A60-86 | PO8004115760 | 6 | 296 | 576 | 231 | 9 | 2024-03-03 | 5721.77 | 143.04 | 2024-02-20 | 4 | 1481.94 | 1 | 5721.77 | 6 | SO61235 | 2024-02-27 | 457.74 | 5927.75 | 1430.44 | |||
SO43912_1 | 69B6-46F8-A4 | PO7656175368 | 100 | 282 | 317 | 403 | 4 | 2021-10-02 | 874.79 | 21.87 | 2021-09-20 | 1 | 884.71 | 1 | 874.79 | 1 | SO43912 | 2021-09-27 | 69.98 | 884.71 | 874.79 | |||
SO44530_16 | 46CE-47C5-B3 | PO10440138648 | 100 | 283 | 220 | 623 | 3 | 2022-01-02 | 80.75 | 2.02 | 2021-12-21 | 4 | 12.03 | 1 | 80.75 | 16 | SO44530 | 2021-12-28 | 6.46 | 48.11 | 20.19 | |||
SO61204_12 | E810-4164-82 | PO15312134209 | 19 | 291 | 234 | 299 | 6 | 2024-03-03 | 179.96 | 4.50 | 2024-02-20 | 6 | 38.49 | 1 | 179.96 | 12 | SO61204 | 2024-02-27 | 14.40 | 230.95 | 29.99 | |||
SO57055_14 | 3CBC-4CD2-B1 | PO13369127604 | 100 | 292 | 584 | 391 | 7 | 2024-01-02 | 647.99 | 16.20 | 2023-12-21 | 2 | 343.65 | 1 | 647.99 | 14 | SO57055 | 2023-12-28 | 51.84 | 687.30 | 323.99 | |||
SO59027_24 | C142-4AAA-AB | PO6757122081 | 100 | 281 | 551 | 21 | 4 | 2024-02-01 | 158.43 | 3.96 | 2024-01-20 | 1 | 144.59 | 1 | 158.43 | 24 | SO59027 | 2024-01-27 | 12.67 | 144.59 | 158.43 | |||
SO47025_7 | 9A7F-452C-83 | PO3625180823 | 100 | 281 | 341 | 666 | 2 | 2022-10-02 | 939.59 | 23.49 | 2022-09-20 | 2 | 486.71 | 1 | 939.59 | 7 | SO47025 | 2022-09-27 | 75.17 | 973.41 | 469.79 | |||
SO49484_16 | B25F-4DF4-8E | PO18299142683 | 19 | 291 | 354 | 118 | 6 | 2023-05-02 | 1242.85 | 31.07 | 2023-04-20 | 1 | 1117.86 | 1 | 1242.85 | 16 | SO49484 | 2023-04-27 | 99.43 | 1117.86 | 1242.85 | |||
SO44317_8 | BE9B-42BA-87 | PO7859142280 | 100 | 287 | 270 | 221 | 4 | 2021-12-02 | 919.69 | 22.99 | 2021-11-20 | 5 | 181.49 | 1 | 919.69 | 8 | SO44317 | 2021-11-27 | 73.58 | 907.43 | 183.94 | |||
SO48312_2 | 2CA6-44B7-AA | PO16269124774 | 100 | 287 | 254 | 624 | 4 | 2023-02-01 | 551.81 | 13.80 | 2023-01-20 | 3 | 170.14 | 1 | 551.81 | 2 | SO48312 | 2023-01-27 | 44.15 | 510.43 | 183.94 | |||
SO48745_8 | CDB4-4FFB-87 | PO2494111050 | 100 | 281 | 464 | 184 | 4 | 2023-03-04 | 98.90 | 2.47 | 2023-02-20 | 7 | 9.71 | 1 | 98.90 | 8 | SO48745 | 2023-02-27 | 7.91 | 68.00 | 14.13 | |||
SO65155_11 | 154D-4EBA-85 | PO19633122185 | 100 | 287 | 511 | 149 | 3 | 2024-05-02 | 436.91 | 10.92 | 2024-04-20 | 2 | 199.38 | 1 | 436.91 | 11 | SO65155 | 2024-04-27 | 34.95 | 398.75 | 218.45 | |||
SO46648_42 | 2073-4051-9E | PO2494191557 | 100 | 283 | 230 | 184 | 4 | 2022-09-01 | 201.88 | 5.05 | 2022-08-20 | 7 | 29.08 | 1 | 201.88 | 42 | SO46648 | 2022-08-27 | 16.15 | 203.56 | 28.84 | |||
SO43917_8 | 9EDA-4CDB-A8 | PO8816199739 | 100 | 289 | 315 | 218 | 1 | 2021-10-02 | 4373.97 | 109.35 | 2021-09-20 | 5 | 884.71 | 1 | 4373.97 | 8 | SO43917 | 2021-09-27 | 349.92 | 4423.54 | 874.79 | |||
SO59057_4 | 95D3-4D4B-9D | PO7018154607 | 100 | 281 | 491 | 695 | 3 | 2024-02-01 | 129.58 | 3.24 | 2024-01-20 | 4 | 41.57 | 1 | 129.58 | 4 | SO59057 | 2024-01-27 | 10.37 | 166.29 | 32.39 | |||
SO53562_26 | 9FC2-4D08-A7 | PO8468156175 | 98 | 288 | 214 | 16 | 10 | 2023-11-02 | 62.98 | 1.57 | 2023-10-21 | 3 | 13.09 | 1 | 62.98 | 26 | SO53562 | 2023-10-28 | 5.04 | 39.26 | 20.99 | |||
SO63209_24 | 1C23-4681-BF | PO11223142410 | 100 | 292 | 363 | 632 | 7 | 2024-04-03 | 2753.99 | 68.85 | 2024-03-22 | 2 | 1251.98 | 1 | 2753.99 | 24 | SO63209 | 2024-03-29 | 220.32 | 2503.96 | 1376.99 | |||
SO55249_48 | 0527-4C9D-BA | PO13688172507 | 100 | 282 | 237 | 475 | 4 | 2023-12-02 | 119.98 | 3.00 | 2023-11-20 | 4 | 38.49 | 1 | 119.98 | 48 | SO55249 | 2023-11-27 | 9.60 | 153.97 | 29.99 | |||
SO69442_11 | 9833-459C-A2 | PO11658194725 | 100 | 283 | 355 | 233 | 2 | 2024-07-02 | 2783.99 | 69.60 | 2024-06-20 | 2 | 1265.62 | 1 | 2783.99 | 11 | SO69442 | 2024-06-27 | 222.72 | 2531.24 | 1391.99 | |||
SO57067_24 | 08F2-42FC-BE | PO11368183380 | 36 | 295 | 488 | 687 | 8 | 2024-01-02 | 194.36 | 4.86 | 2023-12-21 | 6 | 41.57 | 1 | 194.36 | 24 | SO57067 | 2023-12-28 | 15.55 | 249.43 | 32.39 | |||
SO50225_33 | 6F8E-49A2-A5 | PO12702153410 | 100 | 292 | 362 | 175 | 7 | 2023-07-02 | 2458.92 | 61.47 | 2023-06-20 | 2 | 1105.81 | 1 | 2458.92 | 33 | SO50225 | 2023-06-27 | 196.71 | 2211.62 | 1229.46 | |||
SO49090_16 | BA90-48D0-89 | PO11571148651 | 100 | 285 | 333 | 512 | 5 | 2023-04-04 | 1409.38 | 35.23 | 2023-03-23 | 3 | 486.71 | 1 | 1409.38 | 16 | SO49090 | 2023-03-30 | 112.75 | 1460.12 | 469.79 | |||
SO49837_13 | C136-4536-9D | PO12412160791 | 100 | 281 | 321 | 670 | 3 | 2023-06-02 | 1879.18 | 46.98 | 2023-05-21 | 4 | 486.71 | 1 | 1879.18 | 13 | SO49837 | 2023-05-28 | 150.33 | 1946.83 | 469.79 | |||
SO61173_25 | 6B8D-47B8-8E | PO522171689 | 100 | 285 | 222 | 676 | 5 | 2024-03-03 | 20.99 | 0.52 | 2024-02-20 | 1 | 13.09 | 1 | 20.99 | 25 | SO61173 | 2024-02-27 | 1.68 | 13.09 | 20.99 | |||
SO69558_6 | 0B27-4F3C-97 | PO8642129578 | 98 | 288 | 506 | 520 | 10 | 2024-07-02 | 200.05 | 5.00 | 2024-06-20 | 1 | 199.85 | 1 | 200.05 | 6 | SO69558 | 2024-06-27 | 16.00 | 199.85 | 200.05 |
Generated 2024-09-19 19:05:50.557 UTC