[ROOT] dt FactResellerSale < WHERE DimSalesTerritoryId EQ '4' > SKIP 0 SHUFFLE < SKIP 1625 > < 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 |
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
| SO47439_30 | D4B6-4746-BE | PO6786128920 | 100 | 283 | 461 | 3 | 4 | 2022-12-28 | 215.98 | 5.40 | 2022-12-16 | 4 | 37.12 | 1 | 215.98 | 30 | SO47439 | 2022-12-23 | 17.28 | 148.48 | 53.99 | |||
| SO63280_5 | C73E-4203-80 | PO3654118854 | 100 | 281 | 552 | 435 | 4 | 2024-05-29 | 109.79 | 2.74 | 2024-05-17 | 2 | 40.62 | 1 | 109.79 | 5 | SO63280 | 2024-05-24 | 8.78 | 81.24 | 54.89 | |||
| SO51122_3 | D915-4225-97 | PO551181465 | 100 | 281 | 606 | 4 | 4 | 2023-10-27 | 1619.97 | 40.50 | 2023-10-15 | 5 | 343.65 | 1 | 1619.97 | 3 | SO51122 | 2023-10-22 | 129.60 | 1718.25 | 323.99 | |||
| SO47016_8 | 205E-4F0A-81 | PO2320157867 | 100 | 282 | 245 | 529 | 4 | 2022-11-27 | 1561.64 | 39.04 | 2022-11-15 | 2 | 722.26 | 1 | 1561.64 | 8 | SO47016 | 2022-11-22 | 124.93 | 1444.51 | 780.82 | |||
| SO45810_10 | 2A16-4AA7-89 | PO5626186069 | 100 | 283 | 340 | 166 | 4 | 2022-07-28 | 419.46 | 10.49 | 2022-07-16 | 1 | 413.15 | 1 | 419.46 | 10 | SO45810 | 2022-07-23 | 33.56 | 413.15 | 419.46 | |||
| SO63240_9 | AC0A-4F08-91 | PO4611157476 | 100 | 287 | 570 | 131 | 4 | 2024-05-29 | 445.41 | 11.14 | 2024-05-17 | 1 | 461.44 | 1 | 445.41 | 9 | SO63240 | 2024-05-24 | 35.63 | 461.44 | 445.41 | |||
| SO57034_30 | 57D0-46D3-B7 | PO15689142548 | 100 | 281 | 214 | 328 | 4 | 2024-02-27 | 104.97 | 2.62 | 2024-02-15 | 5 | 13.09 | 1 | 104.97 | 30 | SO57034 | 2024-02-22 | 8.40 | 65.43 | 20.99 | |||
| SO71899_6 | C395-434F-89 | PO4582142611 | 100 | 282 | 231 | 25 | 4 | 2024-09-27 | 59.99 | 1.50 | 2024-09-15 | 2 | 38.49 | 1 | 59.99 | 6 | SO71899 | 2024-09-22 | 4.80 | 76.98 | 29.99 | |||
| SO65176_8 | 2516-4DF3-BB | PO17052135284 | 100 | 282 | 561 | 420 | 4 | 2024-06-27 | 2860.88 | 71.52 | 2024-06-15 | 2 | 1481.94 | 1 | 2860.88 | 8 | SO65176 | 2024-06-22 | 228.87 | 2963.88 | 1430.44 | |||
| SO44521_6 | E46D-4692-AC | PO12557171689 | 100 | 282 | 318 | 240 | 4 | 2022-02-27 | 874.79 | 21.87 | 2022-02-15 | 1 | 884.71 | 1 | 874.79 | 6 | SO44521 | 2022-02-22 | 69.98 | 884.71 | 874.79 | |||
| SO69532_20 | 27FB-4A86-85 | PO3799165791 | 100 | 282 | 595 | 16 | 312 | 4 | 45.20 | 2024-08-27 | 113.00 | 1.70 | 2024-08-15 | 1 | 308.22 | 1 | 67.80 | 20 | SO69532 | 2024-08-22 | 5.42 | 308.22 | 113.00 | 0.40 |
| SO50707_1 | C071-42D6-B3 | PO16124195115 | 100 | 282 | 327 | 649 | 4 | 2023-09-27 | 469.79 | 11.74 | 2023-09-15 | 1 | 486.71 | 1 | 469.79 | 1 | SO50707 | 2023-09-22 | 37.58 | 486.71 | 469.79 | |||
| SO48375_1 | B5F1-4C2A-94 | PO5597156214 | 100 | 283 | 367 | 75 | 4 | 2023-03-29 | 1943.98 | 48.60 | 2023-03-17 | 3 | 598.44 | 1 | 1943.98 | 1 | SO48375 | 2023-03-24 | 155.52 | 1795.31 | 647.99 | |||
| SO47436_4 | 4AA1-4884-91 | PO5510133089 | 100 | 287 | 333 | 5 | 4 | 2022-12-28 | 939.59 | 23.49 | 2022-12-16 | 2 | 486.71 | 1 | 939.59 | 4 | SO47436 | 2022-12-23 | 75.17 | 973.41 | 469.79 | |||
| SO48384_27 | C99C-4AEC-9E | PO7569115185 | 100 | 287 | 356 | 608 | 4 | 2023-03-29 | 3728.56 | 93.21 | 2023-03-17 | 3 | 1117.86 | 1 | 3728.56 | 27 | SO48384 | 2023-03-24 | 298.28 | 3353.57 | 1242.85 | |||
| SO67279_29 | 5395-4C5C-A0 | PO12528190770 | 100 | 282 | 558 | 331 | 4 | 2024-07-28 | 728.98 | 18.22 | 2024-07-16 | 3 | 179.82 | 1 | 728.98 | 29 | SO67279 | 2024-07-23 | 58.32 | 539.45 | 242.99 | |||
| SO51745_29 | C261-441D-A5 | PO11745132954 | 100 | 282 | 380 | 97 | 4 | 2023-11-27 | 11728.08 | 293.20 | 2023-11-15 | 8 | 1554.95 | 1 | 11728.08 | 29 | SO51745 | 2023-11-22 | 938.25 | 12439.58 | 1466.01 | |||
| SO51825_26 | E395-4F72-84 | PO6525184188 | 100 | 281 | 588 | 345 | 4 | 2023-11-27 | 1846.78 | 46.17 | 2023-11-15 | 4 | 419.78 | 1 | 1846.78 | 26 | SO51825 | 2023-11-22 | 147.74 | 1679.11 | 461.69 | |||
| SO48758_3 | 709A-4AE0-B1 | PO13688180139 | 100 | 282 | 445 | 475 | 4 | 2023-04-29 | 71.99 | 1.80 | 2023-04-17 | 2 | 24.75 | 1 | 71.99 | 3 | SO48758 | 2023-04-24 | 5.76 | 49.49 | 35.99 | |||
| SO47687_44 | 738F-43EE-95 | PO10817185499 | 100 | 287 | 273 | 203 | 4 | 2023-01-27 | 202.33 | 5.06 | 2023-01-15 | 1 | 187.16 | 1 | 202.33 | 44 | SO47687 | 2023-01-22 | 16.19 | 187.16 | 202.33 | |||
| SO53470_18 | 932B-41E0-AF | PO17052111209 | 100 | 282 | 522 | 420 | 4 | 2023-12-28 | 23.48 | 0.59 | 2023-12-16 | 1 | 17.38 | 1 | 23.48 | 18 | SO53470 | 2023-12-23 | 1.88 | 17.38 | 23.48 | |||
| SO50738_21 | 531C-4E52-80 | PO3915159731 | 100 | 281 | 414 | 130 | 4 | 2023-09-27 | 298.06 | 7.45 | 2023-09-15 | 2 | 110.28 | 1 | 298.06 | 21 | SO50738 | 2023-09-22 | 23.85 | 220.57 | 149.03 | |||
| SO51099_6 | FF5E-417D-8D | PO13833111492 | 100 | 287 | 603 | 95 | 4 | 2023-10-27 | 145.79 | 3.64 | 2023-10-15 | 2 | 53.94 | 1 | 145.79 | 6 | SO51099 | 2023-10-22 | 11.66 | 107.88 | 72.89 | |||
| SO45301_8 | 0BA8-4928-A7 | PO12499190711 | 100 | 282 | 334 | 78 | 4 | 2022-05-30 | 1258.38 | 31.46 | 2022-05-18 | 3 | 413.15 | 1 | 1258.38 | 8 | SO45301 | 2022-05-25 | 100.67 | 1239.44 | 419.46 | |||
| SO45332_11 | AD0B-49A0-A5 | PO6351110306 | 100 | 283 | 320 | 255 | 4 | 2022-05-30 | 838.92 | 20.97 | 2022-05-18 | 2 | 413.15 | 1 | 838.92 | 11 | SO45332 | 2022-05-25 | 67.11 | 826.29 | 419.46 | |||
| SO48364_6 | 93FF-4A54-BA | PO3886118778 | 100 | 283 | 333 | 165 | 4 | 2023-03-29 | 1409.38 | 35.23 | 2023-03-17 | 3 | 486.71 | 1 | 1409.38 | 6 | SO48364 | 2023-03-24 | 112.75 | 1460.12 | 469.79 | |||
| SO47422_38 | 9D8D-4481-B6 | PO3915123127 | 100 | 283 | 236 | 130 | 4 | 2022-12-28 | 86.52 | 2.16 | 2022-12-16 | 3 | 29.08 | 1 | 86.52 | 38 | SO47422 | 2022-12-23 | 6.92 | 87.24 | 28.84 | |||
| SO59011_17 | CAAD-4857-B7 | PO6786194654 | 100 | 281 | 487 | 3 | 4 | 2024-03-28 | 263.95 | 6.60 | 2024-03-16 | 8 | 20.57 | 1 | 263.95 | 17 | SO59011 | 2024-03-23 | 21.12 | 164.53 | 32.99 | |||
| SO58979_16 | A35B-403A-A4 | PO18038174164 | 100 | 287 | 558 | 509 | 4 | 2024-03-28 | 242.99 | 6.07 | 2024-03-16 | 1 | 179.82 | 1 | 242.99 | 16 | SO58979 | 2024-03-23 | 19.44 | 179.82 | 242.99 | |||
| SO48069_6 | 60CF-43B6-82 | PO6438117188 | 100 | 283 | 410 | 309 | 4 | 2023-02-27 | 182.24 | 4.56 | 2023-02-15 | 5 | 26.97 | 1 | 182.24 | 6 | SO48069 | 2023-02-22 | 14.58 | 134.85 | 36.45 | |||
| SO46964_41 | B3E6-43CC-A2 | PO15689139014 | 100 | 283 | 417 | 328 | 4 | 2022-11-27 | 1297.81 | 32.45 | 2022-11-15 | 4 | 300.12 | 1 | 1297.81 | 41 | SO46964 | 2022-11-22 | 103.82 | 1200.48 | 324.45 | |||
| SO65209_2 | B869-4DFD-AB | PO2697179473 | 100 | 282 | 363 | 187 | 4 | 2024-06-27 | 1376.99 | 34.42 | 2024-06-15 | 1 | 1251.98 | 1 | 1376.99 | 2 | SO65209 | 2024-06-22 | 110.16 | 1251.98 | 1376.99 | |||
| SO47417_11 | 1CE8-4651-A9 | PO2697165938 | 100 | 282 | 354 | 187 | 4 | 2022-12-28 | 4971.41 | 124.29 | 2022-12-16 | 4 | 1117.86 | 1 | 4971.41 | 11 | SO47417 | 2022-12-23 | 397.71 | 4471.42 | 1242.85 | |||
| SO63263_16 | 1E1A-44EE-94 | PO4843118280 | 100 | 287 | 584 | 257 | 4 | 2024-05-29 | 323.99 | 8.10 | 2024-05-17 | 1 | 343.65 | 1 | 323.99 | 16 | SO63263 | 2024-05-24 | 25.92 | 343.65 | 323.99 | |||
| SO50670_2 | FE24-428B-88 | PO17226158606 | 100 | 281 | 459 | 561 | 4 | 2023-09-27 | 53.99 | 1.35 | 2023-09-15 | 1 | 37.12 | 1 | 53.99 | 2 | SO50670 | 2023-09-22 | 4.32 | 37.12 | 53.99 | |||
| SO46988_1 | 2D2E-4EC3-AC | PO12499171502 | 100 | 282 | 375 | 78 | 4 | 2022-11-27 | 9162.56 | 229.06 | 2022-11-15 | 7 | 1320.68 | 1 | 9162.56 | 1 | SO46988 | 2022-11-22 | 733.01 | 9244.79 | 1308.94 | |||
| SO67320_12 | 771C-4E57-91 | PO5626199373 | 100 | 281 | 382 | 166 | 4 | 2024-07-28 | 4033.76 | 100.84 | 2024-07-16 | 6 | 713.08 | 1 | 4033.76 | 12 | SO67320 | 2024-07-23 | 322.70 | 4278.48 | 672.29 | |||
| SO69545_39 | 2C06-44D9-96 | PO3480123333 | 100 | 272 | 231 | 436 | 4 | 2024-08-27 | 59.99 | 1.50 | 2024-08-15 | 2 | 38.49 | 1 | 59.99 | 39 | SO69545 | 2024-08-22 | 4.80 | 76.98 | 29.99 | |||
| SO53550_1 | C0B3-4A54-9F | PO16124171850 | 100 | 282 | 482 | 649 | 4 | 2023-12-28 | 26.97 | 0.67 | 2023-12-16 | 5 | 3.36 | 1 | 26.97 | 1 | SO53550 | 2023-12-23 | 2.16 | 16.81 | 5.39 | |||
| SO61184_42 | F33C-4C57-BD | PO16298116527 | 100 | 287 | 484 | 599 | 4 | 2024-04-28 | 33.39 | 0.83 | 2024-04-16 | 7 | 2.97 | 1 | 33.39 | 42 | SO61184 | 2024-04-23 | 2.67 | 20.81 | 4.77 | |||
| SO49086_3 | DC81-474D-82 | PO15196160156 | 100 | 282 | 389 | 258 | 4 | 2023-05-30 | 600.26 | 15.01 | 2023-05-18 | 1 | 605.65 | 1 | 600.26 | 3 | SO49086 | 2023-05-25 | 48.02 | 605.65 | 600.26 | |||
| SO47035_3 | 661B-492D-B3 | PO4698148803 | 100 | 282 | 333 | 528 | 4 | 2022-11-27 | 469.79 | 11.74 | 2022-11-15 | 1 | 486.71 | 1 | 469.79 | 3 | SO47035 | 2022-11-22 | 37.58 | 486.71 | 469.79 | |||
| SO47434_20 | 6848-4C33-98 | PO5539145068 | 100 | 282 | 456 | 61 | 4 | 2022-12-28 | 179.98 | 4.50 | 2022-12-16 | 4 | 30.93 | 1 | 179.98 | 20 | SO47434 | 2022-12-23 | 14.40 | 123.73 | 44.99 | |||
| SO63251_3 | CA03-47EE-90 | PO6525146360 | 100 | 281 | 532 | 345 | 4 | 2024-05-29 | 599.50 | 14.99 | 2024-05-17 | 4 | 136.79 | 1 | 599.50 | 3 | SO63251 | 2024-05-24 | 47.96 | 547.14 | 149.87 | |||
| SO43689_1 | DCD9-4C9A-AB | PO5626159507 | 100 | 283 | 330 | 166 | 4 | 2021-10-27 | 1258.38 | 31.46 | 2021-10-15 | 3 | 413.15 | 1 | 1258.38 | 1 | SO43689 | 2021-10-22 | 100.67 | 1239.44 | 419.46 | |||
| SO44795_7 | 629B-45A2-8B | PO7569171528 | 100 | 287 | 345 | 608 | 4 | 2022-03-29 | 4079.99 | 102.00 | 2022-03-17 | 2 | 1912.15 | 1 | 4079.99 | 7 | SO44795 | 2022-03-24 | 326.40 | 3824.31 | 2039.99 | |||
| SO48363_19 | A9C9-4B7B-9B | PO3915186343 | 100 | 283 | 462 | 130 | 4 | 2023-03-29 | 70.64 | 1.77 | 2023-03-17 | 5 | 9.71 | 1 | 70.64 | 19 | SO48363 | 2023-03-24 | 5.65 | 48.57 | 14.13 | |||
| SO58984_6 | 5D72-43BF-AB | PO16153135798 | 100 | 282 | 564 | 186 | 4 | 2024-03-28 | 1430.44 | 35.76 | 2024-03-16 | 1 | 1481.94 | 1 | 1430.44 | 6 | SO58984 | 2024-03-23 | 114.44 | 1481.94 | 1430.44 | |||
| SO49086_7 | DC81-474D-82 | PO15196160156 | 100 | 282 | 375 | 258 | 4 | 2023-05-30 | 5235.75 | 130.89 | 2023-05-18 | 4 | 1320.68 | 1 | 5235.75 | 7 | SO49086 | 2023-05-25 | 418.86 | 5282.74 | 1308.94 | |||
| SO47658_8 | C574-484B-83 | PO551177057 | 100 | 283 | 329 | 4 | 4 | 2023-01-27 | 1409.38 | 35.23 | 2023-01-15 | 3 | 486.71 | 1 | 1409.38 | 8 | SO47658 | 2023-01-22 | 112.75 | 1460.12 | 469.79 | |||
| SO47355_57 | 6B7D-4E47-B5 | PO19343125466 | 100 | 282 | 263 | 24 | 4 | 2022-12-28 | 2023.32 | 50.58 | 2022-12-16 | 10 | 187.16 | 1 | 2023.32 | 57 | SO47355 | 2022-12-23 | 161.87 | 1871.57 | 202.33 | |||
| SO51153_18 | AC8D-4688-81 | PO5626119823 | 100 | 281 | 545 | 166 | 4 | 2023-10-27 | 145.76 | 3.64 | 2023-10-15 | 6 | 17.98 | 1 | 145.76 | 18 | SO51153 | 2023-10-22 | 11.66 | 107.87 | 24.29 | |||
| SO46355_18 | D579-4B15-AB | PO261195016 | 100 | 283 | 232 | 647 | 4 | 2022-09-27 | 144.20 | 3.61 | 2022-09-15 | 5 | 31.72 | 1 | 144.20 | 18 | SO46355 | 2022-09-22 | 11.54 | 158.62 | 28.84 | |||
| SO49481_28 | 474A-4DD1-9B | PO10701112208 | 100 | 282 | 427 | 133 | 4 | 2023-06-27 | 1674.05 | 41.85 | 2023-06-15 | 8 | 185.82 | 1 | 1674.05 | 28 | SO49481 | 2023-06-22 | 133.92 | 1486.55 | 209.26 | |||
| SO71859_7 | 326E-4365-A3 | PO16182112142 | 100 | 287 | 477 | 23 | 4 | 2024-09-27 | 5.99 | 0.15 | 2024-09-15 | 2 | 1.87 | 1 | 5.99 | 7 | SO71859 | 2024-09-22 | 0.48 | 3.73 | 2.99 | |||
| SO44791_6 | CA2D-49E4-BD | PO6786162636 | 100 | 283 | 328 | 3 | 4 | 2022-03-29 | 838.92 | 20.97 | 2022-03-17 | 2 | 413.15 | 1 | 838.92 | 6 | SO44791 | 2022-03-24 | 67.11 | 826.29 | 419.46 | |||
| SO63261_3 | 47AD-4561-92 | PO2320130718 | 100 | 282 | 390 | 529 | 4 | 2024-05-29 | 1344.59 | 33.61 | 2024-05-17 | 2 | 713.08 | 1 | 1344.59 | 3 | SO63261 | 2024-05-24 | 107.57 | 1426.16 | 672.29 | |||
| SO48380_20 | 580B-4A1F-A4 | PO6757155119 | 100 | 283 | 308 | 21 | 4 | 2023-03-29 | 1488.55 | 37.21 | 2023-03-17 | 2 | 660.91 | 1 | 1488.55 | 20 | SO48380 | 2023-03-24 | 119.08 | 1321.83 | 744.27 | |||
| SO45339_15 | 1F94-40D0-86 | PO7656113434 | 100 | 282 | 316 | 403 | 4 | 2022-05-30 | 4373.97 | 109.35 | 2022-05-18 | 5 | 884.71 | 1 | 4373.97 | 15 | SO45339 | 2022-05-25 | 349.92 | 4423.54 | 874.79 | |||
| SO51090_49 | EBDE-4A71-8E | PO13688110947 | 100 | 282 | 359 | 475 | 4 | 2023-10-27 | 4130.98 | 103.27 | 2023-10-15 | 3 | 1251.98 | 1 | 4130.98 | 49 | SO51090 | 2023-10-22 | 330.48 | 3755.94 | 1376.99 | |||
| SO47990_32 | 7D80-4D9E-9A | PO15689162700 | 100 | 283 | 216 | 328 | 4 | 2023-02-27 | 80.75 | 2.02 | 2023-02-15 | 4 | 13.88 | 1 | 80.75 | 32 | SO47990 | 2023-02-22 | 6.46 | 55.51 | 20.19 | |||
| SO49151_8 | D25B-462C-8C | PO6438151235 | 100 | 281 | 469 | 2 | 309 | 4 | 5.29 | 2023-05-30 | 264.41 | 6.48 | 2023-05-18 | 12 | 15.67 | 1 | 259.12 | 8 | SO49151 | 2023-05-25 | 20.73 | 188.05 | 22.03 | 0.02 |
Generated 2024-11-14 04:30:15.214 UTC