[ROOT] dt FactResellerSale < WHERE DimSalesTerritoryId EQ ALL < SKIP 4785 > < TAKE 30 >
30 items
FactResellerSaleId | CarrierTrackingNumber | CustomerPONumber | DimCurrencyId | DimEmployeeId | DimProductId | DimResellerId | DimSalesTerritoryId | DueDate | ExtendedAmount | Freight | OrderDate | OrderQuantity | ProductStandardCost | RevisionNumber | SalesAmount | SalesOrderLineNumber | SalesOrderNumber | ShipDate | TaxAmt | TotalProductCost | UnitPrice |
---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
SO51148_35 | 1D20-490E-98 | PO6612158387 | 100 | 286 | 225 | 110 | 1 | 2023-10-23 | 5.39 | 0.13 | 2023-10-11 | 1 | 6.92 | 1 | 5.39 | 35 | SO51148 | 2023-10-18 | 0.43 | 6.92 | 5.39 |
SO59031_13 | 15F5-4B32-AC | PO5017142991 | 100 | 289 | 506 | 308 | 1 | 2024-03-24 | 600.16 | 15.00 | 2024-03-12 | 3 | 199.85 | 1 | 600.16 | 13 | SO59031 | 2024-03-19 | 48.01 | 599.56 | 200.05 |
SO43873_26 | 494C-48D2-BD | PO12499138177 | 100 | 282 | 262 | 78 | 4 | 2021-11-23 | 367.88 | 9.20 | 2021-11-11 | 2 | 181.49 | 1 | 367.88 | 26 | SO43873 | 2021-11-18 | 29.43 | 362.97 | 183.94 |
SO47724_14 | FDA2-4CD7-92 | PO8787160870 | 100 | 282 | 233 | 523 | 3 | 2023-01-23 | 288.40 | 7.21 | 2023-01-11 | 10 | 29.08 | 1 | 288.40 | 14 | SO47724 | 2023-01-18 | 23.07 | 290.81 | 28.84 |
SO51148_36 | 1D20-490E-98 | PO6612158387 | 100 | 286 | 514 | 110 | 1 | 2023-10-23 | 127.80 | 3.20 | 2023-10-11 | 2 | 47.29 | 1 | 127.80 | 36 | SO51148 | 2023-10-18 | 10.22 | 94.57 | 63.90 |
SO59031_14 | 15F5-4B32-AC | PO5017142991 | 100 | 289 | 554 | 308 | 1 | 2024-03-24 | 54.94 | 1.37 | 2024-03-12 | 1 | 40.66 | 1 | 54.94 | 14 | SO59031 | 2024-03-19 | 4.40 | 40.66 | 54.94 |
SO43873_27 | 494C-48D2-BD | PO12499138177 | 100 | 282 | 314 | 78 | 4 | 2021-11-23 | 4293.92 | 107.35 | 2021-11-11 | 2 | 2171.29 | 1 | 4293.92 | 27 | SO43873 | 2021-11-18 | 343.51 | 4342.59 | 2146.96 |
SO47724_15 | FDA2-4CD7-92 | PO8787160870 | 100 | 282 | 224 | 523 | 3 | 2023-01-23 | 31.12 | 0.78 | 2023-01-11 | 6 | 5.23 | 1 | 31.12 | 15 | SO47724 | 2023-01-18 | 2.49 | 31.38 | 5.19 |
SO51148_37 | 1D20-490E-98 | PO6612158387 | 100 | 286 | 499 | 110 | 1 | 2023-10-23 | 1807.04 | 45.18 | 2023-10-11 | 3 | 601.74 | 1 | 1807.04 | 37 | SO51148 | 2023-10-18 | 144.56 | 1805.23 | 602.35 |
SO59031_15 | 15F5-4B32-AC | PO5017142991 | 100 | 289 | 492 | 308 | 1 | 2024-03-24 | 3011.73 | 75.29 | 2024-03-12 | 5 | 601.74 | 1 | 3011.73 | 15 | SO59031 | 2024-03-19 | 240.94 | 3008.72 | 602.35 |
SO43873_28 | 494C-48D2-BD | PO12499138177 | 100 | 282 | 275 | 78 | 4 | 2021-11-23 | 2141.39 | 53.53 | 2021-11-11 | 6 | 352.14 | 1 | 2141.39 | 28 | SO43873 | 2021-11-18 | 171.31 | 2112.84 | 356.90 |
SO47724_16 | FDA2-4CD7-92 | PO8787160870 | 100 | 282 | 462 | 523 | 3 | 2023-01-23 | 56.52 | 1.41 | 2023-01-11 | 4 | 9.71 | 1 | 56.52 | 16 | SO47724 | 2023-01-18 | 4.52 | 38.85 | 14.13 |
SO51148_38 | 1D20-490E-98 | PO6612158387 | 100 | 286 | 575 | 110 | 1 | 2023-10-23 | 1430.44 | 35.76 | 2023-10-11 | 1 | 1481.94 | 1 | 1430.44 | 38 | SO51148 | 2023-10-18 | 114.44 | 1481.94 | 1430.44 |
SO59031_16 | 15F5-4B32-AC | PO5017142991 | 100 | 289 | 500 | 308 | 1 | 2024-03-24 | 4818.77 | 120.47 | 2024-03-12 | 8 | 601.74 | 1 | 4818.77 | 16 | SO59031 | 2024-03-19 | 385.50 | 4813.95 | 602.35 |
SO43874_1 | 190B-4F56-9E | PO12122162917 | 100 | 283 | 328 | 22 | 3 | 2021-11-23 | 419.46 | 10.49 | 2021-11-11 | 1 | 413.15 | 1 | 419.46 | 1 | SO43874 | 2021-11-18 | 33.56 | 413.15 | 419.46 |
SO47724_17 | FDA2-4CD7-92 | PO8787160870 | 100 | 282 | 445 | 523 | 3 | 2023-01-23 | 35.99 | 0.90 | 2023-01-11 | 1 | 24.75 | 1 | 35.99 | 17 | SO47724 | 2023-01-18 | 2.88 | 24.75 | 35.99 |
SO51148_39 | 1D20-490E-98 | PO6612158387 | 100 | 286 | 603 | 110 | 1 | 2023-10-23 | 218.68 | 5.47 | 2023-10-11 | 3 | 53.94 | 1 | 218.68 | 39 | SO51148 | 2023-10-18 | 17.49 | 161.82 | 72.89 |
SO59031_17 | 15F5-4B32-AC | PO5017142991 | 100 | 289 | 498 | 308 | 1 | 2024-03-24 | 1204.69 | 30.12 | 2024-03-12 | 2 | 601.74 | 1 | 1204.69 | 17 | SO59031 | 2024-03-19 | 96.38 | 1203.49 | 602.35 |
SO43875_1 | CE1F-4E31-89 | PO12586178184 | 100 | 285 | 351 | 278 | 5 | 2021-11-23 | 12149.96 | 303.75 | 2021-11-11 | 6 | 1898.09 | 1 | 12149.96 | 1 | SO43875 | 2021-11-18 | 972.00 | 11388.57 | 2024.99 |
SO47724_18 | FDA2-4CD7-92 | PO8787160870 | 100 | 282 | 433 | 523 | 3 | 2023-01-23 | 324.45 | 8.11 | 2023-01-11 | 1 | 300.12 | 1 | 324.45 | 18 | SO47724 | 2023-01-18 | 25.96 | 300.12 | 324.45 |
SO51148_40 | 1D20-490E-98 | PO6612158387 | 100 | 286 | 555 | 110 | 1 | 2023-10-23 | 511.20 | 12.78 | 2023-10-11 | 8 | 47.29 | 1 | 511.20 | 40 | SO51148 | 2023-10-18 | 40.90 | 378.29 | 63.90 |
SO59032_1 | DB21-4653-88 | PO4756173322 | 100 | 283 | 583 | 126 | 2 | 2024-03-24 | 1020.59 | 25.51 | 2024-03-12 | 1 | 1082.51 | 1 | 1020.59 | 1 | SO59032 | 2024-03-19 | 81.65 | 1082.51 | 1020.59 |
SO43875_2 | CE1F-4E31-89 | PO12586178184 | 100 | 285 | 304 | 278 | 5 | 2021-11-23 | 1429.41 | 35.74 | 2021-11-11 | 2 | 617.03 | 1 | 1429.41 | 2 | SO43875 | 2021-11-18 | 114.35 | 1234.06 | 714.70 |
SO47724_19 | FDA2-4CD7-92 | PO8787160870 | 100 | 282 | 286 | 523 | 3 | 2023-01-23 | 551.81 | 13.80 | 2023-01-11 | 3 | 170.14 | 1 | 551.81 | 19 | SO47724 | 2023-01-18 | 44.15 | 510.43 | 183.94 |
SO51148_41 | 1D20-490E-98 | PO6612158387 | 100 | 286 | 492 | 110 | 1 | 2023-10-23 | 1204.69 | 30.12 | 2023-10-11 | 2 | 601.74 | 1 | 1204.69 | 41 | SO51148 | 2023-10-18 | 96.38 | 1203.49 | 602.35 |
SO59032_2 | DB21-4653-88 | PO4756173322 | 100 | 283 | 481 | 126 | 2 | 2024-03-24 | 16.18 | 0.40 | 2024-03-12 | 3 | 3.36 | 1 | 16.18 | 2 | SO59032 | 2024-03-19 | 1.29 | 10.09 | 5.39 |
SO43875_3 | CE1F-4E31-89 | PO12586178184 | 100 | 285 | 292 | 278 | 5 | 2021-11-23 | 818.70 | 20.47 | 2021-11-11 | 1 | 706.81 | 1 | 818.70 | 3 | SO43875 | 2021-11-18 | 65.50 | 706.81 | 818.70 |
SO47724_20 | FDA2-4CD7-92 | PO8787160870 | 100 | 282 | 263 | 523 | 3 | 2023-01-23 | 202.33 | 5.06 | 2023-01-11 | 1 | 187.16 | 1 | 202.33 | 20 | SO47724 | 2023-01-18 | 16.19 | 187.16 | 202.33 |
SO51148_42 | 1D20-490E-98 | PO6612158387 | 100 | 286 | 579 | 110 | 1 | 2023-10-23 | 1457.82 | 36.45 | 2023-10-11 | 2 | 755.15 | 1 | 1457.82 | 42 | SO51148 | 2023-10-18 | 116.63 | 1510.30 | 728.91 |
SO59032_3 | DB21-4653-88 | PO4756173322 | 100 | 283 | 482 | 126 | 2 | 2024-03-24 | 43.15 | 1.08 | 2024-03-12 | 8 | 3.36 | 1 | 43.15 | 3 | SO59032 | 2024-03-19 | 3.45 | 26.90 | 5.39 |
Generated 2024-11-11 00:37:35.198 UTC