What field is used to define a “customer contract” or a “time and material contract” in Astea v15.3 ?
We want to check and report which kind of contract is on a customer support or a service order.
Page 1 / 1
Piet,
Reviewing the SQL executed in the time and materials module, it seems that it is keying on the cconth.is_default field to determine if it is a Time and Materials contract.
There is only one in the DB copy we have from you for IMAC and it is pulled up with the following query criteria:
AND (cconth.is_default = 'Y')
When I look at the query for the Customer Contracts module, the criteria is looking for:
Where (cconth.is_default <> 'Y')
Reply
Enter your E-mail address. We'll send you an e-mail with instructions to reset your password.