[ROOT] dt FactResellerSale WHERE DimSalesTerritoryId EQ '1' > < SKIP 3250 > < TAKE 31 >
31 items
FactResellerSaleId | CarrierTrackingNumber | CustomerPONumber | DimCurrencyId | DimEmployeeId | DimProductId | DimResellerId | DimSalesTerritoryId | DueDate | ExtendedAmount | Freight | OrderDate | OrderQuantity | ProductStandardCost | RevisionNumber | SalesAmount | SalesOrderLineNumber | SalesOrderNumber | ShipDate | TaxAmt | TotalProductCost | UnitPrice |
---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
SO63157_7 | 9E62-4577-80 | PO14500183845 | 100 | 282 | 524 | 650 | 1 | 2024-05-25 | 1109.01 | 27.73 | 2024-05-13 | 7 | 144.59 | 1 | 1109.01 | 7 | SO63157 | 2024-05-20 | 88.72 | 1012.16 | 158.43 |
SO63157_8 | 9E62-4577-80 | PO14500183845 | 100 | 282 | 511 | 650 | 1 | 2024-05-25 | 436.91 | 10.92 | 2024-05-13 | 2 | 199.38 | 1 | 436.91 | 8 | SO63157 | 2024-05-20 | 34.95 | 398.75 | 218.45 |
SO63157_9 | 9E62-4577-80 | PO14500183845 | 100 | 282 | 465 | 650 | 1 | 2024-05-25 | 102.86 | 2.57 | 2024-05-13 | 7 | 9.16 | 1 | 102.86 | 9 | SO63157 | 2024-05-20 | 8.23 | 64.12 | 14.69 |
SO63157_10 | 9E62-4577-80 | PO14500183845 | 100 | 282 | 490 | 650 | 1 | 2024-05-25 | 97.18 | 2.43 | 2024-05-13 | 3 | 41.57 | 1 | 97.18 | 10 | SO63157 | 2024-05-20 | 7.77 | 124.72 | 32.39 |
SO63157_11 | 9E62-4577-80 | PO14500183845 | 100 | 282 | 552 | 650 | 1 | 2024-05-25 | 164.68 | 4.12 | 2024-05-13 | 3 | 40.62 | 1 | 164.68 | 11 | SO63157 | 2024-05-20 | 13.17 | 121.86 | 54.89 |
SO63157_12 | 9E62-4577-80 | PO14500183845 | 100 | 282 | 556 | 650 | 1 | 2024-05-25 | 105.29 | 2.63 | 2024-05-13 | 1 | 77.92 | 1 | 105.29 | 12 | SO63157 | 2024-05-20 | 8.42 | 77.92 | 105.29 |
SO63157_13 | 9E62-4577-80 | PO14500183845 | 100 | 282 | 512 | 650 | 1 | 2024-05-25 | 436.91 | 10.92 | 2024-05-13 | 2 | 199.38 | 1 | 436.91 | 13 | SO63157 | 2024-05-20 | 34.95 | 398.75 | 218.45 |
SO63157_14 | 9E62-4577-80 | PO14500183845 | 100 | 282 | 484 | 650 | 1 | 2024-05-25 | 9.54 | 0.24 | 2024-05-13 | 2 | 2.97 | 1 | 9.54 | 14 | SO63157 | 2024-05-20 | 0.76 | 5.95 | 4.77 |
SO63157_15 | 9E62-4577-80 | PO14500183845 | 100 | 282 | 476 | 650 | 1 | 2024-05-25 | 251.96 | 6.30 | 2024-05-13 | 6 | 26.18 | 1 | 251.96 | 15 | SO63157 | 2024-05-20 | 20.16 | 157.06 | 41.99 |
SO63157_16 | 9E62-4577-80 | PO14500183845 | 100 | 282 | 357 | 650 | 1 | 2024-05-25 | 4175.98 | 104.40 | 2024-05-13 | 3 | 1265.62 | 1 | 4175.98 | 16 | SO63157 | 2024-05-20 | 334.08 | 3796.86 | 1391.99 |
SO63157_17 | 9E62-4577-80 | PO14500183845 | 100 | 282 | 491 | 650 | 1 | 2024-05-25 | 226.76 | 5.67 | 2024-05-13 | 7 | 41.57 | 1 | 226.76 | 17 | SO63157 | 2024-05-20 | 18.14 | 291.01 | 32.39 |
SO63157_18 | 9E62-4577-80 | PO14500183845 | 100 | 282 | 231 | 650 | 1 | 2024-05-25 | 239.95 | 6.00 | 2024-05-13 | 8 | 38.49 | 1 | 239.95 | 18 | SO63157 | 2024-05-20 | 19.20 | 307.94 | 29.99 |
SO63157_19 | 9E62-4577-80 | PO14500183845 | 100 | 282 | 558 | 650 | 1 | 2024-05-25 | 1214.97 | 30.37 | 2024-05-13 | 5 | 179.82 | 1 | 1214.97 | 19 | SO63157 | 2024-05-20 | 97.20 | 899.08 | 242.99 |
SO63157_20 | 9E62-4577-80 | PO14500183845 | 100 | 282 | 555 | 650 | 1 | 2024-05-25 | 383.40 | 9.59 | 2024-05-13 | 6 | 47.29 | 1 | 383.40 | 20 | SO63157 | 2024-05-20 | 30.67 | 283.72 | 63.90 |
SO49161_12 | 0377-44E6-AA | PO7627157444 | 100 | 293 | 337 | 433 | 1 | 2023-05-26 | 939.59 | 23.49 | 2023-05-14 | 2 | 486.71 | 1 | 939.59 | 12 | SO49161 | 2023-05-21 | 75.17 | 973.41 | 469.79 |
SO49161_13 | 0377-44E6-AA | PO7627157444 | 100 | 293 | 371 | 433 | 1 | 2023-05-26 | 2617.88 | 65.45 | 2023-05-14 | 2 | 1320.68 | 1 | 2617.88 | 13 | SO49161 | 2023-05-21 | 209.43 | 2641.37 | 1308.94 |
SO49161_14 | 0377-44E6-AA | PO7627157444 | 100 | 293 | 387 | 433 | 1 | 2023-05-26 | 1200.53 | 30.01 | 2023-05-14 | 2 | 605.65 | 1 | 1200.53 | 14 | SO49161 | 2023-05-21 | 96.04 | 1211.30 | 600.26 |
SO49161_15 | 0377-44E6-AA | PO7627157444 | 100 | 293 | 369 | 433 | 1 | 2023-05-26 | 4398.03 | 109.95 | 2023-05-14 | 3 | 1518.79 | 1 | 4398.03 | 15 | SO49161 | 2023-05-21 | 351.84 | 4556.36 | 1466.01 |
SO49161_16 | 0377-44E6-AA | PO7627157444 | 100 | 293 | 335 | 433 | 1 | 2023-05-26 | 1409.38 | 35.23 | 2023-05-14 | 3 | 486.71 | 1 | 1409.38 | 16 | SO49161 | 2023-05-21 | 112.75 | 1460.12 | 469.79 |
SO49161_17 | 0377-44E6-AA | PO7627157444 | 100 | 293 | 385 | 433 | 1 | 2023-05-26 | 600.26 | 15.01 | 2023-05-14 | 1 | 605.65 | 1 | 600.26 | 17 | SO49161 | 2023-05-21 | 48.02 | 605.65 | 600.26 |
SO49161_18 | 0377-44E6-AA | PO7627157444 | 100 | 293 | 383 | 433 | 1 | 2023-05-26 | 600.26 | 15.01 | 2023-05-14 | 1 | 605.65 | 1 | 600.26 | 18 | SO49161 | 2023-05-21 | 48.02 | 605.65 | 600.26 |
SO49161_19 | 0377-44E6-AA | PO7627157444 | 100 | 293 | 331 | 433 | 1 | 2023-05-26 | 2348.97 | 58.72 | 2023-05-14 | 5 | 486.71 | 1 | 2348.97 | 19 | SO49161 | 2023-05-21 | 187.92 | 2433.53 | 469.79 |
SO49161_20 | 0377-44E6-AA | PO7627157444 | 100 | 293 | 341 | 433 | 1 | 2023-05-26 | 469.79 | 11.74 | 2023-05-14 | 1 | 486.71 | 1 | 469.79 | 20 | SO49161 | 2023-05-21 | 37.58 | 486.71 | 469.79 |
SO49161_21 | 0377-44E6-AA | PO7627157444 | 100 | 293 | 321 | 433 | 1 | 2023-05-26 | 1409.38 | 35.23 | 2023-05-14 | 3 | 486.71 | 1 | 1409.38 | 21 | SO49161 | 2023-05-21 | 112.75 | 1460.12 | 469.79 |
SO49161_22 | 0377-44E6-AA | PO7627157444 | 100 | 293 | 379 | 433 | 1 | 2023-05-26 | 1308.94 | 32.72 | 2023-05-14 | 1 | 1320.68 | 1 | 1308.94 | 22 | SO49161 | 2023-05-21 | 104.72 | 1320.68 | 1308.94 |
SO49161_23 | 0377-44E6-AA | PO7627157444 | 100 | 293 | 370 | 433 | 1 | 2023-05-26 | 7330.05 | 183.25 | 2023-05-14 | 5 | 1518.79 | 1 | 7330.05 | 23 | SO49161 | 2023-05-21 | 586.40 | 7593.93 | 1466.01 |
SO49161_24 | 0377-44E6-AA | PO7627157444 | 100 | 293 | 389 | 433 | 1 | 2023-05-26 | 1200.53 | 30.01 | 2023-05-14 | 2 | 605.65 | 1 | 1200.53 | 24 | SO49161 | 2023-05-21 | 96.04 | 1211.30 | 600.26 |
SO49163_1 | DE2F-4D6A-99 | PO7917119932 | 100 | 287 | 469 | 401 | 1 | 2023-05-26 | 68.38 | 1.71 | 2023-05-14 | 3 | 15.67 | 1 | 68.38 | 1 | SO49163 | 2023-05-21 | 5.47 | 47.01 | 22.79 |
SO49163_2 | DE2F-4D6A-99 | PO7917119932 | 100 | 287 | 358 | 401 | 1 | 2023-05-26 | 3688.38 | 92.21 | 2023-05-14 | 3 | 1105.81 | 1 | 3688.38 | 2 | SO49163 | 2023-05-21 | 295.07 | 3317.43 | 1229.46 |
SO49163_3 | DE2F-4D6A-99 | PO7917119932 | 100 | 287 | 470 | 401 | 1 | 2023-05-26 | 182.35 | 4.56 | 2023-05-14 | 8 | 15.67 | 1 | 182.35 | 3 | SO49163 | 2023-05-21 | 14.59 | 125.37 | 22.79 |
SO49163_4 | DE2F-4D6A-99 | PO7917119932 | 100 | 287 | 468 | 401 | 1 | 2023-05-26 | 68.38 | 1.71 | 2023-05-14 | 3 | 15.67 | 1 | 68.38 | 4 | SO49163 | 2023-05-21 | 5.47 | 47.01 | 22.79 |
Generated 2024-11-10 21:06:29.373 UTC