[ROOT] dt FactResellerSale WHERE DimSalesTerritoryId EQ '1' > SHUFFLE SKIP 2000 < SKIP 532 > < 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 |
---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
SO51148_30 | 1D20-490E-98 | PO6612158387 | 100 | 286 | 496 | 110 | 1 | 2023-09-02 | 1204.69 | 30.12 | 2023-08-21 | 2 | 601.74 | 1 | 1204.69 | 30 | SO51148 | 2023-08-28 | 96.38 | 1203.49 | 602.35 | |||
SO51128_3 | 5A2E-45E2-A5 | PO2929192490 | 100 | 289 | 475 | 380 | 1 | 2023-09-02 | 83.99 | 2.10 | 2023-08-21 | 2 | 26.18 | 1 | 83.99 | 3 | SO51128 | 2023-08-28 | 6.72 | 52.35 | 41.99 | |||
SO43917_8 | 9EDA-4CDB-A8 | PO8816199739 | 100 | 289 | 315 | 218 | 1 | 2021-10-03 | 4373.97 | 109.35 | 2021-09-21 | 5 | 884.71 | 1 | 4373.97 | 8 | SO43917 | 2021-09-28 | 349.92 | 4423.54 | 874.79 | |||
SO57046_22 | 52CC-460F-B3 | PO14500161818 | 100 | 282 | 471 | 2 | 650 | 1 | 8.84 | 2024-01-03 | 441.96 | 10.83 | 2023-12-22 | 12 | 23.75 | 1 | 433.12 | 22 | SO57046 | 2023-12-29 | 34.65 | 284.99 | 36.83 | 0.02 |
SO59010_30 | 2350-42CD-B1 | PO6815132533 | 100 | 293 | 599 | 109 | 1 | 2024-02-02 | 971.98 | 24.30 | 2024-01-21 | 3 | 294.58 | 1 | 971.98 | 30 | SO59010 | 2024-01-28 | 77.76 | 883.74 | 323.99 | |||
SO59066_13 | 9FAA-410F-AB | PO9309141643 | 100 | 293 | 603 | 55 | 1 | 2024-02-02 | 72.89 | 1.82 | 2024-01-21 | 1 | 53.94 | 1 | 72.89 | 13 | SO59066 | 2024-01-28 | 5.83 | 53.94 | 72.89 | |||
SO46647_15 | FA5F-4878-9F | PO2552157860 | 100 | 286 | 461 | 506 | 1 | 2022-09-02 | 161.98 | 4.05 | 2022-08-21 | 3 | 37.12 | 1 | 161.98 | 15 | SO46647 | 2022-08-28 | 12.96 | 111.36 | 53.99 | |||
SO51145_3 | BBD2-4A22-8C | PO7105118870 | 100 | 293 | 434 | 668 | 1 | 2023-09-02 | 1070.69 | 26.77 | 2023-08-21 | 3 | 360.94 | 1 | 1070.69 | 3 | SO51145 | 2023-08-28 | 85.66 | 1082.83 | 356.90 | |||
SO49844_1 | 84A1-4FF2-A9 | PO899181442 | 100 | 289 | 343 | 290 | 1 | 2023-06-03 | 3288.56 | 82.21 | 2023-05-22 | 7 | 486.71 | 1 | 3288.56 | 1 | SO49844 | 2023-05-29 | 263.08 | 3406.95 | 469.79 | |||
SO53469_15 | 9CB4-402C-94 | PO17139199092 | 100 | 293 | 404 | 644 | 1 | 2023-11-03 | 26.72 | 0.67 | 2023-10-22 | 1 | 19.78 | 1 | 26.72 | 15 | SO53469 | 2023-10-29 | 2.14 | 19.78 | 26.72 | |||
SO63148_13 | 00FA-42B1-88 | PO16675153915 | 100 | 293 | 603 | 361 | 1 | 2024-04-04 | 145.79 | 3.64 | 2024-03-23 | 2 | 53.94 | 1 | 145.79 | 13 | SO63148 | 2024-03-30 | 11.66 | 107.88 | 72.89 | |||
SO63149_2 | 7EF2-4565-86 | PO16414166653 | 100 | 289 | 532 | 236 | 1 | 2024-04-04 | 299.75 | 7.49 | 2024-03-23 | 2 | 136.79 | 1 | 299.75 | 2 | SO63149 | 2024-03-30 | 23.98 | 273.57 | 149.87 | |||
SO50218_19 | B8E9-4FE2-8B | PO14442144367 | 100 | 293 | 460 | 127 | 1 | 2023-07-03 | 269.97 | 6.75 | 2023-06-21 | 5 | 37.12 | 1 | 269.97 | 19 | SO50218 | 2023-06-28 | 21.60 | 185.60 | 53.99 | |||
SO46974_41 | BEE6-4EC8-8E | PO14442112586 | 100 | 286 | 421 | 127 | 1 | 2022-10-03 | 785.32 | 19.63 | 2022-09-21 | 4 | 145.28 | 1 | 785.32 | 41 | SO46974 | 2022-09-28 | 62.83 | 581.13 | 196.33 | |||
SO53514_23 | 8580-40F8-81 | PO10411179199 | 100 | 289 | 465 | 182 | 1 | 2023-11-03 | 58.78 | 1.47 | 2023-10-22 | 4 | 9.16 | 1 | 58.78 | 23 | SO53514 | 2023-10-29 | 4.70 | 36.64 | 14.69 | |||
SO45564_9 | DD65-42A2-80 | PO5220129554 | 100 | 282 | 350 | 169 | 1 | 2022-05-03 | 18224.95 | 455.62 | 2022-04-21 | 9 | 1898.09 | 1 | 18224.95 | 9 | SO45564 | 2022-04-28 | 1458.00 | 17082.85 | 2024.99 | |||
SO57109_4 | C4FF-4694-96 | PO14529190471 | 100 | 293 | 474 | 289 | 1 | 2024-01-03 | 125.98 | 3.15 | 2023-12-22 | 3 | 26.18 | 1 | 125.98 | 4 | SO57109 | 2023-12-29 | 10.08 | 78.53 | 41.99 | |||
SO53514_17 | 8580-40F8-81 | PO10411179199 | 100 | 289 | 574 | 182 | 1 | 2023-11-03 | 4291.33 | 107.28 | 2023-10-22 | 3 | 1481.94 | 1 | 4291.33 | 17 | SO53514 | 2023-10-29 | 343.31 | 4445.81 | 1430.44 | |||
SO46958_1 | 7F0E-4A0E-A7 | PO16878165735 | 100 | 272 | 362 | 115 | 1 | 2022-10-03 | 2458.92 | 61.47 | 2022-09-21 | 2 | 1105.81 | 1 | 2458.92 | 1 | SO46958 | 2022-09-28 | 196.71 | 2211.62 | 1229.46 | |||
SO51145_5 | BBD2-4A22-8C | PO7105118870 | 100 | 293 | 546 | 668 | 1 | 2023-09-02 | 149.02 | 3.73 | 2023-08-21 | 4 | 27.57 | 1 | 149.02 | 5 | SO51145 | 2023-08-28 | 11.92 | 110.27 | 37.25 | |||
SO51712_38 | 910D-4560-A7 | PO16675134576 | 100 | 293 | 501 | 361 | 1 | 2023-10-03 | 145.75 | 3.64 | 2023-09-21 | 2 | 53.93 | 1 | 145.75 | 38 | SO51712 | 2023-09-28 | 11.66 | 107.86 | 72.88 | |||
SO53514_35 | 8580-40F8-81 | PO10411179199 | 100 | 289 | 234 | 182 | 1 | 2023-11-03 | 299.94 | 7.50 | 2023-10-22 | 10 | 38.49 | 1 | 299.94 | 35 | SO53514 | 2023-10-29 | 24.00 | 384.92 | 29.99 | |||
SO53452_35 | B555-4FD7-8B | PO870113712 | 100 | 286 | 564 | 14 | 621 | 1 | 190.73 | 2023-11-03 | 953.63 | 19.07 | 2023-10-22 | 1 | 1481.94 | 1 | 762.90 | 35 | SO53452 | 2023-10-29 | 61.03 | 1481.94 | 953.63 | 0.20 |
SO44540_2 | 4773-44B5-9B | PO2900111031 | 100 | 286 | 300 | 469 | 1 | 2022-01-03 | 809.76 | 20.24 | 2021-12-22 | 1 | 699.09 | 1 | 809.76 | 2 | SO44540 | 2021-12-29 | 64.78 | 699.09 | 809.76 | |||
SO51726_1 | 9BC5-4281-AF | PO14587157005 | 100 | 293 | 495 | 199 | 1 | 2023-10-03 | 1204.69 | 30.12 | 2023-09-21 | 2 | 601.74 | 1 | 1204.69 | 1 | SO51726 | 2023-09-28 | 96.38 | 1203.49 | 602.35 | |||
SO48347_38 | 40D2-4DF5-93 | PO841112057 | 100 | 286 | 354 | 254 | 1 | 2023-02-02 | 3728.56 | 93.21 | 2023-01-21 | 3 | 1117.86 | 1 | 3728.56 | 38 | SO48347 | 2023-01-28 | 298.28 | 3353.57 | 1242.85 | |||
SO47054_13 | E4B1-4C58-AE | PO7627150376 | 100 | 286 | 422 | 433 | 1 | 2022-10-03 | 202.62 | 5.07 | 2022-09-21 | 3 | 49.98 | 1 | 202.62 | 13 | SO47054 | 2022-09-28 | 16.21 | 149.94 | 67.54 | |||
SO51838_14 | 8AB1-478C-86 | PO4727199391 | 100 | 293 | 605 | 343 | 1 | 2023-10-03 | 323.99 | 8.10 | 2023-09-21 | 1 | 343.65 | 1 | 323.99 | 14 | SO51838 | 2023-09-28 | 25.92 | 343.65 | 323.99 | |||
SO69422_11 | BF3A-4F54-82 | PO14500139823 | 100 | 282 | 531 | 650 | 1 | 2024-07-03 | 599.50 | 14.99 | 2024-06-21 | 4 | 136.79 | 1 | 599.50 | 11 | SO69422 | 2024-06-28 | 47.96 | 547.14 | 149.87 | |||
SO44788_10 | 4CD8-41D6-AE | PO5220181334 | 100 | 282 | 296 | 169 | 1 | 2022-02-02 | 1429.41 | 35.74 | 2022-01-21 | 2 | 617.03 | 1 | 1429.41 | 10 | SO44788 | 2022-01-28 | 114.35 | 1234.06 | 714.70 | |||
SO47057_3 | 0D4D-45B2-91 | PO7917141916 | 100 | 287 | 419 | 401 | 1 | 2022-10-03 | 210.59 | 5.26 | 2022-09-21 | 4 | 38.96 | 1 | 210.59 | 3 | SO47057 | 2022-09-28 | 16.85 | 155.84 | 52.65 | |||
SO45064_1 | 2DCA-4F00-94 | PO2552154948 | 100 | 289 | 350 | 506 | 1 | 2022-03-05 | 4049.99 | 101.25 | 2022-02-21 | 2 | 1898.09 | 1 | 4049.99 | 1 | SO45064 | 2022-02-28 | 324.00 | 3796.19 | 2024.99 | |||
SO44501_11 | 4971-4FC0-A3 | PO16646128920 | 100 | 286 | 314 | 1 | 1 | 2022-01-03 | 2146.96 | 53.67 | 2021-12-22 | 1 | 2171.29 | 1 | 2146.96 | 11 | SO44501 | 2021-12-29 | 171.76 | 2171.29 | 2146.96 | |||
SO63157_31 | 9E62-4577-80 | PO14500183845 | 100 | 282 | 298 | 650 | 1 | 2024-04-04 | 1619.52 | 40.49 | 2024-03-23 | 2 | 739.04 | 1 | 1619.52 | 31 | SO63157 | 2024-03-30 | 129.56 | 1478.08 | 809.76 | |||
SO57026_44 | CD5A-4300-81 | PO16675118038 | 100 | 293 | 523 | 361 | 1 | 2024-01-03 | 63.17 | 1.58 | 2023-12-22 | 2 | 23.37 | 1 | 63.17 | 44 | SO57026 | 2023-12-29 | 5.05 | 46.74 | 31.58 | |||
SO59019_7 | 5F5A-465D-A8 | PO7192182554 | 100 | 289 | 475 | 20 | 1 | 2024-02-02 | 125.98 | 3.15 | 2024-01-21 | 3 | 26.18 | 1 | 125.98 | 7 | SO59019 | 2024-01-28 | 10.08 | 78.53 | 41.99 | |||
SO57026_10 | CD5A-4300-81 | PO16675118038 | 100 | 293 | 552 | 361 | 1 | 2024-01-03 | 109.79 | 2.74 | 2023-12-22 | 2 | 40.62 | 1 | 109.79 | 10 | SO57026 | 2023-12-29 | 8.78 | 81.24 | 54.89 | |||
SO57045_8 | 4D3C-4309-BE | PO14587121888 | 100 | 293 | 562 | 199 | 1 | 2024-01-03 | 1430.44 | 35.76 | 2023-12-22 | 1 | 1481.94 | 1 | 1430.44 | 8 | SO57045 | 2023-12-29 | 114.44 | 1481.94 | 1430.44 | |||
SO57160_12 | 86C3-4E21-9D | PO4727197868 | 100 | 293 | 546 | 343 | 1 | 2024-01-03 | 74.51 | 1.86 | 2023-12-22 | 2 | 27.57 | 1 | 74.51 | 12 | SO57160 | 2023-12-29 | 5.96 | 55.14 | 37.25 | |||
SO51123_4 | E412-45DF-AE | PO899150137 | 100 | 289 | 418 | 290 | 1 | 2023-09-02 | 1070.69 | 26.77 | 2023-08-21 | 3 | 360.94 | 1 | 1070.69 | 4 | SO51123 | 2023-08-28 | 85.66 | 1082.83 | 356.90 | |||
SO49092_4 | 72CE-4E29-82 | PO14442163644 | 100 | 293 | 396 | 127 | 1 | 2023-04-05 | 74.84 | 1.87 | 2023-03-24 | 1 | 55.38 | 1 | 74.84 | 4 | SO49092 | 2023-03-31 | 5.99 | 55.38 | 74.84 | |||
SO50209_28 | D138-4E7C-86 | PO15573136083 | 100 | 293 | 399 | 487 | 1 | 2023-07-03 | 168.87 | 4.22 | 2023-06-21 | 5 | 24.99 | 1 | 168.87 | 28 | SO50209 | 2023-06-28 | 13.51 | 124.97 | 33.77 | |||
SO65200_20 | C4A9-49C4-AE | PO841148607 | 100 | 286 | 474 | 2 | 254 | 1 | 10.55 | 2024-05-03 | 527.72 | 12.93 | 2024-04-21 | 13 | 26.18 | 1 | 517.17 | 20 | SO65200 | 2024-04-28 | 41.37 | 340.29 | 40.59 | 0.02 |
SO57136_31 | 0031-4C10-84 | PO7627163680 | 100 | 272 | 434 | 433 | 1 | 2024-01-03 | 1784.49 | 44.61 | 2023-12-22 | 5 | 360.94 | 1 | 1784.49 | 31 | SO57136 | 2023-12-29 | 142.76 | 1804.71 | 356.90 | |||
SO53514_3 | 8580-40F8-81 | PO10411179199 | 100 | 289 | 577 | 182 | 1 | 2023-11-03 | 728.91 | 18.22 | 2023-10-22 | 1 | 755.15 | 1 | 728.91 | 3 | SO53514 | 2023-10-29 | 58.31 | 755.15 | 728.91 | |||
SO69408_14 | 8DF5-4377-9D | PO16414161428 | 100 | 289 | 363 | 236 | 1 | 2024-07-03 | 2753.99 | 68.85 | 2024-06-21 | 2 | 1251.98 | 1 | 2753.99 | 14 | SO69408 | 2024-06-28 | 220.32 | 2503.96 | 1376.99 | |||
SO65170_2 | F14C-4F1E-84 | PO17487113942 | 100 | 293 | 583 | 692 | 1 | 2024-05-03 | 1020.59 | 25.51 | 2024-04-21 | 1 | 1082.51 | 1 | 1020.59 | 2 | SO65170 | 2024-04-28 | 81.65 | 1082.51 | 1020.59 | |||
SO58963_45 | 6ADC-4485-8C | PO841129336 | 100 | 286 | 514 | 254 | 1 | 2024-02-02 | 127.80 | 3.20 | 2024-01-21 | 2 | 47.29 | 1 | 127.80 | 45 | SO58963 | 2024-01-28 | 10.22 | 94.57 | 63.90 | |||
SO45804_6 | A72B-452A-BA | PO2552178124 | 100 | 289 | 344 | 506 | 1 | 2022-06-03 | 4079.99 | 102.00 | 2022-05-22 | 2 | 1912.15 | 1 | 4079.99 | 6 | SO45804 | 2022-05-29 | 326.40 | 3824.31 | 2039.99 | |||
SO53457_38 | B3F3-4A07-9B | PO19169151555 | 100 | 289 | 593 | 272 | 1 | 2023-11-03 | 338.99 | 8.47 | 2023-10-22 | 1 | 308.22 | 1 | 338.99 | 38 | SO53457 | 2023-10-29 | 27.12 | 308.22 | 338.99 | |||
SO49136_11 | 3492-4F41-97 | PO4727180151 | 100 | 293 | 368 | 343 | 1 | 2023-04-05 | 4398.03 | 109.95 | 2023-03-24 | 3 | 1518.79 | 1 | 4398.03 | 11 | SO49136 | 2023-03-31 | 351.84 | 4556.36 | 1466.01 | |||
SO71893_16 | 9AE1-416A-8F | PO7482196160 | 100 | 293 | 496 | 163 | 1 | 2024-08-03 | 1204.69 | 30.12 | 2024-07-22 | 2 | 601.74 | 1 | 1204.69 | 16 | SO71893 | 2024-07-29 | 96.38 | 1203.49 | 602.35 | |||
SO45064_9 | 2DCA-4F00-94 | PO2552154948 | 100 | 289 | 346 | 506 | 1 | 2022-03-05 | 8159.98 | 204.00 | 2022-02-21 | 4 | 1912.15 | 1 | 8159.98 | 9 | SO45064 | 2022-02-28 | 652.80 | 7648.62 | 2039.99 | |||
SO58917_7 | 0658-4A38-93 | PO17487197562 | 100 | 293 | 477 | 692 | 1 | 2024-02-02 | 2.99 | 0.07 | 2024-01-21 | 1 | 1.87 | 1 | 2.99 | 7 | SO58917 | 2024-01-28 | 0.24 | 1.87 | 2.99 | |||
SO49826_23 | 2EBD-4312-9C | PO16588178669 | 100 | 289 | 366 | 146 | 1 | 2023-06-03 | 3239.97 | 81.00 | 2023-05-22 | 5 | 598.44 | 1 | 3239.97 | 23 | SO49826 | 2023-05-29 | 259.20 | 2992.18 | 647.99 | |||
SO48328_14 | 5992-4AF8-B1 | PO13543152596 | 100 | 287 | 358 | 293 | 1 | 2023-02-02 | 1229.46 | 30.74 | 2023-01-21 | 1 | 1105.81 | 1 | 1229.46 | 14 | SO48328 | 2023-01-28 | 98.36 | 1105.81 | 1229.46 | |||
SO63268_3 | 0CC5-4FCB-BD | PO5742162516 | 100 | 293 | 357 | 541 | 1 | 2024-04-04 | 2783.99 | 69.60 | 2024-03-23 | 2 | 1265.62 | 1 | 2783.99 | 3 | SO63268 | 2024-03-30 | 222.72 | 2531.24 | 1391.99 | |||
SO46356_23 | 30BA-40DA-B4 | PO783139385 | 100 | 286 | 275 | 91 | 1 | 2022-08-03 | 356.90 | 8.92 | 2022-07-22 | 1 | 352.14 | 1 | 356.90 | 23 | SO46356 | 2022-07-29 | 28.55 | 352.14 | 356.90 | |||
SO47999_2 | DF06-4F6A-9D | PO14500121568 | 100 | 282 | 397 | 650 | 1 | 2023-01-03 | 24.29 | 0.61 | 2022-12-22 | 1 | 17.98 | 1 | 24.29 | 2 | SO47999 | 2022-12-29 | 1.94 | 17.98 | 24.29 | |||
SO65200_18 | C4A9-49C4-AE | PO841148607 | 100 | 286 | 552 | 254 | 1 | 2024-05-03 | 109.79 | 2.74 | 2024-04-21 | 2 | 40.62 | 1 | 109.79 | 18 | SO65200 | 2024-04-28 | 8.78 | 81.24 | 54.89 | |||
SO47033_25 | 2797-46ED-BB | PO4727113716 | 100 | 286 | 213 | 343 | 1 | 2022-10-03 | 60.56 | 1.51 | 2022-09-21 | 3 | 13.88 | 1 | 60.56 | 25 | SO47033 | 2022-09-28 | 4.84 | 41.63 | 20.19 | |||
SO51838_13 | 8AB1-478C-86 | PO4727199391 | 100 | 293 | 604 | 343 | 1 | 2023-10-03 | 647.99 | 16.20 | 2023-09-21 | 2 | 343.65 | 1 | 647.99 | 13 | SO51838 | 2023-09-28 | 51.84 | 687.30 | 323.99 |
Generated 2024-09-20 03:32:18.858 UTC