Re: [Emerald] Report

Gary Wilkinson ( (no email) )
Wed, 31 Mar 1999 08:23:38 +1000

Sorry I must not be making myself clear. I understand the account type
decide as to the charge type but I need to know if a customer after he is
entered into the database is going to get charged that fee. I need to
distinguish between a customer that is going to get the charge as apposed to
it being waived or as a renewal.

Regards Gary

-----Original Message-----
From: Dale E. Reed Jr. <daler@iea-software.com>
To: emerald@iea-software.com <emerald@iea-software.com>
Date: Wednesday, 31 March 1999 8:14
Subject: Re: [Emerald] Report

>Gary Wilkinson wrote:
>>
>> Yes a setup fee, we only need to detect as to wether the account is going
to
>> be charged a setup fee, is there a flag set somewhere?
>
>The flag is where the AccountTypes.ChargeTypeID is NULL or not.
>
>> -----Original Message-----
>> From: Dale E. Reed Jr. <daler@iea-software.com>
>> To: emerald@iea-software.com <emerald@iea-software.com>
>> Date: Wednesday, 31 March 1999 8:01
>> Subject: Re: [Emerald] Report
>>
>> >> Gary Wilkinson wrote:
>> >>
>> >> I am currently writing a report and I need to find the information in
>> >> the tables that determines if the user is going to be charged a
>> >> connection fee.
>> >>
>> >> Could someone point me in the correct direction.
>> >
>> >Do you mean a setup fee? You need to see if the ChargeTypeID
>> >is NULL or null for their account type. If its not NULL, then
>> >find that ID from the ChargeTypes table and thats the setup
>> >charge. Like:
>> >
>> >Select SubAccounts.Login, AccountTypes.AccountType, AccountTypes.Cost,
>> >ChargeTypes.Amount
>> >From SubAccounts, AccountTypes, ChargeTypes
>> >Where SubAccounts.AccountType = AcountTypes.AccountType
>> > and AccountType.ChargeTypeID *= ChargeTypes.ChargeTypeID
>> >
>> >
>> >--
>> >
>> >Dale E. Reed Jr. Emerald and RadiusNT
>> >__________________________________________
>> >IEA Software, Inc. www.iea-software.com
>> >
>> >For more information about this list, including removal,
>> >please see http://www.iea-software.com/maillist.html
>>
>> For more information about this list, including removal,
>> please see http://www.iea-software.com/maillist.html
>
>
>--
>
>Dale E. Reed Jr. Emerald and RadiusNT
>__________________________________________
>IEA Software, Inc. www.iea-software.com
>
>For more information about this list, including removal,
>please see http://www.iea-software.com/maillist.html

For more information about this list, including removal,
please see http://www.iea-software.com/maillist.html