[ROOT] dt FactResellerSale < WHERE DimEmployeeId EQ '287' > SKIP 2500 SHUFFLE < SKIP 1985 > < TAKE 62 >
60 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 |
---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
SO46624_3 | 12A0-4CA7-93 | PO13659199342 | 100 | 287 | 399 | 437 | 4 | 2022-09-03 | 101.32 | 2.53 | 2022-08-22 | 3 | 24.99 | 1 | 101.32 | 3 | SO46624 | 2022-08-29 | 8.11 | 74.98 | 33.77 | |||
SO45798_8 | 3FA4-4459-BD | PO10817199969 | 100 | 287 | 328 | 203 | 4 | 2022-06-04 | 419.46 | 10.49 | 2022-05-23 | 1 | 413.15 | 1 | 419.46 | 8 | SO45798 | 2022-05-30 | 33.56 | 413.15 | 419.46 | |||
SO47057_16 | 0D4D-45B2-91 | PO7917141916 | 100 | 287 | 410 | 401 | 1 | 2022-10-04 | 109.34 | 2.73 | 2022-09-22 | 3 | 26.97 | 1 | 109.34 | 16 | SO47057 | 2022-09-29 | 8.75 | 80.91 | 36.45 | |||
SO45788_2 | 70AB-422F-8E | PO14413199158 | 100 | 287 | 319 | 383 | 4 | 2022-06-04 | 1749.59 | 43.74 | 2022-05-23 | 2 | 884.71 | 1 | 1749.59 | 2 | SO45788 | 2022-05-30 | 139.97 | 1769.42 | 874.79 | |||
SO50743_3 | C1F5-4D36-9F | PO4640120853 | 100 | 287 | 420 | 648 | 4 | 2023-08-04 | 283.23 | 7.08 | 2023-07-23 | 2 | 104.80 | 1 | 283.23 | 3 | SO50743 | 2023-07-30 | 22.66 | 209.59 | 141.62 | |||
SO48775_7 | E56E-4C8C-AA | PO10817145980 | 100 | 287 | 381 | 203 | 4 | 2023-03-06 | 1200.53 | 30.01 | 2023-02-22 | 2 | 605.65 | 1 | 1200.53 | 7 | SO48775 | 2023-03-01 | 96.04 | 1211.30 | 600.26 | |||
SO49832_22 | 3280-41FF-A3 | PO13659150841 | 100 | 287 | 354 | 437 | 4 | 2023-06-04 | 4971.41 | 124.29 | 2023-05-23 | 4 | 1117.86 | 1 | 4971.41 | 22 | SO49832 | 2023-05-30 | 397.71 | 4471.42 | 1242.85 | |||
SO69509_3 | 3683-45BF-B7 | PO4611111760 | 100 | 287 | 578 | 131 | 4 | 2024-07-04 | 728.91 | 18.22 | 2024-06-22 | 1 | 755.15 | 1 | 728.91 | 3 | SO69509 | 2024-06-29 | 58.31 | 755.15 | 728.91 | |||
SO69411_10 | E0BB-44D1-83 | PO15921144493 | 100 | 287 | 606 | 77 | 4 | 2024-07-04 | 323.99 | 8.10 | 2024-06-22 | 1 | 343.65 | 1 | 323.99 | 10 | SO69411 | 2024-06-29 | 25.92 | 343.65 | 323.99 | |||
SO46348_14 | CF4C-437D-97 | PO13543132672 | 100 | 287 | 349 | 7 | 293 | 1 | 885.93 | 2022-08-04 | 2531.24 | 41.13 | 2022-07-23 | 3 | 1898.09 | 1 | 1645.31 | 14 | SO46348 | 2022-07-30 | 131.62 | 5694.28 | 843.75 | 0.35 |
SO50672_13 | 1BE9-437C-8A | PO16472110144 | 100 | 287 | 457 | 239 | 4 | 2023-08-04 | 359.95 | 9.00 | 2023-07-23 | 8 | 30.93 | 1 | 359.95 | 13 | SO50672 | 2023-07-30 | 28.80 | 247.47 | 44.99 | |||
SO69509_4 | 3683-45BF-B7 | PO4611111760 | 100 | 287 | 572 | 131 | 4 | 2024-07-04 | 1336.23 | 33.41 | 2024-06-22 | 3 | 461.44 | 1 | 1336.23 | 4 | SO69509 | 2024-06-29 | 106.90 | 1384.33 | 445.41 | |||
SO67274_27 | EAF2-43E4-AB | PO13659172775 | 100 | 287 | 525 | 437 | 4 | 2024-06-04 | 158.43 | 3.96 | 2024-05-23 | 1 | 144.59 | 1 | 158.43 | 27 | SO67274 | 2024-05-30 | 12.67 | 144.59 | 158.43 | |||
SO50221_27 | EAD6-4841-B9 | PO13572116484 | 100 | 287 | 271 | 527 | 3 | 2023-07-04 | 809.33 | 20.23 | 2023-06-22 | 4 | 187.16 | 1 | 809.33 | 27 | SO50221 | 2023-06-29 | 64.75 | 748.63 | 202.33 | |||
SO45799_11 | 4DE8-4B9B-A1 | PO10730195041 | 100 | 287 | 316 | 491 | 4 | 2022-06-04 | 1749.59 | 43.74 | 2022-05-23 | 2 | 884.71 | 1 | 1749.59 | 11 | SO45799 | 2022-05-30 | 139.97 | 1769.42 | 874.79 | |||
SO46624_9 | 12A0-4CA7-93 | PO13659199342 | 100 | 287 | 409 | 437 | 4 | 2022-09-03 | 837.02 | 20.93 | 2022-08-22 | 4 | 185.82 | 1 | 837.02 | 9 | SO46624 | 2022-08-29 | 66.96 | 743.28 | 209.26 | |||
SO71818_19 | 2FCA-4131-BD | PO12470139718 | 100 | 287 | 493 | 672 | 1 | 2024-08-04 | 200.05 | 5.00 | 2024-07-23 | 1 | 199.85 | 1 | 200.05 | 19 | SO71818 | 2024-07-30 | 16.00 | 199.85 | 200.05 | |||
SO49506_2 | A1B2-45C6-A2 | PO13717198252 | 100 | 287 | 381 | 473 | 4 | 2023-05-04 | 600.26 | 15.01 | 2023-04-22 | 1 | 605.65 | 1 | 600.26 | 2 | SO49506 | 2023-04-29 | 48.02 | 605.65 | 600.26 | |||
SO47352_32 | 9DF5-4A88-9C | PO19633111392 | 100 | 287 | 233 | 149 | 3 | 2022-11-04 | 57.68 | 1.44 | 2022-10-23 | 2 | 29.08 | 1 | 57.68 | 32 | SO47352 | 2022-10-30 | 4.61 | 58.16 | 28.84 | |||
SO47374_20 | C6BE-481A-A0 | PO16182131046 | 100 | 287 | 352 | 23 | 4 | 2022-11-04 | 2485.70 | 62.14 | 2022-10-23 | 2 | 1117.86 | 1 | 2485.70 | 20 | SO47374 | 2022-10-30 | 198.86 | 2235.71 | 1242.85 | |||
SO71818_4 | 2FCA-4131-BD | PO12470139718 | 100 | 287 | 494 | 672 | 1 | 2024-08-04 | 1204.69 | 30.12 | 2024-07-23 | 2 | 601.74 | 1 | 1204.69 | 4 | SO71818 | 2024-07-30 | 96.38 | 1203.49 | 602.35 | |||
SO71787_5 | 94A7-4406-B3 | PO18038111279 | 100 | 287 | 567 | 509 | 4 | 2024-08-04 | 890.82 | 22.27 | 2024-07-23 | 2 | 461.44 | 1 | 890.82 | 5 | SO71787 | 2024-07-30 | 71.27 | 922.89 | 445.41 | |||
SO49832_4 | 3280-41FF-A3 | PO13659150841 | 100 | 287 | 428 | 437 | 4 | 2023-06-04 | 209.26 | 5.23 | 2023-05-23 | 1 | 185.82 | 1 | 209.26 | 4 | SO49832 | 2023-05-30 | 16.74 | 185.82 | 209.26 | |||
SO47057_18 | 0D4D-45B2-91 | PO7917141916 | 100 | 287 | 221 | 401 | 1 | 2022-10-04 | 20.19 | 0.50 | 2022-09-22 | 1 | 13.88 | 1 | 20.19 | 18 | SO47057 | 2022-09-29 | 1.61 | 13.88 | 20.19 | |||
SO45813_3 | 36A5-446C-96 | PO7859120230 | 100 | 287 | 316 | 221 | 4 | 2022-06-04 | 2624.38 | 65.61 | 2022-05-23 | 3 | 884.71 | 1 | 2624.38 | 3 | SO45813 | 2022-05-30 | 209.95 | 2654.12 | 874.79 | |||
SO49841_38 | 35A1-40DC-99 | PO10817181706 | 100 | 287 | 333 | 203 | 4 | 2023-06-04 | 469.79 | 11.74 | 2023-05-23 | 1 | 486.71 | 1 | 469.79 | 38 | SO49841 | 2023-05-30 | 37.58 | 486.71 | 469.79 | |||
SO50672_43 | 1BE9-437C-8A | PO16472110144 | 100 | 287 | 265 | 239 | 4 | 2023-08-04 | 607.00 | 15.17 | 2023-07-23 | 3 | 187.16 | 1 | 607.00 | 43 | SO50672 | 2023-07-30 | 48.56 | 561.47 | 202.33 | |||
SO49841_40 | 35A1-40DC-99 | PO10817181706 | 100 | 287 | 329 | 203 | 4 | 2023-06-04 | 1879.18 | 46.98 | 2023-05-23 | 4 | 486.71 | 1 | 1879.18 | 40 | SO49841 | 2023-05-30 | 150.33 | 1946.83 | 469.79 | |||
SO45813_22 | 36A5-446C-96 | PO7859120230 | 100 | 287 | 322 | 221 | 4 | 2022-06-04 | 1677.84 | 41.95 | 2022-05-23 | 4 | 413.15 | 1 | 1677.84 | 22 | SO45813 | 2022-05-30 | 134.23 | 1652.59 | 419.46 | |||
SO48767_12 | 08F3-41F2-A9 | PO13659113323 | 100 | 287 | 367 | 437 | 4 | 2023-03-06 | 1943.98 | 48.60 | 2023-02-22 | 3 | 598.44 | 1 | 1943.98 | 12 | SO48767 | 2023-03-01 | 155.52 | 1795.31 | 647.99 | |||
SO45798_12 | 3FA4-4459-BD | PO10817199969 | 100 | 287 | 338 | 203 | 4 | 2022-06-04 | 419.46 | 10.49 | 2022-05-23 | 1 | 413.15 | 1 | 419.46 | 12 | SO45798 | 2022-05-30 | 33.56 | 413.15 | 419.46 | |||
SO46965_5 | C9A7-4125-95 | PO15921113146 | 100 | 287 | 458 | 77 | 4 | 2022-10-04 | 269.96 | 6.75 | 2022-09-22 | 6 | 30.93 | 1 | 269.96 | 5 | SO46965 | 2022-09-29 | 21.60 | 185.60 | 44.99 | |||
SO47018_51 | E622-43B1-98 | PO2523197473 | 100 | 287 | 414 | 167 | 4 | 2022-10-04 | 894.19 | 22.35 | 2022-09-22 | 6 | 110.28 | 1 | 894.19 | 51 | SO47018 | 2022-09-29 | 71.53 | 661.70 | 149.03 | |||
SO49534_5 | 2910-41C4-A3 | PO5510112224 | 100 | 287 | 325 | 5 | 4 | 2023-05-04 | 939.59 | 23.49 | 2023-04-22 | 2 | 486.71 | 1 | 939.59 | 5 | SO49534 | 2023-04-29 | 75.17 | 973.41 | 469.79 | |||
SO69527_5 | A6FE-49DA-BE | PO4843110434 | 100 | 287 | 287 | 257 | 4 | 2024-07-04 | 607.00 | 15.17 | 2024-06-22 | 3 | 204.63 | 1 | 607.00 | 5 | SO69527 | 2024-06-29 | 48.56 | 613.88 | 202.33 | |||
SO47374_14 | C6BE-481A-A0 | PO16182131046 | 100 | 287 | 216 | 23 | 4 | 2022-11-04 | 20.19 | 0.50 | 2022-10-23 | 1 | 13.88 | 1 | 20.19 | 14 | SO47374 | 2022-10-30 | 1.61 | 13.88 | 20.19 | |||
SO67305_32 | CBB5-42BF-9E | PO16298111473 | 100 | 287 | 222 | 599 | 4 | 2024-06-04 | 209.94 | 5.25 | 2024-05-23 | 10 | 13.09 | 1 | 209.94 | 32 | SO67305 | 2024-05-30 | 16.80 | 130.86 | 20.99 | |||
SO71896_22 | A37A-4B16-B0 | PO4640135042 | 100 | 287 | 402 | 648 | 4 | 2024-08-04 | 288.65 | 7.22 | 2024-07-23 | 4 | 53.40 | 1 | 288.65 | 22 | SO71896 | 2024-07-30 | 23.09 | 213.60 | 72.16 | |||
SO49527_5 | BFD0-4AA2-AF | PO4640129987 | 100 | 287 | 352 | 648 | 4 | 2023-05-04 | 8699.96 | 217.50 | 2023-04-22 | 7 | 1117.86 | 1 | 8699.96 | 5 | SO49527 | 2023-04-29 | 696.00 | 7824.99 | 1242.85 | |||
SO49116_8 | 5844-47DC-B2 | PO13572169665 | 100 | 287 | 325 | 527 | 3 | 2023-04-06 | 1879.18 | 46.98 | 2023-03-25 | 4 | 486.71 | 1 | 1879.18 | 8 | SO49116 | 2023-04-01 | 150.33 | 1946.83 | 469.79 | |||
SO46634_2 | 8EF9-46A8-AA | PO10730130024 | 100 | 287 | 327 | 9 | 491 | 4 | 70.47 | 2022-09-03 | 234.90 | 4.11 | 2022-08-22 | 1 | 486.71 | 1 | 164.43 | 2 | SO46634 | 2022-08-29 | 13.15 | 486.71 | 234.90 | 0.30 |
SO71787_6 | 94A7-4406-B3 | PO18038111279 | 100 | 287 | 572 | 509 | 4 | 2024-08-04 | 445.41 | 11.14 | 2024-07-23 | 1 | 461.44 | 1 | 445.41 | 6 | SO71787 | 2024-07-30 | 35.63 | 461.44 | 445.41 | |||
SO71859_5 | 326E-4365-A3 | PO16182112142 | 100 | 287 | 491 | 23 | 4 | 2024-08-04 | 64.79 | 1.62 | 2024-07-23 | 2 | 41.57 | 1 | 64.79 | 5 | SO71859 | 2024-07-30 | 5.18 | 83.14 | 32.39 | |||
SO50298_16 | 2A9C-4236-85 | PO4843196377 | 100 | 287 | 329 | 257 | 4 | 2023-07-04 | 1409.38 | 35.23 | 2023-06-22 | 3 | 486.71 | 1 | 1409.38 | 16 | SO50298 | 2023-06-29 | 112.75 | 1460.12 | 469.79 | |||
SO50672_42 | 1BE9-437C-8A | PO16472110144 | 100 | 287 | 453 | 239 | 4 | 2023-08-04 | 323.95 | 8.10 | 2023-07-23 | 9 | 24.75 | 1 | 323.95 | 42 | SO50672 | 2023-07-30 | 25.92 | 222.71 | 35.99 | |||
SO69466_30 | 8B97-4CC6-8A | PO2523169620 | 100 | 287 | 580 | 167 | 4 | 2024-07-04 | 3061.78 | 76.54 | 2024-06-22 | 3 | 1082.51 | 1 | 3061.78 | 30 | SO69466 | 2024-06-29 | 244.94 | 3247.53 | 1020.59 | |||
SO71890_10 | D31D-413E-BB | PO5510169156 | 100 | 287 | 580 | 5 | 4 | 2024-08-04 | 4082.38 | 102.06 | 2024-07-23 | 4 | 1082.51 | 1 | 4082.38 | 10 | SO71890 | 2024-07-30 | 326.59 | 4330.04 | 1020.59 | |||
SO47427_4 | 61AA-44CA-99 | PO4640137176 | 100 | 287 | 365 | 648 | 4 | 2022-11-04 | 1295.99 | 32.40 | 2022-10-23 | 2 | 598.44 | 1 | 1295.99 | 4 | SO47427 | 2022-10-30 | 103.68 | 1196.87 | 647.99 | |||
SO50678_13 | CAED-407A-BA | PO13543174640 | 100 | 287 | 308 | 293 | 1 | 2023-08-04 | 744.27 | 18.61 | 2023-07-23 | 1 | 660.91 | 1 | 744.27 | 13 | SO50678 | 2023-07-30 | 59.54 | 660.91 | 744.27 | |||
SO71812_6 | 3257-4AE0-A8 | PO13543115747 | 100 | 287 | 517 | 293 | 1 | 2024-08-04 | 126.34 | 3.16 | 2024-07-23 | 4 | 23.37 | 1 | 126.34 | 6 | SO71812 | 2024-07-30 | 10.11 | 93.49 | 31.58 | |||
SO45798_24 | 3FA4-4459-BD | PO10817199969 | 100 | 287 | 311 | 203 | 4 | 2022-06-04 | 4293.92 | 107.35 | 2022-05-23 | 2 | 2171.29 | 1 | 4293.92 | 24 | SO45798 | 2022-05-30 | 343.51 | 4342.59 | 2146.96 | |||
SO46076_10 | E898-4203-B0 | PO2523131751 | 100 | 287 | 315 | 167 | 4 | 2022-07-04 | 874.79 | 21.87 | 2022-06-22 | 1 | 884.71 | 1 | 874.79 | 10 | SO46076 | 2022-06-29 | 69.98 | 884.71 | 874.79 | |||
SO46965_12 | C9A7-4125-95 | PO15921113146 | 100 | 287 | 422 | 77 | 4 | 2022-10-04 | 202.62 | 5.07 | 2022-09-22 | 3 | 49.98 | 1 | 202.62 | 12 | SO46965 | 2022-09-29 | 16.21 | 149.94 | 67.54 | |||
SO50661_15 | CE6E-45C9-A1 | PO19633184648 | 100 | 287 | 352 | 149 | 3 | 2023-08-04 | 2485.70 | 62.14 | 2023-07-23 | 2 | 1117.86 | 1 | 2485.70 | 15 | SO50661 | 2023-07-30 | 198.86 | 2235.71 | 1242.85 | |||
SO50721_2 | E836-480F-AA | PO16182137721 | 100 | 287 | 358 | 23 | 4 | 2023-08-04 | 4917.84 | 122.95 | 2023-07-23 | 4 | 1105.81 | 1 | 4917.84 | 2 | SO50721 | 2023-07-30 | 393.43 | 4423.24 | 1229.46 | |||
SO69509_1 | 3683-45BF-B7 | PO4611111760 | 100 | 287 | 563 | 131 | 4 | 2024-07-04 | 1430.44 | 35.76 | 2024-06-22 | 1 | 1481.94 | 1 | 1430.44 | 1 | SO69509 | 2024-06-29 | 114.44 | 1481.94 | 1430.44 | |||
SO47387_4 | 4FFC-4663-AC | PO13543169662 | 100 | 287 | 420 | 293 | 1 | 2022-11-04 | 566.46 | 14.16 | 2022-10-23 | 4 | 104.80 | 1 | 566.46 | 4 | SO47387 | 2022-10-30 | 45.32 | 419.18 | 141.62 | |||
SO69466_2 | 8B97-4CC6-8A | PO2523169620 | 100 | 287 | 217 | 167 | 4 | 2024-07-04 | 188.95 | 4.72 | 2024-06-22 | 9 | 13.09 | 1 | 188.95 | 2 | SO69466 | 2024-06-29 | 15.12 | 117.78 | 20.99 | |||
SO47369_45 | B6B6-442B-8B | PO16472118462 | 100 | 287 | 456 | 239 | 4 | 2022-11-04 | 359.95 | 9.00 | 2022-10-23 | 8 | 30.93 | 1 | 359.95 | 45 | SO47369 | 2022-10-30 | 28.80 | 247.47 | 44.99 | |||
SO47369_40 | B6B6-442B-8B | PO16472118462 | 100 | 287 | 343 | 239 | 4 | 2022-11-04 | 2818.76 | 70.47 | 2022-10-23 | 6 | 486.71 | 1 | 2818.76 | 40 | SO47369 | 2022-10-30 | 225.50 | 2920.24 | 469.79 |
Generated 2024-09-21 07:41:58.510 UTC