| Description |
[~satya.sahoo] ,
Currently, we use the vyuCTContractDetailView to load the available contract for the vendor which has lots fields that is not necessary in our function. Same sql view is use to retrieve contract item. On that view, we created extjs store in our module to use for dropdown.
Can you create us a lightweight sql view and extjs store that we could use in AP?
Here's the requirement for the contract header store.
Following fields is needed.
1. intContractHeaderId - primary key of tblCTContractHeader
2. dblQtyContract - total quantiy
3. strContractNumber
4. ysnComplete - this is the overall contract status, if one of the detail is not yet complete, this should be false
5. intEntityId - the vendor contract
6. dblCost - in prepayment, we could prepay the whole contract or without selecting an item, in this case, we will use the minimum cash price used on the details.
7. ysnUnlimitedContract
For the contract details, let's have a call on skype to discuss this matter if another view would possible.
|