[ROOT] dt FactResellerSale WHERE DimSalesTerritoryId EQ '1' > < SKIP 6095 > < TAKE 31 >
31 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 |
---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
SO65278_3 | 5822-4DF1-92 | PO5017152408 | 100 | 289 | 573 | 308 | 1 | 2024-06-23 | 1430.44 | 35.76 | 2024-06-11 | 1 | 1481.94 | 1 | 1430.44 | 3 | SO65278 | 2024-06-18 | 114.44 | 1481.94 | 1430.44 | |||
SO65278_4 | 5822-4DF1-92 | PO5017152408 | 100 | 289 | 503 | 308 | 1 | 2024-06-23 | 400.10 | 10.00 | 2024-06-11 | 2 | 199.85 | 1 | 400.10 | 4 | SO65278 | 2024-06-18 | 32.01 | 399.70 | 200.05 | |||
SO65278_5 | 5822-4DF1-92 | PO5017152408 | 100 | 289 | 492 | 308 | 1 | 2024-06-23 | 1204.69 | 30.12 | 2024-06-11 | 2 | 601.74 | 1 | 1204.69 | 5 | SO65278 | 2024-06-18 | 96.38 | 1203.49 | 602.35 | |||
SO65278_6 | 5822-4DF1-92 | PO5017152408 | 100 | 289 | 569 | 308 | 1 | 2024-06-23 | 890.82 | 22.27 | 2024-06-11 | 2 | 461.44 | 1 | 890.82 | 6 | SO65278 | 2024-06-18 | 71.27 | 922.89 | 445.41 | |||
SO55269_12 | C087-4A55-8D | PO899192335 | 100 | 289 | 545 | 290 | 1 | 2024-01-23 | 121.47 | 3.04 | 2024-01-11 | 5 | 17.98 | 1 | 121.47 | 12 | SO55269 | 2024-01-18 | 9.72 | 89.89 | 24.29 | |||
SO55269_13 | C087-4A55-8D | PO899192335 | 100 | 289 | 418 | 290 | 1 | 2024-01-23 | 1070.69 | 26.77 | 2024-01-11 | 3 | 360.94 | 1 | 1070.69 | 13 | SO55269 | 2024-01-18 | 85.66 | 1082.83 | 356.90 | |||
SO55269_14 | C087-4A55-8D | PO899192335 | 100 | 289 | 217 | 290 | 1 | 2024-01-23 | 41.99 | 1.05 | 2024-01-11 | 2 | 13.09 | 1 | 41.99 | 14 | SO55269 | 2024-01-18 | 3.36 | 26.17 | 20.99 | |||
SO55269_15 | C087-4A55-8D | PO899192335 | 100 | 289 | 471 | 290 | 1 | 2024-01-23 | 304.80 | 7.62 | 2024-01-11 | 8 | 23.75 | 1 | 304.80 | 15 | SO55269 | 2024-01-18 | 24.38 | 189.99 | 38.10 | |||
SO55269_16 | C087-4A55-8D | PO899192335 | 100 | 289 | 487 | 290 | 1 | 2024-01-23 | 164.97 | 4.12 | 2024-01-11 | 5 | 20.57 | 1 | 164.97 | 16 | SO55269 | 2024-01-18 | 13.20 | 102.83 | 32.99 | |||
SO55269_17 | C087-4A55-8D | PO899192335 | 100 | 289 | 606 | 290 | 1 | 2024-01-23 | 1943.96 | 48.60 | 2024-01-11 | 6 | 343.65 | 1 | 1943.96 | 17 | SO55269 | 2024-01-18 | 155.52 | 2061.90 | 323.99 | |||
SO55269_18 | C087-4A55-8D | PO899192335 | 100 | 289 | 434 | 290 | 1 | 2024-01-23 | 1427.59 | 35.69 | 2024-01-11 | 4 | 360.94 | 1 | 1427.59 | 18 | SO55269 | 2024-01-18 | 114.21 | 1443.77 | 356.90 | |||
SO55269_19 | C087-4A55-8D | PO899192335 | 100 | 289 | 477 | 290 | 1 | 2024-01-23 | 29.94 | 0.75 | 2024-01-11 | 10 | 1.87 | 1 | 29.94 | 19 | SO55269 | 2024-01-18 | 2.40 | 18.66 | 2.99 | |||
SO55269_20 | C087-4A55-8D | PO899192335 | 100 | 289 | 605 | 290 | 1 | 2024-01-23 | 2591.95 | 64.80 | 2024-01-11 | 8 | 343.65 | 1 | 2591.95 | 20 | SO55269 | 2024-01-18 | 207.36 | 2749.20 | 323.99 | |||
SO55269_21 | C087-4A55-8D | PO899192335 | 100 | 289 | 482 | 290 | 1 | 2024-01-23 | 16.18 | 0.40 | 2024-01-11 | 3 | 3.36 | 1 | 16.18 | 21 | SO55269 | 2024-01-18 | 1.29 | 10.09 | 5.39 | |||
SO55269_22 | C087-4A55-8D | PO899192335 | 100 | 289 | 463 | 290 | 1 | 2024-01-23 | 29.39 | 0.73 | 2024-01-11 | 2 | 9.16 | 1 | 29.39 | 22 | SO55269 | 2024-01-18 | 2.35 | 18.32 | 14.69 | |||
SO55269_23 | C087-4A55-8D | PO899192335 | 100 | 289 | 583 | 2 | 290 | 1 | 236.78 | 2024-01-23 | 11838.89 | 290.05 | 2024-01-11 | 12 | 1082.51 | 1 | 11602.11 | 23 | SO55269 | 2024-01-18 | 928.17 | 12990.12 | 986.57 | 0.02 |
SO55269_24 | C087-4A55-8D | PO899192335 | 100 | 289 | 546 | 290 | 1 | 2024-01-23 | 111.76 | 2.79 | 2024-01-11 | 3 | 27.57 | 1 | 111.76 | 24 | SO55269 | 2024-01-18 | 8.94 | 82.70 | 37.25 | |||
SO55269_25 | C087-4A55-8D | PO899192335 | 100 | 289 | 214 | 2 | 290 | 1 | 5.28 | 2024-01-23 | 263.82 | 6.46 | 2024-01-11 | 13 | 13.09 | 1 | 258.55 | 25 | SO55269 | 2024-01-18 | 20.68 | 170.12 | 20.29 | 0.02 |
SO55269_26 | C087-4A55-8D | PO899192335 | 100 | 289 | 580 | 290 | 1 | 2024-01-23 | 3061.78 | 76.54 | 2024-01-11 | 3 | 1082.51 | 1 | 3061.78 | 26 | SO55269 | 2024-01-18 | 244.94 | 3247.53 | 1020.59 | |||
SO55269_27 | C087-4A55-8D | PO899192335 | 100 | 289 | 584 | 290 | 1 | 2024-01-23 | 323.99 | 8.10 | 2024-01-11 | 1 | 343.65 | 1 | 323.99 | 27 | SO55269 | 2024-01-18 | 25.92 | 343.65 | 323.99 | |||
SO55269_28 | C087-4A55-8D | PO899192335 | 100 | 289 | 234 | 290 | 1 | 2024-01-23 | 239.95 | 6.00 | 2024-01-11 | 8 | 38.49 | 1 | 239.95 | 28 | SO55269 | 2024-01-18 | 19.20 | 307.94 | 29.99 | |||
SO55269_29 | C087-4A55-8D | PO899192335 | 100 | 289 | 225 | 290 | 1 | 2024-01-23 | 32.36 | 0.81 | 2024-01-11 | 6 | 6.92 | 1 | 32.36 | 29 | SO55269 | 2024-01-18 | 2.59 | 41.53 | 5.39 | |||
SO55269_30 | C087-4A55-8D | PO899192335 | 100 | 289 | 222 | 290 | 1 | 2024-01-23 | 209.94 | 5.25 | 2024-01-11 | 10 | 13.09 | 1 | 209.94 | 30 | SO55269 | 2024-01-18 | 16.80 | 130.86 | 20.99 | |||
SO55269_31 | C087-4A55-8D | PO899192335 | 100 | 289 | 472 | 290 | 1 | 2024-01-23 | 152.40 | 3.81 | 2024-01-11 | 4 | 23.75 | 1 | 152.40 | 31 | SO55269 | 2024-01-18 | 12.19 | 95.00 | 38.10 | |||
SO55269_32 | C087-4A55-8D | PO899192335 | 100 | 289 | 484 | 290 | 1 | 2024-01-23 | 28.62 | 0.72 | 2024-01-11 | 6 | 2.97 | 1 | 28.62 | 32 | SO55269 | 2024-01-18 | 2.29 | 17.84 | 4.77 | |||
SO55269_33 | C087-4A55-8D | PO899192335 | 100 | 289 | 467 | 290 | 1 | 2024-01-23 | 102.86 | 2.57 | 2024-01-11 | 7 | 9.16 | 1 | 102.86 | 33 | SO55269 | 2024-01-18 | 8.23 | 64.12 | 14.69 | |||
SO55269_34 | C087-4A55-8D | PO899192335 | 100 | 289 | 547 | 290 | 1 | 2024-01-23 | 242.97 | 6.07 | 2024-01-11 | 5 | 35.96 | 1 | 242.97 | 34 | SO55269 | 2024-01-18 | 19.44 | 179.80 | 48.59 | |||
SO55269_35 | C087-4A55-8D | PO899192335 | 100 | 289 | 237 | 290 | 1 | 2024-01-23 | 149.97 | 3.75 | 2024-01-11 | 5 | 38.49 | 1 | 149.97 | 35 | SO55269 | 2024-01-18 | 12.00 | 192.46 | 29.99 | |||
SO55269_36 | C087-4A55-8D | PO899192335 | 100 | 289 | 436 | 290 | 1 | 2024-01-23 | 1427.59 | 35.69 | 2024-01-11 | 4 | 360.94 | 1 | 1427.59 | 36 | SO55269 | 2024-01-18 | 114.21 | 1443.77 | 356.90 | |||
SO55269_37 | C087-4A55-8D | PO899192335 | 100 | 289 | 465 | 290 | 1 | 2024-01-23 | 132.25 | 3.31 | 2024-01-11 | 9 | 9.16 | 1 | 132.25 | 37 | SO55269 | 2024-01-18 | 10.58 | 82.43 | 14.69 | |||
SO55269_38 | C087-4A55-8D | PO899192335 | 100 | 289 | 480 | 290 | 1 | 2024-01-23 | 5.50 | 0.14 | 2024-01-11 | 4 | 0.86 | 1 | 5.50 | 38 | SO55269 | 2024-01-18 | 0.44 | 3.43 | 1.37 |
Generated 2024-11-10 21:22:14.731 UTC