[ROOT] dt FactResellerSale < WHERE DimSalesTerritoryId EQ '6' > SHUFFLE < SKIP 440 > < 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 |
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
| SO71794_8 | C39A-4835-99 | PO17574111985 | 19 | 291 | 592 | 16 | 678 | 6 | 135.60 | 2024-09-27 | 338.99 | 5.08 | 2024-09-15 | 3 | 308.22 | 1 | 203.40 | 8 | SO71794 | 2024-09-22 | 16.27 | 924.65 | 113.00 | 0.40 |
| SO61204_23 | E810-4164-82 | PO15312134209 | 19 | 291 | 222 | 299 | 6 | 2024-04-28 | 146.96 | 3.67 | 2024-04-16 | 7 | 13.09 | 1 | 146.96 | 23 | SO61204 | 2024-04-23 | 11.76 | 91.60 | 20.99 | |||
| SO65189_30 | 985E-4937-94 | PO14761195376 | 19 | 284 | 586 | 408 | 6 | 2024-06-27 | 2672.46 | 66.81 | 2024-06-15 | 6 | 461.44 | 1 | 2672.46 | 30 | SO65189 | 2024-06-22 | 213.80 | 2768.67 | 445.41 | |||
| SO46334_22 | F652-4575-B7 | PO17574196050 | 19 | 272 | 292 | 678 | 6 | 2022-09-27 | 818.70 | 20.47 | 2022-09-15 | 1 | 706.81 | 1 | 818.70 | 22 | SO46334 | 2022-09-22 | 65.50 | 706.81 | 818.70 | |||
| SO51839_31 | 411D-4ACA-8E | PO4901195797 | 19 | 284 | 471 | 84 | 6 | 2023-11-27 | 266.70 | 6.67 | 2023-11-15 | 7 | 23.75 | 1 | 266.70 | 31 | SO51839 | 2023-11-22 | 21.34 | 166.24 | 38.10 | |||
| SO71828_15 | 73A0-490C-B1 | PO11194153355 | 19 | 284 | 564 | 48 | 6 | 2024-09-27 | 4291.33 | 107.28 | 2024-09-15 | 3 | 1481.94 | 1 | 4291.33 | 15 | SO71828 | 2024-09-22 | 343.31 | 4445.81 | 1430.44 | |||
| SO69390_1 | A6A6-421B-A7 | PO20242146443 | 19 | 284 | 398 | 390 | 6 | 2024-08-27 | 26.72 | 0.67 | 2024-08-15 | 1 | 19.78 | 1 | 26.72 | 1 | SO69390 | 2024-08-22 | 2.14 | 19.78 | 26.72 | |||
| SO55283_18 | 8D6B-460A-83 | PO18473174493 | 19 | 291 | 400 | 442 | 6 | 2024-01-27 | 111.46 | 2.79 | 2024-01-15 | 3 | 27.49 | 1 | 111.46 | 18 | SO55283 | 2024-01-22 | 8.92 | 82.48 | 37.15 | |||
| SO51160_59 | 3F3F-4135-B0 | PO4495157262 | 19 | 291 | 544 | 2 | 496 | 6 | 12.21 | 2023-10-27 | 610.66 | 14.96 | 2023-10-15 | 13 | 35.96 | 1 | 598.45 | 59 | SO51160 | 2023-10-22 | 47.88 | 467.47 | 46.97 | 0.02 |
| SO53535_24 | 8195-45C7-93 | PO18502176746 | 19 | 291 | 472 | 154 | 6 | 2023-12-28 | 76.20 | 1.91 | 2023-12-16 | 2 | 23.75 | 1 | 76.20 | 24 | SO53535 | 2023-12-23 | 6.10 | 47.50 | 38.10 | |||
| SO65163_24 | 6062-4B82-A4 | PO18502160930 | 19 | 291 | 568 | 154 | 6 | 2024-06-27 | 2672.46 | 66.81 | 2024-06-15 | 6 | 461.44 | 1 | 2672.46 | 24 | SO65163 | 2024-06-22 | 213.80 | 2768.67 | 445.41 | |||
| SO49484_10 | B25F-4DF4-8E | PO18299142683 | 19 | 291 | 213 | 118 | 6 | 2023-06-27 | 40.37 | 1.01 | 2023-06-15 | 2 | 13.88 | 1 | 40.37 | 10 | SO49484 | 2023-06-22 | 3.23 | 27.76 | 20.19 | |||
| SO45786_27 | C4AF-4371-B7 | PO14732192241 | 19 | 288 | 319 | 514 | 6 | 2022-07-28 | 7873.15 | 196.83 | 2022-07-16 | 9 | 884.71 | 1 | 7873.15 | 27 | SO45786 | 2022-07-23 | 629.85 | 7962.37 | 874.79 | |||
| SO46639_10 | 7CDF-4BF8-8E | PO10527141970 | 19 | 284 | 414 | 480 | 6 | 2022-10-27 | 149.03 | 3.73 | 2022-10-15 | 1 | 110.28 | 1 | 149.03 | 10 | SO46639 | 2022-10-22 | 11.92 | 110.28 | 149.03 | |||
| SO43661_2 | 4E0A-4F89-AE | PO18473189620 | 19 | 288 | 296 | 442 | 6 | 2021-10-27 | 714.70 | 17.87 | 2021-10-15 | 1 | 617.03 | 1 | 714.70 | 2 | SO43661 | 2021-10-22 | 57.18 | 617.03 | 714.70 | |||
| SO58925_8 | ACBD-43C3-A2 | PO15544139465 | 19 | 284 | 577 | 282 | 6 | 2024-03-28 | 728.91 | 18.22 | 2024-03-16 | 1 | 755.15 | 1 | 728.91 | 8 | SO58925 | 2024-03-23 | 58.31 | 755.15 | 728.91 | |||
| SO51766_9 | 1118-4A2A-80 | PO638122353 | 19 | 291 | 511 | 280 | 6 | 2023-11-27 | 436.91 | 10.92 | 2023-11-15 | 2 | 199.38 | 1 | 436.91 | 9 | SO51766 | 2023-11-22 | 34.95 | 398.75 | 218.45 | |||
| SO43844_1 | 15C3-40C5-AC | PO19691138342 | 19 | 288 | 348 | 353 | 6 | 2021-11-27 | 8099.98 | 202.50 | 2021-11-15 | 4 | 1898.09 | 1 | 8099.98 | 1 | SO43844 | 2021-11-22 | 648.00 | 7592.38 | 2024.99 | |||
| SO46334_2 | F652-4575-B7 | PO17574196050 | 19 | 272 | 307 | 678 | 6 | 2022-09-27 | 1445.19 | 36.13 | 2022-09-15 | 2 | 623.84 | 1 | 1445.19 | 2 | SO46334 | 2022-09-22 | 115.62 | 1247.68 | 722.59 | |||
| SO43898_19 | 420C-4ECE-85 | PO4901196283 | 19 | 284 | 229 | 84 | 6 | 2021-11-27 | 86.52 | 2.16 | 2021-11-15 | 3 | 31.72 | 1 | 86.52 | 19 | SO43898 | 2021-11-22 | 6.92 | 95.17 | 28.84 | |||
| SO71891_5 | A2BC-4140-A6 | PO7366158003 | 19 | 284 | 497 | 372 | 6 | 2024-09-27 | 602.35 | 15.06 | 2024-09-15 | 1 | 601.74 | 1 | 602.35 | 5 | SO71891 | 2024-09-22 | 48.19 | 601.74 | 602.35 | |||
| SO48764_2 | B2E5-4B83-BC | PO18444188685 | 19 | 291 | 415 | 227 | 6 | 2023-04-29 | 594.11 | 14.85 | 2023-04-17 | 3 | 146.55 | 1 | 594.11 | 2 | SO48764 | 2023-04-24 | 47.53 | 439.64 | 198.04 | |||
| SO58913_1 | 51C4-4C84-94 | PO17690130629 | 19 | 291 | 475 | 47 | 6 | 2024-03-28 | 41.99 | 1.05 | 2024-03-16 | 1 | 26.18 | 1 | 41.99 | 1 | SO58913 | 2024-03-23 | 3.36 | 26.18 | 41.99 | |||
| SO49496_4 | 1BAD-4D34-B0 | PO10614179686 | 19 | 291 | 343 | 461 | 6 | 2023-06-27 | 939.59 | 23.49 | 2023-06-15 | 2 | 486.71 | 1 | 939.59 | 4 | SO49496 | 2023-06-22 | 75.17 | 973.41 | 469.79 | |||
| SO47366_58 | DD3E-4DAA-BA | PO17545115575 | 19 | 291 | 216 | 155 | 6 | 2022-12-28 | 201.87 | 5.05 | 2022-12-16 | 10 | 13.88 | 1 | 201.87 | 58 | SO47366 | 2022-12-23 | 16.15 | 138.78 | 20.19 | |||
| SO59003_6 | 514A-4B62-B4 | PO14239121229 | 19 | 291 | 545 | 550 | 6 | 2024-03-28 | 72.88 | 1.82 | 2024-03-16 | 3 | 17.98 | 1 | 72.88 | 6 | SO59003 | 2024-03-23 | 5.83 | 53.93 | 24.29 | |||
| SO47365_51 | 4535-457B-B0 | PO17574153673 | 19 | 291 | 454 | 678 | 6 | 2022-12-28 | 107.98 | 2.70 | 2022-12-16 | 3 | 24.75 | 1 | 107.98 | 51 | SO47365 | 2022-12-23 | 8.64 | 74.24 | 35.99 | |||
| SO49879_41 | 7A79-4FB0-85 | PO4495112714 | 19 | 291 | 448 | 496 | 6 | 2023-07-28 | 11.99 | 0.30 | 2023-07-16 | 1 | 8.25 | 1 | 11.99 | 41 | SO49879 | 2023-07-23 | 0.96 | 8.25 | 11.99 | |||
| SO46359_17 | 95FD-4612-88 | PO1740167502 | 19 | 288 | 314 | 460 | 6 | 2022-09-27 | 4293.92 | 107.35 | 2022-09-15 | 2 | 2171.29 | 1 | 4293.92 | 17 | SO46359 | 2022-09-22 | 343.51 | 4342.59 | 2146.96 | |||
| SO69482_12 | 0D35-42F6-9E | PO18357170772 | 19 | 284 | 552 | 138 | 6 | 2024-08-27 | 54.89 | 1.37 | 2024-08-15 | 1 | 40.62 | 1 | 54.89 | 12 | SO69482 | 2024-08-22 | 4.39 | 40.62 | 54.89 | |||
| SO44560_2 | CED4-47AE-86 | PO6960179699 | 19 | 288 | 241 | 532 | 6 | 2022-02-27 | 758.08 | 18.95 | 2022-02-15 | 1 | 747.97 | 1 | 758.08 | 2 | SO44560 | 2022-02-22 | 60.65 | 747.97 | 758.08 | |||
| SO46645_31 | F857-4A6D-9C | PO1711132491 | 19 | 291 | 358 | 245 | 6 | 2022-10-27 | 12294.59 | 307.36 | 2022-10-15 | 10 | 1105.81 | 1 | 12294.59 | 31 | SO46645 | 2022-10-22 | 983.57 | 11058.10 | 1229.46 | |||
| SO46608_1 | ACF1-4852-B7 | PO18473177913 | 19 | 291 | 469 | 442 | 6 | 2022-10-27 | 68.38 | 1.71 | 2022-10-15 | 3 | 15.67 | 1 | 68.38 | 1 | SO46608 | 2022-10-22 | 5.47 | 47.01 | 22.79 | |||
| SO45524_8 | D7A1-4CAA-B1 | PO18299160578 | 19 | 288 | 347 | 118 | 6 | 2022-06-27 | 8159.98 | 204.00 | 2022-06-15 | 4 | 1912.15 | 1 | 8159.98 | 8 | SO45524 | 2022-06-22 | 652.80 | 7648.62 | 2039.99 | |||
| SO49827_18 | E4F0-4B91-84 | PO15312199090 | 19 | 291 | 263 | 299 | 6 | 2023-07-28 | 607.00 | 15.17 | 2023-07-16 | 3 | 187.16 | 1 | 607.00 | 18 | SO49827 | 2023-07-23 | 48.56 | 561.47 | 202.33 | |||
| SO47366_56 | DD3E-4DAA-BA | PO17545115575 | 19 | 291 | 321 | 155 | 6 | 2022-12-28 | 2818.76 | 70.47 | 2022-12-16 | 6 | 486.71 | 1 | 2818.76 | 56 | SO47366 | 2022-12-23 | 225.50 | 2920.24 | 469.79 | |||
| SO48323_4 | 5C46-4F8D-9E | PO14239114372 | 19 | 291 | 327 | 550 | 6 | 2023-03-29 | 939.59 | 23.49 | 2023-03-17 | 2 | 486.71 | 1 | 939.59 | 4 | SO48323 | 2023-03-24 | 75.17 | 973.41 | 469.79 | |||
| SO44773_13 | D4D3-4657-AC | PO1740125070 | 19 | 288 | 235 | 460 | 6 | 2022-03-29 | 86.52 | 2.16 | 2022-03-17 | 3 | 31.72 | 1 | 86.52 | 13 | SO44773 | 2022-03-24 | 6.92 | 95.17 | 28.84 | |||
| SO48307_41 | 7DE5-4D74-A7 | PO17545123793 | 19 | 291 | 230 | 155 | 6 | 2023-03-29 | 230.72 | 5.77 | 2023-03-17 | 8 | 29.08 | 1 | 230.72 | 41 | SO48307 | 2023-03-24 | 18.46 | 232.65 | 28.84 | |||
| SO47668_35 | 7CB5-4904-AD | PO15312152020 | 19 | 291 | 462 | 299 | 6 | 2023-01-27 | 28.26 | 0.71 | 2023-01-15 | 2 | 9.71 | 1 | 28.26 | 35 | SO47668 | 2023-01-22 | 2.26 | 19.43 | 14.13 | |||
| SO63174_21 | 0B72-4270-AC | PO1827182060 | 19 | 291 | 287 | 317 | 6 | 2024-05-29 | 404.66 | 10.12 | 2024-05-17 | 2 | 204.63 | 1 | 404.66 | 21 | SO63174 | 2024-05-24 | 32.37 | 409.25 | 202.33 | |||
| SO47415_3 | 4C47-41C8-B0 | PO2233131382 | 19 | 291 | 458 | 262 | 6 | 2022-12-28 | 44.99 | 1.12 | 2022-12-16 | 1 | 30.93 | 1 | 44.99 | 3 | SO47415 | 2022-12-23 | 3.60 | 30.93 | 44.99 | |||
| SO50664_40 | 85F5-458B-8D | PO19401149024 | 19 | 291 | 329 | 173 | 6 | 2023-09-27 | 1409.38 | 35.23 | 2023-09-15 | 3 | 486.71 | 1 | 1409.38 | 40 | SO50664 | 2023-09-22 | 112.75 | 1460.12 | 469.79 | |||
| SO43880_8 | 3269-4442-87 | PO11020127453 | 19 | 284 | 314 | 336 | 6 | 2021-11-27 | 4293.92 | 107.35 | 2021-11-15 | 2 | 2171.29 | 1 | 4293.92 | 8 | SO43880 | 2021-11-22 | 343.51 | 4342.59 | 2146.96 | |||
| SO46658_6 | F375-4C62-AB | PO4930144247 | 19 | 291 | 356 | 425 | 6 | 2022-10-27 | 1242.85 | 31.07 | 2022-10-15 | 1 | 1117.86 | 1 | 1242.85 | 6 | SO46658 | 2022-10-22 | 99.43 | 1117.86 | 1242.85 | |||
| SO51160_70 | 3F3F-4135-B0 | PO4495157262 | 19 | 291 | 593 | 496 | 6 | 2023-10-27 | 1355.98 | 33.90 | 2023-10-15 | 4 | 308.22 | 1 | 1355.98 | 70 | SO51160 | 2023-10-22 | 108.48 | 1232.87 | 338.99 | |||
| SO47000_10 | 4946-4EC7-8D | PO10469179014 | 19 | 291 | 420 | 335 | 6 | 2022-11-27 | 141.62 | 3.54 | 2022-11-15 | 1 | 104.80 | 1 | 141.62 | 10 | SO47000 | 2022-11-22 | 11.33 | 104.80 | 141.62 | |||
| SO44773_23 | D4D3-4657-AC | PO1740125070 | 19 | 288 | 212 | 460 | 6 | 2022-03-29 | 121.12 | 3.03 | 2022-03-17 | 6 | 12.03 | 1 | 121.12 | 23 | SO44773 | 2022-03-24 | 9.69 | 72.17 | 20.19 | |||
| SO45039_18 | F427-497C-A1 | PO18444197500 | 19 | 288 | 332 | 227 | 6 | 2022-04-29 | 838.92 | 20.97 | 2022-04-17 | 2 | 413.15 | 1 | 838.92 | 18 | SO45039 | 2022-04-24 | 67.11 | 826.29 | 419.46 | |||
| SO49085_8 | 7265-4D98-80 | PO19198152404 | 19 | 291 | 305 | 653 | 6 | 2023-05-30 | 2208.44 | 55.21 | 2023-05-18 | 3 | 653.70 | 1 | 2208.44 | 8 | SO49085 | 2023-05-25 | 176.67 | 1961.09 | 736.15 | |||
| SO48039_3 | DA46-4271-BC | PO2030120341 | 19 | 284 | 297 | 661 | 6 | 2023-02-27 | 1472.29 | 36.81 | 2023-02-15 | 2 | 653.70 | 1 | 1472.29 | 3 | SO48039 | 2023-02-22 | 117.78 | 1307.39 | 736.15 | |||
| SO44533_9 | 6A24-4735-B2 | PO1827111566 | 19 | 288 | 262 | 317 | 6 | 2022-02-27 | 367.88 | 9.20 | 2022-02-15 | 2 | 181.49 | 1 | 367.88 | 9 | SO44533 | 2022-02-22 | 29.43 | 362.97 | 183.94 | |||
| SO50229_1 | 1C9D-4B67-94 | PO10991189322 | 19 | 284 | 358 | 570 | 6 | 2023-08-27 | 2458.92 | 61.47 | 2023-08-15 | 2 | 1105.81 | 1 | 2458.92 | 1 | SO50229 | 2023-08-22 | 196.71 | 2211.62 | 1229.46 | |||
| SO69446_2 | E9F7-4369-85 | PO10498138449 | 19 | 291 | 359 | 316 | 6 | 2024-08-27 | 1376.99 | 34.42 | 2024-08-15 | 1 | 1251.98 | 1 | 1376.99 | 2 | SO69446 | 2024-08-22 | 110.16 | 1251.98 | 1376.99 | |||
| SO46616_14 | 1264-43E6-B7 | PO14732122562 | 19 | 291 | 458 | 514 | 6 | 2022-10-27 | 224.97 | 5.62 | 2022-10-15 | 5 | 30.93 | 1 | 224.97 | 14 | SO46616 | 2022-10-22 | 18.00 | 154.67 | 44.99 | |||
| SO47003_13 | 2C85-4918-94 | PO638185142 | 19 | 291 | 224 | 280 | 6 | 2022-11-27 | 25.93 | 0.65 | 2022-11-15 | 5 | 5.23 | 1 | 25.93 | 13 | SO47003 | 2022-11-22 | 2.07 | 26.15 | 5.19 |
Generated 2024-11-14 18:01:05.842 UTC