[ROOT] dt FactResellerSale < WHERE DimSalesTerritoryId EQ '6' > SHUFFLE < SKIP 2624 > < 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 |
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
| SO44773_4 | D4D3-4657-AC | PO1740125070 | 19 | 288 | 330 | 460 | 6 | 2022-03-27 | 419.46 | 10.49 | 2022-03-15 | 1 | 413.15 | 1 | 419.46 | 4 | SO44773 | 2022-03-22 | 33.56 | 413.15 | 419.46 | |||
| SO67316_2 | 6F7E-4455-9E | PO4495115494 | 19 | 291 | 214 | 2 | 496 | 6 | 5.28 | 2024-07-26 | 263.82 | 6.46 | 2024-07-14 | 13 | 13.09 | 1 | 258.55 | 2 | SO67316 | 2024-07-21 | 20.68 | 170.12 | 20.29 | 0.02 |
| SO50699_4 | FEA0-4613-AE | PO1885169186 | 19 | 284 | 365 | 588 | 6 | 2023-09-25 | 647.99 | 16.20 | 2023-09-13 | 1 | 598.44 | 1 | 647.99 | 4 | SO50699 | 2023-09-20 | 51.84 | 598.44 | 647.99 | |||
| SO57152_1 | 6C7E-4B58-93 | PO2030123828 | 19 | 284 | 513 | 661 | 6 | 2024-02-25 | 436.91 | 10.92 | 2024-02-13 | 2 | 199.38 | 1 | 436.91 | 1 | SO57152 | 2024-02-20 | 34.95 | 398.75 | 218.45 | |||
| SO53536_26 | 5C09-4051-92 | PO18299189909 | 19 | 291 | 557 | 118 | 6 | 2023-12-26 | 461.68 | 11.54 | 2023-12-14 | 3 | 113.88 | 1 | 461.68 | 26 | SO53536 | 2023-12-21 | 36.93 | 341.64 | 153.89 | |||
| SO71806_4 | 26A7-4E95-9B | PO14790111844 | 19 | 291 | 524 | 497 | 6 | 2024-09-25 | 316.86 | 7.92 | 2024-09-13 | 2 | 144.59 | 1 | 316.86 | 4 | SO71806 | 2024-09-20 | 25.35 | 289.19 | 158.43 | |||
| SO58958_28 | BC3F-443F-B5 | PO10875118816 | 19 | 291 | 493 | 281 | 6 | 2024-03-26 | 200.05 | 5.00 | 2024-03-14 | 1 | 199.85 | 1 | 200.05 | 28 | SO58958 | 2024-03-21 | 16.00 | 199.85 | 200.05 | |||
| SO44300_9 | 5132-4204-BB | PO10527120063 | 19 | 284 | 324 | 480 | 6 | 2022-01-25 | 419.46 | 10.49 | 2022-01-13 | 1 | 413.15 | 1 | 419.46 | 9 | SO44300 | 2022-01-20 | 33.56 | 413.15 | 419.46 | |||
| SO48296_33 | FC37-4F3E-BB | PO19401157526 | 19 | 291 | 456 | 173 | 6 | 2023-03-27 | 179.98 | 4.50 | 2023-03-15 | 4 | 30.93 | 1 | 179.98 | 33 | SO48296 | 2023-03-22 | 14.40 | 123.73 | 44.99 | |||
| SO61196_6 | 8DD6-4DC9-A5 | PO1711193720 | 19 | 291 | 476 | 245 | 6 | 2024-04-26 | 335.95 | 8.40 | 2024-04-14 | 8 | 26.18 | 1 | 335.95 | 6 | SO61196 | 2024-04-21 | 26.88 | 209.41 | 41.99 | |||
| SO48023_12 | 18BD-4FA3-9F | PO11020197101 | 19 | 284 | 273 | 336 | 6 | 2023-02-25 | 202.33 | 5.06 | 2023-02-13 | 1 | 187.16 | 1 | 202.33 | 12 | SO48023 | 2023-02-20 | 16.19 | 187.16 | 202.33 | |||
| SO71781_17 | 2FB9-4F05-82 | PO19401117806 | 19 | 291 | 582 | 173 | 6 | 2024-09-25 | 2041.19 | 51.03 | 2024-09-13 | 2 | 1082.51 | 1 | 2041.19 | 17 | SO71781 | 2024-09-20 | 163.30 | 2165.02 | 1020.59 | |||
| SO61204_22 | E810-4164-82 | PO15312134209 | 19 | 291 | 583 | 299 | 6 | 2024-04-26 | 3061.78 | 76.54 | 2024-04-14 | 3 | 1082.51 | 1 | 3061.78 | 22 | SO61204 | 2024-04-21 | 244.94 | 3247.53 | 1020.59 | |||
| SO47696_16 | B251-4D0B-9C | PO1711162591 | 19 | 291 | 421 | 245 | 6 | 2023-01-25 | 1177.97 | 29.45 | 2023-01-13 | 6 | 145.28 | 1 | 1177.97 | 16 | SO47696 | 2023-01-20 | 94.24 | 871.70 | 196.33 | |||
| SO51700_23 | 6837-439E-BC | PO17806126316 | 19 | 291 | 484 | 101 | 6 | 2023-11-25 | 23.85 | 0.60 | 2023-11-13 | 5 | 2.97 | 1 | 23.85 | 23 | SO51700 | 2023-11-20 | 1.91 | 14.87 | 4.77 | |||
| SO71869_1 | F7E5-49CA-8C | PO14877155420 | 19 | 291 | 556 | 172 | 6 | 2024-09-25 | 105.29 | 2.63 | 2024-09-13 | 1 | 77.92 | 1 | 105.29 | 1 | SO71869 | 2024-09-20 | 8.42 | 77.92 | 105.29 | |||
| SO44112_3 | C224-4FC6-AB | PO1885183650 | 19 | 284 | 348 | 588 | 6 | 2021-12-26 | 16199.95 | 405.00 | 2021-12-14 | 8 | 1898.09 | 1 | 16199.95 | 3 | SO44112 | 2021-12-21 | 1296.00 | 15184.76 | 2024.99 | |||
| SO57093_11 | 2F7C-4AF6-8B | PO18705165751 | 19 | 291 | 477 | 479 | 6 | 2024-02-25 | 2.99 | 0.07 | 2024-02-13 | 1 | 1.87 | 1 | 2.99 | 11 | SO57093 | 2024-02-20 | 0.24 | 1.87 | 2.99 | |||
| SO43662_21 | 2E53-4802-85 | PO18444174044 | 19 | 288 | 334 | 227 | 6 | 2021-10-25 | 1258.38 | 31.46 | 2021-10-13 | 3 | 413.15 | 1 | 1258.38 | 21 | SO43662 | 2021-10-20 | 100.67 | 1239.44 | 419.46 | |||
| SO43850_10 | EBA6-4C6F-86 | PO18415143340 | 19 | 288 | 275 | 191 | 6 | 2021-11-25 | 1070.69 | 26.77 | 2021-11-13 | 3 | 352.14 | 1 | 1070.69 | 10 | SO43850 | 2021-11-20 | 85.66 | 1056.42 | 356.90 | |||
| SO46351_7 | 9218-4521-8F | PO11107115959 | 19 | 284 | 232 | 156 | 6 | 2022-09-25 | 57.68 | 1.44 | 2022-09-13 | 2 | 31.72 | 1 | 57.68 | 7 | SO46351 | 2022-09-20 | 4.61 | 63.45 | 28.84 | |||
| SO47415_1 | 4C47-41C8-B0 | PO2233131382 | 19 | 291 | 286 | 262 | 6 | 2022-12-26 | 735.75 | 18.39 | 2022-12-14 | 4 | 170.14 | 1 | 735.75 | 1 | SO47415 | 2022-12-21 | 58.86 | 680.57 | 183.94 | |||
| SO51132_12 | D4A8-472C-A4 | PO18444136544 | 19 | 291 | 382 | 227 | 6 | 2023-10-25 | 2016.88 | 50.42 | 2023-10-13 | 3 | 713.08 | 1 | 2016.88 | 12 | SO51132 | 2023-10-20 | 161.35 | 2139.24 | 672.29 | |||
| SO51755_17 | 46F4-477C-A7 | PO11020169365 | 19 | 284 | 376 | 336 | 6 | 2023-11-25 | 2932.02 | 73.30 | 2023-11-13 | 2 | 1554.95 | 1 | 2932.02 | 17 | SO51755 | 2023-11-20 | 234.56 | 3109.90 | 1466.01 | |||
| SO47980_30 | 4C76-4276-8E | PO17603160708 | 19 | 284 | 233 | 12 | 6 | 2023-02-25 | 288.40 | 7.21 | 2023-02-13 | 10 | 29.08 | 1 | 288.40 | 30 | SO47980 | 2023-02-20 | 23.07 | 290.81 | 28.84 | |||
| SO48037_4 | D0D4-4B5F-84 | PO1827138439 | 19 | 291 | 459 | 317 | 6 | 2023-02-25 | 53.99 | 1.35 | 2023-02-13 | 1 | 37.12 | 1 | 53.99 | 4 | SO48037 | 2023-02-20 | 4.32 | 37.12 | 53.99 | |||
| SO51698_20 | C8C8-43A4-AC | PO19227173300 | 19 | 284 | 434 | 210 | 6 | 2023-11-25 | 713.80 | 17.84 | 2023-11-13 | 2 | 360.94 | 1 | 713.80 | 20 | SO51698 | 2023-11-20 | 57.10 | 721.89 | 356.90 | |||
| SO45047_25 | B1C5-444F-BF | PO14732155479 | 19 | 288 | 330 | 514 | 6 | 2022-04-27 | 419.46 | 10.49 | 2022-04-15 | 1 | 413.15 | 1 | 419.46 | 25 | SO45047 | 2022-04-22 | 33.56 | 413.15 | 419.46 | |||
| SO58956_11 | 36A4-4154-AB | PO11194174095 | 19 | 284 | 577 | 48 | 6 | 2024-03-26 | 2186.73 | 54.67 | 2024-03-14 | 3 | 755.15 | 1 | 2186.73 | 11 | SO58956 | 2024-03-21 | 174.94 | 2265.45 | 728.91 | |||
| SO47357_18 | 3E93-4357-9B | PO18531126368 | 19 | 284 | 458 | 613 | 6 | 2022-12-26 | 134.98 | 3.37 | 2022-12-14 | 3 | 30.93 | 1 | 134.98 | 18 | SO47357 | 2022-12-21 | 10.80 | 92.80 | 44.99 | |||
| SO46955_8 | 3DCD-4209-B1 | PO17313113846 | 19 | 291 | 356 | 389 | 6 | 2022-11-25 | 2485.70 | 62.14 | 2022-11-13 | 2 | 1117.86 | 1 | 2485.70 | 8 | SO46955 | 2022-11-20 | 198.86 | 2235.71 | 1242.85 | |||
| SO47663_18 | 1B17-4C63-B6 | PO18444192283 | 19 | 291 | 265 | 227 | 6 | 2023-01-25 | 1213.99 | 30.35 | 2023-01-13 | 6 | 187.16 | 1 | 1213.99 | 18 | SO47663 | 2023-01-20 | 97.12 | 1122.94 | 202.33 | |||
| SO47365_19 | 4535-457B-B0 | PO17574153673 | 19 | 291 | 297 | 678 | 6 | 2022-12-26 | 2208.44 | 55.21 | 2022-12-14 | 3 | 653.70 | 1 | 2208.44 | 19 | SO47365 | 2022-12-21 | 176.67 | 1961.09 | 736.15 | |||
| SO51703_4 | 53F7-4B59-AA | PO17603160217 | 19 | 284 | 234 | 3 | 12 | 6 | 27.49 | 2023-11-25 | 549.89 | 13.06 | 2023-11-13 | 20 | 38.49 | 1 | 522.40 | 4 | SO51703 | 2023-11-20 | 41.79 | 769.85 | 27.49 | 0.05 |
| SO44282_4 | 57B6-44F8-98 | PO18473177808 | 19 | 288 | 288 | 442 | 6 | 2022-01-25 | 1445.19 | 36.13 | 2022-01-13 | 2 | 623.84 | 1 | 1445.19 | 4 | SO44282 | 2022-01-20 | 115.62 | 1247.68 | 722.59 | |||
| SO71794_1 | C39A-4835-99 | PO17574111985 | 19 | 291 | 353 | 678 | 6 | 2024-09-25 | 4175.98 | 104.40 | 2024-09-13 | 3 | 1265.62 | 1 | 4175.98 | 1 | SO71794 | 2024-09-20 | 334.08 | 3796.86 | 1391.99 | |||
| SO69540_14 | 75AA-4D8C-83 | PO1856168639 | 19 | 291 | 487 | 263 | 6 | 2024-08-25 | 329.94 | 8.25 | 2024-08-13 | 10 | 20.57 | 1 | 329.94 | 14 | SO69540 | 2024-08-20 | 26.40 | 205.66 | 32.99 | |||
| SO43855_12 | FB88-4B92-82 | PO17748116016 | 19 | 284 | 316 | 102 | 6 | 2021-11-25 | 874.79 | 21.87 | 2021-11-13 | 1 | 884.71 | 1 | 874.79 | 12 | SO43855 | 2021-11-20 | 69.98 | 884.71 | 874.79 | |||
| SO57079_4 | 1CB1-4EC7-8E | PO638182054 | 19 | 291 | 475 | 280 | 6 | 2024-02-25 | 125.98 | 3.15 | 2024-02-13 | 3 | 26.18 | 1 | 125.98 | 4 | SO57079 | 2024-02-20 | 10.08 | 78.53 | 41.99 | |||
| SO61248_14 | 67A0-4D10-87 | PO4495126386 | 19 | 291 | 363 | 496 | 6 | 2024-04-26 | 4130.98 | 103.27 | 2024-04-14 | 3 | 1251.98 | 1 | 4130.98 | 14 | SO61248 | 2024-04-21 | 330.48 | 3755.94 | 1376.99 | |||
| SO43898_14 | 420C-4ECE-85 | PO4901196283 | 19 | 284 | 330 | 84 | 6 | 2021-11-25 | 838.92 | 20.97 | 2021-11-13 | 2 | 413.15 | 1 | 838.92 | 14 | SO43898 | 2021-11-20 | 67.11 | 826.29 | 419.46 | |||
| SO48764_17 | B2E5-4B83-BC | PO18444188685 | 19 | 291 | 265 | 227 | 6 | 2023-04-27 | 607.00 | 15.17 | 2023-04-15 | 3 | 187.16 | 1 | 607.00 | 17 | SO48764 | 2023-04-22 | 48.56 | 561.47 | 202.33 | |||
| SO47013_17 | 4AB0-4FA0-95 | PO1827132360 | 19 | 291 | 280 | 317 | 6 | 2022-11-25 | 735.75 | 18.39 | 2022-11-13 | 4 | 170.14 | 1 | 735.75 | 17 | SO47013 | 2022-11-20 | 58.86 | 680.57 | 183.94 | |||
| SO51116_8 | B371-45B5-B0 | PO10527115387 | 19 | 284 | 606 | 480 | 6 | 2023-10-25 | 323.99 | 8.10 | 2023-10-13 | 1 | 343.65 | 1 | 323.99 | 8 | SO51116 | 2023-10-20 | 25.92 | 343.65 | 323.99 | |||
| SO51100_10 | A159-4950-A0 | PO13862191766 | 19 | 291 | 517 | 119 | 6 | 2023-10-25 | 126.34 | 3.16 | 2023-10-13 | 4 | 23.37 | 1 | 126.34 | 10 | SO51100 | 2023-10-20 | 10.11 | 93.49 | 31.58 | |||
| SO51130_26 | F38F-411F-B2 | PO18473180006 | 19 | 291 | 555 | 442 | 6 | 2023-10-25 | 127.80 | 3.20 | 2023-10-13 | 2 | 47.29 | 1 | 127.80 | 26 | SO51130 | 2023-10-20 | 10.22 | 94.57 | 63.90 | |||
| SO67302_39 | E4B2-462D-AC | PO18473194134 | 19 | 291 | 515 | 442 | 6 | 2024-07-26 | 65.09 | 1.63 | 2024-07-14 | 4 | 12.04 | 1 | 65.09 | 39 | SO67302 | 2024-07-21 | 5.21 | 48.17 | 16.27 | |||
| SO44744_8 | 6D80-4E9D-83 | PO19401124443 | 19 | 288 | 215 | 173 | 6 | 2022-03-27 | 121.12 | 3.03 | 2022-03-15 | 6 | 12.03 | 1 | 121.12 | 8 | SO44744 | 2022-03-22 | 9.69 | 72.17 | 20.19 | |||
| SO57188_15 | BA1D-4480-AA | PO9077120275 | 19 | 291 | 353 | 100 | 6 | 2024-02-25 | 1391.99 | 34.80 | 2024-02-13 | 1 | 1265.62 | 1 | 1391.99 | 15 | SO57188 | 2024-02-20 | 111.36 | 1265.62 | 1391.99 | |||
| SO43891_2 | 1094-43CB-B1 | PO2726163521 | 19 | 288 | 219 | 29 | 6 | 2021-11-25 | 11.40 | 0.29 | 2021-11-13 | 2 | 3.40 | 1 | 11.40 | 2 | SO43891 | 2021-11-20 | 0.91 | 6.79 | 5.70 | |||
| SO69522_2 | 28C3-4615-8B | PO4901187436 | 19 | 284 | 467 | 84 | 6 | 2024-08-25 | 73.47 | 1.84 | 2024-08-13 | 5 | 9.16 | 1 | 73.47 | 2 | SO69522 | 2024-08-20 | 5.88 | 45.80 | 14.69 | |||
| SO45284_18 | 57F0-404F-97 | PO16733112744 | 19 | 288 | 340 | 533 | 6 | 2022-05-28 | 419.46 | 10.49 | 2022-05-16 | 1 | 413.15 | 1 | 419.46 | 18 | SO45284 | 2022-05-23 | 33.56 | 413.15 | 419.46 | |||
| SO50694_31 | DAEB-4730-9B | PO17545120609 | 19 | 291 | 368 | 155 | 6 | 2023-09-25 | 8796.06 | 219.90 | 2023-09-13 | 6 | 1518.79 | 1 | 8796.06 | 31 | SO50694 | 2023-09-20 | 703.68 | 9112.72 | 1466.01 | |||
| SO47399_1 | B5FA-4CC2-8C | PO10962177551 | 19 | 284 | 367 | 685 | 6 | 2022-12-26 | 3239.97 | 81.00 | 2022-12-14 | 5 | 598.44 | 1 | 3239.97 | 1 | SO47399 | 2022-12-21 | 259.20 | 2992.18 | 647.99 | |||
| SO46940_16 | 6ADC-4363-B3 | PO18705126181 | 19 | 291 | 333 | 479 | 6 | 2022-11-25 | 939.59 | 23.49 | 2022-11-13 | 2 | 486.71 | 1 | 939.59 | 16 | SO46940 | 2022-11-20 | 75.17 | 973.41 | 469.79 | |||
| SO51818_13 | B8CE-4C91-A9 | PO9077115532 | 19 | 291 | 592 | 100 | 6 | 2023-11-25 | 1016.98 | 25.42 | 2023-11-13 | 3 | 308.22 | 1 | 1016.98 | 13 | SO51818 | 2023-11-20 | 81.36 | 924.65 | 338.99 | |||
| SO63177_14 | 87AD-4113-AD | PO1856115383 | 19 | 291 | 561 | 263 | 6 | 2024-05-27 | 5721.77 | 143.04 | 2024-05-15 | 4 | 1481.94 | 1 | 5721.77 | 14 | SO63177 | 2024-05-22 | 457.74 | 5927.75 | 1430.44 | |||
| SO45553_6 | 87C3-40D7-80 | PO1885177550 | 19 | 284 | 345 | 588 | 6 | 2022-06-25 | 16319.95 | 408.00 | 2022-06-13 | 8 | 1912.15 | 1 | 16319.95 | 6 | SO45553 | 2022-06-20 | 1305.60 | 15297.24 | 2039.99 | |||
| SO63267_2 | A573-4A2E-B5 | PO2262115390 | 19 | 291 | 480 | 629 | 6 | 2024-05-27 | 1.37 | 0.03 | 2024-05-15 | 1 | 0.86 | 1 | 1.37 | 2 | SO63267 | 2024-05-22 | 0.11 | 0.86 | 1.37 | |||
| SO51769_8 | 4AAC-4066-A6 | PO1595126190 | 19 | 284 | 440 | 426 | 6 | 2023-11-25 | 2576.70 | 64.42 | 2023-11-13 | 3 | 868.63 | 1 | 2576.70 | 8 | SO51769 | 2023-11-20 | 206.14 | 2605.90 | 858.90 | |||
| SO51843_12 | 2960-4D59-96 | PO2117116809 | 19 | 284 | 491 | 444 | 6 | 2023-11-25 | 64.79 | 1.62 | 2023-11-13 | 2 | 41.57 | 1 | 64.79 | 12 | SO51843 | 2023-11-20 | 5.18 | 83.14 | 32.39 | |||
| SO46953_32 | C650-4C32-BE | PO17603154442 | 19 | 284 | 286 | 12 | 6 | 2022-11-25 | 1287.57 | 32.19 | 2022-11-13 | 7 | 170.14 | 1 | 1287.57 | 32 | SO46953 | 2022-11-20 | 103.01 | 1191.00 | 183.94 |
Generated 2024-11-13 00:33:20.101 UTC