[ROOT] dt FactResellerSale < WHERE DimSalesTerritoryId EQ '3' > < SKIP 1061 > < 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 |
---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
SO63194_18 | A6B4-4109-B0 | PO15370118285 | 100 | 281 | 512 | 381 | 3 | 2024-05-29 | 436.91 | 10.92 | 2024-05-17 | 2 | 199.38 | 1 | 436.91 | 18 | SO63194 | 2024-05-24 | 34.95 | 398.75 | 218.45 |
SO44758_11 | 28CF-4701-9C | PO14268184289 | 100 | 283 | 313 | 418 | 3 | 2022-03-29 | 2146.96 | 53.67 | 2022-03-17 | 1 | 2171.29 | 1 | 2146.96 | 11 | SO44758 | 2022-03-24 | 171.76 | 2171.29 | 2146.96 |
SO47962_18 | 3B2C-487D-99 | PO19923193438 | 100 | 281 | 470 | 18 | 3 | 2023-02-27 | 91.18 | 2.28 | 2023-02-15 | 4 | 15.67 | 1 | 91.18 | 18 | SO47962 | 2023-02-22 | 7.29 | 62.68 | 22.79 |
SO51691_38 | 8F72-4342-A4 | PO19923122474 | 100 | 283 | 591 | 18 | 3 | 2023-11-27 | 1016.98 | 25.42 | 2023-11-15 | 3 | 308.22 | 1 | 1016.98 | 38 | SO51691 | 2023-11-22 | 81.36 | 924.65 | 338.99 |
SO63194_19 | A6B4-4109-B0 | PO15370118285 | 100 | 281 | 511 | 381 | 3 | 2024-05-29 | 655.36 | 16.38 | 2024-05-17 | 3 | 199.38 | 1 | 655.36 | 19 | SO63194 | 2024-05-24 | 52.43 | 598.13 | 218.45 |
SO44758_12 | 28CF-4701-9C | PO14268184289 | 100 | 283 | 338 | 418 | 3 | 2022-03-29 | 1258.38 | 31.46 | 2022-03-17 | 3 | 413.15 | 1 | 1258.38 | 12 | SO44758 | 2022-03-24 | 100.67 | 1239.44 | 419.46 |
SO47962_19 | 3B2C-487D-99 | PO19923193438 | 100 | 281 | 393 | 18 | 3 | 2023-02-27 | 826.16 | 20.65 | 2023-02-15 | 6 | 101.89 | 1 | 826.16 | 19 | SO47962 | 2023-02-22 | 66.09 | 611.36 | 137.69 |
SO51709_1 | BA41-4B45-8D | PO16849170947 | 100 | 283 | 217 | 198 | 3 | 2023-11-27 | 20.99 | 0.52 | 2023-11-15 | 1 | 13.09 | 1 | 20.99 | 1 | SO51709 | 2023-11-22 | 1.68 | 13.09 | 20.99 |
SO63194_20 | A6B4-4109-B0 | PO15370118285 | 100 | 281 | 531 | 381 | 3 | 2024-05-29 | 149.87 | 3.75 | 2024-05-17 | 1 | 136.79 | 1 | 149.87 | 20 | SO63194 | 2024-05-24 | 11.99 | 136.79 | 149.87 |
SO44758_13 | 28CF-4701-9C | PO14268184289 | 100 | 283 | 318 | 418 | 3 | 2022-03-29 | 874.79 | 21.87 | 2022-03-17 | 1 | 884.71 | 1 | 874.79 | 13 | SO44758 | 2022-03-24 | 69.98 | 884.71 | 874.79 |
SO47962_20 | 3B2C-487D-99 | PO19923193438 | 100 | 281 | 305 | 18 | 3 | 2023-02-27 | 2944.58 | 73.61 | 2023-02-15 | 4 | 653.70 | 1 | 2944.58 | 20 | SO47962 | 2023-02-22 | 235.57 | 2614.79 | 736.15 |
SO51709_2 | BA41-4B45-8D | PO16849170947 | 100 | 283 | 472 | 198 | 3 | 2023-11-27 | 152.40 | 3.81 | 2023-11-15 | 4 | 23.75 | 1 | 152.40 | 2 | SO51709 | 2023-11-22 | 12.19 | 95.00 | 38.10 |
SO63194_21 | A6B4-4109-B0 | PO15370118285 | 100 | 281 | 558 | 381 | 3 | 2024-05-29 | 242.99 | 6.07 | 2024-05-17 | 1 | 179.82 | 1 | 242.99 | 21 | SO63194 | 2024-05-24 | 19.44 | 179.82 | 242.99 |
SO44758_14 | 28CF-4701-9C | PO14268184289 | 100 | 283 | 311 | 418 | 3 | 2022-03-29 | 2146.96 | 53.67 | 2022-03-17 | 1 | 2171.29 | 1 | 2146.96 | 14 | SO44758 | 2022-03-24 | 171.76 | 2171.29 | 2146.96 |
SO47962_21 | 3B2C-487D-99 | PO19923193438 | 100 | 281 | 356 | 18 | 3 | 2023-02-27 | 2485.70 | 62.14 | 2023-02-15 | 2 | 1117.86 | 1 | 2485.70 | 21 | SO47962 | 2023-02-22 | 198.86 | 2235.71 | 1242.85 |
SO51716_1 | 232B-4C4C-97 | PO15283150425 | 100 | 281 | 560 | 363 | 3 | 2023-11-27 | 1457.82 | 36.45 | 2023-11-15 | 2 | 755.15 | 1 | 1457.82 | 1 | SO51716 | 2023-11-22 | 116.63 | 1510.30 | 728.91 |
SO63194_22 | A6B4-4109-B0 | PO15370118285 | 100 | 281 | 357 | 381 | 3 | 2024-05-29 | 2783.99 | 69.60 | 2024-05-17 | 2 | 1265.62 | 1 | 2783.99 | 22 | SO63194 | 2024-05-24 | 222.72 | 2531.24 | 1391.99 |
SO44758_15 | 28CF-4701-9C | PO14268184289 | 100 | 283 | 285 | 418 | 3 | 2022-03-29 | 535.74 | 13.39 | 2022-03-17 | 3 | 176.20 | 1 | 535.74 | 15 | SO44758 | 2022-03-24 | 42.86 | 528.60 | 178.58 |
SO47962_22 | 3B2C-487D-99 | PO19923193438 | 100 | 281 | 421 | 18 | 3 | 2023-02-27 | 1177.97 | 29.45 | 2023-02-15 | 6 | 145.28 | 1 | 1177.97 | 22 | SO47962 | 2023-02-22 | 94.24 | 871.70 | 196.33 |
SO51716_2 | 232B-4C4C-97 | PO15283150425 | 100 | 281 | 499 | 363 | 3 | 2023-11-27 | 5421.11 | 135.53 | 2023-11-15 | 9 | 601.74 | 1 | 5421.11 | 2 | SO51716 | 2023-11-22 | 433.69 | 5415.69 | 602.35 |
SO63194_23 | A6B4-4109-B0 | PO15370118285 | 100 | 281 | 552 | 381 | 3 | 2024-05-29 | 274.47 | 6.86 | 2024-05-17 | 5 | 40.62 | 1 | 274.47 | 23 | SO63194 | 2024-05-24 | 21.96 | 203.11 | 54.89 |
SO44758_16 | 28CF-4701-9C | PO14268184289 | 100 | 283 | 324 | 418 | 3 | 2022-03-29 | 419.46 | 10.49 | 2022-03-17 | 1 | 413.15 | 1 | 419.46 | 16 | SO44758 | 2022-03-24 | 33.56 | 413.15 | 419.46 |
SO47962_23 | 3B2C-487D-99 | PO19923193438 | 100 | 281 | 360 | 18 | 3 | 2023-02-27 | 3688.38 | 92.21 | 2023-02-15 | 3 | 1105.81 | 1 | 3688.38 | 23 | SO47962 | 2023-02-22 | 295.07 | 3317.43 | 1229.46 |
SO51716_3 | 232B-4C4C-97 | PO15283150425 | 100 | 281 | 507 | 363 | 3 | 2023-11-27 | 200.05 | 5.00 | 2023-11-15 | 1 | 199.85 | 1 | 200.05 | 3 | SO51716 | 2023-11-22 | 16.00 | 199.85 | 200.05 |
SO63194_24 | A6B4-4109-B0 | PO15370118285 | 100 | 281 | 363 | 381 | 3 | 2024-05-29 | 1376.99 | 34.42 | 2024-05-17 | 1 | 1251.98 | 1 | 1376.99 | 24 | SO63194 | 2024-05-24 | 110.16 | 1251.98 | 1376.99 |
SO44758_17 | 28CF-4701-9C | PO14268184289 | 100 | 283 | 326 | 418 | 3 | 2022-03-29 | 838.92 | 20.97 | 2022-03-17 | 2 | 413.15 | 1 | 838.92 | 17 | SO44758 | 2022-03-24 | 67.11 | 826.29 | 419.46 |
SO47962_24 | 3B2C-487D-99 | PO19923193438 | 100 | 281 | 362 | 18 | 3 | 2023-02-27 | 1229.46 | 30.74 | 2023-02-15 | 1 | 1105.81 | 1 | 1229.46 | 24 | SO47962 | 2023-02-22 | 98.36 | 1105.81 | 1229.46 |
SO51716_4 | 232B-4C4C-97 | PO15283150425 | 100 | 281 | 576 | 363 | 3 | 2023-11-27 | 10013.09 | 250.33 | 2023-11-15 | 7 | 1481.94 | 1 | 10013.09 | 4 | SO51716 | 2023-11-22 | 801.05 | 10373.57 | 1430.44 |
SO63194_25 | A6B4-4109-B0 | PO15370118285 | 100 | 281 | 398 | 381 | 3 | 2024-05-29 | 53.45 | 1.34 | 2024-05-17 | 2 | 19.78 | 1 | 53.45 | 25 | SO63194 | 2024-05-24 | 4.28 | 39.55 | 26.72 |
SO44758_18 | 28CF-4701-9C | PO14268184289 | 100 | 283 | 328 | 418 | 3 | 2022-03-29 | 1677.84 | 41.95 | 2022-03-17 | 4 | 413.15 | 1 | 1677.84 | 18 | SO44758 | 2022-03-24 | 134.23 | 1652.59 | 419.46 |
Generated 2024-11-14 18:02:12.580 UTC