[ROOT] dt FactResellerSale < WHERE DimSalesTerritoryId EQ '4' > SHUFFLE < SKIP 502 > < TAKE 56 >
56 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 |
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
| SO61227_13 | 9006-4208-8F | PO10730172247 | 100 | 287 | 605 | 491 | 4 | 2024-04-27 | 2591.95 | 64.80 | 2024-04-15 | 8 | 343.65 | 1 | 2591.95 | 13 | SO61227 | 2024-04-22 | 207.36 | 2749.20 | 323.99 | |||
| SO50208_7 | 6993-49B4-8B | PO15689114248 | 100 | 281 | 327 | 328 | 4 | 2023-08-26 | 3288.56 | 82.21 | 2023-08-14 | 7 | 486.71 | 1 | 3288.56 | 7 | SO50208 | 2023-08-21 | 263.08 | 3406.95 | 469.79 | |||
| SO48769_9 | A39E-4380-A6 | PO7859190388 | 100 | 287 | 448 | 221 | 4 | 2023-04-28 | 35.98 | 0.90 | 2023-04-16 | 3 | 8.25 | 1 | 35.98 | 9 | SO48769 | 2023-04-23 | 2.88 | 24.74 | 11.99 | |||
| SO51714_42 | D33A-4EAE-B1 | PO15689195197 | 100 | 281 | 372 | 328 | 4 | 2023-11-26 | 7330.05 | 183.25 | 2023-11-14 | 5 | 1554.95 | 1 | 7330.05 | 42 | SO51714 | 2023-11-21 | 586.40 | 7774.74 | 1466.01 | |||
| SO46970_39 | 01AF-420A-B9 | PO15196114472 | 100 | 282 | 370 | 258 | 4 | 2022-11-26 | 2932.02 | 73.30 | 2022-11-14 | 2 | 1518.79 | 1 | 2932.02 | 39 | SO46970 | 2022-11-21 | 234.56 | 3037.57 | 1466.01 | |||
| SO65160_24 | 9375-44FE-94 | PO19343172976 | 100 | 282 | 471 | 24 | 4 | 2024-06-26 | 304.80 | 7.62 | 2024-06-14 | 8 | 23.75 | 1 | 304.80 | 24 | SO65160 | 2024-06-21 | 24.38 | 189.99 | 38.10 | |||
| SO48048_14 | B414-46CB-BA | PO3480117933 | 100 | 283 | 329 | 436 | 4 | 2023-02-26 | 2818.76 | 70.47 | 2023-02-14 | 6 | 486.71 | 1 | 2818.76 | 14 | SO48048 | 2023-02-21 | 225.50 | 2920.24 | 469.79 | |||
| SO51856_17 | E170-419C-92 | PO3654183134 | 100 | 281 | 361 | 435 | 4 | 2023-11-26 | 2753.99 | 68.85 | 2023-11-14 | 2 | 1251.98 | 1 | 2753.99 | 17 | SO51856 | 2023-11-21 | 220.32 | 2503.96 | 1376.99 | |||
| SO69501_16 | 8A65-4926-A6 | PO6525182870 | 100 | 281 | 559 | 345 | 4 | 2024-08-26 | 36.43 | 0.91 | 2024-08-14 | 3 | 8.99 | 1 | 36.43 | 16 | SO69501 | 2024-08-21 | 2.91 | 26.96 | 12.14 | |||
| SO48043_28 | BA6F-4F1F-B7 | PO2523167437 | 100 | 287 | 271 | 167 | 4 | 2023-02-26 | 607.00 | 15.17 | 2023-02-14 | 3 | 187.16 | 1 | 607.00 | 28 | SO48043 | 2023-02-21 | 48.56 | 561.47 | 202.33 | |||
| SO55276_15 | 81AA-41E5-B0 | PO2755182998 | 100 | 282 | 500 | 2 | 205 | 4 | 128.10 | 2024-01-26 | 6404.95 | 156.92 | 2024-01-14 | 11 | 601.74 | 1 | 6276.85 | 15 | SO55276 | 2024-01-21 | 502.15 | 6619.18 | 582.27 | 0.02 |
| SO53606_47 | 6A19-463C-B7 | PO5539128997 | 100 | 282 | 524 | 61 | 4 | 2023-12-27 | 316.86 | 7.92 | 2023-12-15 | 2 | 144.59 | 1 | 316.86 | 47 | SO53606 | 2023-12-22 | 25.35 | 289.19 | 158.43 | |||
| SO51836_3 | 8AA7-498C-8C | PO6351139034 | 100 | 281 | 287 | 255 | 4 | 2023-11-26 | 607.00 | 15.17 | 2023-11-14 | 3 | 204.63 | 1 | 607.00 | 3 | SO51836 | 2023-11-21 | 48.56 | 613.88 | 202.33 | |||
| SO49125_3 | D58B-4B43-AA | PO3654156335 | 100 | 281 | 409 | 435 | 4 | 2023-05-29 | 418.51 | 10.46 | 2023-05-17 | 2 | 185.82 | 1 | 418.51 | 3 | SO49125 | 2023-05-24 | 33.48 | 371.64 | 209.26 | |||
| SO63285_15 | 6316-44BB-8E | PO3480176259 | 100 | 281 | 217 | 436 | 4 | 2024-05-28 | 83.98 | 2.10 | 2024-05-16 | 4 | 13.09 | 1 | 83.98 | 15 | SO63285 | 2024-05-23 | 6.72 | 52.35 | 20.99 | |||
| SO48295_32 | 12F9-466B-B0 | PO19343197973 | 100 | 282 | 422 | 24 | 4 | 2023-03-28 | 337.70 | 8.44 | 2023-03-16 | 5 | 49.98 | 1 | 337.70 | 32 | SO48295 | 2023-03-23 | 27.02 | 249.89 | 67.54 | |||
| SO44557_11 | 2D19-4C49-B1 | PO6351122593 | 100 | 283 | 330 | 255 | 4 | 2022-02-26 | 419.46 | 10.49 | 2022-02-14 | 1 | 413.15 | 1 | 419.46 | 11 | SO44557 | 2022-02-21 | 33.56 | 413.15 | 419.46 | |||
| SO46370_10 | 7E21-402F-BF | PO4640115047 | 100 | 287 | 345 | 7 | 648 | 4 | 1190.00 | 2022-09-26 | 3399.99 | 55.25 | 2022-09-14 | 4 | 1912.15 | 1 | 2209.99 | 10 | SO46370 | 2022-09-21 | 176.80 | 7648.62 | 850.00 | 0.35 |
| SO48012_34 | AF9F-4901-9E | PO12499156458 | 100 | 282 | 459 | 78 | 4 | 2023-02-26 | 377.96 | 9.45 | 2023-02-14 | 7 | 37.12 | 1 | 377.96 | 34 | SO48012 | 2023-02-21 | 30.24 | 259.85 | 53.99 | |||
| SO50289_26 | 0809-4DE4-93 | PO3480117331 | 100 | 281 | 230 | 436 | 4 | 2023-08-26 | 28.84 | 0.72 | 2023-08-14 | 1 | 29.08 | 1 | 28.84 | 26 | SO50289 | 2023-08-21 | 2.31 | 29.08 | 28.84 | |||
| SO69536_16 | 9646-48B3-9E | PO3654177498 | 100 | 281 | 475 | 435 | 4 | 2024-08-26 | 41.99 | 1.05 | 2024-08-14 | 1 | 26.18 | 1 | 41.99 | 16 | SO69536 | 2024-08-21 | 3.36 | 26.18 | 41.99 | |||
| SO48080_12 | 4DC7-4772-87 | PO7656157590 | 100 | 282 | 375 | 403 | 4 | 2023-02-26 | 3926.81 | 98.17 | 2023-02-14 | 3 | 1320.68 | 1 | 3926.81 | 12 | SO48080 | 2023-02-21 | 314.15 | 3962.05 | 1308.94 | |||
| SO48780_13 | F139-41F4-83 | PO5626121558 | 100 | 281 | 333 | 166 | 4 | 2023-04-28 | 3288.56 | 82.21 | 2023-04-16 | 7 | 486.71 | 1 | 3288.56 | 13 | SO48780 | 2023-04-23 | 263.08 | 3406.95 | 469.79 | |||
| SO69528_28 | 2644-4747-86 | PO6438163496 | 100 | 272 | 590 | 309 | 4 | 2024-08-26 | 461.69 | 11.54 | 2024-08-14 | 1 | 419.78 | 1 | 461.69 | 28 | SO69528 | 2024-08-21 | 36.94 | 419.78 | 461.69 | |||
| SO51773_11 | 14B1-48BF-A0 | PO2523163173 | 100 | 287 | 376 | 167 | 4 | 2023-11-26 | 2932.02 | 73.30 | 2023-11-14 | 2 | 1554.95 | 1 | 2932.02 | 11 | SO51773 | 2023-11-21 | 234.56 | 3109.90 | 1466.01 | |||
| SO61188_10 | 0CFA-4338-90 | PO12528143455 | 100 | 282 | 574 | 331 | 4 | 2024-04-27 | 7152.21 | 178.81 | 2024-04-15 | 5 | 1481.94 | 1 | 7152.21 | 10 | SO61188 | 2024-04-22 | 572.18 | 7409.69 | 1430.44 | |||
| SO51095_2 | 9E89-4758-94 | PO14413190533 | 100 | 287 | 546 | 383 | 4 | 2023-10-26 | 74.51 | 1.86 | 2023-10-14 | 2 | 27.57 | 1 | 74.51 | 2 | SO51095 | 2023-10-21 | 5.96 | 55.14 | 37.25 | |||
| SO47016_6 | 205E-4F0A-81 | PO2320157867 | 100 | 282 | 257 | 529 | 4 | 2022-11-26 | 735.75 | 18.39 | 2022-11-14 | 4 | 170.14 | 1 | 735.75 | 6 | SO47016 | 2022-11-21 | 58.86 | 680.57 | 183.94 | |||
| SO47369_50 | B6B6-442B-8B | PO16472118462 | 100 | 287 | 327 | 2 | 239 | 4 | 127.16 | 2022-12-27 | 6357.88 | 155.77 | 2022-12-15 | 14 | 486.71 | 1 | 6230.72 | 50 | SO47369 | 2022-12-22 | 498.46 | 6813.89 | 454.13 | 0.02 |
| SO48745_21 | CDB4-4FFB-87 | PO2494111050 | 100 | 281 | 393 | 184 | 4 | 2023-04-28 | 413.08 | 10.33 | 2023-04-16 | 3 | 101.89 | 1 | 413.08 | 21 | SO48745 | 2023-04-23 | 33.05 | 305.68 | 137.69 | |||
| SO53606_35 | 6A19-463C-B7 | PO5539128997 | 100 | 282 | 598 | 61 | 4 | 2023-12-27 | 647.99 | 16.20 | 2023-12-15 | 2 | 294.58 | 1 | 647.99 | 35 | SO53606 | 2023-12-22 | 51.84 | 589.16 | 323.99 | |||
| SO57128_7 | 52E0-4277-80 | PO6525176590 | 100 | 281 | 355 | 345 | 4 | 2024-02-26 | 1391.99 | 34.80 | 2024-02-14 | 1 | 1265.62 | 1 | 1391.99 | 7 | SO57128 | 2024-02-21 | 111.36 | 1265.62 | 1391.99 | |||
| SO59036_4 | 4F4B-4F1B-86 | PO3886177724 | 100 | 281 | 434 | 165 | 4 | 2024-03-27 | 356.90 | 8.92 | 2024-03-15 | 1 | 360.94 | 1 | 356.90 | 4 | SO59036 | 2024-03-22 | 28.55 | 360.94 | 356.90 | |||
| SO45810_5 | 2A16-4AA7-89 | PO5626186069 | 100 | 283 | 324 | 166 | 4 | 2022-07-27 | 838.92 | 20.97 | 2022-07-15 | 2 | 413.15 | 1 | 838.92 | 5 | SO45810 | 2022-07-22 | 67.11 | 826.29 | 419.46 | |||
| SO49831_16 | 8BCC-466B-AB | PO13688123267 | 100 | 282 | 224 | 475 | 4 | 2023-07-27 | 41.49 | 1.04 | 2023-07-15 | 8 | 5.23 | 1 | 41.49 | 16 | SO49831 | 2023-07-22 | 3.32 | 41.84 | 5.19 | |||
| SO71881_27 | 8EDF-4F9F-97 | PO6757112103 | 100 | 281 | 558 | 21 | 4 | 2024-09-26 | 242.99 | 6.07 | 2024-09-14 | 1 | 179.82 | 1 | 242.99 | 27 | SO71881 | 2024-09-21 | 19.44 | 179.82 | 242.99 | |||
| SO57144_19 | 074E-478C-99 | PO3799111077 | 100 | 282 | 355 | 312 | 4 | 2024-02-26 | 5567.98 | 139.20 | 2024-02-14 | 4 | 1265.62 | 1 | 5567.98 | 19 | SO57144 | 2024-02-21 | 445.44 | 5062.48 | 1391.99 | |||
| SO47369_21 | B6B6-442B-8B | PO16472118462 | 100 | 287 | 441 | 239 | 4 | 2022-12-27 | 780.82 | 19.52 | 2022-12-15 | 1 | 722.26 | 1 | 780.82 | 21 | SO47369 | 2022-12-22 | 62.47 | 722.26 | 780.82 | |||
| SO49058_10 | BD1B-4C7F-A9 | PO12499147561 | 100 | 282 | 462 | 78 | 4 | 2023-05-29 | 70.64 | 1.77 | 2023-05-17 | 5 | 9.71 | 1 | 70.64 | 10 | SO49058 | 2023-05-24 | 5.65 | 48.57 | 14.13 | |||
| SO50744_4 | 2D17-4C84-9B | PO4582137475 | 100 | 282 | 453 | 25 | 4 | 2023-09-26 | 107.98 | 2.70 | 2023-09-14 | 3 | 24.75 | 1 | 107.98 | 4 | SO50744 | 2023-09-21 | 8.64 | 74.24 | 35.99 | |||
| SO47439_33 | D4B6-4746-BE | PO6786128920 | 100 | 283 | 335 | 3 | 4 | 2022-12-27 | 939.59 | 23.49 | 2022-12-15 | 2 | 486.71 | 1 | 939.59 | 33 | SO47439 | 2022-12-22 | 75.17 | 973.41 | 469.79 | |||
| SO50272_9 | E0A6-4CFA-90 | PO11745174916 | 100 | 282 | 368 | 97 | 4 | 2023-08-26 | 2932.02 | 73.30 | 2023-08-14 | 2 | 1518.79 | 1 | 2932.02 | 9 | SO50272 | 2023-08-21 | 234.56 | 3037.57 | 1466.01 | |||
| SO48295_52 | 12F9-466B-B0 | PO19343197973 | 100 | 282 | 216 | 24 | 4 | 2023-03-28 | 161.49 | 4.04 | 2023-03-16 | 8 | 13.88 | 1 | 161.49 | 52 | SO48295 | 2023-03-23 | 12.92 | 111.03 | 20.19 | |||
| SO45059_13 | C618-4998-BE | PO10730115502 | 100 | 287 | 334 | 491 | 4 | 2022-04-28 | 419.46 | 10.49 | 2022-04-16 | 1 | 413.15 | 1 | 419.46 | 13 | SO45059 | 2022-04-23 | 33.56 | 413.15 | 419.46 | |||
| SO65168_11 | 7CDD-4B4A-AE | PO18038110078 | 100 | 287 | 586 | 509 | 4 | 2024-06-26 | 890.82 | 22.27 | 2024-06-14 | 2 | 461.44 | 1 | 890.82 | 11 | SO65168 | 2024-06-21 | 71.27 | 922.89 | 445.41 | |||
| SO47711_1 | F428-41EA-8E | PO5394123420 | 100 | 283 | 464 | 94 | 4 | 2023-01-26 | 28.26 | 0.71 | 2023-01-14 | 2 | 9.71 | 1 | 28.26 | 1 | SO47711 | 2023-01-21 | 2.26 | 19.43 | 14.13 | |||
| SO46648_45 | 2073-4051-9E | PO2494191557 | 100 | 283 | 468 | 184 | 4 | 2022-10-26 | 22.79 | 0.57 | 2022-10-14 | 1 | 15.67 | 1 | 22.79 | 45 | SO46648 | 2022-10-21 | 1.82 | 15.67 | 22.79 | |||
| SO44756_4 | 7857-4221-BA | PO15138192148 | 100 | 283 | 317 | 93 | 4 | 2022-03-28 | 874.79 | 21.87 | 2022-03-16 | 1 | 884.71 | 1 | 874.79 | 4 | SO44756 | 2022-03-23 | 69.98 | 884.71 | 874.79 | |||
| SO48369_5 | 92AB-4468-B5 | PO4582138864 | 100 | 282 | 216 | 25 | 4 | 2023-03-28 | 20.19 | 0.50 | 2023-03-16 | 1 | 13.88 | 1 | 20.19 | 5 | SO48369 | 2023-03-23 | 1.61 | 13.88 | 20.19 | |||
| SO48080_9 | 4DC7-4772-87 | PO7656157590 | 100 | 282 | 417 | 403 | 4 | 2023-02-26 | 648.91 | 16.22 | 2023-02-14 | 2 | 300.12 | 1 | 648.91 | 9 | SO48080 | 2023-02-21 | 51.91 | 600.24 | 324.45 | |||
| SO55256_17 | 686E-4D36-8B | PO12528136439 | 100 | 282 | 573 | 331 | 4 | 2024-01-26 | 2860.88 | 71.52 | 2024-01-14 | 2 | 1481.94 | 1 | 2860.88 | 17 | SO55256 | 2024-01-21 | 228.87 | 2963.88 | 1430.44 | |||
| SO51714_45 | D33A-4EAE-B1 | PO15689195197 | 100 | 281 | 440 | 328 | 4 | 2023-11-26 | 3435.60 | 85.89 | 2023-11-14 | 4 | 868.63 | 1 | 3435.60 | 45 | SO51714 | 2023-11-21 | 274.85 | 3474.54 | 858.90 | |||
| SO47027_54 | 1A9C-4166-A7 | PO3480112515 | 100 | 283 | 331 | 436 | 4 | 2022-11-26 | 4228.15 | 105.70 | 2022-11-14 | 9 | 486.71 | 1 | 4228.15 | 54 | SO47027 | 2022-11-21 | 338.25 | 4380.36 | 469.79 | |||
| SO49523_27 | 852E-47A8-A9 | PO3915144057 | 100 | 281 | 417 | 130 | 4 | 2023-06-26 | 973.36 | 24.33 | 2023-06-14 | 3 | 300.12 | 1 | 973.36 | 27 | SO49523 | 2023-06-21 | 77.87 | 900.36 | 324.45 | |||
| SO55298_3 | AC0A-4618-BC | PO7743176359 | 100 | 272 | 586 | 275 | 4 | 2024-01-26 | 890.82 | 22.27 | 2024-01-14 | 2 | 461.44 | 1 | 890.82 | 3 | SO55298 | 2024-01-21 | 71.27 | 922.89 | 445.41 | |||
| SO48311_4 | AAD7-4EBC-A1 | PO16472177233 | 100 | 287 | 461 | 239 | 4 | 2023-03-28 | 215.98 | 5.40 | 2023-03-16 | 4 | 37.12 | 1 | 215.98 | 4 | SO48311 | 2023-03-23 | 17.28 | 148.48 | 53.99 |
Generated 2024-11-13 08:46:02.134 UTC