[ROOT] dt FactResellerSale < WHERE DimSalesTerritoryId EQ '4' > SKIP 0 SHUFFLE < SKIP 1095 > < 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 |
---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
SO71896_14 | A37A-4B16-B0 | PO4640135042 | 100 | 287 | 511 | 648 | 4 | 2024-08-03 | 655.36 | 16.38 | 2024-07-22 | 3 | 199.38 | 1 | 655.36 | 14 | SO71896 | 2024-07-29 | 52.43 | 598.13 | 218.45 | |||
SO47018_8 | E622-43B1-98 | PO2523197473 | 100 | 287 | 331 | 167 | 4 | 2022-10-03 | 1409.38 | 35.23 | 2022-09-21 | 3 | 486.71 | 1 | 1409.38 | 8 | SO47018 | 2022-09-28 | 112.75 | 1460.12 | 469.79 | |||
SO50289_42 | 0809-4DE4-93 | PO3480117331 | 100 | 281 | 331 | 436 | 4 | 2023-07-03 | 1409.38 | 35.23 | 2023-06-21 | 3 | 486.71 | 1 | 1409.38 | 42 | SO50289 | 2023-06-28 | 112.75 | 1460.12 | 469.79 | |||
SO46364_6 | BC3C-4FE8-AC | PO3248115921 | 100 | 282 | 215 | 366 | 4 | 2022-08-03 | 80.75 | 2.02 | 2022-07-22 | 4 | 12.03 | 1 | 80.75 | 6 | SO46364 | 2022-07-29 | 6.46 | 48.11 | 20.19 | |||
SO69536_1 | 9646-48B3-9E | PO3654177498 | 100 | 281 | 512 | 435 | 4 | 2024-07-03 | 436.91 | 10.92 | 2024-06-21 | 2 | 199.38 | 1 | 436.91 | 1 | SO69536 | 2024-06-28 | 34.95 | 398.75 | 218.45 | |||
SO46964_40 | B3E6-43CC-A2 | PO15689139014 | 100 | 283 | 403 | 328 | 4 | 2022-10-03 | 97.18 | 2.43 | 2022-09-21 | 4 | 17.98 | 1 | 97.18 | 40 | SO46964 | 2022-09-28 | 7.77 | 71.91 | 24.29 | |||
SO65293_2 | A09F-4D84-9D | PO174134614 | 100 | 282 | 583 | 277 | 4 | 2024-05-03 | 3061.78 | 76.54 | 2024-04-21 | 3 | 1082.51 | 1 | 3061.78 | 2 | SO65293 | 2024-04-28 | 244.94 | 3247.53 | 1020.59 | |||
SO49104_25 | 7F8C-4702-BB | PO11745119484 | 100 | 282 | 385 | 97 | 4 | 2023-04-05 | 1200.53 | 30.01 | 2023-03-24 | 2 | 605.65 | 1 | 1200.53 | 25 | SO49104 | 2023-03-31 | 96.04 | 1211.30 | 600.26 | |||
SO55303_1 | 5C9C-4B35-B8 | PO5626137276 | 100 | 281 | 545 | 166 | 4 | 2023-12-03 | 48.59 | 1.21 | 2023-11-21 | 2 | 17.98 | 1 | 48.59 | 1 | SO55303 | 2023-11-28 | 3.89 | 35.96 | 24.29 | |||
SO51153_25 | AC8D-4688-81 | PO5626119823 | 100 | 281 | 520 | 166 | 4 | 2023-09-02 | 63.17 | 1.58 | 2023-08-21 | 2 | 23.37 | 1 | 63.17 | 25 | SO51153 | 2023-08-28 | 5.05 | 46.74 | 31.58 | |||
SO53583_2 | 582E-4A53-9A | PO5597118655 | 100 | 281 | 598 | 75 | 4 | 2023-11-03 | 323.99 | 8.10 | 2023-10-22 | 1 | 294.58 | 1 | 323.99 | 2 | SO53583 | 2023-10-29 | 25.92 | 294.58 | 323.99 | |||
SO46341_9 | 7717-4086-86 | PO15138183971 | 100 | 283 | 314 | 93 | 4 | 2022-08-03 | 4293.92 | 107.35 | 2022-07-22 | 2 | 2171.29 | 1 | 4293.92 | 9 | SO46341 | 2022-07-29 | 343.51 | 4342.59 | 2146.96 | |||
SO46964_48 | B3E6-43CC-A2 | PO15689139014 | 100 | 283 | 381 | 328 | 4 | 2022-10-03 | 3001.31 | 75.03 | 2022-09-21 | 5 | 605.65 | 1 | 3001.31 | 48 | SO46964 | 2022-09-28 | 240.11 | 3028.25 | 600.26 | |||
SO47422_36 | 9D8D-4481-B6 | PO3915123127 | 100 | 283 | 439 | 130 | 4 | 2022-11-03 | 1561.64 | 39.04 | 2022-10-22 | 2 | 722.26 | 1 | 1561.64 | 36 | SO47422 | 2022-10-29 | 124.93 | 1444.51 | 780.82 | |||
SO49457_1 | AB73-4D64-A7 | PO15979195348 | 100 | 282 | 399 | 349 | 4 | 2023-05-03 | 67.55 | 1.69 | 2023-04-21 | 2 | 24.99 | 1 | 67.55 | 1 | SO49457 | 2023-04-28 | 5.40 | 49.99 | 33.77 | |||
SO45299_3 | 0D55-4B85-AD | PO12557162961 | 100 | 282 | 232 | 240 | 4 | 2022-04-05 | 57.68 | 1.44 | 2022-03-24 | 2 | 31.72 | 1 | 57.68 | 3 | SO45299 | 2022-03-31 | 4.61 | 63.45 | 28.84 | |||
SO71881_39 | 8EDF-4F9F-97 | PO6757112103 | 100 | 281 | 501 | 21 | 4 | 2024-08-03 | 72.88 | 1.82 | 2024-07-22 | 1 | 53.93 | 1 | 72.88 | 39 | SO71881 | 2024-07-29 | 5.83 | 53.93 | 72.88 | |||
SO67279_18 | 5395-4C5C-A0 | PO12528190770 | 100 | 282 | 565 | 331 | 4 | 2024-06-03 | 1781.64 | 44.54 | 2024-05-22 | 4 | 461.44 | 1 | 1781.64 | 18 | SO67279 | 2024-05-29 | 142.53 | 1845.78 | 445.41 | |||
SO44755_22 | 3B0A-428C-99 | PO15167120207 | 100 | 283 | 223 | 273 | 4 | 2022-02-02 | 5.19 | 0.13 | 2022-01-21 | 1 | 5.71 | 1 | 5.19 | 22 | SO44755 | 2022-01-28 | 0.41 | 5.71 | 5.19 | |||
SO57034_8 | 57D0-46D3-B7 | PO15689142548 | 100 | 281 | 434 | 328 | 4 | 2024-01-03 | 1070.69 | 26.77 | 2023-12-22 | 3 | 360.94 | 1 | 1070.69 | 8 | SO57034 | 2023-12-29 | 85.66 | 1082.83 | 356.90 | |||
SO45072_2 | FFF9-4C3E-A9 | PO6409119280 | 100 | 283 | 332 | 292 | 4 | 2022-03-05 | 838.92 | 20.97 | 2022-02-21 | 2 | 413.15 | 1 | 838.92 | 2 | SO45072 | 2022-02-28 | 67.11 | 826.29 | 419.46 | |||
SO61227_10 | 9006-4208-8F | PO10730172247 | 100 | 287 | 386 | 491 | 4 | 2024-03-04 | 3361.47 | 84.04 | 2024-02-21 | 5 | 713.08 | 1 | 3361.47 | 10 | SO61227 | 2024-02-28 | 268.92 | 3565.40 | 672.29 | |||
SO45799_21 | 4DE8-4B9B-A1 | PO10730195041 | 100 | 287 | 332 | 491 | 4 | 2022-06-03 | 838.92 | 20.97 | 2022-05-22 | 2 | 413.15 | 1 | 838.92 | 21 | SO45799 | 2022-05-29 | 67.11 | 826.29 | 419.46 | |||
SO49841_43 | 35A1-40DC-99 | PO10817181706 | 100 | 287 | 460 | 203 | 4 | 2023-06-03 | 215.98 | 5.40 | 2023-05-22 | 4 | 37.12 | 1 | 215.98 | 43 | SO49841 | 2023-05-29 | 17.28 | 148.48 | 53.99 | |||
SO47369_23 | B6B6-442B-8B | PO16472118462 | 100 | 287 | 213 | 239 | 4 | 2022-11-03 | 201.87 | 5.05 | 2022-10-22 | 10 | 13.88 | 1 | 201.87 | 23 | SO47369 | 2022-10-29 | 16.15 | 138.78 | 20.19 | |||
SO48378_39 | 2FD7-4721-9D | PO6786131738 | 100 | 283 | 459 | 3 | 4 | 2023-02-02 | 107.99 | 2.70 | 2023-01-21 | 2 | 37.12 | 1 | 107.99 | 39 | SO48378 | 2023-01-28 | 8.64 | 74.24 | 53.99 | |||
SO48740_18 | 158B-4BBF-9F | PO551143768 | 100 | 281 | 375 | 4 | 4 | 2023-03-05 | 9162.56 | 229.06 | 2023-02-21 | 7 | 1320.68 | 1 | 9162.56 | 18 | SO48740 | 2023-02-28 | 733.01 | 9244.79 | 1308.94 | |||
SO47676_6 | 5DD7-4A1E-9B | PO13659142296 | 100 | 272 | 419 | 437 | 4 | 2022-12-03 | 52.65 | 1.32 | 2022-11-21 | 1 | 38.96 | 1 | 52.65 | 6 | SO47676 | 2022-11-28 | 4.21 | 38.96 | 52.65 | |||
SO51825_40 | E395-4F72-84 | PO6525184188 | 100 | 281 | 516 | 345 | 4 | 2023-10-03 | 234.84 | 5.87 | 2023-09-21 | 10 | 17.38 | 1 | 234.84 | 40 | SO51825 | 2023-09-28 | 18.79 | 173.78 | 23.48 | |||
SO46942_5 | B18D-4253-81 | PO18647164826 | 100 | 282 | 428 | 583 | 4 | 2022-10-03 | 209.26 | 5.23 | 2022-09-21 | 1 | 185.82 | 1 | 209.26 | 5 | SO46942 | 2022-09-28 | 16.74 | 185.82 | 209.26 | |||
SO45516_3 | 3473-43AB-AE | PO261128364 | 100 | 283 | 334 | 647 | 4 | 2022-05-03 | 419.46 | 10.49 | 2022-04-21 | 1 | 413.15 | 1 | 419.46 | 3 | SO45516 | 2022-04-28 | 33.56 | 413.15 | 419.46 | |||
SO48378_13 | 2FD7-4721-9D | PO6786131738 | 100 | 283 | 457 | 3 | 4 | 2023-02-02 | 269.96 | 6.75 | 2023-01-21 | 6 | 30.93 | 1 | 269.96 | 13 | SO48378 | 2023-01-28 | 21.60 | 185.60 | 44.99 | |||
SO46625_47 | 361B-4CAF-A2 | PO13688113829 | 100 | 282 | 362 | 475 | 4 | 2022-09-02 | 1229.46 | 30.74 | 2022-08-21 | 1 | 1105.81 | 1 | 1229.46 | 47 | SO46625 | 2022-08-28 | 98.36 | 1105.81 | 1229.46 | |||
SO69411_6 | E0BB-44D1-83 | PO15921144493 | 100 | 287 | 482 | 77 | 4 | 2024-07-03 | 48.55 | 1.21 | 2024-06-21 | 9 | 3.36 | 1 | 48.55 | 6 | SO69411 | 2024-06-28 | 3.88 | 30.26 | 5.39 | |||
SO67274_25 | EAF2-43E4-AB | PO13659172775 | 100 | 287 | 533 | 437 | 4 | 2024-06-03 | 299.75 | 7.49 | 2024-05-22 | 2 | 136.79 | 1 | 299.75 | 25 | SO67274 | 2024-05-29 | 23.98 | 273.57 | 149.87 | |||
SO49523_22 | 852E-47A8-A9 | PO3915144057 | 100 | 281 | 327 | 130 | 4 | 2023-05-03 | 939.59 | 23.49 | 2023-04-21 | 2 | 486.71 | 1 | 939.59 | 22 | SO49523 | 2023-04-28 | 75.17 | 973.41 | 469.79 | |||
SO69536_30 | 9646-48B3-9E | PO3654177498 | 100 | 281 | 588 | 435 | 4 | 2024-07-03 | 923.39 | 23.08 | 2024-06-21 | 2 | 419.78 | 1 | 923.39 | 30 | SO69536 | 2024-06-28 | 73.87 | 839.56 | 461.69 | |||
SO48016_7 | 0FF6-4F4B-B4 | PO11745112366 | 100 | 282 | 335 | 97 | 4 | 2023-01-03 | 2348.97 | 58.72 | 2022-12-22 | 5 | 486.71 | 1 | 2348.97 | 7 | SO48016 | 2022-12-29 | 187.92 | 2433.53 | 469.79 | |||
SO47417_24 | 1CE8-4651-A9 | PO2697165938 | 100 | 282 | 305 | 187 | 4 | 2022-11-03 | 1472.29 | 36.81 | 2022-10-22 | 2 | 653.70 | 1 | 1472.29 | 24 | SO47417 | 2022-10-29 | 117.78 | 1307.39 | 736.15 | |||
SO58984_3 | 5D72-43BF-AB | PO16153135798 | 100 | 282 | 572 | 186 | 4 | 2024-02-02 | 445.41 | 11.14 | 2024-01-21 | 1 | 461.44 | 1 | 445.41 | 3 | SO58984 | 2024-01-28 | 35.63 | 461.44 | 445.41 | |||
SO63285_27 | 6316-44BB-8E | PO3480176259 | 100 | 281 | 388 | 436 | 4 | 2024-04-04 | 2689.18 | 67.23 | 2024-03-23 | 4 | 713.08 | 1 | 2689.18 | 27 | SO63285 | 2024-03-30 | 215.13 | 2852.32 | 672.29 | |||
SO51090_65 | EBDE-4A71-8E | PO13688110947 | 100 | 282 | 225 | 3 | 475 | 4 | 4.45 | 2023-09-02 | 89.00 | 2.11 | 2023-08-21 | 18 | 6.92 | 1 | 84.55 | 65 | SO51090 | 2023-08-28 | 6.76 | 124.60 | 4.94 | 0.05 |
SO71848_11 | 7082-4BF5-AB | PO18763153352 | 100 | 287 | 560 | 59 | 4 | 2024-08-03 | 728.91 | 18.22 | 2024-07-22 | 1 | 755.15 | 1 | 728.91 | 11 | SO71848 | 2024-07-29 | 58.31 | 755.15 | 728.91 | |||
SO71902_45 | AEC9-4070-9D | PO5539125166 | 100 | 282 | 309 | 61 | 4 | 2024-08-03 | 5730.90 | 143.27 | 2024-07-22 | 7 | 747.20 | 1 | 5730.90 | 45 | SO71902 | 2024-07-29 | 458.47 | 5230.40 | 818.70 | |||
SO51836_20 | 8AA7-498C-8C | PO6351139034 | 100 | 281 | 581 | 255 | 4 | 2023-10-03 | 1020.59 | 25.51 | 2023-09-21 | 1 | 1082.51 | 1 | 1020.59 | 20 | SO51836 | 2023-09-28 | 81.65 | 1082.51 | 1020.59 | |||
SO53546_17 | 57CF-465D-B2 | PO16269114010 | 100 | 287 | 384 | 624 | 4 | 2023-11-03 | 1344.59 | 33.61 | 2023-10-22 | 2 | 713.08 | 1 | 1344.59 | 17 | SO53546 | 2023-10-29 | 107.57 | 1426.16 | 672.29 | |||
SO53470_11 | 932B-41E0-AF | PO17052111209 | 100 | 282 | 561 | 14 | 420 | 4 | 381.45 | 2023-11-03 | 1907.26 | 38.15 | 2023-10-22 | 2 | 1481.94 | 1 | 1525.80 | 11 | SO53470 | 2023-10-29 | 122.06 | 2963.88 | 953.63 | 0.20 |
SO57131_20 | 635E-4BF2-B9 | PO4611148036 | 100 | 287 | 563 | 131 | 4 | 2024-01-03 | 1430.44 | 35.76 | 2023-12-22 | 1 | 1481.94 | 1 | 1430.44 | 20 | SO57131 | 2023-12-29 | 114.44 | 1481.94 | 1430.44 | |||
SO46970_33 | 01AF-420A-B9 | PO15196114472 | 100 | 282 | 424 | 258 | 4 | 2022-10-03 | 856.94 | 21.42 | 2022-09-21 | 4 | 158.53 | 1 | 856.94 | 33 | SO46970 | 2022-09-28 | 68.56 | 634.14 | 214.24 | |||
SO43892_11 | 0D3C-4E1F-9C | PO2523117473 | 100 | 287 | 324 | 167 | 4 | 2021-10-03 | 1677.84 | 41.95 | 2021-09-21 | 4 | 413.15 | 1 | 1677.84 | 11 | SO43892 | 2021-09-28 | 134.23 | 1652.59 | 419.46 | |||
SO46648_42 | 2073-4051-9E | PO2494191557 | 100 | 283 | 230 | 184 | 4 | 2022-09-02 | 201.88 | 5.05 | 2022-08-21 | 7 | 29.08 | 1 | 201.88 | 42 | SO46648 | 2022-08-28 | 16.15 | 203.56 | 28.84 | |||
SO69441_21 | F156-4EE0-B0 | PO11745165450 | 100 | 282 | 546 | 97 | 4 | 2024-07-03 | 149.02 | 3.73 | 2024-06-21 | 4 | 27.57 | 1 | 149.02 | 21 | SO69441 | 2024-06-28 | 11.92 | 110.27 | 37.25 | |||
SO44521_1 | E46D-4692-AC | PO12557171689 | 100 | 282 | 320 | 240 | 4 | 2022-01-03 | 419.46 | 10.49 | 2021-12-22 | 1 | 413.15 | 1 | 419.46 | 1 | SO44521 | 2021-12-29 | 33.56 | 413.15 | 419.46 | |||
SO69412_17 | 14B1-47FE-BF | PO15689112657 | 100 | 281 | 386 | 328 | 4 | 2024-07-03 | 2016.88 | 50.42 | 2024-06-21 | 3 | 713.08 | 1 | 2016.88 | 17 | SO69412 | 2024-06-28 | 161.35 | 2139.24 | 672.29 | |||
SO46057_22 | 6F2B-45A4-9C | PO12499164653 | 100 | 282 | 342 | 78 | 4 | 2022-07-03 | 1258.38 | 31.46 | 2022-06-21 | 3 | 413.15 | 1 | 1258.38 | 22 | SO46057 | 2022-06-28 | 100.67 | 1239.44 | 419.46 | |||
SO46988_16 | 2D2E-4EC3-AC | PO12499171502 | 100 | 282 | 329 | 78 | 4 | 2022-10-03 | 3288.56 | 82.21 | 2022-09-21 | 7 | 486.71 | 1 | 3288.56 | 16 | SO46988 | 2022-09-28 | 263.08 | 3406.95 | 469.79 | |||
SO45332_1 | AD0B-49A0-A5 | PO6351110306 | 100 | 283 | 315 | 255 | 4 | 2022-04-05 | 874.79 | 21.87 | 2022-03-24 | 1 | 884.71 | 1 | 874.79 | 1 | SO45332 | 2022-03-31 | 69.98 | 884.71 | 874.79 | |||
SO44095_3 | 97A5-4FCA-88 | PO14964184959 | 100 | 287 | 347 | 581 | 4 | 2021-11-03 | 8159.98 | 204.00 | 2021-10-22 | 4 | 1912.15 | 1 | 8159.98 | 3 | SO44095 | 2021-10-29 | 652.80 | 7648.62 | 2039.99 | |||
SO55282_15 | A72A-4D3A-BA | PO16298125578 | 100 | 287 | 569 | 599 | 4 | 2023-12-03 | 2672.46 | 66.81 | 2023-11-21 | 6 | 461.44 | 1 | 2672.46 | 15 | SO55282 | 2023-11-28 | 213.80 | 2768.67 | 445.41 | |||
SO57138_13 | CD80-4144-8A | PO5684168325 | 100 | 282 | 357 | 385 | 4 | 2024-01-03 | 2783.99 | 69.60 | 2023-12-22 | 2 | 1265.62 | 1 | 2783.99 | 13 | SO57138 | 2023-12-29 | 222.72 | 2531.24 | 1391.99 | |||
SO46057_15 | 6F2B-45A4-9C | PO12499164653 | 100 | 282 | 264 | 78 | 4 | 2022-07-03 | 183.94 | 4.60 | 2022-06-21 | 1 | 181.49 | 1 | 183.94 | 15 | SO46057 | 2022-06-28 | 14.72 | 181.49 | 183.94 | |||
SO63285_24 | 6316-44BB-8E | PO3480176259 | 100 | 281 | 482 | 436 | 4 | 2024-04-04 | 53.94 | 1.35 | 2024-03-23 | 10 | 3.36 | 1 | 53.94 | 24 | SO63285 | 2024-03-30 | 4.32 | 33.62 | 5.39 |
Generated 2024-09-20 10:25:36.065 UTC